smart_render_action_results(smart_process_action_form($my_sql['result_actions']), $my_sql['result_actions']['resulttitle']); smart_search_form($my_sql); $my_sql['sql_config'] = array('TimeOut' => 60); if (smart_process_mysql_form($my_sql)) { if ($export_data) { unset($my_sql['key']["companyname"]); $my_sql['return']["01|Company"] = array("source" => "cd.companyname", "column" => "companyname"); $my_sql['return']["21|Type"] = array("source" => "td.cardtype", "column" => "cardtype"); $my_sql['return']["22|OriginalTransDate"] = array("source" => "td.transactionDate", "column" => "transactionDate"); $my_sql['return']["23|BankTransID"] = array("source" => "td.td_bank_transaction_id", "column" => "td_bank_transaction_id"); if ($export_data == 'summary') { $my_sql['skip_query'] = true; } if ($export_data == 'transaction') { $my_sql['skip_subquery'] = true; $export_subname = ''; } ob_clean(); $filename = 'Export' . $export_subname . '.csv'; header('Content-type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename="' . $filename . '"'); flush(); } $result = smart_search($my_sql); if ($export_data) { smart_render_export($result, $my_sql); die; } smart_render_results($result, $my_sql); } include "includes/footer.php";
$my_sql['subquery']['queries']['01|Approved'] = array("name" => "amount_approved", "source" => "SUM(td.amount)", 'linkadd' => '&frm_td_status%5B%5D=A'); //$my_sql['subquery']['queries']['02|Transactions'] = array("name"=>"number_transactions", "source" => "COUNT(td.amount)","hidden"=>1); $sizefactor = 1; if ($style == 'minimal') { $sizefactor = 0.5; } if ($style == 'tiny') { $sizefactor = 0.25; } if ($style == 'full') { $my_sql['subquery']['queries']['06|Rebills'] = array("name" => "amount_rebilled", "source" => "SUM(if(td.td_is_a_rebill = 1,td.amount,0))", 'linkadd' => '&frm_td_td_is_a_rebill%5B%5D=1'); $my_sql['subquery']['queries']['07|New Sales'] = array("name" => "amount_newsales", "source" => "SUM(if(td.td_is_a_rebill = 0,td.amount,0))", 'linkadd' => '&frm_td_td_is_a_rebill%5B%5D=0'); } $my_sql['where']['td.transactionDate'] = array("value" => "'" . date('Y-m-01 00:00:00', time() + 60 * 60 * 24 * (30 * -$monthsback)) . "' and '" . date('Y-m-01 00:00:00', time() + 60 * 60 * 24 * (30 * (1 - $monthsback))) . "'", "compare" => "between"); $my_sql['where']['td.status'] = array("value" => "'A'", "compare" => "="); $daily = smart_search($my_sql); for ($i = 1; $i <= $daysinmonth; $i++) { $key = str_pad($i, 2, '0', STR_PAD_LEFT); if (!$daily['sub_row'][$key]) { $daily['sub_row'][$key] = array(); } } ksort($daily['sub_row']); //etelPrint($daily['sub_row']);etelDie(); $w = 600; $h = 200; if ($style == 'tiny') { $w = 300; $h = 150; } else { if ($style == 'full') {
$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";
****************/ smart_search_form($my_sql); if (smart_process_mysql_form($my_sql)) { $results = smart_search($my_sql); $company_ids = array(); foreach ($results['rows'] as $key => $values) { foreach ($values as $index => $value) { $company_ids[] = $value['rc_company_id']; } } $sql_limit = $my_sql['limit']; 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, false); foreach ($results['rows'] as $key => $values) { foreach ($values as $index => $value) { $all_company_ids[] = $value['rc_company_id']; } } $_SESSION['summary_company_id'] = $all_company_ids; $_SESSION['custom_report'] = $_POST['frm_custom_report']; beginTable(); echo sizeof($all_company_ids) . " companies in summary.<br>"; ?> <iframe src="risk_summary.php" width='500px' height='400px' frameborder="0"></iframe> <?php endTable("Report Summary"); beginTable(); $curr_offset = $_POST["frm_" . $sql_limit['offset_source']];