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 �%getPDO(); $action = $_POST['action'] ?? ''; switch ($action) { case 'edit_periodo': { $idAnnuncio = (int)($_POST['id_annuncio'] ?? 0); $id = (int)($_POST['id_periodo'] ?? 0); $ini = $_POST['data_inizio'] ?? ''; $fin = $_POST['data_fine'] ?? ''; $etic = trim($_POST['etichetta'] ?? ''); if (!$id || !$idAnnuncio || !$ini || !$fin) exit('Dati periodo non validi'); $stmt = $pdo->prepare("UPDATE tabella_periodi SET data_inizio=?, data_fine=?, etichetta=? WHERE id=? AND id_annuncio = ?"); $stmt->execute([$ini, $fin, $etic, $id, $idAnnuncio]); break; } case 'add_periodo': { // ID del periodo di origine (da cui copiare i prezzi) $idPeriodoOrigine = (int)($_POST['id_periodo'] ?? 0); // ID annuncio (OBBLIGATORIO) $idAnnuncio = (int)($_POST['id_annuncio'] ?? 0); $ini = $_POST['data_inizio'] ?? ''; $fin = $_POST['data_fine'] ?? ''; $etic = trim($_POST['etichetta'] ?? ''); if ($idAnnuncio < 1 || $ini === '' || $fin === '' || $etic === '') { exit('Dati periodo non validi'); } /** * 🔒 VERIFICA DI SICUREZZA * Il periodo di origine DEVE appartenere allo stesso annuncio */ if ($idPeriodoOrigine > 0) { $stmtCheck = $pdo->prepare(" SELECT COUNT(*) FROM tabella_periodi WHERE id = ? AND id_annuncio = ? "); $stmtCheck->execute([$idPeriodoOrigine, $idAnnuncio]); if ($stmtCheck->fetchColumn() == 0) { exit('Periodo origine non valido per questo annuncio'); } } /** * ➕ INSERIMENTO NUOVO PERIODO */ $stmtInsert = $pdo->prepare(" INSERT INTO tabella_periodi (id_annuncio, etichetta, data_inizio, data_fine) VALUES (?, ?, ?, ?) "); $stmtInsert->execute([$idAnnuncio, $etic, $ini, $fin]); $nuovoIdPeriodo = (int)$pdo->lastInsertId(); if ($nuovoIdPeriodo < 1) { exit('Errore: impossibile ottenere ID nuovo periodo'); } /** * 🔁 DUPLICAZIONE PREZZI (se il periodo di origine ne aveva) */ if ($idPeriodoOrigine > 0) { $stmtDuplica = $pdo->prepare(" INSERT INTO prezzi (id_periodo, min_persone, numero_persone, prezzo_euro, sigla) SELECT ?, min_persone, numero_persone, prezzo_euro, sigla FROM prezzi WHERE id_periodo = ? "); $stmtDuplica->execute([$nuovoIdPeriodo, $idPeriodoOrigine]); } break; } case 'delete_periodo': { $idAnnuncio = (int)($_POST['id_annuncio'] ?? 0); $id = (int)($_POST['id_periodo'] ?? 0); if (!$id || !$idAnnuncio) exit('id_periodo mancante'); // Se NON hai FK ON DELETE CASCADE, prima cancella i prezzi: // $pdo->prepare("DELETE FROM tabella_prezzi WHERE id_periodo=?")->execute([$id]); $pdo->prepare(" DELETE FROM tabella_periodi WHERE id = ? AND id_annuncio = ? ")->execute([$id, $idAnnuncio]); break; } case 'edit_prezzo': { $idAnnuncio = (int)($_POST['id_annuncio'] ?? 0); $etichetta = trim($_POST['etichetta'] ?? ''); $oldMin = (int)($_POST['old_min'] ?? 0); $oldNum = (int)($_POST['old_num'] ?? 0); $newMin = (int)($_POST['min_persone'] ?? 0); $newNum = (int)($_POST['numero_persone'] ?? 0); $sigla = $_POST['sigla'] ?? ""; $prez = trim($_POST['prezzo_euro'] ?? ''); if ($idAnnuncio < 1 || $etichetta === '' || $oldMin < 1 || $oldNum < 1 || $newMin < 1 || $newNum < 1 || $prez === '') { exit('Dati prezzo non validi'); } $prez = str_replace('.', '', $prez); $stmt = $pdo->prepare(" UPDATE prezzi pr JOIN tabella_periodi p ON p.id = pr.id_periodo SET pr.min_persone = ?, pr.numero_persone = ?, pr.prezzo_euro = ?, pr.sigla = ? WHERE p.id_annuncio = ? AND p.etichetta = ? AND pr.min_persone = ? AND pr.numero_persone = ? "); $stmt->execute([ $newMin, $newNum, $prez, $sigla, $idAnnuncio, $etichetta, $oldMin, $oldNum ]); break; } case 'delete_prezzo': { $idAnnuncio = (int)($_POST['id_annuncio'] ?? 0); $etichetta = trim($_POST['etichetta'] ?? ''); $min = (int)($_POST['min_persone'] ?? 0); $num = (int)($_POST['numero_persone'] ?? 0); $sigla = trim($_POST['sigla'] ?? ''); if ($etichetta === '' || $min < 1 || $num < 1) { exit('Dati prezzo non validi'); } $stmt = $pdo->prepare(" DELETE pr FROM prezzi pr JOIN tabella_periodi p ON p.id = pr.id_periodo WHERE p.id_annuncio = ? AND p.etichetta = ? AND pr.min_persone = ? AND pr.numero_persone = ? AND (pr.sigla = ? OR (pr.sigla IS NULL AND ? = '')) "); $stmt->execute([$idAnnuncio, $etichetta, $min, $num, $sigla, $sigla]); break; } case 'add_prezzo': { //var_dump($_POST); $id_annuncio = (int)$_POST['id_annuncio'] ?? 0; $etichetta = trim($_POST['etichetta'] ?? ''); $min = (int)($_POST['min_persone'] ?? 0); $num = (int)($_POST['numero_persone'] ?? 0); $prez = trim($_POST['prezzo_euro'] ?? ''); $sigla = trim($_POST['sigla'] ?? ''); if ($id_annuncio < 1 || $etichetta === '' || $min < 1 || $num < 1 || $prez === '') { exit('Dati prezzo non validi'); } $prez = str_replace('.', '', $prez); // Inserisce la fascia su TUTTI i periodi dell’etichetta $stmt = $pdo->prepare(" INSERT INTO prezzi (id_periodo, min_persone, numero_persone, prezzo_euro, sigla) SELECT p.id, ?, ?, ?, ? FROM tabella_periodi p WHERE p.id_annuncio = ? AND p.etichetta = ? "); $stmt->execute([$min, $num, $prez, $sigla, $id_annuncio, $etichetta]); break; } default: exit('Azione non riconosciuta'); } // dopo l’azione torna alla pagina precedente header('Location: '.$_SERVER['HTTP_REFERER']); exit;