Changeset 5253 for temp


Ignore:
Timestamp:
2006/09/20 14:33:35 (20 years ago)
Author:
kakinaka
Message:

blank

Location:
temp/trunk
Files:
7 edited

Legend:

Unmodified
Added
Removed

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

    r5252 r5253  
    780780        FROM dtb_products_class WHERE classcategory_id1 = 0 AND classcategory_id2 = 0)  
    781781        AS T2 
    782         ON T1.product_id = T2.product_id_sub) vw_products_nonclass', 
     782        ON T1.product_id = T2.product_id_sub) ', 
    783783     
    784784    "vw_products_allclass" => ' 

  • temp/trunk/html/admin/customer/index.php

    r4853 r5253  
    200200        case 'delete_all': 
    201201            // ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü 
    202             $where = "product_id IN (SELECT product_id FROM vw_products_nonclass WHERE $where)"; 
     202            $where = "product_id IN (SELECT product_id FROM vw_products_nonclass AS noncls WHERE $where)"; 
    203203            $sqlval['del_flg'] = 1; 
    204204            $objQuery->update("dtb_products", $sqlval, $where, $arrval); 

  • temp/trunk/html/admin/mail/htmlmail_select.php

    r4608 r5253  
    7171    // Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê 
    7272    $col = "product_id, name, category_id, main_list_image, status, product_code, price01, stock, stock_unlimited"; 
    73     $from = "vw_products_nonclass"; 
     73    $from = "vw_products_nonclass AS noncls "; 
    7474         
    7575    $objQuery = new SC_Query(); 

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

    r4608 r5253  
    223223        case 'delete_all': 
    224224            // ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü 
    225             $where = "product_id IN (SELECT product_id FROM vw_products_nonclass WHERE $where)"; 
     225            $where = "product_id IN (SELECT product_id FROM vw_products_nonclass AS noncls  WHERE $where)"; 
    226226            $sqlval['del_flg'] = 1; 
    227227            $objQuery->update("dtb_products", $sqlval, $where, $arrval); 
    … …  
    230230            // Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê 
    231231            $col = "product_id, name, category_id, main_list_image, status, product_code, price01, price02, stock, stock_unlimited"; 
    232             $from = "vw_products_nonclass"; 
     232            $from = "vw_products_nonclass AS noncls "; 
    233233 
    234234            // ¹Ô¿ô¤Î¼èÆÀ 

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

    r5202 r5253  
    221221    $objQuery = new SC_Query(); 
    222222    $col = "*"; 
    223     $table = "vw_products_nonclass"; 
     223    $table = "vw_products_nonclass AS noncls "; 
    224224    $where = "product_id = ?"; 
    225225    $arrRet = $objQuery->select($col, $table, $where, array($product_id)); 

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

    r4812 r5253  
    6464    $objQuery = new SC_Query(); 
    6565    $col = "product_id, name, main_list_image, rank, product_code"; 
    66     $table = "vw_products_nonclass"; 
     66    $table = "vw_products_nonclass AS noncls "; 
    6767    $where = "del_flg = 0 AND category_id = ?"; 
    6868     

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

    r4608 r5253  
    7373    // Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê 
    7474    $col = "product_id, name, category_id, main_list_image, status, product_code, price01, stock, stock_unlimited"; 
    75     $from = "vw_products_nonclass"; 
     75    $from = "vw_products_nonclass AS noncls "; 
    7676         
    7777    $objQuery = new SC_Query(); 
Note: See TracChangeset for help on using the changeset viewer.