<?php } elseif ($gf[2] == '2') { //formula eval("\$tfee={$ft['1']}{$gf['3']};"); ?> <td><?php echo number_format($tfee, 2); ?> </td> <?php } elseif ($gf[2] == '3') { //range $getr = SelectDataWhere($dbtype, $dbLink, "culture_range", "where\n\t\t\tculture_id={$getengine211['culture_id']} and range_lower<={$ft['1']} and\n\t\t\trange_higher >= {$ft['1']}"); $numr = NumRows($dbtype, $getr); if ($numr == 0) { $getr = SelectDataWhere($dbtype, $dbLink, "culture_range", "where\n culture_id={$getengine211['culture_id']} and range_lower<={$ft['1']} and\n range_higher = '0'"); } $getre = FetchArray($dbtype, $getr); if (is_numeric($getre[amt])) { ?> <td><?php $tfee = $getre[amt]; echo number_format($getre[amt], 2); ?> </td> <?php } else { eval("\$tfee={$ft['1']}{$getre['amt']};"); ?> <td><?php echo number_format($tfee, 2);
<td align="right" valign="top" class='normal' colspan=4> </td> </tr> <?php //if ($owner_id<>'' and $business_id<>'') { $ic = 0; $col1 = 0; $getreq = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_requirements", "where recstatus='A' and reqindicator='1' and permit_type='Business'"); $gt = NumRows($dbtype, $getreq); while ($ic < $gt) { while ($getr = FetchRow($dbtype, $getreq)) { $ic++; if ($col1 == 0) { include 'tablecolor-inc.php'; print "<tr bgcolor='{$varcolor}'>\n"; } $check1 = SelectDataWhere($dbtype, $dbLink, "havereq", " where owner_id={$owner_id}\n \tand business_id={$business_id} \n\t\t\t\t\tand reqid={$getr['0']}"); $hreq = NumRows($dbtype, $check1); if ($hreq == 0) { $insertreq = InsertQuery($dbtype, $dbLink, "havereq", "", "'', {$getr['0']}, {$owner_id}, {$business_id},0"); $ch = 'UNCHECKED'; $gethr[4] = 0; } else { $gethr = FetchRow($dbtype, $check1); if ($gethr[4] == 1) { $ch = 'CHECKED'; } else { $ch = 'UNCHECKED'; } } $getr[1] = stripslashes($getr[1]); print "\t\n\t\t\t\t<td align=right width=5%><input type=hidden name=colre[{$ic}] \n\t\t\t\tvalue={$getr['0']}>  \n\t\t\t\t<input type=checkbox name=x[{$ic}] {$ch}></td><td align=left width=23%>{$getr['1']}\n\t\t\t\t</td>";
$ry = $rt["iReset"]; if ($ry == '1') { $getpyr = mysql_query("select * from {$permittable} order by {$incode} desc"); $gt = mysql_fetch_assoc($getpyr); $anoba = $gt["for_year"]; if ($anoba == date('Y')) { //get total number of permit released $curyr = date('Y'); $gettotal = SelectDataWhere($dbtype, $dbLink, $permittable, "where released = 1 and for_year = '{$curyr}'"); $gettot = NumRows($dbtype, $gettotal); } else { $gettot = 0; } } else { //get total number of permit released $gettotal = SelectDataWhere($dbtype, $dbLink, $permittable, "where released = 1"); $gettot = NumRows($dbtype, $gettotal); } $sequence = $getcode[2]; $sequence = '100000000000' + $sequence; $sequence = $sequence + $gettot + 1; $sequence = substr($sequence, 1, 11); if ($getcode[1] == '1') { // check if have date $permitnumber = $getcode[0] . "-" . $currdate[year] . "-" . $sequence; } else { $permitnumber = $getcode[0] . "-" . $sequence; } if ($permit_type != 'Business') { //insert permitcode to $permittable $updateit = UpdateQuery($dbtype, $dbLink, $permittable, "{$incode}='{$permitnumber}'", "owner_id={$owner_id}");
$getr = FetchRow($dbtype, $get); $feedesc = stripslashes($getr[1]); $feeamount = $getr[2]; if ($permit_type != 'Motorized') { $ptype = $getr[3]; } else { $ptype = $getr[5]; $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>
} if ($istat == 'ReNew') { // || $istat=='Retire') { require "includes/penalty.php"; } } else { echo "0.00"; $amt2pay[$si + 1] = 0; } ?> </td> <?php //check if no more line to pay $hvl = SelectDataWhere($dbtype, $dbLink, "tempbusnature", "where owner_id = {$owner_id} and\n\t\t\tbusiness_id={$business_id} and linepaid=0"); $hvl = NumRows($dbtype, $hvl); //getpayhistory if ($balance == '') { $balance = $tabs; } if ($balance >= 0) { //echo $cnthave."-".$gethis."<BR>"; if ($iswev == 1) { //$gethis=1; } if ($gethis == 0 and $hvl > 0 and $amt2pay[$si + 1] > 0) { if ($mayunpaid == 1) { $unpaid = 2; } else { $mayunpaid = 1;
?> </table> <table border =0 align=left class=sub> <tr><td></td><td>Total Payments Made:</td><td><font color=red><b>Php <?php echo number_format($totpay, 2); ?> <b></font></td><td></td> </table> <?php if ($bpar == 1 || $ulev == 6 || $ulev == 7 and $totpay > 0) { $ge = SelectDataWhere($dbtype, $dbLink, "havereq", "where owner_id={$owner_id} and\n active=1 and business_id={$business_id}"); $ge = NumRows($dbtype, $ge); $getreq = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_requirements", "where recstatus='A' and reqindicator=1 and permit_type='Business'"); $gt = NumRows($dbtype, $getreq); $gettag = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_preference", ""); $getre = FetchArray($dbtype, $gettag); $checkapp = mysql_query("select * from ebpls_buss_approve a where\n \t\t\t\t\t\ta.owner_id='{$owner_id}' and\n a.decision=1 and a.business_id={$business_id}"); $checka = mysql_num_rows($checkapp); if ($checka == 0) { $gud = 0; } else { if ($getre[srequire] == 1) { if ($ge == $gt) { $gud = 1; } else { $gud = 0; } } else { $gud = 1; }
?> "> <table border =0 width=60% align=center><Br><br> <tr> <td> Copy from Line of Business </td> <td align=center ><?php echo get_select_data($dbLink, "fromnat", "ebpls_buss_nature", "natureid", "naturedesc", $fromnat, "true", "naturestatus='A' and natureid<>'{$natureid}' order by naturedesc", "onchange='_FRM.submit();'"); ?> </td> </tr> </table> <table border =0 width=70% align=center><Br> <?php $ic = 0; $col1 = 0; $getreq = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_taxfeeother a, ebpls_buss_tfo b", "where a.tfo_id=b.tfoid and a.natureid='{$fromnat}' order by a.mode"); $gt = NumRows($dbtype, $getreq); while ($ic < $gt) { while ($s = FetchArray($dbtype, $getreq)) { $ic++; if ($col1 == 0) { include 'tablecolor-inc.php'; print "<tr bgcolor='{$varcolor}'>\n"; } if ($s[taxtype] == 1) { $lbl = ' (New)'; } if ($s[taxtype] == 2) { $lbl = ' (ReNew)'; } if ($s[taxtype] == 3) {
//$updateveches = UpdateQuery($dbtype, $dbLink, 'ebpls_motorized_vehicles', "transaction = '$stat'", //"motorized_operator_id = '$owner_id' and retire = '0'"); if ($linkpro == 'RELEASING') { $checkrentype = @mysql_query("select * from ebpls_motorized_penalty where permit_type = '{$permit_type}'"); $checkrentype1 = @mysql_fetch_assoc($checkrentype); if ($checkrentype1['renewaltype'] == '2' and $stat == "ReNew") { $updateit = UpdateQuery($dbtype, $dbLink, "ebpls_motorized_vehicles", "retire = '5'", "motorized_operator_id = '{$owner_id}' and retire = '4'"); $vbnmyear = date('Y'); $updateit321 = UpdateQuery($dbtype, $dbLink, "ebpls_motorized_vehicles", "retire = '5'", "motorized_operator_id = '{$owner_id}' and retire = '0' and create_ts like '{$vbnmyear}%'"); $nbvyear = date('Y'); $updateit = UpdateQuery($dbtype, $dbLink, "ebpls_fees_paid", "active = '0'", "owner_id = '{$owner_id}' and active = '1' and input_date like '{$nbvyear}%'"); } elseif ($stat == "Transfer/Dropping") { $updateit = UpdateQuery($dbtype, $dbLink, "ebpls_motorized_vehicles", "retire = '2', motorized_operator_id = ''", "motorized_operator_id = '{$owner_id}' and retire = '1'"); $nbvyear = date('Y'); $updateit1 = UpdateQuery($dbtype, $dbLink, "ebpls_fees_paid", "active = '0'", "owner_id = '{$owner_id}' and active = '1' and input_date like '{$nbvyear}%'") or die(mysql_error); $checkifmore = SelectDataWhere($dbtype, $dbLink, "ebpls_motorized_vehicles", "where motorized_operator_id = '{$owner_id}'"); $ifmore = mysql_num_rows($checkifmore); if ($ifmore > 0) { $nbvyear = date('Y'); $updateit1 = UpdateQuery($dbtype, $dbLink, "ebpls_motorized_operator_permit ", " motorized_no_of_units = '{$ifmore}', transaction = 'ReNew', steps = 'For Payment'", "owner_id = '{$owner_id}' and active = '1' and for_year = '{$nbvyear}'") or die(mysql_error); } } ?> <body onload="parent.location='index.php?part=4&class_type=Permits&itemID_=3212&owner_id=<?php echo $owner_id; ?> &com=PrintReport&permit_type=<?php echo $permit_type; ?> &stat=<?php echo $stat;
echo $getmsg[2]; ?> </textarea> </td> </tr> </table> <table border=1 align=center width=600<br><br> <tr> <td align=center>Keyword</td><td align=center>Message</td><td></td> </tr> <?php if ($submitbt == 'Search') { $sms = SelectDataWhere($dbtype, $dbLink, "sms_message", "where keyword like '{$keyword}%'"); } else { $sms = SelectDataWhere($dbtype, $dbLink, "sms_message", ""); } while ($msg = FetchRow($dbtype, $sms)) { $msg[1] = stripslashes($msg[1]); $msg[2] = stripslashes($msg[2]); ?> <tr> <td><input type=hidden name=msgid value=<?php echo $msg[0]; ?> > <?php echo $msg[1]; ?> </td> <td>
} } elseif ($getpended['renewaltype'] == '2') { if ($getpended[backtax] == '1') { //BackTax Computation for Scenario 2.... Goodluck sakin!!!!!! if ($permit_type == 'Motorized') { $getvech = @mysql_query("select * from ebpls_motorized_vehicles where motorized_operator_id = '{$owner_id}' and permit_type = 'Motorized' and retire='4' and paid = '0'"); $totvech = mysql_num_rows($getvech); $totalotherpen = 0; $totalotherint = 0; $totalotherlate = 0; while ($getvec = @mysql_fetch_assoc($getvech)) { $getlen = strlen($getvec[motorized_plate_no]); $getlastnum = substr($getvec[motorized_plate_no], $getlen - 1, $getlen); $nsrenewaldate = "renewaldate{$getlastnum}"; $nmrenewaldate = $getpended[$nsrenewaldate]; $totvec = SelectDataWhere($dbtype, $dbLink, "ebpls_motorized_vehicles", "where motorized_operator_id = '{$owner_id}' \n\t\t\t\t\t\tand permit_type='{$permit_type}' and retire=0"); $totvec1 = NumRows($dbtype, $totvec); $anongyearngayon = date('Y'); $getlastnpaydate = @mysql_query("select * from renew_vehicle where owner_id = '{$owner_id}' and motorized_motor_id = {$getvec['motorized_motor_id']} and date_updated not like '{$anongyearngayon}%' and paid = '1' order by date_updated desc limit 1"); $checkifnotempty = @mysql_num_rows($getlastnpaydate); if ($checkifnotempty == 0) { $getlastnpaydate = @mysql_query("select pay_date as date_updated from temppayment where owner_id = '{$owner_id}' and permit_type = 'Motorized' and pay_date not like '{$anongyearngayon}%' order by pay_date desc limit 1"); } $getlastnpaydate = @mysql_fetch_assoc($getlastnpaydate); $getlastnpaydate1 = substr($getlastnpaydate[date_updated], 0, 4); $lastpaydateyear = $getlastnpaydate1 + 1; $lastpaydateyearys = $getlastnpaydate1 + 1; $nyeardiff = $yeartoday - $lastpaydateyear; $ngyeardiff = $nyeardiff; $xloop = 1; $backtaxcompute = 0;
<?php //Module that saves information to table bus_grandamt //if ($itemID_ == "4212") { $yearfornow = date('Y'); if (strtolower($pmode) == 'quarterly') { $paympart = $qtrcnt; } if (strtolower($pmode) == 'semi-annual') { $paympart = $semcnt; } if (strtolower($pmode) == 'annual') { $paympart = '1'; } if ($ramt2 == 0) { $getgh = SelectDataWhere($dbtype, $dbLink, "bus_grandamt", "where owner_id = '{$owner_id}' and business_id = '{$business_id}' and transaction='{$stat}' and ts = '{$yearfornow}' and paymode = '{$pmode}' and paypart = '{$paympart}'"); $getghg = FetchRow($dbtype, $getgh); $nghigh = $getghg[3]; } else { $nghigh = 0; } $updatebus = UpdateQuery($dbtype, $dbLink, "bus_grandamt", "active = 0", "owner_id = '{$owner_id}' and business_id='{$business_id}' and ts != '{$yearfornow}'"); if ($nghigh <= 0) { $ramt2 = round($ramt2, 2); $buspen = round($buspen, 2); $busint = round($busint, 2); $nbacktax = round($nbacktax, 2); $divtax = round($divtax, 2); $totalexptax = round($totalexptax, 2); //if ($) { // $nbacktax = 0;
$clr = 1; } elseif ($stat == 'ReNew') { $result = InsertQuery($dbtype, $dbLink, "tempbusnature", "", "'', '{$bus_code}', '{$bus_nature}',{$oldlay}, \n\t\t\t{$lay},{$owner_id},{$business_id}, now(), \n\t\t\t0, 1,'','ReNew')"); $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 } }
&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"); } }
//$owner_id=$owner_id; $owner_first_name = $res[0]; $owner_middle_name = $res[1]; $owner_last_name = $res[2]; if ($tag == 'Occupational' and $permit_type == 'Occupational') { //$owner_id = $idcnt; require_once "includes/form_add_mtoppermit.html"; //require_once "includes/form_pay_occu.html"; $getemp = SelectMultiTable($dbtype, $dbLink, "{$permittable} a, ebpls_business_enterprise b", "a.occ_permit_code,a.occ_permit_application_date, \r\n\t\t\t a.occ_position_applied , b.business_name", "where a.owner_id={$owner_id} and a.business_id=b.business_id"); $getit = FetchRow($dbtype, $getemp); $permit_code = $getit[0]; $pos_app = $getit[2]; $permit_date = $getit[1]; $employer_name = $getit[3]; require_once "includes/form_pay_midoccu.php"; require_once "includes/paymtop.php"; } elseif ($permit_type == 'Peddlers') { require_once "includes/form_add_mtoppermit.html"; $getemp = SelectDataWhere($dbtype, $dbLink, $permittable, "where owner_id={$owner_id}"); $getit = FetchArray($dbtype, $getemp); $merchandise = stripslashes($getit[merchandise_sold]); $peddler_bus = stripslashes($getit[peddlers_business_name]); $apply = $getit[application_date]; $permid = $getit[peddlers_permit_id]; require_once "includes/form_pay_midpeddler.html"; require_once "includes/paymtop.php"; } else { require_once "includes/form_add_mtoppermit.html"; require_once "includes/paymtop.php"; } }
<?php /* Purpose: Approval processing Modication History: 2008.05.06 RJC Define undefined to clean up phperror.log */ require_once "includes/variables.php"; $PROCESS = isset($PROCESS) ? $PROCESS : ''; //2008.05.06 define undefined $com = isset($com) ? $com : ''; if ($com != 'approve') { // process successful if ($PROCESS == 'SAVE' || $PROCESS == 'PAYMENT') { $dec_comment = addslashes($dec_comment); $getapp = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_approve", "where owner_id = {$owner_id} and \n\t\t\t\t business_id={$business_id}"); $getnum = NumRows($dbtype, $getapp); if ($getnum == 0) { $savedata = InsertQuery($dbtype, $dbLink, "ebpls_buss_approve", "", "'',{$owner_id}, {$business_id}, {$decide}, \n\t\t\t\t '{$dec_comment}', '{$stat}'"); } else { $updata = UpdateQuery($dbtype, $dbLink, "ebpls_buss_approve", "decision={$decide},dec_comment='{$dec_comment}', \n\t\t\t\t transaction='{$stat}'", "owner_id = {$owner_id} and business_id={$business_id}"); } if ($decide == 1) { $updateit = UpdateQuery($dbtype, $dbLink, $permittable, "steps='For Payment'", "owner_id={$owner_id} and business_id={$business_id}"); } if ($PROCESS == 'PAYMENT' and $decide == 1) { ?> <body onload="parent.location='index.php?part=4&newpred=<?php echo $newpred; ?> &noregfee=<?php
<?php if ($totind < $getd['defamt']) { $totind = $getd['defamt']; $compvalrange = $getd['defamt']; $usemin = 'Replaced with Minimum Amount '; $compval = $getd['defamt']; } $getd['tfodesc'] = addslashes($getd['tfodesc']); $chkintfo = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_tfo", "where tfodesc='{$getd['tfodesc']}'"); $chkintfo = FetchArray($dbtype, $chkintfo); if ($chkintfo['taxfeetype'] == 1) { $tottax = $tottax + $totind; } $getd['tfodesc'] = stripslashes($getd['tfodesc']);
$buttag = 'Save'; $buttag1 = 'Cancel'; } require_once "includes/form_add_mtoppermit.html"; require_once "includes/form_add_middlepermit.php"; require_once "includes/mtop.php"; } elseif ($com == 'Delete' || $com == 'Drop') { $getown = SelectMultiTable($dbtype, $dbLink, $owner, "owner_first_name, owner_middle_name,\n owner_last_name, owner_gender", " where owner_id={$owner_id}"); $res = FetchRow($dbtype, $getown); $owner_first_name = $res[0]; $owner_middle_name = $res[1]; $owner_last_name = $res[2]; $owner_gender = $res[3]; $buttag = 'Add'; $buttag1 = 'Clear'; $verdel = SelectDataWhere($dbtype, $dbLink, $vehicle, "where motorized_motor_id={$mid}"); $getver = FetchArray($dbtype, $verdel); $stat1 = $getver[status]; $owner_id = $ownerID; require_once "includes/form_add_mtoppermit.html"; require_once "includes/form_add_middlepermit.php"; if ($com == 'Delete') { //search history $getown = SelectMultiTable($dbtype, $dbLink, "ebpls_motorized_vehicles a, vehicle_transfer b", "motorized_motor_id", " where a.motorized_motor_id ='{$mid}' and a.motorized_motor_id=b.motor_id "); $gg = NumRows($dbtype, $getown); if ($gg > 0) { $getown = SelectMultiTable($dbtype, $dbLink, "ebpls_motorized_vehicles a, vehicle_transfer b", "*", " where a.motorized_motor_id ='{$mid}' and a.motorized_motor_id=b.motor_id and\n b.new_owner='{$owner_id}'"); $ff = NumRows($dbtype, $getown); $ft = FetchArray($dbtype, $getown); if ($ff > 0) { //update vehicle
$tftype = 2; } elseif ($stt == 'Retire') { $tftype = 3; } //print labels $pdf->SetX(15); $pdf->Cell(30, 5, 'LINE OF BUSINESS : ', 0, 0, 'L'); $pdf->SetX(45); $pdf->Cell(75, 5, $getn[1], 1, 1, 'L'); $pdf->SetX(15); $pdf->Cell(30, 5, 'TAXES/FEES', 0, 1, 'L'); $pdf->SetX(15); $pdf->Cell(30, 5, 'BASE VALUE/INPUT', 1, 0, 'C'); $pdf->Cell(45, 5, 'AMOUNT/FORMULA', 1, 0, 'C'); $pdf->Cell(25, 5, 'TAX DUE', 1, 1, 'C'); $cnt = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_taxfeeother a, ebpls_buss_tfo c", "where natureid={$getn['0']} and a.taxtype='{$tftype}'\n and c.tfoid=a.tfo_id {$tft}"); $cnt1 = NumRows($dbtype, $cnt); //get total count of tax per natureid $lop1 = 0; $getd1 = SelectMultiTable($dbtype, $dbLink, "ebpls_buss_taxfeeother a,\n ebpls_buss_nature b, ebpls_buss_tfo c", "c.tfodesc, a.amtformula, a.taxfeeid, b.naturedesc, a.indicator,\n a.basis, a.mode,c.taxfeetype, c.tfoid, a.uom, a.min_amt", "where a.natureid={$getn['0']} and b.natureid={$getn['0']}\n and a.taxtype='{$tftype}' and c.tfoid=a.tfo_id\n {$tft} order by a.mode asc"); while ($lop1 < $cnt1) { while ($getd = FetchArray($dbtype, $getd1)) { $totind = 0; $pdf->SetX(15); $pdf->Cell(30, 5, $getd['tfodesc'], 1, 0, 'C'); $pdf->Cell(45, 5, $getd['amtformula'], 1, 0, 'C'); $show_complex = ''; $lop1++; $getyears = SelectMultiTable($dbtype, $dbLink, "tempassess a, ebpls_buss_tfo c", "c.or_print,a.date_create,c.tfodesc, c.counter", "where a.tfoid=c.tfoid and a.tfoid = {$getd['tfoid']} and a.active=0 \n\t\t\t\t order by a.date_create desc limit 1"); $getyr = FetchArray($dbtype, $getyears); $bill_date = date('Y') - date('Y', strtotime($getyr[date_create]));
<?php require_once "includes/variables.php"; include "lib/multidbconnection.php"; $dbLink = Open($dbtype, $connecttype, $dbhost, $dbuser, $dbpass, $dbname); $wil2 = UpdateQuery($dbtype, $dbLink, "tempbusnature", "retire=1", "owner_id={$owner_id} and\n business_id={$business_id} and\n active=1 and transaction='Retire'"); $updatebusnature = UpdateQuery($dbtype, $dbLink, "tempbusnature", "active=0", "owner_id={$owner_id} and\n business_id={$business_id} and transaction='Retire'"); $chkretire = SelectDataWhere($dbtype, $dbLink, "tempbusnature", "where owner_id={$owner_id} and\n business_id={$business_id} and active=1"); $chkretire = FetchRow($dbtype, $chkretire); if ($chkretire == 0) { $updateretire = UpdateQuery($dbtype, $dbLink, "ebpls_business_enterprise", "retire=1, business_retirement_date=now()", "owner_id={$owner_id} and business_id={$business_id}"); $ubp = UpdateQuery($dbtype, $dbLink, "ebpls_business_enterpr1ise_permit", "active = 0", "owner_id = {$owner_id} and\n business_id = {$business_id}"); } else { //deact all permit $ubp = UpdateQuery($dbtype, $dbLink, "ebpls_business_enterprise_permit", "active = 0", "owner_id = {$owner_id} and \n\t business_id = {$business_id}"); //active 1 $updatepermit = UpdateQuery($dbtype, $dbLink, "ebpls_business_enterprise_permit", "active=1", "owner_id={$owner_id} and business_id={$business_id}\n and transaction<>'Retire' order by business_permit_id desc limit 1"); //change pmode back to orig -- ang orig sa bicol ay baboy $getpmode = SelectDataWhere($dbtype, $dbLink, "ebpls_business_enterprise_permit", "where owner_id={$owner_id} and business_id={$business_id}\n and pmode<>'' order by business_permit_id desc limit 1"); $pmode = FetchArray($dbtype, $getpmode); $pmode = $pmode[pmode]; $updatepmode = UpdateQuery($dbtype, $dbLink, "ebpls_business_enterprise", "business_payment_mode = '{$pmode}'", "owner_id={$owner_id} and business_id={$business_id}"); } ?> <body onload="parent.location='index.php?part=4&class_type=Permits&permit_type=Business&busItem=Business&itemID_=2212&mtopsearch=SEARCH'";></body>
print "<td NOWRAP> {$get_info['6']} </td>\n"; print "<td> {$get_info['7']} </td>\n"; // print "<td> $field </td>\n"; $staxfee = SelectMultiTable($dbtype, $dbLink, "ebpls_buss_preference", "sassess, predcomp", ""); $prefset = FetchArray($dbtype, $staxfee); $sassesscomplex = $prefset['sassess']; // per estab $predcomp = $prefset['predcomp']; if ($predcomp == 1) { $owner_id = $get_info[0]; $business_id = $get_info[1]; $getnat = SelectDataWhere($dbtype, $dbLink, "tempbusnature", " where owner_id={$owner_id} and business_id={$business_id} and active =1\n and transaction='{$get_info['7']}' and date_create like '{$yearnow}%'"); $cntnat = mysql_num_rows($getnat); $getnat = SelectDataWhere($dbtype, $dbLink, "tempbusnature", " where owner_id={$owner_id} and business_id={$business_id} and active =0\n and transaction='{$get_info['7']}' and date_create like '{$yearnow}%'"); $orignat = mysql_num_rows($getnat); $getnat = SelectDataWhere($dbtype, $dbLink, "tempbusnature", " where owner_id={$owner_id} and business_id={$business_id}\n and transaction='{$get_info['7']}' and date_create like '{$yearnow}%'"); $nat = mysql_num_rows($getnat); if ($orignat == '') { $orignat = $cntnat; } if ($orignat < $nat) { $newpred = '1'; $noregfee = 1; } } $newpred = isset($newpred) ? $newpred : '0'; //2008.05.06 $noregfee = isset($noregfee) ? $noregfee : 0; print "<td NOWRAP>\n <a href='index.php?part=4&newpred={$newpred}&noregfee={$noregfee}&class_type=Permits&itemID_=5212&permitid={$get_info['2']}&owner_id={$get_info['0']}&com=approve&permit_type={$tag}&stat={$get_info['7']}&business_id={$get_info['1']}&busItem=Business&istat={$get_info['7']}'> Select </a> \n </td>"; // }//end while print "</tr>\n";
$getfee = FetchRow($dbtype, $getfee); $ttfee = $ttfee + $getfee[0]; } $getot = SelectDataWhere($dbtype, $dbLink, $fee, " where permit_type='{$stat}' and active=1"); $getact = SelectMultiTable($dbtype, $dbLink, "fish_activity", "sum(act_fee)", "where owner_id={$owner_id} and transaction='{$stat}' and active = 1"); $getact = FetchRow($dbtype, $getact); $tfee1 = $getact[0]; $getboat = SelectDataWhere($dbtype, $dbLink, "fish_assess", "where owner_id={$owner_id}"); while ($getb = FetchArray($dbtype, $getboat)) { $getfee = SelectDataWhere($dbtype, $dbLink, "culture_fee", "where culture_id='{$getb['culture_id']}' and\n\t\t transaction='{$stat}' and active = 1 "); $getnum = FetchArray($dbtype, $getfee); if ($getnum[fee_type] == '3') { $getfee = SelectDataWhere($dbtype, $dbLink, "culture_range", "where culture_id='{$getb['culture_id']}' and\n\t\t range_lower<{$getb['amt']} and range_higher>={$getb['amt']} "); $getnum = NumRows($dbtype, $getfee); if ($getnum == 0) { $getfee = SelectDataWhere($dbtype, $dbLink, "culture_range", "where culture_id='{$getb['culture_id']}' and\n range_lower<={$getb['amt']} and range_higher=0"); } } $getfee1 = FetchArray($dbtype, $getfee); $ttfee1 = $ttfee1 + $getfee1[amt]; } ?> <table width=60%> <tr> <td>Fees from Boat Registration</td><td><?php echo number_format($ttfee, 2); ?> </td> </tr> <tr> <td>Fees from Fish Activities</td><td><?php
$numr = NumRows($dbtype, $getr); if ($numr == 0) { $getr = SelectDataWhere($dbtype, $dbLink, "culture_range", "where\n\t\t\t\t\t\t\t\tculture_id={$ft['3']} and range_lower<={$ft['1']} and\n\t\t\t\t\t\t\t\trange_higher = '0'"); } $getre = FetchArray($dbtype, $getr); if (is_numeric($getre[amt])) { $tfee = $getre[amt]; } else { eval("\$tfee={$ft['1']}{$getre['amt']};"); } } $tfee1 = $tfee1 + $tfee; } $backtaxcompute = $backtaxcompute + $tfee1; //Other Permit Fees $getot1 = SelectDataWhere($dbtype, $dbLink, "ebpls_fishery_fees", "where permit_type='{$stat}' and active=1"); $ff = 0; while ($getj = FetchArray($dbtype, $getot1)) { $otherfee = $getj[fee_amount]; $ff = $ff + $getj[fee_amount]; } $backtaxcompute = $backtaxcompute + $ff; $backtotalfee = $backtaxcompute; //Get Surcharge and Interest if ($getpen['indicator'] == '1') { $backpen = $getpen['rateofpenalty']; } elseif ($getpen['indicator'] == '2') { eval("\$backpen={$backtotalfee}*{$getpen['rateofpenalty']};"); } $backtaxcompute = $backtaxcompute + $backpen; $mpyear = date('Y');
} $tabs = abs($grdmt - $totalpaidtax); if ($grdmt == '0.00') { $grdmt = $grandamt; } $gettag = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_preference", ""); $gettag = FetchArray($dbtype, $gettag); if ($gettag[sassess] == '') { $grdmt = $ota - $add2fee + $totfee; $tabs = abs($grdmt - $totalpaidtax); $grandamt = $grdmt; } //getpayhistory $gethis = SelectDataWhere($dbtype, $dbLink, "ebpls_transaction_payment_or_details", "where trans_id={$owner_id} and payment_id={$business_id} and \n\t\t\t transaction='{$istat}' and payment_part='{$s}+1' and \n\t\t\t or_entry_type<>'CHECK'"); $getc = NumRows($dbtype, $gethis); $gethis = SelectDataWhere($dbtype, $dbLink, "ebpls_transaction_payment_or_details a, \n\t\t\tebpls_transaction_payment_check b", "where a.trans_id={$owner_id} and a.payment_id={$business_id} \n\t\t\t and a.transaction='{$istat}' and a.payment_part='{$s}+1' \n\t\t\t and a.or_entry_type='CHECK' and b.check_status='CLEARED'\n and a.or_no=b.or_no"); $getch = NumRows($dbtype, $gethis); $gethis = $getc + $getch; if ($gethis > 0 and $pmode == 'ANNUAL') { $grdmt = 0; $tabs = 0; $grandamt = 0; $an = 1; } if ($gettag[sassess] != 1) { $grdmt = $total_tax_compute + $total_sf_compute + $fee; //$grdmt=$fee+$gentax; ?> <table border=0 cellpadding=0 cellspacing=0 width="100%" align = center class=sub> <td width=25%> </td><td> </td>
if (strtolower($pmode) == 'semi-annual') { if ($montoday >= 1 and $montoday <= 6) { $ssemcnt = 1; } elseif ($montoday >= 7 and $montoday <= 12) { $ssemcnt = 2; } if ($ssemcnt == '1') { $getpendedrenewal = $getrenew['semdue1']; } elseif ($ssemcnt == '2') { $getpendedrenewal = $getrenew['semdue2']; } } if (strtolower($pmode) == 'annual') { $getpendedrenewal = $getpended['renewaldate']; } $getstartdate = SelectDataWhere($dbtype, $dbLink, "ebpls_business_enterprise", "where owner_id = {$owner_id} and business_id={$business_id} and retire=0"); $getstart = FetchArray($dbtype, $getstartdate); $startdate = $getstart[business_start_date]; $renewaldate = "{$addend}{$getpendedrenewal}"; $renewaldate = strtotime($renewaldate); $renewaldate = date('Y-m-d', $renewaldate); $nStartDate = date('Y-m-d', strtotime($startdate)); //get cash first $getcas = SelectMultiTable($dbtype, $dbLink, "ebpls_transaction_payment_or a,\n ebpls_transaction_payment_or_details b", "sum(a.total_amount_paid) as cash", "where a.or_no=b.or_no and b.trans_id={$owner_id} and\n b.or_entry_type='CASH' and\n b.payment_id={$business_id} and b.transaction='{$stat}'"); $getcash = FetchRow($dbtype, $getcas); $getclear = SelectMultiTable($dbtype, $dbLink, "ebpls_transaction_payment_check a,\n ebpls_transaction_payment_or b,\n ebpls_transaction_payment_or_details c", "sum(a.check_amount)", "where a.or_no=b.or_no and a.or_no=c.or_no and b.or_no=c.or_no and\n c.or_entry_type='CHECK' and a.check_status='CLEARED' and\n c.transaction='{$istat}' and\n c.trans_id={$owner_id} and c.payment_id={$business_id}"); $totcheck = FetchRow($dbtype, $getclear); $taonnatinngayon = date('Y'); $buwannatinngayon = date('m'); if (strtolower($pmode) == "quarterly") { if ($buwannatinngayon >= 1 and $buwannatinngayon <= 3) {
$sendthis = "Your Tax Due Is " . $sendthis; } } elseif ($keyword == 'duedate') { $business_id = $getstat[2]; $owner_id = $getstat[1]; $getdue = SelectMultiTable($dbtype, $dbLink, 'ebpls_business_enterprise', "business_payment_mode", "where owner_id='{$owner_id}' and business_id='{$business_id}'"); $getit = FetchRow($dbtype, $getdue); $getdue1 = SelectDataWhere($dbtype, $dbLink, 'ebpls_buss_penalty1', ""); $getnow = Fetcharray($dbtype, $getdue1); echo $getit[0]; 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;
if (strtolower($list_option) == 'capital investment') { $totinv = $resulta[cap_inv]; } else { $totinv = $resulta[last_yr]; } $totinv1 = $totinv1 + $totinv; $pdf->Cell(30, 5, number_format($totinv, 2), 1, 0, 'R'); $getlineb = mysql_query("select sum(a.compval) as tax_due \n\t\t\t\tfrom tempassess a where a.owner_id={$resulta['owner_id']} and\n a.business_id={$resulta['business_id']} and\n a.active=1 and natureid<>'' and taxfeeid<>''"); $resultb = mysql_fetch_assoc($getlineb); $totdue = $resultb[tax_due]; $gtotdue = $gtotdue + $totdue; $dec = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_preference", ""); $sas = FetchArray($dbtype, $dec); $sas = $sas[sassess]; if ($sas == '') { $resultf = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_tfo", "where tfoindicator='1' and tfostatus='A' and taxfeetype<>'1' and \n\t\t\ttfodesc not in (select tfodesc from \n\t\t\tebpls_buss_tfo where tfodesc like 'garbage%')"); $cntfee = NumRows($dbtype, $resultf); $feetype = 1; while ($getf = FetchRow($dbtype, $resultf)) { $getex = SelectMultiTable($dbtype, $dbLink, "ebpls_business_enterprise a, \n\t\t\tfee_exempt b, ebpls_buss_tfo c", "a.*", "where a.business_id={$resulta['business_id']} and\n a.business_category_code=b.business_category_code and\n c.tfoid={$getf['0']} and b.tfoid={$getf['0']} and\n b.active=1"); $getfeex = NumRows($dbtype, $getex); if ($getfeex > 0) { $exemptedfee = $exemptedfee + $getf[6]; $usemin = 'Fee Exempted '; $getf[6] = 0; } $regfee = $regfee + $getf[6]; $totfee = $totfee + $getf[6]; $usemin = ''; } ///garbage fee in place
<!--<body onload='javascript:alert("Line Already Added");'></body>--><?php } } } } //editline } if ($business_id == '') { $business_id = 0; } //get bus nature $getnat = SelectDataWhere($dbtype, $dbLink, "tempbusnature", " where owner_id={$owner_id} and business_id={$business_id}\n and active = 1"); while ($getit = FetchArray($dbtype, $getnat)) { $getit['bus_nature'] = stripslashes($getit['bus_nature']); $bus_code = $getit['bus_code']; $getcapinv = SelectDataWhere($dbtype, $dbLink, "tempbusnature", " where owner_id={$owner_id} and business_id={$business_id} and bus_code='{$bus_code}'\n order by tempid asc limit 1"); $getcapi = FetchArray($dbtype, $getcapinv); $ifpaid = $getit['recpaid']; $editline = isset($editline) ? $editline : ''; //2008.05.08 if ($editline == 'y' and $natcode == $getit['tempid']) { ?> <tr> <td align="left" valign="top" class='normal'> <?php if ($stat == 'New' || $stat == 'ReNew' and $watdo == '') { echo get_select_data_where($dbLink, 'business_nature_code', 'ebpls_buss_nature ', 'natureid', 'naturedesc', $getit['bus_code'], "naturestatus='A' and natureid not in (select bus_code from tempbusnature where business_id='{$business_id}' and owner_id='{$owner_id}' and bus_code<>{$getit['bus_code']} and retire < 1) order by naturedesc"); } else { echo $getit['bus_nature']; } ?>
<tr><td colspan=4 align="center" valign="center" class='header2' width='100%'> Line of Business </td></tr> <?php //get bus nature $lope = 0; $gr = 0; while ($lope < $delayed) { ?> <tr><td></td><td >Gross Sales for <?php echo $yearnow - $delayed + $lope; ?> </td></tr> <?php $yearko = $yearnow - $delayed + $lope; $yearar = $yearar . ($yearnow - $delayed + $lope) . ","; $lope++; $getnat = SelectDataWhere($dbtype, $dbLink, "tempbusnature", " where owner_id={$owner_id} and business_id={$business_id}\n and active = 1"); while ($getit = FetchArray($dbtype, $getnat)) { $getit[bus_nature] = stripslashes($getit[bus_nature]); //check if have inputted value $getinput = mysql_query("select * from ebpls_buss_taxfeeother where\n\t\t\t\t\t\t\t\t\t\t\t\tnatureid = '{$getit['bus_code']}' and basis=3 and taxtype=2"); $getin = mysql_num_rows($getinput); $getwe = mysql_fetch_assoc($getinput); ?> <tr> <td><?php echo $getit[bus_nature]; ?> <input type=hidden name=yearko[<?php echo $gr; ?> ] value=<?php
} else { $depval = ''; $depval1 = ''; } print "<tr><td align =right>Engine Capacity</td><td> \n\t\t\t<input type=hidden name=feeid[{$i}] value={$getrec['0']}>\n <input type=text name=rangelow[{$i}] size=5 value={$getrec['2']} {$depval}> \n <input type=text name=rangehigh[{$i}] size=5 value={$getrec['3']} {$depval1}> \n <input type=text name=amt[{$i}] size=5 value={$getrec['5']}></td>\n </td><td> </td>\n </tr>"; $depval = ''; $depval1 = ''; $i++; } } } if ($addrange == 'Add Range') { if ($updateit == 1) { $ftag = 'Update'; $chkread = 'hidden'; $cntrec = SelectDataWhere($dbtype, $dbLink, "boat_fee", "where boat_type='{$boat_type}'\n\t\t\tand transaction='{$trans}' order by fee_id"); $cnt = NumRows($dbtype, $cntrec); print "<tr><td></td><td><br>Range Low Range High Amount</td><td></td></tr>"; while ($i < $cnt) { while ($getrec = FetchRow($dbtype, $cntrec)) { $boat_type = $getrec[1]; $no_range = $cnt; $uom = $getrec[4]; $ptype = $getrec[6]; if ($i == '0') { $depval = 'readonly'; } elseif ($i == $cnt - 1) { $depval1 = 'readonly'; } else { $depval = ''; $depval1 = '';
$datetoday = date("Y-d-m H:i:s"); $nOccupancy = new EBPLSOccupancy($dbLink, 'false'); $nOccupancy->setData(OCCUPANCY_TYPE_CODE, $nCode); $nOccupancy->setData(OCCUPANCY_TYPE_DESC, $nType); $nOccupancy->setData(OCCUPANCY_TYPE_DATE_UPDATED, $datetoday); $nOccupancy->setData(UPDATED_BY, $ThUserData[username]); $nOccupancy->update($bbo); $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 = ''; }