function adminsaveurlreportstateAction()
{
$type = $this->_request->getParam('type');
$db = Zend_Registry::get('db');
if ($type == 'reportState') {
$idStr = $this->_request->getParam('reportids');
$idStrArray = explode(',', $idStr);
$reportIdArray = array();
$i = 0;
$config = Zend_Registry::get('config');
$smtpSender = new Zend_Mail_Transport_Smtp($config->smtp->report->mail->server, array('username' => $config->smtp->report->mail->username, 'password' => $config->smtp->report->mail->password, 'auth' => $config->smtp->report->mail->auth, 'ssl' => $config->smtp->report->mail->ssl, 'port' => $config->smtp->report->mail->port));
// $smtpSender = new Zend_Mail_Transport_Smtp(
// 'smtp.163.com',array(
// 'username'=>'*****@*****.**',
// 'password'=>'19990402',
// 'auth'=>'login'));
Zend_Mail::setDefaultTransport($smtpSender);
foreach ($idStrArray as $idAndState) {
if ($idAndState == '') {
continue;
}
$idAndStateArray = explode('@', $idAndState);
if ($idAndStateArray[1] == 'NEW') {
continue;
}
if ($idAndStateArray[1] == 'APPROVED') {
$urlreportModel = new UrlReport();
$row = $urlreportModel->fetchRow('id = ' . $idAndStateArray[0]);
if ($row->state != 'NEW') {
continue;
}
$row->state = $idAndStateArray[1];
if ($row->reward_point_transaction_record_id == null || $row->reward_point_transaction_record_id == '') {
$rewardModel = new RewardPointTransactionRecord();
$reward = $rewardModel->createRow();
$reward->consumer_id = $idAndStateArray[2];
$reward->date = date("Y-m-d H:i:s");
$reward->transaction_id = 8;
$reward->point_amount = 300;
$row->reward_point_transaction_record_id = $reward->save();
} else {
$rewardModel = new RewardPointTransactionRecord();
$reward = $rewardModel->fetchRow('id = ' . $row->reward_point_transaction_record_id);
if ($reward != null) {
$reward->date = date("Y-m-d H:i:s");
$reward->point_amount = 300;
$reward->save();
}
}
$row->save();
//2011-05-13 change the rank of consumer
$rankModel = new Rank();
$rankModel->changeConsumerRank($idAndStateArray[1]);
}
if ($idAndStateArray[1] == 'UNAPPROVED') {
$urlreportModel = new UrlReport();
$row = $urlreportModel->fetchRow('id = ' . $idAndStateArray[0]);
if ($row == null) {
continue;
}
if ($row->reward_point_transaction_record_id != null && $row->reward_point_transaction_record_id != '') {
$rewardModel = new RewardPointTransactionRecord();
$reward = $rewardModel->fetchRow('id = ' . $row->reward_point_transaction_record_id);
if ($reward != null) {
$db2 = $rewardModel->getAdapter();
$where = $db2->quoteInto('id = ?', $row->reward_point_transaction_record_id);
$rows_affected = $rewardModel->delete($where);
}
}
$db2 = $urlreportModel->getAdapter();
$where = $db2->quoteInto('id = ?', $idAndStateArray[0]);
$rows_affected = $urlreportModel->delete($where);
}
$consumerModel = new Consumer();
$consumer = $consumerModel->fetchRow('id = ' . $idAndStateArray[2]);
//send mail...
if ($consumer->email == '') {
continue;
}
$mail = new Zend_Mail('utf-8');
if ($consumer->language_pref != null && $consumer->language_pref == 'en') {
$emailSubject = $this->view->translate('Admin_Reply_WOM_URLReport_Subject_en');
$emailBody = $this->view->translate('Admin_Reply_WOM_URLReport_Body_en');
} else {
$emailSubject = $this->view->translate('Admin_Reply_WOM_URLReport_Subject_zh');
$emailBody = $this->view->translate('Admin_Reply_WOM_URLReport_Body_zh');
}
$stringChange = array('?USERNAME?' => $consumer->name, '?YOURSTORY?' => $row->url, '?MYRESPONSE?' => $idAndStateArray[3]);
$emailBody = strtr($emailBody, $stringChange);
$langNamespace = new Zend_Session_Namespace('Lang');
if ($langNamespace->lang == 'en' || $langNamespace->lang == 'EN') {
$mail->setSubject($emailSubject);
} else {
$mail->setSubject("=?UTF-8?B?" . base64_encode($emailSubject) . "?=");
}
$mail->setBodyText($emailBody);
$mail->addTo($consumer->email);
$mail->setFrom($config->smtp->report->mail->username, $this->view->translate('Wildfire'));
// $mail->setFrom('*****@*****.**',$this->view->translate('Wildfire'));
$mail->send();
// save email
$urlreportreplyModel = new UrlReportReply();
$urlreportreply = $urlreportreplyModel->createRow();
$urlreportreply->date = date("Y-m-d H:i:s");
$urlreportreply->subject = $emailSubject;
$urlreportreply->content = $idAndStateArray[3];
$urlreportreply->from = $config->smtp->report->mail->username;
$urlreportreply->to = $consumer->email;
$urlreportreply->url_report_id = $row->id;
//2011-04-08 ham.bao separate the sessions with admin
$urlreportreply->admin_id = $this->_currentAdmin->id;
$urlreportreply->save();
}
}
}
function adminsaveimagereportstateAction()
{
$type = $this->_request->getParam('type');
$db = Zend_Registry::get('db');
if ($type == 'reportState') {
$idStr = $this->_request->getParam('reportids');
$idStrArray = explode(',', $idStr);
$reportIdArray = array();
$i = 0;
foreach ($idStrArray as $idAndState) {
if ($idAndState == '') {
continue;
}
$idAndStateArray = explode('@', $idAndState);
if ($idAndStateArray[1] == 'NEW') {
continue;
}
if ($idAndStateArray[1] == 'APPROVED') {
$imagereportModel = new ImageReport();
$row = $imagereportModel->fetchRow('id = ' . $idAndStateArray[0]);
if ($row->state != 'NEW') {
continue;
}
$row->state = $idAndStateArray[1];
$row->save();
}
if ($idAndStateArray[1] == 'UNAPPROVED') {
$imagereportModel = new ImageReport();
$row = $imagereportModel->fetchRow('id = ' . $idAndStateArray[0]);
if ($row == null) {
continue;
}
if ($row->reward_point_transaction_record_id != null && $row->reward_point_transaction_record_id != '') {
$rewardModel = new RewardPointTransactionRecord();
$reward = $rewardModel->fetchRow('id = ' . $row->reward_point_transaction_record_id);
if ($reward != null) {
$db2 = $rewardModel->getAdapter();
$where = $db2->quoteInto('id = ?', $row->reward_point_transaction_record_id);
$rows_affected = $rewardModel->delete($where);
}
}
$row->state = $idAndStateArray[1];
$row->save();
}
}
}
}