1: <?php
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22: 23: 24: 25: 26: 27: 28:
29:
30: 31: 32: 33: 34: 35: 36:
37: function F_select_modules_sql($andwhere = '')
38: {
39: global $l;
40: require_once('../config/tce_config.php');
41: $sql = 'SELECT * FROM '.K_TABLE_MODULES.'';
42: if ($_SESSION['session_user_level'] >= K_AUTH_ADMINISTRATOR) {
43: if (!empty($andwhere)) {
44: $sql .= ' WHERE '.$andwhere;
45: }
46: } else {
47: $sql .= ' WHERE module_user_id IN ('.F_getAuthorizedUsers($_SESSION['session_user_id']).')';
48: if (!empty($andwhere)) {
49: $sql .= ' AND '.$andwhere;
50: }
51: }
52: $sql .= ' ORDER BY module_name';
53: return $sql;
54: }
55:
56: 57: 58: 59: 60: 61: 62:
63: function F_select_subjects_sql($andwhere = '')
64: {
65: return F_select_module_subjects_sql($andwhere);
66: }
67:
68: 69: 70: 71: 72: 73: 74:
75: function F_select_module_subjects_sql($andwhere = '')
76: {
77: global $l;
78: require_once('../config/tce_config.php');
79: $sql = 'SELECT * FROM '.K_TABLE_MODULES.','.K_TABLE_SUBJECTS.'';
80: $sql .= ' WHERE module_id=subject_module_id';
81: if ($_SESSION['session_user_level'] < K_AUTH_ADMINISTRATOR) {
82: $authorized_users = F_getAuthorizedUsers($_SESSION['session_user_id']);
83: $sql .= ' AND (module_user_id IN ('.$authorized_users.') OR subject_user_id IN ('.$authorized_users.'))';
84: }
85: if (!empty($andwhere)) {
86: $sql .= ' AND '.$andwhere;
87: }
88: $sql .= ' ORDER BY module_name,subject_name';
89: return $sql;
90: }
91:
92: 93: 94: 95: 96: 97:
98: function F_select_tests_sql()
99: {
100: global $l;
101: require_once('../config/tce_config.php');
102: $sql = 'SELECT * FROM '.K_TABLE_TESTS.'';
103: if ($_SESSION['session_user_level'] < K_AUTH_ADMINISTRATOR) {
104: $sql .= ' WHERE test_user_id IN ('.F_getAuthorizedUsers($_SESSION['session_user_id']).')';
105: }
106: $sql .= ' ORDER BY test_begin_time DESC, test_name';
107: return $sql;
108: }
109:
110: 111: 112: 113: 114: 115:
116: function F_select_executed_tests_sql()
117: {
118: global $l;
119: require_once('../config/tce_config.php');
120: $sql = 'SELECT *
121: FROM '.K_TABLE_TESTS.'
122: WHERE test_id IN (
123: SELECT testuser_test_id
124: FROM '.K_TABLE_TEST_USER.'
125: WHERE testuser_status>0
126: )';
127: if ($_SESSION['session_user_level'] < K_AUTH_ADMINISTRATOR) {
128: $sql .= ' AND test_user_id IN ('.F_getAuthorizedUsers($_SESSION['session_user_id']).')';
129: }
130: $sql .= ' ORDER BY test_begin_time DESC, test_name';
131: return $sql;
132: }
133:
134:
135:
136:
137: