type = $type; $this->class = uniqid('column-filter-'); } /** * Add a binding to the query. * * @param string $value * @param Model|null $model */ public function addBinding($value, Model $model) { if (empty($value)) { return; } if ($this->type == 'like') { $model->where($this->getColumnName(), 'like', "%{$value}%"); return; } if (in_array($this->type, ['date', 'time'])) { $method = 'where'.ucfirst($this->type); $model->{$method}($this->getColumnName(), $value); return; } $model->where($this->getColumnName(), $value); } /** * Add script to page. * * @return void */ 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}').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(); $active = empty($value) ? '' : 'text-yellow'; return <<

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

EOT; } }