12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088 |
- <?php
- $role = function()
- {
- $array = array();
- $data = Dever::load('setting/role-state');
- if($data)
- {
- $array += $data;
- }
- return $array;
- };
- $source_id = function()
- {
- $array = array
- (
- -1 => array
- (
- 'id' => '-1',
- 'name' => '无来源',
- ),
- );
- $data = Dever::load('setting/source-state');
- if($data)
- {
- $array += $data;
- }
- return $array;
- };
- $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;
- }
- $excel = false;
- if ($pmid) {
- $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();
- if($search_auth == 1){
- $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');
- }
- }
- $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' => $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' => $search_pmid ? false : array
- (
- 'api' => 'agent/member-getSearch',
- 'col' => 'col',
- 'result' => 'id',
- 'search' => 'parent_mid',
- ),
- 'list_name' => '上级信息',
- 'list' => $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' => '应付金额<br />实付金额<br />代理费<br />软件服务费<br />',
- '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 ? 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',
- ),
- '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' => '注册时间<br />初审时间<br />终审时间<br />完成时间<br />',
- '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' => 'yes',
- 'parent_mid' => 'yes',
- 'state' => 1,
- ),
- 'type' => 'one',
- 'col' => 'sum(price) 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' => '*',
- ),
- ),
- );
|