483 lines
19 KiB
Plaintext
483 lines
19 KiB
Plaintext
<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%@include file="/include/include.jsp"%>
|
|
<%@include file="/include/head.jsp"%>
|
|
<%@include file="/cms_for_bcb/show_top.jsp"%>
|
|
<select id="language_select" onchange="setLanguage(this.value)">
|
|
<option value="en" <%= (request.getLocale().toString().equals("en") ? "selected" : "") %>>English</option>
|
|
<option value="es_PE" <%= (request.getLocale().toString().equals("es_PE") ? "selected" : "") %>>Spanish (Peru)</option>
|
|
</select>
|
|
</p>
|
|
|
|
<%
|
|
String c_channel = r_call(request.getParameter("c_channel"));
|
|
String c_hypo_no = r_call(request.getParameter("c_hypo_no"));
|
|
String[] hy_title = new String[10];
|
|
hy_title[1] = "Key Partners";
|
|
hy_title[2] = "Key Activities";
|
|
hy_title[3] = "Value Propositions";
|
|
hy_title[4] = "Customer Relationships";
|
|
hy_title[5] = "Customer Segments";
|
|
hy_title[6] = "Key Resources";
|
|
hy_title[7] = "Channels";
|
|
hy_title[8] = "Cost Structure";
|
|
hy_title[9] = "Revenue Streams";
|
|
String[] span_title = new String[10];
|
|
span_title[1] = "We need to partner with...";
|
|
span_title[2] = "The most important things to do for our business model to work are...";
|
|
span_title[3] = "Our customers need help...";
|
|
span_title[4] = "We plan to GET/KEEP/GROW using...";
|
|
span_title[5] = "We are helping...";
|
|
span_title[6] = "The most important assets for our business model to work are...";
|
|
span_title[7] = "We deliver our product/service to our customer via...";
|
|
span_title[8] = "One of our operational costs to run the business is...";
|
|
span_title[9] = "We make money by...";
|
|
|
|
String c_no = r_call(request.getParameter("c_no"));
|
|
|
|
%>
|
|
<%if(c_no.equals("")){%>
|
|
<script>
|
|
alert("Login.")
|
|
location.href="/"
|
|
</script>
|
|
<%}else{
|
|
|
|
String sql_interview = "select a.* from tbl_interview a where a.c_no = " + c_no;
|
|
ResultSet rs_interview = stmt2.executeQuery(sql_interview);
|
|
if(rs_interview.next()){
|
|
%>
|
|
|
|
<div class="row">
|
|
<div class="col-lg-12 col-md-12" >
|
|
<h5 class="theme-color" style="color:#22455E;text-align:center">·
|
|
<img src="/images/icon/mic.png" height="24px">
|
|
<span id="a1"> View a</span> <span id="a2" style="color: blue;">Customer Interview</span>
|
|
<a href="#none" onclick='window.open("/cms_for_bcb/process/movie/pop.jsp?c_no=<%=vod_no[13]%>","sk","left=50,top=50,scrollbars=no,resizable=no,width=400,height=300")' title="View Education Clip"><img src="/images/icon/movie.gif" height="16px" alt=""></a>
|
|
|
|
</h5>
|
|
<div class="divider mb-20" ></div>
|
|
</div>
|
|
<div class="col-lg-12 col-md-12" style="background:#ededed;padding-top:8px;padding-bottom:4px">
|
|
<div class="col-lg-10 col-md-10" >
|
|
|
|
<!--
|
|
<%=rs_interview.getString("c_title")%>
|
|
-->
|
|
</div>
|
|
<div class="col-lg-2 col-md-2" style="text-align:right">
|
|
<%if(rs_interview.getInt("c_use") == 0){%>
|
|
<%if(session.getAttribute("member_type").equals("0") && session.getAttribute("member_team_no").equals(c_team) && make_ok == 0){%>
|
|
<a href="edit_interview.jsp?<%=para_t%>&c_team=<%=c_team%>&c_no=<%=rs_interview.getInt("c_no")%>&c_hypo_no=<%=c_hypo_no%>" style="width: 40px; line-height: 24px; text-align: center;display: inline-block; background: blue; border: 1px solid #ffffff;border-radius: 12px; color: #ffffff;font-weight:400;font-size: 13px;"><span id="a3">Edit</span></a>
|
|
<a href="#none" onclick="if(confirm('If you delete this, all data will be deleted.\nDelete?')){location.href='delete_interview.jsp?<%=para_t%>&c_team=<%=c_team%>&c_no=<%=rs_interview.getInt("c_no")%>'}" style="width: 40px; line-height: 24px; text-align: center;display: inline-block; background: #454545; border: 1px solid #ffffff;border-radius: 12px; color: #ffffff;font-weight:400;font-size: 13px;"><span id="a4">Delete</span></a>
|
|
<%}%>
|
|
<%}else{%>
|
|
<span id="a25" style="color: red;">Deleted</span>(<%=rs_interview.getString("c_use_date").substring(0,10)%>)
|
|
<%}%>
|
|
|
|
</div>
|
|
|
|
</div>
|
|
<div class="col-lg-7 col-md-7" style="padding:10px;text-align:left" >
|
|
|
|
<div class="col-lg-12 col-md-12" >
|
|
<img src="/images/icon/point3.png" height="20px"> <span id="a6"><b> Whom did you interview?</b> </span>
|
|
</div>
|
|
<div class="col-lg-12 col-md-12" style="padding-top:5px">
|
|
<%
|
|
String sql_interview2 = "select a.* from tbl_interview_target a where a.c_interview_no = " + c_no + " order by a.c_no asc ";
|
|
ResultSet rs_interview2 = stmt2.executeQuery(sql_interview2);
|
|
int kp = 0;
|
|
while(rs_interview2.next()){
|
|
kp = kp + 1;
|
|
%>
|
|
<table width=100% cellspacing=2 cellpadding=0>
|
|
<%if(kp > 1){%>
|
|
<tr><td height=3 colspan=3 ></td></tr>
|
|
<tr><td height=1 colspan=3 bgcolor="cdcdcd" ></td></tr>
|
|
<tr><td height=3 colspan=3 ></td></tr>
|
|
<%}%>
|
|
<tr><td rowspan=4 valign=top style="padding-top:2px">
|
|
<b><%=kp%>.</b>
|
|
</td>
|
|
<td style="padding:2px">
|
|
<%=rs_interview2.getString("c_company")%>
|
|
</td></tr>
|
|
<tr>
|
|
<td style="width:100%;padding:2px">
|
|
<%=rs_interview2.getString("c_position")%> /
|
|
<%=rs_interview2.getString("c_name")%>
|
|
</td></tr>
|
|
<%if(!rs_interview2.getString("c_email").equals("")){%>
|
|
<tr>
|
|
<td style="width:100%;padding:2px">
|
|
<%=rs_interview2.getString("c_email")%> /
|
|
<%=rs_interview2.getString("c_phone")%>
|
|
</td></tr>
|
|
<tr>
|
|
<td style="width:100%;padding:2px" >
|
|
<%=rs_interview2.getString("c_industry")%> /
|
|
<%=rs_interview2.getString("c_country")%> /
|
|
<%=rs_interview2.getString("c_state")%>
|
|
</td></tr>
|
|
<%}%>
|
|
</table>
|
|
<%}
|
|
rs_interview2.close();
|
|
%>
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-5 col-md-5" style="padding:10px;text-align:left" >
|
|
|
|
<div class="col-lg-12 col-md-12" >
|
|
<img src="/images/icon/point3.png" height="20px"><b id="a7"> Interview Type & Date</b>
|
|
</div>
|
|
<div class="col-lg-12 col-md-12" style="padding-top:5px;padding-left:20px">
|
|
<table width=100% cellspacing=2 cellpadding=0 >
|
|
<tr>
|
|
<td style="width:60%;padding:5px" bgcolor=ededed>
|
|
<img src="/images/icon/point3.png" height="14px"> <span id="a8">Engagement Type</span>
|
|
</td><td style="width:40%;padding:5px" bgcolor=ededed>
|
|
<img src="/images/icon/point3.png" height="14px"> <span id="a9">Interview Date</span>
|
|
</td></tr>
|
|
<tr>
|
|
<td style="padding:5px">
|
|
<%if(rs_interview.getInt("c_type") == 0){%>
|
|
<span id="a16"> In Person</span>
|
|
<%}%>
|
|
<%if(rs_interview.getInt("c_type") == 1){%>
|
|
<span id="a17"> Phone</span>
|
|
<%}%>
|
|
<%if(rs_interview.getInt("c_type") == 2){%>
|
|
<span id="a18">Email</span>
|
|
<%}%>
|
|
<%if(rs_interview.getInt("c_type") == 3){%>
|
|
<span id="a19"> Video Chat</span>
|
|
<%}%>
|
|
</td><td style="padding:5px">
|
|
<%=rs_interview.getString("c_interview_date")%>
|
|
</td></tr></table>
|
|
|
|
</div>
|
|
</div>
|
|
|
|
<div class="col-lg-12 col-md-12" style="padding:10px" id="span_call3" style="display:none">
|
|
<div class="col-lg-12 col-md-12" >
|
|
<img src="/images/icon/point3.png" height="20px"><b id="a10"> Key Insights</b>
|
|
</div>
|
|
</div>
|
|
<% String sql_key = "select * from tbl_interview_key where c_interview_no = " + rs_interview.getInt("c_no") + " order by c_no asc" ;
|
|
ResultSet rs_key = stmt2.executeQuery(sql_key);
|
|
int key_no = 0;
|
|
int plp = 0;
|
|
while(rs_key.next()){
|
|
plp = plp + 1;
|
|
%>
|
|
<div class="col-lg-12 col-md-12" id="span_call3" style="padding-left:20px">
|
|
<div class="col-lg-12 col-md-12" style="padding:5px;background:#efefef">
|
|
<%=rs_key.getString("c_title")%>
|
|
</div>
|
|
<!--
|
|
<div class="col-lg-12 col-md-12" >
|
|
<b> Interview Description & Recordigs or Other Attatchment</b>
|
|
</div>-->
|
|
<div class="col-lg-12 col-md-12" style="padding:5px">
|
|
<%if(rs_key.getString("c_exp") != null && !rs_key.getString("c_exp").equals("")){%>
|
|
<%=rs_key.getString("c_exp").replaceAll("\r\n","<br>")%>
|
|
<%}%>
|
|
</div>
|
|
<%if(rs_key.getString("c_file") != null && !rs_key.getString("c_file").equals("")){%>
|
|
<div class="col-lg-12 col-md-12" style="padding:5px;">
|
|
<a href="/upload/interview/<%=rs_key.getString("c_file")%>"><%=rs_key.getString("c_file")%></a>
|
|
</div>
|
|
<%}%>
|
|
<div class="col-lg-12 col-md-12" style="padding:5px;padding-bottom:10px" >
|
|
<div class="col-lg-12 col-md-12" >
|
|
<b id="a11">* Selected Hypothesis</b>
|
|
</div>
|
|
<div class="col-lg-12 col-md-12" style="padding-top:5px;padding-bottom:20px">
|
|
<table width=100% cellspacing=2 cellpadding=0>
|
|
<%
|
|
sql_interview2 = " select a.c_point, b.c_channel, b.c_title, b.c_no from tbl_interview_point a ";
|
|
sql_interview2 = sql_interview2 + " inner join tbl_hypo b on b.c_no = a.c_hypo_no and b.c_use = 0 ";
|
|
sql_interview2 = sql_interview2 + " where a.c_interview_no = " + c_no;
|
|
if(plp == 1){
|
|
sql_interview2 = sql_interview2 + " and ( a.c_interview_key_no = "+ rs_key.getString("c_no") +" or a.c_interview_key_no = 0)";
|
|
}else{
|
|
sql_interview2 = sql_interview2 + " and (a.c_interview_key_no = "+ rs_key.getString("c_no") +" )";
|
|
}
|
|
sql_interview2 = sql_interview2 + " order by b.c_no asc ";
|
|
rs_interview2 = stmt2.executeQuery(sql_interview2);
|
|
int yp = 0;
|
|
while(rs_interview2.next()){
|
|
yp = yp + 1;
|
|
if(yp == 1 && c_hypo_no.equals("")){
|
|
c_hypo_no=rs_interview2.getString("c_no");
|
|
}
|
|
%>
|
|
|
|
|
|
<tr>
|
|
|
|
|
|
<td style="padding-top:2px;width:205px;text-align:right">
|
|
<%if(rs_interview2.getInt("c_point") == 2){%>
|
|
<b><font color=blue><img src="/images/icon/good.png" height="20px"></font></b>
|
|
<%}%>
|
|
<%if(rs_interview2.getInt("c_point") == 1){%>
|
|
<b><font color=#121212><img src="/images/icon/soso.png" height="20px"></font></b>
|
|
<%}%>
|
|
<%if(rs_interview2.getInt("c_point") == 0){%>
|
|
<b><font color=Orange><img src="/images/icon/bad.png" height="20px"></font></b>
|
|
<%}%>
|
|
[<%=hy_title[rs_interview2.getInt("c_channel")]%>]
|
|
</td>
|
|
|
|
<td style="padding:2px">
|
|
<img src="/images/icon/exp.png" height="20px"><a href="../hypo/view.jsp?<%=para_t%>&c_team=<%=c_team%>&c_no=<%=rs_interview2.getInt("c_no")%>&c_channel=<%=rs_interview2.getInt("c_channel")%>"><%=rs_interview2.getString("c_title")%></a>
|
|
</td></tr>
|
|
|
|
|
|
<%}
|
|
rs_interview2.close();
|
|
%>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<% }
|
|
rs_key.close();
|
|
%>
|
|
|
|
<div class="col-lg-12 col-md-12" >
|
|
<div class="divider mb-20" ></div>
|
|
<!---------------------comment---------------------------->
|
|
<div class="col-lg-12 col-md-12" >
|
|
<img src="/images/icon/comment.png" height="24px"> <b id="a12">Comment with Instructor, Mentor</b><br><br>
|
|
<%if((session.getAttribute("member_type").equals("0") || session.getAttribute("member_type").equals("1") || session.getAttribute("member_type").equals("2")) && make_ok == 0){%>
|
|
<script>
|
|
function go_comment(){
|
|
if(document.bcb_comment.c_content.value == ""){
|
|
alert("Insert Comment.")
|
|
}else{
|
|
document.bcb_comment.method = "post"
|
|
document.bcb_comment.target = "exec"
|
|
document.bcb_comment.action = "/cms_for_bcb/process/comment/insert_ok.jsp"
|
|
document.bcb_comment.submit()
|
|
}
|
|
}
|
|
</script>
|
|
<form name="bcb_comment">
|
|
<input name="c_team_no" value="<%=c_team%>" type="hidden">
|
|
<input name="c_type" value="1" type="hidden">
|
|
<input name="c_relation" value="<%=rs_interview.getInt("c_no")%>" type="hidden">
|
|
<div class="col-lg-7 col-md-7" >
|
|
<table width="100%" cellpadding=0 cellspacing=0>
|
|
<% String sql_in = "select c_photo from tbl_member where c_no = " + session.getAttribute("member_no");
|
|
ResultSet rs_in = stmt.executeQuery(sql_in);
|
|
if(rs_in.next()){
|
|
%>
|
|
<tr>
|
|
<td style="width:56px">
|
|
<%if(!rs_in.getString("c_photo").equals("")){%>
|
|
<img src="/upload/photo/<%=rs_in.getString("c_photo")%>" width="50" height=50 style="border: 1px solid #ededed;border-radius: 50px; ">
|
|
<%}%>
|
|
|
|
</td>
|
|
<td >
|
|
<textarea name="c_content" style="width:100%;height:100px"></textarea>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td >
|
|
</td>
|
|
<td style="font-size:15px;vertical-align:bottom;text-align:right">
|
|
<a href="#none" onclick="go_comment()" style="width: 60px; line-height: 30px; text-align: center;display: inline-block; background: #5E9ECA; border: 1px solid #ffffff;border-radius: 15px; color: #ffffff;font-weight:400;font-size: 13px;"><span id="a13">Insert</span></a>
|
|
</td>
|
|
</tr>
|
|
<tr><td colspan=2 style="height:30px"></td></tr>
|
|
<%
|
|
}
|
|
rs_in.close();
|
|
%>
|
|
</table>
|
|
</div>
|
|
<div class="col-lg-5 col-md-5">
|
|
|
|
</div>
|
|
</form>
|
|
<%}%>
|
|
<div class="col-lg-12 col-md-12" >
|
|
<table width="100%" cellpadding=0 cellspacing=0>
|
|
<% String sql_comment = " select a.c_content, a.c_date, b.c_photo, b.c_name, a.c_member_type from tbl_comment a ";
|
|
sql_comment = sql_comment + " inner join tbl_member b on b.c_no = a.c_member_no ";
|
|
sql_comment = sql_comment + " where a.c_type= 1 and a.c_relation = " + rs_interview.getInt("c_no") + " order by a.c_no desc ";
|
|
ResultSet rs_comment = stmt.executeQuery(sql_comment);
|
|
while(rs_comment.next()){
|
|
%>
|
|
<tr>
|
|
<td style="width:56px">
|
|
<%if(!rs_comment.getString("c_photo").equals("")){%>
|
|
<img src="/upload/photo/<%=rs_comment.getString("c_photo")%>" width="50" height=50 style="border: 1px solid #ededed;border-radius: 50px; ">
|
|
<%}%>
|
|
|
|
</td>
|
|
<td >
|
|
<img src="/images/icon/comment.png" height="16px">
|
|
<%=rs_comment.getString("c_name")%>[
|
|
<%if(rs_comment.getInt("c_member_type") ==0){%>
|
|
<span id="a20">Team Member</span>
|
|
<%}%>
|
|
<%if(rs_comment.getInt("c_member_type") ==1){%>
|
|
<span id="a21">Instructor</span>
|
|
<%}%>
|
|
<%if(rs_comment.getInt("c_member_type") ==2){%>
|
|
|
|
<span id="a22">Mentor</span>
|
|
<%}%>
|
|
]
|
|
/
|
|
<%=rs_comment.getString("c_date")%>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td >
|
|
</td>
|
|
<td style="font-size:15px;">
|
|
<font color="#676767"><%=rs_comment.getString("c_content").replaceAll("\r\n","<br>")%></font>
|
|
</td>
|
|
</tr>
|
|
<tr><td colspan=2 style="height:30px"></td></tr>
|
|
<%
|
|
}
|
|
rs_comment.close();
|
|
%>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<!---------------------comment-E--------------------------->
|
|
|
|
</div>
|
|
|
|
|
|
</div>
|
|
<div class="text-center">
|
|
<a href="../hypo/view.jsp?<%=para_t%>&c_team=<%=c_team%>&c_no=<%=c_hypo_no%>&c_channel=<%=c_channel%>" style="width: 120px; line-height: 40px; text-align: center;display: inline-block; background: #787878; border: 1px solid #ffffff; border-radius: 20px; color: #ffffff;font-weight:400;font-size: 13px;"><span id="a14">To Hypothesis</span></a>
|
|
<a href="../list.jsp?<%=para_t%>&c_team=<%=c_team%>" style="width: 120px; line-height: 40px; text-align: center;display: inline-block; background: #787878; border: 1px solid #ffffff; border-radius: 20px; color: #ffffff;font-weight:400;font-size: 13px;"><span id="a15">To BMC</span></a>
|
|
</div>
|
|
<br />
|
|
<script>
|
|
<%if(!c_channel.equals("")){%>
|
|
td_go(<%=c_channel%>)
|
|
<%}%>
|
|
</script>
|
|
</form>
|
|
<%
|
|
}
|
|
rs_interview.close();
|
|
}%>
|
|
|
|
|
|
<script>
|
|
// 다국어 처리를 위한 i18n 객체
|
|
var i18n = {
|
|
en: {
|
|
a1: "View a",
|
|
a2: "Customer Interview",
|
|
a3: "Edit",
|
|
a4: "Delete",
|
|
a6: "Whom did you interview?",
|
|
a7: "Interview Type & Date",
|
|
a8: "Engagement Type",
|
|
a9: "Interview Date",
|
|
a10: "Key Insights",
|
|
a11: "* Selected Hypothesis",
|
|
a12: "Comment with Instructor, Mentor",
|
|
a13: "Insert",
|
|
a14: "To Hypothesis",
|
|
a15: "To BMC",
|
|
a16: "In Person",
|
|
a17: "Phone",
|
|
a18: "Email",
|
|
a19: "Video Chat",
|
|
a20: "Team Member",
|
|
a21: "Instructor",
|
|
a22: "Mentor",
|
|
a25: "Deleted"
|
|
},
|
|
es_PE: {
|
|
a1: "Ver un",
|
|
a2: "Entrevista al cliente",
|
|
a3: "Editar",
|
|
a4: "Borrar",
|
|
a6: "¿A quién entrevistaste?",
|
|
a7: "Tipo de entrevista y fecha",
|
|
a8: "Tipo de compromiso",
|
|
a9: "Fecha de la entrevista",
|
|
a10: "Información clave",
|
|
a11: "* Hipótesis seleccionada",
|
|
a12: "Comentario con Instructor, Mentor",
|
|
a13: "Insertar",
|
|
a14: "A la Hipótesis",
|
|
a15: "A BMC",
|
|
a16: "En persona",
|
|
a17: "Teléfono",
|
|
a18: "Correo electrónico",
|
|
a19: "Chat de vídeo",
|
|
a20: "Miembro del equipo",
|
|
a21: "Instructor",
|
|
a22: "Maestro",
|
|
a25: "Eliminado"
|
|
|
|
}
|
|
};
|
|
|
|
// 선택된 언어에 따라 다국어 텍스트 설정
|
|
function setLanguage(lang) {
|
|
var langData = i18n[lang];
|
|
document.getElementById("a1").innerText = langData.a1;
|
|
document.getElementById("a2").innerText = langData.a2;
|
|
document.getElementById("a3").innerText = langData.a3;
|
|
document.getElementById("a4").innerText = langData.a4;
|
|
// document.getElementById("a5").innerText = langData.a5;
|
|
document.getElementById("a6").innerText = langData.a6;
|
|
document.getElementById("a7").innerText = langData.a7;
|
|
document.getElementById("a8").innerText = langData.a8;
|
|
document.getElementById("a9").innerText = langData.a9;
|
|
document.getElementById("a10").innerText = langData.a10;
|
|
document.getElementById("a11").innerText = langData.a11;
|
|
|
|
document.getElementById("a12").innerText = langData.a12;
|
|
document.getElementById("a13").innerText = langData.a13;
|
|
document.getElementById("a14").innerText = langData.a14;
|
|
document.getElementById("a15").innerText = langData.a15;
|
|
|
|
document.getElementById("a16").innerText = langData.a16;
|
|
document.getElementById("a17").innerText = langData.a17;
|
|
document.getElementById("a18").innerText = langData.a18;
|
|
document.getElementById("a19").innerText = langData.a19;
|
|
document.getElementById("a20").innerText = langData.a20;
|
|
document.getElementById("a21").innerText = langData.a21;
|
|
document.getElementById("a22").innerText = langData.a22;
|
|
document.getElementById("a23").innerText = langData.a23;
|
|
document.getElementById("a24").innerText = langData.a24;
|
|
document.getElementById("a25").innerText = langData.a25;
|
|
|
|
document.getElementById("a26").innerText = langData.a26;
|
|
document.getElementById("a27").innerText = langData.a27;
|
|
document.getElementById("a28").innerText = langData.a28;
|
|
document.getElementById("a29").innerText = langData.a29;
|
|
document.getElementById("a30").innerText = langData.a30;
|
|
document.getElementById("a31").innerText = langData.a31;
|
|
|
|
|
|
|
|
}
|
|
</script>
|
|
|
|
<script>
|
|
setLanguage('<%= request.getLocale().toString() %>');
|
|
</script>
|
|
<%@include file="/cms_for_bcb/show_bottom.jsp"%>
|
|
<%@include file="/include/bottom.jsp"%>
|
|
<%@include file="/include/include_b.jsp"%>
|