<%--
title : graph2.jsp
Copyright (c) Avman Systems, Inc.
All rights reserved
--%><%@ taglib prefix="RR" uri="RRSupport.tld" %>
<% String datasrc = (String) session.getAttribute("datasrc");
String rptid = request.getParameter("rptid");
String graphid = request.getParameter("graphid");
net.avman.RRSupport.dataString graphtitle= new net.avman.RRSupport.dataString(request.getParameter("graphtitle"));
net.avman.RRSupport.dataString comments= new net.avman.RRSupport.dataString(request.getParameter("comments"));
net.avman.RRSupport.dataString namefield= new net.avman.RRSupport.dataString(request.getParameter("namefield"));
String valuefield = request.getParameter("valuefield");
String valuefield2 = request.getParameter("valuefield2");
if (valuefield2==null || "null".equals(valuefield2) || "".equals(valuefield2))
valuefield2 = "0";
String valuefield3 = request.getParameter("valuefield3");
if (valuefield3==null || "null".equals(valuefield3) || "".equals(valuefield3))
valuefield3 = "0";
String gtype = request.getParameter("graphtypes");
String func = request.getParameter("funcfield");
String func2 = request.getParameter("funcfield2");
if (valuefield2.equals("0"))
func2 = "";
else if (func2==null || "null".equals(func2))
func2 = "";
String func3 = request.getParameter("funcfield3");
if (valuefield2.equals("0"))
func3 = "";
else if (func3==null || "null".equals(func3))
func3 = "";
%>
<% String sumvalueYN;
String showlegendyn;
String barrowspaceyn;
if (request.getParameter("sumvalueyn") == null) {
sumvalueYN = "0";
} else {
sumvalueYN = request.getParameter("sumvalueyn");
}
if (request.getParameter("showlegend") == null) {
showlegendyn = "0";
} else {
showlegendyn = request.getParameter("showlegend");
}
if (request.getParameter("rowspace") == null) {
barrowspaceyn = "0";
} else {
barrowspaceyn = request.getParameter("rowspace");
}
String blksize;
if (request.getParameter("blocksize") == null || request.getParameter("blocksize").equals("")) {
blksize = "0";
} else {
blksize = request.getParameter("blocksize");
}
String graphwidth;
if (request.getParameter("graphwidth") == null || request.getParameter("graphwidth").equals("")) {
graphwidth = "0";
} else {
graphwidth = request.getParameter("graphwidth");
}
String piewidth;
if (request.getParameter("piewidth") == null || request.getParameter("piewidth").equals("")) {
piewidth = "0";
} else {
piewidth = request.getParameter("piewidth");
}
String pieheight;
if (request.getParameter("pieheight") == null || request.getParameter("pieheight").equals("")) {
pieheight = "0";
} else {
pieheight = request.getParameter("pieheight");
}
if (request.getParameter("graphtypes").equals("BarGraph") || request.getParameter("graphtypes").equals("LineGraph")){
pieheight = "0";
piewidth = "0";
} else {
blksize = "0";
graphwidth = "0";
}%>
<% if(graphid.equals("0")) {%>
SELECT max(graphid) as maxgraphid from graphinf
<% int maxgid;
if(GetMaxGraphid.Field("maxgraphid").equals("")) {
maxgid = 1;
} else {
maxgid = Integer.parseInt(GetMaxGraphid.Field("maxgraphid")) + 1;
}
GetMaxGraphid.close(); %>
INSERT into graphinf (Graphid, rptid,graphtitle, comments, valuerptfldid, namerptfldid, sumvaluefld, sortfldid, graphtype, graphorient, showlegend, rowspace, blocksize, graphsize, pieHeight, piewidth, num1, num2,text1,num3,num4 )
VALUES (<%=maxgid%>, <%=rptid%>, '<%=graphtitle%>',
'<%=comments%>', <%=valuefield%>,
<%=namefield%>, <%= sumvalueYN%>, <%=request.getParameter("sortlvlfield")%>,
'<%=request.getParameter("graphtypes")%>', '<%=request.getParameter("graphstyle")%>',
<%=showlegendyn%>, <%=barrowspaceyn%>, <%=blksize%>, <%=graphwidth%>, <%=pieheight%>,
<%=piewidth%>, <%=func %>, <%=valuefield2%>,'<%=func2%>', <%=valuefield3%>,<%=func3%>)
<% Insertgraphinf.close(); %>
<% } else { %>
UPDATE graphinf
SET graphtitle = '<%=graphtitle%>',
comments = '<%=comments%>',
valuerptfldid = <%=valuefield%>,
namerptfldid = <%=namefield%>,
sumvaluefld = <%= sumvalueYN%>,
sortfldid = <%=request.getParameter("sortlvlfield")%>,
graphtype = '<%=request.getParameter("graphtypes")%>',
graphorient = '<%=request.getParameter("graphstyle")%>',
showlegend = <%=showlegendyn%>,
rowspace = <%=barrowspaceyn%>,
blocksize = <%=blksize%> ,
graphsize = <%=graphwidth%>,
pieheight = <%=pieheight%>,
piewidth = <%=piewidth%>,
num1 = <%=func%>,
num2 = <%=valuefield2%>,
text1= '<%=func2%>',
num3 = <%=valuefield3%>,
num4 = <%=func3%>
WHERE graphid = <%= graphid %>
<% Updategraphinf.close(); %>
<% } %>
<%----%>
<% if(graphid.equals("0")) {%>
Graph <%=graphtitle%> has been succefully added.
<% } else { %>
Graph <%=graphtitle%> has been succefully modified.
<% } %>
Please close this window by Pressing DONE
button to return to the graph list.
