<?php

namespace app\common\model\movie\cinema;

use app\model\BaseModel;

class CinemaSched extends BaseModel
{
    protected $name = 'movie_cinema_sched';

    public static function tablePk(): ?string
    {
        return 'id';
    }

    /**
     * @param $model
     * @param array $where
     * @return CinemaSched
     */
    public function search($model = null, array $where = [])
    {
        $model = $model ?? new self();

        return $model->when(isset($where['film_sign']) && $where['film_sign'], function ($query) use ($where) {
            $query->where('film_sign', $where['film_sign']);
        })->when(isset($where['cinema_sign']) && $where['cinema_sign'], function ($query) use ($where) {
            $query->where('cinema_sign', $where['cinema_sign']);
        })->when(isset($where['show_date']) && $where['show_date'], function ($query) use ($where) {
            $query->where('show_date', $where['show_date']);
        })->when(isset($where['date']) && $where['date'], function ($query) use ($where) {
            $query->where('show_date', '>=', $where['date']);
        })->when(isset($where['relation_id']) && $where['relation_id'], function ($query) use ($where) {
            $query->where('relation_id', $where['relation_id']);
        })->when(isset($where['sched_sign']) && $where['sched_sign'], function ($query) use ($where) {
            $query->where('sched_sign', $where['sched_sign']);
        })->when(isset($where['show_time']) && $where['show_time'], function ($query) use ($where) {
            $query->where('show_time', '>=', $where['show_time']);
        });
    }
}