Manage.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358
  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. $id = Dever::input('id');
  42. $status = Dever::input('status');
  43. $type = Dever::input('type');
  44. if ($id) {
  45. $data = Dever::db('work/info')->find($id);
  46. $where['where_id'] = $id;
  47. if ($type == 1) {
  48. $where['status'] = 4;
  49. } else {
  50. $where['status'] = 3;
  51. }
  52. $where['fdate'] = time();
  53. $where['chdate'] = time();
  54. Dever::db('work/info')->update($where);
  55. $log = Dever::db('work/info_log')->find(array('info_id'=>$id));
  56. $w['where_id'] = $log['id'];
  57. $w['fdate'] = time();
  58. if($type == 1){
  59. $w['cloce_date'] = time();
  60. }
  61. Dever::db('work/info_log')->update($w);
  62. return 'ok';
  63. }
  64. }
  65. public function updateInfo($id,$name,$data)
  66. {
  67. $mobile = Dever::param('mobile',$data);
  68. $cate_id = Dever::param('cate_id',$data);
  69. $name = Dever::param('name',$data);
  70. $user = Dever::db('work/user')->find(array('mobile'=>$mobile));
  71. if ($user) {
  72. if ($name && $user['name'] != $name) {
  73. Dever::db('work/user')->update(array('where_id'=>$user['id'],'name'=>$name));
  74. }
  75. } else {
  76. $member = Dever::db('agent/member')->find(array('mobile'=>$mobile));
  77. if ($member) {
  78. $insert['agent_uid'] = $member['id'];
  79. }
  80. $option = Dever::db('option/member')->find(array('mobile'=>$mobile));
  81. if ($option) {
  82. $insert['option_uid'] = $option['id'];
  83. }
  84. $passport = Dever::db('passport/user')->find(array('mobile'=>$mobile));
  85. if ($passport) {
  86. $insert['passport_uid'] = $passport['id'];
  87. }
  88. if ($name) {
  89. $insert['name'] = $name;
  90. }
  91. $insert['mobile'] = $mobile;
  92. if ($insert) {
  93. Dever::db('work/user')->insert($insert);
  94. }
  95. }
  96. $info = Dever::db('work/info')->find($id);
  97. if ($info && !$info['question']) {
  98. if (isset($cate_id) && $cate_id && isset($cate_id[1]) && $cate_id[1]) {
  99. $w['question'] = $cate_id[1];
  100. }
  101. }
  102. if ($info && !$info['work_num']) {
  103. $w['where_id'] = $id;
  104. $w['work_num'] = $this->getWorkId();
  105. Dever::db('work/info')->update($w);
  106. }
  107. }
  108. public function getWorkId()
  109. {
  110. $where['work_num'] = Dever::order('W');
  111. $state = Dever::db('work/info')->one($where);
  112. if (!$state) {
  113. return $where['work_num'];
  114. } else {
  115. return $this->getWorkId();
  116. }
  117. }
  118. public function getUser($id)
  119. {
  120. $info = Dever::db('work/info')->find($id);
  121. $data= Dever::db('work/user')->find(array('mobile'=>$info['mobile']));
  122. if ($data) {
  123. $html['user'] = $data['name'].'<br/>'.$data['mobile'];
  124. if (isset($info['fdate']) && $info['fdate']) {
  125. $fdate = date('Y-m-d H:i:s',$info['fdate']);
  126. } else {
  127. $fdate = '';
  128. }
  129. $html['time'] = date('Y-m-d H:i:s',$info['cdate']).'<br/>'.$fdate;
  130. $cate_id = explode(',',$info['cate_id']);
  131. $cate_name = '';
  132. $question_name = '';
  133. if (isset($cate_id[0]) && $cate_id[0]) {
  134. $cate = Dever::db('work/q_cate')->find($cate_id[0]);
  135. $cate_name = $cate['name'];
  136. }
  137. if (isset($cate_id[1]) && $cate_id[1]) {
  138. $question = Dever::db('work/question')->find($cate_id[1]);
  139. $question_name = $question['name'];
  140. }
  141. $html['cate_name'] = $cate_name.'<br/>'.$question_name;
  142. return $html;
  143. } else {
  144. return '';
  145. }
  146. }
  147. public function xietiao_api($id)
  148. {
  149. $data = Dever::db('work/branch')->find($id);
  150. $data['group'] = explode(',',$data['group']);
  151. $group = Dever::db('manage/group')->find($data['group'][0]);
  152. $admin = Dever::load('manage/company')->getAdmin($group['id'], $data['group'][1]);
  153. $gad = Dever::db('manage/admin')->find($data['group'][1]);
  154. $res = array();
  155. foreach ($admin as $k => $v) {
  156. $res[$k] = $v['username'].'<br/>'.$v['email'];
  157. }
  158. $total = Dever::db('work/info')->getquestTotal(array('group'=>$data['group'][0]));
  159. $html = array();
  160. $html['group'] = $group['name'].'<br/>'.$gad['username'];
  161. $html['name'] = implode('<br/>',$res);
  162. $html['num'] = $total;
  163. return $html;
  164. }
  165. #获取客户信息
  166. public function search_api()
  167. {
  168. $value = Dever::input('value');
  169. if(!preg_match('/^1[3|5|6|7|8|9]\d{9}$/', $value)){
  170. return '代理商手机号不正确';
  171. }
  172. if ($value) {
  173. $name = '';
  174. $role_name = '';
  175. $user = Dever::db('work/user')->find(array('mobile'=>$value));
  176. if(!$user) {
  177. $member = Dever::db('agent/member')->find(array('mobile'=>$value));
  178. if ($member) {
  179. $name = $member['name'];
  180. $type = "代理商";
  181. $role = Dever::db('setting/role')->find($member['role']);
  182. if ($role ) {
  183. $role_name = $role['name'];
  184. }
  185. $option = Dever::db('option/member')->find(array('mobile'=>$value));
  186. if ($option) {
  187. $type = $type.'<br/>期权账户';
  188. $passport = Dever::db('passport/user')->find(array('mobile'=>$value));
  189. if ($passport) {
  190. $type = $type.'<br/>小程序';
  191. }
  192. } else {
  193. $passport = Dever::db('passport/user')->find(array('mobile'=>$value));
  194. if ($passport) {
  195. $type = $type.'<br/>小程序';
  196. }
  197. }
  198. } else {
  199. $option = Dever::db('option/member')->find(array('mobile'=>$value));
  200. if ($option) {
  201. $name = $option['name'];
  202. $type = '期权账户';
  203. $passport = Dever::db('passport/user')->find(array('mobile'=>$value));
  204. if ($passport) {
  205. $type = $type.'<br/>小程序';
  206. }
  207. } else {
  208. $passport = Dever::db('passport/user')->find(array('mobile'=>$value));
  209. if ($passport) {
  210. $name = $passport['username'];
  211. $type = '小程序';
  212. } else {
  213. $type = '无系统关联关系';
  214. }
  215. }
  216. }
  217. } else {
  218. $name = $user['name'];
  219. $type = '客服系统用户';
  220. if ($user['agent_uid'] && $user['agent_uid'] > 0) {
  221. $member = Dever::db('agent/member')->find($user['agent_uid']);
  222. $role = Dever::db('setting/role')->find($member['role']);
  223. if ($role) {
  224. $role_name = $role['name'];
  225. }
  226. $type = $type.'<br/>代理商';
  227. }
  228. if ($user['option_uid'] && $user['option_uid'] > 0) {
  229. $type = $type.'<br/>期权账户';
  230. }
  231. if ($user['passport_uid'] && $user['passport_uid'] > 0) {
  232. $type = $type.'<br/>小程序';
  233. }
  234. }
  235. $table = array();
  236. if ($name && $role_name) {
  237. $table['head'] = array('名称', '电话号码', '平台' ,'角色');
  238. $table['body'] = array($name, $value, $type, $role_name);
  239. } elseif ($name && !$role_name) {
  240. $table['head'] = array('名称', '电话号码', '平台');
  241. $table['body'] = array($name, $value, $type);
  242. } elseif (!$name && $role_name) {
  243. $table['head'] = array('电话号码', '平台' ,'角色');
  244. $table['body'] = array($value, $type, $role_name);
  245. } else if (!$name && !$role_name) {
  246. $table['head'] = array('电话号码', '平台');
  247. $table['body'] = array($value, $type );
  248. }
  249. $result[] = array
  250. (
  251. 'type' => 'table',
  252. 'content' => $table,
  253. );
  254. $html = Dever::show('', $result, false, false);
  255. return array('html' => $html, 'data' => array('name' => $name));
  256. }
  257. }
  258. public function admin($id)
  259. {
  260. $data = Dever::db('work/product')->find(array($id));
  261. $admin_id = explode(',',$data['admin_id']);
  262. $admin = Dever::db('manage/admin')->find($admin_id[1]);
  263. if ($admin) {
  264. return $admin['username'].'<br/>'.$admin['email'];
  265. }
  266. }
  267. public function branch($id)
  268. {
  269. if (isset($id) && $id) {
  270. $group = Dever::db('manage/group')->find($id);
  271. if (isset($group) && isset($group['name']) && $group['name']) {
  272. return $group['name'];
  273. }
  274. }
  275. }
  276. #工单列表导出
  277. public function out_info($data)
  278. {
  279. $header = array('客户名称','手机号','问题类型','问题类型描述','优先级','问题描述','处理结果','创建时间','完成时间');
  280. $body = array();
  281. $config = Dever::db('work/info')->config['config_status'];
  282. foreach ($data as $k => $v ) {
  283. $cate_name = '';
  284. $cate_id = explode(',',$v['cate_id']);
  285. if (isset($cate_id[0]) && $cate_id[0]) {
  286. $cate = Dever::db('work/q_cate')->find(array('id'=>$cate_id[0]));
  287. if ($cate) {
  288. $cate_name = $cate['name'];
  289. }
  290. }
  291. $question_name = '';
  292. if (isset($cate_id[1]) && $cate_id[1]) {
  293. $question = Dever::db('work/question')->find(array('id'=>$cate_id[1]));
  294. if ($question) {
  295. $question_name = $question['name'];
  296. }
  297. }
  298. $priority_name = '';
  299. $priority = Dever::db('work/priority')->find(array('id'=>$v['priority_id']));
  300. if ($priority) {
  301. $priority_name = $priority['name'];
  302. }
  303. $status_name = Dever::status($config,$v['status']);
  304. $cdate = date('Y-m-d H:i',$v['cdate']);
  305. $fdate = '';
  306. if ($v['fdate']){
  307. $fdate = date('Y-m-d H:i',$v['fdate']);
  308. }
  309. $d = array
  310. (
  311. $v['name'],
  312. $v['mobile'],
  313. $cate_name,
  314. $question_name,
  315. $priority_name,
  316. $v['desc'],
  317. $status_name,
  318. $cdate,
  319. $fdate,
  320. );
  321. $body[] = $d;
  322. }
  323. $file = Dever::input('excel_name');
  324. return Dever::excelExport($body, $header, $file);
  325. }
  326. public function getTotal($admin_id,$status=false)
  327. {
  328. $company = Dever::load('manage/company.get');
  329. $where = array();
  330. if ($status){
  331. $where['status'] = $status;
  332. $where['appoint_id'] = $admin_id;
  333. } else {
  334. $where['audit_admin'] = $admin_id;
  335. }
  336. if ($company) {
  337. $where['company_id'] = $company;
  338. }
  339. $data = Dever::db('work/info')->getTotal($where);
  340. return $data;
  341. }
  342. }