Manage.php 12 KB

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