public function index()
{
$page = 1;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
$sort = "paymenttransactions.created_at DESC";
if (isset($_GET['sort'])) {
$options = array("id" => "paymenttransactions.id ASC", "externalid" => "paymenttransactions.externalid ASC", "amount" => "paymenttransactions.amount DESC", "status" => "paymenttransactions.status ASC", "sender" => "paymenttransactions.sender ASC");
if (isset($options[$_GET['sort']])) {
$sort = $options[$_GET['sort']];
}
}
$where = null;
$query = "";
if (isset($_GET['q'])) {
$query = mysql_real_escape_string($_GET['q']);
$where = "paymenttransactions.id = '{$query}' OR paymenttransactions.sender LIKE '%{$query}%' OR paymenttransactions.externalid LIKE '%{$query}%'";
}
$page = PaymentTransaction::paginate($where, $sort, $page, 20);
$this->assign("page", $page);
$this->assign("query", $query);
$this->title = "Payment Transactions";
$this->render("paymenttransaction/index.tpl");
}
