CODEWITHSUNDEEP
phpsqlzend-framework
user1268130
user1268130

Reputation: 923

convert sql query to zend query

SELECT uls.prod_id,um.prod_image,um.prodname,SUM(msm.points)
FROM tbl_prod_selection AS uls
INNER JOIN tbl_prod_master AS um ON um.prod_id = uls.prod_id
INNER JOIN tbl_admin_prod_selection AS als ON als.user_id = uls.user_id
INNER JOIN tbl_prod_statistics_master AS msm ON (msm.user_id = uls.user_id AND msm.barcode_id = als.barcode_id)
WHERE uls.location_id = "18" AND uls.prod_code = "FLB"
GROUP BY uls.user_id;

can any one help to write zend query for this.

Thanks in Advance.

Upvotes: 0

Views: 62

Answers (1)

Daniel Gadawski
Daniel Gadawski

Reputation: 1923

If you're using Zend_Db_Table, then you can assemble Zend_Db_Table_Select like below:

$select = $model->select()
                ->setIntegrityCheck(false)
                ->from(array('uls' => 'tbl_prod_selection'), array(
                        'uls.prod_id',
                        'um.prod_image',
                        'um.prodname',
                        'sum' => new Zend_Db_Expr('SUM(msm.points)'),
                ))
                ->join(array('um' => 'tbl_prod_master'), 'um.prod_id = uls.prod_id', array())
                ->join(array('als' => 'tbl_admin_prod_selection'), 'als.user_id = uls.user_id', array())
                ->join(array('msm' => 'tbl_prod_statistics_master'), 'msm.user_id = uls.user_id AND msm.barcode_id = als.barcode_id', array())
                ->where('uls.location_id = ?', '18')
                ->where('uls.prod_code = ?', 'FLB')
                ->group('uls.user_id');

Upvotes: 1

Related Questions