123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197 |
- <?php
- $config = array
- (
- # 表名
- 'name' => 'user_rank_stat',
- # 显示给用户看的名称
- 'lang' => '用户排名统计',
- 'order' => -13,
- # 数据结构 不同的字段放这里
- 'struct' => array
- (
- 'id' => array
- (
- 'type' => 'int-11',
- 'name' => 'ID',
- 'default' => '',
- 'desc' => '',
- 'match' => 'is_numeric',
- //'list' => true,
- ),
- 'day' => array
- (
- 'type' => 'int-11',
- 'name' => '日期',
- 'default' => '',
- 'match' => 'is_numeric',
- 'desc' => '',
- 'search' => 'day',
- 'search_button' => array
- (
- 'sum' => 'num,cash',
- 'option' => array(
- 'day' => '按天',
- 'week' => '按周',
- 'month' => '按月',
- ),
- 'group' => 'day,mobile',
- ),
- 'order' => 'desc',
- 'list' => 'Dever::showDay("{day}")',
- ),
- 'shop_id' => array
- (
- 'type' => 'int-11',
- 'name' => '门店名称',
- 'default' => '',
- 'desc' => '门店名称',
- 'match' => 'is_numeric',
- 'search' => 'select',
- //'option' => $shop,
- 'update' => 'hidden',
- 'search' => 'hidden',
- 'search' => array
- (
- 'api' => 'shop/info-like',
- 'col' => 'name',
- 'result' => 'id',
- ),
- 'value' => Dever::input('search_option_shop_id'),
- //'list' => 'Dever::load("shop/info-one#name", {shop_id})',
- ),
- 'area' => array
- (
- 'type' => 'varchar-500',
- 'name' => '所在街道',
- 'default' => '',
- 'desc' => '所在街道',
- 'match' => 'option',
- 'search' => 'linkage',
- 'update' => 'linkage',
- 'option' => Dever::url('lib/area.get', 'shop'),
- //'list' => 'Dever::load("area/api.string", "{area}")',
- ),
- 'mobile' => array
- (
- 'type' => 'bigint-11',
- 'name' => '客户手机号',
- 'default' => '',
- 'desc' => '客户手机号',
- 'match' => 'is_numeric',
- 'list' => true,
- ),
- 'num' => array
- (
- 'type' => 'int-11',
- 'name' => '数量',
- 'default' => '0',
- 'desc' => '数量',
- 'match' => 'is_numeric',
- 'search' => 'order',
- 'list' => true,
- ),
- 'cash' => array
- (
- 'type' => 'varchar-100',
- 'name' => '金额',
- 'default' => '0',
- 'desc' => '金额',
- 'match' => 'is_string',
- 'search' => 'order',
- 'list' => 'round({cash}, 2)',
- ),
- 'hb' => array
- (
- 'type' => 'varchar-100',
- 'name' => '环比增长',
- 'default' => '0',
- 'desc' => '环比增长',
- 'match' => 'option',
- 'update' => 'text',
- 'list' => 'Dever::load("shop/lib/manage.getUserRankHb", "{num}", "{mobile}", "{time}")',
- ),
- 'state' => array
- (
- 'type' => 'tinyint-1',
- 'name' => '数据状态',
- 'default' => '1',
- 'desc' => '请选择状态',
- 'match' => 'is_numeric',
- ),
- 'cdate' => array
- (
- 'type' => 'int-11',
- 'name' => '发布时间',
- 'match' => array('is_numeric', time()),
- 'desc' => '',
- # 只有insert时才生效
- 'insert' => true,
- //'search' => 'date',
- //'list' => 'date("Y-m-d H:i:s", {cdate})',
- ),
- ),
- 'manage' => array
- (
- 'insert' => false,
- 'edit' => false,
- 'delete' => false,
- 'num' => false,
- 'excel' => true,
- ),
- # request 请求接口定义
- 'request' => array
- (
- 'list' => array
- (
- # 匹配的正则或函数 选填项
- 'option' => array
- (
- 'shop_id' => 'yes',
- 'mobile' => 'yes',
- 'area' => array('yes', 'like'),
- 'start_day' => array('yes-day', '>='),
- 'end_day' => array('yes-day', '<='),
- 'state' => 1,
- ),
- 'type' => 'all',
- 'order' => array('time' => 'desc', 'cdate' => 'desc'),
- 'page' => array(20, 'list'),
- 'group' => 'day,mobile',
- 'col' => '*,min(day) as time, sum(cash) as cash, sum(num) as num',
- ),
- 'prev' => array
- (
- # 匹配的正则或函数 选填项
- 'option' => array
- (
- 'day' => array('yes-day', '<'),
- 'mobile' => 'yes',
- //'start_day' => array('yes-day', '>='),
- //'end_day' => array('yes-day', '<='),
- 'state' => 1,
- ),
- 'order' => array('time' => 'desc', 'id' => 'desc'),
- 'type' => 'one',
- 'col' => '*,min(day) as time, sum(cash) as cash, sum(num) as num',
- 'group' => 'day,mobile',
- # 允许自定义以上配置
- 'config' => true,
- ),
- ),
- );
- return $config;
|