i am stucked with one query in codeigniter ignited datatable.

shany

How can it convert it into ignited datatable query
$this->db->from('jil_requirements');
$this->db->join('jil_users', 'jil_requirements.rqm_userid=jil_users.usr_id', 'left');
$this->db->join('jil_merchants', 'jil_requirements.rqm_createdempid=jil_merchants.mer_id', 'left');
$this->db->where('jil_requirements.rqm_permission!=', '4');
$this->db->order_by("jil_requirements.rqm_id", "desc");
$query = $this->db->get();
if ($query->num_rows() > 0) {
foreach ($query->result() as $row) {
$this->db->select('count(jil_mrorfq.rfq_requirementid) as total');
$this->db->from('jil_mrorfq');
$this->db->join('jil_requirements', 'jil_requirements.rqm_id=jil_mrorfq.rfq_requirementid', 'left');
$this->db->where('jil_requirements.rqm_id',$row->rqm_id);
$query2= $this->db->get()->row_object();
$row->total_count = $query2->total;
$this->db->select('count(jil_quotemjdetail.qud_requirementid) as quotemjtotal');
$this->db->from('jil_quotemjdetail');
$this->db->join('jil_requirements', 'jil_requirements.rqm_id=jil_quotemjdetail.qud_requirementid', 'left');
$this->db->where('jil_requirements.rqm_id',$row->rqm_id);
$query3= $this->db->get()->row_object();
$row->quotemj_total = $query3->quotemjtotal;

       $this->db->select('count(jil_quotejcdetail.qud_requirementid) as quotejctotal'); 
    $this->db->from('jil_quotejcdetail'); 
   $this->db->join('jil_requirements', 'jil_requirements.rqm_id= jil_quotejcdetail.qud_requirementid', 'left'); 
   $this->db->where('jil_requirements.rqm_id',$row->rqm_id);
      $query4= $this->db->get()->row_object();
      $row->quotejc_total = $query4->quotejctotal;

        $this->db->select('count( jil_pocjdetail.pocd_requirementid) as pocjtotal'); 
    $this->db->from('jil_pocjdetail'); 
   $this->db->join('jil_requirements', 'jil_requirements.rqm_id=  jil_pocjdetail.pocd_requirementid', 'left'); 
   $this->db->where('jil_requirements.rqm_id',$row->rqm_id);
      $query5= $this->db->get()->row_object();
      $row->pocj_total = $query5->pocjtotal;

       $this->db->select('count(jil_pojmdetail.pojd_requirementid) as pojmtotal'); 
    $this->db->from('jil_pojmdetail'); 
   $this->db->join('jil_requirements', 'jil_requirements.rqm_id=  jil_pojmdetail.pojd_requirementid', 'left'); 
   $this->db->where('jil_requirements.rqm_id',$row->rqm_id);
      $query6= $this->db->get()->row_object();
      $row->pojm_total = $query6->pojmtotal;


     $data[] = $row;
            }
           return $data;
        }
        return false;