File: //home/cafsindia/allyindian_com/sbltt/application/views/package/add_package.php
<?php echo form_open('package/save_package_line/'. $package->package_id,array('id'=>'add_package','class'=>'form-inline')); ?>
<fieldset id="FundBasicInfo">
<div class='col-md-12' style='padding:0px;'>
<div class="col-md-3" style='padding:0px 4px;max-height:531px;overflow:auto;'>
<h5 style='color:#d84f57;'>Customer List</h5>
<table class="table table-hover table-striped table-bordered" style='font-size:11px !important;'>
<thead>
<tr>
<th>Name</th>
<th>Address</th>
</tr>
</thead>
<tbody id="customer_list">
</tbody>
</table>
</div>
<div class="col-md-9" style='padding:0px 4px;border-left: 1px dashed #CCCCCC;'>
<div class="form-group" style='margin-bottom:0px;'>
<?php
echo form_label("Search Customer", 'enquiry_search', array('class' => 'control-label required'));
echo form_input(
array(
'name'=>'enquiry_search',
'id'=>'enquiry_search',
'placeholder'=>'Search Customer',
'class'=>'form-control input-sm',
'value'=>$enquiry->enquiry_search
)
);
?>
</div><br/><br/>
<div class="form-group">
<?php echo form_label($this->lang->line('customer_name'), 'customer_name', array('class' => 'control-label required')); ?>
<?php
echo form_input(array(
'name' => 'customer_name',
'id' => 'customer_name',
'class' => 'form-control input-sm alpha',
'value' => $cust_info->customer_name)
);
?>
</div>
<div class="form-group">
<?php echo form_label($this->lang->line('common_phone_number'), 'phone_number', array('class' => 'required')); ?>
<?php
echo form_input(array(
'name' => 'phone_number',
'id' => 'phone_number',
'class' => 'form-control input-sm number',
'value' => $cust_info->phone_number)
);
?>
</div>
<div class="form-group">
<?php echo form_label($this->lang->line('common_altphone_number'), 'altphone_number', array('class' => '')); ?>
<?php
echo form_input(array(
'name' => 'alt_number',
'id' => 'alt_number',
'class' => 'form-control input-sm number',
'value' => $cust_info->alt_number)
);
?>
</div>
<div class="form-group">
<?php echo form_label($this->lang->line('common_email'), 'email', array('class' => '')); ?>
<?php
echo form_input(array(
'name' => 'email',
'id' => 'email',
'type' => 'email',
'class' => 'form-control input-sm',
'value' => $cust_info->cust_email)
);
?>
</div>
<div class="form-group">
<textarea placeholder="Customer Address" name="cust_address" id="cust_address" class="form-control" rows="4"><?php echo $cust_info->cust_address; ?></textarea>
</div>
<div class="form-group">
<?php echo form_label($this->lang->line('common_city'), 'city', array('class' => 'required')); ?>
<?php
echo form_input(array(
'name' => 'city',
'id' => 'city',
'class' => 'form-control input-sm',
'value' => $cust_info->city)
);
?>
</div>
<div class="form-group">
<?php echo form_label($this->lang->line('common_state'), 'state', array('class' => 'required ')); ?>
<?php
echo form_dropdown(array(
'name' => 'state',
'id' => 'state',
'class' => 'form-control input-sm'), $state_info, $cust_info->state);
?>
</div>
<div class="form-group ">
<?php echo form_label("Date Of Birth", 'dob', array('class' => '')); ?>
<?php
$dob = "";
if($cust_info->dob){
$dob = date('d-m-Y',strtotime($cust_info->dob));
}
echo form_input(array(
'name'=>'dob',
'id'=>'dob',
'class'=>'form-control input-sm datepicker',
'placeholder'=>'DD-MM-YYYY',
'value'=>$dob)
);
?>
</div>
<div class="form-group">
<?php echo form_label("Pickup Point", 'pickup_point', array('class' => 'required')); ?>
<?php
echo form_input(array(
'name' => 'pickup_point',
'id' => 'pickup_point',
'class' => 'form-control input-sm',
'value' => $temple_enquiry->pickup_point)
);
?>
</div>
<div class="form-group">
<?php echo form_label("Amount", 'amount', array('class' => 'required')); ?>
<?php
echo form_input(array(
'name' => 'amount',
'id' => 'amount',
'class' => 'form-control input-sm number',
'value' => $temple_enquiry->amount)
);
?>
</div>
<div class="form-group">
<?php echo form_label("Discount", 'discount', array('class' => 'required')); ?>
<?php
echo form_input(array(
'name' => 'discount',
'id' => 'discount',
'class' => 'form-control input-sm number',
'value' => $temple_enquiry->discount)
);
?>
</div>
<div class="form-group">
<?php echo form_label("Balance", 'balance', array('class' => 'required')); ?>
<?php
echo form_input(array(
'name' => 'balance',
'id' => 'balance',
'class' => 'form-control input-sm number',
'value' => $temple_enquiry->balance)
);
?>
</div>
<div class="form-group">
<?php echo form_label("PNR", 'pnr', array('class' => 'required')); ?>
<?php
echo form_input(array(
'name' => 'pnr',
'id' => 'pnr',
'class' => 'form-control input-sm',
'value' => $temple_enquiry->pnr)
);
?>
</div>
<div class="form-group">
<?php echo form_label("Seat#", 'seat_no', array('class' => 'required')); ?>
<?php
echo form_input(array(
'name' => 'seat_no',
'id' => 'seat_no',
'class' => 'form-control input-sm number',
'value' => $temple_enquiry->seat_no)
);
?>
</div>
<div class="form-group">
<?php echo form_label("Payment Type", 'payment_type', array('class' => 'control-label required')); ?>
<?php
$payment_type = array('' => '--Select Payment Type--','Cash' => 'Cash','Net_Banking' => 'Net Banking','Card_Payment' => 'Card Payment','Wallet' => 'Wallet Payment','Others' => 'Others');
echo form_dropdown(array(
'name' => 'payment_type',
'id' => 'payment_type',
'class' => 'form-control input-sm'), $payment_type, $booking->payment_type);
?>
</div>
<div class="form-group">
<?php echo form_label("Sourcing", 'sourcing', array('class' => 'required')); ?>
<?php
$sourcing = array('' => '--Select Referral Type--','Regular' => 'Regular','Web' => 'Web','Referral' => 'Referral','Staff_Referral' => 'Staff Referral','Banner' => 'Banner','Others' => 'Others');
echo form_dropdown(array(
'name' => 'sourcing',
'id' => 'sourcing',
'class' => 'form-control input-sm'), $sourcing,$temple_enquiry->sourcing);
?>
</div>
<div class="form-group">
<?php echo form_label("Enquiry Status", 'enquiry_sts', array('class' => 'control-label required')); ?>
<?php
$enquiry_sts = array('' => '--Select Status--','1' => 'Pending','2' => 'Confirm','3' => 'Cancelled');
echo form_dropdown(array(
'name' => 'enquiry_sts',
'id' => 'enquiry_sts',
'class' => 'form-control input-sm'), $enquiry_sts, $temple_enquiry->enquiry_sts);
?>
</div>
<div class="form-group">
<?php echo form_label("Feedback", 'feedback', array('class' => 'control-label')); ?>
<?php
$feed_back_info = array('' => '--Select--','Good_Service' => 'Good Service','High_Rate' => 'High Rate','Need_to_improve_in_food' => 'Need to improve in food','Need_to_improve_in_VAS' => 'Need to improve in VAS','Need_to_improve_in_Accommodation' => 'Need to improve in Accommodation','Others' => 'Others');
echo form_dropdown(array('name' => 'feedback','id' => 'feedback','class' => 'form-control input-sm'), $feed_back_info);
?>
</div>
<div class="form-group">
<?php echo form_label("Driving / Driver", 'driving_driver', array('class' => 'control-label')); ?>
<?php
$feed_back_trip = array('' => '--Select--','Very_Good' => 'Very Good','Good' => 'Good','Fair' => 'Fair');
echo form_dropdown(array('name' => 'driving_driver','id' => 'driving_driver','class' => 'form-control input-sm'), $feed_back_trip);
?>
</div>
<div class="form-group">
<?php echo form_label("Vehicle", 'feed_vehicle', array('class' => 'control-label')); ?>
<?php
echo form_dropdown(array('name' => 'feed_vehicle','id' => 'feed_vehicle','class' => 'form-control input-sm'), $feed_back_trip);
?>
</div>
<div class="form-group">
<?php echo form_label("Food", 'feed_food', array('class' => 'control-label')); ?>
<?php
echo form_dropdown(array('name' => 'feed_food','id' => 'feed_food','class' => 'form-control input-sm'), $feed_back_trip);
?>
</div>
<div class="form-group">
<?php echo form_label("Accomodation", 'feed_accomodation', array('class' => 'control-label')); ?>
<?php
echo form_dropdown(array('name' => 'feed_accomodation','id' => 'feed_accomodation','class' => 'form-control input-sm'), $feed_back_trip);
?>
</div>
<div class="form-group">
<?php echo form_label("Overall Rating", 'feed_overall', array('class' => 'control-label')); ?>
<?php
echo form_dropdown(array('name' => 'feed_overall','id' => 'feed_overall','class' => 'form-control input-sm'), $feed_back_trip);
?>
</div>
<div class="form-group">
<textarea placeholder="Remarks / Feedback if any" name="remark" id="remark" class="form-control" rows="4"><?php echo $temple_enquiry->remark; ?></textarea>
</div>
<?php
echo form_input( array( 'name'=>'package_id', 'id'=>'package_id', 'type'=>'Hidden', 'class'=>'form-control input-sm', 'value'=>$package->package_id ));
echo form_input( array( 'name'=>'package_line_id', 'id'=>'package_line_id', 'type'=>'Hidden', 'class'=>'form-control input-sm', 'value'=>''));
?>
<button type='submit' class='btn btn-primary btn-sm' style='background:#d84f57;border:1px solid #d84f57;padding:6px 30px;margin-top:-10px;'>Add / Update</button>
</div>
</div>
</fieldset>
<?php echo form_close(); ?>
<table id="table" class="table table-hover table-striped">
<thead>
<tr>
<th>Sl.no</th>
<th>Name</th>
<th>Mobile#</th>
<th>Pickup Point</th>
<th>sourcing</th>
<th>Status</th>
<th>Feedback</th>
<th>Edit</th>
</tr>
</thead>
<tbody id='package_list'>
<?php
$count = 0;
foreach($package_line as $key => $value){
$count++;
$package_line_id = $value->package_line_id;
$cust_name = $value->customer_name;
$cust_mob = $value->phone_number;
$pickup_point = $value->pickup_point;
$discount = $value->discount;
$sourcing = $value->sourcing;
$feedback = $value->feedback;
$feedback = str_replace("_"," ",$feedback);
if($value->enquiry_sts === "1"){
$enquiry_sts = "Pending";
}else
if($value->enquiry_sts === "2"){
$enquiry_sts = "Confirm";
}else
if($value->enquiry_sts === "3"){
$enquiry_sts = "Cancelled";
}
echo "<tr>
<td>$count</td>
<td>$cust_name</td>
<td>$cust_mob</td>
<td>$pickup_point</td>
<td>$sourcing</td>
<td>$enquiry_sts</td>
<td>$feedback</td>
<td><a style='cursor: pointer;' onclick=edit_pack_line('$package_line_id')>Edit</a></td>
</tr>";
}
?>
</tbody>
</table>
<script type="text/javascript">
$(document).ready(function(){
$(function () {
$(".datepicker").datetimepicker({
format: 'DD-MM-YYYY'
});
});
$(".number").bind('keyup', function(e) {
this.value = this.value.replace(/[^0-9_.]/g,'');
});
$('#enquiry_search').keyup(function(e) {
var term = $("#enquiry_search").val();
$("#customer_name").val("");
$("#phone_number").val("");
$("#alt_number").val("");
$("#email").val("");
$("#cust_address").val("");
$("#city").val("");
$("#state").val("");
$("#dob").val("");
if(term !== ""){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/suggest_customer"); ?>',
data: {term:term},
success: function(data) {
var tr = "";
var rslt = JSON.parse(data);
for(i = 0; i < rslt.search.length; i++){
cust_id = rslt.search[i].cust_id;
customer_name = rslt.search[i].customer_name;
phone_number = rslt.search[i].phone_number;
cust_email = rslt.search[i].cust_email;
cust_address = rslt.search[i].cust_address;
tr += "<tr style='cursor:pointer;'onclick=select_customer("+cust_id+")><td>"+customer_name+"<br/>"+phone_number+"</td><td>"+cust_address+"</td></tr>";
}
if(tr === ""){
tr = "<tr><td colspan='2'>Customer not exists</td></tr>";
}
$("#customer_list").html(tr);
},
});
}
});
$('#add_package').validate($.extend({
submitHandler: function (form){
$('#add_package').attr('disabled','disabled');
$(form).ajaxSubmit({
success: function (rslt){
var tr = "";
var count = 0;
for(i = 0; i < rslt.package_line_info.length; i++) {
count++;
package_line_id = rslt.package_line_info[i].package_line_id;
customer_name = rslt.package_line_info[i].customer_name;
phone_number = rslt.package_line_info[i].phone_number;
pickup_point = rslt.package_line_info[i].pickup_point;
discount = rslt.package_line_info[i].discount;
sourcing = rslt.package_line_info[i].sourcing;
feedback = rslt.package_line_info[i].feedback;
enquiry_sts = rslt.package_line_info[i].enquiry_sts;
if(feedback){
feedback = feedback.split('_').join(' ');
}else{
feedback = "";
}
if(enquiry_sts === "1"){
enquiry_sts = "Pending";
}else
if(enquiry_sts === "2"){
enquiry_sts = "Confirm";
}else
if(enquiry_sts === "3"){
enquiry_sts = "Cancelled";
}
edit = "<a style='cursor: pointer;' onclick=edit_pack_line('"+package_line_id+"')>Edit</a>";
tr += "<tr><td>"+count+"</td><td>"+customer_name+"</td><td>"+phone_number+"</td><td>"+pickup_point+"</td><td>"+sourcing+"</td><td>"+enquiry_sts+"</td><td>"+feedback+"</td><td>"+edit+"</td></tr>";
}
if(tr !== ""){
$("#package_list").html(tr);
}
$("#package_line_id").val("");
$("#customer_name").val("");
$("#phone_number").val("");
$("#alt_number").val("");
$("#email").val("");
$("#cust_address").val("");
$("#city").val("");
$("#state").val("");
$("#dob").val("");
$("#pickup_point").val("");
$("#discount").val("");
$("#sourcing").val("");
$("#enquiry_sts").val("");
$("#feedback").val("");
$("#remark").val("");
$("#driving_driver").val("");
$("#feed_vehicle").val("");
$("#feed_food").val("");
$("#feed_accomodation").val("");
$("#amount").val("");
$("#balance").val("");
$("#pnr").val("");
$("#seat_no").val("");
$("#payment_type").val("");
},
dataType: 'json'
});
},
rules:{
customer_name: "required",
phone_number: "required",
cust_address: "required",
city: "required",
state: "required",
dob: "required",
pickup_point: "required",
discount: "required",
sourcing: "required",
enquiry_sts: "required",
amount: "required",
balance: "required",
pnr: "required",
seat_no: "required",
payment_type: "required",
}
}));
});
function edit_pack_line(package_line_id){
if(package_line_id !== ""){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_pack_line"); ?>',
data: {package_line_id:package_line_id},
success: function(data) {
var rslt = JSON.parse(data);
for(i = 0; i < rslt.package_line_info.length; i++) {
package_line_id = rslt.package_line_info[i].package_line_id;
customer_name = rslt.package_line_info[i].customer_name;
phone_number = rslt.package_line_info[i].phone_number;
alt_number = rslt.package_line_info[i].alt_number;
cust_email = rslt.package_line_info[i].cust_email;
cust_address = rslt.package_line_info[i].cust_address;
city = rslt.package_line_info[i].city;
state = rslt.package_line_info[i].state;
dob = rslt.package_line_info[i].dob;
pickup_point = rslt.package_line_info[i].pickup_point;
discount = rslt.package_line_info[i].discount;
sourcing = rslt.package_line_info[i].sourcing;
enquiry_sts = rslt.package_line_info[i].enquiry_sts;
feedback = rslt.package_line_info[i].feedback;
remark = rslt.package_line_info[i].remark;
driving_driver = rslt.package_line_info[i].driving_driver;
feed_vehicle = rslt.package_line_info[i].feed_vehicle;
feed_food = rslt.package_line_info[i].feed_food;
feed_accomodation = rslt.package_line_info[i].feed_accomodation;
feed_overall = rslt.package_line_info[i].feed_overall;
amount = rslt.package_line_info[i].amount;
balance = rslt.package_line_info[i].balance;
pnr = rslt.package_line_info[i].pnr;
seat_no = rslt.package_line_info[i].seat_no;
payment_type = rslt.package_line_info[i].payment_type;
dob = moment(dob).format('DD-MM-YYYY');
$("#package_line_id").val(package_line_id);
$("#customer_name").val(customer_name);
$("#phone_number").val(phone_number);
$("#alt_number").val(alt_number);
$("#email").val(cust_email);
$("#cust_address").val(cust_address);
$("#city").val(city);
$("#state").val(state);
$("#dob").val(dob);
$("#pickup_point").val(pickup_point);
$("#discount").val(discount);
$("#sourcing").val(sourcing);
$("#enquiry_sts").val(enquiry_sts);
$("#feedback").val(feedback);
$("#remark").val(remark);
$("#driving_driver").val(driving_driver);
$("#feed_vehicle").val(feed_vehicle);
$("#feed_food").val(feed_food);
$("#feed_accomodation").val(feed_accomodation);
$("#amount").val(amount);
$("#balance").val(balance);
$("#pnr").val(pnr);
$("#seat_no").val(seat_no);
$("#payment_type").val(payment_type);
}
},
});
}
}
function select_customer(cust_id){
if(cust_id !== ""){
$.ajax({
type: "POST",
url: '<?php echo site_url($controller_name . "/get_customer"); ?>',
data: {term:cust_id},
success: function(data) {
var tr = "";
var rslt = JSON.parse(data);
for(i = 0; i < rslt.search.length; i++){
cust_id = rslt.search[i].cust_id;
customer_name = rslt.search[i].customer_name;
phone_number = rslt.search[i].phone_number;
alt_number = rslt.search[i].alt_number;
cust_email = rslt.search[i].cust_email;
cust_address = rslt.search[i].cust_address;
city = rslt.search[i].city;
state = rslt.search[i].state;
dob = rslt.search[i].dob;
}
$("#customer_name").val(customer_name);
$("#phone_number").val(phone_number);
$("#alt_number").val(alt_number);
$("#email").val(cust_email);
$("#cust_address").val(cust_address);
$("#city").val(city);
$("#state").val(state);
$("#dob").val(dob);
},
});
}
}
</script>