<?php

// tracker item 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
        $itemid = getvar($db, 'iid', 'int');
		
        
		// 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 item caption / target
        $caption = '';
        $target = 0.00;
        
        $query = "SELECT trkr_caption, trkr_target FROM tracker WHERE trkr_id = " . $itemid;
        
        if ($result = $db->query($query))
        {
            $row = $result->fetch_assoc();
            
            $caption = $row['trkr_caption'];
            $target = $row['trkr_target'];
        }
		         
		// fetch tracker transactions
        $data = array();
        $total = 0.00;
        
		$query = "SELECT t.trkg_amt, p.per_per FROM tracking t LEFT JOIN periods p ON p.per_id = t.trkg_per WHERE t.trkg_tracker = " . $itemid;
		
		if ($result = $db->query($query))
		{
			while ($row = $result->fetch_assoc())
			{
				$data[] = array(
                    'period'   => $row['per_per'],
                    'amount'    => $row['trkg_amt']
                );
                
                $total += $row['trkg_amt'];
			}
		}
        
        $ct = count($data);
        
        
        require "ItemReportClass.php";
        
        
        $pdf = new PDF($client, $caption, '1,000,000.00', '2012');
        $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(50);
            
            $pdf->Cell(86, 5, $d['period'], 1, 0, 'L', $fill);
            $pdf->Cell(30, 5, number_format($d['amoumt'], 2), 1, 1, 'R', $fill);
            
            $fill = !$fill;
        }
        
        $pdf->SetFont('Arial', 'B', '9');
        $pdf->SetFillColor(225, 225, 225);
        $pdf->SetX(50);
        
        $pdf->Cell(86, 5, $ct . ' Transactions: ', 'LBT', 0, 'R', $fill);
        $pdf->Cell(30, 5, number_format($total, 2), 'LBRT', 0, 'R', $fill);
        
            
        $pdf->Output();
    }

?>