Changeset 4923 for temp/trunk


Ignore:
Timestamp:
2006/09/17 20:56:29 (20 years ago)
Author:
kakinaka
Message:

blank

File:
1 edited

Legend:

Unmodified
Added
Removed
  • temp/trunk/html/admin/home.php

    r4922 r4923  
    4747// ¿·µ¬¼õÉÕ°ìÍ÷ 
    4848$objPage->arrNewOrder = lfGetNewOrder(); 
    49  
    50 sfprintr($objPage->arrNewOrder ); 
    5149 
    5250// ¤ªÃΤ餻°ìÍ÷¤Î¼èÆÀ 
     
    145143    $col.= "(SELECT det.product_name FROM dtb_order_detail AS det WHERE ord.order_id = det.order_id LIMIT 1) AS product_name, "; 
    146144    $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"; 
    148145    $col.= "cast(create_date as date) AS create_date"; 
    149146    $from = "dtb_order AS ord"; 
     
    151148    $objQuery->setoption("ORDER BY create_date DESC LIMIT 10 OFFSET 0"); 
    152149    $arrRet = $objQuery->select($col, $from, $where); 
     150     
     151    $objQuery->getlastquery(); 
    153152    return $arrRet; 
    154153} 
Note: See TracChangeset for help on using the changeset viewer.