PageRenderTime 59ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

/wp-content/plugins/wp-e-commerce/admin-form-functions.php

https://gitlab.com/endomorphosis/reservationtelco
PHP | 992 lines | 795 code | 115 blank | 82 comment | 81 complexity | 722d8edee50b75fccf02fca18365745a MD5 | raw file
    

  1. <?php

    2. 

  2. // ini_set('display_errors','1');

    3. 

  3. 

    4. 

  4. function nzshpcrt_getcategoryform($catid)

    5. 

  5.   {

    6. 

  6.   global $wpdb,$nzshpcrt_imagesize_info;

    7. 

  7.   $product = $wpdb->get_row("SELECT * FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `id`=$catid LIMIT 1",ARRAY_A);

    8. 

  8.   $output = '';

    9. 

  9.   $output .= "<div class='editing_this_group form_table'>";

    10. 

  10. 	$output .= "<p>".str_replace("[categorisation]", htmlentities(stripslashes($product['name'])), __('You are editing the &quot;[categorisation]&quot; Category', 'wpsc'))."</p>\n\r";

    11. 

  11. 	$output .= "<p><a href='' onclick='return showaddform()' class='add_category_link'><span>".str_replace("&quot;[categorisation]&quot;", "current", __('+ Add new category to the &quot;[categorisation]&quot; Group', 'wpsc'))."</span></a></p>";

    12. 

  12. 	$output .="<dl>\n\r";

    13. 

  13. 	$output .="		<dt>Display Category Shortcode: </dt>\n\r";

    14. 

  14. 	$output .="		<dd> [wpsc_products category_url_name='{$product['nice-name']}']</dd>\n\r";

    15. 

  15. 	$output .="		<dt>Display Category Template Tag: </dt>\n\r";

    16. 

  16. 	$output .="		<dd> &lt;?php echo wpsc_display_products_page(array('category_url_name'=>'{$product['nice-name']}')); ?&gt;</dd>\n\r";

    17. 

  17. 	$output .="</dl>\n\r";

    18. 

  18. 	

    19. 

  19. 	//$output .= "       [ <a href='#' onclick='return showedit_categorisation_form()'>".__('Edit This Group', 'wpsc')."</a> ]";

    20. 

  20. 	

    21. 

  21. 	$output .= "</div>";

    22. 

  22.   $output .= "        <table class='category_forms'>\n\r";

    23. 

  23.   $output .= "          <tr>\n\r";

    24. 

  24.   $output .= "            <td>\n\r";

    25. 

  25.   $output .= __('Name', 'wpsc').": ";

    26. 

  26.   $output .= "            </td>\n\r";

    27. 

  27.   $output .= "            <td>\n\r";

    28. 

  28.   $output .= "<input type='text' class='text' name='title' value='".htmlentities(stripslashes($product['name']), ENT_QUOTES, 'UTF-8')."' />";

    29. 

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

    30. 

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

    31. 

  31. 

    32. 

  32.   $output .= "          <tr>\n\r";

    33. 

  33.   $output .= "            <td>\n\r";

    34. 

  34.   $output .= __('Description', 'wpsc').": ";

    35. 

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

    36. 

  36.   $output .= "            <td>\n\r";

    37. 

  37.   $output .= "<textarea name='description' cols='40' rows='8' >".stripslashes($product['description'])."</textarea>";

    38. 

  38.   $output .= "            </td>\n\r";

    39. 

  39.   $output .= "          </tr>\n\r";

    40. 

  40.   $output .= "          </tr>\n\r";

    41. 

  41. 

    42. 

  42.   $output .= "          <tr>\n\r";

    43. 

  43.   $output .= "            <td>\n\r";

    44. 

  44.   $output .= __('Category Parent', 'wpsc').": ";

    45. 

  45.   $output .= "            </td>\n\r";

    46. 

  46.   $output .= "            <td>\n\r";

    47. 

  47.   $output .= wpsc_parent_category_list($product['group_id'], $product['id'], $product['category_parent']);

    48. 

  48.   $output .= "            </td>\n\r";

    49. 

  49.   $output .= "          </tr>\n\r";

    50. 

  50.   $output .= "          </tr>\n\r";

    51. 

  51. 

    52. 

  52. 

    53. 

  53. 	if ($product['display_type'] == 'grid') {

    54. 

  54. 		$display_type1="selected='selected'";

    55. 

  55. 	} else if ($product['display_type'] == 'default') {

    56. 

  56. 		$display_type2="selected='selected'";

    57. 

  57. 	}

    58. 

  58. 	

    59. 

  59. 	switch($product['display_type']) {

    60. 

  60. 	  case "default":

    61. 

  61. 			$product_view1 = "selected ='selected'";

    62. 

  62. 		break;

    63. 

  63. 		

    64. 

  64. 		case "grid":

    65. 

  65. 		if(function_exists('product_display_grid')) {

    66. 

  66. 			$product_view3 = "selected ='selected'";

    67. 

  67. 			break;

    68. 

  68. 		}

    69. 

  69. 		

    70. 

  70. 		case "list":

    71. 

  71. 		if(function_exists('product_display_list')) {

    72. 

  72. 			$product_view2 = "selected ='selected'";

    73. 

  73. 			break;

    74. 

  74. 		}

    75. 

  75. 		

    76. 

  76. 		default:

    77. 

  77. 			$product_view0 = "selected ='selected'";

    78. 

  78. 		break;

    79. 

  79. 	}	

    80. 

  80. 	

    81. 

  81. 	

    82. 

  82. 

    83. 

  83.   $output .= "          <tr>\n\r";

    84. 

  84.   $output .= "            <td>\n\r";

    85. 

  85.   $output .= __('Category&nbsp;Image', 'wpsc').": ";

    86. 

  86.   $output .= "            </td>\n\r";

    87. 

  87.   $output .= "            <td>\n\r";

    88. 

  88.   $output .= "<input type='file' name='image' value='' />";

    89. 

  89.   $output .= "            </td>\n\r";

    90. 

  90.   $output .= "          </tr>\n\r";

    91. 

  91.   $output .= "          </tr>\n\r";

    92. 

  92. 

    93. 

  93.   if(function_exists("getimagesize")) {

    94. 

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

    95. 

  95.       $imagepath = WPSC_CATEGORY_DIR . $product['image'];

    96. 

  96.       $imagetype = @getimagesize($imagepath); //previously exif_imagetype()

    97. 

  97.       $output .= "          <tr>\n\r";

    98. 

  98.       $output .= "            <td>\n\r";

    99. 

  99.       $output .= "            </td>\n\r";

    100. 

  100.       $output .= "            <td>\n\r";

    101. 

  101.       $output .= __('Height', 'wpsc').":<input type='text' size='6' name='height' value='".$imagetype[1]."' /> ".__('Width', 'wpsc').":<input type='text' size='6' name='width' value='".$imagetype[0]."' /><br /><span class='wpscsmall description'>$nzshpcrt_imagesize_info</span><br />\n\r";

    102. 

  102. 			$output .= "<span class='wpscsmall description'>".__('You can upload thumbnail images for each group. To display Group details in your shop you must configure these settings under <a href="admin.php?page=wpsc-settings&tab=presentation">Presentation Settings</a>.', 'wpsc')."</span>\n\r";

    103. 

  103.       $output .= "            </td>\n\r";

    104. 

  104.       $output .= "          </tr>\n\r";

    105. 

  105. 		} else {

    106. 

  106. 			$output .= "          <tr>\n\r";

    107. 

  107. 			$output .= "            <td>\n\r";

    108. 

  108. 			$output .= "            </td>\n\r";

    109. 

  109. 			$output .= "            <td>\n\r";

    110. 

  110. 			$output .= __('Height', 'wpsc').":<input type='text' size='6' name='height' value='".get_option('product_image_height')."' /> ".__('Width', 'wpsc').":<input type='text' size='6' name='width' value='".get_option('product_image_width')."' /><br /><span class='wpscsmall description'>$nzshpcrt_imagesize_info</span><br />\n\r";

    111. 

  111. 			$output .= "<span class='wpscsmall description'>".__('You can upload thumbnail images for each group. To display Group details in your shop you must configure these settings under <a href="admin.php?page=wpsc-settings&tab=presentation">Presentation Settings</a>.', 'wpsc')."</span>\n\r";

    112. 

  112. 			$output .= "            </td>\n\r";

    113. 

  113. 			$output .= "          </tr>\n\r";

    114. 

  114. 		}

    115. 

  115. 	}

    116. 

  116. 	

    117. 

  117. 	$output .= "          <tr>\n\r";

    118. 

  118.   $output .= "            <td>\n\r";

    119. 

  119.   $output .= __('Delete Image', 'wpsc').": ";

    120. 

  120.   $output .= "            </td>\n\r";

    121. 

  121.   $output .= "            <td>\n\r";

    122. 

  122.   $output .= "<input type='checkbox' name='deleteimage' value='1' />";

    123. 

  123.   $output .= "            </td>\n\r";

    124. 

  124.   $output .= "          </tr>\n\r";

    125. 

  125.   $output .= "          </tr>\n\r";

    126. 

  126. 	 /* START OF TARGET MARKET SELECTION */					

    127. 

  127. 	$countrylist = $wpdb->get_results("SELECT id,country,visible FROM `".WPSC_TABLE_CURRENCY_LIST."` ORDER BY country ASC ",ARRAY_A);

    128. 

  128. 	$selectedCountries = $wpdb->get_col("SELECT countryid FROM `".WPSC_TABLE_CATEGORY_TM."` WHERE categoryid=".$product['id']." AND visible= 1");

    129. 

  129. //	exit('<pre>'.print_r($countrylist,true).'</pre><br /><pre>'.print_r($selectedCountries,true).'</pre>');

    130. 

  130. 	$output .= " <tr>\n\r";

    131. 

  131. 	$output .= " 	<td colspan='2'><h4>Target Market Restrictions</h4></td></tr><tr><td>&nbsp;</td></tr><tr>\n\r";

    132. 

  132. 	$output .= " 	<td>\n\r";

    133. 

  133. 	$output .= __('Target Markets', 'wpsc').":\n\r";

    134. 

  134. 	$output .= " 	</td>\n\r";

    135. 

  135. 	$output .= " 	<td>\n\r";

    136. 

  136. 

    137. 

  137. 	if(@extension_loaded('suhosin')) {

    138. 

  138. 		$output .= "<em>".__("The Target Markets feature has been disabled because you have the Suhosin PHP extension installed on this server. If you need to use the Target Markets feature then disable the suhosin extension, if you can not do this, you will need to contact your hosting provider.

    139. 

  139. 			",'wpsc')."</em>";

    140. 

  140. 

    141. 

  141. 	} else {

    142. 

  142. 		$output .= "<span>Select: <a href='' class='wpsc_select_all'>All</a>&nbsp; <a href='' class='wpsc_select_none'>None</a></span><br />";

    143. 

  143. 		$output .= " 	<div id='resizeable' class='ui-widget-content multiple-select'>\n\r";

    144. 

  144. 		foreach($countrylist as $country){

    145. 

  145. 			if(in_array($country['id'], $selectedCountries))

    146. 

  146. 			/* if($country['visible'] == 1) */{

    147. 

  147. 			$output .= " <input type='checkbox' name='countrylist2[]' value='".$country['id']."'  checked='".$country['visible']."' />".$country['country']."<br />\n\r";

    148. 

  148. 			}else{

    149. 

  149. 			$output .= " <input type='checkbox' name='countrylist2[]' value='".$country['id']."'  />".$country['country']."<br />\n\r";

    150. 

  150. 			}

    151. 

  151. 				

    152. 

  152. 		}

    153. 

  153. 		$output .= " </div><br /><br />";

    154. 

  154. 		$output .= " <span class='wpscsmall description'>Select the markets you are selling this category to.<span>\n\r";

    155. 

  155. 	}

    156. 

  156. 

    157. 

  157. 	$output .= "   </td>\n\r";

    158. 

  158. 	

    159. 

  159. 	$output .= " </tr>\n\r";

    160. 

  160. 	////////

    161. 

  161. 

    162. 

  162. 	$output .= "          <tr>\n\r";

    163. 

  163. 	$output .= "          	<td colspan='2' class='category_presentation_settings'>\n\r";

    164. 

  164. 	$output .= "          		<h4>".__('Presentation Settings', 'wpsc')."</h4>\n\r";

    165. 

  165. 	$output .= "          		<span class='small'>".__('To over-ride the presentation settings for this group you can enter in your prefered settings here', 'wpsc')."</span>\n\r";

    166. 

  166. 	$output .= "          	</td>\n\r";

    167. 

  167. 	$output .= "          </tr>\n\r";

    168. 

  168. 	

    169. 

  169. 	$output .= "          <tr>\n\r";

    170. 

  170. 	$output .= "          	<td>\n\r";

    171. 

  171. 	$output .= "          	". __('Catalog View', 'wpsc').":\n\r";

    172. 

  172. 	$output .= "          	</td>\n\r";

    173. 

  173. 	$output .= "          	<td>\n\r";

    174. 

  174. 	$output .= "          		<select name='display_type'>\n\r";	

    175. 

  175. 	$output .= "          			<option value='' $product_view0 >".__('Please select', 'wpsc')."</option>\n\r";	

    176. 

  176. 	$output .= "          			<option value='default' $product_view1 >".__('Default View', 'wpsc')."</option>\n\r";	

    177. 

  177. 	if(function_exists('product_display_list')) {

    178. 

  178. 		$output .= "          			<option value='list' ". $product_view2.">". __('List View', 'wpsc')."</option>\n\r"; 

    179. 

  179. 	} else {

    180. 

  180. 		$output .= "          			<option value='list' disabled='disabled' ". $product_view2.">". __('List View', 'wpsc')."</option>\n\r";

    181. 

  181. 	}	

    182. 

  182. 	if(function_exists('product_display_grid')) {

    183. 

  183. 		$output .= "          			<option value='grid' ". $product_view3.">". __('Grid View', 'wpsc')."</option>\n\r";

    184. 

  184. 	} else {

    185. 

  185. 		$output .= "          			<option value='grid' disabled='disabled' ". $product_view3.">". __('Grid View', 'wpsc')."</option>\n\r";

    186. 

  186. 	}	

    187. 

  187. 	$output .= "          		</select>\n\r";	

    188. 

  188. 	$output .= "          	</td>\n\r";

    189. 

  189. 	$output .= "          </tr>\n\r";

    190. 

  190. 	

    191. 

  191. 	

    192. 

  192.   if(function_exists("getimagesize")) {

    193. 

  193. 		$output .= "          <tr>\n\r";

    194. 

  194. 		$output .= "            <td>\n\r";

    195. 

  195. 		$output .= __('Thumbnail&nbsp;Size', 'wpsc').": ";

    196. 

  196. 		$output .= "            </td>\n\r";

    197. 

  197. 		$output .= "            <td>\n\r";

    198. 

  198. 		$output .= __('Height', 'wpsc').": <input type='text' value='".$product['image_height']."' name='product_height' size='6'/> ";

    199. 

  199. 		$output .= __('Width', 'wpsc').": <input type='text' value='".$product['image_width']."' name='product_width' size='6'/> <br/>";

    200. 

  200. 		$output .= "            </td>\n\r";

    201. 

  201. 		$output .= "          </tr>\n\r";

    202. 

  202. 	}

    203. 

  203. 

    204. 

  204. 

    205. 

  205. 

    206. 

  206. 	$output .= "          <tr>\n\r";

    207. 

  207. 	$output .= "          	<td colspan='2' class='category_presentation_settings'>\n\r";

    208. 

  208. 	$output .= "          		<h4>".__('Checkout Settings', 'wpsc')."</h4>\n\r";

    209. 

  209. 	//$output .= "          		<span class='small'>".__('To over-ride the presentation settings for this group you can enter in your prefered settings here', 'wpsc')."</span>\n\r";

    210. 

  210. 	$output .= "          	</td>\n\r";

    211. 

  211. 	$output .= "          </tr>\n\r";

    212. 

  212. 

    213. 

  213. 	

    214. 

  214. 		$used_additonal_form_set = wpsc_get_categorymeta($product['id'], 'use_additonal_form_set');

    215. 

  215. 		$output .= "          <tr>\n\r";

    216. 

  216. 		$output .= "            <td>\n\r";

    217. 

  217. 		$output .= __("This category requires additional checkout form fields",'wpsc').": ";

    218. 

  218. 		$output .= "            </td>\n\r";

    219. 

  219. 		$output .= "            <td>\n\r";

    220. 

  220. 		

    221. 

  221. 		$output .= "            <select name='use_additonal_form_set'>\n\r";

    222. 

  222. 		$output .= "            	<option value=''>".__("None",'wpsc')."</option>\n\r";

    223. 

  223. 		

    224. 

  224. 		$checkout_sets = get_option('wpsc_checkout_form_sets');

    225. 

  225. 		unset($checkout_sets[0]);

    226. 

  226. 		foreach((array)$checkout_sets as $key => $value) {

    227. 

  227. 			$selected_state = "";

    228. 

  228. 			if($used_additonal_form_set == $key) {

    229. 

  229. 				$selected_state = "selected='selected'";

    230. 

  230. 			}

    231. 

  231. 			$output .= "            <option {$selected_state} value='{$key}'>".stripslashes($value)."</option>\n\r";

    232. 

  232. 		}

    233. 

  233. 		$output .= "            </select>\n\r";

    234. 

  234.     //$output .= "            <label><input type='radio' value='1' name='uses_additonal_forms' ".(($uses_additional_forms == true) ? "checked='checked'" : "")." />".__("Yes",'wpsc')."</label>";

    235. 

  235. 		//$output .= "            <label><input type='radio' value='0' name='uses_additonal_forms' ".(($uses_additional_forms != true) ? "checked='checked'" : "")." />".__("No",'wpsc')."</label>";

    236. 

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

    237. 

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

    238. 

  238. 

    239. 

  239. 

    240. 

  240. 	$output .= "          <tr>";

    241. 

  241. 	$output .= "          	<td colspan='2'>						</td>";

    242. 

  242. 	$output .= "          </tr>";

    243. 

  243. 		

    244. 

  244. 		$uses_billing_address = (bool)wpsc_get_categorymeta($product['id'], 'uses_billing_address');

    245. 

  245. 		$output .= "          <tr>\n\r";

    246. 

  246. 		$output .= "            <td>\n\r";

    247. 

  247. 		$output .= __("Products in this category use the billing address to calculate shipping",'wpsc').": ";

    248. 

  248. 		$output .= "            </td>\n\r";

    249. 

  249. 		$output .= "            <td>\n\r";

    250. 

  250.     $output .= "            <label><input type='radio' value='1' name='uses_billing_address' ".(($uses_billing_address == true) ? "checked='checked'" : "")." />".__("Yes",'wpsc')."</label>";

    251. 

  251. 		$output .= "            <label><input type='radio' value='0' name='uses_billing_address' ".(($uses_billing_address != true) ? "checked='checked'" : "")." />".__("No",'wpsc')."</label>";

    252. 

  252. 		$output .= "            </td>\n\r";

    253. 

  253. 		$output .= "          </tr>\n\r";

    254. 

  254. 

    255. 

  255.   $output .= "          <tr>\n\r";

    256. 

  256.   $output .= "            <td>\n\r";

    257. 

  257.   $output .= "            </td>\n\r";

    258. 

  258.   $output .= "            <td class='last_row'>\n\r";

    259. 

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

    260. 

  260.   $output .= "<input type='hidden' name='submit_action' value='edit' />";

    261. 

  261.   $output .= "<input class='button-primary' style='float:left;' type='submit' name='submit' value='".__('Update Category', 'wpsc')."' />";

    262. 

  262. 	$output .= "<a class='delete_button' href='".add_query_arg('deleteid', $product['id'], 'admin.php?page=wpsc-edit-groups')."' onclick=\"return conf();\" >".__('Delete', 'wpsc')."</a>";

    263. 

  263.   $output .= "            </td>\n\r";

    264. 

  264.   $output .= "          </tr>\n\r";

    265. 

  265.  $output .= "        </table>\n\r"; 

    266. 

  266.   return $output;

    267. 

  267.   }

    268. 

  268. 

    269. 

  269. function nzshpcrt_getvariationform($variation_id)

    270. 

  270.   {

    271. 

  271.   global $wpdb,$nzshpcrt_imagesize_info;

    272. 

  272. 

    273. 

  273.   $variation_sql = "SELECT * FROM `".WPSC_TABLE_PRODUCT_VARIATIONS."` WHERE `id`='$variation_id' LIMIT 1";

    274. 

  274.   $variation_data = $wpdb->get_results($variation_sql,ARRAY_A) ;

    275. 

  275.   $variation = $variation_data[0];

    276. 

  276.   $output .= "        <table class='category_forms' >\n\r";

    277. 

  277.   $output .= "          <tr>\n\r";

    278. 

  278.   $output .= "            <td>\n\r";

    279. 

  279.   $output .= __('Name', 'wpsc').": ";

    280. 

  280.   $output .= "            </td>\n\r";

    281. 

  281.   $output .= "            <td>\n\r";

    282. 

  282.   $output .= "<input type='text'  class='text' name='title' value='".htmlentities(stripslashes($variation['name']), ENT_QUOTES, 'UTF-8')."' />";

    283. 

  283.   $output .= "            </td>\n\r";

    284. 

  284.   $output .= "          </tr>\n\r";

    285. 

  285. 

    286. 

  286.   $output .= "          <tr>\n\r";

    287. 

  287.   $output .= "            <td>\n\r";

    288. 

  288.   $output .= __('Variation Values', 'wpsc').": ";

    289. 

  289.   $output .= "            </td>\n\r";

    290. 

  290.   $output .= "            <td>\n\r";

    291. 

  291.   $variation_values_sql = "SELECT * FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `variation_id`='$variation_id' ORDER BY `id` ASC";

    292. 

  292.   $variation_values = $wpdb->get_results($variation_values_sql,ARRAY_A);

    293. 

  293.   $variation_value_count = count($variation_values);

    294. 

  294.   $output .= "<div id='edit_variation_values'>";

    295. 

  295.   $num = 0;

    296. 

  296.   foreach($variation_values as $variation_value) {

    297. 

  297.     $output .= "<span class='variation_value'>";

    298. 

  298.     $output .= "<input type='text' class='text' name='variation_values[".$variation_value['id']."]' value='".htmlentities(stripslashes($variation_value['name']), ENT_QUOTES, 'UTF-8')."' />";

    299. 

  299.     if($variation_value_count > 1) {

    300. 

  300.       $output .= " <a  class='image_link' onclick='return remove_variation_value(this,".$variation_value['id'].")' href='#'><img src='".WPSC_URL."/images/trash.gif' alt='".__('Delete', 'wpsc')."' title='".__('Delete', 'wpsc')."' /></a>";

    301. 

  301. 		}

    302. 

  302.     $output .= "<br />";

    303. 

  303.     $output .= "</span>";

    304. 

  304.     $num++;

    305. 

  305. 	}

    306. 

  306.   $output .= "</div>";

    307. 

  307.   $output .= "<a href='#'  onclick='return add_variation_value(\"edit\")'>".__('Add', 'wpsc')."</a>";

    308. 

  308.   $output .= "            </td>\n\r";

    309. 

  309.   $output .= "          </tr>\n\r";

    310. 

  310.   $output .= "          </tr>\n\r";

    311. 

  311. 

    312. 

  312.   $output .= "          <tr>\n\r";

    313. 

  313.   $output .= "            <td>\n\r";

    314. 

  314.   $output .= "            </td>\n\r";

    315. 

  315.   $output .= "            <td>\n\r";

    316. 

  316.   $output .= "<input type='hidden' name='prodid' value='".$variation['id']."' />";

    317. 

  317.   $output .= "<input type='hidden' name='submit_action' value='edit' />";

    318. 

  318.   $output .= "<input class='button' style='float:left;'  type='submit' name='submit' value='".__('Edit', 'wpsc')."' />";

    319. 

  319.   $output .= "<a class='button delete_button' href='admin.php?page=".WPSC_DIR_NAME."/display_variations.php&amp;deleteid=".$variation['id']."' onclick=\"return conf();\" >".__('Delete', 'wpsc')."</a>";

    320. 

  320.   $output .= "            </td>\n\r";

    321. 

  321.   $output .= "          </tr>\n\r";

    322. 

  322.  $output .= "        </table>\n\r";

    323. 

  323.   return $output;

    324. 

  324.   }

    325. 

  325. 

    326. 

  326. function coupon_edit_form($coupon) {

    327. 

  327. 

    328. 

  328. $conditions = unserialize($coupon['condition']);

    329. 

  329. 	//exit('<pre>'.print_r($coupon, true).'</pre>');

    330. 

  330. 

    331. 

  331.   $start_timestamp = strtotime($coupon['start']);

    332. 

  332.   $end_timestamp = strtotime($coupon['expiry']);

    333. 

  333.   $id = $coupon['id'];

    334. 

  334.   $output = '';

    335. 

  335.   $output .= "<form class='displaynone' name='edit_coupon' id='".$coupon['coupon_code']."' method='post' action=''>\n\r";

    336. 

  336.     $output .= "   <input type='hidden' value='true' name='is_edit_coupon' />\n\r";

    337. 

  337.   $output .= "<table class='add-coupon'>\n\r";

    338. 

  338.   $output .= " <tr>\n\r";

    339. 

  339.   $output .= "   <th>".__('Coupon Code', 'wpsc')."</th>\n\r";

    340. 

  340.   $output .= "   <th>".__('Discount', 'wpsc')."</th>\n\r";

    341. 

  341.   $output .= "   <th>".__('Start', 'wpsc')."</th>\n\r";

    342. 

  342.   $output .= "   <th>".__('Expiry', 'wpsc')."</th>\n\r";

    343. 

  343.   $output .= "   <th>".__('Use Once', 'wpsc')."</th>\n\r";

    344. 

  344.   $output .= "   <th>".__('Active', 'wpsc')."</th>\n\r";

    345. 

  345. 	$output .= "   <th>".__('Apply On All Products', 'wpsc')."</th>\n\r";

    346. 

  346.   $output .= "   <th></th>\n\r";

    347. 

  347.   $output .= " </tr>\n\r";

    348. 

  348.   $output .= " <tr>\n\r";

    349. 

  349.   $output .= "  <td>\n\r";

    350. 

  350.   $output .= "   <input type='text' size='8' value='".$coupon['coupon_code']."' name='edit_coupon[".$id."][coupon_code]' />\n\r";

    351. 

  351.   $output .= "  </td>\n\r";

    352. 

  352.   $output .= "  <td>\n\r";

    353. 

  353.   $output .= "   <input type='text' style='width:28px;' value='".$coupon['value']."'  name=edit_coupon[".$id."][value]' />";

    354. 

  354.   $output .= "   <select style='width:20px;' name='edit_coupon[".$id."][is-percentage]'>";

    355. 

  355.   $output .= "     <option value='0' ".(($coupon['is-percentage'] == 0) ? "selected='true'" : '')." >$</option>\n\r";//

    356. 

  356.   $output .= "     <option value='1' ".(($coupon['is-percentage'] == 1) ? "selected='true'" : '')." >%</option>\n\r";

    357. 

  357.   $output .= "     <option value='2' ".(($coupon['is-percentage'] == 2) ? "selected='true'" : '')." >Free shipping</option>\n\r";

    358. 

  358.   $output .= "   </select>\n\r";

    359. 

  359.   $output .= "  </td>\n\r";

    360. 

  360.   $output .= "  <td>\n\r";

    361. 

  361.   $coupon_start = explode(" ",$coupon['start']);

    362. 

  362.   $output .= "<input type='text' class='pickdate' size='8' name='edit_coupon[".$id."][start]' value='{$coupon_start[0]}'>";

    363. 

  363. /*  $output .= "   <select name='edit_coupon[".$id."][start][day]'>\n\r";

    364. 

  364.    for($i = 1; $i <=31; ++$i) {

    365. 

  365.      $selected = '';

    366. 

  366.      if($i == date("d", $start_timestamp)) { $selected = "selected='true'"; }

    367. 

  367.      $output .= "    <option $selected value='$i'>$i</option>";

    368. 

  368.      }

    369. 

  369.   $output .= "   </select>\n\r";

    370. 

  370.   $output .= "   <select name='edit_coupon[".$id."][start][month]'>\n\r";

    371. 

  371.    for($i = 1; $i <=12; ++$i) {

    372. 

  372.      $selected = '';

    373. 

  373.      if($i == (int)date("m", $start_timestamp)) { $selected = "selected='true'"; }

    374. 

  374.      $output .= "    <option $selected value='$i'>".date("M",mktime(0, 0, 0, $i, 1, date("Y")))."</option>";

    375. 

  375.      }

    376. 

  376.   $output .= "   </select>\n\r";

    377. 

  377.   $output .= "   <select name='edit_coupon[".$id."][start][year]'>\n\r";

    378. 

  378.    for($i = date("Y"); $i <= (date("Y") +12); ++$i) {

    379. 

  379.      $selected = '';

    380. 

  380.      if($i == date("Y", $start_timestamp)) { $selected = "selected='true'"; }

    381. 

  381.      $output .= "    <option $selected value='$i'>".$i."</option>";

    382. 

  382.      }

    383. 

  383.   $output .= "   </select>\n\r";*/

    384. 

  384.   $output .= "  </td>\n\r";

    385. 

  385.   $output .= "  <td>\n\r";

    386. 

  386.   $coupon_expiry = explode(" ",$coupon['expiry']);

    387. 

  387.   $output .= "<input type='text' class='pickdate' size='8' name='edit_coupon[".$id."][expiry]' value='{$coupon_expiry[0]}'>";

    388. 

  388.   /*$output .= "   <select name='edit_coupon[".$id."][expiry][day]'>\n\r";

    389. 

  389.    for($i = 1; $i <=31; ++$i) {

    390. 

  390.      $selected = '';

    391. 

  391.      if($i == date("d", $end_timestamp)) { $selected = "selected='true'"; }

    392. 

  392.      $output .= "    <option $selected value='$i'>$i</option>";

    393. 

  393.      }

    394. 

  394.   $output .= "   </select>\n\r";

    395. 

  395.   $output .= "   <select name='edit_coupon[".$id."][expiry][month]'>\n\r";

    396. 

  396. 

    397. 

  397.    for($i = 1; $i <=12; ++$i) {

    398. 

  398.      $selected = '';

    399. 

  399.      if($i == (int)date("m", $end_timestamp)) { $selected = "selected='true'"; }

    400. 

  400.      $output .= "    <option $selected value='$i'>".date("M",mktime(0, 0, 0, $i, 1, date("Y")))."</option>";

    401. 

  401.      }

    402. 

  402.   $output .= "   </select>\n\r";

    403. 

  403.   $output .= "   <select name='edit_coupon[".$id."][expiry][year]'>\n\r";

    404. 

  404.    for($i = date("Y"); $i <= (date("Y") +12); ++$i) {

    405. 

  405.      $selected = '';

    406. 

  406.      if($i == (date("Y", $end_timestamp))) { $selected = "selected='true'"; }

    407. 

  407.      $output .= "    <option $selected value='$i'>".$i."</option>\n\r";

    408. 

  408.      }

    409. 

  409.   $output .= "   </select>\n\r";*/

    410. 

  410.   $output .= "  </td>\n\r";

    411. 

  411.   $output .= "  <td>\n\r";

    412. 

  412.   $output .= "   <input type='hidden' value='0' name='edit_coupon[".$id."][use-once]' />\n\r";

    413. 

  413.   $output .= "   <input type='checkbox' value='1' ".(($coupon['use-once'] == 1) ? "checked='checked'" : '')." name='edit_coupon[".$id."][use-once]' />\n\r";

    414. 

  414.   $output .= "  </td>\n\r";

    415. 

  415.   $output .= "  <td>\n\r";

    416. 

  416.   $output .= "   <input type='hidden' value='0' name='edit_coupon[".$id."][active]' />\n\r";

    417. 

  417.   $output .= "   <input type='checkbox' value='1' ".(($coupon['active'] == 1) ? "checked='checked'" : '')." name='edit_coupon[".$id."][active]' />\n\r";

    418. 

  418.   $output .= "  </td>\n\r";

    419. 

  419.   $output .= "  <td>\n\r";

    420. 

  420.   $output .= "   <input type='hidden' value='0' name='edit_coupon[".$id."][every_product]' />\n\r";

    421. 

  421.   $output .= "   <input type='checkbox' value='1' ".(($coupon['every_product'] == 1) ? "checked='checked'" : '')." name='edit_coupon[".$id."][every_product]' />\n\r";

    422. 

  422.   $output .= "  </td>\n\r";

    423. 

  423.   $output .= "  <td>\n\r";

    424. 

  424.   $output .= "   <input type='hidden' value='".$id."' name='edit_coupon[".$id."][id]' />\n\r";

    425. 

  425.   //$output .= "   <input type='hidden' value='false' name='add_coupon' />\n\r";

    426. 

  426.  /*

    427. 

  427.  $output .= "   <input type='submit' value='".__('Update Coupon', 'wpsc')."' name='edit_coupon[".$id."][submit_coupon]' />\n\r";

    428. 

  428.   $output .= "   <input type='submit' value='".__('Delete Coupon', 'wpsc')."' name='edit_coupon[".$id."][delete_coupon]' />\n\r";

    429. 

  429. */

    430. 

  430. 

    431. 

  431.   $output .= "  </td>\n\r";

    432. 

  432.   $output .= " </tr>\n\r";

    433. 

  433. 

    434. 

  434.   if($conditions != null){

    435. 

  435. 	  $output .= "<tr>";

    436. 

  436. 	  $output .= "<th>";

    437. 

  437. 	  $output .= "Conditions";

    438. 

  438. 	  $output .= "</th>";

    439. 

  439. 	  $output .= "</tr>";

    440. 

  440. 	  $output .= "<th>";

    441. 

  441. 	  $output .= "Delete";

    442. 

  442. 	  $output .= "</th>";

    443. 

  443. 	  $output .= "<th>";

    444. 

  444. 	  $output .= "Property";

    445. 

  445. 	  $output .= "</th>";

    446. 

  446. 	  $output .= "<th>";

    447. 

  447. 	  $output .= "Logic";

    448. 

  448. 	  $output .= "</th>";

    449. 

  449. 	  $output .= "<th>";

    450. 

  450. 	  $output .= "Value";

    451. 

  451. 	  $output .= "</th>";

    452. 

  452. 	  $output .= " </tr>\n\r";

    453. 

  453. 	  $i=0;

    454. 

  454. 	  foreach ($conditions as $condition){

    455. 

  455. 		  $output .= "<tr>";

    456. 

  456. 		  $output .= "<td>";

    457. 

  457. 		  $output .= "<input type='hidden' name='coupon_id' value='".$id."' />";

    458. 

  458. 		  $output .= "<input type='submit' id='delete_condition".$i."' style='display:none;' value='".$i."' name='delete_condition' />";

    459. 

  459. 		  $output .= "<span style='cursor:pointer;' class='delete_button' onclick='jQuery(\"#delete_condition".$i."\").click()'>Delete</span>";

    460. 

  460. 		  $output .= "</td>";

    461. 

  461. 		  $output .= "<td>";

    462. 

  462. 		  $output .= $condition['property'];

    463. 

  463. 		  $output .= "</td>";

    464. 

  464. 		  $output .= "<td>";

    465. 

  465. 		  $output .= $condition['logic'];

    466. 

  466. 		  $output .= "</td>";

    467. 

  467. 		  $output .= "<td>";

    468. 

  468. 		  $output .= $condition['value'];

    469. 

  469. 		  $output .= "</td>";

    470. 

  470. 		  $output .= "</tr>";

    471. 

  471. 		  $i++;

    472. 

  472. 	  }

    473. 

  473. 	  $output .=	wpsc_coupons_conditions( $id);

    474. 

  474.   }elseif($conditions == null){

    475. 

  475.   	$output .=	wpsc_coupons_conditions( $id);

    476. 

  476. 

    477. 

  477.   }

    478. 

  478.   ?>

    479. 

  479. <!--

    480. 

  480.   <tr><td colspan="8">

    481. 

  481. 	<div class="coupon_condition">

    482. 

  482. 		<div><img height="16" width="16" class="delete" alt="Delete" src="<?=WPSC_URL?>/images/cross.png"/></button>

    483. 

  483. 			<select class="ruleprops" name="rules[property][]">

    484. 

  484. 				<option value="item_name" rel="order">Item name</option>

    485. 

  485. 				<option value="item_quantity" rel="order">Item quantity</option>

    486. 

  486. 				<option value="total_quantity" rel="order">Total quantity</option>

    487. 

  487. 				<option value="subtotal_amount" rel="order">Subtotal amount</option>

    488. 

  488. 			</select>

    489. 

  489. 			<select name="rules[logic][]">

    490. 

  490. 				<option value="equal">Is equal to</option>

    491. 

  491. 				<option value="greater">Is greater than</option>

    492. 

  492. 				<option value="less">Is less than</option>

    493. 

  493. 				<option value="contains">Contains</option>

    494. 

  494. 				<option value="not_contain">Does not contain</option>

    495. 

  495. 				<option value="begins">Begins with</option>

    496. 

  496. 				<option value="ends">Ends with</option>

    497. 

  497. 			</select>

    498. 

  498. 			<span>

    499. 

  499. 				<input type="text" name="rules[value][]"/>

    500. 

  500. 			</span>

    501. 

  501. 			<span>

    502. 

  502. 				<button class="add" type="button">

    503. 

  503. 					<img height="16" width="16" alt="Add" src="<?php //WPSC_URL?>/images/add.png"/>

    504. 

  504. 				</button>

    505. 

  505. 			</span>

    506. 

  506. 		</div>

    507. 

  507. 	</div>

    508. 

  508. </tr>

    509. 

  509. -->

    510. 

  510. 

    511. 

  511.   <?php

    512. 

  512.   $output .= "</table>\n\r";

    513. 

  513.   $output .= "</form>\n\r";

    514. 

  514.   echo $output;

    515. 

  515.   return $output;

    516. 

  516.   }

    517. 

  517. function wpsc_coupons_conditions($id){

    518. 

  518. ?>

    519. 

  519. 

    520. 

  520. <?php

    521. 

  521. 

    522. 

  522. $output ='

    523. 

  523. <input type="hidden" name="coupon_id" value="'.$id.'" />

    524. 

  524. <tr><td colspan="3"><b>Add Conditions</b></td></tr>

    525. 

  525. <tr><td colspan="6">

    526. 

  526. 	<div class="coupon_condition">

    527. 

  527. 		<div>

    528. 

  528. 			<select class="ruleprops" name="rules[property][]">

    529. 

  529. 				<option value="item_name" rel="order">Item name</option>

    530. 

  530. 				<option value="item_quantity" rel="order">Item quantity</option>

    531. 

  531. 				<option value="total_quantity" rel="order">Total quantity</option>

    532. 

  532. 				<option value="subtotal_amount" rel="order">Subtotal amount</option>

    533. 

  533. 				' . apply_filters( 'wpsc_coupon_rule_property_options', '' ) . '

    534. 

  534. 			</select>

    535. 

  535. 			<select name="rules[logic][]">

    536. 

  536. 				<option value="equal">Is equal to</option>

    537. 

  537. 				<option value="greater">Is greater than</option>

    538. 

  538. 				<option value="less">Is less than</option>

    539. 

  539. 				<option value="contains">Contains</option>

    540. 

  540. 				<option value="not_contain">Does not contain</option>

    541. 

  541. 				<option value="begins">Begins with</option>

    542. 

  542. 				<option value="ends">Ends with</option>

    543. 

  543. 			</select>

    544. 

  544. 			<span>

    545. 

  545. 				<input type="text" name="rules[value][]"/>

    546. 

  546. 			</span>

    547. 

  547. 			

    548. 

  548. 

    549. 

  549. 		</div>

    550. 

  550. 	</div>

    551. 

  551. 	</td>

    552. 

  552. 	<td colspan="3">

    553. 

  553. 	

    554. 

  554. 		<input type="submit" value="'.__("Update Coupon", "wpsc").'" name="edit_coupon['.$id.'][submit_coupon]" />

    555. 

  555.  		<input type="submit" value="'.__("Delete Coupon", "wpsc").'" name="edit_coupon['.$id.'][delete_coupon]" />

    556. 

  556. 	</td>

    557. 

  557. </tr>

    558. 

  558. ';

    559. 

  559. return $output;

    560. 

  560. 

    561. 

  561. }  

    562. 

  562. function setting_button(){

    563. 

  563. 	$next_url  = 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF']."?page=wpsc-edit-products";

    564. 

  564. 	

    565. 

  565. // 	$output.="<div><img src='".get_option('siteurl')."/wp-content/plugins/".WPSC_DIR_NAME."/images/settings_button.jpg' onclick='display_settings_button()'>";

    566. 

  566. 	$output.="<div style='float: right; margin-top: 0px; position: relative;'> | <a href='#' onclick='display_settings_button(); return false;' style='text-decoration: underline;'>".__('Settings', 'wpsc')." &raquo;</a>";

    567. 

  567. 	$output.="<span id='settings_button' style='width:180px;background-color:#f1f1f1;position:absolute; right: 10px; border:1px solid black; display:none;'>";

    568. 

  568. 	$output.="<ul class='settings_button'>";

    569. 

  569. 	

    570. 

  570. 	$output.="<li><a href='admin.php?page=wpsc-settings'>".__('Shop Settings', 'wpsc')."</a></li>";

    571. 

  571. 	$output.="<li><a href='admin.php?page=wpsc-settings&amp;tab=gateway'>".__('Money and Payment', 'wpsc')."</a></li>";

    572. 

  572. 	$output.="<li><a href='admin.php?page=wpsc-settings&amp;tab=checkout'>".__('Checkout Page Settings', 'wpsc')."</a></li>";

    573. 

  573. 	//$output.="<li><a href='?page=".WPSC_DIR_NAME."/instructions.php'>Help/Upgrade</a></li>";

    574. 

  574. 	$output.="</ul>";

    575. 

  575. //	$output.="<div>Checkout Settings</div>";

    576. 

  576. 	$output.="</span>&emsp;&emsp;</div>";

    577. 

  577. 	

    578. 

  578. 	return $output;

    579. 

  579. }

    580. 

  580. 

    581. 

  581. function wpsc_right_now($hidden = '') {

    582. 

  582.   global $wpdb,$nzshpcrt_imagesize_info;

    583. 

  583. 	$year = date("Y");

    584. 

  584. 	$month = date("m");

    585. 

  585. 	$start_timestamp = mktime(0, 0, 0, $month, 1, $year);

    586. 

  586. 	$end_timestamp = mktime(0, 0, 0, ($month+1), 0, $year);

    587. 

  587. 

    588. 

  588.   $replace_values[":productcount:"] = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `active` IN ('1')");

    589. 

  589.   $product_count = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `active` IN ('1')");

    590. 

  590.   $replace_values[":productcount:"] .= " ".(($replace_values[":productcount:"] == 1) ? __('product', 'wpsc') : __('products', 'wpsc'));

    591. 

  591.   $product_unit = (($replace_values[":productcount:"] == 1) ? __('product', 'wpsc') : __('products', 'wpsc'));

    592. 

  592.   

    593. 

  593.   $replace_values[":groupcount:"] = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `active` IN ('1')");

    594. 

  594.   $group_count = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `active` IN ('1')");

    595. 

  595.   $replace_values[":groupcount:"] .= " ".(($replace_values[":groupcount:"] == 1) ? __('group', 'wpsc') : __('groups', 'wpsc'));

    596. 

  596.   $group_unit = (($replace_values[":groupcount:"] == 1) ? __('group', 'wpsc') : __('groups', 'wpsc'));

    597. 

  597.   

    598. 

  598.   $replace_values[":salecount:"] = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PURCHASE_LOGS."` WHERE `date` BETWEEN '".$start_timestamp."' AND '".$end_timestamp."'");

    599. 

  599.   $sales_count = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PURCHASE_LOGS."` WHERE `date` BETWEEN '".$start_timestamp."' AND '".$end_timestamp."'");

    600. 

  600.   $replace_values[":salecount:"] .= " ".(($replace_values[":salecount:"] == 1) ? __('sale', 'wpsc') : __('sales', 'wpsc'));

    601. 

  601.   $sales_unit = (($replace_values[":salecount:"] == 1) ? __('sale', 'wpsc') : __('sales', 'wpsc'));

    602. 

  602. 		

    603. 

  603.   $replace_values[":monthtotal:"] = nzshpcrt_currency_display(admin_display_total_price($start_timestamp, $end_timestamp),1);

    604. 

  604.   $replace_values[":overaltotal:"] = nzshpcrt_currency_display(admin_display_total_price(),1);

    605. 

  605.   

    606. 

  606.   $variation_count = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PRODUCT_VARIATIONS."`");

    607. 

  607.   $variation_unit = (($variation_count == 1) ? __('variation', 'wpsc') : __('variations', 'wpsc'));

    608. 

  608.   

    609. 

  609.   $replace_values[":pendingcount:"] = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PURCHASE_LOGS."` WHERE `processed` IN ('1')");

    610. 

  610.   $pending_sales = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PURCHASE_LOGS."` WHERE `processed` IN ('1')");

    611. 

  611.   $replace_values[":pendingcount:"] .= " " . (($replace_values[":pendingcount:"] == 1) ? __('transaction', 'wpsc') : __('transactions', 'wpsc'));

    612. 

  612.   $pending_sales_unit = (($replace_values[":pendingcount:"] == 1) ? __('transaction', 'wpsc') : __('transactions', 'wpsc'));

    613. 

  613.   

    614. 

  614.   $accept_sales = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PURCHASE_LOGS."` WHERE `processed` IN ('2' ,'3', '4')");

    615. 

  615.   $accept_sales_unit = (($accept_sales == 1) ? __('transaction', 'wpsc') : __('transactions', 'wpsc'));

    616. 

  616. 

    617. 

  617.   

    618. 

  618.   $replace_values[":theme:"] = get_option('wpsc_selected_theme');

    619. 

  619.   $replace_values[":versionnumber:"] = WPSC_PRESENTABLE_VERSION;

    620. 

  620. 	if (function_exists('add_object_page')) {

    621. 

  621. 		$output="";	

    622. 

  622. 		$output.="<div id='dashboard_right_now' class='postbox ".((array_search('dashboard_right_now', $hidden) !== false) ? 'closed' : '')."'>";

    623. 

  623. 		$output.="	<h3 class='hndle'>";

    624. 

  624. 		$output.="		<span>".__('Current Month', 'wpsc')."</span>";

    625. 

  625. 		$output.="		<br class='clear'/>";

    626. 

  626. 		$output.="	</h3>";

    627. 

  627. 		

    628. 

  628. 		$output .= "<div class='inside'>";

    629. 

  629. 		$output .= "<p class='sub'>".__('At a Glance', 'wpsc')."</p>";

    630. 

  630. 		//$output.="<p class='youhave'>".__('You have <a href='admin.php?page=wpsc-edit-products'>:productcount:</a>, contained within <a href='admin.php?page=wpsc-edit-groups'>:groupcount:</a>. This month you made :salecount: and generated a total of :monthtotal: and your total sales ever is :overaltotal:. You have :pendingcount: awaiting approval.', 'wpsc')."</p>";

    631. 

  631. 		$output .= "<div class='table'>";

    632. 

  632. 		$output .= "<table>";

    633. 

  633. 		

    634. 

  634. 		$output .= "<tr class='first'>";

    635. 

  635. 		$output .= "<td class='first b'>";

    636. 

  636. 		$output .= "<a href='?page=wpsc-edit-products'>".$product_count."</a>";

    637. 

  637. 		$output .= "</td>";

    638. 

  638. 		$output .= "<td class='t'>";

    639. 

  639. 		$output .= ucfirst($product_unit);

    640. 

  640. 		$output .= "</td>";

    641. 

  641. 		$output .= "<td class='b'>";

    642. 

  642. 		$output .= "<a href='?page=wpsc-sales-logs'>".$sales_count."</a>";

    643. 

  643. 		$output .= "</td>";

    644. 

  644. 		$output .= "<td class='last'>";

    645. 

  645. 		$output .= ucfirst($sales_unit);

    646. 

  646. 		$output .= "</td>";

    647. 

  647. 		$output .= "</tr>";

    648. 

  648. 		

    649. 

  649. 		$output .= "<tr>";

    650. 

  650. 		$output .= "<td class='first b'>";

    651. 

  651. 		$output .= "<a href='?page=wpsc-edit-groups'>".$group_count."</a>";

    652. 

  652. 		$output .= "</td>";

    653. 

  653. 		$output .= "<td class='t'>";

    654. 

  654. 		$output .= ucfirst($group_unit);

    655. 

  655. 		$output .= "</td>";

    656. 

  656. 		$output .= "<td class='b'>";

    657. 

  657. 		$output .= "<a href='?page=wpsc-sales-logs'>".$pending_sales."</a>";

    658. 

  658. 		$output .= "</td>";

    659. 

  659. 		$output .= "<td class='last t waiting'>".__('Pending', 'wpsc')." ";

    660. 

  660. 		$output .= ucfirst($pending_sales_unit);

    661. 

  661. 		$output .= "</td>";

    662. 

  662. 		$output .= "</tr>";

    663. 

  663. 		

    664. 

  664. 		$output .= "<tr>";

    665. 

  665. 		$output .= "<td class='first b'>";

    666. 

  666. 		$output .= "<a href='?page=wpsc-edit-variations'>".$variation_count."</a>";

    667. 

  667. 		$output .= "</td>";

    668. 

  668. 		$output .= "<td class='t'>";

    669. 

  669. 		$output .= ucfirst($variation_unit);

    670. 

  670. 		$output .= "</td>";

    671. 

  671. 		$output .= "<td class='b'>";

    672. 

  672. 		$output .= "<a href='?page=wpsc-sales-logs'>".$accept_sales."</a>";

    673. 

  673. 		$output .= "</td>";

    674. 

  674. 		$output .= "<td class='last t approved'>".__('Closed', 'wpsc')." ";

    675. 

  675. 		$output .= ucfirst($accept_sales_unit);

    676. 

  676. 		$output .= "</td>";

    677. 

  677. 		$output .= "</tr>";

    678. 

  678. 		

    679. 

  679. 		$output .= "</table>";

    680. 

  680. 		$output .= "</div>";

    681. 

  681. 		$output .= "<div class='versions'>";

    682. 

  682. 		$output .= "<p><a class='button rbutton' href='admin.php?page=wpsc-edit-products'><strong>".__('Add New Product', 'wpsc')."</strong></a>".__('Here you can add products, groups or variations', 'wpsc')."</p>";

    683. 

  683. 		$output .= "</div>";

    684. 

  684. 		$output .= "</div>";

    685. 

  685. 		$output.="</div>";

    686. 

  686. 	} else {  

    687. 

  687. 		$output="";	

    688. 

  688. 		$output.="<div id='rightnow'>\n\r";

    689. 

  689. 		$output.="	<h3 class='reallynow'>\n\r";

    690. 

  690. 		$output.="		<a class='rbutton' href='admin.php?page=wpsc-edit-products'><strong>".__('Add New Product', 'wpsc')."</strong></a>\n\r";

    691. 

  691. 		$output.="		<span>"._('Right Now')."</span>\n\r";

    692. 

  692. 		

    693. 

  693. 		//$output.="		<br class='clear'/>\n\r";

    694. 

  694. 		$output.="	</h3>\n\r";

    695. 

  695. 		

    696. 

  696. 		$output.="<p class='youhave'>".__('You have <a href="admin.php?page=wpsc-edit-products">:productcount:</a>, contained within <a href="admin.php?page=wpsc-edit-groups">:groupcount:</a>. This month you made :salecount: and generated a total of :monthtotal: and your total sales ever is :overaltotal:. You have :pendingcount: awaiting approval.', 'wpsc')."</p>\n\r";

    697. 

  697. 		$output.="	<p class='youare'>\n\r";

    698. 

  698. 		$output.="		".__('You are using the :theme: style. This is WP e-Commerce :versionnumber:.', 'wpsc')."\n\r";

    699. 

  699. 		//$output.="		<a class='rbutton' href='themes.php'>Change Theme</a>\n\r";

    700. 

  700. 		//$output.="<span id='wp-version-message'>This is WordPress version 2.6. <a class='rbutton' href='http://wordpress.org/download/'>Update to 2.6.1</a></span>\n\r";

    701. 

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

    702. 

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

    703. 

  703. 		$output.="<br />\n\r";

    704. 

  704. 		$output = str_replace(array_keys($replace_values), array_values($replace_values),$output);

    705. 

  705. 	}

    706. 

  706. 	

    707. 

  707. 	return $output;

    708. 

  708. }

    709. 

  709. 

    710. 

  710. 

    711. 

  711. function wpsc_packing_slip($purchase_id) {

    712. 

  712.   global $wpdb, $purchlogitem, $wpsc_cart,$purchlog;

    713. 

  713.   if(isset($_REQUEST['purchaselog_id'])){

    714. 

  714. 	$purchlogitem = new wpsc_purchaselogs_items((int)$_REQUEST['purchaselog_id']);

    715. 

  715.   }

    716. 

  716. 

    717. 

  717. 	$purch_sql = "SELECT * FROM `".WPSC_TABLE_PURCHASE_LOGS."` WHERE `id`='".$purchase_id."'";

    718. 

  718. 		$purch_data = $wpdb->get_row($purch_sql,ARRAY_A) ;

    719. 

  719. 			

    720. 

  720. 

    721. 

  721. 	  //echo "<p style='padding-left: 5px;'><strong>".__('Date', 'wpsc')."</strong>:".date("jS M Y", $purch_data['date'])."</p>";

    722. 

  722. 

    723. 

  723. 		$cartsql = "SELECT * FROM `".WPSC_TABLE_CART_CONTENTS."` WHERE `purchaseid`=".$purchase_id."";

    724. 

  724. 		$cart_log = $wpdb->get_results($cartsql,ARRAY_A) ; 

    725. 

  725. 		$j = 0;

    726. 

  726. 	

    727. 

  727. 		if($cart_log != null) {

    728. 

  728.       echo "<div class='packing_slip'>\n\r";

    729. 

  729. 			echo "<h2>".__('Packing Slip', 'wpsc')."</h2>\n\r";

    730. 

  730. 			echo "<strong>".__('Order', 'wpsc')." #</strong> ".$purchase_id."<br /><br />\n\r";

    731. 

  731. 			

    732. 

  732. 			echo "<table>\n\r";

    733. 

  733. 	/*

    734. 

  734. 		

    735. 

  735. 			$form_sql = "SELECT * FROM `".WPSC_TABLE_SUBMITED_FORM_DATA."` WHERE  `log_id` = '".(int)$purchase_id."'";

    736. 

  736. 			$input_data = $wpdb->get_results($form_sql,ARRAY_A);

    737. 

  737. 	

    738. 

  738. */		

    739. 

  739. 			echo "<tr><td colspan='2'><strong>Billing Info</strong></td></tr>";

    740. 

  740. 			foreach((array)$purchlogitem->userinfo as $userinfo){

    741. 

  741. 				if($userinfo['unique_name'] != 'billingcountry'){

    742. 

  742. 					echo "<tr><td>".$userinfo['name'].": </td><td>".$userinfo['value']."</td></tr>";

    743. 

  743. 				}else{

    744. 

  744. 					$userinfo['value'] = maybe_unserialize($userinfo['value']);

    745. 

  745. 					if(is_array($userinfo['value'] )){

    746. 

  746. 						if(!empty($userinfo['value'][1]) && !is_numeric($userinfo['value'][1])){

    747. 

  747. 							echo "<tr><td>State: </td><td>".$userinfo['value'][1]."</td></tr>";

    748. 

  748. 						}elseif(is_numeric($userinfo['value'][1])){

    749. 

  749. 							echo "<tr><td>State: </td><td>".wpsc_get_state_by_id($userinfo['value'][1],'name')."</td></tr>";

    750. 

  750. 						}

    751. 

  751. 						if(!empty($userinfo['value'][0])){

    752. 

  752. 							echo "<tr><td>Country: </td><td>".$userinfo['value'][0]."</td></tr>";

    753. 

  753. 						}

    754. 

  754. 					}else{

    755. 

  755. 						echo "<tr><td>".$userinfo['name'].": </td><td>".$userinfo['value']."</td></tr>";	

    756. 

  756. 					}

    757. 

  757. 				}

    758. 

  758. 			}

    759. 

  759. 			

    760. 

  760. 			echo "<tr><td colspan='2'><strong>Shipping Info</strong></td></tr>";

    761. 

  761. 			foreach((array)$purchlogitem->shippinginfo as $userinfo){

    762. 

  762. 				if($userinfo['unique_name'] != 'shippingcountry' && $userinfo['unique_name'] != 'shippingstate'){

    763. 

  763. 					echo "<tr><td>".$userinfo['name'].": </td><td>".$userinfo['value']."</td></tr>";

    764. 

  764. 				}elseif($userinfo['unique_name'] == 'shippingcountry'){

    765. 

  765. 					$userinfo['value'] = maybe_unserialize($userinfo['value']);

    766. 

  766. 					if(is_array($userinfo['value'] )){

    767. 

  767. 						if(!empty($userinfo['value'][1]) && !is_numeric($userinfo['value'][1])){

    768. 

  768. 							echo "<tr><td>State: </td><td>".$userinfo['value'][1]."</td></tr>";

    769. 

  769. 						}elseif(is_numeric($userinfo['value'][1])){

    770. 

  770. 							echo "<tr><td>State: </td><td>".wpsc_get_state_by_id($userinfo['value'][1],'name')."</td></tr>";

    771. 

  771. 						}

    772. 

  772. 						if(!empty($userinfo['value'][0])){

    773. 

  773. 							echo "<tr><td>Country: </td><td>".$userinfo['value'][0]."</td></tr>";

    774. 

  774. 						}

    775. 

  775. 					}else{

    776. 

  776. 						echo "<tr><td>".$userinfo['name'].": </td><td>".$userinfo['value']."</td></tr>";	

    777. 

  777. 					}

    778. 

  778. 				}elseif($userinfo['unique_name'] == 'shippingstate'){

    779. 

  779. 					if(!empty($userinfo['value']) && !is_numeric($userinfo['value'])){

    780. 

  780. 						echo "<tr><td>".$userinfo['name'].": </td><td>".$userinfo['value']."</td</tr>>";

    781. 

  781. 					}elseif(is_numeric($userinfo['value'])){

    782. 

  782. 							echo "<tr><td>State: </td><td>".wpsc_get_state_by_id($userinfo['value'],'name')."</td></tr>";

    783. 

  783. 					}

    784. 

  784. 				}

    785. 

  785. 			}

    786. 

  786. 	//		echo('<pre>'.print_r($purchlogitem,true).'</pre>');

    787. 

  787. 			

    788. 

  788. 		/*

    789. 

  789. 	foreach($input_data as $input_row) {

    790. 

  790. 			  $rekeyed_input[$input_row['form_id']] = $input_row;

    791. 

  791. 			}

    792. 

  792. 			

    793. 

  793. 			

    794. 

  794. 			if($input_data != null) {

    795. 

  795.         $form_data = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_CHECKOUT_FORMS."` WHERE `active` = '1'",ARRAY_A);

    796. 

  796.     // exit('<pre>'.print_r($purch_data, true).'</pre>');

    797. 

  797.         foreach($form_data as $form_field) {

    798. 

  798.           switch($form_field['type']) {

    799. 

  799. 			case 'country':

    800. 

  800. 

    801. 

  801. 						$delivery_region_count = $wpdb->get_var("SELECT COUNT(`regions`.`id`) FROM `".WPSC_TABLE_REGION_TAX."` AS `regions` INNER JOIN `".WPSC_TABLE_CURRENCY_LIST."` AS `country` ON `country`.`id` = `regions`.`country_id` WHERE `country`.`isocode` IN('".$wpdb->escape( $purch_data['billing_country'])."')");

    802. 

  802. 

    803. 

  803.             if(is_numeric($purch_data['billing_region']) && ($delivery_region_count > 0)) {

    804. 

  804.               echo "  <tr><td>".__('State', 'wpsc').":</td><td>".wpsc_get_region($purch_data['billing_region'])."</td></tr>\n\r";

    805. 

  805.             }

    806. 

  806.             echo "  <tr><td>".wp_kses($form_field['name'], array() ).":</td><td>".wpsc_get_country($purch_data['billing_country'])."</td></tr>\n\r";

    807. 

  807.             break;

    808. 

  808.                 

    809. 

  809.             case 'delivery_country':

    810. 

  810.             echo "  <tr><td>".$form_field['name'].":</td><td>".wpsc_get_country($purch_data['shipping_country'])."</td></tr>\n\r";

    811. 

  811.             break;

    812. 

  812.                 

    813. 

  813.             case 'heading':

    814. 

  814.             echo "  <tr><td colspan='2'><strong>".wp_kses($form_field['name'], array()).":</strong></td></tr>\n\r";

    815. 

  815.             break;

    816. 

  816.             

    817. 

  817.             default:

    818. 

  818.             if($form_field['unique_name'] == 'shippingstate'){

    819. 

  819.             	echo "  <tr><td>".wp_kses($form_field['name'], array() ).":</td><td>".wpsc_get_region($purch_data['shipping_region'])."</td></tr>\n\r";

    820. 

  820.             }else{

    821. 

  821.             	echo "  <tr><td>".wp_kses($form_field['name'], array() ).":</td><td>".htmlentities(stripslashes($rekeyed_input[$form_field['id']]['value']), ENT_QUOTES,'UTF-8')."</td></tr>\n\r";

    822. 

  822.             }

    823. 

  823.             break;

    824. 

  824.           }

    825. 

  825.         }

    826. 

  826. 			} else {

    827. 

  827.         echo "  <tr><td>".__('Name', 'wpsc').":</td><td>".$purch_data['firstname']." ".$purch_data['lastname']."</td></tr>\n\r";

    828. 

  828.         echo "  <tr><td>".__('Address', 'wpsc').":</td><td>".$purch_data['address']."</td></tr>\n\r";

    829. 

  829.         echo "  <tr><td>".__('Phone', 'wpsc').":</td><td>".$purch_data['phone']."</td></tr>\n\r";

    830. 

  830.         echo "  <tr><td>".__('Email', 'wpsc').":</td><td>".$purch_data['email']."</td></tr>\n\r";

    831. 

  831. 			}

    832. 

  832. */

    833. 

  833. 			

    834. 

  834. 			if(get_option('payment_method') == 2) {

    835. 

  835. 				$gateway_name = '';

    836. 

  836. 				foreach($GLOBALS['nzshpcrt_gateways'] as $gateway) {

    837. 

  837. 					if($purch_data['gateway'] != 'testmode') {

    838. 

  838. 						if($gateway['internalname'] == $purch_data['gateway'] ) {

    839. 

  839. 							$gateway_name = $gateway['name'];

    840. 

  840. 						}

    841. 

  841. 					} else {

    842. 

  842. 						$gateway_name = "Manual Payment";

    843. 

  843. 					}

    844. 

  844. 				}

    845. 

  845. 			}

    846. 

  846. // 			echo "  <tr><td colspan='2'></td></tr>\n\r";

    847. 

  847. // 			echo "  <tr><td>".__('Payment Method', 'wpsc').":</td><td>".$gateway_name."</td></tr>\n\r";

    848. 

  848. // 			//echo "  <tr><td>".__('Purchase No.', 'wpsc').":</td><td>".$purch_data['id']."</td></tr>\n\r";

    849. 

  849. // 			echo "  <tr><td>".__('How The Customer Found Us', 'wpsc').":</td><td>".$purch_data['find_us']."</td></tr>\n\r";

    850. 

  850. // 			$engrave_line = explode(",",$purch_data['engravetext']);

    851. 

  851. // 			echo "  <tr><td>".__('Engrave text', 'wpsc')."</td><td></td></tr>\n\r";

    852. 

  852. // 			echo "  <tr><td>".__('Line 1', 'wpsc').":</td><td>".$engrave_line[0]."</td></tr>\n\r";

    853. 

  853. // 			echo "  <tr><td>".__('Line 2', 'wpsc').":</td><td>".$engrave_line[1]."</td></tr>\n\r";

    854. 

  854. // 			if($purch_data['transactid'] != '') {

    855. 

  855. // 				echo "  <tr><td>".__('Transaction Id', 'wpsc').":</td><td>".$purch_data['transactid']."</td></tr>\n\r";

    856. 

  856. // 			}

    857. 

  857. 			echo "</table>\n\r";

    858. 

  858. 			

    859. 

  859. 			

    860. 

  860. 			

    861. 

  861. 			

    862. 

  862.       echo "<table class='packing_slip'>";

    863. 

  863. 				

    864. 

  864. 				echo "<tr>";

    865. 

  865. 				echo " <th>".__('Quantity', 'wpsc')." </th>";

    866. 

  866. 				

    867. 

  867. 				echo " <th>".__('Name', 'wpsc')."</th>";

    868. 

  868. 				

    869. 

  869. 				

    870. 

  870. 				echo " <th>".__('Price', 'wpsc')." </th>";

    871. 

  871. 				

    872. 

  872. 				echo " <th>".__('Shipping', 'wpsc')." </th>";

    873. 

  873. 				echo "<th>".wpsc_display_tax_label(false)."</th>";

    874. 

  874. 				echo '</tr>';

    875. 

  875. 			$endtotal = 0;

    876. 

  876. 			$all_donations = true;

    877. 

  877. 			$all_no_shipping = true;

    878. 

  878. 			$file_link_list = array();

    879. 

  879. //			exit('<pre>'.print_r($cart_log,true).'</pre>');

    880. 

  880. 			foreach($cart_log as $cart_row) {

    881. 

  881. 			$purchlogitem->the_purch_item();

    882. 

  882. //			exit('<pre>'.print_r, true).'</pre>');

    883. 

  883. 				$alternate = "";

    884. 

  884. 				$j++;

    885. 

  885. 				if(($j % 2) != 0) {

    886. 

  886. 					$alternate = "class='alt'";

    887. 

  887.         }

    888. 

  888. 				$productsql= "SELECT * FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `id`=".$cart_row['prodid']."";

    889. 

  889. 				$product_data = $wpdb->get_results($productsql,ARRAY_A); 

    890. 

  890. 			

    891. 

  891. 			

    892. 

  892. 			

    893. 

  893. 				$variation_sql = "SELECT * FROM `".WPSC_TABLE_CART_ITEM_VARIATIONS."` WHERE `cart_id`='".$cart_row['id']."'";

    894. 

  894. 				$variation_data = $wpdb->get_results($variation_sql,ARRAY_A); 

    895. 

  895. 				$variation_count = count($variation_data);

    896. 

  896. 				

    897. 

  897. 				if($variation_count > 1) {

    898. 

  898. 					$variation_list = " (";

    899. 

  899. 					$i = 0;

    900. 

  900. 					foreach($variation_data as $variation) {

    901. 

  901. 						if($i > 0) {

    902. 

  902. 							$variation_list .= ", ";

    903. 

  903.             }

    904. 

  904. 						$value_id = $variation['value_id'];

    905. 

  905. 						$value_data = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id`='".$value_id."' LIMIT 1",ARRAY_A);

    906. 

  906. 						$variation_list .= $value_data[0]['name'];

    907. 

  907. 						$i++;

    908. 

  908.           }

    909. 

  909. 					$variation_list .= ")";

    910. 

  910.         } else if($variation_count == 1) {

    911. 

  911.           $value_id = $variation_data[0]['value_id'];

    912. 

  912.           $value_data = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id`='".$value_id."' LIMIT 1",ARRAY_A);

    913. 

  913.           $variation_list = " (".$value_data[0]['name'].")";

    914. 

  914.         } else {

    915. 

  915. 							$variation_list = '';

    916. 

  916.         }

    917. 

  917. 				

    918. 

  918. 				

    919. 

  919. 				if($cart_row['donation'] != 1) {

    920. 

  920. 					$all_donations = false;

    921. 

  921. 				}

    922. 

  922. 				if($cart_row['no_shipping'] != 1) {

    923. 

  923. 					$shipping = $cart_row['pnp'] * $cart_row['quantity'];

    924. 

  924. 					$total_shipping += $shipping;            

    925. 

  925. 					$all_no_shipping = false;

    926. 

  926. 				} else {

    927. 

  927. 					$shipping = 0;

    928. 

  928. 				}

    929. 

  929. 				

    930. 

  930. 				$price = $cart_row['price'] * $cart_row['quantity'];

    931. 

  931. 				$gst = $price - ($price  / (1+($cart_row['gst'] / 100)));

    932. 

  932. 				

    933. 

  933. 				if($gst > 0) {

    934. 

  934. 				  $tax_per_item = $gst / $cart_row['quantity'];

    935. 

  935. 				}

    936. 

  936. 

    937. 

  937. 

    938. 

  938. 				echo "<tr $alternate>";

    939. 

  939. 		

    940. 

  940. 		

    941. 

  941. 				echo " <td>";

    942. 

  942. 				echo $cart_row['quantity'];

    943. 

  943. 				echo " </td>";

    944. 

  944. 				

    945. 

  945. 				echo " <td>";

    946. 

  946. 				echo $product_data[0]['name'];

    947. 

  947. 				echo stripslashes($variation_list);

    948. 

  948. 				echo " </td>";

    949. 

  949. 				

    950. 

  950. 				

    951. 

  951. 				echo " <td>";

    952. 

  952. 				echo nzshpcrt_currency_display( $price, 1);

    953. 

  953. 				echo " </td>";

    954. 

  954. 				

    955. 

  955. 				echo " <td>";

    956. 

  956. 				echo nzshpcrt_currency_display($shipping, 1);

    957. 

  957. 				echo " </td>";

    958. 

  958. 							

    959. 

  959. 	

    960. 

  960. 

    961. 

  961. 				echo '<td>';

    962. 

  962. 				if(wpsc_tax_isincluded()){

    963. 

  963. 					echo (wpsc_purchaselog_details_tax());

    964. 

  964. 				}else{

    965. 

  965. 					echo nzshpcrt_currency_display($cart_row['tax_charged'],1);

    966. 

  966. 				}

    967. 

  967. 				echo '<td>';

    968. 

  968. 				echo '</tr>';

    969. 

  969. 			}

    970. 

  970. 			echo "</table>";

    971. 

  971. 			

    972. 

  972. 			echo '<table class="packing-slip-totals">';

    973. 

  973. 			echo '<tr><th>Base Shipping</th><td>' . nzshpcrt_currency_display( $purch_data['base_shipping'], 1 ) . '</td></tr>';

    974. 

  974. 			echo '<tr><th>Total Shipping</th><td>' . nzshpcrt_currency_display( $purch_data['base_shipping'] + $total_shipping, 1 ) . '</td></tr>';

    975. 

  975. 			echo '<tr><th>Total Price</th><td>' . nzshpcrt_currency_display( $purch_data['totalprice'], 1 ) . '</td></tr>';

    976. 

  976. 			echo '</table>';

    977. 

  977. 

    978. 

  978. 			echo "</div>\n\r";

    979. 

  979. 		} else {

    980. 

  980. 			echo "<br />".__('This users cart was empty', 'wpsc');

    981. 

  981. 		}

    982. 

  982. 

    983. 

  983. }

    984. 

  984. 

    985. 

  985. 

    986. 

  986.     

    987. 

  987. 

    988. 

  988. 

    989. 

  989. function wpsc_product_item_row() {

    990. 

  990. }

    991. 

  991. 

    992. 

  992. ?>

    993. 

  993.