get("sms_type"); // 暂时停用 // if ($sms_type == 'mds_meeting') { // return $this->getMdsMeetingInfo($request); // } return [ "code"=>-1, "msg"=>"缺少参数", "data"=>[] ]; } // 麦垛山会议 private function getMdsMeetingInfo(Request $request) { // 会议id $meeting_id = $request->get("meeting_id"); // 通知类型 $notice_type = $request->get("notice_type"); if (empty($meeting_id) || empty($notice_type)) { return [ "code"=>-1, "msg"=>"缺少参数", "data"=>[] ]; } // 获取会议信息 try { $meeting_info = DB::connection('mysql_fwe10')->table('uf_mdshyyy')->where('id', '=', $meeting_id)->first(); } catch (Exception $error) { return [ "code"=>-1, "msg"=>"会议室信息数据连接失败", "data"=>[] ]; } if (empty($meeting_info)) { return [ "code"=>-1, "msg"=>"找不到会议信息", "data"=>[] ]; } $smsServices = new SmsServices(); $meeting_date = date('Y年m月d日 H:i:s', strtotime($meeting_info->ksrq)); // 开始时间 $meeting_title = $meeting_info->hyzt; // 会议主题 $meeting_room_id = $meeting_info->hys; // 会议室id $meeting_room_info = DB::connection('mysql_fwe10')->table('uf_mdshysgl')->where('id', '=', $meeting_room_id)->first(); $meeting_room_name = $meeting_room_info->hysmc; // 会议室名称 if ($notice_type == 1) { // 部门领导审批 // 申请人信息 $apply_user_id = $meeting_info->sqr; $apply_user_info = DB::connection('mysql_fwe10')->table('eteams.employee')->where('id', '=', $apply_user_id)->first(); $apply_user_name = $apply_user_info->USERNAME; // 申请人部门领导 $leader_id = $meeting_info->bmld; $leader_info = DB::connection('mysql_fwe10')->table('eteams.employee')->where('id', '=', $leader_id)->first(); $leader_mobile[] = $leader_info->MOBILE; $template_info[] = [ "username"=>$apply_user_name, "begindate"=>$meeting_date, "meetingname"=>$meeting_title ]; $smsServices->sendBatchSms($leader_mobile, $template_info, 1); return [ "code"=>200, "msg"=>"已发送", "data"=>[ "leader" =>$template_info ] ]; } else if ($notice_type == 2) { // 会议室管理员审批 // 通知类型 $manage_id = $request->get("manage_id"); if (empty($manage_id)) { return [ "code"=>-1, "msg"=>"缺少管理员信息参数", "data"=>[] ]; } // 申请人信息 $apply_user_id = $meeting_info->sqr; $apply_user_info = DB::connection('mysql_fwe10')->table('eteams.employee')->where('id', '=', $apply_user_id)->first(); $apply_user_name = $apply_user_info->USERNAME; // 管理员信息 $leader_info = DB::connection('mysql_fwe10')->table('eteams.employee')->where('id', '=', $manage_id)->first(); $leader_mobile[] = $leader_info->MOBILE; $template_info[] = [ "username"=>$apply_user_name, "begindate"=>$meeting_date, "meetingname"=>$meeting_title ]; $smsServices->sendBatchSms($leader_mobile, $template_info, 1); return [ "code"=>200, "msg"=>"已发送", "data"=>[ "manage" =>$template_info ] ]; } else if ($notice_type == 3) { // 通知参会人员 $attendee = $meeting_info->chry; // 参会人员 $attend_dept = $meeting_info->chbm; // 参会部门 // 参会人信息 $attendee_arr = explode(',', $attendee); $attendee_info = DB::connection('mysql_fwe10')->table('eteams.employee')->where('id', $attendee_arr)->get(); $attendee_mobile = []; $template_info = []; // ${uname},您好,${meetdate} 在“${meetroom}”会议室有主题为“${meetname}”的会议需要您的参加,详情登录安宁查看。 for($i = 0; $i < count($attendee_info); $i++) { $info = $attendee_info[$i]; $attendee_mobile[] = $info->MOBILE; $template_info[] = [ "uname"=>$info->USERNAME, "meetdate"=>$meeting_date, "meetroom"=>$meeting_room_name, "meetname"=>$meeting_title ]; } // 给参会人 发送短信 if (count($template_info) > 0) { $smsServices->sendBatchSms($attendee_mobile, $template_info, 2); } // 参会部门信息 $dept_arr = explode(',', $attend_dept); $dept_info = DB::connection('mysql_fwe10')->table('eteams.department')->where('id', $dept_arr)->get(); $dept_leader = DB::connection('mysql_fwe10') ->table('eteams.employee') ->where("sec_level","=","65") ->where('DEPARTMENT', $attend_dept) ->get(); // 组装部门信息map $dept_info_map = []; for($i = 0; $i < count($dept_info); $i ++) { $info = $dept_info[$i]; $dept_info_map[$info->ID] = $info->NAME; } $attendee_dept_mobile = []; $template_dept_info = []; for($i = 0; $i < count($dept_leader); $i++) { $info = $dept_leader[$i]; $mobile = $info->MOBILE; $attendee_dept_mobile[] = $mobile; // 如果已经给个人发了,就跳过 if (in_array($mobile, $attendee_mobile)) { continue; } // 您好,${meetdate} 在“${meetroom}”会议室有主题为“${meetname}”的会议需要您的部门参加,详情登录安宁查看。 $template_dept_info[] = [ "meetdate"=>$meeting_date, "meetroom"=>$meeting_room_name, "meetname"=>$meeting_title ]; } // 给部门领导发送短信 if (count($template_dept_info) > 0) { $smsServices->sendBatchSms($attendee_dept_mobile, $template_dept_info, 3); } return [ "code"=>200, "msg"=>"已发送", "data"=>[ "attendee" =>$template_info, "dept" => $template_info ] ]; } return [ "code"=>200, "msg"=>"已发送", "data"=>[] ]; } }