public function listWorks_iPhone($taskstatus, $ulID, $backTitle)
{
$this->orderbyfield = 'work_projectName';
if (!$this->formedsql) {
$this->formSqlSelector();
}
$sqltoExecute = "select * from WORKS where work_status = '" . $taskstatus . "' " . $this->sqlselector;
$query = mysql_query($sqltoExecute) or die("Invalid query: " . mysql_error());
if (mysql_num_rows($query) == 0) {
echo "<ul id=\"" . $ulID . "\" title=\"" . $backTitle . "\"><li>No tasks found !</li></ul>";
return;
}
$tmp_manageWorks = new manageWorks();
$mainUL = array();
$eachTaskDivs = array();
$previousProject = '';
while ($row = @mysql_fetch_array($query)) {
extract($row);
// `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 ($previousProject != $work_projectName) {
$mainUL[] = "<li class='group'>{$work_projectName}</li>\n";
}
$previousProject = $work_projectName;
$mainUL[] = "<li><a href=\"#" . $workID . "\">" . $work_briefDesc . "</a></li>\n";
$eachTaskDivs[] = "<div id=\"" . $workID . "\" class=\"panel\" title=\"Task " . $workID . "\">\n";
$eachTaskDivs[] = "<h2>{$work_briefDesc}</h2>\n";
$eachTaskDivs[] = "<h2>Deadline : " . caldate_to_human($work_deadLine) . "</h2>\n";
$eachTaskDivs[] = "<h2>Added By : " . $work_addedBy . "</h2>\n";
$eachTaskDivs[] = "<h2>Added On : " . caldate_to_human($work_dateAdded) . "</h2>\n";
$eachTaskDivs[] = "<h2>Priority : \n";
switch ($work_priority) {
case 'N':
$eachTaskDivs[] = "Normal\n";
break;
case 'H':
$eachTaskDivs[] = "High\n";
break;
case 'L':
$eachTaskDivs[] = "Low\n";
break;
}
$eachTaskDivs[] = "</h2>\n";
if ($work_isPrivate == 'Y') {
$eachTaskDivs[] = "<h2>Visibility : Private</h2>\n";
} else {
$eachTaskDivs[] = "<h2>Visibility : Public</h2>\n";
}
// ... Other details of this task and comments if needed
if ($work_Notes) {
$eachTaskDivs[] = "<h2>Notes : {$work_Notes}</h2>\n";
}
if ($tmp_manageWorks->taskHasComments($workID)) {
$eachTaskDivs[] = "<div id='taskcomments_{$workID}' class='divViewComments'>\n\t\t\t\t\t\t\t\t\t\t\t<span class='ViewCommentsButton' workid='{$workID}'>View Comments</span>\n\t\t\t\t\t\t\t\t\t\t</div>\n";
}
$eachTaskDivs[] = "</div>\n";
}
echo "<ul id=\"" . $ulID . "\" title=\"" . $backTitle . "\">";
echo implode("", $mainUL);
echo "</ul>";
echo implode("", $eachTaskDivs);
}
