File modules/Mail/Models/Server.php | Afterlogic Aurora Corporate 9 API

* @method static \Illuminate\Database\Eloquent\Builder|Server findOrFail(int|string $id, mixed $id, Closure|array|string $columns = ['*'], Closure $callback = null)

56:

* @method static \Illuminate\Database\Eloquent\Builder|Server first(array|string $columns = ['*'])

57:

* @method static \Illuminate\Database\Eloquent\Builder|Server firstWhere(Closure|string|array|\Illuminate\Database\Query\Expression $column, mixed $operator = null, mixed $value = null, string $boolean = 'and')

58:

* @method static \Illuminate\Database\Eloquent\Builder|Server newModelQuery()

59:

* @method static \Illuminate\Database\Eloquent\Builder|Server newQuery()

60:

* @method static \Illuminate\Database\Eloquent\Builder|Server query()

61:

* @method static \Illuminate\Database\Eloquent\Builder|Server leftJoin(string $table, \Closure|string $first, string|null $operator = null, string|null $second = null)

62:

* @method static \Illuminate\Database\Eloquent\Builder|Server where(Closure|string|array|\Illuminate\Database\Query\Expression $column, mixed $operator = null, mixed $value = null, string $boolean = 'and')

63:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereIn(string $column, mixed $values, string $boolean = 'and', bool $not = false)

64:

* @method static \Illuminate\Database\Eloquent\Builder|Server orWhere(\Closure|array|string|\Illuminate\Database\Query\Expression $column, mixed $operator = null, mixed $value = null)

65:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereCreatedAt($value)

66:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereDomains($value)

67:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereEnableSieve($value)

68:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereEnableThreading($value)

69:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereExternalAccessImapAlterPort($value)

70:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereExternalAccessImapPort($value)

71:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereExternalAccessImapServer($value)

72:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereExternalAccessImapUseSsl($value)

73:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereExternalAccessPop3AlterPort($value)

74:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereExternalAccessPop3Port($value)

75:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereExternalAccessPop3Server($value)

76:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereExternalAccessPop3UseSsl($value)

77:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereExternalAccessSmtpAlterPort($value)

78:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereExternalAccessSmtpPort($value)

79:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereExternalAccessSmtpServer($value)

80:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereExternalAccessSmtpUseSsl($value)

81:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereId($value)

82:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereIncomingPort($value)

83:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereIncomingServer($value)

84:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereIncomingUseSsl($value)

85:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereName($value)

86:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereOAuthEnable($value)

87:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereOAuthIconUrl($value)

88:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereOAuthName($value)

89:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereOAuthType($value)

90:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereOutgoingPort($value)

91:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereOutgoingServer($value)

92:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereOutgoingUseSsl($value)

93:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereOwnerType($value)

94:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereSetExternalAccessServers($value)

95:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereSievePort($value)

96:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereSmtpAuthType($value)

97:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereSmtpLogin($value)

98:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereSmtpPassword($value)

99:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereTenantId($value)

100:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereUpdatedAt($value)

101:

* @method static \Illuminate\Database\Eloquent\Builder|Server whereUseFullEmailAddressAsLogin($value)

102:

* @mixin \Eloquent

103:

*/

104:

class Server extends Model

105:

{

106:

protected $table = 'mail_servers';

107:

108:

protected $foreignModel = Tenant::class;

109:

protected $foreignModelIdColumn = 'TenantId'; // Column that refers to an external table

110:

111:

/**

112:

* The attributes that are mass assignable.

*

* @var array

*/

protected $fillable = [

'Id',

'TenantId',

'Name',

'IncomingServer',

'IncomingPort',

'IncomingUseSsl',

'OutgoingServer',

'OutgoingPort',

'OutgoingUseSsl',

'SmtpAuthType',

'SmtpLogin',

'SmtpPassword',

'OwnerType',

'Domains',

'EnableSieve',

'SievePort',

'EnableThreading',

'UseFullEmailAddressAsLogin',

135:

136:

'SetExternalAccessServers',

137:

'ExternalAccessImapServer',

138:

'ExternalAccessImapPort',

139:

'ExternalAccessImapAlterPort',

140:

'ExternalAccessImapUseSsl',

141:

'ExternalAccessPop3Server',

142:

'ExternalAccessPop3Port',

143:

'ExternalAccessPop3AlterPort',

144:

'ExternalAccessPop3UseSsl',

145:

'ExternalAccessSmtpServer',

146:

'ExternalAccessSmtpPort',

147:

'ExternalAccessSmtpAlterPort',

148:

'ExternalAccessSmtpUseSsl',

'OAuthEnable',

'OAuthName',

'OAuthType',

'OAuthIconUrl',

];

/**

* The attributes that should be hidden for arrays.

*

* @var array

*/

protected $hidden = [

];

protected $casts = [

'Properties' => 'array',

166:

'IncomingUseSsl' => 'boolean',

167:

'OutgoingUseSsl' => 'boolean',

168:

'EnableSieve' => 'boolean',

169:

'EnableThreading' => 'boolean',

170:

'UseFullEmailAddressAsLogin' => 'boolean',

171:

'SetExternalAccessServers' => 'boolean',

172:

'OAuthEnable' => 'boolean',

173:

'SmtpPassword' => \Aurora\System\Casts\Encrypt::class,

174:

'ExternalAccessImapUseSsl' => 'boolean',

175:

'ExternalAccessPop3UseSsl' => 'boolean',

176:

'ExternalAccessSmtpUseSsl' => 'boolean',

177:

];

178:

179:

protected $attributes = [

180:

];

181:

182:

protected $appends = [

'EntityId',

'ServerId',

];

public function getServerIdAttribute()

{

return $this->Id;

}

public function MailAccounts()

193:

{

194:

return $this->hasMany(MailAccount::class, 'ServerId', 'Id');

195:

}

196:

197:

public function toResponseArray()

198:

{

199:

$aResponse = parent::toResponseArray();

200:

$aResponse['ServerId'] = $this->Id;

201:

202:

$aArgs = [];

203:

\Aurora\System\Api::GetModule('Mail')->broadcastEvent(

204:

'ServerToResponseArray',

$aArgs,

$aResponse

);

return $aResponse;

}

public function getOrphanIds()

212:

{

213:

if (!$this->foreignModel || !$this->foreignModelIdColumn) {

214:

return ['status' => -1, 'message' => 'Foreign field doesn\'t exist'];

215:

}

216:

$tableName = $this->getTable();

217:

$foreignObject = new $this->foreignModel();

218:

$foreignTable = $foreignObject->getTable();

219:

$foreignPK = $foreignObject->primaryKey;

220:

221:

// DB::enableQueryLog();

222:

$oAccount = new MailAccount();

223:

$accountTable = $oAccount->getTable();

224:

225:

$serversWithoutAccount = self::leftJoin($accountTable, "$accountTable.ServerId", '=', "$tableName.$this->primaryKey")->where('OwnerType', '=', 'account')->whereNull("$accountTable.Id")->groupBy("$tableName.$this->primaryKey")->pluck("$tableName.$this->primaryKey")->all();

226:

$orphanIds = self::where('OwnerType', '=', 'tenant')->pluck($this->primaryKey)->diff(

227:

self::leftJoin($foreignTable, "$tableName.$this->foreignModelIdColumn", '=', "$foreignTable.$foreignPK")->whereNotNull("$foreignTable.$foreignPK")->pluck("$tableName.$this->primaryKey")

228:

)->union($serversWithoutAccount)->all();

229:

$message = $orphanIds ? "$tableName table has orphans." : "Orphans were not found.";

230:

$oResult = ['status' => $orphanIds ? 1 : 0, 'message' => $message, 'orphansIds' => $orphanIds];

231:

// dd(DB::getQueryLog());

return $oResult;

}

}

Namespaces

Classes