<?php include_once "include_db.php"; include_once "include_functions.php"; checkUserSessionandCookie(); $USERNAME = $_SESSION["uname"]; $TASKID = get_GET_var('taskid'); $manageWorks = new manageWorks(); $manageUsers = new manageUsers(); $manageProjects = new manageProjects(); $allPeers = $manageUsers->listOfAllPeerUsers($USERNAME); $taskDetails = $manageWorks->get_workDetails($TASKID); $taskDetails['work_briefDesc'] = $taskDetails['work_briefDesc'] ? $taskDetails['work_briefDesc'] : 'No Description'; $usersActiveProjects = $manageUsers->get_usersActiveProjects($USERNAME); // $allProjects // `workID`, // `work_userAssigned`, // `work_addedBy` , // `work_dateAdded` timestamp , // `work_deadLine` date , // `work_startDate` timestamp, // `work_completeDate` timestamp, // `work_briefDesc` text, // `work_Notes` text, // `work_status` '1', // `work_priority` 'N', // `work_projectName`, // `work_isPrivate` 'N', $workStatus = $taskDetails["work_status"]; switch ($workStatus) { case $DE_GLOBALS_WORK_NEW:
public function getUnreadComments($username, $howmany = 25) { // get the lastReadCommentIndex // get any comments greater than lastReadCommentIndex where commentTask is either 'assigned to' or 'assigned by' $username // mark the first one to use for markAllCommentsRead() $lastReadCommentIndex = executesql_returnArray("select user_lastReadCommentIndex from users where username='******'"); if (!$lastReadCommentIndex) { $lastReadCommentIndex = 0; } $result = mysql_query("select COMMENTS.commentID as commentID, COMMENTS.workID as workID, COMMENTS.comment_date as comment_date, COMMENTS.comment_by as comment_by, COMMENTS.comment as comment from COMMENTS, WORKS where COMMENTS.commentID > " . $lastReadCommentIndex . " and COMMENTS.workID=WORKS.workID and (WORKS.work_userAssigned='{$username}' or WORKS.work_addedBy='{$username}' ) ORDER BY COMMENTS.commentID DESC"); $readresult = mysql_query("select COMMENTS.commentID as commentID, COMMENTS.workID as workID, COMMENTS.comment_date as comment_date, COMMENTS.comment_by as comment_by, COMMENTS.comment as comment from COMMENTS, WORKS where COMMENTS.commentID <= " . $lastReadCommentIndex . " and COMMENTS.workID=WORKS.workID and (WORKS.work_userAssigned='{$username}' or WORKS.work_addedBy='{$username}' ) ORDER BY COMMENTS.commentID DESC LIMIT {$howmany}"); $nwcount = @mysql_num_rows($result); $rccount = @mysql_num_rows($readresult); if ($nwcount == 0 && $rccount == 0) { return; } $lastCommentPerson = ''; $manageWorks = new manageWorks(); ?> <script> var update_LRCI = function(username, lrci){ DE_USER_action( 'update_LRCI' , { username : username, lrci : lrci, callback:function(a){ if(a){ window.location.href = 'comments.php'; }else{ My_JsLibrary.showErrMsg() ; } } }); }; </script> <table style='margin-top:20px;'> <?php $rowcount = 0; while ($row = mysql_fetch_assoc($result)) { // $row['commentID'], $row['workID'], $row['comment_date'], $row['comment_by'], $row['comment'] // get description of this workID if ($rowcount == 0 && $nwcount > 0) { ?> <tr><td></td> <td align='right'> <a class='blueTextButton' href='#' onclick="update_LRCI('<?php echo $username; ?> ','<?php echo $row['commentID']; ?> ');">mark as read</a> </td> </tr> <?php } $rowcount++; $thisworkdetails = $manageWorks->get_workDetails($row['workID']); $this_bdesc = stripslashes($thisworkdetails['work_briefDesc']); ?> <tr><td valign='top' align='right'> <span style='font-weight:bold;'> <?php if ($lastCommentPerson != $row['comment_by']) { echo $row['comment_by']; } ?> </span> </td> <td><div class='ncs1'> <div class='ncd0' onclick="ManageTasksJsFunction.detailsWork('<?php echo $row['workID']; ?> ');"> <?php echo "Task " . $row['workID'] . ": " . getNwordsFromString($this_bdesc, 7); ?> ... </div> <div class='ncd1'><?php echo format_makeLinks(stripslashes(mynl2br($row['comment']))); ?> </div> <div class='nct1'><?php echo caldateTS_to_humanWithTS($row['comment_date']); ?> </div> </div> </td> </tr> <?php $lastCommentPerson = $row['comment_by']; } while ($row = mysql_fetch_assoc($readresult)) { // $row['commentID'], $row['workID'], $row['comment_date'], $row['comment_by'], $row['comment'] // get description of this workID $thisworkdetails = $manageWorks->get_workDetails($row['workID']); $this_bdesc = $thisworkdetails['work_briefDesc']; $this_classname = 'rcs1'; ?> <tr><td valign='top' align='right'> <span style='font-weight:bold; color: #A4A4A4;'> <?php if ($lastCommentPerson != $row['comment_by']) { echo $row['comment_by']; } ?> </span> </td> <td><div class='rcs1'> <div class='ncd0' onclick="ManageTasksJsFunction.detailsWork('<?php echo $row['workID']; ?> ');"> <?php echo "Task " . $row['workID'] . ": " . getNwordsFromString($this_bdesc, 7); ?> ... </div> <div class='ncd1'><?php echo mynl2br($row['comment']); ?> </div> <div class='nct1'><?php echo caldateTS_to_humanWithTS($row['comment_date']); ?> </div> </div> </td> </tr> <?php $lastCommentPerson = $row['comment_by']; } echo "</table>"; }
$manageWorks->addComment($workid, APPNAME, $COMMENTLOGMESSAGE); send_Action_Response('Success', "Details emailed !"); exit; break; case 'AddComment': $comment = htmlentities($_POST['newComment']); $workid = get_POST_var('workid'); $notifyAssigned = get_POST_var('notifyAssigned'); if (!checkPermissions_canUserViewTask($USERNAME, $workid)) { send_Action_Response('Fail', 'insufficient privilege !'); return; } $manageWorks = new manageWorks(); $manageWorks->addComment($workid, $USERNAME, $comment); if ($notifyAssigned == 'Y') { $ThisWorkDetails = $manageWorks->get_workDetails($workid); $userassigned = $ThisWorkDetails['work_userAssigned']; $userOwner = $ThisWorkDetails['work_addedBy']; $work_briefDesc = $ThisWorkDetails['work_briefDesc']; $OtherPerson = $USERNAME == $userassigned ? $userOwner : $userassigned; $tmp_notify_subject = "[#DE] new comment by {$USERNAME} on '{$work_briefDesc}' "; $tmp_notify_body = " <BR> New Comment :<BR> <B> {$comment} </B>\n\t\t\t\t\t\t\t\t<BR> -------------------------------------------\n\t\t\t\t\t\t\t\t<BR> Quick link to task : http://{$_SESSION['subdomain']}.discreteevents.com/taskdetails.php?taskid={$workid} "; NotifyEventEmail($OtherPerson, $USERNAME, $tmp_notify_subject, $tmp_notify_body); } send_Action_Response('Success', "Comment Added !"); exit; break; case 'AddNote': $newNote = get_POST_var('NewNoteText'); $manageNotes = new manageNotes(); $manageNotes->insertNote($newNote);