otevírací doba
Prodejna & vzorkovna | |
---|---|
změna otevírací doby | |
pondělí - pátek | 7:00 - 16:00 |
KONTAKTNÍ OSOBY
Vedoucí pobočky:
Bc. Jiří Hrubý, 724 526 422
Vedoucí prodeje:
Ing. Zdeněk Hora, 602 479 323
Obchodní zástupci:
Adam Pech, 602 774 831
Michal Raus, 731 697 096
Pavel Reithar, 602 774 923
Petr Sedlák, 724 130 781
Roman Valeš, 602 774 924
Obchodní zástupci - stavební prvky:
Josef Kesner, 602 559 572
Pavel Brezňan, 723 471 252
Tomáš Mach, Dis, 731 637 650– podlahy, dveře
Prodej plošných materiálů:
Michaela Benetková, 724 514 167, 371 519 162
Monika Čermáková, 703 477 868, 371 519 158
Prodej kování:
Martin Forejt, 734 117 727
Tereza Petrová, 371 519 163
Prodej truhlářského a exotického řeziva, terasových prken:
Petr Ptáčník, 721 564 277
Prodej stavebních prvků, řeziva:
Radka Rollová, 731 123 510, 371 519 169
Jan Růžička, 602 424 303, 371 519 164
Prodej podlah a dveří:
Klára Mráčková, 371 519 156
Dana Wolfová, 724 723 075, 371 519 165
Prodej dýh:
Bc. Martin Mudra, 724 032 281
Petr Ptáčník, 721 564 277
Výroba:
Radek Černý, 724 841 866, 371 519 154
Jáchym Straka, 371 519 153
Lukáš Špachman, 734 282 571 – nábytkové dílce
Doprava:
Jan Vančura, 723 479 616, 371 519 155
Účtárna:
Alice Provazníková, 724 509 445, 371 519 160
VZORKOVNA
TERASOVÁ EXPOZICE
VOLNÉ PRACOVNÍ POZICE
Listing {#12646 #query: QueryBuilder {#12647 #_adapter: Connection {#2395 #_conn: Connection {#276 : false : { : NATURAL : EXCEPTION : 1 : false : "mysql" : "Uptime: 1031849 Threads: 8 Questions: 573349784 Slow queries: 0 Opens: 43278 Flush tables: 1 Open tables: 5978 Queries per second avg: 555.652" : NATURAL : "mysqlnd 7.4.30" : "5.7.12" : array:2 [ 0 => "Doctrine\DBAL\Driver\PDO\Statement" 1 => [] ] : 1 : "pimcore-cluster.cluster-cyehy2usxici.eu-west-1.rds.amazonaws.com via TCP/IP" : BOTH } } #_config: Configuration {#2387 #_attributes: array:2 [ "filterSchemaAssetsExpression" => null "filterSchemaAssetsExpressionCallable" => SchemaAssetsFilterManager {#2388 -schemaAssetFilters: array:1 [ 0 => BlacklistSchemaAssetFilter {#2389 -blacklist: array:1 [ 0 => "lock_keys" ] } ] } ] } #_eventManager: ContainerAwareEventManager {#2390 -listeners: array:1 [ "loadClassMetadata" => array:2 [ "00000000546fe7a90000000015c83583" => RouteConditionMetadataListener {#2391} "00000000546fe7a60000000015c83583" => AttachEntityListenersListener {#2392 -entityListeners: [] } ] ] -initialized: [] -container: appProdProjectContainer {#105 …21} -listeners: [] } #_expr: ExpressionBuilder {#2396 -connection: Connection {#2395} } -autoCommit: true -transactionNestingLevel: 0 -transactionIsolationLevel: null -nestTransactionsWithSavepoints: false -params: array:11 [ "driver" => "pdo_mysql" "charset" => "UTF8MB4" "user" => "frischeis" "password" => "Koth3fiH" "dbname" => "frischeis_shop_pimcore" "host" => "pimcore-cluster.cluster-cyehy2usxici.eu-west-1.rds.amazonaws.com" "port" => "3306" "driverOptions" => [] "wrapperClass" => "\Pimcore\Db\Connection" "serverVersion" => "5.6" "defaultTableOptions" => array:2 [ "charset" => "UTF8MB4" "collate" => "utf8mb4_general_ci" ] ] -platform: MySqlPlatform {#2397 #doctrineTypeMapping: array:32 [ "tinyint" => "boolean" "smallint" => "smallint" "mediumint" => "integer" "int" => "integer" "integer" => "integer" "bigint" => "bigint" "tinytext" => "text" "mediumtext" => "text" "longtext" => "text" "text" => "text" "varchar" => "string" "string" => "string" "char" => "string" "date" => "date" "datetime" => "datetime" "timestamp" => "datetime" "time" => "time" "float" => "float" "double" => "float" "real" => "float" "decimal" => "decimal" "numeric" => "decimal" "year" => "date" "longblob" => "blob" "blob" => "blob" "mediumblob" => "blob" "tinyblob" => "blob" "binary" => "binary" "varbinary" => "binary" "set" => "simple_array" "enum" => "string" "bit" => "boolean" ] #doctrineTypeComments: null #_eventManager: ContainerAwareEventManager {#2390} #_keywords: null } #_schemaManager: null #_driver: Driver {#2394} -isRollbackOnly: false #defaultFetchMode: 2 #autoQuoteIdentifiers: true } #_parts: array:11 [ "distinct" => false "columns" => array:3 [ 0 => array:3 [ 0 => "job" 1 => "oo_id" 2 => "Id" ] 1 => array:3 [ 0 => "subsidiary" 1 => "*" 2 => null ] 2 => array:3 [ 0 => "localized" 1 => "*" 2 => null ] ] "union" => [] "from" => array:3 [ "job" => array:4 [ "joinType" => "from" "schema" => null "tableName" => "object_39" "joinCondition" => null ] "subsidiary" => array:4 [ "joinType" => "left join" "schema" => null "tableName" => "object_13" "joinCondition" => "subsidiary.oo_id = job.subsidiary__id" ] "localized" => array:4 [ "joinType" => "left join" "schema" => null "tableName" => "object_localized_query_39_cs_CZ" "joinCondition" => "localized.ooo_id = job.o_id" ] ] "where" => array:3 [ 0 => "(job.o_published = 1)" 1 => "AND (localized.title is not null and localized.title != '')" 2 => "AND (job.o_path like '/jobs/subsidiary/cz_jobs/%')" ] "group" => [] "having" => [] "order" => array:1 [ 0 => array:2 [ 0 => "date" 1 => "DESC" ] ] "limitcount" => null "limitoffset" => null "forupdate" => false ] #_tableCols: [] #params: [] #paramTypes: [] } #offset: 0 #limit: 30 #rowCount: 0 #list: null #itemClassName: "AppBundle\Service\ListItem" #itemType: "object" #filter: [] #locale: null }
""" SELECT `job`.`oo_id` AS `Id`, `subsidiary`.*, `localized`.* FROM `object_39` AS `job`\n LEFT JOIN `object_13` AS `subsidiary` ON subsidiary.oo_id = job.subsidiary__id\n LEFT JOIN `object_localized_query_39_cs_CZ` AS `localized` ON localized.ooo_id = job.o_id WHERE (job.o_published = 1) AND (localized.title is not null and localized.title != '') AND (job.o_path like '/jobs/subsidiary/cz_jobs/%') AND (job.subsidiary__id in (1804)) ORDER BY `date` DESC """
mapa příjezdu
kontaktujte nás
Máte-li nějaký dotaz nebo poptávku, využijte formulář níže. Zpracování každého formuláře trvá obvykle několik pracovních dní, budeme se Vám ale snažit odpovědět v co možná nejkratší době.