m_reservation.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607
  1. <?php
  2. // $Id: m_reservation.php,v 1.26 2006/05/12 08:38:34 kvansteenkiste Exp $
  3. /*
  4. ==============================================================================
  5. Dokeos - elearning and course management software
  6. Copyright (c) 2004-2008 Dokeos SPRL
  7. Copyright (c) Sebastien Jacobs (www.spiritual-coder.com)
  8. Copyright (c) Kristof Van Steenkiste
  9. Copyright (c) Julio Montoya Armas
  10. For a full list of contributors, see "credits.txt".
  11. The full license can be read in "license.txt".
  12. This program is free software; you can redistribute it and/or
  13. modify it under the terms of the GNU General Public License
  14. as published by the Free Software Foundation; either version 2
  15. of the License, or (at your option) any later version.
  16. See the GNU General Public License for more details.
  17. Contact address: Dokeos, rue du Corbeau, 108, B-1030 Brussels, Belgium
  18. Mail: info@dokeos.com
  19. ==============================================================================
  20. */
  21. /**
  22. ---------------------------------------------------------------------
  23. Reservation-manager (add, edit & delete)
  24. ---------------------------------------------------------------------
  25. */
  26. require_once('rsys.php');
  27. Rsys :: protect_script('m_reservation', $_GET['item_id']);
  28. $tool_name = get_lang('BookingPeriodList');
  29. /**
  30. ---------------------------------------------------------------------
  31. */
  32. /**
  33. * Filter to display the modify-buttons
  34. *
  35. * @param - int $id The reservation-id
  36. */
  37. function modify_filter($id) {
  38. $out = ' <a href="m_reservation.php?action=accept&amp;rid='.$id.'" alt="'.get_lang('AutoAccept').'"><img title="'.get_lang('AutoAccept').'" alt="'.get_lang('AutoAccept').'" src="../img/students.gif" /></a>';
  39. $out .= '<a href="m_reservation.php?action=edit&amp;id='.$id.'" alt="'.get_lang('EditBookingPeriod').'"><img title="'.get_lang('EditBookingPeriod').'" alt="'.get_lang('EditBookingPeriod').'" src="../img/edit.gif" /></a>';
  40. $out .= ' <a href="m_reservation.php?action=delete&amp;id='.$id.'" alt="'.get_lang('DeleteBookingPeriod').'" onclick="javascript:if(!confirm('."'".addslashes(htmlentities(get_lang("ConfirmDeleteBookingPeriod")))."'".')) return false;"><img title="'.get_lang('DeleteBookingPeriod').'" alt="'.get_lang('DeleteBookingPeriod').'" src="../img/delete.gif" /></a>';
  41. return $out;
  42. }
  43. if (isset ($_POST['action'])) {
  44. switch ($_POST['action']) {
  45. case 'accept_users' :
  46. $ids = $_POST['accepting'];
  47. //echo count($ids);
  48. if (count($ids) > 0) {
  49. foreach ($ids as $id) {
  50. //echo $id;
  51. $result = Rsys :: set_accepted($id, 1);
  52. }
  53. }
  54. $_GET['action'] = 'accept';
  55. break;
  56. case 'unaccept_users' :
  57. $ids = $_POST['accepting'];
  58. //echo count($ids);
  59. if (count($ids) > 0) {
  60. foreach ($ids as $id) {
  61. //echo $id;
  62. $result = Rsys :: set_accepted($id, 0);
  63. }
  64. }
  65. $_GET['action'] = 'accept';
  66. break;
  67. case 'delete_subscriptions' :
  68. $res_id = $_GET['rid'];
  69. $ids = $_POST['accepting'];
  70. //echo count($ids);
  71. if (count($ids) > 0) {
  72. foreach ($ids as $id) {
  73. $result = Rsys :: delete_subscription($res_id,$id);
  74. }
  75. }
  76. $_GET['action'] = 'accept';
  77. break;
  78. }
  79. }
  80. /**
  81. ---------------------------------------------------------------------
  82. */
  83. switch ($_GET['action']) {
  84. case 'overviewsubscriptions' :
  85. $interbreadcrumb[] = array ("url" => "mysubscriptions.php", "name" => get_lang('Booking'));
  86. $interbreadcrumb[] = array ("url" => "m_reservation.php", "name" => get_lang('ManageBookingPeriods'));
  87. Display :: display_header(get_lang('OverviewSubscriptions'));
  88. api_display_tool_title(get_lang('Overview'));
  89. echo '<div class="actions">';
  90. echo '<form id="cat_form" action="m_reservation.php" method="get">';
  91. echo '<input type="hidden" name="action" value="overviewsubscriptions"/>';
  92. echo '<input type="text" name="keyword" /><button type="submit" class="search" value="'.get_lang('Search').'" >'.get_lang('Search').'</button></form>';
  93. echo '</div><br>';
  94. $table = new SortableTable('reservation', array ('Rsys', 'get_num_subscriptions_overview'), array ('Rsys', 'get_table_subcribed_reservations'), 1);
  95. $table->set_additional_parameters(array ('action' => 'overviewsubscriptions','keyword' => $_GET['keyword']));
  96. $table->set_header(0, get_lang('ResourceName'), true);
  97. $table->set_header(1, get_lang('ResourceTypeName'), true);
  98. $table->set_header(2, get_lang('StartDate'), true);
  99. $table->set_header(3, get_lang('EndDate'), true);
  100. $table->set_header(4, get_lang('SubscribedPerson'), true);
  101. $table->set_header(5, get_lang('SubscribedStartDate'), true);
  102. $table->set_header(6, get_lang('SubscribedEndDate'), true);
  103. $table->set_header(7, get_lang('Accept'), true);
  104. $table->display();
  105. break;
  106. case 'accept' :
  107. $NoSearchResults = get_lang('NoReservation');
  108. if (empty ($_GET['rid'])) {
  109. $_GET['rid'] = $_POST['rid'];
  110. }
  111. if ($_GET['switch'] == 'edit') {
  112. Rsys :: set_accepted($_GET['dummy'], $_GET['set']);
  113. }
  114. if ($_GET['switch'] == 'delete') {
  115. Rsys :: delete_subscription($_GET['rid'],$_GET['dummy']);
  116. }
  117. $interbreadcrumb[] = array ("url" => "mysubscriptions.php", "name" => get_lang('Booking'));
  118. $interbreadcrumb[] = array ("url" => "m_reservation.php", "name" => get_lang('ManageBookingPeriods'));
  119. Display :: display_header(get_lang('AutoAccept'));
  120. api_display_tool_title(get_lang('AutoAccept'));
  121. $table = new SortableTable('accepting', array ('Rsys', 'get_num_waiting_users'), array ('Rsys', 'get_table_waiting_users'), 1);
  122. $table->set_additional_parameters(array ('rid' => $_GET['rid'], 'action' => 'accept'));
  123. $table->set_header(0, '', false, array ('style' => 'width:10px'));
  124. $table->set_header(1, get_lang('SubscribedPerson'), true);
  125. $table->set_header(2, get_lang('Class'), true);
  126. $table->set_header(3, get_lang('SubscribedStartDate'), false);
  127. $table->set_header(4, get_lang('SubscribedEndDate'), false);
  128. $table->set_header(5, get_lang('Accept'), false, array ('style' => 'width:30px;'));
  129. $table->set_header(6, get_lang('Delete'), false, array ('style' => 'width:30px;'));
  130. $table->set_form_actions(array ('accept_users' => get_lang('AcceptUsers'), 'unaccept_users' => get_lang('UnacceptedUsers'), 'delete_subscriptions' => get_lang('Delete_subscriptions')), 'accepting');
  131. //$table->set_form_actions(array ('accept_users' => get_lang('AcceptUsers'), 'unaccept_users' => get_lang('UnacceptedUsers')), 'accepting');
  132. $table->display();
  133. break;
  134. case 'add' :
  135. if (!isset ($_GET['cat_id']))
  136. $_GET['cat_id'] = 0;
  137. $interbreadcrumb[] = array ("url" => "mysubscriptions.php", "name" => get_lang('Booking'));
  138. $interbreadcrumb[] = array ("url" => "m_reservation.php", "name" => get_lang('ManageBookingPeriods'));
  139. Display :: display_header(get_lang('AddNewBookingPeriod'));
  140. api_display_tool_title(get_lang('AddNewBookingPeriod'));
  141. ob_start();
  142. $cats = Rsys :: get_category_rights();
  143. echo '<form id="cat_form" action="m_reservation.php" method="get">';
  144. echo '<input type="hidden" name="action" value="add"/>';
  145. echo '<div class="row">';
  146. echo '<div class="label">'.get_lang('ResourceType').': </div>';
  147. echo '<div class="formw">';
  148. echo '<select name="cat_id" onchange="this.form.submit();">';
  149. echo '<option value="0">&nbsp;</option>';
  150. foreach ($cats as $catid => $cat)
  151. echo '<option value="'.$catid.'"'. ($catid == $_GET['cat_id'] ? ' selected="selected"' : '').'>'.$cat.'</option>';
  152. echo '</select></div>';
  153. echo '</div></form>';
  154. $itemlist = Rsys :: get_cat_r_items($_GET['cat_id']);
  155. $form = new FormValidator('reservation', 'post', 'm_reservation.php?action=add&cat_id='.$_GET['cat_id']);
  156. $choices[] = $form->createElement('radio', 'forever', '', get_lang('NoPeriod'), 0, array ('onclick' => 'javascript:window_hide(\'forever_timewindow\')'));
  157. $choices[] = $form->createElement('radio', 'forever', '', get_lang('FixedPeriod'), 1 , array ('onclick' => 'javascript:window_show(\'forever_timewindow\')'));
  158. $form->addElement('select', 'itemid', get_lang('Resource'), $itemlist);
  159. $form->add_timewindow('start', 'end', get_lang('StartDate'), get_lang('EndDate'));
  160. $form->addElement('html', '<div class="row"><div class="label"></div><div class="formw">'.get_lang('TimePickerLimitation').'</div></div><br />');
  161. $form->addElement('text', 'maxuser', get_lang('MaxUsers'));
  162. $form->addElement('html', '<div class="row"><div class="label"></div><div class="formw">'.get_lang('TimePickerMaxUsers').'</div></div><br />');
  163. $form->addGroup($choices, null, get_lang('SubscriptionPeriod'), '<br />', false);
  164. $form->addElement('html', '<div style="margin-left:25px;display:block;" id="forever_timewindow">');
  165. $form->add_timewindow('subscribe_from', 'subscribe_until', '', '');
  166. $form->addElement('html', '</div>');
  167. $form->addElement('checkbox', 'auto_accept', get_lang('AutoAccept'));
  168. //$form->addElement('checkbox', 'timepicker', get_lang('TimePicker'));
  169. $timepicker_arr[] = $form->createElement('radio', 'timepicker', '', get_lang('NoTimePicker'), 0, array ('onclick' => 'javascript:window_hide(\'timepicker_timewindow\')'));
  170. $timepicker_arr[] = $form->createElement('radio', 'timepicker', '', get_lang('TimePicker'), 1 , array ('onclick' => 'javascript:window_show(\'timepicker_timewindow\')'));
  171. $form->addGroup($timepicker_arr, null, get_lang('TimePicker'), '<br />', false);
  172. $form->addElement('html', '<div style="margin-left:25px;display:block;" id="timepicker_timewindow">');
  173. $min_arr = array();
  174. //todo this will be fixed
  175. $min_arr[10] = 10;
  176. $min_arr[20] = 20;
  177. $min_arr[30] = 30;
  178. $min_arr[40] = 40;
  179. $min_arr[50] = 50;
  180. $min_arr[60] = 60;
  181. for ($i = 0; $i < 1441; $i++) {
  182. //$min_arr[$i] = $i;
  183. }
  184. $max_arr = $min_arr;
  185. $form->addElement('select',min,get_lang('Minimum'),$min_arr);
  186. $form->addElement('select',max,get_lang('Maximum'),$max_arr);
  187. $form->addElement('html', '<div class="row"><div class="label"></div><div class="formw">'.get_lang('TimePickerMinMaxNull').'</div></div><br />');
  188. $form->addElement('html', '</div>');
  189. $recurrence[] = $form->createElement('radio', 'recurrence_c', '', get_lang('NoRecurrence'), 0, array ('onclick' => 'javascript:window_hide(\'recurrence_timewindow\')'));
  190. $recurrence[] = $form->createElement('radio', 'recurrence_c', '', get_lang('UntilRecurrence'), 1 , array ('onclick' => 'javascript:window_show(\'recurrence_timewindow\')'));
  191. $form->addGroup($recurrence, null, get_lang('Recurrence'), '<br />', false);
  192. $form->addElement('html', '<div style="margin-left:25px;display:block;" id="recurrence_timewindow">');
  193. $list_time = Rsys:: recurrence_list();
  194. $period[] = $form->createElement('text','repeater','',array('size'=>'3'));
  195. $period[] = $form->createElement('select','recurrence_selector','',$list_time);
  196. $form->addGroup($period, null, get_lang('RepeatFor'), ' ', false);
  197. $form->add_datepicker('recurrence_until',get_lang('RepeatUntil'));
  198. $form->addElement('html', '</div>');
  199. $form->addElement('textarea', 'notes', get_lang('Notes'), array ('cols' => 40, 'rows' => 4));
  200. $form->addElement('style_submit_button', 'submit', get_lang('AddNewBookingPeriod'),'class="add"');
  201. $str='';
  202. if(!$_POST['forever']) $str.="window_hide('forever_timewindow');";
  203. if(!$_POST['recurrence_c']) $str.="window_hide('recurrence_timewindow');";
  204. if(!$_POST['timepicker']) $str.="window_hide('timepicker_timewindow');";
  205. $form->addElement('html', "<script type=\"text/javascript\">
  206. /* <![CDATA[ */
  207. ".$str."
  208. function window_show(item) {
  209. el = document.getElementById(item);
  210. el.style.display='';
  211. }
  212. function window_hide(item) {
  213. el = document.getElementById(item);
  214. el.style.display='none';
  215. }
  216. /* ]]> */
  217. </script>\n");
  218. if (count($itemlist) > 0) {
  219. // here we set the default start and end time that we will see in the form 1h 30m after now()
  220. // 1h after now
  221. $date_defaults_start = array(
  222. 'd' => date('d'),
  223. 'F' => date('n'),
  224. 'Y' => date('Y'),
  225. 'H' => date('H',time()+60*60),
  226. 'i' => '00'
  227. );
  228. //2h after now
  229. $date_defaults_end = array(
  230. 'd' => date('d'),
  231. 'F' => date('n'),
  232. 'Y' => date('Y'),
  233. 'H' => date('H',time()+60*60*2),
  234. 'i' => '00'
  235. );
  236. // 1h after now
  237. $date_defaults_start_sub = array(
  238. 'd' => date('d'),
  239. 'F' => date('n'),
  240. 'Y' => date('Y'),
  241. 'H' => date('H',time()-60*60),
  242. 'i' => '00'
  243. );
  244. //2h after now
  245. $date_defaults_end_sub = array(
  246. 'd' => date('d'),
  247. 'F' => date('n'),
  248. 'Y' => date('Y'),
  249. 'H' => date('H',time()),
  250. 'i' => '00'
  251. );
  252. $defaultvalues['start'] = $date_defaults_start;
  253. $defaultvalues['end'] = $date_defaults_end;
  254. $defaultvalues['subscribe_from'] = $date_defaults_start_sub;
  255. $defaultvalues['subscribe_until'] = $date_defaults_end_sub;
  256. $defaultvalues['recurrence_until'] = $date_defaults_end;
  257. $defaultvalues['recurrence_c'] = '0';
  258. $defaultvalues['forever'] = '0';
  259. $defaultvalues['timepicker'] = '0';
  260. $defaultvalues['maxuser'] = '1';
  261. $defaultvalues['repeater'] = '1';
  262. $defaultvalues['auto_accept'] = '1';
  263. $form->setDefaults($defaultvalues);
  264. $form->Display();
  265. } else {
  266. if ($_GET['cat_id'] != 0)
  267. Display :: display_normal_message(get_lang('NoItems'),false);
  268. }
  269. $buffer = ob_get_contents();
  270. ob_end_clean();
  271. if ($form->validate()) {
  272. $values = $form->exportValues();
  273. if ($values['forever'] == 0) {
  274. $values['subscribe_from'] = 0;
  275. $values['subscribe_until'] = 0;
  276. }
  277. $msg_number = Rsys :: add_reservation($values['itemid'], $values['auto_accept'], $values['maxuser'], $values['start'], $values['end'], $values['subscribe_from'], $values['subscribe_until'], $values['notes'], $values['timepicker'],$values['min'],$values['max'],0);
  278. switch($msg_number) {
  279. case 0 :
  280. Display :: display_normal_message(Rsys :: get_return_msg(get_lang('BookingPeriodAdded'), "m_reservation.php", $tool_name),false);
  281. break;
  282. case 1 :
  283. Display :: display_normal_message(str_replace('#END#', "<b>".$GLOBALS['end_date']."</b>",str_replace('#START#', "<b>".$GLOBALS['start_date']."</b>",get_lang('BookingPeriodDateOverlap'))),false);
  284. break;
  285. case 2 :
  286. Display :: display_normal_message(get_lang('BookingPeriodSubscribeUntilAfterStart'),false);
  287. break;
  288. case 3:
  289. Display :: display_normal_message(get_lang('BookingPeriodPast'),false);
  290. break;
  291. case 4:
  292. Display :: display_normal_message(get_lang('BookingPeriodTimePickerLimitation'),false);
  293. break;
  294. case 5:
  295. Display :: display_normal_message(get_lang('BookingPeriodTimePickerError1'),false);
  296. break;
  297. case 6:
  298. Display :: display_normal_message(get_lang('BookingPeriodTimePickerError2'),false);
  299. break;
  300. case 7:
  301. Display :: display_normal_message(get_lang('BookingPeriodTimePickerError3'),false);
  302. break;
  303. default :
  304. break;
  305. }
  306. }
  307. if($_POST['recurrence_c'] && $msg_number == 0){
  308. $Inserted_id = mysql_insert_id();
  309. $recurrence_date_start = Rsys :: mysql_datetime_to_timestamp($values['start']);
  310. $recurrence_date_end = Rsys :: mysql_datetime_to_timestamp($values['end']);
  311. $recurrence_period_end = Rsys :: mysql_datetime_to_timestamp($values['recurrence_until']);
  312. $recurrence_subscribe_from = Rsys :: mysql_datetime_to_timestamp($values['subscribe_from']);
  313. $count = 0;
  314. $recurrence_date_start = $recurrence_date_start + (60 * 60 * 24 * $values['repeater'] * $values['recurrence_selector']);
  315. $recurrence_date_end = $recurrence_date_end + (60 * 60 * 24 * $values['repeater'] * $values['recurrence_selector']);
  316. while($recurrence_date_end < $recurrence_period_end){
  317. if ($values['forever'] == 0) {
  318. $recurrence_subscribe_from = 0;
  319. $recurrence_subscribe_until = 0;
  320. }else{
  321. $recurrence_subscribe_from = $recurrence_subscribe_from + (60 * 60 * 24 * $values['repeater'] * $values['recurrence_selector']);
  322. $recurrence_subscribe_until = $recurrence_subscribe_until + (60 * 60 * 24 * $values['repeater'] * $values['recurrence_selector']);
  323. }
  324. $errors[]=Rsys :: add_reservation($values['itemid'], $values['auto_accept'], $values['maxuser'], Rsys :: timestamp_to_datetime($recurrence_date_start), Rsys :: timestamp_to_datetime($recurrence_date_end), $values['forever'] == 0 ? 0 : Rsys :: timestamp_to_datetime($recurrence_subscribe_from), $values['forever'] == 0 ? 0 : Rsys :: timestamp_to_datetime($recurrence_subscribe_until), $values['notes'], $values['timepicker'],$values['min'],$values['max'],$Inserted_id);
  325. if($errors[$count] <> 0){
  326. $msg .= str_replace('#START#', "<b>".Rsys :: timestamp_to_datetime($recurrence_date_start)."</b>",str_replace('#END#', "<b>".Rsys :: timestamp_to_datetime($recurrence_date_end)."</b>",get_lang('ReservationFromUntilError')));
  327. }
  328. $count++;
  329. $recurrence_date_start = $recurrence_date_start + (60 * 60 * 24 * $values['repeater'] * $values['recurrence_selector']);
  330. $recurrence_date_end = $recurrence_date_end + (60 * 60 * 24 * $values['repeater'] * $values['recurrence_selector']);
  331. }
  332. }
  333. if(!empty ($msg))
  334. Display :: display_normal_message($msg);
  335. echo $buffer;
  336. break;
  337. case 'edit' :
  338. if (isset ($_GET["id"]))
  339. $Reservation_id = $_GET["id"];
  340. else
  341. $Reservation_id = $_POST["id"];
  342. $result = Rsys :: get_num_subscriptions_ReservationPeriods($Reservation_id);
  343. if($result != '0')
  344. {
  345. $interbreadcrumb[] = array ("url" => "mysubscriptions.php", "name" => get_lang('Booking'));
  346. $interbreadcrumb[] = array ("url" => "m_reservation.php", "name" => get_lang('ManageBookingPeriods'));
  347. Display :: display_header('');
  348. api_display_tool_title($tool_name);
  349. Display :: display_normal_message(Rsys :: get_return_msg(str_replace('#NUM#', $result, get_lang('BookingPeriodHasSubscriptions')),"m_reservation.php",get_lang('BookingPeriodList')),false);
  350. }
  351. else
  352. {
  353. $interbreadcrumb[] = array ("url" => "mysubscriptions.php", "name" => get_lang('Booking'));
  354. $interbreadcrumb[] = array ("url" => "m_reservation.php", "name" => get_lang('ManageBookingPeriods'));
  355. Display :: display_header(get_lang('EditBookingPeriod'));
  356. api_display_tool_title(get_lang('EditNewBookingPeriod'));
  357. $reservation = Rsys :: get_reservation($Reservation_id);
  358. $item_category = Rsys :: get_item($reservation[0][2]);
  359. $categori = Rsys :: get_category($item_category[1]);
  360. $cats = Rsys :: get_category_rights();
  361. $tijdelijke_cat = $categori[0];
  362. if (isset ($_GET['cat_id']))
  363. $categori[0] = $_GET['cat_id'];
  364. ob_start();
  365. echo '<form id="cat_form" action="m_reservation.php" method="get">';
  366. echo '<input type="hidden" name="id" value="'.$Reservation_id.'" />';
  367. echo '<input type="hidden" name="action" value="edit"/>';
  368. echo '<div class="row">';
  369. echo '<div class="label">'.get_lang('ResourceType').': </div>';
  370. echo '<div class="formw">';
  371. echo '<select name="cat_id" onchange="this.form.submit();">';
  372. echo '<option value="0">&nbsp;</option>';
  373. foreach ($cats as $catid => $cat)
  374. echo '<option value="'.$catid.'"'. ($catid == $categori[0] ? ' selected="selected"' : '').'>'.$cat.'</option>';
  375. echo '</select></div>';
  376. echo '</div>';
  377. echo '</form>';
  378. $itemlist = Rsys :: get_cat_r_items($categori[0]);
  379. $form = new FormValidator('reservation', 'post', 'm_reservation.php?action=edit&id='.$Reservation_id);
  380. $choices[] = $form->createElement('radio', 'forever', '', get_lang('NoPeriod'), '0', array ('onclick' => 'javascript:timewindow_hide(\'forever_timewindow\')'));
  381. $choices[] = $form->createElement('radio', 'forever', '', get_lang('FixedPeriod'), '1', array ('onclick' => 'javascript:timewindow_show(\'forever_timewindow\')'));
  382. $form->addElement('select', 'item_id', get_lang('Resource'), $itemlist);
  383. $form->add_timewindow('start', 'end', get_lang('StartDate'), get_lang('EndDate'));
  384. $form->addElement('html', '<div class="row"><div class="label"></div><div class="formw">'.get_lang('TimePickerLimitation').'</div></div><br />');
  385. $form->addElement('text', 'maxuser', get_lang('MaxUsers'));
  386. $form->addGroup($choices, null, get_lang('SubscriptionPeriod'), '<br />', false);
  387. $form->addElement('html', '<div style="margin-left:25px;display:block;" id="forever_timewindow">');
  388. $form->add_timewindow('subscribe_from', 'subscribe_until', '', '');
  389. $form->addElement('html', '</div>');
  390. $form->addElement('html', "<script type=\"text/javascript\">
  391. /* <![CDATA[ */
  392. ". ($reservation[0][7] == '0000-00-00 00:00:00' && $reservation[0][8] == '0000-00-00 00:00:00' ? "timewindow_hide('forever_timewindow');" : "")."
  393. function timewindow_show(item) {
  394. el = document.getElementById(item);
  395. el.style.display='';
  396. }
  397. function timewindow_hide(item) {
  398. el = document.getElementById(item);
  399. el.style.display='none';
  400. }
  401. /* ]]> */
  402. </script>\n");
  403. $form->addElement('checkbox', 'auto_accept', get_lang('AutoAccept'));
  404. $form->addElement('checkbox', 'timepicker', get_lang('TimePicker'),'',array('disabled'=>'disabled'));
  405. $form->addElement('textarea', 'notes', get_lang('Notes'), array ('cols' => 40, 'rows' => 4));
  406. $form->addElement('style_submit_button', 'submit', get_lang('EditNewBookingPeriod'),'class="save"');
  407. $form->addElement('hidden', 'id', $Reservation_id);
  408. $form->addElement('hidden', 'timepicker2');
  409. $form->addElement('hidden', 'period', ($reservation[0][7] == '0000-00-00 00:00:00' && $reservation[0][8] == '0000-00-00 00:00:00' ? 0 : 1));
  410. if ($categori[0] == $tijdelijke_cat)
  411. $defaultvalues['item_id'] = $reservation[0][2];
  412. $defaultvalues['auto_accept'] = $reservation[0][3];
  413. $defaultvalues['maxuser'] = $reservation[0][4];
  414. $defaultvalues['start'] = $reservation[0][5];
  415. $defaultvalues['end'] = $reservation[0][6];
  416. $defaultvalues['forever']=($reservation[0][7] == '0000-00-00 00:00:00' && $reservation[0][8] == '0000-00-00 00:00:00' ? 0 : 1);
  417. $my_start_date = Rsys :: mysql_datetime_to_timestamp($reservation[0][5]);
  418. if ($defaultvalues['forever']==0) {
  419. //here we set the default dates
  420. $defaultvalues['subscribe_from'] = $my_start_date - 60*60 ;
  421. $defaultvalues['subscribe_until'] = $my_start_date - 60 ;
  422. }
  423. else {
  424. $defaultvalues['subscribe_from'] = $reservation[0][7];
  425. $defaultvalues['subscribe_until'] = $reservation[0][8];
  426. }
  427. $defaultvalues['notes'] = $reservation[0][10];
  428. $defaultvalues['timepicker'] = $reservation[0][11];
  429. $defaultvalues['timepicker2'] = $reservation[0][11];
  430. $form->setDefaults($defaultvalues);
  431. if (count($reservation) > 0) {
  432. $form->Display();
  433. } else {
  434. Display :: display_normal_message(get_lang('NoItems'),false);
  435. }
  436. $buffer = ob_get_contents();
  437. ob_end_clean();
  438. if ($form->validate()) {
  439. $values = $form->exportValues();
  440. //print_r($values);
  441. $auto_accept = true;
  442. if (($values['forever'] == $values['period']) || $values['forever']=='0') {
  443. $values['subscribe_from'] = 0;
  444. $values['subscribe_until'] = 0;
  445. }
  446. $msg_number = Rsys :: edit_reservation($values['id'], $_POST['item_id'], $values['auto_accept'], $values['maxuser'], $values['start'], $values['end'], $values['subscribe_from'], $values['subscribe_until'], $values['notes'], $values['timepicker2']);
  447. switch ($msg_number) {
  448. case 0 :
  449. Display :: display_normal_message(Rsys :: get_return_msg(get_lang('BookingPeriodEdited'), "m_reservation.php", $tool_name),false);
  450. break;
  451. case 1 :
  452. Display :: display_normal_message(str_replace('#END#', "<b>".$GLOBALS['end_date']."</b>",str_replace('#START#', "<b>".$GLOBALS['start_date']."</b>",get_lang('BookingPeriodDateOverlap'))),false);
  453. break;
  454. case 2 :
  455. Display :: display_normal_message(get_lang('BookingPeriodSubscribeUntilAfterStart'),false);
  456. break;
  457. case 3:
  458. Display :: display_normal_message(get_lang('ReservationMaxUsersOverrun'),false);
  459. break;
  460. case 4:
  461. Display :: display_normal_message(get_lang('BookingPeriodTimepickerLimitation'),false);
  462. break;
  463. default :
  464. break;
  465. }
  466. }
  467. echo $buffer;
  468. }
  469. break;
  470. case 'delete' :
  471. Rsys :: delete_reservation($_GET["id"]);
  472. ob_start();
  473. Display :: display_normal_message(Rsys :: get_return_msg(get_lang('BookingPeriodDeleted'), "m_reservation.php", $tool_name),false);
  474. $msg = ob_get_contents();
  475. ob_end_clean();
  476. default :
  477. $NoSearchResults = get_lang('NoReservations');
  478. if ($_GET['view']=='calendar') {
  479. $interbreadcrumb[] = array ("url" => "reservation.php", "name" => get_lang('Booking'));
  480. }
  481. else {
  482. $interbreadcrumb[] = array ("url" => "mysubscriptions.php", "name" => get_lang('Booking'));
  483. }
  484. $interbreadcrumb[] = array ("url" => "m_reservation.php", "name" => get_lang('ManageBookingPeriods'));
  485. Display :: display_header('');
  486. api_display_tool_title($tool_name);
  487. echo '<form id="cat_form" action="m_reservation.php" method="get">';
  488. echo '<div class="actions">';
  489. echo '<a href="m_reservation.php?action=add"><img src="../img/view_more_stats.gif" border="0" alt="" title="'.get_lang('AddNewBookingPeriod').'"/>'.get_lang('AddNewBookingPeriod').'</a>';
  490. echo '&nbsp;&nbsp;&nbsp;<a href="m_reservation.php?action=overviewsubscriptions">'.get_lang('OverviewReservedPeriods').'</a>';
  491. echo '</div>';
  492. echo '<div style="text-align: right; "><input type="text" name="keyword" /><button type="submit" class="search" value="'.get_lang('Search').'" >'.get_lang('Search').'</button></div></form>';
  493. echo '<br>';
  494. if (isset ($_POST['action'])) {
  495. switch ($_POST['action']) {
  496. case 'delete_reservations' :
  497. $ids = $_POST['reservations'];
  498. if (count($ids) > 0) {
  499. foreach ($ids as $index => $id)
  500. Rsys :: delete_reservation($id);
  501. }
  502. break;
  503. }
  504. }
  505. $table = new SortableTable('reservation', array ('Rsys', 'get_num_reservations'), array ('Rsys', 'get_table_reservations'), 1);
  506. $table->set_additional_parameters(array ('keyword' => $_GET['keyword']));
  507. $table->set_header(0, '', false, array ('style' => 'width:10px'));
  508. $table->set_header(1, get_lang('ResourceName'), true);
  509. $table->set_header(2, get_lang('StartDate'), true);
  510. $table->set_header(3, get_lang('EndDate'), true);
  511. $table->set_header(4, get_lang('SubscribeFrom'), true);
  512. $table->set_header(5, get_lang('SubscribeUntil'), true);
  513. $table->set_header(6, get_lang('Subscribers'), true);
  514. $table->set_header(7, get_lang('Notes'), false);
  515. $table->set_header(8, '', false, array ('style' => 'width:65px;'));
  516. $table->set_column_filter(8, 'modify_filter');
  517. $table->set_form_actions(array ('delete_reservations' => get_lang('DeleteSelectedBookingPeriod')), 'reservations');
  518. $table->display();
  519. }
  520. /**
  521. ---------------------------------------------------------------------
  522. */
  523. Display :: display_footer();
  524. ?>