

===============================================================================
User: 12  |  Time: 15:49:27  |  URL: /customers/apple_clinic/StockAjax/importProducts

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
                        SELECT tmp_pro_code, tmp_pro_name, tmp_cat_id, if(...' at line 2
)

INSERT INTO `tbl_stock_products` (`Product_Code`, `Product_Name`, `Category_ID`, `printer_id`,`branch_id`, `brand_id`, `Currency_ID`, `Product_Quantity`, `Product_Cost`                             , `UOM_ID`, `default_view_uom_id`, `default_view_rate` , `Product_VAT`, `vat_percent`, `Product_Limit_Discount`, `Status_ID`, `Logged_ID`, `Product_PLU`, `PLU_Type`, `Product_Arabic_Name`,)                         SELECT tmp_pro_code, tmp_pro_name, tmp_cat_id, if(tmp_printer_id= '',null,tmp_printer_id), if(tmp_branch_id= '',null,tmp_branch_id), tmp_brand_id, '144', 0, tmp_def_uom_pro_cost                             , tmp_uom_id_1, tmp_uom_id_1, 1, if(tmp_vat_per > 0, 1, 0), tmp_vat_per, '0', 1, '12', if(tmp_uom_barcode_1 <> '', tmp_uom_barcode_1, tmp_pro_code), 'N', ''                         from `tmp_product_import_1704721765.51437147110267714.55369` where tmp_is_error <> '1' and isNULL(tmp_pro_exist_id) 


===============================================================================
User: 12  |  Time: 15:52:37  |  URL: /customers/apple_clinic/StockAjax/importProducts

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
                        SELECT tmp_pro_code, tmp_pro_name, tmp_cat_id, if(...' at line 2
)

INSERT INTO `tbl_stock_products` (`Product_Code`, `Product_Name`, `Category_ID`, `printer_id`,`branch_id`, `brand_id`, `Currency_ID`, `Product_Quantity`, `Product_Cost`                             , `UOM_ID`, `default_view_uom_id`, `default_view_rate` , `Product_VAT`, `vat_percent`, `Product_Limit_Discount`, `Status_ID`, `Logged_ID`, `Product_PLU`, `PLU_Type`, `Product_Arabic_Name`,)                         SELECT tmp_pro_code, tmp_pro_name, tmp_cat_id, if(tmp_printer_id= '',null,tmp_printer_id), if(tmp_branch_id= '',null,tmp_branch_id), tmp_brand_id, '144', 0, tmp_def_uom_pro_cost                             , tmp_uom_id_1, tmp_uom_id_1, 1, if(tmp_vat_per > 0, 1, 0), tmp_vat_per, '0', 1, '12', if(tmp_uom_barcode_1 <> '', tmp_uom_barcode_1, tmp_pro_code), 'N', ''                         from `tmp_product_import_1704721955.7449281.497501755279449` where tmp_is_error <> '1' and isNULL(tmp_pro_exist_id) 


===============================================================================
User: 12  |  Time: 15:53:09  |  URL: /customers/apple_clinic/StockAjax/importProducts

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
                        SELECT tmp_pro_code, tmp_pro_name, tmp_cat_id, if(...' at line 2
)

INSERT INTO `tbl_stock_products` (`Product_Code`, `Product_Name`, `Category_ID`, `printer_id`,`branch_id`, `brand_id`, `Currency_ID`, `Product_Quantity`, `Product_Cost`                             , `UOM_ID`, `default_view_uom_id`, `default_view_rate` , `Product_VAT`, `vat_percent`, `Product_Limit_Discount`, `Status_ID`, `Logged_ID`, `Product_PLU`, `PLU_Type`, `Product_Arabic_Name`,)                         SELECT tmp_pro_code, tmp_pro_name, tmp_cat_id, if(tmp_printer_id= '',null,tmp_printer_id), if(tmp_branch_id= '',null,tmp_branch_id), tmp_brand_id, '144', 0, tmp_def_uom_pro_cost                             , tmp_uom_id_1, tmp_uom_id_1, 1, if(tmp_vat_per > 0, 1, 0), tmp_vat_per, '0', 1, '12', if(tmp_uom_barcode_1 <> '', tmp_uom_barcode_1, tmp_pro_code), 'N', ''                         from `tmp_product_import_1704721986.50987651168782996.04970` where tmp_is_error <> '1' and isNULL(tmp_pro_exist_id) 


===============================================================================
User: 12  |  Time: 15:59:09  |  URL: /customers/apple_clinic/StockAjax/importProducts

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
                        SELECT tmp_pro_code, tmp_pro_name, tmp_cat_id, if(...' at line 2
)

INSERT INTO `tbl_stock_products` (`Product_Code`, `Product_Name`, `Category_ID`, `printer_id`,`branch_id`, `brand_id`, `Currency_ID`, `Product_Quantity`, `Product_Cost`                             , `UOM_ID`, `default_view_uom_id`, `default_view_rate` , `Product_VAT`, `vat_percent`, `Product_Limit_Discount`, `Status_ID`, `Logged_ID`, `Product_PLU`, `PLU_Type`, `Product_Arabic_Name`,)                         SELECT tmp_pro_code, tmp_pro_name, tmp_cat_id, if(tmp_printer_id= '',null,tmp_printer_id), if(tmp_branch_id= '',null,tmp_branch_id), tmp_brand_id, '144', 0, tmp_def_uom_pro_cost                             , tmp_uom_id_1, tmp_uom_id_1, 1, if(tmp_vat_per > 0, 1, 0), tmp_vat_per, '0', 1, '12', if(tmp_uom_barcode_1 <> '', tmp_uom_barcode_1, tmp_pro_code), 'N', ''                         from `tmp_product_import_1704722347.7703444707637.621247073` where tmp_is_error <> '1' and isNULL(tmp_pro_exist_id) 


===============================================================================
User: 12  |  Time: 18:14:25  |  URL: /customers/apple_clinic/InventoryAjax/submitCustomer

Array
(
    [0] => 23000
    [1] => 1062
    [2] => Duplicate entry 'mohammad abdalla --' for key 'Customer_Name'
)

INSERT                                      INTO                                          tbl_customers                                      (                                         Customer_Name,                                         Customer_Code,                                         Customer_Email,                                         Customer_Phone,                                         Customer_Work_Phone,                                         Customer_Mobile,                                         Customer_Company,                                         Customer_Country_ID,                                         Customer_City_ID,                                         Customer_Address,                                         Customer_Limit_Balance,                                         Customer_Discount,                                         Currency_ID,                                         Customer_CR,                                         Class_ID,                                         Customer_Lat,                                         Customer_Lng,                                         customer_due_date_period,                                         account_parent_id,                                         stop_invoice,                                         Logged_ID,                                         user_name,                                         password,                                         allergy_id,                                         intolerance_id,web_api_user_id,app_id,type,                                         customer_group_id,customer_class_id,region_id,customer_note,other_pay_acc_id,customer_vat,customer_additional_number,customer_postal_code,customer_other_id ,branch_id                                     )                                         VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Array
(
    [0] => mohammad abdalla 
    [1] => 
    [2] => 
    [3] => 71559664
    [4] => 
    [5] => 71559664
    [6] => 
    [7] => 120
    [8] => 4198
    [9] => 
    [10] => 
    [11] => 
    [12] => 144
    [13] => 
    [14] => 1
    [15] => 
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 12
    [21] => 
    [22] => 6c991fe85d9fcaea917f71fbdc9e384e
    [23] => 
    [24] => 
    [25] => 
    [26] => 
    [27] => 0
    [28] => 
    [29] => 
    [30] => 
    [31] => 
    [32] => 
    [33] => 
    [34] => 
    [35] => 
    [36] => 
    [37] => 1
)


===============================================================================
User: 12  |  Time: 18:14:49  |  URL: /customers/apple_clinic/InventoryAjax/submitCustomer

Array
(
    [0] => 23000
    [1] => 1062
    [2] => Duplicate entry 'mohammad abdalla --' for key 'Customer_Name'
)

INSERT                                      INTO                                          tbl_customers                                      (                                         Customer_Name,                                         Customer_Code,                                         Customer_Email,                                         Customer_Phone,                                         Customer_Work_Phone,                                         Customer_Mobile,                                         Customer_Company,                                         Customer_Country_ID,                                         Customer_City_ID,                                         Customer_Address,                                         Customer_Limit_Balance,                                         Customer_Discount,                                         Currency_ID,                                         Customer_CR,                                         Class_ID,                                         Customer_Lat,                                         Customer_Lng,                                         customer_due_date_period,                                         account_parent_id,                                         stop_invoice,                                         Logged_ID,                                         user_name,                                         password,                                         allergy_id,                                         intolerance_id,web_api_user_id,app_id,type,                                         customer_group_id,customer_class_id,region_id,customer_note,other_pay_acc_id,customer_vat,customer_additional_number,customer_postal_code,customer_other_id ,branch_id                                     )                                         VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Array
(
    [0] => mohammad abdalla 
    [1] => 
    [2] => 
    [3] => 71559664
    [4] => 
    [5] => 71559664
    [6] => 
    [7] => 120
    [8] => 4198
    [9] => 
    [10] => 
    [11] => 
    [12] => 144
    [13] => 
    [14] => 1
    [15] => 
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 12
    [21] => 
    [22] => 6c991fe85d9fcaea917f71fbdc9e384e
    [23] => 
    [24] => 
    [25] => 
    [26] => 
    [27] => 0
    [28] => 
    [29] => 
    [30] => 
    [31] => 
    [32] => 
    [33] => 
    [34] => 
    [35] => 
    [36] => 
    [37] => 1
)
