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