File: /home/cafsindia/.trash/application_bkold/views/challan_entry_bk/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));
<<<<<<< HEAD
$prime_id = "prime_".$controller_name."_id";
=======
// $prime_id = "prime_".$controller_name."_id";
$prime_id = "employee_code";
>>>>>>> a438ff18b14e8bd158d59820ccab5b0cbec83097
$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 */
<<<<<<< HEAD
$breadcrumb = "";
if($access_add === 1){
$breadcrumb .= "<li>
<a class='btn btn-xs btn-primary add' data-btn-submit='Submit' title='Add $page_name' href='$view_url' data_form='$controller_name'> <span class='fa fa-user-plus'> </span>Add $page_name</a>
</li>";
}
if($access_import === 1){
$breadcrumb .= "<li>
<a class='btn btn-xs btn-primary import' data-btn-submit= 'Submit' title='Import $page_name' href='$import_url' data_form='$controller_name' > <span class='fa fa-cloud-upload'> </span> Import $page_name
</a>
</li>";
}
$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 */
/* PAGE FILTER - START */
$filter_tr_line = "";
$table_map_list = "";
$input_ids = "";
$date_ids = "";
$load_script = "";
//DR COMMAND CODE FOR WAITING TO ADD A NEW CHANGES
foreach($fliter_list as $fliter){
$label_id = "filter_".$fliter->label_name;
$lable = $fliter->label_name;
$label_name = ucwords($fliter->view_name);
$field_isdefault = (int)$fliter->field_isdefault;
$array_list = $pick_list[$lable]['array_list'];
$field_type = (int)$fliter->field_type;
$prime_form_id = $fliter->prime_form_id;
$dependent_pick_list = (int)$fliter->dependent_pick_list;
if($field_type === 4){
$filter_box = form_input(array("name"=>$label_id, "id"=>$label_id,"placeholder"=>$label_name, "class"=>"form-control input-sm datepicker"));
$filter_tr_line .= "<tr>
<td class='search_td'> $label_name</td>
<td> $filter_box </td>
</tr>";
}else
if(((int)$field_type === 5) || ((int)$field_type === 7)){
$filter_box = form_dropdown(array("name" =>$label_id,"multiple id" => $label_id,"class" =>'form-control input-sm select2'),$array_list);
$filter_tr_line .= "<tr>
<td class='search_td'> $label_name</td>
<td>$filter_box</td>
</tr>";
}else
if((int)$field_type === 6){
$form_checkbox = form_checkbox(array("name" => $label_id,"id" => $label_id, "value"=> 1, "checked" => ($input_value) ? 1 : 0));
$filter_box .= "<label class='checkbox-inline'> $form_checkbox $form_label </label>";
$filter_tr_line .= "<tr>
<td class='search_td'> $label_name</td>
<td colspan='2'>$filter_box</td>
</tr>";
}else
if($field_type === 13){
$filter_box = form_input(array("name"=>$label_id, "id"=>$label_id,"placeholder"=>$label_name, "class"=>"form-control input-sm datepicker_time"));
$filter_tr_line .= "<tr>
<td class='search_td'> $label_name</td>
<td> $filter_box </td>
</tr>";
}else
if($field_type === 9){
$hidden_id = $label_id."_hidden_".$prime_form_id;
$auto_id = "#$label_id";
$table_val = '$table.draw()';
$filter_box = form_input(array("name"=>$label_id, "id"=>$label_id,"value"=>'',"placeholder"=>$label_name, "class"=>"form-control input-sm"));
$hidden_input = form_input( array("name"=>$hidden_id, "id"=>$hidden_id,"value"=>"","type"=>"hidden"));
$filter_tr_line .= "<tr>
<td class='search_td'> $label_name</td>
<td> $filter_box $hidden_input</td>
<div class='append_div'></div>
</tr>";
$auto_url = site_url("$controller_name/suggest_auto_filter?prime_form_id=$prime_form_id");
$load_script .= "$('#$label_id').autocomplete({
source: '$auto_url',
minChars:2,
autoFocus: true,
delay:10,
appendTo: '.append_div',
select: function(e, ui) {
e.preventDefault();
value = ui.item.value;
label = ui.item.label;
$('#$hidden_id').val(ui.item.value);
$('$auto_id').val(ui.item.display_name);
$table_val
}
});\n";
}else{
$filter_box = form_input(array("name"=>$label_id, "id"=>$label_id,"value"=>'',"placeholder"=>$label_name, "class"=>"form-control input-sm"));
$filter_tr_line .= "<tr>
<td class='search_td'> $label_name</td>
<td> $filter_box </td>
</tr>";
}
$table_map_list .= "var $label_id = $('#$label_id').val(); \n data.$lable = $label_id;\n";
if($field_type === 4){
$date_ids .= "#".$label_id.",";
}else
if($field_type === 9){
$hidden_id = $label_id."_hidden_".$prime_form_id;
$table_map_list .= "var $label_id = $('#$label_id').val(); \n data.$lable = $label_id;\n";
$table_map_list .= "var $hidden_id = $('#$hidden_id').val(); \n data.$hidden_id = $hidden_id;\n";
}else{
$input_ids .= "#".$label_id.",";
}
}
$date_ids = rtrim($date_ids,",");
$input_ids = rtrim($input_ids,",");
$filter_table = "<table class='fliter_table'>$filter_tr_line</table>";
/* PAGE FILTER - END */
$column_count = count(array_column($table_head, "label_name"))+1;
?>
=======
?>
<style>
.form-group {
display: inline-block;
vertical-align: middle;
margin-left: 10px;
margin-bottom: 6px;
width: 23%;
}
</style>
>>>>>>> a438ff18b14e8bd158d59820ccab5b0cbec83097
<div class='row title_content'>
<div class='col-md-4 col-xs-4'>
<h1 class='page_txt'><?php echo $page_name;?></h1>
</div>
<<<<<<< HEAD
<div class='col-md-8 col-xs-8'>
<ol class="breadcrumb">
<?php echo $breadcrumb; ?>
</ol>
</div>
</div>
<?php
if($fliter_list){
?>
<div id="search_filter_div" class='search_filter' style="display:none;">
<div style="max-height:250px;overflow: auto;">
<?php echo $filter_table;?>
</div>
<div class="row" style="margin:0px;margin-top:15px;">
<div class="col-md-6" style='text-align:left;'>
<a class="btn btn-xs btn-danger" id="clear_search"> Clear All</a>
</div>
<div class="col-md-6" style='text-align:right;'>
<a class="btn btn-xs btn-primary" id="search_close"> Close </a>
</div>
</div>
</div>
<?php
}
?>
<div class="row" style='margin:0px;overflow:auto;'>
<div class='col-md-12' style='padding:8px;min-height: 400px;'>
<table id="table" class='table table-striped table-hover' style='width:100% !important;'></table>
</div>
</div>
<script type="text/javascript">
$(document).ready(function (){
$('.modal-dialog').draggable({ handle: ".modal-header" });
// PAGE INFO PROCESS QUERY ERROR THROWING
var module_sts = <?php echo json_encode($module_sts); ?>;
if(!module_sts){
toastr.warning('Index Info Query Process Error...!');
return false;
}
// PAGE INFO PROCESS QUERY ERROR THROWING
//NEW UPDATION FOR PICKLIST AND AUTOCOMPLETE
var pick_list = <?php echo json_encode($pick_list); ?>;
var table_head = '<?php echo $column_count; ?>';
if(parseInt(table_head) <= 1){
toastr.warning('Please Add Atleast One Table View For This Module In Screen Settings !!!');
return false;
}
var freeze_list = <?php echo json_encode($freeze_list); ?>;
$table = $('#table').DataTable( {
processing: true,
serverSide: true,
serverMethod: 'post',
lengthMenu: [[10,25,50,100,500,1000,-1],[10,25,50,100,500,1000,"All"]],
fixedColumns:{leftColumns: freeze_list['left_freeze']},
scrollX:true,
//fixedHeader: true,
language:{
lengthMenu:"<span style='margin-top:8px;margin-left:10px;'>Display</span> _MENU_ <span style='margin-top:8px;'>Records</span>",
searchPlaceholder: "Search records",
search: "",
},
ajax:{
'url': '<?php echo $search_url; ?>',
'data': function(data){
<?php echo $table_map_list;?>
},
beforeSend: function(){
$('.dataTables_processing').html('<span style="color:#CC3366;"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</span>');
},
},
columns: [{
title:'<input type="checkbox" name="select_all" class="select_all">',
data: '<?php echo $prime_id; ?>',
type: 'html',
orderable: false,
className: 'select-checkbox',
searchable:false,
width:'1%',
render:function (value) {
return '<input type="checkbox" value="'+value+'" name="select_one" class="select_one">';
}
},
<?php
foreach($table_head as $table){
$label_name = $table->label_name;
$view_name = $table->view_name;
$field_type = (int)$table->field_type;
$date_type = $table->date_type;
if($field_type === 4){
if((int)$date_type === 1){
echo "{title:'$view_name',data: '$label_name',type: 'date',visible:true,
render:function(value) {
if (value === '' || value === '0000-00-00' || value === null || value === '1970-01-01') return '';
return moment(value).format('DD/MM/YYYY');
}
},\n";
}else{
echo "{title:'$view_name',data: '$label_name',type: 'date',visible:true,
render:function(value) {
if (value === '' || value === '0000-00-00' || value === null || value === '1970') return '';
return value;
}
},\n";
}
}else
if($field_type === 13){
echo "{title:'$view_name',data: '$label_name',type: 'date',visible:true,
render:function(value) {
if(value){
if (value === '' || value === '0000-00-00' || value === null || value === '1970-01-01 05:30:00') return '';
return moment(value).format('DD/MM/YYYY HH:mm:ss');
}else{
return '';
}
}
},\n";
}else
if(($field_type === 5)||($field_type === 9)){
echo "{title:'$view_name',data: '$label_name',type: 'date',visible:true,
render:function(value) {
if('$label_name' in pick_list){
if(value in pick_list['$label_name']['array_list']){
if(value === '0' || value === ''){
return '';
}else{
return pick_list['$label_name']['array_list'][value];
}
}else{
return value;
}
}else{
return value;
}
}
},\n";
}else
if($field_type === 6){
echo "{title:'$view_name',data: '$label_name',type: 'date',visible:true,
render:function(value) {
send_val = 'No';
if(value === '1'){ send_val = 'Yes'; }
return send_val;
}
},\n";
}else
if($field_type === 7){
echo "{title:'$view_name',data: '$label_name',type: 'date',visible:true,
render:function(value) {
if(value !== ''){
var rslt = '';
var multi_val = value.split(',');
var count = 0
$.each(multi_val,function(i){
count++;
var multi_key = multi_val[i];
if(multi_key in pick_list['$label_name']['array_list']){
if(count === 1){
rslt += pick_list['$label_name']['array_list'][multi_key];
}else{
rslt += ' , '+pick_list['$label_name']['array_list'][multi_key];
}
}
});
return rslt;
}else {
return '-';
}
}
},\n";
}else
if($field_type === 10){
$img = '<i class="fa fa-download" onclick="file_download(filepathleft@URL@filepathright)"></i>';
echo "{title:'$view_name',data: '$label_name',type: 'date',visible:true,sClass: 'center',
render:function(value) {
if(value !== ''){
var image = '$img';
image = image.replace('@URL@', value);
image = image.replace('filepathleft', '\'');
image = image.replace('filepathright', '\'');
if(value !== null){
return image;
}else{
return '';
}
}else{
return '';
}
}
},\n";
}else
if($field_type === 1 || $field_type === 8){
echo "{title:'$view_name',data: '$label_name',visible:true,
render:function(value) {
if(value){
var val = value.replace(/\~/g,'\"');
var val = val.replace(/\`/g,'\'');
var val = val.replace(/\^/g,'\&');
return val;
}else{
return '';
}
}
},\n";
}else{
echo "{title:'$view_name',data:'$label_name',visible:true,},\n";
}
}
?>
{title:'View',
data: '<?php echo $prime_id; ?>',
type: 'html',
render:function (value) {
//alert(value + '<?php echo $prime_id; ?>');
if (value === null) return '';
<?php
if($access_update === 1){
?>
return '<a class="btn btn-xs btn-edit view" data-btn-submit="Submit" title="Update <?php echo $page_name;?>" href="<?php echo $view_url;?>'+value+'" data_form="<?php echo $controller_name;?>"> <span class="fa fa-pencil-square-o"></span> Edit</a>';
<?php
}else{
?>
return '<a class="btn btn-xs btn-edit view" title="View <?php echo $page_name;?>" href="<?php echo $view_url;?>'+value+'" data_form="<?php echo $controller_name;?>"> <span class="fa fa-eye"></span> View</a>';
<?php
}
?>
}
}
],
});
$("<?php echo $input_ids;?>").bind('keyup change', function(e) {
$table.draw();
});
$("<?php echo $date_ids;?>").on("dp.hide",function (e) {
$table.draw();
});
var table_option = "<table><tr><td id='filters' style='padding:8px 2px;'></td><td id='export' style='padding:8px 2px;'></td></tr></table>";
$("#table_filter").append(table_option);
<?php
if($access_export === 1){
?>
var buttons = new $.fn.dataTable.Buttons(table, {
buttons: [{
extend: 'collection',
text: 'Export',
buttons: [
{extend:'copy',exportOptions:{modifier :{order:'index',page:'all',search:'none'},columns:':visible'}},
{extend:'csv',exportOptions:{modifier:{order:'index',page:'all',search:'none'},columns:':visible'}},
{extend:'excel',exportOptions:{modifier:{order :'index',page: 'all',search:'none'},columns:':visible'}},
{extend:'pdf',exportOptions:{modifier:{order :'index',page:'all',search:'none'},columns:':visible'}},
{extend:'print',exportOptions:{modifier:{order :'index',page:'all',search:'none'},columns:':visible',}},
]
}]
}).container().appendTo($('#export'));
<?php
}else{
?>
var buttons = "";
<?php
}
?>
var custom_filter = "<button class='btn btn-xs btn-edit fliter' id='search_filter'>Filter <i class='fa fa-filter' aria-hidden='true'></i></button>";
<?php
if($fliter_list){
?>
$("#filters").append(custom_filter);
<?php
}
?>
$(".buttons-collection").addClass("btn btn-xs btn-edit");
$('input[type=search]').addClass('form-control input-sm');
$("select[name='table_length']" ).addClass('form-control input-sm');
$("a.add").click(function(event){
event.preventDefault();
var action = $(this).attr('data-btn-submit');
var title = $(this).attr('title');
var control = $(this).attr('href');
var form_id = $(this).attr('data_form')+"_form";
view_form_data(action,title,control,form_id);
});
$("a.import").click(function(event){
event.preventDefault();
var action = $(this).attr('data-btn-submit');
var title = $(this).attr('title');
var control = $(this).attr('href');
var form_id = "save_import";
view_form_data(action,title,control,form_id);
});
$table.on('click','a.view',function(event){
event.preventDefault();
var action = $(this).attr('data-btn-submit');
var title = $(this).attr('title');
var control = $(this).attr('href');
var form_id = $(this).attr('data_form')+"_form";
view_form_data(action,title,control,form_id);
});
/* DELETE PROCESS - START*/
<?php
if($access_delete === 1){
?>
var delete_btn = "<button class='btn btn-xs btn-danger fliter' id='delete_btn' style='margin-top:7px' disabled='true'><i class='fa fa-trash' aria-hidden='true'></i> Delete</button>";
<?php
}else{
?>
var delete_btn = "";
<?php
}
?>
$("#table_length").prepend(delete_btn);
$("#table_length").css("display", "-webkit-inline-box");
$('.select-checkbox').on('click', "input[name='select_all']", function(){
if(this.checked) {
$('.select_one').prop('checked', true);
var delete_ids = [];
$.each($("input[name='select_one']:checked"), function(){
delete_ids.push($(this).val());
});
if(delete_ids.length > 0) {
$('#delete_btn').attr('disabled',false);
}else{
$('.select_all').prop('checked', false);
$('#delete_btn').attr('disabled',true);
}
}else{
$('.select_all').prop('checked', false);
$('.select_one').prop('checked', false);
$('#delete_btn').attr('disabled',true);
}
});
$table.on('change','.select_one',function(event){
var delete_ids = [];
$.each($("input[name='select_one']:checked"), function(){
delete_ids.push($(this).val());
});
if(delete_ids.length > 0) {
$('#delete_btn').attr('disabled',false);
}else{
$('#delete_btn').attr('disabled',true);
}
});
$("#delete_btn").click(function(event){
if(confirm("Are you sure. you want delete select records??")){
var delete_ids = [];
$.each($(".DTFC_LeftBodyWrapper").find("input[name='select_one']:checked"), function(){
delete_ids.push($(this).val());
});
//do ajax process
if(delete_ids){
$.ajax({
type: "POST",
url: '<?php echo site_url("$controller_name/delete"); ?>',
data:{delete_ids:delete_ids},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.message);
$('.select_all').prop('checked', false);
$('.select_one').prop('checked', false);
$('#delete_btn').attr('disabled',true);
$table.draw();
}else{
toastr.error(rslt.message);
}
}
});
}
}else{
$('.select_all').prop('checked', false);
$('.select_one').prop('checked', false);
$('#delete_btn').attr('disabled',true);
}
});
/* DELETE PROCESS - END*/
$table.on('click','tr td:not(:first-child, :nth-last-child(-n+'+freeze_list['right_freeze']+'))',function() {
var closest_row = $(this).closest('tr');
var data = $table.row(closest_row).data();
var prime_id = data['<?php echo $prime_id; ?>'];
var action = $("td > a").attr('data-btn-submit');
var title = $("td > a").attr('title');
var control = '<?php echo $view_url; ?>'+prime_id;
var form_id = $("td > a").attr('data_form')+"_form";
view_form_data(action,title,control,form_id);
});
$("#search_filter_div").hide();
$("#search_filter").click(function(){
$("#search_filter_div").toggle();
});
$("#search_close").click(function(){
$("#search_filter_div").toggle();
});
$("#clear_search").click(function(){
$('input').val('');
$('option').attr('selected', false);
$("#search_filter_div").toggle();
$table.draw();
$('.select2').select2({placeholder: '---- Select ----',});
});
$(function (){$(".datepicker").datetimepicker({format: 'DD-MM-YYYY',});});
$(".datepicker_time").datetimepicker({format: 'DD-MM-YYYY HH:mm:ss',});
$('.select2').select2({placeholder: '---- Select ----',});
});
function view_form_data(action,title,control,form_id){
$('.modal').modal({backdrop: 'static', keyboard: false});
$('.modal-body').html('<div style="text-align: center;padding:50px;color:#4b6fa2;"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Please wait processing....</div>');
$.ajax({
type: 'POST',
url: control,
dataType: "html",
success: function (response){
$('.modal-title').html('<h4 class="modal-title">'+title+'</h4>');
$('.modal-body').html(response);
var btn_info = '<a class="btn btn-danger" data-dismiss="modal" onclick="close_formfun()">Close</a>';
if(action === "Submit"){
btn_info += '<button class="btn btn-primary" id="submit" style="margin-left: 15px;">Submit</button>';
}
btn_info = '<div class="col-md-12" style="background-color:#FFFFFF;padding: 10px 20px; text-align: right; border-top: 1px solid #e5e5e5;">'+btn_info+'</div>';
$('#'+form_id).append(btn_info);
}
});
}
function close_formfun(){
$table.draw();
$('.select2').select2({placeholder: '---- Select ----',});
}
function file_download(path){
path = path.replace('[','');
path = path.replace(']','');
var split_path = path.split('/');
var file_name = split_path[split_path.length - 1];
var link = document.createElement('a');
link.href = path;
link.download = file_name;
link.click();
link.remove();
}
=======
</div>
<div>
<div class='col-md-12'style='padding:15px 0px;'>
<div class="form-inline">
<?php
echo form_open($controller_name.'/view_data',array('id'=>'challan_form')); ?>
<div class="form-group">
<?php
echo form_label($this->lang->line('category'), 'category', array('class' => 'required'));
echo form_dropdown(array( 'name' => 'category', 'multiple id' => 'category', 'class' => 'form-control input-sm select2'), $category_list);
echo "<label><input name='sel_all' id='sel_all' type='checkbox'> Select All</label>";
?>
</div>
<div class="form-group">
<?php
echo form_label("Process Month", 'process_month', array('class' => 'required'));
echo form_input(array('name' => 'process_month','id' => 'process_month','class' => 'form-control input-sm datepicker','value'=>''));
?>
</div>
<div class="form-group">
<?php
$process_list = array(""=>"Select Process Type","1"=>"Entry","2"=>"View","3"=>"Delete");
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_list);
?>
</div>
<div class="form-group" id='challan_div' style="display:none;">
<?php
echo form_label("Challan", 'challan_list', array('class' => 'required'));
echo form_dropdown(array("name" =>'challan_list',"id" =>'challan_list',"class" =>'form-control input-sm'),$challan_list);
?>
</div>
<!--<div class="form-group">
<?php
echo form_label("Bank Name", 'bank_name', array('class' => 'required'));
echo form_dropdown(array("name" =>'bank_name',"id" =>'bank_name',"class" =>'form-control input-sm select2'),$bank_list);
?>
</div>
<div class="form-group">
<?php
echo form_label("Cheque/DD", 'cheque_no', array('class' => 'required'));
echo form_input(array('name' => 'cheque_no','id' => 'cheque_no','class' => 'form-control input-sm','value'=>''));
?>
</div>
<div class="form-group">
<?php
$book_entry = array(""=>"","1"=>"Yes","2"=>"No");
echo form_label("Book Entry", 'book_entry', array('class' => 'required'));
echo form_dropdown(array("name" =>'book_entry',"id" =>'book_entry',"class" =>'form-control input-sm'),$book_entry);
?>
</div> -->
<div class="form-group">
<button class='btn btn-primary btn-sm' id="view_btn">Submit</button>
</div>
<?php echo form_close(); ?>
</div>
</div>
<div class="col-md-12" style="margin-top:10px;padding:10px;background-color: #f2f2f2;">
<table id='emp_table' class='table table-hover'></table></div>
</div>
</div>
<div id="myModal" style="display: none; padding: 15px 0px;">
<div class="form-group">
<?php
echo form_open($controller_name.'/save_data',array('id'=>'modal_form')); ?>
<?php
echo form_label("Challan Date", 'challan_date', array('class' => 'required'));
echo form_input(array('name' => 'challan_date','id' => 'challan_date','class' => 'form-control input-sm datepickers','value'=>''));
?>
</div>
<div class="form-group">
<?php
echo form_label("Challan Number", 'challan_no', array('class' => 'required'));
echo form_input(array('name' => 'challan_no','id' => 'challan_no','class' => 'form-control input-sm','value'=>''));
?>
</div>
<div class="form-group" style="display:none">
<?php
echo form_input(array('name' => 'challan_no',"type"=>"hidden",'id' => 'sel_id','value'=>''));
?>
</div>
<div class="form-group">
<?php
echo form_label("Bank Name", 'bank_name', array('class' => 'required'));
echo form_dropdown(array("name" =>'bank_name',"id" =>'bank_name',"class" =>'form-control input-sm select2'),$bank_list);
?>
</div>
<div class="form-group">
<?php
echo form_label("Cheque/DD", 'cheque_no', array('class' => 'required'));
echo form_input(array('name' => 'cheque_no','id' => 'cheque_no','class' => 'form-control input-sm','value'=>''));
?>
</div>
<div class="form-group">
<?php
$book_entry = array(""=>"--Select--","1"=>"Yes","2"=>"No");
echo form_label("Book Entry", 'book_entry', array('class' => 'required'));
echo form_dropdown(array("name" =>'book_entry',"id" =>'book_entry',"class" =>'form-control input-sm'),$book_entry,"2");
?>
</div>
<div class="form-group">
<?php
echo form_label("Total Tax Amount", 'tot_sum', array('class' => 'required'));
echo form_input(array('name' => 'tot_sum','id' => 'tot_sum','class' => 'form-control input-sm','value'=>'', "readonly"=>'readonly'));
?>
</div>
<div class="form-group" style="display:none">
<?php
echo form_input(array('name' => 'proc_mnth',"type"=>"hidden",'id' => 'proc_mnth','value'=>''));
?>
</div>
<div class="form-group" style="display:none">
<?php
echo form_input(array('name' => 'role',"type"=>"hidden",'id' => 'role','value'=>''));
?>
</div>
<div class="form-group" id="btn_div">
</div>
<?php
echo form_close(); ?>
</div>
<script type="text/javascript">
$(document).ready(function (){
//Date Picker
$(function(){
$(".datepicker").datetimepicker({
format: 'MM-YYYY',
});
$(".datepickers").datetimepicker({
format: 'DD-MM-YYYY',
});
});
$(function(){
$('.select2').select2({
placeholder: '---- Select ----'
});
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
});
$('#challan_form').submit(function(event){ event.preventDefault(); }).validate({
rules:{
category:"required",
process_month:"required",
process_type:"required",
challan_list:"required",
},
submitHandler: function (form){
$("#view_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#view_btn').attr('disabled','disabled');
var category = $("#category").val();
var process_month = $("#process_month").val();
var challan_list = $("#challan_list").val();
var process_type = $("#process_type").val();
if(process_type){
process_type = process_type;
}else{
process_type = "";
}
if(process_type === ""){
toastr.error("Please Select Process Type");
}
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/view_data"); ?>',
data: {category:category,process_month:process_month,challan_list:challan_list,process_type:process_type},
success: function(data){
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.message);
$('#view_btn').attr('disabled',false);
$("#view_btn").html("Submit");
table_draw(rslt,process_month,category);
}else{
toastr.error(rslt.message);
$('#view_btn').attr('disabled',false);
$("#view_btn").html("Submit");
}
},
});
}
});
$('#process_type').on('change',function(){
var process_type = $('#process_type').val();
if(process_type === "1"){
$('#challan_div').hide();
}else{
$('#challan_div').show();
}
})
$('#sel_all').click(function(){
if($('#sel_all').is(':checked') ){
$('#category > option').prop('selected','selected');
$('#category').trigger('change');
}else{
$('#category > option').removeAttr('selected');
$('#category').trigger('change');
}
$('#category option').filter(function(){
return !this.value || $.trim(this.value).length == 0;
}).remove();
});
});
function save_popup(){
var process_month = $('#process_month').val();
var category = $('#category').val();
var sel_id = [];
$.each($(".select_one:checked"), function() {
if ($(this).val()) {
sel_id.push($(this).val());
}
});
var table = $('#emp_table').DataTable();
var sum = 0;
$.each($(".select_one:checked"), function() {
var value = parseFloat($(this).closest('tr').find('td:eq(3)').text());
if (!isNaN(value)) {
sum += value;
}
});
// $('#tot_sum').html(sum);
$('#tot_sum').val(sum);
$('#sel_id').val(sel_id);
var rslt = $('#myModal').show();
$('.modal').modal({backdrop: 'static', keyboard: false});
$('.modal-body').html('<div style="text-align: center;padding:50px;color:#4b6fa2;"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Please wait processing....</div>');
$('.modal-title').html('<h4 class="modal-title">Challan Entry</h4>');
$('.modal-body').html(rslt);
// $('#btn_div').html('<button id="submit_btn" onclick="popup_submit('+process_month+',"'+category+'")" class="btn btn-sm btn-success" style="margin:10px;">Submit</button><button type="button" class="btn btn-sm btn-danger" data-dismiss="modal">Close</button>');
$('#btn_div').html('<button id="submit_btn" onclick="popup_submit(\''+process_month+'\',\''+category+'\')" class="btn btn-sm btn-success" style="margin:10px;">Submit</button><button type="button" class="btn btn-sm btn-danger" data-dismiss="modal">Close</button>');
}
function table_draw(rslt,process_month,category){
$table = $('#emp_table').DataTable({
destroy: true,
scrollY: '500px',
lengthMenu: [[-1], ['All']],
language: {
lengthMenu: "<span style='margin-top:8px;margin-left:10px;'>Display</span> _MENU_ <span style='margin-top:8px;'>Records</span>",
searchPlaceholder: "Search records",
search: "",
},
data: rslt.table_data,
columns: [
{
title: '<input type="checkbox" name="select_all" class="select_all">',
data: '<?php echo $prime_id; ?>',
type: 'html',
orderable: false,
className: 'select-checkbox',
searchable: false,
width: '1%',
render: function (value) {
return '<input type="checkbox" value="'+value+'" name="select_one" class="select_one">';
}
},
{ title: "Employee Code", data: "employee_code" },
{ title: "Employee Name", data: "emp_name" },
{ title: "Monthly Tax", data: "monthly_tds" },
{ title: "Education Cess", data: "edu_cess" },
{ title: "Total Tax", data: "total_tax" }
],
});
$("#emp_table_length").css("display", "-webkit-inline-box");
$('.select-checkbox').on('click', "input[name='select_all']", function(){
if(this.checked) {
$('.select_one').prop('checked', true);
$("#save_btn").removeAttr("disabled");
}else{
$('.select_one').prop('checked', false);
$("#save_btn").attr('disabled','disabled');
}
var sel_id = [];
$.each($(".select_one:checked"), function() {
if ($(this).val()) {
sel_id.push($(this).val());
}
});
});
$table.on('change','.select_one',function(event){
var sel_id = [];
$.each($("input[name='select_one']:checked"), function(){
if($(this).val()){
sel_id.push($(this).val());
}
});
if(sel_id.length > 0){
$("#save_btn").removeAttr("disabled");
}else{
$("#save_btn").attr('disabled','disabled');
}
});
if(rslt.table_name === "process"){
var submit_btn = "<button class='btn btn-primary btn-xs' id='save_btn' onclick='save_popup()' style='margin-left:5px;'; disabled='true'>Save</button>";
$("#emp_table_length").append(submit_btn);
}
$('input[type=search]').addClass('form-control input-sm');
}
function popup_submit(process_month,category){
$("#save_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_btn').attr('disabled', 'disabled');
// var category = $("#category").val();
// var process_month = $("#process_month").val();
var challan_date = $("#challan_date").val();
var challan_no = $("#challan_no").val();
var bank_name = $("#bank_name").val();
var cheque_no = $("#cheque_no").val();
var book_entry = $("#book_entry").val();
if(challan_date === "" || challan_no === "" || bank_name==="" || cheque_no === "" || book_entry === ""){
toastr.error("Please Fill All Fields");
return false;
}
var sel_id = $('#sel_id').val();
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_data"); ?>',
data: {
category: category,
process_month: process_month,
challan_date: challan_date,
challan_no: challan_no,
bank_name: bank_name,
cheque_no: cheque_no,
book_entry: book_entry,
sel_id:sel_id,
},
success: function (data) {
var rslt = JSON.parse(data);
if (rslt.success) {
table_draw(rslt,process_month,category);
toastr.success(rslt.message);
$('#save_btn').attr('disabled',"disabled");
$("#save_btn").html("Save");
$('.modal').modal('hide');
$('.select_all').prop('checked', false);
$('#challan_date,#challan_no').val('');
$('#bank_name,#cheque_no').val('');
} else {
toastr.error(rslt.message);
$('#save_btn').attr('disabled',"disabled");
$("#save_btn").html("Save");
$('.modal').modal('hide');
}
},
});
}
>>>>>>> a438ff18b14e8bd158d59820ccab5b0cbec83097
</script>
<?php $this->load->view("partial/footer"); ?>