@@ -18,11 +18,11 @@ discard block |
||
18 | 18 | |
19 | 19 | api_protect_admin_script(true); |
20 | 20 | |
21 | -$formSent=0; |
|
22 | -$errorMsg=''; |
|
21 | +$formSent = 0; |
|
22 | +$errorMsg = ''; |
|
23 | 23 | //$interbreadcrumb[]=array('url' => 'index.php',"name" => get_lang('PlatformAdmin')); |
24 | -$interbreadcrumb[] = array('url' => 'session_list.php','name' => get_lang('SessionList')); |
|
25 | -$interbreadcrumb[] = array('url' => "session_category_list.php","name" => get_lang('ListSessionCategory')); |
|
24 | +$interbreadcrumb[] = array('url' => 'session_list.php', 'name' => get_lang('SessionList')); |
|
25 | +$interbreadcrumb[] = array('url' => "session_category_list.php", "name" => get_lang('ListSessionCategory')); |
|
26 | 26 | |
27 | 27 | // Database Table Definitions |
28 | 28 | $tbl_user = Database::get_main_table(TABLE_MAIN_USER); |
@@ -61,7 +61,7 @@ discard block |
||
61 | 61 | //display the header |
62 | 62 | Display::display_header($tool_name); |
63 | 63 | if (!empty($return)) { |
64 | - Display::display_error_message($return,false); |
|
64 | + Display::display_error_message($return, false); |
|
65 | 65 | } |
66 | 66 | ?> |
67 | 67 | <div class="row"> |
@@ -72,13 +72,13 @@ discard block |
||
72 | 72 | <div class="form-group"> |
73 | 73 | <label class="col-sm-3 control-label"><?php echo get_lang('SessionCategoryName') ?></label> |
74 | 74 | <div class="col-sm-6"> |
75 | - <input type="text" class="form-control" name="name" placeholder="<?php echo get_lang('Category') ?>" size="50" maxlength="50" value="<?php if($formSent) echo api_htmlentities($name,ENT_QUOTES,$charset); ?>"> |
|
75 | + <input type="text" class="form-control" name="name" placeholder="<?php echo get_lang('Category') ?>" size="50" maxlength="50" value="<?php if ($formSent) echo api_htmlentities($name, ENT_QUOTES, $charset); ?>"> |
|
76 | 76 | </div> |
77 | 77 | <div class="col-md-3"></div> |
78 | 78 | </div> |
79 | 79 | <div class="form-group"> |
80 | 80 | <div class="col-sm-offset-3 col-sm-6"> |
81 | - <?php echo get_lang('TheTimeLimitsAreReferential');?> <a href="javascript://" onclick="if(document.getElementById('options').style.display == 'none'){document.getElementById('options').style.display = 'block';}else{document.getElementById('options').style.display = 'none';}"><?php echo get_lang('AddTimeLimit') ?></a> |
|
81 | + <?php echo get_lang('TheTimeLimitsAreReferential'); ?> <a href="javascript://" onclick="if(document.getElementById('options').style.display == 'none'){document.getElementById('options').style.display = 'block';}else{document.getElementById('options').style.display = 'none';}"><?php echo get_lang('AddTimeLimit') ?></a> |
|
82 | 82 | </div> |
83 | 83 | <div class="col-md-3"></div> |
84 | 84 | </div> |
@@ -90,58 +90,58 @@ discard block |
||
90 | 90 | <div class="col-sm-6"> |
91 | 91 | <select name="day_start"> |
92 | 92 | <option value="1">01</option> |
93 | - <option value="2" <?php if((!$formSent && $thisDay == 2) || ($formSent && $day_start == 2)) echo 'selected="selected"'; ?> >02</option> |
|
94 | - <option value="3" <?php if((!$formSent && $thisDay == 3) || ($formSent && $day_start == 3)) echo 'selected="selected"'; ?> >03</option> |
|
95 | - <option value="4" <?php if((!$formSent && $thisDay == 4) || ($formSent && $day_start == 4)) echo 'selected="selected"'; ?> >04</option> |
|
96 | - <option value="5" <?php if((!$formSent && $thisDay == 5) || ($formSent && $day_start == 5)) echo 'selected="selected"'; ?> >05</option> |
|
97 | - <option value="6" <?php if((!$formSent && $thisDay == 6) || ($formSent && $day_start == 6)) echo 'selected="selected"'; ?> >06</option> |
|
98 | - <option value="7" <?php if((!$formSent && $thisDay == 7) || ($formSent && $day_start == 7)) echo 'selected="selected"'; ?> >07</option> |
|
99 | - <option value="8" <?php if((!$formSent && $thisDay == 8) || ($formSent && $day_start == 8)) echo 'selected="selected"'; ?> >08</option> |
|
100 | - <option value="9" <?php if((!$formSent && $thisDay == 9) || ($formSent && $day_start == 9)) echo 'selected="selected"'; ?> >09</option> |
|
101 | - <option value="10" <?php if((!$formSent && $thisDay == 10) || ($formSent && $day_start == 10)) echo 'selected="selected"'; ?> >10</option> |
|
102 | - <option value="11" <?php if((!$formSent && $thisDay == 11) || ($formSent && $day_start == 11)) echo 'selected="selected"'; ?> >11</option> |
|
103 | - <option value="12" <?php if((!$formSent && $thisDay == 12) || ($formSent && $day_start == 12)) echo 'selected="selected"'; ?> >12</option> |
|
104 | - <option value="13" <?php if((!$formSent && $thisDay == 13) || ($formSent && $day_start == 13)) echo 'selected="selected"'; ?> >13</option> |
|
105 | - <option value="14" <?php if((!$formSent && $thisDay == 14) || ($formSent && $day_start == 14)) echo 'selected="selected"'; ?> >14</option> |
|
106 | - <option value="15" <?php if((!$formSent && $thisDay == 15) || ($formSent && $day_start == 15)) echo 'selected="selected"'; ?> >15</option> |
|
107 | - <option value="16" <?php if((!$formSent && $thisDay == 16) || ($formSent && $day_start == 16)) echo 'selected="selected"'; ?> >16</option> |
|
108 | - <option value="17" <?php if((!$formSent && $thisDay == 17) || ($formSent && $day_start == 17)) echo 'selected="selected"'; ?> >17</option> |
|
109 | - <option value="18" <?php if((!$formSent && $thisDay == 18) || ($formSent && $day_start == 18)) echo 'selected="selected"'; ?> >18</option> |
|
110 | - <option value="19" <?php if((!$formSent && $thisDay == 19) || ($formSent && $day_start == 19)) echo 'selected="selected"'; ?> >19</option> |
|
111 | - <option value="20" <?php if((!$formSent && $thisDay == 20) || ($formSent && $day_start == 20)) echo 'selected="selected"'; ?> >20</option> |
|
112 | - <option value="21" <?php if((!$formSent && $thisDay == 21) || ($formSent && $day_start == 21)) echo 'selected="selected"'; ?> >21</option> |
|
113 | - <option value="22" <?php if((!$formSent && $thisDay == 22) || ($formSent && $day_start == 22)) echo 'selected="selected"'; ?> >22</option> |
|
114 | - <option value="23" <?php if((!$formSent && $thisDay == 23) || ($formSent && $day_start == 23)) echo 'selected="selected"'; ?> >23</option> |
|
115 | - <option value="24" <?php if((!$formSent && $thisDay == 24) || ($formSent && $day_start == 24)) echo 'selected="selected"'; ?> >24</option> |
|
116 | - <option value="25" <?php if((!$formSent && $thisDay == 25) || ($formSent && $day_start == 25)) echo 'selected="selected"'; ?> >25</option> |
|
117 | - <option value="26" <?php if((!$formSent && $thisDay == 26) || ($formSent && $day_start == 26)) echo 'selected="selected"'; ?> >26</option> |
|
118 | - <option value="27" <?php if((!$formSent && $thisDay == 27) || ($formSent && $day_start == 27)) echo 'selected="selected"'; ?> >27</option> |
|
119 | - <option value="28" <?php if((!$formSent && $thisDay == 28) || ($formSent && $day_start == 28)) echo 'selected="selected"'; ?> >28</option> |
|
120 | - <option value="29" <?php if((!$formSent && $thisDay == 29) || ($formSent && $day_start == 29)) echo 'selected="selected"'; ?> >29</option> |
|
121 | - <option value="30" <?php if((!$formSent && $thisDay == 30) || ($formSent && $day_start == 30)) echo 'selected="selected"'; ?> >30</option> |
|
122 | - <option value="31" <?php if((!$formSent && $thisDay == 31) || ($formSent && $day_start == 31)) echo 'selected="selected"'; ?> >31</option> |
|
93 | + <option value="2" <?php if ((!$formSent && $thisDay == 2) || ($formSent && $day_start == 2)) echo 'selected="selected"'; ?> >02</option> |
|
94 | + <option value="3" <?php if ((!$formSent && $thisDay == 3) || ($formSent && $day_start == 3)) echo 'selected="selected"'; ?> >03</option> |
|
95 | + <option value="4" <?php if ((!$formSent && $thisDay == 4) || ($formSent && $day_start == 4)) echo 'selected="selected"'; ?> >04</option> |
|
96 | + <option value="5" <?php if ((!$formSent && $thisDay == 5) || ($formSent && $day_start == 5)) echo 'selected="selected"'; ?> >05</option> |
|
97 | + <option value="6" <?php if ((!$formSent && $thisDay == 6) || ($formSent && $day_start == 6)) echo 'selected="selected"'; ?> >06</option> |
|
98 | + <option value="7" <?php if ((!$formSent && $thisDay == 7) || ($formSent && $day_start == 7)) echo 'selected="selected"'; ?> >07</option> |
|
99 | + <option value="8" <?php if ((!$formSent && $thisDay == 8) || ($formSent && $day_start == 8)) echo 'selected="selected"'; ?> >08</option> |
|
100 | + <option value="9" <?php if ((!$formSent && $thisDay == 9) || ($formSent && $day_start == 9)) echo 'selected="selected"'; ?> >09</option> |
|
101 | + <option value="10" <?php if ((!$formSent && $thisDay == 10) || ($formSent && $day_start == 10)) echo 'selected="selected"'; ?> >10</option> |
|
102 | + <option value="11" <?php if ((!$formSent && $thisDay == 11) || ($formSent && $day_start == 11)) echo 'selected="selected"'; ?> >11</option> |
|
103 | + <option value="12" <?php if ((!$formSent && $thisDay == 12) || ($formSent && $day_start == 12)) echo 'selected="selected"'; ?> >12</option> |
|
104 | + <option value="13" <?php if ((!$formSent && $thisDay == 13) || ($formSent && $day_start == 13)) echo 'selected="selected"'; ?> >13</option> |
|
105 | + <option value="14" <?php if ((!$formSent && $thisDay == 14) || ($formSent && $day_start == 14)) echo 'selected="selected"'; ?> >14</option> |
|
106 | + <option value="15" <?php if ((!$formSent && $thisDay == 15) || ($formSent && $day_start == 15)) echo 'selected="selected"'; ?> >15</option> |
|
107 | + <option value="16" <?php if ((!$formSent && $thisDay == 16) || ($formSent && $day_start == 16)) echo 'selected="selected"'; ?> >16</option> |
|
108 | + <option value="17" <?php if ((!$formSent && $thisDay == 17) || ($formSent && $day_start == 17)) echo 'selected="selected"'; ?> >17</option> |
|
109 | + <option value="18" <?php if ((!$formSent && $thisDay == 18) || ($formSent && $day_start == 18)) echo 'selected="selected"'; ?> >18</option> |
|
110 | + <option value="19" <?php if ((!$formSent && $thisDay == 19) || ($formSent && $day_start == 19)) echo 'selected="selected"'; ?> >19</option> |
|
111 | + <option value="20" <?php if ((!$formSent && $thisDay == 20) || ($formSent && $day_start == 20)) echo 'selected="selected"'; ?> >20</option> |
|
112 | + <option value="21" <?php if ((!$formSent && $thisDay == 21) || ($formSent && $day_start == 21)) echo 'selected="selected"'; ?> >21</option> |
|
113 | + <option value="22" <?php if ((!$formSent && $thisDay == 22) || ($formSent && $day_start == 22)) echo 'selected="selected"'; ?> >22</option> |
|
114 | + <option value="23" <?php if ((!$formSent && $thisDay == 23) || ($formSent && $day_start == 23)) echo 'selected="selected"'; ?> >23</option> |
|
115 | + <option value="24" <?php if ((!$formSent && $thisDay == 24) || ($formSent && $day_start == 24)) echo 'selected="selected"'; ?> >24</option> |
|
116 | + <option value="25" <?php if ((!$formSent && $thisDay == 25) || ($formSent && $day_start == 25)) echo 'selected="selected"'; ?> >25</option> |
|
117 | + <option value="26" <?php if ((!$formSent && $thisDay == 26) || ($formSent && $day_start == 26)) echo 'selected="selected"'; ?> >26</option> |
|
118 | + <option value="27" <?php if ((!$formSent && $thisDay == 27) || ($formSent && $day_start == 27)) echo 'selected="selected"'; ?> >27</option> |
|
119 | + <option value="28" <?php if ((!$formSent && $thisDay == 28) || ($formSent && $day_start == 28)) echo 'selected="selected"'; ?> >28</option> |
|
120 | + <option value="29" <?php if ((!$formSent && $thisDay == 29) || ($formSent && $day_start == 29)) echo 'selected="selected"'; ?> >29</option> |
|
121 | + <option value="30" <?php if ((!$formSent && $thisDay == 30) || ($formSent && $day_start == 30)) echo 'selected="selected"'; ?> >30</option> |
|
122 | + <option value="31" <?php if ((!$formSent && $thisDay == 31) || ($formSent && $day_start == 31)) echo 'selected="selected"'; ?> >31</option> |
|
123 | 123 | </select> |
124 | 124 | / |
125 | 125 | <select name="month_start"> |
126 | 126 | <option value="1">01</option> |
127 | - <option value="2" <?php if((!$formSent && $thisMonth == 2) || ($formSent && $month_start == 2)) echo 'selected="selected"'; ?> >02</option> |
|
128 | - <option value="3" <?php if((!$formSent && $thisMonth == 3) || ($formSent && $month_start == 3)) echo 'selected="selected"'; ?> >03</option> |
|
129 | - <option value="4" <?php if((!$formSent && $thisMonth == 4) || ($formSent && $month_start == 4)) echo 'selected="selected"'; ?> >04</option> |
|
130 | - <option value="5" <?php if((!$formSent && $thisMonth == 5) || ($formSent && $month_start == 5)) echo 'selected="selected"'; ?> >05</option> |
|
131 | - <option value="6" <?php if((!$formSent && $thisMonth == 6) || ($formSent && $month_start == 6)) echo 'selected="selected"'; ?> >06</option> |
|
132 | - <option value="7" <?php if((!$formSent && $thisMonth == 7) || ($formSent && $month_start == 7)) echo 'selected="selected"'; ?> >07</option> |
|
133 | - <option value="8" <?php if((!$formSent && $thisMonth == 8) || ($formSent && $month_start == 8)) echo 'selected="selected"'; ?> >08</option> |
|
134 | - <option value="9" <?php if((!$formSent && $thisMonth == 9) || ($formSent && $month_start == 9)) echo 'selected="selected"'; ?> >09</option> |
|
135 | - <option value="10" <?php if((!$formSent && $thisMonth == 10) || ($formSent && $month_start == 10)) echo 'selected="selected"'; ?> >10</option> |
|
136 | - <option value="11" <?php if((!$formSent && $thisMonth == 11) || ($formSent && $month_start == 11)) echo 'selected="selected"'; ?> >11</option> |
|
137 | - <option value="12" <?php if((!$formSent && $thisMonth == 12) || ($formSent && $month_start == 12)) echo 'selected="selected"'; ?> >12</option> |
|
127 | + <option value="2" <?php if ((!$formSent && $thisMonth == 2) || ($formSent && $month_start == 2)) echo 'selected="selected"'; ?> >02</option> |
|
128 | + <option value="3" <?php if ((!$formSent && $thisMonth == 3) || ($formSent && $month_start == 3)) echo 'selected="selected"'; ?> >03</option> |
|
129 | + <option value="4" <?php if ((!$formSent && $thisMonth == 4) || ($formSent && $month_start == 4)) echo 'selected="selected"'; ?> >04</option> |
|
130 | + <option value="5" <?php if ((!$formSent && $thisMonth == 5) || ($formSent && $month_start == 5)) echo 'selected="selected"'; ?> >05</option> |
|
131 | + <option value="6" <?php if ((!$formSent && $thisMonth == 6) || ($formSent && $month_start == 6)) echo 'selected="selected"'; ?> >06</option> |
|
132 | + <option value="7" <?php if ((!$formSent && $thisMonth == 7) || ($formSent && $month_start == 7)) echo 'selected="selected"'; ?> >07</option> |
|
133 | + <option value="8" <?php if ((!$formSent && $thisMonth == 8) || ($formSent && $month_start == 8)) echo 'selected="selected"'; ?> >08</option> |
|
134 | + <option value="9" <?php if ((!$formSent && $thisMonth == 9) || ($formSent && $month_start == 9)) echo 'selected="selected"'; ?> >09</option> |
|
135 | + <option value="10" <?php if ((!$formSent && $thisMonth == 10) || ($formSent && $month_start == 10)) echo 'selected="selected"'; ?> >10</option> |
|
136 | + <option value="11" <?php if ((!$formSent && $thisMonth == 11) || ($formSent && $month_start == 11)) echo 'selected="selected"'; ?> >11</option> |
|
137 | + <option value="12" <?php if ((!$formSent && $thisMonth == 12) || ($formSent && $month_start == 12)) echo 'selected="selected"'; ?> >12</option> |
|
138 | 138 | </select> |
139 | 139 | / |
140 | 140 | <select name="year_start"> |
141 | 141 | <?php |
142 | - for ($i=$thisYear-5;$i <= ($thisYear+5);$i++) { |
|
142 | + for ($i = $thisYear - 5; $i <= ($thisYear + 5); $i++) { |
|
143 | 143 | ?> |
144 | - <option value="<?php echo $i; ?>" <?php if((!$formSent && $thisYear == $i) || ($formSent && $year_start == $i)) echo 'selected="selected"'; ?> ><?php echo $i; ?></option> |
|
144 | + <option value="<?php echo $i; ?>" <?php if ((!$formSent && $thisYear == $i) || ($formSent && $year_start == $i)) echo 'selected="selected"'; ?> ><?php echo $i; ?></option> |
|
145 | 145 | <?php |
146 | 146 | } |
147 | 147 | ?> |
@@ -206,7 +206,7 @@ discard block |
||
206 | 206 | <select name="year_end"> |
207 | 207 | <option value="0">----</option> |
208 | 208 | <?php |
209 | - for ($i=$thisYear-5;$i <= ($thisYear+5);$i++) { |
|
209 | + for ($i = $thisYear - 5; $i <= ($thisYear + 5); $i++) { |
|
210 | 210 | ?> |
211 | 211 | <option value="<?php echo $i; ?>"><?php echo $i; ?></option> |
212 | 212 | <?php |
@@ -72,7 +72,10 @@ discard block |
||
72 | 72 | <div class="form-group"> |
73 | 73 | <label class="col-sm-3 control-label"><?php echo get_lang('SessionCategoryName') ?></label> |
74 | 74 | <div class="col-sm-6"> |
75 | - <input type="text" class="form-control" name="name" placeholder="<?php echo get_lang('Category') ?>" size="50" maxlength="50" value="<?php if($formSent) echo api_htmlentities($name,ENT_QUOTES,$charset); ?>"> |
|
75 | + <input type="text" class="form-control" name="name" placeholder="<?php echo get_lang('Category') ?>" size="50" maxlength="50" value="<?php if($formSent) { |
|
76 | + echo api_htmlentities($name,ENT_QUOTES,$charset); |
|
77 | +} |
|
78 | +?>"> |
|
76 | 79 | </div> |
77 | 80 | <div class="col-md-3"></div> |
78 | 81 | </div> |
@@ -90,58 +93,184 @@ discard block |
||
90 | 93 | <div class="col-sm-6"> |
91 | 94 | <select name="day_start"> |
92 | 95 | <option value="1">01</option> |
93 | - <option value="2" <?php if((!$formSent && $thisDay == 2) || ($formSent && $day_start == 2)) echo 'selected="selected"'; ?> >02</option> |
|
94 | - <option value="3" <?php if((!$formSent && $thisDay == 3) || ($formSent && $day_start == 3)) echo 'selected="selected"'; ?> >03</option> |
|
95 | - <option value="4" <?php if((!$formSent && $thisDay == 4) || ($formSent && $day_start == 4)) echo 'selected="selected"'; ?> >04</option> |
|
96 | - <option value="5" <?php if((!$formSent && $thisDay == 5) || ($formSent && $day_start == 5)) echo 'selected="selected"'; ?> >05</option> |
|
97 | - <option value="6" <?php if((!$formSent && $thisDay == 6) || ($formSent && $day_start == 6)) echo 'selected="selected"'; ?> >06</option> |
|
98 | - <option value="7" <?php if((!$formSent && $thisDay == 7) || ($formSent && $day_start == 7)) echo 'selected="selected"'; ?> >07</option> |
|
99 | - <option value="8" <?php if((!$formSent && $thisDay == 8) || ($formSent && $day_start == 8)) echo 'selected="selected"'; ?> >08</option> |
|
100 | - <option value="9" <?php if((!$formSent && $thisDay == 9) || ($formSent && $day_start == 9)) echo 'selected="selected"'; ?> >09</option> |
|
101 | - <option value="10" <?php if((!$formSent && $thisDay == 10) || ($formSent && $day_start == 10)) echo 'selected="selected"'; ?> >10</option> |
|
102 | - <option value="11" <?php if((!$formSent && $thisDay == 11) || ($formSent && $day_start == 11)) echo 'selected="selected"'; ?> >11</option> |
|
103 | - <option value="12" <?php if((!$formSent && $thisDay == 12) || ($formSent && $day_start == 12)) echo 'selected="selected"'; ?> >12</option> |
|
104 | - <option value="13" <?php if((!$formSent && $thisDay == 13) || ($formSent && $day_start == 13)) echo 'selected="selected"'; ?> >13</option> |
|
105 | - <option value="14" <?php if((!$formSent && $thisDay == 14) || ($formSent && $day_start == 14)) echo 'selected="selected"'; ?> >14</option> |
|
106 | - <option value="15" <?php if((!$formSent && $thisDay == 15) || ($formSent && $day_start == 15)) echo 'selected="selected"'; ?> >15</option> |
|
107 | - <option value="16" <?php if((!$formSent && $thisDay == 16) || ($formSent && $day_start == 16)) echo 'selected="selected"'; ?> >16</option> |
|
108 | - <option value="17" <?php if((!$formSent && $thisDay == 17) || ($formSent && $day_start == 17)) echo 'selected="selected"'; ?> >17</option> |
|
109 | - <option value="18" <?php if((!$formSent && $thisDay == 18) || ($formSent && $day_start == 18)) echo 'selected="selected"'; ?> >18</option> |
|
110 | - <option value="19" <?php if((!$formSent && $thisDay == 19) || ($formSent && $day_start == 19)) echo 'selected="selected"'; ?> >19</option> |
|
111 | - <option value="20" <?php if((!$formSent && $thisDay == 20) || ($formSent && $day_start == 20)) echo 'selected="selected"'; ?> >20</option> |
|
112 | - <option value="21" <?php if((!$formSent && $thisDay == 21) || ($formSent && $day_start == 21)) echo 'selected="selected"'; ?> >21</option> |
|
113 | - <option value="22" <?php if((!$formSent && $thisDay == 22) || ($formSent && $day_start == 22)) echo 'selected="selected"'; ?> >22</option> |
|
114 | - <option value="23" <?php if((!$formSent && $thisDay == 23) || ($formSent && $day_start == 23)) echo 'selected="selected"'; ?> >23</option> |
|
115 | - <option value="24" <?php if((!$formSent && $thisDay == 24) || ($formSent && $day_start == 24)) echo 'selected="selected"'; ?> >24</option> |
|
116 | - <option value="25" <?php if((!$formSent && $thisDay == 25) || ($formSent && $day_start == 25)) echo 'selected="selected"'; ?> >25</option> |
|
117 | - <option value="26" <?php if((!$formSent && $thisDay == 26) || ($formSent && $day_start == 26)) echo 'selected="selected"'; ?> >26</option> |
|
118 | - <option value="27" <?php if((!$formSent && $thisDay == 27) || ($formSent && $day_start == 27)) echo 'selected="selected"'; ?> >27</option> |
|
119 | - <option value="28" <?php if((!$formSent && $thisDay == 28) || ($formSent && $day_start == 28)) echo 'selected="selected"'; ?> >28</option> |
|
120 | - <option value="29" <?php if((!$formSent && $thisDay == 29) || ($formSent && $day_start == 29)) echo 'selected="selected"'; ?> >29</option> |
|
121 | - <option value="30" <?php if((!$formSent && $thisDay == 30) || ($formSent && $day_start == 30)) echo 'selected="selected"'; ?> >30</option> |
|
122 | - <option value="31" <?php if((!$formSent && $thisDay == 31) || ($formSent && $day_start == 31)) echo 'selected="selected"'; ?> >31</option> |
|
96 | + <option value="2" <?php if((!$formSent && $thisDay == 2) || ($formSent && $day_start == 2)) { |
|
97 | + echo 'selected="selected"'; |
|
98 | +} |
|
99 | +?> >02</option> |
|
100 | + <option value="3" <?php if((!$formSent && $thisDay == 3) || ($formSent && $day_start == 3)) { |
|
101 | + echo 'selected="selected"'; |
|
102 | +} |
|
103 | +?> >03</option> |
|
104 | + <option value="4" <?php if((!$formSent && $thisDay == 4) || ($formSent && $day_start == 4)) { |
|
105 | + echo 'selected="selected"'; |
|
106 | +} |
|
107 | +?> >04</option> |
|
108 | + <option value="5" <?php if((!$formSent && $thisDay == 5) || ($formSent && $day_start == 5)) { |
|
109 | + echo 'selected="selected"'; |
|
110 | +} |
|
111 | +?> >05</option> |
|
112 | + <option value="6" <?php if((!$formSent && $thisDay == 6) || ($formSent && $day_start == 6)) { |
|
113 | + echo 'selected="selected"'; |
|
114 | +} |
|
115 | +?> >06</option> |
|
116 | + <option value="7" <?php if((!$formSent && $thisDay == 7) || ($formSent && $day_start == 7)) { |
|
117 | + echo 'selected="selected"'; |
|
118 | +} |
|
119 | +?> >07</option> |
|
120 | + <option value="8" <?php if((!$formSent && $thisDay == 8) || ($formSent && $day_start == 8)) { |
|
121 | + echo 'selected="selected"'; |
|
122 | +} |
|
123 | +?> >08</option> |
|
124 | + <option value="9" <?php if((!$formSent && $thisDay == 9) || ($formSent && $day_start == 9)) { |
|
125 | + echo 'selected="selected"'; |
|
126 | +} |
|
127 | +?> >09</option> |
|
128 | + <option value="10" <?php if((!$formSent && $thisDay == 10) || ($formSent && $day_start == 10)) { |
|
129 | + echo 'selected="selected"'; |
|
130 | +} |
|
131 | +?> >10</option> |
|
132 | + <option value="11" <?php if((!$formSent && $thisDay == 11) || ($formSent && $day_start == 11)) { |
|
133 | + echo 'selected="selected"'; |
|
134 | +} |
|
135 | +?> >11</option> |
|
136 | + <option value="12" <?php if((!$formSent && $thisDay == 12) || ($formSent && $day_start == 12)) { |
|
137 | + echo 'selected="selected"'; |
|
138 | +} |
|
139 | +?> >12</option> |
|
140 | + <option value="13" <?php if((!$formSent && $thisDay == 13) || ($formSent && $day_start == 13)) { |
|
141 | + echo 'selected="selected"'; |
|
142 | +} |
|
143 | +?> >13</option> |
|
144 | + <option value="14" <?php if((!$formSent && $thisDay == 14) || ($formSent && $day_start == 14)) { |
|
145 | + echo 'selected="selected"'; |
|
146 | +} |
|
147 | +?> >14</option> |
|
148 | + <option value="15" <?php if((!$formSent && $thisDay == 15) || ($formSent && $day_start == 15)) { |
|
149 | + echo 'selected="selected"'; |
|
150 | +} |
|
151 | +?> >15</option> |
|
152 | + <option value="16" <?php if((!$formSent && $thisDay == 16) || ($formSent && $day_start == 16)) { |
|
153 | + echo 'selected="selected"'; |
|
154 | +} |
|
155 | +?> >16</option> |
|
156 | + <option value="17" <?php if((!$formSent && $thisDay == 17) || ($formSent && $day_start == 17)) { |
|
157 | + echo 'selected="selected"'; |
|
158 | +} |
|
159 | +?> >17</option> |
|
160 | + <option value="18" <?php if((!$formSent && $thisDay == 18) || ($formSent && $day_start == 18)) { |
|
161 | + echo 'selected="selected"'; |
|
162 | +} |
|
163 | +?> >18</option> |
|
164 | + <option value="19" <?php if((!$formSent && $thisDay == 19) || ($formSent && $day_start == 19)) { |
|
165 | + echo 'selected="selected"'; |
|
166 | +} |
|
167 | +?> >19</option> |
|
168 | + <option value="20" <?php if((!$formSent && $thisDay == 20) || ($formSent && $day_start == 20)) { |
|
169 | + echo 'selected="selected"'; |
|
170 | +} |
|
171 | +?> >20</option> |
|
172 | + <option value="21" <?php if((!$formSent && $thisDay == 21) || ($formSent && $day_start == 21)) { |
|
173 | + echo 'selected="selected"'; |
|
174 | +} |
|
175 | +?> >21</option> |
|
176 | + <option value="22" <?php if((!$formSent && $thisDay == 22) || ($formSent && $day_start == 22)) { |
|
177 | + echo 'selected="selected"'; |
|
178 | +} |
|
179 | +?> >22</option> |
|
180 | + <option value="23" <?php if((!$formSent && $thisDay == 23) || ($formSent && $day_start == 23)) { |
|
181 | + echo 'selected="selected"'; |
|
182 | +} |
|
183 | +?> >23</option> |
|
184 | + <option value="24" <?php if((!$formSent && $thisDay == 24) || ($formSent && $day_start == 24)) { |
|
185 | + echo 'selected="selected"'; |
|
186 | +} |
|
187 | +?> >24</option> |
|
188 | + <option value="25" <?php if((!$formSent && $thisDay == 25) || ($formSent && $day_start == 25)) { |
|
189 | + echo 'selected="selected"'; |
|
190 | +} |
|
191 | +?> >25</option> |
|
192 | + <option value="26" <?php if((!$formSent && $thisDay == 26) || ($formSent && $day_start == 26)) { |
|
193 | + echo 'selected="selected"'; |
|
194 | +} |
|
195 | +?> >26</option> |
|
196 | + <option value="27" <?php if((!$formSent && $thisDay == 27) || ($formSent && $day_start == 27)) { |
|
197 | + echo 'selected="selected"'; |
|
198 | +} |
|
199 | +?> >27</option> |
|
200 | + <option value="28" <?php if((!$formSent && $thisDay == 28) || ($formSent && $day_start == 28)) { |
|
201 | + echo 'selected="selected"'; |
|
202 | +} |
|
203 | +?> >28</option> |
|
204 | + <option value="29" <?php if((!$formSent && $thisDay == 29) || ($formSent && $day_start == 29)) { |
|
205 | + echo 'selected="selected"'; |
|
206 | +} |
|
207 | +?> >29</option> |
|
208 | + <option value="30" <?php if((!$formSent && $thisDay == 30) || ($formSent && $day_start == 30)) { |
|
209 | + echo 'selected="selected"'; |
|
210 | +} |
|
211 | +?> >30</option> |
|
212 | + <option value="31" <?php if((!$formSent && $thisDay == 31) || ($formSent && $day_start == 31)) { |
|
213 | + echo 'selected="selected"'; |
|
214 | +} |
|
215 | +?> >31</option> |
|
123 | 216 | </select> |
124 | 217 | / |
125 | 218 | <select name="month_start"> |
126 | 219 | <option value="1">01</option> |
127 | - <option value="2" <?php if((!$formSent && $thisMonth == 2) || ($formSent && $month_start == 2)) echo 'selected="selected"'; ?> >02</option> |
|
128 | - <option value="3" <?php if((!$formSent && $thisMonth == 3) || ($formSent && $month_start == 3)) echo 'selected="selected"'; ?> >03</option> |
|
129 | - <option value="4" <?php if((!$formSent && $thisMonth == 4) || ($formSent && $month_start == 4)) echo 'selected="selected"'; ?> >04</option> |
|
130 | - <option value="5" <?php if((!$formSent && $thisMonth == 5) || ($formSent && $month_start == 5)) echo 'selected="selected"'; ?> >05</option> |
|
131 | - <option value="6" <?php if((!$formSent && $thisMonth == 6) || ($formSent && $month_start == 6)) echo 'selected="selected"'; ?> >06</option> |
|
132 | - <option value="7" <?php if((!$formSent && $thisMonth == 7) || ($formSent && $month_start == 7)) echo 'selected="selected"'; ?> >07</option> |
|
133 | - <option value="8" <?php if((!$formSent && $thisMonth == 8) || ($formSent && $month_start == 8)) echo 'selected="selected"'; ?> >08</option> |
|
134 | - <option value="9" <?php if((!$formSent && $thisMonth == 9) || ($formSent && $month_start == 9)) echo 'selected="selected"'; ?> >09</option> |
|
135 | - <option value="10" <?php if((!$formSent && $thisMonth == 10) || ($formSent && $month_start == 10)) echo 'selected="selected"'; ?> >10</option> |
|
136 | - <option value="11" <?php if((!$formSent && $thisMonth == 11) || ($formSent && $month_start == 11)) echo 'selected="selected"'; ?> >11</option> |
|
137 | - <option value="12" <?php if((!$formSent && $thisMonth == 12) || ($formSent && $month_start == 12)) echo 'selected="selected"'; ?> >12</option> |
|
220 | + <option value="2" <?php if((!$formSent && $thisMonth == 2) || ($formSent && $month_start == 2)) { |
|
221 | + echo 'selected="selected"'; |
|
222 | +} |
|
223 | +?> >02</option> |
|
224 | + <option value="3" <?php if((!$formSent && $thisMonth == 3) || ($formSent && $month_start == 3)) { |
|
225 | + echo 'selected="selected"'; |
|
226 | +} |
|
227 | +?> >03</option> |
|
228 | + <option value="4" <?php if((!$formSent && $thisMonth == 4) || ($formSent && $month_start == 4)) { |
|
229 | + echo 'selected="selected"'; |
|
230 | +} |
|
231 | +?> >04</option> |
|
232 | + <option value="5" <?php if((!$formSent && $thisMonth == 5) || ($formSent && $month_start == 5)) { |
|
233 | + echo 'selected="selected"'; |
|
234 | +} |
|
235 | +?> >05</option> |
|
236 | + <option value="6" <?php if((!$formSent && $thisMonth == 6) || ($formSent && $month_start == 6)) { |
|
237 | + echo 'selected="selected"'; |
|
238 | +} |
|
239 | +?> >06</option> |
|
240 | + <option value="7" <?php if((!$formSent && $thisMonth == 7) || ($formSent && $month_start == 7)) { |
|
241 | + echo 'selected="selected"'; |
|
242 | +} |
|
243 | +?> >07</option> |
|
244 | + <option value="8" <?php if((!$formSent && $thisMonth == 8) || ($formSent && $month_start == 8)) { |
|
245 | + echo 'selected="selected"'; |
|
246 | +} |
|
247 | +?> >08</option> |
|
248 | + <option value="9" <?php if((!$formSent && $thisMonth == 9) || ($formSent && $month_start == 9)) { |
|
249 | + echo 'selected="selected"'; |
|
250 | +} |
|
251 | +?> >09</option> |
|
252 | + <option value="10" <?php if((!$formSent && $thisMonth == 10) || ($formSent && $month_start == 10)) { |
|
253 | + echo 'selected="selected"'; |
|
254 | +} |
|
255 | +?> >10</option> |
|
256 | + <option value="11" <?php if((!$formSent && $thisMonth == 11) || ($formSent && $month_start == 11)) { |
|
257 | + echo 'selected="selected"'; |
|
258 | +} |
|
259 | +?> >11</option> |
|
260 | + <option value="12" <?php if((!$formSent && $thisMonth == 12) || ($formSent && $month_start == 12)) { |
|
261 | + echo 'selected="selected"'; |
|
262 | +} |
|
263 | +?> >12</option> |
|
138 | 264 | </select> |
139 | 265 | / |
140 | 266 | <select name="year_start"> |
141 | 267 | <?php |
142 | 268 | for ($i=$thisYear-5;$i <= ($thisYear+5);$i++) { |
143 | 269 | ?> |
144 | - <option value="<?php echo $i; ?>" <?php if((!$formSent && $thisYear == $i) || ($formSent && $year_start == $i)) echo 'selected="selected"'; ?> ><?php echo $i; ?></option> |
|
270 | + <option value="<?php echo $i; ?>" <?php if((!$formSent && $thisYear == $i) || ($formSent && $year_start == $i)) { |
|
271 | + echo 'selected="selected"'; |
|
272 | +} |
|
273 | +?> ><?php echo $i; ?></option> |
|
145 | 274 | <?php |
146 | 275 | } |
147 | 276 | ?> |
@@ -29,29 +29,29 @@ discard block |
||
29 | 29 | $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); |
30 | 30 | |
31 | 31 | if (isset($_POST['formSent']) && $_POST['formSent']) { |
32 | - $formSent = 1; |
|
33 | - $name = $_POST['name']; |
|
34 | - $year_start = $_POST['year_start']; |
|
35 | - $month_start = $_POST['month_start']; |
|
36 | - $day_start = $_POST['day_start']; |
|
37 | - $year_end = $_POST['year_end']; |
|
38 | - $month_end = $_POST['month_end']; |
|
39 | - $day_end = $_POST['day_end']; |
|
40 | - $return = SessionManager::create_category_session( |
|
41 | - $name, |
|
42 | - $year_start, |
|
43 | - $month_start, |
|
44 | - $day_start, |
|
45 | - $year_end, |
|
46 | - $month_end, |
|
47 | - $day_end |
|
48 | - ); |
|
49 | - |
|
50 | - if ($return == strval(intval($return))) { |
|
51 | - Display::addFlash(Display::return_message(get_lang('SessionCategoryAdded'))); |
|
52 | - header('Location: session_category_list.php'); |
|
53 | - exit(); |
|
54 | - } |
|
32 | + $formSent = 1; |
|
33 | + $name = $_POST['name']; |
|
34 | + $year_start = $_POST['year_start']; |
|
35 | + $month_start = $_POST['month_start']; |
|
36 | + $day_start = $_POST['day_start']; |
|
37 | + $year_end = $_POST['year_end']; |
|
38 | + $month_end = $_POST['month_end']; |
|
39 | + $day_end = $_POST['day_end']; |
|
40 | + $return = SessionManager::create_category_session( |
|
41 | + $name, |
|
42 | + $year_start, |
|
43 | + $month_start, |
|
44 | + $day_start, |
|
45 | + $year_end, |
|
46 | + $month_end, |
|
47 | + $day_end |
|
48 | + ); |
|
49 | + |
|
50 | + if ($return == strval(intval($return))) { |
|
51 | + Display::addFlash(Display::return_message(get_lang('SessionCategoryAdded'))); |
|
52 | + header('Location: session_category_list.php'); |
|
53 | + exit(); |
|
54 | + } |
|
55 | 55 | } |
56 | 56 | $thisYear = date('Y'); |
57 | 57 | $thisMonth = date('m'); |
@@ -61,7 +61,7 @@ discard block |
||
61 | 61 | //display the header |
62 | 62 | Display::display_header($tool_name); |
63 | 63 | if (!empty($return)) { |
64 | - Display::display_error_message($return,false); |
|
64 | + Display::display_error_message($return,false); |
|
65 | 65 | } |
66 | 66 | ?> |
67 | 67 | <div class="row"> |
@@ -139,12 +139,12 @@ discard block |
||
139 | 139 | / |
140 | 140 | <select name="year_start"> |
141 | 141 | <?php |
142 | - for ($i=$thisYear-5;$i <= ($thisYear+5);$i++) { |
|
143 | - ?> |
|
142 | + for ($i=$thisYear-5;$i <= ($thisYear+5);$i++) { |
|
143 | + ?> |
|
144 | 144 | <option value="<?php echo $i; ?>" <?php if((!$formSent && $thisYear == $i) || ($formSent && $year_start == $i)) echo 'selected="selected"'; ?> ><?php echo $i; ?></option> |
145 | 145 | <?php |
146 | - } |
|
147 | - ?> |
|
146 | + } |
|
147 | + ?> |
|
148 | 148 | </select> |
149 | 149 | </div> |
150 | 150 | <div class="col-md-3"></div> |
@@ -32,7 +32,7 @@ discard block |
||
32 | 32 | |
33 | 33 | $tool_name = get_lang('ExportSessionListXMLCSV'); |
34 | 34 | |
35 | -$interbreadcrumb[] = array('url' => 'session_list.php','name' => get_lang('SessionList')); |
|
35 | +$interbreadcrumb[] = array('url' => 'session_list.php', 'name' => get_lang('SessionList')); |
|
36 | 36 | |
37 | 37 | set_time_limit(0); |
38 | 38 | |
@@ -56,9 +56,9 @@ discard block |
||
56 | 56 | ORDER BY id"; |
57 | 57 | |
58 | 58 | if (api_is_multiple_url_enabled()) { |
59 | - $tbl_session_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
59 | + $tbl_session_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
60 | 60 | $access_url_id = api_get_current_access_url_id(); |
61 | - if ($access_url_id != -1){ |
|
61 | + if ($access_url_id != -1) { |
|
62 | 62 | $sql = "SELECT s.id, name,id_coach,username,access_start_date,access_end_date,visibility,session_category_id |
63 | 63 | FROM $tbl_session s |
64 | 64 | INNER JOIN $tbl_session_rel_access_url as session_rel_url |
@@ -113,7 +113,7 @@ discard block |
||
113 | 113 | |
114 | 114 | $archiveFile = 'export_sessions_'.$session_id.'_'.api_get_local_time().'.'.$file_type; |
115 | 115 | while (file_exists($archivePath.$archiveFile)) { |
116 | - $archiveFile ='export_users_'.$session_id.'_'.api_get_local_time().'_'.uniqid('').'.'.$file_type; |
|
116 | + $archiveFile = 'export_users_'.$session_id.'_'.api_get_local_time().'_'.uniqid('').'.'.$file_type; |
|
117 | 117 | } |
118 | 118 | |
119 | 119 | $cvs = false; |
@@ -123,12 +123,12 @@ discard block |
||
123 | 123 | |
124 | 124 | |
125 | 125 | while ($row = Database::fetch_array($result)) { |
126 | - $row['name'] = str_replace(';',',',$row['name']); |
|
127 | - $row['username'] = str_replace(';',',',$row['username']); |
|
128 | - $row['access_start_date'] = str_replace(';',',',$row['access_start_date']); |
|
129 | - $row['access_end_date'] = str_replace(';',',',$row['access_end_date']); |
|
130 | - $row['visibility'] = str_replace(';',',',$row['visibility']); |
|
131 | - $row['session_category'] = str_replace(';',',',$row['session_category_id']); |
|
126 | + $row['name'] = str_replace(';', ',', $row['name']); |
|
127 | + $row['username'] = str_replace(';', ',', $row['username']); |
|
128 | + $row['access_start_date'] = str_replace(';', ',', $row['access_start_date']); |
|
129 | + $row['access_end_date'] = str_replace(';', ',', $row['access_end_date']); |
|
130 | + $row['visibility'] = str_replace(';', ',', $row['visibility']); |
|
131 | + $row['session_category'] = str_replace(';', ',', $row['session_category_id']); |
|
132 | 132 | |
133 | 133 | |
134 | 134 | // users |
@@ -142,9 +142,9 @@ discard block |
||
142 | 142 | |
143 | 143 | $rsUsers = Database::query($sql); |
144 | 144 | $users = ''; |
145 | - while ($rowUsers = Database::fetch_array($rsUsers)){ |
|
146 | - if($cvs){ |
|
147 | - $users .= str_replace(';',',',$rowUsers['username']).'|'; |
|
145 | + while ($rowUsers = Database::fetch_array($rsUsers)) { |
|
146 | + if ($cvs) { |
|
147 | + $users .= str_replace(';', ',', $rowUsers['username']).'|'; |
|
148 | 148 | } else { |
149 | 149 | $users .= "\t\t<User>$rowUsers[username]</User>\n"; |
150 | 150 | } |
@@ -184,8 +184,8 @@ discard block |
||
184 | 184 | $coachs = implode(",", $coachs); |
185 | 185 | |
186 | 186 | if ($cvs) { |
187 | - $courses .= str_replace(';',',',$rowCourses['code']); |
|
188 | - $courses .= '['.str_replace(';',',',$coachs).']['; |
|
187 | + $courses .= str_replace(';', ',', $rowCourses['code']); |
|
188 | + $courses .= '['.str_replace(';', ',', $coachs).']['; |
|
189 | 189 | } else { |
190 | 190 | $courses .= "\t\t<Course>\n"; |
191 | 191 | $courses .= "\t\t\t<CourseCode>$rowCourses[code]</CourseCode>\n"; |
@@ -208,9 +208,9 @@ discard block |
||
208 | 208 | |
209 | 209 | $rsUsersCourse = Database::query($sql); |
210 | 210 | $userscourse = ''; |
211 | - while ($rowUsersCourse = Database::fetch_array($rsUsersCourse)){ |
|
211 | + while ($rowUsersCourse = Database::fetch_array($rsUsersCourse)) { |
|
212 | 212 | if ($cvs) { |
213 | - $userscourse .= str_replace(';',',',$rowUsersCourse['username']).','; |
|
213 | + $userscourse .= str_replace(';', ',', $rowUsersCourse['username']).','; |
|
214 | 214 | } else { |
215 | 215 | $courses .= "\t\t\t<User>$rowUsersCourse[username]</User>\n"; |
216 | 216 | } |
@@ -291,7 +291,7 @@ discard block |
||
291 | 291 | if (api_is_multiple_url_enabled()) { |
292 | 292 | $tbl_session_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
293 | 293 | $access_url_id = api_get_current_access_url_id(); |
294 | - if ($access_url_id != -1){ |
|
294 | + if ($access_url_id != -1) { |
|
295 | 295 | $sql = "SELECT s.id, name FROM $tbl_session s |
296 | 296 | INNER JOIN $tbl_session_rel_access_url as session_rel_url |
297 | 297 | ON (s.id = session_rel_url.session_id) |
@@ -304,7 +304,7 @@ discard block |
||
304 | 304 | |
305 | 305 | echo '<div class="actions">'; |
306 | 306 | echo '<a href="../session/session_list.php">'. |
307 | - Display::return_icon('back.png', get_lang('BackTo').' '.get_lang('SessionList'),'',ICON_SIZE_MEDIUM).'</a>'; |
|
307 | + Display::return_icon('back.png', get_lang('BackTo').' '.get_lang('SessionList'), '', ICON_SIZE_MEDIUM).'</a>'; |
|
308 | 308 | echo '</div>'; |
309 | 309 | |
310 | 310 | if (!empty($errorMsg)) { |
@@ -313,8 +313,8 @@ discard block |
||
313 | 313 | |
314 | 314 | $form = new FormValidator('session_export', 'post', api_get_self()); |
315 | 315 | $form->addElement('hidden', 'formSent', 1); |
316 | -$form->addElement('radio', 'file_type', get_lang('OutputFileType'), 'CSV' , 'csv', null); |
|
317 | -$form->addElement('radio', 'file_type', '', 'XLS' , 'xls', null); |
|
316 | +$form->addElement('radio', 'file_type', get_lang('OutputFileType'), 'CSV', 'csv', null); |
|
317 | +$form->addElement('radio', 'file_type', '', 'XLS', 'xls', null); |
|
318 | 318 | $form->addElement('radio', 'file_type', null, 'XML', 'xml', null, array('id' => 'file_type_xml')); |
319 | 319 | |
320 | 320 | $options = array(); |
@@ -323,7 +323,7 @@ discard block |
||
323 | 323 | $options[$enreg['id']] = $enreg['name']; |
324 | 324 | } |
325 | 325 | |
326 | -$form->addElement('select', 'session_id', get_lang('WhichSessionToExport'), $options); |
|
326 | +$form->addElement('select', 'session_id', get_lang('WhichSessionToExport'), $options); |
|
327 | 327 | $form->addButtonExport(get_lang('ExportSession')); |
328 | 328 | |
329 | 329 | $defaults = array(); |
@@ -37,11 +37,11 @@ discard block |
||
37 | 37 | set_time_limit(0); |
38 | 38 | |
39 | 39 | if (isset($_POST['formSent'])) { |
40 | - $formSent = $_POST['formSent']; |
|
41 | - $file_type = isset($_POST['file_type']) ? $_POST['file_type'] : 'csv'; |
|
42 | - $session_id = $_POST['session_id']; |
|
43 | - if (empty($session_id)) { |
|
44 | - $sql = "SELECT |
|
40 | + $formSent = $_POST['formSent']; |
|
41 | + $file_type = isset($_POST['file_type']) ? $_POST['file_type'] : 'csv'; |
|
42 | + $session_id = $_POST['session_id']; |
|
43 | + if (empty($session_id)) { |
|
44 | + $sql = "SELECT |
|
45 | 45 | s.id, |
46 | 46 | name, |
47 | 47 | id_coach, |
@@ -55,84 +55,84 @@ discard block |
||
55 | 55 | ON $tbl_user.user_id = s.id_coach |
56 | 56 | ORDER BY id"; |
57 | 57 | |
58 | - if (api_is_multiple_url_enabled()) { |
|
59 | - $tbl_session_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
60 | - $access_url_id = api_get_current_access_url_id(); |
|
61 | - if ($access_url_id != -1){ |
|
62 | - $sql = "SELECT s.id, name,id_coach,username,access_start_date,access_end_date,visibility,session_category_id |
|
58 | + if (api_is_multiple_url_enabled()) { |
|
59 | + $tbl_session_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
60 | + $access_url_id = api_get_current_access_url_id(); |
|
61 | + if ($access_url_id != -1){ |
|
62 | + $sql = "SELECT s.id, name,id_coach,username,access_start_date,access_end_date,visibility,session_category_id |
|
63 | 63 | FROM $tbl_session s |
64 | 64 | INNER JOIN $tbl_session_rel_access_url as session_rel_url |
65 | 65 | ON (s.id= session_rel_url.session_id) |
66 | 66 | INNER JOIN $tbl_user u ON (u.user_id = s.id_coach) |
67 | 67 | WHERE access_url_id = $access_url_id |
68 | 68 | ORDER BY id"; |
69 | - } |
|
70 | - } |
|
69 | + } |
|
70 | + } |
|
71 | 71 | |
72 | - $result = Database::query($sql); |
|
73 | - } else { |
|
74 | - $sql = "SELECT s.id,name,username,access_start_date,access_end_date,visibility,session_category_id |
|
72 | + $result = Database::query($sql); |
|
73 | + } else { |
|
74 | + $sql = "SELECT s.id,name,username,access_start_date,access_end_date,visibility,session_category_id |
|
75 | 75 | FROM $tbl_session s |
76 | 76 | INNER JOIN $tbl_user |
77 | 77 | ON $tbl_user.user_id = s.id_coach |
78 | 78 | WHERE s.id='$session_id'"; |
79 | - $result = Database::query($sql); |
|
80 | - } |
|
79 | + $result = Database::query($sql); |
|
80 | + } |
|
81 | 81 | |
82 | - if (Database::num_rows($result)) { |
|
82 | + if (Database::num_rows($result)) { |
|
83 | 83 | |
84 | 84 | |
85 | 85 | |
86 | - $sessionListToExport = []; |
|
86 | + $sessionListToExport = []; |
|
87 | 87 | |
88 | - if (in_array($file_type, ['csv', 'xls'])) { |
|
88 | + if (in_array($file_type, ['csv', 'xls'])) { |
|
89 | 89 | |
90 | - $archiveFile = 'export_sessions_'.$session_id.'_'.api_get_local_time(); |
|
90 | + $archiveFile = 'export_sessions_'.$session_id.'_'.api_get_local_time(); |
|
91 | 91 | |
92 | - $cvs = true; |
|
93 | - $sessionListToExport[] = [ |
|
94 | - 'SessionName', |
|
95 | - 'Coach', |
|
96 | - 'DateStart', |
|
97 | - 'DateEnd', |
|
98 | - 'Visibility', |
|
99 | - 'SessionCategory', |
|
100 | - 'Users', |
|
101 | - 'Courses' |
|
102 | - ]; |
|
103 | - } else { |
|
104 | - if (!file_exists($archivePath)) { |
|
105 | - mkdir($archivePath, api_get_permissions_for_new_directories(), true); |
|
106 | - } |
|
92 | + $cvs = true; |
|
93 | + $sessionListToExport[] = [ |
|
94 | + 'SessionName', |
|
95 | + 'Coach', |
|
96 | + 'DateStart', |
|
97 | + 'DateEnd', |
|
98 | + 'Visibility', |
|
99 | + 'SessionCategory', |
|
100 | + 'Users', |
|
101 | + 'Courses' |
|
102 | + ]; |
|
103 | + } else { |
|
104 | + if (!file_exists($archivePath)) { |
|
105 | + mkdir($archivePath, api_get_permissions_for_new_directories(), true); |
|
106 | + } |
|
107 | 107 | |
108 | - if (!file_exists($archivePath.'index.html')) { |
|
109 | - $fp = fopen($archivePath.'index.html', 'w'); |
|
110 | - fputs($fp, '<html><head></head><body></body></html>'); |
|
111 | - fclose($fp); |
|
112 | - } |
|
108 | + if (!file_exists($archivePath.'index.html')) { |
|
109 | + $fp = fopen($archivePath.'index.html', 'w'); |
|
110 | + fputs($fp, '<html><head></head><body></body></html>'); |
|
111 | + fclose($fp); |
|
112 | + } |
|
113 | 113 | |
114 | - $archiveFile = 'export_sessions_'.$session_id.'_'.api_get_local_time().'.'.$file_type; |
|
115 | - while (file_exists($archivePath.$archiveFile)) { |
|
116 | - $archiveFile ='export_users_'.$session_id.'_'.api_get_local_time().'_'.uniqid('').'.'.$file_type; |
|
117 | - } |
|
114 | + $archiveFile = 'export_sessions_'.$session_id.'_'.api_get_local_time().'.'.$file_type; |
|
115 | + while (file_exists($archivePath.$archiveFile)) { |
|
116 | + $archiveFile ='export_users_'.$session_id.'_'.api_get_local_time().'_'.uniqid('').'.'.$file_type; |
|
117 | + } |
|
118 | 118 | |
119 | - $cvs = false; |
|
120 | - $fp = fopen($archivePath.$archiveFile, 'w'); |
|
121 | - fputs($fp, "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<Sessions>\n"); |
|
122 | - } |
|
119 | + $cvs = false; |
|
120 | + $fp = fopen($archivePath.$archiveFile, 'w'); |
|
121 | + fputs($fp, "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<Sessions>\n"); |
|
122 | + } |
|
123 | 123 | |
124 | 124 | |
125 | - while ($row = Database::fetch_array($result)) { |
|
126 | - $row['name'] = str_replace(';',',',$row['name']); |
|
127 | - $row['username'] = str_replace(';',',',$row['username']); |
|
128 | - $row['access_start_date'] = str_replace(';',',',$row['access_start_date']); |
|
129 | - $row['access_end_date'] = str_replace(';',',',$row['access_end_date']); |
|
130 | - $row['visibility'] = str_replace(';',',',$row['visibility']); |
|
131 | - $row['session_category'] = str_replace(';',',',$row['session_category_id']); |
|
125 | + while ($row = Database::fetch_array($result)) { |
|
126 | + $row['name'] = str_replace(';',',',$row['name']); |
|
127 | + $row['username'] = str_replace(';',',',$row['username']); |
|
128 | + $row['access_start_date'] = str_replace(';',',',$row['access_start_date']); |
|
129 | + $row['access_end_date'] = str_replace(';',',',$row['access_end_date']); |
|
130 | + $row['visibility'] = str_replace(';',',',$row['visibility']); |
|
131 | + $row['session_category'] = str_replace(';',',',$row['session_category_id']); |
|
132 | 132 | |
133 | 133 | |
134 | - // users |
|
135 | - $sql = "SELECT DISTINCT $tbl_user.username |
|
134 | + // users |
|
135 | + $sql = "SELECT DISTINCT $tbl_user.username |
|
136 | 136 | FROM $tbl_user |
137 | 137 | INNER JOIN $tbl_session_user |
138 | 138 | ON |
@@ -140,33 +140,33 @@ discard block |
||
140 | 140 | $tbl_session_user.relation_type<>".SESSION_RELATION_TYPE_RRHH." AND |
141 | 141 | $tbl_session_user.session_id = '".$row['id']."'"; |
142 | 142 | |
143 | - $rsUsers = Database::query($sql); |
|
144 | - $users = ''; |
|
145 | - while ($rowUsers = Database::fetch_array($rsUsers)){ |
|
146 | - if($cvs){ |
|
147 | - $users .= str_replace(';',',',$rowUsers['username']).'|'; |
|
148 | - } else { |
|
149 | - $users .= "\t\t<User>$rowUsers[username]</User>\n"; |
|
150 | - } |
|
151 | - } |
|
152 | - |
|
153 | - if (!empty($users) && $cvs) { |
|
154 | - $users = api_substr($users, 0, api_strlen($users) - 1); |
|
155 | - } |
|
156 | - |
|
157 | - // Courses |
|
158 | - $sql = "SELECT DISTINCT c.code, sc.id, c_id |
|
143 | + $rsUsers = Database::query($sql); |
|
144 | + $users = ''; |
|
145 | + while ($rowUsers = Database::fetch_array($rsUsers)){ |
|
146 | + if($cvs){ |
|
147 | + $users .= str_replace(';',',',$rowUsers['username']).'|'; |
|
148 | + } else { |
|
149 | + $users .= "\t\t<User>$rowUsers[username]</User>\n"; |
|
150 | + } |
|
151 | + } |
|
152 | + |
|
153 | + if (!empty($users) && $cvs) { |
|
154 | + $users = api_substr($users, 0, api_strlen($users) - 1); |
|
155 | + } |
|
156 | + |
|
157 | + // Courses |
|
158 | + $sql = "SELECT DISTINCT c.code, sc.id, c_id |
|
159 | 159 | FROM $tbl_course c |
160 | 160 | INNER JOIN $tbl_session_course_user sc |
161 | 161 | ON c.id = sc.c_id |
162 | 162 | AND sc.session_id = '".$row['id']."'"; |
163 | 163 | |
164 | - $rsCourses = Database::query($sql); |
|
164 | + $rsCourses = Database::query($sql); |
|
165 | 165 | |
166 | - $courses = ''; |
|
167 | - while ($rowCourses = Database::fetch_array($rsCourses)) { |
|
168 | - // get coachs from a course |
|
169 | - $sql = "SELECT u.username |
|
166 | + $courses = ''; |
|
167 | + while ($rowCourses = Database::fetch_array($rsCourses)) { |
|
168 | + // get coachs from a course |
|
169 | + $sql = "SELECT u.username |
|
170 | 170 | FROM $tbl_session_course_user scu |
171 | 171 | INNER JOIN $tbl_user u |
172 | 172 | ON u.user_id = scu.user_id |
@@ -175,25 +175,25 @@ discard block |
||
175 | 175 | scu.session_id = '".$row['id']."' AND |
176 | 176 | scu.status = 2 "; |
177 | 177 | |
178 | - $rs_coachs = Database::query($sql); |
|
179 | - $coachs = array(); |
|
180 | - while ($row_coachs = Database::fetch_array($rs_coachs)) { |
|
181 | - $coachs[] = $row_coachs['username']; |
|
182 | - } |
|
183 | - |
|
184 | - $coachs = implode(",", $coachs); |
|
185 | - |
|
186 | - if ($cvs) { |
|
187 | - $courses .= str_replace(';',',',$rowCourses['code']); |
|
188 | - $courses .= '['.str_replace(';',',',$coachs).']['; |
|
189 | - } else { |
|
190 | - $courses .= "\t\t<Course>\n"; |
|
191 | - $courses .= "\t\t\t<CourseCode>$rowCourses[code]</CourseCode>\n"; |
|
192 | - $courses .= "\t\t\t<Coach>$coachs</Coach>\n"; |
|
193 | - } |
|
194 | - |
|
195 | - // rel user courses |
|
196 | - $sql = "SELECT DISTINCT u.username |
|
178 | + $rs_coachs = Database::query($sql); |
|
179 | + $coachs = array(); |
|
180 | + while ($row_coachs = Database::fetch_array($rs_coachs)) { |
|
181 | + $coachs[] = $row_coachs['username']; |
|
182 | + } |
|
183 | + |
|
184 | + $coachs = implode(",", $coachs); |
|
185 | + |
|
186 | + if ($cvs) { |
|
187 | + $courses .= str_replace(';',',',$rowCourses['code']); |
|
188 | + $courses .= '['.str_replace(';',',',$coachs).']['; |
|
189 | + } else { |
|
190 | + $courses .= "\t\t<Course>\n"; |
|
191 | + $courses .= "\t\t\t<CourseCode>$rowCourses[code]</CourseCode>\n"; |
|
192 | + $courses .= "\t\t\t<Coach>$coachs</Coach>\n"; |
|
193 | + } |
|
194 | + |
|
195 | + // rel user courses |
|
196 | + $sql = "SELECT DISTINCT u.username |
|
197 | 197 | FROM $tbl_session_course_user scu |
198 | 198 | INNER JOIN $tbl_session_user su |
199 | 199 | ON |
@@ -206,79 +206,79 @@ discard block |
||
206 | 206 | scu.c_id='".$rowCourses['c_id']."' AND |
207 | 207 | scu.session_id='".$row['id']."'"; |
208 | 208 | |
209 | - $rsUsersCourse = Database::query($sql); |
|
210 | - $userscourse = ''; |
|
211 | - while ($rowUsersCourse = Database::fetch_array($rsUsersCourse)){ |
|
212 | - if ($cvs) { |
|
213 | - $userscourse .= str_replace(';',',',$rowUsersCourse['username']).','; |
|
214 | - } else { |
|
215 | - $courses .= "\t\t\t<User>$rowUsersCourse[username]</User>\n"; |
|
216 | - } |
|
217 | - } |
|
218 | - |
|
219 | - if ($cvs) { |
|
220 | - if (!empty($userscourse)) { |
|
221 | - $userscourse = api_substr( |
|
222 | - $userscourse, |
|
223 | - 0, |
|
224 | - api_strlen($userscourse) - 1 |
|
225 | - ); |
|
226 | - } |
|
227 | - |
|
228 | - $courses .= $userscourse.']|'; |
|
229 | - } else { |
|
230 | - $courses .= "\t\t</Course>\n"; |
|
231 | - } |
|
232 | - } |
|
233 | - |
|
234 | - if (!empty($courses) && $cvs) { |
|
235 | - $courses = api_substr($courses, 0, api_strlen($courses) - 1); |
|
236 | - } |
|
237 | - $add = $courses; |
|
238 | - |
|
239 | - if (in_array($file_type, ['csv', 'xls'])) { |
|
240 | - $sessionListToExport[] = [ |
|
241 | - $row['name'], |
|
242 | - $row['username'], |
|
243 | - $row['access_start_date'], |
|
244 | - $row['access_end_date'], |
|
245 | - $row['visibility'], |
|
246 | - $row['session_category'], |
|
247 | - $users, |
|
248 | - $courses |
|
249 | - ]; |
|
250 | - } else { |
|
251 | - $add = "\t<Session>\n" |
|
252 | - ."\t\t<SessionName>$row[name]</SessionName>\n" |
|
253 | - ."\t\t<Coach>$row[username]</Coach>\n" |
|
254 | - ."\t\t<DateStart>$row[access_start_date]</DateStart>\n" |
|
255 | - ."\t\t<DateEnd>$row[access_end_date]</DateEnd>\n" |
|
256 | - ."\t\t<Visibility>$row[visibility]</Visibility>\n" |
|
257 | - ."\t\t<SessionCategory>$row[session_category]</SessionCategory>\n"; |
|
258 | - } |
|
259 | - |
|
260 | - if (!$cvs) { |
|
261 | - $add .= "\t</Session>\n"; |
|
262 | - fputs($fp, $add); |
|
263 | - } |
|
264 | - } |
|
265 | - |
|
266 | - switch ($file_type) { |
|
267 | - case 'xml': |
|
268 | - fputs($fp, "</Sessions>\n"); |
|
269 | - fclose($fp); |
|
270 | - $errorMsg = get_lang('UserListHasBeenExported').'<br/> |
|
209 | + $rsUsersCourse = Database::query($sql); |
|
210 | + $userscourse = ''; |
|
211 | + while ($rowUsersCourse = Database::fetch_array($rsUsersCourse)){ |
|
212 | + if ($cvs) { |
|
213 | + $userscourse .= str_replace(';',',',$rowUsersCourse['username']).','; |
|
214 | + } else { |
|
215 | + $courses .= "\t\t\t<User>$rowUsersCourse[username]</User>\n"; |
|
216 | + } |
|
217 | + } |
|
218 | + |
|
219 | + if ($cvs) { |
|
220 | + if (!empty($userscourse)) { |
|
221 | + $userscourse = api_substr( |
|
222 | + $userscourse, |
|
223 | + 0, |
|
224 | + api_strlen($userscourse) - 1 |
|
225 | + ); |
|
226 | + } |
|
227 | + |
|
228 | + $courses .= $userscourse.']|'; |
|
229 | + } else { |
|
230 | + $courses .= "\t\t</Course>\n"; |
|
231 | + } |
|
232 | + } |
|
233 | + |
|
234 | + if (!empty($courses) && $cvs) { |
|
235 | + $courses = api_substr($courses, 0, api_strlen($courses) - 1); |
|
236 | + } |
|
237 | + $add = $courses; |
|
238 | + |
|
239 | + if (in_array($file_type, ['csv', 'xls'])) { |
|
240 | + $sessionListToExport[] = [ |
|
241 | + $row['name'], |
|
242 | + $row['username'], |
|
243 | + $row['access_start_date'], |
|
244 | + $row['access_end_date'], |
|
245 | + $row['visibility'], |
|
246 | + $row['session_category'], |
|
247 | + $users, |
|
248 | + $courses |
|
249 | + ]; |
|
250 | + } else { |
|
251 | + $add = "\t<Session>\n" |
|
252 | + ."\t\t<SessionName>$row[name]</SessionName>\n" |
|
253 | + ."\t\t<Coach>$row[username]</Coach>\n" |
|
254 | + ."\t\t<DateStart>$row[access_start_date]</DateStart>\n" |
|
255 | + ."\t\t<DateEnd>$row[access_end_date]</DateEnd>\n" |
|
256 | + ."\t\t<Visibility>$row[visibility]</Visibility>\n" |
|
257 | + ."\t\t<SessionCategory>$row[session_category]</SessionCategory>\n"; |
|
258 | + } |
|
259 | + |
|
260 | + if (!$cvs) { |
|
261 | + $add .= "\t</Session>\n"; |
|
262 | + fputs($fp, $add); |
|
263 | + } |
|
264 | + } |
|
265 | + |
|
266 | + switch ($file_type) { |
|
267 | + case 'xml': |
|
268 | + fputs($fp, "</Sessions>\n"); |
|
269 | + fclose($fp); |
|
270 | + $errorMsg = get_lang('UserListHasBeenExported').'<br/> |
|
271 | 271 | <a class="btn btn-default" href="'.$archiveURL.$archiveFile.'">'.get_lang('ClickHereToDownloadTheFile').'</a>'; |
272 | - break; |
|
273 | - case 'csv': |
|
274 | - Export::arrayToCsv($sessionListToExport, $archiveFile); |
|
275 | - exit; |
|
276 | - case 'xls': |
|
277 | - Export::arrayToXls($sessionListToExport, $archiveFile); |
|
278 | - exit; |
|
279 | - break; |
|
280 | - } |
|
281 | - } |
|
272 | + break; |
|
273 | + case 'csv': |
|
274 | + Export::arrayToCsv($sessionListToExport, $archiveFile); |
|
275 | + exit; |
|
276 | + case 'xls': |
|
277 | + Export::arrayToXls($sessionListToExport, $archiveFile); |
|
278 | + exit; |
|
279 | + break; |
|
280 | + } |
|
281 | + } |
|
282 | 282 | } |
283 | 283 | |
284 | 284 | // display the header |
@@ -288,26 +288,26 @@ discard block |
||
288 | 288 | $sql = "SELECT id, name FROM $tbl_session ORDER BY name"; |
289 | 289 | |
290 | 290 | if (api_is_multiple_url_enabled()) { |
291 | - $tbl_session_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
292 | - $access_url_id = api_get_current_access_url_id(); |
|
293 | - if ($access_url_id != -1){ |
|
294 | - $sql = "SELECT s.id, name FROM $tbl_session s |
|
291 | + $tbl_session_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
292 | + $access_url_id = api_get_current_access_url_id(); |
|
293 | + if ($access_url_id != -1){ |
|
294 | + $sql = "SELECT s.id, name FROM $tbl_session s |
|
295 | 295 | INNER JOIN $tbl_session_rel_access_url as session_rel_url |
296 | 296 | ON (s.id = session_rel_url.session_id) |
297 | 297 | WHERE access_url_id = $access_url_id |
298 | 298 | ORDER BY name"; |
299 | - } |
|
299 | + } |
|
300 | 300 | } |
301 | 301 | $result = Database::query($sql); |
302 | 302 | $Sessions = Database::store_result($result); |
303 | 303 | |
304 | 304 | echo '<div class="actions">'; |
305 | 305 | echo '<a href="../session/session_list.php">'. |
306 | - Display::return_icon('back.png', get_lang('BackTo').' '.get_lang('SessionList'),'',ICON_SIZE_MEDIUM).'</a>'; |
|
306 | + Display::return_icon('back.png', get_lang('BackTo').' '.get_lang('SessionList'),'',ICON_SIZE_MEDIUM).'</a>'; |
|
307 | 307 | echo '</div>'; |
308 | 308 | |
309 | 309 | if (!empty($errorMsg)) { |
310 | - Display::display_normal_message($errorMsg, false); //main API |
|
310 | + Display::display_normal_message($errorMsg, false); //main API |
|
311 | 311 | } |
312 | 312 | |
313 | 313 | $form = new FormValidator('session_export', 'post', api_get_self()); |
@@ -636,11 +636,11 @@ |
||
636 | 636 | } |
637 | 637 | $formToDisplay = $form->returnForm(); |
638 | 638 | } else { |
639 | - if (!empty($sessionId)) { |
|
640 | - $sessionInfo = api_get_session_info($sessionId); |
|
641 | - $startDate = $sessionInfo['access_start_date']; |
|
642 | - $endDate = $sessionInfo['access_end_date']; |
|
643 | - } |
|
639 | + if (!empty($sessionId)) { |
|
640 | + $sessionInfo = api_get_session_info($sessionId); |
|
641 | + $startDate = $sessionInfo['access_start_date']; |
|
642 | + $endDate = $sessionInfo['access_end_date']; |
|
643 | + } |
|
644 | 644 | } |
645 | 645 | |
646 | 646 | $attendance = new Attendance(); |
@@ -550,17 +550,17 @@ discard block |
||
550 | 550 | } |
551 | 551 | } |
552 | 552 | $max_cols_per_page = 12; //10 dates + 2 name and number |
553 | - $max_dates_per_page = $max_dates_per_page_original = $max_cols_per_page - 2;//10 |
|
553 | + $max_dates_per_page = $max_dates_per_page_original = $max_cols_per_page - 2; //10 |
|
554 | 554 | $rows = count($data_table); |
555 | 555 | |
556 | 556 | if ($cols > $max_cols_per_page) { |
557 | - $number_tables = round(($cols-2)/$max_dates_per_page); |
|
557 | + $number_tables = round(($cols - 2) / $max_dates_per_page); |
|
558 | 558 | $headers = $data_table[0]; |
559 | 559 | $all = array(); |
560 | 560 | $tables = array(); |
561 | 561 | $changed = 1; |
562 | 562 | |
563 | - for ($i= 0; $i <= $rows; $i++) { |
|
563 | + for ($i = 0; $i <= $rows; $i++) { |
|
564 | 564 | $row = isset($data_table[$i]) ? $data_table[$i] : null; |
565 | 565 | $key = 1; |
566 | 566 | $max_dates_per_page = 10; |
@@ -571,7 +571,7 @@ discard block |
||
571 | 571 | foreach ($item as $value) { |
572 | 572 | if ($count_j >= $max_dates_per_page) { |
573 | 573 | $key++; |
574 | - $max_dates_per_page = $max_dates_per_page_original*$key; |
|
574 | + $max_dates_per_page = $max_dates_per_page_original * $key; |
|
575 | 575 | //magic hack |
576 | 576 | $tables[$key][$i][] = $tables[1][$i][0]; |
577 | 577 | $tables[$key][$i][] = $tables[1][$i][1]; |
@@ -628,8 +628,8 @@ discard block |
||
628 | 628 | $form = new FormValidator( |
629 | 629 | 'search', |
630 | 630 | 'post', |
631 | - api_get_self() . '?' . api_get_cidreq( |
|
632 | - ) . '&action=calendar_logins' |
|
631 | + api_get_self().'?'.api_get_cidreq( |
|
632 | + ).'&action=calendar_logins' |
|
633 | 633 | ); |
634 | 634 | $form->addDateRangePicker('range', get_lang('DateRange')); |
635 | 635 | $form->addButton('submit', get_lang('Submit')); |
@@ -91,7 +91,7 @@ |
||
91 | 91 | $content .= '<div class="courseadminview-activity-3col"><span class="viewcaption">'.get_lang('SessionData').'</span> |
92 | 92 | <table width="100%">'; |
93 | 93 | $content .= CourseHome::show_session_data($session_id); |
94 | - $content .= '</table></div>'; |
|
94 | + $content .= '</table></div>'; |
|
95 | 95 | } |
96 | 96 | |
97 | 97 | $content .= '<div class="Authoringview">'; |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | // Show message to confirm that a tool it to be hidden from available tools |
38 | 38 | // visibility 0,1->2 |
39 | 39 | if (!empty($_GET['askDelete'])) { |
40 | - $content .='<div id="toolhide">'.get_lang('DelLk').'<br /> |
|
40 | + $content .= '<div id="toolhide">'.get_lang('DelLk').'<br /> |
|
41 | 41 | <a href="'.api_get_self().'">'.get_lang('No').'</a> | |
42 | 42 | <a href="'.api_get_self().'?delete=yes&id='.$id.'">'.get_lang('Yes').'</a> |
43 | 43 | </div>'; |
@@ -55,14 +55,14 @@ discard block |
||
55 | 55 | |
56 | 56 | // Start of tools for CourseAdmins (teachers/tutors) |
57 | 57 | if (api_is_allowed_to_edit(null, true) && !api_is_coach()) { |
58 | - $content .= '<div class="courseadminview" style="border:0px; margin-top: 0px;padding:5px;"> |
|
58 | + $content .= '<div class="courseadminview" style="border:0px; margin-top: 0px;padding:5px;"> |
|
59 | 59 | <div class="normal-message" id="id_normal_message" style="display:none">'; |
60 | - $content .= '<img src="'.api_get_path(WEB_PATH).'main/inc/lib/javascript/indicator.gif"/> '; |
|
61 | - $content .= get_lang('PleaseStandBy'); |
|
60 | + $content .= '<img src="'.api_get_path(WEB_PATH).'main/inc/lib/javascript/indicator.gif"/> '; |
|
61 | + $content .= get_lang('PleaseStandBy'); |
|
62 | 62 | |
63 | - $content .= '</div> |
|
63 | + $content .= '</div> |
|
64 | 64 | <div class="confirmation-message" id="id_confirmation_message" style="display:none"></div></div>'; |
65 | - $content .= '<div id="activity-3col">'; |
|
65 | + $content .= '<div id="activity-3col">'; |
|
66 | 66 | |
67 | 67 | if (api_get_setting('show_session_data') == 'true' && $session_id > 0) { |
68 | 68 | $content .= '<div class="courseadminview-activity-3col"><span class="viewcaption">'.get_lang('SessionData').'</span> |
@@ -90,10 +90,10 @@ discard block |
||
90 | 90 | $content .= '<div class="courseadminview-activity-3col"><span class="viewcaption">'.get_lang('SessionData').'</span> |
91 | 91 | <table width="100%">'; |
92 | 92 | $content .= CourseHome::show_session_data($session_id); |
93 | - $content .= '</table></div>'; |
|
93 | + $content .= '</table></div>'; |
|
94 | 94 | } |
95 | 95 | |
96 | - $content .= '<div class="Authoringview">'; |
|
96 | + $content .= '<div class="Authoringview">'; |
|
97 | 97 | $my_list = CourseHome::get_tools_category(TOOL_STUDENT_VIEW); |
98 | 98 | $content .= CourseHome::show_tools_category($my_list); |
99 | 99 | $content .= '</div>'; |
@@ -106,7 +106,7 @@ discard block |
||
106 | 106 | $order_tool_list = array(); |
107 | 107 | foreach ($my_list as $key => $new_tool) { |
108 | 108 | $tool_name = CourseHome::translate_tool_name($new_tool); |
109 | - $order_tool_list [$key]= $tool_name; |
|
109 | + $order_tool_list [$key] = $tool_name; |
|
110 | 110 | } |
111 | 111 | natsort($order_tool_list); |
112 | 112 | $my_temp_tool_array = array(); |
@@ -23,7 +23,7 @@ |
||
23 | 23 | // set URL and other appropriate options |
24 | 24 | $defaults = array( |
25 | 25 | CURLOPT_URL => $url, |
26 | - CURLOPT_FOLLOWLOCATION => true, // follow redirects accept youtube.com |
|
26 | + CURLOPT_FOLLOWLOCATION => true, // follow redirects accept youtube.com |
|
27 | 27 | CURLOPT_HEADER => 0, |
28 | 28 | CURLOPT_RETURNTRANSFER => true, |
29 | 29 | CURLOPT_TIMEOUT => 4 |
@@ -15,7 +15,7 @@ discard block |
||
15 | 15 | $list_sessions = SessionManager::get_sessions_by_user($user_id, true); |
16 | 16 | if (!empty($list_sessions)) { |
17 | 17 | foreach ($list_sessions as $session_item) { |
18 | - echo $session_item['session_name'] . '<br />'; |
|
18 | + echo $session_item['session_name'].'<br />'; |
|
19 | 19 | } |
20 | 20 | } else { |
21 | 21 | echo get_lang('NoSessionsForThisUser'); |
@@ -29,7 +29,7 @@ discard block |
||
29 | 29 | [ |
30 | 30 | 's.name' => [ |
31 | 31 | 'operator' => 'LIKE', |
32 | - 'value' => "%" . $_REQUEST['q'] . "%" |
|
32 | + 'value' => "%".$_REQUEST['q']."%" |
|
33 | 33 | ] |
34 | 34 | ] |
35 | 35 | ); |
@@ -488,7 +488,7 @@ |
||
488 | 488 | $remind_list |
489 | 489 | ); |
490 | 490 | |
491 | - // Destruction of the Question object |
|
491 | + // Destruction of the Question object |
|
492 | 492 | unset($objQuestionTmp); |
493 | 493 | if ($debug) { |
494 | 494 | error_log(" -- end question -- "); |
@@ -32,10 +32,10 @@ discard block |
||
32 | 32 | $exercise_id = intval($_GET['exercise_id']); |
33 | 33 | $page = intval($_REQUEST['page']); //page |
34 | 34 | $limit = intval($_REQUEST['rows']); //quantity of rows |
35 | - $sidx = $_REQUEST['sidx']; //index to filter |
|
36 | - $sord = $_REQUEST['sord']; //asc or desc |
|
35 | + $sidx = $_REQUEST['sidx']; //index to filter |
|
36 | + $sord = $_REQUEST['sord']; //asc or desc |
|
37 | 37 | |
38 | - if (!in_array($sord, array('asc','desc'))) { |
|
38 | + if (!in_array($sord, array('asc', 'desc'))) { |
|
39 | 39 | $sord = 'desc'; |
40 | 40 | } |
41 | 41 | // get index row - i.e. user click to sort $sord = $_GET['sord']; |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | $total_pages = 0; |
65 | 65 | if ($count > 0) { |
66 | 66 | if (!empty($limit)) { |
67 | - $total_pages = ceil($count/$limit); |
|
67 | + $total_pages = ceil($count / $limit); |
|
68 | 68 | } |
69 | 69 | } |
70 | 70 | |
@@ -126,7 +126,7 @@ discard block |
||
126 | 126 | $response->page = $page; |
127 | 127 | $response->total = $total_pages; |
128 | 128 | $response->records = $count; |
129 | - $i=0; |
|
129 | + $i = 0; |
|
130 | 130 | |
131 | 131 | if (!empty($results)) { |
132 | 132 | foreach ($results as $row) { |
@@ -140,22 +140,22 @@ discard block |
||
140 | 140 | GROUP by question_id |
141 | 141 | ) as count_table"; |
142 | 142 | $result_count = Database::query($sql); |
143 | - $count_questions = Database::fetch_array($result_count,'ASSOC'); |
|
143 | + $count_questions = Database::fetch_array($result_count, 'ASSOC'); |
|
144 | 144 | $count_questions = $count_questions['count_question_id']; |
145 | 145 | |
146 | 146 | $row['count_questions'] = $count_questions; |
147 | 147 | |
148 | 148 | $response->rows[$i]['id'] = $row['exe_id']; |
149 | - $remaining = strtotime($row['start_date'])+($oExe->expired_time*60) - strtotime(api_get_utc_datetime(time())); |
|
150 | - $h = floor($remaining/3600); |
|
151 | - $m = floor(($remaining - ($h*3600))/60); |
|
152 | - $s = ($remaining - ($h*3600) - ($m*60)); |
|
149 | + $remaining = strtotime($row['start_date']) + ($oExe->expired_time * 60) - strtotime(api_get_utc_datetime(time())); |
|
150 | + $h = floor($remaining / 3600); |
|
151 | + $m = floor(($remaining - ($h * 3600)) / 60); |
|
152 | + $s = ($remaining - ($h * 3600) - ($m * 60)); |
|
153 | 153 | $array = array( |
154 | 154 | $row['firstname'], |
155 | 155 | $row['lastname'], |
156 | - api_format_date($row['start_date'], DATE_TIME_FORMAT_LONG).' ['.($h>0?$h.':':'').sprintf("%02d",$m).':'.sprintf("%02d",$s).']', |
|
156 | + api_format_date($row['start_date'], DATE_TIME_FORMAT_LONG).' ['.($h > 0 ? $h.':' : '').sprintf("%02d", $m).':'.sprintf("%02d", $s).']', |
|
157 | 157 | $row['count_questions'], |
158 | - round($row['score']*100).'%' |
|
158 | + round($row['score'] * 100).'%' |
|
159 | 159 | ); |
160 | 160 | $response->rows[$i]['cell'] = $array; |
161 | 161 | $i++; |
@@ -361,8 +361,8 @@ discard block |
||
361 | 361 | $objQuestionTmp = Question::read($my_question_id, $course_id); |
362 | 362 | |
363 | 363 | // Getting free choice data. |
364 | - if ($objQuestionTmp->type == FREE_ANSWER && $type == 'all') { |
|
365 | - $my_choice = isset($_REQUEST['free_choice'][$my_question_id]) && !empty($_REQUEST['free_choice'][$my_question_id]) ? $_REQUEST['free_choice'][$my_question_id]: null; |
|
364 | + if ($objQuestionTmp->type == FREE_ANSWER && $type == 'all') { |
|
365 | + $my_choice = isset($_REQUEST['free_choice'][$my_question_id]) && !empty($_REQUEST['free_choice'][$my_question_id]) ? $_REQUEST['free_choice'][$my_question_id] : null; |
|
366 | 366 | } |
367 | 367 | |
368 | 368 | if ($type == 'all') { |
@@ -518,7 +518,7 @@ discard block |
||
518 | 518 | $objQuestion = Question::read($questionId); |
519 | 519 | $objQuestion->get_question_type_name(); |
520 | 520 | |
521 | - echo '<p class="lead">' . $objQuestion->get_question_type_name() . '</p>'; |
|
521 | + echo '<p class="lead">'.$objQuestion->get_question_type_name().'</p>'; |
|
522 | 522 | //echo get_lang('Level').': '.$objQuestionTmp->selectLevel(); |
523 | 523 | ExerciseLib::showQuestion( |
524 | 524 | $questionId, |
@@ -55,56 +55,56 @@ |
||
55 | 55 | } |
56 | 56 | |
57 | 57 | switch ($action) { |
58 | - case 'chatheartbeat': |
|
59 | - $chat->heartbeat(); |
|
60 | - break; |
|
61 | - case 'closechat': |
|
62 | - $chat->close(); |
|
63 | - break; |
|
64 | - case 'sendchat': |
|
65 | - $chat->send(api_get_user_id(), $to_user_id, $message); |
|
66 | - break; |
|
67 | - case 'startchatsession': |
|
68 | - $chat->startSession(); |
|
69 | - break; |
|
70 | - case 'set_status': |
|
71 | - $status = isset($_REQUEST['status']) ? intval($_REQUEST['status']) : 0; |
|
72 | - $chat->setUserStatus($status); |
|
73 | - break; |
|
74 | - case 'create_room': |
|
75 | - $room = VideoChat::getChatRoomByUsers(api_get_user_id(), $to_user_id); |
|
76 | - |
|
77 | - if ($room === false) { |
|
78 | - $createdRoom = VideoChat::createRoom(api_get_user_id(), $to_user_id); |
|
79 | - |
|
80 | - if ($createdRoom === false) { |
|
81 | - echo Display::return_message(get_lang('ChatRoomNotCreated'), 'error'); |
|
82 | - break; |
|
58 | + case 'chatheartbeat': |
|
59 | + $chat->heartbeat(); |
|
60 | + break; |
|
61 | + case 'closechat': |
|
62 | + $chat->close(); |
|
63 | + break; |
|
64 | + case 'sendchat': |
|
65 | + $chat->send(api_get_user_id(), $to_user_id, $message); |
|
66 | + break; |
|
67 | + case 'startchatsession': |
|
68 | + $chat->startSession(); |
|
69 | + break; |
|
70 | + case 'set_status': |
|
71 | + $status = isset($_REQUEST['status']) ? intval($_REQUEST['status']) : 0; |
|
72 | + $chat->setUserStatus($status); |
|
73 | + break; |
|
74 | + case 'create_room': |
|
75 | + $room = VideoChat::getChatRoomByUsers(api_get_user_id(), $to_user_id); |
|
76 | + |
|
77 | + if ($room === false) { |
|
78 | + $createdRoom = VideoChat::createRoom(api_get_user_id(), $to_user_id); |
|
79 | + |
|
80 | + if ($createdRoom === false) { |
|
81 | + echo Display::return_message(get_lang('ChatRoomNotCreated'), 'error'); |
|
82 | + break; |
|
83 | + } |
|
84 | + |
|
85 | + $room = VideoChat::getChatRoomByUsers(api_get_user_id(), $to_user_id); |
|
83 | 86 | } |
84 | 87 | |
85 | - $room = VideoChat::getChatRoomByUsers(api_get_user_id(), $to_user_id); |
|
86 | - } |
|
87 | - |
|
88 | - $videoChatUrl = api_get_path(WEB_LIBRARY_JS_PATH) . "chat/video.php?room={$room['id']}"; |
|
89 | - $videoChatLink = Display::url( |
|
90 | - Display::returnFontAwesomeIcon('video-camera') . get_lang('StartVideoChat'), |
|
91 | - $videoChatUrl |
|
92 | - ); |
|
93 | - |
|
94 | - $chat->send( |
|
95 | - api_get_user_id(), |
|
96 | - $to_user_id, |
|
97 | - $videoChatLink, |
|
98 | - false, |
|
99 | - false |
|
100 | - ); |
|
101 | - |
|
102 | - echo Display::tag('p', $videoChatLink, ['class' => 'lead']); |
|
103 | - break; |
|
104 | - case 'notify_not_support': |
|
105 | - $chat->send(api_get_user_id(), $to_user_id, get_lang('TheXUserBrowserDoesNotSupportWebRTC')); |
|
106 | - break; |
|
107 | - default: |
|
108 | - echo ''; |
|
88 | + $videoChatUrl = api_get_path(WEB_LIBRARY_JS_PATH) . "chat/video.php?room={$room['id']}"; |
|
89 | + $videoChatLink = Display::url( |
|
90 | + Display::returnFontAwesomeIcon('video-camera') . get_lang('StartVideoChat'), |
|
91 | + $videoChatUrl |
|
92 | + ); |
|
93 | + |
|
94 | + $chat->send( |
|
95 | + api_get_user_id(), |
|
96 | + $to_user_id, |
|
97 | + $videoChatLink, |
|
98 | + false, |
|
99 | + false |
|
100 | + ); |
|
101 | + |
|
102 | + echo Display::tag('p', $videoChatLink, ['class' => 'lead']); |
|
103 | + break; |
|
104 | + case 'notify_not_support': |
|
105 | + $chat->send(api_get_user_id(), $to_user_id, get_lang('TheXUserBrowserDoesNotSupportWebRTC')); |
|
106 | + break; |
|
107 | + default: |
|
108 | + echo ''; |
|
109 | 109 | } |
110 | 110 | exit; |
@@ -5,7 +5,7 @@ discard block |
||
5 | 5 | * Responses to AJAX calls |
6 | 6 | */ |
7 | 7 | |
8 | -$_dont_save_user_course_access = true; |
|
8 | +$_dont_save_user_course_access = true; |
|
9 | 9 | |
10 | 10 | require_once __DIR__.'/../global.inc.php'; |
11 | 11 | |
@@ -26,7 +26,7 @@ discard block |
||
26 | 26 | } |
27 | 27 | |
28 | 28 | $to_user_id = isset($_REQUEST['to']) ? $_REQUEST['to'] : null; |
29 | -$message = isset($_REQUEST['message']) ? $_REQUEST['message'] : null; |
|
29 | +$message = isset($_REQUEST['message']) ? $_REQUEST['message'] : null; |
|
30 | 30 | |
31 | 31 | if (!isset($_SESSION['chatHistory'])) { |
32 | 32 | $_SESSION['chatHistory'] = array(); |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | } |
38 | 38 | |
39 | 39 | $chat = new Chat(); |
40 | -if (chat::disableChat()){ |
|
40 | +if (chat::disableChat()) { |
|
41 | 41 | exit; |
42 | 42 | } |
43 | 43 | if ($chat->is_chat_blocked_by_exercises()) { |
@@ -77,9 +77,9 @@ discard block |
||
77 | 77 | $room = VideoChat::getChatRoomByUsers(api_get_user_id(), $to_user_id); |
78 | 78 | } |
79 | 79 | |
80 | - $videoChatUrl = api_get_path(WEB_LIBRARY_JS_PATH) . "chat/video.php?room={$room['id']}"; |
|
80 | + $videoChatUrl = api_get_path(WEB_LIBRARY_JS_PATH)."chat/video.php?room={$room['id']}"; |
|
81 | 81 | $videoChatLink = Display::url( |
82 | - Display::returnFontAwesomeIcon('video-camera') . get_lang('StartVideoChat'), |
|
82 | + Display::returnFontAwesomeIcon('video-camera').get_lang('StartVideoChat'), |
|
83 | 83 | $videoChatUrl |
84 | 84 | ); |
85 | 85 |
@@ -58,7 +58,7 @@ discard block |
||
58 | 58 | <div class="row"> |
59 | 59 | <div class="col-sm-10 col-sm-offset-2"> |
60 | 60 | <a class="btn btn-primary" id="send_message_link"> |
61 | - <em class="fa fa-envelope"></em> ' . get_lang('Send') . ' |
|
61 | + <em class="fa fa-envelope"></em> ' . get_lang('Send').' |
|
62 | 62 | </a> |
63 | 63 | </div> |
64 | 64 | </div> |
@@ -112,7 +112,7 @@ discard block |
||
112 | 112 | |
113 | 113 | if (!empty($user_id)) { |
114 | 114 | $user_table = Database :: get_main_table(TABLE_MAIN_USER); |
115 | - $sql="UPDATE $user_table SET active='".$status."' WHERE user_id='".$user_id."'"; |
|
115 | + $sql = "UPDATE $user_table SET active='".$status."' WHERE user_id='".$user_id."'"; |
|
116 | 116 | $result = Database::query($sql); |
117 | 117 | |
118 | 118 | //Send and email if account is active |
@@ -122,13 +122,13 @@ discard block |
||
122 | 122 | $emailsubject = '['.api_get_setting('siteName').'] '.get_lang('YourReg').' '.api_get_setting('siteName'); |
123 | 123 | $email_admin = api_get_setting('emailAdministrator'); |
124 | 124 | $sender_name = api_get_person_name(api_get_setting('administratorName'), api_get_setting('administratorSurname'), null, PERSON_NAME_EMAIL_ADDRESS); |
125 | - $emailbody=get_lang('Dear')." ".stripslashes($recipient_name).",\n\n"; |
|
125 | + $emailbody = get_lang('Dear')." ".stripslashes($recipient_name).",\n\n"; |
|
126 | 126 | |
127 | - $emailbody.=sprintf(get_lang('YourAccountOnXHasJustBeenApprovedByOneOfOurAdministrators'), api_get_setting('siteName'))."\n"; |
|
128 | - $emailbody.=sprintf(get_lang('YouCanNowLoginAtXUsingTheLoginAndThePasswordYouHaveProvided'), api_get_path(WEB_PATH)).",\n\n"; |
|
129 | - $emailbody.=get_lang('HaveFun')."\n\n"; |
|
127 | + $emailbody .= sprintf(get_lang('YourAccountOnXHasJustBeenApprovedByOneOfOurAdministrators'), api_get_setting('siteName'))."\n"; |
|
128 | + $emailbody .= sprintf(get_lang('YouCanNowLoginAtXUsingTheLoginAndThePasswordYouHaveProvided'), api_get_path(WEB_PATH)).",\n\n"; |
|
129 | + $emailbody .= get_lang('HaveFun')."\n\n"; |
|
130 | 130 | //$emailbody.=get_lang('Problem'). "\n\n". get_lang('SignatureFormula'); |
131 | - $emailbody.=api_get_person_name(api_get_setting('administratorName'), api_get_setting('administratorSurname'))."\n". get_lang('Manager'). " ".api_get_setting('siteName')."\nT. ".api_get_setting('administratorTelephone')."\n" .get_lang('Email') ." : ".api_get_setting('emailAdministrator'); |
|
131 | + $emailbody .= api_get_person_name(api_get_setting('administratorName'), api_get_setting('administratorSurname'))."\n".get_lang('Manager')." ".api_get_setting('siteName')."\nT. ".api_get_setting('administratorTelephone')."\n".get_lang('Email')." : ".api_get_setting('emailAdministrator'); |
|
132 | 132 | |
133 | 133 | $additionalParameters = array( |
134 | 134 | 'smsType' => SmsPlugin::ACCOUNT_APPROVED_CONNECT, |