"ID","userid"=>"User ID","clientname"=>"Client Name","currency"=>"Currency","gateway"=>"Payment Method","date"=>"Date","description"=>"Description","invoiceid"=>"Invoice ID","transid"=>"Transaction ID","amountin"=>"Amount In","fees"=>"Fees","amountout"=>"Amount Out","rate"=>"Exchange Rate","refundid"=>"Refund ID"); $reportdata["description"] = $reportdata["headertext"] = ''; $incfields = $whmcs->get_req_var('incfields'); $filterfield = $whmcs->get_req_var('filterfield'); $filtertype = $whmcs->get_req_var('filtertype'); $filterq = $whmcs->get_req_var('filterq'); if (!is_array($incfields)) $incfields = array(); if (!is_array($filterfield)) $filterfield = array(); if (!is_array($filtertype)) $filtertype = array(); if (!is_array($filterq)) $filterq = array(); if (!$print) { $reportdata["description"] = "This report can be used to generate a custom export of transactions by applying up to 5 filters. CSV Export is available via the download link at the bottom of the page."; $reportdata["headertext"] = '

'; for ( $i = 1; $i <= 5; $i ++ ) { $reportdata["headertext"] .= ''; } $reportdata["headertext"] .= ''; $reportdata["headertext"] .= '

Fields to Include	'; $i=0; foreach ($filterfields AS $k=>$v) { $reportdata["headertext"] .= ''; $i++; if (($i%5)==0) $reportdata["headertext"] .= ''; } $reportdata["headertext"] .= ' '.$v.'
Filter '.$i.'	None'; foreach ($filterfields AS $k=>$v) { $reportdata["headertext"] .= ''; } $reportdata["headertext"] .= ' Exact Match
Date Range	From   to

'; } if (count($incfields)) { $filters = array(); foreach ($filterfield as $i => $val) { if ($val && array_key_exists($val, $filterfields)) { if ($val == 'clientname') { $val = "(SELECT CONCAT(firstname,' ',lastname) FROM tblclients WHERE id=tblaccounts.userid)"; } $filters[] = ($filtertype[$i]=="like") ? $val . " LIKE '%" . db_escape_string($filterq[$i]) . "%'" : $val . "='" . db_escape_string($filterq[$i]) . "'"; } } $fieldlist = array(); foreach ($incfields AS $fieldname) { if (array_key_exists($fieldname,$filterfields)) { $reportdata["tableheadings"][] = $filterfields[$fieldname]; if ($fieldname=="clientname") $fieldname = "(SELECT CONCAT(firstname,' ',lastname) FROM tblclients WHERE id=tblaccounts.userid)"; $fieldlist[] = $fieldname; } } if (in_array('currency',$incfields) && !in_array('userid',$incfields)) $fieldlist[] = 'userid'; if ($whmcs->get_req_var('datefrom') && $whmcs->get_req_var('dateto')) { $filters[] = "date>='".toMySQLDate($whmcs->get_req_var('datefrom'))."' AND date<='".toMySQLDate($whmcs->get_req_var('dateto'))." 23:59:59'"; } $result = select_query("tblaccounts",implode(',',$fieldlist),implode(' AND ',$filters),"date","ASC"); while ($data = mysql_fetch_assoc($result)) { if (isset($data['currency'])) { $currency = getCurrency($data['userid'],$data['currency']); $data['currency'] = $currency['code']; if (!in_array('userid',$incfields)) unset($data['userid']); } if (isset($data['gateway'])) $data['gateway'] = $gateways->getDisplayName($data['gateway']); $reportdata["tablevalues"][] = $data; } }