|
@@ 7405-7430 (lines=26) @@
|
| 7402 |
|
$where.=" WHERE s.session_admin_id = $user_id "; |
| 7403 |
|
} |
| 7404 |
|
|
| 7405 |
|
if (!empty($options['where'])) { |
| 7406 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7407 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7408 |
|
|
| 7409 |
|
$options['where'] = str_replace( |
| 7410 |
|
array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
| 7411 |
|
array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
| 7412 |
|
, $options['where'] |
| 7413 |
|
); |
| 7414 |
|
|
| 7415 |
|
$options['where'] = str_replace( |
| 7416 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7417 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7418 |
|
$options['where'] |
| 7419 |
|
); |
| 7420 |
|
|
| 7421 |
|
if (!empty($options['extra'])) { |
| 7422 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7423 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7424 |
|
|
| 7425 |
|
foreach ($options['extra'] as $extra) { |
| 7426 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7427 |
|
} |
| 7428 |
|
} |
| 7429 |
|
$where .= ' AND '.$options['where']; |
| 7430 |
|
} |
| 7431 |
|
|
| 7432 |
|
$today = api_get_utc_datetime(); |
| 7433 |
|
$query_rows = "SELECT count(*) as total_rows, c.title as course_title, s.name, |
|
@@ 7718-7744 (lines=27) @@
|
| 7715 |
|
c.title as course_title, |
| 7716 |
|
s.id "; |
| 7717 |
|
|
| 7718 |
|
if (!empty($options['where'])) { |
| 7719 |
|
if (!empty($options['extra'])) { |
| 7720 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7721 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7722 |
|
foreach ($options['extra'] as $extra) { |
| 7723 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7724 |
|
} |
| 7725 |
|
} |
| 7726 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7727 |
|
|
| 7728 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7729 |
|
|
| 7730 |
|
$options['where'] = str_replace( |
| 7731 |
|
array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
| 7732 |
|
array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
| 7733 |
|
, $options['where'] |
| 7734 |
|
); |
| 7735 |
|
|
| 7736 |
|
$options['where'] = str_replace( |
| 7737 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7738 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7739 |
|
$options['where'] |
| 7740 |
|
); |
| 7741 |
|
|
| 7742 |
|
|
| 7743 |
|
$where .= ' AND '.$options['where']; |
| 7744 |
|
} |
| 7745 |
|
|
| 7746 |
|
if (!empty($options['limit'])) { |
| 7747 |
|
$where .= " LIMIT ".$options['limit']; |
chamilo /
chamilo-lms
