Dingding.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293
  1. <?php
  2. namespace app\admin\controller\qingdong\dingding;
  3. use addons\qingdong\library\Ding;
  4. use app\common\controller\Backend;
  5. use addons\qingdong\model\StaffDepartment;
  6. use addons\qingdong\model\DingStaff;
  7. use addons\qingdong\model\DingCustomer;
  8. use addons\qingdong\model\DingContacts;
  9. use addons\qingdong\model\DingRecord;
  10. /**
  11. * 钉钉同步
  12. *
  13. */
  14. class Dingding extends Backend
  15. {
  16. public function __construct(){
  17. date_default_timezone_set('Asia/Shanghai');
  18. $ding=new Ding();
  19. //获取access_token
  20. $token = $ding->getAccessToken();
  21. if($token->errcode != 0){
  22. $this->error($token->errmsg);
  23. }
  24. $this->access_token = $token->access_token;
  25. }
  26. /**
  27. * 获取部门
  28. */
  29. public function index(){
  30. $ding=new Ding();
  31. $accessToken = $this->access_token;
  32. //获取部门
  33. $department = $ding->departmentInfo($accessToken);
  34. if($department->errcode != 0){
  35. $this->error($department->errmsg);
  36. }
  37. foreach($department->result as $k=>$v){
  38. $departmentData = StaffDepartment::where(array('id'=>$v->dept_id))->find();
  39. if($departmentData){
  40. continue;
  41. }
  42. $deRes = array(
  43. 'id'=>$v->dept_id,
  44. 'name'=>$v->name,
  45. );
  46. $departmentInfo = StaffDepartment::create($deRes);
  47. //查找他的下级部门
  48. if($departmentInfo){
  49. $dept_id = $v->dept_id;
  50. $this->deepDep($accessToken,$dept_id);
  51. }
  52. }
  53. $this->success('同步成功');
  54. }
  55. //递归获取子部门
  56. public function deepDep($accessToken,$depid=0,&$arr=[]){
  57. $ding=new Ding();
  58. //获取部门
  59. $department = $ding->departmentInfo($accessToken,$depid);
  60. if($department->errcode != 0){
  61. $this->error($department->errmsg);
  62. }
  63. if(count($department->result)>0){
  64. foreach($department->result as $k=>$v){
  65. $arr[] = $v;
  66. $deRes1 = array(
  67. 'id'=>$v->dept_id,
  68. 'pid'=>$v->parent_id,
  69. 'name'=>$v->name,
  70. );
  71. StaffDepartment::create($deRes1);
  72. $this->deepDep($accessToken,$v->dept_id,$arr);
  73. }
  74. }
  75. return $arr;
  76. }
  77. /**
  78. * 获取员工
  79. */
  80. public function staffinfo(){
  81. $ding=new Ding();
  82. $accessToken = $this->access_token;
  83. $department = StaffDepartment::where(array('type'=>0))->select();
  84. if(!$department){
  85. $this->error('部门为空,请先同步部门');
  86. }
  87. foreach($department as $k=>$v){
  88. $staff =$ding->staffInfo($accessToken,$v['id']);
  89. if($staff->errcode != 0 || !$staff->result->list){
  90. continue;
  91. }
  92. foreach($staff->result->list as $ks=>$vs){
  93. //重复员工记录不存储
  94. $staffFind = DingStaff::where(array('user_id' =>$vs->userid,'type'=>0))->find();
  95. if($staffFind){
  96. continue;
  97. }
  98. $resmobile = $ding->staffInfoDetail($accessToken,$vs->userid);
  99. $mobile = '';
  100. if($resmobile->errcode == 0){
  101. if(property_exists($resmobile->result,'mobile')){
  102. $mobile =$resmobile->result->mobile;
  103. }
  104. }
  105. $staffUser = array(
  106. 'dept_id' =>$v['id'],
  107. 'user_id' =>$vs->userid,
  108. 'name' =>filter_Emoji($vs->name),
  109. 'mobile' => $mobile,
  110. 'status' =>0,
  111. );
  112. DingStaff::create($staffUser);
  113. }
  114. }
  115. $this->success('同步成功');
  116. }
  117. /**
  118. * 批量获取客户
  119. */
  120. public function customer(){
  121. $ding=new Ding();
  122. $accessToken = $this->access_token;
  123. $DingStaff = DingStaff::where(array('type'=>0))->select();
  124. if(!$DingStaff){
  125. $this->error('员工为空,请先同步员工为空');
  126. }
  127. foreach($DingStaff as $k=>$v){
  128. $customer = $ding->customerBatch($accessToken,$v['user_id']);
  129. if($customer->errcode != 0 || !$customer->result->values){
  130. continue;
  131. }
  132. foreach($customer->result->values as $ks=>$vs){
  133. $customerFind = DingCustomer::where(array('instance_id'=>$vs->instance_id,'type'=>0))->find();
  134. if($customerFind){
  135. continue;
  136. }
  137. $data = json_decode($vs->data,true);
  138. $instance_id = $vs->instance_id;
  139. $customers = isset($data['customer_name']) ? $data['customer_name'] : '';
  140. $adressinfo = isset($data['address']['extendValue']) ? json_decode($data['address']['extendValue'],true) : '';
  141. $address_detail = '';
  142. $address = '';
  143. if($adressinfo){
  144. $province = isset($adressinfo['province']['name']) ? $adressinfo['province']['name'] : '';
  145. $city = isset($adressinfo['city']['name']) ? $adressinfo['city']['name'] : '';
  146. $district = isset($adressinfo['district']['name']) ? $adressinfo['district']['name'] : '';
  147. $address_detail = isset($adressinfo['detail']['name']) ? $adressinfo['detail']['name'] : '';
  148. $address = $province.$city.$district;
  149. }
  150. $remark = isset($data['TextareaField-K55CWZ2E']) ? $data['TextareaField-K55CWZ2E'] : '';
  151. $source = isset($data['DDSelectField-K2U5GX3B']['value']) ? $data['DDSelectField-K2U5GX3B']['value'] : '';
  152. $owner_staff_id=$vs->permission->owner_userid_list[0];
  153. $create_staff_id=$vs->creator_userid;
  154. $createtime = strtotime($vs->gmt_create);
  155. $updatetime = strtotime($vs->gmt_modified);
  156. $customerData = array(
  157. 'instance_id'=>$instance_id,
  158. 'user_id'=>$create_staff_id,
  159. 'name'=>$customers,
  160. 'address'=>$address,
  161. 'address_detail'=>$address_detail,
  162. 'source'=>$source,
  163. 'remark'=>$remark,
  164. 'owner_staff_id'=>$owner_staff_id,
  165. 'create_staff_id'=>$create_staff_id,
  166. 'createtime'=>$createtime,
  167. 'updatetime'=>$updatetime,
  168. );
  169. DingCustomer::create($customerData);
  170. }
  171. }
  172. $this->success('同步成功');
  173. }
  174. /**
  175. * 批量获取联系人
  176. */
  177. public function contacts(){
  178. $ding=new Ding();
  179. $accessToken = $this->access_token;
  180. $DingStaff = DingStaff::where(array('type'=>0))->select();
  181. if(!$DingStaff){
  182. $this->error('员工为空,请先同步员工为空');
  183. }
  184. foreach($DingStaff as $k=>$v){
  185. $customer = $ding->contactsBatch($accessToken,$v['user_id']);
  186. if($customer->errcode != 0 || !$customer->result->values){
  187. continue;
  188. }
  189. foreach($customer->result->values as $ks=>$vs){
  190. $customerFind = DingContacts::where(array('instance_id'=>$vs->instance_id))->find();
  191. if($customerFind){
  192. continue;
  193. }
  194. $data = json_decode($vs->data,true);
  195. $contact_related_customer = json_decode($data['contact_related_customer']['extendValue'],true);
  196. $instanceId = isset($contact_related_customer['list'][0]['instanceId']) ? $contact_related_customer['list'][0]['instanceId'] : '';
  197. if(!$instanceId){
  198. continue;
  199. }
  200. $customerId = DingCustomer::where(array('instance_id'=>$instanceId))->value('id');
  201. if(!$customerId){
  202. continue;
  203. }
  204. $instance_id = $vs->instance_id;
  205. $contact_name = isset($data['contact_name']) ? $data['contact_name'] : '';
  206. $post = isset($data['contact_position']['extendValue']) ? json_decode($data['contact_position']['extendValue'],true)[0]['label'] : '';
  207. $email = isset($data['TextField-K55DPXC9']) ? $data['TextField-K55DPXC9'] : '';
  208. $mobile = isset($data['contact_phone']['value']) ? $data['contact_phone']['value'] : '';
  209. $remark = isset($data['TextareaField-K2UG1B59']) ? $data['TextareaField-K2UG1B59'] : '';
  210. $owner_staff_id=$vs->permission->owner_userid_list[0];
  211. $create_staff_id=$vs->creator_userid;
  212. $createtime = strtotime($vs->gmt_create);
  213. $updatetime = strtotime($vs->gmt_modified);
  214. $customerData = array(
  215. 'instance_id'=>$instance_id,
  216. 'customer_id'=>$customerId,
  217. 'name'=>$contact_name,
  218. 'post'=>$post,
  219. 'email'=>$email,
  220. 'mobile'=>$mobile,
  221. 'remarks'=>$remark,
  222. 'owner_staff_id'=>$owner_staff_id,
  223. 'create_staff_id'=>$create_staff_id,
  224. 'createtime'=>$createtime,
  225. 'updatetime'=>$updatetime,
  226. );
  227. DingContacts::create($customerData);
  228. }
  229. }
  230. $this->success('同步成功');
  231. }
  232. /**
  233. * 批量获取跟进记录
  234. */
  235. public function record(){
  236. $ding=new Ding();
  237. $accessToken = $this->access_token;
  238. $DingStaff = DingStaff::select();
  239. if(!$DingStaff){
  240. $this->error('员工为空,请先同步员工为空');
  241. }
  242. foreach($DingStaff as $k=>$v){
  243. $customer = $ding->recordBatch($accessToken,$v['user_id']);
  244. if($customer->errcode != 0 || !$customer->result->values){
  245. continue;
  246. }
  247. foreach($customer->result->values as $ks=>$vs){
  248. $customerFind = DingRecord::where(array('instance_id'=>$vs->instance_id))->find();
  249. if($customerFind){
  250. continue;
  251. }
  252. $data = json_decode($vs->data,true);
  253. $contact_related_customer = json_decode($data['follow_record_related_customer']['extendValue'],true);
  254. $instanceId = isset($contact_related_customer['list'][0]['instanceId']) ? $contact_related_customer['list'][0]['instanceId'] : '';
  255. if(!$instanceId){
  256. continue;
  257. }
  258. $customerId = DingCustomer::where(array('instance_id'=>$instanceId))->value('id');
  259. if(!$customerId){
  260. continue;
  261. }
  262. $instance_id = $vs->instance_id;
  263. $content = isset($data['TextareaField-K2U5UJAF']) ? $data['TextareaField-K2U5UJAF'] : '';
  264. $create_staff_id=$vs->creator_userid;
  265. $createtime = strtotime($vs->gmt_create);
  266. $updatetime = strtotime($vs->gmt_modified);
  267. $customerData = array(
  268. 'instance_id'=>$instance_id,
  269. 'customer_id'=>$customerId,
  270. 'content'=>$content,
  271. 'create_staff_id'=>$create_staff_id,
  272. 'createtime'=>$createtime,
  273. 'updatetime'=>$updatetime,
  274. );
  275. DingRecord::create($customerData);
  276. }
  277. }
  278. $this->success('同步成功');
  279. }
  280. }