Changeset 12022
- Timestamp:
- 2007/03/29 14:28:54 (17 years ago)
- Location:
- branches/dev
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/data/Smarty/templates/admin/total/page_products.tpl
r17 r12022 31 31 <td align="center"><!--{*½ç°Ì*}--><!--{$smarty.section.cnt.iteration}--></td> 32 32 <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> 34 34 <td align="right"><!--{*¹ØÆþ·ï¿ô*}--><!--{$arrResults[cnt].order_count}-->·ï</td> 35 35 <td align="right"><!--{*ÅÀ¿ô*}--><!--{$arrResults[cnt].products_count}--></td> -
branches/dev/html/admin/total/index.php
r57 r12022 617 617 list($where, $arrval) = lfGetWhereMember('create_date', $sdate, $edate, $type); 618 618 619 $sql = "SELECT T1.product_id, T1.product_code, T 2.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 "; 620 620 $sql.= "FROM ( "; 621 621 $sql.= "SELECT product_id, product_code, price, "; … … 626 626 $sql.= "GROUP BY product_id, product_code, price "; 627 627 $sql.= ") "; 628 $sql.= " AS T1 LEFT JOIN dtb_products AS T2 USING (product_id) WHERE T2.name IS NOT NULL AND status = 1ORDER BY T1.total DESC ";628 $sql.= "ORDER BY T1.total DESC "; 629 629 630 630 if($mode != "csv") { -
branches/dev/html/admin/total/index_sub.php
r17 r12022 135 135 $arrDataCol = array( 136 136 'product_code', 137 ' name',137 'product_name', 138 138 'order_count', 139 139 'products_count',
Note: See TracChangeset
for help on using the changeset viewer.