echo $rsPsale['ru_name'];
?>
<br>
<?php
}
}
?>
<b>แก้ไขล่าสุด</b>
<p style='font-size: 11px;'>
<?
$eng_date=strtotime($rsPsale['rdg_update']);
echo thai_date($eng_date);
?>
</p>
</div>
</div>
<div class="row box-margin-top5">
<div class="col-xs-12">
<p>
<button data-target="#contactFormModal" data-toggle="modal" class="btn-u btn-u-xs btn-u-green contactFormModal" type="button" id="<?php
echo $rsPsale['cus_id'];
?>
-<?php
echo $rsPsale['rdg_id'];
?>
} else {
$postsend_date = mysqli_real_escape_string($connect, $_POST['send_date']);
$_GET['datepicker'] = $postsend_date;
}
//$datepicker = $_GET['datepicker'];
if (!isset($_GET['datepicker'])) {
$getdatepicker = date("Y-m-d");
$f2_date = date("Y-m-d");
} else {
$getdatepicker = mysqli_real_escape_string($connect, $_GET['datepicker']);
//$f1_date=explode("-", $getdatepicker);
//$f2_date=$f1_date[2]."-".$f1_date[1]."-".$f1_date[0]; //ปี เดือน วัน
$f2_date = $getdatepicker;
}
//$thai_date=thai_date(make_time($f2_date));
$thai_date = thai_date($f2_date);
echo "<br />";
echo "<table width='99%' border='0' align='center'>";
echo "<tr align='center'><td colspan=2><font color='#006666' size='3'><strong>การปฏิบัติราชการ {$thai_date}</strong></font></td></tr>";
echo "<tr align='center'><td colspan=2><font color='#006666' size='3'><strong>ของผู้บริหารสำนักงานคณะกรรมการการศึกษาขั้นพื้นฐาน</strong></font></td></tr>";
?>
<link rel="stylesheet" type="text/css" media="all" href="./modules/work/css.css">
<link rel="stylesheet" href="./jquery/themes/ui-lightness/jquery.ui.all.css">
<script src="./jquery/jquery-1.5.1.js"></script>
<script src="./jquery/ui/jquery.ui.core.js"></script>
<script src="./jquery/ui/jquery.ui.widget.js"></script>
<script src="./jquery/ui/jquery.ui.datepicker.js"></script>
<script>
$(function() {
$( "#datepicker" ).datepicker({
showButtonPanel: true,
//echo " 555 ". $user_permis;
require_once "modules/work/time_inc.php";
$officer = $user_id;
$today_date = date("Y-m-d");
$sql_user = "******";
$dbquery_user = $connect->prepare($sql_user);
$dbquery_user->bind_param("i", $officer);
$dbquery_user->execute();
$result_userdepart = $dbquery_user->get_result();
while ($result_user = $result_userdepart->fetch_array()) {
$department = $result_user['department'];
}
//ส่วนหัว
echo "<br />";
echo "<table width='99%' border='0' align='center'>";
echo "<tr align='center'>\n\t<td align=center><font color='#990000' size='3'><strong>บันทึกข้อมูลการปฏิบัติราชการ</strong></font>\n<font color='#006666' size='3'><strong>" . thai_date($today_date) . "</strong></font>\n</td></tr>";
echo "</table>";
echo "<br />";
$sql_post = "select * from person_position order by position_code ";
$dbquery_post = $connect->prepare($sql_post);
$dbquery_post->execute();
$result_allpost = $dbquery_post->get_result();
while ($result = $result_allpost->fetch_array()) {
$position_ar[$result['position_code']] = $result['position_name'];
}
//ส่วนบันทึกข้อมูล
if (isset($_POST['index'])) {
$postindex = mysqli_real_escape_string($connect, $_POST['index']);
} else {
$postindex = "";
}
} else {
echo '<table class="table table-responsive table-striped tb-task">
<thead>
<tr>
<th scope="col" class="" style="width:140px;">' . lang_date . '</th>
<th scope="col" class="" style="width:160px;">' . lang_time . '</th>
<th scope="col" class="" style="width:400px;">' . lang_title . '</th>
<th scope="col" class="">' . lang_room . '</th>
<th scope="col" class="">' . lang_people . '</th>
<th scope="col" class="" style="width:100px;">' . lang_status . '</th>
</tr>
</thead>';
foreach ($res as $tk) {
echo '
<tr class="status' . $tk['ord_status'] . ' room room' . $tk['ord_room_id'] . '" data-id="' . $tk['ord_id'] . '">
<td style="background-color:rgba(' . hex2rgb($tk['rm_color']) . ',.3);">' . thai_date($tk['cDay'], 0, 0) . '</td>
<td>' . $tk['sTime'] . ' - ' . $tk['eTime'] . '</td>
<td><a href="' . SITE_URL . '/v' . $tk['ord_id'] . '/"
data-target="#BookDetail"
data-toggle="modal"
data-html="true"
data-placement="left"
class="detail tt"
title="รายละเอียด">
' . $tk['ord_subject'] . '
</a></td>
<td>' . $tk['rm_name'] . '</td>
<td>' . $tk['ord_person'] . '</td>
<td>' . $status_array[$tk['ord_status']] . '</td>
</tr>';
}
$sqlOpd_Socail .= "r.*,o.vstdate,o.vsttime,t.name as pttype_name ";
$sqlOpd_Socail .= "from rcpt_arrear r ";
$sqlOpd_Socail .= "left outer join ovst o on o.vn=r.vn ";
$sqlOpd_Socail .= "left outer join patient p on p.hn=r.hn ";
$sqlOpd_Socail .= "left outer join pttype t on t.pttype = o.pttype ";
$sqlOpd_Socail .= "where r.hn={$hn} ";
$sqlOpd_Socail .= "and r.paid in ('N') order by r.arrear_id ";
$resultOpd_Socail = ResultDB($sqlOpd_Socail);
if (mysql_num_rows($resultOpd_Socail) > 0) {
$i = 0;
while ($i < mysql_num_rows($resultOpd_Socail)) {
$rsOpd_Socail = mysql_fetch_array($resultOpd_Socail);
echo "<table width='730' border='0'>";
echo "<tr>";
echo "<td width='63' align='right'>" . ($i + 1) . ".</td>";
echo "<td width=380'>гя╧╥уХарця║ир╬бр╨ре " . thai_date(strtotime($rsOpd_Socail['arrear_date'])) . "</td>";
echo "<td width='150'>╗с╧г╧Ю╖т╧╥уХ╓Ир╖╙сцп</td>";
echo "<td align='right' width='55'>" . number_format(floor($rsOpd_Socail['amount'])) . "</td>";
echo "<td> ╨р╥</td>";
echo "</tr>";
echo "</table>";
$i++;
}
}
//while
?>
<?php
$sql_sum_price = "select sum(amount) as price from rcpt_arrear where hn='{$hn}' and paid ='N' group by hn";
$resultOpd_Socail_sum = ResultDB($sql_sum_price);
$resultOpd_Socail_sum = mysql_fetch_array($resultOpd_Socail_sum);
$price = $resultOpd_Socail_sum['price'];
</tr>
<tr><td> </td></tr>
<tr>
<td>
<table border="1" width="80%" align="center" cellpadding="0" cellspacing="0" bordercolor="#AAAAAA">
<tr>
<td align="left">เลขที่ใบสั่งขาย :</td>
<td align="left"> <?php
echo $order["order_id"];
?>
</td>
</tr>
<tr>
<td align="left">วันที่สั่งซื้อ :</td>
<td align="left"><?php
echo thai_date(strtotime($order["order_date"]));
?>
</td>
</tr>
<? foreach($order_detail as $item){?>
<tr>
<td align="left">รหัสร้านค้า :</td>
<td align="left"> <?echo $item["vendor_id"]; ?></td>
</tr>
<tr>
<td align="left" valign="top">รายละเอียด :</td>
<td align="left"> <?echo $item["product_name"];?></td>
</tr>
<? }?>
</table>
</td>
<div class="order_id_data"><?=$order_id?></div>
<div class="voucher">CUSTOMER ID :</div>
<div class="order_id">REDEMPTION CODE :</div>
<div class="voucher_data"><?=$member_id?></div>
<div class="order_id_data"><?=$redemption_code?></div>
</div>
<div class="detail_box">
<div class="logo"></div>
<div class="barcode_box" style="padding: 0 10px;"><img src="http://www.barcodesinc.com/generator/image.php?code=<?=$barcode?>&style=164&type=C128B&width=280&height=100&xres=1&font=5"/></div>
<div class="coupon_time_head">สงวนลิขสิทธิ์ไม่คืนเงินสำหรับคูปองที่ไม่ได้ใช้ภายในระยะเวลา</div>
<div class="valid">VALID FROM:</div>
<?
$coupon_can_use_full=strtotime(date_format(date_create($coupon_can_use),"Y-m-d"));
$coupon_expire=strtotime(date_format(date_create($coupon_expire),"Y-m-d"));
?>
<div class="coupon_time"><?=thai_date($coupon_can_use_full)?> to <?=thai_date($coupon_expire)?></div>
<div class="qrcode_box">
<div class="qr_text1">Need Assistance?</div>
<div class="qr_text2">Call Thebestdeal1 : 02 938 4399 | Email : info@thebestdeal1.com</div>
<div class="img1"><?=image_asset('../../assets/images/thebestdeal1.png');?></div>
<div class="img3"><?=image_asset('../../assets/images/facebook.png');?></div>
<div class="qr_text3">Thebestdeal1.com</div>
<div class="qr_text4">Facebook</div>
</div>
</div>
</div>
<div class="m_Sec">
<div class="m_SecL">
<div class="fine_print">Fine Print :</div>
<div class="fine_print_detail"><?=$fine_print?></div>
</div>
<th><i class="fa fa-clock-o fa-fw"></i> <?php echo lang_start; ?> </th> <td><?php echo thai_date($rm[0]['ord_date_start'], 0, 1); ?> </td> </tr> <tr> <th><i class="fa fa-clock-o fa-fw"></i> <?php echo lang_end; ?> </th> <td><?php echo thai_date($rm[0]['ord_date_end'], 0, 1); ?> </td> </tr> <tr> <th><i class="fa fa-quote-left fa-fw"></i> <?php echo lang_subject; ?> </th> <td><?php echo $rm[0]['ord_subject']; ?> </td> </tr> <tr> <th><i class="fa fa-users fa-fw"></i> <?php
<th class="text-center" style="background-color:#b71c1c;color:white;">R</th>
<th class="text-center" style="background-color:#d81b60;color:white;">E</th>
<th class="text-center" style="background-color:#ffea00;color:white;" >U</th>
<th class="text-center" style="background-color:#43a047;color:white;">SU</th>
<th class="text-center" style="background-color:#9e9e9e;color:white;">N</th>
<th class="text-center">Admit</th>
<th class="text-center">Dead</th>
</tr>
</thead>
<tbody>
<?php
$graph_sql = "\n SELECT\n ath_7days.em_date,\n Sum(IF(ath_7days.em_sex = 'm',1,0)) AS man,\n Sum(IF(ath_7days.em_sex = 'w',1,0)) AS woman,\n SUM(IF(ath_7days.em_type = 'R',1,0)) AS R,\n SUM(IF(ath_7days.em_type = 'E',1,0)) AS E,\n SUM(IF(ath_7days.em_type = 'U',1,0)) AS U,\n SUM(IF(ath_7days.em_type = 'S',1,0)) AS S,\n SUM(IF(ath_7days.em_type = 'N',1,0)) AS N,\n (Sum(IF(ath_7days.em_sex = 'm',1,0)) + Sum(IF(ath_7days.em_sex = 'w',1,0))) AS total,\n SUM(IF(ath_7days.em_admit = 1,1,0)) AS admit,\n SUM(IF(ath_7days.em_dead = 1,1,0)) AS dead\n FROM\n ath_7days\n GROUP BY\n ath_7days.em_date\n ";
$graph_query = CON::selectArrayDB(array(), $graph_sql);
foreach ($graph_query as $row) {
echo '<tr class="text-center">
<td>' . thai_date($row['em_date'], 0, 0) . '</td>
<td class="active"><strong>' . $row['total'] . '</strong></td>
<td>' . $row['man'] . '</td>
<td>' . $row['woman'] . '</td>
<td>' . $row['R'] . '</td>
<td>' . $row['E'] . '</td>
<td>' . $row['U'] . '</td>
<td>' . $row['S'] . '</td>
<td>' . $row['N'] . '</td>
<td>' . $row['admit'] . '</td>
<td>' . $row['dead'] . '</td>
</tr>';
$level .= '{ date: "' . $row['em_date'] . '", r: ' . $row['R'] . ', e: ' . $row['E'] . ', u:' . $row['U'] . ',s:' . $row['S'] . ',n:' . $row['N'] . ' },';
$sumation .= '{ date: "' . $row['em_date'] . '", t: ' . $row['total'] . '},';
$sumT = $row['total'] + $sumT;
$sumM = $row['man'] + $sumM;
ord_id,
DATE(' . TB_PREFIX . 'booking_order.ord_date_start) as cDay,
TIME_FORMAT(' . TB_PREFIX . 'booking_order.ord_date_start,"%H:%i%p") as sTime,
TIME_FORMAT(' . TB_PREFIX . 'booking_order.ord_date_end,"%H:%i%p") as eTime,
ord_date_end,
ord_subject,
ord_person,
ord_room_id,
ord_status,
rm_name,
rm_color
FROM
' . TB_PREFIX . 'booking_order
INNER JOIN
' . TB_PREFIX . 'booking_room ON (' . TB_PREFIX . 'booking_order.ord_room_id = ' . TB_PREFIX . 'booking_room.rm_id)
ORDER BY
' . TB_PREFIX . 'booking_order.ord_date_start DESC';
$query = CON::selectArrayDB(array(), $arsql);
foreach ($query as $row) {
$approved = $row['ord_status'] == 0 ? '<a id="btn' . $row['ord_id'] . '" class="btn btn-success clickOFF approve tt" title="อนุมัติ" data-placement="left" data-id="' . $row['ord_id'] . '" data-act="apv" href="../admin-manage.php"><i class="fa fa-check"></i></a>' : '';
$data['data'][] = array('DT_RowId' => 'row' . $row['ord_id'], 'date' => thai_date($row['cDay'], 1, 0), 'time' => $row['sTime'] . ' - ' . $row['eTime'], 'subject' => '<a href="' . SITE_URL . '/v' . $row['ord_id'] . '/"
data-target="#BookDetail"
data-toggle="modal"
data-html="true"
data-placement="left"
class="detail tt"
title="รายละเอียด">
' . $row['ord_subject'] . '
</a>', 'name' => $row['rm_name'], 'person' => $row['ord_person'], 'status' => $status_array[$row['ord_status']], 'manage' => '<div class="btn-group btn-group-xs pull-right">' . $approved . '<a class="btn btn-warning tt" title="แก้ไข" data-placement="top" href="' . SITE_URL . '/booking/' . $row['ord_id'] . '/edit/"><i class="fa fa-edit"></i></a><a class="btn btn-danger clickOFF delete tt" title="ลบ" data-placement="right" data-id="' . $row['ord_id'] . '" data-act="delord" href="../admin-manage.php"><i class="fa fa-trash"></i></a></div>');
}
echo json_encode($data);
$sql_person = "select * from person_main where person_id='$ref_result[person_id]' ";
$dbquery_person = mysqli_query($connect,$sql_person);
$result_person = mysqli_fetch_array($dbquery_person);
$sql_car = "select * from car_car where car_code='$ref_result[car]' ";
$dbquery_car = mysqli_query($connect,$sql_car);
$result_car= mysqli_fetch_array($dbquery_car);
echo "<Table width='80%'>";
echo "<Tr align='left'><Td align='right'>เรื่อง </Td><Td>ขออนุญาตเบิกน้ำมันเชื้อเพลิงและน้ำมันหล่อลื่น</Td></Tr>";
echo "<Tr align='left'><Td align='right'>เรียน </Td><Td>ผู้อำนวยการ$_SESSION[office_name]</Td></Tr>";
echo "<Tr align='left'><Td> </Td><Td>ตามที่อนุญาตให้ <b>$result_person[prename]$result_person[name] $result_person[surname]</b> ใช้รถราชการหมายเลขทะเบียน <b>$result_car[car_number] ($result_car[name])</b> </Td></Tr>";
echo "<Tr align='left'><Td> </Td><Td>เพื่อ <b>$ref_result[because]</b> ในวันที่ <b>";
echo thai_date($ref_result['car_start']);
echo "</b></Td></Tr>";
echo "<Tr align='left'><Td> </Td><Td>ถึงวันที่ <b>";
echo thai_date($ref_result['car_finish']);
echo "</b> รวม <b>$ref_result[day_total]</b> วัน ระยะทางไปราชการครั้งนี้ ไป-กลับ (ประมาณ).......................... กิโลเมตร นั้น</Td></Tr>";
echo "<Tr align='left'><Td> </Td><Td> เสนอข้อมูลประกอบการพิจารณาอนุญาตเติม ( )น้ำมันดีเซล ( )น้ำมันเบนซิล ครั้งนี้ ดังนี้ </Td></Tr>";
if($ref_result['fuel']==1){
$ref_result['project']="งบเชื้อเพลิงกลาง สพท.";
$ref_result['activity']="...........................";
}
else if($ref_result['fuel']==0){
$ref_result['project']="-";
$ref_result['activity']="-";
$ref_result['money']="-";
}
echo "<Tr align='left'><Td align='right' valign='top'>1. </Td><Td>ใช้งบประมาณโครงการ <b>$ref_result[project]</b> รหัสโครงการ................................<br />กิจกรรม <b>$ref_result[activity]</b> จำนวนเงิน <b>$ref_result[money]</b> บาท</Td></Tr>";
echo "<Tr align='left'><Td align='right'>2. </Td><Td>มาตรฐานของรถ</Td></Tr>";
echo "<Tr align='left'><Td> </Td><Td>ถังน้ำมันเชื้อเพลิงบรรจุได้เต็ม จำนวน..................ลิตร ความสิ้นเปลืองจำนวน 1 ลิตร ต่อ................กิโลเมตร</Td></Tr>";
echo "<Tr align='left'><Td align='right' valign='top'>3. </Td><Td>จากรายงานการใช้พาหนะครั้งสุดท้ายโดย.................................................</Td></Tr>";
