<?php namespace Framework\Utilities; error_reporting(E_ALL); ini_set("display_errors", 1); include '../DatabaseFunctions.php'; echo "<h2>Testing DatabaseFunctions class</h2>"; /* Enter your database connection information. You should first import the sql file given in data folder */ $connection_information = array("host" => "localhost", "user" => "nadir", "password" => "kcbW5eFSCbPXbJGLHvUGG8T8", "database" => "dev_pakphp", "debug" => "2", "charset" => "utf8"); SelectQuery($connection_information); UpdateQuery($connection_information); InsertQuery($connection_information); //DeleteQuery($connection_information); /** * Used to select data from database * * @since 1.2.2 * @param array $connection_information an array with following keys: * host => the database host name * user => the database user * password => the database password * database => the database name * debug => the debug level it can be 0,1 or 2 * charset => utf8 */ function SelectQuery($connection_information) { /** The database connection details */ $parameters = $connection_information; /** The DatabaseFunctions object is created */
$totind = 0; $regfee = 0; $exemptedfee = 0; } //end wopi } // end cango //sakit na ulo ko $gtp = mysql_query("update ebpls_business_enterprise_permit set active = 0 where\n\t\t\t\t\t\towner_id ='{$owner_id}' and business_id ='{$business_id}'"); // $gtp = mysql_query("update ebpls_business_enterprise_permit set active = 1 where // owner_id ='$owner_id' and business_id ='$business_id' order by for_year desc limit 1"); $yeary = $yearnow - 1; $wil = UpdateQuery($dbtype, $dbLink, "tempbusnature", "active=0", "owner_id ='{$owner_id}' and business_id ='{$business_id}'"); $wil = UpdateQuery($dbtype, $dbLink, "tempbusnature", "active=1", "owner_id ='{$owner_id}' and business_id ='{$business_id}' and date_create like '{$yeary}%'"); $wil = UpdateQuery($dbtype, $dbLink, "tempassess", "active=0", "owner_id ='{$owner_id}' and business_id ='{$business_id}'"); $wil = UpdateQuery($dbtype, $dbLink, "tempassess", "active=1", "owner_id ='{$owner_id}' and business_id ='{$business_id}' and date_create like '{$yeary}%'"); //will create permit record $res = InsertQuery($dbtype, $dbLink, "ebpls_business_enterprise_permit", "\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},'{$yearnow}', \n\t\t\t\tnow(), '{$usern}', '{$stat}', \n\t\t\t\t0,'For Assessment', '{$pin}', 1"); ?> <body onload="alert('Assessment Process Completed'); parent.location='index.php?part=4&class_type=Permits&itemID_=1221&owner_id=<?php echo $owner_id; ?> &com=<?php echo $stat; ?> &permit_type=Business&stat=<?php echo $stat; ?> &business_id=<?php echo $business_id;
<?php if ($reg_but == 'Save') { $chkboat = SelectDataWhere($dbtype, $dbLink, "fish_boat", " where boat_name='{$boat_name}'"); $chkboat = NumRows($dbtype, $chkboat); if ($chkboat == 1 and $editit != 1) { ?> <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>
$tt = $tt + $totind; $grandamt = $tt; if (is_numeric($gethuh[amtformula])) { $gethuh[amtformula] = number_format($gethuh[amtformula], 2); } print "<td align=right width=25%>\n <input type=hidden name=natureid[{$varx}] value={$gethuh['natureid']}>\n <input type=hidden name=z[{$varx}] value={$gethuh['amtformula']}>{$usemin1} \n\t{$gethuh['amtformula']} {$show_complex} \n\t<input type=hidden name=taxfeeid[{$varx}] value={$gethuh['taxfeeid']}></td>\n <td align=right width=25%>\n\t<input type=hidden name=y{$varx} value={$totind} size=5 readonly>{$usemin} {$taxdue}</td>\n </tr>"; $usemin = ''; $havemayor = strpos(strtolower($getd[tfodesc]), 'mayor'); //echo $getd[taxfeetype]."<br>"; if ($getd[taxfeetype] != 1 || $havemayor > -1) { $feecompute1 = $feecompute1 + $totind; $tt = $tt - $totind; $grandamt = $tt; $nyotfee = $totind + $nyotfee; } $result1 = UpdateQuery($dbtype, $dbLink, "tempassess", "compval='{$totind}'", "owner_id='{$owner_id}'\n and business_id='{$business_id}' and natureid='{$gethuh['natureid']}'\n and taxfeeid='{$gethuh['taxfeeid']}' and active=1"); /* ============================*/ } else { //put to tempassess; $nat_id = $getn[0]; if ($getd[indicator] == 2 and $stt == 'New') { //if formula $indi = 1; $basis = $getn[2]; if ($getd[basis] == 3) { $basis = 0; } if ($getd[mode] == 2) { //complex include_once "class/TaxFeeOtherChargesClass.php"; $searchme = new TaxFee();
$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 = ''; $feeid = ''; $desc = ''; $amt = ''; $ptype = ''; if ($feet == "") { $feet = "Motorized";
$updateit = UpdateQuery($dbtype, $dbLink, $permittable, "released = 1, steps='Released'", "owner_id = {$owner_id}"); $checkrentype = @mysql_query("select * from ebpls_motorized_penalty where permit_type = '{$permit_type}'"); $checkrentype1 = @mysql_fetch_assoc($checkrentype); if ($permit_type == "Motorized") { $updatetempt = mysql_query("update ebpls_mtop_temp_fees set active = '0' where owner_id = '{$owner_id}' and year = '{$yearsdf}'"); } if ($checkrentype1['renewaltype'] == '2' and $stat == "ReNew") { $updateit = UpdateQuery($dbtype, $dbLink, "ebpls_motorized_vehicles", "retire = '5'", "motorized_operator_id = '{$owner_id}' and retire='4'"); $nbvyear = date('Y'); $updateit1 = UpdateQuery($dbtype, $dbLink, "ebpls_fees_paid", "active = '0'", "owner_id = '{$owner_id}' and active = '1' and input_date like '{$nbvyear}%'"); $updateit2 = UpdateQuery($dbtype, $dbLink, "renew_vehicle", "paid = '1'", "owner_id = '{$owner_id}' and paid = '0' and date_updated like '{$nbvyear}%'"); } } else { /* */ $updateit = UpdateQuery($dbtype, $dbLink, $permittable, "{$incode}='{$permitnumber}', \n\t\t\t\treleased = 1, steps='Release',transaction='{$stat}', released_date=now()", "owner_id={$owner_id} and business_id={$business_id}\n\t\t\t\torder by business_permit_id desc limit 1\n\t\t\t\t"); } $isrel = 0; } else { $permitnumber = $veri[1]; $isrel = 1; } $permit_num = $permitnumber; if ($permit_type == 'Business') { $report_desc = 'Business Permit'; ?> <body onLoad="javascript:window.open('reports/ebpls_buss_permit.php?owner_id=<?php echo $owner_id; ?> &business_id=<?php echo $business_id;
$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; ?> &busItem=<?php echo $permit_type; ?>
$interestrate = $getpended[rateofinterest] * $d; } elseif ($getpended['inttype'] == '2') { while ($x <= $d) { $counter = $counter * $intrate; $x++; } $interestrate = $counter - 1; } if ($getpended['feeonly'] == '1') { $busint = $interestrate * $nTotalTax; } elseif ($getpended['feeonly'] == '2') { $busint = $interestrate * ($nTotalTax + $nTotalFee); } elseif ($getpended['feeonly'] == '3') { $busint = $interestrate * ($nTotalTax + $nTotalFee + $buspen); } $updatebus = UpdateQuery($dbtype, $dbLink, "bus_grandamt", "active = 0", "owner_id = '{$owner_id}' and business_id='{$business_id}' and ts != '{$yearnow1}'"); $ramt2 = round($ramt2, 2); $nTaxnFee = round($nTotalTax + $nTotalFee, 2); $nTotalTax = round($nTotalTax, 2); $buspen = round($buspen, 2); $busint = round($busint, 2); $nbacktax = round($nbacktax, 2); $divtax = round($divtax, 2); $totalexptax = round($totalexptax, 2); $totexemption = $grandamt * $getbusexempt1[tax_exemption] / 100; $totexemption = round($totexemption, 2); $busvalues = "'', '{$owner_id}', '{$business_id}', '{$nTaxnFee}', '{$buspen}', '{$busint}', '0', '{$nTotalTax}', '', '1', '{$stat}', '{$totexemption}', '{$yearnow1}', '{$pmode}', '{$robert}'"; $insertbus = InsertQuery($dbtype, $dbLink, "bus_grandamt", "", $busvalues); } } //}
<?php if ($stat == 'New') { $tftype = 1; } elseif ($stat == 'ReNew') { $tftype = 2; } else { $tfttype = 3; } //update old assess $ui = UpdateQuery($dbtype, $dbLink, "tempassess", "active = 0", "owner_id={$owner_id} and\r\n\t\t business_id={$business_id} and transaction<>'{$stat}'"); //use decimal $dec = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_preference", ""); $dec = FetchArray($dbtype, $dec); $dec = $dec[sdecimal]; if ($dec == '1') { $d = '('; } else { $d = '(int)('; } $df = 0; //get naturecode if ($stat == 'Retire') { $retstr = "and a.retire=2"; } else { $retstr = ''; } $getnat = SelectMultiTable($dbtype, $dbLink, "tempbusnature a, ebpls_buss_nature b", "a.bus_code, b.naturedesc, a.cap_inv, a.last_yr, a.transaction", "where owner_id={$owner_id} and business_id={$business_id} \r\n\t\t\tand a.bus_code=b.natureid and active = 1 {$retstr}"); while ($getn = FetchRow($dbtype, $getnat)) { $stt = $getn[4]; if ($stt == 'New') {
$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 } } ?>
<?php if ($permit_type != 'Business') { $searchif = SelectDataWhere($dbtype, $dbLink, $permittable, " where owner_id={$owner_id}"); $existid = NumRows($dbtype, $searchif); if ($existid == 0) { $inserttemp = InsertQuery($dbtype, $dbLink, $permittable, "({$incode}, owner_id, for_year, {$appdate}, paid,transaction)", "'{$permitcode}', {$owner_id}, '{$currdate['year']}', '{$tdate}', 0,'{$stat}')"); } if ($tag == 'Occupational' and $permit_type == 'Occupational') { //update occu permit if ($existid != 0) { if ($frmedit == 'yes') { $slash = 'add'; require_once "includes/stripslash.php"; $updateemp = UpdateQuery($dbtype, $dbLink, "ebpls_occupational_permit", "occ_position_applied ='{$pos_app}',\n\t\t\t business_id='{$employer_business}',\n\t\t\t for_year='{$currdate['year']}'", "owner_id={$owner_id} and active=1"); } } else { $slash = 'add'; require_once "includes/stripslash.php"; if ($frmedit != 'yes') { if ($employer_business > 0) { $insertemp = InsertQuery($dbtype, $dbLink, "ebpls_occupational_permit", "(owner_id , occ_permit_application_date, \n\t\t\t\t\tocc_position_applied, for_year, paid,\n\t\t\t\t\ttransaction, steps, pin, active, business_id)", "{$owner_id}, '{$tdate}', '{$pos_app}',\n \t\t\t'{$currdate['year']}', 0,'{$stat}', 'For Payment', \n\t\t\t\t\t'{$pin}', 1, {$employer_business}"); } else { ?> <body onload='alert("Please select employer."); parent.location="index.php?part=4&itemID_=1221&permit_type=Occupational&stat=<?php echo $stat; ?> &owner_id=<?php echo $owner_id; ?> &upOwner=UPDATE&business_id=<?php
$grandamt = 0; $totfee = 0; $exemptot = 0; $totind = 0; $regfee = 0; } //end wopi } // end cango $yearnow2 = $yearnow - 1; $wil = UpdateQuery($dbtype, $dbLink, "tempassess", "active=0", "owner_id ='{$owner_id}' and business_id ='{$business_id}'"); $wil = UpdateQuery($dbtype, $dbLink, "tempassess", "active=1", "owner_id ='{$owner_id}' and business_id ='{$business_id}' and date_create like '{$inputdate}%'"); $wil = UpdateQuery($dbtype, $dbLink, "tempbusnature", "active=0", "owner_id ='{$owner_id}' and business_id ='{$business_id}'"); $cht = mysql_query("select distinct(bus_code) from tempbusnature where owner_id='{$owner_id}' and business_id='{$business_id}'"); $cnte = mysql_num_rows($cht); $wil = UpdateQuery($dbtype, $dbLink, "tempbusnature", "active=1", "owner_id ='{$owner_id}' and business_id ='{$business_id}' and date_create like '{$yearnow2}-12%' limit {$cnte}"); $stat = 'ReNew'; ?> <body onload="alert('Assessment Process Completed'); parent.location='index.php?part=4&class_type=Permits&itemID_=1221&owner_id=<?php echo $owner_id; ?> &com=<?php echo $stat; ?> &permit_type=Business&stat=<?php echo $stat; ?> &business_id=<?php echo $business_id; ?>
} $wopi++; } if ($cango == '1') { $wopi = 0; $ui = UpdateQuery($dbtype, $dbLink, "tempassess", "active = 0", "owner_id='{$owner_id}' and\n business_id='{$business_id}'"); while ($wopi < $gr) { $tempid = $tempbus[$wopi]; $lastyr = $gross[$wopi]; $getbus = SelectDataWhere($dbtype, $dbLink, "tempbusnature", "where tempid={$tempid}"); $getbu = FetchRow($dbtype, $getbus); $bus_code = $getbu[1]; $bus_nature = $getbu[2]; $oldlay = $getbu[4]; $result = InsertQuery($dbtype, $dbLink, "tempbusnature", "", "'', '{$bus_code}', '{$bus_nature}',{$lastyr},\n \t \t{$lastyr},{$owner_id},{$business_id}, now(),\n\t \t0, 1,'','{$stat}','0'"); $wil = UpdateQuery($dbtype, $dbLink, "tempbusnature", "active=0", "tempid='{$tempid}'"); $wopi++; } // end wopi } ?> <body onload="alert('Assessment Process Completed'); parent.location='index.php?part=4&newpred=1&noregfee=1&class_type=Permits&itemID_=4212&owner_id=<?php echo $owner_id; ?> &com=assess&permit_type=Business&stat=<?php echo $stat; ?> &business_id=<?php echo $business_id; ?>
$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 echo $noregfee; ?> &class_type=Permits&itemID_=2212&owner_id=<?php echo $owner_id; ?> &com=cash&permit_type=<?php echo $permit_type; ?>
} } } } elseif ($com == 'DeAct') { ?> <body onload='javascript:alert("Fee DeActivated");'></body> <?php // print "<div align=center><font color=red>Fee DeActivated</font></div>"; $deact = UpdateQuery($dbtype, $dbLink, "culture_fee", "active=0", "culture_id='{$boat_type}' and transaction='{$trans}'"); $chkread = "checkbox"; } elseif ($com == 'Act') { ?> <body onload='javascript:alert("Fee Activated");'></body> <?php // print "<div align=center><font color=red>Fee Activated</font></div>"; $deact = UpdateQuery($dbtype, $dbLink, "culture_fee", "active=1", "culture_id='{$boat_type}' and transaction='{$trans}'"); $chkread = "checkbox"; } ?> <tr> <td align="right" valign="center" ><br> Unit Of Measure: </td> <td align="left" valign="center" ><br>   <input type=text name="uom" value="<?php echo $rr[6]; ?> "> </td></tr>
$updateit = UpdateQuery($dbtype, $dbLink, $vehicle, "motorized_operator_id = {$ft['old_owner']},permit_type='{$permit_type}',retire=2,transaction='Drop'", " motorized_motor_id='{$mid}'"); $D = DeleteQuery($dbtype, $dbLink, "vehicle_transfer", "motor_id='{$mid}' and\n\t\t\t\t\t\tnew_owner='{$owner_id}'"); ?> <body onload='javascript:("Vehicle Transferred Cancelled");'</body> <?php } else { ?> <body onload='javascript:ExistOther();'></body> <?php } } else { $delvec = DeleteQuery($dbtype, $dbLink, $vehicle, "motorized_motor_id={$mid}"); } } elseif ($com == 'Drop') { //drop vehicle $dropvek = UpdateQuery($dbtype, $dbLink, $vehicle, "retire=1, transaction={$com}", " motorized_motor_id={$mid}"); } require_once "includes/mtop.php"; } elseif ($clearveh == 'Clear' or $clearveh == 'Cancel') { $mid = ''; $mmodel = ''; $mnum = ''; $cnum = ''; $pnum = ''; $bnum = ''; $route = ''; $ltype = ''; $bcolor = ''; $ltoreg = ''; $cro = ''; $buttag1 = 'Clear';
require_once "ebpls-php-lib/utils/ebpls.search.funcs.php"; //--- get connection from DB //$dbLink = get_db_connection(); global $ThUserData; require_once "includes/variables.php"; include "lib/multidbconnection.php"; $dbLink = Open($dbtype, $connecttype, $dbhost, $dbuser, $dbpass, $dbname); if ($msgid == '') { $msgid = 0; } 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); }
<?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>
CreateNewHost($EditId, $EditArr); } if (ValidId($HostId) && !ValidVar($EditPage) && !ValidVar($EditEvent) && ValidArr($EditArr)) { UpdateHost($HostId, $EditArr); } if ($EditPage == "new" && ValidArr($EditArr)) { 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);
if ($savenat != '') { $nat = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_nature", "where natureid='{$_idx}'"); $getnat = FetchArray($dbtype, $nat); $getna = $getnat['naturedesc']; $nat = SelectDataWhere($dbtype, $dbLink, "tempbusnature", "where tempid='{$savenat}'"); $getnat = FetchArray($dbtype, $nat); $transme = $getnat['transaction']; if ($transme == 'New') { $multi = $_cap; $oldm = $getnat[cap_inv]; } else { $multi = $lastyr; $oldm = $getnat[last_yr]; } $result = UpdateQuery($dbtype, $dbLink, "tempbusnature", "bus_code={$_idx}, bus_nature='{$getna}', cap_inv='{$_cap}',\n last_yr='{$lastyr}'", "tempid='{$savenat}'"); $result = UpdateQuery($dbtype, $dbLink, "tempassess", "multi='{$multi}'", "owner_id='{$owner_id}' and\n\t\t\t\t\t business_id='{$business_id}' and natureid = '{$business_nature_code}'\n\t\t\t\t\t and transaction = '{$stat}' and multi='{$oldm}'"); } else { $check = SelectDataWhere($dbtype, $dbLink, $tempbiz, "where bus_code='{$_idx}' and business_id={$business_id}\n and owner_id={$owner_id}"); $checkit = NumRows($dbtype, $check); if ($checkit == 0) { //get nature_desc $nat = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_nature", "where natureid='{$_idx}'"); $getnat = FetchArray($dbtype, $nat); $getnat = $getnat['naturedesc']; //save to temp table if ($stat == 'New') { if ($business_capital_investment != 0) { $oki = 1; } else { $oki = 0; }
$howmany = $howmany - 1; } $i = 0; while ($i < $howmany) { $i++; //echo $varx."<BR>"; if (!is_numeric($x[$i])) { ?> <body onload='javascript:alert("Invalid Input");'></body> <?php $i = $howmany; $woki = 0; } else { $woki = 2; if ($invest_up != 1) { $res = UpdateQuery($dbtype, $dbLink, "tempassess", "multi={$x[$i]}", "assid='{$i}'\n\t\t \t and owner_id={$owner_id} and business_id={$business_id} \n\t\t\t\t\t\tand active=1 and transaction='{$stat}'"); } } } $i = 1; if ($woki == 1) { while ($i < $howmany) { if ($invest_up != 1) { $res = UpdateQuery($dbtype, $dbLink, "tempassess", "multi={$x[$i]},compval={$y[$i]}", "assid='{$i}' and owner_id={$owner_id} \n\t\t\t\tand business_id={$business_id} and active=1\n\t and transaction='{$stat}'"); } $i++; } } } require_once "ebpls4222.php"; }
} else { $woki = 1; } $i++; } if ($updateit == 1) { $ftag = 'Update'; } else { $ftag = 'Save'; } } $i = 0; if ($woki == 1) { while ($i < $no_range) { if ($updateit == '1') { $insnew = UpdateQuery($dbtype, $dbLink, "boat_fee", "boat_type='{$boat_type}',\n range_lower={$rangelow[$i]},\n range_higher={$rangehigh[$i]},\n unit_measure='{$uom}',\n amt={$amt[$i]}, transaction = '{$ptype}'", "fee_id={$feeid[$i]}"); } else { if ($userenew == true) { $insnew = InsertQuery($dbtype, $dbLink, "boat_fee", "", "'','{$boat_type}',{$rangelow[$i]},\n\t\t\t\t\t\t\t{$rangehigh[$i]},'{$uom}',{$amt[$i]},'New',1,3"); $insrenew = InsertQuery($dbtype, $dbLink, "boat_fee", "", "'','{$boat_type}',{$rangelow[$i]},\n\t {$rangehigh[$i]},'{$uom}',{$amt[$i]},'ReNew',1,3"); } else { $insnew = InsertQuery($dbtype, $dbLink, "boat_fee", "", "'','{$boat_type}',{$rangelow[$i]},\n\t \t {$rangehigh[$i]},'{$uom}',{$amt[$i]},'{$ptype}',1,3"); } } $i++; } if ($updateit == '1') { ?> <body onload='UpRec();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 {
$updateit = UpdateQuery($dbtype, $dbLink, $permittable, "steps='For Releasing'", "owner_id={$owner_id} and business_id={$business_id}"); // save fees paid $gettag = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_preference", ""); $gettag = FetchArray($dbtype, $gettag); if ($gettag[sassess] == '') { //check if have rec $chkit = SelectDataWhere($dbtype, $dbLink, "bus_fees_paid", "where owner_id={$owner_id} and \n\t\t\t\t\t\tbusiness_id={$business_id}"); $chkit = NumRows($dbtype, $chkit); if ($chkit == 0) { $getfee = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_tfo", "where\ttfoindicator=1 and \n\t\t\t\t\t\ttaxfeetype!=1 and tfostatus='A'"); while ($getf = FetchRow($dbtype, $getfee)) { $insit = InsertQuery($dbtype, $dbLink, "bus_fees_paid", "''", "'',{$owner_id}, {$business_id},\n\t\t\t\t\t\t{$getf['0']}, {$getf['6']},now())"); } } } $updatebusnature = UpdateQuery($dbtype, $dbLink, "tempbusnature", "linepaid=5,recpaid=1", "owner_id={$owner_id} and business_id={$business_id} and active='1'"); ?> <body onunload='opener.location.reload(true); ' onLoad='window.open("ebplsreceipt.php?owner_id=<?php echo $owner_id; ?> &business_id=<?php echo $business_id; ?> &or_no=<?php echo $or_no; ?> &cn=<?php echo $orno; ?> &cmd=<?php echo $cmd;