Example #1
0
    $check1 = mysql_query("select * from ebpls_owner where owner_zone_code = '{$bbo}'");
    $check1 = mysql_num_rows($check1);
    $check2 = mysql_query("select * from ebpls_business_enterprise where business_zone_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 {
        $nZone = new EBPLSZone($dbLink, 'false');
        $nZone->delete($bbo);
        $bbo = "";
        $iBarangay = "";
        $iZone = "";
        $iBLGFCode = "";
        ?>
		<body onload='javascript:alert ("Record Deleted!!");'></body>
		<?php 
    }
}
if ($com == "edit") {
    $nZone = new EBPLSZone($dbLink, 'false');
    $nZone->search($bbo, NULL);
    $nResult = $nZone->out;
    $iZone = $nResult[zone_desc];
    $nBarangay = new EBPLSBarangay($dbLink, 'false');
    $nBarangay->search($nResult[upper], NULL);
    $iResult = $nBarangay->out;
    $iBarangay = $iResult[barangay_code];
}
include 'html/eBPLS_zone.html';
Example #2
0
    $is_desc = $is_asc;
}
if ($is_desc == 'DESC') {
    $is_desc = 'ASC';
} else {
    $is_desc = 'DESC';
}
$is_asc = $is_desc;
if ($pagemulti == '') {
    $pagemulti = 1;
}
//echo $is_desc."VooDoo";
if ($orderkey == "") {
    $orderkey = "zone_code";
}
$nresult = new EBPLSZone($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><br />";
if ($pager > 1) {
    $prevr = $pager - 1;
    echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nzone&page=1&orderkey={$orderkey}&is_asc={$is_asc}'>&lt;&lt;&nbsp;";
    echo "<a href='index.php?part=4&class_type=Preference&selMode=ebpls_nzone&page={$prevr}&orderkey={$orderkey}&is_asc={$is_asc}'>Prev&nbsp;";
}
if ($pager >= 7) {