Manage.php 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291
  1. <?php
  2. namespace Work\Lib;
  3. use Dever;
  4. Class Manage
  5. {
  6. public function setInfoStatus_api ()
  7. {
  8. $id = Dever::input('id');
  9. $status = Dever::input('status');
  10. $type = Dever::input('type');
  11. if ($id) {
  12. $data = Dever::db('work/info')->find($id);
  13. $where['where_id'] = $id;
  14. if ($type == 1) {
  15. $where['status'] = 4;
  16. } else {
  17. $where['status'] = 3;
  18. }
  19. $where['fdate'] = time();
  20. $where['chdate'] = time();
  21. Dever::db('work/info')->update($where);
  22. $log = Dever::db('work/info_log')->find(array('info_id'=>$id));
  23. $w['where_id'] = $log['id'];
  24. $w['fdate'] = time();
  25. if($type == 1){
  26. $w['cloce_date'] = time();
  27. }
  28. Dever::db('work/info_log')->update($w);
  29. return 'ok';
  30. }
  31. }
  32. public function updateInfo($id,$name,$data)
  33. {
  34. $mobile = Dever::param('mobile',$data);
  35. $name = Dever::param('name',$data);
  36. $user = Dever::db('work/user')->find(array('mobile'=>$mobile));
  37. if ($name && $user['name'] != $name) {
  38. Dever::db('work/user')->update(array('where_id'=>$user['id'],'name'=>$name));
  39. }
  40. $info = Dever::db('work/info')->find($id);
  41. if ($info && !$info['work_num']) {
  42. $w['where_id'] = $id;
  43. $w['work_num'] = $this->getWorkId();
  44. Dever::db('work/info')->update($w);
  45. }
  46. }
  47. public function getWorkId()
  48. {
  49. $where['work_num'] = Dever::order('W');
  50. $state = Dever::db('work/info')->one($where);
  51. if (!$state) {
  52. return $where['work_num'];
  53. } else {
  54. return $this->getWorkId();
  55. }
  56. }
  57. public function getUser($id)
  58. {
  59. $info = Dever::db('work/info')->find($id);
  60. $data= Dever::db('work/user')->find(array('mobile'=>$info['mobile']));
  61. if ($data) {
  62. $html['user'] = $data['name'].'<br/>'.$data['mobile'];
  63. if (isset($info['fdate']) && $info['fdate']) {
  64. $fdate = date('Y-m-d H:i:s',$info['fdate']);
  65. } else {
  66. $fdate = '';
  67. }
  68. $html['time'] = date('Y-m-d H:i:s',$info['cdate']).'<br/>'.$fdate;
  69. return $html;
  70. } else {
  71. return '';
  72. }
  73. }
  74. public function xietiao_api($id)
  75. {
  76. $data = Dever::db('work/branch')->find($id);
  77. $data['group'] = explode(',',$data['group']);
  78. $group = Dever::db('manage/group')->find($data['group'][0]);
  79. $admin = Dever::load('manage/company')->getAdmin($group['id'], $data['group'][1]);
  80. // Dever::db('manage/admin')->fetchAll('select * from churen_manage_admin where group='.$group['id'].' and id !='.$data['group'][1]);
  81. // state(array('group'=>$group['id']));
  82. $gad = Dever::db('manage/admin')->find($data['group'][1]);
  83. $res = array();
  84. foreach ($admin as $k => $v) {
  85. $res[$k] = $v['username'].'<br/>'.$v['email'];
  86. }
  87. $html = array();
  88. $html['group'] = $group['name'].'<br/>'.$gad['username'];
  89. $html['name'] = implode('<br/>',$res);
  90. return $html;
  91. }
  92. #获取客户信息
  93. public function search_api()
  94. {
  95. $value = Dever::input('value');
  96. if(!preg_match('/^1[3|5|6|7|8|9]\d{9}$/', $value)){
  97. return '代理商手机号不正确';
  98. }
  99. if ($value) {
  100. $user = Dever::db('work/user')->find(array('mobile'=>$value));
  101. if (!$user) {
  102. $uid = $this->member($value);
  103. $user = Dever::db('work/user')->find($uid);
  104. }
  105. if ($user){
  106. $table = array();
  107. $role_name = '';
  108. $type = '';
  109. $table['head'] = array('名称', '电话号码', '平台' ,'角色');
  110. if ($user['agent_uid'] && $user['agent_uid'] > 0) {
  111. $member = Dever::db('agent/member')->find($user['agent_uid']);
  112. if ($member['role']) {
  113. $role = Dever::db('setting/role')->find($member['role']);
  114. if ($role) {
  115. $role_name = $role['name'];
  116. }
  117. }
  118. $type = '代理商';
  119. if ($user['option_uid'] && $user['option_uid']>0) {
  120. $type = $type.'<br/>期权账户';
  121. }
  122. if ($user['passport_uid'] && $user['passport_uid']>0) {
  123. $type = $type.'<br/>小程序';
  124. }
  125. } else {
  126. if ($user['option_uid'] && $user['option_uid']>0) {
  127. $type = '期权账户';
  128. if ($user['passport_uid'] && $user['passport_uid']>0) {
  129. $type = $type.'<br/>小程序';
  130. }
  131. } else {
  132. if ($user['passport_uid'] && $user['passport_uid']>0) {
  133. $type = '小程序';
  134. } else {
  135. return '无系统关联关系';
  136. }
  137. }
  138. }
  139. $table['body'] = array();
  140. $table['body'] = array($user['name'], $user['mobile'], $type, $role_name);
  141. $result[] = array
  142. (
  143. 'type' => 'table',
  144. 'content' => $table,
  145. );
  146. $html = Dever::show('', $result, false, false);
  147. return array('html' => $html, 'data' => array('name' => $user['name']));
  148. }
  149. }
  150. }
  151. private function member($value)
  152. {
  153. $uid ='';
  154. $member = Dever::db('agent/member')->find(array('mobile'=>$value));
  155. if ($member) {
  156. $uid = $this->upUser($member);
  157. }
  158. if ($uid && $uid > 0) {
  159. $option = Dever::db('option/member')->find(array('mobile'=>$value));
  160. $user = Dever::db('work/user')->find($uid);
  161. if ($option) {
  162. $type = $user['type'].',2';
  163. $uid = Dever::db('work/user')->update(array('where_id'=>$uid,'type'=>$type,'option_uid'=>$option['id']));
  164. if ($uid && $uid > 0) {
  165. $passport = Dever::db('passport/user')->find(array('mobile'=>$value));
  166. if ($passport) {
  167. $user = Dever::db('work/user')->find($uid);
  168. $type = $user['type'].',3';
  169. $uid = Dever::db('work/user')->update(array('where_id'=>$uid,'type'=>$type,'passport_uid'=>$passport['id']));
  170. }
  171. }
  172. } else {
  173. $passport = Dever::db('passport/user')->find(array('mobile'=>$value));
  174. $uid = $this->upUser($passport);
  175. }
  176. } else {
  177. $option = Dever::db('option/member')->find(array('mobile'=>$value));
  178. if($option) {
  179. $uid = $this->upUser(false,$option);
  180. $user = Dever::db('work/user')->find($uid);
  181. if ($uid && $uid > 0){
  182. $passport = Dever::db('passport/user')->find(array('mobile'=>$value));
  183. if ($passport) {
  184. $user = Dever::db('work/user')->find($uid);
  185. $type = $user['type'].',3';
  186. $uid = Dever::db('work/user')->update(array('where_id'=>$uid,'type'=>$type,'passport_uid'=>$passport['id']));
  187. }
  188. }
  189. } else {
  190. $passport = Dever::db('passport/user')->find(array('mobile'=>$value));
  191. if ($passport) {
  192. $uid = $this->upUser(false,false,$passport);
  193. }
  194. if (!$uid) {
  195. $uid = Dever::db('work/user')->insert(array('mobile'=>$value));
  196. }
  197. }
  198. }
  199. return $uid;
  200. }
  201. private function upUser($member = false, $option = false, $passport = false)
  202. {
  203. if ($member) {
  204. $w['agent_uid'] = $member['id'];
  205. $w['name'] = $member['name'];
  206. $w['mobile'] = $member['mobile'];
  207. $w['idcard'] = $member['idcard'];
  208. $w['username'] = $member['username'];
  209. $w['avatar'] = $member['avatar'];
  210. $w['type'] = 1;
  211. } elseif ($option) {
  212. $w['option_uid'] = $option['id'];
  213. $w['name'] = $option['name'];
  214. $w['mobile'] = $option['mobile'];
  215. $w['idcard'] = $option['idcard'];
  216. $w['type'] = 2;
  217. } elseif ($passport) {
  218. $w['passport_uid'] = $passport['id'];
  219. $w['name'] = $passport['username'];
  220. $w['mobile'] = $passport['mobile'];
  221. $w['username'] = $passport['truename'];
  222. $w['avatar'] = $passport['avatar'];
  223. }
  224. if ($w) {
  225. $uid = Dever::db('work/user')->insert($w);
  226. return $uid;
  227. }
  228. }
  229. public function admin($id)
  230. {
  231. $data = Dever::db('work/product')->find(array($id));
  232. $admin_id = explode(',',$data['admin_id']);
  233. $admin = Dever::db('manage/admin')->find($admin_id[1]);
  234. if ($admin) {
  235. return $admin['username'].'<br/>'.$admin['email'];
  236. }
  237. }
  238. public function branch($id)
  239. {
  240. $group = Dever::db('manage/group')->find($id);
  241. return $group['name'];
  242. }
  243. #工单列表导出
  244. public function out_info($data)
  245. {
  246. $header = array('客户名称','手机号','问题类型','优先级','问题描述','处理结果','创建时间','完成时间');
  247. $body = array();
  248. $config = Dever::db('work/info')->config['config_status'];
  249. foreach ($data as $k => $v ) {
  250. $cate_name = '';
  251. $cate = Dever::db('work/q_cate')->find(array('id'=>$v['cate_id']));
  252. if ($cate) {
  253. $cate_name = $cate['name'];
  254. }
  255. $priority_name = '';
  256. $priority = Dever::db('work/priority')->find(array('id'=>$v['priority_id']));
  257. if ($priority) {
  258. $priority_name = $priority['name'];
  259. }
  260. $status_name = Dever::status($config,$v['status']);
  261. $cdate = date('Y-m-d H:i',$v['cdate']);
  262. $fdate = '';
  263. if ($v['fdate']){
  264. $fdate = date('Y-m-d H:i',$v['fdate']);
  265. }
  266. $d = array
  267. (
  268. $v['name'],
  269. $v['mobile'],
  270. $cate_name,
  271. $priority_name,
  272. $v['desc'],
  273. $status_name,
  274. $cdate,
  275. $fdate,
  276. );
  277. $body[] = $d;
  278. }
  279. $file = Dever::input('excel_name');
  280. return Dever::excelExport($body, $header, $file);
  281. }
  282. }