<?php
$i = 0;
while ($i < $total) {
?>
<tr>
<td style="text-align:center;"><?php
echo $i + 1;
?>
</td>
<td><?php
echo $car_model[$i]['carModelName'];
?>
</td>
<td><?php
echo Thai_date($car_model[$i]['dateAdd']);
?>
</td>
<td>
<!--<a data-toggle="modal" data-backdrop="static" href="#myModalAdd"> -->
<!--<a href="index.php?p=car.type&menu=main_car&act=edit&id=<?php
echo $car_model[$i]['carModelId'];
?>
" class="sepV_a" title="Edit"><i class="icon-pencil"></i></a> -->
<a href="#" data-toggle="modal" data-backdrop="static" title="Edit" onclick="fn_formEdit(<?php
echo $car_model[$i]['carModelId'];
?>
, 'select');"><i class="icon-pencil"></i></a>
<a href="#myModalDel<?php
echo $car_model[$i]['carModelId'];
*/
$output = array("sEcho" => intval($_GET['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array());
$n = 0;
while ($aRow = mysql_fetch_array($rResult)) {
$row = array();
$n++;
for ($i = 0; $i < count($aColumns); $i++) {
//echo $aColumns[$i]."/n";
//print_r($aColumns[$i]);
$row[0] = $n + $_REQUEST['iDisplayStart'];
if ($aColumns[$i] == "customer.firstName") {
$setrow1 = "<i class=\"splashy-contact_grey\" style=\"margin-right:5px;\"></i>";
$setrow1 .= $aRow['firstName'] . " " . $aRow['lastName'];
$row[1] = $setrow1;
}
if ($aColumns[$i] == "customermap.latitudeCustomer") {
$row[2] = $aRow['latitudeCustomer'] . ", " . $aRow['longitudeCustomer'];
}
if ($aColumns[$i] == "timeServer") {
$row[3] = Thai_date($aRow['timeServer']);
}
if ($aColumns[$i] == "customerMapId") {
$datenow = $aRow['timeServer'];
$pTime = explode(' ', $datenow);
$thisTime = $pTime[1];
$row[4] = $thisTime;
}
}
$output['aaData'][] = $row;
}
echo json_encode($output);
?>
);">
<?php
echo $mobileNumber;
?>
</a>
</td>
<td><?php
echo $lat;
?>
, <?php
echo $lon;
?>
</td>
<td><?php
echo Thai_date($time_data[$i]['dateAdd']);
?>
</td>
<td style="text-align:center;"><?php
echo $p_time1[0];
?>
:<?php
echo $p_time1[1];
?>
น. - <?php
echo $p_time2[0];
?>
:<?php
echo $p_time2[1];
?>
น. </td>
if ($car_data[$i]['carStatusId'] == 2) {
?>
<i class="splashy-marker_rounded_red"></i>
<?php
}
?>
<?php
if ($car_data[$i]['carStatusId'] == 3) {
?>
<i class="splashy-marker_rounded_light_blue"></i>
<?php
}
?>
</td>
<td><?php
echo Thai_date($car_data[$i]['dateAdd']);
?>
</td>
<td>
<!--<a data-toggle="modal" data-backdrop="static" href="#myModalAdd"> -->
<!--<a href="index.php?p=car.type&menu=main_car&act=edit&id=<?php
echo $car_data[$i]['carId'];
?>
" class="sepV_a" title="Edit"><i class="icon-pencil"></i></a> -->
<div style="float:left; margin-right:5px;">
<form action="" method="post" name="fmEdit<?php
echo $i;
?>
" id="fmEdit<?php
echo $i;
?>
}
if ($aColumns[$i] == 'credits') {
$row[4] = $aRow['credits'];
}
if ($aColumns[$i] == 'drivertaxi.mobilePhone') {
$row[5] = $aRow['mobilePhone'];
}
if ($aColumns[$i] == 'thaiCompanyName') {
if ($aRow['thaiCompanyName'] == "") {
$row[6] = "ไม่มีสังกัด";
} else {
$row[6] = $aRow['thaiCompanyName'] . "<br />" . $aRow['englishCompanyName'];
}
}
if ($aColumns[$i] == "drivertaxi.dateAdd") {
$row[7] = Thai_date($aRow['dateAdd']);
}
if ($aColumns[$i] == 'driverId') {
$set_tools = "<a style=\"cursor:pointer;\" class=\"ttip_t\" title=\"แก้ไข\" onClick=\"fn_Edit(" . $aRow[$aColumns[$i]] . "," . $aRow['garageId'] . ")\" ><i class=\"icon-pencil\"></i></a>";
if ($aRow['garageId'] != 0) {
$set_tools = $set_tools . "<a style=\"cursor:pointer;margin-left:5px;\" class=\"ttip_t\" title=\"ลบออกจากสังกัด\" onClick=\"fn_callDel(" . $aRow['driverId'] . ",'" . $aRow['firstName'] . ' ' . $aRow['lastName'] . "')\" ><i class=\"icon-trash\"></i></a>";
}
$set_tools .= " <a style=\"cursor:pointer;\" class=\"ttip_t\" title=\"เพิ่มเครดิต\" onClick=\"fn_addCredit(" . $aRow['driverId'] . ",'" . $aRow['firstName'] . ' ' . $aRow['lastName'] . "')\" ><i class=\"splashy-heart_add\"></i></a>";
if ($aRow['garageId'] == $u_garage || $u_garage == 1 || $aRow['garageId'] == 0) {
$row[8] = $set_tools;
} else {
$row[8] = "";
}
$set_tools2 = "<div id=\"div_lock" . $aRow[$aColumns[$i]] . " style=\"float:left; margin-left:5px;\">";
if ($aRow['lock'] == 0) {
$set_tools2 = $set_tools2 . "<a href=\"#\" class=\"ttip_t\" title=\"สถานะล๊อค\" onclick=\"fn_changeLock('" . $aRow[$aColumns[$i]] . "',1);\"><i class=\"splashy-thumb_down\"></i></a>";
<?php
$i = 0;
while ($i < $total) {
?>
<tr>
<td style="text-align:center;"><?php
echo $i + 1;
?>
</td>
<td><?php
echo $car_fuel[$i]['carFuelName'];
?>
</td>
<td><?php
echo Thai_date($car_fuel[$i]['dateAdd']);
?>
</td>
<td>
<!--<a data-toggle="modal" data-backdrop="static" href="#myModalAdd"> -->
<!--<a href="index.php?p=car.type&menu=main_car&act=edit&id=<?php
echo $car_fuel[$i]['carFuelId'];
?>
" class="sepV_a" title="Edit"><i class="icon-pencil"></i></a> -->
<a href="#" data-toggle="modal" data-backdrop="static" title="Edit" onclick="fn_formEdit(<?php
echo $car_fuel[$i]['carFuelId'];
?>
, 'select');"><i class="icon-pencil"></i></a>
<a href="#myModalDel<?php
echo $car_fuel[$i]['carFuelId'];
?>
<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
echo Thai_date($car_banner[$i]['dateAdd']);
?>
</td>
<td>
<!--<a data-toggle="modal" data-backdrop="static" href="#myModalAdd"> -->
<!--<a href="index.php?p=car.type&menu=main_car&act=edit&id=<?php
echo $car_banner[$i]['carBannerId'];
?>
" class="sepV_a" title="Edit"><i class="icon-pencil"></i></a> -->
<a href="#" data-toggle="modal" data-backdrop="static" title="Edit" onclick="fn_formEdit(<?php
echo $car_banner[$i]['carBannerId'];
?>
, 'select');"><i class="icon-pencil"></i></a>
<a href="#myModalDel<?php
echo $car_banner[$i]['carBannerId'];
?>
<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
echo Thai_date($mobile_banner[$i]['dateAdd']);
?>
</td>
<td>
<?php
if ($u_garage == $mobile_banner[$i]['garageId'] || $u_type == 1) {
?>
<!--<a data-toggle="modal" data-backdrop="static" href="#myModalAdd"> -->
<!--<a href="index.php?p=mobile.type&menu=main_mobile&act=edit&id=<?php
echo $mobile_banner[$i]['mobileBannerId'];
?>
" class="sepV_a" title="Edit"><i class="icon-pencil"></i></a> -->
<a href="#" data-toggle="modal" data-backdrop="static" title="Edit" onclick="fn_formEdit(<?php
echo $mobile_banner[$i]['mobileBannerId'];
?>
, 'select');"><i class="icon-pencil"></i></a>
<td style="text-align:center;"><?php
echo $i + 1;
?>
</td>
<td>
<a href="#myModalDetail<?php
echo $news_data[$i]['newsId'];
?>
" data-toggle="modal" class="ttip_t" title="รายละเอียดข่าว">
<?php
echo $news_data[$i]['newsTopic'];
?>
</a>
</td>
<td><?php
echo Thai_date($news_data[$i]['dateAdd']);
?>
</td>
<td>
<div id="divShow<?php
echo $news_data[$i]['newsId'];
?>
" style="float:left; margin-right:5px; cursor:pointer;">
<?php
if ($news_data[$i]['statusShow'] == 1) {
?>
<a class="sepV_a ttip_t" title="ซ่อน" onClick="fn_formShow(<?php
echo $news_data[$i]['newsId'];
?>
,'hide')"><i class="icon-eye-open"></i></a>
echo $user["nname"];
?>
</td>
</tr>
<tr>
<td align="right">เพศ : </td>
<td><?php
echo $user["sex"];
?>
</td>
</tr>
<tr>
<td align="right">วันเกิด : </td>
<td><?php
if ($user["birthday"] != "0000-00-00") {
echo Thai_date($user["birthday"]);
}
?>
</td>
</tr>
<tr>
<td align="right">สถานภาพ : </td>
<td><?php
echo $user["status2"];
?>
</td>
</tr>
<tr>
<td align="right">น้ำหนัก : </td>
<td><?php
echo $user["weight"];
<td style="text-align:center;"><?php
echo $i + 1;
?>
</td>
<td>
<a href="#myModalDetail<?php
echo $promo_data[$i]['promotionId'];
?>
" data-toggle="modal" class="ttip_t" title="รายละเอียดข่าว">
<?php
echo $promo_data[$i]['promotionTopic'];
?>
</a>
</td>
<td><?php
echo Thai_date($promo_data[$i]['dateAdd']);
?>
</td>
<td>
<div id="divShow<?php
echo $promo_data[$i]['promotionId'];
?>
" style="float:left; margin-right:5px; cursor:pointer;">
<?php
if ($promo_data[$i]['statusShow'] == 1) {
?>
<a class="sepV_a ttip_t" title="ซ่อน" onClick="fn_formShow(<?php
echo $promo_data[$i]['promotionId'];
?>
,'hide')"><i class="icon-eye-open"></i></a>
for ($i = 0; $i < count($aColumns); $i++) {
//echo $aColumns[$i]."/n";
//print_r($aColumns[$i]);
$row[0] = $n + $_REQUEST['iDisplayStart'];
if ($aColumns[$i] == "drivertaxi.firstName") {
$setrow1 = "<i class=\"splashy-contact_grey\" style=\"margin-right:5px;\"></i>";
$setrow1 .= $aRow['firstName'] . " " . $aRow['lastName'];
$row[1] = $setrow1;
}
if ($aColumns[$i] == "startPlace") {
$row[2] = $aRow['startPlace'];
}
if ($aColumns[$i] == "finishPlace") {
$row[3] = $aRow['finishPlace'];
}
if ($aColumns[$i] == "customerComment") {
$row[4] = $aRow['driverComment'];
}
if ($aColumns[$i] == "callTime") {
$row[5] = Thai_date($aRow['callTime']);
}
if ($aColumns[$i] == "historyId") {
$datenow = $aRow['callTime'];
$pTime = explode(' ', $datenow);
$thisTime = $pTime[1];
$row[6] = $thisTime;
}
}
$output['aaData'][] = $row;
}
echo json_encode($output);
<?php
$i = 0;
while ($i < $total) {
?>
<tr>
<td style="text-align:center;"><?php
echo $i + 1;
?>
</td>
<td><?php
echo $mobile_model[$i]['mobileModelName'];
?>
</td>
<td><?php
echo Thai_date($mobile_model[$i]['dateAdd']);
?>
</td>
<td>
<?php
if ($u_garage == $mobile_model[$i]['garageId'] || $u_type == 1) {
?>
<!--<a data-toggle="modal" data-backdrop="static" href="#myModalAdd"> -->
<!--<a href="index.php?p=mobile.type&menu=main_mobile&act=edit&id=<?php
echo $mobile_model[$i]['mobileModelId'];
?>
" class="sepV_a" title="Edit"><i class="icon-pencil"></i></a> -->
<a href="#" data-toggle="modal" data-backdrop="static" title="Edit" onclick="fn_formEdit(<?php
echo $mobile_model[$i]['mobileModelId'];
?>
, 'select');"><i class="icon-pencil"></i></a>
<?php
$i = 0;
while ($i < $total) {
?>
<tr>
<td style="text-align:center;"><?php
echo $i + 1;
?>
</td>
<td><?php
echo $car_color[$i]['carColorName'];
?>
</td>
<td><?php
echo Thai_date($car_color[$i]['dateAdd']);
?>
</td>
<td>
<?php
if ($u_garage == $car_color[$i]['garageId'] || $u_type == 1) {
?>
<!--<a data-toggle="modal" data-backdrop="static" href="#myModalAdd"> -->
<!--<a href="index.php?p=car.type&menu=main_car&act=edit&id=<?php
echo $car_color[$i]['carColorId'];
?>
" class="sepV_a" title="Edit"><i class="icon-pencil"></i></a> -->
<a href="#" data-toggle="modal" data-backdrop="static" title="Edit" onclick="fn_formEdit(<?php
echo $car_color[$i]['carColorId'];
?>
, 'select');"><i class="icon-pencil"></i></a>
<?php
$i = 0;
while ($i < $total) {
?>
<tr>
<td style="text-align:center;"><?php
echo $i + 1;
?>
</td>
<td><?php
echo $car_type[$i]['carTypeName'];
?>
</td>
<td><?php
echo Thai_date($car_type[$i]['dateAdd']);
?>
</td>
<td>
<!--<a data-toggle="modal" data-backdrop="static" href="#myModalAdd"> -->
<!--<a href="index.php?p=car.type&menu=main_car&act=edit&id=<?php
echo $car_type[$i]['carTypeId'];
?>
" class="sepV_a" title="Edit"><i class="icon-pencil"></i></a> -->
<a href="#" data-toggle="modal" data-backdrop="static" title="Edit" onclick="fn_formEdit(<?php
echo $car_type[$i]['carTypeId'];
?>
, 'select');"><i class="icon-pencil"></i></a>
<a href="#myModalDel<?php
echo $car_type[$i]['carTypeId'];
?>
<?php
$i = 0;
while ($i < $total) {
?>
<tr>
<td style="text-align:center;"><?php
echo $i + 1;
?>
</td>
<td><?php
echo $mobile_network[$i]['mobileNetworkName'];
?>
</td>
<td><?php
echo Thai_date($mobile_network[$i]['dateAdd']);
?>
</td>
<td>
<a href="#" data-toggle="modal" data-backdrop="static" title="Edit" onclick="fn_formEdit(<?php
echo $mobile_network[$i]['mobileNetworkId'];
?>
, 'select');"><i class="icon-pencil"></i></a>
<a href="#myModalDel<?php
echo $mobile_network[$i]['mobileNetworkId'];
?>
" data-toggle="modal" title="Delete"><i class="icon-trash"></i></a>
</td>
<td></td>
</tr>
<?php
$i = 0;
while ($i < $total) {
?>
<tr>
<td style="text-align:center;"><?php
echo $i + 1;
?>
</td>
<td><?php
echo $user_type[$i]['minorType'];
?>
</td>
<td><?php
echo Thai_date($user_type[$i]['dateAdded']);
?>
</td>
<td>
<a href="#" data-toggle="modal" data-backdrop="static" title="Edit" onclick="fn_formEdit(<?php
echo $user_type[$i]['minorTypeId'];
?>
, 'select');"><i class="icon-pencil"></i></a>
<a href="#myModalDel<?php
echo $user_type[$i]['minorTypeId'];
?>
" data-toggle="modal" title="Delete"><i class="icon-trash"></i></a>
</td>
<td></td>
</tr>
$row[1] = "<a href=\"index.php?p=user.customercheck&menu=main_user&customerId=" . $aRow['customerId'] . "\" title=\"ข้อมูลการใช้งานลูกค้า\">" . $aRow['firstName'] . ' ' . $aRow['lastName'] . "</a>";
}
if ($aColumns[$i] == 'email') {
$row[2] = $aRow['email'];
}
if ($aColumns[$i] == 'citizenId') {
$row[3] = $aRow['citizenId'];
}
if ($aColumns[$i] == 'credits') {
$row[4] = $aRow['credits'];
}
if ($aColumns[$i] == 'telephone') {
$row[5] = $aRow['telephone'];
}
if ($aColumns[$i] == "dateAdded") {
$row[6] = Thai_date($aRow['dateAdded']);
}
if ($aColumns[$i] == 'customerId') {
$set_tools = "<a style=\"cursor:pointer;\" class=\"ttip_t\" title=\"แก้ไข\" onClick=\"fn_Edit(" . $aRow['customerId'] . ")\" ><i class=\"icon-pencil\"></i></a>";
$set_tools .= " <a style=\"cursor:pointer;\" class=\"ttip_t\" title=\"เพิ่มเครดิต\" onClick=\"fn_addCredit(" . $aRow['customerId'] . ",'" . $aRow['firstName'] . ' ' . $aRow['lastName'] . "')\" ><i class=\"splashy-heart_add\"></i></a>";
$row[7] = $set_tools;
$set_tools2 = "<div id=\"div_lock" . $aRow['customerId'] . " style=\"float:left; margin-left:5px;\">";
if ($aRow['lock'] == 0) {
$set_tools2 = $set_tools2 . "<a href=\"#\" class=\"ttip_t\" title=\"สถานะล๊อค\" onclick=\"fn_changeLock('" . $aRow['customerId'] . "',1);\"><i class=\"splashy-thumb_down\"></i></a>";
} else {
$set_tools2 = $set_tools2 . "<a href=\"#\" class=\"ttip_t\" title=\"สถานะไม่ล๊อค\" onclick=\"fn_changeLock('" . $aRow['customerId'] . "',0);\"><i class=\"splashy-thumb_up\"></i></a>";
}
$set_tools2 = $set_tools2 . "</div>";
$row[8] = $set_tools2;
}
}
</div>
</td>
<td>
<div><strong>ยี่ห้อ</strong> :<?php
echo $mobile_data[$i]['mobileBanner'];
?>
</div>
<div><strong>รุ่น</strong> :<?php
echo $mobile_data[$i]['mobileModel'];
?>
</div>
</td>
<td><?php
echo Thai_date($mobile_data[$i]['dateAdd']);
?>
</td>
<td>
<div style="float:left; margin-right:5px;">
<form action="" method="post" name="fmEdit<?php
echo $i;
?>
" id="fmEdit<?php
echo $i;
?>
">
<input type="hidden" name="mobileId" value="<?php
echo $mobile_data[$i]['mobileId'];
?>
" />
echo $minor_data[$i]['email'];
?>
</td>
<td>
<?php
$type_data = select_db('minortype', "where minorTypeId = '" . $minor_data[$i]['minorTypeId'] . "'");
$type_name = $type_data[0]['minorType'];
?>
<div><?php
echo $type_name;
?>
</div>
</td>
<td><?php
echo Thai_date($minor_data[$i]['dateAdded']);
?>
</td>
<td>
<div style="float:left; margin-right:5px;">
<form action="" method="post" name="fmEdit<?php
echo $i;
?>
" id="fmEdit<?php
echo $i;
?>
">
<input type="hidden" name="minorId" value="<?php
echo $minor_data[$i]['minorId'];
?>
" />
</td>
<td style="background-color:<?php
echo $bgcolor;
?>
;"><?php
echo $data_history->latitude;
?>
, <?php
echo $data_history->longitude;
?>
</td>
<td style="background-color:<?php
echo $bgcolor;
?>
;"><?php
echo Thai_date($data_history->timeServer);
?>
</td>
<td style="background-color:<?php
echo $bgcolor;
?>
;"><?php
echo $thisTime;
?>
</td>
</tr>
<?php
// }
?>
</tbody>
<?php
$i = 0;
while ($i < $total) {
?>
<tr>
<td style="text-align:center;"><?php
echo $i + 1;
?>
</td>
<td><?php
echo $car_gas[$i]['carGasName'];
?>
</td>
<td><?php
echo Thai_date($car_gas[$i]['dateAdd']);
?>
</td>
<td>
<!--<a data-toggle="modal" data-backdrop="static" href="#myModalAdd"> -->
<!--<a href="index.php?p=car.type&menu=main_car&act=edit&id=<?php
echo $car_gas[$i]['carGasId'];
?>
" class="sepV_a" title="Edit"><i class="icon-pencil"></i></a> -->
<a href="#" data-toggle="modal" data-backdrop="static" title="Edit" onclick="fn_formEdit(<?php
echo $car_gas[$i]['carGasId'];
?>
, 'select');"><i class="icon-pencil"></i></a>
<a href="#myModalDel<?php
echo $car_gas[$i]['carGasId'];