23 lines
675 B
PHP
23 lines
675 B
PHP
<?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');
|
|
}
|
|
}
|