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 : salaccountsreport_govtid.php

<?php
 session_start();
 include("../homepage/header.php");
 include("../homepage/headermenu.php");
 include("../common/functions.php");
 include("../common/config.php");

if(empty($_SESSION["username"])) 
 {
   Header("Location: ../login/login.php");
  }

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

//Role
                include("../reports/hrmrole.php");

//for District Office
            $districtoffice_id=$_REQUEST["districtoffice_id"];
			if(!empty($districtoffice_id))
			{
				// prepare and bind
                $stmt = $conn->prepare("SELECT * FROM districtoffice WHERE id = ? ORDER BY id ASC");
                $stmt->bind_param("i", $districtoffice_id);
                $stmt->execute();

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

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

// prepare and bind
                $stmt = $conn->prepare("SELECT o.orderno, o.districtoffice_id,
                                                g.GovtId, g.NameB,
                                                gr.PayScale,
                                                ds.DesignationName,
                                                IFNULL(sal.salbasic,0) bsal,
                                                IFNULL(sal.houserent,0) houserent,
                                                IFNULL(sal.medical,0) medical,
                                                IFNULL(sal.srantibinodon,0) srantibinodon, 
                                                IFNULL(sal.education,0) education, 
                                                IFNULL(sal.spicial,0) spicial, 
                                                IFNULL(sal.preson,0) preson,
                                                IFNULL(sal.respon,0)  respon
                                                
                                        FROM `general` g
                                        LEFT JOIN salaccounts sal ON (sal.GovtId=g.GovtId)
                                        LEFT JOIN designation ds ON (g.designation_id=ds.id)
                                        LEFT JOIN grade gr ON(g.CurrScale_id=gr.id)
                                        LEFT JOIN office o 
                                            INNER JOIN districtoffice doff ON(o.districtoffice_id=doff.id)
                                            ON(g.office_id=o.id)											 
                                        WHERE 1=1 AND g.status_id=1 AND doff.id=? order by ds.desigslno");
										
			   //for error avoiding in dropdown				
                $stmt->bind_param("i",$districtoffice_id);
                $stmt->execute();

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

if($numrows==0) exit('No rows');
                $slno=0;
				$totbsal=0;
                $tothouserent=0;
                $totmedical=0;
                $totsrantibinodon=0;
                $totutsab=0;
                $totnoboborsha=0;
                $toteducation=0;
                $totspicial=0;
                $totpreson=0;
                $totrespon=0;
                $altot=0;
?>
                 <br/>				
                
				 <h4>অফিস :: <?=$drdistrictofficeName?> এর বাৎসরিক বেতন ভাতার প্রতিবেদন</h4>
				<table class="table table-bordered table-striped table-condensed">
    
                    <thead>
					<th>ক্রমিক নং</th>
                    <th>PIMS আইডি</th>
					<th>নাম</th>
                    <th>পদবি</th>
                    <th>স্কেল</th>
					<th>মূল বেতন</th>	
                    <th>বাড়ি ভাড়া</th>
                    <th>চিকিৎসা ভাতা</th>
                    <th>শ্রান্তি বিনোদন ভাতা</th>
                    <th>উৎসব ভাতা</th>	
                    <th>নববর্ষ ভাতা</th>	
                    <th>শিক্ষা সহায়ক ভাতা</th>	
                    <th>বিশেষ ভাতা</th>
                    <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'];
					$districtofficeName = $row['districtofficeName'];
                    $NameB = $row['NameB'];
                    $PayScale = $row['PayScale'];
                    $DesignationName = $row['DesignationName'];
                    $GovtId = $row['GovtId'];

$bsal = $row['bsal'];
                    $houserent = $row['houserent'];
                    $medical = $row['medical'];
                    $srantibinodon = $row['srantibinodon'];
                    $utsab = $row['utsab'];
                    $noboborsha = $row['noboborsha'];
                    $education = $row['education'];
                    $spicial = $row['spicial'];
                    $preson = $row['preson'];
                    $respon = $row['respon'];

$wash = $row['wash'];
                    $haor = $row['haor'];
                    $mauntain = $row['mauntain'];
                    $mobile = $row['mobile'];
                    $tifin = $row['tifin'];
                    $convayance = $row['convayance'];

$rtot=$bsal+$houserent+$medical+$srantibinodon
                          +$utsab+$noboborsha+$education+$spicial+$preson+$respon
                          +$wash+$haor+$mauntain+$mobile+$tifin+$convayance;

$totbsal=$totbsal+$bsal;
                    $tothouserent=$tothouserent+$houserent;
                    $totmedical=$totmedical+$medical;
                    $totsrantibinodon=$totsrantibinodon+$srantibinodon;
                    $totutsab=$totutsab+$utsab;
                    $totnoboborsha=$totnoboborsha+$noboborsha;
                    $toteducation=$toteducation+$education;
                    $totspicial=$totspicial+$spicial;
                    $totpreson=$totpreson+$preson;
                    $totrespon=$totrespon+$respon;

$totwash=$totwash+$wash;
                    $tothaor=$tothaor+$haor;
                    $totmauntain=$totmauntain+$mauntain;
                    $totmobile=$totmobile+$mobile;
                    $tottifin=$tottifin+$tifin;
                    $totconvayance=$totconvayance+$convayance;

$altot=$altot+$rtot;
                   
				
                    ?>

<?php   
     //তথ্য এন্ট্রির হিসাব
     $dentry=0;
     $notdentry=0;

$stmt = $conn->prepare("SELECT o.orderno, o.districtoffice_id,
                                    sal.salbasic
                            FROM `general` g
                            LEFT JOIN salaccounts sal ON (sal.GovtId=g.GovtId)
                            LEFT JOIN office o 
                                INNER JOIN districtoffice doff ON(o.districtoffice_id=doff.id)
                                ON(g.office_id=o.id)											 
                            WHERE 1=1 AND g.status_id=1 AND doff.id =?");
     
     $stmt->bind_param("i",$districtoffice_id);
     $stmt->execute();

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

while($row = $result->fetch_assoc())
        {
            $salbasic = $row['salbasic'];

if($salbasic>0){
                $dentry=$dentry+1;
            }else{
                $notdentry=$notdentry+1;
            }
        }

?>
<p class="text-danger">মোট <?=bangladate($dentry+$notdentry)?> জনের মধ্যে <?=bangladate($dentry)?>  জন বেতন ভাতার তথ্য এন্ট্রি করেছে। <?=bangladate($notdentry)?> জন এখনও করেনি।</p>

</div>
    </div>
</div>

${this.title}

Code Editor : salaccountsreport_govtid.php