<?php
/**
 * 重庆赤晓店信息科技有限公司
 * https://www.chixiaodian.com
 * Copyright (c) 2023 赤店商城 All rights reserved.
 */

namespace app\modules\admin\models;

use app\models\IntegralRecharge;
use app\models\IntegralRechargeOrder;
use app\models\ReOrder;
use app\models\ReOrderRefundMoney;
use yii\base\Model;
use app\models\User;
use app\models\AccountLog;
use app\utils\OrderNo;
use app\utils\Refund;
use app\utils\Notice\NoticeSend;
use app\models\Option;
use app\constants\OptionSetting;

class IntegralReOrderForm extends Model
{
    public $export;
    public $user_id;
    public $order_id;
    public $store_id;
    public $name;
    public $phone;
    public $status;
    public $audit_status;
    public $dateTime;
    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['store_id'], 'integer'],
            [['name', 'phone', 'status', 'audit_status', 'user_id', 'order_id', 'dateTime'], 'safe'],
            [['export'], 'safe'],
        ];
    }

    public function search()
    {
        $query = IntegralRechargeOrder::find()->alias('ro')->where([
            'ro.is_pay' => 1,
            'ro.is_delete' => 0,
        ])->leftJoin(['u' => User::tableName()], 'ro.user_id = u.id')
            ->leftJoin(['ir' => IntegralRecharge::tableName()], 'ro.recharge_id = ir.id')
            ->orderBy('ro.id DESC');
        if ($this->store_id > 0) {
            $query->andWhere(['ro.store_id' => $this->store_id]);
        }
        if ($this->name) {
            $query->andWhere(['like', 'u.nickname', $this->name]);
        }
        if ($this->phone) {
            $query->andWhere(['like', 'u.binding', $this->phone]);
        }
        if ($this->dateTime) {
            $query->andWhere(['>=', 'ro.created_at', strtotime($this->dateTime[0])]);
            $query->andWhere(['<=', 'ro.created_at', strtotime($this->dateTime[1])]);
        }
        $query->select('ro.*, u.avatar_url, u.binding, u.nickname, ir.name, ir.first_commission, ir.second_commission, ir.third_commission');
        $data = pagination_make($query);
        $data['data'] = $data['list'];
        unset($data['list']);
        foreach ($data['data'] as &$item) {
            $item['created_at'] = date('Y-m-d H:i:s', $item['created_at']);
        }
        return [
            'code' => 0,
            'data' => $data,
            'sql' => $query->createCommand()->getRawSql(),
        ];
    }


}