%@ Language=VBScript %>
<%Option Explicit%>
<%
Dim RS2 : Set RS2 = Server.CreateObject("ADODB.Recordset")
Dim sesid,vID,res,mp,sesid2,sesid3,mac,username, mpasse
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 ShowContentA 'As Boolean 'Should the form be Displayed
ShowContentA = 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 = ""
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
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 & ""
if vMess = "" then
'Response.Write vContent
SendEMail EMAIL_FROM, EMAIL_TO, "", vSubject, vContent
showContentA = false
end if
end if %>
Richard Perreault