<%@ Language=VBScript %> <%Option Explicit%> <% Dim RS2 : Set RS2 = Server.CreateObject("ADODB.Recordset") Dim sesid,vID,res,mp,sesid2,sesid3,mac 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 %> <% function DateForm2(vDat) dim Days, Months, strReturn Days = array("Dimanche", "Lundi", "Mardi", "Mercredi", "Jeudi", "Vendredi", "Samedi") Months = array("Janvier", "Février", "Mars", "Avril", "Mai", "Juin", "Juillet", "Août", "Septembre", "Octobre", "Novembre", "Décembre") strReturn = "" strReturn = strReturn & Day(vDat) & " " strReturn = strReturn & Months(Month(vDat) - 1) & " " strReturn = strReturn & Year(vDat) & " [" strReturn = strReturn & right(FormatNumber(Hour(vDat) / 100, 2), 2) & ":" & right(FormatNumber(Minute(vDat) / 100, 2), 2) & "]" DateForm2 = strReturn end Function mp = 0 res = Request.QueryString("resid") vID = Request.QueryString("id") mp = Request.QueryString("usid") sesid = Request.QueryString("ids") sesid2 = Request.QueryString("ids2") sesid3 = Request.QueryString("ids3") mac = Request.QueryString("mac") 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 dim vCourriel dim vPrenom dim vNom dim vRes dim vUsid vMess = "" if Request.Form("txtPrenom") = "" then vNom = "Sans Prenom" else vNom = Request.Form("txtPrenom") end if if Request.Form("txtNom") = "" and Len(vUsid) =0 then vNom = "Sans Nom" else vNom = Request.Form("txtNom") end if vRes = Request.Form("res") vUsid = Request.Form("ach") if Len(vUsid) =0 then vUsid = "Anonyme" end if vName = Trim(vPrenom & " " & vNom) if sesid2="111" and sesid3="111" then vSubject = "Listing complet (" & res &" / Mandat Acheteur seulement) par #"& vUsid & " (Acheteur sans acces à cette fiche) " elseif sesid2="111" then vSubject = "Listing complet (" & res &" / Mandat Acheteur seulement) par #"& vUsid & " " elseif sesid3="111" then vSubject = "Listing complet (" & res &") par #"& vUsid & " (Acheteur sans acces à cette fiche) " else vSubject = "Listing complet (" & vRes &") par "& vName & "( # "& vUsid &")" end if vContent = "" vData = Now & chr(20) vData = vData & vPrenom & chr(20) vData = vData & vNom & chr(20) vContent = vContent & "" & vbcrlf vContent = vContent & "Coordonnées

" & vbcrlf vContent = vContent & "
" & vbcrlf if Request.Form("txtTelephone") <> "" then vContent = vContent & "Téléphone : " & Request.Form("txtTelephone") & "
" & vbcrlf end if vData = vData & Request.Form("txtTelephone") & chr(20) if Request.Form("txtCellulaire") <> "" then vContent = vContent & "Téléphone céllulaire : " & Request.Form("txtCellulaire") & "
" & vbcrlf end if vData = vData & Request.Form("txtCellulaire") & chr(20) if Request.Form("txtEmail") <> "" and instr(Request.Form("txtEmail"), "@") > 0 then if trim(Request.Form("txtEmail")) = trim(Request.Form("txtEmailCF")) then vContent = vContent & "Courriel : " & 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 vContent = vContent & "
" & vbcrlf if Request.Form("rapportComplet") = "on" then vContent = vContent & "

Listing complet
" end if vData = vData & Request.Form("rapportComplet") & chr(20) if Request.Form("Photos") = "on" then vContent = vContent & "Photos
" end if vData = vData & Request.Form("Photos") & chr(20) if Request.Form("EtudeS") = "on" then vContent = vContent & "Étude du marché SCHL
" end if vData = vData & Request.Form("EtudeS") & chr(20) if Request.Form("EtudeM") = "on" then vContent = vContent & "Étude du marché privé
" end if vData = vData & Request.Form("EtudeM") & chr(20) if Request.Form("EvalA") = "on" then vContent = vContent & "Évaluation agréé
" end if vData = vData & Request.Form("EvalA") & chr(20) if Request.Form("DeclVendeur") = "on" then vContent = vContent & "Declaration du vendeur
" end if vData = vData & Request.Form("DeclVendeur") & chr(20) if Request.Form("InspectB") = "on" then vContent = vContent & "Inspection bâtiment
" end if vData = vData & Request.Form("InspectB") & chr(20) if Request.Form("EtudeEnv") = "on" then vContent = vContent & "Étude environnementale
" end if vData = vData & Request.Form("EtudeEnv") & chr(20) if Request.Form("PlanEvac") = "on" then vContent = vContent & "Plan d'évacuation
" end if vData = vData & Request.Form("PlanEvac") & chr(20) if Request.Form("CerLoc") = "on" then vContent = vContent & "Certificat localisation
" end if vData = vData & Request.Form("CerLoc") & chr(20) if Request.Form("AssPret") = "on" then vContent = vContent & "Acte d'assurance hypothécaire SCHL
" end if vData = vData & Request.Form("AssPret") & chr(20) if Request.Form("PretHyp") = "on" then vContent = vContent & "Acte de prêt hypothécaire
" end if vData = vData & Request.Form("PretHyp") & chr(20) if Request.Form("Taxes") = "on" then vContent = vContent & "Taxes municipales et scolaires
" end if vData = vData & Request.Form("Taxes") & chr(20) if Request.Form("Energ") = "on" then vContent = vContent & "Énergie
" end if vData = vData & Request.Form("Energ") & chr(20) if Request.Form("AssBat") = "on" then vContent = vContent & "Assurance bâtiment
" end if vData = vData & Request.Form("AssBat") & chr(20) if Request.Form("PermisV") = "on" then vContent = vContent & "Permis ville
" end if vData = vData & Request.Form("PermisV") & chr(20) if Request.Form("PermisM ") = "on" then vContent = vContent & "Permis M.A.P.A.Q.
" end if vData = vData & Request.Form("PermisM ") & chr(20) if Request.Form("EtatsFin ") = "on" then vContent = vContent & "États financiers
" end if vData = vData & Request.Form("EtatsFin ") & chr(20) if Request.Form("txtComments") <> "" then vContent = vContent & "
Commentaires :


" & vbcrlf vContent = vContent & Request.Form("txtComments") end if vData = vData & Request.Form("txtComments") & chr(20) vContent = vContent & "
" & chr(19) & chr(19) & "
" & vbcrlf vContent = vContent & "" if vMess = "" then 'Response.Write vContent SendEMail EMAIL_FROM, EMAIL_TO, "", vSubject, vContent showContent = false end if end if %> Richard Perreault
<% Dim noBrp strSQL = " SELECT Last_brp FROM tblBrp" RS2.Open strSQL, CNRS noBrp = RS2.Fields(0) RS2.Close noBrp = noBrp & "Web.html"%>

Acheteur / Vendeur

  • <%if Request.QueryString("p") = "mandats" then Response.Write "

    Liste des mandats

    " else Response.Write "Liste des mandats" end if %>
  • <% if Session("Perm") = 1 then %>
  • " target="_blank"> Comparez mandats
  • <%else %>
  • Comparez mandats
  • <% end if%>
  • <% if Request.QueryString("p") = "motdepasse" then Response.Write "

    Achat / mot de passe

    " else Response.Write "Achat / mot de passe" end if %>
  • <% if Request.QueryString("p") = "faq" then Response.Write "

    F.A.Q.- mandat acheteur

    " else Response.Write "F.A.Q.- mandat acheteur" end if %>
  • <% if Request.QueryString("p") = "vente" then Response.Write "

    Vente de résidence

    " else Response.Write "Vente de résidence" end if %>
  • <% if Request.QueryString("p") = "loyers" then Response.Write "

    Types d'hebergement

    " else Response.Write "Types d'hebergement" end if %>

Chercher Mandat

Calculez

<%if session("user") <> "" then%>

Identification

Vous êtes connecté
en tant que : <%=Session("user")%>

<%=vMess%>

<%else%>

Identification

Utilisateur : " size="20" />

Mot de passe :

<%=vMess%>

< S'INSCRIRE >

<%if vMess = "" then%> <%end if%> <%end if%>
<%if ShowContent then %>

Les documents sont disponibles sur demande par l'envoi du formulaire.

(* champs obligatoires)

<% ShowFieldsRapport %>
Cocher s'il vous plaît les documents désirés :
<% Dim EtudeS, EtudeM,EvalA,EtudeEnv, InspectB, CerLoc, AssBat, PermisV, PermisM, PlanEvac,Energ, Taxes,Photos, DeclVendeur,PretHyp,AssPret,EtatsFin RS.Open " SELECT * FROM tblListingDoc " & _ " WHERE Id_Listing = " & vID,CNRS if(RS.EOF And RS.BOF) then elseif not isnull(RS.Fields("ConfPhotos")) then Photos = RS.Fields("ConfPhotos") EtudeM = RS.Fields("ConfEtudeM") EtudeEnv = RS.Fields("ConfEtudeEnv") EtudeS = RS.Fields("ConfEtudeS") EvalA = RS.Fields("ConfEvalA") InspectB = RS.Fields("ConfInspectB") CerLoc = RS.Fields("ConfCerLoc") AssBat = RS.Fields("ConfAssBat") PermisV = RS.Fields("ConfPermisV") PermisM = RS.Fields("ConfPermisM") PlanEvac = RS.Fields("ConfPlanEvac") Energ = RS.Fields("ConfEnerg") Taxes = RS.Fields("ConfTaxes") DeclVendeur = RS.Fields("DeclVendeur") PretHyp = RS.Fields("PretHyp") AssPret = RS.Fields("AssPret") EtatsFin = RS.Fields("EtatsFin") end if RS.Close%> <% if sesid<>"" and sesid <>"111" then %> <% 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 = " & sesid RS.Open strSQL, CNRS sesid = sesid & RS.Fields(0) RS.Close() %> <%end if %> <% if Photos <> 0 then%> <% end if %> <% if EtudeS <> 0 then%> <% end if %> <% if EtudeM<> 0 then%> <% end if %> <% if EvalA <> 0 then%> <% end if %> <% if DeclVendeur <> 0 then%> <% end if %> <% if InspectB <> 0 then%> <% end if %> <% if EtudeEnv <> 0 then%> <% end if %> <% if PlanEvac <> 0 then%> <% end if %> <% if CerLoc <> 0 then%> <% end if %> <% if AssPret <> 0 then%> <% end if %> <% if PretHyp <> 0 then%> <% end if %> <% if Taxes <> 0 then%> <% end if %> <% if Energ <> 0 then%> <% end if %> <% if AssBat <> 0 then%> <% end if %> <% if PermisV <> 0 then%> <% end if %> <% if PermisM <> 0 then%> <% end if %> <% if EtatsFin <> 0 then%> <% end if %>
 
<% if sesid="111" then %> <%elseif Len(mac) > 0 then %> <%else %> <%end if %>
<% if mp <>0 then %> Fiche complète <%end if %>
Commentaires et autres informations.
<%else %>

Vous recevrez une réponse par courriel d'ici 24 heures.

Merci.

<%end if %> <% EndConnect %>