<?php require '../controller/session.php'; ?>
<?php include 'controller/admissionCode.php'; ?>
<?php require_once("inc/init.php"); ?>
<?php include 'csvAssess.php' ?>
<div class="row">
	<div class="col-xs-12 col-sm-7 col-md-7 col-lg-4">
		<h1 class="page-title txt-color-blueDark">
			<i class="fa fa-table fa-fw "></i> 
				Report
			<span>> 
				All class_students
			</span>
		</h1>


		
	</div>

</div>

<div class="row">
			<div class="col-md-4"></div>
			<div class="col-md-4">
				
			<form enctype="multipart/form-data" id="import-csv" onsubmit="return false;" method="POST" action="index.php#ajax/set_assessment.php">
				<div class="form-group">
					<input type="hidden" name="csv" value="ok">

					<input type="file" class="form-control" name="file" id="file">
<input type="submit" class="form-control btn btn-primary" id="import" value="Import Students Assessment">
				</div>
			</form>
			</div>
			<div class="col-md-4"></div>
			
		</div>

<!-- widget grid -->
<section id="widget-grid" class="">

	<!-- row -->
	<div class="row">
		<!-- <article class="col-xs-12 col-sm-12 col-md-12 col-lg-2"></article> -->
		<!-- NEW WIDGET START -->
		<article class="col-xs-12 col-sm-12 col-md-12 col-lg-12">

			<!-- Widget ID (each widget will need unique ID)-->
			<div class="jarviswidget jarviswidget-color-blueDark"  id="wid-id-3"  data-widget-editbutton="false" data-widget-deletebutton="false">
				<!-- widget options:
				usage: <div class="jarviswidget" id="wid-id-0" data-widget-editbutton="false">

				data-widget-colorbutton="false"
				data-widget-editbutton="false"
				data-widget-togglebutton="false"
				data-widget-deletebutton="false"
				data-widget-fullscreenbutton="false"
				data-widget-custombutton="false"
				data-widget-collapsed="true"
				data-widget-sortable="false"

				-->
				<header>
					<span class="widget-icon"> <i class="fa fa-table"></i> </span>
					<h2>Export to PDF / Excel</h2>

				</header>

				<!-- widget div-->
				<div>

					<!-- widget edit box -->
					<div class="jarviswidget-editbox">
						<!-- This area used as dropdown edit box -->

					</div>
					<!-- end widget edit box -->

					<!-- widget content -->
					<div class="widget-body no-padding">
						
						<table id="datatable_tabletools" class="table table-striped table-bordered table-hover" width="100%">
							<thead>

								<tr>
									<th>S/N</th>
									<th>Picture</th>
									<th data-hide="phone,tablet">Index No</th>
									<th data-class="expand"> Name</th>
									<th data-hide="phone,tablet"> Class</th>
									<th data-hide="phone,tablet"> Track</th>
									<th data-hide="phone,tablet"> Class Score</th>
									<th data-hide="phone,tablet"> Exam Score</th>
									<th data-hide="phone,tablet"> Action</th>
								</tr>
							</thead>
							
							<tbody>
									<?php 
								if ($class_students) {
									$i = 0;
									foreach ($class_students as $key) {
										$i++;
										$track = $admission->get_student_track($key['track']);
										$isset = $admission->if_isset($key['student_id'],$std_class_id,$subject_id,$track_id,$semester_id,$a_year_id);
										$class_score = $isset[0]['class_score'];
										$exam_score = $isset[0]['exam_score'];
										$total_score = $isset[0]['total_score'];
									?>
									<tr class="">
									<td><?php echo $key['student_id']; ?></td>
									<td style="width:15%;">
										<?php 
										if($key['student_picture']){
                                                                                  $ext_1 = explode('.', basename($key['student_picture']));
                                                                                  $file_extension_1 = end($ext_1);
										?>
										<div><?php 
										if($ext_1[count($ext_1) - 1]=="JPG"){
										 ?>
										<img style="width:30%;" src="student_pics/<?php echo $key['student_picture']; ?>">
										<?php }else{?>
										<img style="width:30%;" src="student_pics/<?php echo $key['student_picture']; ?>.JPG">
										<?php } ?>
									</div>
										<?php
										}else{
											?>
											<div>
										<img style="width:30%;" src="img/avatars/male.png">
									</div>
											<?php
										}
										
										?>
										
									</td>

									<td><?php echo $key['student_id']; ?></td>
									<td><?php echo $key['student_name']; ?></td>
									<td><?php echo $key['class_name']; ?></td>
									<td><?php echo $track[0]['track_name']; ?></td>
									<td><input type="number" max="100" value="<?php echo round($class_score) ?>" id="class_score<?php echo $key['student_id'] ?>" class="form-control" style="width:90px;" min="0"></td>
									<td>
									<input type="number" max="100" value="<?php echo round($exam_score) ?>" id="exam_score<?php echo $key['student_id'] ?>" class="form-control" style="width:90px;" min="0">
									</td>
									
									<td><button data-loading-text="&lt;i class='fa fa-refresh fa-spin'&gt;&lt;/i&gt; &nbsp; Saving..." class="btn btn-primary btn-xs pull-right" type="submit" id="save<?php echo $key['student_id'] ?>" name="">
		Save <i class="fa fa-save fa-lg"></i>
	</button></td>
								</tr>
								<script type="text/javascript">
									var class_score = 0;
									var exam_score = 0;
									

									$('#save<?php echo $key['student_id'] ?>').click(function(){
										class_score = $('#class_score<?php echo $key['student_id'] ?>').val();
										class_score2 = (class_score/60)*50;
										exam_score = $('#exam_score<?php echo $key['student_id'] ?>').val();
										exam_score2 = (exam_score/100*50);
										total_score = parseInt(class_score2)+parseInt(exam_score2);
										var data = {
											class_score:class_score,
											exam_score:exam_score,
											class_id:<?php echo $std_class_id; ?>,
											subject_id:<?php echo $subject_id; ?>,
											student_id:<?php echo $key['student_id']; ?>,
											set_scores:''
										};
										console.log(data);
											$.post('ajax/controller/assessmentCode.php',data,function(res){
											$('#total_score<?php echo $key['student_id'] ?>').html(total_score);
											if (res==0) {
												$.smallBox({
					title : "Scores Assigned successfully",
					content : "<i class='fa fa-clock-o'></i> <i>just now...</i>",
					color : "#000000",
					iconSmall : "fa fa-check bounce animated",
					timeout : 4000
				});
											}else if(res==1){
												$.smallBox({
					title : "Could not save scores!",
					content : "<i class='fa fa-clock-o'></i> <i>just now...</i>",
					color : "#275670",
					iconSmall : "fa fa-clock-o bounce animated",
					timeout : 4000
				});
											}else{
												$.smallBox({
					title : "Internal Error!",
					content : "<i class='fa fa-clock-o'></i> <i>just now...</i>",
					color : "#C46A69",
					iconSmall : "fa fa-check bounce animated",
					timeout : 4000
				});
											}
										});
										

									});

									$('#save_all').click(function(){
										class_score = $('#class_score<?php echo $key['student_id'] ?>').val();
										class_score2 = (class_score/60)*50;
										exam_score = $('#exam_score<?php echo $key['student_id'] ?>').val();
										exam_score2 = (exam_score/100*50);
										total_score = parseInt(class_score2)+parseInt(exam_score2);
										var data = {
											class_score:class_score,
											exam_score:exam_score,
											class_id:<?php echo $std_class_id; ?>,
											subject_id:<?php echo $subject_id; ?>,
											student_id:<?php echo $key['student_id']; ?>,
											set_scores:''
										};
										console.log(data);
											$.post('ajax/controller/assessmentCode.php',data,function(res){
											$('#total_score<?php echo $key['student_id'] ?>').html(total_score);
											if (res==0) {
												$.smallBox({
					title : "Scores Assigned successfully",
					content : "<i class='fa fa-clock-o'></i> <i>just now...</i>",
					color : "#000000",
					iconSmall : "fa fa-check bounce animated",
					timeout : 4000
				});
											}else if(res==1){
												$.smallBox({
					title : "Could not save scores!",
					content : "<i class='fa fa-clock-o'></i> <i>just now...</i>",
					color : "#275670",
					iconSmall : "fa fa-clock-o bounce animated",
					timeout : 4000
				});
											}else{
												$.smallBox({
					title : "Internal Error!",
					content : "<i class='fa fa-clock-o'></i> <i>just now...</i>",
					color : "#C46A69",
					iconSmall : "fa fa-check bounce animated",
					timeout : 4000
				});
											}
										});
									});

									
								</script>
									<?php
									}
								}
								 ?>
								
							</tbody>
						</table>
						<button data-loading-text="&lt;i class='fa fa-refresh fa-spin'&gt;&lt;/i&gt; &nbsp; Saving..." class="btn btn-primary btn-lg pull-right" type="submit" id="save_all" name="">
		Save All <i class="fa fa-save fa-lg"></i>
	</button>


					</div>
					<!-- end widget content -->

				</div>
				<!-- end widget div -->

			</div>
			<!-- end widget -->

		</article>
		<!-- WIDGET END -->
		<!-- <article class="col-xs-12 col-sm-12 col-md-12 col-lg-2"></article> -->
	</div>

	<!-- end row -->

	<!-- end row -->

</section>
<!-- end widget grid -->
	<!-- PAGE RELATED PLUGIN(S) -->
		
<script type="text/javascript">

	/* DO NOT REMOVE : GLOBAL FUNCTIONS!
	 *
	 * pageSetUp(); WILL CALL THE FOLLOWING FUNCTIONS
	 *
	 * // activate tooltips
	 * $("[rel=tooltip]").tooltip();
	 *
	 * // activate popovers
	 * $("[rel=popover]").popover();
	 *
	 * // activate popovers with hover states
	 * $("[rel=popover-hover]").popover({ trigger: "hover" });
	 *
	 * // activate inline charts
	 * runAllCharts();
	 *
	 * // setup widgets
	 * setup_widgets_desktop();
	 *
	 * // run form elements
	 * runAllForms();
	 *
	 ********************************
	 *
	 * pageSetUp() is needed whenever you load a page.
	 * It initializes and checks for all basic elements of the page
	 * and makes rendering easier.
	 *
	 */

	pageSetUp();
	
	/*
	 * ALL PAGE RELATED SCRIPTS CAN GO BELOW HERE
	 * eg alert("my home function");
	 * 
	 * var pagefunction = function() {
	 *   ...
	 * }
	 * loadScript("js/plugin/_PLUGIN_NAME_.js", pagefunction);
	 * 
	 */
	
	// PAGE RELATED SCRIPTS
	
	// pagefunction	
	var pagefunction = function() {
		//console.log("cleared");
		
		/* // DOM Position key index //
		
			l - Length changing (dropdown)
			f - Filtering input (search)
			t - The Table! (datatable)
			i - Information (records)
			p - Pagination (paging)
			r - pRocessing 
			< and > - div elements
			<"#id" and > - div with an id
			<"class" and > - div with a class
			<"#id.class" and > - div with an id and class
			
			Also see: http://legacy.datatables.net/usage/features
		*/	

		/* BASIC ;*/
			var responsiveHelper_dt_basic = undefined;
			var responsiveHelper_datatable_fixed_column = undefined;
			var responsiveHelper_datatable_col_reorder = undefined;
			var responsiveHelper_datatable_tabletools = undefined;
			
			var breakpointDefinition = {
				tablet : 1024,
				phone : 480
			};

			$('#dt_basic').dataTable({
				"sDom": "<'dt-toolbar'<'col-xs-12 col-sm-6'f><'col-sm-6 col-xs-12 hidden-xs'l>r>"+
					"t"+
					"<'dt-toolbar-footer'<'col-sm-6 col-xs-12 hidden-xs'i><'col-xs-12 col-sm-6'p>>",
				"autoWidth" : true,
				"preDrawCallback" : function() {
					// Initialize the responsive datatables helper once.
					if (!responsiveHelper_dt_basic) {
						responsiveHelper_dt_basic = new ResponsiveDatatablesHelper($('#dt_basic'), breakpointDefinition);
					}
				},
				"rowCallback" : function(nRow) {
					responsiveHelper_dt_basic.createExpandIcon(nRow);
				},
				"drawCallback" : function(oSettings) {
					responsiveHelper_dt_basic.respond();
				}
			});

		/* END BASIC */
		
		/* COLUMN FILTER  */
	    var otable = $('#datatable_fixed_column').DataTable({
	    	//"bFilter": false,
	    	//"bInfo": false,
	    	//"bLengthChange": false
	    	//"bAutoWidth": false,
	    	//"bPaginate": false,
	    	//"bStateSave": true // saves sort state using localStorage
			"sDom": "<'dt-toolbar'<'col-xs-12 col-sm-6 hidden-xs'f><'col-sm-6 col-xs-12 hidden-xs'<'toolbar'>>r>"+
					"t"+
					"<'dt-toolbar-footer'<'col-sm-6 col-xs-12 hidden-xs'i><'col-xs-12 col-sm-6'p>>",
			"autoWidth" : true,
			"preDrawCallback" : function() {
				// Initialize the responsive datatables helper once.
				if (!responsiveHelper_datatable_fixed_column) {
					responsiveHelper_datatable_fixed_column = new ResponsiveDatatablesHelper($('#datatable_fixed_column'), breakpointDefinition);
				}
			},
			"rowCallback" : function(nRow) {
				responsiveHelper_datatable_fixed_column.createExpandIcon(nRow);
			},
			"drawCallback" : function(oSettings) {
				responsiveHelper_datatable_fixed_column.respond();
			}		
		
	    });
	    
	    // custom toolbar
	    $("div.toolbar").html('<div class="text-right"><img src="img/logo.png" alt="OT SmartAdmin" style="width: 111px; margin-top: 3px; margin-right: 10px;"></div>');
	    	   
	    // Apply the filter
	    $("#datatable_fixed_column thead th input[type=text]").on( 'keyup change', function () {
	    	
	        otable
	            .column( $(this).parent().index()+':visible' )
	            .search( this.value )
	            .draw();
	            
	    } );
	    /* END COLUMN FILTER */   
    
		/* COLUMN SHOW - HIDE */
		$('#datatable_col_reorder').dataTable({
			"sDom": "<'dt-toolbar'<'col-xs-12 col-sm-6'f><'col-sm-6 col-xs-6 hidden-xs'C>r>"+
					"t"+
					"<'dt-toolbar-footer'<'col-sm-6 col-xs-12 hidden-xs'i><'col-sm-6 col-xs-12'p>>",
			"autoWidth" : true,
			"preDrawCallback" : function() {
				// Initialize the responsive datatables helper once.
				if (!responsiveHelper_datatable_col_reorder) {
					responsiveHelper_datatable_col_reorder = new ResponsiveDatatablesHelper($('#datatable_col_reorder'), breakpointDefinition);
				}
			},
			"rowCallback" : function(nRow) {
				responsiveHelper_datatable_col_reorder.createExpandIcon(nRow);
			},
			"drawCallback" : function(oSettings) {
				responsiveHelper_datatable_col_reorder.respond();
			}			
		});
		
		/* END COLUMN SHOW - HIDE */

		/* TABLETOOLS */
		$('#datatable_tabletools').dataTable({
			
			// Tabletools options: 
			//   https://datatables.net/extensions/tabletools/button_options
			"sDom": "<'dt-toolbar'<'col-xs-12 col-sm-6'f><'col-sm-6 col-xs-6 hidden-xs'T>r>"+
					"t"+
					"<'dt-toolbar-footer'<'col-sm-6 col-xs-12 hidden-xs'i><'col-sm-6 col-xs-12'p>>",
	        "oTableTools": {
	        	 "aButtons": [
	             "copy",
	             "csv",
	             "xls",
	                {
	                    "sExtends": "pdf",
	                    "sTitle": "Students List",
	                    "sPdfMessage": "OT SMS PDF Export",
	                    "sPdfSize": "letter"
	                },
	             	{
                    	"sExtends": "print",
                    	"sMessage": "OTSMS Report <i>(press Esc to close)</i>"
                	}
	             ],
	            "sSwfPath": "js/plugin/datatables/swf/copy_csv_xls_pdf.swf"
	        },
			"autoWidth" : true,
			"paging":false,
			"preDrawCallback" : function() {
				// Initialize the responsive datatables helper once.
				if (!responsiveHelper_datatable_tabletools) {
					responsiveHelper_datatable_tabletools = new ResponsiveDatatablesHelper($('#datatable_tabletools'), breakpointDefinition);
				}
			},
			"rowCallback" : function(nRow) {
				responsiveHelper_datatable_tabletools.createExpandIcon(nRow);
			},
			"drawCallback" : function(oSettings) {
				responsiveHelper_datatable_tabletools.respond();
			}
		});
		
		/* END TABLETOOLS */

	};

	// load related plugins
	
	loadScript("js/plugin/datatables/jquery.dataTables.min.js", function(){
		loadScript("js/plugin/datatables/dataTables.colVis.min.js", function(){
			loadScript("js/plugin/datatables/dataTables.tableTools.min.js", function(){
				loadScript("js/plugin/datatables/dataTables.bootstrap.min.js", function(){
					loadScript("js/plugin/datatable-responsive/datatables.responsive.min.js", pagefunction)
				});
			});
		});
	});

$(document).ready(function(){
	$('#import').click(function(){
		 // var form = new FormData($("#import-csv")[0]);
		  var myFormData = new FormData();
myFormData.append('file', $('#file').prop('files')[0]);
var cid = ['<?php echo $std_class_id ?>'];
var sub = ['<?php echo $subject_id ?>'];

myFormData.append('cid',cid);
myFormData.append('sub',sub);
// var data = new FormData(form); 
   $.ajax({
            type: "POST",
            enctype: 'multipart/form-data',
            url: "ajax/set_assessment.php",
            data: myFormData,
            processData: false,
            contentType: false,
            cache: false,
            timeout: 600000,
beforeSend: function(response){

    },
    complete: function(response){
       
    },
    success: function(response){
    	console.log(response);
    	if (response.charAt(0)==0) {
    		$.smallBox({
					title : "Students Imported successfully",
					content : "<i class='fa fa-clock-o'></i> <i>just now...</i>",
					color : "#000000",
					iconSmall : "fa fa-check bounce animated",
					timeout : 4000
				});
    	}else if (response.charAt(0)==1) {
    		$.smallBox({
					title : "Action Failed!",
					content : "<i class='fa fa-clock-o'></i> <i>just now...</i>",
					color : "#C46A69",
					iconSmall : "fa fa-check bounce animated",
					timeout : 4000
				});
    	}else if (response.charAt(0)==3) {
    		$.smallBox({
					title : "Internal Error!",
					content : "<i class='fa fa-clock-o'></i> <i>just now...</i>",
					color : "#C46A69",
					iconSmall : "fa fa-check bounce animated",
					timeout : 4000
				});
    	}
	}
    });
	});
});
</script>
