|
@@ 6928-6953 (lines=26) @@
|
| 6925 |
|
$where.=" WHERE s.session_admin_id = $user_id "; |
| 6926 |
|
} |
| 6927 |
|
|
| 6928 |
|
if (!empty($options['where'])) { |
| 6929 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 6930 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 6931 |
|
|
| 6932 |
|
$options['where'] = str_replace( |
| 6933 |
|
array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
| 6934 |
|
array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
| 6935 |
|
, $options['where'] |
| 6936 |
|
); |
| 6937 |
|
|
| 6938 |
|
$options['where'] = str_replace( |
| 6939 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 6940 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 6941 |
|
$options['where'] |
| 6942 |
|
); |
| 6943 |
|
|
| 6944 |
|
if (!empty($options['extra'])) { |
| 6945 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 6946 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 6947 |
|
|
| 6948 |
|
foreach ($options['extra'] as $extra) { |
| 6949 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 6950 |
|
} |
| 6951 |
|
} |
| 6952 |
|
$where .= ' AND '.$options['where']; |
| 6953 |
|
} |
| 6954 |
|
|
| 6955 |
|
$today = api_get_utc_datetime(); |
| 6956 |
|
$query_rows = "SELECT count(*) as total_rows, c.title as course_title, s.name, |
|
@@ 7234-7260 (lines=27) @@
|
| 7231 |
|
c.title as course_title, |
| 7232 |
|
s.id "; |
| 7233 |
|
|
| 7234 |
|
if (!empty($options['where'])) { |
| 7235 |
|
if (!empty($options['extra'])) { |
| 7236 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7237 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7238 |
|
foreach ($options['extra'] as $extra) { |
| 7239 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7240 |
|
} |
| 7241 |
|
} |
| 7242 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7243 |
|
|
| 7244 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7245 |
|
|
| 7246 |
|
$options['where'] = str_replace( |
| 7247 |
|
array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
| 7248 |
|
array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
| 7249 |
|
, $options['where'] |
| 7250 |
|
); |
| 7251 |
|
|
| 7252 |
|
$options['where'] = str_replace( |
| 7253 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7254 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7255 |
|
$options['where'] |
| 7256 |
|
); |
| 7257 |
|
|
| 7258 |
|
|
| 7259 |
|
$where .= ' AND '.$options['where']; |
| 7260 |
|
} |
| 7261 |
|
|
| 7262 |
|
if (!empty($options['limit'])) { |
| 7263 |
|
$where .= " LIMIT ".$options['limit']; |
chamilo /
chamilo-lms
