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\MaterialBoxModel;
use App\Owner;
use App\OwnerFeeDetail;
use App\OwnerPriceOperation;
use App\OrderPackageCountingRecord;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Cache;
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','2');
    }
    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());
    }
    public function test()
    {
        MaterialBoxModel::query()->where("id","!=",1)->delete();
        MaterialBoxModel::query()->where("id",1)->update([
            "description" => "单商品料箱"
        ]);
    }

    public function addRecord()
    {
        $yesterday = '2021-06-08';
        $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()
    {
        Cache::pull('weight.2021-06-06');
    }

}