VirtueMart

h1. Coding standards and hints for Virtuemart

In general we avoid the use of globals. Globals are hard to maintain and they are unsure variables. 

h2. Code Formatting:

We follow the joomla standard in most cases. We use camelCase for methods. For faster copypasting and working with database fields, both variable and database fields are lowercase and seperated with "_". You may use for internal variables camelCase also.

Example:

<pre>

function exampleMethod($data = 0) {

    if (!$product_id) $product_id = JRequest::getInt('product_id', 0);

    if ($product_id > 0) {

        ...;

    }

}

</pre>

h2. SQL Formatting:

The queries should follow this format:

@$q  = 'SELECT `example_id` FROM  `#__vm_table` WHERE `user_id`=' . (int)$user_id;@

or if the

$user_id is an array, use $user_id["myId"]

Placing of the ` improves speed, because the sql-engine can parse faster ( and do not have to reparse).

h2. Variable Formatting:

Due abstract logic many people name their variables or database fields just "id", "key", "value" and so on.

In our case we want to rewrite the structure of an old code, therefore it is very important to find the variable in the code rather fields in the database.

So we want a kind of this: <classname><tablename>variable like here

$vendor_id or $payment_method_id

Exception from this rule is the use of ordering and published. Ordering and published with 0 and 1 as values are useable with the joomla standard methods.

h2. Filename Formatting:

Filenames should be lowercase.

Models filenames (mymodel.php), view direcorynames (myview), all helper files and probably all other files loaded by the Joomla Framework, must be lowercase, no matter how you load the file:

 @$this->loadHelper('adminMenu'); // looks for the file helpers/adminmenu.php@

More complex filenames that are specific to your task and loaded by your own code (using require_once()), e.g. mySpecificClass.php, can be camelcase.

Read this article for more info http://docs.joomla.org/Talk:Developing_a_Model-View-Controller_Component_-_Part_1#Use_lowercase_file_and_folder_names_in_your_components.21 

h2. Table names

Depending on the way mysqld is configured, the MySQL server might be case sensitive on linux systems too, so _always_ use the correct case, preferably lowercase only.

h2. URL Requests:

As written in the section __Filename Formatting__ above, Joomla requires lowercase filenames. However, URL requests are not lowercased by Joomla. In order to find the proper views and controllers, make sure you use lowercase only in requests, e.g.:

  $this->setRedirect('index.php?option=com_virtuemart&view=updatesMigration', $msg); // Fails

$this->setRedirect('index.php?option=com_virtuemart&view=updatesmigration', $msg); // Works

h2. Character Encoding:

Like in joomla we use UTF-8. Please ensure the right character set in your IDE.

h1. Some coding standards

h2. Standard publishing fields use:

- published with 0 and 1 formatted in the db as tinyInt(1) with standard 0

- publish_up and publish_down formatted in the db as datetime with standard 0000-00-00 00:00:00

The standard query is then 

	@ $db = &JFactory::getDBO();

	$this->_nullDate = $db->getNullDate();

	$this->_now        = JFactory::getDate()->toMySQL();

 $query  = 'SELECT * FROM `#__sometable` WHERE yourexampel ="myexampelvalue" AND ';

 $query .= ' ( publish_up = '.$this->_db->Quote($this->_nullDate).' OR publish_up <= '.$this->_db->Quote($this->_now).' )' .

 ' AND ( publish_down = '.$this->_db->Quote($this->_nullDate).' OR publish_down >= '.$this->_db->Quote($this->_now).' ) '; @