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);
