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.'
';
}
//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.'
';
}
//for Circle Office
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 aps.frmdate 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,
aps.frmdate,
aps.todate,
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)
LEFT JOIN applicantpass aps ON (aps.applicantlist_id=ap.id)
WHERE aps.slflag=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;
?>
| ক্রমিক |
PIMS আইডি |
নাম |
পদবি |
কর্মস্থল |
প্রশিক্ষণ শিরোনাম |
নিজ জেলা |
ঠিকানা |
এনআইডি |
মোবাইল |
ইমেইল |
মন্তব্য |
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).' '.'মাস';
}
?>
|
|
|
|
|
|
|
|
|
|
|
|