price - "Preis" Hublify-CMS - Template Examples
Below you can find some auto-generated examples for direct use within your Hublify-CMS' twig templates.
dataset().all()
Hint: For best performance, retrieve only those fields you really need!
Autogenerated twig-templating source code:
{# Get all records from dataset "price".
Other retrievable fields of price are:
'prc_id' - (INT, 11) Preis-ID,
'fk_prc_pcode' - (TEXT, 127) Produktcode,
'fk_prc_shopid' - (INT, 11) Shop,
'state' - (INT, 3) Status,
'state_color' - (TEXT, 15) ,
'rrp' - (FLOAT, 13,2) UVP (Brutto),
'price' - (FLOAT, 13,2) Brutto Preis,
'vat' - (FLOAT, 6,2) MwSt. Satz (%),
'discount' - (FLOAT, 13,2) Discount Brutto Preis,
'discount_text' - (TEXT) Discount Text,
'discount_start' - (DATETIME) Discount Startdatum,
'discount_end' - (DATETIME) Discount Enddatum,
'price_dsc_scale' - (DATA) Staffelpreise,
'fk_prc_prcgrp_id' - (INT, 11) Preisgruppe,
'prd_storage_counter' - (FLOAT, 13,1) Lagerbestand,
'prd_storage_counter_update_time' - (DATETIME) Letzte Änderung des Lagerbestands,
'prd_storage_limit_notify' - (FLOAT, 13,1) Info geringer Bestand,
'prd_storage_limit_reorder' - (FLOAT, 13,1) Info Nachbestellung,
'order_quanti_max' - (FLOAT, 13,1) Max. Bestellmenge,
'order_quanti_min' - (FLOAT, 13,1) Mindest-Bestellmenge,
'order_quanti_inc' - (FLOAT, 13,1) Bestellschrittweite,
'offer_level' - (INT, 11) Offer-Level,
'prd_delivery' - (TEXT) Lieferhinweis,
'searchable' - (INT, 1) Suchbar,
'single_buy' - (INT, 1) Kaufbar,
'available_date' - (DATETIME) Verfügbar ab,
'hide_price_dsp' - (INT, 1) Preisanzeige,
'bookable' - (INT, 1) Vorbestellung möglich,
'free_shipping' - (TEXT) Versandkostenfrei für ,
'xdata' - (DATA) Weitere Daten,
'price_first_online' - (DATETIME) Zuerst online,
'prc_insert_time' - (DATETIME) Angelegt am,
'prc_insert_user' - (TEXT, 127) Ersteller,
'prc_update_time' - (DATETIME) Geändert am,
'prc_update_user' - (TEXT, 127) Letzte Änderung durch,
'prc_external_id' - (TEXT, 63) ,
'prc_configurator_adaptor' - (TEXT) Konfigurator Adaptor,
'prc_configurator_params' - (TEXT) Konfigurator Parameter,
'dynx__externalid_shopware' - (INT, 11) Shopware ID,
'dynx__prdxcost_ch' - (FLOAT, 13,4) ,
#}
{% set dataList = hublify.dataset('price')
.fields([
'prc_id',
'fk_prc_pcode',
])
.filter('','<something>')
.limit(10)
.all()
%}
dataset().one()
Hint: For best performance, retrieve only those fields you really need!
Autogenerated twig-templating source code:
{# Get one record from dataset "price".
Other retrievable fields of price are:
'prc_id' - (INT, 11) Preis-ID,
'fk_prc_pcode' - (TEXT, 127) Produktcode,
'fk_prc_shopid' - (INT, 11) Shop,
'state' - (INT, 3) Status,
'state_color' - (TEXT, 15) ,
'rrp' - (FLOAT, 13,2) UVP (Brutto),
'price' - (FLOAT, 13,2) Brutto Preis,
'vat' - (FLOAT, 6,2) MwSt. Satz (%),
'discount' - (FLOAT, 13,2) Discount Brutto Preis,
'discount_text' - (TEXT) Discount Text,
'discount_start' - (DATETIME) Discount Startdatum,
'discount_end' - (DATETIME) Discount Enddatum,
'price_dsc_scale' - (DATA) Staffelpreise,
'fk_prc_prcgrp_id' - (INT, 11) Preisgruppe,
'prd_storage_counter' - (FLOAT, 13,1) Lagerbestand,
'prd_storage_counter_update_time' - (DATETIME) Letzte Änderung des Lagerbestands,
'prd_storage_limit_notify' - (FLOAT, 13,1) Info geringer Bestand,
'prd_storage_limit_reorder' - (FLOAT, 13,1) Info Nachbestellung,
'order_quanti_max' - (FLOAT, 13,1) Max. Bestellmenge,
'order_quanti_min' - (FLOAT, 13,1) Mindest-Bestellmenge,
'order_quanti_inc' - (FLOAT, 13,1) Bestellschrittweite,
'offer_level' - (INT, 11) Offer-Level,
'prd_delivery' - (TEXT) Lieferhinweis,
'searchable' - (INT, 1) Suchbar,
'single_buy' - (INT, 1) Kaufbar,
'available_date' - (DATETIME) Verfügbar ab,
'hide_price_dsp' - (INT, 1) Preisanzeige,
'bookable' - (INT, 1) Vorbestellung möglich,
'free_shipping' - (TEXT) Versandkostenfrei für ,
'xdata' - (DATA) Weitere Daten,
'price_first_online' - (DATETIME) Zuerst online,
'prc_insert_time' - (DATETIME) Angelegt am,
'prc_insert_user' - (TEXT, 127) Ersteller,
'prc_update_time' - (DATETIME) Geändert am,
'prc_update_user' - (TEXT, 127) Letzte Änderung durch,
'prc_external_id' - (TEXT, 63) ,
'prc_configurator_adaptor' - (TEXT) Konfigurator Adaptor,
'prc_configurator_params' - (TEXT) Konfigurator Parameter,
'dynx__externalid_shopware' - (INT, 11) Shopware ID,
'dynx__prdxcost_ch' - (FLOAT, 13,4) ,
#}
{% set dataList = hublify.dataset('price')
.fields([
'prc_id',
'fk_prc_pcode',
])
.filter('prc_id','<something>')
.one()
%}
api(). ... - create
For how-to insert a record...
api(). ... - update
For how-to update a record...
WHAT ELSE, you'd like ??
...