if (isset($objects[$order_bookings['product_id']])) {
$room_id = $objects[$order_bookings['product_id']]->product_ean;
$date_from = date('d-m-Y', $order_bookings['dfrom']);
$date_to = date('d-m-Y', $order_bookings['dto']);
//echo'<pre>';print_r($objects[$order_bookings['product_id']]);echo'</pre>';//die;
//echo'<pre>';print_r($room_id);echo'</pre>';//die;
echo '<pre>C: ';
print_r($date_from);
echo '</pre>';
//die;
echo '<pre>По: ';
print_r($date_to);
echo '</pre>';
//die;
$date_from = VipLocalApi::PrepareDateForLocalFormat($date_from, 2);
$date_to = VipLocalApi::PrepareDateForLocalFormat($date_to, 2);
$query = "SELECT k_zajav, room_id, dat1, dat2 FROM `armor`\n\t\t\t\t\tWHERE `room_id` = {$room_id} AND \n\t\t\t\t\t(\n\t\t\t\t\t(dat1 <= '{$date_from}' AND dat2 >= '{$date_to}') OR\n\t\t\t\t\t(dat1 >= '{$date_from}' AND dat2 <= '{$date_to}') OR\n\t\t\t\t\t(dat1 <= '{$date_from}' AND dat2 > '{$date_from}' AND dat2 <= '{$date_to}') OR\n\t\t\t\t\t(dat1 >= '{$date_from}' AND dat1 < '{$date_to}' AND dat2 >= '{$date_to}')\n\t\t\t\t\t)\n\n\t\t\t\t\tORDER BY `k_zajav` DESC";
//echo'<pre>';print_r($query);echo'</pre>';//die;
$db_local->setQuery($query);
$rows = $db_local->loadObjectList();
echo '<pre>';
print_r($rows);
echo '</pre>';
//die;
//echo'<pre>';var_dump($rows);echo'</pre>';//die;
} else {
echo '<pre>Данный объект отсутствует в базе данных сайта.</pre>';
}
}
}
break;
