baoshi-was/app/Http/Controllers/TestController.php

<?php

namespace App\Http\Controllers;

use App\Components\AsyncResponse;
use App\Components\Database;
use App\Components\ErrorPush;
use App\MaterialBox;
use App\MaterialBoxModel;
use App\Order;
use App\OrderDetail;
use App\OrderIssue;
use App\OrderIssueRejectedBill;
use App\RejectedBill;
use App\Services\common\BatchUpdateService;
use App\Services\OrderRejectedBillRelationService;
use App\Services\OrderRejectingStatusService;
use App\Services\RejectedService;
use App\User;
use App\Waybill;
use Illuminate\Database\Capsule\Manager;
use Illuminate\Database\DatabaseManager;
use Illuminate\Foundation\Auth\AuthenticatesUsers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Facades\Log;
use Oursdreams\Export\Export;

class TestController extends Controller
{
    use AsyncResponse, ErrorPush, Database;

    const ASNREFERENCE_2 = 'ASNREFERENCE2';

    public function __construct()
    {
        $this->data["active_test"] = "active";
    }

    public function method(Request $request, $method)
    {
        try {
            return call_user_func([$this, $method], $request);
        }catch (\BadMethodCallException $e){
            dd("方法不存在");
        }
    }
    public function test($main, $x)
    {
        return;
        $db = DB::connection("aliyunMysql");
        foreach ($db->select(DB::raw("select * from equipments where code like 'W4%' and info is not null and id <= 4972")) as $eq){
            $arr = str_split ($eq->code);
            if (strlen($main)==2){
                $arr1 = str_split ($main);
                $arr[4] = $arr1[0];
                $arr[5] = $arr1[1];
            }else{
                $arr[5] = $main;
            }
            $code = implode("",$arr);

            $obj = json_decode($eq->info);
            $obj->x +=$x;
            $db->insert("insert into equipments(code,parent_id,info,depth,width,created_at,updated_at,warehouse_detail_id)
values(?,null,?,?,?,?,?,1)",[$code,json_encode($obj),$eq->depth,$eq->width,now()->toDateTimeString(),now()->toDateTimeString()]);

            $a = $db->selectOne("select * from equipments where parent_id is null and code = ? ",[$code]);
            foreach ($db->select("select * from equipments where parent_id = ?",[$eq->id]) as $item){
                $arr = str_split ($item->code);
                if (strlen($main)==2){
                    $arr1 = str_split ($main);
                    $arr[4] = $arr1[0];
                    $arr[5] = $arr1[1];
                }else{
                    $arr[5] = $main;
                }
                $code = implode("",$arr);
                $db->insert("insert into equipments(code,parent_id,info,depth,width,height,location_tab,created_at,updated_at,warehouse_detail_id)
values(?,?,null,?,?,?,?,?,?,2)",[$code,$a->id,$item->depth,$item->width,$item->height,$item->location_tab,now()->toDateTimeString(),now()->toDateTimeString()]);
            }
        }
    }
    public function test2(){
        return;
        $db = DB::connection("aliyunMysql");
        foreach ($db->select("select * from equipments where (code like 'W3%') and info is not null") as $eq){
            $obj = json_decode($eq->info);
            $obj->x -= 105;
            $db->update("UPDATE equipments SET info = ? where id = ?",[json_encode($obj),$eq->id]);
        }
    }

    public function test1(Request $request){
        return;
        $x = 0;
        $a1 = 8 + 30;
        $a2 = 80 + 30;
        $a3 = 32 + 30;
    }
    use AuthenticatesUsers;

    public function test3($request){
        dd(Hash::make("wangyan"));
    }

    public function testOrder()
    {
        /** @var OrderRejectedBillRelationService $service */
        $service = app('OrderRejectedBillRelationService');
        $service->orderSyncRejectedBill(Order::find(3));
    }

    public function testRejectedBill()
    {
        /** @var OrderRejectedBillRelationService $service */
        $service = app(OrderRejectedBillRelationService::class);
        /** @var RejectedBill $item */
        $item = RejectedBill::query()->orderByDesc('id')->first();
        $service->rejectedBillSyncOrder($item);
    }

    public function getOrder()
    {

        $query = Order::query()->select('id')->where('client_code','22011700000161');
        dd(OrderDetail::query()->whereIn('order_id',$query)->get());
    }

    public function syncOrderIssue()
    {
        $items = OrderIssueRejectedBill::query()->with('orderIssue')->get();
        $item_array = $items->chunk(500);

        foreach ($item_array as $items){
            $insert_params = [];
            $update_params = [['logistic_number_return','order_id']];
            foreach ($items as $item){
                $insert_params[] = [
                    'order_id' => $item->orderIssue->order_id,
                    'is_new_rejecting' => $item->orderIssue->is_new_rejecting,
                    'rejecting_status' => $item->orderIssue->rejecting_status
                ];
                $update_params[] = ['logistic_number_return' => $item->logistic_number_return,'order_id' => $item->orderIssue->order_id];
            }
            $this->batchOrderIssueRejectedBIll($update_params);
            OrderDetail::query()->insert($insert_params);
        }
    }

    public function batchOrderIssueRejectedBIll($array)
    {
        /** @var BatchUpdateService $service */
        $service = app(BatchUpdateService::class);
        $service->batchUpdate('order_issue_rejected_bill',$array);
    }
}