Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
acceptqp.php	4.45 KB	-rw-rw-r--
addqptrancenter.php	2.13 KB	-rw-rw-r--
assignUserMenu.php	12.78 KB	-rw-rw-r--
assignmod.php	37.61 KB	-rw-rw-r--
availableqp.php	7.95 KB	-rw-rw-r--
changePwd.php	8.62 KB	-rw-rw-r--
deggrpCreation.php	2.84 KB	-rw-rw-r--
degreeCreation.php	4.07 KB	-rw-rw-r--
displayTempDet.php	8.07 KB	-rwxr-xr-x
eligibleQpSetter.php	4.09 KB	-rw-rw-r--
error_log.php	755 B	-rw-rw-r--
forgetPassword.php	4.62 KB	-rw-r--r--
generateBill.php	21.27 KB	-rw-r--r--
getTeacherlists.php	954 B	-rw-rw-r--
guidelines.php	578 B	-rw-rw-r--
login.php	19.3 KB	-rw-rw-r--
mapTeachersQbms.php	3.88 KB	-rw-rw-r--
modupdqp.php	17.15 KB	-rw-rw-r--
prepareQpNew.php	19.1 KB	-rw-rw-r--
preparethqp.php	30.91 KB	-rw-rw-r--
qpbankdet.php	1.47 KB	-rw-rw-r--
qpdaylog.php	433 B	-rw-rw-r--
qpfootnote.php	4.61 KB	-rw-rw-r--
qplog.php	938 B	-rw-rw-r--
qpmodreport.php	6.23 KB	-rw-rw-r--
qpsummary.php	6.9 KB	-rw-rw-r--
qptran.php	24.32 KB	-rw-rw-r--
registration.php	25.41 KB	-rw-rw-r--
saveAbstractForm.php	6.83 KB	-rw-rw-r--
select-final-qp.php	10.17 KB	-rw-rw-r--
selectqpsetter.php	59.35 KB	-rw-rw-r--
sendGridMail.php	1.72 KB	-rw-rw-r--
sendzohomail.php	1.46 KB	-rw-rw-r--
subjectCretion.php	8.58 KB	-rw-rw-r--
subqnwise.php	1.46 KB	-rw-rw-r--
teacherentry.php	10.29 KB	-rw-rw-r--
updqppattern.php	9.83 KB	-rw-rw-r--
uploadPassword.php	805 B	-rw-rw-r--
uploadqp.php	10.22 KB	-rw-rw-r--
usertype.php	5.14 KB	-rw-rw-r--
viewQPScr.php	18.14 KB	-rw-r--r--
wordFile.php	1.32 KB	-rw-rw-r--

Code Editor : generateBill.php

<?php
    function getTeahcerData($aobj_context){
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
        $univcode = $aobj_context->mobj_data["univcode"];
        
        $query = "select distinct m.fteachcode, mas.fteachname, CONCAT(m.fteachcode, '-', mas.fteachname) AS teachername from 
                moderator m inner join masteach mas on mas.fteachcode = m.fteachcode union 
                select distinct q.fteachcode, mas.fteachname, CONCAT(q.fteachcode, '-', mas.fteachname) AS teachername  from 
                qpseterdet q inner join masteach mas on mas.fteachcode = q.fteachcode";
        $result = $aobj_context->mobj_db->GetAll($query); 
        if($result){
            echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success");  
        }else{
            $arr['msg'] = 'No data found';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
        }
    }

function getTeachValDet($aobj_context){
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
        $univcode = $aobj_context->mobj_data["univcode"];
        $deggrp = $aobj_context->mobj_data["fdeggrp"];
        $degree = $aobj_context->mobj_data["fdegree"];
        $fsem = $aobj_context->mobj_data["fsem"];
        $freportopt = $aobj_context->mobj_data["freportopt"];
        $fteacher = $aobj_context->mobj_data["fteacher"];
        $ffrmDate = $aobj_context->mobj_data["ffrmDate"];
        $ftoDate = $aobj_context->mobj_data["ftoDate"];
        $fdisptype = $aobj_context->mobj_data["fdisptyp"];

if($freportopt == 'Teacher'){
            $cond = "q.fteachcode";
            $cond1 = "q.fqpfilepath";
            $cond2 = "fqpdtme";
        }else if($freportopt == 'Moderator'){
            $cond = "q.fmodteach";
            $cond1 = "q.fmodqpupd";
            $cond2 = "fmodqpdate";
        }

$degree_arr = explode(",", $degree);
        foreach($degree_arr as $key => $value){
            if($value != 'All')
                $degree_array .= "'".$value."',";
        }
        $degree_array = substr_replace($degree_array ,"",-1);
        
        if($degree_array != ""){
            $degreeCond = "and s.fdegree in ({$degree_array})";
        }

if($fsem != "All"){
            $fsemCond = "and d.fexamno ='{$fsem}'";
        }

$fteacher_arr = explode(",", $fteacher);

foreach($fteacher_arr as $key => $value){
            if($value != 'All')
                $fteacher_array .= "'".$value."',";
        }

$fteacher_array = substr_replace($fteacher_array ,"",-1);

if($fteacher_array != ""){
            $fteacherCond = "and $cond in ({$fteacher_array})";
        }

if($fdisptype == "All"){
            $dispcond = "";
        }else if($fdisptype == "Generated"){
            $dispcond = "and ifnull(q.fdocno,'') <> ''";
        }else if($fdisptype == "Pending"){
            $dispcond = "and ifnull(q.fdocno,'') = ''";
        }
        
        $query = "select m.fteachcode,m.fteachname,count($cond) ftotscrp,
            q.fset,q.fqpcode,if(ifnull(fdocno,'')='','F','F') as fcheck
            from qpseterdet q
            inner join masteach m on $cond = m.fteachcode
            inner join (select fqpcode from subject s inner join degree d on s.fdegree = d.fdegree
            and s.fexamno = d.fexamno
            where d.fdeggrp = '{$deggrp}' $fsemCond
            group by fqpcode) x on q.fqpcode = x.fqpcode 
            where date_format(q.$cond2,'%Y-%m-%d') between '{$ffrmDate}'
            and '{$ftoDate}'
            $dispcond
            $degreeCond
            $fteacherCond
            group by $cond
            having ftotscrp >0";
    // var_dump($query);die();
        $result = $aobj_context->mobj_db->GetAll($query); 
        if($result){
            echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success");  
        }else{
            $arr['msg'] = 'No data found';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
        }
    }

function saveValBillDet($aobj_context){
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
        $univcode = $aobj_context->mobj_data["univcode"];
        $findata = json_decode($aobj_context->mobj_data["finData"]);
        $fdeggrp = $aobj_context->mobj_data["fdeggrp"];
        $fdegree = $aobj_context->mobj_data["fdegree"];
        $fsem = $aobj_context->mobj_data["fsem"];
        $freportopt = $aobj_context->mobj_data["freportopt"];
        $fteacher = $aobj_context->mobj_data["fteacher"];
        $ffrmDate = $aobj_context->mobj_data["ffrmDate"];
        $ftoDate = $aobj_context->mobj_data["ftoDate"];
        $fuser = $aobj_context->mobj_data["fuser"];
        $fdisptype = $aobj_context->mobj_data["fdisptyp"];

if($freportopt == 'Teacher'){
            $cond = "q.fqpduser";
            $cond1 = "q.fqpfilepath";
            $cond2 = "fqpdtme";
        }else if($freportopt == 'Moderator'){
            $cond = "q.fmodteach";
            $cond1 = "q.fmodqpupd";
            $cond2 = "fmodqpdate";
        }

$degree_arr = explode(",", $fdegree);
        foreach($degree_arr as $key => $value){
            if($value != 'All')
                $degree_array .= "'".$value."',";
        }
        $degree_array = substr_replace($degree_array ,"",-1);
        
        if($degree_array != ""){
            $degreeCond = "and d.fdegree in ({$degree_array})";
        }

if($fsem != "All"){
            $fsemCond = "and d.fexamno ='{$fsem}'";
        }

$fteacher_arr = explode(",", $fteacher);
        foreach($fteacher_arr as $key => $value){
            if($value != 'All')
                $fteacher_array .= "'".$value."',";
        }
        $fteacher_array = substr_replace($fteacher_array ,"",-1);

if($fteacher_array != ""){
            $fteacherCond = "and $cond in ({$fteacher_array})";
        }
 
        $query = "INSERT INTO tdvs_docno (FDEGGRP,FDEGREE,FEXAMNO,FREPORTYPE,
            FTEACHCODE,FFROMDATE,FTODATE,FUPDUSER,FUPDTIME,FDELETED)
            VALUES('{$fdeggrp}','{$fdegree}','{$fsem}','{$freportopt}',
            '{$fteacher}','{$ffrmDate}','{$ftoDate}','{$fuser}',now(),'F')";
        $result = $aobj_context->mobj_db->Execute($query);
        $docNo = $aobj_context->mobj_db->Insert_id();

if($freportopt == 'Teacher'){
            $query10 = "update qpseterdet set fdocno='' where date_format(fqpdtme,'%Y-%m-%d') between '{$ffrmDate}'
                        and '{$ftoDate}' and fqpcode in (select fqpcode from subject s inner join degree d on s.fdegree = d.fdegree
                        and s.fexamno = d.fexamno
                        where d.fdeggrp = '{$fdeggrp}' and ifnull(fqpcode, '')<>''
                        group by fqpcode)";

// var_dump($query10);die();
            $res10 = $aobj_context->mobj_db->Execute($query10);
        }else if($freportopt == 'Moderator'){
            $query10 = "update qpseterdet set fmoddocno='' where date_format(fmodqpdate,'%Y-%m-%d') between '{$ffrmDate}'
                        and '{$ftoDate}' and fqpcode in (select fqpcode from subject s inner join degree d on s.fdegree = d.fdegree
                        and s.fexamno = d.fexamno
                        where d.fdeggrp = '{$fdeggrp}' and ifnull(fqpcode, '')<>''
                        group by fqpcode)";

// var_dump($query10);die();
            $res10 = $aobj_context->mobj_db->Execute($query10);
        }
        
        foreach($findata as $val)
        {
            if($val->fcheck == 'T'){
                if($freportopt == 'Teacher'){
                    if($univcode == '030')
                    {
                        $insertPayhead = "INSERT INTO tdvs_payhead (FDOCNO,FDEGGRP,FBILLDATE,FBILLTYPE,FYEAR,
                        FEXAMTYPE,FTEACHCODE,FDAYS,FTOTAL,fteachname,fmobileno,
                        femail,fbankname,faccno,
                        fifsccode,faadharno,fpanno,fqtotal,FCREATDATE,fsubname)
                        select '$docNo','$fdeggrp',now(),'QPMS','2222','2',m.fteachcode,'',
                        (sum(qpcnt)*1200) as fstot,
                        m.fteachname,m.fmobile,m.femail,
                        m.FBANKNAME,m.faccno,m.FIFSCCODE,
                        m.faccno,m.fpanno,sum(qpcnt) as totcnt,now(),
                        group_concat(concat(q.fsubname,' - ',q.fsubshort,' Max. Maks: ',fmaxmarks,' ( ',qpcnt,' ) ') order by q.fsubshort SEPARATOR ', ')as fsubname
                        from(select q.fteachcode,s.fsubname,s.fsubshort,q.fqpcode,fyear,fexamtype, 
                        s.fmaxmarks,
                        if(ifnull(q.fqpcode, '')<> '',1,0) as qpcnt,
                        if(s.fmaxmarks >= '50',if(left(fdeggrp,2) = 'UG',1200,1200),0)as f100,
                        if(s.fmaxmarks >=20 and s.fmaxmarks <=40,1200,1200) as f40,
                        if(s.fmaxmarks <20,1200,1200) as  f20
                        from qpseterdet q 
                        inner join subject s on q.fqpcode = s.fqpcode
                        inner join degree d on d.fdegree = s.fdegree 
                        and d.fexamno = s.fexamno
                        where fyear='2222' and fexamtype='2'
                        and ifnull(fqpfilepath,'') <> ''
                        and date_format(q.fqpdtme,'%Y-%m-%d') between '{$ffrmDate}'
                        and '{$ftoDate}' and d.fdeggrp = '{$fdeggrp}'
                        and ifnull(q.FDOCNO,'') = ''
                        $degreeCond
                        $fsemCond
                        $fteacherCond
                        group by q.fteachcode,q.fqpcode,q.fset) q
                        inner join masteach m on q.fteachcode = m.fteachcode 
                        where q.fyear='2222' and q.fexamtype='2' 
                        and q.fteachcode = '{$val->fteachcode}'
                        group by q.fteachcode";
                        
                    }else if($univcode == '061')
                    {
                        $insertPayhead = "INSERT INTO tdvs_payhead (FDOCNO,FDEGGRP,FBILLDATE,FBILLTYPE,FYEAR,
                        FEXAMTYPE,FTEACHCODE,FDAYS,FTOTAL,fteachname,fmobileno,
                        femail,fbankname,faccno,
                        fifsccode,faadharno,fpanno,fqtotal,FCREATDATE,fsubname)
                        select '$docNo','$fdeggrp',now(),'QPMS','2222','2',m.fteachcode,'',
                        (sum(qpcnt)*1500) as fstot,
                        m.fteachname,m.fmobile,m.femail,
                        m.FBANKNAME,m.faccno,m.FIFSCCODE,
                        m.faccno,m.fpanno,sum(qpcnt) as totcnt,now(),
                        group_concat(concat(q.fsubname,' - ',q.fsubshort,' Max. Maks: ',fmaxmarks,' ( ',qpcnt,' ) ') order by q.fsubshort SEPARATOR ', ')as fsubname
                        from(select q.fteachcode,s.fsubname,s.fsubshort,q.fqpcode,fyear,fexamtype, 
                        s.fmaxmarks,
                        if(ifnull(q.fqpcode, '')<> '',1,0) as qpcnt,
                        if(s.fmaxmarks >= '50',if(left(fdeggrp,2) = 'UG',1500,1500),0)as f100,
                        if(s.fmaxmarks >=20 and s.fmaxmarks <=40,1500,1500) as f40,
                        if(s.fmaxmarks <20,1500,1500) as  f20
                        from qpseterdet q 
                        inner join subject s on q.fqpcode = s.fqpcode
                        inner join degree d on d.fdegree = s.fdegree 
                        and d.fexamno = s.fexamno
                        where fyear='2222' and fexamtype='2'
                        and ifnull(q.fqpdtme,'') <> ''
                        and date_format(q.fqpdtme,'%Y-%m-%d') between '{$ffrmDate}'
                        and '{$ftoDate}' and d.fdeggrp = '{$fdeggrp}'
                        and ifnull(q.FDOCNO,'') = ''
                        $degreeCond
                        $fsemCond
                        $fteacherCond
                        group by q.fteachcode,q.fqpcode,q.fset) q
                        inner join masteach m on q.fteachcode = m.fteachcode 
                        where q.fyear='2222' and q.fexamtype='2' 
                        and q.fteachcode = '{$val->fteachcode}'
                        group by q.fteachcode";
                    }
                    else
                    {
                        
                        $insertPayhead = "INSERT INTO tdvs_payhead (FDOCNO,FDEGGRP,FBILLDATE,FBILLTYPE,FYEAR,
                        FEXAMTYPE,FTEACHCODE,FDAYS,FTOTAL,fteachname,fmobileno,
                        femail,fbankname,faccno,
                        fifsccode,faadharno,fpanno,fqtotal,FCREATDATE,fsubname)
                        select '$docNo','$fdeggrp',now(),'QPMS','2222','2',m.fteachcode,'',
                        (sum(f100) + sum(f40) + sum(f20)) as fstot,
                        m.fteachname,m.fmobile,m.femail,
                        m.FBANKNAME,m.faccno,m.FIFSCCODE,
                        m.faccno,m.fpanno,sum(qpcnt) as totcnt,now(),
                        group_concat(concat(q.fsubname,' - ',q.fsubshort,' Max. Maks: ',fmaxmarks,' ( ',qpcnt,' ) ') order by q.fsubshort SEPARATOR ', ')as fsubname
                        from(select q.fteachcode,s.fsubname,s.fsubshort,q.fqpcode,fyear,fexamtype, 
                        s.fmaxmarks,
                        if(ifnull(q.fqpcode, '')<> '',1,0) as qpcnt,
                        if(s.fmaxmarks >= '50',if(left(fdeggrp,2) = 'UG',600,900),0)as f100,
                        if(s.fmaxmarks >=20 and s.fmaxmarks <=40,250,0) as f40,
                        if(s.fmaxmarks <20,100,0) as  f20
                        from qpseterdet q 
                        inner join subject s on q.fqpcode = s.fqpcode
                        inner join degree d on d.fdegree = s.fdegree 
                        and d.fexamno = s.fexamno
                        where fyear='2222' and fexamtype='2'
                        and ifnull(q.FDOCNO,'') = ''
                        and date_format(q.fqpdtme,'%Y-%m-%d') between '{$ffrmDate}'
                        and '{$ftoDate}' and d.fdeggrp = '{$fdeggrp}'
                        $degreeCond
                        $fsemCond
                        $fteacherCond
                        group by q.fteachcode,q.fqpcode,q.fset) q
                        inner join masteach m on q.fteachcode = m.fteachcode 
                        where q.fyear='2222' and q.fexamtype='2' 
                        and q.fteachcode = '{$val->fteachcode}'
                        group by q.fteachcode";

// var_dump($insertPayhead);die();
                    }
                }else if($freportopt == 'Moderator'){
                    if($univcode == '030')
                    {
                        $insertPayhead = "INSERT INTO tdvs_payhead (FDOCNO,FDEGGRP,FBILLDATE,FBILLTYPE,FYEAR,FEXAMTYPE,
                        FTEACHCODE,FDAYS,FTOTAL,fteachname,fmobileno,femail,fbankname,faccno,
                        fifsccode,faadharno,fpanno,fqtotal,FCREATDATE,fsubname)
                        select '$docNo','$fdeggrp',now(),'QPMS','2222','2',m.fteachcode,'',
                        sum(s.total) as total,m.fteachname,m.fmobile,m.femail,
                        m.FBANKNAME,m.faccno,m.FIFSCCODE,m.faccno,m.fpanno,sum(s.count)as totcnt,now(),
                        group_concat(concat(s.fsubname,' - ',s.fsubshort,' Max. Maks: ',s.fmaxmarks,' ( ',count,' ) ') order by s.fsubshort SEPARATOR ', ')as fsubname
                        from(select mo.fteachcode,s.fsubname, s.fsubshort,s.fmaxmarks, mo.fqpcode, 
                        mo.fyear, mo.fexamtype, s.fexamno, s.fdegree,
                        if(mo.fqpcode <> '', 1, 0)as count,
                        if(mo.fqpcode <> '', 1200,0)as total
                        from moderator mo 
                        inner join subject s on s.fqpcode = mo.fqpcode
                        inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno
                        inner join qpseterdet q on mo.fqpcode = q.fqpcode 
                        and ifnull(q.fmodqpupd,'') <> ''
                        where mo.fyear='2222' and mo.fexamtype='2'
                        and date_format(q.fqpdtme,'%Y-%m-%d') between '{$ffrmDate}'
                        and '{$ftoDate}' and d.fdeggrp = '{$fdeggrp}'
                        $degreeCond
                        $fsemCond
                        $fteacherCond
                        group by mo.fteachcode, mo.fqpcode) s
                        inner join masteach m on m.fteachcode = s.fteachcode 
                        where s.fyear='2222' and s.fexamtype='2'     
                        and s.fteachcode = '{$val->fteachcode}'
                        group by s.fteachcodexx";
                    }else
                    {

$insertPayhead = "INSERT INTO tdvs_payhead (FDOCNO,FDEGGRP,FBILLDATE,FBILLTYPE,FYEAR,FEXAMTYPE,
                        FTEACHCODE,FDAYS,FTOTAL,fteachname,fmobileno,femail,fbankname,faccno,
                        fifsccode,faadharno,fpanno,fqtotal,FCREATDATE,fsubname)
                        select '$docNo','$fdeggrp',now(),'QPMS','2222','2',m.fteachcode,'',
                        sum(s.total) as total,m.fteachname,m.fmobile,m.femail,
                        m.FBANKNAME,m.faccno,m.FIFSCCODE,m.faccno,m.fpanno,sum(s.count)as totcnt,now(),
                        group_concat(concat(s.fsubname,' - ',s.fsubshort,' Max. Maks: ',s.fmaxmarks,' ( ',count,' ) ') order by s.fsubshort SEPARATOR ', ')as fsubname
                        from(select mo.fteachcode,s.fsubname, s.fsubshort,s.fmaxmarks, mo.fqpcode, 
                        mo.fyear, mo.fexamtype, s.fexamno, s.fdegree,
                        if(mo.fqpcode <> '', 1, 0)as count,
                        if(mo.fqpcode <> '', 700,0)as total
                        from moderator mo 
                        inner join subject s on s.fqpcode = mo.fqpcode
                        inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno
                        inner join qpseterdet q on mo.fqpcode = q.fqpcode 
                        and ifnull(q.fmodqpupd,'') <> ''
                        where mo.fyear='2222' and mo.fexamtype='2'
                        and date_format(q.fqpdtme,'%Y-%m-%d') between '{$ffrmDate}'
                        and '{$ftoDate}' and d.fdeggrp = '{$fdeggrp}'
                        $degreeCond
                        $fsemCond
                        $fteacherCond
                        group by mo.fteachcode, mo.fqpcode) s
                        inner join masteach m on m.fteachcode = s.fteachcode 
                        where s.fyear='2222' and s.fexamtype='2'     
                        and s.fteachcode = '{$val->fteachcode}'
                        group by s.fteachcode";

}
        // var_dump($insertPayhead);die();

}
                $res = $aobj_context->mobj_db->Execute($insertPayhead);

$insetpaydet = "insert into tdvs_paydetl (FBILLNO,FDOCNO,FBILLTYPE,
                FTEACHCODE,FHEADCODE,FAMOUNT,FREMARKS,FCREATEDATE)
                select FBILLNO,FDOCNO,'QPMS',FTEACHCODE,'QP',FTOTAL,fsubname,now() 
                from tdvs_payhead 
                where fteachcode = '{$val->fteachcode}' and fyear='2222' and fexamtype='2'";
                // var_dump($insetpaydet);die();

$res2 = $aobj_context->mobj_db->Execute($insetpaydet);

if($freportopt == 'Teacher'){
                    $cond3 = "fqpduser";
                    $cond4 = "fdocno";
                }else if($freportopt == 'Moderator'){
                    $cond3 = "fmodteach";
                    $cond4 = "fmoddocno";
                }

$update = "update qpseterdet set $cond4 = '{$docNo}'
                        where $cond3 = '{$val->fteachcode}' 
                        and fqpcode = '{$val->fqpcode}' 
                        and fset = '{$val->fset}' 
                        and fyear = '2222' 
                        and fexamtype = '2'";

// var_dump($update);die();
                $qpres = $aobj_context->mobj_db->Execute($update);
            }
        }

if($qpres){
            $arr['msg'] = 'Successfully Updated';
            echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success");
        }else{
            $arr['msg'] = 'Something went wrong please try later';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
        }
    }

function getGenerateBillReport($aobj_context){
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
        $univcode = $aobj_context->mobj_data["univcode"];
        $ftype = $aobj_context->mobj_data["ftype"];
        $cond = "";

if($ftype != "All")
            $cond = "where FREPORTYPE = '{$ftype}'";

$query = "select * from tdvs_docno $cond order by fdocno desc";
        $result = $aobj_context->mobj_db->GetAll($query);

if($result){
            echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success");  
        }else{
            $arr['msg'] = 'No data found';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
        }
    }
?>

${this.title}

Code Editor : generateBill.php