title = $aInt->lang('gatewaytranslog', 'gatewaytranslogtitle'); $aInt->sidebar = 'billing'; $aInt->icon = 'logs'; ob_start(); echo $aInt->Tabs(array( $aInt->lang('global', 'searchfilter') ), true); if( !count($_REQUEST) ) { $startdate = fromMySQLDate(date('Y-m-d', mktime(0, 0, 0, date('m') - 3, date('d'), date('Y')))); $enddate = getTodaysDate(); } echo "\n

\n\n

\n\n\n\n\n

"; echo $aInt->lang('fields', 'daterange'); echo "	"; echo $aInt->lang('global', 'to'); echo "	"; echo $aInt->lang('gatewaytranslog', 'gateway'); echo "
"; echo $aInt->lang('gatewaytranslog', 'debugdata'); echo "		"; echo $aInt->lang('fields', 'result'); echo "

\n\n

lang('gatewaytranslog', 'filter'); echo "\" class=\"button\">

\n\n

\n\n
\n\n"; $aInt->sortableTableInit('id', 'DESC'); $where = array( ); if( $filterdebugdata ) { $where[] = "data LIKE '%" . db_escape_string(WHMCS_Input_Sanitize::decode($filterdebugdata)) . "%'"; } if( $startdate ) { $where[] = "date>='" . toMySQLDate($startdate) . " 00:00:00'"; } if( $enddate ) { $where[] = "date<='" . toMySQLDate($enddate) . " 23:59:59'"; } if( $filtergateway ) { $where[] = "gateway='" . db_escape_string($filtergateway) . "'"; } if( $filterresult ) { $where[] = "result='" . db_escape_string($filterresult) . "'"; } $result = select_query('tblgatewaylog', "COUNT(*)", implode(" AND ", $where), 'id', 'DESC'); $data = mysql_fetch_array($result); $numrows = $data[0]; $result = select_query('tblgatewaylog', '', implode(" AND ", $where), 'id', 'DESC', $page * $limit . ',' . $limit); while( $data = mysql_fetch_array($result) ) { $id = $data['id']; $date = $data['date']; $gateway = WHMCS_Input_Sanitize::makesafeforoutput($data['gateway']); $data2 = WHMCS_Input_Sanitize::makesafeforoutput($data['data']); $res = WHMCS_Input_Sanitize::makesafeforoutput($data['result']); $date = fromMySQLDate($date, 'time'); $tabledata[] = array( $date, $gateway, "", "" . $res . "" ); } echo $aInt->sortableTable(array( $aInt->lang('fields', 'date'), $aInt->lang('gatewaytranslog', 'gateway'), $aInt->lang('gatewaytranslog', 'debugdata'), $aInt->lang('fields', 'result') ), $tabledata); $content = ob_get_contents(); ob_end_clean(); $aInt->content = $content; $aInt->jquerycode = $jquerycode; $aInt->display();