File: /home/cafsindia/ntc_cafsinfotech_in/application/views/form_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;}
.select2-container--default .select2-selection--single {
border: 0px;
border-radius: 0px;
border-bottom: 1px solid #CCCCCC;
padding: 4px 5px;
display: none !important;
}
</style>
<ul class="nav nav-tabs" data-tabs="tabs">
<li class="active" role="presentation">
<a data-toggle="tab" href="#form_view">Form view layout</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#input_view">Input view layout</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#table_view">Table view layout</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#manage_formula">Manage Condition & Formula</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#add_formula">Add Condition & Formula</a>
</li>
</ul>
<div class="tab-content">
<div class="tab-pane fade in active" id="form_view">
<?php echo form_open('form_setting/add_ui/' . $prime_module_id,array('id'=>'add_ui_form','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_label($this->lang->line('form_view_label_name'), 'form_view_label_name', array('class' => 'required'));
echo form_input(array( 'name' => 'form_view_label_name', 'id' => 'form_view_label_name', 'class' => 'form-control input-sm', 'placeholder'=>$this->lang->line('form_view_label_name'),'value' => ''));
?>
</div>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_form_view_id', 'id'=>'prime_form_view_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'view_previous_val', 'id'=>'view_previous_val', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'prime_view_module_id', 'id'=>'prime_view_module_id', 'type'=>'Hidden','value'=>$prime_module_id));
echo form_label($this->lang->line('form_view_type'), 'form_view_type', array('class' => 'required'));
$form_view_type_array = array(""=>"---- Form view type ----",1=>"Block View",2=>"Tab View",3=>"Form with table");
echo form_dropdown(array( 'name' => 'form_view_type', 'id' => 'form_view_type', 'class' => 'form-control input-sm'), $form_view_type_array);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('form_view_type_mode'), 'form_view_type_mode', array('class' => 'required'));
$form_view_type_mode_array = array(""=>"---- Show In ----",1=>"Block View",2=>"Tab View");
echo form_dropdown(array( 'name' => 'form_view_type_mode', 'id' => 'form_view_type_mode', 'class' => 'form-control input-sm'), $form_view_type_mode_array);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('form_view_heading'), 'form_view_heading', array('class' => 'required'));
echo form_input(array( 'name' => 'form_view_heading', 'id' => 'form_view_heading', 'class' => 'form-control input-sm', 'placeholder'=>$this->lang->line('form_view_heading'),'value' => ''));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('form_view_for'), 'field_for', array('class' => 'required'));
echo form_dropdown(array('name' => 'form_view_for[]','multiple id' =>'form_view_for','class' => 'form-control input-sm select2'), $field_for);
echo "<label><input name='form_view_select' id='form_view_select' type='checkbox'> Select All</label>";
?>
</div>
<div class="form-group">
<label>
<input name='form_view_show' id='form_view_show' type="checkbox" checked> Show Form
</label>
</div>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="add_ui_submit">Add/Update</button>
<a class='btn btn-danger btn-sm' id="add_ui_cancel">Cancel</a>
</div>
<?php echo form_close(); ?>
<div style="padding:15px;background-color: #f2f2f2;" id="form_view_data">
<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_sortable" class='sortable'>
<?php
foreach($view_setting as $setting){
$count++;
$prime_form_view_id = $setting->prime_form_view_id;
$prime_view_module_id = $setting->prime_view_module_id;
$form_view_type = $setting->form_view_type;
$form_view_label_name = $setting->form_view_label_name;
$form_view_heading = ucwords($setting->form_view_heading);
$form_view_sort = $setting->form_view_sort;
$form_view_show = $setting->form_view_show;
$form_view_for = $setting->form_view_for;
$form_view_type = $form_view_type_array[$form_view_type];
$li_id = "li_".$prime_form_view_id;
$a_id = "a_".$prime_form_view_id."_$count";
$show_icon = "<i class='fa fa-eye-slash' aria-hidden='true'></i>";
if((int)$form_view_show === 1){
$show_icon = "<i class='fa fa-eye' aria-hidden='true'></i>";
}
echo "<li class='ui-state-default' id='$li_id'>
<table style='width:100%;'>
<tr>
<td style='font-weight:bold'>
<label>$form_view_heading</label><br/>
<span style='font-size:13px;font-weight:normal;color:#999999;'> $show_icon $form_view_type </span>
</td>
<td style='text-align:right;'>
<a id='$a_id' style='color:#1883E9;' onclick=get_view_info('$prime_form_view_id','$a_id');><i class='fa fa-pencil-square-o fa-2x' aria-hidden='true'></i></a>
</td>
</tr>
</table>
</li>";
}
?>
</ul>
</div>
</div>
<div class="tab-pane fade" id="input_view">
<?php echo form_open('form_setting/save/' . $prime_module_id,array('id'=>'form_setting_form','class'=>'form-inline')); ?>
<fieldset id="FundBasicInfo">
<?php
echo form_input( array('name'=>'prime_form_id', 'id'=>'prime_form_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'prime_module_id', 'id'=>'prime_module_id', 'type'=>'Hidden','value'=>$prime_module_id));
echo form_input( array('name'=>'common_table', 'id'=>'common_table', 'type'=>'Hidden','value'=>''));
?>
<div class="form-group">
<?php
echo form_label($this->lang->line('input_for'), 'input_for', array('class' => 'required'));
echo form_dropdown(array( 'name' => 'input_for', 'id' => 'input_for', 'class' => 'form-control input-sm'), $input_for);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('field_isdefault'), 'field_isdefault', array('class' => 'required'));
$field_isdefault = array(""=>"---- Is Default ----",1=>"Yes",2=>"No");
echo form_dropdown(array( 'name' => 'field_isdefault', 'id' => 'field_isdefault', 'class' => 'form-control input-sm'), $field_isdefault);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('field_type'), 'field_type', array('class' => 'required'));
$field_type_array = array(""=>"---- Field Type ----",1=>"Text",2=>"Decimals",3=>"Integer",4=>"Date",5=>"Picklist",6=>"Checkbox",7=>"Multi Picklist",8=>"summary box",9=>"Auto complete box",10=>"File upload box",11=>"Mobile Number",12=>"Email",13=>"Date & Time",14=>"Read Only");
echo form_dropdown(array( 'name' => 'field_type', 'id' => 'field_type', 'class' => 'form-control input-sm'), $field_type_array);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('label_name'), 'label_name', array('class' => 'required'));
echo form_input(array( 'name' => 'label_name', 'id' => 'label_name', 'class' => 'form-control input-sm', 'placeholder'=>$this->lang->line('label_name'),'value' => ''));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('view_name'), 'view_name', array('class' => 'required'));
echo form_input(array( 'name' => 'view_name', 'id' => 'view_name', 'class' => 'form-control input-sm', 'placeholder'=>$this->lang->line('view_name'),'value' => ''));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('short_name'), 'short_name', array('class' => 'required'));
echo form_input(array( 'name' => 'short_name', 'id' => 'short_name', 'class' => 'form-control input-sm', 'placeholder'=>$this->lang->line('short_name'),'value' => ''));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('field_length'), 'field_length', array('class' => 'required'));
echo form_input(array( 'name' => 'field_length', 'id' => 'field_length', 'class' => 'form-control input-sm', 'placeholder'=>$this->lang->line('field_length'),'value' => ''));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('field_decimals'), 'field_decimals', array('class' => 'required'));
echo form_input(array( 'name' => 'field_decimals', 'id' => 'field_decimals', 'class' => 'form-control input-sm', 'placeholder'=>$this->lang->line('field_decimals'),'value' => ''));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('pick_list_type'), 'pick_list_type', array('class' => 'required'));
$pick_list_type = array(""=>"--- Select pick list type ---","1"=>"From table","2"=>"Add new pick list");
echo form_dropdown(array( 'name' => 'pick_list_type', 'id' =>'pick_list_type', 'class' => 'form-control input-sm'), $pick_list_type);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('pick_table'), 'pick_table', array('class' => 'required'));
echo form_dropdown(array( 'name' => 'pick_table', 'id' => 'pick_table', 'class' => 'form-control input-sm'), $table_list);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('pick_table_col'), 'pick_table_col', array('class' => 'required'));
$pick_table_col = array(""=>"--- Pick list value ---");
echo form_dropdown(array( 'name' => 'pick_table_col[]', 'multiple id' =>'pick_table_col', 'class' => 'form-control input-sm'), $pick_table_col);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('auto_prime_id'), 'auto_prime_id', array('class' => 'required'));
$pick_table_col = array(""=>"--- Auto prime id column ---");
echo form_dropdown(array( 'name' => 'auto_prime_id', 'id' =>'auto_prime_id', 'class' => 'form-control input-sm'), $pick_table_col);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('auto_dispaly_value'), 'auto_dispaly_value', array('class' => 'required'));
$pick_table_col = array(""=>"--- Auto display column ---");
echo form_dropdown(array( 'name' => 'auto_dispaly_value', 'id' =>'auto_dispaly_value', 'class' => 'form-control input-sm'), $pick_table_col);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('pick_list'), 'pick_list', array('class' => 'required'));
$pick_list = array();
echo form_dropdown(array( 'name' => 'pick_list[]', 'multiple id' =>'pick_list', 'class' => 'form-control input-sm select2_user'), $pick_list);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('default_value'), 'default_value', array('class' => ''));
echo form_input(array( 'name' => 'default_value', 'id' => 'default_value', 'class' => 'form-control input-sm', 'placeholder'=>$this->lang->line('default_value'),'value' => ''));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('file_type'), 'file_type', array('class' => 'required'));
$file_type = array(""=> "--- File type ----",".pdf,.xls,.xlsx,.csv,.docx,.txt" => "Document","audio/*" => "Audio","image/*" => "Image");
echo form_dropdown(array('name' => 'file_type',' id' =>'file_type','class' => 'form-control input-sm'), $file_type);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('field_for'), 'field_for', array('class' => 'required'));
echo form_dropdown(array('name' => 'field_for[]','multiple id' =>'field_for','class' => 'form-control input-sm select2'), $field_for);
echo "<label><input name='field_for_select' id='field_for_select' type='checkbox'> Select All</label>";
?>
</div>
<div class="form-group" style='display:inline-grid;' id="checkbox_group_div">
<label>
<input name='mandatory_field' id='mandatory_field' type="checkbox"> Mandatory Field
</label>
<label>
<input name='unique_field' id='unique_field' type="checkbox"> Unique Field
</label>
<label>
<input name='field_show' id='field_show' type="checkbox" checked> Show Field
</label>
<label>
<input name='edit_read' id='edit_read' type="checkbox"> Edit Readonly
</label>
<label>
<input name='table_show' id='table_show' type="checkbox"> Show Table View
</label>
<label>
<input name='search_show' id='search_show' type="checkbox"> Show Search Filter
</label>
</div>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="submit">Add/Update</button>
<a class='btn btn-danger btn-sm' id="form_setting_cancel">Cancel</a>
</div>
</fieldset>
<?php echo form_close(); ?>
<div style="padding:15px;background-color: #f2f2f2;" id="input_view_data">
<?php
$form_view_rslt = json_decode($update_form_viewui);
$view_content = $form_view_rslt->view_content;
$id_array = $form_view_rslt->id_array;
$view_input_count = $form_view_rslt->view_input_count;
echo $view_content;
?>
</div>
</div>
<div class="tab-pane fade" id="table_view">
<div style="padding:15px;background-color: #f2f2f2;" id="table_view_data">
<?php
$table_view_rslt = json_decode($update_table_viewui);
$table_content = $table_view_rslt->table_content;
echo $table_content;
?>
</div>
</div>
<div class="tab-pane fade" id="manage_formula">
<?php echo form_open('form_setting/condition_formula/' . $prime_module_id,array('id'=>'condition_formula','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_cond_id', 'id'=>'prime_cond_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'cond_module_id', 'id'=>'cond_module_id', 'type'=>'Hidden','value'=>$prime_module_id));
echo form_label($this->lang->line('condition_label_name'), 'condition_label_name', array('class' => 'required'));
echo form_input(array( 'name' => 'condition_label_name', 'id' => 'condition_label_name', 'class' => 'form-control input-sm', 'placeholder'=>$this->lang->line('condition_label_name'),'value' => ''));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('condition_type'), 'condition_type', array('class' => 'required'));
$condition_type = array(''=>"--- Condition Type ---",1=>"From Table",2=>"Write Condition");
echo form_dropdown(array('name' => 'condition_type','id' =>'condition_type','class' => 'form-control input-sm'), $condition_type);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('condition_for'), 'condition_for', array('class' => 'required'));
echo form_dropdown(array('name' => 'condition_for[]','multiple id' =>'condition_for','class' => 'form-control input-sm select2'), $field_for);
echo "<label><input name='condition_for_select' id='condition_for_select' type='checkbox'> Select All</label>";
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('condition_check_form'), 'condition_check_form', array('class' => 'required'));
echo form_dropdown(array('name' => 'condition_check_form[]','multiple id' =>'condition_check_form','class' => 'form-control input-sm select2'), $column_list);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('condition_bind_to'), 'condition_bind_to', array('class' => 'required'));
echo form_dropdown(array('name' => 'condition_bind_to[]','multiple id' =>'condition_bind_to','class' => 'form-control input-sm select2'), $column_list);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('condition_table'), 'condition_table', array('class' => 'required'));
$condition_table = array(''=>"--- Condition Table ---",1=>"From Table",2=>"Write Condition");
echo form_dropdown(array('name' => 'condition_table[]','multiple id' =>'condition_table','class' => 'form-control input-sm select2'), $table_list);
?>
</div>
<div class="form-group">
<label>
<input name='is_drop_down' id='is_drop_down' type="checkbox">Is Drop down based condition
</label>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('cond_drop_down'), 'cond_drop_down', array('class' => 'required'));
echo form_dropdown(array('name' => 'cond_drop_down','id' =>'cond_drop_down','class' => 'form-control input-sm'), $column_list);
?>
</div>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="cond_submit">Add/Update</button>
<a class='btn btn-danger btn-sm' id="cond_cancel">Cancel</a>
</div>
<?php echo form_close(); ?>
<div style="padding:15px;" id="cond_view_data">
<?php
echo $cond_content;
?>
</div>
</div>
<div class="tab-pane fade" id="add_formula">
<?php echo form_open('form_setting/get_add_cond_info/' . $prime_module_id,array('id'=>'get_add_cond_info','class'=>'form-inline','style'=>'background-color: #f2f2f2; padding: 8px 0px;')); ?>
<div class="form-group">
<?php
echo form_label($this->lang->line('add_cond_content'), 'add_cond_content', array('class' => 'required'));
echo form_dropdown(array( 'name' => 'add_cond_content', 'id' => 'add_cond_content', 'class' => 'form-control input-sm'), $add_cond_content);
echo form_input( array('name'=>'add_cond_module_id', 'id'=>'add_cond_module_id', 'type'=>'Hidden','value'=>$prime_module_id));
?>
</div>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="view_cond_submit" style='margin-top:20px;'>View</button>
</div>
<?php echo form_close(); ?>
<?php echo form_open('form_setting/add_condition_formula/' . $prime_module_id,array('id'=>'add_condition_formula','class'=>'form-inline')); ?>
<!-- LOAD CONTENT FROM CONTROLLER -->
<?php echo form_close(); ?>
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){
empty_all();
call_select();
call_sort();
$("#form_view_select").click(function(){
if($("#form_view_select").is(':checked') ){
$("#form_view_for > option").prop("selected","selected");
$("#form_view_for").trigger("change");
}else{
$("#form_view_for > option").removeAttr("selected");
$("#form_view_for").trigger("change");
}
//$("#menu_for>option[value='']").removeAttr("selected");
});
$("#field_for_select").click(function(){
if($("#field_for_select").is(':checked') ){
$("#field_for > option").prop("selected","selected");
$("#field_for").trigger("change");
}else{
$("#field_for > option").removeAttr("selected");
$("#field_for").trigger("change");
}
//$("#menu_for>option[value='']").removeAttr("selected");
});
$("#condition_for_select").click(function(){
if($("#condition_for_select").is(':checked') ){
$("#condition_for > option").prop("selected","selected");
$("#condition_for").trigger("change");
}else{
$("#condition_for > option").removeAttr("selected");
$("#condition_for").trigger("change");
}
//$("#menu_for>option[value='']").removeAttr("selected");
});
$.validator.addMethod("alphanumeric", function(value, element) {
return this.optional(element) || /^[a-zA-Z0-9 ]*$/i.test(value);
}, "Must contain only letters and numbers");
$.validator.addMethod("space_check", function(value, element) {
return this.optional(element) || /^(\w+\s?)*\s*$/i.test(value);
}, "Must contain single space");
/* INPUT FORM SORTABLE - START */
<?php
foreach($id_array as $id){
$site_url = site_url($controller_name . '/update_sortorder');
$id_info = $id;
$ul_id = "#$id";
$li_id = "#$id li";
echo "var idsInOrder = [];\n
$('$ul_id').sortable({
update: function( event, ui ){
idsInOrder = [];
$('$li_id').each(function() {
idsInOrder.push($(this).attr('id'));
});
if(idsInOrder){
prime_module_id = $('#prime_module_id').val();
$.ajax({
type: 'POST',
url: '$site_url',
data: {idsInOrder:idsInOrder,id_info:'$id_info'},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.message);
}
},
});
}
}
});\n";
}
?>
/* INPUT FORM SORTABLE - END */
/* VIEW SORTABLE - START */
var view_idsInOrder = [];
$( "#view_sortable" ).sortable({
update: function( event, ui ){
view_idsInOrder = [];
$('#view_sortable li').each(function() {
view_idsInOrder.push($(this).attr('id'));
});
if(view_idsInOrder){
prime_view_module_id = $("#prime_view_module_id").val();
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/update_view_sortorder"); ?>',
data: {view_idsInOrder:view_idsInOrder,prime_view_module_id:prime_view_module_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.message);
}
},
});
}
}
});
/* VIEW SORTABLE - END */
/* TABLE SORTABLE - START */
var table_idsInOrder = [];
$( "#table_sortable" ).sortable({
update: function( event, ui ){
table_idsInOrder = [];
$('#table_sortable th').each(function() {
table_idsInOrder.push($(this).attr('id'));
});
if(table_idsInOrder){
prime_module_id = $("#prime_module_id").val();
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/update_table_sortorder"); ?>',
data: {table_idsInOrder:table_idsInOrder,prime_module_id:prime_module_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
toastr.success(rslt.message);
}
},
});
}
}
});
/* TABLE SORTABLE - END */
/* VIEW FORM VIDATION - START */
$('#add_ui_form').validate($.extend({
submitHandler: function (form){
$("#add_ui_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#add_ui_submit').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#form_view_label_name').attr('readonly', false);
$('#add_ui_submit').attr('disabled',false);
$("#add_ui_submit").html("Add/Update");
call_sort();
empty_all_view();
if(response.success){
$("#form_view_data").html(response.view_setting);
toastr.success(response.msg);
$('.modal').modal('hide');
}else{
toastr.error(response.msg);
}
},
dataType: 'json'
});
},
rules:{
form_view_type: "required",
form_view_label_name: {
required: true,
alphanumeric:true,
space_check:true,
},
form_view_heading: {
required: true,
alphanumeric:true,
space_check:true,
},
"form_view_for[]": "required",
}
}));
$("#add_ui_cancel").click(function(){
$('#form_view_label_name').attr('readonly', false);
$('#add_ui_submit').attr('disabled',false);
$("#add_ui_submit").html("Add/Update");
empty_all_view();
});
/* INPUT FORM VIDATION - START */
$('#form_setting_form').validate($.extend({
submitHandler: function (form){
$("#submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#submit').attr('disabled','disabled');
var field_type = $("#field_type").val();
if((field_type === "2") || (field_type === "3") || (field_type === "5") || (field_type === "6") || (field_type === "7")){
var default_value = $("#default_value").val();
if(default_value === ""){
$('#submit').attr('disabled',false);
$("#submit").html("Submit");
toastr.error("Please enter default value atleast 0");
return false;
}
}
$(form).ajaxSubmit({
success: function(response){
$('#submit').attr('disabled',false);
$("#submit").html("Add/Update");
if(response.success){
var from_rslt = JSON.parse(response.form_setting);
$("#input_view_data").html(from_rslt.view_content);
var table_rslt = JSON.parse(response.table_setting);
$("#table_view_data").html(table_rslt.table_content);
toastr.success(response.msg);
<?php
if((int)$view_input_count === 0){
echo "$('.modal').modal('hide');\n";
}
?>
}else{
toastr.error(response.msg);
if(response.frm !== "exist"){
$('.modal').modal('hide');
}
}
$('#field_type').attr('readonly', false);
$('#label_name').attr('readonly', false);
$('#field_isdefault').attr('readonly', false);
$("#input_for").val("");
$("#prime_form_id").val(0);
$("#field_isdefault").val("");
$("#field_type").val("");
call_select();
call_sort();
empty_all();
},
dataType: 'json'
});
},
rules:{
file_type: "required",
input_for: "required",
field_isdefault: "required",
field_type: "required",
label_name: {
required: true,
alphanumeric:true,
space_check:true,
},
view_name: {
required: true,
alphanumeric:true,
space_check:true,
},
pick_list_type: "required",
pick_table: "required",
"field_for[]": "required",
"pick_list[]": "required",
field_length:{
required: true,
number: true,
range:[10,255],
},
field_decimals:{
required: true,
number: true,
range:[2,5],
},
"pick_table_col[]":{
required: true,
minlength: 2,
maxlength: 4,
}
},
messages: {
"pick_table_col[]": "Select Atleast 2 options",
}
}));
$("#form_setting_cancel").click(function(){
$('#field_type').attr('readonly', false);
$('#label_name').attr('readonly', false);
$('#field_isdefault').attr('readonly', false);
$("#input_for").val("");
$('#submit').attr('disabled',false);
$("#submit").html("Add/Update");
$("#prime_form_id").val(0);
$("#field_isdefault").val("");
$("#field_type").val("");
call_select();
empty_all();
});
$('#condition_formula').validate($.extend({
submitHandler: function (form){
$("#cond_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#cond_submit').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#cond_submit').attr('disabled',false);
$("#cond_submit").html("Add/Update");
update_condition_ui(0);
empty_all_cond();
if(response.success){
$("#cond_view_data").html(response.cond_content);
toastr.success(response.msg);
$('.modal').modal('hide');
}else{
toastr.error(response.msg);
}
},
dataType: 'json'
});
},
rules:{
condition_label_name: "required",
condition_type: "required",
"condition_for[]": "required",
"condition_check_form[]": "required",
"condition_bind_to[]": "required",
"condition_table[]": "required",
cond_drop_down: "required",
cond_drop_down_val: "required",
}
}));
$('#get_add_cond_info').validate($.extend({
submitHandler: function (form){
$("#view_cond_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#view_cond_submit').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$("#add_condition_formula").html(response.load_content);
$('#view_cond_submit').attr('disabled',false);
$("#view_cond_submit").html("View");
},
dataType: 'json'
});
},
rules:{
add_cond_content: "required",
}
}));
$('#add_condition_formula').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');
}
});
$("select[name='line_input_for_table[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='line_input_for_col[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='line_input_bind_col[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='line_input_bind_col[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
if(isValid) {
$("#add_cond_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#add_cond_submit').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#add_cond_submit').attr('disabled',false);
$("#add_cond_submit").html("Add/Update");
toastr.success("Mapping successfully added");
$("#add_condition_formula").html("");
$("#add_cond_content").val("");
$('.modal').modal('hide');
},
dataType: 'json'
});
}else{
toastr.error("Map all input and table");
}
}
});
$("#cond_cancel").click(function(){
empty_all_cond();
update_condition_ui("");
});
/* INPUT FORM VIDATION - END */
/* ONCHANGE EVENTS - START */
$('#form_view_type_mode').parent().hide();
$("#form_view_type").change(function(){
view_previous_val = $("#view_previous_val").val();
form_view_type = $("#form_view_type").val();
prime_form_view_id = $("#prime_form_view_id").val();
if(form_view_type === "3"){
$('#form_view_type_mode').parent().show();
}else{
$('#form_view_type_mode').parent().hide();
}
if(view_previous_val === "3"){
if(prime_form_view_id !== 0){
$('#form_view_type').val(view_previous_val);
toastr.error("Can't change to Tab or Block view");
}
}else
if((view_previous_val === "1") || (view_previous_val === "2")){
if(form_view_type === "3"){
$('#form_view_type').val(view_previous_val);
toastr.error("Can't change to From with table view");
}
}
});
$("#field_type").change(function(){
field_type = $("#field_type").val();
update_ui(field_type);
});
$("#pick_list_type").change(function(){
pick_list_type = $("#pick_list_type").val();
update_pick_ui(pick_list_type);
});
$("#pick_table").change(function(){
pick_table = $("#pick_table").val();
field_type = $("#field_type").val();
if(pick_table){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_table_info"); ?>',
data: {pick_table:pick_table},
success: function(data) {
var rslt = JSON.parse(data);
$('#pick_table_col').empty();
var option ="";
for(i = 0; i < rslt.colums_list.length; i++) {
key = rslt.colums_list[i].key;
value = rslt.colums_list[i].value;
option += '<option value="' + key + '">' + value + '</option>';
}
$('#pick_table_col').parent().show();
$('#pick_table_col').append(option);
if(field_type === "9"){
$('#auto_prime_id').empty();
$('#auto_prime_id').append(option);
$('#auto_prime_id').parent().show();
$('#auto_dispaly_value').empty();
$('#auto_dispaly_value').append(option);
$('#auto_dispaly_value').parent().show();
}
},
});
}
});
$('#condition_check_form,#condition_bind_to,#condition_for,#condition_table,#is_drop_down,#cond_drop_down,#cond_drop_down_val,#cond_submit').parent().hide();
$("#condition_type").change(function(){
condition_type = $("#condition_type").val();
update_condition_ui(condition_type);
});
$('#is_drop_down').change(function () {
$('#cond_drop_down').parent().hide();
$("#cond_drop_down").val();
if($('input[name="is_drop_down"]').is(':checked')){
$('#cond_drop_down').parent().show();
}
});
/* ONCHANGE EVENTS - END */
});
// SELECT2 UI UPDATE
function call_select(){
$(function(){
$('.select2').select2();
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
$(".select2_user").select2({
tags: true
});
});
}
/* COMMON SORTABLE - START */
function call_sort(){
var id_array = "<?php echo $id_array?>";
$(function(){
$( "#view_sortable" ).sortable();
$( "#view_sortable" ).disableSelection();
$( "#table_sortable" ).sortable();
$( "#table_sortable" ).disableSelection();
<?php
foreach($id_array as $id){
echo "$('#$id').sortable();\n $('#$id').disableSelection();\n";
}
?>
});
}
// EMPTY ALL INPUT
function empty_all(){
call_select();
$("#prime_form_id").val(0);
$("#label_name").val("");
$("#view_name").val("");
$("#short_name").val("");
$("#field_length").val("");
$("#field_decimals").val("");
$("#pick_list_type").val("");
$("#pick_table").val("");
$("#pick_table_col").val("");
$("#pick_list").val("");
$("#default_value").val("");
$("#file_type").val("");
$("#auto_prime_id").val("");
$("#auto_dispaly_value").val("");
$('#mandatory_field').prop('checked', false);
$('#unique_field').prop('checked', false);
$('#edit_read').prop('checked', true);
$('#field_show').prop('checked', true);
$('#table_show').prop('checked', false);
$('#search_show').prop('checked', false);
$('#field_for option:selected').removeAttr('selected');
$('#label_name,#view_name,#short_name,#field_length,#field_decimals,#pick_list_type,#pick_table,#pick_table_col,#pick_list,#default_value,#field_for,#file_type,#auto_prime_id,#auto_dispaly_value').parent().hide();
$('#checkbox_group_div').hide();
}
function empty_all_view(){
$("#form_view_for").val("");
call_select();
$("#prime_form_view_id").val(0);
$("#form_view_type").val("");
$("#form_view_label_name").val("");
$("#form_view_heading").val("");
$("#form_view_sort").val("");
$('#form_view_show').prop('checked', true);
$('#form_view_for option:selected').removeAttr('selected');
}
// UPDATE UI BASED ON FIELD TYPE
function update_ui(field_type){
empty_all();
//TEXT,INTEGER
if((field_type === "1") || (field_type === "3") || (field_type === "11") || (field_type === "12") || (field_type === "14")){
$('#label_name,#view_name,#short_name,#field_length,#default_value,#field_for').parent().show();
$('#checkbox_group_div').show();
}else
//DECIMALS
if(field_type === "2"){
$('#label_name,#view_name,#short_name,#field_decimals,#default_value,#field_for').parent().show();
$('#checkbox_group_div').show();
}else
//DATE,CHECKBOX,SUMMARY
if((field_type === "4") || (field_type === "6") || (field_type === "8")|| (field_type === "13")){
$('#label_name,#view_name,#short_name,#default_value,#field_for').parent().show();
$('#checkbox_group_div').show();
}else
//DATE,CHECKBOX,SUMMARY
if((field_type === "5") || (field_type === "7")){
$('#label_name,#view_name,#short_name,#pick_list_type,#default_value,#field_for').parent().show();
$('#checkbox_group_div').show();
}else
//AUTO COMPLETE
if(field_type === "9"){
$('#label_name,#view_name,#short_name,#pick_table,#default_value,#field_for').parent().show();
$('#checkbox_group_div').show();
}else
//FILE UPLOAD
if(field_type === "10"){
$('#label_name,#view_name,#short_name,#default_value,#field_for,#file_type').parent().show();
$('#checkbox_group_div').show();
}else{
$('#label_name,#view_name,#short_name,#field_length,#field_decimals,#pick_list_type,#pick_table,#pick_table_col,#pick_list,#default_value,#field_for,#file_type,#auto_prime_id,#auto_dispaly_value').parent().hide();
$('#checkbox_group_div').hide();
}
call_select();
}
// UPDATE UI BASED ON PICK LIST TYPE
function update_pick_ui(pick_list_type){
if(pick_list_type === "1"){
$('#pick_table_col,#pick_list').parent().hide();
$('#pick_table').parent().show();
}else
if(pick_list_type === "2"){
$('#pick_table,#pick_table_col').parent().hide();
$('#pick_list').parent().show();
}
call_select();
}
// FORM EDIT OPERATION FOR ALL
function get_field_info(prime_form_id,a_id){
prime_module_id = $("#prime_module_id").val();
$("#"+a_id).html("<i class='fa fa-spinner fa-spin fa-2x' style='color:#CC3366'></i>");
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_field_info"); ?>',
data: {prime_module_id:prime_module_id,prime_form_id:prime_form_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
update_ui(rslt.field_type);
update_pick_ui(rslt.pick_list_type);
update_field_info(rslt);
}
$("#"+a_id).html("<i class='fa fa-pencil-square-o fa-2x' aria-hidden='true'></i>");
},
});
}
// FORM UPDATE INPUT WITH VALUE FOR ALL
function update_field_info(rslt){
if(rslt){
$("#prime_form_id").val(rslt.field_info.prime_form_id);
$("#prime_module_id").val(rslt.field_info.prime_module_id);
$("#input_for").val(rslt.field_info.input_for);
$("#field_type").val(rslt.field_info.field_type);
$("#label_name").val(rslt.field_info.label_name);
$("#view_name").val(rslt.field_info.view_name);
$("#short_name").val(rslt.field_info.short_name);
$("#field_length").val(rslt.field_info.field_length);
$("#field_decimals").val(rslt.field_info.field_decimals);
$("#field_isdefault").val(rslt.field_info.field_isdefault);
$("#default_value").val(rslt.field_info.default_value);
$("#pick_list_type").val(rslt.field_info.pick_list_type);
$("#common_table").val(rslt.field_info.pick_table);
$("#file_type").val(rslt.field_info.file_type);
$('#mandatory_field').prop('checked', false);
if(rslt.field_info.mandatory_field === "1"){
$('#mandatory_field').prop('checked', true);
}
$('#unique_field').prop('checked', false);
if(rslt.field_info.unique_field === "1"){
$('#unique_field').prop('checked', true);
}
$('#field_show').prop('checked', false);
if(rslt.field_info.field_show === "1"){
$('#field_show').prop('checked', true);
}
$('#edit_read').prop('checked', false);
if(rslt.field_info.edit_read === "1"){
$('#edit_read').prop('checked', true);
}
$('#table_show').prop('checked', false);
if(rslt.field_info.table_show === "1"){
$('#table_show').prop('checked', true);
}
$('#search_show').prop('checked', false);
if(rslt.field_info.search_show === "1"){
$('#search_show').prop('checked', true);
}
if((rslt.field_info.pick_list_type === "1") || (rslt.field_info.field_type === "9")){
$("#pick_table").val(rslt.field_info.pick_table);
var option = "";
for(i = 0; i < rslt.colums_list.length; i++) {
key = rslt.colums_list[i].key;
value = rslt.colums_list[i].value;
option += '<option value="' + key + '">' + value + '</option>';
}
$('#pick_table_col').empty();
$('#pick_table_col').append(option);
$('#pick_table_col').parent().show();
if(rslt.field_info.field_type === "9"){
$('#auto_prime_id').empty();
$('#auto_prime_id').append(option);
$('#auto_prime_id').parent().show();
$("#auto_prime_id").val(rslt.field_info.auto_prime_id);
$('#auto_dispaly_value').empty();
$('#auto_dispaly_value').append(option);
$('#auto_dispaly_value').parent().show();
$("#auto_dispaly_value").val(rslt.field_info.auto_dispaly_value);
}
var selectedOptions = rslt.field_info.pick_list.split(",");
for(var i in selectedOptions) {
var optionVal = selectedOptions[i];
$("#pick_table_col").find("option[value='"+optionVal+"']").prop("selected", "selected");
}
}else{
if(rslt.field_info.pick_list){
$('#pick_list').empty();
var selectedOptions = rslt.field_info.pick_list.split(",");
for(var i in selectedOptions) {
var optionVal = selectedOptions[i];
$('#pick_list').append('<option value="' + optionVal + '">' + optionVal + '</option>');
$("#pick_list").find("option[value='"+optionVal+"']").prop("selected", "selected");
}
}
}
var field_for_options = rslt.field_info.field_for.split(',');
for(var i in field_for_options) {
var optionVal = field_for_options[i];
$("#field_for").find("option[value='"+optionVal+"']").prop("selected", "selected");
}
$('#field_isdefault').attr('readonly', 'true');
$('#field_type').attr('readonly', 'true');
$('#label_name').attr('readonly', 'true');
call_select();
}
}
// VIEW EDIT OPERATION FOR ALL
function get_view_info(prime_form_view_id,a_id){
prime_view_module_id = $("#prime_view_module_id").val();
$("#"+a_id).html("<i class='fa fa-spinner fa-spin fa-2x' style='color:#CC3366'></i>");
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_view_info"); ?>',
data: {prime_view_module_id:prime_view_module_id,prime_form_view_id:prime_form_view_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
update_view_info(rslt);
form_view_type = $("#form_view_type").val();
if(form_view_type === "3"){
$('#form_view_type_mode').parent().show();
}else{
$('#form_view_type_mode').parent().hide();
}
}
$("#"+a_id).html("<i class='fa fa-pencil-square-o fa-2x' aria-hidden='true'></i>");
},
});
}
// UPDATE CONDITION UI
function empty_all_cond(){
$("#prime_cond_id").val(0);
$("#condition_label_name").val("");
$("#condition_type").val("");
$("#condition_for").val("");
$("#condition_check_form").val("");
$("#condition_bind_to").val("");
$("#condition_table").val("");
$('#condition_for option:selected').removeAttr('selected');
$('#condition_check_form option:selected').removeAttr('selected');
$('#condition_bind_to option:selected').removeAttr('selected');
$('#condition_table option:selected').removeAttr('selected');
$('#is_drop_down').prop('checked', true);
$("#cond_drop_down").val("");
call_select();
}
function update_condition_ui(condition_type){
$('#condition_check_form,#condition_bind_to,#condition_for,#condition_table,#is_drop_down,#cond_drop_down,#cond_submit').parent().hide();
if(condition_type === "1"){
$('#condition_check_form,#condition_bind_to,#condition_for,#condition_table,#cond_submit').parent().show();
}else
if(condition_type === "2"){
$('#condition_check_form,#condition_bind_to,#condition_for,#is_drop_down,#cond_submit').parent().show();
}
call_select();
}
// FORM UPDATE INPUT WITH VALUE FOR ALL
function update_view_info(rslt){
if(rslt){
$("#prime_form_view_id").val(rslt.view_info.prime_form_view_id);
$("#prime_view_module_id").val(rslt.view_info.prime_view_module_id);
$("#form_view_type").val(rslt.view_info.form_view_type);
$("#form_view_type_mode").val(rslt.view_info.form_view_type_mode);
$("#view_previous_val").val(rslt.view_info.form_view_type);
$("#form_view_label_name").val(rslt.view_info.form_view_label_name);
$("#form_view_heading").val(rslt.view_info.form_view_heading);
$("#form_view_sort").val(rslt.view_info.form_view_sort);
$('#form_view_show').prop('checked', false);
if(rslt.view_info.form_view_show === "1"){
$('#form_view_show').prop('checked', true);
}
var field_for_options = rslt.view_info.form_view_for.split(',');
for(var i in field_for_options) {
var optionVal = field_for_options[i];
$("#form_view_for").find("option[value='"+optionVal+"']").prop("selected", "selected");
}
$('#form_view_label_name').attr('readonly', 'true');
call_select();
}
}
function get_cond_info(prime_cond_id){
cond_module_id = $("#cond_module_id").val();
if(prime_cond_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_cond_info"); ?>',
data: {prime_cond_id:prime_cond_id,cond_module_id:cond_module_id},
success: function(data) {
var rslt = JSON.parse(data);
$("#prime_cond_id").val(rslt.cond_info.prime_cond_id);
$("#cond_module_id").val(rslt.cond_info.cond_module_id);
$("#condition_label_name").val(rslt.cond_info.condition_label_name);
$("#condition_type").val(rslt.cond_info.condition_type);
update_condition_ui(rslt.cond_info.condition_type);
if(rslt.cond_info.condition_for){
var condition_for = rslt.cond_info.condition_for.split(",");
for(var i in condition_for) {
var condition_for_val = condition_for[i];
$("#condition_for").find("option[value='"+condition_for_val+"']").prop("selected", "selected");
}
}
if(rslt.cond_info.condition_check_form){
var condition_check_form = rslt.cond_info.condition_check_form.split(",");
for(var i in condition_check_form) {
var condition_check_form_val = condition_check_form[i];
$("#condition_check_form").find("option[value='"+condition_check_form_val+"']").prop("selected", "selected");
}
}
if(rslt.cond_info.condition_bind_to){
var condition_bind_to = rslt.cond_info.condition_bind_to.split(",");
for(var i in condition_bind_to) {
var condition_bind_to_val = condition_bind_to[i];
$("#condition_bind_to").find("option[value='"+condition_bind_to_val+"']").prop("selected", "selected");
}
}
if(rslt.cond_info.condition_table){
var condition_table = rslt.cond_info.condition_table.split(",");
for(var i in condition_table) {
var condition_table_val = condition_table[i];
$("#condition_table").find("option[value='"+condition_table_val+"']").prop("selected", "selected");
}
}
if(rslt.cond_info.is_drop_down === "1"){
$('#is_drop_down').prop('checked', true);
$('#cond_drop_down').parent().show();
}else{
$('#cond_drop_down').parent().hide();
$('#is_drop_down').prop('checked', false);
$("#cond_drop_down").val();
}
$("#cond_drop_down").val(rslt.cond_info.cond_drop_down);
call_select();
},
});
}
}
function remove_cond(prime_cond_id){
if(confirm("Are you sure to delete!")){
cond_module_id = $("#cond_module_id").val();
if(prime_cond_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/remove_cond"); ?>',
data: {prime_cond_id:prime_cond_id,cond_module_id:cond_module_id},
success: function(data) {
var rslt = JSON.parse(data);
$("#cond_view_data").html(rslt.cond_content);
update_condition_ui(0);
empty_all_cond();
},
});
}
}
}
function get_id(val){
con_column_input = "con_column_input_"+val;
line_input_bind_col = "line_input_bind_col_"+val;
con_column_input_val = $("#"+con_column_input).val();
line_input_bind_col_val = $("#"+line_input_bind_col).val();
//alert(con_column_input_val + " , "+ line_input_bind_col_val);
fill_val = line_input_bind_col_val + "@" +con_column_input_val+ "@";
$("#"+line_input_bind_col).val(fill_val);
}
</script>