Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- session_start();
- $level = $_SESSION['level'];
- $ic = $_SESSION['ic'];
- include ("config/db.php");
- $sql_u = "SELECT * FROM personal WHERE ic ='$ic'";
- $result_u = mysql_query ($sql_u);
- $row_u = mysql_fetch_array($result_u);
- $row = mysql_num_rows ($result_u);
- echo $row;
- if($_POST['submit_add']){
- $name_customer = mysql_real_escape_string($_POST['name_customer']);
- $date = mysql_real_escape_string($_POST['date']);
- $destination = mysql_real_escape_string($_POST['destination']);
- $expected_activities = mysql_real_escape_string($_POST['expected_activities']);
- $category = "customer";
- $error = NULL;
- if(empty($name_customer)){
- $error['name_customer'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($date)){
- $error['date'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($destination)){
- $error['destination'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($expected_activities)){
- $error['expected_activities'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if($error == NULL){
- $sql = "INSERT INTO sementara_travel (ic, name_customer, date, destination, expected_activities, category) VALUES
- ('$ic', '$name_customer', '$date', '$destination','$expected_activities', '$category')";
- $result = mysql_query ($sql) or die (mysql_error());
- }
- }
- //hotel
- if($_POST['submit_hotel']){
- $name_hotel = mysql_real_escape_string ( $_POST['name_hotel']);
- $accommodation_date = mysql_real_escape_string ( $_POST['accommodation_date']);
- $to_date_hotel = mysql_real_escape_string ( $_POST['to_date_hotel']);
- $type_room = mysql_real_escape_string ( $_POST['type_room']);
- $category = "hotel";
- $error = NULL;
- if(empty($name_hotel)){
- $error['name_hotel'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($accommodation_date)){
- $error['accommodation_date'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($to_date_hotel)){
- $error['to_date_hotel'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($type_room)){
- $error['type_room'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if($error == NULL){
- $sql = "INSERT INTO sementara_travel (ic, name_hotel, accommodation_date, to_date_hotel, type_room, category) VALUE ('$ic',
- '$name_hotel', '$accommodation_date','$to_date_hotel', '$type_room', '$category')";
- $result = mysql_query ($sql) or die (mysql_error());
- }
- }
- //name_accommodation
- if($_POST['submit_preview']){
- $name_accommodation = mysql_real_escape_string($_POST['name_accommodation']);
- $name_travel = mysql_real_escape_string($_POST['name_travel']);
- $class_travel = mysql_real_escape_string($_POST['class_travel']);
- $type_flight = mysql_real_escape_string($_POST['type_flight']);
- $departure_date = mysql_real_escape_string($_POST['departure_date']);
- $from = mysql_real_escape_string($_POST['from']);
- $to = mysql_real_escape_string($_POST['to']);
- $time_departure = mysql_real_escape_string($_POST['time_departure']);
- $time_arrival = mysql_real_escape_string($_POST['time_arrival']);
- $return_date = mysql_real_escape_string($_POST['return_date']);
- $from1 = mysql_real_escape_string($_POST['from1']);
- $to1 = mysql_real_escape_string($_POST['to1']);
- $estimated_departure = mysql_real_escape_string($_POST['estimated_departure']);
- $estimated_arrival = mysql_real_escape_string($_POST['estimated_arrival']);
- $date_needed = mysql_real_escape_string($_POST['date_needed']);
- $to2 = mysql_real_escape_string($_POST['to2']);
- $period = mysql_real_escape_string($_POST['period']);
- $start = mysql_real_escape_string($_POST['start']);
- $to_start = mysql_real_escape_string($_POST['to_start']);
- $purpose = mysql_real_escape_string($_POST['purpose']);
- $destination_car = mysql_real_escape_string($_POST['destination_car']);
- $driver = mysql_real_escape_string($_POST['driver']);
- $pick_up = mysql_real_escape_string($_POST['pick_up']);
- $date_departure = mysql_real_escape_string($_POST['date_departure']);
- $from_date = mysql_real_escape_string($_POST['from_date']);
- $to_date = mysql_real_escape_string($_POST['to_date']);
- $time_departure_car = mysql_real_escape_string($_POST['time_departure_car']);
- $time_arrival_car = mysql_real_escape_string($_POST['time_arrival_car']);
- $category = "travel";
- $error = NULL;
- if(empty($name_accommodation)){
- $error['name_accommodation'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($name_travel)){
- $error['name_travel'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($class_travel)){
- $error['class_travel'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($type_flight)){
- $error['type_flight'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($departure_date)){
- $error['departure_date'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($from)){
- $error['from'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($to)){
- $error['to'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($time_departure)){
- $error['time_departure'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($time_arrival)){
- $error['time_arrival'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($return_date)){
- $error['return_date'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($from1)){
- $error['from1'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($to1)){
- $error['to1'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($estimated_departure)){
- $error['estimated_departure'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($estimated_arrival)){
- $error['estimated_arrival'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($date_needed)){
- $error['date_needed'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($to2)){
- $error['to2'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($period)){
- $error['period'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($start)){
- $error['start'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($to_start)){
- $error['to_start'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($purpose)){
- $error['purpose'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($destination_car)){
- $error['destination_car'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($driver)){
- $error['driver'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($pick_up)){
- $error['pick_up'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($date_departure)){
- $error['date_departure'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($from_date)){
- $error['from_date'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($to_date)){
- $error['to_date'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($time_departure_car)){
- $error['time_departure_car'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if(empty($time_arrival_car)){
- $error['time_arrival_car'] = "<font color = 'red'> Sila Masukkan Nama Jawatan!</font>";
- }
- if($error == NULL){
- $sql = "INSERT INTO sementara_travel (ic, name_accommodation, name_travel, class_travel, type_flight, departure_date, from, to,
- time_departure, time_arrival,return_date, from1, to1, estimated_departure, estimated_arrival, date_needed, to2, period, start,
- to_start, purpose, destination_car, driver, pick_up, date_departure, from_date, to_date, time_departure_car, time_arrivel_car,
- category)VALUES ('$ic', '$name_accommodation', '$name_travel', '$class_travel','$type_flight', '$departure_date', '$from', '$to',
- '$time_departure', '$time_arrival', '$return_date', '$from1', '$to1', '$estimated_departure','$estimated_arrival', '$date_needed',
- '$to2', '$period', '$start', '$to_start', '$purpose', '$destination_car', '$driver', '$pick_up', '$date_departure',
- '$from_date', '$to_date', '$time_departure_car', '$time_arrival_car', '$category')";
- $result = mysql_query ($sql) or die (mysql_error());
- echo $sql;
- echo '<meta http-equiv="refresh" content="2; cikmie.php" />';
- }
- }
- echo "<pre>" , print_r($_POST) ."</pre>";
- // delete customer
- if($_GET['item']=="delete"){
- $id = $_GET['id'];
- echo $id;
- echo "select";
- // letak command utk delte sql where id = '$id'
- $query = "DELETE from sementara_travel where id= '$id'";
- $result= mysql_query($query);
- header ("Location:travel.php");
- }
- ?>
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
- <html>
- <head>
- <meta http-equiv="Content-type" content="text/html; charset=utf-8" />
- <title>Show/Hide</title>
- <?
- $level = $_SESSION['level'];
- $ic = $_SESSION['ic'];
- include ("config/db.php");
- $link = include("config/db.php");
- if (!$link) {
- die('Could not connect: ' . mysql_error());
- }
- echo 'Connected successfully';
- ?>
- <script type="text/javascript">
- // <![CDATA[
- function display(obj,id1,id2) {
- txt = obj.options[obj.selectedIndex].value;
- document.getElementById(id1).style.display = 'none';
- document.getElementById(id2).style.display = 'none';
- if ( txt.match(id1) ) {
- document.getElementById(id1).style.display = 'block';
- }
- if ( txt.match(id2) ) {
- document.getElementById(id2).style.display = 'block';
- }
- }
- // ]]>
- </script>
- </head>
- <body>
- <form name="form1" method="post" action="travel.php">
- <table width="842" border="1">
- <tr>
- <th width="832" height="1425" scope="col"><table width="811" border="1">
- <tr>
- <th width="801" height="149" scope="col"><div align="justify">
- <table width="200" border="1">
- <tr>
- <th scope="col"><div align="justify">Personal Information</div></th>
- </tr>
- </table>
- <table width="738" border="1">
- <tr>
- <th width="167" scope="col"><div align="justify">Employee Name</div></th>
- <th width="8" scope="col"><div align="justify">:</div></th>
- <th width="541" scope="col"><div align="justify">
- <label>
- <input type="text" name="name" id="name" value="<? echo $row_u['name'] ?>">
- </label>
- </div></th>
- </tr>
- <tr>
- <th scope="col"><div align="justify">Designation</div></th>
- <th scope="col"><div align="justify">:</div></th>
- <th scope="col"><div align="justify">
- <label>
- <input type="text" name="designation" id="designation" value="<? echo $row_u['designation'] ?>">
- </label>
- </div></th>
- </tr>
- <tr>
- <th scope="col"><div align="justify">Department</div></th>
- <th scope="col"><div align="justify">:</div></th>
- <th scope="col"><div align="justify">
- <label>
- <input type="text" name="department" id="department" value="<? echo $row_u['department'] ?>">
- </label>
- </div></th>
- </tr>
- <tr>
- <th scope="col"><div align="justify">Company</div></th>
- <th scope="col"><div align="justify">:</div></th>
- <th scope="col"><div align="justify">
- <label>
- <input type="text" name="company" id="company" value="<? echo $row_u['company'] ?>">
- </label>
- </div></th>
- </tr>
- </table>
- </div></th>
- </tr>
- </table>
- <table width="95%" border="1">
- <tr>
- <td colspan="3"><table width="75%" border="1">
- <tr>
- <td colspan="3">Travel Itinerary / Purpose Of Trip </td>
- </tr>
- </table>
- <table width="86%" border="1">
- <tr>
- <td width="24%"><div align="justify">Name Of Customer</div></td>
- <td width="2%"><div align="justify">:</div></td>
- <td width="31%"><div align="justify">
- <input name="name_customer" type="text" id="name_customer">
- </div></td>
- <td width="43%"> </td>
- </tr>
- <tr>
- <td><div align="justify">Date</div></td>
- <td><div align="justify">:</div></td>
- <td><div align="justify">
- <input name="date" type="text" id="date">
- </div></td>
- <td> </td>
- </tr>
- <tr>
- <td><div align="justify">Destination</div></td>
- <td><div align="justify">:</div></td>
- <td><div align="justify">
- <input name="destination" type="text" id="destination">
- </div></td>
- <td> </td>
- </tr>
- <tr>
- <td>Expected Activities</td>
- <td>:</td>
- <td><input name="expected_activities" type="text" id="expected_activities"></td>
- <td><div align="left">
- <input type="submit" name="submit_add" value="Add">
- </div></td>
- </tr>
- </table>
- <?
- $level = $_SESSION['level'];
- $ic = $_SESSION['ic'];
- $result_data = mysql_query("SELECT * FROM sementara_travel where ic = '$ic' and category = 'customer' order by name_customer ASC")
- or die (mysql_error());
- $row_data = mysql_num_rows ($result_data);
- if($row_data !=0){
- echo "<table border = 1>";
- echo "<tr> <th> Name Of Customer </th> <th> Date </th> <th> Destination </th> <th> Expected Activities </th>";
- while ($row_data = mysql_fetch_array($result_data, MYSQL_ASSOC))
- {
- echo "<tr>";
- echo "<td>".$row_data['name_customer']."</td>";
- echo "<td>".$row_data['date']."</td>";
- echo "<td>".$row_data['destination']."</td>";
- echo "<td>".$row_data['expected_activities']."</td>";
- echo "<td> <a href='travel.php?item=delete&id=".$row_data['id']."'>Delete </a></td>";
- echo "</tr>";
- }
- echo "</table>";
- }
- ?>
- </td>
- </tr>
- </table>
- <table width="95%" border="1">
- <tr>
- <td height="286" colspan="3"><table width="75%" border="1">
- <tr>
- <td colspan="3"><div align="justify">Accommodation Plan</div></td>
- </tr>
- </table>
- <table width="75%" border="1">
- <tr>
- <td width="33%"><input type="radio" name="name_accommodation" value="hotel" <?php echo ($name_accommodation== "hotel")? 'checked':''; ?>>
- Hotel</td>
- <td width="2%"> </td>
- <td width="65%"> </td>
- </tr>
- <tr>
- <td><input type="radio" name="name_accommodation" value="self" <?php echo ($name_accommodation== "self")? 'checked':''; ?>>
- Self Accommodation</td>
- <td> </td>
- <td> </td>
- </tr>
- <tr>
- <td><input type="radio" name="name_accommodation" value="others"<?php echo ($name_accommodation== "others")? 'checked':''; ?>>
- Others</td>
- <td> </td>
- <td> </td>
- </tr>
- </table>
- <table width="75%" border="1">
- <tr>
- <td colspan="3">For Hotel Accommodation</td>
- </tr>
- </table>
- <table width="88%" border="1">
- <tr>
- <td width="24%">Name Of Hotel</td>
- <td width="2%">:</td>
- <td width="30%"><input type="text" name="name_hotel" id="name_hotel"></td>
- <td width="44%"> </td>
- </tr>
- <tr>
- <td>Accommodation Date</td>
- <td>:</td>
- <td><input type="text" name="accommodation_date" id="accommodation_date"></td>
- <td> </td>
- </tr>
- <tr>
- <td>To</td>
- <td>:</td>
- <td><label>
- <input type="text" name="to_date_hotel" id="to_date_hotel">
- </label></td>
- <td> </td>
- </tr>
- <tr>
- <td>Type Of Room</td>
- <td>:</td>
- <td><input type="text" name="type_room" id="type_room"></td>
- <td><div align="left">
- <input type="submit" name="submit_hotel" value="Add">
- </div></td>
- </tr>
- </table>
- <?
- $level = $_SESSION['level'];
- $ic = $_SESSION['ic'];
- $result_data = mysql_query("SELECT * FROM sementara_travel where ic = '$ic' and category = 'hotel' order by
- name_hotel ASC")
- or die (mysql_error());
- $row_data = mysql_num_rows ($result_data);
- if($row_data !=0){
- echo "<table border = 1>";
- echo "<tr> <th> Name Of Hotel </th> <th> Accommodation Date </th> <th> To </th> <th> Type Of Room </th>";
- while ($row_data = mysql_fetch_array($result_data, MYSQL_ASSOC))
- {
- echo "<tr>";
- echo "<td>".$row_data['name_hotel']."</td>";
- echo "<td>".$row_data['accommodation_date']."</td>";
- echo "<td>".$row_data['to_date_hotel']."</td>";
- echo "<td>".$row_data['type_room']."</td>";
- echo "<td> <a href='travel.php?item=delete&id=".$row_data['id']."'>Delete </a></td>";
- echo "</tr>";
- }
- echo "</table>";
- }
- ?>
- </td>
- </tr>
- </table>
- <table width="95%" border="1">
- <tr>
- <td height="793" colspan="3" valign="top"><table width="75%" border="1">
- <tr>
- <td colspan="3">Travel Plan</td>
- </tr>
- </table>
- <table width="97%" border="1">
- <tr>
- <td width="15%">Mode Of Travel</td>
- <td width="1%">:</td>
- <td width="15%"><select name="name_travel" onChange="display(this,'class_travel','date_needed');">
- <option>Please select:</option>
- <option value="class_travel">Flight</option>
- <option value="date_needed">Company Car</option>
- <option value="date_needed">Own Car</option>
- <option value="date_needed">Bus</option>
- <option value="invisible">Invisible</option>
- </select></td>
- </tr>
- <tbody id="class_travel" style="display: none;">
- <tr>
- <td>Class Of Travel</td>
- <td>:</td>
- <td><label>
- <input type="text" name="class_travel" id="class_travel">
- </label></td>
- </tr>
- <tr>
- <td>Type Of Flight</td>
- <td>:</td>
- <td><label>
- <select name="type_flight" id="type_flight">
- <option selected>-</option>
- <option>AirAsia</option>
- <option>Malaysia Airlines</option>
- <option>Firefly</option>
- </select>
- </label></td>
- </tr>
- <tr>
- <td>Departure Date</td>
- <td>:</td>
- <td><label>
- <input type="text" name="departure_date" id="departure_date">
- </label></td>
- </tr>
- <tr>
- <td>From</td>
- <td>:</td>
- <td><select name="from" id="from">
- <option selected>-</option>
- <option>Kuala Lumpur</option>
- <option>Kuantan</option>
- </select>
- </td>
- </tr>
- <tr>
- <td>To</td>
- <td>:</td>
- <td><label>
- <select name="to" id="to">
- <option selected>-</option>
- <option>Kuantan</option>
- <option>Kuala Lumpur</option>
- </select>
- </label></td>
- </tr>
- <tr>
- <td>Estimated Time Of Departure</td>
- <td>:</td>
- <td><input type="text" name="time_departure" id="time_departure"></td>
- </tr>
- <tr>
- <td>Estimated Time Of Arrival</td>
- <td>:</td>
- <td><input type="text" name="time_arrival" id="time_arrival"></td>
- </tr>
- <tr>
- <td>Return Date</td>
- <td>:</td>
- <td><label>
- <input type="text" name="return_date" id="return_date">
- </label></td>
- </tr>
- <tr>
- <td>From</td>
- <td>:</td>
- <td><label>
- <select name="from1" id="from1">
- <option selected>-</option>
- <option>Kalimantan</option>
- <option>Kuantan</option>
- </select>
- </label></td>
- </tr>
- <tr>
- <td>To</td>
- <td>:</td>
- <td><select name="to1" id="to1">
- <option selected>-</option>
- <option>Kuantan</option>
- <option>Kuala Terengganu</option>
- </select>
- </td>
- </tr>
- <tr>
- <td>Estimated Time Of Departure</td>
- <td>:</td>
- <td><input type="text" name="estimated_departure" id="estimated_departure"></td>
- </tr>
- <tr>
- <td>Estimated Time Of Arrival</td>
- <td>:</td>
- <td><input type="text" name="estimated_arrival" id="estimated_arrival"></td>
- </tr>
- <tbody id="date_needed" style="display: none;">
- <tr>
- <td>Date Needed</td>
- <td>:</td>
- <td><input type="text" name="date_needed" id="date_needed"></td>
- </tr>
- <tr>
- <td>To</td>
- <td>:</td>
- <td><label>
- <input type="text" name="to2" id="to2">
- </label></td>
- </tr>
- <tr>
- <td>Period</td>
- <td>:</td>
- <td><input type="text" name="period" id="period"></td>
- </tr>
- <tr>
- <td>Start</td>
- <td>:</td>
- <td><input type="text" name="start" id="start"></td>
- </tr>
- <tr>
- <td>To</td>
- <td>:</td>
- <td><input type="text" name="to_start" id="to_start"></td>
- </tr>
- <tr>
- <td>Purpose</td>
- <td>:</td>
- <td><input type="text" name="purpose" id="purpose"></td>
- </tr>
- <tr>
- <td>Destination</td>
- <td>:</td>
- <td><input type="text" name="destination_car" id="destination_car"></td>
- </tr>
- <tr>
- <td>Driver</td>
- <td>:</td>
- <td><select name="driver" id="driver">
- <option selected>-</option>
- <option>Own Car</option>
- </select>
- </td>
- </tr>
- <tr>
- <td>Pick Up From</td>
- <td>:</td>
- <td><input type="text" name="pick_up" id="pick_up"></td>
- </tr>
- <tr>
- <td>Departure Date</td>
- <td>:</td>
- <td><input type="text" name="date_departure" id="date_departure"></td>
- </tr>
- <tr>
- <td>From</td>
- <td>:</td>
- <td><select name="from_date" id="from_date">
- <option selected>-</option>
- <option>Kelana Jaya Medical Centre</option>
- <option>KJMC</option>
- </select>
- </td>
- </tr>
- <tr>
- <td>To</td>
- <td>:</td>
- <td><select name="to_date" id="to_date">
- <option selected>-</option>
- <option>Kuala Terengganu</option>
- </select>
- </td>
- </tr>
- <tr>
- <td>Estimated Time Of Departure</td>
- <td>:</td>
- <td><input type="text" name="time_departure_car" id="time_departure_car"></td>
- </tr>
- <tr>
- <td>Estimated time Of Arrival</td>
- <td>:</td>
- <td><input type="text" name="time_arrival_car" id="time_arrival_car"></td>
- </tr>
- </table></td>
- </tr>
- </table>
- <table width="200" border="1" align="left">
- <tr>
- <th scope="col"><label>
- <div align="left">
- <input type="submit" name="submit_preview" id="Preview" value="Preview">
- </div>
- </label></th>
- </tr>
- </table></th>
- </tr>
- </table>
- </form>
- <?
- mysql_close();
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement