หน้าเว็บโหลดข้อมูลช้า เนื่องจากข้อมูลเยอะ ผมมาแก้ไขต่อจากคนเขียนคนเดิม
ขอผู้ใจดีช่วยดูหน่อยครับว่าจะปรับยังไงได้บ้าง (ขอโค๊ดแก้ไขจะดีมากๆเลยครับ ไม่ได้จับโค๊ดมานานมาแล้ว)
<?PHP
include('include/inc.config.php');
include('include/inc.check_login.php');
include('include/inc.title.php');
include('include/inc.function.php');
?>
<!DOCTYPE html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<title><?PHP echo "$general_name"; ?> <?PHP echo "$general_description"; ?></title>
<link rel="shortcut icon" href="images/<?PHP echo "$general_favicon"; ?>" type="image/x-icon" >
<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/font-awesome.min.css">
<link rel="stylesheet" href="css/ionicons.min.css">
<link rel="stylesheet" href="css/AdminLTE.min.css">
<link rel="stylesheet" href="css/_all-skins.min.css">
<link rel="stylesheet" href="css/styles.css">
<link rel="stylesheet" href="plugins/fullcalendar/fullcalendar.min.css">
<link rel="stylesheet" href="plugins/fullcalendar/fullcalendar.print.css" media="print">
<script type="text/javascript" src="plugins/ckeditor_bootstrap/ckeditor.js"></script>
<link rel="stylesheet" href="plugins/colorpicker/bootstrap-colorpicker.min.css">
<link rel="stylesheet" href="plugins/timepicker/bootstrap-timepicker.min.css">
<link rel="stylesheet" href="plugins/daterangepicker/daterangepicker.css">
<link rel="stylesheet" href="plugins/datepicker/datepicker3.css">
<link rel="stylesheet" href="plugins/timepicker/bootstrap-timepicker.min.css">
<link rel="stylesheet" href="plugins/datatables.net-bs/css/dataTables.bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="plugins/datetimepicker/jquery.datetimepicker.css">
<script type="text/javascript" src="plugins/datetimepicker/jquery.js"></script>
<script type="text/javascript" src="plugins/datetimepicker/jquery.datetimepicker.js"></script>
<link href="https://fonts.googleapis.com/css?family=Kanit|Prompt" rel="stylesheet">
</head>
<body class="hold-transition <?PHP echo $general_themes; ?> layout-boxed sidebar-mini">
<div class="wrapper">
<?PHP include("include/template_head.php"); ?>
<?PHP include("include/template_menu.php"); ?>
<div class="content-wrapper">
<section class="content-header">
<h1 class="kanit">
<i class="fa fa-list-alt"></i> ระบบรับงาน - ออกใบมัดจำ
<small></small>
</h1>
<ol class="breadcrumb">
<li><a href="<?PHP echo $general_homepage; ?>"><i class="fa fa-home"></i> หน้าแรก</a></li>
<li class="active">ระบบรับงาน - ออกใบมัดจำ </li>
</ol>
</section>
<section class="content">
<div class="box box-primary">
<div class="box-header with-border">
<span class="box-title kanit"><div align="left">ค้นหารายชื่อลูกค้า</div></span>
</div>
<div class="box-body">
<div align="center" style="background-color:#4C5A65;"><img src="images/search.png"/></div>
<div style="margin-top:-30;">
<a href="job_customer_form.php" class="btn btn-block btn-primary kanit"><i class="fa fa-plus-square"></i> เพิ่มประวัติลูกค้าใหม่</a>
</div>
</div>
</div>
<div class="box box-primary">
<div class="box-header with-border">
<span class="box-title">
<table width="100%" border="0">
<tr class="verdana_15 kanit">
<td width="999" align="left">รายชื่อข้อมูลลูกค้าทั้งหมด</td>
<td width="1" align="right"></td>
</tr>
</table>
</span>
</div>
<div class="box-body">
<div class="table-responsive">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<td width="1%" rowspan="2" align="center" class="kanit">#</td>
<td width="70%" rowspan="2" align="center" class="kanit">ชื่อ-นามสกุล</td>
<td width="14%" rowspan="2" align="center" class="kanit">โทรศัพท์</td>
<td width="10%" rowspan="2" align="center" class="kanit">สถานะ</td>
<td colspan="3" align="center" class="kanit">จัดการ</td>
</tr>
<tr>
<td width="1%" align="center" class="kanit"><i class="fa fa-edit" style="color:#999;"></i></td>
<td width="1%" align="center" class="kanit"><span class="text-muted" style="font-size:14px; color:#999;">ซื้อสินค้า</span></td>
<td width="1%" align="center" class="kanit"><span class="text-muted" style="font-size:14px; color:#999;">เพิ่มใบมัดจำ</span></td>
</tr>
</thead>
<tbody>
<?PHP
$sql = "select customer_profile_id, customer_profile_namefull, customer_profile_phone_1, customer_profile_status from customer_profile order by customer_profile_id desc";
$result = mysqli_query($con,$sql);
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr onmouseover='this.style.backgroundColor="#e0e4e8"' onmouseout='this.style.backgroundColor=""'>
<td align="center"><?PHP echo $row['customer_profile_id']; ?></td>
<td>
<a href="job_customer_detail.php?profile_id=<?PHP echo $row['customer_profile_id']; ?>" data-toggle="tooltip" title="คลิกเพื่อดูข้อมูลลูกค้า">
<font class="verdana_12" color="#000000"><?PHP echo $row['customer_profile_namefull']; ?></font>
</a></td>
<td align="center"><?PHP echo $row['customer_profile_phone_1']; ?></td>
<td>
<?PHP
$sql_sutstatus = "select * from customer_status";
$result_sutstatus = mysqli_query($con,$sql_sutstatus);
while ($data_sutstatus = mysqli_fetch_assoc($result_sutstatus)) {
$customerprofilestatus = $row['customer_profile_status'];
if($customerprofilestatus == $data_sutstatus['customer_status_id']) $jobmembername = $data_sutstatus['customer_status_name'];
if($customerprofilestatus == $data_sutstatus['customer_status_id']) $jobmembercolor = $data_sutstatus['customer_status_color']; }
?>
<div class="<?PHP echo $jobmembercolor; ?>" style="font-size:11px;"><?PHP echo $jobmembername; ?></div>
</td>
<td>
<a href="job_customer_form_edit.php?profile_id=<?PHP echo $row['customer_profile_id']; ?>" class="btn btn-block btn-default" data-toggle="tooltip" title="แก้ไขประวัติ"><i class="fa fa-edit"></i></a>
</td>
<td>
<a href="job_quick_form.php?profile_id=<?PHP echo $row['customer_profile_id']; ?>" class="btn btn-block btn-primary kanit" data-toggle="tooltip" title="สั่งซื้อสินค้า กรณีซื้อสินค้าอย่างเดียว"><i class="fa fa-plus-square"></i> ซื้อสินค้า</a>
</td>
<td>
<?PHP if($row['customer_profile_status'] == '3') { ?>
<a onClick="fncBlacklist();" class="btn btn-default btn-block" data-toggle="tooltip" title="เพิ่มการรับงาน">
<i class="fa fa-plus-square"></i> เพิ่มการรับงาน
</a>
<script language="javascript">
function fncBlacklist() {
swal({
title: "ลูกค้าท่านนี้ติด Blacklist!",
text: "ไม่สามารถเพิ่มรายการสั่งซื้อได้เนื่องจากสถานะติด Blacklist!",
type: "warning",
} ); }
</script>
<?PHP } else { ?>
<a href="job_form.php?profile_id=<?PHP echo $row['customer_profile_id']; ?>" class="btn btn-block btn-danger kanit" data-toggle="tooltip" title="สั่งซื้อสินค้า"><i class="fa fa-plus-square"></i> เพิ่มการรับงาน</a>
<?PHP } ?>
</td>
</tr>
<?PHP } ?>
</tbody>
</table>
</div>
</div>
</div>
</section>
</div>
<?php include("include/template_footer.php"); ?>
<script src="plugins/jQuery/jquery-2.2.3.min.js"></script>
<!-- Bootstrap 3.3.6 -->
<script src="js/bootstrap.min.js"></script>
<!-- SlimScroll -->
<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>
<!-- FastClick -->
<script src="plugins/fastclick/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="js/app.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="js/demo.js"></script>
<!-- Select2 -->
<script src="plugins/select2/select2.full.min.js"></script>
<!-- iCheck 1.0.1 -->
<script src="plugins/iCheck/icheck.min.js"></script>
<!-- date-range-picker -->
<script src="plugins/daterangepicker/moment.min.js"></script>
<script src="plugins/daterangepicker/daterangepicker.js"></script>
<script src="plugins/input-mask/jquery.inputmask.js"></script>
<script src="plugins/datepicker/bootstrap-datepicker.js"></script>
<!-- DataTables -->
<script src="plugins/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="plugins/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
<script>
$(function () {
$('#example1').DataTable({
'paging' : true,
'lengthChange': true,
'searching' : true,
'ordering' : true,
'info' : true,
'autoWidth' : false
})
})
</script>
<script>
$(function () {
//Initialize Select2 Elements
$('.select2').select2()
//Datemask dd/mm/yyyy
$('#datemask').inputmask('dd/mm/yyyy', { 'placeholder': 'dd/mm/yyyy' })
//Datemask2 mm/dd/yyyy
$('#datemask2').inputmask('mm/dd/yyyy', { 'placeholder': 'mm/dd/yyyy' })
//Money Euro
$('[data-mask]').inputmask()
//Date range picker
$('#reservation').daterangepicker()
//Date range picker with time picker
$('#reservationtime').daterangepicker({ timePicker: true, timePickerIncrement: 30, format: 'MM/DD/YYYY h:mm A' })
//Date range as a button
$('#daterange-btn').daterangepicker(
{
ranges : {
'Today' : [moment(), moment()],
'Yesterday' : [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
'Last 7 Days' : [moment().subtract(6, 'days'), moment()],
'Last 30 Days': [moment().subtract(29, 'days'), moment()],
'This Month' : [moment().startOf('month'), moment().endOf('month')],
'Last Month' : [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
},
startDate: moment().subtract(29, 'days'),
endDate : moment()
},
function (start, end) {
$('#daterange-btn span').html(start.format('MMMM D, YYYY') ' - ' end.format('MMMM D, YYYY'))
}
)
//Date picker
$('#datepicker').datepicker({
autoclose: true
})
//iCheck for checkbox and radio inputs
$('input[type="checkbox"].minimal, input[type="radio"].minimal').iCheck({
checkboxClass: 'icheckbox_minimal-blue',
radioClass : 'iradio_minimal-blue'
})
//Red color scheme for iCheck
$('input[type="checkbox"].minimal-red, input[type="radio"].minimal-red').iCheck({
checkboxClass: 'icheckbox_minimal-red',
radioClass : 'iradio_minimal-red'
})
//Flat red color scheme for iCheck
$('input[type="checkbox"].flat-red, input[type="radio"].flat-red').iCheck({
checkboxClass: 'icheckbox_flat-green',
radioClass : 'iradio_flat-green'
})
//Colorpicker
$('.my-colorpicker1').colorpicker()
//color picker with addon
$('.my-colorpicker2').colorpicker()
//Timepicker
$('.timepicker').timepicker({
showInputs: false
})
})
</script>
</body>
</html>
<!-- Page specific script -->