Beispiel #1
0
         $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>";
Beispiel #2
0
		$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>";
}
Beispiel #3
0
 $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 = "";
Beispiel #4
0
 $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=\"ด่วนที่สุด\">";
             }
         }
     }
Beispiel #5
0
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>";
Beispiel #6
0
          </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]&nbsp;&nbsp;$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>
<?
//กำหนดเวลาให้แก้ไขได้
Beispiel #7
0
 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++;
Beispiel #8
0
                $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 
Beispiel #9
0
 $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}&nbsp;&nbsp;{$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) {
Beispiel #10
0
             $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 " - ว่าง - ";
 }