PHP SugarBean::add_team_security_where_clause方法代码示例

function get_message_scope_dom($campaign_id, $campaign_name, $db = null, $mod_strings = array())
{
    //find prospect list attached to this campaign..
    $query = "SELECT prospect_list_id, prospect_lists.name ";
    $query .= "FROM prospect_list_campaigns ";
    $query .= "INNER join prospect_lists on prospect_lists.id = prospect_list_campaigns.prospect_list_id ";
    // We need to confirm that the user is a member of the team of the item.
    $bean = new SugarBean();
    $bean->disable_row_level_security = false;
    $bean->add_team_security_where_clause($query, "prospect_lists");
    $query .= "WHERE prospect_lists.deleted = 0 ";
    $query .= "AND prospect_list_campaigns.deleted=0 ";
    $query .= "AND campaign_id='" . $campaign_id . "'";
    $query .= " and prospect_lists.list_type not like 'exempt%'";
    if (empty($db)) {
        $db = DBManagerFactory::getInstance();
    }
    if (empty($mod_strings) or !isset($mod_strings['LBL_DEFAULT'])) {
        global $current_language;
        $mod_strings = return_module_language($current_language, 'Campaigns');
    }
    //add campaign to the result array.
    //$return_array[$campaign_id]= $campaign_name . ' (' . $mod_strings['LBL_DEFAULT'] . ')';
    $result = $db->query($query);
    while (($row = $db->fetchByAssoc($result)) != null) {
        $return_array[$row['prospect_list_id']] = $row['name'];
    }
    if (empty($return_array)) {
        $return_array = array();
    } else {
        return $return_array;
    }
}

 /**
  * Builds up a metacollection of user/group folders to be passed to processor methods
  * @param object User object, defaults to $current_user
  * @return array Array of abstract folder objects
  */
 function retrieveFoldersForProcessing($user, $subscribed = true)
 {
     global $sugar_config;
     global $current_language, $current_user;
     $emails_mod_strings = return_module_language($current_language, "Emails");
     $myEmailTypeString = 'inbound';
     $myDraftsTypeString = 'draft';
     $mySentEmailTypeString = 'sent';
     if (empty($user)) {
         global $current_user;
         $user = $current_user;
     }
     $rootWhere = '';
     $teamSecurityClause = '';
     $bean = new SugarBean();
     $bean->disable_row_level_security = false;
     $bean->add_team_security_where_clause($teamSecurityClause, 'f');
     $bean->disable_row_level_security = true;
     $rootWhere .= "AND (f.parent_folder IS NULL OR f.parent_folder = '')";
     if ($subscribed) {
         $q = $this->coreSubscribed . $teamSecurityClause . $this->coreWhereSubscribed . "'{$user->id}' " . $rootWhere . $this->coreOrderBy;
     } else {
         $q = $this->core . $teamSecurityClause . $this->coreWhere . $rootWhere . $this->coreOrderBy;
     }
     $r = $this->db->query($q);
     $return = array();
     $found = array();
     while ($a = $this->db->fetchByAssoc($r, false)) {
         if (($a['folder_type'] == $myEmailTypeString || $a['folder_type'] == $myDraftsTypeString || $a['folder_type'] == $mySentEmailTypeString) && $a['created_by'] != $current_user->id) {
             continue;
         }
         // if
         if (!isset($found[$a['id']])) {
             $found[$a['id']] = true;
             $return[] = $a;
         }
     }
     return $return;
 }