100){ $myActualRate = 100; }else{ $myActualRate = $myRating; } $sql="INSERT INTO `hrd_updates_ratings` (`id`,`rec_id`,`emp_id`,`emp_rating`,`comment`,`date`,`time`) VALUES('','$recID','$myEMPID','$myActualRate','$myComment','$toDate','$currentTime')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "

Record has been saved.

"; } } if(isset($_POST['SubmitComment'])){ $recID=$_POST['recID']; $myComment=$_POST['smyComment']; $myComment = mysql_real_escape_string($myComment); $sql="INSERT INTO `hrd_updates_comments` (`id`,`rec_id`,`emp_id`,`comment`,`date`,`time`) VALUES('','$recID','$myEMPID','$myComment','$toDate','$currentTime')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "

Record has been saved.

"; } } if(isset($_GET['rate'])){ echo "
"; echo ""; echo "
"; echo "

RATE THIS UPDATE

"; echo "

TYPE YOUR COMMENTS HERE...

"; echo "
"; echo "

SUBMIT YOUR RATINGS [0 - 100] where 100 is the highest rating:

"; echo "


"; echo ""; echo " "; echo "
"; echo"
"; echo "
"; } if(isset($_GET['react'])){ echo "
"; echo ""; echo "
"; echo "

COMMENT BOX

"; echo "

TYPE YOUR COMMENTS HERE...

"; echo "
"; echo "
"; echo ""; echo " "; echo "
"; echo"
"; echo "
"; } //VIEW COMMENTS if(isset($_GET['view'])){ $recID = $_GET['view']; echo "
"; echo "

COMMENT BOX

"; echo "
"; echo " X "; echo "
"; echo "

USER'S FEEDBACK

"; echo "
"; $getCom = mysql_query("SELECT * FROM `hrd_updates_comments` WHERE `rec_id`='$recID' ORDER BY `id` DESC "); while($cRow = mysql_fetch_array($getCom)){ $empID = $cRow['emp_id']; $fName = mysql_result(mysql_query("SELECT `u_fname` FROM `c_users` WHERE `emp_id`='$empID'"),0); echo "
"; echo "

". $cRow['comment']."

"; echo "

Comment by: ". $fName." | Date: " .$cRow['date']. " ".$cRow['time']."

"; echo "
"; } echo "
"; echo"
"; echo ""; } if(isset($_GET['up'])){ $id=$_GET['up']; $checkIfLikeExist = mysql_result(mysql_query("SELECT COUNT('id') FROM `hrd_updates_likers` WHERE `rec_id`='$id' AND `emp_id`='$myEMPID'"),0); if($checkIfLikeExist > 0){ }else{ $sql="INSERT INTO `hrd_updates_likers` (`id`,`rec_id`,`emp_id`,`like`,`dislike`,`date`,`time`) VALUES('','$id','$myEMPID','1','0','$toDate','$currentTime')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); } } } if(isset($_GET['td'])){ $id=$_GET['td']; $checkIfLikeExist = mysql_result(mysql_query("SELECT COUNT('id') FROM `hrd_updates_likers` WHERE `rec_id`='$id' AND `emp_id`='$myEMPID'"),0); if($checkIfLikeExist > 0){ }else{ $sql="INSERT INTO `hrd_updates_likers` (`id`,`rec_id`,`emp_id`,`like`,`dislike`,`date`,`time`) VALUES('','$id','$myEMPID','0','1','$toDate','$currentTime')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); } } } $empID = $user_data['emp_id']; $trCountOpen = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pod_training_list` WHERE `status` ='1' AND `grouping`='OPEN' "),0); $trCountInvites = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pod_training_invites` WHERE `status` ='1' AND `employee_id`='$empID' "),0); $totalEnrolledTraining = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `pod_training_enrollees` WHERE `status` ='1' AND `employee_id`='$empID' "),0); $totalTrainingCount = $trCountOpen + $trCountInvites; //$averageAnswer = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `employee_id`='$empID'"),0); //$averageMaxAnswer = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `employee_id`='$empID'"),0); echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "
THE HUMAN RESOURCE DEPARTMENT - NEWS & UPDATES
"; echo "
"; echo ""; $getUpdate = mysql_query("SELECT * FROM `hrd_updates` WHERE `status`='1' ORDER BY `id` DESC"); while($urow=mysql_fetch_array($getUpdate)){ $recID = $urow['id']; echo ""; echo ""; echo ""; echo ""; } echo "
"; echo "".$urow['title']."
"; if($urow['image_path']!=''){ echo "   View Attachment
"; } echo "".substr($urow['description'],0,250)." more...
"; echo " Date: ".$urow['date']." | ".$urow['time']."
"; echo " Uploaded by: ".$urow['created_by']."
"; $comments = mysql_result(mysql_query("SELECT COUNT('id') FROM `hrd_updates_comments` WHERE `rec_id`='$recID'"),0); $getLike = mysql_result(mysql_query("SELECT COUNT('id') FROM `hrd_updates_likers` WHERE `rec_id`='$recID' AND `like`='1'"),0); $getDisLike = mysql_result(mysql_query("SELECT COUNT('id') FROM `hrd_updates_likers` WHERE `rec_id`='$recID' AND `dislike`='1'"),0); $checkIfLikeExist = mysql_result(mysql_query("SELECT COUNT('id') FROM `hrd_updates_likers` WHERE `rec_id`='$recID' AND `emp_id`='$myEMPID'"),0); $chkIfRated = mysql_result(mysql_query("SELECT COUNT('id') FROM `hrd_updates_ratings` WHERE `emp_id`='$myEMPID' AND `rec_id`='$recID'"),0); if($chkIfRated > 0){ echo "Rate Us! "; }else{ echo "Rate Us! "; } echo " | "; if($checkIfLikeExist > 0){ echo $getLike. ""; echo $getDisLike. ""; }else { echo $getLike. ""; echo $getDisLike. ""; } echo "| [ ". $comments. " ] View Comments| Add Comment"; echo "		"; //echo "Ratings
"; $myActualRatingRate = mysql_result(mysql_query("SELECT AVG(`emp_rating`) FROM `hrd_updates_ratings` WHERE `rec_id`='$recID'"),0); echo "

Rating

". number_format($myActualRatingRate,1,'.','')." %"; echo "
"; echo "
"; echo "
"; echo "
"; //===================================//===================================//===================================//===================================//=================================== echo "
"; echo ""; echo ""; if(isset($_GET['more'])){ $id=$_GET['react']; $desc = mysql_result(mysql_query("SELECT `description` FROM `hrd_updates` WHERE `id`='$id'"),0); ?>