.-.-.-.-.-

<?php 
$title= "Invest Done";
include 'header.php';
?>
<div class="wrapper_cls">
    
    <h1>Invest Details</h1>
    <?php echo getMessage(); ?>
    <div style="width: 500px; height: 310px; border: solid medium black">
        <div style="font-size: 25px; font-weight: bold; font-family:  sans-serif; border-bottom:  solid black thin; text-align: center"> Wtm WebShop Invoice</div>
        <div>
            <?php
            $row = mysqli_fetch_object(mysqli_query($connection, "select * from invest_amount where iaid = ".$_GET['id']));
            ?>
            <table border="0" style="font-size: 15; font-family:  sans-serif;" align="center">
                <tr><td>User ID</td><td><?php echo $row->uid; ?></td></tr>
                <tr><td>User Name </td><td><?php echo mysqli_fetch_object(mysqli_query($connection, "select name from user where uid = '$row->uid'"))->name;?></td></tr>
                <tr><td>Sponser Name </td><td><?php echo mysqli_fetch_object(mysqli_query($connection, "select name from user where uid = (select refer_id from user where uid ='$row->uid')"))->name;?></td></tr>
                
                <tr><td>Date</td><td><?php echo date('d/m/y', strtotime($row->date));?></td></tr>
                
				<?php
				$row_cnt = mysqli_fetch_object(mysqli_query($connection, "SELECT COUNT( * ) 'cnt' FROM `invest_amount` WHERE uid ='$row->uid'"));
				?>
				<tr><td>Installment No:</td><td><?php if(isset($row_cnt->cnt)){echo $row_cnt->cnt;}?></td></tr>
				<?php
				$first_pay_details = mysqli_fetch_object(mysqli_query($connection, "SELECT `iaid`,`amount`,`date`,`month` FROM `invest_amount` WHERE uid ='$row->uid' ORDER BY `date` ASC LIMIT 1"));
				$next_pay_date = mysqli_fetch_object(mysqli_query($connection, "SELECT DATE_ADD( '$first_pay_details->date' , INTERVAL 1 MONTH ) 'a'"));
				$datepart_first_pay = explode('-',$first_pay_details->date);
				$datepart_curr_pay = explode('-',$row->date);
				$datepart_next_pay = explode('-',$next_pay_date->a);
				//echo "<pre>";
				
				//echo $datepart[0]." ";echo $datepart[1]." ";echo $datepart[2]." ";//2014 02 01
				$y=$datepart_first_pay[0];//$y=$datepart_first_pay[0]+($datepart_curr_pay[0]-$datepart_first_pay[0]);
				$m=date('m');//$m=$datepart_first_pay[1];
				//echo "<pre>".var_dump($m)."</pre>";
				$d=$datepart_first_pay[2];//$d=$datepart_next_pay[2];
				//var_dump($m);
				
				if ($m=="12") {$m="01";}
				else {$m=$m+1;
					if ($m>1 && $m<10) {
						$m="0".$m;
					}
				}
				$y=$y+(date('y')-$y);
				//echo $y." ".$m." ".$d;
				//echo $d."/".$m."/".$y;
				//echo "</pre>";
				?>
				<tr><td>First Payment Date:</td><td><?php echo date('d/m/y', strtotime($first_pay_details->date));?></td></tr>
				<tr><td>Next Payment Date:</td><td><?php echo $d."/".$m."/".$y;?></td></tr>
				
				<?php
				//$last_pay_details = mysqli_fetch_object(mysqli_query($connection, "SELECT iaid,amount FROM `invest_amount` WHERE uid = "32643290" AND iaid < (SELECT MAX( iaid ) FROM `invest_amount` WHERE uid = "32643290" ) ORDER BY iaid DESC LIMIT 1"));
				$last_pay_details = mysqli_fetch_object(mysqli_query($connection, "SELECT `iaid`,`amount`,`date`,`month` FROM `invest_amount` WHERE uid ='$row->uid' AND iaid < (SELECT MAX( iaid ) FROM `invest_amount` WHERE uid ='$row->uid' ) ORDER BY iaid DESC LIMIT 1"));
				?>
                <tr><td>Last Payment Date:</td><td><?php if($row_cnt->cnt==1){echo "N/A ";} else {echo date('d/m/y', strtotime($last_pay_details->date));}?></td></tr>
				<tr><td>Last Payment Amount Rs:</td><td><?php if(isset($last_pay_details->amount)){echo $last_pay_details->amount;} else {echo "N/A ";}?></td></tr>
                <?php
				//$last_pay_details = mysqli_fetch_object(mysqli_query($connection, "SELECT iaid,amount FROM `invest_amount` WHERE uid = "32643290" AND iaid < (SELECT MAX( iaid ) FROM `invest_amount` WHERE uid = "32643290" ) ORDER BY iaid DESC LIMIT 1"));
				$amount_paid_till_now = mysqli_fetch_object(mysqli_query($connection, "SELECT sum( amount ) 'a' FROM `invest_amount` WHERE uid ='$row->uid'"));
				?>
				<tr><td>Total Paid Amount Until Now:</td><td><?php if(isset($amount_paid_till_now->a)){echo $amount_paid_till_now->a;}?></td></tr>
                
                
                <tr><td>Current Paid Amount Rs:</td><td><?php echo $row->amount;?></td></tr>
                
                
                
            </table>
        </div>
		
		
        <div style="margin: 20px;"><button onclick='window.open("invest_done_print.php?id=<?=$_GET['id']?>","", "height=800, width=600, location=no, menubar=no, toolbar=no")'>Print</button></div>
    </div>
</div>
    
    <?php
include('footer.php');
?>

/home2/wtmwscom/public_html/admin/cgi-bin/../invest_done.php