Home  Web Programming Search Log JOOMLA Component, ver.1.3
|
|
Search Log JOOMLA Component, ver.1.3 |
|
|
|
|
Sunday, 18 February 2007 |
For this Radio Amateur Web site I developed new Joomla component dedicated primarily for station QSO log searching. My implementation for OM1AVK station you can find selecting from main menu Search Ham Logs .
Purpose
Search Log is primarily oriented for searching in Amateur Radio logs containing informations about performed radio contacts (QSO's). Because of radio amateur rules and gentlement agreement (ham spirit) there is not allowed to gain all important informations about the performed contact via web published log. This Joomla component follows mentioned requirements and allows for each searched callsign to find some important data : contact callsign, band, transmission mode and status of confirming of QSO via QSL card (none as blank, sent, received, confirmed on both sides).
Search Log ver.1.3. allows to present search for more (up to 5) callsigns of stations (base calls) which owns the mutual log. Such type of arrangement is usefull for expedition activities or club maintained logs.
Version history
| version 1.3 | - Multi base callsigns search implemented in the front-end, administration and database
- Internal extensive re-design
- Functionality of ver.1.2. is included
- Tested on MySQL database ver.4, ver.5
| | version 1.2 | - Sole one base callsign search implemented in the front-end, administration and database
- Basic public version
| Upgrade to version 1.3Prior to the installation of Search Log ver.1.3 you have to unistall the old version via Administrator Installers/Components. Unistallation operation remains intact your log table in the database. Then after you can install the component again via Administrator Installers/Components. Screen example
version 1.3  version 1.2  Station Log QSO log data are stored in database table in MySQL database in the following manner : version 1.3  Numbers in column 'callbase' are integers (from 1 up to 5) relating to the fields 'Callsign #n' on the Search Log administration page. For simple (one station log) no assigment in the fields 'Callsign #n' is necessary - in this case data select do not cover the column 'callbase' (it can have no/any value). For multi station log you have to set callsign names in appropriate fields on Search Log administration page. version 1.2  As you see in the tables is callsign stored in two columns - in the 'call' is allocated full callsign as used during QSO and in the 'radio' column here is basic callsign stripped, without /P or /number (as used by portable operation). This arrangement allows easy searching for all QSO records for the basic callsign as shown on the first figure. During installation of SearchLog component is created the related table with naming 'jos_calls' (when the default table prefix 'jos' is used). Importing data into this table as well as data update and maintainence is necessary to perform by PHPMyAdmin client or other database administration frontend. SearchLog SettingsEach of the SearchLog parameters has on administration page pop-up hint when appointed by mouse cursor. For multilanguage pages is here foreseen to use '*' value of the parameter in which case the proper definition from language definition file is used (valid for _SEARCHLOG_TITLE, _SEARCHLOG_DESC, _SEARCHLOG_TEXT definitions). Behavior of Base callsigns settings : - NO Base callsign set - Base callsign combo is not shown on log search page, 'callbase' column in the database is not included in search select command
- One Base callsign set - Base callsign combo is not shown on log search page, 'callbase' column in the database IS INCLUDED in search select command
- More Base callsigns set - Base callsign combo IS SHOWN on log search page, 'callbase' column in the database IS INCLUDED in search select command
Download
Component SearchLog, ver.1.2., designed for Joomla! framework, ver.1.0.11, is available for download here. |
|
Last Updated ( Friday, 05 October 2007 )
|
|