<?php

namespace app\modules\admin\controllers;

use Yii;
use yii\web\Controller;
use yii\web\BadRequestHttpException;
use app\models\Status;
use app\models\OrderStatuses;
use app\models\ShippingMethod;

/**
 * Default controller for the `admin` module
 */
class DefaultController extends Controller
{
    /**
     * @inheritdoc
     */
    public function behaviors()
    {
        return [
            'contentType' => [
                'class' => 'yii\filters\ContentNegotiator',
                'except' => ['index'],
                'formats' => [
                    'application/json' => \yii\web\Response::FORMAT_JSON
                ]
            ],
        ];
    }

    /**
     * Renders the index view for the module
     * @return string
     */
    public function actionIndex()
    {
        return $this->render('index');
    }

    /**
     * Retrievers the orders
     * @return JSON array
     */
    public function actionGetData()
    {
        $state = (int) Yii::$app->request->get('state');

        $query = (new \yii\db\Query())
            ->select([
                'o.*',
                's.status_date',
                's.status_id',
                's.message'])
            ->from('orders o')
            ->innerJoin('order_statuses s',
                's.order_id = o.id and s.status_date = (select max(status_date) from order_statuses where order_id = s.order_id)');
        if ($state) $query->where('s.status_id = :state', [':state' => $state]);
        $query->orderBy('o.id DESC');

        return $query->all();
    }

    /**
     * Retrieves the `status` dictionary
     * @return array
     */
    public function actionGetStatuses()
    {
        return Status::find()->orderBy('id')->all();
    }

    /**
     * Retrieves the `shipping_methods` dictionary
     * @return array
     */
    public function actionGetShipping()
    {
        return ShippingMethod::find()->orderBy('id')->all();
    }

    public function actionStatusTranslation()
    {
        $result = [];
        $category = 'status';
        foreach (array_keys(Yii::$app->params['languages']) as $lang) {
            Yii::$app->language = $lang;
            $fileMap = Yii::$app->i18n->getMessageSource($category)->fileMap;
            $file = require(Yii::getAlias(Yii::$app->i18n->getMessageSource($category)->basePath . '/' . $lang . '/' . $fileMap[$category]));
            foreach ($file as $src => $translation) {
                $result[] = [
                    'lang' => $lang,
                    'src' => $src,
                    'translation' => $translation,
                ];
            }
        }
        return $result;
    }

    public function actionSendStatus()
    {
        $model = new OrderStatuses;
        if ($model->load(Yii::$app->request->post())) {
            if ($model->save()) {
                if (intval(Yii::$app->request->post('sendMsg'))) {
                    try {
                        $sms = Yii::$app->smsGate->sendSMS($model->phone, $model->message);
                    } catch (\Exception $exc) {
                        $sms = $exc->getMessage();
                    }
                } else $sms = '';
                return [
                    'result' => 'OK',
                    'status_id' => $model->status_id,
                    'status_date' => $model->status_date,
                    'message' => $model->message,
                    'sms' => $sms,
                ];
            }
        }
        throw new BadRequestHttpException('Invalid status sent');
    }

    public function actionStatusHistory()
    {
        $order_id = (int) Yii::$app->request->get('order_id');
        return OrderStatuses::find()->where('order_id = :order_id', [':order_id' => $order_id])->orderBy('status_date ASC')->all();
    }
}