$book_department_name = $result_depart_name['department_name']; $book_department_precisname = $result_depart_name['department_precis']; } $showdepartmybook = " <a tabindex='0' class='btn btn-warning btn-xs' role='button' data-toggle='popover' data-placement='top' data-trigger='focus' title='สำนัก' data-content={$book_department_name}>{$book_department_precisname}</a>"; } else { $showdepartmybook = ""; } //if(($M%2) == 0) $color = ""; //else $color="#FFFFFF"; echo "<Tr bgcolor='{$color}'>"; echo "<Td align='left'>"; echo thai_date_3($book_date_start); echo "</Td>"; echo "<Td align='left'>"; echo thai_date_3($book_date_end); echo "</Td>"; echo "<Td align='left'>"; echo $room_name; echo "</Td>"; echo "<Td align='center'>{$start_time} น.</Td><Td align='center' >{$finish_time} น.</Td>"; echo "<td>{$result['chairman']}/{$result['objective']}</td>"; echo "<td>{$result['other']}/{$result['coordinator']}</td>"; echo "<Td>{$name} {$surname}(<font size='1px'>"; echo thai_date_4($rec_date); //echo $rec_date; echo "</font>) {$showdepartmybook}</Td>"; if ($result['reason'] != "") { echo "<Td align='left'>{$result['reason']}</Td>"; } else { echo "<td></td>";
$car_start = $result['car_start']; $car_finish = $result['car_finish']; $rec_date = $result['rec_date']; $officer_sign = $result['officer_sign']; $group_sign = $result['group_sign']; $grant = $result['commander_grant']; $commander_sign = $result['commander_sign']; ?> <Tr> <Td><?=$N?></Td> <Td><? echo thai_date_3($car_start);?></Td> <Td><? echo thai_date_3($car_finish);?></Td> <Td><?=$result['name']?></Td> <Td><? echo $full_name_ar[$person_id];?></Td> <Td><? echo thai_date_3($rec_date);?></Td> <Td> <? if($grant==1){echo "<img src=images/yes.png border='0'>";} else if($grant==2){echo "<img src=images/no.png border='0'>";} else{echo "รออนุมัติ";} echo "</Td>"; ?> <Td><a href=?option=car&task=main/car_officer&car_index=<?=$car_index?>&page=<?=$page?>&index=7&id=<?=$id?> class='btn btn-primary'><span class='glyphicon glyphicon-file' ></span></a></Td> <? if($result['officer_sign']!=""){ echo "<Td><img src=images/yes.png border='0'></Td>"; } else{ echo "<Td><img src=images/no.png border='0' ></Td>"; }
$book_from = $result['book_from']; $book_to = $result['book_to']; $subject = $result['subject']; $group = $result['department']; $group_sub = $result['sub_department']; $operation = $result['operation']; $comment = $result['comment']; $register_date = $result['register_date']; $ref_id = $result['ref_id']; if ($M % 2 == 0) { $color = "#ffffff"; } else { $color = "#FFFFC"; } $signdate = thai_date_3($signdate); $register_date = thai_date_3($register_date); // ตรวจสอบไฟล์แนบ if ($result['book_link'] == 0) { $file = mysqli_query($connect, "SELECT id FROM bookregister_receive_filebook WHERE ref_id='{$ref_id}' "); } else { if ($result['book_link'] == 1) { $file = mysqli_query($connect, "SELECT * FROM book_filebook WHERE ref_id='{$ref_id}' "); } else { if ($result['book_link'] == 2) { $file = mysqli_query($connect, "SELECT * FROM bookregister_send_filebook_sch WHERE ref_id='{$ref_id}' "); } } } $file_num = mysqli_num_rows($file); if ($file_num == 0) { $file_img = "";
$sender = $result['sender']; $office = $result['office']; $ref_id = $result['ref_id']; $level = $result['level']; $bookno = $result['bookno']; $signdate = $result['signdate']; $subject = $result['subject']; $ref_id = $result['ref_id']; $rec_date = $result['send_date']; if ($M % 2 == 0) { $color = "#ffffff"; } else { $color = "#E5E5FF"; } $send_date = thai_date_4($rec_date); $signdate = thai_date_3($signdate); // ระดับความสำคัญ if ($level == 1) { $img_level = "<IMG SRC=\"modules/book/images/level1.gif\" WIDTH=\"20\" HEIGHT=\"11\" BORDER=\"0\" ALT=\"ปกติ\">"; } else { if ($level == 2) { $img_level = "<IMG SRC=\"modules/book/images/level2.gif\" WIDTH=\"20\" HEIGHT=\"11\" BORDER=\"0\" ALT=\"ด่วน\">"; } else { if ($level == 3) { $img_level = "<IMG SRC=\"modules/book/images/level3.gif\" WIDTH=\"20\" HEIGHT=\"11\" BORDER=\"0\" ALT=\"ด่วนมาก\">"; } else { if ($level == 4) { $img_level = "<IMG SRC=\"modules/book/images/level4.gif\" WIDTH=\"20\" HEIGHT=\"11\" BORDER=\"0\" ALT=\"ด่วนที่สุด\">"; } } }
echo "<table width='65%' border='0' align='center'>"; echo "<Tr bgcolor='#FFCCCC'><Td align='center' rowspan='2' width='50'>ที่</Td><td align='center' colspan='2'>วันรักษาราชการแทน</td><Td align='center' rowspan='2'>ผู้รักษาราชการแทน</Td><Td align='center' rowspan='2'>ตำแหน่ง</Td></Tr>"; echo "<tr bgcolor='#CC9900'><Td align='center' width='110'>เริ่ม</Td><Td align='center' width='110'>สิ้นสุด</Td></tr>"; $N = ($page - 1) * $pagelen + 1; //*เกี่ยวข้องกับการแยกหน้า $M = 1; while ($result = mysqli_fetch_array($dbquery)) { $id = $result['id']; $prename = $result['prename']; $name = $result['name']; $surname = $result['surname']; if ($M % 2 == 0) { $color = "#FFFFC"; } else { $color = "#FFFFFF"; } echo "<Tr bgcolor={$color}><Td align='center'>{$M}</Td><Td align='center'>"; echo thai_date_3($result['start']); echo "</Td><Td align='center'>"; echo thai_date_3($result['finish']); echo "</Td><Td align='left'>{$prename}{$name} {$surname}</Td><td>"; $sql_position = "select position_name from person_position where position_code='{$result['position_code']}'"; $dbquery_position = mysqli_query($connect, $sql_position); $result_position = mysqli_fetch_array($dbquery_position); echo $result_position['position_name']; echo "</td></Tr>"; $M++; $N++; //*เกี่ยวข้องกับการแยกหน้า } echo "</Table>";
</thead> <tbody> <? $N=(($page-1)*$pagelen)+1; //*เกี่ยวข้องกับการแยกหน้า $M=1; While ($result = mysqli_fetch_array($query)){ $id = $result['id']; $rec_date = $result['rec_date']; $finish_mile= $result['finish_mile']; $fuel = $result['fuel']; ?> <Tr bgcolor='$color'> <Td valign='top' align='center'><?=$N?></Td> <Td valign='top' align='left'><? echo thai_date_3($rec_date);?></Td> <Td> <? $sql_person = "select * from person_main where person_id='$result[person_id]' "; $query_person = mysqli_query($connect,$sql_person); $result_person = mysqli_fetch_array($query_person); echo "$result_person[prename]$result_person[name] $result_person[surname]"; ?> </Td> <Td><?=$result['car_number']?></Td> <Td><?=$result['place']?></Td> <Td><?=$result['finish_mile']?></Td> <Td><?=$result['fuel']?></Td> <Td><a href=?option=car&task=main/car_report&index=7&id=$id&page=$page&car_index=$car_index><img src=images/browse.png border='0' alt='รายละเอียด'></Td> <? //กำหนดเวลาให้แก้ไขได้
if ($M % 2 == 0) { $color = "#FFFFB"; } else { $color = "#FFFFFF"; } echo "<Tr bgcolor='{$color}'><Td valign='top' align='center'>{$N}</Td><Td valign='top' align='left'>"; echo thai_date_3($car_start); echo "</Td><Td align='left'>"; echo thai_date_3($car_finish); echo "</Td>"; echo "<Td valign='top' align='left' >{$result['name']}</Td>"; echo "<Td valign='top' align='left' >"; echo $full_name_ar[$person_id]; echo "</Td>"; echo "<Td valign='top' align='left' >"; echo thai_date_3($rec_date); echo "</Td>"; echo "<Td valign='top' align='center'>"; if ($grant == 1) { echo "<img src=images/yes.png border='0'>"; } else { if ($grant == 2) { echo "<img src=images/no.png border='0'>"; } else { echo "รออนุมัติ"; } } echo "</Td>"; echo "</Tr>"; $M++; $N++;
$showdepartmybook = " <a tabindex='0' class='btn btn-warning btn-xs' role='button' data-toggle='popover' data-placement='top' data-trigger='focus' title='ห้องประชุมสำนัก' data-content={$book_department_name}>{$book_department_precisname}</a>"; } else { $showdepartmybook = ""; } ?> <tr <?php echo $tr_class; ?> > <td><?php echo thai_date_3($row['book_date_start']); ?> </td> <td><?php echo thai_date_3($row['book_date_end']); ?> </td> <td><?php echo $row['room_name'] . $showdepartmybook; ?> </td> <td><?php echo number_format($row['start_time'], 2) . "-" . number_format($row['finish_time'], 2) . "น."; ?> </td> <td><?php echo $row['chairman'] . "/" . $row['objective']; ?> </td> <td><?php
$start_time = $result['start_time']; $start_time = number_format($start_time, 2); $finish_time = $result['finish_time']; $finish_time = number_format($finish_time, 2); $book_date = $result['book_date']; $rec_date = $result['rec_date']; $name = $result['name']; $surname = $result['surname']; if ($M % 2 == 0) { $color = "#FFFFB"; } else { $color = "#FFFFFF"; } echo "<Tr bgcolor='{$color}'>"; echo "<Td align='left'>"; echo thai_date_3($book_date); echo "</Td>"; echo "<Td align='left'>"; if (isset($room_ar[$room])) { echo $room_ar[$room]; } echo "</Td>"; echo "<Td align='center'>{$start_time} น.</Td><Td align='center' >{$finish_time} น.</Td>"; echo "<td>{$result['objective']}</td>"; echo "<Td>{$name} {$surname}</Td>"; if ($result['book_person'] == $user) { echo "<Td align='center'><a href=?option=meeting&task=main/meeting_mobile&index=2&id={$id}&page={$page}&room_index={$room_index}><img src=images/drop.png border='0' alt='ลบ'></Td>"; } else { echo "<td></td>"; } if ($result['approve'] == 1) {
$dbquery_depart->execute(); $result_qdepart = $dbquery_depart->get_result(); while ($result_depart = mysqli_fetch_array($result_qdepart)) { $department_name = $result_depart['department_name']; $department_precis = $result_depart['department_precis']; } if ($approve == 1) { $showstatus = "อนุญาตแล้ว"; } else { if ($approve == 2) { $showstatus = "<font color='red'>ไม่อนุญาต</font>"; } else { $showstatus = "<font color='blue'>รอการอนุญาต</font>"; } } echo "<tr><td>วันที่ " . thai_date_3($book_date_start) . " ถึง " . thai_date_3($book_date_end) . "</td>"; echo "<td>เวลา : {$start_time} น. - {$finish_time} น.</td>"; echo "<td>ผู้จอง : {$name} {$surname}({$department_precis})</td>"; echo "<td>สถานะ : {$showstatus}</td>"; echo "<td>ผู้เข้าประชุม : {$person_num} คน</td>"; echo "</tr>"; echo "<tr><td align='left' colspan='5'>เรื่อง : ({$chairman}){$objective}</td></tr>"; echo "<tr><td align='left' colspan='5' height='1px'></td></tr>"; echo "<tr><td align='left' colspan='5' height='1px'></td></tr>"; } //แสดงรายการที่มีการจอง } } else { //ตรวจสอบมีการจองห้องหรือไม่ echo " - ว่าง - "; }