- Timestamp:
- 2007/08/24 19:46:25 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update/data/class/helper/SC_Helper_DB.php
r15343 r15347 253 253 */ 254 254 function sfTotalCart($objPage, $objCartSess, $arrInfo) { 255 $objDb = new SC_Helper_DB_Ex(); 255 256 // 規格名一覧 256 $arrClassName = SC_Utils_Ex::sfGetIDValueList("dtb_class", "class_id", "name");257 $arrClassName = $objDb->sfGetIDValueList("dtb_class", "class_id", "name"); 257 258 // 規格分類名一覧 258 $arrClassCatName = SC_Utils_Ex::sfGetIDValueList("dtb_classcategory", "classcategory_id", "name");259 $arrClassCatName = $objDb->sfGetIDValueList("dtb_classcategory", "classcategory_id", "name"); 259 260 260 261 $objPage->tpl_total_pretax = 0; // 費用合計(税込み) … … 302 303 $objPage->arrProductsClass[$cnt]['quantity'] = $quantity; 303 304 $objPage->arrProductsClass[$cnt]['cart_no'] = $arrCart[$i]['cart_no']; 304 $objPage->arrProductsClass[$cnt]['class_name1'] = $arrClassName[$arrData['class_id1']]; 305 $objPage->arrProductsClass[$cnt]['class_name2'] = $arrClassName[$arrData['class_id2']]; 306 $objPage->arrProductsClass[$cnt]['classcategory_name1'] = $arrClassCatName[$arrData['classcategory_id1']]; 307 $objPage->arrProductsClass[$cnt]['classcategory_name2'] = $arrClassCatName[$arrData['classcategory_id2']]; 305 $objPage->arrProductsClass[$cnt]['class_name1'] = 306 isset($arrClassName[$arrData['class_id1']]) 307 ? $arrClassName[$arrData['class_id1']] : ""; 308 309 $objPage->arrProductsClass[$cnt]['class_name2'] = 310 isset($arrClassName[$arrData['class_id2']]) 311 ? $arrClassName[$arrData['class_id2']] : ""; 312 313 $objPage->arrProductsClass[$cnt]['classcategory_name1'] = 314 $arrClassCatName[$arrData['classcategory_id1']]; 315 316 $objPage->arrProductsClass[$cnt]['classcategory_name2'] = 317 $arrClassCatName[$arrData['classcategory_id2']]; 308 318 309 319 // 画像サイズ … … 537 547 538 548 /** 549 * 子IDの配列を返す. 550 * 551 * @param string $table テーブル名 552 * @param string $pid_name 親ID名 553 * @param string $id_name ID名 554 * @param integer $id ID 555 * @param array 子ID の配列 556 */ 557 function sfGetChildsID($table, $pid_name, $id_name, $id) { 558 $arrRet = $this->sfGetChildrenArray($table, $pid_name, $id_name, $id); 559 return $arrRet; 560 } 561 562 /** 539 563 * 階層構造のテーブルから子ID配列を取得する. 540 564 * … … 616 640 617 641 return $arrParents; 642 } 643 644 /** 645 * カテゴリから商品を検索する場合のWHERE文と値を返す. 646 * 647 * @param integer $category_id カテゴリID 648 * @return array 商品を検索する場合の配列 649 */ 650 function sfGetCatWhere($category_id) { 651 // 子カテゴリIDの取得 652 $arrRet = $this->sfGetChildsID("dtb_category", "parent_category_id", "category_id", $category_id); 653 $tmp_where = ""; 654 foreach ($arrRet as $val) { 655 if($tmp_where == "") { 656 $tmp_where.= " category_id IN ( ?"; 657 } else { 658 $tmp_where.= ",? "; 659 } 660 $arrval[] = $val; 661 } 662 $tmp_where.= " ) "; 663 return array($tmp_where, $arrval); 618 664 } 619 665 … … 855 901 return false; 856 902 } 903 857 904 } 858 905 ?>
Note: See TracChangeset
for help on using the changeset viewer.