File: /home/cafsindia/.trash/application.1/views/sms_setting/sms_info.php
<style>
.sortable {list-style-type:none;margin:0;padding:0;width: auto;}
.sortable li{margin: 2px 20px 15px 0; padding: 8px; width: 100%; height: auto; font-size: inherit; box-shadow: 0 2px 2px 0 rgba(0,0,0,0.14), 0 3px 1px -2px rgba(0,0,0,0.12), 0 1px 5px 0 rgba(0,0,0,0.2); background-color: #FFFFFF; border: 0px; border-radius: 2px; cursor: pointer;display: inline-block;}
.sortable_width li{width: 23% !important;}
.form-control, input {
text-transform: lowercase !important;
}
.form-inline .form-control {
text-transform: lowercase !important;
}
td{
text-transform: none !important;
}
@import url(//fonts.googleapis.com/css?family=Cambria:400,300,700&subset=latin,latin-ext);
</style>
<link href='https://fonts.googleapis.com/css?family=Cambria:400,300,700&subset=latin,latin-ext' rel='stylesheet' type='text/css'>
<ul class="nav nav-tabs" data-tabs="tabs">
<li class="active" role="presentation">
<a data-toggle="tab" href="#sms_info">Sms Info</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#sms_block">Sms Column Info</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#sms_table">Sms Table Info</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#sms_join_table">Sms Table Join</a>
</li>
<!-- <li role="presentation">
<a data-toggle="tab" href="#sms_content_join_table">Sms Content Join</a>
</li> -->
<!-- <li role="presentation">
<a data-toggle="tab" href="#sms_design">sms Design</a>
</li> -->
<li role="presentation">
<a data-toggle="tab" href="#sms_design">Sms Design</a>
</li>
</ul>
<?php $count_mobile_column = count($mobile_column);?>
<div class="tab-content">
<div class="tab-pane fade in active" id="sms_info">
<?php echo form_open('sms_setting/save_sms_info/' . $sms_info_module_id,array('id'=>'save_sms_info','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_sms_info_id', 'id'=>'prime_sms_info_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'sms_info_module_id', 'id'=>'sms_info_module_id', 'type'=>'Hidden','value'=>$sms_info_module_id));
echo form_label($this->lang->line('sms_info_name'), 'sms_info_name', array('class' => 'required'));
echo form_input(array('name'=> 'sms_info_name', 'id' => 'sms_info_name', 'class' => 'form-control input-sm', "placeholder"=>$this->lang->line('sms_info_name'),'value' =>''));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('sms_info_for'), 'sms_for', array('class' => 'required'));
echo form_dropdown(array('name' => 'sms_info_for[]','multiple id' =>'sms_info_for','class' => 'form-control input-sm select2'), $sms_for);
echo "<label><input name='sms_info_for_select' id='sms_info_for_select' type='checkbox'> Select All</label>";
?>
</div>
<div class="form-group">
<?php
echo form_label("Pick List", 'query_list_id', array('class' => 'required'));
echo form_dropdown(array('name' => 'query_list_id','id' =>'query_list_id','class' => 'form-control input-sm'), $query_list_id);
?>
</div>
<div class="form-group">
<?php
$query_column_list = array('' => "--- Select Column ---");
echo form_label("Pick List column", 'query_column_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'query_column_list','id' =>'query_column_list','class' => 'form-control input-sm'),$query_column_list);
?>
</div>
<div class="form-group">
<?php
$table_values = array('' => "--- Select Table Values ---");
echo form_label("Table Values", 'table_values', array('class' => 'required'));
echo form_dropdown(array('name' => 'table_values','id' =>'table_values','class' => 'form-control input-sm'),$table_values);
?>
</div>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="sms_info_submit">Add/Update</button>
<a class='btn btn-danger btn-sm' id="sms_info_cancel">Cancel</a>
</div>
<?php echo form_close(); ?>
<div style='padding:15px;' id='sms_info_list'>
<?php
print_r($sms_info_list);
?>
</div>
</div>
<div class="tab-pane fade" id="sms_block">
<?php echo form_open('sms_setting/save_sms_block/' . $sms_info_module_id,array('id'=>'save_sms_block','class'=>'form-inline' ,'style'=>'background-color: #f2f2f2;')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_sms_block_id', 'id'=>'prime_sms_block_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'sms_block_module_id', 'id'=>'sms_block_module_id', 'type'=>'Hidden','value'=>$sms_info_module_id));
echo form_label($this->lang->line('sms_block_for'), 'sms_block_for', array('class' => 'required'));
echo form_dropdown(array('name' => 'sms_block_for','id' =>'sms_block_for','class' => 'form-control input-sm'), $sms_block_for);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('sms_block_name'), 'sms_block_name', array('class' => 'required'));
echo form_input(array('name'=> 'sms_block_name', 'id' => 'sms_block_name', 'class' => 'form-control input-sm', "placeholder"=>$this->lang->line('sms_block_name'),'value' =>''));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('sms_block_table'), 'sms_block_table', array('class' => 'required'));
echo form_dropdown(array('name' => 'sms_block_table[]','multiple id' =>'sms_block_table','class' => 'form-control input-sm select2'), $table_list);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('sms_block_column'), 'sms_block_column', array('class' => 'required'));
echo form_dropdown(array('name' => 'sms_block_column','id' =>'sms_block_column','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('sms_block_type'), 'sms_block_type', array('class' => 'required'));
$sms_block_type_list = array("0"=>"--- Select Block Type ---","1"=>"Primary","2"=>"Secondary",);
echo form_dropdown(array('name' => 'sms_block_type','id' =>'sms_block_type','class' => 'form-control input-sm'), $sms_block_type_list);
?>
</div>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="sms_block_submit">Add/Update</button>
<a class='btn btn-danger btn-sm' id="sms_block_cancel">Cancel</a>
</div>
<?php echo form_close(); ?>
<div style='padding:15px;' id='sms_block_list'>
<?php
print_r($sms_block_list);
?>
</div>
</div>
<div class="tab-pane fade" id="sms_table">
<?php echo form_open('sms_setting/get_sms_table_info/' . $sms_info_module_id,array('id'=>'get_sms_table_info','class'=>'form-inline' ,'style'=>'background-color: #f2f2f2;')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_sms_table_id', 'id'=>'prime_sms_table_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'sms_block_module_id', 'id'=>'sms_block_module_id', 'type'=>'Hidden','value'=>$sms_info_module_id));
echo form_label($this->lang->line('sms_table_list'), 'sms_table_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'sms_table_list','id' =>'sms_table_list','class' => 'form-control input-sm'), $sms_block_for);
?>
</div>
<div class="form-group">
<?php
$sms_name_table = array('' => "--- Select Column ---");
echo form_label($this->lang->line('sms_name_table'), 'sms_name_table', array('class' => 'required'));
echo form_dropdown(array('name' => 'sms_name_table','id' =>'sms_name_table','class' => 'form-control input-sm'), $sms_name_table);
?>
</div>
<div class="form-group">
<?php
$sms_table_column = array('0' => "--- Select Column ---");
echo form_label($this->lang->line('sms_table_column'), 'sms_table_column', array('class' => 'required'));
echo form_dropdown(array('name' => 'sms_table_column[]','multiple id' =>'sms_table_column','class' => 'form-control input-sm select2'), $sms_table_column);
?>
</div>
<div class="form-group">
<?php
$sms_table_sms_column = array('0' => "--- Select Column ---");
echo form_label($this->lang->line('sms_table_sms_column'), 'sms_table_sms_column', array('class' => 'required'));
echo form_dropdown(array('name' => 'sms_table_sms_column[]','multiple id' =>'sms_table_sms_column','class' => 'form-control input-sm select2'), $sms_table_sms_column);
?>
</div>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="sms_table_submit">Add/Update</button>
<a class='btn btn-danger btn-sm' id="sms_table_cancel">Cancel</a>
</div>
<?php echo form_close(); ?>
<div style='padding:15px;' id='sms_table_info_list'>
<?php
print_r($sms_table_info_list);
?>
</div>
</div>
<div class="tab-pane fade" id="sms_join_table">
<?php echo form_open('sms_setting/get_join_table_info/' . $sms_info_module_id,array('id'=>'get_join_table_info','class'=>'form-inline' ,'style'=>'background-color: #f2f2f2;')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_sms_table_join_id', 'id'=>'prime_sms_table_join_id', 'type'=>'Hidden','value'=>0));
echo form_label($this->lang->line('sms_table_list'), 'sms_table_join_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'sms_table_join_list','id' =>'sms_table_join_list','class' => 'form-control input-sm'), $sms_table_list);
?>
</div>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="sms_table_info_view">View</button>
</div>
<?php echo form_close(); ?>
<div id="sms_table_content">
<ul class="nav nav-tabs" data-tabs="tabs">
<li class="active" role="presentation">
<a data-toggle="tab" href="#sms_map_table">Map Table</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#sms_table_where">Map Where</a>
</li>
</ul>
<div class="tab-content">
<div class="tab-pane fade in active" id="sms_map_table" style='padding:15px;'>
<?php echo form_open('sms_setting/save_sms_table/' . $prime_module_id,array('id'=>'save_sms_table','class'=>'form-inline')); ?>
<!-- LOAD CONTENT FROM CONTROLLER -->
<?php echo form_close(); ?>
</div>
<div class="tab-pane fade" id="sms_table_where" style='padding:15px;'>
<?php echo form_open('sms_setting/save_sms_where/' . $prime_module_id,array('id'=>'save_sms_where','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'where_for_id', 'id'=>'where_for_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'where_module_id', 'id'=>'where_module_id', 'type'=>'Hidden','value'=>$prime_module_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_table','id' =>'query_column_list_table','class' => 'form-control input-sm query_column_list_table'));
?>
</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' >and</textarea>
</div>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="save_query_btn">Add/Update</button>
</div>
</div>
<?php echo form_close(); ?>
</div>
</div>
</div>
</div>
<!-- <div class="tab-pane fade" id="sms_content_join_table">
<?php echo form_open('sms_setting/get_content_join_table_info/' . $sms_info_module_id,array('id'=>'get_content_join_table_info','class'=>'form-inline' ,'style'=>'background-color: #f2f2f2;')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_sms_content_table_join_id', 'id'=>'prime_sms_content_table_join_id', 'type'=>'Hidden','value'=>0));
echo form_label($this->lang->line('sms_table_list'), 'sms_table_join_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'sms_content_table_join_list','id' =>'sms_content_table_join_list','class' => 'form-control input-sm'), $sms_table_list);
?>
</div>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="sms_content_table_info_view">View</button>
</div>
<?php echo form_close(); ?>
<div id="sms_content_table_content">
<ul class="nav nav-tabs" data-tabs="tabs">
<li class="active" role="presentation">
<a data-toggle="tab" href="#sms_content_map_table">Map Table</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#sms_table_content_where">Map Where</a>
</li>
</ul>
<div class="tab-content">
<div class="tab-pane fade in active" id="sms_content_map_table" style='padding:15px;'>
<?php echo form_open('sms_setting/save_sms_content_table/' . $prime_module_id,array('id'=>'save_sms_content_table','class'=>'form-inline')); ?>
<?php echo form_close(); ?>
</div>
<div class="tab-pane fade" id="sms_table_content_where" style='padding:15px;'>
<?php echo form_open('sms_setting/save_sms_content_where/' . $prime_module_id,array('id'=>'save_sms_content_where','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'content_where_for_id', 'id'=>'content_where_for_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'content_where_module_id', 'id'=>'content_where_module_id', 'type'=>'Hidden','value'=>$prime_module_id));
echo form_input( array('name'=>'content_query_type', 'id'=>'content_query_type', 'type'=>'Hidden','value'=>''));
echo form_label($this->lang->line('query_column_list'), 'pick_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'content_query_column_list_table','id' =>'content_query_column_list_table','class' => 'form-control input-sm content_query_column_list_table'));
?>
</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' => 'content_picklist_type','id' =>'content_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' => 'content_pick_list[]','multiple id' =>'content_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' => 'content_session_list','id' =>'content_session_list','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<a class='btn btn-edit btn-sm' id="content_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='content_where_condition' id='content_where_condition'class='form-control' rows='4' placeholder='Write Condition with out where' >and</textarea>
</div>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="content_save_query_btn">Add/Update</button>
</div>
</div>
<?php echo form_close(); ?>
</div>
</div>
</div>
</div> -->
<div class="tab-pane fade" id="sms_design">
<form class="form-inline">
<div class="form-group">
<?php
echo form_label('Select sms Info', 'sms_assign_table_info', array('class' => 'required'));
echo form_dropdown(array('name' => 'assign_table_info','id' =>'sms_assign_table_info','class' => 'form-control input-sm'), $sms_block_for);
?>
</div>
<div class="form-group">
<?php
echo form_label("Template Id", 'template_id', array('class' => 'required'));
echo form_input(array('name'=> 'template_id', 'id' => 'template_id', 'class' => 'form-control input-sm', "placeholder"=>"Mail Subject",'value' =>''));
?>
</div>
<div class="form-group">
<?php
echo form_label('Select sms Block', 'sms_assign_table_block', array('class' => ''));
echo form_dropdown(array('name' => 'assign_table_block','id' =>'sms_assign_table_block','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_type'), 'sms_assign_type', array('class' => ''));
echo form_dropdown(array('name' => 'sms_assign_type','id' =>'sms_assign_type','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_label'), 'sms_assign_label', array('class' => ''));
echo form_dropdown(array('name' => 'sms_assign_label','id' =>'sms_assign_label','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_short_label'), 'sms_assign_short_label', array('class' => ''));
echo form_dropdown(array('name' => 'sms_assign_short_label','id' =>'sms_assign_short_label','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_value_for'), 'sms_assign_value_for', array('class' => ''));
echo form_dropdown(array('name' => 'sms_assign_value_for','id' =>'sms_assign_value_for','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('list_view_value'), 'sms_list_view_value', array('class' => ''));
echo form_dropdown(array('name' => 'sms_list_view_value','id' =>'sms_list_view_value','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_date_formate'), 'sms_assign_date_formate', array('class' => ''));
$assign_date_formate_list = array(""=>"-- Select Format --","DMY"=>"(DD-MM-YYYY)","YMD"=>"(YYYY-MM-DD)","DFY"=>"(DD-FF-YYYY)","MY"=>"(MM-YYYY)","YM"=>"(YYYY-MM)","D"=>"(DD)","M"=>"(MM)","Y"=>"(YYYY)");
echo form_dropdown(array('name' => 'sms_assign_date_formate','id' =>'sms_assign_date_formate','class' => 'form-control input-sm'),$assign_date_formate_list);
?>
<span style='font-size:11px;color:green;'>Select Date formate if mapping is date</span>
</div>
<div class="form-group">
<a class='btn btn-primary btn-sm' id="sms_btn">Assign</a>
</div>
</form>
<div id="sms_froala_editor" style="padding:0px 15px;margin-bottom:15px;"> </div>
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){
call_select();
$.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");
jQuery.validator.addMethod("notEqual", function (value, element, param) { // ADDING RULES FOR AMOUNT(NOT EQUAL TO ZERO)
return this.optional(element) || value != 'and';
}, "Write Condition after and");
$('a[data-toggle="tab"]').on('shown.bs.tab', function (e) {
var target = $(e.target).attr("href");
call_select();
});
$("#sms_table_content,#sms_content_table_content").hide();
/* sms BASE INFO START*/
$("#sms_info_for_select").click(function(){
if($("#sms_info_for_select").is(':checked') ){
$("#sms_info_for > option").prop("selected","selected");
$("#sms_info_for").trigger("change");
}else{
$("#sms_info_for > option").removeAttr("selected");
$("#sms_info_for").trigger("change");
}
});
var sms_type_id = parseInt($('#sms_type_id').val());
if(sms_type_id === 2){
$("select[name='sms_block_table[]']").attr('readonly','readonly');
}
$('#save_sms_info').validate($.extend({
submitHandler: function (form){
$("#sms_info_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#sms_info_submit').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#sms_info_submit').attr('disabled',false);
$("#sms_info_submit").html("Add/Update");
if(response.success){
var sms_type = parseInt($('#sms_type').val());
document.getElementById("save_sms_info").reset();
$("#prime_sms_info_id").val(0);
$('#sms_info_for option:selected').removeAttr('selected');
$("#sms_info_list").html(response.sms_info_list);
$('#sms_block_for,#assign_table_info').empty();
var option ="";
$.each(response.sms_block_for, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_block_for,#assign_table_info').append(option);
/*$('#sms_type_id').val(sms_type);
if(sms_type === 2){
$("#sms_block_table").val(["cw_employees","cw_transactions"]);
$("select[name='sms_block_table[]']").attr('readonly','readonly');
}*/
call_select();
toastr.success(response.message);
activaTab('sms_block');
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
sms_block_for: {
required: true,
alphanumeric:true,
space_check:true,
},
"sms_info_name": "required",
"sms_info_for[]": "required",
"query_list_id": "required",
"query_column_list": "required",
"table_values": "required",
}
}));
$("#sms_info_cancel").click(function(){
document.getElementById("save_sms_info").reset();
$("#prime_sms_info_id").val(0);
$('#sms_info_for option:selected').removeAttr('selected');
$('#sms_info_submit').attr('disabled',false);
$("#sms_info_submit").html("Add/Update");
call_select();
});
/* sms BASE INFO END*/
$("#query_column_list,#values_from,#table_values,#session_values").parent().hide();
$("#query_list_id").change(function(){
var query_list_id = $('#query_list_id').val();
var sms_info_module_id = "<?php echo $sms_info_module_id;?>";
if(query_list_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_query_column_list"); ?>',
data: {query_list_id:query_list_id,sms_info_module_id:sms_info_module_id},
success: function(data){
var rslt = JSON.parse(data);
$('#query_column_list').empty();
$('#table_values').empty();
if(rslt.success){
var column_option ="";
$.each(rslt.column_list, function( key, value ) {
column_option += '<option value="' + key + '">' + value + '</option>';
});
$('#query_column_list').append(column_option);
$('#query_column_list').parent().show();
$('#table_values').parent().hide();
}else{
toastr.error(rslt.msg);
}
},
});
}
});
$("#sms_table_list").change(function(){
$('#sms_name_table').empty();
var sms_table_list = $('#sms_table_list').val();
var sms_info_module_id = "<?php echo $sms_info_module_id;?>";
if(query_list_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_query_block_list"); ?>',
data: {sms_table_list:sms_table_list,sms_info_module_id:sms_info_module_id},
success: function(data){
var rslt = JSON.parse(data);
console.log(rslt.column_list);
if(rslt.success){
var column_option ="";
$.each(rslt.column_list, function( key, value ) {
column_option += '<option value="' + key + '">' + value + '</option>';
});
$('#sms_name_table').append(column_option);
}else{
toastr.error(rslt.msg);
}
},
});
}
});
$("#sms_name_table").change(function(){
var sms_name_table = $('#sms_name_table').val();
var sms_info_module_id = "<?php echo $sms_info_module_id;?>";
if(query_list_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_query_table_column_list"); ?>',
data: {sms_name_table:sms_name_table,sms_info_module_id:sms_info_module_id},
success: function(data){
var rslt = JSON.parse(data);
$('#sms_table_column').empty();
$('#sms_table_sms_column').empty();
var bcc_sms_type = rslt.bcc_sms_type;
if(rslt.success){
var column_option ="";
$.each(rslt.sms_block_column, function( key, value ) {
column_option += '<option value="' + key + '">' + value + '</option>';
});
var column_options ="";
$.each(rslt.sms_block_column_sms, function( key, value ) {
column_options += '<option value="' + key + '">' + value + '</option>';
});
$('#sms_table_column').append(column_option);
$('#sms_table_sms_column').append(column_options);
}else{
toastr.error(rslt.msg);
}
},
});
}
});
// $("#sms_table_column").change(function(){
// var sms_table_column = $("input[name='sms_table_column[]'],select[name='sms_table_column[]']").map(function(){return $(this).val();}).get();
// var sms_info_module_id = "<?php echo $sms_info_module_id;?>";
// var sms_name_table = $('#sms_name_table').val();
// $.ajax({
// type: "POST",
// url: '<?php echo site_url($controller_name . "/get_sms_column_only"); ?>',
// data: {sms_table_column:sms_table_column,sms_info_module_id:sms_info_module_id,sms_name_table:sms_name_table},
// success: function(data){
// var rslt = JSON.parse(data);
// console.log(rslt.mail_id_colum);
// $('#sms_table_sms_column').empty();
// if(rslt.success){
// var column_option ="";
// $.each(rslt.mail_id_colum, function( key, value ) {
// if(value !== null){
// var keys = value.replace("_", " ");
// var rls_keys = keys.replace(".", " - ");
// var column_value = rls_keys.toUpperCase();
// column_option += '<option value="' + value + '">' + column_value + '</option>';
// }
// });
// $('#sms_table_sms_column').append(column_option);
// }else{
// toastr.error(rslt.msg);
// }
// },
// });
// });
/* sms BLOCK INFO START*/
$("#sms_block_table").change(function(){
var sms_block_table = $('#sms_block_table').val();
if(sms_block_table){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_sms_block_table"); ?>',
data: {sms_block_table:sms_block_table},
success: function(data) {
var rslt = JSON.parse(data);
var sms_block_column = $('#sms_block_column').val();
if((sms_block_column == null) || (sms_block_column == "NULL")){
$('#sms_block_column option:selected').removeAttr('selected');
}
call_select();
if(rslt.success){
if(rslt.sms_block_column){
$('#sms_block_column').empty();
var option = "";
$.each(rslt.sms_block_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_block_column').html(option);
}
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
});
$('#save_sms_block').validate($.extend({
submitHandler: function (form){
$("#sms_block_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#sms_block_submit').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#sms_block_submit').attr('disabled',false);
$("#sms_block_submit").html("Add/Update");
if(response.success){
$('#sms_block_table option:selected').removeAttr('selected');
$('#sms_block_column option:selected').removeAttr('selected');
document.getElementById("save_sms_block").reset();
$("#prime_sms_block_id").val(0);
call_select();
$("#sms_block_list").html(response.sms_block_list);
$('#assign_table_block').empty();
var option ="";
$.each(response.sms_table_list, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#assign_table_block').append(option);
toastr.success(response.message);
// $("#sms_table_content").hide();
// $("#sms_content_table_content").hide();
$("#sms_table_join_list").val(0);
// $("#sms_content_table_join_list").val(0);
activaTab('sms_table');
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
sms_block_for: {
required: true,
min:1,
},
sms_block_type: {
required: true,
min:1,
},
sms_block_name: {
required: true,
alphanumeric:true,
space_check:true,
},
"sms_block_table[]": "required",
"sms_block_column[]": "required",
}
}));
$("#sms_block_cancel").click(function(){
document.getElementById("save_sms_block").reset();
$("#prime_sms_block_id").val(0);
$('#sms_block_submit').attr('disabled',false);
$("#sms_block_submit").html("Add/Update");
call_select();
});
$("#sms_table_cancel").click(function(){
document.getElementById("get_sms_table_info").reset();
$("#sms_table_list").val('');
$("#sms_name_table").val('');
$("#sms_table_column").val('');
$("#sms_table_sms_column").val('');
$('#sms_table_submit').attr('disabled',false);
$("#sms_table_submit").html("Add/Update");
call_select();
});
/* sms BLOCK INFO END*/
$('#get_join_table_info').validate($.extend({
submitHandler: function (form){
$("#sms_table_info_view").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#sms_table_info_view').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#sms_table_info_view').attr('disabled',false);
$("#sms_table_info_view").html("View");
if(response.success){
$("#save_sms_table").html(response.sms_table_block);
$('#query_column_list').empty();
var option ="";
$.each(response.column_list, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('.query_column_list_table').append(option);
$("#where_for_id").val(response.prime_sms_block_id);
$("#where_module_id").val(response.sms_block_module_id);
$("#where_condition").val(response.where_condition);
$("#sms_table_content").show();
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
sms_table_join_list: {
required: true,
min:1,
},
}
}));
/*$('#get_content_join_table_info').validate($.extend({
submitHandler: function (form){
$("#sms_content_table_info_view").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#sms_content_table_info_view').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#sms_content_table_info_view').attr('disabled',false);
$("#sms_content_table_info_view").html("View");
if(response.success){
$("#save_sms_content_table").html(response.sms_table_block);
$('#content_query_column_list').empty();
var option ="";
$.each(response.column_list, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('.content_query_column_list_table').append(option);
$("#content_where_for_id").val(response.prime_sms_block_id);
$("#content_where_module_id").val(response.sms_block_module_id);
$("#content_where_condition").val(response.where_condition);
$("#sms_content_table_content").show();
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
sms_content_table_join_list: {
required: true,
min:1,
},
}
}));*/
/* sms TABLE INFO START*/
$('#get_sms_table_info').validate($.extend({
submitHandler: function (form){
$("#sms_table_info_view").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#sms_table_info_view').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#sms_table_info_view').attr('disabled',false);
$("#sms_table_info_view").html("View");
if(response.success){
toastr.success(response.message);
$("#sms_table_list_info").html(response.sms_table_info_list);
$("#save_sms_table").html(response.sms_table_block);
$('#sms_table_list').val('');
$('#sms_name_table').val('');
$('#sms_table_column').val('');
$('#sms_table_sms_column').val('');
call_select();
activaTab("sms_join_table");
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
sms_table_list: {
required: true,
min:1,
},
sms_name_table: {
required: true
},
"sms_table_column[]": "required",
"sms_table_sms_column[]": "required",
}
}));
$('#save_sms_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_sms_table_save").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_sms_table_save').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#save_sms_table_save').attr('disabled',false);
$("#save_sms_table_save").html("Save");
toastr.success(response.message);
},
dataType: 'json'
});
}else{
toastr.error("Map all table join");
}
}
});
/*$('#save_sms_content_table').validate({
submitHandler:function(form) {
var isValid = true;
$("select[name='line_prime_table_content[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='line_prime_col_content[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='line_join_type_content[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='line_join_table_content[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
$("select[name='line_join_col_content[]']").each(function() {
if($(this).val() == "" && $(this).val().length < 1) {
$(this).addClass('error');
isValid = false;
} else {
$(this).removeClass('error');
}
});
if(isValid) {
$("#save_sms_content_table_save").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_sms_content_table_save').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#save_sms_content_table_save').attr('disabled',false);
$("#save_sms_content_table_save").html("Save");
toastr.success(response.message);
},
dataType: 'json'
});
}else{
toastr.error("Map all table join");
}
}
});*/
/* sms TABLE INFO END*/
/* sms WHERE INFO START*/
$('#save_sms_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);
//document.getElementById("save_sms_where").reset();
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
where_condition: {
required:true,
/*notEqual: true,*/
}
}
}));
/*$('#save_sms_content_where').validate($.extend({
submitHandler: function (form){
$("#content_save_query_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#content_save_query_btn').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (response){
$('#content_save_query_btn').attr('disabled',false);
$("#content_save_query_btn").html("Add/Update");
if(response.success){
toastr.success(response.message);
//document.getElementById("save_sms_where").reset();
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
content_where_condition: {
required:true,
}
}
}));*/
$('#picklist_type,#pick_list,#session_list').parent().hide();
$("#query_column_list").change(function(){
$("#table_values").empty();
query_column = $("#query_column_list").val();
where_module_id = $("#where_module_id").val();
query_list_id = $("#query_list_id").val();
query_column_list = $("#query_column_list").val();
var sms_info_module_id = "<?php echo $sms_info_module_id;?>";
if(query_column){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_column_info"); ?>',
data: {query_column:query_column,where_module_id:where_module_id,query_list_id:query_list_id,query_column_list:query_column_list,sms_info_module_id:sms_info_module_id},
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);
var table_option ="";
$.each(rslt.value_list, function( key, value ) {
table_option += '<option value="' + key + '">' + value + '</option>';
});
$('#table_values').append(table_option);
$('#table_values').parent().show();
}else{
toastr.error(rslt.msg);
}
},
});
}
});
// $('#content_picklist_type,#content_pick_list,#content_session_list').parent().hide();
// $("#content_query_column_list").change(function(){
// $("#content_table_values").empty();
// content_query_column = $("#content_query_column_list").val();
// content_where_module_id = $("#content_where_module_id").val();
// query_list_id = $("#query_list_id").val();
// content_query_column_list = $("#content_query_column_list").val();
// var sms_info_module_id = "<?php echo $sms_info_module_id;?>";
// if(content_query_column){
// $.ajax({
// type: "POST",
// url: '<?php echo site_url($controller_name . "/get_content_column_info"); ?>',
// data: {content_query_column:content_query_column,content_where_module_id:content_where_module_id,query_list_id:query_list_id,content_query_column_list:content_query_column_list,sms_info_module_id:sms_info_module_id},
// success: function(data) {
// var rslt = JSON.parse(data);
// $('#content_pick_list').empty();
// $('#content_session_list').empty();
// $('#content_picklist_type,#content_pick_list,#content_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>';
// });
// $('#content_pick_list').append(pick_option);
// var session_option ="";
// $.each(rslt.session_list, function( key, value ) {
// session_option += '<option value="' + key + '">' + value + '</option>';
// });
// $('#content_session_list').append(session_option);
// $('#content_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>';
// });
// $('#content_session_list').append(option);
// $('#content_session_list').parent().show();
// }
// $("#query_type").val(rslt.type);
// var table_option ="";
// $.each(rslt.value_list, function( key, value ) {
// table_option += '<option value="' + key + '">' + value + '</option>';
// });
// $('#content_table_values').append(table_option);
// $('#content_table_values').parent().show();
// }else{
// toastr.error(rslt.msg);
// }
// },
// });
// }
// });
/*$("#content_query_column_list_table").change(function(){
content_query_column = $("#content_query_column_list_table").val();
content_where_module_id = $("#content_where_module_id").val();
if(content_query_column){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_content_column_info"); ?>',
data: {content_query_column:content_query_column,content_where_module_id:content_where_module_id},
success: function(data) {
var rslt = JSON.parse(data);
$('#content_pick_list').empty();
$('#content_session_list').empty();
$('#content_picklist_type,#content_pick_list,#content_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>';
});
$('#content_pick_list').append(pick_option);
var session_option ="";
$.each(rslt.session_list, function( key, value ) {
session_option += '<option value="' + key + '">' + value + '</option>';
});
$('#content_session_list').append(session_option);
$('#content_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>';
});
$('#content_session_list').append(option);
$('#content_session_list').parent().show();
}
$("#content_query_type").val(rslt.type);
}else{
toastr.error(rslt.msg);
}
},
});
}
});*/
$("#query_column_list_table").change(function(){
query_column = $("#query_column_list_table").val();
where_module_id = $("#where_module_id").val();
if(query_column){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_column_info"); ?>',
data: {query_column:query_column,where_module_id:where_module_id},
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()
});
/*$("#content_picklist_type").change(function(){
$('#content_pick_list,#content_session_list').parent().hide();
content_picklist_type = $("#content_picklist_type").val();
if(content_picklist_type === "1"){
$('#content_pick_list').parent().show();
}else
if(content_picklist_type === "2"){
$('#content_session_list').parent().show();
}
call_select()
});*/
$("#apply_condition").click(function(){
query_column = $("#query_column_list_table").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);
}
});
/*$("#content_apply_condition").click(function(){
query_column = $("#content_query_column_list_table").val();
query_type = $("#content_query_type").val();
var fill_val = "";
if(query_column){
if(query_type === "pick_list"){
picklist_type = $("#content_picklist_type").val();
if(picklist_type === "1"){
sub_value = $("#content_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 = $("#content_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 = $("#content_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 = $("#content_where_condition").val();
fill_val = where_condition +" "+fill_val;
$("#content_where_condition").val(fill_val);
}
});*/
/* sms WHERE INFO END*/
/* sms DESIGN START*/
$("#assign_table_block,#assign_type,#assign_label,#assign_short_label,#assign_value_for,#list_view_value,#assign_date_formate,#assign_btn,#assign_ytd_label").parent().hide();
$("#assign_table_info").change(function(){
assign_table_info = $("#assign_table_info").val();
$("#assign_table_block,#assign_type,#assign_label,#assign_short_label,#assign_value_for,#list_view_value,#assign_date_formate,#assign_btn,#assign_ytd_label").parent().hide();
if(assign_table_info){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/assign_table_info"); ?>',
data: {assign_table_info:assign_table_info},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#assign_table_block,#list_view_value').empty();
var option ="";
$.each(rslt.assign_table_block, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#assign_table_block').append(option);
var option ="";
$.each(rslt.list_view_value, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#list_view_value').append(option);
$("#assign_table_block").parent().show();
// PAGE BUILDER WITH DATA IF EXIST.
call_sms_builder(rslt.sms_design);
}else{
toastr.error(rslt.message);
}
},
});
}else{
toastr.error("Please select sms info");
}
});
$("#assign_table_block").change(function(){
assign_table_block = $("#assign_table_block").val();
$("#assign_type,#assign_label,#assign_short_label,#assign_value_for,#list_view_value,#assign_date_formate,#assign_btn,#assign_ytd_label").parent().hide();
if(assign_table_block){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/assign_table_block"); ?>',
data: {assign_table_block:assign_table_block},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#assign_label,#assign_short_label,#assign_value_for,#assign_type,#assign_ytd_label').empty();
var option ="";
$.each(rslt.assign_type, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#assign_type').append(option);
var option ="";
$.each(rslt.assign_label, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#assign_label').append(option);
var option ="";
$.each(rslt.assign_short_label, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#assign_short_label').append(option);
var option ="";
$.each(rslt.assign_ytd_label, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#assign_ytd_label').append(option);
var option ="";
$.each(rslt.assign_value_for, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#assign_value_for').append(option);
$("#assign_type").parent().show();
}else{
toastr.error(rslt.message);
}
},
});
}else{
toastr.error("Please select sms block");
}
});
$("#assign_type").change(function(){
assign_type = $("#assign_type").val();
$("#assign_label,#assign_short_label,#assign_value_for,#list_view_value,#assign_date_formate,#assign_btn,#assign_ytd_label").parent().hide();
if(assign_type === "1"){
$("#assign_label,#assign_btn").parent().show();
}else
if(assign_type === "2"){
$("#assign_short_label,#assign_btn").parent().show();
}else
if(assign_type === "3"){
$("#assign_value_for,#assign_btn").parent().show();
}else
if(assign_type === "4"){
$("#assign_ytd_label,#assign_btn").parent().show();
}else
if(assign_type === "5"){
$("#list_view_value,#assign_btn").parent().show();
}
});
//assign_value_for assign_date_formate
$("#assign_value_for").change(function(){
assign_value_for = $("#assign_value_for").val();
if(assign_value_for){
$("#assign_date_formate").parent().show();
}else{
$("#assign_date_formate").parent().hide();
$("#assign_date_formate").val("");
}
});
$("#save_sms_design").click(function(){
$('#froala-editor').froalaEditor('save.save');
});
/* sms DESIGN START*/
$("#sms_assign_table_block,#sms_assign_type,#sms_assign_label,#sms_assign_short_label,#sms_assign_value_for,#sms_list_view_value,#sms_assign_date_formate,#sms_btn,#template_id").parent().hide();
$("#sms_assign_table_info").change(function(){
assign_table_info = $("#sms_assign_table_info").val();
$("#sms_assign_table_block,#sms_assign_type,#sms_assign_label,#sms_assign_short_label,#sms_assign_value_for,#sms_list_view_value,#sms_assign_date_formate,#sms_btn,#template_id").parent().hide();
if(assign_table_info){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/sms_assign_table_info"); ?>',
data: {assign_table_info:assign_table_info},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#sms_assign_table_block,#sms_list_view_value').empty();
var option ="";
$.each(rslt.assign_table_block, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_assign_table_block').append(option);
var option ="";
$.each(rslt.list_view_value, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_list_view_value').append(option);
$("#sms_assign_table_block").parent().show();
$("#template_id").parent().show();
$('#template_id').val(rslt.template_id);
$('#template_id').val(rslt.template_id);
// PAGE BUILDER WITH DATA IF EXIST.
call_sms_builder(rslt.sms_design);
}else{
toastr.error(rslt.message);
}
},
});
}else{
toastr.error("Please select sms info");
}
});
$("#sms_assign_table_block").change(function(){
assign_table_block = $("#sms_assign_table_info").val();
$("#sms_assign_type,#sms_assign_label,#sms_assign_short_label,#sms_assign_value_for,#sms_list_view_value,#sms_assign_date_formate,#sms_btn").parent().hide();
if(assign_table_block){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/assign_table_block"); ?>',
data: {assign_table_block:assign_table_block},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#sms_assign_label,#sms_assign_short_label,#sms_assign_value_for,#sms_assign_type').empty();
var option ="";
$.each(rslt.assign_type, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_assign_type').append(option);
var option ="";
$.each(rslt.assign_label, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_assign_label').append(option);
var option ="";
$.each(rslt.assign_short_label, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_assign_short_label').append(option);
var option ="";
$.each(rslt.assign_value_for, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_assign_value_for').append(option);
$("#sms_assign_type").parent().show();
}else{
toastr.error(rslt.message);
}
},
});
}else{
toastr.error("Please select sms block");
}
});
$("#sms_assign_type").change(function(){
assign_type = $("#sms_assign_type").val();
$("#sms_assign_label,#sms_assign_short_label,#sms_assign_value_for,#sms_list_view_value,#sms_assign_date_formate,#sms_btn").parent().hide();
if(assign_type === "1"){
$("#sms_assign_label,#sms_btn").parent().show();
}else
if(assign_type === "2"){
$("#sms_assign_short_label,#sms_btn").parent().show();
}else
if(assign_type === "3"){
$("#sms_assign_value_for,#sms_btn").parent().show();
}
});
//assign_value_for assign_date_formate
$("#sms_assign_value_for").change(function(){
assign_value_for = $("#sms_assign_value_for").val();
if(assign_value_for){
$("#sms_assign_date_formate").parent().show();
}else{
$("#sms_assign_date_formate").parent().hide();
$("#sms_assign_date_formate").val("");
}
});
$("#save_sms_design").click(function(){
$('#sms_froala_editor').froalaEditor('save.save');
});
/* sms DESIGN INFO END*/
/* sms DESIGN INFO END*/
$("#sms_block_for").change(function(){
get_block_table();
});
//HIDE SHOW FOR sms BASED ON(OFFER LETTER)
sms_based_on();
$('#sms_type').on('change',function(){
sms_based_on();
});
});
function sms_based_on(){
$('#sms_based_on').parent().hide();
var sms_type = $('#sms_type').val();
if(parseInt(sms_type) === 3){
$('#sms_based_on').parent().show();
}else{
$('#sms_based_on').parent().hide();
}
}
function call_select(){
$(function(){
$('.select2').select2();
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
$(".select2_user").select2({
tags: true
});
});
}
/* sms BASE INFO START*/
// EDIT SPLIT INFO
function edit_split_info(prime_sms_split_id){
if(prime_sms_split_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/edit_split_info"); ?>',
data: {prime_sms_split_id:prime_sms_split_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#split_colum').empty();
var option ="";
$.each(rslt.split_column_rslt, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#split_colum').append(option);
$.each(rslt.split_rslt, function (index, value){
$("#"+index).val(value);
});
}else{
toastr.error(rslt.message);
}
},
});
}
}
// REMOVE sms INFO
function remove_split_info(prime_sms_split_id){
if(confirm("Are you sure to delete!")){
if(prime_sms_split_id){
sms_info_module_id = $("#sms_info_module_id").val();
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/remove_split_info"); ?>',
data: {prime_sms_split_id:prime_sms_split_id,sms_info_module_id:sms_info_module_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#split_table_list").html(rslt.table_info);
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
}
// EDIT sms INFO
function edit_sms_info(prime_sms_info_id){
var sms_info_module_id = "<?php echo $sms_info_module_id;?>";
if(prime_sms_info_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/edit_sms_info"); ?>',
data: {prime_sms_info_id:prime_sms_info_id,sms_info_module_id:sms_info_module_id},
success: function(data) {
var rslt = JSON.parse(data);
$('#sms_for option:selected').removeAttr('selected');
var query_column_list = rslt.sms_info.query_column_list;
var table_values = rslt.sms_info.table_values;
call_select();
if(rslt.success){
$('#table_values').empty();
$("#prime_sms_info_id").val(rslt.sms_info.prime_sms_info_id);
$("#sms_info_name").val(rslt.sms_info.sms_info_name);
$("#query_list_id").val(rslt.sms_info.query_list_id);
$('#query_column_list').empty();
var column_option ="";
$.each(rslt.column_list, function( key, value ) {
column_option += '<option value="' + key + '">' + value + '</option>';
});
$('#query_column_list').append(column_option);
$("#query_column_list").find("option[value='"+query_column_list+"']").prop("selected", "selected");
var table_option ="";
$.each(rslt.value_list, function( key, value ) {
table_option += '<option value="' + key + '">' + value + '</option>';
});
$('#table_values').append(table_option);
$("#table_values").find("option[value='"+table_values+"']").prop("selected", "selected");
if(rslt.sms_info.sms_info_for){
var sms_info_for = rslt.sms_info.sms_info_for.split(",");
for(var i in sms_info_for) {
var sms_info_for_val = sms_info_for[i];
$("#sms_info_for").find("option[value='"+sms_info_for_val+"']").prop("selected", "selected");
sms_based_on();
}
}
$("#query_column_list,#table_values").parent().show();
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
}
// REMOVE sms INFO
function remove_sms_info(prime_sms_info_id){
if(confirm("Are you sure to delete!")){
if(prime_sms_info_id){
sms_info_module_id = $("#sms_info_module_id").val();
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/remove_sms_info"); ?>',
data: {prime_sms_info_id:prime_sms_info_id,sms_info_module_id:sms_info_module_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#sms_info_list").html(rslt.sms_info_list);
$('#sms_block_for,#assign_table_info').empty();
var option ="";
$.each(rslt.sms_block_for, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_block_for,#assign_table_info').append(option);
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
}
/* sms BASE INFO END*/
/* sms BASE INFO START*/
// EDIT sms INFO
function edit_sms_block(prime_sms_block_id){
if(prime_sms_block_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/edit_sms_block"); ?>',
data: {prime_sms_block_id:prime_sms_block_id},
success: function(data) {
var rslt = JSON.parse(data);
$('#sms_block_table option:selected').removeAttr('selected');
call_select();
if(rslt.success){
if(rslt.sms_block_column){
$('#sms_block_column').empty();
var option = "";
$.each(rslt.sms_block_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_block_column').append(option);
}
$("#prime_sms_block_id").val(rslt.sms_info.prime_sms_block_id);
$("#sms_block_name").val(rslt.sms_info.sms_block_name);
$("#sms_block_for").val(rslt.sms_info.sms_block_for);
$("#assign_table_info").val(rslt.sms_info.sms_block_for);
$("#sms_block_type").val(rslt.sms_info.sms_block_type);
if(rslt.sms_info.suppressed_data == 1){
$('#suppressed_data').prop('checked', true);
}
if(rslt.sms_info.cumulative_data == 1){
$('#cumulative_data').prop('checked', true);
}
if(rslt.sms_info.sms_block_table){
var sms_block_table = rslt.sms_info.sms_block_table.split(",");
for(var i in sms_block_table) {
var sms_block_table_val = sms_block_table[i];
$("#sms_block_table").find("option[value='"+sms_block_table_val+"']").prop("selected", "selected");
}
}
if(rslt.sms_info.sms_block_column){
var sms_block_column = rslt.sms_info.sms_block_column.split(",");
for(var i in sms_block_column) {
var sms_block_column_val = sms_block_column[i];
$("#sms_block_column").find("option[value='"+sms_block_column_val+"']").prop("selected", "selected");
}
}
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
}
// REMOVE sms INFO
function remove_sms_block(prime_sms_block_id){
if(confirm("Are you sure to delete!")){
if(prime_sms_block_id){
sms_block_module_id = $("#sms_block_module_id").val();
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/remove_sms_block"); ?>',
data: {prime_sms_block_id:prime_sms_block_id,sms_block_module_id:sms_block_module_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#sms_block_list").html(rslt.sms_block_list);
$('#sms_table_list,#assign_table_block').empty();
var option ="";
$.each(rslt.sms_table_list, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_table_list,#assign_table_block').append(option);
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
}
/* sms BASE INFO END*/
//Next Tab to Display
function activaTab(tab){
$('.nav-tabs a[href="#' + tab + '"]').tab('show');
};
//
function get_block_table(){
var sms_block_for = parseInt($('#sms_block_for').val());
if(sms_block_for > 0){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_block_table"); ?>',
data: {sms_block_for:sms_block_for},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
if(parseInt(rslt.sms_type) === 2){
$("#sms_block_table").val(["cw_employees","cw_transactions"]);
$("select[name='sms_block_table[]']").attr('readonly','readonly');
if(rslt.sms_block_column){
$('#sms_block_column').empty();
var option = "";
$.each(rslt.sms_block_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_block_column').html(option);
}
}else{
$("#sms_block_table").val('');
$("select[name='sms_block_table[]']").attr('readonly',false);
}
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
}
/* sms BASE INFO START*/
function call_sms_builder(assign_table_info){
$('div#sms_froala_editor').froalaEditor('destroy');
$('div#sms_froala_editor').html("");
if(assign_table_info){
$('div#sms_froala_editor').html(assign_table_info);
}
$(function(){
$('div#sms_froala_editor').on('froalaEditor.initialized', function (e, editor){
editor.events.bindClick($('body'), '#sms_btn', function () {
assign_type = $("#sms_assign_type").val();
var assign_value = "";
if(assign_type === "1"){
assign_value = $("#sms_assign_label").val();
}else
if(assign_type === "2"){
assign_value = $("#sms_assign_short_label").val();
}else
if(assign_type === "3"){
assign_value = $("#sms_assign_value_for").val();
date_formte = $("#sms_assign_date_formate").val();
if(date_formte){
assign_value = assign_value.replace(/\@/g,"");
assign_value = "@"+date_formte+"_"+assign_value+"_"+date_formte+"@";
}
}else
if(assign_type === "5"){
assign_value = $("#sms_list_view_value").val();
}
editor.html.insert(assign_value);
editor.undo.saveStep();
});
}).froalaEditor({
toolbarButtons: ['fullscreen', '|','bold', '|','fontFamily', '|','fontSize', '|','color', '|','align','|','insertTable', '|','insertImage', '|','insertHR', '|', 'sms', '|', 'html', '|', 'undo','|', 'redo'],
//pluginsEnabled: ['image', 'link', 'draggable'],
saveInterval: 500,
heightMin: 150,
heightMax: 300,
imageUploadURL: './upload_image.php',
imageMaxSize: 5 * 1024 * 1024,
imageAllowedTypes: ['jpeg', 'jpg', 'png'],
saveParam: 'content',
saveURL: '<?php echo site_url($controller_name . "/save_sms_design"); ?>',
saveMethod: 'POST',
}).on('froalaEditor.save.before', function (e, editor){
//ACTION BEFORE SAVE
assign_table_info = $("#sms_assign_table_info").val();
template_id = $("#template_id").val();
if(assign_table_info === "0"){
toastr.error("Please select sms info");
return false;
}
if(template_id === ""){
toastr.error("Please enter the subject");
return false;
}
var newOpts = {saveParams: {assign_table_info: assign_table_info,template_id:template_id}}
$.extend(editor.opts, newOpts)
}).on('froalaEditor.save.after', function (e, editor, response) {
//ACTION AFETR SAVE
var rslt = JSON.parse(response);
//toastr.remove();
toastr.success(rslt.message);
}).on('froalaEditor.save.error', function (e, editor, error) {
//SAVE ERROR
toastr.error("Something went wrong please retry");
});
});
}
function edit_sms_table_info(prime_sms_table_id,sms_info_module_id){
// var sms_block_for = parseInt($('#sms_block_for').val());
// if(sms_block_for > 0){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/edit_sms_table_info"); ?>',
data: {prime_sms_table_id:prime_sms_table_id,sms_info_module_id:sms_info_module_id},
success: function(data) {
var rslt = JSON.parse(data);
var sms_block_type = rslt.sms_info.sms_block_type;
var sms_info_select = rslt.sms_info_select;
var sms_block_select = rslt.sms_block_select;
var sms_table_select = rslt.sms_block_table;
$("#prime_sms_table_id").val(rslt.sms_info.prime_sms_table_id);
$('#sms_table_list').empty();
$('#sms_name_table').empty();
$('#sms_table_column option:selected').removeAttr('selected');
$('#sms_table_sms_column option:selected').removeAttr('selected');
call_select();
if(rslt.success){
if(rslt.sms_block_column){
$('#sms_table_column').empty();
var option = "";
$.each(rslt.sms_block_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_table_column').append(option);
}
if(rslt.sms_block_column_sms){
$('#sms_table_sms_column').empty();
var option = "";
$.each(rslt.sms_block_column_sms, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_table_sms_column').append(option);
}
var column_option ="";
$.each(rslt.sms_info_name, function( key, value ) {
column_option += '<option value="' + key + '">' + value + '</option>';
});
var block_option ="";
$.each(rslt.sms_block_list, function( key, value ) {
block_option += '<option value="' + key + '">' + value + '</option>';
});
$('#sms_table_list').append(column_option);
$("#sms_table_list").find("option[value='"+sms_info_select+"']").prop("selected", "selected");
$('#sms_name_table').append(block_option);
$("#sms_name_table").find("option[value='"+sms_block_select+"']").prop("selected", "selected");
if(rslt.sms_info.sms_table_column){
var sms_table_column = rslt.sms_info.sms_table_column.split(",");
for(var i in sms_table_column) {
var sms_block_column_val = sms_table_column[i];
$("#sms_table_column").find("option[value='"+sms_block_column_val+"']").prop("selected", "selected");
}
}
if(rslt.sms_info.sms_table_sms_column){
var sms_table_sms_column = rslt.sms_info.sms_table_sms_column.split(",");
for(var i in sms_table_sms_column) {
var sms_block_column_val = sms_table_sms_column[i];
$("#sms_table_sms_column").find("option[value='"+sms_block_column_val+"']").prop("selected", "selected");
}
}
call_select();
}else{
toastr.error(rslt.message);
}
},
});
// }
}
function remove_sms_table_info(prime_sms_table_id,sms_info_module_id){
if(confirm("Are you sure to delete!")){
if(prime_sms_table_id){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/remove_sms_table_info"); ?>',
data: {prime_sms_table_id:prime_sms_table_id,sms_info_module_id:sms_info_module_id},
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#sms_table_list_info").html(rslt.sms_table_info_list);
$('#sms_table_list').val('');
$('#sms_name_table').val('');
$('#sms_table_column').val('');
$('#sms_table_sms_column').val('');
call_select();
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
}
</script>
<style>
select[readonly].select2 + .select2-container {
pointer-events: none;
touch-action: none;
}
td{
word-break: break-word;
}
</style>