@@ -18,30 +18,30 @@ discard block |
||
18 | 18 | if (api_is_student() && !api_get_setting('student_page_after_login') == '') { |
19 | 19 | $redirect_url = html_entity_decode(api_get_setting('student_page_after_login')); |
20 | 20 | if ($redirect_url[0] == "/") { |
21 | - $redirect_url = substr(api_get_path(WEB_PATH), 0, -1) . $redirect_url; |
|
21 | + $redirect_url = substr(api_get_path(WEB_PATH), 0, -1).$redirect_url; |
|
22 | 22 | } |
23 | 23 | } |
24 | 24 | if (api_is_teacher() && !api_get_setting('teacher_page_after_login') == '') { |
25 | 25 | $redirect_url = html_entity_decode(api_get_setting('teacher_page_after_login')); |
26 | 26 | if ($redirect_url[0] == "/") { |
27 | - $redirect_url = substr(api_get_path(WEB_PATH), 0, -1) . $redirect_url; |
|
27 | + $redirect_url = substr(api_get_path(WEB_PATH), 0, -1).$redirect_url; |
|
28 | 28 | } |
29 | 29 | } |
30 | 30 | if (api_is_drh() && !api_get_setting('drh_page_after_login') == '') { |
31 | 31 | $redirect_url = html_entity_decode(api_get_setting('drh_page_after_login')); |
32 | 32 | if ($redirect_url[0] == "/") { |
33 | - $redirect_url = substr(api_get_path(WEB_PATH), 0, -1) . $redirect_url; |
|
33 | + $redirect_url = substr(api_get_path(WEB_PATH), 0, -1).$redirect_url; |
|
34 | 34 | } |
35 | 35 | } |
36 | 36 | if (api_is_session_admin() && !api_get_setting('sessionadmin_page_after_login') == '') { |
37 | 37 | $redirect_url = html_entity_decode(api_get_setting('sessionadmin_page_after_login')); |
38 | 38 | if ($redirect_url[0] == "/") { |
39 | - $redirect_url = substr(api_get_path(WEB_PATH), 0, -1) . $redirect_url; |
|
39 | + $redirect_url = substr(api_get_path(WEB_PATH), 0, -1).$redirect_url; |
|
40 | 40 | } |
41 | 41 | } |
42 | 42 | |
43 | 43 | if (!empty($redirect_url)) { |
44 | - header('Location: ' . $redirect_url . $param); |
|
44 | + header('Location: '.$redirect_url.$param); |
|
45 | 45 | exit(); |
46 | 46 | } |
47 | 47 | |
@@ -49,7 +49,7 @@ discard block |
||
49 | 49 | if (CustomPages::enabled()) { |
50 | 50 | CustomPages::display(CustomPages::INDEX_LOGGED); |
51 | 51 | } |
52 | - header('location: ' . api_get_path(WEB_PATH) . api_get_setting('page_after_login') . $param); |
|
52 | + header('location: '.api_get_path(WEB_PATH).api_get_setting('page_after_login').$param); |
|
53 | 53 | exit(); |
54 | 54 | } |
55 | 55 | } |
@@ -6022,7 +6022,7 @@ |
||
6022 | 6022 | ]); |
6023 | 6023 | } |
6024 | 6024 | |
6025 | - /** |
|
6025 | + /** |
|
6026 | 6026 | * Get the count of user courses in session |
6027 | 6027 | * @param int $sessionId The session id |
6028 | 6028 | * @return array |
@@ -2896,10 +2896,11 @@ |
||
2896 | 2896 | c_id = $courseId AND |
2897 | 2897 | user_id = $user_id "; |
2898 | 2898 | $result = Database::query($sql); |
2899 | - if (Database::affected_rows($result) > 0) |
|
2900 | - return true; |
|
2901 | - else |
|
2902 | - return false; |
|
2899 | + if (Database::affected_rows($result) > 0) { |
|
2900 | + return true; |
|
2901 | + } else { |
|
2902 | + return false; |
|
2903 | + } |
|
2903 | 2904 | } else { |
2904 | 2905 | // The user is not subscribed to the session, so make sure |
2905 | 2906 | // he isn't subscribed to a course in this session either |
@@ -1532,7 +1532,7 @@ discard block |
||
1532 | 1532 | * @param array $id_checked an array to delete sessions |
1533 | 1533 | * @param boolean $from_ws optional, true if the function is called |
1534 | 1534 | * by a webservice, false otherwise. |
1535 | - * @return void Nothing, or false on error |
|
1535 | + * @return boolean Nothing, or false on error |
|
1536 | 1536 | * */ |
1537 | 1537 | public static function delete($id_checked, $from_ws = false) |
1538 | 1538 | { |
@@ -1669,7 +1669,7 @@ discard block |
||
1669 | 1669 | * @param array $user_list |
1670 | 1670 | * @param int $session_visibility |
1671 | 1671 | * @param bool $empty_users |
1672 | - * @return bool |
|
1672 | + * @return false|null |
|
1673 | 1673 | */ |
1674 | 1674 | public static function subscribe_users_to_session( |
1675 | 1675 | $id_session, |
@@ -1942,7 +1942,7 @@ discard block |
||
1942 | 1942 | * @param array $courseInfo |
1943 | 1943 | * @param int $status |
1944 | 1944 | * @param bool $updateTotal |
1945 | - * @return bool |
|
1945 | + * @return false|null |
|
1946 | 1946 | */ |
1947 | 1947 | public static function removeUsersFromCourseSession( |
1948 | 1948 | $userList, |
@@ -2008,7 +2008,7 @@ discard block |
||
2008 | 2008 | * @param string $course_code |
2009 | 2009 | * @param int $session_visibility |
2010 | 2010 | * @param bool $removeUsersNotInList |
2011 | - * @return bool |
|
2011 | + * @return false|null |
|
2012 | 2012 | */ |
2013 | 2013 | public static function subscribe_users_to_session_course( |
2014 | 2014 | $user_list, |
@@ -2192,7 +2192,7 @@ discard block |
||
2192 | 2192 | * @param bool $removeExistingCoursesWithUsers Whether to unsubscribe |
2193 | 2193 | * existing courses and users (true, default) or not (false) |
2194 | 2194 | * @param $copyEvaluation from base course to session course |
2195 | - * @return void Nothing, or false on error |
|
2195 | + * @return false|null Nothing, or false on error |
|
2196 | 2196 | * */ |
2197 | 2197 | public static function add_courses_to_session( |
2198 | 2198 | $sessionId, |
@@ -2441,7 +2441,7 @@ discard block |
||
2441 | 2441 | * @param string $variable Field's internal variable name |
2442 | 2442 | * @param int $fieldType Field's type |
2443 | 2443 | * @param string $displayText Field's language var name |
2444 | - * @return int new extra field id |
|
2444 | + * @return boolean new extra field id |
|
2445 | 2445 | */ |
2446 | 2446 | public static function create_session_extra_field($variable, $fieldType, $displayText) |
2447 | 2447 | { |
@@ -2670,7 +2670,7 @@ discard block |
||
2670 | 2670 | * @param array id_checked |
2671 | 2671 | * @param bool include delete session |
2672 | 2672 | * @param bool optional, true if the function is called by a webservice, false otherwise. |
2673 | - * @return void Nothing, or false on error |
|
2673 | + * @return boolean Nothing, or false on error |
|
2674 | 2674 | * The parameters is a array to delete sessions |
2675 | 2675 | * */ |
2676 | 2676 | public static function delete_session_category($id_checked, $delete_session = false, $from_ws = false) |
@@ -3436,8 +3436,8 @@ discard block |
||
3436 | 3436 | /** |
3437 | 3437 | * Gets the list of courses by session filtered by access_url |
3438 | 3438 | * |
3439 | - * @param $userId |
|
3440 | - * @param $sessionId |
|
3439 | + * @param integer $userId |
|
3440 | + * @param null|integer $sessionId |
|
3441 | 3441 | * @param null $from |
3442 | 3442 | * @param null $limit |
3443 | 3443 | * @param null $column |
@@ -3562,6 +3562,7 @@ discard block |
||
3562 | 3562 | /** |
3563 | 3563 | * Gets the count of courses by session filtered by access_url |
3564 | 3564 | * @param int session id |
3565 | + * @param integer $session_id |
|
3565 | 3566 | * @return array list of courses |
3566 | 3567 | */ |
3567 | 3568 | public static function getCourseCountBySessionId($session_id, $keyword = null) |
@@ -3820,6 +3821,7 @@ discard block |
||
3820 | 3821 | * Updates a session status |
3821 | 3822 | * @param int session id |
3822 | 3823 | * @param int status |
3824 | + * @param integer $status |
|
3823 | 3825 | */ |
3824 | 3826 | public static function set_session_status($session_id, $status) |
3825 | 3827 | { |
@@ -4028,7 +4030,7 @@ discard block |
||
4028 | 4030 | * Protect a session to be edited. |
4029 | 4031 | * @param int $id |
4030 | 4032 | * @param bool $checkSession |
4031 | - * @return mixed | bool true if pass the check, api_not_allowed otherwise |
|
4033 | + * @return boolean|null | bool true if pass the check, api_not_allowed otherwise |
|
4032 | 4034 | */ |
4033 | 4035 | public static function protectSession($id, $checkSession = true) |
4034 | 4036 | { |
@@ -4136,7 +4138,7 @@ discard block |
||
4136 | 4138 | |
4137 | 4139 | /** |
4138 | 4140 | * @param $id |
4139 | - * @return bool |
|
4141 | + * @return null|boolean |
|
4140 | 4142 | */ |
4141 | 4143 | public static function protect_teacher_session_edit($id) |
4142 | 4144 | { |
@@ -4201,7 +4203,7 @@ discard block |
||
4201 | 4203 | * true: if the session exists it will be updated. |
4202 | 4204 | * false: if session exists a new session will be created adding a counter session1, session2, etc |
4203 | 4205 | * @param int $defaultUserId |
4204 | - * @param mixed $logger |
|
4206 | + * @param Logger $logger |
|
4205 | 4207 | * @param array $extraFields convert a file row to an extra field. Example in CSV file there's a SessionID then it will |
4206 | 4208 | * converted to extra_external_session_id if you set this: array('SessionId' => 'extra_external_session_id') |
4207 | 4209 | * @param string $extraFieldId |
@@ -5504,7 +5506,6 @@ discard block |
||
5504 | 5506 | * @param string $lastConnectionDate |
5505 | 5507 | * @param array $sessionIdList |
5506 | 5508 | * @param array $studentIdList |
5507 | - * @param int $userStatus STUDENT|COURSEMANAGER constants |
|
5508 | 5509 | * |
5509 | 5510 | * @return array|int |
5510 | 5511 | */ |
@@ -5656,7 +5657,7 @@ discard block |
||
5656 | 5657 | /** |
5657 | 5658 | * Get the list of course tools that have to be dealt with in case of |
5658 | 5659 | * registering any course to a session |
5659 | - * @return array The list of tools to be dealt with (literal names) |
|
5660 | + * @return string[] The list of tools to be dealt with (literal names) |
|
5660 | 5661 | */ |
5661 | 5662 | public static function getCourseToolToBeManaged() |
5662 | 5663 | { |
@@ -5670,7 +5671,7 @@ discard block |
||
5670 | 5671 | * Calls the methods bound to each tool when a course is registered into a session |
5671 | 5672 | * @param int $sessionId |
5672 | 5673 | * @param int $courseId |
5673 | - * @return void |
|
5674 | + * @return boolean|null |
|
5674 | 5675 | */ |
5675 | 5676 | public static function installCourse($sessionId, $courseId) |
5676 | 5677 | { |
@@ -6320,6 +6321,7 @@ discard block |
||
6320 | 6321 | * @param int $categoryId The internal ID of the session category |
6321 | 6322 | * @param string $target Value to search for in the session field values |
6322 | 6323 | * @param array $extraFields A list of fields to be scanned and returned |
6324 | + * @param DateTime $publicationDate |
|
6323 | 6325 | * @return mixed |
6324 | 6326 | */ |
6325 | 6327 | public static function getShortSessionListAndExtraByCategory( |
@@ -7656,7 +7658,7 @@ discard block |
||
7656 | 7658 | /** |
7657 | 7659 | * Get link to the admin page for this session |
7658 | 7660 | * @param int $id Session ID |
7659 | - * @return mixed URL to the admin page to manage the session, or false on error |
|
7661 | + * @return false|string URL to the admin page to manage the session, or false on error |
|
7660 | 7662 | */ |
7661 | 7663 | public static function getAdminPath($id) |
7662 | 7664 | { |
@@ -7673,7 +7675,7 @@ discard block |
||
7673 | 7675 | * If a course is provided, build the link to the course |
7674 | 7676 | * @param int $id Session ID |
7675 | 7677 | * @param int $courseId Course ID (optional) in case the link has to send straight to the course |
7676 | - * @return mixed URL to the page to use the session, or false on error |
|
7678 | + * @return false|string URL to the page to use the session, or false on error |
|
7677 | 7679 | */ |
7678 | 7680 | public static function getPath($id, $courseId = 0) |
7679 | 7681 | { |
@@ -177,7 +177,7 @@ discard block |
||
177 | 177 | return $msg; |
178 | 178 | } |
179 | 179 | } else { |
180 | - $rs = Database::query("SELECT 1 FROM $tbl_session WHERE name='" . $name . "'"); |
|
180 | + $rs = Database::query("SELECT 1 FROM $tbl_session WHERE name='".$name."'"); |
|
181 | 181 | if (Database::num_rows($rs)) { |
182 | 182 | $msg = get_lang('SessionNameAlreadyExists'); |
183 | 183 | return $msg; |
@@ -290,7 +290,7 @@ discard block |
||
290 | 290 | public static function session_name_exists($name) |
291 | 291 | { |
292 | 292 | $name = Database::escape_string($name); |
293 | - $sql = "SELECT COUNT(*) as count FROM " . Database::get_main_table(TABLE_MAIN_SESSION) . " |
|
293 | + $sql = "SELECT COUNT(*) as count FROM ".Database::get_main_table(TABLE_MAIN_SESSION)." |
|
294 | 294 | WHERE name = '$name'"; |
295 | 295 | $result = Database::fetch_array(Database::query($sql)); |
296 | 296 | |
@@ -321,7 +321,7 @@ discard block |
||
321 | 321 | $where .= " AND ( |
322 | 322 | s.session_admin_id = $user_id OR |
323 | 323 | sru.user_id = '$user_id' AND |
324 | - sru.relation_type = '" . SESSION_RELATION_TYPE_RRHH . "' |
|
324 | + sru.relation_type = '".SESSION_RELATION_TYPE_RRHH."' |
|
325 | 325 | ) |
326 | 326 | "; |
327 | 327 | |
@@ -339,7 +339,7 @@ discard block |
||
339 | 339 | $where_condition = str_replace('category_name', 'sc.name', $where_condition); |
340 | 340 | $where_condition = str_replace( |
341 | 341 | array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
342 | - array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
|
342 | + array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 ") |
|
343 | 343 | , $where_condition |
344 | 344 | ); |
345 | 345 | $where_condition = str_replace( |
@@ -384,7 +384,7 @@ discard block |
||
384 | 384 | |
385 | 385 | $access_url_id = api_get_current_access_url_id(); |
386 | 386 | if ($access_url_id != -1) { |
387 | - $where.= " AND ar.access_url_id = $access_url_id "; |
|
387 | + $where .= " AND ar.access_url_id = $access_url_id "; |
|
388 | 388 | |
389 | 389 | $sql = "SELECT count(id) as total_rows FROM ( |
390 | 390 | SELECT DISTINCT |
@@ -434,14 +434,14 @@ discard block |
||
434 | 434 | if (api_is_session_admin() && |
435 | 435 | api_get_setting('allow_session_admins_to_manage_all_sessions') == 'false' |
436 | 436 | ) { |
437 | - $where .=" AND s.session_admin_id = $user_id "; |
|
437 | + $where .= " AND s.session_admin_id = $user_id "; |
|
438 | 438 | } |
439 | 439 | } |
440 | 440 | |
441 | 441 | if (!api_is_platform_admin() && api_is_teacher() && |
442 | 442 | api_get_setting('allow_teachers_to_create_sessions') == 'true' |
443 | 443 | ) { |
444 | - $where .=" AND s.id_coach = $user_id "; |
|
444 | + $where .= " AND s.id_coach = $user_id "; |
|
445 | 445 | } |
446 | 446 | |
447 | 447 | $extra_field = new ExtraFieldModel('session'); |
@@ -493,10 +493,10 @@ discard block |
||
493 | 493 | $query = "$select FROM $tbl_session s $inject_joins $where $inject_where"; |
494 | 494 | |
495 | 495 | if (api_is_multiple_url_enabled()) { |
496 | - $table_access_url_rel_session= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
496 | + $table_access_url_rel_session = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
497 | 497 | $access_url_id = api_get_current_access_url_id(); |
498 | 498 | if ($access_url_id != -1) { |
499 | - $where.= " AND ar.access_url_id = $access_url_id "; |
|
499 | + $where .= " AND ar.access_url_id = $access_url_id "; |
|
500 | 500 | $query = "$select |
501 | 501 | FROM $tbl_session s $inject_joins |
502 | 502 | INNER JOIN $table_access_url_rel_session ar |
@@ -599,7 +599,7 @@ discard block |
||
599 | 599 | INNER JOIN $tbl_lp l ON l.id = v.lp_id |
600 | 600 | INNER JOIN $tbl_user u ON u.user_id = v.user_id |
601 | 601 | INNER JOIN $tbl_course c |
602 | - WHERE v.session_id = " . $sessionId; |
|
602 | + WHERE v.session_id = ".$sessionId; |
|
603 | 603 | $result_rows = Database::query($sql); |
604 | 604 | $row = Database::fetch_array($result_rows); |
605 | 605 | $num = $row['total_rows']; |
@@ -651,7 +651,7 @@ discard block |
||
651 | 651 | |
652 | 652 | $limit = null; |
653 | 653 | if (!empty($options['limit'])) { |
654 | - $limit = " LIMIT " . $options['limit']; |
|
654 | + $limit = " LIMIT ".$options['limit']; |
|
655 | 655 | } |
656 | 656 | |
657 | 657 | if (!empty($options['where'])) { |
@@ -660,7 +660,7 @@ discard block |
||
660 | 660 | |
661 | 661 | $order = null; |
662 | 662 | if (!empty($options['order'])) { |
663 | - $order = " ORDER BY " . $options['order']; |
|
663 | + $order = " ORDER BY ".$options['order']; |
|
664 | 664 | } |
665 | 665 | |
666 | 666 | $sql = "SELECT u.user_id, u.lastname, u.firstname, u.username, u.email, s.c_id |
@@ -719,13 +719,13 @@ discard block |
||
719 | 719 | foreach ($lessons as $lesson) { |
720 | 720 | $data[$lesson['id']] = (!empty($user_lessons[$lesson['id']]['progress'])) ? $user_lessons[$lesson['id']]['progress'] : 0; |
721 | 721 | $progress += $data[$lesson['id']]; |
722 | - $data[$lesson['id']] = $data[$lesson['id']] . '%'; |
|
722 | + $data[$lesson['id']] = $data[$lesson['id']].'%'; |
|
723 | 723 | $count++; |
724 | 724 | } |
725 | 725 | if ($count == 0) { |
726 | 726 | $data['total'] = 0; |
727 | 727 | } else { |
728 | - $data['total'] = round($progress / $count, 2) . '%'; |
|
728 | + $data['total'] = round($progress / $count, 2).'%'; |
|
729 | 729 | } |
730 | 730 | $table[] = $data; |
731 | 731 | } |
@@ -766,7 +766,7 @@ discard block |
||
766 | 766 | |
767 | 767 | $limit = null; |
768 | 768 | if (!empty($options['limit'])) { |
769 | - $limit = " LIMIT " . $options['limit']; |
|
769 | + $limit = " LIMIT ".$options['limit']; |
|
770 | 770 | } |
771 | 771 | |
772 | 772 | if (!empty($options['where'])) { |
@@ -775,7 +775,7 @@ discard block |
||
775 | 775 | |
776 | 776 | $order = null; |
777 | 777 | if (!empty($options['order'])) { |
778 | - $order = " ORDER BY " . $options['order']; |
|
778 | + $order = " ORDER BY ".$options['order']; |
|
779 | 779 | } |
780 | 780 | |
781 | 781 | $sql = "SELECT u.user_id, u.lastname, u.firstname, u.username, u.email, s.c_id |
@@ -877,7 +877,7 @@ discard block |
||
877 | 877 | |
878 | 878 | $limit = null; |
879 | 879 | if (!empty($options['limit'])) { |
880 | - $limit = " LIMIT " . $options['limit']; |
|
880 | + $limit = " LIMIT ".$options['limit']; |
|
881 | 881 | } |
882 | 882 | |
883 | 883 | if (!empty($options['where'])) { |
@@ -886,7 +886,7 @@ discard block |
||
886 | 886 | |
887 | 887 | $order = null; |
888 | 888 | if (!empty($options['order'])) { |
889 | - $order = " ORDER BY " . $options['order']; |
|
889 | + $order = " ORDER BY ".$options['order']; |
|
890 | 890 | } |
891 | 891 | |
892 | 892 | //TODO, fix create report without session |
@@ -919,7 +919,7 @@ discard block |
||
919 | 919 | /** |
920 | 920 | * Lessons |
921 | 921 | */ |
922 | - $sql = "SELECT * FROM $tbl_course_lp WHERE c_id = %s "; //AND session_id = %s |
|
922 | + $sql = "SELECT * FROM $tbl_course_lp WHERE c_id = %s "; //AND session_id = %s |
|
923 | 923 | $sql_query = sprintf($sql, $course['real_id']); |
924 | 924 | $result = Database::query($sql_query); |
925 | 925 | $arrLesson = array(array()); |
@@ -927,7 +927,7 @@ discard block |
||
927 | 927 | if (empty($arrLesson[$row['session_id']]['lessons_total'])) { |
928 | 928 | $arrLesson[$row['session_id']]['lessons_total'] = 1; |
929 | 929 | } else { |
930 | - $arrLesson[$row['session_id']]['lessons_total'] ++; |
|
930 | + $arrLesson[$row['session_id']]['lessons_total']++; |
|
931 | 931 | } |
932 | 932 | } |
933 | 933 | |
@@ -1003,7 +1003,7 @@ discard block |
||
1003 | 1003 | $course['real_id'] |
1004 | 1004 | ); |
1005 | 1005 | foreach ($user_list as $user_id) { |
1006 | - isset($survey_user_list[$user_id]) ? $survey_user_list[$user_id] ++ : $survey_user_list[$user_id] = 1; |
|
1006 | + isset($survey_user_list[$user_id]) ? $survey_user_list[$user_id]++ : $survey_user_list[$user_id] = 1; |
|
1007 | 1007 | } |
1008 | 1008 | } |
1009 | 1009 | |
@@ -1057,7 +1057,7 @@ discard block |
||
1057 | 1057 | $assignments_done = Tracking::count_student_assignments($user['user_id'], $course['code'], $user['id_session']); |
1058 | 1058 | $assignments_left = $assignments_total - $assignments_done; |
1059 | 1059 | if (!empty($assignments_total)) { |
1060 | - $assignments_progress = round((( $assignments_done * 100 ) / $assignments_total), 2); |
|
1060 | + $assignments_progress = round((($assignments_done * 100) / $assignments_total), 2); |
|
1061 | 1061 | } else { |
1062 | 1062 | $assignments_progress = 0; |
1063 | 1063 | } |
@@ -1087,7 +1087,7 @@ discard block |
||
1087 | 1087 | $wiki_read = $row['count']; |
1088 | 1088 | $wiki_unread = $wiki_total - $wiki_read; |
1089 | 1089 | if (!empty($wiki_total)) { |
1090 | - $wiki_progress = round((( $wiki_read * 100 ) / $wiki_total), 2); |
|
1090 | + $wiki_progress = round((($wiki_read * 100) / $wiki_total), 2); |
|
1091 | 1091 | } else { |
1092 | 1092 | $wiki_progress = 0; |
1093 | 1093 | } |
@@ -1096,7 +1096,7 @@ discard block |
||
1096 | 1096 | $surveys_done = (isset($survey_user_list[$user['user_id']]) ? $survey_user_list[$user['user_id']] : 0); |
1097 | 1097 | $surveys_left = $surveys_total - $surveys_done; |
1098 | 1098 | if (!empty($surveys_total)) { |
1099 | - $surveys_progress = round((( $surveys_done * 100 ) / $surveys_total), 2); |
|
1099 | + $surveys_progress = round((($surveys_done * 100) / $surveys_total), 2); |
|
1100 | 1100 | } else { |
1101 | 1101 | $surveys_progress = 0; |
1102 | 1102 | } |
@@ -1109,7 +1109,7 @@ discard block |
||
1109 | 1109 | ); |
1110 | 1110 | $forums_left = $forums_total - $forums_done; |
1111 | 1111 | if (!empty($forums_total)) { |
1112 | - $forums_progress = round((( $forums_done * 100 ) / $forums_total), 2); |
|
1112 | + $forums_progress = round((($forums_done * 100) / $forums_total), 2); |
|
1113 | 1113 | } else { |
1114 | 1114 | $forums_progress = 0; |
1115 | 1115 | } |
@@ -1117,58 +1117,58 @@ discard block |
||
1117 | 1117 | //Overall Total |
1118 | 1118 | $overall_total = ($course_description_progress + $exercises_progress + $forums_progress + $assignments_progress + $wiki_progress + $surveys_progress) / 6; |
1119 | 1119 | |
1120 | - $link = '<a href="' . api_get_path(WEB_CODE_PATH) . 'mySpace/myStudents.php?student=' . $user[0] . '&details=true&course=' . $course['code'] . '&id_session=' . $user['id_session'] . '"> %s </a>'; |
|
1121 | - $linkForum = '<a href="' . api_get_path(WEB_CODE_PATH) . 'forum/index.php?cidReq=' . $course['code'] . '&id_session=' . $user['id_session'] . '"> %s </a>'; |
|
1122 | - $linkWork = '<a href="' . api_get_path(WEB_CODE_PATH) . 'work/work.php?cidReq=' . $course['code'] . '&id_session=' . $user['id_session'] . '"> %s </a>'; |
|
1123 | - $linkWiki = '<a href="' . api_get_path(WEB_CODE_PATH) . 'wiki/index.php?cidReq=' . $course['code'] . '&session_id=' . $user['id_session'] . '&action=statistics"> %s </a>'; |
|
1124 | - $linkSurvey = '<a href="' . api_get_path(WEB_CODE_PATH) . 'survey/survey_list.php?cidReq=' . $course['code'] . '&id_session=' . $user['id_session'] . '"> %s </a>'; |
|
1120 | + $link = '<a href="'.api_get_path(WEB_CODE_PATH).'mySpace/myStudents.php?student='.$user[0].'&details=true&course='.$course['code'].'&id_session='.$user['id_session'].'"> %s </a>'; |
|
1121 | + $linkForum = '<a href="'.api_get_path(WEB_CODE_PATH).'forum/index.php?cidReq='.$course['code'].'&id_session='.$user['id_session'].'"> %s </a>'; |
|
1122 | + $linkWork = '<a href="'.api_get_path(WEB_CODE_PATH).'work/work.php?cidReq='.$course['code'].'&id_session='.$user['id_session'].'"> %s </a>'; |
|
1123 | + $linkWiki = '<a href="'.api_get_path(WEB_CODE_PATH).'wiki/index.php?cidReq='.$course['code'].'&session_id='.$user['id_session'].'&action=statistics"> %s </a>'; |
|
1124 | + $linkSurvey = '<a href="'.api_get_path(WEB_CODE_PATH).'survey/survey_list.php?cidReq='.$course['code'].'&id_session='.$user['id_session'].'"> %s </a>'; |
|
1125 | 1125 | |
1126 | 1126 | $table[] = array( |
1127 | 1127 | 'lastname' => $user[1], |
1128 | 1128 | 'firstname' => $user[2], |
1129 | 1129 | 'username' => $user[3], |
1130 | 1130 | #'profile' => '', |
1131 | - 'total' => round($overall_total, 2) . '%', |
|
1132 | - 'courses' => sprintf($link, $course_description_progress . '%'), |
|
1133 | - 'lessons' => sprintf($link, $lessons_progress . '%'), |
|
1134 | - 'exercises' => sprintf($link, $exercises_progress . '%'), |
|
1135 | - 'forums' => sprintf($link, $forums_progress . '%'), |
|
1136 | - 'homeworks' => sprintf($link, $assignments_progress . '%'), |
|
1137 | - 'wikis' => sprintf($link, $wiki_progress . '%'), |
|
1138 | - 'surveys' => sprintf($link, $surveys_progress . '%'), |
|
1131 | + 'total' => round($overall_total, 2).'%', |
|
1132 | + 'courses' => sprintf($link, $course_description_progress.'%'), |
|
1133 | + 'lessons' => sprintf($link, $lessons_progress.'%'), |
|
1134 | + 'exercises' => sprintf($link, $exercises_progress.'%'), |
|
1135 | + 'forums' => sprintf($link, $forums_progress.'%'), |
|
1136 | + 'homeworks' => sprintf($link, $assignments_progress.'%'), |
|
1137 | + 'wikis' => sprintf($link, $wiki_progress.'%'), |
|
1138 | + 'surveys' => sprintf($link, $surveys_progress.'%'), |
|
1139 | 1139 | //course description |
1140 | - 'course_description_progress' => $course_description_progress . '%', |
|
1140 | + 'course_description_progress' => $course_description_progress.'%', |
|
1141 | 1141 | //lessons |
1142 | 1142 | 'lessons_total' => sprintf($link, $lessons_total), |
1143 | 1143 | 'lessons_done' => sprintf($link, $lessons_done), |
1144 | 1144 | 'lessons_left' => sprintf($link, $lessons_left), |
1145 | - 'lessons_progress' => sprintf($link, $lessons_progress . '%'), |
|
1145 | + 'lessons_progress' => sprintf($link, $lessons_progress.'%'), |
|
1146 | 1146 | //exercises |
1147 | 1147 | 'exercises_total' => sprintf($link, $exercises_total), |
1148 | 1148 | 'exercises_done' => sprintf($link, $exercises_done), |
1149 | 1149 | 'exercises_left' => sprintf($link, $exercises_left), |
1150 | - 'exercises_progress' => sprintf($link, $exercises_progress . '%'), |
|
1150 | + 'exercises_progress' => sprintf($link, $exercises_progress.'%'), |
|
1151 | 1151 | //forums |
1152 | 1152 | 'forums_total' => sprintf($linkForum, $forums_total), |
1153 | 1153 | 'forums_done' => sprintf($linkForum, $forums_done), |
1154 | 1154 | 'forums_left' => sprintf($linkForum, $forums_left), |
1155 | - 'forums_progress' => sprintf($linkForum, $forums_progress . '%'), |
|
1155 | + 'forums_progress' => sprintf($linkForum, $forums_progress.'%'), |
|
1156 | 1156 | //assignments |
1157 | 1157 | 'assignments_total' => sprintf($linkWork, $assignments_total), |
1158 | 1158 | 'assignments_done' => sprintf($linkWork, $assignments_done), |
1159 | 1159 | 'assignments_left' => sprintf($linkWork, $assignments_left), |
1160 | - 'assignments_progress' => sprintf($linkWork, $assignments_progress . '%'), |
|
1160 | + 'assignments_progress' => sprintf($linkWork, $assignments_progress.'%'), |
|
1161 | 1161 | //wiki |
1162 | 1162 | 'wiki_total' => sprintf($linkWiki, $wiki_total), |
1163 | 1163 | 'wiki_revisions' => sprintf($linkWiki, $wiki_revisions), |
1164 | 1164 | 'wiki_read' => sprintf($linkWiki, $wiki_read), |
1165 | 1165 | 'wiki_unread' => sprintf($linkWiki, $wiki_unread), |
1166 | - 'wiki_progress' => sprintf($linkWiki, $wiki_progress . '%'), |
|
1166 | + 'wiki_progress' => sprintf($linkWiki, $wiki_progress.'%'), |
|
1167 | 1167 | //survey |
1168 | 1168 | 'surveys_total' => sprintf($linkSurvey, $surveys_total), |
1169 | 1169 | 'surveys_done' => sprintf($linkSurvey, $surveys_done), |
1170 | 1170 | 'surveys_left' => sprintf($linkSurvey, $surveys_left), |
1171 | - 'surveys_progress' => sprintf($linkSurvey, $surveys_progress . '%'), |
|
1171 | + 'surveys_progress' => sprintf($linkSurvey, $surveys_progress.'%'), |
|
1172 | 1172 | ); |
1173 | 1173 | } |
1174 | 1174 | |
@@ -1250,7 +1250,7 @@ discard block |
||
1250 | 1250 | |
1251 | 1251 | $limit = null; |
1252 | 1252 | if (!empty($options['limit'])) { |
1253 | - $limit = " LIMIT " . $options['limit']; |
|
1253 | + $limit = " LIMIT ".$options['limit']; |
|
1254 | 1254 | } |
1255 | 1255 | |
1256 | 1256 | if (!empty($options['where'])) { |
@@ -1259,7 +1259,7 @@ discard block |
||
1259 | 1259 | |
1260 | 1260 | $order = null; |
1261 | 1261 | if (!empty($options['order'])) { |
1262 | - $order = " ORDER BY " . $options['order']; |
|
1262 | + $order = " ORDER BY ".$options['order']; |
|
1263 | 1263 | } |
1264 | 1264 | |
1265 | 1265 | //TODO add course name |
@@ -1272,7 +1272,7 @@ discard block |
||
1272 | 1272 | " : " |
1273 | 1273 | u.lastname, |
1274 | 1274 | u.firstname, |
1275 | - ") . " |
|
1275 | + ")." |
|
1276 | 1276 | a.logout_course_date, |
1277 | 1277 | a.counter, |
1278 | 1278 | c.title, |
@@ -1354,7 +1354,7 @@ discard block |
||
1354 | 1354 | if (Database::num_rows($result) > 0) { |
1355 | 1355 | $row = Database::fetch_array($result); |
1356 | 1356 | $count = $row['count'] + 1; |
1357 | - $session_name = $session_name . '_' . $count; |
|
1357 | + $session_name = $session_name.'_'.$count; |
|
1358 | 1358 | $result = self::session_name_exists($session_name); |
1359 | 1359 | if (!$result) { |
1360 | 1360 | return $session_name; |
@@ -1861,7 +1861,7 @@ discard block |
||
1861 | 1861 | // Delete users from the session |
1862 | 1862 | if ($empty_users === true) { |
1863 | 1863 | $sql = "DELETE FROM $tbl_session_rel_user |
1864 | - WHERE session_id = $id_session AND relation_type<>" . SESSION_RELATION_TYPE_RRHH . ""; |
|
1864 | + WHERE session_id = $id_session AND relation_type<>".SESSION_RELATION_TYPE_RRHH.""; |
|
1865 | 1865 | Database::query($sql); |
1866 | 1866 | } |
1867 | 1867 | |
@@ -1872,7 +1872,7 @@ discard block |
||
1872 | 1872 | $enreg_user = Database::escape_string($enreg_user); |
1873 | 1873 | $nbr_users++; |
1874 | 1874 | $sql = "INSERT IGNORE INTO $tbl_session_rel_user (relation_type, session_id, user_id, registered_at) |
1875 | - VALUES (0, $id_session, $enreg_user, '" . api_get_utc_datetime() . "')"; |
|
1875 | + VALUES (0, $id_session, $enreg_user, '".api_get_utc_datetime()."')"; |
|
1876 | 1876 | Database::query($sql); |
1877 | 1877 | } |
1878 | 1878 | |
@@ -1964,7 +1964,7 @@ discard block |
||
1964 | 1964 | $statusCondition = null; |
1965 | 1965 | if (isset($status) && !is_null($status)) { |
1966 | 1966 | $status = intval($status); |
1967 | - $statusCondition = " AND status = $status"; |
|
1967 | + $statusCondition = " AND status = $status"; |
|
1968 | 1968 | } |
1969 | 1969 | |
1970 | 1970 | foreach ($userList as $userId) { |
@@ -2096,7 +2096,7 @@ discard block |
||
2096 | 2096 | if (empty($count)) { |
2097 | 2097 | // If user is not registered to a session then add it. |
2098 | 2098 | $sql = "INSERT IGNORE INTO $tbl_session_rel_user (session_id, user_id, registered_at) |
2099 | - VALUES ($session_id, $enreg_user, '" . api_get_utc_datetime() . "')"; |
|
2099 | + VALUES ($session_id, $enreg_user, '".api_get_utc_datetime()."')"; |
|
2100 | 2100 | Database::query($sql); |
2101 | 2101 | |
2102 | 2102 | $sql = "UPDATE $tbl_session SET nbr_users = nbr_users + 1 |
@@ -2139,7 +2139,7 @@ discard block |
||
2139 | 2139 | WHERE |
2140 | 2140 | session_id = $session_id AND |
2141 | 2141 | user_id = $user_id AND |
2142 | - relation_type <> " . SESSION_RELATION_TYPE_RRHH . ""; |
|
2142 | + relation_type <> ".SESSION_RELATION_TYPE_RRHH.""; |
|
2143 | 2143 | $result = Database::query($sql); |
2144 | 2144 | $return = Database::affected_rows($result); |
2145 | 2145 | |
@@ -2224,7 +2224,7 @@ discard block |
||
2224 | 2224 | FROM $tbl_session_rel_user |
2225 | 2225 | WHERE |
2226 | 2226 | session_id = $sessionId AND |
2227 | - relation_type<>" . SESSION_RELATION_TYPE_RRHH; |
|
2227 | + relation_type<>".SESSION_RELATION_TYPE_RRHH; |
|
2228 | 2228 | $result = Database::query($sql); |
2229 | 2229 | $user_list = Database::store_result($result); |
2230 | 2230 | |
@@ -2235,7 +2235,7 @@ discard block |
||
2235 | 2235 | |
2236 | 2236 | $sql = "DELETE FROM $tbl_session_rel_course |
2237 | 2237 | WHERE |
2238 | - c_id = " . $existingCourse['c_id'] . " AND |
|
2238 | + c_id = ".$existingCourse['c_id']." AND |
|
2239 | 2239 | session_id = $sessionId"; |
2240 | 2240 | Database::query($sql); |
2241 | 2241 | |
@@ -2298,7 +2298,7 @@ discard block |
||
2298 | 2298 | $links = $cat->get_links(null, false, $courseInfo['code'], 0); |
2299 | 2299 | |
2300 | 2300 | $cat->set_session_id($sessionId); |
2301 | - $oldCategoryId= $cat->get_id(); |
|
2301 | + $oldCategoryId = $cat->get_id(); |
|
2302 | 2302 | $newId = $cat->add(); |
2303 | 2303 | $newCategoryIdList[$oldCategoryId] = $newId; |
2304 | 2304 | $parentId = $cat->get_parent_id(); |
@@ -2485,7 +2485,7 @@ discard block |
||
2485 | 2485 | $return_value = false; |
2486 | 2486 | $sql = "SELECT c_id FROM $tbl_session_course |
2487 | 2487 | WHERE |
2488 | - session_id = " . intval($session_id) . " AND |
|
2488 | + session_id = ".intval($session_id)." AND |
|
2489 | 2489 | c_id = " . intval($courseId); |
2490 | 2490 | $result = Database::query($sql); |
2491 | 2491 | $num = Database::num_rows($result); |
@@ -2509,8 +2509,8 @@ discard block |
||
2509 | 2509 | } |
2510 | 2510 | |
2511 | 2511 | $sql = 'SELECT * |
2512 | - FROM ' . $tbl_session . ' |
|
2513 | - WHERE name = "' . Database::escape_string($session_name) . '"'; |
|
2512 | + FROM ' . $tbl_session.' |
|
2513 | + WHERE name = "' . Database::escape_string($session_name).'"'; |
|
2514 | 2514 | $result = Database::query($sql); |
2515 | 2515 | $num = Database::num_rows($result); |
2516 | 2516 | if ($num > 0) { |
@@ -2550,8 +2550,8 @@ discard block |
||
2550 | 2550 | $month_end = intval($smonth_end); |
2551 | 2551 | $day_end = intval($sday_end); |
2552 | 2552 | |
2553 | - $date_start = "$year_start-" . (($month_start < 10) ? "0$month_start" : $month_start) . "-" . (($day_start < 10) ? "0$day_start" : $day_start); |
|
2554 | - $date_end = "$year_end-" . (($month_end < 10) ? "0$month_end" : $month_end) . "-" . (($day_end < 10) ? "0$day_end" : $day_end); |
|
2553 | + $date_start = "$year_start-".(($month_start < 10) ? "0$month_start" : $month_start)."-".(($day_start < 10) ? "0$day_start" : $day_start); |
|
2554 | + $date_end = "$year_end-".(($month_end < 10) ? "0$month_end" : $month_end)."-".(($day_end < 10) ? "0$day_end" : $day_end); |
|
2555 | 2555 | |
2556 | 2556 | if (empty($name)) { |
2557 | 2557 | $msg = get_lang('SessionCategoryNameIsRequired'); |
@@ -2628,8 +2628,8 @@ discard block |
||
2628 | 2628 | $month_end = intval($smonth_end); |
2629 | 2629 | $day_end = intval($sday_end); |
2630 | 2630 | $id = intval($id); |
2631 | - $date_start = "$year_start-" . (($month_start < 10) ? "0$month_start" : $month_start) . "-" . (($day_start < 10) ? "0$day_start" : $day_start); |
|
2632 | - $date_end = "$year_end-" . (($month_end < 10) ? "0$month_end" : $month_end) . "-" . (($day_end < 10) ? "0$day_end" : $day_end); |
|
2631 | + $date_start = "$year_start-".(($month_start < 10) ? "0$month_start" : $month_start)."-".(($day_start < 10) ? "0$day_start" : $day_start); |
|
2632 | + $date_end = "$year_end-".(($month_end < 10) ? "0$month_end" : $month_end)."-".(($day_end < 10) ? "0$day_end" : $day_end); |
|
2633 | 2633 | |
2634 | 2634 | if (empty($name)) { |
2635 | 2635 | $msg = get_lang('SessionCategoryNameIsRequired'); |
@@ -2649,13 +2649,13 @@ discard block |
||
2649 | 2649 | if ($date_end <> null) { |
2650 | 2650 | $sql = "UPDATE $tbl_session_category |
2651 | 2651 | SET |
2652 | - name = '" . Database::escape_string($name) . "', |
|
2652 | + name = '".Database::escape_string($name)."', |
|
2653 | 2653 | date_start = '$date_start' , |
2654 | 2654 | date_end = '$date_end' |
2655 | 2655 | WHERE id= $id"; |
2656 | 2656 | } else { |
2657 | 2657 | $sql = "UPDATE $tbl_session_category SET |
2658 | - name = '" . Database::escape_string($name) . "', |
|
2658 | + name = '".Database::escape_string($name)."', |
|
2659 | 2659 | date_start = '$date_start', |
2660 | 2660 | date_end = NULL |
2661 | 2661 | WHERE id= $id"; |
@@ -2685,10 +2685,10 @@ discard block |
||
2685 | 2685 | |
2686 | 2686 | //Setting session_category_id to 0 |
2687 | 2687 | $sql = "UPDATE $tbl_session SET session_category_id = 0 |
2688 | - WHERE session_category_id IN (" . $id_checked . ")"; |
|
2688 | + WHERE session_category_id IN (".$id_checked.")"; |
|
2689 | 2689 | Database::query($sql); |
2690 | 2690 | |
2691 | - $sql = "SELECT id FROM $tbl_session WHERE session_category_id IN (" . $id_checked . ")"; |
|
2691 | + $sql = "SELECT id FROM $tbl_session WHERE session_category_id IN (".$id_checked.")"; |
|
2692 | 2692 | $result = Database::query($sql); |
2693 | 2693 | while ($rows = Database::fetch_array($result)) { |
2694 | 2694 | $session_id = $rows['id']; |
@@ -2700,7 +2700,7 @@ discard block |
||
2700 | 2700 | } |
2701 | 2701 | } |
2702 | 2702 | } |
2703 | - $sql = "DELETE FROM $tbl_session_category WHERE id IN (" . $id_checked . ")"; |
|
2703 | + $sql = "DELETE FROM $tbl_session_category WHERE id IN (".$id_checked.")"; |
|
2704 | 2704 | Database::query($sql); |
2705 | 2705 | |
2706 | 2706 | // Add event to system log |
@@ -2773,7 +2773,7 @@ discard block |
||
2773 | 2773 | $value = Database::escape_string($options['value']); |
2774 | 2774 | $sql_query .= ' AND '; |
2775 | 2775 | if (in_array($field, $availableFields) && in_array($operator, $availableOperator)) { |
2776 | - $sql_query .= $field . " $operator '" . $value . "'"; |
|
2776 | + $sql_query .= $field." $operator '".$value."'"; |
|
2777 | 2777 | } |
2778 | 2778 | } |
2779 | 2779 | } |
@@ -2840,8 +2840,8 @@ discard block |
||
2840 | 2840 | { |
2841 | 2841 | $tbl_session_category = Database::get_main_table(TABLE_MAIN_SESSION_CATEGORY); |
2842 | 2842 | $id = api_get_current_access_url_id(); |
2843 | - $sql = 'SELECT * FROM ' . $tbl_session_category . ' |
|
2844 | - WHERE access_url_id = ' . $id . ' |
|
2843 | + $sql = 'SELECT * FROM '.$tbl_session_category.' |
|
2844 | + WHERE access_url_id = ' . $id.' |
|
2845 | 2845 | ORDER BY name ASC'; |
2846 | 2846 | $result = Database::query($sql); |
2847 | 2847 | if (Database::num_rows($result) > 0) { |
@@ -2994,7 +2994,7 @@ discard block |
||
2994 | 2994 | $sql = "DELETE FROM $tbl_session_rel_user |
2995 | 2995 | WHERE |
2996 | 2996 | session_id = $sessionId AND |
2997 | - relation_type =" . SESSION_RELATION_TYPE_RRHH; |
|
2997 | + relation_type =".SESSION_RELATION_TYPE_RRHH; |
|
2998 | 2998 | Database::query($sql); |
2999 | 2999 | |
3000 | 3000 | return true; |
@@ -3048,12 +3048,12 @@ discard block |
||
3048 | 3048 | ON (a.session_id = s.session_id) |
3049 | 3049 | WHERE |
3050 | 3050 | s.user_id = $userId AND |
3051 | - relation_type = " . SESSION_RELATION_TYPE_RRHH . " AND |
|
3051 | + relation_type = ".SESSION_RELATION_TYPE_RRHH." AND |
|
3052 | 3052 | access_url_id = " . api_get_current_access_url_id(); |
3053 | 3053 | } else { |
3054 | 3054 | $sql = "SELECT s.session_id |
3055 | 3055 | FROM $tbl_session_rel_user s |
3056 | - WHERE user_id = $userId AND relation_type=" . SESSION_RELATION_TYPE_RRHH; |
|
3056 | + WHERE user_id = $userId AND relation_type=".SESSION_RELATION_TYPE_RRHH; |
|
3057 | 3057 | } |
3058 | 3058 | $result = Database::query($sql); |
3059 | 3059 | |
@@ -3063,7 +3063,7 @@ discard block |
||
3063 | 3063 | WHERE |
3064 | 3064 | session_id = {$row['session_id']} AND |
3065 | 3065 | user_id = $userId AND |
3066 | - relation_type =" . SESSION_RELATION_TYPE_RRHH; |
|
3066 | + relation_type =".SESSION_RELATION_TYPE_RRHH; |
|
3067 | 3067 | Database::query($sql); |
3068 | 3068 | } |
3069 | 3069 | } |
@@ -3078,7 +3078,7 @@ discard block |
||
3078 | 3078 | WHERE |
3079 | 3079 | session_id = $session_id AND |
3080 | 3080 | user_id = $userId AND |
3081 | - relation_type = '" . SESSION_RELATION_TYPE_RRHH . "'"; |
|
3081 | + relation_type = '".SESSION_RELATION_TYPE_RRHH."'"; |
|
3082 | 3082 | $result = Database::query($sql); |
3083 | 3083 | if (Database::num_rows($result) == 0) { |
3084 | 3084 | $sql = "INSERT IGNORE INTO $tbl_session_rel_user (session_id, user_id, relation_type, registered_at) |
@@ -3128,8 +3128,8 @@ discard block |
||
3128 | 3128 | WHERE |
3129 | 3129 | sru.user_id = '$userId' AND |
3130 | 3130 | sru.session_id = '$sessionId' AND |
3131 | - sru.relation_type = '" . SESSION_RELATION_TYPE_RRHH . "' AND |
|
3132 | - access_url_id = " . api_get_current_access_url_id() . " |
|
3131 | + sru.relation_type = '".SESSION_RELATION_TYPE_RRHH."' AND |
|
3132 | + access_url_id = " . api_get_current_access_url_id()." |
|
3133 | 3133 | "; |
3134 | 3134 | } else { |
3135 | 3135 | $sql = "$select FROM $tbl_session s |
@@ -3138,7 +3138,7 @@ discard block |
||
3138 | 3138 | sru.session_id = s.id AND |
3139 | 3139 | sru.user_id = '$userId' AND |
3140 | 3140 | sru.session_id = '$sessionId' AND |
3141 | - sru.relation_type = '" . SESSION_RELATION_TYPE_RRHH . "' |
|
3141 | + sru.relation_type = '".SESSION_RELATION_TYPE_RRHH."' |
|
3142 | 3142 | "; |
3143 | 3143 | } |
3144 | 3144 | |
@@ -3238,7 +3238,7 @@ discard block |
||
3238 | 3238 | |
3239 | 3239 | $limitCondition = null; |
3240 | 3240 | if (!empty($start) && !empty($limit)) { |
3241 | - $limitCondition = " LIMIT " . intval($start) . ", " . intval($limit); |
|
3241 | + $limitCondition = " LIMIT ".intval($start).", ".intval($limit); |
|
3242 | 3242 | } |
3243 | 3243 | |
3244 | 3244 | if (empty($orderCondition)) { |
@@ -3315,26 +3315,26 @@ discard block |
||
3315 | 3315 | |
3316 | 3316 | $sessions = array(); |
3317 | 3317 | if (Database::num_rows($result) > 0) { |
3318 | - $sysUploadPath = api_get_path(SYS_UPLOAD_PATH). 'sessions/'; |
|
3319 | - $webUploadPath = api_get_path(WEB_UPLOAD_PATH). 'sessions/'; |
|
3318 | + $sysUploadPath = api_get_path(SYS_UPLOAD_PATH).'sessions/'; |
|
3319 | + $webUploadPath = api_get_path(WEB_UPLOAD_PATH).'sessions/'; |
|
3320 | 3320 | $imgPath = Display::return_icon('session_default_small.png', null, null, null, null, true); |
3321 | 3321 | |
3322 | 3322 | $tableExtraFields = Database::get_main_table(TABLE_EXTRA_FIELD); |
3323 | - $sql = "SELECT id FROM " . $tableExtraFields . " |
|
3323 | + $sql = "SELECT id FROM ".$tableExtraFields." |
|
3324 | 3324 | WHERE extra_field_type = 3 AND variable='image'"; |
3325 | 3325 | $resultField = Database::query($sql); |
3326 | 3326 | $imageFieldId = Database::fetch_assoc($resultField); |
3327 | 3327 | |
3328 | 3328 | while ($row = Database::fetch_array($result)) { |
3329 | 3329 | |
3330 | - $row['image'] = null; |
|
3331 | - $sessionImage = $sysUploadPath . $imageFieldId['id'] . '_' . $row['id'] . '.png'; |
|
3330 | + $row['image'] = null; |
|
3331 | + $sessionImage = $sysUploadPath.$imageFieldId['id'].'_'.$row['id'].'.png'; |
|
3332 | 3332 | |
3333 | 3333 | if (is_file($sessionImage)) { |
3334 | - $sessionImage = $webUploadPath . $imageFieldId['id'] . '_' . $row['id'] . '.png'; |
|
3334 | + $sessionImage = $webUploadPath.$imageFieldId['id'].'_'.$row['id'].'.png'; |
|
3335 | 3335 | $row['image'] = $sessionImage; |
3336 | 3336 | } else { |
3337 | - $row['image'] = $imgPath; |
|
3337 | + $row['image'] = $imgPath; |
|
3338 | 3338 | } |
3339 | 3339 | |
3340 | 3340 | if ($row['display_start_date'] == '0000-00-00 00:00:00' || $row['display_start_date'] == '0000-00-00') { |
@@ -3434,7 +3434,7 @@ discard block |
||
3434 | 3434 | return intval($count['count']); |
3435 | 3435 | } |
3436 | 3436 | |
3437 | - while ($row = Database::fetch_array($result,'ASSOC')) { |
|
3437 | + while ($row = Database::fetch_array($result, 'ASSOC')) { |
|
3438 | 3438 | $courses[$row['real_id']] = $row; |
3439 | 3439 | } |
3440 | 3440 | } |
@@ -3478,7 +3478,7 @@ discard block |
||
3478 | 3478 | } |
3479 | 3479 | |
3480 | 3480 | $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE); |
3481 | - $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE); |
|
3481 | + $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE); |
|
3482 | 3482 | |
3483 | 3483 | if ($getCount) { |
3484 | 3484 | $select = "SELECT COUNT(DISTINCT(c.code)) as count "; |
@@ -3503,7 +3503,7 @@ discard block |
||
3503 | 3503 | "; |
3504 | 3504 | if ($getCount) { |
3505 | 3505 | $result = Database::query($sql); |
3506 | - $row = Database::fetch_array($result,'ASSOC'); |
|
3506 | + $row = Database::fetch_array($result, 'ASSOC'); |
|
3507 | 3507 | return $row['count']; |
3508 | 3508 | } |
3509 | 3509 | |
@@ -3518,7 +3518,7 @@ discard block |
||
3518 | 3518 | $courses = array(); |
3519 | 3519 | |
3520 | 3520 | if ($num_rows > 0) { |
3521 | - while ($row = Database::fetch_array($result,'ASSOC')) { |
|
3521 | + while ($row = Database::fetch_array($result, 'ASSOC')) { |
|
3522 | 3522 | $courses[$row['id']] = $row; |
3523 | 3523 | } |
3524 | 3524 | } |
@@ -3596,7 +3596,7 @@ discard block |
||
3596 | 3596 | $result = Database::query($sql); |
3597 | 3597 | $num_rows = Database::num_rows($result); |
3598 | 3598 | if ($num_rows > 0) { |
3599 | - $row = Database::fetch_array($result,'ASSOC'); |
|
3599 | + $row = Database::fetch_array($result, 'ASSOC'); |
|
3600 | 3600 | return $row['count']; |
3601 | 3601 | } |
3602 | 3602 | |
@@ -3715,9 +3715,9 @@ discard block |
||
3715 | 3715 | |
3716 | 3716 | if ($access_url_id != -1) { |
3717 | 3717 | $sql = 'SELECT DISTINCT session.* |
3718 | - FROM ' . $session_table . ' session INNER JOIN ' . $tbl_session_rel_access_url . ' session_rel_url |
|
3718 | + FROM ' . $session_table.' session INNER JOIN '.$tbl_session_rel_access_url.' session_rel_url |
|
3719 | 3719 | ON (session.id = session_rel_url.session_id) |
3720 | - WHERE '.$sqlCoach.' access_url_id = ' . $access_url_id; |
|
3720 | + WHERE '.$sqlCoach.' access_url_id = '.$access_url_id; |
|
3721 | 3721 | } |
3722 | 3722 | } |
3723 | 3723 | $sql .= ' ORDER by name'; |
@@ -3751,8 +3751,8 @@ discard block |
||
3751 | 3751 | FROM $tbl_session_rel_course_rel_user session_rcru, $tbl_user user |
3752 | 3752 | WHERE |
3753 | 3753 | session_rcru.user_id = user.user_id AND |
3754 | - session_rcru.session_id = '" . intval($session_id) . "' AND |
|
3755 | - session_rcru.c_id ='" . intval($courseId) . "' AND |
|
3754 | + session_rcru.session_id = '".intval($session_id)."' AND |
|
3755 | + session_rcru.c_id ='" . intval($courseId)."' AND |
|
3756 | 3756 | user.user_id = " . intval($user_id); |
3757 | 3757 | |
3758 | 3758 | $result = Database::query($sql); |
@@ -3783,8 +3783,8 @@ discard block |
||
3783 | 3783 | $sql = "SELECT session_rcru.status |
3784 | 3784 | FROM $tbl_session_rel_course_rel_user session_rcru, $tbl_user user |
3785 | 3785 | WHERE session_rcru.user_id = user.user_id AND |
3786 | - session_rcru.session_id = '" . intval($session_id) . "' AND |
|
3787 | - session_rcru.c_id ='" . intval($courseId) . "' AND |
|
3786 | + session_rcru.session_id = '".intval($session_id)."' AND |
|
3787 | + session_rcru.c_id ='" . intval($courseId)."' AND |
|
3788 | 3788 | user.user_id = " . intval($user_id); |
3789 | 3789 | $result = Database::query($sql); |
3790 | 3790 | $status = false; |
@@ -3861,7 +3861,7 @@ discard block |
||
3861 | 3861 | // Get timestamp for now in UTC - see http://php.net/manual/es/function.time.php#117251 |
3862 | 3862 | $now = time() - date('Z'); |
3863 | 3863 | // Timestamp in one month |
3864 | - $inOneMonth = $now + (30*24*3600); |
|
3864 | + $inOneMonth = $now + (30 * 24 * 3600); |
|
3865 | 3865 | $inOneMonth = api_get_local_time($inOneMonth); |
3866 | 3866 | if (api_strtotime($s['access_start_date']) < $now) { |
3867 | 3867 | $s['access_start_date'] = api_get_local_time($now); |
@@ -3883,16 +3883,16 @@ discard block |
||
3883 | 3883 | } |
3884 | 3884 | // Now try to create the session |
3885 | 3885 | $sid = self::create_session( |
3886 | - $s['name'] . ' ' . get_lang('CopyLabelSuffix'), |
|
3886 | + $s['name'].' '.get_lang('CopyLabelSuffix'), |
|
3887 | 3887 | $s['access_start_date'], |
3888 | 3888 | $s['access_end_date'], |
3889 | 3889 | $s['display_start_date'], |
3890 | 3890 | $s['display_end_date'], |
3891 | 3891 | $s['coach_access_start_date'], |
3892 | 3892 | $s['coach_access_end_date'], |
3893 | - (int)$s['id_coach'], |
|
3893 | + (int) $s['id_coach'], |
|
3894 | 3894 | $s['session_category_id'], |
3895 | - (int)$s['visibility'], |
|
3895 | + (int) $s['visibility'], |
|
3896 | 3896 | true |
3897 | 3897 | ); |
3898 | 3898 | |
@@ -4006,7 +4006,7 @@ discard block |
||
4006 | 4006 | $session_table = Database::get_main_table(TABLE_MAIN_SESSION); |
4007 | 4007 | $sql = "SELECT DISTINCT id |
4008 | 4008 | FROM $session_table |
4009 | - WHERE session.id_coach = '" . $user_id . "' AND id = '$session_id'"; |
|
4009 | + WHERE session.id_coach = '".$user_id."' AND id = '$session_id'"; |
|
4010 | 4010 | $result = Database::query($sql); |
4011 | 4011 | if ($result && Database::num_rows($result)) { |
4012 | 4012 | return true; |
@@ -4025,7 +4025,7 @@ discard block |
||
4025 | 4025 | $access_url_rel_session_table = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
4026 | 4026 | $sql = "SELECT count(id) FROM $session_table s"; |
4027 | 4027 | if (!empty($access_url_id) && $access_url_id == intval($access_url_id)) { |
4028 | - $sql .= ", $access_url_rel_session_table u " . |
|
4028 | + $sql .= ", $access_url_rel_session_table u ". |
|
4029 | 4029 | " WHERE s.id = u.session_id AND u.access_url_id = $access_url_id"; |
4030 | 4030 | } |
4031 | 4031 | $res = Database::query($sql); |
@@ -4264,7 +4264,7 @@ discard block |
||
4264 | 4264 | |
4265 | 4265 | $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); |
4266 | 4266 | $tbl_session_user = Database::get_main_table(TABLE_MAIN_SESSION_USER); |
4267 | - $tbl_session_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE); |
|
4267 | + $tbl_session_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE); |
|
4268 | 4268 | $tbl_session_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER); |
4269 | 4269 | |
4270 | 4270 | $sessions = array(); |
@@ -4400,10 +4400,10 @@ discard block |
||
4400 | 4400 | $suffix = null; |
4401 | 4401 | while (!$unique_name) { |
4402 | 4402 | if ($i > 1) { |
4403 | - $suffix = ' - ' . $i; |
|
4403 | + $suffix = ' - '.$i; |
|
4404 | 4404 | } |
4405 | - $sql = 'SELECT 1 FROM ' . $tbl_session . ' |
|
4406 | - WHERE name="' . Database::escape_string($session_name). $suffix . '"'; |
|
4405 | + $sql = 'SELECT 1 FROM '.$tbl_session.' |
|
4406 | + WHERE name="' . Database::escape_string($session_name).$suffix.'"'; |
|
4407 | 4407 | $rs = Database::query($sql); |
4408 | 4408 | |
4409 | 4409 | if (Database::result($rs, 0, 0)) { |
@@ -4416,14 +4416,14 @@ discard block |
||
4416 | 4416 | |
4417 | 4417 | // Creating the session. |
4418 | 4418 | $sql = "INSERT IGNORE INTO $tbl_session SET |
4419 | - name = '" . Database::escape_string($session_name). "', |
|
4419 | + name = '".Database::escape_string($session_name)."', |
|
4420 | 4420 | id_coach = '$coach_id', |
4421 | 4421 | access_start_date = '$dateStart', |
4422 | 4422 | access_end_date = '$dateEnd', |
4423 | 4423 | display_start_date = '$dateStart', |
4424 | 4424 | display_end_date = '$dateEnd', |
4425 | 4425 | visibility = '$visibilityAfterExpirationPerSession', |
4426 | - session_admin_id = " . $defaultUserId . " |
|
4426 | + session_admin_id = ".$defaultUserId." |
|
4427 | 4427 | $sessionCondition $extraParameters $extraSessionParameters"; |
4428 | 4428 | Database::query($sql); |
4429 | 4429 | |
@@ -4489,7 +4489,7 @@ discard block |
||
4489 | 4489 | |
4490 | 4490 | // Delete session-user relation only for students |
4491 | 4491 | $sql = "DELETE FROM $tbl_session_user |
4492 | - WHERE session_id = '$session_id' AND relation_type <> " . SESSION_RELATION_TYPE_RRHH; |
|
4492 | + WHERE session_id = '$session_id' AND relation_type <> ".SESSION_RELATION_TYPE_RRHH; |
|
4493 | 4493 | Database::query($sql); |
4494 | 4494 | |
4495 | 4495 | $sql = "DELETE FROM $tbl_session_course WHERE session_id = '$session_id'"; |
@@ -4580,7 +4580,7 @@ discard block |
||
4580 | 4580 | |
4581 | 4581 | // Delete session-user relation only for students |
4582 | 4582 | $sql = "DELETE FROM $tbl_session_user |
4583 | - WHERE session_id = '$session_id' AND relation_type <> " . SESSION_RELATION_TYPE_RRHH; |
|
4583 | + WHERE session_id = '$session_id' AND relation_type <> ".SESSION_RELATION_TYPE_RRHH; |
|
4584 | 4584 | Database::query($sql); |
4585 | 4585 | |
4586 | 4586 | $sql = "DELETE FROM $tbl_session_course WHERE session_id = '$session_id'"; |
@@ -4623,7 +4623,7 @@ discard block |
||
4623 | 4623 | $sql = "INSERT IGNORE INTO $tbl_session_user SET |
4624 | 4624 | user_id = '$user_id', |
4625 | 4625 | session_id = '$session_id', |
4626 | - registered_at = '" . api_get_utc_datetime() . "'"; |
|
4626 | + registered_at = '".api_get_utc_datetime()."'"; |
|
4627 | 4627 | Database::query($sql); |
4628 | 4628 | if ($debug) { |
4629 | 4629 | $logger->addInfo("Sessions - Adding User #$user_id ($user) to session #$session_id"); |
@@ -5182,7 +5182,7 @@ discard block |
||
5182 | 5182 | foreach ($sessions as $session) { |
5183 | 5183 | $courseList = SessionManager::get_course_list_by_session_id($session['id']); |
5184 | 5184 | foreach ($courseList as $course) { |
5185 | - $coursesFromSession[$course['code'].':'.$session['id']] = $course['visual_code'] . ' - ' . $course['title'] . ' (' . $session['name'] . ')'; |
|
5185 | + $coursesFromSession[$course['code'].':'.$session['id']] = $course['visual_code'].' - '.$course['title'].' ('.$session['name'].')'; |
|
5186 | 5186 | } |
5187 | 5187 | } |
5188 | 5188 | } |
@@ -5329,7 +5329,7 @@ discard block |
||
5329 | 5329 | |
5330 | 5330 | if (!empty($lastConnectionDate)) { |
5331 | 5331 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
5332 | - $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
5332 | + $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
5333 | 5333 | } |
5334 | 5334 | |
5335 | 5335 | if (!empty($keyword)) { |
@@ -5399,7 +5399,7 @@ discard block |
||
5399 | 5399 | $result = Database::query($sql); |
5400 | 5400 | $result = Database::store_result($result); |
5401 | 5401 | |
5402 | - return $result ; |
|
5402 | + return $result; |
|
5403 | 5403 | } |
5404 | 5404 | |
5405 | 5405 | /** |
@@ -5459,7 +5459,7 @@ discard block |
||
5459 | 5459 | $userToString = null; |
5460 | 5460 | foreach ($userList as $userInfo) { |
5461 | 5461 | $newUserList[] = $userInfo['user_id']; |
5462 | - $userToString .= $userInfo['firstname'] . ' ' . $userInfo['lastname'] . '<br />'; |
|
5462 | + $userToString .= $userInfo['firstname'].' '.$userInfo['lastname'].'<br />'; |
|
5463 | 5463 | } |
5464 | 5464 | |
5465 | 5465 | if (!empty($sessionsDestination)) { |
@@ -5472,7 +5472,7 @@ discard block |
||
5472 | 5472 | $messages[] = Display::return_message(sprintf(get_lang('SessionXSkipped'), $sessionDestinationId), 'warning', false); |
5473 | 5473 | continue; |
5474 | 5474 | } |
5475 | - $messages[] = Display::return_message(get_lang('StudentList') . '<br />' . $userToString, 'info', false); |
|
5475 | + $messages[] = Display::return_message(get_lang('StudentList').'<br />'.$userToString, 'info', false); |
|
5476 | 5476 | SessionManager::subscribe_users_to_session( |
5477 | 5477 | $sessionDestinationId, |
5478 | 5478 | $newUserList, |
@@ -5527,7 +5527,7 @@ discard block |
||
5527 | 5527 | } |
5528 | 5528 | } |
5529 | 5529 | } |
5530 | - $sessionUrl = api_get_path(WEB_CODE_PATH) . 'admin/resume_session.php?id_session='; |
|
5530 | + $sessionUrl = api_get_path(WEB_CODE_PATH).'admin/resume_session.php?id_session='; |
|
5531 | 5531 | |
5532 | 5532 | $htmlResult = null; |
5533 | 5533 | |
@@ -5542,7 +5542,7 @@ discard block |
||
5542 | 5542 | $sessionInfo = self::fetch($sessionId); |
5543 | 5543 | $htmlResult .= '<br />'; |
5544 | 5544 | $htmlResult .= Display::url( |
5545 | - get_lang('Session') . ': ' . $sessionInfo['name'] . ' <br />', $sessionUrl . $sessionId, array('target' => '_blank') |
|
5545 | + get_lang('Session').': '.$sessionInfo['name'].' <br />', $sessionUrl.$sessionId, array('target' => '_blank') |
|
5546 | 5546 | ); |
5547 | 5547 | $teacherList = array(); |
5548 | 5548 | foreach ($coachList as $coachId) { |
@@ -5655,7 +5655,7 @@ discard block |
||
5655 | 5655 | } |
5656 | 5656 | |
5657 | 5657 | $sessionIdList = array_map('intval', $sessionIdList); |
5658 | - $sessionToString = implode("', '", $sessionIdList); |
|
5658 | + $sessionToString = implode("', '", $sessionIdList); |
|
5659 | 5659 | |
5660 | 5660 | $course = Database::get_main_table(TABLE_MAIN_COURSE); |
5661 | 5661 | $sessionCourse = Database::get_main_table(TABLE_MAIN_SESSION_COURSE); |
@@ -5667,7 +5667,7 @@ discard block |
||
5667 | 5667 | INNER JOIN $courseUser cu ON (cu.c_id = c.id) |
5668 | 5668 | WHERE src.session_id IN ('$sessionToString') AND cu.status = 1"; |
5669 | 5669 | $result = Database::query($sql); |
5670 | - while($row = Database::fetch_array($result, 'ASSOC')) { |
|
5670 | + while ($row = Database::fetch_array($result, 'ASSOC')) { |
|
5671 | 5671 | $teacherListId[$row['user_id']] = $row['user_id']; |
5672 | 5672 | } |
5673 | 5673 | } else { |
@@ -5742,7 +5742,7 @@ discard block |
||
5742 | 5742 | $toolList = self::getCourseToolToBeManaged(); |
5743 | 5743 | |
5744 | 5744 | foreach ($toolList as $tool) { |
5745 | - $method = 'add' . $tool; |
|
5745 | + $method = 'add'.$tool; |
|
5746 | 5746 | if (method_exists(get_class(), $method)) { |
5747 | 5747 | self::$method($sessionId, $courseId); |
5748 | 5748 | } |
@@ -5761,7 +5761,7 @@ discard block |
||
5761 | 5761 | $toolList = self::getCourseToolToBeManaged(); |
5762 | 5762 | |
5763 | 5763 | foreach ($toolList as $tool) { |
5764 | - $method = 'remove' . $tool; |
|
5764 | + $method = 'remove'.$tool; |
|
5765 | 5765 | if (method_exists(get_class(), $method)) { |
5766 | 5766 | self::$method($sessionId, $courseId); |
5767 | 5767 | } |
@@ -5879,18 +5879,18 @@ discard block |
||
5879 | 5879 | } |
5880 | 5880 | } |
5881 | 5881 | |
5882 | - $message .= '<strong>' . get_lang('User') . '</strong> ' . $userInfo['complete_name'] . ' <br />'; |
|
5882 | + $message .= '<strong>'.get_lang('User').'</strong> '.$userInfo['complete_name'].' <br />'; |
|
5883 | 5883 | |
5884 | 5884 | if (!in_array($userInfo['status'], array(DRH)) && !api_is_platform_admin_by_id($userInfo['user_id'])) { |
5885 | - $message .= get_lang('UserMustHaveTheDrhRole') . '<br />'; |
|
5885 | + $message .= get_lang('UserMustHaveTheDrhRole').'<br />'; |
|
5886 | 5886 | continue; |
5887 | 5887 | } |
5888 | 5888 | |
5889 | 5889 | if (!empty($sessionList)) { |
5890 | - $message .= '<strong>' . get_lang('Sessions') . ':</strong> <br />'; |
|
5891 | - $message .= implode(', ', $sessionList) . '<br /><br />'; |
|
5890 | + $message .= '<strong>'.get_lang('Sessions').':</strong> <br />'; |
|
5891 | + $message .= implode(', ', $sessionList).'<br /><br />'; |
|
5892 | 5892 | } else { |
5893 | - $message .= get_lang('NoSessionProvided') . ' <br /><br />'; |
|
5893 | + $message .= get_lang('NoSessionProvided').' <br /><br />'; |
|
5894 | 5894 | } |
5895 | 5895 | } |
5896 | 5896 | } |
@@ -6070,8 +6070,8 @@ discard block |
||
6070 | 6070 | |
6071 | 6071 | $firstAccess = api_strtotime($courseAccess['login_course_date'], 'UTC'); |
6072 | 6072 | |
6073 | - $endDateInSeconds = $firstAccess + $duration*24*60*60; |
|
6074 | - $leftDays = round(($endDateInSeconds- $currentTime) / 60 / 60 / 24); |
|
6073 | + $endDateInSeconds = $firstAccess + $duration * 24 * 60 * 60; |
|
6074 | + $leftDays = round(($endDateInSeconds - $currentTime) / 60 / 60 / 24); |
|
6075 | 6075 | |
6076 | 6076 | return $leftDays; |
6077 | 6077 | } |
@@ -6363,7 +6363,7 @@ discard block |
||
6363 | 6363 | FROM $table scu |
6364 | 6364 | INNER JOIN $tableUser u |
6365 | 6365 | ON scu.user_id = u.id |
6366 | - WHERE scu.session_id = " . intval($sessionId) ." |
|
6366 | + WHERE scu.session_id = ".intval($sessionId)." |
|
6367 | 6367 | GROUP BY u.id"; |
6368 | 6368 | |
6369 | 6369 | $result = Database::query($sql); |
@@ -6401,7 +6401,7 @@ discard block |
||
6401 | 6401 | $sfTable = Database::get_main_table(TABLE_EXTRA_FIELD); |
6402 | 6402 | $sfvTable = Database::get_main_table(TABLE_EXTRA_FIELD_VALUES); |
6403 | 6403 | // Join session field and session field values tables |
6404 | - $joinTable = $sfTable . ' sf INNER JOIN ' . $sfvTable . ' sfv ON sf.id = sfv.field_id'; |
|
6404 | + $joinTable = $sfTable.' sf INNER JOIN '.$sfvTable.' sfv ON sf.id = sfv.field_id'; |
|
6405 | 6405 | $fieldsArray = array(); |
6406 | 6406 | foreach ($extraFields as $field) { |
6407 | 6407 | $fieldsArray[] = Database::escape_string($field); |
@@ -6444,14 +6444,14 @@ discard block |
||
6444 | 6444 | for ($i = 1; $i < count($fieldsArray); $i++) { |
6445 | 6445 | $whereParams .= ', ?'; |
6446 | 6446 | } |
6447 | - $whereFieldVariables = ' variable IN ( ' . $whereParams .' )'; |
|
6448 | - $whereFieldIds = 'field_id IN ( ' . $whereParams . ' )'; |
|
6447 | + $whereFieldVariables = ' variable IN ( '.$whereParams.' )'; |
|
6448 | + $whereFieldIds = 'field_id IN ( '.$whereParams.' )'; |
|
6449 | 6449 | } |
6450 | 6450 | // Get session fields |
6451 | 6451 | $extraField = new ExtraFieldModel('session'); |
6452 | 6452 | $questionMarks = substr(str_repeat('?, ', count($fieldsArray)), 0, -2); |
6453 | 6453 | $fieldsList = $extraField->get_all(array( |
6454 | - ' variable IN ( ' . $questionMarks . ' )' => $fieldsArray, |
|
6454 | + ' variable IN ( '.$questionMarks.' )' => $fieldsArray, |
|
6455 | 6455 | )); |
6456 | 6456 | // Index session fields |
6457 | 6457 | foreach ($fieldsList as $field) { |
@@ -6460,7 +6460,7 @@ discard block |
||
6460 | 6460 | // Get session field values |
6461 | 6461 | $extra = new ExtraFieldValue('session'); |
6462 | 6462 | $questionMarksFields = substr(str_repeat('?, ', count($fields)), 0, -2); |
6463 | - $sessionFieldValueList = $extra->get_all(array ('where' => array('field_id IN ( ' . $questionMarksFields . ' )' => array_keys($fields)))); |
|
6463 | + $sessionFieldValueList = $extra->get_all(array('where' => array('field_id IN ( '.$questionMarksFields.' )' => array_keys($fields)))); |
|
6464 | 6464 | // Add session fields values to session list |
6465 | 6465 | foreach ($sessionList as $id => &$session) { |
6466 | 6466 | foreach ($sessionFieldValueList as $sessionFieldValue) { |
@@ -6513,7 +6513,7 @@ discard block |
||
6513 | 6513 | // Check the result |
6514 | 6514 | if ($result < 1) { |
6515 | 6515 | // If not found any result, update error message |
6516 | - $errorResult['errorMessage'] = 'Not found any session category name ' . $categoryName; |
|
6516 | + $errorResult['errorMessage'] = 'Not found any session category name '.$categoryName; |
|
6517 | 6517 | } elseif (count($result) > 1 && !$force) { |
6518 | 6518 | // If found more than one result and force is disabled, update error message |
6519 | 6519 | $errorResult['errorMessage'] = 'Found many session categories'; |
@@ -6572,7 +6572,7 @@ discard block |
||
6572 | 6572 | // Check if session list query had result |
6573 | 6573 | if (!empty($sessionList)) { |
6574 | 6574 | // implode all session id |
6575 | - $sessionIdsString = '(' . implode(', ', array_keys($sessionList)) . ')'; |
|
6575 | + $sessionIdsString = '('.implode(', ', array_keys($sessionList)).')'; |
|
6576 | 6576 | // Get all field variables |
6577 | 6577 | $sessionFieldList = Database::select( |
6578 | 6578 | 'id, variable', |
@@ -6659,7 +6659,7 @@ discard block |
||
6659 | 6659 | return $sessionList; |
6660 | 6660 | } else { |
6661 | 6661 | // Not found result, update error message |
6662 | - $errorResult['errorMessage'] = 'Not found any session for session category id ' . $sessionCategoryId; |
|
6662 | + $errorResult['errorMessage'] = 'Not found any session for session category id '.$sessionCategoryId; |
|
6663 | 6663 | } |
6664 | 6664 | } |
6665 | 6665 | |
@@ -6763,7 +6763,7 @@ discard block |
||
6763 | 6763 | |
6764 | 6764 | $sessionExtraField = new ExtraFieldModel('session'); |
6765 | 6765 | $fieldList = $sessionExtraField->get_all(array( |
6766 | - "variable IN ( " . implode(", ", $variablePlaceHolders) . " ) " => $variables, |
|
6766 | + "variable IN ( ".implode(", ", $variablePlaceHolders)." ) " => $variables, |
|
6767 | 6767 | )); |
6768 | 6768 | |
6769 | 6769 | $fields = array(); |
@@ -6777,7 +6777,7 @@ discard block |
||
6777 | 6777 | $extra = new ExtraFieldValue('session'); |
6778 | 6778 | $sessionFieldValueList = $extra->get_all( |
6779 | 6779 | array( |
6780 | - "field_id IN ( " . implode(", ", $variablePlaceHolders) . " )" => array_keys($fields), |
|
6780 | + "field_id IN ( ".implode(", ", $variablePlaceHolders)." )" => array_keys($fields), |
|
6781 | 6781 | ) |
6782 | 6782 | ); |
6783 | 6783 | |
@@ -6849,7 +6849,7 @@ discard block |
||
6849 | 6849 | INNER JOIN $sessionUserTable sru |
6850 | 6850 | ON s.id = sru.id_session |
6851 | 6851 | WHERE |
6852 | - (sru.id_user IN (" . implode(', ', $userIdList) . ") |
|
6852 | + (sru.id_user IN (".implode(', ', $userIdList).") |
|
6853 | 6853 | AND sru.relation_type = 0 |
6854 | 6854 | )"; |
6855 | 6855 | |
@@ -6865,7 +6865,7 @@ discard block |
||
6865 | 6865 | WHERE |
6866 | 6866 | srau.access_url_id = $accessUrlId |
6867 | 6867 | AND ( |
6868 | - sru.id_user IN (" . implode(', ', $userIdList) . ") |
|
6868 | + sru.id_user IN (".implode(', ', $userIdList).") |
|
6869 | 6869 | AND sru.relation_type = 0 |
6870 | 6870 | )"; |
6871 | 6871 | } |
@@ -7085,7 +7085,7 @@ discard block |
||
7085 | 7085 | get_lang('CoachName'), |
7086 | 7086 | $coachInfo ? [$coachInfo['id'] => $coachInfo['complete_name_with_username']] : [], |
7087 | 7087 | [ |
7088 | - 'url' => api_get_path(WEB_AJAX_PATH) . 'session.ajax.php?a=search_general_coach', |
|
7088 | + 'url' => api_get_path(WEB_AJAX_PATH).'session.ajax.php?a=search_general_coach', |
|
7089 | 7089 | 'width' => '100%', |
7090 | 7090 | ] |
7091 | 7091 | ); |
@@ -7096,7 +7096,7 @@ discard block |
||
7096 | 7096 | $form->addHtml('<div id="ajax_list_coachs"></div>'); |
7097 | 7097 | |
7098 | 7098 | $form->addButtonAdvancedSettings('advanced_params'); |
7099 | - $form->addElement('html','<div id="advanced_params_options" style="display:none">'); |
|
7099 | + $form->addElement('html', '<div id="advanced_params_options" style="display:none">'); |
|
7100 | 7100 | |
7101 | 7101 | $form->addSelect( |
7102 | 7102 | 'session_category', |
@@ -7268,16 +7268,16 @@ discard block |
||
7268 | 7268 | if (api_is_session_admin() && |
7269 | 7269 | api_get_setting('allow_session_admins_to_see_all_sessions') == 'false' |
7270 | 7270 | ) { |
7271 | - $where.=" WHERE s.session_admin_id = $user_id "; |
|
7271 | + $where .= " WHERE s.session_admin_id = $user_id "; |
|
7272 | 7272 | } |
7273 | 7273 | |
7274 | 7274 | if (!empty($options['where'])) { |
7275 | 7275 | $options['where'] = str_replace('course_title', 'c.title', $options['where']); |
7276 | - $options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
|
7276 | + $options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
|
7277 | 7277 | |
7278 | 7278 | $options['where'] = str_replace( |
7279 | 7279 | array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
7280 | - array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
|
7280 | + array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 ") |
|
7281 | 7281 | , $options['where'] |
7282 | 7282 | ); |
7283 | 7283 | |
@@ -7319,10 +7319,10 @@ discard block |
||
7319 | 7319 | $where "; |
7320 | 7320 | |
7321 | 7321 | if (api_is_multiple_url_enabled()) { |
7322 | - $table_access_url_rel_session= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
7322 | + $table_access_url_rel_session = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
7323 | 7323 | $access_url_id = api_get_current_access_url_id(); |
7324 | 7324 | if ($access_url_id != -1) { |
7325 | - $where.= " AND ar.access_url_id = $access_url_id "; |
|
7325 | + $where .= " AND ar.access_url_id = $access_url_id "; |
|
7326 | 7326 | |
7327 | 7327 | $query_rows = "SELECT count(*) as total_rows |
7328 | 7328 | FROM $tbl_session s |
@@ -7367,12 +7367,12 @@ discard block |
||
7367 | 7367 | //get_lang('CourseTitle'), |
7368 | 7368 | get_lang('Visibility'), |
7369 | 7369 | ); |
7370 | - $column_model = array ( |
|
7371 | - array('name'=>'name', 'index'=>'s.name', 'width'=>'160', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('sopt' => $operators)), |
|
7372 | - array('name'=>'category_name', 'index'=>'category_name', 'width'=>'40', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('sopt' => $operators)), |
|
7373 | - array('name'=>'display_start_date', 'index'=>'display_start_date', 'width'=>'50', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('dataInit' => 'date_pick_today', 'sopt' => $date_operators)), |
|
7374 | - array('name'=>'display_end_date', 'index'=>'display_end_date', 'width'=>'50', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('dataInit' => 'date_pick_one_month', 'sopt' => $date_operators)), |
|
7375 | - array('name'=>'visibility', 'index'=>'visibility', 'width'=>'40', 'align'=>'left', 'search' => 'false'), |
|
7370 | + $column_model = array( |
|
7371 | + array('name'=>'name', 'index'=>'s.name', 'width'=>'160', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('sopt' => $operators)), |
|
7372 | + array('name'=>'category_name', 'index'=>'category_name', 'width'=>'40', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('sopt' => $operators)), |
|
7373 | + array('name'=>'display_start_date', 'index'=>'display_start_date', 'width'=>'50', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('dataInit' => 'date_pick_today', 'sopt' => $date_operators)), |
|
7374 | + array('name'=>'display_end_date', 'index'=>'display_end_date', 'width'=>'50', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('dataInit' => 'date_pick_one_month', 'sopt' => $date_operators)), |
|
7375 | + array('name'=>'visibility', 'index'=>'visibility', 'width'=>'40', 'align'=>'left', 'search' => 'false'), |
|
7376 | 7376 | ); |
7377 | 7377 | break; |
7378 | 7378 | case 'complete': |
@@ -7385,12 +7385,12 @@ discard block |
||
7385 | 7385 | get_lang('Visibility'), |
7386 | 7386 | get_lang('CourseTitle'), |
7387 | 7387 | ); |
7388 | - $column_model = array ( |
|
7389 | - array('name'=>'name', 'index'=>'s.name', 'width'=>'200', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('sopt' => $operators)), |
|
7390 | - array('name'=>'display_start_date', 'index'=>'display_start_date', 'width'=>'70', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('dataInit' => 'date_pick_today', 'sopt' => $date_operators)), |
|
7391 | - array('name'=>'display_end_date', 'index'=>'display_end_date', 'width'=>'70', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('dataInit' => 'date_pick_one_month', 'sopt' => $date_operators)), |
|
7392 | - array('name'=>'coach_name', 'index'=>'coach_name', 'width'=>'70', 'align'=>'left', 'search' => 'false', 'searchoptions' => array('sopt' => $operators)), |
|
7393 | - array('name'=>'session_active', 'index'=>'session_active', 'width'=>'25', 'align'=>'left', 'search' => 'true', 'stype'=>'select', |
|
7388 | + $column_model = array( |
|
7389 | + array('name'=>'name', 'index'=>'s.name', 'width'=>'200', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('sopt' => $operators)), |
|
7390 | + array('name'=>'display_start_date', 'index'=>'display_start_date', 'width'=>'70', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('dataInit' => 'date_pick_today', 'sopt' => $date_operators)), |
|
7391 | + array('name'=>'display_end_date', 'index'=>'display_end_date', 'width'=>'70', 'align'=>'left', 'search' => 'true', 'searchoptions' => array('dataInit' => 'date_pick_one_month', 'sopt' => $date_operators)), |
|
7392 | + array('name'=>'coach_name', 'index'=>'coach_name', 'width'=>'70', 'align'=>'left', 'search' => 'false', 'searchoptions' => array('sopt' => $operators)), |
|
7393 | + array('name'=>'session_active', 'index'=>'session_active', 'width'=>'25', 'align'=>'left', 'search' => 'true', 'stype'=>'select', |
|
7394 | 7394 | // for the bottom bar |
7395 | 7395 | 'searchoptions' => array( |
7396 | 7396 | 'defaultValue' => '1', |
@@ -7398,8 +7398,8 @@ discard block |
||
7398 | 7398 | // for the top bar |
7399 | 7399 | 'editoptions' => array('value' => '" ":'.get_lang('All').';1:'.get_lang('Active').';0:'.get_lang('Inactive')), |
7400 | 7400 | ), |
7401 | - array('name'=>'visibility', 'index'=>'visibility', 'width'=>'40', 'align'=>'left', 'search' => 'false'), |
|
7402 | - array('name'=>'course_title', 'index'=>'course_title', 'width'=>'50', 'hidden' => 'true', 'search' => 'true', 'searchoptions' => array('searchhidden' =>'true','sopt' => $operators)), |
|
7401 | + array('name'=>'visibility', 'index'=>'visibility', 'width'=>'40', 'align'=>'left', 'search' => 'false'), |
|
7402 | + array('name'=>'course_title', 'index'=>'course_title', 'width'=>'50', 'hidden' => 'true', 'search' => 'true', 'searchoptions' => array('searchhidden' =>'true', 'sopt' => $operators)), |
|
7403 | 7403 | ); |
7404 | 7404 | break; |
7405 | 7405 | } |
@@ -7408,14 +7408,14 @@ discard block |
||
7408 | 7408 | $session_field = new ExtraFieldModel('session'); |
7409 | 7409 | $rules = $session_field->getRules($columns, $column_model); |
7410 | 7410 | |
7411 | - $column_model[] = array('name'=>'actions', 'index'=>'actions', 'width'=>'80', 'align'=>'left','formatter'=>'action_formatter','sortable'=>'false', 'search' => 'false'); |
|
7411 | + $column_model[] = array('name'=>'actions', 'index'=>'actions', 'width'=>'80', 'align'=>'left', 'formatter'=>'action_formatter', 'sortable'=>'false', 'search' => 'false'); |
|
7412 | 7412 | $columns[] = get_lang('Actions'); |
7413 | 7413 | |
7414 | 7414 | foreach ($column_model as $col_model) { |
7415 | 7415 | $simple_column_name[] = $col_model['name']; |
7416 | 7416 | } |
7417 | 7417 | |
7418 | - $return_array = array( |
|
7418 | + $return_array = array( |
|
7419 | 7419 | 'columns' => $columns, |
7420 | 7420 | 'column_model' => $column_model, |
7421 | 7421 | 'rules' => $rules, |
@@ -7504,7 +7504,7 @@ discard block |
||
7504 | 7504 | if (api_is_session_admin() && |
7505 | 7505 | api_get_setting('allow_session_admins_to_manage_all_sessions') == 'false' |
7506 | 7506 | ) { |
7507 | - $where.=" AND s.session_admin_id = $user_id "; |
|
7507 | + $where .= " AND s.session_admin_id = $user_id "; |
|
7508 | 7508 | } |
7509 | 7509 | } |
7510 | 7510 | |
@@ -7586,11 +7586,11 @@ discard block |
||
7586 | 7586 | } |
7587 | 7587 | $options['where'] = str_replace('course_title', 'c.title', $options['where']); |
7588 | 7588 | |
7589 | - $options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
|
7589 | + $options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
|
7590 | 7590 | |
7591 | 7591 | $options['where'] = str_replace( |
7592 | 7592 | array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
7593 | - array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
|
7593 | + array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 ") |
|
7594 | 7594 | , $options['where'] |
7595 | 7595 | ); |
7596 | 7596 | |
@@ -7625,10 +7625,10 @@ discard block |
||
7625 | 7625 | $where; |
7626 | 7626 | |
7627 | 7627 | if (api_is_multiple_url_enabled()) { |
7628 | - $table_access_url_rel_session= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
7628 | + $table_access_url_rel_session = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
7629 | 7629 | $access_url_id = api_get_current_access_url_id(); |
7630 | 7630 | if ($access_url_id != -1) { |
7631 | - $where.= " AND ar.access_url_id = $access_url_id "; |
|
7631 | + $where .= " AND ar.access_url_id = $access_url_id "; |
|
7632 | 7632 | $query = "$select |
7633 | 7633 | FROM $tbl_session s |
7634 | 7634 | LEFT JOIN $tbl_session_field_values fv ON (fv.session_id = s.id) |
@@ -7652,7 +7652,7 @@ discard block |
||
7652 | 7652 | $formatted_sessions = array(); |
7653 | 7653 | |
7654 | 7654 | if (Database::num_rows($result)) { |
7655 | - $sessions = Database::store_result($result, 'ASSOC'); |
|
7655 | + $sessions = Database::store_result($result, 'ASSOC'); |
|
7656 | 7656 | foreach ($sessions as $session) { |
7657 | 7657 | $session_id = $session['id']; |
7658 | 7658 | $session['name'] = Display::url($session['name'], "resume_session.php?id_session=".$session['id']); |
@@ -7667,14 +7667,14 @@ discard block |
||
7667 | 7667 | |
7668 | 7668 | switch ($session['visibility']) { |
7669 | 7669 | case SESSION_VISIBLE_READ_ONLY: //1 |
7670 | - $session['visibility'] = get_lang('ReadOnly'); |
|
7670 | + $session['visibility'] = get_lang('ReadOnly'); |
|
7671 | 7671 | break; |
7672 | 7672 | case SESSION_VISIBLE: //2 |
7673 | 7673 | case SESSION_AVAILABLE: //4 |
7674 | - $session['visibility'] = get_lang('Visible'); |
|
7674 | + $session['visibility'] = get_lang('Visible'); |
|
7675 | 7675 | break; |
7676 | 7676 | case SESSION_INVISIBLE: //3 |
7677 | - $session['visibility'] = api_ucfirst(get_lang('Invisible')); |
|
7677 | + $session['visibility'] = api_ucfirst(get_lang('Invisible')); |
|
7678 | 7678 | break; |
7679 | 7679 | } |
7680 | 7680 | |
@@ -7750,7 +7750,7 @@ discard block |
||
7750 | 7750 | if (empty($session)) { |
7751 | 7751 | return false; |
7752 | 7752 | } |
7753 | - return api_get_path(WEB_CODE_PATH) . 'session/resume_session.php?id_session=' . $id; |
|
7753 | + return api_get_path(WEB_CODE_PATH).'session/resume_session.php?id_session='.$id; |
|
7754 | 7754 | } |
7755 | 7755 | |
7756 | 7756 | /** |
@@ -7768,7 +7768,7 @@ discard block |
||
7768 | 7768 | return false; |
7769 | 7769 | } |
7770 | 7770 | if (empty($courseId)) { |
7771 | - return api_get_path(WEB_CODE_PATH) . 'session/index.php?session_id=' . $id; |
|
7771 | + return api_get_path(WEB_CODE_PATH).'session/index.php?session_id='.$id; |
|
7772 | 7772 | } else { |
7773 | 7773 | $courseInfo = api_get_course_info_by_id($courseId); |
7774 | 7774 | if ($courseInfo) { |
@@ -7979,7 +7979,7 @@ discard block |
||
7979 | 7979 | // sort $listCat by catSessionName |
7980 | 7980 | usort($listCat, 'self::compareBySessionName'); |
7981 | 7981 | // in each catSession sort sessionList by sessionName |
7982 | - foreach($listCat as $i => $listCatSessionInfo) { |
|
7982 | + foreach ($listCat as $i => $listCatSessionInfo) { |
|
7983 | 7983 | $listSessionList = $listCatSessionInfo['sessionList']; |
7984 | 7984 | usort($listSessionList, 'self::compareCatSessionInfo'); |
7985 | 7985 | $listCat[$i]['sessionList'] = $listSessionList; |
@@ -7994,8 +7994,8 @@ discard block |
||
7994 | 7994 | ); |
7995 | 7995 | |
7996 | 7996 | $userCatId = intval($userCatId); |
7997 | - $listResults[$userCatId]['courseInUserCategoryId'] = $userCatId; |
|
7998 | - $listResults[$userCatId]['courseInUserCategoryTitle'] = $userCatTitle; |
|
7997 | + $listResults[$userCatId]['courseInUserCategoryId'] = $userCatId; |
|
7998 | + $listResults[$userCatId]['courseInUserCategoryTitle'] = $userCatTitle; |
|
7999 | 7999 | $listResults[$userCatId]['courseInUserCatList'][] = $listOneCourse; |
8000 | 8000 | } |
8001 | 8001 | |
@@ -8021,7 +8021,7 @@ discard block |
||
8021 | 8021 | { |
8022 | 8022 | if ($listA['sessionName'] == $listB['sessionName']) { |
8023 | 8023 | return 0; |
8024 | - } else if($listA['sessionName'] > $listB['sessionName']) { |
|
8024 | + } else if ($listA['sessionName'] > $listB['sessionName']) { |
|
8025 | 8025 | return 1; |
8026 | 8026 | } else { |
8027 | 8027 | return -1; |
@@ -8041,7 +8041,7 @@ discard block |
||
8041 | 8041 | return 1; |
8042 | 8042 | } else if ($listA['catSessionName'] == $listB['catSessionName']) { |
8043 | 8043 | return 0; |
8044 | - } else if($listA['catSessionName'] > $listB['catSessionName']) { |
|
8044 | + } else if ($listA['catSessionName'] > $listB['catSessionName']) { |
|
8045 | 8045 | return 1; |
8046 | 8046 | } else { |
8047 | 8047 | return -1; |
@@ -8057,7 +8057,7 @@ discard block |
||
8057 | 8057 | { |
8058 | 8058 | if ($listA['courseInUserCategoryTitle'] == $listB['courseInUserCategoryTitle']) { |
8059 | 8059 | return 0; |
8060 | - } else if($listA['courseInUserCategoryTitle'] > $listB['courseInUserCategoryTitle']) { |
|
8060 | + } else if ($listA['courseInUserCategoryTitle'] > $listB['courseInUserCategoryTitle']) { |
|
8061 | 8061 | return 1; |
8062 | 8062 | } else { |
8063 | 8063 | return -1; |
@@ -8073,7 +8073,7 @@ discard block |
||
8073 | 8073 | { |
8074 | 8074 | if ($listA['title'] == $listB['title']) { |
8075 | 8075 | return 0; |
8076 | - } else if($listA['title'] > $listB['title']) { |
|
8076 | + } else if ($listA['title'] > $listB['title']) { |
|
8077 | 8077 | return 1; |
8078 | 8078 | } else { |
8079 | 8079 | return -1; |
@@ -8119,8 +8119,8 @@ discard block |
||
8119 | 8119 | |
8120 | 8120 | $marginShift = 20; |
8121 | 8121 | if ($catSessionName != '') { |
8122 | - $htmlCatSessions .= '<div style="margin-left:'.$marginShift.'px;">' . |
|
8123 | - CourseManager::course_item_html($listParamsCatSession, true) . '</div>'; |
|
8122 | + $htmlCatSessions .= '<div style="margin-left:'.$marginShift.'px;">'. |
|
8123 | + CourseManager::course_item_html($listParamsCatSession, true).'</div>'; |
|
8124 | 8124 | $marginShift = 40; |
8125 | 8125 | } |
8126 | 8126 | |
@@ -8188,14 +8188,14 @@ discard block |
||
8188 | 8188 | |
8189 | 8189 | if ($response) { |
8190 | 8190 | |
8191 | - $urlToRedirect = api_get_path(WEB_CODE_PATH) . 'session/index.php?session_id=' . $sessionId; |
|
8191 | + $urlToRedirect = api_get_path(WEB_CODE_PATH).'session/index.php?session_id='.$sessionId; |
|
8192 | 8192 | |
8193 | 8193 | if (!empty($onlyOneCourseSessionToRedirect)) { |
8194 | 8194 | |
8195 | - $urlToRedirect = api_get_path(WEB_PATH) . 'courses/' . $onlyOneCourseSessionToRedirect . '/index.php?id_session=' . $sessionId; |
|
8195 | + $urlToRedirect = api_get_path(WEB_PATH).'courses/'.$onlyOneCourseSessionToRedirect.'/index.php?id_session='.$sessionId; |
|
8196 | 8196 | } |
8197 | 8197 | |
8198 | - header('Location: ' . $urlToRedirect); |
|
8198 | + header('Location: '.$urlToRedirect); |
|
8199 | 8199 | exit; |
8200 | 8200 | } |
8201 | 8201 | } |
@@ -23,7 +23,7 @@ |
||
23 | 23 | if (isset($condition['conditional_function']) && $condition['conditional_function']($user) == false) { |
24 | 24 | $_SESSION['conditional_login']['uid'] = $user['user_id']; |
25 | 25 | $_SESSION['conditional_login']['can_login'] = false; |
26 | - header("Location:". $condition['url']); |
|
26 | + header("Location:".$condition['url']); |
|
27 | 27 | exit(); |
28 | 28 | } |
29 | 29 | } |
@@ -47,7 +47,7 @@ discard block |
||
47 | 47 | if ($height >= $max_size_for_picture) { |
48 | 48 | // scale width |
49 | 49 | $new_width = round($width * ($max_size_for_picture / $height)); |
50 | - $this->image_wrapper->resize($new_width, $max_size_for_picture, 0); |
|
50 | + $this->image_wrapper->resize($new_width, $max_size_for_picture, 0); |
|
51 | 51 | } |
52 | 52 | } |
53 | 53 | } |
@@ -149,7 +149,7 @@ discard block |
||
149 | 149 | |
150 | 150 | public function __construct($path) |
151 | 151 | { |
152 | - parent::__construct($path); |
|
152 | + parent::__construct($path); |
|
153 | 153 | } |
154 | 154 | |
155 | 155 | public function set_image_wrapper() |
@@ -184,19 +184,19 @@ discard block |
||
184 | 184 | } |
185 | 185 | } |
186 | 186 | |
187 | - public function get_image_size() |
|
187 | + public function get_image_size() |
|
188 | 188 | { |
189 | - $imagesize = array('width'=>0,'height'=>0); |
|
190 | - if ($this->image_validated) { |
|
189 | + $imagesize = array('width'=>0,'height'=>0); |
|
190 | + if ($this->image_validated) { |
|
191 | 191 | $imagesize = $this->image->getImageGeometry(); |
192 | - } |
|
193 | - return $imagesize; |
|
194 | - } |
|
192 | + } |
|
193 | + return $imagesize; |
|
194 | + } |
|
195 | 195 | |
196 | - //@todo implement border logic case for Imagick |
|
197 | - public function resize($thumbw, $thumbh, $border, $specific_size = false) |
|
196 | + //@todo implement border logic case for Imagick |
|
197 | + public function resize($thumbw, $thumbh, $border, $specific_size = false) |
|
198 | 198 | { |
199 | - if (!$this->image_validated) return false; |
|
199 | + if (!$this->image_validated) return false; |
|
200 | 200 | |
201 | 201 | if ($specific_size) { |
202 | 202 | $width = $thumbw; |
@@ -206,10 +206,10 @@ discard block |
||
206 | 206 | $width = (int)($this->width * $scale); |
207 | 207 | $height = (int)($this->height * $scale); |
208 | 208 | } |
209 | - $result = $this->image->resizeImage($width, $height, $this->filter, 1); |
|
210 | - $this->width = $thumbw; |
|
211 | - $this->height = $thumbh; |
|
212 | - } |
|
209 | + $result = $this->image->resizeImage($width, $height, $this->filter, 1); |
|
210 | + $this->width = $thumbw; |
|
211 | + $this->height = $thumbh; |
|
212 | + } |
|
213 | 213 | |
214 | 214 | /** |
215 | 215 | * @author José Loguercio <[email protected]> |
@@ -224,8 +224,8 @@ discard block |
||
224 | 224 | public function crop($x, $y, $width, $height, $src_width, $src_height) { |
225 | 225 | if (!$this->image_validated) return false; |
226 | 226 | $this->image->cropimage($width, $height, $x, $y); |
227 | - $this->width = $width; |
|
228 | - $this->height = $height; |
|
227 | + $this->width = $width; |
|
228 | + $this->height = $height; |
|
229 | 229 | } |
230 | 230 | |
231 | 231 | public function send_image($file = '', $compress = -1, $convert_file_to = null) |
@@ -235,35 +235,35 @@ discard block |
||
235 | 235 | if (!empty($convert_file_to) && in_array($convert_file_to, $this->allowed_extensions)) { |
236 | 236 | $type = $convert_file_to; |
237 | 237 | } |
238 | - switch ($type) { |
|
239 | - case 'jpeg': |
|
240 | - case 'jpg': |
|
241 | - if (!$file) header("Content-type: image/jpeg"); |
|
242 | - break; |
|
243 | - case 'png': |
|
244 | - if (!$file) header("Content-type: image/png"); |
|
245 | - break; |
|
246 | - case 'gif': |
|
247 | - if (!$file) header("Content-type: image/gif"); |
|
248 | - break; |
|
249 | - } |
|
250 | - $result = false; |
|
251 | - try { |
|
252 | - $result = $this->image->writeImage($file); |
|
253 | - } catch(ImagickException $e) { |
|
238 | + switch ($type) { |
|
239 | + case 'jpeg': |
|
240 | + case 'jpg': |
|
241 | + if (!$file) header("Content-type: image/jpeg"); |
|
242 | + break; |
|
243 | + case 'png': |
|
244 | + if (!$file) header("Content-type: image/png"); |
|
245 | + break; |
|
246 | + case 'gif': |
|
247 | + if (!$file) header("Content-type: image/gif"); |
|
248 | + break; |
|
249 | + } |
|
250 | + $result = false; |
|
251 | + try { |
|
252 | + $result = $this->image->writeImage($file); |
|
253 | + } catch(ImagickException $e) { |
|
254 | 254 | if ($this->debug) error_log($e->getMessage()); |
255 | 255 | } |
256 | 256 | |
257 | - if (!$file) { |
|
258 | - echo $this->image; |
|
259 | - $this->image->clear(); |
|
257 | + if (!$file) { |
|
258 | + echo $this->image; |
|
259 | + $this->image->clear(); |
|
260 | 260 | $this->image->destroy(); |
261 | - } else { |
|
262 | - $this->image->clear(); |
|
261 | + } else { |
|
262 | + $this->image->clear(); |
|
263 | 263 | $this->image->destroy(); |
264 | - return $result; |
|
265 | - } |
|
266 | - } |
|
264 | + return $result; |
|
265 | + } |
|
266 | + } |
|
267 | 267 | |
268 | 268 | } |
269 | 269 | |
@@ -285,21 +285,21 @@ discard block |
||
285 | 285 | $this->fill_image_info(); |
286 | 286 | |
287 | 287 | switch ($this->type) { |
288 | - case 0: |
|
289 | - $handler = false; |
|
290 | - break; |
|
291 | - case 1 : |
|
288 | + case 0: |
|
289 | + $handler = false; |
|
290 | + break; |
|
291 | + case 1 : |
|
292 | 292 | $handler = @imagecreatefromgif($this->path); |
293 | 293 | $this->type = 'gif'; |
294 | 294 | break; |
295 | - case 2 : |
|
295 | + case 2 : |
|
296 | 296 | $handler = @imagecreatefromjpeg($this->path); |
297 | 297 | $this->type = 'jpg'; |
298 | 298 | break; |
299 | - case 3 : |
|
300 | - $handler = @imagecreatefrompng($this->path); |
|
301 | - $this->type = 'png'; |
|
302 | - break; |
|
299 | + case 3 : |
|
300 | + $handler = @imagecreatefrompng($this->path); |
|
301 | + $this->type = 'png'; |
|
302 | + break; |
|
303 | 303 | } |
304 | 304 | if ($handler) { |
305 | 305 | $this->image_validated = true; |
@@ -313,29 +313,29 @@ discard block |
||
313 | 313 | { |
314 | 314 | $return_array = array('width'=>0,'height'=>0); |
315 | 315 | if ($this->image_validated) { |
316 | - $return_array = array('width'=>$this->width,'height'=>$this->height); |
|
316 | + $return_array = array('width'=>$this->width,'height'=>$this->height); |
|
317 | 317 | } |
318 | 318 | return $return_array; |
319 | - } |
|
319 | + } |
|
320 | 320 | |
321 | 321 | public function fill_image_info() |
322 | 322 | { |
323 | - if (file_exists($this->path)) { |
|
324 | - $image_info = getimagesize($this->path); |
|
325 | - $this->width = $image_info[0]; |
|
326 | - $this->height = $image_info[1]; |
|
327 | - $this->type = $image_info[2]; |
|
328 | - } else { |
|
329 | - $this->width = 0; |
|
330 | - $this->height = 0; |
|
331 | - $this->type = 0; |
|
332 | - } |
|
323 | + if (file_exists($this->path)) { |
|
324 | + $image_info = getimagesize($this->path); |
|
325 | + $this->width = $image_info[0]; |
|
326 | + $this->height = $image_info[1]; |
|
327 | + $this->type = $image_info[2]; |
|
328 | + } else { |
|
329 | + $this->width = 0; |
|
330 | + $this->height = 0; |
|
331 | + $this->type = 0; |
|
332 | + } |
|
333 | 333 | } |
334 | 334 | |
335 | 335 | public function resize($thumbw, $thumbh, $border, $specific_size = false) |
336 | 336 | { |
337 | 337 | if (!$this->image_validated) return false; |
338 | - if ($border == 1) { |
|
338 | + if ($border == 1) { |
|
339 | 339 | if ($specific_size) { |
340 | 340 | $width = $thumbw; |
341 | 341 | $height = $thumbh; |
@@ -344,17 +344,17 @@ discard block |
||
344 | 344 | $width = (int)($this->width * $scale); |
345 | 345 | $height = (int)($this->height * $scale); |
346 | 346 | } |
347 | - $deltaw = (int)(($thumbw - $width) / 2); |
|
348 | - $deltah = (int)(($thumbh - $height) / 2); |
|
349 | - $dst_img = @ImageCreateTrueColor($thumbw, $thumbh); |
|
350 | - @imagealphablending($dst_img, false); |
|
351 | - @imagesavealpha($dst_img, true); |
|
352 | - if (!empty($this->color)) { |
|
353 | - @imagefill($dst_img, 0, 0, $this->color); |
|
354 | - } |
|
355 | - $this->width = $thumbw; |
|
356 | - $this->height = $thumbh; |
|
357 | - } elseif ($border == 0) { |
|
347 | + $deltaw = (int)(($thumbw - $width) / 2); |
|
348 | + $deltah = (int)(($thumbh - $height) / 2); |
|
349 | + $dst_img = @ImageCreateTrueColor($thumbw, $thumbh); |
|
350 | + @imagealphablending($dst_img, false); |
|
351 | + @imagesavealpha($dst_img, true); |
|
352 | + if (!empty($this->color)) { |
|
353 | + @imagefill($dst_img, 0, 0, $this->color); |
|
354 | + } |
|
355 | + $this->width = $thumbw; |
|
356 | + $this->height = $thumbh; |
|
357 | + } elseif ($border == 0) { |
|
358 | 358 | if ($specific_size) { |
359 | 359 | $width = $thumbw; |
360 | 360 | $height = $thumbh; |
@@ -363,19 +363,19 @@ discard block |
||
363 | 363 | $width = (int)($this->width * $scale); |
364 | 364 | $height = (int)($this->height * $scale); |
365 | 365 | } |
366 | - $deltaw = 0; |
|
367 | - $deltah = 0; |
|
368 | - $dst_img = @ImageCreateTrueColor($width, $height); |
|
369 | - @imagealphablending($dst_img, false); |
|
370 | - @imagesavealpha($dst_img, true); |
|
371 | - $this->width = $width; |
|
372 | - $this->height = $height; |
|
373 | - } |
|
374 | - $src_img = $this->bg; |
|
375 | - @ImageCopyResampled($dst_img, $src_img, $deltaw, $deltah, 0, 0, $width, $height, ImageSX($src_img), ImageSY($src_img)); |
|
376 | - $this->bg = $dst_img; |
|
377 | - @imagedestroy($src_img); |
|
378 | - } |
|
366 | + $deltaw = 0; |
|
367 | + $deltah = 0; |
|
368 | + $dst_img = @ImageCreateTrueColor($width, $height); |
|
369 | + @imagealphablending($dst_img, false); |
|
370 | + @imagesavealpha($dst_img, true); |
|
371 | + $this->width = $width; |
|
372 | + $this->height = $height; |
|
373 | + } |
|
374 | + $src_img = $this->bg; |
|
375 | + @ImageCopyResampled($dst_img, $src_img, $deltaw, $deltah, 0, 0, $width, $height, ImageSX($src_img), ImageSY($src_img)); |
|
376 | + $this->bg = $dst_img; |
|
377 | + @imagedestroy($src_img); |
|
378 | + } |
|
379 | 379 | |
380 | 380 | /** |
381 | 381 | * @author José Loguercio <[email protected]> |
@@ -389,7 +389,7 @@ discard block |
||
389 | 389 | public function crop($x, $y, $width, $height, $src_width, $src_height) { |
390 | 390 | if (!$this->image_validated) return false; |
391 | 391 | $this->width = $width; |
392 | - $this->height = $height; |
|
392 | + $this->height = $height; |
|
393 | 393 | $src = null; |
394 | 394 | $dest = @imagecreatetruecolor($width, $height); |
395 | 395 | $type = $this->type; |
@@ -400,56 +400,56 @@ discard block |
||
400 | 400 | @imagecopy($dest, $src, 0, 0, $x, $y, $src_width, $src_height); |
401 | 401 | @imagejpeg($dest, $this->path); |
402 | 402 | break; |
403 | - case 'png' : |
|
403 | + case 'png' : |
|
404 | 404 | $src = @imagecreatefrompng($this->path); |
405 | 405 | @imagecopy($dest, $src, 0, 0, $x, $y, $src_width, $src_height); |
406 | 406 | @imagepng($dest, $this->path); |
407 | 407 | break; |
408 | - case 'gif' : |
|
409 | - $src = @imagecreatefromgif($this->path); |
|
408 | + case 'gif' : |
|
409 | + $src = @imagecreatefromgif($this->path); |
|
410 | 410 | @imagecopy($dest, $src, 0, 0, $x, $y, $src_width, $src_height); |
411 | 411 | @imagegif($dest, $this->path); |
412 | - break; |
|
412 | + break; |
|
413 | 413 | default: return 0; |
414 | 414 | } |
415 | 415 | @imagedestroy($dest); |
416 | 416 | @imagedestroy($src); |
417 | 417 | } |
418 | 418 | |
419 | - public function send_image($file = '', $compress = -1, $convert_file_to = null) |
|
419 | + public function send_image($file = '', $compress = -1, $convert_file_to = null) |
|
420 | 420 | { |
421 | - if (!$this->image_validated) return false; |
|
421 | + if (!$this->image_validated) return false; |
|
422 | 422 | $compress = (int)$compress; |
423 | 423 | $type = $this->type; |
424 | 424 | if (!empty($convert_file_to) && in_array($convert_file_to, $this->allowed_extensions)) { |
425 | 425 | $type = $convert_file_to; |
426 | 426 | } |
427 | - switch ($type) { |
|
428 | - case 'jpeg': |
|
429 | - case 'jpg': |
|
430 | - if (!$file) header("Content-type: image/jpeg"); |
|
431 | - if ($compress == -1) $compress = 100; |
|
432 | - return imagejpeg($this->bg, $file, $compress); |
|
433 | - break; |
|
434 | - case 'png': |
|
435 | - if (!$file) header("Content-type: image/png"); |
|
436 | - if ($compress != -1) { |
|
437 | - @imagetruecolortopalette($this->bg, true, $compress); |
|
438 | - } |
|
439 | - return imagepng($this->bg, $file, $compress); |
|
440 | - break; |
|
441 | - case 'gif': |
|
442 | - if (!$file) header("Content-type: image/gif"); |
|
443 | - if ($compress != -1) { |
|
444 | - @imagetruecolortopalette($this->bg, true, $compress); |
|
445 | - } |
|
446 | - return imagegif($this->bg, $file, $compress); |
|
447 | - break; |
|
448 | - default: return 0; |
|
449 | - } |
|
450 | - // TODO: Occupied memory is not released, because the following fragment of code is actually dead. |
|
451 | - @imagedestroy($this->bg); |
|
452 | - } |
|
427 | + switch ($type) { |
|
428 | + case 'jpeg': |
|
429 | + case 'jpg': |
|
430 | + if (!$file) header("Content-type: image/jpeg"); |
|
431 | + if ($compress == -1) $compress = 100; |
|
432 | + return imagejpeg($this->bg, $file, $compress); |
|
433 | + break; |
|
434 | + case 'png': |
|
435 | + if (!$file) header("Content-type: image/png"); |
|
436 | + if ($compress != -1) { |
|
437 | + @imagetruecolortopalette($this->bg, true, $compress); |
|
438 | + } |
|
439 | + return imagepng($this->bg, $file, $compress); |
|
440 | + break; |
|
441 | + case 'gif': |
|
442 | + if (!$file) header("Content-type: image/gif"); |
|
443 | + if ($compress != -1) { |
|
444 | + @imagetruecolortopalette($this->bg, true, $compress); |
|
445 | + } |
|
446 | + return imagegif($this->bg, $file, $compress); |
|
447 | + break; |
|
448 | + default: return 0; |
|
449 | + } |
|
450 | + // TODO: Occupied memory is not released, because the following fragment of code is actually dead. |
|
451 | + @imagedestroy($this->bg); |
|
452 | + } |
|
453 | 453 | |
454 | 454 | /** |
455 | 455 | * Convert image to black & white |
@@ -154,7 +154,9 @@ discard block |
||
154 | 154 | |
155 | 155 | public function set_image_wrapper() |
156 | 156 | { |
157 | - if ($this->debug) error_log('Image::set_image_wrapper loaded'); |
|
157 | + if ($this->debug) { |
|
158 | + error_log('Image::set_image_wrapper loaded'); |
|
159 | + } |
|
158 | 160 | try { |
159 | 161 | if (file_exists($this->path)) { |
160 | 162 | $this->image = new Imagick($this->path); |
@@ -163,10 +165,14 @@ discard block |
||
163 | 165 | $this->fill_image_info(); //Fills height, width and type |
164 | 166 | } |
165 | 167 | } else { |
166 | - if ($this->debug) error_log('Image::image does not exist'); |
|
168 | + if ($this->debug) { |
|
169 | + error_log('Image::image does not exist'); |
|
170 | + } |
|
167 | 171 | } |
168 | 172 | } catch(ImagickException $e) { |
169 | - if ($this->debug) error_log($e->getMessage()); |
|
173 | + if ($this->debug) { |
|
174 | + error_log($e->getMessage()); |
|
175 | + } |
|
170 | 176 | } |
171 | 177 | } |
172 | 178 | |
@@ -180,7 +186,9 @@ discard block |
||
180 | 186 | |
181 | 187 | if (in_array($this->type, $this->allowed_extensions)) { |
182 | 188 | $this->image_validated = true; |
183 | - if ($this->debug) error_log('image_validated true'); |
|
189 | + if ($this->debug) { |
|
190 | + error_log('image_validated true'); |
|
191 | + } |
|
184 | 192 | } |
185 | 193 | } |
186 | 194 | |
@@ -196,7 +204,9 @@ discard block |
||
196 | 204 | //@todo implement border logic case for Imagick |
197 | 205 | public function resize($thumbw, $thumbh, $border, $specific_size = false) |
198 | 206 | { |
199 | - if (!$this->image_validated) return false; |
|
207 | + if (!$this->image_validated) { |
|
208 | + return false; |
|
209 | + } |
|
200 | 210 | |
201 | 211 | if ($specific_size) { |
202 | 212 | $width = $thumbw; |
@@ -222,7 +232,9 @@ discard block |
||
222 | 232 | */ |
223 | 233 | |
224 | 234 | public function crop($x, $y, $width, $height, $src_width, $src_height) { |
225 | - if (!$this->image_validated) return false; |
|
235 | + if (!$this->image_validated) { |
|
236 | + return false; |
|
237 | + } |
|
226 | 238 | $this->image->cropimage($width, $height, $x, $y); |
227 | 239 | $this->width = $width; |
228 | 240 | $this->height = $height; |
@@ -230,7 +242,9 @@ discard block |
||
230 | 242 | |
231 | 243 | public function send_image($file = '', $compress = -1, $convert_file_to = null) |
232 | 244 | { |
233 | - if (!$this->image_validated) return false; |
|
245 | + if (!$this->image_validated) { |
|
246 | + return false; |
|
247 | + } |
|
234 | 248 | $type = $this->type; |
235 | 249 | if (!empty($convert_file_to) && in_array($convert_file_to, $this->allowed_extensions)) { |
236 | 250 | $type = $convert_file_to; |
@@ -238,20 +252,28 @@ discard block |
||
238 | 252 | switch ($type) { |
239 | 253 | case 'jpeg': |
240 | 254 | case 'jpg': |
241 | - if (!$file) header("Content-type: image/jpeg"); |
|
255 | + if (!$file) { |
|
256 | + header("Content-type: image/jpeg"); |
|
257 | + } |
|
242 | 258 | break; |
243 | 259 | case 'png': |
244 | - if (!$file) header("Content-type: image/png"); |
|
260 | + if (!$file) { |
|
261 | + header("Content-type: image/png"); |
|
262 | + } |
|
245 | 263 | break; |
246 | 264 | case 'gif': |
247 | - if (!$file) header("Content-type: image/gif"); |
|
265 | + if (!$file) { |
|
266 | + header("Content-type: image/gif"); |
|
267 | + } |
|
248 | 268 | break; |
249 | 269 | } |
250 | 270 | $result = false; |
251 | 271 | try { |
252 | 272 | $result = $this->image->writeImage($file); |
253 | 273 | } catch(ImagickException $e) { |
254 | - if ($this->debug) error_log($e->getMessage()); |
|
274 | + if ($this->debug) { |
|
275 | + error_log($e->getMessage()); |
|
276 | + } |
|
255 | 277 | } |
256 | 278 | |
257 | 279 | if (!$file) { |
@@ -334,7 +356,9 @@ discard block |
||
334 | 356 | |
335 | 357 | public function resize($thumbw, $thumbh, $border, $specific_size = false) |
336 | 358 | { |
337 | - if (!$this->image_validated) return false; |
|
359 | + if (!$this->image_validated) { |
|
360 | + return false; |
|
361 | + } |
|
338 | 362 | if ($border == 1) { |
339 | 363 | if ($specific_size) { |
340 | 364 | $width = $thumbw; |
@@ -387,7 +411,9 @@ discard block |
||
387 | 411 | * @param int $src_height the source height of the original image |
388 | 412 | */ |
389 | 413 | public function crop($x, $y, $width, $height, $src_width, $src_height) { |
390 | - if (!$this->image_validated) return false; |
|
414 | + if (!$this->image_validated) { |
|
415 | + return false; |
|
416 | + } |
|
391 | 417 | $this->width = $width; |
392 | 418 | $this->height = $height; |
393 | 419 | $src = null; |
@@ -418,7 +444,9 @@ discard block |
||
418 | 444 | |
419 | 445 | public function send_image($file = '', $compress = -1, $convert_file_to = null) |
420 | 446 | { |
421 | - if (!$this->image_validated) return false; |
|
447 | + if (!$this->image_validated) { |
|
448 | + return false; |
|
449 | + } |
|
422 | 450 | $compress = (int)$compress; |
423 | 451 | $type = $this->type; |
424 | 452 | if (!empty($convert_file_to) && in_array($convert_file_to, $this->allowed_extensions)) { |
@@ -427,19 +455,27 @@ discard block |
||
427 | 455 | switch ($type) { |
428 | 456 | case 'jpeg': |
429 | 457 | case 'jpg': |
430 | - if (!$file) header("Content-type: image/jpeg"); |
|
431 | - if ($compress == -1) $compress = 100; |
|
458 | + if (!$file) { |
|
459 | + header("Content-type: image/jpeg"); |
|
460 | + } |
|
461 | + if ($compress == -1) { |
|
462 | + $compress = 100; |
|
463 | + } |
|
432 | 464 | return imagejpeg($this->bg, $file, $compress); |
433 | 465 | break; |
434 | 466 | case 'png': |
435 | - if (!$file) header("Content-type: image/png"); |
|
467 | + if (!$file) { |
|
468 | + header("Content-type: image/png"); |
|
469 | + } |
|
436 | 470 | if ($compress != -1) { |
437 | 471 | @imagetruecolortopalette($this->bg, true, $compress); |
438 | 472 | } |
439 | 473 | return imagepng($this->bg, $file, $compress); |
440 | 474 | break; |
441 | 475 | case 'gif': |
442 | - if (!$file) header("Content-type: image/gif"); |
|
476 | + if (!$file) { |
|
477 | + header("Content-type: image/gif"); |
|
478 | + } |
|
443 | 479 | if ($compress != -1) { |
444 | 480 | @imagetruecolortopalette($this->bg, true, $compress); |
445 | 481 | } |
@@ -456,7 +492,9 @@ discard block |
||
456 | 492 | */ |
457 | 493 | function convert2bw() |
458 | 494 | { |
459 | - if (!$this->image_validated) return false; |
|
495 | + if (!$this->image_validated) { |
|
496 | + return false; |
|
497 | + } |
|
460 | 498 | |
461 | 499 | $dest_img = imagecreatetruecolor(imagesx($this->bg), imagesy($this->bg)); |
462 | 500 | /* copy ignore the transparent color |
@@ -63,6 +63,9 @@ discard block |
||
63 | 63 | return $image; |
64 | 64 | } |
65 | 65 | |
66 | + /** |
|
67 | + * @param string $convert_file_to |
|
68 | + */ |
|
66 | 69 | public function send_image( |
67 | 70 | $file = '', |
68 | 71 | $compress = -1, |
@@ -144,6 +147,9 @@ discard block |
||
144 | 147 | public $image; |
145 | 148 | public $filter = Imagick::FILTER_LANCZOS; |
146 | 149 | |
150 | + /** |
|
151 | + * @param string $path |
|
152 | + */ |
|
147 | 153 | public function __construct($path) |
148 | 154 | { |
149 | 155 | parent::__construct($path); |
@@ -191,6 +197,10 @@ discard block |
||
191 | 197 | } |
192 | 198 | |
193 | 199 | //@todo implement border logic case for Imagick |
200 | + |
|
201 | + /** |
|
202 | + * @param integer $border |
|
203 | + */ |
|
194 | 204 | public function resize($thumbw, $thumbh, $border, $specific_size = false) |
195 | 205 | { |
196 | 206 | if (!$this->image_validated) return false; |
@@ -272,6 +282,9 @@ discard block |
||
272 | 282 | { |
273 | 283 | public $bg; |
274 | 284 | |
285 | + /** |
|
286 | + * @param string $path |
|
287 | + */ |
|
275 | 288 | function __construct($path) { |
276 | 289 | parent::__construct($path); |
277 | 290 | } |
@@ -329,6 +342,9 @@ discard block |
||
329 | 342 | } |
330 | 343 | } |
331 | 344 | |
345 | + /** |
|
346 | + * @param integer $border |
|
347 | + */ |
|
332 | 348 | public function resize($thumbw, $thumbh, $border, $specific_size = false) |
333 | 349 | { |
334 | 350 | if (!$this->image_validated) return false; |
@@ -114,7 +114,7 @@ discard block |
||
114 | 114 | return false; |
115 | 115 | } |
116 | 116 | $this->path = $path; |
117 | - $this->set_image_wrapper(); //Creates image obj |
|
117 | + $this->set_image_wrapper(); //Creates image obj |
|
118 | 118 | } |
119 | 119 | |
120 | 120 | abstract function set_image_wrapper(); |
@@ -156,7 +156,7 @@ discard block |
||
156 | 156 | if ($this->debug) error_log('Image::set_image_wrapper loaded'); |
157 | 157 | try { |
158 | 158 | if (file_exists($this->path)) { |
159 | - $this->image = new Imagick($this->path); |
|
159 | + $this->image = new Imagick($this->path); |
|
160 | 160 | |
161 | 161 | if ($this->image) { |
162 | 162 | $this->fill_image_info(); //Fills height, width and type |
@@ -164,7 +164,7 @@ discard block |
||
164 | 164 | } else { |
165 | 165 | if ($this->debug) error_log('Image::image does not exist'); |
166 | 166 | } |
167 | - } catch(ImagickException $e) { |
|
167 | + } catch (ImagickException $e) { |
|
168 | 168 | if ($this->debug) error_log($e->getMessage()); |
169 | 169 | } |
170 | 170 | } |
@@ -185,7 +185,7 @@ discard block |
||
185 | 185 | |
186 | 186 | public function get_image_size() |
187 | 187 | { |
188 | - $imagesize = array('width'=>0,'height'=>0); |
|
188 | + $imagesize = array('width'=>0, 'height'=>0); |
|
189 | 189 | if ($this->image_validated) { |
190 | 190 | $imagesize = $this->image->getImageGeometry(); |
191 | 191 | } |
@@ -202,8 +202,8 @@ discard block |
||
202 | 202 | $height = $thumbh; |
203 | 203 | } else { |
204 | 204 | $scale = ($this->width > 0 && $this->height > 0) ? min($thumbw / $this->width, $thumbh / $this->height) : 0; |
205 | - $width = (int)($this->width * $scale); |
|
206 | - $height = (int)($this->height * $scale); |
|
205 | + $width = (int) ($this->width * $scale); |
|
206 | + $height = (int) ($this->height * $scale); |
|
207 | 207 | } |
208 | 208 | $result = $this->image->resizeImage($width, $height, $this->filter, 1); |
209 | 209 | $this->width = $thumbw; |
@@ -249,7 +249,7 @@ discard block |
||
249 | 249 | $result = false; |
250 | 250 | try { |
251 | 251 | $result = $this->image->writeImage($file); |
252 | - } catch(ImagickException $e) { |
|
252 | + } catch (ImagickException $e) { |
|
253 | 253 | if ($this->debug) error_log($e->getMessage()); |
254 | 254 | } |
255 | 255 | |
@@ -310,9 +310,9 @@ discard block |
||
310 | 310 | |
311 | 311 | public function get_image_size() |
312 | 312 | { |
313 | - $return_array = array('width'=>0,'height'=>0); |
|
313 | + $return_array = array('width'=>0, 'height'=>0); |
|
314 | 314 | if ($this->image_validated) { |
315 | - $return_array = array('width'=>$this->width,'height'=>$this->height); |
|
315 | + $return_array = array('width'=>$this->width, 'height'=>$this->height); |
|
316 | 316 | } |
317 | 317 | return $return_array; |
318 | 318 | } |
@@ -320,7 +320,7 @@ discard block |
||
320 | 320 | public function fill_image_info() |
321 | 321 | { |
322 | 322 | if (file_exists($this->path)) { |
323 | - $image_info = getimagesize($this->path); |
|
323 | + $image_info = getimagesize($this->path); |
|
324 | 324 | $this->width = $image_info[0]; |
325 | 325 | $this->height = $image_info[1]; |
326 | 326 | $this->type = $image_info[2]; |
@@ -340,11 +340,11 @@ discard block |
||
340 | 340 | $height = $thumbh; |
341 | 341 | } else { |
342 | 342 | $scale = min($thumbw / $this->width, $thumbh / $this->height); |
343 | - $width = (int)($this->width * $scale); |
|
344 | - $height = (int)($this->height * $scale); |
|
343 | + $width = (int) ($this->width * $scale); |
|
344 | + $height = (int) ($this->height * $scale); |
|
345 | 345 | } |
346 | - $deltaw = (int)(($thumbw - $width) / 2); |
|
347 | - $deltah = (int)(($thumbh - $height) / 2); |
|
346 | + $deltaw = (int) (($thumbw - $width) / 2); |
|
347 | + $deltah = (int) (($thumbh - $height) / 2); |
|
348 | 348 | $dst_img = @ImageCreateTrueColor($thumbw, $thumbh); |
349 | 349 | @imagealphablending($dst_img, false); |
350 | 350 | @imagesavealpha($dst_img, true); |
@@ -359,8 +359,8 @@ discard block |
||
359 | 359 | $height = $thumbh; |
360 | 360 | } else { |
361 | 361 | $scale = ($this->width > 0 && $this->height > 0) ? min($thumbw / $this->width, $thumbh / $this->height) : 0; |
362 | - $width = (int)($this->width * $scale); |
|
363 | - $height = (int)($this->height * $scale); |
|
362 | + $width = (int) ($this->width * $scale); |
|
363 | + $height = (int) ($this->height * $scale); |
|
364 | 364 | } |
365 | 365 | $deltaw = 0; |
366 | 366 | $deltah = 0; |
@@ -418,7 +418,7 @@ discard block |
||
418 | 418 | public function send_image($file = '', $compress = -1, $convert_file_to = null) |
419 | 419 | { |
420 | 420 | if (!$this->image_validated) return false; |
421 | - $compress = (int)$compress; |
|
421 | + $compress = (int) $compress; |
|
422 | 422 | $type = $this->type; |
423 | 423 | if (!empty($convert_file_to) && in_array($convert_file_to, $this->allowed_extensions)) { |
424 | 424 | $type = $convert_file_to; |
@@ -462,11 +462,11 @@ discard block |
||
462 | 462 | * so that we can use black (0,0,0) as transparent, which is what |
463 | 463 | * the image is filled with when created. |
464 | 464 | */ |
465 | - $transparent = imagecolorallocate($dest_img, 0,0,0); |
|
465 | + $transparent = imagecolorallocate($dest_img, 0, 0, 0); |
|
466 | 466 | imagealphablending($dest_img, false); |
467 | 467 | imagesavealpha($dest_img, true); |
468 | 468 | imagecolortransparent($dest_img, $transparent); |
469 | - imagecopy($dest_img, $this->bg, 0,0, 0, 0,imagesx($this->bg), imagesx($this->bg)); |
|
469 | + imagecopy($dest_img, $this->bg, 0, 0, 0, 0, imagesx($this->bg), imagesx($this->bg)); |
|
470 | 470 | imagefilter($dest_img, IMG_FILTER_GRAYSCALE); |
471 | 471 | $this->bg = $dest_img; |
472 | 472 |
@@ -25,10 +25,10 @@ discard block |
||
25 | 25 | ); |
26 | 26 | public $is_course_model = true; |
27 | 27 | |
28 | - public function __construct() |
|
28 | + public function __construct() |
|
29 | 29 | { |
30 | 30 | $this->table = Database::get_course_table(TABLE_TIMELINE); |
31 | - } |
|
31 | + } |
|
32 | 32 | |
33 | 33 | /** |
34 | 34 | * Get the count of elements |
@@ -52,16 +52,16 @@ discard block |
||
52 | 52 | /** |
53 | 53 | * Displays the title + grid |
54 | 54 | */ |
55 | - public function listing() |
|
55 | + public function listing() |
|
56 | 56 | { |
57 | - // action links |
|
58 | - $html = '<div class="actions">'; |
|
57 | + // action links |
|
58 | + $html = '<div class="actions">'; |
|
59 | 59 | //$html .= '<a href="career_dashboard.php">'.Display::return_icon('back.png',get_lang('Back'),'','32').'</a>'; |
60 | - $html .= '<a href="'.api_get_self().'?action=add">'.Display::return_icon('add.png', get_lang('Add'),'','32').'</a>'; |
|
61 | - $html .= '</div>'; |
|
60 | + $html .= '<a href="'.api_get_self().'?action=add">'.Display::return_icon('add.png', get_lang('Add'),'','32').'</a>'; |
|
61 | + $html .= '</div>'; |
|
62 | 62 | $html .= Display::grid_html('timelines'); |
63 | 63 | return $html; |
64 | - } |
|
64 | + } |
|
65 | 65 | |
66 | 66 | public function get_status_list() |
67 | 67 | { |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | |
90 | 90 | $form->addElement('text', 'headline', get_lang('Name'), array('size' => '70')); |
91 | 91 | //$form->addHtmlEditor('description', get_lang('Description'), false, false, array('ToolbarSet' => 'Careers','Width' => '100%', 'Height' => '250')); |
92 | - $status_list = $this->get_status_list(); |
|
92 | + $status_list = $this->get_status_list(); |
|
93 | 93 | $form->addElement('select', 'status', get_lang('Status'), $status_list); |
94 | 94 | if ($action == 'edit') { |
95 | 95 | //$form->addElement('text', 'created_at', get_lang('CreatedAt')); |
@@ -173,7 +173,7 @@ discard block |
||
173 | 173 | |
174 | 174 | // Setting the rules |
175 | 175 | $form->addRule('headline', get_lang('ThisFieldIsRequired'), 'required'); |
176 | - return $form; |
|
176 | + return $form; |
|
177 | 177 | |
178 | 178 | } |
179 | 179 | |
@@ -184,11 +184,11 @@ discard block |
||
184 | 184 | public function save_item($params) |
185 | 185 | { |
186 | 186 | $params['c_id'] = api_get_course_int_id(); |
187 | - $id = parent::save($params); |
|
188 | - if (!empty($id)) { |
|
189 | - //event_system(LOG_CAREER_CREATE, LOG_CAREER_ID, $id, api_get_utc_datetime(), api_get_user_id()); |
|
190 | - } |
|
191 | - return $id; |
|
187 | + $id = parent::save($params); |
|
188 | + if (!empty($id)) { |
|
189 | + //event_system(LOG_CAREER_CREATE, LOG_CAREER_ID, $id, api_get_utc_datetime(), api_get_user_id()); |
|
190 | + } |
|
191 | + return $id; |
|
192 | 192 | } |
193 | 193 | |
194 | 194 | /** |
@@ -199,16 +199,16 @@ discard block |
||
199 | 199 | $params['c_id'] = api_get_course_int_id(); |
200 | 200 | $params['parent_id'] = '0'; |
201 | 201 | $params['type'] = 'default'; |
202 | - $id = parent::save($params); |
|
203 | - if (!empty($id)) { |
|
204 | - //event_system(LOG_CAREER_CREATE, LOG_CAREER_ID, $id, api_get_utc_datetime(), api_get_user_id()); |
|
205 | - } |
|
206 | - return $id; |
|
202 | + $id = parent::save($params); |
|
203 | + if (!empty($id)) { |
|
204 | + //event_system(LOG_CAREER_CREATE, LOG_CAREER_ID, $id, api_get_utc_datetime(), api_get_user_id()); |
|
205 | + } |
|
206 | + return $id; |
|
207 | 207 | } |
208 | 208 | |
209 | 209 | public function delete($id) { |
210 | - parent::delete($id); |
|
211 | - //event_system(LOG_CAREER_DELETE, LOG_CAREER_ID, $id, api_get_utc_datetime(), api_get_user_id()); |
|
210 | + parent::delete($id); |
|
211 | + //event_system(LOG_CAREER_DELETE, LOG_CAREER_ID, $id, api_get_utc_datetime(), api_get_user_id()); |
|
212 | 212 | } |
213 | 213 | |
214 | 214 | public function get_url($id) { |
@@ -247,7 +247,7 @@ discard block |
||
247 | 247 | $item['asset'] = array( 'media' => $item['media'], |
248 | 248 | 'credit' => $item['media_credit'], |
249 | 249 | 'caption' => $item['media_caption'], |
250 | - ); |
|
250 | + ); |
|
251 | 251 | |
252 | 252 | //Cleaning items |
253 | 253 | unset($item['id']); |
@@ -27,7 +27,7 @@ discard block |
||
27 | 27 | |
28 | 28 | public function __construct() |
29 | 29 | { |
30 | - $this->table = Database::get_course_table(TABLE_TIMELINE); |
|
30 | + $this->table = Database::get_course_table(TABLE_TIMELINE); |
|
31 | 31 | } |
32 | 32 | |
33 | 33 | /** |
@@ -46,7 +46,7 @@ discard block |
||
46 | 46 | */ |
47 | 47 | public function get_all($where_conditions = array()) |
48 | 48 | { |
49 | - return Database::select('*',$this->table, array('where'=>$where_conditions,'order' =>'headline ASC')); |
|
49 | + return Database::select('*', $this->table, array('where'=>$where_conditions, 'order' =>'headline ASC')); |
|
50 | 50 | } |
51 | 51 | |
52 | 52 | /** |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | // action links |
58 | 58 | $html = '<div class="actions">'; |
59 | 59 | //$html .= '<a href="career_dashboard.php">'.Display::return_icon('back.png',get_lang('Back'),'','32').'</a>'; |
60 | - $html .= '<a href="'.api_get_self().'?action=add">'.Display::return_icon('add.png', get_lang('Add'),'','32').'</a>'; |
|
60 | + $html .= '<a href="'.api_get_self().'?action=add">'.Display::return_icon('add.png', get_lang('Add'), '', '32').'</a>'; |
|
61 | 61 | $html .= '</div>'; |
62 | 62 | $html .= Display::grid_html('timelines'); |
63 | 63 | return $html; |
@@ -244,7 +244,7 @@ discard block |
||
244 | 244 | } |
245 | 245 | unset($item['end_date']); |
246 | 246 | // Assets |
247 | - $item['asset'] = array( 'media' => $item['media'], |
|
247 | + $item['asset'] = array('media' => $item['media'], |
|
248 | 248 | 'credit' => $item['media_credit'], |
249 | 249 | 'caption' => $item['media_caption'], |
250 | 250 | ); |
@@ -11,15 +11,15 @@ discard block |
||
11 | 11 | class UrlManager |
12 | 12 | { |
13 | 13 | /** |
14 | - * Creates a new url access |
|
15 | - * |
|
16 | - * @author Julio Montoya <[email protected]>, |
|
17 | - * |
|
18 | - * @param string $url The URL of the site |
|
19 | - * @param string $description The description of the site |
|
20 | - * @param int $active is active or not |
|
21 | - * @return boolean if success |
|
22 | - */ |
|
14 | + * Creates a new url access |
|
15 | + * |
|
16 | + * @author Julio Montoya <[email protected]>, |
|
17 | + * |
|
18 | + * @param string $url The URL of the site |
|
19 | + * @param string $description The description of the site |
|
20 | + * @param int $active is active or not |
|
21 | + * @return boolean if success |
|
22 | + */ |
|
23 | 23 | public static function add($url, $description, $active) |
24 | 24 | { |
25 | 25 | $tms = time(); |
@@ -36,15 +36,15 @@ discard block |
||
36 | 36 | } |
37 | 37 | |
38 | 38 | /** |
39 | - * Updates an URL access |
|
40 | - * @author Julio Montoya <[email protected]>, |
|
41 | - * |
|
42 | - * @param int $url_id The url id |
|
43 | - * @param string $url |
|
44 | - * @param string $description The description of the site |
|
45 | - * @param int $active is active or not |
|
46 | - * @return boolean if success |
|
47 | - */ |
|
39 | + * Updates an URL access |
|
40 | + * @author Julio Montoya <[email protected]>, |
|
41 | + * |
|
42 | + * @param int $url_id The url id |
|
43 | + * @param string $url |
|
44 | + * @param string $description The description of the site |
|
45 | + * @param int $active is active or not |
|
46 | + * @return boolean if success |
|
47 | + */ |
|
48 | 48 | public static function update($url_id, $url, $description, $active) |
49 | 49 | { |
50 | 50 | $url_id = intval($url_id); |
@@ -63,12 +63,12 @@ discard block |
||
63 | 63 | } |
64 | 64 | |
65 | 65 | /** |
66 | - * Deletes an url |
|
67 | - * @author Julio Montoya |
|
68 | - * @param int $id url id |
|
66 | + * Deletes an url |
|
67 | + * @author Julio Montoya |
|
68 | + * @param int $id url id |
|
69 | 69 | * |
70 | - * @return boolean true if success |
|
71 | - * */ |
|
70 | + * @return boolean true if success |
|
71 | + * */ |
|
72 | 72 | public static function delete($id) |
73 | 73 | { |
74 | 74 | $id = intval($id); |
@@ -200,12 +200,12 @@ discard block |
||
200 | 200 | } |
201 | 201 | |
202 | 202 | /** |
203 | - * Gets the inner join of access_url and the course table |
|
204 | - * |
|
205 | - * @author Julio Montoya |
|
206 | - * @param int access url id |
|
207 | - * @return array Database::store_result of the result |
|
208 | - **/ |
|
203 | + * Gets the inner join of access_url and the course table |
|
204 | + * |
|
205 | + * @author Julio Montoya |
|
206 | + * @param int access url id |
|
207 | + * @return array Database::store_result of the result |
|
208 | + **/ |
|
209 | 209 | public static function get_url_rel_course_data($access_url_id = null) |
210 | 210 | { |
211 | 211 | $where = ''; |
@@ -362,12 +362,12 @@ discard block |
||
362 | 362 | } |
363 | 363 | |
364 | 364 | /** |
365 | - * Checks the relationship between an URL and a User (return the num_rows) |
|
366 | - * @author Julio Montoya |
|
367 | - * @param int user id |
|
368 | - * @param int url id |
|
369 | - * @return boolean true if success |
|
370 | - * */ |
|
365 | + * Checks the relationship between an URL and a User (return the num_rows) |
|
366 | + * @author Julio Montoya |
|
367 | + * @param int user id |
|
368 | + * @param int url id |
|
369 | + * @return boolean true if success |
|
370 | + * */ |
|
371 | 371 | public static function relation_url_user_exist($user_id, $url_id) |
372 | 372 | { |
373 | 373 | $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
@@ -377,15 +377,15 @@ discard block |
||
377 | 377 | $num = Database::num_rows($result); |
378 | 378 | |
379 | 379 | return $num; |
380 | - } |
|
380 | + } |
|
381 | 381 | |
382 | 382 | /** |
383 | - * Checks the relationship between an URL and a Course (return the num_rows) |
|
384 | - * @author Julio Montoya |
|
385 | - * @param int $courseId |
|
386 | - * @param int $urlId |
|
387 | - * @return boolean true if success |
|
388 | - * */ |
|
383 | + * Checks the relationship between an URL and a Course (return the num_rows) |
|
384 | + * @author Julio Montoya |
|
385 | + * @param int $courseId |
|
386 | + * @param int $urlId |
|
387 | + * @return boolean true if success |
|
388 | + * */ |
|
389 | 389 | public static function relation_url_course_exist($courseId, $urlId) |
390 | 390 | { |
391 | 391 | $table_url_rel_course = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE); |
@@ -420,12 +420,12 @@ discard block |
||
420 | 420 | } |
421 | 421 | |
422 | 422 | /** |
423 | - * Checks the relationship between an URL and a Session (return the num_rows) |
|
424 | - * @author Julio Montoya |
|
425 | - * @param int user id |
|
426 | - * @param int url id |
|
427 | - * @return boolean true if success |
|
428 | - * */ |
|
423 | + * Checks the relationship between an URL and a Session (return the num_rows) |
|
424 | + * @author Julio Montoya |
|
425 | + * @param int user id |
|
426 | + * @param int url id |
|
427 | + * @return boolean true if success |
|
428 | + * */ |
|
429 | 429 | public static function relation_url_session_exist($session_id, $url_id) |
430 | 430 | { |
431 | 431 | $table_url_rel_session= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
@@ -737,13 +737,13 @@ discard block |
||
737 | 737 | } |
738 | 738 | |
739 | 739 | /** |
740 | - * Deletes an url and user relationship |
|
741 | - * @author Julio Montoya |
|
742 | - * @param int user id |
|
743 | - * @param int url id |
|
740 | + * Deletes an url and user relationship |
|
741 | + * @author Julio Montoya |
|
742 | + * @param int user id |
|
743 | + * @param int url id |
|
744 | 744 | * |
745 | - * @return boolean true if success |
|
746 | - * */ |
|
745 | + * @return boolean true if success |
|
746 | + * */ |
|
747 | 747 | public static function delete_url_rel_user($user_id, $url_id) |
748 | 748 | { |
749 | 749 | $table_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
@@ -758,13 +758,13 @@ discard block |
||
758 | 758 | } |
759 | 759 | |
760 | 760 | /** |
761 | - * Deletes an url and course relationship |
|
762 | - * @author Julio Montoya |
|
763 | - * @param int $courseId |
|
764 | - * @param int $urlId |
|
761 | + * Deletes an url and course relationship |
|
762 | + * @author Julio Montoya |
|
763 | + * @param int $courseId |
|
764 | + * @param int $urlId |
|
765 | 765 | * |
766 | - * @return boolean true if success |
|
767 | - * */ |
|
766 | + * @return boolean true if success |
|
767 | + * */ |
|
768 | 768 | public static function delete_url_rel_course($courseId, $urlId) |
769 | 769 | { |
770 | 770 | $table_url_rel_course= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE); |
@@ -814,13 +814,13 @@ discard block |
||
814 | 814 | } |
815 | 815 | |
816 | 816 | /** |
817 | - * Deletes an url and session relationship |
|
818 | - * @author Julio Montoya |
|
819 | - * @param char course code |
|
820 | - * @param int url id |
|
817 | + * Deletes an url and session relationship |
|
818 | + * @author Julio Montoya |
|
819 | + * @param char course code |
|
820 | + * @param int url id |
|
821 | 821 | * |
822 | - * @return boolean true if success |
|
823 | - * */ |
|
822 | + * @return boolean true if success |
|
823 | + * */ |
|
824 | 824 | public static function delete_url_rel_session($session_id, $url_id) |
825 | 825 | { |
826 | 826 | $table_url_rel_session = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
@@ -18,7 +18,7 @@ discard block |
||
18 | 18 | * @param string $url The URL of the site |
19 | 19 | * @param string $description The description of the site |
20 | 20 | * @param int $active is active or not |
21 | - * @return boolean if success |
|
21 | + * @return Doctrine\DBAL\Driver\Statement|null if success |
|
22 | 22 | */ |
23 | 23 | public static function add($url, $description, $active) |
24 | 24 | { |
@@ -43,7 +43,7 @@ discard block |
||
43 | 43 | * @param string $url |
44 | 44 | * @param string $description The description of the site |
45 | 45 | * @param int $active is active or not |
46 | - * @return boolean if success |
|
46 | + * @return Doctrine\DBAL\Driver\Statement|null if success |
|
47 | 47 | */ |
48 | 48 | public static function update($url_id, $url, $description, $active) |
49 | 49 | { |
@@ -386,7 +386,7 @@ discard block |
||
386 | 386 | * @author Julio Montoya |
387 | 387 | * @param int user id |
388 | 388 | * @param int url id |
389 | - * @return boolean true if success |
|
389 | + * @return integer true if success |
|
390 | 390 | * */ |
391 | 391 | public static function relation_url_user_exist($user_id, $url_id) |
392 | 392 | { |
@@ -404,7 +404,7 @@ discard block |
||
404 | 404 | * @author Julio Montoya |
405 | 405 | * @param int $courseId |
406 | 406 | * @param int $urlId |
407 | - * @return boolean true if success |
|
407 | + * @return integer true if success |
|
408 | 408 | * */ |
409 | 409 | public static function relation_url_course_exist($courseId, $urlId) |
410 | 410 | { |
@@ -425,7 +425,7 @@ discard block |
||
425 | 425 | * @author Julio Montoya |
426 | 426 | * @param int $userGroupId |
427 | 427 | * @param int $urlId |
428 | - * @return boolean true if success |
|
428 | + * @return integer true if success |
|
429 | 429 | * */ |
430 | 430 | public static function relationUrlUsergroupExist($userGroupId, $urlId) |
431 | 431 | { |
@@ -445,7 +445,7 @@ discard block |
||
445 | 445 | * @author Julio Montoya |
446 | 446 | * @param int user id |
447 | 447 | * @param int url id |
448 | - * @return boolean true if success |
|
448 | + * @return integer true if success |
|
449 | 449 | * */ |
450 | 450 | public static function relation_url_session_exist($session_id, $url_id) |
451 | 451 | { |
@@ -568,6 +568,8 @@ discard block |
||
568 | 568 | * @author Julio Montoya |
569 | 569 | * @param array of course ids |
570 | 570 | * @param array of url_ids |
571 | + * @param integer[] $courseCategoryList |
|
572 | + * @param integer[] $urlList |
|
571 | 573 | * @return array |
572 | 574 | **/ |
573 | 575 | public static function addCourseCategoryListToUrl($courseCategoryList, $urlList) |
@@ -598,7 +600,7 @@ discard block |
||
598 | 600 | * @author Julio Montoya |
599 | 601 | * @param int $categoryCourseId |
600 | 602 | * @param int $urlId |
601 | - * @return boolean true if success |
|
603 | + * @return integer true if success |
|
602 | 604 | * */ |
603 | 605 | public static function relationUrlCourseCategoryExist($categoryCourseId, $urlId) |
604 | 606 | { |
@@ -615,7 +617,7 @@ discard block |
||
615 | 617 | /** |
616 | 618 | * @param int $userGroupId |
617 | 619 | * @param int $urlId |
618 | - * @return int |
|
620 | + * @return string |
|
619 | 621 | */ |
620 | 622 | public static function addUserGroupToUrl($userGroupId, $urlId) |
621 | 623 | { |
@@ -716,7 +718,7 @@ discard block |
||
716 | 718 | * @param int $courseId |
717 | 719 | * @param int $url_id |
718 | 720 | * |
719 | - * @return resource |
|
721 | + * @return boolean |
|
720 | 722 | */ |
721 | 723 | public static function add_course_to_url($courseId, $url_id = 1) |
722 | 724 | { |
@@ -807,7 +809,7 @@ discard block |
||
807 | 809 | * @param int $courseId |
808 | 810 | * @param int $urlId |
809 | 811 | * |
810 | - * @return boolean true if success |
|
812 | + * @return Doctrine\DBAL\Driver\Statement|null true if success |
|
811 | 813 | * */ |
812 | 814 | public static function delete_url_rel_course($courseId, $urlId) |
813 | 815 | { |
@@ -825,7 +827,7 @@ discard block |
||
825 | 827 | * @param int $userGroupId |
826 | 828 | * @param int $urlId |
827 | 829 | * |
828 | - * @return boolean true if success |
|
830 | + * @return Doctrine\DBAL\Driver\Statement|null true if success |
|
829 | 831 | * */ |
830 | 832 | public static function delete_url_rel_usergroup($userGroupId, $urlId) |
831 | 833 | { |
@@ -844,7 +846,7 @@ discard block |
||
844 | 846 | * @param int $userGroupId |
845 | 847 | * @param int $urlId |
846 | 848 | * |
847 | - * @return boolean true if success |
|
849 | + * @return Doctrine\DBAL\Driver\Statement|null true if success |
|
848 | 850 | * */ |
849 | 851 | public static function deleteUrlRelCourseCategory($userGroupId, $urlId) |
850 | 852 | { |
@@ -862,8 +864,9 @@ discard block |
||
862 | 864 | * @author Julio Montoya |
863 | 865 | * @param char course code |
864 | 866 | * @param int url id |
867 | + * @param integer $url_id |
|
865 | 868 | * |
866 | - * @return boolean true if success |
|
869 | + * @return Doctrine\DBAL\Driver\Statement|null true if success |
|
867 | 870 | * */ |
868 | 871 | public static function delete_url_rel_session($session_id, $url_id) |
869 | 872 | { |
@@ -23,7 +23,7 @@ discard block |
||
23 | 23 | public static function add($url, $description, $active) |
24 | 24 | { |
25 | 25 | $tms = time(); |
26 | - $table= Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
26 | + $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
27 | 27 | $sql = "INSERT INTO $table |
28 | 28 | SET url = '".Database::escape_string($url)."', |
29 | 29 | description = '".Database::escape_string($description)."', |
@@ -92,7 +92,7 @@ discard block |
||
92 | 92 | $sql = "DELETE FROM $tableUser WHERE access_url_id = ".$id; |
93 | 93 | Database::query($sql); |
94 | 94 | |
95 | - $sql= "DELETE FROM $table WHERE id = ".$id; |
|
95 | + $sql = "DELETE FROM $table WHERE id = ".$id; |
|
96 | 96 | Database::query($sql); |
97 | 97 | |
98 | 98 | return true; |
@@ -105,7 +105,7 @@ discard block |
||
105 | 105 | */ |
106 | 106 | public static function url_exist($url) |
107 | 107 | { |
108 | - $table= Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
108 | + $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
109 | 109 | $sql = "SELECT id FROM $table |
110 | 110 | WHERE url = '".Database::escape_string($url)."' "; |
111 | 111 | $res = Database::query($sql); |
@@ -139,10 +139,10 @@ discard block |
||
139 | 139 | * */ |
140 | 140 | public static function url_count() |
141 | 141 | { |
142 | - $table_access_url= Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
142 | + $table_access_url = Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
143 | 143 | $sql = "SELECT count(id) as count_result FROM $table_access_url"; |
144 | 144 | $res = Database::query($sql); |
145 | - $url = Database::fetch_array($res,'ASSOC'); |
|
145 | + $url = Database::fetch_array($res, 'ASSOC'); |
|
146 | 146 | $result = $url['count_result']; |
147 | 147 | |
148 | 148 | return $result; |
@@ -160,7 +160,7 @@ discard block |
||
160 | 160 | FROM $table |
161 | 161 | ORDER BY id"; |
162 | 162 | $res = Database::query($sql); |
163 | - $urls = array (); |
|
163 | + $urls = array(); |
|
164 | 164 | while ($url = Database::fetch_array($res)) { |
165 | 165 | $urls[] = $url; |
166 | 166 | } |
@@ -277,7 +277,7 @@ discard block |
||
277 | 277 | **/ |
278 | 278 | public static function get_url_rel_session_data($access_url_id = null) |
279 | 279 | { |
280 | - $where =''; |
|
280 | + $where = ''; |
|
281 | 281 | $table_url_rel_session = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
282 | 282 | $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION); |
283 | 283 | |
@@ -313,7 +313,7 @@ discard block |
||
313 | 313 | $table_user_group = Database::get_main_table(TABLE_USERGROUP); |
314 | 314 | |
315 | 315 | if (!empty($access_url_id)) { |
316 | - $where ="WHERE $table_url_rel_usergroup.access_url_id = ".intval($access_url_id); |
|
316 | + $where = "WHERE $table_url_rel_usergroup.access_url_id = ".intval($access_url_id); |
|
317 | 317 | } |
318 | 318 | |
319 | 319 | $sql = "SELECT u.id, u.name, access_url_id |
@@ -391,7 +391,7 @@ discard block |
||
391 | 391 | public static function relation_url_user_exist($user_id, $url_id) |
392 | 392 | { |
393 | 393 | $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
394 | - $sql= "SELECT user_id FROM $table |
|
394 | + $sql = "SELECT user_id FROM $table |
|
395 | 395 | WHERE access_url_id = ".intval($url_id)." AND user_id = ".intval($user_id)." "; |
396 | 396 | $result = Database::query($sql); |
397 | 397 | $num = Database::num_rows($result); |
@@ -409,7 +409,7 @@ discard block |
||
409 | 409 | public static function relation_url_course_exist($courseId, $urlId) |
410 | 410 | { |
411 | 411 | $table_url_rel_course = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE); |
412 | - $sql= "SELECT c_id FROM $table_url_rel_course |
|
412 | + $sql = "SELECT c_id FROM $table_url_rel_course |
|
413 | 413 | WHERE |
414 | 414 | access_url_id = ".intval($urlId)." AND |
415 | 415 | c_id = '".intval($courseId)."'"; |
@@ -430,7 +430,7 @@ discard block |
||
430 | 430 | public static function relationUrlUsergroupExist($userGroupId, $urlId) |
431 | 431 | { |
432 | 432 | $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USERGROUP); |
433 | - $sql= "SELECT usergroup_id FROM $table |
|
433 | + $sql = "SELECT usergroup_id FROM $table |
|
434 | 434 | WHERE |
435 | 435 | access_url_id = ".intval($urlId)." AND |
436 | 436 | usergroup_id = ".intval($userGroupId); |
@@ -449,9 +449,9 @@ discard block |
||
449 | 449 | * */ |
450 | 450 | public static function relation_url_session_exist($session_id, $url_id) |
451 | 451 | { |
452 | - $table_url_rel_session= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
452 | + $table_url_rel_session = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
453 | 453 | $session_id = intval($session_id); |
454 | - $url_id = intval($url_id); |
|
454 | + $url_id = intval($url_id); |
|
455 | 455 | $sql = "SELECT session_id FROM $table_url_rel_session |
456 | 456 | WHERE |
457 | 457 | access_url_id = ".intval($url_id)." AND |
@@ -477,7 +477,7 @@ discard block |
||
477 | 477 | if (is_array($user_list) && is_array($url_list)) { |
478 | 478 | foreach ($url_list as $url_id) { |
479 | 479 | foreach ($user_list as $user_id) { |
480 | - $count = UrlManager::relation_url_user_exist($user_id,$url_id); |
|
480 | + $count = UrlManager::relation_url_user_exist($user_id, $url_id); |
|
481 | 481 | if ($count == 0) { |
482 | 482 | $sql = "INSERT INTO $table_url_rel_user |
483 | 483 | SET |
@@ -505,7 +505,7 @@ discard block |
||
505 | 505 | * @param array of url_ids |
506 | 506 | * @return array |
507 | 507 | **/ |
508 | - public static function add_courses_to_urls($course_list,$url_list) |
|
508 | + public static function add_courses_to_urls($course_list, $url_list) |
|
509 | 509 | { |
510 | 510 | $table_url_rel_course = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE); |
511 | 511 | $result_array = array(); |
@@ -517,7 +517,7 @@ discard block |
||
517 | 517 | $courseId = $courseInfo['real_id']; |
518 | 518 | |
519 | 519 | $count = self::relation_url_course_exist($courseId, $url_id); |
520 | - if ($count==0) { |
|
520 | + if ($count == 0) { |
|
521 | 521 | $sql = "INSERT INTO $table_url_rel_course |
522 | 522 | SET c_id = '".$courseId."', access_url_id = ".intval($url_id); |
523 | 523 | $result = Database::query($sql); |
@@ -603,7 +603,7 @@ discard block |
||
603 | 603 | public static function relationUrlCourseCategoryExist($categoryCourseId, $urlId) |
604 | 604 | { |
605 | 605 | $table = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE_CATEGORY); |
606 | - $sql= "SELECT course_category_id FROM $table |
|
606 | + $sql = "SELECT course_category_id FROM $table |
|
607 | 607 | WHERE access_url_id = ".intval($urlId)." AND |
608 | 608 | course_category_id = ".intval($categoryCourseId); |
609 | 609 | $result = Database::query($sql); |
@@ -774,7 +774,7 @@ discard block |
||
774 | 774 | $table_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
775 | 775 | $result = true; |
776 | 776 | if (!empty($user_id) && !empty($url_id)) { |
777 | - $sql= "DELETE FROM $table_url_rel_user |
|
777 | + $sql = "DELETE FROM $table_url_rel_user |
|
778 | 778 | WHERE user_id = ".intval($user_id)." AND access_url_id = ".intval($url_id); |
779 | 779 | $result = Database::query($sql); |
780 | 780 | } |
@@ -794,7 +794,7 @@ discard block |
||
794 | 794 | $table_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
795 | 795 | $result = true; |
796 | 796 | if (!empty($userId)) { |
797 | - $sql= "DELETE FROM $table_url_rel_user |
|
797 | + $sql = "DELETE FROM $table_url_rel_user |
|
798 | 798 | WHERE user_id = ".intval($userId); |
799 | 799 | Database::query($sql); |
800 | 800 | } |
@@ -812,8 +812,8 @@ discard block |
||
812 | 812 | * */ |
813 | 813 | public static function delete_url_rel_course($courseId, $urlId) |
814 | 814 | { |
815 | - $table_url_rel_course= Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE); |
|
816 | - $sql= "DELETE FROM $table_url_rel_course |
|
815 | + $table_url_rel_course = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE); |
|
816 | + $sql = "DELETE FROM $table_url_rel_course |
|
817 | 817 | WHERE c_id = '".intval($courseId)."' AND access_url_id=".intval($urlId)." "; |
818 | 818 | $result = Database::query($sql); |
819 | 819 | |
@@ -831,7 +831,7 @@ discard block |
||
831 | 831 | public static function delete_url_rel_usergroup($userGroupId, $urlId) |
832 | 832 | { |
833 | 833 | $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USERGROUP); |
834 | - $sql= "DELETE FROM $table |
|
834 | + $sql = "DELETE FROM $table |
|
835 | 835 | WHERE usergroup_id = '".intval($userGroupId)."' AND |
836 | 836 | access_url_id = ".intval($urlId); |
837 | 837 | $result = Database::query($sql); |
@@ -850,7 +850,7 @@ discard block |
||
850 | 850 | public static function deleteUrlRelCourseCategory($userGroupId, $urlId) |
851 | 851 | { |
852 | 852 | $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE_CATEGORY); |
853 | - $sql= "DELETE FROM $table |
|
853 | + $sql = "DELETE FROM $table |
|
854 | 854 | WHERE course_category_id = '".intval($userGroupId)."' AND |
855 | 855 | access_url_id=".intval($urlId)." "; |
856 | 856 | $result = Database::query($sql); |
@@ -869,9 +869,9 @@ discard block |
||
869 | 869 | public static function delete_url_rel_session($session_id, $url_id) |
870 | 870 | { |
871 | 871 | $table_url_rel_session = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
872 | - $sql= "DELETE FROM $table_url_rel_session |
|
872 | + $sql = "DELETE FROM $table_url_rel_session |
|
873 | 873 | WHERE session_id = ".intval($session_id)." AND access_url_id=".intval($url_id)." "; |
874 | - $result = Database::query($sql,'ASSOC'); |
|
874 | + $result = Database::query($sql, 'ASSOC'); |
|
875 | 875 | |
876 | 876 | return $result; |
877 | 877 | } |
@@ -884,7 +884,7 @@ discard block |
||
884 | 884 | * */ |
885 | 885 | public static function update_urls_rel_user($user_list, $access_url_id) |
886 | 886 | { |
887 | - $table_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
|
887 | + $table_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
|
888 | 888 | $sql = "SELECT user_id |
889 | 889 | FROM $table_url_rel_user |
890 | 890 | WHERE access_url_id = ".intval($access_url_id); |
@@ -940,7 +940,7 @@ discard block |
||
940 | 940 | $result = Database::query($sql); |
941 | 941 | |
942 | 942 | $existing_courses = array(); |
943 | - while ($row = Database::fetch_array($result)){ |
|
943 | + while ($row = Database::fetch_array($result)) { |
|
944 | 944 | $existing_courses[] = $row['c_id']; |
945 | 945 | } |
946 | 946 | |
@@ -973,7 +973,7 @@ discard block |
||
973 | 973 | $result = Database::query($sql); |
974 | 974 | $existingItems = array(); |
975 | 975 | |
976 | - while ($row = Database::fetch_array($result)){ |
|
976 | + while ($row = Database::fetch_array($result)) { |
|
977 | 977 | $existingItems[] = $row['usergroup_id']; |
978 | 978 | } |
979 | 979 | |
@@ -1006,7 +1006,7 @@ discard block |
||
1006 | 1006 | $result = Database::query($sql); |
1007 | 1007 | $existingItems = array(); |
1008 | 1008 | |
1009 | - while ($row = Database::fetch_array($result)){ |
|
1009 | + while ($row = Database::fetch_array($result)) { |
|
1010 | 1010 | $existingItems[] = $row['course_category_id']; |
1011 | 1011 | } |
1012 | 1012 | |
@@ -1046,13 +1046,13 @@ discard block |
||
1046 | 1046 | * */ |
1047 | 1047 | public static function update_urls_rel_session($session_list, $access_url_id) |
1048 | 1048 | { |
1049 | - $table_url_rel_session = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
1049 | + $table_url_rel_session = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
|
1050 | 1050 | |
1051 | 1051 | $sql = "SELECT session_id FROM $table_url_rel_session WHERE access_url_id=".intval($access_url_id); |
1052 | 1052 | $result = Database::query($sql); |
1053 | 1053 | $existing_sessions = array(); |
1054 | 1054 | |
1055 | - while ($row = Database::fetch_array($result)){ |
|
1055 | + while ($row = Database::fetch_array($result)) { |
|
1056 | 1056 | $existing_sessions[] = $row['session_id']; |
1057 | 1057 | } |
1058 | 1058 | |
@@ -1082,13 +1082,13 @@ discard block |
||
1082 | 1082 | */ |
1083 | 1083 | public static function get_access_url_from_user($user_id) |
1084 | 1084 | { |
1085 | - $table_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
|
1086 | - $table_url = Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
1085 | + $table_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER); |
|
1086 | + $table_url = Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
1087 | 1087 | $sql = "SELECT url, access_url_id FROM $table_url_rel_user url_rel_user INNER JOIN $table_url u |
1088 | 1088 | ON (url_rel_user.access_url_id = u.id) |
1089 | 1089 | WHERE user_id = ".intval($user_id); |
1090 | 1090 | $result = Database::query($sql); |
1091 | - $url_list = Database::store_result($result,'ASSOC'); |
|
1091 | + $url_list = Database::store_result($result, 'ASSOC'); |
|
1092 | 1092 | |
1093 | 1093 | return $url_list; |
1094 | 1094 | } |
@@ -1099,14 +1099,14 @@ discard block |
||
1099 | 1099 | */ |
1100 | 1100 | public static function get_access_url_from_course($courseId) |
1101 | 1101 | { |
1102 | - $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE); |
|
1103 | - $table_url = Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
1102 | + $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE); |
|
1103 | + $table_url = Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
1104 | 1104 | $sql = "SELECT url, access_url_id FROM $table c INNER JOIN $table_url u |
1105 | 1105 | ON (c.access_url_id = u.id) |
1106 | 1106 | WHERE c_id = ".intval($courseId); |
1107 | 1107 | |
1108 | 1108 | $result = Database::query($sql); |
1109 | - $url_list = Database::store_result($result,'ASSOC'); |
|
1109 | + $url_list = Database::store_result($result, 'ASSOC'); |
|
1110 | 1110 | return $url_list; |
1111 | 1111 | } |
1112 | 1112 | |
@@ -1117,7 +1117,7 @@ discard block |
||
1117 | 1117 | public static function get_access_url_from_session($session_id) |
1118 | 1118 | { |
1119 | 1119 | $table_url_rel_session = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION); |
1120 | - $table_url = Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
1120 | + $table_url = Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
1121 | 1121 | $sql = "SELECT url, access_url_id FROM $table_url_rel_session url_rel_session INNER JOIN $table_url u |
1122 | 1122 | ON (url_rel_session.access_url_id = u.id) |
1123 | 1123 | WHERE session_id = ".intval($session_id); |
@@ -1133,7 +1133,7 @@ discard block |
||
1133 | 1133 | */ |
1134 | 1134 | public static function get_url_id($url) |
1135 | 1135 | { |
1136 | - $table_access_url= Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
1136 | + $table_access_url = Database :: get_main_table(TABLE_MAIN_ACCESS_URL); |
|
1137 | 1137 | $sql = "SELECT id FROM $table_access_url WHERE url = '".Database::escape_string($url)."'"; |
1138 | 1138 | $result = Database::query($sql); |
1139 | 1139 | $access_url_id = Database::result($result, 0, 0); |
@@ -79,7 +79,7 @@ discard block |
||
79 | 79 | $count = intval($count); |
80 | 80 | $from = intval($from); |
81 | 81 | |
82 | - $sql .= " ORDER BY $column $direction"; |
|
82 | + $sql .= " ORDER BY $column $direction"; |
|
83 | 83 | $sql .= " LIMIT $count, $from "; |
84 | 84 | |
85 | 85 | $result = Database::query($sql); |
@@ -93,8 +93,8 @@ discard block |
||
93 | 93 | static function deactivate_zombies($ceiling) |
94 | 94 | { |
95 | 95 | $zombies = self::list_zombies($ceiling); |
96 | - $ids = array(); |
|
97 | - foreach($zombies as $zombie) { |
|
96 | + $ids = array(); |
|
97 | + foreach ($zombies as $zombie) { |
|
98 | 98 | $ids[] = $zombie['user_id']; |
99 | 99 | } |
100 | 100 | UserManager::deactivate_users($ids); |
@@ -73,8 +73,9 @@ |
||
73 | 73 | //$form->addElement('submit','submit',get_lang('Filter')); |
74 | 74 | $form->addButtonFilter(get_lang('Filter')); |
75 | 75 | |
76 | -if (!empty($_REQUEST['course_code'])) |
|
76 | +if (!empty($_REQUEST['course_code'])) { |
|
77 | 77 | $selected_course = $_REQUEST['course_code']; |
78 | +} |
|
78 | 79 | if (!empty($selected_course)) { |
79 | 80 | $selected_course = api_get_course_info($selected_course); |
80 | 81 | $course_list = array($selected_course); |
@@ -16,34 +16,34 @@ discard block |
||
16 | 16 | $is_allowedToTrack = $is_courseAdmin || $is_platformAdmin || $is_courseCoach || $is_sessionAdmin; |
17 | 17 | |
18 | 18 | if (!$is_allowedToTrack) { |
19 | - Display :: display_header(null); |
|
20 | - api_not_allowed(); |
|
21 | - Display :: display_footer(); |
|
19 | + Display :: display_header(null); |
|
20 | + api_not_allowed(); |
|
21 | + Display :: display_footer(); |
|
22 | 22 | } |
23 | 23 | |
24 | 24 | $export_to_csv = false; |
25 | 25 | if (isset($_GET['export'])) { |
26 | - $export_to_csv = true; |
|
26 | + $export_to_csv = true; |
|
27 | 27 | } |
28 | 28 | |
29 | 29 | if (api_is_platform_admin() ) { |
30 | - $global = true; |
|
30 | + $global = true; |
|
31 | 31 | } else { |
32 | - $global = false; |
|
32 | + $global = false; |
|
33 | 33 | } |
34 | 34 | |
35 | 35 | if ($global) { |
36 | - $temp_course_list = CourseManager :: get_courses_list(); |
|
37 | - foreach($temp_course_list as $temp_course_item) { |
|
38 | - $course_item = CourseManager ::get_course_information($temp_course_item['code']); |
|
36 | + $temp_course_list = CourseManager :: get_courses_list(); |
|
37 | + foreach($temp_course_list as $temp_course_item) { |
|
38 | + $course_item = CourseManager ::get_course_information($temp_course_item['code']); |
|
39 | 39 | $course_list[] = array( |
40 | 40 | 'code' => $course_item['code'], |
41 | 41 | 'title' => $course_item['title'], |
42 | 42 | ); |
43 | - } |
|
43 | + } |
|
44 | 44 | } else { |
45 | 45 | $current_course['code'] = $_course['id']; |
46 | - $course_list = array($current_course); |
|
46 | + $course_list = array($current_course); |
|
47 | 47 | } |
48 | 48 | |
49 | 49 | $new_course_select = array(); |
@@ -54,20 +54,20 @@ discard block |
||
54 | 54 | $form = new FormValidator('search_simple', 'POST', '', '', null, false); |
55 | 55 | $form->addElement('select','course_code',get_lang('Course'), $new_course_select); |
56 | 56 | if ($global) { |
57 | - $form->addElement('hidden','view','admin'); |
|
57 | + $form->addElement('hidden','view','admin'); |
|
58 | 58 | } else { |
59 | - //Get exam lists |
|
59 | + //Get exam lists |
|
60 | 60 | $course_id = api_get_course_int_id(); |
61 | - $t_quiz = Database::get_course_table(TABLE_QUIZ_TEST); |
|
62 | - $sqlExercices = "SELECT quiz.title,id FROM ".$t_quiz." AS quiz |
|
61 | + $t_quiz = Database::get_course_table(TABLE_QUIZ_TEST); |
|
62 | + $sqlExercices = "SELECT quiz.title,id FROM ".$t_quiz." AS quiz |
|
63 | 63 | WHERE c_id = $course_id AND active='1' |
64 | 64 | ORDER BY quiz.title ASC"; |
65 | - $resultExercices = Database::query($sqlExercices); |
|
66 | - $exercise_list[0] = get_lang('All'); |
|
67 | - while($a_exercices = Database::fetch_array($resultExercices)) { |
|
68 | - $exercise_list[$a_exercices['id']] = $a_exercices['title']; |
|
69 | - } |
|
70 | - $form->addElement('select', 'exercise_id', get_lang('Exercise'), $exercise_list); |
|
65 | + $resultExercices = Database::query($sqlExercices); |
|
66 | + $exercise_list[0] = get_lang('All'); |
|
67 | + while($a_exercices = Database::fetch_array($resultExercices)) { |
|
68 | + $exercise_list[$a_exercices['id']] = $a_exercices['title']; |
|
69 | + } |
|
70 | + $form->addElement('select', 'exercise_id', get_lang('Exercise'), $exercise_list); |
|
71 | 71 | } |
72 | 72 | |
73 | 73 | //$form->addElement('submit','submit',get_lang('Filter')); |
@@ -81,9 +81,9 @@ discard block |
||
81 | 81 | } |
82 | 82 | |
83 | 83 | if (!$export_to_csv) { |
84 | - Display :: display_header(get_lang('Reporting')); |
|
85 | - echo '<div class="actions" style ="font-size:10pt;">'; |
|
86 | - if ($global) { |
|
84 | + Display :: display_header(get_lang('Reporting')); |
|
85 | + echo '<div class="actions" style ="font-size:10pt;">'; |
|
86 | + if ($global) { |
|
87 | 87 | |
88 | 88 | echo '<div style="float:right"> <a href="'.api_get_self().'?export=1&score='.$filter_score.'&exercise_id='.$exercise_id.'"> |
89 | 89 | '.Display::return_icon('csv.gif').' |
@@ -93,81 +93,81 @@ discard block |
||
93 | 93 | '.get_lang('Print').'</a> |
94 | 94 | </div>'; |
95 | 95 | |
96 | - $menu_items[] = '<a href="'.api_get_path(WEB_CODE_PATH).'mySpace/?view=teacher">'.get_lang('TeacherInterface').'</a>'; |
|
96 | + $menu_items[] = '<a href="'.api_get_path(WEB_CODE_PATH).'mySpace/?view=teacher">'.get_lang('TeacherInterface').'</a>'; |
|
97 | 97 | if (api_is_platform_admin()) { |
98 | - $menu_items[] = '<a href="'.api_get_path(WEB_CODE_PATH).'mySpace/?view=admin">'.get_lang('AdminInterface').'</a>'; |
|
98 | + $menu_items[] = '<a href="'.api_get_path(WEB_CODE_PATH).'mySpace/?view=admin">'.get_lang('AdminInterface').'</a>'; |
|
99 | 99 | } else { |
100 | 100 | $menu_items[] = '<a href="'.api_get_path(WEB_CODE_PATH).'mySpace/?view=coach">'.get_lang('AdminInterface').'</a>'; |
101 | 101 | } |
102 | - $menu_items[] = get_lang('ExamTracking'); |
|
103 | - $nb_menu_items = count($menu_items); |
|
104 | - if($nb_menu_items>1) { |
|
105 | - foreach($menu_items as $key=> $item) { |
|
106 | - echo $item; |
|
107 | - if($key!=$nb_menu_items-1) { |
|
108 | - echo ' | '; |
|
109 | - } |
|
110 | - } |
|
111 | - echo '<br />'; |
|
112 | - } |
|
113 | - } else { |
|
114 | - echo '<a href="courseLog.php?'.api_get_cidreq().'&studentlist=true">'.get_lang('StudentsTracking').'</a> | |
|
102 | + $menu_items[] = get_lang('ExamTracking'); |
|
103 | + $nb_menu_items = count($menu_items); |
|
104 | + if($nb_menu_items>1) { |
|
105 | + foreach($menu_items as $key=> $item) { |
|
106 | + echo $item; |
|
107 | + if($key!=$nb_menu_items-1) { |
|
108 | + echo ' | '; |
|
109 | + } |
|
110 | + } |
|
111 | + echo '<br />'; |
|
112 | + } |
|
113 | + } else { |
|
114 | + echo '<a href="courseLog.php?'.api_get_cidreq().'&studentlist=true">'.get_lang('StudentsTracking').'</a> | |
|
115 | 115 | <a href="courseLog.php?'.api_get_cidreq().'&studentlist=false">'.get_lang('CourseTracking').'</a> | '; |
116 | 116 | echo '<a href="courseLog.php?'.api_get_cidreq().'&studentlist=resources">'.get_lang('ResourcesTracking').'</a>'; |
117 | - echo ' | '.get_lang('ExamTracking').''; |
|
117 | + echo ' | '.get_lang('ExamTracking').''; |
|
118 | 118 | echo '<a href="'.api_get_self().'?export=1&score='.$filter_score.'&exercise_id='.$exercise_id.'"> |
119 | 119 | '.Display::return_icon('excel.gif').' |
120 | 120 | '.get_lang('ExportAsXLS').'</a><br /><br />'; |
121 | 121 | |
122 | - } |
|
122 | + } |
|
123 | 123 | echo '</div>'; |
124 | - echo '<br /><br />'; |
|
125 | - $form->display(); |
|
124 | + echo '<br /><br />'; |
|
125 | + $form->display(); |
|
126 | 126 | } |
127 | 127 | $main_result = array(); |
128 | 128 | $session_id = 0; |
129 | 129 | $user_list = array(); |
130 | 130 | // Getting course list |
131 | 131 | foreach ($course_list as $current_course ) { |
132 | - $course_info = api_get_course_info($current_course['code']); |
|
133 | - $_course = $course_info; |
|
134 | - |
|
135 | - // Getting LP list |
|
136 | - $list = new LearnpathList('', $current_course['code'], $session_id); |
|
137 | - $lp_list = $list->get_flat_list(); |
|
138 | - |
|
139 | - // Looping LPs |
|
140 | - $lps = array(); |
|
141 | - foreach ($lp_list as $lp_id =>$lp) { |
|
142 | - $exercise_list = Event::get_all_exercises_from_lp($lp_id, $course_info['real_id']); |
|
143 | - $attempt_result = array(); |
|
144 | - // Looping Chamilo Exercises in LP |
|
145 | - foreach ($exercise_list as $exercise) { |
|
146 | - $exercise_stats = Event::get_all_exercise_event_from_lp( |
|
147 | - $exercise['path'], |
|
148 | - $course_info['real_id'], |
|
149 | - $session_id |
|
150 | - ); |
|
151 | - // Looping Exercise Attempts |
|
152 | - foreach ($exercise_stats as $stats) { |
|
153 | - $attempt_result[$exercise['id']]['users'][$stats['exe_user_id']][$stats['exe_id']] = $stats; |
|
154 | - $user_list[$stats['exe_user_id']] = $stats['exe_user_id']; |
|
155 | - } |
|
156 | - $exercise_list_name[$exercise['id']] = $exercise['title']; |
|
157 | - } |
|
158 | - $lps[$lp_id] = array('lp_name' =>$lp['lp_name'], 'exercises' =>$attempt_result); |
|
159 | - $lp_list_name[$lp_id] = $lp['lp_name']; |
|
160 | - } |
|
161 | - $main_result[$current_course['code']] = $lps; |
|
132 | + $course_info = api_get_course_info($current_course['code']); |
|
133 | + $_course = $course_info; |
|
134 | + |
|
135 | + // Getting LP list |
|
136 | + $list = new LearnpathList('', $current_course['code'], $session_id); |
|
137 | + $lp_list = $list->get_flat_list(); |
|
138 | + |
|
139 | + // Looping LPs |
|
140 | + $lps = array(); |
|
141 | + foreach ($lp_list as $lp_id =>$lp) { |
|
142 | + $exercise_list = Event::get_all_exercises_from_lp($lp_id, $course_info['real_id']); |
|
143 | + $attempt_result = array(); |
|
144 | + // Looping Chamilo Exercises in LP |
|
145 | + foreach ($exercise_list as $exercise) { |
|
146 | + $exercise_stats = Event::get_all_exercise_event_from_lp( |
|
147 | + $exercise['path'], |
|
148 | + $course_info['real_id'], |
|
149 | + $session_id |
|
150 | + ); |
|
151 | + // Looping Exercise Attempts |
|
152 | + foreach ($exercise_stats as $stats) { |
|
153 | + $attempt_result[$exercise['id']]['users'][$stats['exe_user_id']][$stats['exe_id']] = $stats; |
|
154 | + $user_list[$stats['exe_user_id']] = $stats['exe_user_id']; |
|
155 | + } |
|
156 | + $exercise_list_name[$exercise['id']] = $exercise['title']; |
|
157 | + } |
|
158 | + $lps[$lp_id] = array('lp_name' =>$lp['lp_name'], 'exercises' =>$attempt_result); |
|
159 | + $lp_list_name[$lp_id] = $lp['lp_name']; |
|
160 | + } |
|
161 | + $main_result[$current_course['code']] = $lps; |
|
162 | 162 | } |
163 | 163 | |
164 | 164 | if (!empty($user_list)) { |
165 | 165 | foreach($user_list as $user_id) { |
166 | 166 | $user_data = api_get_user_info($user_id); |
167 | - $user_list_name[$user_id] = api_get_person_name( |
|
168 | - $user_data['firstname'], |
|
169 | - $user_data['lastname'] |
|
170 | - ); |
|
167 | + $user_list_name[$user_id] = api_get_person_name( |
|
168 | + $user_data['firstname'], |
|
169 | + $user_data['lastname'] |
|
170 | + ); |
|
171 | 171 | } |
172 | 172 | } |
173 | 173 | $export_array = array(); |
@@ -207,15 +207,15 @@ discard block |
||
207 | 207 | $html_result .= Display::tag('td', $result); |
208 | 208 | |
209 | 209 | $html_result .= '</tr>'; |
210 | - $export_array[] = array( |
|
211 | - $course_code, |
|
212 | - $lp_list_name[$lp_id], |
|
213 | - $exercise_list_name[$exercise_id], |
|
214 | - $user_list_name[$user_id], |
|
215 | - $attempt, |
|
216 | - api_get_local_time($attempt_data['exe_date']), |
|
217 | - $result, |
|
218 | - ); |
|
210 | + $export_array[] = array( |
|
211 | + $course_code, |
|
212 | + $lp_list_name[$lp_id], |
|
213 | + $exercise_list_name[$exercise_id], |
|
214 | + $user_list_name[$user_id], |
|
215 | + $attempt, |
|
216 | + api_get_local_time($attempt_data['exe_date']), |
|
217 | + $result, |
|
218 | + ); |
|
219 | 219 | $attempt++; |
220 | 220 | } |
221 | 221 | } |
@@ -226,30 +226,30 @@ discard block |
||
226 | 226 | } |
227 | 227 | |
228 | 228 | if (!$export_to_csv) { |
229 | - echo $html_result; |
|
229 | + echo $html_result; |
|
230 | 230 | } |
231 | 231 | $filename = 'learning_path_results-'.date('Y-m-d-h:i:s').'.xls'; |
232 | 232 | if ($export_to_csv) { |
233 | 233 | export_complete_report_csv($filename, $export_array); |
234 | - exit; |
|
234 | + exit; |
|
235 | 235 | } |
236 | 236 | |
237 | 237 | function export_complete_report_csv($filename, $array) |
238 | 238 | { |
239 | - $header[] = array( |
|
240 | - get_lang('Course'), |
|
241 | - get_lang('LearningPath'), |
|
242 | - get_lang('Exercise'), |
|
243 | - get_lang('User'), |
|
244 | - get_lang('Attempt'), |
|
245 | - get_lang('Date'), |
|
246 | - get_lang('Results'), |
|
247 | - ); |
|
248 | - if (!empty($array)) { |
|
249 | - $array = array_merge($header, $array); |
|
250 | - Export :: arrayToCsv($array, $filename); |
|
251 | - } |
|
252 | - exit; |
|
239 | + $header[] = array( |
|
240 | + get_lang('Course'), |
|
241 | + get_lang('LearningPath'), |
|
242 | + get_lang('Exercise'), |
|
243 | + get_lang('User'), |
|
244 | + get_lang('Attempt'), |
|
245 | + get_lang('Date'), |
|
246 | + get_lang('Results'), |
|
247 | + ); |
|
248 | + if (!empty($array)) { |
|
249 | + $array = array_merge($header, $array); |
|
250 | + Export :: arrayToCsv($array, $filename); |
|
251 | + } |
|
252 | + exit; |
|
253 | 253 | |
254 | 254 | } |
255 | 255 | Display :: display_footer(); |
@@ -26,7 +26,7 @@ discard block |
||
26 | 26 | $export_to_csv = true; |
27 | 27 | } |
28 | 28 | |
29 | -if (api_is_platform_admin() ) { |
|
29 | +if (api_is_platform_admin()) { |
|
30 | 30 | $global = true; |
31 | 31 | } else { |
32 | 32 | $global = false; |
@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | |
35 | 35 | if ($global) { |
36 | 36 | $temp_course_list = CourseManager :: get_courses_list(); |
37 | - foreach($temp_course_list as $temp_course_item) { |
|
37 | + foreach ($temp_course_list as $temp_course_item) { |
|
38 | 38 | $course_item = CourseManager ::get_course_information($temp_course_item['code']); |
39 | 39 | $course_list[] = array( |
40 | 40 | 'code' => $course_item['code'], |
@@ -47,14 +47,14 @@ discard block |
||
47 | 47 | } |
48 | 48 | |
49 | 49 | $new_course_select = array(); |
50 | -foreach($course_list as $data) { |
|
50 | +foreach ($course_list as $data) { |
|
51 | 51 | $new_course_select[$data['code']] = $data['title']; |
52 | 52 | } |
53 | 53 | |
54 | 54 | $form = new FormValidator('search_simple', 'POST', '', '', null, false); |
55 | -$form->addElement('select','course_code',get_lang('Course'), $new_course_select); |
|
55 | +$form->addElement('select', 'course_code', get_lang('Course'), $new_course_select); |
|
56 | 56 | if ($global) { |
57 | - $form->addElement('hidden','view','admin'); |
|
57 | + $form->addElement('hidden', 'view', 'admin'); |
|
58 | 58 | } else { |
59 | 59 | //Get exam lists |
60 | 60 | $course_id = api_get_course_int_id(); |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | ORDER BY quiz.title ASC"; |
65 | 65 | $resultExercices = Database::query($sqlExercices); |
66 | 66 | $exercise_list[0] = get_lang('All'); |
67 | - while($a_exercices = Database::fetch_array($resultExercices)) { |
|
67 | + while ($a_exercices = Database::fetch_array($resultExercices)) { |
|
68 | 68 | $exercise_list[$a_exercices['id']] = $a_exercices['title']; |
69 | 69 | } |
70 | 70 | $form->addElement('select', 'exercise_id', get_lang('Exercise'), $exercise_list); |
@@ -87,7 +87,7 @@ discard block |
||
87 | 87 | |
88 | 88 | echo '<div style="float:right"> <a href="'.api_get_self().'?export=1&score='.$filter_score.'&exercise_id='.$exercise_id.'"> |
89 | 89 | '.Display::return_icon('csv.gif').' |
90 | - '.get_lang('ExportAsCSV').'</a>' . |
|
90 | + '.get_lang('ExportAsCSV').'</a>'. |
|
91 | 91 | '<a href="javascript: void(0);" onclick="javascript: window.print()"> |
92 | 92 | '.Display::return_icon('printmgr.gif').' |
93 | 93 | '.get_lang('Print').'</a> |
@@ -101,10 +101,10 @@ discard block |
||
101 | 101 | } |
102 | 102 | $menu_items[] = get_lang('ExamTracking'); |
103 | 103 | $nb_menu_items = count($menu_items); |
104 | - if($nb_menu_items>1) { |
|
105 | - foreach($menu_items as $key=> $item) { |
|
104 | + if ($nb_menu_items > 1) { |
|
105 | + foreach ($menu_items as $key=> $item) { |
|
106 | 106 | echo $item; |
107 | - if($key!=$nb_menu_items-1) { |
|
107 | + if ($key != $nb_menu_items - 1) { |
|
108 | 108 | echo ' | '; |
109 | 109 | } |
110 | 110 | } |
@@ -128,7 +128,7 @@ discard block |
||
128 | 128 | $session_id = 0; |
129 | 129 | $user_list = array(); |
130 | 130 | // Getting course list |
131 | -foreach ($course_list as $current_course ) { |
|
131 | +foreach ($course_list as $current_course) { |
|
132 | 132 | $course_info = api_get_course_info($current_course['code']); |
133 | 133 | $_course = $course_info; |
134 | 134 | |
@@ -162,7 +162,7 @@ discard block |
||
162 | 162 | } |
163 | 163 | |
164 | 164 | if (!empty($user_list)) { |
165 | - foreach($user_list as $user_id) { |
|
165 | + foreach ($user_list as $user_id) { |
|
166 | 166 | $user_data = api_get_user_info($user_id); |
167 | 167 | $user_list_name[$user_id] = api_get_person_name( |
168 | 168 | $user_data['firstname'], |
@@ -170,7 +170,7 @@ discard block |
||
170 | 170 | ); |
171 | 171 | } |
172 | 172 | } |
173 | -$export_array = array(); |
|
173 | +$export_array = array(); |
|
174 | 174 | if (!empty($main_result)) { |
175 | 175 | |
176 | 176 | $html_result .= '<table class="data_table">'; |
@@ -193,9 +193,9 @@ discard block |
||
193 | 193 | |
194 | 194 | foreach ($exercises as $exercise_id => $exercise_data) { |
195 | 195 | $users = $exercise_data['users']; |
196 | - foreach($users as $user_id => $attempts) { |
|
196 | + foreach ($users as $user_id => $attempts) { |
|
197 | 197 | $attempt = 1; |
198 | - foreach($attempts as $exe_id => $attempt_data) { |
|
198 | + foreach ($attempts as $exe_id => $attempt_data) { |
|
199 | 199 | $html_result .= '<tr colspan="">'; |
200 | 200 | $html_result .= Display::tag('td', $course_code); |
201 | 201 | $html_result .= Display::tag('td', $lp_list_name[$lp_id]); |
@@ -222,7 +222,7 @@ discard block |
||
222 | 222 | } |
223 | 223 | } |
224 | 224 | } |
225 | - $html_result .='</table>'; |
|
225 | + $html_result .= '</table>'; |
|
226 | 226 | } |
227 | 227 | |
228 | 228 | if (!$export_to_csv) { |
@@ -75,13 +75,13 @@ discard block |
||
75 | 75 | // check if uid is tutor of this group |
76 | 76 | $courseId = api_get_course_int_id(); |
77 | 77 | |
78 | - if (( $is_allowedToTrack || $is_allowedToTrackEverybodyInCourse)) { |
|
78 | + if (($is_allowedToTrack || $is_allowedToTrackEverybodyInCourse)) { |
|
79 | 79 | if ($is_allowedToTrackEverybodyInCourse) { |
80 | 80 | $sql = "SELECT u.firstname,u.lastname, u.email |
81 | 81 | FROM $TABLECOURSUSER cu , $TABLEUSER u |
82 | 82 | WHERE |
83 | 83 | cu.user_id = u.user_id AND |
84 | - cu.relation_type<>" . COURSE_RELATION_TYPE_RRHH . " AND |
|
84 | + cu.relation_type<>".COURSE_RELATION_TYPE_RRHH." AND |
|
85 | 85 | cu.c_id = '$courseId' AND |
86 | 86 | u.user_id = '$uInfo'"; |
87 | 87 | } else { |
@@ -97,21 +97,21 @@ discard block |
||
97 | 97 | $res[2] == "" ? $res2 = get_lang('NoEmail') : $res2 = Display::encrypted_mailto_link($res[2]); |
98 | 98 | |
99 | 99 | echo "<tr><td>"; |
100 | - echo $informationsAbout . " : <br>"; |
|
100 | + echo $informationsAbout." : <br>"; |
|
101 | 101 | echo "<ul>\n" |
102 | - . "<li>" . get_lang('FirstName') . " : " . $res[0] . "</li>\n" |
|
103 | - . "<li>" . get_lang('LastName') . " : " . $res[1] . "</li>\n" |
|
104 | - . "<li>" . get_lang('Email') . " : " . $res2 . "</li>\n" |
|
102 | + . "<li>".get_lang('FirstName')." : ".$res[0]."</li>\n" |
|
103 | + . "<li>".get_lang('LastName')." : ".$res[1]."</li>\n" |
|
104 | + . "<li>".get_lang('Email')." : ".$res2."</li>\n" |
|
105 | 105 | . "</ul>"; |
106 | 106 | echo "</td></tr>"; |
107 | 107 | /* * ***** MENU ******* */ |
108 | 108 | echo "<tr> |
109 | 109 | <td> |
110 | - [<a href='userLog.php?uInfo=$uInfo&view=$view'>" . get_lang('Back') . "</a>] |
|
110 | + [<a href='userLog.php?uInfo=$uInfo&view=$view'>".get_lang('Back')."</a>] |
|
111 | 111 | "; |
112 | 112 | echo " || |
113 | - [<a href='" . api_get_self() . "?uInfo=$uInfo&view=$view&period=week&reqdate=$reqdate' class='specialLink'>" . get_lang('PeriodWeek') . "</a>] |
|
114 | - [<a href='" . api_get_self() . "?uInfo=$uInfo&view=$view&period=month&reqdate=$reqdate' class='specialLink'>" . get_lang('PeriodMonth') . "</a>] |
|
113 | + [<a href='" . api_get_self()."?uInfo=$uInfo&view=$view&period=week&reqdate=$reqdate' class='specialLink'>".get_lang('PeriodWeek')."</a>] |
|
114 | + [<a href='" . api_get_self()."?uInfo=$uInfo&view=$view&period=month&reqdate=$reqdate' class='specialLink'>".get_lang('PeriodMonth')."</a>] |
|
115 | 115 | || |
116 | 116 | "; |
117 | 117 | switch ($period) { |
@@ -120,8 +120,8 @@ discard block |
||
120 | 120 | $previousReqDate = $reqdate - 7 * 86400; |
121 | 121 | $nextReqDate = $reqdate + 7 * 86400; |
122 | 122 | echo " |
123 | - [<a href='" . api_get_self() . "?uInfo=$uInfo&view=$view&period=week&reqdate=$previousReqDate' class='specialLink'>" . get_lang('PreviousWeek') . "</a>] |
|
124 | - [<a href='" . api_get_self() . "?uInfo=$uInfo&view=$view&period=week&reqdate=$nextReqDate' class='specialLink'>" . get_lang('NextWeek') . "</a>] |
|
123 | + [<a href='" . api_get_self()."?uInfo=$uInfo&view=$view&period=week&reqdate=$previousReqDate' class='specialLink'>".get_lang('PreviousWeek')."</a>] |
|
124 | + [<a href='" . api_get_self()."?uInfo=$uInfo&view=$view&period=week&reqdate=$nextReqDate' class='specialLink'>".get_lang('NextWeek')."</a>] |
|
125 | 125 | "; |
126 | 126 | break; |
127 | 127 | default : |
@@ -132,8 +132,8 @@ discard block |
||
132 | 132 | $previousReqDate = mktime(1, 1, 1, date("m", $reqdate) - 1, 1, date("Y", $reqdate)); |
133 | 133 | $nextReqDate = mktime(1, 1, 1, date("m", $reqdate) + 1, 1, date("Y", $reqdate)); |
134 | 134 | echo " |
135 | - [<a href='" . api_get_self() . "?uInfo=$uInfo&view=$view&period=month&reqdate=$previousReqDate' class='specialLink'>" . get_lang('PreviousMonth') . "</a>] |
|
136 | - [<a href='" . api_get_self() . "?uInfo=$uInfo&view=$view&period=month&reqdate=$nextReqDate' class='specialLink'>" . get_lang('NextMonth') . "</a>] |
|
135 | + [<a href='" . api_get_self()."?uInfo=$uInfo&view=$view&period=month&reqdate=$previousReqDate' class='specialLink'>".get_lang('PreviousMonth')."</a>] |
|
136 | + [<a href='" . api_get_self()."?uInfo=$uInfo&view=$view&period=month&reqdate=$nextReqDate' class='specialLink'>".get_lang('NextMonth')."</a>] |
|
137 | 137 | "; |
138 | 138 | break; |
139 | 139 | } |
@@ -153,7 +153,7 @@ discard block |
||
153 | 153 | AND YEAR(access_date) = YEAR(FROM_UNIXTIME('$reqdate')) |
154 | 154 | GROUP BY DAYOFMONTH(access_date) |
155 | 155 | ORDER BY access_date ASC"; |
156 | - $displayedDate = $MonthsLong[date("n", $reqdate) - 1] . date(" Y", $reqdate); |
|
156 | + $displayedDate = $MonthsLong[date("n", $reqdate) - 1].date(" Y", $reqdate); |
|
157 | 157 | break; |
158 | 158 | case "week" : |
159 | 159 | $sql = "SELECT access_date |
@@ -165,24 +165,24 @@ discard block |
||
165 | 165 | GROUP BY DAYOFMONTH(access_date) |
166 | 166 | ORDER BY access_date ASC"; |
167 | 167 | $weeklowreqdate = ($reqdate - (86400 * date("w", $reqdate))); |
168 | - $weekhighreqdate = ($reqdate + (86400 * (6 - date("w", $reqdate)) )); |
|
169 | - $displayedDate = get_lang('From') . " " . date("d ", $weeklowreqdate) . $MonthsLong[date("n", $weeklowreqdate) - 1] . date(" Y", $weeklowreqdate) |
|
170 | - . " " . get_lang('To') . " " . date("d ", $weekhighreqdate) . $MonthsLong[date("n", $weekhighreqdate) - 1] . date(" Y", $weekhighreqdate); |
|
168 | + $weekhighreqdate = ($reqdate + (86400 * (6 - date("w", $reqdate)))); |
|
169 | + $displayedDate = get_lang('From')." ".date("d ", $weeklowreqdate).$MonthsLong[date("n", $weeklowreqdate) - 1].date(" Y", $weeklowreqdate) |
|
170 | + . " ".get_lang('To')." ".date("d ", $weekhighreqdate).$MonthsLong[date("n", $weekhighreqdate) - 1].date(" Y", $weekhighreqdate); |
|
171 | 171 | break; |
172 | 172 | } |
173 | 173 | echo "<tr><td>"; |
174 | 174 | $results = StatsUtils::getManyResults1Col($sql); |
175 | 175 | /* * * display of the displayed period ** */ |
176 | 176 | echo "<table width='100%' cellpadding='2' cellspacing='1' border='0' align=center>"; |
177 | - echo "<td bgcolor='#E6E6E6'>" . $displayedDate . "</td>"; |
|
177 | + echo "<td bgcolor='#E6E6E6'>".$displayedDate."</td>"; |
|
178 | 178 | if (is_array($results)) { |
179 | 179 | for ($j = 0; $j < sizeof($results); $j++) { |
180 | 180 | $beautifulDateTime = api_convert_and_format_date($results[$j], null, date_default_timezone_get()); |
181 | 181 | echo "<tr>"; |
182 | - echo "<td style='padding-left : 40px;' valign='top'>" . $beautifulDateTime . "</td>"; |
|
182 | + echo "<td style='padding-left : 40px;' valign='top'>".$beautifulDateTime."</td>"; |
|
183 | 183 | echo"</tr>"; |
184 | 184 | // $limit is used to select only results between $results[$j] (current login) and next one |
185 | - if ($j == ( sizeof($results) - 1 )) |
|
185 | + if ($j == (sizeof($results) - 1)) |
|
186 | 186 | $limit = date("Y-m-d H:i:s", $nextReqDate); |
187 | 187 | else |
188 | 188 | $limit = $results[$j + 1]; |
@@ -192,8 +192,8 @@ discard block |
||
192 | 192 | FROM $TABLETRACK_ACCESS |
193 | 193 | WHERE access_user_id = $uInfo |
194 | 194 | AND access_tool IS NOT NULL |
195 | - AND access_date > '" . $results[$j] . "' |
|
196 | - AND access_date < '" . $limit . "' |
|
195 | + AND access_date > '".$results[$j]."' |
|
196 | + AND access_date < '" . $limit."' |
|
197 | 197 | AND c_id = $courseId |
198 | 198 | GROUP BY access_tool |
199 | 199 | ORDER BY access_tool ASC"; |
@@ -204,8 +204,8 @@ discard block |
||
204 | 204 | echo "<table width='50%' cellpadding='0' cellspacing='0' border='0'>\n"; |
205 | 205 | for ($k = 0; $k < count($results2); $k++) { |
206 | 206 | echo "<tr>\n"; |
207 | - echo "<td width='70%' style='padding-left : 60px;'>" . get_lang($results2[$k][0]) . "</td>\n"; |
|
208 | - echo "<td width='30%' align='right' style='padding-right : 40px'>" . $results2[$k][1] . " " . get_lang('Visits') . "</td>\n"; |
|
207 | + echo "<td width='70%' style='padding-left : 60px;'>".get_lang($results2[$k][0])."</td>\n"; |
|
208 | + echo "<td width='30%' align='right' style='padding-right : 40px'>".$results2[$k][1]." ".get_lang('Visits')."</td>\n"; |
|
209 | 209 | echo "</tr>"; |
210 | 210 | } |
211 | 211 | echo "</table>\n"; |
@@ -215,7 +215,7 @@ discard block |
||
215 | 215 | } |
216 | 216 | } else { |
217 | 217 | echo "<tr>"; |
218 | - echo "<td colspan='2' bgcolor='#eeeeee'>" . get_lang('NoResult') . "</td>"; |
|
218 | + echo "<td colspan='2' bgcolor='#eeeeee'>".get_lang('NoResult')."</td>"; |
|
219 | 219 | echo "</tr>"; |
220 | 220 | } |
221 | 221 | echo "</table>"; |
@@ -182,10 +182,11 @@ |
||
182 | 182 | echo "<td style='padding-left : 40px;' valign='top'>" . $beautifulDateTime . "</td>"; |
183 | 183 | echo"</tr>"; |
184 | 184 | // $limit is used to select only results between $results[$j] (current login) and next one |
185 | - if ($j == ( sizeof($results) - 1 )) |
|
186 | - $limit = date("Y-m-d H:i:s", $nextReqDate); |
|
187 | - else |
|
188 | - $limit = $results[$j + 1]; |
|
185 | + if ($j == ( sizeof($results) - 1 )) { |
|
186 | + $limit = date("Y-m-d H:i:s", $nextReqDate); |
|
187 | + } else { |
|
188 | + $limit = $results[$j + 1]; |
|
189 | + } |
|
189 | 190 | // select all access to tool between displayed date and next displayed date or now() if |
190 | 191 | // displayed date is the last login date |
191 | 192 | $sql = "SELECT access_tool, count(access_tool) |
@@ -7,7 +7,6 @@ |
||
7 | 7 | * @author Sebastien Piraux |
8 | 8 | * |
9 | 9 | * @package chamilo.tracking |
10 | - |
|
11 | 10 | */ |
12 | 11 | /** |
13 | 12 | * Code |