You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
292 lines
11 KiB
Plaintext
292 lines
11 KiB
Plaintext
<%@page import="com.clipsoft.clipreport.oof.OOFFile"%>
|
|
<%@page import="com.clipsoft.clipreport.oof.OOFDocument"%>
|
|
<%@page import="java.io.File"%>
|
|
<%@page import="com.clipsoft.clipreport.server.service.ReportUtil"%>
|
|
<%@page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%
|
|
|
|
|
|
|
|
|
|
|
|
String newCollectId = request.getParameter("newCollectId");
|
|
|
|
|
|
String overfareKbn = request.getParameter("overfareKbn");
|
|
String refundKbn = request.getParameter("refundKbn");
|
|
|
|
String workDateFrom = request.getParameter("workDateFrom");
|
|
String workDateTo = request.getParameter("workDateTo");
|
|
|
|
|
|
String penaltyDateFrom = request.getParameter("penaltyDateFrom");
|
|
String penaltyDateTo = request.getParameter("penaltyDateTo");
|
|
|
|
|
|
|
|
|
|
String year = request.getParameter("year");
|
|
String month = request.getParameter("month");
|
|
String day = request.getParameter("day");
|
|
|
|
|
|
|
|
String crfName = request.getParameter("crfName");
|
|
String fareOfficeId = request.getParameter("fareOfficeId");
|
|
String isAmpm = request.getParameter("isAmpm");
|
|
String isGubun = request.getParameter("isGubun");
|
|
String workerId = request.getParameter("workerId");
|
|
String boothId = request.getParameter("boothId");
|
|
String fromDt = request.getParameter("fromDt");
|
|
String toDt = request.getParameter("toDt");
|
|
|
|
String inStDate = request.getParameter("inStDate");
|
|
String inEdDate = request.getParameter("inEdDate");
|
|
String passDate = request.getParameter("passDate");
|
|
String carNo = request.getParameter("carNo");
|
|
String deleteYn = request.getParameter("deleteYn");
|
|
String roadNumber = request.getParameter("roadNumber");
|
|
String workDate = request.getParameter("workDate");
|
|
String stTime = request.getParameter("stTime");
|
|
String edTime = request.getParameter("edTime");
|
|
String couponNo = request.getParameter("couponNo");
|
|
String passDateFrom = request.getParameter("passDateFrom");
|
|
String passDateTo = request.getParameter("passDateTo");
|
|
String carNum = request.getParameter("carNum");
|
|
String readId = request.getParameter("readId");
|
|
String inStDateYear = request.getParameter("inStDateYear");
|
|
String inEdDateYear = request.getParameter("inEdDateYear");
|
|
String motionId = request.getParameter("motionId");
|
|
String dtType = request.getParameter("dtType");
|
|
String inStDateSec = request.getParameter("inStDateSec");
|
|
String inEdDateSec = request.getParameter("inEdDateSec");
|
|
String kbn = request.getParameter("kbn");
|
|
String workStDate = request.getParameter("workStDate");
|
|
String workEdDate = request.getParameter("workEdDate");
|
|
String dateKbn = request.getParameter("dateKbn");
|
|
String passStDate = request.getParameter("passStDate");
|
|
String passEdDate = request.getParameter("passEdDate");
|
|
String cardKbn = request.getParameter("cardKbn");
|
|
String receiptKbn = request.getParameter("receiptKbn");
|
|
String residentNo = request.getParameter("residentNo");
|
|
String carsDataKbn = request.getParameter("carsDataKbn");
|
|
String dateFrom = request.getParameter("dateFrom");
|
|
String dateTo = request.getParameter("dateTo");
|
|
String reader = request.getParameter("reader");
|
|
String inRadDate = request.getParameter("inRadDate");
|
|
String sendyear = request.getParameter("sendyear");
|
|
String penaltyCnt = request.getParameter("penaltyCnt");
|
|
String sortType = request.getParameter("sortType");
|
|
String dateDiv = request.getParameter("dateDiv");
|
|
String passYearFrom = request.getParameter("passYearFrom");
|
|
String passYearTo = request.getParameter("passYearTo");
|
|
String passYearMonth = request.getParameter("passYearMonth");
|
|
String owner = request.getParameter("owner");
|
|
String carTypeName = request.getParameter("carTypeName");
|
|
String civilSummaryId = request.getParameter("civilSummaryId");
|
|
String civilProcessId = request.getParameter("civilProcessId");
|
|
String acceptDate = request.getParameter("acceptDate");
|
|
String acceptStatus = request.getParameter("acceptStatus");
|
|
String noticeWrongId = request.getParameter("noticeWrongId");
|
|
String penaltySeqno = request.getParameter("penaltySeqno");
|
|
String postDiv = request.getParameter("postDiv");
|
|
String remarksCode = request.getParameter("remarksCode");
|
|
String selCarNum = request.getParameter("selCarNum");
|
|
String defectYn = request.getParameter("defectYn");
|
|
|
|
String fareOfficeNm = request.getParameter("fareOfficeNm");
|
|
String workSttTime = request.getParameter("workSttTime");
|
|
String workEndTime = request.getParameter("workEndTime");
|
|
String workerIdSub = request.getParameter("workerIdSub");
|
|
String boothNm = request.getParameter("boothNm");
|
|
String otherSeqNo = request.getParameter("otherSeqNo");
|
|
String workerNm = request.getParameter("workerNm");
|
|
String retQty = request.getParameter("retQty");
|
|
String retAmount = request.getParameter("retAmount");
|
|
String compareYnTxt = request.getParameter("compareYnTxt");
|
|
String prpKbn = request.getParameter("prpKbn");
|
|
String retAmountC = request.getParameter("retAmountC");
|
|
|
|
|
|
String standardStDate = request.getParameter("standardStDate");
|
|
String standardEdDate = request.getParameter("standardEdDate");
|
|
|
|
|
|
String compareStDate = request.getParameter("compareStDate");
|
|
String compareEdDate = request.getParameter("compareEdDate");
|
|
|
|
|
|
|
|
|
|
|
|
String report ="%root%/crf/" + crfName + ".crf";
|
|
|
|
|
|
OOFDocument oof = OOFDocument.newOOF();
|
|
OOFFile file = oof.addFile("crf.root", report);
|
|
oof.addConnectionData("*", "oracle1");
|
|
// 옵션 - 레포트 파라메터(파라메터 NAME 대문자 중요!)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
oof.addField("NEWCOLLECTID",newCollectId);
|
|
|
|
oof.addField("STANDARDSTDATE",standardStDate);
|
|
oof.addField("STANDARDEDDATE",standardEdDate);
|
|
|
|
|
|
|
|
oof.addField("COMPARESTDATE",compareStDate);
|
|
oof.addField("COMPAREEDDATE",compareEdDate);
|
|
|
|
|
|
|
|
|
|
|
|
oof.addField("OVERFAREKBN",overfareKbn);
|
|
oof.addField("REFUNDKBN",refundKbn);
|
|
|
|
|
|
|
|
oof.addField("WORKDATEFROM",workDateFrom);
|
|
oof.addField("WORKDATETO",workDateTo);
|
|
|
|
|
|
|
|
oof.addField("PENALTYDATEFROM",penaltyDateFrom);
|
|
oof.addField("PENALTYDATETO",penaltyDateTo);
|
|
|
|
|
|
|
|
|
|
oof.addField("YEAR", year);
|
|
oof.addField("MONTH", month);
|
|
oof.addField("DAY", day);
|
|
|
|
|
|
|
|
|
|
oof.addField("FAREOFFICEID", fareOfficeId);
|
|
oof.addField("ISAMPM", isAmpm);
|
|
oof.addField("ISGUBUN", isGubun);
|
|
oof.addField("WORKERID", workerId);
|
|
oof.addField("BOOTHID", boothId);
|
|
oof.addField("FROMDT", fromDt);
|
|
oof.addField("TODT", toDt);
|
|
|
|
oof.addField("INSTDATE", inStDate);
|
|
oof.addField("INEDDATE", inEdDate);
|
|
oof.addField("PASSDATE", passDate);
|
|
oof.addField("CARNO", carNo);
|
|
oof.addField("DELETEYN", deleteYn);
|
|
oof.addField("ROADNUMBER", roadNumber);
|
|
oof.addField("WORKDATE", workDate);
|
|
oof.addField("STTIME", stTime);
|
|
oof.addField("EDTIME", edTime);
|
|
oof.addField("COUPONNO", couponNo);
|
|
oof.addField("PASSDATEFROM", passDateFrom);
|
|
oof.addField("PASSDATETO", passDateTo);
|
|
oof.addField("CARNUM", carNum);
|
|
oof.addField("READID", readId);
|
|
oof.addField("INSTDATEYEAR", inStDateYear);
|
|
oof.addField("INEDDATEYEAR", inEdDateYear);
|
|
oof.addField("MOTIONID", motionId);
|
|
oof.addField("DTTYPE", dtType);
|
|
oof.addField("INSTDATESEC", inStDateSec);
|
|
oof.addField("INEDDATESEC", inEdDateSec);
|
|
oof.addField("KBN", kbn);
|
|
oof.addField("WORKSTDATE", workStDate);
|
|
oof.addField("WORKEDDATE", workEdDate);
|
|
oof.addField("DATEKBN", dateKbn);
|
|
oof.addField("PASSSTDATE", passStDate);
|
|
oof.addField("PASSEDDATE", passEdDate);
|
|
oof.addField("CARDKBN", cardKbn);
|
|
oof.addField("RECEIPTKBN", receiptKbn);
|
|
oof.addField("RESIDENTNO", residentNo);
|
|
oof.addField("CARSDATAKBN", carsDataKbn);
|
|
oof.addField("DATEFROM", dateFrom);
|
|
oof.addField("DATETO", dateTo);
|
|
oof.addField("READER", reader);
|
|
oof.addField("INRADDATE", inRadDate);
|
|
oof.addField("SENDYEAR", sendyear);
|
|
oof.addField("PENALTYCNT", penaltyCnt);
|
|
oof.addField("SORTTYPE", sortType);
|
|
oof.addField("DATEDIV", dateDiv);
|
|
oof.addField("PASSYEARFROM", passYearFrom);
|
|
oof.addField("PASSYEARTO", passYearTo);
|
|
oof.addField("PASSYEARMONTH", passYearMonth);
|
|
oof.addField("OWNER", owner);
|
|
oof.addField("CARTYPENAME", carTypeName);
|
|
oof.addField("CIVILSUMMARYID", civilSummaryId);
|
|
oof.addField("CIVILPROCESSID", civilProcessId);
|
|
oof.addField("ACCEPTDATE", acceptDate);
|
|
oof.addField("ACCEPTSTATUS", acceptStatus);
|
|
oof.addField("NOTICEWRONGID", noticeWrongId);
|
|
oof.addField("PENALTYSEQNO", penaltySeqno);
|
|
oof.addField("POSTDIV", postDiv);
|
|
oof.addField("REMARKSCODE", remarksCode);
|
|
oof.addField("SELCARNUM", selCarNum);
|
|
oof.addField("DEFECTYN", defectYn);
|
|
oof.addField("FAREOFFICENM", fareOfficeNm);
|
|
oof.addField("WORKSTTTIME", workSttTime);
|
|
oof.addField("WORKENDTIME", workEndTime);
|
|
oof.addField("WORKERIDSUB", workerIdSub);
|
|
oof.addField("BOOTHNM", boothNm);
|
|
oof.addField("OTHERSEQNO", otherSeqNo);
|
|
oof.addField("WORKERNM", workerNm);
|
|
oof.addField("RETQTY", retQty);
|
|
oof.addField("RETAMOUNT", retAmount);
|
|
oof.addField("COMPAREYNTXT", compareYnTxt);
|
|
oof.addField("PRPKBN", prpKbn);
|
|
oof.addField("RETAMOUNTC", retAmountC);
|
|
|
|
|
|
%><%@include file="Property.jsp"%><%
|
|
//세션을 활용하여 리포트키들을 관리하지 않는 옵션
|
|
//request.getSession().setAttribute("ClipReport-SessionList-Allow", false);
|
|
String resultKey = ReportUtil.createReport(request, oof, "false", "false", request.getRemoteAddr(), propertyPath);
|
|
//리포트의 특정 사용자 ID를 부여합니다.
|
|
//clipreport4.properties 의 useuserid 옵션이 true 일 때만 적용됩니다.
|
|
//clipreport4.properties 의 useuserid 옵션이 true 이고 기본 예제[String resultKey = ReportUtil.createReport(request, oof, "false", "false", request.getRemoteAddr(), propertyPath);] 사용 했을 때 세션ID가 userID로 사용 됩니다.
|
|
//String resultKey = ReportUtil.createReport(request, oof, "false", "false", request.getRemoteAddr(), propertyPath, "userID");
|
|
|
|
//리포트key의 사용자문자열을 추가합니다.(문자숫자만 가능합니다.)
|
|
//String resultKey = ReportUtil.createReport(request, oof, "false", "false", request.getRemoteAddr(), propertyPath, "", "usetKey");
|
|
|
|
//리포트를 저장 스토리지를 지정하여 생성합니다.
|
|
//String resultKey = ReportUtil.createReportByStorage(request, oof, "false", "false", request.getRemoteAddr(), propertyPath, "rpt1");
|
|
%>
|
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
|
|
<html>
|
|
<head>
|
|
<title>Report</title>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
|
<link rel="stylesheet" type="text/css" href="/cm/ClipReport4/css/clipreport.css">
|
|
<link rel="stylesheet" type="text/css" href="/cm/ClipReport4/css/UserConfig.css">
|
|
<link rel="stylesheet" type="text/css" href="/cm/ClipReport4/css/font.css">
|
|
<script type='text/javascript' src='/cm/ClipReport4/js/jquery-1.11.1.js'></script>
|
|
<script type='text/javascript' src='/cm/ClipReport4/js/clipreport.js'></script>
|
|
<script type='text/javascript' src='/cm/ClipReport4/js/UserConfig.js'></script>
|
|
<script type='text/javascript'>
|
|
var urlPath = document.location.protocol + "//" + document.location.host;
|
|
|
|
function html2xml(divPath){
|
|
var reportkey = "<%=resultKey%>";
|
|
var report = createImportJSPReport(urlPath + "/ClipReport4/Clip.jsp", reportkey, document.getElementById(divPath));
|
|
//alert("리포트실행");
|
|
//리포트 실행
|
|
report.view();
|
|
}
|
|
</script>
|
|
</head>
|
|
<body onload="html2xml('targetDiv1')">
|
|
<div id='targetDiv1' style='position:absolute;top:5px;left:5px;right:5px;bottom:5px;'></div>
|
|
</body>
|
|
</html>
|