MOON
Server: Apache
System: Linux nserver.cafsindia.com 4.18.0-553.104.1.lve.el8.x86_64 #1 SMP Tue Feb 10 20:07:30 UTC 2026 x86_64
User: cafsindia (1002)
PHP: 8.2.30
Disabled: NONE
Upload Files
File: /home/cafsindia/uds.cafsinfotech.in/application/views/session_audit/manage.php
<?php 
	$this->load->view("partial/header"); 
	$access_data    = $this->session->userdata('access_data');
	$access_add     = (int)$access_data[$controller_name]['access_add'];
	$access_update  = (int)$access_data[$controller_name]['access_update'];
	$access_delete  = (int)$access_data[$controller_name]['access_delete'];
	$access_search  = (int)$access_data[$controller_name]['access_search']; 
	$access_export  = (int)$access_data[$controller_name]['access_export'];
	$access_import  = (int)$access_data[$controller_name]['access_import'];
	$page_name      = ucwords(str_replace("_"," ",$controller_name));
	$prime_id       = "prime_".$controller_name."_id";
	$search_url     = site_url($controller_name ."/search");
	$view_url       = site_url($controller_name ."/view/");
	$import_url     = site_url($controller_name ."/import/");
?>
<div class='row title_content'>
	<div class='col-md-2 col-xs-4'>
		<h1 class='page_txt'><?php echo $page_name;?></h1>
	</div>
</div>
<div class='col-md-12' style='margin-top:30px;'>
	<div class="form-group col-md-2">
		<?php
			$form_input   = form_input(array("name"=>"emp_hidden", "id"=>"emp_hidden","value"=>'',"placeholder"=>"Search Employee Code","class"=>"form-control input-sm"));
				$hidden_input = form_input( array("name"=>"emp_code", "id"=>"emp_code","value"=>"","type"=>"hidden"));
				echo $input_box   = "<div class='form-group' >$hidden_input $form_input <div class='append_div'></div></div>";
		?>
	</div>
			<div class = "form-group col-md-2">
				<button class = 'btn btn-primary btn-sm' id = "download">Download</button>
			</div>
</div>
<script type="text/javascript">
	$(document).ready(function (){
		$('#emp_hidden').autocomplete({
			minChars:3,
			autoFocus: true,
			delay:5,
			appendTo: '.append_div',
			source: function (request, response) {
				if(request.term.length >= 4){
					// Encryption
					var encKey  = '<?php echo $encKey; ?>';
					var data    = {term:request.term};
					var encData = encrypt(encKey,data);
					$.ajax({
						url: '<?php echo site_url("$controller_name/get_employee_list"); ?>',
						type: 'post',
						data:encData,				
						contentType: 'text/plain',
						success: function (data) {
							var rslt = JSON.parse(data);
							response($.map(rslt, function (el) {
								if(el.value === '0'){
									$('#emp_hidden').val('');
								}else{
									return {
										value: el.value,
										label: el.label,
										display_name:el.display_name,
										wbs_network_id:el.wbs_network_id
									};
								}
							}));
						}
					});
				}
			},
			select: function(e, ui) {
				e.preventDefault();
				$('#emp_code').val(ui.item.value);
				$('#emp_hidden').val(ui.item.display_name);
				// $('#emp_hidden').prop('readonly', true);
			},
			change: function(event, ui) {
				if (ui.item === null || ui.item === '' || ui.item === 'null') {
					$('#emp_hidden,#emp_code').val('');
				}
			}
		});

			
		//FUNCTION FOR BUTTON ONCLICK SUBMIT
		$('#download').on('click',function(){
			var emp_code =$('#emp_code').val();
			if(emp_code === ""){
				toastr.error("Please Select Employee Code");
				return false;
			}
			$("#download").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
			// Encryption
			var encKey  = '<?php echo $encKey; ?>';
			var data    = {emp_code:emp_code};
			var encData = encrypt(encKey,data);
			$.ajax({
				type: "POST",
				url: '<?php echo site_url("$controller_name/session_data"); ?>',
				data:encData,				
				contentType: 'text/plain',
				success: function(data){
					var rslt = JSON.parse(data);
					if(rslt.success){
						ExportToExcel(rslt.session_data,rslt.message);
						$("#download").html("Download");

					}else{
						toastr.error(rslt.message);
						$("#download").html("Download"); 
					}
				},
			});
		})

		$(function(){
			$('.select2').select2({
				placeholder: '---- Select ----',
			});
			$('.select2-tags').select2({
				tags: true,
				tokenSeparators: [',']
			});
		});
	});

	//CALLBACK FUCNTION FOR DOWNLOAD EXCEL EXPORT
function ExportToExcel(rslt_arr,callback_success) {
	
	// return false;
	//ALLOWANCE OBJECT GET FROM GLOBALLY
	let sheet_name       =  "session_Audit";
	try {
		//ARRAY OF OBJECT TO EXCEL EXPORT
		/* generate worksheet and workbook */
		const worksheet = XLSX.utils.json_to_sheet(rslt_arr);
		const workbook = XLSX.utils.book_new();
		XLSX.utils.book_append_sheet(workbook, worksheet, sheet_name);
		/* fix headers */
		// XLSX.utils.sheet_add_aoa(worksheet, [["Name", "Birthday"]], { origin: "A1" });

		/* calculate column width */
		// const max_width = rows.reduce((w, r) => Math.max(w, r.name.length), 10);
		// worksheet["!cols"] = [ { wch: max_width } ];
		/* create an XLSX file and try to save to Presidents.xlsx */
		XLSX.writeFile(workbook, sheet_name+".xlsx", { compression: true });

		//CALLBACK FUNCTION USING FOR SUCCESS MESSAGE THROUGH TO FRONT SIDE
		toastr.success(callback_success);
	} catch (err) {
	}
}

</script>
<?php $this->load->view("partial/footer"); ?>