manage/api/Page/Data.php

<?php namespace Manage\Api\Page;
use Dever;
use Manage\Lib\Page;
# 数据获取
class Data extends Page
{
    private $expand = false;
    public function __construct($load = '')
    {
        parent::__construct('list', $load);
    }
    public function list()
    {
        if ($this->menu && $this->menu['show'] == 1 && !$this->getFunc('list', '列表', 1)) {
            Dever::error('无访问权限');
        }
        $data['title'] = '';
        $data['button'] = $this->button();
        $data['recycler'] = $this->recycler;
        $data = array_merge($data, $this->out());
        $data['total'] = Dever::page('total');
        $data['height'] = $this->config['height'] ?? '100%';
        $data['type'] = $this->config['type'] ?? 'table';
        $data['desc'] = $this->config['desc'] ?? '';
        $data['layout'] = $this->config['layout'] ?? [];
        $data['exportButton'] = $this->export();
        $data['show'] = [
            'selection' => $this->config['selection'] ?? false,
            'expand' => $this->expand,
            'index' => $this->config['index'] ?? false,
        ];
        $this->column($data);
        return $data;
    }
    public function out()
    {
        $where = $this->config['where'] ?? [];
        $set = $this->config['set'] ?? [];
        $data['field'] = $data['head'] = [];
        $data['search'] = $this->search($where);
        $ids = Dever::input('ids');
        if ($ids) {
            $where['id'] = ['in', $ids];
        }
        $set['num'] = Dever::input('pgnum', '', '', 10);
        $order_col = Dever::input('order_col');
        if ($order_col) {
            $order_value = Dever::input('order_value');
            if ($order_value) {
                $set['order'] = $order_col . ' ' . $order_value . ', id desc';
            }
        }
        if (isset($this->config['data'])) {
            $result = Dever::call($this->config['data'], [$where, $set]);
            $data = array_merge($data, $result);
        } else {
            $data['field'] = $this->setting('field', $data['head'], true, 'show');
            $data['body'] = $this->data($where, $set);
        }
        $method = Dever::input('method');
        if ($method && strstr($method, '.')) {
            $result = Dever::call($method, [$data]);
            unset($data);
            $data['field'] = $result['head'];
            $data['body'] = $result['body'];
        }
        $data['stat'] = [];
        if (isset($this->config['stat'])) {
            $data['stat'] = Dever::call($this->config['stat'], [$where]);
        }
        return $data;
    }

    private function data($where, $set = [])
    {
        if (isset($this->config['tree'])) {
            return $this->db->tree($where, $this->config['tree'], [$this, 'handleData']);
        }
        $data = $this->db->select($where, $set);
        $result = [];
        if ($data) {
            foreach ($data as $k => $v) {
                $result[$k] = $this->handleData($k, $v);
            }
        }
        return $result;
    }

    public function handleData($k, $v)
    {
        $result['index'] = $k+1*Dever::input('pg', '', '', 1);
        $button = $this->button('data_button', $v);
        if ($button) {
            $result['button'] = $button;
        }
        # 是否保留html代码，1是保留，2是不保留
        $html = Dever::input('html', '', '', 1);
        if (isset($v['_id'])) {
            $result['id'] = $v['_id'];
        } elseif (isset($v['id'])) {
            $result['id'] = $v['id'];
        }
        $result['cdate'] = $v['cdate'];
        foreach ($this->field as $value) {
            $key = $value['key'];
            if (isset($v[$key])) {
                $result[$key] = $this->getValue($key, $v[$key], $v, $value);
            } elseif (strpos($key, '/')) {
                $other = $this->getOther($key, $value, $v);
                if ($other) {
                    $otherName = [];
                    foreach ($other as $k1 => $v1) {
                        if (isset($v1['name'])) {
                            $otherName[] = $v1['name'];
                        }
                    }
                    if ($otherName) {
                        $result[$key] = implode('、', $otherName);
                    } else {
                        $result[$key] = $other;
                    }
                }
            } elseif (isset($value['show'])) {
                $result[$key] = $this->getShow($value['show'], $v);
            }
            if ($html == 2) {
                $result[$key] = strip_tags($result[$key]);
            }
        }
        if (isset($this->config['expand']) && $this->config['expand']) {
            $result['expand'] = Dever::call($this->config['expand'], [$v]);
            $this->expand = true;
        }
        return $result;
    }

    private function export()
    {
        $result = false;
        if (isset($this->config['export']) && $this->config['export']) {
            $result = [];
            foreach ($this->config['export'] as $k => $v) {
                $func = $this->getFunc($k, $v, 300);
                if ($func) {
                    $result[$k] = $v;
                }
            }
        }
        return $result;
    }

    private function search(&$where)
    {
        $search = Dever::input('search');
        $set = Dever::input('set');
        $list_search = $result = [];
        $result['form'] = $result['field'] = $result['option'] = [];
        $this->setting('search', $list_search, false, 'text');
        if ($list_search) {
            foreach ($list_search as $v) {
                if ($v['type'] != 'hidden1') {
                    $result['form'][] = $v;
                    if (is_numeric($v['value'])) {
                        $v['value'] = (float) $v['value'];
                    }
                    $result['field'][$v['key']] = $v['value'];
                    if ($v['type'] == 'sku') {
                        $result['field'][$v['key'] . '_spec'] = [];
                    }
                    if (isset($v['option'])) {
                        $result['option'][$v['key']] = $v['option'];
                    }
                }
                $this->where($search, $v, $where);
                $this->where($set, $v, $where);
            }
        }
        return $result;
    }

    private function where($value, $v, &$where)
    {
        if ($value) {
            if ($value = Dever::issets($value, $v['key'])) {
                if (isset($v['search'])) {
                    if (is_callable($v['search'])) {
                        $value = $v['search']($v['key'], $v['type'], $value);
                    } elseif (isset($v['search']['table'])) {
                        $v['search']['where'] = Dever::json_decode(str_replace('{value}', $value, Dever::json_encode($v['search']['where'])));
                        $search = Dever::db($v['search']['table'])->select($v['search']['where'], $v['search']['set'] ?? []);
                        $value = [];
                        if ($search) {
                            foreach ($search as $v1) {
                                $value[] = $v1[$v['search']['field']];
                            }
                        }
                        $value = implode(',', $value);
                        $v['type'] = 'in';
                        if (isset($v['search']['key'])) {
                            $v['key'] = $v['search']['key'];
                        }
                    }
                }
                if ($v['type'] == 'group') {
                    $where[$v['key']] = ['group', $value];
                } elseif ($v['type'] == 'selects') {
                    $where[$v['key']] = ['group', $value];
                } elseif ($v['type'] == 'cascader') {
                    $t = $value;
                    if (is_array($value)) {
                        $t = implode(',', $value);
                    }
                    $where[$v['key']] = ['like', $t];
                } elseif ($v['type'] == 'like') {
                    $where[$v['key']] = ['like', $value];
                } elseif ($v['type'] == 'in') {
                    $where[$v['key']] = ['in', $value];
                } elseif ($v['type'] == 'date') {
                    if (strstr($v['date_type'], 'range')) {
                        $where[$v['key']] = array('>=', \Dever\Helper\Date::mktime($value[0]));
                        $where[$v['key'] . '#'] = array('<=', \Dever\Helper\Date::mktime($value[1]));
                    } else {
                        $where[$v['key']] = $value;
                    }
                } else {
                    $where[$v['key']] = $value;
                }
            }
        }
    }
}