ZZCS/coding/st-xm/Api/add_order_status_log.php

<?php
/*
 Author:XM
 Compeny:Spiders Travel
 */
require_once '../Common/Mysql.php';
$pdo=conn();
$order_id = isset($_POST["order_id"]) ? $_POST["order_id"] : false;
$order_status = isset($_POST["order_status"]) ? $_POST["order_status"] : false;

if( $order_id == false || $order_status == false ) {
	echo "insert failed";
	exit();
}

$order_id_array = explode(",", $order_id);
$order_status_array = explode(",", $order_status);

$current_time = date("Y-m-d H:i:s");

foreach( $order_id_array as $order_id_token ) {
	//add by qius on 20170531 for main coporation
	$pdo1 = conn();
	$sql_order = " SELECT SALE_PATH FROM order_main where order_id = {$order_id_token}";
	$result=$pdo1->query($sql_order);
	$add_order_array = array($order_id_token);
	if( $result != false ) {
		$result_array = $result->fetchAll();
		$result->closeCursor();
		if( $result_array != false && count($result_array) > 0 ) {
			$add_order_array = strlen($result_array[0]["SALE_PATH"]) > 0 ? explode(",", $result_array[0]["SALE_PATH"]) : array($order_id_token);
		}
	}

	foreach( $order_status_array as $order_status_token ) {
		foreach( $add_order_array as $add_order_id ) {
			$sql_log = "insert into order_status_log(order_id,new_status,change_time) VALUES ({$add_order_id},{$order_status_token},'{$current_time}') ON DUPLICATE KEY UPDATE change_time='{$current_time}' ";
			$pdo->exec($sql_log);
		}
	}
}

echo "insert success";
exit();