TestController.php 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Authority;
  4. use App\Batch;
  5. use App\Events\CancelOrder;
  6. use App\Events\WmsReceiveNewEvent;
  7. use App\Http\Controllers\Api\thirdPart\flux\WaybillController;
  8. use App\Logistic;
  9. use App\Order;
  10. use App\Package;
  11. use App\Rejected;
  12. use App\RejectedBill;
  13. use App\RejectedBillItem;
  14. use App\Unit;
  15. use App\UploadFile;
  16. use App\User;
  17. use App\UserToken;
  18. use App\Waybill;
  19. use App\OraccleBasCustomer;
  20. use App\WMSReflectReceive;
  21. use Carbon\Carbon;
  22. use Endroid\QrCode\Response\QrCodeResponse;
  23. use Illuminate\Http\Request;
  24. use Illuminate\Support\Facades\DB;
  25. use function PHPSTORM_META\map;
  26. use Zttp\Zttp;
  27. class TestController extends Controller
  28. {
  29. private $data = [];
  30. public function __construct()
  31. {
  32. $this->data["active_test"] = "active";
  33. }
  34. public function method(Request $request, $method)
  35. {
  36. return call_user_func([$this, $method], $request);
  37. }
  38. function packageFromLog(Request $request)
  39. { //x $packagesBatch=Package::where('batch_number',$batch_number)->first();
  40. ini_set('max_execution_time', 2500);
  41. ini_set('memory_limit', '1526M');
  42. $uploaded = 0;
  43. $count = DB::table('logs')->where('operation', 'like', "%PackageController::new_%")
  44. ->where('created_at', '>', "2020-06-08 15:46:00")
  45. ->where('created_at', '<', "2020-06-08 15:47:00")
  46. ->where('type', "request_new_")
  47. ->count();
  48. $requests = DB::table('logs')->where('operation', 'like', "%PackageController::new_%")
  49. ->where('created_at', '>', "2020-06-08 15:46:00")
  50. ->where('created_at', '<', "2020-06-08 15:47:00")
  51. ->where('type', "request_new_")
  52. ->get();
  53. $requests->each(function ($request) use (&$uploaded) {
  54. $requestJson = json_decode($request->description, true);
  55. $response = Zttp::withHeaders(['content-type' => 'application/json',
  56. ])->post('https://was.baoshi56.com/api/thirdPart/flux/package/new',
  57. $requestJson
  58. );
  59. if ($response->json() && $response->json()['response'] && $response->json()['response']['flag'] == 'Y')
  60. $uploaded += 1;
  61. });
  62. dd($uploaded . '/' . $count);
  63. }
  64. function t2(Request $request)
  65. { //x $packagesBatch=Package::where('batch_number',$batch_number)->first();
  66. $uploaded = 0;
  67. $count = DB::table('logs')->where('operation', 'like', "%PackageController::new_%")
  68. ->where('created_at', '>', "2020-06-03 14:02:00")
  69. ->where('created_at', '<', "2020-06-03 15:05:00")
  70. ->where('type', "request_new_")
  71. ->where('description', 'like', "%W200603000117%")
  72. ->count();
  73. $requests = DB::table('logs')->where('operation', 'like', "%PackageController::new_%")
  74. ->where('created_at', '>', "2020-06-03 14:02:00")
  75. ->where('created_at', '<', "2020-06-03 15:05:00")
  76. ->where('description', 'like', "%W200603000117%")
  77. ->where('type', "request_new_")
  78. ->get();
  79. $requests->each(function ($request) use (&$uploaded) {
  80. $requestJson = json_decode($request->description, true);
  81. $response = Zttp::withHeaders(['content-type' => 'application/json',
  82. ])->post('https://was.baoshi56.com/api/thirdPart/flux/package/new',
  83. $requestJson
  84. );
  85. if ($response->json() && $response->json()['response'] && $response->json()['response']['flag'] == 'Y')
  86. $uploaded += 1;
  87. });
  88. dd($uploaded . '/' . $count);
  89. }
  90. function t1(Request $request)
  91. {
  92. $test=new TestController();
  93. dump(method_exists($test,'t1'));
  94. }
  95. function tj(Request $request)
  96. {
  97. $waybills = Waybill::where('created_at', 'like', '%2020-05-25%')->orWhere('created_at', 'like', '%2020-05-30%')->get();
  98. $controller = (new WaybillController());
  99. $waybills->each(function ($waybill) use ($controller) {
  100. $controller->accomplishToWMS($waybill);
  101. });
  102. dd($waybills->count());
  103. }
  104. function injectJS(Request $request)
  105. {
  106. $items = RejectedBillItem::whereHas('rejectedBill', function ($query) {
  107. return $query->where('id_owner', 2);
  108. })->where('created_at', '>', '2019-12-23 18:11:00')->where('created_at', '<', '2019-12-24 11:25:00')->get();
  109. (new RejectedBillItemController())->collectionsToPackConfirm($items);
  110. }
  111. public function tj2(Request $request)
  112. {
  113. $rejected = Rejected::find(10);
  114. $rejectedJianshang = new \App\Http\Controllers\api\jianshang\RejectedController();
  115. dd($rejectedJianshang->sendRejected($rejected));
  116. }
  117. public function excelIt()
  118. {
  119. $excel = new ExcelController();
  120. return $excel->makeExcel();
  121. }
  122. public function featureIt()
  123. {
  124. LogisticNumberFeatureController::loadRecentRejectedsToFeatures(5, 2500);
  125. }
  126. public function newSku()
  127. {
  128. $url = 'http://bswcs/api/sorting/flux/newSku';
  129. $response = Zttp::post($url, [
  130. 'request' => [
  131. [
  132. "SKU" => "1234567890",
  133. "NAME" => "瑞士莲**巧克力",
  134. "Alternate_SKU1" => "1122334455",
  135. "GrossWeight" => "1.2",
  136. "Cube" => "0.75",
  137. "SKULength" => "0.25",
  138. "SKUWidth" => "0.15",
  139. "SKUHigh" => "0.05"
  140. ],
  141. [
  142. "SKU" => "1234567892",
  143. "NAME" => "跳跳饼",
  144. "Alternate_SKU1" => "",
  145. "GrossWeight" => "1.3",
  146. "Cube" => "0.75",
  147. "SKULength" => "0.25",
  148. "SKUWidth" => "0.15",
  149. "SKUHigh" => "0.25"
  150. ],
  151. ]
  152. ]);
  153. return $response->json();
  154. }
  155. public function changePackage()
  156. {
  157. $packages = Package::where('delivery_number', '<>', null)->where('logistic_id', null)->get();
  158. dd($packages);
  159. $packages = Package::whereRaw('delivery_number IS NOT NULL AND logistic_id IS NULL')->get();
  160. $logistics = Logistic::get();
  161. $packages->each(function ($package) use ($logistics) {
  162. $logistics->each(function ($logistic) use ($package) {
  163. if ($package->WMSReflectPackage->CarrierID == $logistic->code) {
  164. $package->logistic_id = $logistic->id;
  165. return;
  166. }
  167. });
  168. });
  169. return "OK";
  170. }
  171. public function tNull()
  172. {
  173. }
  174. public function deletePackageAuthority()
  175. {
  176. $authorities = Authority::where('name', 'like', '%包裹信息%')->get();
  177. $authorities->each(function ($authority) {
  178. $authority->delete();
  179. });
  180. }
  181. /*1*/
  182. function test(){
  183. }
  184. }