WPSC_Purchase_Log_Page::download_csv() - Code Metrics - Inspection of "Modify Order, Issues #2163, #194" - wp-e-commerce/WP-e-Commerce - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#2165)

by Justin

created 2016-11-07 15:21 UTC

WPSC_Purchase_Log_Page::download_csv() A

↳ Parent: WPSC_Purchase_Log_Page

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	2
nc	1
nop	0
dl	0
loc	3
rs	10
c	0
b	0
f	0

<?php
/**
 * WP eCommerce edit and view sales page functions
 *
 * These are the main WPSC sales page functions
 *
 * @package wp-e-commerce
 * @since 3.8.8
 */

class WPSC_Purchase_Log_Page {
	private $list_table;
	private $output;
	public $log_id = 0;

	/**
	 * WPSC_Purchase_Log
	 *
	 * @var WPSC_Purchase_Log object.
	 */
	public $log = null;

	/**
	 * Whether the purchase log can be modified.
	 *
	 * @var boolean
	 */
	protected $can_edit = false;

	public function __construct() {
		$controller = 'default';
		$controller_method = 'controller_default';

		// If individual purchase log, setup ID and action links.
		if ( isset( $_REQUEST['id'] ) && is_numeric( $_REQUEST['id'] ) ) {
			$this->log_id = (int) $_REQUEST['id'];
			$this->log = new WPSC_Purchase_Log( $this->log_id );
			$this->can_edit = $this->log->can_edit();
		}

		if ( isset( $_REQUEST['c'] ) && method_exists( $this, 'controller_' . $_REQUEST['c'] ) ) {
			$controller = $_REQUEST['c'];
			$controller_method = 'controller_' . $controller;
		} elseif ( isset( $_REQUEST['id'] ) && is_numeric( $_REQUEST['id'] ) ) {
			$controller = 'item_details';
			$controller_method = 'controller_item_details';
		}

		// Can only edit in the item details view.
		if ( 'controller_item_details' !== $controller_method ) {
			$this->can_edit = false;
		}

		$this->$controller_method();
	}

	private function needs_update() {
		global $wpdb;

		if ( get_option( '_wpsc_purchlogs_3.8_updated' ) )
			return false;

		$c = $wpdb->get_var( "SELECT COUNT(*) FROM " . WPSC_TABLE_PURCHASE_LOGS . " WHERE plugin_version IN ('3.6', '3.7')" );
		if ( $c > 0 )
			return true;

		update_option( '_wpsc_purchlogs_3.8_updated', true );
		return false;
	}

	public function controller_upgrade_purchase_logs_3_7() {
		add_action( 'wpsc_display_purchase_logs_page', array( $this, 'display_upgrade_purchase_logs_3_7' ) );
	}

	private function purchase_logs_fix_options( $id ) {
		?>
		<select name='<?php echo $id; ?>'>
			<option value='-1'><?php echo esc_html_x( 'Select an Option', 'Dropdown default when called in uniquename dropdown', 'wp-e-commerce' ); ?></option>
			<option value='billingfirstname'><?php esc_html_e( 'Billing First Name', 'wp-e-commerce' ); ?></option>
			<option value='billinglastname'><?php esc_html_e( 'Billing Last Name', 'wp-e-commerce' ); ?></option>
			<option value='billingaddress'><?php esc_html_e( 'Billing Address', 'wp-e-commerce' ); ?></option>
			<option value='billingcity'><?php esc_html_e( 'Billing City', 'wp-e-commerce' ); ?></option>
			<option value='billingstate'><?php esc_html_e( 'Billing State', 'wp-e-commerce' ); ?></option>
			<option value='billingcountry'><?php esc_html_e( 'Billing Country', 'wp-e-commerce' ); ?></option>
			<option value='billingemail'><?php esc_html_e( 'Billing Email', 'wp-e-commerce' ); ?></option>
			<option value='billingphone'><?php esc_html_e( 'Billing Phone', 'wp-e-commerce' ); ?></option>
			<option value='billingpostcode'><?php esc_html_e( 'Billing Post Code', 'wp-e-commerce' ); ?></option>
			<option value='shippingfirstname'><?php esc_html_e( 'Shipping First Name', 'wp-e-commerce' ); ?></option>
			<option value='shippinglastname'><?php esc_html_e( 'Shipping Last Name', 'wp-e-commerce' ); ?></option>
			<option value='shippingaddress'><?php esc_html_e( 'Shipping Address', 'wp-e-commerce' ); ?></option>
			<option value='shippingcity'><?php esc_html_e( 'Shipping City', 'wp-e-commerce' ); ?></option>
			<option value='shippingstate'><?php esc_html_e( 'Shipping State', 'wp-e-commerce' ); ?></option>
			<option value='shippingcountry'><?php esc_html_e( 'Shipping Country', 'wp-e-commerce' ); ?></option>
			<option value='shippingpostcode'><?php esc_html_e( 'Shipping Post Code', 'wp-e-commerce' ); ?></option>
		</select>
		<?php
	}

	public function display_upgrade_purchase_logs_3_7() {
		global $wpdb;
		$numChanged = 0;
		$numQueries = 0;
		$purchlog =  "SELECT DISTINCT id FROM `".WPSC_TABLE_PURCHASE_LOGS."` LIMIT 1";

		$id = $wpdb->get_var($purchlog);
		$usersql = "SELECT DISTINCT `".WPSC_TABLE_SUBMITTED_FORM_DATA."`.value, `".WPSC_TABLE_CHECKOUT_FORMS."`.* FROM `".WPSC_TABLE_CHECKOUT_FORMS."` LEFT JOIN `".WPSC_TABLE_SUBMITTED_FORM_DATA."` ON `".WPSC_TABLE_CHECKOUT_FORMS."`.id = `".WPSC_TABLE_SUBMITTED_FORM_DATA."`.`form_id` WHERE `".WPSC_TABLE_SUBMITTED_FORM_DATA."`.log_id=".$id." ORDER BY `".WPSC_TABLE_CHECKOUT_FORMS."`.`checkout_order`" ;
		$formfields = $wpdb->get_results($usersql);

		if(count($formfields) < 1){
			$usersql = "SELECT DISTINCT  `".WPSC_TABLE_CHECKOUT_FORMS."`.* FROM `".WPSC_TABLE_CHECKOUT_FORMS."` WHERE `type` != 'heading'";
			$formfields = $wpdb->get_results($usersql);
		}

		if(isset($_POST)){
			foreach($_POST as $key=>$value){
				if($value != '-1'){
					$complete = $wpdb->update(
				 WPSC_TABLE_CHECKOUT_FORMS,
				 array(
				'unique_name' => $value
				 ),
				 array(
				'id' => $key
				  ),
				 '%s',
				 '%d'
				 );
				}
				$numChanged++;
				$numQueries ++;
			}

			$sql = "UPDATE `".WPSC_TABLE_CHECKOUT_FORMS."` SET `unique_name`='delivertoafriend' WHERE `name` = '2. Shipping details'";
			$wpdb->query($sql);

			add_option('wpsc_purchaselogs_fixed',true);
		}

		include( 'includes/purchase-logs-page/upgrade.php' );
	}

	public function display_upgrade_purchase_logs_3_8() {
		?>
			<div class="wrap">
				<h2><?php echo esc_html( __('Sales', 'wp-e-commerce') ); ?> </h2>
				<div class="updated">
					<p><?php printf( __( 'Your purchase logs have been updated! <a href="%s">Click here</a> to return.' , 'wp-e-commerce' ), esc_url( remove_query_arg( 'c' ) ) ); ?></p>
				</div>
			</div>
		<?php
	}

	public function controller_upgrade_purchase_logs_3_8() {
		if ( $this->needs_update() ) {
			wpsc_update_purchase_logs();
		}

		add_action( 'wpsc_display_purchase_logs_page', array( $this, 'display_upgrade_purchase_logs_3_8' ) );
	}

	function purchase_logs_pagination() {
		global $wpdb, $purchlogitem;
		$prev_id = $this->log->get_previous_log_id();
		$next_id = $this->log->get_next_log_id();
		?>
		<span class='tablenav'><span class='tablenav-pages'><span class='pagination-links'>
			<?php if ( $prev_id ) : ?>
				<a href='<?php echo esc_url( $this->get_purchase_log_url( $prev_id ) ); ?>' class='prev-page'>&lsaquo; <?php _e( 'Previous', 'wp-e-commerce' ); ?></a>
			<?php endif; ?>

			<?php if ( $next_id ) : ?>
				<a href='<?php echo esc_url( $this->get_purchase_log_url( $next_id ) ); ?>' class='next-page'><?php _e( 'Next', 'wp-e-commerce' ); ?> &rsaquo;</a>
			<?php endif; ?>
		</span></span></span>
		<?php
	}

	function purchase_logs_checkout_fields(){
		global $purchlogitem;

		if ( ! empty( $purchlogitem->additional_fields ) ) {
		?>
			<div class="metabox-holder">
				<div id="custom_checkout_fields" class="postbox">
					<h3 class='hndle'><?php esc_html_e( 'Additional Checkout Fields' , 'wp-e-commerce' ); ?></h3>
					<div class='inside'>
						<?php
						foreach( (array) $purchlogitem->additional_fields as $value ) {
							$value['value'] = maybe_unserialize ( $value['value'] );

							if ( is_array( $value['value'] ) ) {
								?>
									<p><strong><?php echo $value['name']; ?> :</strong> <?php echo implode( stripslashes( $value['value'] ), ',' ); ?></p>
								<?php
							} else {
								$thevalue = esc_html( stripslashes( $value['value'] ));
								if ( empty( $thevalue ) ) {
									$thevalue = __( '<em>blank</em>', 'wp-e-commerce' );
								}
								?>
									<p><strong><?php echo $value['name']; ?> :</strong> <?php echo $thevalue; ?></p>
								<?php
							}
						}
						?>
					</div>
				</div>
			</div>
		<?php
		}
	}

	public function purchase_log_custom_fields(){
		if( wpsc_purchlogs_has_customfields() ){?>
			<div class='metabox-holder'>
				<div id='purchlogs_customfields' class='postbox'>
					<h3 class='hndle'><?php esc_html_e( 'Users Custom Fields' , 'wp-e-commerce' ); ?></h3>
					<div class='inside'>
						<?php $messages = wpsc_purchlogs_custommessages(); ?>
						<?php $files = wpsc_purchlogs_customfiles(); ?>
						<?php if(count($files) > 0){ ?>
							<h4><?php esc_html_e( 'Cart Items with Custom Files' , 'wp-e-commerce' ); ?>:</h4>
							<?php
							foreach($files as $file){
								echo $file;
							}
						}?>
						<?php if(count($messages) > 0){ ?>
							<h4><?php esc_html_e( 'Cart Items with Custom Messages' , 'wp-e-commerce' ); ?>:</h4>
							<?php
							foreach($messages as $message){
								echo esc_html( $message['title'] ) . ':<br />' . nl2br( esc_html( $message['message'] ) );
							}
						} ?>
					</div>
				</div>
			</div>
		<?php
		}
	}

	private function purchase_log_cart_items() {
		while( wpsc_have_purchaselog_details() ) : wpsc_the_purchaselog_item();
			self::purchase_log_cart_item( $this->can_edit );
		endwhile;
	}

	public static function purchase_log_cart_item( $can_edit = false ) {
		?>
		<tr class="purchase-log-line-item" id="purchase-log-item-<?php echo wpsc_purchaselog_details_id(); ?>" data-id="<?php echo wpsc_purchaselog_details_id(); ?>" data-productid="<?php echo wpsc_purchaselog_product_id(); ?>">
			<td><?php echo wpsc_purchaselog_details_name(); ?></td> <!-- NAME! -->
			<td><?php echo wpsc_purchaselog_details_SKU(); ?></td> <!-- SKU! -->
			<td>
				<?php if ( $can_edit ) : ?>
					<input type="number" step="1" min="0" autocomplete="off" name="wpsc_item_qty" class="wpsc_item_qty" placeholder="0" value="<?php echo wpsc_purchaselog_details_quantity(); ?>" size="4" class="quantity">
				<?php else: ?>
					<?php echo wpsc_purchaselog_details_quantity(); ?>
				<?php endif; ?>
			</td> <!-- QUANTITY! -->
			<td>
		 <?php
		echo wpsc_currency_display( wpsc_purchaselog_details_price() );
		do_action( 'wpsc_additional_sales_amount_info', wpsc_purchaselog_details_id() );
		 ?>
	 </td> <!-- PRICE! -->
			<td><?php echo wpsc_currency_display( wpsc_purchaselog_details_shipping() ); ?></td> <!-- SHIPPING! -->
			<?php if( wpec_display_product_tax() ): ?>
				<td><?php echo wpsc_currency_display( wpsc_purchaselog_details_tax() ); ?></td> <!-- TAX! -->
			<?php endif; ?>
			<!-- <td><?php echo wpsc_currency_display( wpsc_purchaselog_details_discount() ); ?></td> --> <!-- DISCOUNT! -->
			<td class="amount"><?php echo wpsc_currency_display( wpsc_purchaselog_details_total() ); ?></td> <!-- TOTAL! -->
			<?php if ( $can_edit ) : ?>
				<td class="remove">
					<div class="wpsc-remove-row">
						<button type="button" class="wpsc-remove-item-button"><span style="color:#a00;" class="dashicons dashicons-dismiss"></span> <?php esc_html_e( 'Remove Item', 'wp-e-commerce' ); ?></button>
					</div>
				</td> <!-- REMOVE! -->
			<?php endif; ?>
		</tr>
		<?php
		do_action( 'wpsc_additional_sales_item_info', wpsc_purchaselog_details_id() );
	}

	public function controller_item_details() {
		if (
			! isset( $_REQUEST['id'] )
			|| ( isset( $_REQUEST['id'] ) && ! is_numeric( $_REQUEST['id'] ) )
			|| ! $this->log->exists()
		) {
			wp_die( __( 'Invalid sales log ID', 'wp-e-commerce'  ) );
		}

		$this->log->init_items();

		$columns = array(
			'title'    => __( 'Name', 'wp-e-commerce' ),
			'sku'      => __( 'SKU', 'wp-e-commerce' ),
			'quantity' => __( 'Quantity','wp-e-commerce' ),
			'price'    => __( 'Price', 'wp-e-commerce' ),
			'shipping' => __( 'Item Shipping', 'wp-e-commerce'),
		);

		if ( wpec_display_product_tax() ) {
			$columns['tax'] = __( 'Item Tax', 'wp-e-commerce' );
		}

		$columns['total'] = __( 'Item Total','wp-e-commerce' );

		if ( $this->can_edit ) {
			$columns['remove'] = '';
		}

		register_column_headers( 'wpsc_purchase_log_item_details', $columns );

		add_action( 'wpsc_display_purchase_logs_page', array( $this, 'display_purchase_log' ) );
		add_action( 'wpsc_purchlogitem_metabox_start', array( $this, 'purchase_log_custom_fields' ) );
	}

	public function controller_packing_slip() {

		if ( ! isset( $_REQUEST['id'] ) || ( isset( $_REQUEST['id'] ) && ! is_numeric( $_REQUEST['id'] ) ) ) {
			wp_die( __( 'Invalid sales log ID', 'wp-e-commerce'  ) );
		}

		$this->log->init_items();

		$columns = array(
			'title'    => __( 'Item Name', 'wp-e-commerce' ),
			'sku'      => __( 'SKU', 'wp-e-commerce' ),
			'quantity' => __( 'Quantity', 'wp-e-commerce' ),
			'price'    => __( 'Price', 'wp-e-commerce' ),
			'shipping' => __( 'Item Shipping','wp-e-commerce' ),
		);

		if ( wpec_display_product_tax() ) {
			$columns['tax'] = __( 'Item Tax', 'wp-e-commerce' );
		}

		$columns['total'] = __( 'Item Total','wp-e-commerce' );

		$cols = count( $columns ) - 2;

		register_column_headers( 'wpsc_purchase_log_item_details', $columns );

		if ( file_exists( get_stylesheet_directory() . '/wpsc-packing-slip.php' ) ) {
			$packing_slip_file = get_stylesheet_directory() . '/wpsc-packing-slip.php';
		} else {
			$packing_slip_file = 'includes/purchase-logs-page/packing-slip.php';
		}

		$packing_slip_file = apply_filters( 'wpsc_packing_packing_slip_path', $packing_slip_file );

		include( $packing_slip_file );

		exit;
	}

	public function controller_default() {
		// Create an instance of our package class...
		$this->list_table = new WPSC_Purchase_Log_List_Table();
		$this->process_bulk_action();
		$this->list_table->prepare_items();
		add_action( 'wpsc_display_purchase_logs_page', array( $this, 'display_list_table' ) );
	}

	public function display_purchase_log() {
		$cols = 4;
		if ( wpec_display_product_tax() ) {
			$cols++;
		}

		if ( $this->can_edit ) {
			$cols++;
		}

		$receipt_sent = ! empty( $_GET['sent'] );
		$receipt_not_sent = isset( $_GET['sent'] ) && ! $_GET['sent'];
		include( 'includes/purchase-logs-page/item-details.php' );

		global $wp_scripts;

		wp_enqueue_script( 'wp-backbone' );

		if ( isset( $wp_scripts->registered['wp-e-commerce-purchase-logs'] ) ) {
			// JS needed for modal
			$wp_scripts->registered['wp-e-commerce-purchase-logs']->deps[] = 'wp-backbone';
		}

		add_action( 'admin_footer', 'find_posts_div' );
	}

	public function download_csv() {
		_wpsc_download_purchase_log_csv();
	}

	public function process_bulk_action() {
		global $wpdb;
		$current_action = $this->list_table->current_action();

		do_action( 'wpsc_sales_log_process_bulk_action', $current_action );

		if ( ! $current_action || ( 'download_csv' != $current_action && empty( $_REQUEST['post'] ) ) ) {
			if ( ! empty( $_REQUEST['_wp_http_referer'] ) ) {
				wp_redirect( esc_url_raw( remove_query_arg( array( '_wp_http_referer', '_wpnonce', 'action', 'action2' ), stripslashes( $_SERVER['REQUEST_URI'] ) ) ) );
				exit;
			}

			unset( $_REQUEST['post'] );
			return;
		}

		if ( 'download_csv' == $current_action ) {
			$this->download_csv();
			exit;
		}

		$sendback = remove_query_arg( array(
			'_wpnonce',
			'_wp_http_referer',
			'action',
			'action2',
			'confirm',
			'post',
			'last_paged'
		) );

		if ( 'delete' == $current_action ) {

			// delete action
			if ( empty( $_REQUEST['confirm'] ) ) {
				$this->list_table->disable_search_box();
				$this->list_table->disable_bulk_actions();
				$this->list_table->disable_sortable();
				$this->list_table->disable_month_filter();
				$this->list_table->disable_views();
				$this->list_table->set_per_page(0);
				add_action( 'wpsc_purchase_logs_list_table_before', array( $this, 'action_list_table_before' ) );
				return;
			} else {
				if ( empty( $_REQUEST['post'] ) )
					return;

				$ids = array_map( 'intval', $_REQUEST['post'] );

				foreach ( $ids as $id ) {
					$log = new WPSC_Purchase_Log( $id );
					$log->delete();
				}

				$sendback = add_query_arg( array(
					'paged'   => $_REQUEST['last_paged'],
					'deleted' => count( $_REQUEST['post'] ),
				), $sendback );

			}
		}

		// change status actions
		if ( is_numeric( $current_action ) && ! empty( $_REQUEST['post'] ) ) {

			foreach ( $_REQUEST['post'] as $id )
				wpsc_purchlog_edit_status( $id, $current_action );

			$sendback = add_query_arg( array(
				'updated' => count( $_REQUEST['post'] ),
			), $sendback );
		}

		wp_redirect( esc_url_raw( $sendback ) );
		exit;
	}

	public function action_list_table_before() {
		include( 'includes/purchase-logs-page/bulk-delete-confirm.php' );
	}

	public function display_list_table() {
		if ( ! empty( $this->output ) ) {
			echo $this->output;
			return;
		}

		include( 'includes/purchase-logs-page/list-table.php' );
	}

	private function get_purchase_log_url( $id ) {
		$location = add_query_arg( array(
			'page' => 'wpsc-purchase-logs',
			'c'    => 'item_details',
			'id'   => $id,
		), admin_url( 'index.php' ) );

		return esc_url( $location );
	}

}


1			<?php
2			/**
3			* WP eCommerce edit and view sales page functions
4			*
5			* These are the main WPSC sales page functions
6			*
7			* @package wp-e-commerce
8			* @since 3.8.8
9			*/
10
11			class WPSC_Purchase_Log_Page {
12			private $list_table;
13			private $output;
14			public $log_id = 0;
15
16			/**
17			* WPSC_Purchase_Log
18			*
19			* @var WPSC_Purchase_Log object.
20			*/
21			public $log = null;
22
23			/**
24			* Whether the purchase log can be modified.
25			*
26			* @var boolean
27			*/
28			protected $can_edit = false;
29
30			public function __construct() {
31			$controller = 'default';
32			$controller_method = 'controller_default';
33
34			// If individual purchase log, setup ID and action links.
35			if ( isset( $_REQUEST['id'] ) && is_numeric( $_REQUEST['id'] ) ) {
36			$this->log_id = (int) $_REQUEST['id'];
37			$this->log = new WPSC_Purchase_Log( $this->log_id );
38			$this->can_edit = $this->log->can_edit();
39			}
40
41			if ( isset( $_REQUEST['c'] ) && method_exists( $this, 'controller_' . $_REQUEST['c'] ) ) {
42			$controller = $_REQUEST['c'];
43			$controller_method = 'controller_' . $controller;
44			} elseif ( isset( $_REQUEST['id'] ) && is_numeric( $_REQUEST['id'] ) ) {
45			$controller = 'item_details';
46			$controller_method = 'controller_item_details';
47			}
48
49			// Can only edit in the item details view.
50			if ( 'controller_item_details' !== $controller_method ) {
51			$this->can_edit = false;
52			}
53
54			$this->$controller_method();
55			}
56
57			private function needs_update() {
58			global $wpdb;
59
60			if ( get_option( '_wpsc_purchlogs_3.8_updated' ) )
61			return false;
62
63			$c = $wpdb->get_var( "SELECT COUNT(*) FROM " . WPSC_TABLE_PURCHASE_LOGS . " WHERE plugin_version IN ('3.6', '3.7')" );
64			if ( $c > 0 )
65			return true;
66
67			update_option( '_wpsc_purchlogs_3.8_updated', true );
68			return false;
69			}
70
71			public function controller_upgrade_purchase_logs_3_7() {
72			add_action( 'wpsc_display_purchase_logs_page', array( $this, 'display_upgrade_purchase_logs_3_7' ) );
73			}
74
75			private function purchase_logs_fix_options( $id ) {
76			?>
77			<select name='<?php echo $id; ?>'>
78			<option value='-1'><?php echo esc_html_x( 'Select an Option', 'Dropdown default when called in uniquename dropdown', 'wp-e-commerce' ); ?></option>
79			<option value='billingfirstname'><?php esc_html_e( 'Billing First Name', 'wp-e-commerce' ); ?></option>
80			<option value='billinglastname'><?php esc_html_e( 'Billing Last Name', 'wp-e-commerce' ); ?></option>
81			<option value='billingaddress'><?php esc_html_e( 'Billing Address', 'wp-e-commerce' ); ?></option>
82			<option value='billingcity'><?php esc_html_e( 'Billing City', 'wp-e-commerce' ); ?></option>
83			<option value='billingstate'><?php esc_html_e( 'Billing State', 'wp-e-commerce' ); ?></option>
84			<option value='billingcountry'><?php esc_html_e( 'Billing Country', 'wp-e-commerce' ); ?></option>
85			<option value='billingemail'><?php esc_html_e( 'Billing Email', 'wp-e-commerce' ); ?></option>
86			<option value='billingphone'><?php esc_html_e( 'Billing Phone', 'wp-e-commerce' ); ?></option>
87			<option value='billingpostcode'><?php esc_html_e( 'Billing Post Code', 'wp-e-commerce' ); ?></option>
88			<option value='shippingfirstname'><?php esc_html_e( 'Shipping First Name', 'wp-e-commerce' ); ?></option>
89			<option value='shippinglastname'><?php esc_html_e( 'Shipping Last Name', 'wp-e-commerce' ); ?></option>
90			<option value='shippingaddress'><?php esc_html_e( 'Shipping Address', 'wp-e-commerce' ); ?></option>
91			<option value='shippingcity'><?php esc_html_e( 'Shipping City', 'wp-e-commerce' ); ?></option>
92			<option value='shippingstate'><?php esc_html_e( 'Shipping State', 'wp-e-commerce' ); ?></option>
93			<option value='shippingcountry'><?php esc_html_e( 'Shipping Country', 'wp-e-commerce' ); ?></option>
94			<option value='shippingpostcode'><?php esc_html_e( 'Shipping Post Code', 'wp-e-commerce' ); ?></option>
95			</select>
96			<?php
97			}
98
99			public function display_upgrade_purchase_logs_3_7() {
100			global $wpdb;
101			$numChanged = 0;
102			$numQueries = 0;
103			$purchlog = "SELECT DISTINCT id FROM `".WPSC_TABLE_PURCHASE_LOGS."` LIMIT 1";
			0 ignored issues – show introduced 2015-11-30 18:13 UTC by Report Bug Copy Issue Report Expected 1 space after "="; 2 found Loading history...
104			$id = $wpdb->get_var($purchlog);
105			$usersql = "SELECT DISTINCT `".WPSC_TABLE_SUBMITTED_FORM_DATA."`.value, `".WPSC_TABLE_CHECKOUT_FORMS."`.* FROM `".WPSC_TABLE_CHECKOUT_FORMS."` LEFT JOIN `".WPSC_TABLE_SUBMITTED_FORM_DATA."` ON `".WPSC_TABLE_CHECKOUT_FORMS."`.id = `".WPSC_TABLE_SUBMITTED_FORM_DATA."`.`form_id` WHERE `".WPSC_TABLE_SUBMITTED_FORM_DATA."`.log_id=".$id." ORDER BY `".WPSC_TABLE_CHECKOUT_FORMS."`.`checkout_order`" ;
106			$formfields = $wpdb->get_results($usersql);
107
108			if(count($formfields) < 1){
109			$usersql = "SELECT DISTINCT `".WPSC_TABLE_CHECKOUT_FORMS."`.* FROM `".WPSC_TABLE_CHECKOUT_FORMS."` WHERE `type` != 'heading'";
110			$formfields = $wpdb->get_results($usersql);
111			}
112
113			if(isset($_POST)){
114			foreach($_POST as $key=>$value){
115			if($value != '-1'){
116			$complete = $wpdb->update(
117			WPSC_TABLE_CHECKOUT_FORMS,
118			array(
119			'unique_name' => $value
120			),
121			array(
122			'id' => $key
123			),
124			'%s',
125			'%d'
126			);
127			}
128			$numChanged++;
129			$numQueries ++;
130			}
131
132			$sql = "UPDATE `".WPSC_TABLE_CHECKOUT_FORMS."` SET `unique_name`='delivertoafriend' WHERE `name` = '2. Shipping details'";
133			$wpdb->query($sql);
134
135			add_option('wpsc_purchaselogs_fixed',true);
136			}
137
138			include( 'includes/purchase-logs-page/upgrade.php' );
139			}
140
141			public function display_upgrade_purchase_logs_3_8() {
142			?>
143			<div class="wrap">
144			<h2><?php echo esc_html( __('Sales', 'wp-e-commerce') ); ?> </h2>
145			<div class="updated">
146			<p><?php printf( __( 'Your purchase logs have been updated! <a href="%s">Click here</a> to return.' , 'wp-e-commerce' ), esc_url( remove_query_arg( 'c' ) ) ); ?></p>
147			</div>
148			</div>
149			<?php
150			}
151
152			public function controller_upgrade_purchase_logs_3_8() {
153			if ( $this->needs_update() ) {
154			wpsc_update_purchase_logs();
155			}
156
157			add_action( 'wpsc_display_purchase_logs_page', array( $this, 'display_upgrade_purchase_logs_3_8' ) );
158			}
159
160			function purchase_logs_pagination() {
161			global $wpdb, $purchlogitem;
162			$prev_id = $this->log->get_previous_log_id();
163			$next_id = $this->log->get_next_log_id();
164			?>
165			<span class='tablenav'><span class='tablenav-pages'><span class='pagination-links'>
166			<?php if ( $prev_id ) : ?>
167			<a href='<?php echo esc_url( $this->get_purchase_log_url( $prev_id ) ); ?>' class='prev-page'>&lsaquo; <?php _e( 'Previous', 'wp-e-commerce' ); ?></a>
168			<?php endif; ?>
169
170			<?php if ( $next_id ) : ?>
171			<a href='<?php echo esc_url( $this->get_purchase_log_url( $next_id ) ); ?>' class='next-page'><?php _e( 'Next', 'wp-e-commerce' ); ?> &rsaquo;</a>
172			<?php endif; ?>
173			</span></span></span>
174			<?php
175			}
176
177			function purchase_logs_checkout_fields(){
178			global $purchlogitem;
179
180			if ( ! empty( $purchlogitem->additional_fields ) ) {
181			?>
182			<div class="metabox-holder">
183			<div id="custom_checkout_fields" class="postbox">
184			<h3 class='hndle'><?php esc_html_e( 'Additional Checkout Fields' , 'wp-e-commerce' ); ?></h3>
185			<div class='inside'>
186			<?php
187			foreach( (array) $purchlogitem->additional_fields as $value ) {
188			$value['value'] = maybe_unserialize ( $value['value'] );
			0 ignored issues – show Coding Style introduced 2015-11-30 18:13 UTC by Report Bug Copy Issue Report Space before opening parenthesis of function call prohibited Loading history...
189			if ( is_array( $value['value'] ) ) {
190			?>
191			<p><strong><?php echo $value['name']; ?> :</strong> <?php echo implode( stripslashes( $value['value'] ), ',' ); ?></p>
192			<?php
193			} else {
194			$thevalue = esc_html( stripslashes( $value['value'] ));
195			if ( empty( $thevalue ) ) {
196			$thevalue = __( '<em>blank</em>', 'wp-e-commerce' );
197			}
198			?>
199			<p><strong><?php echo $value['name']; ?> :</strong> <?php echo $thevalue; ?></p>
200			<?php
201			}
202			}
203			?>
204			</div>
205			</div>
206			</div>
207			<?php
208			}
209			}
210
211			public function purchase_log_custom_fields(){
212			if( wpsc_purchlogs_has_customfields() ){?>
213			<div class='metabox-holder'>
214			<div id='purchlogs_customfields' class='postbox'>
215			<h3 class='hndle'><?php esc_html_e( 'Users Custom Fields' , 'wp-e-commerce' ); ?></h3>
216			<div class='inside'>
217			<?php $messages = wpsc_purchlogs_custommessages(); ?>
218			<?php $files = wpsc_purchlogs_customfiles(); ?>
219			<?php if(count($files) > 0){ ?>
220			<h4><?php esc_html_e( 'Cart Items with Custom Files' , 'wp-e-commerce' ); ?>:</h4>
221			<?php
222			foreach($files as $file){
223			echo $file;
224			}
225			}?>
226			<?php if(count($messages) > 0){ ?>
227			<h4><?php esc_html_e( 'Cart Items with Custom Messages' , 'wp-e-commerce' ); ?>:</h4>
228			<?php
229			foreach($messages as $message){
230			echo esc_html( $message['title'] ) . ':<br />' . nl2br( esc_html( $message['message'] ) );
231			}
232			} ?>
233			</div>
234			</div>
235			</div>
236			<?php
237			}
238			}
239
240			private function purchase_log_cart_items() {
241			while( wpsc_have_purchaselog_details() ) : wpsc_the_purchaselog_item();
242			self::purchase_log_cart_item( $this->can_edit );
243			endwhile;
244			}
245
246			public static function purchase_log_cart_item( $can_edit = false ) {
247			?>
248			<tr class="purchase-log-line-item" id="purchase-log-item-<?php echo wpsc_purchaselog_details_id(); ?>" data-id="<?php echo wpsc_purchaselog_details_id(); ?>" data-productid="<?php echo wpsc_purchaselog_product_id(); ?>">
249			<td><?php echo wpsc_purchaselog_details_name(); ?></td> <!-- NAME! -->
250			<td><?php echo wpsc_purchaselog_details_SKU(); ?></td> <!-- SKU! -->
251			<td>
252			<?php if ( $can_edit ) : ?>
253			<input type="number" step="1" min="0" autocomplete="off" name="wpsc_item_qty" class="wpsc_item_qty" placeholder="0" value="<?php echo wpsc_purchaselog_details_quantity(); ?>" size="4" class="quantity">
254			<?php else: ?>
255			<?php echo wpsc_purchaselog_details_quantity(); ?>
256			<?php endif; ?>
257			</td> <!-- QUANTITY! -->
258			<td>
259			<?php
260			echo wpsc_currency_display( wpsc_purchaselog_details_price() );
261			do_action( 'wpsc_additional_sales_amount_info', wpsc_purchaselog_details_id() );
262			?>
263			</td> <!-- PRICE! -->
264			<td><?php echo wpsc_currency_display( wpsc_purchaselog_details_shipping() ); ?></td> <!-- SHIPPING! -->
265			<?php if( wpec_display_product_tax() ): ?>
266			<td><?php echo wpsc_currency_display( wpsc_purchaselog_details_tax() ); ?></td> <!-- TAX! -->
267			<?php endif; ?>
268			<!-- <td><?php echo wpsc_currency_display( wpsc_purchaselog_details_discount() ); ?></td> --> <!-- DISCOUNT! -->
269			<td class="amount"><?php echo wpsc_currency_display( wpsc_purchaselog_details_total() ); ?></td> <!-- TOTAL! -->
270			<?php if ( $can_edit ) : ?>
271			<td class="remove">
272			<div class="wpsc-remove-row">
273			<button type="button" class="wpsc-remove-item-button"><span style="color:#a00;" class="dashicons dashicons-dismiss"></span> <?php esc_html_e( 'Remove Item', 'wp-e-commerce' ); ?></button>
274			</div>
275			</td> <!-- REMOVE! -->
276			<?php endif; ?>
277			</tr>
278			<?php
279			do_action( 'wpsc_additional_sales_item_info', wpsc_purchaselog_details_id() );
280			}
281
282			public function controller_item_details() {
283			if (
284			! isset( $_REQUEST['id'] )
285			\|\| ( isset( $_REQUEST['id'] ) && ! is_numeric( $_REQUEST['id'] ) )
286			\|\| ! $this->log->exists()
287			) {
288			wp_die( __( 'Invalid sales log ID', 'wp-e-commerce' ) );
289			}
290
291			$this->log->init_items();
292
293			$columns = array(
294			'title' => __( 'Name', 'wp-e-commerce' ),
295			'sku' => __( 'SKU', 'wp-e-commerce' ),
296			'quantity' => __( 'Quantity','wp-e-commerce' ),
297			'price' => __( 'Price', 'wp-e-commerce' ),
298			'shipping' => __( 'Item Shipping', 'wp-e-commerce'),
299			);
300
301			if ( wpec_display_product_tax() ) {
302			$columns['tax'] = __( 'Item Tax', 'wp-e-commerce' );
303			}
304
305			$columns['total'] = __( 'Item Total','wp-e-commerce' );
306
307			if ( $this->can_edit ) {
308			$columns['remove'] = '';
309			}
310
311			register_column_headers( 'wpsc_purchase_log_item_details', $columns );
312
313			add_action( 'wpsc_display_purchase_logs_page', array( $this, 'display_purchase_log' ) );
314			add_action( 'wpsc_purchlogitem_metabox_start', array( $this, 'purchase_log_custom_fields' ) );
315			}
316
317			public function controller_packing_slip() {
318
319			if ( ! isset( $_REQUEST['id'] ) \|\| ( isset( $_REQUEST['id'] ) && ! is_numeric( $_REQUEST['id'] ) ) ) {
320			wp_die( __( 'Invalid sales log ID', 'wp-e-commerce' ) );
321			}
322
323			$this->log->init_items();
324
325			$columns = array(
326			'title' => __( 'Item Name', 'wp-e-commerce' ),
327			'sku' => __( 'SKU', 'wp-e-commerce' ),
328			'quantity' => __( 'Quantity', 'wp-e-commerce' ),
329			'price' => __( 'Price', 'wp-e-commerce' ),
330			'shipping' => __( 'Item Shipping','wp-e-commerce' ),
331			);
332
333			if ( wpec_display_product_tax() ) {
334			$columns['tax'] = __( 'Item Tax', 'wp-e-commerce' );
335			}
336
337			$columns['total'] = __( 'Item Total','wp-e-commerce' );
338
339			$cols = count( $columns ) - 2;
340
341			register_column_headers( 'wpsc_purchase_log_item_details', $columns );
342
343			if ( file_exists( get_stylesheet_directory() . '/wpsc-packing-slip.php' ) ) {
344			$packing_slip_file = get_stylesheet_directory() . '/wpsc-packing-slip.php';
345			} else {
346			$packing_slip_file = 'includes/purchase-logs-page/packing-slip.php';
347			}
348
349			$packing_slip_file = apply_filters( 'wpsc_packing_packing_slip_path', $packing_slip_file );
350
351			include( $packing_slip_file );
352
353			exit;
354			}
355
356			public function controller_default() {
357			// Create an instance of our package class...
358			$this->list_table = new WPSC_Purchase_Log_List_Table();
359			$this->process_bulk_action();
360			$this->list_table->prepare_items();
361			add_action( 'wpsc_display_purchase_logs_page', array( $this, 'display_list_table' ) );
362			}
363
364			public function display_purchase_log() {
365			$cols = 4;
366			if ( wpec_display_product_tax() ) {
367			$cols++;
368			}
369
370			if ( $this->can_edit ) {
371			$cols++;
372			}
373
374			$receipt_sent = ! empty( $_GET['sent'] );
375			$receipt_not_sent = isset( $_GET['sent'] ) && ! $_GET['sent'];
376			include( 'includes/purchase-logs-page/item-details.php' );
377
378			global $wp_scripts;
379
380			wp_enqueue_script( 'wp-backbone' );
381
382			if ( isset( $wp_scripts->registered['wp-e-commerce-purchase-logs'] ) ) {
383			// JS needed for modal
384			$wp_scripts->registered['wp-e-commerce-purchase-logs']->deps[] = 'wp-backbone';
385			}
386
387			add_action( 'admin_footer', 'find_posts_div' );
388			}
389
390			public function download_csv() {
391			_wpsc_download_purchase_log_csv();
392			}
393
394			public function process_bulk_action() {
395			global $wpdb;
396			$current_action = $this->list_table->current_action();
397
398			do_action( 'wpsc_sales_log_process_bulk_action', $current_action );
399
400			if ( ! $current_action \|\| ( 'download_csv' != $current_action && empty( $_REQUEST['post'] ) ) ) {
401			if ( ! empty( $_REQUEST['_wp_http_referer'] ) ) {
402			wp_redirect( esc_url_raw( remove_query_arg( array( '_wp_http_referer', '_wpnonce', 'action', 'action2' ), stripslashes( $_SERVER['REQUEST_URI'] ) ) ) );
403			exit;
404			}
405
406			unset( $_REQUEST['post'] );
407			return;
408			}
409
410			if ( 'download_csv' == $current_action ) {
411			$this->download_csv();
412			exit;
413			}
414
415			$sendback = remove_query_arg( array(
416			'_wpnonce',
417			'_wp_http_referer',
418			'action',
419			'action2',
420			'confirm',
421			'post',
422			'last_paged'
423			) );
424
425			if ( 'delete' == $current_action ) {
426
427			// delete action
428			if ( empty( $_REQUEST['confirm'] ) ) {
429			$this->list_table->disable_search_box();
430			$this->list_table->disable_bulk_actions();
431			$this->list_table->disable_sortable();
432			$this->list_table->disable_month_filter();
433			$this->list_table->disable_views();
434			$this->list_table->set_per_page(0);
435			add_action( 'wpsc_purchase_logs_list_table_before', array( $this, 'action_list_table_before' ) );
436			return;
437			} else {
438			if ( empty( $_REQUEST['post'] ) )
439			return;
440
441			$ids = array_map( 'intval', $_REQUEST['post'] );
442
443			foreach ( $ids as $id ) {
444			$log = new WPSC_Purchase_Log( $id );
445			$log->delete();
446			}
447
448			$sendback = add_query_arg( array(
449			'paged' => $_REQUEST['last_paged'],
450			'deleted' => count( $_REQUEST['post'] ),
451			), $sendback );
452
453			}
454			}
455
456			// change status actions
457			if ( is_numeric( $current_action ) && ! empty( $_REQUEST['post'] ) ) {
458
459			foreach ( $_REQUEST['post'] as $id )
460			wpsc_purchlog_edit_status( $id, $current_action );
461
462			$sendback = add_query_arg( array(
463			'updated' => count( $_REQUEST['post'] ),
464			), $sendback );
465			}
466
467			wp_redirect( esc_url_raw( $sendback ) );
468			exit;
469			}
470
471			public function action_list_table_before() {
472			include( 'includes/purchase-logs-page/bulk-delete-confirm.php' );
473			}
474
475			public function display_list_table() {
476			if ( ! empty( $this->output ) ) {
477			echo $this->output;
478			return;
479			}
480
481			include( 'includes/purchase-logs-page/list-table.php' );
482			}
483
484			private function get_purchase_log_url( $id ) {
485			$location = add_query_arg( array(
486			'page' => 'wpsc-purchase-logs',
487			'c' => 'item_details',
488			'id' => $id,
489			), admin_url( 'index.php' ) );
490
491			return esc_url( $location );
492			}
493
494			}
495

wp-e-commerce / WP-e-Commerce

Pull Request — master (#2165)

WPSC_Purchase_Log_Page::download_csv() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like