Class: ProductCategoryRepository

backend.ProductCategoryRepository

Hierarchy

• TreeRepository<ProductCategory>

  ↳ ProductCategoryRepository

Table of contents

Constructors

• constructor

Properties

• dbType

Methods

• applyBaseFilter
• applyCategoryFilter
• applyGetEntityViews
• createProductCategory
• deleteManyCategories
• deleteProductCategory
• getCategoriesOfProduct
• getChildCategories
• getEntityViews
• getFilteredCategories
• getNestedLevel
• getParentCategory
• getProductCategories
• getProductCategoriesById
• getProductCategoryById
• getProductCategoryBySlug
• getRootCategories
• getSqlBoolStr
• getSqlLike
• handleProductCategoryInput
• quote
• updateProductCategory

Constructors

constructor

• new ProductCategoryRepository()

Overrides

TreeRepository<ProductCategory\>.constructor

Defined in

system/core/backend/src/repositories/product-category.repository.ts:51

Properties

dbType

• dbType: "mysql" | "mariadb" | "postgres" | "cockroachdb" | "sqlite" | "mssql" | "sap" | "oracle" | "cordova" | "nativescript" | "react-native" | "sqljs" | "mongodb" | "aurora-data-api" | "aurora-data-api-pg" | "expo" | "better-sqlite3" | "capacitor"

Defined in

system/core/backend/src/repositories/product-category.repository.ts:49

Methods

applyBaseFilter

▸ applyBaseFilter(qb, filter?): SelectQueryBuilder<TBasePageEntity>

Parameters

Name	Type
qb	SelectQueryBuilder<TBasePageEntity>
filter?	BaseFilterInput

Returns

SelectQueryBuilder<TBasePageEntity>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:218

---

applyCategoryFilter

▸ applyCategoryFilter(qb, filterParams?): void

Parameters

Name	Type
qb	SelectQueryBuilder<ProductCategory>
filterParams?	ProductCategoryFilterInput

Returns

void

Defined in

system/core/backend/src/repositories/product-category.repository.ts:225

---

applyGetEntityViews

▸ applyGetEntityViews(qb, entityType): SelectQueryBuilder<TBasePageEntity>

Parameters

Name	Type
qb	SelectQueryBuilder<TBasePageEntity>
entityType	EDBEntity

Returns

SelectQueryBuilder<TBasePageEntity>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:252

---

createProductCategory

▸ createProductCategory(createProductCategory, id?): Promise<ProductCategory>

Parameters

Name	Type
createProductCategory	CreateProductCategory
id?	null | number

Returns

Promise<ProductCategory>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:115

---

deleteManyCategories

▸ deleteManyCategories(input, filterParams?): Promise<boolean>

Parameters

Name	Type
input	TDeleteManyInput
filterParams?	ProductCategoryFilterInput

Returns

Promise<boolean>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:152

---

deleteProductCategory

▸ deleteProductCategory(id): Promise<boolean>

Parameters

Name	Type
id	number

Returns

Promise<boolean>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:135

---

getCategoriesOfProduct

▸ getCategoriesOfProduct(productId, params?): Promise<TProductCategory[]>

Parameters

Name	Type
productId	number
params?	TPagedParams<TProductCategory>

Returns

Promise<TProductCategory[]>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:178

---

getChildCategories

▸ getChildCategories(category): Promise<ProductCategory[]>

Parameters

Name	Type
category	ProductCategory

Returns

Promise<ProductCategory[]>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:188

---

getEntityViews

▸ getEntityViews(entityId, entityType): Promise<any>

Parameters

Name	Type
entityId	number
entityType	EDBEntity

Returns

Promise<any>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:256

---

getFilteredCategories

▸ getFilteredCategories(pagedParams?, filterParams?): Promise<TPagedList<TProductCategory>>

Parameters

Name	Type
pagedParams?	PagedParamsInput<ProductCategory>
filterParams?	ProductCategoryFilterInput

Returns

Promise<TPagedList<TProductCategory>>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:244

---

getNestedLevel

▸ getNestedLevel(category): Promise<number>

Parameters

Name	Type
category	ProductCategory

Returns

Promise<number>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:260

---

getParentCategory

▸ getParentCategory(category): Promise<undefined | null | ProductCategory>

Parameters

Name	Type
category	ProductCategory

Returns

Promise<undefined | null | ProductCategory>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:193

---

getProductCategories

▸ getProductCategories(params): Promise<TPagedList<TProductCategory>>

Parameters

Name	Type
params	TPagedParams<TProductCategory>

Returns

Promise<TPagedList<TProductCategory>>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:61

---

getProductCategoriesById

▸ getProductCategoriesById(ids): Promise<ProductCategory[]>

Parameters

Name	Type
ids	number[]

Returns

Promise<ProductCategory[]>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:68

---

getProductCategoryById

▸ getProductCategoryById(id): Promise<ProductCategory>

Parameters

Name	Type
id	number

Returns

Promise<ProductCategory>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:73

---

getProductCategoryBySlug

▸ getProductCategoryBySlug(slug): Promise<ProductCategory>

Parameters

Name	Type
slug	string

Returns

Promise<ProductCategory>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:82

---

getRootCategories

▸ getRootCategories(): Promise<TPagedList<ProductCategory>>

Returns

Promise<TPagedList<ProductCategory>>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:198

---

getSqlBoolStr

▸ getSqlBoolStr(b): "true" | "false" | "1" | "0"

Parameters

Name	Type
b	boolean

Returns

"true" | "false" | "1" | "0"

Defined in

system/core/backend/src/repositories/product-category.repository.ts:57

---

getSqlLike

▸ getSqlLike(): "ILIKE" | "LIKE"

Returns

"ILIKE" | "LIKE"

Defined in

system/core/backend/src/repositories/product-category.repository.ts:58

---

handleProductCategoryInput

▸ handleProductCategoryInput(productCategory, input, action): Promise<void>

Parameters

Name	Type
productCategory	ProductCategory
input	TProductCategoryInput
action	"update" | "create"

Returns

Promise<void>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:91

---

quote

▸ quote(str): string

Parameters

Name	Type
str	string

Returns

string

Defined in

system/core/backend/src/repositories/product-category.repository.ts:59

---

updateProductCategory

▸ updateProductCategory(id, updateProductCategory): Promise<ProductCategory>

Parameters

Name	Type
id	number
updateProductCategory	UpdateProductCategory

Returns

Promise<ProductCategory>

Defined in

system/core/backend/src/repositories/product-category.repository.ts:125