/application/controllers/email_queues.php - Komentovat - FreenetIS - Redmine

freenetis-github/application/controllers/email_queues.php @ 264c87f2

-baed187
+<?php defined('SYSPATH') or die('No direct script access.');
 /*
  * This file is part of open source system FreenetIS
  * and it is released under GPLv3 licence.
+ *
  * More info about licence can be found:
  * http://www.gnu.org/licenses/gpl-3.0.html
+ *
  * More info about project can be found:
  * http://www.freenetis.org/
+ *
  */
 /**
  * Controller performs logic of queue of e-mails
+ *
  * @see Scheduler_Controller
  * @see Notification_Controller
  * @package Controller
  */
 class Email_queues_Controller extends Controller
+{
-            c1bdc1c4
+	/**
 	 * Constructor, only test if email is enabled
+	 *
 	 * @author Michal Kliment
 	 */
 	public function __construct()
+	{
 		parent::__construct();
 		if (!Settings::get('email_enabled'))
 			Controller::error (ACCESS);
+	}
-baed187
+	/**
 	 * Index redirects to show unset
 	 */
 	public function index()
+	{
 		url::redirect('email_queues/show_all_unsent');
+	}
 	/**
 	 * Function to show all unsent e-mails
+	 *
 	 * @author Michal Kliment
 	 * @param integer $limit_results
 	 * @param string $order_by
 	 * @param string $order_by_direction
 	 * @param string $page_word
 	 * @param integer $page
 	 */
 	public function show_all_unsent(
-d9077c2
+			$limit_results = 50, $order_by = 'id',
-baed187
+			$order_by_direction = 'DESC', $page_word = null, $page = 1)
+	{
 		// access check
-            c1bdc1c4
+		if (!$this->acl_check_view('Email_queues_Controller', 'email_queue'))
-baed187
+			Controller::error(ACCESS);
 		// filter form
-            c1bdc1c4
+		$filter_form = new Filter_form();
-baed187
+            Michal Kliment
 		$filter_form->add('from_user_name')
 			->label(__('User From'))
 			->callback('json/user_fullname');
 		$filter_form->add('from')
 			->label(__('E-mail From'))
 			->callback('json/user_email');
 		$filter_form->add('to_user_name')
 			->label(__('User To'))
 			->callback('json/user_fullname');
 		$filter_form->add('to')
 			->label(__('E-mail To'))
 			->callback('json/user_email');
 		$filter_form->add('subject');
 		$filter_form->add('access_time')
 			->type('date')
 			->label(__('Time'));
 		// gets new selector
-            c1bdc1c4
+		if (is_numeric($this->input->post('record_per_page')))
 			$limit_results = (int) $this->input->post('record_per_page');
-baed187
+            Michal Kliment
 		// parameters control
 		$allowed_order_type = array
+		(
 			'id', 'from', 'to', 'subject', 'access_time'
 		);
 		// order by check
 		if (!in_array(strtolower($order_by), $allowed_order_type))
-d9077c2
+			$order_by = 'id';
-baed187
+            Michal Kliment
 		// order by direction check
 		if (strtolower($order_by_direction) != 'asc')
 			$order_by_direction = 'desc';
 		$email_queue_model = new Email_queue_Model();
 		// counts all unsent e-mail
 		$total_emails = $email_queue_model->count_all_unsent_emails($filter_form->as_sql());
 		// limit check
 		if (($sql_offset = ($page - 1) * $limit_results) > $total_emails)
 			$sql_offset = 0;
 		$emails = $email_queue_model->get_all_unsent_emails(
 			$sql_offset, (int)$limit_results, $order_by, $order_by_direction,
 			$filter_form->as_sql()
 		);
 		// headline
 		$headline = __('List of all unsent e-mails');
 		// path to form
 		$path = Config::get('lang') . '/email_queues/show_all_unsent/' . $limit_results . '/'
 				. $order_by . '/' . $order_by_direction;
 		$grid = new Grid('email_queues', null, array
+		(
 			'current'					=> $limit_results,
 			'selector_increace'			=> 50,
 			'selector_min' 				=> 50,
 			'selector_max_multiplier'   => 20,
 			'base_url'					=> $path,
 			'uri_segment'				=> 'page',
 			'total_items'				=> $total_emails,
 			'items_per_page' 			=> $limit_results,
 			'style'		  				=> 'classic',
 			'order_by'					=> $order_by,
 			'order_by_direction'		=> $order_by_direction,
 			'limit_results'				=> $limit_results,
 			'filter'					=> $filter_form
 		));
 		$grid->add_new_button(
 				'email_queues/show_all_sent', __('Show all sent e-mails')
 		);
-            c1bdc1c4
+		if ($this->acl_check_delete('Email_queues_Controller', 'email_queue'))
+		{
 			$grid->add_new_button(
 					'email_queues/delete_unsent', __('Delete all unsended e-mails'),
 					array
+					(
 						'class' => 'delete_link'
+					)
 			);
+		}
-baed187
+            Michal Kliment
 		// database columns
 		$grid->order_field('id')
 				->label('ID');
 		$grid->order_callback_field('from')
 				->callback('callback::email_from_field');
 		$grid->order_callback_field('to')
 				->label('To')
 				->callback('callback::email_to_field');
 		$grid->order_callback_field('subject')
 				->callback('callback::email_subject_field');
 		$grid->order_callback_field('state')
 				->callback('callback::email_state_field');
 		$grid->order_field('access_time')
 				->label(__('Time'));
 		$actions = $grid->grouped_action_field();
 		$actions->add_action()
-            c1bdc1c4
+				->icon_action('show')
 				->url('email/show');
-baed187
+            Michal Kliment
-            c1bdc1c4
+		if ($this->acl_check_new('Email_queues_Controller', 'email_queue'))
+		{
 			$actions->add_action()
 					->icon_action('mail_send')
 					->label('Send again')
 					->url('email_queues/send');
+		}
 		if ($this->acl_check_delete('Email_queues_Controller', 'email_queue'))
+		{
 			$actions->add_action()
 					->icon_action('delete')
 					->url('email_queues/delete')
 					->class('delete_link');
+		}
-baed187
+            Michal Kliment
 		// load data
 		$grid->datasource($emails);
 		$view = new View('main');
 		$view->breadcrumbs = __('Unsent e-mails');
 		$view->title = $headline;
 		$view->content = new View('show_all');
 		$view->content->headline = $headline;
 		$view->content->table = $grid;
 		$view->render(TRUE);
+	}
 	/**
 	 * Function to show all sent e-mails
+	 *
 	 * @author Michal Kliment
 	 * @param integer $limit_results
 	 * @param string $order_by
 	 * @param string $order_by_direction
 	 * @param string $page_word
 	 * @param integer $page
 	 */
 	public function show_all_sent(
-d9077c2
+			$limit_results = 50, $order_by = 'id',
-baed187
+			$order_by_direction = 'DESC', $page_word = null, $page = 1)
+	{
 		// access check
-            c1bdc1c4
+		if (!$this->acl_check_view('Email_queues_Controller', 'email_queue'))
-baed187
+			Controller::error(ACCESS);
 		// filter form
-            c1bdc1c4
+		$filter_form = new Filter_form();
-baed187
+            Michal Kliment
 		$filter_form->add('from_user_name')
-            c1bdc1c4
+			->label('User From')
-baed187
+			->callback('json/user_fullname');
 		$filter_form->add('from')
-            c1bdc1c4
+			->label('E-mail From')
-baed187
+			->callback('json/user_email');
 		$filter_form->add('to_user_name')
-            c1bdc1c4
+			->label('User To')
-baed187
+			->callback('json/user_fullname');
 		$filter_form->add('to')
-            c1bdc1c4
+			->label('E-mail To')
-baed187
+			->callback('json/user_email');
 		$filter_form->add('subject');
 		$filter_form->add('access_time')
 			->type('date')
-            c1bdc1c4
+			->label('Time');
-baed187
+            Michal Kliment
 		// gets new selector
-            c1bdc1c4
+		if (is_numeric($this->input->post('record_per_page')))
 			$limit_results = (int) $this->input->post('record_per_page');
-baed187
+            Michal Kliment
 		// parameters control
 		$allowed_order_type = array
+		(
 			'id', 'from', 'to', 'subject', 'access_time'
 		);
 		// order by check
 		if (!in_array(strtolower($order_by), $allowed_order_type))
-d9077c2
+			$order_by = 'id';
-baed187
+            Michal Kliment
 		// order by direction check
 		if (strtolower($order_by_direction) != 'asc')
 			$order_by_direction = 'desc';
 		$email_queue_model = new Email_queue_Model();
-            c1bdc1c4
+		// hide grid on its first load (#442)
 		$hide_grid = Settings::get('grid_hide_on_first_load') && $filter_form->is_first_load();
-baed187
+            Michal Kliment
-            c1bdc1c4
+		if (!$hide_grid)
+		{
 			try
+			{
 				// counts all sent e-mail
 				$total_emails = $email_queue_model->count_all_sent_emails($filter_form->as_sql());
 				// limit check
 				if (($sql_offset = ($page - 1) * $limit_results) > $total_emails)
 					$sql_offset = 0;
 				$emails = $email_queue_model->get_all_sent_emails(
 					$sql_offset, (int)$limit_results, $order_by, $order_by_direction,
 					$filter_form->as_sql()
 				);
+			}
 			catch (Exception $e)
+			{
 				if ($filter_form->is_loaded_from_saved_query())
+				{
 					status::error('Invalid saved query');
 					// disable default query (loop protection)
 					if ($filter_form->is_loaded_from_default_saved_query())
+					{
 						ORM::factory('filter_query')->remove_default($filter_form->get_base_url());
+					}
 					$this->redirect(url_lang::current());
+				}
 				throw $e;
+			}
+		}
-baed187
+            Michal Kliment
 		// headline
 		$headline = __('List of all sent e-mails');
 		// path to form
 		$path = Config::get('lang') . '/email_queues/show_all_sent/' . $limit_results . '/'
 				. $order_by . '/' . $order_by_direction;
 		$grid = new Grid('email_queues', null, array
+		(
 			'current'					=> $limit_results,
 			'selector_increace'			=> 50,
 			'selector_min' 				=> 50,
 			'selector_max_multiplier'   => 20,
 			'base_url'					=> $path,
 			'uri_segment'				=> 'page',
-            c1bdc1c4
+			'total_items'				=> isset($total_emails) ? $total_emails : 0,
-baed187
+			'items_per_page' 			=> $limit_results,
 			'style'		  				=> 'classic',
 			'order_by'					=> $order_by,
 			'order_by_direction'		=> $order_by_direction,
 			'limit_results'				=> $limit_results,
 			'filter'					=> $filter_form
 		));
 		$grid->add_new_button(
 				'email_queues/show_all_unsent', __('Show all unsent e-mails')
 		);
-            c1bdc1c4
+		if (!$hide_grid && $this->acl_check_delete('Email_queues_Controller', 'email_queue'))
+		{
 			$grid->add_new_button(
 					'email_queues/delete_sent' . server::query_string(),
 					__('Delete all filtered e-mails'), array
+					(
 						'class' => 'delete_link'
+					)
 			);
+		}
-baed187
+		$grid->add_new_button(
-            c1bdc1c4
+				'export/csv/email_queue_sent' . server::query_string(),
 				'Export to CSV', array
+				(
 					'title' => __('Export to CSV'),
 					'class' => 'popup_link'
+				)
-baed187
+		);
 		// database columns
 		$grid->order_field('id')
 				->label('ID');
 		$grid->order_callback_field('from')
 				->callback('callback::email_from_field');
 		$grid->order_callback_field('to')
 				->callback('callback::email_to_field');
 		$grid->order_callback_field('subject')
 				->callback('callback::email_subject_field');
 		$grid->order_field('access_time')
 				->label('Time');
 		$actions = $grid->grouped_action_field();
 		$actions->add_action()
 				->icon_action('show')
 				->url('email/show');
-            c1bdc1c4
+		if ($this->acl_check_new('Email_queues_Controller', 'email_queue'))
+		{
 			$actions->add_action()
 					->icon_action('mail_send')
 					->label('Send again')
 					->url('email_queues/send');
+		}
-baed187
+            Michal Kliment
-            c1bdc1c4
+		if (!$hide_grid)
+		{
 			// load data
 			$grid->datasource($emails);
+		}
-baed187
+            Michal Kliment
 		$view = new View('main');
 		$view->breadcrumbs = __('Sent e-mails');
 		$view->title = $headline;
 		$view->content = new View('show_all');
 		$view->content->headline = $headline;
 		$view->content->table = $grid;
 		$view->render(TRUE);
+	}
 	/**
 	 * Tries to send message from queue
+	 *
 	 * @author Michal Kliment
 	 * @param integer $email_queue_id
 	 */
 	public function send($email_queue_id = NULL)
+	{
 		// access check
-            c1bdc1c4
+		if (!$this->acl_check_new('Email_queues_Controller', 'email_queue'))
-baed187
+			Controller::error(ACCESS);
 		// bad parameter
 		if (!$email_queue_id || !is_numeric($email_queue_id))
 			Controller::warning(PARAMETER);
 		$email_queue = new Email_queue_Model($email_queue_id);
 		// record doens't exist
 		if (!$email_queue->id)
 			Controller::error(RECORD);
 		$swift = email::connect();
 		// Build recipient lists
 		$recipients = new Swift_RecipientList;
 		$recipients->addTo($email_queue->to);
-ac9009
+		// E-mail hash
 		$hash = sha1($email_queue->id . $email_queue->to . $email_queue->body);
 		$email_queue->hash = $hash;
-baed187
+		// Build the HTML message
-ac9009
+		$html_message = email::create_preview_link($hash) . $email_queue->body;
 		$message = new Swift_Message($email_queue->subject, $html_message, "text/html");
-baed187
+            Michal Kliment
 		// Send
 		$state = (
 				Config::get('unit_tester') ||
 				$swift->send($message, $recipients, $email_queue->from)
 		);
 		if ($state)
 			$email_queue->state = Email_queue_Model::STATE_OK;
 		else
 			$email_queue->state = Email_queue_Model::STATE_FAIL;
 		$email_queue->access_time = date('Y-m-d H:i:s');
 		$email_queue->save();
 		$swift->disconnect();
 		if ($state)
+		{
 			status::success('E-mail has been successfully sent');
 			url::redirect('email_queues/show_all_sent');
+		}
 		else
+		{
 			status::error('Error - e-mail has not been successfully sent');
 			url::redirect('email_queues/show_all_unsent');
+		}
+	}
 	/**
 	 * Deletes message from queue
+	 *
 	 * @author Michal Kliment
 	 * @param integer $email_queue_id
 	 */
 	public function delete($email_queue_id = NULL)
+	{
 		// access check
-            c1bdc1c4
+		if (!$this->acl_check_delete('Email_queues_Controller', 'email_queue'))
-baed187
+			Controller::error(ACCESS);
 		// bad parameter
 		if (!$email_queue_id || !is_numeric($email_queue_id))
 			Controller::warning(PARAMETER);
 		$email_queue = new Email_queue_Model($email_queue_id);
 		// record doens't exist
 		if (!$email_queue->id)
 			Controller::error(RECORD);
 		if ($email_queue->state != Email_queue_Model::STATE_OK)
+		{
 			$email_queue->delete();
 			status::success('Message has been successfully deleted');
+		}
 		else
 			status::error('Error - it is not possible delete already sent message');
 		url::redirect('email_queues/show_all_unsent');
+	}
 	/**
 	 * Deletes all unsended emails
+	 *
 	 * @author Ondřej Fibich
 	 */
-            c1bdc1c4
+	public function delete_unsent()
-baed187
+            Michal Kliment
 		// access
-            c1bdc1c4
+		if (!$this->acl_check_delete('Email_queues_Controller', 'email_queue'))
-baed187
+            Michal Kliment
 			Controller::error(ACCESS);
+		}
 		// model
 		$eq_model = new Email_queue_Model();
 		// count first
 		$count = $eq_model->where(array
+		(
 			'state'	=> Email_queue_Model::STATE_NEW
 		))->count_all();
 		// delete all
 		$eq_model->where(array
+		(
 			'state'	=> Email_queue_Model::STATE_NEW
 		))->delete_all();
 		// send notification
 		status::success('%d unsended e-mails has been deleted.', TRUE, $count);
 		// redirects
-            c1bdc1c4
+		url::redirect('email_queues/show_all_unsent');
+	}
 	/**
 	 * Deletes filtered sent emails
+	 *
 	 * @author Ondřej Fibich
 	 */
 	public function delete_sent()
+	{
 		// access
 		if (!$this->acl_check_delete('Email_queues_Controller', 'email_queue'))
+		{
 			Controller::error(ACCESS);
+		}
 		// filter load
 		$f = new Filter_form();
 		$f->autoload();
 		$fsql = $f->as_sql();
 		// model
 		$eq_model = new Email_queue_Model();
 		// count first
 		$count = $eq_model->count_all_sent_emails($fsql);
 		// delete all
 		if ($eq_model->count_all() == $count)
+		{
 			$eq_model->truncate();
+		}
 		// delete filtered
 		else
+		{
 			$eq_model->delete_sent_emails($fsql);
+		}
 		// send notification
 		status::success('%d sended e-mails has been deleted.', TRUE, $count);
 		// redirects
-baed187
+		url::redirect('email_queues/show_all_sent');
+	}
+}

Projekt

Obecné

Profil

FreenetIS