Monday, July 4, 2016

For Dynamic find_in_set with JOIN Query

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

No comments:

Post a Comment