<?php

namespace app\admin\controller;

use think\Exception;
use think\facade\Cache;
use think\facade\Db;
use think\facade\View;
use think\facade\Request;


class PaymentTool extends Common {
    private $tableName = 'payment_tool';
    private $viewPath = 'payment_tool';
    /**
     * 分销区域列表
     * @return string
     */
    public function index() {
        ////////
        if (!Request::isPost()) {
            $other['title'] = '收款工具管理';
            View::assign('other', $other);
            View::assign('viewPath', $this->viewPath);
            return View::fetch();
        } else {
            try {
                $kw = input('kw');
                if (!empty($kw)) {
                    $condition[] = array('payment_tool_name', 'like', "%$kw%");
                }
                $p = input('p', 1);
                $other['page_size'] = input('page_size', 20);
                $order = 'order_id asc,payment_tool_id asc';
                $count = Db::name($this->tableName)->where($condition)->count();
                $list = Db::name($this->tableName)->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 \app\admin\validate\paymentTool();
            $check_result = $validate->check($data);
            if (!$check_result) {
                return $this->errorResponse($validate->getError());
            }
            $payment_tool_id = input('post.payment_tool_id');
            if (is_numeric($payment_tool_id)) {
                //更新数据
                $update_result = Db::name($this->tableName)->where('payment_tool_id', $payment_tool_id)->withoutField('id')->save($data);
                if ($update_result === FALSE) {
                    return $this->errorResponse(lang('editing_failed'));
                }
                //提交事务
                Db::commit();
                $this->delCache();
                return $this->successResponse('修改成功！');
            } else {
                //添加数据
                unset($data['payment_tool_id']);
                $add_result = Db::name($this->tableName)->insertGetId($data);
                if (!$add_result) {
                    return $this->errorResponse('添加失败！');
                }
                Db::name($this->tableName)->where('payment_tool_id', $add_result)->save(['order_id' => $add_result]);
                //提交事务
                Db::commit();
                $this->delCache();
                return $this->successResponse('添加成功！');
            }
        } catch (Exception $exc) {
            // 回滚事务
            Db::rollback();
            return $this->errorResponse($exc->getMessage());
        }
    }
    
    function updateExt() {
        try {
            if (!Request::isPost()) {
                throw new Exception(lang('request_method_incorrect'));
            }
            $postField = 'payment_tool_id,is_show';
            $data = Request::only(explode(',', $postField), 'post');
            if (!$data['payment_tool_id']) {
                throw new Exception(lang('parameter_error'));
            }
            Db::name($this->tableName)->update($data);
            $result['message'] = '操作成功';
            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 {
            $payment_tool_id = input('payment_tool_id');
            if (!is_numeric($payment_tool_id)) {
                return $this->errorResponse(lang('parameter_error'));
            }
            $condition['payment_tool_id'] = $payment_tool_id;
            $info = Db::name($this->tableName)->field('payment_tool_id')->where($condition)->find();
            if (!$info) {
                return $this->errorResponse(lang('parameter_error'));
            }
            Db::name($this->tableName)->where('payment_tool_id', $payment_tool_id)->delete();
            //提交事务
            Db::commit();
            $this->delCache();
            return $this->successResponse('删除成功！');
        } catch (Exception $exc) {
            // 回滚事务
            Db::rollback();
            return $this->errorResponse($exc->getMessage());
        }
    }
    
    /**
     * 清除缓存
     * @return void
     */
    private function delCache() {
        Cache::tag('payment_tool')->clear();
    }
    
}