VÝROBA NÁBYTKOVÝCH DÍLCŮ
Příjem zakázek nábytkových dílců
Tel.: +420 517 325 877
E-mail: vyroba.vyskov@jafholz.cz
Technická podpora - nábytkové dílce
Tel.: +420 517 325 886
E-mail: vyroba.vyskov@jafholz.cz
PRODEJ DVEŘÍ A PODLAH
Prodej dveří a podlah
Tel.: +420 517 325 875
E-mail: dvere.vyskov@jafholz.cz
Otevírací doba
Prodejna & vzorkovna dveří a podlah | |
---|---|
pondělí - úterý | 7:00 - 16:00 |
středa | 7:00 - 17:00 |
čtvrtek - pátek | 7:00 - 16:00 |
KONTAKTNÍ OSOBY
VÝROBA NÁBYTKOVÝCH DÍLCŮ
Vedoucí pobočky:
Pavel Lokaj, +420 737 915 146, pavel.lokaj@jafholz.cz
Technický a produktový manažer:
Milan Tesař, +420 733 622 730, milan.tesar@jafholz.cz
Vedoucí prodeje nábytkových dílců:
Petr Svoboda, +420 704 611 249, petr.svoboda@jafholz.cz
Obchodní zástupce:
Michal Švejda, +420 734 780 550, michal.svejda@jafholz.cz
Zákaznický servis:
Tomáš Fürst, +420 517 325 877, +420 731 604 281, tomas.fuerst@jafholz.cz
Jaroslav Plhal, +420 517 325 884, +420 734 729 096, jaroslav.plhal@jafholz.cz
Edita Zámečníková, +420 517 325 545, +420 734 728 987, edita.zamecnikova@jafholz.cz
Technická podpora - nábytkové dílce:
Jan Čtvrtník, +420 517 325 886, +420 734 729 206, jan.ctvrtnik@jafholz.cz
Matěj Strnad, +420 517 325 810, +420 734 729 044, matej.strnad@jafholz.cz
Jan Petřík, +420 602 155 174, Jan.Petrik@jafholz.cz
PRODEJ DVEŘÍ A PODLAH
Vedoucí prodeje dveří a podlah:
Jiří Adamec, +420 734 390 839, jiri.adamec@jafholz.cz
Prodej dveří:
Kamil Štěpán, +420 517 325 875, +420 724 947 251, kamil.stepan@jafholz.cz
Prodej podlah:
Lucie Beránková, +420 517 325 893, lucie.berankova@jafholz.cz
fotogalerie
VOLNÉ PRACOVNÍ POZICE
Listing {#12630 #query: QueryBuilder {#12631 #_adapter: Connection {#2395 #_conn: Connection {#276 : false : { : NATURAL : EXCEPTION : 1 : false : "mysql" : "Uptime: 1033228 Threads: 7 Questions: 573619341 Slow queries: 0 Opens: 43287 Flush tables: 1 Open tables: 5978 Queries per second avg: 555.172" : 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 [ "000000006b946913000000001cf70f7b" => RouteConditionMetadataListener {#2391} "000000006b94691c000000001cf70f7b" => 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 (15022140)) 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ě.