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