SecuritySuite - SuiteCRM and CE Teams

function populateQuoteTemplates(){ global $app_list_strings, $current_user;

    **$sql = "SELECT id, name FROM aos_pdf_templates WHERE deleted=0 AND type='AOS_Quotes' AND active = 1";**

    $res = $this->bean->db->query($sql);

    $app_list_strings['template_ddown_c_list'] = array();
    while($row = $this->bean->db->fetchByAssoc($res)){
        if($row['id']){
            $app_list_strings['template_ddown_c_list'][$row['id']] = $row['name'];
        }
    }
}

function displayPopupHtml(){
    global $app_list_strings,$app_strings, $mod_strings;
    $templates = array_keys($app_list_strings['template_ddown_c_list']);
    if($templates){

    echo &#039; <div id="popupDiv_ara" style="display:none;position:fixed;top: 39%; left: 41%;opacity:1;z-index:9999;background:#FFFFFF;">
            <form id="popupForm" action="index.php?entryPoint=generatePdf" method="post">
            <table style="border: #000 solid 2px;padding-left:40px;padding-right:40px;padding-top:10px;padding-bottom:10px;font-size:110%;" >
                <tr height="20">
                    <td colspan="2">
                    <b>&#039;.$app_strings[&#039;LBL_SELECT_TEMPLATE&#039;].&#039;:-</b>
                    </td>
                </tr>&#039;;
        foreach($templates as $template){
            if(!$template){
                continue;

            }

...

}

I'm not good at formatting my posts here,...

Hi Mayer,

You would need to add the SecuritySuite logic to append some conditions to the SQL. An example that you can follow is in data/SugarBean.php->create_new_list_query(). Look for the Security Groups code block.