Help with MYSQL Query (must be in CodeIgniter query builder class format)

I need assistance writing a complex query to sum columns conditionally based on conditions of another field, then group by customer, then only display customers with a sum greater than zero.

The query must be in code ignitors query bulder class format, for example:

$this->db->where('name', $name);

$this->db->where('title', $title);

$this->db->where('status', $status);

Please see attachments with current query and report display. In the [login to view URL] the only record that should be returned is the record in red.

Kĩ năng: PHP, MySQL, Codeigniter, Kiến trúc phần mềm, Lập trình cơ sở dữ liệu

Xem nhiều hơn: perl mysql find record query, mysql advanced search query example, mysql remote server query, mysql search tag query, php mysql specific search query, php mysql safe update query, mysql scripts loop query, php mysql drop list query table, php mysql real estate query, bash mysql connecting running query, mysql dial plan query, query failed mysql error 1065 query empty, mysql fix 2013 query, mysql error 1065 query empty sugarcrm, codeigniter query builder, convert mysql query to codeigniter query online

ID dự án: #28296849