<?
namespace common;

use common\support\Message;
use common\support\Message\structure\eSupportMessageType;
use common\support\structure\eSupportStatus;
use core\db\structure\Column as C;
use core\db\structure\eColumnType;
use ui\form\structure\eInputType;
use ui\Form;
use ui\input\Input;
use core\lang\structure\LangVariable as V;
use ms\ms\structure\msModuleTable;
use common\support\structure\supportLang as Vars;


class Support extends msModuleTable {
    static $self;
    static $table_name = 'support';
    static $controller  = 'common.support';

    static $ID        = 'id';

    static $NAME      = 'name';
    static $PROFILE   = 'profile';
    static $STATUS    = 'status';
    static $TO        = 'to';
    static $OID       = 'oid';
    static $PORTAL    = 'portal';

    static $ACCOUNT   = 'account';
    static $CREATED   = 'created';
    static $UPDATED   = 'updated';


    static function getTitle(){return V::get(Vars::$MODULE_NAME);}
    static function getSystemLangValues():array{ return Vars::getArray(); }
    public function _update(\Where $w, array $values) {
        $values[self::$UPDATED] = time();
        return parent::_update($w, $values);
    }

    public static function installUniques() {
        \DB::addIndexManyColumns(self::$table_name,[self::$TO,self::$OID]);
        \DB::addIndexManyColumns(self::$table_name,[self::$PORTAL]);
        \DB::addIndexManyColumns(self::$table_name,[self::$PROFILE]);
        \DB::addIndexManyColumns(self::$table_name,[self::$STATUS]);
        \DB::addIndexManyColumns(self::$table_name,[self::$ACCOUNT]);
    }

    static function isMyProfileCanBeAdmin(){
        // TODO : доделать админов
        return false;
    }

    static function closeSupport($support_id){
        $r = Support::updateById($support_id,[
            Support::$STATUS => eSupportStatus::CLOSE
        ]);
        return ['success'=>$r->res];
    }

    static function addMessage($support_id,$text='',$isAdmin = false,$attachments = []){
        $support_id = intval($support_id);
        $text = trim((string)$text);
        if(!$support_id or !$text) return null;
        Message::insert([
            Message::$TEXT => $text,
            Message::$SUPPORT => $support_id,
            Message::$TYPE => $isAdmin ? eSupportMessageType::ANSWER : eSupportMessageType::QUESTION,
        ]);
        Support::updateById($support_id,[
            Support::$STATUS => $isAdmin ? eSupportStatus::WAIT_PROFILE : eSupportStatus::WAIT_SUPPORT
        ]);

    }

    static function getMessagesFormatted($id){
        $id = intval($id);
        $res = [];
        $r = Message::select($q = [
            \Query::TABLES =>[Message::$table_name],
            \Query::LEFT_JOINS =>[
                [\Profile::$table_name,\Profile::$ID,Message::$PROFILE]
            ],
            \Query::WHERE => new \Where(\Where::_and([
                \Where::_operator(Message::$SUPPORT,'=',$id),
            ])),
            \Query::SORT => [Message::$CREATED=>'ASC'],
        ]);
        while($l = \DB::fetch($r)){
            $res[] = Message::format($l);
        }
        return $res;
    }


    static function format($v){
        $id = intval($v[Support::$ID]);
        return [
            'id'            => $id,
            'status'        => intval($v[Support::$STATUS]),
            'title'         => (string)$v[Support::$NAME],
            'emp'           => \Profile::formatPublic($v),
            'profile'       => \Profile::formatPublic($v),
            'date'          => self::formatDate($v[self::$CREATED]),
        ];
    }


    static function addSupport($profile_id,$to,$oid,$name,$text){
        $res = [];
        $profile_id = intval($profile_id);
        $to         = intval($to);
        $oid        = intval($oid);
        // TODO: Выслать уведомление админам
        $r = Support::insert([
            Support::$NAME    => trim((string)$name),
            Support::$PROFILE => intval($profile_id),
            Support::$TO      => intval($to),
            Support::$OID     => intval($oid),
        ]);
        Message::insert([
            Message::$SUPPORT => $r->id,
            Message::$TEXT => trim((string)$text),
            Message::$TYPE => eSupportMessageType::QUESTION,
        ]);
        $res = Support::format(Support::getByID($r->id));
        return $res;
    }


    static function getList($profile_id,$isAdmin,$isClosed,$isOnlyNew,$isWaitAnswer,$search,$to=0,$oid=0){
        $res = [];
        $isCanAdmin   = static::isMyProfileCanBeAdmin();
        $isClosed     = boolval($isClosed);
        $isOnlyNew    = boolval($isOnlyNew);
        $isWaitAnswer = boolval($isWaitAnswer);
        $isAdmin      = boolval($isAdmin) && $isCanAdmin;
        $search       = trim((string)$search);
        $isSearch     = $search!='';
        $to           = intval($to);
        $oid          = intval($oid);

        $and = [];
        if($to){
            $and[] = \Where::_operator(Support::$TO,'=',$to);
        }
        if($to and $oid){
            $and[] = \Where::_operator(Support::$OID,'=',$oid);
        }

        if($isSearch) {
            $search_id = intval($search);
            $or = [];
            if($search_id) {
                $or[] = \Where::_operator(Support::$ID, 'LIKE', $search_id.'%');
            }
            $or[] = \Where::_operator(Support::$NAME, 'LIKE', '%'.$search.'%');;
            if($or){
                $and[] = \Where::_or($or);
            }
        } else {
            $and[] = \Where::_operator(Support::$STATUS, $isClosed ? '=' : '<>', eSupportStatus::CLOSE);
            if ($isOnlyNew) {
                $and[] = \Where::_operator(Support::$STATUS, '=', $isAdmin ? eSupportStatus::WAIT_SUPPORT : eSupportStatus::WAIT_PROFILE);
            }
            if ($isWaitAnswer) {
                $and[] = \Where::_operator(Support::$STATUS, '=', $isAdmin ? eSupportStatus::WAIT_PROFILE : eSupportStatus::WAIT_SUPPORT);
            }
        }
        if(!$isAdmin) {
            $and[] = \Where::_operator(Support::$PROFILE,'=',$profile_id);
        } else {
            $and[] = \Where::_operator(Support::$ACCOUNT,'=',\Site::$owner_id);
        }

        $r = Support::select($q = [
            \Query::LEFT_JOINS => [
                [\Profile::$table_name,\Profile::$ID,Support::$PROFILE]
            ],
            \Query::WHERE => new \Where(\Where::_and($and)),
            \Query::SORT  => [Support::$UPDATED=>'DESC'],
        ]);
        while($l = \DB::fetch($r)){
            $res[] = Support::format($l);
        }
        return $res;
    }


    static function columnInfo() : array {
        return [
            new C([
                C::VAR_NAME         =>&self::$ID,
                C::TYPE             =>eColumnType::INT,
                C::AUTO_INCREMENT   =>true,
                C::PRIMARY          =>true,
                C::DEFAULT          =>0,
                C::HIDDEN           =>true,
                C::TH               =>V::get(Vars::$ID),
            ]),
            new C([
                C::VAR_NAME         => &self::$NAME,
                C::TYPE             => eColumnType::VARCHAR,
                C::LENGTH           => 1023,
                C::TH               => V::get(Vars::$NAME),
            ]),

            new C([
                C::VAR_NAME         => &self::$PROFILE,
                C::TYPE             => eColumnType::INT,
                C::TH               => V::get(Vars::$PROFILE),
                C::DEFAULT          => intval(PID),
            ]),
            new C([
                C::VAR_NAME         => &self::$STATUS,
                C::TYPE             => eColumnType::TINYINT,
                C::DEFAULT          => eSupportStatus::WAIT_SUPPORT,
                C::TH               => V::get(Vars::$STATUS),
            ]),
            new C([
                C::VAR_NAME         => &self::$TO,
                C::TYPE             => eColumnType::INT,
                C::TH               => V::get(Vars::$TO),
            ]),
            new C([
                C::VAR_NAME         => &self::$OID,
                C::TYPE             => eColumnType::INT,
                C::TH               => V::get(Vars::$OID),
            ]),
            new C([
                C::VAR_NAME         => &self::$PORTAL,
                C::TYPE             => eColumnType::INT,
                C::TH               => V::get(Vars::$PORTAL),
                C::DEFAULT          => intval(\Site::$portal_id)
            ]),


            new C([
                C::VAR_NAME         => &self::$ACCOUNT,
                C::TYPE             => eColumnType::INT,
                C::LENGTH           => 11,
                C::TH               => V::get(Vars::$ACCOUNT),
                C::DEFAULT          => intval(\SITE::$owner_id),
                c::HIDDEN=>true,
                c::FUNC_VALUE       => function($v){
                    if($id = $v[self::$ACCOUNT]) {
                        return \Account::getName(  \Account::getByID($id) );
                    } else return '-';
                },
            ]),
            new C([
                C::VAR_NAME         => &self::$CREATED,
                C::TYPE             => eColumnType::INT,
                C::LENGTH           => 11,
                C::TH               => V::get(Vars::$CREATED),
                C::DEFAULT          => time(),
                c::FUNC_VALUE       => function($v){return self::formatDate($v[self::$CREATED]);},
                c::HIDDEN=>true,
            ]),
            new C([
                C::VAR_NAME         => &self::$UPDATED,
                C::TYPE             => eColumnType::INT,
                C::DEFAULT          => time(),
                C::TH               => V::get(Vars::$UPDATED),
                c::FUNC_VALUE       => function($v){return self::formatDate($v[self::$UPDATED]);},
                c::HIDDEN=>true,
            ]),
        ];
    }

}
new Support();


///