Models and database

<?php
// src/Models/productos.php
Koshkil::Uses('sys.db.model');
Koshkil::UsesModel('categorias');

class TModelProductos extends TModel {

    protected $tableName = 'tbl_productos';
    public $primaryKeyColumn = 'prd_codigo';

    // Only these fields are assigned by create(), fill() and update()
    protected $fillable = ['cat_codigo', 'prd_nombre', 'prd_precio', 'prd_destacado', 'prd_alta', 'prd_datos'];

    protected $dates = ['prd_alta'];   // shown as dd/mm/yyyy and stored as yyyy-mm-dd
    protected $json  = ['prd_datos'];  // decoded to an array when read

    protected function setupTableStructure() {
        $this->table->id('prd_codigo')
            ->varchar('prd_nombre', 120, false, '')
            ->decimal('prd_precio', 10, 2, false, 0)
            ->enum('prd_destacado', ['0', '1'], false, '0')
            ->datetime('prd_alta')
            ->text('prd_datos')
            ->belongsTo('categorias')                  // adds cat_codigo + foreign key
            ->addKey('idx_prd_nombre', 'prd_nombre');
    }

    // Custom method: used as $producto->precioConIva()
    public function precioConIva() {
        return round($this->prd_precio * 1.21, 2);
    }
}

Koshkil::UsesModel('productos');            // includes the file and creates the TMProductos alias
Koshkil::UsesModel('noticias.noticias');    // a plugin's model -> TMNoticias

$this->table
    ->addKey('idx_email', 'usr_email')
    ->addKey('idx_composite', ['cat_codigo', 'prd_nombre'])
    ->engine('InnoDB')
    ->charset('utf8mb4')
    ->collate('utf8mb4_unicode_ci')
    ->initialRecords([
        ['cat_nombre' => 'General'],
        ['cat_nombre' => 'Offers'],
    ]);

// Create: returns the created record (with its primary key)
$producto = TMProductos::create([
    'prd_nombre' => 'Notebook 14"',
    'prd_precio' => 850000,
    'prd_alta'   => date('d/m/Y H:i:s'),
]);

// Read
$producto = TMProductos::find(15);                   // by primary key, or null
$producto->prd_nombre;                               // as a property
$producto['prd_nombre'];                             // or as an array
$producto->record();                                 // all fields as an array

// Update
$producto->fill(['prd_precio' => 799000])->update();
$producto->prd_destacado = '1';
$producto->update();

// Delete
$producto->delete();                                 // honors readOnly and behaviors
if ($categoria->canDelete()) {                       // does it have dependent records?
    $categoria->cascadeDelete();                     // deletes the dependants too
}

// Bulk operations (a single statement, no events)
TMProductos::updateAll(['prd_destacado' => '0'], ['cat_codigo' => 3]);
TMProductos::deleteAll(['cat_codigo' => [7, 8]]);    // an array becomes IN (…)

$list = TMProductos::where('prd_destacado', '1')
    ->where('prd_precio', '<', 100000)
    ->order('prd_nombre', 'ASC')
    ->take(12)
    ->get();                         // TCollection of TMProductos

foreach ($list as $producto) {
    echo $producto->prd_nombre;
}

$page  = TMProductos::order('prd_nombre')->pageSize(20)->page(2)->get();
$pages = ceil($page->totalRecords / 20);

TMUsuarios::where('usr_email', $this->Request->email)->first();          // escaped by where()
TMProductos::where('prd_nombre', 'like', "%{$this->Request->q}%")->get();
TMProductos::where('cat_codigo', [$a, $b, $c])->get();                    // every item is escaped

$q = Koshkil::escapeString($this->Request->q);
$qb->where("MATCH(prd_nombre) AGAINST ('{$q}')");
$qb->where("FIND_IN_SET(" . intval($this->Request->grupo) . ", prd_grupos)");
$qb->where('p.cat_codigo = ' . Koshkil::quote($this->Request->categoria));

// In TModelProductos: each product belongs to a category
$this->table->belongsTo('categorias');
// creates the cat_codigo column (integer, the categories primary key), its foreign
// key and the $producto->categoria() method (the model name in singular)

// In TModelCategorias: a category has many products
$this->table->hasMany('productos', ['foreignKey' => 'cat_codigo', 'virtualMethodName' => 'productos', 'orderBy' => ['prd_nombre' => 'ASC']]);

// One-to-one with extra conditions
$this->table->hasOne('galeria', [
    'foreignKey'        => 'gal_relacionado',
    'columnName'        => 'usr_codigo',
    'virtualMethodName' => 'imagenPerfil',
    'where'             => [['gal_grupo', 'usuarios'], ['gal_uso', 'profile']],
]);

$categoria = TMCategorias::find(3);
foreach ($categoria->productos() as $producto) { … }
$photo = $usuario->imagenPerfil();

class TModelProductos extends TModel {
    public function productos_event_precreate($record) {
        $record->prd_alta = date('d/m/Y H:i:s');
        return $record;
    }
}

Koshkil::uses('sys.db.traits.hierarchy');
Koshkil::uses('sys.db.traits.ownable');

class TModelCategorias extends TModel {
    use THierarchyTrait, TOwnableTrait;

    protected function setupTableStructure() {
        $this->parentField = 'cat_parent';     // the column is added by the trait
        $this->textField   = 'cat_nombre';
        $this->table->id('cat_codigo')->varchar('cat_nombre', 45, false, '');
    }
}

<?php
// src/Models/Behaviors/Publicable.php
Koshkil::uses('sys.db.behavior');

class PublicableBehavior extends Behavior {
    public function publicar() {
        $this->record->fill(['pub_estado' => '1'])->update();
    }
}

class TModelArticulos extends TModel {
    protected $behaviors = ['publicable'];
}

TMArticulos::find(4)->publicar();

<?php
// src/Migrations/20260425120000_create_personal_negocios_table.php
class Migration20260425120000 {
    public function up() {
        Koshkil::$db->execute("CREATE TABLE IF NOT EXISTS `tbl_personal_negocios` (…)");
    }
    public function down() {
        Koshkil::$db->execute("DROP TABLE IF EXISTS `tbl_personal_negocios`");
    }
}

$db = Koshkil::getDatabase();
$db->execute("UPDATE tbl_productos SET prd_precio = prd_precio * 1.1");
$row = $db->getRow("SELECT COUNT(*) AS total FROM tbl_productos");
$res = $db->getRecords("SELECT * FROM tbl_productos WHERE cat_codigo = 3"); // ['data' => […], 'records' => N]
$db->performTransaction([$sql1, $sql2]);
$db->escape($text);                   // with PDO the value comes back already quoted
Koshkil::escapeString($text);         // same with any driver, without quotes
Koshkil::quote($text);                // 'text'
$db->lastInsertId();