Changeset 10614

Timestamp:

2006/12/14 14:07:57 (18 years ago)

Author:

uehara

Message:

 

File:

• temp/branches/ec-cube-beta/html/admin/products/upload_csv.php (modified) (2 diffs)

temp/branches/ec-cube-beta/html/admin/products/upload_csv.php

@@ -8 +8 @@
 
 require_once("../require.php");
-require_once("./upload_csv.inc");
 
 class LC_Page {
@@ -200 +199 @@
     $objFormParam->addParam("¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È(4)", "recommend_comment4", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK"));
 }
+
+/* ¾¦Éʤο·µ¬Äɲà */
+function lfRegistProduct($objQuery) {
+    global $objFormParam;
+    $arrRet = $objFormParam->getHashArray();
+    
+    // dtb_products°Ê³°¤ËÅÐÏ¿¤µ¤ì¤ëÃͤò½ü³°¤¹¤ë¡£
+    foreach($arrRet as $key => $val) {
+        switch($key) {
+        case 'product_code':
+        case 'price01':
+        case 'price02':
+        case 'point_rate':
+        case 'stock':
+        case 'product_class_id':
+        case 'recommend_product_id1':
+        case 'recommend_product_id2':
+        case 'recommend_product_id3':
+        case 'recommend_product_id4':
+        case 'recommend_comment1':
+        case 'recommend_comment2':
+        case 'recommend_comment3':
+        case 'recommend_comment4':
+            break;
+        default:
+            if(!ereg("^dummy", $key)) {
+                $sqlval[$key] = $val;
+            }
+            break;
+        }
+    }
+    // ÅÐÏ¿»þ´Ö¤òÀ¸À®(DB¤Înow()¤À¤Ècommit¤·¤¿ºÝ¡¢¤¹¤Ù¤ÆƱ°ì¤Î»þ´Ö¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¦)
+    $time = date("Y-m-d H:i:s");
+    $m = (float)microtime();
+    list($dummy, $m_time) = split("\.", $m);
+    $time .= ".$m_time";
+    $sqlval['update_date'] = $time;
+    $sqlval['creator_id'] = $_SESSION['member_id'];
+        
+    if($sqlval['sale_limit'] == "") {
+        $sqlval['sale_unlimited'] = '1';
+    } else {
+        $sqlval['sale_unlimited'] = '0';        
+    }
+    
+    if($sqlval['status'] == "") {
+        $sqlval['status'] = 2;
+    }
+
+    if($arrRet['product_id'] != "" && $arrRet['product_class_id'] != "") {
+        // ¥«¥Æ¥´¥êÆâ¥é¥ó¥¯¤ÎÄ´À°½èÍý
+        $old_catid = $objQuery->get("dtb_products", "category_id", "product_id = ?", array($arrRet['product_id']));
+        sfMoveCatRank($objQuery, "dtb_products", "product_id", "category_id", $old_catid, $arrRet['category_id'], $arrRet['product_id']);
+
+        // UPDATE¤Î¼Â¹Ô
+        $where = "product_id = ?";
+        $objQuery->update("dtb_products", $sqlval, $where, array($sqlval['product_id']));
+    } else {
+
+        // ¿·µ¬ÅÐÏ¿
+        $product_id = $objQuery->nextval("dtb_products", "product_id");
+        $sqlval['product_id'] = $product_id;
+        $sqlval['create_date'] = $time;
+        
+        // ¥«¥Æ¥´¥êÆâ¤ÇºÇÂç¤Î¥é¥ó¥¯¤ò³ä¤êÅö¤Æ¤ë
+        $sqlval['rank'] = $objQuery->max("dtb_products", "rank", "category_id = ?", array($arrRet['category_id'])) + 1;
+        
+        // INSERT¤Î¼Â¹Ô
+        $objQuery->insert("dtb_products", $sqlval);
+    }
+    
+    // µ¬³ÊÅÐÏ¿
+    lfRegistProductClass($objQuery, $arrRet, $sqlval['product_id'], $arrRet['product_class_id']);
+    
+    // ¤ª¤¹¤¹¤á¾¦ÉÊÅÐÏ¿
+    $objQuery->delete("dtb_recommend_products", "product_id = ?", array($sqlval['product_id']));
+    for($i = 1; $i <= RECOMMEND_PRODUCT_MAX; $i++) {
+        $keyname = "recommend_product_id" . $i;
+        $comment_key = "recommend_comment" . $i;
+        if($arrRet[$keyname] != "") {
+            $arrProduct = $objQuery->select("product_id", "dtb_products", "product_id = ?", array($arrRet[$keyname]));
+            if($arrProduct[0]['product_id'] != "") {
+                $arrval['product_id'] = $sqlval['product_id'];
+                $arrval['recommend_product_id'] = $arrProduct[0]['product_id'];
+                $arrval['comment'] = $arrRet[$comment_key];
+                $arrval['update_date'] = "Now()";
+                $arrval['create_date'] = "Now()";
+                $arrval['creator_id'] = $_SESSION['member_id'];
+                $arrval['rank'] = RECOMMEND_PRODUCT_MAX - $i + 1;
+                $objQuery->insert("dtb_recommend_products", $arrval);
+            }
+        }
+    }
+}
+
+/* µ¬³Ê¤ÎÅÐÏ¿ */
+function lfRegistProductClass($objQuery, $arrList, $product_id, $product_class_id) {
+    $sqlval['product_code'] = $arrList["product_code"];
+    $sqlval['stock'] = $arrList["stock"];
+    if($sqlval['stock'] == "") {
+        $sqlval['stock_unlimited'] = '1';
+    } else {
+        $sqlval['stock_unlimited'] = '0';       
+    }
+    $sqlval['price01'] = $arrList['price01'];
+    $sqlval['price02'] = $arrList['price02'];
+    $sqlval['creator_id'] = $_SESSION['member_id'];
+    if($sqlval['member_id'] == "") {
+        $sqlval['creator_id'] = '0';
+    }
+        
+    if($product_class_id == "") {
+        // ¿·µ¬ÅÐÏ¿
+        $where = "product_id = ?";
+        // Ç°¤Î¤¿¤á¤Ë´û¸¤Îµ¬³Ê¤òºï½ü
+        $objQuery->delete("dtb_products_class", $where, array($product_id));
+        $sqlval['product_id'] = $product_id;
+        $sqlval['classcategory_id1'] = '0';
+        $sqlval['classcategory_id2'] = '0';
+        $sqlval['create_date'] = "now()";
+        $objQuery->insert("dtb_products_class", $sqlval);
+    } else {
+        // ´û¸ÊÔ½¸
+        $where = "product_id = ? AND product_class_id = ?";
+        $objQuery->update("dtb_products_class", $sqlval, $where, array($product_id, $product_class_id));    
+    }
+}
+
+/* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */
+function lfCheckError() {
+    global $objFormParam;
+    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
+    $arrRet =  $objFormParam->getHashArray();
+    $objErr = new SC_CheckError($arrRet);
+    $objErr->arrErr = $objFormParam->checkError(false);
+    
+    if(count($objErr->arrErr) == 0) {
+        $objQuery = new SC_Query();
+        // ¾¦ÉÊID¡¢µ¬³ÊID¤Î¸ºß¥Á¥§¥Ã¥¯
+        if($arrRet['product_id'] != "") {
+            $count = $objQuery->count("dtb_products", "product_id = ?", array($arrRet['product_id']));
+            if($count == 0) {
+                $objErr->arrErr['product_id'] = "¢¨ »ØÄê¤Î¾¦ÉÊID¤Ï¡¢ÅÐÏ¿¤µ¤ì¤Æ¤¤¤Þ¤»¤ó¡£";
+            }
+        }
+                
+        if($arrRet['product_class_id'] != "") {
+            $count = 0;
+            if($arrRet['product_id'] != "") {
+                $count = $objQuery->count("dtb_products_class", "product_id = ? AND product_class_id = ?", array($arrRet['product_id'], $arrRet['product_class_id']));
+            }
+            if($count == 0) {
+                $objErr->arrErr['product_class_id'] = "¢¨ »ØÄê¤Îµ¬³ÊID¤Ï¡¢ÅÐÏ¿¤µ¤ì¤Æ¤¤¤Þ¤»¤ó¡£";
+            }
+        }
+    }
+    return $objErr->arrErr;
+}
 ?>