} else { echo " "; } //============================Get New Personnel Details================================= //$assembly; $forassembly; $forpc; $groupid; $for_subdiv = isset($_GET["for_subdiv"]) ? $_GET["for_subdiv"] : ""; $assembly = isset($_GET["assembly"]) ? $_GET["assembly"] : ""; $posting_status = isset($_GET["posting_status"]) ? $_GET["posting_status"] : ""; $groupid = isset($_GET["groupid"]) ? $_GET["groupid"] : ""; $gender = isset($_GET["gender"]) ? $_GET["gender"] : ""; if ($opn == 'g_new_per') { $forpc = isset($_GET["forpc"]) ? $_GET["forpc"] : ""; if ($assembly != '' && $posting_status != '' && $groupid != '' && $gender != '') { $rs_new_per; $row_new_per; $rs_new_per = fatch_Random_personnel_for_replacement($for_subdiv, $forpc, $assembly, $posting_status, $groupid, $gender); //$random_rs_person=array_rand($rs_new_per); $num_rows_new_per = rowCount($rs_new_per); if ($num_rows_new_per > 0) { $row_new_per = getRows($rs_new_per); echo "<table>\n"; echo "<tr><td align='center' colspan='4'><b>NEW PERSONNEL</b></td></tr>\n"; echo "<tr><td align='left'><b>Personnel ID: </b></td><td align='left' id='new_per_id'>" . $row_new_per['personcd'] . "</td><td align='left'><b>Office ID: </b></td><td>" . $row_new_per['officecd'] . "</td></tr>\n"; echo "<tr><td align='left'>Name: </td><td align='left' colspan='3'>" . $row_new_per['officer_name'] . "</td></tr>\n"; echo "<tr><td align='left'>Designation: </td><td align='left' colspan='3'>" . $row_new_per['off_desg'] . "</td></tr>\n"; echo "<tr><td align='left'>Office Address: </td><td align='left' colspan='3'>" . $row_new_per['address1'] . "," . $row_new_per['address2'] . ", PO-" . $row_new_per['postoffice'] . ", PS-" . $row_new_per['policestation'] . ", Subdiv-" . $row_new_per['subdivision'] . ", Dist.-" . $row_new_per['district'] . "," . $row_new_per['pin'] . "</td></tr>\n"; echo "<tr><td align='left'>Date of Birth: </td><td align='left'>" . $row_new_per['dateofbirth'] . "</td><td align='left'>Sex: </td><td align='left'>" . $row_new_per['gender'] . "</td></tr>\n"; echo "<tr><td align='left'>EPIC No: </td><td align='left'>" . $row_new_per['epic'] . "</td><td align='left'>Posting Status: </td><td align='left'>" . $row_new_per['poststatus'] . "</td></tr>\n"; echo "<tr><td align='left'>Present Address: </td><td align='left' colspan='3'>" . $row_new_per['present_addr1'] . ", " . $row_new_per['present_addr2'] . "</td></tr>\n"; echo "<tr><td align='left' colspan='4'><b>Assembly of</b></td></tr>\n"; echo "<tr><td align='left' colspan='2'>Present Address: </td><td align='left' colspan='2'>" . $row_new_per['pre_ass'] . "<hidden id='hid_pre_ass' name='hid_pre_ass' style='display:none;'>" . $row_new_per['pre_ass'] . "</hidden></td></tr>\n";
echo $row_person['officecd']; } } else { echo " "; } //================================ Reserve Personnel Replacement ======================================= $forassembly = isset($_GET["forassembly"]) ? $_GET["forassembly"] : ""; $post_stat = isset($_GET["post_stat"]) ? $_GET["post_stat"] : ""; //$groupid=isset($_GET["groupid"])?$_GET["groupid"]:""; $gender = isset($_GET["gender"]) ? $_GET["gender"] : ""; if ($opn == 'new_search') { $forpc = isset($_GET["forpc"]) ? $_GET["forpc"] : ""; if ($forassembly != '' && $post_stat != '' && $forpc != '' && $gender != '') { $rs_new_per; $row_new_per; $rs_new_per = fatch_Random_personnel_for_replacement($forpc, $forassembly, $post_stat, $gender); //$random_rs_person=array_rand($rs_new_per); $num_rows_new_per = rowCount($rs_new_per); if ($num_rows_new_per > 0) { $row_new_per = getRows($rs_new_per); echo "<table>\n"; echo "<tr><td align='center' colspan='4'><b>NEW PERSONNEL</b></td></tr>\n"; echo "<tr><td align='left'><b>Personnel ID: </b></td><td align='left' id='new_per_id'>" . $row_new_per['personcd'] . "</td><td align='left'><b>Office ID: </b></td><td>" . $row_new_per['officecd'] . "</td></tr>\n"; echo "<tr><td align='left'>Name: </td><td align='left' colspan='3'>" . $row_new_per['officer_name'] . "</td></tr>\n"; echo "<tr><td align='left'>Designation: </td><td align='left' colspan='3'>" . $row_new_per['off_desg'] . "</td></tr>\n"; echo "<tr><td align='left'>Office Address: </td><td align='left' colspan='3'>" . $row_new_per['address1'] . "," . $row_new_per['address2'] . ", PO-" . $row_new_per['postoffice'] . ", PS-" . $row_new_per['policestation'] . ", Subdiv-" . $row_new_per['subdivision'] . ", Dist.-" . $row_new_per['district'] . "," . $row_new_per['pin'] . "</td></tr>\n"; echo "<tr><td align='left'>Date of Birth: </td><td align='left'>" . $row_new_per['dateofbirth'] . "</td><td align='left'>Sex: </td><td align='left'>" . $row_new_per['gender'] . "</td></tr>\n"; echo "<tr><td align='left'>EPIC No: </td><td align='left'>" . $row_new_per['epic'] . "</td><td align='left'>Posting Status: </td><td align='left'>" . $row_new_per['poststatus'] . "</td></tr>\n"; echo "<tr><td align='left'>Present Address: </td><td align='left' colspan='3'>" . $row_new_per['present_addr1'] . ", " . $row_new_per['present_addr2'] . "</td></tr>\n"; echo "<tr><td align='left' colspan='4'><b>Assembly of</b></td></tr>\n"; echo "<tr><td align='left' colspan='2'>Present Address: </td><td align='left' colspan='2'>" . $row_new_per['pre_ass'] . "<hidden id='hid_pre_ass' name='hid_pre_ass' style='display:none;'>" . $row_new_per['pre_ass'] . "</hidden></td></tr>\n";