Changeset 21376 for branches/version-2_11-dev/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSVCategory.php

Timestamp:

2011/12/26 17:11:08 (12 years ago)

Author:

Seasoft

Message:

#1582 (SC_Query 一致レコードの有無を返す機能を追加 (パフォーマンス改善))
#1526 (typo修正・ソース整形・ソースコメントの改善)
#1449 (不要な関数・処理の整理)

File:

• branches/version-2_11-dev/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSVCategory.php (modified) (2 diffs)

branches/version-2_11-dev/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSVCategory.php

@@ -374 +374 @@
             // 同じidが存在すればupdate存在しなければinsert
             $where = "category_id = ?";
-            $category_count = $objQuery->count("dtb_category", $where, array($sqlval['category_id']));
-            if($category_count > 0){
+            $category_exists = $objQuery->exists("dtb_category", $where, array($sqlval['category_id']));
+            if ($category_exists) {
                 // UPDATEの実行
                 $where = "category_id = ?";
                 $objQuery->update("dtb_category", $sqlval, $where, array($sqlval['category_id']));
-            }else{
+            } else {
                 $sqlval['create_date'] = $arrList['update_date'];
                 // 新規登録
@@ -477 +477 @@
             }
             $where = "parent_category_id = ? AND category_id <> ? AND category_name = ?";
-            $count = $objQuery->count('dtb_category',
+            $exists = $objQuery->exists('dtb_category',
                         $where,
                         array($parent_category_id,
                                 $item['category_id'],
                                 $item['category_name']));
-            if($count > 0) {
+            if ($exists) {
                 $arrErr['category_name'] = "※ 既に同名のカテゴリが存在します。";
             }