$a="<table class='nitya'><tr><th> Fees </th><th> Amount</th><th> Paid</th><th> Pending</th><th></th></tr>";
// Institution wide pick
$rs = DB::Query("SELECT
SUM(amount) AS amount,
if(`1`=1, 1, if(`2`=1,2,if(`3`=1,3,if(`4`=1,4,if(`6`=1,6,if(`7`=1,7,if(`8`=1,8,if(`9`=1,9,if(`10`=1, 10, 0))))))))) AS `type`
FROM fees_school_wide_table
WHERE (ay ='$ay') AND (fees_category ='$fc') AND (status ='Active')
GROUP BY `1`, `2`, `3`, `4`, `6`, `7`, `8`, `9`, `10`");
while($data1 = db_fetch_array($rs))
{
${'ct'.$data1["type"]}=${'ct'.$data1["type"]}+$data1["amount"];
$tot = $tot + $data1["amount"];
}
// class wise pick
$rs = DB::Query("SELECT
SUM(amount) AS amount,
if(`1`=1, 1, if(`2`=1,2,if(`3`=1,3,if(`4`=1,4,if(`6`=1,6,if(`7`=1,7,if(`8`=1,8,if(`9`=1,9,if(`10`=1, 10, 0))))))))) AS `type`
FROM fees_class_wise_table
WHERE (ay ='$ay') AND (fees_category ='$fc') AND (status ='Active') AND (`class` ='$class')
GROUP BY `1`, `2`, `3`, `4`, `6`, `7`, `8`, `9`, `10`");
while($data1 = db_fetch_array($rs))
{
${'ct'.$data1["type"]}=${'ct'.$data1["type"]}+$data1["amount"];
$tot = $tot + $data1["amount"];
}
// Individual pick
$rs = DB::Query("SELECT
ay,
SUM(amount) AS amount,
if(`1`=1, 1, if(`2`=1,2,if(`3`=1,3,if(`4`=1,4,if(`6`=1,6,if(`7`=1,7,if(`8`=1,8,if(`9`=1,9,if(`10`=1, 10, 0))))))))) AS `type`,
student_reg_no
FROM fees_individual_table
WHERE (ay ='$ay') AND (student_reg_no ='$stu') AND (transp_id IS NULL)
GROUP BY `1`, `2`, `3`, `4`, `6`, `7`, `8`, `9`, `10`");
while($data1 = db_fetch_array($rs))
{
${'ct'.$data1["type"]}=${'ct'.$data1["type"]}+$data1["amount"];
$tot = $tot + $data1["amount"];
}
// Transport pick
$rs = DB::Query("SELECT
ay,
SUM(amount) AS amount,
5 AS `type`,
student_reg_no
FROM fees_individual_table
WHERE (ay ='$ay') AND (student_reg_no ='$stu') AND (transp_id IS NOT NULL)
GROUP BY ay, student_reg_no, transp_id, collect_as_oth, collect_as_donation, collect_as_misc");
while($data1 = db_fetch_array($rs))
{
${'ct'.$data1["type"]}=${'ct'.$data1["type"]}+$data1["amount"];
$tot = $tot + $data1["amount"];
}
$cnt =0;
$rs = DB::Query("SELECT * FROM fees_collection_label ORDER BY priority, ftlbid ");
while($data1 = db_fetch_array($rs))
{
$cnt = $data1["ftlbid"];
if(${'ct'.$cnt}>1)
{
$rs1 = DB::Query("SELECT
SUM(fees_payment_details_table.amount) AS amount,
fees_payment_details_table.ay,
fees_payment_details_table.student,
if(fees_payment_table.`type`='transport', '5', if(`1`=1, 1, if(`2`=1,2,if(`3`=1,3,if(`4`=1,4,if(`6`=1,6,if(`7`=1,7,if(`8`=1,8,if(`9`=1,9,if(`10`=1, 10, 0)))))))))) AS `type`
FROM fees_payment_details_table
INNER JOIN fees_payment_table ON fees_payment_details_table.fp_id = fees_payment_table.fp_id
WHERE (fees_payment_details_table.ay ='".$ay."') AND (fees_payment_details_table.student ='".$stu."') AND (if(fees_payment_table.`type`='transport', '5', if(`1`=1, 1, if(`2`=1,2,if(`3`=1,3,if(`4`=1,4,if(`6`=1,6,if(`7`=1,7,if(`8`=1,8,if(`9`=1,9,if(`10`=1, 10, 0)))))))))) ='".$cnt."') AND (fees_payment_table.status !='Pending')
GROUP BY fees_payment_details_table.ay, fees_payment_details_table.student, fees_payment_table.`type`, `1`, `2`, `3`, `4`, `6`, `7`, `8`, `9`, `10`");
$data2 = db_fetch_array($rs1);
$paid = $paid+$data2["amount"];
if((${'ct'.$cnt}-$data2['amount']) >0)
{
$lnk = "<a href='fee_payment_list.php?masterkey1=".$ay."&masterkey2=".$stu."&mastertable=fee_collection&fc=".$cnt."'><button class='btn btn-labeled btn-primary'> Payment </button></a>";
}
else
{
$lnk ='';
}
$a = $a."<tr><td><p align='left'>".$data1["label"]."</p></td><td><p align='right'>".number_format(${'ct'.$cnt},2)."</p></td><td><p align='right'>".number_format($data2['amount'],2)."</p></td><td><p align='right'>".number_format((${'ct'.$cnt}-$data2['amount']),2)."</p></td><td>".$lnk."</td></tr>";
}
}
if($tot >0)
{
$a = $a."<tr><th>Total</th><th>".number_format($tot,2)."</th><th>".number_format($paid,2)."</th><th>".number_format(($tot-$paid),2)."</th><th></th></tr>";
$v = $a."</table>";
$v = $v."<a href='fee_bulk_payment_list.php?masterkey1=".$ay."&masterkey2=".$stu."&mastertable=fee_collection'><button class='btn btn-labeled btn-primary'> Bulk Generation </button></a>";
}
else {$v ="";}