mall/plugins/product_traceability/models/client/ProductBatchProcessDetailForm.php

<?php
/**
 * 重庆赤晓店信息科技有限公司
 * https://www.chixiaodian.com
 * Copyright (c) 2023 赤店商城 All rights reserved.
 */
namespace app\plugins\product_traceability\models\client;


use app\models\Goods;
use app\models\SaasUser;
use app\models\Shop;
use app\models\Store;
use app\models\User;

use app\plugins\food\models\FoodOrderDetail;
use app\plugins\product_traceability\models\Product;
use app\plugins\product_traceability\models\ProductBatch;
use app\plugins\product_traceability\models\ProductBatchProcess;
use app\plugins\product_traceability\models\ProductBatchProcessLog;
use app\plugins\product_traceability\models\ProductBatchProcessLogSheet;
use app\utils\Tools;
use yii\base\Model;
use yii\data\Pagination;
use yii\helpers\Json;
use yii\helpers\Json as HelpersJson;

class ProductBatchProcessDetailForm extends Model
{
    public $store_id;
    public $user_id;
    public $product_batch_id;
    public $page;
    public $limit;


    public function rules()
    {
        return [
            [['store_id', 'user_id', 'product_batch_id'], 'required'],
            [['page', 'limit'], 'integer'],
            [['page'], 'default', 'value' => 1],
            [['limit'], 'default', 'value' => 20],
        ];
    }

    public function search()
    {
        if (!$this->validate()) {
            return ['code' => 1, 'msg' => $this->getErrorSummary(false)[0]];
        }

        $product_batch_info =
//            ProductBatchProcess::find()->alias('pbp')
//            ->innerJoin(['pbpl' => ProductBatchProcessLog::tableName()], 'pbp.id=pbpl.product_batch_process_id')
//            ->leftJoin(['pb' => ProductBatch::tableName()], 'pb.id=pbp.product_batch_id')
            ProductBatch::find()->alias('pb')
            ->leftJoin(['p' => Product::tableName()], 'p.id=pb.product_id')
            ->where([
                'pb.is_delete' => 0,
                'pb.store_id' => get_store_id(),
//                'pbp.process_user_id' => $this->user_id,
                'pb.id' => $this->product_batch_id
            ])
            ->select(['pb.batch_number', 'pb.batch_name', 'p.product_name', 'p.updated_at'])->asArray()->one();
        $product_batch_info['updated_at'] = date("Y-m-d H:i:s", $product_batch_info['updated_at']);
        $query = ProductBatchProcess::find()->alias('pbp')
            ->innerJoin(['pbpl' => ProductBatchProcessLog::tableName()], 'pbp.id=pbpl.product_batch_process_id')
            ->leftJoin(['pb' => ProductBatch::tableName()], 'pb.id=pbp.product_batch_id')
//            ->innerJoin(['pbpls' => ProductBatchProcessLogSheet::tableName()], 'pbpls.process_log_id=pbpl.id')
            ->where([
                'pbp.is_delete' => 0,
                'pbp.store_id' => get_store_id(),
                'pbpl.state' => 1,
                'pb.id' => $this->product_batch_id
            ])
            ->select([ 'pbp.process_name', 'pbpl.id as process_log_id']);

        $count = $query->count();
        $pagination = new Pagination(['totalCount' => $count, 'page' => $this->page - 1, 'pageSize' => $this->limit]);
        $list = $query->limit($pagination->limit)->offset($pagination->offset)->asArray()->all();

        foreach ($list as $k => $v) {
            $list[$k]['sheet_list'] = ProductBatchProcessLogSheet::find()->where(['process_log_id' => $v['process_log_id'], 'is_delete' => 0])->all();
        }

        return [
            'code' => 0,
            'msg' => 'success',
            'data' => [
                'row_count' => $count,
                'page_count' => $pagination->pageCount,
                'list' => $list,
                'product_batch_info' => $product_batch_info,
            ],
        ];
    }
}