示例#1
0
         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']);
示例#2
0
    $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;