Changeset 16808

Timestamp:

2007/11/27 20:32:49 (19 years ago)

Author:

satou

Message:

#188
修正完了。

Location:

branches/feature-module-update/data

Files:

• Smarty/templates/default/list.tpl (modified) (1 diff)
• class/pages/products/LC_Page_Products_List.php (modified) (2 diffs)

branches/feature-module-update/data/Smarty/templates/default/list.tpl

@@ -139 +139 @@
            <div class="in_cart">
              <dl>
+           
+         <!--{assign var=class1 value=classcategory_id`$id`_1}-->
+         <!--{assign var=class2 value=classcategory_id`$id`_2}-->
          <!--{if $tpl_classcat_find1[$id]}-->
-           <!--{assign var=class1 value=classcategory_id`$id`_1}-->
-           <!--{assign var=class2 value=classcategory_id`$id`_2}-->
            <dt><!--{$tpl_class_name1[$id]|escape}-->：</dt>
-           <dd><select name="<!--{$class1}-->" style="<!--{$arrErr[$class1]|sfGetErrorColor}-->" onchange="lnSetSelect('<!--{$class1}-->', '<!--{$class2}-->', '<!--{$id}-->','');">
+           <dd>
+             <select name="<!--{$class1}-->" style="<!--{$arrErr[$class1]|sfGetErrorColor}-->" onchange="lnSetSelect('<!--{$class1}-->', '<!--{$class2}-->', '<!--{$id}-->','');">
              <option value="">選択してください</option>
              <!--{html_options options=$arrClassCat1[$id] selected=$arrForm[$class1]}-->
-           </select>
+             </select>
              <!--{if $arrErr[$class1] != ""}-->
              <br /><span class="attention">※ <!--{$tpl_class_name1[$id]}-->を入力して下さい。</span>
              <!--{/if}-->
            </dd>
-
-           <!--{/if}-->
-           <!--{if $tpl_classcat_find2[$id]}-->
-             <dt><!--{$tpl_class_name2[$id]|escape}-->：</dt>
-             <dd><select name="<!--{$class2}-->" style="<!--{$arrErr[$class2]|sfGetErrorColor}-->">
-               <option value="">選択してください</option>
+         <!--{/if}-->
+         <!--{if $tpl_classcat_find2[$id]}-->
+           <dt><!--{$tpl_class_name2[$id]|escape}-->：</dt>
+           <dd>
+             <select name="<!--{$class2}-->" style="<!--{$arrErr[$class2]|sfGetErrorColor}-->">
+             <option value="">選択してください</option>
              </select>
-
              <!--{if $arrErr[$class2] != ""}-->
              <br /><span class="attention">※ <!--{$tpl_class_name2[$id]}-->を入力して下さい。</span>
              <!--{/if}-->
-             </dd>
-
-           <!--{/if}-->
-           <!--{assign var=quantity value=quantity`$id`}-->
-
+           </dd>
+         <!--{/if}-->
+         
+         <!--{assign var=quantity value=quantity`$id`}-->
            <dt>個数：</dt>
            <dd><input type="text" name="<!--{$quantity}-->" size="3" class="box54" value="<!--{$arrForm[$quantity]|default:1}-->" maxlength="<!--{$smarty.const.INT_LEN}-->" style="<!--{$arrErr[$quantity]|sfGetErrorColor}-->" />

branches/feature-module-update/data/class/pages/products/LC_Page_Products_List.php

@@ -382 +382 @@
         //価格順
         case 'price':
-            $distinct = "DISTINCT ON (price02_min, product_id)";
-            $col = $distinct . " *";
-            $from = "vw_products_allclass ";
-            $order = "price02_min ASC, product_id ASC";
+            $col = "DISTINCT price02_min, product_id, product_code_min, product_code_max,"
+                . " price01_min, price01_max, price02_max,"
+                . " stock_min, stock_max, stock_unlimited_min,"
+                . " stock_unlimited_max, del_flg, status, name, comment1,"
+                . " comment2, comment3, main_list_comment, main_image,"
+                . " main_list_image, product_flag, deliv_date_id, sale_limit,"
+                . " point_rate, sale_unlimited, create_date, deliv_fee";
+            $from = "vw_products_allclass AS T1";
+            $order = "price02_min, product_id";
             break;
 
         //新着順
         case 'date':
-            $distinct = "DISTINCT ON (create_date, product_id)";
-            $col = $distinct . " *";
-            $from = "vw_products_allclass ";
-            $order = "create_date DESC, product_id ASC";
+            $col = "DISTINCT create_date, product_id, product_code_min, product_code_max,"
+                . " price01_min, price01_max, price02_min, price02_max,"
+                . " stock_min, stock_max, stock_unlimited_min,"
+                . " stock_unlimited_max, del_flg, status, name, comment1,"
+                . " comment2, comment3, main_list_comment, main_image,"
+                . " main_list_image, product_flag, deliv_date_id, sale_limit,"
+                . " point_rate, sale_unlimited, create_date, deliv_fee";
+            $from = "vw_products_allclass AS T1";
+            $order = "create_date DESC, product_id";
             break;
 
         default:
             $col = "DISTINCT T1.product_id, product_code_min, product_code_max,"
-                . " price01_min, price01_max, price02_min, price02_max, "
-                . " stock_min, stock_max, stock_unlimited_min, "
-                . " stock_unlimited_max, del_flg, status, name, comment1, "
-                . " comment2, comment3, main_list_comment, main_image, "
+                . " price01_min, price01_max, price02_min, price02_max,"
+                . " stock_min, stock_max, stock_unlimited_min,"
+                . " stock_unlimited_max, del_flg, status, name, comment1,"
+                . " comment2, comment3, main_list_comment, main_image,"
                 . " main_list_image, product_flag, deliv_date_id, sale_limit,"
                 . " point_rate, sale_unlimited, create_date, deliv_fee, "
                 . " T4.product_rank, T4.category_rank";
-            $from = "vw_products_allclass AS T1 "
+            $from = "vw_products_allclass AS T1"
                 . " JOIN ("
-                . " SELECT max(T3.rank) AS category_rank, "
-                . "        max(T2.rank) AS product_rank, "
+                . " SELECT max(T3.rank) AS category_rank,"
+                . "        max(T2.rank) AS product_rank,"
                 . "        T2.product_id"
-                . "   FROM dtb_product_categories T2  "
-                . "   JOIN dtb_category T3 USING (category_id) "
+                . "   FROM dtb_product_categories T2"
+                . "   JOIN dtb_category T3 USING (category_id)"
                 . " GROUP BY product_id) AS T4 USING (product_id)";
             $order = "T4.category_rank DESC, T4.product_rank DESC";
@@ -588 +598 @@
 
         $classcategory_id_2 = $classcategory_id . "_2";
-        if (!isset($$classcategory_id_2)) $$classcategory_id_2 = "";
-        if (!isset($_POST[$$classcategory_id_2])) $_POST[$$classcategory_id_2] = "";
+        if (!isset($classcategory_id_2)) $classcategory_id_2 = "";
+        if (!isset($_POST[$classcategory_id_2])) $_POST[$classcategory_id_2] = "";
 
         $this->tpl_onload .= "lnSetSelect('" . $classcategory_id ."_1', "
-            . "'" . $$classcategory_id_2 . "',"
+            . "'" . $classcategory_id_2 . "',"
             . "'" . $product_id . "',"
-            . "'" . $_POST[$$classcategory_id_2] ."'); ";
+            . "'" . $_POST[$classcategory_id_2] ."'); ";
 
         // 規格1が設定されている