1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

require_once("Report.php");

class Detailed_sales extends Report
{
    function __construct()
    {
        parent::__construct();
    }

    public function create(array $inputs)
    {
        //Create our temp tables to work with the data in our report
        $this->Sale->create_temp_table($inputs);
    }

    public function getDataColumns()
    {
        return array(
            'summary' => array(
                array('id' => $this->lang->line('reports_sale_id')),
                array('sale_date' => $this->lang->line('reports_date')),
                array('quantity' => $this->lang->line('reports_quantity')),
                array('employee_name' => $this->lang->line('reports_sold_by')),
                array('customer_name' => $this->lang->line('reports_sold_to')),
                array('subtotal' => $this->lang->line('reports_subtotal'), 'sorter' => 'number_sorter'),
                array('tax' => $this->lang->line('reports_tax'), 'sorter' => 'number_sorter'),
                array('total' => $this->lang->line('reports_total'), 'sorter' => 'number_sorter'),
                array('cost' => $this->lang->line('reports_cost'), 'sorter' => 'number_sorter'),
                array('profit' => $this->lang->line('reports_profit'), 'sorter' => 'number_sorter'),
                array('payment_type' => $this->lang->line('sales_amount_tendered')),
                array('comment' => $this->lang->line('reports_comments'))),
            'details' => array(
                $this->lang->line('reports_name'),
                $this->lang->line('reports_category'),
                $this->lang->line('reports_serial_number'),
                $this->lang->line('reports_description'),
                $this->lang->line('reports_quantity'),
                $this->lang->line('reports_subtotal'),
                $this->lang->line('reports_tax'),
                $this->lang->line('reports_total'),
                $this->lang->line('reports_cost'),
                $this->lang->line('reports_profit'),
                $this->lang->line('reports_discount')),
            'details_rewards' => array(
                $this->lang->line('reports_used'),
                $this->lang->line('reports_earned'))
        );
    }

    public function getDataBySaleId($sale_id)
    {
        $this->db->select('sale_id, sale_date, SUM(quantity_purchased) AS items_purchased, employee_name, customer_name, SUM(subtotal) AS subtotal, SUM(tax) AS tax, SUM(total) AS total, SUM(cost) AS cost, SUM(profit) AS profit, payment_type, comment');
        $this->db->from('sales_items_temp');
        $this->db->where('sale_id', $sale_id);

        return $this->db->get()->row_array();
    }

    public function getData(array $inputs)
    {
        $this->db->select('sale_id, 
        MAX(sale_date) AS sale_date, 
        SUM(quantity_purchased) AS items_purchased, 
        MAX(employee_name) AS employee_name, 
        MAX(customer_name) AS customer_name, 
        SUM(subtotal) AS subtotal, 
        SUM(tax) AS tax, 
        SUM(total) AS total, 
        SUM(cost) AS cost, 
        SUM(profit) AS profit, 
        MAX(payment_type) AS payment_type, 
        MAX(comment) AS comment');
        $this->db->from('sales_items_temp');

        if($inputs['location_id'] != 'all')
        {
            $this->db->where('item_location', $inputs['location_id']);
        }

        if($inputs['sale_type'] == 'sales')
        {
            $this->db->where('quantity_purchased > 0');
        }
        elseif($inputs['sale_type'] == 'returns')
        {
            $this->db->where('quantity_purchased < 0');
        }

        $this->db->group_by('sale_id');
        $this->db->order_by('MAX(sale_date)');

        $data = array();
        $data['summary'] = $this->db->get()->result_array();
        $data['details'] = array();
        $data['rewards'] = array();

        foreach($data['summary'] as $key=>$value)
        {
            $this->db->select('name, category, quantity_purchased, item_location, serialnumber, description, subtotal, tax, total, cost, profit, discount_percent');
            $this->db->from('sales_items_temp');
            $this->db->where('sale_id', $value['sale_id']);
            $data['details'][$key] = $this->db->get()->result_array();
            $this->db->select('used, earned');
            $this->db->from('sales_reward_points');
            $this->db->where('sale_id', $value['sale_id']);
            $data['rewards'][$key] = $this->db->get()->result_array();
        }

        return $data;
    }

    public function getSummaryData(array $inputs)
    {
        $this->db->select('SUM(subtotal) AS subtotal, SUM(tax) AS tax, SUM(total) AS total, SUM(cost) AS cost, SUM(profit) AS profit');
        $this->db->from('sales_items_temp');

        if($inputs['location_id'] != 'all')
        {
            $this->db->where('item_location', $inputs['location_id']);
        }

        if($inputs['sale_type'] == 'sales')
        {
            $this->db->where('quantity_purchased > 0');
        }
        elseif($inputs['sale_type'] == 'returns')
        {
            $this->db->where('quantity_purchased < 0');
        }

        return $this->db->get()->row_array();
    }
}
?>