File: /home/usas/swastikenterprises.usas.in/Admin/update-additional-service.php
<?php
include 'Database/config.php';
if (isset($_POST['submit'])) {
$as_id = $_GET['id'];
$c_id = mysqli_real_escape_string($conn, $_POST['c_id']);
$t_id = mysqli_real_escape_string($conn, $_POST['t_id']);
$as_number = mysqli_real_escape_string($conn, $_POST['as_number']);
$as_date = mysqli_real_escape_string($conn, $_POST['as_date']);
$as_product_category = mysqli_real_escape_string($conn, $_POST['as_product_category']);
$as_product_name = mysqli_real_escape_string($conn, $_POST['as_product_name']);
$as_amount = mysqli_real_escape_string($conn, $_POST['as_amount']);
$as_pending_amount = mysqli_real_escape_string($conn, $_POST['as_pending_amount']);
$as_message = mysqli_real_escape_string($conn, $_POST['as_message']);
$as_status = mysqli_real_escape_string($conn, $_POST['as_status']);
$sql = "UPDATE `additional_service` SET `t_id`='{$t_id}',`c_id`='{$c_id}',`as_date`='{$as_date}',`as_product_category`='{$as_product_category}',`as_product_name`='{$as_product_name}',`as_number`='{$as_number}',`as_amount`='{$as_amount}',`as_pending_amount`='{$as_pending_amount}',`as_message`='{$as_message}',`as_status`='{$as_status}' WHERE id = '{$as_id}'";
$result = mysqli_query($conn, $sql);
if ($result) {
header('location:additional-service.php');
}else{
$error = "Additional Service not Updated";
}
}
?>
<?php
include 'include/header.php';
?>
<style>
.gradient-custom {
/* fallback for old browsers */
.card-registration .select-input.form-control[readonly]:not([disabled]) {
font-size: 1rem;
line-height: 2.15;
padding-left: .75em;
padding-right: .75em;
}
.card-registration .select-arrow {
top: 13px;
}
input[type=text]{
background: #fff;
}
label{
font-size: 18px;
}
</style>
<section class="vh-100 gradient-custom">
<div class="container py-5 h-100">
<div class="row justify-content-center align-items-center h-100">
<div class="col-12 col-lg-9 col-xl-9">
<div class="card shadow-2-strong card-registration" style="border-radius: 15px;">
<div class="card-body p-4 p-md-5">
<h3 class="mb-4 pb-2 pb-md-0 mb-md-5">Update Additional Service</h3>
<?php
$as_id = $_GET['id'];
$sql5 = "SELECT * FROM additional_service WHERE id = '{$as_id}'";
$result5 = mysqli_query($conn, $sql5);
if (mysqli_num_rows($result5) >0) {
while ($row5 = mysqli_fetch_assoc($result5)) {
?>
<form action="<?php $_SERVER['PHP_SELF'];?>" method = "POST">
<div class="row">
<div class="col-md-6 mb-4">
<div data-mdb-input-init class="form-outline">
<!-- Customer Dropdown -->
<label class="form-label" for="cust_id">Select Customer</label>
<select class="form-control form-control-lg" id="cust_id" name="c_id" required>
<option value="" disabled>Select Customer Name</option>
<?php
$sql = "SELECT * FROM customers ORDER BY cust_name ASC";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
$selected = ($row5['c_id'] == $row['cust_id']) ? "selected" : "";
echo "<option value='{$row['cust_id']}' data-contact='{$row['cust_ph']}' $selected>
{$row['cust_name']}
</option>";
}
}
?>
</select>
</div>
</div>
<div class="col-md-6 mb-4">
<div data-mdb-input-init class="form-outline">
<label class="form-label" for="firstName">Technician Name</label>
<select class="form-control form-control-lg" name="t_id" required>
<option value="" disabled>Select Technician Name</option>
<?php
$sql = "SELECT * FROM technician ORDER BY username ASC";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
$selected = ($row5['t_id'] == $row['id']) ? "selected" : "";
echo "<option value='{$row['id']}' $selected>{$row['username']}</option>";
}
}
?>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6 mb-4">
<div data-mdb-input-init class="form-outline">
<label class="form-label mt-3" for="cust_no">Customer Contact No</label>
<input type="tel" id="cust_no" class="form-control form-control-lg"
name="as_number" required placeholder="Customer Number" readonly value="<?php echo $row5['as_number'];?>">
</div>
</div>
<div class="col-md-6 mb-4">
<div data-mdb-input-init class="form-outline">
<label for="birthdayDate" class="form-label">Service Date</label>
<input type="date" id="lastName" class="form-control form-control-lg" / name="as_date" required value="<?php echo $row5['as_date'];?>">
</div>
</div>
</div>
<div class="row">
<!-- Product Category -->
<div class="col-md-6 mb-4">
<div data-mdb-input-init class="form-outline">
<label class="form-label">Product Category</label>
<select class="form-control form-control-lg" name="as_product_category" id="product_category" required>
<option value="" selected disabled>Select Category</option>
<?php
include 'Database/config.php';
$sql = "SELECT * FROM products";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
$selected = ($row5['as_product_category'] == $row['id']) ? "selected" : "";
echo "<option value='{$row['id']}' $selected>{$row['product_name']}</option>";
}
}
?>
</select>
</div>
</div>
<!-- Product Name -->
<div class="col-md-6 mb-4">
<div data-mdb-input-init class="form-outline">
<label class="form-label">Product Name</label>
<select class="form-control form-control-lg" name="as_product_name" id="product_name" required>
<option value="" selected disabled>Select Product Name</option>
<?php
$sql = "SELECT * FROM product_name";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
$selected = ($row5['as_product_name'] == $row['id']) ? "selected" : "";
// store related product_id in data-category
echo "<option data-category='{$row['product_id']}' value='{$row['id']}' $selected>{$row['products_name']}</option>";
}
}
?>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6 mb-4">
<div data-mdb-input-init class="form-outline">
<label class="form-label" for="firstName">Service Amount</label>
<input type="text" id="lastName" class="form-control form-control-lg" / name="as_amount" value="<?php echo $row5['as_amount'];?>">
<!--<select class="form-control form-control-lg" name="blog_category">
</select>-->
</div>
</div>
<div class="col-md-6 mb-4">
<div data-mdb-input-init class="form-outline">
<label class="form-label" for="firstName">Service Pending Amount</label>
<input type="text" id="lastName" class="form-control form-control-lg" / name="as_pending_amount" value="<?php echo $row5['as_pending_amount'];?>">
</div>
</div>
</div>
<div class="row">
<div class="col-md-6 mb-4">
<div data-mdb-input-init class="form-outline">
<label class="form-label" for="firstName">Service Message</label>
<input type="text" id="lastName" class="form-control form-control-lg" / name="as_message" value="<?php echo $row5['as_message'];?>">
</div>
</div>
<div class="col-md-6 mb-4">
<div data-mdb-input-init class="form-outline">
<label class="form-label" for="firstName">Service Status</label>
<select class="form-control form-control-lg" name="as_status" required>
<option value="" disabled>Select Status</option>
<option value="0" <?php echo ($row5['as_status'] == 0) ? "selected" : ""; ?>>Not Done</option>
<option value="1" <?php echo ($row5['as_status'] == 1) ? "selected" : ""; ?>>Done</option>
</select>
</div>
</div>
</div>
<div class="mt-4 pt-2 w-100">
<?php
if (isset($_POST['submit'])) {
echo '<p style= "color:red;">' . $error . '</p>';
}
?>
<input data-mdb-button-init data-mdb-ripple-init class="btn btn-primary btn-lg" type="submit" value="Update Additional Service" / name = "submit">
</div>
</form>
<?php
}
}
?>
</div>
</div>
</div>
</div>
</div>
</section>
<?php
include 'include/footer.php';
?>