<%-- - FileName : ModStatus.jsp - Author(s) : hoonseok choi - Date : 2021.3.3 --%> <%@ page contentType="text/html; charset=utf-8" %> <%@ page import="com.udapsoft.waf.system.HandlerStorage" %> <%@ page import="com.udapsoft.waf.common.ui.*" %> <%@ page import="com.udapsoft.waf.common.ui.InitCombo" %> <%@ page import="com.udapsoft.waf.common.util.DateUtil" %> <%@ page import="kr.co.udapsoft.common.code.CommCodeManager" %> <%@ page import="kr.co.hsnc.common.util.*"%> <%@ page import="kr.co.hsnc.common.sql.*" %> <%@ include file="/jsp/work/taglib.jsp" %> <% ctx.init(request, response); HandlerStorage storage = ctx.getHandlerStorage(); ValueObject params = storage.getParams(); ValueObject user = storage.getUser(); String event = storage.getEvent(); ValueObject vo = storage.getValueObject("modStatusListRowSet"); ValueObject vo2 = storage.getValueObject("modTemplateRowSet"); CommCodeManager commCodeManager = new CommCodeManager(); InitCombo initCombo = new InitCombo(); initCombo.makeComboData(commCodeManager.getCodeRowSet("BID_STATUS_CD","1","1"), "DETAILNM", "DETAILCD"); String BID_STATUS_CD = initCombo.getCode(); String BID_STATUS_NM = initCombo.getCodeName(); InitCombo initCombo2 = new InitCombo(); initCombo2.makeComboData(commCodeManager.getCodeRowSet("BID_RESOL_CD","1","1"), "DETAILNM", "DETAILCD"); String BID_SUPP_STATUS_CD = initCombo2.getCode(); String BID_SUPP_STATUS_NM = initCombo2.getCodeName(); InitCombo initCombo3 = new InitCombo(); initCombo3.makeComboData(commCodeManager.getCodeRowSet("TBE_LIST_STATUS","1","1"), "DETAILNM", "DETAILCD"); String BID_TBE_STATUS_CD = initCombo3.getCode(); String BID_TBE_STATUS_NM = initCombo3.getCodeName(); InitCombo initCombo4 = new InitCombo(); initCombo4.makeComboData(commCodeManager.getCodeRowSet("CONT_STATUS_CD","1","1"), "DETAILNM", "DETAILCD"); String CONT_STATUS_CD = initCombo4.getCode(); String CONT_STATUS_NM = initCombo4.getCodeName(); InitCombo initCombo5 = new InitCombo(); initCombo5.makeComboData(commCodeManager.getCodeRowSet("GUAR_STATUS","1","1"), "DETAILNM", "DETAILCD"); String GUAR_STATUS_CD = initCombo5.getCode(); String GUAR_STATUS_NM = initCombo5.getCodeName(); InitCombo initCombo6 = new InitCombo(); initCombo6.makeComboData(commCodeManager.getCodeRowSet("GAUR_KIND","1","1"), "DETAILNM", "DETAILCD"); String GAUR_KIND_CD = initCombo6.getCode(); String GAUR_KIND_NM = initCombo6.getCodeName(); String statusSheetComboListText = (String)storage.getObject("selectText"); String statusSheetComboListValue = (String)storage.getObject("selectValue"); String statusSheetComboListText2 = (String)storage.getObject("selectText2"); String statusSheetComboListValue2 = (String)storage.getObject("selectValue2"); //검색조건 작성일 String initSearchDateStart = params.get("searchDateStart"); String initSearchDateEnd = params.get("searchDateEnd"); //com.udapsoft.waf.common.util.DateUtil ValueObject defaultDate = DateUtil.getDefaultPeriod(); if("".equals(initSearchDateStart)) initSearchDateStart = defaultDate.get("START_DATE"); if("".equals(initSearchDateEnd)) initSearchDateEnd = defaultDate.get("END_DATE"); %>
  • ERP결재상태 변경
KEY_COL1 KEY_COL2 KEY_COL3 검색
KEY_COL4 KEY_COL5 KEY_COL6
  • 전자조달 템플릿 관리
검색
  • 입찰상태변경
현장 <%=InputText.getSiteCodeNew("p_dept_cd", "p_dept_nm", "", user, params.get("p_dept_cd"), params.get("p_dept_nm"))%> 입찰공고명 " style="width:90%"> 검색
입찰번호 " style="width:90%"> 상태 <%=CommCodeManager.getSelectCodeSearchList("BID_STATUS_CD","P_DEMANDED_STATUS","height=18;width:80px;","",params.get("P_DEMANDED_STATUS"),"","DETAILCD") %>
  • 구매 계약서 관리
현장 <%=InputText.getSiteCodeNew("p_dept_cd2", "p_dept_nm2", "", user, params.get("p_dept_cd2"), params.get("p_dept_nm2"))%> 계약명 " style="width:90%"> 검색
계약번호 " style="width:90%"> 차수 " style="width:90%">
  • 외주 계약서 관리
현장 <%=InputText.getSiteCodeNew("p_dept_cd3", "p_dept_nm3", "", user, params.get("p_dept_cd3"), params.get("p_dept_nm3"))%> 계약명 " style="width:90%"> 검색
계약번호 " style="width:90%"> 차수 " style="width:90%">
  • 외주 기성 관리
현장 <%=InputText.getSiteCodeNew("searchDeptCd", "searchDeptNm", "", user, "", "")%> 업체명 검색
계약명 기성년월 <%= InputText.get("searchFromDate", "", 10, 50, "hangule,center, desc=기성년월, ReadOnly") %> ~ <%= InputText.get("searchToDate", "", 10, 50, "hangule,center, desc=기성년월, ReadOnly") %>
  • 대금지급관리
<%-- --%>
현장 <%=InputText.getSiteCodeNew("searchDeptCd2", "searchDeptNm2", "", user, "", "")%> 계약명 검색
증빙일 <%= InputText.get("searchDateStart", initSearchDateStart, 15, 10, "Center, date, PerSize, readonly", "date", "") %> 달력  ~  <%= InputText.get("searchDateEnd", initSearchDateEnd, 15, 10, "Center, date, PerSize, readonly", "date", "") %> 달력 상태 <%= HTMLMaker.getSelectTag(statusComboList, "DETAILCD", "DETAILNM", "searchStatusCd", "width:25%;height=18;", "", initStatusCd) %> 업체명
  • 데이타 수정(update) * SET 입력시 ''입력 필수
 수정
테이블명
SET_1 SET_1(값)
SET_2 SET_2(값)
SET_3 SET_3(값)
SET_4 SET_4(값)
WHERE WHERE(값)
AND_1 AND_1(값)
AND_2 AND_2(값)
AND_3 AND_3(값)
  • 데이타 삭제(delete)
 삭제
테이블명
WHERE WHERE(값)
AND_1 AND_1(값)
AND_2 AND_2(값)
AND_3 AND_3(값)
  • 결재테스트 * 개발위주 테스트 진행 요망
 실행
SIGN_INTERFACE_ID SIGN_DECI_CLASS