$storeCode = $resGetOperatorInfoArray['storeCode'];
$storeName = $resGetOperatorInfoArray['storeName'];
$deliverCharge = $resGetOperatorInfoArray['deliverCharge'];
$operatorType = $resGetOperatorInfoArray['operatorType'];
$operatorName = $resGetOperatorInfoArray['operatorName'];
$operatorMailAddress = $resGetOperatorInfoArray['operatorMailAddress'];
$operatorPhoneNumber = $resGetOperatorInfoArray['operatorPhoneNumber'];
$role = $resGetOperatorInfoArray['role'];
// 4. Publish New Order Id
// 発行方法について
$order_id = time();
// 5. Register Purchase Info By Order Unit
$regLastOrderInfo = "INSERT INTO regular_purchase_plan (`order_id`, `total_product_price`, `operator_id`, `store_code`, `deliver_address`, `deliver_charge_discount_flag`, `created_datetime`) VALUES ({$order_id}, {$total_price}, {$operator_id}, {$store_code}, '{$deliver_address}', {$deliver_charge_discount_flag}, NOW());";
$resRegLastOrderInfo = $dbConnectObj->executeSql($regLastOrderInfo);
if (!$resRegLastOrderInfo || $resRegLastOrderInfo == null) {
$dbConnectObj->rollback();
$dbConnectObj->close();
// redirect to error page
header('location: ./error.php?ecode=SE006');
exit;
}
// 6. Register Purchase History
foreach ($orderProductDateNumArray as $orderRecord) {
$purchase_number = $orderRecord['purchase_number'];
if ($purchase_number == 0) {
continue;
}
$product_id = $orderRecord['product_id'];
$deliver_date = date("Y-m-d", strtotime($orderRecord['deliver_date']));
$sqlRegPurchaseHistory = "INSERT INTO purchase_history (`order_id`, `store_code`, `operator_id`, `product_id`, `deliver_date`, `purchase_number`) VALUES ({$order_id}, {$store_code}, {$operator_id}, {$product_id}, '{$deliver_date}', {$purchase_number});";
$resRegPurchaseHistory = $dbConnectObj->executeSql($sqlRegPurchaseHistory);
