<%@LANGUAGE="VBSCRIPT"%> <% ' *** Restrict Access To Page: Grant or deny access to this page MM_authorizedUsers="ADMIN,VENDEDOR,GERENTE,RESP_ZONA" MM_authFailedURL="login.asp" MM_grantAccess=false If Session("MM_Username") <> "" Then If (false Or CStr(Session("MM_UserAuthorization"))="") Or _ (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then MM_grantAccess = true End If End If If Not MM_grantAccess Then MM_qsChar = "?" If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&" MM_referrer = Request.ServerVariables("URL") if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString() MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer) Response.Redirect(MM_authFailedURL) End If %> <% ' *** Edit Operations: declare variables Dim MM_editAction Dim MM_abortEdit Dim MM_editQuery Dim MM_editCmd Dim MM_editConnection Dim MM_editTable Dim MM_editRedirectUrl Dim MM_editColumn Dim MM_recordId Dim MM_fieldsStr Dim MM_columnsStr Dim MM_fields Dim MM_columns Dim MM_typeArray Dim MM_formVal Dim MM_delim Dim MM_altVal Dim MM_emptyVal Dim MM_i MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString) End If ' boolean to abort record edit MM_abortEdit = false ' query string to execute MM_editQuery = "" %> <% ' *** Insert Record: set variables If (CStr(Request("MM_insert")) = "form2") Then MM_editConnection = MM_maq_STRING MM_editTable = "TBL_OPPORTUNITY_HIST" MM_editRedirectUrl = "" MM_fieldsStr = "WHO|value|COMENTARIO|value|FECHA|value|HORA|value|IDVOBO|value|ETAPA|value|IDOPPORTUNITY|value" MM_columnsStr = "WHO|',none,''|COMENTARIO|',none,''|FECHA|',none,NULL|HORA|',none,''|IDVOBO|none,none,NULL|ETAPA|none,none,NULL|IDOPPORTUNITY|none,none,NULL" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If End If %> <% ' *** Update Record: set variables If (CStr(Request("MM_update")) = "sf" And CStr(Request("MM_recordId")) <> "") Then MM_editConnection = MM_maq_STRING MM_editTable = "promad2007.TBL_OPPORTUNITY" MM_editColumn = "IDOP" MM_recordId = "" + Request.Form("MM_recordId") + "" MM_editRedirectUrl = "" MM_fieldsStr = "FECHA_CIERRE|value|TIPO_PROYECTO|value|TIPO|value|IDPROSPECTO|value|TEQUIPO|value|GRP|value|PLAZO|value|ORIGENOP|value|ORIGENOPTX|value|MAQUINAS|value|COMMENT|value|DIVISION|value|MODELO|value|IDMAQUINA|value|SUCURSAL|value|ESTADO|value|E1A|value|E1B|value|E1C|value|E1D|value|E1E|value|E2A|value|E2B|value|NIV_INTERES|value|E2C|value|E2D|value|E3A|value|E3B|value|E3C|value|E3D|value|E3E|value|E3F|value|E4A|value|E4B|value|E4C|value|E4D|value|E4E|value|E5A|value|E5B|value|LICITACION|value|E5C|value|E5D|value|E5E|value|E5F|value|E5G|value|CIERRE|value|EXITED|value" MM_columnsStr = "FECHA_CIERRE|',none,NULL|TIPO_PROYECTO|',none,''|TIPO|none,none,NULL|IDPROSPECTO|none,none,NULL|TEQUIPO|none,none,NULL|GRP|',none,''|PLAZO|none,none,NULL|ORIGENOP|none,none,NULL|ORIGENOPTX|',none,''|MAQUINAS|',none,''|COMMENT|',none,''|DIVISION|',none,''|MODELO|',none,''|IDMAQUINA|none,none,NULL|SUCURSAL|',none,''|ESTADO|none,none,NULL|E1A|none,1,0|E1B|none,1,0|E1C|none,1,0|E1D|none,1,0|E1E|none,1,0|E2A|none,1,0|E2B|none,1,0|NIV_INTERES|none,none,NULL|E2C|none,1,0|E2D|none,1,0|E3A|none,1,0|E3B|none,1,0|E3C|none,1,0|E3D|none,1,0|E3E|none,1,0|E3F|none,1,0|E4A|none,1,0|E4B|none,1,0|E4C|none,1,0|E4D|none,1,0|E4E|none,1,0|E5A|none,1,0|E5B|none,1,0|LICITACION|none,none,NULL|E5C|none,1,0|E5D|none,1,0|E5E|none,1,0|E5E|none,1,0|E5G|none,1,0|CIERRE|none,none,NULL|EXITED|none,1,0" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If End If %> <% ' *** Insert Record: construct a sql insert statement and execute it Dim MM_tableValues Dim MM_dbValues If (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_formVal = MM_fields(MM_i+1) MM_typeArray = Split(MM_columns(MM_i+1),",") MM_delim = MM_typeArray(0) If (MM_delim = "none") Then MM_delim = "" MM_altVal = MM_typeArray(1) If (MM_altVal = "none") Then MM_altVal = "" MM_emptyVal = MM_typeArray(2) If (MM_emptyVal = "none") Then MM_emptyVal = "" If (MM_formVal = "") Then MM_formVal = MM_emptyVal Else If (MM_altVal <> "") Then MM_formVal = MM_altVal ElseIf (MM_delim = "'") Then ' escape quotes MM_formVal = "'" & strreplace(MM_formVal,"'","''") & "'" Else MM_formVal = MM_delim + MM_formVal + MM_delim End If End If If (MM_i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End If MM_tableValues = MM_tableValues & MM_columns(MM_i) MM_dbValues = MM_dbValues & MM_formVal Next MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")" If (Not MM_abortEdit) Then ' execute the insert Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End If End If %> <% ' *** Update Record: construct a sql update statement and execute it If (CStr(Request("MM_update")) <> "" And CStr(Request("MM_recordId")) <> "") Then ' create the sql update statement MM_editQuery = "update " & MM_editTable & " set " For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_formVal = MM_fields(MM_i+1) MM_typeArray = Split(MM_columns(MM_i+1),",") MM_delim = MM_typeArray(0) If (MM_delim = "none") Then MM_delim = "" MM_altVal = MM_typeArray(1) If (MM_altVal = "none") Then MM_altVal = "" MM_emptyVal = MM_typeArray(2) If (MM_emptyVal = "none") Then MM_emptyVal = "" If (MM_formVal = "") Then MM_formVal = MM_emptyVal Else If (MM_altVal <> "") Then MM_formVal = MM_altVal ElseIf (MM_delim = "'") Then ' escape quotes MM_formVal = "'" & strreplace(MM_formVal,"'","''") & "'" Else MM_formVal = MM_delim + MM_formVal + MM_delim End If End If If (MM_i <> LBound(MM_fields)) Then MM_editQuery = MM_editQuery & "," End If MM_editQuery = MM_editQuery & MM_columns(MM_i) & " = " & MM_formVal Next MM_editQuery = MM_editQuery & " where " & MM_editColumn & " = " & MM_recordId If (Not MM_abortEdit) Then ' execute the update Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End If End If %> <% Dim opps__MMColParam opps__MMColParam = "1" If (Request.QueryString("IDOP") <> "") Then opps__MMColParam = Request.QueryString("IDOP") End If %> <% Dim opps Dim opps_numRows Set opps = Server.CreateObject("ADODB.Recordset") opps.ActiveConnection = MM_maq_STRING opps.Source = "SELECT * FROM TBL_OPPORTUNITY WHERE IDOP = " + strreplace(opps__MMColParam, "'", "''") + "" opps.CursorType = 0 opps.CursorLocation = 2 opps.LockType = 1 opps.Open() opps_numRows = 0 %> <% Dim vds__MMColParam vds__MMColParam = "1" If (Request("MM_EmptyValue") <> "") Then vds__MMColParam = Request("MM_EmptyValue") End If %> <% Dim vds Dim vds_numRows Set vds = Server.CreateObject("ADODB.Recordset") vds.ActiveConnection = MM_maq_STRING vds.Source = "SELECT NOMBRE, IDCLIENTE, ZONA FROM USUARIOSCRM WHERE CARTCONTRA <> " + strreplace(vds__MMColParam, "'", "''") + " ORDER BY ZONA ASC" vds.CursorType = 0 vds.CursorLocation = 2 vds.LockType = 1 vds.Open() vds_numRows = 0 %> <% Dim ophist__idopt ophist__idopt = "0" If (request("IDOP") <> "") Then ophist__idopt = request("IDOP") End If %> <% Dim ophist Dim ophist_numRows Set ophist = Server.CreateObject("ADODB.Recordset") ophist.ActiveConnection = MM_maq_STRING ophist.Source = "SELECT * FROM TBL_OPPORTUNITY_HIST WHERE IDOPPORTUNITY=" + strreplace(ophist__idopt, "'", "''") + "" ophist.CursorType = 0 ophist.CursorLocation = 2 ophist.LockType = 1 ophist.Open() ophist_numRows = 0 %> <% Dim prosp__idv prosp__idv = "0" If (session("IDCLIENTE") <> "") Then prosp__idv = session("IDCLIENTE") End If %> <% Dim prosp Dim prosp_numRows Set prosp = Server.CreateObject("ADODB.Recordset") prosp.ActiveConnection = MM_maq_STRING prosp.Source = "SELECT NOMBRE, COMPANIA, IDDBSCTE, IDCLIENTE FROM PROSPECTOS WHERE VENDEDOR=" + strreplace(prosp__idv, "'", "''") + " ORDER BY COMPANIA,NOMBRE" prosp.CursorType = 0 prosp.CursorLocation = 2 prosp.LockType = 1 prosp.Open() prosp_numRows = 0 %> <% Dim divs Dim divs_numRows Set divs = Server.CreateObject("ADODB.Recordset") divs.ActiveConnection = MM_maq_STRING divs.Source = "SELECT SHORT, DESCRIPCION FROM DIVISIONES" divs.CursorType = 0 divs.CursorLocation = 2 divs.LockType = 1 divs.Open() divs_numRows = 0 %> <% Dim grps Dim grps_numRows Set grps = Server.CreateObject("ADODB.Recordset") grps.ActiveConnection = MM_maq_STRING grps.Source = "SELECT distinct(SHORT2),DIV2 FROM DIVISIONES WHERE SHORT2<>'-1' ORDER BY DIV2" grps.CursorType = 0 grps.CursorLocation = 2 grps.LockType = 1 grps.Open() grps_numRows = 0 %> <% Dim origs Dim origs_numRows Set origs = Server.CreateObject("ADODB.Recordset") origs.ActiveConnection = MM_maq_STRING origs.Source = "SELECT * FROM TBL_ORIGENOPP " origs.CursorType = 0 origs.CursorLocation = 2 origs.LockType = 1 origs.Open() origs_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 ophist_numRows = ophist_numRows + Repeat1__numRows %> www.promad.com.mx
 
Oportunidades Obtenidas de Clientes
ID:<%=(opps.Fields.Item("IDOP").Value)%>  Fecha <%= DoDateTime((opps.Fields.Item("FECHA").Value), 1, 1034) %>
Fecha Estimada de Cierre <%fci="" femy=(opps.Fields.Item("FECHA_CIERRE").Value) if femy<>"" then fci=cstr(datepart("yyyy",femy))+"/" +cstr(datepart("m",femy))+"/" +cstr(datepart("d",femy)) %> <%'=femy %> Seleccione Aqui la Fecha
PALABRA CLAVE: ">
Prospecto
 
División de la Oportunidad
Plazo(mas de 6 meses=largo plazo):
type="radio" value="0" name="PLAZO" > Largo Plazo type="radio" value="1" name="PLAZO" > Corto Plazo
Origen de la Oportunidad " size="20" maxlength="20">
Productos Involucrados:



Comentarios
Producto Principal de la Oportunidad
División
Seleccione un Producto
Producto " size="50"> ">

Archivos Adjuntos
">
Etapa:.gif" alt="Etapa<%=(opps.Fields.Item("ETAPA").Value)%>" width="38" height="37">  

">
ETAPA I -
PROSPECTO ACEPTADO


name="E1A" type="checkbox" id="E1A" value="1"> 1)Obtuvo una calificación mayor a 10 en el examen de Calificación y Validación
name="E1B" type="checkbox" id="E1B" value="1"> 2)Hay facilidad de Traslado (vuelo directo, vuelo por aerolíneas económicas, hospedaje, etc).
name="E1C" type="checkbox" id="E1C" value="1"> 3)Ya se tiene la Cita con el tomador de decisiones confirmada.
name="E1D" type="checkbox" id="E1D" value="1"> 4)Ya tiene preparado el Kit de Ventas personalizado para el cliente que incluye:
* Presentación
* Material a dejar
* Cotización del Diagnóstico (si aplica).

name="E1E" type="checkbox" id="E1E" value="1"> Se llevó a cabo una reunión de validación final y sugerencias donde la visita fue autorizada.
">
ETAPA II - PRESENTACION
name="E2A" type="checkbox" id="E2A" value="1"> 1)Ya se llevó a cabo la presentación al tomador de decisiones.
name="E2B" type="checkbox" id="E2B" value="1"> 2)Demostró Interés (del 1 al 5)
name="E2C" type="checkbox" id="E2C" value="1"> 3)¿Se encontraron durante la presentación datos y/o información importante que nos ayudará a personalizar y adecuar la Propuesta Comercial que se le presentará al cliente?
name="E2D" type="checkbox" id="E2D" value="1"> 4)Se concretó una cita o compromiso para entregar la Propuesta Comercial



c.=Comprador

">
ETAPA III - PROPUESTA COMERCIAL
name="E3A" type="checkbox" id="E3A" value="1"> 1)Ya está lista una propuesta Comercial adecuada para el cliente
name="E3B" type="checkbox" id="E3B" value="1"> 2)Se tiene la aprobación del Depto. De Implementación para la Propuesta Comercial.
name="E3C" type="checkbox" id="E3A4" value="1"> 3)Se tiene la aprobación del Depto. De Técnico para la Propuesta Comercial.
name="E3D" type="checkbox" id="E3D" value="1"> 4)Se tiene la aprobación del Depto. De Financiero para la Propuesta Comercial.
name="E3E" type="checkbox" id="E3A6" value="1"> 5)Se llevó a cabo una sesión de Comentarios y Sugerencias
name="E3F" type="checkbox" id="E3A7" value="1"> 6)Ya se envió o se llevó a cabo una presentación en persona de la Propuesta Comercial.

">
ETAPA IV - SEGUIMIENTO Y NEGOCIACIÓN
name="E4A" type="checkbox" id="E4A" value="1"> 1)Se ha confirmado de recepción de la Propuesta Comercial
name="E4B" type="checkbox" id="E4B2" value="1"> 2)Seguimiento a la Propuesta Comercial
name="E4C" type="checkbox" id="E4C" value="1"> 3)Ha existido Retroalimentación
name="E4D" type="checkbox" id="E4D" value="1"> 4)Se ha aceptado de la Propuesta
name="E4E" type="checkbox" id="E4E2" value="1"> 5 ) Se llevó a cabo la negociación de las condiciones de ventas (fecha de primer anticipo, duración del proyecto, fecha final de pago, financiamiento, etc.)
">
ETAPA V - CONTRATO Y FACTURACIÓN

name="E5A" type="checkbox" id="E4E" value="1"> 1)Se proporcionaron herramientas para dar pie a la asignación directa, sustento legal
name="E5B" type="checkbox" id="E5A" value="1"> 2)¿Se decidió Proceso de Compra (Licitación o Asignación Directa)?

name="E5C" type="checkbox" id="E5C" value="1"> 3)Se apoyó en el proceso de Asignación Directa / Se armó y ejecutó la Licitación.
name="E5D" type="checkbox" id="E5A3" value="1"> 4)Se envió de Machote de Contrato
name="E5E" type="checkbox" id="E5A4" value="1"> 5)Se hizo la afinación de detalles al Contrato (en base a comentarios del cliente)
Se firmó el Contrato
name="E5F" type="checkbox" id="E5A5" value="1"> 6)Se ha entregado la Factura
name="E5G" type="checkbox" id="E5A6" value="1"> 7)Se le ha dado seguimiento a la Factura

CIERRE (Por favor indique que tipo de cierre fue )


1)Se tiene el Contra Recibo
2)Cobro de Factura
<% IF opps("ETAPA")>=5 THEN %>
type="radio" name="CIERRE" value="1"> Cerrada-sin negocio: la oportunidad se cerró por otro motivo.
type="radio" name="CIERRE" value="2"> Cerrada-Ganada: Maqsa ganó la venta.
type="radio" name="CIERRE" value="3"> Cerrada-perdida: La competencia ganó. <% END IF 'opps("ETAPA")>=5 %>


         
<% IF opps("ETAPA")<5 THEN %> name="EXITED" type="checkbox" id="EXITED3" value="1"> SACAR DEL EMBUDO
type="radio" name="CIERRE" value="3"> Cerrada-perdida: La competencia ganó. <% END IF 'opps("ETAPA")<5 %> <%=opps.Fields.Item("CIERRE").Value %>
">
Agregar Avance:
 
" size="32"> " size="32"> " size="32"> " size="32">

 

  <% While ((Repeat1__numRows <> 0) AND (NOT ophist.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 ophist.MoveNext() Wend %>
FECHA HORA USUARIO COMENTARIO ETAPA
<%=(ophist.Fields.Item("FECHA").Value)%> <%=(ophist.Fields.Item("HORA").Value)%> <%=(ophist.Fields.Item("WHO").Value)%> <%=(ophist.Fields.Item("COMENTARIO").Value)%> .gif" alt="Etapa<%=(ophist.Fields.Item("ETAPA").Value)%>" width="38" height="37">



 
<%'=MM_editQuery %>
<% opps.Close() Set opps = Nothing %> <% vds.Close() Set vds = Nothing %> <% ophist.Close() Set ophist = Nothing %> <% prosp.Close() Set prosp = Nothing %> <% divs.Close() Set divs = Nothing %> <% grps.Close() Set grps = Nothing %> <% origs.Close() Set origs = Nothing %>