|
<?php defined('SYSPATH') or die('No direct script access.');
|
|
/*
|
|
* This file is part of open source system FreeNetIS
|
|
* and it is release under GPLv3 licence.
|
|
*
|
|
* More info about licence can be found:
|
|
* http://www.gnu.org/licenses/gpl-3.0.html
|
|
*
|
|
* More info about project can be found:
|
|
* http://www.freenetis.org/
|
|
*
|
|
*/
|
|
|
|
/**
|
|
* @package Model
|
|
*/
|
|
class Invoice_template_Model extends ORM {
|
|
|
|
/**
|
|
* Function to get all invoice templates
|
|
*
|
|
* @author Michal Kliment
|
|
* @return unknown_type
|
|
*/
|
|
public function get_all_invoice_templates()
|
|
{
|
|
return $this->db->query("
|
|
SELECT it.id, IFNULL(t.translated_term, it.name) as name
|
|
FROM invoice_templates it
|
|
LEFT JOIN translations t ON it.name = t.original_term
|
|
");
|
|
}
|
|
|
|
}
|