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

<?php
/**
 * Created by PhpStorm.
 * User: liying
 * Date: 2018/5/24
 * Time: 10:58
 */

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(){
//       SystemCleardata::ClearData('user',1);
        $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);
        }
    }
}