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;
}
