Пытаюсь отфильтровать заказы по дате, но ни так:
Код |
---|
$arFilterOrders = array('PROPERTY_VAL_BY_CODE_RESTAURANT_ID' => $arRest['ID'], 'STATUS_ID'=>'F', 'CANCELED'=> 'N', "DATE_INSERT" => date($DB->DateFormatToPHP(CSite::GetDateFormat("SHORT")), mktime(0, 0, 0, date("n"), 1, date("Y")))); $rsOrders = CSaleOrder::GetList(array(), $arFilterOrders); while($arOrder = $rsOrders -> Fetch()){ $arOrders[$arRest['NAME']][] = $arOrder; } |
Ни так, не получается:
Код |
---|
$arFilterOrders = array('PROPERTY_VAL_BY_CODE_RESTAURANT_ID' => $arRest['ID'], 'STATUS_ID'=>'F', 'CANCELED'=> 'N', ">=DATE_INSERT" => ConvertDateTime($DateFrom, "YYYY-MM-DD")." 00:00:00", "<=DATE_INSERT" => ConvertDateTime($DateTo, "YYYY-MM-DD")." 23:59:59"); $rsOrders = CSaleOrder::GetList(array(), $arFilterOrders); while($arOrder = $rsOrders -> Fetch()){ $arOrders[$arRest['NAME']][] = $arOrder; } |