timestamp = true; return $this; } /** * Format id. * * @param string $column * * @return array|string */ public function formatId($column) { $id = str_replace('.', '_', $column); $prefix = 'filter_column_'.$this->parent->grid()->getName().'_'; return ['start' => "{$prefix}{$id}_start", 'end' => "{$prefix}{$id}_end"]; } /** * Format two field names of this filter. * * @param string $column * * @return array */ protected function formatName($column) { $gridName = $this->parent->grid()->getName(); $prefix = $gridName ? $gridName.'_' : ''; $columns = explode('.', $column); if (count($columns) == 1) { $name = $prefix.$columns[0]; } else { $name = $prefix.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 ($this->timestamp) { $value = array_map(function ($v) { if ($v) { return strtotime($v); } }, $value); } if (empty($value)) { return; } if (! isset($value['start']) && isset($value['end'])) { return $this->buildCondition($this->column, '<=', $value['end']); } if (! isset($value['end']) && isset($value['start'])) { return $this->buildCondition($this->column, '>=', $value['start']); } $this->query = 'whereBetween'; return $this->buildCondition($this->column, [$value['start'], $value['end']]); } /** * @param array $options * * @return $this */ public function datetime($options = []) { $this->view = 'admin::filter.between-datetime'; DateTime::collectAssets(); $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); }); JS; Admin::script($script); } }