Changeset 17226

Timestamp:

2008/04/07 13:29:15 (16 years ago)

Author:

satou

Message:

fixed by pineray (merge r17190:r17191)

Location:

branches/version-2/data

Files:

• Smarty/templates/default/admin/products/index.tpl (modified) (1 diff)
• class/pages/admin/products/LC_Page_Admin_Products.php (modified) (1 diff)
• class/pages/admin/products/LC_Page_Admin_Products_Category.php (modified) (1 diff)

branches/version-2/data/Smarty/templates/default/admin/products/index.tpl

@@ -346 +346 @@
                             <!--{* カテゴリ名 *}-->
                             <div id="disp_cat<!--{$smarty.section.cnt.iteration}-->" style="display:<!--{$cat_flg}-->">
-                            <!--{assign var=key value=$arrProducts[cnt].category_id}-->
-                            <!--{$arrCatList[$key]|sfTrim}-->
+                            <!--{foreach from=$arrProducts[cnt].categories item=category_id name=categories}-->
+                              <!--{$arrCatList[$category_id]|sfTrim}-->
+                              <!--{if !$smarty.foreach.categories.last}--><br /><!--{/if}-->
+                            <!--{/foreach}-->
                             </div>
 

branches/version-2/data/class/pages/admin/products/LC_Page_Admin_Products.php

@@ -312 +312 @@
                     // 検索結果の取得
                     $this->arrProducts = $objQuery->select($col, $from, $where, $arrval);
+
+                    // 各商品ごとのカテゴリIDを取得
+                    if (count($this->arrProducts) > 0) {
+                        foreach ($this->arrProducts as $key => $val) {
+                            $this->arrProducts[$key]["categories"] = $objDb->sfGetCategoryId($val["product_id"]);
+                            $objDb->g_category_on = false;
+                        }
+                    }
                 }
             }

branches/version-2/data/class/pages/admin/products/LC_Page_Admin_Products_Category.php

@@ -126 +126 @@
             }
             // 登録商品のチェック
-            $where = "category_id = ? AND del_flg = 0";
-            $count = $objQuery->count("dtb_products", $where, array($_POST['category_id']));
+            $table = "dtb_product_categories AS T1 LEFT JOIN dtb_products AS T2 ON T1.product_id = T2.product_id";
+            $where = "T1.category_id = ? AND T2.del_flg = 0";
+            $count = $objQuery->count($table, $where, array($_POST['category_id']));
             if($count != 0) {
                 $this->arrErr['category_name'] = "※ カテゴリ内に商品が存在するため削除できません。<br>";