zones.php

来自「全新且完善的强大网上商店系统」· PHP 代码 · 共 145 行

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

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

*/

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

cpheader();

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

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

if ($action) {
    switch ($action) {
      case 'new':
        $zone_country_id = safe_input($HTTP_POST_VARS['zone_country_id']);
        $zone_code = safe_input($HTTP_POST_VARS['zone_code']);
        $zone_name = safe_input($HTTP_POST_VARS['zone_name']);
        $db->query("insert into $table_zones (zone_country_id, zone_code, zone_name) values ('" . (int)$zone_country_id . "', '" . ($zone_code) . "', '" . ($zone_name) . "')");
        cpmsg("Soolan!省份地区成功添加。",tep_href_link('admincp.php', 'act=zones')); 
        break;
      case 'save':
        $zone_id = safe_input($HTTP_POST_VARS['zID']);
        $zone_country_id = safe_input($HTTP_POST_VARS['zone_country_id']);
        $zone_code = safe_input($HTTP_POST_VARS['zone_code']);
        $zone_name = safe_input($HTTP_POST_VARS['zone_name']);

        $db->query("update $table_zones set zone_country_id = '" . (int)$zone_country_id . "', zone_code = '" . ($zone_code) . "', zone_name = '" . ($zone_name) . "' where zone_id = '" . (int)$zone_id . "'");
        cpmsg("Soolan!省份地区成功编辑。",tep_href_link('admincp.php', 'act=zones&page=' . $HTTP_GET_VARS['page'] )); 
        break;
      case 'delete':
        $zone_id = safe_input($HTTP_GET_VARS['zID']);

        $db->query("delete from $table_zones where zone_id = '" . (int)$zone_id . "'");
        cpmsg("Soolan!省份地区成功删除。",tep_href_link('admincp.php', 'act=zones&page=' . $HTTP_GET_VARS['page']));  
        break;
    }
}elseif($type){
    switch ($type) {
      case 'delete':
        cpmsg("本操作不可恢复，您确定要删除该省份(地区)？", tep_href_link('admincp.php', 'act=zones&page=' . $HTTP_GET_VARS['page'].'&zID='.$zID.'&action=delete', 'NONSSL'), "form");
      break;
      case 'edit':
        $query = $db->query("select z.zone_id, c.countries_id, c.countries_name, z.zone_name, z.zone_code from $table_zones z, $table_countries c where z.zone_country_id = c.countries_id and zone_id = '" . (int)$zID. "'"); 
				$zones = $db->fetch_array($query); 
?>

<form method="post" action="<?=tep_href_link('admincp.php','act=zones')?>">
<input type="hidden" name="action" value="save">
<input type="hidden" name="zID" value="<?=$zones['zone_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="7"><?=TEXT_INFO_INSERT_INTRO?></td></tr>

<tr align="center" bgcolor="<?=ALTBG1?>"><td width="40%" align="right"><?=TEXT_INFO_ZONES_NAME?></td>
<td align="left"><input type="text" size="50" name="zone_name" value="<?=$zones['zone_name']?>"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right"><?=TEXT_INFO_ZONES_CODE?></td>
<td align="left"><input type="text" size="50" name="zone_code" value="<?=$zones['zone_code']?>"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG1?>"><td align="right"><?=TEXT_INFO_COUNTRY_NAME?></td>
<td align="left"><?=tep_draw_pull_down_menu('zone_country_id', tep_get_countries(),$zones['countries_id'])?></td>

</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_zones z, $table_countries c where z.zone_country_id = c.countries_id ");
    $multipage = multi($db->result($query, 0), MAX_DISPLAY_SEARCH_RESULTS, $page, "admincp.php?act=zones".($desc ? "&desc=$desc" : NULL));
    $query = $db->query("select z.zone_id, c.countries_id, c.countries_name, z.zone_name, z.zone_code from $table_zones z, $table_countries c where z.zone_country_id = c.countries_id order by c.countries_name, z.zone_name 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_COUNTRY_NAME?></td><td width="20%" align="center"><?=TABLE_HEADING_ZONE_NAME?></td><td width="20%" align="center"><?=TABLE_HEADING_ZONE_CODE?></td><td width="20%" align="center"><?=TABLE_HEADING_ACTION?></td></tr>
<?
    
		while ($zones = $db->fetch_array($query)) {
         $bgno = $productcount++ % 2 + 1;
?>
<tr bgcolor="<?=${'altbg'.$bgno}?>"><td><?=$zones['countries_name']?></td><td><?=$zones['zone_name']?></td><td><?=$zones['zone_code']?></td><td align="center"><a href="<?=tep_href_link('admincp.php', 'act=zones&page=' . $HTTP_GET_VARS['page'] . '&type=edit&zID=' . $zones['zone_id'])?>">详情</a>&nbsp;&nbsp;&nbsp;<a href="<?=tep_href_link('admincp.php', 'act=zones&page=' . $HTTP_GET_VARS['page'] . '&type=delete&zID=' .$zones['zone_id'])?>">删除</a></td></tr>


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

<form method="post" action="<?=tep_href_link('admincp.php','act=zones')?>">
<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="<?=ALTBG1?>"><td width="40%" align="right"><?=TEXT_INFO_ZONES_NAME?></td>
<td align="left"><input type="text" size="50" name="zone_name"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right"><?=TEXT_INFO_ZONES_CODE?></td>
<td align="left"><input type="text" size="50" name="zone_code"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG1?>"><td align="right"><?=TEXT_INFO_COUNTRY_NAME?></td>
<td align="left"><?=tep_draw_pull_down_menu('zone_country_id', tep_get_countries())?></td>

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