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); }