Đã hoàn thành

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

Về Bên Thuê:
( 9 nhận xét ) Copperopolis, United States

ID dự án: #28296849

Được trao cho:

jcaff999

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 trong 1 ngày
(15 Đánh Giá)
2.9

4 freelancer chào giá trung bình$38 cho công việc này

smilemittal181

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 Thêm

$100 USD trong 3 ngày
(184 Nhận xét)
7.1
vijaydevops92

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 Thêm

$20 USD trong 1 ngày
(2 Nhận xét)
0.8
sajjadmelwana

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. Thêm

$10 USD trong 1 ngày
(0 Nhận xét)
0.0