|
@@ 7274-7299 (lines=26) @@
|
| 7271 |
|
$where.=" WHERE s.session_admin_id = $user_id "; |
| 7272 |
|
} |
| 7273 |
|
|
| 7274 |
|
if (!empty($options['where'])) { |
| 7275 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7276 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7277 |
|
|
| 7278 |
|
$options['where'] = str_replace( |
| 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 " ) |
| 7281 |
|
, $options['where'] |
| 7282 |
|
); |
| 7283 |
|
|
| 7284 |
|
$options['where'] = str_replace( |
| 7285 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7286 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7287 |
|
$options['where'] |
| 7288 |
|
); |
| 7289 |
|
|
| 7290 |
|
if (!empty($options['extra'])) { |
| 7291 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7292 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7293 |
|
|
| 7294 |
|
foreach ($options['extra'] as $extra) { |
| 7295 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7296 |
|
} |
| 7297 |
|
} |
| 7298 |
|
$where .= ' AND '.$options['where']; |
| 7299 |
|
} |
| 7300 |
|
|
| 7301 |
|
$today = api_get_utc_datetime(); |
| 7302 |
|
$query_rows = "SELECT count(*) as total_rows, c.title as course_title, s.name, |
|
@@ 7579-7605 (lines=27) @@
|
| 7576 |
|
c.title as course_title, |
| 7577 |
|
s.id "; |
| 7578 |
|
|
| 7579 |
|
if (!empty($options['where'])) { |
| 7580 |
|
if (!empty($options['extra'])) { |
| 7581 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7582 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7583 |
|
foreach ($options['extra'] as $extra) { |
| 7584 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7585 |
|
} |
| 7586 |
|
} |
| 7587 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7588 |
|
|
| 7589 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7590 |
|
|
| 7591 |
|
$options['where'] = str_replace( |
| 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 " ) |
| 7594 |
|
, $options['where'] |
| 7595 |
|
); |
| 7596 |
|
|
| 7597 |
|
$options['where'] = str_replace( |
| 7598 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7599 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7600 |
|
$options['where'] |
| 7601 |
|
); |
| 7602 |
|
|
| 7603 |
|
|
| 7604 |
|
$where .= ' AND '.$options['where']; |
| 7605 |
|
} |
| 7606 |
|
|
| 7607 |
|
if (!empty($options['limit'])) { |
| 7608 |
|
$where .= " LIMIT ".$options['limit']; |
chamilo /
chamilo-lms
