286 lines
15 KiB
PHP
286 lines
15 KiB
PHP
|
<!DOCTYPE html>
|
||
|
|
<html>
|
||
|
|
|
||
|
|
<head>
|
||
|
|
<?php
|
||
|
|
include 'header.php';
|
||
|
|
include 'config.php';
|
||
|
|
?>
|
||
|
|
|
||
|
|
<style>
|
||
|
|
/* Add custom styles for the panel body */
|
||
|
|
.panel-body {
|
||
|
|
overflow-x: auto;
|
||
|
|
}
|
||
|
|
</style>
|
||
|
|
</head>
|
||
|
|
<?php
|
||
|
|
if (isset($_GET['urole'])) {
|
||
|
|
$urole = $_GET['urole'];
|
||
|
|
$arole = $_GET['arole'];
|
||
|
|
$rrole = $_GET['rrole'];
|
||
|
|
$arole2 = $_GET['arole2'];
|
||
|
|
$arole3 = $_GET['arole3'];
|
||
|
|
$arole4 = $_GET['arole4'];
|
||
|
|
$sql = "UPDATE setup SET urole=$urole, arole=$arole, rrole=$rrole, arole2=$arole2, arole3=$arole3, arole4=$arole4";
|
||
|
|
$result = $conn->query($sql);
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
|
||
|
|
<body class="dt-example dt-example-bootstrap" style="background-color: rgba(0, 0, 0, 0);">
|
||
|
|
<div class="container">
|
||
|
|
<div class="row">
|
||
|
|
<div class="col-sm-2"> </div>
|
||
|
|
<div class="col-sm-8">
|
||
|
|
<div class="panel-group">
|
||
|
|
<div class="panel panel-default">
|
||
|
|
<div class="panel-heading">
|
||
|
|
<h4 class="panel-title">
|
||
|
|
<a data-toggle="collapse" href="#collapse1">Workflow</a>
|
||
|
|
</h4>
|
||
|
|
</div>
|
||
|
|
<div id="collapse1" class="panel-collapse collapse">
|
||
|
|
<div class="panel-body">
|
||
|
|
<form action="setup.php">
|
||
|
|
<div class="form-group">
|
||
|
|
<label for="urole">Uploader:</label>
|
||
|
|
<select class="form-control" id="urole" name="urole">
|
||
|
|
<?php
|
||
|
|
$sql = "SELECT * FROM roles where code LIKE '%1%'";
|
||
|
|
$result = $conn->query($sql);
|
||
|
|
if ($result->num_rows > 0) {
|
||
|
|
// output data of each row
|
||
|
|
while ($row = $result->fetch_assoc()) {
|
||
|
|
echo "<option value='" . $row['id'];
|
||
|
|
if ($urole == $row['id']) {
|
||
|
|
echo "' selected>";
|
||
|
|
} else {
|
||
|
|
echo "'>";
|
||
|
|
}
|
||
|
|
echo $row['name'] . "</option>";
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
echo "0 results";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</select>
|
||
|
|
</div>
|
||
|
|
<div class="form-group">
|
||
|
|
<label for="arole">Approver:</label>
|
||
|
|
<select class="form-control" id="arole" name="arole">
|
||
|
|
<?php
|
||
|
|
$sql = "SELECT * FROM roles where code LIKE '%2%'";
|
||
|
|
$result = $conn->query($sql);
|
||
|
|
if ($result->num_rows > 0) {
|
||
|
|
// output data of each row
|
||
|
|
while ($row = $result->fetch_assoc()) {
|
||
|
|
echo "<option value='" . $row['id'];
|
||
|
|
if ($arole == $row['id']) {
|
||
|
|
echo "' selected>";
|
||
|
|
} else {
|
||
|
|
echo "'>";
|
||
|
|
}
|
||
|
|
echo $row['name'] . "</option>";
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
echo "0 results";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</select>
|
||
|
|
</div>
|
||
|
|
<div class="form-group">
|
||
|
|
<label for="arole2">Approver Level 2:</label>
|
||
|
|
<select class="form-control" id="arole2" name="arole2">
|
||
|
|
<?php
|
||
|
|
$sql = "SELECT * FROM roles where code LIKE '%2%'";
|
||
|
|
$result = $conn->query($sql);
|
||
|
|
if ($result->num_rows > 0) {
|
||
|
|
// output data of each row
|
||
|
|
while ($row = $result->fetch_assoc()) {
|
||
|
|
echo "<option value='" . $row['id'];
|
||
|
|
if ($arole2 == $row['id']) {
|
||
|
|
echo "' selected>";
|
||
|
|
} else {
|
||
|
|
echo "'>";
|
||
|
|
}
|
||
|
|
echo $row['name'] . "</option>";
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
echo "0 results";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</select>
|
||
|
|
</div>
|
||
|
|
<div class="form-group">
|
||
|
|
<label for="arole3">Approver Level 3:</label>
|
||
|
|
<select class="form-control" id="arole3" name="arole3">
|
||
|
|
<?php
|
||
|
|
$sql = "SELECT * FROM roles where code LIKE '%2%'";
|
||
|
|
$result = $conn->query($sql);
|
||
|
|
if ($result->num_rows > 0) {
|
||
|
|
// output data of each row
|
||
|
|
while ($row = $result->fetch_assoc()) {
|
||
|
|
echo "<option value='" . $row['id'];
|
||
|
|
if ($arole3 == $row['id']) {
|
||
|
|
echo "' selected>";
|
||
|
|
} else {
|
||
|
|
echo "'>";
|
||
|
|
}
|
||
|
|
echo $row['name'] . "</option>";
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
echo "0 results";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</select>
|
||
|
|
</div>
|
||
|
|
<div class="form-group">
|
||
|
|
<label for="arole4">Approver Level 4:</label>
|
||
|
|
<select class="form-control" id="arole4" name="arole4">
|
||
|
|
<?php
|
||
|
|
$sql = "SELECT * FROM roles where code LIKE '%2%'";
|
||
|
|
$result = $conn->query($sql);
|
||
|
|
if ($result->num_rows > 0) {
|
||
|
|
// output data of each row
|
||
|
|
while ($row = $result->fetch_assoc()) {
|
||
|
|
echo "<option value='" . $row['id'];
|
||
|
|
if ($arole4 == $row['id']) {
|
||
|
|
echo "' selected>";
|
||
|
|
} else {
|
||
|
|
echo "'>";
|
||
|
|
}
|
||
|
|
echo $row['name'] . "</option>";
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
echo "0 results";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</select>
|
||
|
|
</div>
|
||
|
|
<div class="form-group">
|
||
|
|
<label for="rrole">Releasing:</label>
|
||
|
|
<select class="form-control" id="rrole" name="rrole">
|
||
|
|
<?php
|
||
|
|
$sql = "SELECT * FROM roles where code LIKE '%3%'";
|
||
|
|
$result = $conn->query($sql);
|
||
|
|
if ($result->num_rows > 0) {
|
||
|
|
// output data of each row
|
||
|
|
while ($row = $result->fetch_assoc()) {
|
||
|
|
echo "<option value='" . $row['id'];
|
||
|
|
if ($rrole == $row['id']) {
|
||
|
|
echo "' selected>";
|
||
|
|
} else {
|
||
|
|
echo "'>";
|
||
|
|
}
|
||
|
|
echo $row['name'] . "</option>";
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
echo "0 results";
|
||
|
|
}
|
||
|
|
$conn->close();
|
||
|
|
?>
|
||
|
|
</select>
|
||
|
|
</div>
|
||
|
|
<button type="submit" class="btn btn-default">Save</button>
|
||
|
|
</form>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div class="panel-group">
|
||
|
|
<div class="panel panel-default">
|
||
|
|
<div class="panel-heading">
|
||
|
|
<h4 class="panel-title">
|
||
|
|
<a data-toggle="collapse" href="#collapse2">Document Types</a>
|
||
|
|
</h4>
|
||
|
|
</div>
|
||
|
|
<div id="collapse2" class="panel-collapse collapse">
|
||
|
|
<div class="panel-body">
|
||
|
|
<?php include 'dtype_list.php'; ?>
|
||
|
|
</div>
|
||
|
|
<!-- <div class="panel-footer">Panel Footer</div> -->
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div class="panel-group">
|
||
|
|
<div class="panel panel-default">
|
||
|
|
<div class="panel-heading">
|
||
|
|
<h4 class="panel-title">
|
||
|
|
<a data-toggle="collapse" href="#collapse3">Companies</a>
|
||
|
|
</h4>
|
||
|
|
</div>
|
||
|
|
<div id="collapse3" class="panel-collapse collapse">
|
||
|
|
<div class="panel-body">
|
||
|
|
<?php include 'company_list.php'; ?>
|
||
|
|
</div>
|
||
|
|
<!-- <div class="panel-footer">Panel Footer</div> -->
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div class="panel-group">
|
||
|
|
<div class="panel panel-default">
|
||
|
|
<div class="panel-heading">
|
||
|
|
<h4 class="panel-title">
|
||
|
|
<a data-toggle="collapse" href="#collapse4">Departments</a>
|
||
|
|
</h4>
|
||
|
|
</div>
|
||
|
|
<div id="collapse4" class="panel-collapse collapse">
|
||
|
|
<div class="panel-body">
|
||
|
|
<?php include 'department_list.php'; ?>
|
||
|
|
</div>
|
||
|
|
<!-- <div class="panel-footer">Panel Footer</div> -->
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div class="panel-group">
|
||
|
|
<div class="panel panel-default">
|
||
|
|
<div class="panel-heading">
|
||
|
|
<h4 class="panel-title">
|
||
|
|
<a data-toggle="collapse" href="#collapse5">Roles</a>
|
||
|
|
</h4>
|
||
|
|
</div>
|
||
|
|
<div id="collapse5" class="panel-collapse collapse">
|
||
|
|
|
||
|
|
<div class="panel-body">
|
||
|
|
<div>
|
||
|
|
<h4>CODE</h4>
|
||
|
|
<strong>Uploader = 1,</strong>
|
||
|
|
<strong>Approver = 2,</strong>
|
||
|
|
<strong>Releaser = 3</strong>
|
||
|
|
</div>
|
||
|
|
<br>
|
||
|
|
<?php include 'role_list.php'; ?>
|
||
|
|
</div>
|
||
|
|
<!-- <div class="panel-footer">Panel Footer</div> -->
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
|
||
|
|
<div class="panel-group">
|
||
|
|
<div class="panel panel-default">
|
||
|
|
<div class="panel-heading">
|
||
|
|
<h4 class="panel-title">
|
||
|
|
<a data-toggle="collapse" href="#collapse6">Users</a>
|
||
|
|
</h4>
|
||
|
|
</div>
|
||
|
|
<div id="collapse6" class="panel-collapse collapse">
|
||
|
|
|
||
|
|
<div class="panel-body">
|
||
|
|
<br>
|
||
|
|
<?php include 'users_list.php'; ?>
|
||
|
|
</div>
|
||
|
|
<!-- <div class="panel-footer">Panel Footer</div> -->
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-2"> </div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
|
||
|
|
</html>
|