|
@@ 7523-7548 (lines=26) @@
|
| 7520 |
|
$where .= " WHERE s.session_admin_id = $user_id "; |
| 7521 |
|
} |
| 7522 |
|
|
| 7523 |
|
if (!empty($options['where'])) { |
| 7524 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7525 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7526 |
|
|
| 7527 |
|
$options['where'] = str_replace( |
| 7528 |
|
array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
| 7529 |
|
array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 ") |
| 7530 |
|
, $options['where'] |
| 7531 |
|
); |
| 7532 |
|
|
| 7533 |
|
$options['where'] = str_replace( |
| 7534 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7535 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7536 |
|
$options['where'] |
| 7537 |
|
); |
| 7538 |
|
|
| 7539 |
|
if (!empty($options['extra'])) { |
| 7540 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7541 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7542 |
|
|
| 7543 |
|
foreach ($options['extra'] as $extra) { |
| 7544 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7545 |
|
} |
| 7546 |
|
} |
| 7547 |
|
$where .= ' AND '.$options['where']; |
| 7548 |
|
} |
| 7549 |
|
|
| 7550 |
|
$today = api_get_utc_datetime(); |
| 7551 |
|
$query_rows = "SELECT count(*) as total_rows, c.title as course_title, s.name, |
|
@@ 7889-7915 (lines=27) @@
|
| 7886 |
|
c.title as course_title, |
| 7887 |
|
s.id "; |
| 7888 |
|
|
| 7889 |
|
if (!empty($options['where'])) { |
| 7890 |
|
if (!empty($options['extra'])) { |
| 7891 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7892 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7893 |
|
foreach ($options['extra'] as $extra) { |
| 7894 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7895 |
|
} |
| 7896 |
|
} |
| 7897 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7898 |
|
|
| 7899 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7900 |
|
|
| 7901 |
|
$options['where'] = str_replace( |
| 7902 |
|
array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
| 7903 |
|
array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 ") |
| 7904 |
|
, $options['where'] |
| 7905 |
|
); |
| 7906 |
|
|
| 7907 |
|
$options['where'] = str_replace( |
| 7908 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7909 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7910 |
|
$options['where'] |
| 7911 |
|
); |
| 7912 |
|
|
| 7913 |
|
|
| 7914 |
|
$where .= ' AND '.$options['where']; |
| 7915 |
|
} |
| 7916 |
|
|
| 7917 |
|
if (!empty($options['limit'])) { |
| 7918 |
|
$where .= " LIMIT ".$options['limit']; |
chamilo /
chamilo-lms
