| Server IP : 103.234.187.230 / Your IP : 216.73.216.216 Web Server : Apache System : Linux lserver42043-ind.megavelocity.net 3.10.0-1160.108.1.el7.x86_64 #1 SMP Thu Jan 25 16:17:31 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/b2bzend/application/controllers/ |
Upload File : |
<?php
/**
* Class TransportRoute
* @name Transport Routes
* @author Pardeep Panchal
* @version 1.0
* @copyright Catabatic India Pvt Ltd
* Handle Transport Routes Related function
*
*/
class TransportsRouteController extends Catabatic_ValidateGtx{
public function init() {
parent::init();
$sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
#get session variable
$this->SupplierTypeSysId = 7;
$this->intLoggedinUserId = $sessionLogin_user->intLoggedinUserId;
$this->intLoggedinUserGroupSysId = $sessionLogin_user->intLoggedinUserGroupSysId;
$this->intLoggedinUserAgencySysId = $sessionLogin_user->intLoggedinUserAgencySysId;
$this->intLoggedinUserTrxCurrency = $sessionLogin_user->intLoggedinUserTrxCurrency;
$this->IsB2CSite = $sessionLogin_user->agencyDetails['IsB2CSite'];
if(!empty($this->intLoggedinUserAgencySysId)) {
$this->InfoSourceSysId = '2'; // Information Source is Agent //
}
}
public function indexAction(){
$post = $this->getRequest()->getPost();
//echo "<pre>";print_r($post);echo "</pre>";//exit;
$this->view->startCityName = $startCityName = isset($post['start_city_id'])?$post['start_city_name']: '';
$this->view->startCityId = $startCityId = isset($post['start_city_id'])?$post['start_city_id']: '';
$this->view->supplierName = $supplierName = isset($post['supplier_type'])?$post['supplier_type']: '';
$this->view->supplierId = $supplier_id = isset($post['supplier_id'])?$post['supplier_id']: '';
$this->view->IsB2CSite = $this->IsB2CSite;
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$objTransportsRoutes->strCondition = "";
$objTransportsRoutes->strConditionsear = "";
$objTransportsRoutes->strCondition .= "tb1.AgencySysId = ".$this->intLoggedinUserAgencySysId;
$objTransportsRoutes->strConditionsear .= "tb4.AgencySysId = ".$this->intLoggedinUserAgencySysId;
if(!empty($startCityId)){
$objTransportsRoutes->strCondition .= " AND tb1.StartCitySysId = ".$startCityId;
}
// if(!empty($supplier_id)){
// $objTransportsRoutes->strCondition .= " AND tb1.SupplierSysId = ".$supplier_id;
// }
if(!empty($startCityId)){
$objTransportsRoutes->strConditionsear .= " AND tb4.StartCitySysId = ".$startCityId;
}
if(!empty($supplier_id)){
$objTransportsRoutes->strConditionsear .= " AND tb1.SupplierSysId = ".$supplier_id;
}
$transportsRoutesListSearch = $objTransportsRoutes->transportsRoutesListSearch();
//echo "<pre>";print_r($transportsRoutesListSearch);echo "</pre>";//exit;
$strTransportsRoutesListSQL = $objTransportsRoutes->transportsRoutesList();
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_DbSelect($strTransportsRoutesListSQL));
$pageNumber = $this->_getParam('page',1);
$paginator->setCurrentPageNumber($pageNumber);
$paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
$this->view->arrTransportsRoutesList = $paginator;
}
public function activeWebsiteAction() {
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
if ($this->_request->isXmlHttpRequest()) {
$postData = $this->getRequest()->getPost();
$RouteSysId = $postData['RouteSysId'];
$status = $postData['status'];
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
if (isset($RouteSysId)) {
try {
$updateRouteData = array(
'IsWebsite' => $status,
);
$objIsWebsiteTrans = $objTransportsRoutes->editTransportsRouteData($RouteSysId,$updateRouteData);
if (!$objIsWebsiteTrans || $objIsWebsiteTrans != 1) {
$result_message = ['status' => false, 'message' => 'Oops something wrong!!!'];
echo Zend_Json::encode($result_message);
exit;
} else {
$result_message = ['status' => true, 'message' => 'Active successfully'];
echo Zend_Json::encode($result_message);
exit;
}
} catch (Exception $ex) {
$ex->getMessage();
}
} else {
$result_message = ['status' => false, 'message' => 'Oops there might be something wrong!!!'];
echo Zend_Json::encode($result_message);
exit;
}
}
}
public function addTransportsRouteAction(){
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$this->view->arrVehicleTypeList = $objTransportsRoutes->getAllVehicleTypeList();
$objCurrency = new Travel_Model_TblCurrency();
$this->view->arrCurrencyTypes = $objCurrency->getCurrencyTypes();
if ($this->_request->isXmlHttpRequest()) {
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$post = $this->getRequest()->getPost();
// echo "<pre>";print_r($post);exit;
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$routesCityIdArr = isset($post['routes_city_ids'])?$post['routes_city_ids']: '';
$routesCityIds = implode(',', $routesCityIdArr);
$routesNightsArr = isset($post['nights'])?$post['nights']: '';
$startCityId = isset($post['start_city_id'])?$post['start_city_id']: '';
$endCityId = isset($post['end_city_id'])?$post['end_city_id']: '';
$routeName = isset($post['route_name'])?$post['route_name']: '';
$Noofnights = isset($post['Noofnights'])?$post['Noofnights']: '';
$routesCityIds = isset($routesCityIds) ? $routesCityIds : '';
$routesCities = isset($post['route_cities'])?rtrim($post['route_cities'],", "): '';
$routesCities = str_replace(", ", "-", $routesCities);
$routeDesc = isset($post['route_desc'])?$post['route_desc']: '';
$currentDate = date('Y-m-d H:i:s');
$intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
$intLoggedinUserId = $this->intLoggedinUserId;
$Iswebsite = isset($post['Iswebsite'])?$post['Iswebsite']: 0;
// echo "<pre>";print_r($routesCityIds);die;
$routesCitiesName = $objTransportsRoutes->selectCityCovered($routesCityIds);
foreach ($routesCityIdArr as $keyId => $valueId) {
foreach ($routesCitiesName as $keyName => $valueName) {
if($valueId == $valueName['CityId']){
$finRoutesCitiesName[] = $valueName['Title'];
}
}
}
$finRoutesCitiesName = implode(',', $finRoutesCitiesName);
//Insert data array
$insertData = array(
'RouteName' => $routeName,
'Noofnights' => $Noofnights,
'RouteDestinationStr' => $finRoutesCitiesName,
'Description' => $routeDesc,
'SupplierSysId' => '0',
'AgencySysId' => $intLoggedinUserAgencySysId,
'StartCitySysId' => $startCityId,
'EndCitySysId' => $endCityId,
'UpdateDate' => $currentDate,
'CreateDate' => $currentDate,
'IsActive' => '1',
'IsMarkForDel' => '0',
'Iswebsite' => $Iswebsite
);
$intRouteSysId = $objTransportsRoutes->addTransportsRoute($insertData);
if(!empty($intRouteSysId)){
$arrIncludedCitiesIds = explode(",", $routesCityIds);
if(!empty($arrIncludedCitiesIds) ){
foreach($arrIncludedCitiesIds as $citykey => $cityId){
$cityIncludedData = array(
'RouteSysId' => $intRouteSysId,
'DestSysId' => trim($cityId),
'nights' => (int) ($routesNightsArr[$citykey]),
'UpdateDate' => $currentDate,
'CreateDate' => $currentDate,
'IsActive' => '1',
'IsMarkForDel' => '0'
);
// echo "<pre>";print_r($cityIncludedData);die;
try {
$objTransportsRoutes->addTransportsRoutesCityIncluded($cityIncludedData);
} catch(Zend_Exception $e) {
$e->getMessage();
}
}
}
// Add Vehicles in route.....
//echo count($post['route_cost']);exit;
if (!empty($post['route_cost'])) {
for ($i = 0; $i < count($post['route_cost']); $i++) {
$vehicle_type_id = isset($post['vehicle_type_id'][$i]) ? trim($post['vehicle_type_id'][$i]) : '';
$vehicle_id = isset($post['vehicle_name_id'][$i]) ? trim($post['vehicle_name_id'][$i]) : '';
$carCapacity = isset($post['car_capacity'][$i]) ? trim($post['car_capacity'][$i]) : '';
$currency_type = isset($post['currency_type'][$i]) ? trim($post['currency_type'][$i]) : '';
$routeCost = isset($post['route_cost'][$i]) ? trim($post['route_cost'][$i]) : '';
$supplierId = isset($post['supplier_id'][$i])?$post['supplier_id'][$i]: '';
$VehicleData = array(
'RouteSysId' => $intRouteSysId,
'VehicleSysId' => $vehicle_id,
'VehicleTypeSysId' => $vehicle_type_id,
'SupplierSysId' => $supplierId,
'CurrencyType' => $currency_type,
'Cost' => $routeCost,
'Capacity' => $carCapacity,
'UpdateDate' => $currentDate,
'CreateDate' => $currentDate,
'IsActive' => '1',
'IsMarkForDel' => '0'
);
$objTransportsRoutes->addRoutesVehicles($VehicleData);
}
}
// Add Vehicles in route ends.....
if (trim($_SESSION['sessionLogin_user']['agencyDetails']['IsB2CSite']) == 1 && $Iswebsite == 1) {
$URL=trim($_SESSION['sessionLogin_user']['agencyDetails']['Url']).'gtxwebservices/index/transports-route';
$this->postFields = "";
$this->postFields .= "&AgencySysId=" . Travel_Model_AgencyAuth::getIdentity()->AgencySysId;
$this->postFields .= "&packageId=$RouteSysId";
$writeLogObj = new Payment_Model_Payment();
$writeLogObj->writeLog($this->postFields . "\n");
try {
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $URL);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_POST, 1);
//if (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') {
// SSL connection
// curl_setopt($ch, CURLOPT_PORT, 443);
// curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
// curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
// }
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $this->postFields);
$output = curl_exec($ch);
//echo "<pre>";print_r($output);exit;
$writeLogObj->writeLog($output . "\n");
curl_close($ch);
} catch (Zend_Exception $ex) {
$response = array('success' => false, 'msg' => $e->getMessage());
echo json_encode($response);
exit;
}
}
}
$response = array('success' => true,'msg' => "Transport Route Added Successfully.");
echo json_encode($response);
exit;
}
}
public function editTransportsRouteAction(){
if ($this->_request->isXmlHttpRequest()) {
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$post = $this->getRequest()->getPost();
// echo "<pre>";print_r($post);exit;
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$routesCityIdArr = isset($post['routes_city_ids'])?$post['routes_city_ids']: '';
$routesCityIds = implode(',', $routesCityIdArr);
$routesNightsArr = isset($post['nights'])?$post['nights']: '';
$RouteSysId = isset($post['id'])?$post['id']: '';
$startCityId = isset($post['start_city_id'])?$post['start_city_id']: '';
$endCityId = isset($post['end_city_id'])?$post['end_city_id']: '';
$routeName = isset($post['route_name'])?$post['route_name']: '';
$Noofnights = isset($post['Noofnights'])?$post['Noofnights']: '';
$routesCityIds = isset($routesCityIds) ? $routesCityIds : '';
$routesCities = isset($post['route_cities'])?rtrim($post['route_cities'],", "): '';
$routesCities = str_replace(", ", "-", $routesCities);
$routeDesc = isset($post['route_desc'])?$post['route_desc']: '';
$currentDate = date('Y-m-d H:i:s');
$intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
$intLoggedinUserId = $this->intLoggedinUserId;
$Iswebsite = isset($post['Iswebsite'])?$post['Iswebsite']: 0;
$routesCitiesName = $objTransportsRoutes->selectCityCovered($routesCityIds);
foreach ($routesCityIdArr as $keyId => $valueId) {
foreach ($routesCitiesName as $keyName => $valueName) {
if($valueId == $valueName['CityId']){
$finRoutesCitiesName[] = $valueName['Title'];
}
}
}
$finRoutesCitiesName = implode(',', $finRoutesCitiesName);
// echo "<pre>";print_r($finRoutesCitiesName);die;
//Insert data array
$updateRouteData = array(
'RouteName' => $routeName,
'Noofnights' => $Noofnights,
'RouteDestinationStr' => $finRoutesCitiesName,
'Description' => $routeDesc,
'SupplierSysId' => '0',
'StartCitySysId' => $startCityId,
'EndCitySysId' => $endCityId,
'UpdateDate' => $currentDate,
'Iswebsite' => $Iswebsite
);
$objTransportsRoutes->editTransportsRoute($RouteSysId,$updateRouteData);
if(!empty($RouteSysId)){
$arrIncludedCitiesIds = explode(",", $routesCityIds);
if(!empty($arrIncludedCitiesIds) ){
$objTransportsRoutes->deleteTransportsRoutesCityIncluded($RouteSysId);
foreach($arrIncludedCitiesIds as $citykey => $cityId){
$cityIncludedData = array(
'RouteSysId' => $RouteSysId,
'DestSysId' => trim($cityId),
'nights' => (int) ($routesNightsArr[$citykey]),
'UpdateDate' => $currentDate,
'CreateDate' => $currentDate,
'IsActive' => '1',
'IsMarkForDel' => '0'
);
$objTransportsRoutes->addTransportsRoutesCityIncluded($cityIncludedData);
}
}
// Add Vehicles in route.....
//echo count($post['route_cost']);exit;
if (!empty($post['route_cost']) ) {
for ($i = 0; $i < count($post['route_cost']); $i++) {
$vehicle_type_id = isset($post['vehicle_type_id'][$i]) ? $post['vehicle_type_id'][$i] : '';
$vehicle_id = isset($post['vehicle_name_id'][$i]) ? $post['vehicle_name_id'][$i] : '';
$carCapacity = isset($post['car_capacity'][$i]) ? $post['car_capacity'][$i] : '';
$routeCost = isset($post['route_cost'][$i]) ? $post['route_cost'][$i] : '';
$currency_type = isset($post['currency_type'][$i]) ? trim($post['currency_type'][$i]) : '';
$supplierId = isset($post['supplier_id'][$i])?$post['supplier_id'][$i]: '';
$VehicleData = array(
'RouteSysId' => $RouteSysId,
'VehicleSysId' => $vehicle_id,
'VehicleTypeSysId' => $vehicle_type_id,
'SupplierSysId' => $supplierId,
'CurrencyType' => $currency_type,
'Cost' => $routeCost,
'Capacity' => $carCapacity,
'UpdateDate' => $currentDate,
'CreateDate' => $currentDate,
'IsActive' => '1',
'IsMarkForDel' => '0'
);
$objTransportsRoutes->addRoutesVehicles($VehicleData);
}
}
if (trim($_SESSION['sessionLogin_user']['agencyDetails']['IsB2CSite']) == 1 && $Iswebsite == 1) {
$URL=trim($_SESSION['sessionLogin_user']['agencyDetails']['Url']).'gtxwebservices/index/transports-route';
$this->postFields = "";
$this->postFields .= "&AgencySysId=" . Travel_Model_AgencyAuth::getIdentity()->AgencySysId;
$this->postFields .= "&packageId=$RouteSysId";
$writeLogObj = new Payment_Model_Payment();
$writeLogObj->writeLog($this->postFields . "\n");
try {
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $URL);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_POST, 1);
//if (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') {
// SSL connection
// curl_setopt($ch, CURLOPT_PORT, 443);
// curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
// curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
// }
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $this->postFields);
$output = curl_exec($ch);
//echo "<pre>";print_r($output);exit;
$writeLogObj->writeLog($output . "\n");
curl_close($ch);
} catch (Zend_Exception $ex) {
$response = array('success' => false, 'msg' => $e->getMessage());
echo json_encode($response);
exit;
}
}
}
$response = array('success'=>true,'msg' => "Transport Route Updated Successfully.");
echo json_encode($response);
exit;
}else{
$this->view->intRouteId = $intRouteId = base64_decode($this->getRequest()->getParam('id'));
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$this->view->arrTransportsRouteDetails = $objTransportsRoutes->getTransportsRouteDetailsById($intRouteId);
$objCurrency = new Travel_Model_TblCurrency();
$this->view->arrCurrencyTypes = $objCurrency->getCurrencyTypes();
// Route Cities Included...
$arrTransportsRoutesCityIncluded = $objTransportsRoutes->getTransportsRoutesCityIncluded($intRouteId);
// echo "<pre>";print_r($arrTransportsRoutesCityIncluded);exit;
$strCities = "";
$strCitiesIds = "";
if(!empty($arrTransportsRoutesCityIncluded) ){
foreach ($arrTransportsRoutesCityIncluded as $value){
$strCities .= $value['CityName'].", ";
$strCitiesIds .= $value['DestSysId'].",";
}
}
$this->view->arrTransportsRoutesCityIncluded = $arrTransportsRoutesCityIncluded;
$this->view->strCities = $strCities;
$this->view->strCitiesIds = rtrim($strCitiesIds,",");
// Route Cities Included...
// Route Vehicles Included...
$arrTransportsRoutesVehiclesIncluded = $objTransportsRoutes->getTransportsRoutesVehiclesIncluded($intRouteId);
$this->view->arrTransportsRoutesVehiclesIncluded = $arrTransportsRoutesVehiclesIncluded;
// Route Vehicles Included...
$this->view->arrVehicleTypeList = $objTransportsRoutes->getAllVehicleTypeList();
}
}
public function deleteRouteVehicleAction(){
// disable layout...
$this->_helper->layout->disableLayout();
$intId = trim($this->getRequest()->getParam('RouteVechSysId'));
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$objTransportsRoutes->deleteTransportsRoutesVehiclesIncluded($intId);
$response = array('success'=>true,'msg' => "success");
echo json_encode($response);
exit;
}
public function deleteRecordAction(){
// disable layout...
$this->_helper->layout->disableLayout();
$intId = base64_decode($this->getRequest()->getParam('id'));// exit;
$data = array(
"IsMarkForDel" => 1
);
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$objTransportsRoutes->deleteTransportRoute($intId,$data);
$this->view->message = $this->_helper->flashMessenger->addMessage("Transport Route deleted successfully.");
$this->_redirect("/transports-route");
}
public function getVehicleListAction() {
/* Disable Layout */
$this->_helper->layout->disableLayout();
if($this->_request->isXmlHttpRequest()) {
$post = $this->getRequest()->getPost();
$intVehicleTypeSysId = isset($post['VehicleTypeSysId'])?$post['VehicleTypeSysId']:'0';
$str_vehicle = '';
if(!empty($intVehicleTypeSysId))
{
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$arrVehicleList = $objTransportsRoutes->getVehicleList($post['VehicleTypeSysId'],$this->intLoggedinUserAgencySysId);
if(!empty($arrVehicleList))
{
foreach($arrVehicleList as $arrVehicle)
{
$str_vehicle .= '<option data-capacity="'.trim($arrVehicle['Capacity']).'" value="'.trim($arrVehicle['VehSysId']).'">'.trim($arrVehicle['VehName']).' ('.trim($arrVehicle['IsAC']).')</option>';
}
} else {
$str_vehicle = '<option value="0">Select</option>';
}
} else {
$str_vehicle = '<option value="0">Select</option>';
}
echo $str_vehicle;
exit;
}
}
public function busRouteAction(){
$post = $this->getRequest()->getPost();
$intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$strBusTransportsRoutesListSQL = $objTransportsRoutes->busTransportsRoutesList($intLoggedinUserAgencySysId);
// $paginator = new Zend_Paginator(($strBusTransportsRoutesListSQL));
$paginator = Zend_Paginator::factory($strBusTransportsRoutesListSQL);
$pageNumber = $this->_getParam('page',1);
$paginator->setCurrentPageNumber($pageNumber);
$paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
$this->view->page = $pageNumber;
$this->view->per_page_record = GRID_PER_PAGE_RECORD_COUNT;
$this->view->arrTransportsRoutesList = $paginator;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
public function addBusRouteAction(){
$intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
if ($this->_request->isXmlHttpRequest()) {
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$post = $this->getRequest()->getPost();
$StartCitySysId = $post['start_city_id'];
$EndCitySysId = $post['end_city_id'];
$pickup_location_NameArr = array();
$currentDate = date('Y-m-d H:i:s');
$m = 1;
foreach ($post['pickup_location_Name'] as $pickkey => $pickvalue) {
if(trim($pickvalue) != ''){
$pickup_location_NameArr[][$StartCitySysId.'_'.$EndCitySysId.'_'.$m] = trim($pickvalue);
$m++;
}
}
$addDataArray = [
'AgencySysId' => $intLoggedinUserAgencySysId,
'busRouteName' => $post['busRouteName'],
'StartCitySysId' => $post['start_city_id'],
'EndCitySysId' => $post['end_city_id'],
'StartCityName' => $post['start_city_name'],
'EndCityName' => $post['end_city_name'],
'BusPickUpLocationsStr' => json_encode($pickup_location_NameArr),
'IsActive' => 1,
'IsMarkForDel' => 0,
'UpdateDate' => $currentDate,
'CreateDate' => $currentDate,
];
$BusRouteSysId = $objTransportsRoutes->addBusTransportRoute($addDataArray);
if($BusRouteSysId){
$response = array('success' => true,'msg' => "Bus Transport Route Added Successfully.");
echo json_encode($response);
exit;
}
}
}
public function editBusRouteAction() {
$intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$this->view->BusRouteSysId = $BusRouteSysId = base64_decode($this->getRequest()->getParam('id'));
if ($this->_request->isXmlHttpRequest()) {
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$post = $this->getRequest()->getPost();
$StartCitySysId = $post['start_city_id'];
$EndCitySysId = $post['end_city_id'];
$pickup_location_NameArr = array();
$currentDate = date('Y-m-d H:i:s');
$m = 1;
foreach ($post['pickup_location_Name'] as $pickkey => $pickvalue) {
if(trim($pickvalue) != ''){
$pickup_location_NameArr[][$StartCitySysId.'_'.$EndCitySysId.'_'.$m] = trim($pickvalue);
$m++;
}
}
$editDataArray = [
'AgencySysId' => $intLoggedinUserAgencySysId,
'busRouteName' => $post['busRouteName'],
'StartCitySysId' => $post['start_city_id'],
'EndCitySysId' => $post['end_city_id'],
'StartCityName' => $post['start_city_name'],
'EndCityName' => $post['end_city_name'],
'BusPickUpLocationsStr' => json_encode($pickup_location_NameArr),
'UpdateDate' => $currentDate,
];
$BusRouteSysIdres = $objTransportsRoutes->updateBusTransportsRouteData($post['BusRouteSysId'],$editDataArray);
if($BusRouteSysIdres){
$response = array('success' => true,'msg' => "Bus Transport Route Updated Successfully.");
echo json_encode($response);
exit;
}
}else{
$editBusRouteData = $objTransportsRoutes->getBusTransportRouteDataById($intLoggedinUserAgencySysId,$BusRouteSysId);
$this->view->editBusRouteData = $editBusRouteData;
}
}
public function deleteBusRouteAction(){
// disable layout...
$this->_helper->layout->disableLayout();
$intId = base64_decode($this->getRequest()->getParam('id'));// exit;
$data = array(
"IsMarkForDel" => 1
);
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$objTransportsRoutes->deleteBusTransportRoute($intId,$data);
$this->view->message = $this->_helper->flashMessenger->addMessage("Transport Route deleted successfully.");
$this->_redirect("/transports-route/bus-route");
}
public function addPickupLocationTimeAction(){
$intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$this->view->BusRouteSysId = $BusRouteSysId = base64_decode($this->getRequest()->getParam('id'));
$objPackage = new Travel_Model_TblPackage();
if ($this->getRequest()->isPost()) {
$postData = $this->getRequest()->getPost();
$currentDate = date('Y-m-d H:i:s');
$CheckBusPickupLocationTimeData = $objTransportsRoutes->getBusPickupLocationTimeDataById($intLoggedinUserAgencySysId,$postData['BusRouteSysId']);
if(!empty($CheckBusPickupLocationTimeData) ){
$BusRouteSysId = $postData['BusRouteSysId'];
$updateArray = ['IsMarkForDel' => 1];
$where = "BusRouteSysId = $BusRouteSysId AND AgencySysId = $intLoggedinUserAgencySysId";
$updateData = array('IsMarkForDel' => '1');
$objPackage->updateData('TB_Agency_Transport_bus_Pickup_Time', $updateData, $where);
}
$m = 1;
foreach($postData['pickupLocationName'] as $pickKey => $pickValue){
$mKey = 'pickup_time'.$m;
foreach($postData[$mKey] as $timeKey => $timeValue){
$insertArray = [
'AgencySysId' =>$intLoggedinUserAgencySysId,
'BusRouteSysId' =>$postData['BusRouteSysId'],
'busRouteName' =>$postData['busRouteName'],
'pickupLocationName' =>trim($pickValue),
'pickupLocationTime' =>$timeValue,
'CreateTime' =>$currentDate,
'IsActive' =>1,
'IsMarkForDel' =>0,
'Sequence' => (int) $postData['Sequence'][$pickKey],
];
$BusPickupTimeSysId[] = $objPackage->insertData('TB_Agency_Transport_bus_Pickup_Time', $insertArray);
}
$m++;
}
if(!empty($BusPickupTimeSysId)){
$this->_helper->flashMessenger->addMessage("Content Save Successfully.");
$this->_redirect('/transports-route/bus-route');
}
}else{
$BusRouteData = $objTransportsRoutes->getBusTransportRouteDataById($intLoggedinUserAgencySysId,$BusRouteSysId);
$BusPickUpLocationsStr = json_decode($BusRouteData['BusPickUpLocationsStr'],1);
$finalLocationArray = array();
$i = 1;
foreach ($BusPickUpLocationsStr as $pickkey => $pickvalue) {
$finkey = $BusRouteData["StartCitySysId"].'_'.$BusRouteData["EndCitySysId"].'_'.$i;
$finalLocationArray[] = $pickvalue[$finkey];
$i++;
}
$BusPickupLocationTimeData = $objTransportsRoutes->getBusPickupLocationTimeDataById($intLoggedinUserAgencySysId,$BusRouteSysId);
$BusPickupLocationTimeDataArray = array();
$myArray = array();
$i = 1;
foreach($BusPickupLocationTimeData as $timeKey => $timeValue){
if(!in_array(trim($timeValue['Sequence']), $myArray)){
$myArray[] = trim($timeValue['Sequence']);
$i = 0;
}else{
$i++;
}
$BusPickupLocationTimeDataArray[$i][] = [
'pickupLocationTime' =>$timeValue['pickupLocationTime']->format('H:i'),
];
}
// echo "<pre>";print_r($BusPickupLocationTimeDataArray);die;
$this->view->BusPickupLocationTimeDataArray = $BusPickupLocationTimeDataArray;
$this->view->finalLocationArray = $finalLocationArray;
$this->view->busRouteName = $BusRouteData['busRouteName'];
}
}
public function addMorePickuptimeRowAction(){
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$params = $this->getRequest()->getParams();
$count =$params['count'] +1;
// echo "<pre>";print_r($params);die;
$returnOption = '<tr id="remove_datesTr'.$count.'"><script src="/public/assets/js/pages/pickerToolFlight.js"></script>';
for($m=1;$m<=$params['count_locations'];$m++){
$returnOption .= '<td><input type="text" name="pickup_time'.$m.'[]" id="pickup_timeId'.$m.$count.'" class="form-control dateTimePickerm1" placeholder="Select Time"><span class="errorMsgAll errorMsg'.$m.$count.'"></span></td>';
}
$returnOption .= '<td><a data-original-title="Delete" class="btn btn-danger tooltipLink" data-toggle="tooltip" data-placement="top" title="" onclick="removeLocationTimeTr('.$count.')" ><i class="fa fa-trash-o"></i></a></td></tr>';
echo $returnOption;exit;
}
public function getPickupLocationAndTimeAction(){
$intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
$objTransportsRoutes = new Travel_Model_TblTransportsRoutes();
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$params = $this->getRequest()->getParams();
$BusRouteSysId = $params['BusRouteSysId'];
$PickupLocationData = $objTransportsRoutes->getBusPickupLocationTimeDataById($intLoggedinUserAgencySysId,$BusRouteSysId);
// echo "<pre>";print_r($PickupLocationData);die;
$PickupLocationDataArray = array();
$html = '';
foreach($PickupLocationData as $key => $value){
$PickupLocationDataArray[$value['Sequence']]['pickupLocationName'] = $value['pickupLocationName'];
$PickupLocationDataArray[$value['Sequence']]['pickupLocationTime'][] = $value['pickupLocationTime']->format('H:i');
}
$i = 1;
foreach ($PickupLocationDataArray as $pickkey => $pickvalue) {
$timeHtml = '';
foreach($pickvalue['pickupLocationTime'] as $timekey => $timevalue){
$timeHtml .= ' <input type="checkbox" name="LocationTime'.$i.'[]" value="'.$timevalue.'" checked> '.$timevalue;
}
$html .= '<input type="hidden" name="pickupLocationName[]" value="'.$pickvalue['pickupLocationName'].'">'.$pickvalue['pickupLocationName'].' (Time : '.$timeHtml.')<br>';
$i++;
}
$html .= '';
echo $html;exit;
// echo "<pre>";print_r($PickupLocationDataArray);die;
}
}