28 lines
670 B
PHP
28 lines
670 B
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use CodeIgniter\Model;
|
|
|
|
class ReceiptItemModel extends Model
|
|
{
|
|
protected $table = 'receipt_items';
|
|
protected $primaryKey = 'id';
|
|
protected $returnType = 'array';
|
|
protected $useTimestamps = true;
|
|
protected $allowedFields = [
|
|
'receipt_id', 'name', 'display_name', 'qty', 'amount',
|
|
'suggested_category_id', 'chosen_category_id',
|
|
];
|
|
|
|
/**
|
|
* Pozycje danego paragonu w kolejnosci wprowadzenia.
|
|
*/
|
|
public function forReceipt(int $receiptId): array
|
|
{
|
|
return $this->where('receipt_id', $receiptId)
|
|
->orderBy('id', 'ASC')
|
|
->findAll();
|
|
}
|
|
}
|