orders_status.php

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

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

	Version: 1.5
	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."/orders_status.php");

$error = false;
$processed = false;
//$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : (isset($HTTP_POST_VARS['action']) ? $HTTP_POST_VARS['action'] : ''));
if ($action) {
  switch($action){
     case 'new':
		 case 'update':
        if (isset($osID)) $orders_status_id = tep_db_prepare_input($osID);
        
				$languages = tep_get_languages();
        for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
            $orders_status_name_array = $HTTP_POST_VARS['orders_status_name'];
            $language_id = $languages[$i]['id'];

            $sql_data_array = array('orders_status_name' => tep_db_prepare_input($orders_status_name_array[$language_id]));
  
            if ($action == 'new') {
                 if (empty($orders_status_id)) {
                     $next_id_query = $db->query("select max(orders_status_id) as orders_status_id from $table_orders_status");
                     $next_id = $db->fetch_array($next_id_query);
                     $orders_status_id = $next_id['orders_status_id'] + 1;
                 }

                 $insert_sql_data = array('orders_status_id' => $orders_status_id,
                                     'language_id' => $language_id);

                 $sql_data_array = array_merge($sql_data_array, $insert_sql_data);

                 tep_db_perform($table_orders_status, $sql_data_array);
            } elseif ($action == 'update') {
                 tep_db_perform($table_orders_status, $sql_data_array, 'update', "orders_status_id = '" . (int)$orders_status_id . "' and language_id = '" . (int)$language_id . "'");
            }
        }

        if (isset($HTTP_POST_VARS['default']) && ($HTTP_POST_VARS['default'] == 'on')) {
             $db->query("update $table_configuration set configuration_value = '" . (int)$orders_status_id. "' where configuration_key = 'DEFAULT_ORDERS_STATUS_ID'");
        }
        updatecache('settings');
				cpmsg("Lansen!提示 恭喜您操作成功！",tep_href_link('admincp.php', 'act=orders_status')); 
        
     break;
     case 'delete': 
        $osID = tep_db_prepare_input($HTTP_GET_VARS['osID']);
         
        $orders_status_query = $db->query("select configuration_value from $table_configuration where configuration_key = 'DEFAULT_ORDERS_STATUS_ID'");
        $orders_status = $db->fetch_array($orders_status_query);

        if ($orders_status['configuration_value'] == $osID) {
           $db->query("update $table_configuration set configuration_value = '' where configuration_key = 'DEFAULT_ORDERS_STATUS_ID'");
        }

        $db->query("delete from $table_orders_status where orders_status_id = '" . safe_input($osID) . "'");

				cpmsg("Lansen!提示 此订单状态已成功删除。",tep_href_link('admincp.php', 'act=orders_status')); 
     break;      
     default:
  }
}elseif($type){
  switch($type){
		 case 'delete':
        $osID = tep_db_prepare_input($HTTP_GET_VARS['osID']);
        $status_query = $db->query("select count(*) as count from $table_orders where orders_status = '" . (int)$osID . "'");
        $status = $db->fetch_array($status_query);

        $remove_status = true;
        if ($osID == DEFAULT_ORDERS_STATUS_ID) {
             cpmsg("Lansen!提示 ".ERROR_REMOVE_DEFAULT_ORDER_STATUS); 
				} elseif ($status['count'] > 0) {
             cpmsg("Lansen!提示 ".ERROR_STATUS_USED_IN_ORDERS); 
        } else {
             $history_query = $db->query("select count(*) as count from $table_orders_status_history where orders_status_id = '" . (int)$osID . "'");
             $history =$db->fetch_array($history_query);
             if ($history['count'] > 0) {
                  cpmsg("Lansen!提示 ".ERROR_STATUS_USED_IN_HISTORY); 
             }
       } 
			 cpmsg("本操作不可恢复，您确定要删除此订单状态吗？", tep_href_link('admincp.php','act=orders_status&action=delete&osID='.$osID), "form");				 
		 break;
		 case 'edit':
		   $osID = tep_db_prepare_input($HTTP_GET_VARS['osID']);
			 $orders_status_inputs_string = '';
       $languages = tep_get_languages();
       for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
           if (!$language_id) $language_id = $languages_id;
           $orders_status_query = $db->query("select orders_status_name from $table_orders_status where orders_status_id = '" . (int)$osID . "' and language_id = '" . (int)$languages[$i]['id']. "'");
           $orders_status = $db->fetch_array($orders_status_query);
 
 					 $orders_status_inputs_string .= '<br><img src="'.IMGDIR.'/'.$languages[$i]['directory'].'/'.$languages[$i]['image'].'" alt="'.$languages[$i]['name'].'" title="'.$languages[$i]['name'].'">&nbsp;<input type="text" name="orders_status_name[' . $languages[$i]['id'] . ']" value="'.$orders_status['orders_status_name'].'" >';
       }
		 
?>
<br><form method="post" action="<?=tep_href_link('admincp.php','act=orders_status&action=update&osID='.$osID)?>">
<table cellspacing="0" cellpadding="0" border="0" width="100%" align="center" style="word-break:break-all;"> 
<tr><td bgcolor="<?=BORDERCOLOR?>"> 
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;"> 
<tr class="header" align="center"><td colspan="2"><?=TEXT_INFO_EDIT_INTRO; ?></td>

<tr><td bgcolor="<?=ALTBG1?>"><?=TEXT_INFO_ORDERS_STATUS_NAME?></td><td bgcolor="<?=ALTBG2?>"><?=$orders_status_inputs_string?></td></tr>
<?if (DEFAULT_ORDERS_STATUS_ID != $osID){
?>
<tr><td bgcolor="<?=ALTBG1?>"><?=TEXT_SET_DEFAULT?></td><td bgcolor="<?=ALTBG2?>"><input type="checkbox" name="default" value="on"></td></tr>
<?}?>
</table></td></tr></table>
<center><input type="submit" name="searchsubmit" value="提   交"> &nbsp; </center></form>
<br>
<?		 
		 break;
  }
}else{
?>
<table cellspacing="0" cellpadding="0" border="0" width="100%" align="center" style="word-break:break-all;"> 
<tr><td bgcolor="<?=BORDERCOLOR?>"> 
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;"> 
<tr class="header" align="center">
<td width="80%"><?=TABLE_HEADING_ORDERS_STATUS; ?></td>
<td><?=TABLE_HEADING_ACTION; ?></td>

<?
	  $query=$db->query("select orders_status_id, orders_status_name from $table_orders_status where language_id = '" . (int)$languages_id . "' order by orders_status_id");
    while ($orders_status = $db->fetch_array($query)) {
?>

<?
       if (DEFAULT_ORDERS_STATUS_ID == $orders_status['orders_status_id']) {
           echo '<tr><td bgcolor="'.ALTBG2.'" ><b>' . $orders_status['orders_status_name'] . ' (' . TEXT_DEFAULT . ')</b></td>' . "\n";
       } else {
           echo '<tr><td bgcolor="'.ALTBG2.'">' . $orders_status['orders_status_name'] . '</td>' . "\n";
       }
?>
       <td bgcolor="<?=ALTBG2?>" align="center" width="15%">
			   <a href="<?echo tep_href_link("admincp.php", 'act=orders_status&osID=' . $orders_status['orders_status_id'].'&type=delete');?>">删除</a>
				 <a href="<?echo tep_href_link('admincp.php', 'act=orders_status&osID=' . $orders_status['orders_status_id'].'&type=edit');?>">详情</a>
		   </td></tr>
<?
    }
    
    $orders_status_inputs_string = '';
    $languages = tep_get_languages();
    for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
        $orders_status_inputs_string .= '<br><img src="'.IMGDIR.'/'.$languages[$i]['directory'].'/'.$languages[$i]['image'].'" alt="'.$languages[$i]['name'].'" title="'.$languages[$i]['name'].'">&nbsp;<input type="text" name="orders_status_name[' . $languages[$i]['id'] . ']" >';
    }

?>
</table></td></tr></table>

<br><form method="post" action="<?=tep_href_link('admincp.php','act=orders_status&action=new')?>">
<table cellspacing="0" cellpadding="0" border="0" width="100%" align="center" style="word-break:break-all;"> 
<tr><td bgcolor="<?=BORDERCOLOR?>"> 
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;"> 
<tr class="header" align="center"><td colspan="2"><?=TEXT_INFO_INSERT_INTRO; ?></td>

<tr><td bgcolor="<?=ALTBG1?>"><?=TEXT_INFO_ORDERS_STATUS_NAME?></td><td bgcolor="<?=ALTBG2?>"><?=$orders_status_inputs_string?></td></tr>
<tr><td bgcolor="<?=ALTBG1?>"><?=TEXT_SET_DEFAULT?></td><td bgcolor="<?=ALTBG2?>"><input type="checkbox" name="default" value="on"></td></tr>
</table></td></tr></table>
<center><input type="submit" name="searchsubmit" value="提   交"> &nbsp; </center></form>
<br>

<?
}
?>