function update_m_push()
{
lite_connect($_POST['sync_user']);
if (func_num_args() > 0) {
$arg_list = func_get_args();
$list = $arg_list[0];
$type = $arg_list[1];
}
foreach ($list as $key => $value) {
switch ($type) {
case 'newpatient':
$update_patient_id = mysql_query("UPDATE m_push_status SET emr_patient_id={$value['1']} WHERE lite_patient_id={$value['0']} AND emr_patient_id=0") or die("Error 213 : " . mysql_error());
$update_sql = "UPDATE m_push_status SET push_flag='N' WHERE lite_patient_id={$value['0']} AND lite_specific_id =0";
break;
case 'update':
if ($vaue[4]) {
$update_sql = "UPDATE m_push_status SET push_flag='N' WHERE lite_patient_id = '{$value['0']}' AND emr_patient_id = '{$value['1']}' AND table_name='{$value['4']}' AND entry_date='{$value['5']}'";
} else {
$update_sql = "UPDATE m_push_status SET push_flag='N' WHERE lite_patient_id = '{$value['0']}' AND emr_patient_id = '{$value['1']}' AND lite_specific_id='{$value['2']}' AND table_name='{$value['4']}' AND entry_date='{$value['5']}'";
}
break;
default:
$update_sql = "UPDATE m_push_status SET emr_specific_id='{$value['3']}', push_flag='N' WHERE lite_patient_id = '{$value['0']}' AND emr_patient_id = '{$value['1']}' AND lite_specific_id='{$value['2']}' AND table_name='{$value['4']}' AND entry_date='{$value['5']}' AND sync_type='N'";
break;
}
$update_status = mysql_query($update_sql) or die("Error 45 : " . mysql_error());
}
}
function update_m_push()
{
lite_connect($host);
if (func_num_args() > 0) {
$arg_list = func_get_args();
$list = $arg_list[0];
$type = $arg_list[1];
}
//foreach list[0];
foreach ($list as $key => $value) {
switch ($type) {
case 'newpatient':
$update_sql = "UPDATE m_push_status SET emr_patient_id={$value['1']}, push_flag='N' WHERE lite_patient_id={$value['0']} AND emr_patient_id=0";
break;
default:
$update_sql = "UPDATE m_push_status SET emr_specific_id={$value['3']}, push_flag='N' WHERE lite_patient_id = '{$value['0']}' AND emr_patient_id = '{$value['1']}' AND lite_specific_id='{$value['2']}' AND table_name='{$value['4']}' AND entry_date='{$value['5']}'";
break;
}
echo $update_sql . "<br />";
$update_status = mysql_query($update_sql) or die("Error 45 : " . mysql_error());
}
}
