示例#1
0
                    if ($cp > 0) {
                        $sValues = "'',{$tax_fee_id},'{$complex_tfoid}',\n                                                   '{$com_var}',now()";
                    } else {
                        $tp = mysql_query("select * from ebpls_buss_taxfeeother\n\t                                        \t\t\twhere taxfeeid='{$complex_tfoid}'");
                        //source
                        $co = mysql_fetch_assoc($tp);
                        $tfoid = $co[tfo_id];
                        $taxtype = $co[taxtype];
                        $tp = mysql_query("select * from ebpls_buss_taxfeeother\n\t                                        \t\t\twhere natureid='{$natureid}' and\n\t                                        \t\t\ttfo_id='{$tfoid}' and taxtype='{$taxtype}'");
                        $co = mysql_fetch_assoc($tp);
                        $ntaxid = $co[taxfeeid];
                        $sValues = "'',{$tax_fee_id},'{$ntaxid}',\n                                                   '{$com_var}',now()";
                    }
                    $nFormula->InsertNewComplex($sValues);
                }
            }
        }
    } elseif ($Indicator == 3) {
        //go go power ranger
        $nRange = new TaxFee();
        $sValues = "'',{$natureid}, {$tfotype}, {$Basis},\n                                    {$Indicator},'','{$AmountFormula}',now(),\n                                    {$TaxType},'{$uom}',{$MinAmount}";
        $nRange->InsertNewTaxFee($sValues);
        $tax_fee_id = $nRange->outid;
        $loop = 0;
        while ($loop < $howmanyrange) {
            $sValues = "'',{$tax_fee_id},'{$rlow[$loop]}','{$rhigh[$loop]}',\n                                   '{$rvalue[$loop]}',now()";
            $nRange->InsertNewRange($sValues);
            $loop++;
        }
    }
}
示例#2
0
                        $AmountFormula = $cntRange->outnumrow;
                    } elseif ($varflag != $AmountFormula) {
                        $AmountFormula = $AmountFormula;
                    }
                    $editme = "246";
                    $query = $cntRange->outselect;
                    ?>
<table border=0 width=50% align=center>
                <tr>
                <td></td><td></td><td></td><td></td>
                </tr>
<?php 
                    $rangeme = 0;
                    while ($rangeme < $AmountFormula) {
                        if ($editme == 246) {
                            $lRange = new TaxFee();
                            $lRange->FetchTaxFeeArray($query);
                            $range_list = $lRange->outarray;
                            $range_id[$rangeme] = $range_list[rangeid];
                            ?>
	                <input type=hidden name=rangeid[<?php 
                            echo $rangeme;
                            ?>
] value=<?php 
                            echo $range_id[$rangeme];
                            ?>
>
<?php 
                            $rlow[$rangeme] = $range_list[rangelow];
                            $rhigh[$rangeme] = $range_list[rangehigh];
                            $rvalue[$rangeme] = $range_list[rangeamount];
示例#3
0
        $DelNat->CheckTaxFee($bcode);
        if ($DelNat->outnumrow > 0) {
            ?>
			<body onload='javascript:alert ("Cannot Delete, Record exists in other table(s)!!");'></body>
			<?php 
        } else {
            $strwhere = "natureid='{$bcode}'";
            $DelNat->DeleteTax('ebpls_buss_nature', $strwhere);
            ?>
		<body onload='javascript:alert ("Record Deleted!!");'></body>
		<?php 
        }
    }
    if ($donfx == 1) {
        include_once 'class/TaxFeeOtherChargesClass.php';
        $DelNat = new TaxFee();
        $strvalues = "naturestatus='A'";
        $strwhere = "natureid='{$bcode}'";
        $DelNat->UpdateNature($strvalues, $strwhere);
    }
    ?>
<body onload="javascript: _FRM.searcheenat.focus();"></body>
<tr><td colspan=2 class=header2 align=center width=100%>Masterlist of Business Nature</td></tr>
<tr>
<td colspan=2><br><br>&nbsp;<!--To add new record click here.-->

&nbsp;<input type=text name=searcheenat size=20 maxlength=255>&nbsp;<input type = submit name=searchnat value ='Search Nature'><br><br>
<input type = submit name=cbut value ='Add New Record'><br><br>   <!--LEO RENTON.-->

</td>
</tr>
示例#4
0
             $howmanydec = $havemat / $getyr[counter];
             $isdeci = strpos($howmanydec, ".");
             if ($havemat % $getyr[counter] != 0) {
                 $replace_var[compval] = 0;
             }
         }
         $complex_formula = str_replace($get_varx[var_complex], $replace_var[compval], $complex_formula);
         // echo $complex_formula."<BR>";
     }
     // echo $complex_formula."<BR>";
 } else {
     while ($loop < $how_many) {
         $loop++;
         $gTFO->FetchTaxFeeArray($searchme->outselect);
         $get_varx = $gTFO->outarray;
         $gTempAssess = new TaxFee();
         $gTempAssess->ReplaceValueDef($get_varx[complex_tfoid], $owner_id, $business_id, $getn[0]);
         $replace_var = $gTempAssess->outarray;
         if ($replace_var[compval] > 0) {
             $repval = $replace_var[compval];
         } else {
             $repval = $replace_var[defamt];
             $havegar = strpos(strtolower(trim($replace_var[tfodesc])), 'garbage');
             if ($g_zone == 0) {
                 if ($havegar > -1) {
                     $exemptedfee = $exemptedfee + $repval;
                     $repval = 0;
                 }
             }
             $getex = SelectMultiTable($dbtype, $dbLink, "ebpls_business_enterprise a, fee_exempt b,\n\t\t\t                        ebpls_buss_tfo c", "a.*", "where a.business_id={$business_id} and\n\t\t\t\t\t\t\t\t\ta.business_category_code=b.business_category_code and\n\t\t\t\t\t\t\t\t\tc.tfoid='{$replace_var['tfoid']}' and b.tfoid='{$replace_var['tfoid']}' and\n\t\t\t\t\t\t\t\t\tb.active=1");
             $getfeex = NumRows($dbtype, $getex);
示例#5
0
<?php

if (empty($bussEvent)) {
    $bussEvent = 1;
}
if ($confx == 1) {
    //delete tax and iba pang kasama nito
    include_once "class/TaxFeeOtherChargesClass.php";
    $DelTax = new TaxFee();
    $strwhere = "taxfeeid='{$bcode}'";
    $DelTax->DeleteTax("ebpls_buss_taxfeeother", $strwhere);
    $strwhere = "taxfeeid='{$bcode}'";
    $DelTax->DeleteTax("ebpls_buss_taxrange", $strwhere);
    $strwhere = "complex_taxfeeid='{$bcode}'";
    $DelTax->DeleteTax("ebpls_buss_complex", $strwhere);
}
?>
<table width=100%>
<tr>
<td width=5%>#</td>
<td width=40%>&nbsp;Description</td>
<td width=10%>&nbsp;Formula Type</td>
<td width=5% align=left>&nbsp;Type</td>
<td width=5% align=center>&nbsp;Indicator</td>
<td width=10% align=center>&nbsp;Amt/For</td>
<td width=25% align=center>&nbsp;Action</td>
</tr>
<script language="Javascript">
function DelTax(cc)
{
         var _FRM = document._FRM;