File: /home/cafsindia/cpaqua.cafsinfotech.in/application/views/challan_entry/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";
$prime_id = "employee_code";
$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 */
?>
<style>
.form-group {
display: inline-block;
vertical-align: middle;
margin-left: 10px;
margin-bottom: 6px;
width: 23%;
}
</style>
<div class='row title_content'>
<div class='col-md-4 col-xs-4'>
<h1 class='page_txt'><?php echo $page_name;?></h1>
</div>
</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'));
?>
</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_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'),$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" id="btn_div">
</div>
</div>
<script type="text/javascript">
$(document).ready(function (){
//Date Picker
$(function(){
$(".datepicker").datetimepicker({
format: 'MM-YYYY',
});
});
//$("document").on("hidden.bs.modal", function () {
$(document).on("click",".close",function() {
close_popup();
});
$(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");
}
if(process_type === "3"){
if(confirm("Are you sure. you want delete select records??")){
}else{
toastr.error("Delete Cancelled");
$('#view_btn').attr('disabled',false);
$("#view_btn").html("Submit");
return false;
}
}
//Encryption
var key = '<?php echo $key; ?>';
var data = {category:category,process_month:process_month,challan_list:challan_list,process_type:process_type};
var encData = encrypt(key,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/view_data"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data){
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.message);
$('#view_btn').attr('disabled',false);
$("#view_btn").html("Submit");
// get_challan();
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{
get_challan();
$('#challan_div').show();
}
})
$('#process_month').on("dp.hide",function(e){
get_challan();
});
$('#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 FOR GET CHALLAN NO BASED ON PROCESS MONTH
function get_challan(){
var process_month = $('#process_month').val();
var process_type = $('#process_type').val();
if(process_month && process_type && process_type !== 1){
//Encryption
var key = '<?php echo $key; ?>';
var data = {process_month:process_month};
var encData = encrypt(key,data);
$.ajax({
type: "POST",
url: '<?php echo site_url("$controller_name/get_challan_list"); ?>',
data:encData,
contentType: 'text/plain',
beforeSend: function () {
$("#challan_list").next('span').attr('id', 'challan_list_span');
$('#challan_list_span').html('<span style="color:#CC3366;"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</span>');
},
success: function(data){
var rslt = JSON.parse(data);
if(rslt.success){
$('#challan_list_span').empty();
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
//dropdownParent: $('.modal-dialog')
});
$("#challan_list").empty();
var challan_option ="<option value=''>---- Select Challan ----</option>';";
$.each(rslt.list_data, function( key, value ) {
challan_option += '<option value="' + value['challan_no'] + '">' + value['challan_no'] + '</option>';
});
$('#challan_list').append(challan_option);
}else{
if(process_type !== "1"){
$("#challan_list").empty();
toastr.error(rslt.message);
var challan_option ="<option value=''>---- Select Challan ----</option>';";
$('#challan_list').append(challan_option);
}
}
},
});
}
}
function save_popup(process_month,category){
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);
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" onclick="close_popup()">Close</button>');
$(function(){
$(".datepickers").datetimepicker({
format: 'DD-MM-YYYY',
});
});
}
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: "Tds", data: "tds" }
],
});
$("#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('"+process_month+"','"+category+"') 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){
var sel_id = [];
$.each($(".select_one:checked"), function() {
if ($(this).val()) {
sel_id.push($(this).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;
}
$("#submit_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#submit_btn').attr('disabled', 'disabled');
//Encryption
var key = '<?php echo $key; ?>';
var 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};
var encData = encrypt(key,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_data"); ?>',
data:encData,
contentType: 'text/plain',
success: function (data) {
var rslt = JSON.parse(data);
if (rslt.success){
table_draw(rslt,process_month,category);
toastr.success(rslt.message);
$('#submit_btn').attr('disabled',"disabled");
$("#submit_btn").html("Submit");
$('.modal').modal('hide');
$('.select_all,.select_one').prop('checked', false);
$('#challan_date,#challan_no,#cheque_no').val('');
$('#bank_name').find('option').prop('selected', false);
// get_challan();
}else{
toastr.error(rslt.message);
$('#save_btn').attr('disabled',"disabled");
$("#save_btn").html("Save");
$('.modal').modal('hide');
$('.select_all,.select_one').prop('checked', false);
$('#challan_date,#challan_no,#cheque_no').val('');
$('#bank_name').find('option').prop('selected', false);
}
},
});
}
function close_popup(){
$('#challan_date,#challan_no,#cheque_no').val('');
$('#bank_name').find('option').prop('selected', false);
}
</script>
<?php $this->load->view("partial/footer"); ?>