| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/(Del)pathways.org.hk/MIS_bk/area/ |
Upload File : |
<?php
require_once(__DIR__ . '/../checkuser.php');
function form() {
global $dbh;
$area = array(
'actived' => 1,
'deleted' => 0,
);
$id = isset($_GET['id']) ? $_GET['id'] : null;
if (!empty($id)) {
$sql = "SELECT * FROM mis_area WHERE id = ? AND deleted = ?";
$parameters = array($id, 0);
$sth = Db\Util::execute($dbh, $sql, $parameters);
$area = $sth->fetch(PDO::FETCH_ASSOC);
}
if (isPost()) {
$area = array_merge($area, $_POST['area']);
if (empty($area['id'])) {
// Get max sort
$sql = "SELECT MAX(sort) AS max_sort FROM mis_area WHERE actived = ? AND deleted = ?";
$parameters = array(1, 0);
$sth = Db\Util::execute($dbh, $sql, $parameters);
$record = $sth->fetch(PDO::FETCH_ASSOC);
// Assign sort
$area['sort'] = $record['max_sort'] + 1;
// Save
$area['id'] = Db\Util::create($dbh, 'mis_area', $area);
} else {
// Save
Db\Util::update($dbh, 'mis_area', $area);
}
$data = array(
'message' => 'Saved',
);
redirectAndExit(Util::link(__DIR__ . '/index.php') . '?' . http_build_query($data));
}
return array(
'area' => $area,
);
}
extract(form());
?><!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php require(__DIR__ . '/../inc/_head_meta.php'); ?>
<?php require(__DIR__ . '/../inc/_head_css.php'); ?>
<?php require(__DIR__ . '/../inc/_head_script.php'); ?>
</head>
<body>
<?php require( __DIR__ . '/../inc/_navbar.php'); ?>
<div class="text-right">
<ul class="breadcrumb">
<li><a href="#">Master</a> <span class="divider">></span></li>
<li class="active">Area</li>
</ul>
</div>
<div class="container-fluid pathways-container">
<h3><?=empty($area['id']) ? 'Add' : 'Modify'?> Area</h3>
<form id="form" class="form-horizontal" method="post">
<?php $attribute = 'id'; ?>
<input type="hidden" name="area[<?=$attribute?>]" value="<?=h($area[$attribute])?>" />
<div class="control-group">
<?php $attribute = 'title'; $label = 'Name'; ?>
<label class="control-label" for="<?=$attribute?>"><?=$label?></label>
<div class="controls">
<input type="text" id="<?=$attribute?>" name="area[<?=$attribute?>]" class="required" value="<?=h($area[$attribute])?>" placeholder="<?=h($label)?>" maxlength="200" />
</div>
</div>
<div class="control-group">
<div class="controls">
<button type="submit" class="btn btn-danger">Save</button>
</div>
</div>
</form>
<script type="text/javascript">
$(function() {
$('#form').validate();
});
</script>
<?php require( __DIR__ . '/../inc/_footer.php'); ?>
</div> <!-- /container -->
</body>
</html>