<?php

/**
 * included file - draw chart: ytd expense pie
 */
 
 
    // init
    $grdata3 = array();
    
    $captions3 = array();
    $values3 = array();
    
    
    
    
    
    
    // fetch data
    $query = "SELECT SUM(j.jrnl_in_cogs) as cogs, (SUM(j.jrnl_oh_0) + SUM(j.jrnl_oh_1) + SUM(j.jrnl_oh_2) + SUM(j.jrnl_oh_3) + 
				 SUM(j.jrnl_oh_4) + SUM(j.jrnl_oh_5) + SUM(j.jrnl_oh_6) + SUM(j.jrnl_oh_7) + SUM(j.jrnl_oh_8)) as oh, 
				 (SUM(j.jrnl_la_0) + SUM(j.jrnl_la_1) + SUM(j.jrnl_la_2) + SUM(j.jrnl_la_3) + SUM(j.jrnl_la_4) + 
				 SUM(j.jrnl_la_5) + SUM(j.jrnl_la_6) + SUM(j.jrnl_la_7)) as la,
				 (SUM(j.jrnl_op_0) + SUM(j.jrnl_op_1) + SUM(j.jrnl_op_2) + SUM(j.jrnl_op_3) + SUM(j.jrnl_op_4) + 
				 SUM(j.jrnl_op_5) + SUM(j.jrnl_op_6) + SUM(j.jrnl_op_7) + SUM(j.jrnl_op_8) + SUM(j.jrnl_op_9) + 
				 SUM(j.jrnl_op_10) + SUM(j.jrnl_op_11) + SUM(j.jrnl_op_12) + SUM(j.jrnl_op_13) + SUM(j.jrnl_op_14) + 
				 SUM(j.jrnl_op_15) + SUM(j.jrnl_op_16) + SUM(j.jrnl_op_17) + SUM(j.jrnl_op_18) + SUM(j.jrnl_op_19)) AS op,
				 (SUM(j.jrnl_in_cogs) + SUM(j.jrnl_oh_0) + SUM(j.jrnl_oh_1) + SUM(j.jrnl_oh_2) + SUM(j.jrnl_oh_3) + 
				 SUM(j.jrnl_oh_4) + SUM(j.jrnl_oh_5) + SUM(j.jrnl_oh_6) + SUM(j.jrnl_oh_7) + SUM(j.jrnl_oh_8) +  
				 SUM(j.jrnl_la_0) + SUM(j.jrnl_la_1) + SUM(j.jrnl_la_2) + SUM(j.jrnl_la_3) + SUM(j.jrnl_la_4) + 
				 SUM(j.jrnl_la_5) + SUM(j.jrnl_la_6) + SUM(j.jrnl_la_7) + 
				 SUM(j.jrnl_op_0) + SUM(j.jrnl_op_1) + SUM(j.jrnl_op_2) + SUM(j.jrnl_op_3) + SUM(j.jrnl_op_4) + 
				 SUM(j.jrnl_op_5) + SUM(j.jrnl_op_6) + SUM(j.jrnl_op_7) + SUM(j.jrnl_op_8) + SUM(j.jrnl_op_9) + 
				 SUM(j.jrnl_op_10) + SUM(j.jrnl_op_11) + SUM(j.jrnl_op_12) + SUM(j.jrnl_op_13) + SUM(j.jrnl_op_14) + 
				 SUM(j.jrnl_op_15) + SUM(j.jrnl_op_16) + SUM(j.jrnl_op_17) + SUM(j.jrnl_op_18) + SUM(j.jrnl_op_19)) as total
				 FROM journal j LEFT JOIN periods p ON p.per_id = j.jrnl_per
				 WHERE j.jrnl_per IN (SELECT per_id FROM periods WHERE per_yr = (SELECT per_yr FROM periods WHERE per_id = " . $pid . ")) 
                 ORDER BY j.jrnl_id ASC";

    
    if ($result = $db->query($query))
    {
        $i = 1;
        
        $row = $result->fetch_assoc();
        
        $values3[0] = $row['total'];
        
        if ($row['cogs'] != 0.00)
        {
            $captions3[$i] = $data['in_cogs']['cap'];
            $values3[$i] = $row['cogs'];
            
            $i++;
        }
        
        if ($row['oh'] != 0.00)
        {
            $captions3[$i] = 'Overhead Costs';
            $values3[$i] = $row['oh'];
            
            $i++;
        }
        
        if ($row['la'] != 0.00)
        {
            $captions3[$i] = 'Labor Costs';
            $values3[$i] = $row['la'];
            
            $i++;
        }
        
        if ($row['op'] != 0.00)
        {
            $captions3[$i] = 'Operating Costs';
            $values3[$i] = $row['op'];
            
            $i++;
        }
    }
    
           
    
    // build output array
    for ($i = 0; $i < $mos_year; $i++)
    {
        $grdata3[$i] = $values3;
    }


    // create graph / save as jpg
    include_once(includePath() . "phplot.php");
    
    $file = clientPath() . $dbn . '/tmp_expense.jpg';
    
    $graph = new PHPlot(500, 260, $file);
    $graph->SetPlotType('pie');
    $graph->SetDataColors(array('gray', 'blue', 'PeachPuff', 'white'));
    $graph->SetLegend($captions3);
    
    // set data
    $graph->SetDataValues($grdata3);
        
    // draw graph
    $graph->DrawGraph();

?>