<?php
if($_GET['act']=='student.note.list.save') {
         $dTables = new DataTables($academicConfig);
         if($_SESSION['groupid']==9 || $_SESSION['groupid']==5){
         //check is it there?
         $checkQuery=$dTables->ExecuteQuery("select * from studentactivity where studentid='".StrToDB($_GET['studentId'])."' and schoolYear='".StrToDB($_GET['schoolYear'])."' and semester='".StrToDB($_GET['semester'])."' ");
         $checkData=$dTables->FetchArray($checkQuery);


            if($checkData['STUDENTID']){
             $query="update studentactivity set COMMENTOFLECTURER='".@str_replace('\'','\'\'',$_POST['note'])."', COMMENTOFPARENTS='".StrToDB($_POST['note_parent'])."' where studentid='".StrToDB($_GET['studentId'])."' and schoolYear='".StrToDB($_GET['schoolYear'])."' and semester='".StrToDB($_GET['semester'])."' ";

            $dTables->ExecuteQuery($query);
             }else{
                $newData=array(
                  "STUDENTID"=>"'".StrToDB($_GET['studentId'])."'",
                  "SCHOOLYEAR"=>"'".StrToDB($_GET['schoolYear'])."'",
                  "SEMESTER"=>"'".StrToDB($_GET['semester'])."'",
                  "COMMENTOFLECTURER"=>"'".@str_replace('\'','\'\'',$_POST['note'])."'",
                  "COMMENTOFPARENTS"=>"'".StrToDB($_POST['note_parent'])."'",
                  "APPROVALBYPRODI"=>"'TIDAK'",
                );
                $dTables->Insert("STUDENTACTIVITY",$newData);

             }
         }


    }else if($_GET['act']=='student.note.list.approve') {
         $dTables = new DataTables($academicConfig);



         if($_SESSION['groupid']==9){
             $query="update studentactivity set APPROVALBYPRODI='YA', PRODIAPPROVEMENTDATE=SYSDATE where studentid='".intval($_GET['studentId'])."' and schoolYear='".StrToDB($_GET['schoolYear'])."' and semester='".intval($_GET['semester'])."' ";

            $dTables->ExecuteQuery($query);
         }



    }else if($_GET['act']=='student.note.list.un.approve') {
         $dTables = new DataTables($academicConfig);
         if($_SESSION['groupid']==9){
             $query="update studentactivity set APPROVALBYPRODI='TIDAK', PRODIAPPROVEMENTDATE=NULL where studentid='".intval($_GET['studentId'])."' and schoolYear='".StrToDB($_GET['schoolYear'])."' and semester='".intval($_GET['semester'])."' ";

            $dTables->ExecuteQuery($query);
         }



    }
?>