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

<div class="container backcolor fullheight">
    <div class="row">
        <div class="col-md-12">
		<br/>
		<h3>অফিস ও পদবি ভিত্তিক জনবলের তালিকা</h3>
            <?php
				//Role
				include("../reports/hrmrole.php");

/****************************
                 District office Data entry
                *****************************/
                /*
                $stmt = $conn->prepare("SELECT id AS offid FROM  office
                WHERE activity=1 AND id NOT IN (492,558,559,560,561,562,563,564,565,566)
                order by id");                              
				$stmt->execute();
                $inst = $stmt->get_result();

while ($row = $inst->fetch_assoc()) {
                    $offid = $row["offid"];

$stmt = $conn->prepare('INSERT INTO officeemployee(office_id, designation_id, nopost)
                    SELECT ?, designation_id, nopost FROM dataemp');

$stmt->bind_param("i", $offid);                                                 
                    $stmt->execute();

}

//সহকারি প্রশাসনিক কর্মকর্তা
                IN (494,495,496,498,501,503,505,506,507,509,514,517,518,519,522,523,524,528,530,532,534,535,538,539,543,544,546,547,549,553,554,556)
               */
            
                /**********************************************************
                 No of Upazila for D.E Operrator, SAE, Office shohayak Post
                ***********************************************************/
                /*
                $stmt = $conn->prepare("SELECT a.districtoffice_id, b.id,a.upz from
                    (SELECT districtoffice_id,count(id) AS upz FROM office where activity=0
                    group by districtoffice_id) a,
                    (SELECT districtoffice_id,id FROM office where activity=1) b 
                    WHERE a.districtoffice_id=b.districtoffice_id");                              
				$stmt->execute();
                $stmupz = $stmt->get_result();

while ($row = $stmupz->fetch_assoc()) {
                    $id = $row["id"];
                    $upz = $row["upz"];

$stmt = $conn->prepare("UPDATE officeemployee set nopost=nopost+?
                                        WHERE designation_id IN (24,41,48) AND office_id=?");

$stmt->bind_param("ii", $upz,$id);                                                 
                    $stmt->execute();

}
               
                */

// prepare and bind
                $stmt = $conn->prepare("SELECT id, districtofficeName FROM districtoffice 
										WHERE 1=1 AND id=? order by districtofficeName");

$stmt->bind_param("i", $_POST["districtoffice_id"]);                
				$stmt->execute();

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

$emocount=0;
                $gtapemp=0;
                $gtcemp=0;
                while ($row = $resultoffice->fetch_assoc()) {
                    $districtofficeName = $row["districtofficeName"];
					$office_id = $row["id"];
					
              
                // prepare and bind
                $stmt = $conn->prepare("SELECT tt.districtoffice_id,tt.designation_id, ds.DesignationName,d.districtofficeName, SUM(tt.nopost) nopost, COUNT(tt.cp) cp FROM
											(SELECT o.districtoffice_id, g.designation_id, 0 nopost,g.GovtId cp FROM `general` g, office o
                                              WHERE g.office_id=o.id AND g.status_id=1

UNION
											SELECT o.districtoffice_id, e.designation_id, e.nopost, NULL cp FROM officeemployee e, office o
                                            WHERE e.office_id=o.id) tt
										LEFT JOIN designation ds ON (tt.designation_id=ds.id)
										LEFT JOIN districtoffice d ON (tt.districtoffice_id=d.id)
										WHERE tt.districtoffice_id=?
										GROUP BY tt.districtoffice_id,tt.designation_id ORDER BY ds.desigslno");
			
			   //for error avoiding in dropdown				
               $stmt->bind_param("i",$office_id);
                $stmt->execute();

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

//if($numrows==0) exit('No rows');
                 $slno=0;
				 $tnopost=0;
				 $tcp=0;
?>
                 <br/>				
                <h4><?=$districtofficeName?></h4>
                
				<table class="table table-bordered table-striped table-condensed">
    
                    <thead>
					<th class="text-center">ক্রমিক নং</th>										
					<th>পদবি</th>
					<th class="text-center">অনুমোদিত পদ</th>			
					<th class="text-center">বর্তমান জনবল</th>	
                    <th class="text-center">শূন্যপদ</th>						
                    </thead>
    
                    <tbody>
    
                    <hr/>
                    <?php
            
                while($row = $result->fetch_assoc())
                {

$slno = $slno+1;	
					$DesignationName = $row['DesignationName'];
					$nopost = $row['nopost'];
					$cp = $row['cp'];

$tnopost=$tnopost+$nopost;
					$tcp=$tcp+$cp;

$gtapemp=$gtapemp + $nopost;
                    $gtcemp=$gtcemp + $cp;
								
				
                    ?>

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

${this.title}

Code Editor : emplist_organogram_office.php