if ($conact == 1) { $nRequirements = new EBPLSRequirements($dbLink, 'false'); $datetoday = date("Y-m-d H:i:s"); $nRequirements->searchexist($bbo); if ($nRequirements->rcount > 0) { ?> <body onload='javascript:alert ("Cannot Delete, Record exist in other table!!");'></body> <?php } else { $nRequirements->setData(RECSTATUS, "A"); $nRequirements->update($bbo); $bbo = ""; ?> <body onload='javascript:alert ("Record Successfully Activated!!");'></body> <?php } } if ($com == "edit") { $nRequirements = new EBPLSRequirements($dbLink, 'false'); $nRequirements->search($bbo, NULL); $nResult = $nRequirements->out; $iDesc = $nResult[reqdesc]; $iPermitType = $nResult[permit_type]; $ireqindicator = $nResult[reqindicator]; if ($ireqindicator == '1') { $is_checked = "CHECKED"; } else { $is_checked = ""; } } include 'html/eBPLS_requirements.html';
} // Define the number of results per page $fromr = abs($pager * $max_resultsr - $max_resultsr); if ($is_desc == 'DESC') { $is_desc = 'ASC'; } else { $is_desc = 'DESC'; } if ($pagemulti == '') { $pagemulti = 1; } //echo $is_desc."VooDoo"; if ($orderkey == "") { $orderkey = "reqid"; } $nresult = new EBPLSRequirements($dbLink, 'false'); $nresult->pagesearch($fromr, $max_resultsr, $orderkey, $is_desc); $fetarray = $nresult->rcount; $total_sr = @mysql_fetch_row($fetarray); $total_resultsr = $total_sr[0]; $fetchrecord = $nresult->out; // Figure out the total number of pages. Always round up using ceil() $total_pagesr = ceil($total_resultsr / $max_resultsr); //echo $total_resultsr."VooDoo"; echo "<table border=0 width=100%><tr><td align=left>"; if ($pager > 1) { $prevr = $pager - 1; echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nRequirements&page=1&orderkey={$orderkey}&ascdesc1={$ascdesc1}'><<</a> "; echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nRequirements&page={$prevr}&orderkey={$orderkey}&ascdesc1={$ascdesc1}'>Prev</a> "; } if ($pager >= 7) {