array('name' => '待审核', 'style' => 'font-weight:bold;color:#436EEE'),
2 => array('name' => '已审核', 'style' => 'font-weight:bold;color:green'),
3 => array('name' => '已作废', 'style' => 'font-weight:bold;color:#CD3700'),
);
$manage_status = array
(
//1 => '待审核',
2 => '已审核',
3 => '已作废',
);
$type = array
(
1 => '直推佣金',
2 => '市场培训费',
3 => '区域管理收益',#'代理区域分润',
4 => '活动分佣',
10 => '手动发放',
11 => '提现',
12 => '消费',
13 => '区域招商补贴',
14 => '创V归店补贴',
15 => '区域运营收益',
21 => '抵扣券差额',//市场培训费或者直推佣金多发,这里需要扣除
);
$role = function()
{
$array = array();
$data = Dever::load('setting/lib/manage.role');
if($data)
{
$array += $data;
}
return $array;
};
$mid = Dever::input('search_option_mid');
$button = array();
if ($mid) {
$button['返回上一页'] = array('location', 'l=project/database/list&project=agent&table=member_area&page_type=1&mid=' . $mid . '&[refer]');
if (Dever::load('manage/auth')->checkFunc('agent.member', 'edit1', '发放资金')) {
$button['发放资金'] = array('fast', '', 'push_cash&search_option_mid=' . $mid);
}
// $button = array
// (
// '返回上一页' => array('location', 'l=project/database/list&project=agent&table=member_area&page_type=1&mid=' . $mid),
// '发放资金' => array('fast', '', 'push_cash&search_option_mid=' . $mid),
// );
}
$excel = false;
if(Dever::load('manage/auth')->checkFunc('menu_244.menu_245', 'editCout', '数据导出')){
$excel[] = array('数据导出','代理商分润', 'bill/lib/cash.out_cash');
}
$list_button = array();
$list_button['list'] = array('查看详情', '"push_cash&project=bill&id={id}&page_type=1&[refer]"');
if (Dever::load('manage/auth')->checkFunc('bill.tixian', 'edit', '审核')) {
$list_button['fast'] = array('审核', '"cash&where_id={id}&col=audit,audit_desc&oper_save_jump=cash&oper_table=cash&oper_parent=cash"', '{status} == 1');
}
$mul = false;
if (Dever::load('manage/auth')->checkFunc('bill.tixian', 'tixianedit', '批量审核')) {
$mul = '{status} == 1';
}
$admin = Dever::load('manage/auth.info');
$admin_auth = false;
if ($admin && $admin['role'] == 24){
$admin_auth = $admin['role'];
}
return array
(
# 表名
'name' => 'cash',
# 显示给用户看的名称
'lang' => '资金流水',
'auto' => 100000,
'set' => array
(
'status' => $status,
'type' => $type,
),
'start' => array
(
'updatemul' => 'bill/lib/manage.cashAuditUpdateStart',
),
'end' => array
(
'update' => 'bill/lib/manage.cashAuditUpdate',
'updatemul' => 'bill/lib/manage.cashAuditUpdate',
),
'order' => 99,
# 数据结构
'struct' => array
(
'id' => array
(
'type' => 'int-11',
'name' => 'ID',
'default' => '',
'desc' => '',
'match' => 'is_numeric',
'search' => 'order',
//'list' => true,
),
'mid' => array
(
'type' => 'int-11',
'name' => '代理商姓名/手机号',
'default' => '-1',
'desc' => '代理商',
'match' => 'is_string',
'update' => 'text',
'search' => array
(
'api' => 'agent/member-getSearch',
'col' => 'col',
'result' => 'id',
'search' => 'mid',
),
'list_name' => '代理商信息',
'list' => $admin_auth ? 'Dever::load("agent/lib/member.getOne", {mid}, "agent/member", true,true)' : 'Dever::load("agent/lib/member.getOne", {mid}, "agent/member", true)',
'list_order' => 1,
),
'agent-member-name'=> array
(
'name' => '姓名',
'default' => '',
'desc' => '姓名',
'match' => 'option',
# 读取另外表的关联方式
'sync' => array('mid', 'id'),
'searchs' => array
(
'api' => 'agent/member-find',
'col' => 'name',
'result' => 'id',
),
),
'agent-member-role'=> array
(
'name' => '代理角色',
'default' => '',
'desc' => '代理角色',
'match' => 'option',
# 读取另外表的关联方式
'sync' => array('mid', 'id'),
// 'list' => 'Dever::load("setting/role-find#name", "{agent-member-role}")',
// 'list_order' => 5,
),
'order_num' => array
(
'type' => 'varchar-100',
'name' => '流水号',
'default' => '',
'desc' => '流水号',
'match' => 'is_string',
'update' => 'text',
'search' => 'fulltext',
//'list' => true,
//'list_name' => '流水号
交易时间',
//'list' =>'Dever::load("bill/lib/cash.order_num#num", {id})',
//'list_order' => 1,
),
'role' => array
(
'type' => 'int-11',
'name' => '代理角色',
'default' => '',
'desc' => '代理角色',
'match' => 'is_numeric',
//'search' => 'select',
'update' => 'checkbox',
'option' => $role,
//'list' => true,
),
'type' => array
(
'type' => 'int-11',
'name' => '交易类型',
'default' => '1',
'desc' => '交易类型',
'match' => 'is_numeric',
'search' => 'select',
'update' => 'checkbox',
'option' => $type,
'list' => true,
'list_order' => 2,
),
'type_id' => array
(
'type' => 'int-11',
'name' => '交易来源id',
'default' => '',
'desc' => '交易来源id',
'match' => 'is_string',
'update' => 'text',
),
'cash' => array
(
'type' => 'decimal-11,2',
'name' => '金额',
'default' => '0',
'desc' => '金额',
'match' => 'is_numeric',
'update' => 'text',
'list_name' => '金额
操作后余额',
'list' =>'Dever::load("bill/lib/cash.order_num#cash", {id})',
'list_order' => 4,
),
'yue' => array
(
'type' => 'decimal-11,2',
'name' => '操作后余额',
'default' => '0',
'desc' => '操作后余额',
'match' => 'is_numeric',
'update' => 'text',
// 'list' => true,
// 'list_order' => 7,
),
'status' => array
(
'type' => 'int-11',
'name' => '交易状态',
'default' => '1',
'desc' => '交易状态',
'match' => 'is_numeric',
'update' => 'hidden',
'option' => $status,
'search' => 'select',
'list' => true,
'list_name' => '交易状态',
'list_order' => 3,
),
'audit' => array
(
'type' => 'int-11',
'name' => '审核状态',
'default' => '2',
'desc' => '审核状态',
'match' => 'is_numeric',
'update' => 'radio',
'option' => $manage_status,
'mul' => true,
'control' => 'audit',
),
'audit_desc' => array
(
'type' => 'varchar-600',
'name' => '备注',
'default' => '',
'desc' => '审核说明',
'match' => 'is_string',
'update' => 'textarea',
'list' => '"{audit_desc}" ? "{audit_desc}" : "-"',
'list_order' => 5,
'show' => 'audit=3',
),
'desc' => array
(
'type' => 'varchar-600',
'name' => '资金说明',
'default' => '',
'desc' => '资金说明',
'match' => 'is_string',
'update' => 'text',
),
'operdate' => array
(
'type' => 'int-11',
'name' => '审核确认时间',
'default' => '',
'match' => 'is_numeric',
'desc' => '',
//'list' => '"{operdate}" > 0 ? date("Y-m-d H:i", {operdate}) : "-"',
//'list_order' => 9,
),
'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_name' => '交易时间
审核时间',
'list' => 'Dever::load("bill/lib/cash.order_num#num", {id})',
'list_order' => 20,
),
),
'manage' => array
(
'insert' => false,
'delete' => false,
'edit' => false,
'excel' => $excel,
'button' => $button,
'mul' => $mul,
'list_button' => $list_button,
),
'request' => array
(
'getData' => array
(
# 匹配的正则或函数 选填项
'option' => array
(
'mid' => 'yes',
'type' => 'yes',
'state' => 1,
),
'order' => array('id' => 'desc'),
'page' => array(10, 'list'),
'type' => 'all',
'col' => '*',
),
# 获取订单数量
'getCash' => array
(
# 匹配的正则或函数 选填项
'option' => array
(
'start' => array('yes-cdate', '>='),
'end' => array('yes-cdate', '<='),
'type' => array('yes', 'in'),
'mid' => 'yes',
'status' => 2,
'state' => 1,
),
'type' => 'one',
'col' => 'sum(cash) as total',
),
'getwsCash' => array
(
# 匹配的正则或函数 选填项
'option' => array
(
'start' => array('yes-cdate', '>='),
'end' => array('yes-cdate', '<='),
'status' => array('yes', 'in'),
'type' => array('yes', 'in'),
'mid' => 'yes',
'state' => 1,
),
'type' => 'one',
'col' => 'sum(cash) as total',
),
'getExcelAll' => array
(
# 匹配的正则或函数 选填项
'option' => array
(
'start' => array('yes-cdate', '>='),
'end' => array('yes-cdate', '<='),
'state' => 1,
),
'type' => 'all',
'col' => '*',
),
'getMoney' => array
(
# 匹配的正则或函数 选填项
'option' => array
(
'mid' => 'yes',
'start' => array('yes-cdate', '>='),
'end' => array('yes-cdate', '<='),
'type' => array('yes','in'),
'state' => 1,
),
'type' => 'one',
'col' => 'sum(cash) as cash',
),
),
);