"{$id}_start", 'end' => "{$id}_end"]; } /** * Format two field names of this filter. * * @param string $column * * @return array */ protected function formatName($column) { $columns = explode('.', $column); if (count($columns) == 1) { $name = $columns[0]; } else { $name = array_shift($columns); foreach ($columns as $column) { $name .= "[$column]"; } } return ['start' => "{$name}[start]", 'end' => "{$name}[end]"]; } /** * Get condition of this filter. * * @param array $inputs * * @return mixed */ public function condition($inputs) { if (!Arr::has($inputs, $this->column)) { return; } $this->value = Arr::get($inputs, $this->column); $value = array_filter($this->value, function ($val) { return $val !== ''; }); if (empty($value)) { return; } if (!isset($value['start'])) { return $this->buildCondition($this->column, '<=', $value['end']); } if (!isset($value['end'])) { return $this->buildCondition($this->column, '>=', $value['start']); } $this->query = 'whereBetween'; return $this->buildCondition($this->column, $this->value); } /** * @param array $options * * @return $this */ public function datetime($options = []) { $this->view = 'admin::filter.betweenDatetime'; $this->setupDatetime($options); return $this; } /** * @param array $options */ protected function setupDatetime($options = []) { $options['format'] = Arr::get($options, 'format', 'YYYY-MM-DD HH:mm:ss'); $options['locale'] = Arr::get($options, 'locale', config('app.locale')); $startOptions = json_encode($options); $endOptions = json_encode($options + ['useCurrent' => false]); $script = <<id['start']}').datetimepicker($startOptions); $('#{$this->id['end']}').datetimepicker($endOptions); $("#{$this->id['start']}").on("dp.change", function (e) { $('#{$this->id['end']}').data("DateTimePicker").minDate(e.date); }); $("#{$this->id['end']}").on("dp.change", function (e) { $('#{$this->id['start']}').data("DateTimePicker").maxDate(e.date); }); EOT; Admin::script($script); } }