Free Shipping World Wide -Here's to your health and beauty - Lima Natural Cosmetics Free Shipping World Wide -Here's to your health and beauty - Kaeru series horse oil Free Shipping World Wide -Here's to your health and beauty - Itchnon Free Shipping World Wide -Here's to your health and beauty - Hirara Free Shipping World Wide -Here's to your health and beauty - Roasted brown rice drink -  Genki Youkino MotoFree Shipping World Wide -Here's to your health and beauty -Bio-Normalizer
We exist to help you cherish your loved ones, which we believe will also lead to somebody elses happiness and to our infinite future together.  CEO Message >

About Us

For whom we love, what can we hand down?
For children we love,
what can adults do?

read more

Merchandise Selection-standard

We are applying the following standards in order to select safe, effective, and tasteful food products.

read more

Our Flagship Store

What's New

2024.2.14 [Renewal] Itchnon tablets and oil are renewed
2023.12.7 [New Item] SHINSHUYAKI Ceramics tableware
2020.5.15 [New Item] L-Theanine Sleeping support 90capsules
2019.6.13 [New Item] Organic Japanese Green Juice powder
2018.6.19 [New Item] Bio-normalizer tablet
2018.4.13 [New Item] Genki☆Zen-dama Lactic Acid Bacterium producing supplement
2018.2.2 [New Item] Food supplements>Bio-Normalizer Tablet
2017.6.27 [New Item] Natural & Organic Foods>[Vege Meat] Soy Meat (chips) 90g
2017.6.5 [New Item] Natural & Organic Foods>Unbleached Strip Agar
2017.5.11 [New Item] Natural & Organic Foods>Unconditioned Natural Adzuki Beans
2017.4.11 [New Item] Natural & Organic Foods>Shinshu Miso
2017.3.30 [New Item] Household Goods / Haramaki Belly Band Warmer
2016.11.15 [New Item] Japanese Superfoods / Organic Green Tea (Matcha) Powder
2016.04.09 [New Item] Drink supplements / Anti Aging with Manju No Shizuku
2016.04.08 [New Item] Drink supplements / EM-X GOLD
2016.01.31 [New Item] Sweet rice(brown rice)
2015.12.28 [New Item] Organic Mulberry Leaf Powder powder / Japanese Superfoods
2015.11.10 [New Item] Natural Dashi powder
2015.11.04 [New Item] Prema Shanti Japanese Pickles
2015.10.30 [New Item] Crispy Carob Non-wheat Cookies
2015.10.20 [Campaign] Free shipping! - Adio If / Natural Healing Pendants
2015.08.12 [Campaign] Free shipping! - Eyepathy / Natural Healing Pendants
2015.08.12 [Campaign] Free shipping! - Result / Natural Healing Pendants
2015.08.07 [Campaign] Free shipping! - Cauliflower Mushrooms tablets / Food supplements
2015.07.06 [Campaign] Free shipping! - Bio-Normalizer / Food supplements
2015.07.02 [New Article]Lifestyle habit "Diet" for losing weight in healthy way without rebound
2015.06.17 [New Item] Bulk Buy!-Household Antibacterial Wash "Surfcera" 100g x 3bags (with 150g of bottle & 1g measuring spoons)
2015.05.28 [Campaign] Free shipping! - LIMA NATURAL Skin Care / Cosmetics
2015.04.28 [New Item] Aroma guard mist of Astro Boy
2015.04.27 [New Item] Konbu-cha with kelp roots, Umekonbu-cha
2015.01.30 [New Item] Up to 25%OFF! Dry Shirataki 10bags, 50bags, 150bags
2015.01.05 [Campaign] Free shipping Campaign! - Itchnon -110 tablets
2014.12.16 [New Item] Kaeru Series Horse Oil with Tea tree oil 30ml
2014.12.12 [Campaign] Free shipping Campaign! - Kaeru Series Horse Oil
2014.11.27 [New item] Sarari Surari tea with Chotto Mate!, Natural Silk Belly-warmer Tie ~Eggshell White~ [Ohisama no Nukumori]
2014.11.26 [New item] LIMA NATURAL Dental White 60g
2014.11.19 [New item] Ginger Powder for Drink or Cooking "Ultra Kintoki Ginger"
2014.11.10 [New item] [Prema Shanti] Dry Shirataki
2014.10.24 [New Article]Exercise guide "Diet" for losing weight in healthy way without rebound
2014.10.15 [New item] [Prema Shanti] Sushi Seasoning, Arrowroot Noodle,etc.
2014.10.14 [New item] [Prema Shanti] Veggie Ramen, Freeze-dried Miso Soup
2014.09.25 [New Article]"Diet" for losing weight in healthy way without rebound
2014.09.11 [New item] [Prema Shanti] Organic Cereal Mix, Organic Black Rice, etc.
2014.07.22 [New item] [Itchnon-gamma linolenic acid] Itchnon BCO (skin oil for body), Itchnon AD cream 50g
2014.06.07 [New item] [Prema Shanti] Popular Japanese Rice crackers "Kakinotane"
2014.06.07 [New item] [MUSO Halal] Muslim friendly "Halal food"
2014.05.30 [New item] [Prema Shanti] Brown Rice Cafe, Dark roast Brown Rice Tea
2014.05.21 [New item] [Prema Shanti] Burdock Roots Tea, Dark roast Brown Rice Tea
2014.04.10 [New item] [Prema Shanti] Malt Nougat 4 flavors
2014.03.17 [New item] [Prema Shanti] Kinako,Shiratamako, etc.
2014.02.25 [New item] [Prema Shanti] Inca Inchi Oil
2014.02.25 [New item] [Prema Shanti] Dried Koya Tofu ~Freeze-dried~
2014.02.22 [New item] [Prema Shanti] Unconditioned Natural Navy Beans ~Otebou~
2014.02.22 [New item] [Prema Shanti] Unconditioned Natural Adzuki Beans
2014.02.22 [New item] [Prema Shanti] Unconditioned Natural Black Soy Beans
2014.02.21 [New item] [Prema Shanti] Unconditioned Natural Soy Beans
2014.02.21 [New item] [Prema Shanti] Natural and nutritious black bean glace
2014.01.18 [New item] [Prema Shanti] Millet, Mochi, Udon noodle, etc.
2013.12.19 [New item] Natural Skincare Series - Hirara™
2013.12.10 [New item] [Prema Shanti] Artisan Rice syrup, Throat Smoother
2013.11.22 [New item] [Prema Shanti] UMAMI Broth, Canola Oil
2013.11.11 [New item] [Prema Shanti] Brown Rice, Black Vinegar, etc.
2013.10.09 [New item] [Prema Shanti] Chia Seeds, Organic Pickled Plums, etc.
2013.09.06 [New item] Premium Henna, Amateru-kimi herbal care
2013.09.06 [New item] Carika Celapi Ps501- Papaya Fermented Food
2013.09.05 [New item] [Prema Shanti] Vegetable dressing, Soy sauce, etc.
2013.08.09 [New item] [Prema Shanti] Dried Radish, Somen Noodles, etc.
2013.07.10 [New item] [Prema Shanti] Kudzu Powder, Organic Tea, etc.

[Recommended Items]

*Prices can be converted into your currency on each product page.

SHINSHUYAKI Ceramics Multi spoon

1,019 YEN

Ceramic Chinaspoon large size Good for noodles...

Click here!

Premium Henna Indigo 80g Amateru-kimi herbal care

1,980 YEN

Pure 100% premium indigo, for those people who ...

Click here!

Premium Henna Light Brown 80g Amateru-kimi herbal care

1,880 YEN

This product uses premium-quality henna leaves ...

Click here!

Japanese Kudzu Powder 200g

1,675 YEN

With 450 years of tradition, Kudzu powder is ...

Click here!

Itchnon AD cream 50g

4,180 YEN

“Enough moisture, but it feels dry” Supporting ...

Click here!

Organic Mulberry Leaf Powder (100g)

1,980 YEN

Mulberry leaf is getting attention as food ingr...

Click here!

OrBS Yumemihada Skin Base Water 200ml

3,361 YEN

Makeup powered by purely natural ingredients T...

Click here!

Sarari Surari tea with Chotto Mate!

2,800 YEN

For you who are meat eater, restaurant goer, an...

Click here!

LIMA NATURAL Dental White 60g

2,970 YEN

Whitening, Fresh Breath, Good Oral Hygienewith ...

Click here!

Plum Essence Tablet 450g

9,000 YEN

Enables all family members to benefit from the ...

Click here!

Sesame Seed Oil, KIYORA (Taihaku)

1,100 YEN

Pressed after being roasted ultra-light, it has...

Click here!

Macrobiotics One week trial meal kit

16,740 YEN

Based on the quality standard of Macrobiotics, ...

Click here!
Macrobiotic.. This is a regimen that incorporates such concepts as Zen, Feng-Shui, Yin Yang and Tao. These concepts unify the essence of Japan's spirituality and outlook on the Universe..  The purpose of the Macrobiotic Asia website is to bring together products from Natures bounty as well as processed products and deliver them to the world in the Japanese spirit of harmony.
japanese site Natural Skincare - Hirara Natural Foods - Prema Shanti Prema Original Distributor Wanted - applies world wide Customers' voice FAQ
Become our Fan on Facebook Follow MacrobioticAsia on Twitter
Featured Products Recommended Items
CEO Interview: Fukushima Today Mision Statement The moment @Prema
Prema Inc. Prema Village Kyoto Bldg., 
569 Sannocho, Shimogyo, 
Kyoto 600-8424 JAPAN
// 「言語毎の商品表示・非表示制御」機能がONの時 if (exist_lcs_module("goods_lang_disp", $lcs{'lcs_module_info'}) === TRUE) { // 言語毎の表示条件を追加 $where .= " AND (g.goods_lang_disp_flag = 0 " . " OR EXISTS ( " . " SELECT gl.goods_id FROM tbl_goods_lang gl " . " WHERE gl.lcs_id = g.lcs_id AND gl.goods_id = g.goods_id AND gl.lang_id = ". sqlesc($lang_id, "t") . " AND gl.gola_disp_flag = 1))"; } // モールの時 if ($shop{'lcs_mall_flag'} == "1"){ // メインユーザの商品または、サブユーザでステータスが利用中の商品のみ表示 $where .= " AND (g.mls_id = ". sqlesc(MLS_DEFAULT_ID, "i"). " OR " . " EXISTS (SELECT ml.mls_id " . " FROM tbl_mall_license ml " . " WHERE ml.lcs_id = g.lcs_id AND ml.mls_id = g.mls_id AND ml.mls_status = 1 " . " ) " . " ) "; // サブユーザの使用可言語 $where .= " AND EXISTS ( " . " SELECT mll.lang_id " . " FROM tbl_mall_license_lang mll " . " WHERE mll.lcs_id = g.lcs_id AND mll.mls_id = g.mls_id AND mll.lang_id = ". sqlesc($lang_id, "t") . " ) "; } // YCD機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE) { // YCD対象の配送国の時 if ($obj_ycd->ycd_target_country_flag == "1") { // YCDスクリーニング状態 が スクリーニング完了 // YCD販売対象から除外するフラグ が 未設定 $where .= " AND g.goods_ycd_screening_status = " . sqlesc(cls_ycd::YCD_SCREENING_STATUS_COMPLETE, "i") . " AND g.goods_ycd_nodisp_flag = 0 "; } } // 店舗サブ管理者 承認管理 機能ONの時 if (exist_lcs_module("sblc_approval", $lcs{'lcs_module_info'}) === TRUE) { // 承認ステータスの条件を設定 if (($approval_status_sql = $obj_goods->get_active_goods_sblc_approval_status_sql($lcs_id, 'g')) !== '') { $where .= " AND " . $approval_status_sql; } } //エアリー様対応→廃止 $genre_optv1_code=""; $genre_optv2_code=""; /* if(exist_lcs_module("sku_img_flg", $lcs{'lcs_module_info'}) === TRUE){ // カテゴリ情報 $sql = "SELECT genre_id,genre_optv1_code,genre_optv2_code FROM tbl_genre " . " WHERE lcs_id = ". sqlesc($lcs_id, "t") . " AND genre_id = ". sqlesc($genre_id, "t"); $R = mysql_query($sql); $rows = mysqli_num_rows($R); if ($rows == 1) { $data = mysqli_fetch_array($R, MYSQLI_ASSOC); $genre_optv1_code=$data["genre_optv1_code"]; $genre_optv2_code=$data["genre_optv2_code"]; $smarty->assign("genre_optv1_code",$genre_optv1_code); $smarty->assign("genre_optv2_code", $genre_optv2_code); } } if(exist_lcs_module("sku_img_flg", $lcs{'lcs_module_info'}) === TRUE && $genre_optv1_code!=""){ // 商品SKU 取得 $where .= " AND EXISTS ( " ."SELECT tgs.gosku_thumbnail,tgs.gosku_shop_original_optv2_code " . " FROM tbl_goods_sku tgs" . " WHERE tgs.lcs_id = ". sqlesc($lcs_id, "t") . " AND tgs.goods_id = g.goods_id AND tgs.gosku_shop_original_optv1_code=".sqlesc($genre_optv1_code, "t") . " AND (tgs.gosku_flg1=0 or tgs.gosku_flg1 is null or tgs.gosku_flg1 =2) and gosku_show_flg='1'" .")"; } */ // 並び順の価格項目 $order_by_price_elm = 'goods_price'; // 国内価格 // YCD機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE) { // YCD対象の配送国の時 if ($obj_ycd->ycd_target_country_flag == "1") { $order_by_price_elm = 'goods_cn_ddp_price'; // 中国DDP価格 } } //2018/05/14 商品在庫あり優先判断 $stock_sort_str = ""; if($shop{'shop_goods_stock_sort_flg'}=="1"&&exist_lcs_module("lcs_stock_presence_flg", $lcs{'lcs_module_info'})){ $stock_sort_str = " CASE WHEN g.goods_zaiko_flag = '0' OR ( g.goods_zaiko_flag = '1' and g.goods_zaikosu > 0 AND sku.goods_id IS NULL ) OR ( sku.sku_zaikosu is not null and sku.sku_zaikosu > 0 and sku.goods_id is not null ) THEN '1' ELSE '0' END DESC, "; } if ($sortkey == 1) { $order = " ORDER BY ".$stock_sort_str." g.goods_keisaibi DESC, g.goods_id DESC "; } elseif ($sortkey == 2) { $order = " ORDER BY ".$stock_sort_str." g." . $order_by_price_elm . ", g.goods_id "; } elseif ($sortkey == 3) { $order = " ORDER BY ".$stock_sort_str." g." . $order_by_price_elm . " DESC, g.goods_id "; } elseif ($sortkey == 4) { $order = " ORDER BY ".$stock_sort_str." g.goods_price2, g.goods_id "; } elseif ($sortkey == 5) { $order = " ORDER BY ".$stock_sort_str." g.goods_price2 DESC, g.goods_id "; } else { $order = " ORDER BY ".$stock_sort_str." g.goods_sortno IS NULL ASC, g.goods_sortno ASC, g.goods_keisaibi DESC, g.goods_id DESC "; } // 全データ数取得 $sql = "SELECT count(*) FROM tbl_goods g ". $where; $R = mysql_query($sql); $allrows = mysqli_fetch_array($R, MYSQLI_BOTH);$allrows = $allrows[0]; // 表示データ取得 //$limit = dlookup("htpl_list_limit", "tbl_html_tpl", "lcs_id = ". sqlesc($lcs_id, "t"). " AND htpl_id = ". sqlesc($htpl_id, "i")); if (($html_tpl_info = cls_util::get_html_tpl_info($lcs_id, $htpl_id)) !== false) { $limit = $html_tpl_info{'htpl_list_limit'}; } else { $limit = "10"; } // オフセットを補正 if (isset($offset) === false) { $offset = 0; } $offset = edit_pager_offset($allrows, $offset, $limit); //2018/05/14 商品在庫あり優先判断 $skuJoinStr = ""; if($shop{'shop_goods_stock_sort_flg'}=="1"&&exist_lcs_module("lcs_stock_presence_flg", $lcs{'lcs_module_info'})){ $sku_img_str = ""; if (exist_lcs_module("sku_img_flg", $lcs{'lcs_module_info'}) === TRUE) { $sku_img_str = " AND ( gosku_flg1 != 1 or gosku_flg1 is null ) and gosku_show_flg='1' "; } $skuJoinStr = "left join (select goods_id, Sum(gosku_zaikosu) as sku_zaikosu from tbl_goods_sku WHERE lcs_id = ".sqlesc($lcs_id, "t").$sku_img_str."group by goods_id) sku on sku.goods_id = g.goods_id "; } $sql = "SELECT g.goods_id, g.mls_id, g.brand_id, g.goods_num, g.goods_num2, g.goods_price, g.goods_price2, g.goods_zaiko_flag, g.goods_zaikosu, g.goods_weight, g.goods_min_kosu, g.goods_thumbnail, g.goods_img1, g.goods_img2, g.goods_img3, g.goods_img4, g.goods_img5, g.goods_img6, g.goods_img7, g.goods_img8, g.goods_img9, g.goods_img10, g.goods_embargo, g.goods_nocharge, g.goods_name_print_flag, g.goods_cool_type, g.goods_google_shopping_feed_zaiko_type, g.goods_sale_flag, g.goods_sale_base_price, g.goods_sale_base_price2, g.goods_warehouse_code, g.goods_keisaibi, g.goods_ycd_screening_status, g.goods_ycd_nodisp_flag, g.goods_cn_ddp_price, g.goods_cn_ddp_sale_price, g.goods_cn_ddp_sale_base_price, g.goods_duty_exemption_type, g.goods_free_option_1, g.goods_free_option_2, g.goods_free_option_3, g.goods_free_option_4, g.goods_free_option_5, g.goods_release_date, g.goods_release_date_control_flag, g.sblc_supplier_id, g.sblc_supplier_name, g.goods_eky_capacity FROM tbl_goods g ". $skuJoinStr. $where. $order. " LIMIT ". sqlesc($limit, "i"). " OFFSET ". sqlesc($offset, "i"); // print "sql=[$sql]
\n"; $R = mysql_query($sql); $rows = mysqli_num_rows($R); // ページ送り $smarty->assign("goodslist_allrows", _h($allrows)); $smarty->assign("goodslist_srows", _h($offset + 1)); $smarty->assign("goodslist_erows", _h($offset + $rows)); $url = ""; if($offset > 0){ $prev = $offset - $limit; $url = $_SERVER{'PHP_SELF'}."?lang_id=$lang_id&genre_id=$genre_id&keyword=".urlencode($keyword)."&sch_goods_tag=".urlencode($sch_goods_tag)."&act=$act&sortkey=$sortkey&offset=$prev"; if ($htpl_id_over) $url .= "&htpl_id=$htpl_id"; if ($tsuka_conv) $url .= "&tsuka_conv=$tsuka_conv"; // セール中 商品 if ($sch_goods_sale != "") { $url .= "&sch_goods_sale=$sch_goods_sale"; } } $smarty->assign("goodslist_prev", _h($url)); $url = ""; if(($allrows - $offset + $limit) > 0 && ($offset+$limit) < $allrows){ $next = $offset + $limit; $url = $_SERVER{'PHP_SELF'}."?lang_id=$lang_id&genre_id=$genre_id&keyword=".urlencode($keyword)."&sch_goods_tag=".urlencode($sch_goods_tag)."&act=$act&sortkey=$sortkey&offset=$next"; if ($htpl_id_over) $url .= "&htpl_id=$htpl_id"; if ($tsuka_conv) $url .= "&tsuka_conv=$tsuka_conv"; // セール中 商品 if ($sch_goods_sale != "") { $url .= "&sch_goods_sale=$sch_goods_sale"; } } $smarty->assign("goodslist_next", _h($url)); if ($allrows > 0) { $page_max = 1; } else { $page_max = 0; } // ページリンク $list_page_ary = array(); if ($limit > 0 && $allrows > 0 && $allrows > $limit) { $current_page = intval($offset / $limit) + 1; $page_max = intval($allrows / $limit); if ($allrows > ($page_max * $limit)) { $page_max++; } if ($current_page < 5) { $start_page = 1; if ($page_max > 9) { $end_page = 9; } else { $end_page = $page_max; } } elseif (($page_max - $current_page) < 5) { if ($page_max > 8) { $start_page = $page_max - 8; } else { $start_page = 1; } $end_page = $page_max; } else { $start_page = $current_page - 4; $end_page = $current_page + 4; } $j = 0; for ($i = $start_page; $i <= $end_page; $i++) { $page_offset = ($i * $limit) - $limit; $list_page_ary[$j]{'id'} = _h($j); $list_page_ary[$j]{'name'} = _h($i); $url = $_SERVER{'PHP_SELF'}."?lang_id=$lang_id&genre_id=$genre_id&keyword=".urlencode($keyword)."&sch_goods_tag=".urlencode($sch_goods_tag)."&act=$act&sortkey=$sortkey&offset=$page_offset"; if ($htpl_id_over) $url .= "&htpl_id=$htpl_id"; if ($tsuka_conv) $url .= "&tsuka_conv=$tsuka_conv"; // セール中 商品 if ($sch_goods_sale != "") { $url .= "&sch_goods_sale=$sch_goods_sale"; } $list_page_ary[$j]{'url'} = _h($url); if ($page_offset == $offset) { $list_page_ary[$j]{'current_flag'} = _h("1"); } else { $list_page_ary[$j]{'current_flag'} = _h(""); } $j++; } } $smarty->assign("goodslist_page", $list_page_ary); // 総ページ数 $smarty->assign("goodslist_page_max", $page_max); // 商品配列に設定 $goods_tmp_ary = array(); $goods_id_ary = array(); for ($i = 0; $i < $rows; $i++) { $data = mysqli_fetch_array($R,MYSQLI_ASSOC); $data{'goods_lang'} = array(); // 言語別情報 $data{'goods_sku'} = array(); // SKU $data{'goods_opt'} = array(); // オプション $goods_tmp_ary{$data{'goods_id'}} = $data; $goods_id_ary[] = $data{'goods_id'}; } // 商品言語別情報、SKU情報、オプション情報 取得 if (count($goods_id_ary) > 0) { // 商品ID $where_goods_id_in = ""; reset($goods_id_ary); foreach ($goods_id_ary as $idx => $val) { if ($where_goods_id_in != "") { $where_goods_id_in .= ","; } $where_goods_id_in .= sqlesc($val, "i"); } // 商品言語別情報 取得 $sql = "SELECT * FROM tbl_goods_lang " . " WHERE lcs_id = ". sqlesc($lcs_id, "t") . " AND goods_id IN(". $where_goods_id_in . ")" . " AND lang_id = ". sqlesc($lang_id, "t"); $R = mysql_query($sql); $rows = mysqli_num_rows($R); if ($rows > 0) { for ($i = 0; $i < $rows; $i++) { $data = mysqli_fetch_array($R,MYSQLI_ASSOC); $goods_tmp_ary{$data{'goods_id'}}{'goods_lang'} = $data; } } // 商品SKU 取得 $sql = "SELECT * " . " FROM tbl_goods_sku " . " WHERE lcs_id = ". sqlesc($lcs_id, "t") . " AND goods_id IN(". $where_goods_id_in . ") " . " ORDER BY goods_id, gosku_id"; $R = mysql_query($sql); $rows = mysqli_num_rows($R); if ($rows > 0) { for ($i = 0; $i < $rows; $i++) { $data = mysqli_fetch_array($R,MYSQLI_ASSOC); $goods_tmp_ary{$data{'goods_id'}}{'goods_sku'}{$data{'gosku_id'}} = $data; } } // 商品オプション 取得 $sql = "SELECT goods_id, goopt_id, goopt_opt_name " . " FROM tbl_goods_opt " . " WHERE lcs_id = ". sqlesc($lcs_id, "t") . " AND goods_id IN(". $where_goods_id_in . ")" . " AND lang_id = ". sqlesc($lang_id, "t") . " ORDER BY goods_id, goopt_id"; $R = mysql_query($sql); $rows = mysqli_num_rows($R); if ($rows > 0) { for ($i = 0; $i < $rows; $i++) { $data = mysqli_fetch_array($R,MYSQLI_ASSOC); $data{'goods_optval'} = array(); $goods_tmp_ary{$data{'goods_id'}}{'goods_opt'}{$data{'goopt_id'}} = $data; } } // 商品オプション値 取得 $sql = "SELECT goods_id, goopt_id, gooptv_id, gooptv_opt_value " . " FROM tbl_goods_optval " . " WHERE lcs_id = ". sqlesc($lcs_id, "t") . " AND goods_id IN(". $where_goods_id_in . ")" . " AND lang_id = ". sqlesc($lang_id, "t") . " ORDER BY goods_id, goopt_id, gooptv_id"; $R = mysql_query($sql); $rows = mysqli_num_rows($R); if ($rows > 0) { for ($i = 0; $i < $rows; $i++) { $data = mysqli_fetch_array($R,MYSQLI_ASSOC); if (isset($goods_tmp_ary{$data{'goods_id'}}{'goods_opt'}{$data{'goopt_id'}}) !== false) { $goods_tmp_ary{$data{'goods_id'}}{'goods_opt'}{$data{'goopt_id'}}{'goods_optval'}{$data{'gooptv_id'}} = $data; } } } } // 商品表示 $goods_ary = array(); $i = 0; reset($goods_tmp_ary); foreach ($goods_tmp_ary as $key => $val) { $data = $val; // 言語別情報 if (count($data{'goods_lang'}) > 0) { $data2 = $data{'goods_lang'}; } else { $data2{'gola_goods_name'} = ''; $data2{'gola_goods_copy'} = ''; $data2{'gola_setsumei'} = ''; $data2{'gola_freearea1'} = ''; $data2{'gola_freearea2'} = ''; $data2{'gola_freearea3'} = ''; $data2{'gola_freearea4'} = ''; $data2{'gola_freearea5'} = ''; $data2{'gola_tani'} = ''; } // 商品詳細ページURL(商品ID 指定) $url = "goods.php?lang_id=$lang_id&goods_id=".$data{'goods_id'}."&tsuka_conv=$tsuka_conv"; if ($htpl_id_over) $url .= "&htpl_id=$htpl_id"; $goods_ary[$i]{'url'} = _h($url); // 商品詳細ページURL(商品番号 指定 : URLフィルター用パラメータ値変換) $url = "goods.php?lang_id=$lang_id&goods_num=" . mlc_urlencode(encode_url_filter_param($data{'goods_num'})) . "&tsuka_conv=$tsuka_conv"; if ($htpl_id_over) $url .= "&htpl_id=$htpl_id"; $goods_ary[$i]{'url_gonum'} = _h($url); // 手数料適用対象外 $goods_ary[$i]{'nocharge'} = _h($data{'goods_nocharge'}); // 商品ID $goods_ary[$i]{'id'} = _h($data{'goods_id'}); // カートに入っているフラグ $cart_in_flag = ""; // カートCookie 存在する場合 if (isset($_SESSION{'CART_'.$lcs_id})) { // カートCookieの中に 商品IDがあるかチェック $cart_ary = explode(",", $_SESSION{'CART_'.$lcs_id}); foreach($cart_ary as $value) { list($cart_goods_id, $cart_kosu, $cart_goods_opt) = explode("|", $value); if ($cart_goods_id == $data{'goods_id'}){ $cart_in_flag = 1; } } } $goods_ary[$i]{'cart_in_flag'} = _h($cart_in_flag); // 商品番号 $goods_ary[$i]{'num'} = _h($data{'goods_num'}); // 商品番号2 $goods_ary[$i]{'num2'} = _h($data{'goods_num2'}); // 商品名 $goods_ary[$i]{'name'} = _h($data2{'gola_goods_name'}); // タイムスタンプ if ($data{'goods_keisaibi'} != "") { $goods_ary[$i]{'keisaibi'} = _h(date("Y/m/d H:i:s", strtotime($data{'goods_keisaibi'}))); } else { $goods_ary[$i]{'keisaibi'} = _h(""); } // 発売開始日時制御フラグ $goods_ary[$i]{'goods_release_date_control_flag'} = _h($data{'goods_release_date_control_flag'}); // 発売開始日時 if ($data{'goods_release_date'} != "") { $goods_ary[$i]{'goods_release_date'} = _h(date("Y/m/d H:i:s", strtotime($data{'goods_release_date'}))); } else { $goods_ary[$i]{'goods_release_date'} = _h(""); } // 単語のスペース区切りフラグ設定時 if ($lang_word_space_delimiter_flag == 1) { $conv_br_delimiter = " "; } else { $conv_br_delimiter = ""; } // 商品コピー $goods_ary[$i]{'goods_copy'} = _h(str_replace(array("\r", "\n"), $conv_br_delimiter, strip_tags($data2{'gola_goods_copy'}))); // 商品コピー(タグ削除なし) $goods_ary[$i]{'goods_copy_raw'} = mlc_nl2br($data2{'gola_goods_copy'}); // 商品説明 $goods_ary[$i]{'setsumei'} = _h(str_replace(array("\r", "\n"), $conv_br_delimiter, strip_tags($data2{'gola_setsumei'}))); // 商品説明(タグ削除なし) $goods_ary[$i]{'setsumei_raw'} = mlc_nl2br($data2{'gola_setsumei'}); // 商品自由設定項目 $goods_ary[$i]{'freearea1'} = _h(str_replace(array("\r", "\n"), $conv_br_delimiter, strip_tags($data2{'gola_freearea1'}))); $goods_ary[$i]{'freearea2'} = _h(str_replace(array("\r", "\n"), $conv_br_delimiter, strip_tags($data2{'gola_freearea2'}))); $goods_ary[$i]{'freearea3'} = _h(str_replace(array("\r", "\n"), $conv_br_delimiter, strip_tags($data2{'gola_freearea3'}))); $goods_ary[$i]{'freearea4'} = _h(str_replace(array("\r", "\n"), $conv_br_delimiter, strip_tags($data2{'gola_freearea4'}))); $goods_ary[$i]{'freearea5'} = _h(str_replace(array("\r", "\n"), $conv_br_delimiter, strip_tags($data2{'gola_freearea5'}))); // 商品自由設定項目(タグ削除なし) $goods_ary[$i]{'freearea1_raw'} = mlc_nl2br($data2{'gola_freearea1'}); $goods_ary[$i]{'freearea2_raw'} = mlc_nl2br($data2{'gola_freearea2'}); $goods_ary[$i]{'freearea3_raw'} = mlc_nl2br($data2{'gola_freearea3'}); $goods_ary[$i]{'freearea4_raw'} = mlc_nl2br($data2{'gola_freearea4'}); $goods_ary[$i]{'freearea5_raw'} = mlc_nl2br($data2{'gola_freearea5'}); // 日本国内価格 $goods_ary[$i]{'price'} = _h(number_format($data{'goods_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // 日本国内価格(桁区切りなし) $goods_ary[$i]{'price_nonbreaking'} = _h($data{'goods_price'}); // 日本国外価格 $goods_ary[$i]{'price2'} = _h(number_format($data{'goods_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // 日本国外価格(桁区切りなし) $goods_ary[$i]{'price2_nonbreaking'} = _h($data{'goods_price2'}); // YCD機能ONの時 // EKKYO.NET 機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE || exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // YCD機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE) { // YCD販売対象から除外するフラグ が設定されている時 if ($data{'goods_ycd_nodisp_flag'} == "1") { // YCDスクリーニング状態 $goods_ary[$i]{'goods_ycd_screening_status'} = _h(cls_ycd::YCD_SCREENING_STATUS_NG); // YCD販売対象外 } else { // YCDスクリーニング状態 $goods_ary[$i]{'goods_ycd_screening_status'} = _h($data{'goods_ycd_screening_status'}); } } // 中国DDP価格 $goods_ary[$i]{'cn_ddp_price'} = _h($obj_ycd->calc_price($lcs_id, $data{'goods_cn_ddp_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000, "format")); // 中国DDP価格(桁区切りなし) $goods_ary[$i]{'cn_ddp_price_nonbreaking'} = _h($data{'goods_cn_ddp_price'}); // 関税および立替手数料(=中国DDP価格 - FOB価格) $goods_ary[$i]{'cn_ddp_customs_duty'} = _h($obj_ycd->calc_customs_duty($lcs_id, $data{'goods_cn_ddp_price'}, $data{'goods_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000, "format")); // 関税および立替手数料(=中国DDP価格 - FOB価格)(桁区切りなし) $goods_ary[$i]{'cn_ddp_customs_duty_nonbreaking'} = _h($obj_ycd->calc_customs_duty($lcs_id, $data{'goods_cn_ddp_price'}, $data{'goods_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000, "")); // ※YCD使用店舗 (EKKYO.NET機能ON店舗も同様) は // クーポン割引(割引率)、 // ボリュームディスカウント割引、 // 有料会員割引(プレミアム会員機能)が使用不可。 // (システムでは制限せずに、店舗が使用しない運用) } // プレミアム会員機能ONの時 if (exist_lcs_module("premium_membership", $lcs{'lcs_module_info'}) === TRUE) { $ary_membership_price = array(); // 会員種別毎の商品価格 -> 値引き価格を取得 $params = array(); $params{'lcs_id'} = $lcs_id; $params{'lang_id'} = $lang_id; $params{'goods_id'} = $data{'goods_id'}; $params{'goods_price'} = $data{'goods_price'}; // 商品 国内価格 $params{'goods_price2'} = $data{'goods_price2'}; // 商品 国外価格 $params{'goods_sale_base_price'} = $data{'goods_sale_base_price'}; // 商品 セール前 国内価格 $params{'goods_sale_base_price2'} = $data{'goods_sale_base_price2'}; // 商品 セール前 国外価格 $params{'tsuka_decimal'} = $tsuka_decimal; $cache_not_use_flag = ""; // 公開側のトップ~商品詳細はキャッシュを使用する(カート投入前) if (($result = $obj_mdl_premium_membership->calc_goods_premium_membership_waribiki_price($params, $cache_not_use_flag)) !== false) { $ary_membership_price = $result; reset($ary_membership_price); foreach ($ary_membership_price as $membership_price_key => $membership_price_val) { // 会員権割引 商品 国内価格 $goods_ary[$i]{'membership_price_' . $membership_price_key} = _h(number_format($membership_price_val{'membership_goods_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // 会員権割引 商品 国内価格(桁区切りなし) $goods_ary[$i]{'membership_price_nonbreaking_' . $membership_price_key} = _h($membership_price_val{'membership_goods_price'}); // 会員権割引 商品 国外価格 $goods_ary[$i]{'membership_price2_' . $membership_price_key} = _h(number_format($membership_price_val{'membership_goods_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // 会員権割引 商品 国外価格(桁区切りなし) $goods_ary[$i]{'membership_price2_nonbreaking_' . $membership_price_key} = _h($membership_price_val{'membership_goods_price2'}); // 会員権割引 商品 セール前 国内価格 $goods_ary[$i]{'membership_sale_base_price_' . $membership_price_key} = _h(number_format($membership_price_val{'membership_goods_sale_base_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // 会員権割引 商品 セール前 国外価格 $goods_ary[$i]{'membership_sale_base_price2_' . $membership_price_key} = _h(number_format($membership_price_val{'membership_goods_sale_base_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); } } } // 在庫管理有無フラグ $goods_ary[$i]{'zaiko_flag'} = _h($data{'goods_zaiko_flag'}); // 在庫数 $goods_ary[$i]{'zaikosu'} = _h($data{'goods_zaikosu'}); // 重量 $goods_ary[$i]{'weight'} = _h($data{'goods_weight'}); // 最低注文数 $goods_ary[$i]{'min_kosu'} = _h($data{'goods_min_kosu'}); // 注文の単位 $goods_ary[$i]{'tani'} = _h($data2{'gola_tani'}); // 倉庫コード $goods_ary[$i]{'goods_warehouse_code'} = _h($data{'goods_warehouse_code'}); // 名入れ商品フラグ $goods_ary[$i]{'goods_name_print_flag'} = _h($data{'goods_name_print_flag'}); // 冷凍冷蔵フラグ(0 : 一般、1 : 冷凍、 2 : 冷蔵) $goods_ary[$i]{'cool_flag'} = _h($data{'goods_cool_type'}); // if ($goods_ary[$i]{'cool_flag'} > 0) { // if ($goods_ary[$i]{'cool_flag'} == 1) { // // 冷凍 // $goods_ary[$i]{'cool_type'} = "frozen"; // } else if ($goods_ary[$i]{'cool_flag'} == 2) { // // 冷蔵 // $goods_ary[$i]{'cool_type'} = "chilled"; // } // } $goods_ary[$i]{'cool_type'} = _h(cls_util::get_goods_cool_type_title($data{'goods_cool_type'})); // サムネイル $goods_ary[$i]{'thumbnail'} = _h(($data{'goods_thumbnail'}=="")?"":$goimg_url.$data{'goods_thumbnail'}); $goods_ary[$i]{'img1'} = _h(($data{'goods_img1'}=="")?"":$goimg_url.$data{'goods_img1'}); $goods_ary[$i]{'img2'} = _h(($data{'goods_img2'}=="")?"":$goimg_url.$data{'goods_img2'}); $goods_ary[$i]{'img3'} = _h(($data{'goods_img3'}=="")?"":$goimg_url.$data{'goods_img3'}); $goods_ary[$i]{'img4'} = _h(($data{'goods_img4'}=="")?"":$goimg_url.$data{'goods_img4'}); $goods_ary[$i]{'img5'} = _h(($data{'goods_img5'}=="")?"":$goimg_url.$data{'goods_img5'}); $goods_ary[$i]{'img6'} = _h(($data{'goods_img6'}=="")?"":$goimg_url.$data{'goods_img6'}); $goods_ary[$i]{'img7'} = _h(($data{'goods_img7'}=="")?"":$goimg_url.$data{'goods_img7'}); $goods_ary[$i]{'img8'} = _h(($data{'goods_img8'}=="")?"":$goimg_url.$data{'goods_img8'}); $goods_ary[$i]{'img9'} = _h(($data{'goods_img9'}=="")?"":$goimg_url.$data{'goods_img9'}); $goods_ary[$i]{'img10'} = _h(($data{'goods_img10'}=="")?"":$goimg_url.$data{'goods_img10'}); // 国外配送の制限 $goods_ary[$i]{'embargo'} = _h($data{'goods_embargo'}); // 店舗の基準通貨が「通貨選択」または「店舗の優先順位一位の通貨」と異なる時 if($tsuka_conv != $shop{'tsuka_id'} || $shop_first_tsuka_id != $shop{'tsuka_id'}){ // 通貨変換 $price_conv = round_price_conv($data{'goods_price'} * $rate, $tsuka_conv_decimal); $goods_ary[$i]{'price_conv'} = _h(get_shop_tsuka_approximate_symbol($lcs_id, $lang_id) . $price_conv . " " . $tsuka_unit); $price2_conv = round_price_conv($data{'goods_price2'} * $rate, $tsuka_conv_decimal); $goods_ary[$i]{'price2_conv'} = _h(get_shop_tsuka_approximate_symbol($lcs_id, $lang_id) . $price2_conv . " " . $tsuka_unit); // YCD機能ONの時 // EKKYO.NET 機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE || exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 通貨変換 $goods_ary[$i]{'cn_ddp_price_conv'} = _h($obj_ycd->calc_price_conv($lcs_id, $data{'goods_cn_ddp_price'}, $rate, $tsuka_conv_decimal, $lang_id, $tsuka_unit)); // 関税および立替手数料(=中国DDP価格 - FOB価格) 通貨変換 $goods_ary[$i]{'cn_ddp_customs_duty_conv'} = _h($obj_ycd->calc_customs_duty_conv($lcs_id, $data{'goods_cn_ddp_price'}, $data{'goods_price2'}, $rate, $tsuka_conv_decimal, $lang_id, $tsuka_unit)); } // プレミアム会員機能ONの時 if (exist_lcs_module("premium_membership", $lcs{'lcs_module_info'}) === TRUE) { reset($ary_membership_price); foreach ($ary_membership_price as $membership_price_key => $membership_price_val) { // 会員権割引 商品 国内価格 通貨変換 $membership_price_conv = round_price_conv($membership_price_val{'membership_goods_price'} * $rate, $tsuka_conv_decimal); $goods_ary[$i]{'membership_price_conv_' . $membership_price_key} = _h(get_shop_tsuka_approximate_symbol($lcs_id, $lang_id) . $membership_price_conv . " " . $tsuka_unit); // 会員権割引 商品 国外価格 通貨変換 $membership_price2_conv = round_price_conv($membership_price_val{'membership_goods_price2'} * $rate, $tsuka_conv_decimal); $goods_ary[$i]{'membership_price2_conv_' . $membership_price_key} = _h(get_shop_tsuka_approximate_symbol($lcs_id, $lang_id) . $membership_price2_conv . " " . $tsuka_unit); } } } // ブランド $goods_ary[$i]{'brand_name'} = ""; // モールの時 if ($shop{'lcs_mall_flag'} == "1"){ if ($data{'brand_id'} != 0){ // ブランド名を取得 // $goods_ary[$i]{'brand_name'} = dlookup("mall_shopla_brand_title". $data{'brand_id'}, "tbl_mall_shop_lang", "lcs_id = ". sqlesc($lcs_id, "t"). " AND mls_id = ". sqlesc($data{'mls_id'}, "i"). " AND lang_id = ". sqlesc($lang_id, "t")); if (($mall_shop_lang_info = cls_util::get_mall_shop_lang_info($lcs_id, $data{'mls_id'}, $lang_id)) !== false) { $goods_ary[$i]{'brand_name'} = $mall_shop_lang_info{'mall_shopla_brand_title'. $data{'brand_id'}}; } else { $goods_ary[$i]{'brand_name'} = ""; } } } // セールフラグ $goods_ary[$i]{'goods_sale_flag'} = _h($data{'goods_sale_flag'}); // セール前価格(国内) $goods_ary[$i]{'goods_sale_base_price'} = _h(number_format($data{'goods_sale_base_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // セール前価格(国外) $goods_ary[$i]{'goods_sale_base_price2'} = _h(number_format($data{'goods_sale_base_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // YCD機能ONの時 // EKKYO.NET 機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE || exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 中国DDP セール前価格 $goods_ary[$i]{'goods_cn_ddp_sale_base_price'} = _h($obj_ycd->calc_price($lcs_id, $data{'goods_cn_ddp_sale_base_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000, "format")); } // 免税区分 $goods_ary[$i]{'goods_duty_exemption_type'} = _h($data{'goods_duty_exemption_type'}); // 商品自由管理項目1~5 for ($idx = 1; $idx <= $CN_GOODS_OP_MAX; $idx++) { $goods_ary[$i]{'goods_free_option_' . $idx} = _h($data{'goods_free_option_' . $idx}); } // 店舗サブ管理者 承認管理 機能ONの時 if (exist_lcs_module("sblc_approval", $lcs{'lcs_module_info'}) === TRUE) { $goods_ary[$i]{'sblc_supplier_id'} = _h($data{'sblc_supplier_id'}); $goods_ary[$i]{'sblc_supplier_name'} = _h($data{'sblc_supplier_name'}); } // EKKYO.NET 機能ONの時 if (exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 容積値 $goods_ary[$i]{'eky_capacity'} = _h($data{'goods_eky_capacity'}); } // カートフォームhidden $tmp = ""; if (strstr($lcs{'lcs_sslurl'}, $CN_SSL_DOMAIN)) { $tmp .= "\n"; } $tmp .= "\n"; $tmp .= "\n"; if ($htpl_id_over) $tmp .= "\n"; // EKKYO.NET 機能ONの時 if (exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // トークン $tmp .= "\n"; $tmp .= "\n"; } $goods_ary[$i]{'cart_hidden'} = $tmp; $sku_goods_key = $lcs_id . '_' . $data{'goods_id'}; // 店舗ID+商品ID $goods_ary[$i]{'sku_goods_key'} = _h($sku_goods_key); $goods_ary[$i]{'sku_goods_opt1'} = _h(""); $goods_ary[$i]{'sku_goods_opt2'} = _h(""); $sku_hidden = ""; $goods_ary[$i]{'sku_flag'} = ""; // SKU管理有無の判定用 $goods_sku_ary = array(); // SKUの在庫数 合計 $goods_ary[$i]{'sku_zaikosu_total'} = 0; // 出力用 商品SKU $ary_temp_out_sku = array(); // SKU if (count($data{'goods_sku'}) > 0) { $goods_ary[$i]{'sku_flag'} = "1"; reset($data{'goods_sku'}); foreach ($data{'goods_sku'} as $sub_key => $sub_val) { $data3 = $sub_val; $goods_ary[$i]{'sku_zaikosu_total'} += $data3{'gosku_zaikosu'}; $gosku_id = $data3{'gosku_id'}; $goods_sku_ary[$gosku_id] = $data3; // 価格、在庫表示変更用にデリミタを変更 $w_sku_key = $data3{'gosku_id'}; $w_sku_key = str_replace(SKU_OPT_DELIMITER, "-", $w_sku_key); $w_sku_key = str_replace(SKU_OPTVAL_DELIMITER, ":", $w_sku_key); // プレミアム会員機能ONの時 if (exist_lcs_module("premium_membership", $lcs{'lcs_module_info'}) === TRUE) { $temp_out_membership_sku = array(); $ary_membership_sku_price = array(); // 会員種別毎の商品価格 -> 値引き価格を取得 $params = array(); $params{'lcs_id'} = $lcs_id; $params{'lang_id'} = $lang_id; $params{'goods_id'} = $data{'goods_id'}; $params{'goods_price'} = $data3{'gosku_price'}; // 商品SKU 国内価格 $params{'goods_price2'} = $data3{'gosku_price2'}; // 商品SKU 国外価格 $params{'goods_sale_base_price'} = $data3{'gosku_sale_base_price'}; // 商品SKU セール前 国内価格 $params{'goods_sale_base_price2'} = $data3{'gosku_sale_base_price2'}; // 商品SKU セール前 国外価格 $params{'tsuka_decimal'} = $tsuka_decimal; $cache_not_use_flag = ""; // 公開側のトップ~商品詳細はキャッシュを使用する(カート投入前) if (($result = $obj_mdl_premium_membership->calc_goods_premium_membership_waribiki_price($params, $cache_not_use_flag)) !== false) { $ary_membership_sku_price = $result; reset($ary_membership_sku_price); foreach ($ary_membership_sku_price as $membership_price_key => $membership_price_val) { // 会員権割引 商品SKU 国内価格 $temp_out_membership_sku{'membership_price_' . $membership_price_key} = _h(number_format($membership_price_val{'membership_goods_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // 会員権割引 商品SKU 国内価格(桁区切りなし) $temp_out_membership_sku{'membership_price_nonbreaking_' . $membership_price_key} = _h($membership_price_val{'membership_goods_price'}); // 会員権割引 商品SKU 国外価格 $temp_out_membership_sku{'membership_price2_' . $membership_price_key} = _h(number_format($membership_price_val{'membership_goods_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // 会員権割引 商品SKU 国外価格(桁区切りなし) $temp_out_membership_sku{'membership_price2_nonbreaking_' . $membership_price_key} = _h($membership_price_val{'membership_goods_price2'}); // 会員権割引 商品 セール前 国内価格 $temp_out_membership_sku{'membership_sale_base_price_' . $membership_price_key} = _h(number_format($membership_price_val{'membership_goods_sale_base_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // 会員権割引 商品 セール前 国外価格 $temp_out_membership_sku{'membership_sale_base_price2_' . $membership_price_key} = _h(number_format($membership_price_val{'membership_goods_sale_base_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); } } } // 日本国内価格 $price = number_format($data3{'gosku_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000); // 日本国外価格 $price2 = number_format($data3{'gosku_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000); // YCD機能ONの時 // EKKYO.NET 機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE || exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 中国向けDDP価格 $gosku_cn_ddp_price = $obj_ycd->calc_price($lcs_id, $data3{'gosku_cn_ddp_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000, "format"); // 関税および立替手数料(=中国DDP価格 - FOB価格) $gosku_cn_ddp_customs_duty = $obj_ycd->calc_customs_duty($lcs_id, $data3{'gosku_cn_ddp_price'}, $data3{'gosku_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000, "format"); } // 店舗の基準通貨が「通貨選択」または「店舗の優先順位一位の通貨」と異なる時 if($tsuka_conv != $shop{'tsuka_id'} || $shop_first_tsuka_id != $shop{'tsuka_id'}){ // 通貨変換 $price_conv = round_price_conv($data3{'gosku_price'} * $rate, $tsuka_conv_decimal); $price_conv = get_shop_tsuka_approximate_symbol($lcs_id, $lang_id) . $price_conv . " " . $tsuka_unit; $price2_conv = round_price_conv($data3{'gosku_price2'} * $rate, $tsuka_conv_decimal); $price2_conv = get_shop_tsuka_approximate_symbol($lcs_id, $lang_id) . $price2_conv . " " . $tsuka_unit; // YCD機能ONの時 // EKKYO.NET 機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE || exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 通貨変換 $gosku_cn_ddp_price_conv = $obj_ycd->calc_price_conv($lcs_id, $data3{'gosku_cn_ddp_price'}, $rate, $tsuka_conv_decimal, $lang_id, $tsuka_unit); // 関税および立替手数料(=中国DDP価格 - FOB価格) 通貨変換 $gosku_cn_ddp_customs_duty_conv = $obj_ycd->calc_customs_duty_conv($lcs_id, $data3{'gosku_cn_ddp_price'}, $data3{'gosku_price2'}, $rate, $tsuka_conv_decimal, $lang_id, $tsuka_unit); } // プレミアム会員機能ONの時 if (exist_lcs_module("premium_membership", $lcs{'lcs_module_info'}) === TRUE) { reset($ary_membership_sku_price); foreach ($ary_membership_sku_price as $membership_price_key => $membership_price_val) { // 会員権割引 商品 国内価格 通貨変換 $membership_price_conv = round_price_conv($membership_price_val{'membership_goods_price'} * $rate, $tsuka_conv_decimal); $temp_out_membership_sku{'membership_price_conv_' . $membership_price_key} = _h(get_shop_tsuka_approximate_symbol($lcs_id, $lang_id) . $membership_price_conv . " " . $tsuka_unit); // 会員権割引 商品 国外価格 通貨変換 $membership_price2_conv = round_price_conv($membership_price_val{'membership_goods_price2'} * $rate, $tsuka_conv_decimal); $temp_out_membership_sku{'membership_price2_conv_' . $membership_price_key} = _h(get_shop_tsuka_approximate_symbol($lcs_id, $lang_id) . $membership_price2_conv . " " . $tsuka_unit); } } } // セール前価格(国内) $gosku_sale_base_price = number_format($data3{'gosku_sale_base_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000); // セール前価格(国外) $gosku_sale_base_price2 = number_format($data3{'gosku_sale_base_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000); // YCD機能ONの時 // EKKYO.NET 機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE || exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 中国向けDDP セール前価格 $gosku_cn_ddp_sale_base_price = $obj_ycd->calc_price($lcs_id, $data3{'gosku_cn_ddp_sale_base_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000, "format"); } $sku_z_key = $sku_goods_key . "_" . $w_sku_key; $sku_hidden .= "\n"; $sku_hidden .= "\n"; $sku_hidden .= "\n"; $sku_hidden .= "\n"; $sku_hidden .= "\n"; $sku_hidden .= "\n"; $sku_hidden .= "\n"; $sku_hidden .= "\n"; $sku_hidden .= "\n"; // YCD機能ONの時 // EKKYO.NET 機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE || exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { $sku_hidden .= "\n"; $sku_hidden .= "\n"; $sku_hidden .= "\n"; $sku_hidden .= "\n"; $sku_hidden .= "\n"; } // EKKYO.NET 機能ONの時 if (exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 容積値 $sku_hidden .= "\n"; } // プレミアム会員機能ONの時 if (exist_lcs_module("premium_membership", $lcs{'lcs_module_info'}) === TRUE) { reset($temp_out_membership_sku); foreach ($temp_out_membership_sku as $membership_price_elm_key => $membership_price_elm_val) { // 会員権割引 項目をhiddenに設定 $sku_hidden .= "\n"; } } // 出力用 商品SKU $temp_out_sku = array(); // 商品SKUのhiddenキー $temp_out_sku{'sku_hidden_key'} = _h($sku_z_key); // 商品オプション1 ID $temp_out_sku{'opt1_id'} = _h($data3{'goopt1_id'}); // 商品オプション値1 ID $temp_out_sku{'optv1_id'} = _h($data3{'gooptv1_id'}); // 商品オプション2 ID $temp_out_sku{'opt2_id'} = _h($data3{'goopt2_id'}); // 商品オプション値2 ID $temp_out_sku{'optv2_id'} = _h($data3{'gooptv2_id'}); // 重量 $temp_out_sku{'weight'} = _h($data3{'gosku_weight'}); // 在庫数 $temp_out_sku{'zaikosu'} = _h($data3{'gosku_zaikosu'}); // 国内価格 $temp_out_sku{'price'} = _h($price); // 国外価格 $temp_out_sku{'price2'} = _h($price2); // 国内価格(近似値) $temp_out_sku{'price_conv'} = _h($price_conv); // 国外価格(近似値) $temp_out_sku{'price2_conv'} = _h($price2_conv); // セール前 国内価格 $temp_out_sku{'sale_base_price'} = _h($gosku_sale_base_price); // セール前 国外価格 $temp_out_sku{'sale_base_price2'} = _h($gosku_sale_base_price2); // YCD機能ONの時 // EKKYO.NET 機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE || exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 中国向けDDP価格 $temp_out_sku{'cn_ddp_price'} = _h($gosku_cn_ddp_price); // 中国向けDDP価格(近似値) $temp_out_sku{'cn_ddp_price_conv'} = _h($gosku_cn_ddp_price_conv); // 関税および立替手数料(=中国DDP価格 - FOB価格) $temp_out_sku{'cn_ddp_customs_duty'} = _h($gosku_cn_ddp_customs_duty); // 関税および立替手数料(=中国DDP価格 - FOB価格)(近似値) $temp_out_sku{'cn_ddp_customs_duty_conv'} = _h($gosku_cn_ddp_customs_duty_conv); // 中国向けDDP セール前価格 $temp_out_sku{'cn_ddp_sale_base_price'} = _h($gosku_cn_ddp_sale_base_price); } // プレミアム会員機能ONの時 if (exist_lcs_module("premium_membership", $lcs{'lcs_module_info'}) === TRUE) { reset($temp_out_membership_sku); foreach ($temp_out_membership_sku as $membership_price_elm_key => $membership_price_elm_val) { // 会員権割引 項目をSKU出力項目に設定 $temp_out_sku{$membership_price_elm_key} = _h($membership_price_elm_val); $goods_sku_ary[$gosku_id]{'premium_membership'}{$membership_price_elm_key} = $membership_price_elm_val; } } // EKKYO.NET 機能ONの時 if (exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 容積値 $temp_out_sku{'eky_capacity'} = _h($data3{'gosku_eky_capacity'}); } $ary_temp_out_sku[] = $temp_out_sku; } } $goods_ary[$i]{'cart_hidden'} .= $sku_hidden; // 商品SKU 配列 $goods_ary[$i]{'sku'} = $ary_temp_out_sku; // Google shopping feed用 在庫タイプ $goods_ary[$i]{'goods_google_shopping_feed_zaiko_type'} = _h($data{'goods_google_shopping_feed_zaiko_type'}); $goods_ary[$i]{'zaiko_type_title'} = ""; // Google shopping feed用 在庫タイプ 名称 if ($goods_ary[$i]{'goods_google_shopping_feed_zaiko_type'} == 0) { // 在庫有り $goods_ary[$i]{'zaiko_type_title'} = "in stock"; if ($goods_ary[$i]{'zaiko_flag'} == 1) { if ($goods_ary[$i]{'sku_flag'} == 1) { if ($goods_ary[$i]{'sku_zaikosu_total'} <= 0) { // 在庫無し $goods_ary[$i]{'zaiko_type_title'} = "out of stock"; } } else { if ($goods_ary[$i]{'zaikosu'} <= 0) { // 在庫無し $goods_ary[$i]{'zaiko_type_title'} = "out of stock"; } } } } elseif ($goods_ary[$i]{'goods_google_shopping_feed_zaiko_type'} == 1) { // 取り寄せ $goods_ary[$i]{'zaiko_type_title'} = "available for order"; } elseif ($goods_ary[$i]{'goods_google_shopping_feed_zaiko_type'} == 2) { // 予約 $goods_ary[$i]{'zaiko_type_title'} = "preorder"; } // 商品オプション if (count($data{'goods_opt'}) > 0) { $j = 0; reset($data{'goods_opt'}); foreach ($data{'goods_opt'} as $sub_key => $sub_val) { $data3 = $sub_val; $goods_ary[$i]{'opt'}[$j]{'name'} = _h($data3{'goopt_opt_name'}); $goods_ary[$i]{'opt'}[$j]{'goopt_id'} = _h($data3{'goopt_id'}); // 選択状態にする選択肢 $goods_ary[$i]{'opt'}[$j]{'selected_gooptv_id'} = _h(""); // SKUのプルダウンで在庫チェック用 $opt_idx = $j + 1; $goods_ary[$i]{'opt'}[$j]{'sku_opt_key'} = _h($sku_goods_key . "_opt" . $opt_idx); $goods_ary[$i]{'sku_goods_opt' . $opt_idx} = _h($sku_goods_key . "_opt" . $opt_idx); if (count($sub_val{'goods_optval'}) > 0) { reset($sub_val{'goods_optval'}); foreach ($sub_val{'goods_optval'} as $sub_optval_key => $sub_optval_val) { $data4 = $sub_optval_val; $goods_ary[$i]{'optv'}[$j]{'id'}[] = _h($data3{'goopt_id'}.":".$data4{'gooptv_id'}); $goods_ary[$i]{'optv'}[$j]{'name'}[] = _h($data4{'gooptv_opt_value'}); $goods_ary[$i]{'optv'}[$j]{'sku_optval_key'}[] = _h($data3{'goopt_id'} . SKU_OPTVAL_DELIMITER . $data4{'gooptv_id'}); } } $j++; } } // SKU登録されている場合、初期表示される商品オプションの組み合わせの価格・在庫に変更 if (count($goods_sku_ary) > 0) { $target_sku_key = ""; if (isset($goods_ary[$i]{'optv'}[0]{'sku_optval_key'}) !== FALSE) { $ary_optval1 = $goods_ary[$i]{'optv'}[0]{'sku_optval_key'}; $opt1_key = ""; $opt2_key = ""; reset($ary_optval1); foreach ($ary_optval1 as $sub_optval1_idx => $sku_optval1_key) { $opt1_key = $sku_optval1_key; if (isset($goods_ary[$i]{'optv'}[1]{'sku_optval_key'}) !== FALSE) { $ary_optval2 = $goods_ary[$i]{'optv'}[1]{'sku_optval_key'}; reset($ary_optval2); foreach ($ary_optval2 as $sub_optval2_idx => $sku_optval2_key) { $opt2_key = $sku_optval2_key; $sku_key1 = $opt1_key . SKU_OPT_DELIMITER . $opt2_key; $sku_key2 = $opt2_key . SKU_OPT_DELIMITER . $opt1_key; if ($sku_key1 != "" && isset($goods_sku_ary[$sku_key1]) !== FALSE) { $target_sku_key = $sku_key1; // 選択状態にする選択肢 $goods_ary[$i]{'opt'}[0]{'selected_gooptv_id'} = _h($goods_ary[$i]{'optv'}[0]{'id'}[$sub_optval1_idx]); $goods_ary[$i]{'opt'}[1]{'selected_gooptv_id'} = _h($goods_ary[$i]{'optv'}[1]{'id'}[$sub_optval2_idx]); break; } elseif ($sku_key2 != "" && isset($goods_sku_ary[$sku_key2]) !== FALSE) { $target_sku_key = $sku_key2; // 選択状態にする選択肢 $goods_ary[$i]{'opt'}[0]{'selected_gooptv_id'} = _h($goods_ary[$i]{'optv'}[0]{'id'}[$sub_optval1_idx]); $goods_ary[$i]{'opt'}[1]{'selected_gooptv_id'} = _h($goods_ary[$i]{'optv'}[1]{'id'}[$sub_optval2_idx]); break; } } } else { $sku_key1 = $opt1_key; if ($sku_key1 != "" && isset($goods_sku_ary[$sku_key1]) !== FALSE) { $target_sku_key = $sku_key1; // 選択状態にする選択肢 $goods_ary[$i]{'opt'}[0]{'selected_gooptv_id'} = _h($goods_ary[$i]{'optv'}[0]{'id'}[$sub_optval1_idx]); } } if ($target_sku_key != "") { break; } } } else { if (isset($goods_ary[$i]{'optv'}[1]{'sku_optval_key'}) !== FALSE) { $ary_optval2 = $goods_ary[$i]{'optv'}[1]{'sku_optval_key'}; reset($ary_optval2); foreach ($ary_optval2 as $sub_optval2_idx => $sku_optval2_key) { $opt2_key = $sku_optval2_key; $sku_key2 = $opt2_key; if ($sku_key2 != "" && isset($goods_sku_ary[$sku_key2]) !== FALSE) { $target_sku_key = $sku_key2; // 選択状態にする選択肢 $goods_ary[$i]{'opt'}[1]{'selected_gooptv_id'} = _h($goods_ary[$i]{'optv'}[1]{'id'}[$sub_optval2_idx]); break; } } } } if ($target_sku_key != "") { $sku_key = $target_sku_key; // 日本国内価格 $goods_ary[$i]{'price'} = _h(number_format($goods_sku_ary[$sku_key]{'gosku_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // 日本国内価格(桁区切りなし) $goods_ary[$i]{'price_nonbreaking'} = _h($goods_sku_ary[$sku_key]{'gosku_price'}); // 日本国外価格 $goods_ary[$i]{'price2'} = _h(number_format($goods_sku_ary[$sku_key]{'gosku_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // 日本国外価格(桁区切りなし) $goods_ary[$i]{'price2_nonbreaking'} = _h($goods_sku_ary[$sku_key]{'gosku_price2'}); // 在庫数 $goods_ary[$i]{'zaikosu'} = _h($goods_sku_ary[$sku_key]{'gosku_zaikosu'}); // 重量 $goods_ary[$i]{'weight'} = _h($goods_sku_ary[$sku_key]{'gosku_weight'}); // YCD機能ONの時 // EKKYO.NET 機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE || exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 中国向けDDP価格 $goods_ary[$i]{'cn_ddp_price'} = _h($obj_ycd->calc_price($lcs_id, $goods_sku_ary[$sku_key]{'gosku_cn_ddp_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000, "format")); // 中国向けDDP価格(桁区切りなし) $goods_ary[$i]{'cn_ddp_price_nonbreaking'} = _h($goods_sku_ary[$sku_key]{'gosku_cn_ddp_price'}); // 関税および立替手数料(=中国DDP価格 - FOB価格) $goods_ary[$i]{'cn_ddp_customs_duty'} = _h($obj_ycd->calc_customs_duty($lcs_id, $goods_sku_ary[$sku_key]{'gosku_cn_ddp_price'}, $goods_sku_ary[$sku_key]{'gosku_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000, "format")); // 関税および立替手数料(=中国DDP価格 - FOB価格)(桁区切りなし) $goods_ary[$i]{'cn_ddp_customs_duty_nonbreaking'} = _h($obj_ycd->calc_customs_duty($lcs_id, $goods_sku_ary[$sku_key]{'gosku_cn_ddp_price'}, $goods_sku_ary[$sku_key]{'gosku_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000, "")); } // 店舗の基準通貨が「通貨選択」または「店舗の優先順位一位の通貨」と異なる時 if($tsuka_conv != $shop{'tsuka_id'} || $shop_first_tsuka_id != $shop{'tsuka_id'}){ // 通貨変換 $price_conv = round_price_conv($goods_sku_ary[$sku_key]{'gosku_price'} * $rate, $tsuka_conv_decimal); // $goods_ary[$i]{'price_conv'} = _h(" ≈ " . $price_conv . " " . $tsuka_unit); $goods_ary[$i]{'price_conv'} = _h(get_shop_tsuka_approximate_symbol($lcs_id, $lang_id) . $price_conv . " " . $tsuka_unit); $price2_conv = round_price_conv($goods_sku_ary[$sku_key]{'gosku_price2'} * $rate, $tsuka_conv_decimal); // $goods_ary[$i]{'price2_conv'} = _h(" ≈ " . $price2_conv . " " . $tsuka_unit); $goods_ary[$i]{'price2_conv'} = _h(get_shop_tsuka_approximate_symbol($lcs_id, $lang_id) . $price2_conv . " " . $tsuka_unit); // YCD機能ONの時 // EKKYO.NET 機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE || exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 通貨変換 $goods_ary[$i]{'cn_ddp_price_conv'} = _h($obj_ycd->calc_price_conv($lcs_id, $goods_sku_ary[$sku_key]{'gosku_cn_ddp_price'}, $rate, $tsuka_conv_decimal, $lang_id, $tsuka_unit)); // 関税および立替手数料(=中国DDP価格 - FOB価格) 通貨変換 $goods_ary[$i]{'cn_ddp_customs_duty_conv'} = _h($obj_ycd->calc_customs_duty_conv($lcs_id, $goods_sku_ary[$sku_key]{'gosku_cn_ddp_price'}, $goods_sku_ary[$sku_key]{'gosku_price2'}, $rate, $tsuka_conv_decimal, $lang_id, $tsuka_unit)); } } // セール前価格(国内) $goods_ary[$i]{'goods_sale_base_price'} = _h(number_format($goods_sku_ary[$sku_key]{'gosku_sale_base_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // セール前価格(国外) $goods_ary[$i]{'goods_sale_base_price2'} = _h(number_format($goods_sku_ary[$sku_key]{'gosku_sale_base_price2'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000)); // YCD機能ONの時 // EKKYO.NET 機能ONの時 if (exist_lcs_module("ycd", $lcs{'lcs_module_info'}) === TRUE || exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 中国向けDDP セール前価格 $goods_ary[$i]{'goods_cn_ddp_sale_base_price'} = _h($obj_ycd->calc_price($lcs_id, $goods_sku_ary[$sku_key]{'gosku_cn_ddp_sale_base_price'}, $tsuka_decimal, $CN_NF_DECP, $CN_NF_1000, "format")); } // プレミアム会員機能ONの時 if (exist_lcs_module("premium_membership", $lcs{'lcs_module_info'}) === TRUE && isset($goods_sku_ary[$sku_key]{'premium_membership'})) { reset($goods_sku_ary[$sku_key]{'premium_membership'}); foreach ($goods_sku_ary[$sku_key]{'premium_membership'} as $membership_price_elm_key => $membership_price_elm_val) { $goods_ary[$i]{$membership_price_elm_key} = _h($membership_price_elm_val); } } // EKKYO.NET 機能ONの時 if (exist_lcs_module("ekkyo_net", $lcs{'lcs_module_info'}) === TRUE) { // 容積値 $goods_ary[$i]{'eky_capacity'} = _h($goods_sku_ary[$sku_key]{'gosku_eky_capacity'}); } } } $i++; } $smarty->assign("goodslist", $goods_ary); //言語ID、通貨単位 $smarty->assign("lang_id", _h($lang_id)); $smarty->assign("tsuka_conv", _h($tsuka_conv)); //通貨単位が店舗の基準通貨と異なる場合に設定(近似値の表示制御用) if (strtoupper($tsuka_conv) != $shop{'tsuka_id'}) { $smarty->assign("tsuka_conv_flag", _h("1")); } else { $smarty->assign("tsuka_conv_flag", _h("")); } // カートからの戻りURL設定を追加 $url_param = "lang_id=" . mlc_urlencode($lang_id) . "&genre_id=" . mlc_urlencode($genre_id) . "&keyword=" . mlc_urlencode($keyword)."&sch_goods_tag=".mlc_urlencode($sch_goods_tag) . "&act=" . mlc_urlencode($act) . "&sortkey=" . mlc_urlencode($sortkey) . "&offset=" . mlc_urlencode($offset); if ($htpl_id_over) $url_param .= "&htpl_id=" . mlc_urlencode($htpl_id); if ($tsuka_conv) $url_param .= "&tsuka_conv=" . mlc_urlencode($tsuka_conv); // index : トップ $smarty->assign("cart_back_url", _h(create_cart_back_url("index", $url_param))); // 検索条件:セール中 $smarty->assign("search_goods_sale", _h($sch_goods_sale)); if ($lcs_id=="50662"){ require_once('../include/init_nw_com_date.inc'); // ネオ・ウィング様用 $smarty->assign("express_day", _h($express_day)); $smarty->assign("express_day_2", _h($express_day_2)); $smarty->assign("rental_start_date", _h($rental_start_date)); $smarty->assign("rental_start_date_2", _h($rental_start_date_2)); } // url変更フィルタ $smarty->register_outputfilter('tpl_replace'); // HTMLを画面出力 $smarty->display("index.tpl"); ?>