File: /home/cafsindia/uds.cafsinfotech.in/application/views/report_setting/form.php
<style>
.sortable {list-style-type:none;margin:0;padding:0;width: auto;}
.sortable li{margin: 2px 20px 15px 0; padding: 8px; width: 100%; height: auto; font-size: inherit; box-shadow: 0 2px 2px 0 rgba(0,0,0,0.14), 0 3px 1px -2px rgba(0,0,0,0.12), 0 1px 5px 0 rgba(0,0,0,0.2); background-color: #FFFFFF; border: 0px; border-radius: 2px; cursor: pointer;display: inline-block;}
.sortable_width li{width: 23% !important;}
</style>
<ul class="nav nav-tabs" data-tabs="tabs">
<li class="active" role="presentation">
<a data-toggle="tab" href="#report_base">Basic Information</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#add_column_view">Add Column View</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#total_sum_view">Total Column Sum</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#report_tab_view">Report Table View</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#report_tab_join">Report Table Join</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#report_tab_where">Report Table Where</a>
</li>
</ul>
<div class="tab-content">
<div class="tab-pane fade in active" id="report_base">
<?php echo form_open('report_setting/report_save/' . $view_id,array('id'=>'report_save','class'=>'form-inline')); ?>
<div class="form-group">
<?php
$report_menu_val = $report_data->report_menu;
$date_filter_list = array(""=>"-- Select Type--",1=>"Required",2=>"Not Required");
echo form_label("Report Menu", 'report_menu', array('class' => 'required'));
echo form_dropdown(array('name' => 'report_menu','id' =>'report_menu','class' => 'form-control input-sm'),$report_menu_list,$report_menu_val);
?>
</div>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_report_setting_id', 'id'=>'prime_report_setting_id', 'type'=>'Hidden','value'=>$report_data->prime_report_setting_id));
echo form_label("Report Name", 'report_name', array('class' => 'required'));
echo form_input(array( 'name' => 'report_name', 'id' => 'report_name', 'class' => 'form-control input-sm', 'placeholder'=>"Report Name",'value' => $report_data->report_name));
?>
</div>
<div class="form-group">
<?php
$report_for_val = "";
if($report_data->report_for){
$report_for_val = explode(",",$report_data->report_for);
}
echo form_label("Report For", 'report_for', array('class' => 'required'));
echo form_dropdown(array('name' => 'report_for[]','multiple id' =>'report_for','class' => 'form-control input-sm select2'), $report_for_list,$report_for_val);
echo "<label><input name='all_category_select' id='all_category_select' type='checkbox'> Select All</label>";
?>
</div>
<div class="form-group">
<?php
$table_info_val = "";
if($report_data->table_info){
$table_info_val = explode(",",$report_data->table_info);
}
echo form_label("Select Table", 'table_info', array('class' => 'required'));
echo form_dropdown(array('name' => 'table_info[]','multiple id' =>'table_info','class' => 'form-control input-sm select2'), $table_list,$table_info_val);
?>
</div>
<div class="form-group">
<?php
$table_column_val = "";
if($report_data->table_column){
$table_column_val = explode(",",$report_data->table_column);
}
echo form_label("Select Column", 'table_column', array('class' => 'required'));
echo form_dropdown(array('name' => 'table_column[]','multiple id' =>'table_column','class' => 'form-control input-sm select2'),$columns_list,$table_column_val);
?>
</div>
<div class="form-group">
<?php
$group_column_val = "";
if($report_data->group_column){
$group_column_val = explode(",",$report_data->group_column);
}
echo form_label("Group By", 'group_column', array('class' => ''));
echo form_dropdown(array('name' => 'group_column[]','multiple id' =>'group_column','class' => 'form-control input-sm select2'),$columns_list,$group_column_val);
?>
</div>
<div class="form-group" style="display: none;">
<?php
$sub_tot_show_val = $report_data->sub_tot_show;
?>
<input name='sub_tot_show' id='sub_tot_show' type="checkbox"> <b>Show Sub Total</b>
</div>
<div class="form-group">
<?php
$date_filter_val = $report_data->date_filter;
$date_filter_list = array(""=>"-- Select Type--",1=>"Required",2=>"Not Required");
echo form_label("Date Filter", 'date_filter', array('class' => 'required'));
echo form_dropdown(array('name' => 'date_filter','id' =>'date_filter','class' => 'form-control input-sm'),$date_filter_list,$date_filter_val);
?>
</div>
<div class="form-group">
<?php
$sort_column_val = "";
if($report_data->sort_column){
$sort_column_val = explode(",",$report_data->sort_column);
}
echo form_label("Sort By", 'sort_column', array('class' => ''));
echo form_dropdown(array('name' => 'sort_column[]','multiple id' =>'sort_column','class' => 'form-control input-sm select2'),$columns_list,$sort_column_val);
?>
</div>
<div class="form-group">
<?php
$date_column_val = "";
if($report_data->date_column){
$date_column_val = explode(",",$report_data->date_column);
}
echo form_label("Select Date Column", 'date_column', array('class' => ''));
echo form_dropdown(array('name' => 'date_column[]','multiple id' =>'date_column','class' => 'form-control input-sm select2'),$columns_list,$date_column_val);
?>
</div>
<div class="form-group">
<?php
$table_filter_val = "";
if($report_data->table_column){
$table_filter_val = explode(",",$report_data->table_filter);
}
echo form_label("Select Filter Columns", 'table_filter', array('class' => 'required'));
echo form_dropdown(array('name' => 'table_filter[]','multiple id' =>'table_filter','class' => 'form-control input-sm select2'),'',$table_filter_val);
?>
</div>
<div class="form-group">
<?php
$date_type_val = $report_data->date_filter_type;
$date_type_list = array(""=>"-- Select Type--",1=>"Last 30 Days",2=>"Current Month",3=>"Current Month Update to Date",4=>"Today Date",5=>"Yesterday",6=>"Salary Date");
echo form_label("Date Type", 'date_filter_type', array('class' => 'required'));
echo form_dropdown(array('name' => 'date_filter_type','id' =>'date_filter_type','class' => 'form-control input-sm select2'),$date_type_list,$date_type_val);
?>
</div>
<div class="form-group">
<?php
$filter_start_date = $report_data->filter_start_date;
echo form_label("Start Date", 'filter_start_date', array('class' => 'required'));
echo form_dropdown(array('name' => 'filter_start_date','id' =>'filter_start_date','class' => 'form-control input-sm select2'),$days_list,$filter_start_date);
?>
</div>
<div class="form-group">
<?php
$filter_end_date = $report_data->filter_end_date;
echo form_label("End Date", 'filter_end_date', array('class' => 'required'));
echo form_dropdown(array('name' => 'filter_end_date','id' =>'filter_end_date','class' => 'form-control input-sm select2'),$days_list,$filter_end_date);
?>
</div>
<?php if((int)$this->session->userdata('logged_id') === 1){ ?>
<div class="form-group">
<?php
$menu_types = array(""=>"--- Icon Based ---","1"=>"Yes","2"=>"No");
$menu_type = $report_data->menu_type;
echo form_label("Icon Based", 'menu_type', array('class' => 'required'));
echo form_dropdown(array('name' => 'menu_type','id' =>'menu_type','class' => 'form-control input-sm'), $menu_types,$menu_type);
?>
</div>
<div class="form-group">
<?php
$label_id = "menu_icon";
$value = $report_data->menu_icon;
$upload_id = "upload_$label_id";
$tabel_id = "table_$label_id";
$proof = base_url("$value"); //accept need to be added
echo form_label("Choose Icon", 'upload_menu_icon', array('class' => 'required'));
echo form_upload(array('name' => $upload_id,'id' => $upload_id,'class' => 'form-control input-sm','value' => $input_value ));
$remove_btn = "";
$view_btn = "";
if($value){
$file_name = explode("/",$value);
$file_name = $file_name[2];
$remove_btn = "<a onclick=remove_file('$prime_id','$field_isdefault','$label_id'); style='color: red; cursor: pointer;'><i class='fa fa-times' aria-hidden='true'></i></a>";
$view_btn = "<a href='$proof' target='_blank' style='cursor: pointer;'>$file_name</a>";
}
$row_send_data .= "$upload_old:$('#$upload_old').val(),";
echo "<input type='hidden' id='$label_id' name='$label_id' value='$value'>
<table style='width: 100%;' id='$tabel_id'>
<tr>
<td>$remove_btn</td>
<td style='text-overflow: ellipsis; overflow: hidden; white-space: nowrap; max-width: 100px;'>$view_btn</td>
</tr>
</table>";
$upload_id = "upload_".$label_id;
$check_size = 2;
$send_url = base_url("upload_files/upload.php?send_from=$controller_name&send_for=$upload_id&extension=png,pdf,jpg,jpeg");
$document_load_script = "$('#$upload_id').change(function() {
var file_data = $('#$upload_id').prop('files')[0];
var size = file_data.size;
if(file_data){
var form_data = new FormData();
form_data.append('$upload_id', file_data);
$.ajax({
url: '$send_url',
cache: false,
contentType: false,
processData: false,
data: form_data,
beforeSend: function(){
$('#div_$label_id').show();
$('#submit').html('<i class=\"fa fa-spinner fa-spin\"></i> Processing...');
$('#submit').attr('disabled','disabled');
//progress_bar('$label_id');
},
type: 'post',
success: function(result_data){
var rslt = JSON.parse(result_data);
if(rslt['success']){
$('#$label_id').val(rslt['path']);
}else{
toastr.error(rslt['msg']);
$('#$upload_id').val('');
}
}
});
}else{
toastr.error('Please select file to upload');
}
});" ?>
</div>
<?php } ?>
<div class="form-group">
<?php
$export_type_list = array(""=>"--- Export Type ---","1"=>"To Upper Case","2"=>"Normal");
$export_type = $report_data->export_type;
echo form_label("Export Type", 'export_type', array('class' => 'required'));
echo form_dropdown(array('name' => 'export_type','id' =>'export_type','class' => 'form-control input-sm'), $export_type_list,$export_type);
?>
</div>
<div class="form-group" style='margin-bottom:10px;'>
<button class='btn btn-primary btn-sm' id="report_base_submit">Submit</button>
</div>
<?php echo form_close(); ?>
</div>
<div class="tab-pane fade" id="add_column_view" style="padding-top:10px;">
<?php echo form_open('report_setting/save_add_column/' . $view_id,array('id'=>'save_add_column','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'report_id', 'id'=>'report_id', 'type'=>'Hidden','value'=>$view_id));
echo form_input( array('name'=>'add_column_id', 'id'=>'add_column_id', 'type'=>'Hidden','value'=>0));
echo form_label("Add Name", 'add_name', array('class' => 'required'));
echo form_input(array( 'name' => 'add_name', 'id' => 'add_name', 'class' => 'form-control input-sm', 'placeholder'=>"Display Name",'value' => ""));
?>
</div>
<div class="form-group">
<?php
echo form_label("Select Add Column", 'add_column', array('class' => 'required'));
echo form_dropdown(array('name' => 'add_column','id' =>'add_column','class' => 'form-control input-sm select2'),$columns_list);
?>
</div>
<div class="form-group" style="display:none;">
<?php
echo form_textarea( array('id'=>'hid_add_column_id', 'type'=>'Hidden','value'=>''));
?>
</div>
<div class="form-group" style="width:40% !important;margin-bottom: 0px !important;">
<textarea name='select_condition' id='select_condition'class='form-control' rows='4' placeholder='Query Column'></textarea>
</div>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="add_column_submit">Submit</button>
</div>
<?php echo form_close(); ?>
<!-- Additional Table Column Name View -->
<div id='add_column_content' style="padding:10px; !important; overflow: auto;">
<?php
echo $add_column_content;
?>
</div>
</div>
<!-- Total Column Calculation Part -->
<div class="tab-pane fade" id="total_sum_view">
<?php
echo form_open('report_setting/save_sum_column/'.$view_id,array('id'=>'save_sum_column','class'=>'form-inline'));
?>
<div class="form-group" id="total_sum">
<?php
echo form_input( array('name'=>'total_report_id', 'id'=>'total_report_id', 'type'=>'Hidden','value'=>$view_id));
echo form_label("Sum Column Name", 'sum_column_name', array('class' => 'required'))."<br/>";
echo form_dropdown(array('name' => 'sum_column_name[]','multiple id' =>'sum_column_name','class' => 'form-control input-sm select2'),$sum_column_list);
echo "<br/><br/><label><input name='all_column_select' id='all_column_select' type='checkbox'> Select All</label>";
?>
</div>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="sum_column_submit">Submit</button>
</div>
<?php
echo form_close();
?>
<div id='sum_column_content' style="padding:10px; !important; overflow: auto;">
<?php
echo $sum_column_content;
?>
</div>
</div>
<!-- Table Sort View -->
<div class="tab-pane fade" id="report_tab_view" style="padding:15px;background-color: #f2f2f2; overflow: auto !important;">
<?php
$report_tab_view = json_decode($report_tab_view);
$table_content = $report_tab_view->table_content;
$report_id = $report_tab_view->report_id;
$table_report_id = $report_tab_view->table_report_id;
echo $table_content;
?>
</div>
<div class="tab-pane fade" id="report_tab_join">
<?php
echo form_open('report_setting/save_join_table/' . $view_id,array('id'=>'save_join_table','class'=>'form-inline','style'=>'padding:15px;'));
?>
<span id="join_list_id"><?php echo $join_list;?></span>
<?php
echo form_close();
?>
</div>
<div class="tab-pane fade" id="report_tab_where">
<?php echo form_open('report_setting/save_table_where/' . $prime_module_id,array('id'=>'save_table_where','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'where_for_id', 'id'=>'where_for_id', 'type'=>'Hidden','value'=>$view_id));
echo form_input( array('name'=>'query_type', 'id'=>'query_type', 'type'=>'Hidden','value'=>''));
echo form_label($this->lang->line('query_for'), 'field_for', array('class' => 'required'));
echo form_dropdown(array('name' => 'query_for[]','multiple id' =>'query_for','class' => 'form-control input-sm select2'), $user_field_for);
echo "<label><input name='all_query_for_select' id='all_query_for_select' type='checkbox'> Select All</label>";
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('query_column_list'), 'pick_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'query_column_list','id' =>'query_column_list','class' => 'form-control input-sm select2'),$columns_list);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('picklist_type'), 'picklist_type', array('class' => 'required'));
$query_type_array = array(''=>"--- Select Get Value from ---","1"=>"Get From Picklist ","2"=>"Get From Session");
echo form_dropdown(array('name' => 'picklist_type','id' =>'picklist_type','class' => 'form-control input-sm select2'), $query_type_array);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('pick_list'), 'pick_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'pick_list[]','multiple id' =>'pick_list','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('session_list'), 'session_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'session_list','id' =>'session_list','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group">
<a class='btn btn-edit btn-sm' id="apply_condition">Apply to Condition</a>
</div>
<br/>
<div style='padding: 15px 0px; background-color: #efefef;'>
<div class="form-group" style="width:75% !important;margin-bottom: 0px !important;">
<textarea name='where_condition' id='where_condition'class='form-control' rows='4' placeholder='Write Condition with out where' >and</textarea>
</div>
<?php
//if((int)$view_id > 0){
?>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="save_query_btn">Add/Update</button>
</div>
<?php
//}
?>
</div>
<?php echo form_close(); ?>
<div id='table_query_list'>
<?php
echo $table_query_list;
?>
</div>
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){
$("#search_submit").click(function(){
$("#search_filter_div").toggle()
});
//ON LOAD -> SELECTED OPTIONS IN THE FILTER COLUMN PICKLIST BASED ON THE SELECT COLUMN INPUT !
var tab_value = '<?php echo json_encode($table_filter_val); ?>';
var sample_obj = jQuery.parseJSON(tab_value);
selected_option(sample_obj);
$("#table_column").change(function(){
var tab_value = '<?php echo json_encode($table_filter_val); ?>';
var sample_obj = jQuery.parseJSON(tab_value);
selected_option(sample_obj);
});
$("#search_filter_div").hide();
$("#search_filter").click(function(){
$("#search_filter_div").toggle();
});
$("#clear_search").click(function(){
$('#search_filter_div').find('input').val('');
$('option').attr('selected', false);
$("#search_filter_div").toggle();
});
$('#date_column,#date_filter_type').parent().hide();
$('#sub_tot_show').parent().hide();
//$report_for_val,$table_info_val,$table_column_val,$sub_total_row_val,$sub_total_column_val
var report_for_val = "#<?php echo $report_for_val;?>";
if((report_for_val === "") || (report_for_val === "#")){
$('#report_for option:selected').removeAttr('selected');
}
var table_info_val = "#<?php echo $table_info_val;?>";
if((table_info_val === "") || (table_info_val === "#")){
$('#table_info option:selected').removeAttr('selected');
}
var table_column_val = "#<?php echo $table_column_val;?>";
if((table_column_val === "") || (table_column_val === "#")){
$('#table_column option:selected').removeAttr('selected');
}
var table_filter_val = "#<?php echo $table_filter_val;?>";
if((table_filter_val === "") || (table_filter_val === "#")){
$('#table_filter option:selected').removeAttr('selected');
}
/*var sub_total_row_val = "#<?php echo $sub_total_row_val;?>";
if((sub_total_row_val === "") || (sub_total_row_val === "#")){
$('#sub_total_row option:selected').removeAttr('selected');
}*/
var group_column_val = "#<?php echo $group_column_val;?>";
if((group_column_val === "") || (group_column_val === "#")){
$('#group_column option:selected').removeAttr('selected');
}
var date_column_val = "#<?php echo $date_column_val;?>";
if((date_column_val === "") || (date_column_val === "#")){
$('#date_column option:selected').removeAttr('selected');
}
var date_filter_val = "<?php echo $date_filter_val;?>";
if(parseInt(date_filter_val) === 1){
$('#date_column,#date_filter_type').parent().show();
$('#date_column,#date_filter_type').attr('required','required');
}else{
$('#date_column,#date_filter_type').parent().hide();
$('#date_column,#date_filter_type').removeAttr('required');
}
var sort_column_val = "#<?php echo $sort_column_val;?>";
if((sort_column_val === "") || (sort_column_val === "#")){
$('#sort_column option:selected').removeAttr('selected');
}
$('#sub_tot_show').prop('checked', false);
var sub_tot_show_val = "<?php echo $sub_tot_show_val;?>";
if(parseInt(sub_tot_show_val) === 1){
$('#sub_tot_show').prop('checked', true);
$('#sub_tot_show').parent().show();
}
call_select();
$("#all_category_select").click(function(){
if($("#all_category_select").is(':checked') ){
$("#report_for > option").prop("selected","selected");
$("#report_for").trigger("change");
}else{
$("#report_for > option").removeAttr("selected");
$("#report_for").trigger("change");
}
$('#report_for option').filter(function(){
return !this.value || $.trim(this.value).length == 0;
}).remove();
});
$('#group_column').change(function(e){
group_column = $('#group_column').val();
if(group_column == ""){
$('#sub_tot_show').parent().hide();
}else{
$('#sub_tot_show').parent().show();
}
});
//Value append in the text area column hidden is used
$('#add_column').change(function(e){
var add_name = $('#add_name').val();
var add_column_name = $('#add_column').val();
var check_result = "";
if(add_name !== ""){
if(add_column_name !== ""){
var check_result = "@"+add_column_name+"@";
$('#hid_add_column_id').append(check_result);
}
}
var as_column_name = add_name.replaceAll(" ","_").toLowerCase();
var fill_val = $('#hid_add_column_id').val();
if(fill_val){
$('#select_condition').val(",("+fill_val+") as "+as_column_name);
}
});
$("#all_column_select").click(function(){
if($("#all_column_select").is(':checked') ){
$("#sum_column_name > option").prop("selected","selected");
$("#sum_column_name").trigger("change");
}else{
$("#sum_column_name > option").removeAttr("selected");
$("#sum_column_name").trigger("change");
}
});
//Next Tab to Display
function activaTab(tab){
$('.nav-tabs a[href="#' + tab + '"]').tab('show');
};
$('#report_save').validate($.extend({
submitHandler: function (form){
$("#report_base_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#report_base_submit').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
let report_for_arr = [];
let table_info_arr = [];
let table_column_arr = [];
let table_filter_arr = [];
let group_column_arr = [];
let sort_column_arr = [];
let date_column_arr = [];
$('select[name="report_for[]"]').each(function (a , b) {
report_for_arr[a] = $(this).val();
});
$('select[name="table_info[]"]').each(function (a , b) {
table_info_arr[a] = $(this).val();
});
$('select[name="table_column[]"]').each(function (a , b) {
table_column_arr[a] = $(this).val();
});
$('select[name="table_filter[]"]').each(function (a , b) {
table_filter_arr[a] = $(this).val();
});
$('select[name="group_column[]"]').each(function (a , b) {
group_column_arr[a] = $(this).val();
});
$('select[name="sort_column[]"]').each(function (a , b) {
sort_column_arr[a] = $(this).val();
});
$('select[name="date_column[]"]').each(function (a , b) {
date_column_arr[a] = $(this).val();
});
jsonData['report_for'] = report_for_arr[0];
jsonData['table_info'] = table_info_arr[0];
jsonData['table_column'] = table_column_arr[0];
jsonData['table_filter'] = table_filter_arr[0];
jsonData['group_column'] = group_column_arr[0];
jsonData['sort_column'] = sort_column_arr[0];
jsonData['date_column'] = date_column_arr[0];
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/report_save"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#report_base_submit').attr('disabled',false);
$("#report_base_submit").html("Submit");
var table_opt = "";
$.each(response.table_column, function (index, value) {
var table_selected = "";
if($.inArray(index, table_column) >= 0) {
table_selected = "selected";
}
table_opt += '<option value="' + index + '" '+table_selected+'>' + value + '</option>';
});
$("#sum_column_name").empty();
var sum_table_opt = "";
$.each(response.sum_column_list, function (index, value) {
sum_table_opt += '<option value="' + index + '">' + value + '</option>';
});
if(response.success){
$("#join_list_id").html(response.report_tab_join);
$("#query_column_list").append(table_opt);
$("#add_column").append(table_opt);
$("#sum_column_name").append(sum_table_opt);
$("#report_id").val(response.report_id);
$("#total_report_id").val(response.report_id);
$("#join_list_id").css({padding: "15px"});
$('#report_tab_view').html(response.drag_column);
default_sortable();
toastr.success(response.message);
table_support.refresh();
}else{
toastr.error(response.message);
}
call_select();
},
dataType: 'json'
});
},
rules:{
report_name: "required",
report_menu: "required",
"table_info[]": "required",
"table_column[]": "required",
"report_for[]": "required",
date_filter: "required",
}
}));
$("#date_filter").change(function(){
date_filter = $("#date_filter").val();
if(date_filter === "1"){
$('#date_column,#date_filter_type').parent().show();
// $('#date_column').attr('required','required');
}else{
$('#date_column,#date_filter_type').parent().hide();
// ('#date_column').removeAttr('required');
}
call_select()
});
$('#save_join_table').validate({
submitHandler:function(form) {
var isValid = true;
$("select[name='line_prime_table[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='line_prime_col[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='line_join_type[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='line_join_table[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='line_join_col[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
if(isValid) {
$("#save_join_table_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_join_table_btn').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_join_table"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#save_join_table_btn').attr('disabled',false);
$("#save_join_table_btn").html("Save");
toastr.success(response.message);
},
dataType: 'json'
});
}else{
toastr.error("Map all table join");
}
}
});
jQuery.validator.addMethod("notEqual", function (value, element, param) { // Adding rules for Amount(Not equal to zero)
return this.optional(element) || value != 'and';
}, "Please choose query column?");
$('#save_table_where').validate($.extend({
submitHandler: function (form){
$("#save_query_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_query_btn').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_table_where"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#save_query_btn').attr('disabled',false);
$("#save_query_btn").html("Add/Update");
if(response.success){
toastr.success(response.message);
$("#table_query_list").html(response.table_query_list);
document.getElementById("save_table_where").reset();
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
query_for: "required",
where_condition: {
required:true,
notEqual: true,
}
}
}));
$('#picklist_type,#pick_list,#session_list').parent().hide();
$("#query_column_list").change(function(){
query_column = $("#query_column_list").val();
if(query_column){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {query_column:query_column};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_column_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
$('#pick_list').empty();
$('#session_list').empty();
$('#picklist_type,#pick_list,#session_list').parent().hide();
if(rslt.success){
if(rslt.type === "pick_list"){
var pick_option ="";
$.each(rslt.pick_list, function( key, value ) {
pick_option += '<option value="' + key + '">' + value + '</option>';
});
$('#pick_list').append(pick_option);
var session_option ="";
$.each(rslt.session_list, function( key, value ) {
session_option += '<option value="' + key + '">' + value + '</option>';
});
$('#session_list').append(session_option);
$('#picklist_type').parent().show();
}else
if(rslt.type === "session_list"){
var option ="";
$.each(rslt.session_list, function( key, value ) {
option += '<option value="' + key + '">' + value + '</option>';
});
$('#session_list').append(option);
$('#session_list').parent().show();
}
$("#query_type").val(rslt.type);
}else{
toastr.error(rslt.msg);
}
},
});
}
});
$("#picklist_type").change(function(){
$('#pick_list,#session_list').parent().hide();
picklist_type = $("#picklist_type").val();
if(picklist_type === "1"){
$('#pick_list').parent().show();
}else
if(picklist_type === "2"){
$('#session_list').parent().show();
}
call_select()
});
$("#apply_condition").click(function(){
query_column = $("#query_column_list").val();
query_type = $("#query_type").val();
var fill_val = "";
if(query_column){
if(query_type === "pick_list"){
picklist_type = $("#picklist_type").val();
if(picklist_type === "1"){
sub_value = $("#pick_list").val();
if(sub_value){
fill_val = query_column + " in(^"+sub_value+"^) ";
}else{
toastr.error("Please select pick list value");
return false;
}
}else
if(picklist_type === "2"){
sub_value = $("#session_list").val();
sub_value = sub_value.split('|');
sub_value = sub_value[1];
if(sub_value){
fill_val = query_column + " in(^@"+sub_value+"@^)";
}else{
toastr.error("Please select session value");
return false;
}
}
}else
if(query_type === "session_list"){
sub_value = $("#session_list").val();
sub_value = sub_value.split('|');
sub_value = sub_value[1];
if(sub_value){
fill_val = query_column + " = ^@"+sub_value+"@^";
}else{
toastr.error("Please select session value");
return false;
}
}else{
toastr.error("Invalid column");
return false;
}
}else{
toastr.error("Please select column value");
return false;
}
if(fill_val){
where_condition = $("#where_condition").val();
fill_val = where_condition +" "+fill_val;
$("#where_condition").val(fill_val);
}
});
/* GET TABLE COLUM LIST*/
$("#table_info").change(function(){
var table_info = $('#table_info').val();
var table_column = $('#table_column').val();
var group_column = $('#group_column').val();
var date_column = $('#date_column').val();
var sort_column = $('#sort_column').val();
//if(!table_info){
$('#table_column option:selected').removeAttr('selected');
$('#group_column option:selected').removeAttr('selected');
$('#date_column option:selected').removeAttr('selected');
$('#sort_column option:selected').removeAttr('selected');
$('#table_column,#group_column,#date_column,#sort_column').empty();
//}else{
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {table_info:table_info};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_table_column"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
call_select();
if(rslt.success){
if(rslt.table_column){
var table_opt = "";
var group_opt = "";
var sort_opt = "";
$.each(rslt.table_column, function (index, value) {
var table_selected = "";
var group_selected = "";
// var date_selected = "";
var sort_selected = "";
if($.inArray(index, table_column) >= 0) {
table_selected = "selected";
}
if($.inArray(index, group_column) >= 0) {
group_selected = "selected";
}
if($.inArray(index, date_column) >= 0) {
date_selected = "selected";
}
if($.inArray(index, sort_column) >= 0) {
sort_selected = "selected";
}
table_opt += '<option value="' + index + '" '+table_selected+'>' + value + '</option>';
group_opt += '<option value="' + index + '" '+group_selected+'>' + value + '</option>';
// date_opt += '<option value="' + index + '" '+date_selected+'>' + value + '</option>';
sort_opt += '<option value="' + index + '" '+sort_selected+'>' + value + '</option>';
});
var date_opt = "";
$.each(rslt.get_date_columns, function (index, value) {
var date_selected = "";
if($.inArray(index, date_column) >= 0) {
date_selected = "selected";
}
date_opt += '<option value="' + index + '" '+date_selected+'>' + value + '</option>';
});
$('#table_column').append(table_opt);
$('#group_column').append(group_opt);
$('#date_column').append(date_opt);
$('#sort_column').append(sort_opt);
}
call_select();
}else{
toastr.error(rslt.message);
}
},
});
//}
});
/* TABLE SORTABLE - START */
default_sortable();
/* TABLE SORTABLE - END */
//Save Additional Table Column input save functions
$('#save_add_column').validate($.extend({
submitHandler: function (form){
$("#add_column_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#add_column_submit').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_add_column"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#add_column_submit').attr('disabled',false);
$("#add_column_submit").html("Submit");
if(response.success){
toastr.success(response.message);
$("#add_column_content").html(response.add_column_content);
$("#add_column").val('');
$('.select2').select2({placeholder: '---- Select ----',});
}else{
toastr.error(response.message);
}
document.getElementById("save_add_column").reset();
$("#add_column_id").val(0);
$('#report_tab_view').html(response.drag_column);
default_sortable();
},
dataType: 'json'
});
},
rules:{
add_name: "required",
add_column: "required",
}
}));
//Save total columnwise input function
$('#save_sum_column').validate($.extend({
submitHandler: function (form){
$("#sum_column_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#sum_column_submit').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
let sum_column_name_arr = [];
$('select[name="sum_column_name[]"]').each(function (a , b) {
sum_column_name_arr[a] = $(this).val();
});
jsonData['sum_column_name'] = sum_column_name_arr[0];
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_sum_column"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#sum_column_submit').attr('disabled',false);
$("#sum_column_submit").html("Submit");
if(response.success){
toastr.success(response.message);
$("#sum_column_content").html(response.sum_column_content);
}else{
toastr.error(response.message);
}
//$('.modal').modal('toggle');
},
dataType: 'json'
});
},
rules:{
"sum_column_name[]": "required",
}
}));
$("#save_filter_query_btn").on('click', function(e){
var status = true;
var report_filter_id = $('#report_filter_id').val();
var prime_report_setting_id = $('#module_id').val();
var filter_name = $("#filter_name").val();
var arr_sts = true;
var result = {};
var filter_label = $("input[name='filter_label[]']").map(function(){return $(this).val();}).get();
$.each($("input[name='filter_val[]'],select[name='filter_val[]']"), function() {
var id = $(this).attr('id');
result[id]=$(this).val();
if($(this).val()){
arr_sts = false;
}
});
if(arr_sts){
toastr.error('Please select the filter condition and value !');
status = false;
}
if(!filter_name){
toastr.error('Please enter the filter name');
status = false;
}
var send_url = '<?php echo site_url("$controller_name/filter_save");?>'
if(status){
$("#save_filter_query_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_filter_query_btn').attr('disabled','disabled');
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {report_filter_id:report_filter_id,prime_report_setting_id:prime_report_setting_id,filter_name:filter_name,result:result,filter_label:filter_label};
var encData = encrypt(encKey,data);
$.ajax({
type: 'POST',
url: send_url,
data:encData,
contentType: 'text/plain',
success: function (data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#filter_report_view").html(rslt.table_view);
}else{
toastr.error(rslt.message);
}
$('#report_filter_id,#filter_name').val('');
$("input[name='filter_val[]'],select[name='filter_val[]']").map(function(){return $(this).val('');});
$(function(){
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
dropdownParent: $('.modal-dialog')
});
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
});
$('#save_filter_query_btn').attr('disabled',false);
$("#save_filter_query_btn").html("Add/Update");
}
});
}
});
$("#cancel_filter_query_btn").click(function(){
$('#report_filter_id,#filter_name').val('');
$('#search_filter_div').find('input').val('');
$('#search_filter_div').find('select').val('');
$("input[name='filter_val[]'],select[name='filter_val[]']").map(function(){
if($(this).hasClass('select2')){
$(this).select2({
placeholder: '---- Select ----',
allowClear: true,
dropdownParent: $('.modal-dialog')
});
}
});
$("#search_filter_div").toggle();
toastr.success('Data Cleaned');
});
$("#add_name").change(function(){
var add_name = $("#add_name").val();
var report_id = $("#report_id").val();
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {add_name:add_name,report_id:report_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/check_add_column"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(!rslt.success){
$("#add_name").val('');
toastr.error(rslt.message);
}
},
});
});
var menu_type = $("#menu_type").val();
menu_type_hide_show(menu_type);
$("#menu_type").change(function(){
var menu_type = $("#menu_type").val();
menu_type_hide_show(menu_type);
});
var date_filter_type = $("#date_filter_type").val();
date_hide_show(date_filter_type);
$("#date_filter_type").change(function(){
var date_filter_type = $("#date_filter_type").val();
date_hide_show(date_filter_type);
});
$("#filter_start_date").change(function(){
var res_value = this.value;
var res_text = $("#filter_start_date option:selected").text();
ans_value = parseInt(res_value) - 1;
ans_text = parseInt(res_text) - 1;
if(ans_value !=0){
$('#filter_end_date').append('<option value="' + ans_value + '" selected="selected">' + ans_text + '</option>');
}else{
alert("Please Choose valid cut off?");
$('#filter_start_date').val("");
}
});
//select all data for query for
$("#all_query_for_select").click(function(){
if($("#all_query_for_select").is(':checked') ){
$("#query_for > option").prop("selected","selected");
$("#query_for").trigger("change");
}else{
$("#query_for > option").removeAttr("selected");
$("#query_for").trigger("change");
}
$('#query_for option').filter(function(){
return !this.value || $.trim(this.value).length == 0;
}).remove();
});
//duplicate column remove
$('#table_column').on('select2:select', function(e) {
var table_column = $("select[name='table_column[]']").map(function(){
return $(this).val();
}).get();
var data = e.params.data;
var split_id = data.id.split('.');
var split_id = split_id[1]
var remove_id= $.each( table_column, function(key,value){
if(value != data.id){
if(value){
var split_data = value.split('.');
var split_val = split_data[1];
if(split_val === split_id){
$('#table_column option[value="'+data.id+'"]').prop('selected', false);
toastr.error('Column Already selected...');
}
}
}
});
});
/* upload icons */
<?php echo $document_load_script; ?>
/* upload icons */
});
function date_hide_show(date_filter_type){
if(parseInt(date_filter_type) === 6){
$("#filter_start_date,#filter_end_date").parent().show();
$("#filter_start_date,#filter_end_date").attr('required','required');
}else{
$("#filter_start_date,#filter_end_date").parent().hide();
$("#filter_start_date,#filter_end_date").removeClass("required");
}
}
//ICON HIDE SHOW
function menu_type_hide_show(menu_type){
$("#upload_menu_icon").parent().hide();
$("#upload_menu_icon").addClass('error');
if(parseInt(menu_type) === 1){
$("#upload_menu_icon").parent().show();
$("#upload_menu_icon").removeClass('error');
}else{
$("#upload_menu_icon").parent().hide();
$("#upload_menu_icon").addClass('error');
$("#menu_icon").val('');
}
}
//FILTER COLUMN INPUT ONCHANGE SELECT OPTIONS !
function selected_option(sample_obj){
var values = $("#table_column > option:selected").map(function(){
var sel = '';
if ($.inArray($(this).val(), sample_obj) >= 0) {
sel = 'selected';
}
return '<option value='+$(this).val()+' '+sel+'>'+$(this).text()+'</option>';
}).get();
$('#table_filter').html(values);
}
//SORTABLE DEFAULT TABLE
function default_sortable(){
var table_idsInOrder = [];
$( ".default_table" ).sortable({
update: function( event, ui ){
table_idsInOrder = [];
$('#report_sortable tr > th').each(function() {
table_idsInOrder.push($(this).attr('id'));
});
if(table_idsInOrder){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {table_idsInOrder:table_idsInOrder};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/table_sort_update"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.message);
}
},
});
get_table_view_data();
}
},connectWith: '.default_table'
});
}
//GET DEFAULT TABLE UI
function get_table_view_data(){
var report_id = $("#report_id").val();
if(report_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {report_id:report_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_table_view_data"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data){
var rslt = JSON.parse(data);
if(rslt.success){
$('#report_tab_view').html(rslt.table_content);
default_sortable();
}
}
});
}
}
function call_select(){
$(function(){
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
dropdownParent: $('.modal-dialog')
});
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
});
}
function get_add_column_edit(add_column_id){
if(add_column_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {add_column_id:add_column_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_add_column_edit"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
select_condition = rslt.edit_result.select_condition;
if(select_condition){
select_condition = select_condition.replaceAll('~', '"');
}
ad_name = rslt.edit_result.add_name;
ad_name = ad_name.replaceAll("_"," ").toUpperCase();
add_column = rslt.edit_result.add_column;
$("#add_column_id").val(rslt.edit_result.prime_report_add_column_id);
$("#add_name").val(ad_name);
// $("#add_column").val(rslt.edit_result.add_column);
$("#add_column").find("option[value='"+add_column+"']").prop("selected", "selected");
$("#select_condition").val(select_condition);
}else{
toastr.error(rslt.message);
}
call_select();
},
});
}
}
function remove_add_column(add_column_id,report_id){
if(confirm("Are you sure to delete!")){
if(add_column_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {add_column_id:add_column_id,report_id:report_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/remove_add_column"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#add_column_content").html(rslt.add_column_content);
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
}
function get_sum_column_edit(report_id){
if(report_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {report_id:report_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_sum_column_edit"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#report_id").val(rslt.sum_column_edit_result.report_id);
if(rslt.sum_column_edit_result.sum_column_name){
var sum_column_options = rslt.sum_column_edit_result.sum_column_name.split(',');
for(var i in sum_column_options) {
var optionVal = sum_column_options[i];
$("#sum_column_name").find("option[value='"+optionVal+"']").prop("selected", "selected");
}
}
call_select();
}
},
});
}
}
function remove_sum_column(report_id){
if(report_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {report_id:report_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/remove_sum_column"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#sum_column_content").html(rslt.sum_column_content);
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
function edit_filter_report(report_id){
if(report_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {report_id:report_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/edit_filter_report"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
var filter_val = (rslt.edit_data['filter_label']).split(",");
i = 0;
$("input[name='filter_label[]']").map(function(){
$(this).val(filter_val[i]);
i++;
}).get();
var map = (rslt.edit_data['map']);
var report_filter_id = $('#report_filter_id').val(rslt.edit_data['report_filter_id']);
var prime_report_setting_id = $('#module_id').val(rslt.edit_data['prime_report_setting_id']);
var filter_name = $("#filter_name").val(rslt.edit_data['filter_name']);
$.each( map, function(key,value){
if(value){
$("#"+key).val(value);
if($("#"+key).hasClass('select2')){
$("#"+key).select2({
placeholder: '---- Select ----',
allowClear: true,
dropdownParent: $('.modal-dialog')
});
}
}
});
}
});
}
}
function delete_filter_report(report_id,prime_report_setting_id){
if(report_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {report_id:report_id,prime_report_setting_id:prime_report_setting_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/delete_filter_report"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#filter_report_view").html(rslt.table_view);
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
function edit_query(prime_report_where_id){
if(prime_report_where_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {prime_report_where_id:prime_report_where_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_edit_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#query_for").val('');
if(rslt.query_for){
var condition_for = rslt.query_for.split(",");
for(var i in condition_for) {
var condition_for_val = condition_for[i];
$("#query_for").find("option[value='"+condition_for_val+"']").prop("selected", "selected");
}
}
$("#where_condition").val(rslt.where_condition);
}else{
toastr.error(rslt.message);
}
call_select();
},
});
}
}
function remove_query(prime_report_where_id,where_for_id){
if(confirm("Are you sure to delete!")){
if(prime_report_where_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {prime_report_where_id:prime_report_where_id,where_for_id:where_for_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/remove_query_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#table_query_list").html(rslt.table_query_list);
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
}
</script>
<style>
div#total_sum > span{
width: 200px !important;
}
/*ul.select2-selection__rendered{
overflow: auto !important;height: 180px;
}*/
.search_filter{
right: 56.5%;
}
.select2-selection--multiple{
overflow-y: scroll !important;
height: 100px;
border-radius: 13px;
}
.form-inline .form-control {
display: inline-block;
width: -webkit-fill-available;
vertical-align: middle;
text-transform: lowercase !important;
}
.form-control, input {
border-width: auto;
-webkit-box-shadow: none;
box-shadow: none;
text-transform: lowercase !important;
}
</style>