1

YM

2025-04-10 c4782840b8893dcc0bcf262153374237f40f6b9e

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
<?php
/**
+-----------------------------------------------------------------------------------------------
* GouGuOPEN [ 左手研发，右手开源，未来可期！]
+-----------------------------------------------------------------------------------------------
* @Copyright (c) 2021~2024 http://www.gouguoa.com All rights reserved.
+-----------------------------------------------------------------------------------------------
* @Licensed 勾股OA，开源且可免费使用，但并不是自由软件，未经授权许可不能去除勾股OA的相关版权信息
+-----------------------------------------------------------------------------------------------
* @Author 勾股工作室 <hdm58@qq.com>
+-----------------------------------------------------------------------------------------------
*/
 
declare (strict_types = 1);
 
namespace app\home\controller;
 
use app\base\BaseController;
use backup\Backup;
use think\facade\Db;
use think\facade\View;
 
class Area extends BaseController
{
    //数据表列表
    public function datalist()
    {
        if (request()->isAjax()) {
            $area = Db::name('Area')->select();
            $list = generateTree($area);
            return to_assign(0, '', $list);
        }
        else{
            $db = new Backup();
            $is_area = $db->check_table('area');
            View::assign('is_area', $is_area);
            return view();
        }
    }
 
    //新增/编辑
    public function add()
    {
        $param = get_params();
        $id = isset($param['id']) ? $param['id'] : 0;
        $pid = isset($param['pid']) ? $param['pid'] : 0;
        if (request()->isAjax()) {
            $param['level'] = 1;
            if($pid > 0){
                $level = Db::name('Area')->where('id', $pid)->value('level');
                $param['level'] = $level+1;
            }
            if ($param['id'] > 0) {
                Db::name('Area')->strict(false)->field(true)->update($param);
                add_log('edit', $param['id'], $param);
            } else {
                $param['create_time'] = time();
                $rid = Db::name('Area')->strict(false)->field(true)->insertGetId($param);
            }
            return to_assign();
        } else {
            if ($id > 0) {
                $detail = Db::name('Area')->where('id', $id)->find();
                $detail['pname'] = Db::name('Area')->where('id', $detail['pid'])->value('name');
                View::assign('detail', $detail);
            }
            $pname='';
            if($pid>0){
                $pname = Db::name('Area')->where('id', $pid)->value('name');
            }
            View::assign('id', $id);
            View::assign('pid', $pid);
            View::assign('pname', $pname);
            return view();
        }
    }
 
    //设置
    public function set()
    {
        if (request()->isPost()) {
            $db = new Backup();
            $is_area = $db->check_table('area');
            if($is_area==0){
                $oa_area = file_get_contents(CMS_ROOT . '/public/static/home/file/oa_area.sql');
                $res = $db->run_sql($oa_area);
                if($res){
                    add_log('import', 0, []);
                    return to_assign();
                }
                else{
                    return to_assign(1, '数据写入失败，请联系官方！');
                }    
            }
        }
        else if (request()->isDelete()) {
            $params = get_params();
            $log_type = 'recovery';
            if($params['status']==0){
                $count = Db::name('Area')->where(["pid" => $params['id']])->count();
                if ($count > 0) {
                    return to_assign(1, "该记录下还有子记录，无法禁用");
                }
                $log_type = 'disable';
            }
            if (Db::name('Area')->where(["id" => $params['id']])->update(['status'=>$params['status']]) !== false) {
                add_log($log_type, $params['id'], []);
                return to_assign();
            } else {
                return to_assign(1, "操作失败");
            }
        } else {
            return to_assign(1, "错误的请求");
        }
    }
 
}