PhotoReloadInfo.jsp
3.64 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
<%@page import="net.sf.json.JSONObject"%>
<%@page import="weaver.systeminfo.SystemEnv"%>
<%@page import="weaver.hrm.HrmUserVarify"%>
<%@page import="weaver.hrm.User"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="weaver.general.*" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="hrm" class="weaver.hrm.resource.ResourceComInfo" scope="page" />
<jsp:useBean id="DateTransformer" class="weaver.dateformat.DateTransformer" scope="page" />
<%
User user=HrmUserVarify.getUser(request, response);
if(user == null){
out.print("{}");
}else{
String CurrentDate=TimeUtil.getCurrentDateString();
String CurrentTime=TimeUtil.getOnlyCurrentTimeString();
String src=Util.null2String(request.getParameter("src"));
String type=Util.null2String(request.getParameter("type"));
int photoId=Util.getIntValue(request.getParameter("photoid"));
JSONObject jsonObject=new JSONObject();
String sql = "";
int userId = user.getUID();
String postdate = TimeUtil.getCurrentTimeString();
StringBuilder content = new StringBuilder(" ");
rs.executeSql("SELECT * FROM AlbumPhotoReview WHERE photoId="+photoId+" ORDER BY postdate DESC");
while(rs.next()){
content.append("<table class='ListStyle' style='width:100%;border-collapse:collapse'><tr class='DataLight'><td width='*'>");
content.append("<a href='/hrm/resource/HrmResource.jsp?id="+rs.getString("userId")+"' target='_blank'>"+hrm.getResourcename(rs.getString("userId"))+"</a> : ");
content.append("<span id='reviewcontent_"+rs.getString("id")+"'>"+Util.toHtml(rs.getString("content"))+"</span> ");
content.append("<span style='font:12px MS Shell Dlg,Arail'>"+"("+DateTransformer.getLocaleDateTime(rs.getString("postdate"))+")"+"</span>");
content.append("</td><td width='150' style='text-align:right;'>");
if(HrmUserVarify.checkUserRight("Album:Maint",user) || userId==rs.getInt("userId")){
content.append("<span id='linkEdit"+rs.getString("id")+"' class='e8_btn_top' reviewId='"+rs.getString("id")+"' onclick='javascript:editReview()'>"+SystemEnv.getHtmlLabelName(93,user.getLanguage())+"</span>");
content.append(" <span id='linkSave"+rs.getString("id")+"' class='e8_btn_top' style='display:none' reviewId='"+rs.getString("id")+"' onclick='javascript:saveReview()'>"+SystemEnv.getHtmlLabelName(86,user.getLanguage())+"</span>");
content.append(" <span id='linkCancel"+rs.getString("id")+"' class='e8_btn_top' style='display:none' reviewId='"+rs.getString("id")+"' onclick='javascript:cancelReview()'>"+SystemEnv.getHtmlLabelName(201,user.getLanguage())+"</span>");
content.append(" <span id='linkDelete"+rs.getString("id")+"' class='e8_btn_top' reviewId='"+rs.getString("id")+"' onclick='javascript:deleteReview()'>"+SystemEnv.getHtmlLabelName(91,user.getLanguage())+"</span>");
}
content.append("</td></tr></table>");
}
sql="select * FROM AlbumPhotos where id="+photoId;
rs.executeSql(sql);
String photo_postdate="";
String photo_title="";
String photo_desc="";
String photo_uploader="";
if(rs.next()){
photo_postdate=Util.null2String(rs.getString("postdate"));
photo_title=Util.null2String(rs.getString("photoname"));
photo_desc=Util.null2String(rs.getString("photoDescription"));
photo_uploader=hrm.getResourcename( Util.null2String(rs.getString("userid")));
}
jsonObject.put("reviewInfo", content.toString());
jsonObject.put("photo_postdate", DateTransformer.getLocaleDateTime(photo_postdate));
jsonObject.put("photo_title", photo_title);
jsonObject.put("photo_desc", photo_desc);
jsonObject.put("photo_uploader", photo_uploader);
out.print(jsonObject.toString());
}
%>