|
@@ 7167-7192 (lines=26) @@
|
| 7164 |
|
$where.=" WHERE s.session_admin_id = $user_id "; |
| 7165 |
|
} |
| 7166 |
|
|
| 7167 |
|
if (!empty($options['where'])) { |
| 7168 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7169 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7170 |
|
|
| 7171 |
|
$options['where'] = str_replace( |
| 7172 |
|
array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
| 7173 |
|
array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
| 7174 |
|
, $options['where'] |
| 7175 |
|
); |
| 7176 |
|
|
| 7177 |
|
$options['where'] = str_replace( |
| 7178 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7179 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7180 |
|
$options['where'] |
| 7181 |
|
); |
| 7182 |
|
|
| 7183 |
|
if (!empty($options['extra'])) { |
| 7184 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7185 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7186 |
|
|
| 7187 |
|
foreach ($options['extra'] as $extra) { |
| 7188 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7189 |
|
} |
| 7190 |
|
} |
| 7191 |
|
$where .= ' AND '.$options['where']; |
| 7192 |
|
} |
| 7193 |
|
|
| 7194 |
|
$today = api_get_utc_datetime(); |
| 7195 |
|
$query_rows = "SELECT count(*) as total_rows, c.title as course_title, s.name, |
|
@@ 7472-7498 (lines=27) @@
|
| 7469 |
|
c.title as course_title, |
| 7470 |
|
s.id "; |
| 7471 |
|
|
| 7472 |
|
if (!empty($options['where'])) { |
| 7473 |
|
if (!empty($options['extra'])) { |
| 7474 |
|
$options['where'] = str_replace(' 1 = 1 AND', '', $options['where']); |
| 7475 |
|
$options['where'] = str_replace('AND', 'OR', $options['where']); |
| 7476 |
|
foreach ($options['extra'] as $extra) { |
| 7477 |
|
$options['where'] = str_replace($extra['field'], 'fv.field_id = '.$extra['id'].' AND fvo.option_value', $options['where']); |
| 7478 |
|
} |
| 7479 |
|
} |
| 7480 |
|
$options['where'] = str_replace('course_title', 'c.title', $options['where']); |
| 7481 |
|
|
| 7482 |
|
$options['where'] = str_replace("( session_active = '0' )", '1=1', $options['where']); |
| 7483 |
|
|
| 7484 |
|
$options['where'] = str_replace( |
| 7485 |
|
array("AND session_active = '1' )", " AND ( session_active = '1' )"), |
| 7486 |
|
array(') GROUP BY s.name HAVING session_active = 1 ', " GROUP BY s.name HAVING session_active = 1 " ) |
| 7487 |
|
, $options['where'] |
| 7488 |
|
); |
| 7489 |
|
|
| 7490 |
|
$options['where'] = str_replace( |
| 7491 |
|
array("AND session_active = '0' )", " AND ( session_active = '0' )"), |
| 7492 |
|
array(') GROUP BY s.name HAVING session_active = 0 ', " GROUP BY s.name HAVING session_active = '0' "), |
| 7493 |
|
$options['where'] |
| 7494 |
|
); |
| 7495 |
|
|
| 7496 |
|
|
| 7497 |
|
$where .= ' AND '.$options['where']; |
| 7498 |
|
} |
| 7499 |
|
|
| 7500 |
|
if (!empty($options['limit'])) { |
| 7501 |
|
$where .= " LIMIT ".$options['limit']; |
chamilo /
chamilo-lms
