checkFunc('bill.shop_stat', 'editSout', '导出数据')) { $excel[] = array('数据导出','归店数据统计','bill/lib/manage.out_shop_stat'); } $shop = function() { $array = array(); $data = Dever::db('shop/info-state'); if($data) { $array += $data; } return $array; }; $cash_status = array ( 1 => '已发放', 2 => '未发放', ); $status = array ( 1 => '已确认', 2 => '未确认', ); $list_button = array(); $list_button['list1'] = array('归店明细', 'member_shop_log&project=agent&menu=agent&search_option_state=1&menu_id=306&search_option_new_shop_id={shop_id}&search_option_dever_auth=2&search_option_status=1'); $list_button['list2'] = array('直推明细', 'order&project=agent&menu=agent&search_option_state=1&menu_id=306&search_in_parent_mid={mids}'); $table = Dever::input('table'); if ($table == 'shop_stat') { $month = Dever::input('search_option_month', date('Y-m')); if ($month) { Dever::setInput('search_option_month', $month); } $button['一键生成归店信息'] = array('oper', 'bill/?l=lib/Cron.shop_stat&day=' . $month, '确认生成归店统计信息吗?'); $button['重新生成归店信息'] = array('oper', 'bill/?l=lib/Cron.shop_stat&day=' . $month, '确认生成归店统计信息吗?'); if (Dever::load('manage/auth')->checkFunc('bill.shop_stat', 'duizhang', '对账确认')) { $button['对账确认'] = array('oper', 'bill/?l=lib/cron.shopYes_commit&month=' . $month, '确定已完成对账?'); } if (Dever::load('manage/auth')->checkFunc('bill.shop_stat', 'fafang', '确认发放')) { $button['确认发放'] = array('oper', 'bill/?l=lib/cron.areaCash_commit&month=' . $month, '确认发放资金到代理商账户吗?确认后无法手动恢复'); } } $config = array ( # 表名 'name' => 'shop_stat', # 显示给用户看的名称 'lang' => '归店统计', 'order' => -10, 'info' => '代理商总数=创V数+代理商数量,创V数包含名额外创V数,创V数减去名额外创V就是名额内创V数,代理商数量包含创客数', 'end' => array ( 'list' => 'bill/lib/cron.getShopInfo', ), # 数据结构 不同的字段放这里 'struct' => array ( 'id' => array ( 'type' => 'int-11', 'name' => 'ID', 'default' => '', 'desc' => '', 'match' => 'is_numeric', //'list' => true, ), 'month' => array ( 'type' => 'int-11', 'name' => '月份', 'default' => '', 'match' => 'is_numeric', 'desc' => '', 'search' => 'month_eq', // 'list_name' => '月份', 'search_default' => '', 'list_name' => '月份', 'list' => 'is_numeric("{month}") ? date("Y-m", "{month}") : "{month}"', ), 'mids' => array ( 'type' => 'text-255', 'name' => '代理商id', 'default' => '', 'desc' => '代理商id', 'match' => 'is_numeric', // 'option' => $shop, // 'list' => true, //'list_order' => 6, ), 'month_mids' => array ( 'type' => 'text-255', 'name' => '代理商id', 'default' => '', 'desc' => '代理商id', 'match' => 'is_numeric', // 'option' => $shop, // 'list' => true, //'list_order' => 6, ), 'shop_id' => array ( 'type' => 'int-11', 'name' => '店铺名称/店铺编号', 'default' => '', 'desc' => '店铺名称', 'match' => 'is_numeric', 'option' => $shop, 'search' => array ( 'api' => 'shop/info-getSearch', 'col' => 'col', 'result' => 'id', ) , 'list_name' => '门店名称
门店编号
所属代理商', 'list' => 'Dever::load("bill/lib/manage.shop_stat", {id})', 'list_order' => 2, ), 'dl_subsidy' => array ( 'type' => 'decimal-11,2', 'name' => '区域招商补贴', 'default' => '0', 'desc' => '补贴', 'match' => 'is_numeric', 'update' => 'text', 'list' => true, 'list_order' => 3, ), 'v_subsidy' => array ( 'type' => 'decimal-11,2', 'name' => '名额外创V补贴', 'default' => '0', 'desc' => '补贴', 'match' => 'is_numeric', 'update' => 'text', 'list' => true, 'list_order' => 3, ), 'c_money' => array ( 'type' => 'decimal-11,2', 'name' => '采购金额', 'default' => '0', 'desc' => '采购金额', 'match' => 'is_numeric', 'update' => 'text', 'list' => true, 'list_order' => 3, ), 'num' => array ( 'type' => 'int-11', 'name' => '代理商总数量', 'default' => '0', 'desc' => '代理商总数量', 'match' => 'is_numeric', 'search' => 'order', // 'list' => true, ), 'dl_num' => array ( 'type' => 'int-11', 'name' => '代理商
数量-除掉创v的数量', 'default' => '0', 'desc' => '代理商数量', 'match' => 'is_numeric', // 'search' => 'order', 'list' => true, 'list_order' => 4, ), 'ck_num' => array ( 'type' => 'int-11', 'name' => '创客数', 'default' => '0', 'desc' => '创客数', 'match' => 'is_numeric', // 'search' => 'order', 'list' => true, 'list_order' => 5, ), 'v_num' => array ( 'type' => 'int-11', 'name' => '创V数', 'default' => '0', 'desc' => '创V总数量', 'match' => 'is_numeric', // 'search' => 'order', 'list' => true, 'list_order' => 6, ), 'out_num' => array ( 'type' => 'int-11', 'name' => '名额外创V数', 'default' => '0', 'desc' => '创V名额外数量', 'match' => 'is_numeric', // 'search' => 'order', 'list' => true, 'list_order' => 7, ), 'money' => array ( 'type' => 'decimal-11,2', 'name' => '代理商的总业绩', 'default' => '0', 'desc' => '代理商的总业绩', 'match' => 'is_numeric', 'update' => 'text', // 'list' => true, ), 'dl_money' => array ( 'type' => 'decimal-11,2', 'name' => '归店业绩
(除创V)', 'default' => '0', 'desc' => '代理商业绩', 'match' => 'is_numeric', 'update' => 'text', 'list' => true, 'list_order' => 4, ), 'v_money' => array ( 'type' => 'decimal-11,2', 'name' => '创V总业绩', 'default' => '0', 'desc' => '创V总业绩', 'match' => 'is_numeric', 'update' => 'text', // 'list' => true, ), 'out_money' => array ( 'type' => 'decimal-11,2', 'name' => '名额外创V
业绩', 'default' => '0', 'desc' => '创V名额外业绩', 'match' => 'is_numeric', 'update' => 'text', 'list' => true, 'list_order' => 8, ), 'nei_money' => array ( 'type' => 'decimal-11,2', 'name' => '名额内创V
业绩', 'default' => '0', 'desc' => '创V名额内业绩', 'match' => 'is_numeric', 'update' => 'text', // 'list' => true, // 'list_order' => 9, ), 'status' => array ( 'type' => 'int-11', 'name' => '确认状态', 'default' => '2', 'desc' => '确认状态', 'match' => 'is_numeric', 'option' => $status, 'list' => true, ), 'cash_status' => array ( 'type' => 'int-11', 'name' => '发放状态', 'default' => '2', 'desc' => '发放状态', 'match' => 'is_numeric', 'option' => $cash_status, 'list' => true, ), '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, 'excel' => $excel, 'button' => $button, 'list_button' => $list_button, // ( // 'new' => array('查看明细', '"lib/manage.guidian?id={id}"', 'bill'), // ), ), # request 请求接口定义 'request' => array ( 'getState' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'start' => array('yes-month', '>='), 'end' => array('yes-month', '<='), 'shop_id' => 'yes', 'state' => 1, ), 'type' => 'all', 'col' => '*', ), ), ); return $config;