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; }