array ( 'id' => '-1', 'name' => '无来源', ), ); $data = Dever::load('setting/source-state'); if($data) { $array += $data; } return $array; }; $prize_type = array ( 1 => '名额外', 2 => '名额内', ); $status = array ( -2 => array('name' => '待签名', 'style' => 'font-weight:bold;color:#00FFFF'), 1 => array('name' => '待业务初审', 'style' => 'font-weight:bold;color:#436EEE'), 2 => array('name' => '待财务终审', 'style' => 'font-weight:bold;color:#003366'), 3 => array('name' => '待权益发放', 'style' => 'font-weight:bold;color:#993333'), 4 => array('name' => '已完成', 'style' => 'font-weight:bold;color:green'), 5 => array('name' => '驳回', 'style' => 'font-weight:bold;color:#CD3700'), 6 => array('name' => '挂起', 'style' => 'font-weight:bold;color:#436EEE'), 7 => array('name' => '关闭', 'style' => 'font-weight:bold;color:#000000'), ); $pay_status = array ( 1 => '待支付', 2 => '已支付', 3 => '已退款', ); $goods_status = array ( 1 => array('name' => '未发放', 'style' => 'font-weight:bold;color:#436EEE'), 2 => array('name' => '无权益', 'style' => 'font-weight:bold;'), 3 => array('name' => '已发放', 'style' => 'font-weight:bold;color:green'), ); $type = array ( 1 => '个人', 2 => '公司', ); $pay_type = array ( 1 => '在线支付', 2 => '汇款', 3 => '个人转账', ); $get_type = array ( 1 => '购买', 2 => '赠送', ); $level = function() { $array = array ( -1 => array ( 'id' => -1, 'name' => '普通', ), ); $data = Dever::load('setting/level-state'); if($data) { $array += $data; } return $array; }; $import = array ( 1 => '最新系统', 2 => 'v2旧系统导入', 3 => 'v1旧系统导入', ); $order_type = array ( 1 => '新购', 2 => '升级', ); $button = array(); $parent_mid = Dever::input('search_option_parent_mid'); $mid = Dever::input('search_option_mid'); $pmid = ''; if ($parent_mid) { $pmid = $parent_mid; } if ($mid) { $pmid = $mid; } $p = Dever::input('p'); $excel = false; if ($pmid && $p !=1) { $button = array ( '返回上一页' => array('location', 'l=project/database/list&project=agent&table=member_area&page_type=1&mid=' . $pmid), ); }else{ if(Dever::load('manage/auth')->checkFunc('agent.order', 'editorderout', '数据导出')){ $excel[] = array('数据导出', '代理商订单','agent/lib/order.out_order'); } if(Dever::load('manage/auth')->checkFunc('agent.order', 'editbeidiao', '背调订单记录数据导出')){ $excel[] = array('代理商订单导出', '代理商订单记录','agent/lib/order.out_beidiaoorder'); } } # 权限设置 1是查看详情、2是城市数据统计 $search_auth = Dever::input('search_option_dever_auth', 1); $list_button = array(); $admin = Dever::load('manage/auth.info'); $admin_auth = false; if ($admin && $admin['role'] == 24){ $admin_auth = $admin['role']; } if($search_auth == 1){ if(Dever::load('manage/auth')->checkFunc('agent.order', 'ckdesc', '查看详情')){ $list_button['list'] = array('查看详情', '"order_process&project=agent&order_id={id}&page_type=1&[refer]"'); } if(Dever::load('manage/auth')->checkFunc('agent.order', 'editSoftorderout', '软件服务费数据导出')){ $excel[] = array('软件服务费数据导出','软件服务费数据导出', 'agent/lib/order.out_softorder'); } if(Dever::load('manage/auth')->checkFunc('agent.order', 'editguidian', '归店业绩统计导出')){ $excel[] = array('归店业绩统计导出','归店业绩统计导出', 'agent/lib/order.out_guidian'); } if (Dever::load('manage/auth')->checkFunc('agent.order', 'agent_oder_touxian', '推荐人头衔导出')) { $excel[] = array('推荐人头衔导出', '推荐人头衔导出', 'agent/lib/manage.out_order_touxian'); } } if(Dever::load('manage/auth')->checkFunc('agent.order', 'qxorder', '取消订单')){ $list_button['oper'] = array('取消订单', '"agent/lib/manage.setOrderStatus?id={id}&status=7"', '{status} <= 1 || {status} == 5'); } $search_pmid = Dever::input('search_in_parent_mid'); $invite_type = array ( 1 => '邀请人', 2 => '来源', ); # id小于50000为导入的数据 return array ( # 表名 'name' => 'order', # 显示给用户看的名称 'lang' => '代理商订单', 'auto' => 50000, 'set' => array ( 'status' => $status, 'pay_status' => $pay_status, 'goods_status' => $goods_status, 'type' => $type, 'pay_type' => $pay_type, 'order_type' => $order_type, ), 'start' => array ( 'update' => 'agent/lib/manage.orderUpdateParent', ), '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' => $search_pmid ? false : 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)' : ($search_auth == 1 ? 'Dever::load("agent/lib/member.getOne", {mid}, "agent/member", true)' : false), 'list_order' => 3, ), 'order_num' => array ( 'type' => 'varchar-100', 'name' => '订单号', 'default' => '', 'desc' => '订单号', 'match' => 'is_string', 'update' => 'text', //'search' => 'fulltext', //'list' => true, //'list_order' => 1, ), 'order_type' => array ( 'type' => 'tinyint-1', 'name' => '订单类型', 'default' => '1', 'desc' => '订单类型', 'match' => 'is_numeric', 'option' => $order_type, ), 'mobile' => array ( 'type' => 'bigint-11', 'name' => '手机号', 'default' => '', 'desc' => '请输入手机号', 'match' => Dever::rule('mobile'), 'update' => 'text', //'search' => 'fulltext', 'list' => $search_auth == 2 ? true : false, 'list_order' => 2, ), 'invite_type' => array ( 'type' => 'tinyint-1', 'name' => '邀请类型', 'default' => '1', 'desc' => '邀请类型', 'match' => 'is_numeric', //'search' => 'select', 'update' => 'radio', 'option' => $invite_type, //'list' => true, //'list_order' => 7, 'control' => 'invite_type', ), 'parent_code' => array ( 'type' => 'varchar-100', 'name' => '上级邀请码', 'default' => '', 'desc' => '上级邀请码', 'match' => 'is_string', 'update' => 'text', # 绑定js脚本,更新时使用,第一个参数是执行的方式,第二个参数执行的方法,第三个参数是传值。 'bind' => array('onblur', 'loading', array('url' => Dever::url("lib/member.search", 'agent'))), 'show' => 'invite_type=1', ), 'parent_mid' => array ( 'type' => 'int-11', 'name' => '推荐人姓名/手机号', 'default' => '-1', 'desc' => '邀请人', 'match' => 'is_string', //'update' => 'text', 'search' => $admin_auth ? false : ($search_pmid ? false : array ( 'api' => 'agent/member-getSearch', 'col' => 'col', 'result' => 'id', 'search' => 'parent_mid', )), 'list_name' => '推荐人信息', 'list' => $admin_auth ? 'Dever::load("agent/lib/member.getOne", {parent_mid}, "agent/member", false,true)' : ($search_auth == 1 ? 'Dever::load("agent/lib/member.getOne", {parent_mid})' : false), ), 'source_id' => array ( 'type' => 'int-11', 'name' => '注册来源', 'default' => '-1', 'desc' => '注册来源', 'match' => 'is_numeric', 'search' => 'select', 'update' => 'radio', 'option' => $source_id, // 'list' => true, // 'list_order' => 5, // 'show' => 'invite_type=2', ), 'name' => array ( 'type' => 'varchar-100', 'name' => '姓名', 'default' => '', 'desc' => '姓名', 'match' => 'is_string', 'update' => 'text', //'search' => 'fulltext', 'list' => $search_auth == 2 ? true : false, 'list_order' => 1, ), 'role' => array ( 'type' => 'int-11', 'name' => '代理角色', 'default' => '', 'desc' => '代理角色', 'match' => 'is_numeric', 'search' => 'select', 'update' => 'select', 'option' => $role, 'list' => $search_auth == 2 ? true : false, 'list_order' => 3, ), 'area' => array ( 'type' => 'varchar-500', 'name' => '代理区域', 'default' => '', 'desc' => '代理区域', 'match' => 'option', 'search' => 'linkage', 'update' => 'linkage', 'option' => Dever::url('api.get?level_total=4', 'area'), 'list' => $search_auth == 2 ? 'Dever::load("agent/lib/order.getArea", {id})' : false, 'list_order' => 3, ), 'desc' => array ( 'type' => 'varchar-600', 'name' => '付款备注', 'default' => '', 'desc' => '付款备注', 'match' => 'is_string', 'update' => 'text', ), 'f_price' => array ( 'type' => 'decimal-11,2', 'name' => '原价', 'default' => '0', 'desc' => '原价', 'match' => 'option', 'update' => 'text', ), 'price' => array ( 'type' => 'decimal-11,2', 'name' => '金额', 'default' => '0', 'desc' => '金额', 'match' => 'option', 'update' => 'text', // 'list' => true, //'list_name' => '应付金额
实付金额
代理费
软件服务费
', 'list_name' => $search_auth == 1 ? '实付金额' : '总销售额', 'list' => true, // 'list' =>'Dever::load("agent/lib/order.set_price", {id})', 'list_order' => 100, ), 'pay_type' => array ( 'type' => 'tinyint-1', 'name' => '支付方式', 'default' => '1', 'desc' => '支付方式', 'match' => 'is_numeric', //'search' => 'select', //'update' => 'select', 'option' => $pay_type, //'list' => true, //'list_order' => 7, ), 'pay_pic' => array ( 'type' => 'text-255', 'name' => '打款凭证', 'default' => '', 'desc' => '打款凭证', 'match' => 'option', 'update' => 'images', 'key' => '1', //'place' => '150', ), 'pay_price' => array ( 'type' => 'decimal-11,2', 'name' => '交款金额', 'default' => '0', 'desc' => '交款金额', 'match' => 'option', 'update' => 'text', ), 'option_price' => array ( 'type' => 'decimal-11,2', 'name' => '赠送期权价值', 'default' => '0', 'desc' => '金额', 'match' => 'option', 'update' => 'text', // 'value' => Dever::input('soft_price', '0'), // 'show' => 'cstatus=2', ), 'bank_id' => array ( 'type' => 'int-11', 'name' => '所属银行', 'default' => '', 'desc' => '所属银行', 'match' => 'is_numeric', ), 'bank_card' => array ( 'type' => 'int-11', 'name' => '银行卡号', 'default' => '', 'desc' => '银行卡号', 'match' => 'is_numeric', ), 'type' => array ( 'type' => 'tinyint-1', 'name' => '类型', 'default' => '1', 'desc' => '类型', 'match' => 'is_numeric', 'option' => $type, 'update' => 'radio', 'control' => 'type', ), 'sign' => array ( 'type' => 'varchar-150', 'name' => '手写签名', 'default' => '', 'desc' => '手写签名', 'match' => 'option', 'update' => 'image', 'key' => '7', ), 'idcard' => array ( 'type' => 'varchar-100', 'name' => '身份证号码', 'default' => '', 'desc' => '身份证号码', 'match' => 'is_string', 'match' => Dever::rule('idcard'), 'update' => 'text', //'search' => 'fulltext', ), 'idcard_front' => array ( 'type' => 'varchar-150', 'name' => '身份证正面', 'default' => '', 'desc' => '身份证正面', 'match' => 'option', 'update' => 'image', 'key' => '8', //'place' => '660*660', ), 'idcard_back' => array ( 'type' => 'varchar-150', 'name' => '身份证背面', 'default' => '', 'desc' => '身份证背面', 'match' => 'option', 'update' => 'image', 'key' => '8', //'place' => '660*660', ), 'company_name' => array ( 'type' => 'varchar-100', 'name' => '公司名称', 'default' => '', 'desc' => '公司名称', 'match' => 'is_string', 'update' => 'text', //'search' => 'fulltext', //'list' => true, 'show' => 'type=2', ), 'company_pic' => array ( 'type' => 'varchar-150', 'name' => '营业执照', 'default' => '', 'desc' => '营业执照', 'match' => 'option', 'update' => 'image', 'key' => '8', //'place' => '660*660', 'show' => 'type=2', ), 'company_number' => array ( 'type' => 'varchar-80', 'name' => '营业执照号码', 'default' => '', 'desc' => '营业执照号码', 'match' => 'is_string', 'update' => 'text', 'show' => 'type=2', ), 'address' => array ( 'type' => 'varchar-800', 'name' => '地址', 'default' => '', 'desc' => '地址', 'match' => 'is_string', 'update' => 'text', ), 'audit_desc' => array ( 'type' => 'varchar-400', 'name' => '审核备注-从order_process中同步过来', 'default' => '', 'desc' => '审核备注', 'match' => 'is_string', //'update' => 'textarea', ), 'admin_desc' => array ( 'type' => 'varchar-800', 'name' => '管理员备注', 'default' => '', 'desc' => '管理员备注', 'match' => 'is_string', 'update' => 'textarea', ), 'status' => array ( 'type' => 'tinyint-1', 'name' => '订单状态', 'default' => '1', 'desc' => '状态', 'match' => 'is_numeric', 'option' => $status, 'search' => 'select', 'list' => $search_auth == 1 ? true : false, 'list_order' => 8, ), 'history_status' => array ( 'type' => 'tinyint-1', 'name' => '记录挂起之前的状态', 'default' => '1', 'desc' => '状态', 'match' => 'is_numeric', 'option' => $status, ), 'goods_status' => array ( 'type' => 'tinyint-1', 'name' => '权益状态', 'default' => '1', 'desc' => '权益状态', 'match' => 'is_numeric', 'option' => $goods_status, 'search' => 'select', 'list' => $search_auth == 1 ? true : false, 'list_order' => 9, ), 'pay_status' => array ( 'type' => 'tinyint-1', 'name' => '支付状态', 'default' => '1', 'desc' => '状态', 'match' => 'is_numeric', 'option' => $pay_status, ), 'get_type' => array ( 'type' => 'tinyint-1', 'name' => '获取方式', 'default' => '1', 'desc' => '获取方式', 'match' => 'is_numeric', 'update' => 'radio', 'option' => $get_type, ), 'agent_cash' => array ( 'type' => 'decimal-11,2', 'name' => '代理费', 'default' => '0', 'desc' => '代理费', 'match' => 'option', 'update' => 'text', 'list' => $search_auth == 2 || $search_pmid ? true : false, ), 'soft_cash' => array ( 'type' => 'decimal-11,2', 'name' => '软件服务费', 'default' => '0', 'desc' => '软件服务费', 'match' => 'option', 'update' => 'text', 'list' => $search_auth == 2 ? '{soft_cash}' : false, ), 'goods_cash' => array ( 'type' => 'decimal-11,2', 'name' => '商品价值-名额不算,商品价值第一次分配后保持不变', 'default' => '0', 'desc' => '商品价值', 'match' => 'option', 'update' => 'text', ), 'import' => array ( 'type' => 'tinyint-1', 'name' => '是否导入', 'default' => '1', 'desc' => '是否导入', 'match' => 'is_numeric', 'option' => $import, 'update' => 'radio', ), 'dever_auth' => array ( 'name' => '权限', 'default' => '', 'desc' => '类型', 'match' => 'is_string', 'search' => 'hidden', ), 'prize_type' => array ( 'type' => 'tinyint-1', 'name' => '是否名额内', 'default' => '1', 'desc' => '是否名额内', 'match' => 'is_numeric', 'option' => $prize_type, ), 'state' => array ( 'type' => 'tinyint-1', 'name' => '状态', 'default' => '1', 'desc' => '请选择状态', 'match' => 'is_numeric', ), 'fdate' => array ( 'type' => 'int-11', 'name' => '完成时间', 'default' => '', 'match' => 'is_numeric', 'search' => 'date', 'desc' => '', ), 'udate' => array ( 'type' => 'int-11', 'name' => '更新时间', 'default' => '', 'match' => 'is_numeric', 'desc' => '', 'order' => 'desc', ), 'cdate' => array ( 'type' => 'int-11', 'name' => '注册时间', 'match' => array('is_numeric', time()), 'default' => '', 'desc' => '', # 只有insert时才生效 'insert' => true, 'search' => 'date', // 'list' => 'date("Y-m-d H:i:s", {cdate})', 'list_name' => '注册时间
初审时间
终审时间
完成时间
', 'list' => $search_auth == 1 ? 'Dever::load("agent/lib/order.set_cdate", {id})' : false, 'list_order' => 200, ), ), 'alter' => array ( 10 => array ( array('update', 'price', 'price', 'decimal-11,2 0 实付金额'), array('update', 'f_price', 'f_price', 'decimal-11,2 0 原价'), array('update', 'agent_cash', 'agent_cash', 'decimal-11,2 0 代理费'), array('update', 'soft_cash', 'soft_cash', 'decimal-11,2 0 软件服务费'), array('update', 'goods_cash', 'goods_cash', 'decimal-11,2 0 商品价值'), array('update', 'pay_price', 'pay_price', 'decimal-11,2 0 交款金额'), array('update', 'option_price', 'option_price', 'decimal-11,2 0 赠送期权价值'), ), 11 => array ( array('update', 'pay_pic', 'pay_pic', 'text-255 打款凭证'), ), 'version' => 11, ), 'manage' => array ( //'list_table' => 'js', 'insert' => false, 'delete' => false, 'edit' => false, 'excel' => $excel, 'button' => $button, 'list_button' => $list_button, // ( // //fast_list // 'list' => array('查看详情', '"order_process&project=agent&order_id={id}&page_type=1&[refer]"'), // //'edit' => array('退款', 'status,tk_time,tk_pic,tk_desc,tk_admin,tk_status', '{status} == 6'), // //'delete' => array('删除', '', '{status} == 1'), // ), ), 'request' => array ( 'getNew' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'mid' => 'yes', 'status' => array('yes', 'in'), 'state' => 1, ), 'order' => array('id' => 'desc'), 'type' => 'one', 'col' => '*', ), 'getTotal' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'mid' => 'yes', 'status' => array('yes', 'in'), 'state' => 1, ), 'order' => array('id' => 'desc'), 'type' => 'count', 'col' => '*', ), 'getData' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'mid' => 'yes', 'status' => array('yes', 'in'), 'state' => 1, ), 'order' => array('id' => 'desc'), 'page' => array(10, 'list'), 'type' => 'all', 'col' => '*', ), # 获取订单数量 'getNum' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'start' => array('yes-cdate', '>='), 'end' => array('yes-cdate', '<='), 'fstart' => array('yes-fdate', '>='), 'fend' => array('yes-fdate', '<='), 'role' => 'yes', 'status' => array('yes', 'in'), 'state' => 1, ), 'type' => 'count', 'col' => '*', ), # 获取订单数量 'getCash' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'start' => array('yes-cdate', '>='), 'end' => array('yes-cdate', '<='), 'fstart' => array('yes-fdate', '>='), 'fend' => array('yes-fdate', '<='), 'role' => 'yes', 'status' => array('yes', 'in'), 'state' => 1, ), 'type' => 'one', 'col' => 'sum(price) as total', ), 'getDailiCash' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'start' => array('yes-cdate', '>='), 'end' => array('yes-cdate', '<='), 'fstart' => array('yes-fdate', '>='), 'fend' => array('yes-fdate', '<='), 'status' => array('yes', 'in'), 'state' => 1, ), 'type' => 'one', 'col' => 'sum(agent_cash) as total', ), #期权价值 'getOptionPrice' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'start' => array('yes-cdate', '>='), 'end' => array('yes-cdate', '<='), 'fstart' => array('yes-fdate', '>='), 'fend' => array('yes-fdate', '<='), 'status' => array('yes', 'in'), 'role' => 'yes', 'state' => 1, ), 'type' => 'one', 'col' => 'sum(option_price) as total', ), 'getSoftCash' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'start' => array('yes-cdate', '>='), 'end' => array('yes-cdate', '<='), 'fstart' => array('yes-fdate', '>='), 'fend' => array('yes-fdate', '<='), 'status' => array('yes', 'in'), 'role' => 'yes', 'state' => 1, ), 'type' => 'one', 'col' => 'sum(soft_cash) as total', ), 'getSoftNoCash' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'fstart' => array('yes-cdate', '>='), 'fend' => array('yes-cdate', '<='), 'status' => array('yes', 'in'), 'state' => 1, ), 'type' => 'one', 'col' => 'sum(soft_cash) as total', ), 'getSoftNum' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'fstart' => array('yes-fdate', '>='), 'fend' => array('yes-fdate', '<='), 'soft_cash' => array('yes', '>='), 'status' => array('yes','in'), 'state' => 1, ), 'type' => 'count', 'col' => '*', ), 'getSoftNoNum' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'fstart' => array('yes-cdate', '>='), 'fend' => array('yes-cdate', '<='), 'soft_cash' => array('yes', '>='), 'status' => array('yes','in'), 'state' => 1, ), 'type' => 'count', 'col' => '*', ), 'getGoodsCash' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'start' => array('yes-cdate', '>='), 'end' => array('yes-cdate', '<='), 'fstart' => array('yes-fdate', '>='), 'fend' => array('yes-fdate', '<='), 'status' => array('yes', 'in'), 'state' => 1, ), 'type' => 'one', 'col' => 'sum(goods_cash) as total', ), 'getFindOne' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'id' => array('yes','!='), 'mid' => 'yes', 'order_type' => 'yes', 'state' => 1, ), 'type' => 'one', 'order' => array('cdate' => 'desc'), 'col' => '*', ), 'getPrice' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'mid' => 'yes', 'status' => 4, 'state' => 1, ), 'type' => 'one', 'col' => 'sum(price) as total', ), 'getCount' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'start' => array('yes-fdate','>='), 'end' => array('yes-fdate','<='), 'mid' => array('yes', 'in'), 'parent_mid' => array('yes', 'in'), 'role' => array('yes','in'), 'status' => 4, 'state' => 1, ), 'type' => 'one', 'col' => 'sum(agent_cash) as total', ), 'getVCount' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'start' => array('yes-fdate','>='), 'end' => array('yes-fdate','<='), 'mid' => 'yes', 'parent_mid' => 'yes', 'role' => array('yes','in'), 'status' => 4, 'state' => 1, ), 'type' => 'one', 'col' => 'sum(price) as total', ), 'getExcelAll' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'start' => array('yes-cdate', '>='), 'end' => array('yes-cdate', '<='), 'fstart' => array('yes-fdate', '>='), 'fend' => array('yes-fdate', '<='), 'status' => array('yes', 'in'), 'state' => 1, ), 'type' => 'all', 'col' => '*', ), 'getSum' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'start' => array('yes-fdate', '>='), 'end' => array('yes-fdate', '<='), 'fstart' => array('yes-fdate', '>='), 'fend' => array('yes-fdate', '<='), 'status' => array('yes', 'in'), 'role' => 'yes', 'state' => 1, ), 'type' => 'one', 'col' => 'sum(price) as total', ), 'getAll' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'start' => array('yes-fdate','>='), 'end' => array('yes-fdate','<='), 'mid' => 'yes', 'area' => array('yes','in'), 'role' => array('yes','in'), 'state' => 1, ), 'type' => 'all', 'page' => array(20,'list'), 'col' => 'id,mid,name,mobile,idcard,soft_cash,option_price,price,area,role,agent_cash', ), 'getDataByNew' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'id' => 'yes', 'ids' => array('yes-id', '>='), 'status' => 4, 'state' => 1, ), 'order' => array('id' => 'asc'), 'type' => 'all', //'limit' => '0,2', 'col' => '*', ), 'getDataBySoft' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'soft_cash' => array('yes', '>='), 'status' => 4, 'state' => 1, ), 'order' => array('id' => 'asc'), 'type' => 'all', 'col' => '*', ), 'getDataBySign' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'id' => 'yes', 'ids' => array('yes-id', '<'), 'pay_pic' => array('yes', 'like'), 'state' => 1, ), 'order' => array('id' => 'asc'), 'type' => 'all', //'limit' => '0,2', 'col' => 'id,mid,sign,pay_pic', ), 'getClose' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'mid' => 'yes', 'status' => array('yes', '!='), 'state' => 1, ), 'order' => array('id' => 'asc'), 'type' => 'all', 'col' => '*', ), 'getOrder' => array ( # 匹配的正则或函数 选填项 'option' => array ( 'mid' => 'yes', // 'status' => array('yes', '!='), 'state' => 1, ), 'order' => array('id' => 'asc'), 'type' => 'one', 'col' => '*,sum(agent_cash) as agent_cash', ), ), );