public static function sqlGetAllItems($using_pages = false, $current_page = '1', $items_on_page = '5', $controller_search = '', array $custom_where = array())
{
if ($sql = parent::sqlGetAllItems($using_pages, $current_page, $items_on_page, $controller_search, $custom_where)) {
foreach ($sql as $key => $val) {
// nazwa stopnia zaawansowania jezyka
$sql[$key]['language_level_name'] = ClassLanguageLevel::sqlGetItemNameByIdParent($val['id_language_level']);
}
}
return $sql;
}
protected function getPageList($item)
{
$this->actions();
// strony
$this->controller_name = 'jezyki';
$this->using_pages = true;
$this->count_items = ClassSoldierLanguage::sqlGetCountItems('', array('id_soldier' => $item->id));
$this->current_page = ClassTools::getValue('number_page') ? ClassTools::getValue('number_page') : '1';
// tytul strony
$this->tpl_title = "{$item->name} {$item->surname}: Języki";
// ladowanie funkcji
$this->load_select2 = true;
$this->load_js_functions = true;
// pobieranie wszystkich rekordow
$this->tpl_values['items'] = ClassSoldierLanguage::sqlGetAllItems($this->using_pages, $this->current_page, $this->items_on_page, '', array('id_soldier' => $item->id));
$this->tpl_values['id_soldier'] = $item->id;
// pobieranie statusow zaawansowania jezyka
$this->tpl_values['language_levels'] = ClassLanguageLevel::getAllItemsNameWhithChild();
// ladowanie strony z lista
return $this->loadTemplate('/soldier/languages');
}
