<?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 period
        $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 tracker
        $data = array();
        
		$query = "SELECT t.trkr_id, t.trkr_caption, t.trkr_target, e.trkg_id, SUM(e.trkg_amt) as ytd FROM tracker AS t LEFT JOIN 
				  tracking AS e ON e.trkg_tracker = t.trkr_id" ;
		
		if ($result = $db->query($query))
		{
			if ($db->affected_rows > 0)
			{
				while ($row = $result->fetch_assoc())
				{
					$data[] = array(
                        'caption'   => $row['trkr_caption'],
                        'target'    => $row['trkr_target'],
                        'ytd'      => $row['ytd']
                    );
                    
                    $total += $row['fa_cost'];
				}
			}
		}
        
        require "SummaryReportClass.php";
        
        $pdf = new PDF($client, $per);
        $pdf->AliasNbPages();
        $pdf->SetDrawColor(150, 150, 150);
        $pdf->SetFillColor(242, 242, 242);
        $pdf->SetFont('Arial', '', '9');
        $pdf->AddPage();
        
        $fill = false;
        
        if (count($data) > 0)
        {
            foreach ($data as $d)
            {
                $pdf->SetX(40);
                
                $pdf->Cell(80, 5, $d['caption'], 1, 0, 'L', $fill);
                $pdf->Cell(30, 5, number_format($d['target'], 2), 1, 0, 'R', $fill);
                $pdf->Cell(30, 5, number_format($d['ytd'], 2), 1, 1, 'R', $fill);
                
                $fill = !$fill;
            }    
        }
        else
        {
            $pdf->SetFont('Arial', 'I', '9');
            $pdf->Ln(6);
            $pdf->SetX(40);
            
            $pdf->Cell(142, 5, '[ No Tracker Items found ]', 0, 0, "C");
        }
        
        
            
        $pdf->Output();
    }

?>