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