ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / letacommog / laindinois / wp-content / plugins / woocommerce-pdf-vouchers / includes

<?php

// Exit if accessed directly
if ( !defined( 'ABSPATH' ) ) exit;

/**
 * Export to CSV for Voucher
 * 
 * Handles to Export to CSV on run time when 
 * user will execute the url which is sent to
 * user email with purchase receipt
 * 
 * @package WooCommerce - PDF Vouchers
 * @since 1.0.0
 */

$columns = array(
							esc_html__( 'Voucher Code', 'woovoucher' ),
							esc_html__( 'Buyer\'s Information', 'woovoucher' ),
							esc_html__( 'Order Information', 'woovoucher' ),
							esc_html__( 'Voucher Information', 'woovoucher' ),	
							esc_html__( 'Recipient Information', 'woovoucher' ),
					     );
					     
		if( isset( $_GET['woo_vou_action'] ) && $_GET['woo_vou_action'] == 'used' ) {
			
			$new_columns	= array( esc_html__('Redeem Information', 'woovoucher' ) );
			$columns 		= array_merge ( $columns , $new_columns );
			
		}

// Put the name of all fields
		foreach ($columns as $column) {
			
			$exports .= '"'.$column.'",';
		}
		$exports .="\n";

if( !empty( $voucodes ) &&  count( $voucodes ) > 0 ) {

foreach ( $voucodes as $key => $voucodes_data ) { 
                
                $voucher_codes = explode(',', $voucodes_data['vou_codes'] );
                foreach ( $voucher_codes as $voucher_code ) { 
                                    
                    //voucher order id
                    $orderid 		= $voucodes_data['order_id'];

//voucher code purchased/used
                    $voucode 		= $voucher_code;;

// Get order information 
                    $order_info = woo_vou_display_order_info_html( $orderid, 'csv' );

// Get Recipient information 
                    $recipient_info = woo_vou_display_recipient_info_html( $orderid, $voucode, 'csv' );

// Get Voucher information 
                    $voucher_info = woo_vou_display_voucher_info_html( $orderid, $voucodes_data['voucode_id'], $voucode, 'csv' );

// Get Buyer information 
                    $buyer_details		 = $model->woo_vou_get_buyer_information( $orderid );
                    $buyer_details_html  = 'Name: '.$buyer_details['first_name'].' '.$buyer_details['last_name']."\n";
                    $buyer_details_html .= 'Email: '.$buyer_details['email']."\n";
                    $buyer_details_html .= 'Address: '.$buyer_details['address_1'].' '.$buyer_details['address_2']."\n";
                    $buyer_details_html .= $buyer_details['city'].' '.$buyer_details['state'].' '.$buyer_details['country'].' - '.$buyer_details['postcode']."\n";
                    $buyer_details_html .= 'Phone: '.$buyer_details['phone'];

$buyerinfo = $buyer_details_html;

//this line should be on start of loop
                    $exports .= '"'.html_entity_decode($voucode).'",';
                    $exports .= '"'.$buyerinfo.'",';
                    $exports .= '"'.$order_info.'",';
                    $exports .= '"'.$voucher_info.'",';
                    $exports .= '"'.$recipient_info.'",';

if( isset( $_GET['woo_vou_action'] ) && $_GET['woo_vou_action'] == 'used' ) {

// get voucher Redeem by information 
                        $redeeminfo = woo_vou_display_redeem_info_html( $voucodes_data['voucode_id'], $orderid, 'csv' );
                        $exports .= '"'.$redeeminfo.'",';
                    }
                    ob_start();

$added_column = ob_get_clean();

$exports .= $added_column;

$exports .="\n";
                }
			}
		}

// Apply filter to allow 3rd party people to change it
		$date_format = apply_filters( 'woo_vou_voucher_date_format', 'Y-m-d' );

$vou_file_name = str_replace( '{current_date}', date('Y-m-d'), $vou_file_name );
		
		// Output to browser with appropriate mime type, you choose ;)
		header("Content-type: text/x-csv");
		header("Content-Disposition: attachment; filename=".$vou_file_name.".csv");
		echo $exports;
		exit;
		
	}
	
	// generate csv for voucher code
	if( isset( $_GET['woo-vou-voucher-exp-csv'] ) && !empty( $_GET['woo-vou-voucher-exp-csv'] ) 
		&& $_GET['woo-vou-voucher-exp-csv'] == '1' ) 
	{	
		global $current_user,$woo_vou_model, $woo_vou_voucher, $post, $woo_vou_vendor_role;

// Taking parameter
		$orderby 	= isset( $_GET['orderby'] ) ? urldecode( $_GET['orderby'] ) : 'ID';
		$order		= isset( $_GET['order'] ) ? $_GET['order'] : 'DESC';

$args = array(
						'orderby'			=> $orderby,
						'order'				=> $order,
					);

$admin_roles	= woo_vou_assigned_admin_roles();
		
		//Get user role
		$user_roles	= isset( $current_user->roles ) ? $current_user->roles : array();
		$user_role	= array_shift( $user_roles );

if ( empty ( $current_user->ID ) || empty ( $current_user->roles ) ) {

return;
		}
		
		//model class
		$model = $woo_vou_model;

// Get option whether to allow all vendor to redeem voucher codes
	    $vou_enable_vendor_access_all_voucodes = get_option('vou_enable_vendor_access_all_voucodes');
	
		$exports = '';
		
		// Check action is used codes
		if( isset( $_GET['woo_vou_action'] ) && $_GET['woo_vou_action'] == 'used' ) {
		
			$args['meta_query'] = array(
											array(
														'key'		=> $prefix.'used_codes',
														'value'		=> '',
														'compare'	=> '!=',
													)
										);
			//Get user role
			$user_roles	= isset( $current_user->roles ) ? $current_user->roles : array();
			$user_role	= array_shift( $user_roles );
			
			//voucher admin roles
			$admin_roles	= woo_vou_assigned_admin_roles();

if( in_array( $user_role, $woo_vou_vendor_role ) 
				&& ( empty($vou_enable_vendor_access_all_voucodes) || $vou_enable_vendor_access_all_voucodes == 'no' ) ) {// voucher admin can redeem all codes

$args['author'] = $current_user->ID;

} elseif( !in_array( $user_role, $woo_vou_vendor_role ) && !in_array( $user_role, $admin_roles ) ) {
		
				$args['meta_query'] =	array(
									'relation' => 'AND',
									($args['meta_query']),
									array(
										array(
												'key'		=> $prefix.'customer_user',
												'value'		=> $current_user->ID,
												'compare'	=> '=',
											)
									)
								);
			}

if( isset( $_GET['woo_vou_post_id'] ) && !empty( $_GET['woo_vou_post_id'] ) ) {
				$args['post_parent'] = $_GET['woo_vou_post_id'];
			}
			
			if( isset( $_GET['woo_vou_user_id'] ) && !empty( $_GET['woo_vou_user_id'] ) ) {
				
				$args['meta_query'] =	array(
								'relation' => 'AND',
								($args['meta_query']),
								array(
									array(
											'key'		=> $prefix.'redeem_by',
											'value'		=> $_GET['woo_vou_user_id'],
											'compare'	=> '=',
										)
								)
							);
			}
			
			if( isset( $_GET['woo_vou_start_date'] ) && !empty( $_GET['woo_vou_start_date'] ) ) {
				
				$args['meta_query'] =	array(
								'relation' => 'AND',
								($args['meta_query']),
								array(
									array(
											'key'		=> $prefix.'used_code_date',
											'value'		=> date( "Y-m-d H:i:s", strtotime( $_GET['woo_vou_start_date'] ) ),
											'compare'	=> '>=',
										)
								)
							);
			}
			
			if( isset( $_GET['woo_vou_end_date'] ) && !empty( $_GET['woo_vou_end_date'] ) ) {
				
				$args['meta_query'] =	array(
								'relation' => 'AND',
								($args['meta_query']),
								array(
									array(
											'key'		=> $prefix.'used_code_date',
											'value'		=> date( "Y-m-d H:i:s", strtotime( $_GET['woo_vou_end_date'] ) ),
											'compare'	=> '<=',
										)
								)
							);
			}

// If Partially Used checkbox is ticked than only show voucher codes which are used partially
			if( !empty( $_GET['woo_vou_partial_used_voucode'] ) && $_GET['woo_vou_partial_used_voucode'] == 'yes' ){

// Search for code having meta key _woo_vou_redeem_method and meta value partial
				$args['meta_query'] = array_merge(array( array( 
														'key' 		=> $prefix . 'redeem_method',
														'value'		=> 'partial',
														) ), $args['meta_query']);
			}

if( isset( $_GET['s'] ) && !empty( $_GET['s'] ) ) {
				
				//$args['s'] = $_GET['s'];
				$args['meta_query'] = array(
											'relation' => 'AND',
											($args['meta_query']),
											array(
												'relation'	=> 'OR',
												array(
															'key'		=> $prefix.'used_codes',
															'value'		=> $_GET['s'],
															'compare'	=> 'LIKE',
														),
												array(
															'key'		=> $prefix.'first_name',
															'value'		=> $_GET['s'],
															'compare'	=> 'LIKE',
														),
												array(
															'key'		=> $prefix.'last_name',
															'value'		=> $_GET['s'],
															'compare'	=> 'LIKE',
														),
												array(
															'key'		=> $prefix.'order_id',
															'value'		=> $_GET['s'],
															'compare'	=> 'LIKE',
														),
												array(
															'key'		=> $prefix.'order_date',
															'value'		=> $_GET['s'],
															'compare'	=> 'LIKE',
														),
											)
										);
			}

$args = apply_filters('woo_vou_used_codes_gen_csv', $args);

//Get Voucher Details by post id
		 	$voucodes = woo_vou_get_voucher_details( $args );
		 	
		 	$vou_file_name = 'woo-used-voucher-codes-{current_date}';
			
		} else { // Get expired codes
		 	
		 	if( isset( $_GET['vou-data'] ) && $_GET['vou-data'] == 'expired') {
		 		
	 			$args['meta_query'] = array(
										array(
												'key' 		=> $prefix . 'purchased_codes',
												'value'		=> '',
												'compare' 	=> '!='
											),
										array(
													'key'     	=> $prefix . 'used_codes',
													'compare' 	=> 'NOT EXISTS'
											 ),
										array(
												'key' =>  $prefix .'exp_date',
												'compare' => '<=',
	                  							'type'    => 'DATE',
	                  							'value' => $model->woo_vou_current_date()
											)										    
									);
									
				$vou_file_name = 'woo-expired-voucher-codes-{current_date}';
		 		
		 	} else {
		 		
				$args['meta_query'] = array(
											array(
													'key' 		=> $prefix . 'purchased_codes',
													'value'		=> '',
													'compare' 	=> '!='
												),
											array(
														'key'     	=> $prefix . 'used_codes',
														'compare' 	=> 'NOT EXISTS'
												 ),
											array(
												'relation' => 'OR', // Optional, defaults to "AND"
												array(
													'key'     => $prefix .'exp_date',
													'value'   => '',
													'compare' => '='
												),
												array(
													'key' =>  $prefix .'exp_date',
													'compare' => '>=',
		                  							'type'    => 'DATE',
		                  							'value' => $model->woo_vou_current_date()
												)
										   )	 
										);
										
				$vou_csv_name  = get_option( 'vou_csv_name' );
				$vou_file_name = !empty( $vou_csv_name )? $vou_csv_name : 'woo-purchased-voucher-codes-{current_date}';
		 	}
			//Get user role
			$user_roles	= isset( $current_user->roles ) ? $current_user->roles : array();
			$user_role	= array_shift( $user_roles );

//voucher admin roles
			$admin_roles	= woo_vou_assigned_admin_roles();
	
			if( in_array( $user_role, $woo_vou_vendor_role ) && 
				( empty($vou_enable_vendor_access_all_voucodes) || $vou_enable_vendor_access_all_voucodes == 'no' ) ) {// voucher admin can redeem all codes

$args['author'] = $current_user->ID;

if( isset( $_GET['woo_vou_post_id'] ) && !empty( $_GET['woo_vou_post_id'] ) ) {
				$args['post_parent'] = $_GET['woo_vou_post_id'];
			}
			
			if( isset( $_GET['s'] ) && !empty( $_GET['s'] ) ) {
				
				$args['meta_query'] = array(
												'relation'	=> 'OR',
												array(
															'key'		=> $prefix.'purchased_codes',
															'value'		=> $_GET['s'],
															'compare'	=> 'LIKE',
														),
												array(
															'key'		=> $prefix.'first_name',
															'value'		=> $_GET['s'],
															'compare'	=> 'LIKE',
														),
												array(
															'key'		=> $prefix.'last_name',
															'value'		=> $_GET['s'],
															'compare'	=> 'LIKE',
														),
												array(
															'key'		=> $prefix.'order_id',
															'value'		=> $_GET['s'],
															'compare'	=> 'LIKE',
														),
												array(
															'key'		=> $prefix.'order_date',
															'value'		=> $_GET['s'],
															'compare'	=> 'LIKE',
														),
											);
			}

if( isset( $_GET['woo_vou_start_date'] ) && !empty( $_GET['woo_vou_start_date'] ) ) {

$args['date_query'][] = array(
												'column' => 'post_date',
												'after'  => $_GET['woo_vou_start_date'],
											);
			}

if( isset( $_GET['woo_vou_end_date'] ) && !empty( $_GET['woo_vou_end_date'] ) ) {

$args['date_query'][] = array(
												'column' => 'post_date',
												'before'  => $_GET['woo_vou_end_date'],
											);
			}

//Get Voucher Details by post id
		 	$voucodes = woo_vou_get_voucher_details( $args );
		}
		$columns = array(	
							esc_html__( 'Voucher Code', 'woovoucher' ),
							esc_html__( 'Product Information', 'woovoucher' ),
							esc_html__( 'Buyer\'s Information', 'woovoucher' ),
							esc_html__( 'Order Information', 'woovoucher' ),
							esc_html__( 'Voucher Information', 'woovoucher' ),	
							esc_html__( 'Recipient Information', 'woovoucher' ),
					     );
					     
		if( isset( $_GET['woo_vou_action'] ) && ( $_GET['woo_vou_action'] == 'used' || $_GET['woo_vou_action'] == 'partially' ) ) {
			
			$new_columns	= array( esc_html__('Redeem Information', 'woovoucher' ) );
			$columns 		= array_merge ( $columns , $new_columns );
			
		}	
		
		$csv_type	= isset( $_GET['woo_vou_action'] ) ? $_GET['woo_vou_action'] : 'purchased';		
		
		$columns	= apply_filters( 'woo_vou_generate_csv_columns', $columns, $csv_type );
		
        // Put the name of all fields
		foreach ($columns as $column) {
			
			$exports .= '"'.$column.'",';
		}
		$exports .="\n";
		
		if( !empty( $voucodes ) &&  count( $voucodes ) > 0 ) { 
												
			foreach ( $voucodes as $key => $voucodes_data ) {

if(isset( $_GET['woo_vou_action'] ) && $_GET['woo_vou_action'] == 'partially') {
					//voucher order id
					$orderid = get_post_meta( $voucodes[$key]['post_parent'], $prefix.'order_id', true );
				}
				else{
					//voucher order id
					$orderid = get_post_meta( $voucodes_data['ID'], $prefix.'order_id', true );
				}

// get order detail
	            $order = wc_get_order($orderid);
	            if (empty($order)) {
	            	continue;
	            }

if(isset( $_GET['woo_vou_action'] ) && $_GET['woo_vou_action'] == 'partially') { 
					
					
					//voucher order date
					$orderdate 		= get_post_meta( $voucodes[$key]['post_parent'], $prefix.'order_date', true );
					$orderdate 		= !empty( $orderdate ) ? $model->woo_vou_get_date_format( $orderdate, true ) : '';
					
					//voucher code purchased/used
					$voucode 		= get_post_meta( $voucodes[$key]['post_parent'], $prefix.'purchased_codes', true );
					
					// Get user details
					$user_id 	 	= get_post_meta( $voucodes_data['ID'], $prefix.'redeem_by', true );
					$user_detail 	= get_userdata( $user_id );
					$redeem_by 		= isset( $user_detail->display_name ) ? $user_detail->display_name : 'N/A';
					
					// Get redeem Date
					$redeem_date	= get_post_meta( $voucodes_data['ID'], $prefix.'used_code_date', true );
					$redeem_date 	= !empty( $redeem_date ) ? $model->woo_vou_get_date_format( $redeem_date, true ) : '';
					
					// Get Redeem by information 
					$redeeminfo 	=	woo_vou_display_redeem_info_html( $voucodes_data['ID'], $orderid ,'csv', 'partially' ); 
					$redeeminfo = strip_tags( $redeeminfo);	
					// Get buyer information 
					$buyer_details		 = $model->woo_vou_get_buyer_information( $orderid );
					$buyer_details_html  = 'Name: '.$buyer_details['first_name'].' '.$buyer_details['last_name']."\n";
					$buyer_details_html .= 'Email: '.$buyer_details['email']."\n";
					$buyer_details_html .= 'Address: '.$buyer_details['address_1'].' '.$buyer_details['address_2']."\n";
					$buyer_details_html .= $buyer_details['city'].' '.$buyer_details['state'].' '.$buyer_details['country'].' - '.$buyer_details['postcode']."\n";
					$buyer_details_html .= 'Phone: '.$buyer_details['phone'];
				
					$buyerinfo = $buyer_details_html;			
				
				} else {
					
					
					//voucher order date
					$orderdate 		= get_post_meta( $voucodes_data['ID'], $prefix.'order_date', true );
					$orderdate 		= !empty( $orderdate ) ? $model->woo_vou_get_date_format( $orderdate, true ) : '';
					
					//voucher code purchased/used
					$voucode 		= get_post_meta( $voucodes_data['ID'], $prefix.'purchased_codes', true );
					
					// Get user information 
					$user_id 	 	= get_post_meta( $voucodes_data['ID'], $prefix.'redeem_by', true );
					$user_detail 	= get_userdata( $user_id );
					$redeem_by 		= isset( $user_detail->display_name ) ? $user_detail->display_name : 'N/A';
					
					// Get voucher redeem date
					$redeem_date	= get_post_meta( $voucodes_data['ID'], $prefix.'used_code_date', true );
					$redeem_date 	= !empty( $redeem_date ) ? $model->woo_vou_get_date_format( $redeem_date, true ) : '';
					
					// get voucher Redeem by information 
					$redeeminfo = woo_vou_display_redeem_info_html( $voucodes_data['ID'], $orderid, 'csv' );
					
					// Get Buyer information 
					$buyer_details		 = $model->woo_vou_get_buyer_information( $orderid );
					$buyer_details_html  = 'Name: '.$buyer_details['first_name'].' '.$buyer_details['last_name']."\n";
					$buyer_details_html .= 'Email: '.$buyer_details['email']."\n";
					$buyer_details_html .= 'Address: '.$buyer_details['address_1'].' '.$buyer_details['address_2']."\n";
					$buyer_details_html .= $buyer_details['city'].' '.$buyer_details['state'].' '.$buyer_details['country'].' - '.$buyer_details['postcode']."\n";
					$buyer_details_html .= 'Phone: '.$buyer_details['phone'];
					
					$buyerinfo = $buyer_details_html;			
				}
					
				// get order detail
				$order = new WC_Order( $orderid );
				
				// get Buyer id, if buyer is guest then user id will be zero
				if ( version_compare( WOOCOMMERCE_VERSION, "3.0.0" ) == -1 )
					$user_id = $order->user_id;
				else
					$user_id = $order->get_user_id();				
				
				// Get Product information 
				$product_info = woo_vou_display_product_info_html( $orderid, $voucode, 'csv' );
				
				// Get order information 
				$order_info = woo_vou_display_order_info_html( $orderid, 'csv' );
				
				// Get Recipient information 
				$recipient_info = woo_vou_display_recipient_info_html( $orderid, $voucode, 'csv' );

// Get Voucher information 
				$voucher_info = woo_vou_display_voucher_info_html( $orderid, $voucodes_data['ID'], $voucode, 'csv' );
				
				//this line should be on start of loop
				$export = '"'.html_entity_decode($voucode).'",';
				$export .= '"'.$product_info.'",';
				$export .= '"'.$buyerinfo.'",';
				$export .= '"'.$order_info.'",';
				$export .= '"'.$voucher_info.'",';
				$export .= '"'.$recipient_info.'",';

if( isset( $_GET['woo_vou_action'] ) && ( $_GET['woo_vou_action'] == 'used' || $_GET['woo_vou_action'] == 'partially' ) ) {
					$export .= '"'.$redeeminfo.'",';
				}
				$exports .= apply_filters( 'woo_vou_generate_csv_add_column_after', $export, $orderid, $voucode, $voucodes_data['ID'] );
				
				$exports .="\n";
			}
		}

// Apply filter to allow 3rd party people to change it
		$date_format = apply_filters( 'woo_vou_voucher_date_format', 'Y-m-d' );

$vou_file_name = str_replace( '{current_date}', date( $date_format ), $vou_file_name );

// Output to browser with appropriate mime type, you choose ;)
		header("Content-type: text/x-csv");
		header("Content-Disposition: attachment; filename=".$vou_file_name.".csv");
		echo $exports;
		exit;
		
	}
}
add_action( 'init', 'woo_vou_code_export_to_csv' );

[+] ..
[-] woo-vou-generate-order-pdf.php [edit]
[+] css
[-] woo-vou-used-codes-pdf.php [edit]
[-] woo-vou-post-types.php [edit]
[+] js
[-] class-woo-vou-template-shortcodes.php [edit]
[-] woo-vou-shortcode-functions.php [edit]
[+] images
[-] class-woo-vou-shortcodes.php [edit]
[-] woo-vou-misc-functions.php [edit]
[-] woo-vou-template-html.php [edit]
[-] woo-vou-used-codes-export-csv.php [edit]
[-] woo-vou-install.php [edit]
[+] templates
[-] woo-vou-template-functions.php [edit]
[+] public
[+] tcpdf
[-] woo-vou-pdf-process.php [edit]
[-] woo-vou-cvc-functions.php [edit]
[-] woo-vou-uninstall.php [edit]
[-] woo-vou-template-hooks.php [edit]
[-] class-woo-vou-model.php [edit]
[+] meta-boxes
[+] fonts
[-] class-woo-vou-pagination-public.php [edit]
[-] class-woo-vou-scripts.php [edit]
[+] updater
[-] class-woo-vou-renderer.php [edit]
[-] wpweb-upd-functions.php [edit]
[-] class-woo-vou-public.php [edit]
[+] compatibility
[+] admin