java 时间转为毫秒数_java后端把毫秒数转化成日期的方法----java中实现日期的加减...

id, jhcj, jmcj, zhcj, ccwl, tzsb, bjss, xcwx, pcyh, gwfx, tcj, tszysl, gsm, tszynr,

zjl, tbr, ggrq, status, cjr, cjsj, xgsj, xgr, delete_status,zx

selectfrom wp_fxcns

where id= #{id,jdbcType=VARCHAR}

SELECT DISTINCT f.id, jhcj, jmcj, zhcj, ccwl, tzsb, bjss, xcwx, pcyh, gwfx, tcj, tszysl, gsm, tszynr,

zjl, tbr, ggrq, d.`name` gsmc, d1.`name` gwfxmc,d2.name tcjmc, u.`name` tbrmc, FROM_UNIXTIME(f.ggrq/1000, "%Y-%m-%d") ggrqStr, w.`status` status,

w.id AS processinstId,f.cjsj

from wp_fxcns f-- join base_data_table bdt on bdt.tableid=f.id

LEFT JOIN base_data_dictionary d on f.gsm=d.id

LEFT JOIN base_data_dictionary d1 on f.gwfx=d1.id

LEFT JOIN base_data_dictionary d2 on f.tcj=d2.id

LEFT JOIN base_user u on f.tbr=u.id

INNER JOIN wf_processinst w on f.id=w.business_Id

where f.id= #{id,jdbcType=VARCHAR}

AND judgeDataPermission(f.id,#{id},f.cjr)=1

SELECT DISTINCT f.id, jhcj, jmcj, zhcj, ccwl, tzsb, bjss, xcwx, pcyh, gwfx, tcj, tszysl, gsm, tszynr,

zjl, tbr, ggrq, d.`name` gsmc, d1.`name` gwfxmc,d2.name tcjmc, u.`name` tbrmc, FROM_UNIXTIME(f.ggrq/1000, "%Y-%m-%d") ggrqStr, w.`status` status,

w.id AS processinstId,f.cjsj

from wp_fxcns f-- join base_data_table bdt on bdt.tableid=f.id

LEFT JOIN base_data_dictionary d on f.gsm=d.id

LEFT JOIN base_data_dictionary d1 on f.gwfx=d1.id

LEFT JOIN base_data_dictionary d2 on f.tcj=d2.id

LEFT JOIN base_user u on f.tbr=u.id

INNER JOIN wf_processinst w on f.id=w.business_Id

where1=1

AND f.jhcj LIKE CONCAT(CONCAT('%',#{jhcj,jdbcType=VARCHAR},'%'))

AND f.jmcj LIKE CONCAT(CONCAT('%',#{jmcj,jdbcType=VARCHAR},'%'))

AND f.zhcj LIKE CONCAT(CONCAT('%',#{zhcj,jdbcType=VARCHAR},'%'))

AND f.ccwl LIKE CONCAT(CONCAT('%',#{ccwl,jdbcType=VARCHAR},'%'))

AND f.tzsb LIKE CONCAT(CONCAT('%',#{tzsb,jdbcType=VARCHAR},'%'))

AND f.bjss LIKE CONCAT(CONCAT('%',#{bjss,jdbcType=VARCHAR},'%'))

AND f.xcwx LIKE CONCAT(CONCAT('%',#{xcwx,jdbcType=VARCHAR},'%'))

AND f.pcyh LIKE CONCAT(CONCAT('%',#{pcyh,jdbcType=VARCHAR},'%'))

AND f.gwfx= #{gwfx,jdbcType=VARCHAR}

AND f.tcj= #{tcj,jdbcType=VARCHAR}

AND f.tszysl LIKE CONCAT(CONCAT('%',#{tszysl,jdbcType=VARCHAR},'%'))

AND f.gsm= #{gsm,jdbcType=VARCHAR}

AND f.tszynr LIKE CONCAT(CONCAT('%',#{tszynr,jdbcType=VARCHAR},'%'))

AND f.zjl LIKE CONCAT(CONCAT('%',#{zjl,jdbcType=VARCHAR},'%'))

AND u.name LIKE CONCAT(CONCAT('%',#{tbr,jdbcType=VARCHAR},'%'))

AND #{ggrqStart,jdbcType=BIGINT} <=f.ggrq

AND f.ggrq<= #{ggrqEnd,jdbcType=BIGINT}

AND w.status= #{status,jdbcType=VARCHAR}

AND f.delete_status= #{deleteStatus,jdbcType=INTEGER}

AND CONCAT(f.jhcj, f.jmcj, f.zhcj, f.ccwl, f.tzsb, f.bjss, f.xcwx, f.pcyh, f.tszysl, f.gsm, f.tszynr,

f.zjl, u.name) LIKE CONCAT(CONCAT('%',#{all},'%'))AND judgeDataPermission(f.id,#{cjr},f.cjr)=1order by f.cjsj desc

delete from wp_fxcns

where id= #{id,jdbcType=VARCHAR}

insert into wp_fxcns

id,

jhcj,

jmcj,

zhcj,

ccwl,

tzsb,

bjss,

xcwx,

pcyh,

gwfx,

tcj,

tszysl,

gsm,

tszynr,

zjl,

tbr,

ggrq,

status,

cjr,

cjsj,

xgsj,

xgr,

delete_status,

#{id,jdbcType=VARCHAR},

#{jhcj,jdbcType=VARCHAR},

#{jmcj,jdbcType=VARCHAR},

#{zhcj,jdbcType=VARCHAR},

#{ccwl,jdbcType=VARCHAR},

#{tzsb,jdbcType=VARCHAR},

#{bjss,jdbcType=VARCHAR},

#{xcwx,jdbcType=VARCHAR},

#{pcyh,jdbcType=VARCHAR},

#{gwfx,jdbcType=VARCHAR},

#{tcj,jdbcType=VARCHAR},

#{tszysl,jdbcType=VARCHAR},

#{gsm,jdbcType=VARCHAR},

#{tszynr,jdbcType=VARCHAR},

#{zjl,jdbcType=VARCHAR},

#{tbr,jdbcType=VARCHAR},

#{ggrq,jdbcType=BIGINT},

#{status,jdbcType=VARCHAR},

#{cjr,jdbcType=VARCHAR},

#{cjsj,jdbcType=TIMESTAMP},

#{xgsj,jdbcType=TIMESTAMP},

#{xgr,jdbcType=VARCHAR},

#{deleteStatus,jdbcType=INTEGER},

update wp_fxcns

jhcj= #{jhcj,jdbcType=VARCHAR},

jmcj= #{jmcj,jdbcType=VARCHAR},

zhcj= #{zhcj,jdbcType=VARCHAR},

ccwl= #{ccwl,jdbcType=VARCHAR},

tzsb= #{tzsb,jdbcType=VARCHAR},

bjss= #{bjss,jdbcType=VARCHAR},

xcwx= #{xcwx,jdbcType=VARCHAR},

pcyh= #{pcyh,jdbcType=VARCHAR},

gwfx= #{gwfx,jdbcType=VARCHAR},

tcj= #{tcj,jdbcType=VARCHAR},

tszysl= #{tszysl,jdbcType=VARCHAR},

gsm= #{gsm,jdbcType=VARCHAR},

tszynr= #{tszynr,jdbcType=VARCHAR},

zjl= #{zjl,jdbcType=VARCHAR},

tbr= #{tbr,jdbcType=VARCHAR},

ggrq= #{ggrq,jdbcType=BIGINT},

status= #{status,jdbcType=VARCHAR},

cjr= #{cjr,jdbcType=VARCHAR},

cjsj= #{cjsj,jdbcType=TIMESTAMP},

xgsj= #{xgsj,jdbcType=TIMESTAMP},

xgr= #{xgr,jdbcType=VARCHAR},

delete_status= #{deleteStatus,jdbcType=INTEGER},

zx= #{zx,jdbcType=INTEGER},

where id= #{id,jdbcType=VARCHAR}

SELECT #{id,jdbcType=VARCHAR} in (

SELECT distinct wp.business_Id as docId

FROM

wf_processinst wp

LEFT JOIN act_ru_task art ON wp.id=art.PROC_INST_ID_

left JOIN act_re_model arm on arm.KEY_=wp.processDefinationKey

left join base_user u1 on u1.id=wp.origiator

LEFT JOIN base_user u2 on u2.id=art.ASSIGNEE_-- inner join base_data_table bdt on bdt.tableid=wp.business_Id

WHERE1=1and wp.`status` in#{wpStatus}and art.ID_ in#{taskId}

AND judgeDataPermission(wp.id,#{userId},wp.gmt_created_by)=1)

update wp_fxcns

set zx= 0where zx= 1

update wp_fxcns

set zx= 1where id= #{id,jdbcType=VARCHAR}

SELECT f.id, jhcj, jmcj, zhcj, ccwl, tzsb, bjss, xcwx, pcyh, gwfx, tcj, tszysl, gsm, tszynr,

zjl, tbr, ggrq, d.`name` gsmc, d1.`name` gwfxmc,d2.name tcjmc, u.`name` tbrmc, FROM_UNIXTIME(f.ggrq/1000, "%Y-%m-%d") ggrqStr

from wp_fxcns f

LEFT JOIN base_data_dictionary d on f.gsm=d.id

LEFT JOIN base_data_dictionary d1 on f.gwfx=d1.id

LEFT JOIN base_data_dictionary d2 on f.tcj=d2.id

LEFT JOIN base_user u on f.tbr=u.id

where f.zx= 1 and f.delete_status = 0

SELECT DISTINCT f.id, jhcj, jmcj, zhcj, ccwl, tzsb, bjss, xcwx, pcyh, gwfx, tcj, tszysl, gsm, tszynr,

zjl, tbr, ggrq, d.`name` gsmc, d1.`name` gwfxmc,d2.name tcjmc, u.`name` tbrmc, FROM_UNIXTIME(f.ggrq/1000, "%Y-%m-%d") ggrqStr, w.`status` status,

w.id AS processinstId,f.cjsj

from wp_fxcns f-- join base_data_table bdt on bdt.tableid=f.id

LEFT JOIN base_data_dictionary d on f.gsm=d.id

LEFT JOIN base_data_dictionary d1 on f.gwfx=d1.id

LEFT JOIN base_data_dictionary d2 on f.tcj=d2.id

LEFT JOIN base_user u on f.tbr=u.id

INNER JOIN wf_processinst w on f.id=w.business_Id

where1=1 AND w.status = "Finished" and f.delete_status = 0AND judgeDataPermission(f.id,u.id,f.gmt_created_by)=1order by f.cjsj desc

LIMIT1