access_token\u53d6\u5f97<\/a>\u300f\u3067\u66f8\u3044\u305f\u306e\u3067\u7701\u7565\u3057\u307e\u3059\u3002<\/p>\nclass NEAPI {\r\n\r\n public static function ConnectNE($selecterCode)\r\n {\r\n #token\u53d6\u5f97\u90e8\uff081\uff5e5\uff09\u7701\u7565\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n \/\/ \u52d5\u4f5c\u306e\u5206\u5c90 \u203b\u5f15\u6570\u3067\u52d5\u4f5c\u3092\u5206\u3051\u308b\u3053\u3068\u3067token\u767a\u884c\u307e\u3067\u3092\u5171\u901a\u5316\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n Switch($selecterCode){\r\n case 1:\r\n #NE\u5728\u5eab\u6570\u66f4\u65b0 \u203b\u3064\u3044\u3067\u306b\u51fa\u54c1\u4e2d\u5546\u54c1\u306e\u767b\u9332\r\n self::StockUplode_NextEngine($access_token,$refresh_toke,$encode_access,$encode_refresh);\r\n break;\r\n case 99:\r\n #NE\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u30ad\u30e5\u30fc\u691c\u7d22 \u203b\u671f\u9593\u6307\u5b9a\u81ea\u52d5\u3067\u6628\u65e5\uff5e\u672c\u65e5\r\n self::QueSearch_NextEngine($access_token,$refresh_toke,$encode_access,$encode_refresh);\r\n break;\r\n default:\r\n break;\r\n }\r\n }\r\n \r\n public static function StockUplode_NextEngine($access_token,$refresh_toke,$encode_access,$encode_refresh)\r\n {\r\n #\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\u3057\u306a\u3044 & \u30d1\u30fc\u30b9\u6642\u9593\u3092\u8a2d\u5b9a\u3057\u306a\u3044\r\n ini_set(\"max_execution_time\",0);\r\n ini_set(\"max_input_time\",0); \r\n\r\n #\u30cd\u30af\u30b9\u30c8\u30a8\u30f3\u30b8\u30f3\u306e\u5546\u54c1\u30de\u30b9\u30bf\u304b\u3089\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\r\n self::getItemData_NextEngine($access_token,$refresh_toke,$encode_access,$encode_refresh);\r\n #\u30cd\u30af\u30b9\u30c8\u30a8\u30f3\u30b8\u30f3\u306e\u5728\u5eab\u30de\u30b9\u30bf\u304b\u3089\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u306b\u5728\u5eab\u6570\u3092\u767b\u9332\r\n self::getStockData_NextEngine($access_token,$refresh_toke,$encode_access,$encode_refresh);\r\n #\u51fa\u54c1\u4e2d\u306e\u30b7\u30b9\u30c6\u30e0\u5185\u5546\u54c1\u60c5\u5831\u306e\u62bd\u51fa\r\n $saleingItems = self::pickUpSaleItem_SystemData();\r\n If(!empty($saleingItems)){\r\n #\u30b7\u30b9\u30c6\u30e0\u5185\u5546\u54c1\u60c5\u5831\u3068\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u3092\u6bd4\u8f03\u3057\u3066\u52a0\u6e1b\u7b97\r\n self::checkStockSystemData_Temp($saleingItems);\r\n #\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u306e\u30de\u30fc\u30ab\u30fc\u3067\u62bd\u51fa\u30cd\u30af\u30b9\u30c8\u30a8\u30f3\u30b8\u30f3\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\r\n self::ItemStockUplode_NextEngine($access_token,$refresh_toke,$encode_access,$encode_refresh);\r\n }\r\n return;\r\n }\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ NextEngin\u5546\u54c1\u30de\u30b9\u30bf\u53d6\u5f97 \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n public static function getItem_NextEngine($access_token,$refresh_toke,$encode_access,$encode_refresh)\r\n {\r\n $Endpoint = 'https:\/\/api.next-engine.org\/api_v1_master_goods\/count';\r\n $header = array(\"Content-Type: application\/x-www-form-urlencoded;charset=UTF-8\");\r\n $params = 'access_token='.$access_token.'&refresh_token='.$refresh_toke.'&wait_flag=1';\r\n\r\n #\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3078\u30a2\u30af\u30bb\u30b9\u3057\u3066\u60c5\u5831\u53d6\u5f97\r\n $response = self::postSSLAPI_Curl($Endpoint,$header,$params);\r\n #JSON\u306e\u53d6\u308a\u51fa\u3057\r\n $pattern = '\/\\{.+?\\}\/';\r\n preg_match_all($pattern, $response, $match);\r\n $list = (array)json_decode($match[0][0]);\r\n\r\n #sitelogincodes\u306bend_Date\u3092\u767b\u9332\r\n \/\/$access_token\r\n self::saveTokenEndDate_NextEngine($list['access_token'],$list['access_token_end_date'],$encode_access);\r\n \/\/$refresh_toke\r\n self::saveTokenEndDate_NextEngine($list['refresh_token'],$list['refresh_token_end_date'],$encode_refresh);\r\n \r\n If(!empty($list['count'])){\r\n $count = (ceil($list['count']\/10000));\r\n \r\n #NE\u5546\u54c1\u30de\u30b9\u30bf\u3092\u53d6\u5f97\r\n $Endpoint = 'https:\/\/api.next-engine.org\/api_v1_master_goods\/search';\r\n $header = array(\"Content-Type: application\/x-www-form-urlencoded;charset=UTF-8\");\r\n $fields = 'goods_id,goods_representation_id,goods_name,goods_supplier_id,goods_jan_code,goods_maker_model_number,goods_cost_price,goods_display_price,goods_selling_price';\r\n for($i=0;$i < $count; $i++){\r\n #for\u30eb\u30fc\u30d7\u3067\u53d6\u308a\u51fa\u3057\r\n $list = $ItemData = array();\r\n $params = 'access_token='.$access_token.'&refresh_token='.$refresh_toke.'&wait_flag=1&offset='.$i.'&fields='.$fields;\r\n \r\n $response = self::postSSLAPI_Curl($Endpoint,$header,$params);\r\n $list = (array)json_decode($response);\r\n\r\n #sitelogincodes\u306bend_Date\u3092\u767b\u9332\r\n \/\/$access_token\r\n self::saveTokenEndDate_NextEngine($list['access_token'],$list['access_token_end_date'],$encode_access);\r\n \/\/$refresh_toke\r\n self::saveTokenEndDate_NextEngine($list['refresh_token'],$list['refresh_token_end_date'],$encode_refresh);\r\n \r\n If(!empty($list['data'])){\r\n foreach($list['data'] as $id){\r\n #\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092\u5546\u54c1\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u306b\u683c\u7d0d\r\n $item = new Producttemporary;\r\n $item->product_id = $id->goods_id;\r\n If(!empty($id->goods_maker_model_number)){$item->makercode = $id->goods_maker_model_number;}else{$item->makercode = NULL;}\r\n If(!empty($id->goods_jan_code)){$item->jan = $id->goods_jan_code;}else{$item->jan = NULL;}\r\n $item->jan = $id->goods_jan_code;\r\n $item->productname = $id->goods_name;\r\n $item->stock = NULL;\r\n $item->originalprice = $id->goods_display_price;\r\n $item->assunedcost = $id->goods_cost_price;\r\n $item->salesprice = $id->goods_selling_price;\r\n $item->shipper_id = $id->goods_supplier_id;\r\n $item->mathstocks = NULL;\/\/\u66f4\u65b0\u7528\u5dee\u5206\u8a08\u7b97\u7d50\u679c\r\n $item->onoff = 0;\/\/\u66f4\u65b0\u9069\u7528\u30d5\u30e9\u30b0\r\n $item->save();\r\n }\r\n }\r\n }\r\n }else{\r\n #\u500b\u6570\u8abf\u67fb\u5931\u6557\u203b\u30ed\u30b0\u306b\u6b8b\u3059\r\n }\r\n return;\r\n }\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ NextEngin\u5728\u5eab\u30de\u30b9\u30bf\u53d6\u5f97 \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n public static function getStock_NextEngine($access_token,$refresh_toke,$encode_access,$encode_refresh)\r\n {\r\n $Endpoint = 'https:\/\/api.next-engine.org\/api_v1_master_stock\/count';\r\n $header = array(\"cache-control: no-cache;charset=UTF-8\");\r\n $params = 'access_token='.$access_token.'&refresh_token='.$refresh_toke.'&wait_flag=1';\r\n\r\n #\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3078\u30a2\u30af\u30bb\u30b9\u3057\u3066\u60c5\u5831\u53d6\u5f97\r\n $response = self::postSSLAPI_Curl($Endpoint,$header,$params);\r\n\r\n #JSON\u306e\u53d6\u308a\u51fa\u3057\r\n $pattern = '\/\\{.+?\\}\/';\r\n preg_match_all($pattern, $response, $match);\r\n $list = (array)json_decode($match[0][0]);\r\n\r\n #sitelogincodes\u306bend_Date\u3092\u767b\u9332\r\n \/\/$access_token\r\n self::saveTokenEndDate_NextEngine($list['access_token'],$list['access_token_end_date'],$encode_access);\r\n \/\/$refresh_toke\r\n self::saveTokenEndDate_NextEngine($list['refresh_token'],$list['refresh_token_end_date'],$encode_refresh);\r\n \r\n If(!empty($list['count'])){\r\n $count = (ceil($list['count']\/10000));\r\n \r\n #NE\u5546\u54c1\u30de\u30b9\u30bf\u3092\u53d6\u5f97\r\n $Endpoint = 'https:\/\/api.next-engine.org\/api_v1_master_stock\/search';\r\n $header = array(\"Content-Type: application\/x-www-form-urlencoded;charset=UTF-8\");\r\n $fields = 'stock_goods_id,stock_quantity';\r\n for($i=0;$i < $count; $i++){\r\n #for\u30eb\u30fc\u30d7\u3067\u53d6\u308a\u51fa\u3057\r\n $list = $ItemData = array();\r\n $params = 'access_token='.$access_token.'&refresh_token='.$refresh_toke.'&wait_flag=1&offset='.$i.'&fields='.$fields;\r\n $response = self::postSSLAPI_Curl($Endpoint,$header,$params);\r\n $list = (array)json_decode($response);\r\n\r\n #sitelogincodes\u306bend_Date\u3092\u767b\u9332\r\n \/\/$access_token\r\n self::saveTokenEndDate_NextEngine($list['access_token'],$list['access_token_end_date'],$encode_access);\r\n \/\/$refresh_toke\r\n self::saveTokenEndDate_NextEngine($list['refresh_token'],$list['refresh_token_end_date'],$encode_refresh);\r\n \r\n If(!Empty($list['data'])){\r\n foreach($list['data'] as $id){\r\n #\u30c6\u30f3\u30dd\u30e9\u30ea\u306b\u5728\u5eab\u6570\u3092\u767b\u9332\r\n $item = Producttemporary::where('product_id',$id->stock_goods_id)->first();\r\n $item->stock = $id->stock_quantity;\r\n $item->save();\r\n }\r\n }\r\n }\r\n }else{\r\n #\u500b\u6570\u8abf\u67fb\u5931\u6557\u203b\u30ed\u30b0\u306b\u6b8b\u3059\r\n }\r\n return;\r\n }\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ \u81ea\u793e\u30b7\u30b9\u30c6\u30e0\u51fa\u54c1\u4e2d\u62bd\u51fa \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n public static function pickUpSaleItem_SystemData()\r\n {\r\n $array = MySQL\u304b\u3089\u51fa\u54c1\u4e2d\u5546\u54c1\u3092\u62bd\u51fa;\r\n return $array;\r\n }\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ \u30ec\u30b3\u30fc\u30c9\u6bd4\u8f03\u30fb\u5dee\u5206\u8a08\u7b97 \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n public static function checkStockSystemData_Temp($saleingItems)\r\n {\r\n #\u51fa\u54c1\u4e2d\u5546\u54c1\u304b\u3089\u62bd\u51fa\u3057\u305f\u5024\u3092\u4f7f\u3063\u3066\u30eb\u30fc\u30d7\r\n foreach($saleingItems as $saleslist){\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n \/\/ Saleitems\u306b\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u4fa1\u683c\u60c5\u5831\u3092\u53d6\u308a\u51fa\u3059\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n #Select\u51fa\u54c1\u304b\u5426\u304b\u3092\u78ba\u8a8d\r\n If(!empty(optional($saleslist->saleitem)->selectsalesmark)){\r\n #0\u306fEmpty\u306a\u306e\u3067\u3053\u3053\u306b\u306f\u9078\u629e\u80a2\u5546\u54c1\u306e\u307f\u304c\u5165\u308b \u203b\u7d44\u307f\u5408\u308f\u305b\u8ca9\u58f2\u3092\u632f\u308a\u304b\u3089\u843d\u305b\u308c\u3070OK\r\n If($saleslist->product_id == $saleslist->selectitem_id){\r\n #\u9078\u629e\u80a2ID\u3068product_id\u304c\u540c\u3058 => \u30d1\u30bf\u30fc\u30f3\u8ca9\u58f2\r\n \/\/\u4fa1\u683c\u60c5\u5831\u78ba\u5b9a\r\n $salesprice = optional($saleslist->saleitem)->salesprice;\r\n $assumedcost =optional($saleslist->saleitem)->assumedcost;\r\n $originalprice = optional($saleslist->saleitem)->originalprice;\r\n $shipper_id = optional($saleslist->saleitem->shipper)->pictfolder;\r\n }else{\r\n #\u7d44\u307f\u5408\u308f\u305b\u8ca9\u58f2 \u304b \u8a2d\u5b9a\u30df\u30b9\r\n \/\/productconverter\u306b\u8907\u6570\u306eSaleitem_id\u304c\u767b\u9332\u3055\u308c\u3066\u3044\u306a\u3044\u304b\u30c1\u30a7\u30c3\u30af\r\n $subchecks = \u9078\u629e\u80a2\u8ca9\u58f2\u306eMySQL\u767b\u9332\u30eb\u30fc\u30eb\r\n \u7d44\u5408\u305b\u8ca9\u58f2\u3067\u767a\u751f\u3059\u308bMySQL\u767b\u9332\u30eb\u30fc\u30eb\r\n \u6709\u52b9\u5546\u54c1\u306e\u30eb\u30fc\u30eb->get();\r\n If(!Empty($subchecks)){\r\n #\u30ec\u30b3\u30fc\u30c9\u304c\u5b58\u5728\u3059\u308b\r\n $salesprice = $assumedcost = $originalprice = $flag = 0;\r\n foreach($subchecks as $subcheck){\r\n #\u30ec\u30b3\u30fc\u30c9\u306e\u4e2d\u306b\u30bb\u30ec\u30af\u30c8\u30de\u30fc\u30af0\u306e\u5024\u304c\u306a\u3044\u304b\u30c1\u30a7\u30c3\u30af\r\n $saleitemCheck = \u5546\u54c1\u60c5\u5831\u306efind\u62bd\u51fa;\r\n If(($saleitemCheck->\u9078\u629e\u80a2\u8ca9\u58f2\u30de\u30fc\u30ab\u30fc)&&($flag == 0)){\r\n \r\n #\u4fa1\u683c\u60c5\u5831\u3092\u56fa\u5b9a\r\n $salesprice = $saleitemCheck->\u8ca9\u58f2\u4fa1\u683c;\r\n $assumedcost = $saleitemCheck->\u4ed5\u5165\u539f\u4fa1;\r\n $originalprice = $saleitemCheck->\u5b9a\u4fa1;\r\n $shipper_id = optional($saleitemCheck->\u4ed5\u5165\u4f01\u696d\u30c6\u30fc\u30d6\u30eb)->\u533a\u5206\u540d;\r\n $flag = 1;\/\/\u30eb\u30fc\u30d7\u7d42\u4e86\u30de\u30fc\u30ab\u30fc\r\n }\r\n }\r\n }else{\r\n #\u30ec\u30b3\u30fc\u30c9\u304c\u306a\u3044\r\n $salesprice = $assumedcost = $originalprice = 0;\r\n $shipper_id = '9999';\r\n }\r\n \/\/\u7d44\u5408\u305b\u306e\u307f\u3067\u51fa\u54c1\u3057\u3066\u3044\u308b\u5546\u54c1\u306e\u8af8\u3005\u4fa1\u683c\u306f0\u3067\u767b\u9332\u3055\u308c\u308b \u203b\u305f\u3060\u3057\u4e0a\u66f8\u304d\u6642\u306b\u306f\u65e2\u5b58\u4fa1\u683c\u304c\u5165\u3063\u3066\u3044\u308b\u3068\u304d\u30b9\u30ad\u30c3\u30d7\u3059\u308b\r\n }\r\n }else{\r\n #NULL\u30680\u306e\u5883\u3092\u4f5c\u308c\u306a\u3044\u306e\u30670\u3068\u307f\u306a\u3057\u3066\u52d5\u4f5c\u3059\u308b\r\n If(!empty(optional($saleslist->saleitem)->salesprice)){\r\n #\u58f2\u4fa1\u304c\u5165\u3063\u3066\u3044\u308c\u3070\u60c5\u5831\u306fnonObject\u30a8\u30e9\u30fc\u56de\u907f\u3067\u304d\u308b\r\n $salesprice = optional($saleslist->saleitem)->salesprice;\r\n $assumedcost =optional($saleslist->saleitem)->assumedcost;\r\n $originalprice = optional($saleslist->saleitem)->originalprice;\r\n $shipper_id = optional($saleslist->saleitem)->shipper_id;\r\n }else{\r\n #\u58f2\u4fa1 = 0\u306f\u7121\u8996\u3057\u3066\u3088\u3044\u60c5\u5831\u3068\u5224\u65ad\r\n $salesprice = $assumedcost = $originalprice = 0;\r\n $shipper_id = 0;\r\n }\r\n }\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n \/\/ Product_id\u304b\u3089\u5728\u5eab\u6570\u53d6\u5f97\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n #productstocks\u3092\u30c1\u30a7\u30c3\u30af\u3001\u5728\u5eab\u6570\u53d6\u5f97\r\n $p_stocks = MySQL\u5009\u5eab\u5225\u5728\u5eab\u7ba1\u7406\u30c6\u30fc\u30d6\u30eb\r\n ->select('\uff33\uff2b\uff35\u30b3\u30fc\u30c9',DB::raw('sum(\u5728\u5eab) as total'))\r\n ->get();\r\n \r\n #\u52a0\u7b97\u5728\u5eab\u6570\u53d6\u5f97\r\n $addstock = 0;\/\/\u521d\u671f\u5316\r\n $sts = \u5728\u5eab\u30bf\u30a4\u30d7::where(\u6709\u52b9\u30de\u30fc\u30ab,1)->get();\r\n $additionals = array();\r\n foreach($sts as $st){\r\n $additionals[$st->id] = $st->\u52a0\u7b97\u5728\u5eab\u6570;\r\n }\r\n #\u5728\u5eab\u52a0\u7b97\u6570\u3092\u78ba\u5b9a\r\n If(!Empty($additionals[optional($saleslist->\u5546\u54c1\uff33\uff2b\uff35\u30c6\u30fc\u30d6\u30eb)->\u5728\u5eab\u30bf\u30a4\u30d7_id])){\r\n $addstock = $additionals[optional($saleslist->\u5546\u54c1\uff33\uff2b\uff35\u30c6\u30fc\u30d6\u30eb)->\u5728\u5eab\u30bf\u30a4\u30d7_id];\r\n }else{\r\n $addstock = 0;\r\n }\r\n \r\n #\u767b\u9332\u5728\u5eab\u6570(\u6700\u7d42)\r\n If(!empty($p_stocks)){\r\n #\u5728\u5eab\u6570\u304c\u3042\u308b\u6642\u3001\u5728\u5eab\u6570+\u52a0\u7b97\u5728\u5eab\u6570\u3092\u8a08\u4e0a\r\n $stocks = ($p_stocks[0]->total) + $addstock;\r\n }else{\r\n #\u5728\u5eab\u6570\u767b\u9332\u304c\u306a\u3044\u6642\u3001\u52a0\u7b97\u5728\u5eab\u6570\u3092\u8a08\u4e0a\r\n $stocks = $addstock;\r\n }\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n \/\/ \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u8ffd\u52a0\/\u4e0a\u66f8\u304d\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n #Producttemporary\u304b\u3089\u4e00\u81f4\u3092\u63a2\u3059\r\n $value = Producttemporary::where('product_id',$saleslist->product_id)->first();\r\n If(!empty($value)){\r\n #$value\u304c\u5b58\u5728\u3059\u308b\u6642\u3001\u5728\u5eab\u6570\u3092\u8a08\u7b97\u3057\u683c\u7d0d\r\n If(($value->stock <> $stocks)or($value->originalprice <> $originalprice)or($value->assunedcost <> $assumedcost)or($value->salesprice <> $salesprice)){\r\n If(($value->originalprice <> $originalprice)&&($originalprice <> 0)){$value->originalprice = (INT)$originalprice;}\r\n If(($value->assunedcost <> $assumedcost)&&($assumedcost <> 0)){$value->assunedcost = (INT)$assumedcost;}\r\n If(($value->salesprice <> $salesprice)&&($salesprice <> 0)){$value->salesprice = (INT)$salesprice;}\r\n $value->shipper_id = $shipper_id;\r\n $value->mathstocks = $stocks - ($value->stock);\/\/\u66f4\u65b0\u7528\u5dee\u5206\u8a08\u7b97\u7d50\u679c\r\n $value->onoff = 1;\r\n $value->save();\r\n }else{\r\n #\u5897\u6e1b\u306a\u3044\u6642\u3001\u30bc\u30ed\u3067\u66f4\u65b0 \u203b\u58f2\u4fa1\u66f4\u65b0\u306a\u3069\u3067\u306e\u30a8\u30e9\u30fc\u56de\u907f\u76ee\u7684\r\n $value->mathstocks = 0;\/\/\u66f4\u65b0\u7528\u5dee\u5206\u8a08\u7b97\u7d50\u679c\r\n $value->onoff = 0;\r\n $value->save();\r\n }\r\n }else{\r\n #\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u306b\u5b58\u5728\u3057\u306a\u3044\u6642\u3001\u65b0\u898f\u8ffd\u52a0\r\n $item = new Producttemporary;\r\n $item->product_id = $saleslist->product_id;\r\n $item->makercode = optional($saleslist->product)->makercode;\r\n $item->jan = optional($saleslist->product)->jan;\r\n $item->productname = optional($saleslist->product)->productname;\r\n $item->stock = NULL;\r\n $item->originalprice = $originalprice;\r\n $item->assunedcost = $assumedcost;\r\n $item->salesprice = $salesprice;\r\n $item->shipper_id = $shipper_id;\r\n $item->mathstocks = $stocks;\/\/\u66f4\u65b0\u7528\u5dee\u5206\u8a08\u7b97\u7d50\u679c\r\n $item->onoff = 1;\r\n $item->save();\r\n }\r\n }\r\n }\r\n \r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ NextEngine\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9 \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n public static function ItemStockUplode_NextEngine($access_token,$refresh_toke,$encode_access,$encode_refresh)\r\n {\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n \/\/ \u5728\u5eab\u6570\u66f4\u65b0\uff1a\u5546\u54c1\u30de\u30b9\u30bf\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\r\n \/\/ ENDPOINT\uff1ahttps:\/\/api.next-engine.org\/api_v1_master_goods\/upload\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n #access_token\u53d6\u5f97\r\n $Endpoint = 'https:\/\/api.next-engine.org\/api_v1_master_goods\/upload\/';\r\n \r\n \/\/\/\/\/\/\/\/CSV\u30c7\u30fc\u30bf\u9020\u4f5c\/\/\/\/\/\/\/\/\r\n #$csv_header = ['syohin_code','sire_code','jan_code','kataban','syohin_name','genka_tnk','hyoji_tnk','baika_tnk','zaiko_su'];\r\n $csv_list = 'syohin_code,sire_code,jan_code,kataban,syohin_name,genka_tnk,hyoji_tnk,baika_tnk,zaiko_su';\r\n\r\n #\u5546\u54c1\u540d = NULL\u306e\u30ec\u30b3\u30fc\u30c9\u306f\u30a8\u30e9\u30fc\u56de\u907f\u306e\u305f\u3081\u9664\u5916\r\n $values = Producttemporary::where('onoff',1)\r\n ->whereNotNull('productname')\r\n ->get();\r\n \r\n $i = 0;\r\n foreach($values as $val){\r\n If(!empty($val->shipper_id)){\r\n #$shipper = optional($val->shipper)->pictfolder;\r\n $shipper = 9999;\/\/\u30c6\u30b9\u30c8\u5e97\u8217\u7528\r\n }else{\r\n $shipper = 9999;\r\n }\r\n $str = $val->product_id.','.$shipper.','.$val->jan.','.$val->makercode.',\"'.$val->productname.'\",'.$val->assunedcost.','.$val->originalprice.','.$val->salesprice.','.$val->mathstocks;\r\n $csv_list = $csv_list.\"\\n\".$str;\r\n }\r\n\r\n $header = array(\"Content-Type: application\/x-www-form-urlencoded;charset=UTF-8\");\r\n $params = 'access_token='.$access_token.'&refresh_token='.$refresh_toke.'&wait_flag=1&data_type=csv&data='.$csv_list;\r\n\r\n $response = self::postSSLAPI_Curl($Endpoint,$header,$params);\r\n\r\n $pattern = '\/\\{.+?\\}\/';\r\n preg_match_all($pattern, $response, $match);\r\n $list = (array)json_decode($match[0][0]);\r\n #sitelogincodes\u306bend_Date\u3092\u767b\u9332\r\n \/\/$access_token\r\n self::saveTokenEndDate_NextEngine($list['access_token'],$list['access_token_end_date'],$encode_access);\r\n \/\/$refresh_toke\r\n self::saveTokenEndDate_NextEngine($list['refresh_token'],$list['refresh_token_end_date'],$encode_refresh);\r\n\r\n #\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u306e\u5168\u4ef6\u524a\u9664\r\n #Producttemporary::truncate();\r\n }\r\n \r\n\r\n public static function saveTokenEndDate_NextEngine($code,$endDate,$name)\r\n {\r\n $necode_token = openssl_encrypt($code, \u6697\u53f7Method, \u6697\u53f7\u5316Key);\r\n $value = MySQL\u304b\u3089token\u30b3\u30fc\u30c9\u3067\u62bd\u51fa;\r\n If(!empty($value)){\r\n If($value->\u6709\u52b9\u671f\u9593 !== $endDate){\r\n $value->\u6709\u52b9\u671f\u9593 = $endDate;\r\n $value->save();\r\n }\r\n }else{\r\n $value2 = MySQL\u304b\u3089token\u540d\u3067\u62bd\u51fa;\r\n If(!empty($value2)){\r\n $value2->token = $necode_token;\r\n $value2->\u6709\u52b9\u671f\u9650 = $endDate;\r\n $value2->save();\r\n }\r\n }\r\n return;\r\n }\r\n \r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ \u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u30ad\u30e5\u30fc\u306e\u7d50\u679c\u53d6\u5f97 \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n public static function QueSearch_NextEngine($access_token,$refresh_toke,$encode_access,$encode_refresh)\r\n {\r\n #\u65e5\u4ed8\u53d6\u5f97\r\n $now = Carbon::now();\r\n $yesterday = Carbon::yesterday();\r\n\r\n #NE\u5546\u54c1\u30de\u30b9\u30bf\u3092\u53d6\u5f97\r\n $Endpoint = 'https:\/\/api.next-engine.org\/api_v1_system_que\/search';\r\n $header = array(\"Content-Type: application\/x-www-form-urlencoded;charset=UTF-8\");\r\n $fields = 'que_id,que_method_name,que_client_file_name,que_file_name,que_status_id,que_message,que_creation_date';\r\n $search = 'que_creation_date-gte='.$yesterday.&que_creation_date-lte='.$now;\r\n #que_creation_date\u3000\u30ad\u30e5\u30fc\u4f5c\u6210\u65e5\r\n $params = 'access_token='.$access_token.'&refresh_token='.$refresh_toke.'&wait_flag=1&offset=1&fields='.$fields.'&'.$search;\r\n \r\n $response = self::postSSLAPI_Curl($Endpoint,$header,$params);\r\n $list = (array)json_decode($response);\r\n \r\n return;\r\n }\r\n\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ \u57fa\u672c\u7684\u306aAPI_POST\u30ea\u30af\u30a8\u30b9\u30c8\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ \r\n public static function postSSLAPI_Curl($Endpoint,$header,$params)\r\n {\r\n $curl = curl_init();\r\n curl_setopt($curl, CURLOPT_URL, $Endpoint);\r\n curl_setopt($curl, CURLOPT_POST, true);\r\n curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);\r\n curl_setopt($curl, CURLOPT_HTTPHEADER, $header);\r\n curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, true);\/\/SSL\u8a3c\u660e\u66f8\r\n curl_setopt($curl, CURLOPT_POSTFIELDS, $params);\r\n $response = curl_exec($curl);\r\n \r\n return $response;\r\n }\r\n}<\/pre>\n\u304a\uff5e\u9577\u3044\uff01\u305d\u308c\u3082\u4e00\u822c\u7684\u306b\u4f7f\u3046\u30b9\u30af\u30ea\u30d7\u30c8\u3068\u9055\u3046\u3057\u3002\u307b\u3093\u3068\u500b\u4eba\u7684\u306a\u30e1\u30e2\u3067\u3059\u306d\u3002
\n\u7533\u3057\u8a33\u306a\u3044\u3002<\/p>\n
\u5927\u307e\u304b\u306a\u6d41\u308c\u306f\u300e\u5728\u5eab\u5909\u66f4\u306e\u6bb5\u53d6\u308a\u3092\u8003\u3048\u308b<\/a>\u300f\u3067\u30e1\u30e2\u3057\u305f\u901a\u308a\u3067\u3059\u3002<\/p>\n\u3061\u3087\u3063\u3068\u3057\u305f\u30b9\u30af\u30ea\u30d7\u30c8\u89e3\u8aac<\/h3>\n393\u884c\u76ee\uff5e405\u884c\u76ee<\/h4>\n
\u307e\u305a\u6700\u5f8c\u306efunction\u306e\u90e8\u5206\u3001\u3053\u308c\u306fcurl\u306ePOST\u304c\u591a\u3044\u306e\u3067\u5171\u901a\u5316\u3057\u3066\u304a\u3044\u3066\u3042\u308b\u3082\u306e\u3067\u3059\u3002
\n\u3053\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u5185\u3067\u306fself\u3067\u547c\u3073\u51fa\u3057\u3066\u307e\u3059\u304c\u3001\u5b9f\u969b\u306b\u306f\u5171\u901a\u51e6\u7406\u3092\u307e\u3068\u3081\u305fLibrary \u306b\u5165\u308c\u3066\u3042\u308a\u300e\u3044\u308d\u3093\u306a\u6240\u300f\u304b\u3089\u547c\u3073\u51fa\u3057\u3066\u4f7f\u3063\u3066\u307e\u3059\u3002<\/p>\n
\u30cd\u30af\u30b9\u30c8\u30a8\u30f3\u30b8\u30f3API\u3067\u306f\u3053\u306e\u4e2d\u306e400\u884c\u76ee\u3010SSL\u8a3c\u660e\u66f8\u3011\u304c\u5fc5\u9808\u306a\u306e\u3067\u6c17\u3092\u3064\u3051\u306a\u304d\u3083\u3044\u3051\u307e\u305b\u3093\u3002<\/p>\n
9\u884c\u76ee\uff5e20\u884c\u76ee<\/h4>\n
selecterCode\u3068\u3044\u3046\u5f15\u6570\u3067\u305d\u306e\u5f8c\u306e\u30a2\u30af\u30b7\u30e7\u30f3\u3092\u5206\u3051\u3066\u3044\u307e\u3059\u3002
\n\u7406\u7531\u306ftoken\u53d6\u5f97\u307e\u3067\u306f\u540c\u3058\u52d5\u304d\u3092\u3059\u308b\u304b\u3089\u3002
\n\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u4f8b\u3067\u3044\u3048\u3070\u3001\u5f15\u6570\uff1d1\u306e\u5834\u5408\u306f\u5728\u5eab\u66f4\u65b0\u3092\u8d77\u52d5\u3001\u5f15\u6570=99\u306e\u5834\u5408\u306f\u30ad\u30e5\u30fc\u306e\u8abf\u67fb\u3092\u52d5\u304b\u3057\u307e\u3059\u3002<\/p>\n
23\u884c\u76ee\uff5e42\u884c\u76ee<\/h4>\n
\u3053\u306efunction\u306f\u5728\u5eab\u66f4\u65b0\u306e\u52d5\u4f5c\u30925\u30d1\u30fc\u30c8\u306b\u5206\u3051\u3066\u52d5\u304b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n
\n
\n- \u30cd\u30af\u30b9\u30c8\u30a8\u30f3\u30b8\u30f3\u306e\u5546\u54c1\u30de\u30b9\u30bfAPI\u3092\u52d5\u304b\u3057\u3001MySQL\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u306b\u683c\u7d0d\u301030\u884c\u76ee\u3011<\/li>\n
- \u30cd\u30af\u30b9\u30c8\u30a8\u30f3\u30b8\u30f3\u306e\u5728\u5eab\u30de\u30b9\u30bfAPI\u3092\u52d5\u304b\u3057\u3001\u767b\u9332\u3057\u305f\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u306estock\u30ab\u30e9\u30e0\u306b\u683c\u7d0d\u301032\u884c\u76ee\u3011<\/li>\n
- \u793e\u5185\u30b7\u30b9\u30c6\u30e0\u304b\u3089\u6709\u52b9\u306a\u5546\u54c1(\u30cd\u30af\u30b9\u30c8\u30a8\u30f3\u30b8\u30f3\u306b\u767b\u9332\u3059\u308b\u5546\u54c1)\u306e\u5728\u5eab\u6570\u3092\u30ea\u30b9\u30c8\u3067\u62bd\u51fa\u301034\u884c\u76ee\u3011<\/li>\n
- \u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u306estock\u30ab\u30e9\u30e0\u3068\u7167\u3089\u3057\u5408\u308f\u305b\u66f4\u65b0\u7528\u5728\u5eab\u6570\u3092\u767b\u9332\u3001\u30c6\u30f3\u30dd\u30e9\u30ea\u306b\u306a\u3044\u5834\u5408\u306f\u60c5\u5831\u8ffd\u52a0\u301037\u884c\u76ee\u3011<\/li>\n
- \u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u3092\u53c2\u7167\u3057\u3001\u5909\u66f4\u306e\u3042\u3063\u305f\u30ec\u30b3\u30fc\u30c9\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u301039\u884c\u76ee\u3011<\/li>\n<\/ol>\n<\/div>\n
\u305d\u308c\u305e\u308c\u306e\u30b3\u30fc\u30c9\u306eJUMP\u5148\u306f\u4e0b\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n
\n
\n- 44\u884c\u76ee\uff5e108\u884c\u76ee\uff1a30\u884c\u76ee\u306e\u30b3\u30fc\u30c9\u306e\u7740\u5730\u70b9\u3002<\/li>\n
- 110\u884c\u76ee\uff5e163\u884c\u76ee\uff1a32\u884c\u76ee\u306e\u30b3\u30fc\u30c9\u306e\u7740\u5730\u70b9\u3002<\/li>\n
- 165\u884c\u76ee\uff5e299\u884c\u76ee\uff1a34\u884c\u76ee\u306e\u30b3\u30fc\u30c9\u306e\u7740\u5730\u70b9\u3002<\/li>\n
- 302\u884c\u76ee\uff5e348\u884c\u76ee\uff1a37\u884c\u76ee\u306e\u30b3\u30fc\u30c9\u306e\u7740\u5730\u70b9\u3002<\/li>\n
- 351\u884c\u76ee\uff5e369\u884c\u76ee\uff1a39\u884c\u76ee\u306e\u30b3\u30fc\u30c9\u306e\u7740\u5730\u70b9\u3002<\/li>\n<\/ul>\n<\/div>\n
371\u884c\u76ee\uff5e390\u884c\u76ee<\/h4>\n
selecterCode\uff08\u5f15\u6570\uff09\uff1d99\u3067\u8aad\u307f\u8fbc\u307f\u3092\u884c\u3046\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u30ad\u30e5\u30fc\u306e\u5b9f\u884c\u7d50\u679c\u53d6\u5f97API\u3002
\n\u671f\u9593\u6307\u5b9a\u3092\u6bce\u56de\u884c\u3046\u306e\u3082\u9762\u5012\u306a\u306e\u3067\u3001\u6628\u65e5\uff5e\u672c\u65e5\u306e\u5024\u3092\u53d6\u3063\u3066\u304f\u308b\u3088\u3046\u306b\u6307\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n
\u307e\u3068\u3081<\/h3>\n
\u3053\u308c\u3067\u5728\u5eab\u6570\u66f4\u65b0\u81ea\u4f53\u306f\u6a5f\u80fd\u3057\u305f\u306e\u3067\u3059\u304c\u3001\u554f\u984c\u3082\u767a\u751f\u3002<\/p>\n
250\u30ec\u30b3\u30fc\u30c9\u4ee5\u4e0a\u306e\u767b\u9332\u304c\u3067\u304d\u306a\u3044...\u3002<\/div>\n
\u3093\uff5e\u3001\u306a\u3093\u3067\u3060\u308d\u3046\u3002<\/p>\n
\u30cd\u30af\u30b9\u30c8\u30a8\u30f3\u30b8\u30f3\u3055\u3093\u306b\u304a\u805e\u304d\u3057\u305f\u3068\u3053\u308d\u3001\u4e00\u62ec\u767b\u9332\u306e\u5236\u9650\u3068\u8a00\u3046\u4e8b\u3067\u306f\u306a\u3055\u305d\u3046\u3002
\n\u3068\u306a\u308b\u3068\u3001\u4f5c\u6210\u3057\u305fCSV\u30ec\u30b3\u30fc\u30c9\u306e\u3069\u3053\u304b\u304c\u60aa\u3044\u3093\u3060\u308d\u3046\u3051\u3069...\u73fe\u72b6\u539f\u56e0\u4e0d\u660e\u3067\u3059\u3002<\/p>\n
\u7406\u7531\u304c\u5224\u660e\u3057\u305f\u3089\u5225\u9014\u8a18\u4e8b\u66f8\u3044\u3066\u8a18\u9332\u3057\u3066\u304a\u3053\u3046\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
Laravel\uff1aNextEngineAPI\u3067\u767b\u9332\u5728\u5eab\u306e\u6570\u3092\u793e\u5185\u8ca9\u58f2\u7ba1\u7406\u306e\u500b\u6570\u306b\u5909\u66f4\u3059\u308b\u3010\u305d\u306e2\u3011 \u524d\u56de\u307e\u3067\u306e\u95a2\u9023\u8a18\u4e8b\u306f\u3053\u3061\u3089\u300eaccess_token\u53d6\u5f97\u300f\u300e\u5728\u5eab\u5909\u66f4\u306e\u6bb5\u53d6\u308a\u3092\u8003\u3048\u308b\u300f \u4eca\u56de\u306f\u5728\u5eab\u66f4\u65b0\u306eScript\u3092\u66f8\u304d […]<\/p>\n","protected":false},"author":1,"featured_media":944,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"vkexunit_cta_each_option":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[72,34],"tags":[19,153,98,53,20,107,897,45,693,68],"class_list":["post-2468","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ec-system-do","category-php-memorandum","tag-ec","tag-laravel","tag-php","tag-53","tag-20","tag-107","tag-897","tag-45","tag-693","tag-68"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/qol-kk.com\/wp2\/wp-content\/uploads\/2018\/11\/laravel_logo.png","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/posts\/2468","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/comments?post=2468"}],"version-history":[{"count":0,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/posts\/2468\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/media\/944"}],"wp:attachment":[{"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/media?parent=2468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/categories?post=2468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/tags?post=2468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}