Manifest Utils Directive in a SugarCRM Module - Function

contract_products_utils.php

// /extensions/application/utils/contract_products_utils.php
function getProducts(){
   static $products = null;
   if(!$products){
      global $db;
      
      $query = "SELECT id, name FROM products where deleted = 0 order by name asc ";
      
      $result = $db->query($query, false);

      $products = array();
      $products[''] = '';

      while (($row = $db->fetchByAssoc($result)) != null) {
         $products[$row['id']] = $row['name'];
      }

   }
   return $products;
}