countries.php

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

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

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

*/

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

cpheader();

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

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

if ($action) {
    switch ($action) {
      case 'new':
        $countries_name = safe_input($HTTP_POST_VARS['countries_name']);
        $countries_iso_code_2 = safe_input($HTTP_POST_VARS['countries_iso_code_2']);
        $countries_iso_code_3 = safe_input($HTTP_POST_VARS['countries_iso_code_3']);
        $address_format_id = safe_input($HTTP_POST_VARS['address_format_id']);

        $db->query("insert into $table_countries (countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id) values ('" . ($countries_name) . "', '" . ($countries_iso_code_2) . "', '" . ($countries_iso_code_3) . "', '" . (int)$address_format_id . "')");
        cpmsg("Soolan!国家成功添加。",tep_href_link('admincp.php', 'act=countries')); 
        break;
      case 'save':
        $countries_id = safe_input($HTTP_POST_VARS['cID']);
        $countries_name = safe_input($HTTP_POST_VARS['countries_name']);
        $countries_iso_code_2 = safe_input($HTTP_POST_VARS['countries_iso_code_2']);
        $countries_iso_code_3 = safe_input($HTTP_POST_VARS['countries_iso_code_3']);
        //$address_format_id = safe_input($HTTP_POST_VARS['address_format_id']);

        $db->query("update $table_countries set countries_name = '" .$countries_name. "', countries_iso_code_2 = '".$countries_iso_code_2."', countries_iso_code_3 = '" .$countries_iso_code_3. "' where countries_id = '" . (int)$countries_id . "'");
        cpmsg("Soolan!国家成功编辑。",tep_href_link('admincp.php', 'act=countries&page=' . $HTTP_GET_VARS['page'] )); 
        break;
      case 'delete':
        $countries_id = safe_input($HTTP_GET_VARS['cID']);

        $db->query("delete from $table_countries where countries_id = '" . (int)$countries_id . "'");
        cpmsg("Soolan!国家成功删除。",tep_href_link('admincp.php', 'act=countries&page=' . $HTTP_GET_VARS['page']));  
        break;
    }
}elseif($type){
    switch ($type) {
      case 'delete':
        cpmsg("本操作不可恢复，您确定要删除该国家？", tep_href_link('admincp.php', 'act=countries&page=' . $HTTP_GET_VARS['page'].'&cID='.$cID.'&action=delete', 'NONSSL'), "form");
      break;
      case 'edit':
        $query = $db->query("select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id from $table_countries where countries_id = '" . (int)$cID. "'");
        $countries = $db->fetch_array($query); 
?>
<form method="post" action="<?=tep_href_link('admincp.php','act=countries')?>">
<input type="hidden" name="action" value="save">
<input type="hidden" name="cID" value="<?=$countries['countries_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_COUNTRY?></td></tr>

<tr align="center" bgcolor="<?=ALTBG1?>"><td width="40%" align="right">国家名称：</td>
<td align="left"><input type="text" size="50" name="countries_name" value="<?=$countries['countries_name']?>"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right">国家IOS代码(2位)：</td>
<td align="left"><input type="text" size="50" name="countries_iso_code_2" value="<?=$countries['countries_iso_code_2']?>"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG1?>"><td align="right">国家IOS代码(3位)：</td>
<td align="left"><input type="text" size="50" name="countries_iso_code_3" value="<?=$countries['countries_iso_code_3']?>"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right">地址格式：</td>
<td align="left">商业版本支持该功能</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_countries ");
    $multipage = multi($db->result($query, 0), MAX_DISPLAY_SEARCH_RESULTS, $page, "admincp.php?act=countries".($desc ? "&desc=$desc" : NULL));
    
		$query = $db->query("select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id from $table_countries  order by countries_name LIMIT $start_limit, ".MAX_DISPLAY_SEARCH_RESULTS);
    $altbg1 = ALTBG1;
	  $altbg2 = ALTBG2;
	  $productcount = 0;
?>
<br><br>
<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_COUNTRY_CODES?></td><td width="20%" align="center"><?=TABLE_HEADING_COUNTRY_CODES?></td><td width="20%" align="center"><?=TABLE_HEADING_ACTION?></td></tr>
<?
		while ($countries = $db->fetch_array($query)) {
         $bgno = $productcount++ % 2 + 1;
?>
<tr bgcolor="<?=${'altbg'.$bgno}?>"><td><?=$countries['countries_name']?></td><td><?=$countries['countries_iso_code_2']?></td><td><?=$countries['countries_iso_code_3']?></td><td align="center"><a href="<?=tep_href_link('admincp.php', 'act=countries&page=' . $HTTP_GET_VARS['page'] . '&type=edit&cID=' . $countries['countries_id'])?>">详情</a>&nbsp;&nbsp;&nbsp;<a href="<?=tep_href_link('admincp.php', 'act=countries&page=' . $HTTP_GET_VARS['page'] . '&type=delete&cID=' . $countries['countries_id'])?>">删除</a></td></tr>


<?
    }
?>
</table></td></tr></table>        
<br><br>

<form method="post" action="<?=tep_href_link('admincp.php','act=countries')?>">
<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_HEADING_NEW_COUNTRY?></td></tr>

<tr align="center" bgcolor="<?=ALTBG1?>"><td width="40%" align="right">国家名称：</td>
<td align="left"><input type="text" size="50" name="countries_name"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right">国家IOS代码2：</td>
<td align="left"><input type="text" size="50" name="countries_iso_code_2"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG1?>"><td align="right">国家IOS代码3：</td>
<td align="left"><input type="text" size="50" name="countries_iso_code_3"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right">地址格式：</td>
<td align="left">商业版本支持该功能</td>
</tr>

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