chamilo /
chamilo-lms
| @@ 1515-1526 (lines=12) @@ | ||
| 1512 | ip.lastedit_user_id = '".$user_id."' OR ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".$group_id.") |
|
| 1513 | )"; |
|
| 1514 | } |
|
| 1515 | } else { |
|
| 1516 | if (api_get_group_id() == 0) { |
|
| 1517 | $cond_user_id = " AND ( |
|
| 1518 | ip.to_user_id=$user_id OR (ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".implode(", ", $group_memberships).")) |
|
| 1519 | ) "; |
|
| 1520 | } else { |
|
| 1521 | $cond_user_id = " AND ( |
|
| 1522 | ip.to_user_id=$user_id OR (ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".api_get_group_id().")) |
|
| 1523 | )"; |
|
| 1524 | } |
|
| 1525 | } |
|
| 1526 | ||
| 1527 | $sql = "SELECT $select |
|
| 1528 | FROM $tbl_announcement announcement, |
|
| 1529 | $tbl_item_property ip |
|
| @@ 1473-1479 (lines=7) @@ | ||
| 1470 | if (api_is_allowed_to_edit()) { |
|
| 1471 | if (!empty($groupId)) { |
|
| 1472 | $where_condition = "( ip.to_group_id IN (".implode(", ", $group_memberships).") ) "; |
|
| 1473 | } else { |
|
| 1474 | if (!empty($user_id)) { |
|
| 1475 | $where_condition = "( ip.to_user_id = $user_id OR ip.to_user_id IS NULL OR (ip.to_group_id IN (0, ".implode(", ", $group_memberships).")) ) "; |
|
| 1476 | } else { |
|
| 1477 | $where_condition = "( ip.to_group_id IN (0, ".implode(", ", $group_memberships).") ) "; |
|
| 1478 | } |
|
| 1479 | } |
|
| 1480 | } else { |
|
| 1481 | $where_condition = "( ip.to_user_id = $user_id OR ip.to_user_id IS NULL OR (ip.to_group_id IN (0, ".implode(", ", $group_memberships).")) ) "; |
|
| 1482 | } |
|
