otevírací doba
Prodejna & vzorkovna | |
---|---|
pondělí - pátek | 7:00 - 16:00 |
KONTAKTNÍ OSOBY
Vedoucí pobočky:
Ing. Vladimír Němec, 383 355 533, vladimir.nemec@jafholz.cz
Vedoucí prodeje:
Jaromír Čejka, 734 358 449, jaromir.cejka@jafholz.cz
Prodejna:
Anna Soukopová, 383 355 511, anna.soukupova@jafholz.cz
Obchodní zástupci:
Petr Jaroš, 605 399 760, petr.jaros@jafholz.cz
Martin Klecán, 602 630 357, martin.klecan@jafholz.cz
Pavel Morávek, 724 216 880, pavel.moravek@jafholz.cz
Prodej truhlářského a stavebního řeziva:
Miroslav Masáček, 383 355 515, 724 534 402, miroslav.masacek@jafholz.cz
Prodej plošných materiálů:
Nikola Pilečková, 383 355 512, nikola.pileckova@jafholz.cz
Prodej překližek a stavebních prvků:
Iveta Kolešová, 383 355 537, 606 629 042, iveta.kolesova@jafholz.cz
Prodej dýh:
Karel Dušek, 383 355 513, 602 211 325, karel.dusek@jafholz.cz
Prodej dveří, podlah:
Ing. Edita Morávková, 383 355 518, edita.moravkova@jafholz.cz
Bc. Pavel Pileček, 383 355 519, 731 562 464, pavel.pilecek@jafholz.cz
Formátování, olepování:
Štěpánka Záveská, 383 355 520, stepanka.zaveska@jafholz.cz
Prodej kování:
Marcela Hoťová, 383 355 514, marcela.hotova@jafholz.cz
Petr Valach, 732 390 357, petr.valach@jafholz.cz
Nákup:
Martina Härtelová, 383 355 521, martina.hartelova@jafholz.cz
Doprava, organizace rozvozů:
Pavel Turek, 383 355 534, 606 651 041, pavel.turek@jafholz.cz
Nábytkové dílce:
David Müller, 383 355 526, david.muller@jafholz.cz
VZORKOVNA
TERASOVÁ EXPOZICE
volné pracovní pozice
Listing {#12636 #query: QueryBuilder {#12637 #_adapter: Connection {#2395 #_conn: Connection {#276 : false : { : NATURAL : EXCEPTION : 1 : false : "mysql" : "Uptime: 1034060 Threads: 6 Questions: 573933229 Slow queries: 0 Opens: 43291 Flush tables: 1 Open tables: 5978 Queries per second avg: 555.028" : 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 [ "0000000061e39f2b000000004a3adb40" => RouteConditionMetadataListener {#2391} "0000000061e39f24000000004a3adb40" => 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 (1762)) 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ě.