public function invoiceAction() { $this->_helper->layout->disableLayout(); $this->_helper->getHelper('viewRenderer')->setNoRender(TRUE); $tblUser = new App_Model_Db_Table_User(); $rowUser = $tblUser->fetchRow("kopel='00015'"); $temptime = strtotime($rowUser->createdDate); //$temptime = time(); $temptime = Pandamp_Lib_Formater::DateAdd('d', 5, $temptime); $rowInvoice = strftime('%Y-%m-%d', $temptime); Pandamp_Debug::manager($rowInvoice); }
function confirmAction() { if (!Pandamp_Controller_Action_Helper_IsAllowed::isAllowed('membership', 'all')) { $this->_redirect(ROOT_URL . '/' . $this->_zl->getLanguage() . '/error/restricted'); } $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(TRUE); $aResult = array(); $id = $this->_request->getParam('id') ? $this->_request->getParam('id') : ''; $tblInvoice = new App_Model_Db_Table_Invoice(); $rowInvoice = $tblInvoice->find($id)->current(); if ($rowInvoice) { if ($rowInvoice->isPaid == "N") { $tblUser = new App_Model_Db_Table_User(); $sql = $tblUser->select()->setIntegrityCheck(false); $sql->from(array('ku' => 'KutuUser'))->join(array('gag' => 'gacl_aro_groups'), 'ku.packageId = gag.id')->where('ku.kopel=?', $rowInvoice->uid); $rowUser = $tblUser->fetchRow($sql); if ($rowUser) { if (in_array($rowUser->packageId, array(14, 15, 16, 17, 18))) { $rowInvoice->invoiceConfirmDate = date("Y-m-d"); $rowInvoice->isPaid = 'Y'; // get expiration date $temptime = time(); $temptime = Pandamp_Lib_Formater::DateAdd('m', $rowUser->paymentId, $temptime); $rowInvoice->expirationDate = strftime('%Y-%m-%d', $temptime); $rowInvoice->save(); $rowUser->periodeId = 3; $rowUser->modifiedDate = date("Y-m-d h:i:s"); $rowUser->modifiedBy = "{$rowUser->username}"; $result = $rowUser->save(); if ($result) { $aResult['isError'] = false; $aResult['msg'] = $rowUser->username . ", confirm saved"; } else { $aResult['isError'] = true; $aResult['msg'] = "Error user confirmation!"; } } } else { $aResult['isError'] = true; $aResult['msg'] = 'There is no such user!'; } } else { $aResult['isError'] = true; $aResult['msg'] = 'Invoice has been paid!'; } } else { $aResult['isError'] = true; $aResult['msg'] = 'Wrong Package!'; } echo Zend_Json::encode($aResult); }
/** * _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 checkusernameAction() { $this->_helper->viewRenderer->setNoRender(TRUE); $username = $this->_getParam('username') ? $this->_getParam('username') : ''; $modelUser = new App_Model_Db_Table_User(); $rowset = $modelUser->fetchRow("username='******'"); if ($rowset) { $valid = 'false'; } else { $valid = 'true'; } echo $valid; die; }
function inaAction() { /* get GroupName echo $this->getUserGroupName('enisetiati'); * */ /* get Group Name Id $getGroupId = $this->getUserGroupId($this->getUserGroupName('enisetiati')); echo $getGroupId; * */ /* * Hukumonline Indonesia * 11 = admin * 41 = klinik_admin * 39 = marketing * 36 = member_admin * 34 = news_admin * 40 = holproject * 20 = dc_admin * 25 = member_gratis * 26 = member_individual * 27 = member_corporate */ $title = "<h4>MIGRASI HUKUMONLINE INDONESIA</h4><hr/>"; echo $title . '<br>'; $groupId = 36; require_once CONFIG_PATH . '/master-status.php'; $aroMap = App_Model_Show_Migration_AroGroupMapIn::show()->getObjectsByGroup($groupId); /* echo '<pre>'; print_r($aroMap); echo '</pre>'; * */ foreach ($aroMap as $value) { // $modelUser = new App_Model_Db_Table_User(); // $rowUser = $modelUser->fetchRow("username='******'name']."'"); // if (!$rowUser) { $ignoredUser = MasterStatus::ignoreUserMigration(); if (!in_array($value['name'], $ignoredUser)) { //echo $id.' - '.$value['name'].'<br>'; $rowUser = App_Model_Show_Migration_UserIn::show()->getUser($value['name']); //echo $id.' - '.$rowUser['fullName'].'<br>'; /* $groupName = $this->getUserGroupName($rowUser['username']); $getGroupId = $this->getUserGroupId($groupName); * */ if ($rowUser) { $rowUser['packageId'] = $groupId; //list($ret, $body) = Pandamp_Lib_Remote::serverCmd('migrationUser', $rowUser); $modelUser = new App_Model_Db_Table_User(); $dUser = $modelUser->fetchRow("username='******'username'] . "'"); $groupName = $this->getGroupName($groupId); if (!$dUser) { $data = $this->transformMigrationUser($rowUser); $result = $modelUser->insert($data); if ($result) { $this->updateKopel(); $groupName = $this->getGroupName($groupId); //$acl = new Kutu_Acl_Adapter_Local(); $acl = Pandamp_Acl::manager(); //$acl->addUser($_POST['username'],$groupName); $acl->addUserToGroup($rowUser['username'], $groupName); $message = "\n <div class='box box-info closeable'>\n User : <abbr>" . $rowUser['username'] . "</abbr> data has been successfully saved to local.\n </div><br>"; } else { $message = "\n <div class='box box-error'>ERROR</div> \n <div class='box box-error-msg'>\n <ol>\n <li>User : <abbr>" . $rowUser['username'] . "</abbr> data has failed saved to local.</li>\n </ol>\n </div><br>"; } echo $message; } /* echo '<pre>'; print_r($body); echo '</pre>'; die; * */ /* switch ($ret) { case 200: $message = " <div class='box box-info closeable'> User : <abbr>".$rowUser['username']."</abbr> data has been successfully saved to local. </div><br>"; break; default: $message = " <div class='box box-error'>ERROR</div> <div class='box box-error-msg'> <ol> <li>User : <abbr>".$rowUser['username']."</abbr> data has failed saved to local.</li> </ol> </div><br>"; } */ // echo $message; } /* else { echo " <div class='box box-error'>ERROR</div> <div class='box box-error-msg'> <ol> <li>User : <abbr>".$value['name']."</abbr> not active.</li> </ol> </div><br>"; } */ } // } } }
/** * Set Invoice * @param guid */ function setInvoiceAction() { $this->_helper->getHelper('layout')->disableLayout(); $this->_helper->getHelper('viewRenderer')->setNoRender(); $request = $this->getRequest(); $result = 'RESULT_ERROR'; if (Pandamp_Controller_Action_Helper_IsAllowed::isAllowed('membership', 'all')) { if ($request->isPost()) { $id = $request->getPost('id'); $modelUser = new App_Model_Db_Table_User(); $rowset = $modelUser->fetchRow("kopel='" . $id . "'"); $modelPackage = new App_Model_Db_Table_Package(); $rowPackage = $modelPackage->fetchRow("packageId=" . $rowset->packageId); //if ((in_array($rowset->packageId,array(14,15,16,17,18))) && ($rowset->paymentId <> 0) && ($rowset->isActive == 1)) if ($rowPackage && $rowset->paymentId != 0 && $rowset->isActive == 1) { $formater = new Pandamp_Core_Hol_User(); /** * @modifiedDate: Dec 07, 2012 */ // GET disc promo //$disc = $formater->checkPromoValidation('Disc',$rowset->packageId,$rowset->promotionId,$rowset->paymentId); // GET total promo //$total = $formater->checkPromoValidation('Total',$rowset->packageId,$rowset->promotionId,$rowset->paymentId); $total = $formater->checkPromoValidation('Total', $rowset->packageId, $rowset->paymentId); $disc = $formater->checkPromoValidation('Disc', $rowset->packageId, $rowset->paymentId); // WRITE invoice //$r = $formater->_writeInvoice($rowset->kopel, $total, $disc, $rowset->paymentId,'admin'); $r = $formater->_writeInvoice($rowset->kopel, $total, $disc, $rowset->paymentId, 'admin'); $result = $r; } else { $result = "check your payment/status"; } } } $this->getResponse()->setBody($result); }