12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730 |
- //分类设置
- var Col_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ColName', title:'名称', sort: true}
- ,{field:'RecommendName', title:'推荐', sort: true}
- ,{field:'ColEnName', title:'英文名', sort: true}
- ]];
- //创客
- var Users_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'RealName', title:'真实姓名', sort: true}
- ,{field:'CertId', title:'身份证号', sort: true}
- ,{field:'UserLevel', title:'创客等级', sort: true}
- ,{field:'MerchantType', title:'商户创客类型', sort: true}
- ,{field:'MerchantDate', title:'成为商户型创客时间', sort: true}
- ,{field:'AuthFlagName', title:'实名标识', sort: true}
- ,{field:'RiskFlagName', title:'风控标识', sort: true}
- ,{field:'MakerCode', title:'创客编号', sort: true}
- ,{field:'SettleAmount', title:'最低结算金额', sort: true}
- ,{field:'CashFreezeAmt', title:'提现冻结金额', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ,{field:'StatusName', title:'状态', sort: true}
- ]];
- //创客分组
- var UserGroup_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ]];
- //创客等级设定
- var UserLevelSet_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'等级名称', sort: true}
- ,{field:'UpLevelDays', title:'升级天数', sort: true}
- ,{field:'UpLevelIntegral', title:'升级需要积分值', sort: true}
- ,{field:'UpLevelGrowth', title:'升级需要成长值', sort: true}
- ]];
- //创客详细信息
- var UserDetail_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //创客手机号为主键的关联表
- var UserForMobile_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //创客数据
- var UserData_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'GrowthValue', title:'成长值', sort: true}
- ,{field:'CurMoney', title:'当前余额', sort: true}
- ,{field:'Integral', title:'当前积分', sort: true}
- ,{field:'TotalOrderMoney', title:'消费总额', sort: true}
- ,{field:'TotalUseIntegral', title:'消耗积分总额', sort: true}
- ,{field:'FollowCount', title:'关注数', sort: true}
- ,{field:'FansCount', title:'粉丝数', sort: true}
- ,{field:'CollectionCount', title:'收藏数', sort: true}
- ,{field:'Coupons', title:'卡券包', sort: true}
- ,{field:'ToPayOrderCount', title:'待付款', sort: true}
- ,{field:'ToSendOrderCount', title:'待发货', sort: true}
- ,{field:'ToReceiveOrderCount', title:'待收货', sort: true}
- ,{field:'ToCommentOrderCount', title:'待评价', sort: true}
- ,{field:'ToRefundOrderCount', title:'退款售后', sort: true}
- ,{field:'ActiveRewardAmount', title:'激活奖励金额', sort: true}
- ,{field:'SettleAmount', title:'最低结算金额', sort: true}
- ,{field:'CashFreezeAmt', title:'提现冻结金额', sort: true}
- ,{field:'ProfitRewardRate', title:'分润奖励', sort: true}
- ]];
- //创客收货地址
- var UserAddress_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Address', title:'详细地址', sort: true}
- ,{field:'PostalCode', title:'邮政编码', sort: true}
- ,{field:'RealName', title:'收货人姓名', sort: true}
- ,{field:'Mobile', title:'手机号码', sort: true}
- ,{field:'Areas', title:'所在地区', sort: true}
- ]];
- //创客好友关联表
- var UserFriend_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //创客家庭成员
- var UserFamilyMember_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'姓名', sort: true}
- ,{field:'Mobile', title:'手机号', sort: true}
- ,{field:'MemberKind', title:'关系', sort: true}
- ,{field:'IdCardNo', title:'身份证号', sort: true}
- ,{field:'Job', title:'职业', sort: true}
- ]];
- //商品信息
- var Products_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ProductName', title:'商品名称', sort: true}
- ,{field:'Stock', title:'库存', sort: true}
- ,{field:'BuyCount', title:'已购买数', sort: true}
- ,{field:'CommentCount', title:'评价数', sort: true}
- ,{field:'GoodPercent', title:'好评率', sort: true}
- ,{field:'Price', title:'价格', sort: true}
- ,{field:'Integral', title:'抵扣积分', sort: true}
- ,{field:'MemberPrice', title:'创客价', sort: true}
- ,{field:'UserIntegral', title:'创客抵扣积分', sort: true}
- ,{field:'MerchantClassId', title:'商家分类', sort: true}
- ,{field:'ProductCode', title:'商品编号', sort: true}
- ]];
- //创客订单
- var Orders_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'OrderNo', title:'订单号', sort: true}
- ,{field:'RealName', title:'姓名', sort: true}
- ,{field:'Mobile', title:'手机号', sort: true}
- ,{field:'TotalPrice', title:'总价', sort: true}
- ,{field:'Areas', title:'所在地区', sort: true}
- ,{field:'Address', title:'详细地址', sort: true}
- ,{field:'ErpName', title:'物流名称', sort: true}
- ,{field:'ErpCode', title:'运单号', sort: true}
- ,{field:'SendDate', title:'发货时间', sort: true}
- ,{field:'PayMode', title:'支付方式', sort: true}
- ,{field:'TradeNo', title:'支付交易号', sort: true}
- ,{field:'StoreId', title:'仓库', sort: true}
- ,{field:'RefundStatus', title:'退款状态', sort: true}
- ,{field:'DeliveryType', title:'提货类型', sort: true}
- ,{field:'SendStatus', title:'发货状态', sort: true}
- ,{field:'ProductId', title:'商品名称', sort: true}
- ,{field:'StoreContact', title:'仓库联系人', sort: true}
- ,{field:'StoreType', title:'仓库类型', sort: true}
- ,{field:'StoreUserId', title:'仓库归属创客', sort: true}
- ,{field:'TopUserId', title:'顶级创客', sort: true}
- ,{field:'PayStatus', title:'支付状态', sort: true}
- ,{field:'BuyCount', title:'下单数量', sort: true}
- ,{field:'Remark', title:'订单备注', sort: true}
- ,{field:'StoreContactMobile', title:'仓库联系人电话', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //订单商品
- var OrderProduct_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ProductName', title:'商品名称', sort: true}
- ,{field:'ProductPrice', title:'商品单价', sort: true}
- ,{field:'ProductCount', title:'商品数量', sort: true}
- ,{field:'TotalPrice', title:'小计', sort: true}
- ,{field:'TotalIntegral', title:'积分', sort: true}
- ,{field:'ProductIntegral', title:'商品抵扣积分', sort: true}
- ,{field:'ProductCode', title:'商品编号', sort: true}
- ,{field:'StoreId', title:'发货仓库', sort: true}
- ]];
- //创客购物车
- var UserCar_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'BuyCount', title:'购买数量', sort: true}
- ]];
- //商家
- var Merchants_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ,{field:'Areas', title:'所在地区', sort: true}
- ,{field:'Principal', title:'负责人', sort: true}
- ,{field:'Phone', title:'联系电话', sort: true}
- ,{field:'StarNum1', title:'快递包装评分', sort: true}
- ,{field:'FollowCount', title:'关注数', sort: true}
- ,{field:'IsAuthName', title:'是否认证', sort: true}
- ,{field:'CommentCount', title:'评论数', sort: true}
- ,{field:'Address', title:'详细地址', sort: true}
- ,{field:'StarNum2', title:'送货速度评分', sort: true}
- ,{field:'StarNum3', title:'服务态度评分', sort: true}
- ]];
- //收藏
- var UserCollection_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'DataId', title:'数据Id', sort: true}
- ,{field:'Kind', title:'类别', sort: true}
- ,{field:'UserId', title:'创客Id', sort: true}
- ]];
- //退款申请
- var OrderRefund_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Reason', title:'退款原因', sort: true}
- ,{field:'Amount', title:'退款金额', sort: true}
- ,{field:'Mobile', title:'申请人手机号', sort: true}
- ,{field:'GoodStatus', title:'货物状态', sort: true}
- ]];
- //商品评价
- var ProductComment_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客Id', sort: true}
- ,{field:'ProductId', title:'商品Id', sort: true}
- ,{field:'OrderId', title:'订单Id', sort: true}
- ,{field:'Contents', title:'评论内容', sort: true}
- ,{field:'StarNum', title:'商品评分', sort: true}
- ,{field:'AgreeCount', title:'点赞数', sort: true}
- ,{field:'BackCount', title:'回复数', sort: true}
- ]];
- //商品规格项目
- var ProductNormItem_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ColName', title:'名称', sort: true}
- ]];
- //商品规格
- var ProductNorm_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ColName', title:'名称', sort: true}
- ,{field:'Price', title:'价格', sort: true}
- ,{field:'Integral', title:'抵扣积分', sort: true}
- ,{field:'UserPrice', title:'创客价', sort: true}
- ,{field:'UserIntegral', title:'创客抵扣积分', sort: true}
- ,{field:'Stock', title:'库存', sort: true}
- ,{field:'BuyCount', title:'已购买数', sort: true}
- ,{field:'Code', title:'编码', sort: true}
- ,{field:'LimitCount', title:'限购数量', sort: true}
- ]];
- //商品规格模板
- var ProductNormTemp_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ]];
- //商品运费模板
- var ProductFareTemp_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ,{field:'SendAreas', title:'发货地区', sort: true}
- ,{field:'SendAddress', title:'发货地址', sort: true}
- ,{field:'IsFreeName', title:'是否包邮', sort: true}
- ,{field:'MeterMode', title:'计价方式', sort: true}
- ,{field:'TransportMode', title:'运送方式', sort: true}
- ]];
- //运费按区域
- var ProductFareAreas_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //商品关键词库
- var ProductKeys_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'关键词', sort: true}
- ]];
- //商家分类
- var MerchantClass_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ColName', title:'名称', sort: true}
- ]];
- //创客线下签到记录
- var UserOfflineSignInRecords_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //商家商品分类
- var MerchantCol_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ColName', title:'名称', sort: true}
- ,{field:'RecommendName', title:'推荐', sort: true}
- ,{field:'ColEnName', title:'英文名', sort: true}
- ]];
- //订单号关联表
- var OrderForNo_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //手机验证码
- var MobileCodeCheck_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //店铺评价
- var MerchantComment_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客Id', sort: true}
- ,{field:'OrderId', title:'订单Id', sort: true}
- ,{field:'StarNum1', title:'快递包装评分', sort: true}
- ,{field:'StarNum2', title:'送货速度评分', sort: true}
- ,{field:'StarNum3', title:'服务态度评分', sort: true}
- ]];
- //商品评价点赞记录
- var ProductCommentAgree_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //快递公司
- var ErpCompanys_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ,{field:'Code', title:'编码', sort: true}
- ,{field:'Phone', title:'客服电话', sort: true}
- ,{field:'StatusName', title:'状态', sort: true}
- ]];
- //退款原因
- var OrderRefundReason_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ]];
- //自定义全局标签
- var CustomTagSet_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Tags', title:'标签', sort: true}
- ,{field:'Title', title:'标题', sort: true}
- ]];
- //优惠券
- var Coupons_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ,{field:'IsNewUserName', title:'新创客使用', sort: true}
- ,{field:'IsPublicName', title:'是否公开领取', sort: true}
- ,{field:'Stock', title:'库存', sort: true}
- ,{field:'Kind', title:'优惠券类型', sort: true}
- ,{field:'MerchantId', title:'商家', sort: true}
- ,{field:'ProductColId', title:'商品分类', sort: true}
- ,{field:'ProductId', title:'商品', sort: true}
- ,{field:'UserMaxLevel', title:'创客最高等级', sort: true}
- ,{field:'UserMinLevel', title:'创客最低等级', sort: true}
- ,{field:'UseStartDate', title:'开始使用时间', sort: true}
- ,{field:'UseEndDate', title:'结束使用时间', sort: true}
- ,{field:'IsRepeatName', title:'是否重复', sort: true}
- ,{field:'RepeatType', title:'重复类型', sort: true}
- ,{field:'IsReUseName', title:'是否一次性使用', sort: true}
- ,{field:'PublicStartDate', title:'公开领取开始时间', sort: true}
- ,{field:'PublicEndDate', title:'公开领取结束时间', sort: true}
- ,{field:'PublicMax', title:'公开每人领取数量', sort: true}
- ,{field:'PublicMaxByDay', title:'公开每人每天领取数量', sort: true}
- ,{field:'IsSuperposeName', title:'是否叠加使用', sort: true}
- ,{field:'AndPromotionName', title:'是否与促销活动同时使用', sort: true}
- ,{field:'FullReduceMoney', title:'满多少可用', sort: true}
- ,{field:'FullReduceData', title:'满减数据', sort: true}
- ,{field:'ExpireStartDate', title:'过期开始时间', sort: true}
- ,{field:'ExpireEndDate', title:'过期结束时间', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ,{field:'StatusName', title:'状态', sort: true}
- ]];
- //优惠券领取记录
- var CouponsForUser_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'IsUseName', title:'是否使用', sort: true}
- ,{field:'IsLockName', title:'是否锁定', sort: true}
- ,{field:'UseDate', title:'使用时间', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //优惠券发放记录
- var CouponAssignRecords_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserMinLevel', title:'创客最低等级', sort: true}
- ,{field:'UserMaxLevel', title:'创客最高等级', sort: true}
- ,{field:'TotalOrderMoneyMin', title:'最小消费总额', sort: true}
- ,{field:'TotalOrderMoneyMax', title:'最大消费总额', sort: true}
- ,{field:'TotalUseIntegralMin', title:'最小消耗积分总额', sort: true}
- ,{field:'TotalUseIntegralMax', title:'最大消耗积分总额', sort: true}
- ,{field:'CurMoneyMin', title:'当前最低余额', sort: true}
- ,{field:'CurMoneyMax', title:'当前最高余额', sort: true}
- ,{field:'UserGroupId', title:'创客分组', sort: true}
- ,{field:'Areas', title:'创客所在地区', sort: true}
- ,{field:'Mobile', title:'手机号', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //商家管理员
- var MerchantAdmin_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'AdminName', title:'用户名', sort: true}
- ,{field:'RealName', title:'名称', sort: true}
- ,{field:'LastLoginDate', title:'最后登录时间', sort: true}
- ,{field:'Mobile', title:'手机号', sort: true}
- ,{field:'Email', title:'邮箱', sort: true}
- ,{field:'QQ', title:'QQ号', sort: true}
- ]];
- //分润对象
- var ProfitObjects_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ,{field:'MaxFloor', title:'最大层级', sort: true}
- ,{field:'MaxLevel', title:'最大等级', sort: true}
- ,{field:'MaxLevelContinueName', title:'到顶级是否继续', sort: true}
- ,{field:'MinProfitVal', title:'最小分润值', sort: true}
- ,{field:'StartDate', title:'开始时间', sort: true}
- ,{field:'EndDate', title:'结束时间', sort: true}
- ]];
- //激活奖励设置
- var ProfitObjectActivations_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'LimitDateKind', title:'限制时间类型', sort: true}
- ,{field:'LimitDateVal', title:'限制时间值', sort: true}
- ,{field:'LimitCustomerDate', title:'自定时间限制', sort: true}
- ,{field:'ExpiredNumber', title:'过期收益值', sort: true}
- ]];
- //继续分润层级
- var ProfitObjectContinueFloors_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'FloorNumber', title:'层级', sort: true}
- ,{field:'Percents', title:'分润比例', sort: true}
- ,{field:'AddProfitVal', title:'附加分润值', sort: true}
- ]];
- //分润对象层级
- var ProfitObjectFloors_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'FloorNumber', title:'层级', sort: true}
- ,{field:'Percents', title:'分润比例', sort: true}
- ,{field:'AddProfitVal', title:'附加分润值', sort: true}
- ,{field:'FloorDiffName', title:'级差', sort: true}
- ]];
- //分润对象等级分类
- var ProfitObjectLevelKinds_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ]];
- //分润对象等级
- var ProfitObjectLevels_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'LevelNumber', title:'级别', sort: true}
- ,{field:'Name', title:'名称', sort: true}
- ,{field:'Percents', title:'分润比例', sort: true}
- ,{field:'AddProfitVal', title:'附加分润值', sort: true}
- ,{field:'LevelDiffName', title:'级差', sort: true}
- ,{field:'DebitPercents', title:'借记卡分润比例', sort: true}
- ,{field:'DebitAddProfitVal', title:'借记卡附加分润值', sort: true}
- ]];
- //分润对象活动奖
- var ProfitObjectsActives_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ,{field:'LimitDateKind', title:'限制时间类型', sort: true}
- ,{field:'LimitDateVal', title:'限制时间值', sort: true}
- ,{field:'LimitCustomerDate', title:'自定时间限制', sort: true}
- ,{field:'FinishNumber', title:'满足条件的数值', sort: true}
- ,{field:'ProfitNumber', title:'获得收益值', sort: true}
- ,{field:'StartDate', title:'活动开始时间', sort: true}
- ,{field:'EndDate', title:'活动结束时间', sort: true}
- ,{field:'MachineCount', title:'赠机台数', sort: true}
- ]];
- //激活奖励队列
- var ProfitObjectsActiveCheck_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //机具库
- var PosMachines_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'BindingState', title:'绑定状态', sort: true}
- ,{field:'ActivationState', title:'激活状态', sort: true}
- ,{field:'UserId', title:'所属创客', sort: true}
- ,{field:'PosSn', title:'SN编号', sort: true}
- ,{field:'BrandId', title:'产品类型', sort: true}
- ,{field:'ActivityList', title:'参加活动', sort: true}
- ,{field:'BindMerchantId', title:'绑定商户', sort: true}
- ,{field:'PosSnType', title:'机具类型', sort: true}
- ,{field:'DeviceType', title:'设备类型', sort: true}
- ]];
- //激活奖励记录
- var ActiveReward_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'MerchantId', title:'商户', sort: true}
- ,{field:'RewardAmount', title:'奖励金额', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'MerUserNav', title:'商户直属创客父级', sort: true}
- ,{field:'KqMerNo', title:'渠道商户编号', sort: true}
- ,{field:'KqSnNo', title:'渠道SN号', sort: true}
- ,{field:'SnType', title:'机具类型', sort: true}
- ,{field:'SnApplyUserId', title:'机具申请创客', sort: true}
- ,{field:'ActType', title:'激活类型', sort: true}
- ,{field:'SnStoreId', title:'SN仓库', sort: true}
- ,{field:'ActDate', title:'激活时间', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客账户
- var UserAccount_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'TotalAmount', title:'总金额', sort: true}
- ,{field:'FreezeAmount', title:'冻结金额', sort: true}
- ,{field:'BalanceAmount', title:'余额', sort: true}
- ,{field:'AccountStatus', title:'账户状态', sort: true}
- ,{field:'WithdrawAmount', title:'已提现金额', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客账户变动记录
- var UserAccountRecord_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'ChangeType', title:'变动类型', sort: true}
- ,{field:'ProductType', title:'产品类型', sort: true}
- ,{field:'ChangeAmount', title:'变更金额', sort: true}
- ,{field:'BeforeTotalAmount', title:'变更前总金额', sort: true}
- ,{field:'AfterTotalAmount', title:'变更后总金额', sort: true}
- ,{field:'BeforeFreezeAmount', title:'变更前冻结金额', sort: true}
- ,{field:'AfterFreezeAmount', title:'变更后冻结金额', sort: true}
- ,{field:'BeforeBalanceAmount', title:'变更前余额', sort: true}
- ,{field:'AfterBalanceAmount', title:'变更后余额', sort: true}
- ,{field:'Remark', title:'账户变动明细备注信息', sort: true}
- ,{field:'TransRecordNo', title:'交易流水编号', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //商户
- var MerchantInfo_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'MerchantNo', title:'商户编号', sort: true}
- ,{field:'MerchantName', title:'商户姓名', sort: true}
- ,{field:'MerchantMobile', title:'商户手机号', sort: true}
- ,{field:'KqMerNo', title:'渠道商户编码', sort: true}
- ,{field:'KqSnNo', title:'渠道SN号', sort: true}
- ,{field:'MerStatus', title:'商户状态', sort: true}
- ,{field:'ActiveStatus', title:'商户激活状态', sort: true}
- ,{field:'DirectUserId', title:'直属创客编号', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'MerUserId', title:'商户创客', sort: true}
- ,{field:'SnType', title:'机具类型', sort: true}
- ,{field:'SnApplyUserId', title:'机具SN申请创客', sort: true}
- ,{field:'KqRegTime', title:'渠道注册时间', sort: true}
- ,{field:'ActType', title:'激活类型', sort: true}
- ,{field:'SnStoreId', title:'SN仓库', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'MerUserType', title:'商户创客类型', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //商户实名信息
- var MerchantAuth_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ChannelCode', title:'渠道编码', sort: true}
- ,{field:'ChannelName', title:'渠道名称 ', sort: true}
- ,{field:'MerNo', title:'商户编号', sort: true}
- ,{field:'RealName', title:'真实姓名', sort: true}
- ,{field:'IdCardNo', title:'身份证号', sort: true}
- ,{field:'BankCardAccount', title:'银行卡账号', sort: true}
- ,{field:'BankName', title:'银行名称', sort: true}
- ,{field:'BankMobile', title:'银行预留手机号码', sort: true}
- ,{field:'AuthType', title:'实名类型', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //仓库
- var StoreHouse_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'StoreNo', title:'仓库编号', sort: true}
- ,{field:'StoreName', title:'仓库名称', sort: true}
- ,{field:'UserId', title:'仓库归属人', sort: true}
- ,{field:'BrandId', title:'产品类型', sort: true}
- ,{field:'Address', title:'仓库地址', sort: true}
- ,{field:'ManageUserId', title:'仓库管理员', sort: true}
- ,{field:'ManagerEmail', title:'管理者邮箱', sort: true}
- ,{field:'StoreType', title:'仓库类型', sort: true}
- ,{field:'TotalNum', title:'总库存数', sort: true}
- ,{field:'LaveNum', title:'剩余库存数', sort: true}
- ,{field:'OutNum', title:'出库数', sort: true}
- ,{field:'LimitTopUserId', title:'限制创客特殊仓库', sort: true}
- ,{field:'StoreStatus', title:'仓库状态', sort: true}
- ,{field:'StoreKind', title:'仓库归属类型', sort: true}
- ,{field:'ManageMobile', title:'管理者手机号', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //银行信息
- var BankInfo_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'BankName', title:'银行全称', sort: true}
- ,{field:'BankCode', title:'银行编码', sort: true}
- ,{field:'UnitedBankNo', title:'银行总行联行号', sort: true}
- ,{field:'UnitedBankName', title:'总行名称', sort: true}
- ,{field:'BankNameAbbr', title:'银行简称', sort: true}
- ]];
- //活动信息
- var ActivityInfo_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ActCode', title:'活动编号', sort: true}
- ,{field:'ActType', title:'活动类型', sort: true}
- ,{field:'ActName', title:'活动名称', sort: true}
- ,{field:'BrandId', title:'产品类型', sort: true}
- ,{field:'LimitTopBuddy', title:'顶级创客设置', sort: true}
- ,{field:'IsTop', title:'是否置顶', sort: true}
- ,{field:'EffectStartDate', title:'活动开始时间', sort: true}
- ,{field:'EffectEndDate', title:'活动结束时间', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //活动报名记录
- var ActivityEnrolRecord_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ActId', title:'活动', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'EnrolMonth', title:'报名有效月份', sort: true}
- ,{field:'EffectStartTime', title:'报名有效开始时间', sort: true}
- ,{field:'EffectEndTime', title:'报名有效结束时间', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //仓库库存变动记录
- var StoreStockChange_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'StoreId', title:'仓库', sort: true}
- ,{field:'BrandId', title:'产品类型', sort: true}
- ,{field:'TransType', title:'交易类型', sort: true}
- ,{field:'SnNo', title:'SN编号', sort: true}
- ,{field:'StockOpDirect', title:'库存操作方向', sort: true}
- ,{field:'SnStatus', title:'SN状态', sort: true}
- ,{field:'BindStatus', title:'绑定状态', sort: true}
- ,{field:'BindMerchant', title:'绑定商户', sort: true}
- ,{field:'ActiveStatus', title:'激活状态', sort: true}
- ,{field:'ExpressNo', title:'快递单号', sort: true}
- ,{field:'BrandType', title:'品牌类型', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //兑换机具记录
- var StoreSwapSn_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'SnNo', title:'SN号', sort: true}
- ,{field:'SnType', title:'SN类型', sort: true}
- ,{field:'StandardDate', title:'达标日期', sort: true}
- ,{field:'PosType', title:'POS类型', sort: true}
- ,{field:'SwapStatus', title:'兑换状态', sort: true}
- ,{field:'BizStatus', title:'业务状态', sort: true}
- ,{field:'RiskStatus', title:'风控状态', sort: true}
- ,{field:'SwapExtProductTypes', title:'可兑换产品类型', sort: true}
- ,{field:'SwapSnNo', title:'兑换SN号', sort: true}
- ,{field:'SwapApplyOrderNo', title:'兑换申请单号', sort: true}
- ,{field:'SwapApplyDate', title:'兑换时间', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //机具申请订单
- var MachineApply_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ApplyNo', title:'申请单号', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'Areas', title:'收货所在地区', sort: true}
- ,{field:'Address', title:'收货详细地址', sort: true}
- ,{field:'RealName', title:'收件人姓名', sort: true}
- ,{field:'Mobile', title:'收件人手机号', sort: true}
- ,{field:'ApplyDeviceName', title:'申请机具名称', sort: true}
- ,{field:'ApplyDeviceNum', title:'申请机具数量', sort: true}
- ,{field:'ApplyTime', title:'申请时间', sort: true}
- ,{field:'SendStatus', title:'发货状态', sort: true}
- ,{field:'ExpressNo', title:'快递单号', sort: true}
- ,{field:'ExpressName', title:'快递名称', sort: true}
- ,{field:'DeliveryType', title:'提货类型', sort: true}
- ,{field:'StoreId', title:'发货仓库', sort: true}
- ,{field:'StoreName', title:'发货仓库名称', sort: true}
- ,{field:'StoreManager', title:'仓库联系人', sort: true}
- ,{field:'Remark', title:'订单备注', sort: true}
- ,{field:'StoreUserId', title:'仓库归属创客', sort: true}
- ,{field:'SendDate', title:'发货时间', sort: true}
- ,{field:'SendSn', title:'发货SN', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //机具申请明细
- var MachineApplyDetail_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ApplyNo', title:'订单号', sort: true}
- ,{field:'ProductType', title:'实际发货产品类型', sort: true}
- ,{field:'ProductName', title:'实际发货产品名称', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'DeviceSnNo', title:'设备SN编号', sort: true}
- ,{field:'DeviceStatus', title:'设备状态', sort: true}
- ,{field:'DeviceVendor', title:'设备厂商', sort: true}
- ,{field:'DeviceModel', title:'设备型号', sort: true}
- ,{field:'DeviceDesc', title:'设备描述', sort: true}
- ,{field:'UpSrcProName', title:'上级源机具产品名称', sort: true}
- ,{field:'SourceSnNo', title:'兑换来源SN编码', sort: true}
- ,{field:'SourceSnType', title:'兑换来源SN机具类型', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //机具转换订单
- var MachineChange_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //机具转换明细
- var MachineChangeDetail_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ChangeNo', title:'订单号', sort: true}
- ,{field:'BackProductType', title:'退回产品类型', sort: true}
- ,{field:'BackProductName', title:'退回产品名称', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BackSnNo', title:'设备SN编号', sort: true}
- ,{field:'BackDeviceStatus', title:'设备状态', sort: true}
- ,{field:'OutProductType ', title:'出库产品类型', sort: true}
- ,{field:'OutProductName', title:'出库产品名称', sort: true}
- ,{field:'OutSnNo', title:'出库设备SN编号', sort: true}
- ,{field:'OutSnType', title:'出库SN机具类型', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'BackSnType', title:'退回SN机具类型', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //分润奖励记录
- var ProfitRewardRecord_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'ProfitType', title:'创客分润类型', sort: true}
- ,{field:'OtherTradeAmt', title:'其他产品交易总金额', sort: true}
- ,{field:'OtherCreditTradeAmt', title:'其他产品贷记卡交易总金额', sort: true}
- ,{field:'OtherDebitNotCapTradeAmt', title:'其他产品借记卡非封顶交易总金额', sort: true}
- ,{field:'TradeAmt', title:'商户交易总额', sort: true}
- ,{field:'CreditTradeAmt', title:'贷记卡交易总金额', sort: true}
- ,{field:'QrCreditTradeAmt', title:'(云闪付)贷记卡交易总金额', sort: true}
- ,{field:'NonQrCreditTradeAmt', title:'(非云闪付)贷记卡交易总金额', sort: true}
- ,{field:'DebitNonCapTradeAmt', title:'商户非封顶借记卡交易总额', sort: true}
- ,{field:'QrDebitNotCapTradeAmt', title:'(云闪付)商户非封顶借记卡交易总额', sort: true}
- ,{field:'NonQrDebitNotCapTradeAmt', title:'(非云闪付)商户非封顶借记卡交易总额', sort: true}
- ,{field:'DebitCapTradeAmt', title:'商户借记卡封顶交易总额', sort: true}
- ,{field:'DebitCapTradeNum', title:'商户借记卡封顶交易总笔数', sort: true}
- ,{field:'TradeProfit', title:'交易分润', sort: true}
- ,{field:'CreditTradeProfit', title:'贷记卡分润总金额', sort: true}
- ,{field:'QrCreditTradeProfit', title:'(云闪付)贷记卡交易分润', sort: true}
- ,{field:'NonQrCreditTradeProfit', title:'(非云闪付)贷记卡交易分润', sort: true}
- ,{field:'DebitNonTradeCapProfit', title:'借记卡非封顶交易分润总金额', sort: true}
- ,{field:'QrDebitNonTradeCapProfit', title:'(云闪付)借记卡非封顶交易分润总金额', sort: true}
- ,{field:'NonQrDebitNonTradeCapProfit', title:'(非云闪付)借记卡非封顶交易分润总金额', sort: true}
- ,{field:'DebitTradeCapProfit', title:'借记卡封顶交易分润总金额', sort: true}
- ,{field:'CheckStatus', title:'验证和同步账户状态', sort: true}
- ,{field:'TradeMonth', title:'交易月', sort: true}
- ,{field:'RecordNo', title:'记录单号', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //交易记录
- var TradeRecord_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'MerchantId', title:'商户', sort: true}
- ,{field:'MerNo', title:'渠道商户编号', sort: true}
- ,{field:'MerHelpFlagName', title:'是否属于扶持周期内商户', sort: true}
- ,{field:'MerBuddyType', title:'商户创客类型', sort: true}
- ,{field:'SnNo', title:'渠道SN号', sort: true}
- ,{field:'TradeDate', title:'交易日期', sort: true}
- ,{field:'TradeSerialNo', title:'交易流水号', sort: true}
- ,{field:'TradeAmount', title:'交易金额', sort: true}
- ,{field:'BankCardType', title:'银行卡类型', sort: true}
- ,{field:'QrPayFlag', title:'云闪付标识', sort: true}
- ,{field:'CapFlag', title:'借记卡封顶交易标志', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //开机奖励明细
- var OpenRewardDetail_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'TradeDate', title:'达标日期', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'MerchantId', title:'商户', sort: true}
- ,{field:'DirectUserId', title:'商户直属人', sort: true}
- ,{field:'SnNo', title:'SN号', sort: true}
- ,{field:'MerNo', title:'渠道商户号', sort: true}
- ,{field:'SnType', title:'机具类型', sort: true}
- ,{field:'SnApplyUserId', title:'机具申请人', sort: true}
- ,{field:'StandardDate', title:'商户的激活日期', sort: true}
- ,{field:'SnStoreId', title:'SN仓库', sort: true}
- ,{field:'MerBuddyType', title:'商户创客类型', sort: true}
- ,{field:'RewardType', title:'奖励类型', sort: true}
- ,{field:'CreditTradeAmt', title:'贷记卡交易总金额', sort: true}
- ,{field:'DebitTradeAmt', title:'借记卡交易总金额', sort: true}
- ,{field:'CreditRewardAmount', title:'贷记卡交易奖励金额', sort: true}
- ,{field:'DebitRewardAmount', title:'借记记卡交易奖励金额', sort: true}
- ,{field:'OpenRewardNo', title:'开机奖励单号', sort: true}
- ,{field:'RewardDesc', title:'奖励描述', sort: true}
- ,{field:'CheckStatus', title:'同步状态', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客反馈
- var UserBack_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'Content', title:'回复内容', sort: true}
- ,{field:'IsPhoneCallBackName', title:'是否需要电话回复', sort: true}
- ,{field:'BackKind', title:'反馈类型', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客反馈类型
- var UserBackKind_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ]];
- //服务中心
- var ServiceCenter_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Title', title:'标题', sort: true}
- ,{field:'CategoryId', title:'问答类型', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //提现记录
- var UserCashRecord_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'CashOrderNo', title:'申请提现单号', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'IdCardNo', title:'身份证号', sort: true}
- ,{field:'SettleBankCardNo', title:'提现卡号', sort: true}
- ,{field:'SettleBankName', title:'银行名称', sort: true}
- ,{field:'TradeType', title:'交易类型', sort: true}
- ,{field:'TradeAmount', title:'交易金额', sort: true}
- ,{field:'ReturnCode', title:'返回编码', sort: true}
- ,{field:'ReturnMsg', title:'返回信息', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客绑卡记录
- var UserAuthRecord_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ChannelCode', title:'渠道编码', sort: true}
- ,{field:'ChannelName', title:'渠道名称', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'RealName', title:'真实姓名', sort: true}
- ,{field:'IdcardNo', title:'身份证号码', sort: true}
- ,{field:'BankCardAccount', title:'银行卡账号', sort: true}
- ,{field:'BankName', title:'银行名称', sort: true}
- ,{field:'BankMobile', title:'银行预留手机号码', sort: true}
- ,{field:'AuthType', title:'实名类型', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //页面模板更新信息
- var PageUpdateInfo_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ModuleVersion', title:'模板更新版本', sort: true}
- ,{field:'ModulePath', title:'模板路径', sort: true}
- ]];
- //资源文件更新信息
- var FileUpdateInfo_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'VersionNum', title:'更新版本', sort: true}
- ,{field:'Path', title:'路径', sort: true}
- ,{field:'FileName', title:'文件名', sort: true}
- ]];
- //App版本管理
- var AppVersion_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'TerminalKind', title:'终端类型', sort: true}
- ,{field:'VersionNum', title:'版本号', sort: true}
- ,{field:'Title', title:'标题', sort: true}
- ,{field:'ConfirmText', title:'确定按钮文字', sort: true}
- ,{field:'CancelText', title:'取消按钮文字', sort: true}
- ,{field:'DownloadUrl', title:'更新地址', sort: true}
- ,{field:'StatusName', title:'状态', sort: true}
- ]];
- //App底部导航
- var AppBottomNavs_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Title', title:'标题', sort: true}
- ,{field:'SelectTextColor', title:'选中文字颜色', sort: true}
- ,{field:'NormalTextColor', title:'未选中文字颜色', sort: true}
- ,{field:'PageName', title:'关联页面文件', sort: true}
- ,{field:'NoPageHint', title:'空页面提示信息', sort: true}
- ,{field:'BgColor', title:'背景色', sort: true}
- ,{field:'StatusName', title:'状态', sort: true}
- ]];
- //上传配置项
- var UploadParams_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'TableName', title:'表名', sort: true}
- ,{field:'ColumnName', title:'字段名', sort: true}
- ,{field:'ColumnEnName', title:'字段英文明', sort: true}
- ,{field:'ParamString', title:'参数', sort: true}
- ,{field:'TableEnName', title:'表英文名', sort: true}
- ]];
- //流量分佣明细
- var FluxProfitDetail_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'TradeDate', title:'交易日期', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'MerchantId', title:'商户', sort: true}
- ,{field:'MerNo', title:'渠道商户编号', sort: true}
- ,{field:'SnNo', title:'渠道SN号', sort: true}
- ,{field:'ProfitType', title:'分润类型', sort: true}
- ,{field:'FluxOrderNo', title:'流量扣费单号', sort: true}
- ,{field:'TradeOrderNo', title:'交易流水号', sort: true}
- ,{field:'TradeAmt', title:'商户交易额', sort: true}
- ,{field:'FluxFeeAmt', title:'流量费', sort: true}
- ,{field:'FluxStartDate', title:'流量扣费开始日期', sort: true}
- ,{field:'FluxEndDate', title:'流量扣费结束日期', sort: true}
- ,{field:'FluxProfitAmt', title:'流量分润总金额', sort: true}
- ,{field:'MerUserType', title:'商户创客类型', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //分润补贴明细
- var ProfitSubsidyDetail_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'MerchantId', title:'商户', sort: true}
- ,{field:'MerNo', title:'渠道商户编号', sort: true}
- ,{field:'SnNo', title:'渠道SN号', sort: true}
- ,{field:'MerRegTime', title:'渠道注册时间', sort: true}
- ,{field:'MerStandardDate', title:'商户激活时间', sort: true}
- ,{field:'SubsidyUserId', title:'补贴人', sort: true}
- ,{field:'SubsidyType', title:'分润补贴类型', sort: true}
- ,{field:'CreditTradeAmt', title:'商户贷记卡交易总金额', sort: true}
- ,{field:'QrCreditTradeAmt', title:'商户(云闪付)贷记卡交易总金额', sort: true}
- ,{field:'NonQrCreditTradeAmt', title:'商户(非云闪付)贷记卡交易总金额', sort: true}
- ,{field:'CreditProfitRate', title:'(非云闪付)贷记卡交易分润比例', sort: true}
- ,{field:'SubsidyProfitRate', title:'创客活动期内直营商户分润万分之十', sort: true}
- ,{field:'SubsidyProfit', title:'商户(非云闪付)贷记卡交易分润补贴金额', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //返利明细表
- var UserRebateDetail_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'TradeMonth', title:'交易月份', sort: true}
- ,{field:'TradeDate', title:'达标日期', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'MgrNo', title:'渠道经理编号', sort: true}
- ,{field:'MgrName', title:'渠道经理姓名', sort: true}
- ,{field:'ProductType', title:'产品类型', sort: true}
- ,{field:'ProductName', title:'产品名称', sort: true}
- ,{field:'MerchantId', title:'商户', sort: true}
- ,{field:'ChannelMerNo', title:'渠道商户编号', sort: true}
- ,{field:'RebateType', title:'返利类型', sort: true}
- ,{field:'RebateMonthCount', title:'返利周期数', sort: true}
- ,{field:'CreditTradeAmt', title:'贷记卡交易总金额', sort: true}
- ,{field:'DebitTradeAmt', title:'借记卡交易总金额', sort: true}
- ,{field:'CreditRewardAmount', title:'贷记卡交易奖励金额', sort: true}
- ,{field:'DebitRewardAmount', title:'借记卡交易奖励金额', sort: true}
- ,{field:'RebateRewardNo', title:'达标返利单号', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //商户返利明细
- var MerchantRebateDetail_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'TradeMonth', title:'交易月份', sort: true}
- ,{field:'TradeDate', title:'达标日期', sort: true}
- ,{field:'MerNo', title:'渠道商户编号', sort: true}
- ,{field:'SnNo', title:'渠道SN号', sort: true}
- ,{field:'MerRegTime', title:'渠道注册时间', sort: true}
- ,{field:'MerStandardDate', title:'商户激活时间', sort: true}
- ,{field:'MerchantId', title:'商户', sort: true}
- ,{field:'MmpUserNo', title:'KYS刷APP创客编号', sort: true}
- ,{field:'MmpUserName', title:'KYS商户真实姓名', sort: true}
- ,{field:'CreditTradeAmt', title:'贷记卡交易总金额', sort: true}
- ,{field:'DebitTradeAmt', title:'借记卡交易总金额', sort: true}
- ,{field:'CreditRewardAmount', title:'贷记卡交易奖励金额', sort: true}
- ,{field:'DebitRewardAmount', title:'借记卡交易奖励金额', sort: true}
- ,{field:'SyncStatus', title:'同步MMP', sort: true}
- ,{field:'RewardDesc', title:'奖励描述', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //循环返风控白名单
- var UserSwapWhite_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'RiskType', title:'风控类型', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //拉新活动信息
- var PullNewAct_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'SnDelayDay', title:'机具延时时间', sort: true}
- ,{field:'ProductType', title:'产品类型', sort: true}
- ,{field:'ProductName', title:'产品名称', sort: true}
- ,{field:'ActEffectStartDate', title:'有效开始时间', sort: true}
- ,{field:'ActEffectEndDate', title:'有效结束时间', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //拉新明细
- var PullNewDetail_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'StatDate', title:'统计日期', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'RecUserId', title:'招募人', sort: true}
- ,{field:'RecMallOrderTime', title:'招募创客商城下单时间', sort: true}
- ,{field:'RecMallBrandId', title:'招募人商城订单品牌', sort: true}
- ,{field:'RecUserType', title:'商户创客类型', sort: true}
- ,{field:'RegDate', title:'注册时间', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客商城提大货SN
- var UserMallLargeSn_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'OrderNo', title:'订单号', sort: true}
- ,{field:'OrderAmount', title:'订单金额', sort: true}
- ,{field:'OrderNum', title:'订单数量', sort: true}
- ,{field:'RuleOrderAmt', title:'规则订单金额', sort: true}
- ,{field:'SnStatus', title:'SN状态', sort: true}
- ,{field:'SnNo', title:'SN编号', sort: true}
- ,{field:'SnType', title:'SN类型', sort: true}
- ,{field:'SnShipDate', title:'SN发货时间', sort: true}
- ,{field:'StoreId', title:'SN发货仓库', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //产品规则配置
- var KqProductRuleSet_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Deposit', title:'押金', sort: true}
- ,{field:'ActiveCount', title:'活动政策台数', sort: true}
- ,{field:'ActivePrice', title:'活动政策价格', sort: true}
- ,{field:'MerStaStartDate', title:'活动开始时间', sort: true}
- ,{field:'MerStaEndDate', title:'活动结束时间', sort: true}
- ,{field:'MerStaProfit', title:'达标奖励', sort: true}
- ,{field:'MerStaMonths', title:'激活后达标月', sort: true}
- ,{field:'MerStaTradeForMonth', title:'激活后每月达标交易', sort: true}
- ,{field:'ActStartDate', title:'活动开始时间', sort: true}
- ,{field:'ActEndDate', title:'活动结束时间', sort: true}
- ,{field:'ActDeposit', title:'激活押金', sort: true}
- ,{field:'ActFirst', title:'激活首刷', sort: true}
- ,{field:'ActFirstDeposit', title:'激活首刷押金', sort: true}
- ,{field:'ActPrize', title:'激活奖励金额', sort: true}
- ,{field:'ActPosCount', title:'激活赠机台数', sort: true}
- ,{field:'OpenStartDate', title:'活动开始时间', sort: true}
- ,{field:'OpenEndDate', title:'活动结束时间', sort: true}
- ,{field:'OpenStaDays', title:'达标天数', sort: true}
- ,{field:'OpenStaTrade', title:'达标交易', sort: true}
- ,{field:'OpenStaPrize', title:'达标奖励1', sort: true}
- ,{field:'OpenStaPrize2', title:'达标奖励2', sort: true}
- ,{field:'CycleStartDate', title:'活动开始时间', sort: true}
- ,{field:'CycleEndDate', title:'活动结束时间', sort: true}
- ,{field:'CycleIsOtherName', title:'是否允许划拨给他人', sort: true}
- ,{field:'CyclePosDays', title:'领机天数', sort: true}
- ,{field:'PullNewStartDate', title:'活动开始时间', sort: true}
- ,{field:'PullNewEndDate', title:'活动结束时间', sort: true}
- ,{field:'PullNewExtendDays', title:'延长领机天数', sort: true}
- ,{field:'BigTotalAmount', title:'购买机起始价', sort: true}
- ,{field:'BigExtendCycleDays', title:'延长循环周期天数', sort: true}
- ,{field:'SubsidyStartDate', title:'活动开始时间', sort: true}
- ,{field:'SubsidyEndDate', title:'活动结束时间', sort: true}
- ,{field:'FlowCardStartDate', title:'活动开始时间', sort: true}
- ,{field:'FlowCardEndDate', title:'活动结束时间', sort: true}
- ,{field:'FlowCardFreeDays', title:'免收天数', sort: true}
- ,{field:'FlowCardFee', title:'费用', sort: true}
- ,{field:'FeeOfDays', title:'扣费频率(天)', sort: true}
- ,{field:'FlowCardDirectProfit', title:'直属上级返佣', sort: true}
- ,{field:'HelpStartDate', title:'活动开始时间', sort: true}
- ,{field:'HelpEndDate', title:'活动结束时间', sort: true}
- ,{field:'HelpMonths', title:'计算自然月', sort: true}
- ,{field:'HelpFee', title:'扶植期费率', sort: true}
- ,{field:'HelpSteadyFee', title:'稳定期费率', sort: true}
- ,{field:'FeeBindDays', title:'绑定起天数', sort: true}
- ,{field:'FeeFixed', title:'固定手续费', sort: true}
- ,{field:'FeeRate', title:'费率', sort: true}
- ,{field:'StatusName', title:'状态', sort: true}
- ]];
- //产品库
- var KqProducts_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ]];
- //产品品牌
- var KqProductBrand_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'品牌名称', sort: true}
- ]];
- //产品机构
- var KqProductOrgs_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'机构名称', sort: true}
- ]];
- //仓库库存变动信息
- var StoreBalance_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'StoreId', title:'仓库', sort: true}
- ,{field:'TransRecordNo', title:'交易流水编号', sort: true}
- ,{field:'TransType', title:'交易类型', sort: true}
- ,{field:'BrandId', title:'产品类型', sort: true}
- ,{field:'OpStoreNum', title:'操作库存数', sort: true}
- ,{field:'OpSymbol', title:'操作符', sort: true}
- ,{field:'BeforeTotalNum', title:'操作前总库存数', sort: true}
- ,{field:'AfterTotalNum', title:'操作后总库存数', sort: true}
- ,{field:'BeforeLaveNum', title:'操作前剩余库存数', sort: true}
- ,{field:'AfterLaveNum', title:'操作后剩余库存数', sort: true}
- ,{field:'BeforeOutNum', title:'操作前出库数', sort: true}
- ,{field:'AfterOutNum', title:'操作后出库数', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //开团申请
- var TeamApply_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'TeamNo', title:'队伍编码', sort: true}
- ,{field:'TeamName', title:'队伍名称', sort: true}
- ,{field:'UserId', title:'队长', sort: true}
- ,{field:'Areas', title:'特训营所在地区', sort: true}
- ,{field:'EffectStartDate', title:'活动开始时间', sort: true}
- ,{field:'EffectEndDate', title:'活动结束时间', sort: true}
- ,{field:'EnterStartDate', title:'报名开始时间', sort: true}
- ,{field:'EnterEndDate', title:'报名结束时间', sort: true}
- ,{field:'MinUserNum', title:'最小队伍人数', sort: true}
- ,{field:'MaxUserNum', title:'最大队伍人数', sort: true}
- ,{field:'WatchWord', title:'口号', sort: true}
- ,{field:'AuditTime', title:'审核时间', sort: true}
- ,{field:'AuditResult', title:'审核结果', sort: true}
- ,{field:'AuditRemark', title:'审核备注', sort: true}
- ,{field:'NotifyFlag', title:'提醒标识', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'TopUserId', title:'顶级创客', sort: true}
- ,{field:'TeamStatus', title:'组队状态', sort: true}
- ]];
- //参团申请
- var TeamOfferApply_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Areas', title:'特训营所在地区', sort: true}
- ,{field:'EffectStartDate', title:'活动开始时间', sort: true}
- ,{field:'EffectEndDate ', title:'活动结束时间', sort: true}
- ,{field:'EnterDate', title:'报名时间', sort: true}
- ,{field:'AuditTime', title:'审核时间', sort: true}
- ,{field:'AuditResult', title:'审核结果', sort: true}
- ,{field:'AuditRemark', title:'审核备注', sort: true}
- ,{field:'NotifyFlag', title:'提醒标识', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'TeamId', title:'团队', sort: true}
- ,{field:'TeamLeader', title:'队长', sort: true}
- ,{field:'TopUserId', title:'顶级创客', sort: true}
- ,{field:'TeamApplyStatus', title:'组队申请状态', sort: true}
- ,{field:'TeamStatus', title:'状态', sort: true}
- ]];
- //开团配置
- var TeamConfig_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'LimitBuddyNo', title:'限制人', sort: true}
- ,{field:'MinUserNum', title:'最小队伍人数', sort: true}
- ,{field:'MaxUserNum', title:'最大队伍人数', sort: true}
- ,{field:'MinCycleNum', title:'最小周期天数', sort: true}
- ,{field:'MaxCycleNum', title:'最大周期天数', sort: true}
- ,{field:'MinStartDayLimit', title:'最小间隔天数', sort: true}
- ,{field:'MaxStartDayLimit', title:'最大间隔天数', sort: true}
- ,{field:'OverlineStatusName', title:'是否允许跨顶级线报名', sort: true}
- ,{field:'BlacklistCycle', title:'黑名单周期', sort: true}
- ,{field:'EnterEndMin', title:'活动时间差', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ]];
- //开团黑名单
- var TeamBlackList_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'EffectStartDate', title:'生效时间', sort: true}
- ,{field:'EffectEndDate', title:'失效时间', sort: true}
- ,{field:'TopUserId', title:'顶级创客', sort: true}
- ,{field:'BlackStatus', title:'状态', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //分润对象活动参数
- var ProfitObjectsActiveParams_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ProfitObjectsActiveId', title:'分润对象活动', sort: true}
- ,{field:'Name', title:'参数名称', sort: true}
- ,{field:'TextValue', title:'参数值', sort: true}
- ,{field:'Remark', title:'参数说明', sort: true}
- ]];
- //活动奖励明细
- var ActivityPrizeDetail_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'TradeAmt', title:'合伙人团队交易总金额', sort: true}
- ,{field:'CheckStatus', title:'同步状态', sort: true}
- ,{field:'TradeMonth', title:'交易月份', sort: true}
- ,{field:'OtherProdCreditTradeAmt', title:'其他组合计算产品贷记卡交易总金额', sort: true}
- ,{field:'CreditTradeAmt', title:'合伙人团队贷记卡交易总金额', sort: true}
- ,{field:'ActRewardAmt', title:'合伙人团队交易活动奖励金额', sort: true}
- ,{field:'ProfitRate', title:'活动奖励对应分成比例', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客机具延迟变动明细表
- var UserSnDelayChange_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'ChangeRecordNo', title:'变更记录单号', sort: true}
- ,{field:'SnNo', title:'SN编号', sort: true}
- ,{field:'SnType', title:'SN机具类型', sort: true}
- ,{field:'SnStoreId', title:'发货仓库', sort: true}
- ,{field:'InitCycleDate', title:'初始循环截止时间', sort: true}
- ,{field:'BeforeEndCycleDate', title:'变动前循环截止时间', sort: true}
- ,{field:'AfterEndCycleDate', title:'变动后循环截止时间', sort: true}
- ,{field:'RecUserId', title:'招募创客', sort: true}
- ,{field:'SnDelayDay', title:'机具延时天数', sort: true}
- ,{field:'ActivityRuleId', title:'拉新活动', sort: true}
- ,{field:'SourceSnNo', title:'源SN编号', sort: true}
- ,{field:'SourceSnType', title:'源SN类型', sort: true}
- ,{field:'SourceSnShipDate', title:'源SN发货时间', sort: true}
- ,{field:'SourceStoreId', title:'源SN发货你仓库', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客库存变动记录
- var UserStoreChange_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'产品类型', sort: true}
- ,{field:'TransType', title:'交易类型', sort: true}
- ,{field:'SnNo', title:'SN编号', sort: true}
- ,{field:'SnType', title:'SN机具类型', sort: true}
- ,{field:'StockOpDirect', title:'库存操作方向', sort: true}
- ,{field:'ToUserId', title:'收货创客', sort: true}
- ,{field:'ToStoreId', title:'创客退货收货仓库', sort: true}
- ,{field:'SourceStoreId', title:'源仓库', sort: true}
- ,{field:'SnStatus', title:'SN状态', sort: true}
- ,{field:'BindStatus', title:'绑定状态', sort: true}
- ,{field:'BindMerchantId', title:'绑定商户', sort: true}
- ,{field:'ActiveStatus', title:'激活状态', sort: true}
- ,{field:'ActRewardUserId', title:'激活奖励创客', sort: true}
- ,{field:'FromUserId', title:'出货创客', sort: true}
- ,{field:'BrandType', title:'品牌类型', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //机具变动历史
- var StoreChangeHistory_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'产品类型', sort: true}
- ,{field:'TransType', title:'交易类型', sort: true}
- ,{field:'SnNo', title:'SN编号', sort: true}
- ,{field:'SnType', title:'SN机具类型', sort: true}
- ,{field:'StockOpDirect', title:'库存操作方向', sort: true}
- ,{field:'ToUserId', title:'收货创客', sort: true}
- ,{field:'ToStoreId', title:'创客退货收货仓库', sort: true}
- ,{field:'SourceStoreId', title:'源仓库', sort: true}
- ,{field:'StoreId', title:'仓库', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客奖励记录
- var SysRechargeRecord_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'RechargeRecNo', title:'充值流水号', sort: true}
- ,{field:'ProductType', title:'产品类型', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BizType', title:'业务类型', sort: true}
- ,{field:'BizTime', title:'奖励时间', sort: true}
- ,{field:'Amount', title:'奖励金额', sort: true}
- ,{field:'SyncStatus', title:'同步状态', sort: true}
- ,{field:'BatchCode', title:'批次号', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客预设职级
- var UserRankWhite_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'用户', sort: true}
- ,{field:'Rank', title:'当前等级类型', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //循环返风控明细信息
- var UserSwapDetail_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'TradeMonth', title:'交易月', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'SnNo', title:'风控SN编号', sort: true}
- ,{field:'SnType', title:'风控SN机具类型', sort: true}
- ,{field:'RiskResult', title:'循环风控降档状态', sort: true}
- ,{field:'SwapExtProductTypes', title:'可申请循环产品类型', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //开机奖励
- var OpenReward_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'TradeDate', title:'达标日期', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'RewardType', title:'奖励类型', sort: true}
- ,{field:'CreditTradeAmt', title:'贷记卡交易总金额', sort: true}
- ,{field:'DebitTradeAmt', title:'借记卡交易总金额', sort: true}
- ,{field:'CreditRewardAmount', title:'贷记卡交易奖励金额', sort: true}
- ,{field:'DebitRewardAmount', title:'借记记卡交易奖励金额', sort: true}
- ,{field:'RewardMerCount', title:'达标商户数', sort: true}
- ,{field:'CheckStatus', title:'验证和同步账户状态', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //开机机具快照
- var OpenSnSnapshot_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'TradeDate', title:'达标日期', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'MerchantId', title:'商户', sort: true}
- ,{field:'DirectUserId', title:'商户直属人', sort: true}
- ,{field:'SnNo', title:'SN号', sort: true}
- ,{field:'MerNo', title:'渠道商户号', sort: true}
- ,{field:'StandardDate', title:'商户的激活日期', sort: true}
- ,{field:'RewardType', title:'奖励类型', sort: true}
- ,{field:'RewardTips', title:'奖励描述', sort: true}
- ,{field:'OpenRewardNo', title:'开机奖励单号', sort: true}
- ,{field:'BuySnNum', title:'购买机数量', sort: true}
- ,{field:'StdBuySnNum', title:'标准购买机数量', sort: true}
- ,{field:'RewardAmount', title:'奖励金额', sort: true}
- ,{field:'FailReason', title:'失败原因', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //机具退货申请订单
- var MachineReturn_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ApplyNo', title:'申请单号', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'DeviceNum', title:'申请退货数量', sort: true}
- ,{field:'ToStoreId', title:'退回仓库', sort: true}
- ,{field:'DeviceDesc', title:'设备描述', sort: true}
- ,{field:'AuditStatus', title:'审核状态', sort: true}
- ,{field:'Operator', title:'操作人', sort: true}
- ,{field:'Remark', title:'退货备注', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //机具激活限制信息
- var UserSnActInfo_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'产品类型', sort: true}
- ,{field:'SnNo', title:'SN编号', sort: true}
- ,{field:'SnType', title:'SN机具类型', sort: true}
- ,{field:'SnStoreId', title:'SN仓库', sort: true}
- ,{field:'EffectStartCycleDate', title:'有效开始循环时间', sort: true}
- ,{field:'EffectEndCycleDate', title:'有效结束循环时间', sort: true}
- ,{field:'ActUserId', title:'激活奖励创客', sort: true}
- ,{field:'ActiveStatus', title:'商户激活状态', sort: true}
- ,{field:'StandardDate', title:'激活日期', sort: true}
- ,{field:'SourceSnNo', title:'源SN编号', sort: true}
- ,{field:'SourceSnType', title:'源SN机具类型', sort: true}
- ,{field:'SourceShipDate', title:'源SN发货时间', sort: true}
- ,{field:'SourceStoreId', title:'源SN发货你仓库', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客预设分润
- var UserProfitSet_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'CardType', title:'交易卡类型', sort: true}
- ,{field:'HelpFlag', title:'扶持期标识', sort: true}
- ,{field:'ProfitRate', title:'创客预设分润比例', sort: true}
- ,{field:'ProfitPercent', title:'创客预设分润百分比', sort: true}
- ,{field:'AddOrSubRate', title:'浮动空间', sort: true}
- ,{field:'ProfitRateBase', title:'分润比例基数', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //交易日汇总
- var TradeDaySummary_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'TradeDate', title:'交易日', sort: true}
- ,{field:'TradeMonth', title:'交易月', sort: true}
- ,{field:'NotHelpDirectTradeAmt', title:'直营商户交易总额(非扶持期)', sort: true}
- ,{field:'NotHelpNonDirectTradeAmt', title:'非直营商户交易总额(非扶持期)', sort: true}
- ,{field:'NotHelpDirectCreditTradeAmt', title:'直营贷记卡交易总额(非扶持期)', sort: true}
- ,{field:'NotHelpNonDirectCreditTradeAmt', title:'非直营贷记卡交易总额(非扶持期)', sort: true}
- ,{field:'NotHelpDirectQrCreditTradeAmt', title:'直营云闪付贷记卡交易额(非扶持期)', sort: true}
- ,{field:'NotHelpNonDirectQrCreditTradeAmt', title:'非直营云闪付贷记卡交易额(非扶持期)', sort: true}
- ,{field:'NotHelpDirectNonQrCreditTradeAmt', title:'直营非云闪付贷记卡交易额(非扶持期)', sort: true}
- ,{field:'NotHelpNonDirectNonQrCreditTradeAmt', title:'非直营非云闪付贷记卡交易额(非扶持期)', sort: true}
- ,{field:'NotHelpDirectDebitTradeAmt', title:'直营商户借记卡交易总额(非扶持期)', sort: true}
- ,{field:'NotHelpDirectDebitCapTradeAmt', title:'直营商户借记卡封顶交易总金额(非扶持期)', sort: true}
- ,{field:'NotHelpDirectDebitCapNum', title:'直营商户借记卡封顶交易总数(非扶持期)', sort: true}
- ,{field:'NotHelpNonDirectDebitTradeAmt', title:'非直营商户借记卡交易总额(非扶持期)', sort: true}
- ,{field:'NotHelpNonDirectDebitCapTradeAmt', title:'非直营商户借记卡封顶交易总金额(非扶持期)', sort: true}
- ,{field:'NotHelpNonDirectDebitCapNum', title:'非直营商户借记卡封顶交易总数(非扶持期)', sort: true}
- ,{field:'NotHelpDirectQrDebitTradeAmt', title:'直营云闪付非封顶借记卡(非扶持期)', sort: true}
- ,{field:'NotHelpNonDirectQrDebitTradeAmt', title:'非直营云闪付非封顶借记卡(非扶持期)', sort: true}
- ,{field:'NotHelpDirectNonQrDebitTradeAmt', title:'直营非云闪付非封顶借记卡(非扶持期)', sort: true}
- ,{field:'NotHelpNonDirectNonQrDebitTradeAmt', title:'非直营非云闪付非封顶借记卡(非扶持期)', sort: true}
- ,{field:'HelpDirectTradeAmt', title:'直营商户交易总额(扶持期)', sort: true}
- ,{field:'HelpNonDirectTradeAmt', title:'非直营商户交易总额(扶持期)', sort: true}
- ,{field:'HelpDirectCreditTradeAmt', title:'直营贷记卡交易总额(扶持期)', sort: true}
- ,{field:'HelpNonDirectCreditTradeAmt', title:'非直营贷记卡交易总额(扶持期)', sort: true}
- ,{field:'HelpDirectQrCreditTradeAmt', title:'直营云闪付贷记卡交易额(扶持期)', sort: true}
- ,{field:'HelpNonDirectQrCreditTradeAmt', title:'非直营云闪付贷记卡交易额(扶持期)', sort: true}
- ,{field:'HelpDirectNonQrCreditTradeAmt', title:'直营非云闪付贷记卡交易额(扶持期)', sort: true}
- ,{field:'HelpNonDirectNonQrCreditTradeAmt', title:'非直营非云闪付贷记卡交易额(扶持期)', sort: true}
- ,{field:'HelpDirectDebitTradeAmt', title:'直营商户借记卡交易总额(扶持期)', sort: true}
- ,{field:'HelpDirectDebitCapTradeAmt', title:'直营商户借记卡封顶交易总金额(扶持期)', sort: true}
- ,{field:'HelpDirectDebitCapNum', title:'直营商户借记卡封顶交易总数(扶持期)', sort: true}
- ,{field:'HelpNonDirectDebitTradeAmt', title:'非直营商户借记卡交易总额(扶持期)', sort: true}
- ,{field:'HelpNonDirectDebitCapTradeAmt', title:'非直营商户借记卡封顶交易总金额(扶持期)', sort: true}
- ,{field:'HelpNonDirectDebitCapNum', title:'非直营商户借记卡封顶交易总数(扶持期)', sort: true}
- ,{field:'HelpDirectQrDebitTradeAmt', title:'直营云闪付非封顶借记卡(扶持期)', sort: true}
- ,{field:'HelpNonDirectQrDebitTradeAmt', title:'非直营云闪付非封顶借记卡(扶持期)', sort: true}
- ,{field:'HelpDirectNonQrDebitTradeAmt', title:'直营非云闪付非封顶借记卡(扶持期)', sort: true}
- ,{field:'HelpNonDirectNonQrDebitTradeAmt', title:'非直营非云闪付非封顶借记卡(扶持期)', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客交易日汇总
- var UserTradeDaySummary_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'TradeDate', title:'交易日', sort: true}
- ,{field:'TradeMonth', title:'交易月', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'DirectTradeAmt', title:'直营商户交易总额', sort: true}
- ,{field:'NonDirectTradeAmt', title:'非直营商户交易总额', sort: true}
- ,{field:'DirectDebitTradeAmt', title:'直营商户借记卡交易总额', sort: true}
- ,{field:'DirectDebitCapNum', title:'直营激活商户数', sort: true}
- ,{field:'NonDirectDebitTradeAmt', title:'非直营商户借记卡交易总额', sort: true}
- ,{field:'NonDirectDebitCapNum', title:'非直营激活商户数', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客分润补贴月汇总
- var UserProfitSubsidySummary_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'TradeMonth', title:'交易月', sort: true}
- ,{field:'SubsidyTotalProfit', title:'商户(非云闪付)贷记卡交易分润补贴总金额', sort: true}
- ,{field:'SubsidyJuniorProfit', title:'下级合伙人直属商户(非云闪付)贷记卡交易分润补贴总金额', sort: true}
- ,{field:'SubsidyDirectProfit', title:'直营商户(非云闪付)贷记卡交易分润补贴总金额', sort: true}
- ,{field:'CheckStatus', title:'验证和同步账户状态', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //交易按产品汇总
- var UserTradeMonthSummary_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'TradeMonth', title:'交易月', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'StatType', title:'交易统计类型', sort: true}
- ,{field:'TradeAmt', title:'商户交易总额', sort: true}
- ,{field:'CreditTradeAmt', title:'商户贷记卡交易总金额', sort: true}
- ,{field:'DebitNotCapTradeAmt', title:'商户非封顶借记卡交易总金额', sort: true}
- ,{field:'DebitCapTradeAmt', title:'商户借记卡封顶交易总额', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客循环返风控月汇总
- var UserSwapSummary_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'TradeMonth', title:'交易月', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'DirectActMerCount', title:'上月直营激活商户数', sort: true}
- ,{field:'DirAvgTradeAmt', title:'户均', sort: true}
- ,{field:'RiskStatus', title:'循环风控降档状态', sort: true}
- ,{field:'SwapExtProductTypes', title:'可申请循环产品类型', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //流量分佣汇总
- var FluxProfitSummary_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'TopUserId', title:'顶级创客', sort: true}
- ,{field:'TradeMonth', title:'交易月', sort: true}
- ,{field:'MerUserType', title:'商户创客类型', sort: true}
- ,{field:'FluxProfitAmt', title:'流量分润总金额', sort: true}
- ,{field:'FluxTradeNum', title:'商户借记卡封顶交易总笔数', sort: true}
- ,{field:'CheckStatus', title:'同步账户状态', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //仓库订单汇总
- var StoreMallOrderSummary_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'TradeMonth', title:'交易月', sort: true}
- ,{field:'StoreId', title:'仓库', sort: true}
- ,{field:'AgentStoreId', title:'代理分仓', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'UnitPrice', title:'单价', sort: true}
- ,{field:'OrderNum', title:'订单数量', sort: true}
- ,{field:'OrderAmt', title:'订单金额', sort: true}
- ,{field:'RefundOrderNum', title:'退款订单数量', sort: true}
- ,{field:'RefundAmt', title:'退款金额', sort: true}
- ,{field:'SettleStatus', title:'结算状态', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //拉新日统计信息
- var PullnewSummary_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'StatDate', title:'统计日', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'产品类型', sort: true}
- ,{field:'RecUserDeliveryStdNum', title:'招募创客提货达标人数', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //仓库SN激活统计
- var StoreSnActivateSummary_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'TradeDate', title:'交易日', sort: true}
- ,{field:'TradeMonth', title:'交易月', sort: true}
- ,{field:'StoreId', title:'仓库', sort: true}
- ,{field:'AgentStoreId', title:'代理分仓', sort: true}
- ,{field:'BrandId', title:'产品类型', sort: true}
- ,{field:'ActivateNum', title:'激活数量', sort: true}
- ,{field:'RejectActNum', title:'互斥激活数量', sort: true}
- ,{field:'TransferActNum', title:'划拨激活数量(循环机划拨激活数)', sort: true}
- ,{field:'EffectActNum', title:'有效激活数量', sort: true}
- ,{field:'UserApplyNum', title:'创客申请数量', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客收益排行
- var UserBalanceTop_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'Balance', title:'收益金额', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //特训营团队排行榜
- var TeamDayTop_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'TopUserId', title:'顶级创客', sort: true}
- ,{field:'TeamId', title:'队伍', sort: true}
- ,{field:'TeamUserId', title:'团队长创客', sort: true}
- ,{field:'TeamStartDate', title:'队伍开始时间', sort: true}
- ,{field:'TeamEndDate', title:'队伍结束时间', sort: true}
- ,{field:'TeamActMerNum', title:'队伍直营激活商户数', sort: true}
- ]];
- //创客职级信息
- var UserRank_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'Rank', title:'当前等级', sort: true}
- ,{field:'WhiteRank', title:'白名单等级', sort: true}
- ,{field:'NextRank', title:'下个等级', sort: true}
- ,{field:'TradeAmt', title:'团队交易总额', sort: true}
- ,{field:'OperateDate', title:'操作时间', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //机具损坏换新申请
- var MachineRenew_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'ApplyNo', title:'机具售后换新申请订单号', sort: true}
- ,{field:'ApplyDate', title:'机具售后换新申请时间', sort: true}
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'DamagedBrandId', title:'损坏的机具产品类型', sort: true}
- ,{field:'DamagedSnNo', title:'创客损坏的机具SN', sort: true}
- ,{field:'DamagedSnType', title:'损坏的机具SN机具类型', sort: true}
- ,{field:'ReplaceBrandId', title:'替换的机具产品类型', sort: true}
- ,{field:'ReplaceSnNo', title:'创客机具替换SN', sort: true}
- ,{field:'ReplaceSnType', title:'替换的机具SN机具类型', sort: true}
- ,{field:'DeliverBrandId', title:'仓库换新发货的机具产品类型', sort: true}
- ,{field:'DeliverSnNo', title:'仓库换新发货SN', sort: true}
- ,{field:'DemandDesc', title:'售后换新机具处理需求描述', sort: true}
- ,{field:'audit_status', title:'审核状态', sort: true}
- ,{field:'AuditDesc', title:'创客机具售后换新审核描述', sort: true}
- ,{field:'AuditDate', title:'审核时间', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
- //创客姓名为主键的关联表
- var UserForRealName_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //创客编号为主键的关联表
- var UserForMakerCode_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //仓库名称为主键的关联表
- var StoreForName_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //仓库编号为主键的关联表
- var StoreForCode_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //商户姓名为主键的关联表
- var MerchantForName_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //商户编号为主键的关联表
- var MerchantForCode_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //活动名称为主键的关联表
- var ProfitObjectsActivesForId_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //团队编号为主键的关联表
- var TeamApplyForTeamNo_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //团队名称为主键的关联表
- var TeamApplyForTeamName_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ]];
- //特训营个人排行榜
- var TeamPersonDayTop_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'TopUserId', title:'顶级创客', sort: true}
- ,{field:'TeamId', title:'队伍', sort: true}
- ,{field:'TeamUserId', title:'团队长创客', sort: true}
- ,{field:'TeamStartDate', title:'队伍开始时间', sort: true}
- ,{field:'TeamEndDate', title:'队伍结束时间', sort: true}
- ,{field:'ActMerNum', title:'团员直营激活商户数', sort: true}
- ]];
- //首页快捷入口
- var IndexIconList_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Title', title:'标题', sort: true}
- ,{field:'Url', title:'跳转地址', sort: true}
- ]];
- //个人中心常用工具
- var UserCenterIconList_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Title', title:'标题', sort: true}
- ,{field:'Url', title:'跳转地址', sort: true}
- ]];
- //创客分润规则
- var UserProfit_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'BrandId', title:'品牌', sort: true}
- ,{field:'CardType', title:'交易卡类型', sort: true}
- ,{field:'ProfitRate', title:'创客预设分润比例', sort: true}
- ,{field:'ProfitPercent', title:'创客预设分润百分比', sort: true}
- ,{field:'AddOrSubRate', title:'浮动空间', sort: true}
- ,{field:'ProfitRateBase', title:'分润比例基数', sort: true}
- ,{field:'Remark', title:'备注', sort: true}
- ,{field:'TopUserId', title:'顶级创客', sort: true}
- ,{field:'HelpAddOrSubRate', title:'扶持期浮动空间', sort: true}
- ,{field:'HelpProfitPercent', title:'扶持期创客预设分润百分比', sort: true}
- ,{field:'HelpProfitRate', title:'扶持期创客预设分润比例', sort: true}
- ,{field:'HelpProfitRateBase', title:'扶持期分润比例基数', sort: true}
- ]];
- //快联盟操作视频分类
- var AppVideo_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Name', title:'名称', sort: true}
- ]];
- //快联盟操作视频列表
- var AppVideoList_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'Title', title:'标题', sort: true}
- ,{field:'VideoId', title:'视频分类Id', sort: true}
- ]];
- //创客登录记录
- var UserLoginRecord_cols = [[
- { type: 'checkbox', fixed: 'left' }
- , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
- ,{field:'UserId', title:'创客', sort: true}
- ,{field:'Kind', title:'类别', sort: true}
- ,{field:'CreateDate', title:'创建时间', sort: true}
- ]];
|