<?php  
$page_title = 'Import Feedback';
include 'header.php';
$agent_id = $userData['id'];
$role = $userData['user_type'];
?>
<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="" method="POST" enctype="multipart/form-data">
							<div class="card-body">
								<div class="row">
									<div class="col-md-4">
										<div class="form-group">
											<label for="exampleInputFile">Upload Excel File</label>
											<a href="downloads/feedback_import.csv?q=1" download="feedback_import.csv">CSV Format File Format</a>
											<div class="input-group">
												<div class="custom-file">
													<input type="file" class="custom-file-input" name="upload_format" accept=".csv" id="exampleInputFile" required>
													<label class="custom-file-label" for="exampleInputFile">Choose file</label>
												</div>
											</div>
										</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']))
{
	$filename=$_FILES["upload_format"]["tmp_name"];
	if($_FILES["upload_format"]["size"] > 0)
	{
		$file = fopen($filename, "r");
		$update = 0;
		$insert = 0;
		$row_count = 0;
		while (($emapData = fgetcsv($file, 10000, ",")) !== FALSE)
		{
			if($row_count>0)
			{
				$Counter = $emapData[11];
				$Student_ID = $emapData[2];
				$Type_ID = $emapData[0];
				$Question_ID = $emapData[1];
				$Response_Value = $emapData[12];
				
				$sel_result = mysqli_query($con, "select * from FactFeedback_Table where Student_ID = '$Student_ID' and Type_ID = '$Type_ID' and Question_ID = '$Question_ID'");
                if(mysqli_num_rows($sel_result) > 0) {
                    $upd = mysqli_query($con, "update FactFeedback_Table set Response_Value = '$Response_Value', Counter = '$Counter' where Student_ID = '$Student_ID' and Type_ID = '$Type_ID' and Question_ID = '$Question_ID'");
                    if($upd) {
                        $update = $update + 1;
                    }
                }
                else {
                    // 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 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);
                    
                    $ins = mysqli_query($con, "INSERT INTO FactFeedback_Table (Feedback_ID, Student_ID, Type_ID, Question_ID, Q, Response_Value, Counter) VALUES ('$feedback_id', '$Student_ID', '$Type_ID', '$Question_ID', '$q', '$Response_Value', '$Counter')");
                    if($ins) {
                        $insert = $insert + 1;
                    }
                }
			}
			$row_count = $row_count + 1;
		}

		$message = "Import Summary:\n";
        $message .= "✔️ Records Added: $insert\n";
        $message .= "♻️ Records Updated: $update\n";
        
        echo nl2br($message);
		$_SESSION['success_msg'] = $message;
		echo"<script>window.location='import-feedback.php';</script>";
	}
	else
	{
		$_SESSION['error_msg'] = 'Have not data in uploaded file...';
		echo"<script>window.location='import-exams.php';</script>";
	}

}
?>