public static function getInstance()
{
if (!is_object(self::$_instance)) {
self::$_instance = new Admin_Model_HotelDetails();
}
return self::$_instance;
}
public function productAjaxHandlerAction()
{
$this->_helper->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$productsModel = Admin_Model_Products::getInstance();
$hotelModel = Admin_Model_HotelDetails::getInstance();
$catModel = Admin_Model_MenuCategory::getInstance();
$CuisinesModel = Admin_Model_FamousCuisines::getInstance();
if ($this->getRequest()->isPost()) {
$method = $this->getRequest()->getParam('method');
switch ($method) {
case 'productstatuschange':
$productid = $this->getRequest()->getParam('productid');
$result = $productsModel->changeProductStatus($productid);
if ($result) {
echo $productid;
die;
} else {
echo "error";
}
break;
case 'productdelete':
$productid = $this->getRequest()->getParam('productid');
$result = $productsModel->productDelete($productid);
if ($result) {
echo $result;
} else {
echo "error";
}
break;
case 'getcuisines':
$val = $this->getRequest()->getParam('typevalue');
if ($val == 2) {
$result = $CuisinesModel->getCuisines();
if ($result) {
$arr['code'] = 200;
$arr['data'] = $result;
echo json_encode($arr, true);
} else {
$arr['code'] = 197;
$arr['data'] = null;
echo json_encode($arr, true);
}
} else {
$arr['code'] = 198;
$arr['message'] = 'param not passed';
echo json_encode($arr, true);
}
break;
case 'getcategories':
$val = $this->getRequest()->getParam('typevalue');
if ($val == 1) {
$result = $catModel->selectAllCategorys();
if ($result) {
$arr['code'] = 200;
$arr['data'] = $result;
echo json_encode($arr, true);
die;
} else {
$arr['code'] = 197;
$arr['data'] = null;
echo json_encode($arr, true);
die;
}
} else {
$arr['code'] = 198;
$arr['message'] = 'param not passed';
echo json_encode($arr, true);
die;
}
break;
case 'hotelsbasedonagent':
$hotelid = $this->getRequest()->getParam('hotel_id');
$result = $hotelModel->getAllHotelsBasedOnAgent($hotelid);
if ($result) {
$arr['code'] = 200;
$arr['data'] = $result;
echo json_encode($arr, true);
} else {
$arr['code'] = 197;
$arr['data'] = null;
echo json_encode($arr, true);
}
break;
}
}
}
public function userAjaxHandlerAction()
{
$this->_helper->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$userModel = Admin_Model_Users::getInstance();
$usermetaModel = Admin_Model_Usermeta::getInstance();
$addtocartModel = Admin_Model_Addtocart::getInstance();
$userDeliveryAddressModel = Admin_Model_UserDeliveryAddress::getInstance();
$hotelDetailsModel = Admin_Model_HotelDetails::getInstance();
$productsModel = Admin_Model_Products::getInstance();
$agentsModal = Admin_Model_Agents::getInstance();
$delguyModal = Admin_Model_DeliveryGuys::getInstance();
$storeDetailsModel = Admin_Model_StoreDetails::getInstance();
$userTransModal = Admin_Model_UserTransactions::getInstance();
$agentTransModal = Admin_Model_AgentTransactions::getInstance();
$productTransModal = Admin_Model_ProductTransactions::getInstance();
$orderModal = Admin_Model_Orders::getInstance();
if ($this->getRequest()->isPost()) {
$method = $this->getRequest()->getParam('method');
switch ($method) {
case 'useractive':
$userstate = $this->getRequest()->getParam('userid');
$ok = $userModel->getstatustodeactivate($userstate);
if ($ok) {
echo $userstate;
} else {
echo "Error";
}
break;
// added by sowmya 11/4/2016
// added by sowmya 11/4/2016
case 'userdelete':
$userid = $this->getRequest()->getParam('userid');
$result = $userModel->userdelete($userid);
if ($result) {
$result1 = $usermetaModel->usermetadelete($userid);
$result2 = $addtocartModel->addToCartDeleteByUserId($userid);
$result3 = $userTransModal->userDeleteByUserId($userid);
$result4 = $productTransModal->productDeleteByUserId($userid);
$result5 = $orderModal->orderDeleteByUserId($userid);
$result6 = $userDeliveryAddressModel->userDeliveryAddressByUserId($userid);
echo $result;
'<br>';
echo $result1;
'<br>';
echo $result2;
'<br>';
echo $result3;
'<br>';
echo $result4;
'<br>';
echo $result5;
'<br>';
echo $result6;
} else {
echo "error";
}
break;
case 'agentactive':
$userstate = $this->getRequest()->getParam('agentid');
$ok = $agentsModal->getstatustodeactivate($userstate);
if ($ok) {
echo $userstate;
return $userstate;
} else {
echo "Error";
}
break;
// added by sowmya 11/4/2016
// added by sowmya 11/4/2016
case 'agentdelete':
$agentid = $this->getRequest()->getParam('agentid');
$result = $agentsModal->agentdelete($agentid);
if ($result) {
$result1 = $agentTransModal->agentDeleteByAgentId($agentid);
$result2 = $hotelDetailsModel->hotelDeleteByAgentId($agentid);
$result3 = $productsModel->productDeleteByAgentId($agentid);
echo $result;
'<br>';
echo $result1;
'<br>';
echo $result2;
'<br>';
echo $result3;
} else {
echo "error";
}
break;
case 'delguystatus':
$delguyid = $this->getRequest()->getParam('delguyid');
$ok = $delguyModal->getstatustodeactivate($delguyid);
if ($ok) {
echo $delguyid;
return $delguyid;
} else {
echo "Error";
}
break;
case 'delguydelete':
$delguyid = $this->getRequest()->getParam('delguyid');
$result = $delguyModal->deliveryGuydelete($delguyid);
if ($result) {
echo $result;
} else {
echo "error";
}
break;
//added by sowmya 30/3/2016
//added by sowmya 30/3/2016
case 'transdelete':
$transid = $this->getRequest()->getParam('transid');
$result = $userTransModal->transDelete($transid);
if ($result) {
echo $result;
} else {
echo "error";
}
break;
//added by sowmya 30/3/2016
//added by sowmya 30/3/2016
case 'orderdelete':
$orderid = $this->getRequest()->getParam('orderid');
$result = $orderModal->orderDelete($orderid);
if ($result) {
echo $result;
} else {
echo "error";
}
break;
//added by sowmya 4/4/2016
//added by sowmya 4/4/2016
case 'agenttransdelete':
$transid = $this->getRequest()->getParam('transid');
$result = $agentTransModal->transDelete($transid);
if ($result) {
echo $result;
} else {
echo "error";
}
break;
//added by sowmya 4/4/2016
//added by sowmya 4/4/2016
case 'producttransdelete':
$transid = $this->getRequest()->getParam('transid');
$result = $productTransModal->transDelete($transid);
if ($result) {
echo $result;
} else {
echo "error";
}
break;
case "OrderStatusChange":
//This method is use to change the status of merchant as well as his store.
$orderId = $this->_request->getParam('orderId');
$orderStatus = $this->_request->getParam('orderStatus');
$changed = $orderModal->changeOrderStatus($orderId);
if ($changed) {
$changed = $orderModal->updateOrderStatus($orderId, $orderStatus);
echo 1;
} else {
echo 0;
}
break;
case 'findhotel':
$locationid = $this->_request->getParam('locationid');
$result = $hotelDetailsModel->getHotelDetailsByLocation($locationid);
if ($result) {
echo json_encode($result);
} else {
echo "error";
}
break;
case 'findstore':
$locationid = $this->_request->getParam('locationid');
$result = $storeDetailsModel->getStoreDetailsByLocation($locationid);
if ($result) {
echo json_encode($result);
} else {
echo "error";
}
break;
}
}
}
public function dashboardAction()
{
$adminModel = Admin_Model_Users::getInstance();
$result = $adminModel->getAdminDetails();
// showing image
if ($result) {
$this->view->admindetails = $result;
}
$userModel = Admin_Model_Users::getInstance();
$result = $userModel->getUserdetails();
if ($result) {
$this->view->userdetails = count($result);
}
$usertransactionModel = Admin_Model_UserTransactions::getInstance();
$result1 = $usertransactionModel->getAllUsertransaction();
if ($result1) {
$this->view->usertransaction = count($result1);
}
$ordersModel = Admin_Model_Orders::getInstance();
$result2 = $ordersModel->getAllHotelOrder();
if ($result2) {
$this->view->orderdetails = count($result2);
}
$ordersModel1 = Admin_Model_Orders::getInstance();
$result21 = $ordersModel->getAllStoreOrder();
if ($result21) {
$this->view->storeorderdetails = count($result21);
}
$productsModel = Admin_Model_Products::getInstance();
$result3 = $productsModel->getProductsdetails();
if ($result3) {
$this->view->productsdetails = count($result3);
}
$productsModel1 = Admin_Model_Products::getInstance();
$result31 = $productsModel1->getAllStoreProductdetails();
if ($result31) {
$this->view->productsdetails = count($result31);
}
$agentsModel = Admin_Model_Agents::getInstance();
$result4 = $agentsModel->getAgentsDetails();
if ($result4) {
$this->view->agentsdetails = count($result4);
}
$storeDetailsModel = Admin_Model_StoreDetails::getInstance();
$result5 = $storeDetailsModel->getAllStore();
if ($result5) {
$this->view->storedetails = count($result5);
}
$hotelDetailsModel = Admin_Model_HotelDetails::getInstance();
$result6 = $hotelDetailsModel->getAllHotels();
if ($result6) {
$this->view->hoteldetails = count($result6);
}
$agenttransactionModel = Admin_Model_AgentTransactions::getInstance();
$result7 = $agenttransactionModel->getAllAgenttransaction();
if ($result7) {
$this->view->agenttransaction = count($result7);
}
$producttransactionModel = Admin_Model_ProductTransactions::getInstance();
$result8 = $producttransactionModel->getAllProducttransaction();
if ($result8) {
$this->view->producttransaction = count($result8);
}
$storeCategoryDetailsModel = Admin_Model_StoreCategory::getInstance();
$result9 = $storeCategoryDetailsModel->selectAllCategorys();
if ($result9) {
$this->view->storecategorydetails = count($result9);
}
$DeliveryGuysModel = Admin_Model_DeliveryGuys::getInstance();
$result10 = $DeliveryGuysModel->getAllDeliveryGuys();
if ($result10) {
$this->view->DeliveryGuys = count($result10);
}
$NotificationModel = Admin_Model_Notification::getInstance();
$result11 = $NotificationModel->getNotificationDetail();
if ($result11) {
$this->view->Notification = count($result11);
}
$ReviewsModel = Admin_Model_Reviews::getInstance();
$result12 = $ReviewsModel->getAllHotelReviews();
if ($result12) {
$this->view->HotelReviews = count($result12);
}
$ReviewModel = Admin_Model_Reviews::getInstance();
$result13 = $ReviewModel->getAllStoreReviews();
if ($result13) {
$this->view->StoreReviews = count($result13);
}
$locationsModel1 = Admin_Model_Location::getInstance();
$result14 = $locationsModel1->getCountrys();
if ($result14) {
$this->view->CountryDetails = count($result14);
}
$locationsModel2 = Admin_Model_Location::getInstance();
$result15 = $locationsModel2->getStates();
if ($result15) {
$this->view->StateDetails = count($result15);
}
$locationsModel3 = Admin_Model_Location::getInstance();
$result16 = $locationsModel3->getCitys();
if ($result16) {
$this->view->CityDetails = count($result16);
}
$locationsModel4 = Admin_Model_Location::getInstance();
$result17 = $locationsModel4->getLocations();
if ($result17) {
$this->view->LocationDetails = count($result17);
}
$cuisinesModel = Admin_Model_FamousCuisines::getInstance();
$result18 = $cuisinesModel->getCuisines();
if ($result18) {
$this->view->CuisineDetails = count($result18);
}
$categoryModel = Admin_Model_MenuCategory::getInstance();
$result19 = $categoryModel->selectAllCategorys();
if ($result19) {
$this->view->CategoryDetails = count($result19);
}
$objModelCoupons = Admin_Model_Coupons::getInstance();
$allCoupons = $objModelCoupons->getCoupons();
if ($allCoupons) {
$this->view->allcoupons = count($allCoupons);
}
$objModelCouponUsers = Admin_Model_CouponUsers::getInstance();
$couponsLog = $objModelCouponUsers->getCouponsLog();
if ($couponsLog) {
$this->view->couponsLog = count($couponsLog);
}
}
public function cuisinesDetailsAction()
{
$adminModel = Admin_Model_Users::getInstance();
$result = $adminModel->getAdminDetails();
// showing image
if ($result) {
$this->view->admindetails = $result;
}
$cuisinesModel = Admin_Model_FamousCuisines::getInstance();
$hotelModel = Admin_Model_HotelDetails::getInstance();
$hotelcuisinesModel = Admin_Model_HotelCuisines::getInstance();
$cuisines = $cuisinesModel->getCuisinesHotelBased();
if ($cuisines) {
$this->view->cuisinesdetails = $cuisines;
}
$hotel = $hotelModel->selectAllHotels();
if ($hotel) {
$this->view->hotellist = $hotel;
}
if ($this->getRequest()->isPost()) {
$data['Cuisine_name'] = $this->getRequest()->getPost('cuisinename');
$data['cuisine_status'] = $this->getRequest()->getPost('cuisine_status');
$cuisine_id = $cuisinesModel->addCuisines($data);
$hotelcuisinesdata['cuisine_id'] = $cuisine_id;
$hotelcuisinesdata['hotel_id'] = $this->getRequest()->getPost('hotels');
$result2 = $hotelcuisinesModel->addCuisinesDetails($hotelcuisinesdata);
if ($result2) {
$this->redirect('/admin/cuisines-details');
}
}
}
public function viewHotelDetailsAction()
{
$adminModel = Admin_Model_Users::getInstance();
$result = $adminModel->getAdminDetails();
// showing image
if ($result) {
$this->view->admindetails = $result;
}
$hotelDetailsModel = Admin_Model_HotelDetails::getInstance();
$hotelCuisinesModel = Admin_Model_HotelCuisines::getInstance();
$hotel_id = $this->getRequest()->getParam('id');
$dt['hotel_id'] = $hotel_id;
$cuisinesdDetails = $hotelCuisinesModel->getCuisinesByHotelId($hotel_id);
$i = 0;
if ($cuisinesdDetails) {
foreach ($cuisinesdDetails as $value) {
$array[$i] = $value['Cuisine_name'];
}
$i++;
$this->view->cuisinesdDetails = $cuisinesdDetails;
}
$result = $hotelDetailsModel->getHotelDetailsByID($hotel_id);
if ($result) {
$this->view->allhoteldetails = $result;
} else {
echo 'controller error occured';
}
}
