File: //home/cafsindia/login_cafsindia_com/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: 23%; 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_setting">Report Settings</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#view_setting">View Settings</a>
</li>
</ul>
<div class="tab-content">
<!------------------------------------------------------------------>
<!------------------ REPORT SETTING - STARTS ----------------------->
<!------------------------------------------------------------------>
<div class="tab-pane fade in active" id="report_setting">
<ul class="nav nav-tabs second_nav_tab" 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="#custom_select">Custom Select column</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
$prime_report_setting_id = 0;
if($report_data->prime_report_setting_id){
$prime_report_setting_id = $report_data->prime_report_setting_id;
}
echo form_input( array('name'=>'prime_report_setting_id', 'id'=>'prime_report_setting_id', 'type'=>'Hidden','value'=>$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='select_all_role' id='select_all_role' type='checkbox'> Select All</label>";
?>
</div>
<div class="form-group">
<?php
$report_tables_val = "";
if($report_data->report_tables){
$report_tables_val = explode(",",$report_data->report_tables);
}
echo form_label("Select Table", 'report_tables', array('class' => 'required'));
echo form_dropdown(array('name' => 'report_tables[]','multiple id' =>'report_tables','class' => 'form-control input-sm select2'), $table_list,$report_tables_val);
?>
</div>
<div class="form-group">
<?php
$report_columns_val = "";
if($report_data->report_columns){
$report_columns_val = explode(",",$report_data->report_columns);
}
echo form_label("Select Column", 'report_columns', array('class' => 'required'));
echo form_dropdown(array('name' => 'report_columns[]','multiple id' =>'report_columns','class' => 'form-control input-sm select2'),$table_column,$report_columns_val);
?>
</div>
<div class="form-group">
<?php
$report_prime_column_val = "";
if($report_data->report_prime_column){
$report_prime_column_val = explode(",",$report_data->report_prime_column);
}
echo form_label("Prime Column ID", 'report_prime_column', array('class' => 'required'));
echo form_dropdown(array('name' => 'report_prime_column[]','multiple id' =>'report_prime_column','class' => 'form-control input-sm select2'),$table_column,$report_prime_column_val);
?>
</div>
<div class="form-group">
<?php
echo form_label("Search Filter", 'search_filter', array('class' => 'required'));
echo form_dropdown(array('name' => 'search_filter','id' =>'search_filter','class' => 'form-control input-sm'),$filter_list,$report_data->search_filter);
?>
</div>
<div class="form-group">
<?php
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'),$filter_list,$report_data->date_filter);
?>
</div>
<div class="form-group">
<?php
$date_filter_column_val = "";
if($report_data->date_filter_column){
$date_filter_column_val = explode(",",$report_data->date_filter_column);
}
echo form_label("Select Date Column", 'date_filter_column', array('class' => ''));
echo form_dropdown(array('name' => 'date_filter_column[]','multiple id' =>'date_filter_column','class' => 'form-control input-sm select2'),$date_column,$date_filter_column_val);
?>
</div>
<div class="form-group">
<?php
$report_group_by_val = "";
if($report_data->report_group_by){
$report_group_by_val = explode(",",$report_data->report_group_by);
}
echo form_label("Group By", 'report_group_by', array('class' => ''));
echo form_dropdown(array('name' => 'report_group_by[]','multiple id' =>'report_group_by','class' => 'form-control input-sm select2'),$table_column,$report_group_by_val);
?>
</div>
<div class="form-group">
<?php
echo form_label("Show Sub Total", 'subtotal_filter', array('class' => ''));
echo form_dropdown(array('name' => 'subtotal_filter','id' =>'subtotal_filter','class' => 'form-control input-sm'),$filter_list,$report_data->subtotal_filter);
?>
</div>
<div class="form-group">
<?php
$subtotal_column_val = "";
if($report_data->subtotal_column){
$subtotal_column_val = explode(",",$report_data->subtotal_column);
}
echo form_label("Total / Sub total Column", 'subtotal_column', array('class' => 'required'));
echo form_dropdown(array('name' => 'subtotal_column[]','multiple id' =>'subtotal_column','class' => 'form-control input-sm select2'),$total_subtotal_list,$subtotal_column_val);
?>
</div>
<div class="form-group" style='margin-bottom:10px;'>
<button class='btn btn-primary btn-sm' id="report_setting_submit">Submit</button>
</div>
<?php echo form_close(); ?>
</div>
<div class="tab-pane fade" id="custom_select" style="padding-top:10px;">
<?php echo form_open('report_setting/save_custom_select/' . $view_id,array('id'=>'save_custom_select','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_custom_select_id', 'id'=>'prime_custom_select_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'custom_select_report_id', 'id'=>'custom_select_report_id', 'type'=>'Hidden','value'=>$view_id));
echo form_label("Custom Column Name", 'custom_column_name', array('class' => 'required'));
echo form_input(array( 'name' => 'custom_column_name', 'id' => 'custom_column_name', 'class' => 'form-control input-sm', 'placeholder'=>"Custom Column Name",'value' => "", 'style'=>'text-transform:lowercase;'));
?>
</div>
<div class="form-group">
<?php
echo form_label("Select Column", 'custom_select_column', array('class' => ''));
echo form_input( array('name'=>'custom_select_column_hidden', 'id'=>'custom_select_column_hidden', 'type'=>'Hidden','value'=>''));
echo form_dropdown(array('name' => 'custom_select_column','id' =>'custom_select_column','class' => 'form-control input-sm'),$table_column);
?>
</div>
<div class="form-group" style="width:40% !important;margin-bottom: 0px !important;">
<textarea name='select_column_query' id='select_column_query'class='form-control' rows='4' placeholder='Query Column' style='text-transform:lowercase;'></textarea>
</div>
<?php
if((int)$view_id > 0){
?>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="custom_select_submit">Submit</button>
</div>
<?php
}
?>
<?php echo form_close(); ?>
<div id='custom_select_list' style="padding:10px; !important; overflow: auto;">
<?php echo $custom_select_list; ?>
</div>
</div>
<div class="tab-pane fade" id="report_tab_view" style="padding:15px;">
<div id='table_view_list' style="overflow: auto;">
<?php echo $table_view_list ?>
</div>
</div>
<div class="tab-pane fade" id="report_tab_join" style="padding:8px;">
<?php
echo form_open('report_setting/save_join_table/' . $view_id,array('id'=>'save_join_table','class'=>'form-inline'));
echo $join_list;
echo form_close();
?>
</div>
<div class="tab-pane fade" id="report_tab_where">
<?php echo form_open('report_setting/save_table_where/' . $view_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_column_list'), 'pick_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'query_column_list','id' =>'query_column_list','class' => 'form-control input-sm'),$table_column);
?>
</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'), $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'));
?>
</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' style=' text-transform: lowercase;'><?php echo $where_condition; ?></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>
</div>
</div>
<!------------------------------------------------------------------>
<!---------------------- REPORT SETTING -END ----------------------->
<!------------------------------------------------------------------>
<!------------------------------------------------------------------>
<!---------------------- VIEW SETTING - START ---------------------->
<!------------------------------------------------------------------>
<div class="tab-pane fade" id="view_setting">
<ul class="nav nav-tabs second_nav_tab" data-tabs="tabs">
<li class='active' role="presentation">
<a data-toggle="tab" href="#view_block">View Block</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#view_map_columns">Map Columns</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#view_custom_select">View custom select</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#view_table_join">View Table Join</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#view_table_where">View Table Where</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#view_sort">View Sort</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#view_table_sort">View Table Sort</a>
</li>
</ul>
<div class="tab-content">
<div class="tab-pane fade in active" id="view_block" style="padding-top:10px;">
<?php echo form_open('report_setting/view_save/' . $view_id,array('id'=>'view_save','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'report_setting_id', 'id'=>'report_setting_id', 'type'=>'Hidden','value'=>$view_id));
echo form_input( array('name'=>'prime_view_id', 'id'=>'prime_view_id', 'type'=>'Hidden','value'=>0));
echo form_label("View Name", 'view_name', array('class' => 'required'));
echo form_input(array( 'name' => 'view_name', 'id' => 'view_name', 'class' => 'form-control input-sm', 'placeholder'=>"View Name",'value' => ''));
?>
</div>
<div class="form-group">
<?php
echo form_label("View For", 'view_for', array('class' => 'required'));
echo form_dropdown(array('name' => 'view_for[]','multiple id' =>'view_for','class' => 'form-control input-sm select2'), $report_for_list);
echo "<label><input name='view_select_all_role' id='view_select_all_role' type='checkbox'> Select All</label>";
?>
</div>
<div class="form-group">
<?php
echo form_label("View Type", 'view_type', array('class' => 'required'));
echo form_dropdown(array('name' => 'view_type','id' =>'view_type','class' => 'form-control input-sm'),$view_type_list);
?>
</div>
<div class="form-group">
<?php
echo form_label("View Size", 'view_size', array('class' => 'required'));
echo form_dropdown(array('name' => 'view_size','id' =>'view_size','class' => 'form-control input-sm'),$view_size_list);
?>
</div>
<div class="form-group">
<?php
echo form_label("Chart", 'view_chart', array('class' => 'required'));
echo form_dropdown(array('name' => 'view_chart','id' =>'view_chart','class' => 'form-control input-sm'),$filter_list);
?>
</div>
<div class="form-group">
<?php
echo form_label("Chart Size", 'view_chart_size', array('class' => ''));
echo form_dropdown(array('name' => 'view_chart_size','id' =>'view_chart_size','class' => 'form-control input-sm'),$view_size_list);
?>
</div>
<div class="form-group">
<?php
echo form_label("View Table", 'view_tables', array('class' => 'required'));
echo form_dropdown(array('name' => 'view_tables[]','multiple id' =>'view_tables','class' => 'form-control input-sm select2'), $table_list);
?>
</div>
<div class="form-group">
<?php
echo form_label("View Select Column", 'view_columns', array('class' => ''));
echo form_dropdown(array('name' => 'view_columns[]','multiple id' =>'view_columns','class' => 'form-control input-sm select2'),$view_column);
?>
</div>
<div class="form-group">
<?php
echo form_label("View Total Column", 'view_total_columns', array('class' => ''));
echo form_dropdown(array('name' => 'view_total_columns[]','multiple id' =>'view_total_columns','class' => 'form-control input-sm select2'),$view_total_columns);
?>
</div>
<?php
if((int)$view_id > 0){
?>
<div class="form-group" style='margin-bottom:10px;'>
<button class='btn btn-primary btn-sm' id="view_submit">Submit</button>
</div>
<?php
}
?>
<?php echo form_close(); ?>
<div id='view_block_list' style="padding:10px; !important; overflow: auto;">
<?php echo $view_block_list; ?>
</div>
</div>
<div class="tab-pane fade" id="view_map_columns" style="padding-top:10px;">
<?php echo form_open('report_setting/save_view_map_columns/' . $view_id,array('id'=>'save_view_map_columns','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'view_report_setting_id', 'id'=>'view_report_setting_id', 'type'=>'Hidden','value'=>$view_id));
echo form_label("Select View Block", 'view_map_block_id', array('class' => 'required'));
echo form_dropdown(array('name' => 'view_map_block_id','id' =>'view_map_block_id','class' => 'form-control input-sm'),$view_block_drop);
?>
</div>
<div id='view_map_columns_list' style='padding:8px;'>
</div>
<?php echo form_close(); ?>
</div>
<div class="tab-pane fade" id="view_custom_select" style="padding-top:10px;">
<?php echo form_open('report_setting/save_view_select/' . $view_id,array('id'=>'save_view_select','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_view_select_id', 'id'=>'prime_view_select_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'view_report_setting_id', 'id'=>'view_report_setting_id', 'type'=>'Hidden','value'=>$view_id));
echo form_label("Select View Block", 'view_block_id', array('class' => 'required'));
echo form_dropdown(array('name' => 'view_block_id','id' =>'view_block_id','class' => 'form-control input-sm'),$view_block_drop);
?>
</div>
<div class="form-group">
<?php
echo form_label("Custom Column Name", 'view_column_name', array('class' => 'required'));
echo form_input(array( 'name' => 'view_column_name', 'id' => 'view_column_name', 'class' => 'form-control input-sm', 'placeholder'=>"Custom Column Name",'value' => "",'style'=>'text-transform:lowercase;'));
?>
</div>
<div class="form-group">
<?php
echo form_label("Select Column", 'view_select_column', array('class' => ''));
echo form_input( array('name'=>'view_select_column_hidden', 'id'=>'view_select_column_hidden', 'type'=>'Hidden','value'=>''));
echo form_dropdown(array('name' => 'view_select_column','id' =>'view_select_column','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group" style="width:40% !important;margin-bottom: 0px !important;">
<textarea name='view_select_column_query' id='view_select_column_query'class='form-control' rows='4' placeholder='Query Column' style='text-transform:lowercase;'></textarea>
</div>
<?php
if((int)$view_id > 0){
?>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="view_select_submit">Submit</button>
</div>
<?php
}
?>
<?php echo form_close(); ?>
<div id='view_select_list' style="padding:10px; !important; overflow: auto;">
<?php echo $view_select_list;?>
</div>
</div>
<div class="tab-pane fade" id="view_table_join" style='padding:10px;'>
<div class="form-group" style='width:20%;'>
<?php
echo form_label("Select Table Block", 'table_block_id', array('class' => 'required'));
echo form_dropdown(array('name' => 'table_block_id','id' =>'table_block_id','class' => 'form-control input-sm'),$view_block_drop);
?>
</div>
<?php
echo form_open('report_setting/save_view_join_table/' . $view_id,array('id'=>'save_view_join_table','class'=>'form-inline'));
?>
<div id='view_table_join_content'>
</div>
<?php
echo form_close();
?>
</div>
<div class="tab-pane fade" id="view_table_where" style="padding-top:10px;">
<?php echo form_open('report_setting/save_view_table_where/' . $view_id,array('id'=>'save_view_table_where','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'where_report_id', 'id'=>'where_report_id', 'type'=>'Hidden','value'=>$view_id));
echo form_input( array('name'=>'view_query_type', 'id'=>'view_query_type', 'type'=>'Hidden','value'=>''));
echo form_label("Select View Block", 'view_where_block_id', array('class' => 'required'));
echo form_dropdown(array('name' => 'view_where_block_id','id' =>'view_where_block_id','class' => 'form-control input-sm'),$view_block_drop);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('query_column_list'), 'view_query_column_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'view_query_column_list','id' =>'view_query_column_list','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('picklist_type'), 'view_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' => 'view_picklist_type','id' =>'view_picklist_type','class' => 'form-control input-sm'), $query_type_array);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('pick_list'), 'view_pick_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'view_pick_list[]','multiple id' =>'view_pick_list','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('session_list'), 'view_session_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'view_session_list','id' =>'view_session_list','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<a class='btn btn-edit btn-sm' id="view_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='view_where_condition' id='view_where_condition'class='form-control' rows='4' placeholder='Write Condition with out where' style=' text-transform: lowercase;'>and </textarea>
</div>
<?php
if((int)$view_id > 0){
?>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="save_view_query_btn">Add/Update</button>
</div>
<?php
}
?>
</div>
<?php echo form_close(); ?>
<div id='view_where_list' style="padding:10px; !important; overflow: auto;">
<?php echo $view_where_list;?>
</div>
</div>
<div class="tab-pane fade" id="view_sort" style="padding:10px;background-color: #f2f2f2;">
<p style='color:#1883E9;text-align:center;'><i class="fa fa-hand-rock-o fa-2x" aria-hidden="true"></i> Drag and drop for align field postion</p>
<ul id="view_block_sortable" class='sortable'>
<?php
echo $view_block_sort_list;
?>
</ul>
</div>
<div class="tab-pane fade" id="view_table_sort" style="padding:10px;background-color: #f2f2f2;">
<p style='color:#1883E9;text-align:center;'><i class="fa fa-hand-rock-o fa-2x" aria-hidden="true"></i> Drag and drop for align field postion</p>
<?php
echo $table_sort_content;
?>
</div>
</div>
</div>
<!------------------------------------------------------------------>
<!---------------------- VIEW SETTING - END ------------------------>
<!------------------------------------------------------------------>
</div>
<script type="text/javascript">
$(document).ready(function(){
call_select();
<?php
echo $table_sort_script;
?>
/*================================================*/
/*============ REPORT SETTING - START ============*/
/*================================================*/
//COMMON SCRIPT
update_table_sort();
var prime_report_setting_id = $("#prime_report_setting_id").val();
var report_for = '<?php echo $report_for_val;?>';
if(report_for === ""){
$('#report_for option:selected').removeAttr('selected');
}
var report_tables = '<?php echo $report_tables_val;?>';
if(report_tables === ""){
$('#report_tables option:selected').removeAttr('selected');
}
var report_columns = '<?php echo $report_columns_val;?>';
if(report_columns === ""){
$('#report_columns option:selected').removeAttr('selected');
}
var report_group_by = '<?php echo $report_group_by_val;?>';
if(report_group_by === ""){
$('#report_group_by option:selected').removeAttr('selected');
}
var date_filter_column = '<?php echo $date_filter_column_val;?>';
if(date_filter_column === ""){
$('#date_filter_column option:selected').removeAttr('selected');
}
var subtotal_column = '<?php echo $subtotal_column_val;?>';
if(subtotal_column === ""){
$('#subtotal_column option:selected').removeAttr('selected');
}
var report_prime_column = '<?php echo $report_prime_column_val;?>';
if(report_prime_column === ""){
$('#report_prime_column option:selected').removeAttr('selected');
}
//SELECT ROLE
$("#select_all_role").click(function(){
if($("#select_all_role").is(':checked') ){
$("#report_for > option").prop("selected","selected");
$("#report_for").trigger("change");
}else{
$("#report_for > option").removeAttr("selected");
$("#report_for").trigger("change");
}
call_select();
});
//SAVE REPORT BASE INFO
$('#report_save').validate($.extend({
submitHandler: function (form){
$("#report_setting_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#report_setting_submit').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#report_setting_submit').attr('disabled',false);
$("#report_setting_submit").html("Submit");
if(response.success){
toastr.success(response.message);
table_support.refresh();
}else{
toastr.error(response.message);
}
//$('.modal').modal('toggle');
},
dataType: 'json'
});
},
rules:{
report_name: "required",
"report_for[]": "required",
"report_tables[]": "required",
"report_columns[]": "required",
"report_prime_column[]": "required",
search_filter: "required",
date_filter: "required",
}
}));
// GET COLUM LIST BASED ON TABLE SELECTED
$("#report_tables").change(function(){
var report_tables = $('#report_tables').val();
if(report_tables){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_table_column"); ?>',
data: {report_tables:report_tables},
success: function(data){
var rslt = JSON.parse(data);
if(rslt.success){
if(rslt.table_column){
var report_columns = $("#report_columns").val();
var report_group_by = $("#report_group_by").val();
var report_prime_column = $("#report_prime_column").val();
var date_filter_column = $("#date_filter_column").val();
$('#report_columns,#report_group_by,#date_filter_column,#report_prime_column,#query_column_list').empty();
var option = "";
$.each(rslt.table_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#report_columns,#report_group_by,#report_prime_column,#query_column_list').append(option);
var option = "";
$.each(rslt.date_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#date_filter_column').append(option);
$("#report_columns").val(report_columns);
$("#report_group_by").val(report_group_by);
$("#report_prime_column").val(report_prime_column);
$("#date_filter_column").val(date_filter_column);
}
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
});
//CUSTOM SELECT COMMON
$('#custom_column_name').on('keyup keypress', function(e) {
var custom_select_column = $('#custom_select_column').val();
var custom_column_name = $('#custom_column_name').val();
if((custom_column_name !== "") || (custom_select_column !== "")){
update_custom_select(false);
}
});
$('#custom_select_column').change(function(e){
update_custom_select(true);
});
$("#report_columns").change(function(){
update_total_subtotal_column();
});
//SAVE CUSTOM SELECT
$('#save_custom_select').validate($.extend({
submitHandler: function (form){
$("#custom_select_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#custom_select_submit').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#custom_select_submit').attr('disabled',false);
$("#custom_select_submit").html("Submit");
if(response.success){
toastr.success(response.message);
$("#custom_select_list").html(response.custom_select_list);
$("#table_view_list").html(response.table_view_list);
update_table_sort();
var subtotal_column_val = $("#subtotal_column").val();
$('#subtotal_column').empty();
var option = "";
$.each(response.subtotal_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#subtotal_column').append(option);
$("#subtotal_column").val(subtotal_column_val);
call_select();
}else{
toastr.error(response.message);
}
document.getElementById("save_custom_select").reset();
$("#prime_custom_select_id").val(0);
$('#custom_select_column_hidden').val("");
},
dataType: 'json'
});
},
rules:{
custom_column_name: "required",
select_column_query: "required",
}
}));
//SAVE TABLE JOIN
$('#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');
$(form).ajaxSubmit({
success: function (response){
$('#save_join_table_btn').attr('disabled',false);
$("#save_join_table_btn").html("Save");
toastr.success(response.message);
$('.modal').modal('toggle');
},
dataType: 'json'
});
}else{
toastr.error("Map all table join");
}
}
});
//SAVE TABLE WHERE
$('#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');
$(form).ajaxSubmit({
success: function (response){
$('#save_query_btn').attr('disabled',false);
$("#save_query_btn").html("Add/Update");
if(response.success){
toastr.success(response.message);
$('.modal').modal('toggle');
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
where_condition: {
required:true,
/*notEqual: true,*/
}
}
}));
// TABLE WHERE COMMON SETTING
$('#picklist_type,#pick_list,#session_list').parent().hide();
$("#query_column_list").change(function(){
query_column = $("#query_column_list").val();
if(query_column){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_column_info"); ?>',
data: {query_column:query_column},
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);
}
});
/*================================================*/
/*============ REPORT SETTING - END ============*/
/*================================================*/
/*================================================*/
/*============ VIEW SETTING - START ============*/
/*================================================*/
$('#view_for option:selected').removeAttr('selected');
$('#view_tables option:selected').removeAttr('selected');
$('#view_columns option:selected').removeAttr('selected');
$('#view_total_columns option:selected').removeAttr('selected');
//SELECT VIEW ROLE
$("#view_select_all_role").click(function(){
if($("#view_select_all_role").is(':checked') ){
$("#view_for > option").prop("selected","selected");
$("#view_for").trigger("change");
}else{
$("#view_for > option").removeAttr("selected");
$("#view_for").trigger("change");
}
call_select();
});
// CHART HIDE SHOW
$('#view_chart_size').parent().hide();
$("#view_chart").change(function(){
var view_chart = $('#view_chart').val();
if(view_chart === "1"){
$('#view_chart_size').parent().show();
}else{
$('#view_chart_size').parent().hide();
}
});
// GET COLUM LIST BASED ON VIEW TABLE SELECTED
$("#view_tables").change(function(){
var view_tables = $('#view_tables').val();
if(view_tables){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_table_column"); ?>',
data: {report_tables:view_tables},
success: function(data){
var rslt = JSON.parse(data);
if(rslt.success){
if(rslt.table_column){
var view_columns = $("#view_columns").val();
var view_total_columns = $("#view_total_columns").val();
$('#view_columns,#view_total_columns').empty();
var option = "";
$.each(rslt.table_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#view_columns,#view_total_columns').append(option);
$("#view_columns").val(view_columns);
$("#view_total_columns").val(view_total_columns);
}
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
});
//SAVE VIEW BASE INFO
$('#view_save').validate($.extend({
submitHandler: function (form){
$("#view_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#view_submit').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#view_submit').attr('disabled',false);
$("#view_submit").html("Submit");
if(response.success){
toastr.success(response.message);
table_support.refresh();
}else{
toastr.error(response.message);
}
$('.modal').modal('toggle');
},
dataType: 'json'
});
},
rules:{
view_name: "required",
"view_for[]": "required",
view_type: "required",
view_size: "required",
view_chart: "required",
"view_tables[]": "required",
}
}));
//VIEW BLOCK SORT
var view_idsInOrder = [];
$( "#view_block_sortable" ).sortable({
update: function( event, ui ){
view_idsInOrder = [];
$('#view_block_sortable li').each(function() {
view_idsInOrder.push($(this).attr('id'));
});
if(view_idsInOrder){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/update_view_sortorder"); ?>',
data: {view_idsInOrder:view_idsInOrder},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.message);
}
},
});
}
}
});
//VIEW MAP BLOCK ON CHANGE
$("#view_map_block_id").change(function(){
var view_map_block_id = $('#view_map_block_id').val();
if(view_map_block_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/update_map_block_column"); ?>',
data: {view_map_block_id:view_map_block_id},
success: function(data){
var rslt = JSON.parse(data);
if(rslt.success){
$("#view_map_columns_list").html(rslt.view_map_columns_list);
}else{
toastr.error(rslt.message);
}
},
});
}
});
//VIEW BLOCK ON CHANGE
$("#view_block_id").change(function(){
var view_block_id = $('#view_block_id').val();
if(view_block_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/update_view_select_column"); ?>',
data: {view_block_id:view_block_id},
success: function(data){
var rslt = JSON.parse(data);
if(rslt.success){
$('#view_select_column').empty();
var option = "";
$.each(rslt.view_select_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#view_select_column').append(option);
}else{
toastr.error(rslt.message);
}
},
});
}
});
//VIEW CUSTOM SELECT COMMON
$('#view_column_name').on('keyup keypress', function(e) {
var view_select_column = $('#view_select_column').val();
var view_column_name = $('#view_column_name').val();
if((view_column_name !== "") || (custom_select_column !== "")){
update_view_custom_select(false);
}
});
$('#view_select_column').change(function(e){
update_view_custom_select(true);
});
//SAVE CUSTOM SELECT
$('#save_view_map_columns').validate($.extend({
submitHandler: function (form){
$("#save_view_map_block_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_view_map_block_btn').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#save_view_map_block_btn').attr('disabled',false);
$("#save_view_map_block_btn").html("Submit");
if(response.success){
toastr.success(response.message);
$("#view_map_columns_list").html("");
}else{
toastr.error(response.message);
}
document.getElementById("save_view_map_columns").reset();
},
dataType: 'json'
});
},
rules:{
view_map_block_id: "required",
}
}));
//SAVE CUSTOM SELECT
$('#save_view_select').validate($.extend({
submitHandler: function (form){
$("#view_select_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#view_select_submit').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#view_select_submit').attr('disabled',false);
$("#view_select_submit").html("Submit");
if(response.success){
toastr.success(response.message);
$("#view_select_list").html(response.view_select_list);
}else{
toastr.error(response.message);
}
document.getElementById("save_view_select").reset();
$("#prime_view_select_id").val(0);
},
dataType: 'json'
});
},
rules:{
view_block_id: "required",
view_column_name: "required",
view_select_column_query: "required",
}
}));
//VIEW TABLE JOIN ON CHANGE
$("#table_block_id").change(function(){
var table_block_id = $('#table_block_id').val();
if(table_block_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/update_table_join_block"); ?>',
data: {table_block_id:table_block_id},
success: function(data){
var rslt = JSON.parse(data);
if(rslt.success){
$("#view_table_join_content").html(rslt.table_content);
}else{
toastr.error(rslt.message);
}
},
});
}
});
//SAVE VIEW TABLE JOIN
$('#save_view_join_table').validate({
submitHandler:function(form) {
var isValid = true;
$("select[name='view_line_prime_table[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='view_line_prime_col[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='view_line_join_type[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='view_line_join_table[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='view_line_join_col[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
if(isValid) {
$("#save_view_join_table_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_view_join_table_btn').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#save_view_join_table_btn').attr('disabled',false);
$("#save_view_join_table_btn").html("Save");
toastr.success(response.message);
$('.modal').modal('toggle');
},
dataType: 'json'
});
}else{
toastr.error("Map all table join");
}
}
});
//VIEW TABLE WHERE ON CHANGE
$("#view_where_block_id").change(function(){
var view_where_block_id = $('#view_where_block_id').val();
if(view_where_block_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/update_view_select_column"); ?>',
data: {view_block_id:view_where_block_id},
success: function(data){
var rslt = JSON.parse(data);
if(rslt.success){
$('#view_query_column_list').empty();
var option = "";
$.each(rslt.view_select_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#view_query_column_list').append(option);
}else{
toastr.error(rslt.message);
}
},
});
}
});
// VIEW TABLE WHERE COMMON SETTING
$('#view_picklist_type,#view_pick_list,#view_session_list').parent().hide();
$("#view_query_column_list").change(function(){
query_column = $("#view_query_column_list").val();
if(query_column){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_column_info"); ?>',
data: {query_column:query_column},
success: function(data) {
var rslt = JSON.parse(data);
$('#view_pick_list').empty();
$('#view_session_list').empty();
$('#view_picklist_type,#view_pick_list,#view_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>';
});
$('#view_pick_list').append(pick_option);
var session_option ="";
$.each(rslt.session_list, function( key, value ) {
session_option += '<option value="' + key + '">' + value + '</option>';
});
$('#view_session_list').append(session_option);
$('#view_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>';
});
$('#view_session_list').append(option);
$('#view_session_list').parent().show();
}
$("#view_query_type").val(rslt.type);
}else{
toastr.error(rslt.msg);
}
},
});
}
});
$("#view_picklist_type").change(function(){
$('#view_pick_list,#view_session_list').parent().hide();
picklist_type = $("#view_picklist_type").val();
if(picklist_type === "1"){
$('#view_pick_list').parent().show();
}else
if(picklist_type === "2"){
$('#view_session_list').parent().show();
}
call_select()
});
$("#view_apply_condition").click(function(){
query_column = $("#view_query_column_list").val();
query_type = $("#view_query_type").val();
var fill_val = "";
if(query_column){
if(query_type === "pick_list"){
picklist_type = $("#view_picklist_type").val();
if(picklist_type === "1"){
sub_value = $("#view_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 = $("#view_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 = $("#view_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 = $("#view_where_condition").val();
fill_val = where_condition +" "+fill_val;
$("#view_where_condition").val(fill_val);
}
});
//SAVE TABLE WHERE
$('#save_view_table_where').validate($.extend({
submitHandler: function (form){
$("#save_view_query_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_view_query_btn').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#save_view_query_btn').attr('disabled',false);
$("#save_view_query_btn").html("Add/Update");
if(response.success){
toastr.success(response.message);
$("#view_where_list").html(response.view_table_where_list);
document.getElementById("save_view_table_where").reset();
call_select();
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
view_where_condition: {
required:true,
/*notEqual: true,*/
}
}
}));
/*================================================*/
/*============ VIEW SETTING - END ============*/
/*================================================*/
});
function call_select(){
$(function(){
$('.select2').select2();
$('.select2-tags').select2({
tags: true,
tokenSeparators: [','],
});
});
}
/*================================================*/
/*============ REPORT SETTING - START ============*/
/*================================================*/
// GET TOTAL AND SUB TOTAL COLUMNS BASED ON SELECT
function update_total_subtotal_column(){
var prime_report_setting_id = $("#prime_report_setting_id").val();
var report_columns = $("#report_columns").val();
var subtotal_column_val = $("#subtotal_column").val();
if(report_columns){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/update_total_subtotal_column"); ?>',
data: {prime_report_setting_id:prime_report_setting_id,report_columns:report_columns},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#subtotal_column').empty();
var option = "";
$.each(rslt.total_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#subtotal_column').append(option);
$("#subtotal_column").val(subtotal_column_val);
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
}
//CUSTOM SELECT COLUMNS NAME WITH CONDITION
function update_custom_select(append_sts){
$('#select_column_query').val('');
var custom_select_column = $('#custom_select_column').val();
var custom_column_name = $('#custom_column_name').val();
if((custom_column_name === "") || (custom_column_name === "")){
toastr.error("Please Fill Required column name");
}else{
var custom_column_name = custom_column_name.replace(" ","_");
var select_column = "@"+custom_select_column+"@";
fill_val = $('#custom_select_column_hidden').val();
if(append_sts){
fill_val = fill_val + select_column;
$('#custom_select_column_hidden').val(fill_val);
}
if(fill_val){
$('#select_column_query').val("("+fill_val+") as "+custom_column_name);
}
}
}
//CUSTOM SELECT EDIT CALLBACK
function custom_select_edit(prime_custom_select_id){
if(prime_custom_select_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/custom_select_edit"); ?>',
data: {prime_custom_select_id:prime_custom_select_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#prime_custom_select_id").val(rslt.edit_result.prime_custom_select_id);
$("#custom_column_name").val(rslt.edit_result.custom_column_name);
$("#select_column_query").val(rslt.edit_result.select_column_query);
}else{
toastr.error(rslt.message);
}
},
});
}
}
//CUSTOM SELECT REMOVE CALLBACK
function custom_select_remove(prime_custom_select_id,custom_select_report_id){
if(confirm("Are you sure to delete!")){
if(prime_custom_select_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/custom_select_remove"); ?>',
data: {prime_custom_select_id:prime_custom_select_id,custom_select_report_id:custom_select_report_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#custom_select_list").html(rslt.custom_select_list);
$("#table_view_list").html(rslt.table_view_list);
toastr.success(rslt.message);
update_table_sort();
var subtotal_column_val = $("#subtotal_column").val();
$('#subtotal_column').empty();
var option = "";
$.each(rslt.subtotal_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#subtotal_column').append(option);
$("#subtotal_column").val(subtotal_column_val);
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
}
}
//UPDATE TABLE SORT
function update_table_sort(){
var table_idsInOrder = [];
$( "#report_sortable" ).sortable({
update: function( event, ui ){
table_idsInOrder = [];
$('#report_sortable th').each(function() {
table_idsInOrder.push($(this).attr('id'));
});
if(table_idsInOrder){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/table_sort_update"); ?>',
data: {table_idsInOrder:table_idsInOrder},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.message);
}
},
});
}
}
});
}
/*================================================*/
/*============ REPORT SETTING - END ============*/
/*================================================*/
/*================================================*/
/*============ VIEW BLOCK - START ============*/
/*================================================*/
function view_edit(prime_view_id){
if(prime_view_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/view_edit"); ?>',
data: {prime_view_id:prime_view_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#view_columns,#view_total_columns').empty();
var option = "";
$.each(rslt.view_columns, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#view_columns,#view_total_columns').append(option);
$.each(rslt.edit_result, function (index, value) {
if((index === "view_for") || (index === "view_tables") || (index === "view_columns") || (index === "view_total_columns")){
if(value){
var selectedOptions = value.split(",");
for(var i in selectedOptions) {
var optionVal = selectedOptions[i];
$("#"+index).find("option[value='"+optionVal+"']").prop("selected", "selected");
}
}
}else{
$("#"+index).val(value);
}
});
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
}
//CUSTOM SELECT REMOVE CALLBACK
function view_remove(prime_view_id,report_setting_id){
if(confirm("Are you sure to delete!")){
if(prime_view_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/view_remove"); ?>',
data: {prime_view_id:prime_view_id,report_setting_id:report_setting_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#view_block_list").html(rslt.view_block_list);
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
}
//CUSTOM SELECT COLUMNS NAME WITH CONDITION
function update_view_custom_select(append_sts){
$('#view_select_column_query').val('');
var view_select_column = $('#view_select_column').val();
var view_column_name = $('#view_column_name').val();
if((view_column_name !== "") || (view_select_column !== "")){
var view_column_name = view_column_name.replace(" ","_");
var select_column = "@"+view_select_column+"@";
fill_val = $('#view_select_column_hidden').val();
if(append_sts){
fill_val = fill_val + select_column;
$('#view_select_column_hidden').val(fill_val);
}
if(fill_val){
$('#view_select_column_query').val("("+fill_val+") as "+view_column_name);
}
}
}
//CUSTOM VIEW SELECT EDIT CALLBACK
function view_select_edit(prime_view_select_id){
if(prime_view_select_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/view_select_edit"); ?>',
data: {prime_view_select_id:prime_view_select_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#view_select_column').empty();
var option = "";
$.each(rslt.view_select_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#view_select_column').append(option);
$.each(rslt.edit_result, function (index, value) {
$("#"+index).val(value);
});
}else{
toastr.error(rslt.message);
}
},
});
}
}
//CUSTOM VIEW SELECT REMOVE CALLBACK
function view_select_remove(prime_view_select_id,view_report_setting_id){
if(confirm("Are you sure to delete!")){
if(prime_view_select_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/view_select_remove"); ?>',
data: {prime_view_select_id:prime_view_select_id,view_report_setting_id:view_report_setting_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#view_select_list").html(rslt.view_select_list);
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
}
//CUSTOM VIEW SELECT EDIT CALLBACK
function view_where_edit(prime_report_where_id){
if(prime_report_where_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/view_where_edit"); ?>',
data: {prime_report_where_id:prime_report_where_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#view_query_column_list').empty();
var option = "";
$.each(rslt.view_select_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#view_query_column_list').append(option);
$('#where_report_id').val(rslt.edit_result.where_report_id);
$('#view_where_block_id').val(rslt.edit_result.where_for_id);
$('#view_where_condition').val(rslt.edit_result.where_condition);
}else{
toastr.error(rslt.message);
}
},
});
}
}
//CUSTOM VIEW SELECT REMOVE CALLBACK
function view_where_remove(prime_report_where_id,where_report_id){
if(confirm("Are you sure to delete!")){
if(prime_report_where_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/view_where_remove"); ?>',
data: {prime_report_where_id:prime_report_where_id,where_report_id:where_report_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#view_where_list").html(rslt.view_table_where_list);
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
}
function update_table_sort_script(tr_id){
var table_idsInOrder = [];
$( '#'+tr_id ).sortable({
update: function( event, ui ){
table_idsInOrder = [];
$('#'+tr_id+' th').each(function() {
table_idsInOrder.push($(this).attr('id'));
});
if(table_idsInOrder){
$.ajax({
type: 'POST',
url: '<?php echo site_url($controller_name . '/update_view_table_sort'); ?>',
data: {table_idsInOrder:table_idsInOrder},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
});
}
/*================================================*/
/*============ VIEW BLOCK - END ============*/
/*================================================*/
</script>
<style>
div#total_sum > span{
width: 200px !important;
}
.second_nav_tab {
border-bottom: 1px solid #ecf0f1;
background-color: #1a242f;
display: flex;
white-space: nowrap;
overflow-x: auto;
overflow-y: hidden;
}
.second_nav_tab>li>a {
border-radius:0px;
}
.second_nav_tab>li>a:hover, .second_nav_tab>li>a:focus {
background-color: transparent;
color: #FFFFFF;
border: 0px !important;
}
</style>