cat_dbitem.php
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Fri, Nov 21, 4:15 AM

cat_dbitem.php
View Options

	<?php

	class kCatDBItem extends kDBItem {

	/**
	* Category path, needed for import
	*
	* @var Array
	*/
	var $CategoryPath = Array();

	/**
	* Use automatic filename generation
	*
	* @var bool
	*/
	var $useFilenames = true;

	/**
	* Use pending editing abilities during item (delegated by permissions)
	*
	* @var bool
	*/
	var $usePendingEditing = false;

	function Clear()
	{
	parent::Clear();
	$this->CategoryPath = Array();
	}

	/**
	* Set's prefix and special
	*
	* @param string $prefix
	* @param string $special
	* @access public
	*/
	function Init($prefix, $special, $event_params = null)
	{
	parent::Init($prefix, $special, $event_params);
	$this->usePendingEditing = $this->Application->getUnitOption($this->Prefix, 'UsePendingEditing');
	}

	function Create($force_id=false, $system_create=false)
	{
	if (!$this->Validate()) return false;

	$this->SetDBField('ResourceId', $this->Application->NextResourceId());
	$this->SetDBField('Modified', adodb_mktime() );
	$this->UpdateFormattersSubFields(array('Modified'));

	if ($this->mode != 't' && !$this->Application->IsAdmin()) {
	$this->SetDBField('CreatedById', $this->Application->RecallVar('user_id'));
	}

	if ($this->useFilenames) {
	$this->checkFilename();
	$this->generateFilename();
	}

	$ret = parent::Create();
	if ($ret) {
	$primary_category = $this->GetDBField('CategoryId') > 0 ? $this->GetDBField('CategoryId') : $this->Application->GetVar('m_cat_id');
	$fields_hash = Array(
	'CategoryId' => $primary_category,
	'ItemResourceId' => $this->GetField('ResourceId'),
	'PrimaryCat' => 1,
	'ItemPrefix' => $this->Prefix,
	'Filename' => $this->GetDBField('Filename'),
	);
	$this->Conn->doInsert($fields_hash, $this->CategoryItemsTable());
	}
	return $ret;
	}

	function Update($id=null, $system_update=false)
	{
	$this->VirtualFields['ResourceId'] = Array();
	$this->SetDBField('Modified', adodb_mktime() );
	$this->UpdateFormattersSubFields(array('Modified'));
	$this->SetDBField('ModifiedById', $this->Application->RecallVar('user_id'));

	if ($this->useFilenames) {
	$this->checkFilename();
	$this->generateFilename();
	}

	$ret = parent::Update($id, $system_update);

	if ($ret) {
	$filename = $this->useFilenames ? $this->GetDBField('Filename') : '';
	$sql = 'UPDATE '.$this->CategoryItemsTable().'
	SET Filename = '.$this->Conn->qstr($filename).'
	WHERE ItemResourceId = '.$this->GetDBField('ResourceId');
	$this->Conn->Query($sql);
	}

	unset($this->VirtualFields['ResourceId']);
	return $ret;
	}

	/**
	* Returns CategoryItems table based on current item mode (temp/live)
	*
	* @return string
	*/
	function CategoryItemsTable()
	{
	$table = TABLE_PREFIX.'CategoryItems';
	if ($this->Application->IsTempTable($this->TableName)) {
	$table = $this->Application->GetTempName($table, 'prefix:'.$this->Prefix);
	}

	return $table;
	}


	function checkFilename()
	{
	if( !$this->GetDBField('AutomaticFilename') )
	{
	$filename = $this->GetDBField('Filename');
	$this->SetDBField('Filename', $this->stripDisallowed($filename) );
	}
	}

	function Copy($cat_id=null)
	{
	if (!isset($cat_id)) $cat_id = $this->Application->GetVar('m_cat_id');
	$this->NameCopy($cat_id);
	return $this->Create($cat_id);
	}

	function NameCopy($master=null, $foreign_key=null)
	{
	$title_field = $this->Application->getUnitOption($this->Prefix, 'TitleField');
	if (!$title_field) return;

	$new_name = $this->GetDBField($title_field);
	$cat_id = $this->Application->GetVar('m_cat_id');
	$original_checked = false;
	do {
	if ( preg_match('/Copy ([0-9]) of (.*)/', $new_name, $regs) ) {
	$new_name = 'Copy '.( (int)$regs[1] + 1 ).' of '.$regs[2];
	}
	elseif ($original_checked) {
	$new_name = 'Copy of '.$new_name;
	}
	$query = 'SELECT '.$title_field.' FROM '.$this->TableName.'
	LEFT JOIN '.TABLE_PREFIX.'CategoryItems ON
	('.TABLE_PREFIX.'CategoryItems.ItemResourceId = '.$this->TableName.'.ResourceId)
	WHERE ('.TABLE_PREFIX.'CategoryItems.CategoryId = '.$cat_id.') AND '.
	$title_field.' = '.$this->Conn->qstr($new_name);
	$res = $this->Conn->GetOne($query);
	$original_checked = true;
	} while ($res !== false);
	$this->SetDBField($title_field, $new_name);

	// this is needed, because Create will create items in its own CategoryId (if it's set),
	// but we need to create it in target Paste category @see{kCatDBItem::Create} and its primary_category detection
	$this->SetDBField('CategoryId', $cat_id);
	}

	function MoveToCat($cat_id=null)
	{
	// $this->NameCopy();
	$cat_id = $this->Application->GetVar('m_cat_id');
	// check if the product already exists in destination cat
	$query = 'SELECT PrimaryCat FROM '.TABLE_PREFIX.'CategoryItems
	WHERE CategoryId = '.$cat_id.' AND ItemResourceId = '.$this->GetDBField('ResourceId');
	// if it's not found is_primary will be FALSE, if it's found but not primary it will be int 0
	$is_primary = $this->Conn->GetOne($query);
	$exists = $is_primary !== false;

	if ($exists) { // if the Product already exists in destination category
	if ($is_primary) return; // do nothing when we paste to primary
	// if it's not primary - delete it from destination category,
	// as we will move it from current primary below
	$query = 'DELETE FROM '.TABLE_PREFIX.'CategoryItems
	WHERE ItemResourceId = '.$this->GetDBField('ResourceId').' AND CategoryId = '.$cat_id;
	$this->Conn->Query($query);

	}
	$query = 'UPDATE '.TABLE_PREFIX.'CategoryItems SET CategoryId = '.$cat_id.
	' WHERE ItemResourceId = '.$this->GetDBField('ResourceId').' AND PrimaryCat = 1';
	$this->Conn->Query($query);
	$this->Update();
	}

	// We need to delete CategoryItems record when deleting product
	function Delete($id = null)
	{
	if( isset($id) ) {
	$this->setID($id);
	}
	$this->Load($this->GetID());

	$ret = parent::Delete();
	if ($ret) {
	$query = ' DELETE FROM '.$this->CategoryItemsTable().'
	WHERE ItemResourceId = '.$this->GetDBField('ResourceId');
	$this->Conn->Query($query);
	}

	return $ret;
	}

	/**
	* Deletes item from categories
	*
	* @param Array $delete_category_ids
	* @author Alex
	*/
	function DeleteFromCategories($delete_category_ids)
	{
	$id_field = $this->Application->getUnitOption($this->Prefix, 'IDField'); // because item was loaded before by ResourceId

	$ci_table = $this->Application->getUnitOption($this->Prefix.'-ci', 'TableName');
	$resource_id = $this->GetDBField('ResourceId');

	$item_cats_sql = 'SELECT CategoryId FROM %s WHERE ItemResourceId = %s';
	$delete_category_items_sql = 'DELETE FROM %s WHERE ItemResourceId = %s AND CategoryId IN (%s)';

	$category_ids = $this->Conn->GetCol( sprintf($item_cats_sql, $ci_table, $resource_id) );
	$cats_left = array_diff($category_ids, $delete_category_ids);
	if(!$cats_left)
	{
	$sql = 'SELECT %s FROM %s WHERE ResourceId = %s';
	$ids = $this->Conn->GetCol( sprintf($sql, $id_field, $this->TableName, $resource_id) );

	$temp =& $this->Application->recallObject($this->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	$temp->DeleteItems($this->Prefix, $this->Special, $ids);
	}
	else
	{
	$this->Conn->Query( sprintf($delete_category_items_sql, $ci_table, $resource_id, implode(',', $delete_category_ids) ) );

	$sql = 'SELECT CategoryId FROM %s WHERE PrimaryCat = 1 AND ItemResourceId = %s';
	$primary_cat_id = $this->Conn->GetCol( sprintf($sql, $ci_table, $resource_id) );
	if( count($primary_cat_id) == 0 )
	{
	$sql = 'UPDATE %s SET PrimaryCat = 1 WHERE (CategoryId = %s) AND (ItemResourceId = %s)';
	$this->Conn->Query( sprintf($sql, $ci_table, reset($cats_left), $resource_id ) );
	}
	}
	}

	/**
	* replace not allowed symbols with "_" chars + remove duplicate "_" chars in result
	*
	* @param string $string
	* @return string
	*/
	function stripDisallowed($filename)
	{
	$filenames_helper =& $this->Application->recallObject('FilenamesHelper');
	$table = $this->mode == 't' ? $this->Application->GetTempName(TABLE_PREFIX.'CategoryItems', 'prefix:'.$this->Prefix) : TABLE_PREFIX.'CategoryItems';

	return $filenames_helper->stripDisallowed($table, 'ItemResourceId', $this->GetDBField('ResourceId'), $filename);
	}

	/* commented out because it's called only from stripDisallowed body, which is moved to helper

	function checkAutoFilename($filename)
	{
	$filenames_helper =& $this->Application->recallObject('FilenamesHelper');
	return $filenames_helper->checkAutoFilename($this->TableName, $this->IDField, $this->GetID(), $filename);
	}*/

	/**
	* Generate item's filename based on it's title field value
	*
	* @return string
	*/
	function generateFilename()
	{
	if ( !$this->GetDBField('AutomaticFilename') && $this->GetDBField('Filename') ) return false;

	$title_field = $this->Application->getUnitOption($this->Prefix, 'TitleField');
	if (preg_match('/l([\d]+)_(.*)/', $title_field, $regs)) {
	// if title field is multilingual, then use it's name from primary language
	$title_field = 'l'.$this->Application->GetDefaultLanguageId().'_'.$regs[2];
	}
	$name = $this->stripDisallowed( $this->GetDBField($title_field) );

	if ( $name != $this->GetDBField('Filename') ) $this->SetDBField('Filename', $name);
	}

	/**
	* Check if value is set for required field
	*
	* @param string $field field name
	* @param Array $params field options from config
	* @return bool
	* @access private
	*/
	function ValidateRequired($field, $params)
	{
	$res = true;
	$error_field = isset($params['error_field']) ? $params['error_field'] : $field;
	if ( getArrayValue($params,'required') )
	{
	$res = ( (string) $this->FieldValues[$field] != '');
	}
	if (!$res) $this->FieldErrors[$error_field]['pseudo'] = 'required';
	return $res;
	}

	/**
	* Adds item to other category
	*
	* @param int $category_id
	* @param bool $is_primary
	*/
	function assignToCategory($category_id, $is_primary = false)
	{
	$table = $this->mode == 't' ? $this->Application->GetTempName(TABLE_PREFIX.'CategoryItems', 'prefix:'.$this->Prefix) : TABLE_PREFIX.'CategoryItems';
	$key_clause = '(ItemResourceId = '.$this->GetDBField('ResourceId').')';

	// get all cateories, where item is in
	$sql = 'SELECT PrimaryCat, CategoryId FROM '.$table.' WHERE '.$key_clause;
	$item_categories = $this->Conn->GetCol($sql, 'CategoryId');
	if (!$item_categories) {
	$item_categories = Array();
	$primary_found = false;
	}

	// find primary category
	foreach ($item_categories as $item_category_id => $primary_found) {
	if ($primary_found) {
	break;
	}
	}

	if ($primary_found && ($item_category_id == $category_id) && !$is_primary) {
	// want to make primary category as non-primary :(
	return true;
	}
	else if (!$primary_found) {
	$is_primary = true;
	}

	if ($is_primary && $item_categories) {
	// reset primary mark from all other categories
	$sql = 'UPDATE '.$table.' SET PrimaryCat = 0 WHERE '.$key_clause;
	$this->Conn->Query($sql);
	}

	// UPDATE & INSERT instead of REPLACE because CategoryItems table has no primary key defined in database
	if (isset($item_categories[$category_id])) {
	$sql = 'UPDATE '.$table.' SET PrimaryCat = '.($is_primary ? 1 : 0).' WHERE '.$key_clause.' AND (CategoryId = '.$category_id.')';
	$this->Conn->Query($sql);
	}
	else {
	$sql = 'INSERT INTO '.$table.' (CategoryId,ItemResourceId,PrimaryCat,ItemPrefix,Filename) VALUES (%s,%s,%s,%s,%s)';
	$filename = $this->useFilenames ? $this->GetDBField('Filename') : ''; // because some prefixes does not use filenames
	$this->Conn->Query( sprintf($sql, $category_id, $this->GetDBField('ResourceId'), $is_primary ? 1 : 0, $this->Conn->qstr($this->Prefix), $this->Conn->qstr($filename)) );
	}
	// to ensure filename update after adding to another category
	// this is critical since there may be an item with same filename in newly added category!
	$this->Update();
	}

	/**
	* Removes item from category specified
	*
	* @param int $category_id
	*/
	function removeFromCategory($category_id)
	{
	$sql = 'DELETE FROM '.TABLE_PREFIX.'CategoryItems WHERE (CategoryId = %s) AND (ItemResourceId = %s)';
	$this->Conn->Query( sprintf($sql, $category_id, $this->GetDBField('ResourceId')) );
	}

	/**
	* Returns list of columns, that could exist in imported file
	*
	* @return Array
	*/
	function getPossibleExportColumns()
	{
	static $columns = null;
	if (!is_array($columns)) {
	$columns = array_merge($this->Fields['AvailableColumns']['options'], $this->Fields['ExportColumns']['options']);
	}
	return $columns;
	}

	/**
	* Returns item's primary image data
	*
	* @return Array
	*/
	function getPrimaryImageData()
	{
	$sql = 'SELECT *
	FROM '.TABLE_PREFIX.'Images
	WHERE (ResourceId = '.$this->GetDBField('ResourceId').') AND (DefaultImg = 1)';
	$image_data = $this->Conn->GetRow($sql);
	if (!$image_data) {
	// 2. no primary image, then get image with name "main"
	$sql = 'SELECT *
	FROM '.TABLE_PREFIX.'Images
	WHERE (ResourceId = '.$this->GetDBField('ResourceId').') AND (Name = "main")';
	$image_data = $this->Conn->GetRow($sql);
	}
	return $image_data;
	}

	function ChangeStatus($new_status)
	{
	$status_field = array_shift( $this->Application->getUnitOption($this->Prefix,'StatusField') );
	$this->SetDBField($status_field, $new_status);
	return $this->Update();
	}

	/**
	* Approves changes made to category item
	*
	* @return bool
	*/
	function ApproveChanges()
	{
	$original_id = $this->GetDBField('OrgId');

	if (!($this->usePendingEditing && $original_id)) {
	// non-pending copy of original link
	return $this->ChangeStatus(STATUS_ACTIVE);
	}

	if ($this->raiseEvent('OnBeforeDeleteOriginal', null, Array('original_id' => $original_id))) {
	// delete original item, because changes made in pending copy (this item) got to be approved in this method
	$temp_handler =& $this->Application->recallObject($this->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	$temp_handler->DeleteItems($this->Prefix, $this->Special, Array($original_id));

	$this->SetDBField('OrgId', 0);
	return $this->ChangeStatus(STATUS_ACTIVE);
	}

	return false;
	}

	/**
	* Decline changes made to category item
	*
	* @return bool
	*/
	function DeclineChanges()
	{
	$original_id = $this->GetDBField('OrgId');

	if (!($this->usePendingEditing && $original_id)) {
	// non-pending copy of original link
	return $this->ChangeStatus(STATUS_DISABLED);
	}

	// delete this item, because changes made in pending copy (this item) will be declined in this method
	$temp_handler =& $this->Application->recallObject($this->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	$temp_handler->DeleteItems($this->Prefix, $this->Special, Array($this->GetID()));

	// original item is not changed here, because it is already enabled (thrus pending copy is visible to item's owner or admin with permission)
	return true;
	}
	}

	?>

cat_dbitem.phpNo OneTemporaryActions

File Metadata

cat_dbitem.phpView Options

Event Timeline

cat_dbitem.php
No OneTemporary
Actions

cat_dbitem.php
View Options