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;