Changeset 5259 for temp


Ignore:
Timestamp:
2006/09/20 14:45:58 (20 years ago)
Author:
kakinaka
Message:

blank

Location:
temp/trunk
Files:
6 edited

Legend:

Unmodified
Added
Removed

  • temp/trunk/data/conf/conf.php

    r5256 r5259  
    840840        FROM dtb_products_class GROUP BY product_id) AS T2 
    841841        ON T1.product_id = T2.product_id_sub ) ) AS T3 LEFT JOIN (SELECT rank AS category_rank, category_id AS sub_category_id FROM dtb_category) AS T4 
    842         ON T3.category_id = T4.sub_category_id) vw_products_allclass_detail ', 
     842        ON T3.category_id = T4.sub_category_id) ', 
    843843 
    844844    "vw_product_class" => ' 

  • temp/trunk/data/lib/slib.php

    r5258 r5259  
    17541754            USING (product_id) WHERE A.category_id = ? AND A.del_flg = 0 AND status = 1 ORDER BY A.rank"; 
    17551755    $arrItems = $conn->getAll($sql, array($category_id)); 
     1756     
     1757    sfprintr($arrItems); 
    17561758    return $arrItems; 
    17571759} 

  • temp/trunk/html/admin/products/index_csv.php

    r1328 r5259  
    2727    global $arrPRODUCTS_CVSCOL; 
    2828 
    29     $from = "vw_product_class"; 
     29    $from = "vw_product_class AS prdcls"; 
    3030    $cols = sfGetCommaList($arrOutputCols); 
    3131     

  • temp/trunk/html/frontparts/bloc/best5.php

    r5258 r5259  
    3131     
    3232    $arrBestProducts = $objQuery->select($col, $from, $where); 
    33     $objQuery->getlastquery(); 
    3433    return $arrBestProducts; 
    3534} 

  • temp/trunk/html/products/detail.php

    r5255 r5259  
    140140$objQuery = new SC_Query(); 
    141141// DB¤«¤é¾¦ÉʾðÊó¤ò¼èÆÀ¤¹¤ë¡£ 
    142 $arrRet = $objQuery->select("*", "vw_products_allclass_detail", "product_id = ?", array($tmp_id)); 
     142$arrRet = $objQuery->select("*", "vw_products_allclass_detail AS alldtl", "product_id = ?", array($tmp_id)); 
    143143$objPage->arrProduct = $arrRet[0]; 
    144144 

  • temp/trunk/html/products/list.php

    r5255 r5259  
    352352        $objQuery = new SC_Query(); 
    353353        $col = "product_class_id, classcategory_id1, classcategory_id2, class_id1, class_id2, stock, stock_unlimited"; 
    354         $table = "vw_product_class"; 
     354        $table = "vw_product_class AS prdcls"; 
    355355        $where = "product_id = ?"; 
    356356        $objQuery->setorder("rank1 DESC, rank2 DESC"); 
Note: See TracChangeset for help on using the changeset viewer.