public function listWorksClosed()
{
global $DE_GLOBALS_WORK_CLOSED;
if (!$this->formedsql) {
$this->formSqlSelector();
}
$sqltoExecute = "select * from WORKS where work_status = '{$DE_GLOBALS_WORK_CLOSED}' {$this->sql_closedTasks} {$this->sqlselector}";
//echo "<BR><BR>$sqltoExecute<BR><BR>";
$query = mysql_query($sqltoExecute) or die("Invalid query: " . mysql_error());
$wcCount = @mysql_num_rows($query);
if ($wcCount == 0) {
echo "<center><div onclick='ManageTasksJsFunction.allClosedThisYear();' class='linkTextButton' style='margin-top:10px;'>Show all tasks closed this year</div></center>";
echo "<center><div onclick=\"ManageTasksJsFunction.allClosedThisYear('all');\" class='linkTextButton' style='margin-top:10px;'>Show all closed tasks </div></center>";
return;
}
?>
<div class='listclosedtasks'><span onclick="var ckval = String(jQuery('.WorksClosedTable').is(':hidden')); My_JsLibrary.cookies.setCookie( 'WCLT' , ckval ); $('.WorksClosedTable').toggle();"><?php
echo "Closed Tasks {$this->closedTasksPeriod} ({$wcCount})";
?>
</span></div>
<table align=center cellpadding=0 cellspacing=0 class="WorksClosedTable">
<TR><TD class="firstRow" width="110" align='right' style='cursor:pointer;' onclick="My_JsLibrary.updatePageWithGetVar('sortby', 'workID');">
<span style='margin-right:20px;'>Task ID<?php
if ($this->orderbyfield == 'workID') {
echo ' ↓';
}
?>
</span>
</TD>
<TD class="firstRow" width="125" style='cursor:pointer;' onclick="My_JsLibrary.updatePageWithGetVar('sortby', 'work_userAssigned');">
Assigned To<?php
if ($this->orderbyfield == 'work_userAssigned') {
echo ' ↓';
}
?>
</TD>
<?php
if (!$this->PersonalTasks) {
?>
<TD class="firstRow" width="145" style='cursor:pointer;' onclick="My_JsLibrary.updatePageWithGetVar('sortby', 'work_projectName');">
Project Name<?php
if ($this->orderbyfield == 'work_projectName') {
echo ' ↓';
}
?>
</TD>
<?php
}
?>
<TD class="firstRow" style='cursor:pointer;' onclick="My_JsLibrary.updatePageWithGetVar('sortby', 'work_priority');">
Task Description<?php
if ($this->orderbyfield == 'work_priority') {
echo ' ↓';
}
?>
</TD>
<TD class="firstRow" style='cursor:pointer;' onclick="My_JsLibrary.updatePageWithGetVar('sortby', 'work_closedDate');" width="125">Closed On<?php
if ($this->orderbyfield == 'work_closedDate') {
echo ' ↓';
}
?>
</TD>
<TD class="firstRow" style='cursor:pointer;' onclick="My_JsLibrary.updatePageWithGetVar('sortby', 'work_deadLine');" width="110">
Deadline<?php
if ($this->orderbyfield == 'work_deadLine') {
echo ' ↓';
}
?>
</TD>
</TR>
<?php
$tdclass = "oddrow";
$tmp_manageWorks = new manageWorks();
while ($row = @mysql_fetch_array($query)) {
extract($row);
$tdclass = $tdclass == "oddrow" ? 'evenrow' : 'oddrow';
// `workID`, `work_userAssigned`, `work_addedBy`, `work_dateAdded`, `work_deadLine`, `work_startDate`, `work_completeDate`,
// `work_briefDesc`, `work_Notes`, `work_status`, `work_priority`, `work_projectName`, `work_isPrivate`,
if ($work_priority == 'H') {
$work_briefDesc = HIGHPRIORITYAPPENDSTRING . $work_briefDesc;
} elseif ($work_priority == 'L') {
$work_briefDesc = LOWPRIORITYAPPENDSTRING . $work_briefDesc;
}
$work_briefDesc = $work_briefDesc ? $work_briefDesc : 'No Description';
?>
<TR><TD align='center' class='<?php
echo $tdclass;
?>
'>
<span style='float:right; margin-right:10px;'><?php
echo $workID;
?>
</span>
<?php
if ($tmp_manageWorks->taskHasAttachments($workID)) {
echo "<img src='/images/attach1.gif' width=15 height=15 border=0 class='image_attachment' taskid='" . $workID . "'>";
}
?>
<span style='float:right; margin-right:5px;'>
<img src='/images/letter.png' border=0 class='emailTaskBescImg' title='e-mail task description' taskid='<?php
echo $workID;
?>
'>
</span>
</TD>
<TD class='<?php
echo $tdclass;
?>
AssignedUser' style='cursor:default;' assignedto='<?php
echo $work_userAssigned;
?>
' assignedby='<?php
echo $work_addedBy;
?>
'>
<?php
if ($work_addedBy == $_SESSION["uname"] && $work_userAssigned == $_SESSION["uname"]) {
echo "<i>Self</i>";
} else {
$str_work_userAssigned = $work_userAssigned;
$str_work_addedBy = $work_addedBy;
if ($work_addedBy == $_SESSION["uname"]) {
$str_work_addedBy = YOUSTRING;
}
if ($work_userAssigned == $_SESSION["uname"]) {
$str_work_userAssigned = YOUSTRING;
}
echo "{$str_work_userAssigned}←{$str_work_addedBy}";
}
?>
</TD>
<?php
if (!$this->PersonalTasks) {
echo "<TD class='{$tdclass}'>{$work_projectName}</TD>";
}
?>
<TD class='<?php
echo $tdclass;
?>
OMOhilitLink' onclick="ManageTasksJsFunction.detailsWork('<?php
echo $workID;
?>
');" TITLE="<?php
echo $work_Notes;
?>
">
<?php
if ($tmp_manageWorks->taskHasNewComments($workID)) {
echo "<img src='/images/newcommentsblue.png' width=15 height=15 border=0 class='image_newcomments'>";
}
?>
<?php
if ($work_RTID) {
echo "<img src='/images/rt.png' border=0 width='31' height='15'>";
}
echo getNwordsOfLengthFromString(stripslashes($work_briefDesc), 90);
?>
</TD>
<TD class='<?php
echo $tdclass;
?>
'>
<NOBR>
<?php
echo caldateTS_to_humanWithOutTS($work_closedDate);
?>
</NOBR>
</TD>
<TD class='<?php
echo $tdclass;
?>
'>
<NOBR>
<?php
echo caldate_to_human($work_deadLine, true);
?>
</NOBR>
</TD>
</TR>
<?php
}
echo "</table>";
if ($this->closedTasksPeriod != 'in this Year') {
echo "<center><div onclick='ManageTasksJsFunction.allClosedThisYear();' class='linkTextButton' style='margin-top:10px;'>Show all tasks closed this year</div></center>";
echo "<center><div onclick=\"ManageTasksJsFunction.allClosedThisYear('all');\" class='linkTextButton' style='margin-top:10px;'>Show all closed tasks </div></center>";
}
}
<?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:
list($reminder_emailWhen, $reminder_emailHour, $reminder_emailBody) = parseReminderSubject($thisemail_subject);
// (caldate, timeofday , subject)
$reminder_emailTo = $thisemail_fromAddress;
$reminder_emailSubject = "[Reminder] {$reminder_emailBody}";
if ($DEVELOPMENT_MODE) {
echo "\n\t\t\t<PRE>\n\t\t\tIncoming Subject : {$thisemail_subject}\n\t\t\t-------------------------------------------\n\t\t\tReminder to : {$reminder_emailTo}\n\t\t\tReminder email body : {$reminder_emailBody}\n\t\t\tReminder email Subject : {$reminder_emailSubject}\n\t\t\tReminder email when : {$reminder_emailWhen}\n\t\t\tReminder email Hour : {$reminder_emailHour}\n\t\t\tSubdomain User : {$SUBDOMAIN_USER}\n\t\t\t</PRE>\n\t\t";
scheduleNewEmail_temp($reminder_emailTo, $reminder_emailBody, $reminder_emailSubject, $reminder_emailWhen, $reminder_emailHour, $SUBDOMAIN_USER);
} else {
scheduleNewEmail_temp($reminder_emailTo, $reminder_emailBody, $reminder_emailSubject, $reminder_emailWhen, $reminder_emailHour, $SUBDOMAIN_USER);
}
simpleEmail($thisemail_fromAddress, "Reminder Added", "Added Reminder on {$reminder_emailWhen}");
$processemail_debugoutput = "Added Reminder on {$reminder_emailWhen} \n for {$reminder_emailBody}";
}
if ($before_underscore == 'comments') {
if (preg_match('/TN(?<digit>\\d+)(.*)/i', $thisemail_subject, $matches)) {
$manageWorks = new manageWorks();
// $matches[2] = trim($matches[2]); rest of the subject after 'TNXXX'
$WORK_ID = $matches[1];
$manageWorks->addComment($WORK_ID, $SUBDOMAIN_USER, $thisemail_body);
$processemail_debugoutput = "Added Comment to Task {$WORK_ID} \n Comment: {$thisemail_body} ";
// If the email received has attachments , put attach those files to this task
$attachments = $Parser->getAttachments();
if (count($attachments)) {
$tmp_uploadedOn = get_currentPHPTimestamp();
foreach ($attachments as $attachment) {
$upload_filename = $attachment->filename;
$TMP_SOMENAME = '/tmp/' . getaRandomString(9);
if ($fp = fopen($TMP_SOMENAME, 'w')) {
while ($bytes = $attachment->read()) {
fwrite($fp, $bytes);
}
<?php
include_once "include_db.php";
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
// date in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
// always modified
header("Cache-Control: no-store, no-cache, must-revalidate");
// HTTP/1.1
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
// HTTP/1.0
include_once "include_functions.php";
if (!$_SESSION["uname"]) {
exit;
}
$ACTION = @$_GET["action"];
$USERNAME = $_SESSION["uname"];
switch ($ACTION) {
case 'getcomments':
$taskid = get_GET_var("taskid");
$manageWorks = new manageWorks();
$manageWorks->get_workComments($taskid, true);
exit;
break;
default:
break;
}
<?php
include_once "include_db.php";
include_once "include_functions.php";
$USERNAME = $_POST['username'];
$USERPASS = $_POST['password'];
if (!authenticateUser($USERNAME, $USERPASS)) {
echo "Invalid Username or Password!";
exit;
} else {
$_SESSION["uname"] = $USERNAME;
}
$projectName = DEFAULTPERSONALPROJECT;
$briefDesc = urldecode($_POST['newtask']);
$deadline = getTomorrowCaldate(2);
$manageWorks = new manageWorks();
$manageWorks->newWork(array(work_userAssigned => $USERNAME, work_addedBy => $USERNAME, work_deadLine => $deadline, work_briefDesc => $briefDesc, work_Notes => '', work_status => $DE_GLOBALS_WORK_NEW, work_priority => 'N', work_projectName => $projectName, work_isPrivate => 'Y', daysb4deadline => 0, afterCompletionID => 0));
$this_taskid = mysql_insert_id();
$COMMENTLOGMESSAGE = "<B>{$USERNAME}</B> Created New Task -- User Assigned:{$USERNAME}, DeadLine:{$deadline}, Project:{$projectName}";
$manageWorks->addComment($this_taskid, APPNAME, $COMMENTLOGMESSAGE);
echo "Task '{$this_taskid}' Created !";
$actualFieldName = 'work_priority';
break;
case 'briefDesc':
$actualFieldName = 'work_briefDesc';
break;
case 'Notes':
$actualFieldName = 'work_Notes';
break;
case 'isPrivate':
$actualFieldName = 'work_isPrivate';
$fieldValue = $fieldValue == 'yes' ? 'Y' : 'N';
break;
}
$somearray = array();
$somearray[$actualFieldName] = $fieldValue;
$manageWorks = new manageWorks();
$manageWorks->updateWork($workid, $somearray);
$manageWorks->addComment($workid, APPNAME, "<B>{$USERNAME}</B> updated field {$fieldName} to {$fieldValue}");
send_Action_Response('Success', "updated Task {$workid} !");
exit;
break;
case 'newRoutineTask':
$nrt = get_POST_var('nrt');
$result = execute_sqlInsert("dailychecklist", array(username => $USERNAME, task => $nrt));
send_Action_Response('Success', "Note Routine task added !");
exit;
break;
case 'resetRoutineTasksStatus':
$result = execute_sqlUpdate("dailychecklist", array(status => 'N'), array(username => $USERNAME));
send_Action_Response('Success', "Status Reset !");
exit;
