order.php 32 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049
  1. <?php
  2. $role = function()
  3. {
  4. $array = array();
  5. $data = Dever::load('setting/role-state');
  6. if($data)
  7. {
  8. $array += $data;
  9. }
  10. return $array;
  11. };
  12. $source_id = function()
  13. {
  14. $array = array
  15. (
  16. -1 => array
  17. (
  18. 'id' => '-1',
  19. 'name' => '无来源',
  20. ),
  21. );
  22. $data = Dever::load('setting/source-state');
  23. if($data)
  24. {
  25. $array += $data;
  26. }
  27. return $array;
  28. };
  29. $status = array
  30. (
  31. -2 => array('name' => '待签名', 'style' => 'font-weight:bold;color:#00FFFF'),
  32. 1 => array('name' => '待业务初审', 'style' => 'font-weight:bold;color:#436EEE'),
  33. 2 => array('name' => '待财务终审', 'style' => 'font-weight:bold;color:#003366'),
  34. 3 => array('name' => '待权益发放', 'style' => 'font-weight:bold;color:#993333'),
  35. 4 => array('name' => '已完成', 'style' => 'font-weight:bold;color:green'),
  36. 5 => array('name' => '驳回', 'style' => 'font-weight:bold;color:#CD3700'),
  37. 6 => array('name' => '挂起', 'style' => 'font-weight:bold;color:#436EEE'),
  38. 7 => array('name' => '关闭', 'style' => 'font-weight:bold;color:#000000'),
  39. );
  40. $pay_status = array
  41. (
  42. 1 => '待支付',
  43. 2 => '已支付',
  44. 3 => '已退款',
  45. );
  46. $goods_status = array
  47. (
  48. 1 => array('name' => '未发放', 'style' => 'font-weight:bold;color:#436EEE'),
  49. 2 => array('name' => '无权益', 'style' => 'font-weight:bold;'),
  50. 3 => array('name' => '已发放', 'style' => 'font-weight:bold;color:green'),
  51. );
  52. $type = array
  53. (
  54. 1 => '个人',
  55. 2 => '公司',
  56. );
  57. $pay_type = array
  58. (
  59. 1 => '在线支付',
  60. 2 => '汇款',
  61. 3 => '个人转账',
  62. );
  63. $get_type = array
  64. (
  65. 1 => '购买',
  66. 2 => '赠送',
  67. );
  68. $level = function()
  69. {
  70. $array = array
  71. (
  72. -1 => array
  73. (
  74. 'id' => -1,
  75. 'name' => '普通',
  76. ),
  77. );
  78. $data = Dever::load('setting/level-state');
  79. if($data)
  80. {
  81. $array += $data;
  82. }
  83. return $array;
  84. };
  85. $import = array
  86. (
  87. 1 => '最新系统',
  88. 2 => 'v2旧系统导入',
  89. 3 => 'v1旧系统导入',
  90. );
  91. $order_type = array
  92. (
  93. 1 => '新购',
  94. 2 => '升级',
  95. );
  96. $button = array();
  97. $parent_mid = Dever::input('search_option_parent_mid');
  98. $mid = Dever::input('search_option_mid');
  99. $pmid = '';
  100. if ($parent_mid) {
  101. $pmid = $parent_mid;
  102. }
  103. if ($mid) {
  104. $pmid = $mid;
  105. }
  106. if ($pmid) {
  107. $button = array
  108. (
  109. '返回上一页' => array('location', 'l=project/database/list&project=agent&table=member_area&page_type=1&mid=' . $pmid),
  110. );
  111. }else{
  112. if(Dever::load('manage/auth')->checkFunc('agent.order', 'editorderout', '数据导出')){
  113. $button['数据导出'] = array('excel', 'agent/lib/order.out_order');
  114. }
  115. }
  116. # 权限设置 1是查看详情、2是城市数据统计
  117. $search_auth = Dever::input('search_option_dever_auth', 1);
  118. $list_button = array();
  119. if($search_auth == 1){
  120. $list_button['list'] = array('查看详情', '"order_process&project=agent&order_id={id}&page_type=1&[refer]"');
  121. if(Dever::load('manage/auth')->checkFunc('agent.order', 'editSoftorderout', '软件服务费数据导出')){
  122. $button['软件服务费数据导出'] = array('excel', 'agent/lib/order.out_softorder');
  123. }
  124. }
  125. $invite_type = array
  126. (
  127. 1 => '邀请人',
  128. 2 => '来源',
  129. );
  130. # id小于50000为导入的数据
  131. return array
  132. (
  133. # 表名
  134. 'name' => 'order',
  135. # 显示给用户看的名称
  136. 'lang' => '代理商订单',
  137. 'auto' => 50000,
  138. 'set' => array
  139. (
  140. 'status' => $status,
  141. 'pay_status' => $pay_status,
  142. 'goods_status' => $goods_status,
  143. 'type' => $type,
  144. 'pay_type' => $pay_type,
  145. 'order_type' => $order_type,
  146. ),
  147. 'start' => array
  148. (
  149. 'update' => 'agent/lib/manage.orderUpdateParent',
  150. ),
  151. 'order' => 99,
  152. # 数据结构
  153. 'struct' => array
  154. (
  155. 'id' => array
  156. (
  157. 'type' => 'int-11',
  158. 'name' => 'ID',
  159. 'default' => '',
  160. 'desc' => '',
  161. 'match' => 'is_numeric',
  162. 'search' => 'order',
  163. //'list' => true,
  164. ),
  165. 'mid' => array
  166. (
  167. 'type' => 'int-11',
  168. 'name' => '代理商姓名/手机号',
  169. 'default' => '-1',
  170. 'desc' => '代理商',
  171. 'match' => 'is_string',
  172. 'update' => 'text',
  173. 'search' => array
  174. (
  175. 'api' => 'agent/member-getSearch',
  176. 'col' => 'col',
  177. 'result' => 'id',
  178. 'search' => 'mid',
  179. ),
  180. 'list_name' => '代理商信息',
  181. 'list' => $search_auth == 1 ? 'Dever::load("agent/lib/member.getOne", {mid}, "agent/member", true)' : false,
  182. 'list_order' => 3,
  183. ),
  184. 'order_num' => array
  185. (
  186. 'type' => 'varchar-100',
  187. 'name' => '订单号',
  188. 'default' => '',
  189. 'desc' => '订单号',
  190. 'match' => 'is_string',
  191. 'update' => 'text',
  192. //'search' => 'fulltext',
  193. //'list' => true,
  194. //'list_order' => 1,
  195. ),
  196. 'order_type' => array
  197. (
  198. 'type' => 'tinyint-1',
  199. 'name' => '订单类型',
  200. 'default' => '1',
  201. 'desc' => '订单类型',
  202. 'match' => 'is_numeric',
  203. 'option' => $order_type,
  204. ),
  205. 'mobile' => array
  206. (
  207. 'type' => 'bigint-11',
  208. 'name' => '手机号',
  209. 'default' => '',
  210. 'desc' => '请输入手机号',
  211. 'match' => Dever::rule('mobile'),
  212. 'update' => 'text',
  213. //'search' => 'fulltext',
  214. 'list' => $search_auth == 2 ? true : false,
  215. 'list_order' => 2,
  216. ),
  217. 'invite_type' => array
  218. (
  219. 'type' => 'tinyint-1',
  220. 'name' => '邀请类型',
  221. 'default' => '1',
  222. 'desc' => '邀请类型',
  223. 'match' => 'is_numeric',
  224. //'search' => 'select',
  225. 'update' => 'radio',
  226. 'option' => $invite_type,
  227. //'list' => true,
  228. //'list_order' => 7,
  229. 'control' => 'invite_type',
  230. ),
  231. 'parent_code' => array
  232. (
  233. 'type' => 'varchar-100',
  234. 'name' => '上级邀请码',
  235. 'default' => '',
  236. 'desc' => '上级邀请码',
  237. 'match' => 'is_string',
  238. 'update' => 'text',
  239. # 绑定js脚本,更新时使用,第一个参数是执行的方式,第二个参数执行的方法,第三个参数是传值。
  240. 'bind' => array('onblur', 'loading', array('url' => Dever::url("lib/member.search", 'agent'))),
  241. 'show' => 'invite_type=1',
  242. ),
  243. 'parent_mid' => array
  244. (
  245. 'type' => 'int-11',
  246. 'name' => '上级姓名/手机号',
  247. 'default' => '-1',
  248. 'desc' => '邀请人',
  249. 'match' => 'is_string',
  250. //'update' => 'text',
  251. 'search' => array
  252. (
  253. 'api' => 'agent/member-getSearch',
  254. 'col' => 'col',
  255. 'result' => 'id',
  256. 'search' => 'parent_mid',
  257. ),
  258. 'list_name' => '上级信息',
  259. 'list' => $search_auth == 1 ? 'Dever::load("agent/lib/member.getOne", {parent_mid})' : false,
  260. ),
  261. 'source_id' => array
  262. (
  263. 'type' => 'int-11',
  264. 'name' => '注册来源',
  265. 'default' => '-1',
  266. 'desc' => '注册来源',
  267. 'match' => 'is_numeric',
  268. 'search' => 'select',
  269. 'update' => 'radio',
  270. 'option' => $source_id,
  271. // 'list' => true,
  272. // 'list_order' => 5,
  273. // 'show' => 'invite_type=2',
  274. ),
  275. 'name' => array
  276. (
  277. 'type' => 'varchar-100',
  278. 'name' => '姓名',
  279. 'default' => '',
  280. 'desc' => '姓名',
  281. 'match' => 'is_string',
  282. 'update' => 'text',
  283. //'search' => 'fulltext',
  284. 'list' => $search_auth == 2 ? true : false,
  285. 'list_order' => 1,
  286. ),
  287. 'role' => array
  288. (
  289. 'type' => 'int-11',
  290. 'name' => '代理角色',
  291. 'default' => '',
  292. 'desc' => '代理角色',
  293. 'match' => 'is_numeric',
  294. 'search' => 'select',
  295. 'update' => 'select',
  296. 'option' => $role,
  297. 'list' => $search_auth == 2 ? true : false,
  298. 'list_order' => 3,
  299. ),
  300. 'area' => array
  301. (
  302. 'type' => 'varchar-500',
  303. 'name' => '代理区域',
  304. 'default' => '',
  305. 'desc' => '代理区域',
  306. 'match' => 'option',
  307. 'search' => 'linkage',
  308. 'update' => 'linkage',
  309. 'option' => Dever::url('api.get?level_total=4', 'area'),
  310. 'list' => $search_auth == 2 ? 'Dever::load("agent/lib/order.getArea", {id})' : false,
  311. 'list_order' => 3,
  312. ),
  313. 'desc' => array
  314. (
  315. 'type' => 'varchar-600',
  316. 'name' => '付款备注',
  317. 'default' => '',
  318. 'desc' => '付款备注',
  319. 'match' => 'is_string',
  320. 'update' => 'text',
  321. ),
  322. 'f_price' => array
  323. (
  324. 'type' => 'decimal-11,2',
  325. 'name' => '原价',
  326. 'default' => '0',
  327. 'desc' => '原价',
  328. 'match' => 'option',
  329. 'update' => 'text',
  330. ),
  331. 'price' => array
  332. (
  333. 'type' => 'decimal-11,2',
  334. 'name' => '金额',
  335. 'default' => '0',
  336. 'desc' => '金额',
  337. 'match' => 'option',
  338. 'update' => 'text',
  339. // 'list' => true,
  340. //'list_name' => '应付金额<br />实付金额<br />代理费<br />软件服务费<br />',
  341. 'list_name' => $search_auth == 1 ? '实付金额' : '总销售额',
  342. 'list' => true,
  343. // 'list' =>'Dever::load("agent/lib/order.set_price", {id})',
  344. 'list_order' => 100,
  345. ),
  346. 'pay_type' => array
  347. (
  348. 'type' => 'tinyint-1',
  349. 'name' => '支付方式',
  350. 'default' => '1',
  351. 'desc' => '支付方式',
  352. 'match' => 'is_numeric',
  353. //'search' => 'select',
  354. //'update' => 'select',
  355. 'option' => $pay_type,
  356. //'list' => true,
  357. //'list_order' => 7,
  358. ),
  359. 'pay_pic' => array
  360. (
  361. 'type' => 'text-255',
  362. 'name' => '打款凭证',
  363. 'default' => '',
  364. 'desc' => '打款凭证',
  365. 'match' => 'option',
  366. 'update' => 'images',
  367. 'key' => '1',
  368. //'place' => '150',
  369. ),
  370. 'pay_price' => array
  371. (
  372. 'type' => 'decimal-11,2',
  373. 'name' => '交款金额',
  374. 'default' => '0',
  375. 'desc' => '交款金额',
  376. 'match' => 'option',
  377. 'update' => 'text',
  378. ),
  379. 'option_price' => array
  380. (
  381. 'type' => 'decimal-11,2',
  382. 'name' => '赠送期权价值',
  383. 'default' => '0',
  384. 'desc' => '金额',
  385. 'match' => 'option',
  386. 'update' => 'text',
  387. // 'value' => Dever::input('soft_price', '0'),
  388. // 'show' => 'cstatus=2',
  389. ),
  390. 'bank_id' => array
  391. (
  392. 'type' => 'int-11',
  393. 'name' => '所属银行',
  394. 'default' => '',
  395. 'desc' => '所属银行',
  396. 'match' => 'is_numeric',
  397. ),
  398. 'bank_card' => array
  399. (
  400. 'type' => 'int-11',
  401. 'name' => '银行卡号',
  402. 'default' => '',
  403. 'desc' => '银行卡号',
  404. 'match' => 'is_numeric',
  405. ),
  406. 'type' => array
  407. (
  408. 'type' => 'tinyint-1',
  409. 'name' => '类型',
  410. 'default' => '1',
  411. 'desc' => '类型',
  412. 'match' => 'is_numeric',
  413. 'option' => $type,
  414. 'update' => 'radio',
  415. 'control' => 'type',
  416. ),
  417. 'sign' => array
  418. (
  419. 'type' => 'varchar-150',
  420. 'name' => '手写签名',
  421. 'default' => '',
  422. 'desc' => '手写签名',
  423. 'match' => 'option',
  424. 'update' => 'image',
  425. 'key' => '7',
  426. ),
  427. 'idcard' => array
  428. (
  429. 'type' => 'varchar-100',
  430. 'name' => '身份证号码',
  431. 'default' => '',
  432. 'desc' => '身份证号码',
  433. 'match' => 'is_string',
  434. 'match' => Dever::rule('idcard'),
  435. 'update' => 'text',
  436. //'search' => 'fulltext',
  437. ),
  438. 'idcard_front' => array
  439. (
  440. 'type' => 'varchar-150',
  441. 'name' => '身份证正面',
  442. 'default' => '',
  443. 'desc' => '身份证正面',
  444. 'match' => 'option',
  445. 'update' => 'image',
  446. 'key' => '8',
  447. //'place' => '660*660',
  448. ),
  449. 'idcard_back' => array
  450. (
  451. 'type' => 'varchar-150',
  452. 'name' => '身份证背面',
  453. 'default' => '',
  454. 'desc' => '身份证背面',
  455. 'match' => 'option',
  456. 'update' => 'image',
  457. 'key' => '8',
  458. //'place' => '660*660',
  459. ),
  460. 'company_name' => array
  461. (
  462. 'type' => 'varchar-100',
  463. 'name' => '公司名称',
  464. 'default' => '',
  465. 'desc' => '公司名称',
  466. 'match' => 'is_string',
  467. 'update' => 'text',
  468. //'search' => 'fulltext',
  469. //'list' => true,
  470. 'show' => 'type=2',
  471. ),
  472. 'company_pic' => array
  473. (
  474. 'type' => 'varchar-150',
  475. 'name' => '营业执照',
  476. 'default' => '',
  477. 'desc' => '营业执照',
  478. 'match' => 'option',
  479. 'update' => 'image',
  480. 'key' => '8',
  481. //'place' => '660*660',
  482. 'show' => 'type=2',
  483. ),
  484. 'company_number' => array
  485. (
  486. 'type' => 'varchar-80',
  487. 'name' => '营业执照号码',
  488. 'default' => '',
  489. 'desc' => '营业执照号码',
  490. 'match' => 'is_string',
  491. 'update' => 'text',
  492. 'show' => 'type=2',
  493. ),
  494. 'address' => array
  495. (
  496. 'type' => 'varchar-800',
  497. 'name' => '地址',
  498. 'default' => '',
  499. 'desc' => '地址',
  500. 'match' => 'is_string',
  501. 'update' => 'text',
  502. ),
  503. 'audit_desc' => array
  504. (
  505. 'type' => 'varchar-400',
  506. 'name' => '审核备注-从order_process中同步过来',
  507. 'default' => '',
  508. 'desc' => '审核备注',
  509. 'match' => 'is_string',
  510. //'update' => 'textarea',
  511. ),
  512. 'admin_desc' => array
  513. (
  514. 'type' => 'varchar-800',
  515. 'name' => '管理员备注',
  516. 'default' => '',
  517. 'desc' => '管理员备注',
  518. 'match' => 'is_string',
  519. 'update' => 'textarea',
  520. ),
  521. 'status' => array
  522. (
  523. 'type' => 'tinyint-1',
  524. 'name' => '订单状态',
  525. 'default' => '1',
  526. 'desc' => '状态',
  527. 'match' => 'is_numeric',
  528. 'option' => $status,
  529. 'search' => 'select',
  530. 'list' => $search_auth == 1 ? true : false,
  531. 'list_order' => 8,
  532. ),
  533. 'history_status' => array
  534. (
  535. 'type' => 'tinyint-1',
  536. 'name' => '记录挂起之前的状态',
  537. 'default' => '1',
  538. 'desc' => '状态',
  539. 'match' => 'is_numeric',
  540. 'option' => $status,
  541. ),
  542. 'goods_status' => array
  543. (
  544. 'type' => 'tinyint-1',
  545. 'name' => '权益状态',
  546. 'default' => '1',
  547. 'desc' => '权益状态',
  548. 'match' => 'is_numeric',
  549. 'option' => $goods_status,
  550. 'search' => 'select',
  551. 'list' => $search_auth == 1 ? true : false,
  552. 'list_order' => 9,
  553. ),
  554. 'pay_status' => array
  555. (
  556. 'type' => 'tinyint-1',
  557. 'name' => '支付状态',
  558. 'default' => '1',
  559. 'desc' => '状态',
  560. 'match' => 'is_numeric',
  561. 'option' => $pay_status,
  562. ),
  563. 'get_type' => array
  564. (
  565. 'type' => 'tinyint-1',
  566. 'name' => '获取方式',
  567. 'default' => '1',
  568. 'desc' => '获取方式',
  569. 'match' => 'is_numeric',
  570. 'update' => 'radio',
  571. 'option' => $get_type,
  572. ),
  573. 'agent_cash' => array
  574. (
  575. 'type' => 'decimal-11,2',
  576. 'name' => '代理费',
  577. 'default' => '0',
  578. 'desc' => '代理费',
  579. 'match' => 'option',
  580. 'update' => 'text',
  581. 'list' => $search_auth == 2 ? true : false,
  582. ),
  583. 'soft_cash' => array
  584. (
  585. 'type' => 'decimal-11,2',
  586. 'name' => '软件服务费',
  587. 'default' => '0',
  588. 'desc' => '软件服务费',
  589. 'match' => 'option',
  590. 'update' => 'text',
  591. 'list' => $search_auth == 2 ? '{soft_cash}' : false,
  592. ),
  593. 'goods_cash' => array
  594. (
  595. 'type' => 'decimal-11,2',
  596. 'name' => '商品价值-名额不算,商品价值第一次分配后保持不变',
  597. 'default' => '0',
  598. 'desc' => '商品价值',
  599. 'match' => 'option',
  600. 'update' => 'text',
  601. ),
  602. 'import' => array
  603. (
  604. 'type' => 'tinyint-1',
  605. 'name' => '是否导入',
  606. 'default' => '1',
  607. 'desc' => '是否导入',
  608. 'match' => 'is_numeric',
  609. 'option' => $import,
  610. 'update' => 'radio',
  611. ),
  612. 'dever_auth' => array
  613. (
  614. 'name' => '权限',
  615. 'default' => '',
  616. 'desc' => '类型',
  617. 'match' => 'is_string',
  618. 'search' => 'hidden',
  619. ),
  620. 'state' => array
  621. (
  622. 'type' => 'tinyint-1',
  623. 'name' => '状态',
  624. 'default' => '1',
  625. 'desc' => '请选择状态',
  626. 'match' => 'is_numeric',
  627. ),
  628. 'fdate' => array
  629. (
  630. 'type' => 'int-11',
  631. 'name' => '完成时间',
  632. 'default' => '',
  633. 'match' => 'is_numeric',
  634. 'search' => 'date',
  635. 'desc' => '',
  636. ),
  637. 'udate' => array
  638. (
  639. 'type' => 'int-11',
  640. 'name' => '更新时间',
  641. 'default' => '',
  642. 'match' => 'is_numeric',
  643. 'desc' => '',
  644. 'order' => 'desc',
  645. ),
  646. 'cdate' => array
  647. (
  648. 'type' => 'int-11',
  649. 'name' => '注册时间',
  650. 'match' => array('is_numeric', time()),
  651. 'default' => '',
  652. 'desc' => '',
  653. # 只有insert时才生效
  654. 'insert' => true,
  655. 'search' => 'date',
  656. // 'list' => 'date("Y-m-d H:i:s", {cdate})',
  657. 'list_name' => '注册时间<br />初审时间<br />终审时间<br />完成时间<br />',
  658. 'list' => $search_auth == 1 ? 'Dever::load("agent/lib/order.set_cdate", {id})' : false,
  659. 'list_order' => 200,
  660. ),
  661. ),
  662. 'alter' => array
  663. (
  664. 10 => array
  665. (
  666. array('update', 'price', 'price', 'decimal-11,2 0 实付金额'),
  667. array('update', 'f_price', 'f_price', 'decimal-11,2 0 原价'),
  668. array('update', 'agent_cash', 'agent_cash', 'decimal-11,2 0 代理费'),
  669. array('update', 'soft_cash', 'soft_cash', 'decimal-11,2 0 软件服务费'),
  670. array('update', 'goods_cash', 'goods_cash', 'decimal-11,2 0 商品价值'),
  671. array('update', 'pay_price', 'pay_price', 'decimal-11,2 0 交款金额'),
  672. array('update', 'option_price', 'option_price', 'decimal-11,2 0 赠送期权价值'),
  673. ),
  674. 11 => array
  675. (
  676. array('update', 'pay_pic', 'pay_pic', 'text-255 打款凭证'),
  677. ),
  678. 'version' => 11,
  679. ),
  680. 'manage' => array
  681. (
  682. //'list_table' => 'js',
  683. 'insert' => false,
  684. 'delete' => false,
  685. 'edit' => false,
  686. 'button' => $button,
  687. 'list_button' => $list_button,
  688. // (
  689. // //fast_list
  690. // 'list' => array('查看详情', '"order_process&project=agent&order_id={id}&page_type=1&[refer]"'),
  691. // //'edit' => array('退款', 'status,tk_time,tk_pic,tk_desc,tk_admin,tk_status', '{status} == 6'),
  692. // //'delete' => array('删除', '', '{status} == 1'),
  693. // ),
  694. ),
  695. 'request' => array
  696. (
  697. 'getNew' => array
  698. (
  699. # 匹配的正则或函数 选填项
  700. 'option' => array
  701. (
  702. 'mid' => 'yes',
  703. 'status' => array('yes', 'in'),
  704. 'state' => 1,
  705. ),
  706. 'order' => array('id' => 'desc'),
  707. 'type' => 'one',
  708. 'col' => '*',
  709. ),
  710. 'getTotal' => array
  711. (
  712. # 匹配的正则或函数 选填项
  713. 'option' => array
  714. (
  715. 'mid' => 'yes',
  716. 'status' => array('yes', 'in'),
  717. 'state' => 1,
  718. ),
  719. 'order' => array('id' => 'desc'),
  720. 'type' => 'count',
  721. 'col' => '*',
  722. ),
  723. 'getData' => array
  724. (
  725. # 匹配的正则或函数 选填项
  726. 'option' => array
  727. (
  728. 'mid' => 'yes',
  729. 'status' => array('yes', 'in'),
  730. 'state' => 1,
  731. ),
  732. 'order' => array('id' => 'desc'),
  733. 'page' => array(10, 'list'),
  734. 'type' => 'all',
  735. 'col' => '*',
  736. ),
  737. # 获取订单数量
  738. 'getNum' => array
  739. (
  740. # 匹配的正则或函数 选填项
  741. 'option' => array
  742. (
  743. 'start' => array('yes-cdate', '>='),
  744. 'end' => array('yes-cdate', '<='),
  745. 'fstart' => array('yes-fdate', '>='),
  746. 'fend' => array('yes-fdate', '<='),
  747. 'status' => array('yes', 'in'),
  748. 'state' => 1,
  749. ),
  750. 'type' => 'count',
  751. 'col' => '*',
  752. ),
  753. # 获取订单数量
  754. 'getCash' => array
  755. (
  756. # 匹配的正则或函数 选填项
  757. 'option' => array
  758. (
  759. 'start' => array('yes-cdate', '>='),
  760. 'end' => array('yes-cdate', '<='),
  761. 'fstart' => array('yes-fdate', '>='),
  762. 'fend' => array('yes-fdate', '<='),
  763. 'status' => array('yes', 'in'),
  764. 'state' => 1,
  765. ),
  766. 'type' => 'one',
  767. 'col' => 'sum(price) as total',
  768. ),
  769. 'getDailiCash' => array
  770. (
  771. # 匹配的正则或函数 选填项
  772. 'option' => array
  773. (
  774. 'start' => array('yes-cdate', '>='),
  775. 'end' => array('yes-cdate', '<='),
  776. 'fstart' => array('yes-fdate', '>='),
  777. 'fend' => array('yes-fdate', '<='),
  778. 'status' => array('yes', 'in'),
  779. 'state' => 1,
  780. ),
  781. 'type' => 'one',
  782. 'col' => 'sum(agent_cash) as total',
  783. ),
  784. #期权价值
  785. 'getOptionPrice' => array
  786. (
  787. # 匹配的正则或函数 选填项
  788. 'option' => array
  789. (
  790. 'start' => array('yes-cdate', '>='),
  791. 'end' => array('yes-cdate', '<='),
  792. 'fstart' => array('yes-fdate', '>='),
  793. 'fend' => array('yes-fdate', '<='),
  794. 'status' => array('yes', 'in'),
  795. 'role' => 'yes',
  796. 'state' => 1,
  797. ),
  798. 'type' => 'one',
  799. 'col' => 'sum(option_price) as total',
  800. ),
  801. 'getSoftCash' => array
  802. (
  803. # 匹配的正则或函数 选填项
  804. 'option' => array
  805. (
  806. 'start' => array('yes-cdate', '>='),
  807. 'end' => array('yes-cdate', '<='),
  808. 'fstart' => array('yes-fdate', '>='),
  809. 'fend' => array('yes-fdate', '<='),
  810. 'status' => array('yes', 'in'),
  811. 'role' => 'yes',
  812. 'state' => 1,
  813. ),
  814. 'type' => 'one',
  815. 'col' => 'sum(soft_cash) as total',
  816. ),
  817. 'getSoftNoCash' => array
  818. (
  819. # 匹配的正则或函数 选填项
  820. 'option' => array
  821. (
  822. 'fstart' => array('yes-cdate', '>='),
  823. 'fend' => array('yes-cdate', '<='),
  824. 'status' => array('yes', '!='),
  825. 'state' => 1,
  826. ),
  827. 'type' => 'one',
  828. 'col' => 'sum(soft_cash) as total',
  829. ),
  830. 'getSoftNum' => array
  831. (
  832. # 匹配的正则或函数 选填项
  833. 'option' => array
  834. (
  835. 'fstart' => array('yes-fdate', '>='),
  836. 'fend' => array('yes-fdate', '<='),
  837. 'soft_cash' => array('yes', '>='),
  838. 'status' => array('yes','in'),
  839. 'state' => 1,
  840. ),
  841. 'type' => 'count',
  842. 'col' => '*',
  843. ),
  844. 'getSoftNoNum' => array
  845. (
  846. # 匹配的正则或函数 选填项
  847. 'option' => array
  848. (
  849. 'fstart' => array('yes-cdate', '>='),
  850. 'fend' => array('yes-cdate', '<='),
  851. 'soft_cash' => array('yes', '>='),
  852. 'status' => array('yes','!='),
  853. 'state' => 1,
  854. ),
  855. 'type' => 'count',
  856. 'col' => '*',
  857. ),
  858. 'getGoodsCash' => array
  859. (
  860. # 匹配的正则或函数 选填项
  861. 'option' => array
  862. (
  863. 'start' => array('yes-cdate', '>='),
  864. 'end' => array('yes-cdate', '<='),
  865. 'fstart' => array('yes-fdate', '>='),
  866. 'fend' => array('yes-fdate', '<='),
  867. 'status' => array('yes', 'in'),
  868. 'state' => 1,
  869. ),
  870. 'type' => 'one',
  871. 'col' => 'sum(goods_cash) as total',
  872. ),
  873. 'getFindOne' => array
  874. (
  875. # 匹配的正则或函数 选填项
  876. 'option' => array
  877. (
  878. 'id' => array('yes','!='),
  879. 'mid' => 'yes',
  880. 'order_type' => 'yes',
  881. 'state' => 1,
  882. ),
  883. 'type' => 'one',
  884. 'order' => array('cdate' => 'desc'),
  885. 'col' => '*',
  886. ),
  887. 'getPrice' => array
  888. (
  889. # 匹配的正则或函数 选填项
  890. 'option' => array
  891. (
  892. 'mid' => 'yes',
  893. 'status' => 4,
  894. 'state' => 1,
  895. ),
  896. 'type' => 'one',
  897. 'col' => 'sum(price) as total',
  898. ),
  899. 'getCount' => array
  900. (
  901. # 匹配的正则或函数 选填项
  902. 'option' => array
  903. (
  904. 'start' => array('yes-cdate','>='),
  905. 'end' => array('yes-cdate','<='),
  906. 'mid' => 'yes',
  907. 'state' => 1,
  908. ),
  909. 'type' => 'one',
  910. 'col' => 'sum(price) as total',
  911. ),
  912. 'getVCount' => array
  913. (
  914. # 匹配的正则或函数 选填项
  915. 'option' => array
  916. (
  917. 'start' => array('yes-cdate','>='),
  918. 'end' => array('yes-cdate','<='),
  919. 'mid' => 'yes',
  920. 'role' => array('yes','in'),
  921. 'state' => 1,
  922. ),
  923. 'type' => 'one',
  924. 'col' => 'sum(price) as total',
  925. ),
  926. 'getExcelAll' => array
  927. (
  928. # 匹配的正则或函数 选填项
  929. 'option' => array
  930. (
  931. 'start' => array('yes-cdate', '>='),
  932. 'end' => array('yes-cdate', '<='),
  933. 'fstart' => array('yes-fdate', '>='),
  934. 'fend' => array('yes-fdate', '<='),
  935. 'status' => array('yes', 'in'),
  936. 'state' => 1,
  937. ),
  938. 'type' => 'all',
  939. 'col' => '*',
  940. ),
  941. 'getSum' => array
  942. (
  943. # 匹配的正则或函数 选填项
  944. 'option' => array
  945. (
  946. 'start' => array('yes-fdate', '>='),
  947. 'end' => array('yes-fdate', '<='),
  948. 'fstart' => array('yes-fdate', '>='),
  949. 'fend' => array('yes-fdate', '<='),
  950. 'status' => array('yes', 'in'),
  951. 'role' => 'yes',
  952. 'state' => 1,
  953. ),
  954. 'type' => 'one',
  955. 'col' => 'sum(price) as total',
  956. ),
  957. 'getAll' => array
  958. (
  959. # 匹配的正则或函数 选填项
  960. 'option' => array
  961. (
  962. 'start' => array('yes-fdate','>='),
  963. 'end' => array('yes-fdate','<='),
  964. 'mid' => 'yes',
  965. 'area' => array('yes','in'),
  966. 'role' => array('yes','in'),
  967. 'state' => 1,
  968. ),
  969. 'type' => 'all',
  970. 'page' => array(20,'list'),
  971. 'col' => 'id,mid,name,mobile,idcard,soft_cash,option_price,price,area,role,agent_cash',
  972. ),
  973. ),
  974. );