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) {
// Zmiana daty na polski format
$sql[$key]['date_add_rank'] = date('d.m.Y', strtotime($val['date_add_rank']));
}
}
return $sql;
}
public static function sqlGetAllItems($using_pages = false, $current_page = '1', $items_on_page = '5', $controller_search = '')
{
if ($sql = parent::sqlGetAllItems($using_pages, $current_page, $items_on_page, $controller_search)) {
foreach ($sql as $key => $val) {
// Nazwa statusu
$sql[$key]['active_name'] = ClassUser::getNameStatus($val['active']);
}
}
return $sql;
}
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;
}
public static function sqlGetAllItems($using_pages = false, $current_page = '1', $items_on_page = '5', $controller_search = '')
{
if ($sql = parent::sqlGetAllItems($using_pages, $current_page, $items_on_page, $controller_search)) {
foreach ($sql as $key => $val) {
// Rodzaj jednostki nazwa
$sql[$key]['equipment_type_name'] = ClassEquipmentType::sqlGetItemNameByIdParent($val['id_equipment_type']);
// Nazwa statusu
$sql[$key]['active_name'] = ClassUser::getNameStatus($val['active']);
}
}
return $sql;
}
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 kategorii prawa jazdy
$sql[$key]['drive_category_name'] = ClassDriveCategories::sqlGetItemNameByIdParent($val['id_drive_category']);
// Zmiana daty na polski format
$sql[$key]['date_start'] = date('d.m.Y', strtotime($val['date_start']));
$sql[$key]['date_end'] = date('d.m.Y', strtotime($val['date_end']));
}
}
return $sql;
}
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) {
// pobieranie typow adresow przypisanych do tego adresu
$sql[$key]['soldier_address_types'] = self::sqlGetAddresses2TypesByAddres($val['id_address']);
}
}
return $sql;
}
public static function sqlGetAllItems($using_pages = false, $current_page = '1', $items_on_page = '5', $controller_search = '')
{
if ($sql = parent::sqlGetAllItems($using_pages, $current_page, $items_on_page, $controller_search)) {
foreach ($sql as $key => $val) {
// $sql[$key]['mission_type_name'] = self::sqlGetTypeNameId($val['id_mission_type']);
$sql[$key]['mission_type_name'] = ClassMissionType::sqlGetItemNameByIdParent($val['id_mission_type']);
$sql[$key]['date_end_name'] = self::getDateEndNameByDateEnd($val['date_end']);
// $sql[$key]['status'] = self::getStatusName($val['date_end'], $val['active']);
$sql[$key]['status'] = self::getStatusMission($val['date_start'], $val['date_end']);
}
}
return $sql;
}
public static function sqlGetAllItems($using_pages = false, $current_page = '1', $items_on_page = '5', $controller_search = '')
{
if ($sql = parent::sqlGetAllItems($using_pages, $current_page, $items_on_page, $controller_search)) {
// ladowanie centrow szkolen
$training_centers = ClassTrainingCenter::sqlGetAllActiveItems(false);
foreach ($sql as $key => $val) {
// nazwa centrum szkolenia
$sql[$key]['training_center_name'] = $training_centers[$val['id_training_centre']]['name'] . ', ' . $training_centers[$val['id_training_centre']]['location'];
// nazwa lub data zakonczenia misji
$sql[$key]['date_end_name'] = self::getDateEndNameByDateEnd($val['date_end'], true);
// data rozpoczecia misji
$sql[$key]['date_start_name'] = self::getPlDate($val['date_start']);
// nazwa statusu
// $sql[$key]['status'] = self::getStatusName($val['date_end'], $val['active']);
$sql[$key]['status'] = self::getStatusTraining($val['date_start'], $val['date_end']);
}
}
return $sql;
}
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 statusu
$sql[$key]['status_name'] = ClassSoldierStatus::sqlGetItemNameByIdParent($val['id_status']);
}
}
return $sql;
}
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 tytulu zawodowego
$sql[$key]['academic_degree_name'] = ClassAcademicDegree::sqlGetItemNameByIdParent($val['id_academic_degree']);
// Zmiana daty na polski format
$sql[$key]['date_start'] = date('d.m.Y', strtotime($val['date_start']));
$sql[$key]['date_end'] = date('d.m.Y', strtotime($val['date_end']));
}
}
return $sql;
}