thinkphp5 sql语句中concat拼接查询字段

拼接查询字段一

$batch = $BatchModel
            ->alias('a')
            ->leftJoin("school b", "a.schoolId = b.id")
            ->leftJoin("admin c", "a.adminId = c.id")
            ->where($where)
            ->field("a.*,b.name as schoolName,c.name as updateUser,CONCAT(a.batchNum,a.id) as batchNum")
            ->order('a.id desc')
            ->page($page, $limit)
            ->select()
            ->toArray();

$rs = $ApplyModel
            ->alias('a')
            ->leftJoin("goods g", "a.goodsId = g.id")
            ->leftJoin("container c", "a.cabinetId = c.id")
            ->where($where)
            ->field("
            a.id,
            a.goodsId,
            a.goodsName,
            a.packNum * a.perBoxNum as sumGoodsNum,
            round(a.packNum * a.perNetWeight,2) as sumNetWeight,
            round(a.packNum * a.perGrossWeight,2) as sumGrossWeight,
            round(a.packNum * a.perCube,6) as sumCube,
            g.name as goodsName2,            
            c.number as cabinetNumber,
            CASE WHEN a.image = '' THEN '' ELSE CONCAT('" . Config::get('app.domain.' . Config::get('app.env')) . Config::get('app.image_path') . "images/',  a.image) END as image
            ")
            ->select();