Changeset 21400 for branches/version-2_11-dev/data/class
- Timestamp:
- 2012/01/17 16:03:47 (15 years ago)
- Location:
- branches/version-2_11-dev/data/class
- Files:
-
- 3 edited
-
SC_Initial.php (modified) (1 diff)
-
SC_Product.php (modified) (2 diffs)
-
pages/products/LC_Page_Products_List.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_11-dev/data/class/SC_Initial.php
r21384 r21400 113 113 */ 114 114 function phpconfigInit() { 115 // E_DEPRECATED 定数 (for PHP < 5.3) 116 // TODO バージョン互換処理に統合したい。 117 $this->defineIfNotDefined('E_DEPRECATED', 8192); 118 119 // エラーレベル設定 120 // 開発時は E_ALL を推奨 121 error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED); 122 115 123 ini_set('display_errors', '1'); 116 124 ini_set('html_errors', '1'); -
branches/version-2_11-dev/data/class/SC_Product.php
r21386 r21400 74 74 function findProductIdsOrder(&$objQuery, $arrVal = array()) { 75 75 $table = <<< __EOS__ 76 dtb_products AS alldtl 77 LEFT JOIN dtb_products_class 78 ON alldtl.product_id = dtb_products_class.product_id 79 LEFT JOIN dtb_product_categories 80 ON alldtl.product_id = dtb_product_categories.product_id 76 dtb_products AS alldtl 77 JOIN dtb_products_class AS T1 78 ON alldtl.product_id = T1.product_id 79 JOIN dtb_product_categories AS T2 80 ON alldtl.product_id = T2.product_id 81 JOIN dtb_category 82 ON T2.category_id = dtb_category.category_id 81 83 __EOS__; 82 84 $objQuery->setGroupBy('alldtl.product_id'); … … 117 119 function findProductCount(&$objQuery, $arrVal = array()) { 118 120 $table = <<< __EOS__ 119 dtb_products AS alldtl120 LEFT JOIN dtb_products_class121 ON alldtl.product_id = dtb_products_class.product_id122 LEFT JOIN dtb_product_categories123 ON alldtl.product_id = dtb_product_categories.product_id121 dtb_products AS alldtl 122 JOIN dtb_product_categories AS T2 123 ON alldtl.product_id = T2.product_id 124 JOIN dtb_category 125 ON T2.category_id = dtb_category.category_id 124 126 __EOS__; 125 127 $objQuery->setGroupBy('alldtl.product_id'); -
branches/version-2_11-dev/data/class/pages/products/LC_Page_Products_List.php
r21386 r21400 425 425 426 426 if (strlen($searchCondition["where_category"]) >= 1) { 427 $searchCondition['where'] .= " AND dtb_product_categories.".$searchCondition["where_category"];427 $searchCondition['where'] .= " AND T2.".$searchCondition["where_category"]; 428 428 $searchCondition['arrval'] = array_merge($searchCondition['arrval'], $searchCondition['arrvalCategory']); 429 429 }
Note: See TracChangeset
for help on using the changeset viewer.
