|
@@ 7239-7264 (lines=26) @@
|
| 7236 |
|
$where.=" WHERE s.session_admin_id = $user_id "; |
| 7237 |
|
} |
| 7238 |
|
|
| 7239 |
|
if (!empty($options['where'])) { |
| 7240 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7241 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7242 |
|
|
| 7243 |
|
$options['where'] = str_replace( |
| 7244 |
|
array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
| 7245 |
|
array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
| 7246 |
|
, $options['where'] |
| 7247 |
|
); |
| 7248 |
|
|
| 7249 |
|
$options['where'] = str_replace( |
| 7250 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7251 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7252 |
|
$options['where'] |
| 7253 |
|
); |
| 7254 |
|
|
| 7255 |
|
if (!empty($options['extra'])) { |
| 7256 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7257 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7258 |
|
|
| 7259 |
|
foreach ($options['extra'] as $extra) { |
| 7260 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7261 |
|
} |
| 7262 |
|
} |
| 7263 |
|
$where .= ' AND '.$options['where']; |
| 7264 |
|
} |
| 7265 |
|
|
| 7266 |
|
$today = api_get_utc_datetime(); |
| 7267 |
|
$query_rows = "SELECT count(*) as total_rows, c.title as course_title, s.name, |
|
@@ 7544-7570 (lines=27) @@
|
| 7541 |
|
c.title as course_title, |
| 7542 |
|
s.id "; |
| 7543 |
|
|
| 7544 |
|
if (!empty($options['where'])) { |
| 7545 |
|
if (!empty($options['extra'])) { |
| 7546 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7547 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7548 |
|
foreach ($options['extra'] as $extra) { |
| 7549 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7550 |
|
} |
| 7551 |
|
} |
| 7552 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7553 |
|
|
| 7554 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7555 |
|
|
| 7556 |
|
$options['where'] = str_replace( |
| 7557 |
|
array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
| 7558 |
|
array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
| 7559 |
|
, $options['where'] |
| 7560 |
|
); |
| 7561 |
|
|
| 7562 |
|
$options['where'] = str_replace( |
| 7563 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7564 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7565 |
|
$options['where'] |
| 7566 |
|
); |
| 7567 |
|
|
| 7568 |
|
|
| 7569 |
|
$where .= ' AND '.$options['where']; |
| 7570 |
|
} |
| 7571 |
|
|
| 7572 |
|
if (!empty($options['limit'])) { |
| 7573 |
|
$where .= " LIMIT ".$options['limit']; |
chamilo /
chamilo-lms
