public function login_reader()
{
if (isset($_COOKIE[$this->cookie_name])) {
$obj = new Pandamp_Crypt_Password();
$cookie_parts = explode(chr(31), $_COOKIE[$this->cookie_name]);
$this->user = $cookie_parts[0];
$this->user_pw = $obj->decryptPassword($cookie_parts[1]);
$this->is_cookie = true;
}
}
/**
* _writeConfirmCorporateEmail
* @return JSON
*/
function _writeConfirmCorporateEmail($mailcontent, $fullname, $company, $payment, $disc, $total, $username, $guid, $email)
{
$obj = new Pandamp_Crypt_Password();
$mailcontent = str_replace('$fullname', $fullname, $mailcontent);
$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 Pandamp_Modules_Identity_User_Model_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><b>Password</b></td></tr>';
foreach ($rowUser as $rowsetUser) {
$tag .= '<tr><td>' . $rowsetUser->username . '</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(CONFIG_PATH . '/mail.ini', 'mail');
$mailAttempt = $this->add_mail($config->mail->sender->support->email, $email, $username, $config->mail->sender->support->name, $mail_body);
// try to save mail before send
if ($mailAttempt) {
$sendAttempt = $this->send_mail();
if ($sendAttempt) {
$response['success'] = true;
$response['message'] = "Please check your email at {$email}!";
// update user
$rowUser = $tblUser->find($obj->decryptPassword($guid))->current();
if ($rowUser) {
$rowUser->isEmailSent = 'Y';
$rowUser->save();
}
} else {
$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);
}
/**
* _writeConfirmFreeEmail
* @return JSON
*/
function _writeConfirmFreeEmail($mailcontent, $fullname, $username, $password, $guid, $email, $package = '')
{
$obj = new Pandamp_Crypt_Password();
$aclMan = Pandamp_Acl::manager();
$mailcontent = str_replace('$fullname', $fullname, $mailcontent);
$mailcontent = str_replace('$username', $username, $mailcontent);
$mailcontent = str_replace('$password', $password, $mailcontent);
$mailcontent = str_replace('$guid', $guid, $mailcontent);
$mailcontent = str_replace('$package', $package, $mailcontent);
$mail_body = $mailcontent;
// parse ini_file
$config = new Zend_Config_Ini(CONFIG_PATH . '/mail.ini', 'mail');
$mailAttempt = $this->add_mail($config->mail->sender->support->email, $email, $username, $config->mail->sender->support->name, $mail_body);
// try to save mail before send
if ($mailAttempt) {
$sendAttempt = $this->send_mail();
if ($sendAttempt) {
$message = "Please check your email at {$email}!";
// update user
$tblUser = new App_Model_Db_Table_User();
$rowUser = $tblUser->find($obj->decryptPassword($guid))->current();
if ($rowUser) {
$rowUser->isEmailSent = 'Y';
$rowUser->save();
}
} else {
$message = "Error send mail but register user successfully!<br>Please contact our customer service for more information";
}
} else {
$message = "Error saving mail!";
}
return $message;
}
function decryptPasswordAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(TRUE);
$userDb = new App_Model_Db_Table_User();
$users = $userDb->fetchAll();
foreach ($users as $user) {
$obj = new Pandamp_Crypt_Password();
$passwd = $obj->decryptPassword($user->password);
if ($passwd == 'g00dPa$$w0rD') {
echo $user->kopel . '<br>';
}
}
//echo md5('SolrRocks');
//$obj = new Pandamp_Crypt_Password();
//echo $obj->decryptPassword('VTIDb1o8Bz0LaApsUndSJgtoB3QDJ1x2');
/*for($i = 1; $i <=10; $i++) {
$plainPassword = $this->generateRandomString();
$cryptedPassword = $obj->encryptPassword($plainPassword);
$deCryptedPassword = $obj->decryptPassword($cryptedPassword);
echo $cryptedPassword.' '.$deCryptedPassword.' plainnya: '.$plainPassword."<br>";
}*/
}
/**
* TODO
* admin sentEmail
* @param id, uid
*/
function sentEmailAction()
{
$guid = $this->_getParam('guid') ? $this->_getParam('guid') : '';
$formater = new Pandamp_Core_Hol_User();
$obj = new Pandamp_Crypt_Password();
$aclMan = Pandamp_Acl::manager();
$tblUser = new Pandamp_Modules_Identity_User_Model_User();
$rowUser = $tblUser->find($guid)->current();
if ($rowUser->packageId == 26) {
// Get disc promo
$disc = $formater->checkPromoValidation('Disc', $aclMan->getGroupIds('member_individual'), $rowUser->promotionId, $rowUser->paymentId);
// Get total promo
$total = $formater->checkPromoValidation('Total', $aclMan->getGroupIds('member_individual'), $rowUser->promotionId, $rowUser->paymentId);
// get mail content
$mailcontent = $formater->getMailContent('konfirmasi-email-individual');
// write confirm individual email
$formater->_writeConfirmIndividualEmail($mailcontent, $rowUser->fullName, $rowUser->username, $obj->decryptPassword($rowUser->password), $rowUser->paymentId, $disc, $total, base64_encode(Pandamp_Lib_Formater::get_user_id($rowUser->username)), $rowUser->email);
} elseif ($rowUser->packageId == 27) {
// Get disc promo
$disc = $formater->checkPromoValidation('Disc', $aclMan->getGroupIds('member_corporate'), $rowUser->promotionId, $rowUser->paymentId);
// Get total promo
$total = $formater->checkPromoValidation('Total', $aclMan->getGroupIds('member_corporate'), $rowUser->promotionId, $rowUser->paymentId);
// get mail content
$mailcontent = $formater->getMailContent('konfirmasi-email-korporasi');
// write confirm korporasi email
$formater->_writeConfirmCorporateEmail($mailcontent, $rowUser->fullName, $rowUser->company, $rowUser->paymentId, $disc, $total, $rowUser->username, base64_encode(Pandamp_Lib_Formater::get_user_id($rowUser->username)), $rowUser->email);
} else {
// get mail content
$mailcontent = $formater->getMailContent('konfirmasi email gratis');
// write confirm free email
$aReturn = $aclMan->getGroupData($rowUser->packageId);
$formater->_writeConfirmFreeEmail($mailcontent, $rowUser->fullName, $rowUser->username, $obj->decryptPassword($rowUser->password), base64_encode(Pandamp_Lib_Formater::get_user_id($rowUser->username)), $rowUser->email, $aReturn[2]);
}
}
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";
$pColumns = array('ku.kopel', 'ku.username', 'ku.company', 'ku.email', 'gag.value', 'kus.status');
$sWhere = "";
if ($r->getParam('q')) {
$q = base64_decode($r->getParam('q'));
for ($i = 0; $i < count($pColumns); $i++) {
$sWhere .= $pColumns[$i] . " LIKE '%" . mysql_real_escape_string($q) . "%' OR ";
}
$sWhere = substr_replace($sWhere, "", -3);
} else {
$sWhere = "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();
$obj = new Pandamp_Crypt_Password();
$tblUser = new App_Model_Db_Table_User();
//echo $q;die();
//$rowset = $tblUser->fetchAll($sWhere, 'kopel ASC', $limit, $start);
$rowset = App_Model_Show_User::show()->fetchUser($sWhere, $start, $limit);
if (count($rowset) == 0) {
$a['users'][0]['kopel'] = 'XXX';
$a['users'][0]['username'] = "******";
$a['users'][0]['company'] = "";
$a['users'][0]['group'] = '';
$a['users'][0]['status'] = '';
} else {
$ii = 0;
foreach ($rowset as $row) {
$a['users'][$ii]['checkbox'] = "<input type='checkbox' name='kopel[]' id='kopel' value='{$row->kopel}' class='check_me'>";
$a['users'][$ii]['kopel'] = $row->kopel;
$a['users'][$ii]['username'] = $row->username;
$a['users'][$ii]['company'] = $row->company;
//$a['users'][$ii]['group']= Pandamp_Controller_Action_Helper_UserGroup::userGroup($row->packageId);
$a['users'][$ii]['group'] = $row->value;
//$a['users'][$ii]['status']= Pandamp_Controller_Action_Helper_UserStatus::userStatus($row->periodeId);
$a['users'][$ii]['status'] = $row->status;
$btn = "";
$passwd = "";
$gEx = Pandamp_Controller_Action_Helper_GroupException::groupException(11);
if (in_array($row->username, $gEx) && Pandamp_Controller_Action_Helper_UserGroup::userGroup($this->_user->packageId) !== "Master") {
$btn .= '-';
$passwd .= '';
} else {
if (Pandamp_Controller_Action_Helper_IsAllowed::isAllowed('membership', 'all')) {
$btn .= "<a href='" . ROOT_URL . '/' . $this->_zl->getLanguage() . '/customer/user/edit/id/' . $row->kopel . "'>edit</a> ";
$btn .= "<a class=\"deleteAction\" rel=\"{$row->kopel}\" href=\"javascript: void(0);\">delete</a> ";
$btn .= "<a class=\"resetAction\" rel=\"{$row->kopel}\" href=\"javascript: void(0);\">reset</a>";
// $btn .= "<input type=\"button\" name=\"edit\" value=\"Edit\" onclick=\"javascript: window.location.href='".ROOT_URL.'/'.$this->_zl->getLanguage().'/customer/user/edit/id/'.$row->kopel."'\" class=\"form-button\"> ";
// $btn .= "<input type=\"button\" name=\"delete\" value=\"Delete\" id=\"$row->kopel\" class=\"form-button\" /> ";
// $btn .= "<input type=\"button\" name=\"reset\" value=\"Reset\" id=\"$row->kopel\" class=\"form-button\" />";
if (Pandamp_Controller_Action_Helper_UserGroup::userGroup($this->_user->packageId) == "Master") {
if ($this->is_sha1($row->password)) {
$password = $row->password;
} else {
$password = $obj->decryptPassword($row->password);
}
$passwd .= "<tr><td> </td><td colspan='6' style='color:green;'>password:<a href='" . ROOT_URL . '/' . $this->_zl->getLanguage() . '/customer/user/edit/id/' . $row->kopel . "'>" . $password . "</a> - " . $row->email . "</td></tr>";
} else {
$passwd .= "";
}
} else {
$btn .= "Edit ";
$btn .= "Delete ";
$btn .= "Reset";
$passwd .= "";
}
}
$a['users'][$ii]['action'] = $btn . "<br><div id='kopel_{$row->kopel}'></div>";
$a['users'][$ii]['passwd'] = $passwd;
$ii++;
}
}
echo Zend_Json::encode($a);
die;
}
