public function restaurantMenu($restId)
{
try {
$menuRestMapper = new Restaurant_Model_MenuFirmDataMapper();
$manuTable = $menuRestMapper->getDbTable();
$menuSelect = $manuTable->select();
$menuSelect->from(array('mr' => 'rd.menu_restaurant'), array('mrid', 'mr_title', 'mr_description', 'mr_status', 'mr_viewtype'))->where('mrfk_restaurantid = ?', $restId)->where('mr_status = ?', true)->order(array('mrid ASC'));
$rowSet = $manuTable->fetchAll($menuSelect);
$menus = array();
foreach ($rowSet as $row) {
$table = $this->getDbTable();
$select = $table->select();
$select->setIntegrityCheck(false);
$select->from(array('cat' => 'rd.menu_category'), array('mcid', 'mc_name', 'mc_description', 'mc_status'))->where('mcfk_menu_restaurantid = ?', $row->mrid)->where('mc_status = ?', true)->order(array('mcid ASC'));
$catrowSet = $table->fetchAll($select);
$categorys = array();
foreach ($catrowSet as $catrow) {
$itemMaper = new Restaurant_Model_MenuItemsDataMapper();
$menuItems = $itemMaper->GetMenuItems($catrow->mcid);
$categorys[] = array('categoryid' => $catrow->mcid, 'categoryname' => $catrow->mc_name, 'categorydesc' => $catrow->mc_description, 'categorystatus' => $catrow->mc_status, 'currency' => 'INR', 'currencytitle' => 'Indian Rupee', 'itemsArr' => $menuItems);
}
$menus[] = array('menuid' => $row->mrid, 'menutitle' => $row->mr_title, 'menudesc' => $row->mr_description, 'menustatus' => $row->mr_status, 'menuview' => $row->mr_viewtype, 'categorys' => $categorys);
}
return $menus;
} catch (Exception $ex) {
throw new Exception($ex->getMessage());
}
}
public function changeMenuStatus($request)
{
try {
$menuid = $request->menuid;
if ($request->status == 'ACT') {
$status = 1;
} else {
if ($request->status == 'INA') {
$status = 0;
}
}
$menuMapper = new Restaurant_Model_MenuFirmDataMapper();
$result = $menuMapper->changeMenuStatus($menuid, $status);
return $result;
} catch (Exception $ex) {
Rdine_Logger_FileLogger::info($ex->getMessage());
throw new Exception($ex->getMessage());
}
}
