session_start();
if (!isset($_GET['hospital_id'])) {
header("Location: index.php");
exit;
}
include 'php/config/autoload.inc.php';
use classes as cls;
use config as cfg;
$db = new cfg\database();
$ht = new cls\hospitals();
$pv = new cls\provinces();
$data = $ht->get_hospital_detail_by_id($_GET['hospital_id']);
// print_r($data);
$province = $pv->get_province($data['province']);
$amphur = $pv->get_amphur($data['amphur']);
$district = $pv->get_district($data['district']);
/*
Array
(
[hospital_id] => 1
[hospital_verify_code] => กก11021จ
[hospital_name] => ค่ายสรรพสิทธิประสงค์
[hospital_address] => 383 หมู่ 2 ถ.สถิตย์นิมานกาล
[province] => 1
[amphur] => 4
[district] => 31
[zipcode] => 34190
[lat] => 15.1939973
[lng] => 104.8732654
[tel] => 045-3211735
[email] => thongtank@hotmail.com
<tr>
<th>ใบอนุญาติ</th>
<th>ชื่อ</th>
<th>ที่ตั้ง</th>
<th colspan="2">จัดการ</th>
</tr>
<?php
$sql = "select * from hospital order by hospital_id DESC limit 5;";
$result = $db->query($sql, $rows, $num_rows);
if ($result) {
foreach ($rows as $k => $v) {
$province = $pv->get_province($v['province']);
$provine_name = $province[0]['PROVINCE_NAME'];
$amphur = $pv->get_amphur($v['amphur']);
$amphur_name = $amphur[0]['AMPHUR_NAME'];
$district = $pv->get_district($v['district']);
$district_name = $district[0]['DISTRICT_NAME'];
print "\n <tr>\n <td>" . $v['hospital_verify_code'] . "</td>\n <td>โรงพยาบาล" . $v['hospital_name'] . "</td>\n <td>\n " . $v['hospital_address'] . " อำเภอ" . $amphur_name . " ตำบล" . $district_name . " จังหวัด" . $provine_name . $v['zipcode'] . "\n </td>\n <td><a href='delete-hospital.php?id=" . $v['hospital_id'] . "' onclick='return confirm(\"ยืนยันการลบข้อมูล ?\");'><i class='fa fa-trash-o'></i></a></td>\n <td><a href='edit-hospital.php?id=" . $v['hospital_id'] . "'><i class='fa fa-pencil'></i></a></td>\n </tr>\n ";
}
}
$result = null;
$rows = null;
$num_rows = null;
?>
</table>
</div>
<div class="panel-footer text-right">
<a href="list-hospital.php">โรงพยาบาลทั้งหมด</a>
</div>
</div>
</div>
<span id="amphur-helpBox" class="help-block">อำเภอเดิมคือ <?php
echo $amphur[0]['AMPHUR_NAME'];
?>
</span>
<input type="hidden" name="hidden_amphur_id" value="<?php
echo $amphur[0]['AMPHUR_ID'];
?>
">
</div>
</div>
<div class="form-group">
<label for="district" class="control-label col-md-4">ตำบล</label>
<div class="col-md-8">
<?php
$pv = new cls\provinces();
$district = $pv->get_district($data['company_district']);
?>
<select name="district" id="district" class="form-control" aria-describedby="district-helpBox">
<option value="">เลือกตำบล</option>
</select>
<span id="district-helpBox" class="help-block">ตำบลเดิมคือ <?php
echo $district[0]['DISTRICT_NAME'];
?>
</span>
<input type="hidden" name="hidden_district_id" value="<?php
echo $district[0]['DISTRICT_ID'];
?>
">
</div>
</div>
<div class="form-group">
</select>
<span id="amphur-helpBox" class="help-block">อำเภอเดิมคือ <?php
echo $amphur[0]['AMPHUR_NAME'];
?>
</span>
<input type="hidden" name="hidden_amphur_id" value="<?php
echo $amphur[0]['AMPHUR_ID'];
?>
">
</div>
</div>
<div class="form-group">
<label for="district" class="control-label col-md-4">ตำบล</label>
<div class="col-md-8">
<?php
$district = $pv->get_district($_SESSION['profile_detail']['district']);
?>
<select name="district" id="district" class="form-control" aria-describedby="district-helpBox">
<option value="">เลือกตำบล</option>
</select>
<span id="district-helpBox" class="help-block">ตำบลเดิมคือ <?php
echo $district[0]['DISTRICT_NAME'];
?>
</span>
<input type="hidden" name="hidden_district_id" value="<?php
echo $district[0]['DISTRICT_ID'];
?>
">
</div>
</div>
<div class="form-group">
