<?php
include('koneksi.php');

$query = "select * from download where id = '$_GET[id]'";
$result = mysql_query($query);
$data = mysql_fetch_array($result);

?>
<form action="download_ubah_query.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="id" value="<?php echo $data['id']; ?>" />
<table width="100%" align="center" border="0" bgcolor="#eee" cellpadding="2" cellspacing="0">
<tr>
<td><b>Tanggal Claim</b></td><td> </td><td><input type="text" class="form-control" name="tanggal_claim" value="<?php echo $data['tanggal_claim']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>Claim OLO</b></td><td> </td><td><input type="text" class="form-control" name="claim_olo" value="<?php echo $data['claim_olo']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>Detail Claim</b></td><td> </td><td><textarea class="form-control" name="detail_claim" rows="3" value="<?php echo $data['detail_claim'] ; ?>" /></textarea></td>
<td> </td>
</tr>
<tr>
<td><b>Customer</b></td><td> </td><td><input type="text" class="form-control" name="customer" value="<?php echo $data['customer']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>No ADSL / Link</b></td><td> </td><td><input type="text" class="form-control" name="no_adsl" value="<?php echo $data['no_adsl']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>Id Trans</b></td><td> </td><td><input type="text" class="form-control" name="id_trans" value="<?php echo $data['id_trans']; ?>" readonly="true" /></td>
<td> </td>
</tr>
<tr>
<td><b>AO MO DO</b></td><td> </td><td><input type="text" class="form-control" name="aomodo" value="<?php echo $data['aomodo']; ?>" /></td>
<td> </td>
</tr>
<tr>
<td><b>Konfirmasi Awal</b></td><td> </td><td><textarea class="form-control" name="kofirmasi_awal" rows="3" value="<?php echo $data['kofirmasi_awal']; ?>" /></textarea></td>
<td> </td>
</tr>
<tr>
<td><b>Hasil RAM</b></td><td> </td><td><input type="text" class="form-control" name="hasil_ram" value="<?php echo $data['hasil_ram']; ?>" /></td>
<td> </td>
</tr>
<tr>
<td><b>Status</b></td><td> </td>
<td>
<select name="status" class="form-control" id="status">
<?php
if ($data['status']=="OPEN"){
$pilih_open = "selected";
}else if($data['status']=="IN_PROGRESS"){
$pilih_in_progress = "selected";
}else if($data['status']=="CLOSED"){
$pilih_closed = "selected";
}
?>
<option value="OPEN"<?php echo $pilih_open ?>>OPEN</option>
<option value="IN_PROGRESS"<?php echo $pilih_in_progress ?>>IN PROGRESS</option>
<option value="CLOSED"<?php echo $pilih_closed ?>>CLOSED</option>
</select></td>
<td> </td>
</tr>
<tr>
<td><b>Keterangan</b></td><td> </td><td><input type="text" class="form-control" name="keterangan" value="<?php echo $data['keterangan']; ?>" /></td>
<td> </td>
</tr>
<tr>
<td><b>Nama File</b></td><td> </td><td><input type="text" class="form-control" name="nama" value="<?php echo $data['nama_file']; ?>" readonly="true" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><div class="alert alert-info" role="alert">*Upload ukuran file maksimal 2 Mb !</div></td>
</tr>
<tr>
<td><b>Pilih File</b></td><td> </td><td><input type="file" class="#" name="file" value="<?php echo $data['file']; ?>" readonly="true" /></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td><td> </td><td><input type="submit" class="btn btn-info" name="update" value="Update" /></td>
</tr>
</table>
</form>

<?php
include("koneksi.php");
if (isset($_POST['update'])) {
$id = $_GET['id'];
$query = "(update download set id_trans = '$_POST[id_trans]',
tanggal = '$_POST[tanggal]',
claim_olo = '$_POST[claim_olo]',
detail_claim = '$_POST[detail_claim]',
customer = '$_POST[customer]',
no_adsl = '$_POST[no_adsl]',
aomodo = '$_POST[aomodo]',
kofirmasi_awal = '$_POST[kofirmasi_awal]',
hasil_ram = '$_POST[hasil_ram]',
status = '$_POST[status]',
keterangan = '$_POST[keterangan]',
where id = '$_POST[id]')";
$result = mysql_query($query);
if($result){
header("location:view_tables.php");
}else{
echo '<div class="error">ERROR: Gagal update file! <meta http-equiv="refresh" content="5; url=./tables_view.php"></div>';
}
}
?>