<?php
/* Include Requerie d files */
define("PREPEND_PATH", "../");
$hooks_dir = dirname(__FILE__);
include("{$hooks_dir}/../defaultLang.php");
include("{$hooks_dir}/../language.php");
include("{$hooks_dir}/../lib.php");
include("{$hooks_dir}/SummaryReport.php");
include_once("{$hooks_dir}/../header.php");

$from = makeSafe($_POST['from']);
$to = makeSafe($_POST['to']);
if(!$from) $from = date('m-01-Y');
if(!$to) $to = date('m-d-Y');

$config_array = array(
	'title' => 'Orders By Country',
	'table' => 'orders',
	'label'=>'Country',
	'group_function'=>'count',
	'caption1'=>'Country',
	'caption2'=>'Count of Orders',
	'group_function_field' =>'',
	'parent_table' =>'customers',
	'join_statment' =>'orders join customers on orders.CustomerID=customers.id',
	'date_field' =>'OrderDate',
	'start_date' =>$from,
	'end_date' =>$to,
	'look_up_table' =>'',
	'look_up_value' =>''
);
$new_report = new SummaryReport($config_array);
$new_report->get_picker($from,$to,"mm-dd-yyyy");
$new_report->render_report();

include_once("{$hooks_dir}/../footer.php");