/**
* Save MailNotification
* @param MailNotification $mailNotification
* @returns boolean
* @throws DaoException
*/
public function saveMailNotification(MailNotification $mailNotification)
{
try {
$mailNotification->save();
return true;
} catch (Exception $e) {
throw new DaoException($e->getMessage());
}
}
$instance = $this;
}
static function getInstance()
{
if (!isset($instance)) {
$instance = new MailNotification();
}
return $instance;
}
function createTableIfNotExists()
{
$sql = "CREATE TABLE IF NOT EXISTS wiki_dailychanges (\r\n\t\t\t dc_timestamp varchar(14) binary NOT NULL default '',\r\n\t\t\t dc_title varchar(255) binary NOT NULL default '',\r\n\t\t\t dc_summary varchar(255) binary NOT NULL default '',\r\n\t\t\t dc_url varchar(255) binary NOT NULL default '',\r\n\t\t\t dc_user varchar(255) binary NOT NULL default '',\r\n\t\t\t dc_real_name varchar(255) binary NOT NULL default '',\r\n\t\t\t dc_mail varchar(255) binary NOT NULL default '',\r\n\t\t\t dc_minor tinyint(3) unsigned NOT NULL default '0'\r\n) TYPE=MyISAM PACK_KEYS=1;";
wfQuery($sql, DB_MASTER);
}
function onArticleSaveComplete($article, $user, $text, $summary, $isminor, $iswatch, $section)
{
$this->createTableIfNotExists();
$titleObject = $article->getTitle();
$url = $titleObject->getFullURL();
$title = $titleObject->getText();
$userName = $user->getName();
$realName = $user->getRealName();
$email = $user->getEmail();
$now = wfTimestampNow();
$sql = "INSERT INTO wiki_dailychanges (dc_timestamp, dc_title, dc_summary, dc_url, dc_user, " . "dc_real_name, dc_mail, dc_minor) values ('" . mysql_real_escape_string($now) . "', '" . mysql_real_escape_string($title) . "', '" . mysql_real_escape_string($summary) . "', '" . mysql_real_escape_string($url) . "', '" . mysql_real_escape_string($userName) . "', '" . mysql_real_escape_string($realName) . "', '" . mysql_real_escape_string($email) . "', '" . mysql_real_escape_string($isminor) . "')";
wfQuery($sql, DB_MASTER);
return true;
}
}
$wgHooks['ArticleSaveComplete'][] = MailNotification::getInstance();
/**
* List Mail Subscriptions
* @param sfWebRequest $request
* @return unknown_type
*/
public function executeListMailSubscriptions(sfWebRequest $request)
{
$this->form = new EmailSubscriptionsForm(array(), array(), true);
$mailService = new MailService();
$user = $_SESSION['user'];
$this->mailnot = array();
for ($i = -1; $i < 9; $i++) {
$this->mailnot[$i] = '';
}
if ($request->isMethod('post')) {
$this->form->bind($request->getParameter($this->form->getName()));
if ($this->form->isValid()) {
$mailService->removeMailNotification($user);
$postedStates = $request->getParameter('notificationMessageStatus');
for ($i = -1; $i < 9; $i++) {
$notficationEmail = trim($request->getParameter('txtMailAddress_' . $i));
if (!empty($notficationEmail)) {
$state = in_array($i, $postedStates) ? 1 : 0;
$mailNotification = new MailNotification();
$mailNotification->setUserId($user);
$mailNotification->setNotificationTypeId($i);
$mailNotification->setStatus($state);
$mailNotification->setEmail($notficationEmail);
$mailService->saveMailNotification($mailNotification);
}
}
}
}
$this->notficationList = $mailService->getMailNotificationList($user);
$AllMailNotifications = $mailService->getAllMailNotifications();
foreach ($AllMailNotifications as $mailNotification) {
$this->mailnot[$mailNotification->notification_type_id] = $mailNotification->email;
}
}
/**
* @return \yii\db\ActiveQuery
*/
public function getMailNotifications()
{
return $this->hasMany(MailNotification::className(), ['partner_id' => 'id']);
}
public static function createFromJSON($json_obj)
{
$result = new self();
// Handle complex and special cases
// Then remove them from the data array as not to be reprocessed below
if (isset($json_obj->alert)) {
$result->alert = Alert::createFromJSON($json_obj->alert);
unset($json_obj->alert);
}
if (isset($json_obj->trigger)) {
$result->trigger = Trigger::createFromJSON($json_obj->trigger);
unset($json_obj->trigger);
}
if (isset($json_obj->source)) {
$result->source = Source::createFromJSON($json_obj->source);
unset($json_obj->source);
}
if (isset($json_obj->outputFormats)) {
$result->outputFormats = $json_obj->outputFormats->outputFormat;
unset($json_obj->outputFormats);
}
if (isset($json_obj->repositoryDestination)) {
$result->repositoryDestination = RepositoryDestination::createFromJSON($json_obj->repositoryDestination);
unset($json_obj->repositoryDestination);
}
if (isset($json_obj->mailNotification)) {
$result->mailNotification = MailNotification::createFromJSON($json_obj->mailNotification);
unset($json_obj->mailNotification);
}
// Handle the remaining simple attributes
foreach ($json_obj as $k => $v) {
$result->{$k} = $v;
}
return $result;
}
