Gecko [ 122.154.134.11 ]

Name	Size	Permission
bootstrap-3.3.5-dist	[ DIR ]	drwxr-xr-x
fullcalendar-2.4.0	[ DIR ]	drwxr-xr-x
car_book.php	15.32 KB	-rwxr-xr-x
car_calendar.php	6.58 KB	-rwxr-xr-x
car_commander.php	32.5 KB	-rwxr-xr-x
car_group.php	29.95 KB	-rwxr-xr-x
car_list.php	16.42 KB	-rwxr-xr-x
car_officer.php	29.41 KB	-rwxr-xr-x
car_report.php	26.27 KB	-rwxr-xr-x
car_request.php	40.84 KB	-rwxr-xr-x
car_request_mobile.php	8.34 KB	-rwxr-xr-x
car_type.php	8.85 KB	-rwxr-xr-x
officer.php	14.49 KB	-rwxr-xr-x
oil_withdraw.php	29.44 KB	-rwxr-xr-x
permission.php	9.63 KB	-rwxr-xr-x
pic_show.php	831 B	-rwxr-xr-x
set_car.php	9.1 KB	-rwxr-xr-x
set_driver.php	7.88 KB	-rwxr-xr-x

Code Editor : car_calendar.php

<link rel="stylesheet" type="text/css" href="./modules/car/main/bootstrap-3.3.5-dist/css/bootstrap.min.css">
<script src="./modules/car/main/bootstrap-3.3.5-dist/js/jquery-1.11.3.min.js"></script>
<script src="./modules/car/main/bootstrap-3.3.5-dist/js/bootstrap.min.js"></script>
<script src="./modules/car/main/bootstrap-3.3.5-dist/js/bootstrap-confirmation.min.js"></script>

<?php

$searchtext="";
$action="";
$rdsearch="";
$chk1="";
$chk2="";
$chk3="";
$comG="";
if(isset($_POST['chk1'])!=""){ 
    $chk1 = $_POST['chk1'];
    $comG=$comG."0,";
}
if(isset($_POST['chk2'])!=""){
    $chk2 = $_POST['chk2'];
    $comG=$comG."1,";
}
if(isset($_POST['chk3'])!=""){
    $chk3 = $_POST['chk3'];
    $comG=$comG."2,";
}
$comG = substr($comG,0,strlen($comG)-1);
if($comG=="") $comG="0,1,2";
if(isset($_POST['rdsearch'])!="") $rdsearch = $_POST['rdsearch'];
if(isset($_POST['action'])!=""){
    $action = $_POST['action'];
}
if(isset($_POST['searchtext'])!=""){
    $searchtext = $_POST['searchtext'];
}else if(isset($_GET['searchtext'])!=""){
    $searchtext = $_GET['searchtext'];
}

//Database

$data = array();
$link = mysqli_connect($hostname, $user, $password, $dbname);
mysqli_set_charset($link, 'utf8');
if (!$link) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;
}
 $sql = "SELECT a.id,a.car_start as start,a.car_finish as end,
 CASE
 WHEN time_start<13 and time_finish<13 THEN CONCAT(a.place,' เวลา ',time_start,'.00 AM - ',time_finish,'.00 AM')
 WHEN time_start<13 and time_finish>=13 THEN CONCAT(a.place,' เวลา ',time_start,'.00 AM - ',time_finish,'.00 PM')
 WHEN time_start>=13 and time_finish>=13 THEN CONCAT(a.place,' เวลา ',time_start,'.00 PM - ',time_finish,'.00 PM')
 WHEN time_start>=13 and time_finish<13 THEN CONCAT(a.place,' เวลา ',time_start,'.00 PM - ',time_finish,'.00 AM')
 ELSE ''
 END as title,
 CONCAT('index.php?option=car&task=main/car_officer&index=7&page=1&id=',a.id) as url,
  CASE 
  WHEN commander_sign is NOT NULL THEN '#0000FF'
  WHEN group_sign     is NOT NULL THEN '#00FE00'
  WHEN officer_sign   is NOT NULL THEN '#00F8F0'
  WHEN officer_sign   is NULL THEN '#FF0000'
  ELSE ''
  END as color
FROM car_main a
left outer join car_car b on a.car=b.car_code
left outer join person_main aa on a.person_id=aa.person_id
left outer join person_main driver on a.driver=driver.person_id
where  (
    b.name like '%$searchtext%' 
    or aa.name like '%$searchtext%' 
    or aa.surname like '%$searchtext%' 
";
if($rdsearch =="1") $sql=$sql ."or b.car_number like '%$searchtext%' ";
if($rdsearch =="2") $sql=$sql ."
    or a.driver like '%$searchtext%' 
    or driver.name like '%$searchtext%' 
    or driver.surname like '%$searchtext%' ";
if($rdsearch =="3") $sql=$sql ."or a.place like '%$searchtext%' ";
if($rdsearch =="4") $sql=$sql ."or a.because like '%$searchtext%' ";

//$sql = $sql."  ) and a.commander_grant in ($comG) ";
$sql = $sql."  )  ";

$sql = $sql." order by car_start,time_start ";

if ($result = $link->query($sql)) {
    /* fetch object array */
    while ($obj = $result->fetch_object()) {
       $data[] = array(
                    'id' => $obj->id,
                    'title'=> $obj->title,
                    'start'=> $obj->start,
                    'end'=> $obj->end,
                    'url'=> $obj->url,
                    'color'=>$obj->color
                    );
    }
    /* free result set */
    $result->close();
}
mysqli_close($link);

?>
<script>
    $(document).ready(function() {
        
        $('#calendar').fullCalendar({
            header: {
                left: 'prev,next today',
                center: 'title',
                right: 'month,basicWeek,basicDay'
            },
            defaultDate: '<?php echo date("Y-m-d");?>',
            editable: false,
            displayEventEnd:true,
            displayEventTime:true,
            lang : 'th',            
            eventLimit: true, // allow "more" link when too many events
            events : <?php echo json_encode($data);?>
        });
        
    });
</script>
<BR>
<div class="container">
  <div class="panel panel-default">
      <div class="panel-heading"><h3 class="panel-title">ปฏิทินการใช้ยานพาหนะ</h3></div>
      <div class="panel-body">
                <form class="form-inline" action="#" enctype="multipart/form-data" method="POST">
                    <label>เงื่อนไข&nbsp;&nbsp;:&nbsp;&nbsp;</label>
                    
                    <div class="radio">
                        <label>
                            <input type="radio" name="rdsearch" value="1" <?php if($rdsearch == "1") echo "checked"; ?>> ยานพาหนะ
                        </label>
                    </div>
                    <div class="radio">
                        <label>
                            <input type="radio" name="rdsearch" value="2" <?php if($rdsearch == "2") echo "checked "; ?>> คนขับรถ
                        </label>
                    </div>
                    <div class="radio">
                        <label>
                            <input type="radio" name="rdsearch" value="3" <?php if($rdsearch == "3") echo " checked "; ?> > สถานที่
                        </label>
                    </div>
                        <label for="searchtext"></label>
                        <input type="text" class="form-control" id="searchtext" name="searchtext" placeholder="พิมพ์คำค้นหา" value="<?php echo $searchtext; ?>">
                        
                    <button type="submit" class="btn btn-default"><span class="glyphicon glyphicon-search"></span> ค้นหา</button>
                    <a href="?option=car&task=main/car_calendar&action=select_clearsearchtext" class="btn btn-default"><span class="glyphicon glyphicon-list"></span> แสดงทั้งหมด</a>
                        
                </form>
       
          </div>
<div id='calendar'></div>
    </div>
    </div>

${this.title}

Code Editor : car_calendar.php