PageRenderTime 133ms CodeModel.GetById 24ms RepoModel.GetById 2ms app.codeStats 0ms

/administrator/components/com_virtuemart/classes/ps_product.php

https://bitbucket.org/dgough/annamaria-daneswood-25102012
PHP | 2743 lines | 1976 code | 250 blank | 517 comment | 367 complexity | 912628defcddc12db09e6304fee92fb8 MD5 | raw file
Possible License(s): GPL-2.0, LGPL-2.1

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. if( !defined( '_VALID_MOS' ) && !defined( '_JEXEC' ) ) die( 'Direct Access to '.basename(__FILE__).' is not allowed.' );
    3. 

  3. /**
    4. 

  4. *
    5. 

  5. * @version $Id: ps_product.php 1475 2008-07-16 17:35:35Z soeren_nb $
    6. 

  6. * @package VirtueMart
    7. 

  7. * @subpackage classes
    8. 

  8. * @copyright Copyright (C) 2004-2008 soeren - All rights reserved.
    9. 

  9. * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
    10. 

  10. * VirtueMart is free software. This version may have been modified pursuant
    11. 

  11. * to the GNU General Public License, and as distributed it includes or
    12. 

  12. * is derivative of works licensed under the GNU General Public License or
    13. 

  13. * other free or open source software licenses.
    14. 

  14. * See /administrator/components/com_virtuemart/COPYRIGHT.php for copyright notices and details.
    15. 

  15. *
    16. 

  16. * http://virtuemart.net
    17. 

  17. */
    18. 

  18. 

  19. /**
    20. 

  20.  * The class is is used to manage product repository.
    21. 

  21.  * @package virtuemart
    22. 

  22.  * @author pablo, jep, gday, soeren
    23. 

  23.  * 
    24. 

  24.  */
    25. 

  25. class ps_product extends vmAbstractObject {
    26. 

  26. 	var $_key = 'product_id';
    27. 

  27. 	var $_table_name = '#__{vm}_product';
    28. 

  28. 	
    29. 

  29. 	/**
    30. 

  30. 	 * Validates product fields and uploaded image files.
    31. 

  31. 	 *
    32. 

  32. 	 * @param array $d The input vars
    33. 

  33. 	 * @return boolean True when validation successful, false when not
    34. 

  34. 	 */
    35. 

  35. 	function validate(&$d) {
    36. 

  36. 		global $vmLogger, $database, $perm, $VM_LANG;
    37. 

  37. 		require_once(CLASSPATH . 'imageTools.class.php' );
    38. 

  38. 		
    39. 

  39. 		$valid = true;
    40. 

  40. 		$db = new ps_DB;
    41. 

  41. 

  42. 		$q = "SELECT product_id,product_thumb_image,product_full_image FROM #__{vm}_product WHERE product_sku='";
    43. 

  43. 		$q .= $d["product_sku"] . "'";
    44. 

  44. 		$db->setQuery($q); $db->query();
    45. 

  45. 		if ($db->next_record()&&($db->f("product_id") != $d["product_id"])) {
    46. 

  46. 			$vmLogger->err( "A Product with the SKU ".$d['product_sku']." already exists." );
    47. 

  47. 			$valid = false;
    48. 

  48. 		}
    49. 

  49. 		if( !empty( $d['product_discount_id'] )) {
    50. 

  50. 			if( $d['product_discount_id'] == "override" ) {
    51. 

  51. 

  52. 				$d['is_percent'] = "0";
    53. 

  53. 				
    54. 

  54. 				// If discount are applied before tax then base the discount on the untaxed price
    55. 

  55. 				if( PAYMENT_DISCOUNT_BEFORE == '1' ) {
    56. 

  56. 					$d['amount'] = (float)$d['product_price'] - (float)$d['discounted_price_override'];
    57. 

  57. 				}
    58. 

  58. 				// Otherwise, base the discount on the taxed price
    59. 

  59. 				else {
    60. 

  60. 					$d['amount'] = (float)$d['product_price_incl_tax'] - (float)$d['discounted_price_override'];
    61. 

  61. 				}
    62. 

  62. 				
    63. 

  63. 				// Set the discount start date as today
    64. 

  64. 				$d['start_date'] = date( 'Y-m-d' );
    65. 

  65. 

  66. 				require_once( CLASSPATH. 'ps_product_discount.php' );
    67. 

  67. 				$ps_product_discount = new ps_product_discount;
    68. 

  68. 				$ps_product_discount->add( $d );
    69. 

  69. 				$d['product_discount_id'] = $database->insertid();
    70. 

  70. 				vmRequest::setVar( 'product_discount_id', $d['product_discount_id'] );
    71. 

  71. 			}
    72. 

  72. 		}
    73. 

  73. 		if (empty($d['manufacturer_id'])) {
    74. 

  74. 			$d['manufacturer_id'] = "1";
    75. 

  75. 		}
    76. 

  76. 		if (empty( $d["product_sku"])) {
    77. 

  77. 			$vmLogger->err( $VM_LANG->_('VM_PRODUCT_MISSING_SKU',false) );
    78. 

  78. 			$valid = false;
    79. 

  79. 		}
    80. 

  80. 		if (!$d["product_name"]) {
    81. 

  81. 			$vmLogger->err( $VM_LANG->_('VM_PRODUCT_MISSING_NAME',false) );
    82. 

  82. 			$valid = false;
    83. 

  83. 		}
    84. 

  84. 		if (empty($d["product_available_date"])) {
    85. 

  85. 			$vmLogger->err( $VM_LANG->_('VM_PRODUCT_MISSING_AVAILDATE',false) );
    86. 

  86. 			$valid = false;
    87. 

  87. 		}
    88. 

  88. 		else {
    89. 

  89. 			$day = (int) substr ( $d["product_available_date"], 8, 2);
    90. 

  90. 			$month= (int) substr ( $d["product_available_date"], 5, 2);
    91. 

  91. 			$year = (int) substr ( $d["product_available_date"], 0, 4);
    92. 

  92. 			$d["product_available_date_timestamp"] = mktime(0,0,0,$month, $day, $year);
    93. 

  93. 		}
    94. 

  94. 

  95. 		/** Validate Product Specific Fields **/
    96. 

  96. 		if (!$d["product_parent_id"]) {
    97. 

  97. 			if( empty( $d['product_categories']) || !is_array(@$d['product_categories'])) {
    98. 

  98. 				$d['product_categories'] = explode('|', $d['category_ids'] );
    99. 

  99. 			}
    100. 

  100. 			if (sizeof(@$d["product_categories"]) < 1) {
    101. 

  101. 				$vmLogger->err( $VM_LANG->_('VM_PRODUCT_MISSING_CATEGORY') );
    102. 

  102. 				$valid = false;
    103. 

  103. 			}
    104. 

  104. 		}
    105. 

  105. 		/** Image Upload Validation **/
    106. 

  106. 

  107. 		// do we have an image URL or an image File Upload?
    108. 

  108. 		if (!empty( $d['product_thumb_image_url'] )) {
    109. 

  109. 			// Image URL
    110. 

  110. 			if (substr( $d['product_thumb_image_url'], 0, 4) != "http") {
    111. 

  111. 				$vmLogger->err( $VM_LANG->_('VM_PRODUCT_IMAGEURL_MUSTBEGIN',false) );
    112. 

  112. 				$valid =  false;
    113. 

  113. 			}
    114. 

  114. 

  115. 			// if we have an uploaded image file, prepare this one for deleting.
    116. 

  116. 			if( $db->f("product_thumb_image") && substr( $db->f("product_thumb_image"), 0, 4) != "http") {
    117. 

  117. 				$_REQUEST["product_thumb_image_curr"] = $db->f("product_thumb_image");
    118. 

  118. 				$d["product_thumb_image_action"] = "delete";
    119. 

  119. 				if (!vmImageTools::validate_image($d,"product_thumb_image","product")) {
    120. 

  120. 					return false;
    121. 

  121. 				}
    122. 

  122. 			}
    123. 

  123. 			$d["product_thumb_image"] = $d['product_thumb_image_url'];
    124. 

  124. 		}
    125. 

  125. 		else {
    126. 

  126. 			// File Upload
    127. 

  127. 			if (!vmImageTools::validate_image($d,"product_thumb_image","product")) {
    128. 

  128. 				$valid = false;
    129. 

  129. 			}
    130. 

  130. 		}
    131. 

  131. 

  132. 		if (!empty( $d['product_full_image_url'] )) {
    133. 

  133. 			// Image URL
    134. 

  134. 			if (substr( $d['product_full_image_url'], 0, 4) != "http") {
    135. 

  135. 				$vmLogger->err( $VM_LANG->_('VM_PRODUCT_IMAGEURL_MUSTBEGIN',false) );
    136. 

  136. 				return false;
    137. 

  137. 			}
    138. 

  138. 			// if we have an uploaded image file, prepare this one for deleting.
    139. 

  139. 			if( $db->f("product_full_image") && substr( $db->f("product_full_image"), 0, 4) != "http") {
    140. 

  140. 				$_REQUEST["product_full_image_curr"] = $db->f("product_full_image");
    141. 

  141. 				$d["product_full_image_action"] = "delete";
    142. 

  142. 				if (!vmImageTools::validate_image($d,"product_full_image","product")) {
    143. 

  143. 					return false;
    144. 

  144. 				}
    145. 

  145. 			}
    146. 

  146. 			$d["product_full_image"] = $d['product_full_image_url'];
    147. 

  147. 		}
    148. 

  148. 		else {
    149. 

  149. 			// File Upload
    150. 

  150. 			if (!vmImageTools::validate_image($d,"product_full_image","product")) {
    151. 

  151. 				$valid = false;
    152. 

  152. 			}
    153. 

  153. 		}
    154. 

  154. 		
    155. 

  155. 		// added for advanced attribute modification
    156. 

  156. 		// strips the trailing semi-colon from an attribute
    157. 

  157.         if(isset($d["product_advanced_attribute"])) {
    158. 

  158. 		    if (';' == substr($d["product_advanced_attribute"], strlen($d["product_advanced_attribute"])-1,1) ) {
    159. 

  159. 			    $d["product_advanced_attribute"] =substr($d["product_advanced_attribute"], 0, strlen($d["product_advanced_attribute"])-1);
    160. 

  160. 		    }
    161. 

  161.         }
    162. 

  162. 		// added for custom attribute modification
    163. 

  163. 		// strips the trailing semi-colon from an attribute
    164. 

  164.         if(isset($d["product_custom_attribute"])) {
    165. 

  165. 		    if (';' == substr($d["product_custom_attribute"], strlen($d["product_custom_attribute"])-1,1) ) {
    166. 

  166. 			    $d["product_custom_attribute"] =substr($d["product_custom_attribute"], 0, strlen($d["product_custom_attribute"])-1);
    167. 

  167. 		    }
    168. 

  168.         }
    169. 

  169. 		$d["clone_product"] = empty($d["clone_product"]) ? "N" : "Y";
    170. 

  170. 		$d["product_publish"] = empty($d["product_publish"]) ? "N" : "Y";
    171. 

  171. 		$d["product_special"] = empty($d["product_special"]) ? "N" : "Y";
    172. 

  172.         //parse quantity and child options
    173. 

  173.         $d['display_headers'] = vmGet($d,'display_headers', 'Y') =='Y' ? 'Y' : 'N';
    174. 

  174.         $d['product_list_child'] = vmGet($d,'product_list_child', 'Y') =='Y' ? 'Y' : 'N';
    175. 

  175.         $d['display_use_parent'] = vmGet($d,'display_use_parent', 'Y') =='Y' ? 'Y' : 'N';
    176. 

  176.         $d['product_list_type'] = vmGet($d,'product_list_type', 'Y') =='Y' ? 'Y' : 'N';
    177. 

  177.         $d['display_desc'] = vmGet($d,'display_desc', 'Y') =='Y' ? 'Y' : 'N';
    178. 

  178.         
    179. 

  179.         if (@$d['product_list'] =="Y") {
    180. 

  180.             if($d['list_style'] == "one")
    181. 

  181.                 $d['product_list'] = "Y";
    182. 

  182.             else
    183. 

  183.                 $d['product_list'] = "YM";            
    184. 

  184.         }
    185. 

  185.         else {
    186. 

  186.             $d['product_list'] = "N";
    187. 

  187.         }
    188. 

  188.         
    189. 

  189.         $d['quantity_options'] = ps_product::set_quantity_options($d);
    190. 

  190. 		$d['child_options'] = ps_product::set_child_options($d);
    191. 

  191. 		
    192. 

  192.         $d['order_levels'] = vmRequest::getInt('min_order_level').",".vmRequest::getInt('max_order_level');
    193. 

  193.         
    194. 

  194. 		return $valid;
    195. 

  195. 	}
    196. 

  196. 

  197. 	/**
    198. 

  198. 	 * Validates that a product can be deleted
    199. 

  199. 	 *
    200. 

  200. 	 * @param array $d The input vars
    201. 

  201. 	 * @return boolean Validation sucessful?
    202. 

  202. 	 */
    203. 

  203. 	function validate_delete( $product_id, &$d ) {
    204. 

  204. 		global $vmLogger, $VM_LANG;
    205. 

  205. 		require_once(CLASSPATH . 'imageTools.class.php' );
    206. 

  206. 		/* Check that ps_vendor_id and product_id match
    207. 

  207. 		if (!$this->check_vendor($d)) {
    208. 

  208. 		$d["error"] = "ERROR: Cannot delete product. Wrong product or vendor." ;
    209. 

  209. 		return false;
    210. 

  210. 		}*/
    211. 

  211. 		if (empty($product_id)) {
    212. 

  212. 			$vmLogger->err( $VM_LANG->_('VM_PRODUCT_SPECIFY_DELETE',false) );
    213. 

  213. 			return false;
    214. 

  214. 		}
    215. 

  215. 		/* Get the image filenames from the database */
    216. 

  216. 		$db = new ps_DB;
    217. 

  217. 		$q  = "SELECT product_thumb_image,product_full_image ";
    218. 

  218. 		$q .= "FROM #__{vm}_product ";
    219. 

  219. 		$q .= "WHERE product_id='$product_id'";
    220. 

  220. 		$db->setQuery($q); $db->query();
    221. 

  221. 		$db->next_record();
    222. 

  222. 

  223. 		/* Prepare product_thumb_image for Deleting */
    224. 

  224. 		if( !stristr( $db->f("product_thumb_image"), "http") ) {
    225. 

  225. 			$_REQUEST["product_thumb_image_curr"] = $db->f("product_thumb_image");
    226. 

  226. 			$d["product_thumb_image_action"] = "delete";
    227. 

  227. 			if (!vmImageTools::validate_image($d,"product_thumb_image","product")) {
    228. 

  228. 				$vmLogger->err( $VM_LANG->_('VM_PRODUCT_IMGDEL_FAILED',false) );
    229. 

  229. 				return false;
    230. 

  230. 			}
    231. 

  231. 		}
    232. 

  232. 		/* Prepare product_full_image for Deleting */
    233. 

  233. 		if( !stristr( $db->f("product_full_image"), "http") ) {
    234. 

  234. 			$_REQUEST["product_full_image_curr"] = $db->f("product_full_image");
    235. 

  235. 			$d["product_full_image_action"] = "delete";
    236. 

  236. 			if (!vmImageTools::validate_image($d,"product_full_image","product")) {
    237. 

  237. 				return false;
    238. 

  238. 			}
    239. 

  239. 		}
    240. 

  240. 		return true;
    241. 

  241. 

  242. 	}
    243. 

  243. 

  244. 	/**
    245. 

  245. 	 * Function to add a new product into the product table
    246. 

  246. 	 *
    247. 

  247. 	 * @param array $d The input vars
    248. 

  248. 	 * @return boolean True, when the product was added, false when not
    249. 

  249. 	 */
    250. 

  250. 	function add( &$d ) {
    251. 

  251. 		global $perm, $vmLogger, $VM_LANG;
    252. 

  252. 		$database = new ps_DB();
    253. 

  253. 

  254. 		if (!$this->validate($d)) {
    255. 

  255. 			return false;
    256. 

  256. 		}
    257. 

  257. 

  258. 		if (!vmImageTools::process_images($d)) {
    259. 

  259. 			return false;
    260. 

  260. 		}
    261. 

  261. 

  262. 		$timestamp = time();
    263. 

  263. 		$db = new ps_DB;
    264. 

  264. 

  265. 		$ps_vendor_id = $_SESSION["ps_vendor_id"];
    266. 

  266. 		if( $perm->check( 'admin' )) {
    267. 

  267. 			$vendor_id = $d['vendor_id'];
    268. 

  268. 		}
    269. 

  269. 		else {
    270. 

  270. 			$vendor_id = $ps_vendor_id;
    271. 

  271. 		}
    272. 

  272.         // Insert into DB
    273. 

  273. 		$fields = array ( 'vendor_id' => $vendor_id,
    274. 

  274. 						'product_parent_id' => vmRequest::getInt('product_parent_id'),
    275. 

  275. 						'product_sku' => vmGet($d,'product_sku'),
    276. 

  276. 						'product_name' => vmGet($d,'product_name'),
    277. 

  277. 						'product_desc' => vmRequest::getVar('product_desc', '', 'default', '', VMREQUEST_ALLOWHTML),
    278. 

  278. 						'product_s_desc' => vmRequest::getVar('product_s_desc', '', 'default', '', VMREQUEST_ALLOWHTML),
    279. 

  279. 						'product_thumb_image' => vmGet($d,'product_thumb_image'),
    280. 

  280. 						'product_full_image' => vmGet($d,'product_full_image'),
    281. 

  281. 						'product_publish' => $d['product_publish'],
    282. 

  282. 						'product_weight' => vmRequest::getFloat('product_weight'),
    283. 

  283. 						'product_weight_uom' => vmGet($d,'product_weight_uom'),
    284. 

  284. 						'product_length' => vmRequest::getFloat('product_length'),
    285. 

  285. 						'product_width' => vmRequest::getFloat('product_width'),
    286. 

  286. 						'product_height' => vmRequest::getFloat('product_height'),
    287. 

  287. 						'product_lwh_uom' => vmGet($d,'product_lwh_uom'),
    288. 

  288. 						'product_unit' => vmGet($d,'product_unit'),
    289. 

  289. 						'product_packaging' => (($d["product_box"] << 16) | ($d["product_packaging"]&0xFFFF)),
    290. 

  290. 						'product_url' => vmGet($d,'product_url'),
    291. 

  291. 						'product_in_stock' => vmRequest::getInt('product_in_stock'),
    292. 

  292. 						'attribute' => ps_product_attribute::formatAttributeX(),
    293. 

  293. 						'custom_attribute' => vmGet($d,'product_custom_attribute'),
    294. 

  294. 						'product_available_date' => $d['product_available_date_timestamp'],
    295. 

  295. 						'product_availability' => vmGet($d,'product_availability'),
    296. 

  296. 						'product_special' => $d['product_special'],
    297. 

  297. 						'child_options' => $d['child_options'],
    298. 

  298. 						'quantity_options' => $d['quantity_options'],
    299. 

  299. 						'product_discount_id' => vmRequest::getInt('product_discount_id'),
    300. 

  300. 						'cdate' => $timestamp,
    301. 

  301. 						'mdate' => $timestamp,
    302. 

  302. 						'product_tax_id' => vmRequest::getInt('product_tax_id'),
    303. 

  303. 						'child_option_ids' => vmGet($d,'included_product_id'),
    304. 

  304. 						'product_order_levels' => $d['order_levels'] );
    305. 

  305. 

  306. 		$db->buildQuery('INSERT', '#__{vm}_product', $fields );
    307. 

  307. 		if( $db->query() === false ) {
    308. 

  308. 			$vmLogger->err( $VM_LANG->_('VM_PRODUCT_ADDING_FAILED',false) );
    309. 

  309. 			return false;
    310. 

  310. 		}
    311. 

  311. 

  312. 		$d["product_id"] = $_REQUEST['product_id'] = $db->last_insert_id();
    313. 

  313. 

  314. 		// If is Item, add attributes from parent //
    315. 

  315. 		if ($d["product_parent_id"]) {
    316. 

  316. 			$q  = "SELECT attribute_name FROM #__{vm}_product_attribute_sku ";
    317. 

  317. 			$q .= "WHERE product_id='" . vmRequest::getInt('product_parent_id') . "' ";
    318. 

  318. 			$q .= "ORDER BY attribute_list,attribute_name";
    319. 

  319. 			$db->query($q);
    320. 

  320. 

  321. 			$db2 = new ps_DB;
    322. 

  322. 			$i = 0;
    323. 

  323. 			while($db->next_record()) {
    324. 

  324. 				$i++;
    325. 

  325.                 
    326. 

  326. 				$q = "INSERT INTO #__{vm}_product_attribute (`product_id`,`attribute_name`,`attribute_value`) VALUES ";
    327. 

  327. 				$q .= "('".$d["product_id"]."', '".$db->f("attribute_name", false)."', '".vmGet($d,'attribute_'.$i )."')";
    328. 

  328. 				$db2->query( $q );
    329. 

  329. 			}
    330. 

  330. 		}
    331. 

  331. 		else {
    332. 

  332. 			// If is Product, Insert category ids
    333. 

  333. 			if( empty( $d['product_categories']) || !is_array(@$d['product_categories'])) {
    334. 

  334. 				$d['product_categories'] = explode('|', $d['category_ids'] );
    335. 

  335. 			}
    336. 

  336. 			foreach( $d["product_categories"] as $category_id ) {
    337. 

  337. 				$db->query('SELECT MAX(`product_list`) as list_order FROM `#__{vm}_product_category_xref` WHERE `category_id`='.$category_id );
    338. 

  338. 				$db->next_record();
    339. 

  339. 

  340. 				$q  = "INSERT INTO #__{vm}_product_category_xref ";
    341. 

  341. 				$q .= "(category_id,product_id,product_list) ";
    342. 

  342. 				$q .= "VALUES ('$category_id','". $d["product_id"] . "', ".intval($db->f('max') +1 ) . ")";
    343. 

  343. 				$db->setQuery($q); $db->query();
    344. 

  344. 			}
    345. 

  345. 		}
    346. 

  346. 		$q = "INSERT INTO #__{vm}_product_mf_xref VALUES (";
    347. 

  347. 		$q .= "'".$d['product_id']."', '".vmRequest::getInt('manufacturer_id')."')";
    348. 

  348. 		$db->setQuery($q); $db->query();
    349. 

  349. 

  350. 		if( !empty($d["related_products"])) {
    351. 

  351. 			/* Insert Pipe separated Related Product IDs */
    352. 

  352. 			$related_products = vmGet( $d, "related_products" );
    353. 

  353. 			$q  = "INSERT INTO #__{vm}_product_relations ";
    354. 

  354. 			$q .= "(product_id, related_products) ";
    355. 

  355. 			$q .= "VALUES ('".$d["product_id"]."','".$db->getEscaped($related_products)."')";
    356. 

  356. 			$db->setQuery($q); $db->query();
    357. 

  357. 

  358. 		}
    359. 

  359. 		// ADD A PRICE, IF NOT EMPTY ADD 0
    360. 

  360. 		if (!empty($d['product_price'])) {
    361. 

  361. 

  362. 			if(empty($d['product_currency'])) {
    363. 

  363. 				$d['product_currency'] = $_SESSION['vendor_currency'];
    364. 

  364. 			}
    365. 

  365. 

  366. 			$d["price_quantity_start"] = 0;
    367. 

  367. 			$d["price_quantity_end"] = "";
    368. 

  368. 			require_once ( CLASSPATH. 'ps_product_price.php');
    369. 

  369. 			$my_price = new ps_product_price;
    370. 

  370. 			$my_price->add($d);
    371. 

  371. 		}
    372. 

  372. 		
    373. 

  373. 		if( !empty( $d['product_type_id'])) {
    374. 

  374. 			require_once( CLASSPATH.'ps_product_product_type.php' );
    375. 

  375. 			$ps_product_product_type = new ps_product_product_type();
    376. 

  376. 			$ps_product_product_type->add( $d );
    377. 

  377. 				
    378. 

  378. 			// Product Type Parameters!
    379. 

  379. 			$this->handleParameters( $d );
    380. 

  380. 		}
    381. 

  381. 		
    382. 

  382. 		// CLONE PRODUCT additional code
    383. 

  383. 		if( $d["clone_product"] == "Y" ) {
    384. 

  384. 

  385. 			// Clone Parent Product's Attributes
    386. 

  386. 			$q  = "INSERT INTO #__{vm}_product_attribute_sku
    387. 

  387.               SELECT '".$d["product_id"]."', attribute_name, attribute_list 
    388. 

  388.               FROM #__{vm}_product_attribute_sku WHERE product_id='" . (int)$d["old_product_id"] . "' ";
    389. 

  389. 			$db->query( $q );
    390. 

  390. 			if( !empty( $d["child_items"] )) {
    391. 

  391. 

  392. 				$database->query( "SHOW COLUMNS FROM #__{vm}_product" );
    393. 

  393. 				$rows = $database->record;
    394. 

  394. 				while(list(,$Field) = each( $rows) ) {
    395. 

  395. 					$product_fields[$Field->Field] = $Field->Field;
    396. 

  396. 				}
    397. 

  397. 				// Change the Field Names
    398. 

  398. 				// leave empty for auto_increment
    399. 

  399. 				$product_fields["product_id"] = "''";
    400. 

  400. 				// Update Product Parent ID to the new one
    401. 

  401. 				$product_fields["product_parent_id"] = "'".$d["product_id"]."'";
    402. 

  402. 				// Rename the SKU
    403. 

  403. 				$product_fields["product_sku"] = "CONCAT(product_sku,'_".$d["product_id"]."')";
    404. 

  404. 

  405. 				$rows = Array();
    406. 

  406. 				$database->query( "SHOW COLUMNS FROM #__{vm}_product_price" );
    407. 

  407. 				$rows = $database->record;
    408. 

  408. 				while(list(,$Field) = each( $rows) ) {
    409. 

  409. 					$price_fields[$Field->Field] = $Field->Field;
    410. 

  410. 				}
    411. 

  411. 

  412. 				foreach( $d["child_items"] as $child_id ) {
    413. 

  413. 					$q = "INSERT INTO #__{vm}_product ";
    414. 

  414. 					$q .= "SELECT ".implode(",", $product_fields )." FROM #__{vm}_product WHERE product_id='$child_id'";
    415. 

  415. 					$db->query( $q );
    416. 

  416. 					$new_product_id = $db->last_insert_id();
    417. 

  417. 

  418. 					$q = "INSERT INTO #__{vm}_product_attribute
    419. 

  419. 			                  SELECT NULL, '$new_product_id', attribute_name, attribute_value
    420. 

  420. 			                  FROM #__{vm}_product_attribute WHERE product_id='$child_id'";
    421. 

  421. 					$db->query( $q );
    422. 

  422. 

  423. 					$price_fields["product_price_id"] = "''";
    424. 

  424. 					$price_fields["product_id"] = "'$new_product_id'";
    425. 

  425. 

  426. 					$q = "INSERT INTO #__{vm}_product_price ";
    427. 

  427. 					$q .= "SELECT ".implode(",", $price_fields )." FROM #__{vm}_product_price WHERE product_id='$child_id'";
    428. 

  428. 					$db->query( $q );
    429. 

  429. 				}
    430. 

  430. 			}
    431. 

  431. 

  432. 			// End Cloning
    433. 

  433. 

  434. 		}
    435. 

  435. 		if( $d['clone_product'] == 'Y') {
    436. 

  436. 			$vmLogger->info( $VM_LANG->_('VM_PRODUCT_CLONED',false) );
    437. 

  437. 		}
    438. 

  438. 		else {
    439. 

  439. 			$vmLogger->info( $VM_LANG->_('VM_PRODUCT_ADDED',false) );
    440. 

  440. 		}
    441. 

  441. 		return true;
    442. 

  442. 	}
    443. 

  443. 

  444. 	/**
    445. 

  445. 	 * Function to update product $d['product_id'] in the product table
    446. 

  446. 	 *
    447. 

  447. 	 * @param array $d The input vars
    448. 

  448. 	 * @return boolean True, when the product was updated, false when not
    449. 

  449. 	 */
    450. 

  450. 	function update( &$d ) {
    451. 

  451. 		global $vmLogger, $perm, $VM_LANG;
    452. 

  452. 		require_once(CLASSPATH.'ps_product_attribute.php');
    453. 

  453. 		
    454. 

  454. 		if (!$this->validate($d)) {
    455. 

  455. 			return false;
    456. 

  456. 		}
    457. 

  457. 

  458. 		if (!vmImageTools::process_images($d)) {
    459. 

  459. 			return false;
    460. 

  460. 		}
    461. 

  461. 

  462. 		$timestamp = time();
    463. 

  463. 		$db = new ps_DB;
    464. 

  464. 		$ps_vendor_id = $_SESSION["ps_vendor_id"];
    465. 

  465. 		if( $perm->check( 'admin' )) {
    466. 

  466. 			$vendor_id = $d['vendor_id'];
    467. 

  467. 		}
    468. 

  468. 		else {
    469. 

  469. 			$vendor_id = $ps_vendor_id;
    470. 

  470. 		}
    471. 

  471. 		$old_vendor_id = $this->get_field($d['product_id'], 'vendor_id');
    472. 

  472. 		
    473. 

  473.         // Insert into DB
    474. 

  474. 		$fields = array ( 'vendor_id' => $vendor_id,
    475. 

  475. 						'product_sku' => vmGet($d,'product_sku'),
    476. 

  476. 						'product_name' => vmGet($d,'product_name'),
    477. 

  477. 						'product_desc' => vmRequest::getVar('product_desc', '', 'default', '', VMREQUEST_ALLOWHTML),
    478. 

  478. 						'product_s_desc' => vmRequest::getVar('product_s_desc', '', 'default', '', VMREQUEST_ALLOWHTML),
    479. 

  479. 						'product_thumb_image' => vmGet($d,'product_thumb_image'),
    480. 

  480. 						'product_full_image' => vmGet($d,'product_full_image'),
    481. 

  481. 						'product_publish' => $d['product_publish'],
    482. 

  482. 						'product_weight' => vmRequest::getFloat('product_weight'),
    483. 

  483. 						'product_weight_uom' => vmGet($d,'product_weight_uom'),
    484. 

  484. 						'product_length' => vmRequest::getFloat('product_length'),
    485. 

  485. 						'product_width' => vmRequest::getFloat('product_width'),
    486. 

  486. 						'product_height' => vmRequest::getFloat('product_height'),
    487. 

  487. 						'product_lwh_uom' => vmGet($d,'product_lwh_uom'),
    488. 

  488. 						'product_unit' => vmGet($d,'product_unit'),
    489. 

  489. 						'product_packaging' => (($d["product_box"] << 16) | ($d["product_packaging"]&0xFFFF)),
    490. 

  490. 						'product_url' => vmGet($d,'product_url'),
    491. 

  491. 						'product_in_stock' => vmRequest::getInt('product_in_stock'),
    492. 

  492. 						'attribute' => ps_product_attribute::formatAttributeX(),
    493. 

  493. 						'custom_attribute' => vmGet($d,'product_custom_attribute'),
    494. 

  494. 						'product_available_date' => $d['product_available_date_timestamp'],
    495. 

  495. 						'product_availability' => vmGet($d,'product_availability'),
    496. 

  496. 						'product_special' => $d['product_special'],
    497. 

  497. 						'child_options' => $d['child_options'],
    498. 

  498. 						'quantity_options' => $d['quantity_options'],
    499. 

  499. 						'product_discount_id' => vmRequest::getInt('product_discount_id'),
    500. 

  500. 						'mdate' => $timestamp,
    501. 

  501. 						'product_tax_id' => vmRequest::getInt('product_tax_id'),
    502. 

  502. 						'child_option_ids' => vmGet($d,'included_product_id'),
    503. 

  503. 						'product_order_levels' => $d['order_levels'] );
    504. 

  504. 						
    505. 

  505. 		$db->buildQuery( 'UPDATE', '#__{vm}_product', $fields,  'WHERE product_id='. (int)$d["product_id"] . ' AND vendor_id=' . (int)$old_vendor_id );
    506. 

  506. 		$db->query();
    507. 

  507. 

  508. 		/* notify the shoppers that the product is here */
    509. 

  509. 		/* see zw_waiting_list */
    510. 

  510. 		if ($d["product_in_stock"] > "0" && @$d['notify_users'] == '1' && $d['product_in_stock_old'] == '0') {
    511. 

  511. 			require_once( CLASSPATH . 'zw_waiting_list.php');
    512. 

  512. 			$zw_waiting_list = new zw_waiting_list;
    513. 

  513. 			$zw_waiting_list->notify_list($d["product_id"]);
    514. 

  514. 		}
    515. 

  515. 

  516. 		$q = "UPDATE #__{vm}_product_mf_xref SET ";
    517. 

  517. 		$q .= 'manufacturer_id='.vmRequest::getInt('manufacturer_id').' ';
    518. 

  518. 		$q .= 'WHERE product_id = '.$d['product_id'];
    519. 

  519. 		$db->query($q);
    520. 

  520. 

  521. 

  522. 		/* If is Item, update attributes */
    523. 

  523. 		if( !empty($d["product_parent_id"])) {
    524. 

  524. 			$q  = "SELECT attribute_name FROM #__{vm}_product_attribute_sku ";
    525. 

  525. 			$q .= 'WHERE product_id=' .(int)$d["product_parent_id"] . ' ';
    526. 

  526. 			$q .= "ORDER BY attribute_list,attribute_name";
    527. 

  527. 			$db->query($q);
    528. 

  528. 

  529. 			$db2 = new ps_DB;
    530. 

  530. 			$i = 0;
    531. 

  531. 			while($db->next_record()) {
    532. 

  532. 				$i++;
    533. 

  533. 				$q2  = "UPDATE #__{vm}_product_attribute SET ";
    534. 

  534. 				$q2 .= "attribute_value='" .vmGet($d,'attribute_'.$i ) . "' ";
    535. 

  535. 				$q2 .= "WHERE product_id = '" . $d["product_id"] . "' ";
    536. 

  536. 				$q2 .= "AND attribute_name = '" . $db->f("attribute_name", false ) . "' ";
    537. 

  537. 				$db2->setQuery($q2); $db2->query();
    538. 

  538. 			}
    539. 

  539. 			/* If it is a Product, update Category */
    540. 

  540. 		}
    541. 

  541. 		else {
    542. 

  542. 			// Handle category selection: product_category_xref
    543. 

  543. 			$q  = "SELECT `category_id` FROM `#__{vm}_product_category_xref` ";
    544. 

  544. 			$q .= "WHERE `product_id` = '" . $d["product_id"] . "' ";
    545. 

  545. 			$db->setQuery($q);
    546. 

  546. 			$db->query();
    547. 

  547. 			$old_categories = array();
    548. 

  548. 			while( $db->next_record()) {
    549. 

  549. 				$old_categories[$db->f('category_id')] = $db->f('category_id');
    550. 

  550. 			}
    551. 

  551. 			// NOW Insert new categories
    552. 

  552. 			$new_categories = array();
    553. 

  553. 			
    554. 

  554. 			if( empty( $d['product_categories']) || !is_array(@$d['product_categories'])) {
    555. 

  555. 				$d['product_categories'] = explode('|', $d['category_ids'] );
    556. 

  556. 			}
    557. 

  557. 			
    558. 

  558. 			foreach( $d["product_categories"] as $category_id ) {
    559. 

  559. 				if( !in_array( $category_id, $old_categories ) ) {
    560. 

  560. 					$db->query('SELECT MAX(`product_list`) as list_order FROM `#__{vm}_product_category_xref` WHERE `category_id`='.(int)$category_id );
    561. 

  561. 					$db->next_record();
    562. 

  562. 

  563. 					$q  = "INSERT INTO #__{vm}_product_category_xref ";
    564. 

  564. 					$q .= "(category_id,product_id,product_list) ";
    565. 

  565. 					$q .= "VALUES ('".(int)$category_id."','". $d["product_id"] . "', ".intval($db->f('max') +1 ) . ")";
    566. 

  566. 					$db->setQuery($q); $db->query();
    567. 

  567. 					$new_categories[$category_id] = $category_id;
    568. 

  568. 				}
    569. 

  569. 				else {
    570. 

  570. 					unset( $old_categories[$category_id]);
    571. 

  571. 				}
    572. 

  572. 			}
    573. 

  573. 			// The rest of the old categories can be deleted
    574. 

  574. 			foreach( $old_categories as $category_id ) {
    575. 

  575. 				$q  = "DELETE FROM `#__{vm}_product_category_xref` ";
    576. 

  576. 				$q .= "WHERE `product_id` = '" . $d["product_id"] . "' ";
    577. 

  577. 				$q .= "AND `category_id` = '" . $category_id . "' ";
    578. 

  578. 				$db->query($q);
    579. 

  579. 			}
    580. 

  580. 		}
    581. 

  581. 

  582. 		if( !empty($d["related_products"])) {
    583. 

  583. 			/* Insert Pipe separated Related Product IDs */
    584. 

  584. 			$related_products = vmGet( $d, "related_products" );
    585. 

  585. 			$q  = "REPLACE INTO #__{vm}_product_relations (product_id, related_products)";
    586. 

  586. 			$q .= " VALUES( '".$d["product_id"]."', '$related_products') ";
    587. 

  587. 			$db->query($q);
    588. 

  588. 

  589. 		}
    590. 

  590. 		else{
    591. 

  591. 			$q  = "DELETE FROM #__{vm}_product_relations WHERE product_id='".$d["product_id"]."'";
    592. 

  592. 			$db->query($q);
    593. 

  593. 		}
    594. 

  594. 

  595. 		// UPDATE THE PRICE, IF EMPTY ADD 0
    596. 

  596. 		if(empty($d['product_currency'])) {
    597. 

  597. 			$d['product_currency'] = $_SESSION['vendor_currency'];
    598. 

  598. 		}
    599. 

  599. 

  600. 		// look if we have a price for this product
    601. 

  601. 		$q = "SELECT product_price_id, price_quantity_start, price_quantity_end FROM #__{vm}_product_price ";
    602. 

  602. 		$q .= "WHERE shopper_group_id=" . vmRequest::getInt('shopper_group_id');
    603. 

  603. 		$q .= ' AND product_id = ' . $d["product_id"];
    604. 

  604. 		$db->query($q);
    605. 

  605. 

  606. 

  607. 		if ($db->next_record()) {
    608. 

  608. 

  609. 			$d["product_price_id"] = $db->f("product_price_id");
    610. 

  610. 			require_once ( CLASSPATH. 'ps_product_price.php');
    611. 

  611. 			$my_price = new ps_product_price;
    612. 

  612. 

  613. 			if (@$d['product_price'] != '') {
    614. 

  614. 				// update prices
    615. 

  615. 				$d["price_quantity_start"] = $db->f("price_quantity_start");
    616. 

  616. 				$d["price_quantity_end"] = $db->f("price_quantity_end");
    617. 

  617. 

  618. 				$my_price->update($d);
    619. 

  619. 			}
    620. 

  620. 			else {
    621. 

  621. 				// delete the price
    622. 

  622. 				$my_price->delete( $d );
    623. 

  623. 			}
    624. 

  624. 		}
    625. 

  625. 		else {
    626. 

  626. 			if ( $d['product_price'] != '' ) {
    627. 

  627. 				// add the price
    628. 

  628. 				$d["price_quantity_start"] = 0;
    629. 

  629. 				$d["price_quantity_end"] = "";
    630. 

  630. 				require_once ( CLASSPATH. 'ps_product_price.php');
    631. 

  631. 				$my_price = new ps_product_price;
    632. 

  632. 				$my_price->add($d);
    633. 

  633. 			}
    634. 

  634. 		}
    635. 

  635. 

  636. 		// Product Type Parameters!
    637. 

  637. 		$this->handleParameters( $d );
    638. 

  638. 		 
    639. 

  639. 		$vmLogger->info( $VM_LANG->_('VM_PRODUCT_UPDATED',false) );
    640. 

  640. 		return true;
    641. 

  641. 	}
    642. 

  642. 	
    643. 

  643. 	/**
    644. 

  644. 	 * Handles adding or updating parameter values for a product an its product types
    645. 

  645. 	 * @since VirtueMart 1.1.0
    646. 

  646. 	 * @param array $d
    647. 

  647. 	 */
    648. 

  648. 	function handleParameters( &$d ) {
    649. 

  649. 		global $db;
    650. 

  650. 		
    651. 

  651. 		$product_id= intval( $d["product_id"] );
    652. 

  652. 

  653. 		$q  = "SELECT `product_type_id` FROM `#__{vm}_product_product_type_xref` WHERE ";
    654. 

  654. 		$q .= "`product_id`=$product_id";
    655. 

  655. 		$db->query($q);
    656. 

  656. 

  657. 		$dbpt = new ps_DB;
    658. 

  658. 		$dbp = new ps_DB;
    659. 

  659. 

  660. 		// For every Product Type
    661. 

  661. 		while ($db->next_record()) {
    662. 

  662. 			$product_type_id = $db->f("product_type_id");
    663. 

  663. 

  664. 			$q  = "SELECT * FROM #__{vm}_product_type_parameter WHERE ";
    665. 

  665. 			$q .= "product_type_id='$product_type_id' ";
    666. 

  666. 			$q .= "ORDER BY parameter_list_order";
    667. 

  667. 			$dbpt->query($q);
    668. 

  668. 

  669. 			$q  = "SELECT COUNT(`product_id`) as num_rows FROM `#__{vm}_product_type_$product_type_id` WHERE ";
    670. 

  670. 			$q .= "product_id='$product_id'";
    671. 

  671. 			$dbp->query($q); $dbp->next_record();
    672. 

  672. 			
    673. 

  673. 			if ( $dbp->f('num_rows') == 0 ) {  // Add record if not exist (Items)
    674. 

  674. 				$q  = "INSERT INTO #__{vm}_product_type_$product_type_id (product_id) ";
    675. 

  675. 				$q .= "VALUES ('$product_id')";
    676. 

  676. 				$dbp->query($q);
    677. 

  677. 			}
    678. 

  678. 

  679. 			// Update record
    680. 

  680. 			$q  = "UPDATE #__{vm}_product_type_$product_type_id SET ";
    681. 

  681. 			$q .= "product_id='$product_id'";
    682. 

  682. 			while ($dbpt->next_record()) {
    683. 

  683. 				if ($dbpt->f("parameter_type")!="B") { // if it is not breaker
    684. 

  684. 					$value=$d["product_type_".$product_type_id."_".$dbpt->f("parameter_name")];
    685. 

  685. 					if ($dbpt->f("parameter_type")=="V" && is_array($value)) {
    686. 

  686. 						$value = join(';',$value);
    687. 

  687. 					}
    688. 

  688. 					if ($value=="") {
    689. 

  689. 						$value='NULL'; 
    690. 

  690. 					}
    691. 

  691. 					else { 
    692. 

  692. 						$value="'".$dbpt->getEscaped($value)."'"; 
    693. 

  693. 					}
    694. 

  694. 					$q .= ',`'.$dbpt->f('parameter_name', false).'`='.$value;
    695. 

  695. 				}
    696. 

  696. 			}
    697. 

  697. 			$q .= ' WHERE product_id = '.$d['product_id'];
    698. 

  698. 			$dbp->query($q);
    699. 

  699. 		}
    700. 

  700. 

  701. 	}
    702. 

  702. 	
    703. 

  703. 	/**
    704. 

  704. 	 * Function to delete product(s) $d['product_id'] from the product table
    705. 

  705. 	 *
    706. 

  706. 	 * @param array $d The input vars
    707. 

  707. 	 * @return boolean True, when the product was deleted, false when not
    708. 

  708. 	 */
    709. 

  709. 	function delete(&$d) {
    710. 

  710. 

  711. 		$product_id = $d["product_id"];
    712. 

  712. 

  713. 		if( is_array( $product_id)) {
    714. 

  714. 			foreach( $product_id as $product) {
    715. 

  715. 				if( !$this->delete_product( $product, $d ))
    716. 

  716. 				return false;
    717. 

  717. 			}
    718. 

  718. 			return true;
    719. 

  719. 		}
    720. 

  720. 		else {
    721. 

  721. 			return $this->delete_product( $product_id, $d );
    722. 

  722. 		}
    723. 

  723. 	}
    724. 

  724. 	/**
    725. 

  725.          * Move a product from one category to another
    726. 

  726.          *
    727. 

  727.          * @param array $d
    728. 

  728.          * @return boolean True on sucess, false on failure
    729. 

  729.          */
    730. 

  730. 	function move( &$d ) {
    731. 

  731. 		global $db, $vmLogger, $VM_LANG;
    732. 

  732. 		if( !is_array( $d['product_id'])) {
    733. 

  733. 			$vmLogger->err( $VM_LANG->_('VM_PRODUCT_MOVE_NOTFOUND',false));
    734. 

  734. 			return false;
    735. 

  735. 		}
    736. 

  736. 		if( empty( $d['category_id'])) {
    737. 

  737. 			$vmLogger->err( $VM_LANG->_('VM_PRODUCT_MUSTSELECT_ONE_CAT',false));
    738. 

  738. 			return false;
    739. 

  739. 		}
    740. 

  740. 		// Loop though each product
    741. 

  741. 		foreach( $d['product_id'] as $product_id ) {
    742. 

  742. 			// check if the product is already assigned to the category it should be moved to
    743. 

  743. 			$db->query( 'SELECT product_id FROM `#__{vm}_product_category_xref` WHERE `product_id`='.intval($product_id).' AND `category_id`='.intval($d['category_id']));
    744. 

  744. 			if( !$db->next_record()) {
    745. 

  745. 				// If the product is not yet in this category, move it!
    746. 

  746. 				$db->query( 'SELECT MAX(`product_list`) as max FROM `#__{vm}_product_category_xref` WHERE `category_id`='.intval($d['category_id']));
    747. 

  747. 				$db->next_record();
    748. 

  748. 				$db->query('INSERT INTO `#__{vm}_product_category_xref` VALUES ('.intval($d['category_id']).', '.intval($product_id).', '.intval( $db->f('max') + 1) .') ');
    749. 

  749. 			}
    750. 

  750. 			$db->query('DELETE FROM `#__{vm}_product_category_xref` WHERE `product_id`='.intval($product_id).' AND `category_id`='.intval($d['old_category_id']));
    751. 

  751. 		}
    752. 

  752. 		return true;
    753. 

  753. 	}
    754. 

  754. 

  755. 	/**
    756. 

  756. 	 * The function that holds the code for deleting
    757. 

  757. 	 * one product from the database and all related tables
    758. 

  758. 	 * plus deleting files related to the product
    759. 

  759. 	 *
    760. 

  760. 	 * @param int $product_id
    761. 

  761. 	 * @param array $d The input vars
    762. 

  762. 	 * @return boolean True on success, false on error
    763. 

  763. 	 */
    764. 

  764. 	function delete_product( $product_id, &$d ) {
    765. 

  765. 		global $vmLogger, $VM_LANG;
    766. 

  766. 		$db = new ps_DB;
    767. 

  767. 		if (!$this->validate_delete($product_id, $d)) {
    768. 

  768. 			return false;
    769. 

  769. 		}
    770. 

  770. 		/* If is Product */
    771. 

  771. 		if ($this->is_product($product_id)) {
    772. 

  772. 			/* Delete all items first */
    773. 

  773. 			$q  = "SELECT product_id FROM #__{vm}_product WHERE product_parent_id='$product_id'";
    774. 

  774. 			$db->setQuery($q); $db->query();
    775. 

  775. 			while($db->next_record()) {
    776. 

  776. 				$d2["product_id"] = $db->f("product_id");
    777. 

  777. 				if (!$this->delete($d2)) {
    778. 

  778. 					return false;
    779. 

  779. 				}
    780. 

  780. 			}
    781. 

  781. 

  782. 			/* Delete attributes */
    783. 

  783. 			$q  = "DELETE FROM #__{vm}_product_attribute_sku WHERE product_id='$product_id' ";
    784. 

  784. 			$db->setQuery($q); $db->query();
    785. 

  785. 

  786. 			/* Delete categories xref */
    787. 

  787. 			$q  = "DELETE FROM #__{vm}_product_category_xref WHERE product_id = '$product_id' ";
    788. 

  788. 			$db->setQuery($q); $db->query();
    789. 

  789. 		}
    790. 

  790. 		/* If is Item */
    791. 

  791. 		else {
    792. 

  792. 			/* Delete attribute values */
    793. 

  793. 			$q  = "DELETE FROM #__{vm}_product_attribute WHERE product_id='$product_id'";
    794. 

  794. 			$db->setQuery($q); $db->query();
    795. 

  795. 		}
    796. 

  796. 		/* For both Product and Item */
    797. 

  797. 

  798. 		/* Delete product - manufacturer xref */
    799. 

  799. 		$q = "DELETE FROM #__{vm}_product_mf_xref WHERE product_id='$product_id'";
    800. 

  800. 		$db->setQuery($q); $db->query();
    801. 

  801. 

  802. 		/* Delete Product - ProductType Relations */
    803. 

  803. 		$q  = "DELETE FROM `#__{vm}_product_product_type_xref` WHERE `product_id`=$product_id";
    804. 

  804. 		$db->setQuery($q); $db->query();
    805. 

  805. 

  806. 		/* Delete product votes */
    807. 

  807. 		$q  = "DELETE FROM #__{vm}_product_votes WHERE product_id='$product_id'";
    808. 

  808. 		$db->setQuery($q); $db->query();
    809. 

  809. 

  810. 		/* Delete product reviews */
    811. 

  811. 		$q = "DELETE FROM #__{vm}_product_reviews WHERE product_id='$product_id'";
    812. 

  812. 		$db->setQuery($q); $db->query();
    813. 

  813. 

  814. 		/* Delete Image files */
    815. 

  815. 		if (!vmImageTools::process_images($d)) {
    816. 

  816. 			return false;
    817. 

  817. 		}
    818. 

  818. 		/* Delete other Files and Images files */
    819. 

  819. 		require_once(  CLASSPATH.'ps_product_files.php' );
    820. 

  820. 		$ps_product_files = new ps_product_files();
    821. 

  821. 

  822. 		$db->query( "SELECT file_id FROM #__{vm}_product_files WHERE file_product_id='$product_id'" );
    823. 

  823. 		while($db->next_record()) {
    824. 

  824. 			$d["file_id"] = $db->f("file_id");
    825. 

  825. 			$ps_product_files->delete( $d );
    826. 

  826. 		}
    827. 

  827. 

  828. 		/* Delete Product Relations */
    829. 

  829. 		$q  = "DELETE FROM #__{vm}_product_relations WHERE product_id = '$product_id'";
    830. 

  830. 		$db->setQuery($q); $db->query();
    831. 

  831. 

  832. 		/* Delete Prices */
    833. 

  833. 		$q  = "DELETE FROM #__{vm}_product_price WHERE product_id = '$product_id'";
    834. 

  834. 		$db->setQuery($q); $db->query();
    835. 

  835. 

  836. 		/* Delete entry FROM #__{vm}_product table */
    837. 

  837. 		$q  = "DELETE FROM #__{vm}_product WHERE product_id = '$product_id'";
    838. 

  838. 		$db->setQuery($q); $db->query();
    839. 

  839. 

  840. 		/* If only deleting an item, go to the parent product page after
    841. 

  841. 		** the deletion. This had to be done here because the product id
    842. 

  842. 		** of the item to be deleted had to be passed as product_id */
    843. 

  843. 		if (!empty($d["product_parent_id"])) {
    844. 

  844. 			$d["product_id"] = $d["product_parent_id"];
    845. 

  845. 			$d["product_parent_id"] = "";
    846. 

  846. 		}
    847. 

  847. 		$vmLogger->info( str_replace('{product_id}',$product_id,$VM_LANG->_('VM_PRODUCT_DELETED',false)) );
    848. 

  848. 		return true;
    849. 

  849. 	}
    850. 

  850. 

  851. 	/**
    852. 

  852. 	 * Function to check if the vendor_id of the product
    853. 

  853. 	 * $d['product_id'] matches the vendor_id associated with the
    854. 

  854. 	 * user that calls this function
    855. 

  855. 	 *
    856. 

  856. 	 * @param array $d
    857. 

  857. 	 * @return boolean True, when vendor_id matches, false when not
    858. 

  858. 	 */
    859. 

  859. 	function check_vendor($d) {
    860. 

  860. 

  861. 		$ps_vendor_id = $_SESSION["ps_vendor_id"];
    862. 

  862. 

  863. 		$db = new ps_DB;
    864. 

  864. 		$q  = "SELECT vendor_id  FROM #__{vm}_product ";
    865. 

  865. 		$q .= "WHERE vendor_id = '$ps_vendor_id' ";
    866. 

  866. 		$q .= "AND product_id = '" . $d["product_id"] . "' ";
    867. 

  867. 		$db->query($q);
    868. 

  868. 		if ($db->next_record()) {
    869. 

  869. 			return true;
    870. 

  870. 		} else {
    871. 

  871. 			return false;
    872. 

  872. 		}
    873. 

  873. 	}
    874. 

  874. 

  875. 

  876. 	/**
    877. 

  877. 	 * Function to create a ps_DB object holding the data of product $d['product_id']
    878. 

  878. 	 * from the table #__{vm}_product
    879. 

  879. 	 *
    880. 

  880. 	 * @param int $product_id
    881. 

  881. 	 * @return ps_DB DB object holding all data for product $product_id
    882. 

  882. 	 */
    883. 

  883. 	function sql($product_id) {
    884. 

  884. 		$db = new ps_DB;
    885. 

  885. 		if( !empty( $product_id )) {
    886. 

  886. 			$q  = 'SELECT * FROM #__{vm}_product WHERE product_id=' . (int)$product_id;
    887. 

  887. 			$db->setQuery($q); $db->query(); 
    888. 

  888. 		}
    889. 

  889. 		return $db;
    890. 

  890. 	}
    891. 

  891. 

  892. 	/**
    893. 

  893. 	 * Function to create a db object holding the data of all child items of
    894. 

  894. 	 * product $product_id
    895. 

  895. 	 *
    896. 

  896. 	 * @param int $product_id
    897. 

  897. 	 * @return ps_DB object that holds all items of product $product_id
    898. 

  898. 	 */
    899. 

  899. 	function items_sql($product_id) {
    900. 

  900. 		$db = new ps_DB;
    901. 

  901. 		if( !empty($product_id) ) {
    902. 

  902. 			$q  = "SELECT * FROM #__{vm}_product ";
    903. 

  903. 			$q .= "WHERE product_parent_id=".(int)$product_id.' ';
    904. 

  904. 			$q .= "ORDER BY product_name";
    905. 

  905. 	
    906. 

  906. 			$db->setQuery($q); $db->query();
    907. 

  907. 		}
    908. 

  908. 

  909. 		return $db;
    910. 

  910. 	}
    911. 

  911. 

  912. 	/**
    913. 

  913. 	 * Function to check whether a product is a parent product or not
    914. 

  914. 	 * If is is a child product, it has a non-empty value for "product_parent_id"
    915. 

  915. 	 *
    916. 

  916. 	 * @param int $product_id
    917. 

  917. 	 * @return boolean True when the product is a parent product, false when product is a child item
    918. 

  918. 	 */
    919. 

  919. 	function is_product($product_id) {
    920. 

  920. 		$product_parent_id = ps_product::get_field($product_id, 'product_parent_id');
    921. 

  921. 		return $product_parent_id == 0;
    922. 

  922. 	}
    923. 

  923. 	/**
    924. 

  924. 	 * Function to check whether a product is published
    925. 

  925. 	 *
    926. 

  926. 	 *
    927. 

  927. 	 * @param int $product_id
    928. 

  928. 	 * @return boolean True when the product is a parent product, false when product is a child item
    929. 

  929. 	 */
    930. 

  930. 	function is_published($product_id, $check_stock=false) {
    931. 

  931. 		if( CHECK_STOCK != '1') $check_stock=false;
    932. 

  932. 		return ps_product::get_field($product_id, 'product_publish') == 'Y';
    933. 

  933. 

  934. 	}
    935. 

  935. 	/**
    936. 

  936. 	 * Checks if a product is a downloadable product
    937. 

  937. 	 *
    938. 

  938. 	 * @param int $product_id
    939. 

  939. 	 * @return boolean
    940. 

  940. 	 */
    941. 

  941. 	function is_downloadable($product_id) {
    942. 

  942. 		if( empty( $GLOBALS['product_info'][$product_id]['is_downloadable'] )) {
    943. 

  943. 		    $db_check = new ps_DB;
    944. 

  944. 	        $q_dl = "SELECT attribute_name,attribute_value 
    945. 

  945. 	        				FROM #__{vm}_product_attribute WHERE
    946. 

  946. 							product_id=".(int)$product_id." AND attribute_name='download'";
    947. 

  947. 			$db_check->query($q_dl);
    948. 

  948. 			$db_check->next_record();
    949. 

  949. 			if( $db_check->num_rows() > 0 ) {
    950. 

  950. 				$GLOBALS['product_info'][$product_id]['is_downloadable'] = 'Y';
    951. 

  951. 			} else {
    952. 

  952. 				$GLOBALS['product_info'][$product_id]['is_downloadable'] = 'N';
    953. 

  953. 			}
    954. 

  954. 		}
    955. 

  955. 		return $GLOBALS['product_info'][$product_id]['is_downloadable'] == 'Y';
    956. 

  956. 	}
    957. 

  957. 	/**
    958. 

  958. 	 * Function to create a DB object that holds all information
    959. 

  959. 	 * from the attribute tables about item $item_id AND/OR product $product_id
    960. 

  960. 	 *
    961. 

  961. 	 * @param int $item_id The product_id of the item
    962. 

  962. 	 * @param int $product_id The product_id of the parent product
    963. 

  963. 	 * @param string $attribute_name The name of the attribute to filter
    964. 

  964. 	 * @return ps_DB The db object...
    965. 

  965. 	 */
    966. 

  966. 	function attribute_sql($item_id="",$product_id="",$attribute_name="") {
    967. 

  967. 		$db = new ps_DB;
    968. 

  968. 		if ($item_id and $product_id) {
    969. 

  969. 			$q  = "SELECT * FROM #__{vm}_product_attribute,#__{vm}_product_attribute_sku ";
    970. 

  970. 			$q .= "WHERE #__{vm}_product_attribute.product_id = '$item_id' ";
    971. 

  971. 			$q .= "AND #__{vm}_product_attribute_sku.product_id ='$product_id' ";
    972. 

  972. 			if ($attribute_name) {
    973. 

  973. 				$q .= "AND #__{vm}_product_attribute.attribute_name = $attribute_name ";
    974. 

  974. 			}
    975. 

  975. 			$q .= "AND #__{vm}_product_attribute.attribute_name = ";
    976. 

  976. 			$q .=     "#__{vm}_product_attribute_sku.attribute_name ";
    977. 

  977. 			$q .= "ORDER BY attribute_list,#__{vm}_product_attribute.attribute_name";
    978. 

  978. 		} elseif ($item_id) {
    979. 

  979. 			$q  = "SELECT * FROM #__{vm}_product_attribute ";
    980. 

  980. 			$q .= "WHERE product_id=$item_id ";
    981. 

  981. 			if ($attribute_name) {
    982. 

  982. 				$q .= "AND attribute_name = '$attribute_name' ";
    983. 

  983. 			}
    984. 

  984. 		} elseif ($product_id) {
    985. 

  985. 			$q  = "SELECT * FROM #__{vm}_product_attribute_sku ";
    986. 

  986. 			$q .= "WHERE product_id =".(int)$product_id.' ';
    987. 

  987. 			if ($attribute_name) {
    988. 

  988. 				$q .= "AND #__{vm}_product_attribute.attribute_name = $attribute_name ";
    989. 

  989. 			}
    990. 

  990. 			$q .= "ORDER BY attribute_list,attribute_name";
    991. 

  991. 		} else {
    992. 

  992. 			/* Error: no arguments were provided. */
    993. 

  993. 			return 0;
    994. 

  994. 		}
    995. 

  995. 

  996. 		$db->setQuery($q); $db->query();
    997. 

  997. 

  998. 		return $db;
    999. 

  999. 	}
    1000. 

  1000. 

  1001. 	/**
    1002. 

  1002. 	 * Function to return the product ids of all child items of product $pid
    1003. 

  1003. 	 *
    1004. 

  1004. 	 * @param int $pid The ID of the parent product
    1005. 

  1005. 	 * @return array $list
    1006. 

  1006. 	 */
    1007. 

  1007. 	function get_child_product_ids($pid) {
    1008. 

  1008. 		$db = new ps_DB;
    1009. 

  1009. 		$q  = "SELECT product_id FROM #__{vm}_product ";
    1010. 

  1010. 		$q .= "WHERE product_parent_id='$pid' ";
    1011. 

  1011. 

  1012. 		$db->setQuery($q); $db->query();
    1013. 

  1013. 

  1014. 		$i = 0;
    1015. 

  1015. 		$list = Array();
    1016. 

  1016. 		while($db->next_record()) {
    1017. 

  1017. 			$list[$i] = $db->f("product_id");
    1018. 

  1018. 			$i++;
    1019. 

  1019. 		}
    1020. 

  1020. 		return $list;
    1021. 

  1021. 	}
    1022. 

  1022. 

  1023. 	/**
    1024. 

  1024. 	 * Function to quickly check whether a product has child products or not
    1025. 

  1025. 	 *
    1026. 

  1026. 	 * @param int $pid The id of the product to check
    1027. 

  1027. 	 * @return boolean True when the product has childs, false when not
    1028. 

  1028. 	 */
    1029. 

  1029. 	function parent_has_children($pid) {
    1030. 

  1030. 		$db = new ps_DB;
    1031. 

  1031. 		if( empty($GLOBALS['product_info'][$pid]["parent_has_children"] )) {
    1032. 

  1032. 			$q  = "SELECT COUNT(product_id) as num_rows FROM #__{vm}_product WHERE product_parent_id='$pid' ";
    1033. 

  1033. 			$db->query($q);
    1034. 

  1034. 			$db->next_record();
    1035. 

  1035. 			if( $db->f('num_rows') > 0 ) {
    1036. 

  1036. 				$GLOBALS['product_info'][$pid]["parent_has_children"] = True;
    1037. 

  1037. 			}
    1038. 

  1038. 			else {
    1039. 

  1039. 				$GLOBALS['product_info'][$pid]["parent_has_children"] = False;
    1040. 

  1040. 			}
    1041. 

  1041. 		}
    1042. 

  1042. 		return $GLOBALS['product_info'][$pid]["parent_has_children"];
    1043. 

  1043. 	}
    1044. 

  1044. 

  1045. 	/**
    1046. 

  1046. 	 * Function to quickly check whether a product has attributes or not
    1047. 

  1047. 	 *
    1048. 

  1048. 	 * @param int $pid The id of the product to check
    1049. 

  1049. 	 * @return boolean True when the product has attributes, false when not
    1050. 

  1050. 	 */
    1051. 

  1051. 	function product_has_attributes($pid, $checkSimpleAttributes=false ) {
    1052. 

  1052. 		if( is_array($pid) || empty($pid)) {
    1053. 

  1053. 			return false;
    1054. 

  1054. 		}
    1055. 

  1055. 		$pid = intval( $pid );
    1056. 

  1056. 		$db = new ps_DB;
    1057. 

  1057. 		if( empty($GLOBALS['product_info'][$pid]["product_has_attributes"] )) {
    1058. 

  1058. 			$db->query( "SELECT `product_id` FROM `#__{vm}_product_attribute_sku` WHERE `product_id`=$pid");
    1059. 

  1059. 			if ($db->next_record()) {
    1060. 

  1060. 				$GLOBALS['product_info'][$pid]["product_has_attributes"] = True;
    1061. 

  1061. 			}
    1062. 

  1062. 			elseif( $checkSimpleAttributes ) {
    1063. 

  1063. 				$db->query( "SELECT `attribute`,`custom_attribute` FROM `#__{vm}_product` WHERE `product_id`=$pid");
    1064. 

  1064. 				$db->next_record();
    1065. 

  1065. 				if( $db->f('attribute') || $db->f('custom_attribute')) {
    1066. 

  1066. 					$GLOBALS['product_info'][$pid]["product_has_attributes"] = True;
    1067. 

  1067. 				}
    1068. 

  1068. 				else {
    1069. 

  1069. 					$GLOBALS['product_info'][$pid]["product_has_attributes"] = False;
    1070. 

  1070. 				}
    1071. 

  1071. 			}
    1072. 

  1072. 			else {
    1073. 

  1073. 				$GLOBALS['product_info'][$pid]["product_has_attributes"] = False;
    1074. 

  1074. 			}
    1075. 

  1075. 		}
    1076. 

  1076. 		return $GLOBALS['product_info'][$pid]["product_has_attributes"];
    1077. 

  1077. 	}
    1078. 

  1078. 

  1079. 	/**
    1080. 

  1080. 	 * Get the value of the field $field_name for product $product_id from the product table
    1081. 

  1081. 	 *
    1082. 

  1082. 	 * @param int $product_id
    1083. 

  1083. 	 * @param string $field_name
    1084. 

  1084. 	 * @return string The value of the field $field_name for that product
    1085. 

  1085. 	 */
    1086. 

  1086. 	function get_field( $product_id, $field_name, $force = false ) {
    1087. 

  1087. 		if( $product_id == 0 ) return '';
    1088. 

  1088. 		$db = new ps_DB;
    1089. 

  1089. 		
    1090. 

  1090. 		if( !isset($GLOBALS['product_info'][$product_id][$field_name] ) || $force ) {
    1091. 

  1091. 			$q = 'SELECT product_id, `#__{vm}_product`.* FROM `#__{vm}_product` WHERE `product_id`='.(int)$product_id;
    1092. 

  1092. 			$db->query($q);
    1093. 

  1093. 			if ($db->next_record()) {
    1094. 

  1094. 				$values = get_object_vars( $db->getCurrentRow() );
    1095. 

  1095. 				
    1096. 

  1096. 				foreach( $values as $key => $value ) {
    1097. 

  1097. 					$GLOBALS['product_info'][$product_id][$key] = $value;
    1098. 

  1098. 				}
    1099. 

  1099. 				if( !isset( $GLOBALS['product_info'][$product_id][$field_name] ) && !is_null($GLOBALS['product_info'][$product_id][$field_name])) {
    1100. 

  1100. 					$GLOBALS['vmLogger']->debug( 'The Field '.$field_name. ' does not exist in the product table!');
    1101. 

  1101. 					$GLOBALS['product_info'][$product_id][$field_name] = true;
    1102. 

  1102. 				}
    1103. 

  1103. 			}
    1104. 

  1104. 			else {
    1105. 

  1105. 				$GLOBALS['product_info'][$product_id][$field_name] = false;
    1106. 

  1106. 			}
    1107. 

  1107. 		}
    1108. 

  1108. 		return $GLOBALS['product_info'][$product_id][$field_name];
    1109. 

  1109. 	}
    1110. 

  1110. 

  1111. 	/**
    1112. 

  1112. 	 * Sets a global value for a fieldname for a specific product
    1113. 

  1113. 	 * Is to be used by other scripts to populate a field value for a prodct
    1114. 

  1114. 	 * that was already fetched from the database - so it doesn't need to e fetched again
    1115. 

  1115. 	 * Can be also used to override a value
    1116. 

  1116. 	 *
    1117. 

  1117. 	 * @param int $product_id
    1118. 

  1118. 	 * @param string $field_name
    1119. 

  1119. 	 * @param mixed $value
    1120. 

  1120. 	 */
    1121. 

  1121. 	function set_field( $product_id, $field_name, $value ) {
    1122. 

  1122. 

  1123. 		$GLOBALS['product_info'][$product_id][$field_name] = $value;
    1124. 

  1124. 

  1125. 	}
    1126. 

  1126. 

  1127. 	/**
    1128. 

  1128. 	 * This is a very time consuming function. 
    1129. 

  1129. 	 * It fetches the category flypage for a specific product id
    1130. 

  1130. 	 *
    1131. 

  1131. 	 * @param int $product_id
    1132. 

  1132. 	 * @return string The flypage value for that product
    1133. 

  1133. 	 */
    1134. 

  1134. 	function get_flypage($product_id) {
    1135. 

  1135. 

  1136. 		if( empty( $_SESSION['product_sess'][$product_id]['flypage'] )) {
    1137. 

  1137. 			$db = new ps_DB;
    1138. 

  1138. 			$productParentId = (int)$product_id;
    1139. 

  1139. 			do {
    1140. 

  1140. 				$q = "SELECT
    1141. 

  1141.                                 `#__{vm}_product`.`product_parent_id` AS product_parent_id,
    1142. 

  1142.                                 `#__{vm}_category`.`category_flypage`
    1143. 

  1143.                         FROM
    1144. 

  1144.                                 `#__{vm}_product`
    1145. 

  1145. 

  1146.                         LEFT JOIN `#__{vm}_product_category_xref` ON `#__{vm}_product_category_xref`.`product_id` = `#__{vm}_product`.`product_id`
    1147. 

  1147.                         LEFT JOIN `#__{vm}_category` ON `#__{vm}_product_category_xref`.`category_id` = `#__{vm}_category`.`category_id`
    1148. 

  1148. 

  1149.                         WHERE `#__{vm}_product`.`product_id`='$productParentId'
    1150. 

  1150.                         ";
    1151. 

  1151. 				$productParentId = $db->f("product_parent_id");
    1152. 

  1152. 				$db->query($q);
    1153. 

  1153. 				$db->next_record();
    1154. 

  1154. 			} 
    1155. 

  1155. 			while( $db->f("product_parent_id") && !$db->f("category_flypage"));
    1156. 

  1156. 

  1157. 			if ($db->f("category_flypage")) {
    1158. 

  1158. 				$_SESSION['product_sess'][$product_id]['flypage'] = $db->f("category_flypage");
    1159. 

  1159. 			} else {
    1160. 

  1160. 				$_SESSION['product_sess'][$product_id]['flypage'] = FLYPAGE;
    1161. 

  1161. 			}
    1162. 

  1162. 		}
    1163. 

  1163. 		return $_SESSION['product_sess'][$product_id]['flypage'];
    1164. 

  1164. 	}
    1165. 

  1165. 

  1166. 	/**
    1167. 

  1167. 	 * Function to get the name of the vendor the product is associated with
    1168. 

  1168. 	 *
    1169. 

  1169. 	 * @param int $product_id
    1170. 

  1170. 	 * @return string The name of the vendor
    1171. 

  1171. 	 */
    1172. 

  1172. 	function get_vendorname($product_id) {
    1173. 

  1173. 		$db = new ps_DB;
    1174. 

  1174. 

  1175. 		$q = "SELECT #__{vm}_vendor.vendor_name FROM #__{vm}_product, #__{vm}_vendor ";
    1176. 

  1176. 		$q .= "WHERE #__{vm}_product.product_id='$product_id' ";
    1177. 

  1177. 		$q .= "AND #__{vm}_vendor.vendor_id=#__{vm}_product.vendor_id";
    1178. 

  1178. 

  1179. 		$db->query($q);
    1180. 

  1180. 		$db->next_record();
    1181. 

  1181. 		if ($db->f("vendor_name")) {
    1182. 

  1182. 			return $db->f("vendor_name");
    1183. 

  1183. 		}
    1184. 

  1184. 		else {
    1185. 

  1185. 			return "";
    1186. 

  1186. 		}
    1187. 

  1187. 	}
    1188. 

  1188. 

  1189. 	/**
    1190. 

  1190. 	 * Function to get the name of a vendor by its id
    1191. 

  1191. 	 * @author pablo
    1192. 

  1192. 	 * @param int $vendor_id
    1193. 

  1193. 	 * @return string The name of the vendor
    1194. 

  1194. 	 */
    1195. 

  1195. 	function get_vend_idname($vendor_id) {
    1196. 

  1196. 		$db = new ps_DB;
    1197. 

  1197. 

  1198. 		$q = "SELECT vendor_name,vendor_id FROM #__{vm}_vendor ";
    1199. 

  1199. 		$q .= "WHERE vendor_id='$vendor_id'";
    1200. 

  1200. 

  1201. 		$db->query($q);
    1202. 

  1202. 		$db->next_record();
    1203. 

  1203. 		if ($db->f("vendor_name")) {
    1204. 

  1204. 			return $db->f("vendor_name");
    1205. 

  1205. 		}
    1206. 

  1206. 		else {
    1207. 

  1207. 			return "";
    1208. 

  1208. 		}
    1209. 

  1209. 	}
    1210. 

  1210. 

  1211. 	/**
    1212. 

  1212. 	 * Function to get the vendor_id of a product
    1213. 

  1213. 	 * @author pablo
    1214. 

  1214. 	 * @param int $product_id
    1215. 

  1215. 	 * @return int The vendor id
    1216. 

  1216. 	 */
    1217. 

  1217. 	function get_vendor_id($product_id) {
    1218. 

  1218. 		$db = new ps_DB;
    1219. 

  1219. 		if( empty( $_SESSION['product_sess'][$product_id]['vendor_id'] )) {
    1220. 

  1220. 			$q = "SELECT vendor_id FROM #__{vm}_product ";
    1221. 

  1221. 			$q .= "WHERE product_id='$product_id' ";
    1222. 

  1222. 

  1223. 			$db->query($q);
    1224. 

  1224. 			$db->next_record();
    1225. 

  1225. 			if ($db->f("vendor_id")) {
    1226. 

  1226. 				$_SESSION['product_sess'][$product_id]['vendor_id'] = $db->f("vendor_id");
    1227. 

  1227. 			}
    1228. 

  1228. 			else {
    1229. 

  1229. 				$_SESSION['product_sess'][$product_id]['vendor_id'] = "";
    1230. 

  1230. 			}
    1231. 

  1231. 		}
    1232. 

  1232. 		return $_SESSION['product_sess'][$product_id]['vendor_id'];
    1233. 

  1233. 	}
    1234. 

  1234. 

  1235. 	/**
    1236. 

  1236. 	 * Function to get the manufacturer id the product $product_id is assigned to
    1237. 

  1237. 	 * @author soeren
    1238. 

  1238. 	 * @param int $product_id
    1239. 

  1239. 	 * @return int The manufacturer id
    1240. 

  1240. 	 */
    1241. 

  1241. 	function get_manufacturer_id($product_id) {
    1242. 

  1242. 		$db = new ps_DB;
    1243. 

  1243. 

  1244. 		$q = "SELECT manufacturer_id FROM #__{vm}_product_mf_xref ";
    1245. 

  1245. 		$q .= "WHERE product_id='$product_id' ";
    1246. 

  1246. 

  1247. 		$db->query($q);
    1248. 

  1248. 		$db->next_record();
    1249. 

  1249. 		if ($db->f("manufacturer_id")) {
    1250. 

  1250. 			return $db->f("manufacturer_id");
    1251. 

  1251. 		}
    1252. 

  1252. 		else {
    1253. 

  1253. 			return false;
    1254. 

  1254. 		}
    1255. 

  1255. 	}
    1256. 

  1256. 

  1257. 	/**
    1258. 

  1258. 	 * Functon to get the name of the manufacturer this product is assigned to
    1259. 

  1259. 	 *
    1260. 

  1260. 	 * @param int $product_id
    1261. 

  1261. 	 * @return string the manufacturer name
    1262. 

  1262. 	 */
    1263. 

  1263. 	function get_mf_name($product_id) {
    1264. 

  1264. 		$db = new ps_DB;
    1265. 

  1265. 

  1266. 		$q = "SELECT mf_name,#__{vm}_manufacturer.manufacturer_id FROM #__{vm}_product_mf_xref,#__{vm}_manufacturer ";
    1267. 

  1267. 		$q .= "WHERE product_id='$product_id' ";
    1268. 

  1268. 		$q .= "AND #__{vm}_manufacturer.manufacturer_id=#__{vm}_product_mf_xref.manufacturer_id";
    1269. 

  1269. 

  1270. 		$db->query($q);
    1271. 

  1271. 		$db->next_record();
    1272. 

  1272. 		if ($db->f("mf_name")) {
    1273. 

  1273. 			return $db->f("mf_name");
    1274. 

  1274. 		}
    1275. 

  1275. 		else {
    1276. 

  1276. 			return "";
    1277. 

  1277. 		}
    1278. 

  1278. 	}
    1279. 

  1279. 	/**
    1280. 

  1280. 	 * This function retrieves the "neighbor" products of a product specified by $product_id
    1281. 

  1281. 	 * Neighbors are the previous and next product in the current list
    1282. 

  1282. 	 *
    1283. 

  1283. 	 * @param int $product_id
    1284. 

  1284. 	 * @return array
    1285. 

  1285. 	 */
    1286. 

  1286. 	function get_neighbor_products( $product_id ) {
    1287. 

  1287. 		global $perm, $orderby, $my, $auth, $keyword, $DescOrderBy, $limit, $limitstart, $search_limiter, $search_op, 
    1288. 

  1288. 			$category_id, $manufacturer_id, $vm_mainframe, $vmInputFilter, $product_type_id, $keyword1, $keyword2;
    1289. 

  1289. 		$limit = 2000;
    1290. 

  1290.         $limitstart = 0;
    1291. 

  1291. 		if( !empty( $_SESSION['last_browse_parameters'])) {
    1292. 

  1292. 			foreach( $_SESSION['last_browse_parameters'] as $paramName => $paramValue ) {
    1293. 

  1293. 				$$paramName = $paramValue;
    1294. 

  1294. 			}
    1295. 

  1295. 		}
    1296. 

  1296. 		$db = new ps_DB();
    1297. 

  1297. 		$db_browse = new ps_DB();
    1298. 

  1298. 		include( PAGEPATH . 'shop_browse_queries.php' );
    1299. 

  1299. 		
    1300. 

  1300. 		$db->query( $list );
    1301. 

  1301. 		
    1302. 

  1302. 		$neighbors = array('previous'=>'',
    1303. 

  1303. 							'next'=>'');
    1304. 

  1304. 		
    1305. 

  1305. 		while( $db->next_record() ) {
    1306. 

  1306. 			if( $db->f( 'product_id' ) == $product_id ) {
    1307. 

  1307. 				$previous_row = $db->previousRow();
    1308. 

  1308. 				$next_row = $db->nextRow();
    1309. 

  1309. 				
    1310. 

  1310. 				if( !empty( $previous_row->product_id )) {
    1311. 

  1311. 					$neighbors['previous']['product_id'] = $previous_row->product_id;
    1312. 

  1312. 					$neighbors['previous']['product_name'] = $previous_row->product_name;
    1313. 

  1313. 				} 
    1314. 

  1314. 				if( !empty( $next_row->product_id )) {
    1315. 

  1315. 					$neighbors['next']['product_id'] = $next_row->product_id;
    1316. 

  1316. 					$neighbors['next']['product_name'] = $next_row->product_name;
    1317. 

  1317. 				}
    1318. 

  1318. 			}
    1319. 

  1319. 		}
    1320. 

  1320. 		return $neighbors;
    1321. 

  1321. 	}
    1322. 

  1322. 	/**
    1323. 

  1323. 	 * Prints the img tag for the given product image
    1324. 

  1324. 	 *
    1325. 

  1325. 	 * @param string $image The name of the imahe OR the full URL to the image
    1326. 

  1326. 	 * @param string $args Additional attributes for the img tag
    1327. 

  1327. 	 * @param int $resize 
    1328. 

  1328. 	 * (1 = resize the image by using height and width attributes, 
    1329. 

  1329. 	 * 0 = do not resize the image)
    1330. 

  1330. 	 * @param string $path_appendix The path to be appended to IMAGEURL / IMAGEPATH
    1331. 

  1331. 	 */
    1332. 

  1332. 	function show_image($image, $args="", $resize=1, $path_appendix="product") {
    1333. 

  1333. 		echo $this->image_tag($image, $args, $resize, $path_appendix);
    1334. 

  1334. 	}
    1335. 

  1335. 

  1336. 	/**
    1337. 

  1337. 	 * Returns the img tag for the given product image
    1338. 

  1338. 	 *
    1339. 

  1339. 	 * @param string $image The name of the imahe OR the full URL to the image
    1340. 

  1340. 	 * @param string $args Additional attributes for the img tag
    1341. 

  1341. 	 * @param int $resize 
    1342. 

  1342. 	 * (1 = resize the image by using height and width attributes, 
    1343. 

  1343. 	 * 0 = do not resize the image)
    1344. 

  1344. 	 * @param string $path_appendix The path to be appended to IMAGEURL / IMAGEPATH
    1345. 

  1345. 	 * @return The HTML code of the img tag
    1346. 

  1346. 	 */
    1347. 

  1347. 	function image_tag($image, $args="", $resize=1, $path_appendix='product', $thumb_width=0, $thumb_height=0 ) {
    1348. 

  1348. 		global $mosConfig_live_site, $mosConfig_absolute_path;
    1349. 

  1349. 		require_once( CLASSPATH . 'imageTools.class.php');
    1350. 

  1350. 		
    1351. 

  1351. 		$border="";
    1352. 

  1352. 		if( strpos( $args, "border=" )===false ) {
    1353. 

  1353. 			$border = 'border="0"';
    1354. 

  1354. 		}
    1355. 

  1355. 		$height = $width = '';
    1356. 

  1356. 		
    1357. 

  1357. 		if ($image != "") {
    1358. 

  1358. 			// URL
    1359. 

  1359. 			if( substr( $image, 0, 4) == "http" ) {
    1360. 

  1360. 				$url = $image;
    1361. 

  1361. 			}
    1362. 

  1362. 			// local image file
    1363. 

  1363. 			else {
    1364. 

  1364. 				if(PSHOP_IMG_RESIZE_ENABLE == '1' || $resize==1) {
    1365. 

  1365. 					$url = $mosConfig_live_site."/components/com_virtuemart/show_image_in_imgtag.php?filename=".urlencode($image)."&amp;newxsize=".PSHOP_IMG_WIDTH."&amp;newysize=".PSHOP_IMG_HEIGHT."&amp;fileout=";
    1366. 

  1366. 					if( !strpos( $args, "height=" )) {
    1367. 

  1367. 						$arr = @getimagesize( vmImageTools::getresizedfilename( $image, $path_appendix, '', $thumb_width, $thumb_height ) );
    1368. 

  1368. 						$width = $arr[0]; $height = $arr[1];
    1369. 

  1369. 					}
    1370. 

  1370. 				}
    1371. 

  1371. 				else {
    1372. 

  1372. 					$url = IMAGEURL.$path_appendix.'/'.$image;
    1373. 

  1373. 					if( file_exists($image)) {
    1374. 

  1374. 						$url = str_replace( $mosConfig_absolute_path, $mosConfig_live_site, $image );
    1375. 

  1375. 					} elseif( file_exists($mosConfig_absolute_path.'/'.$image)) {
    1376. 

  1376. 						$url = $mosConfig_live_site.'/'.$image;
    1377. 

  1377. 					}
    1378. 

  1378. 					
    1379. 

  1379. 					if( !strpos( $args, "height=" ) ) {
    1380. 

  1380. 						$arr = getimagesize( str_replace( IMAGEURL, IMAGEPATH, $url ) );
    1381. 

  1381. 						$width = $arr[0]; $height = $arr[1];
    1382. 

  1382. 						
    1383. 

  1383. 					}
    1384. 

  1384. 					if( $resize ) {
    1385. 

  1385. 						if( $height < $width ) {
    1386. 

  1386. 							$width = round($width / ($height / PSHOP_IMG_HEIGHT));
    1387. 

  1387. 							$height = PSHOP_IMG_HEIGHT;
    1388. 

  1388. 						} else {
    1389. 

  1389. 							$height = round($height / ($width / PSHOP_IMG_WIDTH ));
    1390. 

  1390. 							$width = PSHOP_IMG_WIDTH;
    1391. 

  1391. 						}
    1392. 

  1392. 					}
    1393. 

  1393. 				}
    1394. 

  1394. 				$url = str_replace( basename( $url ), $GLOBALS['VM_LANG']->convert(basename($url)), $url );
    1395. 

  1395. 			}
    1396. 

  1396. 		}
    1397. 

  1397. 		else {
    1398. 

  1398. 			$url = VM_THEMEURL.'images/'.NO_IMAGE;
    1399. 

  1399. 		}
    1400. 

  1400. 		
    1401. 

  1401. 		return vmCommonHTML::imageTag( $url, '', '', $height, $width, '', '', $args.' '.$border );
    1402. 

  1402. 

  1403. 	}
    1404. 

  1404. 

  1405. 	/**
    1406. 

  1406. 	 * Get the tax rate...
    1407. 

  1407. 	 * @author soeren
    1408. 

  1408. 	 * @return int The tax rate found
    1409. 

  1409. 	 */
    1410. 

  1410. 	function get_taxrate() {
    1411. 

  1411. 		global $page;
    1412. 

  1412. 		$ps_vendor_id = $_SESSION["ps_vendor_id"];
    1413. 

  1413. 		$auth = $_SESSION['auth'];
    1414. 

  1414. 

  1415. 		if( !defined('_PSHOP_ADMIN' ) || $page == 'product.product_list') {
    1416. 

  1416. 

  1417. 			$db = new ps_DB;
    1418. 

  1418. 

  1419. 			if ($auth["show_price_including_tax"] == 1) {
    1420. 

  1420. 

  1421. 				require_once( CLASSPATH . 'ps_checkout.php' );
    1422. 

  1422. 				if (! ps_checkout::tax_based_on_vendor_address ()) {
    1423. 

  1423. 					if( $auth["user_id"] > 0 ) {
    1424. 

  1424. 

  1425. 						$q = "SELECT state, country FROM #__{vm}_user_info WHERE user_id='". $auth["user_id"] . "'";
    1426. 

  1426. 						$db->query($q);
    1427. 

  1427. 

  1428. 						$db->next_record();
    1429. 

  1429. 						$state = $db->f("state");
    1430. 

  1430. 						$country = $db->f("country");
    1431. 

  1431. 

  1432. 						$q = "SELECT tax_rate FROM #__{vm}_tax_rate WHERE tax_country='$country' ";
    1433. 

  1433. 						if( !empty($state)) {
    1434. 

  1434. 							$q .= "AND tax_state='$state'";
    1435. 

  1435. 						}
    1436. 

  1436. 						$db->query($q);
    1437. 

  1437. 						if ($db->next_record()) {
    1438. 

  1438. 							$_SESSION['taxrate'][$ps_vendor_id] = $db->f("tax_rate");
    1439. 

  1439. 						}
    1440. 

  1440. 						else {
    1441. 

  1441. 							$_SESSION['taxrate'][$ps_vendor_id] = 0;
    1442. 

  1442. 						}
    1443. 

  1443. 					}
    1444. 

  1444. 					else {
    1445. 

  1445. 						$_SESSION['taxrate'][$ps_vendor_id] = 0;
    1446. 

  1446. 					}
    1447. 

  1447. 

  1448. 				}
    1449. 

  1449. 				else {
    1450. 

  1450. 					if( empty( $_SESSION['taxrate'][$ps_vendor_id] )) {
    1451. 

  1451. 						// let's get the store's tax rate
    1452. 

  1452. 						$q = "SELECT `tax_rate` FROM #__{vm}_vendor, #__{vm}_tax_rate ";
    1453. 

  1453. 						$q .= "WHERE tax_country=vendor_country AND #__{vm}_vendor.vendor_id=1 ";
    1454. 

  1454. 						// !! Important !! take the highest available tax rate for the store's country
    1455. 

  1455. 						$q .= "ORDER BY `tax_rate` DESC";
    1456. 

  1456. 						$db->query($q);
    1457. 

  1457. 						if ($db->next_record()) {
    1458. 

  1458. 							$_SESSION['taxrate'][$ps_vendor_id] = $db->f("tax_rate");
    1459. 

  1459. 						}…
    1460.

Large files files are truncated, but you can click here to view the full file