function editprofileAction()
{
$r = $this->getRequest();
$auth = Zend_Auth::getInstance();
if (!$auth->hasIdentity()) {
$this->_redirect(KUTU_ROOT_URL . '/helper/sso/login' . '?returnTo=' . $sReturn);
} else {
$username = $auth->getIdentity()->username;
//echo $auth->getIdentity()->guid;
//die();
$this->view->username = $username;
}
$tblUser = new Kutu_Core_Orm_Table_User();
$row = $tblUser->fetchRow("username='******'");
$modDir = $this->getFrontController()->getModuleDirectory();
require_once $modDir . '/components/MyAccount/Menu.php';
$w = new MyAccount_Menu();
$this->view->widget1 = $w;
$this->view->row = $row;
$this->view->message = "";
if ($r->isPost()) {
$aData = $r->getParams();
//below is for security purpose. Making sure that the GUID being edited is the GUID of the logged in user
$aData['guid'] = $auth->getIdentity()->guid;
try {
$bpm = new Kutu_Core_Bpm_User();
$row = $bpm->editProfileByUser($aData);
$this->view->row = $row;
$this->view->message = "Data has been successfully saved.";
} catch (Zend_Exception $e) {
$this->view->message = $e->getMessage();
}
}
}
function activateAction()
{
$sReturn = "http://" . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
$sReturn = base64_encode($sReturn);
$r = $this->getRequest();
$id = $r->getParam("id");
$modelUser = new Kutu_Core_Orm_Table_User();
$rowset = $modelUser->find(base64_decode($id))->current();
if ($rowset) {
if ($rowset->periodeId == 2) {
$this->_forward('restricted', 'manager', 'membership', array('type' => 'user', 'num' => 106));
} elseif ($rowset->periodeId == 3) {
$this->_forward('restricted', 'manager', 'membership', array('type' => 'user', 'num' => 102));
} elseif ($rowset->periodeId == 4) {
$this->_forward('restricted', 'manager', 'membership', array('type' => 'user', 'num' => 'downgrade'));
} else {
$rowset->activationDate = date("Y-m-d h:i:s");
$rowset->isActive = 1;
$rowset->periodeId = 3;
$rowset->save();
$this->_forward('redirect-url', 'manager', 'membership', array('username' => $rowset->username, 'packageId' => $rowset->packageId, 'return' => $sReturn));
}
} else {
$this->_forward('restricted', 'manager', 'membership', array('type' => 'user', 'num' => 105));
}
}
public function getalluserAction()
{
$this->_helper->layout()->disableLayout();
//params: $folderGuid,$start,$limit,orderBy
$r = $this->getRequest();
$q = $r->getParam('q') ? base64_decode($r->getParam('q')) : "1=1";
$start = $r->getParam('start') ? $r->getParam('start') : 0;
$limit = $r->getParam('limit') ? $r->getParam('limit') : 0;
$orderBy = $r->getParam('orderBy') ? $r->getParam('sortBy') : 'firstname';
$sortOrder = $r->getParam('sortOrder') ? $r->getParam('sortOrder') : ' asc';
$a = array();
$tblUser = new Kutu_Core_Orm_Table_User();
//echo $q;die();
$rowset = $tblUser->fetchAll($q, 'firstname ASC', $limit, $start);
if (count($rowset) == 0) {
$a['catalogs'][0]['guid'] = 'XXX';
$a['catalogs'][0]['title'] = "No Data";
$a['catalogs'][0]['subTitle'] = "";
$a['catalogs'][0]['createdDate'] = '';
$a['catalogs'][0]['modifiedDate'] = '';
} else {
$ii = 0;
foreach ($rowset as $row) {
$a['catalogs'][$ii]['guid'] = $row->guid;
$a['catalogs'][$ii]['title'] = $row->firstname . ' ' . $row->lastname;
$a['catalogs'][$ii]['subTitle'] = $row->username;
$a['catalogs'][$ii]['createdDate'] = $row->createdDate;
$a['catalogs'][$ii]['modifiedDate'] = $row->modifiedDate;
$ii++;
}
}
echo Zend_Json::encode($a);
die;
}
public function checkoutAction()
{
$auth = Zend_Auth::getInstance();
$userId = $auth->getIdentity()->guid;
$tblUser = new Kutu_Core_Orm_Table_User();
$userDetailInfo = $tblUser->find($userId)->current();
$tblUserFinance = new Kutu_Core_Orm_Table_UserFinance();
$userFinanceInfo = $tblUserFinance->find($userId)->current();
if (empty($userFinanceInfo)) {
$finance = $tblUserFinance->fetchNew();
$finance->userId = $userId;
$finance->taxNumber = '';
$finance->taxCompany = $userDetailInfo->company;
$finance->taxAddress = $userDetailInfo->mainAddress;
$finance->taxCity = $userDetailInfo->city;
$finance->taxProvince = $userDetailInfo->state;
$finance->taxCountryId = $userDetailInfo->countryId;
$finance->taxZip = $userDetailInfo->zip;
$finance->save();
}
$userFinanceInfo = $tblUserFinance->find($userId)->current();
//print_r($_POST);
$cart =& $_SESSION['jCart'];
if (!is_object($cart)) {
$cart = new jCart();
}
$this->view->cart = $cart;
//print_r($_SESSION['jCart']);
$this->view->userInfo = $userFinanceInfo;
//if($this->_configStore->store->isClosed)
if ($this->_isStoreClosed()) {
$this->_forward('closed', 'store', 'site');
}
}
public function getExpiredDay()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$tblUsername = new Kutu_Core_Orm_Table_User();
$rowset = $tblUsername->getExpiredDay($auth->getIdentity()->username, 2);
if ($rowset) {
return $rowset;
}
}
}
public function verifyoldpasswordAction()
{
$r = $this->getRequest();
$oldPassword = $r->getParam('oldPassword');
$auth = Zend_Auth::getInstance();
$obj = new Kutu_Crypt_Password();
$tblUser = new Kutu_Core_Orm_Table_User();
$row = $tblUser->find($auth->getIdentity()->guid)->current();
if ($obj->matchPassword($oldPassword, $row->password)) {
die('1');
} else {
die('0');
}
}
public function sendReceiptToUser($orderId, $paymentMethod = '', $statusText = '')
{
$config = new Zend_Config_Ini(KUTU_ROOT_DIR . '/application/configs/mail.ini', 'general');
$siteOwner = "Hukumonline";
$siteName = $config->mail->sender->support->name;
$contactEmail = $config->mail->sender->support->email;
$tblOrder = new Kutu_Core_Orm_Table_Order();
$rowOrder = $tblOrder->find($orderId)->current();
$userId = $rowOrder->userId;
//first check if orderId status is PAID, then send the email.
switch ($rowOrder->orderStatus) {
case 1:
die('ORDER STATUS IS NOT YET PAID. CAN NOT SEND RECEIPT!.');
break;
case 3:
$orderStatus = "PAID";
break;
case 5:
$orderStatus = "POSTPAID PENDING";
break;
case 6:
$orderStatus = "PAYMENT REJECTED";
break;
case 7:
$orderStatus = "PAYMENT ERROR";
break;
default:
$orderStatus = "PAYMENT ERROR";
break;
}
$tblUser = new Kutu_Core_Orm_Table_User();
$rowUser = $tblUser->find($userId)->current();
$userEmail = $rowUser->email;
$userFullname = $rowUser->fullName;
switch (strtolower($paymentMethod)) {
case 'paypal':
case 'manual':
case 'bank':
case 'postpaid':
default:
$message = "\t\t\t\t\t\r\nDear {$userFullname},\r\n\r\nThis is a payment receipt for Invoice # {$rowOrder->invoiceNumber}\r\n\r\nTotal Amount: USD {$rowOrder->orderTotal}\r\nTransaction #:\r\nTotal Paid: USD {$rowOrder->orderTotal}\r\nStatus: {$orderStatus}\r\nYour payment method is: {$paymentMethod}\r\n\r\nYou may review your invoice history at any time by logging in to your account " . KUTU_ROOT_URL . "/store/payment/list\r\n\r\nNote: This email will serve as an official receipt for this payment.\r\n\r\nSalam,\r\n\r\nHukumonline\r\n\r\n==============================";
}
$this->send($config->mail->sender->support->email, $config->mail->sender->support->name, $userEmail, '', "Hukumonline Receipt Invoice# " . $rowOrder->invoiceNumber, $message);
}
function processAction()
{
$formater = new Kutu_Core_Hol_User();
$orderId = $this->_request->getParam('orderId');
$packageId = $this->_request->getParam('packageId');
$paymentSubscription = $this->_request->getParam('paymentSubscription');
$this->_orderIdNumber = $orderId;
if (empty($orderId)) {
echo "kosong";
die;
}
include_once KUTU_ROOT_DIR . '/application/models/Store.php';
$modelAppStore = new App_Model_Store();
if ($modelAppStore->isOrderPaid($orderId)) {
//forward to error page
$this->_helper->redirector->gotoSimple('error', 'store', 'hol-site', array('view' => 'orderalreadypaid'));
die;
}
$tblOrder = new Kutu_Core_Orm_Table_Order();
$items = $tblOrder->getOrderDetail($orderId);
$tmpMethod = $this->_request->getParam('method');
if (!empty($tmpMethod)) {
$items[0]['paymentMethod'] = $tmpMethod;
}
$tblUser = new Kutu_Core_Orm_Table_User();
$rowUser = $tblUser->find($items[0]['userId'])->current();
$total = $formater->checkPromoValidation('Total', $packageId, $rowUser->promotionId, $paymentSubscription);
switch ($items[0]['paymentMethod']) {
case 'nsiapay':
require_once 'PaymentGateway/Nsiapay.php';
// include the class file
$paymentObject = new Nsiapay();
// initiate an instance of the class
if ($this->_testMode) {
$paymentObject->enableTestMode();
}
$paymentObject->addField('TYPE', "IMMEDIATE");
$subTotal = 0;
for ($iCart = 0; $iCart < count($items); $iCart++) {
$i = $iCart + 1;
$basket[] = $items[$iCart]['documentName'] . "," . $items[$iCart]['price'] . ".00" . "," . $items[$iCart]['qty'] . "," . $items[$iCart]['finalPrice'] . ".00";
$subTotal += $items[$iCart]['price'] * $items[$iCart]['qty'];
}
$ca = implode(";", $basket);
$merchantId = "000100090000028";
$paymentObject->addField("BASKET", $ca);
$paymentObject->addField("MERCHANTID", $merchantId);
$paymentObject->addField("CHAINNUM", "NA");
$paymentObject->addField("TRANSIDMERCHANT", $items[0]['invoiceNumber']);
$paymentObject->addField("AMOUNT", $subTotal);
$paymentObject->addField("CURRENCY", "360");
$paymentObject->addField("PurchaseCurrency", "360");
$paymentObject->addField("acquirerBIN", "360");
$paymentObject->addField("password", "123456");
$paymentObject->addField("URL", "http://hukumonline.pl");
$paymentObject->addField("MALLID", "199");
$paymentObject->addField("SESSIONID", Zend_Session::getId());
$sha1 = sha1($subTotal . ".00" . $merchantId . "08iIWbWvO16w" . $items[0]['invoiceNumber']);
// echo $subTotal.".00".$merchantId."08iIWbWvO16w".$items[0]['invoiceNumber']."<br>";
// echo $sha1;die;
$paymentObject->addField("WORDS", $sha1);
//$paymentObject->dumpFields();
$this->_helper->layout->disableLayout();
$paymentObject->submitPayment();
break;
case 'manual':
case 'bank':
/*
1. update order status
2. redirect to instruction page
*/
//setting payment and status as pending (1), notify = 0, notes = 'paid with...'
$this->updateInvoiceMethod($orderId, 'bank', 1, 0, 'paid with manual method');
// HAP: i think we should send this notification when user were on page "Complete Order" and after confirmation made by user is approved;
//$this->Mailer($orderId, 'admin-order', 'admin');
//$this->Mailer($orderId, 'user-order', 'user');
$this->_helper->redirector('instruction', 'payment', 'membership', array('orderId' => $orderId));
break;
}
}
function getMeEmailAction()
{
$this->_helper->layout()->disableLayout();
$request = $this->getRequest();
$email = $request->getParam('email') ? $request->getParam('email') : '';
$response = array();
if ($email == "undefined") {
$response['failure'] = true;
$response['message'] = 'Email is Empty';
} else {
$tableUser = new Kutu_Core_Orm_Table_User();
$rowUser = $tableUser->fetchRow("email='" . $email . "'");
if (!empty($rowUser->email)) {
$response['failure'] = true;
$response['message'] = '<i><b>' . $email . '</b></i> is not available';
} else {
$response['success'] = true;
$response['message'] = '<i><b>' . $email . '</b></i> is available';
}
}
echo Zend_Json::encode($response);
}
private function _checkAuth()
{
$auth = Zend_Auth::getInstance();
$userId = $auth->getIdentity()->guid;
if (!$auth->hasIdentity()) {
$this->_redirect(KUTU_ROOT_URL . '/helper/sso/login' . '?returnTo=' . $sReturn);
} else {
// [TODO] else: check if user has access to admin page
$username = $auth->getIdentity()->username;
$this->view->username = $username;
}
//$userId=$auth->getIdentity()->guid;
$tblUser = new Kutu_Core_Orm_Table_User();
$this->_userDetailInfo = $tblUser->find($userId)->current();
$tblUserFinance = new Kutu_Core_Orm_Table_UserFinance();
$this->_userInfo = $tblUserFinance->find($userId)->current();
if (empty($this->_userInfo)) {
$finance = $tblUserFinance->fetchNew();
$finance['userId'] = $userId;
$finance->save();
$this->_userInfo = $tblUserFinance->find($userId)->current();
}
}
public function Mailer($idOrder, $key, $userTo)
{
$mail = new PaymentGateway_HtmlMail();
$tblSetting = new Kutu_Core_Orm_Table_PaymentSetting();
$template = $tblSetting->fetchAll($tblSetting->select()->where("settingKey = '{$key}'"));
$tblOrder = new Kutu_Core_Orm_Table_Order();
$tblOrderDetail = new Kutu_Core_Orm_Table_OrderDetail();
$rowset = $tblOrder->getOrderAndStatus($idOrder);
//echo '<pre>';
//print_r($_SESSION['_orderIdNumber']);
$rowsetDetail = $tblOrderDetail->fetchAll($tblOrderDetail->select()->where("orderId = " . $idOrder));
$tblConfirm = new Kutu_Core_Orm_Table_PaymentConfirmation();
$unConfirmed = $tblConfirm->fetchAll($tblConfirm->select()->where("confirmed =0 AND orderId = " . $idOrder));
$detail = "ORDER ID : " . $idOrder . '<br/>' . 'Detail : <br/><blockquote><ol>';
foreach ($rowsetDetail as $row) {
$detail .= '<li><ul>
<li>Document Name: ' . $row->documentName . '</li>
<li>Quantity : ' . $row->qty . '</li>
<li>Price : USD ' . number_format($row->price, 2) . ' </li>
<li>Tax : ' . number_format($row->tax, 2) . ' %</li>
<li>Final Price : ' . number_format($row->finalPrice, 2) . '</li>
</ul></li>';
}
$detail .= '</ol></blockquote>';
//$userId=$rowset[0]['userId'];
//echo $userId;
$auth = Zend_Auth::getInstance();
$userId = $auth->getIdentity()->guid;
$tblUser = new Kutu_Core_Orm_Table_User();
$this->_userDetailInfo = $tblUser->find($userId)->current();
$sMailSource = $template[0]->note;
$tblSetting = new Kutu_Core_Orm_Table_PaymentSetting();
$adminMail = $tblSetting->fetchAll($tblSetting->select()->where("settingKey = 'paypalBusiness'"));
if ($userTo == 'admin') {
$sMailEmailTo = $adminMail[0]->settingValue;
//die($this->_userDetailInfo->email);
$sMailEmailFrom = $this->_userDetailInfo->email;
$link = '<a href="' . KUTU_ROOT_URL . '/admin/store/detailOrder/id/' . $idOrder . '">here</a>';
} else {
$sMailEmailTo = $this->_userDetailInfo->email;
$sMailEmailFrom = $adminMail[0]->settingValue;
$link = '<a href="' . KUTU_ROOT_URL . '/site/store_payment/detail/id/' . $idOrder . '">here</a>';
}
$sMailSubject = "Confirmation for user payment";
$sMailHeader = '';
$aMailDataSet = array('PAYMENTDATE' => @$unConfirmed[0]->paymentDate, 'PAYMENT' => $rowset[0]->paymentMethod, 'DESCRIPTION' => $detail, 'TOTALORDER' => $rowset[0]->orderTotal, 'ORDERTIME' => $rowset[0]->datePurchased, 'INVOICE' => $rowset[0]->invoiceNumber, 'METHOD' => $rowset[0]->paymentMethod, 'LINK' => $link);
$mail->SendFileMail($sMailSource, $sMailEmailTo, $sMailSubject, $sMailEmailFrom, $sMailHeader, $aMailDataSet);
}
function checkemailAction()
{
$this->_helper->viewRenderer->setNoRender(TRUE);
$email = $this->_getParam('email') ? $this->_getParam('email') : '';
$modelUser = new Kutu_Core_Orm_Table_User();
$rowset = $modelUser->fetchRow("email='{$email}'");
if ($rowset) {
$valid = 'false';
} else {
$valid = 'true';
}
echo $valid;
die;
}
public function changepasswordAction()
{
$r = $this->getRequest();
$guid = $r->getParam('guid');
$tblUser = new Kutu_Core_Orm_Table_User();
$row = $tblUser->find($guid)->current();
$this->view->rowUser = $row;
if ($r->isPost()) {
echo "<strong> THIS FUNCTION IS NOT YET IMPLEMENTED</strong>";
}
}
public function sendPaypalCompleteNotificationToUser($orderId)
{
$config = new Zend_Config_Ini(KUTU_ROOT_DIR . '/application/configs/mail.ini', 'general');
$sOrderId = '';
$tblUser = new Kutu_Core_Orm_Table_User();
$tblOrder = new Kutu_Core_Orm_Table_Order();
$rowOrder = $tblOrder->find($orderId)->current();
$userId = $rowOrder->userId;
$rowUser = $tblUser->find($userId)->current();
$userEmail = $rowUser->email;
$userFullname = $rowUser->firstname . ' ' . $rowUser->lastname;
$message = "\t\t\t\t\t\nYour Paypal payment for item(s) with Order ID {$sOrderId} has been completely proceed.\n\nnow you can continue to <a href=\"" . KUTU_ROOT_URL . "/site/store_payment/document\">download the document(s)</a> or just continue <a href=\"" . KUTU_ROOT_URL . "/dms\">browsing our database</a>..\n\n==============================";
$sFile = "sendPaypalCompleteNotificationToUser.log";
$content = "SENDER : " . $config->mail->sender->support->email . "\n";
$content .= "NAME : " . $config->mail->sender->support->name . "\n";
$content .= "RECIPIENT : " . $userEmail;
$content .= "MESSAGE : [LGS ONLINE] Receipt Invoice# " . $rowOrder->invoiceNumber . $message . "\n";
$this->logThisMail($sFile, $content);
$this->send($config->mail->sender->support->email, $config->mail->sender->support->name, $userEmail, '', "[LGS ONLINE] Paypal Payment Complete ", $message);
}
function _writeConfirmCorporateEmail($mailcontent, $company, $payment, $disc, $total, $username, $guid, $email)
{
$formater = new Kutu_Lib_Formater();
$obj = new Kutu_Crypt_Password();
$mailcontent = str_replace('$company', $company, $mailcontent);
$mailcontent = str_replace('$timeline', $payment, $mailcontent);
$mailcontent = str_replace('$disc', $disc, $mailcontent);
$mailcontent = str_replace('$price', number_format($total), $mailcontent);
$mailcontent = str_replace('$username1', $username, $mailcontent);
$mailcontent = str_replace('$guid', $guid, $mailcontent);
// table User
$tblUser = new Kutu_Core_Orm_Table_User();
$where = $tblUser->getAdapter()->quoteInto('company=?', $company);
$rowUser = $tblUser->fetchAll($where, 'username ASC');
$tag = '<table>';
$tag .= '<tr><td><b>Username</b></td><td> </td><td> </td><td> </td><td><b>Password</b></td></tr>';
foreach ($rowUser as $rowsetUser) {
$tag .= '<tr><td>' . $rowsetUser->username . '</td><td> </td><td> </td><td> </td><td>' . $obj->decryptPassword($rowsetUser->password) . '</td></tr>';
}
$tag .= '</table>';
$mailcontent = str_replace('$tag', $tag, $mailcontent);
$mail_body = $mailcontent;
// parse ini_file
$config = new Zend_Config_Ini(KUTU_ROOT_DIR . '/app/config/config.ini', 'mail');
$mailAttempt = $formater->add_mail($config->from, $email, $username, 'Hukumonline-ID', $mail_body);
// try to save mail before send
if ($mailAttempt) {
$sendAttempt = $formater->send_mail();
if ($sendAttempt) {
$response['success'] = true;
$response['message'] = "Please check your email at {$email}!";
} else {
ob_clean();
$response['failure'] = false;
$response['message'] = "Error send mail but register user successfully!<br>Please contact our customer service for more information";
}
} else {
$response['failure'] = true;
$response['message'] = "Error saving mail!";
}
echo Zend_Json::encode($response);
}
public function newsletterAction()
{
$this->_helper->layout()->setLayout('layout-final-inside');
$auth = Zend_Auth::getInstance();
$userGuid = $auth->getIdentity()->guid;
$tblUser = new Kutu_Core_Orm_Table_User();
$rowUser = $tblUser->find($userGuid)->current();
if (!empty($rowUser)) {
$this->view->email = $rowUser->email;
}
}
private function _migrateAllUsers()
{
$sqlSource = "SELECT * from tblPersonalization_User";
$this->_dbSource->setFetchMode(Zend_Db::FETCH_OBJ);
$results = $this->_dbSource->fetchAll($sqlSource);
// do mapping
if (count($results)) {
foreach ($results as $row) {
$tblUser = new Kutu_Core_Orm_Table_User();
$rowsetUser = $tblUser->find($this->_guidPrefix . $row->UserID);
if (count($rowsetUser) < 1) {
// do something
$rowUser = $tblUser->fetchNew();
$rowUser->guid = $this->_guidPrefix . $row->UserID;
$rowUser->username = $row->UserName;
$rowUser->password = is_null($row->Password) ? 'V3FXfFJzBnpVYg==' : $row->Password;
$rowUser->firstname = $row->FullName;
$rowUser->lastname = '';
$rowUser->email = $row->Email;
$rowUser->company = $row->CompanyName;
$rowUser->mainAddress = $row->Address;
$rowUser->zip = $row->ZIP;
$rowUser->phone = $row->Phone;
$rowUser->industryId = $row->CompBusLine;
$rowUser->isActive = is_null($row->isActive) ? 0 : $row->isActive;
$rowUser->createdDate = $row->DateCreate;
$rowUser->registrationDate = $rowUser->createdDate;
$sqlMembership = "SELECT * from tblMembership_Exp where User_ID={$row->UserID}";
$this->_dbSource->setFetchMode(Zend_Db::FETCH_OBJ);
$resultsMembership = $this->_dbSource->fetchAll($sqlMembership);
//print_r($resultsMembership);
//die();
if (count($resultsMembership)) {
$rowMembership = $resultsMembership[0];
$rowUser->fax = $rowMembership->Fax;
$rowUser->activationDate = $rowMembership->Activation_Date;
$rowUser->expirationDate = $rowMembership->Expiration_Date;
}
//if($row->UserID==157)
if (true) {
$rowUser->save();
//die();
}
//Must also assign assign user as group:member_free
$acl = Kutu_Acl_Manager::getAdapter();
$acl->addUserToGroup($rowUser->username, "member_free");
} else {
}
}
}
die;
}
public function delete($userId)
{
//[TODO] WE MUST DEFINE RELATIONSHIP AND CASCADE DELETE ON EVERY TABLES
$tblUser = new Kutu_Core_Orm_Table_User();
$rowUser = $tblUser->find($userId)->current();
$username = $rowUser->username;
print_r($username);
//delete from KutuOrder
//$tblOrder = new Kutu_Core_Orm_Table_Order();
//$tblOrder->delete("userId='$userId'");
//delete from PHPGACL (use PHPGACL function to delete user)
$acl = Kutu_Acl::manager();
$acl->deleteUser($username);
//delete from KutuUserFinance
$tblUserFinance = new Kutu_Core_Orm_Table_UserFinance();
$rowsetUserFinance = $tblUserFinance->find($userId);
if (count($rowsetUserFinance)) {
$rowUserFinance = $rowsetUserFinance->current();
$rowUserFinance->delete();
}
//delete from KutuUser
$rowUser->delete();
//delete from all table that Chenri made (Store related tables)
}
public function loginAction()
{
//$this->_helper->layout->disableLayout();
$this->_helper->layout()->setLayout('layout-lgs');
$r = $this->getRequest();
//$returnTo = $r->getParam('returnTo');
//$this->view->returnTo = urlencode($returnTo);
if ($r->isPost()) {
$returnTo = $r->getParam('returnTo');
$this->view->returnTo = $returnTo;
Zend_Session::rememberMe(86400);
$saveHandler = Zend_Session::getSaveHandler();
$saveHandler->setLifetime(87500)->setOverrideLifetime(true);
Zend_Session::start();
$username = $r->getParam('username');
$password = $r->getParam('password');
$registry = Zend_Registry::getInstance();
$application = $registry->get('application');
//ensure resource Session has/is initialized;
//$application->getBootstrap()->bootstrap('identity');
$identity = $application->getBootstrap()->getResource('identity');
$authAdapter = $identity->authAdapter;
$authAdapter->setIdentity($username)->setCredential($password);
$auth = Zend_Auth::getInstance();
$authResult = $auth->authenticate($authAdapter);
if ($authResult->isValid()) {
Zend_Session::regenerateId();
// success : store database row to auth's storage
$data = $authAdapter->getResultRowObject();
$auth->getStorage()->write($data);
if (strpos($returnTo, '?')) {
$sAddition = '&';
} else {
$sAddition = '?';
}
//[TODO] update last login date in tbl User
//[TODO] update last login IP in tbl User
$tblUser = new Kutu_Core_Orm_Table_User();
$row = $tblUser->fetchRow($tblUser->select()->where('username = ?', $username));
$ip = $this->real_ip_address();
$row->lastLoginIp = $ip;
$today = date('Y-m-d h:i:s');
$row->lastLoginDate = $today;
$row->save();
header("location: " . $returnTo . $sAddition . "PHPSESSID=" . Zend_Session::getId());
} else {
if ($authResult->getCode() != -51) {
// failure : clear database row from session
Zend_Auth::getInstance()->clearIdentity();
}
$this->view->errorMessage = "Login GAGAL";
}
} else {
Zend_Session::start();
$returnTo = $r->getParam('returnTo');
if (!empty($returnTo)) {
$returnTo = urldecode($returnTo);
$this->view->returnTo = $returnTo;
} else {
//$returnTo = KUTU_ROOT_URL.'/identity/account';
$returnTo = KUTU_ROOT_URL . '/pages';
$this->view->returnTo = $returnTo;
}
//check sudah login belum
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
//echo "punya identitas";
if (strpos($returnTo, '?')) {
$sAddition = '&';
} else {
$sAddition = '?';
}
header("location: " . $returnTo . $sAddition . "PHPSESSID=" . Zend_Session::getId());
}
}
}
public function save($aData)
{
if (isset($aData['fullname']) && !empty($aData['fullname'])) {
$aData['firstname'] = $aData['fullname'];
}
if (empty($aData['firstname'])) {
throw new Zend_Exception('Firstname can not be EMPTY!');
}
$tblUser = new Kutu_Core_Orm_Table_User();
$gman = new Kutu_Core_Guid();
$guid = isset($aData['guid']) && !empty($aData['guid']) ? $aData['guid'] : $gman->generateGuid();
//if not empty, there are 2 possibilities
$tblUser = new Kutu_Core_Orm_Table_User();
$row = $tblUser->fetchRow("guid='{$guid}'");
if (empty($row)) {
if (empty($aData['username'])) {
throw new Zend_Exception('Username can not be EMPTY!');
}
if (empty($aData['password'])) {
throw new Zend_Exception('Password can not be EMPTY!');
}
$row = $tblUser->createRow();
if (isset($aData['username']) && !empty($aData['username'])) {
//check if username was already taken
$username = $aData['username'];
$tblUser = new Kutu_Core_Orm_Table_User();
$rowUsername = $tblUser->fetchRow("username='******'");
if ($rowUsername) {
throw new Zend_Exception('Username exists');
}
$row->username = $aData['username'];
}
if (isset($aData['password']) && !empty($aData['password'])) {
$password = $aData['password'];
$crypt = new Kutu_Crypt_Password();
$password = $crypt->encryptPassword($password);
$row->password = $password;
}
}
if (isset($aData['firstname'])) {
$row->firstname = $aData['firstname'];
}
if (isset($aData['lastname'])) {
$row->lastname = $aData['lastname'];
}
if (isset($aData['email'])) {
$row->email = $aData['email'];
}
if (isset($aData['bbPin'])) {
$row->bbPin = $aData['bbPin'];
}
if (isset($aData['clientId'])) {
$row->clientId = $aData['clientId'];
}
if (isset($aData['mainAddress'])) {
$row->mainAddress = $aData['mainAddress'];
}
if (isset($aData['city'])) {
$row->city = $aData['city'];
}
if (isset($aData['state'])) {
$row->state = $aData['state'];
}
if (isset($aData['zip'])) {
$row->zip = $aData['zip'];
}
if (isset($aData['phone'])) {
$row->phone = $aData['phone'];
}
if (isset($aData['fax'])) {
$row->fax = $aData['fax'];
}
if (isset($aData['url'])) {
$row->url = $aData['url'];
}
if (isset($aData['countryId'])) {
$row->countryId = $aData['countryId'];
}
if (isset($aData['company'])) {
$row->company = $aData['company'];
}
if (isset($aData['companySizeId'])) {
$row->companySizeId = $aData['companySizeId'];
}
if (isset($aData['jobId'])) {
$row->jobId = $aData['jobId'];
}
if (isset($aData['industryId'])) {
$row->industryId = $aData['industryId'];
}
if (isset($aData['isActive'])) {
$row->isActive = $aData['isActive'];
}
if (isset($aData['registrationDate'])) {
$row->registrationDate = $aData['registrationDate'];
}
if (isset($aData['activationDate'])) {
$row->activationDate = $aData['activationDate'];
}
if (isset($aData['activationCode'])) {
$row->activationCode = $aData['activationCode'];
}
if (isset($aData['expirationDate'])) {
$row->expirationDate = $aData['expirationDate'];
}
$row->save();
return $row;
}
public function save($aData)
{
$guid = $aData['kopel'];
//if not empty, there are 2 possibilities
$tblUser = new Kutu_Core_Orm_Table_User();
$row = $tblUser->fetchRow("kopel='{$guid}'");
if (isset($aData['email'])) {
$row->email = $aData['email'];
}
if (isset($aData['fullName'])) {
$row->fullName = $aData['fullName'];
}
if (isset($aData['chkGender'])) {
$row->gender = $aData['chkGender'] == 1 ? 'L' : 'P';
}
if (isset($aData['year'])) {
$row->birthday = $aData['year'] . '-' . $aData['month'] . '-' . $aData['day'];
}
if (isset($aData['education'])) {
$row->educationId = $aData['education'];
}
if (isset($aData['expense'])) {
$row->expenseId = $aData['expense'];
}
if (isset($aData['company'])) {
$row->company = $aData['company'];
}
if (isset($aData['businessType'])) {
$row->businessTypeId = $aData['businessType'];
}
if (isset($aData['phone'])) {
$row->phone = $aData['phone'];
}
if (isset($aData['fax'])) {
$row->phone = $aData['fax'];
}
if (isset($aData['packageId'])) {
$row->packageId = $aData['packageId'];
}
if (isset($aData['newArticle']) && $aData['newArticle'] == 1) {
$row->newArticle = 'Y';
} else {
if (!isset($aData['email']) && !isset($aData['username'])) {
$row->newArticle = 'N';
}
}
if (isset($aData['newRegulation']) && $aData['newRegulation'] == 1) {
$row->monthlyList = 'Y';
} else {
if (!isset($aData['email']) && !isset($aData['username'])) {
$row->monthlyList = 'N';
}
}
if (isset($aData['newWeeklyRegulation']) && $aData['newWeeklyRegulation'] == 1) {
$row->weeklyList = 'Y';
} else {
if (!isset($aData['email']) && !isset($aData['username'])) {
$row->weeklyList = 'N';
}
}
$row->save();
return $row;
}
function migrationUser()
{
$data = $this->transformMigrationUser($_POST);
/*
echo '<pre>';
print_r($data);
echo '</pre>';
*
*/
$modelUser = new Kutu_Core_Orm_Table_User();
$rowUser = $modelUser->fetchRow("username='******'username'] . "'");
if (!$rowUser) {
$modelUser->insert($data);
$this->updateKopel();
$groupName = $this->getGroupName($_POST['packageId']);
$acl = new Kutu_Acl_Adapter_Local();
//$acl->addUser($_POST['username'],$groupName);
$acl->addUserToGroup($_POST['username'], $groupName);
}
}
static function get_user_id($username)
{
$tblUser = new Kutu_Core_Orm_Table_User();
$rowUser = $tblUser->fetchRow("username='******'");
return $rowUser->kopel;
}
