} } } elseif ($confx == 1) { $check1 = mysql_query("select * from ebpls_owner where owner_zip_code = '{$bbo}'"); $check1 = mysql_num_rows($check1); $check2 = mysql_query("select * from ebpls_business_enterprise where business_zip_code = '{$bbo}'"); $check2 = mysql_num_rows($check2); if ($check1 > 0 || $check2 > 0) { ?> <body onload='javascript:alert ("Cannot Delete. Record exist in other table(s).");'></body> <?php } else { $nZIP = new EBPLSZIP($dbLink, 'false'); $nZIP->delete($bbo); $bbo = ""; ?> <body onload='javascript:alert ("Record Deleted!!");'></body> <?php } } if ($com == "edit") { $nZIP = new EBPLSZIP($dbLink, 'false'); $nZIP->search($bbo, NULL); $nResult = $nZIP->out; $iZIP = $nResult[zip_code]; $nLGU = new EBPLSLGU($dbLink, 'false'); $nLGU->search($nResult[upper], NULL); $iResult = $nLGU->out; $iLGU = $iResult[city_municipality_code]; } include 'html/eBPLS_zip.html';
} } } elseif ($confx == 1) { $nAnnounce = new EBPLSAnnouncement($dbLink, 'false'); $nAnnounce->delete($bbo); $bbo = ""; ?> <body onload='javascript:alert ("Record Deleted!!");'></body> <?php } if ($com == "edit") { $nAnnounce = new EBPLSAnnouncement($dbLink, 'false'); $nAnnounce->getLgu(); $nAnnounce->search($bbo, NULL); $nResult = $nAnnounce->out; $announcements = $nResult[announcements]; $announced_by = $nResult[announced_by]; $sms_checked = $nResult[sms_send]; } $nAnnounce = new EBPLSAnnouncement($dbLink, 'false'); $nAnnounce->getLgu(); $Pref = $nAnnounce->out; $iProv = $Pref[lguprovince]; $iLgu = $Pref[lguname]; $nProvince = new EBPLSProvince($dbLink, 'false'); $nProvince->search($iProv, NULL); $getProvince = $nProvince->out[province_desc]; $nLGU = new EBPLSLGU($dbLink, 'false'); $nLGU->search($iLgu, NULL); $getLGU = $nLGU->out[city_municipality_desc]; include 'html/eBPLS_lotpin.html';
// Flip direction $is_desc = 'ASC'; } else { $is_desc = 'DESC'; } $is_asc = $is_desc; // set ascending or descending sequence // echo "Sequence is ".$is_asc."\n"; if ($pagemulti == '') { $pagemulti = 1; } //echo $is_desc."VooDoo"; if (!isset($orderkey) or $orderkey == "") { $orderkey = "city_municipality_code"; } $nresult = new EBPLSLGU($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_nLGU&page=1&orderkey={$orderkey}&is_asc={$is_asc}'><< "; echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nLGU&page={$prevr}&orderkey={$orderkey}&is_asc={$is_asc}'>Prev "; } if ($pager >= 7) {
$check2 = mysql_query("select * from ebpls_business_enterprise where business_city_code = '{$bbo}'"); $check2 = mysql_num_rows($check2); if ($check1 > 0 || $check2 > 0) { ?> <body onload='javascript:alert ("Cannot Delete. Record exist in other table(s).");'></body> <?php } else { $nLGU = new EBPLSLGU($dbLink, 'false'); $nLGU->delete($bbo); $bbo = ""; ?> <body onload='javascript:alert ("Record Deleted!!");'></body> <?php } } $dblink = isset($dblink) ? $dblink : ''; //2008.05.12 if ($com == "edit") { $nLGU = new EBPLSLGU($dbLink, 'false'); $nLGU->search($bbo, NULL); $nResult = $nLGU->out; $iLGUCode = $nResult[city_municipality_code]; $iLGUDescription = $nResult[city_municipality_desc]; $iUpper = $nResult[upper]; $iBLGFCode = $nResult[blgf_code]; $nProvince = new EBPLSProvince($dbLink, 'false'); $nProvince->search($nResult[upper], NULL); $iResult = $nProvince->out; $iProvince = $iResult[province_code]; } include 'html/eBPLS_lgu.html';