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; ?>