Yii2 搜索问题 6 个搜索条件，需要交叉搜索怎么实现最好？ [ 2.0 版本 ]

<?php
 if($this->start_date&&$this->end_date&&$this->shop_name&&$this->spid){
            $sum_gross = $query->select([
                'gross_sum' => 'sum(gross_margin)',
            ])
                ->where(['between', 'create_date', $this->start_date, $this->end_date])
                ->andWhere(['like','shop_name',$this->shop_name])
                ->andWhere(['like','spid',$this->spid])
                ->scalar();
            $sum_sale = $query->select([
                'sale_sum' => 'sum(saleroom)',
            ])
                ->where(['between', 'create_date', $this->start_date, $this->end_date])
                ->andWhere(['like','shop_name',$this->shop_name])
                ->andWhere(['like','spid',$this->spid])
                ->scalar();

            $sum_profit = $query->from("yn_goods_analyze_shop_by_day")
                ->select([
                    'predict_profit' => "round(sum(saleroom)*0.88-sum(goods_cost)-6,1)"
                ])
                ->where(['between', 'create_date', $last_f_date, $last_e_date])
                ->andWhere(['like','shop_name',$this->shop_name])
                ->andWhere(['like','spid',$this->spid])
                ->scalar();

            $resp = [
                'sum_gross' => $sum_gross,
                'sum_sale' => $sum_sale,
                'predict_profit' => $sum_profit,
            ];
            return $resp;
        }
?>

这是其中一个判断情况