$result = select_query("tblnetworkissues", "COUNT(*)", "status='Resolved'");
$data = mysql_fetch_array($result);
$smartyvalues['resolvedcount'] = $data[0];
$users_servers = array();
if (isset($_SESSION['uid'])) {
$result = select_query("tblhosting", "DISTINCT server", array("userid" => $_SESSION['uid']));
while ($data = mysql_fetch_array($result)) {
if ($data['server']) {
$users_servers[] = $data['server'];
}
}
}
$result = select_query("tblnetworkissues", "COUNT(*)", $query_where);
$data = mysql_fetch_array($result);
$numitems = $data[0];
list($orderby, $sort, $limit) = clientAreaTableInit("networkissues", "lastupdate", "DESC", $numitems);
$smartyvalues['orderby'] = $orderby;
$smartyvalues['sort'] = strtolower($sort);
$issues = array();
$result = select_query("tblnetworkissues", "", $query_where, $orderby, $sort, $limit);
while ($data = mysql_fetch_array($result)) {
$startdate = fromMySQLDate($data['startdate'], true);
$lastupdate = fromMySQLDate($data['lastupdate'], true);
if (!is_null($data['enddate'])) {
$enddate = fromMySQLDate($data['enddate'], true);
} else {
$enddate = "";
}
$priority = $_LANG["networkissuespriority" . strtolower($data['priority'])];
$status = $_LANG["networkissuesstatus" . str_replace(" ", "", strtolower($data['status']))];
$type = $_LANG["networkissuestype" . strtolower($data['type'])];
$deptid = get_query_val("tblticketdepartments", "id", array("id" => $CONFIG['AffiliateDepartment']));
}
if (!$deptid) {
$deptid = get_query_val("tblticketdepartments", "id", array("hidden" => ""), "order", "ASC");
}
$message = "Affiliate Account Withdrawal Request. Details below:\n\nClient ID: " . $_SESSION['uid'] . ("\nAffiliate ID: " . $id . "\nBalance: " . $balance);
$ticketdetails = openNewTicket($_SESSION['uid'], $_SESSION['cid'], $deptid, "Affiliate Withdrawal Request", $message, "Medium");
redir("withdraw=1");
}
}
if ($whmcs->get_req_var("withdraw")) {
$smarty->assign("withdrawrequestsent", "true");
}
$content .= "\n<p><b>" . $_LANG['affiliatesreferals'] . "</b></p>\n<table align=\"center\" id=\"affiliates\" cellspacing=\"1\">\n<tr><td id=\"affiliatesheading\">" . $_LANG['affiliatessignupdate'] . "</td><td id=\"affiliatesheading\">" . $_LANG['affiliateshostingpackage'] . "</td><td id=\"affiliatesheading\">" . $_LANG['affiliatesamount'] . "</td><td id=\"affiliatesheading\">" . $_LANG['affiliatescommision'] . "</td><td id=\"affiliatesheading\">" . $_LANG['affiliatesstatus'] . "</td></tr>\n";
$numitems = get_query_val("tblaffiliatesaccounts", "COUNT(*)", array("affiliateid" => $affiliateid), "", "", "", "tblhosting ON tblhosting.id=tblaffiliatesaccounts.relid INNER JOIN tblproducts ON tblproducts.id=tblhosting.packageid INNER JOIN tblclients ON tblclients.id=tblhosting.userid");
list($orderby, $sort, $limit) = clientAreaTableInit("affiliates", "regdate", "DESC", $numitems);
$smartyvalues['orderby'] = $orderby;
$smartyvalues['sort'] = strtolower($sort);
if ($orderby == "product") {
$orderby = "tblproducts`.`name";
} else {
if ($orderby == "amount") {
$orderby = "tblhosting`.`amount";
} else {
if ($orderby == "billingcycle") {
$orderby = "tblhosting`.`billingcycle";
} else {
if ($orderby == "status") {
$orderby = "tblhosting`.`domainstatus";
} else {
$orderby = "tblhosting`.`regdate";
$tstatus = $data['status'];
$urgency = $data['urgency'];
$lastreply = $data['lastreply'];
$lastreply = fromMySQLDate($lastreply, 1, 1);
$clientunread = $data['clientunread'];
$tstatus = getStatusColour($tstatus);
$dept = getDepartmentName($deptid);
$urgency = $_LANG["supportticketsticketurgency" . strtolower($urgency)];
$tickets[] = array("id" => $id, "tid" => $tid, "c" => $c, "date" => $date, "department" => $dept, "subject" => $subject, "status" => $tstatus, "urgency" => $urgency, "lastreply" => $lastreply, "unread" => $clientunread);
}
} else {
$result = select_query("tbltickets", "COUNT(id)", array("userid" => $_SESSION['uid']));
$data = mysql_fetch_array($result);
$numtickets = $data[0];
$smartyvalues['numtickets'] = $numtickets;
list($orderby, $sort, $limit) = clientAreaTableInit("tickets", "lastreply", "DESC", $numtickets);
$smartyvalues['orderby'] = $orderby;
$smartyvalues['sort'] = strtolower($sort);
if ($orderby == "date") {
$orderby = "date";
} else {
if ($orderby == "dept") {
$orderby = "deptname";
} else {
if ($orderby == "subject") {
$orderby = "title";
} else {
if ($orderby == "status") {
$orderby = "status";
} else {
if ($orderby == "urgency") {
if (!defined("WHMCS")) {
exit("This file cannot be accessed directly");
}
if (!$vars['clientenable']) {
redir();
}
$tplvars = array();
$tplvars['_lang'] = $vars['_lang'];
$tplvars['features'] = $features = explode(",", $vars['clientfeatures']);
$a = $_GET['a'];
if (!$a) {
$tplfile = "templates/clienthome";
$result = select_query("mod_project", "COUNT(*)", array("userid" => $_SESSION['uid']));
$data = mysql_fetch_array($result);
$numitems = $data[0];
list($orderby, $sort, $limit) = clientAreaTableInit("projects", "lastmodified", "DESC", $numitems);
$projects = array();
$result = select_query("mod_project", "", array("userid" => $_SESSION['uid']), $orderby, $sort, $limit);
while ($data = mysql_fetch_array($result)) {
$projects[] = array("id" => $data['id'], "title" => $data['title'], "adminid" => $data['adminid'], "adminname" => get_query_val("tbladmins", "CONCAT(firstname,' ',lastname)", array("id" => $data['adminid'])), "created" => fromMySQLDate($data['created'], 0, 1), "duedate" => fromMySQLDate($data['duedate'], 0, 1), "lastmodified" => fromMySQLDate($data['lastmodified'], 0, 1), "status" => $data['status']);
}
$tplvars['projects'] = $projects;
$tplvars['orderby'] = $orderby;
$tplvars['sort'] = strtolower($sort);
$tplvars = array_merge($tplvars, clientAreaTablePageNav($numitems));
return 1;
}
if ($a == "view") {
$tplfile = "templates/clientview";
$result = select_query("mod_project", "", array("userid" => $_SESSION['uid'], "id" => $_REQUEST['id']));
$data = mysql_fetch_array($result);
if ($partialpayments) {
$smartyvalues['partialpayments'] = formatCurrency($partialpayments);
}
$smartyvalues['total'] = formatCurrency($total - $partialpayments);
$smartyvalues['invoiceitems'] = $invoiceitems;
$gatewayslist = showPaymentGatewaysList();
$smartyvalues['gateways'] = $gatewayslist;
$smartyvalues['defaultgateway'] = key($gatewayslist);
} else {
if ($action == "quotes") {
$ca->setTemplate("clientareaquotes");
require ROOTDIR . "/includes/quotefunctions.php";
$result = select_query("tblquotes", "COUNT(*)", array("userid" => $client->getID()));
$data = mysql_fetch_array($result);
$numitems = $data[0];
list($orderby, $sort, $limit) = clientAreaTableInit("quote", "id", "DESC", $numitems);
if (!in_array($orderby, array("id", "date", "duedate", "total", "stage"))) {
$orderby = "validuntil";
}
$smartyvalues['orderby'] = $orderby;
$smartyvalues['sort'] = strtolower($sort);
$quotes = array();
$result = select_query("tblquotes", "", array("userid" => $client->getID(), "stage" => array("sqltype" => "NEQ", "value" => "Draft")), $orderby, $sort, $limit);
while ($data = mysql_fetch_assoc($result)) {
$data['datecreated'] = fromMySQLDate($data['datecreated'], 0, 1);
$data['validuntil'] = fromMySQLDate($data['validuntil'], 0, 1);
$data['lastmodified'] = fromMySQLDate($data['lastmodified'], 0, 1);
$data['stage'] = getQuoteStageLang($data['stage']);
$quotes[] = $data;
}
$smartyvalues['quotes'] = $quotes;
