File: /home/cafsindia/hrms_patroniss_com/application/views/master_details_export/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/");
/* PAGE TITLE AND BUTTONS- START */
$quick_link = explode(",",$quick_link->quicklink);
$link_li_line = "";
foreach($quick_link as $link){
if($link){
$url = site_url("$link");
$name = ucwords(str_replace("_"," ",$link));
$link_li_line .= "<li><a href='$url'> <i class='fa fa-angle-double-right fa-lg' aria-hidden='true'></i> $name</a></li>";
}
}
if($link_li_line){
$breadcrumb .= "<li class='dropdown'>
<a class='btn btn-xs btn-primary dropdown-toggle' type='button' id='dropdownMenu2' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'>
<i class='fa fa-plus-circle' aria-hidden='true'></i> Quick Links
</a>
<ul class='dropdown-menu dropdown-menu-left' aria-labelledby='dropdownMenu2'>
$link_li_line
</ul>
</li>";
}
$breadcrumb .="<li><a href='$site_url#Home'>Home</a></li>
<li><a href='$site_url/$controller_name#$controller_name'>$page_name</a></li>
<li class='active'>List</li>";
/* PAGE TITLE AND BUTTONS- END */
?>
<div class='row title_content'>
<div class='col-md-2 col-xs-4'>
<h1 class='page_txt'><?php echo $page_name;?></h1>
</div>
<div class='col-md-10 col-xs-8'>
<ol class="breadcrumb">
<?php echo $breadcrumb; ?>
</ol>
</div>
</div>
<div id="table_holder">
<div class='col-md-12 form-inline'style='margin:15px 0px;border-radius:2px;box-shadow:0 2px 2px 0 rgba(0,0,0,0.14),0 3px 1px -2px rgba(0,0,0,0.12),0 1px 5px 0 rgba(0,0,0,0.2);padding:15px 0px;'>
<div class="form-group">
<?php
$process_type = array(""=>"---- Select Process Type ----","1"=>"Process By Employee","2"=>"Process By Role","3"=>"Process All");
echo form_label("Process Type", 'process_type', array('class' => 'required'));
echo form_dropdown(array("name" =>'process_type',"id" =>'process_type',"class" =>'form-control input-sm'),$process_type);
?>
</div>
<div class="form-group" style='display:none;max-height: 50px;!important'>
<?php
echo form_label("Search Employee", 'process_emp_code', array('class' => 'required'));
echo form_input(array('name' =>'process_emp_code','id' =>'process_emp_code','class' => 'form-control input-sm','value'=>'','placeholder'=>"Search by Employee Code"));
?>
<div class='append_div'></div>
</div>
<div class="form-group" style='display:none;'>
<?php
echo form_label("Process Role", 'process_role', array('class' => 'required'));
echo form_dropdown(array("name" =>'process_role',"id" =>'process_role',"class" =>'form-control input-sm'),$process_role);
?>
</div>
<div class="form-group">
<?php
echo form_label("Master Details", 'master_details', array('class' => 'required'));
echo form_dropdown(array("name" =>'master_details',"id" =>'master_details',"class" =>'form-control input-sm'),$module_list);
?>
</div>
<div class="form-group" id='download'>
<button class='btn btn-primary btn-sm' id="process_btn"> Generate Excel</button>
</div>
</div>
</div>
<script type="text/javascript">
$(document).ready(function (){
$('#process_type').change(function () {
process_type = $("#process_type").val();
$('#process_emp_code,#process_role').parent().hide();
$('#process_emp_code').val("");
$('#process_role').val("");
if(process_type === "1"){
$('#process_emp_code').parent().show();
}else
if(process_type === "2"){
$('#process_role').parent().show();
}else{
$('#process_emp_code,#process_role').parent().hide();
}
});
$('#process_emp_code').autocomplete({
source: function(request, response) {
$.getJSON('<?php echo site_url("$controller_name/emp_suggest");?>',{term:request.term},response);
},
minChars:3,
autoFocus: true,
delay:10,
scroll: true,
appendTo: '.append_div',
select: function(e, ui) {
$('#process_emp_code').val(ui.item.value);
return false;
}
});
$("#process_btn").click(function(event){
var process_type = $('#process_type').val();
var process_role = $('#process_role').val();
var process_emp_code = $('#process_emp_code').val();
var master_details = $('#master_details').val();
// mode == block
var can_process = true;
if(process_type === "" && process_type.length < 1) {
can_process = false;
}
if(parseInt(process_type) === 1){
if(process_emp_code === "" && process_emp_code.length < 1) {
can_process = false;
}
}else
if(parseInt(process_type) === 2){
if(process_role === "" && process_role.length < 1) {
can_process = false;
}
}
if(master_details === "" && master_details.length < 1) {
can_process = false;
}
if(can_process){
$("#process_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#process_btn').attr('disabled','disabled');
if(process_type && master_details){
$.ajax({
type: "POST",
url: '<?php echo site_url("master_details_export/rowset_export"); ?>',
data: {process_role:process_role,process_emp_code:process_emp_code,master_details:master_details,process_type:process_type},
success: function(data){
$('#process_btn').attr('disabled',false);
$("#process_btn").html("Generate Excel");
var rslt = JSON.parse(data);
if(rslt.success){
var href = "<a href="+rslt.excel_path+" class='btn btn-info btn-sm' id='link' onclick='hide_link()'><span class='fa fa-download'> </span> Download</a>";
$('#download').append(href);
}else{
toastr.error(rslt.message);
}
empty_all();
}
});
}
}else{
toastr.error("Please fill all the Mandatory Fields...");
empty_all();
}
});
});
function hide_link(){
$("#link").hide();
}
function empty_all(){
$('#process_type').val('');
$('#process_role').val('');
$('#process_emp_code').val();
$('#master_details').val('');
}
</script>
<?php $this->load->view("partial/footer"); ?>