otevírací doba
Prodejna & vzorkovna | |
---|---|
pondělí - pátek | 7:00 - 15:30 |
KONTAKTNÍ OSOBY
Vedoucí pobočky:
Ing. Andrej Kocvár
Vedoucí prodeje:
Martin Thoř, 724 352 101, martin.thor@jafholz.cz
Obchodní zástupci:
Jan Randa, 724 008 981, jan.randa@jafholz.cz
Oblast: Ústí nad Labem, Litoměřice, Roudnice nad Labem, Neratovice
Jiří Macoun, 736 214 625, jiri.macoun@jafholz.cz
Oblast: Děčín, Česká Lípa, Mladá Boleslav, Liberec
Ing. Andrea Čiefová, 724 008 438, andrea.ciefova@jafholz.cz
Oblast: Praha západ, Kladno, Slaný, Lovosice, Teplice
Tomáš Mařata, 605 399 908, tomas.marata@jafholz.cz
Oblast: Mělník, Nymburk, Český Brod, Nová Paka
Mgr. Dagmar Tůmová, 721 866 359, dagmar.tumova@jafholz.cz
Oblast: Ústecký kraj
Prodej plošných materiálů:
Pavel Kuzebauch, 731 682 359, pavel.kuzebauch@jafholz.cz
Adéla Bíbrlová, 731 682 360, adela.bibrlova@jafholz.cz
Prodej kování:
Radka Kudrnová 326 901 036, 736 203 165 radka.kudrnova@jafholz.cz
Prodej stavebních prvků - obchodní zástupci:
Vladimír Janček, 724 019 161, vladimir.jancek@jafholz.cz
Karel Šírek, 602 171 524, karel.sirek@jafholz.cz
Jiří Hrdina, 734 684 625, jiri.hrdina@jafholz.cz
Prodej truhlářského a exotického řeziva:
Milan Macek, 734 646 111, milan.macek@jafholz.cz
Prodej dveří:
Zdeňka Bouřilová, 326 901 018, 602 477 730, zdenka.bourilova@jafholz.cz
Prodej podlah:
Lenka Rejzlová, 602 477 730, 326 901 013, lenka.rejzlova@jafholz.cz
Prodej dýh:
Vladimír Hauer, 602 855 332, vladimir.hauer@jafholz.cz
Bc. Martin Mudra, 724 032 281
Formátování a olepování:
Hana Bystrá, 326 901 038, hana.bystra@jafholz.cz
Dana Zhorná, 602 737 099, dana.zhorna@jafholz.cz
Dílna: Vladimír Hauer, 602 855 332, vladimir.hauer@jafholz.cz
Vedoucí skladu:
Bc. Ondřej Kubů, 731 497 120, 326 901 031
ondrej.kubu@jafholz.cz
Účtárna:
Soňa Šíchová, sona.sichova@jafholz.cz
Věra Drimlová, vera.drimlova@jafholz.cz
VZORKOVNA
TERASOVÁ EXPOZICE
volné pracovní pozice
Listing {#12666 #query: QueryBuilder {#12667 #_adapter: Connection {#2395 #_conn: Connection {#276 : false : { : NATURAL : EXCEPTION : 1 : false : "mysql" : "Uptime: 1032539 Threads: 6 Questions: 573452193 Slow queries: 0 Opens: 43286 Flush tables: 1 Open tables: 5978 Queries per second avg: 555.380" : 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 [ "00000000133fa602000000002a3806b2" => RouteConditionMetadataListener {#2391} "00000000133fa60d000000002a3806b2" => 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 (1809)) 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ě.