$training_time = $rowAppDtl['training_time'];
mysqli_stmt_bind_param($stmt, 'ssssssssssssssssssssssssssssss', $rowApp['officer_name'], $rowApp['person_desig'], $rowApp['personcd'], $rowApp['officer_desig'], $office_address, $rowApp['postoffice'], $rowApp['subdivision'], $rowApp['policestation'], $rowApp['district'], $rowApp['pin'], $rowApp['officecd'], $rowApp['poststatus'], $rowApp['mob_no'], $training_desc, $venuename, $venue_add, $training_dt, $training_time, $rowApp['forpc'], $rowApp['pcname'], $rowApp['forsubdivision'], $rowApp['epic'], $rowApp['acno'], $rowApp['partno'], $rowApp['slno'], $rowApp['bank_name'], $rowApp['branch_name'], $rowApp['bank_acc_no'], $rowApp['ifsc_code'], $token_no);
mysqli_stmt_execute($stmt);
$rowAppDtl = NULL;
}
unset($rsAppDtl);
} else {
$training_desc = '';
$venuename = '';
$venue_add = '';
$training_dt = '';
$training_time = '';
mysqli_stmt_bind_param($stmt, 'ssssssssssssssssssssssssssssss', $rowApp['officer_name'], $rowApp['person_desig'], $rowApp['personcd'], $rowApp['officer_desig'], $office_address, $rowApp['postoffice'], $rowApp['subdivision'], $rowApp['policestation'], $rowApp['district'], $rowApp['pin'], $rowApp['officecd'], $rowApp['poststatus'], $rowApp['mob_no'], $training_desc, $venuename, $venue_add, $training_dt, $training_time, $rowApp['forpc'], $rowApp['pcname'], $rowApp['forsubdivision'], $rowApp['epic'], $rowApp['acno'], $rowApp['partno'], $rowApp['slno'], $rowApp['bank_name'], $rowApp['branch_name'], $rowApp['bank_acc_no'], $rowApp['ifsc_code'], $token_no);
mysqli_stmt_execute($stmt);
}
echo "\r\n </table>\r\n</div>\r\n<hr width='750px' />\r\n<div align='center'>\r\n<table cellspacing='0' cellpadding='0' width='750'>\r\n\t<tr><td align='left'> This is a compulsory duty on your part to attend the said programme, as per the provisions of The Representation of the People Act, 1951. <br />\r\n You are directed to bring your Elector's Photo Identity Card (EPIC) or any proof of Identity affixed with your Photograph.</td></tr></table></div>\r\n<div align='center'>\r\n<table cellspacing='0' cellpadding='0' width='750'>\r\n\t<tr><td height='20px' colspan='2'> </td></tr>\r\n\t<tr><td align='right' colspan='2'>Signature </td></tr></div>\r\n<tr><td align='left'>Place: " . uppercase($distnm_cap) . "</td><td rowspan='3' align='right'><img src='../images/deo/{$_SESSION['signature']}' alt='' height='50px' width='100px' /></td></tr>\r\n<tr><td align='left'>Date: " . date('d/m/Y') . "</td></tr>\r\n<tr><td height='30px' align='right'> </td></tr>\r\n<tr><td align='right' colspan='2'>District Election Officer <br />\r\nDistrict " . wordcase($distnm_cap) . " </td></tr></table>\r\n<hr width='750px' />\r\n<table cellspacing='0' cellpadding='0' width='750px'>\r\n <tr>\r\n <td width='5%' rowspan='6' valign='top'>NB.</td>\r\n <td width='5%' valign='top'>1.</td>\r\n <td width='90%' align='left'>Please fillup form 12A (for Election Duty Certificate) if you have been deployed for poll duty within your home Parliamentary Constituency. In other cases fill up form form 12 (for Postal Ballot).</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>2.</td>\r\n <td align='left'>Please submit duly filled in form 12/12A allong with duplicate copy of appointment letter at training venue on the first day of training.</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>3.</td>\r\n <td align='left'>Please write particulars on the supplied blank Identity Card and also affix your colour passport size photograph on it. Please bring it at training venue for attestation.</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>4.</td>\r\n <td align='left'>Please check your electoral data and bank details given below. For any inconsistancy please inform the authority.</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'> </td>\r\n <td align='left'>EPIC No.- {$rowApp['epic']} Assembly- {$rowApp['acno']} Part No.- {$rowApp['partno']} Sl. No.- {$rowApp['slno']} <br /> Bank- {$rowApp['bank_name']} Branch- {$rowApp['branch_name']} A/c No.- {$rowApp['bank_acc_no']} IFS Code- {$rowApp['ifsc_code']}</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>5.</td>\r\n <td align='left'>Please bring in the filled up data sheet, as attached herewith, during the first training.</td>\r\n </tr>\r\n</table>\r\n<table width='750px' cellspacing='0' cellpadding='0'>\r\n <tr>\r\n <td>---------------------------------------------------------------------------------------------------------------------------------------------------</td>\r\n </tr>\r\n <tr>\r\n <td>Copy to DDO / Head of Office to serve the Letter and submit the service return.</td>\r\n </tr>\r\n <tr>\r\n <td>---------------------------------------------------------------------------------------------------------------------------------------------------</td>\r\n </tr>\r\n</table>\r\n<p> </p>\r\n<div align='center'>\r\n <table width='700' border='0' cellspacing='0' cellpadding='0'>\r\n <tr>\r\n <td width='70%' valign='top'>Receipt of Appointment Letter</td>\r\n <td width='30%' valign='top'>Signature of the Recepient<br />\r\n Date:</td>\r\n </tr>\r\n </table>\r\n</div>";
echo "\n<h6></h6>\n";
echo "\n<h6></h6>\n";
$rowPer = NULL;
}
unset($rsId, $num_rows);
if (!mysqli_commit($link)) {
print "Transaction commit failed\n";
exit;
}
mysqli_stmt_close($stmt);
mysqli_close($link);
//delete_temp_app_letter($usercd);
}
?>
</td></tr></table>
$training_time = $rowAppDtl['training_time'];
mysqli_stmt_bind_param($stmt, 'ssssssssssssssssssssssssssssss', $rowApp['officer_name'], $rowApp['person_desig'], $rowApp['personcd'], $rowApp['officer_desig'], $office_address, $rowApp['postoffice'], $rowApp['subdivision'], $rowApp['policestation'], $rowApp['district'], $rowApp['pin'], $rowApp['officecd'], $rowApp['poststatus'], $rowApp['mob_no'], $training_desc, $venuename, $venue_add, $training_dt, $training_time, $rowApp['forpc'], $rowApp['pcname'], $rowApp['forsubdivision'], $rowApp['epic'], $rowApp['acno'], $rowApp['partno'], $rowApp['slno'], $rowApp['bank_name'], $rowApp['branch_name'], $rowApp['bank_acc_no'], $rowApp['ifsc_code'], $token_no);
mysqli_stmt_execute($stmt);
$rowAppDtl = NULL;
}
unset($rsAppDtl);
} else {
$training_desc = '';
$venuename = '';
$venue_add = '';
$training_dt = '';
$training_time = '';
mysqli_stmt_bind_param($stmt, 'ssssssssssssssssssssssssssssss', $rowApp['officer_name'], $rowApp['person_desig'], $rowApp['personcd'], $rowApp['officer_desig'], $office_address, $rowApp['postoffice'], $rowApp['subdivision'], $rowApp['policestation'], $rowApp['district'], $rowApp['pin'], $rowApp['officecd'], $rowApp['poststatus'], $rowApp['mob_no'], $training_desc, $venuename, $venue_add, $training_dt, $training_time, $rowApp['forpc'], $rowApp['pcname'], $rowApp['forsubdivision'], $rowApp['epic'], $rowApp['acno'], $rowApp['partno'], $rowApp['slno'], $rowApp['bank_name'], $rowApp['branch_name'], $rowApp['bank_acc_no'], $rowApp['ifsc_code'], $token_no);
mysqli_stmt_execute($stmt);
}
echo "\r\n </table>\r\n</div>\r\n<hr width='750px' />\r\n<div align='center'>\r\n<table cellspacing='0' cellpadding='0' width='750'>\r\n\t<tr><td align='left'> This is a compulsory duty on your part to attend the said programme, as per the provisions of The Representation of the People Act, 1951. <br />\r\n You are directed to bring a copy of 1st. page of your bank pass book where your account details are available and photo copy of your Elector's Photo Identity Card (EPIC).</td></tr></table></div>\r\n<div align='center'>\r\n<table cellspacing='0' cellpadding='0' width='750'>\r\n\t<tr><td height='20px' colspan='2'> </td></tr>\r\n\t<tr><td align='right' colspan='2'>Signature </td></tr></div>\r\n<tr><td align='left'>Place: " . uppercase($_SESSION['dist_name']) . "</td><td rowspan='3' align='right'><img src='../images/deo/{$_SESSION['signature']}' alt='' height='50px' width='100px' /></td></tr>\r\n<tr><td align='left'>Date: " . date('d/m/Y') . "</td></tr>\r\n<tr><td height='30px' align='right'> </td></tr>\r\n<tr><td align='right' colspan='2'>District Election Officer <br />\r\nDistrict " . wordcase($_SESSION['dist_name']) . " </td></tr></table>\r\n<hr width='750px' />\r\n<table cellspacing='0' cellpadding='0' width='750px'>\r\n <tr>\r\n <td width='5%' rowspan='6' valign='top'>NB.</td>\r\n\t<td width='5%' valign='top'>1.</td>\r\n <td>Please check A/c No, Part No., Sl.No., EPIC No., mobile no. in the prefilled Form 12 (for postal ballot)/12A (for Election Duty Certificate).</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>2.</td>\r\n <td>Please write your address in 12/12A and sign it.</td>\r\n </tr>\r\n\r\n <tr>\r\n <td valign='top'>3.</td>\r\n <td>Please submit duly filled in form 12/12A allong with duplicate copy of appointment letter and photo copy of voter card at training venue on the first day of training.</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>4.</td>\r\n <td>Please write particulars on the supplied blank Identity Card and also affix your colour passport size photograph on it. Please bring it at training venue for attestation.</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>5.</td>\r\n <td>Your electroral details, Bank details and mobile no. are given below. Please check the details and make correction in Form 12/12A and attendance sheet in case of any discripancy.</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'> </td>\r\n <td>EPIC : {$rowApp['epic']} AC No. : {$rowApp['acno']} Part No. : {$rowApp['partno']} Sl. No. : {$rowApp['slno']} <br /> Bank : {$rowApp['bank_name']} Branch : {$rowApp['branch_name']} <br>IFSC : {$rowApp['ifsc_code']} Bank A/c No. : {$rowApp['bank_acc_no']} Mobile No. : {$rowApp['mob_no']}</td>\r\n </tr>\r\n </table>\r\n<table width='750px' cellspacing='0' cellpadding='0'>\r\n <tr>\r\n <td>---------------------------------------------------------------------------------------------------------------------------------------------------</td>\r\n </tr>\r\n <tr>\r\n <td>Copy to DDO / Head of Office to serve the Letter and submit the service return.</td>\r\n </tr>\r\n <tr>\r\n <td>---------------------------------------------------------------------------------------------------------------------------------------------------</td>\r\n </tr>\r\n</table>\r\n<p> </p>\r\n<div align='center'>\r\n <table width='700' border='0' cellspacing='0' cellpadding='0'>\r\n <tr>\r\n <td width='70%' valign='top'>Receipt of Appointment Letter</td>\r\n <td width='30%' valign='top'>Signature of the Recepient<br />\r\n Date:</td>\r\n </tr>\r\n </table>\r\n</div>";
echo "\n<h6></h6>\n";
echo "\n<h6></h6>\n";
$rowPer = NULL;
}
unset($rsId, $num_rows);
if (!mysqli_commit($link)) {
print "Transaction commit failed\n";
exit;
}
mysqli_stmt_close($stmt);
mysqli_close($link);
//delete_temp_app_letter($usercd);
}
?>
</td></tr></table>
</tr>
<tr>
<td colspan='2' valign='middle' align='left'>Place : <?php
print uppercase($_SESSION['dist_name']);
?>
<br />
Date : <?php
print date('d/m/Y');
?>
</td>
<td align='center' valign='top'>Signature<br /><img src=<?php
print "../images/deo/{$_SESSION['signature']}";
?>
alt='' height='50px' width='100px' /><br />
(__________________)<br />District Election Officer<br /><?php
print wordcase($_SESSION['dist_name']);
?>
District</td>
</tr>
<tr><td colspan="3"><hr style="border:1px solid #999; width:100%;" /></td></tr>
<tr><td colspan="3" align="left">You are requested to attend the training at <?php
print $training_venue . ", " . $venue_addr;
?>
on <?php
print $training_date;
?>
from <?php
print $training_time;
?>
</td></tr>
</table>