<?
/**
 * Plugin Name:       Export Order
 * Plugin URI:        https://www.geomagworld.com/
 * Description:       Export Order
 * Version:           1.0.0
 * Requires at least: 5.2
 * Requires PHP:      7.2
 * Author:            Orangeid
 * Author URI:        https://www.geomagworld.com/
 * License:           GPL v2 or later
 * License URI:       https://www.gnu.org/licenses/gpl-2.0.html
 * Text Domain:       export-order
 * Domain Path:       /lang
 */

require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
 
function generateRandomString($length = 10) {
    $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
    $charactersLength = strlen($characters);
    $randomString = '';
    for ($i = 0; $i < $length; $i++) {
        $randomString .= $characters[rand(0, $charactersLength - 1)];
    }
    return $randomString;
}

function custom_orders_page_init() {
	add_menu_page('Export Order', 'Export Order', 'edit_posts','custom-view-export-orders' , 'custom_orders_page','',50);
    wp_enqueue_script( 'custom-view-orders-js1', 'https://code.jquery.com/ui/1.12.1/jquery-ui.js');
    wp_enqueue_script( 'custom-view-orders-js2', plugin_dir_url( __FILE__ ) .'/js/utility.js');
    wp_register_style('custom-view-orders-css', 'https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css');
    wp_enqueue_style('custom-view-orders-css');
}

add_action('admin_menu', 'custom_orders_page_init');

function custom_orders_page() {
    $filename="";
	if ((isset($_GET['action'])) || isset($_POST['action'])) {
        if (isset($_GET['action'])) {
            $action=$_GET['action'];
        }
        else {
            $action=$_POST['action'];
        }
        switch ($action) {
            case "filtra":
				
				$files = glob(get_home_path().'wp-content/plugins/export-order/temp/'.'*'); // get all file names
				foreach($files as $file){ // iterate files
				  	if(is_file($file)) {
				   	 	unlink($file); // delete file
				  	}
				}
				
                $filtri = array(
                    'post_type'         => 'shop_order',
                     'orderby'           => 'date',
                     'order'            => 'DESC',
                    //'post_status'       =>  array_keys( wc_get_order_statuses() ),
                    'posts_per_page'    => -1,
                );
                $date_query = array();
                //$stato_ord = 'wc-processing,wc-completed';
                $stato_ord = 'any';
                if (isset($_GET['action'])) {
                    if (isset($_POST['data_da']) && ($_POST['data_da']!="")){
                        $date_query['after']=$_POST['data_da'];
                    }
                    if (isset($_POST['data_a']) && ($_POST['data_a']!="")){
                        $date_query['before']=$_POST['data_a'];
                    }
                    if (isset($_POST['stato_ord']) && ($_POST['stato_ord']!="")){
                        $stato_ord="wc-".$_POST['stato_ord'];
                        $filtri['post_status']=$stato_ord;
                    }
                }
                $filtri['post_status']=$stato_ord;
                $date_query['inclusive']=true;
                $filtri['date_query']=array($date_query);
                $loop = new WP_Query( $filtri );
                
				$spreadsheet = new Spreadsheet();
    				$sheet = $spreadsheet->getActiveSheet();
						
				$sheet->setCellValue('A1', "Order number");
				$sheet->setCellValue('B1', "Order Date");
				$sheet->setCellValue('C1', "Email (Billing)");
				$sheet->setCellValue('D1', "Phone (Billing)");
				$sheet->setCellValue('E1', "Recipient Name");
				$sheet->setCellValue('F1', "Additional recipient information");
				$sheet->setCellValue('G1', "Recipient Address");
				$sheet->setCellValue('H1', "Additional address information");
				$sheet->setCellValue('I1', "Recipient City");
				$sheet->setCellValue('J1', "Recipient Province");
				$sheet->setCellValue('K1', "Recipient PostCode");
				$sheet->setCellValue('L1', "Recipient Country Code");
				$sheet->setCellValue('M1', "COD Payment Method");
				$sheet->setCellValue('N1', "COD Value");
				$sheet->setCellValue('O1', "SKU");
				$sheet->setCellValue('P1', "code_product");
				$sheet->setCellValue('Q1', "name_product");
				$sheet->setCellValue('R1', "Quantity");
				$sheet->setCellValue('S1', "Price");
				$sheet->setCellValue('T1', "SMM");
				$i=2;
                // The Wordpress post loop
                if ( $loop->have_posts() ): 
                    while ( $loop->have_posts() ) : $loop->the_post();
                        // The order ID
                    		$id=$loop->post->ID;
                    		//if ($id!=45906) {
		                		$order = wc_get_order($id);
							$data = $order->get_date_created()->date("d/m/Y G:i");
							$billing_email  = $order->get_billing_email();
							$billing_phone  = $order->get_billing_phone();
							$cliente = $order->get_shipping_first_name(). " ".$order->get_shipping_last_name();
							$shipping_address_1  = $order->get_shipping_address_1();
							$shipping_address_2  = $order->get_shipping_address_2();
							$shipping_city       = $order->get_shipping_city();
							$shipping_state      = $order->get_shipping_state();
							$shipping_postcode   = $order->get_shipping_postcode();
							$shipping_country    = $order->get_shipping_country();
							$pay_method = $order->get_payment_method();
							$totale = $order->get_total();
							
							foreach ( $order->get_items() as $item_id => $item ) {
								$product = $item->get_product();	
								$id_prod = $item['product_id'];
								if (($id_prod==39381) || ($id_prod==39380) || ($id_prod==39382) || ($id_prod==39379)) {
									$smm="Additional recipient information";
								}
								else {
									$smm="";
								}
								if ($id_prod!=0) {
									$sku = $product->get_sku();
								}
								else {
									$sku = "";
								}
								$sku = str_replace("-B", "", $sku);
								$name_prod = $item['name'];
								$quantity = $item->get_quantity();
								$subtotal = $item->get_subtotal();
   								$total = $item->get_total();
								$sheet->setCellValue('A'.$i, $id);
								$sheet->setCellValue('B'.$i, $data);
								$sheet->setCellValue('C'.$i, $billing_email);
								$sheet->setCellValue('D'.$i, $billing_phone);
								$sheet->setCellValue('E'.$i, $cliente);
								$sheet->setCellValue('F'.$i, "");
								$sheet->setCellValue('G'.$i, $shipping_address_1);
								$sheet->setCellValue('H'.$i, "");
								$sheet->setCellValue('I'.$i, $shipping_city);
								$sheet->setCellValue('J'.$i, $shipping_state);
								$sheet->setCellValue('K'.$i, $shipping_postcode);
								$sheet->setCellValue('L'.$i, $shipping_country);
								$sheet->setCellValue('M'.$i, $pay_method);
								$sheet->setCellValue('N'.$i, $totale);
								$sheet->setCellValue('O'.$i, $sku);
								$sheet->setCellValue('P'.$i, $sku);
								$sheet->setCellValue('Q'.$i, $name_prod);
								$sheet->setCellValue('R'.$i, $quantity);
								$sheet->setCellValue('S'.$i, $total);
								$sheet->setCellValue('T'.$i, $smm);
								$i++;
							}
						//}
                    endwhile;
                    
                    wp_reset_postdata();
                
                endif;
				$writer = new Xlsx($spreadsheet);
				$writer->setPreCalculateFormulas(false);
				$nome_file_xls = 'Export order '.date("Y-m-d H:i:s").'.xlsx';
				$filename=get_home_path().'wp-content/plugins/export-order/temp/'.$nome_file_xls;
				$writer->save($filename); 
            break;
        }
    }
	include('template/custom-view-orders.php');
	return;
}