Index: /branches/comu-ver2/html/install/sql/insert_data.sql =================================================================== --- /branches/comu-ver2/html/install/sql/insert_data.sql (revision 17453) +++ /branches/comu-ver2/html/install/sql/insert_data.sql (revision 17455) @@ -12,5 +12,5 @@ insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('新着情報', 'bloc/news.tpl', 'news','frontparts/bloc/news.php', 1, now(), now()); insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('ログイン', 'bloc/login.tpl', 'login','frontparts/bloc/login.php', 1, now(), now()); -insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('オススメ商品', 'bloc/best5.tpl', 'best5','frontparts/bloc/best5.php', 1, now(), now()); +insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('おすすめ商品', 'bloc/best5.tpl', 'best5','frontparts/bloc/best5.php', 1, now(), now()); INSERT INTO dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) VALUES ('カレンダー', 'bloc/calendar.tpl', 'calendar', 'frontparts/bloc/calendar.php', 1, now(), now()); @@ -90,16 +90,16 @@ insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_large_image5','詳細-サブ拡大画像（5）',43,now(),now()); insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'deliv_date_id','発送日目安',44,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_product_id1','おすすめ商品(1)',45,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_comment1','おすすめコメント(1)',46,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_product_id2','おすすめ商品(2)',47,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_comment2','おすすめコメント(2)',48,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_product_id3','おすすめ商品(3)',49,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_comment3','おすすめコメント(3)',50,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id4','おすすめ商品(4)',51,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment4','おすすめコメント(4)',52,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_product_id5','おすすめ商品(5)',53,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_comment5','おすすめコメント(5)',54,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_product_id6','おすすめ商品(6)',55,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_comment6','おすすめコメント(6)',56,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_product_id1','関連商品(1)',45,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_comment1','関連商品コメント(1)',46,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_product_id2','関連商品(2)',47,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_comment2','関連商品コメント(2)',48,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_product_id3','関連商品(3)',49,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_comment3','関連商品コメント(3)',50,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id4','関連商品(4)',51,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment4','関連商品コメント(4)',52,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_product_id5','関連商品(5)',53,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_comment5','関連商品コメント(5)',54,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_product_id6','関連商品(6)',55,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_comment6','関連商品コメント(6)',56,now(),now()); insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'category_id','カテゴリID',57,now(),now()); insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'customer_id','顧客ID',1,now(),now()); @@ -1033,5 +1033,5 @@ INSERT INTO mtb_constants VALUES ('ENTRY_LIMIT_HOUR','1',267,'再入会制限時間（単位: 時間)'); INSERT INTO mtb_constants VALUES ('RECOMMEND_PRODUCT_MAX','6',268,'関連商品表示数'); -INSERT INTO mtb_constants VALUES ('RECOMMEND_NUM','8',269,'オススメ商品表示数'); +INSERT INTO mtb_constants VALUES ('RECOMMEND_NUM','8',269,'おすすめ商品表示数'); INSERT INTO mtb_constants VALUES ('BEST_MAX','5',270,'ベスト商品の最大登録数'); INSERT INTO mtb_constants VALUES ('BEST_MIN','3',271,'ベスト商品の最小登録数（登録数が満たない場合は表示しない。)'); Index: /branches/comu-ver2/data/class/util/SC_Utils.php =================================================================== --- /branches/comu-ver2/data/class/util/SC_Utils.php (revision 17403) +++ /branches/comu-ver2/data/class/util/SC_Utils.php (revision 17455) @@ -917,5 +917,5 @@ } - // カテゴリ別オススメ品の取得 + // カテゴリ別おすすめ商品の取得 function sfGetBestProducts( $conn, $category_id = 0){ // 既に登録されている内容を取得する Index: /branches/comu-ver2/data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php =================================================================== --- /branches/comu-ver2/data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php (revision 16919) +++ /branches/comu-ver2/data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php (revision 17455) @@ -26,5 +26,5 @@ /** - * おすすめ管理検索 のページクラス. + * おすすめ商品管理 商品検索のページクラス. * * @package Page Index: /branches/comu-ver2/data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php =================================================================== --- /branches/comu-ver2/data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php (revision 16741) +++ /branches/comu-ver2/data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php (revision 17455) @@ -26,5 +26,5 @@ /** - * おすすめ管理 のページクラス. + * おすすめ商品管理 のページクラス. * * @package Page @@ -48,5 +48,5 @@ $this->tpl_subnavi = 'contents/subnavi.tpl'; $this->tpl_subno = "recommend"; - $this->tpl_subtitle = 'オススメ管理'; + $this->tpl_subtitle = 'おすすめ商品管理'; } @@ -65,5 +65,4 @@ array( "column" => "category_id", "convert" => "n" ), array( "column" => "rank", "convert" => "n" ), - array( "column" => "title", "convert" => "aKV" ), array( "column" => "comment", "convert" => "aKV" ), ); @@ -185,6 +184,5 @@ $objErr = new SC_CheckError(); - $objErr->doFunc(array("見出しコメント", "title", STEXT_LEN), array("MAX_LENGTH_CHECK")); - $objErr->doFunc(array("オススメコメント", "comment", LTEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK")); + $objErr->doFunc(array("コメント", "comment", LTEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK")); return $objErr->arrErr; Index: /branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products_Product.php =================================================================== --- /branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products_Product.php (revision 17434) +++ /branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products_Product.php (revision 17455) @@ -137,5 +137,5 @@ $arrRet = SC_Utils_Ex::sfSplitCBValue($this->arrForm['product_flag'], "product_flag"); $this->arrForm = array_merge($this->arrForm, $arrRet); - // DBからおすすめ商品の読み込み + // DBから関連商品の読み込み $this->arrRecommend = $this->lfPreGetRecommendProducts($_POST['product_id']); @@ -204,5 +204,5 @@ $this->lfProductPage(); // 商品登録ページ break; - // おすすめ商品選択 + // 関連商品選択 case 'recommend_select' : $this->lfProductPage(); // 商品登録ページ @@ -214,5 +214,5 @@ if($_POST['mode'] != 'pre_edit') { - // おすすめ商品の読み込み + // 関連商品の読み込み $this->arrRecommend = $this->lfGetRecommendProducts(); } @@ -256,5 +256,5 @@ } - /* おすすめ商品の読み込み */ + /* 関連商品の読み込み */ function lfGetRecommendProducts() { $objQuery = new SC_Query(); @@ -277,7 +277,7 @@ } - /* おすすめ商品の登録 */ + /* 関連商品の登録 */ function lfInsertRecommendProducts($objQuery, $arrList, $product_id) { - // 一旦オススメ商品をすべて削除する + // 一旦関連商品をすべて削除する $objQuery->delete("dtb_recommend_products", "product_id = ?", array($product_id)); $sqlval['product_id'] = $product_id; @@ -303,5 +303,5 @@ } - /* 登録済みおすすめ商品の読み込み */ + /* 登録済み関連商品の読み込み */ function lfPreGetRecommendProducts($product_id) { $arrRecommend = array(); @@ -489,5 +489,5 @@ SC_Utils_Ex::sfInsertProductClass($objQuery, $arrList, $product_id); - // おすすめ商品登録 + // 関連商品登録 $this->lfInsertRecommendProducts($objQuery, $arrList, $product_id); @@ -528,5 +528,5 @@ } - // おすすめ商品 + // 関連商品 for ($cnt = 1; $cnt <= RECOMMEND_PRODUCT_MAX; $cnt++) { $arrConvList["recommend_comment$cnt"] = "KVa"; @@ -590,5 +590,5 @@ && $_POST["recommend_id$cnt"] != "" && $_POST["recommend_delete$cnt"] != 1) { - $objErr->doFunc(array("おすすめ商品コメント$cnt", "recommend_comment$cnt", LTEXT_LEN), array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objErr->doFunc(array("関連商品コメント$cnt", "recommend_comment$cnt", LTEXT_LEN), array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); } } Index: /branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php =================================================================== --- /branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php (revision 17363) +++ /branches/comu-ver2/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php (revision 17455) @@ -282,6 +282,6 @@ for ($cnt = 1; $cnt <= RECOMMEND_PRODUCT_MAX; $cnt++) { - $this->objFormParam->addParam("おすすめ商品($cnt)", "recommend_product_id$cnt", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK")); - $this->objFormParam->addParam("詳細-サブコメント($cnt)", "recommend_comment$cnt", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK")); + $this->objFormParam->addParam("関連商品($cnt)", "recommend_product_id$cnt", INT_LEN, "n", array("MAX_LENGTH_CHECK","NUM_CHECK")); + $this->objFormParam->addParam("関連商品コメント($cnt)", "recommend_comment$cnt", LTEXT_LEN, "KVa", array("SPTAB_CHECK","MAX_LENGTH_CHECK")); } @@ -380,5 +380,5 @@ $this->lfRegistProductClass($objQuery, $arrRet, $sqlval['product_id'], $arrRet['product_class_id']); - // おすすめ商品登録 + // 関連商品登録 $objQuery->delete("dtb_recommend_products", "product_id = ?", array($sqlval['product_id'])); for($i = 1; $i <= RECOMMEND_PRODUCT_MAX; $i++) { Index: /branches/comu-ver2/data/class/pages/products/LC_Page_Products_Detail.php =================================================================== --- /branches/comu-ver2/data/class/pages/products/LC_Page_Products_Detail.php (revision 17444) +++ /branches/comu-ver2/data/class/pages/products/LC_Page_Products_Detail.php (revision 17455) @@ -247,5 +247,5 @@ // タイトルに商品名を入れる $this->tpl_title = "商品詳細 ". $this->arrProduct["name"]; - //オススメ商品情報表示 + //関連商品情報表示 $this->arrRecommend = $this->lfPreGetRecommendProducts($tmp_id); //この商品を買った人はこんな商品も買っています @@ -462,5 +462,5 @@ // タイトルに商品名を入れる $this->tpl_title = "商品詳細 ". $this->arrProduct["name"]; - //オススメ商品情報表示 + //関連商品情報表示 $this->arrRecommend = $this->lfPreGetRecommendProducts($tmp_id); //この商品を買った人はこんな商品も買っています @@ -709,5 +709,5 @@ } - /* 登録済みオススメ商品の読み込み */ + /* 登録済み関連商品の読み込み */ function lfPreGetRecommendProducts($product_id) { $arrRecommend = array(); Index: /branches/comu-ver2/data/mtb_constants_init.php =================================================================== --- /branches/comu-ver2/data/mtb_constants_init.php (revision 17444) +++ /branches/comu-ver2/data/mtb_constants_init.php (revision 17455) @@ -122,5 +122,5 @@ /** 会員登録変更(マイページ)パスワード用 */ define('DEFAULT_PASSWORD', "UAhgGR3L"); -/** おすすめ商品数 */ +/** 関連商品数 */ define('RECOMMEND_PRODUCT_MAX', 6); /** 別のお届け先最大登録数 */ @@ -509,5 +509,5 @@ /** 再入会制限時間（単位: 時間) */ define('ENTRY_LIMIT_HOUR', 1); -/** オススメ商品表示数 */ +/** おすすめ商品表示数 */ define('RECOMMEND_NUM', 8); /** ベスト商品の最大登録数 */ Index: /branches/comu-ver2/data/Smarty/templates/default/bloc/best5.tpl =================================================================== --- /branches/comu-ver2/data/Smarty/templates/default/bloc/best5.tpl (revision 17434) +++ /branches/comu-ver2/data/Smarty/templates/default/bloc/best5.tpl (revision 17455) @@ -20,8 +20,8 @@ * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. *}--> - +

- おすすめ情報 + おすすめ商品

@@ -82,3 +82,3 @@
- + Index: /branches/comu-ver2/data/Smarty/templates/default/admin/contents/subnavi.tpl =================================================================== --- /branches/comu-ver2/data/Smarty/templates/default/admin/contents/subnavi.tpl (revision 17423) +++ /branches/comu-ver2/data/Smarty/templates/default/admin/contents/subnavi.tpl (revision 17455) @@ -24,5 +24,5 @@