} print "</td>"; print "<td>"; if ($row["viewableStudents"] == "Y") { print _("Students"); } if ($row["viewableStudents"] == "Y" and $row["viewableParents"] == "Y") { print ", "; } if ($row["viewableParents"] == "Y") { print _("Parents"); } print "</td>"; print "<td>"; if ($row["role"] == "Teacher") { print countLikesByContext($connection2, "Planner", "gibbonPlannerEntryID", $row["gibbonPlannerEntryID"]); } else { $likesGiven = countLikesByContextAndGiver($connection2, "Planner", "gibbonPlannerEntryID", $row["gibbonPlannerEntryID"], $_SESSION[$guid]["gibbonPersonID"]); if ($likesGiven != 1) { print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/modules/Planner/plannerProcess.php?gibbonPlannerEntryID=" . $row["gibbonPlannerEntryID"] . "&address=" . $_GET["q"] . "&viewBy={$viewBy}&gibbonCourseClassID={$gibbonCourseClassID}&date={$date}'><img src='" . $_SESSION[$guid]["absoluteURL"] . "/themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/like_off.png'></a>"; } else { print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/modules/Planner/plannerProcess.php?gibbonPlannerEntryID=" . $row["gibbonPlannerEntryID"] . "&address=" . $_GET["q"] . "&viewBy={$viewBy}&gibbonCourseClassID={$gibbonCourseClassID}&date={$date}'><img src='" . $_SESSION[$guid]["absoluteURL"] . "/themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/like_on.png'></a>"; } } print "</td>"; print "<td>"; print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/planner_view_full.php&gibbonPlannerEntryID=" . $row["gibbonPlannerEntryID"] . "&viewBy=class&gibbonCourseClassID={$gibbonCourseClassID}&width=1000&height=550'><img title='" . _('View') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/plus.png'/></a> "; if ($highestAction == "Lesson Planner_viewAllEditMyClasses" and $teacher == TRUE or $highestAction == "Lesson Planner_viewEditAllClasses") { print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/planner_edit.php&gibbonPlannerEntryID=" . $row["gibbonPlannerEntryID"] . "&viewBy={$viewBy}&gibbonCourseClassID={$gibbonCourseClassID}'><img title='" . _('Edit') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/config.png'/></a> "; print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/planner_bump.php&gibbonPlannerEntryID=" . $row["gibbonPlannerEntryID"] . "&viewBy={$viewBy}&gibbonCourseClassID={$gibbonCourseClassID}'><img title='" . _('Bump') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/page_right.png'/></a>"; print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/planner_delete.php&gibbonPlannerEntryID=" . $row["gibbonPlannerEntryID"] . "&viewBy={$viewBy}&gibbonCourseClassID={$gibbonCourseClassID}'><img title='" . _('Delete') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/garbage.png'/></a>";
print "<span title='" . $rowWork["version"] . ". Submitted at " . substr($rowWork["timestamp"], 11, 5) . " on " . dateConvertBack($guid, substr($rowWork["timestamp"], 0, 10)) . "'><a target='_blank' href='" . $rowWork["location"] . "'>{$linkText}</a></span>"; } else { print "<span title='Recorded at " . substr($rowWork["timestamp"], 11, 5) . " on " . dateConvertBack($guid, substr($rowWork["timestamp"], 0, 10)) . "'>{$linkText}</span>"; } } } print "</td>"; print "<td>"; if ($rowWork["gibbonPlannerEntryHomeworkID"] != "" and $rowList["gibbonPersonID"] != $_SESSION[$guid]["gibbonPersonID"] and $rowWork["status"] != "Exemption") { $likesGiven = countLikesByContextAndGiver($connection2, "Crowd Assessment", "gibbonPlannerEntryHomeworkID", $rowWork["gibbonPlannerEntryHomeworkID"], $_SESSION[$guid]["gibbonPersonID"]); if ($likesGiven != 1) { print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/modules/Crowd Assessment/crowdAssess_viewProcess.php?gibbonPlannerEntryID={$gibbonPlannerEntryID}&gibbonPlannerEntryHomeworkID=" . $rowWork["gibbonPlannerEntryHomeworkID"] . "&address=" . $_GET["q"] . "&gibbonPersonID=" . $rowList["gibbonPersonID"] . "'><img src='" . $_SESSION[$guid]["absoluteURL"] . "/themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/like_off.png'></a>"; } else { print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/modules/Crowd Assessment/crowdAssess_viewProcess.php?gibbonPlannerEntryID={$gibbonPlannerEntryID}&gibbonPlannerEntryHomeworkID=" . $rowWork["gibbonPlannerEntryHomeworkID"] . "&address=" . $_GET["q"] . "&gibbonPersonID=" . $rowList["gibbonPersonID"] . "'><img src='" . $_SESSION[$guid]["absoluteURL"] . "/themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/like_on.png'></a>"; } $likesTotal = countLikesByContext($connection2, "Crowd Assessment", "gibbonPlannerEntryHomeworkID", $rowWork["gibbonPlannerEntryHomeworkID"]); print " x " . $likesTotal; } print "</td>"; print "<td>"; $dataDiscuss = array("gibbonPlannerEntryHomeworkID" => $rowWork["gibbonPlannerEntryHomeworkID"]); $sqlDiscuss = "SELECT gibbonCrowdAssessDiscuss.*, title, surname, preferredName, category FROM gibbonCrowdAssessDiscuss JOIN gibbonPerson ON (gibbonCrowdAssessDiscuss.gibbonPersonID=gibbonPerson.gibbonPersonID) JOIN gibbonRole ON (gibbonPerson.gibbonRoleIDPrimary=gibbonRole.gibbonRoleID) WHERE gibbonPlannerEntryHomeworkID=:gibbonPlannerEntryHomeworkID"; $resultDiscuss = $connection2->prepare($sqlDiscuss); $resultDiscuss->execute($dataDiscuss); print $resultDiscuss->rowCount(); print "</td>"; print "<td>"; if ($rowWork["gibbonPlannerEntryHomeworkID"] != "" and $rowWork["status"] != "Exemption") { print "<a href='" . $_SESSION[$guid]["absoluteURL"] . "/index.php?q=/modules/" . $_SESSION[$guid]["module"] . "/crowdAssess_view_discuss.php&gibbonPlannerEntryID={$gibbonPlannerEntryID}&gibbonPlannerEntryHomeworkID=" . $rowWork["gibbonPlannerEntryHomeworkID"] . "&gibbonPersonID=" . $rowList["gibbonPersonID"] . "'><img title='" . _('View') . "' src='./themes/" . $_SESSION[$guid]["gibbonThemeName"] . "/img/plus.png'/></a> "; } print "</td>";