update_bank_fields.php000064400000001130150312724140011052 0ustar00sql_query("DELETE FROM `source_bank_fields_name` WHERE `bank_field_id` = '$bank_field_id'"); foreach ($field_names as $data){ $insert_data = $db->escape(strtoupper(trim($data))); $insert = "INSERT INTO `source_bank_fields_name`(`bank_field_id`, `name`) VALUES ('$bank_field_id','$insert_data')"; // echo $insert; return; $db->sql_query($insert); } ?>update_finance_pdc_fields.php000064400000001320150312724140012371 0ustar00sql_query($delete); foreach ($pdc_field_names AS $data){ $insert_data = $db->escape(strtoupper(trim($data))); $insert = "INSERT INTO `source_finance_pdc_fields_name`(`finance_field_pdc_id`, `name`) VALUES ('$finance_pdc_field_id','$insert_data')"; // echo $insert; return; $db->sql_query($insert); } ?>update_finance_fields.php000064400000001351150312724140011547 0ustar00sql_query("DELETE FROM `source_finance_fields_name` WHERE `finance_field_id` = '$finance_field_id'"); foreach ($field_names as $data){ $insert_data = $db->escape(strtoupper(trim($data))); $insert = "INSERT INTO `source_finance_fields_name`(`finance_field_id`, `name`) VALUES ('$finance_field_id','$insert_data')"; // echo $insert; return; $db->sql_query($insert); } ?>update_dms_fields_v2.php000064400000000766150312724140011347 0ustar00 sql_query("DELETE FROM `source_dms_fields_name_v2` WHERE `dms_field_id` = '$dms_field_id' "); foreach ($field_names as $data){ $insert_data = $db -> escape(strtoupper(trim($data))); $db -> sql_query("INSERT INTO `source_dms_fields_name_v2`(`dms_field_id`, `name`) VALUES ('$dms_field_id','$insert_data')"); } ?>update_dms_fields.php000064400000001121150312724140010722 0ustar00 sql_query("DELETE FROM `source_dms_fields_name` WHERE `dms_id` = '$dms_id' AND `dms_field_id` = '$dms_field_id' "); foreach ($field_names as $data){ $insert_data = $db -> escape(trim($data)); $db -> sql_query("INSERT INTO `source_dms_fields_name`(`dms_id`, `dms_field_id`, `name`) VALUES ('$dms_id','$dms_field_id','$insert_data')"); } ?>error_log000064400000001642150312724140006463 0ustar00[20-Aug-2024 08:33:37 Asia/Manila] PHP Warning: Invalid argument supplied for foreach() in /home/autoph/public_html/data_consolidation/app/settings/update_finance_fields.php on line 14 [20-Aug-2024 08:34:07 Asia/Manila] PHP Warning: Invalid argument supplied for foreach() in /home/autoph/public_html/data_consolidation/app/settings/update_finance_fields.php on line 14 [27-Aug-2024 10:33:11 Asia/Manila] PHP Warning: Invalid argument supplied for foreach() in /home/autoph/public_html/data_consolidation/app/settings/update_finance_fields.php on line 14 [27-Aug-2024 15:11:13 Asia/Manila] PHP Warning: Invalid argument supplied for foreach() in /home/autoph/public_html/data_consolidation/app/settings/update_finance_fields.php on line 14 [03-Sep-2024 16:40:59 Asia/Manila] PHP Warning: Invalid argument supplied for foreach() in /home/autoph/public_html/data_consolidation/app/settings/update_finance_fields.php on line 14