\application\admin\controllersite

<?php

/**
 * +----------------------------------------------------------------------
 * | TickyPHP [ This is a freeware ]
 * +----------------------------------------------------------------------
 * | Copyright (c) 2019 All rights reserved.
 * +----------------------------------------------------------------------
 * | Author: 罗敏贵 <e-mail:minguiluo@163.com> <QQ:271391233>
 * +----------------------------------------------------------------------
 * | SVN: $Id: Site.php 85779 2019-02-01 09:57:53 luomingui $
 * +----------------------------------------------------------------------
 * | 文件功能：对应的表名:tky_site
 * +----------------------------------------------------------------------
 */

namespace application\admin\controller;

use ticky\request;
use ticky\response;

class site extends auth {

    // 首页
    public function index() {
        $search = $this->search_frm();
        $ret = $this->db->page('site', $search['sql'], 'siteid', $this->p);
        $this->assign('page', $ret['page']);
        $this->assign('items', $ret['items']);
        $this->assign('search', $search['arr']);
        $this->display('site/index');
    }

    // 添加记录
    public function add() {
        if (request::isPost()) {
            $data = $this->post_frm();
            $this->db->table('site')->add($data);
            if (request::isAjax()) {
                response::ajax(['code' => 200, 'msg' => '添加成功']);
            } else {
                showmsg('添加成功', '/admin/site');
            }
        } else {
            $this->assign('postUrl', '/admin/site/add');
            $this->assign('action', '添加');
            $this->display('site/manage');
        }
    }

    // 更新记录
    public function update() {
        if (request::isPost()) {
            $data = $this->post_frm();
            $id = request::post('siteid', 0);
            $this->db->table('site')->where(['siteid' => $id])->update($data);
            if (request::isAjax()) {
                response::ajax(['code' => 200, 'msg' => '修改成功']);
            } else {
                showmsg('修改成功', '/admin/site');
            }
        } else {
            $siteid = request::get('siteid', 0);
            $item = db('site')->where(['siteid' => $siteid])->find();
            $this->assign('postUrl', '/admin/site/update');
            $this->assign('action', '修改');
            $this->assign('item', $item);
            $this->display('site/manage');
        }
    }

    // 删除记录
    public function delete() {
        $siteid = request::post('siteid', 0);
        $result = $this->db->table('site')->where(['siteid' => $siteid])->delete();
        if (request::isAjax()) {
            if ($result) {
                response::ajax(['code' => 200, 'msg' => '删除成功!']);
            } else {
                response::ajax(['code' => 403, 'msg' => '删除失败! id=' . $siteid]);
            }
        } else {
            showmsg('删除成功', '/admin/site');
        }
    }

    // 批量删除
    public function batchremove() {
        $optype = request::post('optype', 'del');
        $ids = request::post('ids', []);
        if ($optype == "del") {
            for ($i = 0; $i < count($ids); $i++) {
                $id = $ids[$i];
                $this->db->table('site')->where(['siteid' => $id])->delete();
            }
            if (request::isAjax()) {
                response::ajax(['code' => 200, 'msg' => '修改成功']);
            } else {
                showmsg('删除成功', '/admin/site');
            }
        }
    }

    //查询条件
    private function search_frm() {
        $search = request::get('search', []);
        $where = '1=1 ';

        $type = request::get('type', '');
        $keyword = request::get('keyword', '');
        $search['type'] = $type;
        if ($keyword != '') {
            $search['keyword'] = $keyword;
            switch ($type) {
                case "siteid":
                    $where .= "and siteid = '" . $keyword . "' ";
                    break;
                case "name":
                    $where .= "and name = '" . $keyword . "' ";
                    break;
                case "dirname":
                    $where .= "and dirname = '" . $keyword . "' ";
                    break;
                case "domain":
                    $where .= "and domain = '" . $keyword . "' ";
                    break;
                case "site_title":
                    $where .= "and site_title = '" . $keyword . "' ";
                    break;
                case "keywords":
                    $where .= "and keywords = '" . $keyword . "' ";
                    break;
                case "description":
                    $where .= "and description = '" . $keyword . "' ";
                    break;
                case "release_point":
                    $where .= "and release_point = '" . $keyword . "' ";
                    break;
                case "default_style":
                    $where .= "and default_style = '" . $keyword . "' ";
                    break;
                case "template":
                    $where .= "and template = '" . $keyword . "' ";
                    break;
                case "setting":
                    $where .= "and setting = '" . $keyword . "' ";
                    break;
                case "inputtime":
                    $where .= "and inputtime = '" . $keyword . "' ";
                    break;
            }
        }
        return [
            'arr' => $search,
            'sql' => $where
        ];
    }

    //表单数据
    private function post_frm() {
        $arr = array();
        $arr['name'] = request::post('name', '');
        $arr['dirname'] = request::post('dirname', '');
        $arr['domain'] = request::post('domain', '');
        $arr['site_title'] = request::post('site_title', '');
        $arr['keywords'] = request::post('keywords', '');
        $arr['description'] = request::post('description', '');
        $arr['release_point'] = request::post('release_point', '');
        $arr['default_style'] = request::post('default_style', '');
        $arr['template'] = request::post('template', '');
        $arr['setting'] = request::post('setting', '');
        $arr['inputtime'] = time();
        return $arr;
    }

}