96 lines
4.4 KiB
PHP
96 lines
4.4 KiB
PHP
|
<!DOCTYPE html>
|
||
|
|
<html>
|
||
|
|
|
||
|
|
<head>
|
||
|
|
<?php
|
||
|
|
include '../header.php';
|
||
|
|
include '../config.php';
|
||
|
|
$role = $_GET['role'];
|
||
|
|
$user_id = $_GET['user_id'];
|
||
|
|
$doc_id = $_GET['doc_id'];
|
||
|
|
$sql = "SELECT documents.id,documents.number,type.name as doc_type,
|
||
|
|
documents.description,department.name as department,company.name as company,
|
||
|
|
city.name as city,province.name as province
|
||
|
|
FROM documents
|
||
|
|
LEFT JOIN type on type.id = documents.type
|
||
|
|
LEFT JOIN department on department.id = documents.department
|
||
|
|
LEFT JOIN company on company.id = documents.company
|
||
|
|
LEFT JOIN city on city.id = documents.city
|
||
|
|
LEFT JOIN province on province.id = documents.province
|
||
|
|
WHERE documents.id=$doc_id;";
|
||
|
|
$result = $conn->query($sql);
|
||
|
|
$row = $result->fetch_assoc();
|
||
|
|
$doc_no = $row['number'];
|
||
|
|
$doc_type = $row['doc_type'];
|
||
|
|
$description = $row['description'];
|
||
|
|
$department = $row['department'];
|
||
|
|
$company = $row['company'];
|
||
|
|
$city = $row['city'];
|
||
|
|
$province = $row['province'];
|
||
|
|
$requestor = $row['name'];
|
||
|
|
if(isset($_GET['reason'])){
|
||
|
|
$rtype = $_GET['rtype'];
|
||
|
|
$reason = $_GET['reason'];
|
||
|
|
$rsql = "SELECT * FROM vault_users WHERE id=$user_id";
|
||
|
|
$rresult = $conn->query($rsql);
|
||
|
|
$rrow = $rresult->fetch_assoc();
|
||
|
|
$user_name = $rrow['name'];
|
||
|
|
$user_company = $rrow['company'];
|
||
|
|
$isql = "INSERT INTO request (type, reason, document, user_id, name, company) VALUES ($rtype,'$reason',$doc_id,$user_id,'$user_name',$user_company)";
|
||
|
|
$iresult = $conn->query($isql);
|
||
|
|
//$irow = $iresult->fetch_assoc();
|
||
|
|
//header("Location: ../index.php?role=$role&user_id=$user_id");
|
||
|
|
header("Location: create.php?doc_id=$doc_id&user_id=$user_id");
|
||
|
|
exit();
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</head>
|
||
|
|
|
||
|
|
<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-3"> </div>
|
||
|
|
<div class="col-sm-6">
|
||
|
|
<div class="panel panel-default">
|
||
|
|
<div class="panel-heading">Document Request</div>
|
||
|
|
<div class="panel-body">
|
||
|
|
<form action="request.php">
|
||
|
|
<div class="form-group">
|
||
|
|
<label for="rtype">Request Type:</label>
|
||
|
|
<select class="form-control" id="rtype" name="rtype">
|
||
|
|
<option value="0">View</option>
|
||
|
|
<option value="1">Copy</option>
|
||
|
|
<option value="2">Original Copy</option>
|
||
|
|
</select>
|
||
|
|
</div>
|
||
|
|
<div class="form-group">
|
||
|
|
<label for="reason">Reason:</label>
|
||
|
|
<textarea class="form-control" rows="5" id="reason" name="reason" required></textarea>
|
||
|
|
</div>
|
||
|
|
<input type="hidden" name="doc_id" value="<?php echo $doc_id; ?>" />
|
||
|
|
<input type="hidden" name="user_id" value="<?php echo $user_id; ?>" />
|
||
|
|
<div class="well">
|
||
|
|
<?php
|
||
|
|
echo "Doc. ID: ".$doc_id."<br>";
|
||
|
|
echo "Doc. No.: ".$doc_no."<br>";
|
||
|
|
echo "Doc. Type: ".$doc_type."<br>";
|
||
|
|
echo "Description: ".$description."<br>";
|
||
|
|
echo "City: ".$city."<br>";
|
||
|
|
echo "Province: ".$province."<br>";
|
||
|
|
echo "Department: ".$department."<br>";
|
||
|
|
echo "Document Company: ".$company."<br>";
|
||
|
|
$conn->close();
|
||
|
|
?>
|
||
|
|
</div>
|
||
|
|
<button type="submit" class="btn btn-default">Submit</button>
|
||
|
|
<button class="btn btn-default" onclick="history.back()">Cancel</button>
|
||
|
|
</form>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div class="col-sm-3"> </div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
|
||
|
|
</html>
|