function verifyAction()
{
$currentTime = date("Y-m-d H:i:s");
$request = $this->getRequest();
$auth_code = $this->_request->getParam('auth_code');
$this->_helper->layout->disableLayout();
$db = Zend_Registry::get('db');
$signupAuthCodeModel = new SignupAuthCode();
$code = $signupAuthCodeModel->fetchRow("use_date is null and auth_code = '" . $auth_code . "'");
if ($code && $code->id) {
$this->view->codeId = $code->id;
$code->view_date = $currentTime;
$code->save();
}
}
/**
* sendAction 邀请朋友加入(给朋友的邮箱发送邮件)
*/
function sendAction()
{
$this->view->title = $this->view->translate("Wildfire") . " - " . $this->view->translate("INVITATION_MAIL_SEND");
//
$form = new SendMailForm();
$consumer = $this->_currentUser;
$isSentSuccessfully = false;
if ($consumer['pest'] == '1') {
$this->view->showMessage = $this->view->translate('INVITATION_MAIL_LIST_PART1_Sucessful');
$isSentSuccessfully = true;
return;
}
if ($this->_request->isPost()) {
//POST
$formData = $this->_request->getPost();
if ($form->isValid($formData)) {
if ($consumer->invitation_limit != null) {
$this->invitation_limit = $consumer->invitation_limit;
} else {
$this->invitation_limit = $this->_maxInvitation;
}
//get the amount of emails have been sent
$db = Zend_Registry::get('db');
$select = $db->select();
$select->from('invitation_email', 'distinct (invitation_email.to)');
$select->where('consumer_id = ?', $this->_currentUser->id);
// $select->from('invitation_email', 'count(*)');
// $select->where('consumer_id = ?',$consumer->id);
for ($i = (int) $db->fetchOne($select) + 1; $i <= $this->invitation_limit; $i++) {
if ($form->getValue('email' . (string) $i) != '') {
//generate rand code
$codePattern = '1234567890ABCDEFGHIJKLOMNOPQRSTUVWXYZ';
$signup_auth_code = '';
for ($codeCount = 0; $codeCount < 12; $codeCount++) {
$signup_auth_code = $signup_auth_code . $codePattern[mt_rand(0, 35)];
}
//send mail
$emailSubject = $this->view->translate('Invitation_Email_subject');
$emailBody = $this->view->translate('Invitation_Email_body');
$stringChange = array('?USERNAME?' => $this->_currentUser['name'], '?EMAIL?' => $this->_currentUser['email'], '?MESSAGE?' => $form->getValue('message'), '?AUTHCODE?' => (string) $signup_auth_code);
$emailSubject = strtr($emailSubject, $stringChange);
$emailBody = strtr($emailBody, $stringChange);
$config = Zend_Registry::get('config');
$smtpSender = new Zend_Mail_Transport_Smtp($config->smtp->friend->mail->server, array('username' => $config->smtp->friend->mail->username, 'password' => $config->smtp->friend->mail->password, 'auth' => $config->smtp->friend->mail->auth, 'ssl' => $config->smtp->friend->mail->ssl, 'port' => $config->smtp->friend->mail->port));
// $smtpSender = new Zend_Mail_Transport_Smtp(
// smtp.163.com',array(
// 'username'=>'*****@*****.**',
// 'password'=>'19990402',
// 'auth'=>'login'));
Zend_Mail::setDefaultTransport($smtpSender);
$mail = new Zend_Mail('utf-8');
$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->setFrom($config->smtp->friend->mail->username, $consumer->name);
$mail->addHeader('Reply-To', $consumer->email);
// $mail->setFrom('*****@*****.**',$this->view->translate('Wildfire'));
$mail->addTo($form->getValue('email' . (string) $i));
//save into DB
try {
$currentTime = date("Y-m-d H:i:s");
//save into signup_auth_code
$signupAuthCodeModel = new SignupAuthCode();
$signupAuthCode = $signupAuthCodeModel->createRow();
$signupAuthCode->auth_code = $signup_auth_code;
$signupAuthCode->create_date = $currentTime;
$signupAuthCode->sender = $this->_currentUser->id;
$signupAuthCode->source = 'FRIENDS';
$signupAuthCode->auto_invitation = 0;
$signupAuthCode->save();
//send mail after saving
$mail->send();
//save into invitation_email
$invitationEmailModel = new InvitationEmail();
$invitationEmail = $invitationEmailModel->createRow();
$invitationEmail->subject = $emailSubject;
$invitationEmail->content = $form->getValue('message');
$invitationEmail->consumer_id = $this->_currentUser->id;
$invitationEmail->to = $form->getValue('email' . (string) $i);
$invitationEmail->signup_auth_code_id = $signupAuthCode->id;
$invitationEmail->date = $currentTime;
$invitationEmail->save();
$this->view->showMessage = $this->view->translate('INVITATION_MAIL_LIST_PART1_Sucessful');
$isSentSuccessfully = true;
} catch (Exception $e) {
//roll back...
$this->view->showMessage = 'System Error!';
}
}
}
if (!$isSentSuccessfully) {
$this->view->showMessage = $this->view->translate('INVITATION_MAIL_LIST_PART1_Fail');
}
} else {
$this->view->showMessage = $this->view->translate('INVITATION_MAIL_LIST_PART1_DataError');
}
}
// $this->_helper->redirector('index','invitation',null,array('isSendMailSuccessful'=>$isSendMailSuccessful));
}
function precampaignfinishedAction()
{
$this->view->activeTab = 'Campaign';
$this->view->title = $this->view->title = $this->view->translate("Wildfire") . " - " . $this->view->translate("You_are_in");
//precampaignsurvey的css使用的是layout_survey
$this->_helper->layout->setLayout("layout_survey");
$id = (int) $this->_request->getParam('survey');
$campaignModel = new Campaign();
$this->view->campaign = $campaignModel->fetchRow("pre_campaign_survey=" . $id . " or " . "pre_campaign_survey_en=" . $id);
$db = Zend_Registry::get('db');
if ($this->view->campaign != null) {
$campaignId = $this->view->campaign->id;
}
$consumer = $this->_currentUser;
//TOCHECK
//$select_extra_info = $db->select ();
//$select_extra_info->from ( "consumer",array ('consumer.*', 'consumer_extra_info.gender as gender','consumer_extra_info.education as education','consumer_extra_info.income as income' ));
//$select_extra_info->joinLeft ( "consumer_extra_info","consumer.id = consumer_extra_info.consumer_id",null);
//$select_extra_info->where("consumer.id = ".$this->_currentUser->id );
//$consumer2 = $db->fetchRow ( $select_extra_info );
//Zend_Debug::dump($consumer2);die;
if ($this->view->campaign != null && $campaignId != null && $campaignId > 0) {
// check if precampaign poll is finished
// $select1 = $db->select();
// $select1->from('campaign', 'pre_campaign_survey');
// $select1->where('campaign.id = ?',$campaignId);
// $previewCamSurvey = $db->fetchOne($select1);
// $indicate2Connect = new Indicate2_Connect();
// $ids = array($previewCamSurvey);
// $wsResult = $indicate2Connect->getAnswerSetCount($consumer->email,$ids);
//
// if ($wsResult==0){
// $this->_redirect('campaign/precampaign/survey/'.$previewCamSurvey);
// }else{
$campaignInvitationModel = new CampaignInvitation();
$campaignInvitation = $campaignInvitationModel->fetchRow("campaign_id=" . $campaignId . " and consumer_id=" . $consumer->id);
if ($campaignInvitation == null) {
$this->_redirect('http://community.wildfire.asia/public/home');
}
$id = $campaignInvitation->id;
//Zend_Debug::dump($campaignInvitation);
$campaignInvitation->state = "ACCEPTED";
$campaignInvitation->save();
//2011-05-19 ham.bao add the badge
// $consumerBadgeModel = new ConsumerBadge();
// $notificationModel = new Notification();
// $consumerBadgeData = $consumerBadgeModel->fetchRow('badge='.$this->view->campaign->badge .' and consumer='.$consumer->id);
// if(!count($consumerBadgeData)){
// $row = $consumerBadgeModel->createRow();
// $row->consumer = $consumer->id;
// $row->badge = $this->view->campaign->badge;
// $row->create_date = date("Y-m-d H:i:s");
// $row->save();
// // add notification
// $notificationModel->createRecord("CONSUMER_BADGE",$consumer->id);
//
// }
//2011-05-19 ham.bao add the badge
$result = $db->fetchOne("SELECT COUNT(*) FROM campaign_participation WHERE campaign_invitation_id=:t1", array('t1' => $id));
if ($result == 0) {
//2011-02-22 ham.bao add the logic to calculate the number of participation
$campaignModel->update(array('participation' => $this->view->campaign->participation + 1), 'id = ' . $this->view->campaign->id);
if ($this->view->campaign->participation + 1 >= $this->view->campaign->total) {
$campaignInvitationModel->update(array('state' => 'EXPIRED'), ' state = "NEW" and campaign_id =' . $this->view->campaign->id);
$signauthcodeModel = new SignupAuthCode();
$signauthcodeModel->update(array('auto_invitation' => 0), 'auto_invitation =' . $this->view->campaign->id);
}
//create participation
$campaignParticipationModel = new CampaignParticipation();
$currentTime = date("Y-m-d H:i:s");
$row = $campaignParticipationModel->createRow();
$row->campaign_invitation_id = $id;
$row->accept_date = $currentTime;
$row->state = 'NEW';
$row->save();
//send "welcome to campaign" mail
//set the content of mail
$emailSubject = $this->view->translate('Welcome_to_Spark_Campaign_Email_subject_campaign_' . $campaignId);
$emailBody = $this->view->translate('Welcome_to_Spark_Campaign_Email_body_campaign_' . $campaignId);
$stringChange = array('?USERNAME?' => $this->_currentUser['name']);
$emailBody = strtr($emailBody, $stringChange);
//send...
$config = Zend_Registry::get('config');
$smtpSender = new Zend_Mail_Transport_Smtp($config->smtp->welcome->mail->server, array('username' => $config->smtp->welcome->mail->username, 'password' => $config->smtp->welcome->mail->password, 'auth' => $config->smtp->welcome->mail->auth, 'ssl' => $config->smtp->welcome->mail->ssl, 'port' => $config->smtp->welcome->mail->port));
Zend_Mail::setDefaultTransport($smtpSender);
$mail = new Zend_Mail('utf-8');
$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->setFrom($config->smtp->welcome->mail->username, $this->view->translate('Wildfire'));
$mail->addTo($this->_currentUser['email']);
$mail->send();
}
}
//edit ConsumerContactForm();
$form = new ConsumerContactForm(array('relative' => $this->view->campaign->relative));
$consumer = $this->_currentUser;
$order = new Zend_Db_Expr(' id ');
$consumerFriend = new ConsumerFriend();
$friends = $consumerFriend->fetchAll('consumer= ' . $consumer->id . ' and campaign=' . $this->view->campaign->id, $order);
$this->view->friendsNum = count($friends);
//consumer_extra_info
/*$consumer_extra_info = new ConsumerExtraInfo();
//TOCHECK
$consumerextra = $consumer_extra_info->fetchAll("consumer_id= ".$consumer->id);*/
$select_consumer_extra_info = $db->select();
$select_consumer_extra_info->from('consumer_extra_info', '*')->where('consumer_extra_info.consumer_id = ?', $consumer->id);
$consumerextra = $db->fetchAll($select_consumer_extra_info);
if ($this->_request->getPost()) {
$formData = $this->_request->getPost();
$form->populate($formData);
$this->view->city = $formData["city"];
$this->view->province = $formData["province"];
$this->view->encity = $formData["city"];
} else {
$form->populate($consumer->toArray());
$form->birthdate->setValue($consumerextra[0]['birthdate']);
$form->gender->setValue($consumerextra[0]['gender']);
$form->education->setValue($consumerextra[0]['education']);
$form->income->setValue($consumerextra[0]['income']);
$form->telephone->setValue($consumer->company_phone);
// zh city
if ($consumer["city"] != NULL && $consumer["province"] != NULL) {
$this->view->city = $consumer["city"];
$this->view->province = $consumer["province"];
}
// en city
if ($consumer["city"] != NULL && $consumer["province"] == NULL) {
$this->view->encity = $consumer["city"];
}
if (count($friends)) {
$i = 1;
foreach ($friends as $friend) {
$name = 'friend_name_' . $i;
$email = 'friend_email_' . $i;
$phone = 'friend_phone_' . $i;
$address = 'friend_address_' . $i;
$message = 'friend_message_' . $i;
$form->{$name}->setValue($friend->name);
$form->{$email}->setValue($friend->email);
$form->{$phone}->setValue($friend->phone);
$form->{$address}->setValue($friend->address);
$form->{$message}->setValue($friend->message);
$i++;
}
}
}
//var_dump($form);die;
$langNamespace = new Zend_Session_Namespace('Lang');
$this->view->language = $langNamespace->lang;
$this->view->form = $form;
$this->view->friendsLimit = $this->view->campaign->relative;
//Zend_Debug::dump($this->_request->getPost ());
//Zend_Debug::dump($this->view->friendsLimit);
}
function admindynamicsendinvitationsAction()
{
$this->view->title = $this->view->translate("Wildfire") . " - " . $this->view->translate("INVITATION_MAIL_SEND");
$this->view->activeTab = 'Mails';
//
$this->_helper->layout->setLayout("layout_admin");
$form = new CampaignInvitationMailForm();
$consumer = $this->_currentUser;
$isSentSuccessfully = false;
if ($this->_request->isPost()) {
//POST
$formData = $this->_request->getPost();
if ($form->isValid($formData)) {
// $subjectmessage = $formData ["subject"];
// $message = $formData ["message"];
// if ($message == null || $message == '') {
// $message = $formData ["htmlmessage"];
// $useHtmlEmail = true;
// } else {
// $useHtmlEmail = false;
// }
$useHtmlEmail = true;
//2011-02-14 ham.bao get email content and subject
$emailTemplate = new EmailTemplate();
$email = $emailTemplate->fetchRow('id = ' . $formData['emailTemplate']);
$subjectmessage = $email->subject;
$message = $email->message;
//2011-02-14 ham.bao get email content and subject
$campaignId = $formData["campaignId"];
$code_source = $formData["code_source"];
$emailCategory = $formData['emailCategory'];
$emailListString = $formData["emailList"];
// $emailArray = explode(';',$emailListString);
// $emailArray= preg_split ( '/[;\s]+[\n\r\t]*/', trim ( $emailListString ) );
$emailArray = array();
$rows = explode("\n", $emailListString);
$i = 0;
foreach ($rows as $row) {
$cells = explode("\t", $row);
$j = 0;
foreach ($cells as $cell) {
$emailArray[$i][$j] = $cell;
$j++;
}
$i++;
}
$sentList = "";
$total = 0;
$config = Zend_Registry::get('config');
$smtpSender = new Zend_Mail_Transport_Smtp($config->smtp->invitation->mail->server, array('username' => $config->smtp->invitation->mail->username, 'password' => $config->smtp->invitation->mail->password, 'auth' => $config->smtp->invitation->mail->auth, 'ssl' => $config->smtp->invitation->mail->ssl, 'port' => $config->smtp->invitation->mail->port));
Zend_Mail::setDefaultTransport($smtpSender);
$db = Zend_Registry::get('db');
$langNamespace = new Zend_Session_Namespace('Lang');
//print_r($emailArray);die;
foreach ($emailArray as $emailAddress) {
$currentTime = date("Y-m-d H:i:s");
//$emailAddress = trim ( $emailAddress[0] );
if ($emailAddress[0] == null || $emailAddress[0] == '') {
continue;
}
if ($emailCategory == 'Invite non-sparks to join campaign') {
// ignore the spark!
$consumerModel = new Consumer();
$consumer = $consumerModel->fetchRow("email = '" . $emailAddress[0] . "'");
if ($consumer != null) {
continue;
}
$selectCode = $db->select();
$selectCode->from('signup_auth_code', 'signup_auth_code.auth_code')->joinInner('invitation_email', "invitation_email.signup_auth_code_id = signup_auth_code.id and invitation_email.to ='{$emailAddress['0']}'")->where('signup_auth_code.auto_invitation= ?', $campaignId);
$code = $db->fetchOne($selectCode);
//generate rand code
if ($code == false) {
$codePattern = '1234567890ABCDEFGHIJKLOMNOPQRSTUVWXYZ';
$signup_auth_code = '';
for ($codeCount = 0; $codeCount < 12; $codeCount++) {
$signup_auth_code = $signup_auth_code . $codePattern[mt_rand(0, 35)];
}
} else {
$signup_auth_code = $code;
}
//var_dump($signup_auth_code);die;
$stringChange = array('?EMAIL?' => $emailAddress[0], '?AUTHCODE?' => (string) $signup_auth_code);
$subject = strtr($subjectmessage, $stringChange);
$body = strtr($message, $stringChange);
}
if ($emailCategory == 'Invite sparks to join campaign') {
$select = $db->select();
$select->from('consumer', '*')->where('email = ?', $emailAddress[0])->where('pest != 1 or pest is null');
$user = $db->fetchRow($select);
//ignore the pest!
if ($user == null) {
continue;
}
//ignore those have been invited
$selectInvitedSpark = $db->select();
$selectInvitedSpark->from('campaign_invitation', '*')->where('campaign_id = ?', $campaignId)->where('consumer_id = ?', $user['id']);
$invitedSpark = $db->fetchRow($selectInvitedSpark);
if ($invitedSpark != null) {
continue;
}
$stringChange = array('?USERNAME?' => $user['name']);
$subject = strtr($subjectmessage, $stringChange);
$body = strtr($message, $stringChange);
}
if ($emailCategory == 'Send mail to sparks') {
$select = $db->select();
$select->from('consumer', '*')->where('email = ?', $emailAddress[0])->where('pest != 1 or pest is null');
$user = $db->fetchRow($select);
//ignore the pest!
if ($user == null) {
continue;
}
$stringChange = array('?USERNAME?' => $user['name']);
$subject = strtr($subjectmessage, $stringChange);
$body = strtr($message, $stringChange);
}
$i = 0;
$num = count($emailAddress);
for ($j = 1; $j <= $num; $j++) {
if (isset($emailAddress[$j])) {
$body = str_replace('$' . $j, $emailAddress[$j], $body);
}
}
$i++;
$mail = new Zend_Mail('utf-8');
if ($langNamespace->lang == 'en' || $langNamespace->lang == 'EN') {
$mail->setSubject($subject);
} else {
$mail->setSubject("=?UTF-8?B?" . base64_encode($subject) . "?=");
}
if ($useHtmlEmail != null && $useHtmlEmail) {
$mail->setBodyHtml($body);
} else {
$mail->setBodyText($body);
}
$mail->setFrom($config->smtp->invitation->mail->username, $this->view->translate('Wildfire_bi_lang'));
// $mail->setFrom('*****@*****.**',$this->view->translate('Wildfire'));
$mail->addTo($emailAddress[0]);
$mail->send();
//save into DB
try {
//save into signup_auth_code
if ($emailCategory == 'Invite non-sparks to join campaign') {
$signupAuthCodeModel = new SignupAuthCode();
$signupAuthCode = $signupAuthCodeModel->createRow();
$signupAuthCode->auth_code = $signup_auth_code;
$signupAuthCode->create_date = $currentTime;
if ($code_source == null || $code_source == '') {
$signupAuthCode->source = 'SIGNUP';
} else {
$signupAuthCode->source = $code_source;
}
$signupAuthCode->auto_invitation = $campaignId;
$signupAuthCode->save();
//save into invitation_email
$invitationEmailModel = new InvitationEmail();
$invitationEmail = $invitationEmailModel->createRow();
$invitationEmail->subject = $subject;
$invitationEmail->content = $body;
$invitationEmail->consumer_id = 16693;
$invitationEmail->to = $emailAddress[0];
$invitationEmail->signup_auth_code_id = $signupAuthCode->id;
$invitationEmail->date = $currentTime;
$invitationEmail->save();
}
if ($emailCategory == 'Invite sparks to join campaign') {
//save into spark email
$sparkEmailModel = new SparkEmail();
$sparkEmail = $sparkEmailModel->createRow();
$sparkEmail->subject = $subject;
$sparkEmail->content = $body;
$sparkEmail->to = $user['id'];
$sparkEmail->date = date("Y-m-d H:i:s");
$sparkEmail->save();
//save into campaign_invitation
$campaigninvitationModel = new CampaignInvitation();
$campaigninvitation = $campaigninvitationModel->createRow();
$campaigninvitation->campaign_id = $campaignId;
$campaigninvitation->consumer_id = $user['id'];
$campaigninvitation->create_date = $currentTime;
$campaigninvitation->state = 'NEW';
$campaigninvitation->save();
}
if ($emailCategory == 'Send mail to sparks') {
//save into spark email
$sparkEmailModel = new SparkEmail();
$sparkEmail = $sparkEmailModel->createRow();
$sparkEmail->subject = $subject;
$sparkEmail->content = $body;
$sparkEmail->to = $user['id'];
$sparkEmail->date = date("Y-m-d H:i:s");
$sparkEmail->save();
}
$total++;
$sentList .= $emailAddress[0] . ", ";
$isSentSuccessfully = true;
} catch (Exception $e) {
//roll back...
$this->view->showMessage = 'System Error!';
}
}
$this->view->showMessage = $this->view->translate('INVITATION_MAIL_LIST_PART1_Sucessful');
$this->view->showsentList = $sentList;
$this->view->showTotal = "Total: " . $total;
if (!$isSentSuccessfully) {
$this->view->showMessage = $this->view->translate('INVITATION_MAIL_LIST_PART1_Fail');
}
} else {
$this->view->showMessage = $this->view->translate('INVITATION_MAIL_LIST_PART1_DataError');
}
}
}
