set_old_menus($menu,$sub_menu); require_once('pool/formatting_functions.php'); //*********************************** database accesses ********************************************************* $query='select booking.*, instructors.SIGN, real_auth.LAST_NAME, real_auth.FIRST_NAME, aircrafts.CALLSIGN from (booking, aircrafts) left join authentication as real_auth on booking.MEMBER_NUM=real_auth.NUM left join instructors on booking.INST_NUM=instructors.INST_NUM left join authentication as inst_auth on booking.INST_NUM=inst_auth.NUM where booking.AIRCRAFT_NUM=aircrafts.NUM and booking.CLUB_NUM='.$user_session->get_club_num(); if(!define_global('all_slots',false)) { $query=$query.' and booking.END_DATE>=\''.date('Y-m-d H:i:s').'\''; } if((!$user_session->is_anybody_book_allowed())and(!$user_session->is_nothing_allowed())) { if($user_session->is_instructor()) { $query=$query.' and (booking.MEMBER_NUM='.$user_session->get_authentication_num().' or booking.INST_NUM='.$user_session->get_authentication_num().')'; } else { $query=$query.' and booking.MEMBER_NUM='.$user_session->get_authentication_num(); } } if((!$user_session->is_freeze_aircraft_allowed())and(!$user_session->is_nothing_allowed())) { $query=$query.' and booking.SLOT_TYPE!=2'; } $query=$query.' order by booking.START_DATE'; $result=$database->query($query); // $result is used whithin the HTML code below ///////////////////////////////////// HTML DISPLAY START HERE //////////////////////////////////////////////////// require_once('includes/header.php'); ?>

Créneau checked onClick="submit()" /> Afficher les dépassés	Pilote	Avion	Instructeur	Sièges disponibles	actions possibles
START_DATE,$row->END_DATE)?>	SLOT_TYPE==2) { ?>MécaniqueLAST_NAME=='')and($row->FIRST_NAME=='')) { ?>???FIRST_NAME.' '.$row->LAST_NAME?>	CALLSIGN)?>	SIGN)?>	FREE_SEATS?>