/ var / www / html / intranetpage / iiitdinternaldocs / [ HOME SHELL ]

Name	Size	Permission	Action
css	[ DIR ]	drwxr-x--x
dist	[ DIR ]	drwxr-x--x
documents	[ DIR ]	drwxr-x--x
images	[ DIR ]	drwxr-x--x
js	[ DIR ]	drwxr-x--x
lib	[ DIR ]	drwxr-x--x
plugins	[ DIR ]	drwxr-x--x
DBController.php	739 B	-rwxr-x--x
categorylist.php	2.25 KB	-rwxr-x--x
common.php	2.94 KB	-rwxr-x--x
createCategory.php	3.45 KB	-rwxr-x--x
createOfficeorder.php	9.13 KB	-rwxr-x--x
dashboard.php	3.01 KB	-rwxr-x--x
dbconfig.php	1.25 KB	-rwxr-x--x
get_subcatg.php	500 B	-rwxr-x--x
index.php	3.54 KB	-rwxr-x--x
indexDashboard.php	9.81 KB	-rwxr-x--x
list.php	9.5 KB	-rwxr-x--x
list.php_07032021	10.86 KB	-rwxr-x--x
logout.php	377 B	-rwxr-x--x

Code Editor : createOfficeorder.php

<?php
error_reporting(0);
ob_start();
require __DIR__ . DIRECTORY_SEPARATOR . "lib" . DIRECTORY_SEPARATOR . "config.php";
// HTML
require_once 'common.php';
$officeOrder = new IIITDELHI();
require_once("DBController.php");
$db_handle = new DBController();
$query = "SELECT * FROM category";
$categoryResult = $db_handle->runQuery($query);

if(isset($_POST['offOrder']))
{
	$subject = $_POST['subject'];
	$category = $_POST['category'];
	$subCatg = "NA";
	$releaseDate = $_POST['releaseDate'];
	$imgFile6 = $_FILES['fileUpload']['name'];
	$tmp_dir6 = $_FILES['fileUpload']['tmp_name'];
	$imgSize6 = $_FILES['fileUpload']['size'];
	//ITI MARKSHEET-------------------------------------------------------------------
		$errori= array();
      $file_ext6=strtolower(end(explode('.',$_FILES['fileUpload']['name'])));
      if($file_ext6 <>""){
		   $fileUpload = $subject."-".$category."-".rand(1000,1000000).".".$file_ext6;
	  } else {
		 $fileUpload=""; 
	  }
      $expensions6= array("jpeg","jpg","png","pdf","doc","csv");
		
      
      if(in_array($file_ext6,$expensions6)=== false){
         $errori[]="extension not allowed, please choose a PDF,DOC, JPEG, JPG or PNG file.";
      }
      
      if($imgSize6 > 2097152){
         $errori[]='File size must be 2 MB';
      }
      
      if(empty($errori)==true){
         move_uploaded_file($tmp_dir6,$_SERVER['DOCUMENT_ROOT'].'/iiitdinternaldocs/documents/'.$fileUpload);
        //echo "Success";
      }else{
         $errori;
      }
		if(empty($subject)){
			$errMSG = "Please Select Category Name.";
		}
			if(!isset($errMSG))
		{
	
	$stmt = $officeOrder->runQuery("SELECT * FROM officeorder WHERE  subject=:subject1");
	$stmt->execute(array(":subject1"=>$subject));
	$rows = $stmt->fetch(PDO::FETCH_ASSOC);
 	if($stmt->rowCount() > 0)
	{
		$errMSG = "It is already Uploaded. Please Check";    
	}
	else
	{
		if($officeOrder->officeOrderup($subject,$category,$subCatg,$releaseDate,$fileUpload))
		{	
			$successMSG = "Document Uploaded Successfuly...";
		}
		
		else
		{
			$errMSG = "Sorry , Query could not execute...";
		}		
	}
		
		}
}
?>
<script src="https://code.jquery.com/jquery-2.1.1.min.js"
    type="text/javascript"></script>
<script>
function getState() {
        var str='';
        var val=document.getElementById('category-list');
        for (i=0;i< val.length;i++) { 
            if(val[i].selected){
                str += val[i].value + ','; 
            }
        }         
        var str=str.slice(0,str.length -1);
        
	$.ajax({          
        	type: "GET",
        	url: "get_subcatg.php",
        	data:'catgID='+str,
        	success: function(data){
        		$("#subcatg-list").html(data);
        	}
	});
}
</script>
<?php require PATH_LIB . "page-top.php"; ?>
  
  <div class="content-wrapper">
     
    <section class="content">
      <div class="container-fluid">
        <div class="row">
          <div class="col-md-12">
            <div class="card card-primary card-outline mt-2">
              <div class="card-header" style="padding-left: 20px;">
                <h3 class="card-title">
                Upload Document
					<?php echo $_SERVER['DOCUMENT_ROOT'];?>
                </h3>
              </div>
				
				<div class="row">
    
        <div class="col-md-6">
          
          <div class="box box-primary" style="padding-left: 20px;">
            
            <form role="form" enctype="multipart/form-data" action="createOfficeorder.php" method="post">
				<div class="box-body">  
<?php
	if(isset($errMSG)){
			?>
		  <div class="alert alert-danger alert-dismissible">
                <button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
                <h4 style="font-size: 15px;"><i class="icon fa fa-ban"></i> Alert! &nbsp; &nbsp; <?php echo $errMSG; ?></h4>
               
              </div>
            <?php
	}
	else if(isset($successMSG)){
		?>
		    <div class="alert alert-success alert-dismissible">
                <button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
                <h4 style="font-size: 15px;"><i class="icon fa fa-check"></i> Alert! &nbsp; &nbsp;  <?php echo $successMSG; ?></h4>
               
              </div>
        <?php
	}
	?> 
				  </div>
              <div class="box-body">
                <div class="form-group">
                  <label for="subject">Document Title </label>
                  <input type="text" class="form-control" id="subject" name="subject" required>
                </div>
				  <div class="form-group">
                  <label for="createCategory">Select Category</label>
        	<select name="category" id="category-list" class="form-control" onChange="getState();" >
                <option value="">Select Category</option>
<?php
foreach ($categoryResult as $category) {
    ?>
<option value="<?php echo $category["catgID"]; ?>"><?php echo $category["categoryName"]; ?></option>
<?php
}
?>
</select>
                </div>
				  <div class="form-group">
                  <label for="releaseDate">Document Release Date</label>
                  <input type="date" class="form-control" id="releaseDate" name="releaseDate" required>
					  
                </div>
				  <div class="form-group">
                  <label for="createCategory">Upload File</label>
                  <input type="file" class="form-control" id="fileUpload" name="fileUpload" required>
				  <div id="fileUploadfilename"></div>
                </div>
              </div>

<div class="box-footer">
                <button type="submit" class="btn btn-primary" name="offOrder">Submit</button>
              </div>
            </form>
          </div>
          
        </div>
         
 				
        </div>
				</div>
			  </div>
			</div>
		  </div>
		 </section>
    
<section class="content">
						<div class="container-fluid">
								<div class="row">
										<div class="col-12">
												<div class="card">
														<div class="card-header">
																<h3 class="card-title">Internal Documents List</h3>
														</div>
														
														<div class="card-body">
																<table id="example1" class="table table-bordered table-striped">
																		<thead>
																				<tr>
																						<th>Release Date</th>
																						<th>Title</th>
																						<th>Category</th>
																						<th>Upload Date</th>
																						<th>Download</th>
																					
																						
																				</tr>
																		</thead>
																		<tbody>
								<?php
						
								$result = $DB_con->prepare("SELECT cg.*,of.* FROM category cg,officeorder of
								 where cg.catgID = of.category");
								$result->execute();
								for($i=0; $row = $result->fetch(); $i++){
									
							?>
							<tr>
							<td><?php echo $row ['releaseDate']; ?></td>
							<td><?php echo $row ['subject']; ?></td>
							<td><?php echo $row ['categoryName']; ?></td>
							<td><?php echo $row ['makerstamp']; ?></td>
							<td><a href="/iiitdinternaldocs/documents/<?php echo $row ['fileUpload']; ?>" target="_blank">File</a></td>
							</tr>
									 <?php } ?>											
																		</tbody>
																		
																</table>
														</div>
														 
												</div>
												 
										</div>
										 
								</div>
								 
						</div>
						 
				</section>
    <a id="back-to-top" href="#" class="btn btn-primary back-to-top" role="button" aria-label="Scroll to top">
      <i class="fas fa-chevron-up"></i>
    </a>
  </div>
<script>
var input3 = document.getElementById('fileUpload');
var infoArea3 = document.getElementById('fileUploadfilename');

input3.addEventListener('change', showFileName3);

function showFileName3(event) {

// the change event gives us the input it occurred in 
  var input3 = event.srcElement;

// the input has an array of files in the `files` property, each one has a name that you can use. We're just using the name here.
  var fileName3 = input3.files[0].name;

// use fileName however fits your app best, i.e. add it into a div
  infoArea3.textContent = 'File name: ' + fileName3;
}
</script>
  
  <?php  ob_end_flush(); require PATH_LIB . "page-bottom.php"; ?>

Urban Research Lab

Urban Research Lab

The Urban Research Lab (URL) at IIIT-Delhi was established in 2020, during a time when the pandemic brought the complexities of urban life more visible than ever. What started as an initiative by faculty and students has grown into a collaborative space for critically exploring and reimagining the urban questions through research, dialogue, and interdisciplinary engagement.