<?php
//error_reporting(E_ALL);
//ini_set('display_errors', 1);
//include wp libriries and set timezone to HK
require_once('wp-load.php'); 
require_once('PHPExcel.php');
date_default_timezone_set("Asia/Hong_Kong"); 
global $wpdb;
$path = "/var/www/html/ossfs/amber/awb_excel/";

function get_cost_amount($arr_data, $orderID){	
	$cost_amount = 0;
	$orderNoIdx = array_search("相册内容", $arr_data[0]);
	$costAmountIdx = array_search("总价", $arr_data[0]);
	 	
	for($r=1; $r<count($arr_data); $r++){	
		$orderNo = $arr_data[$r][$orderNoIdx];		
		$arrOrderNo = explode("-", $orderNo);								
		$orderIDs = trim(preg_replace('/[^0-9]/', '', $arrOrderNo[0]));	
		if($orderIDs==$orderID){
			$cost_amount += $arr_data[$r][$costAmountIdx];	
		}
	}	
	
	return $cost_amount;	
}

if ($_FILES["excelFile"]["name"] <> ""){
	
	$filename=time()."_".$_FILES["excelFile"]["name"];
	$filepath = $path.$filename;
	if(move_uploaded_file($_FILES["excelFile"]["tmp_name"], $path.$filename)){
		$arr_result['condition'] = 'success';
		$arr_result['message'] = 'upload success';
		
		if(file_exists($filepath)){	
			$arr_data = array(array());
			$xlsObj = PHPExcel_IOFactory::load($filepath);
			$wsObj = $xlsObj->getActiveSheet();	
			
			$maxColIdx = $wsObj->getHighestColumn();
			$maxColNo = PHPExcel_Cell::columnIndexFromString($maxColIdx);
			$maxCol = $maxColNo-1;
			
 			foreach($wsObj->getRowIterator() as $row) {
				 $xlsRow = $row->getRowIndex();
				 if(trim($wsObj->getCellByColumnAndRow(0, $xlsRow)->getFormattedValue())!=""){
					  for($col=0;$col<=$maxCol;$col++){
						$arr_data[$xlsRow][] = trim($wsObj->getCellByColumnAndRow($col, $xlsRow)->getFormattedValue()); 
					  }
				 } 
			}
					
			 array_shift($arr_data); // remove first empty row
			 
			 if(count($arr_data)>0){
				 
				 $trackNoIdx = array_search("快递货运编号", $arr_data[0]);
				 $orderNoIdx = array_search("相册内容", $arr_data[0]);
				 $delDateIdx = array_search("安排时间", $arr_data[0]);
				 $costAmountIdx = array_search("总价", $arr_data[0]);
				 
				 if($trackNoIdx!=false){
					 if($orderNoIdx!==false){
					 	if($delDateIdx!==false){	
							if($costAmountIdx!==false){
								for($dataRow=1; $dataRow<count($arr_data); $dataRow++){
									$trackNo = $arr_data[$dataRow][$trackNoIdx];
									$orderNo = $arr_data[$dataRow][$orderNoIdx];
									$delDate = $arr_data[$dataRow][$delDateIdx];								
									$delDate = date("Y-m-d H:i:s", strtotime($delDate));
									$arrOrderNo = explode("-", $orderNo);								
									$orderID = trim(preg_replace('/[^0-9]/', '', $arrOrderNo[0]));
									
									$exist = false;
									$order = wc_get_order($orderID);
									
									if($order==false){									
										;
									} else {
																
										$shipping_hash = get_post_meta($orderID, '_wc_shipment_tracking_items', true ); // get plugin value;	
										if($shipping_hash!=""){								
											foreach($shipping_hash as $shipping_idx=>$shipping_arr){ // check trackNo is existing in plugin value									
												if(trim($shipping_arr['tracking_number'])==$trackNo){												
													$exits = true;	
												}
											}					
										}else{
											$shipping_hash = array();
										}
										
										if($exist){ // if exist, do nothing
											;
										} else {
											
											if(substr($trackNo, 0, 2)=="SF"){									
												$array_ship_line = array(									
													"tracking_provider" => "sf-express",
													"custom_tracking_provider" => "",
													"custom_tracking_link" => "",
													"tracking_number" => $trackNo,
													"tracking_product_code" => "",
													"date_shipped" => strtotime($delDate),
													"products_list" => "",
													"status_shipped" => "1",
													"tracking_id" => md5($orderID),
												);
											} else {
												$arr_tackNo = explode("-",$trackNo);										
												$array_ship_line = array(									
													"tracking_provider" => $arr_tackNo[0],
													"custom_tracking_provider" => "",
													"custom_tracking_link" => "",
													"tracking_number" => $arr_tackNo[1],
													"tracking_product_code" => "",
													"date_shipped" => strtotime($delDate),
													"products_list" => "",
													"status_shipped" => "1",
													"tracking_id" => md5($orderID),
												);										
												
											}										
											
											array_push($shipping_hash, $array_ship_line);
											$shipping_hash = array_map("unserialize", array_unique(array_map("serialize", $shipping_hash)));
											
											update_post_meta($orderID, '_wc_shipment_tracking_items', $shipping_hash);
											$cost_amount = get_cost_amount($arr_data, $orderID);
											if($cost_amount>0){
												update_post_meta($orderID, 'Cost1_currency', 'RMB');
												update_post_meta($orderID, 'Cost1_amount', $cost_amount);
											}											
											
											if(in_array($order->get_status(), array("processing","on-hold","pending"))){
												$order->update_status('completed');
											}
											
											
										}	
									} // end check order object
								}
								$arr_result['condition'] = 'success';
								$arr_result['message'] = 'import success';	
							}else{
								$arr_result['condition'] = 'fail';
								$arr_result['message'] = 'missing 总价 column';									
							}
						}else{
							$arr_result['condition'] = 'fail';
							$arr_result['message'] = 'missing 相册内容 column';									
						}					 
					 } else {
						$arr_result['condition'] = 'fail';
						$arr_result['message'] = 'missing 安排时间 column';						 
					 }
				 } else {
					$arr_result['condition'] = 'fail';
					$arr_result['message'] = 'missing 快递货运编号 column';
				 }
			 } else {
				$arr_result['condition'] = 'fail';
				$arr_result['message'] = 'file content is empty';	
			 }
		} else {
			$arr_result['condition'] = 'fail';
			$arr_result['message'] = 'uploaded file not found';			
		}
		
	} else {
		$arr_result['condition'] = 'fail';
		$arr_result['message'] = 'unable to upload file';
	}
}

echo json_encode($arr_result);
?>