/modules/storecommander/ead6f6fce09/SC/lib/cat/shopshare/cat_shopshare_update_queue.php

<?php


/**


 * Store Commander


 *


 * @category administration


 * @author Store Commander - support@storecommander.com


 * @version 2015-09-15


 * @uses Prestashop modules


 * @since 2009


 * @copyright Copyright &copy; 2009-2015, Store Commander


 * @license commercial


 * All rights reserved! Copying, duplication strictly prohibited


 *


 * *****************************************


 * *           STORE COMMANDER             *


 * *   http://www.StoreCommander.com       *


 * *            V 2015-09-15               *


 * *****************************************


 *


 * Compatibility: PS version: 1.1 to 1.6.1


 *


 **/





@error_reporting(E_ALL & ~E_NOTICE & ~E_WARNING);


@ini_set("display_errors", "ON");





$id_lang = Tools::getValue('id_lang','0');


$action = Tools::getValue('action','');





$return = "ERROR: Try again later";





// FUNCTIONS


$updated_products = array();


function removeInShop($product_id, $shop_id)


{


	if(!empty($product_id) && !empty($shop_id))


	{


		$product = new Product($product_id, false, null, $shop_id);





		// product_shop


		// delete row pour ce product et ce shop


		$sql = "DELETE FROM `"._DB_PREFIX_."product_shop` WHERE `id_product` = '".psql($product_id)."' AND id_shop = '".psql($shop_id)."'";


		Db::getInstance()->Execute($sql);





		// stock_available


		// delete row pour ce product et ce shop


		$sql = "DELETE FROM `"._DB_PREFIX_."stock_available` WHERE `id_product` = '".psql($product_id)."' AND id_shop = '".psql($shop_id)."'";


		Db::getInstance()->Execute($sql);





		// product_lang


		// delete row pour ce product et ce shop


		$sql = "DELETE FROM `"._DB_PREFIX_."product_lang` WHERE `id_product` = '".psql($product_id)."' AND id_shop = '".psql($shop_id)."'";


		Db::getInstance()->Execute($sql);





		// product_attribute_shop


		// delete row pour ce product et ce shop


		$sql = 'SELECT pa.id_product_attribute FROM `'._DB_PREFIX_.'product_attribute` pa WHERE pa.`id_product` = '.(int)$product_id.'';


			


		$attributes = Db::getInstance()->executeS($sql);


		foreach($attributes as $attribute)


		{


			if(!empty($attribute["id_product_attribute"]))


			{


				$sql = "DELETE FROM `"._DB_PREFIX_."product_attribute_shop` WHERE `id_product_attribute` = '".psql($attribute["id_product_attribute"])."' AND id_shop = '".psql($shop_id)."'";


				Db::getInstance()->Execute($sql);


			}


		}


			


		// image_shop


		// delete row pour images de ce product et ce shop


		$images = $product->getImages(Configuration::get("PS_LANG_DEFAULT"));


		foreach($images as $image)


		{


			if(!empty($image["id_image"]))


			{


				$sql = "DELETE FROM `"._DB_PREFIX_."image_shop` WHERE `id_image` = '".psql($image["id_image"])."' AND id_shop = '".psql($shop_id)."'";


				Db::getInstance()->Execute($sql);


			}


		}





		// feature_product


		// delete row pour ce product et ce feature


		$features = $product->getFeatures();


		foreach($features as $feature)


		{


			if(!empty($feature["id_feature"]))


			{


				$feature = new Feature($feature["id_feature"]);


				$associated_shops = $feature->getAssociatedShops();


				// si feature_shop existe QUE pour ce shop


				if(count($associated_shops)==1 && $associated_shops[0]==$shop_id)


				{


					$sql = "SELECT id_feature_value FROM `"._DB_PREFIX_."feature_product` WHERE `id_feature` = '".psql($feature->id)."' AND id_product = '".psql($product_id)."'";


					$values = Db::getInstance()->ExecuteS($sql);


					foreach($values as $value)


					{


						$feature_value = new FeatureValue($value["id_feature_value"]);


						if(!empty($feature_value->id))


							$feature_value->delete();


					}





					$sql = "DELETE FROM `"._DB_PREFIX_."feature_product` WHERE `id_feature` = '".psql($feature->id)."' AND id_product = '".psql($product_id)."'";


					Db::getInstance()->Execute($sql);


				}


			}


		}


			


		// supplier_product


		// si supplier_shop existe QUE pour ce shop


		$sql = "SELECT id_supplier FROM `"._DB_PREFIX_."product_supplier` WHERE id_product = '".psql($product_id)."' GROUP BY id_supplier";


		$suppliers = Db::getInstance()->ExecuteS($sql);


		foreach($suppliers as $supplier)


		{


			if(!empty($supplier) && !empty($supplier["id_supplier"]))


			{


				$supplier = new Supplier($supplier["id_supplier"]);


				$associated_shops = $supplier->getAssociatedShops();


				// delete row pour ce product et ce suplier


				if(count($associated_shops)==1 && $associated_shops[0]==$shop_id)


				{


					$sql = "DELETE FROM `"._DB_PREFIX_."supplier_product` WHERE `id_supplier` = '".psql($supplier->id)."' AND id_product = '".psql($product_id)."'";


					Db::getInstance()->Execute($sql);


				}


			}


		}


			


		// warehouse_product_location


		// si warehouse_shop existe QUE pour ce shop


		$sql = "SELECT id_warehouse FROM `"._DB_PREFIX_."warehouse_product_location` WHERE id_product = '".psql($product_id)."' GROUP BY id_warehouse";


		$warehouses = Db::getInstance()->ExecuteS($sql);


		foreach($warehouses as $warehouse)


		{


			if(!empty($warehouse["id_warehouse"]))


			{


				$warehouse = new Warehouse($warehouse["id_warehouse"]);


				$associated_shops = $warehouse->getAssociatedShops();


				// delete row pour ce product et ce warehouse


				if(count($associated_shops)==1 && $associated_shops[0]==$shop_id)


				{


					$sql = "DELETE FROM `"._DB_PREFIX_."warehouse_product_location` WHERE `id_warehouse` = '".psql($warehouse->id)."' AND id_product = '".psql($product_id)."'";


					Db::getInstance()->Execute($sql);


				}


			}


		}


	}


}





/*function duplicateCombination($id_product, $id_product_attribute, $id_shop_base, $id_shop_new)


 {


//$product = new Product($id_product, false, null, $id_shop_base);


$combination = new Combination($id_product_attribute, null, $id_shop_base);





$sql = "INSERT INTO "._DB_PREFIX_."product_attribute_shop (id_product_attribute, id_shop, wholesale_price, price, ecotax, weight, unit_price_impact, default_on, minimal_quantity, available_date)


SELECT '".$id_product_attribute."', '".$id_shop_new."', wholesale_price, price, ecotax, weight, unit_price_impact, default_on, minimal_quantity, available_date FROM "._DB_PREFIX_."product_attribute_shop


WHERE id_product_attribute='".$id_product_attribute."' AND id_shop='".$id_shop_base."'";


Db::getInstance()->Execute($sql);


}*/





// Récupération de toutes les modifications à effectuer


if(!empty($_POST["rows"]) || $action=="insert")


{


	if($action!="insert")


	{


		if(_PS_MAGIC_QUOTES_GPC_)


			$_POST["rows"] = stripslashes($_POST["rows"]);


		$rows = json_decode($_POST["rows"]);


	}


	else


	{


		$rows = array();


		$rows[0] = new stdClass();


		$rows[0]->name = Tools::getValue('act','');


		$rows[0]->action = Tools::getValue('action','');


		$rows[0]->row = Tools::getValue('gr_id','');


		$rows[0]->callback = Tools::getValue('callback','');


		$rows[0]->params = $_POST;


	}


	


	if(is_array($rows) && count($rows)>0)


	{


		$callbacks = '';


		


		// Première boucle pour remplir la table sc_queue_log 


		// avec toutes ces modifications


		$log_ids = array();


		$date = date("Y-m-d H:i:s");


		foreach($rows as $num => $row)


		{


			$id = QueueLog::add($row->name, $row->row, $row->action, (!empty($row->params)?$row->params:array()), (!empty($row->callback)?$row->callback:null), $date);


			$log_ids[$num] = $id;


		}


		


		// Deuxième boucle pour effectuer les 


		// actions les une après les autres


		foreach($rows as $num => $row)


		{


			if(!empty($log_ids[$num]))


			{


				$gr_id = intval($row->row);


				$action = $row->action;


				


				if(!empty($row->callback))


					$callbacks .= $row->callback.";";





				if($action!="insert")


				{


					$_POST=array();


					$_POST = (array) json_decode($row->params);


				}


				if(empty($gr_id))


					$gr_id=Tools::getValue('gr_id','0');





				if(!empty($action) && $action=="update" && !empty($gr_id))


				{


					$idlist=$gr_id;


					$action_upd=Tools::getValue('action_upd','');


					$id_lang=Tools::getValue('id_lang','0');


					$id_shop=Tools::getValue('id_shop','0');


					$id_actual_shop = SCI::getSelectedShop();


					$value=Tools::getValue('value','0');


					$auto_share_imgs=intval(Tools::getValue('auto_share_imgs','0'));


					


					if($value=="true")


						$value = 1;


					else


						$value = 0;


					


					$ids = explode(",", $idlist);


					


					if($action_upd!='' && !empty($id_shop) && !empty($idlist)/* && !empty($id_actual_shop)*/)


					{


						if(!empty($ids) && count($ids)==1)


							$updated_products[$ids]=$ids;


						elseif(!empty($ids) && count($ids)>1)


							$updated_products = array_merge($updated_products,$ids);


						switch($action_upd)


						{


							// Modification de active pour le shop passé en params


							// pour un ou plusieurs products passés en params


							case 'active':


								foreach($ids as $id)


								{


									$product = new Product($id, false, null, $id_actual_shop);


									if(!$product->isAssociatedToShop($id_shop))


									{


										$product->id_shop_list=array($id_shop);


										$product->active = (int)$value;


										$product->save();


											


										$sql = 'SELECT pa.id_product_attribute


										FROM `'._DB_PREFIX_.'product_attribute` pa


										WHERE pa.`id_product` = '.(int)$id.'';


										$product_attrs = Db::getInstance()->executeS($sql);


										foreach($product_attrs as $product_attr)


										{


											$combination = new Combination($product_attr["id_product_attribute"], null, $id_actual_shop);


											$combination->id_product = $id;


											$combination->id_shop_list=array($id_shop);


											$combination->minimal_quantity=max(1,(int)$combination->minimal_quantity);


											$combination->save();


										}


											


										//$images = $product->getImages($id_lang);


										if($auto_share_imgs)


										{


											$sql = 'SELECT pis.id_image


											FROM `'._DB_PREFIX_.'image_shop` pis


												INNER JOIN `'._DB_PREFIX_.'image` pi ON pi.id_image = pis.id_image


											WHERE pi.`id_product` = '.(int)$id.'


												AND pis.id_shop = "'.(int)$id_actual_shop.'"


											GROUP BY pis.id_image';


											$images = Db::getInstance()->executeS($sql);


											foreach ($images as $image)


											{


												/*$image_temp = new Image($image["id_image"]);


												 $image_temp->id_shop_list=array($id_shop, $id_actual_shop);


												$image_temp->save();*/


												SCI::duplicateImageToShops($image["id_image"], $id_actual_shop, array($id_shop));


											}


										}


									}


									else


									{


										$sql = "UPDATE `"._DB_PREFIX_."product_shop` SET active='".(int)$value."' WHERE `id_product` = '".psql($id)."' AND id_shop = '".$id_shop."'";


										Db::getInstance()->Execute($sql);


									}


								}


								break;


								// Modification de present pour le shop passé en params


								// pour un ou plusieurs products passés en params


							case 'present':


								foreach($ids as $id)


								{


									$product = new Product($id, false, null, $id_actual_shop);


					


									if(!$product->isAssociatedToShop($id_shop) && $value=="1")


									{


										$product->id_shop_list=array($id_shop);


										$product->price=floatval($product->price);


										$product->save();


										SCI::setQuantity($id, null, StockAvailable::getQuantityAvailableByProduct($id, null, $id_actual_shop), $id_shop);


											


										$sql = 'UPDATE `'._DB_PREFIX_.'product_shop`


										SET active = "'._s("CAT_PROD_AUTO_ACTIVATION_MB_SHARE").'"


										WHERE `id_product` = '.(int)$id.' AND `id_shop` = '.(int)$id_shop.'';


										Db::getInstance()->execute($sql);


											


										$sql = 'SELECT pa.id_product_attribute


										FROM `'._DB_PREFIX_.'product_attribute` pa


										WHERE pa.`id_product` = '.(int)$id.'';


										$product_attrs = Db::getInstance()->executeS($sql);


										foreach($product_attrs as $product_attr)


										{


											$combination = new Combination($product_attr["id_product_attribute"], null, $id_actual_shop);


											$combination->id_product = $id;


											$combination->id_shop_list=array($id_shop);


											$combination->minimal_quantity=max(1,(int)$combination->minimal_quantity);


											$combination->save();


										}


											


										//$images = $product->getImages($id_lang);


										if($auto_share_imgs)


										{


											$sql = 'SELECT pis.id_image


											FROM `'._DB_PREFIX_.'image_shop` pis


												INNER JOIN `'._DB_PREFIX_.'image` pi ON pi.id_image = pis.id_image


											WHERE pi.`id_product` = '.(int)$id.'


												AND pis.id_shop = "'.(int)$id_actual_shop.'"


											GROUP BY pis.id_image';


											$images = Db::getInstance()->executeS($sql);


											foreach ($images as $image)


											{


												/*$image_temp = new Image($image["id_image"]);


												 $image_temp->id_shop_list=array($id_shop, $id_actual_shop);


												$image_temp->save();*/


												SCI::duplicateImageToShops($image["id_image"], $id_actual_shop, array($id_shop));


											}


										}


									}


									elseif($product->isAssociatedToShop($id_shop) && empty($value))


									{


										if($id_shop != $product->id_shop_default)


											removeInShop($id, $id_shop);


									}


								}


								break;


								// Modification la boutique par défaut


								// pour un ou plusieurs products passés en params


							case 'default':


								foreach($ids as $id)


								{


									$sql2 ="SELECT id_shop_default


									FROM "._DB_PREFIX_."product


									WHERE id_product = '".psql($id)."'";


									$res2 = Db::getInstance()->getRow($sql2);


									if(!empty($res2["id_shop_default"]))


									{


										$product = new Product($id, false, null, $res2["id_shop_default"]);


											


										if(!$product->isAssociatedToShop($id_shop))


										{


											$product->id_shop_list=array($id_shop);


					


											$sql = 'SELECT pa.id_product_attribute


											FROM `'._DB_PREFIX_.'product_attribute` pa


											WHERE pa.`id_product` = '.(int)$id.'';


											$product_attrs = Db::getInstance()->executeS($sql);


											foreach($product_attrs as $product_attr)


											{


												$combination = new Combination($product_attr["id_product_attribute"], null, $res2["id_shop_default"]);


												$combination->id_product = $id;


												$combination->id_shop_list=array($id_shop);


												$combination->minimal_quantity=max(1,(int)$combination->minimal_quantity);


												$combination->save();


											}


												


											//$images = $product->getImages($id_lang);


											if($auto_share_imgs)


											{


												$sql = 'SELECT pis.id_image


												FROM `'._DB_PREFIX_.'image_shop` pis


													INNER JOIN `'._DB_PREFIX_.'image` pi ON pi.id_image = pis.id_image


												WHERE pi.`id_product` = '.(int)$id.'


													AND pis.id_shop = "'.(int)$id_actual_shop.'"


												GROUP BY pis.id_image';


												$images = Db::getInstance()->executeS($sql);


												foreach ($images as $image)


												{


													/*$image_temp = new Image($image["id_image"]);


													 $image_temp->id_shop_list=array($id_shop, $id_actual_shop);


													$image_temp->save();*/


													SCI::duplicateImageToShops($image["id_image"], $id_actual_shop, array($id_shop));


												}


											}


										}


											


										$product->id_shop_default=$id_shop;


										$product->save();


											


										$sql = 'UPDATE `'._DB_PREFIX_.'product_shop`


										SET active = "'._s("CAT_PROD_AUTO_ACTIVATION_MB_SHARE").'"


										WHERE `id_product` = '.(int)$id.' AND `id_shop` = '.(int)$id_shop.'';


										Db::getInstance()->execute($sql);


											


										$images = array();


										$image_temps = $product->getImages($id_lang);


										foreach ($image_temps as $image_temp)


										{


											if(!empty($image_temp["id_image"]))


												$images[] = $image_temp["id_image"];


										}


										if(!empty($images) && count($images)>0)


											SCI::addToShops("image", $images,array($id_shop));


									}


								}


								break;


								// Modification de present


								// pour un ou plusieurs shops passés en params


								// pour un ou plusieurs products passés en params


							case 'mass_present':


								$shops  = explode(",", $id_shop);


								foreach($shops as $id_shop)


								{


									foreach($ids as $id)


									{										


										$product = new Product($id, false, null, $id_actual_shop);


						


										if(!$product->isAssociatedToShop($id_shop) && $value=="1")


										{


											$product->id_shop_list=array($id_shop);


											$product->price=floatval($product->price);


											$product->save();


											SCI::setQuantity($id, null, StockAvailable::getQuantityAvailableByProduct($id, null, $id_actual_shop), $id_shop);


												


											$sql = 'UPDATE `'._DB_PREFIX_.'product_shop`


											SET active = "'._s("CAT_PROD_AUTO_ACTIVATION_MB_SHARE").'"


											WHERE `id_product` = '.(int)$id.' AND `id_shop` = '.(int)$id_shop.'';


											Db::getInstance()->execute($sql);


												


											$sql = 'SELECT pa.id_product_attribute


											FROM `'._DB_PREFIX_.'product_attribute` pa


											WHERE pa.`id_product` = '.(int)$id.'';


											$product_attrs = Db::getInstance()->executeS($sql);


											foreach($product_attrs as $product_attr)


											{


												$combination = new Combination($product_attr["id_product_attribute"], null, $id_actual_shop);


												$combination->id_product = $id;


												$combination->id_shop_list=array($id_shop);


												$combination->minimal_quantity=max(1,(int)$combination->minimal_quantity);


												$combination->save();


											}


												


											//$images = $product->getImages($id_lang);


											if($auto_share_imgs)


											{


												$sql = 'SELECT pis.id_image


												FROM `'._DB_PREFIX_.'image_shop` pis


													INNER JOIN `'._DB_PREFIX_.'image` pi ON pi.id_image = pis.id_image


												WHERE pi.`id_product` = '.(int)$id.'


													AND pis.id_shop = "'.(int)$id_actual_shop.'"


												GROUP BY pis.id_image';


												$images = Db::getInstance()->executeS($sql);


												foreach ($images as $image)


												{


													/*$image_temp = new Image($image["id_image"]);


													 $image_temp->id_shop_list=array($id_shop, $id_actual_shop);


													$image_temp->save();*/


													SCI::duplicateImageToShops($image["id_image"], $id_actual_shop, array($id_shop));


												}


											}


										}


										elseif($product->isAssociatedToShop($id_shop) && empty($value))


										{


											if($id_shop != $product->id_shop_default)


												removeInShop($id, $id_shop);


										}


									}


								}


								break;


								// Modification de active


								// pour un ou plusieurs shops passés en params


								// pour un ou plusieurs products passés en params


							case 'mass_active':


								$shops  = explode(",", $id_shop);


								foreach($shops as $shop)


								{


									foreach($ids as $id)


									{


										$product = new Product($id, false, null, $id_actual_shop);


										if(!$product->isAssociatedToShop($shop))


										{


											$product->id_shop_list=array($shop);


											$product->active = (int)$value;


											$product->save();


												


											$sql = 'SELECT pa.id_product_attribute


											FROM `'._DB_PREFIX_.'product_attribute` pa


											WHERE pa.`id_product` = '.(int)$id.'';


											$product_attrs = Db::getInstance()->executeS($sql);


											foreach($product_attrs as $product_attr)


											{


												$combination = new Combination($product_attr["id_product_attribute"], null, $id_actual_shop);


												$combination->id_product = $id;


												$combination->id_shop_list=array($shop);


												$combination->minimal_quantity=max(1,(int)$combination->minimal_quantity);


												$combination->save();


											}


												


											//$images = $product->getImages($id_lang);


											if($auto_share_imgs)


											{


												$sql = 'SELECT pis.id_image


												FROM `'._DB_PREFIX_.'image_shop` pis


													INNER JOIN `'._DB_PREFIX_.'image` pi ON pi.id_image = pis.id_image


												WHERE pi.`id_product` = '.(int)$id.'


													AND pis.id_shop = "'.(int)$id_actual_shop.'"


												GROUP BY pis.id_image';


												$images = Db::getInstance()->executeS($sql);


												foreach ($images as $image)


												{


													/*$image_temp = new Image($image["id_image"]);


													 $image_temp->id_shop_list=array($shop, $id_actual_shop);


													$image_temp->save();*/


													SCI::duplicateImageToShops($image["id_image"], $id_actual_shop, array($shop));


												}


											}


										}


										else


										{


											$sql = "UPDATE `"._DB_PREFIX_."product_shop` SET active='".(int)$value."' WHERE `id_product` = '".psql($id)."' AND id_shop = '".$shop."'";


											Db::getInstance()->Execute($sql);


										}


									}


								}


								break;


						}


					}


				}


				


				QueueLog::delete(($log_ids[$num]));


			}


		}





		// PM Cache


		if(!empty($updated_products))


			ExtensionPMCM::clearFromIdsProduct($updated_products);


		


		// RETURN


		$return = json_encode(array("callback"=>$callbacks));


	}	


}


echo $return;