$filters->redir();
}
if ($whmcs->get_req_var("sendmessage")) {
check_token("WHMCS.admin.default");
$clientslist = "";
$result = select_query("tblorders", "DISTINCT userid", "id IN (" . db_build_in_array($selectedorders) . ")");
while ($data = mysql_fetch_array($result)) {
$clientslist .= "selectedclients[]=" . $data['userid'] . "&";
}
redir("type=general&multiple=true&" . substr($clientslist, 0, 0 - 1), "sendmessage.php");
}
ob_start();
if (!$action) {
releaseSession();
echo $aInt->Tabs(array($aInt->lang("global", "searchfilter")), true);
$client = $filters->get("client");
$clientid = $filters->get("clientid");
if (!$clientid && $client) {
$clientid = $client;
}
$clientname = $filters->get("clientname");
echo "\n<div id=\"tab0box\" class=\"tabbox\">\n <div id=\"tab_content\">\n\n<form action=\"";
echo $PHP_SELF;
echo "\" method=\"post\">\n\n<table class=\"form\" width=\"100%\" border=\"0\" cellspacing=\"2\" cellpadding=\"3\">\n<tr><td width=\"15%\" class=\"fieldlabel\">";
echo $aInt->lang("fields", "orderid");
echo "</td><td class=\"fieldarea\"><input type=\"text\" name=\"orderid\" size=\"8\" value=\"";
echo $orderid = $filters->get("orderid");
echo "\"></td><td width=\"15%\" class=\"fieldlabel\">";
echo $aInt->lang("fields", "client");
echo "</td><td class=\"fieldarea\">";
echo $aInt->clientsDropDown($clientid, "", "clientid", true);
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) . "%'";
}
if ($invoicenum = $filt->get("invoicenum")) {
$filters[] = "(tblinvoices.id='" . db_escape_string($invoicenumber) . "' OR tblinvoices.invoicenum='" . db_escape_string($invoicenumber) . "')";
}
if ($lineitem = $filt->get("lineitem")) {
$pageObj->digestCookieData();
$tbl = new WHMCS_ListTable($pageObj);
$tbl->setColumns(array("checkall", array("id", $aInt->lang("fields", "invoicenum")), array("clientname", $aInt->lang("fields", "clientname")), array("date", $aInt->lang("fields", "invoicedate")), array("duedate", $aInt->lang("fields", "duedate")), array("total", $aInt->lang("fields", "total")), array("paymentmethod", $aInt->lang("fields", "paymentmethod")), array("status", $aInt->lang("fields", "status")), "", ""));
$invoicesModel = new WHMCS_Invoices($pageObj);
if (checkPermission("View Income Totals", true)) {
$invoicetotals = $invoicesModel->getInvoiceTotals();
if (count($invoicetotals)) {
echo "<div class=\"contentbox\" style=\"font-size:18px;\">";
foreach ($invoicetotals as $vals) {
echo "<b>" . $vals['currencycode'] . "</b> " . $aInt->lang("status", "paid") . ": <span class=\"textgreen\"><b>" . $vals['paid'] . "</b></span> " . $aInt->lang("status", "unpaid") . ": <span class=\"textred\"><b>" . $vals['unpaid'] . "</b></span> " . $aInt->lang("status", "overdue") . ": <span class=\"textblack\"><b>" . $vals['overdue'] . "</b></span><br />";
}
echo "</div><br />";
}
}
echo $aInt->Tabs(array($aInt->lang("global", "searchfilter")), true);
$clientid = $filters->get("clientid");
$invoicenum = $filters->get("invoicenum");
echo "\n<div id=\"tab0box\" class=\"tabbox\">\n <div id=\"tab_content\">\n\n<!-- Filter -->\n<form action=\"";
echo $PHP_SELF;
echo "\" method=\"post\">\n\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=\"25\" value=\"";
echo $clientname = $filters->get("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 = $filters->get("invoicedate");
echo "\" class=\"datepick\"></td></tr>\n<tr><td class=\"fieldlabel\">";
echo $aInt->lang("fields", "lineitem");
echo "</td><td class=\"fieldarea\"><input type=\"text\" name=\"lineitem\" size=\"40\" value=\"";
echo $lineitem = $filters->get("lineitem");
$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=\"";
echo $email = $filters->get("email");
echo "\" /></td><td class=\"fieldlabel\">";
echo $aInt->lang("fields", "address");
if (!$action) {
$smartyvalues['inticketlist'] = true;
if (!count($supportdepts)) {
$aInt->gracefulExit($aInt->lang("permissions", "accessdenied") . " - " . $aInt->lang("support", "noticketdepts"));
}
$tickets = new WHMCS_Tickets();
if ($_COOKIE['WHMCSAutoRefresh'] && !$action) {
$refreshtime = intval($_COOKIE['WHMCSAutoRefresh']) * 60;
if ($refreshtime && !$disable_auto_ticket_refresh) {
echo "<meta http-equiv=\"refresh\" content=\"" . $refreshtime . "\">";
}
}
echo $aInt->Tabs(array($aInt->lang("global", "searchfilter"), $aInt->lang("support", "autorefresh")), true);
$filterops = array("view", "deptid", "client", "subject", "email", "tag");
$filt->setAllowedVars($filterops);
$view = $filt->get("view");
$deptid = $filt->get("deptid");
$client = $filt->get("client");
$subject = $filt->get("subject");
$email = $filt->get("email");
$tag = $filt->get("tag");
$filt->store();
$smartyvalues['ticketfilterdata'] = array("view" => $view, "deptid" => $deptid, "subject" => $subject, "email" => $email);
echo "\n<div id=\"tab0box\" class=\"tabbox\">\n <div id=\"tab_content\">\n\n<form action=\"";
echo $PHP_SELF;
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", "status");
echo "</td><td class=\"fieldarea\">";
echo "<s";
echo "elect name=\"view\">\n<option value=\"any\"";
if ($view == "any") {
