/**
* 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');
}
}
