function test_where_clause()
{
$this->assertEqual(where_clause('f1', 'v1'), "WHERE f1 = 'v1'");
$this->assertEqual(where_clause('f1', 'v1', 'f2', 2), "WHERE f1 = 'v1' AND f2 = '2'");
$this->assertEqual(where_clause('f1', 'v1', 'f2', 1.75, 'f3', 'v3'), "WHERE f1 = 'v1' AND f2 = '1.75' AND f3 = 'v3'");
$this->assertEqual(where_clause('f1', NULL), "WHERE f1 IS NULL");
}
/**
* Delete the records from a table where all the given fields match the given values.
*
* @uses $CFG
* @uses $db
* @param string $table the table to delete from.
* @param string $field1 the first field to check (optional).
* @param string $value1 the value field1 must have (requred if field1 is given, else optional).
* @param string $field2 the second field to check (optional).
* @param string $value2 the value field2 must have (requred if field2 is given, else optional).
* @param string $field3 the third field to check (optional).
* @param string $value3 the value field3 must have (requred if field3 is given, else optional).
* @return mixed An ADODB RecordSet object with the results from the SQL call or false.
*/
function delete_records($table, $field1 = '', $value1 = '', $field2 = '', $value2 = '', $field3 = '', $value3 = '')
{
global $db, $CFG;
// Clear record_cache based on the parameters passed
// (individual record or whole table)
if ($CFG->rcache === true) {
if ($field1 == 'id') {
rcache_unset($table, $value1);
} else {
if ($field2 == 'id') {
rcache_unset($table, $value2);
} else {
if ($field3 == 'id') {
rcache_unset($table, $value3);
} else {
rcache_unset_table($table);
}
}
}
}
if (defined('MDL_PERFDB')) {
global $PERF;
$PERF->dbqueries++;
}
$select = where_clause($field1, $value1, $field2, $value2, $field3, $value3);
$sql = 'DELETE FROM ' . $CFG->prefix . $table . ' ' . $select;
$rs = $db->Execute($sql);
if (!$rs) {
debugging($db->ErrorMsg() . '<br /><br />' . s($sql));
if (!empty($CFG->dblogerror)) {
$debug = array_shift(debug_backtrace());
error_log("SQL " . $db->ErrorMsg() . " in {$debug['file']} on line {$debug['line']}. STATEMENT: {$sql}");
}
return false;
}
return $rs;
}
/**
* Delete the records from a table where all the given fields match the given values.
*
* @uses $CFG
* @uses $db
* @param string $table the table to delete from.
* @param string $field1 the first field to check (optional).
* @param string $value1 the value field1 must have (requred if field1 is given, else optional).
* @param string $field2 the second field to check (optional).
* @param string $value2 the value field2 must have (requred if field2 is given, else optional).
* @param string $field3 the third field to check (optional).
* @param string $value3 the value field3 must have (requred if field3 is given, else optional).
* @return mixed An ADODB RecordSet object with the results from the SQL call or false.
*/
function delete_records($table, $field1 = '', $value1 = '', $field2 = '', $value2 = '', $field3 = '', $value3 = '')
{
global $db, $CFG;
// Clear record_cache based on the parameters passed
// (individual record or whole table)
if ($CFG->rcache === true) {
if ($field1 == 'id') {
rcache_unset($table, $value1);
} else {
if ($field2 == 'id') {
rcache_unset($table, $value2);
} else {
if ($field3 == 'id') {
rcache_unset($table, $value3);
} else {
rcache_unset_table($table);
}
}
}
}
if (defined('MDL_PERFDB')) {
global $PERF;
$PERF->dbqueries++;
}
$select = where_clause($field1, $value1, $field2, $value2, $field3, $value3);
return $db->Execute('DELETE FROM ' . $CFG->prefix . $table . ' ' . $select);
}
update_m_push($array_m_push_update, 'update');
unset($array_m_push_update);
}
//DELETE RECORDS
$delete_record_count = 0;
lite_connect($_POST['sync_user']);
$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 sync_type='D'";
$delete_array = get_data_array($check_status_sql);
//print_r($delete_array);
if ($delete_array != NULL || $delete_array != '') {
ehr_connect();
$array_m_push_update = array();
foreach ($delete_array as $del_array => $delete_value) {
//print_r($delete_array);
//echo "<br />";
$delete_text = where_clause($delete_value);
if ($delete_value[4] == 'm_patient_fp_method_service' || $delete_value[4] == 'm_patient_fp_obgyn' || $delete_value[4] == 'm_patient_fp_hx' || $delete_value[4] == 'm_consult_mc_postpartum' || $delete_value[4] == 'm_consult_mc_prenatal' || $delete_value[4] == 'm_consult_mc_services' || $delete_value[4] == 'm_consult_mc_vaccine' || $delete_value[4] == 'm_consult_ccdev_vaccine' || $delete_value[4] == 'm_consult_ccdev_services' || $delete_value[4] == 'm_consult_vaccine' || $delete_value[4] == 'm_consult_notes_complaint' || $delete_value[4] == 'm_consult_notes_dxclass') {
$get_all_compare = mysql_query("SELECT * FROM {$delete_value['4']} WHERE {$delete_text}") or die("Error 200 : " . mysql_error());
while ($get_all_result = mysql_fetch_array($get_all_compare)) {
switch ($delete_value[4]) {
case 'm_consult_mc_prenatal':
$spc_field = 'mc_id';
$field_to_find = 'visit_sequence';
$value_to_find = $get_all_result['visit_sequence'];
break;
case 'm_consult_mc_postpartum':
$spc_field = 'mc_id';
$field_to_find = 'visit_sequence';
$value_to_find = $get_all_result['visit_sequence'];
break;
case 'm_consult_ccdev_vaccine':
}
if ($operator == STARTSWITH) {
$where_clause = "(" . $field . " LIKE '%" . $string . "')";
}
if ($operator == ISANYOF) {
}
if ($operator == ISALLOF) {
}
return $where_clause;
}
if ($HTTP_POST_VARS["hdn_search"]) {
$where_clause = "";
$and_flag = FALSE;
if (strlen($HTTP_POST_VARS["txt_srch_doc_name"]) > 2) {
$where_clause .= "(";
$where_clause .= where_clause($HTTP_POST_VARS["slct_srch_doc_name"], $xoopsDB->prefix("dms_objects") . ".obj_name", $HTTP_POST_VARS["txt_srch_doc_name"]);
$where_clause .= ")";
$and_flag = TRUE;
}
if (strlen($HTTP_POST_VARS["txt_srch_doc_owner"]) > 2) {
if ($and_flag == TRUE) {
$where_clause .= " AND ";
}
$where_clause .= "(";
$where_clause .= ")";
$and_flag = TRUE;
}
if (strlen($HTTP_POST_VARS["txt_srch_descript"]) > 2) {
if ($and_flag == TRUE) {
$where_clause .= " AND ";
}
