<?php
    
    namespace artweb\artbox\ecommerce\models;
    
    use artweb\artbox\language\behaviors\LanguageBehavior;
    use yii\db\ActiveQuery;
    use yii\db\ActiveRecord;
    use yii\db\Query;
    use yii\helpers\VarDumper;
    use yii\web\Request;
    
    /**
     * Class Label
     *
     * @property int              $id
     * @property string           $label
     * * From language behavior *
     * @property orderLabelLang   $lang
     * @property orderLabelLang[] $langs
     * @property orderLabelLang   $objectLang
     * @property string           $ownerKey
     * @property string           $langKey
     * @property orderLabelLang[] $modelLangs
     * @property bool             $transactionStatus
     * @method string           getOwnerKey()
     * @method void             setOwnerKey( string $value )
     * @method string           getLangKey()
     * @method void             setLangKey( string $value )
     * @method ActiveQuery      getLangs()
     * @method ActiveQuery      getLang( integer $language_id )
     * @method OrderLabelLang[]    generateLangs()
     * @method void             loadLangs( Request $request )
     * @method bool             linkLangs()
     * @method bool             saveLangs()
     * @method bool             getTransactionStatus()
     * * End language behavior
     */
    class Label extends ActiveRecord
    {
        
        public function rules()
        {
            return [
                [
                    [ 'label' ],
                    'string',
                ],
            ];
        }
        
        public static function tableName()
        {
            return 'order_label';
        }
        
        public function behaviors()
        {
            return [
                'language' => [
                    'class'      => LanguageBehavior::className(),
                    'objectLang' => OrderLabelLang::className(),
                    'ownerKey'   => 'id',
                    'langKey'    => 'order_label_id',
                ],
            ];
        }
        
        public function getStatistics(int $dateFrom, int $dateTo)
        {
            
            if ($dateTo != 0) {
                $where =    [
                    'between',
                    'created_at',
                    $dateFrom,
                    $dateTo,
                ];
            } else {
                $where = [];
            }
                $query = ( new Query() )->select(
                    [
                        'sum'      => 'SUM(total)',
                        'count'    => 'COUNT(*)',
                        'unique' => ( new Query() )->select('COUNT(*)')
                                                     ->from('order')
                                                     ->leftJoin(
                                                         'order_product',
                                                          '"order"."id"="order_product"."order_id"'
                                                     )
                                                     ->where([ 'order.label' => $this->id ])
                                                     ->andFilterWhere(
                                                        $where
                                                     ),
                        'products' => ( new Query() )->select('SUM(count)')
                                                     ->from('order')
                                                     ->leftJoin(
                                                         'order_product',
                                                         '"order"."id"="order_product"."order_id"'
                                                     )
                                                     ->where([ 'order.label' => $this->id ])
                                                     ->andFilterWhere(
                                                         $where
                                                     ),
                    ]
                )
                                        ->from('order')
                                        ->where([ 'label' => $this->id ])
                                        ->andFilterWhere(
                                         $where
                                        );
          
            return $query->one();
        }
    }