$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) {
