<?php  
$page_title = 'Add Feedback';
include 'header.php';
?>
<div class="content-wrapper">
	<section class="content mt-4">
		<div class="container-fluid">
			<div class="row">
				<div class="col-md-12">
					<?php include('alert-msg.php'); ?>
					<div class="card card-primary">
						<div class="card-header">
							<h3 class="card-title"><?php echo $page_title; ?></h3>
						</div>
						<form action="add-feedback.php" method="POST" enctype="multipart/form-data">
							<div class="card-body">
							    <div class="row">
									<div class="col-md-4">
										<div class="form-group">
											<label>Student</label>
											<select class="form-control select2" name="student_id" required>
												<option value="">--Select--</option>
												<?php
												$sel_stud=mysqli_query($con,"SELECT * FROM `DimStudent_Table` where Name != ''");
												while($row_stud=mysqli_fetch_array($sel_stud))
												{
												?>
												<option value="<?php echo $row_stud['Student_ID']; ?>"><?php echo $row_stud['Name']; ?> (<?php echo $row_stud['Class']; ?>/<?php echo $row_stud['Division']; ?>)</option>
												<?php
												}
												?>
											</select>
										</div>
									</div>
									
									<div class="col-md-4">
										<div class="form-group">
											<label>Feedback Type</label>
											<select class="form-control select2" name="feedback_type" required>
												<option value="">--Select--</option>
												<?php
												$sel_type=mysqli_query($con,"SELECT * FROM `DimFeedbackType_Table` where Type_Description != ''");
												while($row_type = mysqli_fetch_array($sel_type))
												{
												?>
												<option value="<?php echo $row_type['Type_ID']; ?>"><?php echo $row_type['Type_Description']; ?></option>
												<?php
												}
												?>
											</select>
										</div>
									</div>
									
									<div class="col-md-4">
										<div class="form-group">
											<label>Question</label>
											<select class="form-control select2" name="question" required>
												<option value="">--Select--</option>
												<?php
												$sel_question=mysqli_query($con,"SELECT * FROM `DimQuestionType_Table` where Question_Text != ''");
												while($row_question = mysqli_fetch_array($sel_question))
												{
												?>
												<option value="<?php echo $row_question['Question_ID']; ?>"><?php echo $row_question['Question_Text']; ?></option>
												<?php
												}
												?>
											</select>
										</div>
									</div>
									
									<div class="col-md-4">
										<div class="form-group">
											<label>Response Value</label>
											<input type="number" name="respose_value" class="form-control" />
										</div>
									</div>
        						</div>
								<button type="submit" class="btn btn-primary" name="btnSubmit">Submit</button>
							</div>
						</form>
					</div>
				</div>
			</div>
		</div>
	</section>
</div>
<?php include 'footer.php'; ?>

<?php
if (isset($_POST['btnSubmit'])) {
    $student_id     = $_POST['student_id'];
    $type_id        = $_POST['feedback_type'];
    $question_id    = $_POST['question'];
    $response_value = $_POST['respose_value'];

    // Generate Q
    $q_result = mysqli_query($con, "SELECT MAX(Q) as max_q FROM FactFeedback_Table");
    $row_q = mysqli_fetch_assoc($q_result);
    $q = ($row_q['max_q'] ?? 0) + 1;

    // Generate Counter (count of existing similar records + 1)
    $counter_query = mysqli_query($con, "
        SELECT COUNT(*) as counter 
        FROM FactFeedback_Table 
        WHERE Student_ID = '$student_id' 
        AND Question_ID = '$question_id' 
        AND Type_ID = '$type_id'
    ");
    $row_counter = mysqli_fetch_assoc($counter_query);
    $counter = ($row_counter['counter'] ?? 0) + 1;

    // Generate Feedback_ID (like FB00003)
    $last_id_query = mysqli_query($con, "SELECT Feedback_ID FROM FactFeedback_Table ORDER BY Feedback_ID DESC LIMIT 1");
    if ($last_row = mysqli_fetch_assoc($last_id_query)) {
        $last_num = (int)substr($last_row['Feedback_ID'], 2); // remove 'FB'
        $new_num = $last_num + 1;
    } else {
        $new_num = 1;
    }
    $feedback_id = 'FB' . str_pad($new_num, 5, '0', STR_PAD_LEFT); // e.g., FB00003

    // Insert
    $insert = mysqli_query($con, "
        INSERT INTO FactFeedback_Table (Feedback_ID, Counter, Student_ID, Type_ID, Question_ID, Response_Value, Q)
        VALUES ('$feedback_id', '$counter', '$student_id', '$type_id', '$question_id', '$response_value', '$q')
    ");

    if ($insert) {
        $_SESSION['success_msg'] = "Feedback submitted successfully.";
    } else {
        $_SESSION['error_msg'] = "Failed to submit feedback.";
    }

    echo"<script>window.location='add-feedback.php'</script>";
    exit;
}