| 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/models/ |
Upload File : |
<?php
class Travel_Model_TblBus
{
private $db = NULL;
public $intId = NULL;
public $searchArr = NULL;
public $baseUrl = Null;
/* * ************************************ */
public function __construct()
{
$request = Zend_Controller_Front::getInstance()->getRequest();
$this->baseUrl = $request->getScheme() . '://' . $request->getHttpHost();
$this->db = Zend_Db_Table::getDefaultAdapter();
}
public function __destruct()
{
$this->db->closeConnection();
}
public function CheckAction (){
if ($checkAccuratePrice == 0) {
$return = true;
if ($roomjson) {
if (is_array($roomjsonArray)) {
$twinSharing = $tripleSharing = $getHexaRoom = $getQuintRoom = $getQuadRoom = $getExtraBedChild = $getExtraWithoutBedAdult = $getExtraBedAdult = $getSingleOccAdult = 0;
foreach ($roomjsonArray as $jsonArray) {
if (isset($jsonArray['adult_type']) && $jsonArray['adult_type'] == 'twin') {
$twinSharing = $jsonArray['Adult'];
}
if (isset($jsonArray['adult_type']) && $jsonArray['adult_type'] == 'triple') {
$tripleSharing = $jsonArray['Adult'];
}
if (isset($jsonArray['adult_type']) && $jsonArray['adult_type'] == 'quad') {
$getQuadRoom = $getQuadRoom + 1;
}
if (isset($jsonArray['adult_type']) && $jsonArray['adult_type'] == 'quint') {
$getQuintRoom = $getQuintRoom + 1;
}
if (isset($jsonArray['adult_type']) && $jsonArray['adult_type'] == 'hexa') {
$getHexaRoom = $getHexaRoom + 1;
}
if (isset($jsonArray['AdultBedType']) && $jsonArray['AdultBedType'] == 'extrabed') {
$getExtraBedAdult = $getExtraBedAdult + 1;
}
if (isset($jsonArray['adult_type']) && $jsonArray['adult_type'] == 'single') {
$getSingleOccAdult = $getSingleOccAdult + 1;
}
if (isset($jsonArray['Child']) && $jsonArray['Child'] > 0) {
for ($c = 1; $c <= $jsonArray['Child']; $c++) {
if (isset($jsonArray['ChildBedType_' . $c]) && $jsonArray['ChildBedType_' . $c] == 'extrabed') {
$getExtraBedChild = $getExtraBedChild + 1;
}
if (isset($jsonArray['ChildBedType_' . $c]) && $jsonArray['ChildBedType_' . $c] == 'withoutbed') {
$getExtraWithoutBedAdult = $getExtraWithoutBedAdult + 1;
}
}
}
}
if (($getQuadRoom > 0) || ($getQuintRoom > 0) || ($getHexaRoom > 0)) {
if ($IsquadPrice == 0) {
$return = false;
}
}
}
}
if ($return) {
$resultPackage = $this->getPackRateRowWiseNotAccurate($packid, $tripdate, $MarketPlaceId, $adultOld);
if (!empty($resultPackage)) {
if ($getSingleOccAdult > 0) {
if (isset($resultPackage[0]['CostSO']) && ($resultPackage[0]['CostSO'])) {
$return = true;
} else {
$return = false;
}
} else {
$return = true;
}
if ($getExtraBedAdult > 0 || $tripleSharing > 0) {
if (isset($resultPackage[0]['AdultCostExtraBed']) && ($resultPackage[0]['AdultCostExtraBed'])) {
$getExtraBed = true;
} else {
$getExtraBed = false;
}
} else {
$getExtraBed = true;
}
if ($getExtraWithoutBedAdult > 0) {
if (isset($resultPackage[0]['CostWithoutBed']) && ($resultPackage[0]['CostWithoutBed'])) {
$CostWithoutBed = true;
} else {
$CostWithoutBed = false;
}
} else {
$CostWithoutBed = true;
}
if ($ChildCount > 0) {
if (isset($resultPackage[0]['CostExtraBed']) && ($resultPackage[0]['CostExtraBed'])) {
$CostExtraBed = true;
} else {
$CostExtraBed = false;
}
} else {
$CostExtraBed = true;
}
if ($InfentCount > 0) {
if (isset($resultPackage[0]['CostInfent']) && ($resultPackage[0]['CostInfent'])) {
$infent_return = true;
} else {
$infent_return = false;
}
} else {
$infent_return = true;
}
if ($getQuadRoom > 0) {
if (isset($resultPackage[0]['CostQuad']) && ($resultPackage[0]['CostQuad'])) {
$cost_quad_return = true;
} else {
$cost_quad_return = false;
}
} else {
$cost_quad_return = true;
}
if ($getQuintRoom > 0) {
if (isset($resultPackage[0]['CostQuint']) && ($resultPackage[0]['CostQuint'])) {
$cost_quint_return = true;
} else {
$cost_quint_return = false;
}
} else {
$cost_quint_return = true;
}
if ($getHexaRoom > 0) {
if (isset($resultPackage[0]['CostHexa']) && ($resultPackage[0]['CostHexa'])) {
$cost_hexa_return = true;
} else {
$cost_hexa_return = false;
}
} else {
$cost_hexa_return = true;
}
} else {
$return = false;
}
if ($return && $infent_return && $CostExtraBed && $CostWithoutBed && $getExtraBed && $cost_quad_return && $cost_hexa_return && $cost_quint_return) {
return $resultPackage;
} else {
return array();
}
} else {
return array();
}
} else {
$return = false;
if ($roomjson) {
$roomjsonArray = json_decode($roomjson, true);
if (is_array($roomjsonArray)) {
$tripleSharing = $getHexaRoom = $getQuintRoom = $getQuadRoom = $getExtraBedChild = $getExtraWithoutBedAdult = $getExtraBedAdult = $getSingleOccAdult = 0;
foreach ($roomjsonArray as $jsonArray) {
if (isset($jsonArray['adult_type']) && $jsonArray['adult_type'] == 'triple') {
$tripleSharing = $jsonArray['Adult'];
}
if (isset($jsonArray['adult_type']) && $jsonArray['adult_type'] == 'quad') {
$getQuadRoom = $getQuadRoom + 1;
}
if (isset($jsonArray['adult_type']) && $jsonArray['adult_type'] == 'quint') {
$getQuintRoom = $getQuintRoom + 1;
}
if (isset($jsonArray['adult_type']) && $jsonArray['adult_type'] == 'hexa') {
$getHexaRoom = $getHexaRoom + 1;
}
if (isset($jsonArray['AdultBedType']) && $jsonArray['AdultBedType'] == 'extrabed') {
$getExtraBedAdult = $getExtraBedAdult + 1;
}
if (isset($jsonArray['Adult']) && $jsonArray['Adult'] == 1 && $IsSharingPrice == 0) {
$getSingleOccAdult = $getSingleOccAdult + 1;
}
if (isset($jsonArray['Child']) && $jsonArray['Child'] > 0) {
for ($c = 1; $c <= $jsonArray['Child']; $c++) {
if (isset($jsonArray['ChildBedType_' . $c]) && $jsonArray['ChildBedType_' . $c] == 'extrabed') {
$getExtraBedChild = $getExtraBedChild + 1;
}
if (isset($jsonArray['ChildBedType_' . $c]) && $jsonArray['ChildBedType_' . $c] == 'withoutbed') {
$getExtraWithoutBedAdult = $getExtraWithoutBedAdult + 1;
}
}
}
}
if (($getQuadRoom > 0) || ($getQuintRoom > 0) || ($getHexaRoom > 0)) {
if ($IsquadPrice == 0) {
return array();
}
}
$AdultCount = (int) array_sum((array_column($roomjsonArray, 'Adult')));
$ChildCount = (int) array_sum((array_column($roomjsonArray, 'Child')));
$InfentCount = (int) array_sum((array_column($roomjsonArray, 'Infant')));
$totalAdult = 0;
if ((int) $AdultCount > 2) {
if (($AdultCount % 2) == 1 && $getExtraBedAdult > 0) {
$totalAdult = $AdultCount - 1;
} else {
$totalAdult = $AdultCount;
}
} else {
$totalAdult = 2;
}
$cond = '';
if ($MarketPlaceId != '') {
$cond = " AND MarketPlaceId=" . $MarketPlaceId . "";
}
$sqlPackage = "SELECT TOP 1 * FROM TB_TravelPlan_Rate as TBTPMWR WHERE PAX = '" . $totalAdult . "' AND TPSysId = '" . @$packid . "' AND CostDO is not null AND IsMarkForDel = '0' AND IsActive = '1' AND '$tripdate' BETWEEN CAST(TBTPMWR.StartDate AS DATE) AND CAST(TBTPMWR.ValidTill AS DATE) $cond ORDER BY Pax DESC";
$resultPackage = $this->db->query($sqlPackage)->fetchAll();
if (!empty($resultPackage)) {
if ($getSingleOccAdult > 0) {
if (isset($resultPackage[0]['CostSO']) && ($resultPackage[0]['CostSO'])) {
$return = true;
} else {
$return = false;
}
} else {
$return = true;
}
if ($getExtraBedAdult > 0 || $tripleSharing > 0) {
if (isset($resultPackage[0]['AdultCostExtraBed']) && ($resultPackage[0]['AdultCostExtraBed'])) {
$getExtraBed = true;
} else {
$getExtraBed = false;
}
} else {
$getExtraBed = true;
}
if ($getExtraWithoutBedAdult > 0) {
if (isset($resultPackage[0]['CostWithoutBed']) && ($resultPackage[0]['CostWithoutBed'])) {
$CostWithoutBed = true;
} else {
$CostWithoutBed = false;
}
} else {
$CostWithoutBed = true;
}
if ($ChildCount > 0) {
if (isset($resultPackage[0]['CostExtraBed']) && ($resultPackage[0]['CostExtraBed'])) {
$CostExtraBed = true;
} else {
$CostExtraBed = false;
}
} else {
$CostExtraBed = true;
}
if ($InfentCount > 0) {
if (isset($resultPackage[0]['CostInfent']) && ($resultPackage[0]['CostInfent'])) {
$infent_return = true;
} else {
$infent_return = false;
}
} else {
$infent_return = true;
}
if ($getQuadRoom > 0) {
if (isset($resultPackage[0]['CostQuad']) && ($resultPackage[0]['CostQuad'])) {
$cost_quad_return = true;
} else {
$cost_quad_return = false;
}
} else {
$cost_quad_return = true;
}
if ($getQuintRoom > 0) {
if (isset($resultPackage[0]['CostQuint']) && ($resultPackage[0]['CostQuint'])) {
$cost_quint_return = true;
} else {
$cost_quint_return = false;
}
} else {
$cost_quint_return = true;
}
if ($getHexaRoom > 0) {
if (isset($resultPackage[0]['CostHexa']) && ($resultPackage[0]['CostHexa'])) {
$cost_hexa_return = true;
} else {
$cost_hexa_return = false;
}
} else {
$cost_hexa_return = true;
}
} else {
$return = false;
}
if ($return && $infent_return && $CostExtraBed && $CostWithoutBed && $getExtraBed && $cost_quad_return && $cost_hexa_return && $cost_quint_return) {
return $resultPackage;
} else {
return array();
}
} else {
return array();
}
} else {
return array();
}
}
}
}