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 : report_editor.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 fullheight">
    <div class="row">
        <div class="col-md-8 col-md-offset-2">
           <br/>
           <br/>
           <div><font class="headline">জনবলের প্রতিবেদনের জন্য তথ্য বাছাই করুন</font></div>
           <div style="background-color: #ff0000;height: 2px">&nbsp;</div>

<br/>

<?php
  if(($_SESSION['userrole_id']==1) OR ($_SESSION['userrole_id']==2) OR ($_SESSION['userrole_id']==3)){
?>			           
              <div class="form-group">
                    <label class="col-md-5 control-label">প্রধান প্রকৌশলীর কার্যালয় ও তার আওতাভিত্তিক অফিস</label>
                    <div class="col-md-5">
                    <select   name="headoffice_id" id="headoffice_id"  class="form-control">
                          <option value="">--Select--</option>
                          <?php
                              // prepare and bind
                              $stmt = $conn->prepare("SELECT * FROM headoffice");
                              $stmt->execute();

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

while($row = $result->fetch_assoc())
                              {

$id = $row["id"];
                                  $offname = $row['offname'];
                        ?>
                        
                      <option value="<?=$id?>" <?php if($id==$headoffice_id) echo "selected"; ?>><?=$offname?></option>
                        <?php
                            }	
                          ?>
                      </select>                      
                    </div>
               </div>

<?php
  }
  if(($_SESSION['userrole_id']==1) OR ($_SESSION['userrole_id']==2) OR ($_SESSION['userrole_id']==3) OR ($_SESSION['userrole_id']==5)){
?>
								
               <div class="form-group">
                    <label class="col-md-5 control-label">তত্ত্বাবধায়ক প্রকৌশলীর কার্যালয় ও তার আওতাভিত্তিক অফিস</label>
                    <div class="col-md-5">
                    <select   name="circleoffice_id" id="circleoffice_id"  class="form-control">
                          <option value="">--Select--</option>
                          <?php
                              // prepare and bind
                              if($_SESSION['userrole_id']==5){
                                $stmt = $conn->prepare("SELECT * FROM circleoffice WHERE id NOT IN (10) AND id=?");
                                $stmt->bind_param("i", $_SESSION["circleoffice_id"]);
                              } 
                              else{
                              $stmt = $conn->prepare("SELECT * FROM circleoffice WHERE id NOT IN (10)");
                              }
                              $stmt->execute();

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

while($row = $result->fetch_assoc())
                              {

$id = $row["id"];
                                  $circleofficeName = $row["circleofficeName"];
                        ?>
                        
                      <option value="<?=$id?>" <?php if($id==$circleoffice_id) echo "selected"; ?>><?=$circleofficeName?></option>
                        <?php
                            }	
                          ?>
                      </select>                      
                    </div>
               </div>
	
<?php
  }
?>               
               <div class="form-group">
                    <label class="col-md-5 control-label">নির্বাহী প্রকৌশলীর কার্যালয় ও তার আওতাভিত্তিক অফিস</label>
                    <div class="col-md-5">
                    <select   name="districtoffice_id" id="districtoffice_id"  class="form-control">
                          <option value="">--Select--</option>
                          <?php
                              // prepare and bind
                              if($_SESSION['userrole_id']==5){
                                $stmt = $conn->prepare("SELECT * FROM districtoffice WHERE id NOT IN (65,66,67,68,69,70,71,72,73,74) AND circleoffice_id=?");
                                $stmt->bind_param("i", $_SESSION["circleoffice_id"]);
                              } 
                              elseif($_SESSION['userrole_id']==6){
                                $stmt = $conn->prepare("SELECT * FROM districtoffice WHERE id NOT IN (65,66,67,68,69,70,71,72,73,74) AND id=?");
                                $stmt->bind_param("i", $_SESSION["districtoffice_id"]);
                              }                          
                              else{
                              $stmt = $conn->prepare("SELECT * FROM districtoffice WHERE id NOT IN (65,66,67,68,69,70,71,72,73,74)");
                              }
                              $stmt->execute();

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

while($row = $result->fetch_assoc())
                              {

$id = $row["id"];
                                  $districtofficeName = $row["districtofficeName"];
                        ?>
                        
                      <option value="<?=$id?>" <?php if($id==$districtoffice_id) echo "selected"; ?>><?=$districtofficeName?></option>
                        <?php
                            }	
                          ?>
                      </select>                      
                    </div>
               </div>

<div class="form-group">
                    <label class="col-md-5 control-label">কার্যালয় ভিত্তিক প্রতিবেদন</label>
                    <div class="col-md-5">
                    <select   name="office_id" id="office_id"  class="form-control">
                          <option value="">--Select--</option>
                          <?php
                              // prepare and bind
                              if($_SESSION['userrole_id']==5){
                                $stmt = $conn->prepare("SELECT o.id,o.OfficeName FROM office o, districtoffice d
                                WHERE o.activity=1 AND d.id=o.districtoffice_id AND d.circleoffice_id=? ORDER BY o.orderno");
                                $stmt->bind_param("i", $_SESSION["circleoffice_id"]);
                              } 
                              elseif($_SESSION['userrole_id']==6){
                                $stmt = $conn->prepare("SELECT id,OfficeName FROM office WHERE activity=1 AND districtoffice_id=? ORDER BY orderno");
                                $stmt->bind_param("i", $_SESSION["districtoffice_id"]);
                              }                          
                              else{
                                $stmt = $conn->prepare("SELECT id,OfficeName FROM office WHERE activity=1 ORDER BY orderno");
                              }                              
                              $stmt->execute();

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

while($row = $result->fetch_assoc())
                              {

$id = $row["id"];
                                  $OfficeName = $row["OfficeName"];
                        ?>
                        
                      <option value="<?=$id?>" <?php if($id==$office_id) echo "selected"; ?>><?=$OfficeName?></option>
                        <?php
                            }	
                          ?>
                      </select>                      
                    </div>
               </div>

<div class="form-group">
                    <label class="col-md-5 control-label">পদবি ভিত্তিক প্রতিবেদন</label>
                    <div class="col-md-5">
                    <select   name="designation_id" id="designation_id"  class="form-control">
                          <option value="">--Select--</option>
                          <?php
                              // prepare and bind
                              $stmt = $conn->prepare("SELECT * FROM designation ORDER BY grade_id");
                              $stmt->execute();

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

while($row = $result->fetch_assoc())
                              {

$id = $row["id"];
                                  $DesignationName = $row["DesignationName"];
                        ?>
                        
                      <option value="<?=$id?>" <?php if($id==$designation_id) echo "selected"; ?>><?=$DesignationName?></option>
                        <?php
                            }	
                          ?>
                      </select>                      
                    </div>
               </div>

<div class="form-group">
                          <div class="col-md-4 col-md-offset-5">
                              <input type="hidden" name="cmd" value="add">
                              <input type="hidden" name="id" value="<?=$Id?>">	
                          <button type="submit" class="btn btn-primary">
                           <i class="fa fa-btn fa-sign-in"></i>Submit
                           </button>
                          </div>
                     </div>

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

<?php
 include("../homepage/footer.php");
?>

${this.title}

Code Editor : report_editor.php