reviews.php

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

<?php
/*
  [SOOBIC!] admin/reviews.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."/reviews.php");

if ($action) {
  switch($action){
     case 'save':
        $reviews_id = tep_db_prepare_input($rID);
        $reviews_rating = tep_db_prepare_input($rating);
        $reviews_text = tep_db_prepare_input($reviews_text);

        $db->query("update $table_reviews set reviews_rating = '" . safe_input($reviews_rating) . "', last_modified = now() where reviews_id = '" . (int)$reviews_id . "'");
        $db->query("update $table_reviews_description set reviews_text = '" . safe_input($reviews_text) . "' where reviews_id = '" . (int)$reviews_id . "'");

        cpmsg("Lansen! 评论修改成功。",tep_href_link('admincp.php','act=reviews'.(isset($page) ? '&page=' . $page: '').'&rID=' . $reviews_id)); 
     break;
     case 'delete': 
        $db->query("delete from $table_reviews where reviews_id = '" . (int)$rID . "'");
        $db->query("delete from $table_reviews_description where reviews_id = '" . (int)$rID . "'");

		    cpmsg("Lansen! 评论成功删除。",tep_href_link('admincp.php','act=reviews'.(isset($page) ? '&page=' . $page: ''))); 
     break;     
     default:
  }
}elseif($type){
  switch($type){
     case 'delete':
        cpmsg("本操作不可恢复，您确定要删除该评论？", tep_href_link('admincp.php','act=reviews&action=delete'.(isset($page) ? '&page=' . $page: '').'&rID=' . $rID), "form");
        
     break;
     case 'edit':
				$query = $db->query("select r.reviews_id, r.date_added, r.last_modified, r.customers_name, r.reviews_rating, rd.reviews_text, pd.products_name, pd.products_id from $table_reviews r left join $table_products_description pd on pd.products_id=r.products_id, $table_reviews_description rd   where pd.language_id = '".(int)$languages_id."' and r.reviews_id = rd.reviews_id and r.reviews_id = '" . (int)$rID. "' order by date_added DESC");
        $reviews = $db->fetch_array($query);
        @extract($reviews);
        ${'checked_'.$reviews_rating}='checked';
				
?>
<form method="post" action="<?=tep_href_link('admincp.php','act=reviews&action=save'.(isset($page) ? '&page=' . $page: '').'&rID=' . $rID)?>">
<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"><?=HEADING_TITLE;?></td></tr>
<tr><td bgcolor="<?=ALTBG1?>"><?=ENTRY_PRODUCT?></td><td bgcolor="<?=ALTBG2?>"><?=$products_name?></td></tr>

<tr><td bgcolor="<?=ALTBG1?>"><?=ENTRY_FROM?></b></td><td bgcolor="<?=ALTBG2?>"><?=tep_output_string_protected($customers_name)?></td></tr>

<tr><td bgcolor="<?=ALTBG1?>"><?=ENTRY_REVIEW?></td><td bgcolor="<?=ALTBG2?>"><textarea name="reviews_text" wrap="soft" cols="80" rows="8"><?=$reviews_text?></textarea></td></tr>

<tr><td bgcolor="<?=ALTBG1?>"><?=ENTRY_RATING?></td><td bgcolor="<?=ALTBG2?>"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td width="20%"><input type="radio" name="rating" value="5" <?=$checked_5?>><font color=#cc6600>★★★★★</font></td><td width="20%"><input type="radio" name="rating" value="4" <?=$checked_4?>><font color=#cc6600>★★★★</font>☆</td><td width="20%"><input type="radio" name="rating" value="3" <?=$checked_3?>><font color=#cc6600>★★★</font>☆☆</td><td width="20%"><input type="radio" name="rating" value="2" <?=$checked_2?>><font color=#cc6600>★★</font>☆☆☆</td><td width="20%"><input type="radio" name="rating" value="1" <?=$checked_1?>><font color=#cc6600>★</font>☆☆☆☆</td></tr>
<tr><td>优秀，一定要买</td><td width="20%">不错，值得购买</td><td width="20%">还行</td><td width="20%">不太好</td><td width="20%">差劲</td></tr>
</tr></table></td></tr>
</table></td></tr></table>
</table></td></tr></table>
<br><center><?=$warning?>
<input type="submit" name="submit" value="提   交">&nbsp;<input type="button" value="返  回" accesskey="e" onClick="history.go(-1)">
</center></form>

<?				
		 break;
		 default:
  }
}else{

	 if($page) {
		  $start_limit = ($page - 1) * MAX_DISPLAY_SEARCH_RESULTS ;
	 } else {
		  $start_limit = 0;
		  $page = 1;
	 }
	 
   $query = $db->query("SELECT COUNT(*) FROM $table_reviews order by date_added DESC");
	 $multipage = multi($db->result($query, 0), MAX_DISPLAY_SEARCH_RESULTS, $page, "admincp.php?act=reviews&order=$order".($desc ? "&desc=$desc" : NULL));
   
?>  
 
<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><td bgcolor="<?=ALTBG1?>" colspan="2">
<?=$multipage?></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 width="20%"><?=TABLE_HEADING_PRODUCTS; ?></td>
<td width="39%"><?=HEADING_TITLE; ?></td>
<td width="13%"><?=TABLE_HEADING_RATING; ?></td>
<td width="13%"><?=TABLE_HEADING_DATE_ADDED; ?></td>
<td width="13%"><?=TABLE_HEADING_ACTION; ?></td></tr>
<?
	 $query = $db->query("select r.reviews_id, r.date_added, r.last_modified, r.customers_name, r.reviews_rating, rd.reviews_text, pd.products_name, pd.products_id from $table_reviews r left join $table_products_description pd on pd.products_id=r.products_id, $table_reviews_description rd  where pd.language_id = '".(int)$languages_id."' and r.reviews_id = rd.reviews_id order by date_added DESC LIMIT $start_limit, ".MAX_DISPLAY_SEARCH_RESULTS);
   while ($reviews = $db->fetch_array($query)) {
				@extract($reviews);
        $reviews_text=wordscut($reviews_text,50);
?>
              <tr>  
								<td bgcolor="<?=ALTBG1?>"><a href="product_info.php?products_id=<?=$products_id?>" target=_blank><?=tep_get_products_name($products_id)?></a></td>
                <td bgcolor="<?=ALTBG1?>" align="left"><?=$reviews_text?>&nbsp;</td>
								<td bgcolor="<?=ALTBG1?>" align="center"><?for($i=0;$i<(int)$reviews_rating;$i++){?>★<?}?></font><?for($i=0;$i<(5-(int)$reviews_rating);$i++){?>☆<?}?></td>
                <td bgcolor="<?=ALTBG1?>" align="center"><?php echo tep_date_short($reviews['date_added']); ?></td>
                <td bgcolor="<?=ALTBG2?>" align="center" width="15%">
	                  <a href="<?=tep_href_link('admincp.php','act=reviews&type=edit&page='.$page.'&rID='.$reviews_id)?>">详情</a>
	                  <a href="<?=tep_href_link('admincp.php','act=reviews&type=delete&page='.$page.'&rID='.$reviews_id)?>">删除</a>
	             </td>
							</tr>
<?php
   }
?>
</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>
<td bgcolor="<?=ALTBG1?>" colspan="2">
<?=$multipage?></td></tr>
</table></td></tr></table>

<?
}
?>