|
Server : Apache System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64 User : rainic ( 1014) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/akaindir/public_html/crm/modules/MailManager/models/ |
Upload File : |
<?php
/*+**********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.1
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
************************************************************************************/
class MailManager_Mailbox_Model {
protected $mServer;
public $mUsername;
protected $mPassword;
protected $mProtocol = 'IMAP4';
protected $mSSLType = 'ssl';
protected $mCertValidate = 'novalidate-cert';
protected $mRefreshTimeOut;
protected $mId;
protected $mServerName;
protected $mFolder;
public function exists() {
return !empty($this->mId);
}
public function decrypt($value) {
require_once('include/utils/encryption.php');
$e = new Encryption();
return $e->decrypt($value);
}
public function encrypt($value) {
require_once('include/utils/encryption.php');
$e = new Encryption();
return $e->encrypt($value);
}
public function server() {
return $this->mServer;
}
public function setServer($server) {
$this->mServer = trim($server);
}
public function serverName() {
return $this->mServerName;
}
public function username() {
return $this->mUsername;
}
public function setUsername($username) {
$this->mUsername = trim($username);
}
public function password($decrypt=true) {
if ($decrypt) return $this->decrypt($this->mPassword);
return $this->mPassword;
}
public function setPassword($password) {
$this->mPassword = $this->encrypt(trim($password));
}
public function protocol() {
return $this->mProtocol;
}
public function setProtocol($protocol) {
$this->mProtocol = trim($protocol);
}
public function ssltype() {
if (strcasecmp($this->mSSLType, 'ssl') === 0) {
return $this->mSSLType;
}
return $this->mSSLType;
}
public function setSSLType($ssltype) {
$this->mSSLType = trim($ssltype);
}
public function certvalidate() {
return $this->mCertValidate;
}
public function setCertValidate($certvalidate) {
$this->mCertValidate = trim($certvalidate);
}
public function setRefreshTimeOut($value) {
$this->mRefreshTimeOut = $value;
}
public function refreshTimeOut() {
return $this->mRefreshTimeOut;
}
public function setFolder($value) {
$this->mFolder = $value;
}
public function folder() {
return decode_html($this->mFolder);
}
public function delete() {
$db = PearDatabase::getInstance();
$currentUserModel = Users_Record_Model::getCurrentUserModel();
$db->pquery("DELETE FROM vtiger_mail_accounts WHERE user_id = ? AND account_id = ?", array($currentUserModel->getId(), $this->mId));
}
public function save() {
$db = PearDatabase::getInstance();
$currentUserModel = Users_Record_Model::getCurrentUserModel();
$account_id = 1;
$maxresult = $db->pquery("SELECT max(account_id) as max_account_id FROM vtiger_mail_accounts", array());
if ($db->num_rows($maxresult)) $account_id += intval($db->query_result($maxresult, 0, 'max_account_id'));
$isUpdate = !empty($this->mId);
$sql = "";
$parameters = array($this->username(), $this->server(), $this->username(), $this->password(false), $this->protocol(), $this->ssltype(), $this->certvalidate(), $this->refreshTimeOut(),$this->folder(), $currentUserModel->getId());
if ($isUpdate) {
$sql = "UPDATE vtiger_mail_accounts SET display_name=?, mail_servername=?, mail_username=?, mail_password=?, mail_protocol=?, ssltype=?, sslmeth=?, box_refresh=?, sent_folder=? WHERE user_id=? AND account_id=?";
$parameters[] = $this->mId;
} else {
$sql = "INSERT INTO vtiger_mail_accounts(display_name, mail_servername, mail_username, mail_password, mail_protocol, ssltype, sslmeth, box_refresh,sent_folder, user_id, mails_per_page, account_name, status, set_default, account_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
$parameters[] = vglobal('list_max_entries_per_page'); // Number of emails per page
$parameters[] = $this->username();
$parameters[] = 1; // Status
$parameters[] = '0'; // Set Default
$parameters[] = $account_id;
}
$db->pquery($sql, $parameters);
if (!$isUpdate) {
$this->mId = $account_id;
}
}
public static function activeInstance($currentUserModel = false) {
$db = PearDatabase::getInstance();
if(!$currentUserModel)
$currentUserModel = Users_Record_Model::getCurrentUserModel();
$instance = new MailManager_Mailbox_Model();
$result = $db->pquery("SELECT * FROM vtiger_mail_accounts WHERE user_id=? AND status=1 AND set_default=0", array($currentUserModel->getId()));
if ($db->num_rows($result)) {
$instance->mServer = trim($db->query_result($result, 0, 'mail_servername'));
$instance->mUsername = trim($db->query_result($result, 0, 'mail_username'));
$instance->mPassword = trim($db->query_result($result, 0, 'mail_password'));
$instance->mProtocol = trim($db->query_result($result, 0, 'mail_protocol'));
$instance->mSSLType = trim($db->query_result($result, 0, 'ssltype'));
$instance->mCertValidate = trim($db->query_result($result, 0, 'sslmeth'));
$instance->mId = trim($db->query_result($result, 0, 'account_id'));
$instance->mRefreshTimeOut = trim($db->query_result($result, 0, 'box_refresh'));
$instance->mFolder = trim($db->query_result($result, 0, 'sent_folder'));
$instance->mServerName = self::setServerName($instance->mServer);
}
return $instance;
}
public static function setServerName($mServer) {
if($mServer == 'imap.gmail.com') {
$mServerName = 'gmail';
} else if($mServer == 'imap.mail.yahoo.com') {
$mServerName = 'yahoo';
} else if($mServer == 'mail.messagingengine.com') {
$mServerName = 'fastmail';
} else {
$mServerName = 'other';
}
return $mServerName;
}
}
?>