geo_zones.php

来自「全新且完善的强大网上商店系统」· PHP 代码 · 共 325 行 · 第 1/2 页

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

	Version: 1.5
	Author: soolan ([e-mail])
	Copyright: soolan (www.soobic.com)

	Last Modified: 2005/4/12 10:00
  
*/

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

cpheader();

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

if ($action) {
    switch ($action) {
      case 'insert':
        $geo_zone_name = tep_db_prepare_input($HTTP_POST_VARS['geo_zone_name']);
        $geo_zone_description = tep_db_prepare_input($HTTP_POST_VARS['geo_zone_description']);

        $db->query("insert into $table_geo_zones  (geo_zone_name, geo_zone_description, date_added,last_modified) values ('$geo_zone_name', '$geo_zone_description', now(),now())");
        $new_zone_id = $db->insert_id();
				cpmsg("Soolan!提示：区域成功添加。",tep_href_link('admincp.php', 'act=geo_zones&zpage=' . $HTTP_GET_VARS['zpage'].'&zID='.$new_zone_id)); 
        break;
      case 'save':
        $geo_zone_name = tep_db_prepare_input($HTTP_POST_VARS['geo_zone_name']);
        $geo_zone_description = tep_db_prepare_input($HTTP_POST_VARS['geo_zone_description']);
        
        $db->query("update $table_geo_zones set geo_zone_name = '".$geo_zone_name."', geo_zone_description = '$geo_zone_description', last_modified = now() where geo_zone_id = '" . (int)$zID . "'");
        cpmsg("Soolan!提示：区域成功编辑。",tep_href_link('admincp.php', 'act=geo_zones&zpage=' . $HTTP_GET_VARS['zpage'] )); 
        break;
      case 'delete':
        $zID = safe_input($HTTP_GET_VARS['zID']);

        $db->query("delete from $table_geo_zones where geo_zone_id = '" . (int)$zID . "'");
        $db->query("delete from $table_zones_to_geo_zones where geo_zone_id = '" . (int)$zID . "'");
        cpmsg("Soolan!提示：区域成功删除。",tep_href_link('admincp.php', 'act=geo_zones&zpage=' . $HTTP_GET_VARS['zpage']));  
        break;
    }
}elseif($type){
    switch ($type) {
      case 'delete_zone':
        cpmsg("本操作不可恢复，您确定要删除该省份(地区)？", tep_href_link('admincp.php', 'act=geo_zones&zpage=' . $HTTP_GET_VARS['zpage'].'&zID='.$zID.'&action=delete', 'NONSSL'), "form");
      break;
      case 'new_zone':
?>
<form method="post" action="<?=tep_href_link('admincp.php','act=geo_zones')?>">
<input type="hidden" name="action" value="insert">
<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_HEADING_NEW_ZONE?>--<?=TEXT_INFO_NEW_ZONE_INTRO?></td></tr>

<tr align="center" bgcolor="<?=ALTBG1?>"><td width="40%" align="right"><?=TEXT_INFO_ZONE_NAME?></td>
<td align="left"><input type="text" size="50" name="geo_zone_name" ></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right"><?=TEXT_INFO_ZONE_DESCRIPTION?></td>
<td align="left"><input type="text" size="50" name="geo_zone_description"></td>
</tr>

</table></td></tr></table><br><center><?=$warning?>
<input type="submit" name="submit" value="提   交">&nbsp;
</center></form><br><br>
<?
      break;
      case 'edit_zone':
        $query = $db->query("select geo_zone_id, geo_zone_name, geo_zone_description  from $table_geo_zones where geo_zone_id='$zID'");
				$geo_zone = $db->fetch_array($query); 
?>

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

<tr align="center" bgcolor="<?=ALTBG1?>"><td width="40%" align="right"><?=TEXT_INFO_ZONE_NAME?></td>
<td align="left"><input type="text" size="50" name="geo_zone_name" value="<?=$geo_zone['geo_zone_name']?>"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right"><?=TEXT_INFO_ZONE_DESCRIPTION?></td>
<td align="left"><input type="text" size="50" name="geo_zone_description" value="<?=$geo_zone['geo_zone_description']?>"></td>
</tr>

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


<?
      break;
      
    }

}elseif($saction){
   switch ($saction){
      case 'delete':
        $db->query("delete from $table_zones_to_geo_zones where association_id = '" . (int)$sID . "'");
        cpmsg("Soobic!提示：区域成功删除。",tep_href_link('admincp.php', 'act=geo_zones&zpage=' . $HTTP_GET_VARS['zpage'].'&zID=' . $zID.'&sub=list&spage=' . $HTTP_GET_VARS['spage'])); 
      break;
			case 'save':
        //echo "<pre>";print_r($_POST);exit;
				$zone_country_id = tep_db_prepare_input($HTTP_POST_VARS['zone_country_id']);
        $zone_id = tep_db_prepare_input($HTTP_POST_VARS['zone_id']);
        $db->query("update $table_zones_to_geo_zones set geo_zone_id = '".(int)$zID."', zone_country_id = '".(int)$zone_country_id."', zone_id = " . (tep_not_null($zone_id) ? "'" . (int)$zone_id . "'" : 'null') . ", last_modified = now() where association_id = '" . (int)$sID . "'");
         
				cpmsg("Soobic!提示：区域成功编辑。",tep_href_link('admincp.php', 'act=geo_zones&zpage=' . $HTTP_GET_VARS['zpage'].'&zID=' . $zID.'&sub=list&spage=' . $HTTP_GET_VARS['spage'] . '&sID=' . $sID)); 
      break;
      case 'insert':
        $zone_country_id = tep_db_prepare_input($HTTP_POST_VARS['zone_country_id']);
        $zone_id = tep_db_prepare_input($HTTP_POST_VARS['zone_id']);
        $db->query("insert into $table_zones_to_geo_zones (zone_country_id, zone_id, geo_zone_id, date_added, last_modified) values ('" . (int)$zone_country_id . "', '" . (int)$zone_id . "', '" . (int)$zID . "', now(), now())");
        $new_subzone_id = $db->insert_id();
        cpmsg("Soobic!提示：区域成功添加。",tep_href_link('admincp.php', 'act=geo_zones&zpage=' . $HTTP_GET_VARS['zpage'].'&zID=' . $zID.'&sub=list&spage=' . $HTTP_GET_VARS['spage'] . '&sID=' . $new_subzone_id)); 
      break;   
   } 

}elseif($stype){
?>
<script language="javascript"><!--
function resetZoneSelected(theForm) {
  if (theForm.state.value != '') {
    theForm.zone_id.selectedIndex = '0';
    if (theForm.zone_id.options.length > 0) {
      theForm.state.value = '<?php echo JS_STATE_SELECT; ?>';
    }
  }
}

function update_zone(theForm) {
  var NumState = theForm.zone_id.options.length;
  var SelectedCountry = "";

  while(NumState > 0) {
    NumState--;
    theForm.zone_id.options[NumState] = null;
  }         

  SelectedCountry = theForm.zone_country_id.options[theForm.zone_country_id.selectedIndex].value;

<?php echo tep_js_zone_list('SelectedCountry', 'theForm', 'zone_id'); ?>

}
//--></script>
<?php    
		$countries_array = array();
    if (TEXT_ALL_COUNTRIES) {
        $countries_array[] = array('id' => '',
                                 'text' => TEXT_ALL_COUNTRIES);
    }
    $countries_query = $db->query("select countries_id, countries_name from $table_countries order by countries_name");
    while ($countries = $db->fetch_array($countries_query)) {
        $countries_array[] = array('id' => $countries['countries_id'],
                                 'text' => $countries['countries_name']);
    }