/**
* checkPromoValidation : Individual & Korporasi
* @return disc :: Total
*/
function checkPromoValidation($whatPromo, $package, $promotionId = '', $payment = 0)
{
$tblPackage = new Pandamp_Modules_Identity_Package_Model_Package();
$rowPackage = $tblPackage->find($package)->current();
$periode = $rowPackage->charge * $payment;
$tblPromosi = new Pandamp_Modules_Identity_Promotion_Model_Promotion();
$rowPromo = $tblPromosi->find($promotionId)->current();
// check promotionID if exist then dischard query
if (isset($rowPromo)) {
if ($payment == 6) {
$disc = $rowPromo->discount + 5;
} elseif ($payment == 12) {
$disc = $rowPromo->discount + 10;
} else {
$disc = $rowPromo->discount;
}
$total = ($periode - $disc / 100 * $periode) * 1.1;
} else {
$getPromo = $tblPromosi->fetchRow("periodeStart <= '" . date("Y-m-d") . "' AND periodEnd >= '" . date("Y-m-d") . "' AND monthlySubscriber=" . $payment . "");
if (!empty($getPromo)) {
if ($payment == 6) {
$disc = $getPromo->discount + 5;
} elseif ($payment == 12) {
$disc = $getPromo->discount + 10;
} else {
$disc = $getPromo->discount;
}
$total = ($periode - $disc / 100 * $periode) * 1.1;
} else {
if ($payment == 6) {
$disc = 5;
} elseif ($payment == 12) {
$disc = 10;
} else {
$disc = 0;
}
$total = ($periode - $disc / 100 * $periode) * 1.1;
}
}
switch ($whatPromo) {
case 'Disc':
return $disc;
break;
case 'Total':
return $total;
break;
}
}
function completeAction()
{
$formater = new Pandamp_Core_Hol_User();
$defaultCurrency = 'Rp';
$guid = $this->_request->getParam('guid');
$method = $this->_request->getParam('method');
$tblPaymentSetting = new Pandamp_Modules_Payment_Setting_Model_PaymentSetting();
$usdIdrEx = $tblPaymentSetting->fetchRow(" settingKey= 'USDIDR'");
$currencyValue = $usdIdrEx->settingValue;
$rowTaxRate = $tblPaymentSetting->fetchRow("settingKey='taxRate'");
$taxRate = $rowTaxRate->settingValue;
$tblUser = new Pandamp_Modules_Identity_User_Model_User();
$rowUser = $tblUser->find($guid)->current();
$this->view->rowUser = $rowUser;
// discount
$disc = $formater->checkPromoValidation('Disc', $rowUser->packageId, $rowUser->promotionId, $rowUser->paymentId);
$total = $formater->checkPromoValidation('Total', $rowUser->packageId, $rowUser->promotionId, $rowUser->paymentId);
$tblPackage = new Pandamp_Modules_Identity_Package_Model_Package();
$rowPackage = $tblPackage->find($rowUser->packageId)->current();
$this->view->rowPackage = $rowPackage;
$tblOrder = new Pandamp_Modules_Payment_Order_Model_Order();
$row = $tblOrder->fetchNew();
$row->userId = $guid;
if ($this->getRequest()->getPost()) {
$value = $this->getRequest()->getPost();
$row->taxNumber = $value['taxNumber'];
$row->taxCompany = $value['taxCompany'];
$row->taxAddress = $value['taxAddress'];
$row->taxCity = $value['taxCity'];
$row->taxZip = $value['taxZip'];
$row->taxProvince = $value['taxProvince'];
$row->taxCountryId = $value['taxCountry'];
$row->paymentMethod = $method;
}
$row->datePurchased = date('YmdHis');
$row->paymentMethodNote = "membership";
if ($method == "nsiapay") {
$row->orderStatus = 8;
} else {
$row->orderStatus = 1;
//pending
}
$row->currency = $defaultCurrency;
$row->currencyValue = $currencyValue;
$row->orderTotal = $total;
$row->ipAddress = Pandamp_Lib_Formater::getRealIpAddr();
$orderId = $row->save();
$rowJustInserted = $tblOrder->find($orderId)->current();
$rowJustInserted->invoiceNumber = date('Ymd') . '.' . $orderId;
$temptime = time();
$temptime = Pandamp_Lib_Formater::DateAdd('d', 5, $temptime);
$rowJustInserted->discount = $disc;
$rowJustInserted->invoiceExpirationDate = strftime('%Y-%m-%d', $temptime);
$rowJustInserted->save();
$this->view->invoiceNumber = $rowJustInserted->invoiceNumber;
$this->view->datePurchased = $rowJustInserted->datePurchased;
$tblOrderDetail = new Pandamp_Modules_Payment_OrderDetail_Model_OrderDetail();
$rowDetail = $tblOrderDetail->fetchNew();
$rowDetail->orderId = $orderId;
$rowDetail->itemId = $rowPackage->packageId;
if ($rowUser->packageId == 26) {
$group = "Subsciption for Member Individual " . $rowUser->paymentId . " Months";
} else {
if ($rowUser->packageId == 27) {
$group = "Subsciption for Member Corporate" . $rowUser->paymentId . " Months";
}
}
$this->view->itemName = $group;
$rowDetail->documentName = $group;
$rowDetail->price = $total;
$numOfUsers = $tblUser->getUserCount($rowUser->guid);
$this->view->numOfUsers = $numOfUsers;
$this->view->grandtotal = $grandTotal;
$this->view->method = $method;
$this->view->orderId = $orderId;
$this->view->total = $total;
$rowDetail->qty = $numOfUsers;
$rowDetail->finalPrice = $total;
$rowDetail->save();
$data = $this->_request->getParams();
$this->view->data = $data;
$modDir = $this->getFrontController()->getModuleDirectory();
require_once $modDir . '/models/Store/Mailer.php';
$mod = new Holsite_Model_Store_Mailer();
switch (strtolower($method)) {
case 'manual':
case 'bank':
//$mod->sendBankInvoiceToUser($orderId);
break;
case 'nsiapay':
$mod->sendInvoiceToUser($orderId);
break;
}
}
