$my_sql['title'] = "Report Lookup"; $my_sql['pairs']['ResultsPerPage'] = array(array("display" => "50", "value" => "50"), array("display" => "25", "value" => "25"), array("display" => "10", "value" => "10"), array("display" => "100", "value" => "100"), array("display" => "All", "value" => "1000")); $my_sql['pairs']['Company_Search_By'] = array(array("display" => "Company Name", "value" => "cn"), array("display" => "Reference ID", "value" => "ri"), array("display" => "Login UserName", "value" => "un"), array("display" => "Contact Email", "value" => "em"), array("display" => "Website Name", "value" => "wn"), array("display" => "Website Reference ID", "value" => "wr"), array("display" => "Merchant ID (List)", "value" => "id")); /**************** Process and Render Forms ****************/ smart_search_form($my_sql); if (smart_process_mysql_form($my_sql)) { $results = smart_search($my_sql); $report = new risk_report_main($_POST['frm_custom_report']); $company_ids = array(); foreach ($results['rows'] as $key => $values) { foreach ($values as $index => $value) { $company_ids[] = $value['rc_company_id']; } } unset($my_sql['limit']); unset($my_sql['return']); unset($my_sql['subquery']); $my_sql['return']["00|Company Id"] = array("source" => "r.rc_company_id", "column" => "rc_company_id", "hidden" => 1); $results = smart_search($my_sql, true); foreach ($results['rows'] as $key => $values) { foreach ($values as $index => $value) { $all_company_ids[] = $value['rc_company_id']; } } echo sizeof($all_company_ids) . " companies in summary.<br>"; $report->display_summary_report($all_company_ids); $report->display_risk_report($company_ids); } include "includes/footer.php";
<?php $etel_debug_mode = 0; include "includes/sessioncheck.php"; require_once "../includes/dbconnection.php"; require_once '../includes/function.php'; require_once '../includes/subFunctions/risk_report.php'; //$company_id = isset($_GET['company_id']) ? $_GET['company_id'] : (isset($_POST['company_id']) ? $_POST['company_id'] : ""); //$custom_report = isset($_GET['custom_report']) ? $_GET['custom_report'] : (isset($_POST['custom_report']) ? $_POST['custom_report'] : ""); if (isset($_SESSION['summary_company_id'])) { $company_id = $_SESSION['summary_company_id']; } else { exit; } if (isset($_SESSION['custom_report'])) { $custom_report = $_SESSION['custom_report']; } $report = new risk_report_main($custom_report); if (is_array($company_id)) { $report->display_summary_report($company_id); } else { if ($company_id != "") { $report->display_summary_report(array($company_id)); } else { $report->display_summary_report(); } } unset($_SESSION['summary_company_id']);