RIFF"WEBPVP8 Е�* �>�T�M'��%�u|�� gk�ZaQb�����o����lN���s�_�3��S+���c�€R��y����//����~��H�@�2oF�X ���R@'�:�ꞓ}��a�M,.� ��o��=�p�U�&g<�:���~���t��.�1���cyW�� We�M=�f�Y6v�����(nO���������^- �9(b _�s%{�C|�p�@�����37�}B0��u���i�Գ���� ������5�}���֮M?dz���q�e��N�~�&�N��K�av$]hO�i�C�,��"]�����@����M@�o O[�Æ*;�e]��_; }�p�?��)�'VC� J��L�y� v����18��)7c�d�mߛ�]I� ����d��?�{�.����b)49��c��Zy/��c^��%��/z�å̯�t��rS��Z��Uͩ�h��2����` �7�:��~��zP���Z����?v�R��TD���G����CJ���}�o��fs��̜#b��e"k9,���3�{Or�i��x":���{/ۈ�`�7RČ����(�p:I��%:�ͺ��W(|�=KP��3�7}���������ed��;�3�;�e��8�g�4�9 %v,B�GU�����T% ֯��B+�tR���p������F7�sT��oϱq �h�Rݧ�~*�܈_�Ck���}�nY�>��C�PQ�B��(o�६�qxy������f ���]��}����%=CW�k^t�—]����M�cX�i��%��!�Y������:N=|��wj<9ł��,�s�O�,,�U�!�������e���{���W��989�y*z�=�"E�CyW���N�2�ę��LN�HW��?����`V���DJ=#׶×ܽ$eF���o;b� ��0��&�W���Y�bR�� �Fֵ� `J�an�-Є@�tR�v��e2W��Mn�p��4P1�q ���®w���ũur*�җ.�#�4b���������:���g��ʧ�`R�4�+G�f���niU����$�K-'A�zE&]��Y�H2�4� ��˄�t��Q�4%��L�#��0FS8�Bu����ژ��"����۹�[�JK��4��z�v�ڌ��L*jD0.����?�ڃN��H��J����n�w��6Q(i;��I,.3?|�`���y���D_��(��w��������[��ZYhe�')��D*��kb����c��@� �|S�S3���- ���iq!*��w������Ł��ܩ��*FY���jV�4Q���4�,�ʑV!��N�.�1�KT,��Zp� ���iL�r��Ȧ����"y�tU���PS�ģ��?�QGng_�#yEk��B̝��1hr��ѕ�z*Ԧ�L8T�����H�^�k�-�g�z������w��N����v��RH��E��!0Cؚ)R�@�q�J�qA�r�$k4���om���Ьnu���x�������������y$�8�Z���v� &�+2�|���\r:[,!�Y�C#c��͊�{��7Щ��Y�LVę]�j��)��^���󶦙$�_����Hx>����[ +K�ڏ�1������Q�7@�^{�ik�;'H{�8 �ȇe vR����^� Meq�����Y�MC��U<��O�۫�nAfBf317���x��O�.u@3R}e�`�D��\�z���L��P������y8�?����I�"s`�b 3��ٹd�0��A�/���� ��{b�b������1� ����ka�&T�z�_4���I��PN��8��}N�r��]�՜���ӿ��9�|/.��� �fˑ.�`r�r��U-���7�Rx8L��d$H�m��Ǒ�*x�P{�D�����k��o�ueV�-.��j}���U2��g絍g���s �������aN�X�ҍ���C�� ��X��B�EF���8%p57<�x�Y�e�cϔ�\��C �OAj&N�V���!v��U��~J��j��4�V|��8�R�v�fD�)�HA�3�G��ds�7Z.���= ����+kI2�0=�'� K �H,`�ɴāTE\����E�'/��;���;��a���0"��� �x$J�T��#U=������j-�8�����y c8W����Ԋ�K��_��Y� '%Vg$I�Пq�shE�y�:�m�}�F1(:b�U�~� ���0}�C�}0����#�#}���e�S9��.��SP�m���<�~�y��� ��ɭ�ٮ6N��� ğ��t��A��N�V ������f�+�w�O1�Jq���U�B�T��į���� ��*�=z�x"yU S���� ��// ����W᫮��R�O�2W�M��<-�;�F�`9 �����t�:C{a�8�� <�r'���:�g8%�9J̞�˦��eV�7l�~�#����.yY)$��k�|�!�3���m���XS���J4B���`�����oL[]��aT[�C��@h�T�l��_�e>�����K<'��P�zgk�#fm��V�]�ݽ�j1����H��J��J58��ڱ��@�e&*�w��e���Q��HT8�ֽ��\�Fa�栆�A�ڝӚ׹@�:9`��G�h�7����t<���_˒|�\bU�O�����,M�a�oynGf�޶7�w�i`�m[��XE4�*�8}5��U1���^�B*��_%[����Yb�^���S�l�"A�1�T��ڈ��(???)j�S�n�8v%� Eo��� mE��|�Έ�Ai�3uy5O����7Rܽ���"L��X���1�@�=?5�_'��{j�����Z3L��k��^x6g3i�����r.��N��&��9[��ɓW[+�� 7�����fe�3�K�%��0F��+V�ϛ+3�B�p,y;Z�NGK�uWg䁯9�v��t��ǒx�JY�O��K�iY��#FJy�Bzt�Q^�Y��Uϲ-͖��9��g�X,�X] f�P/�]d�䠾�̔m%Q��겓\q(�%'����/EN�P�1�o��� ���}��'��c�F��Ju��4��0ck�N��w�1��&]a ��^I�)����֓��\;�1��3��� �L��{>�+���a��Jg��#����P���>�5�a<�`>>˔�]�ߎey�-T���ʵ���r���8`dmNm���_mӐK�Ҏ-޴�� ��RQ%�d�l"��l�_��ie0.�$Xh|.jv,���l\ uyj�u\�/� B:�܀�]� _��T��I���lz�&c�A�g{g��O˂�O���O�M�t��7Y�~? ቶ`�7��'�w��#���˚�\��_��� a��d���[Ҭњ��]ɢ�A$ �l�v=E�66d �WA\̬fsǭ}x;';���?�UW�O��{�&|_a�C� |ȹ��pka�|���zf[S�������[�Jcf�A�&�L�U)Pd+)�_�$1�0�z�'�v\u�' +;�!���dž�]h�N�{ku��<��a��.0�,��]q��ZKao=ILo�z�rb&�{@K�i*7nX).�/�̶��ӒU�v �B֝���a��n��تx ���P�AG7M4N�?r;Z�����7�@�wA�q��RM5�8ۭ ��g��8�g���G�Tſ�O�{2��P3r��6�W,/��kC���p�V���~�"���T���6�/<�4�U�>��T�H�Fc�T�D�^I���!�����=&\Em�>b�,|T��d���n��=@\Wzi���D��&�f���1�t�mC�Ih��m��&�������84�!H�i�|�Z���� ��W���g����8�h�B] OvQ�u����+�}n�� FE�+q�&j����I�u��&��=!��T�b�@�ք0 �D�W�W�t�V}�������^�g�Erb`j��2 �wr�\Y5��L�Ρ���_�bNU�)~�e�Z�U�*�����:�vƀu2�W-W��W{KKo0�)��G�K.��{̮���v�/��p� !�� �w;`��b ������F���/���:����I�lm��Vc�,x~m<=|�_�>n����(A�����{�膾���m�,{3 �ӀH=٘�%��[USd��!J�|�f_�/ �߻��)I%���G�ܑ�G |N������d��BU5��qvG�c,���A?!��w��� �S��-i���Fr�P�_��E�+��)��V��f��������~�����������}"sk��cHN�<� 5I�r��1gu�ݗ�,N�I��f��k�s���0��: 0�<�\ͩB�܄ �:�f2A��mҞ�Z�6��3��t�����͟~����J�R9�] �,h������Z�@�{����9��W�il!�:��P��P���wK)���p���!���KuB\�7 uI�?(���/��r3����v,\'�8��qUa�ء���!��(b��n?�YfӸ����r�$���ה�~��_�&�8g�<(Mx$ZO�������u`q��:�N�Q !�%`���h:�� �~>�D���m�^��[V!y�6=� ��m��ѡ��p4�Iꎸ��1cE��QS�ٷ��W�C����*�����Q��=��3���&���-#,åCCG�������9�i��3�C��S[t>���qm����B��s���������o��� J�^s|����r��\ԺΦ�a�{��1��wT'���� �̓Q���B��\xx}��8��Of!��U�n��f�����bA��UD�cC} �r�������c ���^�X���k�Ɩk�6��^E�C�E�sՀ`�Ⱦ,i��v�� ٺe˟�!�co�64x4��A�ah��ˏ<��%�@�*|�\�TY����#:9��|?S�[������G hUw9���z]��D��-J6�m,ʭ��2�Iz�4W9��&���t�߁ R�Z�gP��H�dj�`%ap}�^떟��*fb{�Q) Dd_V����$��,�߁� @D�&f�2��S6��M�ɤ�)Q\F�i���5p��Wb'PN�R�>�����9��]��\8{B8�� ��ю�������%� ӏۙ{]�j,_Y>��!�l���'���H�["��;c?cy��1< 0ϑ���/�AAЛ�� ; �j�(!��1 [)5ݻK ��A7��"[�%"���{��H ���V�� ���m�K���VLn��9鿹8�At΀@����f`�1y�rЅ��q��7Nf���x)y��, 0e�"{�ƨ�"� o �6� �.|Tm.���-r �G� [ed���–q���]�X�oG*�1>�� م�p_Y{δ(N�|s��^{i�`��͒ QӴx+X.ݕ�kP�g]�޿�4��Q|�O��h�*c�W�G�4{~x�k��A:�{Yu�倀#ތM�K!�e�;ȩ����r������'���D&H�$�0�ߜ�w��Sq dH��P�y����z����h��d��"�;0��#I2�F{����. W�wl���|>s�\ŌO�&bO/4(z9ܭua��`��_3d�Qpt�/�P -��#5�,�M��� �pA:©�q�����NW��ډ�A���� �9nʺج���� �TSM��{J6?7��r�@�\����D��� �׶���s�f�TJj?"��D��`?��̒� b�#�%�C*v�$�{�$����5Ծ�F�s��y�e/8��h-�f�̰&(����Gj�L:U� 2�� ����v�_k����Y��gp,�k�WF�R������_C�R��N@���R�@�ߔ?A�w9���F("iNa-S���Q�o�3tDMLh*�#4k�T/iQ��Y*�G��m����)��8�hBm/�I�,g�ﯖ���Z��}�Cz�q@´��d.����L�ŕ�,��1�Z�܌�: ̪���F+J-'��c�tvJ8��]Q-��b��y �6;*J`r_�d ��'�G ~p��)'�C,�%F��E(��2�k�����lР�z�!�=t ��_�0��f7��� ;�p�|�U �% PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, ]); $tablePeriodi = 'tabella_periodi'; $tablePrezzi = 'prezzi'; // mappa: tabella sorgente => anno di default $sourceMaps = [ 'prezziario2023' => 2023, 'prezziario2024' => 2024, 'prezziario2025' => 2025, ]; // Se vuoi pulire prima i dati del 2023 in poi $pdo->exec("DELETE FROM tabella_periodi"); $pdo->exec("DELETE FROM prezzi"); // opzionale filtro per ridurre il set $where = ''; // es. "WHERE numid IN (334,335)" /* ---------- util ---------- */ function clean($v): string { return trim(preg_replace('/\s+/u', ' ', strip_tags((string)$v))); } function parsePeriodo(?string $raw, int $year): ?array { if (!$raw) return null; $s = clean($raw); if (!preg_match('/Dal\s*(\d{1,2})\/(\d{1,2})\s*al\s*(\d{1,2})\/(\d{1,2})/iu', $s, $m)) return null; [$all,$d1,$m1,$d2,$m2] = $m; return [ 'start' => sprintf('%04d-%02d-%02d', $year, (int)$m1, (int)$d1), 'end' => sprintf('%04d-%02d-%02d', $year, (int)$m2, (int)$d2), ]; } function parsePrezzo(?string $raw): ?array { if (!$raw) return null; $s = clean($raw); if (!preg_match('/([\d\.\,]+)\s*(?:€)?/u', $s, $pm)) return null; $num = str_replace(['.', '€', ' '], '', $pm[1]); $num = str_replace(',', '.', $num); $price = (float)$num; // solo MAX pax $max = null; if (preg_match('/\((\d+)\s*-\s*(\d+)\s*pax\)/iu', $s, $xm)) { $max = (int)$xm[2]; } elseif (preg_match('/\((\d+)\s*pax\)/iu', $s, $xm)) { $max = (int)$xm[1]; } return ['price'=>$price, 'max_pax'=>$max ?? 1]; } function buildColumnLists(): array { $periodCols = []; for ($i=1; $i<=5; $i++) $periodCols[] = "Periodo{$i}"; $priceCols = []; for ($i=1; $i<=8; $i++) $priceCols[] = "Prezzo{$i}"; return [$periodCols, $priceCols]; } /* ---------- core per una tabella sorgente ---------- */ function processSourceTable(PDO $pdo, string $sourceTable, int $defaultYear, string $where, string $tablePeriodi, string $tablePrezzi): array { [$periodCols, $priceCols] = buildColumnLists(); // includo l’etichetta "Periodo" $cols = array_merge(['idPrezziario','numid','Anno','Periodo'], $periodCols, $priceCols); $selectCols = implode(',', array_map(fn($c)=>"`$c`", $cols)); $sql = "SELECT $selectCols FROM `{$sourceTable}` " . ($where ? $where.' ' : '') . "ORDER BY idPrezziario ASC"; $stmt = $pdo->query($sql); // prepared statements $chkAnnuncio = $pdo->prepare("SELECT 1 FROM annuncio WHERE IdAnnuncio = :id LIMIT 1"); $insPeriodo = $pdo->prepare(" INSERT INTO `{$tablePeriodi}` (id_annuncio, etichetta, data_inizio, data_fine) VALUES (:id_annuncio, :etichetta, :data_inizio, :data_fine) "); $insPrezzo = $pdo->prepare(" INSERT INTO `{$tablePrezzi}` (id_periodo, numero_persone, prezzo_euro) VALUES (:id_periodo, :numero_persone, :prezzo_euro) "); $cntPeriodi = 0; $cntPrezzi = 0; $skippedNoParent = []; while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { // skip righe senza Periodo1 valido $p1 = isset($row['Periodo1']) ? strtoupper(trim(clean($row['Periodo1']))) : ''; if ($p1 === 'NO') continue; $year = (isset($row['Anno']) && is_numeric($row['Anno'])) ? (int)$row['Anno'] : $defaultYear; $etichetta = isset($row['Periodo']) ? clean($row['Periodo']) : ''; // costruisci periodi $periodi = []; foreach ($periodCols as $i => $col) { $raw = $row[$col] ?? null; if ($raw && stripos($raw, 'NO') === false) { $pp = parsePeriodo($raw, $year); if ($pp) $periodi[$i+1] = $pp; } } if (!$periodi) continue; // prezzi $prezzi = []; foreach ($priceCols as $col) { $raw = $row[$col] ?? null; if ($raw) { $pz = parsePrezzo($raw); if ($pz) $prezzi[] = $pz; } } // verifica esistenza annuncio $chkAnnuncio->execute([':id' => $row['numid']]); if (!$chkAnnuncio->fetchColumn()) { $skippedNoParent[$row['numid']] = true; continue; } // inserisci foreach ($periodi as $p) { $pdo->beginTransaction(); try { $insPeriodo->execute([ ':id_annuncio' => $row['numid'], ':etichetta' => $etichetta, ':data_inizio' => $p['start'], ':data_fine' => $p['end'], ]); $idPeriodo = (int)$pdo->lastInsertId(); $cntPeriodi++; foreach ($prezzi as $z) { // formato "1000,70" $prezzoForm = number_format($z['price'], 2, ',', ''); $insPrezzo->execute([ ':id_periodo' => $idPeriodo, ':numero_persone' => $z['max_pax'], ':prezzo_euro' => $prezzoForm, ]); $cntPrezzi++; } $pdo->commit(); } catch (Throwable $e) { $pdo->rollBack(); throw $e; } } } return [ 'periodi' => $cntPeriodi, 'prezzi' => $cntPrezzi, 'skipped' => array_keys($skippedNoParent), ]; } /* ---------- run ---------- */ try { $totPeriodi = 0; $totPrezzi = 0; $logSkip = []; foreach ($sourceMaps as $table => $year) { $res = processSourceTable($pdo, $table, $year, $where, $tablePeriodi, $tablePrezzi); $totPeriodi += $res['periodi']; $totPrezzi += $res['prezzi']; if ($res['skipped']) $logSkip[$table] = $res['skipped']; } header('Content-Type: text/plain; charset=utf-8'); echo "Completato.\n"; echo "Totale periodi inseriti: {$totPeriodi}\n"; echo "Totale prezzi inseriti: {$totPrezzi}\n"; foreach ($logSkip as $tab => $ids) { echo "Saltati (annuncio mancante) in {$tab}: ".implode(',', $ids)."\n"; } } catch (Throwable $e) { http_response_code(500); header('Content-Type: text/plain; charset=utf-8'); echo "Errore: ".$e->getMessage(); }