অফিস ও পদবি ভিত্তিক জনবলের তালিকা

prepare("SELECT id, districtofficeName FROM districtoffice WHERE 1=1 order by districtofficeName"); $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; ?>

---

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

ক্রমিক নং	পদবি	অনুমোদিত পদ	বর্তমান জনবল	শূন্যপদ
মোট

মোট অনুমোদিত পদ	বর্তমান মোট জনবল	বর্তমান শূন্যপদ জনবল