MAINHACK

Viewing / Editing File: edit_report.php

<?php
include('header.php');

?>
<style>
    
    .col-md-6,.col-md-4,.col-md-3,.col-md-2,.col-md-5,.col-md-1{
        display:inline-block !important;
    }
</style>

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
			<div class="row">	
<div class="col-md-12">
<div class="card">
	<div class="card-header">
		<div class="card-title">Edit Order</div>
	</div>
<?php 
			
$sr='orders';
$stmt =$show->readwithdata($sr,'order_id',$_REQUEST['order']);
$num = $stmt->rowCount();
     
     if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
    
    $s1=$show->readwithdata('user','user_id',$row['user_id']);
    $row12 = $s1->fetch(PDO::FETCH_ASSOC);
    $uname=$row12['name'];
    $uemail=$row12['email'];
    $uphone=$row12['phone'];
?>
 	<form method="post" id="exampleValidation" data-toggle="validator" enctype="multipart/form-data" >

<div class="card-body">
		    
		    	<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Order Id <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="order_id" value="<?=$row['order_id']?>" class="form-control" placeholder="Title" >
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Date <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="no_of_days" value="<?=date('d-m-Y',strtotime($row['date']))?>"class="form-control" placeholder="No of Days" >
				</div>	
				
			</div>
			<hr>
			<h6>User Details</h6>
		    	<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">User Id <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="title" value="<?=$row['order_id']?>" class="form-control" placeholder="Title">
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Name <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="no_of_days" value="<?=$uname?>"class="form-control" placeholder="Name">
				</div>	
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Phone <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="phone" value="<?=$uphone?>"class="form-control" placeholder="Phone">
				</div>	
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Email <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="email" value="<?=$uemail?>"class="form-control" placeholder="Email">
				</div>	
			</div>
			<hr>
		 	<h6>Report Details</h6>    
		<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Marraige Type<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="title" value="<?=$row['marraige_type']?>" class="form-control" placeholder="Title">
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Type <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="no_of_days" value="<?=$row['type']?>"class="form-control" placeholder="No of Days" >
				</div>	
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Name <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="name" value="<?=$row['name']?>"class="form-control" placeholder="Phone">
				</div>	
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">DOB <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="email" value="<?=date('d-m-Y',strtotime($row['dob']))?>"class="form-control" placeholder="Email">
				</div>		
			</div>
				<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Phone<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="phone" value="<?=$row['phone']?>" class="form-control" placeholder="Title">
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Alt. Phone<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="alt_phone" value="<?=$row['alt_phone']?>"class="form-control" placeholder="No of Days" >
				</div>	
				<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Residential Address <span class="required-label">*</span></label>
				<div class="col-lg-4 col-md-12 col-sm-12">
            	    <input type="text" name="residential_address" value="<?=$row['residential_address']?>"class="form-control" placeholder="Phone">
				</div>	
					
			</div>	
			<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Pincode<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="pincode" value="<?=$row['pincode']?>" class="form-control" placeholder="Title">
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Landmark<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="landmark" value="<?=$row['landmark']?>"class="form-control" placeholder="No of Days" >
				</div>	
				<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Office Address <span class="required-label">*</span></label>
				<div class="col-lg-4 col-md-12 col-sm-12">
            	    <input type="text" name="office_address" value="<?=$row['office_address']?>"class="form-control" placeholder="Phone">
				</div>	
					
			</div>	
				<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Office Pincode<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="office_pincode" value="<?=$row['office_pincode']?>" class="form-control" placeholder="Title">
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Designation<span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="designation" value="<?=$row['designation']?>"class="form-control" placeholder="No of Days" >
				</div>	
				
					
			</div>	
			<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Brothers<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="brothers" value="<?=$row['brothers']?>" class="form-control" placeholder="Title">
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Sisters<span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="sisters" value="<?=$row['sisters']?>"class="form-control" placeholder="No of Days" >
				</div>	
				
					
			</div>	
							
			<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Father<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="father" value="<?=$row['father']?>" class="form-control" placeholder="Title">
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Father Phone<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="no_of_days" value="<?=$row['father_phone']?>"class="form-control" placeholder="No of Days">
				</div>	
				<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Father Office Address <span class="required-label">*</span></label>
				<div class="col-lg-4 col-md-12 col-sm-12">
            	    <input type="text" name="father_office_address" value="<?=$row['father_office_address']?>"class="form-control" placeholder="Phone">
				</div>	
					
			</div>	
				<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Mother<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="mother" value="<?=$row['mother']?>" class="form-control" placeholder="Title">
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Mother Phone<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="mother_phone" value="<?=$row['mother_phone']?>"class="form-control" placeholder="No of Days" >
				</div>	
				<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Mother Office Address <span class="required-label">*</span></label>
				<div class="col-lg-4 col-md-12 col-sm-12">
            	    <input type="text" name="mother_office_address" value="<?=$row['mother_office_address']?>"class="form-control" placeholder="Phone">
				</div>	
					
			</div>	
				<div class="form-group form-show-validation row">
			
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Description <span class="required-label">*</span></label>
				<div class="col-lg-6 col-md-12 col-sm-12">
            	    <textarea name="content"><?=$row['content']?></textarea>
				</div>	
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Image/Video<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	  <img src="<?=$pic_img?>/<?=$row['image']?>" width="100px">
				</div>			
			</div>
				<hr>
			<h6>Package & Payment Details</h6>
		    	<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Package Id<span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="package_id" value="<?=$row['package_id']?>" class="form-control" placeholder="Package Id" readonly>
				</div>
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Package <span class="required-label">*</span></label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="package" value="<?=$row['package']?>"class="form-control" placeholder="Package" readonly>
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Package Amt <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="discounted_price" value="<?=$row['discounted_price']?>"class="form-control" placeholder="Package Amt" readonly>
				</div>	
			
			</div>
		    	<div class="form-group form-show-validation row">
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Pay Status <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	   
            	 	<?php 
						     	$interests = array('PENDING','SUCCESS'); 
?>
						<select name="pay_status" id="status<?=$count;?>" class="form-control">
<?php foreach( $interests as  $interest ): ?>
<option value="<?php echo $interest ?>"<?php if( $interest==$row['pay_status']): ?> selected="selected"<?php endif; ?>><?php echo $interest ?></option>
<?php endforeach; ?>
</select>   
            	    
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Status <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	<?php 
						     	$interests = array('PENDING','SUCCESS'); 
?>
						<select name="status" id="status<?=$count;?>" class="form-control">
<?php foreach( $interests as  $interest ): ?>
<option value="<?php echo $interest ?>"<?php if( $interest==$row['pay_status']): ?> selected="selected"<?php endif; ?>><?php echo $interest ?></option>
<?php endforeach; ?>
</select>   			</div>	
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Payment Id <span class="required-label">*</span></label>
				<div class="col-lg-2 col-md-12 col-sm-12">
            	    <input type="text" name="phone" value="<?=$row['txn_id']?>"class="form-control" placeholder="Payment Id">
				</div>	
					
			</div>
<hr> 
<h6>Upload Report</h6>
		 <div class="form-group">
                <label> Image</label>
                
                <input type="file" name="service_img" required>
                <?php if($row['report']!=""){
                echo "<a href='".$pic_img."/".$row['report']."' target='_blank' class='btn btn-xs btn-info'>Show & Download</a>";
                
                }?>
                </div>	
		<div class="card-action">
			<div class="row">
				<div class="col-md-12">
					<input class="btn btn-success" type="submit" name="sub" value="Submit">
				</div>										
			</div>
		</div>
</div>
	</form>
	<?php } } ?>
</div>
</div>

<?php

if(isset($_POST['sub'])){

if(isset($_FILES['service_img'])){
    $img=$show->imageEdit($_FILES['service_img']['name']);
move_uploaded_file($_FILES['service_img']['tmp_name'],"../product_img/".$img);

}
$allowed = ["content"];

$params = [];
$setStr = "";
foreach ($allowed as $key)
{
    if (isset($_POST[$key]) && $key != "uid")
    {
        $setStr .= "`$key` = :$key,";
        $params[$key] = htmlspecialchars($_POST[$key]);
    }
}
$setStr .="`report`=:report,";

$setStr = rtrim($setStr, ",");
$params['report'] =$img;
$params['order_id'] =$_REQUEST['order'];
$show->table ='orders';
$show->cols =$setStr;
$show->id_name ='order_id';
$show->params =$params;

//print_r($setStr);

//print_r($params);
if($show->update_all()){
   		
echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You ",
            text: "for Updating!",
            type: "success"
        }, function() {
            window.location = "'.$_SERVER['REQUEST_URI'].'";
        });
    }, 1000);
</script>';
} else{
	echo "ss";
}

}?>

</div></div>
			</div>
			</div>
		
		
		<?php 
		
		include('footer.php');
		?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: edit_report.php

Server Info

System Features

User Info