Exemplo n.º 1
0
    $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';
Exemplo n.º 2
0
        }
    }
} 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';
Exemplo n.º 3
0
            ?>
			<body onload='javascript:alert ("Record Successfully Updated!!");'></body>
			<?php 
        }
    }
} elseif ($confx == 1) {
    $check1 = mysql_query("select * from ebpls_owner where owner_province_code = '{$bbo}'");
    $check1 = mysql_num_rows($check1);
    $check2 = mysql_query("select * from ebpls_business_enterprise where business_province_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 {
        $nProvinceIssued = new EBPLSProvince($dbLink, 'false');
        $nProvinceIssued->delete($bbo);
        $bbo = "";
        ?>
		<body onload='javascript:alert ("Record Deleted!!");'></body>
		<?php 
    }
}
if ($com == 'edit') {
    $nProvince = new EBPLSProvince($dbLink, 'false');
    $nProvince->search($bbo, NULL);
    $nResult = $nProvince->out;
    $iProvince = $nResult[province_desc];
    $iBLGFCode = $nResult[blgf_code];
}
include 'html/eBPLS_province.html';