sum() function in cakephp query

by

You should not be using PHP superglobals directly in CakePHP. You should instead use Model.field naming so that you do not get ambiguous field errors.

Virtual fields is the way to go but that is not your problem, you need to read the book some more.

$total = $this->RequestedItem->find('all', array(array('fields' => array('sum(Model.cost * Model.quantity)   AS ctotal'), 'conditions'=>array('RequestedItem.purchase_request_id'=>$this->params['named']['po_id'])));

should work fine, with the virtualFields it would be

var $virtualFields = array('total' => 'SUM(Model.cost * Model.quantity)');
$total = $this->RequestedItem->find('all', array(array('fields' => array('total'), 'conditions'=>array('RequestedItem.purchase_request_id'=>$this->params['named']['po_id'])));

Fields go in the ‘fields’ key, just like conditions go in the ‘conditions’ key. See http://book.cakephp.org/2.0/en/models/retrieving-your-data.html#find

More Related Contents:

  1. How to filter by conditions for associated models?
  2. CakePHP 3.0 installation: intl extension missing from system
  3. How to limit contained associations per record/group?
  4. CakePHP 3.0 -> Between find condition
  5. Can I use one model inside of a different model in CakePHP?
  6. How do I write a join query across multiple tables in CakePHP?
  7. How to setup cronjobs in cake php?
  8. How to use different datasources in a Query using cakephp3?
  9. What is the equivalent to getLastInsertId() in Cakephp?
  10. How to Install DebugKit on CakePHP
  11. Paginate from within a model in CakePHP
  12. How do I create a keyValue pair (display field) by combining/having two fields in CakePHP 3?
  13. How to create a `IN` clause in CakePHP query?
  14. How to paginate associated records?
  15. Cakephp Career Database Design
  16. Where 2 != 2 in PHP
  17. “[notice] child pid XXXX exit signal Segmentation fault (11)” in apache error.log [closed]
  18. How to output custom HTTP body contents with CakePHP 3.4? Echoing causes “Unable to emit headers” error
  19. CakePHP 2.0 – How to make custom error pages?
  20. How to use multiple databases dynamically for one model in CakePHP
  21. Request Entity Too Large PHP
  22. SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP
  23. How to “Validate” Human Names in CakePHP?
  24. How do you make strings “XML safe”?
  25. CakePHP remember me with Auth
  26. How to output serialized JSON view data as an array of objects, instead of wrapped in an outer object?
  27. Encryption/Decryption of Form Fields in CakePHP 3
  28. Best way to document Array options in PHPDoc?
  29. CakePHP – get last query run
  30. CakePHP: best way to call an action of another controller with array as parameter?

Leave a Comment