Main_Admin.js 87 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730
  1. //分类设置
  2. var Col_cols = [[
  3. { type: 'checkbox', fixed: 'left' }
  4. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  5. ,{field:'ColName', title:'名称', sort: true}
  6. ,{field:'RecommendName', title:'推荐', sort: true}
  7. ,{field:'ColEnName', title:'英文名', sort: true}
  8. ]];
  9. //创客
  10. var Users_cols = [[
  11. { type: 'checkbox', fixed: 'left' }
  12. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  13. ,{field:'RealName', title:'真实姓名', sort: true}
  14. ,{field:'CertId', title:'身份证号', sort: true}
  15. ,{field:'UserLevel', title:'创客等级', sort: true}
  16. ,{field:'MerchantType', title:'商户创客类型', sort: true}
  17. ,{field:'MerchantDate', title:'成为商户型创客时间', sort: true}
  18. ,{field:'AuthFlagName', title:'实名标识', sort: true}
  19. ,{field:'RiskFlagName', title:'风控标识', sort: true}
  20. ,{field:'MakerCode', title:'创客编号', sort: true}
  21. ,{field:'SettleAmount', title:'最低结算金额', sort: true}
  22. ,{field:'CashFreezeAmt', title:'提现冻结金额', sort: true}
  23. ,{field:'CreateDate', title:'创建时间', sort: true}
  24. ,{field:'StatusName', title:'状态', sort: true}
  25. ]];
  26. //创客分组
  27. var UserGroup_cols = [[
  28. { type: 'checkbox', fixed: 'left' }
  29. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  30. ,{field:'Name', title:'名称', sort: true}
  31. ]];
  32. //创客等级设定
  33. var UserLevelSet_cols = [[
  34. { type: 'checkbox', fixed: 'left' }
  35. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  36. ,{field:'Name', title:'等级名称', sort: true}
  37. ,{field:'UpLevelDays', title:'升级天数', sort: true}
  38. ,{field:'UpLevelIntegral', title:'升级需要积分值', sort: true}
  39. ,{field:'UpLevelGrowth', title:'升级需要成长值', sort: true}
  40. ]];
  41. //创客详细信息
  42. var UserDetail_cols = [[
  43. { type: 'checkbox', fixed: 'left' }
  44. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  45. ]];
  46. //创客手机号为主键的关联表
  47. var UserForMobile_cols = [[
  48. { type: 'checkbox', fixed: 'left' }
  49. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  50. ]];
  51. //创客数据
  52. var UserData_cols = [[
  53. { type: 'checkbox', fixed: 'left' }
  54. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  55. ,{field:'GrowthValue', title:'成长值', sort: true}
  56. ,{field:'CurMoney', title:'当前余额', sort: true}
  57. ,{field:'Integral', title:'当前积分', sort: true}
  58. ,{field:'TotalOrderMoney', title:'消费总额', sort: true}
  59. ,{field:'TotalUseIntegral', title:'消耗积分总额', sort: true}
  60. ,{field:'FollowCount', title:'关注数', sort: true}
  61. ,{field:'FansCount', title:'粉丝数', sort: true}
  62. ,{field:'CollectionCount', title:'收藏数', sort: true}
  63. ,{field:'Coupons', title:'卡券包', sort: true}
  64. ,{field:'ToPayOrderCount', title:'待付款', sort: true}
  65. ,{field:'ToSendOrderCount', title:'待发货', sort: true}
  66. ,{field:'ToReceiveOrderCount', title:'待收货', sort: true}
  67. ,{field:'ToCommentOrderCount', title:'待评价', sort: true}
  68. ,{field:'ToRefundOrderCount', title:'退款售后', sort: true}
  69. ,{field:'ActiveRewardAmount', title:'激活奖励金额', sort: true}
  70. ,{field:'SettleAmount', title:'最低结算金额', sort: true}
  71. ,{field:'CashFreezeAmt', title:'提现冻结金额', sort: true}
  72. ,{field:'ProfitRewardRate', title:'分润奖励', sort: true}
  73. ]];
  74. //创客收货地址
  75. var UserAddress_cols = [[
  76. { type: 'checkbox', fixed: 'left' }
  77. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  78. ,{field:'Address', title:'详细地址', sort: true}
  79. ,{field:'PostalCode', title:'邮政编码', sort: true}
  80. ,{field:'RealName', title:'收货人姓名', sort: true}
  81. ,{field:'Mobile', title:'手机号码', sort: true}
  82. ,{field:'Areas', title:'所在地区', sort: true}
  83. ]];
  84. //创客好友关联表
  85. var UserFriend_cols = [[
  86. { type: 'checkbox', fixed: 'left' }
  87. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  88. ]];
  89. //创客家庭成员
  90. var UserFamilyMember_cols = [[
  91. { type: 'checkbox', fixed: 'left' }
  92. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  93. ,{field:'Name', title:'姓名', sort: true}
  94. ,{field:'Mobile', title:'手机号', sort: true}
  95. ,{field:'MemberKind', title:'关系', sort: true}
  96. ,{field:'IdCardNo', title:'身份证号', sort: true}
  97. ,{field:'Job', title:'职业', sort: true}
  98. ]];
  99. //商品信息
  100. var Products_cols = [[
  101. { type: 'checkbox', fixed: 'left' }
  102. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  103. ,{field:'ProductName', title:'商品名称', sort: true}
  104. ,{field:'Stock', title:'库存', sort: true}
  105. ,{field:'BuyCount', title:'已购买数', sort: true}
  106. ,{field:'CommentCount', title:'评价数', sort: true}
  107. ,{field:'GoodPercent', title:'好评率', sort: true}
  108. ,{field:'Price', title:'价格', sort: true}
  109. ,{field:'Integral', title:'抵扣积分', sort: true}
  110. ,{field:'MemberPrice', title:'创客价', sort: true}
  111. ,{field:'UserIntegral', title:'创客抵扣积分', sort: true}
  112. ,{field:'MerchantClassId', title:'商家分类', sort: true}
  113. ,{field:'ProductCode', title:'商品编号', sort: true}
  114. ]];
  115. //创客订单
  116. var Orders_cols = [[
  117. { type: 'checkbox', fixed: 'left' }
  118. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  119. ,{field:'UserId', title:'创客', sort: true}
  120. ,{field:'OrderNo', title:'订单号', sort: true}
  121. ,{field:'RealName', title:'姓名', sort: true}
  122. ,{field:'Mobile', title:'手机号', sort: true}
  123. ,{field:'TotalPrice', title:'总价', sort: true}
  124. ,{field:'Areas', title:'所在地区', sort: true}
  125. ,{field:'Address', title:'详细地址', sort: true}
  126. ,{field:'ErpName', title:'物流名称', sort: true}
  127. ,{field:'ErpCode', title:'运单号', sort: true}
  128. ,{field:'SendDate', title:'发货时间', sort: true}
  129. ,{field:'PayMode', title:'支付方式', sort: true}
  130. ,{field:'TradeNo', title:'支付交易号', sort: true}
  131. ,{field:'StoreId', title:'仓库', sort: true}
  132. ,{field:'RefundStatus', title:'退款状态', sort: true}
  133. ,{field:'DeliveryType', title:'提货类型', sort: true}
  134. ,{field:'SendStatus', title:'发货状态', sort: true}
  135. ,{field:'ProductId', title:'商品名称', sort: true}
  136. ,{field:'StoreContact', title:'仓库联系人', sort: true}
  137. ,{field:'StoreType', title:'仓库类型', sort: true}
  138. ,{field:'StoreUserId', title:'仓库归属创客', sort: true}
  139. ,{field:'TopUserId', title:'顶级创客', sort: true}
  140. ,{field:'PayStatus', title:'支付状态', sort: true}
  141. ,{field:'BuyCount', title:'下单数量', sort: true}
  142. ,{field:'Remark', title:'订单备注', sort: true}
  143. ,{field:'StoreContactMobile', title:'仓库联系人电话', sort: true}
  144. ,{field:'CreateDate', title:'创建时间', sort: true}
  145. ]];
  146. //订单商品
  147. var OrderProduct_cols = [[
  148. { type: 'checkbox', fixed: 'left' }
  149. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  150. ,{field:'ProductName', title:'商品名称', sort: true}
  151. ,{field:'ProductPrice', title:'商品单价', sort: true}
  152. ,{field:'ProductCount', title:'商品数量', sort: true}
  153. ,{field:'TotalPrice', title:'小计', sort: true}
  154. ,{field:'TotalIntegral', title:'积分', sort: true}
  155. ,{field:'ProductIntegral', title:'商品抵扣积分', sort: true}
  156. ,{field:'ProductCode', title:'商品编号', sort: true}
  157. ,{field:'StoreId', title:'发货仓库', sort: true}
  158. ]];
  159. //创客购物车
  160. var UserCar_cols = [[
  161. { type: 'checkbox', fixed: 'left' }
  162. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  163. ,{field:'BuyCount', title:'购买数量', sort: true}
  164. ]];
  165. //商家
  166. var Merchants_cols = [[
  167. { type: 'checkbox', fixed: 'left' }
  168. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  169. ,{field:'Name', title:'名称', sort: true}
  170. ,{field:'Areas', title:'所在地区', sort: true}
  171. ,{field:'Principal', title:'负责人', sort: true}
  172. ,{field:'Phone', title:'联系电话', sort: true}
  173. ,{field:'StarNum1', title:'快递包装评分', sort: true}
  174. ,{field:'FollowCount', title:'关注数', sort: true}
  175. ,{field:'IsAuthName', title:'是否认证', sort: true}
  176. ,{field:'CommentCount', title:'评论数', sort: true}
  177. ,{field:'Address', title:'详细地址', sort: true}
  178. ,{field:'StarNum2', title:'送货速度评分', sort: true}
  179. ,{field:'StarNum3', title:'服务态度评分', sort: true}
  180. ]];
  181. //收藏
  182. var UserCollection_cols = [[
  183. { type: 'checkbox', fixed: 'left' }
  184. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  185. ,{field:'DataId', title:'数据Id', sort: true}
  186. ,{field:'Kind', title:'类别', sort: true}
  187. ,{field:'UserId', title:'创客Id', sort: true}
  188. ]];
  189. //退款申请
  190. var OrderRefund_cols = [[
  191. { type: 'checkbox', fixed: 'left' }
  192. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  193. ,{field:'Reason', title:'退款原因', sort: true}
  194. ,{field:'Amount', title:'退款金额', sort: true}
  195. ,{field:'Mobile', title:'申请人手机号', sort: true}
  196. ,{field:'GoodStatus', title:'货物状态', sort: true}
  197. ]];
  198. //商品评价
  199. var ProductComment_cols = [[
  200. { type: 'checkbox', fixed: 'left' }
  201. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  202. ,{field:'UserId', title:'创客Id', sort: true}
  203. ,{field:'ProductId', title:'商品Id', sort: true}
  204. ,{field:'OrderId', title:'订单Id', sort: true}
  205. ,{field:'Contents', title:'评论内容', sort: true}
  206. ,{field:'StarNum', title:'商品评分', sort: true}
  207. ,{field:'AgreeCount', title:'点赞数', sort: true}
  208. ,{field:'BackCount', title:'回复数', sort: true}
  209. ]];
  210. //商品规格项目
  211. var ProductNormItem_cols = [[
  212. { type: 'checkbox', fixed: 'left' }
  213. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  214. ,{field:'ColName', title:'名称', sort: true}
  215. ]];
  216. //商品规格
  217. var ProductNorm_cols = [[
  218. { type: 'checkbox', fixed: 'left' }
  219. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  220. ,{field:'ColName', title:'名称', sort: true}
  221. ,{field:'Price', title:'价格', sort: true}
  222. ,{field:'Integral', title:'抵扣积分', sort: true}
  223. ,{field:'UserPrice', title:'创客价', sort: true}
  224. ,{field:'UserIntegral', title:'创客抵扣积分', sort: true}
  225. ,{field:'Stock', title:'库存', sort: true}
  226. ,{field:'BuyCount', title:'已购买数', sort: true}
  227. ,{field:'Code', title:'编码', sort: true}
  228. ,{field:'LimitCount', title:'限购数量', sort: true}
  229. ]];
  230. //商品规格模板
  231. var ProductNormTemp_cols = [[
  232. { type: 'checkbox', fixed: 'left' }
  233. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  234. ,{field:'Name', title:'名称', sort: true}
  235. ]];
  236. //商品运费模板
  237. var ProductFareTemp_cols = [[
  238. { type: 'checkbox', fixed: 'left' }
  239. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  240. ,{field:'Name', title:'名称', sort: true}
  241. ,{field:'SendAreas', title:'发货地区', sort: true}
  242. ,{field:'SendAddress', title:'发货地址', sort: true}
  243. ,{field:'IsFreeName', title:'是否包邮', sort: true}
  244. ,{field:'MeterMode', title:'计价方式', sort: true}
  245. ,{field:'TransportMode', title:'运送方式', sort: true}
  246. ]];
  247. //运费按区域
  248. var ProductFareAreas_cols = [[
  249. { type: 'checkbox', fixed: 'left' }
  250. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  251. ]];
  252. //商品关键词库
  253. var ProductKeys_cols = [[
  254. { type: 'checkbox', fixed: 'left' }
  255. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  256. ,{field:'Name', title:'关键词', sort: true}
  257. ]];
  258. //商家分类
  259. var MerchantClass_cols = [[
  260. { type: 'checkbox', fixed: 'left' }
  261. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  262. ,{field:'ColName', title:'名称', sort: true}
  263. ]];
  264. //创客线下签到记录
  265. var UserOfflineSignInRecords_cols = [[
  266. { type: 'checkbox', fixed: 'left' }
  267. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  268. ,{field:'CreateDate', title:'创建时间', sort: true}
  269. ]];
  270. //商家商品分类
  271. var MerchantCol_cols = [[
  272. { type: 'checkbox', fixed: 'left' }
  273. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  274. ,{field:'ColName', title:'名称', sort: true}
  275. ,{field:'RecommendName', title:'推荐', sort: true}
  276. ,{field:'ColEnName', title:'英文名', sort: true}
  277. ]];
  278. //订单号关联表
  279. var OrderForNo_cols = [[
  280. { type: 'checkbox', fixed: 'left' }
  281. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  282. ]];
  283. //手机验证码
  284. var MobileCodeCheck_cols = [[
  285. { type: 'checkbox', fixed: 'left' }
  286. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  287. ]];
  288. //店铺评价
  289. var MerchantComment_cols = [[
  290. { type: 'checkbox', fixed: 'left' }
  291. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  292. ,{field:'UserId', title:'创客Id', sort: true}
  293. ,{field:'OrderId', title:'订单Id', sort: true}
  294. ,{field:'StarNum1', title:'快递包装评分', sort: true}
  295. ,{field:'StarNum2', title:'送货速度评分', sort: true}
  296. ,{field:'StarNum3', title:'服务态度评分', sort: true}
  297. ]];
  298. //商品评价点赞记录
  299. var ProductCommentAgree_cols = [[
  300. { type: 'checkbox', fixed: 'left' }
  301. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  302. ]];
  303. //快递公司
  304. var ErpCompanys_cols = [[
  305. { type: 'checkbox', fixed: 'left' }
  306. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  307. ,{field:'Name', title:'名称', sort: true}
  308. ,{field:'Code', title:'编码', sort: true}
  309. ,{field:'Phone', title:'客服电话', sort: true}
  310. ,{field:'StatusName', title:'状态', sort: true}
  311. ]];
  312. //退款原因
  313. var OrderRefundReason_cols = [[
  314. { type: 'checkbox', fixed: 'left' }
  315. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  316. ,{field:'Name', title:'名称', sort: true}
  317. ]];
  318. //自定义全局标签
  319. var CustomTagSet_cols = [[
  320. { type: 'checkbox', fixed: 'left' }
  321. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  322. ,{field:'Tags', title:'标签', sort: true}
  323. ,{field:'Title', title:'标题', sort: true}
  324. ]];
  325. //优惠券
  326. var Coupons_cols = [[
  327. { type: 'checkbox', fixed: 'left' }
  328. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  329. ,{field:'Name', title:'名称', sort: true}
  330. ,{field:'IsNewUserName', title:'新创客使用', sort: true}
  331. ,{field:'IsPublicName', title:'是否公开领取', sort: true}
  332. ,{field:'Stock', title:'库存', sort: true}
  333. ,{field:'Kind', title:'优惠券类型', sort: true}
  334. ,{field:'MerchantId', title:'商家', sort: true}
  335. ,{field:'ProductColId', title:'商品分类', sort: true}
  336. ,{field:'ProductId', title:'商品', sort: true}
  337. ,{field:'UserMaxLevel', title:'创客最高等级', sort: true}
  338. ,{field:'UserMinLevel', title:'创客最低等级', sort: true}
  339. ,{field:'UseStartDate', title:'开始使用时间', sort: true}
  340. ,{field:'UseEndDate', title:'结束使用时间', sort: true}
  341. ,{field:'IsRepeatName', title:'是否重复', sort: true}
  342. ,{field:'RepeatType', title:'重复类型', sort: true}
  343. ,{field:'IsReUseName', title:'是否一次性使用', sort: true}
  344. ,{field:'PublicStartDate', title:'公开领取开始时间', sort: true}
  345. ,{field:'PublicEndDate', title:'公开领取结束时间', sort: true}
  346. ,{field:'PublicMax', title:'公开每人领取数量', sort: true}
  347. ,{field:'PublicMaxByDay', title:'公开每人每天领取数量', sort: true}
  348. ,{field:'IsSuperposeName', title:'是否叠加使用', sort: true}
  349. ,{field:'AndPromotionName', title:'是否与促销活动同时使用', sort: true}
  350. ,{field:'FullReduceMoney', title:'满多少可用', sort: true}
  351. ,{field:'FullReduceData', title:'满减数据', sort: true}
  352. ,{field:'ExpireStartDate', title:'过期开始时间', sort: true}
  353. ,{field:'ExpireEndDate', title:'过期结束时间', sort: true}
  354. ,{field:'CreateDate', title:'创建时间', sort: true}
  355. ,{field:'StatusName', title:'状态', sort: true}
  356. ]];
  357. //优惠券领取记录
  358. var CouponsForUser_cols = [[
  359. { type: 'checkbox', fixed: 'left' }
  360. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  361. ,{field:'IsUseName', title:'是否使用', sort: true}
  362. ,{field:'IsLockName', title:'是否锁定', sort: true}
  363. ,{field:'UseDate', title:'使用时间', sort: true}
  364. ,{field:'CreateDate', title:'创建时间', sort: true}
  365. ]];
  366. //优惠券发放记录
  367. var CouponAssignRecords_cols = [[
  368. { type: 'checkbox', fixed: 'left' }
  369. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  370. ,{field:'UserMinLevel', title:'创客最低等级', sort: true}
  371. ,{field:'UserMaxLevel', title:'创客最高等级', sort: true}
  372. ,{field:'TotalOrderMoneyMin', title:'最小消费总额', sort: true}
  373. ,{field:'TotalOrderMoneyMax', title:'最大消费总额', sort: true}
  374. ,{field:'TotalUseIntegralMin', title:'最小消耗积分总额', sort: true}
  375. ,{field:'TotalUseIntegralMax', title:'最大消耗积分总额', sort: true}
  376. ,{field:'CurMoneyMin', title:'当前最低余额', sort: true}
  377. ,{field:'CurMoneyMax', title:'当前最高余额', sort: true}
  378. ,{field:'UserGroupId', title:'创客分组', sort: true}
  379. ,{field:'Areas', title:'创客所在地区', sort: true}
  380. ,{field:'Mobile', title:'手机号', sort: true}
  381. ,{field:'CreateDate', title:'创建时间', sort: true}
  382. ]];
  383. //商家管理员
  384. var MerchantAdmin_cols = [[
  385. { type: 'checkbox', fixed: 'left' }
  386. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  387. ,{field:'AdminName', title:'用户名', sort: true}
  388. ,{field:'RealName', title:'名称', sort: true}
  389. ,{field:'LastLoginDate', title:'最后登录时间', sort: true}
  390. ,{field:'Mobile', title:'手机号', sort: true}
  391. ,{field:'Email', title:'邮箱', sort: true}
  392. ,{field:'QQ', title:'QQ号', sort: true}
  393. ]];
  394. //分润对象
  395. var ProfitObjects_cols = [[
  396. { type: 'checkbox', fixed: 'left' }
  397. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  398. ,{field:'Name', title:'名称', sort: true}
  399. ,{field:'MaxFloor', title:'最大层级', sort: true}
  400. ,{field:'MaxLevel', title:'最大等级', sort: true}
  401. ,{field:'MaxLevelContinueName', title:'到顶级是否继续', sort: true}
  402. ,{field:'MinProfitVal', title:'最小分润值', sort: true}
  403. ,{field:'StartDate', title:'开始时间', sort: true}
  404. ,{field:'EndDate', title:'结束时间', sort: true}
  405. ]];
  406. //激活奖励设置
  407. var ProfitObjectActivations_cols = [[
  408. { type: 'checkbox', fixed: 'left' }
  409. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  410. ,{field:'LimitDateKind', title:'限制时间类型', sort: true}
  411. ,{field:'LimitDateVal', title:'限制时间值', sort: true}
  412. ,{field:'LimitCustomerDate', title:'自定时间限制', sort: true}
  413. ,{field:'ExpiredNumber', title:'过期收益值', sort: true}
  414. ]];
  415. //继续分润层级
  416. var ProfitObjectContinueFloors_cols = [[
  417. { type: 'checkbox', fixed: 'left' }
  418. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  419. ,{field:'FloorNumber', title:'层级', sort: true}
  420. ,{field:'Percents', title:'分润比例', sort: true}
  421. ,{field:'AddProfitVal', title:'附加分润值', sort: true}
  422. ]];
  423. //分润对象层级
  424. var ProfitObjectFloors_cols = [[
  425. { type: 'checkbox', fixed: 'left' }
  426. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  427. ,{field:'FloorNumber', title:'层级', sort: true}
  428. ,{field:'Percents', title:'分润比例', sort: true}
  429. ,{field:'AddProfitVal', title:'附加分润值', sort: true}
  430. ,{field:'FloorDiffName', title:'级差', sort: true}
  431. ]];
  432. //分润对象等级分类
  433. var ProfitObjectLevelKinds_cols = [[
  434. { type: 'checkbox', fixed: 'left' }
  435. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  436. ,{field:'Name', title:'名称', sort: true}
  437. ]];
  438. //分润对象等级
  439. var ProfitObjectLevels_cols = [[
  440. { type: 'checkbox', fixed: 'left' }
  441. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  442. ,{field:'LevelNumber', title:'级别', sort: true}
  443. ,{field:'Name', title:'名称', sort: true}
  444. ,{field:'Percents', title:'分润比例', sort: true}
  445. ,{field:'AddProfitVal', title:'附加分润值', sort: true}
  446. ,{field:'LevelDiffName', title:'级差', sort: true}
  447. ,{field:'DebitPercents', title:'借记卡分润比例', sort: true}
  448. ,{field:'DebitAddProfitVal', title:'借记卡附加分润值', sort: true}
  449. ]];
  450. //分润对象活动奖
  451. var ProfitObjectsActives_cols = [[
  452. { type: 'checkbox', fixed: 'left' }
  453. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  454. ,{field:'Name', title:'名称', sort: true}
  455. ,{field:'LimitDateKind', title:'限制时间类型', sort: true}
  456. ,{field:'LimitDateVal', title:'限制时间值', sort: true}
  457. ,{field:'LimitCustomerDate', title:'自定时间限制', sort: true}
  458. ,{field:'FinishNumber', title:'满足条件的数值', sort: true}
  459. ,{field:'ProfitNumber', title:'获得收益值', sort: true}
  460. ,{field:'StartDate', title:'活动开始时间', sort: true}
  461. ,{field:'EndDate', title:'活动结束时间', sort: true}
  462. ,{field:'MachineCount', title:'赠机台数', sort: true}
  463. ]];
  464. //激活奖励队列
  465. var ProfitObjectsActiveCheck_cols = [[
  466. { type: 'checkbox', fixed: 'left' }
  467. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  468. ]];
  469. //机具库
  470. var PosMachines_cols = [[
  471. { type: 'checkbox', fixed: 'left' }
  472. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  473. ,{field:'BindingState', title:'绑定状态', sort: true}
  474. ,{field:'ActivationState', title:'激活状态', sort: true}
  475. ,{field:'UserId', title:'所属创客', sort: true}
  476. ,{field:'PosSn', title:'SN编号', sort: true}
  477. ,{field:'BrandId', title:'产品类型', sort: true}
  478. ,{field:'ActivityList', title:'参加活动', sort: true}
  479. ,{field:'BindMerchantId', title:'绑定商户', sort: true}
  480. ,{field:'PosSnType', title:'机具类型', sort: true}
  481. ,{field:'DeviceType', title:'设备类型', sort: true}
  482. ]];
  483. //激活奖励记录
  484. var ActiveReward_cols = [[
  485. { type: 'checkbox', fixed: 'left' }
  486. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  487. ,{field:'UserId', title:'创客', sort: true}
  488. ,{field:'MerchantId', title:'商户', sort: true}
  489. ,{field:'RewardAmount', title:'奖励金额', sort: true}
  490. ,{field:'BrandId', title:'品牌', sort: true}
  491. ,{field:'MerUserNav', title:'商户直属创客父级', sort: true}
  492. ,{field:'KqMerNo', title:'渠道商户编号', sort: true}
  493. ,{field:'KqSnNo', title:'渠道SN号', sort: true}
  494. ,{field:'SnType', title:'机具类型', sort: true}
  495. ,{field:'SnApplyUserId', title:'机具申请创客', sort: true}
  496. ,{field:'ActType', title:'激活类型', sort: true}
  497. ,{field:'SnStoreId', title:'SN仓库', sort: true}
  498. ,{field:'ActDate', title:'激活时间', sort: true}
  499. ,{field:'CreateDate', title:'创建时间', sort: true}
  500. ]];
  501. //创客账户
  502. var UserAccount_cols = [[
  503. { type: 'checkbox', fixed: 'left' }
  504. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  505. ,{field:'UserId', title:'创客', sort: true}
  506. ,{field:'TotalAmount', title:'总金额', sort: true}
  507. ,{field:'FreezeAmount', title:'冻结金额', sort: true}
  508. ,{field:'BalanceAmount', title:'余额', sort: true}
  509. ,{field:'AccountStatus', title:'账户状态', sort: true}
  510. ,{field:'WithdrawAmount', title:'已提现金额', sort: true}
  511. ,{field:'CreateDate', title:'创建时间', sort: true}
  512. ]];
  513. //创客账户变动记录
  514. var UserAccountRecord_cols = [[
  515. { type: 'checkbox', fixed: 'left' }
  516. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  517. ,{field:'UserId', title:'创客', sort: true}
  518. ,{field:'ChangeType', title:'变动类型', sort: true}
  519. ,{field:'ProductType', title:'产品类型', sort: true}
  520. ,{field:'ChangeAmount', title:'变更金额', sort: true}
  521. ,{field:'BeforeTotalAmount', title:'变更前总金额', sort: true}
  522. ,{field:'AfterTotalAmount', title:'变更后总金额', sort: true}
  523. ,{field:'BeforeFreezeAmount', title:'变更前冻结金额', sort: true}
  524. ,{field:'AfterFreezeAmount', title:'变更后冻结金额', sort: true}
  525. ,{field:'BeforeBalanceAmount', title:'变更前余额', sort: true}
  526. ,{field:'AfterBalanceAmount', title:'变更后余额', sort: true}
  527. ,{field:'Remark', title:'账户变动明细备注信息', sort: true}
  528. ,{field:'TransRecordNo', title:'交易流水编号', sort: true}
  529. ,{field:'CreateDate', title:'创建时间', sort: true}
  530. ]];
  531. //商户
  532. var MerchantInfo_cols = [[
  533. { type: 'checkbox', fixed: 'left' }
  534. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  535. ,{field:'MerchantNo', title:'商户编号', sort: true}
  536. ,{field:'MerchantName', title:'商户姓名', sort: true}
  537. ,{field:'MerchantMobile', title:'商户手机号', sort: true}
  538. ,{field:'KqMerNo', title:'渠道商户编码', sort: true}
  539. ,{field:'KqSnNo', title:'渠道SN号', sort: true}
  540. ,{field:'MerStatus', title:'商户状态', sort: true}
  541. ,{field:'ActiveStatus', title:'商户激活状态', sort: true}
  542. ,{field:'DirectUserId', title:'直属创客编号', sort: true}
  543. ,{field:'UserId', title:'创客', sort: true}
  544. ,{field:'MerUserId', title:'商户创客', sort: true}
  545. ,{field:'SnType', title:'机具类型', sort: true}
  546. ,{field:'SnApplyUserId', title:'机具SN申请创客', sort: true}
  547. ,{field:'KqRegTime', title:'渠道注册时间', sort: true}
  548. ,{field:'ActType', title:'激活类型', sort: true}
  549. ,{field:'SnStoreId', title:'SN仓库', sort: true}
  550. ,{field:'BrandId', title:'品牌', sort: true}
  551. ,{field:'MerUserType', title:'商户创客类型', sort: true}
  552. ,{field:'CreateDate', title:'创建时间', sort: true}
  553. ]];
  554. //商户实名信息
  555. var MerchantAuth_cols = [[
  556. { type: 'checkbox', fixed: 'left' }
  557. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  558. ,{field:'ChannelCode', title:'渠道编码', sort: true}
  559. ,{field:'ChannelName', title:'渠道名称 ', sort: true}
  560. ,{field:'MerNo', title:'商户编号', sort: true}
  561. ,{field:'RealName', title:'真实姓名', sort: true}
  562. ,{field:'IdCardNo', title:'身份证号', sort: true}
  563. ,{field:'BankCardAccount', title:'银行卡账号', sort: true}
  564. ,{field:'BankName', title:'银行名称', sort: true}
  565. ,{field:'BankMobile', title:'银行预留手机号码', sort: true}
  566. ,{field:'AuthType', title:'实名类型', sort: true}
  567. ,{field:'CreateDate', title:'创建时间', sort: true}
  568. ]];
  569. //仓库
  570. var StoreHouse_cols = [[
  571. { type: 'checkbox', fixed: 'left' }
  572. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  573. ,{field:'StoreNo', title:'仓库编号', sort: true}
  574. ,{field:'StoreName', title:'仓库名称', sort: true}
  575. ,{field:'UserId', title:'仓库归属人', sort: true}
  576. ,{field:'BrandId', title:'产品类型', sort: true}
  577. ,{field:'Address', title:'仓库地址', sort: true}
  578. ,{field:'ManageUserId', title:'仓库管理员', sort: true}
  579. ,{field:'ManagerEmail', title:'管理者邮箱', sort: true}
  580. ,{field:'StoreType', title:'仓库类型', sort: true}
  581. ,{field:'TotalNum', title:'总库存数', sort: true}
  582. ,{field:'LaveNum', title:'剩余库存数', sort: true}
  583. ,{field:'OutNum', title:'出库数', sort: true}
  584. ,{field:'LimitTopUserId', title:'限制创客特殊仓库', sort: true}
  585. ,{field:'StoreStatus', title:'仓库状态', sort: true}
  586. ,{field:'StoreKind', title:'仓库归属类型', sort: true}
  587. ,{field:'ManageMobile', title:'管理者手机号', sort: true}
  588. ,{field:'CreateDate', title:'创建时间', sort: true}
  589. ]];
  590. //银行信息
  591. var BankInfo_cols = [[
  592. { type: 'checkbox', fixed: 'left' }
  593. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  594. ,{field:'BankName', title:'银行全称', sort: true}
  595. ,{field:'BankCode', title:'银行编码', sort: true}
  596. ,{field:'UnitedBankNo', title:'银行总行联行号', sort: true}
  597. ,{field:'UnitedBankName', title:'总行名称', sort: true}
  598. ,{field:'BankNameAbbr', title:'银行简称', sort: true}
  599. ]];
  600. //活动信息
  601. var ActivityInfo_cols = [[
  602. { type: 'checkbox', fixed: 'left' }
  603. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  604. ,{field:'ActCode', title:'活动编号', sort: true}
  605. ,{field:'ActType', title:'活动类型', sort: true}
  606. ,{field:'ActName', title:'活动名称', sort: true}
  607. ,{field:'BrandId', title:'产品类型', sort: true}
  608. ,{field:'LimitTopBuddy', title:'顶级创客设置', sort: true}
  609. ,{field:'IsTop', title:'是否置顶', sort: true}
  610. ,{field:'EffectStartDate', title:'活动开始时间', sort: true}
  611. ,{field:'EffectEndDate', title:'活动结束时间', sort: true}
  612. ,{field:'Remark', title:'备注', sort: true}
  613. ,{field:'CreateDate', title:'创建时间', sort: true}
  614. ]];
  615. //活动报名记录
  616. var ActivityEnrolRecord_cols = [[
  617. { type: 'checkbox', fixed: 'left' }
  618. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  619. ,{field:'ActId', title:'活动', sort: true}
  620. ,{field:'UserId', title:'创客', sort: true}
  621. ,{field:'EnrolMonth', title:'报名有效月份', sort: true}
  622. ,{field:'EffectStartTime', title:'报名有效开始时间', sort: true}
  623. ,{field:'EffectEndTime', title:'报名有效结束时间', sort: true}
  624. ,{field:'CreateDate', title:'创建时间', sort: true}
  625. ]];
  626. //仓库库存变动记录
  627. var StoreStockChange_cols = [[
  628. { type: 'checkbox', fixed: 'left' }
  629. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  630. ,{field:'StoreId', title:'仓库', sort: true}
  631. ,{field:'BrandId', title:'产品类型', sort: true}
  632. ,{field:'TransType', title:'交易类型', sort: true}
  633. ,{field:'SnNo', title:'SN编号', sort: true}
  634. ,{field:'StockOpDirect', title:'库存操作方向', sort: true}
  635. ,{field:'SnStatus', title:'SN状态', sort: true}
  636. ,{field:'BindStatus', title:'绑定状态', sort: true}
  637. ,{field:'BindMerchant', title:'绑定商户', sort: true}
  638. ,{field:'ActiveStatus', title:'激活状态', sort: true}
  639. ,{field:'ExpressNo', title:'快递单号', sort: true}
  640. ,{field:'BrandType', title:'品牌类型', sort: true}
  641. ,{field:'CreateDate', title:'创建时间', sort: true}
  642. ]];
  643. //兑换机具记录
  644. var StoreSwapSn_cols = [[
  645. { type: 'checkbox', fixed: 'left' }
  646. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  647. ,{field:'UserId', title:'创客', sort: true}
  648. ,{field:'BrandId', title:'品牌', sort: true}
  649. ,{field:'SnNo', title:'SN号', sort: true}
  650. ,{field:'SnType', title:'SN类型', sort: true}
  651. ,{field:'StandardDate', title:'达标日期', sort: true}
  652. ,{field:'PosType', title:'POS类型', sort: true}
  653. ,{field:'SwapStatus', title:'兑换状态', sort: true}
  654. ,{field:'BizStatus', title:'业务状态', sort: true}
  655. ,{field:'RiskStatus', title:'风控状态', sort: true}
  656. ,{field:'SwapExtProductTypes', title:'可兑换产品类型', sort: true}
  657. ,{field:'SwapSnNo', title:'兑换SN号', sort: true}
  658. ,{field:'SwapApplyOrderNo', title:'兑换申请单号', sort: true}
  659. ,{field:'SwapApplyDate', title:'兑换时间', sort: true}
  660. ,{field:'Remark', title:'备注', sort: true}
  661. ,{field:'CreateDate', title:'创建时间', sort: true}
  662. ]];
  663. //机具申请订单
  664. var MachineApply_cols = [[
  665. { type: 'checkbox', fixed: 'left' }
  666. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  667. ,{field:'ApplyNo', title:'申请单号', sort: true}
  668. ,{field:'UserId', title:'创客', sort: true}
  669. ,{field:'BrandId', title:'品牌', sort: true}
  670. ,{field:'Areas', title:'收货所在地区', sort: true}
  671. ,{field:'Address', title:'收货详细地址', sort: true}
  672. ,{field:'RealName', title:'收件人姓名', sort: true}
  673. ,{field:'Mobile', title:'收件人手机号', sort: true}
  674. ,{field:'ApplyDeviceName', title:'申请机具名称', sort: true}
  675. ,{field:'ApplyDeviceNum', title:'申请机具数量', sort: true}
  676. ,{field:'ApplyTime', title:'申请时间', sort: true}
  677. ,{field:'SendStatus', title:'发货状态', sort: true}
  678. ,{field:'ExpressNo', title:'快递单号', sort: true}
  679. ,{field:'ExpressName', title:'快递名称', sort: true}
  680. ,{field:'DeliveryType', title:'提货类型', sort: true}
  681. ,{field:'StoreId', title:'发货仓库', sort: true}
  682. ,{field:'StoreName', title:'发货仓库名称', sort: true}
  683. ,{field:'StoreManager', title:'仓库联系人', sort: true}
  684. ,{field:'Remark', title:'订单备注', sort: true}
  685. ,{field:'StoreUserId', title:'仓库归属创客', sort: true}
  686. ,{field:'SendDate', title:'发货时间', sort: true}
  687. ,{field:'SendSn', title:'发货SN', sort: true}
  688. ,{field:'CreateDate', title:'创建时间', sort: true}
  689. ]];
  690. //机具申请明细
  691. var MachineApplyDetail_cols = [[
  692. { type: 'checkbox', fixed: 'left' }
  693. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  694. ,{field:'ApplyNo', title:'订单号', sort: true}
  695. ,{field:'ProductType', title:'实际发货产品类型', sort: true}
  696. ,{field:'ProductName', title:'实际发货产品名称', sort: true}
  697. ,{field:'UserId', title:'创客', sort: true}
  698. ,{field:'DeviceSnNo', title:'设备SN编号', sort: true}
  699. ,{field:'DeviceStatus', title:'设备状态', sort: true}
  700. ,{field:'DeviceVendor', title:'设备厂商', sort: true}
  701. ,{field:'DeviceModel', title:'设备型号', sort: true}
  702. ,{field:'DeviceDesc', title:'设备描述', sort: true}
  703. ,{field:'UpSrcProName', title:'上级源机具产品名称', sort: true}
  704. ,{field:'SourceSnNo', title:'兑换来源SN编码', sort: true}
  705. ,{field:'SourceSnType', title:'兑换来源SN机具类型', sort: true}
  706. ,{field:'Remark', title:'备注', sort: true}
  707. ,{field:'CreateDate', title:'创建时间', sort: true}
  708. ]];
  709. //机具转换订单
  710. var MachineChange_cols = [[
  711. { type: 'checkbox', fixed: 'left' }
  712. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  713. ,{field:'CreateDate', title:'创建时间', sort: true}
  714. ]];
  715. //机具转换明细
  716. var MachineChangeDetail_cols = [[
  717. { type: 'checkbox', fixed: 'left' }
  718. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  719. ,{field:'ChangeNo', title:'订单号', sort: true}
  720. ,{field:'BackProductType', title:'退回产品类型', sort: true}
  721. ,{field:'BackProductName', title:'退回产品名称', sort: true}
  722. ,{field:'UserId', title:'创客', sort: true}
  723. ,{field:'BackSnNo', title:'设备SN编号', sort: true}
  724. ,{field:'BackDeviceStatus', title:'设备状态', sort: true}
  725. ,{field:'OutProductType ', title:'出库产品类型', sort: true}
  726. ,{field:'OutProductName', title:'出库产品名称', sort: true}
  727. ,{field:'OutSnNo', title:'出库设备SN编号', sort: true}
  728. ,{field:'OutSnType', title:'出库SN机具类型', sort: true}
  729. ,{field:'Remark', title:'备注', sort: true}
  730. ,{field:'BackSnType', title:'退回SN机具类型', sort: true}
  731. ,{field:'CreateDate', title:'创建时间', sort: true}
  732. ]];
  733. //分润奖励记录
  734. var ProfitRewardRecord_cols = [[
  735. { type: 'checkbox', fixed: 'left' }
  736. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  737. ,{field:'UserId', title:'创客', sort: true}
  738. ,{field:'ProfitType', title:'创客分润类型', sort: true}
  739. ,{field:'OtherTradeAmt', title:'其他产品交易总金额', sort: true}
  740. ,{field:'OtherCreditTradeAmt', title:'其他产品贷记卡交易总金额', sort: true}
  741. ,{field:'OtherDebitNotCapTradeAmt', title:'其他产品借记卡非封顶交易总金额', sort: true}
  742. ,{field:'TradeAmt', title:'商户交易总额', sort: true}
  743. ,{field:'CreditTradeAmt', title:'贷记卡交易总金额', sort: true}
  744. ,{field:'QrCreditTradeAmt', title:'(云闪付)贷记卡交易总金额', sort: true}
  745. ,{field:'NonQrCreditTradeAmt', title:'(非云闪付)贷记卡交易总金额', sort: true}
  746. ,{field:'DebitNonCapTradeAmt', title:'商户非封顶借记卡交易总额', sort: true}
  747. ,{field:'QrDebitNotCapTradeAmt', title:'(云闪付)商户非封顶借记卡交易总额', sort: true}
  748. ,{field:'NonQrDebitNotCapTradeAmt', title:'(非云闪付)商户非封顶借记卡交易总额', sort: true}
  749. ,{field:'DebitCapTradeAmt', title:'商户借记卡封顶交易总额', sort: true}
  750. ,{field:'DebitCapTradeNum', title:'商户借记卡封顶交易总笔数', sort: true}
  751. ,{field:'TradeProfit', title:'交易分润', sort: true}
  752. ,{field:'CreditTradeProfit', title:'贷记卡分润总金额', sort: true}
  753. ,{field:'QrCreditTradeProfit', title:'(云闪付)贷记卡交易分润', sort: true}
  754. ,{field:'NonQrCreditTradeProfit', title:'(非云闪付)贷记卡交易分润', sort: true}
  755. ,{field:'DebitNonTradeCapProfit', title:'借记卡非封顶交易分润总金额', sort: true}
  756. ,{field:'QrDebitNonTradeCapProfit', title:'(云闪付)借记卡非封顶交易分润总金额', sort: true}
  757. ,{field:'NonQrDebitNonTradeCapProfit', title:'(非云闪付)借记卡非封顶交易分润总金额', sort: true}
  758. ,{field:'DebitTradeCapProfit', title:'借记卡封顶交易分润总金额', sort: true}
  759. ,{field:'CheckStatus', title:'验证和同步账户状态', sort: true}
  760. ,{field:'TradeMonth', title:'交易月', sort: true}
  761. ,{field:'RecordNo', title:'记录单号', sort: true}
  762. ,{field:'CreateDate', title:'创建时间', sort: true}
  763. ]];
  764. //交易记录
  765. var TradeRecord_cols = [[
  766. { type: 'checkbox', fixed: 'left' }
  767. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  768. ,{field:'UserId', title:'创客', sort: true}
  769. ,{field:'MerchantId', title:'商户', sort: true}
  770. ,{field:'MerNo', title:'渠道商户编号', sort: true}
  771. ,{field:'MerHelpFlagName', title:'是否属于扶持周期内商户', sort: true}
  772. ,{field:'MerBuddyType', title:'商户创客类型', sort: true}
  773. ,{field:'SnNo', title:'渠道SN号', sort: true}
  774. ,{field:'TradeDate', title:'交易日期', sort: true}
  775. ,{field:'TradeSerialNo', title:'交易流水号', sort: true}
  776. ,{field:'TradeAmount', title:'交易金额', sort: true}
  777. ,{field:'BankCardType', title:'银行卡类型', sort: true}
  778. ,{field:'QrPayFlag', title:'云闪付标识', sort: true}
  779. ,{field:'CapFlag', title:'借记卡封顶交易标志', sort: true}
  780. ,{field:'BrandId', title:'品牌', sort: true}
  781. ,{field:'CreateDate', title:'创建时间', sort: true}
  782. ]];
  783. //开机奖励明细
  784. var OpenRewardDetail_cols = [[
  785. { type: 'checkbox', fixed: 'left' }
  786. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  787. ,{field:'TradeDate', title:'达标日期', sort: true}
  788. ,{field:'UserId', title:'创客', sort: true}
  789. ,{field:'BrandId', title:'品牌', sort: true}
  790. ,{field:'MerchantId', title:'商户', sort: true}
  791. ,{field:'DirectUserId', title:'商户直属人', sort: true}
  792. ,{field:'SnNo', title:'SN号', sort: true}
  793. ,{field:'MerNo', title:'渠道商户号', sort: true}
  794. ,{field:'SnType', title:'机具类型', sort: true}
  795. ,{field:'SnApplyUserId', title:'机具申请人', sort: true}
  796. ,{field:'StandardDate', title:'商户的激活日期', sort: true}
  797. ,{field:'SnStoreId', title:'SN仓库', sort: true}
  798. ,{field:'MerBuddyType', title:'商户创客类型', sort: true}
  799. ,{field:'RewardType', title:'奖励类型', sort: true}
  800. ,{field:'CreditTradeAmt', title:'贷记卡交易总金额', sort: true}
  801. ,{field:'DebitTradeAmt', title:'借记卡交易总金额', sort: true}
  802. ,{field:'CreditRewardAmount', title:'贷记卡交易奖励金额', sort: true}
  803. ,{field:'DebitRewardAmount', title:'借记记卡交易奖励金额', sort: true}
  804. ,{field:'OpenRewardNo', title:'开机奖励单号', sort: true}
  805. ,{field:'RewardDesc', title:'奖励描述', sort: true}
  806. ,{field:'CheckStatus', title:'同步状态', sort: true}
  807. ,{field:'CreateDate', title:'创建时间', sort: true}
  808. ]];
  809. //创客反馈
  810. var UserBack_cols = [[
  811. { type: 'checkbox', fixed: 'left' }
  812. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  813. ,{field:'UserId', title:'创客', sort: true}
  814. ,{field:'Content', title:'回复内容', sort: true}
  815. ,{field:'IsPhoneCallBackName', title:'是否需要电话回复', sort: true}
  816. ,{field:'BackKind', title:'反馈类型', sort: true}
  817. ,{field:'CreateDate', title:'创建时间', sort: true}
  818. ]];
  819. //创客反馈类型
  820. var UserBackKind_cols = [[
  821. { type: 'checkbox', fixed: 'left' }
  822. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  823. ,{field:'Name', title:'名称', sort: true}
  824. ]];
  825. //服务中心
  826. var ServiceCenter_cols = [[
  827. { type: 'checkbox', fixed: 'left' }
  828. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  829. ,{field:'Title', title:'标题', sort: true}
  830. ,{field:'CategoryId', title:'问答类型', sort: true}
  831. ,{field:'CreateDate', title:'创建时间', sort: true}
  832. ]];
  833. //提现记录
  834. var UserCashRecord_cols = [[
  835. { type: 'checkbox', fixed: 'left' }
  836. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  837. ,{field:'CashOrderNo', title:'申请提现单号', sort: true}
  838. ,{field:'UserId', title:'创客', sort: true}
  839. ,{field:'IdCardNo', title:'身份证号', sort: true}
  840. ,{field:'SettleBankCardNo', title:'提现卡号', sort: true}
  841. ,{field:'SettleBankName', title:'银行名称', sort: true}
  842. ,{field:'TradeType', title:'交易类型', sort: true}
  843. ,{field:'TradeAmount', title:'交易金额', sort: true}
  844. ,{field:'ReturnCode', title:'返回编码', sort: true}
  845. ,{field:'ReturnMsg', title:'返回信息', sort: true}
  846. ,{field:'CreateDate', title:'创建时间', sort: true}
  847. ]];
  848. //创客绑卡记录
  849. var UserAuthRecord_cols = [[
  850. { type: 'checkbox', fixed: 'left' }
  851. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  852. ,{field:'ChannelCode', title:'渠道编码', sort: true}
  853. ,{field:'ChannelName', title:'渠道名称', sort: true}
  854. ,{field:'UserId', title:'创客', sort: true}
  855. ,{field:'RealName', title:'真实姓名', sort: true}
  856. ,{field:'IdcardNo', title:'身份证号码', sort: true}
  857. ,{field:'BankCardAccount', title:'银行卡账号', sort: true}
  858. ,{field:'BankName', title:'银行名称', sort: true}
  859. ,{field:'BankMobile', title:'银行预留手机号码', sort: true}
  860. ,{field:'AuthType', title:'实名类型', sort: true}
  861. ,{field:'CreateDate', title:'创建时间', sort: true}
  862. ]];
  863. //页面模板更新信息
  864. var PageUpdateInfo_cols = [[
  865. { type: 'checkbox', fixed: 'left' }
  866. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  867. ,{field:'ModuleVersion', title:'模板更新版本', sort: true}
  868. ,{field:'ModulePath', title:'模板路径', sort: true}
  869. ]];
  870. //资源文件更新信息
  871. var FileUpdateInfo_cols = [[
  872. { type: 'checkbox', fixed: 'left' }
  873. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  874. ,{field:'VersionNum', title:'更新版本', sort: true}
  875. ,{field:'Path', title:'路径', sort: true}
  876. ,{field:'FileName', title:'文件名', sort: true}
  877. ]];
  878. //App版本管理
  879. var AppVersion_cols = [[
  880. { type: 'checkbox', fixed: 'left' }
  881. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  882. ,{field:'TerminalKind', title:'终端类型', sort: true}
  883. ,{field:'VersionNum', title:'版本号', sort: true}
  884. ,{field:'Title', title:'标题', sort: true}
  885. ,{field:'ConfirmText', title:'确定按钮文字', sort: true}
  886. ,{field:'CancelText', title:'取消按钮文字', sort: true}
  887. ,{field:'DownloadUrl', title:'更新地址', sort: true}
  888. ,{field:'StatusName', title:'状态', sort: true}
  889. ]];
  890. //App底部导航
  891. var AppBottomNavs_cols = [[
  892. { type: 'checkbox', fixed: 'left' }
  893. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  894. ,{field:'Title', title:'标题', sort: true}
  895. ,{field:'SelectTextColor', title:'选中文字颜色', sort: true}
  896. ,{field:'NormalTextColor', title:'未选中文字颜色', sort: true}
  897. ,{field:'PageName', title:'关联页面文件', sort: true}
  898. ,{field:'NoPageHint', title:'空页面提示信息', sort: true}
  899. ,{field:'BgColor', title:'背景色', sort: true}
  900. ,{field:'StatusName', title:'状态', sort: true}
  901. ]];
  902. //上传配置项
  903. var UploadParams_cols = [[
  904. { type: 'checkbox', fixed: 'left' }
  905. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  906. ,{field:'TableName', title:'表名', sort: true}
  907. ,{field:'ColumnName', title:'字段名', sort: true}
  908. ,{field:'ColumnEnName', title:'字段英文明', sort: true}
  909. ,{field:'ParamString', title:'参数', sort: true}
  910. ,{field:'TableEnName', title:'表英文名', sort: true}
  911. ]];
  912. //流量分佣明细
  913. var FluxProfitDetail_cols = [[
  914. { type: 'checkbox', fixed: 'left' }
  915. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  916. ,{field:'TradeDate', title:'交易日期', sort: true}
  917. ,{field:'UserId', title:'创客', sort: true}
  918. ,{field:'MerchantId', title:'商户', sort: true}
  919. ,{field:'MerNo', title:'渠道商户编号', sort: true}
  920. ,{field:'SnNo', title:'渠道SN号', sort: true}
  921. ,{field:'ProfitType', title:'分润类型', sort: true}
  922. ,{field:'FluxOrderNo', title:'流量扣费单号', sort: true}
  923. ,{field:'TradeOrderNo', title:'交易流水号', sort: true}
  924. ,{field:'TradeAmt', title:'商户交易额', sort: true}
  925. ,{field:'FluxFeeAmt', title:'流量费', sort: true}
  926. ,{field:'FluxStartDate', title:'流量扣费开始日期', sort: true}
  927. ,{field:'FluxEndDate', title:'流量扣费结束日期', sort: true}
  928. ,{field:'FluxProfitAmt', title:'流量分润总金额', sort: true}
  929. ,{field:'MerUserType', title:'商户创客类型', sort: true}
  930. ,{field:'CreateDate', title:'创建时间', sort: true}
  931. ]];
  932. //分润补贴明细
  933. var ProfitSubsidyDetail_cols = [[
  934. { type: 'checkbox', fixed: 'left' }
  935. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  936. ,{field:'BrandId', title:'品牌', sort: true}
  937. ,{field:'MerchantId', title:'商户', sort: true}
  938. ,{field:'MerNo', title:'渠道商户编号', sort: true}
  939. ,{field:'SnNo', title:'渠道SN号', sort: true}
  940. ,{field:'MerRegTime', title:'渠道注册时间', sort: true}
  941. ,{field:'MerStandardDate', title:'商户激活时间', sort: true}
  942. ,{field:'SubsidyUserId', title:'补贴人', sort: true}
  943. ,{field:'SubsidyType', title:'分润补贴类型', sort: true}
  944. ,{field:'CreditTradeAmt', title:'商户贷记卡交易总金额', sort: true}
  945. ,{field:'QrCreditTradeAmt', title:'商户(云闪付)贷记卡交易总金额', sort: true}
  946. ,{field:'NonQrCreditTradeAmt', title:'商户(非云闪付)贷记卡交易总金额', sort: true}
  947. ,{field:'CreditProfitRate', title:'(非云闪付)贷记卡交易分润比例', sort: true}
  948. ,{field:'SubsidyProfitRate', title:'创客活动期内直营商户分润万分之十', sort: true}
  949. ,{field:'SubsidyProfit', title:'商户(非云闪付)贷记卡交易分润补贴金额', sort: true}
  950. ,{field:'CreateDate', title:'创建时间', sort: true}
  951. ]];
  952. //返利明细表
  953. var UserRebateDetail_cols = [[
  954. { type: 'checkbox', fixed: 'left' }
  955. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  956. ,{field:'TradeMonth', title:'交易月份', sort: true}
  957. ,{field:'TradeDate', title:'达标日期', sort: true}
  958. ,{field:'UserId', title:'创客', sort: true}
  959. ,{field:'MgrNo', title:'渠道经理编号', sort: true}
  960. ,{field:'MgrName', title:'渠道经理姓名', sort: true}
  961. ,{field:'ProductType', title:'产品类型', sort: true}
  962. ,{field:'ProductName', title:'产品名称', sort: true}
  963. ,{field:'MerchantId', title:'商户', sort: true}
  964. ,{field:'ChannelMerNo', title:'渠道商户编号', sort: true}
  965. ,{field:'RebateType', title:'返利类型', sort: true}
  966. ,{field:'RebateMonthCount', title:'返利周期数', sort: true}
  967. ,{field:'CreditTradeAmt', title:'贷记卡交易总金额', sort: true}
  968. ,{field:'DebitTradeAmt', title:'借记卡交易总金额', sort: true}
  969. ,{field:'CreditRewardAmount', title:'贷记卡交易奖励金额', sort: true}
  970. ,{field:'DebitRewardAmount', title:'借记卡交易奖励金额', sort: true}
  971. ,{field:'RebateRewardNo', title:'达标返利单号', sort: true}
  972. ,{field:'Remark', title:'备注', sort: true}
  973. ,{field:'CreateDate', title:'创建时间', sort: true}
  974. ]];
  975. //商户返利明细
  976. var MerchantRebateDetail_cols = [[
  977. { type: 'checkbox', fixed: 'left' }
  978. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  979. ,{field:'BrandId', title:'品牌', sort: true}
  980. ,{field:'TradeMonth', title:'交易月份', sort: true}
  981. ,{field:'TradeDate', title:'达标日期', sort: true}
  982. ,{field:'MerNo', title:'渠道商户编号', sort: true}
  983. ,{field:'SnNo', title:'渠道SN号', sort: true}
  984. ,{field:'MerRegTime', title:'渠道注册时间', sort: true}
  985. ,{field:'MerStandardDate', title:'商户激活时间', sort: true}
  986. ,{field:'MerchantId', title:'商户', sort: true}
  987. ,{field:'MmpUserNo', title:'KYS刷APP创客编号', sort: true}
  988. ,{field:'MmpUserName', title:'KYS商户真实姓名', sort: true}
  989. ,{field:'CreditTradeAmt', title:'贷记卡交易总金额', sort: true}
  990. ,{field:'DebitTradeAmt', title:'借记卡交易总金额', sort: true}
  991. ,{field:'CreditRewardAmount', title:'贷记卡交易奖励金额', sort: true}
  992. ,{field:'DebitRewardAmount', title:'借记卡交易奖励金额', sort: true}
  993. ,{field:'SyncStatus', title:'同步MMP', sort: true}
  994. ,{field:'RewardDesc', title:'奖励描述', sort: true}
  995. ,{field:'CreateDate', title:'创建时间', sort: true}
  996. ]];
  997. //循环返风控白名单
  998. var UserSwapWhite_cols = [[
  999. { type: 'checkbox', fixed: 'left' }
  1000. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1001. ,{field:'UserId', title:'创客', sort: true}
  1002. ,{field:'RiskType', title:'风控类型', sort: true}
  1003. ,{field:'BrandId', title:'品牌', sort: true}
  1004. ,{field:'Remark', title:'备注', sort: true}
  1005. ,{field:'CreateDate', title:'创建时间', sort: true}
  1006. ]];
  1007. //拉新活动信息
  1008. var PullNewAct_cols = [[
  1009. { type: 'checkbox', fixed: 'left' }
  1010. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1011. ,{field:'SnDelayDay', title:'机具延时时间', sort: true}
  1012. ,{field:'ProductType', title:'产品类型', sort: true}
  1013. ,{field:'ProductName', title:'产品名称', sort: true}
  1014. ,{field:'ActEffectStartDate', title:'有效开始时间', sort: true}
  1015. ,{field:'ActEffectEndDate', title:'有效结束时间', sort: true}
  1016. ,{field:'CreateDate', title:'创建时间', sort: true}
  1017. ]];
  1018. //拉新明细
  1019. var PullNewDetail_cols = [[
  1020. { type: 'checkbox', fixed: 'left' }
  1021. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1022. ,{field:'StatDate', title:'统计日期', sort: true}
  1023. ,{field:'UserId', title:'创客', sort: true}
  1024. ,{field:'RecUserId', title:'招募人', sort: true}
  1025. ,{field:'RecMallOrderTime', title:'招募创客商城下单时间', sort: true}
  1026. ,{field:'RecMallBrandId', title:'招募人商城订单品牌', sort: true}
  1027. ,{field:'RecUserType', title:'商户创客类型', sort: true}
  1028. ,{field:'RegDate', title:'注册时间', sort: true}
  1029. ,{field:'CreateDate', title:'创建时间', sort: true}
  1030. ]];
  1031. //创客商城提大货SN
  1032. var UserMallLargeSn_cols = [[
  1033. { type: 'checkbox', fixed: 'left' }
  1034. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1035. ,{field:'UserId', title:'创客', sort: true}
  1036. ,{field:'BrandId', title:'品牌', sort: true}
  1037. ,{field:'OrderNo', title:'订单号', sort: true}
  1038. ,{field:'OrderAmount', title:'订单金额', sort: true}
  1039. ,{field:'OrderNum', title:'订单数量', sort: true}
  1040. ,{field:'RuleOrderAmt', title:'规则订单金额', sort: true}
  1041. ,{field:'SnStatus', title:'SN状态', sort: true}
  1042. ,{field:'SnNo', title:'SN编号', sort: true}
  1043. ,{field:'SnType', title:'SN类型', sort: true}
  1044. ,{field:'SnShipDate', title:'SN发货时间', sort: true}
  1045. ,{field:'StoreId', title:'SN发货仓库', sort: true}
  1046. ,{field:'Remark', title:'备注', sort: true}
  1047. ,{field:'CreateDate', title:'创建时间', sort: true}
  1048. ]];
  1049. //产品规则配置
  1050. var KqProductRuleSet_cols = [[
  1051. { type: 'checkbox', fixed: 'left' }
  1052. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1053. ,{field:'Deposit', title:'押金', sort: true}
  1054. ,{field:'ActiveCount', title:'活动政策台数', sort: true}
  1055. ,{field:'ActivePrice', title:'活动政策价格', sort: true}
  1056. ,{field:'MerStaStartDate', title:'活动开始时间', sort: true}
  1057. ,{field:'MerStaEndDate', title:'活动结束时间', sort: true}
  1058. ,{field:'MerStaProfit', title:'达标奖励', sort: true}
  1059. ,{field:'MerStaMonths', title:'激活后达标月', sort: true}
  1060. ,{field:'MerStaTradeForMonth', title:'激活后每月达标交易', sort: true}
  1061. ,{field:'ActStartDate', title:'活动开始时间', sort: true}
  1062. ,{field:'ActEndDate', title:'活动结束时间', sort: true}
  1063. ,{field:'ActDeposit', title:'激活押金', sort: true}
  1064. ,{field:'ActFirst', title:'激活首刷', sort: true}
  1065. ,{field:'ActFirstDeposit', title:'激活首刷押金', sort: true}
  1066. ,{field:'ActPrize', title:'激活奖励金额', sort: true}
  1067. ,{field:'ActPosCount', title:'激活赠机台数', sort: true}
  1068. ,{field:'OpenStartDate', title:'活动开始时间', sort: true}
  1069. ,{field:'OpenEndDate', title:'活动结束时间', sort: true}
  1070. ,{field:'OpenStaDays', title:'达标天数', sort: true}
  1071. ,{field:'OpenStaTrade', title:'达标交易', sort: true}
  1072. ,{field:'OpenStaPrize', title:'达标奖励1', sort: true}
  1073. ,{field:'OpenStaPrize2', title:'达标奖励2', sort: true}
  1074. ,{field:'CycleStartDate', title:'活动开始时间', sort: true}
  1075. ,{field:'CycleEndDate', title:'活动结束时间', sort: true}
  1076. ,{field:'CycleIsOtherName', title:'是否允许划拨给他人', sort: true}
  1077. ,{field:'CyclePosDays', title:'领机天数', sort: true}
  1078. ,{field:'PullNewStartDate', title:'活动开始时间', sort: true}
  1079. ,{field:'PullNewEndDate', title:'活动结束时间', sort: true}
  1080. ,{field:'PullNewExtendDays', title:'延长领机天数', sort: true}
  1081. ,{field:'BigTotalAmount', title:'购买机起始价', sort: true}
  1082. ,{field:'BigExtendCycleDays', title:'延长循环周期天数', sort: true}
  1083. ,{field:'SubsidyStartDate', title:'活动开始时间', sort: true}
  1084. ,{field:'SubsidyEndDate', title:'活动结束时间', sort: true}
  1085. ,{field:'FlowCardStartDate', title:'活动开始时间', sort: true}
  1086. ,{field:'FlowCardEndDate', title:'活动结束时间', sort: true}
  1087. ,{field:'FlowCardFreeDays', title:'免收天数', sort: true}
  1088. ,{field:'FlowCardFee', title:'费用', sort: true}
  1089. ,{field:'FeeOfDays', title:'扣费频率(天)', sort: true}
  1090. ,{field:'FlowCardDirectProfit', title:'直属上级返佣', sort: true}
  1091. ,{field:'HelpStartDate', title:'活动开始时间', sort: true}
  1092. ,{field:'HelpEndDate', title:'活动结束时间', sort: true}
  1093. ,{field:'HelpMonths', title:'计算自然月', sort: true}
  1094. ,{field:'HelpFee', title:'扶植期费率', sort: true}
  1095. ,{field:'HelpSteadyFee', title:'稳定期费率', sort: true}
  1096. ,{field:'FeeBindDays', title:'绑定起天数', sort: true}
  1097. ,{field:'FeeFixed', title:'固定手续费', sort: true}
  1098. ,{field:'FeeRate', title:'费率', sort: true}
  1099. ,{field:'StatusName', title:'状态', sort: true}
  1100. ]];
  1101. //产品库
  1102. var KqProducts_cols = [[
  1103. { type: 'checkbox', fixed: 'left' }
  1104. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1105. ,{field:'Name', title:'名称', sort: true}
  1106. ]];
  1107. //产品品牌
  1108. var KqProductBrand_cols = [[
  1109. { type: 'checkbox', fixed: 'left' }
  1110. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1111. ,{field:'Name', title:'品牌名称', sort: true}
  1112. ]];
  1113. //产品机构
  1114. var KqProductOrgs_cols = [[
  1115. { type: 'checkbox', fixed: 'left' }
  1116. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1117. ,{field:'Name', title:'机构名称', sort: true}
  1118. ]];
  1119. //仓库库存变动信息
  1120. var StoreBalance_cols = [[
  1121. { type: 'checkbox', fixed: 'left' }
  1122. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1123. ,{field:'StoreId', title:'仓库', sort: true}
  1124. ,{field:'TransRecordNo', title:'交易流水编号', sort: true}
  1125. ,{field:'TransType', title:'交易类型', sort: true}
  1126. ,{field:'BrandId', title:'产品类型', sort: true}
  1127. ,{field:'OpStoreNum', title:'操作库存数', sort: true}
  1128. ,{field:'OpSymbol', title:'操作符', sort: true}
  1129. ,{field:'BeforeTotalNum', title:'操作前总库存数', sort: true}
  1130. ,{field:'AfterTotalNum', title:'操作后总库存数', sort: true}
  1131. ,{field:'BeforeLaveNum', title:'操作前剩余库存数', sort: true}
  1132. ,{field:'AfterLaveNum', title:'操作后剩余库存数', sort: true}
  1133. ,{field:'BeforeOutNum', title:'操作前出库数', sort: true}
  1134. ,{field:'AfterOutNum', title:'操作后出库数', sort: true}
  1135. ,{field:'CreateDate', title:'创建时间', sort: true}
  1136. ]];
  1137. //开团申请
  1138. var TeamApply_cols = [[
  1139. { type: 'checkbox', fixed: 'left' }
  1140. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1141. ,{field:'TeamNo', title:'队伍编码', sort: true}
  1142. ,{field:'TeamName', title:'队伍名称', sort: true}
  1143. ,{field:'UserId', title:'队长', sort: true}
  1144. ,{field:'Areas', title:'特训营所在地区', sort: true}
  1145. ,{field:'EffectStartDate', title:'活动开始时间', sort: true}
  1146. ,{field:'EffectEndDate', title:'活动结束时间', sort: true}
  1147. ,{field:'EnterStartDate', title:'报名开始时间', sort: true}
  1148. ,{field:'EnterEndDate', title:'报名结束时间', sort: true}
  1149. ,{field:'MinUserNum', title:'最小队伍人数', sort: true}
  1150. ,{field:'MaxUserNum', title:'最大队伍人数', sort: true}
  1151. ,{field:'WatchWord', title:'口号', sort: true}
  1152. ,{field:'AuditTime', title:'审核时间', sort: true}
  1153. ,{field:'AuditResult', title:'审核结果', sort: true}
  1154. ,{field:'AuditRemark', title:'审核备注', sort: true}
  1155. ,{field:'NotifyFlag', title:'提醒标识', sort: true}
  1156. ,{field:'Remark', title:'备注', sort: true}
  1157. ,{field:'TopUserId', title:'顶级创客', sort: true}
  1158. ,{field:'TeamStatus', title:'组队状态', sort: true}
  1159. ]];
  1160. //参团申请
  1161. var TeamOfferApply_cols = [[
  1162. { type: 'checkbox', fixed: 'left' }
  1163. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1164. ,{field:'Areas', title:'特训营所在地区', sort: true}
  1165. ,{field:'EffectStartDate', title:'活动开始时间', sort: true}
  1166. ,{field:'EffectEndDate ', title:'活动结束时间', sort: true}
  1167. ,{field:'EnterDate', title:'报名时间', sort: true}
  1168. ,{field:'AuditTime', title:'审核时间', sort: true}
  1169. ,{field:'AuditResult', title:'审核结果', sort: true}
  1170. ,{field:'AuditRemark', title:'审核备注', sort: true}
  1171. ,{field:'NotifyFlag', title:'提醒标识', sort: true}
  1172. ,{field:'UserId', title:'创客', sort: true}
  1173. ,{field:'TeamId', title:'团队', sort: true}
  1174. ,{field:'TeamLeader', title:'队长', sort: true}
  1175. ,{field:'TopUserId', title:'顶级创客', sort: true}
  1176. ,{field:'TeamApplyStatus', title:'组队申请状态', sort: true}
  1177. ,{field:'TeamStatus', title:'状态', sort: true}
  1178. ]];
  1179. //开团配置
  1180. var TeamConfig_cols = [[
  1181. { type: 'checkbox', fixed: 'left' }
  1182. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1183. ,{field:'LimitBuddyNo', title:'限制人', sort: true}
  1184. ,{field:'MinUserNum', title:'最小队伍人数', sort: true}
  1185. ,{field:'MaxUserNum', title:'最大队伍人数', sort: true}
  1186. ,{field:'MinCycleNum', title:'最小周期天数', sort: true}
  1187. ,{field:'MaxCycleNum', title:'最大周期天数', sort: true}
  1188. ,{field:'MinStartDayLimit', title:'最小间隔天数', sort: true}
  1189. ,{field:'MaxStartDayLimit', title:'最大间隔天数', sort: true}
  1190. ,{field:'OverlineStatusName', title:'是否允许跨顶级线报名', sort: true}
  1191. ,{field:'BlacklistCycle', title:'黑名单周期', sort: true}
  1192. ,{field:'EnterEndMin', title:'活动时间差', sort: true}
  1193. ,{field:'Remark', title:'备注', sort: true}
  1194. ]];
  1195. //开团黑名单
  1196. var TeamBlackList_cols = [[
  1197. { type: 'checkbox', fixed: 'left' }
  1198. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1199. ,{field:'UserId', title:'创客', sort: true}
  1200. ,{field:'EffectStartDate', title:'生效时间', sort: true}
  1201. ,{field:'EffectEndDate', title:'失效时间', sort: true}
  1202. ,{field:'TopUserId', title:'顶级创客', sort: true}
  1203. ,{field:'BlackStatus', title:'状态', sort: true}
  1204. ,{field:'CreateDate', title:'创建时间', sort: true}
  1205. ]];
  1206. //分润对象活动参数
  1207. var ProfitObjectsActiveParams_cols = [[
  1208. { type: 'checkbox', fixed: 'left' }
  1209. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1210. ,{field:'ProfitObjectsActiveId', title:'分润对象活动', sort: true}
  1211. ,{field:'Name', title:'参数名称', sort: true}
  1212. ,{field:'TextValue', title:'参数值', sort: true}
  1213. ,{field:'Remark', title:'参数说明', sort: true}
  1214. ]];
  1215. //活动奖励明细
  1216. var ActivityPrizeDetail_cols = [[
  1217. { type: 'checkbox', fixed: 'left' }
  1218. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1219. ,{field:'TradeAmt', title:'合伙人团队交易总金额', sort: true}
  1220. ,{field:'CheckStatus', title:'同步状态', sort: true}
  1221. ,{field:'TradeMonth', title:'交易月份', sort: true}
  1222. ,{field:'OtherProdCreditTradeAmt', title:'其他组合计算产品贷记卡交易总金额', sort: true}
  1223. ,{field:'CreditTradeAmt', title:'合伙人团队贷记卡交易总金额', sort: true}
  1224. ,{field:'ActRewardAmt', title:'合伙人团队交易活动奖励金额', sort: true}
  1225. ,{field:'ProfitRate', title:'活动奖励对应分成比例', sort: true}
  1226. ,{field:'CreateDate', title:'创建时间', sort: true}
  1227. ]];
  1228. //创客机具延迟变动明细表
  1229. var UserSnDelayChange_cols = [[
  1230. { type: 'checkbox', fixed: 'left' }
  1231. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1232. ,{field:'UserId', title:'创客', sort: true}
  1233. ,{field:'BrandId', title:'品牌', sort: true}
  1234. ,{field:'ChangeRecordNo', title:'变更记录单号', sort: true}
  1235. ,{field:'SnNo', title:'SN编号', sort: true}
  1236. ,{field:'SnType', title:'SN机具类型', sort: true}
  1237. ,{field:'SnStoreId', title:'发货仓库', sort: true}
  1238. ,{field:'InitCycleDate', title:'初始循环截止时间', sort: true}
  1239. ,{field:'BeforeEndCycleDate', title:'变动前循环截止时间', sort: true}
  1240. ,{field:'AfterEndCycleDate', title:'变动后循环截止时间', sort: true}
  1241. ,{field:'RecUserId', title:'招募创客', sort: true}
  1242. ,{field:'SnDelayDay', title:'机具延时天数', sort: true}
  1243. ,{field:'ActivityRuleId', title:'拉新活动', sort: true}
  1244. ,{field:'SourceSnNo', title:'源SN编号', sort: true}
  1245. ,{field:'SourceSnType', title:'源SN类型', sort: true}
  1246. ,{field:'SourceSnShipDate', title:'源SN发货时间', sort: true}
  1247. ,{field:'SourceStoreId', title:'源SN发货你仓库', sort: true}
  1248. ,{field:'CreateDate', title:'创建时间', sort: true}
  1249. ]];
  1250. //创客库存变动记录
  1251. var UserStoreChange_cols = [[
  1252. { type: 'checkbox', fixed: 'left' }
  1253. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1254. ,{field:'UserId', title:'创客', sort: true}
  1255. ,{field:'BrandId', title:'产品类型', sort: true}
  1256. ,{field:'TransType', title:'交易类型', sort: true}
  1257. ,{field:'SnNo', title:'SN编号', sort: true}
  1258. ,{field:'SnType', title:'SN机具类型', sort: true}
  1259. ,{field:'StockOpDirect', title:'库存操作方向', sort: true}
  1260. ,{field:'ToUserId', title:'收货创客', sort: true}
  1261. ,{field:'ToStoreId', title:'创客退货收货仓库', sort: true}
  1262. ,{field:'SourceStoreId', title:'源仓库', sort: true}
  1263. ,{field:'SnStatus', title:'SN状态', sort: true}
  1264. ,{field:'BindStatus', title:'绑定状态', sort: true}
  1265. ,{field:'BindMerchantId', title:'绑定商户', sort: true}
  1266. ,{field:'ActiveStatus', title:'激活状态', sort: true}
  1267. ,{field:'ActRewardUserId', title:'激活奖励创客', sort: true}
  1268. ,{field:'FromUserId', title:'出货创客', sort: true}
  1269. ,{field:'BrandType', title:'品牌类型', sort: true}
  1270. ,{field:'CreateDate', title:'创建时间', sort: true}
  1271. ]];
  1272. //机具变动历史
  1273. var StoreChangeHistory_cols = [[
  1274. { type: 'checkbox', fixed: 'left' }
  1275. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1276. ,{field:'UserId', title:'创客', sort: true}
  1277. ,{field:'BrandId', title:'产品类型', sort: true}
  1278. ,{field:'TransType', title:'交易类型', sort: true}
  1279. ,{field:'SnNo', title:'SN编号', sort: true}
  1280. ,{field:'SnType', title:'SN机具类型', sort: true}
  1281. ,{field:'StockOpDirect', title:'库存操作方向', sort: true}
  1282. ,{field:'ToUserId', title:'收货创客', sort: true}
  1283. ,{field:'ToStoreId', title:'创客退货收货仓库', sort: true}
  1284. ,{field:'SourceStoreId', title:'源仓库', sort: true}
  1285. ,{field:'StoreId', title:'仓库', sort: true}
  1286. ,{field:'CreateDate', title:'创建时间', sort: true}
  1287. ]];
  1288. //创客奖励记录
  1289. var SysRechargeRecord_cols = [[
  1290. { type: 'checkbox', fixed: 'left' }
  1291. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1292. ,{field:'RechargeRecNo', title:'充值流水号', sort: true}
  1293. ,{field:'ProductType', title:'产品类型', sort: true}
  1294. ,{field:'UserId', title:'创客', sort: true}
  1295. ,{field:'BizType', title:'业务类型', sort: true}
  1296. ,{field:'BizTime', title:'奖励时间', sort: true}
  1297. ,{field:'Amount', title:'奖励金额', sort: true}
  1298. ,{field:'SyncStatus', title:'同步状态', sort: true}
  1299. ,{field:'BatchCode', title:'批次号', sort: true}
  1300. ,{field:'CreateDate', title:'创建时间', sort: true}
  1301. ]];
  1302. //创客预设职级
  1303. var UserRankWhite_cols = [[
  1304. { type: 'checkbox', fixed: 'left' }
  1305. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1306. ,{field:'UserId', title:'用户', sort: true}
  1307. ,{field:'Rank', title:'当前等级类型', sort: true}
  1308. ,{field:'CreateDate', title:'创建时间', sort: true}
  1309. ]];
  1310. //循环返风控明细信息
  1311. var UserSwapDetail_cols = [[
  1312. { type: 'checkbox', fixed: 'left' }
  1313. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1314. ,{field:'UserId', title:'创客', sort: true}
  1315. ,{field:'TradeMonth', title:'交易月', sort: true}
  1316. ,{field:'BrandId', title:'品牌', sort: true}
  1317. ,{field:'SnNo', title:'风控SN编号', sort: true}
  1318. ,{field:'SnType', title:'风控SN机具类型', sort: true}
  1319. ,{field:'RiskResult', title:'循环风控降档状态', sort: true}
  1320. ,{field:'SwapExtProductTypes', title:'可申请循环产品类型', sort: true}
  1321. ,{field:'CreateDate', title:'创建时间', sort: true}
  1322. ]];
  1323. //开机奖励
  1324. var OpenReward_cols = [[
  1325. { type: 'checkbox', fixed: 'left' }
  1326. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1327. ,{field:'TradeDate', title:'达标日期', sort: true}
  1328. ,{field:'UserId', title:'创客', sort: true}
  1329. ,{field:'BrandId', title:'品牌', sort: true}
  1330. ,{field:'RewardType', title:'奖励类型', sort: true}
  1331. ,{field:'CreditTradeAmt', title:'贷记卡交易总金额', sort: true}
  1332. ,{field:'DebitTradeAmt', title:'借记卡交易总金额', sort: true}
  1333. ,{field:'CreditRewardAmount', title:'贷记卡交易奖励金额', sort: true}
  1334. ,{field:'DebitRewardAmount', title:'借记记卡交易奖励金额', sort: true}
  1335. ,{field:'RewardMerCount', title:'达标商户数', sort: true}
  1336. ,{field:'CheckStatus', title:'验证和同步账户状态', sort: true}
  1337. ,{field:'CreateDate', title:'创建时间', sort: true}
  1338. ]];
  1339. //开机机具快照
  1340. var OpenSnSnapshot_cols = [[
  1341. { type: 'checkbox', fixed: 'left' }
  1342. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1343. ,{field:'TradeDate', title:'达标日期', sort: true}
  1344. ,{field:'UserId', title:'创客', sort: true}
  1345. ,{field:'BrandId', title:'品牌', sort: true}
  1346. ,{field:'MerchantId', title:'商户', sort: true}
  1347. ,{field:'DirectUserId', title:'商户直属人', sort: true}
  1348. ,{field:'SnNo', title:'SN号', sort: true}
  1349. ,{field:'MerNo', title:'渠道商户号', sort: true}
  1350. ,{field:'StandardDate', title:'商户的激活日期', sort: true}
  1351. ,{field:'RewardType', title:'奖励类型', sort: true}
  1352. ,{field:'RewardTips', title:'奖励描述', sort: true}
  1353. ,{field:'OpenRewardNo', title:'开机奖励单号', sort: true}
  1354. ,{field:'BuySnNum', title:'购买机数量', sort: true}
  1355. ,{field:'StdBuySnNum', title:'标准购买机数量', sort: true}
  1356. ,{field:'RewardAmount', title:'奖励金额', sort: true}
  1357. ,{field:'FailReason', title:'失败原因', sort: true}
  1358. ,{field:'CreateDate', title:'创建时间', sort: true}
  1359. ]];
  1360. //机具退货申请订单
  1361. var MachineReturn_cols = [[
  1362. { type: 'checkbox', fixed: 'left' }
  1363. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1364. ,{field:'ApplyNo', title:'申请单号', sort: true}
  1365. ,{field:'UserId', title:'创客', sort: true}
  1366. ,{field:'BrandId', title:'品牌', sort: true}
  1367. ,{field:'DeviceNum', title:'申请退货数量', sort: true}
  1368. ,{field:'ToStoreId', title:'退回仓库', sort: true}
  1369. ,{field:'DeviceDesc', title:'设备描述', sort: true}
  1370. ,{field:'AuditStatus', title:'审核状态', sort: true}
  1371. ,{field:'Operator', title:'操作人', sort: true}
  1372. ,{field:'Remark', title:'退货备注', sort: true}
  1373. ,{field:'CreateDate', title:'创建时间', sort: true}
  1374. ]];
  1375. //机具激活限制信息
  1376. var UserSnActInfo_cols = [[
  1377. { type: 'checkbox', fixed: 'left' }
  1378. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1379. ,{field:'UserId', title:'创客', sort: true}
  1380. ,{field:'BrandId', title:'产品类型', sort: true}
  1381. ,{field:'SnNo', title:'SN编号', sort: true}
  1382. ,{field:'SnType', title:'SN机具类型', sort: true}
  1383. ,{field:'SnStoreId', title:'SN仓库', sort: true}
  1384. ,{field:'EffectStartCycleDate', title:'有效开始循环时间', sort: true}
  1385. ,{field:'EffectEndCycleDate', title:'有效结束循环时间', sort: true}
  1386. ,{field:'ActUserId', title:'激活奖励创客', sort: true}
  1387. ,{field:'ActiveStatus', title:'商户激活状态', sort: true}
  1388. ,{field:'StandardDate', title:'激活日期', sort: true}
  1389. ,{field:'SourceSnNo', title:'源SN编号', sort: true}
  1390. ,{field:'SourceSnType', title:'源SN机具类型', sort: true}
  1391. ,{field:'SourceShipDate', title:'源SN发货时间', sort: true}
  1392. ,{field:'SourceStoreId', title:'源SN发货你仓库', sort: true}
  1393. ,{field:'CreateDate', title:'创建时间', sort: true}
  1394. ]];
  1395. //创客预设分润
  1396. var UserProfitSet_cols = [[
  1397. { type: 'checkbox', fixed: 'left' }
  1398. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1399. ,{field:'UserId', title:'创客', sort: true}
  1400. ,{field:'BrandId', title:'品牌', sort: true}
  1401. ,{field:'CardType', title:'交易卡类型', sort: true}
  1402. ,{field:'HelpFlag', title:'扶持期标识', sort: true}
  1403. ,{field:'ProfitRate', title:'创客预设分润比例', sort: true}
  1404. ,{field:'ProfitPercent', title:'创客预设分润百分比', sort: true}
  1405. ,{field:'AddOrSubRate', title:'浮动空间', sort: true}
  1406. ,{field:'ProfitRateBase', title:'分润比例基数', sort: true}
  1407. ,{field:'Remark', title:'备注', sort: true}
  1408. ,{field:'CreateDate', title:'创建时间', sort: true}
  1409. ]];
  1410. //交易日汇总
  1411. var TradeDaySummary_cols = [[
  1412. { type: 'checkbox', fixed: 'left' }
  1413. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1414. ,{field:'UserId', title:'创客', sort: true}
  1415. ,{field:'TradeDate', title:'交易日', sort: true}
  1416. ,{field:'TradeMonth', title:'交易月', sort: true}
  1417. ,{field:'NotHelpDirectTradeAmt', title:'直营商户交易总额(非扶持期)', sort: true}
  1418. ,{field:'NotHelpNonDirectTradeAmt', title:'非直营商户交易总额(非扶持期)', sort: true}
  1419. ,{field:'NotHelpDirectCreditTradeAmt', title:'直营贷记卡交易总额(非扶持期)', sort: true}
  1420. ,{field:'NotHelpNonDirectCreditTradeAmt', title:'非直营贷记卡交易总额(非扶持期)', sort: true}
  1421. ,{field:'NotHelpDirectQrCreditTradeAmt', title:'直营云闪付贷记卡交易额(非扶持期)', sort: true}
  1422. ,{field:'NotHelpNonDirectQrCreditTradeAmt', title:'非直营云闪付贷记卡交易额(非扶持期)', sort: true}
  1423. ,{field:'NotHelpDirectNonQrCreditTradeAmt', title:'直营非云闪付贷记卡交易额(非扶持期)', sort: true}
  1424. ,{field:'NotHelpNonDirectNonQrCreditTradeAmt', title:'非直营非云闪付贷记卡交易额(非扶持期)', sort: true}
  1425. ,{field:'NotHelpDirectDebitTradeAmt', title:'直营商户借记卡交易总额(非扶持期)', sort: true}
  1426. ,{field:'NotHelpDirectDebitCapTradeAmt', title:'直营商户借记卡封顶交易总金额(非扶持期)', sort: true}
  1427. ,{field:'NotHelpDirectDebitCapNum', title:'直营商户借记卡封顶交易总数(非扶持期)', sort: true}
  1428. ,{field:'NotHelpNonDirectDebitTradeAmt', title:'非直营商户借记卡交易总额(非扶持期)', sort: true}
  1429. ,{field:'NotHelpNonDirectDebitCapTradeAmt', title:'非直营商户借记卡封顶交易总金额(非扶持期)', sort: true}
  1430. ,{field:'NotHelpNonDirectDebitCapNum', title:'非直营商户借记卡封顶交易总数(非扶持期)', sort: true}
  1431. ,{field:'NotHelpDirectQrDebitTradeAmt', title:'直营云闪付非封顶借记卡(非扶持期)', sort: true}
  1432. ,{field:'NotHelpNonDirectQrDebitTradeAmt', title:'非直营云闪付非封顶借记卡(非扶持期)', sort: true}
  1433. ,{field:'NotHelpDirectNonQrDebitTradeAmt', title:'直营非云闪付非封顶借记卡(非扶持期)', sort: true}
  1434. ,{field:'NotHelpNonDirectNonQrDebitTradeAmt', title:'非直营非云闪付非封顶借记卡(非扶持期)', sort: true}
  1435. ,{field:'HelpDirectTradeAmt', title:'直营商户交易总额(扶持期)', sort: true}
  1436. ,{field:'HelpNonDirectTradeAmt', title:'非直营商户交易总额(扶持期)', sort: true}
  1437. ,{field:'HelpDirectCreditTradeAmt', title:'直营贷记卡交易总额(扶持期)', sort: true}
  1438. ,{field:'HelpNonDirectCreditTradeAmt', title:'非直营贷记卡交易总额(扶持期)', sort: true}
  1439. ,{field:'HelpDirectQrCreditTradeAmt', title:'直营云闪付贷记卡交易额(扶持期)', sort: true}
  1440. ,{field:'HelpNonDirectQrCreditTradeAmt', title:'非直营云闪付贷记卡交易额(扶持期)', sort: true}
  1441. ,{field:'HelpDirectNonQrCreditTradeAmt', title:'直营非云闪付贷记卡交易额(扶持期)', sort: true}
  1442. ,{field:'HelpNonDirectNonQrCreditTradeAmt', title:'非直营非云闪付贷记卡交易额(扶持期)', sort: true}
  1443. ,{field:'HelpDirectDebitTradeAmt', title:'直营商户借记卡交易总额(扶持期)', sort: true}
  1444. ,{field:'HelpDirectDebitCapTradeAmt', title:'直营商户借记卡封顶交易总金额(扶持期)', sort: true}
  1445. ,{field:'HelpDirectDebitCapNum', title:'直营商户借记卡封顶交易总数(扶持期)', sort: true}
  1446. ,{field:'HelpNonDirectDebitTradeAmt', title:'非直营商户借记卡交易总额(扶持期)', sort: true}
  1447. ,{field:'HelpNonDirectDebitCapTradeAmt', title:'非直营商户借记卡封顶交易总金额(扶持期)', sort: true}
  1448. ,{field:'HelpNonDirectDebitCapNum', title:'非直营商户借记卡封顶交易总数(扶持期)', sort: true}
  1449. ,{field:'HelpDirectQrDebitTradeAmt', title:'直营云闪付非封顶借记卡(扶持期)', sort: true}
  1450. ,{field:'HelpNonDirectQrDebitTradeAmt', title:'非直营云闪付非封顶借记卡(扶持期)', sort: true}
  1451. ,{field:'HelpDirectNonQrDebitTradeAmt', title:'直营非云闪付非封顶借记卡(扶持期)', sort: true}
  1452. ,{field:'HelpNonDirectNonQrDebitTradeAmt', title:'非直营非云闪付非封顶借记卡(扶持期)', sort: true}
  1453. ,{field:'CreateDate', title:'创建时间', sort: true}
  1454. ]];
  1455. //创客交易日汇总
  1456. var UserTradeDaySummary_cols = [[
  1457. { type: 'checkbox', fixed: 'left' }
  1458. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1459. ,{field:'UserId', title:'创客', sort: true}
  1460. ,{field:'TradeDate', title:'交易日', sort: true}
  1461. ,{field:'TradeMonth', title:'交易月', sort: true}
  1462. ,{field:'BrandId', title:'品牌', sort: true}
  1463. ,{field:'DirectTradeAmt', title:'直营商户交易总额', sort: true}
  1464. ,{field:'NonDirectTradeAmt', title:'非直营商户交易总额', sort: true}
  1465. ,{field:'DirectDebitTradeAmt', title:'直营商户借记卡交易总额', sort: true}
  1466. ,{field:'DirectDebitCapNum', title:'直营激活商户数', sort: true}
  1467. ,{field:'NonDirectDebitTradeAmt', title:'非直营商户借记卡交易总额', sort: true}
  1468. ,{field:'NonDirectDebitCapNum', title:'非直营激活商户数', sort: true}
  1469. ,{field:'Remark', title:'备注', sort: true}
  1470. ,{field:'CreateDate', title:'创建时间', sort: true}
  1471. ]];
  1472. //创客分润补贴月汇总
  1473. var UserProfitSubsidySummary_cols = [[
  1474. { type: 'checkbox', fixed: 'left' }
  1475. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1476. ,{field:'UserId', title:'创客', sort: true}
  1477. ,{field:'BrandId', title:'品牌', sort: true}
  1478. ,{field:'TradeMonth', title:'交易月', sort: true}
  1479. ,{field:'SubsidyTotalProfit', title:'商户(非云闪付)贷记卡交易分润补贴总金额', sort: true}
  1480. ,{field:'SubsidyJuniorProfit', title:'下级合伙人直属商户(非云闪付)贷记卡交易分润补贴总金额', sort: true}
  1481. ,{field:'SubsidyDirectProfit', title:'直营商户(非云闪付)贷记卡交易分润补贴总金额', sort: true}
  1482. ,{field:'CheckStatus', title:'验证和同步账户状态', sort: true}
  1483. ,{field:'CreateDate', title:'创建时间', sort: true}
  1484. ]];
  1485. //交易按产品汇总
  1486. var UserTradeMonthSummary_cols = [[
  1487. { type: 'checkbox', fixed: 'left' }
  1488. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1489. ,{field:'UserId', title:'创客', sort: true}
  1490. ,{field:'TradeMonth', title:'交易月', sort: true}
  1491. ,{field:'BrandId', title:'品牌', sort: true}
  1492. ,{field:'StatType', title:'交易统计类型', sort: true}
  1493. ,{field:'TradeAmt', title:'商户交易总额', sort: true}
  1494. ,{field:'CreditTradeAmt', title:'商户贷记卡交易总金额', sort: true}
  1495. ,{field:'DebitNotCapTradeAmt', title:'商户非封顶借记卡交易总金额', sort: true}
  1496. ,{field:'DebitCapTradeAmt', title:'商户借记卡封顶交易总额', sort: true}
  1497. ,{field:'CreateDate', title:'创建时间', sort: true}
  1498. ]];
  1499. //创客循环返风控月汇总
  1500. var UserSwapSummary_cols = [[
  1501. { type: 'checkbox', fixed: 'left' }
  1502. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1503. ,{field:'UserId', title:'创客', sort: true}
  1504. ,{field:'TradeMonth', title:'交易月', sort: true}
  1505. ,{field:'BrandId', title:'品牌', sort: true}
  1506. ,{field:'DirectActMerCount', title:'上月直营激活商户数', sort: true}
  1507. ,{field:'DirAvgTradeAmt', title:'户均', sort: true}
  1508. ,{field:'RiskStatus', title:'循环风控降档状态', sort: true}
  1509. ,{field:'SwapExtProductTypes', title:'可申请循环产品类型', sort: true}
  1510. ,{field:'CreateDate', title:'创建时间', sort: true}
  1511. ]];
  1512. //流量分佣汇总
  1513. var FluxProfitSummary_cols = [[
  1514. { type: 'checkbox', fixed: 'left' }
  1515. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1516. ,{field:'UserId', title:'创客', sort: true}
  1517. ,{field:'TopUserId', title:'顶级创客', sort: true}
  1518. ,{field:'TradeMonth', title:'交易月', sort: true}
  1519. ,{field:'MerUserType', title:'商户创客类型', sort: true}
  1520. ,{field:'FluxProfitAmt', title:'流量分润总金额', sort: true}
  1521. ,{field:'FluxTradeNum', title:'商户借记卡封顶交易总笔数', sort: true}
  1522. ,{field:'CheckStatus', title:'同步账户状态', sort: true}
  1523. ,{field:'CreateDate', title:'创建时间', sort: true}
  1524. ]];
  1525. //仓库订单汇总
  1526. var StoreMallOrderSummary_cols = [[
  1527. { type: 'checkbox', fixed: 'left' }
  1528. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1529. ,{field:'TradeMonth', title:'交易月', sort: true}
  1530. ,{field:'StoreId', title:'仓库', sort: true}
  1531. ,{field:'AgentStoreId', title:'代理分仓', sort: true}
  1532. ,{field:'BrandId', title:'品牌', sort: true}
  1533. ,{field:'UnitPrice', title:'单价', sort: true}
  1534. ,{field:'OrderNum', title:'订单数量', sort: true}
  1535. ,{field:'OrderAmt', title:'订单金额', sort: true}
  1536. ,{field:'RefundOrderNum', title:'退款订单数量', sort: true}
  1537. ,{field:'RefundAmt', title:'退款金额', sort: true}
  1538. ,{field:'SettleStatus', title:'结算状态', sort: true}
  1539. ,{field:'Remark', title:'备注', sort: true}
  1540. ,{field:'CreateDate', title:'创建时间', sort: true}
  1541. ]];
  1542. //拉新日统计信息
  1543. var PullnewSummary_cols = [[
  1544. { type: 'checkbox', fixed: 'left' }
  1545. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1546. ,{field:'StatDate', title:'统计日', sort: true}
  1547. ,{field:'UserId', title:'创客', sort: true}
  1548. ,{field:'BrandId', title:'产品类型', sort: true}
  1549. ,{field:'RecUserDeliveryStdNum', title:'招募创客提货达标人数', sort: true}
  1550. ,{field:'CreateDate', title:'创建时间', sort: true}
  1551. ]];
  1552. //仓库SN激活统计
  1553. var StoreSnActivateSummary_cols = [[
  1554. { type: 'checkbox', fixed: 'left' }
  1555. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1556. ,{field:'TradeDate', title:'交易日', sort: true}
  1557. ,{field:'TradeMonth', title:'交易月', sort: true}
  1558. ,{field:'StoreId', title:'仓库', sort: true}
  1559. ,{field:'AgentStoreId', title:'代理分仓', sort: true}
  1560. ,{field:'BrandId', title:'产品类型', sort: true}
  1561. ,{field:'ActivateNum', title:'激活数量', sort: true}
  1562. ,{field:'RejectActNum', title:'互斥激活数量', sort: true}
  1563. ,{field:'TransferActNum', title:'划拨激活数量(循环机划拨激活数)', sort: true}
  1564. ,{field:'EffectActNum', title:'有效激活数量', sort: true}
  1565. ,{field:'UserApplyNum', title:'创客申请数量', sort: true}
  1566. ,{field:'Remark', title:'备注', sort: true}
  1567. ,{field:'CreateDate', title:'创建时间', sort: true}
  1568. ]];
  1569. //创客收益排行
  1570. var UserBalanceTop_cols = [[
  1571. { type: 'checkbox', fixed: 'left' }
  1572. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1573. ,{field:'UserId', title:'创客', sort: true}
  1574. ,{field:'Balance', title:'收益金额', sort: true}
  1575. ,{field:'CreateDate', title:'创建时间', sort: true}
  1576. ]];
  1577. //特训营团队排行榜
  1578. var TeamDayTop_cols = [[
  1579. { type: 'checkbox', fixed: 'left' }
  1580. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1581. ,{field:'TopUserId', title:'顶级创客', sort: true}
  1582. ,{field:'TeamId', title:'队伍', sort: true}
  1583. ,{field:'TeamUserId', title:'团队长创客', sort: true}
  1584. ,{field:'TeamStartDate', title:'队伍开始时间', sort: true}
  1585. ,{field:'TeamEndDate', title:'队伍结束时间', sort: true}
  1586. ,{field:'TeamActMerNum', title:'队伍直营激活商户数', sort: true}
  1587. ]];
  1588. //创客职级信息
  1589. var UserRank_cols = [[
  1590. { type: 'checkbox', fixed: 'left' }
  1591. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1592. ,{field:'UserId', title:'创客', sort: true}
  1593. ,{field:'Rank', title:'当前等级', sort: true}
  1594. ,{field:'WhiteRank', title:'白名单等级', sort: true}
  1595. ,{field:'NextRank', title:'下个等级', sort: true}
  1596. ,{field:'TradeAmt', title:'团队交易总额', sort: true}
  1597. ,{field:'OperateDate', title:'操作时间', sort: true}
  1598. ,{field:'CreateDate', title:'创建时间', sort: true}
  1599. ]];
  1600. //机具损坏换新申请
  1601. var MachineRenew_cols = [[
  1602. { type: 'checkbox', fixed: 'left' }
  1603. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1604. ,{field:'ApplyNo', title:'机具售后换新申请订单号', sort: true}
  1605. ,{field:'ApplyDate', title:'机具售后换新申请时间', sort: true}
  1606. ,{field:'UserId', title:'创客', sort: true}
  1607. ,{field:'DamagedBrandId', title:'损坏的机具产品类型', sort: true}
  1608. ,{field:'DamagedSnNo', title:'创客损坏的机具SN', sort: true}
  1609. ,{field:'DamagedSnType', title:'损坏的机具SN机具类型', sort: true}
  1610. ,{field:'ReplaceBrandId', title:'替换的机具产品类型', sort: true}
  1611. ,{field:'ReplaceSnNo', title:'创客机具替换SN', sort: true}
  1612. ,{field:'ReplaceSnType', title:'替换的机具SN机具类型', sort: true}
  1613. ,{field:'DeliverBrandId', title:'仓库换新发货的机具产品类型', sort: true}
  1614. ,{field:'DeliverSnNo', title:'仓库换新发货SN', sort: true}
  1615. ,{field:'DemandDesc', title:'售后换新机具处理需求描述', sort: true}
  1616. ,{field:'audit_status', title:'审核状态', sort: true}
  1617. ,{field:'AuditDesc', title:'创客机具售后换新审核描述', sort: true}
  1618. ,{field:'AuditDate', title:'审核时间', sort: true}
  1619. ,{field:'CreateDate', title:'创建时间', sort: true}
  1620. ]];
  1621. //创客姓名为主键的关联表
  1622. var UserForRealName_cols = [[
  1623. { type: 'checkbox', fixed: 'left' }
  1624. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1625. ]];
  1626. //创客编号为主键的关联表
  1627. var UserForMakerCode_cols = [[
  1628. { type: 'checkbox', fixed: 'left' }
  1629. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1630. ]];
  1631. //仓库名称为主键的关联表
  1632. var StoreForName_cols = [[
  1633. { type: 'checkbox', fixed: 'left' }
  1634. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1635. ]];
  1636. //仓库编号为主键的关联表
  1637. var StoreForCode_cols = [[
  1638. { type: 'checkbox', fixed: 'left' }
  1639. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1640. ]];
  1641. //商户姓名为主键的关联表
  1642. var MerchantForName_cols = [[
  1643. { type: 'checkbox', fixed: 'left' }
  1644. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1645. ]];
  1646. //商户编号为主键的关联表
  1647. var MerchantForCode_cols = [[
  1648. { type: 'checkbox', fixed: 'left' }
  1649. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1650. ]];
  1651. //活动名称为主键的关联表
  1652. var ProfitObjectsActivesForId_cols = [[
  1653. { type: 'checkbox', fixed: 'left' }
  1654. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1655. ]];
  1656. //团队编号为主键的关联表
  1657. var TeamApplyForTeamNo_cols = [[
  1658. { type: 'checkbox', fixed: 'left' }
  1659. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1660. ]];
  1661. //团队名称为主键的关联表
  1662. var TeamApplyForTeamName_cols = [[
  1663. { type: 'checkbox', fixed: 'left' }
  1664. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1665. ]];
  1666. //特训营个人排行榜
  1667. var TeamPersonDayTop_cols = [[
  1668. { type: 'checkbox', fixed: 'left' }
  1669. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1670. ,{field:'UserId', title:'创客', sort: true}
  1671. ,{field:'TopUserId', title:'顶级创客', sort: true}
  1672. ,{field:'TeamId', title:'队伍', sort: true}
  1673. ,{field:'TeamUserId', title:'团队长创客', sort: true}
  1674. ,{field:'TeamStartDate', title:'队伍开始时间', sort: true}
  1675. ,{field:'TeamEndDate', title:'队伍结束时间', sort: true}
  1676. ,{field:'ActMerNum', title:'团员直营激活商户数', sort: true}
  1677. ]];
  1678. //首页快捷入口
  1679. var IndexIconList_cols = [[
  1680. { type: 'checkbox', fixed: 'left' }
  1681. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1682. ,{field:'Title', title:'标题', sort: true}
  1683. ,{field:'Url', title:'跳转地址', sort: true}
  1684. ]];
  1685. //个人中心常用工具
  1686. var UserCenterIconList_cols = [[
  1687. { type: 'checkbox', fixed: 'left' }
  1688. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1689. ,{field:'Title', title:'标题', sort: true}
  1690. ,{field:'Url', title:'跳转地址', sort: true}
  1691. ]];
  1692. //创客分润规则
  1693. var UserProfit_cols = [[
  1694. { type: 'checkbox', fixed: 'left' }
  1695. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1696. ,{field:'UserId', title:'创客', sort: true}
  1697. ,{field:'BrandId', title:'品牌', sort: true}
  1698. ,{field:'CardType', title:'交易卡类型', sort: true}
  1699. ,{field:'ProfitRate', title:'创客预设分润比例', sort: true}
  1700. ,{field:'ProfitPercent', title:'创客预设分润百分比', sort: true}
  1701. ,{field:'AddOrSubRate', title:'浮动空间', sort: true}
  1702. ,{field:'ProfitRateBase', title:'分润比例基数', sort: true}
  1703. ,{field:'Remark', title:'备注', sort: true}
  1704. ,{field:'TopUserId', title:'顶级创客', sort: true}
  1705. ,{field:'HelpAddOrSubRate', title:'扶持期浮动空间', sort: true}
  1706. ,{field:'HelpProfitPercent', title:'扶持期创客预设分润百分比', sort: true}
  1707. ,{field:'HelpProfitRate', title:'扶持期创客预设分润比例', sort: true}
  1708. ,{field:'HelpProfitRateBase', title:'扶持期分润比例基数', sort: true}
  1709. ]];
  1710. //快联盟操作视频分类
  1711. var AppVideo_cols = [[
  1712. { type: 'checkbox', fixed: 'left' }
  1713. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1714. ,{field:'Name', title:'名称', sort: true}
  1715. ]];
  1716. //快联盟操作视频列表
  1717. var AppVideoList_cols = [[
  1718. { type: 'checkbox', fixed: 'left' }
  1719. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1720. ,{field:'Title', title:'标题', sort: true}
  1721. ,{field:'VideoId', title:'视频分类Id', sort: true}
  1722. ]];
  1723. //创客登录记录
  1724. var UserLoginRecord_cols = [[
  1725. { type: 'checkbox', fixed: 'left' }
  1726. , { field: 'Id', fixed: 'left', title: 'ID', width: 80, sort: true, unresize: true }
  1727. ,{field:'UserId', title:'创客', sort: true}
  1728. ,{field:'Kind', title:'类别', sort: true}
  1729. ,{field:'CreateDate', title:'创建时间', sort: true}
  1730. ]];