�����JFIF��XX����������    $.' ",#(7),01444'9=82<.342  2!!22222222222222222222222222222222222222222222222222�����"����4���������������������������� ���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������,�PG"Z_�4�˷����kjز�Z�,F+��_z�,�© �����zh6�٨�ic�fu������������������������������������#ډb���_�N��?�����������wQ���5-�~�I���8���������������������������������TK<5o�Iv-������������������k�_U_������������������������������~b�M��d��������Ӝ�U�Hh��?]��E�w��Q���k�{��_}qFW7HTՑ��Y��F�����?_�'ϔ��_�Ջt������������������������=||I �����6�έ"�����D���/[�k�9����Y�8������ds|\���Ҿp6�Ҵ���]��.����6���z<�v��@]�i%������������������������$j��~����g��J>��no����pM[me�i$[�����������s�o�ᘨ�˸ nɜG-�ĨU�ycP���3.DB�li�;���������������������hj���x����7Z^�N�h��������N3u{�:j�����x�힞��#M��&��jL P@��_���� P�������������������&��o8��������9������@Sz���6�t7#O�ߋ �����s}Yf�T������lmr����Z)'N��k�۞p�����w\�T���������������ȯ?�8`���O��i{wﭹW�[�r�� ��Q4F�׊������3m&L�=��h3�������z~��#����\�l :�F,j@�� ʱ�wQT����8�"kJO����6�֚l������������������}����R�>ډK���]��y����&����p�}b������;N�1�m�r$����|��7�>e�@���B�TM*-i�H��g�D�)� E�m�|�ؘbҗ�a���Ҿ����������������t4�����o���G��*oCN�rP���Q��@z,|?W[0���������:�n,j���WiE��W������$~/�hp\��?��{(�0���+�Y8rΟ�+����>S-S���������������VN;���}�s?.����� w��9��˟<���Mq4�Wv'������{)0�1mB����V����W[��������8�/<� �%���wT^�5���b��)iM� p�g�N�&ݝ������������VO~��q���u���9��� ����!��J27�����$����O-���! �:���%H��� ـ�������y�ΠM=t{!S�� �oK8�������t<����è��������:a��������[������ա�H���~��w��Qz`�p����o�^ ������Q��n����� �,uu�C��$ ^���,�������8�#��:�6��e�|~�����������!�3��3.�\0�����q��o�4`.|� ����y�Q�`~;�d�ׯ,��O�Zw�������`73�v�܋�<�����Ȏ�� ـ4k��5�K�a�u�=9Yd��$>x�A�&�� j0� ���vF��� Y���|�y��� ~�6�@c��1vOp��������Ig�����4��l�OD�����L����� R���c���j�_�uX�6��3?nk��Wy�f;^*B� ��@���~a�`��Eu�������+�����6�L��.ü>��}y���}_�O�6�͐�:�Yr���G�X��kG������l^w����������~㒶sy���Iu�!���� W ��X��N�7BV��O��!X�2����wvG�R�f�T#�����t�/?���%8�^�W�aT����G�cL�M���I��(J����1~�8�?aT ���]����AS�E��(��*E}� 2������#I/�׍qz��^t�̔���������b�Yz4x����t�){ OH�����+(E��A&�N�������XT��o��"�XC����'���)}�J�z�p� ����~5�}�^����+�6����w��c��Q�|�Lp�d�H��}�(�.|����k��c4^�����"�����Z?ȕ ��a<�������L�!0�39C� �Eu�����C�F�Ew�ç ;�n?�*o���B�8�bʝ���'#Rqf����M}7����]�������s2tcS{�\icTx;�\��7K���P������ʇ Z O-��~�������c>"��?��������P�����E��O�8��@�8��G��Q�g�a�Վ���󁶠��䧘��_%#r�>�����1�z�a���eb��qcP��ѵ��n���#L��� =��׀t� L�7�`�����V����A{�C:�g���e@�����w1 Xp�3�c3�ġ�������p��M"'-�@n4���fG���B3�DJ�8[Jo�ߐ���gK)ƛ��$���� �������8�3�����+���� �����6�ʻ���� ���S�kI�*KZlT _`�������?��K�����QK�d���������B`�s}�>���`������*�>��,*@J�d�oF*�����弝��O}�k��s��]��y�ߘ�������c1G�V���<=�7��7����6��q�PT��tXԀ�!9*4�4Tހ���3XΛex�46�������Y��D ����� ����BdemDa����\�_l,����G�/���֌7���Y�](�xTt^%�GE�����4�}bT����ڹ�����;��Y)���B�Q��u��>J/J ���⮶.�XԄ��j�ݳ������+E��d ���r�5�_D�����1 ���o�� �B�x�΢�#����<��W�����8���R6�@���g�M�.��� dr�D��>(otU��@�x=��~v���2� ӣ�d�oBd�����3�eO�6�㣷����������ݜ�6��6Y��Qz`����S��{���\P��~z m5{J/L��1������<�e�ͅPu���b�]�ϔ��������'�������f�b� Zpw��c`"��i���BD@:)ִ�:�]��h���v�E��w���T�l�������P����"Ju�}��وV ��J��G6��. J/�Qgl߭�e�����@�z�Zev2u����)]կ���������7x�������s�M�-<ɯ�c��r��v�����@��$�ޮ}lk���a����'����>x��O\�Z������Fu>������ck#��&:��`�$��ai�>2Δ����l���oF[h�������lE�ܺ�Π���k:)���`������� $[6�����9�����kOw�\|�����8}������ބ:��񶐕��������I�A1/���=�2[�,�!��.}gN#�u����b���� ~���������݊��}34q�����d�E��L��������c��$���"�[q�U�硬g^��%B ��z���r�p�������J�ru%v\h�����1Y�ne`������ǥ:g����pQM~�^��Xi� ��`S�:V2������9.�P���V������?B�k�� ��������AEvw%�_�9C�Q����wKekP�ؠ�\������;Io d�{ ߞo�c1eP�����\� `����E=���@K<�Y��������eڼ�J����w����{av�F�'�M�@��������������/J��+9p����|]���������Iw &`���8���&�M�hg���[�{�������Xj���%��Ӓ�������������������$��(�����ʹN�������<>�I���RY�����K2�NPlL�ɀ�)��&e��������B+ь����(������������������� � �JTx����_?EZ� }@���� 6�U���뙢ط�z��dWI��n` D����噥�[��uV��"�G&�����Ú����2�g�}&m���������������������?ċ���"����Om#�������������������������� ��{���������������������ON��"S�X���Ne��ysQ���@�������������Fn��Vg�����dX�~nj����������������������]J�<�K]:����FW���b�������62����������=��5f����JKw����bf�X������������������������55��~J �%^�������:�-�QIE��P��v�nZum� z � ~ə ���� ���ة����;�f��\v�������g�8�1��f2�������������������������4;�V���ǔ�)�������������������9���1\������������������������������c��v�/'Ƞ�w������������������$�4�R-��t����������������������������������� e�6�/�ġ �̕Ecy�J���u�B���<�W�ַ~�w[B1L۲�-JS΂�{���΃�������������������������������������������A��20�c#���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������@���� 0!1@AP"#2Q`$3V�%45a6�FRUq����� ������^7ׅ,$n��������+��F�`��2X'��0vM��p�L=�������5��8������u�p~���.�`r�����\����O��,ư�0oS ��_�M�����l���4�kv\JSd���x���SW�<��Ae�IX����������$I���w�:S���y���›R��9�Q[���,�5�;�@]�%���u�@ *ro�lbI �� ��+���%m:�͇ZV�����u�̉����θau<�fc�.����{�4Ա� �Q����*�Sm��8\ujqs]{kN���)qO�y�_*dJ�b�7���yQqI&9�ԌK!�M}�R�;�������S�T���1���i[U�ɵz�]��U)V�S6���3$K{��ߊ<�(� E]Զ[ǼENg�����'�\?#)Dkf��J���o��v���'�%ƞ�&K�u��!��b�35LX�Ϸ��63$K�a�;�9>,R��W��3�3� d�JeTYE.Mϧ��-�o�j3+y��y^�c�������VO�9NV\nd�1 ��!͕_)a�v;����թ�M�lWR1��)El��P;��yوÏ�u 3�k�5Pr6<�⒲l�!˞*��u־�n�!�l:����UNW ��%��Chx8vL'��X�@��*��)���̮��ˍ��� ����D-M�+J�U�kvK����+�x8��cY������?�Ԡ��~3mo��|�u@[XeY�C�\Kp�x8�oC�C�&����N�~3-H���� ��MX�s�u<`���~"WL��$8ξ��3���a�)|:@�m�\���^�`�@ҷ)�5p+��6���p�%i)P M���ngc�����#0Aruz���RL+xSS?���ʮ}()#�t��mˇ!��0}}y����<�e� �-ή�Ԩ��X������ MF���ԙ~l L.3���}�V뽺�v������멬��Nl�)�2����^�Iq��a��M��qG��T�����c3#������3U�Ǎ���}��לS�|qa��ڃ�+���-��2�f����/��bz��ڐ�� �ݼ[2�ç����k�X�2�* �Z�d���J�G����M*9W���s{��w���T��x��y,�in�O�v��]���n����P�$��JB@=4�OTI�n��e�22a\����q�d���%�$��(���:���: /*�K[PR�fr\nڙdN���F�n�$�4��[�� U�zƶ����� �mʋ���,�ao�u 3�z� �x��Kn����\[��VFmbE;�_U��&V�Gg�]L�۪&#n%�$ɯ��dG���D�TI=�%+AB�Ru#��b4�1�»x�cs�YzڙJG��f��Il���d�eF'T� iA��T���uC�$����Y��H?����[!G`}���ͪ� �纤Hv\������j�Ex�K���!���OiƸ�Yj�+u-<���'q����uN�*�r\��+�]���<�wOZ.fp�ێ��,-*)V?j-kÊ#�`�r��dV����(�ݽBk�����G�ƛk�QmUڗe��Z���f}|����8�8��a���i��3'J�����~G_�^���d�8w������ R�`(�~�.��u���l�s+g�bv���W���lGc}��u���afE~1�Ue������Z�0�8�=e�� f@/�jqEKQQ�J���oN��J���W5~M>$6�Lt�;$ʳ{���^��6�{����v6���ķܰg�V�cnn �~z�x�«�,2�u�?cE+Ș�H؎�%�Za�)���X>uW�Tz�Nyo����s���FQƤ��$��*�&�LLXL)�1�" L��eO��ɟ�9=���:t��Z���c��Ž���Y?�ӭV�wv�~,Y��r�ۗ�|�y��GaF�����C�����.�+� ���v1���fήJ�����]�S��T��B��n5sW}y�$��~z�'�c ��8 ��� ,! �p��VN�S��N�N�q��y8z˱�A��4��*��'������2n<�s���^ǧ˭P�Jޮɏ�U�G�L�J�*#��<�V��t7�8����TĜ>��i}K%,���)[��z�21z ?�N�i�n1?T�I�R#��m-�����������������1����lA�`��fT5+��ܐ�c�q՝��ʐ��,���3�f2U�եmab��#ŠdQ�y>\��)�SLY����w#��.���ʑ�f��� ,"+�w�~�N�'�c�O�3F�������N<���)j��&��,-� �љ���֊�_�zS���TǦ����w�>��?�������n��U仆�V���e�����0���$�C�d���rP �m�׈e�Xm�Vu� �L��.�bֹ��� �[Դaզ���*��\y�8�Է:�Ez\�0�Kq�C b��̘��cө���Q��=0Y��s�N��S.����3.���O�o:���#���v7�[#߫ ��5�܎�L���Er4���9n��COWlG�^��0k�%<���ZB���aB_���������'=��{i�v�l�$�uC���mƎҝ{�c㱼�y]���W�i ��ߧc��m�H� m�"�"�����;Y�ߝ�Z�Ǔ�����:S#��|}�y�,/k�Ld� TA�(�AI$+I3��;Y*���Z��}|��ӧO��d�v��..#:n��f>�>���ȶI�TX��� 8��y����"d�R�|�)0���=���n4��6ⲑ�+��r<�O�܂~zh�z����7ܓ�HH�Ga롏���nCo�>������a ���~]���R���̲c?�6(�q�;5%� |�uj�~z8R�=X��I�V=�|{v�Gj\gc��q����z�؋%M�ߍ����1y��#��@f^���^�>N������#x#۹��6�Y~�?�dfPO��{��P�4��V��u1E1J �*|���%����JN��`eWu�zk M6���q t[�� ��g�G���v��WIG��u_ft����5�j�"�Y�:T��ɐ���*�;� e5���4����q$C��2d�}���� _S�L#m�Yp��O�.�C�;��c����Hi#֩%+) �Ӎ��ƲV���SYź��g |���tj��3�8���r|���V��1#;.SQ�A[���S������#���`n�+���$��$�I �P\[�@�s��(�ED�z���P��])8�G#��0B��[ى��X�II�q<��9�~[Z멜�Z�⊔IWU&A>�P~�#��dp<�?����7���c��'~���5 ��+$���lx@�M�dm��n<=e�dyX��?{�|Aef ,|n3�<~z�ƃ�uۧ�����P��Y,�ӥQ�*g�#먙R�\���;T��i,��[9Qi歉����c>]9�� ��"�c��P�� �Md?٥��If�ت�u��k��/����F��9�c*9��Ǎ:�ØF���z�n*�@|I�ށ9����N3{'��[�'ͬ�Ҳ4��#}��!�V� Fu��,�,mTIk���v C�7v���B�6k�T9��1�*l� '~��ƞF��lU��'�M ����][ΩũJ_�{�i�I�n��$����L�� j��O�dx�����kza۪��#�E��Cl����x˘�o�����V���ɞ�ljr��)�/,�߬h�L��#��^��L�ф�,íMƁe�̩�NB�L�����iL����q�}��(��q��6IçJ$�W�E$��:������=#����(�K�B����zђ <��K(�N�۫K�w��^O{!����)��H���>x�������lx�?>Պ�+�>�W���,Ly!_�D���Ō�l���Q�!�[ �S����J��1��Ɛ�Y}��b,+�Lo�x�ɓ)����=�y�oh�@�꥟/��I��ѭ=��P�y9��� �ۍYӘ�e+�p�Jnϱ?V\SO%�(�t� ���=?MR�[Ș�����d�/ ��n�l��B�7j� ��!�;ӥ�/�[-���A�>��dN�sLj ��,ɪv��=1c�.SQ�O3�U���ƀ�ܽ�E����������̻��9G�ϷD�7(�}��Ävӌ\��y�_0[w ���<΍>����a_��[0+�L��F.�޺��f�>oN�T����q;���y\��bՃ��y�jH�<|q-eɏ�_?_9+P���Hp$�����[ux�K w�Mw��N�ی'$Y2�=��q���KB��P��~�������Yul:�[<����F1�2�O���5=d����]Y�sw:���Ϯ���E��j,_Q��X��z`H1,#II ��d�wr��P˂@�ZJV����y$�\y�{}��^~���[:N����ߌ�U�������O��d�����ؾe��${p>G��3c���Ė�lʌ�� ת��[��`ϱ�-W����dg�I��ig2��� ��}s ��ؤ(%#sS@���~���3�X�nRG�~\jc3�v��ӍL��M[JB�T��s3}��j�Nʖ��W����;7���ç?=X�F=-�=����q�ߚ���#���='�c��7���ڑW�I(O+=:uxq�������������e2�zi+�kuG�R��������0�&e�n���iT^J����~\jy���p'dtG��s����O��3����9* �b#Ɋ�� p������[Bws�T�>d4�ۧs���nv�n���U���_�~,�v����ƜJ1��s�� �QIz���)�(lv8M���U=�;����56��G���s#�K���MP�=��LvyGd��}�VwWBF�'�à �?MH�U�g2�� ����!�p�7Q��j��ڴ����=��j�u��� Jn�A s���uM������e��Ɔ�Ҕ�!)�'��8Ϣ�ٔ���ޝ(��Vp���צ֖d=�IC�J�Ǡ{q������kԭ�߸���i��@K����u�|�p=..�*+����x�����z[Aqġ#s2a�Ɗ���RR�)*HRsi�~�a &f��M��P����-K�L@��Z��Xy�'x�{}��Zm+���:�)�) IJ�-i�u���� ���ܒH��'��L(7�y�GӜq���� j��� 6ߌg1�g�o���,kر���tY�?W,���p���e���f�OQS��!K�۟cҒA�|ս�j�>��=⬒��˧L[�� �߿2JaB~R��u�:��Q�] �0H~���]�7��Ƽ�I���(�}��cq '�ήET���q�?f�ab���ӥvr� �)o��-Q��_'����ᴎo��K������;��V���o��%���~OK ����*��b�f:���-ťIR��`B�5!RB@���ï�� �u �̯e\�_U�_������� g�ES��3��������QT��a�����x����U<~�c?�*�#]�MW,[8O�a�x��]�1bC|踤�P��lw5V%�)�{t�<��d��5���0i�XSU��m:��Z�┵�i�"��1�^B�-��P�hJ��&)O��*�D��c�W��vM��)����}���P��ܗ-q����\mmζZ-l@�}��a��E�6��F�@��&Sg@���ݚ�M����� ȹ 4����#p�\H����dYDo�H���"��\��..R�B�H�z_�/5˘����6��KhJR��P�mƶi�m���3��,#c�co��q�a)*P�t����R�m�k�7x�D�E�\Y�閣_X�<���~�)���c[[�BP����6�Yq���S��0����%_����;��Àv�~�| VS؇ ��'O0��F0��\���U�-�d@�����7�SJ*z��3n��y��P����O����������m�~�P�3|Y��ʉr#�C�<�G~�.,! ���bqx���h~0=��!ǫ�jy����l��O,�[B��~��|9��ٱ����Xly�#�i�B��g%�S��������tˋ���e���ې��\[d�t)��.+u�|1 ������#�~Oj����hS�%��i.�~X���I�H�m��0n���c�1uE�q��cF�RF�o���7� �O�ꮧ� ���ۛ{��ʛi5�rw?׌#Qn�TW��~?y$��m\�\o����%W� ?=>S�N@�� �Ʈ���R����N�)�r"C�:��:����� �����#��qb��Y�. �6[��2K����2u�Ǧ�HYR��Q�MV��� �G�$��Q+.>�����nNH��q�^��� ����q��mM��V��D�+�-�#*�U�̒ ���p욳��u:�������IB���m����PV@O���r[b= �� ��1U�E��_Nm�yKbN�O���U�}�the�`�|6֮P>�\2�P�V���I�D�i�P�O;�9�r�mAHG�W�S]��J*�_�G��+kP�2����Ka�Z���H�'K�x�W�MZ%�O�YD�Rc+o��?�q��Ghm��d�S�oh�\�D�|:W������UA�Qc yT�q��������~^�H��/��#p�CZ���T�I�1�ӏT����4��"�ČZ�����}��`w�#�*,ʹ�� ��0�i��課�Om�*�da��^gJ݅{���l�e9uF#T�ֲ��̲�ٞC"�q���ߍ ոޑ�o#�XZTp����@ o�8��(jd��xw�]�,f���`~��|,s��^����f�1���t��|��m�򸄭/ctr��5s��7�9Q�4�H1꠲BB@�l9@���C�����+�wp�xu�£Yc�9��?`@#�o�mH�s2��)�=��2�.�l����jg�9$�Y�S�%*L������R�Y������7Z���,*=�䷘$�������arm�o�ϰ���UW.|�r�uf����IGw�t����Zwo��~5 ��YյhO+=8fF�)�W�7�L9lM�̘·Y���֘YLf�큹�pRF���99.A �"wz��=E\Z���'a� 2��Ǚ�#;�'}�G���*��l��^"q��+2FQ� hj��kŦ��${���ޮ-�T�٭cf�|�3#~�RJ����t��$b�(R��(����r���dx� >U b�&9,>���%E\� Ά�e�$��'�q't��*�א���ެ�b��-|d���SB�O�O��$�R+�H�)�܎�K��1m`;�J�2�Y~9��O�g8=vqD`K[�F)k�[���1m޼c��n���]s�k�z$@��)!I �x՝"v��9=�ZA=`Ɠi �:�E��)`�7��vI��}d�YI�_ �o�:ob���o ���3Q��&D&�2=�� �Ά��;>�h����y.*ⅥS������Ӭ�+q&����j|UƧ�����}���J0��WW< ۋS�)jQR�j���Ư��rN)�Gű�4Ѷ(�S)Ǣ�8��i��W52���No˓� ۍ%�5brOn�L�;�n��\G����=�^U�dI���8$�&���h��'���+�(������cȁ߫k�l��S^���cƗjԌE�ꭔ��gF���Ȓ��@���}O���*;e�v�WV���YJ\�]X'5��ղ�k�F��b 6R�o՜m��i N�i�����>J����?��lPm�U��}>_Z&�KK��q�r��I�D�Չ~�q�3fL�:S�e>���E���-G���{L�6p�e,8��������QI��h��a�Xa��U�A'���ʂ���s�+טIjP�-��y�8ۈZ?J$��W�P� ��R�s�]��|�l(�ԓ��sƊi��o(��S0���Y� 8�T97.�����WiL��c�~�dxc�E|�2!�X�K�Ƙਫ਼�$((�6�~|d9u+�qd�^3�89��Y�6L�.I�����?���iI�q���9�)O/뚅����O���X��X�V��ZF[�یgQ�L��K1���RҖr@v�#��X�l��F���Нy�S�8�7�kF!A��sM���^rkp�jP�DyS$N���q���nxҍ!U�f�!eh�i�2�m����`�Y�I�9r�6� �TF���C}/�y�^���Η���5d�'��9A-��J��>{�_l+�`��A���[�'��յ�ϛ#w:݅�%��X�}�&�PSt�Q�"�-��\縵�/����$Ɨh�Xb�*�y��BS����;W�ջ_mc�����vt?2}1�;qS�d�d~u:2k5�2�R�~�z+|HE!)�Ǟl��7`��0�<�,�2*���Hl-��x�^����'_TV�gZA�'j� ^�2Ϊ��N7t�����?w�� �x1��f��Iz�C-Ȗ��K�^q�;���-W�DvT�7��8�Z�������� hK�(P:��Q- �8�n�Z���܃e貾�<�1�YT<�,�����"�6{�/ �?�͟��|1�:�#g��W�>$����d��J��d�B���=��jf[��%rE^��il:��B���x���Sּ�1հ��,�=��*�7 fcG��#q� �eh?��2�7�����,�!7x��6�n�LC�4x��},Geǝ�tC.��vS �F�43��zz\��;QYC,6����~;RYS/6���|2���5���v��T��i����������mlv��������&� �nRh^ejR�LG�f���? �ۉҬܦƩ��|��Ȱ����>3����!v��i�ʯ�>�v��オ�X3e���_1z�Kȗ\<������!�8���V��]��?b�k41�Re��T�q��mz��TiOʦ�Z��Xq���L������q"+���2ۨ��8}�&N7XU7Ap�d�X��~�׿��&4e�o�F��� �H�����O���č�c�� 懴�6���͉��+)��v;j��ݷ�� �UV�� i��� j���Y9GdÒJ1��詞�����V?h��l�����l�cGs�ځ�������y�Ac������\V3�? �� ܙg�>qH�S,�E�W�[�㺨�uch�⍸�O�}���a��>�q�6�n6�����N6�q��������N� ���! 1AQaq�0@����"2BRb�#Pr���3C`��Scst���$4D���%Td���� ?�����N����a��3��m���C���w��������xA�m�q�m����m������$����4n淿t'��C"w��zU=D�\R+w�p+Y�T�&�պ@��ƃ��3ޯ?�Aﶂ��aŘ���@-�����Q�=���9D��ռ�ѻ@��M�V��P��܅�G5�f�Y<�u=,EC)�<�Fy'�"�&�չ�X~f��l�KԆV��?�� �W�N����=(� �;���{�r����ٌ�Y���h{�١������jW����P���Tc�����X�K�r��}���w�R��%��?���E��m�� �Y�q|����\lEE4����r���}�lsI�Y������f�$�=�d�yO����p�����yBj8jU�o�/�S��?�U��*������ˍ�0�������u�q�m [�?f����a�� )Q�>����6#������� ?����0UQ����,IX���(6ڵ[�DI�MNލ�c&���υ�j\��X�R|,4��� j������T�hA�e��^���d���b<����n�� �즇�=!���3�^�`j�h�ȓr��jẕ�c�,ٞX����-����a�ﶔ���#�$��]w�O��Ӫ�1y%��L�Y<�wg#�ǝ�̗`�x�xa�t�w��»1���o7o5��>�m뭛C���Uƃߜ}�C���y1Xνm�F8�jI���]����H���ۺиE@I�i;r�8ӭ�����V�F�Շ| ��&?�3|x�B�MuS�Ge�=Ӕ�#BE5G������Y!z��_e��q�р/W>|-�Ci߇�t�1ޯќd�R3�u��g�=0 5��[?�#͏��q�cf���H��{ ?u�=?�?ǯ���}Z��z���hmΔ�BFTW�����<�q��(v� ��!��z���iW]*�J�V�z��gX֧A�q�&��/w���u�gYӘa���; �i=����g:��?2�dž6�ى�k�4�>�Pxs����}������G�9���3 ���)gG�R<>r h�$��'nc�h�P��Bj��J�ҧH� -��N1���N��?��~��}-q!=��_2hc�M��l�vY%UE�@|�v����M2�.Y[|y�"Eï��K�ZF,�ɯ?,q�?v�M 80jx�"�;�9vk�����+ ֧�� �ȺU��?�%�vcV��mA�6��Qg^M�����A}�3�nl� QRN�l8�kkn�'�����(��M�7m9و�q���%ޟ���*h$Zk"��$�9��: �?U8�Sl��,,|ɒ��xH(ѷ����Gn�/Q�4�P��G�%��Ա8�N��!� �&�7�;���eKM7�4��9R/%����l�c>�x;������>��C�:�����t��h?aKX�bhe�ᜋ^�$�Iհ �hr7%F$�E��Fd���t��5���+�(M6�t����Ü�UU|zW�=a�Ts�Tg������dqP�Q����b'�m���1{|Y����X�N��b �P~��F^F:����k6�"�j!�� �I�r�`��1&�-$�Bevk:y���#y�w��I0��x��=D�4��tU���P�ZH��ڠ底taP��6����b>�xa�����Q�#� WeF��ŮNj�p�J* mQ�N�����*I�-*�ȩ�F�g�3 �5��V�ʊ�ɮ�a��5F���O@{���NX��?����H�]3��1�Ri_u��������ѕ�� ����0��� F��~��:60�p�͈�S��qX#a�5>���`�o&+�<2�D����: �������ڝ�$�nP���*)�N�|y�Ej�F�5ټ�e���ihy�Z �>���k�bH�a�v��h�-#���!�Po=@k̆IEN��@��}Ll?j�O������߭�ʞ���Q|A07x���wt!xf���I2?Z��<ץ�T���cU�j��]���陎Ltl �}5�ϓ��$�,��O�mˊ�;�@O��jE��j(�ا,��LX���LO���Ц�90�O �.����a��nA���7������j4 ��W��_ٓ���zW�jcB������y՗+EM�)d���N�g6�y1_x��p�$Lv�:��9�"z��p���ʙ$��^��JԼ*�ϭ����o���=x�Lj�6�J��u82�A�H�3$�ٕ@�=Vv�]�'�qEz�;I˼��)��=��ɯ���x �/�W(V���p�����$ �m�������u�����񶤑Oqˎ�T����r��㠚x�sr�GC��byp�G��1ߠ�w e�8�$⿄����/�M{*}��W�]˷.�CK\�ުx���/$�WP�w���r� |i���&�}�{�X� �>��$-��l���?-z���g����lΆ���(F���h�vS*���b���߲ڡn,|)mrH[���a�3�ר�[1��3o_�U�3�TC�$��(�=�)0�kgP���� ��u�^=��4 �WYCҸ:��vQ�ר�X�à��tk�m,�t*��^�,�}D*�� �"(�I��9R����>`�`��[~Q]�#af��i6l��8���6�:,s�s�N6�j"�A4���IuQ��6E,�GnH��zS�HO�uk�5$�I�4��ؤ�Q9�@��C����wp��BGv[]�u�Ov����0I4���\��y�����Q�Ѹ��~>Z��8�T��a��q�ޣ;z��a���/��S��I:�ܫ_�|������>=Z����8:�S��U�I�J��"IY���8%b8���H��:�QO�6�;7�I�S��J��ҌAά3��>c���E+&jf$eC+�z�;��V����� �r���ʺ������my�e���aQ�f&��6�ND���.:��NT�vm�<- u���ǝ\MvZY�N�NT��-A�>jr!S��n�O 1�3�Ns�%�3D@���`������ܟ 1�^c<���� �a�ɽ�̲�Xë#�w�|y�cW�=�9I*H8�p�^(4���՗�k��arOcW�tO�\�ƍR��8����'�K���I�Q�����?5�>[�}��yU�ײ -h��=��% q�ThG�2�)���"ו3]�!kB��*p�FDl�A���,�eEi�H�f�Ps�����5�H:�Փ~�H�0Dت�D�I����h�F3�������c��2���E��9�H��5�zԑ�ʚ�i�X�=:m�xg�hd(�v����׊�9iS��O��d@0ڽ���:�p�5�h-��t�&���X�q�ӕ,��ie�|���7A�2���O%P��E��htj��Y1��w�Ѓ!����  ���� ࢽ��My�7�\�a�@�ţ�J ��4�Ȼ�F�@o�̒?4�wx��)��]�P��~�����u�����5�����7X ��9��^ܩ�U;Iꭆ 5 �������eK2�7(�{|��Y׎ �V��\"���Z�1� Z�����}��(�Ǝ"�1S���_�vE30>���p;� ΝD��%x�W�?W?v����o�^V�i�d��r[��/&>�~`�9Wh��y�;���R���� ;;ɮT��?����r$�g1�K����A��C��c��K��l:�'��3 c�ﳯ*"t8�~l��)���m��+U,z��`(��>yJ�?����h>��]��v��ЍG*�{`��;y]��I�T� ;c��NU�fo¾h���/$���|NS���1�S�"�H��V���T���4��uhǜ�]�v;���5�͠x��'C\�SBpl���h}�N����� A�Bx���%��ޭ�l��/����T��w�ʽ]D�=����K���ž�r㻠l4�S�O?=�k �M:� ��c�C�a�#ha���)�ѐxc�s���gP�iG���{+���x���Q���I= �� z��ԫ+ �8"�k�ñ�j=|����c ��y��CF��/���*9ж�h{ �?4�o� ��k�m�Q�N�x��;�Y��4膚�a�w?�6�>�e]�����Q�r�:����g�,i"�����ԩA��*M�<�G��b�if��l^M��5�� �Ҩ�{����6J��ZJ�����P�*�����Y���ݛu�_4�9�I8�7���������,^ToR���m4�H��?�N�S�ѕw��/S��甍�@�9H�S�T��t�ƻ���ʒU��*{Xs�@����f������֒Li�K{H�w^���������Ϥm�tq���s� ���ք��f:��o~s��g�r��ט� �S�ѱC�e]�x���a��) ���(b-$(�j>�7q�B?ӕ�F��hV25r[7 Y� }L�R��}����*sg+��x�r�2�U=�*'WS��ZDW]�WǞ�<��叓���{�$�9Ou4��y�90-�1�'*D`�c�^o?(�9��u���ݐ��'PI&� f�Jݮ�������:wS����jfP1F:X �H�9dԯ����˝[�_54 �}*;@�ܨ�� ð�yn�T���?�ןd�#���4rG�ͨ��H�1�|-#���Mr�S3��G�3�����)�.᧏3v�z֑��r����$G"�`j �1t��x0<Ɔ�Wh6�y�6��,œ�Ga��gA����y��b��)���h�D��ß�_�m��ü �gG;��e�v��ݝ�nQ� ��C����-�*��o���y�a��M��I�>�<���]obD��"�:���G�A��-\%LT�8���c�)��+y76���o�Q�#*{�(F�⽕�y����=���rW�\p���۩�c���A���^e6��K������ʐ�cVf5$�'->���ՉN"���F�"�UQ@�f��Gb~��#�&�M=��8�ט�JNu9��D��[̤�s�o�~������� G��9T�tW^g5y$b��Y'��س�Ǵ�=��U-2 #�MC�t(�i� �lj�@Q 5�̣i�*�O����s�x�K�f��}\��M{E�V�{�υ��Ƈ�����);�H����I��fe�Lȣr�2��>��W��I�Ȃ6������i��k�� �5�YOxȺ����>��Y�f5'��|��H+��98pj�n�.O�y�������jY��~��i�w'������l�;�s�2��Y��:'lg�ꥴ)o#'Sa�a�K��Z� �m��}�`169�n���"���x��I ��*+� }F<��cГ���F�P�������ֹ*�PqX�x۩��,� ��N�� �4<-����%����:��7����W���u�`����� $�?�I��&����o��o��`v�>��P��"��l���4��5'�Z�gE���8���?��[�X�7(��.Q�-��*���ތL@̲����v��.5���[��=�t\+�CNܛ��,g�SQnH����}*F�G16���&:�t��4ُ"A��̣��$�b �|����#rs��a�����T�� ]�<�j��B�S�('$�ɻ� �wP;�/�n��?�ݜ��x�F��yUn�~mL*-�������Xf�wd^�a�}��f�,=t�׵i�.2/wpN�Ep8�OР���•��R�FJ� 55TZ��T �ɭ�<��]��/�0�r�@�f��V��V����Nz�G��^���7hZi����k��3�,kN�e|�vg�1{9]_i��X5y7� 8e]�U����'�-2,���e"����]ot�I��Y_��n�(JҼ��1�O ]bXc���Nu�No��pS���Q_���_�?i�~�x h5d'�(qw52] ��'ޤ�q��o1�R!���`ywy�A4u���h<קy���\[~�4�\ X�Wt/� 6�����n�F�a8��f���z �3$�t(���q��q�x��^�XWeN'p<-v�!�{�(>ӽDP7��ո0�y)�e$ٕv�Ih'Q�EA�m*�H��RI��=:��� ���4牢) �%_iN�ݧ�l]� �Nt���G��H�L��� ɱ�g<���1V�,�J~�ٹ�"K��Q�� 9�HS�9�?@��k����r�;we݁�]I�!{ �@�G�[�"��`���J:�n]�{�cA�E����V��ʆ���#��U9�6����j�#Y�m\��q�e4h�B�7��C�������d<�?J����1g:ٳ���=Y���D�p�ц� ׈ǔ��1�]26؜oS�'��9�V�FVu�P�h�9�xc�oq�X��p�o�5��Ա5$�9W�V(�[Ak�aY錎qf;�'�[�|���b�6�Ck��)��#a#a˙��8���=äh�4��2��C��4tm^ �n'c����]GQ$[Wҿ��i���vN�{Fu ��1�gx��1┷���N�m��{j-,��x�� Ūm�ЧS�[�s���Gna���䑴�� x�p 8<������97�Q���ϴ�v�aϚG��Rt�Һ׈�f^\r��WH�JU�7Z���y)�vg=����n��4�_)y��D'y�6�]�c�5̪��\� �PF�k����&�c;��cq�$~T�7j ���nç]�<�g ":�to�t}�159�<�/�8������m�b�K#g'I'.W������6��I/��>v��\�MN��g���m�A�yQL�4u�Lj�j9��#44�t��l^�}L����n��R��!��t��±]��r��h6ٍ>�yҏ�N��fU�� ���� Fm@�8}�/u��jb9������he:A�y�ծw��GpΧh�5����l}�3p468��)U��d��c����;Us/�֔�YX�1�O2��uq�s��`hwg�r~�{ R��mhN��؎*q 42�*th��>�#���E����#��Hv�O����q�}������6�e��\�,Wk�#���X��b>��p}�դ��3���T5��†��6��[��@��P�y*n��|'f�֧>�lư΂�̺����SU�'*�q�p�_S�����M�� '��c�6������m�� ySʨ;M��r���Ƌ�m�Kxo,���Gm�P��A�G�:��i��w�9�}M(�^�V��$ǒ�ѽ�9���|���� �a����J�SQ�a���r�B;����}���ٻ֢�2�%U���c�#�g���N�a�ݕ�'�v�[�OY'��3L�3�;,p�]@�S��{ls��X�'���c�jw��k'a�.��}�}&�� �dP�*�bK=ɍ!����;3n�gΊU�ߴmt�'*{,=SzfD� A��ko~�G�aoq�_mi}#�m�������P�Xhύ�����mxǍ�΂���巿zf��Q���c���|kc�����?���W��Y�$���_Lv����l߶��c���`?����l�j�ݲˏ!V��6����U�Ђ(A���4y)H���p�Z_�x��>���e���R��$�/�`^'3qˏ�-&Q�=?��CFVR �D�fV�9��{�8g�������n�h�(P"��6�[�D���< E�����~0<@�`�G�6����Hг�cc�� �c�K.5��D��d�B���`?�XQ��2��ٿyqo&+�1^� DW�0�ꊩ���G�#��Q�nL3��c���������/��x ��1�1�[y�x�პCW��C�c�UĨ80�m�e�4.{�m��u���I=��f�����0QRls9���f���������9���~f�����Ǩ��a�"@�8���ȁ�Q����#c�ic������G��$���G���r/$W�(��W���V�"��m�7�[m�A�m����bo��D� j����۳� l���^�k�h׽����� ��#� iXn�v��eT�k�a�^Y�4�BN���ĕ���0������� !01@Q"2AaPq3BR�������?�����@4�Q�����T3,���㺠�W�[=JK�Ϟ���2�r^7��vc�:�9 �E�ߴ�w�S#d���Ix��u��:��Hp��9E!�� V 2;73|F��9Y���*ʬ�F��D����u&���y؟��^EA��A��(ɩ���^��GV:ݜDy�`��Jr29ܾ�㝉��[���E;Fzx��YG��U�e�Y�C���� ����v-tx����I�sם�Ę�q��Eb�+P\ :>�i�C'�;�����k|z�رn�y]�#ǿb��Q��������w�����(�r|ӹs��[�D��2v-%��@;�8<a���[\o[ϧw��I!��*0�krs)�[�J9^��ʜ��p1)� "��/_>��o��<1����A�E�y^�C��`�x1'ܣn�p��s`l���fQ��):�l����b>�Me�jH^?�kl3(�z:���1ŠK&?Q�~�{�ٺ�h�y���/�[��V�|6��}�KbX����mn[-��7�5q�94�������dm���c^���h� X��5��<�eޘ>G���-�}�دB�ޟ� ��|�rt�M��V+�]�c?�-#ڛ��^ǂ}���Lkr���O��u�>�-D�ry� D?:ޞ�U��ǜ�7�V��?瓮�"�#���r��չģVR;�n���/_� ؉v�ݶe5d�b9��/O��009�G���5n�W����JpA�*�r9�>�1��.[t���s�F���nQ� V 77R�]�ɫ8����_0<՜�IF�u(v��4��F�k�3��E)��N:��yڮe��P�`�1}�$WS��J�SQ�N�j��ٺ��޵�#l���ј(�5=��5�lǏmoW�v-�1����v,W�mn��߀$x�<����v�j(����c]��@#��1������Ǔ���o'��u+����;G�#�޸��v-lη��/(`i⣍Pm^����ԯ̾9Z��F��������n��1��� ��]�[��)�'�������:�֪�W��FC����� �B9،!?���]��V��A�Վ�M��b�w��G F>_DȬ0¤�#�QR�[V��kz���m�w�"��9ZG�7'[��=�Q����j8R?�zf�\a�=��O�U����*oB�A�|G���2�54 �p��.w7� �� ���&������ξxGHp� B%��$g�����t�Џ򤵍z���HN�u�Я�-�'4��0���;_���3������� !01"@AQa2Pq#3BR�������?����ʩca��en��^��8���<�u#��m*08r��y�N"�<�Ѳ0��@\�p��� �����Kv�D��J8�Fҽ� �f�Y��-m�ybX�NP����}�!*8t(�OqѢ��Q�wW�K��ZD��Δ^e��!� ��B�K��p~�����e*l}z#9ң�k���q#�Ft�o��S�R����-�w�!�S���Ӥß|M�l޶V��!eˈ�8Y���c�ЮM2��tk���� ������J�fS����Ö*i/2�����n]�k�\���|4yX�8��U�P.���Ы[���l��@"�t�<������5�lF���vU�����W��W��;�b�cД^6[#7@vU�xgZv��F�6��Q,K�v��� �+Ъ��n��Ǣ��Ft���8��0��c�@�!�Zq s�v�t�;#](B��-�nῃ~���3g������5�J�%���O������n�kB�ĺ�.r��+���#�N$?�q�/�s�6��p��a����a��J/��M�8��6�ܰ"�*������ɗud"\w���aT(����[��F��U՛����RT�b���n�*��6���O��SJ�.�ij<�v�MT��R\c��5l�sZB>F��<7�;EA��{��E���Ö��1U/�#��d1�a�n.1ě����0�ʾR�h��|�R��Ao�3�m3 ��%�� ���28Q�� ��y��φ���H�To�7�lW>����#i`�q���c����a��� �m,B�-j����݋�'mR1Ήt�>��V��p���s�0IbI�C.���1R�ea�����]H�6�����������4B>��o��](��$B���m�����a�!=���?�B� K�Ǿ+�Ծ"�n���K��*��+��[T#�{�E�J�S����Q�����s�5�:�U�\wĐ�f�3����܆&�)�����I���Ԇw��E T�lrTf6Q|R�h:��[K�� �z��c֧�G�C��%\��_�a��84��HcO�bi��ؖV��7H �)*ģK~Xhչ0��4?�0��� �E<���}3���#���u�?�� ��|g�S�6ꊤ�|�I#Hڛ� �ա��w�X��9��7���Ŀ%�SL��y6č��|�F�a 8���b���$�sק�h���b9RAu7�˨p�Č�_\*w��묦��F ����4D~�f����|(�"m���NK��i�S�>�$d7SlA��/�²����SL��|6N�}���S�˯���g��]6��; �#�.��<���q'Q�1|KQ$�����񛩶"�$r�b:���N8�w@��8$�� �AjfG|~�9F ���Y��ʺ��Bwؒ������M:I岎�G��`s�YV5����6��A �b:�W���G�q%l�����F��H���7�������Fsv7���k�� 403WebShell
403Webshell
Server IP : 172.67.166.40  /  Your IP : 104.23.197.203
Web Server : Apache
System : Linux tastesys.restaurant-online.biz 3.10.0-1160.144.1.el7.tuxcare.els4.x86_64 #1 SMP Tue Apr 7 08:40:40 UTC 2026 x86_64
User : restaura ( 1002)
PHP Version : 5.4.45
Disable Function : exec,passthru,shell_exec,system
MySQL : ON  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /home/restaura/public_html/roo/larrys-jonesboro_OFFLINE/rooadmin/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /home/restaura/public_html/roo/larrys-jonesboro_OFFLINE/rooadmin/editmenuitemsub_OLD.php
<style>
ul.categoryitems {
	background:none;
	width:95%;
	max-width:95%;
	padding:1%
}
</style>

<?php

if ($_SESSION['FirstName'] == "") {

	echo 'You are not authorized to view this page. <br><br>You may <a href="index.php">log in here.</a></div></div>';

	exit;

	}





//require_once ('mysql_connect.php');

$action          = $_GET["a"];

$action2          = $_GET["action2"];

$move          = $_GET["d"];

$editchoice          = $_GET["editchoice"];

$choicekey          = $_GET["ckey"];

$fixingkey          = $_GET["fkey"];

$deleteoption =  $_GET["del"];

$active = $_POST['chkactive'];

$defaultcrust = $_POST['chkdefault'];

$defaultsauce = $_POST['chkdefaultsauce'];

$multisized = $_POST['chksizes'];

$freetopping = $_POST['chkfreetopping'];

$taxable = $_POST['chktaxable'];

$oldnum = $_POST['oldnum']; 	//get original order number so we know if it has been changed

$itemKey  = $_GET["key"];

$sizeKey  = $_GET["sizekey"];

$fixings = $_POST['chkfixings'];

$upsell = $_POST['chkupsell'];



//variables for size upselling options

$upsellsizes = $_POST['chkupsellsize'];

$upsell_cost = $_POST['upgrade_cost'];

$upsell_discount = $_POST['upgrade_discount'];

$upsell_nodiscount = $_POST['chk_nodiscount'];



$upsellcat  = $_GET["upsellcat"];

$editfixings  = $_GET["editfixings"];

//set catfilter based on selected category key

if(!empty($_POST["catfilter"])){

      $catfilter  =   $_POST["catfilter"] ;

} elseif(!empty($_GET["catkey"])){

      $catfilter  = $_GET["catkey"];

}



if ($action == "delimage") {

    $query1 = "update menuItem set imagePath = Null where itemKey =" . $itemKey ;

		mysql_query($query1);

		echo "<font color='red'>Image was deleted.</font>";

	$action = "edit";	//change action flag to edit so changed record will be displayed again

}



if ($action == "upload") {

    include('item-img.php');

    $action = "edit";	//change action flag to edit so changed record will be displayed again

	echo "<font color='red'>Image was uploaded.</font>";

}

        

if(!empty($move)){  //menu item being moved up or down

        unset($previouskey);

        unset($nextkey);

        $query = "SELECT orderNum from menuItem WHERE itemKey =". $itemKey  ;  //get current ordernumber for item being moved

          $rt=mysql_query($query);

          while($nt=mysql_fetch_array($rt)){

          $ordernumber = $nt[orderNum];

        }

        mysql_close;

        

      		$query = "SELECT * from menuItem WHERE categoryKey =" . $catfilter .  " order by orderNum" ;

          $rt=mysql_query($query);

			while($nt=mysql_fetch_array($rt)){

        //echo 'itemkey: ' .$nt[itemKey] . ' - ord#: ' . $nt[orderNum]. '<br>';

            if($nt[orderNum]<$ordernumber){ //if current record is not record selected to be moved, save itemkey as previous record

                 $previouskey = $nt[itemKey];

                 $previousnum = $nt[orderNum];

                 //echo 'checkpoint 1<br>';

                 //echo 'previouskey ' . $nt[itemKey] . '<br>';

                 //echo 'previous #' . $nt[orderNum] . '<br>';

            }

            if($nt[orderNum]>$ordernumber){    //if

                  $nextkey = $nt[itemKey];

                  $nextnum = $nt[orderNum];

                  //echo 'checkpoint 2<br>';

                  break;  //go to end of loop, stop looking thru records

            }

      }     //end of loop to check through item numbers



   if($move=="dn"){

     //echo 'checkpoint 3<br>';

           if(!empty($nextkey)){

             //echo 'checkpoint 4<br>';

                 $query="Update menuItem set orderNum =" . $nextnum . " where itemKey = " . $itemKey ;

                 mysql_query($query);

                 //echo $query . '<br>';

                 $query="Update menuItem set orderNum =" . $ordernumber . " where itemKey = " . $nextkey ;

                 mysql_query($query);

                 //echo $query . '<br>';

           }

   }

   if($move=="up"){

         if(!empty($previouskey)){

                 $query="Update menuItem set orderNum =" . $previousnum . " where itemKey = " . $itemKey ;

                 mysql_query($query);

                 //echo $query . '<br>';

                 $query="Update menuItem set orderNum =" . $ordernumber . " where itemKey = " . $previouskey ;

                 mysql_query($query);

                //echo $query . '<br>';

           }

   }



}

	//echo 'item key = ' . $itemKey; //(for testing)

//require_once ('config.inc');

if(!empty($choicekey)){    //if choice item key is populated, insert choice item into option table, or delete selected item

     if($deleteoption =="del"){

           $query = "Delete from options where optionkey = " . $choicekey ;

           if (!mysql_query($query)){

					echo $query;

  					die('Error: ' . mysql_error());

 			     }

     }else{

       //check for duplicate first

       $update = "Select * from options where choice = " . $editchoice . " AND parentkey = " . $itemKey . " AND itemkey = " . $choicekey ;

       $rt=mysql_query($update);          // query executed

			echo mysql_error();

       if (mysql_num_rows($rt) == 0) {





     $query = "insert into options (choice, parentkey, itemkey, price) values (" . $editchoice . ", " . $itemKey . ", " . $choicekey . ", ";

     $q2 = "Select itemPrice from menuItem where itemKey = " . $choicekey ;

     $rt=mysql_query($q2);          // query executed

			echo mysql_error();                    // if any error is there that will be printed to the screen

			while($nt=mysql_fetch_array($rt)){

            $itemprice = $nt[itemPrice];

      }

      if(empty($itemprice)){

        $itemprice=0;

      }

      $query .= "'" . $itemprice . "')";

      if (!mysql_query($query)){

					echo $query;

  					die('Error: ' . mysql_error());

 			 }



          }  else {

                //record already exists - do nothing?

          }

    }

}



if(!empty($fixingkey)){    //if fixings item key is populated, insert fixings item into fixings table, or delete selected item

     if($deleteoption =="del"){

           $query = "Delete from fixings where fixingkey = " . $fixingkey ;

           if (!mysql_query($query)){

					echo $query;

  					die('Error: ' . mysql_error());

 			     }

     }else{

       //check for duplicate first

       $update = "Select * from fixings where parentkey = " . $itemKey . " AND itemkey = " . $fixingkey ;

       $rt=mysql_query($update);          // query executed

			echo mysql_error();

       if (mysql_num_rows($rt) == 0) {





     $query = "insert into fixings (parentkey, itemkey, price) values (" . $itemKey . ", " . $fixingkey . ", ";

     $q2 = "Select itemPrice from menuItem where itemKey = " . $fixingkey ;

     $rt=mysql_query($q2);          // query executed

			echo mysql_error();                    // if any error is there that will be printed to the screen

			while($nt=mysql_fetch_array($rt)){

            $itemprice = $nt[itemPrice];

      }

      $query .= "'" . $itemprice . "')";

      if (!mysql_query($query)){

					echo $query;

  					die('Error: ' . mysql_error());

 			 }



          }  else {

                //record already exists - do nothing?

          }

    }

}

if ($action2 == "unblocksize") {

	$record = $_GET['record'];

	$delete = "delete from crust_bad_size where recordkey = '$record'";

	mysql_query($delete);



	$action = "edit";	//change action flag to edit so changed record will be displayed again

}

if ($action2 == "blocksize") {

	$record = $_GET['record'];

	$insert = "insert into crust_bad_size (itemkey, sizekey) values ('$_GET[key]', '$_GET[sizekey]')";

	mysql_query($insert);



	$action = "edit";	//change action flag to edit so changed record will be displayed again

}

if (($action == "addsize") && ($_POST['newsize'] !=="")) {

	$newsize= mysql_real_escape_string($_POST['newsize']);

	//echo $newsize . '<br>';

	

	$query = "Insert into itemSize (size, itemKey) Values ('" . $newsize . "', '" .  $itemKey  . "')";

		if (!mysql_query($query)){

					echo $query;

  					die('Error: ' . mysql_error());

 			 } else {

			//echo $query .'<br>';	//for testing 

				echo "<div align=center><font color=red>Size added successfully.</font></div>";

				$action="edit";	//reset so edit item view will be shown again after update

			}

}

if ($action == "copysize") { 

//remove existing sizes

    $query = "Delete from itemSize where itemKey = '" . $itemKey . "'";

	//echo $query."<br>";

    mysql_query($query);          // query executed

		echo mysql_error(); 		//display any error

		//copy sizes from passed in item

		$squery="Select * from itemSize where itemKey='" . $_POST["copyfrom"] . "'";

		//echo $squery."<br>";

		$srt6=mysql_query($squery);          // query executed

        while($snt6=mysql_fetch_array($srt6)){

				$query="insert into itemSize (itemKey, size, price) values ('".$itemKey ."', '". $snt6["size"] ."', '". $snt6["price"] ."')";

				mysql_query($query);          // query executed

				//echo $query."<br>";

				

			}	

		 mysql_close;

		

		$action = "edit";	//change action flag to edit so changed record will be displayed again

		echo "<div align=center><font color=red>Size table updated successfully.</font></div>";

}

if ($action == "delsize") {

    $query = "Delete from itemSize where recordKey = '" . $sizeKey . "'";

    mysql_query($query);          // query executed

		echo mysql_error(); 		//display any error

		

		$action = "edit";	//change action flag to edit so changed record will be displayed again

		echo "<div align=center><font color=red>Size table updated successfully.</font></div>";

}

if ($action == "sizeupd") {



		//this item selected for upsell, clear other in this category

		$upsellqry = "Update itemSize set upsell='0' WHERE itemKey = '" . $_GET["key"] ."'" ;

		mysql_query($upsellqry);          // query executed 

		echo mysql_error(); 		//display any error



		$query = "Update itemSize Set size = '" . $_POST['size'] . "', price = '" . $_POST['sizeprice'] . "'";



if (empty($upsell)){

			$query = $query . ", upsell='0'";

		} else {

			$query = $query . ", upsell='1'";

		}





$query = $query . " Where recordKey = '" . $sizeKey . "'";











if (!mysql_query($query)){

					echo $query;

  					die('Error: ' . mysql_error());

 			 } else {

			//echo $query .'<br>';	//for testing

				echo "<div align=center><font color=red>Size table updated successfully.</font></div>";

				

			}



$action = "edit";	//change action flag to edit so changed record will be displayed again

}

if (($action == "add") && ($_POST['newitem'] !=="")) {

			//get highest ordernum before adding new record - will increase by one and assign to new Item

			$query = "Select max(orderNum) as maxnum from menuItem";

			$rt=mysql_query($query);          // query executed 

			echo mysql_error();                    // if any error is there that will be printed to the screen

			while($nt=mysql_fetch_array($rt)){

				$highnum = ($nt[maxnum] +1);

			

				}

			if ($catfilter !=""){ //if filtered by category, add category to new item being added

				$query = "Insert into menuItem (ItemName, orderNum, categoryKey) Values ('" . mysql_real_escape_string($_POST['newitem']) . "', '" .  $highnum  . "', '". $catfilter . "')";

			} else {

			$query = "Insert into menuItem (ItemName, orderNum) Values ('" . mysql_real_escape_string($_POST['newitem']) . "', '" .  $highnum  . "')";

			}

			if (!mysql_query($query)){

					echo $query;

  					die('Error: ' . mysql_error());

 			 } else {

			//echo $query .'<br>';	//for testing

				echo "<div align=left><font color=red>Item added successfully.</font></div><br />";

				

			}

			//item has been added - now change to edit mode and bring up new item to add details

			$query = "Select itemKey from menuItem where ItemName ='" . mysql_real_escape_string($_POST['newitem']) . "'";

			$rt=mysql_query($query);

			while($nt=mysql_fetch_array($rt)){  //new record found

           $itemKey = $nt[itemKey];

           $action = "edit";

      }

      mysql_close;

		}



if ($action == "update") {

$checkbox = $_POST['chkdelete'];





	if (empty($checkbox)) {

		//delete not checked, save other updated info





		if (isset($_POST["Item"])) {

		$query = "UPDATE menuItem SET ItemName = '" . mysql_real_escape_string($_POST['Item']) . "', Active ='";

		if (empty($active)){

			$query = $query . "0'";

		} else {

			$query = $query . "1'";

		}



		if (empty($multisized)){

			$query = $query . ", multisized='0'";

		} else {

			$query = $query . ", multisized='1'";

		}

		

		if (empty($fixings)){

			$query = $query . ", usefixings='0'";

		} else {

			$query = $query . ", usefixings='1'";

		}

		

		if (empty($freetopping)){

			$query = $query . ", freeTopping='0'";

		} else {

			$query = $query . ", freeTopping='$freetopping'";

		}

		

		if (empty($upsell)){

			$query = $query . ", upsell='0'";

		} else {

			//this item selected for upsell, clear other in this category

			$upsellqry = "Update menuItem set upsell='0' Where categoryKey = '" . $upsellcat . "'";

			mysql_query($upsellqry);          // query executed 

			echo mysql_error(); 		//display any error



			$query = $query . ", upsell='1'";

		}

		

		if (empty($upsellsizes)){

			$query = $query . ", upsellSizes='0'";

		} else {

			$query = $query . ", upsellSizes='1'";

		}

		

		if(empty($upsell_cost)){

			$query = $query . ", upsell_cost='0.00'";

		} else {

			$query = $query . ", upsell_cost='$upsell_cost'";

		}

		

		if(empty($upsell_discount)){

			$query .= ", upsell_pct_disc='0.00'";

		} else {

			$query .= ", upsell_pct_disc='$upsell_discount'";

		}

		

		if (empty($defaultcrust)){

			$query = $query . ", defaultCrust='0'";

		} else {



			//this item selected for default crust type, clear others

			$crustqry = "Update menuItem set defaultCrust='0' Where defaultCrust = '1'";

			mysql_query($crustqry);          // query executed

			echo mysql_error(); 		//display any error



			$query = $query . ", defaultCrust='1'";

		}

		

		if (empty($defaultsauce)){

			$query = $query . ", defaultSauce='0'";

		} else {



			//this item selected for default sauce type, clear others

			$sauceqry = "Update menuItem set defaultSauce='0' Where defaultSauce = '1'";

			mysql_query($sauceqry);          // query executed

			echo mysql_error(); 		//display any error



			$query = $query . ", defaultSauce='1'";

		}

		

		if (empty($taxable)){

			$query = $query . ", taxable='0'";

		} else {

			$query = $query . ", taxable='1'";

		}

		$query = $query . ", categorykey ='" . $_POST['category'] . "', description = '"

        . mysql_real_escape_string($_POST['descrip']) ."'";

        if(!empty($_POST['price'])){

           $query .= ", itemPrice='" . $_POST['price'] . "'";

        } else{

           $query .= ", itemPrice=null";

        }

        if(!empty($_POST['defcrust'])){

           $query .= ", crust='" . $_POST['defcrust'] . "'";

      }

      if(!empty($_POST['defsauce'])){

            $query .= ", sauce='" . $_POST['defsauce'] . "'";

        }

        $query .= " WHERE itemKey = '" . $_GET['key'] ."'" ;

		//echo $query  ;

		mysql_query($query) or die(mysql_error());   //execute query



		//confirmation message that delete worked...

		echo '<div align="center"><font color=red>Item updated successfully.</font></div>';

		$action="edit";   //change so that edited item will be displayed again after update



		}



	} else { 

		

			//delete item	

			$query = "DELETE FROM menuItem WHERE itemKey = '" . $_GET["key"] ."'" ;

			mysql_query($query) or die(mysql_error());   //execute query

			//delete any other sizes set up for item

			$query = "DELETE FROM itemSize WHERE itemKey = '" . $_GET["key"] ."'" ;

			mysql_query($query) or die(mysql_error());   //execute query



			//confirmation message that delete worked...

			echo "<font color=red>Item deleted successfully.</font>";

		}

	}	//end of update query







if ($action =="edit") {

 // echo '<div align="left"><a id="save-button" href="editmenuitem.php#add">Add New Item</a></div><br><br>';

	$query = "SELECT * from menuItem WHERE itemKey ='" . $itemKey . "'";

		//echo $query . "<br>";



		$rt=mysql_query($query);          // query executed 

		echo mysql_error();                    // if any error is there that will be printed to the screen

		echo '<div align="left"><table border=0 width="100%">';

		while($nt=mysql_fetch_array($rt)){

			echo '<tr><td><form action="' . $_SERVER['PHP_SELF'] . '?a=update&key=' . $nt[itemKey] . '" method="post"><td valign=top>Item name: <td valign=top><input type="text" name="Item" id="Item" size="35" value="' . $nt[itemName] . '">';



			$result2 = mysql_query("SELECT categoryName, category_type, recordKey FROM menuCategory where active=1 order by categoryName");

			if (!$result2){    

				print("There was a problem getting categories: <b>" . mysql_error());    

				exit();  

			}

			$counter = 0;



			// Create the HTML code for the label and select list

			$catSelectList .= " <tr><td><td valign=top>Category: <td valign=top><select name='category' id='menuCategory'><option value='' size='10'> - select a category - </option>\n";

			while ($row = mysql_fetch_array($result2)){

				if ($row["recordKey"] == $nt[categoryKey]){ // add selected argument if option matches

				

					$catSelectList .= "<option value='".$row["recordKey"]."' selected='selected'>" . $row["categoryName"] . "</option>\n" ;

					$selectedcat = $row["categoryName"] ;

					$category_type = $row["category_type"] ;

					$catselection=$row["recordKey"];



				} else {

					$catSelectList .= "<option value='".$row["recordKey"]."'>" . $row["categoryName"] . "</option>\n" ;

				}

				$counter++;

				if ($row["categoryName"]=="Options")   {

				     $selectedcatkey = $row["recordKey"];

				}

				if ($row["categoryName"]=="Fixings")   {

				     $fixingcatkey = $row["recordKey"];

				}

			}

			$catSelectList .= "</select>";

		

			if ($counter == 0){

				echo "<input type=hidden name='category' value=''>";		

			}else{

				echo $catSelectList;

			}



$counter = 0;

$catSelectList = "";





	echo '<tr><td><td valign="top">Description: <td valign=top><textarea name="descrip" cols="35" rows="3">'

  . $nt[description] . '</textarea><tr><td><td valign=top><div align=left>';

  if (($selectedcat == "Pizza")||($category_type=='1'))  {  //if this is a pizza, show sauce and crust selectors

     //get category keys for crusts & sauces

     $squery = "Select RecordKey from menuCategory where CategoryName = 'Pizza Sauce'";

     $cquery = "Select RecordKey from menuCategory where CategoryName = 'Pizza Crust'";

      $rsq=mysql_query($squery);          // query executed

			echo mysql_error(); 		//display any error

			while($nt3=mysql_fetch_array($rsq)){

           $saucecat = $nt3["RecordKey"];

      }

      mysql_close;

      $rsq = mysql_query($cquery);          // query executed

			echo mysql_error(); 		//display any error

			while($nt3=mysql_fetch_array($rsq)){

           $crustcat = $nt3["RecordKey"];

      }

      mysql_close;

      echo '<tr><td><td valign=top><div align=left>Default crust: <td><select name=defcrust>';

      $query3 = "Select itemKey, itemName, defaultCrust from menuItem where categoryKey = " . $crustcat;

      $result3 = mysql_query($query3);          // query executed

			echo mysql_error(); 		//display any error

      while($nt3=mysql_fetch_array($result3)){

            echo '<option value="' . $nt3["itemKey"] . '"';

            if($nt["crust"]==$nt3["itemKey"]){

               echo 'selected="selected"';

            }elseif(($nt3["defaultCrust"]==1)&&(empty($nt["crust"]))){

              echo 'selected="selected"';

            }

            echo '>' .  $nt3["itemName"] . '</option>';

      }

      echo '</select>';

      

      mysqlclose;

      

      echo '<tr><td><td valign=top><div align=left>Default sauce: <td><select name=defsauce>';

      $query3 = "Select itemKey, itemName, defaultSauce from menuItem where categoryKey = " . $saucecat;

            $result3 = mysql_query($query3);          // query executed

			echo mysql_error(); 		//display any error

      while($nt3=mysql_fetch_array($result3)){

            echo '<option value="' . $nt3["itemKey"] . '"';

            if($nt["sauce"]==$nt3["itemKey"]){

               echo 'selected="selected"';

            }elseif(($nt3["defaultSauce"]==1)&&(empty($nt["sauce"]))){

              echo 'selected="selected"';

              }

            echo '>' .  $nt3["itemName"] . '</option>';

      }

      echo '</select>';



      mysqlclose;

  }

	//alow multi-size option here if not a sauce or crust category

	if (($selectedcat !=="Pizza Crust")&&($selectedcat !=="Pizza Sauce")){

		echo '<tr><td><td valign=top><div align=left>Multiple sizes: <td valign=top><input type="checkbox" name="chksizes"';

		if(!empty($nt[multisized])){

			echo 'checked=true';

			$multisized=1; 	//set variable here - to be used to show multiple size boxes below if this option is selected

		} else {

			$multisized=0;

		}

		echo '>';

	}

	

	//allow blocking specific sizes for pizza crusts, as many stores don't offer specialty crusts in all sizes

	if ($selectedcat =="Pizza Crust"){

		echo '<tr><td><td valign=top><div align=left>Unavailable Sizes: <td valign=top>';

		echo "<font color='red'><i>By default, all pizza sizes are allowed for crusts. <br>Sizes selected here will NOT be available for this crust type:</i></font><br>";

		$bad_crusts = "Select * from crust_bad_size where itemkey ='$nt[itemKey]'";

		//echo "<br>qry=" . $bad_crusts;

		$cres = mysql_query($bad_crusts);   

		while($ntres=mysql_fetch_array($cres)){

			$qry = "Select sizeName from sizeMaster where recordKey = '$ntres[sizekey]'";

			//echo "<br>qry=" . $qry;

			$qrs = mysql_query($qry);  

			while($qnt=mysql_fetch_array($qrs)){

				echo "<a href='". $_SERVER['PHP_SELF'] . "?a=edit&action2=unblocksize&record=$ntres[recordkey]&key=$nt[itemKey]' title='click to unblock this size'><font color='blue'>$qnt[sizeName] - [x]</font></a><br>";

			}

		}

		echo "<br>";

		echo "Click on a size below to disable for this crust.<br>";

		$sizes = "Select * from sizeMaster where recordKey not in(select sizekey as recordKey from crust_bad_size where itemkey ='$nt[itemKey]')";

		//echo "<br>qry=" . $sizes;

		$srs = mysql_query($sizes);

		while($ntsize=mysql_fetch_array($srs)){

			echo "<a href='". $_SERVER['PHP_SELF'] . "?a=edit&action2=blocksize&sizekey=$ntsize[recordKey]&key=$nt[itemKey]' title='click to block size'><font color='blue'>$ntsize[sizeName]</font></a><br>";

		}

		

	}

	

if (($selectedcat !=="Fixings")&&($selectedcat !=="Options")&&($selectedcat !=="Pizza Toppings")&&($selectedcat !=="Pizza Crust")&&($selectedcat !=="Pizza Sauce")){

	echo '<tr><td><td valign=top><div align=left>Allow Fixings: <td valign=top><input type="checkbox" name="chkfixings"';

	if(!empty($nt[usefixings])){

		echo 'checked=true';

  $fixings = 1;

	}

echo '>';

}

if ($selectedcat == "Pizza")  {





/*echo '<tr><td><td valign=top><div align=left>

  Include free toppings: <td valign=top><input type="checkbox" name="chkfreetopping"';

	if(!empty($nt[freeTopping])){

		echo 'checked=true';

		$freetopping=1; 	//set variable here - to be used to show multiple size boxes below if this option is selected

	} else {

		$freetopping=0;

	}

echo '>';

*/

echo '<tr><td><td valign=top><div align=left>

  Include free toppings: <td valign=top><select name="chkfreetopping">';

 $x=0;

while ($x<6){

	echo"<option value='$x'";

	if($nt[freeTopping]==$x){echo 'selected="selected"';}

	echo ">$x</option>";

	$x++;

}

echo '</select>';



}

	echo '<tr><td><td valign=top><div align=left>Taxable: <td valign=top><input type="checkbox" name="chktaxable"';

	if(!empty($nt[taxable])){

		echo 'checked=true';

	} 

echo '>';

	echo '<tr><td><td valign=top><div align=left>Active: <td valign=top><input type="checkbox" name="chkactive"';

	if(!empty($nt[active])){

		echo 'checked=true';

	} 

echo '>';

if ($selectedcat =="Pizza Crust"){      //if item is a pizza crust, show default box to set as default

                 echo '<tr><td><td valign=top><div align=left>Default crust: <td valign=top><input type="checkbox" name="chkdefault"';

	               if(!empty($nt[defaultCrust])){

		             echo 'checked=true';

	              }

echo '>';

	}

if ($selectedcat =="Pizza Sauce"){      //if item is a pizza sauce, show default box to set as default

                 echo '<tr><td><td valign=top><div align=left>Default sauce: <td valign=top><input type="checkbox" name="chkdefaultsauce"';

	               if(!empty($nt[defaultSauce])){

		             echo 'checked=true';

	              }

echo '>';

	}

	if ($selectedcat !=="Options"){

		echo '<tr><td><td valign=top><div align=left>Upsell: <td valign=top><input type="checkbox" name="chkupsell"';

	    if(!empty($nt[upsell])){

		    echo 'checked=true';

		}

		echo '>';

		echo '<font color="red"><i>&nbsp;&nbsp;(Select one upsell item per category. Upsell occurs at checkout.)</i></font>';

		if($multisized==1){

			echo '<tr><td><td valign=top><div align=left>Upsell next size: <td valign=top><input type="checkbox" name="chkupsellsize"';

			if(!empty($nt[upsellSizes])){

				echo 'checked=true';

			}

			echo '>';

			echo '<font color="red"><i>&nbsp;&nbsp;(When item added to cart, offer upgrade to next size.)</i></font>';

		}

		if(!empty($nt[upsellSizes])){	//show options for size upsell

			echo '<br><div align=left>Size upgrade flat cost: <input type="text" size="3" name="upgrade_cost" id="upgrade_cost" value="'.$nt[upsell_cost].'" onchange="updateDiscount()"> <img src="images/question.png" title="This will offer a flat upgrade cost from any one size to the next. Example: If you set the cost to $2.00, the Small to Medium upgrade is $2.00, the Medium to Large upgrade is $2.00, etc...">';

			echo '<br><div align=left>Size upgrade discount %: <input type="text" size="3" name="upgrade_discount" id="upgrade_discount" value="'.$nt[upsell_pct_disc].'" onchange="updateCost()"> <img src="images/question.png" title="This will offer a discount price when upgrading from one size to the next. Example: If a Large is $5 more than a Medium, and you set the discount percent to .5 (50%), the upgrade will be offered at $2.50. *** NOTE: The discount is a multiplier and should always be entered in decimal form. 10% should be entered as .10, NOT 10.0">';

			echo '<br><div align=left>No discount: <input type="checkbox" name="chk_nodiscount"';

			if(((empty($nt[upsell_pct_disc]))&&(empty($nt[upsell_cost])))||(($nt[upsell_pct_disc]=="0.00")&&($nt[upsell_cost]=="0.00"))){

				echo 'checked=true';

			}

			echo ' disabled="disabled">';

		}

	}

if(($multisized==1)||($selectedcat=="Options")){

	//do not display price here, need to add to each size offered

} else {

	echo '<tr><td><td valign=top>Price: <td valign=top>';

	 echo '<input type="text" name="price" size="10" value="' . $nt[itemPrice] . '">';

}

echo '<tr><td><td valign=top><div align=left>Delete:<td valign=top><input type="checkbox" name="chkdelete" value="true"><tr><td><td><td valign=top><div align=left><input id="save-button" type="submit" name="save" value="Save"></form></div><tr><td colspan=3></table>';

echo '<br><h2>Product image:</h2><center>';

if(!empty($nt[imagePath])){



      echo '<br><img src="../images/menu/'.$nt[imagePath].'?'. time().'" width=150>

      <br><a href="' . $_SERVER['PHP_SELF'] . '?a=delimage&key=' . $nt[itemKey] . '"><font color="red">Remove image</font></a>';

    }

echo '</center>';

?> <!--************************BEGINNING OF IMAGE UPLOAD *************************-->

        <?php if(isset($_REQUEST['upload_message'])){?>

            <div class="upload_message_<?php echo $_REQUEST['upload_message_type'];?>">

            <?php echo htmlentities($_REQUEST['upload_message']);?>

            </div>

		<?php }





echo '<form action="' . $_SERVER['PHP_SELF'] . '?a=upload&key=' . $nt[itemKey] . '#' . $nt[itemKey] . '" method="post" enctype="multipart/form-data" name="image_upload_form" id="image_upload_form" style="margin-bottom:0px;">

<label>Image file, maximum 4MB. it can be jpg, gif,  png:</label><br />

          <input name="image_upload_box" type="file" id="image_upload_box" size="40" />

          <input type="submit" id="update" name="submit" value="Upload image" />



     <br />

	<br />

    <input name="max_width_box" type="hidden" id="max_width_box" value="100" size="4">

      <input name="max_height_box" type="hidden" id="max_height_box" value="100" size="4">

<input name="submitted_form" type="hidden" id="submitted_form" value="image_upload_form" />

          </form>';





//add multiple size boxes here if multisized option selected

	if($multisized==1){

		$query = "SELECT recordKey, itemKey, size, price, upsell FROM itemSize WHERE itemKey ='" . $itemKey . "'";

		//echo $query . "<br>";

		echo '<hr><div align="center"><A NAME="sizes"><h2>Sizes Offered</h2></A>';



		echo'</div>';

		

		$rt3=mysql_query($query);          // query executed 

		echo mysql_error();                    // if any error is there that will be printed to the screen

		if (mysql_num_rows($rt3) == 0) {

			echo '<br><font color="red">No sizes have been set up yet. Please use the selector below to add new sizes.</font>';

		} else {

		echo '<br><div align="center"><table border=0><tr><td><td><div align="center">Upsell<td><div align="center">Size</div><td><div align="center">Price</div><td><div align="center">Save Changes';

		while($nt3=mysql_fetch_array($rt3)){ 

			echo '<tr><td><form action="' . $_SERVER['PHP_SELF'] . '?a=sizeupd&key=' . $itemKey . '&sizekey=' . $nt3[recordKey] . '&upsellcat='. $nt[categoryKey] . '#sizes" method="post"><td>

<input type="checkbox" name="chkupsell"';

	if(!empty($nt3[upsell])){

		echo 'checked=true';

 		

	} 

echo '><td><input type="text" name="size" size=20 maxlength=20 value="' . $nt3[size] . '" readonly="readonly"> <td><input type="text" name="sizeprice" size=10 maxlength=10 value="' . $nt3[price] . '"><td><input type="submit" name="sizeupd" id="update" value="Update"><td><a href="' . $_SERVER['PHP_SELF'] . '?a=delsize&key=' . $itemKey . '&sizekey=' . $nt3[recordKey] . '#sizes"><font color="red">Remove size</font></a></form>';

		}

		echo '</table></div>';

		}

		echo '<div align="center"><form action="' . $_SERVER['PHP_SELF'] . '?a=addsize&key=' . $itemKey .'#sizes" method="post"><br>';

    //get size list

                      $result2 = mysql_query("SELECT sizeName, recordKey FROM sizeMaster order by sizeName");

			if (!$result2){

				print("There was a problem getting sizes: <b>" . mysql_error());

				exit();

			}

			$counter = 0;



			// Create the HTML code for the label and select list

			$sizeSelectList .= " <tr><td><td valign=top>Available sizes: <td valign=top><select name='newsize'><option value='' size='10'> - select a size - </option>\n";

			while ($row = mysql_fetch_array($result2)){



					$sizeSelectList .= "<option value='".$row["sizeName"]."'>" . $row["sizeName"] . "</option>\n" ;



				$counter++;

			}

			$sizeSelectList .= "</select>";



			if ($counter == 0){

				echo "<input type=hidden name='category' value=''>";

			}else{

				echo $sizeSelectList;

			}

$counter = 0;

$sizeSelectList = "";

    

    //end of size list



   echo ' <input type="submit" id="update" name="save" value="Add this Size">

		</form>';

			//add option to copy pricing from similar item - (for reference: $catfilter = selected category key)

			$priceqry = "Select * from itemSize where itemKey in(select itemKey from menuItem where categoryKey = '" . $catselection . "')";

			//echo $priceqry;

			$pqrt=mysql_query($priceqry);

			if (mysql_num_rows($pqrt) >0) {

				$sizesfound=1;

			}

			mysql_close;

			if($sizesfound==1){

			echo '<form action="' . $_SERVER['PHP_SELF'] . '?a=copysize&key=' . $itemKey .'#sizes" method="post">Copy sizes & pricing from: <select name="copyfrom">';

			$comps = "select itemName, itemKey from menuItem where categoryKey='" . $catselection . "'";

			$crt=mysql_query($comps);

			while($cnt=mysql_fetch_array($crt)){ 

				echo"<option value='" . $cnt[itemKey] . "'>" . $cnt[itemName] . "</option>";

			}

			mysql_close;

		

			echo'</select>';

			echo' <input type="submit" id="update" value="Apply"></form>';

			}

		echo'</div><hr><br>';

	}

		

}

       if (($selectedcat !=="Fixings")&&($selectedcat !=="Options")&&($selectedcat !=="Pizza Toppings")&&($selectedcat !=="Pizza Crust")&&($selectedcat !=="Pizza Sauce")){

                         //add section for user choices:

                     echo '<a name="choices"><div align="center"><h2>Choices Offered</h2></div></a>';

                       //show any existing choice lists here, split into 3 columns

                   echo '<table width=100%>';

                   echo '<td width="33%" valign="top"><div align="center"><u>Choice list 1</u></div>';

                       $query = "Select * from options where parentkey = " . $itemKey . " AND choice = 1";

                         $rt5=mysql_query($query);          // query executed

		                     echo mysql_error();                    // if any error is there that will be printed to the screen



		                     while($nt5=mysql_fetch_array($rt5)){

                                        $itemqry = "Select itemName from menuItem where itemKey = " . $nt5[itemkey] . " AND active = 1";

                                        $rt7=mysql_query($itemqry);          // query executed

		                                    echo mysql_error();                    // if any error is there that will be printed to the screen



		                                    while($nt7=mysql_fetch_array($rt7)){

                                        echo '<br>' . $nt7[itemName] . ' <a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=1&ckey=' . $nt5[optionkey] . '&del=del&1=1#choices" title="remove"><font color="red"> (-)</font></a>';

                                      }

                                      mysql_close;

                                      

                         }

                         if ($editchoice==1){

                              $query = "Select itemName, itemPrice, itemKey from menuItem where categoryKey =" . $selectedcatkey . " AND active = 1";

                               $rt6=mysql_query($query);          // query executed

		                           echo mysql_error();                    // if any error is there that will be printed to the screen

                              echo '<br><br><div align="center"><u>Add to list 1:</u></div>';

                               while($nt6=mysql_fetch_array($rt6)){

                                 echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=1&ckey=' . $nt6[itemKey] . '&1=1#choices"><font color="blue">' . $nt6[itemName] . '</font></a><br>';

                         }

                         }else {   //add link to add more choices

                               echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=1&1=1#choices"><div align="center"><font color="blue">Add choices</font></div></a>';

                         }

                     echo '<td width="33%" valign="top"><div align="center"><u>Choice list 2</u></div>';

                        $query = "Select * from options where parentkey = " . $itemKey . " AND choice = 2";

                         $rt5=mysql_query($query);          // query executed

		                     echo mysql_error();                    // if any error is there that will be printed to the screen

                       while($nt5=mysql_fetch_array($rt5)){

                                        $itemqry = "Select itemName from menuItem where itemKey = " . $nt5[itemkey] . " AND active = 1";

                                        $rt7=mysql_query($itemqry);          // query executed

		                                    echo mysql_error();                    // if any error is there that will be printed to the screen



		                                    while($nt7=mysql_fetch_array($rt7)){

                                        echo '<br>' . $nt7[itemName] . ' <a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=2&ckey=' . $nt5[optionkey] . '&del=del&1=1#choices" title="remove"><font color="red"> (-)</font></a>';

                                      }

                                      mysql_close;



                         }

                         if ($editchoice==2){

                              $query = "Select itemName, itemPrice, itemKey from menuItem where categoryKey =" . $selectedcatkey . " AND active = 1";

                               $rt6=mysql_query($query);          // query executed

		                           echo mysql_error();                    // if any error is there that will be printed to the screen

                              echo '<br><br><div align="center"><u>Add to list 2:</u></div>';

                               while($nt6=mysql_fetch_array($rt6)){

                                 echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=2&ckey=' . $nt6[itemKey] . '&1=1#choices"><font color="blue">' . $nt6[itemName] . '</font></a><br>';

                         }

                         }else {   //add link to add more choices

                               echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=2&1=1#choices"><div align="center"><font color="blue">Add choices</font></div></a>';

                         }

                         echo '<td width="33%" valign="top"><div align="center"><u>Choice list 3</u></div>';

                       $query = "Select * from options where parentkey = " . $itemKey . " AND choice = 3";

                         $rt5=mysql_query($query);          // query executed

		                     echo mysql_error();                    // if any error is there that will be printed to the screen

                       while($nt5=mysql_fetch_array($rt5)){

                                        $itemqry = "Select itemName from menuItem where itemKey = " . $nt5[itemkey] . " AND active = 1";

                                        $rt7=mysql_query($itemqry);          // query executed

		                                    echo mysql_error();                    // if any error is there that will be printed to the screen



		                                    while($nt7=mysql_fetch_array($rt7)){

                                        echo '<br>' . $nt7[itemName] . ' <a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=3&ckey=' . $nt5[optionkey] . '&del=del&1=1#choices" title="remove"><font color="red"> (-)</font></a>';

                                      }

                                      mysql_close;



                         }

                        if ($editchoice==3){

                              $query = "Select itemName, itemPrice, itemKey from menuItem where categoryKey =" . $selectedcatkey . " AND active = 1";

                               $rt6=mysql_query($query);          // query executed

		                           echo mysql_error();                    // if any error is there that will be printed to the screen

                              echo '<br><br><div align="center"><u>Add to list 3:</u></div>';

                               while($nt6=mysql_fetch_array($rt6)){

                                 echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=3&ckey=' . $nt6[itemKey] . '&1=1#choices"><font color="blue">' . $nt6[itemName] . '</font></a><br>';

                         }

                         }else {   //add link to add more choices

                               echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editchoice=3&1=1#choices"><div align="center"><font color="blue">Add choices</font></div></a>';

                         }

                         echo '</table><br><hr>';

                  }    //end of options section

                  

                  //add section for fixings:

                  if($fixings==1){

                     echo '<a name="fixings"><div align="center"><h2>Fixings Offered</h2></div></a>';

                     //display current fixings allowed

                     echo '<table width=100% border=0><tr><td width=33%><td width=33%><td width=33%><tr>';

                     $query = "Select * from fixings where parentkey = " . $itemKey;

                         $rt5=mysql_query($query);          // query executed

		                     echo mysql_error();                    // if any error is there that will be printed to the screen

                         $x=0;

		                     while($nt5=mysql_fetch_array($rt5)){

                                        $itemqry = "Select itemName from menuItem where itemKey = " . $nt5[itemkey] . " AND active = 1";

                                        $rt7=mysql_query($itemqry);          // query executed

		                                    echo mysql_error();                    // if any error is there that will be printed to the screen



		                                    while($nt7=mysql_fetch_array($rt7)){

                                        echo '<td valign="top"><div align="left">' . $nt7[itemName] . ' <a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editfixings=1&fkey=' . $nt5[fixingkey] . '&del=del&1=1#fixings" title="remove"><font color="red"> (-)</font></a></div>';



                                        //echo 'x=' . $x;

                                        if ($x == 2){

                                          echo '<tr>';

                                          $x=0;

                                        }

                                       $x = $x + 1;

                                      }

                                      mysql_close;



                         }

                         echo '</table>';

                         //display section add more toppings available for this menu item



                         if ($editfixings==1){

                              $query = "Select itemName, itemPrice, itemKey from menuItem where categoryKey =" . $fixingcatkey . " AND active = 1";

                               $rt6=mysql_query($query);          // query executed

		                           echo mysql_error();                    // if any error is there that will be printed to the screen

                              echo '<br><br><div align="center"><u>Add to toppings available:</u></div>';

                              echo '<table width=100% border=0><tr><td width=33%><td width=33%><td width=33%><tr>';

                              $x=0;

                               while($nt6=mysql_fetch_array($rt6)){

                                 echo '<td><a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editfixings=1&fkey=' . $nt6[itemKey] . '&1=1#fixings"><font color="blue">' . $nt6[itemName] . '</font></a><br>';

                                  if ($x == 2){

                                          echo '<tr>';

                                          $x=0;

                                        }

                                       $x = $x + 1;

                         }

                         }else {   //add link to add more choices

                               echo '<a href="' . $_SERVER['PHP_SELF'] . '?a=edit&key='. $itemKey . '&editfixings=1&1=1#fixings"><div align="center"><font color="blue">Add Fixings</font></div></a>';

                         }

                         echo '</table><hr>';

                  }

} else { //$action is NOT = "edit"



	echo '<div id="single-admin-button">

	<ul>

	<a href="index.php"><li>BACK TO HOME ADMIN</li></a>

	<a href="#add"><li>ADD NEW ITEM</li></a>

	</ul>

	</div>';



	// Select all categories

	$categories = array();

	$sql = "SELECT categoryName, recordKey 

			FROM menuCategory 

			WHERE active = 1 

			ORDER BY categoryName";



	$categoriesResult = mysql_query($sql) or die(mysql_error());



	while ($row = mysql_fetch_assoc($categoriesResult)) {

		$row['menu_items'] = array(); // Place holder for menu items

		$categories[$row['recordKey']] = $row;

	}



	// Get all menu items

	$menuItems = array();

	$sql = "SELECT itemKey, ItemName, active, orderNum, categoryKey, itemPrice, description, taxable 

			FROM menuItem

			ORDER BY orderNum";



	$menuItemsResult = mysql_query($sql) or die(mysql_error());



	while ($row = mysql_fetch_assoc($menuItemsResult)) {

		if (array_key_exists($row['categoryKey'], $categories)) {

			$categories[$row['categoryKey']]['menu_items'][] = $row;

		}

	}



	echo '<form id="form-menu-items" action="' . $_SERVER['PHP_SELF'] . '?a=filter" method="post">';

	echo '<div class="arrowlistmenu">';

	foreach ($categories as $categoryKey => $category) {

		echo "<h3 class='menuheader expandable'>".$category['categoryName']."</h3>";	

		echo'<ul class="categoryitems">';

		echo '<li>';



		echo '<div align="center">';

		echo '<table  class="menu-items" border=0 cellpadding=3 cellspacing=3>';

		echo '<tr>';

		echo '<td width="70px"><div align=left><u><b><font face="verdana, arial" size=2>Move</u></b></div></td>';

		echo '<td valign=top width="200px"><div align="left"><u><b><font face="verdana, arial" size=2>Item name</u></b></div></td>';

		echo '<td valign=top width="500px"><font size=2 face="verdana, arial"><div align=left><u><b>Description</u></b></div></font></td>';

		echo '</tr>';



		foreach ($category['menu_items'] as $menuItem) {

			echo '<tr>';

			echo '<td align="left"><img class="handle" src="/images/icon-drag.png" />';

			echo '<input type="hidden" name="menu_items_order[]" value="'.$menuItem['itemKey'].'" />';

			echo '</td>';



			echo '<td valign=top><div align="left"><font size=2 color="blue" face="verdana, arial"><span id="menu-item-name-'.$menuItem['itemKey'].'">' . $menuItem['ItemName']  .'</span></font></td>';



			echo '<td valign=top><font size=2 face="verdana, arial"><span id="menu-item-description-'.$menuItem['itemKey'].'">' . $menuItem['description']  .'</span></font></td>';

			echo '<td valign="top">';

			// echo '<form action="' . $_SERVER['PHP_SELF'] . '?a=edit&key=' . $menuItem['itemKey'] . '" method="post">';

			echo '<div align="right"><input id="save-button" class="popup edit-menu-item edit-menu-item-'.$menuItem['itemKey'].'" data-popup-id="'.$menuItem['itemKey'].'" data-cat-key="'.$menuItem['categoryKey'].'" type="submit" name="edit" value="Edit" /></div>';

			// echo '</form>';



			echo "

				<div class='toPopDiv' id='popup_".$menuItem['itemKey']."'> 

					<div class='close'></div>

					<span class='ecs_tooltip'>Esc to close <span class='arrow'></span></span>

					<iframe class='menu-item-iframe' id='iframe-".$menuItem['itemKey']."' src=''></iframe>

				</div> <!--toPopup end-->

			";

			echo '</td>';

			echo '</tr><tr><td colspan="4"><hr /></tr>';

				

		}

		echo '</table>';

		echo '<div align="right" style="text-align:center;"><a class="popup add-menu-item" id="save-button" class="popup add-menu-item" data-popup-id="add" data-cat-key="'.$categoryKey.'">New Item</a></div>';

		echo '</div>';



		echo '</li>';

		echo '</ul>';

	}

	// Add menu item popup

	echo "

		<div class='toPopDiv' id='popup_add'> 

			<div class='close'></div>

			<span class='ecs_tooltip'>Esc to close <span class='arrow'></span></span>

			<iframe class='menu-item-iframe' id='iframe-add' src=''></iframe>

		</div> <!--toPopup end-->

	";



	// Popup background

	echo "

			<div class='loader'></div>

			<div id='backgroundPopup'></div>

			<input id='cur-popup-id' type='hidden' value='' />";



	echo '</div>'; // end .arrowlistmenu

	echo '</form>';

	?>

	<script type="text/javascript">

		// Return a helper with preserved width of cells

		var fixHelper = function(e, ui) {

			ui.children().each(function() {

				$(this).width($(this).width());

			});

			return ui;

		};

		$(document).ready(function() {

			$(".menu-items tbody").sortable({

				helper: fixHelper,

				handle: '.handle',

				update: function(event, ui) {

					updateMenuItemsOrder();

				}

			}).disableSelection();



			$('.popup.edit-menu-item').click(function() {

				var popupId = $(this).data('popup-id');

				$('#iframe-'+popupId).attr('src', '/cmsadmin/editmenuitemiframe.php?a=edit&key='+popupId);

			});



			$('.popup.add-menu-item').click(function() {

				var popupId = $(this).data('popup-id');

				var catKey = $(this).data('cat-key');

				$('#iframe-'+popupId).attr('src', '/cmsadmin/editmenuitemiframe.php?a=add&catkey='+catKey);

			});



			$('#backgroundPopup, .toPopDiv .close').click(function() {

				var currentPopupId = $("#cur-popup-id").val();

				if (currentPopupId.length > 0) {

					if (currentPopupId == 'add') {

						location.reload();

					} else {

						updateItemDetails(currentPopupId);

					}

				}

			});

		});



		function updateMenuItemsOrder() {

			$.ajax({

				type: 'POST',

				url: 'save_menu_items_order.php',

				data: $('#form-menu-items').serialize()

			}).done(function(response) {

				if (response != '1') {

					alert('Error updating menu items order.');

				}

			});

		}

		function updateItemDetails(menuItemId) {

			$.ajax({

				type: 'GET',

				url: 'editmenuitemiframe.php?a=details&id='+menuItemId

			}).done(function(response) {

				if (response != '0') {

					response = $.parseJSON(response);

					if (response.hasOwnProperty('category')) {

						var category = response.category;

						var currentCategory = $('.edit-menu-item-'+menuItemId).data('cat-key');

						if (currentCategory != category) {

							location.reload();

						}

					}

					if (response.hasOwnProperty('name')) {

						var name = response.name;

						$('#menu-item-name-'+menuItemId).text(name);

					}

					if (response.hasOwnProperty('description')) {

						var description = response.description;

						$('#menu-item-description-'+menuItemId).text(description);

					}

				} else {

					location.reload();

				}

			});

		}

	</script>

	<?php



	echo '<div align="center">';



	echo '

	    <form action="' . $_SERVER['PHP_SELF'] . '?a=add" method="post">Add new Item' ;





	echo ': <a name="add"></a><br><input type="text" name="newitem" size=50><input type="hidden" name="catfilter" value="' . $catfilter . '">



			<input id="save-button" type="submit" name="save" value="Save">

			</form></div></div>';







} 	//end of 'edit' loop

		



//	echo '<div align="center"><br><a href="index.php"><font color="blue">Back to Main Admin Page</font></a>

// <br><a href="editmenucat.php"><font color="blue">Edit Categories</font></a><br><a href="editmenuitem.php"><font color="blue">Edit Menu Items</font></a>
// </div></div>';

	



	



?>

<script>

function updateDiscount() {

	//alert('test');

	var elem = document.getElementById("upgrade_discount");

	elem.value = "0.00";	

};



function updateCost(){

	//alert('test2');

	var percentage = document.getElementById("upgrade_discount");

	if(percentage.value >1) {

		percentage.value = percentage.value/100;

	}

	var elem = document.getElementById("upgrade_cost");

	elem.value = "0.00";		

};

</script>

<script>$("#itemsort").sortable({

    axis: 'y',

    stop: function (event, ui) {

        var data = $(this).sortable("serialize").toString();

		var idsInOrder = $(this).sortable("toArray").toString();

		//alert(idsInOrder); //popup alert to show data for testing		

		//var elem = document.getElementById("results").value = idsInOrder;	//update results input field for testing

        $.ajax({

            data: data,

            type: 'POST',

            url: 'save_item_order.php'

        });

    }

});

</script>

Youez - 2016 - github.com/yon3zu
LinuXploit