Changeset 17503

Timestamp:

2008/08/07 13:52:02 (16 years ago)

Author:

miningbrownie

Message:

登録処理がPOSTからのデータになっていたのをCSVからのデータで処理するように変更

File:

• branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSVCategory.php (modified) (7 diffs)

branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSVCategory.php

@@ -149 +149 @@
                             $this->objFormParam->convParam();
                             // <br>なしでエラー取得する。
-                            $arrCSVErr = $this->lfCheckError();
+                            $arrCSVErr = $this->lfCheckError($arrCSV);
                         }
 
@@ -162 +162 @@
 
                         if (!$err) {
-                            $this->lfRegistProduct($objQuery, $line);
+                            $this->lfRegistProduct($objQuery, $line,$arrCSV);
                             $regist++;
                         }
@@ -235 +235 @@
      * @return void
      */
-    function lfRegistProduct($objQuery, $line = "") {
+    function lfRegistProduct($objQuery, $line = "",$arrCSV) {
+        
         $objDb = new SC_Helper_DB_Ex();
-        $arrRet = $this->objFormParam->getHashArray();
-        
-        //カテゴリID
-        if ($arrRet['category_id'] == 0) {
-            $category_id = $objQuery->max("dtb_category", "category_id") + 1;
-            $sqlval['category_id'] = $category_id;
+        $arrRet['category_id'] = $arrCSV[0];
+        $arrRet['category_name'] = $arrCSV[1];
+        $arrRet['parent_category_id'] = $arrCSV[2];
+        
+        //存在確認
+        $count = $objQuery->count("dtb_category","category_id = ?",array($arrRet['category_id']));
+        if($count == 0){
             $update = false;
-        } else {
-            $sqlval['category_id'] = $arrRet['category_id'];
+        }else if($count == 1){
             $update = true;
-        }
-        
+        }else{
+            echo "ERROR";
+            return;
+        }
+        $sqlval['category_id'] = $arrRet['category_id'];
         // カテゴリ名
         $sqlval['category_name'] = $arrRet['category_name'];
@@ -281 +285 @@
             echo "INSERT　";
             $sqlval['create_date'] = $time;
+//            var_dump($sqlval);
             // ランク
             if ($sqlval['parent_category_id'] == 0) {
@@ -293 +298 @@
                 $sqlup = "UPDATE dtb_category SET rank = (rank + 1) WHERE rank >= ?";
                 $objQuery->exec($sqlup, array($sqlval['rank']));
+                
             }
             $objQuery->insert("dtb_category", $sqlval);
+            $objQuery->getLastQuery();
         }
     }
@@ -303 +310 @@
      * @return void
      */
-    function lfCheckError() {
-        $arrRet =  $this->objFormParam->getHashArray();
+    function lfCheckError($arrCSV) {
+//        $arrRet =  $this->objFormParam->getHashArray();
+        $arrRet['category_id'] = $arrCSV[0];
+        $arrRet['category_name'] = $arrCSV[1];
+        $arrRet['parent_category_id'] = $arrCSV[2];
+        
         $objQuery = new SC_Query();
+        
         $objErr = new SC_CheckError($arrRet);
         $objErr->arrErr = $this->objFormParam->checkError(false);
@@ -343 +355 @@
             // 編集中のレコード以外に同じ名称が存在する場合
             if ($arrCat[0]['category_id'] != $arrRet['category_id'] && $arrCat[0]['category_name'] == $arrRet['category_name']) {
-                $objErr->arrErr['category_name'] = "※ 既に同じ内容の登録が存在します。<br>";
+                echo $arrCat[0]['category_id'];
+                echo "#######--------- line is ".__LINE__." on ".__FILE__."--------########<br/>";
+                        
+                echo $arrRet['category_id'];
+                echo "#######--------- line is ".__LINE__." on ".__FILE__."--------########<br/>";
+                        
+                echo  $arrCat[0]['category_name'] ;
+                echo "#######--------- line is ".__LINE__." on ".__FILE__."--------########<br/>";
+                        echo  $arrRet['category_name'];
+                        echo "#######--------- line is ".__LINE__." on ".__FILE__."--------########<br/>";
+                                
+                
+                $objErr->arrErr['category_name'] = "※ 既に同じ内容の登録が存在します。</br>";
+                
             }
         }