@@ -44,121 +44,121 @@ |
||
44 | 44 | $users=Database::store_result($result); |
45 | 45 | |
46 | 46 | foreach($Sessions as $session){ |
47 | - $id_session = $session['id']; |
|
48 | - $name_session = $session['name']; |
|
49 | - $UserList=array(); |
|
50 | - $UserUpdate=array(); |
|
51 | - $UserAdd=array(); |
|
47 | + $id_session = $session['id']; |
|
48 | + $name_session = $session['name']; |
|
49 | + $UserList=array(); |
|
50 | + $UserUpdate=array(); |
|
51 | + $UserAdd=array(); |
|
52 | 52 | |
53 | - // Parse des code etape de la session |
|
54 | - /* |
|
53 | + // Parse des code etape de la session |
|
54 | + /* |
|
55 | 55 | $sql = "SELECT id_session, code_etape, etape_description, code_ufr, annee |
56 | 56 | FROM $tbl_session_rel_etape |
57 | 57 | WHERE id_session='$id_session' |
58 | 58 | ORDER BY code_ufr, code_etape"; |
59 | 59 | $result = Database::query($sql); |
60 | 60 | */ |
61 | - $ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError')); |
|
62 | - ldap_set_version($ds); |
|
63 | - // Import des utilisateurs des etapes dans la session |
|
64 | - if ($ds) |
|
65 | - { |
|
66 | - $r = false; |
|
67 | - $res = ldap_handle_bind($ds, $r); |
|
68 | - $UserList=array(); |
|
69 | - if($result !== false) |
|
70 | - { |
|
71 | - //while($row = Database::fetch_array($result)) |
|
72 | - //{ |
|
73 | - /* |
|
61 | + $ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError')); |
|
62 | + ldap_set_version($ds); |
|
63 | + // Import des utilisateurs des etapes dans la session |
|
64 | + if ($ds) |
|
65 | + { |
|
66 | + $r = false; |
|
67 | + $res = ldap_handle_bind($ds, $r); |
|
68 | + $UserList=array(); |
|
69 | + if($result !== false) |
|
70 | + { |
|
71 | + //while($row = Database::fetch_array($result)) |
|
72 | + //{ |
|
73 | + /* |
|
74 | 74 | $annee = $row['annee']; |
75 | 75 | $code_ufr = $row['code_ufr']; |
76 | 76 | $etape = $row['code_etape']; |
77 | 77 | */ |
78 | - // LDAP Query |
|
79 | - // edupersonorgunitdn=ou=12CI1,ou=2006,ou=diploma,o=Paris1,dc=univ-paris1,dc=fr |
|
80 | - //etapescommented |
|
81 | - //$sr = @ ldap_search($ds, "ou=people,$LDAPbasedn", "edupersonorgunitdn=ou=$etape,ou=$annee,ou=diploma,$LDAPbasedn"); |
|
82 | - $sr = @ ldap_search($ds, $ldap_basedn, '(uid=*)'); |
|
83 | - $info = ldap_get_entries($ds, $sr); |
|
84 | - for ($key = 0; $key < $info["count"]; $key ++) |
|
85 | - { |
|
86 | - echo "<pre>"; |
|
87 | - print_r($info[$key]); |
|
88 | - echo "</pre>"; |
|
89 | - $lastname = api_utf8_decode($info[$key]["sn"][0]); |
|
90 | - $firstname = api_utf8_decode($info[$key]["givenname"][0]); |
|
91 | - $email = $info[$key]["mail"][0]; |
|
92 | - // Get uid from dn |
|
93 | - $dn_array=ldap_explode_dn($info[$key]["dn"],1); |
|
94 | - $username = $dn_array[0]; // uid is first key |
|
95 | - $outab[] = $info[$key]["edupersonprimaryaffiliation"][0]; // Ici "student" |
|
96 | - $val = ldap_get_values_len($ds, $sr, "userPassword"); |
|
97 | - $password = $val[0]; |
|
98 | - // Pour faciliter la gestion on ajoute le code "etape-annee" |
|
99 | - $official_code=$etape."-".$annee; |
|
100 | - $auth_source="ldap"; |
|
101 | - // Pas de date d'expiration d'etudiant (a recuperer par rapport au shadow expire LDAP) |
|
102 | - $expiration_date='0000-00-00 00:00:00'; |
|
103 | - $active=1; |
|
104 | - // Ajout de l'utilisateur |
|
105 | - if (UserManager::is_username_available($username)) { |
|
106 | - $user_id = UserManager::create_user($firstname,$lastname,$status,$email,$username,$password,$official_code,api_get_setting('platformLanguage'),$phone,$picture_uri,$auth_source,$expiration_date,$active); |
|
107 | - $UserAdd[]=$user_id; |
|
108 | - } else { |
|
109 | - $user = api_get_user_info_from_username($username); |
|
110 | - $user_id=$user['user_id']; |
|
111 | - UserManager::update_user($user_id, $firstname, $lastname, $username, null, null, $email, $status, $official_code, $phone, $picture_uri, $expiration_date, $active); |
|
112 | - $UserUpdate[]=$user_id; |
|
113 | - } |
|
114 | - $UserList[]=$user_id; |
|
115 | - } |
|
116 | - //} |
|
117 | - } |
|
118 | - if (isset($included) && ($included)) |
|
119 | - { |
|
120 | - $message .= "> $name_session: ".count($UserAdd)." ".get_lang('Added').' '.get_lang('And').' '.count($UserUpdate).' '.get_lang('Modified').'<br/>'; |
|
121 | - } |
|
122 | - else |
|
123 | - { |
|
124 | - print "> $name_session: ".count($UserAdd).get_lang('Added').' '.get_lang('And').' '.count($UserUpdate).' '.get_lang('Modified')."\n"; |
|
125 | - } |
|
78 | + // LDAP Query |
|
79 | + // edupersonorgunitdn=ou=12CI1,ou=2006,ou=diploma,o=Paris1,dc=univ-paris1,dc=fr |
|
80 | + //etapescommented |
|
81 | + //$sr = @ ldap_search($ds, "ou=people,$LDAPbasedn", "edupersonorgunitdn=ou=$etape,ou=$annee,ou=diploma,$LDAPbasedn"); |
|
82 | + $sr = @ ldap_search($ds, $ldap_basedn, '(uid=*)'); |
|
83 | + $info = ldap_get_entries($ds, $sr); |
|
84 | + for ($key = 0; $key < $info["count"]; $key ++) |
|
85 | + { |
|
86 | + echo "<pre>"; |
|
87 | + print_r($info[$key]); |
|
88 | + echo "</pre>"; |
|
89 | + $lastname = api_utf8_decode($info[$key]["sn"][0]); |
|
90 | + $firstname = api_utf8_decode($info[$key]["givenname"][0]); |
|
91 | + $email = $info[$key]["mail"][0]; |
|
92 | + // Get uid from dn |
|
93 | + $dn_array=ldap_explode_dn($info[$key]["dn"],1); |
|
94 | + $username = $dn_array[0]; // uid is first key |
|
95 | + $outab[] = $info[$key]["edupersonprimaryaffiliation"][0]; // Ici "student" |
|
96 | + $val = ldap_get_values_len($ds, $sr, "userPassword"); |
|
97 | + $password = $val[0]; |
|
98 | + // Pour faciliter la gestion on ajoute le code "etape-annee" |
|
99 | + $official_code=$etape."-".$annee; |
|
100 | + $auth_source="ldap"; |
|
101 | + // Pas de date d'expiration d'etudiant (a recuperer par rapport au shadow expire LDAP) |
|
102 | + $expiration_date='0000-00-00 00:00:00'; |
|
103 | + $active=1; |
|
104 | + // Ajout de l'utilisateur |
|
105 | + if (UserManager::is_username_available($username)) { |
|
106 | + $user_id = UserManager::create_user($firstname,$lastname,$status,$email,$username,$password,$official_code,api_get_setting('platformLanguage'),$phone,$picture_uri,$auth_source,$expiration_date,$active); |
|
107 | + $UserAdd[]=$user_id; |
|
108 | + } else { |
|
109 | + $user = api_get_user_info_from_username($username); |
|
110 | + $user_id=$user['user_id']; |
|
111 | + UserManager::update_user($user_id, $firstname, $lastname, $username, null, null, $email, $status, $official_code, $phone, $picture_uri, $expiration_date, $active); |
|
112 | + $UserUpdate[]=$user_id; |
|
113 | + } |
|
114 | + $UserList[]=$user_id; |
|
115 | + } |
|
116 | + //} |
|
117 | + } |
|
118 | + if (isset($included) && ($included)) |
|
119 | + { |
|
120 | + $message .= "> $name_session: ".count($UserAdd)." ".get_lang('Added').' '.get_lang('And').' '.count($UserUpdate).' '.get_lang('Modified').'<br/>'; |
|
121 | + } |
|
122 | + else |
|
123 | + { |
|
124 | + print "> $name_session: ".count($UserAdd).get_lang('Added').' '.get_lang('And').' '.count($UserUpdate).' '.get_lang('Modified')."\n"; |
|
125 | + } |
|
126 | 126 | |
127 | - // Une fois les utilisateurs importer dans la base des utilisateurs, on peux les affecter la session |
|
128 | - $result=Database::query("SELECT c_id FROM $tbl_session_rel_course WHERE session_id='$id_session'"); |
|
129 | - $CourseList=array(); |
|
130 | - while($row=Database::fetch_array($result)) { |
|
131 | - $CourseList[]= $row['c_id']; |
|
132 | - } |
|
127 | + // Une fois les utilisateurs importer dans la base des utilisateurs, on peux les affecter la session |
|
128 | + $result=Database::query("SELECT c_id FROM $tbl_session_rel_course WHERE session_id='$id_session'"); |
|
129 | + $CourseList=array(); |
|
130 | + while($row=Database::fetch_array($result)) { |
|
131 | + $CourseList[]= $row['c_id']; |
|
132 | + } |
|
133 | 133 | |
134 | - foreach ($CourseList as $enreg_course) { |
|
135 | - // On ajoute la relation entre l'utilisateur et le cours |
|
136 | - foreach ($UserList as $enreg_user) { |
|
137 | - $sql = "INSERT IGNORE INTO $tbl_session_rel_course_rel_user(session_id,c_id,user_id) |
|
134 | + foreach ($CourseList as $enreg_course) { |
|
135 | + // On ajoute la relation entre l'utilisateur et le cours |
|
136 | + foreach ($UserList as $enreg_user) { |
|
137 | + $sql = "INSERT IGNORE INTO $tbl_session_rel_course_rel_user(session_id,c_id,user_id) |
|
138 | 138 | VALUES('$id_session','$enreg_course','$enreg_user')"; |
139 | - Database::query($sql); |
|
140 | - } |
|
141 | - $sql = "SELECT COUNT(user_id) as nbUsers " . |
|
142 | - "FROM $tbl_session_rel_course_rel_user " . |
|
143 | - "WHERE session_id='$id_session' AND c_id='$enreg_course'"; |
|
144 | - $rs = Database::query($sql); |
|
145 | - list($nbr_users) = Database::fetch_array($rs); |
|
146 | - $sql = "UPDATE $tbl_session_rel_course SET nbr_users=$nbr_users |
|
139 | + Database::query($sql); |
|
140 | + } |
|
141 | + $sql = "SELECT COUNT(user_id) as nbUsers " . |
|
142 | + "FROM $tbl_session_rel_course_rel_user " . |
|
143 | + "WHERE session_id='$id_session' AND c_id='$enreg_course'"; |
|
144 | + $rs = Database::query($sql); |
|
145 | + list($nbr_users) = Database::fetch_array($rs); |
|
146 | + $sql = "UPDATE $tbl_session_rel_course SET nbr_users=$nbr_users |
|
147 | 147 | WHERE session_id='$id_session' AND c_id = '$enreg_course'"; |
148 | - Database::query($sql); |
|
149 | - } |
|
150 | - // On ajoute la relation entre l'utilisateur et la session |
|
151 | - foreach($UserList as $enreg_user){ |
|
152 | - $sql = "INSERT IGNORE INTO $tbl_session_rel_user(session_id, user_id, registered_at) " . |
|
153 | - "VALUES('$id_session','$enreg_user', '" . api_get_utc_datetime() . "')"; |
|
154 | - Database::query($sql); |
|
155 | - } |
|
156 | - $sql = "SELECT COUNT(user_id) as nbUsers " . |
|
157 | - "FROM $tbl_session_rel_user " . |
|
158 | - "WHERE session_id='$id_session' AND relation_type<>".SESSION_RELATION_TYPE_RRHH.""; |
|
159 | - $rs = Database::query($sql); |
|
160 | - list($nbr_users) = Database::fetch_array($rs); |
|
161 | - $sql = "UPDATE $tbl_session SET nbr_users=$nbr_users WHERE id='$id_session'"; |
|
162 | - Database::query($sql); |
|
163 | - } |
|
148 | + Database::query($sql); |
|
149 | + } |
|
150 | + // On ajoute la relation entre l'utilisateur et la session |
|
151 | + foreach($UserList as $enreg_user){ |
|
152 | + $sql = "INSERT IGNORE INTO $tbl_session_rel_user(session_id, user_id, registered_at) " . |
|
153 | + "VALUES('$id_session','$enreg_user', '" . api_get_utc_datetime() . "')"; |
|
154 | + Database::query($sql); |
|
155 | + } |
|
156 | + $sql = "SELECT COUNT(user_id) as nbUsers " . |
|
157 | + "FROM $tbl_session_rel_user " . |
|
158 | + "WHERE session_id='$id_session' AND relation_type<>".SESSION_RELATION_TYPE_RRHH.""; |
|
159 | + $rs = Database::query($sql); |
|
160 | + list($nbr_users) = Database::fetch_array($rs); |
|
161 | + $sql = "UPDATE $tbl_session SET nbr_users=$nbr_users WHERE id='$id_session'"; |
|
162 | + Database::query($sql); |
|
163 | + } |
|
164 | 164 | } |
@@ -30,8 +30,8 @@ discard block |
||
30 | 30 | $output = array(); |
31 | 31 | if (!empty($_GET['fill'])) { |
32 | 32 | switch ($_GET['fill']) { |
33 | - case 'users': |
|
34 | - require api_get_path(SYS_TEST_PATH).'datafiller/fill_users.php'; |
|
33 | + case 'users': |
|
34 | + require api_get_path(SYS_TEST_PATH).'datafiller/fill_users.php'; |
|
35 | 35 | $output = fill_users(); |
36 | 36 | break; |
37 | 37 | case 'courses': |
@@ -53,8 +53,8 @@ discard block |
||
53 | 53 | $result .= '<table>'; |
54 | 54 | foreach ($output as $line) { |
55 | 55 | $result .= '<tr>'; |
56 | - $result .= '<td class="filler-report-data-init">'.$line['line-init'].' </td><td class="filler-report-data">'.$line['line-info'].'</td>'; |
|
57 | - $result .= '</tr>'; |
|
56 | + $result .= '<td class="filler-report-data-init">'.$line['line-init'].' </td><td class="filler-report-data">'.$line['line-info'].'</td>'; |
|
57 | + $result .= '</tr>'; |
|
58 | 58 | } |
59 | 59 | $result .= '</table>'; |
60 | 60 | $result .= '</div>'; |
@@ -124,11 +124,11 @@ discard block |
||
124 | 124 | } |
125 | 125 | |
126 | 126 | if ($add_type == 'multiple') { |
127 | - $link_add_type_unique = '<a href="'.api_get_self().'?add_type=unique&access_url_id='.$access_url_id.'">'.get_lang('SessionAddTypeUnique').'</a>'; |
|
128 | - $link_add_type_multiple = get_lang('SessionAddTypeMultiple'); |
|
127 | + $link_add_type_unique = '<a href="'.api_get_self().'?add_type=unique&access_url_id='.$access_url_id.'">'.get_lang('SessionAddTypeUnique').'</a>'; |
|
128 | + $link_add_type_multiple = get_lang('SessionAddTypeMultiple'); |
|
129 | 129 | } else { |
130 | - $link_add_type_unique = get_lang('SessionAddTypeUnique'); |
|
131 | - $link_add_type_multiple = '<a href="'.api_get_self().'?add_type=multiple&access_url_id='.$access_url_id.'">'.get_lang('SessionAddTypeMultiple').'</a>'; |
|
130 | + $link_add_type_unique = get_lang('SessionAddTypeUnique'); |
|
131 | + $link_add_type_multiple = '<a href="'.api_get_self().'?add_type=multiple&access_url_id='.$access_url_id.'">'.get_lang('SessionAddTypeMultiple').'</a>'; |
|
132 | 132 | } |
133 | 133 | |
134 | 134 | $url_list = UrlManager::get_url_data(); |
@@ -192,34 +192,34 @@ discard block |
||
192 | 192 | <?php } else { ?> |
193 | 193 | <select id="origin_users" name="no_course_list[]" multiple="multiple" size="15" style="width:380px;"> |
194 | 194 | <?php |
195 | - foreach ($noUserGroupList as $noItem) { |
|
196 | - ?> |
|
195 | + foreach ($noUserGroupList as $noItem) { |
|
196 | + ?> |
|
197 | 197 | <option value="<?php echo $noItem['id']; ?>"> |
198 | 198 | <?php echo $noItem['name']; ?> |
199 | 199 | </option> |
200 | 200 | <?php |
201 | - } |
|
202 | - ?> |
|
201 | + } |
|
202 | + ?> |
|
203 | 203 | </select> |
204 | 204 | <?php |
205 | - } |
|
206 | - ?> |
|
205 | + } |
|
206 | + ?> |
|
207 | 207 | </div> |
208 | 208 | </td> |
209 | 209 | <td width="10%" valign="middle" align="center"> |
210 | 210 | <?php |
211 | - if ($ajax_search) { |
|
212 | - ?> |
|
211 | + if ($ajax_search) { |
|
212 | + ?> |
|
213 | 213 | <button class="btn btn-default" type="button" onclick="remove_item(document.getElementById('destination_users'))" ></button> |
214 | 214 | <?php |
215 | - } else { |
|
216 | - ?> |
|
215 | + } else { |
|
216 | + ?> |
|
217 | 217 | <button class="arrowr" type="button" onclick="moveItem(document.getElementById('origin_users'), document.getElementById('destination_users'))" ></button> |
218 | 218 | <br /><br /> |
219 | 219 | <button class="btn btn-default" type="button" onclick="moveItem(document.getElementById('destination_users'), document.getElementById('origin_users'))" ></button> |
220 | 220 | <?php |
221 | - } |
|
222 | - ?> |
|
221 | + } |
|
222 | + ?> |
|
223 | 223 | <br /><br /><br /><br /><br /><br /> |
224 | 224 | </td> |
225 | 225 | <td align="center"> |
@@ -240,11 +240,11 @@ discard block |
||
240 | 240 | <td colspan="3" align="center"> |
241 | 241 | <br /> |
242 | 242 | <?php |
243 | - if(isset($_GET['add'])) |
|
244 | - echo '<button class="save" onclick="valide()" >'.get_lang('Add').'</button>'; |
|
245 | - else |
|
246 | - echo '<button class="save" onclick="valide()" >'.get_lang('Edit').'</button>'; |
|
247 | - ?> |
|
243 | + if(isset($_GET['add'])) |
|
244 | + echo '<button class="save" onclick="valide()" >'.get_lang('Add').'</button>'; |
|
245 | + else |
|
246 | + echo '<button class="save" onclick="valide()" >'.get_lang('Edit').'</button>'; |
|
247 | + ?> |
|
248 | 248 | </td> |
249 | 249 | </tr> |
250 | 250 | </table> |
@@ -401,7 +401,7 @@ discard block |
||
401 | 401 | <?php |
402 | 402 | $selected_letter = isset($_POST['firstLetterUser']) ? $_POST['firstLetterUser'] : null; |
403 | 403 | echo Display :: get_alphabet_options($selected_letter); |
404 | - ?> |
|
404 | + ?> |
|
405 | 405 | </select> |
406 | 406 | </div> |
407 | 407 | </td> |
@@ -412,59 +412,59 @@ discard block |
||
412 | 412 | <td align="center"> |
413 | 413 | <div id="content_source"> |
414 | 414 | <?php |
415 | - if (!($add_type=='multiple')) { |
|
416 | - ?> |
|
415 | + if (!($add_type=='multiple')) { |
|
416 | + ?> |
|
417 | 417 | <input type="text" id="user_to_add" onkeyup="xajax_search_users(this.value,'single',document.getElementById('relation').value)" /> |
418 | 418 | <div id="ajax_list_users_single"></div> |
419 | 419 | <?php |
420 | - } else { |
|
421 | - ?> |
|
420 | + } else { |
|
421 | + ?> |
|
422 | 422 | <div id="ajax_origin_list_multiple"> |
423 | 423 | <select id="origin_users" name="nosessionUsersList[]" multiple="multiple" size="15" style="width:360px;"> |
424 | 424 | <?php |
425 | - if (!empty($nosessionUsersList)) { |
|
426 | - foreach($nosessionUsersList as $enreg) { |
|
427 | - ?> |
|
425 | + if (!empty($nosessionUsersList)) { |
|
426 | + foreach($nosessionUsersList as $enreg) { |
|
427 | + ?> |
|
428 | 428 | <option value="<?php echo $enreg['user_id']; ?>" > <?php echo $enreg['firstname'].' '.$enreg['lastname'].' ('.$enreg['username'].')'; ?></option> |
429 | 429 | <?php |
430 | - } |
|
431 | - } |
|
432 | - ?> |
|
430 | + } |
|
431 | + } |
|
432 | + ?> |
|
433 | 433 | </select> |
434 | 434 | </div> |
435 | 435 | <?php |
436 | - } |
|
437 | - unset($nosessionUsersList); |
|
438 | - ?> |
|
436 | + } |
|
437 | + unset($nosessionUsersList); |
|
438 | + ?> |
|
439 | 439 | </div> |
440 | 440 | </td> |
441 | 441 | <td width="10%" valign="middle" align="center"> |
442 | 442 | <?php |
443 | - if ($ajax_search) { |
|
444 | - ?> |
|
443 | + if ($ajax_search) { |
|
444 | + ?> |
|
445 | 445 | <button class="btn btn-default" type="button" onclick="remove_item(document.getElementById('destination_users'))" ><em class="fa fa-arrow-left"></em></button> |
446 | 446 | <?php |
447 | - } else { |
|
448 | - ?> |
|
447 | + } else { |
|
448 | + ?> |
|
449 | 449 | <button class="btn btn-default" type="button" onclick="moveItem(document.getElementById('origin_users'), document.getElementById('destination_users'))" onclick="moveItem(document.getElementById('origin_users'), document.getElementById('destination_users'))"><em class="fa fa-arrow-right"></em></button> |
450 | 450 | <br /><br /> |
451 | 451 | <button class="btn btn-default" type="button" onclick="moveItem(document.getElementById('destination_users'), document.getElementById('origin_users'))" onclick="moveItem(document.getElementById('destination_users'), document.getElementById('origin_users'))"><em class="fa fa-arrow-left"></em></button> |
452 | 452 | <?php |
453 | - } |
|
454 | - ?> |
|
453 | + } |
|
454 | + ?> |
|
455 | 455 | <br /><br /><br /><br /><br /> |
456 | 456 | </td> |
457 | 457 | <td align="center"> |
458 | 458 | <div id="ajax_destination_list"> |
459 | 459 | <select id="destination_users" name="sessionUsersList[]" multiple="multiple" size="15" style="width:360px;"> |
460 | 460 | <?php |
461 | - if (!empty($sessionUsersList)) { |
|
462 | - foreach($sessionUsersList as $enreg) { ?> |
|
461 | + if (!empty($sessionUsersList)) { |
|
462 | + foreach($sessionUsersList as $enreg) { ?> |
|
463 | 463 | <option value="<?php echo $enreg['user_id']; ?>"> |
464 | 464 | <?php echo $enreg['firstname'].' '.$enreg['lastname'].' ('.$enreg['username'].')'; ?> |
465 | 465 | </option> |
466 | 466 | <?php } |
467 | - } unset($sessionUsersList); |
|
467 | + } unset($sessionUsersList); |
|
468 | 468 | ?> |
469 | 469 | </select> |
470 | 470 | </div> |
@@ -474,8 +474,8 @@ discard block |
||
474 | 474 | <td colspan="3" align="center"> |
475 | 475 | <br /> |
476 | 476 | <?php |
477 | - echo '<button class="btn btn-success" type="button" value="" onclick="valide()" ><em class="fa fa-floppy-o"></em> '.get_lang('SubscribeUsersToGroup').'</button>'; |
|
478 | - ?> |
|
477 | + echo '<button class="btn btn-success" type="button" value="" onclick="valide()" ><em class="fa fa-floppy-o"></em> '.get_lang('SubscribeUsersToGroup').'</button>'; |
|
478 | + ?> |
|
479 | 479 | </td> |
480 | 480 | </tr> |
481 | 481 | </table> |
@@ -43,15 +43,15 @@ discard block |
||
43 | 43 | $table->set_column_filter(3, 'edit_filter'); |
44 | 44 | |
45 | 45 | function edit_filter($id,$url_params,$row) { |
46 | - global $charset; |
|
47 | - $return = '<a href="specific_fields_add.php?action=edit&field_id='.$row[0].'">'.Display::return_icon('edit.gif',get_lang('Edit')).'</a>'; |
|
48 | - $return .= ' <a href="'.api_get_self().'?action=delete&field_id='.$row[0].'" onclick="javascript:if(!confirm('."'".addslashes(api_htmlentities(get_lang("ConfirmYourChoice"),ENT_QUOTES,$charset))."'".')) return false;">'.Display::return_icon('delete.gif',get_lang('Delete')).'</a>'; |
|
49 | - return $return; |
|
46 | + global $charset; |
|
47 | + $return = '<a href="specific_fields_add.php?action=edit&field_id='.$row[0].'">'.Display::return_icon('edit.gif',get_lang('Edit')).'</a>'; |
|
48 | + $return .= ' <a href="'.api_get_self().'?action=delete&field_id='.$row[0].'" onclick="javascript:if(!confirm('."'".addslashes(api_htmlentities(get_lang("ConfirmYourChoice"),ENT_QUOTES,$charset))."'".')) return false;">'.Display::return_icon('delete.gif',get_lang('Delete')).'</a>'; |
|
49 | + return $return; |
|
50 | 50 | } |
51 | 51 | |
52 | 52 | if ($_REQUEST['action'] == 'delete') { |
53 | - delete_specific_field($_REQUEST['field_id']); |
|
54 | - header('Location: specific_fields.php?message='.get_lang('FieldRemoved')); |
|
53 | + delete_specific_field($_REQUEST['field_id']); |
|
54 | + header('Location: specific_fields.php?message='.get_lang('FieldRemoved')); |
|
55 | 55 | } |
56 | 56 | |
57 | 57 | // Start output |
@@ -61,7 +61,7 @@ discard block |
||
61 | 61 | echo Display::display_normal_message(get_lang('SpecificSearchFieldsIntro')); |
62 | 62 | |
63 | 63 | if(!empty($_GET['message'])) { |
64 | - Display::display_confirmation_message($_GET['message']); |
|
64 | + Display::display_confirmation_message($_GET['message']); |
|
65 | 65 | } |
66 | 66 | |
67 | 67 | echo '<div class="actions">'; |
@@ -14,24 +14,24 @@ discard block |
||
14 | 14 | $message = ''; |
15 | 15 | |
16 | 16 | if (isset($_POST['activeExtension'])) { |
17 | - switch ($_POST['extension_code']) { |
|
18 | - case 'visio' : |
|
19 | - $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
17 | + switch ($_POST['extension_code']) { |
|
18 | + case 'visio' : |
|
19 | + $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
20 | 20 | selected_value="true" |
21 | 21 | WHERE variable="service_visio" |
22 | 22 | AND subkey="active"'; |
23 | - $rs = Database::query($sql); |
|
24 | - if (Database::affected_rows($rs)>0) { |
|
25 | - // select all the courses and insert the tool inside |
|
26 | - $sql = 'SELECT id FROM '.Database::get_main_table(TABLE_MAIN_COURSE); |
|
27 | - $rs = Database::query($sql); |
|
28 | - while($row = Database::fetch_array($rs)){ |
|
29 | - if(!empty($_POST['visio_host'])) { |
|
30 | - $tool_table = Database::get_course_table(TABLE_TOOL_LIST); |
|
31 | - $select = "SELECT id FROM $tool_table WHERE c_id =".$row['id']." AND name='".TOOL_VISIO_CONFERENCE."'"; |
|
32 | - $selectres = Database::query($select); |
|
33 | - if (Database::num_rows($selectres)<1) { |
|
34 | - $sql = 'INSERT INTO '.$tool_table.' SET |
|
23 | + $rs = Database::query($sql); |
|
24 | + if (Database::affected_rows($rs)>0) { |
|
25 | + // select all the courses and insert the tool inside |
|
26 | + $sql = 'SELECT id FROM '.Database::get_main_table(TABLE_MAIN_COURSE); |
|
27 | + $rs = Database::query($sql); |
|
28 | + while($row = Database::fetch_array($rs)){ |
|
29 | + if(!empty($_POST['visio_host'])) { |
|
30 | + $tool_table = Database::get_course_table(TABLE_TOOL_LIST); |
|
31 | + $select = "SELECT id FROM $tool_table WHERE c_id =".$row['id']." AND name='".TOOL_VISIO_CONFERENCE."'"; |
|
32 | + $selectres = Database::query($select); |
|
33 | + if (Database::num_rows($selectres)<1) { |
|
34 | + $sql = 'INSERT INTO '.$tool_table.' SET |
|
35 | 35 | c_id = '.$row['id'].', |
36 | 36 | name="'.TOOL_VISIO_CONFERENCE.'", |
37 | 37 | link="conference/index.php?type=conference", |
@@ -41,12 +41,12 @@ discard block |
||
41 | 41 | address="squaregrey.gif", |
42 | 42 | target="_self", |
43 | 43 | category="interaction"'; |
44 | - Database::query($sql); |
|
45 | - } |
|
46 | - $select = "SELECT id FROM $tool_table WHERE c_id =".$row['id']." AND name='".TOOL_VISIO_CLASSROOM."'"; |
|
47 | - $selectres = Database::query($select); |
|
48 | - if(Database::num_rows($selectres)<1) { |
|
49 | - $sql = 'INSERT INTO '.$tool_table.' SET |
|
44 | + Database::query($sql); |
|
45 | + } |
|
46 | + $select = "SELECT id FROM $tool_table WHERE c_id =".$row['id']." AND name='".TOOL_VISIO_CLASSROOM."'"; |
|
47 | + $selectres = Database::query($select); |
|
48 | + if(Database::num_rows($selectres)<1) { |
|
49 | + $sql = 'INSERT INTO '.$tool_table.' SET |
|
50 | 50 | c_id = '.$row['id'].', |
51 | 51 | name="'.TOOL_VISIO_CLASSROOM.'", |
52 | 52 | link="conference/index.php?type=classroom", |
@@ -56,92 +56,92 @@ discard block |
||
56 | 56 | address="squaregrey.gif", |
57 | 57 | target="_self", |
58 | 58 | category="authoring"'; |
59 | - Database::query($sql); |
|
60 | - } |
|
61 | - } |
|
62 | - } |
|
63 | - $message = get_lang('ServiceActivated'); |
|
64 | - |
|
65 | - } |
|
66 | - $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
59 | + Database::query($sql); |
|
60 | + } |
|
61 | + } |
|
62 | + } |
|
63 | + $message = get_lang('ServiceActivated'); |
|
64 | + |
|
65 | + } |
|
66 | + $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
67 | 67 | selected_value="'.Database::escape_string($_POST['visio_host']).'" |
68 | 68 | WHERE variable="service_visio" |
69 | 69 | AND subkey="visio_host"'; |
70 | - $rs = Database::query($sql); |
|
70 | + $rs = Database::query($sql); |
|
71 | 71 | |
72 | - $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
72 | + $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
73 | 73 | selected_value="'.Database::escape_string($_POST['visio_port']).'" |
74 | 74 | WHERE variable="service_visio" |
75 | 75 | AND subkey="visio_port"'; |
76 | - $rs = Database::query($sql); |
|
76 | + $rs = Database::query($sql); |
|
77 | 77 | |
78 | - $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
78 | + $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
79 | 79 | selected_value="'.Database::escape_string($_POST['visio_pass']).'" |
80 | 80 | WHERE variable="service_visio" |
81 | 81 | AND subkey="visio_pass"'; |
82 | - $rs = Database::query($sql); |
|
82 | + $rs = Database::query($sql); |
|
83 | 83 | |
84 | - $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
84 | + $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
85 | 85 | selected_value="'.($_POST['visio_use_rtmpt']=='true'?'true':'false').'" |
86 | 86 | WHERE variable="service_visio" |
87 | 87 | AND subkey="visio_use_rtmpt"'; |
88 | - $rs = Database::query($sql); |
|
88 | + $rs = Database::query($sql); |
|
89 | 89 | |
90 | - if(empty($message)) { |
|
91 | - $message = get_lang('ServiceReconfigured'); |
|
92 | - } |
|
93 | - break; |
|
90 | + if(empty($message)) { |
|
91 | + $message = get_lang('ServiceReconfigured'); |
|
92 | + } |
|
93 | + break; |
|
94 | 94 | |
95 | - case 'ppt2lp' : |
|
96 | - $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
95 | + case 'ppt2lp' : |
|
96 | + $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
97 | 97 | selected_value="true" |
98 | 98 | WHERE variable="service_ppt2lp" |
99 | 99 | AND subkey="active"'; |
100 | 100 | |
101 | - $rs = Database::query($sql); |
|
101 | + $rs = Database::query($sql); |
|
102 | 102 | |
103 | - if (Database::affected_rows($rs)>0){ |
|
104 | - $message = get_lang('ServiceActivated'); |
|
105 | - } |
|
103 | + if (Database::affected_rows($rs)>0){ |
|
104 | + $message = get_lang('ServiceActivated'); |
|
105 | + } |
|
106 | 106 | |
107 | - $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
107 | + $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
108 | 108 | selected_value="'.addslashes($_POST['host']).'" |
109 | 109 | WHERE variable="service_ppt2lp" |
110 | 110 | AND subkey="host"'; |
111 | - Database::query($sql); |
|
111 | + Database::query($sql); |
|
112 | 112 | |
113 | - $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
113 | + $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
114 | 114 | selected_value="'.addslashes($_POST['port']).'" |
115 | 115 | WHERE variable="service_ppt2lp" |
116 | 116 | AND subkey="port"'; |
117 | - Database::query($sql); |
|
117 | + Database::query($sql); |
|
118 | 118 | |
119 | - $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
119 | + $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
120 | 120 | selected_value="'.addslashes($_POST['ftp_password']).'" |
121 | 121 | WHERE variable="service_ppt2lp" |
122 | 122 | AND subkey="ftp_password"'; |
123 | - Database::query($sql); |
|
123 | + Database::query($sql); |
|
124 | 124 | |
125 | - $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
125 | + $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
126 | 126 | selected_value="'.addslashes($_POST['user']).'" |
127 | 127 | WHERE variable="service_ppt2lp" |
128 | 128 | AND subkey="user"'; |
129 | - Database::query($sql); |
|
129 | + Database::query($sql); |
|
130 | 130 | |
131 | - $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
131 | + $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
132 | 132 | selected_value="'.addslashes($_POST['path_to_lzx']).'" |
133 | 133 | WHERE variable="service_ppt2lp" |
134 | 134 | AND subkey="path_to_lzx"'; |
135 | - Database::query($sql); |
|
135 | + Database::query($sql); |
|
136 | 136 | |
137 | - $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
137 | + $sql = 'UPDATE '.$tbl_settings_current.' SET |
|
138 | 138 | selected_value="'.addslashes($_POST['size']).'" |
139 | 139 | WHERE variable="service_ppt2lp" |
140 | 140 | AND subkey="size"'; |
141 | - Database::query($sql); |
|
141 | + Database::query($sql); |
|
142 | 142 | |
143 | - break; |
|
144 | - } |
|
143 | + break; |
|
144 | + } |
|
145 | 145 | |
146 | 146 | } |
147 | 147 | |
@@ -154,14 +154,14 @@ discard block |
||
154 | 154 | |
155 | 155 | $rs = Database::query($sql); |
156 | 156 | while($row = Database::fetch_array($rs)){ |
157 | - $listActiveServices[] = $row['variable']; |
|
157 | + $listActiveServices[] = $row['variable']; |
|
158 | 158 | } |
159 | 159 | |
160 | 160 | // javascript to handle accordion behaviour |
161 | 161 | $javascript_message = ''; |
162 | 162 | if(!empty($message)){ |
163 | - $javascript_message = |
|
164 | - ' |
|
163 | + $javascript_message = |
|
164 | + ' |
|
165 | 165 | document.getElementById("message").style.display = "block"; |
166 | 166 | var timer = setTimeout(hideMessage,5000); |
167 | 167 | '; |
@@ -215,9 +215,9 @@ discard block |
||
215 | 215 | ?> |
216 | 216 | <div id="message" style="display: none"> |
217 | 217 | <?php |
218 | - if(!empty($message)) |
|
219 | - Display::display_normal_message($message) |
|
220 | - ?> |
|
218 | + if(!empty($message)) |
|
219 | + Display::display_normal_message($message) |
|
220 | + ?> |
|
221 | 221 | </div> |
222 | 222 | |
223 | 223 | <div id="content" align="center"> |
@@ -303,63 +303,63 @@ discard block |
||
303 | 303 | <form method="POST" class="form-horizontal" action="<?php echo api_get_self(); ?>"> |
304 | 304 | <?php |
305 | 305 | |
306 | - $form = new FormValidator('ppt2lp'); |
|
307 | - $form -> addElement('text', 'host', get_lang('Host')); |
|
308 | - //$form -> addElement('html','<br /><br />'); |
|
309 | - $form -> addElement('text', 'port', get_lang('Port')); |
|
310 | - //$form -> addElement('html','<br /><br />'); |
|
311 | - $form -> addElement('text', 'user', get_lang('UserOnHost')); |
|
312 | - //$form -> addElement('html','<br /><br />'); |
|
313 | - $form -> addElement('text', 'ftp_password', get_lang('FtpPassword')); |
|
314 | - //$form -> addElement('html','<br /><br />'); |
|
315 | - $form -> addElement('text', 'path_to_lzx', get_lang('PathToLzx')); |
|
316 | - //$form -> addElement('html','<br /><br />'); |
|
317 | - $options = array( |
|
318 | - '540x405'=>'540x405', |
|
319 | - '640x480'=>'640x480', |
|
320 | - '720x540'=>'720x540', |
|
321 | - '800x600'=>'800x600', |
|
322 | - '1000x750'=>'1000x750' |
|
323 | - ); |
|
324 | - $form -> addElement('select', 'size', get_lang('SlideSize'), $options); |
|
325 | - |
|
326 | - |
|
327 | - $form -> addElement('hidden', 'extension_code', 'ppt2lp'); |
|
328 | - |
|
329 | - $defaults = array(); |
|
330 | - $renderer = $form -> defaultRenderer(); |
|
331 | - $renderer -> setElementTemplate('<div style="text-align:left">{label}</div><div style="text-align:left">{element}</div>'); |
|
332 | - //$form -> addElement('html','<br /><br />'); |
|
333 | - if(in_array('service_ppt2lp',$listActiveServices)) |
|
334 | - { |
|
335 | - $sql = 'SELECT subkey, selected_value FROM '.$tbl_settings_current.' |
|
306 | + $form = new FormValidator('ppt2lp'); |
|
307 | + $form -> addElement('text', 'host', get_lang('Host')); |
|
308 | + //$form -> addElement('html','<br /><br />'); |
|
309 | + $form -> addElement('text', 'port', get_lang('Port')); |
|
310 | + //$form -> addElement('html','<br /><br />'); |
|
311 | + $form -> addElement('text', 'user', get_lang('UserOnHost')); |
|
312 | + //$form -> addElement('html','<br /><br />'); |
|
313 | + $form -> addElement('text', 'ftp_password', get_lang('FtpPassword')); |
|
314 | + //$form -> addElement('html','<br /><br />'); |
|
315 | + $form -> addElement('text', 'path_to_lzx', get_lang('PathToLzx')); |
|
316 | + //$form -> addElement('html','<br /><br />'); |
|
317 | + $options = array( |
|
318 | + '540x405'=>'540x405', |
|
319 | + '640x480'=>'640x480', |
|
320 | + '720x540'=>'720x540', |
|
321 | + '800x600'=>'800x600', |
|
322 | + '1000x750'=>'1000x750' |
|
323 | + ); |
|
324 | + $form -> addElement('select', 'size', get_lang('SlideSize'), $options); |
|
325 | + |
|
326 | + |
|
327 | + $form -> addElement('hidden', 'extension_code', 'ppt2lp'); |
|
328 | + |
|
329 | + $defaults = array(); |
|
330 | + $renderer = $form -> defaultRenderer(); |
|
331 | + $renderer -> setElementTemplate('<div style="text-align:left">{label}</div><div style="text-align:left">{element}</div>'); |
|
332 | + //$form -> addElement('html','<br /><br />'); |
|
333 | + if(in_array('service_ppt2lp',$listActiveServices)) |
|
334 | + { |
|
335 | + $sql = 'SELECT subkey, selected_value FROM '.$tbl_settings_current.' |
|
336 | 336 | WHERE variable = "service_ppt2lp" |
337 | 337 | AND subkey <> "active"'; |
338 | - $rs = Database::query($sql); |
|
339 | - while($row = Database::fetch_array($rs,'ASSOC')) |
|
340 | - { |
|
341 | - $defaults[$row['subkey']] = $row['selected_value']; |
|
342 | - } |
|
343 | - $form->addButtonSave(get_lang('ReconfigureExtension'), 'activeExtension'); |
|
344 | - } |
|
345 | - else { |
|
346 | - $defaults['host'] = 'localhost'; |
|
347 | - $defaults['port'] = '2002'; |
|
348 | - $defaults['size'] = '720x540'; |
|
349 | - $form->addButtonSave(get_lang('ActivateExtension'), 'activeExtension'); |
|
350 | - } |
|
351 | - |
|
352 | - $form -> setDefaults($defaults); |
|
353 | - $form -> display(); |
|
354 | - echo '<br />'; |
|
355 | - ?> |
|
338 | + $rs = Database::query($sql); |
|
339 | + while($row = Database::fetch_array($rs,'ASSOC')) |
|
340 | + { |
|
341 | + $defaults[$row['subkey']] = $row['selected_value']; |
|
342 | + } |
|
343 | + $form->addButtonSave(get_lang('ReconfigureExtension'), 'activeExtension'); |
|
344 | + } |
|
345 | + else { |
|
346 | + $defaults['host'] = 'localhost'; |
|
347 | + $defaults['port'] = '2002'; |
|
348 | + $defaults['size'] = '720x540'; |
|
349 | + $form->addButtonSave(get_lang('ActivateExtension'), 'activeExtension'); |
|
350 | + } |
|
351 | + |
|
352 | + $form -> setDefaults($defaults); |
|
353 | + $form -> display(); |
|
354 | + echo '<br />'; |
|
355 | + ?> |
|
356 | 356 | </form> |
357 | 357 | </div> |
358 | 358 | </div> |
359 | 359 | </div> |
360 | 360 | |
361 | 361 | <?php |
362 | - /* |
|
362 | + /* |
|
363 | 363 | <!-- EPHORUS --> |
364 | 364 | <div id="main_ephorus"> |
365 | 365 | <div id="extension_header_ephorus" class="accordion_header"> |
@@ -18,9 +18,9 @@ |
||
18 | 18 | $classcodes = array (); |
19 | 19 | |
20 | 20 | if (!isset($_POST['subscribe']) && !isset($_POST['subscribe'])) { |
21 | - $user_class['error'] = get_lang('SelectAnAction'); |
|
22 | - $errors[] = $user_class; |
|
23 | - return $errors; |
|
21 | + $user_class['error'] = get_lang('SelectAnAction'); |
|
22 | + $errors[] = $user_class; |
|
23 | + return $errors; |
|
24 | 24 | } |
25 | 25 | foreach ($user_classes as $index => $user_class) { |
26 | 26 | $user_class['line'] = $index + 1; |
@@ -28,8 +28,8 @@ discard block |
||
28 | 28 | require_once '../coursecopy/classes/CourseSelectForm.class.php'; |
29 | 29 | |
30 | 30 | if (function_exists('ini_set')) { |
31 | - api_set_memory_limit('256M'); |
|
32 | - ini_set('max_execution_time',0); |
|
31 | + api_set_memory_limit('256M'); |
|
32 | + ini_set('max_execution_time',0); |
|
33 | 33 | } |
34 | 34 | |
35 | 35 | // Displaying the header |
@@ -50,36 +50,36 @@ discard block |
||
50 | 50 | if ((isset($_POST['action']) && $_POST['action'] == 'course_select_form') || |
51 | 51 | (isset ($_POST['backup_option']) && $_POST['backup_option'] == 'full_backup') |
52 | 52 | ) { |
53 | - $export = false; |
|
54 | - if (isset ($_POST['action']) && $_POST['action'] == 'course_select_form') { |
|
55 | - $FileZip = create_zip(); |
|
56 | - $to_group_id = 0; |
|
57 | - $sql_session = "SELECT id, name FROM $tbl_session "; |
|
58 | - $query_session = Database::query($sql_session); |
|
59 | - $ListSession = array(); |
|
60 | - while ($rows_session = Database::fetch_assoc($query_session)) { |
|
61 | - $ListSession[$rows_session['id']] = $rows_session['name']; |
|
62 | - } |
|
53 | + $export = false; |
|
54 | + if (isset ($_POST['action']) && $_POST['action'] == 'course_select_form') { |
|
55 | + $FileZip = create_zip(); |
|
56 | + $to_group_id = 0; |
|
57 | + $sql_session = "SELECT id, name FROM $tbl_session "; |
|
58 | + $query_session = Database::query($sql_session); |
|
59 | + $ListSession = array(); |
|
60 | + while ($rows_session = Database::fetch_assoc($query_session)) { |
|
61 | + $ListSession[$rows_session['id']] = $rows_session['name']; |
|
62 | + } |
|
63 | 63 | |
64 | 64 | $groupCondition = " props.to_group_id = $to_group_id"; |
65 | 65 | if (empty($to_group_id)) { |
66 | 66 | $groupCondition = " (props.to_group_id = 0 OR props.to_group_id IS NULL)"; |
67 | 67 | } |
68 | 68 | |
69 | - $zip_folder=new PclZip($FileZip['TEMP_FILE_ZIP']); |
|
70 | - if(!isset($_POST['resource']) || count($_POST['resource']) == 0 ) { |
|
71 | - Display::display_error_message(get_lang('ErrorMsgSpecialExport')); |
|
72 | - } else { |
|
73 | - $Resource = $_POST['resource']; |
|
69 | + $zip_folder=new PclZip($FileZip['TEMP_FILE_ZIP']); |
|
70 | + if(!isset($_POST['resource']) || count($_POST['resource']) == 0 ) { |
|
71 | + Display::display_error_message(get_lang('ErrorMsgSpecialExport')); |
|
72 | + } else { |
|
73 | + $Resource = $_POST['resource']; |
|
74 | 74 | |
75 | - foreach ($Resource as $Code_course => $Sessions) { |
|
76 | - $_course = api_get_course_info($Code_course); |
|
77 | - $tbl_document = Database::get_course_table(TABLE_DOCUMENT); |
|
78 | - $tbl_property = Database::get_course_table(TABLE_ITEM_PROPERTY); |
|
79 | - $course_id = $_course['real_id']; |
|
75 | + foreach ($Resource as $Code_course => $Sessions) { |
|
76 | + $_course = api_get_course_info($Code_course); |
|
77 | + $tbl_document = Database::get_course_table(TABLE_DOCUMENT); |
|
78 | + $tbl_property = Database::get_course_table(TABLE_ITEM_PROPERTY); |
|
79 | + $course_id = $_course['real_id']; |
|
80 | 80 | |
81 | - //Add item to the zip file course |
|
82 | - $sql = "SELECT path FROM $tbl_document AS docs, $tbl_property AS props |
|
81 | + //Add item to the zip file course |
|
82 | + $sql = "SELECT path FROM $tbl_document AS docs, $tbl_property AS props |
|
83 | 83 | WHERE props.tool='".TOOL_DOCUMENT."' |
84 | 84 | AND docs.id=props.ref |
85 | 85 | AND docs.path LIKE '".$querypath."/%' |
@@ -89,8 +89,8 @@ discard block |
||
89 | 89 | AND $groupCondition |
90 | 90 | AND docs.c_id = $course_id |
91 | 91 | AND props.c_id = $course_id"; |
92 | - $query = Database::query($sql ); |
|
93 | - while ($rows_course_file = Database::fetch_assoc($query)) { |
|
92 | + $query = Database::query($sql ); |
|
93 | + while ($rows_course_file = Database::fetch_assoc($query)) { |
|
94 | 94 | $zip_folder->add( |
95 | 95 | $FileZip['PATH_COURSE'].$_course['directory']."/document".$rows_course_file['path'], |
96 | 96 | PCLZIP_OPT_ADD_PATH, |
@@ -98,12 +98,12 @@ discard block |
||
98 | 98 | PCLZIP_OPT_REMOVE_PATH, |
99 | 99 | $FileZip['PATH_COURSE'].$_course['directory']."/document".$FileZip['PATH_REMOVE'] |
100 | 100 | ); |
101 | - } |
|
101 | + } |
|
102 | 102 | |
103 | - foreach ($Sessions as $IdSession => $value){ |
|
104 | - $session_id = Security::remove_XSS($IdSession); |
|
105 | - //Add tem to the zip file session course |
|
106 | - $sql_session_doc = "SELECT path FROM $tbl_document AS docs, $tbl_property AS props |
|
103 | + foreach ($Sessions as $IdSession => $value){ |
|
104 | + $session_id = Security::remove_XSS($IdSession); |
|
105 | + //Add tem to the zip file session course |
|
106 | + $sql_session_doc = "SELECT path FROM $tbl_document AS docs, $tbl_property AS props |
|
107 | 107 | WHERE props.tool='".TOOL_DOCUMENT."' |
108 | 108 | AND docs.id=props.ref |
109 | 109 | AND docs.path LIKE '".$querypath."/%' |
@@ -113,8 +113,8 @@ discard block |
||
113 | 113 | AND $groupCondition |
114 | 114 | AND docs.c_id = $course_id |
115 | 115 | AND props.c_id = $course_id"; |
116 | - $query_session_doc = Database::query($sql_session_doc); |
|
117 | - while ($rows_course_session_file = Database::fetch_assoc($query_session_doc)) { |
|
116 | + $query_session_doc = Database::query($sql_session_doc); |
|
117 | + while ($rows_course_session_file = Database::fetch_assoc($query_session_doc)) { |
|
118 | 118 | $zip_folder->add( |
119 | 119 | $FileZip['PATH_COURSE'].$_course['directory'].'/document'.$rows_course_session_file['path'], |
120 | 120 | PCLZIP_OPT_ADD_PATH, |
@@ -122,15 +122,15 @@ discard block |
||
122 | 122 | PCLZIP_OPT_REMOVE_PATH, |
123 | 123 | $FileZip['PATH_COURSE'].$_course['directory'].'/document'.$FileZip['PATH_REMOVE'] |
124 | 124 | ); |
125 | - } |
|
126 | - } |
|
127 | - } |
|
128 | - $name = rename_zip($FileZip); |
|
129 | - $export = true; |
|
130 | - } |
|
131 | - } else { |
|
132 | - $name = fullexportspecial(); |
|
133 | - } |
|
125 | + } |
|
126 | + } |
|
127 | + } |
|
128 | + $name = rename_zip($FileZip); |
|
129 | + $export = true; |
|
130 | + } |
|
131 | + } else { |
|
132 | + $name = fullexportspecial(); |
|
133 | + } |
|
134 | 134 | ?> |
135 | 135 | <!-- Manual download <script language="JavaScript"> |
136 | 136 | // setTimeout(\'download_backup()\',2000); |
@@ -143,23 +143,23 @@ discard block |
||
143 | 143 | } |
144 | 144 | |
145 | 145 | if ($export && $name) { |
146 | - Display::display_confirmation_message(get_lang('BackupCreated')); |
|
147 | - echo '<br /><a class="btn btn-default" href="'.api_get_path(WEB_CODE_PATH).'course_info/download.php?archive='.urlencode($name).'&session=true">'.get_lang('Download').'</a>'; |
|
146 | + Display::display_confirmation_message(get_lang('BackupCreated')); |
|
147 | + echo '<br /><a class="btn btn-default" href="'.api_get_path(WEB_CODE_PATH).'course_info/download.php?archive='.urlencode($name).'&session=true">'.get_lang('Download').'</a>'; |
|
148 | 148 | } else { |
149 | - // Display forms especial export |
|
150 | - if (isset ($_POST['backup_option']) && $_POST['backup_option'] == 'select_items') { |
|
151 | - $cb = new CourseBuilder(); |
|
152 | - $course = $cb->build_session_course(); |
|
153 | - if($course === false){ |
|
154 | - Display::display_error_message(get_lang('ErrorMsgSpecialExport')); |
|
155 | - form_special_export(); |
|
156 | - } else { |
|
157 | - Display::display_normal_message(get_lang('ToExportSpecialSelect')); |
|
158 | - CourseSelectForm :: display_form_session_export($course); |
|
159 | - } |
|
160 | - } else { |
|
161 | - form_special_export(); |
|
162 | - } |
|
149 | + // Display forms especial export |
|
150 | + if (isset ($_POST['backup_option']) && $_POST['backup_option'] == 'select_items') { |
|
151 | + $cb = new CourseBuilder(); |
|
152 | + $course = $cb->build_session_course(); |
|
153 | + if($course === false){ |
|
154 | + Display::display_error_message(get_lang('ErrorMsgSpecialExport')); |
|
155 | + form_special_export(); |
|
156 | + } else { |
|
157 | + Display::display_normal_message(get_lang('ToExportSpecialSelect')); |
|
158 | + CourseSelectForm :: display_form_session_export($course); |
|
159 | + } |
|
160 | + } else { |
|
161 | + form_special_export(); |
|
162 | + } |
|
163 | 163 | } |
164 | 164 | |
165 | 165 | /* FOOTER */ |
@@ -200,10 +200,10 @@ discard block |
||
200 | 200 | } |
201 | 201 | $temp_zip_file = $temp_zip_dir."/".md5(time()).".zip"; //create zipfile of given directory |
202 | 202 | return array('PATH' => $path, |
203 | - 'PATH_TEMP_ARCHIVE' => $temp_zip_dir, |
|
204 | - 'PATH_COURSE' => $sys_course_path, |
|
205 | - 'TEMP_FILE_ZIP' => $temp_zip_file, |
|
206 | - 'PATH_REMOVE' => $remove_dir); |
|
203 | + 'PATH_TEMP_ARCHIVE' => $temp_zip_dir, |
|
204 | + 'PATH_COURSE' => $sys_course_path, |
|
205 | + 'TEMP_FILE_ZIP' => $temp_zip_file, |
|
206 | + 'PATH_REMOVE' => $remove_dir); |
|
207 | 207 | } |
208 | 208 | |
209 | 209 | function rename_zip($FileZip) { |
@@ -287,9 +287,9 @@ discard block |
||
287 | 287 | $query_session_doc = Database::query($sql_session_doc); |
288 | 288 | while ($rows_course_session_file = Database::fetch_assoc($query_session_doc)) { |
289 | 289 | $zip_folder->add($FileZip['PATH_COURSE'].$_course['directory'].'/document'.$rows_course_session_file['path'], |
290 | - PCLZIP_OPT_ADD_PATH, $_course['directory']."/".$rows_session['name'], |
|
291 | - PCLZIP_OPT_REMOVE_PATH, $FileZip['PATH_COURSE'].$_course['directory'].'/document'.$FileZip['PATH_REMOVE'] |
|
292 | - ); |
|
290 | + PCLZIP_OPT_ADD_PATH, $_course['directory']."/".$rows_session['name'], |
|
291 | + PCLZIP_OPT_REMOVE_PATH, $FileZip['PATH_COURSE'].$_course['directory'].'/document'.$FileZip['PATH_REMOVE'] |
|
292 | + ); |
|
293 | 293 | } |
294 | 294 | } |
295 | 295 | } |
@@ -37,12 +37,12 @@ discard block |
||
37 | 37 | |
38 | 38 | // Tool name |
39 | 39 | if (isset($_GET['action']) && $_GET['action'] == 'addnote') { |
40 | - $tool = 'NoteAddNew'; |
|
41 | - $interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('ToolNotebook')); |
|
40 | + $tool = 'NoteAddNew'; |
|
41 | + $interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('ToolNotebook')); |
|
42 | 42 | } |
43 | 43 | if (isset($_GET['action']) && $_GET['action'] == 'editnote') { |
44 | - $tool = 'ModifyNote'; |
|
45 | - $interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('ToolNotebook')); |
|
44 | + $tool = 'ModifyNote'; |
|
45 | + $interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('ToolNotebook')); |
|
46 | 46 | } |
47 | 47 | |
48 | 48 | // Displaying the header |
@@ -53,16 +53,16 @@ discard block |
||
53 | 53 | |
54 | 54 | // Action handling: Adding a note |
55 | 55 | if (isset($_GET['action']) && $_GET['action'] == 'addnote') { |
56 | - if (api_get_session_id() != 0 && !api_is_allowed_to_session_edit(false, true)) { |
|
57 | - api_not_allowed(); |
|
58 | - } |
|
56 | + if (api_get_session_id() != 0 && !api_is_allowed_to_session_edit(false, true)) { |
|
57 | + api_not_allowed(); |
|
58 | + } |
|
59 | 59 | |
60 | - if (!empty($_GET['isStudentView'])) { |
|
61 | - NotebookManager::display_notes(); |
|
62 | - exit; |
|
63 | - } |
|
60 | + if (!empty($_GET['isStudentView'])) { |
|
61 | + NotebookManager::display_notes(); |
|
62 | + exit; |
|
63 | + } |
|
64 | 64 | |
65 | - $_SESSION['notebook_view'] = 'creation_date'; |
|
65 | + $_SESSION['notebook_view'] = 'creation_date'; |
|
66 | 66 | |
67 | 67 | $form = new FormValidator( |
68 | 68 | 'note', |