protected function _postDelete()
{
$modelUserFinance = new App_Model_Db_Table_UserFinance();
$modelUserFinance->delete("userId='" . $this->kopel . "'");
$modelUserInvoice = new App_Model_Db_Table_Invoice();
$modelUserInvoice->delete("uid='" . $this->kopel . "'");
$acl = Pandamp_Acl::manager();
$acl->deleteUser($this->username);
$modelOrder = new App_Model_Db_Table_Order();
$fetchOrder = $modelOrder->fetchAll("userId='" . $this->kopel . "'");
foreach ($fetchOrder as $rowOrder) {
$rowOrder->delete();
}
$registry = Zend_Registry::getInstance();
$config = $registry->get(Pandamp_Keys::REGISTRY_APP_OBJECT);
$cdn = $config->getOption('cdn');
$sDir = $cdn['static']['dir']['photo'];
//$sDir = ROOT_DIR.DIRECTORY_SEPARATOR.'uploads'.DIRECTORY_SEPARATOR.'photo';
try {
if (file_exists($sDir . "/" . $this->kopel . ".gif")) {
unlink($sDir . "/" . $this->kopel . ".gif");
}
if (file_exists($sDir . "/" . $this->kopel . ".jpg")) {
unlink($sDir . "/" . $this->kopel . ".jpg");
}
if (file_exists($sDir . "/" . $this->kopel . ".jpeg")) {
unlink($sDir . "/" . $this->kopel . ".jpeg");
}
if (file_exists($sDir . "/" . $this->kopel . ".png")) {
unlink($sDir . "/" . $this->kopel . ".png");
}
} catch (Exception $e) {
}
}
public function payconfirmyesAction()
{
$this->_helper->viewRenderer->setNoRender(TRUE);
//print_r($this->_request->getParams());
$id = $this->_request->getParam('orderId');
$tblOrder = new App_Model_Db_Table_Order();
$tblHistory = new App_Model_Db_Table_OrderHistory();
$tblConfirm = new App_Model_Db_Table_PaymentConfirmation();
$rowOrder = $tblOrder->find($id)->current();
if ($rowOrder->paymentMethodNote == 'membership') {
$oldUser = App_Model_Show_User::show()->getUserById($rowOrder->userId);
$oldpackage = App_Model_Show_AroGroup::show()->getUserGroup($oldUser['packageId']);
$newGroup = App_Model_Show_AroGroup::show()->getUserGroup($rowOrder->note);
$notes = date("Y-m-d h:i:s") . " - Changed package " . $oldpackage['name'] . " TO " . $newGroup['name'];
$notes = $oldUser['notes'] ? $oldUser['notes'] . "\n" . $notes : $notes;
$dataUser = array('packageId' => $rowOrder->note, 'notes' => $notes, 'modifiedDate' => date("Y-m-d h:i:s"), 'modifiedBy' => Zend_Auth::getInstance()->getIdentity()->username);
$modelUser = new App_Model_Db_Table_User();
$dataUserDetail = array('userId' => $oldUser['kopel'], 'packageId' => $oldUser['packageId'], 'promotionId' => $oldUser['promotionId'], 'educationId' => $oldUser['educationId'], 'expenseId' => $oldUser['expenseId'], 'paymentId' => $oldUser['paymentId'], 'businessTypeId' => $oldUser['businessTypeId'], 'periodeId' => $oldUser['periodeId'], 'activationDate' => $oldUser['activationDate'], 'createdDate' => $oldUser['createdDate'], 'createdBy' => $oldUser['createdBy'], 'modifiedDate' => $oldUser['modifiedDate'], 'modifiedBy' => $oldUser['modifiedBy'], 'isActive' => $oldUser['isActive'], 'isContact' => $oldUser['isContact']);
$modelUserDetail = new App_Model_Db_Table_UserDetail();
$modelUserDetail->insert($dataUserDetail);
$acl = Pandamp_Acl::manager();
$acl->deleteUser($oldUser['username']);
$acl->addUser($oldUser['username'], $newGroup['name']);
$tblInvoice = new App_Model_Db_Table_Invoice();
$where = $tblInvoice->getAdapter()->quoteInto("uid=?", $rowOrder->userId);
$rowInvoice = $tblInvoice->fetchRow($where);
if ($rowInvoice) {
$rowInvoice->invoiceConfirmDate = date("Y-m-d");
$rowInvoice->isPaid = 'Y';
// get expiration date
$temptime = time();
$temptime = Pandamp_Lib_Formater::DateAdd('m', $oldUser['paymentId'], $temptime);
$rowInvoice->expirationDate = strftime('%Y-%m-%d', $temptime);
$rowInvoice->save();
$dataUser['periodeId'] = 3;
}
$modelUser->update($dataUser, "kopel='" . $rowOrder->userId . "'");
}
//select payment date from paymentconfirmation
$date = $tblConfirm->fetchAll("orderId = " . $id . " AND confirmed = 0");
$data['paymentDate'] = $date[0]->paymentDate;
//update order
$data['orderStatus'] = 3;
$tblOrder->update($data, "orderId = " . $id);
//update paymentconfirmation
$dataConfirm['confirmed'] = 1;
$tblConfirm->update($dataConfirm, "orderId = " . $id);
//add history
$dataHistory = $tblHistory->fetchNew();
//history data
$dataHistory['orderId'] = $id;
$dataHistory['orderStatusId'] = 3;
$dataHistory['dateCreated'] = date('Y-m-d');
$dataHistory['userNotified'] = 1;
$dataHistory['note'] = 'confirmed';
$dataHistory->save();
//mailer
//$this->Mailer($id, 'user-confirm', 'user');
$mod = new App_Model_Store_Mailer();
$mod->sendReceiptToUser($id, ucwords($date[0]->paymentMethod));
//redirect to confirmation page
$this->_redirect($this->view->serverUrl() . '/' . $this->view->getLanguage() . '/store/confirm');
}
/**
* _writeInvoice : Individual & Korporasi
* @modifiedDate : 2012-11-20 12:53N
* @todo Changed invoiceOutDate with createdDate from User Table
* @return
*/
function _writeInvoice($memberId, $totalPromo, $discPromo, $payment, $access = '')
{
//$aclMan = Pandamp_Acl::manager();
$tblInvoice = new App_Model_Db_Table_Invoice();
$where = $tblInvoice->getAdapter()->quoteInto("uid=?", "{$memberId}");
$rowInvoice = $tblInvoice->fetchAll($where);
if (count($rowInvoice) <= 0) {
$tblUser = new App_Model_Db_Table_User();
$rowUser = $tblUser->fetchRow("kopel='" . $memberId . "'");
$rowInvoice = $tblInvoice->fetchNew();
$rowInvoice->uid = $memberId;
$rowInvoice->price = $totalPromo;
$rowInvoice->discount = $discPromo;
//$rowInvoice->invoiceOutDate = date("Y-m-d");
$rowInvoice->invoiceOutDate = date("Y-m-d", strtotime($rowUser->createdDate));
$rowInvoice->invoiceConfirmDate = "0000-00-00";
//$temptime = time();
$temptime = strtotime($rowUser->createdDate);
if ($rowUser->trialInDays == 0) {
$trial = 5;
} else {
$trial = $rowUser->trialInDays;
}
$temptime = Pandamp_Lib_Formater::DateAdd('d', $trial, $temptime);
$rowInvoice->expirationDate = strftime('%Y-%m-%d', $temptime);
if (empty($access)) {
$rowInvoice->save();
} else {
$result = $rowInvoice->save();
if ($result) {
$r = $memberId . " OK";
} else {
$r = 'failure';
}
}
} else {
if (!empty($access)) {
$r = "invoice:{$memberId} sudah pernah dibuat!";
}
}
return $r;
}
function invoicelistAction()
{
if (!Pandamp_Controller_Action_Helper_IsAllowed::isAllowed('membership', 'all')) {
$this->_redirect(ROOT_URL . '/' . $this->_zl->getLanguage() . '/error/restricted');
}
$this->_helper->layout->setLayout('layout-customer-credential');
$id = $this->_getParam("id");
$userInvoiceList = App_Model_Show_Invoice::show()->getInvoiceById($id);
$this->view->userInvoiceList = $userInvoiceList;
$user = App_Model_Show_User::show()->getUserById($id);
if ($user) {
$this->view->user = $user;
}
$this->view->identity = $this->_user;
/**
* UPDATED:July 25, 2012
* @modifiedDate: 2012-11-20 15:10N
* @todo Invoice can add more than one
* comment line 897-899
*/
if ($this->getRequest()->isPost()) {
if (isset($user['paymentId']) && $user['paymentId'] != 0) {
$tblInvoice = new App_Model_Db_Table_Invoice();
// $where = $tblInvoice->getAdapter()->quoteInto("uid=?",$this->getRequest()->getPost('kopel'));
// $rowInvoice = $tblInvoice->fetchAll($where);
// if (count($rowInvoice) <= 0)
// {
$rowInvoice = $tblInvoice->fetchNew();
$rowInvoice->uid = $this->getRequest()->getPost('kopel');
$rowInvoice->price = $this->getRequest()->getPost('price');
$rowInvoice->discount = $this->getRequest()->getPost('disc');
$rowInvoice->invoiceOutDate = $this->getRequest()->getPost('invoiceOutDate');
$rowInvoice->invoiceConfirmDate = $this->getRequest()->getPost('invoiceConfirmDate');
$rowInvoice->clientBankAccount = $this->getRequest()->getPost('clientBankAccount');
$rowInvoice->isPaid = $this->getRequest()->getPost('isPaid');
$rowInvoice->expirationDate = $this->getRequest()->getPost('expirationDate');
$rowInvoice->save();
} else {
die('Lamanya berlangganan kosong, silahkan edit dulu data pelanggan');
}
$this->_redirect(ROOT_URL . '/' . $this->_zl->getLanguage() . '/customer/user/invoicelist/id/' . $this->getRequest()->getPost('kopel'));
// }
}
}
public function editAction()
{
if (!Pandamp_Controller_Action_Helper_IsAllowed::isAllowed('membership', 'all')) {
$this->_redirect(ROOT_URL . '/' . $this->_zl->getLanguage() . '/error/restricted');
}
$this->_helper->layout->setLayout('layout-customer-credential');
$id = $this->_getParam("id");
$tblInvoice = new App_Model_Db_Table_Invoice();
$rowset = $tblInvoice->find($id)->current();
$this->view->row = $rowset;
if ($this->getRequest()->isPost()) {
$rowset->price = $this->getRequest()->getPost('price');
$rowset->discount = $this->getRequest()->getPost('disc');
$rowset->invoiceOutDate = $this->getRequest()->getPost('invoiceOutDate');
$rowset->invoiceConfirmDate = $this->getRequest()->getPost('invoiceConfirmDate');
$rowset->clientBankAccount = $this->getRequest()->getPost('clientBankAccount');
$rowset->isPaid = $this->getRequest()->getPost('isPaid');
$rowset->expirationDate = $this->getRequest()->getPost('expirationDate');
$rowset->save();
$notes = date("Y-m-d h:i:s") . ' ' . $this->_user->username . " - Modify invoice:" . $id;
$data = array('notes' => new Zend_Db_Expr("CONCAT(ifnull(notes,''),' \n{$notes}')"));
$modelUser = new App_Model_Db_Table_User();
$modelUser->update($data, "kopel='" . $this->getRequest()->getPost('uid') . "'");
$this->_redirect(ROOT_URL . '/' . $this->_zl->getLanguage() . '/customer/user/invoicelist/id/' . $this->getRequest()->getPost('uid'));
}
}
