www.hkvforums.com

function ListOptions_Load() {
    global $flighttable;
	global $actypes;
//  Find all AC types to be listed on output 
//  - use Activated types and those with a report code > 0
	$Mysql  = "SELECT Code1, Value1 FROM parameters WHERE (Type = 'ACTYPE' AND Value1 <> 0 " ; 
	$Mysql .= " AND Activated = 'Y' ) ORDER by Value1" ;                                  
	$rswrk = ExecuteRows($Mysql);
	$i = 1;
//   Store codes in Header
    foreach ($rswrk as $x)
      {
   	    $this->ListOptions->Add($i);
		$this->ListOptions->Items[$i]->Header = $x["Code1"];
        $actypes[$i] = $x["Code1"];
        $i++;
      }
//   save number of entries
    $flighttable['counter'] = $i;

// ListOptions Rendered event
function ListOptions_Rendered()
{
    // Example:
    //$this->ListOptions["new"]->Body = "xxx";

global $flighttable;
global $actypes; 

//    Shade alternate lines on list
	      for ($cntwrk = 1; $cntwrk < $flighttable['counter'];$cntwrk++)
		  {
               $cntwrk2 = fmod($cntwrk,2);
               if ($cntwrk2 == 1) $this->ListOptions->Items[$cntwrk]->CssStyle = "background-color: #00aaaa"; 
                 }
         $m = "PAULM";
//      $m =  $this->Fields['Username']->CurrentValue;
//      $m = getUsername();
//      $m = $GLOBALS["activebal"]->Username->CurrentValue;

        $Mysql  = "SELECT Permission, Actype FROM permissions WHERE (Activated = 'Y' AND Member =  '";
        $Mysql .= $m . "') ORDER BY Actype ";
    	$rswrk = ExecuteRows($Mysql);
  	foreach ($rswrk as $x)
	 {
       for ($cntwrk = 1; $cntwrk < $flighttable['counter'];$cntwrk++)
        {
	    	if ($actypes[$cntwrk] == $x["Actype"])
	    	  {
        		$this->ListOptions->Items[$cntwrk]->Body = $x["Permission"];
	    	  }
        } 	
	 } 
}