PageRenderTime 54ms CodeModel.GetById 14ms RepoModel.GetById 0ms app.codeStats 1ms

/wp-content/plugins/wp-e-commerce/homepage_products_functions.php

https://gitlab.com/endomorphosis/reservationtelco
PHP | 244 lines | 214 code | 23 blank | 7 comment | 82 complexity | b788b4120a382a215378d019cadf0e51 MD5 | raw file
    

  1. <?php
    2. 

  2. function nszhpcrt_homepage_products($content = '') {
    3. 

  3.   global $wpdb;
    4. 

  4.   $siteurl = get_option('siteurl');
    5. 

  5.   if(get_option('permalink_structure') != '') {
    6. 

  6.     $seperator ="?";
    7. 

  7. 	} else {
    8. 

  8. 		$seperator ="&amp;";
    9. 

  9. 	}
    10. 

  10.   $sql = "SELECT * FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `display_frontpage` IN('1') AND `active` IN('1')";
    11. 

  11.   $product_list = $wpdb->get_results($sql,ARRAY_A);
    12. 

  12.     
    13. 

  13.   $output = "<div id='homepage_products'>\n\r";
    14. 

  14.   foreach((array)$product_list as $product) {
    15. 

  15.     $output .= "<div class='frontpage_product'>\n\r";
    16. 

  16.     $output .= "<a href='".wpsc_product_url($product['id'])."'>";
    17. 

  17.     if($product['image'] != '') {
    18. 

  18.       $output .= "<img src='".WPSC_THUMBNAIL_URL.$product['image']."' title='".$product['name']."' alt='".$product['name']."' />\n\r";
    19. 

  19.       $output .= "<p>\n\r";
    20. 

  20.       $output .= stripslashes($product['name']);
    21. 

  21.       $output .= "<span class='front_page_price'>\n\r";
    22. 

  22.       if($product['special']==1) {
    23. 

  23.         $output .= "<span class='oldprice'>".nzshpcrt_currency_display($product['price'], $product['notax'])."</span><br />\n\r";
    24. 

  24.         $output .= nzshpcrt_currency_display(($product['price'] - $product['special_price']), $product['notax'],false,$product['id']);
    25. 

  25. 			} else {
    26. 

  26. 				$output .= "".nzshpcrt_currency_display($product['price'], $product['notax']);
    27. 

  27. 			}
    28. 

  28.       $output .= "</span>\n\r";
    29. 

  29.       $output .= "</p>\n\r";
    30. 

  30. 		}
    31. 

  31.     $output .= "</a>";
    32. 

  32.     $output .= "</div>\n\r";
    33. 

  33. 	}
    34. 

  34.   $output .= "</div>\n\r";
    35. 

  35.   $output .= "<br style='clear: left;'>\n\r";
    36. 

  36.   return preg_replace("/\[homepage_products\]/", $output, $content);
    37. 

  37. }
    38. 

  38.   
    39. 

  39.   
    40. 

  40. 

  41. function nszhpcrt_category_tag($content = '') {
    42. 

  42. 	global $wpdb;
    43. 

  43. 	if(preg_match_all("/\[wpsc_category_exclude=([\d]+),*(full)?\]/", $content, $matches)) {
    44. 

  44. 		foreach($matches[1] as $key => $category_id) {
    45. 

  45. 			$categories[$key]['id'] = $category_id;
    46. 

  46. 			$categories[$key]['display'] = $matches[2][$key];
    47. 

  47. 			$categories[$key]['original_string'] = $matches[0][$key];
    48. 

  48. 		}
    49. 

  49. 		foreach ($categories as $category) {
    50. 

  50. 			$sql1 = "SELECT DISTINCT `".WPSC_TABLE_PRODUCT_LIST."`.*, `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`category_id`,`".WPSC_TABLE_PRODUCT_ORDER."`.`order`, IF(ISNULL(`".WPSC_TABLE_PRODUCT_ORDER."`.`order`), 0, 1) AS `order_state` FROM `".WPSC_TABLE_PRODUCT_LIST."` LEFT JOIN `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."` ON `".WPSC_TABLE_PRODUCT_LIST."`.`id` = `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`product_id` LEFT JOIN `".WPSC_TABLE_PRODUCT_ORDER."` ON ( ( `".WPSC_TABLE_PRODUCT_LIST."`.`id` = `".WPSC_TABLE_PRODUCT_ORDER."`.`product_id` ) AND ( `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`category_id` = `".WPSC_TABLE_PRODUCT_ORDER."`.`category_id` ) ) WHERE `".WPSC_TABLE_PRODUCT_LIST."`.`active` = '1' AND `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`category_id` NOT IN ('".$category['id']."') $no_donations_sql ORDER BY `order_state` DESC,`".WPSC_TABLE_PRODUCT_ORDER."`.`order` ASC";
    51. 

  51. 			$product_list1 = $wpdb->get_results($sql1,ARRAY_A);
    52. 

  52. 			if(function_exists('product_display_list') && (get_option('product_view') == 'list')) {
    53. 

  53. 				$output1= product_display_list($product_list1, $group_type, $group_sql, $search_sql);
    54. 

  54. 			} else if(function_exists('product_display_grid') && (get_option('product_view') == 'grid')) {
    55. 

  55. 				$output1= product_display_grid($product_list1, $group_type, $group_sql, $search_sql);
    56. 

  56. 			} else {
    57. 

  57. 				$output1= product_display_default($product_list1,'');
    58. 

  58. 			}
    59. 

  59. 		}
    60. 

  60. 		$content = str_replace($category['original_string'], $output1, $content);
    61. 

  61. 	}
    62. 

  62. 	if(preg_match_all("/\[wpsc_category=([\d]+),*(full)?\]/", $content, $matches)) {
    63. 

  63. 		foreach($matches[1] as $key => $category_id) {
    64. 

  64. 			$categories[$key]['id'] = $category_id;
    65. 

  65. 			//$categories[$key]['display'] = $matches[2][$key];
    66. 

  66. 			$original_string = $matches[0][$key];
    67. 

  67. 			$query = array('category_id' => $category_id);
    68. 

  68. 

  69. 			$content = str_replace($original_string, wpsc_display_products_page($query), $content);
    70. 

  70. 			
    71. 

  71. 		}
    72. 

  72. 

  73. 		
    74. 

  74. 		return $content;
    75. 

  75. 

  76. 	//echo("<pre>".print_r($categories,true)."</pre>");
    77. 

  77. 	$siteurl = get_option('siteurl');
    78. 

  78. 	if(get_option('permalink_structure') != '') {
    79. 

  79. 		$seperator ="?";
    80. 

  80. 	} else {
    81. 

  81. 		$seperator ="&amp;";
    82. 

  82. 	}
    83. 

  83. 

  84. 		foreach((array)$activated_widgets as $widget_container) {
    85. 

  85. 			if(is_array($widget_container) && array_search(__('Product Donations', 'wpsc'), $widget_container)) {
    86. 

  86. 				$no_donations_sql = "AND `".WPSC_TABLE_PRODUCT_LIST."`.`donation` != '1'";
    87. 

  87. 				break;
    88. 

  88. 			}
    89. 

  89. 		}
    90. 

  90. 		foreach((array)$categories as $category) {
    91. 

  91. 		  $full_view = null;
    92. 

  92. 		  if($category['display'] == 'full') {
    93. 

  93. 				$sql = "SELECT DISTINCT `".WPSC_TABLE_PRODUCT_LIST."`.*, `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`category_id`,`".WPSC_TABLE_PRODUCT_ORDER."`.`order`, IF(ISNULL(`".WPSC_TABLE_PRODUCT_ORDER."`.`order`), 0, 1) AS `order_state` FROM `".WPSC_TABLE_PRODUCT_LIST."` LEFT JOIN `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."` ON `".WPSC_TABLE_PRODUCT_LIST."`.`id` = `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`product_id` LEFT JOIN `".WPSC_TABLE_PRODUCT_ORDER."` ON ( ( `".WPSC_TABLE_PRODUCT_LIST."`.`id` = `".WPSC_TABLE_PRODUCT_ORDER."`.`product_id` ) AND ( `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`category_id` = `".WPSC_TABLE_PRODUCT_ORDER."`.`category_id` ) ) WHERE `".WPSC_TABLE_PRODUCT_LIST."`.`active` = '1' AND `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`category_id` IN ('".$category['id']."') $no_donations_sql ORDER BY `order_state` DESC,`".WPSC_TABLE_PRODUCT_ORDER."`.`order` ASC";
    94. 

  94. 			
    95. 

  95. 				$product_list = $wpdb->get_results($sql,ARRAY_A);
    96. 

  96. 				// sorry about the global variable, but it was the best way I could think of to avoid people having to upgrade the gold cart	
    97. 

  97. 				$GLOBALS['wpsc_category_id'] = $category['id'];
    98. 

  98. 				if(function_exists('product_display_list') && (get_option('product_view') == 'list')) {
    99. 

  99. 					$output .= product_display_list($product_list, $group_type, $group_sql, $search_sql);
    100. 

  100. 				} else if(function_exists('product_display_grid') && (get_option('product_view') == 'grid')) {
    101. 

  101. 					$output .= product_display_grid($product_list, $group_type, $group_sql, $search_sql);
    102. 

  102. 				} else {
    103. 

  103. 					$output .= product_display_default($product_list, $group_type, $group_sql, $search_sql);
    104. 

  104. 				}
    105. 

  105. 		  
    106. 

  106. 		  } else {
    107. 

  107. 				$sql = "SELECT DISTINCT `".WPSC_TABLE_PRODUCT_LIST."`.*, `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`category_id`,`".WPSC_TABLE_PRODUCT_ORDER."`.`order`, IF(ISNULL(`".WPSC_TABLE_PRODUCT_ORDER."`.`order`), 0, 1) AS `order_state` FROM `".WPSC_TABLE_PRODUCT_LIST."` LEFT JOIN `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."` ON `".WPSC_TABLE_PRODUCT_LIST."`.`id` = `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`product_id` LEFT JOIN `".WPSC_TABLE_PRODUCT_ORDER."` ON ( ( `".WPSC_TABLE_PRODUCT_LIST."`.`id` = `".WPSC_TABLE_PRODUCT_ORDER."`.`product_id` ) AND ( `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`category_id` = `".WPSC_TABLE_PRODUCT_ORDER."`.`category_id` ) ) WHERE `".WPSC_TABLE_PRODUCT_LIST."`.`active` = '1' AND `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`category_id` IN ('".$category['id']."') $no_donations_sql ORDER BY `order_state` DESC,`".WPSC_TABLE_PRODUCT_ORDER."`.`order` ASC";
    108. 

  108. 			
    109. 

  109. 				$product_list = $wpdb->get_results($sql,ARRAY_A);
    110. 

  110. 			  $output = "<div id='products_page_container' class='wrap wpsc_container'>\n\r";
    111. 

  111. 				$output .= "<div id='homepage_products'>\n\r";
    112. 

  112. 				if ($full_view != null){
    113. 

  113. 					$output .= "<table class='productdisplay'>";
    114. 

  114. 				}
    115. 

  115. 				foreach((array)$product_list as $product) {
    116. 

  116. 				  if(function_exists('wpsc_theme_html')) {
    117. 

  117. 						$wpsc_theme = wpsc_theme_html($product);
    118. 

  118. 					}
    119. 

  119. 					if ($full_view == null) {
    120. 

  120. 						$output .= "<div class='category_view_product'>\n\r";
    121. 

  121. 					} else {
    122. 

  122. 							/* product image is here */
    123. 

  123. 					$output .= "<tr>";
    124. 

  124. 					$output .= "<td class='imagecol'>";
    125. 

  125. 					}
    126. 

  126. 					$output .="<a href='".WPSC_IMAGE_URL.$product['image']."' class='thickbox preview_link'  rel='".str_replace(" ", "_",$product['name'])."'>";
    127. 

  127. 					if($product['image'] != '') {
    128. 

  128. 						$output .= "<img class='product_image' src='".WPSC_THUMBNAIL_URL.$product['image']."' title='".$product['name']."' alt='".$product['name']."' />\n\r";
    129. 

  129. 					}
    130. 

  130. 					$output .= "</a>";
    131. 

  131. 					if ($full_view != null) {
    132. 

  132. 						$output .= "</td><td class='textcol'>";
    133. 

  133. 					} else {
    134. 

  134. 						$output .= "<div class='product_details'>";
    135. 

  135. 					}
    136. 

  136. 					if (get_option('hide_name_link')!=1) {
    137. 

  137. 						if(($product['special']==1) && ($variations_output[1] === null)) {
    138. 

  138. 							$output .= "<a href='".wpsc_product_url($product['id'])."' class='wpsc_product_title' >$special<strong class='special'>Special / Sale Price - </strong><strong>" . stripslashes($product['name']) . "</strong></a>";
    139. 

  139. 						} else {
    140. 

  140. 							$output .= "<a href='".wpsc_product_url($product['id'])."' class='wpsc_product_title' >$special<strong>" . stripslashes($product['name']) . "</strong></a>";
    141. 

  141. 						}
    142. 

  142. 					} else {
    143. 

  143. 						if(($product['special']==1) && ($variations_output[1] === null)) {
    144. 

  144. 							$output .= "<a class='wpsc_product_title' >$special<strong class='special'>Special / Sale Price - </strong><strong>" . stripslashes($product['name']) . "</strong></a>";
    145. 

  145. 						} else {
    146. 

  146. 							$output .= "<a class='wpsc_product_title' >$special<strong>" . stripslashes($product['name']) . "</strong></a>";
    147. 

  147. 						}
    148. 

  148. 					}
    149. 

  149. 					if ($full_view !=null) {
    150. 

  150. 						if($product['description'] != '') {
    151. 

  151. 							$output .= "<p class='wpsc_description'>".nl2br(stripslashes($product['description'])) . "</p>";
    152. 

  152. 						}
    153. 

  153. 				
    154. 

  154. 						if($product['additional_description'] != '') {
    155. 

  155. 							$output .= "<a href='#' class='additional_description_link' onclick='return show_additional_description(\"additionaldescription".$product['id']."\",\"link_icon".$product['id']."\");'>";
    156. 

  156. 							$output .= "<img id='link_icon".$product['id']."' class='additional_description_button'  src='".WPSC_URL."/images/icon_window_expand.gif' title='".$product['name']."' alt='".$product['name']."' />";
    157. 

  157. 							$output .= __('More Details', 'wpsc')."</a>";
    158. 

  158. 						
    159. 

  159. 							$output .= "<span class='additional_description' id='additionaldescription".$product['id']."'><br />";
    160. 

  160. 							$output .= nl2br(stripslashes($product['additional_description'])) . "";
    161. 

  161. 							$output .= "</span><br />";
    162. 

  162. 						}
    163. 

  163. 					}
    164. 

  164. 					/*
    165. 

  165. 					adding to cart stuff
    166. 

  166. 					*/
    167. 

  167. 					$output .= "<form id='product_".$product['id']."' name='product_".$product['id']."' method='post' action='".get_option('product_list_url').$seperator."category=".$_GET['category']."' onsubmit='submitform(this);return false;' >";
    168. 

  168. 					$output .= "<input type='hidden' name='prodid' value='".$product['id']."' />";
    169. 

  169. 					$output .= "<input type='hidden' name='item' value='".$product['id']."' />";
    170. 

  170. 					
    171. 

  171. 					$variations_procesor = new nzshpcrt_variations;
    172. 

  172. 							
    173. 

  173. 					$variations_output = $variations_procesor->display_product_variations($product['id'],false, false, true);
    174. 

  174. 					$output .= $variations_output[0];
    175. 

  175. 					if($variations_output[1] !== null) {
    176. 

  176. 						$product['price'] = $variations_output[1];
    177. 

  177. 					}
    178. 

  178. 						
    179. 

  179. 					if(($product['special']==1) && ($variations_output[1] === null)) {
    180. 

  180. 						$output .= "<span class='oldprice'>".nzshpcrt_currency_display($product['price'], $product['notax']) . "</span><br />";
    181. 

  181. 						$output .= nzshpcrt_currency_display(($product['price'] - $product['special_price']), $product['notax'],false,$product['id']) . "<br />";
    182. 

  182. 					} else {
    183. 

  183. 						$output .= "<span id='product_price_".$product['id']."'>" . nzshpcrt_currency_display($product['price'], $product['notax']) . "</span><br />";
    184. 

  184. 					}
    185. 

  185. 					if(((get_option('hide_addtocart_button') !='1') || (get_option('payment_gateway') !='google'))) {
    186. 

  186. 						if(isset($wpsc_theme) && is_array($wpsc_theme) && ($wpsc_theme['html'] !='')) {
    187. 

  187. 							$output .= $wpsc_theme['html'];
    188. 

  188. 						} else {
    189. 

  189. 							$output .= "<input type='submit' id='product_".$product['id']."_submit_button' class='wpsc_buy_button' name='Buy' value='".__('Add To Cart', 'wpsc')."'  />";
    190. 

  190. 						}
    191. 

  191. 					}
    192. 

  192. 					$output .= "</form>";
    193. 

  193. 					if (get_option('addtocart_or_buynow')=='1') {
    194. 

  194. 						if (get_option('payment_gateway')=='google') {
    195. 

  195. 							$output .= google_buynow($product['id']);
    196. 

  196. 						}
    197. 

  197. 					}
    198. 

  198. 							
    199. 

  199. 							
    200. 

  200. 					if ($full_view != null) {
    201. 

  201. 						if(get_option('product_ratings') == 1) {
    202. 

  202. 							$output .= "<div class='product_footer'>";
    203. 

  203. 							
    204. 

  204. 							$output .= "<div class='product_average_vote'>";
    205. 

  205. 							$output .= "<strong>".__('Avg. Customer Rating', 'wpsc').":</strong>";
    206. 

  206. 							$output .= nzshpcrt_product_rating($product['id']);
    207. 

  207. 							$output .= "</div>";
    208. 

  208. 							
    209. 

  209. 							$output .= "<div class='product_user_vote'>";
    210. 

  210. 							$vote_output = nzshpcrt_product_vote($product['id'],"onmouseover='hide_save_indicator(\"saved_".$product['id']."_text\");'");
    211. 

  211. 							if($vote_output[1] == 'voted') {
    212. 

  212. 								$output .= "<strong><span id='rating_".$product['id']."_text'>".__('Your Rating', 'wpsc').":</span>";
    213. 

  213. 								$output .= "<span class='rating_saved' id='saved_".$product['id']."_text'> ".__('Saved', 'wpsc')."</span>";
    214. 

  214. 								$output .= "</strong>";
    215. 

  215. 							} else if($vote_output[1] == 'voting') {
    216. 

  216. 								$output .= "<strong><span id='rating_".$product['id']."_text'>".__('Rate This item', 'wpsc').":</span>";
    217. 

  217. 								$output .= "<span class='rating_saved' id='saved_".$product['id']."_text'> ".__('Saved', 'wpsc')."</span>";
    218. 

  218. 								$output .= "</strong>";
    219. 

  219. 							}
    220. 

  220. 							$output .= $vote_output[0];
    221. 

  221. 							$output .= "</div>";
    222. 

  222. 							$output .= "</div>";
    223. 

  223. 						}
    224. 

  224. 					
    225. 

  225. 						$output .="</td>";
    226. 

  226. 						$output .="</tr>";
    227. 

  227. 					} else {
    228. 

  228. 						$output .= "</div>\n\r";
    229. 

  229. 						$output .= "</div>";
    230. 

  230. 					}
    231. 

  231. 				}
    232. 

  232. 				if ($full_view != null) {
    233. 

  233. 					$output .= "</table>";
    234. 

  234. 				}
    235. 

  235. 				$output .= "</div>\n\r";
    236. 

  236. 				$output .= "<br style='clear: left;'>\n\r";
    237. 

  237. 			  $output .= "</div>\n\r";
    238. 

  238. 			}
    239. 

  239. 		$content = str_replace($category['original_string'], $output, $content);
    240. 

  240. 		}
    241. 

  241. 	}
    242. 

  242. 	return $content;
    243. 

  243. }
    244. 

  244. ?>
    245.