BidResultList.jsp 9.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256
  1. <%--
  2. - Author(s) : Hyung min Son
  3. - Date : 2014.08.08
  4. - Description: 입찰결과리스트
  5. --%>
  6. <%@ page contentType="text/html; charset=utf-8" %>
  7. <%@ page import="com.udapsoft.waf.system.HandlerStorage" %>
  8. <%@ page import="com.udapsoft.waf.common.ui.*" %>
  9. <%@ page import="kr.co.hsnc.common.util.*"%>
  10. <%@ page import="kr.co.hsnc.common.sql.*" %>
  11. <%@ page import="com.udapsoft.waf.common.ui.InitCombo" %>
  12. <%@ page import="kr.co.udapsoft.common.code.CommCodeManager" %>
  13. <%@ include file="/jsp/work/taglib.jsp" %>
  14. <jsp:useBean id="ctx" class="com.udapsoft.waf.system.context.SessionContext" scope="session" />
  15. <%
  16. ctx.init(request, response);
  17. HandlerStorage storage = ctx.getHandlerStorage();
  18. ValueObject params = storage.getParams();
  19. ValueObject user = storage.getUser();
  20. //공통코드
  21. CommCodeManager commCodeManager = new CommCodeManager();
  22. InitCombo initCombo = new InitCombo();
  23. initCombo.makeComboData(commCodeManager.getCodeRowSet("ONBID"), "NAME", "CODE");
  24. String ONBID_CD = initCombo.getCode();
  25. String ONBID_NM = initCombo.getCodeName();
  26. %>
  27. <script language="javascript" src="/js/popup.js"></script>
  28. <SCRIPT language="JavaScript">
  29. document.body.onresize = addEvent( document.body.onresize, "autoResize()");
  30. /*예약함수*/
  31. var sheet1 = new ibsheetObject();
  32. var sheet1Row;
  33. var sheet1PageNo = 1;
  34. var pageLastRowIndex = 1;
  35. var validationResult = false;
  36. var filterShow = false;
  37. function _onReady(){
  38. /**
  39. * IBSheet object initialize
  40. */
  41. gridInit(sheet1);
  42. autoResize();
  43. /**
  44. * Application Initialize
  45. */
  46. $("#btnSearch").click(function() {
  47. jQuery("#fevent").val("SHEET_SELECT");
  48. var url = Modular.model.PageContext.CONTEXT_ROOT + "/bid/purchase/BidResultList_sheet.screen";
  49. Modular.view.IBSheet7.doSearch(sheet1, url, jQuery("#form1"), 30, "");
  50. });
  51. /*
  52. 현장 팝업
  53. */
  54. $("#btn_dept").click(function() {
  55. PopsearchSite("");
  56. });
  57. $("#p_dept_nm").keydown(function (event){var keycode = (event.keyCode ? event.keyCode : event.which); if(keycode == 8||keycode == 46){$("#p_dept_cd").val("");$("#p_dept_nm").val("");}});
  58. $("#P_BID_MASTER_NM").keydown(function (event){var keycode = (event.keyCode ? event.keyCode : event.which);if(keycode == 13)$("#btnSearch").click();});
  59. //2019.11.22 전산요구사항으로 수정(상세보기 후 리스트로 왔을때 자동으로 검색)
  60. if($("#P_AUTO_SEARCH").val() == "1"){
  61. $("#P_AUTO_SEARCH").val("");
  62. $("#btnSearch").click();
  63. }
  64. }
  65. /**
  66. * IBSheet object initialize
  67. */
  68. function gridInit(sheetName){
  69. var init_sheet = {};
  70. init_sheet.Cfg = {SearchMode:2, Page:30};
  71. init_sheet.Cols = [
  72. {Header:'Del', Type:"DelCheck", SaveName:"DEL_CHECK", Width:50, Align:"Center", Hidden:"True"},
  73. {Header:'Status', Type:"Status", SaveName:"STATUS", Width:0, Align:"Center", Hidden:"True"},
  74. {Header:'No.', Type:"Seq", SaveName:"NO", Width:0, Align:"Center", Hidden:"True"},
  75. {Header:'입찰번호', Type:"Text", SaveName:"BID_NO", Width:120, Align:"Center"},
  76. {Header:'차수', Type:"Text", SaveName:"BID_DEG", Width:30, Align:"Center"},
  77. {Header:'현장', Type:"Text", SaveName:"DEPT_NM", Width:200, Align:"Left"},
  78. {Header:'☞입찰공고명', Type:"Text", SaveName:"BID_MASTER_NM", Width:200, Align:"Left", Cursor:"pointer"},
  79. {Header:'입찰방법', Type:"Combo", SaveName:"ONBID_YN", Width:80, Align:"Center", ComboText:"<%=ONBID_NM%>", ComboCode:"<%=ONBID_CD%>"},
  80. {Header:'경쟁방법', Type:"Text", SaveName:"CMPT_NM", Width:80, Align:"Center"},
  81. {Header:'공고일자', Type:"Text", SaveName:"NOTI_DY", Width:80, Align:"Center", Format:"####-##-##"},
  82. {Header:'TBE여부', Type:"Text", SaveName:"OPEN_EMPID", Width:80, Align:"Center", Hidden:"True"},
  83. {Header:'낙찰업체', Type:"Text", SaveName:"VENDOR_NAME", Width:80, Align:"Center"},
  84. {Header:'상태', Type:"Text", SaveName:"STATUS_NM", Width:80, Align:"Center"},
  85. {Header:'DEMANDED_ID', Type:"Text", SaveName:"DEMANDED_ID", Width:80, Align:"Center", Hidden:"True"}
  86. ];
  87. init_sheet.HeaderMode = {Sort:1};
  88. IBS_InitSheet(sheetName, init_sheet);
  89. sheetName.SetDataAutoTrim(0);
  90. sheetName.SetEditable(false);
  91. sheetName.SetActionMenu("ExcelDown");
  92. setGridSize();
  93. }
  94. function sheet1_OnSelectMenu(Text, Code) {
  95. // text 또는 code값으로 Action수행
  96. switch(Text) {
  97. case "ExcelDown":
  98. sheetExcelDown(sheet1,$('li').html());
  99. break;
  100. }
  101. }
  102. function searchSiteClose(result) {
  103. if( result == null ){
  104. $("#p_dept_nm").val("");
  105. $("#p_dept_cd").val("");
  106. }else{
  107. $("#p_dept_nm").val(result[1]);
  108. $("#p_dept_cd").val(result[0]);
  109. }
  110. setTimeout(function(){fLayerPopClose('_searchSite'); },100);
  111. }
  112. /**
  113. * IBSheet Event: Search End(IBSheet 데이터 조회 CallBack)
  114. */
  115. function sheet1_OnSearchEnd(code, message) {
  116. if(code == 0) {
  117. setGridSize();
  118. sheet1.SetColFontColor("BID_MASTER_NM", "#0000ff");
  119. } else {
  120. //조회 에러 수행
  121. alert(message);
  122. }
  123. }
  124. /**
  125. * IBSheet Event: Click
  126. */
  127. function sheet1_OnClick(Row, Col, Value, CellX, CellY, CellW, CellH) {
  128. }
  129. /**
  130. * IBSheet size setting
  131. */
  132. function setGridSize() {sheet1.FitColWidth();}
  133. /**
  134. * IBSheet Event: DBLCLICK
  135. */
  136. function sheet1_OnDblClick(Row, Col, Value, CellX, CellY, CellW, CellH) {
  137. if(Row == 0)return;
  138. if (Col == 6) {
  139. var status = sheet1.GetCellValue(Row,"STATUS_CD");
  140. $("#DEMANDED_ID").val(sheet1.GetCellValue(Row, "DEMANDED_ID"));
  141. $("#BID_NO").val(sheet1.GetCellValue(Row, "BID_NO"));
  142. $("#BID_DEG").val(sheet1.GetCellValue(Row, "BID_DEG"));
  143. $("#P_AUTO_SEARCH").val("1");
  144. $("#fevent").val("FORM_SELECT");
  145. $("#form1").attr("action", "/bid/purchase/BidResult.screen");
  146. $("#form1").attr("target", "_self");
  147. $("#form1").attr("method", "post");
  148. $("#form1").submit();
  149. }
  150. }
  151. function sheet1_OnSmartResize(Width, Height) {
  152. sheet1.FitColWidth();
  153. autoResize();
  154. }
  155. function autoResize(){
  156. var t1_height = document.getElementById("search-table").scrollHeight + document.getElementById("title").scrollHeight + 24;
  157. var iframeHeight= document.body.scrollHeight - t1_height;
  158. var iframeWidth= document.body.scrollWidth;
  159. sheet1.SetSheetHeight(iframeHeight);
  160. }
  161. document.body.onresize = addEvent( document.body.onresize, "autoResize()");
  162. </SCRIPT>
  163. <modular:search id="form1">
  164. <modular:key id="fevent" />
  165. </modular:search>
  166. <form id="form1" name="form1" method="post" modular:type="search">
  167. <TABLE id="t1" border="0" cellspacing="0" cellpadding="0" width="100%" height="100%">
  168. <INPUT type="hidden" name="fevent" id="fevent" value="">
  169. <INPUT type="hidden" name="DEMANDED_ID" value="">
  170. <INPUT type="hidden" name="BID_NO" value="">
  171. <INPUT type="hidden" name="BID_DEG" value="">
  172. <INPUT type='hidden' name="acct_id" value="<%= params.get("acct_id") %>">
  173. <INPUT type='hidden' name="P_AUTO_SEARCH" id="P_AUTO_SEARCH" value="<%= params.get("P_AUTO_SEARCH") %>">
  174. <div align="left" id="title" >
  175. <ul><li>구매_입찰결과</li></ul>
  176. </div>
  177. <!-- 검색조건 영역 : 시작 -->
  178. <TR><TD height="1">
  179. <!-- 검색조건 시작 -->
  180. <table id="search-table" class="search-form-table" >
  181. <colgroup>
  182. <col width="100" />
  183. <col/>
  184. <col width="100" />
  185. <col/>
  186. <col width="150" />
  187. </colgroup>
  188. <tr>
  189. <th>현장</th>
  190. <td >
  191. <%=InputText.getSiteCodeNew("p_dept_cd", "p_dept_nm", "", user, params.get("p_dept_cd"), params.get("p_dept_nm"))%>
  192. </td>
  193. <th>낙찰업체</th>
  194. <td >
  195. <INPUT type="text" name="P_VENDOR_NM" class="input" value="<%=params.get("P_VENDOR_NM") %>" style="width:90%">
  196. </td>
  197. <td class="button" rowspan="3">
  198. <span class="btnSearch center" id="btnSearch"><a href="javascript:void(0);">검색</a></span>
  199. <span class="btnSearch center" id="btnExcel"><a href="javascript:sheetExcelDown(sheet1,$('li').html());">ExcelDown</a></span>
  200. </td>
  201. </tr>
  202. <tr>
  203. <th>입찰공고명</th>
  204. <td>
  205. <INPUT type="text" name="P_BID_MASTER_NM" class="input" value="<%=params.get("P_BID_MASTER_NM") %>" style="width:90%">
  206. </td>
  207. <th>상태</th>
  208. <td><%=CommCodeManager.getSelectCodeSearchList("BID_STATUS_CD","P_DEMANDED_STATUS","height=18;width:80px;","<option value=''>--전체--</option>",params.get("P_DEMANDED_STATUS"),"AND DETAILCD IN (10,91,92,93)","DETAILCD") %>
  209. <!-- <SELECT class='input_select' id='p_demanded_status' name='p_demanded_status' style='width:110px' >
  210. <option value=''>--전체--</option><OPTION value='10'>업체선정완료</OPTION><OPTION value='91'>유찰</OPTION><OPTION value='93'>재입찰</OPTION><OPTION value='92'>취소</OPTION>
  211. </SELECT> -->
  212. </td>
  213. </tr>
  214. <tr>
  215. <th>입찰번호</th>
  216. <td>
  217. <INPUT type="text" name="P_BID_NO" class="input" value="<%=params.get("P_BID_NO") %>" style="width:90%">
  218. </td>
  219. <th>MR번호</th>
  220. <td>
  221. <INPUT type="text" name="P_MR_NO" class="input" value="<%=params.get("P_MR_NO") %>" style="width:90%">
  222. </td>
  223. </tr>
  224. </table>
  225. </TD></TR>
  226. </TABLE>
  227. <div id="sheet1_div" style=" padding-top:5px; height: auto; min-height: 350px; overflow: auto;">
  228. <script>createIBSheet('sheet1','100%', '350px');</script>
  229. </div>
  230. </FORM>