<?php require '../controller/session.php'; ?>
<?php include 'controller/profileCode.php'; ?>
<?php require_once("inc/init.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 all_staff
			</span>
		</h1>
	</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-8">

			<!-- 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 data-hide="phone,tablet">ID</th>
									<th data-class="expand"> Name</th>
									<th data-hide="phone,tablet"> Action</th>
								</tr>
							</thead>
							
							<tbody>
									<?php 
								if ($all_staff) {
									$id = "";
									$i = 0;
									foreach ($all_staff as $key) {
										$i++;
										// $track = $admission->get_staff_track($key['track']);
										$id = $key['staff_id'];
									?>
									<tr>
									<td><?php echo $i; ?></td>
									<td><?php echo $key['staff_id']; ?></td>
									<td><?php echo $key['last_name']; ?> <?php echo $key['first_name']; ?></td>
									<td><a href="index.php#ajax/assign_subject.php#" onclick="return false" data-target="#assign<?php echo $id; ?>" class="btn btn-primary btn-xs">Assign <i class="fa fa-upload"></i></a></td>
								</tr>
								
								<div class="modal fade" id="assign<?php echo $key['staff_id']; ?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
					<div class="modal-dialog">
						<div class="modal-content">
							<div class="modal-header">
								<button type="button" class="close" data-dismiss="modal" aria-hidden="true">
									&times;
								</button>
								<h4 class="modal-title" id="myModalLabel"><?php echo $key['last_name']; ?> <?php echo $key['first_name']; ?></h4>
							</div>
							<div class="modal-body">
				
								<div class="row">
									<div class="col-md-12">
										<div class="well well-sm well-primary">
											<form class="form form-inline" action=""  onsubmit="//return false;" id="checkout-form<?php echo $key['staff_id']; ?>" method="POST" role="form">
													<div class="ajax_load">
													<div class="form-group">
													<select class="form-control load_classes" id="class<?php echo $id;?>">
														<option> -- Select a Class --</option>
														<?php 
														
														if ($all_classes) {
															
															$subject_name = "";	
															$class_name = "";
															foreach ($all_classes as $class) {
																$label = "";
															$if_assigned = $profile->verify_if_subject_assigned($id,$class['class_id']);
															  	if ($if_assigned) {
																	  $i=0;
																	  if($if_assigned){
															  		foreach($if_assigned as $assigned){
															  			$i++;
															  		$subject_name = $profile->get_subject($assigned['subject_id']);
															  		if($i<sizeof($if_assigned)){
															  			if ($assigned['staff_id']==$id) {
															  			$label .= '('.$subject_name[0]['subject_name'].'),';
															  		}else{
															  			$label .= $subject_name[0]['subject_name'];
															  		}
															  			
															  		}else{
															  			if ($assigned['staff_id']==$id) {
															  			$label .= '('.$subject_name[0]['subject_name'].')';
															  		}else{
															  			$label .= $subject_name[0]['subject_name'];
															  		    }
															  			}
																	  }
																	}
															  		
															  	}
																$class_name = $profile->get_class($class['class_id']);
																?>
															  		
															<option value="<?php echo $class['class_id'] ?>"><?php echo $class_name[0]['class_name'] ?> - <span style="color: #F1DA91"><?php echo $label; ?></span></option>	

																<?php
															}
														}
														 ?>
														
													
													</select>
												</div>
												<div class="form-group">
													<select class="form-control" id="subject<?php echo $id;?>">
														<option> -- Select a Subject --</option>
														<?php 
														
														if ($subject_list) {
															foreach ($subject_list as $key) {
																?>
															<option value="<?php echo $key['subject_id'] ?>"><?php echo $key['subject_name'] ?></option>	

																<?php
															}
														}
														 ?>
														</select>

												</div>
												</div>
												<div class="form-group">
													<input type="hidden" name="assign_subject">
													<input type="submit" id="assign_subject<?php echo $id;?>" class="btn btn-primary btn-sm" value="Assign">
													<input type="submit" id="unassign_subject<?php echo $id;?>" class="btn btn-danger btn-sm" value="Unassign">
														
												</div>
											</form>
										</div>
									</div>
								</div>
				
							</div>
							<div class="modal-footer">
								<button type="button" class="btn btn-default" data-dismiss="modal">
									Cancel
								</button>
								
							</div>
						</div><!-- /.modal-content -->
					</div><!-- /.modal-dialog -->
				</div><!-- /.modal --> 

				<script type="text/javascript">
					$(document).ready(function(){
						// setInterval(function(){
						// 	$.get('ajax/ajax_load/load_assigned_classes.php',function(res){
						// 		$('#class<?php //echo $id; ?>').html(res)
						// 	});
						// },500);
						$("a[data-target=#assign<?php echo $id; ?>]").click(function(ev) {
						    ev.preventDefault();
						    var target = $(this).attr("href");

						    // load the url and show modal on success
						   // $("#assign<?php echo $id; ?> .modal-body").load(target, function() { 
						         $("#assign<?php echo $id; ?>").modal("show"); 
						    //});

						});
						$(document).on('hidden.bs.modal', function (e) {
								    $(e.target).removeData('bs.modal');
								});
						$(document).on('click','#assign_subject<?php echo $id;?>',function(){
							var selected_class = $('#class<?php echo $id;?>').val();
							var subject = $('#subject<?php echo $id;?>').val();
							var data = {
								class_id:selected_class,
								subject:subject,
								staff_id:'<?php echo $id; ?>',
								assign_subject:''
							};
							$.post('ajax/assign_subject.php',data,function(res){
								if (res.charAt(0) == 0) {
									// $.get('ajax/ajax_load/load_sub_assign.php?id=<?php echo $id ?>',function(response){
									// 	// $('.ajax_load').html(response);
									// 	// console.log(response);
									// });
									$.get('ajax/ajax_load/laod_assigned_classes.php?id=<?php echo $id; ?>',function(response){
								$('#class<?php echo $id; ?>').html(response)
								console.log(res);
							});
						    		$.smallBox({
											title : "Subject Assigned Successfully",
											content : "<i class='fa fa-clock-o'></i> <i>just now...</i>",
											color : "#000000",
											iconSmall : "fa fa-check bounce animated",
											timeout : 4000
										});
						    		
						    		 $('#checkout-form3').find("input[type=text], textarea,input[type=email],input[type=phone]").val("");
						    	}else{
						    		$.smallBox({
											title : "Subject not Assigned!",
											content : "<i class='fa fa-clock-o'></i> <i>just now...</i>",
											color : "#C46A69",
											iconSmall : "fa fa-check bounce animated",
											timeout : 4000
										});
						    	}
							});
						});
						$(document).on('click','#unassign_subject<?php echo $id;?>',function(){
							var selected_class = $('#class<?php echo $id;?>').val();
							var subject = $('#subject<?php echo $id;?>').val();
							var data = {
								class_id:selected_class,
								subject:0,
								staff_id:'<?php echo $id; ?>',
								assign_subject:''
							};
							$.post('ajax/assign_subject.php',data,function(res){
								if (res.charAt(0) == 0) {
									// $.get('ajax/ajax_load/load_sub_assign.php?id=<?php echo $id ?>',function(response){
									// 	// $('.ajax_load').html(response);
									// 	// console.log(response);
									// });
									$.get('ajax/ajax_load/laod_assigned_classes.php?id=<?php echo $id; ?>',function(response){
								$('#class<?php echo $id; ?>').html(response)
								console.log(res);
							});
						    		$.smallBox({
											title : "Subject Assigned Successfully",
											content : "<i class='fa fa-clock-o'></i> <i>just now...</i>",
											color : "#000000",
											iconSmall : "fa fa-check bounce animated",
											timeout : 4000
										});
						    		
						    		 $('#checkout-form3').find("input[type=text], textarea,input[type=email],input[type=phone]").val("");
						    	}else{
						    		$.smallBox({
											title : "Subject not Assigned!",
											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>


					</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 -->

<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="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": "Staff Log Book",
	                    "sPdfMessage": "SIS PDF Export",
	                    "sPdfSize": "letter"
	                },
	             	{
                    	"sExtends": "print",
                    	"sMessage": "SIS Report <i>(press Esc to close)</i>"
                	}
	             ],
	            "sSwfPath": "js/plugin/datatables/swf/copy_csv_xls_pdf.swf"
	        },
			"autoWidth" : true,
			"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)
				});
			});
		});
	});


</script>
