$pnum = '';
$bnum = '';
$route = '';
$ltype = '';
$bcolor = '';
$ltoreg = '';
$cro = '';
$buttag1 = 'Clear';
$owner_id = $ownerID;
require_once "includes/form_add_mtoppermit.html";
require_once "includes/form_add_middlepermit.php";
require_once "includes/mtop.php";
}
//occu permit clean up
if ($permit_type == 'Occupational') {
$delit = DeleteQuery($dbtype, $dbLink, "ebpls_occupational_permit", "active = 0 and occ_permit_application_date = now()");
}
if ($linkpro == 'PAYMENT') {
if ($permit_type == 'Franchise') {
?>
<body onload="parent.location='index.php?part=4&class_type=Permits&itemID_=2212&stat=<?php
echo $stat;
?>
&com=cash&permit_type=<?php
echo $permit_type;
?>
&busItem=Franchise&owner_id=<?php
echo $owner_id;
?>
'">
<?php
$MFees = $getr[7];
}
require_once "includes/form_mtop.php";
} elseif ($com == 'Delete') {
if ($com1 == 'act') {
$get = SelectDataWhere($dbtype, $dblink, $dtable, "where fee_id = '{$bbo}'");
$get1 = @mysql_fetch_assoc($get);
$desc = $get1[fee_desc];
$exist = SelectDataWhere($dbtype, $dblink, 'ebpls_fess_paid', "where fee_desc = '{$desc}'");
$exist1 = @mysql_num_rows($get);
if ($exist1 > 0) {
?>
<body onLoad='javascript:alert ("Cannot Delete, Record exist in other table");'></body>
<?php
} else {
$delrec = DeleteQuery($dbtype, $dbLink, $dtable, "fee_id='{$bbo}'");
?>
<body onLoad='javascript:alert ("Fee Deleted"); parent.location="index.php?part=4&class_type=Preference&permit=others&selMode=ebpls_notherfees&action_=8&itemEvent=1&data_item=0";'></body>
<?php
}
} else {
$delrec = UpdateQuery($dbtype, $dbLink, $dtable, "active=0", "fee_id={$owner_id}");
?>
<body onLoad='javascript:alert ("Fee DeActivated"); parent.location="index.php?part=4&class_type=Preference&permit=others&selMode=ebpls_notherfees&action_=8&itemEvent=1&data_item=0";'></body>
<?php
}
//$delrec =mysql_query ("delete from $dtable where fee_id =$id") or die("DELETE Error: ".mysql_error());
//int "<td align=right><font color=red>Record Dele</font></td>";
//int "<td align=left><font color=red>ted Successfully</font></td>";
$owner_id = '';
$id = '';
//get garbage zone
$getbar = SelectMultiTable($dbtype, $dbLink, "ebpls_business_enterprise a, ebpls_barangay b", "b.g_zone", "where a.owner_id={$owner_id} and a.business_id={$business_id} \n\t\t\tand a. business_barangay_code=b.barangay_code");
$getbara = FetchRow($dbtype, $getbar);
$g_zone = $getbara[0];
if ($stat == 'New') {
$tftype = 1;
} elseif ($stat == 'ReNew') {
$tftype = 2;
} else {
$tfttype = 3;
}
//update old assess
if ($com == 'assess' and $itemID_ == 4212 and $tftnum == 1) {
$yearold = $yearnow - 1;
$ui = UpdateQuery($dbtype, $dbLink, "tempassess", "active = 0", "owner_id={$owner_id} and\n business_id={$business_id} \n\t\t and date_create like '{$yearold}%'");
$ui = DeleteQuery($dbtype, $dbLink, "tempassess", "owner_id={$owner_id} and\n business_id={$business_id} and active=1");
} else {
if ($com == 'edit' || $itemID_ != 4212) {
$PROCESS = 'COMPUTE';
}
}
//use decimal
$dec = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_preference", "");
$dec = FetchArray($dbtype, $dec);
$dec = $dec[sdecimal];
if ($dec != '1') {
$is_dec = '(int)';
} else {
$is_dec = '';
}
$df = 0;
// per estab
//get garbage zone
$getbar = SelectMultiTable($dbtype, $dbLink, "ebpls_business_enterprise a, ebpls_barangay b", "b.g_zone", "where a.owner_id={$owner_id} and a.business_id={$business_id} \n\t\t\tand a. business_barangay_code=b.barangay_code");
$getbara = FetchRow($dbtype, $getbar);
$g_zone = $getbara[0];
if ($stat == 'New') {
$tftype = 2;
} elseif ($stat == 'ReNew') {
$tftype = 2;
} else {
$tfttype = 2;
}
//update old assess
$yearold = $yearnow1 - 1;
$ui = UpdateQuery($dbtype, $dbLink, "tempassess", "active = 0", "owner_id='{$owner_id}' and\n business_id='{$business_id}' and natureid='{$bus_code}'\n\t\t and date_create like '{$yearold}%'");
$ui = DeleteQuery($dbtype, $dbLink, "tempassess", "owner_id={$owner_id} and\n business_id={$business_id} and active=1 and natureid='{$bus_code}' and date_create like '{$yearnow1}%'");
//use decimal
$dec = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_preference", "");
$dec = FetchArray($dbtype, $dec);
$dec = $dec[sdecimal];
if ($dec != '1') {
$is_dec = '(int)';
} else {
$is_dec = '';
}
$df = 0;
//get naturecode
$retstr = '';
$getnat = SelectMultiTable($dbtype, $dbLink, "tempbusnature a, ebpls_buss_nature b", "a.bus_code, b.naturedesc, a.cap_inv, a.last_yr, a.transaction,a.linepaid", "where owner_id={$owner_id} and business_id={$business_id} \n\t\t\tand a.bus_code=b.natureid and active = 1 and a.bus_code = '{$bus_code}' {$retstr}");
while ($getn = FetchRow($dbtype, $getnat)) {
$grandamt = 0;
AddSitePage($HostId, $EditArr);
}
if (ValidId($EditPage) && ValidArr($EditArr)) {
UpdatePage($EditPage, $EditArr);
}
if (ValidId($DeletePage)) {
DeletePage($DeletePage);
}
if (ValidId($EditEvent) && ValidArr($EditArr2)) {
UpdateQuery($EditEvent, $EditArr2);
}
if (ValidVar($EditEvent) == "new" && ValidId($EventPage) && ValidArr($EditArr2)) {
CreateQuery($EventPage, $EditArr2);
}
if (ValidId($DeleteEvent)) {
DeleteQuery($DeleteEvent);
}
if (ValidId($HostId) && ValidVar($NewHost)) {
CreateNewSiteHost($HostId, $NewHost);
}
if (ValidArr($Enable)) {
SetEnable($Enable);
}
if (ValidId($DelSiteHost)) {
DeleteSiteHost($DelSiteHost);
}
}
/////////////////////////////////////////////
///////// display section here
//// companies list
if (!$EditPage && !$HostId && !$EditId) {
2008.04.18 RJC Simple code cleanup
2008.05.15 RJC Define undefine variables
*/
require_once "lib/ebpls.lib.php";
require_once "lib/ebpls.utils.php";
require_once "ebpls-php-lib/utils/ebpls.search.funcs.php";
global $ThUserData;
require_once "includes/variables.php";
$mtopsearch = isset($mtopsearch) ? $mtopsearch : '';
//2008.05.15
$com = isset($com) ? $com : '';
$minus_hm = isset($minus_hm) ? $minus_hm : '';
$invest_up = isset($invest_up) ? $invest_up : '';
if (isset($delass) && $delass == 1) {
$ui = UpdateQuery($dbtype, $dbLink, "tempassess", "active = 1", "owner_id='{$owner_id}' and\n business_id='{$business_id}' \n\t\t and date_create like '{$yearold}%'");
$ui = DeleteQuery($dbtype, $dbLink, "tempassess", "owner_id={$owner_id} and\n business_id={$business_id} and active=1 \n and date_create like '{$yearnow}%' and transaction='{$stat}' ");
}
// display search form
if (isset($com) && $com == 'reassess') {
$yearold = $yearnow - 1;
$ui = UpdateQuery($dbtype, $dbLink, "tempassess", "active = 0", "owner_id={$owner_id} and\n business_id={$business_id}\n and date_create like '{$yearold}%'");
}
if (isset($reloadna) && $reloadna == 1) {
$PROCESS = 'COMPUTE';
}
if (isset($com) && $com == 'edit') {
$PROCESS = 'COMPUTE';
$com = 'edit';
}
//if payment is made
if (isset($PROCESS) && $PROCESS == 'SAVE') {
if ($updateit == 1) {
$ftag = 'Update';
} else {
$updateit = '';
$ftag = 'Save';
}
if ($confx == '1') {
$cntrec = SelectDataWhere($dbtype, $dbLink, "fish_assess", "where culture_id='{$bbo}' and transaction='{$trans}'");
$cnt = NumRows($dbtype, $cntrec);
if ($cnt > 0) {
?>
<body onload='ExistOther();parent.location="index.php?part=4&class_type=Preference&selMode=ebpls_nfishcfees&permit=others&action_=8&itemEvent=1&data_item=0&orderbyasdes=1";'></body>
<?php
} else {
$deact = DeleteQuery($dbtype, $dbLink, "culture_fee", "culture_id='{$bbo}' and transaction='{$trans}'");
$deact = DeleteQuery($dbtype, $dbLink, "culture_range", "culture_id='{$bbo}'");
?>
<body onload='DelRec();parent.location="index.php?part=4&class_type=Preference&selMode=ebpls_nfishcfees&permit=others&action_=8&itemEvent=1&data_item=0&orderbyasdes=1";'></body>
<?php
}
}
if ($activ == 'FishingGear') {
$htag = 'Fishing Gear';
} else {
$htag = 'Fish Activities';
$htag1 = '" Fish Activities"';
}
//if ($updateit<>1 || $fishadd=='Update') {
//$boat_type=0;
//}
if ($updateit == 1) {
?>
<title>SMS Sender </title>
<div align = center>
<table border=0>
<td>
</td>
</table>
</div>
<?php
$getsend = SelectDataWhere($dbtype, $dbLink, "sms_send", "where new_sms=1 limit 1");
$getcnt = NumRows($dbtype, $getsend);
$smsid = $getit[0];
while ($getit = FetchRow($dbtype, $getsend)) {
$smsid = $getit[0];
$tym = date('H:m:s');
$x = 1;
echo "Sending Message: {$getit['2']} to {$getit['1']}<BR>";
$tym = date('H:m:s');
$mnum = $getit[1];
$mmsg = $getit[2];
$fileopened = fopen("textfile", "wb");
fwrite($fileopened, "To: {$mnum}\r\n\r\n");
fwrite($fileopened, "{$mmsg}");
fclose($fileopened);
$nRand = rand(00, 99999);
$copfile = shell_exec("cp textfile /home/site/gsm/outgoing/textfile{$nRand}");
sleep(2);
$updateit = DeleteQuery($dbtype, $dbLink, "sms_send", "smsid={$smsid}");
$archiveit = InsertQuery($dbtype, $dbLink, "sms_archive", "", "'','{$mnum}','{$mmsg}',now()");
}
setUrlRedirect("sms_sender.php");
$luk = SelectDataWhere($dbtype, $dbLink, $permittable, " \n\t\t\t\towner_id={$owner_id} and \n\t\t\t\tbusiness_id={$business_id} \n\t\t\t\tand active=1 and transaction='ReNew'");
$luk = NumRows($luk);
if ($luk == 0) {
$res = InsertQuery($dbtype, $dbLink, $permittable, "\n\t\t\t\t(business_id, owner_id, for_year,\n\t\t\t\tapplication_date,input_by, transaction, \n\t\t\t\tpaid, steps, pin, active)", "{$business_id}, {$owner_id},'{$currdate['year']}', \n\t\t\t\tnow(), '{$usern}', '{$stat}', \n\t\t\t\t0,'For Assessment', '{$pin}', 1");
}
$wil = UpdateQuery($dbtype, $dbLink, "tempbusnature", "active=0", "tempid=" . $tempid);
$bp = UpdateQuery($dbtype, $dbLink, $permittable, "active=0", "owner_id={$owner_id} and business_id={$business_id}\n\t\t\tand active=1");
$clr = 1;
} elseif ($stat == 'Retire') {
$wil = InsertQuery($dbtype, $dbLink, "tempbusnature", "", "'', '{$bus_code}', '{$bus_nature}',{$oldlay},\n {$lay},{$owner_id}, {$business_id}, now(),\n 0, 1,2,'Retire'");
$updatepermit = UpdateQuery($dbtype, $dbLink, "ebpls_business_enterprise_permit", "pmode='{$pmode}'", "owner_id={$owner_id} and \n\t\t\tbusiness_id={$business_id} order by \n\t\t\tbusiness_permit_id desc limit 1");
$wil3 = UpdateQuery($dbtype, $dbLink, "ebpls_business_enterprise", "business_payment_mode='Annual'", "owner_id={$owner_id} and business_id={$business_id}");
$luk = SelectDataWhere($dbtype, $dbLink, $permittable, " where \n\t\t\towner_id={$owner_id} and business_id={$business_id}\n and active=1 and transaction='Retire'");
$luk = NumRows($luk);
if ($luk == 0) {
$res = InsertQuery($dbtype, $dbLink, $permittable, "(business_id, owner_id, for_year,\n\t\t\tapplication_date,input_by, transaction, \n\t\t\tpaid, steps, pin, active)", "{$business_id},{$owner_id},'{$currdate['year']}', \n\t\t\tnow(), '{$usern}', '{$stat}', \n\t\t\t0,'For Assessment', '{$pin}', 1");
}
$wil = UpdateQuery($dbtype, $dbLink, "tempbusnature", "active=0", "tempid=" . $tempid);
$bp = UpdateQuery($dbtype, $dbLink, $permittable, "active=0", "owner_id={$owner_id} and business_id={$business_id}\n and active=1");
$clr = 1;
}
if ($clr == 1) {
$dt = DeleteQuery($dbtype, $dbLink, "tempassess", "owner_id={$owner_id} and business_id={$business_id}\n\t\t\tand active=1 and transaction='{$stat}'");
?>
<body onLoad='javascript: opener.location.reload(true); window.close()'></body>
<?php
}
}
?>
//if ($) {
// $nbacktax = 0;
//}
if ($paympart != '1') {
$nbacktax = 0;
$totalexptax = 0;
}
if ($stat == 'New') {
$checkfornew = mysql_query("select * from bus_grandamt where owner_id = '{$owner_id}' and business_id = '{$business_id}' and transaction = 'New' and ts != '{$yearfornow}' and paymode = '{$pmode}' and paypart = '{$paympart}'");
$checkfornew1 = mysql_num_rows($checkfornew);
} else {
$checkfornew1 = 0;
}
if ($checkfornew1 == 0) {
$deletebus = DeleteQuery($dbtype, $dbLink, "bus_grandamt", "owner_id = '{$owner_id}' and business_id = '{$business_id}' and transaction='{$stat}' and ts = '{$yearfornow}' and paymode != '{$pmode}'");
$deletebus = DeleteQuery($dbtype, $dbLink, "bus_grandamt", "owner_id = '{$owner_id}' and business_id = '{$business_id}' and transaction='{$stat}' and ts = '{$yearfornow}' and paymode = '{$pmode}' and paypart = '{$paympart}'");
if ($payst == "TAX WAIVED") {
$busvalues = "'', '{$owner_id}', '{$business_id}', '0', '0', '0', '0', '0', '', '1', '{$stat}', '0', '{$yearfornow}', '{$pmode}', '{$paympart}'";
} else {
$foryeard = substr($yearfornow, 0, 4);
$getpens = mysql_query("select sum(penalty), sum(surcharge) from comparative_statement where owner_id = '{$owner_id}' and business_id = '{$business_id}' and payment_number = '{$paympart}' and for_year = '{$foryeard}'");
$getpens1 = @mysql_fetch_row($getpens);
$setdef1 = 0;
$setdef2 = 0;
if ($nSurchargeAmount == "" || $nSurchargeAmount == 0) {
if ($paympart == $haveaddpay) {
$nSurchargeAmount = $getpens1[0];
} else {
$nSurchargeAmount = 0;
}
$setdef1 = 1;
$totind = 0;
$chngcompval = 1;
}
//$totind = round($ttn,2); //dating ganito
$totind = round($totind, 2);
$grandamt = $grandamt + $totind;
print "\r\n <td align=right width=25%>\r\n <input type=hidden name=natureid[{$varx}] value={$getn['0']}>\r\n\t<input type=hidden name=z[{$varx}] value={$getd['1']}>{$usemin1} {$nfgetd} {$rtag} \r\n <input type=hidden name=taxfeeid[{$varx}] value={$getd['2']}></td>\r\n <td align=right width=25%>\r\n\t<input type=hidden name=y{$varx} value={$ttnf} size =5 readonly>{$usemin} \r\n\t{$ttn} </td>\r\n </tr>\r\n";
$usemin = '';
$havemayor = strpos(strtolower($getd[0]), 'mayor');
if ($getd[7] != 1 || $havemayor > -1) {
$totmpf = $totmpf + $totind;
$feecompute = $feecompute + $totind;
$grandamt = $grandamt - $totind;
}
//delete if existing
$result = DeleteQuery($dbtype, $dbLink, "tempassess", "assid='{$varx}' and owner_id={$owner_id} \r\n\t\t\tand business_id={$business_id}\r\n\t\t\tand active=1 and transaction='{$stat}'");
//save to tempassess
if ($indi == 0) {
if ($rtag != 'range') {
$compval = $xv * $getd[1];
} else {
$compval = $compvalrange;
$totind = $compval;
if ($totind < $chkcp) {
//use minimum
$totind = $chkcp;
$compval = $chkcp;
}
}
if ($compval == '') {
eval("\$compval={$d}({$xv}{$getd['1']}));");
&busItem=Occupational";'></body>
<?php
}
}
}
}
//end if occupational
/*
if ($owner_id=='') {
$owner_id=$id;
}
*/
if ($permit_type == 'Occupational' || $permit_type == 'Peddlers') {
$totalvec = 1;
}
//need to add drop command
$getcnt = SelectDataWhere($dbtype, $dbLink, $temptbl, "where owner_id={$owner_id}");
$cnts = NumRows($dbtype, $getcnt);
// $lop=1;
for ($lop = 1; $lop <= $cnts; $lop++) {
$gettemp = SelectDataWhere($dbtype, $dbLink, $temptbl, "where owner_id={$owner_id} limit 1");
$getfee = FetchArray($dbtype, $gettemp);
$slash = 'add';
require_once "includes/stripslash.php";
//insert fees to main table
$fee_desc = addslashes($getfee[fee_desc]);
$insertit = InsertQuery($dbtype, $dbLink, "ebpls_fees_paid", "(owner_id, fee_desc, fee_amount, \n\t\t\t\tmulti_by, permit_type, permit_status,\n\t\t\t\tinput_by, input_date)", "{$owner_id}, '{$fee_desc}', {$getfee['fee_amount']}, \n\t\t\t\t{$totalvec}, '{$permit_type}', '{$status}', \n\t\t\t\t'{$usern}', '{$tdate}'");
$deltemp = DeleteQuery($dbtype, $dbLink, $temptbl, "owner_id ={$owner_id} and \n\t\t\t\t\tpermit_type='{$permit_type}' limit 1");
}
}
$bbo = "";
$com = 'edit';
?>
<body onload='UpRec();'></body>
<?php
}
}
} elseif ($confx == 1) {
$cntrec = SelectDataWhere($dbtype, $dbLink, "ebpls_occupancy_type a, ebpls_business_enterprise b", "where a.occupancy_type_code='{$bbo}' and b.business_occupancy_code=a.occupancy_type_code ");
$cnt = NumRows($dbtype, $cntrec);
if ($cnt > 0) {
?>
<body onload='ExistOther();parent.location="index.php?part=4&class_type=Preference&selMode=ebpls_noccupancy&is_desc=ASC";'></body>
<?php
} else {
$deact = DeleteQuery($dbtype, $dbLink, "ebpls_occupancy_type", "occupancy_type_code='{$bbo}'");
?>
<body onload='DelRec();parent.location="index.php?part=4&class_type=Preference&selMode=ebpls_noccupancy&is_desc=ASC";'></body>
<?php
}
$bbo = "";
$nCode = '';
$nType = '';
}
if ($com == 'edit' || $confx == 'cancel') {
$nOccupancy = new EBPLSOccupancy($dbLink, 'false');
$nOccupancy->search($bbo, NULL);
$nResult = $nOccupancy->out;
$occupancy_id = $nResult[banks_id];
$nCode = $nResult[occupancy_type_code];
$nType = $nResult[occupancy_type_desc];
if (strtolower($getit[0]) == 'quarterly') {
$sendthis = "Due date for 1st Q is {$getnow['qtrdue1']},2nd Q is {$getnow['qtrdue2']}, 3rd Q is {$getnow['qtrdue3']},4th Q is {$getnow['qtrdue4']}";
} elseif (strtolower($getit[0]) == 'semi-annual') {
$sendthis = "Due date for 1st sem is {$getnow['semdue1']},2nd sem is {$getnow['semdue2']}";
} elseif (strtolower($getit[0]) == 'annual') {
$getdue1 = SelectDataWhere($dbtype, $dbLink, 'ebpls_buss_penalty', "");
$getnow = FetchRow($dbtype, $getdue);
$sendthis = "Due date for this year is {$getnow['renewaldate']}";
}
} elseif ($keyword == 'req') {
}
}
}
//send it
$res = InsertQuery($dbtype, $dbLink, "sms_send", "", "'','{$cellnum}','{$sendthis}',1,now()");
$res = InsertQuery($dbtype, $dbLink, "sms_archive", "", "'','{$cellnum}','{$sendthis}',1,now()");
//flush
$delsms = DeleteQuery($dbtype, $dbLink, "sms", "smsid<>0 order by smsid asc limit 1");
}
if ($sendthis != '') {
echo "Message:" . $sendthis . " has been sent to " . $celnum;
} else {
echo "No New Messages Found. Will Search Again";
}
sleep(2);
setUrlRedirect('sms_server.php');
?>
if ($savebt == 'SAVE') {
if ($keyword != null and $message != null) {
$keyword = strtolower(addslashes($keyword));
$message = trim(addslashes($message));
if ($com == 'editsms') {
$result = UpdateQuery($dbtype, $dbLink, "sms_message", "keyword='{$keyword}', full_message='{$message}',\r\n\t\t\t\t\tdateupdated=now(),updateby='{$usern}'", "msgid={$msgid}");
} else {
$result = InsertQuery($dbtype, $dbLink, "sms_message", "", "'','{$keyword}','{$message}',now(),'{$usern}'");
}
$msgid = 0;
$keyword = '';
$message = '';
}
}
if ($com == 'deletesms') {
$result = DeleteQuery($dbtype, $dbLink, "sms_message", "msgid={$msgid}");
$msgid = 0;
} elseif ($com == 'editsms') {
$getmsg = SelectDataWhere($dbtype, $dbLink, "sms_message", "where msgid={$msgid}");
$getmsg = mysql_fetch_row($getmsg);
}
?>
<script language='Javascript' src='javascripts/default.js'></script>
<script language="Javascript">
function VerifyIt(x,y)
{
var _FRM = document._FRM;
var msgTitle = "SMS Settings\n";
if(x.value=='')
{
alert( msgTitle + "Please input a keyword!");
$debug = false;
require_once "includes/variables.php";
if ($updateit == 1) {
$ftag = 'Update';
} else {
$ftag = 'Save';
}
if ($confx == '1') {
$cntrec = SelectDataWhere($dbtype, $dbLink, "fish_boat", "where engine_type='{$bbo}'");
$cnt = NumRows($dbtype, $cntrec);
if ($cnt > 0) {
?>
<body onload='ExistOther();parent.location="index.php?part=4&class_type=Preference&selMode=ebpls_nboatfees&permit=others&action_=8&itemEvent=1&data_item=0&orderbyasdes=1";'></body>
<?php
} else {
$deact = DeleteQuery($dbtype, $dbLink, "boat_fee", "boat_type='{$bbo}' and transaction='{$trans}'");
echo "boat_type='{$bbo}' and transaction='{$trans}'";
?>
<body onload='DelRec();parent.location="index.php?part=4&class_type=Preference&selMode=ebpls_nboatfees&permit=others&action_=8&itemEvent=1&data_item=0&orderbyasdes=1";'></body>
<?php
}
}
if ($addrange == 'addr') {
if ($trans == '' and $fishadd == 'Update') {
$trans = $ptype;
$boat_type = $boat_type1;
}
$cntrec = SelectDataWhere($dbtype, $dbLink, "boat_fee", "where boat_type='{$boat_type}' and transaction='{$trans}' order by fee_id");
$no_range = NumRows($dbtype, $cntrec);
}
?>
<body onload='javascript:alert("Duplicate Boat Name Found");'></body>
<?php
} else {
if ($editit != 1) {
$insboat = InsertQuery($dbtype, $dbLink, "fish_boat", "", "'',{$owner_id},'{$boat_name}',\n\t\t\t\t\t\t'{$crew_num}','{$eng_type}',{$eng_cap},\n\t\t\t\t\t\t'{$reg_num}',now(),'{$usern}','',''");
} else {
$upboat = UpdateQuery($dbtype, $dbLink, "fish_boat", "boat_name='{$boat_name}', crew='{$crew_num}',\n\t\t\t\t\t\tengine_type='{$eng_type}', engine_cap={$eng_cap},\n\t\t\t\t\t\treg_no='{$reg_num}', up_date=now(), \n\t\t\t\t\t\tup_by='{$usern}'", "boat_id={$boatid}");
}
}
} else {
if ($fishcom == 'Edit') {
$getr = SelectDataWhere($dbtype, $dbLink, "fish_boat", "where boat_id = {$boatid}");
$getb = FetchRow($dbtype, $getr);
$editit = 1;
} elseif ($fishcom == 'Delete') {
$getd = DeleteQuery($dbtype, $dbLink, "fish_boat", "boat_id = {$boatid}");
$editit = '';
}
}
?>
<table cellspacing=0 cellpadding=0 border=1 width=60%>
<tr>
<td align="center" valign="top" class='header2' colspan=2>
Registration of Fishery Vehicles
</td>
</tr>
</table> <br>
<input type=hidden name=useboat value='Boat Registration'>
<input type=hidden name=editit value=<?php
