SugarCRM: Visibility: Modify SQL

custom__data__visibility__YourVisibilityClass.php

<?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
class YourVisibilityClass extends SugarVisibility{
    protected  $bean;
    public function __construct($bean)
    {
        $this->bean = $bean;
        $this->module_dir = $this->bean->module_dir;
    }
    public function addVisibilityWhereQuery(SugarQuery $sugarQuery, $options = array())
    {
        global $current_user, $timedate;
        $aclRole = new ACLRole();
        $rolesNames = $aclRole->getUserRoleNames($current_user->id); //
        $where = null;
        //$GLOBALS['log']->fatal('Tasks_By_Day_Mobile::addVisibilityWhere:: llamando al where personalizado'.print_r($sugarQuery,true));
        if( count($rolesNames) && in_array('Salesman', $rolesNames) ){
            $meeting_dateStart = new SugarDateTime();
            $meeting_dateEnd = new SugarDateTime();
            $dateStart = $timedate->tzUser($meeting_dateStart, $current_user)->setTime('00','00','00')->asDb();
            $dateEnd = $timedate->tzUser($meeting_dateEnd, $current_user)->setTime('23','59','59')->asDb();
            $sugarQuery->where()->between('date_start', $dateStart, $dateEnd);
        }
        //$GLOBALS['log']->fatal("query ".$sugarQuery->compileSql());
        return $sugarQuery;
    }
}       

custom__Extension__modules__Tasks__Ext__Vardefs__your_module_ext_visibility.php

<?php
$dictionary['Task']['visibility'] = array(
    "YourVisibilityClass" => true,
);