提交

chengkun

2025-08-19 a4917f837e649e8288f37d386159005a6f415b85

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
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
<?php
 
namespace app\admin\controller;
 
use think\Exception;
use think\facade\Db;
use think\facade\View;
use think\facade\Request;
use \app\admin\validate\DeliverRegion as DeliverRegionValidate;
 
class DeliverRegion extends Common {
    
    /**
     * 分销区域列表
     * @return string
     */
    public function index() {
        ////////
        if (!Request::isPost()) {
            return View::fetch();
        } else {
            try {
                $kw = input('kw');
                if (!empty($kw)) {
                    $condition[] = array('region_name|region_code', 'like', "%$kw%");
                }
                $p = input('p', 1);
                $other['page_size'] = input('page_size', 20);
                $order = 'order_id asc,deliver_region_id asc';
                $count = Db::name('deliver_region')->where($condition)->count();
                $list = Db::name('deliver_region')->field("*")->where($condition)->order($order)->page($p, $other['page_size'])->select()->toArray();
                $other['count'] = $count;
                if (!$list) {
                    $list = [];
                }
                $result['other'] = $other;
                $result['list'] = $list;
                return $this->successResponse($result);
            } catch (Exception $exc) {
                return $this->errorResponse($exc->getMessage());
            }
        }
    }
    
    /**
     *保存分销区域
     */
    public function save() {
        if (!Request::isPost()) {
            return $this->errorResponse(lang('request_method_incorrect'));
        }
        //开始事务
        Db::startTrans();
        try {
            $data = Request::post();
            $validate = new DeliverRegionValidate();
            $check_result = $validate->check($data);
            if (!$check_result) {
                return $this->errorResponse($validate->getError());
            }
            $deliver_region_id = input('post.deliver_region_id');
            if (is_numeric($deliver_region_id)) {
                //更新数据
                $update_result = Db::name('deliver_region')->where('deliver_region_id', $deliver_region_id)->withoutField('id')->save($data);
                if ($update_result === FALSE) {
                    return $this->errorResponse(lang('editing_failed'));
                }
                //提交事务
                Db::commit();
                return $this->successResponse('修改成功！');
            } else {
                //添加数据
                unset($data['deliver_region_id']);
                $add_result = Db::name('deliver_region')->insertGetId($data);
                if (!$add_result) {
                    return $this->errorResponse('添加失败！');
                }
                Db::name('deliver_region')->where('deliver_region_id', $add_result)->save(['order_id' => $add_result]);
                //提交事务
                Db::commit();
                return $this->successResponse('添加成功！');
            }
        } catch (Exception $exc) {
            // 回滚事务
            Db::rollback();
            return $this->errorResponse($exc->getMessage());
        }
    }
    
    public function getCurrencyList() {
        try{
            $order = 'order_id asc,id asc';
            $list = Db::name('currency')->field("*")->order($order)->cacheAlways(TRUE, 0, 'currency')->select()->toArray();
            if (!$list) {
                $list = [];
            }
            $result['list'] = $list;
            return $this->successResponse($result);
        }
        catch (\Exception $exc) {
            return $this->errorResponse($exc->getMessage());
        }
    }
    
    /**
     * 删除分销区域
     * @return array|int[]
     */
    public function delete() {
        if (!Request::isPost()) {
            return $this->errorResponse(lang('request_method_incorrect'));
        }
        //开始事务
        Db::startTrans();
        try {
            $deliver_region_id = input('deliver_region_id');
            if (!is_numeric($deliver_region_id)) {
                return $this->errorResponse(lang('parameter_error'));
            }
            $condition['deliver_region_id'] = $deliver_region_id;
            $info = Db::name('deliver_region')->field('deliver_region_id')->where($condition)->find();
            if (!$info) {
                return $this->errorResponse(lang('parameter_error'));
            }
            Db::name('deliver_region')->where('deliver_region_id', $deliver_region_id)->delete();
            //提交事务
            Db::commit();
            return $this->successResponse('删除成功！');
        } catch (Exception $exc) {
            // 回滚事务
            Db::rollback();
            return $this->errorResponse($exc->getMessage());
        }
    }
    
}