Esempio n. 1
0
 function GetPIDOfLaspedContract($days = '')
 {
     global $db;
     $rep_obj = new report();
     $tmp_reporting_table_1 = $rep_obj->SetReportingLink('care_tz_insurance', 'PID', 'care_person', 'pid');
     $tmp_reporting_table_2 = $rep_obj->TMP_GroupBy($tmp_reporting_table_1, 'care_tz_insurance_PID');
     $rep_obj->DisconnectReportingTable($tmp_reporting_table_1);
     $now = time();
     $seconds = $days * 24 * 60;
     $asked_time = $now - $seconds;
     $this->setTable($tmp_reporting_table_2);
     $this->sql = "SELECT selian_pid, date_reg, name_first, name_2, name_3, name_middle, name_last, name_maiden, name_others FROM {$this->coretable} WHERE end_date < {$asked_time}";
     $mysql_ptr = $db->Execute($this->sql);
 }