if ($action == "ajaxchangeorderstatus") {
check_token("WHMCS.admin.default");
$id = get_query_val("tblorders", "id", array("id" => $id));
$result = select_query("tblorderstatuses", "title", "", "sortorder", "ASC");
while ($data = mysql_fetch_array($result)) {
$statusesarr[] = $data['title'];
}
if (in_array($status, $statusesarr) && $id) {
update_query("tblorders", array("status" => $status), array("id" => $id));
echo $id;
} else {
echo 0;
}
exit;
}
$filters = new WHMCS_Filter();
if ($action == "delete" && $id) {
check_token("WHMCS.admin.default");
checkPermission("Delete Order");
deleteOrder($id);
$filters->redir();
}
if ($whmcs->get_req_var("massaccept")) {
check_token("WHMCS.admin.default");
checkPermission("View Order Details");
if (is_array($selectedorders)) {
foreach ($selectedorders as $orderid) {
acceptOrder($orderid);
}
}
$filters->redir();
redir("userid=" . $userid . "&filter=1");
}
ob_start();
$aInt->deleteJSConfirm("doDelete", "invoices", "delete", "clientsinvoices.php?userid=" . $userid . "&delete=true&invoiceid=");
$jquerycode .= "\$(\".invtooltip\").tooltip({cssClass:\"invoicetooltip\"});";
if ($mergeerr) {
infoBox($aInt->lang("invoices", "mergeerror"), $aInt->lang("invoices", "mergeerrordesc"));
}
if ($masspayerr) {
infoBox($aInt->lang("invoices", "masspay"), $aInt->lang("invoices", "mergeerrordesc"));
}
if ($masspayid) {
infoBox($aInt->lang("invoices", "masspay"), $aInt->lang("invoices", "masspaysuccess") . " - <a href=\"invoices.php?action=edit&id=" . (int) $masspayid . "\">" . $aInt->lang("fields", "invoicenum") . $masspayid . "</a>");
}
echo $infobox;
$filt = new WHMCS_Filter("clinv");
$filterops = array("serviceid", "addonid", "domainid", "clientname", "invoicenum", "lineitem", "paymentmethod", "invoicedate", "duedate", "datepaid", "totalfrom" . "totalto", "status");
$filt->setAllowedVars($filterops);
$filters = array();
$filters[] = "userid='" . (int) $userid . "'";
if ($serviceid = $filt->get("serviceid")) {
$filters[] = "id IN (SELECT invoiceid FROM tblinvoiceitems WHERE type='Hosting' AND relid='" . (int) $serviceid . "')";
}
if ($addonid = $filt->get("addonid")) {
$filters[] = "id IN (SELECT invoiceid FROM tblinvoiceitems WHERE type='Addon' AND relid='" . (int) $addonid . "')";
}
if ($domainid = $filt->get("domainid")) {
$filters[] = "id IN (SELECT invoiceid FROM tblinvoiceitems WHERE type IN ('DomainRegister','DomainTransfer','Domain') AND relid='" . (int) $domainid . "')";
}
if ($clientname = $filt->get("clientname")) {
$filters[] = "concat(firstname,' ',lastname) LIKE '%" . db_escape_string($clientname) . "%'";
$invoiceid = insert_query("tblinvoices", array("date" => "now()", "duedate" => $duedate, "userid" => $userid, "status" => "Unpaid", "paymentmethod" => $gateway, "taxrate" => $taxrate, "taxrate2" => $taxrate2));
logActivity("Created Manual Invoice - Invoice ID: " . $invoiceid, $userid);
if (1 < $CONFIG['InvoiceIncrement']) {
$invoiceincrement = $CONFIG['InvoiceIncrement'] - 1;
$counter = 1;
while ($counter <= $invoiceincrement) {
$tempinvoiceid = insert_query("tblinvoices", array("date" => "now()"));
delete_query("tblinvoices", array("id" => $tempinvoiceid));
$counter += 1;
}
}
run_hook("InvoiceCreationAdminArea", array("invoiceid" => $invoiceid));
redir("action=edit&id=" . $invoiceid);
exit;
}
$filters = new WHMCS_Filter();
if ($whmcs->get_req_var("markpaid")) {
check_token("WHMCS.admin.default");
checkPermission("Manage Invoice");
foreach ($selectedinvoices as $invid) {
$result2 = select_query("tblinvoices", "paymentmethod, ppi", array("id" => $invid));
$data = mysql_fetch_array($result2);
$paymentmethod = $data['paymentmethod'];
addInvoicePayment($invid, "", "", "", $paymentmethod);
if ($data['ppi'] == 0) {
update_query("tblinvoices", array("ppi" => "1"), array("id" => $invid));
continue;
}
}
$filters->redir();
}
**/
define("ADMINAREA", true);
require "../init.php";
$aInt = new WHMCS_Admin("List Clients");
$aInt->title = $aInt->lang("clients", "viewsearch");
$aInt->sidebar = "clients";
$aInt->icon = "clients";
$name = "clients";
$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("firstname", $aInt->lang("fields", "firstname")), array("lastname", $aInt->lang("fields", "lastname")), array("companyname", $aInt->lang("fields", "companyname")), array("email", $aInt->lang("fields", "email")), $aInt->lang("fields", "services"), array("datecreated", $aInt->lang("fields", "created")), array("status", $aInt->lang("fields", "status"))));
$clientsModel = new WHMCS_Clients($pageObj);
$filters = new WHMCS_Filter();
ob_start();
echo $aInt->Tabs(array($aInt->lang("global", "searchfilter")), true);
$userid = $filters->get("userid");
$country = $filters->get("country");
echo "<div id=\"tab0box\" class=\"tabbox\">\n <div id=\"tab_content\">\n\n<form action=\"clients.php\" 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", "clientname");
echo "</td><td class=\"fieldarea\"><input type=\"text\" name=\"clientname\" size=\"30\" value=\"";
echo $clientname = $filters->get("clientname");
echo "\" /></td><td width=\"15%\" class=\"fieldlabel\">";
echo $aInt->lang("fields", "companyname");
echo "</td><td class=\"fieldarea\"><input type=\"text\" name=\"companyname\" size=\"30\" value=\"";
echo $companyname = $filters->get("companyname");
echo "\" /></td></tr>\n<tr><td class=\"fieldlabel\">";
echo $aInt->lang("fields", "email");
echo "</td><td class=\"fieldarea\"><input type=\"text\" name=\"email\" size=\"40\" value=\"";
} else {
$aInt = new WHMCS_Admin($reqperm);
}
if ($action == "open" || $action == "openticket") {
$icon = "ticketsopen";
$title = $aInt->lang("support", "opennewticket");
} else {
$icon = "tickets";
$title = $aInt->lang("support", "supporttickets");
}
$aInt->title = $title;
$aInt->sidebar = "support";
$aInt->icon = $icon;
$aInt->helplink = "Support Tickets";
$aInt->requiredFiles(array("ticketfunctions", "modulefunctions", "customfieldfunctions"));
$filt = new WHMCS_Filter("tickets");
$smartyvalues = array();
if ($whmcs->get_req_var("ticketid")) {
$action = "search";
}
if ($action == "gettags") {
check_token("WHMCS.admin.default");
$array = array();
$result = select_query("tbltickettags", "DISTINCT tag", "tag LIKE '" . db_escape_string($q) . "%'", "tag", "ASC");
while ($data = mysql_fetch_array($result)) {
$array[] = $data[0];
}
echo json_encode($array);
exit;
}
if ($action == "savetags") {
