Manage.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422
  1. <?php
  2. namespace Work\Lib;
  3. use Dever;
  4. Class Manage
  5. {
  6. public function getCoor_api()
  7. {
  8. $id = Dever::input('id');
  9. $info = false;
  10. if ($id) {
  11. $info = Dever::db('work/branch')->one($id);
  12. }
  13. $group = Dever::input('group');
  14. $temp = explode(',', $group);
  15. $group_id = $temp[0];
  16. $admin_id = false;
  17. if (isset($temp[1])) {
  18. $admin_id = $temp[1];
  19. } else {
  20. return 'no';
  21. }
  22. $admin = Dever::load('manage/company')->getAdmin($group_id, $admin_id);
  23. $config = array();
  24. $config['struct']['coor'] = array
  25. (
  26. 'type' => 'varchar-2000',
  27. 'name' => '协调人',
  28. 'default' => '',
  29. 'desc' => '请先选择协调人',
  30. 'match' => 'option',
  31. 'update' => 'checkbox',
  32. 'value' => $info ? $info['coor'] : false,
  33. 'option' => $admin,
  34. );
  35. $data = array();
  36. $result = Dever::load('manage/database')->update_struct($config, false, array(), -1, '', true);
  37. return implode('', $result);
  38. }
  39. public function setInfoStatus_api ()
  40. {
  41. Dever::config('base')->hook = true;
  42. $id = Dever::input('id');
  43. $status = Dever::input('status');
  44. $type = Dever::input('type');
  45. if ($id) {
  46. $info = Dever::db('work/info')->find($id);
  47. $update['where_id'] = $info['id'];
  48. if ($type == 1) {
  49. $update['status'] = 4;
  50. } else {
  51. $update['status'] = 3;
  52. }
  53. $update = $this->finish($update, $info);
  54. Dever::db('work/info')->update($update);
  55. return 'ok';
  56. }
  57. }
  58. private function finish($update, $info)
  59. {
  60. $update['fdate'] = time();
  61. $update['chdate'] = time();
  62. $app = Dever::db('work/appoint')->getAdmin(array('info_id'=>$info['id'],'admin'=>$info['audit_admin']));
  63. if ($app && $app['admin']) {
  64. $update['fpeople'] = $app['admin'];
  65. } else {
  66. $update['fpeople'] = $info['audit_admin'];
  67. }
  68. $log = Dever::db('work/info_log')->find(array('info_id'=>$info['id']));
  69. if ($log) {
  70. $w = array();
  71. $w['where_id'] = $log['id'];
  72. $w['fdate'] = time();
  73. if($update['status'] == 4){
  74. $w['cloce_date'] = time();
  75. }
  76. Dever::db('work/info_log')->update($w);
  77. }
  78. return $update;
  79. }
  80. public function insertInfo($id,$name,$data) {
  81. $mobile = Dever::param('mobile',$data);
  82. if(!preg_match('/^1[3|5|6|7|8|9]\d{9}$/', $mobile)){
  83. Dever::alert('手机号不正确');
  84. }
  85. $cate_id = Dever::param('cate_id',$data);
  86. if ($cate_id[0]<0) {
  87. Dever::alert('问题类型不能为空');
  88. }
  89. }
  90. public function updateInfo($id,$name,$data)
  91. {
  92. Dever::config('base')->hook = true;
  93. $mobile = Dever::param('mobile',$data);
  94. $cate_id = Dever::param('cate_id',$data);
  95. $name = Dever::param('name',$data);
  96. $user = Dever::db('work/user')->find(array('mobile'=>$mobile));
  97. if ($user) {
  98. if ($name && $user['name'] != $name) {
  99. Dever::db('work/user')->update(array('where_id'=>$user['id'],'name'=>$name));
  100. }
  101. } else {
  102. $member = Dever::db('agent/member')->find(array('mobile'=>$mobile));
  103. if ($member) {
  104. $insert['agent_uid'] = $member['id'];
  105. }
  106. $option = Dever::db('option/member')->find(array('mobile'=>$mobile));
  107. if ($option) {
  108. $insert['option_uid'] = $option['id'];
  109. }
  110. $passport = Dever::db('passport/user')->find(array('mobile'=>$mobile));
  111. if ($passport) {
  112. $insert['passport_uid'] = $passport['id'];
  113. }
  114. if ($name) {
  115. $insert['name'] = $name;
  116. }
  117. $insert['mobile'] = $mobile;
  118. if ($insert) {
  119. Dever::db('work/user')->insert($insert);
  120. }
  121. }
  122. $info = Dever::db('work/info')->find($id);
  123. if ($info) {
  124. $w = array();
  125. if (!$info['work_num']) {
  126. $w['work_num'] = $this->getWorkId();
  127. }
  128. if ($info['cate_id']) {
  129. $cate_id = explode(',', $info['cate_id']);
  130. if (isset($cate_id[1]) && $cate_id[1]) {
  131. $info['question'] = $w['question'] = $cate_id[1];
  132. }
  133. }
  134. if ($info['question']) {
  135. $product = Dever::db('work/question')->find($info['question']);
  136. $w['product'] = $product['product_id'];
  137. }
  138. if ($info['branch_id'] && strstr($info['branch_id'], ',') && $info['branch_id'] != -1) {
  139. $branch_id = explode(',', $info['branch_id']);
  140. $w['group'] = $branch_id[0];
  141. $w['appoint_id'] = $branch_id[1];
  142. }
  143. if ($info['status'] == 3 || $info['status'] == 4) {
  144. $w = $this->finish($w, $info);
  145. }
  146. if ($w) {
  147. $w['where_id'] = $id;
  148. Dever::db('work/info')->update($w);
  149. }
  150. }
  151. }
  152. public function getWorkId()
  153. {
  154. $where['work_num'] = Dever::order('W');
  155. $state = Dever::db('work/info')->one($where);
  156. if (!$state) {
  157. return $where['work_num'];
  158. } else {
  159. return $this->getWorkId();
  160. }
  161. }
  162. public function getUser($id)
  163. {
  164. $info = Dever::db('work/info')->find($id);
  165. $data = array();
  166. if ($info && isset($info['mobile']) && $info['mobile']) {
  167. $data= Dever::db('work/user')->find(array('mobile'=>$info['mobile']));
  168. }
  169. if ($data) {
  170. $html['user'] = $data['name'].'<br/>'.$data['mobile'];
  171. if (isset($info['fdate']) && $info['fdate']) {
  172. $fdate = date('Y-m-d H:i:s',$info['fdate']);
  173. } else {
  174. $fdate = '';
  175. }
  176. $html['time'] = date('Y-m-d H:i:s',$info['cdate']).'<br/>'.$fdate;
  177. $cate_id = explode(',',$info['cate_id']);
  178. $cate_name = '';
  179. $question_name = '';
  180. if (isset($cate_id[0]) && $cate_id[0]) {
  181. $cate = Dever::db('work/q_cate')->find($cate_id[0]);
  182. $cate_name = $cate['name'];
  183. }
  184. if (isset($cate_id[1]) && $cate_id[1]) {
  185. $question = Dever::db('work/question')->find($cate_id[1]);
  186. $question_name = $question['name'];
  187. }
  188. $html['cate_name'] = $cate_name.'<br/>'.$question_name;
  189. return $html;
  190. } else {
  191. return '';
  192. }
  193. }
  194. public function xietiao_api($id)
  195. {
  196. $data = Dever::db('work/branch')->find($id);
  197. $data['group'] = explode(',',$data['group']);
  198. $group = Dever::db('manage/group')->find($data['group'][0]);
  199. $admin = Dever::load('manage/company')->getAdmin($group['id'], $data['group'][1]);
  200. $gad = Dever::db('manage/admin')->find($data['group'][1]);
  201. $res = array();
  202. foreach ($admin as $k => $v) {
  203. $res[$k] = $v['username'].'<br/>'.$v['email'];
  204. }
  205. // $total = Dever::db('work/info')->getquestTotal(array('group'=>$data['group'][0]));
  206. $html = array();
  207. $html['group'] = $group['name'].'<br/>'.$gad['username'];
  208. $html['name'] = implode('<br/>',$res);
  209. $total = Dever::db('work/question')->getTotal(array('branch_id'=>$data['group_id']));
  210. $html['num'] = $total;
  211. return $html;
  212. }
  213. #获取客户信息
  214. public function search_api()
  215. {
  216. $value = Dever::input('value');
  217. if(!preg_match('/^1[3|5|6|7|8|9]\d{9}$/', $value)){
  218. return '代理商手机号不正确';
  219. }
  220. if ($value) {
  221. $name = '';
  222. $role_name = '';
  223. $user = Dever::db('work/user')->find(array('mobile'=>$value));
  224. if(!$user) {
  225. $member = Dever::db('agent/member')->find(array('mobile'=>$value));
  226. if ($member) {
  227. $name = $member['name'];
  228. $type = "代理商";
  229. $role = Dever::db('setting/role')->find($member['role']);
  230. if ($role ) {
  231. $role_name = $role['name'];
  232. }
  233. $option = Dever::db('option/member')->find(array('mobile'=>$value));
  234. if ($option) {
  235. $type = $type.'<br/>期权账户';
  236. $passport = Dever::db('passport/user')->find(array('mobile'=>$value));
  237. if ($passport) {
  238. $type = $type.'<br/>小程序';
  239. }
  240. } else {
  241. $passport = Dever::db('passport/user')->find(array('mobile'=>$value));
  242. if ($passport) {
  243. $type = $type.'<br/>小程序';
  244. }
  245. }
  246. } else {
  247. $option = Dever::db('option/member')->find(array('mobile'=>$value));
  248. if ($option) {
  249. $name = $option['name'];
  250. $type = '期权账户';
  251. $passport = Dever::db('passport/user')->find(array('mobile'=>$value));
  252. if ($passport) {
  253. $type = $type.'<br/>小程序';
  254. }
  255. } else {
  256. $passport = Dever::db('passport/user')->find(array('mobile'=>$value));
  257. if ($passport) {
  258. $name = $passport['username'];
  259. $type = '小程序';
  260. } else {
  261. $type = '无系统关联关系';
  262. }
  263. }
  264. }
  265. } else {
  266. $name = $user['name'];
  267. $type = '客服系统用户';
  268. if ($user['agent_uid'] && $user['agent_uid'] > 0) {
  269. $member = Dever::db('agent/member')->find($user['agent_uid']);
  270. $role = Dever::db('setting/role')->find($member['role']);
  271. if ($role) {
  272. $role_name = $role['name'];
  273. }
  274. $type = $type.'<br/>代理商';
  275. }
  276. if ($user['option_uid'] && $user['option_uid'] > 0) {
  277. $type = $type.'<br/>期权账户';
  278. }
  279. if ($user['passport_uid'] && $user['passport_uid'] > 0) {
  280. $type = $type.'<br/>小程序';
  281. }
  282. }
  283. $table = array();
  284. if ($name && $role_name) {
  285. $table['head'] = array('名称', '电话号码', '平台' ,'角色');
  286. $table['body'] = array($name, $value, $type, $role_name);
  287. } elseif ($name && !$role_name) {
  288. $table['head'] = array('名称', '电话号码', '平台');
  289. $table['body'] = array($name, $value, $type);
  290. } elseif (!$name && $role_name) {
  291. $table['head'] = array('电话号码', '平台' ,'角色');
  292. $table['body'] = array($value, $type, $role_name);
  293. } else if (!$name && !$role_name) {
  294. $table['head'] = array('电话号码', '平台');
  295. $table['body'] = array($value, $type );
  296. }
  297. $result[] = array
  298. (
  299. 'type' => 'table',
  300. 'content' => $table,
  301. );
  302. $html = Dever::show('', $result, false, false);
  303. return array('html' => $html, 'data' => array('name' => $name));
  304. }
  305. }
  306. public function admin($id)
  307. {
  308. $data = Dever::db('work/product')->find(array($id));
  309. $admin_id = explode(',',$data['admin_id']);
  310. $admin = Dever::db('manage/admin')->find($admin_id[1]);
  311. if ($admin) {
  312. return $admin['username'].'<br/>'.$admin['email'];
  313. }
  314. }
  315. public function branch($id)
  316. {
  317. if (isset($id) && $id) {
  318. $group = Dever::db('manage/group')->find($id);
  319. if (isset($group) && isset($group['name']) && $group['name']) {
  320. return $group['name'];
  321. }
  322. }
  323. }
  324. #工单列表导出
  325. public function out_info($data)
  326. {
  327. $header = array('客户名称','手机号','问题类型','问题类型描述','优先级','问题描述','处理结果','创建时间','完成时间');
  328. $body = array();
  329. $config = Dever::db('work/info')->config['config_status'];
  330. foreach ($data as $k => $v ) {
  331. $cate_name = '';
  332. $cate_id = explode(',',$v['cate_id']);
  333. if (isset($cate_id[0]) && $cate_id[0]) {
  334. $cate = Dever::db('work/q_cate')->find(array('id'=>$cate_id[0]));
  335. if ($cate) {
  336. $cate_name = $cate['name'];
  337. }
  338. }
  339. $question_name = '';
  340. if (isset($cate_id[1]) && $cate_id[1]) {
  341. $question = Dever::db('work/question')->find(array('id'=>$cate_id[1]));
  342. if ($question) {
  343. $question_name = $question['name'];
  344. }
  345. }
  346. $priority_name = '';
  347. $priority = Dever::db('work/priority')->find(array('id'=>$v['priority_id']));
  348. if ($priority) {
  349. $priority_name = $priority['name'];
  350. }
  351. $status_name = Dever::status($config,$v['status']);
  352. $cdate = date('Y-m-d H:i',$v['cdate']);
  353. $fdate = '';
  354. if ($v['fdate']){
  355. $fdate = date('Y-m-d H:i',$v['fdate']);
  356. }
  357. $d = array
  358. (
  359. $v['name'],
  360. $v['mobile'],
  361. $cate_name,
  362. $question_name,
  363. $priority_name,
  364. $v['desc'],
  365. $status_name,
  366. $cdate,
  367. $fdate,
  368. );
  369. $body[] = $d;
  370. }
  371. $file = Dever::input('excel_name');
  372. return Dever::excelExport($body, $header, $file);
  373. }
  374. public function getTotal($admin_id,$status=false)
  375. {
  376. $company = Dever::load('manage/company.get');
  377. $where = array();
  378. if ($status){
  379. $where['status'] = $status;
  380. if ($where['status'] == '1,2') {
  381. $where['appoint_id'] = $admin_id;
  382. } else {
  383. $where['fpeople'] = $admin_id;
  384. }
  385. } else {
  386. $where['audit_admin'] = $admin_id;
  387. }
  388. if ($company) {
  389. $where['company_id'] = $company;
  390. }
  391. $data = Dever::db('work/info')->getTotal($where);
  392. return $data;
  393. }
  394. }