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

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

if(empty($_SESSION["username"])) 
{
  Header("Location: ../login/login.php");
 }	
 ?>		 
 
<div class="container fullheight">
    <div class="row">
        <div class="col-md-12">
            <br>
           
            
<?php
//অভ্যন্তরীণ প্রশিক্ষণ
$stmt = $conn->prepare("SELECT 
                                tr.id,
                                tr.GovtId,
                                tr.coursetitle,
                                tr.instName,
                                tr.instLocation,
                                tr.startDate,
                                tr.endDate,
                                tr.exmresult											
                        FROM localtraining tr
                        LEFT JOIN general g ON(tr.GovtId=g.GovtId) 
                        ORDER BY g.id");

//$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
  {
 ?>
 <br>
 <h4> অভ্যন্তরীণ প্রশিক্ষণ</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>PIMS আইডি</td>
                        <td>কোর্স টাইটেল</td>
                        <td>প্রশিক্ষণ প্রদানকারী প্রতিষ্ঠানের নাম</td>
                        <td>লোকেশন</td>
                        <td>প্রশিক্ষণ শুরু তারিখ</td>
                        <td>প্রশিক্ষণ শেষের তারিখ</td>
                        <td>প্রশিক্ষণের ফলাফল</td>         
                        </tr>                       
                     <?php
                     while($row = $result->fetch_assoc())
                     {
                         $slno=$slno +1;
                         $id = $row["id"];
                         $GovtId = $row["GovtId"];
                         $coursetitle = $row["coursetitle"];
                         $instName = $row["instName"];
                         $instLocation = $row["instLocation"];
                         $startDate = $row["startDate"];
                         $endDate = $row["endDate"];
                         $exmresult = $row["exmresult"];
                     ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td align="center">
                            <a href="../general/pdsreport.php?GovtId=<?=$GovtId?>" target="_blank" >
                            <?=bangladate($GovtId)?></span></a>
                        </td>
                        
                        <td><?=$coursetitle ?></td>
                        <td><?=$instName ?></td>
                        <td><?=$instLocation ?></td>
                        <td><?=bangladate(str_replace('1970-01-01','',$startDate)) ?></td>
                        <td><?=bangladate(str_replace('1970-01-01','',$endDate)) ?></td>
                        <td><?=$exmresult ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php
  }	
  //বৈদেশিক প্রশিক্ষণ
  $stmt = $conn->prepare("SELECT 
                            f.id,
                            f.GovtId,
                            f.coursetitle,
                            f.instName,
                            f.instLocation,
                            c.CountryName,
                            f.startDate,
                            f.endDate,
                            f.exmresult					         
                        FROM foreigntraining f
                        LEFT JOIN country c ON(f.country_id=c.id)
                        LEFT JOIN general g ON(f.GovtId=g.GovtId) 
                        ORDER BY g.id");

//$stmt->bind_param("s",$GovtId);
                $stmt->execute();
                
                $result = $stmt->get_result();	
				$numrows=$result->num_rows;

$slno=0;

if($numrows>0)
{
  ?>
<br>
<h4> বৈদেশিক প্রশিক্ষণ</h4>
                    <table class="table table-bordered table-striped table-condensed banglafont">                   
                
                        <tr>
                        <td>ক্রমিক নং</td>
                        <td>PIMS আইডি</td>
                        <td>কোর্স টাইটেল</td>
                        <td>প্রশিক্ষণ প্রদানকারী প্রতিষ্ঠানের নাম</td>
                        <td>লোকেশন</td>
                        <td>দেশের নাম</td>
                        <td>প্রশিক্ষণ শুরুর তারিখ</td>
                        <td>প্রশিক্ষণ শেষের তারিখ</td>
                        <td>প্রশিক্ষণের ফলাফল</td>     
                        </tr>                       
                     <?php
                      while($row = $result->fetch_assoc())
                      {
                          $slno=$slno +1;
                          $id = $row["id"];
                          $GovtId = $row["GovtId"];
                          $coursetitle = $row["coursetitle"];
                          $instName = $row["instName"];
                          $instLocation = $row["instLocation"];
                          $CountryName = $row["CountryName"];
                          $startDate = $row["startDate"];
                          $endDate = $row["endDate"];
                          $exmresult = $row["exmresult"];
                      ?>
                        <tr>              
                        <td><?=bangladate($slno)?></td>
                        <td align="center">
                            <a href="../general/pdsreport.php?GovtId=<?=$GovtId?>" target="_blank" >
                            <?=bangladate($GovtId)?></span></a>
                        </td>
                     
                        <td><?=$coursetitle ?></td>
                        <td><?=$instName ?></td>
                        <td><?=$instLocation ?></td>
                        <td><?=$CountryName ?></td>
                        <td><?=bangladate(str_replace('1970-01-01','',$startDate)) ?></td>
                        <td><?=bangladate(str_replace('1970-01-01','',$endDate)) ?></td>
                        <td><?=$exmresult ?></td>
                       </tr>
                       <?php
						}
						?>
                    </table>
<?php    
}
?>

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

</script>

${this.title}

Code Editor : training.php