

===============================================================================
User: 1  |  Time: 11:56:14  |  URL: /trusto_tech/apple_clinic/POSAjax/ajaxInvoice

Array
(
    [0] => 23000
    [1] => 1452
    [2] => Cannot add or update a child row: a foreign key constraint fails (`apple_clinic`.`tbl_invoice_products_details`, CONSTRAINT `FK_inv_to_det` FOREIGN KEY (`Invoice_ID_Auto`) REFERENCES `tbl_invoices` (`Invoice_ID_Auto`) ON DELETE CASCADE ON UPDATE CASCADE)
)

INSERT INTO tbl_invoice_products_details (                                                                         Invoice_ID_Auto,                                                                         Product_ID,                                                                         Product_Discount,                                                                          Product_Net_Price,                                                                         Product_Quantity,                                                                         Product_Total_Price,                                                                         unit_cost,                                                                         Item_Quantity_Current,                                                                         UOM_ID,                                                                         Discount_Amount,                                                                         vat_percent,                                                                         vat_amount,vat2_percent,vat2_amount,                                                                         Added_Amount,                                                                         expiry_date,reserve_from,reserve_to,                                                                         product_description,depot_id,total_tax,                                                                         lot_nb,serial_nb,date_created,hold                                                                         )                                                                      VALUES (                                                                         ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?                                                                         )                     
Array
(
    [0] => 0
    [1] => 1289
    [2] => 0
    [3] => 10
    [4] => 1
    [5] => 10
    [6] => 2
    [7] => 1
    [8] => 67
    [9] => 0
    [10] => 0
    [11] => 0
    [12] => 0
    [13] => 0
    [14] => 0
    [15] => 
    [16] => 
    [17] => 
    [18] => 
    [19] => 1
    [20] => 0
    [21] => 
    [22] => 
    [23] => 2023-12-07 11:56:14
    [24] => 0
)
