{"id":380,"date":"2012-02-27T23:40:46","date_gmt":"2012-02-27T14:40:46","guid":{"rendered":"http:\/\/www.prime-architect.co.jp\/myblog\/?p=380"},"modified":"2013-03-21T23:18:20","modified_gmt":"2013-03-21T14:18:20","slug":"ec-cube-%e9%a1%a7%e5%ae%a2%e3%83%87%e3%83%bc%e3%82%bf%e4%b8%80%e6%8b%ac%e3%82%a2%e3%83%83%e3%83%97%e3%83%ad%e3%83%bc%e3%83%89%e6%a9%9f%e8%83%bd%e3%82%92%e5%ae%9f%e8%a3%85%e3%81%99%e3%82%8b%e3%80%80","status":"publish","type":"post","link":"https:\/\/www.prime-architect.co.jp\/myblog\/ec-cube-380","title":{"rendered":"EC-CUBE \u9867\u5ba2\u30c7\u30fc\u30bf\u4e00\u62ec\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u6a5f\u80fd\u3092\u5b9f\u88c5\u3059\u308b\u3000\u305d\u306e\uff12"},"content":{"rendered":"<p>\u305d\u3057\u3066\u6700\u5f8c\u306b\u3001\u5b9f\u88c5\u30bd\u30fc\u30b9LC_Page_Admin_Customer_Upload.php\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<br \/>\n\u4f5c\u6210\u3059\u308b\u7b87\u6240\u306f\u3001data\/class\/pages\/admin\/customer\/<br \/>\n\u3053\u308c\u306f\u3001\u4ed6\u306e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u30bd\u30fc\u30b9\u3092\u3068\u308a\u3042\u3048\u305a\u6301\u3063\u3066\u304d\u3066\u305d\u308c\u3092\u4fee\u6b63\u3057\u3066\u3044\u304f\u6226\u7565\u3092\u53d6\u308b\u3002<br \/>\n\u4eca\u56de\u306f\u3053\u308c\u3092\u4e38\u3063\u3068\u6301\u3063\u3066\u304d\u3066\u4e2d\u8eab\u3092\u66f8\u304d\u63db\u3048\u307e\u3059\u3002<\/p>\n<p>data\/class\/pages\/admin\/products\/LC_Page_Admin_Products_UploadCSV.php<\/p>\n<p>\u307e\u305a\u306f\u3001LC_Page_Admin_Products_UploadCSV.php\u3092\u30b3\u30d4\u30fc\u3057\u3066\u540d\u524d\u3092\u66f8\u304d\u63db\u3048\u308b\u3068\u3053\u308d\u304b\u3089\u59cb\u3081\u307e\u3059\u3002<br \/>\n\u57fa\u672c\u7684\u306b\u306f\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u51e6\u7406\u306f\u3053\u308c\u3092\u53c2\u8003\u306b\u4f5c\u308a\u5909\u3048\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<p>\u307e\u305a\u306f\u30d5\u30a3\u30fc\u30eb\u30c9\u5909\u6570\u3068init\u30e1\u30bd\u30c3\u30c9\u3092\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u4fee\u6b63<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n\r\n function init() {\r\n  parent::init();\r\n  $this-&gt;tpl_mainpage = 'customer\/upload_csv.tpl';\r\n  $this-&gt;tpl_mainno = 'customer';\r\n  $this-&gt;tpl_subnavi = 'customer\/subnavi.tpl';\r\n  $this-&gt;tpl_subno = 'upload';\r\n }\r\n\r\n<\/pre>\n<p>\u7d9a\u3044\u3066\u3001$this->lfInitParam();\u30e1\u30bd\u30c3\u30c9\u3092\u4fee\u6b63\u3059\u308b\u3002<br \/>\n\u3053\u3053\u3067\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u9805\u76ee\u3092\u5b9a\u7fa9\u3059\u308b\u3002<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n \/**\r\n  * \u5165\u529b\u60c5\u5831\u306e\u521d\u671f\u5316\u3092\u884c\u3046.\r\n  *\r\n  * @return void\r\n  *\/\r\n function lfInitParam() {\r\n\r\n  $this-&gt;objFormParam-&gt;addParam(&quot;\u9867\u5ba2\u540d&quot;, &quot;name01&quot;, STEXT_LEN, &quot;KVa&quot;, array(&quot;EXIST_CHECK&quot;,&quot;SPTAB_CHECK&quot;,&quot;MAX_LENGTH_CHECK&quot;));\r\n  $this-&gt;objFormParam-&gt;addParam(&quot;\u9867\u5ba2\u540d\u30ab\u30ca&quot;, &quot;kana01&quot;, STEXT_LEN, &quot;CKV&quot;, array(&quot;EXIST_CHECK&quot;,&quot;SPTAB_CHECK&quot;,&quot;MAX_LENGTH_CHECK&quot;));\r\n  $this-&gt;objFormParam-&gt;addParam(&quot;\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9&quot;, &quot;email&quot;, STEXT_LEN ,&quot;KVa&quot;, array(&quot;EMAIL_CHAR_CHECK&quot;, &quot;MAX_LENGTH_CHECK&quot;));\r\n  $this-&gt;objFormParam-&gt;addParam(&quot;\u96fb\u8a711&quot;, &quot;tel01&quot;, INT_LEN, &quot;n&quot;, array(&quot;MAX_LENGTH_CHECK&quot;,&quot;NUM_CHECK&quot;,&quot;SPTAB_CHECK&quot;));\r\n  $this-&gt;objFormParam-&gt;addParam(&quot;\u96fb\u8a712&quot;, &quot;tel02&quot;, INT_LEN, &quot;n&quot;, array(&quot;MAX_LENGTH_CHECK&quot;,&quot;NUM_CHECK&quot;,&quot;SPTAB_CHECK&quot;));\r\n  $this-&gt;objFormParam-&gt;addParam(&quot;\u96fb\u8a713&quot;, &quot;tel03&quot;, INT_LEN, &quot;n&quot;, array(&quot;MAX_LENGTH_CHECK&quot;,&quot;NUM_CHECK&quot;,&quot;SPTAB_CHECK&quot;));\r\n  $this-&gt;objFormParam-&gt;addParam(&quot;\u6027\u5225&quot;, &quot;sex&quot;, INT_LEN, &quot;n&quot;, array(&quot;MAX_LENGTH_CHECK&quot;));\r\n  $this-&gt;objFormParam-&gt;addParam(&quot;\u90f5\u4fbf\u756a\u53f71&quot;, &quot;zip01&quot;, INT_LEN, &quot;n&quot;, array(&quot;NUM_CHECK&quot;,&quot;MAX_LENGTH_CHECK&quot;));\r\n  $this-&gt;objFormParam-&gt;addParam(&quot;\u90f5\u4fbf\u756a\u53f72&quot;, &quot;zip02&quot;, INT_LEN, &quot;n&quot;, array(&quot;NUM_CHECK&quot;,&quot;MAX_LENGTH_CHECK&quot;));\r\n  $this-&gt;objFormParam-&gt;addParam(&quot;\u4f4f\u6240\uff11&quot;, &quot;addr01&quot;, STEXT_LEN, &quot;KVa&quot;, array(&quot;EXIST_CHECK&quot;,&quot;SPTAB_CHECK&quot;,&quot;MAX_LENGTH_CHECK&quot;));\r\n  $this-&gt;objFormParam-&gt;addParam(&quot;\u767b\u9332\u65e5&quot;, &quot;create_date&quot;, INT_LEN, &quot;n&quot;, array(&quot;EXIST_CHECK&quot;));\r\n\r\n }\r\n<\/pre>\n<p>\u4eca\u56de\u306e\u4f8b\u3067\u306f\u4e0a\u8a18\u9805\u76ee\u306b\u7d5e\u3063\u3066\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<br \/>\n\u7ba1\u7406\u8005\u753b\u9762\u3067\u306f\u3053\u3093\u306a\u611f\u3058\u3067\u8868\u793a\u3055\u308c\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/www.prime-architect.co.jp\/wordpress\/wp-content\/uploads\/2011\/08\/o0613044011199928232.jpg\" alt=\"ec-cube\u9867\u5ba2\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\" title=\"o0613044011199928232\" width=\"613\" height=\"440\" class=\"alignnone size-full wp-image-379\" \/><\/p>\n<p>\u5fc5\u8981\u9805\u76ee\u306f\u30bd\u30fc\u30b9\u3092\u898b\u306a\u304c\u3089\u968f\u6642\u8abf\u6574\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u3064\u3065\u3044\u3066\u3001\u9867\u5ba2\u30c6\u30fc\u30d6\u30eb\uff08dtb_customer)\u3078\u30a4\u30f3\u30b5\u30fc\u30c8\u3059\u308b\u51e6\u7406\u306b\u3064\u3044\u3066<\/p>\n<p>\u65b0\u305f\u306a\u30e1\u30bd\u30c3\u30c9lfRegistCustomer\u3092LC_Page_Admin_Customer_Upload.php\u306b\u7528\u610f\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n\r\n \/**\r\n  * \u9867\u5ba2\u767b\u9332\u3092\u884c\u3046.\r\n  *\r\n  * @param SC_Query $objQuery SC_Query\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\r\n  * @param string|integer $line \u51e6\u7406\u4e2d\u306e\u884c\u6570\r\n  * @return void\r\n  *\/\r\n function lfRegistCustomer($objQuery,$objDb, $line = &quot;&quot;) {\r\n\r\n  \r\n\r\n  $arrRet = $this-&gt;objFormParam-&gt;getHashArray();\r\n\r\n  \/\/ \u5165\u529b\u5024\u3092\u5165\u308c\u308b\r\n  foreach($arrRet as $key =&gt; $val) {\r\n\u3000\u3000\/\/email\u3068sex\u306e\u5834\u5408\u3001\u5909\u63db\u3092\u304b\u3051\u3066\u3001\u305d\u308c\u4ee5\u5916\u306e\u9805\u76ee\u306f\u305d\u306e\u307e\u307e\u683c\u7d0d\u3059\u308b\u3002\r\n   switch($key) {\r\n    case 'email':\r\n     \/\/email\u306e\u5834\u5408\u3001\u5c0f\u6587\u5b57\u306b\u5909\u63db\u3059\u308b\r\n     $sqlval[$key] =strtolower($val);\r\n     break;\r\n    case 'sex':\r\n     if($val==&quot;\u7537\u6027&quot;){\r\n      $sqlval[$key] = '1';\r\n     }else{\r\n      $sqlval[$key] = '2';\r\n     }\r\n\r\n    default:\r\n     $sqlval[$key] = $val;\r\n     break;\r\n   }\r\n  }\r\n\r\n  \/\/\u9867\u5ba2ID\u306e\u751f\u6210(\u81ea\u52d5\u63a1\u756a\u3055\u308c\u308b\u305f\u3081\u306a\u3057\uff09\r\n\r\n  \/\/\u5fc5\u8981column\u3092\u4f5c\u6210\u3059\u308b\r\n\u3000\u3000\u3000\u3000\u3000\/\/name02\u3068kana02\u306fname01,kana01\u5074\u306b\u5bc4\u305b\u308b\u305f\u3081\u3001\u4f55\u3082\u30bb\u30c3\u30c8\u3057\u306a\u3044\u4ed5\u69d8\u306b\u3059\u308b\u3002\r\n  \/\/name02\r\n  $sqlval['name02'] = &quot; &quot;;\r\n  \/\/kana02\r\n  $sqlval['kana02'] = &quot; &quot;;\r\n\r\n  \/\/secret_key\uff08\u3053\u308c\u306fnot null\u9805\u76ee\u306a\u306e\u3067\u5fc5\u8981\uff09\r\n  \/\/ \u91cd\u8907\u3057\u306a\u3044\u4f1a\u54e1\u767b\u9332\u30ad\u30fc\u3092\u767a\u884c\u3059\u308b\u3002\r\n  $count = 1;\r\n  while ($count != 0) {\r\n   $uniqid = SC_Utils_Ex::sfGetUniqRandomId(&quot;r&quot;);\r\n   $count = $objDb-&gt;sfDataExists(&quot;dtb_customer&quot;, &quot;secret_key = ?&quot;, array($uniqid));\r\n   echo &quot;secret_key&quot; . $uniqid . &quot;\u3067\u3059&quot;;\r\n   \r\n  }\r\n  $sqlval['secret_key'] = $uniqid;\r\n\r\n  $sqlval['status'] = '2';\r\n\r\n\u3000\u3000\u3000\u3000\u3000\/\/\u305d\u308c\u4ee5\u5916\u306e\u9805\u76ee\u3092\u30bb\u30c3\u30c8\r\n  $time = date(&quot;Y-m-d H:i:s&quot;);\r\n  \/\/$sqlval['create_date'] = $sqlval['status'];\r\n  $sqlval['update_date'] = $time;\r\n  $sqlval['del_flg'] = '0';\r\n  $sqlval['mailmaga_flg'] = '1';\r\n\r\n  \/\/ INSERT\u306e\u5b9f\u884c\r\n  $objQuery-&gt;insert(&quot;dtb_customer&quot;, $sqlval);\r\n\r\n }\r\n\r\n<\/pre>\n<p>\u3053\u306e\u30e1\u30bd\u30c3\u30c9\u3067\u30a4\u30f3\u30b5\u30fc\u30c8\u304c\u884c\u308f\u308c\u308b\u3002<\/p>\n<p>\u3053\u308c\u3067\u5fc5\u8981\u306a\u30e1\u30bd\u30c3\u30c9\u306f\u4f5c\u6210\u3067\u304d\u305f\u306e\u3067\u3001\u6b21\u306f\u3044\u3088\u3044\u3088process\u30e1\u30bd\u30c3\u30c9\u306e\u4fee\u6b63\u3067\u3059\u3002<\/p>\n<p>\u3053\u306eprocess\u30e1\u30bd\u30c3\u30c9\u306f~~~\u3067\u56f2\u3063\u305f\u90e8\u5206\u3092\u4fee\u6b63\u3059\u308c\u3070OK\u3067\u3059\u3002<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n \/**\r\n  * Page \u306e\u30d7\u30ed\u30bb\u30b9.\r\n  *\r\n  * @return void\r\n  *\/\r\n function process() {\r\n  \/\/---- \u30da\u30fc\u30b8\u521d\u671f\u8a2d\u5b9a\r\n  $objQuery = new SC_Query();\r\n  $objView = new SC_AdminView();\r\n  $objDb = new SC_Helper_DB_Ex();\r\n\r\n\r\n\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\r\n      if(!$err) {\r\n       $this-&gt;lfRegistCustomer($objQuery,$objDb, $line);\r\n       $regist++;\r\n      }\r\n      $arrParam = $this-&gt;objFormParam-&gt;getHashArray();\r\n\r\n      &lt;font color=&quot;#FF0000&quot;&gt;if(!$err) echo $line.&quot; \/ &quot;.$rec_count. &quot;\u884c\u76ee\u3000\uff08\u9867\u5ba2\u540d\uff1a&quot;.$arrParam['name01'].&quot; \/ \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\uff1a&quot;.$arrParam['email'].&quot;)&quot;;&lt;\/font&gt;\r\n      flush();\r\n     }\r\n     fclose($fp);\r\n\r\n\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\uff5e\r\n\r\n<\/pre>\n<p>\u591a\u5c11\u3001\u7aef\u6298\u3063\u305f\u90e8\u5206\u3082\u3042\u308a\u307e\u3059\u304c\u3001<br \/>\n\u3053\u308c\u3067\u9867\u5ba2\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u6a5f\u80fd\u306f\u5b8c\u6210\u3067\u3059\u3002<\/p>\n<p><a href=\"http:\/\/www.prime-architect.co.jp\/ec-cube\/customer_upload\"><br \/>\n<img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.prime-architect.co.jp\/wordpress\/wp-content\/uploads\/2011\/08\/blog_banner_upload1.jpg\" alt=\"blog_banner_upload\" width=\"723\" height=\"275\" class=\"alignright size-full wp-image-1178\" alt=\"EC-CUBE\u9867\u5ba2\u4e00\u62ec\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\"\/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u305d\u3057\u3066\u6700\u5f8c\u306b\u3001\u5b9f\u88c5\u30bd\u30fc\u30b9LC_Page_Admin_Customer_Upload.php\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002 \u4f5c\u6210\u3059\u308b\u7b87\u6240\u306f\u3001data\/class\/pages\/admin\/customer\/ \u3053\u308c\u306f\u3001\u4ed6\u306e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u30bd\u30fc\u30b9\u3092 &hellip; <a href=\"https:\/\/www.prime-architect.co.jp\/myblog\/ec-cube-380\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;EC-CUBE \u9867\u5ba2\u30c7\u30fc\u30bf\u4e00\u62ec\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u6a5f\u80fd\u3092\u5b9f\u88c5\u3059\u308b\u3000\u305d\u306e\uff12&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[4],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.prime-architect.co.jp\/myblog\/wp-json\/wp\/v2\/posts\/380"}],"collection":[{"href":"https:\/\/www.prime-architect.co.jp\/myblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.prime-architect.co.jp\/myblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.prime-architect.co.jp\/myblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.prime-architect.co.jp\/myblog\/wp-json\/wp\/v2\/comments?post=380"}],"version-history":[{"count":9,"href":"https:\/\/www.prime-architect.co.jp\/myblog\/wp-json\/wp\/v2\/posts\/380\/revisions"}],"predecessor-version":[{"id":579,"href":"https:\/\/www.prime-architect.co.jp\/myblog\/wp-json\/wp\/v2\/posts\/380\/revisions\/579"}],"wp:attachment":[{"href":"https:\/\/www.prime-architect.co.jp\/myblog\/wp-json\/wp\/v2\/media?parent=380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.prime-architect.co.jp\/myblog\/wp-json\/wp\/v2\/categories?post=380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.prime-architect.co.jp\/myblog\/wp-json\/wp\/v2\/tags?post=380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}