';
$output.='
'.$this->getFriendlyStatus(false, true).'
';
$output.='
';
$output.='
'.$this->entryName.'
';
$output.='
';
$output.=' '.$this->entryDate.'';
$output.='
';
$output.='
';
$output.='
';
$output.='
';
$files = $this->getThumbnails();
$i=0;
foreach($files as $file) {
$i++;
$output.='
';
}
$output.='
';
$output.=' ';
$output.=' ';
$output.='
';
$output.='
';
$output.='
';
$output.='
';
$output.='
'.$this->entryDescription.'
';
$output.='
';
if($isAdmin) {
$output.='
';
} else {
global $user;
if ($user->role=="Judge") {
global $CURRENT_ROUND;
global $rankeval;
if($CURRENT_ROUND==2) {
if($this->finalist>0 && $rankeval<6) {
$judgement = SJDAJudgement::getCurrentJudgement($this->entryId,$CURRENT_ROUND,$user->userId);
if($judgement) {
$output.='
';
$output.='
';
$rankeval=(7-$judgement->score);
} else {
$output.='
';
}
}
}
}
}
$output.='
';
$output.='
';
$output.='
'.$this->entryName.'
';
$output.='
';
$output.=' '.$this->entryDate.'';
$output.='
';
$output.='
';
$output.='
';
$output.='
';
$output.='
';
return $output;
}
}
?>feedbackId = $row['FeedbackID'];
$fb->entryId = $row['EntryID'];
$fb->fromId = $row['FromID'];
$fb->messageDate = $row['MessageDate'];
$fb->messageText = $row['MessageText'];
$fb->messageRead = $row['MessageRead'];
$feedback[]=$fb;
}
}
return $feedback;
}
public function save()
{
if ($this->feedbackId) {
logtoconsole("Updating EntryFeedback ".$this->feedbackId);
$sql = 'UPDATE EntryFeedback SET '.
' EntryID="'. JDMIS_DB_Escape($this->entryId) .'", '.
' FromID="'. JDMIS_DB_Escape($this->entryDescription) .'", '.
' MessageDate="'. JDMIS_DB_Escape($this->messageDate) .'", '.
' MessageText="'. JDMIS_DB_Escape($this->messageText) .'", '.
' MessageRead="'. JDMIS_DB_Escape($this->messageRead) .'" '.
' WHERE FeedbackID='.$this->feedbackId;
$result = JDMIS_DB_ExecuteQuery($sql, true);
logtoconsole($sql,$result);
if($result) return $this->feedbackId;
} else {
logtoconsole("Creating EntryFeedback ");
$sql = "INSERT INTO EntryFeedback (EntryID, FromID, MessageDate, MessageText) ".
'VALUES ( '.JDMIS_DB_Escape($this->entryId).', '.
JDMIS_DB_Escape($this->fromId).', '.
'NOW(), '.
'"'.JDMIS_DB_Escape($this->messageText).'" )';
$result = JDMIS_DB_ExecuteQuery($sql, true);
$this->feedbackId = $result;
logtoconsole($sql,$result);
return $this->feedbackId;
}
}
public function delete()
{
$sql = "DELETE FROM EntryFeedback WHERE FeedbackID=".$this->feedbackId;
$result = JDMIS_DB_ExecuteQuery($sql, true);
unset($this->feedbackId);
unset($this->messageText);
unset($this->fromId);
return $result;
}
public function getFromUser() {
return SJDAUser::getUserByID($this->fromId);
}
public function getEntry() {
return SJDAEntry::getEntryByID($this->entryId);
}
}
judgementId = $row['JudgementID'];
$entry->userId = $row['UserID'];
$entry->entryId = $row['EntryID'];
$entry->round = $row['Round'];
$entry->score = $row['Score'];
$entry->judgementDate = $row['JudgementDate'];
$entry->judgeName = $row['JudgeName'];
$entries[]=$entry;
}
}
return $entries;
}
public function save()
{
if ($this->judgementId) {
logtoconsole("Updating Judgement ".$this->judgementId);
$sql = ' UPDATE Judgement SET '.
' UserID= "'. JDMIS_DB_Escape($this->userId) .'", '.
' EntryID= "'. JDMIS_DB_Escape($this->entryId) .'", '.
' Round= "'. JDMIS_DB_Escape($this->round) .'", '.
' Score= "'. JDMIS_DB_Escape($this->score) .'", '.
' JudgementDate="'. JDMIS_DB_Escape($this->judgementDate) .'" '.
' WHERE JudgementID='.$this->judgementId;
$result = JDMIS_DB_ExecuteQuery($sql, true);
logtoconsole($sql,$result);
if($result) return $this->entryId;
} else {
logtoconsole("Creating Entry ");
$sql = "INSERT INTO Judgement (UserID, EntryID, Round, Score, JudgementDate) ".
'VALUES ( "'. JDMIS_DB_Escape($this->userId) .'", '.
' "'. JDMIS_DB_Escape($this->entryId) .'", '.
' "'. JDMIS_DB_Escape($this->round) .'", '.
' "'. JDMIS_DB_Escape($this->score) .'", '.
' NOW() '.
' )';
$result = JDMIS_DB_ExecuteQuery($sql, true);
$this->judgementId = $result;
logtoconsole($sql,$result);
return $this->judgementId;
}
}
public function getUser() {
$user=SJDAUser::getUserByID($this->userId);
}
public function getEntry() {
$entry=SJDAEntry::getEntryByID($this->entryId);
}
public static function getTotalScore($entryId) {
$sql = "SELECT SUM(Score) AS TotalScore FROM Judgement WHERE EntryID=$entryId";
$result = JDMIS_DB_ExecuteQuery($sql, false);
if($result){
return $result[0]['TotalScore'];
} else {
return -2;
}
}
public static function getRoundScore($entryId, $round) {
$sql = "SELECT SUM(Score) AS RoundScore FROM Judgement WHERE EntryID=$entryId AND Round=$round";
$result = JDMIS_DB_ExecuteQuery($sql, false);
if($result){
return $result[0]['RoundScore'];
} else {
return -2;
}
}
public static function getJudgement($entryId, $round, $userId) {
$result = SJDAJudgement::search($entryId, $round, $userId);
if($result){
return $result[0];
} else {
//return a new justdement
$judgement = new SJDAJudgement();
$judgement->entryId = $entryId;
$judgement->round = $round;
$judgement->userId = $userId;
$judgement->score = 0;
return $judgement;
}
}
public static function getJudgeScore($entryId, $round, $userId) {
$judgement=SJDAJudgement::getJudgement($entryId, $round, $userId);
return $judgement->score;
}
public function delete() {
if ($this->judgementId) {
logtoconsole("Deleting Judgement ".$this->judgementId);
$sql = ' DELETE FROM Judgement WHERE JudgementID='.$this->judgementId;
$result = JDMIS_DB_ExecuteQuery($sql, true);
logtoconsole($sql,$result);
return $result;
}
}
}