File: /home/cafsindia/uds.cafsinfotech.in/application/views_bk/email_setting/email_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;
}
.tab-content{
height: 400px;
overflow-y: scroll !important;
}
.modal{
overflow-y: hidden !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="#email_info">Email Info</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#email_block">Email Column Info</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#email_table">Email Table Info</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#email_join_table">Email Table Join</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#email_content_join_table">Email Content Join</a>
</li>
<!-- <li role="presentation">
<a data-toggle="tab" href="#email_design">email Design</a>
</li> -->
<li role="presentation">
<a data-toggle="tab" href="#email_design">Email Design</a>
</li>
</ul>
<?php $count_mobile_column = count($mobile_column);?>
<div class="tab-content">
<div class="tab-pane fade in active" id="email_info">
<?php echo form_open('email_setting/save_email_info/' . $email_info_module_id,array('id'=>'save_email_info','class'=>'form-inline')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_email_info_id', 'id'=>'prime_email_info_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'email_info_module_id', 'id'=>'email_info_module_id', 'type'=>'Hidden','value'=>$email_info_module_id));
echo form_label($this->lang->line('email_info_name'), 'email_info_name', array('class' => 'required'));
echo form_input(array('name'=> 'email_info_name', 'id' => 'email_info_name', 'class' => 'form-control input-sm', "placeholder"=>$this->lang->line('email_info_name'),'value' =>''));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('email_info_for'), 'email_for', array('class' => 'required'));
echo form_dropdown(array('name' => 'email_info_for[]','multiple id' =>'email_info_for','class' => 'form-control input-sm select2'), $email_for);
echo "<label><input name='email_info_for_select' id='email_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 select2'), $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 select2'),$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 select2'),$table_values);
?>
</div>
<div class="form-group">
<?php
$email_attach_type = array("2"=>"NO","1"=>"Yes",);
echo form_label($this->lang->line('email_attach_type'), 'email_attach_type', array('class' => ''));
echo form_dropdown(array('name' => 'email_attach_type','id' =>'email_attach_type','class' => 'form-control input-sm select2'),$email_attach_type);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('email_attach_column'), 'email_attach_column', array('class' => 'required'));
echo form_dropdown(array('name' => 'email_attach_column','id' =>'email_attach_column','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="email_info_submit">Add/Update</button>
<a class='btn btn-danger btn-sm' id="email_info_cancel">Cancel</a>
</div>
<?php echo form_close(); ?>
<div style='padding:15px;' id='email_info_list'>
<?php
print_r($email_info_list);
?>
</div>
</div>
<div class="tab-pane fade" id="email_block">
<?php echo form_open('email_setting/save_email_block/' . $email_info_module_id,array('id'=>'save_email_block','class'=>'form-inline' ,'style'=>'background-color: #f2f2f2;')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_email_block_id', 'id'=>'prime_email_block_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'email_block_module_id', 'id'=>'email_block_module_id', 'type'=>'Hidden','value'=>$email_info_module_id));
echo form_label($this->lang->line('email_block_for'), 'email_block_for', array('class' => 'required'));
echo form_dropdown(array('name' => 'email_block_for','id' =>'email_block_for','class' => 'form-control input-sm select2'), $email_block_for);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('email_block_name'), 'email_block_name', array('class' => 'required'));
echo form_input(array('name'=> 'email_block_name', 'id' => 'email_block_name', 'class' => 'form-control input-sm', "placeholder"=>$this->lang->line('email_block_name'),'value' =>''));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('email_block_table'), 'email_block_table', array('class' => 'required'));
echo form_dropdown(array('name' => 'email_block_table[]','multiple id' =>'email_block_table','class' => 'form-control input-sm select2'), $table_list);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('email_block_column'), 'email_block_column', array('class' => 'required'));
echo form_dropdown(array('name' => 'email_block_column','id' =>'email_block_column','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('email_block_type'), 'email_block_type', array('class' => 'required'));
$email_block_type_list = array("0"=>"--- Select Block Type ---","1"=>"Primary","2"=>"Secondary",);
echo form_dropdown(array('name' => 'email_block_type','id' =>'email_block_type','class' => 'form-control input-sm select2'), $email_block_type_list);
?>
</div>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="email_block_submit">Add/Update</button>
<a class='btn btn-danger btn-sm' id="email_block_cancel">Cancel</a>
</div>
<?php echo form_close(); ?>
<div style='padding:15px;' id='email_block_list'>
<?php
print_r($email_block_list);
?>
</div>
</div>
<div class="tab-pane fade" id="email_table">
<?php echo form_open('email_setting/get_email_table_info/' . $email_info_module_id,array('id'=>'get_email_table_info','class'=>'form-inline' ,'style'=>'background-color: #f2f2f2;')); ?>
<div class="form-group">
<?php
echo form_input( array('name'=>'prime_email_table_id', 'id'=>'prime_email_table_id', 'type'=>'Hidden','value'=>0));
echo form_input( array('name'=>'email_block_module_id', 'id'=>'email_block_module_id', 'type'=>'Hidden','value'=>$email_info_module_id));
echo form_label($this->lang->line('email_table_list'), 'email_table_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'email_table_list','id' =>'email_table_list','class' => 'form-control input-sm select2'), $email_block_for);
?>
</div>
<div class="form-group">
<?php
$email_name_table = array('' => "--- Select Column ---");
echo form_label($this->lang->line('email_name_table'), 'email_name_table', array('class' => 'required'));
echo form_dropdown(array('name' => 'email_name_table','id' =>'email_name_table','class' => 'form-control input-sm select2'), $email_name_table);
?>
</div>
<div class="form-group">
<?php
$email_table_column = array('0' => "--- Select Column ---");
echo form_label($this->lang->line('email_table_column'), 'email_table_column', array('class' => 'required'));
echo form_dropdown(array('name' => 'email_table_column[]','multiple id' =>'email_table_column','class' => 'form-control input-sm select2'), $email_table_column);
?>
</div>
<div class="form-group">
<?php
$email_table_email_column = array('0' => "--- Select Column ---");
echo form_label($this->lang->line('email_table_email_column'), 'email_table_email_column', array('class' => 'required'));
echo form_dropdown(array('name' => 'email_table_email_column[]','multiple id' =>'email_table_email_column','class' => 'form-control input-sm select2'), $email_table_email_column);
?>
</div>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="email_table_submit">Add/Update</button>
<a class='btn btn-danger btn-sm' id="email_table_cancel">Cancel</a>
</div>
<?php echo form_close(); ?>
<div style='padding:15px;' id='email_table_info_list'>
<?php
print_r($email_table_info_list);
?>
</div>
</div>
<div class="tab-pane fade" id="email_join_table">
<?php echo form_open('email_setting/get_join_table_info/' . $email_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_email_table_join_id', 'id'=>'prime_email_table_join_id', 'type'=>'Hidden','value'=>0));
echo form_label($this->lang->line('email_table_list'), 'email_table_join_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'email_table_join_list','id' =>'email_table_join_list','class' => 'form-control input-sm select2'), $email_table_list);
?>
</div>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="email_table_info_view">View</button>
</div>
<?php echo form_close(); ?>
<div id="email_table_content">
<ul class="nav nav-tabs" data-tabs="tabs">
<li class="active" role="presentation">
<a data-toggle="tab" href="#email_map_table">Map Table</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#email_table_where">Map Where</a>
</li>
</ul>
<div class="tab-content">
<div class="tab-pane fade in active" id="email_map_table" style='padding:15px;'>
<?php echo form_open('email_setting/save_email_table/' . $prime_module_id,array('id'=>'save_email_table','class'=>'form-inline')); ?>
<!-- LOAD CONTENT FROM CONTROLLER -->
<?php echo form_close(); ?>
</div>
<div class="tab-pane fade" id="email_table_where" style='padding:15px;'>
<?php echo form_open('email_setting/save_email_where/' . $prime_module_id,array('id'=>'save_email_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 select2 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 select2'), $query_type_array);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('pick_list'), 'pick_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'pick_list[]','multiple id' =>'pick_list','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('session_list'), 'session_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'session_list','id' =>'session_list','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group">
<a class='btn btn-edit btn-sm' id="apply_condition">Apply to Condition</a>
</div>
<br/>
<div style='padding: 15px 0px; background-color: #efefef;'>
<div class="form-group" style="width:75% !important;margin-bottom: 0px !important;">
<textarea name='where_condition' id='where_condition'class='form-control' rows='4' placeholder='Write Condition with out where' >and</textarea>
</div>
<div class="form-group">
<button class='btn btn-primary btn-sm' id="save_query_btn">Add/Update</button>
<a class='btn btn-danger btn-sm' id="dlt_query_btn">Delete</a>
</div>
</div>
<?php echo form_close(); ?>
</div>
</div>
</div>
</div>
<div class="tab-pane fade" id="email_content_join_table">
<?php echo form_open('email_setting/get_content_join_table_info/' . $email_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_email_content_table_join_id', 'id'=>'prime_email_content_table_join_id', 'type'=>'Hidden','value'=>0));
echo form_label($this->lang->line('email_table_list'), 'email_table_join_list', array('class' => 'required'));
echo form_dropdown(array('name' => 'email_content_table_join_list','id' =>'email_content_table_join_list','class' => 'form-control input-sm select2'), $email_table_list);
?>
</div>
<div class="form-group" style='margin-bottom:0px;'>
<button class='btn btn-primary btn-sm' id="email_content_table_info_view">View</button>
</div>
<?php echo form_close(); ?>
<div id="email_content_table_content">
<ul class="nav nav-tabs" data-tabs="tabs">
<li class="active" role="presentation">
<a data-toggle="tab" href="#email_content_map_table">Map Table</a>
</li>
<li role="presentation">
<a data-toggle="tab" href="#email_table_content_where">Map Where</a>
</li>
</ul>
<div class="tab-content">
<div class="tab-pane fade in active" id="email_content_map_table" style='padding:15px;'>
<?php echo form_open('email_setting/save_email_content_table/' . $prime_module_id,array('id'=>'save_email_content_table','class'=>'form-inline')); ?>
<!-- LOAD CONTENT FROM CONTROLLER -->
<?php echo form_close(); ?>
</div>
<div class="tab-pane fade" id="email_table_content_where" style='padding:15px;'>
<?php echo form_open('email_setting/save_email_content_where/' . $prime_module_id,array('id'=>'save_email_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 select2 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 select2'), $query_type_array);
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('pick_list'), 'pick_list', array('class' => 'required'));
echo form_dropdown(array('name' => '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 select2'));
?>
</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="email_design">
<form class="form-inline">
<div class="form-group">
<?php
echo form_label('Select email Info', 'email_assign_table_info', array('class' => 'required'));
echo form_dropdown(array('name' => 'assign_table_info','id' =>'email_assign_table_info','class' => 'form-control input-sm select2'), $email_block_for);
?>
</div>
<div class="form-group">
<?php
echo form_label("Email Subject", 'email_subject', array('class' => 'required'));
echo form_input(array('name'=> 'email_subject', 'id' => 'email_subject', 'class' => 'form-control input-sm', "placeholder"=>"Mail Subject",'value' =>''));
?>
</div>
<div class="form-group">
<?php
echo form_label("Email Id", 'bcc_mail', array('class' => 'required'));
echo form_textarea(array('name'=> 'bcc_mail', 'id' => 'bcc_mail', 'class' => 'form-control input-sm', "placeholder"=>"BCC",'value' =>''));
?>
</div>
<div class="form-group">
<?php
echo form_label('Select email Block', 'email_assign_table_block', array('class' => ''));
echo form_dropdown(array('name' => 'assign_table_block','id' =>'email_assign_table_block','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_type'), 'email_assign_type', array('class' => ''));
echo form_dropdown(array('name' => 'email_assign_type','id' =>'email_assign_type','class' => 'form-control input-sm'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_label'), 'email_assign_label', array('class' => ''));
echo form_dropdown(array('name' => 'email_assign_label','id' =>'email_assign_label','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_short_label'), 'email_assign_short_label', array('class' => ''));
echo form_dropdown(array('name' => 'email_assign_short_label','id' =>'email_assign_short_label','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_value_for'), 'email_assign_value_for', array('class' => ''));
echo form_dropdown(array('name' => 'email_assign_value_for','id' =>'email_assign_value_for','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('list_view_value'), 'email_list_view_value', array('class' => ''));
echo form_dropdown(array('name' => 'email_list_view_value','id' =>'email_list_view_value','class' => 'form-control input-sm select2'));
?>
</div>
<div class="form-group">
<?php
echo form_label($this->lang->line('assign_date_formate'), 'email_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' => 'email_assign_date_formate','id' =>'email_assign_date_formate','class' => 'form-control input-sm select2'),$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="email_btn">Assign</a>
</div>
</form>
<div id="email_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();
});
$("#email_table_content,#email_content_table_content").hide();
/* email BASE INFO START*/
$("#email_info_for_select").click(function(){
if($("#email_info_for_select").is(':checked') ){
$("#email_info_for > option").prop("selected","selected");
$("#email_info_for").trigger("change");
}else{
$("#email_info_for > option").removeAttr("selected");
$("#email_info_for").trigger("change");
}
});
var email_type_id = parseInt($('#email_type_id').val());
if(email_type_id === 2){
$("select[name='email_block_table[]']").attr('readonly','readonly');
}
$('#save_email_info').validate($.extend({
submitHandler: function (form){
$("#email_info_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#email_info_submit').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
let email_info_for_arr = [];
$('select[name="email_info_for[]"]').each(function (a , b) {
email_info_for_arr[a] = $(this).val();
});
jsonData['email_info_for'] = email_info_for_arr[0];
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_email_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#email_info_submit').attr('disabled',false);
$("#email_info_submit").html("Add/Update");
if(response.success){
var email_type = parseInt($('#email_type').val());
document.getElementById("save_email_info").reset();
$("#prime_email_info_id").val(0);
$('#email_info_for option:selected').removeAttr('selected');
$("#email_info_list").html(response.email_info_list);
$('#email_block_for,#assign_table_info').empty();
var option ="";
$.each(response.email_block_for, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_block_for,#assign_table_info').append(option);
/*$('#email_type_id').val(email_type);
if(email_type === 2){
$("#email_block_table").val(["cw_employees","cw_transactions"]);
$("select[name='email_block_table[]']").attr('readonly','readonly');
}*/
call_select();
toastr.success(response.message);
activaTab('email_block');
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
email_block_for: {
required: true,
alphanumeric:true,
space_check:true,
},
"email_info_name": "required",
"email_info_for[]": "required",
"query_list_id": "required",
"query_column_list": "required",
"table_values": "required",
"email_attach_column": "required",
}
}));
$("#email_info_cancel").click(function(){
document.getElementById("save_email_info").reset();
$("#prime_email_info_id").val(0);
$('#email_info_for option:selected').removeAttr('selected');
$('#email_info_submit').attr('disabled',false);
$("#email_info_submit").html("Add/Update");
call_select();
});
/* email 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 email_info_module_id = "<?php echo $email_info_module_id;?>";
if(query_list_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {query_list_id:query_list_id,email_info_module_id:email_info_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_query_column_list"); ?>',
data:encData,
contentType: 'text/plain',
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);
}
},
});
}
});
$("#email_table_list").change(function(){
$('#email_name_table').empty();
var email_table_list = $('#email_table_list').val();
var email_info_module_id = "<?php echo $email_info_module_id;?>";
if(query_list_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {email_table_list:email_table_list,email_info_module_id:email_info_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_query_block_list"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data){
var rslt = JSON.parse(data);
if(rslt.success){
var column_option ="";
$.each(rslt.column_list, function( key, value ) {
column_option += '<option value="' + key + '">' + value + '</option>';
});
$('#email_name_table').append(column_option);
}else{
toastr.error(rslt.msg);
}
},
});
}
});
$("#email_name_table").change(function(){
var email_name_table = $('#email_name_table').val();
var email_info_module_id = "<?php echo $email_info_module_id;?>";
if(query_list_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {email_name_table:email_name_table,email_info_module_id:email_info_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_query_table_column_list"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data){
var rslt = JSON.parse(data);
$('#email_table_column').empty();
$('#email_table_email_column').empty();
var bcc_email_type = rslt.bcc_email_type;
if(rslt.success){
var column_option ="";
$.each(rslt.email_block_column, function( key, value ) {
column_option += '<option value="' + key + '">' + value + '</option>';
});
var column_options ="";
$.each(rslt.email_block_column_email, function( key, value ) {
column_options += '<option value="' + key + '">' + value + '</option>';
});
$('#email_table_column').append(column_option);
$('#email_table_email_column').append(column_options);
}else{
toastr.error(rslt.msg);
}
},
});
}
});
// $("#email_table_column").change(function(){
// var email_table_column = $("input[name='email_table_column[]'],select[name='email_table_column[]']").map(function(){return $(this).val();}).get();
// var email_info_module_id = "<?php echo $email_info_module_id;?>";
// var email_name_table = $('#email_name_table').val();
// $.ajax({
// type: "POST",
// url: '<?php echo site_url($controller_name . "/get_email_column_only"); ?>',
// data: {email_table_column:email_table_column,email_info_module_id:email_info_module_id,email_name_table:email_name_table},
// success: function(data){
// var rslt = JSON.parse(data);
// $('#email_table_email_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>';
// }
// });
// $('#email_table_email_column').append(column_option);
// }else{
// toastr.error(rslt.msg);
// }
// },
// });
// });
$("#email_attach_type").change(function(){
var email_attach_type = $("#email_attach_type").val();
var email_info_module_id = "<?php echo $email_info_module_id;?>";
if(parseInt(email_attach_type) === 1){
$("#email_attach_column").parent().show();
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {email_attach_type:email_attach_type,email_info_module_id:email_info_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_attachment_column"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data){
var rslt = JSON.parse(data);
$('#email_attach_column').empty();
if(rslt.success){
var column_option ="";
$.each(rslt.print_column, function( key, value ) {
column_option += '<option value="' + key + '">' + value + '</option>';
});
$('#email_attach_column').append(column_option);
}else{
toastr.error(rslt.msg);
}
},
});
}else{
$("#email_attach_column").parent().hide();
$("#email_attach_column").val('');
}
call_select();
});
/* email BLOCK INFO START*/
$("#email_block_table").change(function(){
var email_block_table = $('#email_block_table').val();
if(email_block_table){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {email_block_table:email_block_table};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_email_block_table"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
var email_block_column = $('#email_block_column').val();
if((email_block_column == null) || (email_block_column == "NULL")){
$('#email_block_column option:selected').removeAttr('selected');
}
call_select();
if(rslt.success){
if(rslt.email_block_column){
$('#email_block_column').empty();
var option = "";
$.each(rslt.email_block_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_block_column').html(option);
}
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
});
$('#save_email_block').validate($.extend({
submitHandler: function (form){
$("#email_block_submit").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#email_block_submit').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
let email_block_table_arr = [];
$('select[name="email_block_table[]"]').each(function (a , b) {
email_block_table_arr[a] = $(this).val();
});
jsonData['email_block_table'] = email_block_table_arr[0];
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_email_block"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#email_block_submit').attr('disabled',false);
$("#email_block_submit").html("Add/Update");
if(response.success){
$('#email_block_table option:selected').removeAttr('selected');
$('#email_block_column option:selected').removeAttr('selected');
document.getElementById("save_email_block").reset();
$("#prime_email_block_id").val(0);
call_select();
$("#email_block_list").html(response.email_block_list);
$('#assign_table_block').empty();
var option ="";
$.each(response.email_table_list, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#assign_table_block').append(option);
toastr.success(response.message);
$("#email_table_content").hide();
$("#email_content_table_content").hide();
$("#email_table_join_list").val(0);
$("#email_content_table_join_list").val(0);
activaTab('email_table');
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
email_block_for: {
required: true,
min:1,
},
email_block_type: {
required: true,
min:1,
},
email_block_name: {
required: true,
alphanumeric:true,
space_check:true,
},
"email_block_table[]": "required",
"email_block_column[]": "required",
}
}));
$("#email_block_cancel").click(function(){
document.getElementById("save_email_block").reset();
$("#prime_email_block_id").val(0);
$('#email_block_submit').attr('disabled',false);
$("#email_block_submit").html("Add/Update");
call_select();
});
$("#email_table_cancel").click(function(){
document.getElementById("get_email_table_info").reset();
$("#email_table_list").val('');
$("#email_name_table").val('');
$("#email_table_column").val('');
$("#email_table_email_column").val('');
$('#email_table_submit').attr('disabled',false);
$("#email_table_submit").html("Add/Update");
call_select();
});
/* email BLOCK INFO END*/
$('#get_join_table_info').validate($.extend({
submitHandler: function (form){
$("#email_table_info_view").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#email_table_info_view').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_join_table_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#email_table_info_view').attr('disabled',false);
$("#email_table_info_view").html("View");
if(response.success){
$("#save_email_table").html(response.email_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_email_block_id);
$("#where_module_id").val(response.email_block_module_id);
$("#where_condition").val(response.where_condition);
$("#email_table_content").show();
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
email_table_join_list: {
required: true,
min:1,
},
}
}));
$('#get_content_join_table_info').validate($.extend({
submitHandler: function (form){
$("#email_content_table_info_view").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#email_content_table_info_view').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_content_join_table_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#email_content_table_info_view').attr('disabled',false);
$("#email_content_table_info_view").html("View");
if(response.success){
$("#save_email_content_table").html(response.email_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_email_block_id);
$("#content_where_module_id").val(response.email_block_module_id);
$("#content_where_condition").val(response.where_condition);
$("#email_content_table_content").show();
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
email_content_table_join_list: {
required: true,
min:1,
},
}
}));
/* email TABLE INFO START*/
$('#get_email_table_info').validate($.extend({
submitHandler: function (form){
$("#email_table_info_view").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#email_table_info_view').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
let email_table_column_arr = [];
$('select[name="email_table_column[]"]').each(function (a , b) {
email_table_column_arr[a] = $(this).val();
});
jsonData['email_table_column'] = email_table_column_arr[0];
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_email_table_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#email_table_info_view').attr('disabled',false);
$("#email_table_info_view").html("View");
if(response.success){
toastr.success(response.message);
$("#email_table_list_info").html(response.email_table_info_list);
$("#save_email_table").html(response.email_table_block);
$('#email_table_list').val('');
$('#email_name_table').val('');
$('#email_table_column').val('');
$('#email_table_email_column').val('');
call_select();
activaTab("email_join_table");
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
email_table_list: {
required: true,
min:1,
},
email_name_table: {
required: true
},
"email_table_column[]": "required",
"email_table_email_column[]": "required",
}
}));
$('#save_email_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_email_table_save").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_email_table_save').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_email_table"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#save_email_table_save').attr('disabled',false);
$("#save_email_table_save").html("Save");
toastr.success(response.message);
},
dataType: 'json'
});
}else{
toastr.error("Map all table join");
}
}
});
$('#save_email_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_email_content_table_save").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_email_content_table_save').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_email_content_table"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#save_email_content_table_save').attr('disabled',false);
$("#save_email_content_table_save").html("Save");
toastr.success(response.message);
},
dataType: 'json'
});
}else{
toastr.error("Map all table join");
}
}
});
/* email TABLE INFO END*/
/* email WHERE INFO START*/
$('#save_email_where').validate($.extend({
submitHandler: function (form){
$("#save_query_btn").html("<i class='fa fa-spinner fa-spin'></i> Processing...");
$('#save_query_btn').attr('disabled','disabled');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_email_where"); ?>',
data:encData,
contentType: 'text/plain',
success: function (response){
$('#save_query_btn').attr('disabled',false);
$("#save_query_btn").html("Add/Update");
if(response.success){
toastr.success(response.message);
//document.getElementById("save_email_where").reset();
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
where_condition: {
required:true,
/*notEqual: true,*/
}
}
}));
/* DELETE WHERE TABLE */
$("#dlt_query_btn").click(function(){
var where_for_id = $("#where_for_id").val();
var where_module_id = $("#where_module_id").val();
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {where_for_id:where_for_id,where_module_id:where_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/dlt_where_table_query"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#where_condition").val('and');
toastr.success(rslt.message);
}
},
});
});
$('#save_email_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');
//Encrypted
let formData = new FormData(form);
// Convert FormData to JSON object
let jsonData = Object.fromEntries(formData.entries());
var encKey = '<?php echo $encKey; ?>';
var encData = encrypt(encKey,jsonData);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/save_email_content_where"); ?>',
data:encData,
contentType: 'text/plain',
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_email_where").reset();
}else{
toastr.error(response.message);
}
},
dataType: 'json'
});
},
rules:{
content_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 email_info_module_id = "<?php echo $email_info_module_id;?>";
if(query_column){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {query_column:query_column,where_module_id:where_module_id,query_list_id:query_list_id,query_column_list:query_column_list,email_info_module_id:email_info_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_column_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
$('#pick_list').empty();
$('#session_list').empty();
$('#picklist_type,#pick_list,#session_list').parent().hide();
if(rslt.success){
if(rslt.type === "pick_list"){
var pick_option ="";
$.each(rslt.pick_list, function( key, value ) {
pick_option += '<option value="' + key + '">' + value + '</option>';
});
$('#pick_list').append(pick_option);
var session_option ="";
$.each(rslt.session_list, function( key, value ) {
session_option += '<option value="' + key + '">' + value + '</option>';
});
$('#session_list').append(session_option);
$('#picklist_type').parent().show();
}else
if(rslt.type === "session_list"){
var option ="";
$.each(rslt.session_list, function( key, value ) {
option += '<option value="' + key + '">' + value + '</option>';
});
$('#session_list').append(option);
$('#session_list').parent().show();
}
$("#query_type").val(rslt.type);
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 email_info_module_id = "<?php echo $email_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,email_info_module_id:email_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){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {content_query_column:content_query_column,content_where_module_id:content_where_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_content_column_info"); ?>',
data:encData,
contentType: 'text/plain',
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){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {query_column:query_column,where_module_id:where_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_column_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
$('#pick_list').empty();
$('#session_list').empty();
$('#picklist_type,#pick_list,#session_list').parent().hide();
if(rslt.success){
if(rslt.type === "pick_list"){
var pick_option ="";
$.each(rslt.pick_list, function( key, value ) {
pick_option += '<option value="' + key + '">' + value + '</option>';
});
$('#pick_list').append(pick_option);
var session_option ="";
$.each(rslt.session_list, function( key, value ) {
session_option += '<option value="' + key + '">' + value + '</option>';
});
$('#session_list').append(session_option);
$('#picklist_type').parent().show();
}else
if(rslt.type === "session_list"){
var option ="";
$.each(rslt.session_list, function( key, value ) {
option += '<option value="' + key + '">' + value + '</option>';
});
$('#session_list').append(option);
$('#session_list').parent().show();
}
$("#query_type").val(rslt.type);
}else{
toastr.error(rslt.msg);
}
},
});
}
});
$("#picklist_type").change(function(){
$('#pick_list,#session_list').parent().hide();
picklist_type = $("#picklist_type").val();
if(picklist_type === "1"){
$('#pick_list').parent().show();
}else
if(picklist_type === "2"){
$('#session_list').parent().show();
}
call_select()
});
$("#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);
}
});
/* email WHERE INFO END*/
/* email 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){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {assign_table_info:assign_table_info};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/assign_table_info"); ?>',
data:encData,
contentType: 'text/plain',
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_email_builder(rslt.email_design);
}else{
toastr.error(rslt.message);
}
},
});
}else{
toastr.error("Please select email 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){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {assign_table_block:assign_table_block};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/assign_table_block"); ?>',
data:encData,
contentType: 'text/plain',
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 email 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_email_design").click(function(){
$('#froala-editor').froalaEditor('save.save');
});
/* email DESIGN START*/
$("#email_assign_table_block,#email_assign_type,#email_assign_label,#email_assign_short_label,#email_assign_value_for,#email_list_view_value,#email_assign_date_formate,#email_btn,#email_subject,#bcc_mail,#email_attach_column").parent().hide();
$("#email_assign_table_info").change(function(){
assign_table_info = $("#email_assign_table_info").val();
$("#email_assign_table_block,#email_assign_type,#email_assign_label,#email_assign_short_label,#email_assign_value_for,#email_list_view_value,#email_assign_date_formate,#email_btn,#email_subject,#bcc_mail").parent().hide();
if(assign_table_info){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {assign_table_info:assign_table_info};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/email_assign_table_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#email_assign_table_block,#email_list_view_value').empty();
var option ="";
$.each(rslt.assign_table_block, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_assign_table_block').append(option);
var option ="";
$.each(rslt.list_view_value, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_list_view_value').append(option);
$("#email_assign_table_block").parent().show();
$("#email_subject").parent().show();
$('#email_subject').val(rslt.email_subject);
$("#bcc_mail").parent().show();
$('#bcc_mail').val(rslt.bcc_mail);
$("#email_attach_type").parent().show();
$('#email_attach_type').val(rslt.email_attach_type);
$('#email_subject').val(rslt.email_subject);
var email_attach_type = rslt.email_attach_type;
if(parseInt(email_attach_type) === 1){
var type_val = 1;
}else
if(parseInt(email_attach_type)=== 2){
var type_val = 2;
}else{
var type_val = '';
}
$("#email_attach_type").find("option[value='"+type_val+"']").prop("selected", "selected");
// PAGE BUILDER WITH DATA IF EXIST.
call_email_builder(rslt.email_design);
}else{
toastr.error(rslt.message);
}
},
});
}else{
toastr.error("Please select email info");
}
});
$("#email_assign_table_block").change(function(){
assign_table_block = $("#email_assign_table_info").val();
$("#email_assign_type,#email_assign_label,#email_assign_short_label,#email_assign_value_for,#email_list_view_value,#email_assign_date_formate,#email_btn").parent().hide();
if(assign_table_block){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {assign_table_block:assign_table_block};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/assign_table_block"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$('#email_assign_label,#email_assign_short_label,#email_assign_value_for,#email_assign_type').empty();
var option ="";
$.each(rslt.assign_type, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_assign_type').append(option);
var option ="";
$.each(rslt.assign_label, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_assign_label').append(option);
var option ="";
$.each(rslt.assign_short_label, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_assign_short_label').append(option);
var option ="";
$.each(rslt.assign_value_for, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_assign_value_for').append(option);
$("#email_assign_type").parent().show();
}else{
toastr.error(rslt.message);
}
},
});
}else{
toastr.error("Please select email block");
}
});
$("#email_assign_type").change(function(){
assign_type = $("#email_assign_type").val();
$("#email_assign_label,#email_assign_short_label,#email_assign_value_for,#email_list_view_value,#email_assign_date_formate,#email_btn").parent().hide();
if(assign_type === "1"){
$("#email_assign_label,#email_btn").parent().show();
}else
if(assign_type === "2"){
$("#email_assign_short_label,#email_btn").parent().show();
}else
if(assign_type === "3"){
$("#email_assign_value_for,#email_btn").parent().show();
}
});
//assign_value_for assign_date_formate
$("#email_assign_value_for").change(function(){
$("#email_assign_date_formate").val("");
assign_value_for = $("#email_assign_value_for").val();
email_assign_type = $("#email_assign_type").val();
email_info_module_id = "<?php echo $email_info_module_id;?>";
if(parseInt(email_assign_type) === 3){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {assign_value_for:assign_value_for,email_info_module_id:email_info_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/select_date_format_data"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#email_assign_date_formate").parent().show();
}else{
$("#email_assign_date_formate").parent().hide();
$("#email_assign_date_formate").val("");
}
},
});
}
call_select();
});
$("#save_email_design").click(function(){
$('#email_froala_editor').froalaEditor('save.save');
});
/* email DESIGN INFO END*/
/* email DESIGN INFO END*/
$("#email_block_for").change(function(){
get_block_table();
});
//HIDE SHOW FOR email BASED ON(OFFER LETTER)
email_based_on();
$('#email_type').on('change',function(){
email_based_on();
});
});
function email_based_on(){
$('#email_based_on').parent().hide();
var email_type = $('#email_type').val();
if(parseInt(email_type) === 3){
$('#email_based_on').parent().show();
}else{
$('#email_based_on').parent().hide();
}
}
function call_select(){
$(function(){
$('.select2').select2({
placeholder: '---- Select ----',
allowClear: true,
dropdownParent: $('.modal-dialog')
});
$('.select2-tags').select2({
tags: true,
tokenSeparators: [',']
});
});
}
/* email BASE INFO START*/
// EDIT SPLIT INFO
function edit_split_info(prime_email_split_id){
if(prime_email_split_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {prime_email_split_id:prime_email_split_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/edit_split_info"); ?>',
data:encData,
contentType: 'text/plain',
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 email INFO
function remove_split_info(prime_email_split_id){
if(confirm("Are you sure to delete!")){
if(prime_email_split_id){
email_info_module_id = $("#email_info_module_id").val();
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {prime_email_split_id:prime_email_split_id,email_info_module_id:email_info_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/remove_split_info"); ?>',
data:encData,
contentType: 'text/plain',
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 email INFO
function edit_email_info(prime_email_info_id){
var email_info_module_id = "<?php echo $email_info_module_id;?>";
if(prime_email_info_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {prime_email_info_id:prime_email_info_id,email_info_module_id:email_info_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/edit_email_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
$('#email_for option:selected').removeAttr('selected');
var query_column_list = rslt.email_info.query_column_list;
var table_values = rslt.email_info.table_values;
var email_attach_type = rslt.email_info.email_attach_type;
var email_attach_column = rslt.email_info.email_attach_column;
if(parseInt(email_attach_type) === 1){
$("#email_attach_column").parent().show();
}else{
$("#email_attach_column").parent().hide();
}
call_select();
if(rslt.success){
$('#table_values').empty();
$('#email_attach_column').empty();
$("#prime_email_info_id").val(rslt.email_info.prime_email_info_id);
$("#email_info_name").val(rslt.email_info.email_info_name);
$("#query_list_id").val(rslt.email_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>';
});
var print_column ="";
$.each(rslt.print_column, function( key, value ) {
print_column += '<option value="' + key + '">' + value + '</option>';
});
$('#email_attach_column').append(print_column);
$('#table_values').append(table_option);
$("#table_values").find("option[value='"+table_values+"']").prop("selected", "selected");
$("#email_attach_type").find("option[value='"+email_attach_type+"']").prop("selected", "selected");
$("#email_attach_column").find("option[value='"+email_attach_column+"']").prop("selected", "selected");
if(rslt.email_info.email_info_for){
var email_info_for = rslt.email_info.email_info_for.split(",");
for(var i in email_info_for) {
var email_info_for_val = email_info_for[i];
$("#email_info_for").find("option[value='"+email_info_for_val+"']").prop("selected", "selected");
email_based_on();
}
}
$("#query_column_list,#table_values").parent().show();
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
}
// REMOVE email INFO
function remove_email_info(prime_email_info_id){
if(confirm("Are you sure to delete!")){
if(prime_email_info_id){
email_info_module_id = $("#email_info_module_id").val();
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {prime_email_info_id:prime_email_info_id,email_info_module_id:email_info_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/remove_email_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#email_info_list").html(rslt.email_info_list);
$('#email_block_for,#assign_table_info').empty();
var option ="";
$.each(rslt.email_block_for, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_block_for,#assign_table_info').append(option);
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
}
/* email BASE INFO END*/
/* email BASE INFO START*/
// EDIT email INFO
function edit_email_block(prime_email_block_id){
if(prime_email_block_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {prime_email_block_id:prime_email_block_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/edit_email_block"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
$('#email_block_table option:selected').removeAttr('selected');
call_select();
if(rslt.success){
if(rslt.email_block_column){
$('#email_block_column').empty();
var option = "";
$.each(rslt.email_block_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_block_column').append(option);
}
$("#prime_email_block_id").val(rslt.email_info.prime_email_block_id);
$("#email_block_name").val(rslt.email_info.email_block_name);
$("#email_block_for").val(rslt.email_info.email_block_for);
$("#assign_table_info").val(rslt.email_info.email_block_for);
$("#email_block_type").val(rslt.email_info.email_block_type);
if(rslt.email_info.suppressed_data == 1){
$('#suppressed_data').prop('checked', true);
}
if(rslt.email_info.cumulative_data == 1){
$('#cumulative_data').prop('checked', true);
}
if(rslt.email_info.email_block_table){
var email_block_table = rslt.email_info.email_block_table.split(",");
for(var i in email_block_table) {
var email_block_table_val = email_block_table[i];
$("#email_block_table").find("option[value='"+email_block_table_val+"']").prop("selected", "selected");
}
}
if(rslt.email_info.email_block_column){
var email_block_column = rslt.email_info.email_block_column.split(",");
for(var i in email_block_column) {
var email_block_column_val = email_block_column[i];
$("#email_block_column").find("option[value='"+email_block_column_val+"']").prop("selected", "selected");
}
}
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
}
// REMOVE email INFO
function remove_email_block(prime_email_block_id){
if(confirm("Are you sure to delete!")){
if(prime_email_block_id){
email_block_module_id = $("#email_block_module_id").val();
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {prime_email_block_id:prime_email_block_id,email_block_module_id:email_block_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/remove_email_block"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#email_block_list").html(rslt.email_block_list);
$('#email_table_list,#assign_table_block').empty();
var option ="";
$.each(rslt.email_table_list, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_table_list,#assign_table_block').append(option);
toastr.success(rslt.message);
}else{
toastr.error(rslt.message);
}
},
});
}
}
}
/* email BASE INFO END*/
//Next Tab to Display
function activaTab(tab){
$('.nav-tabs a[href="#' + tab + '"]').tab('show');
};
//
function get_block_table(){
var email_block_for = parseInt($('#email_block_for').val());
if(email_block_for > 0){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {email_block_for:email_block_for};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_block_table"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
if(parseInt(rslt.email_type) === 2){
$("#email_block_table").val(["cw_employees","cw_transactions"]);
$("select[name='email_block_table[]']").attr('readonly','readonly');
if(rslt.email_block_column){
$('#email_block_column').empty();
var option = "";
$.each(rslt.email_block_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_block_column').html(option);
}
}else{
$("#email_block_table").val('');
$("select[name='email_block_table[]']").attr('readonly',false);
}
call_select();
}else{
toastr.error(rslt.message);
}
},
});
}
}
/* email BASE INFO START*/
function call_email_builder(assign_table_info){
$('div#email_froala_editor').froalaEditor('destroy');
$('div#email_froala_editor').html("");
if(assign_table_info){
$('div#email_froala_editor').html(assign_table_info);
}
$(function(){
$('div#email_froala_editor').on('froalaEditor.initialized', function (e, editor){
editor.events.bindClick($('body'), '#email_btn', function () {
assign_type = $("#email_assign_type").val();
var assign_value = "";
if(assign_type === "1"){
assign_value = $("#email_assign_label").val();
}else
if(assign_type === "2"){
assign_value = $("#email_assign_short_label").val();
}else
if(assign_type === "3"){
assign_value = $("#email_assign_value_for").val();
date_formte = $("#email_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 = $("#email_list_view_value").val();
}
editor.html.insert(assign_value);
editor.undo.saveStep();
});
}).froalaEditor({
toolbarButtons: ['fullscreen', '|','bold', '|','fontFamily', '|','fontSize', '|','color', '|','align','|','insertTable', '|','insertImage', '|','insertHR', '|', 'email', '|', '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_email_design"); ?>',
saveMethod: 'POST',
}).on('froalaEditor.save.before', function (e, editor){
//ACTION BEFORE SAVE
assign_table_info = $("#email_assign_table_info").val();
email_subject = $("#email_subject").val();
bcc_mail = $("#bcc_mail").val();
email_attach_type = $("#email_attach_type").val();
email_attach_column = $("#email_attach_column").val();
if(assign_table_info === "0"){
toastr.error("Please select email info");
return false;
}
if(email_subject === ""){
toastr.error("Please enter the subject");
return false;
}
var newOpts = {saveParams: {assign_table_info: assign_table_info,email_subject:email_subject,bcc_mail:bcc_mail,email_attach_type:email_attach_type,email_attach_column:email_attach_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");
});
});
}
function edit_email_table_info(prime_email_table_id,email_info_module_id){
// var email_block_for = parseInt($('#email_block_for').val());
// if(email_block_for > 0){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {prime_email_table_id:prime_email_table_id,email_info_module_id:email_info_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/edit_email_table_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
var email_block_type = rslt.email_info.email_block_type;
var email_info_select = rslt.email_info_select;
var email_block_select = rslt.email_block_select;
var email_table_select = rslt.email_block_table;
$("#prime_email_table_id").val(rslt.email_info.prime_email_table_id);
$('#email_table_list').empty();
$('#email_name_table').empty();
$('#email_table_column option:selected').removeAttr('selected');
$('#email_table_email_column option:selected').removeAttr('selected');
call_select();
if(rslt.success){
if(rslt.email_block_column){
$('#email_table_column').empty();
var option = "";
$.each(rslt.email_block_column, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_table_column').append(option);
}
if(rslt.email_block_column_email){
$('#email_table_email_column').empty();
var option = "";
$.each(rslt.email_block_column_email, function (index, value) {
option += '<option value="' + index + '">' + value + '</option>';
});
$('#email_table_email_column').append(option);
}
var column_option ="";
$.each(rslt.email_info_name, function( key, value ) {
column_option += '<option value="' + key + '">' + value + '</option>';
});
var block_option ="";
$.each(rslt.email_block_list, function( key, value ) {
block_option += '<option value="' + key + '">' + value + '</option>';
});
$('#email_table_list').append(column_option);
$("#email_table_list").find("option[value='"+email_info_select+"']").prop("selected", "selected");
$('#email_name_table').append(block_option);
$("#email_name_table").find("option[value='"+email_block_select+"']").prop("selected", "selected");
if(rslt.email_info.email_table_column){
var email_table_column = rslt.email_info.email_table_column.split(",");
for(var i in email_table_column) {
var email_block_column_val = email_table_column[i];
$("#email_table_column").find("option[value='"+email_block_column_val+"']").prop("selected", "selected");
}
}
if(rslt.email_info.email_table_email_column){
var email_table_email_column = rslt.email_info.email_table_email_column.split(",");
for(var i in email_table_email_column) {
var email_block_column_val = email_table_email_column[i];
$("#email_table_email_column").find("option[value='"+email_block_column_val+"']").prop("selected", "selected");
}
}
call_select();
}else{
toastr.error(rslt.message);
}
},
});
// }
}
function remove_email_table_info(prime_email_table_id,email_info_module_id){
if(confirm("Are you sure to delete!")){
if(prime_email_table_id){
// Encryption
var encKey = '<?php echo $encKey; ?>';
var data = {prime_email_table_id:prime_email_table_id,email_info_module_id:email_info_module_id};
var encData = encrypt(encKey,data);
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/remove_email_table_info"); ?>',
data:encData,
contentType: 'text/plain',
success: function(data) {
var rslt = JSON.parse(data);
if(rslt.success){
$("#email_table_list_info").html(rslt.email_table_info_list);
$('#email_table_list').val('');
$('#email_name_table').val('');
$('#email_table_column').val('');
$('#email_table_email_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>