member_view5_detail.php 7.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305
  1. <?php
  2. include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
  3. include $_SERVER['DOCUMENT_ROOT'].ADMIN_PATH.'common/auth_chk.php';
  4. $mp = "20"; //set top nav
  5. $cd_board = "02";
  6. $PageNo = $_REQUEST["PageNo"];
  7. if($cd_board<>"01" && $cd_board <> "03" && $cd_board <> "02" && $cd_board <> "04"){
  8. AlertRedirect("잘못된 요청입니다.",ADMIN_PATH."/index.php");
  9. }
  10. if($cd_seq =="" || $cd_seq ==null){
  11. AlertRedirect("잘못된 요청입니다.",ADMIN_PATH."/index.php");
  12. }
  13. /*조회수 */
  14. $hitsql="update board_master
  15. set
  16. no_hit= no_hit+1
  17. WHERE cd_seq =$cd_seq";
  18. $result = mysql_query($hitsql,$connect);
  19. $sql ="SELECT
  20. cd_seq , cd_board ,cd_user ,cd_userid , nm_title , nm_name, ds_top, ds_main, ds_kind
  21. ,no_hit, ds_open, nm_content, nm_file, nm_updir, nm_reply, dt_insert, ds_delind ,nm_etc1, nm_etc2, nm_etc3, nm_etc4, nm_etc5
  22. FROM board_master
  23. WHERE
  24. cd_board='$cd_board' AND cd_seq='$cd_seq' AND ds_delind='N'";
  25. $col=mysql_fetch_array(mysql_query($sql));
  26. if (!empty($col[cd_seq])){ //일반회원
  27. $cd_seq = $col[cd_seq];
  28. $cd_board = $col[cd_board];
  29. $cd_user = $col[cd_user];
  30. $cd_userid = $col[cd_userid];
  31. $nm_title = $col[nm_title];
  32. $no_hit = $col[no_hit];
  33. $ds_open = $col[ds_open];
  34. $nm_content = $col[nm_content];
  35. $nm_file = $col[nm_file];
  36. $nm_updir = $col[nm_updir];
  37. $nm_reply = $col[nm_reply];
  38. $dt_insert = $col[dt_insert];
  39. $ds_delind = $col[ds_delind];
  40. $ds_top = $col[ds_top];
  41. $ds_main = $col[ds_main];
  42. $ds_kind = $col[ds_kind];
  43. $nm_name = $col[nm_name];
  44. $nm_etc1 = $col[nm_etc1];
  45. $nm_etc2 = $col[nm_etc2];
  46. $nm_etc3 = $col[nm_etc3];
  47. $nm_etc4 = $col[nm_etc4];
  48. $nm_etc5 = $col[nm_etc5];
  49. //if($_SESSION[cd_userid] != $cd_userid){
  50. // AlertBack("게시물을 수정할 권한이 없습니다.");
  51. //}
  52. $mode="Update";
  53. }else{
  54. AlertBack("게시물을 가져오지 못하였습니다.");
  55. }
  56. $PageNo = $PageNo;
  57. //이전글
  58. $presql ="SELECT
  59. cd_seq , cd_board ,cd_userid , nm_title ,
  60. no_hit, ds_open, nm_content, nm_file, nm_updir, dt_insert, ds_delind
  61. FROM board_master
  62. WHERE
  63. cd_board='$cd_board' AND ds_delind='N'
  64. AND cd_seq < (SELECT cd_seq FROM board_master WHERE cd_board='$cd_board' AND ds_delind='N' AND cd_seq = $cd_seq)
  65. ORDER BY cd_seq DESC LIMIT 1";
  66. $preCol=mysql_fetch_array(mysql_query($presql));
  67. //다음글
  68. $nextSql ="SELECT
  69. cd_seq , cd_board ,cd_userid , nm_title ,
  70. no_hit, ds_open, nm_content, nm_file, nm_updir, dt_insert, ds_delind
  71. FROM board_master
  72. WHERE
  73. cd_board='$cd_board' AND ds_delind='N'
  74. AND cd_seq > (SELECT cd_seq FROM board_master WHERE cd_board='$cd_board' AND ds_delind='N' AND cd_seq = $cd_seq)
  75. ORDER BY cd_seq DESC LIMIT 1";
  76. $nextCol=mysql_fetch_array(mysql_query($nextSql));
  77. ?>
  78. <? include("../inc/inc_top.php") ?>
  79. <? include("../inc/inc_header.php") ?>
  80. <script type="text/javascript" src="/common/smarteditor/js/HuskyEZCreator.js" charset="utf-8"></script>
  81. <section id="contents">
  82. <h2>일반회원 관리</h2>
  83. <? include("../inc/inc_header_member.php") ?>
  84. <h3><em>▶</em> 문의내역</h3>
  85. <form id="frmProc" name="frmProc" method="post">
  86. <div class="tbl_wrap">
  87. <table class="tbl_list2">
  88. <colgroup>
  89. <col width="7%">
  90. <col width="32%">
  91. <col width="*">
  92. </colgroup>
  93. <tr>
  94. <th>제목</th>
  95. <td><?=$nm_title?>&nbsp;[등록일:<?=$dt_insert?> &nbsp;조회수:<?=$no_hit?>]</td>
  96. </tr>
  97. <?
  98. if($cd_board == "02"){
  99. ?>
  100. <tr>
  101. <th>작성자</th>
  102. <td><?=$nm_name?></td>
  103. </tr>
  104. <?
  105. }
  106. ?>
  107. <?
  108. if($cd_board == "04"){
  109. ?>
  110. <tr>
  111. <th>문의유형</th>
  112. <td><?=$nm_etc1?></td>
  113. </tr>
  114. <tr>
  115. <th>이름</th>
  116. <td><?=$nm_name?></td>
  117. </tr>
  118. <tr>
  119. <th>연락처</th>
  120. <td><?=$nm_etc2?></td>
  121. </tr>
  122. <tr>
  123. <th>이메일</th>
  124. <td><?=$nm_etc3?></td>
  125. </tr>
  126. <?
  127. }
  128. ?>
  129. <tr>
  130. <th>내용</th>
  131. <td class="text_height pd"><?=$nm_content?></td>
  132. </tr>
  133. <?
  134. if($cd_board == "01"){
  135. ?>
  136. <tr>
  137. <th>파일</th>
  138. <td><? if($nm_file!=""){?><a href="/common/lib/download.php?nm_file=<?=urlencode($nm_file)?>&type=board&cd_board=<?=$cd_board?>"><?=$nm_file?></a><?}else{?>첨부파일없음<?}?></td>
  139. </tr>
  140. <?
  141. }
  142. ?>
  143. </table>
  144. </div>
  145. <?
  146. if($_SESSION[admin_cd_userid] && $cd_board == "02"){
  147. ?>
  148. <h3><em>▶</em> 답변하기</h3>
  149. <div class="tbl_wrap">
  150. <table class="tbl_list2">
  151. <colgroup>
  152. <col width="7%">
  153. <col width="32%">
  154. <col width="*">
  155. </colgroup>
  156. <!--tr>
  157. <th>제목</th>
  158. <td><input type="text" class="inp_txt" style="width:90%;"></td>
  159. </tr-->
  160. <tr>
  161. <th>작성자</th>
  162. <td>관리자</td>
  163. </tr>
  164. <tr>
  165. <th>내용</th>
  166. <td class="pd"><textarea cols="70" rows="10" style="height:230px;" name="nm_reply" id="nm_reply"><?=$nm_reply?></textarea></td>
  167. </tr>
  168. </table>
  169. </div>
  170. <?
  171. }
  172. ?>
  173. <div class="btn_right">
  174. <?
  175. if($_SESSION[admin_cd_userid]){
  176. ?>
  177. <a href="./member_view5.php?cd_user=<?=$cd_user?>&PageNo=<?=$PageNo?>" class="rnd_btn ty2 gray">취소</a>
  178. <?
  179. if($cd_board == "02"){
  180. ?>
  181. <a href="#" class="rnd_btn ty2 black" id="btn_write">답변</a>
  182. <?
  183. }else if($cd_board == "04"){
  184. ?>
  185. <?
  186. }else{
  187. ?>
  188. <a href="#" class="rnd_btn ty2 black" id="btn_write" onclick="fnProc('Update');return false;">수정</a>
  189. <a href="#" class="rnd_btn ty2 black" id="btn_write" onclick="fnProc('Delete');return false;">삭제</a>
  190. <?
  191. }
  192. ?>
  193. <?
  194. }
  195. ?>
  196. </div>
  197. <input type="hidden" name="mode" id="mode" value="Update"/>
  198. <input type="hidden" name="cd_board" id="cd_board" value="<?=$cd_board?>"/>
  199. <input type="hidden" name="cd_userid" id="cd_userid" value="<?=$cd_userid?>"/>
  200. <input type="hidden" name="cd_seq" id="cd_seq" value="<?=$cd_seq?>"/>
  201. <input type="hidden" name="PageNo" id="PageNo" value="<?=$PageNo?>"/>
  202. </form>
  203. </section>
  204. <?
  205. if($_SESSION[admin_cd_userid] && $cd_board == "02"){
  206. ?>
  207. <script language="javascript" type="text/javascript">
  208. $(document).ready(function() {
  209. $("#btn_write").bind("click",function(){
  210. oEditors.getById["nm_reply"].exec("UPDATE_CONTENTS_FIELD", []);
  211. var fieldlist = [["nm_reply","답변"]];
  212. if (!fnCheckForm(fieldlist)){
  213. return false;
  214. }else{
  215. var c = confirm("처리하시겠습니까?");
  216. if(c){
  217. $.post("/admin/board/board_proc.php", { mode: "ReplyInquiryAjax", cd_seq: "<?=$cd_seq?>", cd_userid: "<?=$cd_userid?>", nm_reply: $("#nm_reply").val()},function(data) {
  218. if(data=="Y"){
  219. alert("답변 등록에 성공하였습니다.");
  220. return;
  221. }else{
  222. alert("답변 등록에 실패하였습니다.");
  223. return;
  224. }
  225. });
  226. return false;
  227. }else{
  228. return false;
  229. }
  230. }
  231. });
  232. });
  233. </script>
  234. <script type="text/javascript">
  235. var oEditors = [];
  236. nhn.husky.EZCreator.createInIFrame({
  237. oAppRef: oEditors,
  238. elPlaceHolder: "nm_reply",
  239. sSkinURI: "/common/smarteditor/SmartEditor2Skin.html",
  240. htParams : {
  241. bUseToolbar : true,
  242. bUseVerticalResizer : true,
  243. bUseModeChanger : true,
  244. fOnBeforeUnload : function(){}
  245. }, //boolean
  246. fOnAppLoad : function(){},
  247. fCreator: "createSEditor2"
  248. });
  249. function pasteHTML(fcode,objKey){
  250. var sHTML = '<span style="color:#FF0000;"><img src="'+fcode+'"></span>';
  251. oEditors.getById[objKey].exec("PASTE_HTML", [sHTML]);
  252. }
  253. function delHTML(source){
  254. oEditors.getById[source].exec("SET_CONTENTS", [""]);
  255. }
  256. function copyHTML(source,dest) {
  257. var sHTML = getHTML(source);
  258. oEditors.getById[dest].exec("PASTE_HTML", [sHTML]);
  259. }
  260. function getHTML(source){
  261. return oEditors.getById[source].getIR();
  262. }
  263. </script>
  264. <?
  265. }
  266. ?>
  267. <? include("../inc/inc_footer.php") ?>
  268. <? include("../inc/inc_bottom.php") ?>
  269. <?
  270. mysql_close($connect);
  271. ?>