<?php

namespace common\models;

use Yii;

/**
 * This is the model class for table "job".
 *
 * @property integer $job_id
 * @property string $name
 * @property string $link
 * @property string $date_start
 * @property string $date_end
 * @property string $position
 * @property integer $user_id
 * @property integer $total_count
 * @property integer $complete_count
 * @property integer $current
 */
class Job extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'job';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['name'], 'required'],
            [['date_start', 'date_end'], 'safe'],
            [['user_id', 'total_count', 'complete_count', 'current'], 'integer'],
            [['name', 'link', 'position'], 'string', 'max' => 255]
        ];
    }


    public function getExpTime()
    {
        if($this->date_end && $this->date_start){
            $date = new \DateTime(date('Y-m-d H:i:s', $this->date_start));
            return \Yii::$app->formatter->asRelativeTime($date->diff(new \DateTime(date('Y-m-d H:i:s', $this->date_end))));
        } elseif($this->date_start) {
            $now = new \DateTime();
            $date = new \DateTime(date('Y-m-d H:i:s', strtotime($this->date_start)));
            return \Yii::$app->formatter->asRelativeTime($date->diff(new \DateTime()));
        } else {
            return 'неизвестна дата начала';
        }

    }


    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'job_id' => Yii::t('app', 'Job ID'),
            'name' => Yii::t('app', 'Name'),
            'link' => Yii::t('app', 'Link'),
            'date_start' => Yii::t('app', 'Date Start'),
            'date_end' => Yii::t('app', 'Date End'),
            'position' => Yii::t('app', 'Position'),
            'user_id' => Yii::t('app', 'User ID'),
            'total_count' => Yii::t('app', 'Total Count'),
            'complete_count' => Yii::t('app', 'Complete Count'),
            'current' => Yii::t('app', 'Current'),
        ];
    }
}