<?php
$condition_session = api_get_session_condition(
 $session_id,
 true,
 true,
 'announcement.session_id'
);
if (api_get_group_id() == 0) {
 $group_condition = '';
} else {
 $group_condition = " AND (ip.to_group_id='".api_get_group_id()."' OR ip.to_group_id = 0 OR ip.to_group_id IS NULL)";
}
$sql = "SELECT 
 announcement.*, 
 ip.visibility, 
 ip.to_group_id, 
 ip.insert_user_id
 FROM $tbl_announcement announcement 
 INNER JOIN $tbl_item_property ip
 ON (announcement.c_id = ip.c_id AND announcement.id = ip.ref)
 WHERE
 announcement.c_id = $courseId AND
 ip.c_id = $courseId AND 
 ip.tool = 'announcement' AND
 ip.visibility <> '2'
$group_condition
$condition_session
 GROUP BY ip.ref
 ORDER BY display_order DESC
 LIMIT 0, $maximum";

Steps:

1. AbstractResource

<?php
namespace Chamilo\CourseBundle\Entity;
class CAnnouncement extends AbstractResource implements ResourceInterface
{
}

2. ResourceRepository

<?php
namespace Chamilo\CourseBundle\Repository;
use Chamilo\CourseBundle\Entity\CAnnouncement;
use Doctrine\Persistence\ManagerRegistry;
final class CAnnouncementRepository extends ResourceRepository
{
 public function __construct(ManagerRegistry $registry)
 {
 parent::__construct($registry, CAnnouncement::class);
 }
}

3. Declare the tool in the Container class

<?php
namespace Chamilo\CoreBundle\Framework;
class Container
{
 /**
 * @return CAnnouncementRepository
 */
 public static function getAnnouncementRepository()
 {
 return self::$container->get('Chamilo\CourseBundle\Repository\CAnnouncementRepository');
 }

4. Change legacy code to v2 code

 $sql = "SELECT $select
 FROM $tbl_announcement announcement
 INNER JOIN $tbl_item_property ip
 ON (announcement.id = ip.ref AND ip.c_id = announcement.c_id)
 WHERE
 announcement.c_id = $courseId AND
 ip.c_id = $courseId AND
 ip.tool = 'announcement' AND
 (
 ip.to_user_id = $user_id OR
 ip.to_group_id IS NULL OR
 ip.to_group_id IN (0, ".implode(", ", $group_memberships).")
 ) AND
 ip.visibility IN ('1', '0')
$condition_session
$searchCondition
 ORDER BY display_order DESC";

<?php
 $repo = Container::getAnnouncementRepository();
 $course = api_get_course_entity($courseId);
 $session = api_get_session_entity($session_id);
 $group = api_get_group_entity(api_get_group_id());
 $qb = $repo->getResourcesByCourse($course, $session, $group);
 $qb->select('count(resource)');
 $count = $qb->getQuery()->getSingleScalarResult();

Create a new Resource.

<?php
 $params = [
 'c_id' => $courseId,
 'content' => $newContent,
 'title' => $title,
 'end_date' => $end_date,
 'display_order' => $order,
 'session_id' => (int) $sessionId,
 ];
 $last_id = Database::insert($tbl_announcement, $params);

<?php
 $course = api_get_course_entity($courseId);
 $session = api_get_session_entity($sessionId);
 $announcement = new CAnnouncement();
 $announcement
 ->setContent($newContent)
 ->setTitle($title)
 ->setEndDate(new DateTime($end_date))
 ->setDisplayOrder($order)
 ->setParent($course)
 ->addCourseLink($course, $session)
 ;
 $repo = Container::getAnnouncementRepository();
 $repo->create($announcement);

Update a Resource.

<?php
 $repo = Container::getAnnouncementRepository();
 $announcement = $repo->find($id);
 /** @var CStudentPublication $announcement */
 if ($announcement) {
 $announcement->setTitle('new title');
 $repo->update($announcement);
 }