Exemplos de fatch_Random_personnel_for_replacement em PHP

Exemplo n.º 1

Arquivo: ajax-replacement.php Projeto: MUN06/Lok-Sabha-Election-16th

} 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";

Exemplo n.º 2

Arquivo: ajax-reserve-replacement.php Projeto: MUN06/Lok-Sabha-Election-16th

        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";