TestController.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Authority;
  4. use App\Batch;
  5. use App\Commodity;
  6. use App\CommodityMaterialBoxModel;
  7. use App\Components\AsyncResponse;
  8. use App\Components\Database;
  9. use App\Components\ErrorPush;
  10. use App\ErrorTemp;
  11. use App\Feature;
  12. use App\Http\ApiControllers\LoginController;
  13. use App\Http\Requests\OrderDelivering;
  14. use App\Jobs\BatchTaskJob;
  15. use App\Jobs\CacheShelfTaskJob;
  16. use App\Jobs\OrderCreateInstantBill;
  17. use App\Jobs\OrderCreateWaybill;
  18. use App\Jobs\SettlementBillReportJob;
  19. use App\Jobs\StoreCreateInstantBill;
  20. use App\Jobs\TestJob;
  21. use App\Jobs\WeightUpdateInstantBill;
  22. use App\LaborReport;
  23. use App\LaborReportStatus;
  24. use App\MaterialBox;
  25. use App\MaterialBoxModel;
  26. use App\Notifications\RoutineNotification;
  27. use App\OracleDOCASNHeader;
  28. use App\OracleDOCOrderHeader;
  29. use App\OracleDocOrderPackingSummary;
  30. use App\Order;
  31. use App\OrderBin;
  32. use App\OrderIssue;
  33. use App\OrderIssueProcessLog;
  34. use App\OrderPackage;
  35. use App\Owner;
  36. use App\OwnerAreaReport;
  37. use App\OwnerFeeDetail;
  38. use App\OwnerFeeDetailLogistic;
  39. use App\OwnerFeeExpress;
  40. use App\OwnerFeeLogistic;
  41. use App\OwnerFeeOperation;
  42. use App\OwnerFeeOperationDetail;
  43. use App\OwnerFeeStorage;
  44. use App\OwnerPriceOperation;
  45. use App\OrderPackageCountingRecord;
  46. use App\ProcurementCheckSheet;
  47. use App\RejectedBill;
  48. use App\SeeLog;
  49. use App\Services\BatchService;
  50. use App\Services\CacheShelfService;
  51. use App\Services\ForeignHaiRoboticsService;
  52. use App\Services\NotificationService;
  53. use App\Services\OrderPackageReceivedSyncService;
  54. use App\Services\OrderPackageService;
  55. use App\Services\OrderService;
  56. use App\Services\OwnerFeeTotalService;
  57. use App\Services\OwnerLogisticFeeReportService;
  58. use App\Services\OwnerPriceOperationService;
  59. use App\Services\OwnerStoreFeeReportService;
  60. use App\Services\OwnerStoreOutFeeReportService;
  61. use App\Services\ReviewService;
  62. use App\Services\StationService;
  63. use App\Services\StorageService;
  64. use App\Services\StoreService;
  65. use App\Station;
  66. use App\StationTask;
  67. use App\StationTaskMaterialBox;
  68. use App\Store;
  69. use App\StoreItem;
  70. use App\TaskTransaction;
  71. use App\Unit;
  72. use App\User;
  73. use App\UserDetail;
  74. use App\UserDutyCheck;
  75. use App\ValueStore;
  76. use App\Waybill;
  77. use App\WorkOrder;
  78. use Carbon\Carbon;
  79. use Carbon\CarbonPeriod;
  80. use Decimal\Decimal;
  81. use Doctrine\DBAL\Exception;
  82. use Firebase\JWT\JWT;
  83. use Illuminate\Database\Eloquent\Collection;
  84. use Illuminate\Database\Eloquent\HigherOrderBuilderProxy;
  85. use Illuminate\Foundation\Http\FormRequest;
  86. use Illuminate\Http\Request;
  87. use Illuminate\Support\Facades\Broadcast;
  88. use Illuminate\Support\Facades\Cache;
  89. use Illuminate\Support\Facades\Auth;
  90. use Illuminate\Support\Facades\Cookie;
  91. use Illuminate\Support\Facades\DB;
  92. use Illuminate\Support\Facades\Http;
  93. use Illuminate\Support\Facades\Log;
  94. use Illuminate\Support\Facades\Notification;
  95. use Illuminate\Support\Facades\URL;
  96. use Illuminate\Support\Facades\Validator;
  97. use Illuminate\Support\Str;
  98. use Laravel\Horizon\Events\JobFailed;
  99. use Monolog\Handler\IFTTTHandler;
  100. use phpDocumentor\Reflection\Types\Resource_;
  101. use PhpOffice\PhpSpreadsheet\Calculation\Web\Service;
  102. use Ramsey\Uuid\Uuid;
  103. use Symfony\Component\ErrorHandler\Error\FatalError;
  104. class TestController extends Controller
  105. {
  106. use AsyncResponse, ErrorPush, Database;
  107. const ASNREFERENCE_2 = 'ASNREFERENCE2';
  108. public function __construct()
  109. {
  110. $this->data["active_test"] = "active";
  111. }
  112. public function method(Request $request, $method)
  113. {
  114. try {
  115. return call_user_func([$this, $method], $request);
  116. }catch (\BadMethodCallException $e){
  117. dd("方法不存在");
  118. }
  119. }
  120. /**
  121. * @param $wave
  122. * @return string
  123. */
  124. private function wms_status($wave): string
  125. {
  126. switch ($wave->wavestatus) {
  127. case 00:
  128. $wms_status = '创建';
  129. break;
  130. case 40:
  131. $wms_status = '部分收货';
  132. break;
  133. case 90:
  134. $wms_status = '取消';
  135. break;
  136. case 99:
  137. $wms_status = '完成';
  138. break;
  139. case 62:
  140. $wms_status = '部分装箱';
  141. break;
  142. default:
  143. $wms_status = (string)$wave->wavestatus;
  144. }
  145. return $wms_status;
  146. }
  147. public function assignBatch()
  148. {
  149. $code = \request("code");
  150. $batches = Batch::query()->where("code",$code)->get();
  151. if (!$batches->count()){
  152. $wave = DB::connection("oracle")->selectOne(DB::raw("select * from DOC_WAVE_HEADER where WAVENO = ?"),[$code]);
  153. if (!$wave){
  154. dd("FLUX无波次");
  155. }
  156. $owner = app("OwnerService")->codeGetOwner($wave->customerid);
  157. $obj = [
  158. "wms_status" => $this->wms_status($wave),
  159. "wms_type"=>$wave->descr,
  160. "created_at"=>date("Y-m-d H:i:s"),
  161. "wms_created_at"=>$wave->addtime,
  162. "updated_at"=>$wave->edittime,
  163. "owner_id"=>$owner->id,
  164. ];
  165. $wave = Batch::query()->where("code",$code)->first();
  166. if (!$wave){
  167. $obj["code"] = $code;
  168. $wave = Batch::query()->create($obj);
  169. }else{
  170. Batch::query()->where("code",$code)->update($obj);
  171. }
  172. $ordernos = array_column(DB::connection("oracle")->select(DB::raw("select orderno from DOC_WAVE_DETAILS where WAVENO = ?"),[$code]),"orderno");
  173. Order::query()->whereIn("code",$ordernos)->update([
  174. "batch_id"=>$wave->id
  175. ]);
  176. Order::query()->with(["batch","bin"])->whereIn("code",$ordernos)->get()->each(function ($order){
  177. if (!$order->bin){
  178. $bin = DB::connection("oracle")->selectOne(DB::raw("select seqno from DOC_WAVE_DETAILS where waveno = ? and orderno = ?"),[$order->batch->code,$order->code]);
  179. if ($bin){
  180. OrderBin::query()->create([
  181. 'order_id' => $order->id,
  182. 'number' => $bin->seqno,
  183. ]);
  184. }
  185. }
  186. });
  187. $batches = Batch::query()->where("code",$code)->get();
  188. }
  189. app("BatchService")->assignTasks($batches);
  190. }
  191. /**
  192. * 检查和处理揽收
  193. *
  194. * @param OrderPackage|\stdClass $package
  195. */
  196. public function checkingAndProcess(OrderPackage $package, int $lineNo)
  197. {
  198. //校验快递商 订单状态 复核标记 揽收标记
  199. $package->loadMissing("order.logistic");
  200. if ($package->collecting_status == '1' || !$package->logistic_number)dd(1);
  201. if (strpos($package->order->logistic->code ?? '','ZTO') === false)dd(2);
  202. $statusMapping = array_flip(Order::STATUS);
  203. //if (($statusMapping[$package->order->wms_status] ?? 99) > 63)dd(3);
  204. /** @var OrderPackageService $orderPackageService */
  205. $orderPackageService = app('OrderPackageService');
  206. $result = $orderPackageService->collectUpload([$package->logistic_number]);
  207. dump($result);
  208. if (!$result["success"]){
  209. dd("自动揽收失败",["message"=>$result["message"],"param"=>$package->logistic_number]);
  210. }
  211. $result = app("OrderService")->allocation($package->order->code,$lineNo);
  212. dump($result);
  213. if (mb_substr($result,0,3)=='000'){
  214. if (OrderPackage::query()->where("id",$package->id)
  215. ->where("collecting_status",'0')->update(["collecting_status"=>'1'])!=1)
  216. dd("自动揽收异常",["message"=>"未能成功修改揽收标记","param"=>$package->toArray()]);
  217. }else dd("自动揽收失败",["message"=>"分配失败:{$result}","param"=>$package->order->code." : {$lineNo}"]);
  218. }
  219. public function test()
  220. {
  221. $a = memory_get_usage();
  222. $tmp = str_repeat('http://blog.huachen.me/', 4000);
  223. $b = memory_get_usage();
  224. dump($b-$a);
  225. dd(Notification::send(User::query()->where("name","zhouzhendong")->get(),
  226. new RoutineNotification(SeeLog::query()->first()->toArray())));
  227. $user = Auth::user();
  228. $remark = "zengjunlj";
  229. $ownerName = 'zengjunlj' ?? '';
  230. $clientCode = 'zengjunljljlj' ?? '';
  231. $msg = $user["name"]."建立了新工单<br/>".$ownerName.":".$clientCode."<br/>".$remark;
  232. NotificationService::SingleRegister($msg,$clientCode,"订单管理-问题件");
  233. dd(1);
  234. $seeLog = SeeLog::query()->find(9);
  235. Notification::send(Auth::user(),new RoutineNotification($seeLog->toArray()));
  236. dd(1);
  237. Broadcast::channel('notification', function ($user, $id) {
  238. return (int) $user->id === (int) $id;
  239. });
  240. dd(1);
  241. Notification::send(Auth::user(),new RoutineNotification($seeLog->toArray()));
  242. dd(1);
  243. $username = config('database.connections.oracle.username');
  244. $password = config('database.connections.oracle.password');
  245. $host = config('database.connections.oracle.host');
  246. $service_name = config('database.connections.oracle.service_name');
  247. $conn = oci_connect($username, $password, $host . '/' . $service_name,"utf8");
  248. $sql = <<<sql
  249. BEGIN
  250. SPSO_HardAllocation_Process('WH01','Allocation','By OrderNO',
  251. null,'SO21090100007','0',null,
  252. 'zhouzhendong',:CODE);
  253. END;
  254. sql;
  255. $stmt = oci_parse($conn, $sql);
  256. $code = "";
  257. oci_bind_by_name($stmt, ':CODE', $code,300);
  258. oci_execute($stmt);
  259. oci_close($conn);
  260. dd($code);
  261. //
  262. $no = "SO21090900001";
  263. $db = DB::connection("oracle");
  264. //$order = $db->selectOne(DB::raw("select * from DOC_ORDER_HEADER where orderno = ?"),[$no]);
  265. dd($db->select($sql,[
  266. ]));
  267. $db->select("CALL SPSO_HardAllocation_Process(?,'Allocation','By OrderNO',null,?,'0',null,'zhouzhendong',@code)",[
  268. $order->warehouseid,$no
  269. ]);
  270. //SPSO_HardAllocation_Process
  271. dd($db->selectOne("select @code"));
  272. $date = "2021-09-14 15:47:00";
  273. dispatch(new TestJob("1"))->delay(Carbon::parse($date));
  274. dispatch(new TestJob("2"))->delay(Carbon::parse($date));
  275. dispatch(new TestJob("3"))->delay(Carbon::parse($date));
  276. dispatch(new TestJob("4"))->delay(Carbon::parse($date));
  277. dispatch(new TestJob("5"))->delay(Carbon::parse($date));
  278. dispatch(new TestJob("6"))->delay(Carbon::parse($date));
  279. dispatch(new TestJob("7"))->delay(Carbon::parse($date));
  280. dispatch(new TestJob("8"))->delay(Carbon::parse($date));
  281. dispatch(new TestJob("9"))->delay(Carbon::parse($date));
  282. dispatch(new TestJob("10"))->delay(Carbon::parse($date));
  283. dd(1);
  284. Station::query()->where("station_type_id", 5)->update(["status" => 1]);
  285. Cache::forget("CACHE_SHELF_AVAILABLE");
  286. $station = ["HAIB1-01-01", "HAIB1-02-01"];
  287. $material = ["IDE0001824", "IDE0001740", "IDE0002710"];
  288. Station::query()->whereIn("code", $station)->update(["status" => 0]);
  289. $stations = Station::query()->whereIn("code", $station)->get();
  290. $materials = MaterialBox::query()->whereIn("code", $material)->get();
  291. $dateTime = date("Y-m-d H:i:s");
  292. $task1 = StationTaskMaterialBox::query()->create([
  293. 'station_id' => $stations[0]->id,
  294. 'material_box_id' => $materials[0]->id,
  295. 'station_task_batch_id' => 1,
  296. 'status' => '待处理'
  297. ]);
  298. $task2 = StationTaskMaterialBox::query()->create([
  299. 'station_id' => $stations[1]->id,
  300. 'material_box_id' => $materials[1]->id,
  301. 'station_task_batch_id' => 1,
  302. 'status' => '待处理'
  303. ]);
  304. $task3 = StationTaskMaterialBox::query()->create([
  305. 'station_id' => 6,
  306. 'material_box_id' => $materials[2]->id,
  307. 'station_task_batch_id' => 1,
  308. 'status' => '待处理'
  309. ]);
  310. TaskTransaction::query()->insert([[
  311. "doc_code" => "test",
  312. "bar_code" => "test",
  313. "to_station_id" => $stations[0]->id,
  314. "material_box_id" => $materials[0]->id,
  315. "task_id" => $task1->id,
  316. "commodity_id" => 505012,//XUNI03
  317. "amount" => 1,
  318. "type" => "出库",
  319. "status" => 0,
  320. "mark" => 2,
  321. "bin_number" => 1,
  322. "created_at" => $dateTime,
  323. "updated_at" => $dateTime,
  324. ], [
  325. "doc_code" => "test",
  326. "bar_code" => "test",
  327. "to_station_id" => $stations[1]->id,
  328. "material_box_id" => $materials[1]->id,
  329. "task_id" => $task2->id,
  330. "commodity_id" => 505012,//XUNI03
  331. "amount" => 1,
  332. "type" => "出库",
  333. "status" => 0,
  334. "mark" => 2,
  335. "bin_number" => 1,
  336. "created_at" => $dateTime,
  337. "updated_at" => $dateTime,
  338. ], [
  339. "doc_code" => "test",
  340. "bar_code" => "test",
  341. "to_station_id" => 6,
  342. "material_box_id" => $materials[2]->id,
  343. "task_id" => $task3->id,
  344. "commodity_id" => 505012,//XUNI03
  345. "amount" => 1,
  346. "type" => "出库",
  347. "status" => 3,
  348. "mark" => 2,
  349. "bin_number" => 1,
  350. "created_at" => $dateTime,
  351. "updated_at" => $dateTime,
  352. ]]);
  353. $foreignHaiRoboticsService = new ForeignHaiRoboticsService();
  354. $toLocation = collect($station);
  355. $taskMaterialBoxes = collect([$task1, $task2]);
  356. $foreignHaiRoboticsService->
  357. fetchGroup_multiLocation($toLocation, $taskMaterialBoxes, '', '立架出至缓存架', 20, false);
  358. foreach ($toLocation as $index => $value) {
  359. app("CacheShelfService")->lightUp($value, '3', '0', ["title" => "机器人取箱中,禁止操作"]);
  360. Cache::forever("CACHE_SHELF_OCCUPANCY_{$stations[$index]->id}", true);
  361. }
  362. app("StationService")->locationOccupyMulti($toLocation->toArray());
  363. }
  364. public function update_order_packages_is_manual_update()
  365. {
  366. $descriptions = Log::query()
  367. ->select('description')
  368. ->whereBetween('created_at', ['2021-08-31 10:30:00', '2021-08-31 10:35:00'])
  369. ->where('class', 'like', 'https://was.baoshi56.com/package/logistic/batchUpdate%')->pluck('description');
  370. foreach ($descriptions as $description) {
  371. $description = substr($description, 9);
  372. $description = \Illuminate\Support\Str::before($description, "}");
  373. $obj = json_decode($description . '}', true);
  374. OrderPackage::query()
  375. ->whereIn('logistic_number', $obj['logistic_numbers'])
  376. ->update([
  377. 'status' => '无',
  378. 'is_manual_update' => false,
  379. ]);
  380. }
  381. }
  382. public function testUpdateInv()
  383. {
  384. ini_set('max_execution_time', 0);
  385. ini_set('memory_limit', '4096M');
  386. $sql = <<<sql
  387. select FMLOTNUM,FMLOCATION,PLANTOLOCATION,CREATE_TRANSACTIONID,SKU,CUSTOMERID from TSK_TASKLISTS
  388. where CUSTOMERID=?
  389. AND FMLOCATION= ?
  390. AND OPENWHO = ?
  391. AND TASKPROCESS = ?
  392. AND DOCTYPE = ?
  393. AND TASKTYPE = ?
  394. AND LOTATT05=?
  395. AND LOTATT08=?
  396. AND PLANTOID = ?
  397. and OPENTIME>=TO_DATE(?,'yyyy-mm-dd hh24:mi:ss')
  398. and OPENTIME<=TO_DATE(?,'yyyy-mm-dd hh24:mi:ss')
  399. sql;
  400. $CUSTOMERID = 'JIANSHANG';
  401. $FMLOCATION = 'STAGEWH02';
  402. $OPENWHO = 'WCS';
  403. $TASKPROCESS = '00';
  404. $DOCTYPE = 'ASN';
  405. $TASKTYPE = 'PA';
  406. $LOTATT05 = 'MJ-CP';
  407. $LOTATT08 = 'ZP';
  408. $PLANTOID = '*';
  409. $traceid = 'JIANSHANG03';
  410. $start = '2021-09-02 23:59:59';
  411. $end = '2021-09-03 11:10:00';
  412. $res = DB::connection("oracle")->select(DB::raw($sql),
  413. [$CUSTOMERID, $FMLOCATION, $OPENWHO, $TASKPROCESS, $DOCTYPE, $TASKTYPE, $LOTATT05, $LOTATT08, $PLANTOID, $start, $end]);
  414. $resItems = array_chunk($res, 200);
  415. foreach ($resItems as $res) {
  416. DB::connection("oracle")->beginTransaction();
  417. try {
  418. foreach ($res as $re) {
  419. DB::connection("oracle")->table('INV_LOT_LOC_ID')
  420. ->where([
  421. 'LOTNUM' => $re->fmlotnum,
  422. 'LOCATIONID' => $re->fmlocation,
  423. 'CUSTOMERID' => $re->customerid,
  424. 'sku' => $re->sku,
  425. 'TRACEID' => '*',
  426. ])
  427. ->update([
  428. 'TRACEID' => $traceid,
  429. 'EDITWHO' => 'WCS_',
  430. ]);
  431. if ($re->fmlocation != $re->plantolocation) {
  432. DB::connection("oracle")->table('INV_LOT_LOC_ID')
  433. ->where([
  434. 'LOTNUM' => $re->fmlotnum,
  435. 'LOCATIONID' => $re->plantolocation,
  436. 'CUSTOMERID' => $re->customerid,
  437. 'sku' => $re->sku,
  438. 'TRACEID' => '*',
  439. ])
  440. ->update([
  441. 'TRACEID' => $traceid,
  442. 'EDITWHO' => 'WCS_',
  443. ]);
  444. }
  445. DB::connection("oracle")->commit();
  446. }
  447. dd(true);
  448. } catch (\Exception $e) {
  449. DB::connection("oracle")->rollBack();
  450. dd($e->getMessage());
  451. }
  452. }
  453. }
  454. /**
  455. * 重置15天内的数据
  456. */
  457. public function order_packages_init()
  458. {
  459. OrderPackage::query()
  460. ->whereBetween('created_at', [now()->subDays(15), now()])
  461. ->update([
  462. 'is_delay_deliver' => 0,
  463. 'sync_routes_flag' => 0,
  464. 'status' => 1,
  465. 'exception_status' => 0,
  466. ]);
  467. OrderPackage::query()
  468. ->whereBetween('created_at', [now()->subDays(15), now()])
  469. ->whereNotNull('received_at')
  470. ->update([
  471. 'status' => 7,
  472. ]);
  473. }
  474. public function syncOrderPackage(){
  475. ini_set('memory_limit','500M');
  476. ini_set('max_execution_time', 0);
  477. $orderPackingSummary = OracleDocOrderPackingSummary::query()
  478. ->where('editTime','>=','2021-09-11 12:00:00')
  479. ->where('editTime','<=','2021-09-12 12:40:00')
  480. ->get();
  481. $orderPackingSummary_chunk = $orderPackingSummary->chunk(200);
  482. foreach ($orderPackingSummary_chunk as $orderPackingSummarys) {
  483. foreach ($orderPackingSummarys as $orderPackingSummary) {
  484. $orderPackage = OrderPackage::query()->where('logistic_number',$orderPackingSummary->traceid)->first();
  485. $orderPackage->update([
  486. 'uploaded_to_wms'=> true,
  487. 'weight'=>$orderPackingSummary->grossweight,
  488. 'length'=>$orderPackingSummary->length,
  489. 'width'=>$orderPackingSummary->width,
  490. 'height'=>$orderPackingSummary->height,
  491. 'weighed_at'=>$orderPackingSummary->edittime
  492. ]);
  493. dispatch(new WeightUpdateInstantBill($orderPackage));
  494. }
  495. }
  496. return ['success' => true];
  497. }
  498. public function collectUpload()
  499. {
  500. /** @var OrderPackageService $service */
  501. $service = app('OrderPackageService');
  502. return $service->collectUpload([
  503. '75810646867541',
  504. '75810646197516'
  505. ]);
  506. }
  507. public function init_在途异常()
  508. {
  509. $logistic_numbers = OrderPackage::query()
  510. ->select('logistic_number')
  511. ->where('exception_status', 5)
  512. ->where('created_at', '>=', now()->subDays(20)->toDateTimeString())
  513. ->pluck('logistic_number');
  514. /** @var OrderPackageReceivedSyncService $service */
  515. $service = app('OrderPackageReceivedSyncService');
  516. $service->syncLogisticRoute(false, $logistic_numbers);
  517. // $logistic_numbers = OrderPackage::query()
  518. // ->select(['logistic_number', 'order_id', 'id'])
  519. // ->whereIn('order_id', function ($query) {
  520. // $query->from('orders')->selectRaw('id')->whereIn('logistic_id', function ($builder) {
  521. // $builder->from('logistics')->selectRaw('id')->where('type', '=', '快递')->whereNotIn('belong_company', ['顺丰', '中通', '韵达', '圆通', '京东']);
  522. // });
  523. // })
  524. // ->where('exception_status', 5)
  525. // ->where('created_at', '>=', now()->subDays(20)->toDateTimeString())
  526. // ->pluck('logistic_number');
  527. // $service->syncLogisticRouteByAliJiSu($logistic_numbers);
  528. }
  529. public function store()
  530. {
  531. ini_set('max_execution_time', 0);
  532. ini_set('memory_limit', '1024M');
  533. // $now = Carbon::now();
  534. // $startDate = $this->getDate();
  535. $startDate = '2021-09-25 13:23:14';
  536. $diffDay = 1; // 天数
  537. for($i = 0;$i<=$diffDay;$i++){
  538. $endDate = Carbon::parse($startDate)->addDays(1)->toDateTimeString();
  539. $doc_asn_headers = $this->getDocAsnHeader($startDate,$endDate);
  540. // if (count($doc_asn_headers)>0){
  541. // $this->syncStores($doc_asn_headers);
  542. // $this->syncDate($endDate);
  543. // }
  544. dump($startDate,$endDate);
  545. $startDate = $endDate;
  546. }
  547. $this->clearCache();
  548. // ValueStore::query()->updateOrCreate([
  549. // 'name' => 'last_asn_sync_task_end_at',
  550. // ], [
  551. // 'name' => 'last_asn_sync_task_end_at',
  552. // 'value' => $now,
  553. // ]);
  554. }
  555. public function getDocAsnHeader($startDate,$endDate)
  556. {
  557. return OracleDOCASNHeader::query()
  558. ->with(['asnType', 'asnStatus'])
  559. ->select('asnno','asnstatus','asntype','addtime','edittime','customerid','notes','warehouseid','asnreference3','asnreference2')
  560. ->where('EditTime', '>=', $startDate)
  561. ->where('EditTime', '<=', $endDate)
  562. ->whereColumn('EditTime', '<>', 'addTime')
  563. ->orderByDesc('EditTime')
  564. ->get();
  565. }
  566. public function getDate(){
  567. return ValueStore::query()->where('name','asn_last_updated_sync_at')->value('value');
  568. }
  569. public function syncStores($doc_asn_headers){
  570. $service = new StoreService();
  571. $service->createStore($doc_asn_headers,"update");
  572. $service->updateStore($doc_asn_headers);
  573. $service->createStoreRejected($doc_asn_headers);
  574. unset($doc_asn_headers);
  575. }
  576. public function syncDate($date)
  577. {
  578. // 同步更新时间
  579. ValueStore::query()->updateOrCreate([
  580. 'name' => 'asn_last_updated_sync_at',
  581. ], [
  582. 'name' => 'asn_last_updated_sync_at',
  583. 'value' => $date,
  584. ]);
  585. }
  586. public function clearCache()
  587. {
  588. $service = new StoreService();
  589. $update_set = config('sync.asn_sync.cache_prefix.update_set');
  590. $update_keys = config('sync.asn_sync.cache_prefix.update_keys');
  591. $service->deleteCacheKey($update_set, $update_keys);
  592. // 清空保存 ans 号的栈
  593. // 清除 更新时间 开始 结束
  594. }
  595. public function updateStoreItem()
  596. {
  597. ini_set('max_execution_time', 0);
  598. ini_set('memory_limit', '1024M');
  599. $storeIds = Store::query()
  600. ->where('updated_at', '>=', '2021-09-25 13:21:26')
  601. ->whereColumn('updated_at', '<>', 'created_at')
  602. ->pluck('id');
  603. $storeItemMaxIds = StoreItem::query()
  604. ->selectRaw('max(id) as max_id')
  605. ->whereIn('store_id', $storeIds)
  606. ->groupBy(['store_id', 'asn_line_code'])
  607. ->get();
  608. // dd($storeItemMaxIds->count());
  609. $storeItems = StoreItem::query()
  610. ->whereIn('store_id', $storeIds)
  611. ->whereNotIn('id', $storeItemMaxIds)
  612. ->delete();
  613. }
  614. public function init_SettlementBillReportTask()
  615. {
  616. $this->dispatch(new SettlementBillReportJob('2021-08-01',[]));
  617. }
  618. public function test2(){
  619. $source_file ="E:\OneDrive\桌面\工作目录\文件库\\5.jpg";
  620. $img = ImageCreateFromJpeg($source_file);
  621. imagecolortransparent($img);//将某个颜色设置成透明色
  622. imagecolorstotal($img);
  623. header('Content-type:image/jpeg');
  624. imagejpeg($img);
  625. //dd($this->run('E:\OneDrive\桌面\工作目录\文件库\5.jpg', 'E:\OneDrive\桌面\工作目录\文件库\6.jpg'));
  626. }
  627. const FILE_NOT_FOUND = '-1';
  628. const FILE_EXTNAME_ILLEGAL = '-2';
  629. public function run($src1, $src2) {
  630. if(!is_file($src1) || !is_file($src2)) exit(self::FILE_NOT_FOUND);
  631. $hash1 = $this->getHashValue($src1);
  632. $hash2 = $this->getHashValue($src2);
  633. if(strlen($hash1) !== strlen($hash2)) return false;
  634. $count = 0;
  635. $len = strlen($hash1);
  636. for($i = 0; $i < $len; $i++) if($hash1[$i] !== $hash2[$i]){
  637. $count++;
  638. }
  639. dd($count);
  640. return $count <= 10 ? true : false;
  641. }
  642. public function getImage($file) {
  643. $extname = pathinfo($file, PATHINFO_EXTENSION);
  644. if(!in_array($extname, ['jpg','jpeg','png','gif'])) exit(self::FILE_EXTNAME_ILLEGAL);
  645. $img = call_user_func('imagecreatefrom'. ( $extname == 'jpg' ? 'jpeg' : $extname ) , $file);
  646. return $img;
  647. }
  648. public function getHashValue($file) {
  649. $w = 32;
  650. $h = 32;
  651. $img = imagecreatetruecolor($w, $h);
  652. list($src_w, $src_h) = getimagesize($file);
  653. $src = $this->getImage($file);
  654. imagecopyresampled($img, $src, 0, 0, 0, 0, $w, $h, $src_w, $src_h);
  655. imagedestroy($src);
  656. $total = 0;
  657. $array = array();
  658. for( $y = 0; $y < $h; $y++) {
  659. for ($x = 0; $x < $w; $x++) {
  660. $rgb = imagecolorat($img, $x, $y);
  661. $gray = $rgb & 0xFF;
  662. /*dump([
  663. ($rgb >> 8) & 0xFF,
  664. ($rgb >> 16) & 0xFF,
  665. $rgb & 0xFF,
  666. ]);*/
  667. if(!isset($array[$y])) $array[$y] = array();
  668. $array[$y][$x] = $gray;
  669. $total += $gray;
  670. }
  671. }
  672. imagedestroy($img);
  673. $average = intval($total / ($w * $h * 2));
  674. $hash = '';
  675. for($y = 0; $y < $h; $y++) {
  676. for($x = 0; $x < $w; $x++) {
  677. $hash .= ($array[$y][$x] >= $average) ? '1' : '0';
  678. }
  679. }
  680. dump($hash);
  681. return $hash;
  682. }
  683. }