<?php

declare(strict_types=1);

namespace KupShop\StoresBundle\Utils;

use Query\QueryBuilder;

class StoreMissingVariations
{
    public function getQuery(): QueryBuilder
    {
        return sqlQueryBuilder()
            ->select('si.id_product, p.code, si.quantity, p.title, s.name')
            ->from('stores_items', 'si')
            ->innerJoin('si', 'products_variations', 'pv', 'pv.id_product = si.id_product')
            ->innerJoin('pv', 'stores', 's', 'si.id_store = s.id')
            ->innerJoin('pv', 'products', 'p', 'pv.id_product = p.id')
            ->where('si.id_variation IS NULL AND si.quantity >= 0')
            ->groupBy('pv.id_product');
    }
}