Action = "insert"; $InsertQuery->Table = "wheretrfstep"; $InsertQuery->bindColumn("idtrf", "i", "$idtrf", "WA_DEFAULT"); $InsertQuery->bindColumn("code", "i", "$code", "WA_DEFAULT"); $InsertQuery->saveInSession(""); $InsertQuery->execute(); $InsertGoTo = ""; $InsertQuery->redirect($InsertGoTo); } ?> setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.idtrfdetails='$idtrf'"); $trfnumberfinal->execute(); $idcertn = $trfnumberfinal->getColumnVal("idcertification"); $idarticletype = $trfnumberfinal->getColumnVal("idarticletype"); $modelidart = $trfnumberfinal->getColumnVal("model"); ?> $ones, 2 => $twos, 4 => $fours, 5 => $fives, 7 => $sevens, 8 => $eights, 10 => $tens, 11 => $elevens, 12 => $twelves, 13 => $thirteens, 14 => $fourteens, 15 => $fifteens, 16 => $sixteens, 18 => $eighteens, 19 => $nineteens, 20 => $twentys ]; } elseif ($idarticletype == "2") { include('languages/' . $_SESSION['langselect'] . '/glovesnamepart.php'); $parts = [ 1 => $oneg, 2 => $twog, 3 => $threeg, 4 => $fourg ]; } elseif ($idarticletype == "3") { include('languages/' . $_SESSION['langselect'] . '/semimask.php'); $parts = [ 1 => $onem, 2 => $twom, 3 => $threem, 4 => $fourm, 5 => $fivem, 6 => $sixm ]; } elseif ($idarticletype == "4") { // Abbigliamento if ($modelidart == 11) { // Camice include('languages/' . $_SESSION['langselect'] . '/ind1.php'); $parts = [ 1 => $ind_one, 2 => $ind_two, 3 => $ind_three, 4 => $ind_four, 5 => $ind_five ]; } elseif ($modelidart == 12 && $hivis == 'N') { // Felpa standard include('languages/' . $_SESSION['langselect'] . '/ind3.php'); $parts = [ 1 => $ind_one, 2 => $ind_two, 3 => $ind_three, 4 => $ind_four, 5 => $ind_five, 6 => $ind_six, 7 => $ind_seven ]; } elseif ($modelidart == 12 && $hivis == 'Y') { // Felpa Hi-Vis include('languages/' . $_SESSION['langselect'] . '/ind2.php'); $parts = [ 1 => $ind_one, 2 => $ind_two, 3 => $ind_three, 4 => $ind_four, 5 => $ind_five, 6 => $ind_six, 7 => $ind_seven, 'RM' => $ind_rm, 'FM' => $ind_fm ]; } elseif ($modelidart == 13 && $hivis == 'N') { // Giacca standard include('languages/' . $_SESSION['langselect'] . '/ind5.php'); $parts = [ 1 => $ind_one, 2 => $ind_two, 3 => $ind_three, 4 => $ind_four, 5 => $ind_five, 6 => $ind_six, 7 => $ind_seven ]; } elseif ($modelidart == 13 && $hivis == 'Y') { // Giacca Hi-Vis include('languages/' . $_SESSION['langselect'] . '/ind4.php'); $parts = [ 1 => $ind_one, 2 => $ind_two, 3 => $ind_three, 4 => $ind_four, 5 => $ind_five, 6 => $ind_six, 7 => $ind_seven, 'RM' => $ind_rm, 'FM' => $ind_fm ]; } elseif ($modelidart == 14 && $hivis == 'N') { // Modello 14 standard (es. Pantaloni) include('languages/' . $_SESSION['langselect'] . '/ind14.php'); $parts = [ 1 => $ind_one, // es. Tasca anteriore 2 => $ind_two, // es. Tasca posteriore 3 => $ind_three // es. Ginocchiera ]; } elseif ($modelidart == 14 && $hivis == 'Y') { // Modello 14 Hi-Vis include('languages/' . $_SESSION['langselect'] . '/ind14_hivis.php'); $parts = [ 1 => $ind_one, // es. Tasca anteriore 2 => $ind_two, // es. Tasca posteriore 3 => $ind_three, // es. Ginocchiera 'RM' => $ind_rm, // Banda riflettente 'FM' => $ind_fm // Striscia fluorescente ]; } elseif ($modelidart == 15 && $hivis == 'N') { // Modello 15 standard (es. Gilet) include('languages/' . $_SESSION['langselect'] . '/ind15.php'); $parts = [ 1 => $ind_one, // es. Tasca sul petto 2 => $ind_two // es. Zip frontale ]; } elseif ($modelidart == 15 && $hivis == 'Y') { // Modello 15 Hi-Vis include('languages/' . $_SESSION['langselect'] . '/ind15_hivis.php'); $parts = [ 1 => $ind_one, // es. Tasca sul petto 2 => $ind_two, // es. Zip frontale 'RM' => $ind_rm, // Banda riflettente 'FM' => $ind_fm // Striscia fluorescente ]; } elseif ($modelidart == 16 && $hivis == 'N') { // Modello 16 standard (es. Maglia) include('languages/' . $_SESSION['langselect'] . '/ind16.php'); $parts = [ 1 => $ind_one, // es. Manica 2 => $ind_two, // es. Colletto 3 => $ind_three // es. Orlo ]; } elseif ($modelidart == 16 && $hivis == 'Y') { // Modello 16 Hi-Vis include('languages/' . $_SESSION['langselect'] . '/ind16_hivis.php'); $parts = [ 1 => $ind_one, // es. Manica 2 => $ind_two, // es. Colletto 3 => $ind_three, // es. Orlo 'RM' => $ind_rm, // Banda riflettente 'FM' => $ind_fm // Striscia fluorescente ]; } elseif ($modelidart == 17 && $hivis == 'N') { // Modello 17 standard (es. Giubbotto) include('languages/' . $_SESSION['langselect'] . '/ind17.php'); $parts = [ 1 => $ind_one, // es. Cappuccio 2 => $ind_two, // es. Tasca laterale 3 => $ind_three, // es. Polsino 4 => $ind_four // es. Fodera ]; } elseif ($modelidart == 17 && $hivis == 'Y') { // Modello 17 Hi-Vis include('languages/' . $_SESSION['langselect'] . '/ind17_hivis.php'); $parts = [ 1 => $ind_one, // es. Cappuccio 2 => $ind_two, // es. Tasca laterale 3 => $ind_three, // es. Polsino 4 => $ind_four, // es. Fodera 'RM' => $ind_rm, // Banda riflettente 'FM' => $ind_fm // Striscia fluorescente ]; } elseif ($modelidart == 18 && $hivis == 'N') { // Modello 18 standard (es. Salopette) include('languages/' . $_SESSION['langselect'] . '/ind18.php'); $parts = [ 1 => $ind_one, // es. Bretelle 2 => $ind_two, // es. Tasca pettorale 3 => $ind_three, // es. Tasca laterale 4 => $ind_four, // es. Ginocchiera 5 => $ind_five // es. Cintura ]; } elseif ($modelidart == 18 && $hivis == 'Y') { // Modello 18 Hi-Vis include('languages/' . $_SESSION['langselect'] . '/ind18_hivis.php'); $parts = [ 1 => $ind_one, // es. Bretelle 2 => $ind_two, // es. Tasca pettorale 3 => $ind_three, // es. Tasca laterale 4 => $ind_four, // es. Ginocchiera 5 => $ind_five, // es. Cintura 'RM' => $ind_rm, // Banda riflettente 'FM' => $ind_fm // Striscia fluorescente ]; } elseif ($modelidart == 19 && $hivis == 'N') { // Tuta standard include('languages/' . $_SESSION['langselect'] . '/ind19.php'); $parts = [ 1 => $ind_one, 2 => $ind_two, 3 => $ind_three, 4 => $ind_four, 5 => $ind_five, 6 => $ind_six, 7 => $ind_seven, 8 => $ind_eight, 9 => $ind_nine ]; } elseif ($modelidart == 19 && $hivis == 'Y') { // Tuta Hi-Vis include('languages/' . $_SESSION['langselect'] . '/ind19_hivis.php'); $parts = [ 1 => $ind_one, 2 => $ind_two, 3 => $ind_three, 4 => $ind_four, 5 => $ind_five, 6 => $ind_six, 7 => $ind_seven, 8 => $ind_eight, 9 => $ind_nine, 'RM' => $ind_rm, 'FM' => $ind_fm ]; } } // Aggiungi altri casi per $idarticletype == 4 o altri tipi se necessario ?> getColumnVal("idcertification") ?> setQuery("SELECT * FROM certificationtype WHERE certificationtype.idcertificationtype='$idcert'"); $certname->execute(); ?> Action = "insert"; $InsertQuery->Table = "identificationparts"; $InsertQuery->bindColumn("description_identificationparts", "s", "$descriptionpartvalue", "WA_DEFAULT"); $InsertQuery->bindColumn("article_identificationparts", "s", "$articlepartvalue", "WA_DEFAULT"); $InsertQuery->bindColumn("material_identificationparts", "s", "$materialpartvalue", "WA_DEFAULT"); $InsertQuery->bindColumn("color_identificationparts", "s", "$colorvalue", "WA_DEFAULT"); $InsertQuery->bindColumn("cmcreportnumber_identificationparts", "s", "$cmcreportnumber", "WA_DEFAULT"); $InsertQuery->bindColumn("cmcreportdate_identificationparts", "t", "$cmcdatereport", "WA_DEFAULT"); $InsertQuery->bindColumn("reportof", "s", "$reportof", "WA_DEFAULT"); $InsertQuery->bindColumn("idtrfdetails", "i", "$idtrf", "WA_DEFAULT"); $InsertQuery->bindColumn("kindoftest", "s", "$kindoftest", "WA_DEFAULT"); $InsertQuery->bindColumn("partsidnumber", "s", "$partid", "WA_DEFAULT"); $InsertQuery->bindColumn("arttypeid", "i", "$arttypeid", "WA_DEFAULT"); $InsertQuery->bindColumn("useridn", "i", "$useridn", "WA_DEFAULT"); $InsertQuery->bindColumn("companyidn", "i", "$companyidn", "WA_DEFAULT"); $InsertQuery->saveInSession(""); $InsertQuery->execute(); $InsertGoTo = ""; $InsertQuery->redirect($InsertGoTo); } ?> setQuery("SELECT * FROM identificationparts WHERE identificationparts.idtrfdetails='$idtrf' ORDER BY identificationparts.partsidnumber "); $listinsertedpart->execute(); ?> <?php echo $titlepage; ?>TRF CIMAC

90%

" disabled>
Ex:
">