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

<div class="container backcolor">
    <div class="row">
        <div class="col-md-12">
            <?php

//Value Initialization
				$prmtype="";
				$paramdata = array();
				$where="";
				$headertext="";
				$colhead="";

//for training Headline
                
				if(!empty($thlinelist_id))
				{
					// prepare and bind
					$stmt = $conn->prepare("SELECT * FROM thlinelist WHERE id = ? ORDER BY id ASC");
					$stmt->bind_param("i", $thlinelist_id);
					$stmt->execute();
	
					//Result
					$result = $stmt->get_result();
					$numrows = $result->num_rows;
	
	
					while ($row = $result->fetch_assoc()) {
						$thlinelistName = $row["thlinelistName"];
					}
					$prmtype.="i";
                    $paramdata[]=$thlinelist_id;
                    $where.=" AND thl.id=? ";
					$headertext.='প্রশিক্ষণের শিরোনাম : '.$thlinelistName.'<br>';										
				}

//for training Headline					
	if(!empty($trevent_id))
	{
		// prepare and bind
		$stmt = $conn->prepare("SELECT * FROM trevent WHERE id = ? ORDER BY id ASC");
		$stmt->bind_param("i", $trevent_id);
		$stmt->execute();

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

while ($row = $result->fetch_assoc()) {
			$subject = $row["subject"];
		}
		$prmtype.="i";
		$paramdata[]=$trevent_id;
		$where.=" AND tr.id=? ";
		$headertext.='ব্যাচের শিরোনাম : '.$subject.'<br>';										
	}

//for training Headline					
if(!empty($designation_id))
{
	// prepare and bind
	$stmt = $conn->prepare("SELECT * FROM designation WHERE id = ? ORDER BY id ASC");
	$stmt->bind_param("i", $designation_id);
	$stmt->execute();

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

while ($row = $result->fetch_assoc()) {
		$DesignationName = $row["DesignationName"];
	}
	$prmtype.="i";
	$paramdata[]=$designation_id;
	$where.=" AND d.id=? ";
	$headertext.='পদবি : '.$DesignationName.'<br>';										
}

//for Date 
			if(!empty($fromdate) && !empty($todate))
			{
				// prepare and bind
				$fromdate=date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['fromdate']))));
				$todate=date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['todate']))));
				 
				$prmtype.="s";
				$paramdata[]=$fromdate;

$prmtype.="s";
				$paramdata[]=$todate;

$where.=" AND tr.trdate BETWEEN ? AND ? ";
				$headertext.=bangladate($fromdate).' থেকে '.bangladate($todate).'  ';
			}

$headertext=substr($headertext,0,-2);
		        // prepare and bind
                $stmt = $conn->prepare("SELECT 
											ap.id,
											ap.GovtId,
											ap.trevent_id,
											ap.district_id,
											ap.apname,
											ap.designation_id,
											ap.office_id,
											ap.address,
											ap.mobileno,
											ap.email,
											ap.comment,
											ap.nidcard,
											tr.subject,		
											tr.trevnID,
											d.DesignationName,
											o.OfficeName,
											dis.DistrictName,
											tr.trdate,
											tr.trenddate,
											thl.thlinelistName
										FROM applicantlist ap
										LEFT JOIN trevent tr 
												INNER JOIN thlinelist thl ON(tr.thlinelist_id=thl.id)
											ON(ap.trevent_id=tr.id)                    
										LEFT JOIN designation d ON(ap.designation_id=d.id)
										LEFT JOIN office o ON (ap.office_id=o.id)
										LEFT JOIN district dis ON (ap.district_id=dis.id)
										WHERE 1=1 ".$where);

//Parameter Pass 
				$params = array_merge(array($prmtype), $paramdata);
				foreach( $params as $key => $value ) {
					$params[$key] = &$params[$key];
				}

call_user_func_array(array($stmt, "bind_param"), $params);
				
				$stmt->execute();

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

//if($numrows==0) exit('No rows');
                $slno=0;
?>
                 <br/>
                <h4 class="text-center"><?=$headertext?></h4>
            
				<script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></script>
				<p class="text-right"><button class="btn-danger" onclick="ExportToExcel('xlsx')">Download Excel</button></p>
				<table class="table table-bordered table-striped table-condensed" id="empTable">

<thead>
					<th>ক্রমিক</th>
					<th>PIMS আইডি</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'];					
					$GovtId = $row['GovtId'];
					$apname = $row['apname'];

$DesignationName = $row['DesignationName'];
					$OfficeName = $row['OfficeName'];
					$DistrictName = $row['DistrictName'];
					$address = $row['address'];
					$mobileno = $row['mobileno'];
					$nidcard = $row['nidcard'];
					$subject = $row['subject'];
					$thlinelistName = $row['thlinelistName'];

$frmdate = $row['frmdate'];
					$todate = $row['todate'];
					$nidcard = $row['nidcard'];
					$mobileno = $row['mobileno'];
					$email = $row['email'];
					$comment = $row['comment'];

$d1 = new DateTime($todate);
					$d2 = new DateTime($frmdate);
					$interval = $d1->diff($d2);
					$diffInYears   = $interval->y;
					$diffInMonths  = $interval->m;

if ($CLJoinDate=='1970-01-01'){
						$timeintval="";
					}
					else{
						$timeintval=bangladate($diffInYears).' '.'বছর'.' '.bangladate($diffInMonths).' '.'মাস';

}

var today = new Date();
    var date = today.getFullYear()+'_'+(today.getMonth()+1)+'_'+today.getDate();
    var time_name = today.getHours() + ":" + today.getMinutes() + ":" + today.getSeconds();

${this.title}

Code Editor : rep_applicatlist_training.php