public function searchTypeRoom(request $request)
{
$id = $request->get('id');
$type = TypeRoom::find($id)->id;
$rooms = Room::where('type_room_id', '=', $type)->get();
$start = $request->get('start');
$exit = $request->get('exit');
$start = str_replace('-', '', $start);
$exit = str_replace('-', '', $exit);
// $reserveRoom = ReserveRoom::
// $reserveRoomExit = str_replace('-','',$reserveRoom->exit_at);
// $reserveRoomStart = str_replace('-','',$reserveRoom->start_at);
$reserveRooms = ReserveRoom::where('type_room_id', $type)->get();
// foreach ($reserveRooms as $reserveRoom) {
// echo $reserveRoom->id;
// }
// if ($start >= $reserveRoomStart && $start <= $reserveRoomExit) {
// echo "denegado";
// }else{
// echo "Aceptado";
// }
}
public function actionTranslate()
{
$rooms = TypeRoom::model()->findAllByAttributes(array('status' => 'ACTIVE'));
$sqlsm = "";
$sqlm = "";
$i = 0;
foreach ($rooms as $r) {
$sqlsm .= "insert into `sourcemessage` values (" . $i . ",'rooms','room_" . htmlentities($r->name, ENT_QUOTES, 'UTF-8') . "_name');<br>";
$sqlm .= "insert into `message` values (" . $i . ",'es','" . htmlentities($r->name, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `sourcemessage` values (" . $i . ",'rooms','room_" . htmlentities($r->name, ENT_QUOTES, 'UTF-8') . "_description');<br>";
$sqlm .= "insert into `message` values (" . $i . ",'es','" . htmlentities($r->description, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br>";
$services = Service::model()->findAll();
$sqlsm = "";
$sqlm = "";
foreach ($services as $s) {
$sqlsm .= "insert into `sourcemessage` values (" . $i . ",'services','service_" . htmlentities($s->title, ENT_QUOTES, 'UTF-8') . "_title');<br>";
$sqlm .= "insert into `message` values (" . $i . ",'es','" . htmlentities($s->title, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `message` values (" . $i++ . ",'en','');<br>";
if (!is_null($s->description)) {
$sqlsm .= "insert into `sourcemessage` values (" . $i . ",'services','service_" . htmlentities($s->title, ENT_QUOTES, 'UTF-8') . "_description');<br>";
$sqlm .= "insert into `message` values (" . $i . ",'es','" . htmlentities($s->description, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `message` values (" . $i++ . ",'en','');<br>";
}
}
echo $sqlsm;
echo $sqlm;
}
