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>";