<?php

    if(!$mgc->managers->access('orders') && !$mgc->managers->access('users')) {
        exit();
    }

    $limit = 100;
    $keyword = $mgc->request->get('query', 'string');

    /*Поиск пользователей*/
    $mgc->db->query('SELECT 
            u.id, 
            u.name, 
            u.email 
        FROM __users u 
        WHERE 
            u.name LIKE "%'.$mgc->db->escape($keyword).'%" 
            OR u.email LIKE "%'.$mgc->db->escape($keyword).'%"
        ORDER BY u.name 
        LIMIT ?
    ', $limit);
    $users = $mgc->db->results();
    
    $suggestions = array();
    foreach($users as $user) {
        $suggestion = new stdClass();
        $suggestion->value = $user->name." ($user->email)";
        $suggestion->data = $user;
        $suggestions[] = $suggestion;
    }
    
    $res = new stdClass;
    $res->query = $keyword;
    $res->suggestions = $suggestions;
    header("Content-type: application/json; charset=UTF-8");
    header("Cache-Control: must-revalidate");
    header("Pragma: no-cache");
    header("Expires: -1");
    print json_encode($res);