

===============================================================================
User: 1  |  Time: 11:33:37  |  URL: /customers/apple_clinic/SettingsAjax/submitUser

Array
(
    [0] => 23000
    [1] => 1062
    [2] => Duplicate entry 'abbass' for key 'User_Name'
)

update tbl_common_users set User_Name = ?,                                                                 Role_ID = ?,                                                                 control_role_id = ?,                                                                 landing_id = ?,                                                                 Employee_ID = ?,                                                                 is_app = ? ,                                                                 is_admin =?,                                                                 limited_access =?,                                                                 User_Full_Name =?,                                                                 user_email =?,                                                                 user_mobile_phone =?,login_at=?,login_device = ?,json_data=?,stop_multi_login=?,u_user_shifts_id=?,limit_customer_invoice=?,                                                                 is_actual = ?                                                                 where User_ID = ?
Array
(
    [0] => abbass
    [1] => 6
    [2] => 
    [3] => 1
    [4] => 
    [5] => 0
    [6] => 0
    [7] => 0
    [8] => Abbass
    [9] => 
    [10] => 
    [11] => 0
    [12] => 1
    [13] => 
    [14] => 0
    [15] => 
    [16] => 0
    [17] => 0
    [18] => 18
)


===============================================================================
User: 1  |  Time: 11:36:08  |  URL: /customers/apple_clinic/SettingsAjax/deleteUser?user_id=18&_=1741339989234

Array
(
    [0] => 23000
    [1] => 1451
    [2] => Cannot delete or update a parent row: a foreign key constraint fails (`trusrpca_apple_clinic_system_new`.`tbl_accounting_transactions`, CONSTRAINT `fk_tblAccountingTransac_createdLoggedID_to_tblCommonUsers_UserID` FOREIGN KEY (`created_logged_id`) REFERENCES `tbl_common_users` (`User_ID`) ON UPDATE CASCADE)
)

Delete from tbl_common_users WHERE User_ID = ?
Array
(
    [0] => 18
)


===============================================================================
User: 1  |  Time: 11:36:18  |  URL: /customers/apple_clinic/SettingsAjax/deleteUser?user_id=18&_=1741339989236

Array
(
    [0] => 23000
    [1] => 1451
    [2] => Cannot delete or update a parent row: a foreign key constraint fails (`trusrpca_apple_clinic_system_new`.`tbl_accounting_transactions`, CONSTRAINT `fk_tblAccountingTransac_createdLoggedID_to_tblCommonUsers_UserID` FOREIGN KEY (`created_logged_id`) REFERENCES `tbl_common_users` (`User_ID`) ON UPDATE CASCADE)
)

Delete from tbl_common_users WHERE User_ID = ?
Array
(
    [0] => 18
)


===============================================================================
User: 17  |  Time: 13:33:37  |  URL: /customers/apple_clinic/InventoryAjax/submitCustomer

Array
(
    [0] => 23000
    [1] => 1062
    [2] => Duplicate entry 'youness khalil--' 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] => youness khalil
    [1] => 
    [2] => 
    [3] => 71763562
    [4] => 
    [5] => 71763562
    [6] => 
    [7] => 120
    [8] => 4198
    [9] => 
    [10] => 
    [11] => 
    [12] => 144
    [13] => 
    [14] => 1
    [15] => 
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 17
    [21] => abbass
    [22] => 44209a6a592dea91bcf7d4dd53e47a5a
    [23] => 
    [24] => 
    [25] => 
    [26] => 
    [27] => 0
    [28] => 
    [29] => 
    [30] => 
    [31] => 
    [32] => 
    [33] => 
    [34] => 
    [35] => 
    [36] => 
    [37] => 1
)


===============================================================================
User: 17  |  Time: 16:31:27  |  URL: /customers/apple_clinic/InventoryAjax/submitCustomer

Array
(
    [0] => 23000
    [1] => 1062
    [2] => Duplicate entry 'amin al khatib--' 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] => amin al khatib
    [1] => 
    [2] => 
    [3] => 03736696
    [4] => 
    [5] => 03736696
    [6] => 
    [7] => 120
    [8] => 4198
    [9] => 
    [10] => 
    [11] => 
    [12] => 144
    [13] => 
    [14] => 1
    [15] => 
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 17
    [21] => abbass
    [22] => 44209a6a592dea91bcf7d4dd53e47a5a
    [23] => 
    [24] => 
    [25] => 
    [26] => 
    [27] => 0
    [28] => 
    [29] => 
    [30] => 
    [31] => 
    [32] => 
    [33] => 
    [34] => 
    [35] => 
    [36] => 
    [37] => 1
)
