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

Summary

Details

Page properties
Content
... ... @@ -10,6 +10,11 @@
10 10  
11 11   String strContactID = ""
12 12   String strCompanyName = ""
13 + String strCompanyAddress = ""
14 + String strCompanyCity = ""
15 + String strCompanyPostcode = ""
16 + String strCompanyProvince = ""
17 + String strCompanyCountry = ""
13 13   String strTitle = ""
14 14   String strFirstname = ""
15 15   String strLastname = ""
... ... @@ -38,8 +38,8 @@
38 38   if ((strEditCommand == "Correct") || (strEditCommand == "Register") || (strEditCommand == "Proceed")){
39 39  
40 40   strCompanyName = services.cleanStr.alphanum(request.companyname)
41 - strCompanyAddress = services.cleanStr.alphanum(request.companycity)
42 - strCompanyCity = services.cleanStr.alphanum(request.companyaddress)
46 + strCompanyAddress = services.cleanStr.alphanum(request.companyaddress)
47 + strCompanyCity = services.cleanStr.alphanum(request.companycity)
43 43   strCompanyPostcode = services.cleanStr.alphanum(request.companypostcode)
44 44   strCompanyProvince = services.cleanStr.alphanum(request.companyprovince)
45 45   strCompanyCountry = services.cleanStr.alphanum(request.companycountry)
... ... @@ -62,6 +62,11 @@
62 62   sqlQueryInsertRec = "INSERT INTO " + strDBTable +
63 63   """(
64 64   companyname,
70 + companyaddress,
71 + companycity,
72 + companypostcode,
73 + companyprovince,
74 + companycountry,
65 65   title,
66 66   firstname,
67 67   lastname,
... ... @@ -77,6 +77,11 @@
77 77   confemailsentcode)
78 78   VALUES(
79 79   '$strCompanyName',
90 + '$strCompanyAddress',
91 + '$strCompanyCity',
92 + '$strCompanyPostcode',
93 + '$strCompanyProvince',
94 + '$strCompanyCountry',
80 80   '$strTitle',
81 81   '$strFirstname',
82 82   '$strLastname',
... ... @@ -98,6 +98,11 @@
98 98   """
99 99   SET
100 100   companyname = '$strCompanyName',
116 + companyaddress = '$strCompanyAddress',
117 + companycity = '$strCompanyCity',
118 + companypostcode = '$strCompanyPostcode',
119 + companyprovince = '$strCompanyProvince',
120 + companycountry = '$strCompanyCountry',
101 101   title = '$strTitle',
102 102   firstname = '$strFirstname',
103 103   lastname = '$strLastname',
... ... @@ -119,16 +119,11 @@
119 119   }
120 120   strEmailBody = "Dear " + strPrefname + ","
121 121   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"
122 - strEmailBody = strEmailBody + "Name: " + strTitle + " " + strFirstname + " " + strLastname + "\r\n"
123 - strEmailBody = strEmailBody + "Registered Business Name: " + strCompanyName + "\r\n"
124 - strEmailBody = strEmailBody + "Registered Business Address: " + strCompanyAddress + "\r\n"
125 - strEmailBody = strEmailBody + "Registered Business City: " + strCompanyAddress + "\r\n"
126 - strEmailBody = strEmailBody + "Registered Business Postal Code: " + strCompanyAddress + "\r\n"
127 - strEmailBody = strEmailBody + "Registered Business Province/State: " + strCompanyAddress + "\r\n"
128 - strEmailBody = strEmailBody + "Registered Business Country: " + strCompanyAddress + "\r\n"
129 - strEmailBody = strEmailBody + "Role: " + strRole + "\r\n"
142 + strEmailBody = strEmailBody + "Registered Business: " + strCompanyName + ", " + strCompanyAddress + ", " + strCompanyCity + ", " + strCompanyPostcode + ", " + strCompanyProvince + ", " + strCompanyCountry + "\r\n" + "\r\n"
143 + strEmailBody = strEmailBody + "Contact info: " + strTitle + " " + strFirstname + " " + strLastname + "\r\n"
144 + if ((strRole) and (strRole !! "null")){strEmailBody = strEmailBody + "Contact role: " + strRole + "\r\n"}
130 130   strEmailBody = strEmailBody + "Landline phone: " + strLphone + "\r\n"
131 - strEmailBody = strEmailBody + "Mobile phone:" + strMphone + "\r\n" + "\r\n"
146 + strEmailBody = strEmailBody + "Mobile phone: " + strMphone + "\r\n" + "\r\n"
132 132   strEmailBody = strEmailBody + "The request was made from IP address: " + strCreateIP
133 133   strEmailBody = strEmailBody + "\r\n" + "\r\n" + "Please click the below link to confirm your e-mail address:" + "\r\n"
134 134   strEmailBody = strEmailBody + "https://cecocert.com/bin/view/StartPage/X1100%20-%20Process%20e-mail%20confirmation/WebHome"
... ... @@ -139,11 +139,11 @@
139 139   xcontext.put("strEmailBody",strEmailBody)
140 140  // services.writeLog.writeLogEntry(xcontext.getUser(), request.remoteAddr, doc.space, "INSERT AS NEW", intCurUID)
141 141   xcontext.put("strCompanyName",strCompanyName)
142 - xcontext.put("strCompanyName",strCompanyAddress)
143 - xcontext.put("strCompanyName",strCompanyCity)
144 - xcontext.put("strCompanyName",strCompanyPostcode)
145 - xcontext.put("strCompanyName",strCompanyProvince)
146 - xcontext.put("strCompanyName",strCompanyCountry)
157 + xcontext.put("strCompanyAddress",strCompanyAddress)
158 + xcontext.put("strCompanyCity",strCompanyCity)
159 + xcontext.put("strCompanyPostcode",strCompanyPostcode)
160 + xcontext.put("strCompanyProvince",strCompanyProvince)
161 + xcontext.put("strCompanyCountry",strCompanyCountry)
147 147   xcontext.put("strTitle",strTitle)
148 148   xcontext.put("strFirstname",strFirstname)
149 149   xcontext.put("strLastname",strLastname)
... ... @@ -158,11 +158,11 @@
158 158   }
159 159   if (strEditCommand == "Proceed"){
160 160   xcontext.put("strCompanyName",strCompanyName)
161 - xcontext.put("strCompanyName",strCompanyAddress)
162 - xcontext.put("strCompanyName",strCompanyCity)
163 - xcontext.put("strCompanyName",strCompanyPostcode)
164 - xcontext.put("strCompanyName",strCompanyProvince)
165 - xcontext.put("strCompanyName",strCompanyCountry)
176 + xcontext.put("strCompanyAddress",strCompanyAddress)
177 + xcontext.put("strCompanyCity",strCompanyCity)
178 + xcontext.put("strCompanyPostcode",strCompanyPostcode)
179 + xcontext.put("strCompanyProvince",strCompanyProvince)
180 + xcontext.put("strCompanyCountry",strCompanyCountry)
166 166   xcontext.put("strTitle",strTitle)
167 167   xcontext.put("strFirstname",strFirstname)
168 168   xcontext.put("strLastname",strLastname)
... ... @@ -177,11 +177,11 @@
177 177   }
178 178   if (strEditCommand == "Correct"){
179 179   xcontext.put("strCompanyName",strCompanyName)
180 - xcontext.put("strCompanyName",strCompanyAddress)
181 - xcontext.put("strCompanyName",strCompanyCity)
182 - xcontext.put("strCompanyName",strCompanyPostcode)
183 - xcontext.put("strCompanyName",strCompanyProvince)
184 - xcontext.put("strCompanyName",strCompanyCountry)
195 + xcontext.put("strCompanyAddress",strCompanyAddress)
196 + xcontext.put("strCompanyCity",strCompanyCity)
197 + xcontext.put("strCompanyPostcode",strCompanyPostcode)
198 + xcontext.put("strCompanyProvince",strCompanyProvince)
199 + xcontext.put("strCompanyCountry",strCompanyCountry)
185 185   xcontext.put("strTitle",strTitle)
186 186   xcontext.put("strFirstname",strFirstname)
187 187   xcontext.put("strLastname",strLastname)
... ... @@ -350,6 +350,33 @@
350 350   #if( $xcontext.strFormStatus == "DataCorrection" )
351 351   {{html wiki=false clean=false}}
352 352   <form action="" class="xformInline" method="post" name="User Registration Form">
368 +<head>
369 +<style>
370 +#cecTable {
371 + font-family: Arial, Helvetica, sans-serif;
372 + border-collapse: collapse;
373 + border-color: #007d84
374 + width: 100%;
375 +}
376 +
377 +#cecTable td, #cecTable th {
378 + border: 1px solid #007d84;
379 + padding: 8px;
380 +}
381 +
382 +#cecTable tr:nth-child(even){background-color: #d0d3d4;}
383 +
384 +#cecTable tr:hover {background-color: #ddd;}
385 +
386 +#cecTable th {
387 + padding-top: 12px;
388 + padding-bottom: 12px;
389 + text-align: left;
390 + background-color: #007d84;
391 + color: white;
392 +}
393 +</style>
394 +</head>
353 353   <table id="cecTable"; cellspacing="5px" cellpadding="5%" border="1" width="100%"; align="left">
354 354   <col style="width:30%">
355 355   <col style="width:70%">
... ... @@ -366,7 +366,7 @@
366 366   <tr>
367 367   <td align="left" class="style1">Registered Business Address - House Number, Street:</td>
368 368   <td class="style1">
369 - <input type="text" id="companyaddress" name="companyaddress" placeholder="Enter the House Number, Street, Floor, etc part of your company's registered business address" size="100">
411 + <input type="text" id="companyaddress" name="companyaddress" placeholder="Enter the House Number, Street, Floor, etc part of your company's registered business address" value="${xcontext.strCompanyAddress}" size="100">
370 370   </select>
371 371   </td>
372 372   </tr>
... ... @@ -373,7 +373,7 @@
373 373   <tr>
374 374   <td align="left" class="style1">Registered Business Address - City:</td>
375 375   <td class="style1">
376 - <input type="text" id="companycity" name="companycity" placeholder="Enter the City part of your company's registered business address" size="100">
418 + <input type="text" id="companycity" name="companycity" placeholder="Enter the City part of your company's registered business address" value="${xcontext.strCompanyCity}" size="100">
377 377   </select>
378 378   </td>
379 379   </tr>
... ... @@ -380,7 +380,7 @@
380 380   <tr>
381 381   <td align="left" class="style1">Registered Business Address - Postal Code:</td>
382 382   <td class="style1">
383 - <input type="text" id="companypostcode" name="companypostcode" placeholder="Enter the Postal Code part of your company's registered business address" size="100">
425 + <input type="text" id="companypostcode" name="companypostcode" placeholder="Enter the Postal Code part of your company's registered business address" value="${xcontext.strCompanyPostcode}" size="100">
384 384   </select>
385 385   </td>
386 386   </tr>
... ... @@ -387,7 +387,7 @@
387 387   <tr>
388 388   <td align="left" class="style1">Registered Business Address - Province or State:</td>
389 389   <td class="style1">
390 - <input type="text" id="companyprovince" name="companyprovince" placeholder="Enter the Province or State part of your company's registered business address, leave empty if n/a" size="100">
432 + <input type="text" id="companyprovince" name="companyprovince" placeholder="Enter the Province or State part of your company's registered business address, leave empty if n/a" value="${xcontext.strCompanyProvince}" size="100">
391 391   </select>
392 392   </td>
393 393   </tr>
... ... @@ -394,7 +394,7 @@
394 394   <tr>
395 395   <td align="left" class="style1">Registered Business Address - Country:</td>
396 396   <td class="style1">
397 - <input type="text" id="companycountry" name="companycountry" placeholder="Enter the Country part of your company's registered business address" size="50">
439 + <input type="text" id="companycountry" name="companycountry" placeholder="Enter the Country part of your company's registered business address" value="${xcontext.strCompanyCountry}" size="50">
398 398   </select>
399 399   </td>
400 400   </tr>
... ... @@ -464,9 +464,39 @@
464 464  You have entered the following information to register to the CEC Scheme:
465 465   {{html wiki=false clean=false}}
466 466   <form action="" class="xformInline" method="post" name="User Registration Form">
467 - <table id="table1"; cellspacing="5px" cellpadding="5%" border="1" width="100%"; align="left">
509 +<head>
510 +<style>
511 +#cecTable {
512 + font-family: Arial, Helvetica, sans-serif;
513 + border-collapse: collapse;
514 + border-color: #007d84
515 + width: 100%;
516 +}
517 +
518 +#cecTable td, #cecTable th {
519 + border: 1px solid #007d84;
520 + padding: 8px;
521 +}
522 +
523 +#cecTable tr:nth-child(even){background-color: #d0d3d4;}
524 +
525 +#cecTable tr:hover {background-color: #ddd;}
526 +
527 +#cecTable th {
528 + padding-top: 12px;
529 + padding-bottom: 12px;
530 + text-align: left;
531 + background-color: #007d84;
532 + color: white;
533 +}
534 +</style>
535 +</head>
536 + <table id="cecTable"; cellspacing="5px" cellpadding="5%" border="1" width="100%"; align="left">
468 468   <col style="width:30%">
469 469   <col style="width:70%">
539 + <th colspan = "2">
540 + <b>Company Information</b>
541 + </th>
470 470   <tr>
471 471   <td align="left" class="style1">Company name:</td>
472 472   <td class="style1">
... ... @@ -475,6 +475,45 @@
475 475   </td>
476 476   </tr>
477 477   <tr>
550 + <td align="left" class="style1">Registered Business Address - House Number, Street:</td>
551 + <td class="style1">
552 + <input type="hidden" id="companyaddress" name="companyaddress" readonly value="${xcontext.strCompanyAddress}" size="100">
553 + ${xcontext.strCompanyAddress}
554 + </td>
555 + </tr>
556 + <tr>
557 + <td align="left" class="style1">Registered Business Address - City:</td>
558 + <td class="style1">
559 + <input type="hidden" id="companycity" name="companycity" readonly value="${xcontext.strCompanyCity}" size="100">
560 + ${xcontext.strCompanyCity}
561 + </td>
562 + </tr>
563 + <tr>
564 + <td align="left" class="style1">Registered Business Address - Postal Code:</td>
565 + <td class="style1">
566 + <input type="hidden" id="companypostcode" name="companypostcode" readonly value="${xcontext.strCompanyPostcode}" size="100">
567 + ${xcontext.strCompanyPostcode}
568 + </td>
569 + </tr>
570 + <tr>
571 + <td align="left" class="style1">Registered Business Address - Province or State:</td>
572 + <td class="style1">
573 + <input type="hidden" id="companyprovince" name="companyprovince" readonly value="${xcontext.strCompanyProvince}" size="100">
574 + ${xcontext.strCompanyProvince}
575 + </td>
576 + </tr>
577 + <tr>
578 + <td align="left" class="style1">Registered Business Address - Country:</td>
579 + <td class="style1">
580 + <input type="hidden" id="companycountry" name="companycountry" readonly value="${xcontext.strCompanyCountry}" size="50">
581 + ${xcontext.strCompanyCountry}
582 + </td>
583 + </tr>
584 + <th colspan = "2">
585 + <b>Your Contact Information</b>
586 + </th>
587 +
588 + <tr>
478 478   <td align="hidden" class="style1">Title:</td>
479 479   <td class="style1">
480 480   <input type="hidden" id="title" name="title" readonly value="${xcontext.strTitle}" size="10">
© 2022 TruCert Assessment Services Inc.
V01-00