Last modified by SuperUwe Trueggelmann on 2025-04-18
<
From version < 1.22 >
edited by SuperUwe Trueggelmann
on 2022-10-13
To version < 1.27 >
edited by SuperUwe Trueggelmann
on 2022-10-13
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -38,7 +38,11 @@
38 38   if ((strEditCommand == "Correct") || (strEditCommand == "Register") || (strEditCommand == "Proceed")){
39 39  
40 40   strCompanyName = services.cleanStr.alphanum(request.companyname)
41 -// println "Received Company name: " + strCompanyName
41 + strCompanyAddress = services.cleanStr.alphanum(request.companyaddress)
42 + strCompanyCity = services.cleanStr.alphanum(request.companycity)
43 + strCompanyPostcode = services.cleanStr.alphanum(request.companypostcode)
44 + strCompanyProvince = services.cleanStr.alphanum(request.companyprovince)
45 + strCompanyCountry = services.cleanStr.alphanum(request.companycountry)
42 42   strTitle = services.cleanStr.alphanum(request.title)
43 43   strFirstname = services.cleanStr.alphanum(request.firstname)
44 44   strLastname = services.cleanStr.alphanum(request.lastname)
... ... @@ -47,7 +47,6 @@
47 47   strLphone = services.cleanStr.numphone(request.lphone)
48 48   strMphone = services.cleanStr.numphone(request.mphone)
49 49   strEmail = services.cleanStr.alphanum(request.email)
50 -// println "Received E-mail: " + strEmail
51 51   strEmail2 = services.cleanStr.alphanum(request.email2)
52 52   strCreateTime = java.time.ZonedDateTime.now()
53 53   strCreateIP = request.remoteAddr
... ... @@ -59,6 +59,11 @@
59 59   sqlQueryInsertRec = "INSERT INTO " + strDBTable +
60 60   """(
61 61   companyname,
65 + companyaddress,
66 + companycity,
67 + companypostcode,
68 + companyprovince,
69 + companycountry,
62 62   title,
63 63   firstname,
64 64   lastname,
... ... @@ -74,6 +74,11 @@
74 74   confemailsentcode)
75 75   VALUES(
76 76   '$strCompanyName',
85 + '$strCompanyAddress',
86 + '$strCompanyCity',
87 + '$strCompanyPostcode',
88 + '$strCompanyProvince',
89 + '$strCompanyCountry',
77 77   '$strTitle',
78 78   '$strFirstname',
79 79   '$strLastname',
... ... @@ -95,6 +95,11 @@
95 95   """
96 96   SET
97 97   companyname = '$strCompanyName',
111 + companyaddress = '$strCompanyAddress',
112 + companycity = '$strCompanyCity',
113 + companypostcode = '$strCompanyPostcode',
114 + companyprovince = '$strCompanyProvince',
115 + companycountry = '$strCompanyCountry',
98 98   title = '$strTitle',
99 99   firstname = '$strFirstname',
100 100   lastname = '$strLastname',
... ... @@ -117,7 +117,12 @@
117 117   strEmailBody = "Dear " + strPrefname + ","
118 118   strEmailBody = strEmailBody + "\r\n" + "\r\n" + "A request was made to register you to the CEC website (https://cecocert.com) with the following information:" + "\r\n" + "\r\n"
119 119   strEmailBody = strEmailBody + "Name: " + strTitle + " " + strFirstname + " " + strLastname + "\r\n"
120 - strEmailBody = strEmailBody + "Company: " + strCompanyName + "\r\n"
138 + strEmailBody = strEmailBody + "Registered Business Name: " + strCompanyName + "\r\n"
139 + strEmailBody = strEmailBody + "Registered Business Address: " + strCompanyAddress + "\r\n"
140 + strEmailBody = strEmailBody + "Registered Business City: " + strCompanyAddress + "\r\n"
141 + strEmailBody = strEmailBody + "Registered Business Postal Code: " + strCompanyAddress + "\r\n"
142 + strEmailBody = strEmailBody + "Registered Business Province/State: " + strCompanyAddress + "\r\n"
143 + strEmailBody = strEmailBody + "Registered Business Country: " + strCompanyAddress + "\r\n"
121 121   strEmailBody = strEmailBody + "Role: " + strRole + "\r\n"
122 122   strEmailBody = strEmailBody + "Landline phone: " + strLphone + "\r\n"
123 123   strEmailBody = strEmailBody + "Mobile phone:" + strMphone + "\r\n" + "\r\n"
... ... @@ -131,6 +131,11 @@
131 131   xcontext.put("strEmailBody",strEmailBody)
132 132  // services.writeLog.writeLogEntry(xcontext.getUser(), request.remoteAddr, doc.space, "INSERT AS NEW", intCurUID)
133 133   xcontext.put("strCompanyName",strCompanyName)
157 + xcontext.put("strCompanyName",strCompanyAddress)
158 + xcontext.put("strCompanyName",strCompanyCity)
159 + xcontext.put("strCompanyName",strCompanyPostcode)
160 + xcontext.put("strCompanyName",strCompanyProvince)
161 + xcontext.put("strCompanyName",strCompanyCountry)
134 134   xcontext.put("strTitle",strTitle)
135 135   xcontext.put("strFirstname",strFirstname)
136 136   xcontext.put("strLastname",strLastname)
... ... @@ -145,6 +145,11 @@
145 145   }
146 146   if (strEditCommand == "Proceed"){
147 147   xcontext.put("strCompanyName",strCompanyName)
176 + xcontext.put("strCompanyName",strCompanyAddress)
177 + xcontext.put("strCompanyName",strCompanyCity)
178 + xcontext.put("strCompanyName",strCompanyPostcode)
179 + xcontext.put("strCompanyName",strCompanyProvince)
180 + xcontext.put("strCompanyName",strCompanyCountry)
148 148   xcontext.put("strTitle",strTitle)
149 149   xcontext.put("strFirstname",strFirstname)
150 150   xcontext.put("strLastname",strLastname)
... ... @@ -159,6 +159,11 @@
159 159   }
160 160   if (strEditCommand == "Correct"){
161 161   xcontext.put("strCompanyName",strCompanyName)
195 + xcontext.put("strCompanyName",strCompanyAddress)
196 + xcontext.put("strCompanyName",strCompanyCity)
197 + xcontext.put("strCompanyName",strCompanyPostcode)
198 + xcontext.put("strCompanyName",strCompanyProvince)
199 + xcontext.put("strCompanyName",strCompanyCountry)
162 162   xcontext.put("strTitle",strTitle)
163 163   xcontext.put("strFirstname",strFirstname)
164 164   xcontext.put("strLastname",strLastname)
© 2022 TruCert Assessment Services Inc.
V01-00