public static function main()
{
$venue_room = venue_room::orderBy('room_name')->get();
$user_list = array();
foreach ($venue_room as $query) {
$venue_name = $query->venue->name;
$room_name = $query->room_name;
$full_name = $venue_name . " - " . $room_name;
$room_id = $query->id;
$rooom_list[] = "[" . $room_id . "] " . $full_name;
}
echo json_encode($rooom_list);
}
public static function venue_form($id, $type)
{
if ($type == 'edit_event') {
$event = event::where("id", "=", $id)->first();
$id = $event->venue_id;
}
$venue_room = venue_room::orderBy('room_name')->get();
$returndata = "<select name='venue_id' id='venue_id' class='form-control'>";
foreach ($venue_room as $query) {
$venue_name = $query->venue->name;
$room_name = $query->room_name;
$full_name = $venue_name . " - " . $room_name;
$room_id = $query->id;
$returndata .= "<option value='" . $room_id . "'";
if ($id == $room_id) {
$returndata .= " selected='selected'";
}
$returndata .= ">" . $full_name . "</option>";
}
$returndata .= "</select>";
echo $returndata;
}
