zyedu/application/admin/controller/system/SystemCleardata.php

<?php
// +----------------------------------------------------------------------
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2016～2022 https://www.crmeb.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
// +----------------------------------------------------------------------
// | Author: CRMEB Team <admin@crmeb.com>
// +----------------------------------------------------------------------


namespace app\admin\controller\system;


use app\admin\controller\AuthController;
use app\admin\model\user\User;
use app\admin\model\wechat\WechatUser;
use service\JsonService as Json;
use think\db;
use think\Config;

/**
 * 清除默认数据理控制器
 * Class SystemCleardata
 * @package app\admin\controller\system
 *
 */
class SystemCleardata extends AuthController
{
    public function index()
    {

        return $this->fetch();
    }

    //清除用户数据
    public function UserRelevant()
    {
        SystemCleardata::ClearData('user_recharge', 1);
        SystemCleardata::ClearData('user_address', 1);
        SystemCleardata::ClearData('user_bill', 1);
        SystemCleardata::ClearData('user_enter', 1);
        SystemCleardata::ClearData('user_extract', 1);
        SystemCleardata::ClearData('user_notice', 1);
        SystemCleardata::ClearData('user_notice_see', 1);
        SystemCleardata::ClearData('wechat_qrcode', 1);
        SystemCleardata::ClearData('wechat_message', 1);
        SystemCleardata::ClearData('store_coupon_user', 1);
        SystemCleardata::ClearData('store_coupon_issue_user', 1);
        SystemCleardata::ClearData('store_bargain_user', 1);
        SystemCleardata::ClearData('store_bargain_user_help', 1);
        SystemCleardata::ClearData('store_product_reply', 1);
        $this->delDirAndFile('./public/uploads/store/comment');
        SystemCleardata::ClearData('store_product_relation', 1);
        return Json::successful('清除数据成功!');
    }

    //清除商城数据
    public function storedata()
    {
        SystemCleardata::ClearData('store_coupon', 1);
        SystemCleardata::ClearData('store_coupon_issue', 1);
        SystemCleardata::ClearData('store_bargain', 1);
        SystemCleardata::ClearData('store_combination', 1);
        SystemCleardata::ClearData('store_product_attr', 1);
        SystemCleardata::ClearData('store_product_attr_result', 1);
        SystemCleardata::ClearData('store_product_attr_value', 1);
        SystemCleardata::ClearData('store_seckill', 1);
        SystemCleardata::ClearData('store_product', 1);
        $this->delDirAndFile('./public/uploads/store/product');

        return Json::successful('清除数据成功!');
    }

    //清除产品分类
    public function categorydata()
    {
        SystemCleardata::ClearData('store_category', 1);
        $this->delDirAndFile('./public/uploads/store/product');
        return Json::successful('清除数据成功!');
    }

    //清除订单数据
    public function orderdata()
    {
        SystemCleardata::ClearData('store_order', 1);
        SystemCleardata::ClearData('store_order_cart_info', 1);
        SystemCleardata::ClearData('store_order_copy', 1);
        SystemCleardata::ClearData('store_order_status', 1);
        SystemCleardata::ClearData('store_pink', 1);
        SystemCleardata::ClearData('store_cart', 1);
        return Json::successful('清除数据成功!');
    }

    //清除客服数据
    public function kefudata()
    {
        SystemCleardata::ClearData('store_service', 1);
        $this->delDirAndFile('./public/uploads/store/service');
        SystemCleardata::ClearData('store_service_log', 1);
        return Json::successful('清除数据成功!');
    }

    //修改用户默认密码
    public function userdate()
    {
        $headimgurl = WechatUser::Where('uid', 1)->value('headimgurl');
        $data['account'] = 'crmeb';
        $data['pwd'] = md5(123456);
        $data['avatar'] = $headimgurl;
        $data['add_time'] = time();
        $data['status'] = 1;
        $data['level'] = 0;
        $data['user_type'] = "wechat";
        $data['is_promoter'] = 1;
        User::create($data);
        return Json::successful('清除数据成功!');
    }

    //清除微信管理数据
    public function wechatdata()
    {
        SystemCleardata::ClearData('wechat_media', 1);
        SystemCleardata::ClearData('wechat_reply', 1);
        SystemCleardata::ClearData('wechat_news_content', 1);
        SystemCleardata::ClearData('wechat_news', 1);
        SystemCleardata::ClearData('wechat_news_category', 1);
        $this->delDirAndFile('./public/uploads/wechat');
        return Json::successful('清除数据成功!');
    }

    //清除所有附件
    public function uploaddata()
    {
        $this->delDirAndFile('./public/uploads');
        return Json::successful('清除上传文件成功!');
    }

    //清除微信用户
    public function wechatuserdata()
    {
        $data = WechatUser::get(1)->toArray();
        SystemCleardata::ClearData('wechat_user', 1);
        unset($data['uid']);
        WechatUser::set($data);
        return Json::successful('清除数据成功!');
    }

    //清除内容分类
    public function articledata()
    {
        SystemCleardata::ClearData('article_category', 1);
        $this->delDirAndFile('./public/uploads/article/');
        return Json::successful('清除数据成功!');
    }

    //清除制定表数据
    public function ClearData($table_name, $status)
    {
        $table_name = Config::get('database')['prefix'] . $table_name;
        if ($status) {
            db::query('TRUNCATE TABLE ' . $table_name);
        } else {
            db::query('DELETE FROM' . $table_name);
        }

    }

    //递归删除文件
    function delDirAndFile($dirName, $subdir = true)
    {
        if ($handle = opendir("$dirName")) {
            while (false !== ($item = readdir($handle))) {
                if ($item != "." && $item != "..") {
                    if (is_dir("$dirName/$item"))
                        $this->delDirAndFile("$dirName/$item", false);
                    else
                        @unlink("$dirName/$item");
                }
            }
            closedir($handle);
            if (!$subdir) @rmdir($dirName);
        }
    }
}