Changeset 12022


Ignore:
Timestamp:
2007/03/29 14:28:54 (15 years ago)
Author:
uehara
Message:
 
Location:
branches/dev
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • branches/dev/data/Smarty/templates/admin/total/page_products.tpl

    r17 r12022  
    3131        <td align="center"><!--{*½ç°Ì*}--><!--{$smarty.section.cnt.iteration}--></td> 
    3232        <td align="right"><!--{*¾¦ÉÊÈÖ¹æ*}--><!--{$arrResults[cnt].product_code|escape}--></td> 
    33         <td align="left"><!--{*¾¦ÉÊ̾*}--><!--{$arrResults[cnt].name|sfCutString:40|escape}--></td> 
     33        <td align="left"><!--{*¾¦ÉÊ̾*}--><!--{$arrResults[cnt].product_name|sfCutString:40|escape}--></td> 
    3434        <td align="right"><!--{*¹ØÆþ·ï¿ô*}--><!--{$arrResults[cnt].order_count}-->·ï</td> 
    3535        <td align="right"><!--{*ÅÀ¿ô*}--><!--{$arrResults[cnt].products_count}--></td> 
  • branches/dev/html/admin/total/index.php

    r57 r12022  
    617617    list($where, $arrval) = lfGetWhereMember('create_date', $sdate, $edate, $type); 
    618618     
    619     $sql = "SELECT T1.product_id, T1.product_code, T2.name, T1.products_count, T1.order_count, T1.price, T1.total "; 
     619    $sql = "SELECT T1.product_id, T1.product_code, T1.product_name, T1.products_count, T1.order_count, T1.price, T1.total "; 
    620620    $sql.= "FROM ( "; 
    621621    $sql.= "SELECT product_id, product_code, price, "; 
     
    626626    $sql.= "GROUP BY product_id, product_code, price "; 
    627627    $sql.= ") "; 
    628     $sql.= "AS T1 LEFT JOIN dtb_products AS T2 USING (product_id) WHERE T2.name IS NOT NULL AND status = 1 ORDER BY T1.total DESC "; 
     628    $sql.= "ORDER BY T1.total DESC "; 
    629629     
    630630    if($mode != "csv") { 
  • branches/dev/html/admin/total/index_sub.php

    r17 r12022  
    135135        $arrDataCol = array( 
    136136            'product_code', 
    137             'name', 
     137            'product_name', 
    138138            'order_count', 
    139139            'products_count', 
Note: See TracChangeset for help on using the changeset viewer.