Merge branch 'master' into feature-68684/PHPMailer

- application/libraries/MailLib.php now set the default encoding to UTF-8

application/config/lrt.php

@@ -1,20 +0,0 @@
-<?php
-
-/**
- * Configs for the Long Run Tasks
- */
-
-if (! defined('BASEPATH')) exit('No direct script access allowed');
-
-// Maximum LRTs for a single user in parallel
-$config['lrt_max_number_single_user'] = 10;
-
-// Maximum LRTs for the whole system in parallel
-$config['lrt_max_number_system'] = 100;
-
-// Maximum running time in hours for a single LRT before killing it
-$config['lrt_max_run_timeout'] = 24;
-
-// List of existing LRT types
-$config['lrt_types'] = array('LRTDummy');
-

application/config/mail.php

@@ -4,34 +4,31 @@ if (!defined('BASEPATH')) exit('No direct script access allowed');
 
 // Define configuration parameters
 $config['email_number_to_sent'] = 1000; // Number of emails to sent each time sendAll is called
-$config['email_number_per_time_range'] = 1; // Number of emails to sent before pause
+$config['email_number_per_time_range'] = 882; // Number of emails to sent before pause
 $config['email_time_range'] = 1; // Length of the pause in seconds
 $config['email_from_system'] = 'no-reply@technikum-wien.at';
 $config['alias_from_system'] = 'No Reply';
 
-// Smtp: if the CI email library has to connect to a smtp server
-// Mail: if the system is setup to send emails with the standard php mail function
-// Sendmail: if the system is setup to send email via Sendmail (or similar)
-$config['protocol'] = ''; // mail, sendmail, or smtp
-
-// If protocol is set to sendmail
-$config['mailpath'] = ''; // SThe server path to Sendmail (or similar)
-
 // If protocol is set to smtp
 $config['smtp_host'] = 'localhost'; // SMTP Server Address
 $config['smtp_port'] = 25;
-$config['smtp_timeout'] = 5; // in seconds
+$config['smtp_timeout'] = 1; // in seconds
 $config['smtp_keepalive'] = false; // Enable persistent SMTP connections
+$config['smtp_auth'] = false;
 $config['smtp_user'] = '';
 $config['smtp_pass'] = '';
-$config['wordwrap'] = true; // {unwrap}http://example.com/a_long_link_that_should_not_be_wrapped.html{/unwrap}
-$config['wrapchars'] = 76; // Character count to wrap at.
-$config['mailtype'] = 'html'; // html or text
-$config['priority'] = 3; // Email Priority. 1 = highest. 5 = lowest. 3 = normal
-$config['validate'] = false; // If true then the email address will be validated
+$config['smtp_encryption'] = ''; // '', 'tls' or 'ssl'
+$config['wordwrap'] = 76;
+$config['is_html'] = true; // html or text
+$config['priority'] = 3; // 1 = High, 3 = Normal, 5 = low. When null, the header is not set at all.
 
-// If enabled will be logged info about emails in Codeigniter error logs
-$config['enable_debug'] = false;
+// If enabled will be logged info about emails
+// 0: Disable debugging (you can also leave this out completely, 0 is the default).
+// 1: Output messages sent by the client.
+// 2: as 1, plus responses received from the server (this is the most useful setting).
+// 3: as 2, plus more information about the initial connection - this level can help diagnose STARTTLS failures.
+// 4: as 3, plus even lower-level information, very verbose, don't use for debugging SMTP, only low-level problems.
+$config['enable_debug'] = 0;
 
 // default sender
 $config['sancho_mail_default_sender'] = defined('SANCHO_MAIL_DEFAULT_SENDER') ? SANCHO_MAIL_DEFAULT_SENDER : '';
@@ -47,3 +44,4 @@ $config['sancho_mail_header_img'] = defined('SANCHO_MAIL_HEADER_IMG') ? SANCHO_M
 
 // footer image for custom mails
 $config['sancho_mail_footer_img'] = defined('SANCHO_MAIL_FOOTER_IMG') ? SANCHO_MAIL_FOOTER_IMG : '';
+

application/controllers/jobs/LongRunTaskExecJob.php

@@ -1,112 +0,0 @@
-<?php
-
-if (!defined("BASEPATH")) exit("No direct script access allowed");
-
-/**
- * - This controller acts as interface of the LongRunTaskLib that contains
- * all the needed functionalities to operate with the Long Run Task system
- * that is built on top of the Jobs Queue System
- * - This is a Job Queue Worker that gets scheduled LRTs from the queue and executes them
- * - Once all the LRTs have been started checks if there are LRTs that are running for too long and kills them
- */
-class LongRunTaskExecJob extends JOB_Controller
-{
-	/**
-	 * Constructor
-	 */
-	public function __construct()
-	{
-		parent::__construct();
-
-		// Changes the needed configs for LogLib
-		$this->LogLibJob->setConfigs(
-			array(
-				'dbExecuteUser' => get_class($this),
-				'requestId' => 'LRT'
-			)
-		);
-
-		// Loads LongRunTaskLib library
-		$this->load->library('LongRunTaskLib');
-	}
-
-	/**
-	 * Executes all the new LRTs
-	 */
-	public function execEmAll()
-	{
-		$this->logInfo('Execute long run tasks started');
-
-		// Get all the LRTs that is possible to execute now
-		$lrtsResult = $this->longruntasklib->getNewLRTs();
-		// If an error occurred then return it
-		if (isError($lrtsResult)) return $lrtsResult;
-
-		if (hasData($lrtsResult))
-		{
-			// For each LRT
-			foreach (getData($lrtsResult) as $lrt)
-			{
-				// Execute the task
-				$executeLrtResult = $this->longruntasklib->executeLrt($lrt);
-				if (isError($executeLrtResult)) $this->logError($executeLrtResult);
-			}
-		}
-
-		$this->logInfo('Execute long run tasks ended');
-	}
-
-	/**
-	 * Kills all the hanging LRTs
-	 */
-	public function killHangingLRTs()
-	{
-		$this->logInfo('Kill hanging LRTs started');
-
-		// Get all the LRTs that is possible to execute now
-		$lrtsResult = $this->longruntasklib->getHangingLRTs();
-		// If an error occurred then return it
-		if (isError($lrtsResult)) return $lrtsResult;
-
-		if (hasData($lrtsResult))
-		{
-			// For each LRT
-			foreach (getData($lrtsResult) as $lrt)
-			{
-				// Kill the task
-				$killLrtResult = $this->longruntasklib->killLrt($lrt);
-				if (isError($killLrtResult)) $this->logError($killLrtResult);
-			}
-		}
-
-		$this->logInfo('Kill hanging LRTs ended');
-	}
-
-	/**
-	 * 
-	 */
-	public function checkExecution()
-	{
-		$this->logInfo('Check execution long run tasks started');
-
-		// Get the related LRT data from the queue
-		$lrtsResult = $this->longruntasklib->getRunningLRTs();
-		// If an error occurred then return it
-		if (isError($lrtsResult)) return $lrtsResult;
-
-		// If there are running LRTs
-		if (hasData($lrtsResult))
-		{
-			// For each LRT
-			foreach (getData($lrtsResult) as $lrt)
-			{
-				// Check the LRT execution
-				$checkExecutionResult = $this->longruntasklib->checkExecution($lrt);
-				if (isError($checkExecutionResult)) $this->logError($checkExecutionResult);
-			}
-		}
-
-		$this->logInfo('Check execution long run tasks ended');
-	}
-}
-

application/controllers/lrts/LRTDummy.php

@@ -1,82 +0,0 @@
-<?php
-
-if (!defined("BASEPATH")) exit("No direct script access allowed");
-
-/**
- * Testing LRT to check if the LRT system is working properly
- * This will be called by the LongRunTaskExecJob
- */
-class LRTDummy extends LRT_Controller
-{
-	/**
-	 * This method must be implemented!
-	 */
-	public function run($jobid)
-	{
-		$this->logInfo('Long run tasks '.get_class($this).' started');
-
-		$this->_doIt($jobid);
-
-		$this->logInfo('Long run tasks '.get_class($this).' ended');
-	}
-
-	/**
-	 * Loops on the number of seconds provided by the LRT input
-	 * Sleeps every time 1 sec
-	 * Writes the progress
-	 * Writes the output
-	 */
-	private function _doIt($jobid)
-	{
-		// Get the LRT record related to the provided jobid
-		$lrtResult = $this->getLrt($jobid);
-
-		// If an error occurred or the record has not been found
-		if (isError($lrtResult))
-		{
-			$this->logError($lrtResult);
-			return;
-		}
-		if (!hasData($lrtResult))
-		{
-			$this->logError('LRT not found in database');
-			return;
-		}
-		
-		// Get the record
-		$lrt = getData($lrtResult)[0];
-
-		// Get and check the input
-		$input = json_decode($lrt->{LongRunTaskLib::PROPERTY_INPUT});
-		if ($input == null)
-		{
-			$this->logError('LRT input is not a valid json');
-			return;
-		}
-
-		// Operation
-		for ($i = 0; $i < (int)$input->sleep; $i++)
-		{
-			sleep(1);
-			// Set the progress
-			$setProgressResult = $this->setProgress($jobid, (($i + 1) / (int)$input->sleep) * 100);
-			if (isError($setProgressResult))
-			{
-				$this->logError($setProgressResult);
-				return;
-			}
-		}
-
-		$sleepMsg = 'The user '.$lrt->{LongRunTaskLib::PROPERTY_UID}.' slept for '.$input->sleep.' seconds';
-
-		$this->logInfo($sleepMsg);
-
-		// Set the output
-		$setOutputResult = $this->setOutput($jobid, $sleepMsg);
-		if (isError($setOutputResult))
-		{
-			$this->logError($setOutputResult);
-		}
-	}
-}
-

application/controllers/system/LRTTest.php

@@ -1,56 +0,0 @@
-<?php
-
-if (!defined('BASEPATH')) exit('No direct script access allowed');
-
-use \stdClass as stdClass;
-
-/**
- * 
- */
-class LRTTest extends Auth_Controller
-{
-	/**
-	 *
-	 */
-	public function __construct()
-	{
-		parent::__construct(
-			array(
-				'index' => 'system/developer:r',
-				'lrt1min' => 'system/developer:r',
-			)
-		);
-
-		// Loads LongRunTaskLib library
-		$this->load->library('LongRunTaskLib');
-	}
-
-	// -----------------------------------------------------------------------------------------------------------------
-	// Public methods
-
-	/**
-	 * Everything has a beginning
-	 */
-	public function index()
-	{
-		$this->load->view('system/lrtTest.php');
-	}
-
-	/**
-	 *
-	 */
-	public function lrt1min()
-	{
-		$lrtInput = new stdClass();
-		$lrtInput->sleep = 1; // Sleep for 1 min
-
-		$this->outputJsonSuccess(
-			$this->longruntasklib->addNewLrtToQueue(
-				'LRTDummy', // LRT type
-				getAuthUID(), // UID executer
-				$lrtInput // LRT input
-			)
-		);
-	}
-}
-

application/core/LRT_Controller.php

@@ -1,69 +0,0 @@
-<?php
-
-if (!defined("BASEPATH")) exit("No direct script access allowed");
-
-/**
- * Long Run Task
- *
- * - This controller acts as interface of the LongRunTaskLib that contains
- * all the needed functionalities to operate with the Long Run Task system
- * that is built on top of the Jobs Queue System
- * - This is an abstract class that provide basic functionalities,
- * it has to be extended to broaden its logic
- * - Any implementation of a Long Run Task should extends this class to
- * properly operate with the LRT system
- */
-abstract class LRT_Controller extends JOB_Controller
-{
-	/**
-	 * Constructor
-	 */
-	public function __construct()
-	{
-		parent::__construct();
-
-		// Changes the needed configs for LogLib
-		$this->LogLibJob->setConfigs(
-			array(
-				'dbExecuteUser' => get_class($this),
-				'requestId' => 'LRT'
-			)
-		);
-
-		// Loads LongRunTaskLib library
-		$this->load->library('LongRunTaskLib');
-	}
-
-	//------------------------------------------------------------------------------------------------------------------
-	// Public methods
-
-	abstract public function run($jobid);
-
-	//------------------------------------------------------------------------------------------------------------------
-	// Protected methods
-
-	/**
-	 *
-	 */
-	protected function getLrt($jobid)
-	{
-		return $this->longruntasklib->getLrt($jobid);
-	}
-
-	/**
-	 * 
-	 */
-	protected function setProgress($jobid, $progress)
-	{
-		return $this->longruntasklib->setProgress($jobid, $progress);
-	}
-
-	/**
-	 * 
-	 */
-	protected function setOutput($jobid, $output)
-	{
-		return $this->longruntasklib->setOutuput($jobid, $output);
-	}
-}
-

application/helpers/hlp_sancho_helper.php

@@ -35,41 +35,20 @@ if (! defined('BASEPATH')) exit('No direct script access allowed');
  * @param string $bcc Sets BCC of mail.
  * @return void
  */
-function sendSanchoMail(
-	$vorlage_kurzbz,
-	$vorlage_data,
-	$to,
-	$subject,
-	$headerImg = '',
-	$footerImg = '',
-	$from = null,
-	$cc = null,
-	$bcc = null
-)
+function sendSanchoMail($vorlage_kurzbz, $vorlage_data, $to, $subject, $headerImg = '', $footerImg = '', $from = null, $cc = null, $bcc = null)
 {
 	$ci =& get_instance();
-	$ci->load->library('email');
 	$ci->load->library('MailLib');
 
+	$embeddedImages = array();
+	$_from = 'noreply@' . DOMAIN;
 	$sancho_mail_config = $ci->config->item('mail');
 
-
-	if ($from == '')
+	if ($from == null && isset($sancho_mail_config['sancho_mail_default_sender']) && $sancho_mail_config['sancho_mail_default_sender'])
 	{
-		$from = ((isset($sancho_mail_config['sancho_mail_default_sender'])
-				&& $sancho_mail_config['sancho_mail_default_sender']) 
-			  ? $sancho_mail_config['sancho_mail_default_sender']
-			  : 'noreply')
-			  . '@' . DOMAIN;
+		$_from = $sancho_mail_config['sancho_mail_default_sender'] . '@' . DOMAIN;
 	}
 
-	// Embed sancho header and footer image
-	// reset important to ensure embedding of images when called in a loop
-	$ci->email->clear(true);  // clear vars and attachments
-
-	$cid_header = '';
-	$cid_footer = '';
-
 	if (isset($sancho_mail_config['sancho_mail_use_images']) && $sancho_mail_config['sancho_mail_use_images'])
 	{
 		$sanchoHeader_img = '';
@@ -111,29 +90,27 @@ function sendSanchoMail(
 			}
 		}
 
-		// attach header and footer
-		$ci->email->attach($sanchoHeader_img, 'inline');
-		$ci->email->attach($sanchoFooter_img, 'inline');
-		$cid_header = $ci->email->attachment_cid($sanchoHeader_img); // sets unique content id for embedding
-		$cid_footer = $ci->email->attachment_cid($sanchoFooter_img); // sets unique content id for embedding
+		// Attach header and footer
+		$embeddedImages[] = array('file_name' => $sanchoHeader_img, 'cid' => 'sancho_header');
+		$embeddedImages[] = array('file_name' => $sanchoFooter_img, 'cid' => 'sancho_footer');
 	}
 
 	// Set specific mail content into specific content template
 	$content = _parseMailContent($vorlage_kurzbz, $vorlage_data);
 
-	// overall main content data array
-	$layout = array(
-		'CID_header' => $cid_header,
-		'CID_footer' => $cid_footer,
-		'content' => $content
-	);
-
 	// Set overall main content into the sancho mail template
-	$body = _parseMailContent('Sancho_Mail_Template', $layout);
+	$body = _parseMailContent(
+		'Sancho_Mail_Template',
+		array(
+			'CID_header' => 'sancho_header',
+			'CID_footer' => 'sancho_footer',
+			'content' => $content
+		)
+	);
 
 	// Send mail
 	return $ci->maillib->send(
-		$from,
+		$_from,
 		$to,
 		$subject,
 		$body,
@@ -142,7 +119,8 @@ function sendSanchoMail(
 		$bcc,
 		'', // altMessage
 		true, // bulk
-		true // autogenerated
+		true, // autogenerated
+		$embeddedImages
 	);
 }
 
@@ -171,3 +149,4 @@ function _parseMailContent($vorlage_kurzbz, $vorlage_data)
 		}
 	}
 }
+

application/libraries/JobsQueueLib.php

@@ -2,8 +2,6 @@
 
 if (!defined('BASEPATH')) exit('No direct script access allowed');
 
-use \stdClass as stdClass;
-
 /**
  * Library that contains all the needed functionalities to operate with the Jobs Queue System
  */
@@ -26,12 +24,12 @@ class JobsQueueLib
 	const PROPERTY_END_TIME = 'endtime';
 	const PROPERTY_ERROR = 'error';
 
-	protected $_ci; // CI instance
+	private $_ci; // CI instance
 
 	/**
 	 * Constructor
 	 */
-	public function __construct()
+	public function __construct($authenticate = true)
 	{
 		// Gets CI instance
 		$this->_ci =& get_instance();
@@ -64,29 +62,14 @@ class JobsQueueLib
 	 */
 	public function getOldestJobs($type, $maxAmount = null)
 	{
-		$types = $type; // default is array
-		$limit = 0; // default query limit
+		$this->_ci->JobsQueueModel->resetQuery();
+
+		$this->_ci->JobsQueueModel->addOrder('creationtime', 'ASC');
 
 		// If the maximum amount of jobs to retrieve have been specified
-		if (is_numeric($maxAmount)) $limit = $maxAmount;
+		if (is_numeric($maxAmount)) $this->_ci->JobsQueueModel->addLimit($maxAmount);
 
-		// If it is a string then include it into an array
-		if (!isEmptyString($type) && is_string($type)) $types = array($type);
-
-		// Return the result of the query
-		return $this->_ci->JobsQueueModel->execReadOnlyQuery('
-			SELECT jq.*
-			  FROM system.tbl_jobsqueue jq
-			 WHERE jq.type IN ?
-			   AND jq.status = ?
-		      ORDER BY jq.creationtime DESC
-			 LIMIT ?',
-			array(
-				$types,
-				self::STATUS_NEW,
-				$limit
-			)
-		);
+		return $this->_ci->JobsQueueModel->loadWhere(array('status' => self::STATUS_NEW, 'type' => $type));
 	}
 
 	/**
@@ -94,23 +77,11 @@ class JobsQueueLib
 	 */
 	public function getJobsByTypeStatus($type, $status)
 	{
-		$types = $type; // default is array
+		$this->_ci->JobsQueueModel->resetQuery();
 
-		// If it is a string then include it into an array
-		if (!isEmptyString($type) && is_string($type)) $types = array($type);
+		$this->_ci->JobsQueueModel->addOrder('creationtime', 'DESC');
 
-		// Return the result of the query
-		return $this->_ci->JobsQueueModel->execReadOnlyQuery('
-			SELECT jq.*
-			  FROM system.tbl_jobsqueue jq
-			 WHERE jq.type IN ?
-			   AND jq.status = ?
-		      ORDER BY jq.creationtime DESC',
-			array(
-				$types,
-				$status
-			)
-		);
+		return $this->_ci->JobsQueueModel->loadWhere(array('status' => $status, 'type' => $type));
 	}
 
 	/**
@@ -282,30 +253,8 @@ class JobsQueueLib
 		return array($job);
 	}
 
-	//------------------------------------------------------------------------------------------------------------------
-	// Protected methods
-
-	/**
-	 * Checks if the given job contains a valid type
-	 */
-	protected function _checkJobType($type, $types)
-	{
-		return $this->_inArray($type, $types, self::PROPERTY_TYPE);
-	}
-
 	//------------------------------------------------------------------------------------------------------------------
 	// Private methods
-	
-	/**
-	 * Drop not allowed properties from the given job
-	 */
-	private function _dropNotAllowedPropertiesNewJob(&$job)
-	{
-		unset($job->{self::PROPERTY_JOBID});
-		unset($job->{self::PROPERTY_CREATIONTIME});
-		unset($job->{self::PROPERTY_TYPE});
-	}
-
 
 	/**
 	 * Checks the job object structure when needed for insert
@@ -332,6 +281,34 @@ class JobsQueueLib
 		return false; // better sorry than wrong
 	}
 
+	/**
+	 * Checks the job object structure when needed for update
+	 */
+	private function _checkUpdateJobStructure(&$job)
+	{
+		// If job is a valid object
+		if (is_object($job) && property_exists($job, self::PROPERTY_JOBID)) return true; // it is valid!
+
+		// If not object then object it!
+		if (!is_object($job)) $job = new stdClass();
+
+		// If an error property was not already previously stored then store an error message in job object
+		if (!property_exists($job, self::PROPERTY_ERROR))
+		{
+			$job->{self::PROPERTY_ERROR} = 'The structure of the provided job is not valid';
+		}
+
+		return false; // better sorry than wrong
+	}
+
+	/**
+	 * Checks if the given job contains a valid type
+	 */
+	private function _checkJobType($type, $types)
+	{
+		return $this->_inArray($type, $types, self::PROPERTY_TYPE);
+	}
+
 	/**
 	 * Checks if the given job contains a valid status
 	 */
@@ -356,26 +333,6 @@ class JobsQueueLib
 		return $found;
 	}
 
-	/**
-	 * Checks the job object structure when needed for update
-	 */
-	private function _checkUpdateJobStructure(&$job)
-	{
-		// If job is a valid object
-		if (is_object($job) && property_exists($job, self::PROPERTY_JOBID)) return true; // it is valid!
-
-		// If not object then object it!
-		if (!is_object($job)) $job = new stdClass();
-
-		// If an error property was not already previously stored then store an error message in job object
-		if (!property_exists($job, self::PROPERTY_ERROR))
-		{
-			$job->{self::PROPERTY_ERROR} = 'The structure of the provided job is not valid';
-		}
-
-		return false; // better sorry than wrong
-	}
-
 	/**
 	 * Search in an array the given value
 	 * The elements of the given array are objects
@@ -397,6 +354,16 @@ class JobsQueueLib
 		return $found;
 	}
 
+	/**
+	 * Drop not allowed properties from the given job
+	 */
+	private function _dropNotAllowedPropertiesNewJob(&$job)
+	{
+		unset($job->{self::PROPERTY_JOBID});
+		unset($job->{self::PROPERTY_CREATIONTIME});
+		unset($job->{self::PROPERTY_TYPE});
+	}
+
 	/**
 	 * Drop not allowed properties from the given job
 	 */

application/libraries/LongRunTaskLib.php

@@ -1,333 +0,0 @@
-<?php
-
-if (!defined('BASEPATH')) exit('No direct script access allowed');
-
-require_once 'JobsQueueLib.php';
-
-/**
- * Library that contains all the needed functionalities to operate with the Long Run Tasks
- */
-class LongRunTaskLib extends JobsQueueLib
-{
-	// Config names
-	const CFG_LRT_MAX_NUMBER_SYSTEM = 'lrt_max_number_system';
-	const CFG_LRT_TYPES = 'lrt_types';
-	const CFG_LRT_MAX_RUN = 'lrt_max_run_timeout';
-	const CFG_LRT_MAX_NUMBER_USER = 'lrt_max_number_single_user';
-
-	// LRT object properties
-	const PROPERTY_UID = 'uid';
-	const PROPERTY_PID = 'pid';
-
-	/**
-	 * Constructor
-	 */
-	public function __construct()
-	{
-		parent::__construct();
-
-		// Loads the Long Run Tasks configs
-		$this->_ci->config->load('lrt');
-	}
-
-	//------------------------------------------------------------------------------------------------------------------
-	// Public methods used by the LongRunTaskExecJob
-
-	/**
-	 * Get the oldest added LRTs to the queue having status = new
-	 * The maximum number of returned queued LRTs is limited by:
-	 * number of currently running LRTs - maximum allowed number of LRTs for the system
-	 */
-	public function getNewLRTs()
-	{
-		// Get all the running LRTs
-		$runningLrtsResult = $this->getJobsByTypeStatus($this->_ci->config->item(self::CFG_LRT_TYPES), JobsQueueLib::STATUS_RUNNING);
-
-		if (isError($runningLrtsResult)) return $runningLrtsResult;
-
-		// The number of the currently running LRTs - the maximum LRTs for the system
-		$max_number_of_lrts = $this->_ci->config->item(self::CFG_LRT_MAX_NUMBER_SYSTEM) - count(getData($runningLrtsResult));
-
-		// Get the oldest LRTs added to the queue
-		return $this->getOldestJobs($this->_ci->config->item(self::CFG_LRT_TYPES), $max_number_of_lrts);
-	}
-
-	/**
-	 * Get all the LRT that are running more then CFG_LRT_MAX_RUN hours
-	 */
-	public function getHangingLRTs()
-	{
-		// Return the result of the query
-		return $this->_ci->JobsQueueModel->execReadOnlyQuery('
-			SELECT jq.*
-		          FROM system.tbl_jobsqueue jq
-			 WHERE jq.type IN ?
-			   AND jq.status = ?
-			   AND jq.starttime < NOW() - INTERVAL \''.$this->_ci->config->item(self::CFG_LRT_MAX_RUN).' hours\'
-		      ORDER BY jq.creationtime DESC',
-			array(
-				$this->_ci->config->item(self::CFG_LRT_TYPES),
-				JobsQueueLib::STATUS_RUNNING
-			)
-		);
-	}
-
-	/**
-	 * Get all the LRT that are currently running
-	 */
-	public function getRunningLRTs()
-	{
-		// Return the result of the query
-		return $this->_ci->JobsQueueModel->execReadOnlyQuery('
-			SELECT jq.*
-		          FROM system.tbl_jobsqueue jq
-			 WHERE jq.type IN ?
-			   AND jq.status = ?
-		      ORDER BY jq.creationtime DESC',
-			array(
-				$this->_ci->config->item(self::CFG_LRT_TYPES),
-				JobsQueueLib::STATUS_RUNNING
-			)
-		);
-	}
-
-	/**
-	 * Execute a LRT in background
-	 * - Checks if the wanted LRT exists in the applcation/controllers/lrts directory
-	 * - Then executes it in background via CI CLI
-	 * - Stores the LRT pid into the database
-	 */
-	public function executeLrt($lrt)
-	{
-		$output = array();
-
-		// If does _not_ exist a LRT implementation for this LRT type, then return an error
-		if (!file_exists(APPPATH.'controllers/lrts/'.$lrt->{self::PROPERTY_TYPE}.'.php'))
-		{
-			return error('The required LRT implementation has not been found');
-		}
-
-		// Execute the LRT implementation (a CI controller from CLI) providing as parameter the jobid
-		exec(
-			// Command
-			sprintf(
-				'/usr/bin/php %s/../index.ci.php lrts/%s/run %s > /dev/null 2>&1 & echo $!',
-				APPPATH,
-				$lrt->{self::PROPERTY_TYPE},
-				$lrt->{self::PROPERTY_JOBID}
-			),
-			$output // Here goes the output from the standard output and error
-		);
-
-		// If a pid has not been returned
-		if (isEmptyArray($output) || !is_numeric($output[0])) return error('Not a valid pid has been returned');
-
-		// Set the pid, status and starttime of this LRT into the database
-		$updateLrtResult = $this->_ci->JobsQueueModel->update(
-			$lrt->{self::PROPERTY_JOBID},
-			array(
-				'pid' => $output[0],
-				'starttime' => 'NOW()',
-				'status' => self::STATUS_RUNNING
-			)
-		);
-		if (isError($updateLrtResult)) return $updateLrtResult;
-	}
-
-	/**
-	 * Kill the provided LRT
-	 * To avoid to kill a process that is not this LRT,
-	 * since the same PID can be assigned to another process once this ended
-	 */
-	public function killLrt($lrt)
-	{
-		// Try to get the pid of this LRT from the system
-		$pid = exec(
-			sprintf(
-				'ps -eo pid,cmd | grep "index.ci.php lrts/%s/run %s" | grep -v grep | awk \'{print $1}\'',
-				$lrt->{self::PROPERTY_TYPE},
-				$lrt->{self::PROPERTY_JOBID}
-			)
-		);
-
-		// If the pid is the same then kill the process with a SIGKILL
-		if ($pid == $lrt->{self::PROPERTY_PID}) exec('kill -9 '.$lrt->{self::PROPERTY_PID}.' > /dev/null 2>&1');
-
-		// Set the LRT as failed in any case
-		$lrtExecFailedResult = $this->_ci->JobsQueueModel->update(
-			$lrt->{self::PROPERTY_JOBID},
-			array(
-				'endtime' => 'NOW()',
-				'status' => self::STATUS_FAILED
-			)
-		);
-		// If an error occurred then return it
-		if (isError($lrtExecFailedResult)) return $lrtExecFailedResult;
-	}
-
-	/**
-	 *
-	 */
-	public function checkExecution($lrt)
-	{
-		// If the LRT stopped running
-		if (!$this->_isRunning($lrt))
-		{
-			// Loads MessageLib library
-			$this->_ci->load->library('MessageLib');
-			// Load the BenutzerModel
-			$this->_ci->load->model('person/Benutzer_model', 'BenutzerModel');
-
-			// Get the benutzer for this uid
-			$benutzerResult = $this->_ci->BenutzerModel->loadWhere(array('uid' => $lrt->{LongRunTaskLib::PROPERTY_UID}));
-			// If an error occurred then return it
-			if (isError($benutzerResult)) return $benutzerResult;
-			// If no benutzer has been found
-			if (!hasData($benutzerResult)) return error('No benutzer found, uid: '.$lrt->{LongRunTaskLib::PROPERTY_UID});
-
-			$benutzer = getData($benutzerResult)[0];
-
-			// Sends a message to the user
-			$messageResult = $this->_ci->messagelib->sendMessageUser(
-			        $benutzer->person_id,
-			        'Long run task ended',
-			        'The long run task '.$lrt->{self::PROPERTY_TYPE}.' ended, output: '.$lrt->{self::PROPERTY_OUTPUT}
-			);
-			// If an error occurred then return it
-			if (isError($messageResult)) return $messageResult;
-
-			// Set the LRT as done
-			$lrtExecOverResult = $this->_ci->JobsQueueModel->update(
-				$lrt->{self::PROPERTY_JOBID},
-				array(
-					'endtime' => 'NOW()',
-					'status' => self::STATUS_DONE
-				)
-			);
-			// If an error occurred then return it
-			if (isError($lrtExecOverResult)) return $lrtExecOverResult;
-		}
-	}
-
-	//------------------------------------------------------------------------------------------------------------------
-	// Public methods used by the front end applications (standard controllers/end points, ex. controllers/system/LRTTest.php)
-
-	/**
-	 * Add a single LRT to the queue
-	 */
-	public function addNewLrtToQueue($type, $uid, $lrtInput)
-	{
-		// Checks parameters
-		if (isEmptyString($type)) return error('The provided type parameter is not a valid string');
-		if (isEmptyString($uid)) return error('The provided uid parameter is not a valid string');
-
-		// Get all the running task for this uid
-		// Return the result of the query
-                $runningLRTbyUIDResult = $this->_ci->JobsQueueModel->execReadOnlyQuery('
-			SELECT jq.*
-			  FROM system.tbl_jobsqueue jq
-			 WHERE jq.status IN ?
-			   AND jq.uid = ?
-			',
-			array(
-				array(
-					self::STATUS_NEW,
-					self::STATUS_RUNNING
-				),
-				$uid
-			)
-                );
-
-		// If an error occurred then return it
-		if (isError($runningLRTbyUIDResult)) return $runningLRTbyUIDResult;
-
-		// If the running tasks for this user are too many
-		if (count(getData($runningLRTbyUIDResult)) >= $this->_ci->config->item(self::CFG_LRT_MAX_NUMBER_USER))
-		{
-			return error('Too many running tasks for this user');
-		}
-
-		// Convert input to JSON and check it
-		$jsonLrtInput = json_encode($lrtInput);
-		if ($jsonLrtInput == null) return error('The provided LRT input is not valid');
-
-		// Get all the job types
-		$dbResult = $this->_ci->JobTypesModel->load();
-		if (isError($dbResult)) return $dbResult;
-		$types = getData($dbResult);
-
-		// If the given type is not present in database
-		if (!$this->_checkJobType($type, $types)) return error('The provided type parameter is not valid');
-
-		// Get all the job statuses
-		$dbResult = $this->_ci->JobStatusesModel->load();
-		if (isError($dbResult)) return $dbResult;
-		$statuses = getData($dbResult);
-
-		// Create an object that represent the new tbl_jobsqueue record with the provided input
-		$lrt = $this->generateJobs(self::STATUS_NEW, $jsonLrtInput)[0];
-
-		// What you asked is what you get!
-		$lrt->{self::PROPERTY_TYPE} = $type;
-		$lrt->{self::PROPERTY_UID} = $uid;
-
-		// Try to insert the single lrt into database
-		$dbNewLrtResult = $this->_ci->JobsQueueModel->insert($lrt);
-
-		// If an error occurred during while inserting in database
-		if (isError($dbNewLrtResult)) return $dbNewLrtResult;
-
-		return success('LRT added to the queue');
-	}
-
-	//------------------------------------------------------------------------------------------------------------------
-	// Public methods used by the LRT implementation (controllers/ltrs/*, ex. controllers/ltrs/LRTDummy)
-
-	/**
-	 * Return a single record from the 
-	 */
-	public function getLrt($jobid)
-	{
-		$this->_ci->JobsQueueModel->resetQuery();
-
-		return $this->_ci->JobsQueueModel->loadWhere(array('jobid' => $jobid));
-	}
-
-	/**
-	 * 
-	 */
-	public function setProgress($jobid, $progress)
-	{
-		return $this->_ci->JobsQueueModel->update($jobid, array('progress' => $progress));
-	}
-
-	/**
-	 * 
-	 */
-	public function setOutuput($jobid, $output)
-	{
-		return $this->_ci->JobsQueueModel->update($jobid, array('output' => json_encode($output)));
-	}
-
-	//------------------------------------------------------------------------------------------------------------------
-	// Private methods
-
-	/**
-	 * Return true if the LRT is still running
-	 */
-	private function _isRunning($lrt)
-	{
-		// Try to get the pid of this LRT from the system
-		$pid = exec(
-			sprintf(
-				'ps -eo pid,cmd | grep "index.ci.php lrts/%s/run %s" | grep -v grep | awk \'{print $1}\'',
-				$lrt->{self::PROPERTY_TYPE},
-				$lrt->{self::PROPERTY_JOBID}
-			)
-		);
-
-		// If the pid is the same then the LRT is still running
-		return $pid == $lrt->{self::PROPERTY_PID};
-	}
-}
-

application/libraries/MailLib.php

@@ -2,6 +2,10 @@
 
 if (! defined('BASEPATH')) exit('No direct script access allowed');
 
+use PHPMailer\PHPMailer\PHPMailer;
+use PHPMailer\PHPMailer\SMTP;
+use PHPMailer\PHPMailer\Exception;
+
 /**
  * Library to manage the sending of the email
  */
@@ -9,7 +13,7 @@ class MailLib
 {
 	const ENABLE_DEBUG = 'enable_debug';
 
-	private $sended; // Sended email counter
+	private $_sended; // Sended email counter
 
 	// Properties for storing the configuration
 	private $email_number_to_sent;
@@ -18,6 +22,7 @@ class MailLib
 	private $email_from_system;
 
 	private $_ci; // Codeigniter instance
+	private $_mail; // PHPMailer instance
 
 	/**
 	 * Class constructor
@@ -25,7 +30,7 @@ class MailLib
 	public function __construct()
 	{
 		// Set the counter to 0
-		$this->sended = 0;
+		$this->_sended = 0;
 
 		// Get CI instance
 		$this->_ci =& get_instance();
@@ -33,97 +38,135 @@ class MailLib
 		// The second parameter is used to avoiding name collisions in the config array
 		$this->_ci->config->load('mail', true);
 
-		// CI Email library
-		$this->_ci->load->library('email');
+		try
+		{
+			// PHPMailer configuration
+			$this->_mail = new PHPMailer(true);
+			$this->_mail->isSMTP();								// Send using SMTP
+			$this->_mail->Host = $this->_getEmailCfgItem('smtp_host');			// Set the SMTP server to send through
+			$this->_mail->Port = $this->_getEmailCfgItem('smtp_port');			// TCP port to connect to; use 587 if you have set `SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS`
+			$this->_mail->SMTPAuth = $this->_getEmailCfgItem('smtp_auth');			// Enable SMTP authentication
+			$this->_mail->Username = $this->_getEmailCfgItem('smtp_user');			// SMTP username
+			$this->_mail->Password = $this->_getEmailCfgItem('smtp_pass');			// SMTP password
+			$this->_mail->SMTPSecure = $this->_getEmailCfgItem('smtp_encryption');		// Enable implicit TLS encryption
+			$this->_mail->Timeout = $this->_getEmailCfgItem('smtp_timeout');		// set the timeout (seconds)
+			$this->_mail->SMTPKeepAlive = $this->_getEmailCfgItem('smtp_keepalive');	// Persistent SMTP connection
+			$this->_mail->Priority = $this->_getEmailCfgItem('priority');			// 1 = High, 3 = Normal, 5 = low. When null, the header is not set at all.
+			$this->_mail->WordWrap = $this->_getEmailCfgItem('wordwrap');
+			$this->_mail->isHTML($this->_getEmailCfgItem('is_html'));			// html or text
+			$this->_mail->SMTPDebug = $this->_getEmailCfgItem('enable_debug');
+			$this->_mail->CharSet = 'UTF-8';
 
-		// Initializing email library with the loaded configurations
-		$this->_ci->email->initialize($this->_ci->config->config['mail']);
-
-		// Set the configuration properties with the standard configuration values
-		$this->email_number_to_sent = $this->getEmailCfgItem('email_number_to_sent');
-		$this->email_number_per_time_range = $this->getEmailCfgItem('email_number_per_time_range');
-		$this->email_time_range = $this->getEmailCfgItem('email_time_range');
-		$this->email_from_system = $this->getEmailCfgItem('email_from_system');
-		$this->alias_from_system = $this->getEmailCfgItem('alias_from_system');
+			// Set the configuration properties with the standard configuration values
+			$this->email_number_to_sent = $this->_getEmailCfgItem('email_number_to_sent');
+			$this->email_number_per_time_range = $this->_getEmailCfgItem('email_number_per_time_range');
+			$this->email_time_range = $this->_getEmailCfgItem('email_time_range');
+			$this->email_from_system = $this->_getEmailCfgItem('email_from_system');
+			$this->alias_from_system = $this->_getEmailCfgItem('alias_from_system');
+		}
+		catch(Exception $e)
+		{
+			error_log($e->errorMessage());
+		}
 	}
 
 	/**
 	 * Sends a single email
 	 */
-	public function send($from, $to, $subject, $message, $alias = '', $cc = null, $bcc = null, $altMessage = '', $bulk = false, $autogenerated = false)
+	public function send($from, $to, $subject, $message, $alias = '', $cc = null, $bcc = null, $altMessage = '', $bulk = false, $autogenerated = false, $embeddedImages = array())
 	{
-		// If it is configured then log mail info into the CI error logs
-		if ($this->getEmailCfgItem(self::ENABLE_DEBUG) === true)
-		{
-			$this->_ci->load->library('LogLib'); // Loads logging library
+		$result = false;
 
-			// Log them all!
-			$this->_ci->loglib->logError('From: '.$from);
-			$this->_ci->loglib->logError('To: '.$to);
-			$this->_ci->loglib->logError('Subject: '.$subject);
-			$this->_ci->loglib->logError('Message: '.$message);
-			$this->_ci->loglib->logError('Alias: '.$alias);
-			$this->_ci->loglib->logError('CC: '.$cc);
-			$this->_ci->loglib->logError('BCC: '.$bcc);
-			$this->_ci->loglib->logError('Alternative message: '.$altMessage);
-		}
-
-		// If from is not specified then use the standard one
-		if (is_null($from) || $from == '')
+		try
 		{
-			$from = $this->email_from_system;
-			// If alias is not specified then use the standard one
-			if (is_null($alias) || $alias == '')
+			// If it is configured then log mail info into the CI error logs
+			if ($this->_getEmailCfgItem(self::ENABLE_DEBUG) === true)
 			{
-				$alias = $this->alias_from_system;
+				$this->_ci->load->library('LogLib'); // Loads logging library
+
+				// Log them all!
+				$this->_ci->loglib->logError('From: '.$from);
+				$this->_ci->loglib->logError('To: '.$to);
+				$this->_ci->loglib->logError('Subject: '.$subject);
+				$this->_ci->loglib->logError('Message: '.$message);
+				$this->_ci->loglib->logError('Alias: '.$alias);
+				$this->_ci->loglib->logError('CC: '.$cc);
+				$this->_ci->loglib->logError('BCC: '.$bcc);
+				$this->_ci->loglib->logError('Alternative message: '.$altMessage);
 			}
-		}
-		if (defined('MAIL_FROM') && MAIL_FROM != '')
-		{
-			$from = MAIL_FROM;
-			if (is_null($alias) || $alias == '')
+
+			// If from is not specified then use the standard one
+			if (is_null($from) || $from == '')
 			{
-				$alias = $this->alias_from_system;
+				$from = $this->email_from_system;
+				// If alias is not specified then use the standard one
+				if (is_null($alias) || $alias == '')
+				{
+					$alias = $this->alias_from_system;
+				}
 			}
+			if (defined('MAIL_FROM') && MAIL_FROM != '')
+			{
+				$from = MAIL_FROM;
+				if (is_null($alias) || $alias == '')
+				{
+					$alias = $this->alias_from_system;
+				}
+			}
+
+			$this->_mail->setFrom($from, $alias);
+
+			// Check if the email address of the debug recipient is a valid one
+			$recipient = $to;
+			$recipientCC = $cc;
+			$recipientBCC = $bcc;
+
+			// If we the an email for debugging has been set
+			if (defined('MAIL_DEBUG') && MAIL_DEBUG != '')
+			{
+				// if is it valid use it!!!
+				$recipient = MAIL_DEBUG;
+				if ($recipientCC != '') $recipientCC = MAIL_DEBUG;
+				if ($recipientBCC != '') $recipientBCC = MAIL_DEBUG;
+			}
+
+			// Recipients
+			$this->_mail->addAddress($recipient);
+			if (!is_null($recipientCC)) $this->_mail->addCC($recipientCC);
+			if (!is_null($recipientBCC)) $this->_mail->addBCC($recipientBCC);
+
+			// Subject & body & alternative body
+			$this->_mail->Subject = $subject;
+			$this->_mail->Body = $message;
+			if (!isEmptyString($altMessage)) $this->_mail->AltBody = $altMessage;
+
+			// Custom headers
+			if ($bulk) $this->_mail->addCustomHeader('Precedence', 'bulk');
+			if ($autogenerated) $this->_mail->addCustomHeader('Auto-Submitted', 'auto-generated');
+
+			// Embedded images
+			foreach ($embeddedImages as $embeddedImage)
+			{
+				if (!$this->_mail->addEmbeddedImage($embeddedImage['file_name'], $embeddedImage['cid'])) return false;
+			}
+
+			$result = $this->_mail->send();
+
+			// If the email was succesfully sended then increment the counter and checks if it has to _wait until the sending of the next
+			if ($result != false)
+			{
+				$this->_sended++;
+				$this->_wait();
+			}
+
+			// Clear the properties for the next message
+			$this->_mail->clearAddresses();
+			$this->_mail->clearAllRecipients();
+			$this->_mail->clearAttachments();
 		}
-
-		$this->_ci->email->from($from, $alias);
-
-		// Check if the email address of the debug recipient is a valid one
-		$recipient = $to;
-		$recipientCC = $cc;
-		$recipientBCC = $bcc;
-		if (defined('MAIL_DEBUG') && MAIL_DEBUG != '')
+		catch (Exception $e)
 		{
-			// if is it valid use it!!!
-			$recipient = MAIL_DEBUG;
-			if ($recipientCC != '')
-				$recipientCC = MAIL_DEBUG;
-			if ($recipientBCC != '')
-				$recipientBCC = MAIL_DEBUG;
-		}
-
-		$this->_ci->email->to($recipient);
-		if (!is_null($recipientCC)) $this->_ci->email->cc($recipientCC);
-		if (!is_null($recipientBCC)) $this->_ci->email->bcc($recipientBCC);
-		$this->_ci->email->subject($subject);
-		$this->_ci->email->message($message);
-		if (!isEmptyString($altMessage)) $this->_ci->email->set_alt_message($altMessage);
-
-		if($bulk)
-			$this->_ci->email->set_header('Precedence', 'bulk');
-		if($autogenerated)
-			$this->_ci->email->set_header('Auto-Submitted', 'auto-generated');
-
-		// Avoid printing on standard output ugly error messages
-		$result = @$this->_ci->email->send();
-
-		// If the email was succesfully sended then increment the counter
-		// and checks if it has to wait until the sending of the next
-		if ($result)
-		{
-			$this->sended++;
-			$this->wait();
+			error_log($e->errorMessage());
 		}
 
 		return $result;
@@ -176,13 +219,13 @@ class MailLib
 	}
 
 	/**
-	 * Checks if it has to wait until the sending of the next
+	 * Checks if it has to _wait until the sending of the next
 	 */
-	private function wait()
+	private function _wait()
 	{
-		if ($this->sended == $this->email_number_per_time_range)
+		if ($this->_sended == $this->email_number_per_time_range)
 		{
-			$this->sended = 0;
+			$this->_sended = 0;
 			sleep($this->email_time_range); // Wait!!!
 		}
 	}
@@ -190,7 +233,7 @@ class MailLib
 	/**
 	 * Gets an item from the email configuration array
 	 */
-	private function getEmailCfgItem($itemName)
+	private function _getEmailCfgItem($itemName)
 	{
 		return $this->_ci->config->item($itemName, EMAIL_CONFIG_INDEX);
 	}

application/views/system/lrtTest.php

@@ -1,28 +0,0 @@
-<?php
-	$includesArray = array(
-		'title' => 'LRT Test Page',
-		'axios027' => true,
-		'bootstrap5' => true,
-		'fontawesome6' => true,
-		'vue3' => true,
-		'navigationcomponent' => true,
-		'phrases' => array(
-			'global',
-			'ui'
-		),
-		'customJSModules' => array('public/js/apps/LRTTest.js'),
-	);
-
-	$this->load->view('templates/FHC-Header', $includesArray);
-?>
-
-	<div id="main">
-
-		<!-- Navigation component -->
-		<core-navigation-cmpt></core-navigation-cmpt>
-
-		<div id="content"></div>
-	</div>
-
-<?php $this->load->view('templates/FHC-Footer', $includesArray); ?>
-

composer.json

@@ -519,7 +519,8 @@
 		"vuejs/vuedatepicker_js": "7.2.0",
 		"vuejs/vuedatepicker_css": "7.2.0",
 		"vuejs/vuedatepicker_js11": "11.0.1",
-		"vuejs/vuedatepicker_css11": "11.0.1"
+		"vuejs/vuedatepicker_css11": "11.0.1",
+		"phpmailer/phpmailer": "^7.0"
 
 	},
 	"config": {

composer.lock

@@ -4,7 +4,7 @@
         "Read more about it at https://getcomposer.org/doc/01-basic-usage.md#installing-dependencies",
         "This file is @generated automatically"
     ],
-    "content-hash": "869cbc35bd1ba90ab90934fcb41b0f51",
+    "content-hash": "3ec44005c1f5f810f304ad049a2c5c6b",
     "packages": [
         {
             "name": "afarkas/html5shiv",
@@ -897,12 +897,12 @@
             "version": "v6.0.0",
             "source": {
                 "type": "git",
-                "url": "https://github.com/firebase/php-jwt.git",
+                "url": "https://github.com/googleapis/php-jwt.git",
                 "reference": "0541cba75ab108ef901985e68055a92646c73534"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/firebase/php-jwt/zipball/0541cba75ab108ef901985e68055a92646c73534",
+                "url": "https://api.github.com/repos/googleapis/php-jwt/zipball/0541cba75ab108ef901985e68055a92646c73534",
                 "reference": "0541cba75ab108ef901985e68055a92646c73534",
                 "shasum": ""
             },
@@ -944,8 +944,8 @@
                 "php"
             ],
             "support": {
-                "issues": "https://github.com/firebase/php-jwt/issues",
-                "source": "https://github.com/firebase/php-jwt/tree/v6.0.0"
+                "issues": "https://github.com/googleapis/php-jwt/issues",
+                "source": "https://github.com/googleapis/php-jwt/tree/v6.0.0"
             },
             "time": "2022-01-24T15:18:34+00:00"
         },
@@ -1615,17 +1615,99 @@
             "type": "library"
         },
         {
-            "name": "phpseclib/phpseclib",
-            "version": "2.0.48",
+            "name": "phpmailer/phpmailer",
+            "version": "v7.1.1",
             "source": {
                 "type": "git",
-                "url": "https://github.com/phpseclib/phpseclib.git",
-                "reference": "eaa7be704b8b93a6913b69eb7f645a59d7731b61"
+                "url": "https://github.com/PHPMailer/PHPMailer.git",
+                "reference": "1bc1716a507a65e039d4ac9d9adebbbd0d346e15"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/phpseclib/phpseclib/zipball/eaa7be704b8b93a6913b69eb7f645a59d7731b61",
-                "reference": "eaa7be704b8b93a6913b69eb7f645a59d7731b61",
+                "url": "https://api.github.com/repos/PHPMailer/PHPMailer/zipball/1bc1716a507a65e039d4ac9d9adebbbd0d346e15",
+                "reference": "1bc1716a507a65e039d4ac9d9adebbbd0d346e15",
+                "shasum": ""
+            },
+            "require": {
+                "ext-ctype": "*",
+                "ext-filter": "*",
+                "ext-hash": "*",
+                "php": ">=5.5.0"
+            },
+            "require-dev": {
+                "dealerdirect/phpcodesniffer-composer-installer": "^1.0",
+                "doctrine/annotations": "^1.2.6 || ^1.13.3",
+                "php-parallel-lint/php-console-highlighter": "^1.0.0",
+                "php-parallel-lint/php-parallel-lint": "^1.3.2",
+                "phpcompatibility/php-compatibility": "^10.0.0@dev",
+                "squizlabs/php_codesniffer": "^3.13.5",
+                "yoast/phpunit-polyfills": "^1.0.4"
+            },
+            "suggest": {
+                "decomplexity/SendOauth2": "Adapter for using XOAUTH2 authentication",
+                "directorytree/imapengine": "For uploading sent messages via IMAP, see gmail example",
+                "ext-imap": "Needed to support advanced email address parsing according to RFC822",
+                "ext-mbstring": "Needed to send email in multibyte encoding charset or decode encoded addresses",
+                "ext-openssl": "Needed for secure SMTP sending and DKIM signing",
+                "greew/oauth2-azure-provider": "Needed for Microsoft Azure XOAUTH2 authentication",
+                "hayageek/oauth2-yahoo": "Needed for Yahoo XOAUTH2 authentication",
+                "league/oauth2-google": "Needed for Google XOAUTH2 authentication",
+                "psr/log": "For optional PSR-3 debug logging",
+                "symfony/polyfill-mbstring": "To support UTF-8 if the Mbstring PHP extension is not enabled (^1.2)",
+                "thenetworg/oauth2-azure": "Needed for Microsoft XOAUTH2 authentication"
+            },
+            "type": "library",
+            "autoload": {
+                "psr-4": {
+                    "PHPMailer\\PHPMailer\\": "src/"
+                }
+            },
+            "notification-url": "https://packagist.org/downloads/",
+            "license": [
+                "LGPL-2.1-only"
+            ],
+            "authors": [
+                {
+                    "name": "Marcus Bointon",
+                    "email": "phpmailer@synchromedia.co.uk"
+                },
+                {
+                    "name": "Jim Jagielski",
+                    "email": "jimjag@gmail.com"
+                },
+                {
+                    "name": "Andy Prevost",
+                    "email": "codeworxtech@users.sourceforge.net"
+                },
+                {
+                    "name": "Brent R. Matzelle"
+                }
+            ],
+            "description": "PHPMailer is a full-featured email creation and transfer class for PHP",
+            "support": {
+                "issues": "https://github.com/PHPMailer/PHPMailer/issues",
+                "source": "https://github.com/PHPMailer/PHPMailer/tree/v7.1.1"
+            },
+            "funding": [
+                {
+                    "url": "https://github.com/Synchro",
+                    "type": "github"
+                }
+            ],
+            "time": "2026-05-18T08:06:14+00:00"
+        },
+        {
+            "name": "phpseclib/phpseclib",
+            "version": "2.0.55",
+            "source": {
+                "type": "git",
+                "url": "https://github.com/phpseclib/phpseclib.git",
+                "reference": "d73c9e019a895be83b18a2ccccfa7e2b0a648743"
+            },
+            "dist": {
+                "type": "zip",
+                "url": "https://api.github.com/repos/phpseclib/phpseclib/zipball/d73c9e019a895be83b18a2ccccfa7e2b0a648743",
+                "reference": "d73c9e019a895be83b18a2ccccfa7e2b0a648743",
                 "shasum": ""
             },
             "require": {
@@ -1633,7 +1715,7 @@
             },
             "require-dev": {
                 "phing/phing": "~2.7",
-                "phpunit/phpunit": "^4.8.35|^5.7|^6.0|^9.4",
+                "phpunit/phpunit": "^4.8.35|^5.7|^6.0|^8.5|^9.4",
                 "squizlabs/php_codesniffer": "~2.0"
             },
             "suggest": {
@@ -1706,7 +1788,7 @@
             ],
             "support": {
                 "issues": "https://github.com/phpseclib/phpseclib/issues",
-                "source": "https://github.com/phpseclib/phpseclib/tree/2.0.48"
+                "source": "https://github.com/phpseclib/phpseclib/tree/2.0.55"
             },
             "funding": [
                 {
@@ -1722,7 +1804,7 @@
                     "type": "tidelift"
                 }
             ],
-            "time": "2024-12-14T21:03:54+00:00"
+            "time": "2026-06-14T19:53:12+00:00"
         },
         {
             "name": "rmariuzzo/jquery-checkboxes",
@@ -1931,8 +2013,18 @@
             ],
             "support": {
                 "issues": "https://github.com/twigphp/Twig/issues",
-                "source": "https://github.com/twigphp/Twig/tree/1.x"
+                "source": "https://github.com/twigphp/Twig/tree/v1.42.5"
             },
+            "funding": [
+                {
+                    "url": "https://github.com/fabpot",
+                    "type": "github"
+                },
+                {
+                    "url": "https://tidelift.com/funding/github/packagist/twig/twig",
+                    "type": "tidelift"
+                }
+            ],
             "time": "2020-02-11T05:59:23+00:00"
         },
         {
@@ -2726,33 +2818,29 @@
         },
         {
             "name": "phpmetrics/phpmetrics",
-            "version": "v2.8.2",
+            "version": "v2.9.1",
             "source": {
                 "type": "git",
                 "url": "https://github.com/phpmetrics/PhpMetrics.git",
-                "reference": "4b77140a11452e63c7a9b98e0648320bf6710090"
+                "reference": "e2e68ddd1543bc3f44402c383f7bccb62de1ece3"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/phpmetrics/PhpMetrics/zipball/4b77140a11452e63c7a9b98e0648320bf6710090",
-                "reference": "4b77140a11452e63c7a9b98e0648320bf6710090",
+                "url": "https://api.github.com/repos/phpmetrics/PhpMetrics/zipball/e2e68ddd1543bc3f44402c383f7bccb62de1ece3",
+                "reference": "e2e68ddd1543bc3f44402c383f7bccb62de1ece3",
                 "shasum": ""
             },
             "require": {
                 "ext-dom": "*",
                 "ext-tokenizer": "*",
-                "nikic/php-parser": "^3|^4",
-                "php": ">=5.5"
+                "nikic/php-parser": "^3|^4|^5"
             },
             "replace": {
                 "halleck45/php-metrics": "*",
                 "halleck45/phpmetrics": "*"
             },
             "require-dev": {
-                "phpunit/phpunit": "^4.8.36 || ^5.7.27 || ^6.5.14",
-                "sebastian/comparator": ">=1.2.3",
-                "squizlabs/php_codesniffer": "^3.5",
-                "symfony/dom-crawler": "^3.0 || ^4.0 || ^5.0"
+                "phpunit/phpunit": "*"
             },
             "bin": [
                 "bin/phpmetrics"
@@ -2788,9 +2876,15 @@
             ],
             "support": {
                 "issues": "https://github.com/PhpMetrics/PhpMetrics/issues",
-                "source": "https://github.com/phpmetrics/PhpMetrics/tree/v2.8.2"
+                "source": "https://github.com/phpmetrics/PhpMetrics/tree/v2.9.1"
             },
-            "time": "2023-03-08T15:03:36+00:00"
+            "funding": [
+                {
+                    "url": "https://github.com/Halleck45",
+                    "type": "github"
+                }
+            ],
+            "time": "2025-09-25T05:21:02+00:00"
         },
         {
             "name": "phpspec/prophecy",
@@ -3127,7 +3221,6 @@
                 "issues": "https://github.com/sebastianbergmann/php-token-stream/issues",
                 "source": "https://github.com/sebastianbergmann/php-token-stream/tree/master"
             },
-            "abandoned": true,
             "time": "2017-11-27T05:48:46+00:00"
         },
         {
@@ -3963,16 +4056,16 @@
         },
         {
             "name": "sebastian/recursion-context",
-            "version": "3.0.2",
+            "version": "3.0.3",
             "source": {
                 "type": "git",
                 "url": "https://github.com/sebastianbergmann/recursion-context.git",
-                "reference": "9bfd3c6f1f08c026f542032dfb42813544f7d64c"
+                "reference": "8fe7e75986a9d24b4cceae847314035df7703a5a"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/sebastianbergmann/recursion-context/zipball/9bfd3c6f1f08c026f542032dfb42813544f7d64c",
-                "reference": "9bfd3c6f1f08c026f542032dfb42813544f7d64c",
+                "url": "https://api.github.com/repos/sebastianbergmann/recursion-context/zipball/8fe7e75986a9d24b4cceae847314035df7703a5a",
+                "reference": "8fe7e75986a9d24b4cceae847314035df7703a5a",
                 "shasum": ""
             },
             "require": {
@@ -4014,15 +4107,27 @@
             "homepage": "http://www.github.com/sebastianbergmann/recursion-context",
             "support": {
                 "issues": "https://github.com/sebastianbergmann/recursion-context/issues",
-                "source": "https://github.com/sebastianbergmann/recursion-context/tree/3.0.2"
+                "source": "https://github.com/sebastianbergmann/recursion-context/tree/3.0.3"
             },
             "funding": [
                 {
                     "url": "https://github.com/sebastianbergmann",
                     "type": "github"
+                },
+                {
+                    "url": "https://liberapay.com/sebastianbergmann",
+                    "type": "liberapay"
+                },
+                {
+                    "url": "https://thanks.dev/u/gh/sebastianbergmann",
+                    "type": "thanks_dev"
+                },
+                {
+                    "url": "https://tidelift.com/funding/github/packagist/sebastian/recursion-context",
+                    "type": "tidelift"
                 }
             ],
-            "time": "2024-03-01T14:07:30+00:00"
+            "time": "2025-08-10T05:25:53+00:00"
         },
         {
             "name": "sebastian/resource-operations",

include/mail.class.php

@@ -16,9 +16,9 @@
  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
  *
  * Authors: Christian Paminger <christian.paminger@technikum-wien.at>,
- *          Andreas Oesterreicher <andreas.oesterreicher@technikum-wien.at>,
- *          Rudolf Hangl <rudolf.hangl@technikum-wien.at> and
- *			Gerald Simane-Sequens <gerald.simane-sequens@technikum-wien.at>
+ *	  Andreas Oesterreicher <andreas.oesterreicher@technikum-wien.at>,
+ *	  Rudolf Hangl <rudolf.hangl@technikum-wien.at> and
+ *	  Gerald Simane-Sequens <gerald.simane-sequens@technikum-wien.at>
  */
 /**
  * Klasse Mail
@@ -28,6 +28,12 @@
  * Replyto und Attachments
  */
 
+include_once DOC_ROOT . 'vendor/autoload.php';
+
+use PHPMailer\PHPMailer\PHPMailer;
+use PHPMailer\PHPMailer\SMTP;
+use PHPMailer\PHPMailer\Exception;
+
 class mail
 {
 	public $to;
@@ -41,6 +47,8 @@ class mail
 	public $attachments;
 	public $errormsg;
 
+	private $_mail; // PHPMailer instance
+
 	/**
 	 * MAIL - Konstruktor
 	 * $to Empfaenger
@@ -65,6 +73,30 @@ class mail
 	 */
 	public function send()
 	{
+		// PHPMailer configuration
+		try
+		{
+			$this->_mail = new PHPMailer(true);
+			$this->_mail->isSMTP();		 // Send using SMTP
+			$this->_mail->Host = 'localhost';       // Set the SMTP server to send through
+			$this->_mail->Port = 25;		// TCP port to connect to; use 587 if you have set `SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS`
+			$this->_mail->SMTPAuth = false;	 // Enable SMTP authentication
+			$this->_mail->Username = '';	    // SMTP username
+			$this->_mail->Password = '';	    // SMTP password
+			$this->_mail->SMTPSecure = '';	  // Enable implicit TLS encryption
+			$this->_mail->Timeout = 1;	      // set the timeout (seconds)
+			$this->_mail->SMTPKeepAlive = false;    // Persistent SMTP connection
+			$this->_mail->Priority = 3;	     // 1 = High, 3 = Normal, 5 = low. When null, the header is not set at all.
+			$this->_mail->WordWrap = 76;
+			$this->_mail->isHTML(true);	     // html or text
+			$this->_mail->SMTPDebug = 0;	    // Disable debugging      
+			$this->_mail->CharSet = 'UTF-8';
+		}
+		catch(Exception $e)
+		{
+			return false;
+		}
+
 		//wenn MAIL_DEBUG gesetzt ist dann alles an diese Adresse schicken
 		if(MAIL_DEBUG!='')
 		{
@@ -82,68 +114,38 @@ class mail
 			$this->sender = MAIL_FROM;
 
 		// Header
-		$header = '';
-  		$header .= "From: {$this->sender}".$eol;
+		$this->_mail->setFrom($this->sender);
 
   		if (!empty($this->CC_recievers))
-			$header .= "CC: {$this->CC_recievers}".$eol;
+			$this->_mail->addCC($this->CC_recievers);
 		if (!empty($this->BCC_recievers))
-			$header .= "BCC: {$this->BCC_recievers}".$eol;
+			$this->_mail->addBCC($this->BCC_recievers);
 		if (!empty($this->replyTo))
-			$header .= "Reply-To: {$this->replyTo}".$eol;
-		if (!empty($this->replyTo))
-			$header .= "Return-Path: {$this->replyTo}".$eol;
-
-		$header .= 'X-Mailer: FHComplete V1'.$eol;
-	  	$header .= 'Mime-Version: 1.0'.$eol;
-		$header .= 'Precedence: bulk'.$eol;
-		$header .= 'Auto-Submitted: auto-generated'.$eol;
-		$header .= "Content-Type: multipart/related; boundary=\"$mime_boundary_mixed\"".$eol;
-		$header .= "Content-Transfer-Encoding: 8bit".$eol;
-
-		// Body
-		$mailbody = "";
-		$mailbody .= $eol;
-		$mailbody .= "--$mime_boundary_mixed".$eol;
-		$mailbody .= "Content-Type: multipart/alternative; boundary=\"$mime_boundary_alternative\"".$eol;
-		$mailbody .= $eol;
-		$mailbody .= "--$mime_boundary_alternative".$eol;
-		$mailbody .= "Content-Type: text/plain; charset={$this->textContent[1]}".$eol;
-		$mailbody .= "Content-Transfer-Encoding: {$this->textContent[2]}".$eol;
-		$mailbody .= $eol;
-		$mailbody .= $this->textContent[0];
-		$mailbody .= $eol;
-		$mailbody .= $eol;
-
-		if (!empty($this->htmlContent[0]))
 		{
-			$mailbody .= "--$mime_boundary_alternative".$eol;
-			$mailbody .= "Content-Type: text/html; charset={$this->htmlContent[1]}".$eol;
-			$mailbody .= "Content-Transfer-Encoding: {$this->htmlContent[2]}".$eol;
-			$mailbody .= $eol;
-			$mailbody .= $this->htmlContent[0];
-			$mailbody .= $eol;
-			$mailbody .= $eol;
+			$this->_mail->addReplyTo($this->replyTo);
+			$this->_mail->addCustomHeader('Return-Path', $this->replyTo);
 		}
-		$mailbody .= "--{$mime_boundary_alternative}--".$eol;
-		$mailbody .= $eol;
-		$mailbody .= "--$mime_boundary_mixed";
+
+		$this->_mail->addCustomHeader('X-Mailer', 'FHComplete V1');
+		$this->_mail->addCustomHeader('Mime-Version', '1.0');
+		$this->_mail->addCustomHeader('Precedence', 'bulk');
+		$this->_mail->addCustomHeader('Auto-Submitted', 'auto-generated');
+
+		$this->_mail->Body = $this->htmlContent[0];
+		$this->_mail->AltBody = $this->textContent[0];
 
 		// Attachments Plain
 		if (is_array($this->attachmentsplain) && (count($this->attachmentsplain) > 0))
 		{
 			foreach ($this->attachmentsplain as $attachment)
 			{
-				$dispo = 'attachment';
-				$mailbody .= $eol;
-				$mailbody .= "Content-Disposition: $dispo; filename={$attachment[2]}".$eol;
-				$mailbody .= "Content-Type: {$attachment[1]}; name={$attachment[2]}".$eol;
-
-				$mailbody .= 'Content-Transfer-Encoding: '.$attachment[3].$eol;
-				$mailbody .= $eol;
-				$mailbody .= $attachment[0];
-				$mailbody .= $eol;
-				$mailbody .= "--$mime_boundary_mixed";
+				$this->_mail->addStringAttachment(
+					$attachment[0], // File content
+					$attachment[2], // Name
+					$attachment[3], // Encoding
+					$attachment[1], // Type
+					'attachment'	// Disposition
+				);
 			}
 		}
 
@@ -152,31 +154,23 @@ class mail
 		{
 			foreach ($this->attachments as $attachment)
 			{
-				$dispo = empty($attachment[3]) ? 'attachment' : 'inline';
-				$mailbody .= $eol;
-				$mailbody .= "Content-Disposition: $dispo; filename={$attachment[2]}".$eol;
-				$mailbody .= "Content-Type: {$attachment[1]}; name={$attachment[2]}".$eol;
-				if (!empty($attachment[3]))
-				{
-					$mailbody .= "Content-ID: <{$attachment[3]}>".$eol;
-				}
-				$mailbody .= 'Content-Transfer-Encoding: base64'.$eol;
-				$mailbody .= $eol;
-				$mailbody .= $attachment[0];
-				$mailbody .= $eol;
-				$mailbody .= "--$mime_boundary_mixed";
+				$this->_mail->addStringEmbeddedImage(
+					$attachment[0], // File content
+					$attachment[3], // Content ID
+					$attachment[2], // Content name
+					PHPMailer::ENCODING_BASE64, // Encoding
+					$attachment[1], // Type
+					empty($attachment[3]) ? 'attachment' : 'inline'	// Disposition
+				);
 			}
 		}
-		$mailbody .= "--".$eol;
 
 		// Subject Encoding setzen
-		$subject = "=?UTF-8?B?".base64_encode($this->subject)."?=";
+		$this->_mail->Subject = $this->subject;
+		$this->_mail->addAddress($this->to);
 
 		// Senden
-		if(mail($this->to, $subject, $mailbody, $header))
-			return true;
-		else
-			return false;
+		return $this->_mail->send();
 	}
 
 	/**

public/js/api/LRTTEst.js

@@ -1,9 +0,0 @@
-export default {
-	addNew1MinLrt()
-	{
-		return {
-			method: 'post',
-			url: '/system/LRTTest/lrt1min'
-		};
-	},
-}

public/js/apps/LRTTest.js

@@ -1,48 +0,0 @@
-/**
- * Copyright (C) 2022 fhcomplete.org
- *
- * This program is free software: you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation, either version 3 of the License, or
- * (at your option) any later version.
- *
- * This program is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- * GNU General Public License for more details.
- *
- * You should have received a copy of the GNU General Public License
- * along with this program.  If not, see <https://www.gnu.org/licenses/>.
- */
-
-import PluginsPhrasen from '../plugins/Phrasen.js';
-import {CoreNavigationCmpt} from '../components/navigation/Navigation.js'
-
-import ApiLrt from "../api/LRTTEst.js";
-
-const lrtTestApp = Vue.createApp({
-	data: function() {
-		return {
-		};
-	},
-	components: {
-		CoreNavigationCmpt,
-	},
-	methods: {
-		addNew1MinLrt() {
-			this.$api.call(ApiLrt.addNew1MinLrt())
-			.then(result => {
-				this.dropdowns.studiensemester_array = result.data;
-			})
-			.catch(this.$fhcAlert.handleSystemError);
-		}
-	},
-	template: `
-		<button type="button" class="btn btn-primary" @click="addNew1MinLrt()">Add a 1 min LRT</button>
-	`
-});
-
-FhcApps.makeExtendable(lrtTestApp);
-
-lrtTestApp.use(PluginsPhrasen).mount('#main');
-

system/dbupdate_3.4.php

@@ -94,7 +94,6 @@ require_once('dbupdate_3.4/71399_dashboard_update_widget_paths.php');
 require_once('dbupdate_3.4/71645_studvw_messagetab_ladezeit.php');
 require_once('dbupdate_3.4/71566_studienordnungsdokument_neuer_organisationseinheitstyp_programm.php');
 require_once('dbupdate_3.4/70376_lohnguide.php');
-require_once('dbupdate_3.4/76203_Asynchrone_Tasks.php');
 require_once('dbupdate_3.4/75888_reihungstest_mehrfachdurchfuehrung.php');
 require_once('dbupdate_3.4/76150_perm_other_lv_plan.php');
 require_once('dbupdate_3.4/68957_dashboard_bookmark_neue_Spalte_sort.php');
@@ -434,7 +433,7 @@ $tabellen=array(
 	"system.tbl_log" => array("log_id","person_id","zeitpunkt","app","oe_kurzbz","logtype_kurzbz","logdata","insertvon","taetigkeit_kurzbz"),
 	"system.tbl_logtype" => array("logtype_kurzbz", "data_schema"),
 	"system.tbl_filters" => array("filter_id","app","dataset_name","filter_kurzbz","person_id","description","sort","default_filter","filter","oe_kurzbz","statistik_kurzbz"),
-	"system.tbl_jobsqueue" => array("jobid", "type", "creationtime", "status", "input", "output", "starttime", "endtime", "insertvon", "insertamum", "pid", "uid", "progress"),
+	"system.tbl_jobsqueue" => array("jobid", "type", "creationtime", "status", "input", "output", "starttime", "endtime", "insertvon", "insertamum"),
 	"system.tbl_jobstatuses" => array("status"),
 	"system.tbl_jobtriggers" => array("type", "status", "following_type"),
 	"system.tbl_jobtypes" => array("type", "description"),

system/dbupdate_3.4/76203_Asynchrone_Tasks.php

@@ -1,59 +0,0 @@
-<?php
-
-// Add column pid to system.tbl_jobsqueue
-if (!$result = @$db->db_query('SELECT "pid" FROM "system"."tbl_jobsqueue" LIMIT 1'))
-{
-	$qry = 'ALTER TABLE "system"."tbl_jobsqueue" ADD "pid" INT NULL DEFAULT NULL;';
-	if (!$db->db_query($qry))
-		echo '<strong>system.tbl_jobsqueue: '.$db->db_last_error().'</strong><br>';
-	else
-		echo '<br>Added column pid to table system.tbl_jobsqueue';
-}
-
-// Add column uid to system.tbl_jobsqueue
-if (!$result = @$db->db_query('SELECT "uid" FROM "system"."tbl_jobsqueue" LIMIT 1'))
-{
-	$qry = 'ALTER TABLE "system"."tbl_jobsqueue" ADD "uid" VARCHAR(32) NULL DEFAULT NULL;';
-	if (!$db->db_query($qry))
-		echo '<strong>system.tbl_jobsqueue: '.$db->db_last_error().'</strong><br>';
-	else
-		echo '<br>Added column uid to table system.tbl_jobsqueue';
-}
-
-// Add column progress to system.tbl_jobsqueue
-if (!$result = @$db->db_query('SELECT "progress" FROM "system"."tbl_jobsqueue" LIMIT 1'))
-{
-	$qry = 'ALTER TABLE "system"."tbl_jobsqueue" ADD "progress" NUMERIC(2,1) NULL DEFAULT 0;';
-	if (!$db->db_query($qry))
-		echo '<strong>system.tbl_jobsqueue: '.$db->db_last_error().'</strong><br>';
-	else
-		echo '<br>Added column progress to table system.tbl_jobsqueue';
-}
-
-// Add foreign key fk_jobsqueue_benutzer_uid on system.tbl_jobsqueue.uid with public.tbl_benutzer.uid
-if ($result = $db->db_query("SELECT conname FROM pg_constraint WHERE conname = 'fk_jobsqueue_benutzer_uid'"))
-{
-	if ($db->db_num_rows($result) == 0)
-	{
-		$qry = 'ALTER TABLE "system"."tbl_jobsqueue" ADD CONSTRAINT "fk_jobsqueue_benutzer_uid" FOREIGN KEY ("uid") REFERENCES "public"."tbl_benutzer" ("uid") ON DELETE RESTRICT ON UPDATE CASCADE;';
-		if (!$db->db_query($qry))
-			echo '<strong>system.tbl_jobsqueue: '.$db->db_last_error().'</strong><br>';
-		else
-			echo '<br>Created foreign key fk_jobsqueue_benutzer_uid';
-	}
-}
-
-// Add new webservice type in system.tbl_webservicetyp
-if ($result = @$db->db_query("SELECT 1 FROM system.tbl_webservicetyp WHERE webservicetyp_kurzbz = 'lrt';"))
-{
-	if ($db->db_num_rows($result) == 0)
-	{
-		$qry = "INSERT INTO system.tbl_webservicetyp(webservicetyp_kurzbz, beschreibung) VALUES('lrt', 'Long Run Task');";
-
-		if (!$db->db_query($qry))
-			echo '<strong>system.tbl_webservicetyp '.$db->db_last_error().'</strong><br>';
-		else
-			echo ' system.tbl_webservicetyp: Added webservice type "lrt"<br>';
-	}
-}
-

system/filtersupdate.php

@@ -1638,84 +1638,6 @@ $filters = array(
 			}',
 		'oe_kurzbz' => null,
 	),
-	array(
-		'app' => 'core',
-		'dataset_name' => 'logs',
-		'filter_kurzbz' => 'lrts24hours',
-		'description' => '{Last 24 hours LRTs logs}',
-		'sort' => 2,
-		'default_filter' => false,
-		'filter' => '
-			{
-				"name": "All Long Run Tasks logs from the last 24 hours",
-				"columns": [
-					{"name": "RequestId"},
-					{"name": "ExecutionTime"},
-					{"name": "ExecutedBy"},
-					{"name": "Description"},
-					{"name": "Data"}
-				],
-				"filters": [
-					{
-						"name": "WebserviceType",
-						"operation": "contains",
-						"condition": "job"
-					},
-					{
-						"name": "RequestId",
-						"operation": "contains",
-						"condition": "LRT"
-					},
-					{
-						"name": "ExecutionTime",
-						"operation": "lt",
-						"condition": "24",
-						"option": "hours"
-					}
-				]
-			}
-		',
-		'oe_kurzbz' => null,
-	),
-	array(
-		'app' => 'core',
-		'dataset_name' => 'logs',
-		'filter_kurzbz' => 'lrts48hours',
-		'description' => '{Last 48 hours LRTs logs}',
-		'sort' => 2,
-		'default_filter' => false,
-		'filter' => '
-			{
-				"name": "All Long Run Tasks logs from the last 48 hours",
-				"columns": [
-					{"name": "RequestId"},
-					{"name": "ExecutionTime"},
-					{"name": "ExecutedBy"},
-					{"name": "Description"},
-					{"name": "Data"}
-				],
-				"filters": [
-					{
-						"name": "WebserviceType",
-						"operation": "contains",
-						"condition": "job"
-					},
-					{
-						"name": "RequestId",
-						"operation": "contains",
-						"condition": "LRT"
-					},
-					{
-						"name": "ExecutionTime",
-						"operation": "lt",
-						"condition": "48",
-						"option": "hours"
-					}
-				]
-			}
-		',
-		'oe_kurzbz' => null,
-	),
 );
 
 // Loop through the filters array