info.php 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618
  1. <?php
  2. $cate = function()
  3. {
  4. $array = array();
  5. $data = Dever::db('work/q_cate')->state();
  6. if($data)
  7. {
  8. $array += $data;
  9. }
  10. return $array;
  11. };
  12. $branch = function()
  13. {
  14. $array = array();
  15. $data = Dever::db('work/branch')->state();
  16. if($data)
  17. {
  18. $array += $data;
  19. }
  20. return $array;
  21. };
  22. $priority = function()
  23. {
  24. $array = array();
  25. $data = Dever::db('work/priority')->state();
  26. if($data)
  27. {
  28. foreach ($data as $k => $v) {
  29. $data[$k]['style'] = 'color:'.$v['color'];
  30. }
  31. $array += $data;
  32. }
  33. return $array;
  34. };
  35. $source = function()
  36. {
  37. $array = array();
  38. $data = Dever::db('work/q_source')->state();
  39. if($data)
  40. {
  41. $array += $data;
  42. }
  43. return $array;
  44. };
  45. $question = function()
  46. {
  47. $array = array();
  48. $data = Dever::db('work/question')->state();
  49. if($data)
  50. {
  51. $array += $data;
  52. }
  53. return $array;
  54. };
  55. $product = function()
  56. {
  57. $array = array();
  58. $data = Dever::db('work/product')->state();
  59. if($data)
  60. {
  61. $array += $data;
  62. }
  63. return $array;
  64. };
  65. $status = array
  66. (
  67. // 1 => '全部',
  68. 1 => '待处理',
  69. 2 => '处理中',
  70. 3 => '完成关闭',
  71. 4 => '取消关闭',
  72. );
  73. $admin = Dever::load("manage/auth.info");
  74. $admin_id = '';
  75. if ($admin) {
  76. $admin_id = $admin['id'];
  77. }
  78. #工单列表是1,我的工单列表2
  79. $search_auth = Dever::input('search_option_dever_auth', 1);
  80. $list_button = array();
  81. $list_button['location'] = array('查看详情',Dever::url('lib/appoint.show','work'));
  82. $list_button ['fast_add'] = array('指派工单','appoint&search_option_info_id={id}','{status}<3');
  83. $data = array();
  84. $insert = true;
  85. // $company = Dever::load('manage/company.get');
  86. if ($search_auth == 2) {
  87. $insert = false;
  88. $audit_admin = Dever::setInput('search_option_col', $admin_id);
  89. $data[]= array('待我处理',function() use ($admin_id) {return Dever::load('work/lib/manage')->getTotal($admin_id,'1,2');}, 'search_option_dever_auth=2&search_option_status=1,2&search_option_appoint_id=' . $admin_id);
  90. $data[]= array('处理完成',function() use($admin_id) {return Dever::load('work/lib/manage')->getTotal($admin_id,'3,4');}, 'search_option_dever_auth=2&search_option_status=3,4&search_option_fpeople=' . $admin_id);
  91. $data[]= array('我创建的',function() use($admin_id) {return Dever::load('work/lib/manage')->getTotal($admin_id,false);}, 'search_option_dever_auth=2&search_option_state=1&search_option_audit_admin=' . $admin_id);
  92. $search_ids ='';
  93. $data[]= array('和我相关的',function() use($admin_id)
  94. {
  95. $search_info = Dever::db('work/info_log')->getmyAll(array('admin_id'=>$admin_id,'state'=>1));
  96. if ($search_info) {
  97. $search_ids = implode(',',array_keys($search_info));
  98. }
  99. return count($search_info);}, 'search_option_dever_auth=2&search_option_state=1&search_option_ids=' . $search_ids);
  100. }
  101. $button = array();
  102. if ($search_auth == 1) {
  103. $button['回调界面'] = array('location',Dever::url('lib/appoint.callback','work'));
  104. // $button['电话回调界面'] = array('location',Dever::url('lib/appoint.callback','work'));
  105. }
  106. $excel = false;
  107. if (Dever::load('manage/auth')->checkFunc('work.info', 'infoedit', '数据导出')) {
  108. $excel[] = array('数据导出', '工单列表数据导出', 'work/lib/manage.out_info');
  109. }
  110. return array
  111. (
  112. # 表名
  113. 'name' => 'info',
  114. # 显示给用户看的名称
  115. 'lang' => '发起新工单',
  116. # 后台菜单排序
  117. 'order' => 100,
  118. // 'menu' => false,
  119. // 'auto' => 100000,
  120. 'start' => array
  121. (
  122. 'insert' => 'work/lib/manage.insertInfo',
  123. // 'update' => 'work/lib/manage.insertInfo',
  124. ),
  125. 'end' => array
  126. (
  127. 'insert' => 'work/lib/manage.updateInfo',
  128. 'update' => 'work/lib/manage.updateInfo',
  129. ),
  130. 'config_status' => $status,
  131. # 数据结构
  132. 'struct' => array
  133. (
  134. 'id' => array
  135. (
  136. 'type' => 'int-11',
  137. 'name' => 'ID',
  138. 'default' => '',
  139. 'desc' => '',
  140. 'match' => 'is_numeric',
  141. 'search' => 'order',
  142. 'list' => true,
  143. 'order' => 'desc',
  144. ),
  145. 'company_id' => array
  146. (
  147. 'type' => 'int-11',
  148. 'name' => '所属公司',
  149. 'default' => '1',
  150. 'desc' => '所属公司',
  151. 'match' => 'is_numeric',
  152. 'update' => 'hidden',
  153. //'search' => $company ? 'select' : false,
  154. //'list' => true,
  155. ),
  156. 'mobile' => array
  157. (
  158. 'type' => 'bigint-11',
  159. 'name' => '手机号',
  160. 'default' => '',
  161. 'desc' => '请输入手机号',
  162. 'match' => Dever::rule('mobile'),
  163. // 'is_numeric',
  164. 'update' => 'text',
  165. 'value' => Dever::input('search_option_mobile'),
  166. # 绑定js脚本,更新时使用,第一个参数是执行的方式,第二个参数执行的方法,第三个参数是传值。
  167. 'bind' => array('onblur', 'loading', array('url' => Dever::url("lib/manage.search","work"))),
  168. 'list_name' => '客户信息',
  169. 'list' => 'Dever::load("work/lib/manage.getUser#user",{id})',#true,
  170. // '"Dever::load("work/lib/manage.getUser",{mobile})"',
  171. ),
  172. 'name' => array
  173. (
  174. 'type' => 'varchar-200',
  175. 'name' => '用户姓名(或微信名)',
  176. 'default' => '',
  177. 'desc' => '用户姓名(或微信名)',
  178. 'match' => 'option',
  179. 'update' => 'text',
  180. // 'search' => 'fulltext',
  181. // 'list' => true,
  182. ),
  183. 'work_num' => array
  184. (
  185. 'type' => 'varchar-100',
  186. 'name' => '姓名/手机号',
  187. 'default' => '',
  188. 'desc' => '工单号',
  189. 'match' => 'is_string',
  190. 'update' => 'hidden',
  191. 'search' => array
  192. (
  193. 'api' => 'work/info-getSearch',
  194. 'col' => 'col',
  195. 'result' => 'id',
  196. 'search' => 'id',
  197. ),
  198. // 'search' => 'fulltext',
  199. // 'list' => true,
  200. ),
  201. 'source' => array
  202. (
  203. 'type' => 'int-11',
  204. 'name' => '问题来源',
  205. 'default' => '1',
  206. 'desc' => '问题来源',
  207. 'match' => 'is_string',
  208. 'option' => $source,
  209. 'update' => 'radio',
  210. 'search' => $search_auth == 1 ? 'select' : false,
  211. // 'list' => true,
  212. ),
  213. 'cate_id' => array
  214. (
  215. 'type' => 'varchar-30',
  216. 'name' => '问题类型',
  217. 'default' => '-1',
  218. 'desc' => '问题类型',
  219. 'match' => 'is_string',
  220. 'search' => $search_auth == 1 ? 'linkage' : false,
  221. 'update' => 'linkage',
  222. 'option' => Dever::url('lib/appoint.getCate?level_total=2', 'work'),
  223. 'list' => 'Dever::load("work/lib/manage.getUser#cate_name",{id})',
  224. ),
  225. 'priority_id' => array
  226. (
  227. 'type' => 'int-11',
  228. 'name' => '优先级',
  229. 'default' => '1',
  230. 'desc' => '优先级',
  231. 'match' => 'is_string',
  232. 'option' => $priority,
  233. 'update' => 'radio',
  234. 'search' => $search_auth == 1 ? 'select' : false,
  235. 'list' => true,
  236. ),
  237. 'appoint_id' => array
  238. (
  239. 'type' => 'int-11',
  240. 'name' => '指派人',
  241. 'default' => '-1',
  242. 'desc' => '指派人',
  243. 'match' => 'is_string',
  244. // 'option' => $priority,
  245. // 'update' => 'select',
  246. // 'search' => 'select',
  247. // 'list' => true,
  248. ),
  249. 'desc' => array
  250. (
  251. 'type' => 'text-255',
  252. 'name' => '问题描述',
  253. 'default' => '',
  254. 'desc' => '问题描述',
  255. 'match' => 'is_string',
  256. 'update' => 'textarea',
  257. 'list' => true,
  258. ),
  259. 'pic' => array
  260. (
  261. 'type' => 'varchar-500',
  262. 'name' => '相关截图',
  263. 'default' => '',
  264. 'desc' => '请选择相关截图',
  265. 'match' => 'option',
  266. 'update' => 'images',
  267. 'key' => '1',
  268. //'place' => '150',
  269. ),
  270. 'video' => array
  271. (
  272. 'type' => 'varchar-500',
  273. 'name' => '相关视频',
  274. 'default' => '',
  275. 'desc' => '请选择相关视频',
  276. 'match' => 'option',
  277. 'update' => 'video',
  278. 'key' => '3',
  279. 'place' => '150',
  280. 'upload' => 'yun',
  281. 'large' => true,
  282. ),
  283. 'group' => array
  284. (
  285. 'type' => 'int-11',
  286. 'name' => '部门',
  287. 'default' => '',
  288. 'desc' => '部门',
  289. 'match' => 'option',
  290. // 'search' => 'linkage',
  291. 'update' => 'hidden',
  292. // 'option' => Dever::url('lib/appoint.get?level_total=2', 'work'),
  293. ),
  294. 'question' => array
  295. (
  296. 'type' => 'int-11',
  297. 'name' => '问题',
  298. 'default' => '',
  299. 'desc' => '问题',
  300. 'match' => 'option',
  301. // 'search' => 'linkage',
  302. 'update' => 'hidden',
  303. // 'option' => Dever::url('lib/appoint.get?level_total=2', 'work'),
  304. ),
  305. 'cate' => array
  306. (
  307. 'type' => 'int-11',
  308. 'name' => '分类',
  309. 'default' => '',
  310. 'desc' => '分类',
  311. 'match' => 'option',
  312. // 'search' => 'linkage',
  313. 'update' => 'hidden',
  314. // 'option' => Dever::url('lib/appoint.get?level_total=2', 'work'),
  315. ),
  316. 'product' => array
  317. (
  318. 'type' => 'int-11',
  319. 'name' => '系统产品',
  320. 'default' => '',
  321. 'desc' => '系统产品',
  322. 'match' => 'option',
  323. 'search' => 'select',
  324. 'update' => 'hidden',
  325. 'option' => $product,
  326. 'list' => true,
  327. ),
  328. 'branch_id' => array
  329. (
  330. 'type' => 'varchar-500',
  331. 'name' => '协助部门',
  332. 'default' => '',
  333. 'desc' => '协助部门',
  334. 'match' => 'option',
  335. // 'search' => 'linkage',
  336. 'update' => 'linkage',
  337. 'option' => Dever::url('lib/appoint.get?level_total=2', 'work'),
  338. ),
  339. 'status' => array
  340. (
  341. 'type' => 'int-11',
  342. 'name' => '处理结果',
  343. 'default' => '1',
  344. 'desc' => '处理结果',
  345. 'match' => 'is_string',
  346. 'option' => $status,
  347. 'update' => 'radio',
  348. 'search' => 'select',
  349. 'list' => true,
  350. ),
  351. 'fdate' => array
  352. (
  353. 'type' => 'int-11',
  354. 'name' => '完成时间',
  355. 'default' => '',
  356. 'match' => 'is_numeric',
  357. // 'search' => 'date',
  358. 'list_name' => '时间/完成时间',
  359. // 'desc' => '',
  360. 'list' => 'Dever::load("work/lib/manage.getUSer#time",{id})',
  361. 'list_order' => 1,
  362. ),
  363. 'fpeople' => array
  364. (
  365. 'type' => 'int-11',
  366. 'name' => '完成人',
  367. 'default' => '',
  368. 'desc' => '完成人',
  369. 'match' => 'option',
  370. // 'search' => 'select',
  371. 'update' => 'hidden',
  372. // 'option' => $product,
  373. // 'list' => true,
  374. ),
  375. 'zdate' => array
  376. (
  377. 'type' => 'int-11',
  378. 'name' => '指派时间',
  379. 'default' => '',
  380. 'match' => 'is_numeric',
  381. // 'search' => 'date',
  382. ),
  383. 'chdate' => array
  384. (
  385. 'type' => 'int-11',
  386. 'name' => '处理时间',
  387. 'default' => '',
  388. 'match' => 'is_numeric',
  389. // 'search' => 'date',
  390. // 'desc' => '',
  391. ),
  392. 'audit_admin' => array
  393. (
  394. 'type' => 'int-11',
  395. 'name' => '工单创建人',
  396. 'default' => '',
  397. 'match' => 'is_numeric',
  398. 'desc' => '工单创建人',
  399. 'update' => 'hidden',
  400. 'insert' => true,
  401. 'value' => $admin_id,
  402. 'search' =>
  403. // 'Dever::load("work/lib/manage.getUSer#chuangjian",{id})',
  404. array
  405. (
  406. 'api' => 'manage/admin-getSearch',
  407. 'col' => 'col',
  408. 'result' => 'id',
  409. 'search' => 'audit_admin',
  410. ),
  411. 'list' => 'Dever::load("work/lib/manage.getUSer#chuangjian",{id})',
  412. ),
  413. 'dever_auth' => array
  414. (
  415. 'name' => '搜索',
  416. 'default' => '',
  417. 'desc' => '类型',
  418. 'match' => 'is_string',
  419. 'search' => 'hidden',
  420. ),
  421. 'reorder' => array
  422. (
  423. 'type' => 'int-11',
  424. 'name' => '排序-数值越大越靠前',
  425. 'default' => '1',
  426. 'desc' => '请输入排序',
  427. 'match' => 'option',
  428. // 'update' => 'text',
  429. // 'search' => 'order',
  430. // 'list' => true,
  431. // 'order' => 'desc',
  432. // 'edit' => true,
  433. ),
  434. 'state' => array
  435. (
  436. 'type' => 'tinyint-1',
  437. 'name' => '状态',
  438. 'default' => '1',
  439. 'desc' => '请选择状态',
  440. 'match' => 'is_numeric',
  441. ),
  442. 'cdate' => array
  443. (
  444. 'type' => 'int-11',
  445. 'name' => '创建时间',
  446. 'match' => array('is_numeric', time()),
  447. 'desc' => '',
  448. # 只有insert时才生效
  449. 'insert' => true,
  450. 'search' => 'date',
  451. // 'list' => 'date("Y-m-d H:i:s", {cdate})',
  452. ),
  453. ),
  454. 'alter' => array
  455. (
  456. 4 => array
  457. (
  458. array('update', 'product','product','int-11 系统产品'),
  459. ),
  460. 'version' => 4,
  461. ),
  462. 'manage' => array
  463. (
  464. 'insert' => $insert,
  465. 'delete' => false,
  466. 'edit' => false,
  467. 'list_button' => $list_button,
  468. 'data' => $data,
  469. 'button' => $button,
  470. 'excel' => $excel,
  471. # 设置公司权限
  472. 'company' => 'company_id',
  473. ),
  474. 'request' => array
  475. (
  476. 'list_option' => array
  477. (
  478. 'col' => 'yes-appoint_id,audit_admin,fpeople',
  479. 'ids' => array('yes-id', 'in'),
  480. 'status' => array('yes', 'in'),
  481. 'state'=>1,
  482. ),
  483. 'getSearch' => array
  484. (
  485. # 匹配的正则或函数 选填项
  486. 'option' => array
  487. (
  488. 'col' => array('yes-mobile,name', 'like'),
  489. ),
  490. 'type' => 'all',
  491. 'col' => '*|id',
  492. ),
  493. 'getTotal' => array
  494. (
  495. # 匹配的正则或函数 选填项
  496. 'option' => array
  497. (
  498. 'audit_admin' => 'yes',
  499. 'appoint_id' => 'yes',
  500. 'fpeople' => 'yes',
  501. 'state' => 1,
  502. 'status'=> array('yes','in'),
  503. 'company_id'=>'yes',
  504. ),
  505. 'type' => 'count',
  506. // 'order' => array('reorder' => 'desc', 'id' => 'asc'),
  507. 'col' => '*',
  508. ),
  509. 'getCount' => array
  510. (
  511. # 匹配的正则或函数 选填项
  512. 'option' => array
  513. (
  514. 'group' => 'yes',
  515. 'state' => 1,
  516. 'id' => array('yes','in'),
  517. 'question' => array('yes','in'),
  518. 'start' => array('yes-cdate','>='),
  519. 'end' => array('yes-cdate','<='),
  520. 'status'=> array('yes','in'),
  521. 'fpeople' => array('yes','in'),
  522. ),
  523. 'type' => 'count',
  524. // 'order' => array('reorder' => 'desc', 'id' => 'asc'),
  525. 'col' => '*',
  526. ),
  527. 'getAll' => array
  528. (
  529. # 匹配的正则或函数 选填项
  530. 'option' => array
  531. (
  532. 'group' => 'yes',
  533. 'question' => 'yes',
  534. 'state' => 1,
  535. 'start' => array('yes-cdate','>='),
  536. 'end' => array('yes-cdate','<='),
  537. 'status'=> array('yes','in'),
  538. ),
  539. 'type' => 'all',
  540. 'order' => array('reorder' => 'desc', 'id' => 'desc'),
  541. 'col' => '*',
  542. ),
  543. 'getHAll' => array
  544. (
  545. # 匹配的正则或函数 选填项
  546. 'option' => array
  547. (
  548. 'mobile' =>'yes',
  549. 'state' => 1,
  550. ),
  551. 'type' => 'all',
  552. 'order' => array('reorder' => 'desc', 'id' => 'desc'),
  553. 'page' => array(5,'list'),
  554. 'col' => '*',
  555. ),
  556. 'getquestTotal' => array
  557. (
  558. # 匹配的正则或函数 选填项
  559. 'option' => array
  560. (
  561. 'group' => 'yes',
  562. 'state' => 1,
  563. ),
  564. 'type' => 'count',
  565. // 'order' => array('id' => 'desc'),
  566. 'col' => '*',
  567. ),
  568. 'getNum' => array
  569. (
  570. # 匹配的正则或函数 选填项
  571. 'option' => array
  572. (
  573. 'start' => array('yes-cdate','>='),
  574. 'end' => array('yes-cdate','<='),
  575. 'priority_id' =>'yes',
  576. 'cate' => 'yes',
  577. 'state' => 1,
  578. ),
  579. 'type' => 'count',
  580. // 'order' => array('id' => 'desc'),
  581. 'col' => '*',
  582. ),
  583. ),
  584. );