public static function show()
{
?>
<div class="row">
<div class="wrapperCustom">
<div class="col-lg-12">
<div class="backgroundHeader">
<h1 class="aboutHeading">Specials</h1><br><br>
</div>
</div>
<div class="col-lg-3 col-md-0 col-sm-0"></div>
<div class="col-lg-4 col-md-12 col-sm-12">
<?php
paginator::paginateSpecials();
?>
</div>
<div class="col-lg-3 col-md-0 col-sm-0"></div>
</div>
</div>
<?php
}
<?php
$pagPages = '10';
// Delete Manager Account
if (isset($_POST['submit']) && $_POST['submit'] == 'deleteAdmin') {
$adminId = $mysqli->real_escape_string($_POST['adminId']);
$stmt = $mysqli->prepare("DELETE FROM admins WHERE adminId = ?");
$stmt->bind_param('s', $adminId);
$stmt->execute();
$stmt->close();
$msgBox = alertBox($managerDeletedMsg, "<i class='fa fa-check-square'></i>", "success");
}
// Include Pagination Class
include 'includes/pagination.php';
// Create new object & pass in the number of pages and an identifier
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM clients WHERE isActive = 1");
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Data
$query = "SELECT\n\t\t\t\tadminId,\n\t\t\t\tadminEmail,\n\t\t\t\tCONCAT(adminFirstName,' ',adminLastName) AS theAdmin,\n\t\t\t\tadminPhone,\n\t\t\t\tisAdmin,\n\t\t\t\tadminRole,\n\t\t\t\tisArchived,\n\t\t\t\tDATE_FORMAT(archiveDate,'%M %e, %Y') AS archiveDate\n\t\t\tFROM\n\t\t\t\tadmins\n\t\t\tWHERE\n\t\t\t\tisActive = 0 AND\n\t\t\t\tisAdmin = 0\n\t\t\tORDER BY\n\t\t\t\tadminId " . $pages->get_limit();
$res = mysqli_query($mysqli, $query) or die('-1' . mysqli_error());
include 'includes/navigation.php';
if ($isAdmin != '1') {
?>
<div class="content">
<h3><?php
echo $accessErrorHeader;
?>
$stmt->execute();
// Delete the Folder on the host
if (is_dir($uploadsDir . $folderUrl)) {
rmdir($uploadsDir . $folderUrl);
$msgBox = alertBox("The Project Folder has been Deleted.", "<i class='fa fa-check-square'></i>", "success");
} else {
$msgBox = alertBox($deleteFolderErrorMsg, "<i class='fa fa-times-circle'></i>", "danger");
}
$stmt->close();
} else {
$msgBox = alertBox($foldNotEmptyMsg, "<i class='fa fa-times-circle'></i>", "danger");
}
}
// Include Pagination Class
include 'includes/getpagination.php';
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM projectfolders WHERE projectId = " . $projectId);
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Folder Data
$sql = "SELECT\n\t\t\t\tprojectfolders.folderId,\n\t\t\t\tprojectfolders.projectId,\n\t\t\t\tprojectfolders.adminId,\n\t\t\t\tprojectfolders.clientId,\n\t\t\t\tprojectfolders.folderTitle,\n\t\t\t\tprojectfolders.folderDesc,\n\t\t\t\tprojectfolders.folderUrl,\n\t\t\t\tDATE_FORMAT(projectfolders.folderDate,'%M %d, %Y') AS folderDate,\n\t\t\t\tUNIX_TIMESTAMP(projectfolders.folderDate) AS orderDate,\n\t\t\t\tCONCAT(clients.clientFirstName,' ',clients.clientLastName) AS theClient,\n\t\t\t\tCONCAT(admins.adminFirstName,' ',admins.adminLastName) AS theAdmin\n\t\t\tFROM\n\t\t\t\tprojectfolders\n\t\t\t\tLEFT JOIN clients ON projectfolders.clientId = clients.clientId\n\t\t\t\tLEFT JOIN admins ON projectfolders.adminId = admins.adminId\n\t\t\tWHERE\n\t\t\t\tprojectfolders.projectId = " . $projectId . "\n\t\t\tORDER BY orderDate " . $pages->get_limit();
$res = mysqli_query($mysqli, $sql) or die('-1' . mysqli_error());
$query = "SELECT clientId, projectName FROM clientprojects WHERE projectId = " . $projectId;
$result = mysqli_query($mysqli, $query) or die('-2' . mysqli_error());
$col = mysqli_fetch_assoc($result);
include 'includes/navigation.php';
if ($col['clientId'] != $clientId) {
?>
<div class="content">
public function xlist($data = array())
{
if (@$data['fetch']) {
if (!isset($data['fetch']['data'])) {
$data['fetch']['data'] = array();
}
$data['fetch']['model'] = @$data['fetch']['model'] ? is_object($data['fetch']['model']) ? $data['fetch']['model'] : (class_exists($data['fetch']['model']) ? $data['fetch']['model'] : 'model_' . @$data['fetch']['model']) : '';
if (@$data['fetch']['entity'] != 'none') {
$data['fetch']['entity'] = @$data['fetch']['entity'] ? class_exists($data['fetch']['entity']) ? $data['fetch']['entity'] : 'entity_' . @$data['fetch']['entity'] : ($data['fetch']['model'] ? 'entity_' . strtolower(str_ireplace('model_', '', is_object($data['fetch']['model']) ? get_class($data['fetch']['model']) : $data['fetch']['model'])) : 'none');
}
$data['fetch']['param'] = isset($data['fetch']['param']) ? is_array($data['fetch']['param']) ? $data['fetch']['param'] : array($data['fetch']['param']) : array();
if (!isset($data['fetch']['method'])) {
$data['fetch']['method'] = 'list';
}
if ($data['fetch']['model'] && !method_exists($data['fetch']['model'], $data['fetch']['method'])) {
$data['fetch']['method'] = 'fetch_' . $data['fetch']['method'];
}
}
if (!isset($data['callback'])) {
$data['callback'] = array();
}
if (!isset($data['callback']['empty'])) {
$data['callback']['empty'] = null;
}
if (!@$data['view']) {
$data['view'] = array();
}
if (!isset($data['view']['script'])) {
$data['view']['script'] = strtolower(str_ireplace('model_', '', is_object($data['fetch']['model']) ? get_class($data['fetch']['model']) : $data['fetch']['model'])) . '/' . strtolower(str_ireplace('fetch_', '', $data['fetch']['method']));
}
if (stripos($data['view']['script'], '/') === false) {
$data['view']['script'] .= '/index';
}
if (!isset($data['view']['param'])) {
$data['view']['param'] = array();
}
if (!isset($data['view']['empty'])) {
$data['view']['empty'] = true;
}
if (@$data['pager']) {
$data['pager'] = is_array($data['pager']) ? $data['pager'] : array();
if (!isset($data['pager']['style'])) {
$data['pager']['style'] = 'all';
}
if (!isset($data['pager']['style_param'])) {
$data['pager']['style_param'] = array();
}
if (!isset($data['pager']['active'])) {
$data['pager']['active'] = true;
}
if (!isset($data['pager']['url'])) {
$data['pager']['url'] = '';
}
if (!isset($data['pager']['page'])) {
$data['pager']['page'] = @$this->view->page ? $this->view->page : 1;
}
if (!isset($data['pager']['perpage'])) {
$data['pager']['perpage'] = @$this->view->perpage ? $this->view->perpage : 10;
}
if (!@$data['pager']['script']) {
$data['pager']['script'] = 'pager';
}
if (stripos($data['pager']['script'], '/') === false) {
$data['pager']['script'] .= '/index';
}
if (!isset($data['pager']['param'])) {
$data['pager']['param'] = array();
}
}
$class = !$data['fetch']['data'] && $data['fetch']['model'] ? is_object($data['fetch']['model']) ? $data['fetch']['model'] : new $data['fetch']['model']() : '';
$list = $data['fetch']['data'] ? $data['fetch']['data'] : ($class ? call_user_func_array(array($class, $data['fetch']['method']), $data['fetch']['param']) : array());
if (@$data['pager']) {
$paginator = new paginator($list);
$paginator->perpage = $data['pager']['perpage'];
$paginator->page = $data['pager']['page'];
$paginator->style = $data['pager']['style'];
$paginator->style_param = $data['pager']['style_param'];
$paginator->query();
$list = $paginator->data;
$param = array_merge($data['pager']['param'], array('url' => $data['pager']['url']), array('records' => $paginator->records, 'pages' => $paginator->pages, 'first' => $paginator->first, 'last' => $paginator->last, 'prev' => $paginator->prev, 'next' => $paginator->next));
$this->view->pager = $this->view->xlist(array('fetch' => array('data' => $paginator->list), 'view' => array('script' => $data['pager']['script'], 'param' => $param)));
} else {
if ($list instanceof database_select) {
$list = $class->entity_all($class->adapter->fetch_all($list));
}
}
if (count($list)) {
if ($data['fetch']['entity'] != 'none') {
foreach ($list as &$el) {
$entity = class_exists($data['fetch']['entity']) ? $data['fetch']['entity'] : 'entity';
$el = new $entity($el);
$el->view = $this->view;
}
}
}
$ret = '';
if ($list || $data['view']['empty']) {
$this->view->data = null;
$this->view->data = $list;
if (@$data['view']['param']) {
foreach ($data['view']['param'] as $k => $v) {
$this->view->{$k} = $v;
}
}
$ret = $this->view->render($data['view']['script']);
if (@$data['view']['param']) {
foreach ($data['view']['param'] as $k => $v) {
unset($this->view->{$k});
}
}
unset($this->view->data);
}
if (!$list && $data['callback']['empty']) {
$f = $data['callback']['empty'];
$f($this);
}
return $ret;
}
$datePicker = 'true';
$jsFile = 'siteAlerts';
$pagPages = '10';
// Delete Request
if (isset($_POST['submit']) && $_POST['submit'] == 'deleteRequest') {
$deleteId = $mysqli->real_escape_string($_POST['deleteId']);
$stmt = $mysqli->prepare("DELETE FROM projectrequests WHERE requestId = ?");
$stmt->bind_param('s', $_POST['deleteId']);
$stmt->execute();
$stmt->close();
$msgBox = alertBox($deleteRequestMsg, "<i class='fa fa-check-square'></i>", "success");
}
// Include Pagination Class
include 'includes/pagination.php';
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM projectrequests");
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Data
$sqlStmt = "SELECT\n\t\t\t\t\tprojectrequests.requestId,\n\t\t\t\t\tprojectrequests.clientId,\n\t\t\t\t\tprojectrequests.requestTitle,\n\t\t\t\t\tprojectrequests.requestBudget,\n\t\t\t\t\tprojectrequests.timeFrame,\n\t\t\t\t\tDATE_FORMAT(projectrequests.requestDate,'%M %d, %Y') AS requestDate,\n\t\t\t\t\tUNIX_TIMESTAMP(projectrequests.requestDate) AS orderDate,\n\t\t\t\t\tprojectrequests.requestAccepted,\n\t\t\t\t\tCONCAT(clients.clientFirstName,' ',clients.clientLastName) AS theClient,\n\t\t\t\t\tclients.clientCompany\n\t\t\t\tFROM\n\t\t\t\t\tprojectrequests\n\t\t\t\t\tLEFT JOIN clients ON projectrequests.clientId = clients.clientId\n\t\t\t\tORDER BY projectrequests.requestAccepted, orderDate, clients.clientId " . $pages->get_limit();
$res = mysqli_query($mysqli, $sqlStmt) or die('-1' . mysqli_error());
include 'includes/navigation.php';
?>
<div class="content last">
<h3><?php
echo $pageName;
?>
</h3>
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
if (mail($theEmail, $subject, $message, $headers)) {
$msgBox = alertBox($newPMSentConf, "<i class='fa fa-check-square'></i>", "success");
} else {
$msgBox = alertBox($emailErrorMsg, "<i class='fa fa-times-circle'></i>", "danger");
}
// Clear the Form of values
$_POST['messageTitle'] = $_POST['messageText'] = '';
$stmt->close();
}
}
}
// Include Pagination Class
include 'includes/pagination.php';
// Create new object & pass in the number of pages and an identifier
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("\n\t\tSELECT\n\t\t\t*\n\t\tFROM\n\t\t\tprivatemessages\n\t\t\tLEFT JOIN clients ON privatemessages.clientId = clients.clientId\n\t\t\tLEFT JOIN admins ON privatemessages.adminId = admins.adminId\n\t\tWHERE\n\t\t\tprivatemessages.toClientId = " . $clientId . " AND\n\t\t\tprivatemessages.toDeleted = 0 AND\n\t\t\tprivatemessages.toArchived = 1\n\t");
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
$query = "SELECT\n\t\t\t\tprivatemessages.messageId,\n\t\t\t\tprivatemessages.adminId,\n\t\t\t\tprivatemessages.clientId,\n\t\t\t\tprivatemessages.toClientId,\n\t\t\t\tprivatemessages.messageTitle,\n\t\t\t\tprivatemessages.messageText,\n\t\t\t\tDATE_FORMAT(privatemessages.messageDate,'%b %d %Y %h:%i %p') AS messageDate,\n\t\t\t\tUNIX_TIMESTAMP(privatemessages.messageDate) AS orderDate,\n\t\t\t\tprivatemessages.toRead,\n\t\t\t\tprivatemessages.toArchived,\n\t\t\t\tprivatemessages.toDeleted,\n\t\t\t\tCONCAT(clients.clientFirstName,' ',clients.clientLastName) AS clientSent,\n\t\t\t\tCONCAT(admins.adminFirstName,' ',admins.adminLastName) AS adminSent\n\t\t\tFROM\n\t\t\t\tprivatemessages\n\t\t\t\tLEFT JOIN clients ON privatemessages.clientId = clients.clientId\n\t\t\t\tLEFT JOIN admins ON privatemessages.adminId = admins.adminId\n\t\t\tWHERE\n\t\t\t\tprivatemessages.toClientId = " . $clientId . " AND\n\t\t\t\tprivatemessages.toDeleted = 0 AND\n\t\t\t\tprivatemessages.toArchived = 1\n\t\t\tORDER BY\n\t\t\t\torderDate DESC " . $pages->get_limit();
$res = mysqli_query($mysqli, $query) or die('-2' . mysqli_error());
if ($total < '1') {
$lastContent = 'last';
} else {
$lastContent = '';
}
include 'includes/navigation.php';
?>
<div class="contentAlt">
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
if (mail($managers, $subject, $message, $headers)) {
$msgBox = alertBox($projRequestCreatedMsg, "<i class='fa fa-check-square'></i>", "success");
// Clear the form of Values
$_POST['requestTitle'] = $_POST['requestDesc'] = $_POST['requestBudget'] = $_POST['timeFrame'] = '';
} else {
$msgBox = alertBox($emailErrorMsg, "<i class='fa fa-times-circle'></i>", "danger");
}
$stmt->close();
}
}
}
// Include Pagination Class
include 'includes/pagination.php';
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM projectrequests WHERE clientId = " . $clientId);
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Data
$sqlStmt = "SELECT\n\t\t\t\t\trequestId,\n\t\t\t\t\tclientId,\n\t\t\t\t\trequestTitle,\n\t\t\t\t\trequestDesc,\n\t\t\t\t\trequestBudget,\n\t\t\t\t\ttimeFrame,\n\t\t\t\t\tDATE_FORMAT(requestDate,'%M %d, %Y') AS requestDate,\n\t\t\t\t\trequestAccepted\n\t\t\t\tFROM\n\t\t\t\t\tprojectrequests\n\t\t\t\tWHERE clientId = " . $clientId . "\n\t\t\t\tORDER BY requestId " . $pages->get_limit();
$res = mysqli_query($mysqli, $sqlStmt) or die('-1' . mysqli_error());
include 'includes/navigation.php';
?>
<div class="contentAlt">
<ul class="nav nav-tabs">
<li><a href="index.php?page=openProjects"><i class="fa fa-folder-open-o"></i> <?php
echo $openProjectsLink;
?>
$msgBox = alertBox($newTaskAddedCalMsg, "<i class='fa fa-check-square'></i>", "success");
} else {
$msgBox = alertBox($newTaskAddedMsg, "<i class='fa fa-check-square'></i>", "success");
}
// Clear the Form of values
$_POST['taskTitle'] = $_POST['taskDesc'] = $_POST['taskPriority'] = $_POST['taskStatus'] = $_POST['taskDue'] = '';
}
}
}
}
}
}
// Include Pagination Class
include 'includes/pagination.php';
// Create new object & pass in the number of pages and an identifier
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM tasks WHERE adminId = " . $adminId . " AND isClosed != 0");
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Data
$query = "SELECT\n\t\t\t\ttasks.taskId,\n\t\t\t\ttasks.projectId,\n\t\t\t\ttasks.adminId,\n\t\t\t\ttasks.taskTitle,\n\t\t\t\ttasks.taskDesc,\n\t\t\t\ttasks.taskPriority,\n\t\t\t\tDATE_FORMAT(tasks.taskStart,'%M %d, %Y') AS startDate,\n\t\t\t\tDATE_FORMAT(tasks.dateClosed,'%M %d, %Y') AS dateClosed,\n\t\t\t\tUNIX_TIMESTAMP(tasks.dateClosed) AS orderDate,\n\t\t\t\tclientprojects.projectName\n\t\t\tFROM\n\t\t\t\ttasks\n\t\t\t\tLEFT JOIN clientprojects ON tasks.projectId = clientprojects.projectId\n\t\t\tWHERE\n\t\t\t\ttasks.adminId = " . $adminId . " AND tasks.isClosed != 0\n\t\t\tORDER BY\n\t\t\t\torderDate " . $pages->get_limit();
$res = mysqli_query($mysqli, $query) or die('-1' . mysqli_error());
include 'includes/navigation.php';
?>
<div class="contentAlt">
<ul class="nav nav-tabs">
<li><a href="index.php?action=personalTasks"><i class="fa fa-user"></i> <?php
echo $personalTasksTabLink;
?>
$stmt->close();
}
}
}
// Delete Site Alert
if (isset($_POST['submit']) && $_POST['submit'] == 'deleteAlert') {
$alertId = $mysqli->real_escape_string($_POST['alertId']);
$stmt = $mysqli->prepare("DELETE FROM sitealerts WHERE alertId = ?");
$stmt->bind_param('s', $alertId);
$stmt->execute();
$msgBox = alertBox($alertDeletedMsg, "<i class='fa fa-check-square'></i>", "success");
$stmt->close();
}
// Include Pagination Class
include 'includes/pagination.php';
$pages = new paginator($pagPages, 'p');
// Get the number of total records for Private Closed
$rows = $mysqli->query("SELECT * FROM sitealerts");
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Data
$sqlStmt = "SELECT\n\t\t\t\t\tsitealerts.alertId,\n\t\t\t\t\tsitealerts.adminId,\n\t\t\t\t\tsitealerts.isActive,\n\t\t\t\t\tsitealerts.invoicePrint,\n\t\t\t\t\tsitealerts.alertTitle,\n\t\t\t\t\tsitealerts.alertText,\n\t\t\t\t\tsitealerts.alertDate,\n\t\t\t\t\tDATE_FORMAT(sitealerts.alertDate,'%M %d, %Y') AS createDate,\n\t\t\t\t\tsitealerts.alertStart,\n\t\t\t\t\tDATE_FORMAT(sitealerts.alertStart,'%M %d, %Y') AS startDate,\n\t\t\t\t\tDATE_FORMAT(sitealerts.alertStart,'%Y-%m-%d') AS showStart,\n\t\t\t\t\tsitealerts.alertExpires,\n\t\t\t\t\tDATE_FORMAT(sitealerts.alertExpires,'%M %d, %Y') AS endDate,\n\t\t\t\t\tDATE_FORMAT(sitealerts.alertExpires,'%Y-%m-%d') AS showEnd,\n\t\t\t\t\tCONCAT(admins.adminFirstName,' ',admins.adminLastName) AS createdBy\n\t\t\t\tFROM\n\t\t\t\t\tsitealerts\n\t\t\t\t\tLEFT JOIN admins ON sitealerts.adminId = admins.adminId " . $pages->get_limit();
$res = mysqli_query($mysqli, $sqlStmt) or die('-1' . mysqli_error());
include 'includes/navigation.php';
?>
<div class="contentAlt">
<ul class="nav nav-tabs">
<li class="pull-right"><a data-toggle="modal" href="#newAlert"><i class="fa fa-plus"></i> Add a New Alert</a></li>
</ul>
</div>
$msgBox = alertBox($emailErrorMsg, "<i class='fa fa-times-circle'></i>", "danger");
}
}
// Delete Client Account
if (isset($_POST['submit']) && $_POST['submit'] == 'deleteClient') {
$clientId = $mysqli->real_escape_string($_POST['clientId']);
$stmt = $mysqli->prepare("DELETE FROM clients WHERE clientId = ?");
$stmt->bind_param('s', $clientId);
$stmt->execute();
$stmt->close();
$msgBox = alertBox($clientAccountDeletedMsg, "<i class='fa fa-check-square'></i>", "success");
}
// Include Pagination Class
include 'includes/pagination.php';
// Create new object & pass in the number of pages and an identifier
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM clients WHERE isActive = 0");
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Data
$query = "SELECT\n\t\t\t\tclientId,\n\t\t\t\tclientEmail,\n\t\t\t\tCONCAT(clientFirstName,' ',clientLastName) AS theClient,\n\t\t\t\tclientCompany,\n\t\t\t\thash,\n\t\t\t\tisArchived,\n\t\t\t\tDATE_FORMAT(archiveDate,'%M %d, %Y') AS archiveDate,\n\t\t\t\tUNIX_TIMESTAMP(archiveDate) AS orderDate\n\t\t\tFROM\n\t\t\t\tclients\n\t\t\tWHERE\n\t\t\t\tisActive = 0\n\t\t\tORDER BY\n\t\t\t\torderDate " . $pages->get_limit();
$res = mysqli_query($mysqli, $query) or die('-1' . mysqli_error());
include 'includes/navigation.php';
?>
<div class="contentAlt">
<ul class="nav nav-tabs">
<li><a href="index.php?action=activeClients"><i class="fa fa-user"></i> <?php
echo $activeClientsTabLink;
?>
$msgBox = alertBox($newTaskAddedCalMsg, "<i class='fa fa-check-square'></i>", "success");
} else {
$msgBox = alertBox($newTaskAddedMsg, "<i class='fa fa-check-square'></i>", "success");
}
// Clear the Form of values
$_POST['taskTitle'] = $_POST['taskDesc'] = $_POST['taskPriority'] = $_POST['taskStatus'] = $_POST['taskDue'] = '';
}
}
}
}
}
}
// Include Pagination Class
include 'includes/pagination.php';
// Create new object & pass in the number of pages and an identifier
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM tasks WHERE projectId = 0 AND adminId = " . $adminId . " AND isClosed = 0");
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Data
$query = "SELECT\n\t\t\t\ttaskId,\n\t\t\t\tadminId,\n\t\t\t\ttaskTitle,\n\t\t\t\ttaskDesc,\n\t\t\t\ttaskPriority,\n\t\t\t\ttaskStatus,\n\t\t\t\tDATE_FORMAT(taskStart,'%M %d, %Y') AS startDate,\n\t\t\t\tDATE_FORMAT(taskDue,'%M %d, %Y') AS dueDate,\n\t\t\t\tUNIX_TIMESTAMP(taskDue) AS orderDate\n\t\t\tFROM\n\t\t\t\ttasks\n\t\t\tWHERE\n\t\t\t\tprojectId = 0 AND adminId = " . $adminId . " AND isClosed = 0\n\t\t\tORDER BY\n\t\t\t\torderDate " . $pages->get_limit();
$res = mysqli_query($mysqli, $query) or die('-1' . mysqli_error());
include 'includes/navigation.php';
?>
<div class="contentAlt">
<ul class="nav nav-tabs">
<li class="active"><a href="#personal" data-toggle="tab"><i class="fa fa-user"></i> <?php
echo $personalTasksTabLink;
?>
<?php
$pagPages = '10';
// Include Pagination Class
include 'includes/pagination.php';
// Create new object & pass in the number of pages and an identifier
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$cols = $mysqli->query("SELECT * FROM invoices WHERE clientId = " . $clientId);
$total = mysqli_num_rows($cols);
// Pass the number of total records
$pages->set_total($total);
// Get Data
$query = "SELECT\n\t\t\t\tinvoices.invoiceId,\n\t\t\t\tinvoices.projectId,\n\t\t\t\tinvoices.adminId,\n\t\t\t\tinvoices.clientId,\n\t\t\t\tinvoices.invoiceTitle,\n\t\t\t\tDATE_FORMAT(invoices.invoiceDate,'%M %d, %Y') AS invoiceDate,\n\t\t\t\tDATE_FORMAT(invoices.invoiceDue,'%M %d, %Y') AS invoiceDue,\n\t\t\t\tUNIX_TIMESTAMP(invoices.invoiceDue) AS orderDate,\n\t\t\t\tinvoices.isPaid,\n\t\t\t\tclientprojects.projectName\n\t\t\tFROM\n\t\t\t\tinvoices\n\t\t\t\tLEFT JOIN clientprojects ON invoices.projectId = clientprojects.projectId\n\t\t\tWHERE invoices.clientId = " . $clientId . "\n\t\t\tORDER BY invoices.isPaid, orderDate " . $pages->get_limit();
$res = mysqli_query($mysqli, $query) or die('-1' . mysqli_error());
include 'includes/navigation.php';
?>
<div class="content last">
<h3><?php
echo $pageName;
?>
</h3>
<?php
if ($msgBox) {
echo $msgBox;
}
?>
<?php
if (mysqli_num_rows($res) < 1) {
?>
if ($isAdmin == '1') {
// Include Pagination Class
include 'includes/getpagination.php';
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM clientprojects WHERE clientprojects.clientId = " . $clientId . " AND clientprojects.archiveProj = 0");
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get All Projects for this Client
$stmt = "SELECT\n\t\t\t\t\t\tclientprojects.projectId,\n\t\t\t\t\t\tclientprojects.createdBy,\n\t\t\t\t\t\tclientprojects.clientId,\n\t\t\t\t\t\tclientprojects.projectName,\n\t\t\t\t\t\tclientprojects.percentComplete,\n\t\t\t\t\t\tDATE_FORMAT(clientprojects.dueDate,'%M %d, %Y') AS dueDate,\n\t\t\t\t\t\tassignedprojects.assignedTo,\n\t\t\t\t\t\tCONCAT(admins.adminFirstName,' ',admins.adminLastName) AS theAdmin\n\t\t\t\t\tFROM\n\t\t\t\t\t\tclientprojects\n\t\t\t\t\t\tLEFT JOIN assignedprojects ON clientprojects.projectId = assignedprojects.projectId\n\t\t\t\t\t\tLEFT JOIN admins ON assignedprojects.assignedTo = admins.adminId\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tclientprojects.clientId = " . $clientId . " AND\n\t\t\t\t\t\tclientprojects.archiveProj = 0\n\t\t\t\t\tORDER BY clientprojects.projectId\n\t\t" . $pages->get_limit();
$results = mysqli_query($mysqli, $stmt) or die('-2' . mysqli_error());
} else {
// Include Pagination Class
include 'includes/getpagination.php';
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT\n\t\t\t\t\t\t\t\t\t*\n\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\tclientprojects\n\t\t\t\t\t\t\t\t\tLEFT JOIN assignedprojects ON clientprojects.projectId = assignedprojects.projectId\n\t\t\t\t\t\t\t\t\tLEFT JOIN admins ON assignedprojects.assignedTo = admins.adminId\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tclientprojects.clientId = " . $clientId . " AND\n\t\t\t\t\t\t\t\t\tclientprojects.archiveProj = 0 AND\n\t\t\t\t\t\t\t\t\tassignedprojects.assignedTo = " . $adminId);
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Projects Assigned to the logged in Manager
$stmt = "SELECT\n\t\t\t\t\t\tclientprojects.projectId,\n\t\t\t\t\t\tclientprojects.clientId,\n\t\t\t\t\t\tclientprojects.projectName,\n\t\t\t\t\t\tclientprojects.percentComplete,\n\t\t\t\t\t\tDATE_FORMAT(clientprojects.dueDate,'%M %d, %Y') AS dueDate,\n\t\t\t\t\t\tassignedprojects.assignedTo,\n\t\t\t\t\t\tCONCAT(admins.adminFirstName,' ',admins.adminLastName) AS theAdmin\n\t\t\t\t\tFROM\n\t\t\t\t\t\tclientprojects\n\t\t\t\t\t\tLEFT JOIN assignedprojects ON clientprojects.projectId = assignedprojects.projectId\n\t\t\t\t\t\tLEFT JOIN admins ON assignedprojects.assignedTo = admins.adminId\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tclientprojects.clientId = " . $clientId . " AND\n\t\t\t\t\t\tclientprojects.archiveProj = 0 AND\n\t\t\t\t\t\tassignedprojects.assignedTo = " . $adminId . "\n\t\t\t\t\tORDER BY clientprojects.projectId\n\t\t" . $pages->get_limit();
$results = mysqli_query($mysqli, $stmt) or die('-3' . mysqli_error());
}
include 'includes/navigation.php';
?>
<div class="contentAlt no-margin">
<div class="row">
<div class="col-md-8">
<div class="content">
public static function get($totalCount, $currentPage, $recordsPerPage = 10, $pagesPerBlock = 9, $urlPattern = '', $viewStartEnd = FALSE)
{
$paginator = new paginator($totalCount, $currentPage, $recordsPerPage, $pagesPerBlock = 9, $urlPattern, $viewStartEnd);
return $paginator->toArray();
}
// Update the Project Record
$paymentNumber = $projectPayments - 1;
$stmt = $mysqli->prepare("UPDATE clientprojects SET projectPayments = ? WHERE projectId = ?");
$stmt->bind_param('ss', $paymentNumber, $projectId);
$stmt->execute();
$stmt->close();
// Delete the Payment
$stmt = $mysqli->prepare("DELETE FROM projectpayments WHERE paymentId = ?");
$stmt->bind_param('s', $_POST['deleteId']);
$stmt->execute();
$msgBox = alertBox($paymentDeletedMsg, "<i class='fa fa-check-square'></i>", "success");
$stmt->close();
}
// Include Pagination Class
include 'includes/getpagination.php';
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM projectpayments WHERE projectId = " . $projectId);
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Payment Data
$query = "SELECT\n\t\t\t\tprojectpayments.paymentId,\n\t\t\t\tprojectpayments.projectId,\n\t\t\t\tprojectpayments.invoiceId,\n\t\t\t\tprojectpayments.paymentFor,\n\t\t\t\tDATE_FORMAT(projectpayments.paymentDate,'%M %d, %Y') AS paymentDate,\n\t\t\t\tUNIX_TIMESTAMP(projectpayments.paymentDate) AS orderDate,\n\t\t\t\tprojectpayments.paidBy,\n\t\t\t\tprojectpayments.paymentAmount,\n\t\t\t\tprojectpayments.additionalFee,\n\t\t\t\tprojectpayments.paymentNotes,\n\t\t\t\tclientprojects.projectName,\n\t\t\t\tclientprojects.projectPayments\n\t\t\tFROM\n\t\t\t\tprojectpayments\n\t\t\t\tLEFT JOIN clientprojects ON projectpayments.projectId = clientprojects.projectId\n\t\t\tWHERE\n\t\t\t\tprojectpayments.projectId = " . $projectId . "\n\t\t\tORDER BY orderDate DESC " . $pages->get_limit();
$res = mysqli_query($mysqli, $query) or die('-1' . mysqli_error());
// Only allow access to the Assigned Manager or Admins
$qry = "SELECT\n\t\t\t\tassignedprojects.assignedTo\n\t\t\tFROM\n\t\t\t\tassignedprojects\n\t\t\t\tLEFT JOIN clientprojects ON assignedprojects.projectId = clientprojects.projectId\n\t\t\tWHERE assignedprojects.projectId = " . $projectId;
$result = mysqli_query($mysqli, $qry) or die('-2' . mysqli_error());
$rows = mysqli_fetch_assoc($result);
$assignedTo = $rows['assignedTo'];
include 'includes/navigation.php';
if ($isAdmin != '1' && $rows['assignedTo'] != $adminId) {
} else {
$msgBox = alertBox($emailErrorMsg, "<i class='fa fa-warning'></i>", "warning");
}
} else {
$msgBox = alertBox($invCreatedNoEmail, "<i class='fa fa-check-square'></i>", "success");
}
// Clear the Form of values
$_POST['invoiceDue'] = $_POST['invoiceTitle'] = $_POST['invoiceNotes'] = '';
}
}
}
}
// Include Pagination Class
include 'includes/pagination.php';
// Create new object & pass in the number of pages and an identifier
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$cols = $mysqli->query("SELECT * FROM invoices");
$total = mysqli_num_rows($cols);
// Pass the number of total records
$pages->set_total($total);
// Get Data
$query = "SELECT\n\t\t\t\tinvoices.invoiceId,\n\t\t\t\tinvoices.projectId,\n\t\t\t\tinvoices.adminId,\n\t\t\t\tinvoices.clientId,\n\t\t\t\tinvoices.invoiceTitle,\n\t\t\t\tinvoices.invoiceNotes,\n\t\t\t\tDATE_FORMAT(invoices.invoiceDue,'%M %d, %Y') AS invoiceDue,\n\t\t\t\tUNIX_TIMESTAMP(invoices.invoiceDue) AS orderDate,\n\t\t\t\tinvoices.isPaid,\n\t\t\t\tclientprojects.projectName,\n\t\t\t\tCONCAT(clients.clientFirstName,' ',clients.clientLastName) AS theClient,\n\t\t\t\tCONCAT(admins.adminFirstName,' ',admins.adminLastName) AS theAdmin\n\t\t\tFROM\n\t\t\t\tinvoices\n\t\t\t\tLEFT JOIN clientprojects ON invoices.projectId = clientprojects.projectId\n\t\t\t\tLEFT JOIN clients ON invoices.clientId = clients.clientId\n\t\t\t\tLEFT JOIN admins ON invoices.adminId = admins.adminId\n\t\t\tORDER BY invoices.isPaid, orderDate " . $pages->get_limit();
$res = mysqli_query($mysqli, $query) or die('-2' . mysqli_error());
include 'includes/navigation.php';
?>
<div class="contentAlt">
<ul class="nav nav-tabs">
<li class="pull-right"><a data-toggle="modal" href="#newInvoice"><i class="fa fa-plus"></i> <?php
echo $createNewInvoiceTabLink;
?>
<?php
if (!empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
require_once 'config.php';
require_once 'paginator_class.php';
$recordsCountSelected = $_POST['records-count'];
$startRecord = $_POST['start-record'];
$paginator_class = new paginator();
$result = $mysqli->query("SELECT series, number, start_date, end_date, status FROM table_1 LIMIT {$recordsCountSelected}");
while ($rows = $result->fetch_assoc()) {
echo "<tr class='table-rows'>";
echo "<td><a href='detail.php?number=" . $rows['number'] . "'>" . $rows['series'] . "</a></td>";
echo "<td><a href='detail.php?number=" . $rows['number'] . "'>" . $rows['number'] . "</a></td>";
echo "<td><a href='detail.php?number=" . $rows['number'] . "'>" . $rows['start_date'] . "</a></td>";
echo "<td><a href='detail.php?number=" . $rows['number'] . "'>" . $rows['end_date'] . "</a></td>";
echo "<td><a href='detail.php?number=" . $rows['number'] . "'>" . $rows['status'] . "</a></td>";
echo "<td><input type='checkbox' value='" . $rows['number'] . "'></td>";
echo "</tr>";
}
$result = $mysqli->query("SELECT COUNT(*) FROM table_1");
$rowCountAr = $result->fetch_assoc();
$recordsCount = $rowCountAr['COUNT(*)'];
$paginator_class->checkRecordCount($recordsCount, $recordsCountSelected);
}
$highlight = 'text-danger';
}
if ($row['assignedTo'] != '') {
$isManager = '1';
} else {
$isManager = '0';
}
// Get the Current Status of the Project
if ($row['archiveProj'] == '0') {
$curStatus = '<strong class="text-success">' . $openProjText . '</strong>';
} else {
$curStatus = '<strong class="text-danger">' . $closedProjText . ' ' . $row['archiveDate'] . '</strong>';
}
// Include Pagination Class
include 'includes/getpagination.php';
$pages = new paginator($pagPages, 'p');
// Get the number of total records for Private Closed
$rows = $mysqli->query("SELECT * FROM pwentries WHERE projectId = " . $projectId);
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Project Accounts & Passwords
$sql = "SELECT\n\t\t\t\tentryId,\n\t\t\t\tprojectId,\n\t\t\t\tadminId,\n\t\t\t\tclientId,\n\t\t\t\tentryTitle,\n\t\t\t\tentryDesc,\n\t\t\t\tentryUsername,\n\t\t\t\tentryPass,\n\t\t\t\tentryUrl,\n\t\t\t\tentryNotes\n FROM\n pwentries\n WHERE\n projectId = " . $projectId . " " . $pages->get_limit();
$results = mysqli_query($mysqli, $sql) or die('-9' . mysqli_error());
// Get Project Tasks
if ($isAdmin == '1') {
$tasks = "SELECT\n\t\t\t\t\t\ttasks.taskId,\n\t\t\t\t\t\ttasks.projectId,\n\t\t\t\t\t\ttasks.adminId,\n\t\t\t\t\t\ttasks.taskTitle,\n\t\t\t\t\t\ttasks.taskDesc,\n\t\t\t\t\t\ttasks.taskPriority,\n\t\t\t\t\t\ttasks.taskStatus,\n\t\t\t\t\t\tDATE_FORMAT(tasks.taskDue,'%M %d, %Y') AS taskDue,\n\t\t\t\t\t\tCONCAT(admins.adminFirstName,' ',admins.adminLastName) AS theAdmin\n\t\t\t\t\tFROM\n\t\t\t\t\t\ttasks\n\t\t\t\t\t\tLEFT JOIN admins ON tasks.adminId = admins.adminId\n\t\t\t\t\tWHERE\n\t\t\t\t\t\ttasks.projectId = " . $projectId . " AND\n\t\t\t\t\t\ttasks.isClosed = 0\n\t\t\t\t\tORDER BY tasks.taskId";
$taskres = mysqli_query($mysqli, $tasks) or die('-10' . mysqli_error());
} else {
$tasks = "SELECT\n\t\t\t\t\t\ttasks.taskId,\n\t\t\t\t\t\ttasks.projectId,\n\t\t\t\t\t\ttasks.adminId,\n\t\t\t\t\t\ttasks.taskTitle,\n\t\t\t\t\t\ttasks.taskDesc,\n\t\t\t\t\t\ttasks.taskPriority,\n\t\t\t\t\t\ttasks.taskStatus,\n\t\t\t\t\t\tDATE_FORMAT(tasks.taskDue,'%M %d, %Y') AS taskDue,\n\t\t\t\t\t\tCONCAT(admins.adminFirstName,' ',admins.adminLastName) AS theAdmin\n\t\t\t\t\tFROM\n\t\t\t\t\t\ttasks\n\t\t\t\t\t\tLEFT JOIN admins ON tasks.adminId = admins.adminId\n\t\t\t\t\tWHERE\n\t\t\t\t\t\ttasks.projectId = " . $projectId . " AND\n\t\t\t\t\t\ttasks.adminId = " . $adminId . " AND\n\t\t\t\t\t\ttasks.isClosed = 0\n\t\t\t\t\tORDER BY tasks.taskId";
$taskres = mysqli_query($mysqli, $tasks) or die('-11' . mysqli_error());
function dbGetDataTable($devName, $limit, $page, $links)
{
$conn = dbConnect();
$query = "SELECT devTableName,devNumOfFields FROM devices WHERE devName='" . $devName . "'";
$result = mysqli_query($conn, $query) or die("impossible to do query1 - getDataTable: " . $query);
$devMainInfo = mysqli_fetch_assoc($result);
$query = "SELECT * FROM " . $devMainInfo['devTableName'] . " ORDER BY tableLogId DESC";
$paginator = new paginator($conn, $query);
$query = $paginator->getPaginatorQuery($limit, $page);
$result = mysqli_query($conn, $query) or die("impossible to do query2 - getDataTable: " . $query);
if (mysqli_num_rows($result) > 0) {
for ($i = 0; $i < mysqli_num_rows($result); $i++) {
$dataTableRow = mysqli_fetch_array($result);
$myRow['logId'] = $dataTableRow['tableLogId'];
$myRow['logDate'] = $dataTableRow['logDate'];
$myRow['logTime'] = $dataTableRow['logTime'];
$data = array();
for ($j = 0; $j < $devMainInfo['devNumOfFields']; $j++) {
$data[] = $dataTableRow[$j + 3];
}
$myRow['data'] = $data;
$table[] = $myRow;
}
} else {
$conn->close();
return false;
}
// ['logId'] ['devName']['logDate']['logTime'] ['data']
//table[][] = {logId(tbaleName+tableLogId), devName, logDate, logTime, (array)data}
$extraGetParams = "&devName=" . $devName;
$table['links'] = $paginator->createLinks($links, 'pagination pagination-sm', $extraGetParams);
$conn->close();
return $table;
}
<?php
$pagPages = '10';
$openProjects = '';
$openInvoices = '';
// Include Pagination Class
include 'includes/pagination.php';
// Create new object & pass in the number of pages and an identifier
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM clients WHERE isActive = 1");
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Data
$query = "SELECT\n\t\t\t\tclientId,\n\t\t\t\tclientEmail,\n\t\t\t\tCONCAT(clientFirstName,' ',clientLastName) AS theClient,\n\t\t\t\tclientCompany,\n\t\t\t\tclientPhone,\n\t\t\t\tDATE_FORMAT(lastVisited,'%M %e, %Y') AS lastVisited,\n\t\t\t\tisArchived\n\t\t\tFROM\n\t\t\t\tclients\n\t\t\tWHERE\n\t\t\t\tisActive = 1\n\t\t\tORDER BY\n\t\t\t\tclientId " . $pages->get_limit();
$res = mysqli_query($mysqli, $query) or die('-1' . mysqli_error());
include 'includes/navigation.php';
?>
<div class="contentAlt">
<ul class="nav nav-tabs">
<li class="active"><a href="" data-toggle="tab"><i class="fa fa-user"></i> <?php
echo $activeClientsTabLink;
?>
</a></li>
<li><a href="index.php?action=inactiveClients"><i class="fa fa-archive"></i> <?php
echo $inactiveClientsTabLink;
?>
</a></li>
<li class="pull-right"><a href="index.php?action=newClient"><i class="fa fa-plus"></i> <?php
echo $newClientTabLink;
<?php
error_reporting(E_ALL);
session_start();
require_once '../../classes/class.mysqli.php';
require_once '../../includes/required.inc.php';
require_once '../../classes/class.encryption.php';
require_once '../../classes/class.log.php';
require_once '../../classes/class.user.php';
include_once '../../classes/class.form.php';
include_once '../../classes/class.pager.php';
$pager = new paginator();
$form = new Form();
$log = new LogActivity();
$db2 = new MysqliDb(DBHOST, DBUSER, DBPASS, DBNAME);
isset($_POST['page']) ? $currentPage = $_POST['page'] : ($currentPage = 0);
$pageLimit = 50;
if ($currentPage == 0) {
$currentPage = 1;
}
$limitFrom = $pageLimit * $currentPage - $pageLimit;
switch ($_POST['f']) {
//search by region
case 'fetch_logs':
//db2 is for getting total number of rows
if (isset($_POST['search_term']) && $_POST['search_term'] != null) {
$db->where('action LIKE "%' . $_POST['search_term'] . '%"');
$db2->where('action LIKE "%' . $_POST['search_term'] . '%"');
} else {
$db->where('action LIKE "%%"');
$db2->where('action LIKE "%%"');
<?php
$pagPages = '10';
// Include Pagination Class
include 'includes/pagination.php';
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM clientprojects WHERE clientId = " . $clientId . " AND archiveProj = '1'");
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Data
$sqlStmt = "SELECT\n\t\t\t\t\tclientprojects.projectId,\n\t\t\t\t\tclientprojects.clientId,\n\t\t\t\t\tclientprojects.projectName,\n\t\t\t\t\tclientprojects.projectFee,\n\t\t\t\t\tclientprojects.projectDeatils,\n\t\t\t\t\tDATE_FORMAT(clientprojects.dueDate,'%M %d, %Y') AS dueDate,\n\t\t\t\t\tclientprojects.archiveProj,\n\t\t\t\t\tDATE_FORMAT(clientprojects.archiveDate,'%M %d, %Y') AS archiveDate,\n\t\t\t\t\tassignedprojects.assignedTo,\n\t\t\t\t\tCONCAT(admins.adminFirstName,' ',admins.adminLastName) AS manager\n\t\t\t\tFROM\n\t\t\t\t\tclientprojects\n\t\t\t\t\tLEFT JOIN assignedprojects ON clientprojects.projectId = assignedprojects.projectId\n\t\t\t\t\tLEFT JOIN admins ON assignedprojects.assignedTo = admins.adminId\n\t\t\t\tWHERE clientprojects.clientId = " . $clientId . " AND clientprojects.archiveProj = '1'\n\t\t\t\tORDER BY clientprojects.projectId " . $pages->get_limit();
$res = mysqli_query($mysqli, $sqlStmt) or die('-1' . mysqli_error());
include 'includes/navigation.php';
?>
<div class="contentAlt">
<ul class="nav nav-tabs">
<li><a href="index.php?page=openProjects"><i class="fa fa-folder-open-o"></i> <?php
echo $openProjectsLink;
?>
</a></li>
<li class="active"><a href="#closed" data-toggle="tab"><i class="fa fa-check-square-o"></i> <?php
echo $closedProjectsLink;
?>
</a></li>
<li><a href="index.php?page=myRequests"><i class="fa fa-comments-o"></i> <?php
echo $projectRequestsLink;
?>
</a></li>
</ul>
$deleteId = $mysqli->real_escape_string($_POST['deleteId']);
// Delete the Discussion Topic
$stmt = $mysqli->prepare("DELETE FROM projectdiscus WHERE discussionId = ?");
$stmt->bind_param('s', $_POST['deleteId']);
$stmt->execute();
$stmt->close();
// Delete all of the comments associated with the Discussion Topic
$stmt = $mysqli->prepare("DELETE FROM replies WHERE discussionId = ?");
$stmt->bind_param('s', $_POST['deleteId']);
$stmt->execute();
$stmt->close();
$msgBox = alertBox($discThreadDeletedMsg, "<i class='fa fa-check-square'></i>", "success");
}
// Include Pagination Class
include 'includes/getpagination.php';
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM projectdiscus WHERE projectId = " . $projectId);
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get Project Discussions
$sql = "SELECT\n\t\t\t\tprojectdiscus.discussionId,\n\t\t\t\tprojectdiscus.projectId,\n\t\t\t\tprojectdiscus.adminId,\n\t\t\t\tprojectdiscus.clientId,\n\t\t\t\tprojectdiscus.discussionTitle,\n\t\t\t\tprojectdiscus.discussionText,\n\t\t\t\tDATE_FORMAT(projectdiscus.discussionDate,'%W, %M %e, %Y') AS discussionDate,\n\t\t\t\tUNIX_TIMESTAMP(projectdiscus.discussionDate) AS orderDate,\n\t\t\t\tDATE_FORMAT(projectdiscus.lastUpdated,'%W, %M %e, %Y') AS lastUpdated,\n\t\t\t\tCONCAT(clients.clientFirstName,' ',clients.clientLastName) AS theClient,\n\t\t\t\tCONCAT(admins.adminFirstName,' ',admins.adminLastName) AS theAdmin\n\t\t\tFROM\n\t\t\t\tprojectdiscus\n\t\t\t\tLEFT JOIN clients ON projectdiscus.clientId = clients.clientId\n\t\t\t\tLEFT JOIN admins ON projectdiscus.adminId = admins.adminId\n\t\t\tWHERE\n\t\t\t\tprojectdiscus.projectId = " . $projectId . "\n\t\t\tORDER BY orderDate " . $pages->get_limit();
$res = mysqli_query($mysqli, $sql) or die('-1' . mysqli_error());
// Only allow access to the Assigned Manager or Admins
$qry = "SELECT\n\t\t\t\tassignedprojects.assignedTo,\n\t\t\t\tclientprojects.projectName\n\t\t\tFROM\n\t\t\t\tassignedprojects\n\t\t\t\tLEFT JOIN clientprojects ON assignedprojects.projectId = clientprojects.projectId\n\t\t\tWHERE assignedprojects.projectId = " . $projectId;
$result = mysqli_query($mysqli, $qry) or die('-2' . mysqli_error());
$rows = mysqli_fetch_assoc($result);
$assignedTo = $rows['assignedTo'];
include 'includes/navigation.php';
if ($isAdmin != '1' && $rows['assignedTo'] != $adminId) {
<?php
$pagPages = '10';
// Delete Project
if (isset($_POST['submit']) && $_POST['submit'] == 'deleteClient') {
$projectId = $mysqli->real_escape_string($_POST['projectId']);
$stmt = $mysqli->prepare("DELETE FROM clientprojects WHERE projectId = ?");
$stmt->bind_param('s', $projectId);
$stmt->execute();
$stmt->close();
$msgBox = alertBox($projectDeletedMsg, "<i class='fa fa-check-square'></i>", "success");
}
// Include Pagination Class
include 'includes/pagination.php';
// Create new object & pass in the number of pages and an identifier
$pages = new paginator($pagPages, 'p');
// Get the number of total records
$rows = $mysqli->query("SELECT * FROM clientprojects WHERE archiveProj = 1");
$total = mysqli_num_rows($rows);
// Pass the number of total records
$pages->set_total($total);
// Get All Projects
$stmt = "SELECT\n\t\t\t\tclientprojects.projectId,\n\t\t\t\tclientprojects.createdBy,\n\t\t\t\tclientprojects.clientId,\n\t\t\t\tclientprojects.projectName,\n\t\t\t\tclientprojects.projectFee,\n\t\t\t\tclientprojects.projectPayments,\n\t\t\t\tDATE_FORMAT(clientprojects.dueDate,'%M %e, %Y') AS dueDate,\n\t\t\t\tUNIX_TIMESTAMP(clientprojects.dueDate) AS orderDate,\n\t\t\t\tDATE_FORMAT(clientprojects.archiveDate,'%M %e, %Y') AS archiveDate,\n\t\t\t\tassignedprojects.assignedTo,\n\t\t\t\tCONCAT(admins.adminFirstName,' ',admins.adminLastName) AS theAdmin,\n\t\t\t\tCONCAT(clientFirstName,' ',clientLastName) AS theClient\n\t\t\tFROM\n\t\t\t\tclientprojects\n\t\t\t\tLEFT JOIN assignedprojects ON clientprojects.projectId = assignedprojects.projectId\n\t\t\t\tLEFT JOIN admins ON assignedprojects.assignedTo = admins.adminId\n\t\t\t\tLEFT JOIN clients ON clientprojects.clientId = clients.clientId\n\t\t\tWHERE\n\t\t\t\tclientprojects.archiveProj = 1\n\t\t\tORDER BY orderDate, clientprojects.clientId " . $pages->get_limit();
$results = mysqli_query($mysqli, $stmt) or die('-1' . mysqli_error());
include 'includes/navigation.php';
?>
<div class="contentAlt">
<ul class="nav nav-tabs">
<li><a href="index.php?action=openProjects"><i class="fa fa-folder-open"></i> <?php
echo $openProjNavLink;
?>
