/** * Calculate total gross sales between 2 dates * * @param (date) $dateFrom - format: 'YYYY-mm-dd'; * @param (date) $dateTo - format: 'YYYY-mm-dd'; * @param int $shopId * @return int - total gross sales between 2 dates */ public static function calculateTotalWeekGrossSales($dateFrom, $dateTo, $shopId) { $model = new Default_Model_DailySales(); $selectAll = $model->getMapper()->getDbTable()->select()->from(array('ds' => 'daily_sales'), array('id' => 'SUM(ds.grossSales)'))->where('ds.date >= ?', $dateFrom)->where('ds.date <= ?', $dateTo)->where('ds.idShop = ?', $shopId); $model->fetchRow($selectAll); return $model->getId(); }
/** * * @return number of reports that have not been audited */ public function getTotalNoAudit() { $model = new Default_Model_DailySales(); $select = $model->getMapper()->getDbTable()->select()->from(array('d' => 'daily_sales'), array('id' => 'COUNT(d.id)'))->where('audited = ?', 0)->setIntegrityCheck(false); $model->fetchRow($select); return $model->getId(); }
public function statusAuditAction() { $dailySales = new Default_Model_DailySales(); $select = $dailySales->getMapper()->getDbTable()->select(); $select->from(array('d' => 'daily_sales'), array('d.idShop', 'd.date', 'd.id'))->where('audited = ?', 0)->order('date DESC'); $result = $dailySales->fetchAll($select); $this->view->totalNr = Needs_Tools::getTotalNoAudit(); if (NULL != $result) { $paginator = Zend_Paginator::factory($result); $paginator->setItemCountPerPage(10); $paginator->setCurrentPageNumber($this->_getParam('page')); $paginator->setPageRange(5); $this->view->result = $paginator; $this->view->itemCountPerPage = $paginator->getItemCountPerPage(); $this->view->totalItemCount = $paginator->getTotalItemCount(); Zend_Paginator::setDefaultScrollingStyle('Sliding'); Zend_View_Helper_PaginationControl::setDefaultViewPartial('_pagination.phtml'); } }