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

<?php

namespace App\Http\Controllers;

use App\Components\AsyncResponse;
use App\Components\ErrorPush;
use App\ErrorTemp;
use App\Feature;
use App\Jobs\OrderCreateWaybill;
use App\MaterialBox;
use App\MaterialBoxModel;
use App\Order;
use App\Owner;
use App\OwnerFeeDetail;
use App\OwnerPriceOperation;
use App\OrderPackageCountingRecord;
use App\RejectedBill;
use App\Services\ForeignHaiRoboticsService;
use App\Services\StationService;
use App\Services\StorageService;
use App\Station;
use App\StationTask;
use App\StationTaskMaterialBox;
use App\TaskTransaction;
use App\Unit;
use App\Waybill;
use Carbon\Carbon;
use Carbon\CarbonPeriod;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Cookie;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Http;

class TestController extends Controller
{
    use AsyncResponse,ErrorPush;
    const ASNREFERENCE_2 = 'ASNREFERENCE2';
    private $data = [];

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

    public function method(Request $request, $method)
    {
        return call_user_func([$this, $method], $request);
    }
    public function lightUp()
    {
        app("CacheShelfService")->lightUp('HAIB1-02-02','3','0');
    }
    public function lightOff()
    {
        $params = [
            "areaCode" => "1004",
            'locCode' => "HAIB1-02-02",
            'PTLAction' => 0,
        ];
        $response = Http::post(config('api.haiq.storage.light'), $params);
        return json_decode($response->body());
    }
    private $key = "CACHE_SHELF_AVAILABLE";
    public function test()
    {
        $s = new StationService();
        dd($s->getCacheShelf(true,true));

    }

    //快递称重 生成历史数据
    public function addRecord(Request $request)
    {
        $start =  Carbon::parse(request("month"))->startOfMonth();
        $end = Carbon::parse(request('month'))->endOfMonth();

        foreach (CarbonPeriod::create($start,$end) as $date){
            /** @var $date Carbon */
            $yesterday = $date->format("Y-m-d");
            $sql = <<<sql
SELECT DATE_FORMAT(order_packages.created_at,'%Y-%m-%d') date,IFNULL(order_packages.measuring_machine_id,0) measuring_machine_id,order_packages.owner_id,
SUM(CASE WHEN order_packages.weighed_at IS NOT NULL THEN 1 ELSE 0 END) AS count,
COUNT(1) total FROM order_packages LEFT JOIN orders ON order_packages.order_id=orders.id
WHERE orders.wms_status != '订单取消'
AND order_packages.created_at BETWEEN '{$yesterday} 00:00:00' AND '{$yesterday} 23:59:59' GROUP BY date,order_packages.measuring_machine_id,order_packages.owner_id
sql;
            $result = DB::select(DB::raw($sql));
            if (!$result) {
                $obj = [
                    "targeted_at" => $yesterday,
                    "un_weigh_count" => 0,
                    "total_count" => 0,
                    "measuring_machine_id" => 0,
                    "owner_id" => 0
                ];
                $model = OrderPackageCountingRecord::query()->create($obj);
                Cache::put("weight.".$yesterday, $obj);
            }else{
                $objs = [];
                foreach ($result as $v){
                    $obj = [
                        "targeted_at"    => $v->date,
                        "un_weigh_count" => $v->count,
                        "total_count"    => $v->total,
                        "measuring_machine_id"    => $v->measuring_machine_id,
                        "owner_id"    => $v->owner_id
                    ];
                    $model = OrderPackageCountingRecord::query()->create($obj);
                    array_push($objs, $obj);
                }
                Cache::put("weight.".$yesterday, $objs);
            }
        }
    }

    public function redis()
    {
        $start = 1606752000;$end = 1627747200;
        $len = ($end - $start) / 86400;
        for ($i=0; $i <= $len ; $i ++){
            $date = date("Y-m-d", $start + $i * 86400);
            Cache::pull('weight.'.$date);
        }

    }
}