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()); } }