PHP SelectMultiTable函数代码示例

<?php

require_once "lib/ebpls.lib.php";
require_once "lib/ebpls.utils.php";
require_once "ebpls-php-lib/utils/ebpls.search.funcs.php";
//--- get connection from DB
global $ThUserData;
//$permit_type = 'Business';
require_once "includes/variables.php";
include_once "lib/multidbconnection.php";
$dbLink = Open($dbtype, $connecttype, $dbhost, $dbuser, $dbpass, $dbname);
$result = SelectMultiTable($dbtype, $dbLink, "{$owner}, ebpls_business_enterprise", " concat({$owner}.owner_first_name,' ', {$owner}.owner_middle_name, \r\n\t\t\t' ', {$owner}.owner_last_name) as full,\r\n                        ebpls_business_enterprise.business_name, \r\n\t\t\tebpls_business_enterprise.business_payment_mode", "where {$owner}.owner_id={$owner_id} and \r\n\t\t\tebpls_business_enterprise.owner_id={$owner_id} and\r\n                        ebpls_business_enterprise.business_id={$business_id}");
$list = FetchRow($dbtype, $result);
?>
<link rel="stylesheet" href="stylesheets/default.css" type="text/css"/>
<script language='Javascript' src='javascripts/default.js'></script>
<div align="CENTER">
<!---// start of the table //-->
<br>
<table border=0 cellspacing=0 cellpadding=0   width='90%'>
                <tr><td align="center" valign="center" class='titleblue'  width='90%'> Assessment for <?php 
echo ucfirst($permit_type);
?>
 Permit</td></tr>
                <tr><td align="center" valign="center" class='normal' height=10>&nbsp;</td></tr>
                <tr>
                        <td align="center" valign="center" class='normal'>
                          <form name="_FRM" method="POST"
action='index.php?part=4&class_type=Permits&itemID_=4212&owner_id=<?php 
echo $owner_id;
?>

    $pdf->Cell(80, 5, $resulta[busadd], 1, 0, 'L');
    $getline = mysql_query("select * from tempbusnature a\n\t\t\t\t\t\t\t\t where a.owner_id='{$resulta['owner_id']}' and\n\t\t\t\t\t\t\t\t a.business_id='{$resulta['business_id']}' and a.active=1\n\t\t\t\t\t\t\t\t ");
    /*--------------------------------------------------------------------------------
    frederick >>> found out that this script is located below/after the $getcap query
    This is the reason why the array $getl[bus_code] resulted empty and
    the capital investment did not appear in the report,
    therefore, this has been moved here:             */
    $getl = mysql_fetch_assoc($getline);
    //----------------------------------------------------------------------------------
    $getcap = mysql_query("select * from tempbusnature a\n\t\t\t\t\t\t\t\t where a.owner_id='{$resulta['owner_id']}' and\n\t\t\t\t\t\t\t\t a.business_id='{$resulta['business_id']}' and a.bus_code='{$getl['bus_code']}'\n\t\t\t\t\t\t\t\t  order by tempid");
    $getcap = mysql_fetch_assoc($getcap);
    $totcap = $totcap + $getcap[cap_inv];
    $totgross = $totgross + $getl[last_yr];
    $pdf->Cell(30, 5, number_format($getcap[cap_inv], 2), 1, 0, 'R');
    $pdf->Cell(30, 5, number_format($getl[last_yr], 2), 1, 0, 'R');
    $getcas = SelectMultiTable($dbtype, $dbLink, "ebpls_transaction_payment_or a,\n                        ebpls_transaction_payment_or_details b", "a.payment_code, a.or_date", "where a.or_no=b.or_no and b.trans_id={$resulta['owner_id']} and\n                        b.or_entry_type='CASH' and\n                        b.payment_id={$resulta['business_id']} and b.transaction='{$resulta['transaction']}' order by a.or_no desc");
    $getcash = FetchArray($dbtype, $getcas);
    $pdf->Cell(40, 5, $getcash[payment_code] . "/" . substr($getcash[or_date], 0, 11), 1, 0, 'C');
    $pdf->Cell(25, 5, substr($resulta[application_date], 0, 11), 1, 0, 'C');
    $pdf->Cell(10, 5, $resulta[transaction], 1, 1, 'C');
    $i++;
}
/*
$i = 1;
$pdf->SetY($Y_Table_Position);
while ($i < $number_of_rows)
{
    $pdf->SetX(1);
    $pdf->MultiCell(349,5,$i,1);
    $i = $i +1;   
} */

//2008.05.06
if ($mtopsearch == 'SEARCH') {
    //search existing
    require_once "includes/release_search.php";
} elseif ($com == 'PrintReport') {
    //verify if already have a permit code
    if ($permit_type != 'Business') {
        $vericode = SelectMultiTable($dbtype, $dbLink, $permittable, "released,{$incode}", "where owner_id = {$owner_id} and active=1 limit 1");
    } else {
        $vericode = SelectMultiTable($dbtype, $dbLink, $permittable, "released,{$incode}", "where owner_id = {$owner_id} and \n\t\t\t business_id={$business_id} and active = 1 limit 1");
    }
    $veri = FetchRow($dbtype, $vericode);
    if ($veri[0] == '0' || $veri[0] == '') {
        //assign new code
        //get format of permit
        $getcod = SelectMultiTable($dbtype, $dbLink, "permit_templates", "permit_header, permit_date, permit_sequence", "where permit_type='{$permit_type}'");
        $getcode = FetchRow($dbtype, $getcod);
        //check if have other permit last year
        //get setting
        $rr = mysql_query("select * from ebpls_buss_preference");
        $rt = mysql_fetch_assoc($rr);
        $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);

">
<input type=hidden name=noregfee value="<?php 
echo $noregfee;
?>
">
<th>Trans Type</th>
<th>Payment Mode</th>
<th>Payment Status</th>
</tr>
<?php 
/*
if ($owner_id=='') {
$owner_id=$own_id;
}
*/
$getdata = SelectMultiTable($dbtype, $dbLink, "ebpls_business_enterprise a, \n\t\t\t\tebpls_business_enterprise_permit b, {$owner} c", "a.business_payment_mode, b.paid, \n\t\t\tconcat(c.owner_last_name,',',c.owner_first_name,' ',c.owner_middle_name)\n\t\t\tas fullname, concat(c.owner_house_no,\n\t\t\tc.owner_street,c.owner_barangay_code,\n\t\t\tc.owner_zone_code,c.owner_district_code,\n\t\t\tc.owner_city_code,c.owner_province_code,\n\t\t\tc.owner_zip_code) as address, c.owner_gender,\n\t\t\tc.owner_phone_no, a.business_name, \n\t\t\tconcat(a.business_lot_no,' ', a.business_street,' ',   \n\t\t\ta.business_barangay_code,' ', a.business_zone_code,' ',    \n\t\t\ta.business_barangay_name,' ', a.business_district_code,' ',   \n\t\t\ta.business_city_code,' ', a.business_province_code,' ',  \n\t\t\ta.business_zip_code) as bizadd,b.transaction", "where a.owner_id = b.owner_id and a.business_id = b.business_id and \n\t\t\tc.owner_id={$owner_id} and\n\t\t\ta.owner_id = {$owner_id} and a.business_id = {$business_id} and \n\t\t\tb.transaction='{$stat}' and b.active=1");
$getid = FetchRow($dbtype, $getdata);
$pmode = $getid[0];
$getdata = mysql_query("select * from ebpls_owner a, ebpls_barangay b, ebpls_zone c,\n\t\t\t\t\t\tebpls_district d, ebpls_city_municipality e, ebpls_province f,\n\t\t\t\t\t\tebpls_zip g where owner_id = {$owner_id} and a.owner_barangay_code=b.barangay_code and\n\t\t\ta.owner_zone_code=c.zone_code and a.owner_district_code=d.district_code and\n\t\t\ta.owner_city_code=e.city_municipality_code and a.owner_province_code=f.province_code and\n\t\t\ta.owner_city_code=g.upper");
$getda = FetchArray($dbtype, $getdata);
if ($getda[zone_desc] == '') {
    $getdata = mysql_query("select * from ebpls_owner a, ebpls_barangay b, \n\t\t\t\t\t\tebpls_district d, ebpls_city_municipality e, ebpls_province f,\n\t\t\t\t\t\tebpls_zip g where owner_id = {$owner_id} and a.owner_barangay_code=b.barangay_code and\n\t\t\t a.owner_district_code=d.district_code and\n\t\t\ta.owner_city_code=e.city_municipality_code and a.owner_province_code=f.province_code and\n\t\t\ta.owner_city_code=g.upper");
    $getda = FetchArray($dbtype, $getdata);
}
$add = "{$getda['owner_street']} {$getda['barangay_desc']} {$getda['zone_desc']}, {$getda['district_desc']} \n\t\t{$getda['city_municipality_desc']}, {$getda['province_desc']}, {$getda['zip_code']}";
$getdata = mysql_query("select * from ebpls_business_enterprise a, ebpls_barangay b, ebpls_zone c,\n\t\t\t\t\t\tebpls_district d, ebpls_city_municipality e, ebpls_province f,\n\t\t\t\t\t\tebpls_zip g where owner_id = {$owner_id} and a.business_id='{$business_id}'\n\t\t\t\t\t\tand a.business_barangay_code=b.barangay_code and\n\t\t\ta.business_zone_code=c.zone_code and a.business_district_code=d.district_code and\n\t\t\ta.business_city_code=e.city_municipality_code and a.business_province_code=f.province_code and\n\t\t\ta.business_city_code=g.upper");
$getda = FetchArray($dbtype, $getdata);
if ($getda[zone_desc] == '') {
    $getdata = mysql_query("select * from ebpls_business_enterprise a, ebpls_barangay b, \n\t\t\t\t\t\tebpls_district d, ebpls_city_municipality e, ebpls_province f,\n\t\t\t\t\t\tebpls_zip g where owner_id = {$owner_id} and a.business_id='{$business_id}'\n\t\t\t\t\t\tand a.business_barangay_code=b.barangay_code and\n\t\t\t a.business_district_code=d.district_code and\n\t\t\ta.business_city_code=e.city_municipality_code and a.business_province_code=f.province_code and\n\t\t\ta.business_city_code=g.upper");
    $getda = FetchArray($dbtype, $getdata);
}

<!--
<html>
<head>
<link rel="stylesheet" href="stylesheets/default.css" type="text/css"/>

</head>
<body>
<br>
<div align='center'> 
<?php 
if ($owner_id == '') {
    $owner_id = 0;
}
$getemp = SelectMultiTable($dbtype, $dbLink, $permittable, "occ_permit_code, occ_permit_application_date,\r\n                          occ_position_applied, occ_employer,occ_employer_trade_name,\r\n                          occ_employer_lot_no, occ_employer_street, business_id", "where owner_id={$owner_id} and active=1");
$getit = FetchRow($dbtype, $getemp);
$permit_code = $getit[0];
$pos_app = $getit[2];
$permit_date = $getit[1];
$employer_name = $getit[3];
$trade_name = $getit[4];
$street = $getit[6];
$lot_no = $getit[5];
?>
<form name="_FRM" method="POST" action="index.php?part=1221&owner_id=<?php 
echo $owner_id;
?>
&permit_type=Occupational&stat=<?php 
echo $status;
?>
&create=No&addfee=Add">-->
<form method=post  action ='index.php?part=4&class_type=Permits&itemID_=1221&addfee=Add&owner_id=<?php 

            ?>
,0,0,'<?php 
            echo $getcheck[13];
            ?>
')"><font color=blue>View Payment Details</font></a>
<?php 
        }
        ?>
</td>
<tr>
<?php 
        $totscheck = $totscheck + $getcheck[3];
        $s++;
    }
}
$getclear = SelectMultiTable($dbtype, $dbLink, "ebpls_transaction_payment_check a, \n\t\t\tebpls_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\t\t\tc.transaction='{$istat}' and\n                        c.trans_id={$owner_id} and c.payment_id={$business_id}");
$totcheck = FetchRow($dbtype, $getclear);
print "<tr><br></tr>";
$totchecknf = number_format($totscheck, 2);
print "<tr><td></td><td></td><td align=right>Total Check Payment:</td><td align=right>{$totchecknf}</td></tr>";
$totpay = $totcash + $totscheck;
?>
</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 

     $nConstant->InsertNewTaxFee($sValues);
 } elseif ($Indicator == 2) {
     //formula
     $nFormula = new TaxFee();
     if ($Fmode == 1) {
         //Normal formula
         $sValues = "'',{$natureid}, {$tfotype}, {$Basis},\n                                    {$Indicator},{$Fmode},'{$AmountFormula}',now(),\n                                    {$TaxType},'{$uom}',{$MinAmount}";
         $nFormula->InsertNewTaxFee($sValues);
     } elseif ($Fmode == 2) {
         $sValues = "'',{$natureid}, {$tfotype}, {$Basis},\n                                    {$Indicator},{$Fmode},'{$orig_complex}',now(),\n                                    {$TaxType},'{$uom}',{$MinAmount}";
         $nFormula->InsertNewTaxFee($sValues);
         $added = 1;
         $tax_fee_id = $nFormula->outid;
         //save to complex
         $loop = 0;
         $staxfee = SelectMultiTable($dbtype, $dbLink, "ebpls_buss_preference", "sassess", "");
         $prefset = FetchArray($dbtype, $staxfee);
         $sassesscomplex = $prefset['sassess'];
         // per estab
         $rrc = mysql_query("select * from ebpls_buss_complex where\n                                \t\t\t\tcomplex_taxfeeid='{$aTAXFEEid}' order by var_complex");
         $howmanycomplex = mysql_num_rows($rrc);
         if ($sassess == '1') {
             while ($rrp = mysql_fetch_assoc($rrc)) {
                 $loop++;
                 $nip = mysql_query("select * from ebpls_buss_taxfeeother where taxfeeid='{$rrp['complex_tfoid']}'");
                 $rip = mysql_fetch_assoc($nip);
                 $rip = $rip[tfo_id];
                 $nip = mysql_query("select * from ebpls_buss_taxfeeother where natureid='{$natureid}' and\n                                        \t\t\ttfo_id='{$rip}' and taxtype='{$TaxType}'");
                 $rip = mysql_fetch_assoc($nip);
                 $rip = $rip[taxfeeid];
                 $sValues = "'',{$tax_fee_id},'{$rip}',\n                                                   'X{$loop}',now()";

<tr>
<td>Access Pin</td><td><?php 
echo $pin;
?>
</td>
</tr>
<tr>
<td>Website Username/Password</td><td><?php 
echo $getus . "/" . $passwd;
?>
</td>
</tr>
<tr><td></td></tr>
<tr><td>Line of Business</td><td>Capital Investment</td><td>Gross Sales</td><tr>
<?php 
$getnat = SelectMultiTable($dbtype, $dbLink, "tempbusnature", "bus_nature, cap_inv, last_yr", "where owner_id={$owner_id} and business_id={$business_id}\n \t\t\tand active = 1");
while ($getit = FetchRow($dbtype, $getnat)) {
    ?>
<tr>
<td><?php 
    echo $getit[0];
    ?>
</td>
<td><?php 
    echo $getit[1];
    ?>
</td>
<td><?php 
    echo $getit[2];
    ?>
</td>

<?php

//matinding nakakahilong sql
$ff = "(";
$outamt = '';
$compsql = SelectMultiTable($dbtype, $dbLink, "tempassess a, ebpls_buss_taxfeeother b,\r\n                        ebpls_buss_complex c", "a.multi, a.amt, a.formula, c.coptr, c.addons,a.compval", "where a.natureid = b.natureid and \r\n\t\t\ta.taxfeeid = b.taxfeeid and a.taxfeeid = c.taxfeeid1 and \r\n\t\t\tb.taxfeeid = c.taxfeeid1 and a.tfoid = b.tfoid and \r\n\t\t\ta.tfoid = c.tfoid and b.tfoid = c.tfoid and \r\n\t\t\ta.natureid = b.natureid and b.natureid = c.natureid \r\n\t\t\tand a.natureid = c.natureid and\r\n\t\t\tc.taxfeeid={$taxfeeid} and a.active=1\r\n                        and a.transaction='{$stat}' and owner_id = {$owner_id} \r\n\t\t\tand business_id = {$business_id}\r\n\t\t\torder by compid asc");
while ($comp = FetchRow($dbtype, $compsql)) {
    if (is_numeric($comp[2])) {
        $formula = "((" . $comp[0] . "*" . $comp[2] . "))" . $comp[3] . $comp[4];
    } else {
        $formula = "((" . $comp[0] . $comp[2] . $comp[3] . $comp[4];
    }
    $outamt = $outamt . $formula;
}
$cfr = $fr . $ff . $outamt;
//."))";
//	eval ("\$totind=$fr$ff$outamt));");
//	echo $cfr;
//count "(" ")"
$sop = substr_count($cfr, '(');
$scp = substr_count($cfr, ')');
if ($sop > $scp) {
    $looper = $scp;
    $addcp = '';
    while ($looper < $sop) {
        $addcp = $addcp . ')';
        $looper++;
    }
}
eval("\$totind={$cfr}{$addcp};");
//	echo $totind;

     $nfgetd = $getd[1];
 }
 $ttnf = $totind;
 $ttn = number_format($ttnf, 2);
 if ($getd[6] == 2) {
     $nfgetd = 'complex formula';
 }
 if ($rtag == 'range') {
     $nfgetd = '';
     $getd[1] = $range[0];
     $ttn = number_format($compvalrange, 2);
     $totind = $compvalrange;
 }
 //check for exempted fees
 //$getd[7] tfoid
 $getex = SelectMultiTable($dbtype, $dbLink, "ebpls_business_enterprise a, fee_exempt b,\r\n                        ebpls_buss_tfo c", "a.*", "where a.business_id={$business_id} and\r\n\t\t\ta.business_category_code=b.business_category_code and\r\n\t\t\tc.tfoid={$getd['8']} and b.tfoid={$getd['8']} and\r\n\t\t\tb.active=1");
 $getfeex = NumRows($dbtype, $getex);
 if ($getfeex > 0) {
     $exemptedfee = $exemptedfee + $getd[1];
     $usemin = 'Fee Exempted';
     $nfgetd = '0.00';
     $rtag = '';
     $ttn = '0.00';
     $getd[1] = 0;
     $ttnf = 0;
     $totind = 0;
     $chngcompval = 1;
 }
 //$totind = round($ttn,2); //dating ganito
 $totind = round($totind, 2);
 $grandamt = $grandamt + $totind;

                ?>
'">
<?php 
            } else {
                ?>
				<body onload='javascript: alert("Cannot Process. 
				No Payment Is Made");'></body>
<?php 
                $nopayment = '1';
                require_once "includes/payform.php";
            }
        } else {
            $tfee = SelectMultiTable($dbtype, $dbLink, "ebpls_fees_paid", "sum(fee_amount)* multi_by", "where owner_id = {$owner_id} and\n                                 permit_type='{$permit_type}'");
            $totalfee = FetchRow($dbtype, $tfee);
            $totpay = $totalfee[0];
            $totchnge = SelectMultiTable($dbtype, $dbLink, "temppayment", "sum(payamt)", "where owner_id = {$owner_id} \n\t\t\t\t and permit_type='{$permit_type}' and status=1\n                                 and permit_status='{$stat}'");
            $amtchange = FetchRow($dbtype, $totchnge);
            $ort = SelectDataWhere($dbtype, $dbLink, "temppayment", "where owner_id = {$owner_id} and permit_type='{$permit_type}' \n\t\t\t\t and status=1 and permit_status='{$stat}'");
            $ort = FetchArray($dbtype, $ort);
            $totpaid = $amtchange[0];
            $amtchange = $totpay - $amtchange[0];
            $orno = $ort[or_no];
            //please populate ACCOUNT CODES
            $getmax = SelectDataWhere($dbtype, $dbLink, "ebpls_transaction_payment_or", "");
            $or = NumRows($dbtype, $getmax);
            $or = $or + 1;
            $trans_id = $owner_id;
            $payment_code = $orno;
            $payment_id = 0;
            $tax_fee_code = 'taxcode';
            $account_code = 'acntcode';

$pdf->SetY($Y_Table_Position);
while ($resulta = mysql_fetch_array($result)) {
    $pdf->SetX(1);
    //$pdf->MultiCell(349,5,$i,1);
    $pdf->SetX(5);
    $pdf->Cell(10, 5, $i, 1, 0, 'L');
    $pdf->Cell(50, 5, $resulta[fulln], 1, 0, 'L');
    $pdf->Cell(40, 5, $resulta[business_name], 1, 0, 'L');
    $pdf->Cell(90, 5, $resulta[bus_add], 1, 0, 'L');
    $getlineb = mysql_query("select a.cap_inv as invest from tempbusnature a,\n                                ebpls_buss_nature b where a.owner_id={$resulta['owner_id']} and\n                                a.business_id={$resulta['business_id']} and\n                                a.bus_code=b.natureid \n                                order by tempid");
    $resultb = mysql_fetch_array($getlineb);
    $pdf->Cell(25, 5, $resultb[invest], 1, 0, 'R');
    $getlineb = mysql_query("select a.last_yr as invest from tempbusnature a,\n                                ebpls_buss_nature b where a.owner_id={$resulta['owner_id']} and\n                                a.business_id={$resulta['business_id']} and\n                                a.bus_code=b.natureid and a.active=1 \n                                order by tempid desc");
    $resultb = mysql_fetch_array($getlineb);
    $pdf->Cell(25, 5, $resultb[invest], 1, 0, 'R');
    $getcas = SelectMultiTable($dbtype, $dbLink, "ebpls_transaction_payment_or a,\n                        ebpls_transaction_payment_or_details b, \n\t\t\tebpls_business_enterprise_permit c", "a.ts_create as pay_date, concat(a.payment_code,'/',a.or_no),\n                        a.total_amount_paid, a.payment_officer, a.or_no, a.total_amount_due,\n                        a.payment_code as or_num", "where a.or_no=b.or_no and b.trans_id={$resulta['owner_id']} and\n                        b.or_entry_type='CASH' and\n                        b.payment_id={$resulta['business_id']} and\n\t\t\tb.payment_id=c.business_id and\n\t\t\tb.trans_id=c.owner_id and c.active=1 and\t \n\t\t\tb.transaction='{$resulta['transaction']}'");
    $geta = FetchArray($dbtype, $getcas);
    $getapp = mysql_query("select * from ebpls_business_enterprise_permit\n\t\t\twhere owner_id = {$resulta['owner_id']} and \n\t\t\tbusiness_id ={$resulta['business_id']} and\n\t\t\tactive=1");
    $getapp = mysql_fetch_array($getapp);
    $pdf->Cell(25, 5, $geta[or_num], 1, 0, 'L');
    $pdf->Cell(25, 5, $geta[pay_date], 1, 0, 'L');
    $pdf->Cell(25, 5, $getapp[application_date], 1, 0, 'L');
    $pdf->Cell(20, 5, $resulta[transaction], 1, 0, 'L');
    $i++;
    $pdf->SetY($pdf->GetY() + 5);
}
/*
$i = 1;
$pdf->SetY($Y_Table_Position);
while ($i < $number_of_rows)
{

 /*
 if ($id<>'') {
 $owner_id = $id;
 }
 */
 $getown = SelectMultiTable($dbtype, $dbLink, $owner, "owner_first_name, owner_middle_name, owner_last_name, owner_gender", "where owner_id={$owner_id}");
 $res = FetchRow($dbtype, $getown);
 //$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];

    $getch = $getche[0] + $getch;
    //  }
}
$totbak = $totbak + $getch;
?>
<!--<table>
	<tr>
	<td>
		<?php 
echo $backpays1[0];
?>
	</td>
	</tr>-->

<?php 
if ($istat == 'Retire') {
    $backtaks = SelectMultiTable($dbtype, $dbLink, "bus_grandamt", "grandamt, totpenamt, si, waive", "where owner_id={$owner_id} and business_id={$business_id} \r\n\t\t\t and active = 0 order by gid desc limit 1");
} else {
    $backtaks = SelectMultiTable($dbtype, $dbLink, "bus_grandamt", "sum(grandamt), sum(totpenamt), sum(si), sum(waive)", "where owner_id={$owner_id} and business_id={$business_id} and active = 0\r\n\t                 order by gid desc limit 1");
}
$backtaks1 = mysql_fetch_row($backtaks);
if ($backtaks1[0] == '') {
    $notpaid = 0;
} else {
    $baktax1 = $backtaks1[0];
    $baktax2 = $backtaks1[1];
    $baktax3 = $backtaks1[2];
    $totbaktax = $baktax1 + $baktax2 + $baktax3;
    $totbaktax = $totbaktax - $backtaks1[3];
    $notpaid = abs($totbaktax - $totbak);
}

    $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
                $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 {