qimall/addons/CloudStock/common/models/CloudStockImportStockFailLog.php

<?php

namespace addons\CloudStock\common\models;

use common\components\CsvExport;
use common\enums\StatusEnum;
use common\models\base\BaseActiveRecord;
use PHPUnit\Util\Exception;
use Yii;

/**
 * This is the model class for table "addons_cloud_stock_import_stock_fail_log".
 *
 *
 * @property int $id
 * @property int $mall_id 商城ID
 * @property int $log_id 导入批次id
 * @property int $user_id 用户id
 * @property int $goods_id 商品id
 * @property int $num 数量
 * @property string $reason 失败原因
 * @property string|null $extra 导入的内容
 * @property int $updated_at
 * @property int $created_at 添加时间
 */
class CloudStockImportStockFailLog extends BaseActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%addons_cloud_stock_import_stock_fail_log}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['mall_id', 'log_id', 'user_id','goods_id','num','updated_at', 'created_at'], 'integer'],
            [['extra'], 'string'],
            [['reason'], 'string', 'max' => 255],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'mall_id' => '商城ID',
            'log_id' => '导入批次id',
            'user_id' => '用户id',
            'goods_id' => '商品id',
            'num' => '数量',
            'reason' => '失败原因',
            'extra' => '导入的内容',
            'updated_at' => 'Updated At',
            'created_at' => '添加时间',
        ];
    }
    /**
     * @param array $where
     * @param string $select
     * @param array $with
     * @param int $is_array
     * @return array
     */
    public static function getList(array $where, $select = '*', array $with = [], int $is_array = 0)
    {
        $query = self::find();
        self::paramPack(['where' => $where, 'with' => $with], $query);
        return $query->select($select)->asArray($is_array)->all();
    }
    public static function packFailArr($param, $fail_arr, $fail_counts)
    {
        $fail_counts++;
        $param['extra'] = json_encode($param);
        $fail_arr[] = $param;
        return [$fail_arr, $fail_counts];
    }

    /**
     * 保存数据
     * @param array $params
     * @param $log_id
     * @return bool
     */
    public static function setData(array $params, $log_id)
    {
        try {
            foreach ($params as $param) {
                $model = new self();
                $model->loadDefaultValues();
                $param['log_id'] = $log_id;
                if (!$model->load($param, '') || !$model->save()) throw new Exception($model->getErrorMessage());
            }
            return true;
        } catch (Exception $e) {
            self::$static_error = $e->getMessage();
            return false;
        }
    }

    public static function exportFailLog($params){
        $csv = new CsvExport();
        $list = self::getList([['log_id' => $params['log_id']]]);
        $file_name = date('YmdHis', time());
        $head_list = ["序号", "用户id", "商品id","数量",'失败原因'];
        $arr = [];
        foreach ($list as $k => $val) {
            $row = [];
            $extra = json_decode($val['extra'], true);
            $row[] = $k + 1;
            $row[] = $extra['user_id'];
            $row[] = $extra['goods_id'];
            $row[] = $extra['num'];
            $row[] = $val['reason'];
            $arr[] = $row;
        }
        return $csv->export($arr, $head_list, $file_name);
    }
}