<td>
<a class="ttip_t" title="รุ่นรถยนต์ยี่ห้อ <?php
echo $car_banner[$i]['carBannerNameThai'];
?>
" href="index.php?p=car.model&menu=main_car&bannerid=<?php
echo $car_banner[$i]['carBannerId'];
?>
">
<?php
echo $car_banner[$i]['carBannerNameThai'];
?>
</a>
</td>
<td style="text-align:center;">
<?php
$total_model = count_data_mysql('carModelId', 'carmodel', 'carBannerId =' . $car_banner[$i][carBannerId] . '');
?>
<a class="ttip_t" title="รุ่นรถยนต์ยี่ห้อ <?php
echo $car_banner[$i]['carBannerNameThai'];
?>
" href="index.php?p=car.model&menu=main_car&bannerid=<?php
echo $car_banner[$i]['carBannerId'];
?>
">
<?php
echo $total_model;
?>
</a>
</td>
<td><?php
${$key} = $value;
#echo $key ."=". $value."<br>";
}
//pre($_SESSION);
//pre(error_get_last());
$find_chk = 0;
switch ($act) {
case 'addminor':
include 'modules/mod_user/minor/formAdd.php';
break;
case 'editminor':
include 'modules/mod_user/minor/formEdit.php';
break;
case 'saveadd':
//Check Usernaem ซ้ำ
$find_chk = count_data_mysql('minorId', 'minoradmin', "username = '******' and garageId = '" . $u_garage . "'");
if ($find_chk) {
$message = "ข้อมูลพนักงาน Username : "******" มีแล้วในระบบ";
$act = 'addminor';
?>
<script type="text/javascript">
$(document).ready(function() {
alertPopup('msg2','alert2','<?php
echo $message;
?>
',0);
});
</script>
<?php
include 'modules/mod_user/minor/formAdd.php';
} else {
require_once '../../../include/Zend/JSON.php';
$json = new Services_JSON();
include "../../../include/class.mysqldb.php";
include "../../../include/config.inc.php";
include "../../../include/class.function.php";
foreach ($_REQUEST as $key => $value) {
${$key} = $value;
#echo $key ."=". $value."<br>";
}
$carRegistration = trim($carRegistration);
if ($act == 'add') {
$car_chk = select_db('car', "where carRegistration = '" . $carRegistration . "' and provinceId = '" . $provinceId . "'");
$find_used = count($car_chk);
}
if ($act == 'edit') {
if (trim($carRegistration) == trim($carRegistrationTmp) && trim($provinceId) == trim($provinceIdTmp)) {
$find_used = 0;
} else {
//Check ป้ายทะเบียนซ้ำ
$find_used = count_data_mysql('carId', 'car', "carRegistration = '" . trim($carRegistration) . "' and provinceId = '" . $provinceId . "'");
}
}
if ($find_used == 0) {
$data['success'] = true;
$data['message'] = 'แท๊กซี่ทะเบียน "' . $carRegistration . '" ใช้งานได้';
} else {
$data['success'] = false;
$data['message'] = 'ใช้แท๊กซี่ทะเบียน "' . $carRegistration . '" ไม่ได้เนื่องจากมีข้อมูลแท๊กซี่ถูกใช้งานในระบบ';
}
echo $_GET['callback'] . '(' . $json->encode($data) . ')';
<?php
//Select Minor Data
if (empty($garageId)) {
$thisgarageId = $u_garage;
} else {
$thisgarageId = $garageId;
}
if (empty($d)) {
$time_data = count_data_mysql('transportsectionId', 'transportsection', "garageId = '" . $thisgarageId . "' and (dateAdd like '" . date('Y-m-d') . "%' OR statusWork = 'online')");
//$time_data = select_db('transportsection',"where garageId = '".$u_garage."' and dateAdd like '".date('Y-m-d')."%' OR statusWork = 'online' order by statusWork");
$thisdate = date('d/m/Y');
} else {
$p_date = explode('/', $d);
$setdate = $p_date[2] . '-' . $p_date[1] . '-' . $p_date[0];
$time_data = count_data_mysql('transportsectionId', 'transportsection', "garageId = '" . $thisgarageId . "' and dateAdd like '" . $thisdate . "%'");
//$time_data = select_db('transportsection',"where garageId = '".$u_garage."' and dateAdd like '".$thisdate."%' OR statusWork = 'online' order by statusWork");
$dchk = $setdate;
$thisdate = $d;
}
$total = $time_data;
$major_data = select_db('majoradmin', "where garageId = '" . $thisgarageId . "'");
$major_name = $major_data[0]['thaiCompanyName'];
if (empty($current_page)) {
$current_page = 0;
}
?>
<script type="text/javascript" charset="utf-8">
var current_page = <?php
$(document).ready(function() {
alertPopup('msg3','alert3','<?php
echo $message;
?>
',0);
});
</script>
<?php
include 'modules/mod_mobile/managemobile/mobileShow.php';
}
break;
case 'saveadd':
//Check หมายเลขโทรศํพท์ซ้ำ
$find_chk1 = count_data_mysql('mobileId', 'mobile', "mobileNumber = '" . trim($mobileNumber) . "'");
//Check Emi/Msi ซ้ำ
$find_chk2 = count_data_mysql('mobileId', 'mobile', "EmiMsi = '" . trim($EmiMsi) . "'");
if ($find_chk1 > 0 || $find_chk2 > 0) {
$message = "ข้อมูลโทรศัพท์นี้มีแล้วในระบบ";
//$act = 'addmobile';
?>
<script type="text/javascript">
$(document).ready(function() {
alertPopup('msg2','alert2','<?php
echo $message;
?>
',0);
});
</script>
<?php
include 'modules/mod_mobile/managemobile/formAdd.php';
} else {
<!--/*
table car จะมี carStatusId ดังนี้
1 = ว่าง
2 = ไม่ว่าง
3 = จอด
4 = มีการเลือกรถ จากลูกค้า
5 = มีการเลือกรถ จาก Call center
*/ -->
<?php
$garageId = $u_garage;
$cus_calltaxi_data = count_data_mysql('historyId', 'driverhistory', "statusWork != '99' AND statusWork != '88' AND statusWork != '5' AND statusWork != '6' AND statusWork != '7' order by callTime DESC");
$total = $cus_calltaxi_data;
?>
<script type="text/javascript">
$(document).ready(function(){
$(document).on("keydown.NewActionOnF5", function(e){
var charCode = e.which || e.keyCode;
switch(charCode){
case 116: // F5
e.preventDefault();
window.location = "index.php?p=<?php
echo $p;
?>
&menu=<?php
<!-- datatable -->
<link rel="stylesheet" type="text/css" href="lib/datatables/css/demo_table_jui.css"/>
<script src="lib/datatables/jquery.dataTables.min.js"></script>
<?php
//Case Supervisor
if ($u_garage == 1) {
if ($garageId == '') {
$car_data = count_data_mysql('carId', 'car', '1');
} else {
$car_data = count_data_mysql('carId', 'car', "garageId = '" . $garageId . "'");
}
} else {
//Case Garage
$car_data = count_data_mysql('carId', 'car', "garageId = '" . $u_garage . "'");
$garageId = $u_garage;
}
$total = $car_data;
///=====Data Major
if ($garageId == '') {
$major_name = 'ทั้งหมด';
} else {
$major_data = select_db('majoradmin', "where garageId = '" . $garageId . "'");
$major_name = $major_data[0]['thaiCompanyName'];
$garageId = $major_data[0]['garageId'];
}
if (empty($current_page)) {
$current_page = 0;
}
?>
<?php
foreach ($_REQUEST as $key => $value) {
${$key} = $value;
//echo $key ."=". $value."<br>";
}
//pre($_REQUEST);
//pre(error_get_last());
$find_chk = 0;
switch ($act) {
case 'addschedule':
include 'modules/mod_driver/schedule/formAdd.php';
break;
case 'saveadd':
//Check ซ้ำ
//ลอง Check อีกที
$find_chk = count_data_mysql('transportSectionId', 'transportsection', "driverId = '" . trim($driverId) . "' and garageId = '" . $u_garage . "'");
if ($find_chk) {
$message = "ข้อมูลพนักงาน Username : "******" มีแล้วในระบบ";
$act = 'addschedule';
?>
<script type="text/javascript">
$(document).ready(function() {
alertPopup('msg2','alert2','<?php
echo $message;
?>
',0);
});
</script>
<?php
include 'modules/mod_driver/schedule/formAdd.php';
} else {
$find_number_used = count($mobile_chk);
$mobile_chk = select_db('mobile', "where EmiMsi = '" . $EmiMsi . "'");
$find_emi_used = count($mobile_chk);
}
if ($act == 'edit') {
if (trim($mobileNumber) == trim($mobileNumberTmp)) {
$find_number_used = 0;
} else {
//Check ป้ายทะเบียนซ้ำ
$find_number_used = count_data_mysql('mobileId', 'mobile', "mobileNumber = '" . trim($mobileNumber) . "'");
}
if (trim($EmiMsi) == trim($EmiMsiTmp)) {
$find_emi_used = 0;
} else {
//Check ป้ายทะเบียนซ้ำ
$find_emi_used = count_data_mysql('mobileId', 'mobile', "EmiMsi = '" . trim($EmiMsi) . "'");
}
}
if ($find_number_used == 0) {
$data['number'] = true;
$data['message1'] = 'หมายเลขโทรศัพท์ "' . $mobileNumber . '" ใช้งานได้';
} else {
$data['number'] = false;
$data['message1'] = 'เพิ่มหมายเลขโทรศัพท์ "' . $mobileNumber . '" ไม่ได้เนื่องจากมีข้อมูลถูกใช้งานในระบบ';
}
if ($find_emi_used == 0) {
$data['emi'] = true;
$data['message2'] = 'Emi/Msi "' . $EmiMsi . '" ใช้งานได้';
} else {
$data['emi'] = false;
$data['message2'] = 'Emi/Msi "' . $EmiMsi . '" ไม่ได้เนื่องจากมีข้อมูลถูกใช้งานในระบบ';
<td>
<a class="ttip_t" title="รุ่นมือถือยี่ห้อ <?php
echo $mobile_banner[$i]['mobileBannerNameThai'];
?>
" href="index.php?p=mobile.model&menu=main_mobile&bannerid=<?php
echo $mobile_banner[$i]['mobileBannerId'];
?>
">
<?php
echo $mobile_banner[$i]['mobileBannerNameThai'];
?>
</a>
</td>
<td style="text-align:center;">
<?php
$total_model = count_data_mysql('mobileModelId', 'mobilemodel', 'mobileBannerId =' . $mobile_banner[$i][mobileBannerId] . '');
?>
<a class="ttip_t" title="รุ่นมือถือยี่ห้อ <?php
echo $mobile_banner[$i]['mobileBannerNameThai'];
?>
" href="index.php?p=mobile.model&menu=main_mobile&bannerid=<?php
echo $mobile_banner[$i]['mobileBannerId'];
?>
">
<?php
echo $total_model;
?>
</a>
</td>
<td><?php
<!-- datatable -->
<link rel="stylesheet" type="text/css" href="lib/datatables/css/demo_table_jui.css"/>
<script src="lib/datatables/jquery.dataTables.min.js"></script>
<?php
//Case Supervisor
if ($u_garage == 1) {
if ($garageId == '') {
$mobile_data = count_data_mysql('mobileId', 'mobile', '1');
} else {
$mobile_data = count_data_mysql('mobileId', 'mobile', "garageId = '" . $garageId . "'");
}
} else {
//Case Garage
$mobile_data = count_data_mysql('mobileId', 'mobile', "garageId = '" . $u_garage . "'");
$garageId = $u_garage;
}
$total = $mobile_data;
///=====Data Major
if ($garageId == '') {
$major_name = 'ทั้งหมด';
} else {
$major_data = select_db('majoradmin', "where garageId = '" . $garageId . "'");
$major_name = $major_data[0]['thaiCompanyName'];
$garageId = $major_data[0]['garageId'];
}
if (empty($current_page)) {
$current_page = 0;
}
?>
<script type="text/javascript" charset="utf-8">
<?php
foreach ($_REQUEST as $key => $value) {
${$key} = $value;
#echo $key ."=". $value."<br>";
}
//Case Supervisor
if ($u_garage == 1) {
if ($garageId == '') {
$taxiwork_data = count_data_mysql('transportSectionId', 'transportsection', '1');
} else {
$taxiwork_data = count_data_mysql('transportSectionId', 'transportsection', "garageId = '" . $garageId . "'");
}
} else {
//Case Garage
$taxiwork_data = count_data_mysql('transportSectionId', 'transportsection', "garageId = '" . $u_garage . "'");
$garageId = $u_garage;
}
$total = $taxiwork_data;
///=====Data Major
if ($garageId == '') {
$major_name = 'ทั้งหมด';
} else {
$major_data = select_db('majoradmin', "where garageId = '" . $garageId . "'");
$major_name = $major_data[0]['thaiCompanyName'];
$garageId = $major_data[0]['garageId'];
}
//=============================================== Begin Map =================================================
$var_car_number = 200;
$con1 = $_REQUEST['con1'];
$con1_encode = urlencode($con1);
