MAINHACK

Viewing / Editing File: client_payment.php

<?php

include('header.php');
$show=new Oops($db);
$count=1;
$stmt =$show->readwithdata('client','client_id',$_REQUEST['id']);
$num = $stmt->rowCount();
     
     if($num>0){
 
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
		
		$id=$row['id'];    
        $uid=$row['client_id'];    
        $email=$row['email'];     
		$com=$row['company_name'];
		$gstin=$row['gstin'];
		$address=$row['address'];
		$contact_person1=$row['contact_person1'];
		$phone1=$row['phone1'];
		$contact_person2=$row['contact_person2'];
		$address=$row['address'];

$phone2=$row['phone2'];
		$web=$row['company_website'];

}
         
     }	
?>

$sq="select sum(total) as pay_in from payment where type='IN' and client_id='".$_REQUEST['id']."'";
$st=$con->prepare($sq);
$st->execute();
 while ($row = $st->fetch(PDO::FETCH_ASSOC)){
     $s=$row['pay_in'];
 }
$sq="select sum(total) as pay_out from payment where type='OUT' and client_id='".$_REQUEST['id']."'";
$st=$con->prepare($sq);
$st->execute();
 while ($row1 = $st->fetch(PDO::FETCH_ASSOC)){
     $out=$row1['pay_out'];
 }
 
 $p_loss=$s-$out;
?>

<div class="panel panel-default">
                        <div class="panel-heading">
                        Total IN/OUT Client-><?=$_REQUEST['id']?>                    
                        </div>
                        <div class="panel-body">
                        <div class="row">
                        <div class="col-lg-6">
                        <form role="form" method="post">
                        <div class="form-group">
                        <label>Total IN</label>
                        
                        Rs. <?=$s?>
                        </div>
                        <div class="form-group">
                        <label>Total Exp</label>
                        Rs. <?=$out?>
                        </div>      
                        <div class="form-group">
                        <label>Profit/Loss</label>
                        Rs.<?=$p_loss?>                        
                        </div>                        
                      
                        </form>
                        </div>
                        </div>
                        </div>
                        </div>
                     
                </div>
                <div class="col-lg-6">     
                        <div class="panel panel-default">
                        <div class="panel-heading">
                        Total IN/OUT                       
                        </div>
                        <div class="panel-body">
                        <div class="row">
                        <div class="col-lg-6">
                        <form role="form" method="post">
                        <div class="form-group">
                        <label>Month</label>
                        <select name="month" class="form-control" required>
                        <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>
                        </div>
                        <div class="form-group">
                        <label>Year</label>
                        <?php
                        // Sets the top option to be the current year. (IE. the option that is chosen by default).
                        $currently_selected = date('Y'); 
                        // Year to start available options at
                        $earliest_year = 2000; 
                        // Set your latest year you want in the range, in this case we use PHP to just set it to the current year.
                        $latest_year = date('Y'); 
                        
                        print '<select name="year" class="form-control" required><option value="">Choose</option>';
                        // Loops over each int[year] from current year, back to the $earliest_year [1950]
                        foreach ( range( $latest_year, $earliest_year ) as $i ) {
                        // Prints the option with the next year in range.
                        print '<option value="'.$i.'"'.($i === $currently_selected ? ' selected="selected"' : '').'>'.$i.'</option>';
                        }
                        print '</select>';
                        ?>
                        </div>  
                     <input type="submit" name="sub" value="Show" class="btn btn-info">                
                      
                        </form>
 <?php
if(isset($_POST['sub'])){

$sq="select sum(total) as pay_in from payment where type='IN' and MONTH(date)='".$_POST['month']."' and YEAR(date)='".$_POST['year']."' and client_id='".$_REQUEST['id']."'";
//echo $sq;
$st=$con->prepare($sq);
$st->execute();
 while ($row = $st->fetch(PDO::FETCH_ASSOC)){
     $s=$row['pay_in'];
 }
$sq="select sum(total) as pay_out from payment where type='OUT' and MONTH(date)='".$_POST['month']."' and YEAR(date)='".$_POST['year']."' and client_id='".$_REQUEST['id']."'";
$st=$con->prepare($sq);
$st->execute();
 while ($row1 = $st->fetch(PDO::FETCH_ASSOC)){
     $out=$row1['pay_out'];
 }
 
 $p_loss=$s-$out;
    echo "<table border='1'>";
    echo "<tr><td><h4>Total IN </h4></td><td><h4>Rs.".$s."</h4></td></tr>";
    echo "<tr><td><h4>Total Exp</h4> </td><td><h4>Rs.".$out."</h4></td></tr>";
    echo "<tr><td><h4>Total Profit/Loss</h4></td><td><h4> Rs".$p_loss."</h4></td></tr>";
    echo "</table>";
}

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

include('footer.php');
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: client_payment.php

Server Info

System Features

User Info