# ----------------------------------------------------------------------
*/
$_get = new ORDER_GET();
$_update = new ORDER_UPDATE();
$product_list = $_get->get_add_product(0);
$product_list_reset = $_get->get_add_product(0);
$user_email = $_get->get_user_by_email();
$prefix = cleanurl($_global_general->website_title);
$doku_channel = $_global->get_doku_channel();
/* --- MODAL: ADD PRODUCT --- */
/* --- END: MODAL --- */
/* --- ADD PRODUCT --- */
if (isset($_POST['btn-add-product']) && $_POST['btn-add-product'] == 'Add Product') {
/* --- GENERATE VALUE --- */
$today = date('d-m-y');
$count_order = $_get->generateOrderNumber($order_date);
$_temp_order_number = strtoupper(substr($order_billing_first_name, 0, 3));
$_temp_order_number = $_temp_order_number . date('dmy');
$_temp_order_number = $_temp_order_number . substr('000' . $count_order->rows, -3);
"INSERT INTO `tbl_order` (`order_number`, `order_billing_first_name`, `order_billing_last_name`, `order_billing_fullname`, `order_billing_email`, `order_billing_phone`, `order_billing_address`, `order_billing_country`, `order_billing_province`, `order_billing_city`, order_billing_postal_code, `order_shipping_first_name`, `order_shipping_last_name`, `order_shipping_email`, `order_shipping_phone`, `order_shipping_address`, `order_shipping_country`, `order_shipping_province`, `order_shipping_city`, order_shipping_postal_code, 1`order_billing_note`, shipping_method, order_gift_flag, `order_gift_message`, order_payment_type, order_payment_method, `order_status`, `payment_status`, `fulfillment_status`, currency, currency_rate\n ";
//???????????????????????????????
/* --- ORDER --- */
$order_number = $_temp_order_number;
$order_billing_first_name = filter_var($_POST['billing-fname'], FILTER_SANITIZE_STRING);
$order_billing_last_name = filter_var($_POST['billing-lname'], FILTER_SANITIZE_STRING);
$order_billing_fullname = $order_billing_first_name . ' ' . $order_billing_last_name;
$order_billing_email = filter_var($_POST['billing-email'], FILTER_SANITIZE_EMAIL);
$order_billing_phone = filter_var($_POST['billing-phone'], FILTER_SANITIZE_STRING);
$order_billing_address = filter_var($_POST['billing-address'], FILTER_SANITIZE_STRING);
$order_billing_country = filter_var($_POST['billing-country'], FILTER_SANITIZE_STRING);
$order_billing_province = filter_var($_POST['billing-province'], FILTER_SANITIZE_STRING);