|
<%if ShowContent then %>
<%else %>
Vous recevrez une réponse par courriel d'ici 24 heures contenant votre mot de passe pour consulter les fiches de mandats. Merci. |
%@ Language=VBScript %> <%Option Explicit%> <% Dim RS2 : Set RS2 = Server.CreateObject("ADODB.Recordset") Dim sesid ConnectRS select case Request.Form("action") case "login": if Request.Form("username") <> "" then 'Prise de l'information de l'acheteur selon son nom d'utilisateur (..., (SELECT COUNT(ID_Transaction) FROM tblTransaction WHERE ID_ach = a.ID_ach) AS [transac]...) strSQL = "SELECT a.ID_Ach, 0 AS [ID_Assistant], webActif, webPassword, webDateFin, (SELECT COUNT(ID_CCach) FROM tblCCAch WHERE ID_ach = a.ID_ach) AS [CCACH] FROM tblSUBAcheteur AS a WHERE webUsername = '" & replace(lcase(Request.Form("username")), "'", "''") & "'" & _ " UNION SELECT ID_Ach, ID_Assistant, webActif, webPassword, webDateFin, 0 FROM tblAssistant WHERE webUsername = '" & replace(lcase(Request.Form("username")), "'", "''") & "'" 'Response.Write "" RS.Open strSQL, CNRS 'ouverture de la requête if RS.EOF then 'vérification qu'un nom a été trouvé vMess = "Nom d'utilisateur inconnu" else if RS.Fields("webPassword") <> Request.form("password") then 'vérification du mot de passe vMess = "Mot de passe incorrect" else Session("user") = UCase(Request.Form("username")) 'l'utilisateur est identifié Session("Userid") = RS.Fields("ID_Ach") Session("Assistid") = RS.Fields("ID_Assistant") Session("CCACH") = RS.Fields("CCACH") 'Session("Transac") = RS.Fields("transac") if Session("CCACH") > 0 then dim RScc: Set RScc = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT MAX(Date_CCAch) FROM tblCCach WHERE ID_ach = " & Session("Userid") & " AND ID_EtapeCCach = 1" RScc.Open strSQL, CNRS Response.Write "" if RScc.EOF then Session("CCACH") = 0 else if DateDiff("m", RScc.Fields(0), Date) > 12 then Session("CCACH") = 0 end if end if end if if not RS.Fields("webActif") then 'vérification de l'état de son accès vMess = "Vous êtes identifié mais votre accès a été révoqué" else if datediff("d", RS.Fields("webDateFin"), date) > 0 then 'vérification de la fin de son accès vMess = "Vous êtes identifié mais votre accès a prit fin le " & RS.Fields("webDateFin") else Session("perm") = 1 strSQL = " SELECT d.Nom_dos" & _ " FROM tblDossier AS d INNER JOIN tblSUBAcheteur AS a ON d.ID_dos = a.ID_dos" & _ " WHERE a.ID_Ach = " & Session("Userid") RS2.Open strSQL, CNRS sesid = RS2.Fields(0) RS2.Close() if Session("Userid") <> 1 then SendEMail EMAIL_FROM, EMAIL_TO, "","L'ach. #"& Session("Userid") & " : " & sesid & " vient de se connecter sur le site immobilier !!! ", " " end if end if end if end if end if RS.Close end if case "logout": Session.Abandon Response.Redirect "index.asp" end select %> <% Dim ShowContent 'As Boolean 'Should the form be Displayed ShowContent = True 'The form should be displayed if Request.Form <> "" then 'If there is data in the request.form dim vSubject dim vContent dim vData dim vName dim vLocs dim vLocsID dim vTab vMess = "" vName = Trim(Request.Form("txtPrenom") & " " & Request.Form("txtNom")) vSubject = "-- Achat -- " & vName & " " & FormatDate(Now, "dd-mmm-yyyy") vContent = "" vData = Now & chr(20) vContent = vContent & "
| " & vbcrlf
if Request.Form("txtTelephone") <> "" then
vContent = vContent & "Domicile : " & Request.Form("txtTelephone") & " " & vbcrlf end if vData = vData & Request.Form("txtTelephone") & chr(20) if Request.Form("txtTravail") <> "" then vContent = vContent & "Travail : " & Request.Form("txtTravail") & " " & vbcrlf end if vData = vData & Request.Form("txtTravail") & chr(20) if Request.Form("txtCellulaire") <> "" then vContent = vContent & "Cél. : " & Request.Form("txtCellulaire") & " " & vbcrlf end if vData = vData & Request.Form("txtCellulaire") & chr(20) if Request.Form("txtEmail") <> "" then if trim(Request.Form("txtEmail")) = trim(Request.Form("txtEmailCF")) then vContent = vContent & "" & Request.Form("txtEmail") & " " & vbcrlf vData = vData & Request.Form("txtEmail") & chr(20) else vMess = vMess & "txtEmailCF;" end if else vMess = vMess & "txtEmail;" end if vContent = vContent & " " & vbcrlf vContent = vContent & " | " & vbcrlf
if Request.Form("txtAdresse") <> "" then
vContent = vContent & vName & " " & vbcrlf vContent = vContent & Request.Form("txtAdresse") & " " & vbcrlf if Request.Form("txtVille") <> "" then vContent = vContent & Request.Form("txtVille") if Request.Form("txtProvince") = "" then vContent = vContent & " " & vbcrlf end if else vMess = vMess & "txtVille;" end if if Request.Form("txtProvince") <> "" then if Request.Form("txtVille") <> "" then vContent = vContent & ", " else vMess = vMess & "txtVille;" end if vContent = vContent & Request.Form("txtProvince") & " " & vbcrlf else vMess = vMess & "txtProvince;" end if if Request.Form("txtCodepostal") <> "" then vContent = vContent & Request.Form("txtCodepostal") & " " & vbcrlf else vMess = vMess & "txtCodepostal;" end if end if vContent = vContent & " |
" & vbcrlf vContent = vContent & "Coordonnées :" & vbcrlf vData = vData & Request.Form("txtPermis") & chr(20) end if vContent = vContent & "" if vMess = "" then 'Response.Write vContent SendEMail EMAIL_FROM, EMAIL_TO, "", vSubject, vContent showContent = false end if end if %>
" & vbcrlf vContent = vContent & "" & vbcrlf vContent = vContent & "Numéro de permis: " & Request.Form("txtPermis") vContent = vContent & "
" & vbcrlf if Request.Form("ctxtTelephone") <> "" then vContent = vContent & "Téléphone à la maison : " & Request.Form("ctxtTelephone") & "
" & vbcrlf end if vData = vData & Request.Form("ctxtTelephone") & chr(20) if Request.Form("ctxtTravail") <> "" then vContent = vContent & "Téléphone au travail : " & Request.Form("ctxtTravail") & "
" & vbcrlf end if vData = vData & Request.Form("ctxtTravail") & chr(20) if Request.Form("ctxtCellulaire") <> "" then vContent = vContent & "Téléphone céllulaire : " & Request.Form("ctxtCellulaire") & "
" & vbcrlf end if vData = vData & Request.Form("ctxtCellulaire") & chr(20) if Request.Form("ctxtEmail") <> "" then vContent = vContent & "Courriel : " & Request.Form("ctxtEmail") & "
" & vbcrlf end if vData = vData & Request.Form("ctxtEmail") & chr(20) vContent = vContent & "
" & vbcrlf vContent = vContent & "" & vbcrlf if Request.Form("ctxtAdresse") <> "" then vContent = vContent & vName & "
" & vbcrlf vContent = vContent & Request.Form("ctxtAdresse") & "
" & vbcrlf if Request.Form("ctxtVille") <> "" then vContent = vContent & Request.Form("ctxtVille") if Request.Form("ctxtProvince") = "" then vContent = vContent & "
" end if end if if Request.Form("ctxtProvince") <> "" then if Request.Form("ctxtVille") <> "" then vContent = vContent & ", " end if vContent = vContent & Request.Form("ctxtProvince") & "
" & vbcrlf end if vContent = vContent & Request.Form("ctxtCodepostal") & "
" & vbcrlf end if vData = vData & Request.Form("ctxtAdresse") & chr(20) vData = vData & Request.Form("ctxtVille") & chr(20) vData = vData & Request.Form("ctxtProvince") & chr(20) vData = vData & Request.Form("ctxtCodepostal") & chr(20) vContent = vContent & "
Richard PerreaultLa première étape vers un investissement performant | |||
|
|||