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>";
}*/
}
/**
* _writeConfirmCorporateEmail
* @return JSON
*/
function _writeConfirmCorporateEmail($mailcontent, $package, $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);
$pn = App_Model_Show_AroGroup::show()->getUserGroup($package);
$mailcontent = str_replace('$packagename', $pn['name'], $mailcontent);
$mailcontent = str_replace('$timeline', $payment, $mailcontent);
$mailcontent = str_replace('$disc', $disc, $mailcontent);
$tblPackage = new App_Model_Db_Table_Package();
$rowPackage = $tblPackage->fetchRow("packageId={$package}");
$mailcontent = str_replace('$packageprice', number_format($rowPackage->charge), $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 App_Model_Db_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(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
$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;
}
public function getappuserAction()
{
$this->_helper->layout()->disableLayout();
$r = $this->getRequest();
$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 App_Model_Db_Table_User();
$rowset = $tblUser->fetchAll("isActive = 0 AND periodeId IN (1,2)", 'createdDate DESC', $limit, $start);
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]['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]['status'] = Pandamp_Controller_Action_Helper_UserStatus::userStatus($row->periodeId);
$a['users'][$ii]['checkbox'] = "<input type='checkbox' name='kopel[]' id='kopel' value='{$row->kopel}' class='check_me'>";
$ii++;
}
}
echo Zend_Json::encode($a);
die;
}
