PageRenderTime 28ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

/wp-content/plugins/wp-e-commerce/display-coupons.php

https://gitlab.com/endomorphosis/reservationtelco
PHP | 580 lines | 502 code | 55 blank | 23 comment | 69 complexity | db2f691c016ad43688b28081eb81edbf MD5 | raw file
    

  1. <?php
    2. 

  2. function wpsc_display_coupons_page(){
    3. 

  3. global $wpdb;
    4. 

  4. if(isset($_POST) && is_array($_POST) && !empty($_POST)) {
    5. 

  5. 

  6. 	if(isset($_POST['add_coupon']) && ($_POST['add_coupon'] == 'true')&& (!($_POST['is_edit_coupon'] == 'true'))) {
    7. 

  7. 		$coupon_code = $_POST['add_coupon_code'];
    8. 

  8. 		$discount = (double)$_POST['add_discount'];
    9. 

  9. 		// cast to boolean, then integer, prevents the value from being anything but 1 or 0
    10. 

  10. 		$discount_type = (int)$_POST['add_discount_type'];
    11. 

  11. 		$use_once = (int)(bool)$_POST['add_use-once'];
    12. 

  12. 		$every_product = (int)(bool)$_POST['add_every_product'];
    13. 

  13. // 		$start_date = date("Y-m-d H:i:s", mktime(0, 0, 0, (int)$_POST['add_start']['month'], (int)$_POST['add_start']['day'], (int)$_POST['add_start']['year']));
    14. 

  14. // 		$end_date = date("Y-m-d H:i:s", mktime(0, 0, 0, (int)$_POST['add_end']['month'], (int)$_POST['add_end']['day'], (int)$_POST['add_end']['year']));
    15. 

  15. 		$start_date = date('Y-m-d', strtotime($_POST['add_start'])) . " 00:00:00";
    16. 

  16. 		$end_date = date('Y-m-d', strtotime($_POST['add_end'])) . " 00:00:00";
    17. 

  17. 		$rules = $_POST['rules'];
    18. 

  18. 		foreach ($rules as $key => $rule) {
    19. 

  19. 			foreach ($rule as $k => $r) {
    20. 

  20. 				$new_rule[$k][$key] = $r;
    21. 

  21. 			}
    22. 

  22. 		}
    23. 

  23. 		foreach($new_rule as $key => $rule) {
    24. 

  24. 			if ($rule['value'] == '') {
    25. 

  25. 				unset($new_rule[$key]);
    26. 

  26. 			}
    27. 

  27. 		}
    28. 

  28. 		if($wpdb->query("INSERT INTO `".WPSC_TABLE_COUPON_CODES."` ( `coupon_code` , `value` , `is-percentage` , `use-once` , `is-used` , `active` , `every_product` , `start` , `expiry`, `condition` ) VALUES ( '$coupon_code', '$discount', '$discount_type', '$use_once', '0', '1', '$every_product', '$start_date' , '$end_date' , '".serialize($new_rule)."' );")) {  
    29. 

  29. 			echo "<div class='updated'><p align='center'>".__('Thanks, the coupon has been added.', 'wpsc')."</p></div>";
    30. 

  30. 		}
    31. 

  31. 	}
    32. 

  32. 	if(isset($_POST['is_edit_coupon']) && ($_POST['is_edit_coupon'] == 'true') && !(isset($_POST['delete_condition'])) && !(isset($_POST['submit_condition']))) {
    33. 

  33. 			//exit('<pre>'.print_r($_POST, true).'</pre>');
    34. 

  34. 		foreach((array)$_POST['edit_coupon'] as $coupon_id => $coupon_data) {
    35. 

  35. 			//echo('<pre>'.print_r($coupon_data,true)."</pre>");
    36. 

  36. 			$coupon_id = (int)$coupon_id;
    37. 

  37. 			// convert dates to a form that compares well and can be inserted into the database
    38. 

  38. // 			$coupon_data['start'] = date("Y-m-d H:i:s", mktime(0, 0, 0, (int)$coupon_data['start']['month'], (int)$coupon_data['start']['day'], (int)$coupon_data['start']['year']));
    39. 

  39. // 			$coupon_data['expiry'] = date("Y-m-d H:i:s", mktime(0, 0, 0, (int)$coupon_data['expiry']['month'], (int)$coupon_data['expiry']['day'], (int)$coupon_data['expiry']['year']));
    40. 

  40. 			$coupon_data['start'] = $coupon_data['start']." 00:00:00";
    41. 

  41. 			$coupon_data['expiry'] = $coupon_data['expiry']." 00:00:00";
    42. 

  42. 			$check_values = $wpdb->get_row("SELECT `id`, `coupon_code`, `value`, `is-percentage`, `use-once`, `active`, `start`, `expiry` FROM `".WPSC_TABLE_COUPON_CODES."` WHERE `id` = '$coupon_id'", ARRAY_A);
    43. 

  43. 			//sort both arrays to make sure that if they contain the same stuff, that they will compare to be the same, may not need to do this, but what the heck
    44. 

  44. 		//	exit('<pre>'.print_r($coupon_data, true).'</pre>');
    45. 

  45. 			ksort($check_values); ksort($coupon_data);
    46. 

  46. 			
    47. 

  47. 			if($check_values != $coupon_data) {
    48. 

  48. 				$insert_array = array();
    49. 

  49. 				foreach($coupon_data as $coupon_key => $coupon_value) {
    50. 

  50. 				  if(($coupon_key == "submit_coupon") || ($coupon_key == "delete_coupon")) {
    51. 

  51. 				    continue;
    52. 

  52. 				  }
    53. 

  53. 					if($coupon_value != $check_values[$coupon_key]) {
    54. 

  54. 						$insert_array[] = "`$coupon_key` = '$coupon_value'";
    55. 

  55. 					}
    56. 

  56. 				}
    57. 

  57. 				//if(in_array(mixed needle, array haystack [, bool strict]))	
    58. 

  58. 				//exit("<pre>".print_r($conditions,true)."</pre>");
    59. 

  59. 				if(count($insert_array) > 0) {
    60. 

  60. 					$wpdb->query("UPDATE `".WPSC_TABLE_COUPON_CODES."` SET ".implode(", ", $insert_array)." WHERE `id` = '$coupon_id' LIMIT 1;");
    61. 

  61. 				}
    62. 

  62. 				unset($insert_array);
    63. 

  63. 				$rules = $_POST['rules'];
    64. 

  64. 				
    65. 

  65. 				foreach ((array)$rules as $key => $rule) {
    66. 

  66. 					foreach ($rule as $k => $r) {
    67. 

  67. 						$new_rule[$k][$key] = $r;
    68. 

  68. 					}
    69. 

  69. 				}
    70. 

  70. 				foreach((array)$new_rule as $key => $rule) {
    71. 

  71. 					if ($rule['value'] == '') {
    72. 

  72. 						unset($new_rule[$key]);
    73. 

  73. 					}
    74. 

  74. 				}
    75. 

  75. 

  76. 				/*
    77. 

  77. $sql ="UPDATE `".WPSC_TABLE_COUPON_CODES."` SET `condition`='".serialize($new_rule)."' WHERE `id` = '$coupon_id' LIMIT 1";
    78. 

  78. 				$wpdb->query($sql);
    79. 

  79. 				
    80. 

  80. */
    81. 

  81. 			$conditions = $wpdb->get_var("SELECT `condition` FROM `".WPSC_TABLE_COUPON_CODES."` WHERE `id` = '".(int)$_POST['coupon_id']."' LIMIT 1");
    82. 

  82. 				  $conditions=unserialize($conditions);
    83. 

  83. 				  $new_cond=array();
    84. 

  84. 				  if($_POST['rules']['value'][0] != ''){
    85. 

  85. 					  $new_cond['property']=$_POST['rules']['property'][0];
    86. 

  86. 					  $new_cond['logic']=$_POST['rules']['logic'][0];
    87. 

  87. 					  $new_cond['value']=$_POST['rules']['value'][0];
    88. 

  88. 					  $conditions []= $new_cond;
    89. 

  89. 				  }
    90. 

  90. 				  $sql ="UPDATE `".WPSC_TABLE_COUPON_CODES."` SET `condition`='".serialize($conditions)."' WHERE `id` = '".(int)$_POST['coupon_id']."' LIMIT 1";
    91. 

  91. 				  $wpdb->query($sql);
    92. 

  92. 

  93. 			}
    94. 

  94. 				
    95. 

  95. 			if($coupon_data['delete_coupon'] != '') {
    96. 

  96. 				$wpdb->query("DELETE FROM `".WPSC_TABLE_COUPON_CODES."` WHERE `id` = '$coupon_id' LIMIT 1;");
    97. 

  97. 			}
    98. 

  98. 		}
    99. 

  99. 	}
    100. 

  100.   if(isset($_POST['delete_condition'])){
    101. 

  101. 

  102. 	  $conditions = $wpdb->get_var("SELECT `condition` FROM `".WPSC_TABLE_COUPON_CODES."` WHERE `id` = '".(int)$_POST['coupon_id']."' LIMIT 1");
    103. 

  103. 	  $conditions=unserialize($conditions);
    104. 

  104. 	    
    105. 

  105. 	  unset($conditions[(int)$_POST['delete_condition']]);
    106. 

  106. 	  	
    107. 

  107. 	  //$conditions = array_values($conditions);
    108. 

  108. 	 //  exit('<pre>'.print_r($_POST, true).'</pre><pre>'.print_r($conditions, true).'</pre>'.$sql);
    109. 

  109. 	  $sql ="UPDATE `".WPSC_TABLE_COUPON_CODES."` SET `condition`='".serialize($conditions)."' WHERE `id` = '".(int)$_POST['coupon_id']."' LIMIT 1";
    110. 

  110. 	
    111. 

  111. 	  $wpdb->query($sql);
    112. 

  112.   }
    113. 

  113.   if(isset($_POST['submit_condition'])){
    114. 

  114. 	$conditions = $wpdb->get_var("SELECT `condition` FROM `".WPSC_TABLE_COUPON_CODES."` WHERE `id` = '".(int)$_POST['coupon_id']."' LIMIT 1");
    115. 

  115. 	  $conditions=unserialize($conditions);
    116. 

  116. 	  $new_cond=array();
    117. 

  117. 	  $new_cond['property']=$_POST['rules']['property'][0];
    118. 

  118. 	  $new_cond['logic']=$_POST['rules']['logic'][0];
    119. 

  119. 	  $new_cond['value']=$_POST['rules']['value'][0];
    120. 

  120. 	  $conditions []= $new_cond;
    121. 

  121. 	  $sql ="UPDATE `".WPSC_TABLE_COUPON_CODES."` SET `condition`='".serialize($conditions)."' WHERE `id` = '".(int)$_POST['coupon_id']."' LIMIT 1";
    122. 

  122. 	  $wpdb->query($sql);
    123. 

  123.   }
    124. 

  124.   if($_POST['change-settings'] == 'true') {
    125. 

  125.     if($_POST['wpsc_also_bought'] == 1) {
    126. 

  126.       update_option('wpsc_also_bought', 1);
    127. 

  127. 		} else {
    128. 

  128.       update_option('wpsc_also_bought', 0);
    129. 

  129. 		}
    130. 

  130. 	
    131. 

  131.     if($_POST['display_find_us'] == 'on') {
    132. 

  132.       update_option('display_find_us', 1);
    133. 

  133. 		} else {
    134. 

  134.       update_option('display_find_us', 0);
    135. 

  135. 		}
    136. 

  136.       
    137. 

  137.     if($_POST['wpsc_share_this'] == 1) {
    138. 

  138.       update_option('wpsc_share_this', 1);
    139. 

  139. 		} else {
    140. 

  140.       update_option('wpsc_share_this', 0);
    141. 

  141. 		}
    142. 

  142. 	}
    143. 

  143. }
    144. 

  144. 

  145. /*<strong><?php echo TXT_WPSC_ADD_COUPON; ?></strong>*/
    146. 

  146. ?>
    147. 

  147. <script type='text/javascript'>
    148. 

  148. 	jQuery(".pickdate").datepicker();
    149. 

  149. 		/* jQuery datepicker selector */
    150. 

  150. 	if (typeof jQuery('.pickdate').datepicker != "undefined") {
    151. 

  151. 		jQuery('.pickdate').datepicker({ dateFormat: 'yy-mm-dd' });
    152. 

  152. 	}
    153. 

  153. </script>
    154. 

  154. <div class="wrap">
    155. 

  155.   <h2><?php echo __('Coupons', 'wpsc');?></h2>
    156. 

  156.   <div style='margin:0px;' class="tablenav wpsc_admin_nav">
    157. 

  157.   <!-- <a target="_blank" href="http://www.instinct.co.nz/e-commerce/marketing/" class="about_this_page"><span>About This Page</span> </a> -->
    158. 

  158. 

  159.  	<form action='' method='post'>
    160. 

  160. 		<input id='add_coupon_box_link' type='submit' class=' add_item_link button' name='add_coupon_button' value='<?php echo __('Create Coupon', 'wpsc');?>' onclick='return show_status_box("add_coupon_box","add_coupon_box_link");return false;' />
    161. 

  161. 	</form>
    162. 

  162. </div>
    163. 

  163. <!-- <form name='edit_coupon' method='post' action=''>   -->
    164. 

  164. <table style="width: 100%;">
    165. 

  165.   <tr>
    166. 

  166.     <td id="coupon_data">
    167. 

  167.     
    168. 

  168. 

  169. <div id='add_coupon_box' class='modify_coupon' >
    170. 

  170. <form name='add_coupon' method='post' action=''>
    171. 

  171. <table class='add-coupon' >
    172. 

  172.  <tr>
    173. 

  173.    <th>
    174. 

  174.    <?php echo __('Coupon Code', 'wpsc'); ?>
    175. 

  175.    </th>
    176. 

  176.    <th>
    177. 

  177.    <?php echo __('Discount', 'wpsc'); ?>
    178. 

  178.    </th>
    179. 

  179.    <th>
    180. 

  180.    <?php echo __('Start', 'wpsc'); ?>
    181. 

  181.    </th>
    182. 

  182.    <th>
    183. 

  183.    <?php echo __('Expiry', 'wpsc'); ?>
    184. 

  184.    </th>
    185. 

  185.    <th>
    186. 

  186.    <?php echo __('Use Once', 'wpsc'); ?>
    187. 

  187.    </th>
    188. 

  188.    <th>
    189. 

  189.    <?php echo __('Active', 'wpsc'); ?>
    190. 

  190.    </th>
    191. 

  191.   <!--
    192. 

  192.  <th>
    193. 

  193.    <?php echo __('Apply On All Products', 'wpsc'); ?>
    194. 

  194.    </th>
    195. 

  195. -->
    196. 

  196.  </tr>
    197. 

  197.  <tr>
    198. 

  198.    <td>
    199. 

  199.    <input type='text' value='' name='add_coupon_code' />
    200. 

  200.    </td>
    201. 

  201.    <td>
    202. 

  202.    <input type='text' value='' size='3' name='add_discount' />
    203. 

  203.    <select name='add_discount_type'>
    204. 

  204.      <option value='0' >$</option>
    205. 

  205.      <option value='1' >%</option>
    206. 

  206.      <option value='2' >Free shipping</option>
    207. 

  207.    </select>
    208. 

  208.    </td>
    209. 

  209.    <td>
    210. 

  210.    <input type='text' class='pickdate' size='11' name='add_start' />
    211. 

  211.    <!--<select name='add_start[day]'>
    212. 

  212.    <?php
    213. 

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

  214.      $selected = '';
    215. 

  215.      if($i == date("d")) { $selected = "selected='selected'"; }
    216. 

  216.      echo "<option $selected value='$i'>$i</option>";
    217. 

  217.      }
    218. 

  218.    ?>
    219. 

  219.    </select>
    220. 

  220.    <select name='add_start[month]'>
    221. 

  221.    <?php
    222. 

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

  223.      $selected = '';
    224. 

  224.      if($i == (int)date("m")) { $selected = "selected='selected'"; }
    225. 

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

  226.      }
    227. 

  227.    ?>
    228. 

  228.    </select>
    229. 

  229.    <select name='add_start[year]'>
    230. 

  230.    <?php
    231. 

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

  232.      $selected = '';
    233. 

  233.      if($i == date("Y")) { $selected = "selected='true'"; }
    234. 

  234.      echo "<option $selected value='$i'>".$i."</option>";
    235. 

  235.      }
    236. 

  236.    ?>
    237. 

  237.    </select>-->
    238. 

  238.    </td>
    239. 

  239.    <td>
    240. 

  240.    <input type='text' class='pickdate' size='11' name='add_end'>
    241. 

  241.    <!--<select name='add_end[day]'>
    242. 

  242.    <?php
    243. 

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

  244.      $selected = '';
    245. 

  245.      if($i == date("d")) { $selected = "selected='true'"; }
    246. 

  246.      echo "<option $selected value='$i'>$i</option>";
    247. 

  247.      }
    248. 

  248.    ?>
    249. 

  249.    </select>
    250. 

  250.    <select name='add_end[month]'>
    251. 

  251.    <?php
    252. 

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

  253.      $selected = '';
    254. 

  254.      if($i == (int)date("m")) { $selected = "selected='true'"; }
    255. 

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

  256.      }
    257. 

  257.    ?>
    258. 

  258.    </select>
    259. 

  259.    <select name='add_end[year]'>
    260. 

  260.    <?php
    261. 

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

  262.      $selected = '';
    263. 

  263.      if($i == (date("Y")+1)) { $selected = "selected='true'"; }
    264. 

  264.      echo "<option $selected value='$i'>".$i."</option>";
    265. 

  265.      }
    266. 

  266.    ?>
    267. 

  267.    </select>-->
    268. 

  268.    </td>
    269. 

  269.    <td>
    270. 

  270.    <input type='hidden' value='0' name='add_use-once' />
    271. 

  271.    <input type='checkbox' value='1' name='add_use-once' />
    272. 

  272.    </td>
    273. 

  273.    <td>
    274. 

  274.    <input type='hidden' value='0' name='add_active' />
    275. 

  275.    <input type='checkbox' value='1' checked='checked' name='add_active' />
    276. 

  276.    </td>
    277. 

  277. 

  278.    <td>
    279. 

  279.    
    280. 

  280.    <input type='hidden' value='true' name='add_coupon' />
    281. 

  281.    <input type='submit' value='Add Coupon' name='submit_coupon' class='button-primary' />
    282. 

  282.    </td>
    283. 

  283.  </tr>
    284. 

  284.  <tr><td colspan="2">
    285. 

  285. 		   <input type='hidden' value='0' name='add_every_product' />
    286. 

  286. 			<input type="checkbox" value="1" name='add_every_product'/>
    287. 

  287. 		<?php _e('Apply On All Products', 'wpsc')?></td></tr>
    288. 

  288. 

  289. <tr><td colspan='3'><span id='table_header'>Conditions</span></td></tr>
    290. 

  290. <tr><td colspan="8">
    291. 

  291. 	<div class='coupon_condition' >
    292. 

  292. 		<div class='first_condition'>
    293. 

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

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

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

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

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

  298. 				<?php echo apply_filters( 'wpsc_coupon_rule_property_options', '' ); ?>
    299. 

  299. 			</select>
    300. 

  300. 			<select name="rules[logic][]">
    301. 

  301. 				<option value="equal">Is equal to</option>
    302. 

  302. 				<option value="greater">Is greater than</option>
    303. 

  303. 				<option value="less">Is less than</option>
    304. 

  304. 				<option value="contains">Contains</option>
    305. 

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

  306. 				<option value="begins">Begins with</option>
    307. 

  307. 				<option value="ends">Ends with</option>
    308. 

  308. 			</select>
    309. 

  309. 			<span>
    310. 

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

  311. 			</span>
    312. 

  312. 			<span>
    313. 

  313.             	<script>
    314. 

  314. 				var coupon_number=1;
    315. 

  315. 				function add_another_property(this_button){
    316. 

  316. 					var new_property='<div class="coupon_condition">\n'+
    317. 

  317. 						'<div><img height="16" width="16" class="delete" alt="Delete" src="<?php echo WPSC_URL; ?>/images/cross.png" onclick="jQuery(this).parent().remove();"/> \n'+
    318. 

  318. 							'<select class="ruleprops" name="rules[property][]"> \n'+
    319. 

  319. 								'<option value="item_name" rel="order">Item name</option> \n'+
    320. 

  320. 								'<option value="item_quantity" rel="order">Item quantity</option>\n'+
    321. 

  321. 								'<option value="total_quantity" rel="order">Total quantity</option>\n'+ 
    322. 

  322. 								'<option value="subtotal_amount" rel="order">Subtotal amount</option>\n'+ 
    323. 

  323. 								'<?php echo apply_filters( 'wpsc_coupon_rule_property_options', '' ); ?>'+
    324. 

  324. 							'</select> \n'+
    325. 

  325. 							'<select name="rules[logic][]"> \n'+
    326. 

  326. 								'<option value="equal">Is equal to</option> \n'+
    327. 

  327. 								'<option value="greater">Is greater than</option> \n'+
    328. 

  328. 								'<option value="less">Is less than</option> \n'+
    329. 

  329. 								'<option value="contains">Contains</option> \n'+
    330. 

  330. 								'<option value="not_contain">Does not contain</option> \n'+
    331. 

  331. 								'<option value="begins">Begins with</option> \n'+
    332. 

  332. 								'<option value="ends">Ends with</option> \n'+
    333. 

  333. 							'</select> \n'+
    334. 

  334. 							'<span> \n'+
    335. 

  335. 								'<input type="text" name="rules[value][]"/> \n'+
    336. 

  336. 							'</span>  \n'+
    337. 

  337. 						'</div> \n'+
    338. 

  338. 					'</div> ';
    339. 

  339. 		
    340. 

  340. 					jQuery('.coupon_condition :first').after(new_property);
    341. 

  341. 					coupon_number++;
    342. 

  342. 				}
    343. 

  343. 				</script>
    344. 

  344. 			
    345. 

  345. 			</span>
    346. 

  346. 			
    347. 

  347. 		</div>
    348. 

  348. 	</div>
    349. 

  349. </tr>
    350. 

  350. <tr><td>	<a class="wpsc_coupons_condition_add" onclick="add_another_property(jQuery(this));">
    351. 

  351. 					<?php _e('Add New Condition','wpsc'); ?>
    352. 

  352. 				</a></td></tr>
    353. 

  353. </table>
    354. 

  354. <br />
    355. 

  355. </form>  
    356. 

  356. </div>    
    357. 

  357. 

  358.   <?php
    359. 

  359.   $num = 0;
    360. 

  360. 

  361. echo "<table class='coupon-list'>\n\r";
    362. 

  362. echo "  <tr class='toprow'>\n\r";
    363. 

  363. 

  364. echo "    <th>\n\r";
    365. 

  365. echo __('Coupon Code', 'wpsc');
    366. 

  366. echo "    </th>\n\r";
    367. 

  367. 

  368. echo "    <th>\n\r";
    369. 

  369. echo __('Discount', 'wpsc');
    370. 

  370. echo "    </th>\n\r";
    371. 

  371. 

  372. echo "    <th>\n\r";
    373. 

  373. echo __('Start', 'wpsc');
    374. 

  374. echo "    </th>\n\r";
    375. 

  375. 

  376. echo "    <th>\n\r";
    377. 

  377. echo __('Expiry', 'wpsc');
    378. 

  378. echo "    </th>\n\r";
    379. 

  379. 

  380. echo "    <th>\n\r";
    381. 

  381. echo __('Active', 'wpsc');
    382. 

  382. echo "    </th>\n\r";
    383. 

  383. 

  384. echo "    <th>\n\r";
    385. 

  385. echo __('Apply On All Products', 'wpsc');
    386. 

  386. echo "    </th>\n\r";
    387. 

  387. 

  388. echo "    <th>\n\r";
    389. 

  389. echo __('Edit', 'wpsc');
    390. 

  390. echo "    </th>\n\r";
    391. 

  391. 

  392. $i=0;
    393. 

  393. $coupon_data = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_COUPON_CODES."` ",ARRAY_A);
    394. 

  394. //exit('Coupon Data<pre>'.print_r($coupon_data, true).'</pre>');
    395. 

  395. foreach((array)$coupon_data as $coupon) {
    396. 

  396.   $alternate = "";
    397. 

  397.   $i++;
    398. 

  398.   if(($i % 2) != 0) {
    399. 

  399.     $alternate = "class='alt'";
    400. 

  400.     }
    401. 

  401.   echo "<tr $alternate>\n\r";
    402. 

  402.   
    403. 

  403.   echo "    <td>\n\r";
    404. 

  404.   echo $coupon['coupon_code'];
    405. 

  405.   echo "    </td>\n\r";
    406. 

  406.   
    407. 

  407.   echo "    <td>\n\r";
    408. 

  408.   if($coupon['is-percentage'] == 1){
    409. 

  409.     echo $coupon['value']."%";
    410. 

  410.     } else {    
    411. 

  411.     echo nzshpcrt_currency_display($coupon['value'], 1);
    412. 

  412.     }
    413. 

  413.   echo "    </td>\n\r";
    414. 

  414.   
    415. 

  415.   echo "    <td>\n\r";
    416. 

  416.   echo date("d/m/Y",strtotime($coupon['start']));
    417. 

  417.   echo "    </td>\n\r";
    418. 

  418.   
    419. 

  419.   echo "    <td>\n\r";
    420. 

  420.   echo date("d/m/Y",strtotime($coupon['expiry']));
    421. 

  421.   echo "    </td>\n\r";
    422. 

  422.   
    423. 

  423.   echo "    <td>\n\r";  
    424. 

  424.   switch($coupon['active']) {
    425. 

  425.     case 1:
    426. 

  426.     echo "<img src='".WPSC_URL."/images/yes_stock.gif' alt='' title='' />";
    427. 

  427.     break;
    428. 

  428.     
    429. 

  429.     case 0: default:
    430. 

  430.     echo "<img src='".WPSC_URL."/images/no_stock.gif' alt='' title='' />";
    431. 

  431.     break;
    432. 

  432.     }
    433. 

  433.   echo "    </td>\n\r";
    434. 

  434.   
    435. 

  435.    echo "    <td>\n\r";
    436. 

  436.   switch($coupon['every_product']) {
    437. 

  437. 	  case 1:
    438. 

  438. 		  echo "<img src='".WPSC_URL."/images/yes_stock.gif' alt='' title='' />";
    439. 

  439. 		  break;
    440. 

  440.     
    441. 

  441. 	  case 0: default:
    442. 

  442. 		  echo "<img src='".WPSC_URL."/images/no_stock.gif' alt='' title='' />";
    443. 

  443. 		  break;
    444. 

  444.   }
    445. 

  445.   echo "    </td>\n\r";
    446. 

  446. 

  447.   
    448. 

  448.   
    449. 

  449.   echo "    <td>\n\r";
    450. 

  450.   echo "<a title='".$coupon['coupon_code']."' href='javascript:void(0)' class='wpsc_edit_coupon'  >".__('Edit', 'wpsc')."</a>";
    451. 

  451.   echo "    </td>\n\r";
    452. 

  452.   
    453. 

  453.   echo "  </tr>\n\r";
    454. 

  454.   echo "  <tr>\n\r";
    455. 

  455.   echo "    <td colspan='7' style='padding-left:0px;'>\n\r";
    456. 

  456. //  $status_style = "style='display: block;'";
    457. 

  457.   echo "      <div id='coupon_box_".$coupon['id']."' class='modify_coupon' >\n\r";  
    458. 

  458.   coupon_edit_form($coupon);
    459. 

  459.   echo "      </div>\n\r";
    460. 

  460.   echo "    </td>\n\r";
    461. 

  461.   echo "  </tr>\n\r";
    462. 

  462.   }
    463. 

  463. echo "</table>\n\r";
    464. 

  464.   ?>
    465. 

  465.   <p style='margin: 0px 0px 5px 0px;'>
    466. 

  466.   	 <?php  _e('<strong>Note:</strong> Due to a current limitation of PayPal, if your user makes a purchase and uses a coupon, we can not send a list of items through to paypal for processing. Rather, we must send the total amount of the purchase, so that within PayPal the user who purchases a product will see your shop name and the total amount of their purchase.', 'wpsc');?>
    467. 

  467.   </p>
    468. 

  468.     </td>
    469. 

  469.   </tr>
    470. 

  470. </table>
    471. 

  471. <!-- <input type='hidden' value='true' name='is_edit_coupon' /> -->
    472. 

  472. <!-- </form> -->
    473. 

  473. 

  474. <br />
    475. 

  475. 

  476. 

  477.       
    478. 

  478. <h2><?php echo __('Marketing Settings', 'wpsc');?></h2>
    479. 

  479. 

  480. <form name='cart_options' method='POST' action=''>
    481. 

  481. <input type='hidden' value='true' name='change-settings' />
    482. 

  482.   <table>
    483. 

  483.     <tr>
    484. 

  484.       <td>
    485. 

  485.         <?php echo __('Display Cross Sales', 'wpsc');?>:
    486. 

  486.       </td>
    487. 

  487.       <td>
    488. 

  488.         <?php
    489. 

  489.         $wpsc_also_bought = get_option('wpsc_also_bought');
    490. 

  490.         $wpsc_also_bought1 = "";
    491. 

  491.         $wpsc_also_bought2 = "";
    492. 

  492.         switch($wpsc_also_bought) {
    493. 

  493.         case 0:
    494. 

  494.         $wpsc_also_bought2 = "checked ='true'";
    495. 

  495.         break;
    496. 

  496.         
    497. 

  497.         case 1:
    498. 

  498.         $wpsc_also_bought1 = "checked ='true'";
    499. 

  499.         break;
    500. 

  500.         }
    501. 

  501.         ?>
    502. 

  502.         <input type='radio' value='1' name='wpsc_also_bought' id='wpsc_also_bought1' <?php echo $wpsc_also_bought1; ?> /> <label for='wpsc_also_bought1'><?php echo __('Yes', 'wpsc');?></label> &nbsp;
    503. 

  503.         <input type='radio' value='0' name='wpsc_also_bought' id='wpsc_also_bought2' <?php echo $wpsc_also_bought2; ?> /> <label for='wpsc_also_bought2'><?php echo __('No', 'wpsc');?></label>
    504. 

  504.       </td>
    505. 

  505.     </tr>
    506. 

  506.     
    507. 

  507.     <tr>
    508. 

  508.       <td>
    509. 

  509.       <?php echo __('Show Share This (Social Bookmarks)', 'wpsc');?>:
    510. 

  510.       </td>
    511. 

  511.       <td>
    512. 

  512.         <?php
    513. 

  513.         $wpsc_share_this = get_option('wpsc_share_this');
    514. 

  514.         $wpsc_share_this1 = "";
    515. 

  515.         $wpsc_share_this2 = "";
    516. 

  516.         switch($wpsc_share_this) {
    517. 

  517.           case 0:
    518. 

  518.           $wpsc_share_this2 = "checked ='true'";
    519. 

  519.           break;
    520. 

  520.           
    521. 

  521.           case 1:
    522. 

  522.           $wpsc_share_this1 = "checked ='true'";
    523. 

  523.           break;
    524. 

  524.           }
    525. 

  525.         ?>
    526. 

  526.         <input type='radio' value='1' name='wpsc_share_this' id='wpsc_share_this1' <?php echo $wpsc_share_this1; ?> /> <label for='wpsc_share_this1'><?php echo __('Yes', 'wpsc');?></label> &nbsp;
    527. 

  527.         <input type='radio' value='0' name='wpsc_share_this' id='wpsc_share_this2' <?php echo $wpsc_share_this2; ?> /> <label for='wpsc_share_this2'><?php echo __('No', 'wpsc');?></label>
    528. 

  528.       </td>
    529. 

  529.     </tr>
    530. 

  530. 	<tr>
    531. 

  531.         <td>
    532. 

  532. 		<?php echo __('Display How Customer Found Us Survey', 'wpsc')?>
    533. 

  533.         </td>
    534. 

  534. 	<?php
    535. 

  535. 		$display_find_us = get_option('display_find_us');
    536. 

  536. 		if ($display_find_us=='1') {
    537. 

  537. 			$display_find_us1 = "checked ='checked'";
    538. 

  538. 		}
    539. 

  539. 	?>
    540. 

  540.         <td>
    541. 

  541. 		<input <?php echo $display_find_us1; ?> type='checkbox' name='display_find_us'>
    542. 

  542.         </td>
    543. 

  543.       </tr>
    544. 

  544.       <tr>
    545. 

  545.         <td>
    546. 

  546. 	
    547. 

  547.         </td>
    548. 

  548.         <td>
    549. 

  549.         <input  type='submit' value='<?php echo __('Submit', 'wpsc');?>' name='form_submit' />
    550. 

  550.         </td>
    551. 

  551.       </tr>
    552. 

  552.   </table>
    553. 

  553. </form>
    554. 

  554. 

  555. <h2><?php echo __('RSS Address', 'wpsc');?></h2>
    556. 

  556. <table>
    557. 

  557. 	<tr>
    558. 

  558. 		<td colspan='2'>
    559. 

  559. 			<?php echo __('<strong>Note:</strong> Not only can people use this RSS to keep update with your product list but you can also use this link to promote your products in your facebook profile. <br />Just add the <a href="http://apps.facebook.com/getshopped">getshopped! facebook application</a> to your facebook profile and follow the instructions.', 'wpsc');?>
    560. 

  560. 		</td>
    561. 

  561. 	</tr>
    562. 

  562. 	<tr><td>&nbsp;</td></tr>
    563. 

  563. 	<tr>
    564. 

  564. 		<td>
    565. 

  565. 			RSS Feed Address:
    566. 

  566. 		</td>
    567. 

  567. 		<td>
    568. 

  568. 			<?php echo get_bloginfo('url')."/index.php?rss=true&amp;action=product_list"; ?>
    569. 

  569. 		</td>
    570. 

  570. 	</tr>
    571. 

  571. </table>
    572. 

  572. 

  573. <h2><?php echo __('Google Merchant Centre / Google Product Search', 'wpsc'); ?></h2>
    574. 

  574. <p>To import your products into <a href="http://www.google.com/merchants/" target="_blank">Google Merchant Centre</a> so that they appear within Google Product Search results, sign up for a Google Merchant Centre account and add a scheduled data feed with the following URL:</p>
    575. 

  575. <?php $google_feed_url = get_bloginfo('url')."/index.php?rss=true&action=product_list&xmlformat=google"; ?>
    576. 

  576. <a href="<?php echo htmlentities($google_feed_url); ?>"><?php echo htmlentities($google_feed_url); ?></a>
    577. 

  577. </div>
    578. 

  578. <?php
    579. 

  579. }
    580. 

  580. ?>
    581. 

  581.