Model

class Model

Probably the most significant class in ATK Data - Model - acts as a Parent for all your entity classes:

class User extends \atk4\data\Model

You must define individual classes for all your business entities. Other frameworks may rely on XML or annotations, in ATK everything is defined inside your “Model” class through pure PHP (See Initialization below)

Once you create instance of your model class, it can be recycled. With a single object you can load/unload individual records (See Single record Operations below):

$m = new User($db);

$m->load(3);
$m['note'] = 'just updating';
$m->save();
$m->unload();

$m->load(8);
....

and even perform operations on multiple records (See Persistence Actions below):

$m = new User($db);
$m->addCondition('expired', true);

$m->action('delete')->execute(); // performs mass delete, hooks are not executed

$m->each('delete'); // deletes each record, hooks are executed

When data is loaded from associated Persistence, it is automatically converted into a native PHP type (such as DateTime object) through a process called Typecasting. Various rules apply when you set value for model fields (Normalization) or when data is stored into database that does support a field type (Serialization)

Furthermore, because you define Models as a class, it is very easy to introduce your own extensions which may include Hooks and Actions.

There are many advanced topics that ATK Data covers, such as References, Joins, Aggregation, SQL actions, Unions, Deep Traversal and Containment.

The design is also very extensible allowing you to introduce new Field types, Join strategies, Reference patterns, Action types.

I suggest you to read the next section to make sure you fully understand the Model and its role in ATK Data.

Understanding Model

Please understand that Model in ATK Data is unlike models in other data frameworks. The Model class can be seen as a “gateway” between your code and many other features of ATK Data.

For example - you may define fields and relations for the model:

$model->addField('age', ['type'=>'number']);
$model->hasMany('Children', Person::class);

Methods addField and hasMany will ultimatelly create and link model with a corresponding Field object and Reference object. Those classes contain the logic, but in 95% of the use-cases, you will not have to dive deep into them.

Model object = Data Set

From the moment when you create instance of your model class, it represents a DataSet - set of records that share some common traits:

$all_users = new User($db); // John, Susan, Leo, Bill, Karen

Certain operations may “shrink” this set, such as adding conditions:

$male_users = $all_users->addCondition('gender', 'M');

send_email_to_users($male_users);

This essentially filters your users without fetching them from the database server. In my example, when I pass $male_users to the method, no records are loaded yet from the database. It is up to the implementation of send_email_to_users to load or iterate records or perhaps approach the data-set differently, e.g. execute multi-record operation.

Note that most operations on Model are mutating (meaning that in example above $all_users will also be filtered and in fact, $all_users and $male_users will reference same object. Use clone if you do not wish to affect $all_users.

Model object = meta information

By design, Model object does not have direct knowledge of higher level objects or specific implementations. Still - Model will be a good place to deposit some meta-information:

$model->addField('age', ['ui'=>['caption'=>'Put your age here']]);

Model and Field class will simply store the “ui” property which may (or may not) be used by ATK UI component or some add-on.

Domain vs Persistence

When you declare a model Field you can also store some persistence-related meta-information:

// override how your persistence formats date field
$model->addField('date_of_birth', ['type'=>'date', 'persistence'=>['format'=>'Ymd']]);

// declare field which is not saved
$model->addField('secret', ['never_persist'=>true]);

// rellocate into a different field
$model->addField('old_field', ['actual'=>'new_field']);

// or even into a different table
$model->join('new_table')->addField('extra_field');

Model also has a property $table, which indicate name of default table/collection/file to be used by persistence. (Name of property is decided to avoid beginner confusion)

Good naming for a Model

Some parts of this documentation were created years ago and may use class notation: Model_User. We actually recommend you to use namespaces instead:

namespace yourapp\Model;

use \atk4\data\Model;

class User extends Model {
   function init() {
      parent::init();

      $this->addField('name');

      $this->hasMany('Invoices', Invoice::class);
   }
}

PHP does not have a “class” type, so Invoice::class will translate into a string “yourappModelInvoice” and is a most efficient way to specify related class name.

You way also use new Invoice() there but be sure not to specify any argument, unless you intend to use cross-persistence referencing (this is further explained in Advanced section)

Initialization

Model::init()

Method init() will automatically be called when your Model is associated with Persistence object. It is commonly used to declare fields, conditions, relations, hooks and more:

class Model_User extends atk4\data\Model
{
    function init() {
        parent::init();

        $this->addField('name');
        $this->addField('surname');
    }
}

You may safely rely on $this->persistence property to make choices:

if ($this->persistence instanceof \atk4\data\Persistence\SQL) {

   // Calculating on SQL server is more efficient!!
   $this->addExpression('total', '[amount] + [vat]');
} else {

   // Fallback
   $this->addCalculatedField('total', function($m) {
      return $m['amount'] + $m['vat'];
   } );
}

To invoke code from init() methods of ALL models (for example soft-delete logic), you use Persistence’s “afterAdd” hook. This will not affect ALL models but just models which are associated with said persistence:

$db->onHook('afterAdd', function($p, $m) use($acl) {

   $fields = $m->getFields();

   $acl->disableRestrictedFields($fields);

});

$invoice = new Invoice($db);

Fields

Each model field is represented by a Field object:

$model->addField('name');

var_dump($model->getField('name'));

Other persistence framework will use “properties”, because individual objects may impact performance. In ATK Data this is not an issue, because “Model” is re-usable:

foreach(new User($db) as $user) {

   // will be the same object every time!!
   var_dump($user->getField['name']);

   // this is also the same object every time!!
   var_dump($user)

}

Instead, Field handles many very valuable operations which would otherwise fall on the shoulders of developer (Read more here Field)

Model::addField($name, $seed)

Creates a new field object inside your model (by default the class is ‘Field’). The fields are implemented on top of Containers from Agile Core.

Second argument to addField() will contain a seed for the Field class:

$this->addField('surname', ['default'=>'Smith']);

Additionally, type property can be used to determine the best Field class to handle the type:

$field = $this->addField('is_married', ['type'=>'boolean']);

// $field class now will be Field\Boolean

You may also specify your own Field implementation:

$field = $this->addField('amount_and_currency', new MyAmountCurrencyField());

Read more about Field

Model::addFields(array $fields, $defaults = [])

Creates multiple field objects in one method call. See multiple syntax examples:

$m->addFields(['name'], ['default' => 'anonymous']);

$m->addFields([
    'last_name',
    'login' => ['default' => 'unknown'],
    'salary' => ['type'=>'money', CustomField::class, 'default' => 100],
    ['tax', CustomField::class, 'type'=>'money', 'default' => 20],
    'vat' => new CustomField(['type'=>'money', 'default' => 15]),
]);

Read-only Fields

Although you may make any field read-only:

$this->addField('name', ['read_only'=>true]);

There are two methods for adding dynamically calculated fields.

Model::addExpression($name, $definition)

Defines a field as server-side expression (e.g. SQL):

$this->addExpression('total', '[amount] + [vat]');

The above code is executed on the server (SQL) and can be very powerful. You must make sure that expression is valid for current $this->persistence:

$product->addExpression('discount', $this->refLink('category_id')->fieldQuery('default_discount'));
// expression as a sub-select from referenced model (Category) imported as a read-only field
// of $product model

$product->addExpression('total', 'if([is_discounted], ([amount]+[vat])*[discount], [amount] + [vat])');
// new "total" field now contains complex logic, which is executed in SQL

$product->addCondition('total', '<', 10);
// filter products that cost less than 10.00 (including discount)

For the times when you are not working with SQL persistence, you can calculate field in PHP.

Model::addCalculatedField($name, $callback)

Creates new field object inside your model. Field value will be automatically calculated by your callback method right after individual record is loaded by the model:

$this->addField('term', ['caption'=>'Repayment term in months', 'default'=>36]);
$this->addField('rate', ['caption'=>'APR %', 'default'=>5]);

$this->addCalculatedField('interest', function($m) {
   return $m->calculateInterest();
});

Important

always use argument $m instead of $this inside your callbacks. If model is to be clone`d, the code relying on `$this would reference original model, but the code using $m will properly address the model which triggered the callback.

This can also be useful for calculating relative times:

class MyModel extends Model {
   use HumanTiming; // See https://stackoverflow.com/questions/2915864/php-how-to-find-the-time-elapsed-since-a-date-time

   function init() {
      parent::init();

      $this->addCalculatedField('event_ts_human_friendly', function($m) {
         return $this->humanTiming($m['event_ts']);
      });

   }
}

Strict Fields

By default model will only allow you to operate with values for the fields that have been defined through addField(). If you attempt to get, set or otherwise access the value of any other field that has not been properly defined, you’ll get an exception. Read more about Field

If you set strict_fields to false, then the check will not be performed.

Actions

Another common thing to define inside Model::init() would be a user invokable actions:

class User extends Model {

   function init() {

      parent::init();

      $this->addField('name');
      $this->addField('email');
      $this->addField('password', ['type'=>'password']);

      $this->addAction('send_new_password');

   }

   function send_new_password()
   {
      // .. code here

      $this->save(['password'=> .. ]);

      return 'generated and sent password to '.$m['name'];
   }
}

With a method alone, you can generate and send passwords:

$user->load(3);
$user->send_new_password();

but using $this->addAction() exposes that method to the ATK UI wigets, so if your admin is using CRUD, a new button will be available allowing passwords to be generated and sent to the users:

$app->add('CRUD')->setModel(new User($app->db));

Read more about UserAction

Hooks

Hooks (behaviours) can allow you to define callbacks which would trigger when data is loaded, saved, deleted etc. Hooks are typically defined in Model::init() but will be executed accordingly.

There are countless uses for hooks and even more opportunities to use hook by all sorts of extensions.

Validation

Validation is an extensive topic, but the simplest use-case would be through a hook:

$this->addField('name');

$this->onHook('validate', function($m) {
   if ($m['name'] == 'C#') {
      return ['name'=>'No sharp objects are allowed'];
   }
});

Now if you attempt to save object, you will receive ValidationException:

$model['name'] = 'Swift';
$model->saveAndUnload();      // all good

$model['name'] = 'C#';
$model->saveAndUnload();      // exception here

Other Uses

Other uses for model hooks are explained in Hooks

Inheritance

ATK Data models are really good for structuring hierarchically. Here is example:

class VIPUser extends User {
   function init() {
      parent::init();

      $this->addCondition('purchases', '>', 1000);

      $this->addAction('send_gift');
   }

   function send_gift() {
       ...
   }
}

This introduces a new business object, which is a sub-set of User. The new class will inherit all the fields, methods and actions of “User” class but will introduce one new action - send_gift.

There are some advanced techniques like “SubTypes” or class substitution, for example, this hook may be placed in the “User” class init():

$this->onHook('afterLoad', function($m) {
   if ($m['purchases'] > 1000) {
      $this->breakHook($this->asModel(VIPUser::class);
   }
});

See also FieldSubTypeSwitch

Associating Model with Database

After talking extensively about model definition, lets discuss how model is associated with persistence. In the most basic form, model is associated with persistence like this:

$m = new User($db);

If model was created without persistence Model::init() will not fire. You can explicitly associate model with persistence like this:

$m = new User();

// ....

$db->add($m);  // links with persistence

Multiple models can be associated with the same persistence. Here are also some examples of static persistence:

$m = new Model(new Persistence\Static_(['john', 'peter', 'steve']);

$m->load(1);
echo $m['name'];  // peter

See PersistenceStatic_

property Model::$persistence

Refers to the persistence driver in use by current model. Calling certain methods such as save(), addCondition() or action() will rely on this property.

property Model::$persistence_data

DO NOT USE: Array containing arbitrary data by a specific persistence layer.

property Model::$table

If $table property is set, then your persistence driver will use it as default table / collection when loading data. If you omit the table, you should specify it when associating model with database:

$m = new User($db, 'user');

This also overrides current table value.

Model::withPersistence($persistence, $id = null, $class = null)

Creates a duplicate of a current model and associate new copy with a specified persistence. This method is useful for moving model data from one persistence to another.

Model::asModel($class, $options = [])

Casts current model into another class. The new model class should be compatible with $this - you can do $user->asModel(VIPUser::class) but converting $user into Invoice::class is a bad idea.

Although class is switched, the new model will retain current record data, replace all fields/actions and will combine conditions (avoiding identical conditions).

Populating Data

Model::insert($row)

Inserts a new record into the database and returns $id. It does not affect currently loaded record and in practice would be similar to:

$m_x = $m;
$m_x->unload();
$m_x->set($row);
$m_x->save();
return $m_x;

The main goal for insert() method is to be as fast as possible, while still performing data validation. After inserting method will return cloned model.

Model::import($data)

Similar to insert() however works across array of rows. This method will not return any IDs or models and is optimized for importing large amounts of data.

The method will still convert the data needed and operate with joined tables as needed. If you wish to access tables directly, you’ll have to look into Persistence::insert($m, $data, $table);

Working with selective fields

When you normally work with your model then all fields are available and will be loaded / saved. You may, however, specify that you wish to load only a sub-set of fields.

(In ATK4.3 we call those fields “Actual Fields”)

Model::onlyFields($fields)

Specify array of fields. Only those fields will be accessible and will be loaded / saved. Attempt to access any other field will result in exception.

Model::allFields()

Restore to full set of fields. This will also unload active record.

property Model::$only_fields

Contains list of fields to be loaded / accessed.

Setting and Getting active record data

When your record is loaded from database, record data is stored inside the $data property:

property Model::$data

Contains the data for an active record.

Model allows you to work with the data of single a record directly. You should use the following syntax when accessing fields of an active record:

$m['name'] = 'John';
$m['surname'] = 'Peter';

When you modify active record, it keeps the original value in the $dirty array:

Model::set()

Set field to a specified value. The original value will be stored in $dirty property. If you pass non-array, then the value will be assigned to the Title Field.

Model::unset()

Restore field value to it’s original:

$m['name'] = 'John';
echo $m['name']; // John

unset($m['name']);
echo $m['name']; // Original value is shown

This will restore original value of the field.

Model::get()

Returns one of the following:

  • If value was set() to the field, this value is returned
  • If field was loaded from database, return original value
  • if field had default set, returns default
  • returns null.
Model::isset()

Return true if field contains unsaved changes (dirty):

isset($m['name']); // returns false
$m['name'] = 'Other Name';
isset($m['name']); // returns true
Model::isDirty()

Return true if one or multiple fields contain unsaved changes (dirty):

if ($m->isDirty(['name','surname'])) {
   $m['full_name'] = $m['name'].' '.$m['surname'];
}

When the code above is placed in beforeSave hook, it will only be executed when certain fields have been changed. If your recalculations are expensive, it’s pretty handy to rely on “dirty” fields to avoid some complex logic.

property Model::$dirty

Contains list of modified fields since last loading and their original values.

Model::hasField($field)

Finds a field with a corresponding name. Returns false if field not found. Similar to hasElement() but with extra checks to make sure it’s certainly a field you are getting.

Model::getField($field)

Finds a field with a corresponding name. Throws exception if field not found. Similar to getElement() but with extra checks to make sure it’s certainly a field you are getting.

Full example:

$m = new Model_User($db, 'user');

// Fields can be added after model is created
$m->addField('salary', ['default'=>1000]);

echo isset($m['salary']);   // false
echo $m['salary'];          // 1000

// Next we load record from $db
$m->load(1);

echo $m['salary'];          // 2000 (from db)
echo isset($m['salary']);   // false, was not changed

$m['salary'] = 3000;

echo $m['salary'];          // 3000 (changed)
echo isset($m['salary']);   // true

unset($m['salary']);        // return to original value

echo $m['salary'];          // 2000
echo isset($m['salary']);   // false

$m['salary'] = 3000;
$m->save();

echo $m['salary'];          // 3000 (now in db)
echo isset($m['salary']);   // false
protected Model::normalizeFieldName()

Verify and convert first argument got get / set;

Title Field, ID Field and Model Caption

Those are three properties that you can specify in the model or pass it through defaults:

class MyModel ..
    public $title_field = 'full_name';

or as defaults:

$m = new MyModel($db, ['title_field'=>'full_name']);

ID Field

property Model::$id_field

If your data storage uses field different than id to keep the ID of your records, then you can specify that in $id_field property.

Tip

You can change ID value of the current ID field by calling:

$m['id'] = $new_id;
$m->save();

This will update existing record with new $id. If you want to save your current field over another existing record then:

$m->id = $new_id;
$m->save();

You must remember that only dirty fields are saved, though. (We might add replace() function though).

Title Field

property Model::$title_field

This field by default is set to ‘name’ will act as a primary title field of your table. This is especially handy if you use model inside UI framework, which can automatically display value of your title field in the header, or inside drop-down.

If you don’t have field ‘name’ but you want some other field to be title, you can specify that in the property. If title_field is not needed, set it to false or point towards a non-existent field.

See: :php:meth::hasOne::addTitle() and :php:meth::hasOne::withTitle()

public Model::getTitle()

Return title field value of currently loaded record.

public Model::getTitles()

Returns array of title field values of all model records in format [id => title].

Model Caption

property Model::$caption

This is caption of your model. You can use it in your UI components.

public Model::getModelCaption()

Returns model caption. If caption is not set, then try to generate one from model class name.

Setting limit and sort order

public Model::setLimit($count, $offset = null)

Sets limit on how many records to select. Will select only $count records starting from $offset record.

public Model::setOrder($field, $desc = null)

Sets sorting order of returned data records. Here are some usage examples. All these syntaxes work the same:

$m->setOrder('name, salary desc');
$m->setOrder(['name', 'salary desc']);
$m->setOrder(['name', 'salary'=>true]);
$m->setOrder(['name'=>false, 'salary'=>true]);
$m->setOrder([ ['name'], ['salary','desc'] ]);
$m->setOrder([ ['name'], ['salary',true] ]);
$m->setOrder([ ['name'], ['salary desc'] ]);
// and there can be many more similar combinations how to call this

Keep in mind - true means desc, desc means descending. Otherwise it will be ascending order by default.

You can also use atk4dsqlExpression or array of expressions instead of field name here. Or even mix them together:

$m->setOrder($m->expr('[net]*[vat]'));
$m->setOrder([$m->expr('[net]*[vat]'), $m->expr('[closing]-[opening]')]);
$m->setOrder(['net', $m->expr('[net]*[vat]', 'ref_no')]);