Changeset 21481 for branches/version-2_12-dev/data/class/pages/products
- Timestamp:
- 2012/02/11 05:48:00 (12 years ago)
- Location:
- branches/version-2_12-dev/data/class/pages/products
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_CategoryList.php
r21480 r21481 155 155 function lfInitParam($arrRequest) { 156 156 $objFormParam = new SC_FormParam_Ex(); 157 $objFormParam->addParam("カテゴリID", "category_id", INT_LEN, 'n', array('NUM_CHECK','MAX_LENGTH_CHECK'));157 $objFormParam->addParam("カテゴリID", 'category_id', INT_LEN, 'n', array('NUM_CHECK','MAX_LENGTH_CHECK')); 158 158 // 値の取得 159 159 $objFormParam->setParam($arrRequest); -
branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_Detail.php
r21480 r21481 69 69 parent::init(); 70 70 $masterData = new SC_DB_MasterData_Ex(); 71 $this->arrSTATUS = $masterData->getMasterData( "mtb_status");72 $this->arrSTATUS_IMAGE = $masterData->getMasterData( "mtb_status_image");73 $this->arrDELIVERYDATE = $masterData->getMasterData( "mtb_delivery_date");74 $this->arrRECOMMEND = $masterData->getMasterData( "mtb_recommend");71 $this->arrSTATUS = $masterData->getMasterData('mtb_status'); 72 $this->arrSTATUS_IMAGE = $masterData->getMasterData('mtb_status_image'); 73 $this->arrDELIVERYDATE = $masterData->getMasterData('mtb_delivery_date'); 74 $this->arrRECOMMEND = $masterData->getMasterData('mtb_recommend'); 75 75 } 76 76 … … 162 162 } 163 163 break; 164 case "add_favorite":164 case 'add_favorite': 165 165 // ログイン中のユーザが商品をお気に入りにいれる処理 166 166 if ($objCustomer->isLoginSuccess() === true && $this->objFormParam->getValue('favorite_product_id') > 0) { … … 174 174 break; 175 175 176 case "add_favorite_sphone":176 case 'add_favorite_sphone': 177 177 // ログイン中のユーザが商品をお気に入りにいれる処理(スマートフォン用) 178 178 if ($objCustomer->isLoginSuccess() === true && $this->objFormParam->getValue('favorite_product_id') > 0) { … … 180 180 if (count($this->arrErr) == 0) { 181 181 if ($this->lfRegistFavoriteProduct($this->objFormParam->getValue('favorite_product_id'),$objCustomer->getValue('customer_id'))) { 182 print "true";182 print 'true'; 183 183 exit; 184 184 } 185 185 } 186 print "error";186 print 'error'; 187 187 exit; 188 188 } … … 363 363 364 364 // 規格名一覧 365 $arrClassName = SC_Helper_DB_Ex::sfGetIDValueList( "dtb_class", "class_id", 'name');365 $arrClassName = SC_Helper_DB_Ex::sfGetIDValueList('dtb_class', 'class_id', 'name'); 366 366 // 規格分類名一覧 367 $arrClassCatName = SC_Helper_DB_Ex::sfGetIDValueList( "dtb_classcategory", "classcategory_id", 'name');367 $arrClassCatName = SC_Helper_DB_Ex::sfGetIDValueList('dtb_classcategory', 'classcategory_id', 'name'); 368 368 // 商品規格情報の取得 369 369 $arrProductsClass = $this->lfGetProductsClass($product_id); … … 421 421 /* パラメーター情報の初期化 */ 422 422 function lfInitParam(&$objFormParam) { 423 $objFormParam->addParam("規格1", "classcategory_id1", INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));424 $objFormParam->addParam("規格2", "classcategory_id2", INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));423 $objFormParam->addParam("規格1", 'classcategory_id1', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 424 $objFormParam->addParam("規格2", 'classcategory_id2', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 425 425 $objFormParam->addParam("数量", 'quantity', INT_LEN, 'n', array('EXIST_CHECK', 'ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 426 426 $objFormParam->addParam("管理者ログイン", 'admin', INT_LEN, 'a', array('ALNUM_CHECK','MAX_LENGTH_CHECK')); 427 $objFormParam->addParam("商品ID", "product_id", INT_LEN, 'n', array('EXIST_CHECK', 'ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));428 $objFormParam->addParam("お気に入り商品ID", "favorite_product_id", INT_LEN, 'n', array('ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));429 $objFormParam->addParam("商品規格ID", "product_class_id", INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));427 $objFormParam->addParam("商品ID", 'product_id', INT_LEN, 'n', array('EXIST_CHECK', 'ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 428 $objFormParam->addParam("お気に入り商品ID", 'favorite_product_id', INT_LEN, 'n', array('ZERO_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 429 $objFormParam->addParam("商品規格ID", 'product_class_id', INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 430 430 // 値の取得 431 431 $objFormParam->setParam($_REQUEST); … … 448 448 449 449 $objQuery->setOrder("rank DESC"); 450 $arrRecommendData = $objQuery->select("recommend_product_id, comment", "dtb_recommend_products", "product_id = ?", array($product_id));450 $arrRecommendData = $objQuery->select("recommend_product_id, comment", 'dtb_recommend_products', "product_id = ?", array($product_id)); 451 451 452 452 $arrRecommendProductId = array(); 453 453 foreach ($arrRecommendData as $recommend) { 454 $arrRecommendProductId[] = $recommend[ "recommend_product_id"];454 $arrRecommendProductId[] = $recommend['recommend_product_id']; 455 455 } 456 456 … … 487 487 // 複数項目チェック 488 488 if ($tpl_classcat_find1) { 489 $objErr->doFunc(array("規格1", "classcategory_id1"), array('EXIST_CHECK'));489 $objErr->doFunc(array("規格1", 'classcategory_id1'), array('EXIST_CHECK')); 490 490 } 491 491 if ($tpl_classcat_find2) { 492 $objErr->doFunc(array("規格2", "classcategory_id2"), array('EXIST_CHECK'));492 $objErr->doFunc(array("規格2", 'classcategory_id2'), array('EXIST_CHECK')); 493 493 } 494 494 break; … … 503 503 //商品ごとのレビュー情報を取得する 504 504 $col = "create_date, reviewer_url, reviewer_name, recommend_level, title, comment"; 505 $from = "dtb_review";505 $from = 'dtb_review'; 506 506 $where = "del_flg = 0 AND status = 1 AND product_id = ? ORDER BY create_date DESC LIMIT " . REVIEW_REGIST_MAX; 507 507 $arrval[] = $id; … … 523 523 $subImageFlag = false; 524 524 for ($i = 1; $i <= PRODUCTSUB_MAX; $i++) { 525 if ($arrFile[ "sub_image". $i]['filepath'] != "") {525 if ($arrFile['sub_image' . $i]['filepath'] != "") { 526 526 $subImageFlag = true; 527 527 } … … 536 536 function lfRegistFavoriteProduct($favorite_product_id,$customer_id) { 537 537 // ログイン中のユーザが商品をお気に入りにいれる処理 538 if (!SC_Helper_DB_Ex::sfIsRecord( "dtb_products", "product_id", $favorite_product_id, "del_flg = 0 AND status = 1")) {538 if (!SC_Helper_DB_Ex::sfIsRecord('dtb_products', 'product_id', $favorite_product_id, "del_flg = 0 AND status = 1")) { 539 539 SC_Utils_Ex::sfDispSiteError(PRODUCT_NOT_FOUND); 540 540 return false; 541 541 } else { 542 542 $objQuery =& SC_Query_Ex::getSingletonInstance(); 543 $exists = $objQuery->exists( "dtb_customer_favorite_products", "customer_id = ? AND product_id = ?", array($customer_id, $favorite_product_id));543 $exists = $objQuery->exists('dtb_customer_favorite_products', "customer_id = ? AND product_id = ?", array($customer_id, $favorite_product_id)); 544 544 545 545 if (!$exists) { -
branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_List.php
r21480 r21481 72 72 73 73 $masterData = new SC_DB_MasterData_Ex(); 74 $this->arrSTATUS = $masterData->getMasterData( "mtb_status");75 $this->arrSTATUS_IMAGE = $masterData->getMasterData( "mtb_status_image");76 $this->arrDELIVERYDATE = $masterData->getMasterData( "mtb_delivery_date");77 $this->arrPRODUCTLISTMAX = $masterData->getMasterData( "mtb_product_list_max");74 $this->arrSTATUS = $masterData->getMasterData('mtb_status'); 75 $this->arrSTATUS_IMAGE = $masterData->getMasterData('mtb_status_image'); 76 $this->arrDELIVERYDATE = $masterData->getMasterData('mtb_delivery_date'); 77 $this->arrPRODUCTLISTMAX = $masterData->getMasterData('mtb_product_list_max'); 78 78 } 79 79 … … 129 129 switch ($this->getMode()) { 130 130 131 case "json":131 case 'json': 132 132 $this->arrProducts = $this->setStatusDataTo($this->arrProducts, $this->arrSTATUS, $this->arrSTATUS_IMAGE); 133 133 $this->arrProducts = $objProduct->setPriceTaxTo($this->arrProducts); … … 183 183 // 商品IDの正当性チェック 184 184 if (!SC_Utils_Ex::sfIsInt($this->arrForm['product_id']) 185 || !SC_Helper_DB_Ex::sfIsRecord( "dtb_products", "product_id", $this->arrForm['product_id'], "del_flg = 0 AND status = 1")) {185 || !SC_Helper_DB_Ex::sfIsRecord('dtb_products', 'product_id', $this->arrForm['product_id'], "del_flg = 0 AND status = 1")) { 186 186 SC_Utils_Ex::sfDispSiteError(PRODUCT_NOT_FOUND); 187 187 } … … 270 270 271 271 default: 272 if (strlen($searchCondition[ "where_category"]) >= 1) {273 $dtb_product_categories = "(SELECT * FROM dtb_product_categories WHERE ".$searchCondition[ "where_category"].")";272 if (strlen($searchCondition['where_category']) >= 1) { 273 $dtb_product_categories = "(SELECT * FROM dtb_product_categories WHERE ".$searchCondition['where_category'].")"; 274 274 $arrval_order = $searchCondition['arrvalCategory']; 275 275 } else { … … 404 404 'where' => "", 405 405 'arrval' => array(), 406 "where_category"=> "",406 'where_category' => "", 407 407 'arrvalCategory' => array() 408 408 ); 409 409 410 410 // カテゴリからのWHERE文字列取得 411 if ($arrSearchData[ "category_id"] != 0) {412 list($searchCondition[ "where_category"], $searchCondition['arrvalCategory']) = SC_Helper_DB_Ex::sfGetCatWhere($arrSearchData["category_id"]);411 if ($arrSearchData['category_id'] != 0) { 412 list($searchCondition['where_category'], $searchCondition['arrvalCategory']) = SC_Helper_DB_Ex::sfGetCatWhere($arrSearchData['category_id']); 413 413 } 414 414 // ▼対象商品IDの抽出 … … 416 416 $searchCondition['where'] = "alldtl.del_flg = 0 AND alldtl.status = 1 "; 417 417 418 if (strlen($searchCondition[ "where_category"]) >= 1) {419 $searchCondition['where'] .= ' AND EXISTS (SELECT * FROM dtb_product_categories WHERE ' . $searchCondition[ "where_category"] . ' AND product_id = alldtl.product_id)';418 if (strlen($searchCondition['where_category']) >= 1) { 419 $searchCondition['where'] .= ' AND EXISTS (SELECT * FROM dtb_product_categories WHERE ' . $searchCondition['where_category'] . ' AND product_id = alldtl.product_id)'; 420 420 $searchCondition['arrval'] = array_merge($searchCondition['arrval'], $searchCondition['arrvalCategory']); 421 421 } -
branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_Review.php
r21480 r21481 57 57 58 58 $masterData = new SC_DB_MasterData_Ex(); 59 $this->arrRECOMMEND = $masterData->getMasterData( "mtb_recommend");60 $this->arrSex = $masterData->getMasterData( "mtb_sex");61 $this->arrReviewDenyURL = $masterData->getMasterData( "mtb_review_deny_url");59 $this->arrRECOMMEND = $masterData->getMasterData('mtb_recommend'); 60 $this->arrSex = $masterData->getMasterData('mtb_sex'); 61 $this->arrReviewDenyURL = $masterData->getMasterData('mtb_review_deny_url'); 62 62 $this->tpl_mainpage = 'products/review.tpl'; 63 63 $this->httpCacheControl('nocache'); … … 143 143 */ 144 144 function lfInitParam(&$objFormParam) { 145 $objFormParam->addParam("レビューID", "review_id", INT_LEN, 'aKV');146 $objFormParam->addParam("商品ID", "product_id", INT_LEN, 'n', array('NUM_CHECK','EXIST_CHECK', 'MAX_LENGTH_CHECK'));147 $objFormParam->addParam("投稿者名", "reviewer_name", STEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));148 $objFormParam->addParam("投稿者URL", "reviewer_url", MTEXT_LEN, 'a', array('NO_SPTAB', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK', 'URL_CHECK'));145 $objFormParam->addParam("レビューID", 'review_id', INT_LEN, 'aKV'); 146 $objFormParam->addParam("商品ID", 'product_id', INT_LEN, 'n', array('NUM_CHECK','EXIST_CHECK', 'MAX_LENGTH_CHECK')); 147 $objFormParam->addParam("投稿者名", 'reviewer_name', STEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 148 $objFormParam->addParam("投稿者URL", 'reviewer_url', MTEXT_LEN, 'a', array('NO_SPTAB', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK', 'URL_CHECK')); 149 149 $objFormParam->addParam("性別", 'sex', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 150 $objFormParam->addParam("おすすめレベル", "recommend_level", INT_LEN, 'n', array('EXIST_CHECK', 'SELECT_CHECK'));150 $objFormParam->addParam("おすすめレベル", 'recommend_level', INT_LEN, 'n', array('EXIST_CHECK', 'SELECT_CHECK')); 151 151 $objFormParam->addParam("タイトル", 'title', STEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 152 152 $objFormParam->addParam("コメント", 'comment', LTEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); … … 166 166 // 重複メッセージの判定 167 167 $objQuery =& SC_Query_Ex::getSingletonInstance(); 168 $exists = $objQuery->exists( "dtb_review","product_id = ? AND title = ? ", array($arrForm['product_id'], $arrForm['title']));168 $exists = $objQuery->exists('dtb_review',"product_id = ? AND title = ? ", array($arrForm['product_id'], $arrForm['title'])); 169 169 if ($exists) { 170 170 $arrErr['title'] .= "重複したタイトルは登録できません。"; … … 190 190 $objQuery =& SC_Query_Ex::getSingletonInstance(); 191 191 192 return $objQuery->get('name', "dtb_products", "product_id = ? ", array($product_id));192 return $objQuery->get('name', 'dtb_products', "product_id = ? ", array($product_id)); 193 193 } 194 194 … … 205 205 $objQuery->begin(); 206 206 $arrRegist['review_id'] = $objQuery->nextVal('dtb_review_review_id'); 207 $objQuery->insert( "dtb_review", $arrRegist);207 $objQuery->insert('dtb_review', $arrRegist); 208 208 $objQuery->commit(); 209 209 }
Note: See TracChangeset
for help on using the changeset viewer.