TBEResultList.jsp 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302
  1. <%--
  2. - Author(s) : Hyung min Son
  3. - Date : 2014.09.11
  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("BID_CHK_YN","DETAILCD","Y"), "DETAILNM", "DETAILCD");
  24. String BID_CHK_CD = initCombo.getCode();
  25. String BID_CHK_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/outside/TBEResultList_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_demanded_from_dt").keydown(function (event){var keycode = (event.keyCode ? event.keyCode : event.which); if(keycode == 8||keycode == 46){$("#p_demanded_from_dt").val("");}});
  59. $("#p_demanded_to_dt").keydown(function (event){var keycode = (event.keyCode ? event.keyCode : event.which); if(keycode == 8||keycode == 46){$("#p_demanded_to_dt").val("");}});
  60. $("#p_rceipt_from_dt").keydown(function (event){var keycode = (event.keyCode ? event.keyCode : event.which); if(keycode == 8||keycode == 46){$("#p_rceipt_from_dt").val("");}});
  61. $("#p_rceipt_to_dt").keydown(function (event){var keycode = (event.keyCode ? event.keyCode : event.which); if(keycode == 8||keycode == 46){$("#p_rceipt_to_dt").val("");}});
  62. /* $("#p_demanded_status").change(function(){$("#btnSearch").click();}); */
  63. $("#P_BID_MASTER_NM").keydown(function (event){var keycode = (event.keyCode ? event.keyCode : event.which);if(keycode == 13)$("#btnSearch").click();});
  64. //$("#btnSearch").click();
  65. //발주의뢰일 To
  66. $("#p_demanded_to_dt").change(function() {
  67. if($("#p_demanded_from_dt").val().length > 0){
  68. if($("#p_demanded_to_dt").val() <= $("#p_demanded_from_dt").val()){
  69. alert("시작 또는 종료(마감) 일시가 잘못 입력되었습니다.");
  70. $("#p_demanded_to_dt").val("");
  71. return;
  72. }
  73. }
  74. });
  75. //발주 의뢰일 form
  76. $("#p_demanded_from_dt").change(function() {
  77. if($("#p_demanded_to_dt").val().length > 0){
  78. if($("#p_demanded_from_dt").val() >= $("#p_demanded_to_dt").val()){
  79. alert("시작 또는 종료(마감) 일시가 잘못 입력되었습니다.");
  80. $("#p_demanded_from_dt").val("");
  81. return;
  82. }
  83. }
  84. });
  85. //접수일 form
  86. $("#p_rceipt_from_dt").change(function() {
  87. if($("#p_rceipt_to_dt").val().length > 0){
  88. if($("#p_rceipt_from_dt").val() > $("#p_rceipt_to_dt").val()){
  89. alert("시작 또는 종료(마감) 일시가 잘못 입력되었습니다.");
  90. $("#p_rceipt_from_dt").val("");
  91. return;
  92. }
  93. }
  94. });
  95. //접수일 to
  96. $("#p_rceipt_to_dt").change(function() {
  97. if($("#p_rceipt_from_dt").val().length > 0){
  98. if($("#p_rceipt_to_dt").val() < $("#p_rceipt_from_dt").val()){
  99. alert("시작 또는 종료(마감) 일시가 잘못 입력되었습니다.");
  100. $("#p_rceipt_to_dt").val("");
  101. return;
  102. }
  103. }
  104. });
  105. $("#dataClear1").click(function(){$("#p_demanded_from_dt").val("");$("#p_demanded_to_dt").val("");});
  106. $("#dataClear2").click(function(){$("#p_rceipt_from_dt").val("");$("#p_rceipt_to_dt").val("");});
  107. }
  108. /**
  109. * IBSheet object initialize
  110. */
  111. function gridInit(sheetName){
  112. var init_sheet = {};
  113. init_sheet.Cfg = {SearchMode:2, Page:30};
  114. init_sheet.Cols = [
  115. {Header:'Del', Type:"DelCheck", SaveName:"DEL_CHECK", Width:50, Align:"Center", Hidden:"True"},
  116. {Header:'Status', Type:"Status", SaveName:"STATUS", Width:0, Align:"Center", Hidden:"True"},
  117. {Header:'No.', Type:"Seq", SaveName:"NO", Width:0, Align:"Center", Hidden:"True"},
  118. {Header:'현장', Type:"Text", SaveName:"DEPT_NM", Width:180, Align:"Left"},
  119. {Header:'입찰번호', Type:"Text", SaveName:"BID_NO", Width:150, Align:"Center"},
  120. {Header:'차수', Type:"Text", SaveName:"BID_DEG", Width:30, Align:"Center"},
  121. {Header:'☞입찰공고명', Type:"Text", SaveName:"BID_MASTER_NM", Width:200, Align:"Left", Cursor:"pointer"},
  122. {Header:'심사자', Type:"Text", SaveName:"EVAL_EMPNM", Width:80, Align:"Center"},
  123. {Header:'검토완료/\n대상업체', Type:"Text", SaveName:"TBE_CNT", Width:0, Align:"Center"},
  124. {Header:'기술문서 요청일', Type:"Text", SaveName:"SUPP_REQ_DY", Width:0, Align:"Center"},
  125. {Header:'검토완료일', Type:"Text", SaveName:"TBE_FIN_DT", Width:0, Align:"Center"},
  126. {Header:'입찰진행상태', Type:"Text", SaveName:"STATUS_NM", Width:0, Align:"Center", Hidden:"True"},
  127. {Header:'연기', Type:"Combo", SaveName:"POSTPONE_YN", Width:30, Align:"Center", ComboText:"<%=BID_CHK_NM%>", ComboCode:"<%=BID_CHK_CD%>"},
  128. {Header:'정정', Type:"Combo", SaveName:"MODIFY_YN", Width:30, Align:"Center", ComboText:"<%=BID_CHK_NM%>", ComboCode:"<%=BID_CHK_CD%>"},
  129. {Header:'상태', Type:"Text", SaveName:"TBE_STATUS_NM", Width:50, Align:"Center"},
  130. {Header:'발주번호', Type:"Text", SaveName:"DEMANDED_ID", Width:80, Align:"Center", Hidden:"True"}
  131. ];
  132. init_sheet.HeaderMode = {Sort:1};
  133. IBS_InitSheet(sheetName, init_sheet);
  134. sheetName.SetDataAutoTrim(0);
  135. sheetName.SetEditable(false);
  136. sheetName.SetActionMenu("ExcelDown");
  137. setGridSize();
  138. }
  139. function sheet1_OnSelectMenu(Text, Code) {
  140. // text 또는 code값으로 Action수행
  141. switch(Text) {
  142. case "ExcelDown":
  143. sheetExcelDown(sheet1,$('li').html());
  144. break;
  145. }
  146. }
  147. /**
  148. * IBSheet Event: Search End(IBSheet 데이터 조회 CallBack)
  149. */
  150. function sheet1_OnSearchEnd(code, message) {
  151. if(code == 0) {
  152. setGridSize();
  153. sheet1.SetColFontColor("BID_MASTER_NM", "#0000ff");
  154. sheet1.SetColFontColor("POSTPONE_YN", "#ff0000");
  155. sheet1.SetColFontColor("MODIFY_YN", "#ff0000");
  156. } else {
  157. //조회 에러 수행
  158. alert(message);
  159. }
  160. }
  161. /**
  162. * IBSheet Event: Click
  163. */
  164. function sheet1_OnClick(Row, Col, Value, CellX, CellY, CellW, CellH) {
  165. }
  166. /**
  167. * IBSheet size setting
  168. */
  169. function setGridSize() {sheet1.FitColWidth();}
  170. /**
  171. * IBSheet Event: DBLCLICK
  172. */
  173. function sheet1_OnDblClick(Row, Col, Value, CellX, CellY, CellW, CellH) {
  174. if(Row == 0)return;
  175. if (Col == 6) {
  176. $("#DEMANDED_ID").val(sheet1.GetCellValue(Row, "DEMANDED_ID"));
  177. $("#BID_NO").val(sheet1.GetCellValue(Row, "BID_NO"));
  178. $("#BID_DEG").val(sheet1.GetCellValue(Row, "BID_DEG"));
  179. $("#p_list").val("/bid/outside/TBEResultList.screen");
  180. $("#fevent").val("FORM_SELECT");
  181. $("#form1").attr("action", "/bid/outside/TBECheck.screen");
  182. $("#form1").attr("target", "_self");
  183. $("#form1").attr("method", "post");
  184. $("#form1").submit();
  185. }
  186. }
  187. function sheet1_OnSmartResize(Width, Height) {
  188. sheet1.FitColWidth();
  189. autoResize();
  190. }
  191. function autoResize(){
  192. var t1_height = document.getElementById("search-table").scrollHeight + document.getElementById("title").scrollHeight + 24;
  193. var iframeHeight= document.body.scrollHeight - t1_height;
  194. var iframeWidth= document.body.scrollWidth;
  195. sheet1.SetSheetHeight(iframeHeight);
  196. }
  197. function searchSiteClose(result) {
  198. //PopsearchSite
  199. if( result == null ){
  200. $("#p_dept_nm").val("");
  201. $("#p_dept_cd").val("");
  202. }else{
  203. $("#p_dept_nm").val(result[1]);
  204. $("#p_dept_cd").val(result[0]);
  205. }
  206. setTimeout(function(){fLayerPopClose('_searchSite');},100);
  207. }
  208. </SCRIPT>
  209. <modular:search id="form1">
  210. <modular:key id="fevent" />
  211. </modular:search>
  212. <form id="form1" name="form1" method="post" modular:type="search">
  213. <INPUT type="hidden" name="fevent" id="fevent" value="">
  214. <INPUT type="hidden" name="DEMANDED_ID" value="">
  215. <INPUT type="hidden" name="BID_NO" value="">
  216. <INPUT type="hidden" name="BID_DEG" value="">
  217. <INPUT type="hidden" name="p_list" value="">
  218. <INPUT type='hidden' name="acct_id" value="<%= params.get("acct_id") %>">
  219. <TABLE id="t1" border="0" cellspacing="0" cellpadding="0" width="100%" height="100%">
  220. <TR><TD height="1">
  221. <div align="left" id="title" >
  222. <ul><li>외주_TBE결과조회</li></ul>
  223. </div>
  224. </TD></TR>
  225. <!-- 검색조건 영역 : 시작 -->
  226. <TR><TD height="1">
  227. <TR><TD height="1">
  228. <!-- 검색조건 시작 -->
  229. <table id="search-table" class="search-form-table" >
  230. <colgroup>
  231. <col width="100" />
  232. <col width="40%" />
  233. <col width="100" />
  234. <col/>
  235. <col width="150" />
  236. </colgroup>
  237. <tr>
  238. <th>현장</th>
  239. <td colspan="3">
  240. <%=InputText.getSiteCodeNew("p_dept_cd", "p_dept_nm", "", user, params.get("p_dept_cd"), params.get("p_dept_nm"))%>
  241. </td>
  242. <td class="button" rowspan="3">
  243. <span class="btnSearch center" id="btnSearch"><a href="javascript:void(0);">검색</a></span>
  244. <span class="btnSearch center" id="btnExcel"><a href="javascript:sheetExcelDown(sheet1,$('li').html());">ExcelDown</a></span>
  245. </td>
  246. </tr>
  247. <tr>
  248. <th>입찰공고명</th>
  249. <td>
  250. <INPUT type="text" name="P_BID_MASTER_NM" class="input" value="<%=params.get("P_BID_MASTER_NM") %>" style="width:90%">
  251. </td>
  252. <th>상태</th>
  253. <td><%=CommCodeManager.getSelectCodeSearchList("TBE_LIST_STATUS","P_DEMANDED_STATUS","height=18;width:80px;","<option value=''>--전체--</option>",params.get("P_DEMANDED_STATUS"),"","DETAILCD") %>
  254. <!-- <SELECT class='input_select' id='p_demanded_status' name='p_demanded_status' style='width:80px;' >
  255. <option value=''>--전체--</option><OPTION value='01'>검토대상</OPTION><OPTION value='02'>작성중</OPTION><OPTION value='10'>검토완료</OPTION>
  256. </SELECT> -->
  257. </td>
  258. </tr>
  259. </table>
  260. </TD></TR>
  261. </TABLE>
  262. <div id="sheet1_div" style=" padding-top:5px; height: auto; min-height: 400px; overflow: auto;">
  263. <script>createIBSheet('sheet1','100%', '400px');</script>
  264. </div>
  265. </FORM>