Gecko [ 43.229.15.234 ]

Name	Size	Permission
ajaxselection.php	4.03 KB	-rw-r--r--
circleoffice.php	9.26 KB	-rw-r--r--
designation.php	9.16 KB	-rw-r--r--
districtoffice.php	9.2 KB	-rw-r--r--
empentryGraph.php	4.32 KB	-rw-r--r--
emplist_organogram.php	4.65 KB	-rw-r--r--
emplist_organogram_office.php	6.41 KB	-rw-r--r--
emplistexecutive.php	10.43 KB	-rw-r--r--
emplistexecutivesummary.php	6.98 KB	-rw-r--r--
emplistofficewise.php	10.06 KB	-rw-r--r--
emptime_all.php	9.67 KB	-rw-r--r--
emptime_all_circle.php	11.72 KB	-rw-r--r--
emptime_all_report.php	13.04 KB	-rw-r--r--
emptime_circleoffice.php	9.83 KB	-rw-r--r--
emptime_designation.php	9.96 KB	-rw-r--r--
emptime_designation_circleoffi...	9.94 KB	-rw-r--r--
emptime_designation_districtof...	9.85 KB	-rw-r--r--
emptime_designation_headoffice...	9.83 KB	-rw-r--r--
emptime_districtoffice.php	9.74 KB	-rw-r--r--
emptime_headoffice.php	9.72 KB	-rw-r--r--
graph_region.php	3.16 KB	-rw-r--r--
headoffice -backup.php	13.66 KB	-rw-r--r--
headoffice.php	13.7 KB	-rw-r--r--
hrmrole.php	491 B	-rw-r--r--
office.php	9.05 KB	-rw-r--r--
repGraph.php	2.69 KB	-rw-r--r--
rep_applicat_training.php	6.94 KB	-rw-r--r--
rep_applicatlist_training.php	7.38 KB	-rw-r--r--
rep_class_subject.php	8.38 KB	-rw-r--r--
rep_class_year.php	8.49 KB	-rw-r--r--
rep_directorate.php	7.96 KB	-rw-r--r--
rep_directorate_subject.php	8.4 KB	-rw-r--r--
rep_directorate_year.php	8.54 KB	-rw-r--r--
rep_lpr.php	10.2 KB	-rw-r--r--
rep_male_female.php	3.35 KB	-rw-r--r--
rep_religion.php	4.35 KB	-rw-r--r--
rep_training_circleoffice.php	5.53 KB	-rw-r--r--
rep_training_districtoffice.ph...	5.64 KB	-rw-r--r--
rep_training_headoffice.php	5.12 KB	-rw-r--r--
rep_userwise.php	8.65 KB	-rw-r--r--
rep_yearlist.php	8.18 KB	-rw-r--r--
report.php	564 B	-rw-r--r--
report_applicant_training.php	5.39 KB	-rw-r--r--
report_applicant_training_grap...	3.44 KB	-rw-r--r--
report_applicantlist_training....	8.81 KB	-rw-r--r--
report_editor.php	10.95 KB	-rw-r--r--
report_editor_offdesignation.p...	3.55 KB	-rw-r--r--
report_editor_time.php	10.07 KB	-rw-r--r--
report_editor_time_circle.php	4.8 KB	-rw-r--r--
report_prl.php	2.43 KB	-rw-r--r--
report_training.php	7.24 KB	-rw-r--r--
reportlist -backup.php	2.09 KB	-rw-r--r--
reportlist.php	3.33 KB	-rw-r--r--
reportlist_applicant_training....	957 B	-rw-r--r--
reportlist_applicantlist_train...	1.12 KB	-rw-r--r--
reportlist_offdesignation.php	664 B	-rw-r--r--
reportlist_time.php	1.22 KB	-rw-r--r--
reportlist_time_circle.php	641 B	-rw-r--r--
reportlist_training.php	1.2 KB	-rw-r--r--
salaccountsreport.php	39.81 KB	-rw-r--r--
salaccountsreport_govtid.php	12.41 KB	-rw-r--r--
training.php	7.37 KB	-rw-r--r--

Code Editor : rep_directorate_subject.php

<div class="container backcolor banglafont">
    <div class="row">
        <div class="col-md-12">
            <?php

// prepare and bind
                $stmt = $conn->prepare("SELECT * FROM directorate WHERE id = ? ORDER BY id ASC");
                $stmt->bind_param("i", $directorate_id);
                $stmt->execute();

//Result
                $result = $stmt->get_result();
                $numrows = $result->num_rows;

while ($row = $result->fetch_assoc()) {
                    $drdname = $row["dname"];
                }

// prepare and bind
                $stmt = $conn->prepare("SELECT * FROM casesubject WHERE id = ? ORDER BY id ASC");
                $stmt->bind_param("i", $casesubject_id);
                $stmt->execute();

//Result
                $result = $stmt->get_result();
                $numrows = $result->num_rows;

while ($row = $result->fetch_assoc()) {
                    $drsubname = $row["subname"];
                }

// prepare and bind
                $stmt = $conn->prepare("SELECT 
                c.id,
                c.caseno,																							
                c.casedate,												
                c.refno,	
                c.nothino,
                c.nothidate,
                c.badiname,
                c.badiaddress,
                c.bibadiname,		
                c.universityname,											
                c.answaredate,
                c.solicitorsdate,
                c.verdictdate,													
                c.casestatusdate,
                c.sntoappledate,
                c.aplverdictdate,	
                c.revverdate,
                c.adapstodate,											
                c.styearlist_id,
                c.dataentry_id,
                c.dataentrydate,
                c.verifyid_id,
                c.veryfydate,
                c.dataupd_id,
                c.dataupdate,

y.yname,
                cc.classdes,
                crt.courtname,
                adm.tribname,
                dc.districtname,
                ap.apname,
                pr.pname,
                cn.cnname,
                cs.subname,
                dr.dname,
                mn.mname,
                vl.vname,
                vc.cmname,
                adv.advname,
                st.stname,
                sty.yname styear,
                u.uname											
        FROM casebasic c 
             LEFT JOIN yearlist y ON(c.yearlist_id=y.id)
             LEFT JOIN caseclass cc ON(c.caseclass_id=cc.id)
             LEFT JOIN court crt ON(c.court_id=crt.id)
             LEFT JOIN admintribunal adm ON(c.admintribunal_id=adm.id)
             LEFT JOIN district dc ON(c.districtcourt_id=dc.id)
             LEFT JOIN applenote ap ON(c.applenote_id=ap.id)
             LEFT JOIN parameters pr ON(c.counternoscy_pid=pr.id)
             LEFT JOIN counterno cn ON(c.counternochairman_id=cn.id)
             LEFT JOIN casesubject cs ON(c.casesubject_id=cs.id)
             LEFT JOIN directorate dr ON(c.directorate_id=dr.id)
             LEFT JOIN ministrylist mn ON(c.ministrylist_id=mn.id)
             LEFT JOIN verdictlist vl ON(c.verdictlist_id=vl.id)
             LEFT JOIN verdictcomment vc ON(c.verdictcomment_id=vc.id)
             LEFT JOIN adminverdict adv ON(c.adminverdict_id=adv.id)
             LEFT JOIN casestatus st ON(c.casestatus_id=st.id)
             LEFT JOIN yearlist sty ON(c.styearlist_id=sty.id)
             LEFT JOIN userinfo u ON(c.dataentry_id=u.id)
        WHERE 1=1 and c.directorate_id=? and c.casesubject_id=? ORDER BY c.caseno");

$stmt->bind_param("ii",$directorate_id,$casesubject_id);
                $stmt->execute();

//Result
                $result = $stmt->get_result();
                $numrows=$result->num_rows;

if($numrows==0) exit('No rows');
                $slno=0;
?>
   <h4 class="text-center"> অধিদপ্তর/প্রতিষ্ঠান: <?=$drdname?>, মামলার বিষয়: <?=$drsubname?> <span class="noprint"> :: মামলা সংখ্যা-<?=bangladate($numrows)?></span></h4>
            <table class="table table-bordered table-striped table-condensed banglafont">

<thead>
                <th>ক্রম নং</th>
                <th> মামলা নং</th>       
                <th> মামলা শ্রেণী</th>             
                <th>মামলার বাদীর নাম ও ঠিকানা</th>                
                <th>মামলার বিবাদী/কনটেস্পনার</th>
                <th>মামলার রায়</th>
                <th>আপিলের অবস্থা</th>
                <th>সর্বশেষ অবস্থা</th>
                <th>মন্তব্য</th>
                </thead>

<tbody>

<hr/>
                <?php
                while($row = $result->fetch_assoc())
                {

$slno = $slno+1;								
                    $id = $row["id"];
                            $caseno = $row["caseno"];
                            $casedate = $row["casedate"];
                            $yname = $row["yname"];
                            $classdes = $row["classdes"];
                            $courtname = $row["courtname"];
                            $tribname = $row["tribname"];
                            $districtname = $row["districtname"];
                            $refno = $row["refno"];
                            $apname = $row["apname"];
                            $pname = $row["pname"];
                            $cnname = $row["cnname"];
                            $nothino = $row["nothino"];
                            $nothidate = $row["nothidate"];
                            $badiname = $row["badiname"];
                            $badiaddress = $row["badiaddress"];
                            $bibadiname = $row["bibadiname"];
                            $subname = $row["subname"];
                            $dname = $row["dname"];
                            $universityname = $row["universityname"];
                            $mname = $row["mname"];
                            $answaredate = $row["answaredate"];
                            $solicitorsdate = $row["solicitorsdate"];
                            $verdictdate = $row["verdictdate"];
                            $vname = $row["vname"];
                            $cmname = $row["cmname"];
                            $casestatus_id = $row["casestatus_id"];
                            $casestatusdate = $row["casestatusdate"];
                            $aplverdictdate = $row["aplverdictdate"];
                            $sntoappledate = $row["sntoappledate"];

$adapstodate = $row["adapstodate"];
                            $revverdate = $row["revverdate"];
                            $advname = $row["advname"];

$stname = $row["stname"];
                            $styear = $row["styear"];
                            $uname = $row["uname"];
                            $dataentrydate = $row["dataentrydate"];
                            $verifyid_id = $row["verifyid_id"];
                            $veryfydate = $row["veryfydate"];
                            $dataupd_id = $row["dataupd_id"];
                            $dataupdate = $row["dataupdate"];

<tr>

${this.title}

Code Editor : rep_directorate_subject.php