} else { if ($_GET['filter'] == 'paid') { $paidlog = true; } $max_number = 3; } $date_list = array_slice($date_list, 0, $max_number); } ?> <div class="wrap" style=''> <h2><?php echo TXT_WPSC_PURCHASELOG; ?> </h2><br /> <?php echo wpsc_right_now(); ?> <table style='width: 100%;'> <tr> <td id='product_log_data'> <?php if ($purchase_log == null && !is_numeric($_GET['purchaseid'])) { if ($earliest_record[0]['date'] != null) { $form_sql = "SELECT * FROM `" . $wpdb->prefix . "collect_data_forms` WHERE `active` = '1' AND `display_log` = '1';"; $form_data = $wpdb->get_results($form_sql, ARRAY_A); $col_count = 5 + count($form_data); $i = 0; echo "<table class='logdisplay'>"; //exit("<pre>".print_r($date_list,true)."</pre>"); foreach ($date_list as $date_pair) {
function wpsc_display_sales_log_index() { global $purchlogs; ?> <div class="wrap"> <?php //screen_icon(); ?> <h2><?php echo wp_specialchars(TXT_WPSC_PURCHASELOG); ?> </h2> <?php //START OF PURCHASE LOG DEFAULT VIEW ?> <?php if (isset($_GET['view_purchlogs_by']) || isset($_GET['view_purchlogs_by_status'])) { wpsc_change_purchlog_view($_GET['view_purchlogs_by'], $_GET['view_purchlogs_by_status']); } if (!isset($_REQUEST['purchaselog_id'])) { $columns = array('cb' => '<input type="checkbox" />', 'date' => 'Date', 'name' => '', 'amount' => 'Amount', 'details' => 'Details', 'status' => 'Status', 'delete' => 'Delete', 'track' => 'Track'); register_column_headers('display-sales-list', $columns); ///// start of update message section ////// //$fixpage = get_option('siteurl').'/wp-admin/admin.php?page='.WPSC_FOLDER.'/wpsc-admin/purchlogs_upgrade.php'; $fixpage = get_option('siteurl') . '/wp-admin/admin.php?page=wpsc-sales-logs&subpage=upgrade-purchase-logs'; if (isset($_GET['skipped']) || isset($_GET['updated']) || isset($_GET['deleted']) || isset($_GET['locked'])) { ?> <div id="message" class="updated fade"><p> <?php if (isset($_GET['updated']) && (int) $_GET['updated']) { printf(__ngettext('%s Purchase Log updated.', '%s Purchase Logs updated.', $_GET['updated']), number_format_i18n($_GET['updated'])); unset($_GET['updated']); } if (isset($_GET['skipped']) && (int) $_GET['skipped']) { unset($_GET['skipped']); } if (isset($_GET['locked']) && (int) $_GET['locked']) { printf(__ngettext('%s product not updated, somebody is editing it.', '%s products not updated, somebody is editing them.', $_GET['locked']), number_format_i18n($_GET['locked'])); unset($_GET['locked']); } if (isset($_GET['deleted']) && (int) $_GET['deleted']) { printf(__ngettext('%s Purchase Log deleted.', '%s Purchase Logs deleted.', $_GET['deleted']), number_format_i18n($_GET['deleted'])); unset($_GET['deleted']); } //$_SERVER['REQUEST_URI'] = remove_query_arg( array('locked', 'skipped', 'updated', 'deleted','wpsc_downloadcsv','rss_key','start_timestamp','end_timestamp','email_buyer_id'), $_SERVER['REQUEST_URI'] ); ?> </p></div> <?php } if (get_option('wpsc_purchaselogs_fixed') == false || wpsc_check_uniquenames()) { ?> <div class='error' style='padding:8px;line-spacing:8px;'><span ><?php _e('When upgrading the Wp-E-Commerce Plugin from 3.6.* to 3.7 it is required that you associate your checkout form fields with the new Purchase Logs system. To do so please '); ?> <a href='<?php echo $fixpage; ?> '>Click Here</a></span></div> <?php } ///// end of update message section ////// ?> <div id='dashboard-widgets' style='min-width: 825px;'> <!-- <div class='inner-sidebar'> <div class='meta-box-sortables'> <?php //if(IS_WP27){ // display_ecomm_rss_feed(); //} ?> </div> </div> --> <?php /* end of sidebar start of main column */ ?> <div id='post-body' class='has-sidebar metabox-holder' style='width:95%;'> <div id='dashboard-widgets-main-content-wpsc' class='has-sidebar-content'> <?php if (function_exists('wpsc_right_now')) { echo wpsc_right_now(); } ?> </div><br /> <div id='wpsc_purchlog_searchbox'> <?php wpsc_purchaselogs_searchbox(); ?> </div><br /> <?php wpsc_purchaselogs_displaylist(); ?> </div> </div> <?php } else { //NOT IN GENERIC PURCHASE LOG PAGE, IN DETAILS PAGE PER PURCHASE LOG if (isset($_GET['cleared']) || isset($_GET['cleared'])) { ?> <div id="message" class="updated fade"><p> <?php if (isset($_GET['cleared']) && $_GET['cleared'] == true) { printf(__ngettext('Downloads for this log have been released.', 'Downloads for this log have been released.', $_GET['cleared']), $_GET['cleared']); unset($_GET['cleared']); } if (isset($_GET['sent']) && (int) $_GET['sent']) { printf(__ngettext('Receipt has been resent ', 'Receipt has been resent ', $_GET['sent']), $_GET['sent']); unset($_GET['sent']); } ?> </p></div> <?php } //$_SERVER['REQUEST_URI'] = remove_query_arg( array('locked', 'skipped', 'updated', 'deleted','cleared'), $_SERVER['REQUEST_URI'] ); ?> <?php $page_back = remove_query_arg(array('locked', 'skipped', 'updated', 'deleted', 'purchaselog_id'), $_SERVER['REQUEST_URI']); $columns = array('title' => 'Name', 'sku' => 'SKU', 'quantity' => 'Quantity', 'price' => 'Price', 'tax' => 'Tax', 'total' => 'Total'); register_column_headers('display-purchaselog-details', $columns); ?> <div id='post-body' class='has-sidebar' style='width:95%;'> <?php if (wpsc_has_purchlog_shipping()) { ?> <div id='wpsc_shipping_details_box'> <h3><?php _e('Shipping Details'); ?> </h3> <p><strong><?php echo wpsc_display_purchlog_shipping_name(); ?> </strong></p> <p> <?php echo wpsc_display_purchlog_shipping_address(); ?> <br /> <?php echo wpsc_display_purchlog_shipping_city(); ?> <br /> <?php echo wpsc_display_purchlog_shipping_state_and_postcode(); ?> <br /> <?php echo wpsc_display_purchlog_shipping_country(); ?> <br /> </p> <strong><?php _e('Shipping Options'); ?> </strong> <p> <?php _e('Shipping Method:'); ?> <?php echo wpsc_display_purchlog_shipping_method(); ?> <br /> <?php _e('Shipping Option:'); ?> <?php echo wpsc_display_purchlog_shipping_option(); ?> <br /> <?php if (wpsc_purchlogs_has_tracking()) { ?> <?php _e('Tracking ID:'); ?> <?php echo wpsc_purchlogitem_trackid(); ?> <br /> <?php _e('Shipping Status:'); ?> <?php echo wpsc_purchlogitem_trackstatus(); ?> <br /> <?php _e('Track History:'); ?> <?php echo wpsc_purchlogitem_trackhistory(); ?> <?php } ?> </p> </div> <?php } ?> <div id='wpsc_billing_details_box'> <h3><?php _e('Billing Details'); ?> </h3> <p><strong><?php _e('Purchase Log Date:'); ?> </strong><?php echo wpsc_purchaselog_details_date(); ?> </p> <p><strong><?php _e('Purchase Number:'); ?> </strong><?php echo wpsc_purchaselog_details_purchnumber(); ?> </p> <p><strong><?php _e('Buyers Name:'); ?> </strong><?php echo wpsc_display_purchlog_buyers_name(); ?> </p> <p><strong><?php _e('Address:'); ?> </strong><?php echo wpsc_display_purchlog_buyers_address(); ?> </p> <p><strong><?php _e('Phone:'); ?> </strong><?php echo wpsc_display_purchlog_buyers_phone(); ?> </p> <p><strong><?php _e('Email:'); ?> </strong><a href="mailto:<?php echo wpsc_display_purchlog_buyers_email(); ?> ?subject=Message From '<?php echo get_option('siteurl'); ?> '"><?php echo wpsc_display_purchlog_buyers_email(); ?> </a></p> <p><strong><?php _e('Payment Method:'); ?> </strong><?php echo wpsc_display_purchlog_paymentmethod(); ?> </p> <?php if (wpsc_display_purchlog_display_howtheyfoundus()) { ?> <p><strong><?php _e('How User Found Us:'); ?> </strong><?php echo wpsc_display_purchlog_howtheyfoundus(); ?> </p> <?php } ?> </div> <div id='wpsc_items_ordered'> <br /> <h3><?php _e('Items Ordered'); ?> </h3> <table class="widefat" cellspacing="0"> <thead> <tr> <?php print_column_headers('display-purchaselog-details'); ?> </tr> </thead> <tfoot> <tr> <?php php; ?> </tr> </tfoot> <tbody> <?php wpsc_display_purchlog_details(); ?> <tr> </tr> <tr> <td colspan="4"> <?php if (wpsc_purchlog_has_discount_data()) { ?> <?php _e('Coupon Code'); ?> : <?php echo wpsc_display_purchlog_discount_data(); ?> <?php } ?> </td> <th><?php _e('Discount'); ?> </th> <td><?php echo wpsc_display_purchlog_discount(); ?> </td> </tr> <tr> <td colspan='4'></td> <th><?php _e('Shipping'); ?> </th> <td><?php echo wpsc_display_purchlog_shipping(); ?> </td> </tr> <tr> <td colspan='4'></td> <th><?php _e('Total'); ?> </th> <td><?php echo wpsc_display_purchlog_totalprice(); ?> </td> </tr> </tbody> </table> <div id='wpsc_purchlog_order_status'> <form action='' method='post'> <p><label for='<?php echo $_GET['purchaselog_id']; ?> '><?php _e('Order Status:'); ?> </label><select class='selector' name='<?php echo $_GET['purchaselog_id']; ?> ' title='<?php echo $_GET['purchaselog_id']; ?> ' > <?php while (wpsc_have_purch_items_statuses()) { wpsc_the_purch_status(); ?> <option value='<?php echo wpsc_the_purch_status_id(); ?> ' <?php echo wpsc_purchlog_is_checked_status(); ?> ><?php echo wpsc_the_purch_status_name(); ?> </option> <?php } ?> </select></p> </form> </div> <?php wpsc_purchlogs_custom_fields(); ?> <!-- Start Order Notes (by Ben) --> <?php wpsc_purchlogs_notes(); ?> <!-- End Order Notes (by Ben) --> <?php wpsc_custom_checkout_fields(); ?> </div> </div> <div id='wpsc_purchlogitems_links'> <h3><?php _e('Actions'); ?> </h3> <?php if (wpsc_purchlogs_have_downloads_locked() != false) { ?> <img src='<?php echo WPSC_URL; ?> /images/lock_open.png' alt='clear lock icon' /> <a href='<?php echo $_SERVER['REQUEST_URI'] . '&wpsc_admin_action=clear_locks'; ?> '><?php echo wpsc_purchlogs_have_downloads_locked(); ?> </a><br /><br class='small' /> <?php } ?> <img src='<?php echo WPSC_URL; ?> /images/printer.png' alt='printer icon' /> <a href='<?php echo add_query_arg('wpsc_admin_action', 'wpsc_display_invoice'); ?> '><?php echo TXT_WPSC_VIEW_PACKING_SLIP; ?> </a> <br /><br class='small' /><img src='<?php echo WPSC_URL; ?> /images/email_go.png' alt='email icon' /> <a href='<?php echo add_query_arg('email_buyer_id', $_GET['purchaselog_id']); ?> '><?php echo TXT_WPSC_EMAIL_BUYER; ?> </a> <br /><br class='small' /><a class='submitdelete' title='<?php echo attribute_escape(__('Delete this log')); ?> ' href='<?php echo wp_nonce_url("page.php?wpsc_admin_action=delete_purchlog&purchlog_id=" . $_GET['purchaselog_id'], 'delete_purchlog_' . $_GET['purchaselog_id']); ?> ' onclick="if ( confirm(' <?php echo js_escape(sprintf(__("You are about to delete this log '%s'\n 'Cancel' to stop, 'OK' to delete."), wpsc_purchaselog_details_date())); ?> ') ) { return true;}return false;"><img src='<?php echo WPSC_URL . "/images/cross.png"; ?> ' alt='delete icon' /> <?php echo TXT_WPSC_REMOVE_LOG; ?> </a> <br /><br class='small' />   <a href='<?php echo $page_back; ?> '><?php echo TXT_WPSC_GOBACK; ?> </a> <br /><br /> </div> </div> <br /> <?php } ?> </div> <?php }