Class ProductsService

new ProductsService(prisma: PrismaService): ProductsService

bulkUpdateIndividualPrices(
    userId: string,
    userRole: user_role,
    updates: { newPrice: number; productId: string }[],
): Promise<
    | {
        error?: undefined;
        message: string;
        results: any[];
        success: boolean;
    }
    | { error: any; message?: undefined; results: any[]; success: boolean },
>

bulkUpdateIndividualStock(
    userId: string,
    userRole: user_role,
    updates: { newStock: number; productId: string }[],
): Promise<
    | {
        error?: undefined;
        message: string;
        results: any[];
        success: boolean;
    }
    | { error: any; message?: undefined; results: any[]; success: boolean },
>

createProduct(
    userId: string,
    userRole: user_role,
    createProductDto: CreateProductDto,
): Promise<
    {
        category: {
            description: string;
            id: string;
            name: string;
            slug: string;
        };
        retailer: {
            businessName: string;
            email: string;
            fullName: string;
            id: string;
        };
        subcategory: {
            description: string;
            id: string;
            name: string;
            slug: string;
        };
    } & {
        categoryId: string;
        createdAt: Date;
        createdByRole: user_role;
        currency: string;
        description: string;
        id: string;
        imageUrl: string;
        isActive: boolean;
        manufacturerId: string;
        name: string;
        price: Decimal;
        qcStatus: string;
        retailerId: string;
        sku: string;
        stockQuantity: number;
        subcategoryId: string;
        tags: string[];
        updatedAt: Date;
    },
>

deleteProduct(
    id: string,
    userId: string,
    userRole: user_role,
): Promise<
    {
        categoryId: string;
        createdAt: Date;
        createdByRole: user_role;
        currency: string;
        description: string;
        id: string;
        imageUrl: string;
        isActive: boolean;
        manufacturerId: string;
        name: string;
        price: Decimal;
        qcStatus: string;
        retailerId: string;
        sku: string;
        stockQuantity: number;
        subcategoryId: string;
        tags: string[];
        updatedAt: Date;
    },
>

getAllProducts(
    categoryId?: string,
    isActive?: boolean,
): Promise<
    (
        {
            category: {
                description: string;
                id: string;
                name: string;
                slug: string;
            };
            retailer: {
                businessName: string;
                email: string;
                fullName: string;
                id: string;
            };
            subcategory: {
                description: string;
                id: string;
                name: string;
                slug: string;
            };
        } & {
            categoryId: string;
            createdAt: Date;
            createdByRole: user_role;
            currency: string;
            description: string;
            id: string;
            imageUrl: string;
            isActive: boolean;
            manufacturerId: string;
            name: string;
            price: Decimal;
            qcStatus: string;
            retailerId: string;
            sku: string;
            stockQuantity: number;
            subcategoryId: string;
            tags: string[];
            updatedAt: Date;
        }
    )[],
>

getLowStockProducts(
    threshold?: number,
): Promise<
    (
        {
            category: {
                description: string;
                id: string;
                name: string;
                slug: string;
            };
            retailer: {
                businessName: string;
                email: string;
                fullName: string;
                id: string;
            };
            subcategory: {
                description: string;
                id: string;
                name: string;
                slug: string;
            };
        } & {
            categoryId: string;
            createdAt: Date;
            createdByRole: user_role;
            currency: string;
            description: string;
            id: string;
            imageUrl: string;
            isActive: boolean;
            manufacturerId: string;
            name: string;
            price: Decimal;
            qcStatus: string;
            retailerId: string;
            sku: string;
            stockQuantity: number;
            subcategoryId: string;
            tags: string[];
            updatedAt: Date;
        }
    )[],
>

getProductById(
    id: string,
): Promise<
    {
        category: {
            description: string;
            id: string;
            name: string;
            slug: string;
        };
        retailer: {
            businessName: string;
            email: string;
            fullName: string;
            id: string;
        };
        subcategory: {
            description: string;
            id: string;
            name: string;
            slug: string;
        };
    } & {
        categoryId: string;
        createdAt: Date;
        createdByRole: user_role;
        currency: string;
        description: string;
        id: string;
        imageUrl: string;
        isActive: boolean;
        manufacturerId: string;
        name: string;
        price: Decimal;
        qcStatus: string;
        retailerId: string;
        sku: string;
        stockQuantity: number;
        subcategoryId: string;
        tags: string[];
        updatedAt: Date;
    },
>

getProductCategories(): Promise<
    {
        children: {
            id: string;
            level: number;
            name: string;
            position: number;
            slug: string;
        }[];
        createdAt: Date;
        description: string;
        id: string;
        imageUrl: string;
        isActive: boolean;
        level: number;
        name: string;
        parent: { id: string; name: string; slug: string };
        parentId: string;
        position: number;
        slug: string;
        updatedAt: Date;
    }[],
>

getProductCategoryById(
    id: string,
): Promise<
    {
        children: {
            description: string;
            id: string;
            imageUrl: string;
            level: number;
            name: string;
            position: number;
            slug: string;
        }[];
        createdAt: Date;
        description: string;
        id: string;
        imageUrl: string;
        isActive: boolean;
        level: number;
        name: string;
        parent: { description: string; id: string; name: string; slug: string };
        parentId: string;
        position: number;
        products: {
            id: string;
            imageUrl: string;
            isActive: boolean;
            name: string;
            price: Decimal;
        }[];
        slug: string;
        updatedAt: Date;
    },
>

getProductsByCategory(
    categoryId: string,
): Promise<
    (
        {
            category: {
                description: string;
                id: string;
                name: string;
                slug: string;
            };
            retailer: {
                businessName: string;
                email: string;
                fullName: string;
                id: string;
            };
            subcategory: {
                description: string;
                id: string;
                name: string;
                slug: string;
            };
        } & {
            categoryId: string;
            createdAt: Date;
            createdByRole: user_role;
            currency: string;
            description: string;
            id: string;
            imageUrl: string;
            isActive: boolean;
            manufacturerId: string;
            name: string;
            price: Decimal;
            qcStatus: string;
            retailerId: string;
            sku: string;
            stockQuantity: number;
            subcategoryId: string;
            tags: string[];
            updatedAt: Date;
        }
    )[],
>

getProductsByManufacturer(
    manufacturerId: string,
): Promise<
    (
        {
            category: {
                description: string;
                id: string;
                name: string;
                slug: string;
            };
            retailer: {
                businessName: string;
                email: string;
                fullName: string;
                id: string;
            };
            subcategory: {
                description: string;
                id: string;
                name: string;
                slug: string;
            };
        } & {
            categoryId: string;
            createdAt: Date;
            createdByRole: user_role;
            currency: string;
            description: string;
            id: string;
            imageUrl: string;
            isActive: boolean;
            manufacturerId: string;
            name: string;
            price: Decimal;
            qcStatus: string;
            retailerId: string;
            sku: string;
            stockQuantity: number;
            subcategoryId: string;
            tags: string[];
            updatedAt: Date;
        }
    )[],
>

getTopSellingProducts(
    limit?: number,
): Promise<
    {
        category: {
            description: string;
            id: string;
            name: string;
            slug: string;
        };
        categoryId: string;
        createdAt: Date;
        createdByRole: user_role;
        currency: string;
        description: string;
        id: string;
        imageUrl: string;
        isActive: boolean;
        manufacturerId: string;
        name: string;
        price: Decimal;
        qcStatus: string;
        retailer: {
            businessName: string;
            email: string;
            fullName: string;
            id: string;
        };
        retailerId: string;
        salesData: {
            orderCount: number;
            totalQuantitySold: number;
            totalRevenue: number
            | Decimal;
        };
        sku: string;
        stockQuantity: number;
        subcategoryId: string;
        tags: string[];
        updatedAt: Date;
    }[],
>

getUserProducts(
    userId: string,
): Promise<
    (
        {
            category: {
                description: string;
                id: string;
                name: string;
                slug: string;
            };
            retailer: {
                businessName: string;
                email: string;
                fullName: string;
                id: string;
            };
            subcategory: {
                description: string;
                id: string;
                name: string;
                slug: string;
            };
        } & {
            categoryId: string;
            createdAt: Date;
            createdByRole: user_role;
            currency: string;
            description: string;
            id: string;
            imageUrl: string;
            isActive: boolean;
            manufacturerId: string;
            name: string;
            price: Decimal;
            qcStatus: string;
            retailerId: string;
            sku: string;
            stockQuantity: number;
            subcategoryId: string;
            tags: string[];
            updatedAt: Date;
        }
    )[],
>

searchProducts(
    query: string,
): Promise<
    (
        {
            category: {
                description: string;
                id: string;
                name: string;
                slug: string;
            };
            retailer: {
                businessName: string;
                email: string;
                fullName: string;
                id: string;
            };
            subcategory: {
                description: string;
                id: string;
                name: string;
                slug: string;
            };
        } & {
            categoryId: string;
            createdAt: Date;
            createdByRole: user_role;
            currency: string;
            description: string;
            id: string;
            imageUrl: string;
            isActive: boolean;
            manufacturerId: string;
            name: string;
            price: Decimal;
            qcStatus: string;
            retailerId: string;
            sku: string;
            stockQuantity: number;
            subcategoryId: string;
            tags: string[];
            updatedAt: Date;
        }
    )[],
>

updateProduct(
    id: string,
    userId: string,
    userRole: user_role,
    updateProductDto: UpdateProductDto,
): Promise<
    {
        category: {
            description: string;
            id: string;
            name: string;
            slug: string;
        };
        retailer: {
            businessName: string;
            email: string;
            fullName: string;
            id: string;
        };
        subcategory: {
            description: string;
            id: string;
            name: string;
            slug: string;
        };
    } & {
        categoryId: string;
        createdAt: Date;
        createdByRole: user_role;
        currency: string;
        description: string;
        id: string;
        imageUrl: string;
        isActive: boolean;
        manufacturerId: string;
        name: string;
        price: Decimal;
        qcStatus: string;
        retailerId: string;
        sku: string;
        stockQuantity: number;
        subcategoryId: string;
        tags: string[];
        updatedAt: Date;
    },
>

updateQcStatus(
    id: string,
    userId: string,
    userRole: user_role,
    qcStatus: string,
): Promise<
    {
        categoryId: string;
        createdAt: Date;
        createdByRole: user_role;
        currency: string;
        description: string;
        id: string;
        imageUrl: string;
        isActive: boolean;
        manufacturerId: string;
        name: string;
        price: Decimal;
        qcStatus: string;
        retailerId: string;
        sku: string;
        stockQuantity: number;
        subcategoryId: string;
        tags: string[];
        updatedAt: Date;
    },
>

updateStockQuantity(
    id: string,
    userId: string,
    userRole: user_role,
    quantity: number,
): Promise<
    {
        categoryId: string;
        createdAt: Date;
        createdByRole: user_role;
        currency: string;
        description: string;
        id: string;
        imageUrl: string;
        isActive: boolean;
        manufacturerId: string;
        name: string;
        price: Decimal;
        qcStatus: string;
        retailerId: string;
        sku: string;
        stockQuantity: number;
        subcategoryId: string;
        tags: string[];
        updatedAt: Date;
    },
>