File: /home/cafsindia/.trash/application_bkold/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";
?>
<script type="text/javascript">
$(document).ready(function (){
$("#form_24q_map").validate({
rules: {
//category : "required",
},
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();
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_mapping_data"); ?>',
data:{form_24q_data:form_24q_data,form_24q_mapping:form_24q_mapping},
success: function (data) {
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.msg);
}
$('#submit').attr('disabled',false);
$("#submit").html("Submit");
}
});
}
});
});
function mapping_change_fun(sel_id,text_area_id){
var select_value = $.trim($("#"+sel_id).val());
var text_area = $("#"+text_area_id);
var text_area_val = $("#"+text_area_id).val();
selected_component = select_value+"+";
if(text_area_val.indexOf(select_value) != -1){
toastr.warning('Input Column Already Exist');
}else{
text_area.val(text_area.val() + selected_component);
}
}
</script>
<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="row" style='margin-bottom:0px;'>
<div class="col-md-12">
<form id='form_24q_map'>
<div style="margin:20px !important; padding:15px;background-color: #f2f2f2;">
<?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='0'>---- Select Sections ----</option>";
$option_16 = "<option value='0'>---- Select Sections ----</option>";
$option_80 = "<option value='0'>---- Select Sections ----</option>";
$oth_option = "<option value='0'>---- Select Sections ----</option>";
$option_6a = "<option value='0'>---- Select Sections ----</option>";
$tax_cal_option = "<option value='0'>---- 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>";
}
// echo '<pre>';
// print_r($tax_cal_option); die;
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' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$option_10</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}elseif($tax_section_head === "taxsec_2"){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$option_16</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}elseif($tax_section_head === "taxsec_3"){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$option_80</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}elseif($tax_section_head === "taxsec_4"){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$option_6a</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}elseif($tax_section_head === "otherin_1"){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$oth_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 1){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 2){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 3){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 4){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 5){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 6){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 8){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 21){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 22){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 23){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 27){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 28){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 29){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 32){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 33){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 34){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 36){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 37){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 38){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 52){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 53){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 54){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 55){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 56){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 57){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 58){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 59){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
if($form_sixteen_id == 60){
$area_id='field_column_'.$form_sixteen_id;
$input_line = "<select id='form_24q_$form_sixteen_id' style='width:430px; margin-left:50px;' class='form-control input-sm select2' onchange=mapping_change_fun(id,'$area_id')>$tax_cal_option</select></th><th><textarea class='form-control' name='form_24q_$form_sixteen_id' id='field_column_$form_sixteen_id' style='width:300px;'></textarea>";
}
$form_24_q_input_line = "<input id='24_q_$form_sixteen_id' name='form_24q_mapping[]' class='form-control input-sm' value ='".$form24q_mapping_val."'/>";
$tr_line .= "<tr><td>".$tax_act."</td><td>$input_line</td><td>".$form_24_q_input_line."</td></tr>";
$i++;
}
$table_info = "<table class='table table-bordered'>
<thead>
<tr>
<th style='width:480px; text-align:center;'>Tax Act</th>
<th style='max-width:200px; text-align:center;'>Mapping</th>
<th style='width:200px; text-align:center;'>column Map</th>
<th style='width:120px; text-align:center;'>24Q Mapping</th>
</tr>
</thead>
<tbody>
$tr_line
</tbody>
</table>";
echo $table_info;
?>
</div>
<div class="form-group" style="text-align:center;">
<button class='btn btn-primary btn-sm' id="submit">Submit</button>
</div>
</form>
</div>
</div>
<?php $this->load->view("partial/footer"); ?>