type = $type; $this->class = [ 'start' => uniqid('column-filter-start-'), 'end' => uniqid('column-filter-end-'), ]; } /** * Add a binding to the query. * * @param mixed $value * @param Model $model */ public function addBinding($value, Model $model) { $value = array_filter((array) $value); if (empty($value)) { return; } if (!isset($value['start'])) { return $model->where($this->getColumnName(), '<', $value['end']); } elseif (!isset($value['end'])) { return $model->where($this->getColumnName(), '>', $value['start']); } else { return $model->whereBetween($this->getColumnName(), array_values($value)); } } protected function addScript() { $options = [ 'locale' => config('app.locale'), 'allowInputToggle' => true, ]; if ($this->type == 'date') { $options['format'] = 'YYYY-MM-DD'; } elseif ($this->type == 'time') { $options['format'] = 'HH:mm:ss'; } elseif ($this->type == 'datetime') { $options['format'] = 'YYYY-MM-DD HH:mm:ss'; } else { return; } $options = json_encode($options); Admin::script("$('.{$this->class['start']},.{$this->class['end']}').datetimepicker($options);"); } /** * Render this filter. * * @return string */ public function render() { $script = <<<'SCRIPT' $('.dropdown-menu input').click(function(e) { e.stopPropagation(); }); SCRIPT; Admin::script($script); $this->addScript(); $value = $this->getFilterValue(['start' => '', 'end' => '']); $active = empty(array_filter($value)) ? '' : 'text-yellow'; return <<

• {$this->trans('submit')} {$this->trans('reset')}

EOT; } }