Files
fmgapp/app/models/admin/SmtpServer.php

324 lines
7.2 KiB
PHP
Executable File
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
<?php declare(strict_types=1); namespace IR\App\Models\Admin; if (!defined('IR_START')) exit('<pre>No direct script access allowed</pre>');
/**
* @framework Wevads Framework
* @version 1.0
* @author Amine Idrissi <contact@iresponse.tech>
* @date 2019
* @name SmtpServer.php
*/
# orm
use IR\Orm\ActiveRecord as ActiveRecord;
# helpers
use IR\App\Helpers\AuditLog as AuditLog;
use IR\App\Helpers\Authentication as Authentication;
use IR\App\Helpers\Permissions as Permissions;
# utilities
use IR\Utils\Types\Objects as Objects;
/**
* @name SmtpServer
* @description SmtpServer Model
*/
class SmtpServer extends ActiveRecord
{
/**
* @database
* @readwrite
*/
protected $_databaseKey = 'system';
/**
* @schema
* @readwrite
*/
protected $_schema = 'admin';
/**
* @table
* @readwrite
*/
protected $_table = 'smtp_servers';
# columns
/**
* @column
* @readwrite
* @primary
* @indexed
* @autoincrement
* @type integer
* @nullable false
* @length
*/
protected $_id;
/**
* @column
* @readwrite
* @indexed
* @type integer
* @nullable false
* @length
*/
protected $_provider_id;
/**
* @column
* @readwrite
* @type text
* @nullable false
* @length 200
*/
protected $_provider_name;
/**
* @column
* @readwrite
* @indexed
* @type text
* @nullable false
* @length 20
*/
protected $_status;
/**
* @column
* @readwrite
* @type text
* @nullable false
* @length 200
*/
protected $_name;
/**
* @column
* @readwrite
* @type text
* @nullable true
* @length 200
*/
protected $_host_name;
/**
* @column
* @readwrite
* @type text
* @nullable false
* @length 10
*/
protected $_encryption_type;
/**
* @column
* @readwrite
* @type integer
* @nullable false
* @length
*/
protected $_smtp_port;
/**
* @column
* @readwrite
* @type integer
* @nullable false
* @length
*/
protected $_users_count;
/**
* @column
* @readwrite
* @type date
* @nullable false
* @length
*/
protected $_expiration_date;
/**
* @column
* @readwrite
* @type text
* @nullable false
* @length 200
*/
protected $_created_by;
/**
* @column
* @readwrite
* @type text
* @nullable true
* @length 200
*/
protected $_last_updated_by;
/**
* @column
* @readwrite
* @type date
* @nullable false
* @length
*/
protected $_created_date;
/**
* @column
* @readwrite
* @type date
* @nullable true
* @length
*/
protected $_last_updated_date;
# overrided
/**
* @name first
* @description returns the first matched record
* @access static
* @param integer $format
* @param array $where
* @param array $fields
* @param string $order
* @param string $direction
* @return mixed
*/
public static function first(int $format = ActiveRecord::FETCH_ARRAY, array $where = [], array $fields = ["*"],string $order = '', string $direction = 'ASC')
{
$user = Authentication::getAuthenticatedUser();
if($user->getMasterAccess() != 'Enabled')
{
Permissions::modelTeamAuthsFilter(__CLASS__,$user,$where);
}
return parent::first($format,$where, $fields, $order, $direction);
}
/**
* @name all
* @description creates a query, taking into account the various filters and flags, to return all matching records.
* @access static
* @param integer $format
* @param array $where
* @param array $fields
* @param string $order
* @param string $direction
* @param integer $limit
* @param integer $offset
* @return mixed
*/
public static function all(int $format = ActiveRecord::FETCH_ARRAY, array $where = [], array $fields = ["*"], string $order = '', string $direction = 'ASC', int $limit = 0, int $offset = 0)
{
$user = Authentication::getAuthenticatedUser();
if($user->getMasterAccess() != 'Enabled')
{
Permissions::modelTeamAuthsFilter(__CLASS__,$user,$where);
}
return parent::all($format, $where, $fields, $order, $direction, $limit, $offset);
}
/**
* @name load
* @description loads a record if the primary columns value has been provided
* @access public
* @return
*/
public function load($primayValue = null)
{
$user = Authentication::getAuthenticatedUser();
if($user->getMasterAccess() != 'Enabled')
{
$where = [];
$teamBasedFilterIds = Permissions::modelTeamAuthsFilter(__CLASS__,$user,$where);
$hasAdminRole = Permissions::hasAdminBasedRole($user);
if($hasAdminRole == false)
{
if($primayValue == null)
{
if(in_array($this->_id,$teamBasedFilterIds))
{
parent::load();
}
}
else
{
if(in_array($primayValue,$teamBasedFilterIds))
{
parent::load($primayValue);
}
}
}
else
{
parent::load($primayValue);
}
}
else
{
parent::load($primayValue);
}
}
/**
* @name insert
* @description creates a record base on the primary key
* @access public
* @return integer
* @throws DatabaseException
*/
public function insert() : int
{
$this->_id = parent::insert();
# register audit log
AuditLog::registerLog($this->_id,$this->_name,Objects::getInstance()->getName($this),'Insert');
return $this->_id;
}
/**
* @name insert
* @description creates a record base on the primary key
* @access public
* @return integer
* @throws DatabaseException
*/
public function update() : int
{
# register audit log
AuditLog::registerLog($this->_id,$this->_name,Objects::getInstance()->getName($this),'Update');
return parent::update();
}
/**
* @name delete
* @description creates a query object, only if the primary key property value is not empty, and executes the querys delete() method.
* @access public
* @return integer
*/
public function delete() : int
{
# register audit log
AuditLog::registerLog($this->_id,$this->_name,Objects::getInstance()->getName($this),'Delete');
# delete server users if any
SmtpUser::deleteWhere('smtp_server_id = ?',[$this->_id]);
# delete record
return parent::delete();
}
}