Esempio n. 1
0
			$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"]));
Esempio n. 2
0
<?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 &nbsp;&raquo;&nbsp; History");
require_once 'src/append.inc.php';