function dynamic_find_in_set($rtoLocations='2,1,1327') {
$rtoLocations = explode(',', $rtoLocations);
foreach ($rtoLocations as $row) {
$listOfIds .= $row.',';
}
$rtoLocationStr = rtrim($listOfIds,',');
$tablename = 'rto_tb_leads';
$selectedFields = 'lead_id,bname,bcontact,sname,scontact,veh_reg_no,case_category,follow_up_date_time,ofc.rto_office_location as rto_location';
$matchColumnName = 'rto_tb_leads.rto_location';
$details = $this->db->query("SELECT $selectedFields from $tablename LEFT JOIN rto_office as ofc ON ofc.id = rto_tb_leads.rto_location where lead_status='2' AND mfcw_exe_status='0' AND FIND_IN_SET($matchColumnName,'".$rtoLocationStr."')")->result_array();
if( is_array($details) && count($details) > 0 ) {
return $details;
}
return false;
}
$rtoLocations = explode(',', $rtoLocations);
foreach ($rtoLocations as $row) {
$listOfIds .= $row.',';
}
$rtoLocationStr = rtrim($listOfIds,',');
$tablename = 'rto_tb_leads';
$selectedFields = 'lead_id,bname,bcontact,sname,scontact,veh_reg_no,case_category,follow_up_date_time,ofc.rto_office_location as rto_location';
$matchColumnName = 'rto_tb_leads.rto_location';
$details = $this->db->query("SELECT $selectedFields from $tablename LEFT JOIN rto_office as ofc ON ofc.id = rto_tb_leads.rto_location where lead_status='2' AND mfcw_exe_status='0' AND FIND_IN_SET($matchColumnName,'".$rtoLocationStr."')")->result_array();
if( is_array($details) && count($details) > 0 ) {
return $details;
}
return false;
}
No comments:
Post a Comment