GitHub - borasomaly/CAIC-IAMS

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
Import Form		Import Form
assets		assets
config		config
database		database
excelReader		excelReader
uploads		uploads
404.html		404.html
admin_class.php		admin_class.php
ajax.php		ajax.php
asset_list.php		asset_list.php
audit_users.php		audit_users.php
csv.php		csv.php
db_connect.php		db_connect.php
edit_asset.php		edit_asset.php
edit_camera.php		edit_camera.php
edit_return.php		edit_return.php
edit_software.php		edit_software.php
edit_user.php		edit_user.php
equipment_list.php		equipment_list.php
export_camera.php		export_camera.php
export_return.php		export_return.php
export_software.php		export_software.php
footer.php		footer.php
header.php		header.php
home.php		home.php
import_camera.php		import_camera.php
import_return.php		import_return.php
import_software.php		import_software.php
index.php		index.php
list_equipment.php		list_equipment.php
login.php		login.php
manage_user.php		manage_user.php
message.php		message.php
more_asset.php		more_asset.php
more_license.php		more_license.php
more_return.php		more_return.php
new_asset.php		new_asset.php
new_return.php		new_return.php
new_software.php		new_software.php
new_user.php		new_user.php
permissions.php		permissions.php
return_list.php		return_list.php
setting.php		setting.php
sidebar(R).php		sidebar(R).php
sidebar.php		sidebar.php
software_list.php		software_list.php
supporter.php		supporter.php
tools.php		tools.php
topbar.php		topbar.php
user_list.php		user_list.php
view_return.php		view_return.php
view_software.php		view_software.php
view_user.php		view_user.php

Repository files navigation

<?php
//session_start();
include_once 'db_connect.php';
$error_message = '';
if (isset($_POST['action']) && $_POST['action'] == 'clear') {
    unset($_SESSION['error_message']);
    $error_message = ''; 
}
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['code_equipment']) && isset($_POST['action']) && $_POST['action'] == 'go') {
    $code_equipment = $_POST['code_equipment'];
    $sql = "SELECT * FROM equipment WHERE code_equipment = '$code_equipment'";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        $equipment = $result->fetch_assoc();
        $ponum = $equipment['ponum'];
        $model = $equipment['model'];
        $supplier = $equipment['supplier'];
        $purdate = $equipment['purdate'];
        $delivery = $equipment['delivery'];
        $price = $equipment['price'];
        $description = $equipment['description'];
        $descript = $equipment['descript'];
        $eol = $equipment['eol'];
        $status = $equipment['status'];
        $sect = $equipment['sect'];
        $locat = $equipment['locat'];
        $donation = $equipment['donation'];
        $remark = $equipment['remark'];
        $war_start = $equipment['war_start'];
        $war_end = $equipment['war_end'];
        $type = $equipment['type'];
        $serial = $equipment['serial'];
        $owner = $equipment['owner'];
    } else {
        if (!isset($_POST['action']) || $_POST['action'] != 'clear') {
            $_SESSION['error_message'] = "No equipment found with that code.";
            $error_message = $_SESSION['error_message'];
        }
    }
}
$error_message = isset($_SESSION['error_message']) ? $_SESSION['error_message'] : '';
if ($error_message) {
    unset($_SESSION['error_message']);
}
?>
<!DOCTYPE html>
  <html lang="en">
  <head>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha3/dist/css/bootstrap.min.css" rel="stylesheet">
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha3/dist/js/bootstrap.bundle.min.js"></script>
    <script src="https://cdn.tailwindcss.com"></script>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.6.0/css/all.min.css">
    <script>
      function formToggle(ID){
          var element = document.getElementById(ID);
          if(element.style.display === "none"){
              element.style.display = "block";
          }else{
              element.style.display = "none";
          }
      }
    </script>
  </head>
  <body>
  <?php if ($error_message): ?>
    <div class="alert alert-danger">
        <?php echo $error_message; ?>
    </div>
<?php endif; ?>
  <ul class="nav nav-tabs bg-light mb-12" id="myTab" role="tablist">
    <li class="nav-item" role="presentation">
      <button class="nav-link active" id="tutTab" data-bs-toggle="tab" data-bs-target="#tutorialspoints" type="button" role="tab" aria-controls="tutorialspoints" aria-selected="true"><b>List Equipment</b></button>
    </li>
    <li class="nav-item" role="presentation">
      <button class="nav-link" id="homeTab" data-bs-toggle="tab" data-bs-target="#home" type="button" role="tab" aria-controls="home" aria-selected="false"><b>Purchase Information</b></button>
    </li>
    <li class="nav-item" role="presentation">
      <button class="nav-link" id="servicesTab" data-bs-toggle="tab" data-bs-target="#services" type="button" role="tab" aria-controls="services" aria-selected="false"><b>Other Information</b></button>
    </li>

    <div class="card-tools flex justify-end items-end ml-4">
          <a href="javascript:void(0);" class="btn btn-success" onclick="formToggle('importFrm');"><i class="fa-solid fa-file-import"></i> Import Excel</a>
    </div>
    <div class="card-tools flex justify-end items-end ml-4">
		      <a class="btn btn-danger mr-4" href="export_camera.php?"><i class="fas fa-download"></i> Export to CSV</a></span>
    </div>
        <div class="col-md-12 grid justify-items-end -mt-24 py-12" id="importFrm" style="display: none;">
        <form class="row" action="import_computer.php" method="post" enctype="multipart/form-data">
            <div class="col-auto">
                <label for="" class="visually mb-3">File</label>
                <input type="file" class="form-control " name="excel" id="" />
            </div>
            <div class="col-auto">
                <input type="submit" class="btn btn-success mb-3" name="import" value="Import">
            </div>
        </form>
    </div>
  </ul>
  <div class="tab-content bg-white mt-1 rounded-md">
    <div class="tab-pane fade show active p-2" id="tutorialspoints" role="tabpanel" aria-labelledby="tutTab" tabindex="0">
      <form method="post" action="" class="mt-4">
        <div class="flex items-center justify-center text-center">
          <b class="text-[20px]">Display RowNumber :</b> &nbsp;<input type="text" name="code_equipment" class="form-control col-md-1" value="<?php echo isset($code_equipment) ? $code_equipment : '' ?>"> &nbsp; <button type="submit" class="bg-blue w-12 h-9 rounded-md" name="action" value="go">Go</button>&nbsp;<button type="submit" class="bg-blue w-12 h-9 rounded-md" name="action" value="clear">Clear</button>
        </div>
        <div class="flex items-center justify-center text-center">
          <b class="text-[20px]">Total Equipments :</b> &nbsp;<?php
                $sql = "SELECT * FROM asset_type";
                $query = $conn->query($sql);
                echo "<h4 class='mt-2'>".$query->num_rows."</h4>";
              ?>
        </div>
      </form>
      <table class="table table-striped table-bordered mt-6" style="width:100%;" id="list">
        <thead class="bg-blue-300">
            <tr>
		      	<th class="text-center">Nº</th>
		      	<th class="text-center">Code Equipment</th>
            <th class="text-center">Type</th>
		      	<th class="text-center">Model</th>
		      	<th class="text-center">Supplier</th>
		      	<th class="text-center">Purchase Date</th>
            <th class="text-center">Employee</th>
            <th class="text-center">Status</th>
            <th class="text-center">Donation</th>
            </tr>
        </thead>
        <tbody>
        <?php
        $qry = $conn->query("SELECT * FROM equipment");
        if($qry->num_rows > 0){ $i=0;
            while($row = $qry->fetch_assoc()){ $i++;
        ?>
            <tr>
			      <th class="text-center"><?php echo $i ?></th>
			      <td class="text-center"><b><?php echo $row['code_equipment'] ?></b></td>
            <td class="text-center"><b><?php echo $row['type'] ?></b></td>
			      <td class="text-center"><b><?php echo $row['model'] ?></b></td>
			      <td class="text-center"><b><?php echo $row['supplier'] ?></b></td>
			      <td class="text-center"><b><?php echo $row['purdate'] ?></b></td>
			      <td class="text-center"><b><?php echo $row['owner'] ?></b></td>
            <td class="text-center"><b><?php echo $row['status'] ?></b></td>
			      <td class="text-center"><b><?php echo $row['donation'] ?></b></td>
            </tr>
        <?php } }else{ ?>
            <tr><td colspan="9">No member(s) found...</td></tr>
        <?php } ?>
        </tbody>
    </table>
    </div>
    <div class="tab-pane fade p-2" id="home" role="tabpanel" aria-labelledby="homeTab" tabindex="0">
<form action="" id="manage_equipment">
<input type="hidden" name="id" value="<?php echo isset($id) ? $id : '' ?>">
<input type="hidden" name="code_equipment" value="<?php echo isset($code_equipment) ? $code_equipment : '' ?>">
<div class="row justify-between">
          <div class="col-md-5 bg-blue-300 rounded-md ml-28">
    <h5 class="text-blue-800 py-3 px-4"><i class="fas fa-circle-info"></i>&nbsp;The information of equipment, equipment Nº: <?php echo isset($code_equipment) ? $code_equipment : '' ?></h5>
    <div class="form-group flex items-center px-4">
            PO reference Nº &emsp;&emsp;<input type="text" name="ponum" class="border-black form-control col-md-6 ml-10" value="<?= isset($ponum) ? $ponum : 'N/A' ?>">
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
            Model &emsp;&emsp;<input type="text" class="border-black form-control col-md-6 ml-28" name="model" value="<?= isset($model) ? $model : 'N/A' ?>">
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
            Purchase company &emsp;&emsp;<input type="text" class="border-black form-control col-md-6 ml-6" name="supplier" value="<?= isset($supplier) ? $supplier : 'N/A' ?>">
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
            Delivery Date &emsp;&emsp;<input type="date" class="border-black form-control col-md-6 ml-16" name="delivery" value="<?= isset($delivery) ? $delivery : 'N/A' ?>">
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
            Unit Price &emsp;&emsp;<input type="text" class="border-black form-control col-md-6 ml-24" name="price" value="<?= isset($price) ? $price : 'N/A' ?>">
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
            Description &emsp;&emsp;<textarea type="text" class="border-black form-control col-md-6 ml-20" name="description" value="<?= isset($description) ? $description : 'N/A' ?>"></textarea>
          </div>
          &emsp;
  </div>
  &emsp;
  <div class="col-md-5 bg-blue-300 rounded-md mr-28">
    <h5 class="text-blue-800 py-3 px-4"><i class="fas fa-circle-info"></i>&nbsp;Warranty:</h5>
    <div class="form-group flex items-center px-4">
            Start Date <input type="date" class="border-black form-control col-md-6 ml-28" name="war_start" value="<?= isset($war_start) ? $war_start : 'N/A' ?>">
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
            End Date &emsp;&emsp;<input type="date" class="border-black form-control col-md-6 ml-20" name="war_end" value="<?= isset($war_end) ? $war_end : 'N/A' ?>">
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
            Description &emsp;&emsp;<textarea type="text" class="border-black form-control col-md-6 ml-16" name="descript" value="<?= isset($descript) ? $descript : 'N/A' ?>"></textarea>
          </div>
          &emsp;
        </div>
      </div>
</form>
<hr>
  	<div class="row">
    <div class="col-md-12 text-center justify-content-center flex">
        <button class="btn btn-success mr-2" form="manage_equipment">Update & Save</button>
      </div>    
    </div>
    </div>
    <div class="tab-pane fade p-2" id="services" role="tabpanel" aria-labelledby="servicesTab" tabindex="0">
<form action="" id="manage_equipment">
<input type="hidden" name="id" value="<?php echo isset($id) ? $id : '' ?>">
<input type="hidden" name="code_equipment" value="<?php echo isset($code_equipment) ? $code_equipment : '' ?>">
<div class="row justify-between">
          <div class="col-md-5 bg-blue-300 rounded-md ml-28">
    <h5 class="text-blue-800 py-3 px-4"><i class="fas fa-circle-info"></i>&nbsp;Equipment's Information</h5>
    <div class="form-group flex items-center px-4">
            Equipment Type &emsp;&emsp;<input type="text" class="border-black form-control col-md-6 ml-10" <?= isset($type) ? $type : 'N/A' ?>>
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
            Serial number &emsp;&emsp;<input type="text" class="border-black form-control col-md-6 ml-14" <?= isset($serial) ? $ponum : 'N/A' ?>>
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
            Estimated EOL &emsp;&emsp;<input type="date" class="border-black form-control col-md-6 ml-14" <?= isset($eol) ? $eol : 'N/A' ?>>
          </div>
          <div class="form-group flex items-center px-2 -mt-3">
          <input type="checkbox" class="border-black col-md-6 -ml-[76px]" <?= isset($status) ? $status : 'N/A' ?>><p class="-ml-[96px] mt-2">If in stock</p>
          </div>
          <div class="form-group flex items-center px-2 -mt-2">
          <input type="checkbox" class="border-black col-md-6 -ml-[76px]" <?= isset($status) ? $status : 'N/A' ?>><p class="-ml-[96px] mt-2">Is Demaged</p>
          </div>
          <div class="form-group flex items-center px-2 -mt-2">
          <input type="checkbox" class="border-black col-md-6 -ml-[76px]" <?= isset($status) ? $status : 'N/A' ?>><p class="-ml-[96px] mt-2">Too Old/Donation</p>
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
          &emsp;&emsp;<input type="date" class="border-black form-control col-md-6 ml-24" <?= isset($donation) ? $donation : 'N/A' ?>>
          </div>
          &emsp;
  </div>
  &emsp;
  <div class="col-md-5 bg-blue-300 rounded-md mr-28">
    <h5 class="text-blue-800 py-3 px-4"><i class="fas fa-circle-info"></i>&nbsp;Owner's Information:</h5>
    <div class="form-group flex items-center px-4">
            Owner/User &emsp;&emsp;<input type="text" class="border-black form-control col-md-6 ml-20" <?= isset($owner) ? $owner : 'N/A' ?>>
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
            Section &emsp;&emsp;<input type="text" class="border-black form-control col-md-6 ml-28" <?= isset($sect) ? $sect : 'N/A' ?>>
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
            Location &emsp;&emsp;<input type="text" class="border-black form-control col-md-6 ml-[105px]" <?= isset($locat) ? $locat : 'N/A' ?>>
          </div>
          <div class="form-group flex items-center px-4 -mt-3">
            Remark &emsp;&emsp;<textarea type="text" class="border-black form-control col-md-6 ml-28" <?= isset($remark) ? $remark : 'N/A' ?>></textarea>
          </div>
          &emsp;
        </div>
      </div>
</form>
<hr>
  	<div class="row">
    <div class="col-md-12 text-center justify-content-center flex">
    <button class="btn btn-success mr-2" form="manage_equipment">Update & Save</button>
      </div>    
    </div>
    </div>
  </div>
  <script>

$('#dtype').change(function(){
      if($(this).prop('checked') == true){
        $('#tbi-field').hide()
      }else{
        $('#tbi-field').show()
      }
  })
  $('#manage_equipment').submit(function(e){
    e.preventDefault(); 
    $('input').removeClass("border-danger")
    start_load(); 
		$.ajax({
			url:'ajax.php?action=save_equipment',
			data: new FormData($(this)[0]),
		    cache: false,
		    contentType: false,
		    processData: false,
		    method: 'POST',
		    type: 'POST',
			success:function(resp){
        if(resp == 1){
            alert_toast('Data successfully saved',"success");
            setTimeout(function(){
              location.href = 'index.php?page=list_Equipment';
            },750)

        }
			}
		})
	})
  function displayImgCover(input,_this) {
      if (input.files && input.files[0]) {
          var reader = new FileReader();
          reader.onload = function (e) {
            $('#cover').attr('src', e.target.result);
          }

          reader.readAsDataURL(input.files[0]);
      }
  }
  </script>
  </body>
  </html>