File: /home/cafsindia/groups_cafsindia_com/application/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 Block</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#sms_table">Sms Table</a>
</li>
<!-- <li role="presentation">
<a data-toggle="tab" href="#sms_split_up">Sms split up</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>
<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_type'), 'sms_block_type', array('class' => 'required'));
$sms_block_type_list = array("0"=>"--- Select Block Type ---","1"=>"Normal View","2"=>"List View",);
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">
<?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[]','multiple id' =>'sms_block_column','class' => 'form-control input-sm select2'));
?>
</div>
<!-- <div class="form-group">
<label>
<input name='suppressed_data' id='suppressed_data' type='checkbox'>Suppressed Page</input>
</label>
</div> -->
<!-- <div class="form-group">
<label>
<input name='cumulative_data' id='cumulative_data' type='checkbox'>Is Cumulative</input>
</label>
</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_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_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_split_up">
<form class="form-inline">
<div class="form-group">
<?php
echo form_label("Split Information", 'split_table_info', array('class' => 'required'));
echo form_dropdown(array('name' => 'split_table_info','id' =>'split_table_info','class' => 'form-control input-sm'), $sms_block_for);
?>
</div>
<div class="form-group">
<?php
echo form_label("Select Info", 'split_info', array('class' => 'required'));
$split_info = array(""=>"--- Select split_info ---",1=>"Loan Amount");
echo form_dropdown(array('name' => 'split_info','id' =>'split_info','class' => 'form-control input-sm'),$split_info);
?>
</div>
<div class="form-group">
<?php
echo form_label("Select split column", 'split_colum', array('class' => 'required'));
echo form_dropdown(array('name' => 'split_colum','id' =>'split_colum','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<a class='btn btn-primary btn-sm' id="split_save_btn">Add/Update</a>
<a class='btn btn-danger btn-sm' id="split_cancel_btn">Cancel</a>
</div>
</form>
<div style='padding:15px;' id='split_table_list'>
<?php
print_r($split_table_list);
?>
</div>
</div> -->
<!-- <div class="tab-pane fade" id="sms_design">
<form class="form-inline">
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_table_info'), 'assign_table_info', array('class' => 'required'));
echo form_dropdown(array('name' => 'assign_table_info','id' =>'assign_table_info','class' => 'form-control input-sm'), $sms_block_for);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_table_block'), 'assign_table_block', array('class' => 'required'));
echo form_dropdown(array('name' => 'assign_table_block','id' =>'assign_table_block','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_type'), 'assign_type', array('class' => ''));
echo form_dropdown(array('name' => 'assign_type','id' =>'assign_type','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_label'), 'assign_label', array('class' => ''));
echo form_dropdown(array('name' => 'assign_label','id' =>'assign_label','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_short_label'), 'assign_short_label', array('class' => ''));
echo form_dropdown(array('name' => 'assign_short_label','id' =>'assign_short_label','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_value_for'), 'assign_value_for', array('class' => ''));
echo form_dropdown(array('name' => 'assign_value_for','id' =>'assign_value_for','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_ytd_label'), 'assign_ytd_label', array('class' => ''));
echo form_dropdown(array('name' => 'assign_ytd_label','id' =>'assign_ytd_label','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('list_view_value'), 'list_view_value', array('class' => ''));
echo form_dropdown(array('name' => 'list_view_value','id' =>'list_view_value','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_date_formate'), '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' => 'assign_date_formate','id' =>'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="assign_btn">Assign</a>
</div>
</form>
<div id="froala-editor" style="padding:0px 15px;margin-bottom:15px;"> </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("Sms Subject", 'sms_subject', array('class' => 'required'));
echo form_input(array('name'=> 'sms_subject', 'id' => 'sms_subject', 'class' => 'form-control input-sm', "placeholder"=>"Mail Subject",'value' =>''));
?>
</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"=>"Template Id",'value' =>''));
?>
</div>
<div class="form-group">
<?php
echo form_label('Mobile No Column', 'mobile_no_column', array('class' => 'required'));
echo form_dropdown(array('name' => 'mobile_no_column','id' =>'mobile_no_column','class' => 'form-control input-sm'), $mobile_column);
?>
</div>
<!-- <div class="form-group">
<?php
echo form_label("Additional Mobile", 'additional_moblile_no', array('class' => ''));
echo form_input(array('name'=> 'additional_moblile_no', 'id' => 'additional_moblile_no', 'class' => 'form-control input-sm', "placeholder"=>"Additional Mobile",'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").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 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);
$('#sms_table_list,#assign_table_block').empty();
var option ="";
$.each(response.sms_table_list, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#sms_table_list,#assign_table_block').append(option);
toastr.success(response.message);
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 BLOCK INFO END*/
/* 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){
$("#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_list: {
required: true,
min:1,
},
}
}));
$('#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");
}
}
});
/* 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,*/
}
}
}));
$('#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);
console.log(rslt.status);
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);
}
},
});
}
});
$("#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);
console.log(rslt);
$('#pick_list').empty();
$('#session_list').empty();
$('#picklist_type,#pick_list,#session_list').parent().hide();
if(rslt.success){
if(rslt.type === "pick_list"){
var pick_option ="";
$.each(rslt.pick_list, function( key, value ) {
pick_option += '<option value="' + key + '">' + value + '</option>';
});
$('#pick_list').append(pick_option);
var session_option ="";
$.each(rslt.session_list, function( key, value ) {
session_option += '<option value="' + key + '">' + value + '</option>';
});
$('#session_list').append(session_option);
$('#picklist_type').parent().show();
}else
if(rslt.type === "session_list"){
var option ="";
$.each(rslt.session_list, function( key, value ) {
option += '<option value="' + key + '">' + value + '</option>';
});
$('#session_list').append(option);
$('#session_list').parent().show();
}
$("#query_type").val(rslt.type);
}else{
toastr.error(rslt.msg);
}
},
});
}
});
$("#picklist_type").change(function(){
$('#pick_list,#session_list').parent().hide();
picklist_type = $("#picklist_type").val();
if(picklist_type === "1"){
$('#pick_list').parent().show();
}else
if(picklist_type === "2"){
$('#session_list').parent().show();
}
call_select()
});
$("#apply_condition").click(function(){
query_column = $("#query_column_list_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);
}
});
/* 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');
});
// $("#split_table_info").change(function(){
// split_table_info = $("#split_table_info").val();
// if(split_table_info){
// $.ajax({
// type: "POST",
// url: '<?php echo site_url($controller_name . "/split_table_info"); ?>',
// data: {split_table_info:split_table_info},
// success: function(data) {
// var rslt = JSON.parse(data);
// if(rslt.success){
// $('#split_colum').empty();
// var option ="";
// $.each(rslt.split_colum, function (index, value) {
// option += '<option value="' + index + '">' + value + '</option>';
// });
// $('#split_colum').append(option);
// }
// },
// });
// }else{
// toastr.error("Please select sms block");
// }
// });
// $("#split_save_btn").click(function(){
// var split_table_info = $("#split_table_info").val();
// var split_info = $("#split_info").val();
// var split_colum = $("#split_colum").val();
// if((split_table_info === "") || (split_info === "") || (split_colum === "")){
// toastr.error("Please select all required input");
// }else{
// $.ajax({
// type: "POST",
// url: '<?php echo site_url($controller_name . "/split_save"); ?>',
// data: {split_table_info:split_table_info,split_info:split_info,split_colum:split_colum},
// success: function(data) {
// var rslt = JSON.parse(data);
// if(rslt.success){
// $('#split_table_list').html(rslt.table_info);
// }
// $("#split_table_info").val(0);
// $("#split_info").val("");
// $("#split_colum").val("");
// },
// });
// }
// });
// $("#split_cancel_btn").click(function(){
// $("#split_table_info").val(0);
// $("#split_info").val('');
// $("#split_colum").val('');
// $('#split_save_btn').attr('disabled',false);
// $("#split_save_btn").html("Add/Update");
// call_select();
// });
/* sms DESIGN INFO END*/
/* 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,#sms_subject,#mail_bcc,#template_id,#additional_moblile_no,#mobile_no_column").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,#sms_subject").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();
$("#sms_subject").parent().show();
$('#sms_subject').val(rslt.sms_subject);
$("#mail_bcc").parent().show();
$("#template_id").parent().show();
$('#template_id').val(rslt.template_id);
$("#additional_moblile_no").parent().show();
$("#mobile_no_column").parent().show();
$('#additional_moblile_no').val(rslt.additional_moblile_no);
$('#mobile_no_column').val(rslt.mobile_no_column);
$('#sms_subject').val(rslt.sms_subject);
// 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_block").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
});
});
}
function call_sms_builder(assign_table_info){
$('div#froala-editor').froalaEditor('destroy');
$('div#froala-editor').html("");
if(assign_table_info){
$('div#froala-editor').html(assign_table_info);
}
$(function(){
$('div#froala-editor').on('froalaEditor.initialized', function (e, editor){
editor.events.bindClick($('body'), '#assign_btn', function () {
assign_type = $("#assign_type").val();
var assign_value = "";
if(assign_type === "1"){
assign_value = $("#assign_label").val();
}else
if(assign_type === "2"){
assign_value = $("#assign_short_label").val();
}else
if(assign_type === "3"){
assign_value = $("#assign_value_for").val();
date_formte = $("#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 === "4"){
assign_value = $("#assign_ytd_label").val();
}else
if(assign_type === "5"){
assign_value = $("#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'],
fontFamily: {
"Arial,Helvetica,sans-serif": 'Arial',
"Georgia,serif": 'Georgia',
"Impact,Charcoal,sans-serif": 'Impact',
"Tahoma,Geneva,sans-serif": 'Tahoma',
"Times New Roman,Times,serif": 'Times New Roman',
"Verdana,Geneva,sans-serif": 'Verdana',
"Cambria,sans-serif": 'Cambria',
},
fontFamilySelection: true,
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 = $("#assign_table_info").val();
if(assign_table_info === "0"){
toastr.error("Please select sms info");
return false;
}
var newOpts = {saveParams: {assign_table_info: assign_table_info}}
$.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");
});
});
}
/* 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();
sms_subject = $("#sms_subject").val();
template_id = $("#template_id").val();
additional_moblile_no = $("#additional_moblile_no").val();
mobile_no_column = $("#mobile_no_column").val();
if(assign_table_info === "0"){
toastr.error("Please select Sms info");
return false;
}
if(sms_subject === ""){
toastr.error("Please enter the subject");
return false;
}
if(template_id === ""){
toastr.error("Please enter the Template Id");
return false;
}
if(mobile_no_column === ""){
toastr.error("Please enter the Mobile No Column");
return false;
}
var newOpts = {saveParams: {assign_table_info: assign_table_info,sms_subject:sms_subject,template_id:template_id,additional_moblile_no:additional_moblile_no,mobile_no_column:mobile_no_column}}
$.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");
});
});
}
</script>
<style>
select[readonly].select2 + .select2-container {
pointer-events: none;
touch-action: none;
}
</style>