MAINHACK

Viewing / Editing File: edit_performa_bill.php

<?php include 'header.php';$bil=$_REQUEST['bill']; 
?>
<style>
    
    .col-md-3,.col-md-2,.col-md-6{
        display:inline-block !important;
    }
</style>

<div class="col-md-12">
<div class="card">
	<div class="card-header">
		<div class="card-title">Edit Performa Invoice</div>
	</div>

<div class="card-body">
			<h6>Customer Details</h6>
<?php
$count=1;

$sr='client';
$stmt =$show->readwithdata('client','client_id',$_REQUEST['cid']);
$num = $stmt->rowCount();
    if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];  
    //  echo $row['name'];
                            $c_state=$row['state'];
     ?>	
	
		    	<div class="form-group form-show-validation row">
				<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-3 col-md-12 col-sm-12">
            	    <input type="text" name="name" value="<?=$row['name']?>" class="form-control" placeholder="Name">
            	    <input type="hidden" name="client_id" value="<?=$row['client_id']?>" >
				</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-3 col-md-12 col-sm-12">
            	    <input type="text" name="phone" class="form-control" value="<?=$row['phone']?>"  placeholder="Phone" required>
				</div>
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Alt Phone </label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="alt_phone" value="<?=$row['alt_phone']?>"  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 ">Email </label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="email" name="email" value="<?=$row['email']?>" class="form-control" placeholder="Email">
				</div>
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Address</label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="address" value="<?=$row['address']?>" class="form-control" placeholder="Address">
				</div>
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Location </label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="location" value="<?=$row['location']?>" class="form-control" placeholder="Location">
				</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 ">Country </label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="country" value="<?=$row['country']?>" class="form-control" placeholder="Country">
				</div>
				<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Company Name </label>
				<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="company_name" value="<?=$row['company_name']?>" class="form-control" placeholder="Company Name">
				</div>
				
			</div>
				<div class="form-group form-show-validation row">
				    	<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Company Address</label>
				<div class="col-lg-9 col-md-12 col-sm-12">
            	    <input type="text" name="company_address" value="<?=$row['company_address']?>" class="form-control" placeholder="Company Address">
				</div>
				</div>	
				<div class="form-group form-show-validation row">
				    	<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">GSTIN</label>
		<div class="col-lg-3 col-md-12 col-sm-12">
            	    <input type="text" name="gstin" value="<?=$row['gstin']?>"class="form-control" placeholder="GSTIN">
				</div>
					<label for="name" class="col-lg-2 col-md-3 col-sm-4 mt-sm-2 ">Other Details</label>
		<div class="col-lg-5 col-md-12 col-sm-12">
            	    <input type="text" name="others" value="<?=$row['others']?>" class="form-control" placeholder="Other Details">
				</div>
			</div>
			<?php } } ?>

<hr>
			<h6>Bill Details</h6>
<?php //echo $_REQUEST['bill'];
$stmt11 =$show->readwithdata('inovice_performa','bill_id',$_REQUEST['bill']);
$num11 = $stmt11->rowCount();//echo $num11;
    if($num11>0){
 
        $count=1;
        while ($row11 = $stmt11->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row11['id'];  
    //  echo $row['name'];
      
     ?>	
				
							<div class="form-group form-show-validation row">
	
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Bill ID</label>
		<div class="col-lg-2 col-md-12 col-sm-12">
            <input type="text" name="name" value="<?=$_REQUEST['bill']?>" readonly class="form-control" placeholder="Name">
  
					
				</div>	
				<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Bill Date</label>
		<div class="col-lg-2 col-md-12 col-sm-12">
            <input type="text" name="name" value="<?=date('d-m-Y',strtotime($row11['date']))?>" readonly class="form-control" placeholder="Name">
  
					
				</div>	
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">Bill Type</label>
		<div class="col-lg-3 col-md-12 col-sm-12">
            <input type="text" name="name" value="<?=$row11['type']?>" readonly class="form-control" placeholder="Name">
  
					
				</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 ">Total</label>
		<div class="col-lg-2 col-md-12 col-sm-12">
            <input type="text" name="name" value="<?=$row11['total']?>" readonly class="form-control" placeholder="Name">
  
					
				</div>	
				
				<?php if($c_state==$state){?>
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">CGST</label>
		<div class="col-lg-2 col-md-12 col-sm-12">
            <input type="text" name="name" value="<?=.09*$row11['total']?>" readonly class="form-control" placeholder="Name">
  
					
				</div>
					<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">SGST</label>
		<div class="col-lg-2 col-md-12 col-sm-12">
            <input type="text" name="name" value="<?=.09*$row11['total']?>" readonly class="form-control" placeholder="Name">
  
					
				</div>
				
				<?php }else{?>
						<label for="name" class="col-lg-1 col-md-3 col-sm-4 mt-sm-2 ">IGST</label>
		<div class="col-lg-2 col-md-12 col-sm-12">
            <input type="text" name="name" value="<?=.18*$row11['total']?>" readonly class="form-control" placeholder="Name">
  
					
				</div>
				<?php } ?>
			
			</div>
			<?php } }?>
	
</div>

</div>	
					</div>
							<div class="col-md-12">
							<div class="card">
							
								<div class="card-body">
									<div class="table-responsive">
					            <table id="basic-datatables" class="display table table-striped table-hover">
                                        <thead>
                                            <th>ID</th>
                                            <th>Order Details</th>
                                            <th>HSN / SAC</th>
                                            <th>Amt</th>

</thead>
<tbody>
		
<?php
$count=1;
$sr='project';
//$stmt =$show->readwithdata($sr,'status','Project Confirmed');
$s12="select * from bill where bill_id='".$bil."' order by id desc";//echo $s12;
$stmt=$con->prepare($s12);
$stmt->execute();
$num = $stmt->rowCount();
    if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];

// echo $usr_p;
           $module=$row['mproject_id']==''?"<a href='create_module.php?pid=".$row['project_id']."' class='btn btn-xs btn-success'>Create Module</a>":"<a href='show_module.php?pid=".$row['project_id']."'>Show Module</a>";

echo "<tr>
							    <td>$count </td>
								<td>".$row['title']."<br>".$row['bill_note']."</td>
								<td>".$row['hsn']."</td>
								<td>".$row['total_price']."</td>

";
								?>
		
                                <?php

++$count;
 }
}

?>							
</tbody>
                                    </table>

</div>
				
									</div>
								</div>
							</div>

<div class="card-action">
			<div class="row">
				<div class="col-md-12">
					<input class="btn btn-success" type="submit" name="sub" value="Edit Performa Invoice">
					<a href="final_performa.php?bil=<?=$_REQUEST['bill']?>" class="btn btn-info" target="_blank">Show Bill</a>
				</div>										
			</div>
		</div>
		</form>
		</div>
			</div>
			
		</div>
<?php

if(isset($_POST['sub'])){
    
   
$allowed = ["name","email","phone","address","country","location","alt_phone","company_name","company_address","others","gstin","state"];

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

$params['client_id'] =$_REQUEST['cid'];
$show->table ='client';
$show->cols =$setStr;
$show->id_name ='client_id';
$show->params =$params;
//print_r($params);
if($show->update_all()){

echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You ",
            text: "for Updating!",
            type: "success"
        }, function() {
            window.location = "invoice.php?bil='.$uid.'";
        });
    }, 1000);
</script>';
} else{
	echo "ss";
}

}?>
<?php include 'footer.php'; ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: edit_performa_bill.php

Server Info

System Features

User Info