///////////// SELECT END ///////////////////////////////////////////////////////////////////////////////////////////////////// ?> if(!empty($_POST['pidfilter'][0])) # Whitworth { # es müssen in der Tabelle "G", "R" und leerzeichen entfernt werden $qPID = $pdo->query("SELECT produkte.id,produkte.artikelnr,produkte.normserie,produkte.produktnummerid, normserien.gattung, normserien.serie, normserien.suchindex, normserien.titel, normserien.vtext FROM produkte LEFT JOIN normserien ON produkte.produktnummer = normserien.serie WHERE sprache='".$_SESSION['lang']."' and aktiv=1 and normserien.filter like '%,".$_POST['anwendung'].",%' ".$sql." and ( normserie = 'ep270' and trim(replace(wert8,' ','')) = 'R".$_POST['pidfilter'][0]."\"' or normserie = 'ep280' and trim(replace(wert13,' ','')) = '".$_POST['pidfilter'][0]."\"' or normserie = 'ep283' and trim(replace(wert11,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep285' and trim(replace(wert13,' ','')) = '".$_POST['pidfilter'][0]."\"' or normserie = 'ep320' and trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][0]."\"' or normserie = 'ep340' and trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][0]."\"' or normserie = 'ep350' and trim(replace(wert15,' ','')) = 'R".$_POST['pidfilter'][0]."\"' or normserie = 'ep360' and trim(replace(wert11,' ','')) = 'R".$_POST['pidfilter'][0]."\"' or normserie = 'ep370' and trim(replace(wert6,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep385' and trim(replace(wert1,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep400' and trim(replace(wert1,' ','')) = 'R".$_POST['pidfilter'][0]."\"' or normserie = 'ep4000' and trim(replace(wert1,' ','')) = 'R".$_POST['pidfilter'][0]."\"' or normserie = 'ep434' and trim(replace(wert1,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep435' and trim(replace(wert1,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep437' and trim(replace(wert1,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep439' and trim(replace(wert1,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep445' and trim(replace(wert1,' ','')) = 'G".$_POST['pidfilter'][0]."\"' ) order by normserie, sortierfolge asc "); $ProdukteArray = $qPID->fetchAll(PDO::FETCH_ASSOC); $anzahlprodukte=count($ProdukteArray); }elseif(!empty($_POST['pidfilter'][1])) # metrisch { $_POST['pidfilter'][1]=str_replace(' ','',$_POST['pidfilter'][1]); $qPID = $pdo->query("SELECT produkte.id,produkte.artikelnr,produkte.normserie,produkte.produktnummerid, normserien.gattung, normserien.serie, normserien.suchindex, normserien.titel, normserien.vtext FROM produkte LEFT JOIN normserien ON produkte.produktnummer = normserien.serie WHERE sprache='".$_SESSION['lang']."' and aktiv=1 and normserien.filter like '%,".$_POST['anwendung'].",%' ".$sql." and ( (normserie = 'ep270' and ( trim(replace(wert4,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert5,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert6,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert7,' ','')) = '".$_POST['pidfilter'][1]."')) or (normserie = 'ep280' and ( trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert10,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert11,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert12,' ','')) = '".$_POST['pidfilter'][1]."')) or (normserie = 'ep283' and ( trim(replace(wert7,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert10,' ','')) = '".$_POST['pidfilter'][1]."' )) or (normserie = 'ep285' and ( trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert10,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert11,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert12,' ','')) = '".$_POST['pidfilter'][1]."')) or (normserie = 'ep320' and ( trim(replace(wert4,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert5,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert6,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert7,' ','')) = '".$_POST['pidfilter'][1]."')) or (normserie = 'ep340' and ( trim(replace(wert5,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert6,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert7,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][1]."')) or (normserie = 'ep350' and ( trim(replace(wert6,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert7,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert10,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert11,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert12,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert13,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert14,' ','')) = '".$_POST['pidfilter'][1]."')) or (normserie = 'ep360' and ( trim(replace(wert6,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert7,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert10,' ','')) = '".$_POST['pidfilter'][1]."' )) or (normserie = 'ep370' and trim(replace(wert5,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep380' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep385' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep400' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep4000' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep434' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep435' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep436' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep437' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep438' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep439' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep440' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep445' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) ) order by normserie, sortierfolge asc "); $ProdukteArray = $qPID->fetchAll(PDO::FETCH_ASSOC); $anzahlprodukte=count($ProdukteArray); }elseif(!empty($_POST['pidfilter'][2])) # Panzer { $_POST['pidfilter'][2]=str_replace(' ','',$_POST['pidfilter'][2]); $qPID = $pdo->query("SELECT produkte.id,produkte.artikelnr,produkte.normserie,produkte.produktnummerid, normserien.gattung, normserien.serie, normserien.suchindex, normserien.titel, normserien.vtext FROM produkte LEFT JOIN normserien ON produkte.produktnummer = normserien.serie WHERE sprache='".$_SESSION['lang']."' and aktiv=1 and normserien.filter like '%,".$_POST['anwendung'].",%' ".$sql." and ( (normserie = 'ep280' and trim(replace(wert14,' ','')) = '".$_POST['pidfilter'][2]."' ) or (normserie = 'ep283' and trim(replace(wert12,' ','')) = '".$_POST['pidfilter'][2]."' ) or (normserie = 'ep285' and trim(replace(wert14,' ','')) = '".$_POST['pidfilter'][2]."' ) or (normserie = 'ep320' and trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][2]."' ) or (normserie = 'ep340' and trim(replace(wert10,' ','')) = '".$_POST['pidfilter'][2]."' ) or (normserie = 'ep350' and trim(replace(wert16,' ','')) = '".$_POST['pidfilter'][2]."' ) ) order by normserie, sortierfolge asc "); $ProdukteArray = $qPID->fetchAll(PDO::FETCH_ASSOC); $anzahlprodukte=count($ProdukteArray); }elseif(!empty($_POST['pidfilter'][3])) # UNF { $_POST['pidfilter'][3]=str_replace(' ','',$_POST['pidfilter'][3]); $qPID = $pdo->query("SELECT produkte.id,produkte.artikelnr,produkte.normserie,produkte.produktnummerid, normserien.gattung, normserien.serie, normserien.suchindex, normserien.titel, normserien.vtext FROM produkte LEFT JOIN normserien ON produkte.produktnummerid = normserien.id WHERE sprache='".$_SESSION['lang']."' and aktiv=1 and normserien.filter like '%,".$_POST['anwendung'].",%' ".$sql." and ( ( normserie = 'ep434' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep435' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep436' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep437' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep438' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep439' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep440' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep445' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) ) order by normserie, sortierfolge asc "); $ProdukteArray = $qPID->fetchAll(PDO::FETCH_ASSOC); $anzahlprodukte=count($ProdukteArray); } elseif(!empty($_POST['pidfilter'][4])) # Massangabe OK 01.03.2018 SHA { $_POST['pidfilter'][4]=str_replace(' ','',$_POST['pidfilter'][4]); $qPID = $pdo->query("SELECT produkte.id,produkte.artikelnr,produkte.normserie,produkte.produktnummerid, normserien.gattung, normserien.serie, normserien.suchindex, normserien.titel, normserien.vtext FROM produkte LEFT JOIN normserien ON produkte.produktnummer = normserien.serie WHERE sprache='".$_SESSION['lang']."' and aktiv=1 and normserien.filter like '%,".$_POST['anwendung'].",%' ".$sql." and ( ( normserie = 'ep207' and wert11+wert6+wert6 =".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep230' and trim(replace(wert2,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert3,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep270' and wert1 =".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep270tk' and trim(replace(wert1,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep275' and trim(replace(wert1,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep280' and trim(replace(wert1,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep283' and trim(replace(wert1,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep285' and trim(replace(wert1,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep285gl' and trim(replace(wert1,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep320' and wert1 =".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep330' and trim(replace(wert2,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert3,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep340' and wert1 =".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep350' and trim(replace(wert2,' ',''))+1 < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert3,' ','')-1) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep360' and trim(replace(wert2,' ',''))+1 < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert3,' ','')-1) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep370' and trim(replace(wert11,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep380' and trim(replace(wert2,' ',''))+1 < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert3,' ','')-1) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep385' and trim(replace(wert2,' ',''))+1 < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert3,' ','')-1) > ".floatval($_POST['pidfilter'][4])." ) ) order by normserie, sortierfolge asc "); $ProdukteArray = $qPID->fetchAll(PDO::FETCH_ASSOC); $anzahlprodukte=count($ProdukteArray); } ?>
CAPTOP® EP 213
QC-Stopfen für SAE-Quick-Connectoren
Schutzanwendung für alle SAE Nennweiten an Steckkupplungen
Flexible Griffkappen mit innenliegender Dichtlippe
CAPTOP® EP 306
Flansch-Abdeckungen für Schnellmontage
CAPTOP® EP 300
Flansch-Kegelstopfen zum Schutz der Dichtleiste
Zertifizierte Produktion
Unsere International anerkannten Zertifizierungen wie UL, CSA, BSA, DIN EN ISO 9001:2015, VDE und VDA 6.1 sind ein Beleg für das hohe Niveau aller einbezogenen Protec Qualitätsicherungssysteme.
Nichts verpassen mit dem Protec Newsletter.
Unser PROTEC Newsletter informiert Sie regelmäßig über wichtige Inhalte, aktuelle Aktionen, neue Serien sowie bevorstehende Veranstaltungen und vieles mehr! Der Newsletter, den Sie kostenlos als E-Mail erhalten, erscheint in der Regel ein Mal im Monat und ist jederzeit kündbar.