num_rows()>0) { $i=1; foreach($quo_det->result() as $gq){ $quoteid=$gq->id; $user_id=$gq->user_id; $category=$gq->category; $cdate=$gq->cdate; $policy_id=$gq->policy_id; $policyname=$gq->policyname; $status=$gq->status; $agency_id=$gq->agency_id; //get response given or not $tables="quote_response"; $wheres=array("quote_id"=>$quoteid); $shows=("*"); $get_respo_sts=$this->commonsql_model->selectTable($tables,$wheres,$shows); if ($get_respo_sts->num_rows()>0){ $response_status="1";//response given } else{$response_status="0"; // response notgiven } $tables="categories"; $wheres=array("id"=>$category); $shows=("*"); $categ=$this->commonsql_model->selectTable($tables,$wheres,$shows); if ($categ->num_rows()>0){ $ca=$categ->row(); $ategoryname=$ca->name; } if($agency_id!=0){ $tables="users"; $wheres=array("id"=>$agency_id); $shows=("*"); $agename=$this->commonsql_model->selectTable($tables,$wheres,$shows); if ($agename->num_rows()>0){ $a=$agename->row(); $agency_name=$a->name; $a_color="#fd653b"; } } else { $agency_name="Not Assigned"; $a_color="#dc3545"; } //customer details $tables="users"; $wheres=array("id"=>$user_id); $shows=("*"); $custname=$this->commonsql_model->selectTable($tables,$wheres,$shows); if ($custname->num_rows()>0){ $c=$custname->row(); $custname_name=$c->name; } ?>

S no	Customer Name	Agent Name	Category	Policy	Date