282 lines
13 KiB
Plaintext
282 lines
13 KiB
Plaintext
<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%request.setCharacterEncoding("utf-8");%>
|
|
<%@include file="/include/include.jsp"%>
|
|
<%
|
|
login_tag = 1;
|
|
%>
|
|
<%@include file="/include/head.jsp"%>
|
|
<%@include file="/cms_for_bcb/show_top.jsp"%>
|
|
<%
|
|
String para_t = "show_no="+ show_no +"&check_no="+ check_no + "&c_relation=" + c_relation + "&c_relation2=" + c_relation2;
|
|
String c_no = r_call(request.getParameter("c_no"));
|
|
%>
|
|
<script>
|
|
function go(){
|
|
if(document.ss.c_name.value == ""){
|
|
alert("Insertar nombre de comunidad")
|
|
document.ss.c_name.focus()
|
|
}else if(document.ss.c_target.value == ""){
|
|
alert("Insertar objetivo de comunidad")
|
|
document.ss.c_target.focus()
|
|
}else if(document.ss.c_exp.value == ""){
|
|
alert("Insertar Explicación de la comunidad")
|
|
document.ss.c_exp.focus()
|
|
}else{
|
|
document.ss.action = "edit_ok.jsp?<%=para_t%>"
|
|
document.ss.method = "post"
|
|
document.ss.target = "exec"
|
|
document.ss.submit()
|
|
}
|
|
}
|
|
</script>
|
|
<form name="ss">
|
|
<input name="c_home" value="<%=c_home%>" type="hidden">
|
|
<input name="c_no" value="<%=c_no%>" type="hidden">
|
|
<div class="row">
|
|
<%
|
|
String sql_c = "select a.* , b.c_name as m_name, b.c_id as m_id ";
|
|
sql_c = sql_c + ", (select count(c_no) as m_number from tbl_community_member where c_community_no = a.c_no and c_use = 0 and c_now in (0,1) ) as m_number ";
|
|
sql_c = sql_c + " from tbl_community a ";
|
|
sql_c = sql_c + " inner join tbl_member b on b.c_no = a.c_member_no ";
|
|
sql_c = sql_c + " where a.c_no = "+ c_no +" and a.c_use = 0 and a.c_home = "+ c_home +" and c_member_no = "+ session.getAttribute("member_no") +" ";
|
|
ResultSet rs_c = stmt.executeQuery(sql_c);
|
|
if (rs_c.next()) {
|
|
%>
|
|
<div class="col-lg-12 col-md-12 col-sm-12" style="">
|
|
<div style="padding-bottom:10px">
|
|
<b>◎ Información de la comunidad de gestión</b>
|
|
</div>
|
|
|
|
<div class="col-lg-12 col-md-12 col-sm-12" style="border:1px solid #cdcdcd;padding:10px;padding-left:20px;padding-right:20px">
|
|
<table style="width:100%">
|
|
<tr><td style="width:20%;text-align:center;height:30px">
|
|
<font color=red>*</font>Nombre de la comunidad</b>
|
|
</td><td style="width:80%;text-align:left;padding:10px">
|
|
<input name="c_name" value="<%=rs_c.getString("c_name")%>" style="width:80%;height:30px;border:solid 1px #cdcdcd" maxlength="300">
|
|
</td></tr>
|
|
<tr><td style="text-align:center;height:30px">
|
|
<font color=red>*</font>Comunidad <b> objetivo</b>
|
|
</td><td style="text-align:left;padding:10px">
|
|
<input name="c_target" value="<%=rs_c.getString("c_target")%>" style="width:100%;height:30px;border:solid 1px #cdcdcd" maxlength="300">
|
|
</td></tr>
|
|
<tr><td style="text-align:center;height:30px;vertical-align:top;padding-top:20px">
|
|
<font color=red>*</font>Comunidad <b> Explique</b>
|
|
</td><td style="text-align:left;padding:10px">
|
|
<textarea name="c_exp" style="width:100%;height:300px;border:solid 1px #cdcdcd"><%=rs_c.getString("c_exp")%></textarea>
|
|
</td></tr>
|
|
</table>
|
|
<table width="100%">
|
|
<tr>
|
|
<td align="center" style="padding-bottom:10px;padding-top:10px;font-weight:bold;">
|
|
<a href="#none" onclick="go()" style="width: 250px; line-height: 26px; text-align: center;display: inline-block; background: #F5E0CB; border: 1px solid #555; border-radius: 5px; color: #000000;">Editar información de la comunidad</a>
|
|
</td>
|
|
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
|
|
</div>
|
|
<div class="col-lg-12 col-md-12 col-sm-12" style="padding-top:30px">
|
|
<div style="padding-bottom:10px">
|
|
<b>◎Gestión para juntas comunitarias</b>
|
|
</div>
|
|
<div class="col-lg-12 col-md-12 col-sm-12" style="border:1px solid #cdcdcd;padding:10px;padding-left:20px;padding-right:20px">
|
|
<table style="width:100%">
|
|
<tr>
|
|
<td style="text-align:center;padding:5px;background:#efefef;">
|
|
Nombre de la placa
|
|
</td>
|
|
<td style="text-align:center;padding:5px;background:#efefef;max-width:100px">
|
|
Autoridad de escritura
|
|
</td>
|
|
<td style="text-align:center;padding:5px;background:#efefef;max-width:60px">
|
|
Oder
|
|
</td>
|
|
<td style="text-align:center;padding:5px;background:#efefef;max-width:60px">
|
|
Usar
|
|
</td>
|
|
<td style="text-align:center;padding:5px;background:#efefef;max-width:60px">
|
|
Editar
|
|
</td>
|
|
<td style="text-align:center;padding:5px;background:#efefef;max-width:60px">
|
|
Borrar
|
|
</td>
|
|
</tr>
|
|
<%
|
|
String sql_p = " select * from tbl_community_board ";
|
|
sql_p = sql_p + " where c_community_no = "+ c_no +" and c_use = 0 order by c_order asc ";
|
|
ResultSet rs_p = stmt.executeQuery(sql_p);
|
|
int op_order = 0;
|
|
int old_order = 0;
|
|
int old_no = 0;
|
|
while (rs_p.next()) {
|
|
op_order = op_order + 1;
|
|
%>
|
|
<tr>
|
|
<td style="text-align:center;padding:10px;border-bottom:1px solid #efefef">
|
|
<%=rs_p.getString("c_name")%>
|
|
</td>
|
|
<td style="text-align:center;padding:10px;border-bottom:1px solid #efefef">
|
|
<%if(rs_p.getInt("c_type") == 0){%>
|
|
Miembros
|
|
<%}%>
|
|
<%if(rs_p.getInt("c_type") == 1){%>
|
|
Maestro
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center;padding:10px;border-bottom:1px solid #efefef">
|
|
<%if(op_order > 1){%>
|
|
<a title="Up!" href="change_order.jsp?<%=para_t%>&c_home=<%=c_home%>&c_no=<%=c_no%>&c_view=1&c_board_no=<%=rs_p.getInt("c_no")%>&c_order=<%=rs_p.getInt("C_order")%>&old_no=<%=old_no%>&old_order=<%=old_order%>" target="exec">▲</a>
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center;padding:10px;border-bottom:1px solid #efefef">
|
|
<%if(rs_p.getInt("c_view")== 0 ){%>
|
|
<a title="Change" href="change_view.jsp?<%=para_t%>&c_home=<%=c_home%>&c_no=<%=c_no%>&c_view=1&c_board_no=<%=rs_p.getInt("c_no")%>" target="exec">O</a>
|
|
<%}else{%>
|
|
<a title="Change" href="change_view.jsp?<%=para_t%>&c_home=<%=c_home%>&c_no=<%=c_no%>&c_view=0&c_board_no=<%=rs_p.getInt("c_no")%>" target="exec">X</a>
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center;padding:10px;border-bottom:1px solid #efefef">
|
|
<a href="edit_board.jsp?<%=para_t%>&c_no=<%=c_no%>&c_board_no=<%=rs_p.getInt("c_no")%>">[Editar]</a>
|
|
</td>
|
|
<td style="text-align:center;padding:10px;border-bottom:1px solid #efefef">
|
|
<a href="#none" title="Delete" onclick="if(confirm('Si borra este tablero, \nTodos los datos se eliminarán en este tablero.\nEliminar ahora, ¿de verdad? ')){document.getElementById('exec').src='delete_board.jsp?<%=para_t%>&c_home=<%=c_home%>&c_no=<%=c_no%>&c_board_no=<%=rs_p.getInt("c_no")%>'}" >[Eliminar]</a>
|
|
</td>
|
|
</tr>
|
|
<%
|
|
old_order = rs_p.getInt("c_order");
|
|
old_no = rs_p.getInt("c_no");
|
|
}
|
|
rs_p.close();
|
|
%>
|
|
</table>
|
|
<table width="100%" style="">
|
|
<tr>
|
|
<td align="center" style="padding-bottom:10px;padding-top:20px;font-weight:bold;">
|
|
<a href="insert_board.jsp?<%=para_t%>&c_no=<%=c_no%>" style="width: 100px; line-height: 26px; text-align: center;display: inline-block; background: #F5E0CB; border: 1px solid #555; border-radius: 5px; color: #000000;">Insertar tablero</a>
|
|
</td>
|
|
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
|
|
</div>
|
|
<div class="col-lg-12 col-md-12 col-sm-12" style="padding-top:30px">
|
|
<div style="padding-bottom:10px">
|
|
<b>◎ Lista de miembros</b>
|
|
</div>
|
|
|
|
<div class="col-lg-12 col-md-12 col-sm-12" style="border:1px solid #cdcdcd;padding:10px;padding-left:20px;padding-right:20px">
|
|
<table style="width:100%">
|
|
<tr><td colspan=2 style="text-align:left;padding:10px;background:#efefef;vertical-align:top">
|
|
<div style="height:150px;overflow:auto;">
|
|
|
|
<%
|
|
String sql_m = " select b.c_no, b.c_name, b.c_id, a.c_now , a.c_date, a.c_content ";
|
|
sql_m = sql_m + " from tbl_community_member a ";
|
|
sql_m = sql_m + " inner join tbl_member b on b.c_no = a.c_member_no and b.c_use = 0 ";
|
|
sql_m = sql_m + " where a.c_community_no = "+ c_no + " and a.c_use = 0 and a.c_now = 1 ";
|
|
sql_m = sql_m + " order by a.c_now desc ";
|
|
|
|
ResultSet rs_m = stmt.executeQuery(sql_m);
|
|
int t1 = 0;
|
|
while (rs_m.next()) {
|
|
t1 = t1 + 1;
|
|
%>
|
|
<b><%=rs_m.getString("c_name")%></b> / <%=rs_m.getString("c_id")%>
|
|
/ <%=rs_m.getString("c_date").substring(0,10)%>
|
|
|
|
<a href="#none" onclick="if(confirm('DElete Este miembro, de verdad?')){document.getElementById('exec').src='delete_member.jsp?<%=para_t%>&c_home=<%=c_home%>&c_no=<%=c_no%>&c_member_no=<%=rs_m.getInt("c_no")%>'}" style="width: 220px; line-height: 20px; text-align: center;display: inline-block; background : #E76F63; border: 1px solid #555; border-radius: 5px; color: #ffffff;">Retirada de esta comunidad</a>
|
|
<div style="padding-left:20px;padding-bottom:10px;color:#898989">
|
|
<i><%=rs_m.getString("c_content")%></i>
|
|
</div>
|
|
<%}
|
|
rs_m.close();
|
|
%>
|
|
<%if(t1 == 0){%>
|
|
<center>
|
|
<br /><br /><br /><br />
|
|
No hay ningún miembro.
|
|
</center>
|
|
<%}%>
|
|
</div>
|
|
</td></tr>
|
|
</table>
|
|
</div>
|
|
|
|
</div>
|
|
<div class="col-lg-12 col-md-12 col-sm-12" style="padding-top:30px">
|
|
<div style="padding-bottom:10px">
|
|
<b>◎Estar listo para unirse completo</b>
|
|
</div>
|
|
|
|
<div class="col-lg-12 col-md-12 col-sm-12" style="border:1px solid #cdcdcd;padding:10px;padding-left:20px;padding-right:20px">
|
|
<table style="width:100%">
|
|
<tr><td colspan=2 style="text-align:left;padding:10px;background:#efefef;vertical-align:top">
|
|
<div style="height:150px;overflow:auto;">
|
|
|
|
<%
|
|
sql_m = " select b.c_no, b.c_name, b.c_id, a.c_now , a.c_date, a.c_content ";
|
|
sql_m = sql_m + " from tbl_community_member a ";
|
|
sql_m = sql_m + " inner join tbl_member b on b.c_no = a.c_member_no and b.c_use = 0 ";
|
|
sql_m = sql_m + " where a.c_community_no = "+ c_no + " and a.c_use = 0 and a.c_now = 0 ";
|
|
sql_m = sql_m + " order by a.c_now desc ";
|
|
|
|
rs_m = stmt.executeQuery(sql_m);
|
|
t1 = 0;
|
|
while (rs_m.next()) {
|
|
t1 = t1 + 1;
|
|
%>
|
|
<b><%=rs_m.getString("c_name")%></b> / <%=rs_m.getString("c_id")%>
|
|
/ <%=rs_m.getString("c_date").substring(0,10)%>
|
|
|
|
<a href="#none" onclick="if(confirm('Aprobación de este miembro?')){document.getElementById('exec').src='approval_member.jsp?<%=para_t%>&c_home=<%=c_home%>&c_no=<%=c_no%>&c_member_no=<%=rs_m.getInt("c_no")%>'}" style="width: 120px; line-height: 20px; text-align: center;display: inline-block; background : #0277D0; border: 1px solid #555; border-radius: 5px; color: #ffffff;">Aprobación</a>
|
|
|
|
<a href="#none" onclick="if(confirm('Desaprobación de este miembro, ¿de verdad?')){document.getElementById('exec').src='disapproval_member.jsp?<%=para_t%>&c_home=<%=c_home%>&c_no=<%=c_no%>&c_member_no=<%=rs_m.getInt("c_no")%>'}" style="width: 120px; line-height: 20px; text-align: center;display: inline-block; background : #E76F63; border: 1px solid #555; border-radius: 5px; color: #ffffff;">Desaprobación</a>
|
|
|
|
<div style="padding-left:20px;padding-bottom:10px;color:#898989">
|
|
<i><%=rs_m.getString("c_content")%></i>
|
|
</div>
|
|
<%}
|
|
rs_m.close();
|
|
%>
|
|
<%if(t1 == 0){%>
|
|
<center>
|
|
<br /><br /><br /><br />
|
|
No hay ningún miembro en espera.
|
|
</center>
|
|
<%}%>
|
|
</div>
|
|
</td></tr>
|
|
</table>
|
|
</div>
|
|
|
|
</div>
|
|
<div class="col-lg-12 col-md-12 col-sm-12" style="padding-top:30px">
|
|
<table width="100%">
|
|
<tr>
|
|
<td align="center" style="padding-bottom:10px;padding-top:10px;font-weight:bold;">
|
|
<a href="#none" onclick="if(confirm('Detener esta comunidad, ¿de verdad?')){document.getElementById('exec').src='delete.jsp?<%=para_t%>&c_home=<%=c_home%>&c_no=<%=c_no%>'}" style="width: 160px; line-height: 26px; text-align: center;display: inline-block; background : #E76F63; border: 1px solid #555; border-radius: 5px; color: #ffffff;">Detener esta comunidad</a>
|
|
|
|
<a href="list.jsp?<%=para_t%>" style="width: 100px; line-height: 26px; text-align: center;display: inline-block; background: #ededed; border: 1px solid #555; border-radius: 5px; color: #000000;">Cancelar</a>
|
|
</td>
|
|
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
|
|
<%}else{%>
|
|
<script>
|
|
alert("No eres maestro de esta comunidad")
|
|
location.href="list.jsp?<%=para_t%>"
|
|
</script>
|
|
<%}
|
|
rs_c.close();
|
|
%>
|
|
</div>
|
|
</form>
|
|
<iframe name="exec" id="exec" width="0px" height="0px"></iframe>
|
|
<%@include file="/cms_for_bcb/show_bottom.jsp"%>
|
|
<%@include file="/include/bottom.jsp"%>
|
|
<%@include file="/include/include_b.jsp"%>
|