4             i           " "   " ,          K          K     K     R T T T T K T  T              K  T              ,                             !"#$% &'( ) * +, -. /01 2 3 4 &56   78 9 2: ;< => ? @  AB CD AEF  T  GVW HI J K LQ9 M: N O PQ RSTUVWXbaseDao%Lcom/bcxin/survey/dao/report/BaseDao;RuntimeVisibleAnnotationsLjavax/annotation/Resource; commonService(Lcom/bcxin/survey/service/CommonService;8Lorg/springframework/beans/factory/annotation/Autowired;surveyTaskService3Lcom/bcxin/survey/service/wechat/SurveyTaskService;surveyFeedBackService7Lcom/bcxin/survey/service/wechat/SurveyFeedBackService;surveyQuestionnaireService()VCodeLineNumberTableLocalVariableTablethis7Lcom/bcxin/survey/service/wechat/SurveyPlanServiceImpl; saveOrUpdate.(Lcom/bcxin/survey/domain/survey/SurveyPlan;)ZeLjava/lang/Exception; surveyPlan+Lcom/bcxin/survey/domain/survey/SurveyPlan;flagZ StackMapTableVdeletefindSurveyPlanByOid.(J)Lcom/bcxin/survey/domain/survey/SurveyPlan;oidJfindSurveyPlanByTaskId(J)Ljava/util/List;taskId criterionListLjava/util/List; orderListLocalVariableTypeTable5Ljava/util/List;1Ljava/util/List; Signature@(J)Ljava/util/List;findSurveyPlanBySurveyTaskId"(Ljava/lang/Long;)Ljava/util/List;mapLjava/util/Map;objLjava/lang/Object; surveyTaskIdLjava/lang/Long;sqlLjava/lang/String;list5Ljava/util/Map;$Ljava/util/List;%YZW6(Ljava/lang/Long;)Ljava/util/List;editSurveyPlanE(Lcom/bcxin/survey/domain/survey/SurveyPlan;)Lnet/sf/json/JSONObject;planq5Lcom/bcxin/survey/domain/survey/Survey_Questionnaire; activityVenue0Lcom/bcxin/survey/domain/activity/ActivityVenue;fb0Lcom/bcxin/survey/domain/survey/Survey_FeedBack; surveyTask+Lcom/bcxin/survey/domain/survey/SurveyTask; feedBackList beginTimeendTimecontentmodel Lcom/bcxin/survey/vo/EmailModel;msg*Lcom/bcxin/survey/domain/activity/Message;pm'Lcom/bcxin/survey/domain/security/User; surveyTimeorg&Lcom/bcxin/survey/domain/security/Org;serviceOrgRegister userTypeListserviceOrgPersonList activityUserstepvenue(Lcom/bcxin/survey/domain/activity/Venue;venue1activity+Lcom/bcxin/survey/domain/activity/Activity;task%Lcom/bcxin/survey/domain/report/Task;userfeedBack questionnaireoldQuestionnaireLnet/sf/json/JSONObject; statusCodemessage operationTypeBLjava/util/List;BLjava/util/List;$Ljava/util/List;9Ljava/util/List;[\]^_findSurveyPlanByTaskAndTimeY(Lcom/bcxin/survey/domain/survey/SurveyTask;I)Lcom/bcxin/survey/domain/survey/SurveyPlan;timeI=Ljava/util/List;findSurveyPlanListByUserAndDateY(Lcom/bcxin/survey/domain/security/User;Ljava/util/Date;Ljava/util/Date;)Ljava/util/List;Ljava/util/Date;(Lcom/bcxin/survey/domain/security/User;Ljava/util/Date;Ljava/util/Date;)Ljava/util/List;planListForSort(J)VplanList findSurveyPlanListBySurveyTaskIdfindSurveyPlanByTaskIdAndTime/(JI)Lcom/bcxin/survey/domain/survey/SurveyPlan; surveyPlansfindSurveyPlanListByFeedBackId feedBackId2(Ljava/lang/Long;Ljava/lang/Long;)Ljava/util/List;venueId_(Ljava/lang/Long;Ljava/lang/Long;)Ljava/util/List;#findSurveyPlanListByQuestionnaireIdquestionnaireIdO(Ljava/lang/Long;)Ljava/util/List; SourceFileSurveyPlanServiceImpl.java(Lorg/springframework/stereotype/Service;:Lorg/springframework/transaction/annotation/Transactional; java/util/Date `a b cjava/lang/Exception d  c)com/bcxin/survey/domain/survey/SurveyPlane fg hijava/util/ArrayListsurveyTask.oidj klY mno pq rsoselect A.oid,A.time, case A.surveyStep when 'FIRST' then 1 when 'SECOND' then 2 when 'THIRD' then 3 else '' end surveyStep, case when A.allDay=1 then DATE_FORMAT(A.beginTime,'%Y-%m-%d') else DATE_FORMAT(A.beginTime,'%Y-%m-%d %H:%i') end as beginTime,-- 踏勘开始时间 case when A.allDay=1 then DATE_FORMAT(A.endTime,'%Y-%m-%d') else DATE_FORMAT(A.endTime,'%Y-%m-%d %H:%i') end as endTime, -- 踏勘结束时间 act.sponsor as contacts, B.contactMobile, A.taskStatus, D.`name` as venueName, E.tkExpert from RISK_SurveyPlan A inner join risk_surveytask B on A.taskId=B.oid inner join sys_venue D on D.oid=A.venueId inner join risk_activity act on act.oid=B.activityId left join( select M.surveyStep,M.taskId,CONCAT(N.realName,' ',N.phone) as tkExpert from risk_survey_expert M,risk_se_user N where M.expertUserId=N.oid ) E on (E.taskId=B.taskId and A.surveyStep=E.surveyStep)java/lang/StringBuilder tu where B.oid= tv wx order by B.oid,A.time ascy z{ |}Z ~  java/util/Map taskStatus ntaskStatusName h  tkExpert--net/sf/json/JSONObject300添加   '勘查时间应该晚于当前时间! -勘查开始时间应该小于结束时间!      \   gh修改   [  .com/bcxin/survey/domain/survey/Survey_FeedBack   n  .com/bcxin/survey/domain/activity/ActivityVenue3com/bcxin/survey/domain/survey/Survey_Questionnaire  a                    x    a a 200 pq0成功,现场勘查前还需维护勘查问卷  x     ]    com/bcxin/survey/utils/DateUtil yyyy-MM-dd ~yyyy-MM-dd HH:mm    com/bcxin/survey/utils/DictConst81819_ %com/bcxin/survey/domain/security/User x已为新增计划。勘查时间:,勘查地点:。 xcom/bcxin/survey/utils/ConstPSSTKB09java/lang/String com/bcxin/survey/vo/EmailModel已新增勘查计划   。【 x】  x  (com/bcxin/survey/domain/activity/Message 0 新增了勘查计划  立即查看 /survey/task/detail/^      !  失败 q f r  h l l s   feedBack.oid venue.oidquestionnaire.oid5com/bcxin/survey/service/wechat/SurveyPlanServiceImpljava/lang/Object1com/bcxin/survey/service/wechat/SurveyPlanServicejava/util/Listjava/util/Iterator)com/bcxin/survey/domain/survey/SurveyTask&com/bcxin/survey/domain/activity/Venue)com/bcxin/survey/domain/activity/Activity#com/bcxin/survey/domain/report/Task$com/bcxin/survey/domain/security/Org setUpdateOn(Ljava/util/Date;)V#com/bcxin/survey/dao/report/BaseDao(Ljava/lang/Object;)VprintStackTracejava/lang/LongvalueOf(J)Ljava/lang/Long;get5(Ljava/lang/Class;Ljava/lang/Long;)Ljava/lang/Object;$org/hibernate/criterion/RestrictionseqP(Ljava/lang/String;Ljava/lang/Object;)Lorg/hibernate/criterion/SimpleExpression;add(Ljava/lang/Object;)Zorg/hibernate/criterion/Orderasc3(Ljava/lang/String;)Lorg/hibernate/criterion/Order;findByCriterionC(Ljava/lang/Class;Ljava/util/List;Ljava/util/List;)Ljava/util/List;append-(Ljava/lang/String;)Ljava/lang/StringBuilder;-(Ljava/lang/Object;)Ljava/lang/StringBuilder;toString()Ljava/lang/String; com/bcxin/survey/dao/QueryHelper findBySql3(Ljava/lang/String;Ljava/util/Map;)Ljava/util/List;iterator()Ljava/util/Iterator;hasNext()Znext()Ljava/lang/Object; containsKey&(Ljava/lang/Object;)Ljava/lang/Object;,com/bcxin/survey/enums/report/PlanStatusEnumgetAlias&(Ljava/lang/String;)Ljava/lang/String;put8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; getBeginTime()Ljava/util/Date;getTime()Jjava/lang/SystemcurrentTimeMillis getEndTime getSurveyTask-()Lcom/bcxin/survey/domain/survey/SurveyTask; getSurveyStep,()Lcom/bcxin/survey/enums/report/SurveyStep;5com/bcxin/survey/service/wechat/SurveyFeedBackServicefindSurveyFeedBackByTaskAndStep(Lcom/bcxin/survey/domain/survey/SurveyTask;Lcom/bcxin/survey/enums/report/SurveyStep;)Lcom/bcxin/survey/domain/survey/Survey_FeedBack;getOid()Ljava/lang/Long; longValuegetVenue*()Lcom/bcxin/survey/domain/activity/Venue;:com/bcxin/survey/service/wechat/SurveyQuestionnaireService)findQuestionnaireByFeedBackIdAndAddressId9(JJ)Lcom/bcxin/survey/domain/survey/Survey_Questionnaire;()I1com/bcxin/survey/service/wechat/SurveyTaskServicefindSurveyTaskByOid.(J)Lcom/bcxin/survey/domain/survey/SurveyTask;findSurvey_FeedBackByTaskId0com/bcxin/survey/enums/report/FeedBackStatusEnumNON2Lcom/bcxin/survey/enums/report/FeedBackStatusEnum; getTaskStatus4()Lcom/bcxin/survey/enums/report/FeedBackStatusEnum;equals getActivity-()Lcom/bcxin/survey/domain/activity/Activity;/com/bcxin/survey/service/report/ActivityServicefindActivityVenuesByActivity=(Lcom/bcxin/survey/domain/activity/Activity;)Ljava/util/List;setVenue+(Lcom/bcxin/survey/domain/activity/Venue;)V setCreateOn setFeedBack3(Lcom/bcxin/survey/domain/survey/Survey_FeedBack;)V setSurveyStep-(Lcom/bcxin/survey/enums/report/SurveyStep;)V0com/bcxin/survey/enums/report/QuestionStatusEnum2Lcom/bcxin/survey/enums/report/QuestionStatusEnum; setTaskStatus5(Lcom/bcxin/survey/enums/report/QuestionStatusEnum;)V8(Lcom/bcxin/survey/domain/survey/Survey_Questionnaire;)ZgetQuestionnaire7()Lcom/bcxin/survey/domain/survey/Survey_Questionnaire;getUser)()Lcom/bcxin/survey/domain/security/User;setUser*(Lcom/bcxin/survey/domain/security/User;)V setSurveyTask.(Lcom/bcxin/survey/domain/survey/SurveyTask;)V.Lcom/bcxin/survey/enums/report/PlanStatusEnum;1(Lcom/bcxin/survey/enums/report/PlanStatusEnum;)VsetTime(I)VCOMPLETE5(Lcom/bcxin/survey/enums/report/FeedBackStatusEnum;)V3(Lcom/bcxin/survey/domain/survey/Survey_FeedBack;)Z4()Lcom/bcxin/survey/enums/report/QuestionStatusEnum;CONTINUEsetQuestionnaire8(Lcom/bcxin/survey/domain/survey/Survey_Questionnaire;)V getRemark setRemark(Ljava/lang/String;)VisAllDay setAllDay(Z)V setBeginTime setEndTime(com/bcxin/survey/enums/report/SurveyStepFIRST*Lcom/bcxin/survey/enums/report/SurveyStep;getNameSECONDTHIRDselectVenueById:(Ljava/lang/Long;)Lcom/bcxin/survey/domain/activity/Venue;(com/bcxin/survey/utils/SurveyManagerUtilselectActivityX(Lcom/bcxin/survey/domain/survey/SurveyTask;)Lcom/bcxin/survey/domain/activity/Activity;findActivityByOid=(Ljava/lang/Long;)Lcom/bcxin/survey/domain/activity/Activity;selectTaskBySurveyTaskR(Lcom/bcxin/survey/domain/survey/SurveyTask;)Lcom/bcxin/survey/domain/report/Task;$com/bcxin/survey/service/UserServicegetCurrentUserconvertDateToString6(Ljava/util/Date;Ljava/lang/String;)Ljava/lang/String;&com/bcxin/survey/service/CommonServicegetOrgS(Lcom/bcxin/survey/domain/activity/Activity;)Lcom/bcxin/survey/domain/security/Org;selectServiceOrgRegisterO(Lcom/bcxin/survey/domain/security/Org;)Lcom/bcxin/survey/domain/security/User;selectServiceOrgPersonByList2(Ljava/util/List;Ljava/lang/Long;)Ljava/util/List; getRealNamegetPhone&com/bcxin/survey/service/NotifyService sendHuaWeiSMS^(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)V setSubject*com/bcxin/survey/enums/report/EmailMsgType SURVEYTASK,Lcom/bcxin/survey/enums/report/EmailMsgType; setEmailType/(Lcom/bcxin/survey/enums/report/EmailMsgType;)V"com/bcxin/survey/utils/sms/SMSUtil platFormName setContentgetEmailsetTo sendEmail#(Lcom/bcxin/survey/vo/EmailModel;)V setUser_id(Ljava/lang/Long;)V setReadStatussetTitle setKeywordsetUrl"com/bcxin/survey/utils/DynamicUtilgetBean&()Lcom/bcxin/survey/utils/DynamicUtil;4com/bcxin/survey/domain/dynamic/DynamicTemplateConstDYNAMIC_TEMP_KANCHA_400010saveTKPlanData(Lcom/bcxin/survey/domain/security/User;Ljava/lang/Long;Ljava/lang/Long;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V$checkFeedBackStatusByQuestionnaireIdjava/lang/Integer(I)Ljava/lang/Integer;3(Ljava/lang/Class;Ljava/util/List;)Ljava/util/List;size(I)Ljava/lang/Object;geleorg/hibernate/NullPrecedenceLASTLorg/hibernate/NullPrecedence;nulls?(Lorg/hibernate/NullPrecedence;)Lorg/hibernate/criterion/Order;! /*+ #=+Y*+ N-="IK LPMNO!Q*##!  =*+ N= VX [YZ\*   G*   a J YN- W Y:WW* -hij!k.l;m*JJB!)B!)cMY,+MY,M,N-: S!:":#$%#&'()W*&*+)W-2 w/8SZf>Z=SD !"#8d$Z=%8d$&@'()>*+,-. D Ի,Y-M.N/:0:+123 4:+12+52 6:*7+8+9::*;<=+>?=@:: +A*+8+BC:5D:*+A=E:*FGH=I: *7GH=J:  :   !K: L MN*O PQ:: |!R:*;<=S?=@:ǻTYU:SVYW X YZ[\*;]W@*;<=+>?=@:^: 2 Y_:Y`+ab+8cde+9f+BghMiNLj*7kW%lmno\*;]Wp+>q+rs+tu+1v+5w*xyN*+8H=zY{:,|+8H}W8:  /: +9~~: 0+9: +9 : >: *O ?: * :*O:* :*: /:+t7+1:+5:Y:4+1:+5:Y:*:*: Y:WWW*:W:W: !:Y  :*YSYSYSY SY:YY  *Y:Y  YY¶öY*  ȧYɶ:-yʙE @ l[n lon$ ˶̚*7 ˶=,-}W,}W, !(:ATqt{ *HMPYcov !-@HT[dmv"2=MXc w {   (!:#D&K(U*t,-.0123V4o3r5|69:;<=<>?@*A6BADDG]K`LvNOPQUVW~&/HL01*j23 $45 67 8 &9#:#&9#:#;#H<=>?t@A{B#iCD\EA SF:#GKHAI# ";JK 2+LK = MNXOPcQA67 TmR5qPS1tMT1 $/U V#W#X#* $Y8Z  SF[:#G\(]'''J ]'''^__J ]'''^__`()<^();a_F ]'''^__`()3:&`']'''^__`'bbcde'0v]'''^__`'bbcde'fe((e) ]'''^__) ]'''ghS YN-+HW-иW* -: [\](^6_E`Qb4SS67SijK6$K6$k Q((lmf Y:+W,ֹW-عW Y:WW* "i jk%l3m<nIoVp>ffQAf9nf:n ]<* ]<*opq<*N6-: #! :g*xWٱ"uv w'x.y5z8{;|4'<<6r 3ij 6rk())sP YN- W Y:ոڶ۹WW* -!4A*PPH!/H!/tuW Y: WиW* :  +:IU4WWWij N:v N:vk U((w}% YN- W* - %%x wy/ YN-+W-,W* -"*//x!/z!' '{|z" YM,+W* , ""}! ~