Changeset 4923 for temp/trunk
- Timestamp:
- 2006/09/17 20:56:29 (20 years ago)
- File:
-
- 1 edited
-
temp/trunk/html/admin/home.php (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
temp/trunk/html/admin/home.php
r4922 r4923 47 47 // ¿·µ¬¼õÉÕ°ìÍ÷ 48 48 $objPage->arrNewOrder = lfGetNewOrder(); 49 50 sfprintr($objPage->arrNewOrder );51 49 52 50 // ¤ªÃΤ餻°ìÍ÷¤Î¼èÆÀ … … 145 143 $col.= "(SELECT det.product_name FROM dtb_order_detail AS det WHERE ord.order_id = det.order_id LIMIT 1) AS product_name, "; 146 144 $col.= "(SELECT pay.payment_method FROM dtb_payment AS pay WHERE ord.payment_id = pay.payment_id) AS payment_method, "; 147 // $col.= "to_char(create_date, 'YYYY/MM/DD HH24:MI') AS create_date";148 145 $col.= "cast(create_date as date) AS create_date"; 149 146 $from = "dtb_order AS ord"; … … 151 148 $objQuery->setoption("ORDER BY create_date DESC LIMIT 10 OFFSET 0"); 152 149 $arrRet = $objQuery->select($col, $from, $where); 150 151 $objQuery->getlastquery(); 153 152 return $arrRet; 154 153 }
Note: See TracChangeset
for help on using the changeset viewer.
