Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if($_POST['approval']&&$_POST['actionList']!=NULL&&$_POST['selectedRecord']!=NULL){
- foreach ( $_POST['selectedRecord'] as $key => $val ){
- $arrStudentActivity = array(
- 'APPROVALBYPRODI' => "'".$_POST['actionList']."'",
- 'PRODIAPPROVEMENTDATE' => "SYSDATE",
- 'STUDENTID' => "'".$val."'",
- 'SCHOOLYEAR' => "'".$currentSchoolYear."'",
- 'SEMESTER' => "'".$currentSemester."'"
- );
- $arrUpdateStudentActivity = array(
- 'APPROVALBYPRODI' => "'".$_POST['actionList']."'",
- 'PRODIAPPROVEMENTDATE' => "SYSDATE"
- );
- $studentActivityData=$score->GetStudentActivity($val,$currentSchoolYear,$currentSemester);
- if($studentActivityData){
- $score->UpdateStudentActivity($val,$currentSchoolYear,$currentSemester,$arrUpdateStudentActivity);
- $rowsAff += $score->GetAffectedRows();
- } else {
- $score->InsertStudentActivity($arrStudentActivity);
- $rowsAff += $score->GetAffectedRows();
- }
- }
- if($rowsAff>0){
- $msg="Approval has been submit.";
- $msgType = "success";
- }
- else{
- $msg="Approval failed to be submit.";
- $msgType = "failed";
- }
- $msg = GetMessage($msg, $msgType);
- } else if($_POST['approval']&&$_POST['selectedRecord']==NULL) {
- $msg="No selected record.";
- $msgType = "failed";
- $msg = GetMessage($msg, $msgType);
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment