Public Member Functions
	install (bool $maintenance=false)
	Fuehrt die explizite Schema- und Defaultpflege aus.
	seedDemoProducts ()
	needsDemoSeed ()
	Schneller Seed-Check ohne Produktdekoration und N+1-Abfragen.
	attributeDefinitionsForGroup (int $groupId, bool $activeOnly=true)
	attributeDefinitionsForProduct (int $productId, bool $activeOnly=true)
	attributesForProduct (int $productId)
	allAttributeDefinitions ()
	attributeFilterDefinitions ()
	saveAttributeDefinition (array $data)
	saveProductAttributeValue (int $productId, int $attributeId, string $value)
	saveProductAttributeValues (int $productId, array $values)
	products (bool $activeOnly=true)
	catalogCandidates (string $channelKey='shop')
	Liefert leichte, gebuendelt angereicherte Katalogzeilen.
	productsByIds (array $ids)
	Dekoriert nur die vom Report tatsaechlich sichtbaren Artikel.
	productBySku (string $sku, bool $activeOnly=true)
	productById (int $id)
	groupById (int $id)
	stockIssuesForItems (array $items)
	deleteProducts (array $ids)
	addChannelToProducts (array $ids, string $channelKey)
	removeChannelFromProducts (array $ids, string $channelKey)
	setProductGroupForProducts (array $ids, int $groupId)
	groupsForProduct (int $productId)
	channelsForProduct (int $productId)
	productChannelOverrides (int $productId)
	inheritedChannelsForProduct (int $productId)
	saveProductChannelOverrides (int $productId, array $activeChannelKeys)
	shippingGroupsForProduct (int $productId)
	channelGroupsForProduct (int $productId)
	groups ()
	groupsByParent (int $parentId=0, bool $activeOnly=true)
	groupPath (int $groupId)
	moveProductGroupParent (int $groupId, int $parentId)
	channels ()
	channelById (int $id)
	channelByKey (string $key)
	updateChannel (int $id, array $data)
	deleteChannel (int $id)
	testChannelConnection (int $id)
	productChannelMapping (int $productId, string $channelKey)
	saveProductChannelMapping (int $productId, string $channelKey, array $data)
	exportProductToChannel (int $productId, string $channelKey)
	exportProductsToChannel (array $ids, string $channelKey)
	shippingGroups ()
	channelGroups ()
	channelsForChannelGroup (int $channelGroupId)
	updateProductGroup (int $id, array $data)
	updateShippingGroup (int $id, array $data)
	updateChannelGroup (int $id, array $data, array $channelKeys)
	deleteChannelGroup (int $id)
	deleteProductGroup (int $id)
	deleteShippingGroup (int $id)
	imagesForProduct (int $productId, array $groups=array())
	productImageCounts ()
	allImages ()
	updateImageMediaReference (int $imageId, int $mediaId, string $imagePath='')
	saveImage (int $productId, int $groupId, string $imagePath, string $title, string $alt, int $isPrimary=0, int $sorter=100)
	saveMediaImage (int $productId, int $groupId, int $mediaId, string $title='', string $alt='', int $isPrimary=0, int $sorter=100)
	primaryImageForGroup (int $groupId)
	removeProductImageAssociation (int $imageId, int $productId=0)
	createOrderFromItems (array $items, string $channelKey='shop', string $customerName='', string $customerEmail='', string $note='', string $paymentProvider='', string $paymentStatus='open', string $status='payment_pending', string $customerPhone='', string $shippingAddress='', string $legalSnapshot='', string $withdrawalSnapshot='')
	importChannelOrder (string $channelKey, array $payload)
	orderByNo (string $orderNo)
	orderById (int $id)
	ordersByUid (int $uid, int $limit=25)
	orders (array $filters=array(), int $limit=50, int $offset=0, string $sort='create_date', string $direction='DESC')
	orderCount (array $filters=array())
	orderChannelKeys ()
	updateOrderAdmin (int $id, array $data)
	updateOrderQuickAction (int $id, string $action)
	deleteOrder (int $id)
	orderByPaymentReference (string $provider, string $reference)
	orderItems (int $orderId)
	claimOrderPayment (int $orderId, string $provider, string $reference)
	Beansprucht einen Provider-Abschluss atomar.
	updateOrderPayment (int $orderId, string $provider, string $status, string $reference='', array $payload=array())
	Aktualisiert den Zahlungsstatus idempotent und verhindert Downgrades terminaler Zahlungen sowie Referenz-/Providerwechsel.
	addOrderHistory (int $orderId, string $eventType, string $oldValue='', string $newValue='', string $message='')
	orderHistory (int $orderId)
	hasOrderHistoryEvent (int $orderId, string $eventType, string $newValue='')
	nextInvoiceNo ()
	ensureOrderInvoicePdf (int $id)
	invoicePdfAbsolutePath (array $order)
	saveWithdrawal (array $data)
	updateWithdrawalAdmin (int $id, string $status, string $note='')
	withdrawalById (int $id)
	withdrawals (array $filters=array(), int $limit=50, int $offset=0)
	withdrawalCount (array $filters=array())
	withdrawalsForOrder (int $orderId)
	dashboardStats ()

Detailed Description

Definition at line 4 of file dbxShopRepository.class.php.

Member Function Documentation

◆ addChannelToProducts()

dbx\dbxShop\dbxShopRepository::addChannelToProducts	(	array	$ids,
		string	$channelKey )

Definition at line 1472 of file dbxShopRepository.class.php.

References install().

◆ addOrderHistory()

dbx\dbxShop\dbxShopRepository::addOrderHistory	(	int	$orderId,
		string	$eventType,
		string	$oldValue = '',
		string	$newValue = '',
		string	$message = '' )

Definition at line 3530 of file dbxShopRepository.class.php.

References if.

◆ allAttributeDefinitions()

dbx\dbxShop\dbxShopRepository::allAttributeDefinitions ( )

Definition at line 439 of file dbxShopRepository.class.php.

References $groups, groups(), and install().

Referenced by attributeFilterDefinitions().

◆ allImages()

dbx\dbxShop\dbxShopRepository::allImages ( )

Definition at line 2597 of file dbxShopRepository.class.php.

References $rows, and install().

◆ attributeDefinitionsForGroup()

dbx\dbxShop\dbxShopRepository::attributeDefinitionsForGroup	(	int	$groupId,
		bool	$activeOnly = true )

Definition at line 385 of file dbxShopRepository.class.php.

References install().

Referenced by attributeDefinitionsForProduct().

◆ attributeDefinitionsForProduct()

dbx\dbxShop\dbxShopRepository::attributeDefinitionsForProduct	(	int	$productId,
		bool	$activeOnly = true )

Definition at line 395 of file dbxShopRepository.class.php.

References $definition, attributeDefinitionsForGroup(), and groupsForProduct().

◆ attributeFilterDefinitions()

dbx\dbxShop\dbxShopRepository::attributeFilterDefinitions ( )

Definition at line 467 of file dbxShopRepository.class.php.

References $rows, $value, allAttributeDefinitions(), and install().

◆ attributesForProduct()

dbx\dbxShop\dbxShopRepository::attributesForProduct ( int $productId )

Definition at line 409 of file dbxShopRepository.class.php.

References $value, and install().

◆ catalogCandidates()

dbx\dbxShop\dbxShopRepository::catalogCandidates ( string $channelKey = 'shop' )

Liefert leichte, gebuendelt angereicherte Katalogzeilen.

Suche und Filter benoetigen Gruppen, Attribute und den aktiven Channel, aber noch keine Bilder, Versand- oder Channel-Gruppen. Diese Daten werden erst fuer die sichtbare Report-Seite vollstaendig dekoriert.

Definition at line 1042 of file dbxShopRepository.class.php.

References $groups, $rows, groups(), and install().

◆ channelById()

dbx\dbxShop\dbxShopRepository::channelById ( int $id )

Definition at line 1954 of file dbxShopRepository.class.php.

References install().

Referenced by testChannelConnection(), and updateChannel().

◆ channelByKey()

dbx\dbxShop\dbxShopRepository::channelByKey ( string $key )

Definition at line 1963 of file dbxShopRepository.class.php.

References install().

Referenced by importChannelOrder(), and saveProductChannelMapping().

◆ channelGroups()

dbx\dbxShop\dbxShopRepository::channelGroups ( )

Definition at line 2287 of file dbxShopRepository.class.php.

References $groups, channelsForChannelGroup(), and install().

◆ channelGroupsForProduct()

dbx\dbxShop\dbxShopRepository::channelGroupsForProduct ( int $productId )

Definition at line 1812 of file dbxShopRepository.class.php.

◆ channels()

dbx\dbxShop\dbxShopRepository::channels ( )

Definition at line 1946 of file dbxShopRepository.class.php.

References $rows, and install().

Referenced by channelsForChannelGroup(), channelsForProduct(), inheritedChannelsForProduct(), and productChannelOverrides().

◆ channelsForChannelGroup()

dbx\dbxShop\dbxShopRepository::channelsForChannelGroup ( int $channelGroupId )

Definition at line 2298 of file dbxShopRepository.class.php.

References channels().

Referenced by channelGroups().

◆ channelsForProduct()

dbx\dbxShop\dbxShopRepository::channelsForProduct ( int $productId )

Definition at line 1587 of file dbxShopRepository.class.php.

References channels().

◆ claimOrderPayment()

dbx\dbxShop\dbxShopRepository::claimOrderPayment	(	int	$orderId,
		string	$provider,
		string	$reference )

Beansprucht einen Provider-Abschluss atomar.

Nur der Request, der created/open/failed oder einen abgelaufenen processing-Lease nach processing ueberfuehrt, darf den externen Capture-/Complete-Aufruf ausfuehren.

Definition at line 3400 of file dbxShopRepository.class.php.

References $db, $order, $reference, and install().

◆ createOrderFromItems()

dbx\dbxShop\dbxShopRepository::createOrderFromItems	(	array	$items,
		string	$channelKey = 'shop',
		string	$customerName = '',
		string	$customerEmail = '',
		string	$note = '',
		string	$paymentProvider = '',
		string	$paymentStatus = 'open',
		string	$status = 'payment_pending',
		string	$customerPhone = '',
		string	$shippingAddress = '',
		string	$legalSnapshot = '',
		string	$withdrawalSnapshot = '' )

Definition at line 2791 of file dbxShopRepository.class.php.

References $items, and install().

◆ dashboardStats()

dbx\dbxShop\dbxShopRepository::dashboardStats ( )

Definition at line 3840 of file dbxShopRepository.class.php.

References install().

◆ deleteChannel()

dbx\dbxShop\dbxShopRepository::deleteChannel ( int $id )

Definition at line 2023 of file dbxShopRepository.class.php.

References install().

◆ deleteChannelGroup()

dbx\dbxShop\dbxShopRepository::deleteChannelGroup ( int $id )

Definition at line 2436 of file dbxShopRepository.class.php.

References install().

◆ deleteOrder()

dbx\dbxShop\dbxShopRepository::deleteOrder ( int $id )

Definition at line 3354 of file dbxShopRepository.class.php.

References install().

◆ deleteProductGroup()

dbx\dbxShop\dbxShopRepository::deleteProductGroup ( int $id )

Definition at line 2456 of file dbxShopRepository.class.php.

References install().

◆ deleteProducts()

dbx\dbxShop\dbxShopRepository::deleteProducts ( array $ids )

Definition at line 1451 of file dbxShopRepository.class.php.

References install().

◆ deleteShippingGroup()

dbx\dbxShop\dbxShopRepository::deleteShippingGroup ( int $id )

Definition at line 2472 of file dbxShopRepository.class.php.

References install().

◆ ensureOrderInvoicePdf()

dbx\dbxShop\dbxShopRepository::ensureOrderInvoicePdf ( int $id )

Definition at line 3676 of file dbxShopRepository.class.php.

References $order, install(), and orderById().

◆ exportProductsToChannel()

dbx\dbxShop\dbxShopRepository::exportProductsToChannel	(	array	$ids,
		string	$channelKey )

Definition at line 2247 of file dbxShopRepository.class.php.

References $result, exportProductToChannel(), and install().

◆ exportProductToChannel()

dbx\dbxShop\dbxShopRepository::exportProductToChannel	(	int	$productId,
		string	$channelKey )

Definition at line 2220 of file dbxShopRepository.class.php.

References install(), and productById().

Referenced by exportProductsToChannel().

◆ groupById()

dbx\dbxShop\dbxShopRepository::groupById ( int $id )

Definition at line 1275 of file dbxShopRepository.class.php.

References install().

Referenced by groupPath(), groupsForProduct(), and moveProductGroupParent().

◆ groupPath()

dbx\dbxShop\dbxShopRepository::groupPath ( int $groupId )

Definition at line 1863 of file dbxShopRepository.class.php.

References groupById(), and install().

◆ groups()

dbx\dbxShop\dbxShopRepository::groups ( )

Definition at line 1845 of file dbxShopRepository.class.php.

References $rows, and install().

Referenced by allAttributeDefinitions(), and catalogCandidates().

◆ groupsByParent()

dbx\dbxShop\dbxShopRepository::groupsByParent	(	int	$parentId = 0,
		bool	$activeOnly = true )

Definition at line 1853 of file dbxShopRepository.class.php.

References install().

◆ groupsForProduct()

dbx\dbxShop\dbxShopRepository::groupsForProduct ( int $productId )

Definition at line 1544 of file dbxShopRepository.class.php.

References groupById().

Referenced by attributeDefinitionsForProduct(), and productImageCounts().

◆ hasOrderHistoryEvent()

dbx\dbxShop\dbxShopRepository::hasOrderHistoryEvent	(	int	$orderId,
		string	$eventType,
		string	$newValue = '' )

Definition at line 3557 of file dbxShopRepository.class.php.

References if.

◆ imagesForProduct()

dbx\dbxShop\dbxShopRepository::imagesForProduct	(	int	$productId,
		array	$groups = array() )

Definition at line 2533 of file dbxShopRepository.class.php.

References $groups, $rows, and install().

Referenced by productImageCounts().

◆ importChannelOrder()

dbx\dbxShop\dbxShopRepository::importChannelOrder	(	string	$channelKey,
		array	$payload )

Definition at line 2911 of file dbxShopRepository.class.php.

References channelByKey(), and install().

◆ inheritedChannelsForProduct()

dbx\dbxShop\dbxShopRepository::inheritedChannelsForProduct ( int $productId )

Definition at line 1672 of file dbxShopRepository.class.php.

References channels(), and install().

◆ install()

dbx\dbxShop\dbxShopRepository::install ( bool $maintenance = false )

Fuehrt die explizite Schema- und Defaultpflege aus.

Alle Repository-Methoden duerfen install() weiterhin einheitlich aufrufen. Ohne $maintenance ist die Methode absichtlich schreibfrei. Nur die geschuetzte Admin-Installation ruft install(true) auf.

Definition at line 111 of file dbxShopRepository.class.php.

Referenced by addChannelToProducts(), allAttributeDefinitions(), allImages(), attributeDefinitionsForGroup(), attributeFilterDefinitions(), attributesForProduct(), catalogCandidates(), channelById(), channelByKey(), channelGroups(), channels(), claimOrderPayment(), createOrderFromItems(), dashboardStats(), deleteChannel(), deleteChannelGroup(), deleteOrder(), deleteProductGroup(), deleteProducts(), deleteShippingGroup(), ensureOrderInvoicePdf(), exportProductsToChannel(), exportProductToChannel(), groupById(), groupPath(), groups(), groupsByParent(), imagesForProduct(), importChannelOrder(), inheritedChannelsForProduct(), moveProductGroupParent(), needsDemoSeed(), orderById(), orderByNo(), orderByPaymentReference(), orderChannelKeys(), orderCount(), orders(), ordersByUid(), primaryImageForGroup(), productById(), productBySku(), productChannelMapping(), productChannelOverrides(), productImageCounts(), products(), productsByIds(), removeChannelFromProducts(), removeProductImageAssociation(), saveAttributeDefinition(), saveImage(), saveMediaImage(), saveProductAttributeValue(), saveProductChannelMapping(), saveProductChannelOverrides(), saveWithdrawal(), seedDemoProducts(), setProductGroupForProducts(), shippingGroups(), stockIssuesForItems(), testChannelConnection(), updateChannel(), updateChannelGroup(), updateImageMediaReference(), updateOrderAdmin(), updateOrderPayment(), updateOrderQuickAction(), updateProductGroup(), updateShippingGroup(), updateWithdrawalAdmin(), and withdrawals().

◆ invoicePdfAbsolutePath()

dbx\dbxShop\dbxShopRepository::invoicePdfAbsolutePath ( array $order )

Definition at line 3729 of file dbxShopRepository.class.php.

References $order.

◆ moveProductGroupParent()

dbx\dbxShop\dbxShopRepository::moveProductGroupParent	(	int	$groupId,
		int	$parentId )

Definition at line 1919 of file dbxShopRepository.class.php.

References groupById(), and install().

◆ needsDemoSeed()

dbx\dbxShop\dbxShopRepository::needsDemoSeed ( )

Schneller Seed-Check ohne Produktdekoration und N+1-Abfragen.

Definition at line 357 of file dbxShopRepository.class.php.

References install().

◆ nextInvoiceNo()

dbx\dbxShop\dbxShopRepository::nextInvoiceNo ( )

Definition at line 3568 of file dbxShopRepository.class.php.

References $rows.

Referenced by updateOrderAdmin().

◆ orderById()

dbx\dbxShop\dbxShopRepository::orderById ( int $id )

Definition at line 3103 of file dbxShopRepository.class.php.

References install(), orderHistory(), orderItems(), and withdrawalsForOrder().

Referenced by ensureOrderInvoicePdf(), updateOrderAdmin(), and updateOrderQuickAction().

◆ orderByNo()

dbx\dbxShop\dbxShopRepository::orderByNo ( string $orderNo )

Definition at line 3093 of file dbxShopRepository.class.php.

References install(), orderHistory(), orderItems(), and withdrawalsForOrder().

Referenced by saveWithdrawal().

◆ orderByPaymentReference()

dbx\dbxShop\dbxShopRepository::orderByPaymentReference	(	string	$provider,
		string	$reference )

Definition at line 3359 of file dbxShopRepository.class.php.

References $reference, install(), and orderItems().

◆ orderChannelKeys()

dbx\dbxShop\dbxShopRepository::orderChannelKeys ( )

Definition at line 3178 of file dbxShopRepository.class.php.

References $keys, $rows, and install().

◆ orderCount()

dbx\dbxShop\dbxShopRepository::orderCount ( array $filters = array() )

Definition at line 3161 of file dbxShopRepository.class.php.

References install().

◆ orderHistory()

dbx\dbxShop\dbxShopRepository::orderHistory ( int $orderId )

Definition at line 3552 of file dbxShopRepository.class.php.

References $rows.

Referenced by orderById(), and orderByNo().

◆ orderItems()

dbx\dbxShop\dbxShopRepository::orderItems ( int $orderId )

Definition at line 3367 of file dbxShopRepository.class.php.

References $rows.

Referenced by orderById(), orderByNo(), and orderByPaymentReference().

◆ orders()

dbx\dbxShop\dbxShopRepository::orders	(	array	$filters = array(),
		int	$limit = 50,
		int	$offset = 0,
		string	$sort = 'create_date',
		string	$direction = 'DESC' )

Definition at line 3130 of file dbxShopRepository.class.php.

References install().

◆ ordersByUid()

dbx\dbxShop\dbxShopRepository::ordersByUid	(	int	$uid,
		int	$limit = 25 )

Definition at line 3113 of file dbxShopRepository.class.php.

References install().

◆ primaryImageForGroup()

dbx\dbxShop\dbxShopRepository::primaryImageForGroup ( int $groupId )

Definition at line 2741 of file dbxShopRepository.class.php.

References install().

◆ productById()

dbx\dbxShop\dbxShopRepository::productById ( int $id )

Definition at line 1269 of file dbxShopRepository.class.php.

References install().

Referenced by exportProductToChannel(), productChannelMapping(), and saveProductChannelMapping().

◆ productBySku()

dbx\dbxShop\dbxShopRepository::productBySku	(	string	$sku,
		bool	$activeOnly = true )

Definition at line 1259 of file dbxShopRepository.class.php.

References install().

Referenced by stockIssuesForItems().

◆ productChannelMapping()

dbx\dbxShop\dbxShopRepository::productChannelMapping	(	int	$productId,
		string	$channelKey )

Definition at line 2117 of file dbxShopRepository.class.php.

References install(), and productById().

◆ productChannelOverrides()

dbx\dbxShop\dbxShopRepository::productChannelOverrides ( int $productId )

Definition at line 1645 of file dbxShopRepository.class.php.

References channels(), and install().

◆ productImageCounts()

dbx\dbxShop\dbxShopRepository::productImageCounts ( )

Definition at line 2584 of file dbxShopRepository.class.php.

References $groups, groupsForProduct(), imagesForProduct(), and install().

◆ products()

dbx\dbxShop\dbxShopRepository::products ( bool $activeOnly = true )

Definition at line 1027 of file dbxShopRepository.class.php.

References $rows, and install().

◆ productsByIds()

dbx\dbxShop\dbxShopRepository::productsByIds ( array $ids )

Dekoriert nur die vom Report tatsaechlich sichtbaren Artikel.

Definition at line 1233 of file dbxShopRepository.class.php.

References $byId, $rows, and install().

◆ removeChannelFromProducts()

dbx\dbxShop\dbxShopRepository::removeChannelFromProducts	(	array	$ids,
		string	$channelKey )

Definition at line 1496 of file dbxShopRepository.class.php.

References install().

◆ removeProductImageAssociation()

dbx\dbxShop\dbxShopRepository::removeProductImageAssociation	(	int	$imageId,
		int	$productId = 0 )

Definition at line 2761 of file dbxShopRepository.class.php.

References install().

◆ saveAttributeDefinition()

dbx\dbxShop\dbxShopRepository::saveAttributeDefinition ( array $data )

Definition at line 521 of file dbxShopRepository.class.php.

References install().

◆ saveImage()

dbx\dbxShop\dbxShopRepository::saveImage	(	int	$productId,
		int	$groupId,
		string	$imagePath,
		string	$title,
		string	$alt,
		int	$isPrimary = 0,
		int	$sorter = 100 )

Definition at line 2672 of file dbxShopRepository.class.php.

References install().

◆ saveMediaImage()

dbx\dbxShop\dbxShopRepository::saveMediaImage	(	int	$productId,
		int	$groupId,
		int	$mediaId,
		string	$title = '',
		string	$alt = '',
		int	$isPrimary = 0,
		int	$sorter = 100 )