Appoint.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467
  1. <?php
  2. namespace Work\lib;
  3. use Dever;
  4. Class Appoint
  5. {
  6. public function startBranch($id,$name,$data)
  7. {
  8. // Dever::config('base')->hook = true;
  9. $group = Dever::param('group',$data);
  10. // $id = Dever::param('id',$data);
  11. if ($group) {
  12. $res = Dever::db('work/branch')->find(array('group_id'=>$group[0]));
  13. if ($res && isset($id['where_id']) && $id['where_id']){
  14. if ($res['id'] != $id['where_id']){
  15. Dever::alert('部门已存在');
  16. }
  17. } elseif ($res) {
  18. Dever::alert('部门已存在');
  19. }
  20. }
  21. }
  22. public function updateBranch($id,$name,$data)
  23. {
  24. // Dever::config('base')->hook = true;
  25. $group = Dever::param('group',$data);
  26. if($group) {
  27. $where['where_id'] = $id;
  28. $where['group_id'] = $group[0];
  29. Dever::db('work/branch')->update($where);
  30. }
  31. }
  32. public function insertAppoint($id,$name,$data)
  33. {
  34. $info_id = Dever::param('info_id',$data);
  35. if ($info_id) {
  36. $info = Dever::db('work/info')->find($info_id);
  37. if ($info['status']>=3){
  38. Dever::alert('工单已关闭');
  39. }
  40. }
  41. }
  42. public function updateAppoint($id,$name,$data)
  43. {
  44. Dever::config('base')->hook = true;
  45. $info_id = Dever::param('info_id',$data);
  46. $branch = Dever::param('admin_id',$data);
  47. if ($info_id ) {
  48. $info = Dever::db('work/info')->find($info_id);
  49. $admin = Dever::load('manage/auth.info');
  50. $admin_id = $info['audit_admin'];
  51. if ($info['audit_admin'] != $admin['id']) {
  52. $admin_id = $admin['id'];
  53. }
  54. if($info) {
  55. if ($branch) {
  56. $i['where_id'] = $info['id'];
  57. if ($info['group']) {
  58. $group = $info['group'].',';
  59. } else {
  60. $group = $branch[0];
  61. }
  62. if (isset($branch[1]) && $branch[1]) {
  63. $i['appoint_id'] = $branch[1];
  64. }
  65. $i['group'] = $group;
  66. $i['zdate'] = time();
  67. $i['chdate'] = time();
  68. $i['status'] = 2;
  69. if ($i) {
  70. Dever::db('work/info')->update($i);
  71. }
  72. }
  73. $w['info_id'] = $info['id'];
  74. $w['admin_id'] = $admin_id;
  75. $w['appoint_id'] = $id;
  76. Dever::db('work/info_log')->insert($w);
  77. }
  78. if ($branch) {
  79. // $data = Dever::db('work/branch')->find(array('group_id'=>$branch[0]));
  80. // if ($data) {
  81. // $where['where_id'] = $data['id'];
  82. // $where['num'] = $data['num'] +1;
  83. // Dever::db('work/branch')->update($where);
  84. // }
  85. $wh['where_id'] = $id;
  86. $wh['group'] = $branch[0];
  87. Dever::db('work/appoint')->update($wh);
  88. }
  89. }
  90. }
  91. #指派人
  92. private $default = array
  93. (
  94. 'value' => -1,
  95. 'name' => '不选择',
  96. );
  97. private $search_default = array
  98. (
  99. 'value' => -1,
  100. 'name' => '部门',
  101. );
  102. public function get_api()
  103. {
  104. # 联动总数,默认到部门
  105. $level_total = Dever::input('level_total', 1);
  106. # 当前联动级别
  107. $level_num = Dever::input('level_num');
  108. # 一般为id
  109. $level_id = Dever::input('level_id');
  110. # 是否是搜索列表页
  111. $level_search = Dever::input('level_search');
  112. if ($level_search) {
  113. $default = $this->search_default;
  114. if ($level_num == 1) {
  115. $default['name'] = '部门选择';
  116. } elseif ($level_num == 2) {
  117. $default['name'] = '组员选择';
  118. }
  119. } else {
  120. $default = $this->default;
  121. }
  122. // if ($level_id < 0) {
  123. // Dever::alert('error');
  124. // }
  125. if ($level_num == 1) {
  126. $data = $this->group();
  127. } elseif ($level_num == 2) {
  128. $data = $this->group_admin($level_id);
  129. }
  130. if (!$data) {
  131. Dever::alert('error');
  132. }
  133. if ($level_search || $level_num >= 1) {
  134. array_unshift($data, $default);
  135. }
  136. $result['level_total'] = $level_total;
  137. $result['list'] = $data;
  138. return $result;
  139. }
  140. public function group(){
  141. $data = Dever::load('manage/company')->getGroup();
  142. foreach ($data as $k => $v) {
  143. $data[$k]['value'] = $v['id'];
  144. }
  145. return $data;
  146. }
  147. public function group_admin($level_id){
  148. $data = Dever::load('manage/company')->getAdmin($level_id);
  149. foreach ($data as $k => $v) {
  150. foreach ($v as $k1 => $v1) {
  151. $data[$k]['value'] = $v['id'];
  152. $data[$k]['name'] = $v['username'];
  153. }
  154. }
  155. return $data;
  156. }
  157. #问题
  158. private $cdefault = array
  159. (
  160. 'value' => -1,
  161. 'name' => '不选择',
  162. );
  163. private $search_cdefault = array
  164. (
  165. 'value' => -1,
  166. 'name' => '问题类型描述',
  167. );
  168. #问题类型联动
  169. public function getCate_api()
  170. {
  171. # 联动总数,默认到部门
  172. $level_total = Dever::input('level_total', 1);
  173. # 当前联动级别
  174. $level_num = Dever::input('level_num');
  175. # 一般为id
  176. $level_id = Dever::input('level_id');
  177. # 是否是搜索列表页
  178. $level_search = Dever::input('level_search');
  179. if ($level_search) {
  180. $default = $this->search_cdefault;
  181. if ($level_num == 1) {
  182. $default['name'] = '问题分类名称';
  183. } elseif ($level_num == 2) {
  184. $default['name'] = '问题类型描述';
  185. }
  186. } else {
  187. $default = $this->cdefault;
  188. }
  189. // if ($level_id < 0) {
  190. // Dever::alert('error');
  191. // }
  192. if ($level_num == 1) {
  193. $data = Dever::db('work/q_cate')->getSearchAll();
  194. } elseif ($level_num == 2) {
  195. $data = Dever::db('work/question')->getSearchAll(array('cate_id'=>$level_id));
  196. }
  197. if (!$data) {
  198. Dever::alert('error');
  199. }
  200. if ($level_search || $level_num >= 1) {
  201. array_unshift($data, $default);
  202. }
  203. $result['level_total'] = $level_total;
  204. $result['list'] = $data;
  205. return $result;
  206. }
  207. public function show_api()
  208. {
  209. $info_id = Dever::input('id');
  210. $data['info'] = Dever::db('work/info')->find($info_id);
  211. $ztime = $data['info']['cdate'];
  212. $data['info']['cdate'] = date('Y-m-d H:i',$data['info']['cdate']);
  213. $priority = Dever::db('work/priority')->find($data['info']['priority_id']);
  214. $data['info']['priority_name'] = $priority['name'];
  215. $data['info']['color'] = $priority['color'];
  216. $admin = Dever::db('manage/admin')->find($data['info']['audit_admin']);
  217. $admin['group'] = explode(',',$admin['group']);
  218. foreach ($admin['group'] as $k => $v) {
  219. $group = Dever::db('manage/group')->find(array('company_id'=>$data['info']['company_id'],'id'=>$v));
  220. }
  221. $data['info']['admin'] = $group['name'].' / '.$admin['username'];
  222. if ($data['info']['source']) {
  223. $source = Dever::db('work/q_source')->find($data['info']['source']);
  224. if ($source) {
  225. $data['info']['source_name'] = $source['name'];
  226. }
  227. }
  228. $data['info']['role_name'] = '';
  229. $user = Dever::db('work/user')->find(array('mobile'=>$data['info']['mobile']));
  230. if ($user) {
  231. $data['info']['user_name'] = $user['name'];
  232. $data['info']['mobile'] = $user['mobile'];
  233. $data['info']['idcard'] = $user['idcard'];
  234. if ($user['agent_uid'] && $user['agent_uid']>0) {
  235. $member = Dever::db('agent/member')->find($user['agent_uid']);
  236. if ($member && $member['role']) {
  237. $role = Dever::db('setting/role')->find($member['role']);
  238. if ($role) {
  239. $data['info']['role_name'] = $role['name'];
  240. }
  241. }
  242. }
  243. }
  244. $data['info']['cate_name'] = '';
  245. $data['info']['product_name'] = '';
  246. $data['info']['question_name'] ='';
  247. if ($data['info']['cate_id']) {
  248. $cate_id = explode(',',$data['info']['cate_id']);
  249. if (isset($cate_id[0]) && $cate_id[0]) {
  250. $cate = Dever::db('work/q_cate')->find($cate_id[0]);
  251. if ($cate) {
  252. $data['info']['cate_name'] = $cate['name'];
  253. }
  254. } else {
  255. $cate = array();
  256. }
  257. if (isset($cate_id[1]) && $cate_id[1]) {
  258. $question = Dever::db('work/question')->find($cate_id[1]);
  259. if ($question) {
  260. $product = Dever::db('work/product')->find($question['product_id']);
  261. if ($product) {
  262. $data['info']['product_name'] = $product['name'];
  263. }
  264. $data['info']['question_name'] = $question['name'];
  265. }
  266. } else {
  267. $question = array();
  268. }
  269. if ($data['info']['cate_name'] && $data['info']['product_name']) {
  270. $data['info']['cate_name'] = $data['info']['cate_name'].' / '.$data['info']['product_name'];
  271. }
  272. }
  273. if ($data['info']['pic']) {
  274. $data['info']['pic'] = explode(',',$data['info']['pic']);
  275. }
  276. $data['info_log'] = Dever::db('work/info_log')->getAll(array('info_id'=>$info_id));
  277. foreach ($data['info_log'] as $k => $v) {
  278. $data['info_log'][$k]['cdate'] = date('Y-m-d H:i:s',$v['cdate']);
  279. $admin = Dever::db('manage/admin')->find($v['admin_id']);
  280. $admin_group = Dever::db('manage/group')->find($admin['group']);
  281. $data['info_log'][$k]['admin_group'] = $admin_group['name'].' / '.$admin['username'];
  282. $appoint = Dever::db('work/appoint')->find($v['appoint_id']);
  283. if (isset($appoint) && $appoint) {
  284. $data['info_log'][$k]['desc'] = $appoint['desc'];
  285. $appoint_admin = explode(',',$appoint['admin_id']);
  286. if (isset($appoint_admin[0])) {
  287. $appoint_group = Dever::db('manage/group')->find($appoint_admin[0]);
  288. } else {
  289. $appoint_group = array();
  290. }
  291. if (isset($appoint_admin[1]) && $appoint_admin[1]) {
  292. $appoint_ad = Dever::db('manage/admin')->find($appoint_admin[1]);
  293. } else {
  294. $appoint_ad = array();
  295. }
  296. if ($appoint_group && $appoint_ad) {
  297. $data['info_log'][$k]['appoint_admin'] = '指派人:'. $appoint_group['name'].' / '.$appoint_ad['username'];
  298. }
  299. }
  300. $data['info_log'][$k]['image'] = '';
  301. if ($appoint['video']) {
  302. $data['info_log'][$k]['video'] = $appoint['video'];
  303. }
  304. if ($appoint['pic']) {
  305. $data['info_log'][$k]['pic'] = explode(',',$appoint['pic']);
  306. }
  307. }
  308. $data['s_zhi'] = array();
  309. $data['s_zhi']['cdate'] = date('Y-m-d H:i',time());
  310. $data['zhi'] = Dever::db('work/appoint')->getAll(array('info_id'=>$info_id));
  311. foreach ($data['zhi'] as $k => $v) {
  312. $time = $v['cdate'] - $ztime;
  313. $data['zhi'][$k]['time'] = floor($time%86400/3600).'小时'.floor($time%3600/60).'分钟'.floor($time%60).'秒';
  314. $admin = explode(',',$v['admin_id']);
  315. if (isset($admin[0]) && $admin[0]) {
  316. $group = Dever::db('manage/group')->find($admin[0]);
  317. } else {
  318. $group = array();
  319. }
  320. if (isset($admin[1]) && $admin[1]) {
  321. $adm = Dever::db('manage/admin')->find($admin[1]);
  322. } else {
  323. $adm = array();
  324. }
  325. if ($group && $admin) {
  326. $data['zhi'][$k]['admin'] = $group['name'].' / '.$adm['username'];
  327. } else {
  328. $data['zhi'][$k]['admin'] = '';
  329. }
  330. $data['zhi'][$k]['cdate'] = date('Y-m-d H:i',$v['cdate']);
  331. $info_log = Dever::db('work/info_log')->find(array('appoint_id'=>$v['id']));
  332. if ($info_log && $info_log['fdate']) {
  333. $data['zhi'][$k]['finish'] = '完成关闭';
  334. $data['zhi'][$k]['time'] ='';
  335. } else {
  336. if ($info_log && $info_log['cloce_date']) {
  337. $data['zhi'][$k]['finish'] = '取消关闭';
  338. $data['zhi'][$k]['time'] ='';
  339. } else {
  340. $data['zhi'][$k]['finish'] = '';
  341. $data['zhi'][$k]['time'] = floor($time%86400/3600).'小时'.floor($time%3600/60).'分钟'.floor($time%60).'秒';
  342. }
  343. }
  344. }
  345. if ($data['info']['status'] < 3) {
  346. $data['hui'] = Dever::url('project/database/update?project=work&table=appoint&search_option_info_id='.$info_id, 'manage');
  347. }
  348. return Dever::render('index', $data);
  349. }
  350. public function back_api(){
  351. $mobile = Dever::input('mobile');
  352. $data = array();
  353. if ($mobile) {
  354. if(!preg_match('/^1[3|5|6|7|8|9]\d{9}$/', $mobile)){
  355. // Dever::alert('代理商手机号不正确');
  356. return '代理商手机号不正确';
  357. }
  358. $user = Dever::db('work/user')->find(array('mobile'=>$mobile));
  359. if (!$user) {
  360. $data['user']['mobile'] = $mobile;
  361. $data['user']['type'] = '无系统关联关系';
  362. $data['user']['work'] = Dever::url('project/database/update?project=work&table=info&menu=work&search_option_mobile='.$mobile, 'manage');
  363. // print_R($data);die;
  364. return Dever::render('back', $data);
  365. }
  366. if ($user){
  367. $table = array();
  368. $user['role_name'] = '';
  369. $user['type'] = '';
  370. if ($user['agent_uid'] && $user['agent_uid'] > 0) {
  371. $member = Dever::db('agent/member')->find($user['agent_uid']);
  372. if ($member['role']) {
  373. $role = Dever::db('setting/role')->find($member['role']);
  374. if ($role) {
  375. $user['role_name'] = $role['name'];
  376. }
  377. }
  378. $user['type'] = '代理商';
  379. if ($user['option_uid'] && $user['option_uid']>0) {
  380. $user['type'] = $user['type'].'<br/>期权账户';
  381. }
  382. if ($user['passport_uid'] && $user['passport_uid']>0) {
  383. $user['type'] = $user['type'].'<br/>小程序';
  384. }
  385. $user['type'] = $user['type'].'<br/>客服系统用户';
  386. } else {
  387. if ($user['option_uid'] && $user['option_uid']>0) {
  388. $user['type'] = '期权账户';
  389. if ($user['passport_uid'] && $user['passport_uid']>0) {
  390. $user['type'] = $user['type'].'<br/>小程序';
  391. }
  392. $user['type'] = $user['type'].'<br/>客服系统用户';
  393. } else {
  394. if ($user['passport_uid'] && $user['passport_uid']>0) {
  395. $user['type'] = '小程序';
  396. $user['type'] = $user['type'].'<br/>客服系统用户';
  397. } else {
  398. $user['type'] = '客服系统用户';
  399. // $user['type'] = '无系统关联关系';
  400. }
  401. }
  402. }
  403. if ($user['agent_uid']) {
  404. $user['order'] = Dever::url('project/database/list?project=agent&table=order&p=1&search_option_mid='.$user['agent_uid'], 'manage');
  405. $user['agent'] = Dever::url('project/database/list?project=agent&table=member_area&mid='.$user['agent_uid'].'&page_type=1&search_auth=1&page_type=1&jump=19','manage');
  406. $user['soft'] = Dever::url('project/database/list?project=agent&table=soft_cash&search_option_mid='.$user['agent_uid'], 'manage');
  407. }
  408. if ($user['option_uid']) {
  409. $user['option'] = Dever::url('project/database/list?project=option&table=member&search_option_id='.$user['option_uid'], 'manage');
  410. }
  411. $user['work'] = Dever::url('project/database/update?project=work&table=info&menu=work&search_option_mobile='.$mobile, 'manage');
  412. $data['user'] = $user;
  413. $data['info'] = Dever::db('work/info')->getHAll(array('mobile'=>$mobile));
  414. $config = Dever::db('work/info')->config['config_status'];
  415. foreach($data['info'] as $k => $v) {
  416. $data['info'][$k]['cdate'] = date('Y-m-d H:i',$v['cdate']);
  417. $data['info'][$k]['fdate'] = date('Y-m-d H:i',$v['fdate']);
  418. $cate = Dever::db('work/q_cate')->find(array('id'=>$v['cate_id']));
  419. $data['info'][$k]['cate_name'] = $cate['name'];
  420. $you = Dever::db('work/priority')->find(array('id'=>$v['priority_id']));
  421. $data['info'][$k]['you'] = $you['name'];
  422. $group = Dever::db('manage/group')->find(array('id'=>$v['branch_id']));
  423. $data['info'][$k]['branch'] = $group['name'];
  424. $data['info'][$k]['status'] = Dever::status($config,$v['status']);
  425. $data['info'][$k]['url'] = Dever::url('lib/appoint.show&id='.$v['id'],'work');
  426. if ($v['status']<3) {
  427. $data['info'][$k]['zhipai'] = Dever::url('project/database/update?project=work&table=appoint&search_option_info_id='.$v['id'], 'manage');
  428. } else {
  429. $data['info'][$k]['zhipai'] = '';
  430. }
  431. }
  432. }
  433. $data['page'] = Dever::page("current");
  434. }
  435. return Dever::render('back', $data);
  436. }
  437. }