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