function get_index() { $info = Current::config('company'); if ($this->input) { // set null in place of missing values to avoid "Undefined variable" in view. $info = $this->input + S::combine(array_keys($info), null); } $phone = head((array) $info['landline']) ?: head((array) $info['cellular']); return (array) $info + array('contactsURL' => null, 'phone' => $phone); }
$query->where('status', '!=', substr($ofStatus, 1)); } else { $query->where_in('status', $ofStatus); } $can['ofStatus'] = $ofStatus; }); Event::listen(VANE_NS . 'order.list.query', function (Query $query, Block_Order $block, array &$can) { $sorted = $block->in('sort', ''); $sorted or $query->order_by('updated_at', 'desc')->order_by('created_at', 'desc'); $filter = (array) $block->in('filter', ''); $query->commonList(array('paginate' => false, 'filter' => $filter)); $can['sort'] = $sorted ?: true; $can['desc'] = (string) $block->in('desc', '0') ?: '0'; $fields = array('id', 'sum', 'address', 'phone', 'notes'); $fields = userFields($fields, 'order'); $defaults = S::combine($fields, null); $can['filter'] = array_intersect_key($block->in(), $defaults) + $defaults; }); Event::listen(VANE_NS . 'order.list.query', function (Query $query, Block_Order $block, array &$can) { if ($date = $block->in('date', '')) { $query->where(function ($query) use($date) { if (strpbrk($date[0], '<>')) { $op = $date[0]; $date = substr($date, 1); } else { $op = '='; } is_numeric($date) or $date = strtotime($date); $date = with(new \DateTime())->setTimestamp((int) $date); $date = strtok($date->format($query->grammar->datetime), ' '); $query->where(\DB::raw('DATE(created_at)'), $op, $date)->or_where(\DB::raw('DATE(updated_at)'), $op, $date);