Блог

Я хочу подсчитать массив данных, полученных с помощью postgresql, используя codeigniter.Я использовал цикл foreach и использовал count ($ row[‘zero’]) для подсчета, но это приводит только к 1. пожалуйста, направьте меня.

Вот мой контроллер

 public function indicators($pcode = '', $dcode = '') {
    $this->data['p_code'] = $pcode;
    $this->data['d_code'] = $dcode;
    $this->data['pcode'] = $this->employment_model->get_project();

        $this->data['attend_household'] = $this->employment_model->household_absent_all($dcode);
        var_dump($this->data['attend_household']);
        die();
        foreach($this->data['attend_household'] as $row){
            if($row['zero']>0){
                      $this->data['zerroo']=count($row['zero']);              
            }
        }
        if (count($this->data['attend_household']) > 0) {
            $this->data['attend_household'] = $this->data['attend_household'][0];
        }

    // var_dump($this->data);
    $this->load->view("employment_info", $this->data);
}
  

Вот моя модель

 function household_absent_all($dcode) {
    $dcode_query = "";
    if ($dcode != '') {
        if ($dcode == 'all') {
            $dcode_query = "";
        } else {
            $dcode_query = "where t.dcode='$dcode'";
        }
    }
    $sql = "select (100-(sum(days_worked)/sum(days_offered))*100) as zero,regno,sum(days_offered) as days_offered,sum(days_worked) as days_worked
        from(
            select*
            from assets.tblprojects a
            join(
            select pcode as project,hh_jobcard_no
            from employment.work_group_member
            )wg on a.pcode=wg.project
            join(
            select regno,at.days_offered,at.days_worked                                  
            from employment.registration_hh_member

             join(
            select pcode as a_pcode,hh_jobcard_no as jobcard,mem_id,
            sum((shift_1*0.5) (shift_2*0.5)) as days_worked,count(adate) as days_offered
            from employment.attendence
            group by a_pcode,jobcard,mem_id
            )at on regno=at.jobcard and s_no=at.mem_id
            )rhm on wg.hh_jobcard_no=rhm.regno                
            )t
            group by regno
            $dcode_query
            ";
    $result = $this->db->query($sql)->result_array();
    return $result;
}
  

попробуйте вот так

 $i=0;
 foreach($this->data['attend_household'] as $row){
            if($row['zero']>0){
                     $i  ;           
            }
        }
 $this->data['zerroo']=$i;
  

как насчет использования num_rows() в качестве счетчика.

 if($num = $result->num_rows() >=1){
    $result = array('result_set'=>$result->result_array(),'result_count'=>$num);
}else{
    $result = array('result_set'=>FALSE,'result_count'=>FALSE);
}
return $result;
  

затем на вашем контроллере вы можете использовать его как $variable['result_count'] для подсчета, так и $variable['result_set'] для результатов данных.