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.

Taidot: PHP, MySQL, Codeigniter, Tietojärjestelmäarkkitehtuuri, Tietokantaohjelmointi

Näytä lisää: 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

Tietoa työnantajasta:
( 9 arvostelua ) Copperopolis, United States

Projektin tunnus: #28296849

Myönnetty käyttäjälle:


Dear sir! I'm interested in your project. I have experience with 5 years experience of CI I can finish your project on time. I hope to work on the project with you. Regards.

$20 USD 1 päivässä
(15 Arvostelua)

4 freelanceria on tarjonnut keskimäärin $38 tähän työhön


Hello, I have gone through your project description and attached images. I can easily complete this project. I am a PHP, Mysql, Laravel and codeigniter expert who loves to code. For over the last 6+ years, I have built Lisää

$100 USD 3 päivässä
(184 arvostelua)

Hi sir, I am vijay,I had seen your requirement thoroughly. I had very vast knowledge on sql,mongo db,c++,not only these had rich experience in dbms also. if you message me i can show my python deployed applications.w Lisää

$20 USD 1 päivässä
(2 arvostelua)

Hi, Working for the last 5+ years as a Web Developer. I can help you with mysql query in codeigniter. I am applying for this job because it best matches my skills and experience. I am available to start right away. Lisää

$10 USD 1 päivässä
(0 arvostelua)