ReadServiceDatabaseReader
in package
implements
ReadServiceDatabaseReaderInterface
Class ReadServiceDatabaseReader
Interfaces, Classes and Traits
- ReadServiceDatabaseReaderInterface
- Interface ReadServiceDatabaseReaderInterface
Table of Contents
- ATTRIBUTE_ID_COLUMN = 'products_attributes_id'
- IMAGE_LIST_ATTRIBUTE_TABLE_NAME = 'product_image_list_attribute'
- IMAGE_LIST_COMBI_TABLE_NAME = 'product_image_list_combi'
- IMAGE_LIST_IMAGE_TABLE_NAME = 'product_image_list_image'
- IMAGE_LIST_IMAGE_TEXT_TABLE_NAME = 'product_image_list_image_text'
- IMAGE_LIST_TABLE_NAME = 'product_image_list'
- LANGUAGE_ID_COLUMN = 'language_id'
- LIST_ID_COLUMN = 'product_image_list_id'
- LIST_IMAGE_ID_COLUMN = 'product_image_list_image_id'
- LIST_IMAGE_LOCAL_PATH_COLUMN = 'product_image_list_image_local_path'
- LIST_IMAGE_SORT_ORDER_COLUMN = 'product_image_list_image_sort_order'
- LIST_IMAGE_TEXT_TYPE_COLUMN = 'product_image_list_image_text_type'
- LIST_IMAGE_TEXT_VALUE_COLUMN = 'product_image_list_image_text_value'
- LIST_NAME_COLUMN = 'product_image_list_name'
- PROPERTY_COMBI_ID_COLUMN = 'products_properties_combis_id'
- PROPERTY_COMBI_MODEL_COLUMN = 'combi_model'
- PROPERTY_COMBI_PRODUCTS_ID_COLUMN = 'products_id'
- PROPERTY_COMBINATION_TABLE_NAME = 'products_properties_combis'
- $queryBuilder : CI_DB_query_builder
- __construct() : mixed
- ReadServiceDatabaseReader constructor.
- getImageListById() : array<string|int, ImageListDtoInterface>
- getImageListIdByAttributeId() : int
- getImageListIdByCombiId() : int
- getImageListIdByCombiModelAndProductsId() : int
- getImageLists() : array<string|int, ImageListDtoInterface>
- getImages() : array<string|int, ImageListImageDtoInterface>
- getImagesByListId() : array<string|int, ImageListImageDtoInterface>
- getImageTexts() : array<string|int, ImageListImageTextDtoInterface>
- getImageTextsByListId() : array<string|int, ImageListImageTextDtoInterface>
- createImageListDto() : ImageListDtoInterface
- createListImageDto() : ImageListImageDtoInterface
- createListImageTextDto() : ImageListImageTextDtoInterface
- getTexts() : array<string|int, mixed>
Constants
ATTRIBUTE_ID_COLUMN
protected
mixed
ATTRIBUTE_ID_COLUMN
= 'products_attributes_id'
IMAGE_LIST_ATTRIBUTE_TABLE_NAME
protected
mixed
IMAGE_LIST_ATTRIBUTE_TABLE_NAME
= 'product_image_list_attribute'
IMAGE_LIST_COMBI_TABLE_NAME
protected
mixed
IMAGE_LIST_COMBI_TABLE_NAME
= 'product_image_list_combi'
IMAGE_LIST_IMAGE_TABLE_NAME
protected
mixed
IMAGE_LIST_IMAGE_TABLE_NAME
= 'product_image_list_image'
IMAGE_LIST_IMAGE_TEXT_TABLE_NAME
protected
mixed
IMAGE_LIST_IMAGE_TEXT_TABLE_NAME
= 'product_image_list_image_text'
IMAGE_LIST_TABLE_NAME
protected
mixed
IMAGE_LIST_TABLE_NAME
= 'product_image_list'
LANGUAGE_ID_COLUMN
protected
mixed
LANGUAGE_ID_COLUMN
= 'language_id'
LIST_ID_COLUMN
protected
mixed
LIST_ID_COLUMN
= 'product_image_list_id'
LIST_IMAGE_ID_COLUMN
protected
mixed
LIST_IMAGE_ID_COLUMN
= 'product_image_list_image_id'
LIST_IMAGE_LOCAL_PATH_COLUMN
protected
mixed
LIST_IMAGE_LOCAL_PATH_COLUMN
= 'product_image_list_image_local_path'
LIST_IMAGE_SORT_ORDER_COLUMN
protected
mixed
LIST_IMAGE_SORT_ORDER_COLUMN
= 'product_image_list_image_sort_order'
LIST_IMAGE_TEXT_TYPE_COLUMN
protected
mixed
LIST_IMAGE_TEXT_TYPE_COLUMN
= 'product_image_list_image_text_type'
LIST_IMAGE_TEXT_VALUE_COLUMN
protected
mixed
LIST_IMAGE_TEXT_VALUE_COLUMN
= 'product_image_list_image_text_value'
LIST_NAME_COLUMN
protected
mixed
LIST_NAME_COLUMN
= 'product_image_list_name'
PROPERTY_COMBI_ID_COLUMN
protected
mixed
PROPERTY_COMBI_ID_COLUMN
= 'products_properties_combis_id'
PROPERTY_COMBI_MODEL_COLUMN
protected
mixed
PROPERTY_COMBI_MODEL_COLUMN
= 'combi_model'
PROPERTY_COMBI_PRODUCTS_ID_COLUMN
protected
mixed
PROPERTY_COMBI_PRODUCTS_ID_COLUMN
= 'products_id'
PROPERTY_COMBINATION_TABLE_NAME
protected
mixed
PROPERTY_COMBINATION_TABLE_NAME
= 'products_properties_combis'
Properties
$queryBuilder
protected
CI_DB_query_builder
$queryBuilder
Methods
__construct()
ReadServiceDatabaseReader constructor.
public
__construct(CI_DB_query_builder $queryBuilder) : mixed
Parameters
- $queryBuilder : CI_DB_query_builder
Return values
mixed —getImageListById()
public
getImageListById(int $id) : array<string|int, ImageListDtoInterface>
Parameters
- $id : int
Tags
Return values
array<string|int, ImageListDtoInterface> —getImageListIdByAttributeId()
public
getImageListIdByAttributeId(AttributeIdDtoInterface $dto) : int
Parameters
- $dto : AttributeIdDtoInterface
Tags
Return values
int —getImageListIdByCombiId()
public
getImageListIdByCombiId(PropertiesCombisIdDtoInterface $dto) : int
Parameters
Tags
Return values
int —getImageListIdByCombiModelAndProductsId()
public
getImageListIdByCombiModelAndProductsId(CombiModelAndProductsIdDtoInterface $dto) : int
Parameters
Tags
Return values
int —getImageLists()
public
getImageLists([int $listId = null ]) : array<string|int, ImageListDtoInterface>
Parameters
- $listId : int = null
Tags
Return values
array<string|int, ImageListDtoInterface> —getImages()
public
getImages([int $listId = null ]) : array<string|int, ImageListImageDtoInterface>
Parameters
- $listId : int = null
Tags
Return values
array<string|int, ImageListImageDtoInterface> —getImagesByListId()
public
getImagesByListId(int $listId) : array<string|int, ImageListImageDtoInterface>
Parameters
- $listId : int
Tags
Return values
array<string|int, ImageListImageDtoInterface> —getImageTexts()
public
getImageTexts() : array<string|int, ImageListImageTextDtoInterface>
Tags
Return values
array<string|int, ImageListImageTextDtoInterface> —getImageTextsByListId()
public
getImageTextsByListId(int $listId) : array<string|int, ImageListImageTextDtoInterface>
Parameters
- $listId : int
Tags
Return values
array<string|int, ImageListImageTextDtoInterface> —createImageListDto()
protected
createImageListDto(int $listId, string $listName) : ImageListDtoInterface
Parameters
- $listId : int
- $listName : string
Return values
ImageListDtoInterface —createListImageDto()
protected
createListImageDto(int $imageId, int $listId, string $localPath, int $sortOder) : ImageListImageDtoInterface
Parameters
- $imageId : int
- $listId : int
- $localPath : string
- $sortOder : int
Return values
ImageListImageDtoInterface —createListImageTextDto()
protected
createListImageTextDto(int $imageId, string $textType, string $textValue, int $languageId) : ImageListImageTextDtoInterface
Parameters
- $imageId : int
- $textType : string
- $textValue : string
- $languageId : int
Return values
ImageListImageTextDtoInterface —getTexts()
protected
getTexts([ $lists = [] ]) : array<string|int, mixed>