{"id":11917,"date":"2016-11-15T19:24:38","date_gmt":"2016-11-15T16:24:38","guid":{"rendered":"http:\/\/blog.belvg.com\/?p=11917"},"modified":"2025-02-11T13:12:57","modified_gmt":"2025-02-11T11:12:57","slug":"prestashop-mvc-part-1-creating-a-model","status":"publish","type":"post","link":"https:\/\/belvg.com\/blog\/prestashop-mvc-part-1-creating-a-model.html","title":{"rendered":"Prestashop MVC. Part 1: Creating a Model"},"content":{"rendered":"

This article is dedicated to the Model-view-controller in Prestashop CMS. Due to the amount of information we decided to divide it into 3 parts. In the following part we are going to consider basic principles of creation and operation with a model. Moreover, you can find some information regarding this subject under the following link.<\/a><\/p>\n

<\/p>\n

Let’s consider Category(\/classes\/Category.php) object as a model example. Category class is inherited from ObjectModel:<\/p>\n

class CategoryCore extends ObjectModel\r\n{\r\n    \tpublic $id;\r\n\r\n   \t \/** @var int category ID *\/\r\n   \t public $id_category;\r\n\r\n    \t\/** @var string Name *\/\r\n    \tpublic $name;\r\n\r\n    \t…\r\n}\r\n<\/pre>\n
Which in turn implements ERM<\/a> (entity-relationship model) in Prestashop, in other words every row in database table subsumes to entity and object, that very simplifies data management.<\/p>\n
Basing on Category class example we are going to create new tables in a database to build up our model:<\/p>\n
CREATE TABLE IF NOT EXISTS `ps_category` (\r\n  `id_category` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  `id_parent` int(10) unsigned NOT NULL,\r\n  `id_shop_default` int(10) unsigned NOT NULL DEFAULT '1',\r\n  ...\r\n  `is_root_category` tinyint(1) NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`id_category`),\r\n  …\r\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\r\n<\/pre>\n
CREATE TABLE IF NOT EXISTS `ps_category_lang` (\r\n  `id_category` int(10) unsigned NOT NULL,\r\n  `id_shop` int(11) unsigned NOT NULL DEFAULT '1',\r\n  `id_lang` int(10) unsigned NOT NULL,\r\n  `name` varchar(128) NOT NULL,\r\n  `description` text,\r\n  ...\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n<\/pre>\n
CREATE TABLE IF NOT EXISTS `ps_category_shop` (\r\n  `id_category` int(11) NOT NULL,\r\n  `id_shop` int(11) NOT NULL,\r\n  `position` int(10) unsigned NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`id_category`,`id_shop`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n<\/pre>\n
CREATE TABLE IF NOT EXISTS `ps_category_group` (\r\n  `id_category` int(10) unsigned NOT NULL,\r\n  `id_group` int(10) unsigned NOT NULL,\r\n  PRIMARY KEY (`id_category`,`id_group`),\r\n  KEY `id_category` (`id_category`),\r\n  KEY `id_group` (`id_group`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n<\/pre>\n
In order of creating new tables it is necessary to follow some rules:<\/p>\n
1. A name of unique table key is built in accordance with the rule:<\/p>\n
'id_' . $name_table(without prefix, CREATE TABLE IF NOT EXISTS `ps_category` …  - `id_category` int(11) NOT NULL, ...)<\/pre>\n
2. If there are any data in different languages in the entity, then you must create a table name with postfix:<\/p>\n
$name_table .  '_lang' (CREATE TABLE IF NOT EXISTS `ps_category_lang` …)<\/pre>\n