<html>
<head>
<title style="color: GREEN;">GCC/5-Marla Exective Details</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/css/bootstrap.min.css" integrity="sha384-TX8t27EcRE3e/ihU7zmQxVncDAy5uIKz4rEkgIXeMed4M0jlfIDPvg6uqKI2xXr2" crossorigin="anonymous">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Raleway">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="bootstrap.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<style>
table {
font-family: arial, sans-serif;
border-collapse: collapse;
width: 100%;
}
td, th {
border: 1px solid #dddddd;
text-align: center;
padding: 8px;
}
tr:nth-child(even) {
background-color: #dddddd;
text-decoration: bold;
}
th {
border: 1px solid #dddddd;
text-align: center;
padding: 8px;
background-color: black;
color: white;
}
.start{
text-align: center;
}
.button a{
color: white;
text-decoration: none;
}
button {
border-radius: 10px;
border: 4px solid #f90d53;
font-size: 28px;
padding: 20px;
width: 150px;
cursor: pointer;
margin-top: 20px;
margin-left: 40%;
margin-bottom: 20px;
}
.image-div{
width: 40%;
float: left;
}
.detail-div{
width: 400px;
height: 500px;
display: flex;
}
.an:hover{
background: #f90D53;
cursor: pointer;
color: white;
}
.an{
border:2px solid ;
border-radius: 10px;
color: #f90D53;
width: 20%;
}
</style>
</head>
<body>
<!-- Header start -->
<?php
// Navigation
require_once("includes/navbar.php");
require_once("includes/connection.php");
?>
<!--cost table start-->
<section style="margin-top: 104px;">
<?php
$select_project = "SELECT * FROM project WHERE project_id = '$_GET[project_id]'";
$run_project = mysqli_query($con, $select_project);
$project_data = mysqli_fetch_array($run_project);
$project_title = $project_data['title'];
$project_type = $project_data['type'];
$p_size = $project_data['p_size'];
?>
<h2 class="start"><?php echo $project_title." - ".$project_type;?></h2>
<h3 class="start"><b>Detail of material used in costruction with price.</b></h3>
<hr>
<table>
<tr>
<th>Product Name</th>
<th>Retail Price</th>
<th>Company Price</th>
<th>Quantity used</th>
<th>Cost of Quantity</th>
</tr>
<?php
if (isset($_GET['project_id'])) {
$project_id = $_GET['project_id'];
$select_material = "SELECT * FROM material_detail WHERE project_id = '$project_id'";
$run_material = mysqli_query($con, $select_material);
if (mysqli_num_rows($run_material)>0) {
while ($data = mysqli_fetch_array($run_material)) {
$p_name = $data['p_name'];
$r_price = $data['r_price'];
$c_price = $data['c_price'];
$q_used = $data['q_used'];
$project_id = $data['project_id'];
$q_cost = $data['q_cost'];
echo "<tr>
<td>$p_name</td>
<td>$r_price</td>
<td>$c_price</td>
<td>$q_used</td>
<td>$q_cost</td>
</tr>";
}
}
}
?>
</table>
</section>
<!--cost table end-->
<!--Payment plane start-->
<section style="margin-top: 60px;">
<h2 class="start"><?php echo $project_title." - ".$project_type;?></h2>
<h3 class="start"><b>Payment Plan</b></h3>
<hr>
<table>
<tr>
<th>Plot Size</th>
<th><?php echo $p_size;?></th>
</tr>
<?php
if (isset($_GET['project_id'])) {
$project_id = $_GET['project_id'];
$select_payment = "SELECT * FROM payment_plans WHERE project_id = '$project_id'";
$run_payment = mysqli_query($con, $select_payment);
if (mysqli_num_rows($run_payment)>0) {
while ($datapayment = mysqli_fetch_array($run_payment)) {
$p_title = $datapayment['p_title'];
$p_detail = $datapayment['p_detail'];
echo "<tr>
<td>$p_title</td>
<td>$p_detail</td>
</tr>";
}
}
}
?>
</table>
</section>
<!--payment plan end-->
<section>
<hr>
<div class="container-fluid">
<div class="row mb-2">
<div class="image-div">
<div class="col-lg-6 col-md-6 col-sm-12 col-12">
<h2>Features:</h2>
<ol>
<?php
if (isset($_GET['project_id'])) {
$project_id = $_GET['project_id'];
$select_features = "SELECT * FROM project_features WHERE project_id = '$project_id'";
$run_features = mysqli_query($con, $select_features);
if (mysqli_num_rows($run_features)>0) {
while ($datafeatures = mysqli_fetch_array($run_features)) {
$features = $datafeatures['features'];
$image = $datafeatures['image'];
$video = $datafeatures['video'];
echo "<li><b>$features</b></li>";
}
}
}
?>
</ol>
</div>
<hr>
<div>
<h3><?php echo $project_title;?> house vedio:</h3>
<iframe src="images/<?php echo $video;?>"></iframe>
<p>This vedio belong to our previous project.</p>
</div>
</div>
<div class="detail-div">
<img src="images/<?php echo $image;?>">
</div>
</div>
</div>
</section>
<div>
<p style="text-align: center;">To buy this project submit you order by clicking on order button given below.</p>
<button class="an"><a href="orderform.php?project_id=<?php echo $_GET['project_id'];?>">Order</a></button>
</div>
<!-- Footer start-->
<footer class="w3-center w3-black w3-padding-64">
<a href="#" class="w3-button w3-light-grey"><i class="fa fa-arrow-up w3-margin-right"></i>To the top</a>
<div class="w3-xlarge w3-section">
<i class="fa fa-facebook-official w3-hover-opacity"></i>
<i class="fa fa-instagram w3-hover-opacity"></i>
<i class="fa fa-snapchat w3-hover-opacity"></i>
<i class="fa fa-pinterest-p w3-hover-opacity"></i>
<i class="fa fa-twitter w3-hover-opacity"></i>
<i class="fa fa-linkedin w3-hover-opacity"></i>
</div>
<p>Copyright@:<a href="https://www.facebook.com/people/Ch-Umair/100008881573133" title="" target="_blank" class="">GCC.2021</a></p>
</footer>
<!--footer end--->
<!-- Javascript -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
</body>
</html>