|
Server IP : 82.112.239.40 / Your IP : 3.16.57.110 Web Server : LiteSpeed System : Linux in-mum-web1676.main-hosting.eu 5.14.0-503.35.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 4 05:23:43 EDT 2025 x86_64 User : u641149403 ( 641149403) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u641149403/domains/cabz4you.com/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
require_once 'header.php';
require_once 'navbar.php';
$current_time = date('Y-m-d H:i:s');
$vendor_id = $_GET['vendor_id'];
$accept_booking = $conn->query("SELECT * FROM bookings LEFT JOIN payment_log ON payment_log.booking_id=bookings.id LEFT JOIN users ON users.id=bookings.user_id WHERE vendor_id='$vendor_id' AND status='vendor_pass'");
$cancelled_booking = $conn->query("SELECT * FROM bookings LEFT JOIN payment_log ON payment_log.booking_id=bookings.id LEFT JOIN users ON users.id=bookings.user_id WHERE vendor_id='$vendor_id' AND status='cancelled'");
$completed_booking = $conn->query("SELECT * FROM bookings LEFT JOIN payment_log ON payment_log.booking_id=bookings.id LEFT JOIN users ON users.id=bookings.user_id WHERE vendor_id='$vendor_id' AND status='completed'");
$posted_booking = $conn->query("SELECT * FROM bookings LEFT JOIN payment_log ON payment_log.booking_id=bookings.id LEFT JOIN users ON users.id=bookings.user_id WHERE post_by_id='$vendor_id'");
$sql = "select * from vendor_profile,vendor_login where vendor_login.id=vendor_profile.vendor_id and vendor_id='$vendor_id'";
$res = $conn->query($sql);
$data2 = $res->fetch_assoc();
$transaction = "select t.*,vendor.full_name,vendor.company_name,v.contact,v.email from transaction_log as t,vendor_profile as vendor,vendor_login as v where t.vendor_id=v.id and v.id=vendor.vendor_id and v.id='$vendor_id' order by time desc";
$transaction_result = $conn->query($transaction);
if ($transaction_result->num_rows > 0) {
// output data of each row
while ($row = $transaction_result->fetch_assoc()) {
$transactions[] = $row;
}
}
$booking_data = "SELECT bookings.*,bookings.id as bk_id,payment_log.txn_amount,payment_log.booking_id,users.* FROM bookings LEFT JOIN payment_log ON payment_log.booking_id=bookings.id LEFT JOIN users ON users.id=bookings.user_id WHERE vendor_id='$vendor_id' ORDER BY bookings.pickup_date DESC";
$booking_result = $conn->query($booking_data);
if ($booking_result->num_rows > 0) {
// output data of each row
while ($rows = $booking_result->fetch_assoc()) {
$table_data[] = $rows;
}
}
$membership_status = $conn->query("SELECT * FROM membership_log WHERE vendor_id='$vendor_id' AND start<='$current_time' AND end>='$current_time' AND status=1");
?>
<!-- Page content -->
<div class="container-fluid pt-8">
<div class="page-header mt-0 p-3">
<h3 class="mb-sm-0">View Vendor</h3>
</div>
<div class="row">
<div class="col-lg-3">
<div class="info-box">
<span class="info-box-icon bg-green"><i class="fa fa-check-circle"></i></span>
<div class="info-box-content">
<span class="info-box-text">Accept Booking</span>
<span class="info-box-number"><?= $accept_booking->num_rows ?></span>
</div>
</div>
</div>
<div class="col-lg-3">
<div class="info-box">
<span class="info-box-icon bg-red"><i class="fa fa fa-ban"></i></span>
<div class="info-box-content">
<span class="info-box-text">Cancelled Booking</span>
<span class="info-box-number"><?= $cancelled_booking->num_rows ?></span>
</div>
</div>
</div>
<div class="col-lg-3">
<div class="info-box">
<span class="info-box-icon bg-green"><i class="fa fa-check-circle"></i></span>
<div class="info-box-content">
<span class="info-box-text">Completed Booking</span>
<span class="info-box-number"><?= $completed_booking->num_rows ?></span>
</div>
</div>
</div>
<div class="col-lg-3">
<div class="info-box">
<span class="info-box-icon bg-green"><i class="fa fa-check-circle"></i></span>
<div class="info-box-content">
<span class="info-box-text">Posted Booking</span>
<span class="info-box-number"><?= $posted_booking->num_rows ?></span>
</div>
</div>
</div>
</div>
<!-- Table -->
<div class="row">
<div class="col-12">
<div class="box box-default">
<div class="box-header with-border">
<h3 class="box-title">Profile Status:
<?php if ($data2['profile_status'] == 1) {
echo '<span class="text-success">Active</span>';
} else if ($data2['profile_status'] == 0) {
echo '<span class="text-danger">Blocked</span>';
} else {
echo '<span class="text-danger">Blocked</span>';
}
?>
| Account Status:
<?php
if ($data2['status'] == 1) {
$account_status = '<span class="text-success">Online</span>';
} else {
$account_status = '<span class="text-danger">Offline</span>';
}
echo $account_status;
?>
| Membership Status:
<?php
if ($membership_status->num_rows > 0) {
echo '<span class="text-success">Active</span>';
} else {
echo '<span class="text-danger">In Active</span>';
}
?>
</h3>
</div>
<div class="box-body">
<div class="row align-items-center">
<div class="col-md-2">
<img src="../images/logo.png" class="img-circle">
<br>
</div>
<div class="col-md-10">
<div class="spacer"></div>
<h2 style="margin-top:0;"><?= $data2['full_name'] ?>
<small><b>(<?= $account_status ?>)</b></small>
</h2>
<h5><?= $data2['address'] ?></h5>
<a href="edit_vendor?token=<?= $vendor_id ?>" class="btn btn-primary btn-sm">Edit
Profile</a>
<br>
</div>
</div>
<hr>
<div class="row mt-3">
<div class="col-md-3 border-right">
<h5>Date registered: <?= date("d-m-Y h:i A", strtotime($data2['timestamp'])) ?></h5>
<h5>Phone: +91 <?= $data2['contact'] ?></h5>
<h5>Email: <?= $data2['email'] ?></h5>
<h5>Wallet Amount: ₹<?= $data2['w_amount'] ?></h5>
</div>
<div class="col-md-3">
<h5>Bank Name: +91 <?= $data2['bank_name'] ?></h5>
<h5>Account Number: <?= $data2['account_no'] ?></h5>
<h5>IFSC Code: <?= $data2['ifsc_code'] ?></h5>
<h5>UPI ID: <?= $data2['upi_id'] ?></h5>
<h5>Account Type: <?= $data2['acc_type'] ?></h5>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-12">
<div class="box box-default">
<ul class="nav nav-tabs" role="tablist">
<li class="nav-item">
<a class="nav-link active" data-toggle="tab" href="#transactions" role="tab">Transactions</a>
</li>
<li class="nav-item">
<a class="nav-link" data-toggle="tab" href="#bookings" role="tab">Bookings</a>
</li>
<li class="nav-item">
<a class="nav-link" data-toggle="tab" href="#complaints" role="tab">Complaints</a>
</li>
<li class="nav-item">
<a class="nav-link" data-toggle="tab" href="#documents" role="tab">Documents</a>
</li>
<li class="nav-item">
<a class="nav-link" data-toggle="tab" href="#membership" role="tab">Membership</a>
</li>
</ul><!-- Tab panes -->
<div class="tab-content">
<div class="tab-pane p-3 active" id="transactions" role="tabpanel">
<div class="table-responsive">
<table id="example" class="table table-striped table-bordered text-nowrap w-100">
<thead>
<tr>
<th class="wd-15p">S.No</th>
<th class="wd-15p">Name</th>
<th class="wd-10p">Contact</th>
<th class="wd-10p">Amount</th>
<th class="wd-10p">Type</th>
<th class="wd-10p">Message</th>
<th class="wd-10p">Action</th>
<th class="wd-10p">Remark</th>
<th class="wd-10p">Date Time</th>
</tr>
</thead>
<tbody>
<?php
$x = 1;
foreach ($transactions as $hh) {
?>
<tr>
<td><?= $x; ?></td>
<td><a style="color: #4e4c73;font-weight:400"
href="edit_vendor?token=<?= $hh['vendor_id']; ?>"><?= $hh['full_name'] ?></a>
</td>
<td><?= $hh['contact']; ?></td>
<td><?= $hh['amount']; ?></td>
<td><?= ucfirst($hh['txn_type']); ?></td>
<td>
<?php
if ($hh['txn_type'] == 'Credit' || $hh['txn_type'] == 'credit') {
$new_balance = $hh['wallet_amount'] + $hh['amount'];
echo 'Old Balance: Rs.' . $hh['wallet_amount'] . ' | New Balance: Rs.' . $new_balance;
} elseif ($hh['txn_type'] == 'Debit' || $hh['txn_type'] == 'debit') {
$new_balance = $hh['wallet_amount'] - $hh['amount'];
echo 'Old Balance: Rs.' . $hh['wallet_amount'] . ' | New Balance: Rs.' . $new_balance;
}
?>
</td>
<td><?= $hh['action']; ?></td>
<td><?= $hh['remark']; ?></td>
<td><?= date('d-m-Y H:i:s', strtotime($hh['time'])); ?></td>
</tr>
<?php
$x++;
}
?>
</tbody>
</table>
</div>
</div>
<!-- bookings -->
<div class="tab-pane p-3" id="bookings" role="tabpanel">
<div class="table-responsive">
<table id="example-2" class="table table-striped table-bordered text-nowrap w-100">
<thead>
<tr>
<th class="wd-15p">S.No</th>
<th class="wd-15p">Booking ID</th>
<th class="wd-15p">Status</th>
<th class="wd-15p">From </th>
<th class="wd-15p">To</th>
<th class="wd-15p">Booking Stop</th>
<th class="wd-15p">Package</th>
<th class="wd-15p">Company Booking ID</th>
<th class="wd-15p">Company Booking Type</th>
<th class="wd-20p">Name</th>
<th class="wd-20p">Contact</th>
<th class="wd-20p">Email</th>
<th class="wd-20p">Trip type</th>
<th class="wd-20p">Cab Type</th>
<th class="wd-15p">Pickup Date</th>
<th class="wd-20p">pickup time</th>
<th class="wd-20p">Drop Date</th>
<th class="wd-15p">Amount</th>
<th class="wd-15p">Advance Amount</th>
<th class="wd-15p">Balance Amount</th>
<th class="wd-15p">Incentive</th>
<th class="wd-15p">Admin Commission</th>
<th class="wd-15p">Loss</th>
<th class="wd-15p">Profit</th>
<th class="wd-15p">Vendor Commission</th>
<th class="wd-15p">Pickup Address</th>
<th class="wd-15p">Drop Address</th>
<th class="wd-15p">Toll Tax</th>
<th class="wd-15p">State Tax</th>
<th class="wd-15p">Parking</th>
<th class="wd-15p">Night Charge</th>
<th class="wd-15p">Extra Price</th>
<th class="wd-15p">Carrier</th>
<th class="wd-15p">Pet</th>
<th class="wd-15p">Driver App</th>
<th class="wd-15p">Extra Requirement</th>
<th class="wd-15p">Billing Name</th>
<th class="wd-15p">GST No.</th>
<th class="wd-15p">Amenities</th>
<th class="wd-15p">Remark</th>
<th class="wd-15p">Booking Type</th>
<th class="wd-15p">Post Vendor ID</th>
<th class="wd-15p">Post Vendor Name</th>
<th class="wd-15p">Post Vendor Contact</th>
<th class="wd-15p">Accept Vendor id</th>
<th class="wd-15p">Accept Vendor Name</th>
<th class="wd-15p">Accept Vendor Contact</th>
<th class="wd-15p">cab Id</th>
<th class="wd-15p">Driver id</th>
<th class="wd-15p">Posted Date/Time</th>
<th class="wd-15p">Accepted Date/Time</th>
<th class="wd-15p">Completed Date/Time</th>
<th class="wd-15p">Cancelled Date/Time</th>
<th>Comment</th>
</tr>
</tr>
</thead>
<tbody>
<?php
$x = 1;
foreach ($table_data as $hh) {
if ($hh['booking_type'] == 'Website') {
$color = 'bg_success';
$text_color = 'text-white';
} elseif ($hh['company_type'] != '') {
$color = 'bg-warning text-white';
$text_color = 'text-white';
} elseif ($hh['booking_type'] == 'Vendor App') {
$color = 'bg-danger text-white';
$text_color = 'text-white';
} else {
$color = 'none';
$text_color = '';
}
$loss = 0;
$profit = 0;
if ($hh['incentive'] > $hh['admin_commission']) {
$loss = $hh['incentive'] - $hh['admin_commission'];
} else {
$profit = $hh['admin_commission'] - $hh['incentive'];
}
$admin_data = $conn->query("SELECT * FROM user_role_activity WHERE booking_id='" . $hh['bk_id'] . "'");
?>
<tr class="<?php echo $color; ?>" id="row<?= $hh['bk_id']; ?>">
<td><?= $x; ?></td>
<td class="list_booking">C4U<?= $hh['bk_id']; ?></td>
<?php
if ($hh['status'] == 'vendor_pass') {
echo '<td class="status"><label class="badge badge-primary">Not Assigned</label></td>';
} elseif ($hh['status'] == 'booked') {
echo '<td class="status"><label class="badge badge-warning">Pending</label></td>';
} elseif ($hh['status'] == 'confirmed') {
echo '<td class="status"><label class="badge badge-info">Processing</label></td>';
} elseif ($hh['status'] == 'completed') {
echo '<td class="status"><label class="badge badge-success">Completed</label></td>';
} else {
echo '<td class="status"><label class="badge badge-danger">Cancel</label></td>';
}
?>
<td class="from"><?= $hh['booking_from'] ?></td>
<td class="to"><?= $hh['booking_to']; ?></td>
<td class="booking_stop"><?php
$i = 1;
if (!empty($hh['booking_stops'])) {
$booking_stop = explode('/', $hh['booking_stops']);
foreach ($booking_stop as $booking_s) {
echo $i++ . '. ' . $booking_s . '<br>';
}
}
?>
</td>
<td class="pid"><?= $hh['pid']; ?></td>
<td class="company_booking_id"><?= $hh['company_booking_id']; ?></td>
<td class="company_booking_type"><?= $hh['company_booking_type']; ?></td>
<?php if ($hh['company_type'] != '') { ?>
<td class="name"><?= $hh['cust_name']; ?></td>
<td class="contact"><?= $hh['cust_mob']; ?></td>
<td class="email"><?= $hh['cust_email']; ?></td>
<?php } else { ?>
<td class="name"><?= $hh['name']; ?></td>
<td class="contact"><?= $hh['contact']; ?></td>
<td class="email"><?= $hh['email']; ?></td>
<?php } ?>
<td class="trip_type"><?= $hh['trip_type']; ?></td>
<td class="cab_type"><?= $hh['cab_type']; ?></td>
<td class="pickup_date"><?= date('d-m-Y', strtotime($hh['pickup_date'])); ?>
</td>
<td class="pickup_time"><?= date("h:i A", strtotime($hh['pickup_time'])); ?>
</td>
<td class="drop_date">
<?php
if ($hh['drop_date'] == 0) {
echo "<b>N.A.</b>";
} else {
echo date('d-m-Y', strtotime($hh['drop_date']));
}
?>
</td>
<td class="amount"><?= $hh['price'] + $hh['incentive']; ?></td>
<td class="advance_amount"><?= $hh['txn_amount']; ?></td>
<td class="balance_amount">
<?= ($hh['price'] + $hh['incentive']) - $hh['txn_amount']; ?>
</td>
<td class="incentive"><?= $hh['incentive']; ?></td>
<td class="commission" id="com<?= $hh['booking_id']; ?>">
<?= $hh['admin_commission']; ?>
</td>
<td class="loss"><?= $loss; ?></td>
<td class="profit"><?= $profit; ?></td>
<td><?= $hh['vendor_commission']; ?></td>
<td class="pickup_address"><?= $hh['pickup_address']; ?></td>
<td class="drop_address"><?= $hh['drop_add']; ?></td>
<td class="toll_tax">
<?php if ($hh['toll_tax'] == 1)
echo "Excluding";
else
echo "Including" ?>
</td>
<td class="state_tax">
<?php if ($hh['state_tax'] == 1)
echo "Excluding";
else
echo "Including" ?>
</td>
<td class="parking">
<?php if ($hh['parking'] == 1)
echo "Excluding";
else
echo "Including" ?>
</td>
<td class="night_charge"><?= $hh['night_charge']; ?></td>
<td class="extra_price"><?= $hh['extra_price']; ?></td>
<td class="carrier">
<?php if ($hh['carrier'] == 1) {
echo 'Yes';
} else {
echo "No";
} ?>
</td>
<td class="pet"><?= $hh['pet'] ?></td>
<td class="driver_app"><?php echo $hh['driver_app']; ?></td>
<td class="extra_requirement"><?= $hh['extra_requirement']; ?></td>
<td class="billing_name"><?= $hh['billing_name']; ?></td>
<td class="gst_no"><?= $hh['gst_no']; ?></td>
<td class="amenities">
<ul class="list-style-desc">
<?php
$amenities_id = $hh['amenities'];
$amenities = $conn->query("SELECT * FROM amenities WHERE id IN($amenities_id)");
while ($amenity = mysqli_fetch_array($amenities)) {
echo "<li>" . $amenity['note'] . $amenity['price'] . "</li>";
}
?>
</ul>
</td>
<td class="remark"><?= $hh['remark']; ?></td>
<td class="booking_type"><?= $hh['booking_type']; ?></td>
<?php
$vendor_id = $hh['vendor_id'];
$sql = "select * from vendor_login,vendor_profile where vendor_profile.vendor_id=$vendor_id and vendor_login.id=$vendor_id";
$res = $conn->query($sql);
$vendr = $res->fetch_assoc();
if ($hh['post_by_id'] != 0 && $hh['post_by_id'] != '') {
$post_by_id = $hh['post_by_id'];
$sql = "SELECT * FROM vendor_profile INNER JOIN vendor_login ON vendor_profile.vendor_id=vendor_login.id WHERE vendor_id='" . $post_by_id . "'";
$result = $conn->query($sql);
$vv = $result->fetch_assoc();
?>
<td class="post_vendor_id"><a class="text-white"
href="edit_vendor?token=<?= $hh['post_by_id']; ?>"
target="_blank"><?= $hh['post_by_id']; ?></a></td>
<td class="post_vendor_name"><?= $vv['full_name'] ?></td>
<td class="post_vendor_contact"><?= $vv['contact'] ?></td>
<?php } else { ?>
<td></td>
<td></td>
<td></td>
<?php } ?>
<?php
$vendor_id = $hh['vendor_id'];
$sql = "select * from vendor_login,vendor_profile where vendor_profile.vendor_id=$vendor_id and vendor_login.id=$vendor_id";
$res = $conn->query($sql);
$vendr = $res->fetch_assoc();
if ($hh['company_type'] == '') { ?>
<td class="accept_vendor_id"><a class="<?= $text_color; ?>"
href="edit_vendor?token=<?= $hh['vendor_id']; ?>"
target="_blank"><?= $hh['vendor_id']; ?></a></td>
<td class="accept_vendor_name"><input type="hidden"
id="vendorname<?php echo $hh['bk_id'] ?>"
value="<?php echo $hh['vendor_id'] ?>">
<?php echo $vendr['full_name'] ?>
</td>
<td class="accept_vendor_contact">
<?php echo $vendr['contact'] ?>
</td>
<?php } else { ?>
<td class="accept_vendor_id"><?= $hh['company_type']; ?> -
<?= $hh['vendor_id']; ?>
</td>
<td class="accept_vendor_name"><input type="hidden"
id="vendorname<?php echo $hh['bk_id'] ?>"
value="<?php echo $hh['vendor_id'] ?>"><?= $hh['vendor_name'] ?></td>
<td class="accept_vendor_contact"><?= $hh['vendor_phone'] ?></td>
<?php } ?>
<?php
if ($hh['cab_id'] != 0 && $hh['driver_id'] != 0 && $hh['company_type'] == '') {
$cab = $hh['cab_id'];
$k = $hh['driver_id'];
$sql = "select driver_name,contact,cab_name as cc,rc_no from drivers,cabs where cabs.id= $cab and drivers.id=$k;";
$result = $conn->query($sql);
$ss = $result->fetch_assoc();
?>
<td class="cab_detail"><?= $ss['cc'] . ", " . $ss['rc_no']; ?></td>
<td class="driver_detail"><?= $ss['driver_name'] . "," . $ss['contact']; ?></td>
<?php } elseif ($hh['company_type'] != '') { ?>
<td><?= $hh['cabno'] ?></td>
<td><?= $hh['drivername'] ?></td>
<?php } else { ?>
<td class="cab_detail">Cab Not Found.</td>
<td class="driver_detail">Driver Not Found.</td>
<?php
}
?>
<td class="time_stamp"><?= date("d-m-Y h:i A", strtotime($hh['time_stamp'])); ?>
</td>
<td class="accept_time">
<?= date("d-m-Y h:i A", strtotime($hh['accept_time'])); ?>
</td>
<td class="completed_time">
<?= date("d-m-Y h:i A", strtotime($hh['completed_time'])); ?>
</td>
<td class="cancelled_time">
<?= date("d-m-Y h:i A", strtotime($hh['cancelled_time'])); ?>
</td>
<td class="comment comment<?= $hh['bk_id'] ?>"><?= $hh['comment'] ?></td>
</tr>
<?php
$x++;
}
?>
</tbody>
</tbody>
</table>
</div>
</div>
<!-- widthdraw request -->
<div class="tab-pane p-3" id="complaints" role="tabpanel">
<div class="table-responsive">
<table class="table table-striped table-bordered text-nowrap w-100" id="example-3">
<thead>
<tr>
<th>S.No</th>
<th>Complaint Type</th>
<th>Vendor Name</th>
<th>Vendor Contact</th>
<th>Message</th>
<th>Created By</th>
<th>Date/Time</th>
<th>Status</th>
</tr>
</thead>
<tbody id="tbody-complaints">
</tbody>
</table>
</div>
</div>
<!-- documents -->
<div class="tab-pane p-3" id="documents" role="tabpanel">
<div class="row">
<div class="col-lg-3">
<a href="../cabzvendor_api/<?= $data2['qr_code'] ?>" data-fancybox="gallery">
<img src="../cabzvendor_api/<?= $data2['qr_code'] ?>">
</a>
<h5>QR CODE</h5>
</div>
</div>
</div>
<!-- Membership -->
<div class="tab-pane p-3" id="membership" role="tabpanel">
<div class="table-responsive">
<table id="example-4" class="table table-striped table-bordered text-nowrap w-100">
<thead>
<tr>
<th style="width: 80px">S.NO.</th>
<th>Membership Name</th>
<th>Membership Price</th>
<th>Membership Duration</th>
<th>Membership Status</th>
<th>Start Date</th>
<th>End Date</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$sql = "SELECT * FROM membership_log INNER JOIN vendor_profile ON membership_log.vendor_id=vendor_profile.vendor_id INNER JOIN vendor_login ON membership_log.vendor_id=vendor_login.id INNER JOIN membership ON membership_log.membership_id=membership.id WHERE membership_log.vendor_id='$vendor_id'";
$query = mysqli_query($conn, $sql);
while ($res = mysqli_fetch_array($query)) {
$start = explode(' ', $res['start']);
$end = explode(' ', $res['end']);
?>
<tr>
<td><?php echo $i++; ?></td>
<td><?php echo $res['name']; ?></td>
<td><?php echo $res['price']; ?></td>
<td><?php echo $res['duration']; ?></td>
<td><?php if ($end < date('Y-m-d')) {
echo '<label class="badge badge-danger">In-active</label>';
} else {
echo '<label class="badge badge-success">Active</label>';
} ?></td>
<td><?php echo $start[0]; ?></td>
<td><?php echo $end[0]; ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
require_once 'footer.php';
require_once 'jslinks.php';
?>
<!-- Adon JS -->
<script src="assets/js/custom.js"></script>
<script src="assets/js/datatable.js"></script>
<script>
$(function (e) {
new DataTable('#example-2', {
layout: {
topStart: {
buttons: ['copyHtml5', 'excelHtml5', 'csvHtml5', 'pdfHtml5']
}
},
"stateSave": true,
});
new DataTable('#example-4', {
layout: {
topStart: {
buttons: ['copyHtml5', 'excelHtml5', 'csvHtml5', 'pdfHtml5']
}
},
"stateSave": true,
dom: 'lBfrtip',
"lengthMenu": [[10, 25, 50, 100, 250, 500, 1000, -1], [10, 25, 50, 100, 250, 500, 1000, 'All']]
});
});
$(document).ready(function () {
output();
function output() {
var inHTML = '';
var i = 1;
$.getJSON("ajax_complaints?show=1&vendor_id<?= $vendor_id ?>", function (data) {
$.each(data, function (key, item) {
if (item.status == 'Pending') {
var status = '<span class="badge badge-warning">Pending</span>';
} else if (item.status == 'Processing') {
var status = '<span class="badge badge-primary">Processing</span>';
} else {
var status = '<span class="badge badge-success">Completed</span>';
}
inHTML +=
`<tr>
<td>${i}</td>
<td>${item.title}</td>
<td>${item.full_name}</td>
<td>${item.contact}</td>
<td>${item.msg} </td>
<td>${item.created_by}</td>
<td>${item.created_at}</td>
<td>${status}</td>
</tr>`;
i++;
})
$('#tbody-complaints').html(inHTML);
$('#example-3').DataTable({
layout: {
topStart: {
buttons: ['copy', 'csv', 'excel', 'pdf', 'print']
}
},
"stateSave": true,
dom: 'lBfrtip',
"lengthMenu": [[10, 25, 50, 100, 250, 500, 1000, -1], [10, 25, 50, 100, 250, 500, 1000, 'All']]
});
})
}
});
</script>