$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") {