backend/models/ImportersFiles.php

<?php
namespace backend\models;
use common\components\CustomVarDamp;
use Yii;
/**
 * This is the model class for table "{{%importer_files}}".
 *
 * @property integer $id
 * @property string $importer_id
 * @property string $upload_time
 * @property string $time_start
 * @property string $time_end
 */
class ImportersFiles extends \yii\db\ActiveRecord
{
    const FILES_PREFIX = '~!~';
    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['importer_id'], 'required'],
            [['importer_id'], 'integer'],
            [['upload_time', 'time_start', 'time_end'], 'safe']
        ];
    }
    public function getImporter ()
    {
         return $this->hasOne(Importers::className(), ['id' => 'importer_id'])->one()->name;
    }
    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => Yii::t('app', 'ID'),
            'importer_id' => Yii::t('app', 'Importers ID'),
            'upload_time' => Yii::t('app', 'Upload Time'),
            'time_start' => Yii::t('app', 'Time Start'),
            'time_end' => Yii::t('app', 'Time End'),
        ];
    }
    public static function getIdFromMailBox($hostname, $mailbox){
        $words = explode(" ",str_replace( array($hostname,"!"),"",imap_utf7_decode($mailbox)) );
        return (int)preg_replace("/[^A-Z0-9]+/","", strtoupper($words[0]));
    }
    public static function getIdFromFileName($file_name){
        $words = explode( self::FILES_PREFIX, basename( $file_name ) );
        return  (int)$words[0];
    }
}