<?php

namespace app\models;

use PDO;
use Yii;

/**
 * @property string $id
 * @property string $address
 * @property string $description
 * @property string $statusId
 * @property string $statusName
 * @property string $public            ex. "y"|"n"
 * @property string $userEditable      ex. "y"|"n"
 * @property string $userDraftable     ex. "y"|"n"
 * @property string $latitude          ex. "49.5645710",
 * @property string $longitude         ex. "25.6501800",
 * @property string $rating            ex. 0..1
 * @property string $noteForModerator
 * @property string $noteForUser
 * @property string $alias             ex. "2342-15-Kvitnia-Street-12-Ternopil",
 * @property string $languageId        ex. "ukr",
 * @property string $added             ex. "0000-00-00 00:00:00"
 * @property string $changed           ex. "0000-00-00 00:00:00"
 */
class Ticket extends AbstractObject
{
    public $viewColumns = array('id', 'address', 'description', 'statusId', 'latitude', 'longitude', 'noteForUser');

    protected $_insertViaDbFunctionColumn = array('address', 'description', 'statusId', 'latitude', 'longitude',
        'noteForModerator', 'noteForUser');
    protected $_updateViaDbFunctionColumn = array('id', 'address', 'description', 'latitude', 'longitude',
        'noteForUser');
    protected $_updateViaDbFunctionResetColumn = array('latitude', 'longitude', 'noteForUser');

    protected $_saveViaDbFunctionItemTemplate = array(
        'insert'      => '{item}_CreateByUser',
        'update'      => '{item}_UpdateByUser',
        'delete'      => '{item}_DeleteByUser',
        'updateLocal' => '{item}_UpdateLocal'
    );

    public static function getTicketImageSql($fieldTicketId)
    {
        $q = static::createQuery();
        $q->select(['imageV.filenameFs']);
        $q->from(['imageV']);
        $q->where('imageV.nodeId = ' . static::getDb()->quoteColumnName($fieldTicketId));
        $q->andWhere(['imageV.display' => 'y']);
        $q->orderBy('imageV.sorter');
        $q->limit(1);
        return $q->createCommand()->getRawSql();
    }

    public static function getTicketImageCountSql($fieldTicketId)
    {
        $q = static::createQuery();
        $q->select(['COUNT(*)']);
        $q->from(['imageV']);
        $q->where('imageV.nodeId = ' . static::getDb()->quoteColumnName($fieldTicketId));
        $q->andWhere(['imageV.display' => 'y']);
        $q->orderBy('imageV.sorter');
        $q->limit(1);
        return $q->createCommand()->getRawSql();
    }

    /**
     * @param int|array   $ticketId
     * @param null|string $for     "row"|"list"
     *
     * @return array|bool
     */
    public static function getTicketTags($ticketId, $for = 'row')
    {
        if (empty($ticketId)) {
            return [];
        }

        $query = static::createQuery();
        $query->from(['objectWithTagLinkedV owt']);
        // requiredForObject
        $query->select([
                'objectId key',
                'srcTypeCode typeCode', 'srcTypeName typeName', 'srcInternalTypeId as internalTypeId',
                'srcId id', 'objectId', 'srcName name',
                'srcAttributeDataType dataType', 'srcRequired required', 'srcAttributeCode attributeCode',
                'srcUofmPre uofmPre', 'srcUofmPost uofmPost',
                'srcNumericValue numericValue', 'srcDecimalMin decimalMin', 'srcDecimalMax decimalMax', 'srcDecimalRound decimalRound',
                'srcTextValue textValue', 'srcTextIsLong textIsLong',
                'srcDatetimeValue datetimeValue', 'srcDatetimeName datetimeName', 'srcDatetimeOutputFormatJs datetimeOutputFormatJs',
            ]);
        $query->andWhere(['objectId' => $ticketId]);
        $query->andWhere(['linked' => 1]);
        $query->andWhere(['srcIsRoot' => 'n']);
        $query->andWhere('srcGeoRoot IS NULL');
        $query->orderBy('srcTypeSorter, srcSorter');

        if ('row' === $for) {
            $query->andWhere('srcDisplayInObject = "y"');
        } elseif ('list' === $for) {
            $query->andWhere('srcDisplayInObjectList = "y"');
        }

        if (is_array($ticketId)) {
            return $query->createCommand()->queryAll(PDO::FETCH_GROUP | PDO::FETCH_ASSOC);
        } else {
            return $query->createCommand()->queryAll();
        }

    }

    public static function getTicketImages($ticketId)
    {
        $q = static::createQuery();
        $q->select(['imageId', 'name', 'filenameFs']);
        $q->from(['imageV']);
        $q->where(['imageV.nodeId' => $ticketId, 'imageV.display' => 'y']);
        $q->orderBy('imageV.sorter');
        return $q->createCommand()->queryAll();
    }

}