<?php

// fixed asset report

	// init database name
	$database = DB_PREFIX;	
	
	
	// process request
	if ($sid != '')
	{
	    // sid check
		require "includes/session/sidck.php";
        
	
		// fetch database name / open db
		$dbn = '';
        if ( isset($_POST['db']) ) $dbn = $_POST['db'];
		if ( isset($_GET['db']) ) $dbn = $_GET['db'];
		
		if ($dbn == '') die();
		
		$database .= $dbn;
		
		require "includes/db.php";
        
        
        // get params
        $per = getvar($db, 'per', 'string');
		
        
		// fetch client name
        $client = '';
        
        $query = "SELECT cli_sortname FROM client";
        
        if ($result = $db->query($query))
        {
            $row = $result->fetch_assoc();
            
            $client = $row['cli_sortname'];    
        }
		 
               
        
		// fetch assets
        $data = array();
        
		$query = "SELECT inot_note FROM notes_internal WHERE inot_active = 1" ;
		
		if ($result = $db->query($query))
		{
			if ($db->affected_rows > 0)
			{
				while ($row = $result->fetch_assoc())
				{
					$data[] = array(
                        'note'      => $row['inot_note']
                    );
				}
			}
		}
        
        require "ReportClass.php";
        
        $pdf = new PDF($client, true, $per);
        $pdf->AliasNbPages();
        $pdf->SetDrawColor(150, 150, 150);
        $pdf->SetFillColor(242, 242, 242);
        $pdf->SetFont('Arial', '', '9');
        $pdf->AddPage();
        
        $fill = false;
        foreach ($data as $d)
        {
            $pdf->SetX(30);
            
            $pdf->MultiCell(175, 5, $d['note'], "B", "L", $fill);
            
            $fill = !$fill;
        }
        
            
        $pdf->Output();
    }

?>