Export Products as columns

// Export Products as columns
// Format - XLS
// Checked - Output column titles as first line
// Button - Export w/o Progressbar
class Woe_Product_Columns {
    function __construct() {
        //add settings, , skip products        
        add_action("woe_settings_above_buttons", array($this,"draw_options") );
        add_filter("woe_settings_validate_defaults",array($this,"skip_products"),10,1);
    }

    // 1
    function draw_options($settings){
        $selected = !empty($settings[ 'products_as_columns' ]) ? 'checked': '';
        echo '<br><br>
        <input type=hidden name="settings[products_as_columns]" value="0">
        <input type=checkbox name="settings[products_as_columns]" value="1" '. $selected .'>
        <span class="wc-oe-header">Export products as columns,  print <select name="settings[products_as_columns_output_field]" style="width: 100px">
			<option value="qty">Qty</option>
			<option value="line_total">Amount</option>
        </select>
         in cell</span><br>
         Format <b>XLS</b>, button <b>Export w/o progressbar</b>
        <br><br>';
    }

    function skip_products($current_job_settings) {
        if( !empty($current_job_settings['products_as_columns']) )  {
             $current_job_settings["order_fields"]["products"]["checked"] = 0;//  just  skip standard products
             $this->output_field = $current_job_settings['products_as_columns_output_field'];
             // read orders
             add_action("woe_order_export_started",array($this,"start_new_order"),10,1);

             //stop default output for rows
             add_action("woe_xls_header_filter",array($this,"prepare_xls_vars"),10,2);
             add_action("woe_xls_output_filter",array($this,"record_xls_rows"),10,2);
             add_action("woe_xls_print_footer",array($this,"analyze_products_add_columns"),10,2);
        }
        return $current_job_settings;
    }   

    // 2
    function prepare_xls_vars($data) {
	$this->headers_added = count($data);
        $this->product_columns = array();
        return $data;
    }

    //3
    function start_new_order($order_id) {
        $this->order_id = $order_id;
        return $order_id;
    }
    function record_xls_rows($data,$obj) {
        $order = new WC_Order($this->order_id);
        $extra_cells = array_fill(0, count($this->product_columns), "");
        // work with products
        foreach($order->get_items('line_item') as $item_id=>$item) {
            $product_name = $item['name'];   
            $pos = array_search($product_name,$this->product_columns);
            if( $pos === false) { // new product detected
                $extra_cells[] = $item[ $this->output_field  ]; 
                $this->product_columns[] = $product_name;
            } else {
                $extra_cells[$pos] = $item[ $this->output_field  ]; 
            }
        }
        foreach($extra_cells as $pc)
            $data[] = $pc;
        return $data;
    }

    //4 
    function analyze_products_add_columns($phpExcel,$formatter) {
        // add products as titles
        foreach($this->product_columns as $pos=>$text)
            $formatter->objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow( $pos+$this->headers_added, 1, $text );
        //make first bold
        $last_column = $formatter->objPHPExcel->getActiveSheet()->getHighestDataColumn();
        $formatter->objPHPExcel->getActiveSheet()->getStyle( "A1:" . $last_column . "1" )->getFont()->setBold( true );
    }
}
new Woe_Product_Columns();

// Export Products as columns

// Format - XLS

// Checked - Output column titles as first line

// Button - Export w/o Progressbar

class Woe_Product_Columns {

function __construct() {

//add settings, , skip products

add_action("woe_settings_above_buttons", array($this,"draw_options") );

add_filter("woe_settings_validate_defaults",array($this,"skip_products"),10,1);

}

// 1

function draw_options($settings){

$selected = !empty($settings[ 'products_as_columns' ]) ? 'checked': '';

echo '<br><br>

<span class="wc-oe-header">Export products as columns, print <select name="settings[products_as_columns_output_field]" style="width: 100px">

<option value="line_total">Amount</option>

</select>

in cell</span><br>

Format <b>XLS</b>, button <b>Export w/o progressbar</b>

<br><br>';

}

function skip_products($current_job_settings) {

if( !empty($current_job_settings['products_as_columns']) ) {

$current_job_settings["order_fields"]["products"]["checked"] = 0;// just skip standard products

$this->output_field = $current_job_settings['products_as_columns_output_field'];

// read orders

add_action("woe_order_export_started",array($this,"start_new_order"),10,1);

//stop default output for rows

add_action("woe_xls_header_filter",array($this,"prepare_xls_vars"),10,2);

add_action("woe_xls_output_filter",array($this,"record_xls_rows"),10,2);

add_action("woe_xls_print_footer",array($this,"analyze_products_add_columns"),10,2);

}

return $current_job_settings;

}

// 2

function prepare_xls_vars($data) {

$this->headers_added = count($data);

$this->product_columns = array();

return $data;

}

//3

function start_new_order($order_id) {

$this->order_id = $order_id;

return $order_id;

}

function record_xls_rows($data,$obj) {

$order = new WC_Order($this->order_id);

$extra_cells = array_fill(0, count($this->product_columns), "");

// work with products

foreach($order->get_items('line_item') as $item_id=>$item) {

$product_name = $item['name'];

$pos = array_search($product_name,$this->product_columns);

if( $pos === false) { // new product detected

$extra_cells[] = $item[ $this->output_field ];

$this->product_columns[] = $product_name;

} else {

$extra_cells[$pos] = $item[ $this->output_field ];

}

foreach($extra_cells as $pc)

$data[] = $pc;

return $data;

}

//4

function analyze_products_add_columns($phpExcel,$formatter) {

// add products as titles

foreach($this->product_columns as $pos=>$text)

$formatter->objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow( $pos+$this->headers_added, 1, $text );

//make first bold

$last_column = $formatter->objPHPExcel->getActiveSheet()->getHighestDataColumn();

$formatter->objPHPExcel->getActiveSheet()->getStyle( "A1:" . $last_column . "1" )->getFont()->setBold( true );

}

new Woe_Product_Columns();

// Pro version, send separate CSV to each seller
class Woe_Seller_CSV_mod {
	function __construct() {
		add_action("woe_test_destination", array($this,"add_hooks") );
		add_action("woe_start_cron_job_1", array($this,"add_hooks") ); // adjust job ID here 
	}
	
	function add_hooks () {
		add_action("woe_formatter_csv_start", array($this,"csv_start"),10,1);
		add_action("woe_order_export_started",array($this,"start_new_order"),10,1);
		add_action("woe_get_order_product",array($this,"detect_seller"),10,1);
		add_action("woe_formatter_set_handler_for_csv_row",array($this,"switch_file"),10,1);
		add_action("woe_formatter_csv_finished",array($this,"close_csv_files"),10,1);
		add_action("woe_custom_export_to_email",array($this,"send_csv_files"),10,4);
	}

	function csv_start($header) {
		$this->header = $header;
		$this->filenames = $this->files = array();
	}

	function start_new_order($order_id) {
		//remember sellers is for rows here 
		$this->product_sellers = array();
		$this->product_sellers_pos = 0;
                return $order_id;
	}

	function detect_seller($product) {
		$seller_id = $product->post->post_author;
		
		// remember seller  sequence for rows
		$this->product_sellers[] = $seller_id; 
		
		//put header to new file
		if( !isset($this->files[$seller_id]) ) {
			$this->filenames[$seller_id] = tempnam("/tmp",$seller_id);
			$this->files[$seller_id] = fopen( $this->filenames[$seller_id], "wb+");
			fputcsv($this->files[$seller_id], $this->header);
		}
	}

	function switch_file($handle) {
		$seller_id = $this->product_sellers[$this->product_sellers_pos++];
		return $this->files[$seller_id];
	}
	
	function close_csv_files() {
		foreach($this->files as $f)
			if(get_resource_type($f) == 'stream')
				fclose($f);
	}
	
	function send_csv_files($processed, $filename, $filepath, $exporter) {
		global $ts_mail_errors;
		
		foreach($this->filenames as $seller_id => $filepath) { // override filepath
			$user_info = get_userdata($seller_id);
			if( !empty($user_info->user_email) ) {
				$exporter->destination['email_recipients'] = $user_info->user_email;//override email
				$ts_mail_errors = array();
				echo $exporter->run_export( $filename, $filepath )."\n";
			}	
		}
		return true;
	}
}
new Woe_Seller_CSV_mod();

// Pro version, send separate CSV to each seller

class Woe_Seller_CSV_mod {

function __construct() {

add_action("woe_test_destination", array($this,"add_hooks") );

add_action("woe_start_cron_job_1", array($this,"add_hooks") ); // adjust job ID here

}

function add_hooks () {

add_action("woe_formatter_csv_start", array($this,"csv_start"),10,1);

add_action("woe_order_export_started",array($this,"start_new_order"),10,1);

add_action("woe_get_order_product",array($this,"detect_seller"),10,1);

add_action("woe_formatter_set_handler_for_csv_row",array($this,"switch_file"),10,1);

add_action("woe_formatter_csv_finished",array($this,"close_csv_files"),10,1);

add_action("woe_custom_export_to_email",array($this,"send_csv_files"),10,4);

}

function csv_start($header) {

$this->header = $header;

$this->filenames = $this->files = array();

}

function start_new_order($order_id) {

//remember sellers is for rows here

$this->product_sellers = array();

$this->product_sellers_pos = 0;

return $order_id;

}

function detect_seller($product) {

$seller_id = $product->post->post_author;

// remember seller sequence for rows

$this->product_sellers[] = $seller_id;

//put header to new file

if( !isset($this->files[$seller_id]) ) {

$this->filenames[$seller_id] = tempnam("/tmp",$seller_id);

$this->files[$seller_id] = fopen( $this->filenames[$seller_id], "wb+");

fputcsv($this->files[$seller_id], $this->header);

}

function switch_file($handle) {

$seller_id = $this->product_sellers[$this->product_sellers_pos++];

return $this->files[$seller_id];

}

function close_csv_files() {

foreach($this->files as $f)

if(get_resource_type($f) == 'stream')

fclose($f);

}

function send_csv_files($processed, $filename, $filepath, $exporter) {

global $ts_mail_errors;

foreach($this->filenames as $seller_id => $filepath) { // override filepath

$user_info = get_userdata($seller_id);

if( !empty($user_info->user_email) ) {

$exporter->destination['email_recipients'] = $user_info->user_email;//override email

$ts_mail_errors = array();

echo $exporter->run_export( $filename, $filepath )."\n";

}

return true;

}

new Woe_Seller_CSV_mod();

Advanced Order Export for WooCommerce

Export Products as columns