|
@@ 7302-7327 (lines=26) @@
|
| 7299 |
|
$where.=" WHERE s.session_admin_id = $user_id "; |
| 7300 |
|
} |
| 7301 |
|
|
| 7302 |
|
if (!empty($options['where'])) { |
| 7303 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7304 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7305 |
|
|
| 7306 |
|
$options['where'] = str_replace( |
| 7307 |
|
array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
| 7308 |
|
array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
| 7309 |
|
, $options['where'] |
| 7310 |
|
); |
| 7311 |
|
|
| 7312 |
|
$options['where'] = str_replace( |
| 7313 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7314 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7315 |
|
$options['where'] |
| 7316 |
|
); |
| 7317 |
|
|
| 7318 |
|
if (!empty($options['extra'])) { |
| 7319 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7320 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7321 |
|
|
| 7322 |
|
foreach ($options['extra'] as $extra) { |
| 7323 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7324 |
|
} |
| 7325 |
|
} |
| 7326 |
|
$where .= ' AND '.$options['where']; |
| 7327 |
|
} |
| 7328 |
|
|
| 7329 |
|
$today = api_get_utc_datetime(); |
| 7330 |
|
$query_rows = "SELECT count(*) as total_rows, c.title as course_title, s.name, |
|
@@ 7607-7633 (lines=27) @@
|
| 7604 |
|
c.title as course_title, |
| 7605 |
|
s.id "; |
| 7606 |
|
|
| 7607 |
|
if (!empty($options['where'])) { |
| 7608 |
|
if (!empty($options['extra'])) { |
| 7609 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7610 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7611 |
|
foreach ($options['extra'] as $extra) { |
| 7612 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7613 |
|
} |
| 7614 |
|
} |
| 7615 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7616 |
|
|
| 7617 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7618 |
|
|
| 7619 |
|
$options['where'] = str_replace( |
| 7620 |
|
array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
| 7621 |
|
array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
| 7622 |
|
, $options['where'] |
| 7623 |
|
); |
| 7624 |
|
|
| 7625 |
|
$options['where'] = str_replace( |
| 7626 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7627 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7628 |
|
$options['where'] |
| 7629 |
|
); |
| 7630 |
|
|
| 7631 |
|
|
| 7632 |
|
$where .= ' AND '.$options['where']; |
| 7633 |
|
} |
| 7634 |
|
|
| 7635 |
|
if (!empty($options['limit'])) { |
| 7636 |
|
$where .= " LIMIT ".$options['limit']; |
chamilo /
chamilo-lms
