MAINHACK

Viewing / Editing File: monthly_in.php

<?php include 'header.php' ;

$show=new Oops($db);
?>
<script type="text/javascript">
	function send(){
		
		if(window.confirm("Do You Really Want To Delete The Data??")){
			
			return true;
		}
		else return false;
		
		
	}	jQuery(document).ready(function($) {
	  $('a[rel*=facebox]').facebox({
		loadingImage : 'src/loading.gif',
		closeImage   : 'src/closelabel.png'
	  })
	})
  </script>

<div id="page-wrapper">

<div class="main-page">
				
					<div class="tables">
					
						<h3 class="title1">Monthly Payment In</h3>
					<div class="panel-body widget-shadow">
<div class="col-md-4">
    <form method="post">
    <label>Choose Month</label>
    <select name="month" class="form-control">
    <option value=''>Choose</option>    
    <?php for($i=1;$i<=12;$i++){?>
    <option value="<?=$i?>"><?=date("F", mktime(0, 0, 0, $i, 10)) ?></option>
    <?php } ?>
    </select>
    <input type="submit" name="sub" value="Show" class="btn btn-info">
</form>			</div>
<?php if(isset($_POST['sub'])){?>
 <table class="table table-hover table-striped" id='example'>
                                        <thead>
                                            <th>ID</th>
                                            <th>Project ID</th>
                                            <th>Client ID</th>
                                             <th>Client Name/Phone</th>
                                           <th>Entry Date</th>
                                            <th>Payment Date</th>
                                            <th>Amount</th>
                                            <th>Gst</th>
                                            <th>Total</th>
                                            <th>Remark</th>
                                             <th>Delete</th>
                                           
                                            
                                        </thead>
                                        <tbody>
		
<?php
$count=1;
$sq="select * from payment where type='IN' and MONTH(date)='".$_POST['month']."'";
$stmt=$con->prepare($sq);
$stmt->execute();
//$stmt =$show->readwithdata('payment','type','IN');
$num = $stmt->rowCount();
     
     if($num>0){
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];     
    
        echo "<tr>
	        <td>$count</td>
		    <td>".$row['project_id']."</td>
		    <td>".$row['client_id']."</td>
		    <td>".$row['name']."/".$row['phone']."</td>
			<td>".date('d-m-Y',strtotime($row['entry_date']))."</td>
			<td>".date('d-m-Y',strtotime($row['date']))."</td>
		    <td>".$row['amount']."</td>
		    <td>".$row['gst']."</td>
		    <td>".$row['total']."</td>
		    <td>".$row['remarks']."</td>
		   	<td>
		<a href='delete.php?id=$id&table=&url=".$_SERVER['REQUEST_URI']."' class='label label-danger' onclick='return send();'>Delete</a>
		</td>
           
        </tr>";
        ++$count;
        }
        }?>
       </tbody>
                                   
                                    </table>	
<form method="post" action="export.php">
     <input type="submit" name="export" class="btn btn-success" value="Download & Export to Excel" />
    </form> 
<?php } ?>     
    		
    		
                                </div>
                            </div>
                        </div>
           
                    </div>
               
<?php include 'footer.php' ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: monthly_in.php

Server Info

System Features

User Info