File: /home/cafsindia/.trash/application.1/views/twenty_four_q_mapping/manage.php
<?php
$this->load->view("partial/header");
$access_data = $this->session->userdata('access_data');
$page_name = ucwords(str_replace("_"," ",$controller_name));
$uniqueId = "prime_".$controller_name."_id";
?>
<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 class="loader" style="text-align:center">
<span style="color:#CC3366;font-size:large"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading..</span>
</div>
<div class="row" style='margin-bottom:0px;'>
<div class="col-md-12">
<form id='form_24q_map'>
<div style="margin:20px !important; padding:15px;">
<?php
$temp_array = array();
$form24q_mapping_arr = array();
foreach ($form24q_temp_result as $form24q_temp_rslt){
$prime_form_sixteen_id = $form24q_temp_rslt->prime_form_sixteen_id;
$form24q_value = $form24q_temp_rslt->form24q_value;
$temp_array[$prime_form_sixteen_id] = $form24q_value;
$form24q_mapping_arr[] = $form24q_temp_rslt->form24q_mapping;
}
//section 10 option list waiting clarifications
$tr_line = "";
$i = 0;
$tax_cal_arr = array();
$tax_cal_arr =array('rebate_amt'=>'Rebate','edu_cess'=>'Education Cess','total_tax_on_income'=>'Tax on total Income','tax_deducted'=>'Tax Deducted At Source u/s 192(1)','tax_amt'=>'Tax Payable/Refundable','final_tax_amt'=>'Per Month Value','emp_code'=>'Employee Code','emp_name'=>'Employee Name','surcharge_charge'=>'Tax Payable and Surcharge thereon','gross_17a'=>'Salary as per provisions contained in sec.17(1)','gross_17b'=>'Value of perquisites u/s 17(2)[as per Form No 12BA]','gross_17c'=>'profits in lieu of salary under section 17(3[as per Form No 12BA)','17_gross_total'=>'Gross Total[17(1),17(2),17(3)]');
foreach ($form_sixteen_head_result as $form_sixteen_head){
$form_sixteen_id = $form_sixteen_head->prime_form_sixteen_id;
$tax_act = $form_sixteen_head->tax_act;
$tax_section_head = $form_sixteen_head->tax_section_head;
$option_val = $temp_array[$form_sixteen_id];
$form24q_mapping_val = $form24q_mapping_arr[$i];
$option_10 = "<option value=''>---- Select Sections ----</option>";
$option_16 = "<option value=''>---- Select Sections ----</option>";
$option_80 = "<option value=''>---- Select Sections ----</option>";
$oth_option = "<option value=''>---- Select Sections ----</option>";
$option_6a = "<option value=''>---- Select Sections ----</option>";
$tax_cal_option = "<option value=''>---- Select Sections ----</option>";
foreach($tax_sec_10_result as $sec10_rslt){
$tax_act_details = $sec10_rslt->tax_act_details;
$tax_subsection_column = $sec10_rslt->tax_subsection_column;
if($option_val === $tax_subsection_column){
$option_10_sel = "selected";
}else{
$option_10_sel = "";
}
$option_10 .= "<option value='$tax_subsection_column' $option_10_sel>$tax_act_details</option>";
}
foreach($tax_sec_16_result as $sec16_rslt){
$tax_act_details = $sec16_rslt->tax_act_details;
$tax_subsection_column = $sec16_rslt->tax_subsection_column;
if($option_val === $tax_subsection_column){
$option_16_sel = "selected";
}else{
$option_16_sel = "";
}
$option_16 .= "<option value='$tax_subsection_column' $option_16_sel>$tax_act_details</option>";
}
foreach($tax_sec_80_result as $sec80_rslt){
$tax_act_details = $sec80_rslt->tax_act_details;
$tax_subsection_column = $sec80_rslt->tax_subsection_column;
if($option_val === $tax_subsection_column){
$option_80_sel = "selected";
}else{
$option_80_sel = "";
}
$option_80 .= "<option value='$tax_subsection_column' $option_80_sel>$tax_act_details</option>";
}
foreach($tax_sec_6a_result as $sec6a_rslt){
$tax_act_details = $sec6a_rslt->tax_act_details;
$tax_subsection_column = $sec6a_rslt->tax_subsection_column;
if($option_val === $tax_subsection_column){
$option_6a_sel = "selected";
}else{
$option_6a_sel = "";
}
$option_6a .= "<option value='$tax_subsection_column' $option_6a_sel>$tax_act_details</option>";
}
foreach($tax_cal_arr as $col_name => $field_name){
$tax_col = $field_name;
$tax_subsection_column = $col_name;
$sel_opt = "";
$tax_cal_option .= "<option value='$tax_subsection_column' $sel_opt>$tax_col</option>";
}
foreach($oth_sec_result as $oth_rslt){
$income_description = $oth_rslt->income_description;
$other_income_column = $oth_rslt->other_income_column;
if($option_val === $other_income_column){
$oth_option_sel = "selected";
}else{
$oth_option_sel = "";
}
$oth_option .= "<option value='$other_income_column' $oth_option_sel>$income_description</option>";
}
$input_line = "<input id='form_24q_$form_sixteen_id' name='form_24q_$form_sixteen_id' value ='0' type='hidden'/></th><th>";
if($tax_section_head === "taxsec_1"){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$option_10</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}elseif($tax_section_head === "taxsec_2"){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$option_16</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}elseif($tax_section_head === "taxsec_3"){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$option_80</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}elseif($tax_section_head === "taxsec_4"){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$option_6a</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}elseif($tax_section_head === "otherin_1"){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$oth_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 1){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 2){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 3){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 4){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 5){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 6){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 8){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 21){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 22){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 23){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 27){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 28){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 29){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 32){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 33){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 34){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 36){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 37){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 38){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 52){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 53){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 54){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 55){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 56){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 57){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 58){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 59){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
if($form_sixteen_id == 60){
$area_id ='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' class='form-control input-sm select2 dropdown' onchange=mapping_change_fun(id,'$area_id') multiple>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id'></textarea>";
}
$form_24_q_input_line = "<input id='24q_$form_sixteen_id' name='form_24q_mapping[]' class='form-control input-sm' value ='".$form24q_mapping_val."'/>";
$tr_line .= "<tr><td>".$tax_act."</td><td style='width:10%'><div class='form-group'>$input_line</div></td><td>".$form_24_q_input_line."</td></tr>";
$i++;
}
$table_info = "<table class='table table-bordered' id ='twenty4q'>
<thead>
<tr>
<th style=' text-align:center;'>Tax Act</th>
<th style=' text-align:center;'>Mapping</th>
<th style=' text-align:center;'>column Map</th>
<th style=' text-align:center;'>24Q Mapping</th>
</tr>
</thead>
<tbody>
$tr_line
</tbody>
</table>";
echo $table_info;
?>
</form>
</div>
</div>
<script type="text/javascript">
$(document).ready(function (){
select_call();
fetch_data();
$("#twenty4q").DataTable({
processing : true,
serverSide : false,
destroy : true,
paging : true,
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 : "",
processing : '<div style="text-align: center; padding: 50px;color:#4b6fa2;z-index:999999999;"><i class="fa fa-spinner fa-spin fa-2x fa-fw"></i><br/>Loading...</div>',
}
});
//CALL SELECT2 -> DATATABLE NEXT PAGE.
$("#twenty4q").on('draw.dt', function(){
select_call();
});
$('input[type=search]').addClass('form-control input-sm');
$("select[name='table_length']" ).addClass('form-control input-sm');
$("#twenty4q_length").append(`<button class='dt-button buttons-collection btn btn-xs btn-edit' id="submit">Submit</button>`);
$('.loader').hide();
$("#form_24q_map").validate({
submitHandler: function(form){
$("#submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#submit').attr('disabled','disabled');
var form_24q_data = JSON.stringify($("#form_24q_map").serializeArray());
var form_24q_mapping = $("input[name='form_24q_mapping[]']")
.map(function(){return $(this).val();}).get();
//Encryption
var key = '<?php echo $key; ?>';
var data = {form_24q_data:form_24q_data,form_24q_mapping:form_24q_mapping};
var encData = encrypt(key,data);
$.ajax({
type : "POST",
url : '<?php echo site_url($controller_name . "/save_mapping_data"); ?>',
data:encData,
contentType: 'text/plain',
success : function(data){
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.msg);
}
$('#submit').attr('disabled',false);
$("#submit").html("Submit");
}
});
}
});
});
//DROPDOWN ONCHANGE
function mapping_change_fun(sel_id, text_area_id) {
var select_value = $.trim($("#" + sel_id).val());
var text_area = $("#" + text_area_id);
text_area.val('');
let res = select_value.replace(/,/g, "+");
text_area.val(res);
var selected_val = select_value.split(',');
$("select").not("#" + sel_id).each(function(){
var dropdown_val = $(this).val();
if(Array.isArray(dropdown_val)){
for(var i = 0; i < dropdown_val.length; i++){
if(selected_val.includes(dropdown_val[i])){
$("#" + sel_id).find("option[value='" + dropdown_val[i] + "']").prop("selected", false);
$("#" + sel_id).trigger('change');
toastr.warning("This option is already selected in another dropdown. Please choose another option.");
return false;
}
}
}
});
}
//ONLOAD DATA FETCH
function fetch_data(){
$.ajax({
type : "POST",
url : '<?php echo site_url($controller_name."/fetch_data"); ?>',
success : function(data){
var rslt = JSON.parse(data);
if(rslt.success){
rslt.form24.forEach((item, index) => {
if(item.form24q_value !== ''){
var values = item.form24q_value.split('+');
$("#"+item.form24q_key).val(values).trigger('change');
}
var form24q_mapping = item.form24q_mapping;
var key = item.form24q_key.replace('form_', '');
$("#"+key).val(form24q_mapping);
});
}
}
});
}
//SELECT2
function select_call(){
$(function(){
$('.select2').select2({
placeholder: '---- Select ----',
});
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
});
}
</script>
<style>
#twenty4q_length > label{
margin-right: 15px;
}
.select2-container {
width: 98% !important;
}
</style>
<?php $this->load->view("partial/footer"); ?>