From 64a00ecca42ffda234197f070734dfe74972635b Mon Sep 17 00:00:00 2001 From: 6c <420680616@qq.com> Date: 星期五, 30 八月 2024 16:08:08 +0800 Subject: [PATCH] 会议室bug --- src/main/java/com/product/administration/service/ConferenceManagerService.java | 445 +++++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 367 insertions(+), 78 deletions(-) diff --git a/src/main/java/com/product/administration/service/ConferenceManagerService.java b/src/main/java/com/product/administration/service/ConferenceManagerService.java index 5853818..e0c6f5b 100644 --- a/src/main/java/com/product/administration/service/ConferenceManagerService.java +++ b/src/main/java/com/product/administration/service/ConferenceManagerService.java @@ -1,5 +1,7 @@ package com.product.administration.service; +import cn.hutool.core.date.DateUnit; +import cn.hutool.core.date.DateUtil; import cn.hutool.core.util.ObjectUtil; import com.alibaba.fastjson.JSONObject; import com.google.zxing.BarcodeFormat; @@ -7,6 +9,7 @@ import com.google.zxing.MultiFormatWriter; import com.google.zxing.WriterException; import com.google.zxing.common.BitMatrix; +import com.google.zxing.qrcode.decoder.ErrorCorrectionLevel; import com.product.administration.config.CmnConst; import com.product.administration.config.SystemCode; import com.product.administration.service.ide.IConferenceManagerService; @@ -24,17 +27,14 @@ import com.product.core.websocket.service.WebsocketMesssageServiceThread; import com.product.module.sys.entity.SystemUser; import com.product.util.BaseUtil; -import org.apache.poi.hssf.usermodel.HSSFCellStyle; -import org.omg.CORBA.OBJ_ADAPTER; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; -import javax.imageio.ImageIO; -import java.awt.image.BufferedImage; -import java.io.File; + import java.io.IOException; import java.text.DecimalFormat; import java.text.Format; +import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.*; @@ -227,13 +227,12 @@ } StringBuilder bs=new StringBuilder(); - bs.append(" SELECT DISTINCT y.*, g.room_name,g.uuid as meet_room_uuid "); - bs.append(" FROM product_oa_conference_apply y"); - bs.append(" left JOIN product_oa_conference_room_config g "); - bs.append(" on y.meeting_room=g.uuid "); - bs.append(" where DATE_FORMAT(y.start_time,\"%Y-%m-%d\")=?"); + bs.append(" SELECT DISTINCT g.room_name,g.uuid as meet_room_uuid,y.* "); + bs.append(" FROM product_oa_conference_room_config g"); + bs.append(" left JOIN product_oa_conference_apply y "); + bs.append(" on y.meeting_room=g.uuid and DATE_FORMAT(y.start_time,\"%Y-%m-%d\")=? "); if(!StringUtils.isEmpty(meeting_resource)){ - bs.append(" and y.meeting_resource like ? "); + bs.append(" where y.meeting_resource like ? "); } bs.append(" ORDER BY y.start_time"); DataTableEntity dataTableEntity = baseDao.listTable(bs.toString(), param.toArray()); @@ -258,38 +257,50 @@ } baseDao.executeUpdate("update product_oa_conference_apply set status='"+fieldSetEntity1.getString("status")+"' where uuid='"+fieldSetEntity1.getString("uuid")+"'"); } - //鏋勯�犳墍闇�瑕佺殑鏍煎紡 - if(!list.contains(fieldSetEntity.getValue("room_name").toString())){ + + if(ObjectUtil.isNotEmpty(fieldSetEntity.getString("uuid"))){ + //鏋勯�犳墍闇�瑕佺殑鏍煎紡 + if(!list.contains(fieldSetEntity.getValue("room_name").toString())){ + HashMap<String,Object> hashMap=new HashMap<>(); + hashMap.put("room_name",fieldSetEntity.getValue("room_name").toString()); + hashMap.put("uuid",fieldSetEntity.getValue("meet_room_uuid").toString()); + Object getStartTime = dataTableEntity.getData().get(0).getValue("start_time"); + SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + String time = dateFormat.format(getStartTime); + hashMap.put("start_time",time); + list.add(fieldSetEntity.getValue("room_name").toString()); + listDate.add(hashMap); + + } + fieldSetEntity.setValue("parent",fieldSetEntity.getValue("meet_room_uuid").toString()); HashMap<String,Object> hashMap=new HashMap<>(); - hashMap.put("room_name",fieldSetEntity.getValue("room_name").toString()); - hashMap.put("uuid",fieldSetEntity.getValue("meet_room_uuid").toString()); - Object getStartTime = dataTableEntity.getData().get(0).getValue("start_time"); - SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); - String time = dateFormat.format(getStartTime); - hashMap.put("start_time",time); - list.add(fieldSetEntity.getValue("room_name").toString()); + for (int j = 0; j < fieldSetEntity.getValues().keySet().size(); j++) { + if(fieldSetEntity.getValues().keySet().toArray()[j].toString().equals("start_time") || fieldSetEntity.getValues().keySet().toArray()[j].toString().equals("end_time")){ + Object meeting_time = fieldSetEntity.getValue(fieldSetEntity.getValues().keySet().toArray()[j].toString()); + SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + String time = dateFormat.format(meeting_time); + hashMap.put(fieldSetEntity.getValues().keySet().toArray()[j].toString(),time); + if(fieldSetEntity.getValues().keySet().toArray()[j].equals("start_time")){ + hashMap.put("start_date",time); + }else { + hashMap.put("end_date",time); + } + }else { + hashMap.put(fieldSetEntity.getValues().keySet().toArray()[j].toString(),fieldSetEntity.getValue(fieldSetEntity.getValues().keySet().toArray()[j].toString())); + } + + } listDate.add(hashMap); - } - fieldSetEntity.setValue("parent",fieldSetEntity.getValue("meet_room_uuid").toString()); - HashMap<String,Object> hashMap=new HashMap<>(); - for (int j = 0; j < fieldSetEntity.getValues().keySet().size(); j++) { - if(fieldSetEntity.getValues().keySet().toArray()[j].toString().equals("start_time") || fieldSetEntity.getValues().keySet().toArray()[j].toString().equals("end_time")){ - Object meeting_time = fieldSetEntity.getValue(fieldSetEntity.getValues().keySet().toArray()[j].toString()); - SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); - String time = dateFormat.format(meeting_time); - hashMap.put(fieldSetEntity.getValues().keySet().toArray()[j].toString(),time); - if(fieldSetEntity.getValues().keySet().toArray()[j].equals("start_time")){ - hashMap.put("start_date",time); - }else { - hashMap.put("end_date",time); - } - }else { - hashMap.put(fieldSetEntity.getValues().keySet().toArray()[j].toString(),fieldSetEntity.getValue(fieldSetEntity.getValues().keySet().toArray()[j].toString())); + }else { + if(!list.contains(fieldSetEntity.getValue("room_name").toString())){ + HashMap<String,Object> hashMap=new HashMap<>(); + hashMap.put("room_name",fieldSetEntity.getValue("room_name").toString()); + hashMap.put("uuid",fieldSetEntity.getValue("meet_room_uuid").toString()); + list.add(fieldSetEntity.getValue("room_name").toString()); + listDate.add(hashMap); } - } - listDate.add(hashMap); } return listDate; @@ -304,7 +315,7 @@ param.add(meeting_room); param.add(meeting_date); StringBuilder sb=new StringBuilder(); - sb.append(" SELECT b.uuid,b.start_time,b.end_time,b.meeting_topic,b.status, "); + sb.append(" SELECT b.uuid,b.start_time,b.end_time,b.meeting_topic,b.status,b.record_man as record_man_uuid, "); sb.append(" (select user_name from product_sys_users where user_id=b.record_man) as record_man,"); sb.append(" (select user_name from product_sys_users where user_id=b.record_master) as record_master,"); sb.append(" CONCAT(DATE_FORMAT(b.start_time,\"%H-%i-%S\"),'~',DATE_FORMAT(b.end_time,\"%H-%i-%S\")) as time_quantum,"); @@ -339,6 +350,16 @@ String end_time_date = dateFormat.format(end_time); MapValues.put("start_time",start_time_date); MapValues.put("end_time",end_time_date); + } + + Date date = new Date(); + //鏄惁鑳藉鍙栨秷 + if(date.before(fieldSetEntity.getDate("start_time"))){ + MapValues.put("isCancel",true); + } + //鏄惁鎵ц寮�鍚姛鑳� + if(date.before(fieldSetEntity.getDate("start_time")) && fieldSetEntity.getString("status").equals("宸插彇娑�")){ + MapValues.put("isStart",true); } dataList.add(MapValues); } @@ -400,49 +421,285 @@ } @Override - public String getQrCode(FieldSetEntity fse) throws BaseException, WriterException, IOException { - String uuid="96f161b4-6360-40ba-8dc1-72bb39d56be4"; - int BLACK = 0xFF000000; - int WHITE = 0xFFFFFFFF; - Date date = new Date(); - String text = "http://127.0.0.1:9998/lx/api/conference/get_QrCode_Info/v1?uuid=" + uuid+"&date="+date; - String path = "D:/QRCode"; // 鍥剧墖鐢熸垚鐨勪綅缃� - int width = 400; - int height = 400; - // 浜岀淮鐮佸浘鐗囨牸寮� - String format = "jpg"; - // 璁剧疆缂栫爜锛岄槻姝腑鏂囦贡鐮� - Hashtable<EncodeHintType, Object> ht = new Hashtable<EncodeHintType, Object>(); - ht.put(EncodeHintType.CHARACTER_SET, "UTF-8"); - // 璁剧疆浜岀淮鐮佸弬鏁�(缂栫爜鍐呭锛岀紪鐮佺被鍨嬶紝鍥剧墖瀹藉害锛屽浘鐗囬珮搴�,鏍煎紡) - BitMatrix bitMatrix = new MultiFormatWriter().encode(text, BarcodeFormat.QR_CODE, width, height, ht); - // 鐢熸垚浜岀淮鐮�(瀹氫箟浜岀淮鐮佽緭鍑烘湇鍔″櫒璺緞) - File outputFile = new File(path); - if (!outputFile.exists()) { - // 鍒涘缓鏂囦欢澶� - outputFile.mkdir(); - }else { - outputFile.delete(); - outputFile.mkdir(); + public BitMatrix getQrCode(String content) throws BaseException, WriterException, IOException { + + //浜岀淮鐮佺殑瀹介珮 + int width = 200; + int height = 200; + + //鍏朵粬鍙傛暟锛屽瀛楃闆嗙紪鐮� + Map<EncodeHintType, Object> hints = new HashMap<EncodeHintType, Object>(); + hints.put(EncodeHintType.CHARACTER_SET, "UTF-8"); + //瀹归敊绾у埆涓篐 + hints.put(EncodeHintType.ERROR_CORRECTION , ErrorCorrectionLevel.H); + //鐧借竟鐨勫搴︼紝鍙彇0~4 + hints.put(EncodeHintType.MARGIN , 0); + + BitMatrix bitMatrix = null; + try { + + bitMatrix = new MultiFormatWriter().encode(content, + BarcodeFormat.QR_CODE, width, height, hints); + + } catch (WriterException e) { + e.printStackTrace(); } - int b_width = bitMatrix.getWidth(); - int b_height = bitMatrix.getHeight(); - // 寤虹珛鍥惧儚缂撳啿鍣� - BufferedImage image = new BufferedImage(b_width, b_height, BufferedImage.TYPE_3BYTE_BGR); - for (int x = 0; x < b_width; x++) { - for (int y = 0; y < b_height; y++) { - image.setRGB(x, y, bitMatrix.get(x, y) ? BLACK : WHITE); - } - } - // 鐢熸垚浜岀淮鐮� - ImageIO.write(image, format, new File(path + "/code." + format)); - // 浜岀淮鐮佺殑鍚嶇О - // code.jpg - - return path + "/code." + format; + return bitMatrix; } + @Override + public void CancelAndStart(FieldSetEntity fse) throws BaseException { + + String uuid = fse.getString("uuid"); + String filter=" uuid='"+uuid+"'"; + DataTableEntity product_oa_conference_apply = baseDao.listTable("product_oa_conference_apply", filter, new Object[]{}); + if(product_oa_conference_apply.getRows()!=0){ + FieldSetEntity fieldSetEntity = product_oa_conference_apply.getFieldSetEntity(0); + if(fieldSetEntity.getString("status").equals("宸插彇娑�")){ + fieldSetEntity.setValue("status","宸插惎鐢�"); + }else { + fieldSetEntity.setValue("status","宸插彇娑�"); + } + baseDao.update(fieldSetEntity); + } + + } + + @Override + public String ConferenceSign(FieldSetEntity fse) throws BaseException, ParseException { + + + JSONObject jsonObject = new JSONObject(); + if(!StringUtils.isEmpty(fse.getString("uuid"))&&!StringUtils.isEmpty(fse.getString("date"))){ + String uuid = fse.getString("uuid"); + String date = fse.getString("date"); + SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + Date parseDate = dateFormat.parse(date); + long between = DateUtil.between(parseDate, new Date(), DateUnit.SECOND); + + if(between>20){ + jsonObject.put("code","200"); + jsonObject.put("msg","浜岀淮鐮佸凡澶辨晥"); + jsonObject.put("status","fail"); + + }else { + + SystemUser currentUser = SpringMVCContextHolder.getCurrentUser(); + FieldSetEntity fieldSetEntity = new FieldSetEntity(); + fieldSetEntity.setTableName("product_oa_conference_sign"); + fieldSetEntity.setValue("sign_user",currentUser.getUser_name()); + fieldSetEntity.setValue("user_id",currentUser.getUser_id()); + fieldSetEntity.setValue("org_level_uuid","00000000-0000-0000-0000-000000000000"); + fieldSetEntity.setValue("organization",currentUser.getDept_uuid()); + fieldSetEntity.setValue("organization_name",currentUser.getCurrentDept().getString("org_level_name")); + fieldSetEntity.setValue("sign_date",new Date()); + fieldSetEntity.setValue("sign_status","宸茬鍒�"); + fieldSetEntity.setValue("meeting_uuid",uuid); + + BaseUtil.createCreatorAndCreationTime(SpringMVCContextHolder.getCurrentUser(), fse); + baseDao.add(fieldSetEntity); + jsonObject.put("code","200"); + jsonObject.put("msg","绛惧埌鎴愬姛"); + jsonObject.put("status","sucess"); + } + } + + return jsonObject.toString(); + } + + @Override + public HashMap getSignOrVisitInfo(FieldSetEntity fse) throws BaseException { + + String meeting_uuid = fse.getString("meeting_uuid"); + //type=1灏辨槸绛惧埌鏁版嵁锛宼ype=2灏辨槸璁块棶鏁版嵁 + String type = fse.getString("type"); + List<Object> params=new ArrayList<>(); + params.add(meeting_uuid); + params.add(meeting_uuid); + + StringBuilder sb=new StringBuilder(); + sb.append(" SELECT c.* FROM ( "); + sb.append(" SELECT b.staff_id,b.uuid as meeting_uuid,f.show_name,l.uuid as dept_uuid,l.org_level_name,"); + if(type.equals("1")){ + sb.append(" n.sign_status"); + }else { + sb.append(" n.visit_status"); + } + sb.append(" FROM (" ); + sb.append(" SELECT y.*, "); + sb.append(" SUBSTRING_INDEX( SUBSTRING_INDEX( participator, ',', n ), ',', - 1 ) AS staff_id"); + sb.append(" FROM product_oa_conference_apply y, "); + sb.append(" ( SELECT @rownum := @rownum + 1 AS n FROM ( SELECT @rownum := 0 ) r, product_oa_conference_apply ) x "); + sb.append(" WHERE 1 = 1 "); + sb.append(" AND n <= ( LENGTH( participator ) - LENGTH( REPLACE ( participator, ',', '' ) ) + 1 )"); + sb.append(" and y.uuid= ? "); + sb.append(" )b "); + sb.append(" LEFT JOIN product_sys_staffs f on b.staff_id=f.user_id "); + sb.append(" LEFT JOIN product_sys_org_levels l on f.dept_uuid=l.uuid "); + if(type.equals("1")){ + sb.append(" LEFT JOIN product_oa_conference_sign n "); + }else { + sb.append(" LEFT JOIN product_oa_conference_visit n "); + } + sb.append(" on b.staff_id=n.user_id and n.meeting_uuid=? "); + sb.append(" )c"); + + DataTableEntity dataTableEntity = baseDao.listTable(sb.toString(),params.toArray()); + List<HashMap> listDate=new ArrayList<>(); + List<HashMap> listDateSign=new ArrayList<>(); + List<HashMap> listDateNoSign=new ArrayList<>(); + + List<String> list=new ArrayList(); + + int sign_count=0; + int sign_all=0; + int sign_down=0; + HashMap<String,Object> hashMapResult=new HashMap<>(); + for (int i = 0; i < dataTableEntity.getRows(); i++) { + FieldSetEntity fieldSetEntity = dataTableEntity.getFieldSetEntity(i); + + if(!list.contains(fieldSetEntity.getString("org_level_name"))){ + HashMap<String,Object> hashMap=new HashMap<>(); + hashMap.put("dept_uuid",fieldSetEntity.getString("dept_uuid")); + hashMap.put("org_level_name",fieldSetEntity.getString("org_level_name")); + list.add(fieldSetEntity.getString("org_level_name")); + listDate.add(hashMap); + } + + fieldSetEntity.setValue("parent",fieldSetEntity.getString("dept_uuid")); + HashMap<String,Object> hashMap=new HashMap<>(); + for (int j = 0; j < fieldSetEntity.getValues().keySet().size(); j++) { + hashMap.put(fieldSetEntity.getValues().keySet().toArray()[j].toString(),fieldSetEntity.getValue(fieldSetEntity.getValues().keySet().toArray()[j].toString())); + + } + listDate.add(hashMap); + + } + sign_all=listDate.size(); + List<String> list1=new ArrayList(); + List<String> list2=new ArrayList(); + for (int j = 0; j < listDate.size(); j++) { + if((ObjectUtil.isNotEmpty(listDate.get(j).get("sign_status"))&&listDate.get(j).get("sign_status").equals("宸茬鍒�")) || (ObjectUtil.isNotEmpty(listDate.get(j).get("visit_status"))&&listDate.get(j).get("visit_status").equals("宸茶闂�")) ){ + if(!list1.contains(listDate.get(j).get("org_level_name"))){ + list1.add(listDate.get(j).get("org_level_name").toString()); + HashMap<String,Object> hashMap=new HashMap<>(); + hashMap.put("dept_uuid",listDate.get(j).get("dept_uuid")); + hashMap.put("org_level_name",listDate.get(j).get("org_level_name")); + listDateSign.add(hashMap); + } + sign_count++; + //閬垮厤閲嶅娣诲姞閮ㄩ棬 + if(listDate.get(j).size()!=2){ + listDateSign.add(listDate.get(j)); + } + + }else { + if(!list2.contains(listDate.get(j).get("org_level_name"))){ + list2.add(listDate.get(j).get("org_level_name").toString()); + HashMap<String,Object> hashMap=new HashMap<>(); + hashMap.put("dept_uuid",listDate.get(j).get("dept_uuid")); + hashMap.put("org_level_name",listDate.get(j).get("org_level_name")); + listDateNoSign.add(hashMap); + } + //閬垮厤閲嶅娣诲姞閮ㄩ棬 + if(listDate.get(j).size()!=2){ + listDateNoSign.add(listDate.get(j)); + } + + + } + } + sign_down=sign_all-sign_count; + hashMapResult.put("signOrvisit_down",sign_count); + hashMapResult.put("no_signOrvisit",sign_down); + hashMapResult.put("listDateNoSignOrVisit",listDateNoSign); + hashMapResult.put("listDateSignOrVisit",listDateSign); + return hashMapResult; + } + + @Override + public void sendMsg(FieldSetEntity fse) throws BaseException { + + String meeting_uuid= fse.getString("meeting_uuid"); + String type = fse.getString("type"); + String user_ids = fse.getString("user_ids"); + + FieldSetEntity product_oa_conference_apply = baseDao.getFieldSetEntity("product_oa_conference_apply", meeting_uuid, false); + + + //姝ゆ柟寮忔槸鏍规嵁鍚庡彴鑷姩缁熻鏈闂汉鍛� + /* List<Object> params=new ArrayList<>(); + params.add(meeting_uuid); + params.add(meeting_uuid); + + StringBuilder sb=new StringBuilder(); + sb.append(" SELECT c.* FROM ( "); + sb.append(" SELECT b.staff_id,b.uuid as meeting_uuid,f.show_name,l.uuid as dept_uuid,l.org_level_name,"); + if(type.equals("1")){ + sb.append(" n.sign_status"); + }else { + sb.append(" n.visit_status"); + } + sb.append(" FROM (" ); + sb.append(" SELECT y.*, "); + sb.append(" SUBSTRING_INDEX( SUBSTRING_INDEX( participator, ',', n ), ',', - 1 ) AS staff_id"); + sb.append(" FROM product_oa_conference_apply y, "); + sb.append(" ( SELECT @rownum := @rownum + 1 AS n FROM ( SELECT @rownum := 0 ) r, product_oa_conference_apply ) x "); + sb.append(" WHERE 1 = 1 "); + sb.append(" AND n <= ( LENGTH( participator ) - LENGTH( REPLACE ( participator, ',', '' ) ) + 1 )"); + sb.append(" and y.uuid= ? "); + sb.append(" )b "); + sb.append(" LEFT JOIN product_sys_staffs f on b.staff_id=f.user_id "); + sb.append(" LEFT JOIN product_sys_org_levels l on f.dept_uuid=l.uuid "); + if(type.equals("1")){ + sb.append(" LEFT JOIN product_oa_conference_sign n "); + }else { + sb.append(" LEFT JOIN product_oa_conference_visit n "); + } + sb.append(" on b.staff_id=n.user_id and n.meeting_uuid=? "); + sb.append(" )c"); + if(type.equals("1")){ + sb.append(" where c.sign_status is NULL"); + }else { + sb.append(" where c.visit_status is NULL"); + } + + DataTableEntity dataTableEntity = baseDao.listTable(sb.toString(), params.toArray()); + String user_ids = ""; + for (int i = 0; i < dataTableEntity.getRows(); i++) { + FieldSetEntity fieldSetEntity = dataTableEntity.getFieldSetEntity(i); + if((i+1)==dataTableEntity.getRows()){ + user_ids=user_ids+fieldSetEntity.getString("staff_id"); + }else { + user_ids=user_ids+fieldSetEntity.getString("staff_id")+","; + } + + }*/ + String content=""; + if(type.equals("1")){ + content="浼氳灏嗗紑濮嬬鍒�,"+product_oa_conference_apply.getString("meeting_topic")+"-"+product_oa_conference_apply.getString("start_time")+",璇锋寜鏃剁鍒�"; + }else { + content="鎮ㄦ湁鍦轰細璁渶瑕佸弬涓�,"+product_oa_conference_apply.getString("meeting_topic")+"-"+product_oa_conference_apply.getString("start_time")+",璇锋煡鐪嬩細璁鎯�"; + } + SystemUser currentUser = SpringMVCContextHolder.getCurrentUser(); + int user_id = currentUser.getUser_id(); + String send_user=user_id+""; + //String reminder_mode = product_oa_conference_apply.getString("reminder_mode"); + /* //鐭俊 + if(reminder_mode.equals("0")){ + } + //閭欢 + if(reminder_mode.equals("1")){ + + } + //绯荤粺娑堟伅 + if(reminder_mode.equals("2")){ + + }*/ + WebsocketMesssageServiceThread.getInstance().appendMessage(user_ids, content, "浼氳鎻愰啋", 1,"1", "", "", send_user, 1, 0, 0); + + } /** @@ -683,6 +940,38 @@ fieldSetEntity.setValue(CmnConst.CREATED_BY, fieldSetEntity.getString(CmnConst.CREATED_BY + "_save_value")); fieldSetEntity.setValue("meetint_type", fieldSetEntity.getString("meetint_type_save_value")); } + + + //瀛樺偍璁块棶璁板綍 + SystemUser currentUser = SpringMVCContextHolder.getCurrentUser(); + String fliter="meeting_uuid='"+fse.getUUID()+"' and user_id='"+currentUser.getUser_id()+"'"; + DataTableEntity product_oa_conference_visit = baseDao.listTable("product_oa_conference_visit", fliter); + + if(product_oa_conference_visit.getRows()!=0){ + FieldSetEntity fieldSetEntity1 = product_oa_conference_visit.getFieldSetEntity(0); + Integer visit_count = fieldSetEntity1.getInteger("visit_count"); + visit_count++; + fieldSetEntity1.setValue("visit_count",visit_count); + fieldSetEntity1.setValue("visit_date_new",new Date()); + baseDao.update(fieldSetEntity1); + }else { + FieldSetEntity fieldSetEntityVisit = new FieldSetEntity(); + fieldSetEntityVisit.setTableName("product_oa_conference_visit"); + fieldSetEntityVisit.setValue("visit_user",currentUser.getUser_name()); + fieldSetEntityVisit.setValue("user_id",currentUser.getUser_id()); + fieldSetEntityVisit.setValue("org_level_uuid","00000000-0000-0000-0000-000000000000"); + fieldSetEntityVisit.setValue("organization",currentUser.getDept_uuid()); + fieldSetEntityVisit.setValue("organization_name",currentUser.getCurrentDept().getString("org_level_name")); + fieldSetEntityVisit.setValue("visit_date_first",new Date()); + fieldSetEntityVisit.setValue("visit_date_new",new Date()); + fieldSetEntityVisit.setValue("visit_count",1); + fieldSetEntityVisit.setValue("visit_status","宸茶闂�"); + fieldSetEntityVisit.setValue("meeting_uuid",fse.getUUID()); + BaseUtil.createCreatorAndCreationTime(SpringMVCContextHolder.getCurrentUser(), fieldSetEntityVisit); + baseDao.add(fieldSetEntityVisit); + } + + return fieldSetEntity; } -- Gitblit v1.9.2