tax_rates.php

全新且完善的强大网上商店系统

<?php
/*
  [SOOBIC!] admin/tax_rates.php 

	Version: 1.05
	Author: Soolan ([e-mail])
	Copyright: soolan (www.soobic.com)
	Last Modified: 2005/4/1 10:00

*/

if(!defined('IN_SOOBIC')) {
        exit('Access Denied');
}

cpheader();

include ("admin/languages/".$language."/tax_rates.php");

//$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : $HTTP_POST_VARS['action']);

if ($action) {
    switch ($action) {
      case 'new':        
        $db->query("insert into $table_tax_rates (tax_zone_id, tax_class_id, tax_rate, tax_description, tax_priority, date_added) values ('" . (int)$tax_zone_id . "', '" . (int)$tax_class_id . "', '" . ($tax_rate) . "', '" . ($tax_description) . "', '" . ($tax_priority) . "', now())");
        cpmsg("Soolan!税率成功添加。",tep_href_link('admincp.php', 'act=tax_rates')); 
        break;
      case 'save':
        
        $db->query("update $table_tax_rates set tax_zone_id = '" . (int)$tax_zone_id . "', tax_class_id = '" . (int)$tax_class_id . "', tax_rate = '" . ($tax_rate) . "', tax_description = '" . ($tax_description) . "', tax_priority = '" . ($tax_priority) . "', last_modified = now() where tax_rates_id = '" . (int)$tID . "'"); 
        cpmsg("Soolan!税率成功编辑。",tep_href_link('admincp.php', 'act=tax_rates&page=' . $HTTP_GET_VARS['page'] )); 
        break;
      case 'delete':
        $tax_rates_id = $tID;

        $db->query("delete from $table_tax_rates where tax_rates_id = '" . (int)$tax_rates_id . "'");
        cpmsg("Soolan!税率成功删除。",tep_href_link('admincp.php', 'act=tax_rates&page=' . $HTTP_GET_VARS['page']));  
        break;
    }
}elseif($type){
    switch ($type) {
      case 'delete':
        cpmsg("本操作不可恢复，您确定要删除该税率？", tep_href_link('admincp.php', 'act=tax_rates&page=' . $HTTP_GET_VARS['page'].'&tID='.$tID.'&action=delete', 'NONSSL'), "form");
      break;
      case 'edit':
        $query = $db->query("select r.tax_rates_id, z.geo_zone_id, z.geo_zone_name, tc.tax_class_title, tc.tax_class_id, r.tax_priority, r.tax_rate, r.tax_description, r.date_added, r.last_modified from $table_tax_class tc, $table_tax_rates r left join $table_geo_zones z on r.tax_zone_id = z.geo_zone_id where r.tax_class_id = tc.tax_class_id and r.tax_rates_id = '" . (int)$tID. "'"); 
		
				$tax_rates = $db->fetch_array($query); 
?>

<form method="post" action="<?=tep_href_link('admincp.php','act=tax_rates')?>">
<input type="hidden" name="action" value="save">
<input type="hidden" name="tID" value="<?=$tax_rates['tax_rates_id']?>">
<table cellspacing="0" cellpadding="0" border="0" width="80%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">

<tr class="header"><td colspan="2"><?=TEXT_INFO_HEADING_EDIT_TAX_RATE?>--<?=TEXT_INFO_EDIT_INTRO?></td></tr>

<tr align="center" bgcolor="<?=ALTBG2?>"><td width="40%" align="right"><?=TEXT_INFO_CLASS_TITLE?></td>
<td align="left"><?=tep_tax_classes_pull_down('name="tax_class_id" style="font-size:10px"',$tax_rates['tax_class_id'])?></td>
</tr>

<tr align="center" bgcolor="<?=ALTBG1?>"><td width="40%" align="right"><?=TEXT_INFO_ZONE_NAME?></td>
<td align="left"><?=tep_geo_zones_pull_down('name="tax_zone_id" style="font-size:10px"',$tax_rates['geo_zone_id'])?></td>
</tr>

<tr align="center" bgcolor="<?=ALTBG2?>"><td width="40%" align="right"><?=TEXT_INFO_TAX_RATE?></td>
<td align="left"><input type="text" size="50" name="tax_rate" value="<?=$tax_rates['tax_rate']?>"></td>
</tr>

<tr align="center" bgcolor="<?=ALTBG1?>"><td width="40%" align="right"><?=TEXT_INFO_RATE_DESCRIPTION?></td>
<td align="left"><input type="text" size="50" name="tax_description" value="<?=$tax_rates['tax_description']?>"></td>
</tr>

<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right"><?=TEXT_INFO_TAX_RATE_PRIORITY?></td>
<td align="left"><input type="text" size="50" name="tax_priority" value="<?=$tax_rates['tax_priority']?>"></td>
</tr>

</table></td></tr></table><br><center><?=$warning?>
<input type="submit" name="submit" value="提   交">&nbsp;
</center></form><br><br>


<?
      break;
      
    }

}else{
    if($page) {
	      	$start_limit = ($page - 1) * MAX_DISPLAY_SEARCH_RESULTS ;
    } else {
	        $start_limit = 0;
	        $page = 1;
    }
    
    $query = $db->query("SELECT COUNT(*) from $table_tax_class tc, $table_tax_rates r left join $table_geo_zones z on r.tax_zone_id = z.geo_zone_id where r.tax_class_id = tc.tax_class_id");
    $multipage = multi($db->result($query, 0), MAX_DISPLAY_SEARCH_RESULTS, $page, "admincp.php?act=tax_rates".($desc ? "&desc=$desc" : NULL));
    $query = $db->query("select r.tax_rates_id, z.geo_zone_id, z.geo_zone_name, tc.tax_class_title, tc.tax_class_id, r.tax_priority, r.tax_rate, r.tax_description, r.date_added, r.last_modified from $table_tax_class tc, $table_tax_rates r left join $table_geo_zones z on r.tax_zone_id = z.geo_zone_id where r.tax_class_id = tc.tax_class_id LIMIT $start_limit, ".MAX_DISPLAY_SEARCH_RESULTS);
		$altbg1 = ALTBG1;
	  $altbg2 = ALTBG2;
	  $productcount = 0;
?>
<br><br>
<?=$multipage?> 
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center" style="word-break:break-all;">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td><?=TABLE_HEADING_TAX_RATE_PRIORITY?></td><td><?=TABLE_HEADING_TAX_CLASS_TITLE?></td><td><?=TABLE_HEADING_ZONE?></td><td width="20%" align="center"><?=TABLE_HEADING_TAX_RATE?></td><td width="20%" align="center"><?=TABLE_HEADING_ACTION?></td></tr>
<?
		while ($tax_rates = $db->fetch_array($query)) {
         $bgno = $productcount++ % 2 + 1;
?>
<tr bgcolor="<?=${'altbg'.$bgno}?>"><td><?=$tax_rates['tax_priority']?></td><td><?=$tax_rates['tax_class_title']?></td><td><?=$tax_rates['geo_zone_name']?></td><td><?=tep_display_tax_value($tax_rates['tax_rate'])?>%</td><td align="center"><a href="<?=tep_href_link('admincp.php', 'act=tax_rates&page=' . $HTTP_GET_VARS['page'] . '&type=edit&tID=' . $tax_rates['tax_rates_id'])?>">详情</a>&nbsp;&nbsp;&nbsp;<a href="<?=tep_href_link('admincp.php', 'act=tax_rates&page=' . $HTTP_GET_VARS['page'] . '&type=delete&tID=' .$tax_rates['tax_rates_id'])?>">删除</a></td></tr>


<?
    }
?>
</table></td></tr></table>   
<?=$multipage?>      
<br><br>

<form method="post" action="<?=tep_href_link('admincp.php','act=tax_rates')?>">
<input type="hidden" name="action" value="new">
<table cellspacing="0" cellpadding="0" border="0" width="80%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td colspan="7"><?=TEXT_INFO_INSERT_INTRO?></td></tr>

<tr align="center" bgcolor="<?=ALTBG2?>"><td width="40%" align="right"><?=TEXT_INFO_CLASS_TITLE?></td>
<td align="left"><?=tep_tax_classes_pull_down('name="tax_class_id" style="font-size:10px"')?></td>
</tr>

<tr align="center" bgcolor="<?=ALTBG1?>"><td width="40%" align="right"><?=TEXT_INFO_ZONE_NAME?></td>
<td align="left"><?=tep_geo_zones_pull_down('name="tax_zone_id" style="font-size:10px"')?></td>
</tr>

<tr align="center" bgcolor="<?=ALTBG2?>"><td width="40%" align="right"><?=TEXT_INFO_TAX_RATE?></td>
<td align="left"><input type="text" size="50" name="tax_rate"></td>
</tr>

<tr align="center" bgcolor="<?=ALTBG1?>"><td width="40%" align="right"><?=TEXT_INFO_RATE_DESCRIPTION?></td>
<td align="left"><input type="text" size="50" name="tax_description"></td>
</tr>

<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right"><?=TEXT_INFO_TAX_RATE_PRIORITY?></td>
<td align="left"><input type="text" size="50" name="tax_priority"></td>
</tr>

</table></td></tr></table><br><center><?=$warning?>
<input type="submit" name="submit" value="提   交">&nbsp;
</center></form><br><br>
    
    
<?    
}
?>