TestController.php 8.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Authority;
  4. use App\Batch;
  5. use App\City;
  6. use App\Events\CancelOrder;
  7. use App\Events\WmsReceiveNewEvent;
  8. use App\Http\Controllers\Api\thirdPart\flux\WaybillController;
  9. use App\Logistic;
  10. use App\OracleActTransactionLog;
  11. use App\Order;
  12. use App\Owner;
  13. use App\Package;
  14. use App\Rejected;
  15. use App\RejectedBill;
  16. use App\RejectedBillItem;
  17. use App\Unit;
  18. use App\User;
  19. use App\UserToken;
  20. use App\UserWorkgroup;
  21. use App\Waybill;
  22. use App\OraccleBasCustomer;
  23. use App\WMSReflectReceive;
  24. use Carbon\Carbon;
  25. use Endroid\QrCode\QrCode;
  26. use Endroid\QrCode\Response\QrCodeResponse;
  27. use Illuminate\Database\Query\JoinClause;
  28. use Illuminate\Http\Request;
  29. use Illuminate\Support\Facades\DB;
  30. use function PHPSTORM_META\map;
  31. use Zttp\Zttp;
  32. class TestController extends Controller
  33. {
  34. private $data=[];
  35. public function __construct()
  36. {
  37. $this->data["active_test"]="active";
  38. }
  39. public function method(Request $request,$method)
  40. {
  41. return call_user_func([$this, $method],$request);
  42. }
  43. function packageFromLog(Request $request){ //x $packagesBatch=Package::where('batch_number',$batch_number)->first();
  44. ini_set('max_execution_time',2500);
  45. ini_set('memory_limit','1526M');
  46. $uploaded=0;
  47. $count=DB::table('logs')->where('operation','like',"%PackageController::new_%" )
  48. ->where('created_at','>',"2020-06-08 15:46:00")
  49. ->where('created_at','<',"2020-06-08 15:47:00")
  50. ->where('type',"request_new_")
  51. ->count();
  52. $requests=DB::table('logs')->where('operation','like',"%PackageController::new_%" )
  53. ->where('created_at','>',"2020-06-08 15:46:00")
  54. ->where('created_at','<',"2020-06-08 15:47:00")
  55. ->where('type',"request_new_")
  56. ->get();
  57. $requests->each(function($request)use(&$uploaded){
  58. $requestJson=json_decode($request->description,true);
  59. $response = Zttp::withHeaders([ 'content-type' => 'application/json',
  60. ])->post('https://was.baoshi56.com/api/thirdPart/flux/package/new',
  61. $requestJson
  62. );
  63. if($response->json()&&$response->json()['response']&&$response->json()['response']['flag']=='Y')
  64. $uploaded+=1;
  65. });
  66. dd($uploaded.'/'.$count);
  67. }
  68. function t2(Request $request){ //x $packagesBatch=Package::where('batch_number',$batch_number)->first();
  69. $uploaded=0;
  70. $count=DB::table('logs')->where('operation','like',"%PackageController::new_%" )
  71. ->where('created_at','>',"2020-06-03 14:02:00")
  72. ->where('created_at','<',"2020-06-03 15:05:00")
  73. ->where('type',"request_new_")
  74. ->where('description','like',"%W200603000117%")
  75. ->count();
  76. $requests=DB::table('logs')->where('operation','like',"%PackageController::new_%" )
  77. ->where('created_at','>',"2020-06-03 14:02:00")
  78. ->where('created_at','<',"2020-06-03 15:05:00")
  79. ->where('description','like',"%W200603000117%")
  80. ->where('type',"request_new_")
  81. ->get();
  82. $requests->each(function($request)use(&$uploaded){
  83. $requestJson=json_decode($request->description,true);
  84. $response = Zttp::withHeaders([ 'content-type' => 'application/json',
  85. ])->post('https://was.baoshi56.com/api/thirdPart/flux/package/new',
  86. $requestJson
  87. );
  88. if($response->json()&&$response->json()['response']&&$response->json()['response']['flag']=='Y')
  89. $uploaded+=1;
  90. });
  91. dd($uploaded.'/'.$count);
  92. }
  93. function tj(Request $request){
  94. $waybills=Waybill::where('created_at','like','%2020-05-25%')->orWhere('created_at','like','%2020-05-30%')->get();
  95. $controller=(new WaybillController());
  96. $waybills->each(function ($waybill)use($controller){
  97. $controller->accomplishToWMS($waybill);
  98. });
  99. dd($waybills->count());
  100. }
  101. function injectJS(Request $request){
  102. $items=RejectedBillItem::whereHas('rejectedBill',function($query){
  103. return $query->where('id_owner',2);
  104. })->where('created_at','>','2019-12-23 18:11:00')->where('created_at','<','2019-12-24 11:25:00')->get();
  105. (new RejectedBillItemController())->collectionsToPackConfirm($items);
  106. }
  107. public function tj2(Request $request)
  108. {
  109. $rejected = Rejected::find(10);
  110. $rejectedJianshang=new \App\Http\Controllers\api\jianshang\RejectedController();
  111. dd( $rejectedJianshang->sendRejected($rejected));
  112. }
  113. public function excelIt()
  114. {
  115. $excel=new ExcelController();
  116. return $excel->makeExcel();
  117. }
  118. public function featureIt()
  119. {
  120. LogisticNumberFeatureController::loadRecentRejectedsToFeatures(5,2500);
  121. }
  122. public function newSku()
  123. {
  124. $url='http://bswcs/api/sorting/flux/newSku';
  125. $response = Zttp::post($url, [
  126. 'request'=>[
  127. [
  128. "SKU"=> "1234567890",
  129. "NAME"=> "瑞士莲**巧克力",
  130. "Alternate_SKU1"=> "1122334455",
  131. "GrossWeight"=> "1.2",
  132. "Cube"=> "0.75",
  133. "SKULength"=> "0.25",
  134. "SKUWidth"=> "0.15",
  135. "SKUHigh"=> "0.05"
  136. ],
  137. [
  138. "SKU"=> "1234567892",
  139. "NAME"=> "跳跳饼",
  140. "Alternate_SKU1"=> "",
  141. "GrossWeight"=> "1.3",
  142. "Cube"=> "0.75",
  143. "SKULength"=> "0.25",
  144. "SKUWidth"=> "0.15",
  145. "SKUHigh"=> "0.25"
  146. ],
  147. ]
  148. ]);
  149. return $response->json();
  150. }
  151. public function changePackage(){
  152. $packages=Package::where('delivery_number','<>',null)->where('logistic_id',null)->get();
  153. dd($packages);
  154. $packages=Package::whereRaw('delivery_number IS NOT NULL AND logistic_id IS NULL')->get();
  155. $logistics=Logistic::get();
  156. $packages->each(function ($package)use($logistics){
  157. $logistics->each(function ($logistic)use($package){
  158. if ($package->WMSReflectPackage->CarrierID==$logistic->code){
  159. $package->logistic_id=$logistic->id;
  160. return;
  161. }
  162. });
  163. });
  164. return "OK";
  165. }
  166. public function tNull(){
  167. }
  168. public function deletePackageAuthority()
  169. {
  170. $authorities=Authority::where('name','like','%包裹信息%')->get();
  171. $authorities->each(function ($authority){
  172. $authority->delete();
  173. });
  174. }
  175. public function test1(){
  176. Owner::update([["id"=>18,"code"=>"test1"],["id"=>17,"code"=>"test2"]]);
  177. }
  178. public function test3()
  179. {
  180. $strs=["auibh","aopk","bikon"];
  181. if (!$strs[0])return "";
  182. $len=strlen($strs[0]);
  183. for ($i=1;$i<count($strs);$i++){
  184. if ($len<1)break;
  185. for ($j=0;$j<$len;$j++){
  186. if ($strs[$i][$j]!=$strs[0][$j]){
  187. if ($j==0)return "";
  188. break;
  189. }
  190. $sum=$j+1;
  191. }
  192. $len=isset($sum)?$sum:0;
  193. }
  194. return substr($strs[0],0,$len);
  195. }
  196. public function test4(){
  197. $s="{([{()()[]{}}])[{()()[}]{}}](){[]}";
  198. $map = [
  199. ")" => "(",
  200. "}" => "{",
  201. "]" => "[",
  202. ];
  203. $len = strlen($s);
  204. $stack = [];
  205. if ($len%2!=0)dd(false);
  206. //s中出现map的key则弹出,没有出现则入栈
  207. for ($i =0; $i<$len; $i++) {
  208. var_dump("data:".$s[$i]);
  209. if (isset($map[$s[$i]])){
  210. //s中出现map的key:如果能找到对应的map的值 (,{,[ 则说明有配对,则弹出
  211. if (isset($stack) && $stack[0] == $map[$s[$i]]) {
  212. array_shift($stack);
  213. } else { //仅找到后面的一部分,说明是不匹配的
  214. dd(false);
  215. }
  216. var_dump("value1:".$map[$s[$i]]);
  217. var_dump($stack);
  218. } else {
  219. array_unshift($stack, $s[$i]);
  220. var_dump("value2:".$s[$i]);
  221. var_dump($stack);
  222. }
  223. }
  224. if (count($stack) > 0) {
  225. dd(false);
  226. }
  227. dd(true);
  228. //利用栈的先进后出 一个正确的括号组对应都为1对1或N对N
  229. // 先进后出“([{”入栈,")]}"出栈,轮询到出栈元素去映射栈顶,符合出栈,不符合直接返回
  230. //依次轮询 如果映射正确那么最后栈为空栈 否则返回false
  231. }
  232. }