$projectid = isset($_REQUEST['projectid']) ? (int) $_REQUEST['projectid'] : 0;
$msg = isset($_REQUEST['msg']) ? (int) $_REQUEST['msg'] : 0;
$i = isset($_REQUEST['i']) ? (int) $_REQUEST['i'] : 0;
$adminid = isset($_SESSION['adminid']) ? (int) $_SESSION['adminid'] : 0;
$userid = isset($_SESSION['uid']) ? (int) $_SESSION['uid'] : 0;
if ($adminid) {
$result = select_query("tbladdonmodules", "value", array("module" => "project_management", "setting" => "access"));
$data = mysql_fetch_array($result);
$allowedroles = explode(",", $data[0]);
$result = select_query("tbladmins", "roleid", array("id" => $adminid));
$data = mysql_fetch_array($result);
$adminroleid = $data[0];
if (!in_array($adminroleid, $allowedroles)) {
exit("Access Denied");
}
if (!project_management_check_viewproject($projectid)) {
exit("Access Denied");
}
} else {
if ($userid) {
$accessallowed = get_query_val("mod_project", "id", array("id" => $projectid, "userid" => $userid));
if (!$accessallowed) {
exit("Access Denied");
}
} else {
exit("Access Denied");
}
}
if ($msg) {
if (!$adminid) {
exit("Access Denied");
}
$editprojecthtml = $show_project ? "<a href=\"" . str_replace("m=overview", "m=view", $modulelink) . "&projectid=" . $projectid . "\"><img src=\"images/edit.gif\" border=\"0\" /></a>" : "";
$deleteprojecthtml = project_management_checkperm("Delete Projects") ? "<a href=\"#\" onclick=\"doDelete('" . $projectid . "');return false\"><img src=\"images/delete.gif\" border=\"0\" /></a>" : "";
$tabledata[] = array("<div align=\"left\">" . $title . "</div>", $adminuser, $status, $created, $duedate, "<div id=\"progressbar" . $projectid . "\"></div>", $daysleft, $lastmodified, $editprojecthtml, $deleteprojecthtml);
}
echo $aInt->sortableTable(array(array("title", $vars['_lang']['projectname']), $vars['_lang']['assignedto'], array("status", $vars['_lang']['status']), array("created", $vars['_lang']['created']), array("duedate", $vars['_lang']['duedate']), array("progress", $vars['_lang']['projectprogress']), array("duedate", $vars['_lang']['daysleft']), array("lastmodified", $vars['_lang']['lastmodified']), "", ""), $tabledata);
}
echo "\n</td><td width=\"1%\"></td><td width=\"19%\" valign=\"top\">";
if (project_management_checkperm("View Recent Activity")) {
echo "<div align=\"center\"><b>" . $vars['_lang']['recentactivity'] . "</b></div>";
$result = select_query("mod_projectlog", "mod_projectlog.*,(SELECT CONCAT(firstname,' ',lastname) FROM tbladmins WHERE tbladmins.id=mod_projectlog.adminid) AS admin,(SELECT title FROM mod_project WHERE mod_project.id=mod_projectlog.projectid) AS projectname, (SELECT adminid FROM mod_project WHERE mod_project.id=mod_projectlog.projectid) as assignedadminid", "", "id", "DESC", "0,10");
$projectid = "";
while ($data = mysql_fetch_array($result)) {
$date = $data['date'];
$projectid = $data['projectid'];
$projectname = project_management_check_viewproject($projectid) ? "<a href=\"" . $modulelink . "&m=view&projectid=" . $projectid . "\">" . $data['projectname'] . "</a>" : $data['projectname'];
$msg = $data['msg'];
$admin = $data['admin'];
$date = fromMySQLDate($date, true);
if (project_management_checkperm("View Projects")) {
echo "<div class=\"recentactivity\" onclick=\"window.location='" . $modulelink . "&m=view&projectid=" . $projectid . "'\"><div class=\"title\"><a href=\"" . $modulelink . "&m=view&projectid=" . $projectid . "\">" . $projectname . "</a></div><div class=\"desc\">" . $msg . "</div><div style=\"float:left;\" class=\"small\">" . $admin . "</div><div style=\"float:right;\" class=\"small\">" . $date . "</div><div style=\"clear:both;\"></div></div>";
}
echo "<div class=\"recentactivity\"><div class=\"title\">" . $projectname . "</div><div class=\"desc\">" . $msg . "</div><div style=\"float:left;\" class=\"small\">" . $admin . "</div><div style=\"float:right;\" class=\"small\">" . $date . "</div><div style=\"clear:both;\"></div></div>";
}
echo "<div align=\"right\"><a href=\"" . $modulelink . "&m=activity\">View More »</a> </div>";
} else {
if (!project_management_checkperm("View Recent Activity")) {
echo "<div class=\"recentactivity\"><div class=\"desc\" align=\"center\"><br />Welcome to the<br /><strong>Project Management Addon</strong> for WHMCS!<br /><br />Please click on <strong>Create New Project</strong> on the menu bar above to begin creating your ";
}
if (!$projectid) {
echo "first ";
if (!$projectid) {
echo "<p><b>" . $vars['_lang']['viewingproject'] . "</b></p><p>" . $vars['_lang']['projectidnotfound'] . "</p>";
return null;
}
$title = $data['title'];
$attachments = $data['attachments'];
$ticketids = $data['ticketids'];
$notes = $data['notes'];
$userid = $data['userid'];
$adminid = $data['adminid'];
$created = $data['created'];
$duedate = $data['duedate'];
$completed = $data['completed'];
$projectstatus = $data['status'];
$lastmodified = $data['lastmodified'];
$show_project = project_management_check_viewproject($projectid) ? true : false;
if (!$show_project) {
redir("module=project_management");
}
$daysleft = project_management_daysleft($duedate, $vars);
$attachments = explode(",", $attachments);
$ticketids = explode(",", $ticketids);
$created = fromMySQLDate($created);
$duedate = fromMySQLDate($duedate);
$lastmodified = fromMySQLDate($lastmodified, true);
$client = "";
if (!$userid) {
foreach ($ticketids as $i => $ticketnum) {
if ($ticketnum) {
$result = select_query("tbltickets", "userid", array("tid" => $ticketnum));
$data = mysql_fetch_array($result);
