manufacturers.php

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

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

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

*/

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

cpheader();

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

$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_manufacturers':
		 case 'edit_manufacturers':
        if (isset($HTTP_GET_VARS['mID'])) $manufacturers_id = addslashes($HTTP_GET_VARS['mID']);
        $manufacturers_name = addslashes($HTTP_POST_VARS['manufacturers_name']);
        $datetime=date("Y-m-d h:i:s",time());
        
				if ($action == 'new_manufacturers') {
           $db->query("insert into $table_manufacturers (manufacturers_name,date_added) values ('$manufacturers_name','$datetime')");
           $manufacturers_id = $db->insert_id();
        } elseif ($action == 'edit_manufacturers') {
           $db->query("update $table_manufacturers set last_modified = '" . addslashes($datetime) . "' where manufacturers_id = '" . (int)$manufacturers_id. "'");
        }
        $manufacturers_image = new upload('manufacturers_image',$soobic.'./upload/images/manufacturers/');
				if ($manufacturers_image->parse($timestamp)) {
           $query = $db->query("select manufacturers_image from $table_manufacturers where manufacturers_id = '" . (int)$mID. "'");
           $manufacturer = $db->fetch_array($query);
           $image_location = "upload/images/manufacturers/".$manufacturer['manufacturers_image'];
           if (file_exists($image_location)) @unlink($image_location);
					 $manufacturers_image->save();
					 $db->query("update $table_manufacturers set manufacturers_image = '" . $manufacturers_image->filename . "' where manufacturers_id = '" . (int)$manufacturers_id . "'");
        }
        $languages = tep_get_languages();
        for ($i=0, $n=sizeof($languages); $i<$n; $i++) {
           $manufacturers_url_array = $HTTP_POST_VARS['manufacturers_url'];
           $language_id = $languages[$i]['id'];
           if ($action == 'new_manufacturers') {
              $db->query("insert into $table_manufacturers_info (manufacturers_url,manufacturers_id,languages_id) values ('".addslashes($manufacturers_url_array[$language_id])."','$manufacturers_id','".$language_id."')");
           } elseif ($action == 'edit_manufacturers') {
              $db->query("update $table_manufacturers_info set manufacturers_url = '" .addslashes($manufacturers_url_array[$language_id]). "' where manufacturers_id = '" . (int)$manufacturers_id . "' and languages_id = '" . (int)$language_id . "'");
           }
        }
        updatecache('manufacturers');
        cpmsg("Lansen! 厂家操作成功。",tep_href_link('admincp.php','act=manufacturers&page='.$page.'&mID=' . $manufacturers_id)); 
     break;
     case 'delete_manufacturers': 
        $query = $db->query("select manufacturers_image from $table_manufacturers where manufacturers_id = '" . (int)$mID. "'");
        $manufacturer = $db->fetch_array($query);
        $image_location = "upload/images/manufacturers/".$manufacturer['manufacturers_image'];
        if (file_exists($image_location)) @unlink($image_location);
        
				$db->query("DELETE FROM $table_manufacturers WHERE manufacturers_id='$mID'");
		    $db->query("DELETE FROM $table_manufacturers_info WHERE manufacturers_id='$mID'");
        $db->query("update $table_products set manufacturers_id = '' where manufacturers_id = '" . (int)$mID . "'");
        
		    updatecache("manufacturers");
		    cpmsg("Lansen! 厂家删除。",tep_href_link('admincp.php','act=manufacturers&page='.$page)); 
     break;     
     default:
  }
}elseif($type){
  switch($type){
     case 'new_manufacturers':
        $manufacturers_inputs_string = '';
				$languages = tep_get_languages();
        for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
          $manufacturers_inputs_string .= '<br><img src="'.IMGDIR.'/'. $languages[$i]['directory'] . '/' . $languages[$i]['image'].'" border="0" alt="'.$languages[$i]['name'].'"> &nbsp;<input type="text" size="30" name="manufacturers_url[' . $languages[$i]['id'] . ']">';
        }
?>        
<form method="post" name="manufacturers"  action="<?=tep_href_link('admincp.php','act=manufacturers')?>" enctype="multipart/form-data">
<input type="hidden" name="action" value="new_manufacturers">
<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_HEADING_NEW_MANUFACTURER;?></td></tr>

<tr align="center" bgcolor="<?=ALTBG1?>"><td width="40%" align="right"><?=TEXT_MANUFACTURERS_NAME;?></td>
<td align="left"><input type="text" name="manufacturers_name"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right"><?=TEXT_MANUFACTURERS_IMAGE;?></td>
<td align="left"><input type="file" name="manufacturers_image"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right"><?=TEXT_MANUFACTURERS_URL;?></td>
<td align="left"><?=$manufacturers_inputs_string;?></td>
</tr>

</table></td></tr></table>
<br><center><?=$warning?>
<input type="submit" name="submit" value="提   交">&nbsp;
</center></form><br><br>
<?
     break;
     case 'delete_manufacturers':
        if(!$confirmed) {
		        cpmsg("本操作不可恢复，您确定要删除该厂家？", tep_href_link('admincp.php','act=manufacturers&action=delete_manufacturers&page='.$page.'&mID='.$mID), "form");
        } 
     break;
     case 'edit_manufacturer':
				$query = $db->query("select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from $table_manufacturers where manufacturers_id='$mID' order by manufacturers_name ");
        $manufacturers_details = $db->fetch_array($query);

				$manufacturers_inputs_string = '';
        $languages = tep_get_languages();
        for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
            $query = $db->query("select manufacturers_url from $table_manufacturers_info where manufacturers_id = '" . (int)$mID . "' and languages_id = '" . (int)$languages[$i]['id'] . "'");
            @extract($db->fetch_array($query));
            $manufacturers_inputs_string .= '<br><img src="'.IMGDIR.'/'. $languages[$i]['directory'] . '/' . $languages[$i]['image'].'" border="0" alt="'.$languages[$i]['name'].'"> &nbsp;<input type="text" size="30" name="manufacturers_url[' . $languages[$i]['id'] . ']" value="'.$manufacturers_url.'">';
        }
        
?>     

<br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td><?=SPECIALS_NOTICE?></td></tr>
<tr bgcolor="<?=ALTBG1?>"><td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr><td></td>
<td align="right" class="bold"><?php echo '<a href="'.tep_href_link('admincp.php','act=manufacturers&page=' . $page).'">'.IMAGE_BACK.'</a>&nbsp;'; ?>&nbsp;</td>
</tr></table></td></tr></table></td></tr></table>
<br>

<form method="post" name="manufacturers" action="<?=tep_href_link('admincp.php','act=manufacturers&page='.$page.'&mID='.$mID)?>" enctype="multipart/form-data">
<input type="hidden" name="action" value="edit_manufacturers">
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td colspan="7"><?=TEXT_HEADING_EDIT_MANUFACTURER;?></td></tr>

<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right"><?=TEXT_MANUFACTURERS_NAME;?></td>
<td align="left"><input type="text" size="20" name="manufacturers_name" value="<?=$manufacturers_details['manufacturers_name']?>"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right"><?=TEXT_MANUFACTURERS_IMAGE;?></td>
<td align="left"><img src="upload/images/manufacturers/<?=$manufacturers_details['manufacturers_image'];?>"><br><input type="file" name="manufacturers_image"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right"><?=TEXT_MANUFACTURERS_URL;?></td>
<td align="left"><?=$manufacturers_inputs_string;?>"</td>
</tr>

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

?>
<br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td><?=SPECIALS_NOTICE?></td></tr>
<tr bgcolor="<?=ALTBG1?>"><td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr><td></td>
<td align="right" class="bold"><a href="<?=tep_href_link('admincp.php','act=manufacturers&type=new_manufacturers')?>"><?=TEXT_HEADING_NEW_MANUFACTURER?></a>&nbsp;</td>
</tr></table></td></tr></table></td></tr></table>
<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%" style="word-break:break-all;"> 
<tr class="header" align="center"><td><?=TABLE_HEADING_MANUFACTURERS; ?></td><td><?=TABLE_HEADING_ACTION; ?></td></tr>
<?
   if($page) {
		  $start_limit = ($page - 1) * MAX_DISPLAY_SEARCH_RESULTS ;
	 } else {
		  $start_limit = 0;
		  $page = 1;
	 }
	 
   $query = $db->query("SELECT COUNT(*) FROM $table_manufacturers order by manufacturers_name");
	 $multipage = multi($db->result($query, 0), MAX_DISPLAY_SEARCH_RESULTS, $page, "admincp.php?act=manufacturers&order=$order".($desc ? "&desc=$desc" : NULL));
	 
	 $query = "select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from $table_manufacturers order by manufacturers_name $desc LIMIT $start_limit, ".MAX_DISPLAY_SEARCH_RESULTS;
   $manufacturers_query = $db->query($query);

	 while ($manufacturers = $db->fetch_array($manufacturers_query)) {
      if ((!isset($HTTP_GET_VARS['mID']) || (isset($HTTP_GET_VARS['mID']) && ($HTTP_GET_VARS['mID'] == $manufacturers['manufacturers_id']))) && (substr($action, 0, 3) != 'new')) {
         
				 $manufacturer_products_query = $db->query("select count(*) as products_count from $table_products where manufacturers_id = '" . (int)$manufacturers['manufacturers_id'] . "'");
         $manufacturer_products = $db->fetch_array($manufacturer_products_query);

         $mInfo_array = array_merge($manufacturers, $manufacturer_products);
         @extract($mInfo_array);
      }

?>     
</tr>
<td bgcolor="<?=ALTBG1?>"><?php echo $manufacturers['manufacturers_name']; ?></td>
<td bgcolor="<?=ALTBG2?>" align="center" width="15%">
	   <a href="<?=tep_href_link('admincp.php','act=manufacturers&type=edit_manufacturer&mID=' . $manufacturers['manufacturers_id'].'&page=' . $page)?>">修改</a>
		 <a href="<?=tep_href_link('admincp.php','act=manufacturers&type=delete_manufacturers&mID=' . $manufacturers['manufacturers_id'].'&page=' . $page)?>">删除</a></td>
</tr>
<?php
  }

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


<?
}
?>