$delete_query = mysql_query("DELETE FROM {$delete_value['4']} WHERE {$delete_text} {$missing}") or die("Error 227 : " . mysql_error()); } } ehr_connect(); } else { if ($delete_value[4] == 'm_consult_notes') { $delete_text = "notes_id = '{$delete_value['3']}'"; } $delete_query = mysql_query("DELETE FROM {$delete_value['4']} WHERE {$delete_text}") or die("Error 132 : " . mysql_error()); } $push_data_array = array($delete_value[0], $delete_value[1], $delete_value[2], $delete_value[3], $delete_value[4], $delete_value[5], 'N', $delete_value[6]); array_push($array_m_push_update, $push_data_array); unset($push_data_array); $delete_record_count += 1; } update_m_push($array_m_push_update, 'update'); unset($array_m_push_update); } echo "<table width='30%' align='center' style='background-color: #FFFFFF;font-family: verdana,arial;font-size:20;'>"; echo "<tr><td colspan='2' style='background-color:#0000FF;text-align:center;color:white;'>EHR Server Data Sync Results</td></tr>"; //echo "You have successfully Synced : <br />"; echo "<tr><td colspan='2' style='background-color:#99CCFF;text-align:left;'>{$new_record_count} <b>NEW</b> records added to the EHR server </span></td></tr><br />"; echo "<tr><td colspan='2' style='background-color:#99CCFF;text-align:left;'> {$update_record_count} records <b>UPDATED</b> in the EHR server </span></td></tr><br />"; echo "<tr><td colspan='2' style='background-color:#99CCFF;text-align:left;'> {$delete_record_count} records <b>DELETED</b> in the EHR server</span></td></tr>"; echo "</td></tr>"; } else { echo "<form name='lite2-sync' method='post' action=''>"; echo "<table width='30%' align='center' style='background-color: #FFFFFF;font-family: verdana,arial;font-size:20;'>"; echo "<tr><td colspan='2' style='background-color:#0000FF;text-align:center;color:white;'>ENTER EHR-LITE IP ADDRESS </td></tr>"; echo "<tr style='background-color: #99CCFF;text-align:center; '><td><br />"; echo "<input type='text' name='sync_user' size='10' length='10' style='font-size:30;font-weight:bold;background-color:#FFFFCC;height:50px' > ";
foreach ($table_array as $tablename) { lite_connect($host); $check_status_sql = "SELECT lite_patient_id, emr_patient_id, lite_specific_id, emr_specific_id, table_name, entry_date, sync_type FROM m_push_status WHERE push_flag ='Y' AND table_name='{$tablename}' AND sync_type='N'"; $new_entry_array = get_data_array($check_status_sql); if ($new_entry_array != NULL || $new_consult_array != '') { ehr_connect(); $array_m_push_update = array(); foreach ($new_entry_array as $entry_array => $new_entry) { $new_id = get_new_id($new_entry); $insert_text = insert_values($new_entry, $new_id); insert_query($insert_text, $new_entry[4]); $push_data_array = array($new_entry[0], $new_entry[1], $new_entry[2], $new_id, $new_entry[4], $new_entry[5], 'N', $new_entry[6]); array_push($array_m_push_update, $push_data_array); unset($push_data_array); } update_m_push($array_m_push_update, 'new'); unset($array_m_push_update); } } function insert_query() { if (func_num_args() > 0) { $arg_list = func_get_args(); $list = $arg_list[0]; $table_name = $arg_list[1]; } $insert_sql = mysql_query("INSERT INTO {$table_name} VALUES({$list})") or die("Error 21 : " . mysql_error()); } function get_new_id() { if (func_num_args() > 0) {