Array ( [id_masterSurBoutik] => 10 [label] => Plaquiste [ordre] => 5 [date_updated] => 2024-12-09 16:49:37 [date_created] => 2022-09-08 11:11:02 [id_surboutik] => 9 [content] => [color] => [back] => [image] => https://www.fartools.com/medias/photos-famille/3100.jpg [colorOn] => [backOn] => [imageOn] => [code_import] => [rewrite_url] => plaquiste [actif] => 1 [TRIEUR] => Array ( ) [SEO] => Array ( ) [OG] => Array ( ) [income] => Array ( [lang] => fr [rewrite_url_surboutik] => plaquiste [rewrite_url_boutikA] => [rewrite_url_boutikB] => [rewrite_url_boutikC] => [arborescence] => SURBOUTIK [rewrite_url_trieur] => [shop] => [secondevie] => [promotions] => [id_masterSurBoutik] => 10 ) [type] => SURBOUTIK [URLs] => Array ( [url_link] => [breadcrumbs] => ) [SQLBoutique] => SELECT SQL_CALC_FOUND_ROWS mPrix.* FROM masterPrix mPrix INNER JOIN prix_FR mPrixLang USING(id_masterPrix) LEFT OUTER JOIN prixExceptions prixExc ON mPrix.id_masterPrix = prixExc.id_masterPrix LEFT OUTER JOIN prixSecondevie prixSec ON mPrix.id_masterPrix = prixSec.id_masterPrix LEFT OUTER JOIN masterProduit mProd USING(id_masterProduit) LEFT OUTER JOIN collectionProduits colProd ON mProd.id_masterProduit = colProd.id_masterProduit LEFT OUTER JOIN masterSurBoutik_Navision_Collection MSBNC ON MSBNC.id_masterBoutikA = colProd.id_masterBoutikA AND ( MSBNC.id_masterBoutikB = colProd.id_masterBoutikB OR MSBNC.id_masterBoutikB = 0) AND ( MSBNC.id_masterBoutikC = colProd.id_masterBoutikC OR MSBNC.id_masterBoutikC = 0 ) WHERE ( ( mPrix.actif = 1 AND mPrixLang.actif = 1 ) OR ( mPrix.support = 1 ) ) AND ( prixSec.seconde_vie_actif IS NULL || prixSec.seconde_vie_actif = 0 ) AND MSBNC.value = 1 AND MSBNC.id_masterSurBoutik = :id_masterSurBoutik GROUP BY mPrix.id_masterProduit ORDER BY mPrix.ordre_BoutikA, IF( FIELD( prixExc.code_marque, 20, 11, 40, 90 ) = 0, 1, 0 ) , FIELD( prixExc.code_marque, 20, 11, 40, 90 ), mPrix.reference, mPrix.reference_fournisseur ASC [REWRITE_TRIEUR_SQL] => )
array(81) { ["id_masterPrix"]=> string(4) "8728" ["id_masterProduit"]=> string(4) "8559" ["id_masterBoutikA"]=> string(4) "3100" ["id_masterBoutikB"]=> string(4) "3106" ["id_masterBoutikC"]=> string(1) "0" ["product_default_file"]=> string(26) "medias/product_default.png" ["path_file_hd"]=> string(49) "medias/photos-catalogue/Photos/HD/113485A-dt.webp" ["image_file"]=> string(26) "medias/product_default.png" ["image_file_min"]=> string(26) "medias/product_default.png" ["image_file_hd"]=> string(26) "medias/product_default.png" ["allPhotos"]=> array(1) { [0]=> array(4) { ["HD"]=> string(26) "medias/product_default.png" ["REELLE"]=> string(26) "medias/product_default.png" ["BD"]=> string(26) "medias/product_default.png" ["MIN"]=> string(26) "medias/product_default.png" } } ["gencod"]=> string(0) "" ["reference"]=> string(7) "113485A" ["reference_fournisseur"]=> string(0) "" ["reference_masterProduit"]=> string(7) "113485A" ["actif"]=> string(1) "0" ["actif_lang"]=> string(1) "0" ["label_FR"]=> string(0) "" ["label_lang"]=> string(0) "" ["sublabel_lang"]=> string(0) "" ["description_FR"]=> string(0) "" ["description_lang"]=> string(0) "" ["min_description_FR"]=> string(0) "" ["min_description_lang"]=> string(0) "" ["poids"]=> string(5) "0.000" ["delta_stock"]=> int(1) ["stock"]=> string(1) "0" ["quantite_reception"]=> string(1) "0" ["date_reception"]=> string(19) "0000-00-00 00:00:00" ["indisponible"]=> string(1) "0" ["conditionnement"]=> string(1) "1" ["PHT"]=> string(5) "0.000" ["PTTC"]=> string(5) "0.000" ["PHT_promo"]=> string(5) "0.000" ["PTTC_promo"]=> string(5) "0.000" ["PHT_forcing"]=> string(5) "0.000" ["PTTC_forcing"]=> string(5) "0.000" ["Prix_quantitatif"]=> array(0) { } ["taxe"]=> string(4) "0.00" ["ecotaxe"]=> string(4) "0.00" ["Promo"]=> bool(false) ["Forcing"]=> int(0) ["PV_HT"]=> string(5) "0.000" ["PV_TTC"]=> float(0) ["nbAllPrice"]=> int(0) ["PHT_first"]=> NULL ["PTTC_first"]=> NULL ["PHT_promo_first"]=> NULL ["PTTC_promo_first"]=> NULL ["AllSecondeVie"]=> array(0) { } ["SecondeVie"]=> bool(false) ["taxe_first"]=> NULL ["ecotaxe_first"]=> NULL ["Promo_first"]=> bool(false) ["PV_HT_first"]=> NULL ["PV_TTC_first"]=> int(0) ["data_trieur"]=> array(4) { ["id_masterPrix"]=> string(4) "8728" ["DATA"]=> array(0) { } ["sqlTrieur"]=> string(387) "SELECT tC.*, MTP.label AS Parent, MTE.label AS Enfant, MTE.image, MTE.value, MTP.ordre FROM trieurCollection tC INNER JOIN masterTrieurParent MTP USING(id_masterTrieurParent) INNER JOIN masterTrieurEnfant MTE ON tC.id_masterTrieurEnfant = MTE.id_masterTrieurEnfant WHERE tC.id_masterPrix = :id_masterPrix ORDER BY MTP.ordre, MTE.ordre ASC" ["nbTrieur"]=> int(0) } ["type_produit"]=> string(0) "" ["url_link"]=> string(36) "fr/plaquiste/consommables/-8728.html" ["canonical"]=> string(36) "fr/plaquiste/consommables/-8728.html" ["hreflang"]=> array(2) { ["fr"]=> array(1) { ["url_link"]=> string(36) "fr/plaquiste/consommables/-8728.html" } ["en"]=> array(1) { ["url_link"]=> string(33) "en/drywall/consumables/-8728.html" } } ["listing_visible"]=> bool(false) ["listing_visible_infos"]=> string(9) "NOT ACTIF" ["page_visible"]=> bool(false) ["form_cart"]=> bool(false) ["form_cart_infos"]=> string(8) "NO STOCK" ["variante"]=> string(0) "" ["id_marque"]=> string(1) "1" ["code_marque"]=> string(2) "20" ["marque"]=> array(16) { ["id_marque"]=> string(1) "1" ["id_masterMarque"]=> string(1) "1" ["label"]=> string(3) "Pro" ["caption"]=> string(8) "FARTOOLS" ["description"]=> string(0) "" ["image"]=> string(59) "https://www.fartools.com/medias/MARQUES/marque_Fartools.jpg" ["width"]=> NULL ["height"]=> NULL ["link"]=> string(0) "" ["color"]=> string(7) "#FFFFFF" ["background"]=> string(7) "#1D1D1D" ["actif"]=> string(1) "1" ["ordre"]=> string(1) "0" ["code_import"]=> string(2) "20" ["date_updated"]=> string(19) "2022-10-19 10:19:46" ["date_created"]=> string(19) "2022-09-06 11:22:16" } ["Exceptions"]=> array(14) { ["id_prixException"]=> string(8) "11290563" ["id_masterPrix"]=> string(4) "8728" ["reference"]=> string(7) "113485A" ["variante"]=> string(0) "" ["id_marque"]=> string(1) "1" ["code_marque"]=> string(2) "20" ["label_marque"]=> string(3) "PRO" ["NomFichierFicheProduitVarianteActive"]=> string(11) "113485A.pdf" ["NomFichierVueEclateeVarianteActive"]=> string(11) "113485A.pdf" ["NomManuelVarianteActive"]=> string(0) "" ["VideoYoutube"]=> string(0) "" ["gencod"]=> string(0) "" ["date_updated"]=> string(19) "2025-01-23 03:10:17" ["date_created"]=> string(19) "2025-01-23 03:10:17" } ["varianteNotActive"]=> bool(false) ["VarianteAnterieurs"]=> array(0) { } ["data_seconde_vie"]=> array(0) { } ["is_kit"]=> bool(false) ["PrixKitAll"]=> array(0) { } ["is_in_kit"]=> bool(false) ["PrixinKit"]=> array(0) { } ["SEO"]=> array(0) { } ["OG"]=> array(0) { } ["income"]=> array(5) { ["id_masterPrix"]=> string(4) "8728" ["variante"]=> string(0) "" ["id_ndd"]=> int(1) ["affichage"]=> string(4) "full" ["variante_texte"]=> string(4) "VIDE" } }
En stock
En stock