public static function getOrdersList($id = null, $status = 'new', $search = array())
{
$ret = array('dealer' => null, 'dealers_list' => null);
$where = 'WHERE {{dealers_orders_status}}.path = \'' . $status . '\'';
if ($search['form'] && $search['to']) {
$where .= ' AND ({{dealers_orders}}.cdate BETWEEN ' . $search['from'] . ' AND ' . $search['to'] . ') ';
}
if ($search['city']) {
$where .= ' AND {{dealers}}.city=\'' . $search['city'] . '\'';
}
if (!is_null($id)) {
//$id = (isset($_GET['id'])) ? $_GET['id'] : null;
$where .= ' AND {{dealers_orders}}.dealer=' . $id;
$ret['dealer'] = Dealers::getOne($id);
}
$ret['statuses'] = DealersOrders::getStatusesList();
$sql = '
SELECT
{{dealers_orders}}.*,
{{dealers_orders_status}}.name as statusname,
{{dealers_orders_status}}.path as statuspath,
{{dealers}}.city as city,
{{dealers}}.company as company,
{{dealers}}.name as name
FROM {{dealers_orders}}
LEFT JOIN {{dealers_orders_status}} ON {{dealers_orders}}.status = {{dealers_orders_status}}.id
LEFT JOIN {{dealers}} ON {{dealers_orders}}.dealer = {{dealers}}.id
' . $where . ' ORDER by cdate DESC
';
$ret['list'] = DB::getAll($sql);
$ret['dealers_list'] = Dealers::getShortList();
$ret['city_list'] = Dealers::getCityList();
//$ret['sale'] = DealersSales::calcSale()
return $ret;
}
