Hi, I need to convert it to cakephp sql approach rather than sql query. This is very complex for cakephp basic query.
SELECT SUM(payment - ( payment - gross_amount)) as 'Payment' FROM sales_orders s WHERE DATE_FORMAT(`date`,'%Y-%m-%d') = CURDATE(); thanks in advance -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
