<?php  
$page_title = 'Bulk 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="feedback-bulk-add.php" method="POST" enctype="multipart/form-data">
							<div class="card-body">
							    <div class="row">
							        <div class="col-md-12"><b>Search Student for add feedback</b></div>
									<div class="col-md-4">
										<div class="form-group">
											<label>Class</label>
											<select class="form-control select2" name="class">
												<option value="">--All--</option>
												<?php
												$sel_class=mysqli_query($con,"SELECT DISTINCT Class FROM `DimStudent_Table` Where Class != ''");
												while($row_class=mysqli_fetch_array($sel_class))
												{
												?>
												<option value="<?php echo $row_class['Class']; ?>"><?php echo $row_class['Class']; ?></option>
												<?php
												}
												?>
											</select>
										</div>
									</div>
        									
									<div class="col-md-4">
										<div class="form-group">
											<label>Division</label>
											<select class="form-control select2" name="division">
												<option value="">--All--</option>
												<?php
												$sel_division=mysqli_query($con,"SELECT DISTINCT Division FROM `DimStudent_Table` where Division != ''");
												while($row_division=mysqli_fetch_array($sel_division))
												{
												?>
												<option value="<?php echo $row_division['Division']; ?>"><?php echo $row_division['Division']; ?></option>
												<?php
												}
												?>
											</select>
										</div>
									</div>
									
									<div class="col-md-4">
										<div class="form-group">
											<label>Combination</label>
											<select class="form-control select2" name="combination">
												<option value="">--All--</option>
												<?php
												$sel_class=mysqli_query($con,"SELECT DISTINCT Combination FROM `DimStudent_Table` Where Combination != ''");
												while($row_class=mysqli_fetch_array($sel_class))
												{
												?>
												<option value="<?php echo $row_class['Combination']; ?>"><?php echo $row_class['Combination']; ?></option>
												<?php
												}
												?>
											</select>
										</div>
									</div>
									
									<div class="col-md-4">
										<div class="form-group">
											<label>Course</label>
											<select class="form-control select2" name="course">
												<option value="">--All--</option>
												<?php
												$sel_class=mysqli_query($con,"SELECT DISTINCT Course FROM `DimStudent_Table` Where Course != ''");
												while($row_class=mysqli_fetch_array($sel_class))
												{
												?>
												<option value="<?php echo $row_class['Course']; ?>"><?php echo $row_class['Course']; ?></option>
												<?php
												}
												?>
											</select>
										</div>
									</div>
									
									<div class="col-md-4">
										<div class="form-group">
											<label>Search</label>
											<input type="text" class="form-control" name="search" />
										</div>
									</div>
									<div class="col-md-12">
									    <hr />
									    <b>Select Feedback type and subject</b>
									</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="">--All--</option>
												<?php
												$sel_class=mysqli_query($con,"SELECT Type_ID, Type_Description FROM `DimFeedbackType_Table` where Type_Description != '' group by Type_ID");
												while($row_class=mysqli_fetch_array($sel_class))
												{
												?>
												<option value="<?php echo $row_class['Type_ID']; ?>"><?php echo $row_class['Type_Description']; ?> (<?php echo $row_class['Type_ID']; ?>)</option>
												<?php
												}
												?>
											</select>
										</div>
									</div>
									
									<div class="col-md-4">
										<div class="form-group">
											<label>Subject</label>
											<select class="form-control select2" name="subject">
												<option value="">--All--</option>
												<?php
												$sel_class=mysqli_query($con,"SELECT Subject_ID,Subject_Name FROM `DimSubject_Table` where Subject_Name != ''");
												while($row_class=mysqli_fetch_array($sel_class))
												{
												?>
												<option value="<?php echo $row_class['Subject_ID']; ?>"><?php echo $row_class['Subject_Name']; ?> (<?php echo $row_class['Subject_ID']; ?>)</option>
												<?php
												}
												?>
											</select>
										</div>
									</div>
									
									<div class="col-md-4">
										<div class="form-group">
											<label>Question</label>
											<select class="form-control select2" name="question">
												<option value="">--All--</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>Category</label>
											<select class="form-control select2" name="category">
												<option value="">--All--</option>
												<?php
												$sel_class=mysqli_query($con,"SELECT DISTINCT Category FROM `DimQuestionType_Table` where Category != ''");
												while($row_class=mysqli_fetch_array($sel_class))
												{
												?>
												<option value="<?php echo $row_class['Category']; ?>"><?php echo $row_class['Category']; ?></option>
												<?php
												}
												?>
											</select>
										</div>
									</div>
									
        						</div>
								<button type="submit" class="btn btn-primary" name="btnSubmit">Search</button>
							</div>
						</form>
					</div>
					<?php if(isset($_POST['btnSubmit']))
					{
					    $class = $_POST['class'] ?? '';
                    	$division = $_POST['division'] ?? '';
                    	$combination = $_POST['combination'] ?? '';
                    	$course = $_POST['course'] ?? '';
                    	$search = $_POST['search'] ?? '';
                    	$feedback_type = $_POST['feedback_type'] ?? '';
                    	$subject = $_POST['subject'] ?? '';
                    	$question = $_POST['question'] ?? '';
                    	$category = $_POST['category'] ?? '';
					?>
					<div class="card card-primary">
						<div class="card-header">
						    <h3 class="card-title">Add/Update Feedback</h3>
						</div>
						<div class="card-body">
						    <form action="bulk-assign-subject-submit.php" method="POST">
						        <div class="row">
    								<div class="col-md-12">
    								    <div class="table-responsive mt-4" style="width:100%; clear:both;">
                							<table width="100%" class="table table-striped table-bordered table-hover" id="data_table">
                								<thead>
                									<tr>
                									    <th>Feedback Type ID</th>
                									    <th>Question ID</th>
                										<th>Student ID</th>
                										<th>Name</th>
                										<th>Roll Number</th>
                										<th>Class/Division</th>
                										<th>Combination</th>
                										<th>Course</th>
                										<th>Feedback Type</th>
                										<th>Question</th>
                										<th>Subject</th>
                										<th>Counter</th>
                										<th>Response Value</th>
                										<th>Action</th>
                									</tr> 
                								</thead>
                								<tbody>
                									<?php 
                									$query = "SELECT * FROM `DimStudent_Table` where (`Class`='$class' OR '$class' = '') and (`Division`='$division' OR '$division' = '') and (`Combination`='$combination' OR '$combination' = '') and (`Course`='$course' OR '$course' = '') and (`Student_ID` LIKE '%$search%' OR `Name` LIKE '%$search%' OR `Roll_Number` LIKE '%$search%' OR `Combination` LIKE '%$search%' OR `Course` LIKE '%$search%' OR `Place` LIKE '%$search%' OR '$search' = '')";
                									$result = mysqli_query($con,$query);
                									$count = 1;
                									while($row = mysqli_fetch_array($result) )
                									{
                									    $stud_id = $row['Student_ID'];
                									    $sel_ques = mysqli_query($con, "SELECT ft.Type_Description, ft.Type_ID, q.Question_ID, q.Question_Text, q.Subject_ID, sub.Subject_Name FROM `DimQuestionType_Table` as q inner join DimFeedbackType_Table as ft on ft.Type_ID = q.Type_ID left join DimSubject_Table as sub on sub.Subject_ID = q.Subject_ID where (q.Question_ID = '$question' OR '$question' = '') AND (q.category = '$category' OR '$category' = '') AND (q.Type_ID = '$feedback_type' OR '$feedback_type' = '') AND (q.Subject_ID = '$subject' OR '$subject' = '')");
                									    while($row_qu = mysqli_fetch_array($sel_ques)) {
                										?>
                										<tr class="odd gradeX">
                										    <td><?php echo $row_qu['Type_ID']; ?></td>
                										    <td><?php echo $row_qu['Question_ID']; ?></td>
                											<td><?php echo $stud_id; ?></td>
                											<td><?php echo $row['Name']; ?></td>
                											<td><?php echo $row['Roll_Number']; ?></td>
                											<td><?php echo $row['Class']; ?>/<?php echo $row['Division']; ?></td>
                											<td><?php echo $row['Combination']; ?></td>
                											<td><?php echo $row['Course']; ?></td>
                											<td><?php echo $row_qu['Type_Description']; ?></td>
                											<td><?php echo $row_qu['Question_Text']; ?></td>
                											<td><?php echo $row_qu['Subject_Name']; ?></td>
                											<?php
                											    $cTypeId = $row_qu['Type_ID'];
                											    $cQuestionId = $row_qu['Question_ID'];
                											    $sel_res = mysqli_query($con, "SELECT Response_Value, Counter FROM `FactFeedback_Table` where Student_ID = '$stud_id' AND Type_ID = '$cTypeId' AND Question_ID = '$cQuestionId'");
                											    $row_result = mysqli_fetch_array($sel_res);
                											    $Response_Value = '';
                											    $Counter = 1;
            										            if(!empty($row_result)) {
            										                $Response_Value = $row_result['Response_Value'];
            										                $Counter = $row_result['Counter'];
            										            }
                											?>
                											<td><div contentEditable='true' class='edit' id='<?php echo "Counter~~".$stud_id."~~".$cTypeId."~~".$cQuestionId;  ?>'><?php echo $Counter; ?></div></td>
                											<td><div contentEditable='true' class='edit' id='<?php echo "Response_Value~~".$stud_id."~~".$cTypeId."~~".$cQuestionId;  ?>'><?php echo $Response_Value; ?></div></td>
                											<td>
                												<button type="button" class="btn btn-sm btn-danger btnDelete" data-id='<?php echo $stud_id."~~".$cTypeId."~~".$cQuestionId;  ?>'><i class="fas fa-trash"></i></button>
                											</td>
                										</tr>
                										<?php
                										$count ++;
                									    }
                									}
                									?>  
                								</tbody>
                							</table>
                						</div>
    								</div>
    						    </div>
    						</form>
						</div>
					</div>
					<?php
					}
					?>
				</div>
			</div>
		</div>
	</section>
</div>
<?php include 'footer.php'; ?>
<script>
	$(function () {
		$("#data_table").DataTable({
			"lengthChange": false, 
			"autoWidth": false,
			 "paging": false,
			 "columnDefs": [
                { "targets": [0], "visible": false, "searchable": false },
                { "targets": [1], "visible": false, "searchable": false }
            ],
			"buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"],
			//"pageLength": 10,
		}).buttons().container().appendTo('.dataTables_wrapper .col-md-6:eq(0)');
	});
</script>
<script type="text/javascript">
	$(document).ready(function(){
		$('.edit').click(function(){
			$(this).addClass('editMode');
		});
		$(".edit").focusout(function(){
			$(this).removeClass("editMode");
			var id = this.id;
			var value = $(this).text().trim();
			if(value == '') {
			    return;
			}
			if (!/^\d+(\.\d+)?$/.test(value)) { // Allows integers or decimals
                alert("Please enter a valid numeric value.");
                $(this).text("");
                return;
            }
			$.ajax({
				url: 'update-feedback.php',
				type: 'post',
				data: { Data1:id, value:value},
				success:function(response){
					console.log('Save successfully'); 
				}
			});
		});
	});
</script>
<script>
		    $(".btnDelete").click(function(){
				let tr = $(this).parents("tr");
				if(confirm('Are you sure you want to delete?'))
				{
					let id = $(this).data("id");
					$.ajax({
						type : "POST",
						url : "delete-feedback.php",
						data : {id:id},
						beforeSend : function() {

						},
						success : function(response) {
							let res = JSON.parse(response);
							if(res['code']=='100')
							{
								tr.remove();
							}
							else
							{
							    alert(res['msg']);
							}
						}
					});
				}
				return false;
			});
		</script>