$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; ?> </h3> <div class="alertMsg danger"> <i class="fa fa-warning"></i> <?php echo $permissionDenied; ?> </div> </div>
$_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; ?> </a></li> </ul> </div> <div class="content last"> <h3><?php echo $pageName;
<?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>
} $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"> <h3><?php echo $accessErrorHeader; ?> </h3> <div class="alertMsg danger"> <i class="fa fa-warning"></i> <?php echo $permissionDenied;
$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> <?php if ($msgBox) { echo $msgBox; } ?> <?php
<?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;
$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; ?> </a></li> <li class="active"><a href="" data-toggle="tab"><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;
// 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"> <input name="pmPage" id="pmPage" type="hidden" value="<?php echo $pmPage; ?> " /> <ul class="nav nav-tabs">
<?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) { ?>
} } } } } // 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; ?> </a></li> <li><a href="index.php?action=projectTasks"><i class="fa fa-folder-open"></i> <?php echo $projectTaskTabLink; ?> </a></li> <li><a href="index.php?action=closedTasks"><i class="fa fa-check-circle"></i> <?php echo $closedTasksTabLink;
// 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"> <?php if ($msgBox) { echo $msgBox; } ?> <div class="well well-xs comments"> <img src="<?php
<?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 $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\tDATE_FORMAT(lastVisited,'%M %e, %Y') AS lastVisited,\n\t\t\t\tisAdmin,\n\t\t\t\tadminRole\n\t\t\tFROM\n\t\t\t\tadmins\n\t\t\tWHERE\n\t\t\t\tisActive = 1\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; ?> </h3> <div class="alertMsg danger"> <i class="fa fa-warning"></i> <?php echo $permissionDenied; ?> </div> </div> <?php } else {
$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) { ?> <div class="content"> <h3><?php echo $accessErrorHeader; ?> </h3> <div class="alertMsg danger">
} } } } } // 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; ?> </a></li> <li><a href="index.php?action=projectTasks"><i class="fa fa-folder-open"></i> <?php echo $projectTaskTabLink; ?> </a></li> <li class="active"><a href="#closed" data-toggle="tab"><i class="fa fa-check-circle"></i> <?php echo $closedTasksTabLink;
$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> <div class="content last"> <h3><?php echo $pageName; ?> </h3> <?php
$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; ?> </a></li> <li><a href="index.php?page=closedProjects"><i class="fa fa-check-square-o"></i> <?php echo $closedProjectsLink; ?> </a></li> <li class="active"><a href="#requests" data-toggle="tab"><i class="fa fa-comments-o"></i> <?php echo $projectRequestsLink;
// 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()); } if ($set['enablePayments'] == '1') { // Get the project payments $payments = "SELECT\n projectpayments.paymentId,\n\t\t\t\t\t\tprojectpayments.projectId,\n\t\t\t\t\t\tprojectpayments.enteredBy,\n\t\t\t\t\t\tprojectpayments.paymentFor,\n\t\t\t\t\t\tDATE_FORMAT(projectpayments.paymentDate,'%M %d, %Y') AS paymentDate,\n\t\t\t\t\t\tprojectpayments.paidBy,\n\t\t\t\t\t\tprojectpayments.paymentAmount,\n\t\t\t\t\t\tprojectpayments.additionalFee,\n\t\t\t\t\t\tprojectpayments.paymentNotes,\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\tprojectpayments\n\t\t\t\t\t\tLEFT JOIN admins ON projectpayments.enteredBy = admins.adminId\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tprojectpayments.projectId = " . $projectId . "\n ORDER BY projectpayments.paymentId DESC"; $payres = mysqli_query($mysqli, $payments) or die('-12' . mysqli_error()); $invQry = "SELECT\n\t\t\t\t\t\tinvoices.invoiceId,\n\t\t\t\t\t\tinvoices.projectId,\n\t\t\t\t\t\tinvoices.adminId,\n\t\t\t\t\t\tinvoices.clientId,\n\t\t\t\t\t\tinvoices.invoiceTitle,\n\t\t\t\t\t\tinvoices.invoiceNotes,\n\t\t\t\t\t\tDATE_FORMAT(invoices.invoiceDue,'%M %d, %Y') AS invoiceDue,\n\t\t\t\t\t\tUNIX_TIMESTAMP(invoices.invoiceDue) AS orderDate,\n\t\t\t\t\t\tinvoices.isPaid,\n\t\t\t\t\t\tclientprojects.projectName,\n\t\t\t\t\t\tCONCAT(clients.clientFirstName,' ',clients.clientLastName) AS theClient,\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\tinvoices\n\t\t\t\t\t\tLEFT JOIN clientprojects ON invoices.projectId = clientprojects.projectId\n\t\t\t\t\t\tLEFT JOIN clients ON invoices.clientId = clients.clientId\n\t\t\t\t\t\tLEFT JOIN admins ON invoices.adminId = admins.adminId\n\t\t\t\t\tWHERE invoices.projectId = " . $projectId . " AND invoices.isPaid = 0\n\t\t\t\t\tORDER BY invoices.isPaid, orderDate"; $invres = mysqli_query($mysqli, $invQry) or die('-13' . mysqli_error());
$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) { ?> <div class="content"> <h3><?php echo $accessErrorHeader; ?> </h3> <div class="alertMsg danger">
$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; ?> </a></li> <li class="active"><a href="" data-toggle="tab"><i class="fa fa-folder"></i> <?php echo $pageNameclosedProjects; ?> </a></li> <li class="pull-right"><a href="index.php?action=newProject"><i class="fa fa-plus"></i> <?php echo $pageNamenewProject;