Currency

Introduction

Create a real currency field with the benefits of filtering due the nature of the field.

Installation

Prerequisites

Make sure your system meets the minimum requirements:

ExpressionEngine 2.10.x or 3.1.x later
PHP 5.3
cURL

Installation Instructions

Upload the folders to the right folder according the downloaded ZIP structure
Install the module in Add-Ons → Modules

Update instructions

Backup the Files and the Database
Remove the old module files (both system and themes)
Place the new files in the right folders
Navigatie to the module page and trigger the update proces, by clicking on the "module update" buttondule page and trigger the update proces, by clicking on the "module update" buttonoces, by clicking on the "module update" button

The currency fieldtype works just like any other fieldtype, it also looks like a normal fieldtype but in fact it is not a real simple field. The currency fieldtype convert in the MySQL database to a decimal field. This way it can hold any currency value like 9.95 or 188.50

Filtering

Because the field is now converted to an decimal, the filtering (orderby) in the {exp:channel:entries} works perfectly

With the decimal settings you can convert the point to a comma.

Overview

Be aware

Because the currency fieldtype convert the field in mysql to a decimal field, it is wise to delete this field if you want to change it to an other fieldtype. Otherwise that field is an decimal field and not a text field.