echo " selected"; } echo ">" . ($aInt->lang("status", strtolower($data['title'])) ? $aInt->lang("status", strtolower($data['title'])) : $data['title']) . "</option>"; } echo "</select></td></tr>\n<tr><td class=\"fieldlabel\">"; echo $aInt->lang("fields", "amount"); echo "</td><td class=\"fieldarea\"><input type=\"text\" name=\"amount\" value=\""; echo $amount = $filters->get("amount"); echo "\" size=\"10\"></td><td class=\"fieldlabel\">"; echo $aInt->lang("fields", "ipaddress"); echo "</td><td class=\"fieldarea\"><input type=\"text\" name=\"orderip\" value=\""; echo $orderip = $filters->get("orderip"); echo "\" size=\"20\"></td></tr>\n</table>\n\n<img src=\"images/spacer.gif\" height=\"8\" width=\"1\"><br>\n<div align=\"center\"><input type=\"submit\" value=\""; echo $aInt->lang("global", "search"); echo "\" class=\"button\"></div>\n\n</form>\n\n </div>\n</div>\n\n<br>\n\n"; $filters->store(); $aInt->deleteJSConfirm("doDelete", "orders", "confirmdelete", "orders.php?action=delete&id="); $name = "orders"; $orderby = "id"; $sort = "DESC"; $pageObj = new WHMCS_Pagination($name, $orderby, $sort); $pageObj->digestCookieData(); $tbl = new WHMCS_ListTable($pageObj); $tbl->setColumns(array("checkall", array("id", $aInt->lang("fields", "id")), array("ordernum", $aInt->lang("fields", "ordernum")), array("date", $aInt->lang("fields", "date")), $aInt->lang("fields", "clientname"), array("paymentmethod", $aInt->lang("fields", "paymentmethod")), array("amount", $aInt->lang("fields", "total")), $aInt->lang("fields", "paymentstatus"), array("status", $aInt->lang("fields", "status")), "")); $criteria = array("clientid" => $clientid, "amount" => $amount, "orderid" => $orderid, "ordernum" => $ordernum, "orderip" => $orderip, "orderdate" => $orderdate, "clientname" => $clientname, "paymentstatus" => $paymentstatus, "status" => $status); $ordersModel = new WHMCS_Orders($pageObj); $ordersModel->execute($criteria); $numresults = $pageObj->getNumResults(); if ($filters->isActive() && $numresults == 1) { $order = $pageObj->getOne(); redir("action=view&id=" . $order['id']);
$filters[] = "tblinvoices.datepaid>='" . toMySQLDate($datepaid) . "' AND tblinvoices.datepaid<='" . toMySQLDate($datepaid) . " 23:59:59'"; } if ($totalfrom = $filt->get("totalfrom")) { $filters[] = "tblinvoices.total>='" . db_escape_string($totalfrom) . "'"; } if ($totalto = $filt->get("totalto")) { $filters[] = "tblinvoices.total<='" . db_escape_string($totalto) . "'"; } if ($status = $filt->get("status")) { if ($status == "Overdue") { $filters[] = "tblinvoices.status='Unpaid' AND tblinvoices.duedate<'" . date("Ymd") . "'"; } else { $filters[] = "tblinvoices.status='" . db_escape_string($status) . "'"; } } $filt->store(); releaseSession(); echo "\r\n"; echo "<s"; echo "cript src=\"../includes/jscript/jquerytt.js\"></script>\n\n<form action=\""; echo $PHP_SELF; echo "?userid="; echo $userid; echo "\" method=\"post\">\n<table class=\"form\" width=\"100%\" border=\"0\" cellspacing=\"2\" cellpadding=\"3\">\n<tr><td width=\"15%\" class=\"fieldlabel\">"; echo $aInt->lang("fields", "invoicenum"); echo "</td><td class=\"fieldarea\"><input type=\"text\" name=\"invoicenum\" size=\"25\" value=\""; echo $clientname; echo "\"></td><td width=\"15%\" class=\"fieldlabel\">"; echo $aInt->lang("fields", "invoicedate"); echo "</td><td class=\"fieldarea\"><input type=\"text\" name=\"invoicedate\" size=\"15\" value=\""; echo $invoicedate;