PageRenderTime 69ms CodeModel.GetById 32ms RepoModel.GetById 1ms app.codeStats 0ms

/wp-content/plugins/wp-shopping-cart/display-log.php

https://github.com/alx/barceloneta
PHP | 762 lines | 629 code | 108 blank | 25 comment | 112 complexity | f6a14b5aff9d3daf97d3fa87a0dc3d73 MD5 | raw file
  1. <?php
  2. /*
  3. * this updates the processing status of an item
  4. */
  5. if(is_numeric($_GET['id']) && is_numeric($_GET['value'])) {
  6. $max_stage = $wpdb->get_var("SELECT MAX(*) AS `max` FROM `".$wpdb->prefix."purchase_statuses` WHERE `active`='1'");
  7. if(is_numeric($_GET['value']) && ($_GET['value'] <= $max_stage)) {
  8. $newvalue = $_GET['value'];
  9. } else {
  10. $newvalue = 1;
  11. }
  12. $log_data = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `id` = '".$_GET['id']."' LIMIT 1");
  13. $update_sql = "UPDATE `".$wpdb->prefix."purchase_logs` SET `processed` = '".$newvalue."' WHERE `id` = '".$_GET['id']."' LIMIT 1";
  14. $wpdb->query($update_sql);
  15. if(($newvalue > $log_data['processed']) && ($log_data['processed'] <=1)) {
  16. transaction_results($log_data['sessionid'], false);
  17. }
  18. }
  19. if(is_numeric($_GET['deleteid'])) {
  20. $delete_id = $_GET['deleteid'];
  21. $delete_log_form_sql = "SELECT * FROM `".$wpdb->prefix."cart_contents` WHERE `purchaseid`='$delete_id'";
  22. $cart_content = $wpdb->get_results($delete_log_form_sql,ARRAY_A);
  23. foreach((array)$cart_content as $cart_item) {
  24. $cart_item_variations = $wpdb->query("DELETE FROM `".$wpdb->prefix."cart_item_variations` WHERE `cart_id` = '".$cart_item['id']."'", ARRAY_A);
  25. }
  26. $wpdb->query("DELETE FROM `".$wpdb->prefix."cart_contents` WHERE `purchaseid`='$delete_id'");
  27. $wpdb->query("DELETE FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id` IN ('$delete_id')");
  28. $wpdb->query("DELETE FROM `".$wpdb->prefix."purchase_logs` WHERE `id`='$delete_id' LIMIT 1");
  29. echo '<div id="message" class="updated fade"><p>'.TXT_WPSC_THANKS_DELETED.'</p></div>';
  30. }
  31. if(isset($_GET['clear_locks']) && ($_GET['clear_locks'] == 'true') && is_numeric($_GET['purchaseid'])) {
  32. $purchase_id = (int)$_GET['purchaseid'];
  33. $downloadable_items = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."download_status` WHERE `purchid` IN ('$purchase_id')", ARRAY_A);
  34. $clear_locks_sql = "UPDATE`".$wpdb->prefix."download_status` SET `ip_number` = '' WHERE `purchid` IN ('$purchase_id')";
  35. $wpdb->query($clear_locks_sql);
  36. $email_form_field = $wpdb->get_var("SELECT `id` FROM `".$wpdb->prefix."collect_data_forms` WHERE `type` IN ('email') AND `active` = '1' ORDER BY `order` ASC LIMIT 1");
  37. $email_address = $wpdb->get_var("SELECT `value` FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id`='{$purchase_id}' AND `form_id` = '{$email_form_field}' LIMIT 1");
  38. foreach($downloadable_items as $downloadable_item) {
  39. $download_links .= $siteurl."?downloadid=".$downloadable_item['uniqueid']. "\n";
  40. }
  41. mail($email_address, TXT_WPSC_USER_UNLOCKED_EMAIL, str_replace("[download_links]", $download_links, TXT_WPSC_USER_UNLOCKED_EMAIL_MESSAGE), "From: ".get_option('return_email')."");
  42. echo '<div id="message" class="updated fade"><p>'.TXT_WPSC_THANKS_UNLOCKED.'</p></div>';
  43. }
  44. //echo("<pre>".print_r($cart_item,true)."</pre>");
  45. /*
  46. * this finds the earliest time in the shopping cart and sorts out the timestamp system for the month by month display
  47. */
  48. $earliest_record_sql = "SELECT MIN(`date`) AS `date` FROM `".$wpdb->prefix."purchase_logs` WHERE `date`!=''";
  49. $earliest_record = $wpdb->get_results($earliest_record_sql,ARRAY_A) ;
  50. $current_timestamp = time();
  51. $earliest_timestamp = $earliest_record[0]['date'];
  52. $current_year = date("Y");
  53. $earliest_year = date("Y",$earliest_timestamp);
  54. $j = 0;
  55. for($year = $current_year; $year >= $earliest_year; $year--) {
  56. for($month = 12; $month >= 1; $month--) {
  57. $start_timestamp = mktime(0, 0, 0, $month, 1, $year);
  58. $end_timestamp = mktime(0, 0, 0, ($month+1), 1, $year);
  59. if(($end_timestamp >= $earliest_timestamp) && ($start_timestamp <= $current_timestamp)) {
  60. $date_list[$j]['start'] = $start_timestamp;
  61. $date_list[$j]['end'] = $end_timestamp;
  62. $j++;
  63. }
  64. }
  65. }
  66. if($_GET['filter'] !== 'true') {
  67. if(is_numeric($_GET['filter'])) {
  68. $max_number = $_GET['filter'];
  69. } else {
  70. if ($_GET['filter']=='paid') {
  71. $paidlog=true;
  72. }
  73. $max_number = 3;
  74. }
  75. $date_list = array_slice($date_list, 0, $max_number);
  76. }
  77. ?>
  78. <div class="wrap" style=''>
  79. <h2><?php echo TXT_WPSC_PURCHASELOG;?></h2><br />
  80. <?php
  81. echo wpsc_right_now();
  82. ?>
  83. <table style='width: 100%;'>
  84. <tr>
  85. <td id='product_log_data'>
  86. <?php
  87. if(($purchase_log == null) && !is_numeric($_GET['purchaseid'])) {
  88. if($earliest_record[0]['date'] != null) {
  89. $form_sql = "SELECT * FROM `".$wpdb->prefix."collect_data_forms` WHERE `active` = '1' AND `display_log` = '1';";
  90. $form_data = $wpdb->get_results($form_sql,ARRAY_A);
  91. $col_count = 5 + count($form_data);
  92. $i = 0;
  93. echo "<table class='logdisplay'>";
  94. //exit("<pre>".print_r($date_list,true)."</pre>");
  95. foreach($date_list as $date_pair){
  96. if(($date_pair['end'] >= $earliest_timestamp) && ($date_pair['start'] <= $current_timestamp)) {
  97. $sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `date` BETWEEN '".$date_pair['start']."' AND '".$date_pair['end']."' ORDER BY `date` DESC";
  98. if ($paidlog) {
  99. $sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `date` BETWEEN '".$date_pair['start']."' AND '".$date_pair['end']."' AND `processed` >= '2' ORDER BY `date` DESC";
  100. } else if($_GET['filteremail']) {
  101. $sql = "SELECT DISTINCT `{$wpdb->prefix}purchase_logs` . * FROM `{$wpdb->prefix}submited_form_data` LEFT JOIN `{$wpdb->prefix}purchase_logs` ON `{$wpdb->prefix}submited_form_data`.`log_id` = `{$wpdb->prefix}purchase_logs`.`id` WHERE `{$wpdb->prefix}submited_form_data`.`value` IN ( '".$wpdb->escape($_GET['filteremail'])."' ) AND `{$wpdb->prefix}purchase_logs`.`date` BETWEEN '".$date_pair['start']."' AND '".$date_pair['end']."' ORDER BY `{$wpdb->prefix}purchase_logs`.`date` DESC;";
  102. }
  103. $purchase_log = $wpdb->get_results($sql,ARRAY_A) ;
  104. $i = 0;
  105. $subtotal = 0;
  106. echo "<tr>";
  107. echo " <td colspan='$col_count'>";
  108. echo "<h3 class='log_headers'>".date("M Y", $date_pair['start']) ."</h3>";
  109. echo " </td>";
  110. echo "</tr>";
  111. if($purchase_log != null)
  112. {
  113. echo "<tr class='toprow'>";
  114. // echo " <td>";
  115. // echo TXT_WPSC_PURCHASE_NUMBER;
  116. // echo " </td>";
  117. echo " <td style='text-align: left;'>";
  118. echo TXT_WPSC_STATUS;
  119. echo " </td>";
  120. echo " <td>";
  121. echo TXT_WPSC_DATE;
  122. echo " </td>";
  123. foreach($form_data as $form_field)
  124. {
  125. echo " <td>";
  126. echo $form_field['name'];
  127. echo " </td>";
  128. }
  129. echo " <td>";
  130. echo TXT_WPSC_PRICE;
  131. echo " </td>";
  132. if(get_option('payment_method') == 2)
  133. {
  134. echo " <td>";
  135. echo TXT_WPSC_PAYMENT_METHOD;
  136. echo " </td>";
  137. }
  138. echo " <td>";
  139. echo TXT_WPSC_VIEWDETAILS;
  140. echo " </td>";
  141. //echo "<td width='1%'>";
  142. //echo TXT_WPSC_STORENAME;
  143. //echo "<td>";
  144. echo "</tr>";
  145. foreach($purchase_log as $purchase)
  146. {
  147. $status_state = "expand";
  148. $status_style = "";
  149. $alternate = "";
  150. $i++;
  151. if(($i % 2) != 0)
  152. {
  153. $alternate = "class='alt'";
  154. }
  155. echo "<tr $alternate>\n\r";
  156. // echo " <td>";
  157. // echo $purchase['id'];
  158. // echo " </td>";
  159. echo " <td class='processed'>";
  160. if($purchase['processed'] < 1)
  161. {
  162. $purchase['processed'] = 1;
  163. }
  164. $stage_sql = "SELECT * FROM `".$wpdb->prefix."purchase_statuses` WHERE `id`='".$purchase['processed']."' AND `active`='1' LIMIT 1";
  165. $stage_data = $wpdb->get_row($stage_sql,ARRAY_A);
  166. echo "<a href='#' onclick='return show_status_box(\"status_box_".$purchase['id']."\",\"log_expander_icon_".$purchase['id']."\");'>";
  167. if($_GET['id'] == $purchase['id'])
  168. {
  169. $status_state = "collapse";
  170. $status_style = "style='display: block;'";
  171. }
  172. echo "<img class='log_expander_icon' id='log_expander_icon_".$purchase['id']."' src='".WPSC_URL."/images/icon_window_$status_state.gif' alt='' title='' />";
  173. if($stage_data['colour'] != '')
  174. {
  175. $colour = "style='color: #".$stage_data['colour'].";'";
  176. }
  177. echo "<span $colour id='form_group_".$purchase['id']."_text'>".$stage_data['name']."</span>";
  178. echo "</a>";
  179. echo " </td>\n\r";
  180. echo " <td>";
  181. echo date("jS M Y",$purchase['date']);
  182. echo " </td>\n\r";
  183. foreach($form_data as $form_field) {
  184. $collected_data_sql = "SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id` = '".$purchase['id']."' AND `form_id` = '".$form_field['id']."' LIMIT 1";
  185. $collected_data = $wpdb->get_results($collected_data_sql,ARRAY_A);
  186. $collected_data = $collected_data[0];
  187. switch($form_field['type']) {
  188. case 'country':
  189. echo " <td>";
  190. echo get_country($purchase['billing_country']);
  191. echo " </td>\n\r";
  192. break;
  193. case 'delivery_country':
  194. echo " <td>";
  195. echo get_country($purchase['shipping_country']);
  196. echo " </td>\n\r";
  197. break;
  198. default:
  199. echo " <td>";
  200. echo $collected_data['value'];
  201. echo " </td>\n\r";
  202. break;
  203. }
  204. }
  205. echo " <td>";
  206. if($purchase['shipping_country'] != '') {
  207. $billing_country = $purchase['billing_country'];
  208. $shipping_country = $purchase['shipping_country'];
  209. } else {
  210. $country_sql = "SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id` = '".$purchase['id']."' AND `form_id` = '".get_option('country_form_field')."' LIMIT 1";
  211. $country_data = $wpdb->get_results($country_sql,ARRAY_A);
  212. $billing_country = $country_data[0]['value'];
  213. $shipping_country = $country_data[0]['value'];
  214. }
  215. //echo $country;
  216. echo nzshpcrt_currency_display(nzshpcrt_find_total_price($purchase['id'],$shipping_country),1);
  217. $subtotal += nzshpcrt_find_total_price($purchase['id'],$shipping_country);
  218. echo " </td>\n\r";
  219. if(get_option('payment_method') == 2) {
  220. echo " <td>";
  221. $gateway_name = '';
  222. foreach($GLOBALS['nzshpcrt_gateways'] as $gateway) {
  223. if($purchase['gateway'] != 'testmode') {
  224. if($gateway['internalname'] == $purchase['gateway'] ) {
  225. $gateway_name = $gateway['name'];
  226. }
  227. } else {
  228. $gateway_name = "Manual Payment";
  229. }
  230. }
  231. echo $gateway_name;
  232. echo " </td>\n\r";
  233. }
  234. echo " <td>";
  235. echo "<a href='admin.php?page=".WPSC_DIR_NAME."/display-log.php&amp;purchaseid=".$purchase['id']."'>".TXT_WPSC_VIEWDETAILS."</a>";
  236. echo " </td>\n\r";
  237. //echo " <td>";
  238. //echo $purchase['closest_store'];
  239. //echo " </td>\n\r";
  240. echo "</tr>\n\r";
  241. $stage_list_sql = "SELECT * FROM `".$wpdb->prefix."purchase_statuses` ORDER BY `id` ASC";
  242. $stage_list_data = $wpdb->get_results($stage_list_sql,ARRAY_A);
  243. echo "<tr>\n\r";
  244. echo " <td colspan='$col_count'>\n\r";
  245. echo " <div id='status_box_".$purchase['id']."' class='order_status' $status_style>\n\r";
  246. echo " <div>\n\r";
  247. echo " <strong class='form_group'>".TXT_WPSC_ORDER_STATUS."</strong>\n\r";
  248. echo " <form onsubmit='log_submitform(this);return false;' id='form_group_".$purchase['id']."' method='GET' action='admin.php?page=".WPSC_DIR_NAME."/display-log.php'>\n\r";
  249. echo " <input type='hidden' name='page' value='".$_GET['page']."' />\n\r";
  250. if(isset($_GET['filter']))
  251. {
  252. echo " <input type='hidden' name='filter' value='".$_GET['filter']."' />\n\r";
  253. }
  254. echo " <input type='hidden' name='id' value='".$purchase['id']."' />\n\r";
  255. //echo " <input type='hidden' name='id' value='".$purchase['id']."' />\n\r";
  256. echo " <ul>\n\r";
  257. foreach($stage_list_data as $stage)
  258. {
  259. $selected = '';
  260. if($stage['id'] == $purchase['processed'])
  261. {
  262. $selected = "checked='true'";
  263. }
  264. $button_id = "button_".$purchase['id']."_".$stage['id'];
  265. echo " <li><input type='radio' name='value' $selected value='".$stage['id']."' onclick='log_submitform(\"form_group_".$purchase['id']."\");' id='".$button_id."'/><label for='$button_id'>".$stage['name']."</label>\n\r";
  266. }
  267. echo " </ul>\n\r";
  268. //echo " <input type='submit' name='log_state_submit' value='Save... &raquo;' class='button' /> \n\r";
  269. echo " </form>\n\r";
  270. echo "<li style='display:none;' id='track_id'>Tracking ID: <form method='GET'><input type='text' siez='20' id='tracking_id_".$purchase['id']."' name='track_id' value=".$purchase['track_id']."><input type = 'button' value='Submit' onclick='save_tracking_id(".$purchase['id'].");'></form></li>";
  271. if($purchase['transactid'] != '')
  272. {
  273. echo " <span style='float:right; margin-right: 15px; '>".TXT_WPSC_TXN_ID.": ".$purchase['transactid']."</span>";
  274. }
  275. echo "<a href='admin.php?page=".WPSC_DIR_NAME."/display-log.php&amp;deleteid=".$purchase['id']."'>".TXT_WPSC_REMOVE_LOG."</a>";
  276. echo " </div>\n\r";
  277. echo " </div>\n\r";
  278. echo " </td>\n\r";
  279. echo "</tr>\n\r";
  280. }
  281. echo "<tr>";
  282. echo " <td colspan='$col_count'>";
  283. echo "<strong>Total:</strong> ".nzshpcrt_currency_display($subtotal ,1);
  284. echo "<br /><a class='admin_download' href='index.php?purchase_log_csv=true&rss_key=key&start_timestamp=".$date_pair['start']."&end_timestamp=".$date_pair['end']."' ><img align='absmiddle' src='".WPSC_URL."/images/download.gif' alt='' title='' /><span>".TXT_WPSC_DOWNLOAD_CSV."</span></a>";
  285. echo " </td>";
  286. echo "</tr>";
  287. }
  288. else
  289. {
  290. echo "<tr>";
  291. echo " <td colspan='$col_count'>";
  292. echo "No transactions for this month.";
  293. echo " </td>";
  294. echo "</tr>";
  295. }
  296. }
  297. }
  298. echo " </table>";
  299. } else {
  300. echo " <table>";
  301. echo "<tr>";
  302. echo " <td>";
  303. echo TXT_WPSC_NO_PURCHASES;
  304. echo " </td>";
  305. echo "</tr>";
  306. echo " </table>";
  307. }
  308. } else if(is_numeric($_GET['purchaseid'])) {
  309. $purch_sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `id`='".$_GET['purchaseid']."'";
  310. $purch_data = $wpdb->get_results($purch_sql,ARRAY_A) ;
  311. $cartsql = "SELECT * FROM `".$wpdb->prefix."cart_contents` WHERE `purchaseid`=".$_GET['purchaseid']."";
  312. $cart_log = $wpdb->get_results($cartsql,ARRAY_A) ;
  313. $j = 0;
  314. if($cart_log != null) {
  315. echo "<table class='logdisplay'>";
  316. echo "<tr class='toprow2'>";
  317. echo " <td>";
  318. echo TXT_WPSC_NAME;
  319. echo " </td>";
  320. echo " <td>";
  321. echo TXT_WPSC_QUANTITY;
  322. echo " </td>";
  323. echo " <td>";
  324. echo TXT_WPSC_PRICE;
  325. echo " </td>";
  326. echo " <td>";
  327. echo TXT_WPSC_TAX;
  328. echo " </td>";
  329. echo " <td>";
  330. echo TXT_WPSC_SHIPPING;
  331. echo " </td>";
  332. echo " <td>";
  333. echo TXT_WPSC_TOTAL;
  334. echo " </td>";
  335. echo "</tr>";
  336. $endtotal = 0;
  337. $all_donations = true;
  338. $all_no_shipping = true;
  339. $file_link_list = array();
  340. foreach($cart_log as $cart_row)
  341. {
  342. $alternate = "";
  343. $j++;
  344. if(($j % 2) != 0)
  345. {
  346. $alternate = "class='alt'";
  347. }
  348. $productsql= "SELECT * FROM `".$wpdb->prefix."product_list` WHERE `id`=".$cart_row['prodid']."";
  349. $product_data = $wpdb->get_results($productsql,ARRAY_A);
  350. $variation_sql = "SELECT * FROM `".$wpdb->prefix."cart_item_variations` WHERE `cart_id`='".$cart_row['id']."'";
  351. $variation_data = $wpdb->get_results($variation_sql,ARRAY_A);
  352. $variation_count = count($variation_data);
  353. if($variation_count > 1)
  354. {
  355. $variation_list = " (";
  356. $i = 0;
  357. foreach($variation_data as $variation)
  358. {
  359. if($i > 0)
  360. {
  361. $variation_list .= ", ";
  362. }
  363. $value_id = $variation['value_id'];
  364. $value_data = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."variation_values` WHERE `id`='".$value_id."' LIMIT 1",ARRAY_A);
  365. $variation_list .= $value_data[0]['name'];
  366. $i++;
  367. }
  368. $variation_list .= ")";
  369. }
  370. else if($variation_count == 1)
  371. {
  372. $value_id = $variation_data[0]['value_id'];
  373. $value_data = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."variation_values` WHERE `id`='".$value_id."' LIMIT 1",ARRAY_A);
  374. $variation_list = " (".$value_data[0]['name'].")";
  375. }
  376. else
  377. {
  378. $variation_list = '';
  379. }
  380. if($purch_data[0]['shipping_country'] != '') {
  381. $billing_country = $purch_data[0]['billing_country'];
  382. $shipping_country = $purch_data[0]['shipping_country'];
  383. } else {
  384. $country_sql = "SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id` = '".$_GET['purchaseid']."' AND `form_id` = '".get_option('country_form_field')."' LIMIT 1";
  385. $country_data = $wpdb->get_results($country_sql,ARRAY_A);
  386. $billing_country = $country_data[0]['value'];
  387. $shipping_country = $country_data[0]['value'];
  388. }
  389. if($cart_row['donation'] != 1) {
  390. $all_donations = false;
  391. }
  392. if($cart_row['no_shipping'] != 1) {
  393. $shipping = $cart_row['pnp'] * $cart_row['quantity'];
  394. $total_shipping += $shipping;
  395. $all_no_shipping = false;
  396. } else {
  397. $shipping = 0;
  398. }
  399. if($cart_row['files'] != null) {
  400. $file_data = unserialize($cart_row['files']);
  401. if(is_array($file_data)) {
  402. $file_link_list[] = "<a href='".WPSC_USER_UPLOADS_URL.$file_data['file_name']."'>{$product_data[0]['name']} </a><br />";
  403. }
  404. }
  405. echo "<tr $alternate>";
  406. echo " <td>";
  407. echo $product_data[0]['name'];
  408. echo $variation_list;
  409. echo " </td>";
  410. echo " <td>";
  411. echo $cart_row['quantity'];
  412. echo " </td>";
  413. echo " <td>";
  414. $price = $cart_row['price'] * $cart_row['quantity'];
  415. $gst = $price - ($price / (1+($cart_row['gst'] / 100)));
  416. echo nzshpcrt_currency_display($price-$gst, 1);
  417. echo " </td>";
  418. echo " <td>";
  419. echo nzshpcrt_currency_display($gst, 1);
  420. echo " </td>";
  421. echo " <td>";
  422. echo nzshpcrt_currency_display($cart_row['pnp'], 1);
  423. echo " </td>";
  424. echo " <td>";
  425. $endtotal += $price;
  426. echo nzshpcrt_currency_display(($shipping + $price), 1);
  427. echo " </td>";
  428. echo '</tr>';
  429. }
  430. echo "<tr >";
  431. echo " <td colspan='4'>";
  432. echo " </td>";
  433. echo " <td>";
  434. if($purch_data[0]['discount_value'] > 0) {
  435. echo "<strong>".TXT_WPSC_DISCOUNT.":</strong><br />";
  436. }
  437. if(($all_donations == false) && ($all_no_shipping == false)) {
  438. echo "<strong>".TXT_WPSC_BASESHIPPING.":</strong><br />";
  439. echo "<strong>".TXT_WPSC_TOTALSHIPPING.":</strong><br />";
  440. }
  441. echo "<strong>".TXT_WPSC_FINALTOTAL.":</strong>";
  442. echo " </td>";
  443. echo " <td>";
  444. if($purch_data[0]['discount_value'] > 0) {
  445. echo nzshpcrt_currency_display($purch_data[0]['discount_value'], 1)."<br />";
  446. }
  447. if(($all_donations == false) && ($all_no_shipping == false)) {
  448. echo nzshpcrt_currency_display($purch_data[0]['base_shipping'],1)."<br />";
  449. $total_shipping += $purch_data[0]['base_shipping'];
  450. $endtotal += $total_shipping;
  451. echo nzshpcrt_currency_display($total_shipping, 1) . "<br />";
  452. }
  453. $endtotal -= $purch_data[0]['discount_value'];
  454. echo nzshpcrt_currency_display($endtotal,1);
  455. echo " </td>";
  456. echo '</tr>';
  457. echo "</table>";
  458. echo "<br />";
  459. if(count($file_link_list) > 0) {
  460. echo "<p>\n\r";
  461. echo " <strong>".TXT_WPSC_DOWNLOAD_ATTACHED_FILES."</strong><br />\n\r";
  462. foreach($file_link_list as $file_link) {
  463. echo "{$file_link}\n\r";
  464. }
  465. echo "</p>\n\r";
  466. }
  467. echo "<strong>".TXT_WPSC_CUSTOMERDETAILS."</strong>";
  468. echo "<table>";
  469. $form_sql = "SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id` = '".$_GET['purchaseid']."'";
  470. $input_data = $wpdb->get_results($form_sql,ARRAY_A);
  471. //exit("<pre>".print_r($input_data,true)."</pre>");
  472. if($input_data != null) {
  473. foreach($input_data as $form_field) {
  474. $form_sql = "SELECT * FROM `".$wpdb->prefix."collect_data_forms` WHERE `active` = '1' AND `id` = '".$form_field['form_id']."' LIMIT 1";
  475. $form_data = $wpdb->get_results($form_sql,ARRAY_A);
  476. if($form_data != null) {
  477. $form_data = $form_data[0];
  478. switch($form_data['type']) {
  479. case 'country':
  480. if(is_numeric($purch_data[0]['shipping_region'])) {
  481. echo " <tr><td>".TXT_WPSC_STATE.":</td><td>".get_region($purch_data[0]['shipping_region'])."</td></tr>";
  482. }
  483. echo " <tr><td>".$form_data['name'].":</td><td>".get_country($purch_data[0]['billing_country'])."</td></tr>";
  484. break;
  485. case 'delivery_country':
  486. echo " <tr><td>".$form_data['name'].":</td><td>".get_country($purch_data[0]['shipping_country'])."</td></tr>";
  487. break;
  488. default:
  489. echo " <tr><td>".$form_data['name'].":</td><td>".$form_field['value']."</td></tr>";
  490. break;
  491. }
  492. }
  493. }
  494. } else {
  495. echo " <tr><td>".TXT_WPSC_NAME.":</td><td>".$purch_data[0]['firstname']." ".$purch_data[0]['lastname']."</td></tr>";
  496. echo " <tr><td>".TXT_WPSC_ADDRESS.":</td><td>".$purch_data[0]['address']."</td></tr>";
  497. echo " <tr><td>".TXT_WPSC_PHONE.":</td><td>".$purch_data[0]['phone']."</td></tr>";
  498. echo " <tr><td>".TXT_WPSC_EMAIL.":</td><td>".$purch_data[0]['email']."</td></tr>";
  499. }
  500. if(get_option('payment_method') == 2) {
  501. $gateway_name = '';
  502. foreach($GLOBALS['nzshpcrt_gateways'] as $gateway) {
  503. if($purch_data[0]['gateway'] != 'testmode') {
  504. if($gateway['internalname'] == $purch_data[0]['gateway'] ) {
  505. $gateway_name = $gateway['name'];
  506. }
  507. } else {
  508. $gateway_name = "Manual Payment";
  509. }
  510. }
  511. }
  512. echo " <tr><td>".TXT_WPSC_PAYMENT_METHOD.":</td><td>".$gateway_name."</td></tr>";
  513. echo " <tr><td>".TXT_WPSC_PURCHASE_NUMBER.":</td><td>".$purch_data[0]['id']."</td></tr>";
  514. echo " <tr><td>".TXT_WPSC_HOWCUSTOMERFINDUS.":</td><td>".$purch_data[0]['find_us']."</td></tr>";
  515. $engrave_line = explode(",",$purch_data[0]['engravetext']);
  516. echo " <tr><td>".TXT_WPSC_ENGRAVE."</td><td></td></tr>";
  517. echo " <tr><td>Line1:</td><td>".$engrave_line[0]."</td></tr>";
  518. echo " <tr><td>Line2:</td><td>".$engrave_line[1]."</td></tr>";
  519. if($purch_data[0]['transactid'] != '') {
  520. echo " <tr><td>".TXT_WPSC_TXN_ID.":</td><td>".$purch_data[0]['transactid']."</td></tr>";
  521. }
  522. echo "</table>";
  523. } else {
  524. echo "<br />".TXT_WPSC_USERSCARTWASEMPTY;
  525. }
  526. echo "<br /><a href='admin.php?page=".WPSC_DIR_NAME."/display-log.php&amp;purchaseid=".$_GET['purchaseid']."&amp;clear_locks=true'>".TXT_WPSC_CLEAR_IP_LOCKS."</a><br />";
  527. echo "<br /><a href='admin.php?page=".WPSC_DIR_NAME."/display-log.php&amp;deleteid=".$_GET['purchaseid']."'>".TXT_WPSC_REMOVE_LOG."</a>";
  528. echo "<br /><a href='admin.php?page=".WPSC_DIR_NAME."/display-log.php'>".TXT_WPSC_GOBACK."</a>";
  529. }
  530. $sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `date`!=''";
  531. $purchase_log = $wpdb->get_results($sql,ARRAY_A) ;
  532. ?>
  533. </td>
  534. <td id='order_summary_container'>
  535. <?php
  536. require_once (ABSPATH . WPINC . '/rss.php');
  537. $rss = fetch_rss('http://www.instinct.co.nz/feed/');
  538. if($rss != null) {
  539. $rss->items = array_slice((array)$rss->items, 0, 5);
  540. $current_hash = sha1(serialize($rss->items));
  541. if((string)get_option('wpsc_ecom_news_hash') !== (string)$current_hash ) {
  542. ?>
  543. <div class='wpsc_news'>
  544. <strong><?php echo TXT_WPSC_ECOM_NEWS; ?></strong>
  545. <ul class='ecom_dashboard'>
  546. <?php
  547. foreach($rss->items as $items) {
  548. echo "<li><a href='".$items['link']."'>".$items['title']."</a></li>";
  549. }
  550. ?>
  551. </ul>
  552. <a href='admin.php?page=<?php echo WPSC_DIR_NAME;?>/display-log.php&#038;hide_news=true' id='close_news_box'>X</a>
  553. </div>
  554. <?php
  555. }
  556. }
  557. ?>
  558. <div class='menu'>
  559. <div class='order_summary_subsection'>
  560. <strong><?php echo TXT_WPSC_MENU; ?></strong>
  561. <p>
  562. <a href="?page=<?php echo WPSC_DIR_NAME;?>/options.php">Shop Settings</a><br>
  563. <a href="?page=<?php echo WPSC_DIR_NAME;?>/gatewayoptions.php">Gateway Settings</a><br>
  564. <a href="?page=<?php echo WPSC_DIR_NAME;?>/form_fields.php">Checkout Settings</a><br>
  565. <a href="?page=<?php echo WPSC_DIR_NAME;?>/instructions.php">Help</a>
  566. </p>
  567. </div>
  568. </div>
  569. <br>
  570. <strong class='order_summary'><?php echo TXT_WPSC_ORDER_SUMMARY; ?></strong>
  571. <div class='order_summary'>
  572. <div class='order_summary_subsection'>
  573. <strong><?php echo TXT_WPSC_FILTER_ORDER; ?></strong>
  574. <p class='order_filters'>
  575. <form class='order_filters' method='GET' action='' name='order_filters'>
  576. <input type='hidden' name='page' value='<?php echo $_GET['page']?>' />
  577. <?php
  578. switch($_GET['filter'])
  579. {
  580. case "true":
  581. $filter[1] = "checked='true'";
  582. break;
  583. case 3:
  584. default:
  585. $filter[0] = "checked='true'";
  586. break;
  587. case 1:
  588. default:
  589. $filter[2] = "checked='true'";
  590. break;
  591. }
  592. ?>
  593. <input class='order_filters' onclick='document.order_filters.submit();' type='radio' <?php echo $filter[0];?> name='filter' value='1' id='order_filter_1' /> <label class='order_filters' for='order_filter_1'><?php echo TXT_WPSC_LOG_CURRENT_MONTH; ?></label>
  594. <br />
  595. <input class='order_filters' onclick='document.order_filters.submit();' type='radio' <?php echo $filter[0];?> name='filter' value='3' id='order_filter_3' /> <label class='order_filters' for='order_filter_3'><?php echo TXT_WPSC_LOG_PAST_THREE_MONTHS; ?></label>
  596. <br />
  597. <input class='order_filters' onclick='document.order_filters.submit();' type='radio' <?php echo $filter[1];?> name='filter' value='paid' id='order_filter_paid' /> <label class='order_filters' for='order_filter_paid'><?php echo TXT_WPSC_LOG_TRANSACTIONACCEPTEDLOGS; ?></label>
  598. <br />
  599. <input class='order_filters' onclick='document.order_filters.submit();' type='radio' <?php echo $filter[1];?> name='filter' value='true' id='order_filter_none' /> <label class='order_filters' for='order_filter_none'><?php echo TXT_WPSC_LOG_ALL; ?></label>
  600. <br>
  601. <?=TXT_WPSC_SEARCHEMAIL?>: <input type='text' name='filteremail' >
  602. </form>
  603. <br />
  604. </p>
  605. <strong><?php echo TXT_WPSC_TOTAL_THIS_MONTH; ?></strong>
  606. <p id='log_total_month'>
  607. <?php
  608. $year = date("Y");
  609. $month = date("m");
  610. $start_timestamp = mktime(0, 0, 0, $month, 1, $year);
  611. $end_timestamp = mktime(0, 0, 0, ($month+1), 0, $year);
  612. echo nzshpcrt_currency_display(admin_display_total_price($start_timestamp, $end_timestamp),1);
  613. echo " ".TXT_WPSC_ACCEPTED_PAYMENTS;
  614. ?>
  615. </p>
  616. </div>
  617. <div class='order_summary_subsection'>
  618. <strong><?php echo TXT_WPSC_TOTAL_INCOME; ?></strong>
  619. <p id='log_total_absolute'>
  620. <?php
  621. //$total_income = $wpdb->get_results($sql,ARRAY_A);
  622. echo nzshpcrt_currency_display(admin_display_total_price(),1);
  623. ?>
  624. </p>
  625. </div>
  626. <div class='order_summary_subsection'>
  627. <strong><?php echo TXT_WPSC_RSS_FEED_HEADER; ?></strong>
  628. <p>
  629. <a class='product_log_rss' href='index.php?rss=true&amp;rss_key=key&amp;action=purchase_log'><img align='absmiddle' src='<?php echo WPSC_URL; ?>/images/rss-icon.jpg' alt='' title='' />&nbsp;<span><?php echo TXT_WPSC_RSS_FEED_LINK; ?></span></a> <?php echo TXT_WPSC_RSS_FEED_TEXT; ?> </p>
  630. </div>
  631. <div class='order_summary_subsection'>
  632. <strong><?php echo TXT_WPSC_PLUGIN_NEWS_HEADER; ?></strong>
  633. <p>
  634. <?php echo TXT_WPSC_PLUGIN_NEWS; ?>
  635. <br /><br /><?php echo TXT_WPSC_POWERED_BY; ?><a href='http://www.instinct.co.nz'>Instinct</a>
  636. </p>
  637. </div>
  638. </div>
  639. <?php
  640. if(get_option('activation_state') != "true")
  641. {
  642. ?>
  643. <div class='gold-cart_pesterer'>
  644. <div>
  645. <img src='<?php echo WPSC_URL; ?>/images/gold-cart.png' alt='' title='' /><a href='http://www.instinct.co.nz/blogshop/'>Upgrade to Gold</a> and unleash more functionality into your shop.
  646. </div>
  647. </div>
  648. <?php
  649. }
  650. ?>
  651. </td>
  652. </tr>
  653. </table>
  654. </div>