public static function getWeekEarningPdf($user_id, $speriod, $eperiod) { $array = []; $subquery = (new \yii\db\Query())->from('classes')->select('class_id')->where(['class_trainer_id' => $user_id])->andWhere('`class_etime` >= :start AND `class_etime` <= :end', [":start" => $speriod, ":end" => $eperiod])->all(); if ($subquery) { foreach ($subquery as $val) { @($array[] = $val['class_id']); } $array = implode(',', $array); $subquery = TransactionHistory::find()->select('class_id')->where("`class_id` IN ({$array})")->andWhere(['transaction_dispute_status' => 'close'])->orWhere(['transaction_dispute_status' => 'declined'])->all(); if ($subquery) { $array = []; foreach ($subquery as $val) { @($array[] = $val['class_id']); } $array = implode(',', $array); return Classes::find()->where("`class_id` IN ({$array})"); } } return false; }