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.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
			
                //1. প্রধান কার্যালয়
               	//Role
                include("../reports/hrmrole.php");

// prepare and bind
                $stmt = $conn->prepare("SELECT doff.id, doff.districtofficeName,
                                              IFNULL(empc.bsal,0) bsal,
                                              IFNULL(empc.houserent,0) houserent,
                                              IFNULL(empc.medical,0) medical,
                                              IFNULL(empc.srantibinodon,0) srantibinodon,
                                              IFNULL(empc.bsal,0)*2 utsab,
                                              IFNULL(empc.bsal,0)*0.2 noboborsha,
                                              IFNULL(empc.education,0) education,
                                              IFNULL(empc.spicial,0) spicial,
                                              IFNULL(empc.preson,0) preson,
                                              IFNULL(empc.respon,0) respon,

IFNULL(empc.wash,0) wash,
                                              IFNULL(empc.haor,0) haor,
                                              IFNULL(empc.mauntain,0) mauntain,
                                              IFNULL(empc.mobile,0) mobile,
                                              IFNULL(empc.tifin,0) tifin,
                                              IFNULL(empc.convayance,0) convayance
                                                
                                        FROM districtoffice doff LEFT JOIN
                                                (SELECT o.districtoffice_id,
                                                        SUM(sal.salbasic) bsal,
                                                        SUM(sal.houserent) houserent,
                                                        SUM(sal.medical) medical,
                                                        SUM(sal.srantibinodon) srantibinodon, 
                                                        SUM(sal.education) education, 
                                                        SUM(sal.spicial) spicial, 
                                                        SUM(sal.preson) preson,
                                                        SUM(sal.respon) respon,

SUM(sal.wash) wash,
                                                        SUM(sal.haor) haor,
                                                        SUM(sal.mauntain) mauntain,
                                                        SUM(sal.mobile) mobile,
                                                        SUM(sal.tifin) tifin,
                                                        SUM(sal.convayance) convayance
                                                         
                                                 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 ".$district."
                                                 GROUP BY o.districtoffice_id) empc
										ON(doff.id=empc.districtoffice_id)
                                        WHERE 1=1 AND doff.id=65 ORDER BY doff.districtofficeName");

//$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;

$totwash=0;
                $tothaor=0;
                $totmauntain=0;
                $totmobile=0;
                $tottifin=0;
                $totconvayance=0;

$altot=0;

//তথ্য এন্ট্রির হিসাব
                $dentry=0;
                $notdentry=0;
?>
                 <br/>				
                
				 <h4> প্রধান প্রকৌশলীর দপ্তর (প্রধান কার্যালয়) এর বাৎসরিক বেতন ভাতার প্রতিবেদন</h4>
				<table class="table table-bordered table-striped table-condensed">
    
                    <thead>
					<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'];
					$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
    //তথ্য এন্ট্রি গণনা
    $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=65");
    $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>

<?php
            //2.তত্বাবধায়ক প্রকৌসুলির কার্যালয়
            // prepare and bind
                $stmt = $conn->prepare("SELECT doff.id, doff.districtofficeName,
                                              IFNULL(empc.bsal,0) bsal,
                                              IFNULL(empc.houserent,0) houserent,
                                              IFNULL(empc.medical,0) medical,
                                              IFNULL(empc.srantibinodon,0) srantibinodon,
                                              IFNULL(empc.bsal,0)*2 utsab,
                                              IFNULL(empc.bsal,0)*0.2 noboborsha,
                                              IFNULL(empc.education,0) education,
                                              IFNULL(empc.spicial,0) spicial,
                                              IFNULL(empc.preson,0) preson,
                                              IFNULL(empc.respon,0) respon,

//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;

$totwash=0;
                $tothaor=0;
                $totmauntain=0;
                $totmobile=0;
                $tottifin=0;
                $totconvayance=0;

$altot=0;
?>
                 <br/>				
                
				 <h4> তত্ত্বাবধায়ক প্রকৌশলীর কার্যালয়ের বাৎসরিক বেতন ভাতার প্রতিবেদন</h4>
				<table class="table table-bordered table-striped table-condensed">
    
                    <thead>
					<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())
                {

$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 IN (66,67,68,69,70,71,72,73,74)");
    $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;
            }
        }

<?php
            //৩.নির্বাহি প্রকৌসুলির কার্যালয়
            // prepare and bind
                $stmt = $conn->prepare("SELECT doff.id, doff.districtofficeName,
                                              IFNULL(empc.bsal,0) bsal,
                                              IFNULL(empc.houserent,0) houserent,
                                              IFNULL(empc.medical,0) medical,
                                              IFNULL(empc.srantibinodon,0) srantibinodon,
                                              IFNULL(empc.bsal,0)*2 utsab,
                                              IFNULL(empc.bsal,0)*0.2 noboborsha,
                                              IFNULL(empc.education,0) education,
                                              IFNULL(empc.spicial,0) spicial,
                                              IFNULL(empc.preson,0) preson,
                                              IFNULL(empc.respon,0) respon,

IFNULL(empc.wash,0) wash,
                                              IFNULL(empc.haor,0) haor,
                                              IFNULL(empc.mauntain,0) mauntain,
                                              IFNULL(empc.mobile,0) mobile,
                                              IFNULL(empc.tifin,0) tifin,
                                              IFNULL(empc.convayance,0) convayance
                                                
                                        FROM districtoffice doff LEFT JOIN
                                                (SELECT  o.districtoffice_id,
                                                        SUM(sal.salbasic) bsal,
                                                        SUM(sal.houserent) houserent,
                                                        SUM(sal.medical) medical,
                                                        SUM(sal.srantibinodon) srantibinodon, 
                                                        SUM(sal.education) education, 
                                                        SUM(sal.spicial) spicial, 
                                                        SUM(sal.preson) preson,
                                                        SUM(sal.respon) respon,

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

$totwash=0;
                $tothaor=0;
                $totmauntain=0;
                $totmobile=0;
                $tottifin=0;
                $totconvayance=0;

$altot=0;
?>
                 <br/>				
                
				 <h4> নির্বাহি প্রকৌশলীর কার্যালয়ের বাৎসরিক বেতন ভাতার প্রতিবেদন</h4>
				<table class="table table-bordered table-striped table-condensed">
    
                    <thead>
					<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())
                {

$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 NOT IN (65,66,67,68,69,70,71,72,73,74)");
    $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;
            }
        }

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

${this.title}

Code Editor : salaccountsreport.php