<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> FX Curriculum Bank FX Curriculum Bank  by Felice Di Stefano
(PHP_MySQL version)

This object provides you a complete DataBank for work candidates built with Dreamweaver using its native server behaviors plus some of the Felixone's extensions and some hand coding. It features areas for work candidates and for searcher companies, search engine and advanced filtering, plus an administrative area.

A deal of client Javascript has been used for some form validation and cookies management.
In addition to some native DW's behaviors the following Felixone's extensions are used:
FX Password Generator > Used to create a random password when the user registers, this will be emailed to the user.
Check New Elements > Used to check Username and Email duplicates when user registers.
Save Password Login Form > Used to create the login interface and the Save Password functionality.
PHP X UPLOAD > Used in the Curriculum Insertion page to upload candidate documents.
XServer Form Validator > Used to validate the Companies form.
Mail Form > Used to contact the selected candidates.

The files that will be created.
-
Connections/currbase.php
- curbank/inscurr.php - the form to insert the candidate's Curriculum Vitae
- curbank/updcurr.php - the form to update the candidate's Curriculum Vitae
- curbank/inscomp.php - the form to register searcher Company
- curbank/updcomp.php - the form to update searcher Company
- curbank/login.php - to access the candidate area in order to update his data
- curbank/access.php - to access the searcher area
- curbank/search.php - the search engine form
- curbank/results.php - the search engine results
- curbank/selected.php - the filtered results
- curbank/curriculum.php - the printable Curriculum sheet
- curbank/pop.php - the popup window to contact the candidate
- curbank/sent.php - notification of message sent
- curbank/candregistered.php - this will notify the candidate that the password was sent to his address
- curbank/coregistered.php - this will notify the company that the password was sent to their address
- curbank/candupdated.php - notification of update done to the candidate
- curbank/coupdated.php - notification of update done to the company
- curbank/logout.php - log out include file

- curbank/FXInc/ - containing includes and javascript, in order: currform.js, results.js, search.js, FX_mailForm_php.inc, fx_Validator.inc, upload.inc, uploadAction.inc, ProcessWindow.htm, flush.gif

- curbank/images/ - containing the following pics: backtolist.jpg, backtolist_click.jpg, backtores.jpg, backtores_click.jpg, cbank.jpg, gotosel.jpg, gotosel_click.jpg, print.jpg, print_click.jpg, resetsel.jpg, resetsel_click.jpg, avanti_out.gif, avanti_over.gif, blackdot.gif, indietro_out.gif, indietro_over.gif, mail26.gif, misc31.gif, people10.gif, spazio.gif

- admin/index.php - the admin frameset
- admin/left.php - the admin left menu
- admin/main.php - admin splash
- admin/log.php - admin login
- admin/cocomp.php - companies options
- admin/codim.php -           "
- admin/coass.php -           "
- admin/How.php -             "
- admin/civstand.php - candidates options
- admin/drvlic.php -              "
- admin/exp.php -                "
- admin/drvlic.php -              "
- admin/exptype.php -          "
- admin/genre.php -              "
- admin/HSDegree.php -       "
- admin/UDegree.php -          "
- admin/IdPaper.php -           "
- admin/school.php -            "
- admin/provs.php - provinces list (US already listed)
- admin/newadmin.php - new administrator creation
- admin/updadmin.php - administrator updating
- admin/delcomp.php - delete a registered company
- admin/delcand.php - delete a candidate curriculum

The currdata.sql dump for MySQL is included on the package. This must be loaded on MySQL after you have created a new database with the name "currdata".

 

Tutorial

Before you apply this object create a new dynamic page on the root of the site and open it. Then click the object on the insert bar menu, define a welcome message if you wish and click OK. The whole application with all required files will be create in seconds. Refresh the site view to see them.

Describing the Javascript

In the javascript files are contained all the functions to manage the some of the forms and cookies. Assume that because of my lack of perfect English many of the fields names may result a bit wrong but this is not relevant for the application, if you intend to change fields names you will have to find them in the javascript code and change it appropriately otherwise the code may fail.
Functions concern form validation, enabling/disabling of fields relatively to options, chars uppercase, date management and some cookies handling for the filtering, plus some used to adjust few inputs.
The date dropdowns are filled dynamically and assembled so that the date is inserted into database in the mysql format, the process is reversed to retrieve it when updating.
You will find a comment in case you want to change the disabled fields background in case you change the look of the page.
It is recommended to be very careful when doing some change.


Explaining some pages

The graphic is up to you, what you find is just an indication. Recommended to edit enabling Invisible Elements.

inscurr A unique big form where the candidate inserts all the data and upload some document as pictures, videos and pdf or doc curriculum. The form has 4 sections and perhaps esthetically is not a great solution, I am sure you can make better, but I prefer a one picture solution instead of sequential pages to avoid to get lost going back and forward.
The Insert code is manually retouched because when some fields are disabled values remain unset and would make fail the code. When editing watch it first because re-application will erase the adjustment.
Used PHP X UPLOAD, Check New Elements and FX Password Generator.
updcurr As above. Used native MX2004 server behaviors to protect.
candregistered Curriculum registered. Hand coded to email password.
inscomp The form for companies registration which want to access and search the bank. Used Check New Elements, XServer Form Validator.
updcomp As above. Used native MX2004 server behaviors to protect, sessions names modified to not conflict with other areas. Have a look.
coregistered Company registered. Hand coded to email password.
login This login page is reserved to candidates which want to update the curriculum. Used native MX2004 server behaviors. Form created with Save Password Login Form.
access This login page is reserved to registered companies to access the bank for search. Used native MX2004 server behaviors. Sessions names are adjusted to not conflict with others login areas. Have a look.
Form created with Save Password Login Form.
search This is a search form. Whenever a new search is done a previous candidates filtering is reset. Used native MX2004 server behaviors to protect, sessions names modified to not conflict with other areas. Have a look.
results This will display the result of the search with clickable objects as pictures etc. The results can be filtered by selection and the selection remains saved for later review if no new search is done but can be reset by user. The selection remains active even when navigating. Javascript cookies are used for this purpose.
Used native MX2004 server behaviors to protect, sessions names modified to not conflict with other areas. Have a look.
selected Displays only the filtered by selection candidates and remains saved if no new search is done. A link to this page will appear on the menu if a saved selection exists. Javascript cookies are used.
Used native MX2004 server behaviors to protect, sessions names modified to not conflict with other areas. Have a look.
curriculum This is a formal Curriculum sheet to print when clicking the Read link in the results and selected pages which includes the candidate relevant data not sensible and thumbnail picture if exists.
pop A pop up window used to email to the candidate. Appears when clicking the mail object in the results and selected pages. Mail Form was used.

Admin

All the form options are database related so they can be updated at whish, many of these may be incorrect in English so you can re-arrange this data. Some of them are referred in the Javascript code for enabling/disabling fields therefore some of this changes must be reflected in the code.
All pages are using MX2004 native server behaviors, sessions for login (log.php) and pages protection are modified to not conflict with other areas.
In most of the pages Update and Delete code are enclosed in conditions since they are assembled together

Ending

Once the files are created, before you proceed with your editing or test do the following.

Load the included dump to your mysql after creating a new database named "currdata", then double click the connection created in DW and insert the username and password to your mysql, if required. When you go online you will have to remake the connection using the parameters your provider assigned you.

To format birth date the format function is hand coded because normal formatting works only for dates not earlier than 1970.

Then you may proceed with your graphic editing.
In case you want to go to deep editing for dynamics it is recommended that you know what you are doing.

To link to the administration http://yourdomain/admin/index.php


by FELIXONE