$paging->AddURLFilter("op_filter", $req_op_filter); $display["op_filter"] = $req_op_filter; } if ($req_dt) { $date = strtotime($req_dt); $sql .= " AND TO_DAYS(dtadded) = TO_DAYS(FROM_UNIXTIME('{$date}'))"; $paging->AddURLFilter("dt", $req_dt); $display["dt"] = $req_dt; } else $display["dt"] = date("m/d/Y"); //Paging $paging->SetSQLQuery($sql); $paging->AdditionalSQL = "ORDER BY dtadded DESC"; $paging->ApplyFilter($_POST["filter_q"], array("object")); $paging->ApplySQLPaging(); $paging->ParseHTML(); $display["filter"] = $paging->GetFilterHTML("admin/inc/table_filter.tpl"); $display["paging"] = $paging->GetPagerHTML("admin/inc/paging.tpl"); // Rows $rows = $db->Execute($paging->SQL); $added = array(); while ($row = $rows->FetchRow()) { $row["type"] = ucfirst(strtolower($row["type"]));
<?php require_once 'src/prepend.inc.php'; if (!$req_userid) { throw new ApplicationException("Parameter 'userid' must be specified"); } $DBBalance = DBBalance::GetInstance(); $Balance = $DBBalance->LoadClientBalance($req_userid); $paging = new SQLPaging(); $paging->URLFormat = "?userid=" . (int) $req_userid . "&pn=%d&pt=%d"; $paging->SetSQLQuery("SELECT * FROM balance_history WHERE balanceid = '{$Balance->ID}' ORDER BY operation_date DESC"); $paging->ApplySQLPaging(); $paging->ParseHTML(); //$display["filter"] = $paging->GetFilterHTML("admin/inc/table_filter.tpl"); $display["paging"] = $paging->GetPagerHTML("admin/inc/paging.tpl"); $display["users"] = (array) $db->GetAll("SELECT * FROM users"); $display["attr"] = array_merge($_GET, $_POST); $display["rows"] = $DBBalance->LoadBalanceHistory($paging->SQL); foreach ($display["rows"] as &$row) { if ($row->InvoiceID) { $row->InvoiceDescription = $db->GetOne("SELECT description from invoices WHERE id = ?", array($row->InvoiceID)); } } $display["title"] = _("Balance » History"); require_once 'src/append.inc.php';