<?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('Y-m-01');
if(!$to) $to = date('Y-m-d');

$config_array = array(
	'title' => 'amazing report',
	'table' => 'payments',
	'label'=>'client_id',
	'group_function'=>'avg',
	'caption1'=>'الصيدلية',
	'caption2'=>'Average of التحصيلات',
	'group_function_field' =>'id',
	'date_field' =>'due_date',
	'start_date' =>$from,
	'end_date' =>$to,
	'look_up_table' =>'clients',
	'look_up_value' =>'name'
);
$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");