//Author: Robert M. Verzosa (VooDoo)
//Date Created: Matagal nang nagawa, kaya lang maraming comment si Eve.
require 'includes/variables.php';
include 'lib/phpFunctions-inc.php';
include 'class/ownership.class.php';
if ($Submit == 'Submit') {
if ($exemption != '') {
$sQuery = "select * from ebpls_business_category where business_category_code='{$bcode}' or business_category_code='{$engcode}'";
$nOwnType = new Ownership();
$nOwnType->Query1($sQuery);
$chkRecord = $nOwnType->dbResultOut;
if ($chkRecord == 0) {
if ($com != edit) {
$sQuery = "select * from ebpls_business_category where business_category_code='{$ownership_code}'";
$nOwnType = new Ownership();
$nOwnType->Query1($sQuery);
$chkRecord = $nOwnType->dbResultOut;
if ($chkRecord == 1) {
?>
<body onload='javascript:alert ("Existing Code Found!!"); return false;'></body>
<?php
} else {
$nValues = "'{$ownership_code}', '{$ownership_type}',now(),now(),'{$usern}', {$exemption}";
$nOwnType->InsertQuery('ebpls_business_category', $nValues);
$ic = 0;
$colls = 0;
$getreq = mysql_query("select * from ebpls_buss_tfo\n\t\t\t where tfostatus='A' and taxfeetype<>1\n\t\t\t or tfodesc like 'Mayor%'") or die("req" . mysql_error());
$gt = mysql_num_rows($getreq);
while ($ic < $gt) {
while ($getr = mysql_fetch_row($getreq)) {
$ic++;
