File: /home/cafsindia/uds.cafsinfotech.in/application/views/pay_structure_report/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));
$uniqueId = "prime_".$controller_name."_id";
$category = $this->session->userdata('logged_role');
$employee_code = $this->session->userdata('logged_emp_code');
$user_role = $this->session->userdata('logged_user_role');
$import_url = site_url($controller_name ."/import/");
$breadcrumb = "";
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>";
?>
<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-6'>
<ol class="breadcrumb">
<?php echo $breadcrumb; ?>
</ol>
</div>
</div>
<div id="holder" class="form-inline" style="margin-top:10px;">
<div class="col-md-12">
<!-- PROJECT -->
<div class="form-group" >
<?php
echo form_label("Personal Area", 'personal_code', array('class' => 'required'));
echo form_input(array('name'=> 'personal_code','id'=>'personal_code','list'=> 'list_personal_code','class'=> 'form-control form-inline input-sm','value'=> '','placeholder' => 'Search Personal Area'));
echo "<datalist id=\"list_personal_code\">" . $per_area_list . "</datalist>";
?>
</div>
<div class="form-group">
<?php
echo form_label("Project", 'project_id');
echo form_input(array('name' => 'hid_project_id', 'id' => 'project_id','list'=>'list_project_id' ,'class' => 'form-control input-sm', 'value' => '', 'placeholder' => 'Search project Id'));
echo "<datalist id=\"list_project_id\"></datalist>";
?>
</div>
<div class="form-group">
<?php
echo form_label("Wbs Element", 'wbs_element');
echo form_input(array('name' => 'hid_wbs_element', 'id' => 'wbs_element','list'=>'list_wbs_element' ,'class' => 'form-control input-sm', 'value' => '', 'placeholder' => 'Search Wbs Element'));
echo "<datalist id=\"list_wbs_element\"></datalist>";
?>
</div>
<div class="form-group">
<?php
echo form_label("Position", 'position');
echo form_input(array('name' => 'hid_position', 'id' => 'position','list'=>'list_position' ,'class' => 'form-control input-sm', 'value' => '', 'placeholder' => 'Search Position'));
echo "<datalist id=\"list_position\"></datalist>";
?>
</div>
<div class="form-group" style='display:none'>
<?php
echo form_label("network_id", 'network_id');
echo form_input(array('name' => 'hid_network_id', 'id' => 'network_id','list'=>'list_network_id' ,'class' => 'form-control input-sm', 'value' => '', 'placeholder' => 'Search Position'));
echo "<datalist id=\"list_network_id\"></datalist>";
?>
</div>
</div>
<!-- FOR DYNAMIC PAY STRUCTURE BUILD FORM CODE -->
<div class='form-group' style="margin-top: 24px;" style = 'width:100px;'>
<button class = "btn btn-primary btn-sm" id="submit">Submit</button>
</div>
<a href="javascript:void(0)" id="dlbtn" style="display: none;">
<button type="button" id="mine">Export</button>
</a>
</div>
<script src="https://unpkg.com/xlsx/dist/xlsx.full.min.js"></script>
<script type="text/javascript">
$(document).ready(function (){
/* LOAD SCRIPT */
<?php
echo "$document_load_script";
?>
<?php echo $error_info; ?>
<?php echo $toastr_fadeout ?>
var datalist_validate = '<?php echo $datalist_validate; ?>';
//Datalist selected value fetch
$(document).on('change', 'input'+datalist_validate, function(){
var selected_value = $(this).val();
var list = $(this).attr('list');
var attr_id = list.replace('list_', '');
var data_value = $('#'+list+' option[value=\"' + selected_value + '\"]').attr('data-value');
var data_text = $('#'+list+' option[value=\"' + selected_value + '\"]').text();
if(data_value){
$('#'+attr_id).val(data_value);
if(attr_id === 'wbs_element'){ //If Wbs Changed then Activity should fetch based on wbs
get_pick_data(data_value);
//fetch_network(data_value);
$('#'+list).prop('readonly', true);
}
$('#'+attr_id+'_div').remove();
if(attr_id && data_value){
var words = data_text.split(' ');
var text = '';
for (var i = 0; i < words.length; i++){
if ((text + words[i]).length > 28){
text += '...';
break;
}
text += words[i] + ' ';
}
var datalist_span = '<div class="datalist_name">';
datalist_span += '<span id="' + attr_id + '_div" class="datalist_span">';
datalist_span += '<b style="cursor:pointer;" title="' + data_text + '">' + text + '</b>';
datalist_span += ' <a class="clear-btn-data" style="cursor:pointer;font-size:11px" onClick="clear_btn(\'' + attr_id + '\')"><i class="fa fa-remove" aria-hidden="true"></i></a>';
datalist_span += '</span></div>';
$("#" + attr_id).parent().append(datalist_span);
}else{
$('#'+attr_id+'_div').remove();
}
}else{
if(attr_id === 'wbs_element'){
$('#network_id').val('');
}
$('#'+attr_id).val('');
}
});
var rslt_data = 0;
$(document).on('input', 'input[name="hid_project_id"]', function(){
var name = $(this).attr('name');
var list = $(this).attr('list');
var name = name.replace("hid_","");
var attr_id = name.replace("[]","");
var personal_code = $('#personal_code').val();
if(personal_code){
var term = $(this).val();
if(term.length < 4){
rslt_data = 0;
}
if(term.length >= 4 && rslt_data === 0){
rslt_data = 1;
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {term:term,personal_code:personal_code};
var encData = encrypt(encKey,data);
$.ajax({
url: '<?php echo site_url("$controller_name/get_project"); ?>',
type: 'post',
data:encData,
contentType: 'text/plain',
success: function(data){
var rslt = JSON.parse(data);
$("#"+list).html('');
if(rslt.success){
$.each(rslt.search_rslt, function(i, value){
$("#"+list).append("<option data-value='"+value.pro_id+"' value='"+$.trim(value.pro_id)+"' >"+$.trim(value.pro_desc)+"</option>");
});
}else{
var rslt_data = 0;
}
},
beforeSend: function(){
$("#"+list).attr('disabled','disabled');
$("#span_"+attr_id).remove('');
$("#"+attr_id).parent().append('<span id="span_'+attr_id+'" style="color:#CC3366;"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</span>');
},
complete: function() {
$("#"+list).attr('disabled',false);
$("#span_"+attr_id).remove('');
}
});
}
}else{
toastr.error("Please Choose Personal Area...!");
return false;
}
});
$("#personal_code").on("change",function(){
$('#project_id,#position,#network_id,#wbs_element').val('');
$('#project_id_div,#wbs_element_div,#position_div').remove();
$('input[name="hid_position"]','input[name="hid_project_id"]','input[name="hid_wbs_element"]','input[name="hid_position"]').val('');
})
$(document).on('input', 'input[name="hid_wbs_element"]', function(){
var name = $(this).attr('name');
var list = $(this).attr('list');
var name = name.replace("hid_","");
var attr_id = name.replace("[]","");
var personal_code = $('#personal_code').val();
var project_id = $("#project_id").val();
if(!personal_code){
toastr.error("Please Choose Personal Area...!");
return false;
}
if(!project_id){
toastr.error("Please Choose Project...!");
return false;
}
var term = $(this).val();
if(term.length < 4){
rslt_data = 0;
}
if(term.length >= 4 && rslt_data === 0){
rslt_data = 1;
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {term:term,personal_code:personal_code,project_id:project_id};
var encData = encrypt(encKey,data);
$.ajax({
url: '<?php echo site_url("$controller_name/get_wbs"); ?>',
type: 'post',
data:encData,
contentType: 'text/plain',
success: function(data){
var rslt = JSON.parse(data);
$("#"+list).html('');
if(rslt.success){
$.each(rslt.search_rslt, function(i, value){
$("#"+list).append("<option data-value='"+value.wbs_id+"' value='"+$.trim(value.wbs_id)+"' >"+$.trim(value.wbs_desc)+"</option>");
});
}else{
var rslt_data = 0;
}
},
beforeSend: function(){
$("#"+list).attr('disabled','disabled');
$("#span_"+attr_id).remove('');
$("#"+attr_id).parent().append('<span id="span_'+attr_id+'" style="color:#CC3366;"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</span>');
},
complete: function() {
$("#"+list).attr('disabled',false);
$("#span_"+attr_id).remove('');
}
});
}
});
//Get Pickdata on change wbs
function get_pick_data(wbs_element){
var send_url = '<?php echo site_url("$controller_name/get_pick_data");?>';
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {wbs_element:wbs_element};
var encData = encrypt(encKey,data);
$.ajax({
type: 'POST',
url: send_url,
data:encData,
contentType: 'text/plain',
beforeSend: function(){
$("#list_position,#list_activity_no").attr('disabled','disabled');
$("#list_position,#activity_no").parent().append('<span class="span_loader" style="color:#CC3366;"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</span>');
},
complete: function() {
$("#list_position,#list_activity_no").attr('disabled',false);
$(".span_loader").remove('');
},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
if(rslt.position_rslt){ //Position option fetch
$("#list_position").html('');
$.each(rslt.position_rslt, function(key, value){
if(value.position_code !== ""){
$("#list_position").append("<option data-value='"+value.position_code+"' value='"+$.trim(value.position_code)+"' >"+$.trim(value.position_name)+"</option>");
}
});
}
if(rslt.activity_rslt){ //Activity option fetch
$("#list_activity_no").html('');
$.each(rslt.activity_rslt, function(key, value){
if(value.prime_sap_activity_id !== ""){
$("#list_activity_no").append("<option data-value='"+value.prime_sap_activity_id+"' value='"+$.trim(value.act_no)+"' >"+$.trim(value.act_desc)+"</option>");
}
});
}else{
toastr.error('Activity not Available for this WBS.. <button type="button" class="btn-xs btn clear btn-toastr" onclick="toastr.clear()">OK</button>' , 'Error Message:');
}
if(rslt.network_rslt){ // Hidden Network value fetch
$('#network_id').val(rslt.network_rslt[0].wbs_network_id);
}
}else{
toastr.error(rslt.message);
}
}
});
}
$(function(){
$(".datepicker").datetimepicker({
format: 'DD-MM-YYYY',
//debug: true
});
});
$("#submit").click(function(){
// var category = $('#category').val();
var personal_code = $('#personal_code').val();
var project_id = $("#project_id").val();
var wbs_element = $('#wbs_element').val();
var position = $('#position').val();
var activity_no = $('#activity_no').val();
var network_id = $('#network_id').val();
var valid_datas = true;
<?php echo $pay_check_col ?>;
// if(<?php echo $vaildation_add_chk ?>){
if(personal_code !== ''){
var valid_datas = true;
}else{
var valid_datas = false;
/*toastr.error("Please Choose All Show Fields..!");*/
toastr.error("Missing Personal Area..!");
}
// if(valid_datas){
$("#submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#submit').attr('disabled','disabled');
var send_url = '<?php echo site_url("$controller_name/excel_export");?>'
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {personal_code:personal_code,wbs_element:wbs_element,project_id:project_id,position:position,activity_no:activity_no,network_id:network_id};
var encData = encrypt(encKey,data);
$.ajax({
type: 'POST',
url: send_url,
data:encData,
contentType: 'text/plain',
success: function(result){
$('#submit').attr('disabled',false);
$('#submit').html('Submit');
if(result === 'No_Records_Found'){
toastr.error("No Records Found.!");
}else{
if(result === "error"){
toastr.error('No Data...');
}else{
var dlbtn = document.getElementById("dlbtn");
var file = new Blob([result], {type: 'text/xls'});
dlbtn.href = URL.createObjectURL(file);
dlbtn.download = 'Paystucture Report.xls';
$( "#mine").click();
}
}
}
});
// }
});
select_call();
});
//-------------------------------- FUNCTION MODE START ------------------------------------------------
function clear_btn(attr_id){
if(attr_id === 'wbs_element'){
$('#network_id,#position').val('');
$('#position_div').remove();
$('input[name="hid_position"]').val('');
}else
if(attr_id === "personal_code"){
$('#project_id,#position,#network_id,#wbs_element').val('');
$('#project_id_div,#wbs_element_div,#position_div').remove();
$('input[name="hid_position"]','input[name="hid_project_id"]','input[name="hid_wbs_element"]','input[name="hid_position"]').val('');
}else
if(attr_id === "project_id"){
$('#position,#network_id,#wbs_element').val('');
$('#wbs_element_div,#position_div').remove();
$('input[name="hid_position"]','input[name="hid_wbs_element"]','input[name="hid_position"]').val('');
}else{
$('#network_id').val('');
}
$('#'+attr_id+'_div').remove();
$('#'+attr_id).val('');
$('input[name="hid_'+attr_id+'"]').val('');
}
function select_call(){
$(function(){
$('.select2').select2({allowClear: true,placeholder: "--- Select ---",});
$('.select2-tags').select2({
allowClear: true,
tags: true,
placeholder: "--- Select ---",
tokenSeparators: [',']
});
$(".select2_user").select2({
placeholder: "--- Select ---",
allowClear: true,
tags: true
});
});
}
</script>
<style>
.pull-right.search {
display: none !important;
}
.columns.columns-right.btn-group.pull-right {
display: none !important;
}
.floatright {
float:right;
display: inline;
padding: 0 1.5em;
}
.btn-sm {
width: 50px !important;
}
#ear_ded_save {
position: absolute;
right: 32px;
}
#pay_struct_save {
position: absolute;
right: 40px;
}
/* .btn-style {
padding : 8px;
} */
<?php
if($access_search === 1){
echo ".pull-right.search { display: block !important; }";
}
if($access_export === 1){
echo ".columns.columns-right.btn-group.pull-right{display: block !important;}";
}
?>
</style>
<?php $this->load->view("partial/footer"); ?>