php - 我想计算我的数据库中的特定字段取决于 ID_number

Question

这是我的模型

public function total_late()
    {

        $query = "SELECT sum(late_deduction) as late_deduction FROM tbl_dtr";
        $result = $this->db->query($query);
        return $result->row()->late_deduction;
    }

这是数据库的图像：

这是我的桌子的图像：

这是我在视图中的另一个模型

function get_faculty_payroll($limit, $start, $string = "", $orderField, $orderDirection)
    {  
       $this->db->group_start()
                        ->where('tbl_employee' . '.department_id', 3)
                ->group_end()
                ->group_start()
                        ->or_like('first_name', $string)
                        ->or_like('last_name', $string)
                ->group_end()
                ->join('tbl_employee_department', 'tbl_employee.department_id = tbl_employee_department.department_id')
                ->join('tbl_rates', 'tbl_employee.ID_number = tbl_rates.ID_number')
                ->limit($limit, $start)
                ->order_by($orderField, $orderDirection);
       $query = $this->db->get('tbl_employee');
       return $query->result();
    }

这是我的桌子：

标签： phpcodeigniter

Answer 1

试试这个，

public function total_late()
{
  $query = "SELECT sum(late_deduction) as late_deduction FROM tbl_dtr where ID_number = 'C-08011'";
  $result = $this->db->query($query);
  return $result->row()->late_deduction;
}