| 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/modules/webservice/controllers/ |
Upload File : |
<?php
class Webservice_CreditBalanceController extends Catabatic_ValidateCustomer
{
public function init()
{
parent::init();
header("Content-Type: application/json; charset=UTF-8");
header("Access-Control-Allow-Methods: POST");
header("Access-Control-Max-Age: 3600");
header("Access-Control-Allow-Headers: Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With");
$this->paymentMdl = new Payment_Model_Payment();
}
private function getDecrypt($input)
{
$inputKey = Catabatic_Helper::getEncrytInputKey();
$iv = Catabatic_Helper::getEncrytIV();
$blockSize = Catabatic_Helper::getEncrytBlockKey();
$aes = new Travel_Model_Encrytion($input, $inputKey, $iv, $blockSize);
return $enc = $aes->decrypt();
}
private function getEncrypt($input)
{
$inputKey = Catabatic_Helper::getEncrytInputKey();
$iv = Catabatic_Helper::getEncrytIV();
$blockSize = Catabatic_Helper::getEncrytBlockKey();
$aes = new Travel_Model_Encrytion($input, $inputKey, $iv, $blockSize);
return $enc = $aes->encrypt();
}
public function getBalanceAction()
{
$this->view->layout()->disableLayout();
$returnArray = array();
$cheditBalanceModel = new Travel_Model_CreditBalance();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getPost();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
if ($B2BAgencySysIdKey != '' && $B2CAgencySysIdKey != '') {
$getBalanceArray = $cheditBalanceModel->getBalance($B2BAgencySysIdKey, $B2CAgencySysIdKey);
$getBalance = isset($getBalanceArray[0]['BalanceAmount']) ? $getBalanceArray[0]['BalanceAmount'] : '0';
http_response_code(200);
$returnArray = array("status" => True, "creditBalance" => $getBalance, "ortherData" => $getBalanceArray, "message" => "");
} else {
http_response_code(500);
$returnArray = array("status" => False, "creditBalance" => 0, "ortherData" => array(), "message" => "Please check requested parameter");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "creditBalance" => 0, "ortherData" => array(), "message" => "Please use the post method");
}
echo json_encode($returnArray);
exit;
}
public function updateCreditBalanceAction()
{
$currentDate = date("Y-m-d H:i:s");
$this->view->layout()->disableLayout();
$returnArray = array();
$cheditBalanceModel = new Travel_Model_CreditBalance();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getPost();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$Remark = isset($requestPerameter['Remark']) ? $requestPerameter['Remark'] : '';
$Amoout = isset($requestPerameter['Amount']) ? $requestPerameter['Amount'] : '';
$CurrencyType = isset($requestPerameter['CurrencyType']) ? $requestPerameter['CurrencyType'] : '1';
$PlanType = isset($requestPerameter['PlanType']) ? $requestPerameter['PlanType'] : '';
$UserSysId = isset($requestPerameter['UserSysId']) ? $requestPerameter['UserSysId'] : 0;
$PaymentMode = isset($requestPerameter['PaymentMode']) ? $requestPerameter['PaymentMode'] : 0;
$RefrenceNo = isset($requestPerameter['RefrenceNo']) ? $requestPerameter['RefrenceNo'] : '';
if ($B2BAgencySysIdKey != '' && $B2CAgencySysIdKey != '') {
$getBalanceArray = $cheditBalanceModel->getBalanceOtherInfo($B2BAgencySysIdKey, $B2CAgencySysIdKey);
$AgencySysId = isset($getBalanceArray[0]['AgencySysId']) ? $getBalanceArray[0]['AgencySysId'] : 0;
$checkWallet = $cheditBalanceModel->getCreditSysId($AgencySysId);
if (!empty($checkWallet)) {
$IsActive = isset($checkWallet[0]['IsActive']) ? $checkWallet[0]['IsActive'] : 0;
if ($IsActive == 1) {
$CreditSysId = isset($checkWallet[0]['CreditSysId']) ? $checkWallet[0]['CreditSysId'] : 0;
$getBalance = isset($getBalanceArray[0]['BalanceAmount']) ? $getBalanceArray[0]['BalanceAmount'] : 0;
if ($getBalance >= $Amoout) {
$editCreditTable = array('BalanceAmount' => new Zend_Db_Expr("BalanceAmount - $Amoout"));
try {
$whereEditCreditInfo = array('AgencySysId =?' => $AgencySysId);
$this->paymentMdl->updateTable("TB_Agency_Credit", $editCreditTable, $whereEditCreditInfo);
$getBalanceArray = $cheditBalanceModel->getBalanceOtherInfo($B2BAgencySysIdKey, $B2CAgencySysIdKey);
$getBalance = isset($getBalanceArray[0]['BalanceAmount']) ? $getBalanceArray[0]['BalanceAmount'] : 0;
$CreditAmount = isset($getBalanceArray[0]['CreditAmount']) ? $getBalanceArray[0]['CreditAmount'] : 0;
$Amount = isset($getBalanceArray[0]['Amount']) ? $getBalanceArray[0]['Amount'] : 0;
$CreditDays = isset($getBalanceArray[0]['CreditDays']) ? $getBalanceArray[0]['CreditDays'] : 0;
$GUID = $this->GUID();
$saveHistoryData = [
'TrxId' => $GUID,
'AgencySysId' => $AgencySysId,
'CreditSysId' => $CreditSysId,
'IsCredit' => 2,
'PlanType' => $PlanType,
'CurrencyType' => $CurrencyType,
'PaymentMode' => $PaymentMode,
'RefrenceNo' => $RefrenceNo,
'BalanceAmount' => $getBalance,
'CreditAmount' => $CreditAmount,
'Amount' => $Amoout,
'CreditDays' => $CreditDays,
'CreditDate' => $currentDate,
'UserSysId' => $UserSysId,
'Remark' => $Remark,
'OTPCode' => 0,
'TrxType' => 0, // minus
'CodeValidFrom' => $currentDate,
'CodeValidTo' => $currentDate,
'CreateDate' => $currentDate,
'UpdateDate' => $currentDate,
'IsMarkForDel' => 0,
'IsActive' => 1,
];
$this->paymentMdl->insertTable("TB_Agency_Credit_History", $saveHistoryData);
http_response_code(200);
$returnArray = array("status" => True, "TransactionId" => $GUID, "message" => "");
} catch (Zend_Exception $e) {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => $e->getMessage());
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Balance is not sufficient. Please contact to Administrator.");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Your Wallet is Inactive");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Balance is not sufficient. Please contact to Administrator.");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please check requested parameter");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please use the post method");
}
echo json_encode($returnArray);
exit;
}
public function updateCreditBalanceForOfflineRequestAction()
{
$currentDate = date("Y-m-d H:i:s");
$this->view->layout()->disableLayout();
$returnArray = array();
$cheditBalanceModel = new Travel_Model_CreditBalance();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getPost();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$Remark = isset($requestPerameter['Remark']) ? $requestPerameter['Remark'] : '';
$Amoout = isset($requestPerameter['Amount']) ? $requestPerameter['Amount'] : '';
$CurrencyType = isset($requestPerameter['CurrencyType']) ? $requestPerameter['CurrencyType'] : '1';
$PlanType = isset($requestPerameter['PlanType']) ? $requestPerameter['PlanType'] : '';
$UserSysId = isset($requestPerameter['UserSysId']) ? $requestPerameter['UserSysId'] : 0;
$PaymentMode = isset($requestPerameter['PaymentMode']) ? $requestPerameter['PaymentMode'] : 0;
$RefrenceNo = isset($requestPerameter['RefrenceNo']) ? $requestPerameter['RefrenceNo'] : '';
$IsPayLater = isset($requestPerameter['IsPayLater']) ? $requestPerameter['IsPayLater'] : true;
if ($B2BAgencySysIdKey != '' && $B2CAgencySysIdKey != '') {
$getBalanceArray = $cheditBalanceModel->getBalanceOtherInfo($B2BAgencySysIdKey, $B2CAgencySysIdKey);
$AgencySysId = isset($getBalanceArray[0]['AgencySysId']) ? $getBalanceArray[0]['AgencySysId'] : 0;
$checkWallet = $cheditBalanceModel->getCreditSysId($AgencySysId);
if (!empty($checkWallet)) {
$IsActive = isset($checkWallet[0]['IsActive']) ? $checkWallet[0]['IsActive'] : 0;
if ($IsActive == 1) {
$CreditSysId = isset($checkWallet[0]['CreditSysId']) ? $checkWallet[0]['CreditSysId'] : 0;
$getBalance = isset($getBalanceArray[0]['BalanceAmount']) ? $getBalanceArray[0]['BalanceAmount'] : 0;
if ($IsPayLater == true) {
$editCreditTable = array('BalanceAmount' => new Zend_Db_Expr("BalanceAmount - $Amoout"));
try {
$whereEditCreditInfo = array('AgencySysId =?' => $AgencySysId);
$this->paymentMdl->updateTable("TB_Agency_Credit", $editCreditTable, $whereEditCreditInfo);
$getBalanceArray = $cheditBalanceModel->getBalanceOtherInfo($B2BAgencySysIdKey, $B2CAgencySysIdKey);
$getBalance = isset($getBalanceArray[0]['BalanceAmount']) ? $getBalanceArray[0]['BalanceAmount'] : 0;
$CreditAmount = isset($getBalanceArray[0]['CreditAmount']) ? $getBalanceArray[0]['CreditAmount'] : 0;
$Amount = isset($getBalanceArray[0]['Amount']) ? $getBalanceArray[0]['Amount'] : 0;
$CreditDays = isset($getBalanceArray[0]['CreditDays']) ? $getBalanceArray[0]['CreditDays'] : 0;
$GUID = $this->GUID();
$saveHistoryData = [
'TrxId' => $GUID,
'AgencySysId' => $AgencySysId,
'CreditSysId' => $CreditSysId,
'IsCredit' => 2,
'PlanType' => $PlanType,
'CurrencyType' => $CurrencyType,
'PaymentMode' => $PaymentMode,
'RefrenceNo' => $RefrenceNo,
'BalanceAmount' => $getBalance,
'CreditAmount' => $CreditAmount,
'Amount' => $Amoout,
'CreditDays' => $CreditDays,
'CreditDate' => $currentDate,
'UserSysId' => $UserSysId,
'Remark' => $Remark,
'OTPCode' => 0,
'TrxType' => 0, // minus
'CodeValidFrom' => $currentDate,
'CodeValidTo' => $currentDate,
'CreateDate' => $currentDate,
'UpdateDate' => $currentDate,
'IsMarkForDel' => 0,
'IsActive' => 1,
];
$this->paymentMdl->insertTable("TB_Agency_Credit_History", $saveHistoryData);
http_response_code(200);
$returnArray = array("status" => True, "TransactionId" => $GUID, "message" => "");
} catch (Zend_Exception $e) {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => $e->getMessage());
}
} else {
if ($getBalance >= $Amoout) {
$editCreditTable = array('BalanceAmount' => new Zend_Db_Expr("BalanceAmount - $Amoout"));
try {
$whereEditCreditInfo = array('AgencySysId =?' => $AgencySysId);
$this->paymentMdl->updateTable("TB_Agency_Credit", $editCreditTable, $whereEditCreditInfo);
$getBalanceArray = $cheditBalanceModel->getBalanceOtherInfo($B2BAgencySysIdKey, $B2CAgencySysIdKey);
$getBalance = isset($getBalanceArray[0]['BalanceAmount']) ? $getBalanceArray[0]['BalanceAmount'] : 0;
$CreditAmount = isset($getBalanceArray[0]['CreditAmount']) ? $getBalanceArray[0]['CreditAmount'] : 0;
$Amount = isset($getBalanceArray[0]['Amount']) ? $getBalanceArray[0]['Amount'] : 0;
$CreditDays = isset($getBalanceArray[0]['CreditDays']) ? $getBalanceArray[0]['CreditDays'] : 0;
$GUID = $this->GUID();
$saveHistoryData = [
'TrxId' => $GUID,
'AgencySysId' => $AgencySysId,
'CreditSysId' => $CreditSysId,
'IsCredit' => 2,
'PlanType' => $PlanType,
'CurrencyType' => $CurrencyType,
'PaymentMode' => $PaymentMode,
'RefrenceNo' => $RefrenceNo,
'BalanceAmount' => $getBalance,
'CreditAmount' => $CreditAmount,
'Amount' => $Amoout,
'CreditDays' => $CreditDays,
'CreditDate' => $currentDate,
'UserSysId' => $UserSysId,
'Remark' => $Remark,
'OTPCode' => 0,
'TrxType' => 0, // minus
'CodeValidFrom' => $currentDate,
'CodeValidTo' => $currentDate,
'CreateDate' => $currentDate,
'UpdateDate' => $currentDate,
'IsMarkForDel' => 0,
'IsActive' => 1,
];
$this->paymentMdl->insertTable("TB_Agency_Credit_History", $saveHistoryData);
http_response_code(200);
$returnArray = array("status" => True, "TransactionId" => $GUID, "message" => "");
} catch (Zend_Exception $e) {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => $e->getMessage());
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Balance is not sufficient. Please contact to Administrator.");
}
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Your Wallet is Inactive");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Balance is not sufficient. Please contact to Administrator.");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please check requested parameter");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please use the post method");
}
echo json_encode($returnArray);
exit;
}
public function addCreditBalanceAction()
{
$currentDate = date("Y-m-d H:i:s");
$this->view->layout()->disableLayout();
$returnArray = array();
$cheditBalanceModel = new Travel_Model_CreditBalance();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getPost();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$Remark = isset($requestPerameter['Remark']) ? $requestPerameter['Remark'] : '';
$Amoout = isset($requestPerameter['Amount']) ? $requestPerameter['Amount'] : '';
$CurrencyType = isset($requestPerameter['CurrencyType']) ? $requestPerameter['CurrencyType'] : '1';
$PlanType = isset($requestPerameter['PlanType']) ? $requestPerameter['PlanType'] : '';
$UserSysId = isset($requestPerameter['UserSysId']) ? $requestPerameter['UserSysId'] : 0;
$PaymentMode = isset($requestPerameter['PaymentMode']) ? $requestPerameter['PaymentMode'] : 0;
$RefrenceNo = isset($requestPerameter['RefrenceNo']) ? $requestPerameter['RefrenceNo'] : '';
if ($B2BAgencySysIdKey != '' && $B2CAgencySysIdKey != '') {
$getBalanceArray = $cheditBalanceModel->getBalanceOtherInfo($B2BAgencySysIdKey, $B2CAgencySysIdKey);
$AgencySysId = isset($getBalanceArray[0]['AgencySysId']) ? $getBalanceArray[0]['AgencySysId'] : 0;
$checkWallet = $cheditBalanceModel->getCreditSysId($AgencySysId);
if (!empty($checkWallet)) {
$IsActive = isset($checkWallet[0]['IsActive']) ? $checkWallet[0]['IsActive'] : 0;
if ($IsActive == 1) {
$CreditSysId = isset($checkWallet[0]['CreditSysId']) ? $checkWallet[0]['CreditSysId'] : 0;
$getBalance = isset($getBalanceArray[0]['BalanceAmount']) ? $getBalanceArray[0]['BalanceAmount'] : 0;
if ($getBalance >= $Amoout) {
$editCreditTable = array('BalanceAmount' => new Zend_Db_Expr("BalanceAmount - $Amoout"));
try {
$whereEditCreditInfo = array('AgencySysId =?' => $AgencySysId);
$this->paymentMdl->updateTable("TB_Agency_Credit", $editCreditTable, $whereEditCreditInfo);
$getBalanceArray = $cheditBalanceModel->getBalanceOtherInfo($B2BAgencySysIdKey, $B2CAgencySysIdKey);
$getBalance = isset($getBalanceArray[0]['BalanceAmount']) ? $getBalanceArray[0]['BalanceAmount'] : 0;
$CreditAmount = isset($getBalanceArray[0]['CreditAmount']) ? $getBalanceArray[0]['CreditAmount'] : 0;
$Amount = isset($getBalanceArray[0]['Amount']) ? $getBalanceArray[0]['Amount'] : 0;
$CreditDays = isset($getBalanceArray[0]['CreditDays']) ? $getBalanceArray[0]['CreditDays'] : 0;
$GUID = $this->GUID();
$saveHistoryData = [
'TrxId' => $GUID,
'AgencySysId' => $AgencySysId,
'CreditSysId' => $CreditSysId,
'IsCredit' => 2,
'PlanType' => $PlanType,
'CurrencyType' => $CurrencyType,
'PaymentMode' => $PaymentMode,
'RefrenceNo' => $RefrenceNo,
'BalanceAmount' => $getBalance,
'CreditAmount' => $CreditAmount,
'Amount' => $Amount,
'CreditDays' => $CreditDays,
'CreditDate' => $currentDate,
'UserSysId' => $UserSysId,
'Remark' => $Remark,
'OTPCode' => 0,
'TrxType' => 0, // minus
'CodeValidFrom' => $currentDate,
'CodeValidTo' => $currentDate,
'CreateDate' => $currentDate,
'UpdateDate' => $currentDate,
'IsMarkForDel' => 0,
'IsActive' => 1,
];
$this->paymentMdl->insertTable("TB_Agency_Credit_History", $saveHistoryData);
http_response_code(200);
$returnArray = array("status" => True, "TransactionId" => $GUID, "message" => "");
} catch (Zend_Exception $e) {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => $e->getMessage());
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Balance is not sufficient. Please contact to Administrator.");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Your Wallet is Inactive");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Balance is not sufficient. Please contact to Administrator.");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please check requested parameter");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please use the post method");
}
echo json_encode($returnArray);
exit;
}
public function saveOfflineRequestAction()
{
$currentDate = date("Y-m-d H:i:s");
$this->view->layout()->disableLayout();
$returnArray = array();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getParams();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$objAgency = new Travel_Model_TblAgency();
$getB2BAgencySysId = $objAgency->getB2BAgencySysId($B2BAgencySysIdKey);
if (!empty($getB2BAgencySysId)) {
$CreditSysId = isset($getB2BAgencySysId[0]['CreditSysId']) ? $getB2BAgencySysId[0]['CreditSysId'] : '';
$AgencySysId = isset($getB2BAgencySysId[0]['AgencySysId']) ? $getB2BAgencySysId[0]['AgencySysId'] : '';
$MasterAgencySysId = isset($getB2BAgencySysId[0]['MasterAgencySysId']) ? $getB2BAgencySysId[0]['MasterAgencySysId'] : '';
$Amount = isset($requestPerameter['Amount']) ? $requestPerameter['Amount'] : '';
$CurrencyType = isset($requestPerameter['CurrencyType']) ? $requestPerameter['CurrencyType'] : '1';
$PlanType = isset($requestPerameter['PlanType']) ? $requestPerameter['PlanType'] : '';
$UserSysId = isset($requestPerameter['UserSysId']) ? $requestPerameter['UserSysId'] : 0;
$Remark = isset($requestPerameter['Remark']) ? $requestPerameter['Remark'] : 0;
$CreditDate = isset($requestPerameter['CreditDate']) ? $requestPerameter['CreditDate'] : date("Y-m-d");
$PaymentMode = isset($requestPerameter['PaymentMode']) ? $requestPerameter['PaymentMode'] : 0;
$RefrenceNo = isset($requestPerameter['RefrenceNo']) ? $requestPerameter['RefrenceNo'] : '';
$checkCreditBalance = $objAgency->checkCreditBalance($AgencySysId, $CreditSysId);
$getFinanceUserDetail = array();
if (!empty($MasterAgencySysId)) {
$getFinanceUserDetail = $objAgency->getFinanceUserDetail($MasterAgencySysId);
}
if (!empty($checkCreditBalance)) {
$GUID = $this->GUID();
$saveHistoryData = [
'TrxId' => $GUID,
'AgencySysId' => $AgencySysId,
'CreditSysId' => $CreditSysId,
'IsCredit' => 2,
'PlanType' => $PlanType,
'CurrencyType' => $CurrencyType,
'PaymentMode' => $PaymentMode,
'RefrenceNo' => $RefrenceNo,
'BalanceAmount' => 0,
'CreditAmount' => 0,
'Amount' => $Amount,
'CreditDays' => 0,
'CreditDate' => $CreditDate,
'UserSysId' => $UserSysId,
'Remark' => $Remark,
'OTPCode' => 0,
'TrxType' => 1, // plus
'CodeValidFrom' => $currentDate,
'CodeValidTo' => $currentDate,
'CreateDate' => $currentDate,
'UpdateDate' => $currentDate,
'IsMarkForDel' => 0,
'IsActive' => 0,
];
$this->paymentMdl->insertTable("TB_Agency_Credit_History", $saveHistoryData);
http_response_code(200);
$returnArray = array("status" => True, "TransactionId" => $GUID, "message" => "", "getFinanceUserDetail" => $getFinanceUserDetail);
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please contact");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please contact");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please contact");
}
echo json_encode($returnArray);
exit;
}
public function withdrawalOfflineRequestAction()
{
$currentDate = date("Y-m-d H:i:s");
$this->view->layout()->disableLayout();
$returnArray = array();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getParams();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$objAgency = new Travel_Model_TblAgency();
$getB2BAgencySysId = $objAgency->getB2BAgencySysId($B2BAgencySysIdKey);
if (!empty($getB2BAgencySysId)) {
$CreditSysId = isset($getB2BAgencySysId[0]['CreditSysId']) ? $getB2BAgencySysId[0]['CreditSysId'] : '';
$AgencySysId = isset($getB2BAgencySysId[0]['AgencySysId']) ? $getB2BAgencySysId[0]['AgencySysId'] : '';
$Amount = isset($requestPerameter['Amount']) ? $requestPerameter['Amount'] : '';
$CurrencyType = isset($requestPerameter['CurrencyType']) ? $requestPerameter['CurrencyType'] : '1';
$PlanType = isset($requestPerameter['PlanType']) ? $requestPerameter['PlanType'] : '';
$UserSysId = isset($requestPerameter['UserSysId']) ? $requestPerameter['UserSysId'] : 0;
$Remark = isset($requestPerameter['Remark']) ? $requestPerameter['Remark'] : 0;
$CreditDate = isset($requestPerameter['CreditDate']) ? $requestPerameter['CreditDate'] : date("Y-m-d");
$PaymentMode = isset($requestPerameter['PaymentMode']) ? $requestPerameter['PaymentMode'] : 0;
$RefrenceNo = isset($requestPerameter['RefrenceNo']) ? $requestPerameter['RefrenceNo'] : '';
$checkCreditBalance = $objAgency->checkCreditBalance($AgencySysId, $CreditSysId);
if (!empty($checkCreditBalance)) {
$GUID = $this->GUID();
$saveHistoryData = [
'TrxId' => $GUID,
'AgencySysId' => $AgencySysId,
'CreditSysId' => $CreditSysId,
'IsCredit' => 2,
'PlanType' => $PlanType,
'CurrencyType' => $CurrencyType,
'PaymentMode' => $PaymentMode,
'RefrenceNo' => $RefrenceNo,
'BalanceAmount' => 0,
'CreditAmount' => 0,
'Amount' => $Amount,
'CreditDays' => 0,
'CreditDate' => $CreditDate,
'UserSysId' => $UserSysId,
'Remark' => $Remark,
'OTPCode' => 0,
'TrxType' => 0, // minus
'CodeValidFrom' => $currentDate,
'CodeValidTo' => $currentDate,
'CreateDate' => $currentDate,
'UpdateDate' => $currentDate,
'IsMarkForDel' => 0,
'IsActive' => 0,
];
$this->paymentMdl->insertTable("TB_Agency_Credit_History", $saveHistoryData);
http_response_code(200);
$returnArray = array("status" => True, "TransactionId" => $GUID, "message" => "");
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please contact");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please contact");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please contact");
}
echo json_encode($returnArray);
exit;
}
public function saveOnlineRequestAction()
{
$currentDate = date("Y-m-d H:i:s");
$this->view->layout()->disableLayout();
$returnArray = array();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getParams();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$objPackage = new Travel_Model_TblPackage();
$objAgency = new Travel_Model_TblAgency();
$cheditBalanceModel = new Travel_Model_CreditBalance();
$getB2BAgencySysId = $objAgency->getB2BAgencySysId($B2BAgencySysIdKey);
if (!empty($getB2BAgencySysId)) {
$CreditSysId = isset($getB2BAgencySysId[0]['CreditSysId']) ? $getB2BAgencySysId[0]['CreditSysId'] : '';
$AgencySysId = isset($getB2BAgencySysId[0]['AgencySysId']) ? $getB2BAgencySysId[0]['AgencySysId'] : '';
$Amount = isset($requestPerameter['Amount']) ? $requestPerameter['Amount'] : '';
$CurrencyType = isset($requestPerameter['CurrencyType']) ? $requestPerameter['CurrencyType'] : '1';
$PlanType = isset($requestPerameter['PlanType']) ? $requestPerameter['PlanType'] : '';
$UserSysId = isset($requestPerameter['UserSysId']) ? $requestPerameter['UserSysId'] : 0;
$Remark = isset($requestPerameter['Remark']) ? $requestPerameter['Remark'] : 0;
$CreditDate = isset($requestPerameter['CreditDate']) ? $requestPerameter['CreditDate'] : date("Y-m-d");
$PaymentMode = isset($requestPerameter['PaymentMode']) ? trim($requestPerameter['PaymentMode']) : 0;
$RefrenceNo = isset($requestPerameter['RefrenceNo']) ? $requestPerameter['RefrenceNo'] : '';
$isTrue = true;
if ($RefrenceNo != "") {
$getAndCheckCreditHistoryArray = $cheditBalanceModel->getAndCheckCreditHistory($RefrenceNo, $PaymentMode, $CreditSysId);
if (!empty($getAndCheckCreditHistoryArray)) {
$isTrue = false;
}
}
if ($isTrue == true) {
$checkCreditBalance = $objAgency->checkCreditBalance($AgencySysId, $CreditSysId);
if (!empty($checkCreditBalance)) {
$updateData = [
'CreditDate' => $CreditDate,
'UpdateDate' => $CreditDate,
'BalanceAmount' => new Zend_Db_Expr("BalanceAmount + $Amount")
];
$whereQuery1 = array('CreditSysId = ? ' => $CreditSysId, 'AgencySysId = ? ' => $AgencySysId);
try {
if ($isTrue == true) {
$objPackage->updateData('TB_Agency_Credit', $updateData, $whereQuery1);
$isActive = 1;
} else {
$isActive = 0;
}
$getBalanceArray = $objAgency->checkCreditBalance($AgencySysId, $CreditSysId);
$getBalance = isset($getBalanceArray[0]['BalanceAmount']) ? $getBalanceArray[0]['BalanceAmount'] : 0;
$CreditAmount = isset($getBalanceArray[0]['CreditAmount']) ? $getBalanceArray[0]['CreditAmount'] : 0;
$GUID = $this->GUID();
$saveHistoryData = [
'TrxId' => $GUID,
'AgencySysId' => $AgencySysId,
'CreditSysId' => $CreditSysId,
'IsCredit' => 2,
'PlanType' => $PlanType,
'CurrencyType' => $CurrencyType,
'PaymentMode' => $PaymentMode,
'RefrenceNo' => $RefrenceNo,
'BalanceAmount' => $getBalance,
'CreditAmount' => $CreditAmount,
'Amount' => $Amount,
'CreditDays' => 0,
'CreditDate' => $CreditDate,
'UserSysId' => $UserSysId,
'Remark' => $Remark,
'OTPCode' => 0,
'TrxType' => 1, // plus
'CodeValidFrom' => $currentDate,
'CodeValidTo' => $currentDate,
'CreateDate' => $currentDate,
'UpdateDate' => $currentDate,
'IsMarkForDel' => 0,
'IsActive' => $isActive,
];
$this->paymentMdl->insertTable("TB_Agency_Credit_History", $saveHistoryData);
http_response_code(200);
$returnArray = array("status" => True, "TransactionId" => $GUID, "message" => "");
} catch (Zend_Exception $e) {
$returnErrorMessage = $e->getMessage();
$returnArray = array('status' => false, 'message' => $returnErrorMessage, 'CreditSysId' => '');
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please contact");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please contact");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please contact");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please use post method");
}
echo json_encode($returnArray);
exit;
}
public function getMarkupAction()
{
$this->view->layout()->disableLayout();
$objAgency = new Travel_Model_TblAgency();
$finModel = new Finance_Model_Finance();
$returnArray = array();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getParams();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$MasterAgencySysId = isset($requestPerameter['MasterAgencySysId']) ? $requestPerameter['MasterAgencySysId'] : 0;
$PlanType = isset($requestPerameter['PlanType']) ? $requestPerameter['PlanType'] : 0;
$IsB2C = isset($requestPerameter['IsB2C']) ? (int) $requestPerameter['IsB2C'] : 0;
$IsB2CLoggedIn = isset($requestPerameter['IsB2CLoggedIn']) ? (int) $requestPerameter['IsB2CLoggedIn'] : 0;
if ($IsB2C == 1) {
$marketPlace = 1;
if ($IsB2CLoggedIn == 1) {
$getMarkUpArray = $objAgency->getMarkupForB2CAgency($B2CAgencySysIdKey, $PlanType, $IsB2CLoggedIn);
} else {
$getMarkUpArray = $objAgency->getMarkupForB2CAgency($B2CAgencySysIdKey, $PlanType, $IsB2CLoggedIn);
}
} else {
$marketPlace = 2;
$getMarkUpArray = $objAgency->getMarkupForB2bAgency($B2BAgencySysIdKey, $B2CAgencySysIdKey, $PlanType);
}
$getTaxSettingDetail = $finModel->getAllDefaultTaxSetting($MasterAgencySysId, $marketPlace, $PlanType);
http_response_code(200);
$returnArray = array("status" => TRUE, "data" => $getMarkUpArray, "TaxSetting" => $getTaxSettingDetail, "message" => "");
} else {
http_response_code(500);
$returnArray = array("status" => False, "data" => '', "TaxSetting" => '', "message" => "Please use Post Method");
}
echo json_encode($returnArray);
exit;
}
public function getBankDetailAction()
{
$this->view->layout()->disableLayout();
$objAgency = new Travel_Model_TblAgency();
$returnArray = array();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getParams();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$getMarkUpArray = $objAgency->getBankDetail($B2BAgencySysIdKey, $B2CAgencySysIdKey);
http_response_code(200);
$returnArray = array("status" => TRUE, "data" => $getMarkUpArray, "message" => "");
} else {
http_response_code(500);
$returnArray = array("status" => False, "data" => '', "message" => "Please use Post Method");
}
echo json_encode($returnArray);
exit;
}
public function getSupportContactAction()
{
$this->view->layout()->disableLayout();
$objAgency = new Travel_Model_TblAgency();
$otherData = array();
$returnArray = array();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getParams();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$getMarkUpArray = $objAgency->getSupportContactForB2b($B2BAgencySysIdKey, $B2CAgencySysIdKey);
http_response_code(200);
$otherData["MasterDate"]["PlanType"] = array(1 => "Flight", 2 => "Hotel", 5 => "Package", 6 => "Visa", 99 => 'Registration', 96 => 'Flight Modification', 95 => 'Hotel Modification', 94 => 'Booking Failed');
$otherData["MasterDate"]["MarketType"] = array(1 => "B2C", 2 => "B2B");
$otherData["MasterDate"]["ItemSourceType"] = array(1 => "Domestic", 2 => "International");
$otherData["MasterDate"]["SupportNumber"] = $getMarkUpArray;
$returnArray = array("status" => TRUE, "data" => $otherData, "message" => "");
} else {
http_response_code(500);
$returnArray = array("status" => False, "data" => '', "message" => "Please use Post Method");
}
echo json_encode($returnArray);
exit;
}
public function getLedgerAction()
{
$this->view->layout()->disableLayout();
$returnArray = array();
$objAgency = new Travel_Model_TblAgency();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getParams();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$AgencySysIdArr = $objAgency->getB2BAgencyId($B2BAgencySysIdKey, $B2CAgencySysIdKey);
$AgencySysId = isset($AgencySysIdArr['AgencySysId']) ? (int) $AgencySysIdArr['AgencySysId'] : 0;
if ($AgencySysId > 0) {
$ledgerDataArr = $objAgency->getAgencyCreditLimitDataByAgencyId($AgencySysId, 0, 1);
$HistoryCreditSysId = array();
foreach ($ledgerDataArr as $ledgerVal) {
$HistoryCreditSysId[] = $ledgerVal['HistoryCreditSysId'];
}
if (!empty($HistoryCreditSysId)) {
$updatedArray = array("Isfetched" => 1);
$whereCondition = array("HistoryCreditSysId IN (?)" => $HistoryCreditSysId);
$objAgency->updateData("TB_Agency_Credit_History", $updatedArray, $whereCondition);
}
$returnArray["Status"] = True;
$returnArray["Message"] = "";
$returnArray["CreditLimit"] = $objAgency->getCreditBalanceForAgency($AgencySysId);
$returnArray["LedgerData"] = $ledgerDataArr;
} else {
$returnArray["Status"] = False;
$returnArray["Message"] = "Please Check Post Method";
}
} else {
$returnArray["Status"] = False;
$returnArray["Message"] = "Please Use Post Method";
}
echo json_encode($returnArray);
exit;
}
public function getB2bLedgerAction()
{
$this->view->layout()->disableLayout();
$returnArray = array();
$objAgency = new Travel_Model_TblAgency();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getParams();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$PageSize = $this->getRequest()->getPost("PageSize", 25);
$PageNumber = $this->getRequest()->getPost("PageNumber", 1);
$FromDate = $this->getRequest()->getPost("FromDate", null);
$ToDate = $this->getRequest()->getPost("ToDate", null);
$AgencySysIdArr = $objAgency->getB2BAgencyId($B2BAgencySysIdKey, $B2CAgencySysIdKey);
$AgencySysId = isset($AgencySysIdArr['AgencySysId']) ? (int) $AgencySysIdArr['AgencySysId'] : 0;
if ($AgencySysId > 0) {
//echo "<pre>";print_r($requestPerameter);exit;
$ledgerDataArr = $objAgency->getAgencyCreditLimitDataByAgencyIdNew($AgencySysId, $PageSize, $PageNumber, $FromDate, $ToDate);
$returnArray["Status"] = True;
$returnArray["Message"] = "";
$returnArray["CreditLimit"] = $objAgency->getCreditBalanceForAgency($AgencySysId);
$returnArray["LedgerData"] = $ledgerDataArr;
} else {
$returnArray["Status"] = False;
$returnArray["Message"] = "Please Check Post Method";
}
} else {
$returnArray["Status"] = False;
$returnArray["Message"] = "Please Use Post Method";
}
echo json_encode($returnArray);
exit;
}
public function updateReferenceNumberAction()
{
$currentDate = date("Y-m-d H:i:s");
$this->view->layout()->disableLayout();
$returnArray = array();
$cheditBalanceModel = new Travel_Model_CreditBalance();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getPost();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$GUID = isset($requestPerameter['TransactionId']) ? $requestPerameter['TransactionId'] : 0;
$RefrenceNo = isset($requestPerameter['RefrenceNo']) ? $requestPerameter['RefrenceNo'] : '';
if ($B2BAgencySysIdKey != '' && $B2CAgencySysIdKey != '') {
$getBalanceArray = $cheditBalanceModel->getBalanceOtherInfo($B2BAgencySysIdKey, $B2CAgencySysIdKey);
$AgencySysId = isset($getBalanceArray[0]['AgencySysId']) ? $getBalanceArray[0]['AgencySysId'] : 0;
$checkWallet = $cheditBalanceModel->getCreditSysId($AgencySysId);
if (!empty($checkWallet)) {
$IsActive = isset($checkWallet[0]['IsActive']) ? $checkWallet[0]['IsActive'] : 0;
if ($IsActive == 1) {
$editCreditTable = array('RefrenceNo' => $RefrenceNo);
try {
$whereEditCreditInfo = array('AgencySysId =?' => $AgencySysId, 'TrxId =?' => $GUID);
$this->paymentMdl->updateTable("TB_Agency_Credit_History", $editCreditTable, $whereEditCreditInfo);
http_response_code(200);
$returnArray = array("status" => True, "TransactionId" => $GUID, "message" => "");
} catch (Zend_Exception $e) {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => $e->getMessage());
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Your Wallet is Inactive");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Balance is not sufficient. Please contact to Administrator.");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please check requested parameter");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please use the post method");
}
echo json_encode($returnArray);
exit;
}
public function getDefaultTaxSettingAction()
{
$this->view->layout()->disableLayout();
$finModel = new Finance_Model_Finance();
$returnArray = array();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getParams();
$MasterAgencySysId = isset($requestPerameter['MasterAgencySysId']) ? $requestPerameter['MasterAgencySysId'] : 0;
$PlanType = isset($requestPerameter['PlanType']) ? $requestPerameter['PlanType'] : 0;
$getTaxSettingDetail = $finModel->getAllDefaultTaxSetting($MasterAgencySysId, 2, $PlanType);
http_response_code(200);
$returnArray = array("status" => TRUE, "TaxSetting" => $getTaxSettingDetail, "message" => "");
} else {
http_response_code(500);
$returnArray = array("status" => False, "data" => '', "TaxSetting" => '', "message" => "Please use Post Method");
}
echo json_encode($returnArray);
exit;
}
public function saveOnlineDailyCollectionAction()
{
$this->view->layout()->disableLayout();
$returnArray = array();
if ($this->getRequest()->isPost()) {
$requestPerameter = $this->getRequest()->getParams();
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$DrPartyName = isset($requestPerameter['DrPartyName']) ? $requestPerameter['DrPartyName'] : '';
$Amount = isset($requestPerameter['Amount']) ? $requestPerameter['Amount'] : 0;
$CurrencyType = isset($requestPerameter['CurrencyType']) ? $requestPerameter['CurrencyType'] : 0;
$CustomerSysId = isset($requestPerameter['CustomerSysId']) ? $requestPerameter['CustomerSysId'] : 0;
$UserSysId = isset($requestPerameter['UserSysId']) ? $requestPerameter['UserSysId'] : 0;
$AgencySysId = isset($requestPerameter['AgencySysId']) ? $requestPerameter['AgencySysId'] : 0;
$AgentSysId = isset($requestPerameter['AgentSysId']) ? $requestPerameter['AgentSysId'] : 0;
$GUID = isset($requestPerameter['GUID']) ? $requestPerameter['GUID'] : 0;
$objAgency = new Travel_Model_TblAgency();
$paymentMdl = new Payment_Model_Payment();
$getB2BAgencySysId = $objAgency->getB2BAgencySysId($B2BAgencySysIdKey);
if (!empty($getB2BAgencySysId)) {
try {
$offlinePaymentModeData = $paymentMdl->getDetailsByUniqueId("TB_Master_PaymentMediaType", "Title", "CC");
$TrxPayMediaType = $offlinePaymentModeData['PaymentMediaType'];
$addData_Trx = array(
'MPSysId' => 1,
'InvoiceId' => '',
'TrxOrdDocId' => 7,
'TrxType' => "A",
//'TrxOrdDocId' => $TrxPayMediaType,
'TrxDate' => date('Y-m-d H:i:s'),
'TrxPayMediaType' => $TrxPayMediaType,
'CrPartyAccSysId' => 1,
'DrPartyAccSysId' => "",
'CrPartyName' => '', //Agency Name
'DrPartyName' => $DrPartyName,
'CurrencyType' => $CurrencyType,
'Markup' => 0,
"AgencyMarkUp" => 0,
"GTXMarkup" => 0,
"TrxFee" => 0,
"Commission" => 0,
"GTXCommission" => 0,
'TotalDiscount' => 0,
'Amount' => $Amount,
'PaidAmount' => $Amount,
'NetAmount' => $Amount,
'TrxStatus' => true,
'TBPoints' => 0,
'IsActive' => true
);
$TrxSysId = $paymentMdl->insertTable("TB_Trx", $addData_Trx);
$addDataAgency_Customer_Trx = array(
"CustomerSysId" => $CustomerSysId,
"AgencySysId" => $AgencySysId,
"UserSysId" => $UserSysId,
"TrxSysId" => $TrxSysId,
'XRefTrxNo' => '',
'TPSysId' => $GUID,
'MPSysId' => 1,
'TrxDate' => date('Y-m-d H:i:s'),
'TrxUpdatedOn' => "",
'PaymentModeType' => 1,
'InvoiceId' => '',
'TrxOrdDocId' => 7,
'TrxType' => "A",
'TrxPayMediaRefNo' => "",
'CrPartyAccSysId' => 1,
"DrPartyAccSysId" => 0,
"CrPartyName" => "", //Agency Name
"DrPartyName" => $DrPartyName,
'TrxPayMediaType' => 1,
'CurrencyType' => $CurrencyType,
'Amount' => $Amount,
'Markup' => 0,
"AgencyMarkUp" => 0,
"GTXMarkup" => 0,
"TrxFee" => 0,
"Commission" => 0,
'TotalDiscount' => 0,
'PaidAmount' => $Amount,
'NetAmount' => $Amount,
'TBPoints' => 0,
'TrxStatus' => 1,
'IsActive' => true
);
$Customer_TrxID = $paymentMdl->insertTable("TB_Agency_Customer_Trx", $addDataAgency_Customer_Trx);
$wallet = $paymentMdl->getDetailsByUniqueId("TB_Agency_Wallet", "AgencySysId", $AgencySysId);
$addData = array(
'TrxId' => $TrxSysId,
'AgencySysId' => $AgencySysId,
'WalletSysId' => $wallet['WalletSysId'],
'XRefTPSysId' => 0,
"GUID" => "",
"TrxDate" => date('Y-m-d H:i:s'),
'TrxType' => "A",
'InvoiceId' => '0',
'TrxOrdDocId' => 7,
'PaymentModeType' => 1,
"TrxPayMediaType" => $TrxPayMediaType,
'TrxPayMediaRefNo' => "",
'TransFee' => 0,
'CrPartyAccSysId' => 1,
'DrPartyAccSysId' => 0,
'CrPartyName' => "", //Agency Name
'DrPartyName' => $DrPartyName,
'CurrencyType' => $CurrencyType,
'TotalDiscount' => 0,
"Amount" => $Amount,
'NetAmount' => $Amount,
'PaidAmount' => $Amount,
"SupplierSourceStr" => "API",
"PaxCount" => 0,
"ClosingBalance" => 0,
'TBPoints' => 0,
"IsActive" => true,
"UserSysId" => $UserSysId, //insert user id
"CreateDate" => date('Y-m-d H:i:s'),
"UpdateDate" => date('Y-m-d H:i:s'),
"IsApproved" => true,
"ApprovedBy" => $UserSysId,
"ApprovedDate" => date('Y-m-d H:i:s'),
"IsMarkForDel" => false
);
$Wallet_TrxID = $paymentMdl->insertTable("TB_Agency_Wallet_Trx", $addData);
http_response_code(200);
$returnArray = array("status" => True, "TrxSysId" => $TrxSysId, 'Wallet_TrxID' => $Wallet_TrxID, 'Customer_TrxID' => $Customer_TrxID, "message" => "SUCCESS");
} catch (Zend_Exception $e) {
$returnErrorMessage = $e->getMessage();
$returnArray = array('status' => false, 'message' => $returnErrorMessage, 'CreditSysId' => '');
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please contact");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "TransactionId" => "", "message" => "Please use post method");
}
echo json_encode($returnArray);
exit;
}
public function getB2bdepositRequestAction()
{
$this->view->layout()->disableLayout();
$objAgency = new Travel_Model_TblAgency();
$returnArray = array();
if ($this->getRequest()->isPost()) {
$json = file_get_contents('php://input');
$requestPerameter = json_decode($json, true);
$B2BAgencySysIdKey = isset($requestPerameter['B2BAgencySysIdKey']) ? $requestPerameter['B2BAgencySysIdKey'] : '';
$B2CAgencySysIdKey = isset($requestPerameter['B2CAgencySysIdKey']) ? $requestPerameter['B2CAgencySysIdKey'] : '';
$filterData = isset($requestPerameter['filterData']) ? $requestPerameter['filterData'] : [];
$getB2BAgencySysId = $objAgency->getB2BAgencySysId($B2BAgencySysIdKey);
if ($getB2BAgencySysId) {
$MasterAgencySysId = isset($getB2BAgencySysId[0]['MasterAgencySysId']) ? $getB2BAgencySysId[0]['MasterAgencySysId'] : '';
$b2bAgencyDataArr = $objAgency->getB2bAgencyIds($MasterAgencySysId);
$agencyB2bIds[] = isset($getB2BAgencySysId[0]['AgencySysId']) ? $getB2BAgencySysId[0]['AgencySysId'] : 0;
if ($filterData) {
$this->_HtmlPurifier = new Zend_Filter_HtmlPurifier();
$filterData = $this->_HtmlPurifier->filterArray($filterData);
}
$objAgency->filterData = $filterData;
$CreditLimitData = $objAgency->getAgencyCreditLimitDataByAgencyIdwithids($agencyB2bIds, 3);
$page = $this->_getParam('page', 1);
$paginator = Zend_Paginator::factory($CreditLimitData);
$paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
$paginator->setCurrentPageNumber($page);
$items = $paginator->getCurrentItems();
http_response_code(200);
$returnArray = array("status" => TRUE, "data" => (array)$items, "message" => "success");
} else {
http_response_code(200);
$returnArray = array("status" => false, "message" => "Invalid security key");
}
} else {
http_response_code(500);
$returnArray = array("status" => False, "data" => '', "message" => "Please use Post Method");
}
echo json_encode($returnArray);
exit;
}
}