Yii Model通用

#新建
public function createInfo($info)
{
        self::getDb()
            ->createCommand()
            ->insert(‘DB Name', $info)
            ->execute();
        return self::getDb()->getLastInsertID();
        return $query->createCommand()->getRawSql();
}

#更新
public function updateInfo($where,$updateInfo)
{
        return self::updateAll($updateInfo,$where);
}

#查询
public function getInfo($params=[],$isAll='',$indexBy='',$select='',$order='',$groupBy=‘')
{
        $query = self::find();
        if (!empty($select)) {
            $query->select($select);
        }
        foreach ($params as $key => $value) {
            if (!empty($key) && !empty($value)) {
                $query->andWhere([$key => $value]);
            }
        }
        if (!empty($indexBy)) {
            $query->indexBy($indexBy);
        }
        if (!empty($order)) {
            $query->orderBy($order);
        }
        if (!empty($groupBy)) {
            $query->groupBy($groupBy);
        }
        if (empty($isAll)) {
            return $query->asArray()->one();
        } else {
            return $query->asArray()->all();
        }
}