Changeset 3493 for temp/trunk/html


Ignore:
Timestamp:
2006/08/31 16:58:41 (20 years ago)
Author:
kakinaka
Message:

blank

File:
1 edited

Legend:

Unmodified
Added
Removed

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

    r2022 r3493  
    4848 
    4949switch($_POST['mode']) { 
     50// µ¬³Êºï½üÍ×µá 
     51case 'delete': 
     52    $objQuery = new SC_Query(); 
     53     
     54    $objQuery->setLimitOffset(1); 
     55    $where = "product_id = ? AND NOT (classcategory_id1 = 0 AND classcategory_id2 = 0)"; 
     56    $objQuery->setOrder("rank1 DESC, rank2 DESC"); 
     57    $arrRet = $objQuery->select("*", "vw_cross_products_class", $where, array($_POST['product_id'])); 
     58     
     59    if(count($arrRet) > 0) { 
     60 
     61        $sqlval['product_id'] = $arrRet[0]['product_id']; 
     62        $sqlval['classcategory_id1'] = '0'; 
     63        $sqlval['classcategory_id2'] = '0'; 
     64        $sqlval['product_code'] = $arrRet[0]['product_code']; 
     65        $sqlval['stock'] = $arrRet[0]['stock']; 
     66        $sqlval['price01'] = $arrRet[0]['price01']; 
     67        $sqlval['price02'] = $arrRet[0]['price02']; 
     68        $sqlval['creator_id'] = $_SESSION['member_id']; 
     69        $objQuery->begin(); 
     70        $where = "product_id = ?"; 
     71        $objQuery->delete("dtb_products_class", $where, array($_POST['product_id']));        
     72        $objQuery->insert("dtb_products_class", $sqlval); 
     73        $objQuery->commit(); 
     74    } 
     75     
     76    lfProductClassPage();   // µ¬³ÊÅÐÏ¿¥Ú¡¼¥¸    
     77    break; 
     78     
    5079// ÊÔ½¸Í×µá 
    5180case 'pre_edit': 
Note: See TracChangeset for help on using the changeset viewer.