/** * Returns the weekly cost by shop and week * * @param (date) $dateFrom - format: 'YYYY-mm-dd'; * @param (date) $dateTo - format: 'YYYY-mm-dd'; * @param int $shopId * @return \Default_Model_WeeklyCosts */ public static function getWeeklyCostbyShopIdAndDate($dateFrom, $dateTo, $shopId) { $modelWeeklyCosts = new Default_Model_WeeklyCosts(); $selectFind = $modelWeeklyCosts->getMapper()->getDbTable()->select()->where('dateFrom = ?', $dateFrom)->where('dateTo = ?', $dateTo)->where('idShop = ?', $shopId); $modelWeeklyCosts->fetchRow($selectFind); return $modelWeeklyCosts; }
public function deleteAction() { $id = $this->getRequest()->getParam('id'); if ($id) { $model = new Default_Model_WeeklyCosts(); if ($model->find($id)) { if ($model->delete()) { $this->_flashMessenger->addMessage("<div class='success canhide'><p>" . Zend_Registry::get('translate')->_('Weekly Costs Data deleted successfully') . "</p><a href='javascript:;'></a></div>"); } else { $this->_flashMessenger->addMessage("<div class='failure canhide'><p>" . Zend_Registry::get('translate')->_('Weekly Costs Data not deleted') . "</p><a href='javascript:;'></a></div>"); } } else { $this->_flashMessenger->addMessage("<div class='failure canhide'><p>" . Zend_Registry::get('translate')->_('Error deleting Weekly Costs Data') . "!</p><a href='javascript:;'></a></div>"); } } $this->_redirect('/weekly-costs/details/id/' . $idProject); }
public function weeklyCostsAction() { $result = array(); $result["laborCost"] = ''; $result["foodCost"] = ''; $dateFrom = $this->getRequest()->getParam('dateFrom'); $dateTo = $this->getRequest()->getParam('dateTo'); $idUser = $this->getRequest()->getParam('idUser'); $modelWeeklyCosts = new Default_Model_WeeklyCosts(); $selectFind = $modelWeeklyCosts->getMapper()->getDbTable()->select()->where('dateFrom = ?', $dateFrom)->where('dateTo = ?', $dateTo)->where('idUser = ?', $idUser); $modelWeeklyCosts->fetchRow($selectFind); if ($modelWeeklyCosts->getId() !== NULL) { //existing weekly cost added in the database $result["idWeeklyCosts"] = $modelWeeklyCosts->getId(); $result["laborCost"] = $modelWeeklyCosts->getLaborCost(); $result["foodCost"] = $modelWeeklyCosts->getFoodCost(); } echo Zend_Json_Encoder::encode($result); }