�����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 : 104.21.11.142  /  Your IP : 104.23.243.246
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/scoopys_OFFLINE/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /home/restaura/public_html/roo/scoopys_OFFLINE/mycart02262021.php
  <style type="text/css">
  .ui-dialog{
   background: white !important;
   animation :normal !important;
   overflow-y: auto !important;
   top: 250px !important;
  }
</style>

<!-- CSS for terms popup -->
<style>
.modal-window {
  position: fixed;
  background-color: rgba(200, 200, 200, 0.75);
  top: 0;
  right: 0;
  bottom: 0;
  left: 0;
  z-index: 999;
  opacity: 0;
  pointer-events: none;
  -webkit-transition: all 0.3s;
  -moz-transition: all 0.3s;
  transition: all 0.3s;
}

.modal-window:target {
  opacity: 1;
  pointer-events: auto;
}

.modal-window>div {
  width: 400px;
  position: relative;
  margin: 10% auto;
  padding: 2rem;
  background: #fff;
  color: #444;
}

.modal-window header {
  font-weight: bold;
}

.modal-close {
  color: #aaa;
  line-height: 50px;
  font-size: 80%;
  position: absolute;
  right: 0;
  text-align: center;
  top: 0;
  width: 70px;
  text-decoration: none;
}.modal-close:hover {
  color: #000;
}.modal-window h1 {
  font-size: 150%;
  margin: 0 0 15px;
}
</style><script type="text/javascript" src="js/toppingsFunctions.js"></script>

<?php include('cart_js.php'); ?>

<style>

<?php
//determine mobile or standard styling

If($mobile==1){
    Include('css/cart-style_mobile.css');
} else {
    Include('css/cart-style.css');
}

?>
</style>

<?php
//print_r($_SESSION);
//set any posted variables
$action = $_GET["a"];
$topping = $_GET["t"];
if(isset($_GET['v'])){$_SESSION['verified']=$_GET['v'];}
$freetopping = $_POST["freetopping"];
$freetoppingL = $_POST["freetoppingA"];
$freetoppingR = $_POST["freetoppingB"];
$freetopping2 = $_POST["freetopping2"];
$freetopping2L = $_POST["freetopping2A"];
$freetopping2R = $_POST["freetopping2B"];
$freetopping3 = $_POST["freetopping3"];
$freetopping3L = $_POST["freetopping3A"];
$freetopping3R = $_POST["freetopping3B"];
$freetopping4 = $_POST["freetopping4"];
$freetopping4L = $_POST["freetopping4A"];
$freetopping4R = $_POST["freetopping4B"];
$freetopping5 = $_POST["freetopping5"];
$freetopping5L = $_POST["freetopping5A"];
$freetopping5R = $_POST["freetopping5B"];
$cpnchoice = $_POST["cpnchoice"];
$item = $_GET["item"];
$qty = $_GET["qty"];
$parent = $_GET["p"];
$crust = $_GET["crust"];
$sauce = $_GET["sauce"];
$newkey = $_GET["new"];
$fixing = $_GET["f"];
$coupon = $_GET["coupon"];          //if coupon is set, nothing else will be happening at the moment...
$reorder = mysql_real_escape_string($_GET['reorder']);
//die($_GET['reorder']);
//copy selected favorites to cart if order type selected
if(isset($_GET['reorder']) && $_GET['reorder']!=""){
	if(!isset($_SESSION['order_type']) || $_SESSION['order_type']=="unknown"){
		echo "<center><font color='red'>Please select an order type to begin before re-ordering a favorite.</font></center>";
		$reorder="";
	}
}
//if favorite selected, add to cart now
if($reorder >""){
	$sql = "select favorite_name from favorites where recordKey='$reorder'";
	//$rs = mysql_query($sql);
	$rs = $mysqli->query($sql);
	//echo "rows:".mysql_num_rows($rs);
	while($row = $rs->fetch_assoc()){
		$favorite_name = $row['favorite_name'];
		//echo "fav: ".$favorite_name;
	}
	$mysqli->query($rs);
	if($favorite_name >""){
		$sql = "select * from favorites where favorite_name='$favorite_name' and customerID='".$_SESSION['UserKey']."' and parentLineNum='0'";
		$rs = $mysqli->query($sql);
		
		//echo "<br>$sql";
		//echo "<br>rows:".mysql_num_rows($rs);
		while($data = $rs->fetch_assoc()){
			//echo "<br>";print_r($data); echo "<br>";
			//insert parent item
			$sql_insert = "insert into cart (customerID, itemNumber, qty, size, subitems, categoryKey, freeTopping, freeToppingL, freeToppingR, freeTopping2, freeTopping2L, freeTopping2R, freeTopping3, freeTopping3L, freeTopping3R, freeTopping4, freeTopping4L, freeTopping4R, freeTopping5, freeTopping5L, freeTopping5R, choicea, choiceb, choicec, choiced, choicee, choicef, choiceg, choiceh, choicei, choicea_price, choiceb_price, choicec_price, choiced_price, choicee_price, choicef_price, choiceg_price, choiceh_price, choicei_price)";
			$sql_insert .= " values (";
			$sql_insert .= "'".$_SESSION['UserKey']."'";
			$sql_insert .= ", '".$data['itemNumber']."'";
			$sql_insert .= ", '".$data['qty']."'";
			$sql_insert .= ", '".$data['size']."'";
			$sql_insert .= ", '".$data['subitems']."'";
			$sql_insert .= ", '".$data['categoryKey']."'";
			$sql_insert .= ", '".$data['freeTopping']."', '".$data['freeToppingL']."', '".$data['freeToppingR']."'";
			$sql_insert .= ", '".$data['freeTopping2']."', '".$data['freeTopping2L']."', '".$data['freeTopping2R']."'";
			$sql_insert .= ", '".$data['freeTopping3']."', '".$data['freeTopping3L']."', '".$data['freeTopping3R']."'";
			$sql_insert .= ", '".$data['freeTopping4']."', '".$data['freeTopping4L']."', '".$data['freeTopping4R']."'";
			$sql_insert .= ", '".$data['freeTopping5']."', '".$data['freeTopping5L']."', '".$data['freeTopping5R']."'";
			$sql_insert .= ", '".$data['choicea']."'";
			$sql_insert .= ", '".$data['choiceb']."'";
			$sql_insert .= ", '".$data['choicec']."'";
			$sql_insert .= ", '".$data['choiced']."'";
			$sql_insert .= ", '".$data['choicee']."'";
			$sql_insert .= ", '".$data['choicef']."'";
			$sql_insert .= ", '".$data['choiceg']."'";
			$sql_insert .= ", '".$data['choicei']."'";
			$sql_insert .= ", '".$data['choicec']."'";
			$sql_insert .= ", '".$data['choicea_price']."'";
			$sql_insert .= ", '".$data['choiceb_price']."'";
			$sql_insert .= ", '".$data['choicec_price']."'";
			$sql_insert .= ", '".$data['choiced_price']."'";			$sql_insert .= ", '".$data['choicee_price']."'";
			$sql_insert .= ", '".$data['choicef_price']."'";
			$sql_insert .= ", '".$data['choiceg_price']."'";
			$sql_insert .= ", '".$data['choiceh_price']."'";
			$sql_insert .= ", '".$data['choicei_price']."'";
			
			//filling in old option prices for now - update later to use current pricing dynamically
			/*if($data['choicea']!=""){
				//lookup current option price
				//$price = "select price from options where itemkey='".$data['itemNumber']."' and ";
				$sql_insert .= ", ''";
			} else {
				$sql_insert .= ", ''";
			}
			if($data['choiceb']!=""){
				//lookup current option price
				//$price = "select price from options where itemkey='".$data['itemNumber']."' and ";
				$sql_insert .= ", ''";
			} else {
				$sql_insert .= ", ''";
			}
			if($data['choicec']!=""){
				//lookup current option price
				//$price = "select price from options where itemkey='".$data['itemNumber']."' and ";
				$sql_insert .= ", ''";
			} else {
				$sql_insert .= ", ''";
			}
			*/
			$sql_insert .= ")";
	
			//echo $sql_insert;
			$mysqli->query($sql_insert);
			$id = mysqli_insert_id($mysqli);
			//echo "<br>insert id: $id<br>";
			
			//insert any child records
			$sql2 = "select * from favorites where favorite_name='$favorite_name' and customerID='".$_SESSION['UserKey']."' and parentLineNum='".$data['recordKey']."'";
			$rs2 = $mysqli->query($sql2);
			//echo "<br>$sql<br>";
			while($data2 = $rs2->fetch_assoc()){
				$sql_insert = "insert into cart (customerID, itemNumber, qty, parentLineNum, size, subitems, categoryKey, freeTopping, freeToppingL, freeToppingR, freeTopping2, freeTopping2L, freeTopping2R, freeTopping3, freeTopping3L, freeTopping3R, freeTopping4, freeTopping4L, freeTopping4R, freeTopping5, freeTopping5L, freeTopping5R, choicea, choiceb, choicec, choiced, choicee, choicef, choiceg, choiceh, choicei)";
				$sql_insert .= " values (";
				$sql_insert .= "'".$_SESSION['UserKey']."'";
				$sql_insert .= ", '".$data2['itemNumber']."'";
				$sql_insert .= ", '".$data2['qty']."'";
				$sql_insert .= ", '".$id."'";
				$sql_insert .= ", '".$data2['size']."'";
				$sql_insert .= ", '".$data2['subitems']."'";
				$sql_insert .= ", '".$data2['categoryKey']."'";
				$sql_insert .= ", '".$data2['freeTopping']."', '".$data2['freeToppingL']."', '".$data2['freeToppingR']."'";
				$sql_insert .= ", '".$data2['freeTopping2']."', '".$data2['freeTopping2L']."', '".$data2['freeTopping2R']."'";
				$sql_insert .= ", '".$data2['freeTopping3']."', '".$data2['freeTopping3L']."', '".$data2['freeTopping3R']."'";
				$sql_insert .= ", '".$data2['freeTopping4']."', '".$data2['freeTopping4L']."', '".$data2['freeTopping4R']."'";
				$sql_insert .= ", '".$data2['freeTopping5']."', '".$data2['freeTopping5L']."', '".$data2['freeTopping5R']."'";
				$sql_insert .= ", '".$data2['choicea']."'";
				$sql_insert .= ", '".$data2['choiceb']."'";
				$sql_insert .= ", '".$data2['choicec']."'";
				$sql_insert .= ", '".$data2['choiced']."'";
				$sql_insert .= ", '".$data2['choicee']."'";
				$sql_insert .= ", '".$data2['choicef']."'";
				$sql_insert .= ", '".$data2['choiceg']."'";
				$sql_insert .= ", '".$data2['choiceh']."'";
				$sql_insert .= ", '".$data2['choicei']."')";
				//echo $sql_insert;
				$mysqli->query($sql_insert);
			}
			
			
		}
	}
	
}

if(isset($_GET['type'])){ //order type is being set here (delivery or carryout)
	$order_type = $_GET['type'];
	if($_SESSION['UserKey']!="9999"){
		if($order_type=="carryout"){$pickup = 1;} elseif($order_type=="delivery"){$pickup=0;}
		$update = "update guestLogin set pickup = $pickup where UserKey = ".$_SESSION['UserKey'];
		mysql_query($update);
	}
}
if($order_type=="delivery" || $order_type=="carryout"){
	$_SESSION['order_type'] = $order_type;
}

include('catcolor.php');  //get color settings
include('menudatabase.php');  //check for shared menu database - if used, this means menu data will pull from another website's database
//echo 'session storeID= ' . $_SESSION['storeID'];
//check for manually entered offer code
if((empty($coupon))&&(!empty($_POST["ccode"]))){
  $coupon = $_POST["ccode"];
}
//look up pizza category number for later use
$qq = "Select recordKey from menuCategory where categoryName = 'Pizza' or category_type='1'";
$qqr=mysql_query($qq);
while($qqt=mysql_fetch_array($qqr)){
  $pcatKey = $qqt[recordKey];   //$pcatkey = pizza category number
  $pcatArray .="'$qqt[recordKey]',";
}
$pcatArray .="''";
$pizzaArray = array($pcatArray);
//echo "array: " . $pcatArray;  //test - displays all pizza category keys
mysql_close;
// build list of categories to exclude from delivery minimum

$qq2 = "Select recordKey from menuCategory where exclude_from_minimum=1";

$qqr2=mysql_query($qq2);

while($qqt2=mysql_fetch_array($qqr2)){

	//echo "<br>cat:".$qqt2[recordKey];

  //$pcatKey = $qqt2[recordKey];  

  $eXcatArray .=strval($qqt2[recordKey]).",";

  //echo "<br>excat:".$eXcatArray;

}
$eXcatArray .="''";

$eXcatArray =str_replace(",''", "", $eXcatArray);
$exclusionArray = array($eXcatArray);
//print_r($exclusionArray);  //test - displays all categories not to count in delivery min
mysql_close; 
//************process any actions first
if (($action=="savenote")&&(!empty($_POST["notes"]))){
       if($_SESSION['UserKey']=="9999"){
           $query = "Update cart set note = '" . $_POST["notes"] . "' Where  customerID = '" . $_SESSION['UserKey'] . "' AND sessionID = '" . session_id() . "'" ;
       } else {
           $query = "Update cart set note = '" . $_POST["notes"] . "' Where  customerID = '" . $_SESSION['UserKey'] . "'";
       }
  $rt=mysql_query($query);          // query executed
  echo mysql_error();
}
if ($action=="reset"){ //clearing coupon choice so drop-down selector will be displayed again
       //first remove any subitems to keep the data table clean
      $query = "Delete from cart Where parentLineNum ='" . $item . "'";
       mysql_query($query);
       //clear item number so dropdown selector will display
      $query = "Update cart set itemNumber='' Where recordKey = '" . $item . "' or parentLineNum ='" . $item . "'";
      mysql_query($query);          // query executed
  }
if (($action=="addtip")&&($_POST["tipamount"])){
    $query = "Update guestLogin set tipamount = '" . $_POST["tipamount"] . "' Where  UserKey = '" . $_SESSION['UserKey'] . "'";
    $rt=mysql_query($query);          // query executed
     echo mysql_error();
}
if ($action=="rem"){
      $query = "Delete from cart Where recordKey = '" . $item . "' or parentLineNum ='" . $item . "'";
      if(!empty($coupon)){
         $query = "Delete from cart Where couponCode = '" . $coupon . "' AND customerID = '" . $_SESSION['UserKey'] . "'";
      }
      mysql_query($query);          // query executed
      echo mysql_error();
      unset($coupon);  //clear code so items will not be re-added to cart automatically
}
if ($action=="upgrade"){
  //lookup next larger size
    $upgradesize = $_GET['to'];
    $upsell_discount = $_GET['v'];
      $query = "update cart set upsellOffered='0', size = '$upgradesize' Where recordKey = '" . $item . "' or parentLineNum ='" . $item . "'";
    //echo $query ;
    mysql_query($query);
    
    if($upsell_discount>'0.00'){
      $query = "update cart set upgrade_discount='$upsell_discount' Where recordKey = '$item'"; 
      mysql_query($query);          // query executed
      }
}
if ($action=="noupgrade"){
  //mark item as upgrade offered, but cancelled
  $query = "update cart set upsellOffered='2' Where recordKey = '" . $item . "' or parentLineNum ='" . $item . "'";
  mysql_query($query);     
}
if ($crust =="update"){
    $query = "Update cart set itemNumber = '" . $newkey . "' where recordKey = '" . $item . "'";
    //echo $query ;
     mysql_query($query);          // query executed
     echo mysql_error();  //show any error
}
if ($sauce =="update"){
    $query = "Update cart set itemNumber = '" . $newkey . "' where recordKey = '" . $item . "'";
    //echo $query ;
     mysql_query($query);          // query executed
     echo mysql_error();  //show any error
}
if ($action=="empty"){
  $query = "Delete from cart Where  customerID = '" . $_SESSION['UserKey'] . "'";
  $rt=mysql_query($query);          // query executed 
  
$query = "update guestLogin set upselloffered = '0' where userkey='" . $_SESSION['UserKey'] . "'";
  mysql_query($query);
  
}
if ($action=="update"){
  if(!empty($cpnchoice)){
        //user is making a coupon selection - look up line item in cart, get matching coupon info
          $query = "Select couponCode, couponChoice from cart where recordKey = '" . $item . "'";
          $rt=mysql_query($query);
          while($nt=mysql_fetch_array($rt)){
               $cp = $nt[couponCode];
               $cpcat = $nt[couponChoice];
          }
          mysql_close;
         //lookup size from couponitem table, based on line item info
        $sizeqry = "Select size from couponItem where couponCode='" . $cp . "' and categoryKey=" . $cpcat . " and itemNumber=" .$cpnchoice;
        $rt=mysql_query($sizeqry);
        while($nt=mysql_fetch_array($rt)){
              $cpsize = $nt[size];
        }
        mysql_close;
         //update itemnumber and size in cart
        $query = "update cart set itemNumber = " . $cpnchoice;
        if(!empty($cpsize)){
             $query .= " , size = '" . $cpsize . "'";
        }
        //*********************************************
                      //now test selected itemkey
                     $qq = "Select categoryKey from menuItem where itemKey = ".$cpnchoice;
                    $qqr=mysql_query($qq);
                    while($qqt=mysql_fetch_array($qqr)){
            			$currentCat = $qqt[categoryKey];

				
				

				//echo "exlude: $exclude_from_min";

               if (in_array($qqt[categoryKey], $pizzaArray, true)) {
               //if($pcatKey in($pcatArray)){
                                 //item is a pizza
                                 $pizza=1;
                           } else{
                               //item is not a pizza
                                 $pizza=0;
                           }
                           //$icatkey=$qqt[categoryKey];
                    }
                    mysql_close;
        //************************************************
        if($pizza==1){ //set as pizza if it is, so toppings are enabled for line item in cart    if(ispizza($cpnchoice)==1)
             //$query .= " , subitems = '1', categoryKey = '". $pcatKey ."'";
       $query .= " , subitems = '1', categoryKey = '". $currentCat ."'";
             //echo $query;
        } else{
             $query .= " , subitems = '0'";
             //echo $query;
        }
        
        $query .=  " where recordKey = '" . $item . "'";
        mysql_query($query);
  }
$query = "Update cart set freeTopping = '" . $freetopping . "', freeToppingL = '" . $freetoppingL . "', freeToppingR = '" . $freetoppingR . "'
, freeTopping2 = '" . $freetopping2 . "', freeTopping2L = '" . $freetopping2L . "', freeTopping2R = '" . $freetopping2R . "'
, freeTopping3 = '" . $freetopping3 . "', freeTopping3L = '" . $freetopping3L . "', freeTopping3R = '" . $freetopping3R . "'
, freeTopping4 = '" . $freetopping4 . "', freeTopping4L = '" . $freetopping4L . "', freeTopping4R = '" . $freetopping4R . "'
, freeTopping5 = '" . $freetopping5 . "', freeTopping5L = '" . $freetopping5L . "', freeTopping5R = '" . $freetopping5R . "'
 Where recordKey = '" . $item . "'";
//echo $query ;
  $rt=mysql_query($query);          // query executed
  echo mysql_error();
  $query = "Update cart set qty = '" . $_POST['quantity'] . "' Where recordKey = '" . $item . "'";
  $rt=mysql_query($query);          // query executed 
  echo mysql_error();  
  $query = "Update cart set qty = '" . $_POST['quantity'] . "' Where parentLineNum = '" . $item . "'";
  $rt=mysql_query($query);          // query executed 
  echo mysql_error();
  $query = "Update cart set choicea = '" . $_POST['choice1'] . "', choiceb = '" . $_POST['choice2'] . "', choicec = '" . $_POST['choice3'] . "', ";
  $query.= "choiced = '" . $_POST['choice4'] . "', choicee = '" . $_POST['choice5'] . "', choicee = '" . $_POST['choice6'] . "', ";
  $query.= "choicef = '" . $_POST['choice7'] . "', choiceg = '" . $_POST['choice8'] . "', choicei = '" . $_POST['choice9'] . "'";
  $query.=" Where recordKey = '" . $item . "'";
//echo $query ;
  $rt=mysql_query($query);          // query executed
  echo mysql_error();
  
}
if ($action=="addsub"){
  $__topping = explode(',',$topping);
  $__qty     = explode(',',$qty);
  $__item    = explode(',',$item);
  $__parent  = explode(',',$parent);
  if(!empty($__topping) && !empty($__qty) &&  !empty($__item) && !empty($__parent) ){
     for ($i=0; $i < count($__topping); $i++) {
    	
		  //first check if subitem already exists - do not allow duplicate toppings
		  $dupecheck = "select * from cart where itemNumber='".$__item[$i]."' AND parentLineNum='".$__parent[$i]."' and customerID='".$_SESSION['UserKey']."'";
		  $rt_result = mysql_query($dupecheck);
		  //$logging = "insert into test_log (field1, field2) values('mycart.php(0)','".mysql_real_escape_string($dupecheck)."')";
		  //mysql_query($logging);
		  $matching_rows = mysql_num_rows($rt_result);
		  if($matching_rows==0){	   
		      if ($__topping[$i]=="l"){  //if topping=a, ignore since it is for the whole pizza
		        $query = "Insert into cart (qty, itemNumber, parentLineNum, customerID, halfA, sessionID) values ('" . $__qty[$i] . "', '" . $__item[$i] . "', '" . $__parent[$i] . "', '" . $_SESSION['UserKey'] . "', '1', '". session_id() . "')";
		      } elseif($__topping[$i]=="r"){
		        $query = "Insert into cart (qty, itemNumber, parentLineNum, customerID, halfB, sessionID) values ('" . $__qty[$i] . "', '" . $__item[$i] . "', '" . $__parent[$i] . "', '" .  $_SESSION['UserKey'] . "', '1', '". session_id() . "')";
		      } elseif($fixing==1){
		        $query = "Insert into cart (qty, itemNumber, parentLineNum, customerID, fixing, sessionID) values ('" . $__qty[$i] . "', '" . $__item[$i] . "', '" . $__parent[$i] . "', '" .  $_SESSION['UserKey'] . "', '1', '". session_id() . "')";
		      } else{
		        $query = "Insert into cart (qty, itemNumber, parentLineNum, customerID, sessionID) values ('" . $__qty[$i] . "', '" . $__item[$i] . "', '" . $__parent[$i] . "', '" .  $_SESSION['UserKey'] . "', '". session_id() . "')";
		      }
		      $rt=mysql_query($query);          // query executed 
		      echo mysql_error(); 
	      }
      }
  } else {
    if ($topping=="l"){  //if topping=a, ignore since it is for the whole pizza
      $query = "Insert into cart (qty, itemNumber, parentLineNum, customerID, halfA, sessionID) values ('" . $qty . "', '" . $item . "', '" . $parent . "', '" . $_SESSION['UserKey'] . "', '1', '". session_id() . "')";
    } elseif($topping=="r"){
      $query = "Insert into cart (qty, itemNumber, parentLineNum, customerID, halfB, sessionID) values ('" . $qty . "', '" . $item . "', '" . $parent . "', '" .  $_SESSION['UserKey'] . "', '1', '". session_id() . "')";
    } elseif($fixing==1){
      $query = "Insert into cart (qty, itemNumber, parentLineNum, customerID, fixing, sessionID) values ('" . $qty . "', '" . $item . "', '" . $parent . "', '" .  $_SESSION['UserKey'] . "', '1', '". session_id() . "')";
    } else{
      $query = "Insert into cart (qty, itemNumber, parentLineNum, customerID, sessionID) values ('" . $qty . "', '" . $item . "', '" . $parent . "', '" .  $_SESSION['UserKey'] . "', '". session_id() . "')";
    }
    $rt=mysql_query($query);          // query executed 
    echo mysql_error(); 
  }
  $action="editsubs";
}
/*//actions are complete - now make sure sub-items with guest user ID 9999 have the session saved - can't locate where they are being saved...2/28/13 AP
$item_qry = "Select * from cart where customerID='9999' and sessionID is not null";
$rti=mysql_query($item_qry); 
while($nti=mysql_fetch_array($rti)){
  $query = "update cart set sessionID = '$nti[sessionID]' where customerID =  '9999' AND sessionID IS NULL AND parentLineNum = '$nti[recordKey]'";    
  mysql_query($query);
  //echo "test qry: ".$query;
}   
*/  
// *************check store preferences for tax rate and delivery charge if any
$query = "Select deliver, salesTax, deliveryCharge, taxdelivery, include_tipline, half_topping_prices, tip_wording, minimum_order, ordering_age_required, cancel_url, site_terms from storePrefs";
  $rt=mysql_query($query);          // query executed 
  echo mysql_error();                    // if any error is there that will be printed to the screen
  if (mysql_num_rows($rt) !== 0) {
    while($nt=mysql_fetch_array($rt)){
      $wedeliver = $nt[deliver];    //offer delivery
      $tax = $nt[salesTax];
      $delivery = $nt[deliveryCharge];   //delivery cost
      $tipline = $nt[include_tipline];

	  $_SESSION['tipline'] = $nt[include_tipline];
      $_SESSION['ordering_age_required'] = $nt['ordering_age_required'];

	  

	  $_SESSION['cancel_url'] = $nt['cancel_url'];

	  

	  $terms_and_conditions = $nt['site_terms'];
      $tip_wording = $nt[tip_wording];
      $minimum_order = $nt[minimum_order];
      if($nt[half_topping_prices]=='1'){
        $half_topping_prices = TRUE;
      }
      if(!empty($nt[taxdelivery]))  {
      $deltax =  $tax * $delivery;
      } else  {
      $deltax = 0;
      }
    }
  } else {
    $tax = 0;
  }
  mysql_close;
//if delivery is not available at this store, set it to carryout automatically and bypass selction screen
if($wedeliver==0){
	$_SESSION['order_type'] = "carryout";
}

  // *************check user setting for delivery or pickup
$query = "Select pickup, tipamount from guestLogin where UserKey='" . $_SESSION['UserKey'] . "'";
  $rt=mysql_query($query);          // query executed
  echo mysql_error();                    // if any error is there that will be printed to the screen
  if (mysql_num_rows($rt) !== 0) {
    while($nt=mysql_fetch_array($rt)){
        $pickup = $nt[pickup];
      $tipamount = $nt[tipamount];
        if($pickup==1) {    //if method = pickup, clear delivery charge
          $delivery=0;
          $deltax =0;
    }
  }
  }
  
  mysql_close;
//***********initialize variables
  $gtotal = 0;
  $totaltax = 0;
  
 //add coupon to cart if that is what user clicked on...
 if(!empty($coupon)){  //begin loop if coupon selected
      //new coupon code selected, remove any previous coupons entered - only one allowed per order
         //$cpnquery  = "Delete from cart where  sessionID='". session_id() . "' AND (itemNumber IS NULL OR itemNumber<=0)";
         $cpnquery  = "Delete from cart where  sessionID='". session_id() . "' AND couponCode IS NOT NULL";
         mysql_query($cpnquery);
      $cquery = "select * from coupon where code ='" . $coupon . "'";
      $crt=mysql_query($cquery);
      echo mysql_error();
      while($cnt=mysql_fetch_array($crt)){
          if($cnt[active]=='1'){
        $ctype=$cnt[couponType];
         //echo $cpnquery ;
        $cpnquery  = "Update cart set couponCode = NULL where couponCode IS NOT NULL AND sessionID='". session_id() . "'";
         mysql_query($cpnquery);
         
      if(($cnt[couponType]==1)||($cnt[couponType]==2)||($cnt[couponType]==4)){   //Discount amount o r discount percentage
          // this creates a general line item for the discount amount to be deducted from subtotal
           $cpnquery = "Insert into cart (couponCode, customerID, sessionID) values ('" . $coupon . "', '" .  $_SESSION['UserKey'] . "', '". session_id() . "')";
           mysql_query($cpnquery);
           
      }

      if(($cnt[couponType]==3)||($cnt[couponType]==4)){  //coupon is linked to certain items, add those items to cart now
           //get items from couponitem table
           $cpnitms = "Select count(distinct categoryKey) as itemcount from couponItem where couponCode ='" . $coupon . "'";
           $citem = mysql_query($cpnitms);
           while($cit=mysql_fetch_array($citem)){
                 $itemcount= $cit[itemcount];   //this is the count of how many items are included in the coupon
           }
           mysql_close;
           $x=1;
           while ($x <=$itemcount) {
                //check how many items are in choice list $x
                $choices="Select * from couponItem where categoryKey =" . $x . " AND  couponCode ='" . $coupon . "'";
                $ch=mysql_query($choices);
                if(mysql_num_rows($ch)==1){
                  while($cht=mysql_fetch_array($ch)){
                     //$pcatKey is pizza category key
                    //get category key for this item
                    $qq = "Select categoryKey from menuItem where itemKey = ".$cht[itemNumber];
                    $qqr=mysql_query($qq);
                    while($qqt=mysql_fetch_array($qqr)){
                           //if($pcatKey == $qqt[categoryKey]){
              if (in_array($qqt[categoryKey], $pizzaArray, true)) {
                                 //item is a pizza
                                 $pizza=1;
                           }
                           else{
                               //item is not a pizza
                                 $pizza=0;
                           }
                           $icatkey=$qqt[categoryKey];
                    }
                    mysql_close;
                    $cpnquery = "Insert into cart (itemNumber, qty, couponCode, customerID, sessionID, couponChoice, size, subitems, categoryKey) values ('".$cht[itemNumber]  . "', '1','" . $coupon . "', '" .  $_SESSION['UserKey'] . "', '". session_id() . "','" . $x . "', '".$cht[size]  . "', '". $pizza . "', '". $icatkey . "')";

                  }
                }else{
                   $cpnquery = "Insert into cart (qty, couponCode, customerID, sessionID, couponChoice) values ('1','" . $coupon . "', '" .  $_SESSION['UserKey'] . "', '". session_id() . "','" . $x . "')";
                }
                mysql_close;
           mysql_query($cpnquery);
           $x=$x+1;
           }
           
      }
      }//end of 'if coupon active' loop
        else{
          echo '<div align="center"><font color="red"><br><br><br>We\'re sorry, but that coupon has expired.</font></div>';
        }
      } //end while loop
      mysql_close;
} else{   //end loop if coupon selected
      //see if any coupons are in use in this cart - if so, get type of coupon so cart can be calculated correctly
      $cquery = "Select max(couponCode) as couponCode from cart where sessionID = '" .session_id() . "'";
      //echo $cquery ;
      $crt=mysql_query($cquery);
      while($cnt=mysql_fetch_array($crt)){
            $coupon = $cnt[couponCode];
      }
      mysql_close;
      if(!empty($coupon)){
      $cquery = "select couponType from coupon where code ='" . $coupon . "'";
      $crt=mysql_query($cquery);
      echo mysql_error();
      while($cnt=mysql_fetch_array($crt)){
        $ctype=$cnt[couponType];
     }
     mysql_close;
     }
}
//**********Look up cart list from database for logged in user
  if($_SESSION['UserKey']=="9999"){
      $query = "Select * from cart where customerID = '9999' AND sessionID = '" . session_id()  .  "' AND parentLineNum = '' AND qty>0 order by itemNumber";
  } else {
      $query = "Select * from cart where customerID = '" . $_SESSION['UserKey'] . "' AND parentLineNum = '' AND qty>0 order by itemNumber";
  }
  $rt=mysql_query($query);          // query executed
  echo mysql_error();                    // if any error is there that will be printed to the screen
//if minimum order age exists, show age verification prompt
if($_SESSION['ordering_age_required']>0 && $_SESSION['verified']!=1){

			If($_SESSION['cancel_url']>""){$cancel_url=$_SESSION['cancel_url'];}else{$cancel_url="?v=0";}

		    $popup_html = '<div id="order-choice-wrapper21">

				<img src="images/21-plus.svg" alt="21 and older only" />

				<h1 style="text-align:center;">Are you at least '.$_SESSION['ordering_age_required'].' years old and agree to the terms of this site?</h1>';
			//$popup_html .='<a href="terms" target="_blank">View terms</a><br><br>';

			

			$popup_html .='<a href="#open-modal">View terms</a>

				<div id="open-modal" class="modal-window">

				  <div>

				    <a href="#modal-close" title="Close" class="modal-close">close &times;</a>

				    <h1>Terms & Conditions</h1>

				    <div>'.$terms_and_conditions.'</div>

				  </div>

				</div><br><br>';

			

		    $popup_html .= '<a class="choice-button" href="?v=1">YES</a> ';
		    $popup_html .= '<a class="choice-button" href="'.$cancel_url.'">NO</a>';
			//$popup_html .= '<br>By clicking yes, I am agreeing';
		    $popup_html .= '</div>';  
			
						?>
	    	<meta name="viewport" content="width=device-width, initial-scale=1">
			<!--<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">-->
			<link rel="stylesheet" href="css/bootstrap.css">
			<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
			<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
			<style>
			  .modal-body, h4, .close {
			      /*background-color: #5cb85c;*/
			      color:white;
			      opacity:1;
			      text-align: center;
			      /*font-size: 30px;*/
			  }
			  .modal-footer {
			      background-color: #f9f9f9;
			  }
			 /* .modal {
				   background-color: gray;
				   opacity:1;
				}*/
			.fade.in{
				background-color: black;
				opacity:1;
				}
	
			</style>
	    	<script>
			$(function() {
			$("#myModal").modal({backdrop: false});//if you want you can have a timeout to hide the window after x seconds
			});
			</script>
			<!-- Modal -->
		  <div class="modal fade" id="myModal" role="dialog">
		    <div class="modal-dialog">
		      <!-- Modal content-->
		      <div class="modal-content">
	
		        <div class="modal-body">
		          <p><?php echo $popup_html;?></p>
		        </div>
	
		      </div>
		
		    </div>
		  </div>
	    	<?php
}elseif($_SESSION['order_type']=="unknown" || !isset($_SESSION['order_type'])){
    	//print_r($_SESSION);	
    	
		if($_SESSION['brand']=="froogle"){
		    $carryout_icon = "carryout_liquor.png";
		    $delivery_icon = "delivery_liquor.png";
		} else {
		    $carryout_icon = "carryout.png";
		    $delivery_icon = "delivery.png";
		}
		$type_options = 1; //carryout is default and always available
    	//if delivery is available
    	if($_SESSION['delivery_enabled']==1 && ($_SESSION['delivery_open']==1 || $_SESSION['future_orders']==1)){
    		$deliver_button = '<a href="?type=delivery" class="typeOfOrder" data-id="delivery"><img src="images/'.$delivery_icon.'"></a>';
			$type_options++;
    	} else {
    		$deliver_button = '';
		}
    	//if dine-in is available
    	if($_SESSION['dine_in_enabled']==1){
    		$dine_button = '<a href="?type=dine" class="typeOfOrder" data-id="dine"><img src="images/dine.png"></a>';
			$type_options++;
    	} else {
    		$dine_button = '';
		}
		
		    	
    	if($type_options>1){
		    $popup_html = '<div id="order-choice-wrapper">
				<h1 style="text-align:center;">Start a new order:</h1>';
			$popup_html .= $deliver_button;
		    //echo '<a href="?type=delivery" class="typeOfOrder" data-id="delivery"><img src="images/delivery.png"></a>';
		    $popup_html .= '<a href="?type=carryout" class="typeOfOrder" data-id="carryout"><img src="images/'.$carryout_icon.'"></a>';
			$popup_html .= $dine_button;
		    $popup_html .= '</div>';
		} else {
			$_SESSION['order_type']="carryout";
			
		}
		if($_SESSION['order_type']=="unknown" || !isset($_SESSION['order_type'])){
			?>
	    	<meta name="viewport" content="width=device-width, initial-scale=1">
			<!--<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">-->
			<link rel="stylesheet" href="css/bootstrap.css">
			<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
			<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
			<style>
			  .modal-body, h4, .close {
			      /*background-color: #5cb85c;*/
			      color:white;
			      opacity:1;
			      text-align: center;
			      /*font-size: 30px;*/
			  }
			  .modal-footer {
			      background-color: #f9f9f9;
			  }
			 /* .modal {
				   background-color: gray;
				   opacity:1;
				}*/
			.fade.in{
				background-color: black;
				opacity:1;
				}
	
			</style>
	    	<script>
			$(function() {
			$("#myModal").modal({backdrop: false});//if you want you can have a timeout to hide the window after x seconds
			});
			</script>
			<!-- Modal -->
		  <div class="modal fade" id="myModal" role="dialog">
		    <div class="modal-dialog">
		      <!-- Modal content-->
		      <div class="modal-content">
	
		        <div class="modal-body">
		          <p><?php echo $popup_html;?></p>
		        </div>
	
		      </div>
		
		    </div>
		  </div>
	    	<?php
    	}
    }
//end of order type popup

if ($upsell!=="1") {  //show cart if upsell flag not set    
  if (mysql_num_rows($rt) == 0) {
  //************nothing in cart for logged in user, display message...
    //echo $query;
      echo '<div align="center">';
        if($_SESSION['UserKey']=="9999"){ echo '<div style="clear:both;"></div><h1>Welcome guest!</h1> ';}
    //echo'<div style="clear:both;"></div><strong>We are ready to take your order!</strong> <br />Select from below; please enter a quantity by the the item you want and click the "add to order" button.</i></font><br /></div>';
    echo'<div style="clear:both;"></div></div>';
    if($_SESSION['order_type']=="unknown" || !isset($_SESSION['order_type'])){
    	//print_r($_SESSION);	
    } else {
    	if($_SESSION['favorites']==1){
			echo "<center>To re-order one of your favorite orders, click on the <b>My Favorites</b> tab!</center>";
    	}	
?>
    	<script type="text/javascript">
		 
		  
		    $(document).ready(function() {
		         $("#menu_modal").popup("show");
        		 $(".menu_modal_open").click();
		    });
		
		 //alert("TEST");
		 
		 </script>
 <?php
    	echo '<div id="add-to-order-button"><span class="menu_modal_open" id="test">Add Items to Order</span></div><div style="clear:both;"></div>';
		//echo '<span class="menu_modal_open" id="test"></span></div><div style="clear:both;">';
		//automatically pop up ordering menu
		?>
		<!--<meta name="viewport" content="width=device-width, initial-scale=1">-->
		<!--<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">-->
		<!--<link rel="stylesheet" href="css/bootstrap.css">
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
		<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
		<style>
		  .modal-body, h4, .close {
		      /*background-color: #5cb85c;*/
		      color:white;
		      opacity:1;
		      text-align: center;
		      /*font-size: 30px;*/
		  }
		  .modal-footer {
		      background-color: #f9f9f9;
		  }
		 /* .modal {
			   background-color: gray;
			   opacity:1;
			}*/
		.fade.in{
			background-color: transparent;
			opacity:1;
			}
		</style>
    	<script>
		$(function() {
		$("#myModal").modal({backdrop: true});//if you want you can have a timeout to hide the window after x seconds
		});
		</script>-->
		<!-- Modal -->
	  <!--<div class="modal fade" id="myModal" role="dialog">
	    <div class="modal-dialog">-->
	      <!-- Modal content-->
	     <!-- <div class="modal-content">
	        <div class="modal-body">
	          <p>insert order menu...<?php include('ordermenu.php');?></p>
	        </div>
	      </div>
	
	    </div>
	  </div>-->
	  <?php
		//end of popup menu
    }
    //echo '<div id="add-to-order-button"><span class="menu_modal_open" id="test">Start Your Order</span></div><div style="clear:both;"></div>';
    //see if any coupons exist in cart. Display message confirming.
      $cpnquery = "Select max(couponCode) as couponCode, recordKey from cart where sessionID = '" . session_id()  .  "' AND couponCode is not null"; // and itemNumber=''";
      //echo $cpnquery  ;
      $rt7=mysql_query($cpnquery);          // query executed
      while($nt7=mysql_fetch_array($rt7)){
      	if(!empty($nt7[couponCode])){
      		echo '<br /><div align="center"><font color="blue"><b>You have added coupon #' . $nt7[couponCode] . ' to your cart.</b> <br />Please add items to your order in order to receive your discount.</font></div><br /><br />' ;
      	}
      }
      mysql_close;
      
  } else {  
    //***********cart found for user...display current user's cart contents 
    
    //**************Unhide this style section to view table lines while troubleshooting
    //echo "<style>table, th, td{border: 1px solid black;}</style>";
    echo "<style>
    #item-level {
      border: 1px solid black;
      background-color: yellow !important; 
      color:yellow;
    }
    </style>";
	echo '<style>
		.toggle-btn-group label {
	  padding: .5em .2em;
	  display: inline-block;
	  width: 7.5em;
	  float: left;
	  text-align: center;
	  cursor: pointer;
	  color: #000;
	  background-color: #ddd;
	  border: #999 1px solid;
		}
			.toggle-btn-group label:first-of-type {
		  border-top-left-radius: .3em;
		  border-bottom-left-radius: .3em;
		}
		.toggle-btn-group label:last-of-type {
		  border-top-right-radius: .3em;
		  border-bottom-right-radius: .3em;
		  margin-right:5px;
		}
		
		.toggle-btn-group input[type="radio"]:checked+label {
		  background-color: #48A3DB;
		  border: #000 1px solid;
		  color: #fff;
		}
		.toggle-btn-group input[type="radio"]:focus+label {
		  outline: 0px #999 dotted;
		}
		
		.toggle-btn-group label:hover,
		.toggle-btn-group label:focus {
		  background-color: #ccc;
		  border: #000 1px solid;
		  color: #000;
		}
		/* hide visually */
.accessAid {
	position: absolute!important;
	clip: rect(1px,1px,1px,1px);
	overflow: hidden;
}
		</style>';
		
		
    //display order title and column headers
    echo '<div id="order-title"><h2>My Order</h2>';
	if($_SESSION['order_type']=="carryout"){
		$carry_select = 'checked="checked"';
		$deliver_select = '';
	} elseif($_SESSION['order_type']=="delivery") {
		$carry_select = '';
		$deliver_select = 'checked="checked"';
    }
	
	//show delivery/carryout toggle if delivery is enabled
    if($_SESSION['delivery_enabled']==1 && ($_SESSION['delivery_open']==1 || $_SESSION['future_orders']==1)){
		echo'<div style="float:right;"><form>
		  <div class="toggle-btn-group clearfix">
			<input type="radio" id="carryout" name="order_type" value="carryout" class="accessAid" '.$carry_select.' />
			<label for="carryout">Carry Out</label>
			<input type="radio" id="delivery" name="order_type" value="delivery" class="accessAid" '.$deliver_select.'/>
			<label for="delivery">Delivery</label>
		  </div>
		</form></div>';
	}
    
    
    echo '</div>
  <div id="top-add-button"><span class="menu_modal_open">Add to Your Order</span></div>
  <div style="clear:both;"></div>
  <div id="order-window">';
    echo '<table width=100% border=1 cellpadding=1 cellspacing=0><tr><th class="left">Qty</th><th>Item</th>';
    echo '<th class="right"><div align="right">Total &nbsp; </div></th></tr>';
    if($mobile==1){
      $direct_to = "updateMobCart";
    } else {
      $direct_to = "updateCart";
    }
    
    while($nt=mysql_fetch_array($rt)){  //step through item records and display each separately
      //echo '<div id="item-level"><table><tr><td>';
      $recordkey = $nt[recordKey];
      $formname = "cartform$recordkey";
      echo '<tr><form id="cartform'.$recordkey.'" action="/order?a=update&item=' .  $recordkey .'" method="post"><td valign="top"><input type="hidden" id="recordkey" name="recordkey" value="'.$recordkey.'"><input type="text" name="quantity" id="quantity'.$recordkey.'" size=1 maxlength=2 onChange="'.$direct_to.'('.$recordkey.')" value="' . $nt[qty] . '"';
      if(!empty($nt[couponCode])){
        echo ' readonly="readonly"';
      }
      echo' data-form-id="cartform'.$recordkey.'">';
      //change database connection if using shared menu database
      if(!empty($menudatabase)){
        include ('includes/db2config.php');
        include ('includes/mysql_connect.php');
      }
      if($nt[itemNumber]>0){  //check for item number first because coupon line items may not have item numbers assigned yet
        //***********for each item in cart, look up name, price and tax status from menu item table
        $query2 = "Select * From menuItem Where itemKey = '" . $nt[itemNumber] . "'";
        $rt2=mysql_query($query2);          // query executed 
        echo mysql_error();                    // show any errors
        $note = $nt[note];
        if (mysql_num_rows($rt2) !== 0) {
        
        //**********if item found, use to set price and tax status variables
          while($nt2=mysql_fetch_array($rt2)){
            if($nt2[usefixings]>0) {$usefixings=1;} else {$usefixings=0;}
			if($_SESSION[order_type]=="carryout" && $nt2[carryout_price]>0){
				$price = $nt2[carryout_price];
			} else {
				$price = $nt2[itemPrice];
			}
            //$price = $nt2[itemPrice];
            $taxable = $nt2[taxable];
            $upsell_disc = $nt2[upsell_pct_disc];
            $upsell_cost = $nt2[upsell_cost];

			

			$currentCat = strval($nt2[categoryKey]);
			$default_tax = $tax;
			$qry = "select cat_tax_override from menuCategory where RecordKey='$currentCat'";
			
			if ($result = $mysqli->query($qry)) {
    			 if ($result->num_rows >0) {
    			    $row = $result->fetch_assoc();
                    if($row["cat_tax_override"]>0){
                        //echo "cat_tax_override: " . $row["cat_tax_override"]. "<br>";
                        $category_tax = $row["cat_tax_override"];
                        $tax = $category_tax;
                    }
                 } else {
                    //echo "$qry: 0 results";
                    $tax = $default_tax;
                 }
			}
		
            //print_r($exclusionArray);

            /*

			 if (in_array($currentCat, $exclusionArray, true)) {

					$exclude_from_min = 1; //die("EXCLUDE $currentCat");

				}else {

					$exclude_from_min = 0; //die("NONEXCLUDE $currentCat");

				}

			 * */

			 foreach ($exclusionArray as $exclusionCat) {

			 	//echo "<br>$exclusionCat $currentCat";

			    if ($exclusionCat == "$currentCat") {

			        $exclude_from_min = 1; //die("EXCLUDE $currentCat");

			        break;

			    }

			}
            echo '<td><div style="padding-top:8px;" align="left"><span class="item-name">' . $nt2[itemName];

			//echo "<br> $exclude_from_min";

            echo '<div id="remove-line"><a href="/order?a=rem&item=' .  $nt[recordKey] .'&coupon=' . $nt[couponCode] . '">
            <div id="remove-icon"><img src="images/remove-icon.png" style="border:none;margin-left:0em;" /></div> <div id="remove-text-product">[Remove]</div></a></div>';
            
            echo '</span>';
            
            if(!empty($nt[size])){echo "<div class='item-size'> - $nt[size]</div>";}
            echo "<td><div align='right'>"; //this <cell> is the price column
            //************if a size is selected, look up price for selected size
              if($nt[size]!==""){ 
                $size = $nt[size];
                $query3 = "Select price, carryout_price from itemSize where itemKey = '" . $nt[itemNumber] . "' AND size = '"  . $nt[size] . "'" ;
                $rt3=mysql_query($query3);          // query executed 
                echo mysql_error();                    // if any error is there that will be printed to the screen
                while($nt3=mysql_fetch_array($rt3)){
                  //$price = $nt3[price];
					if($_SESSION[order_type]=="carryout" && $nt3[carryout_price]>0){
						$price = $nt3[carryout_price];
					} else {
						$price = $nt3[price];
					}
                } 
                mysql_close;
              } 
              
              if((!empty($nt[couponCode]))&&($ctype==3)){   //if coupon item, zero out price
                $price=0;
              }
              
              //************if menu item is set as taxable, add tax amount to running tax total
              if($taxable==1){
                $totaltax = number_format($totaltax + ($tax * ($price * $nt[qty])), 2, '.', ',');
              }
              //reset tax to default
              	$tax = $default_tax;
              //**********for current item, add pricing to running total and running grand total
                $total = $price * $nt[qty];
                $gtotal = $gtotal + $total;

				$min_order_total = $min_order_total + $total; //echo "<br>total: $min_order_total<br>";

				if($exclude_from_min==1){

					$min_order_total = $gtotal - $total;

				}

              if($nt[upsellOffered]=="1"){  //when = 1, need to offer size upsell if available
                //get price of item currently in cart (will offer upgrade only if more expensive option exists)
                if($nt[size]!==""){ 

                  $query3 = "Select price from itemSize where itemKey = '" . $nt[itemNumber] . "' AND size = '"  . $nt[size] . "'" ;
                  while($nt3=mysql_fetch_array($rt3)){
                    $price = $nt3[price];
                  } 
                } 
                //size upsell is selected, check for larger sizes
                //first check for sizes not allowed for selected crust...
                //lookup current crust selection
                $crquery = "select itemNumber from cart where parentLineNum ='$nt[recordKey]' and crust='1'";
                //echo"qry=".$crquery."<br />";
                $crust_rt=mysql_query($crquery);
                while($crust_nt=mysql_fetch_array($crust_rt)){
                  $selected_crust=$crust_nt[itemNumber];  //this is selected crust
                  //echo"selected_crust=".$selected_crust."<br />";
                }
                //now see what sizes not allowed for this crust
                $crquery = "select sizekey from crust_bad_size where itemkey='$selected_crust'";
                //echo"qry=".$crquery."<br />";
                $crust_rt=mysql_query($crquery);
                $bad_size_keys ="'0'";
                while($crust_nt=mysql_fetch_array($crust_rt)){
                  $bad_size_keys .= ",'$crust_nt[sizekey]'";  //this is selected crust
                }
                //now convert bad size keys to size names for comparing
                $crquery = "Select sizeName from sizeMaster where recordKey in($bad_size_keys)";
                //echo"qry=".$crquery."<br />";
                $crust_rt=mysql_query($crquery);
                $bad_size_array ="'TEST'";
                while($crust_nt=mysql_fetch_array($crust_rt)){
                  $bad_size_array .= ",'$crust_nt[sizeName]'";  //this is selected crust
                }
                
                
                $sizeqry = "select * from itemSize where itemKey = '$nt[itemNumber]' 
                AND size not in ($bad_size_array)
                AND price > '$price' order by price asc";     
                $srt=mysql_query($sizeqry);
                //echo"qry=".$sizeqry."<br />";
                //echo mysql_error(); 
                if(mysql_num_rows($srt)>0){
                  while($nrt=mysql_fetch_array($srt)){
                    $newsize = $nrt['size'];
                    $newprice = $nrt['price'];
                    $pricediff = $newprice - $price;
                    break;
                  }
                  $upgrade_available = TRUE;
                } else {
                  $upgrade_available = FALSE;
                }

                //**********for current item, display line item total cost
                echo  '$' . number_format($total, 2, '.', ',');

                if($upgrade_available == TRUE){
                  //larger size available - offer upgrade here
                  if($upsell_cost >'0.00'){
                    $upgrade_cost = $upsell_cost;
                    $savings = $pricediff - $upgrade_cost;
                    if($savings<0){$savings="0.00";}
                  } elseif ($upsell_disc >'0.00') { 
                    $upgrade_cost = $pricediff - ($pricediff*$upsell_disc); 
                    $savings = $pricediff - $upgrade_cost;
                    if($savings<0){$savings="0.00";}
                  } else {
                    $upgrade_cost = $pricediff;
                    $savings="0.00";
                  }
                  //make sure cost is formatted as currency
                  $upgrade_cost = number_format($upgrade_cost, 2, '.', '');

                  echo"<tr><td colspan=3><div id='upgrade-bubble'><div id='upgrade-text'>Would you like to upgrade to a $newsize for just $$upgrade_cost more?</div>
                  <div id='yes-no-wrapper'><div id='no-button'><a href='/order?a=noupgrade&item=$nt[recordKey]'>No</a></div>
                  <div id='yes-button'><a href='/order?a=upgrade&to=$newsize&item=$nt[recordKey]&v=$savings'>Yes</a></div></div>
                  <div style='clear:both;'></div></div>";
                } 
                #################   
              } else {
                //**********for current item, display line item total cost
                echo  '$' . number_format($total, 2, '.', ',');
              }
              
              echo '</div>';  //end of line item price cell
              
              //show any upsell upgrade discounts
              if($nt[upgrade_discount]>'0.00'){
                $line_discount = number_format($nt[upgrade_discount]*$nt[qty], 2, '.', '');
                echo "<tr><td colspan=2><div align='right'>Upgrade Discount: <td><div align='right'>-$".$line_discount;
                $total_discount = $total_discount + $line_discount;
                //************if menu item is set as taxable, deduct tax amount from running tax total
                if($taxable==1){
                  $totaltax = number_format($totaltax - ($tax * $line_discount), 2, '.', ',');
                }
                //**********for current item, deduct pricing from running total and running grand total
                //$total = number_format($total - $line_discount, 2, '.', ',');
                //$gtotal = number_format(($gtotal - $line_discount), 2, '.', ',');
              }
              ####################
            echo "<tr><td colspan=2>";
            //}
            if(!empty($nt[couponChoice])){
              //check if there are more choices available
              $cpchoice = "Select * from couponItem where couponCode = '" . $nt[couponCode] . "' AND categoryKey = " . $nt[couponChoice];
              //echo $cpchoice ;
              $crt=mysql_query($cpchoice);
              if (mysql_num_rows($crt) >1) {    //more than one option available, add link here to change selected option
                echo '<div align="left" ><a href="/order?a=reset&item=' .  $nt[recordKey] .'">
                <font color="green"><i>[Change Selection]</i></font></a></div>';
              }
              mysql_close;
            }
          if(!empty($nt[couponCode])){
            echo '<div align="left" ><font color="red"><b>Coupon #' . $nt[couponCode] . '</b></font></div>';
          }
          
          //get category key for pizza topping category
          $pquery = "SELECT recordKey, categoryName from menuCategory WHERE active ='1' And categoryName = 'Pizza Toppings'";
          $rt6=mysql_query($pquery);          // query executed
          //echo mysql_error();                    
          while($nt6=mysql_fetch_array($rt6)){
            $pcatKey = $nt6[recordKey];
          }
          //get category key for pizza category
          $pquery = "SELECT recordKey, categoryName from menuCategory WHERE active ='1' And categoryName = 'Pizza'";
          $rt6=mysql_query($pquery);          // query executed
          //echo mysql_error();                   
          while($nt6=mysql_fetch_array($rt6)){
            $pizzacatKey = $nt6[recordKey];
          }
            //get category key for option category
          $pquery = "SELECT recordKey, categoryName from menuCategory WHERE active ='1' And categoryName = 'Options'";
          $rt6=mysql_query($pquery);          // query executed
          echo mysql_error();                    // if any error is there that will be printed to the screen
          while($nt6=mysql_fetch_array($rt6)){
            $ocatKey = $nt6[recordKey];
          }
          echo '<input type="hidden" id="recordkey" name="recordkey" value="'.$recordkey.'">';
          //if freeTopping field used, allow user to make selection
          if($nt2[freeTopping]>0) { //this variable will be set to the number of free toppings included
            echo "<div id='select-free-wrapper'><div id='free-toppings-selected-display" .$recordkey ."' style='display:none; background-color: transparent;'></div><button id='save-button2' class='free_toppings_modal".$recordkey."_open'>Select Free Toppings</button>";
            echo '<div id="free_toppings_modal'.$recordkey.'" class="popup_modal"><a onclick="updateCart('.$recordkey.')" href="#" class="free_toppings_modal'.$recordkey.'_close modal_close_button"><img src="/images/x-15.png" width="15" height="15" /></a>';
            //build drop down topping selector
            $counter = 0;
            $t_num = "1";
            $fieldname = "freetopping";
            $fieldselected = $nt[freeTopping];
            $fieldselectedA = $nt[freeToppingL];
            $fieldselectedB = $nt[freeToppingR];
            include('topping_selector.php');
            if($nt2[freeTopping]>1) { //add second free topping selector
              //echo "free toppings: " . $nt2[freeTopping];
              $counter = 0;
              $t_num = "2";
              $fieldname = "freetopping2";
              $fieldselected = $nt[freeTopping2];
              $fieldselectedA = $nt[freeTopping2L];
              $fieldselectedB = $nt[freeTopping2R];
              include('topping_selector.php');
            }
            if($nt2[freeTopping]>2) { //add third free topping selector
              $counter = 0;
              $t_num = "3";
              $fieldname = "freetopping3";
              $fieldselected = $nt[freeTopping3];
              $fieldselectedA = $nt[freeTopping3L];
              $fieldselectedB = $nt[freeTopping3R];
              include('topping_selector.php');
            }
            if($nt2[freeTopping]>3) { //add fourth free topping selector
              $counter = 0;
              $t_num = "4";
              $fieldname = "freetopping4";
              $fieldselected = $nt[freeTopping4];
              $fieldselectedA = $nt[freeTopping4L];
              $fieldselectedB = $nt[freeTopping4R];
              include('topping_selector.php');
            }
            if($nt2[freeTopping]>4) { //add fifth free topping selector
              $counter = 0;
              $t_num = "5";
              $fieldname = "freetopping5";
              $fieldselected = $nt[freeTopping5];
              $fieldselectedA = $nt[freeTopping5L];
              $fieldselectedB = $nt[freeTopping5R];
              include('topping_selector.php');
            }             echo '<button id="save-button" class="free_toppings_modal'.$recordkey.'_close" type="button" onclick="updateCart('.$recordkey.')">Update</button>';
            echo '</div>'; // closing div tag for free toppings modal
            ?>
            <script type="text/javascript">
              $('#free_toppings_modal<?php echo $recordkey; ?>').popup();
            </script>
            <?php
          }      //end of free topping loop
            ?>
            <script type="text/javascript">
              function selectFreeToppingChanged(inObj, inFieldname, inRecordKey) {
                if($(inObj).val() == 'split') {
                  newHtml = '<div id="'+inFieldname+'SplitSelectors'+inRecordKey+'">';
                    newHtml += "<div style='height:5px;width:100%;clear;both;'></div>";
                    newHtml += "";
                  <?php
                    //build left half topping selector
                    $resultA = mysql_query("SELECT itemName, itemKey FROM menuItem Where active=1 AND categoryKey = '" . $pcatKey  . "' order by itemName"); 
                  ?>
                    newHtml += '&nbsp;&nbsp;&nbsp;<select name="'+inFieldname+'A" id="'+inFieldname+'A'+inRecordKey+'"><option value="" size="8"><span class="selector-text"> select Left half topping &nbsp; &rarr; </span></option>';
                  <?php
                    while ($rowA = mysql_fetch_array($resultA)){ ?>
                      newHtml += '<option value="<?php echo $rowA["itemName"]; ?>"><?php echo $rowA["itemName"]; ?></option>';
                  <?php } ?>
                    newHtml += "</select><br />";
                    
                  <?php 
                    //build right half topping selector
                    $resultB = mysql_query("SELECT itemName, itemKey FROM menuItem Where active=1 AND categoryKey = '" . $pcatKey  . "' order by itemName");
                  ?> 
                    newHtml += "&nbsp;&nbsp;&nbsp;<select name='"+inFieldname+"B' id='"+inFieldname+"B"+inRecordKey+"'><option value='' size='8'><font color='red'> select Right half topping &rarr; </font></option>";
                  <?php
                    while ($rowB = mysql_fetch_array($resultB)){ ?>
                      newHtml += "<option value='<?php echo $rowB["itemName"]; ?>'><?php echo $rowB["itemName"]; ?></option>" ;
                  <?php } ?>
                    newHtml += "</select>";
                    newHtml += "<br /><br />";
                    
                    newHtml += '</div>'; // close div tag for #freeToppingsSplitSelectors
                  
                  $(inObj).after(newHtml);
                }else{
                  $("#"+inFieldname+"SplitSelectors"+inRecordKey).remove();
                }
                toggleAddMoreToppingsButton();
              }
              function toggleAddMoreToppingsButton() {
                $('.free-topping-selections').each(function() {
                  var recordkey = $(this).val();
                  var allFreeToppingsSelected = true;
                  $('.freetopping-'+recordkey).each(function() {
                    if ($(this).val().length < 1 || $(this).val() == 'none') {
                      allFreeToppingsSelected = false;
                    }
                  });
                  if (allFreeToppingsSelected) {
                    $('.add-more-toppings-'+recordkey).show();
                  } else {
                    $('.add-more-toppings-'+recordkey).hide();
                  }
                });
              }
              $(document).ready(function() {
                toggleAddMoreToppingsButton();
              });
            </script>
            <?php
          }
          //echo '</div>';
        }  //end of item found loop
          //check to see if any options are set up for this menu item. if so, show option selectors
          $optquery = "Select * from options where parentkey = " . $nt[itemNumber];
          $oq=mysql_query($optquery);          // query executed
            echo mysql_error();                    // show any errors
              if (mysql_num_rows($oq) !== 0) {
                include('options.php');
          }
          mysql_close;
          
        if($mobile!==1){
        //$tab="<td>";
        $tab=" ";
        }else{
          unset($tab);
        }
        //echo '</div></td><td valign="top" align="right">';
        /*
        //************if a size is selected, look up price for selected size
          if($nt[size]!==""){ 
            $size = $nt[size];
            if($mobile!==1){
              //echo  '&nbsp;&nbsp;' . $nt[size];
            }
                $query3 = "Select price from itemSize where itemKey = '" . $nt[itemNumber] . "' AND size = '"  . $nt[size] . "'" ;
                $rt3=mysql_query($query3);          // query executed 
                echo mysql_error();                    // if any error is there that will be printed to the screen
                while($nt3=mysql_fetch_array($rt3)){
                  $price = $nt3[price];
                } 
                mysql_close;
          } 
          if((!empty($nt[couponCode]))&&($ctype==3)){   //if coupon item, zero out price
            $price=0;
          }
          //************if menu item is set as taxable, add tax amount to running tax total
          if($taxable==1){
            $totaltax = number_format($totaltax + ($tax * ($price * $nt[qty])), 2, '.', ',');
          }
              
        } 
        //**********for current item, add pricing to running total and running grand total
          $total = number_format(($price * $nt[qty]), 2, '.', ',');
          $gtotal = number_format(($gtotal + $total), 2, '.', ',');
        
        //**********for current item, display line item total cost
          echo  $tab . '$' . number_format($total, 2, '.', ',');
          //echo  '<td width=30 valign="top">' ;
          echo  '</div>' ;
        */
        //***********if subitems allowed (for additional pizza toppings) - display currently selected toppings and add option to add more
        //echo '   ';
        //echo '<tr><td colspan=3>';
          $currentkey="'$nt[categoryKey]'";
          if (strpos($pcatArray,$currentkey )!==false) {
          //if ($nt[categoryKey]==$pizzacatKey){ 
          include('toppings.php');
            /*echo'<tr><td colspan=3>
              <div class="arrowlistmenu">
              <h3 class="menuheader expandable"><img src="images/edit-icon.png" style="border:none;" />Add more toppings</h3>
              <ul class="categoryitems"><table><tr><td>';
              echo'</table></ul>            
              </div>';  */
          }
          //if ($nt[subitems]==1){ include('toppings.php'); }
      //**********if fixings allowed for this item, include current and available fixings for customer to add/remove from order
        if($usefixings ==1){include('fixings.php');}
      } else{ //if there is a coupon item that needs a choice made
        echo '<td valign="top"><div align="left"><font color="blue">';
        echo '<select name="cpnchoice"><option value="">--Make a selection--</option>';
         $options="select * from menuItem where itemKey in(select itemNumber as itemKey from couponItem where couponCode='" .$nt[couponCode] . "' and categoryKey=" .$nt[couponChoice] . ")";
        $op=mysql_query($options);          // query executed
              while($ont=mysql_fetch_array($op)){
          echo'<option value='.$ont[itemKey].'>' .$ont[itemName];
          //check for size requirement
          $szquery = "Select size from couponItem where couponCode='" .$nt[couponCode] . "' and categoryKey=" .$nt[couponChoice] . " and itemNumber=" .$ont[itemKey];
            $sz=mysql_query($szquery);          // query executed
            while($snt=mysql_fetch_array($sz)){
              echo ' - ' . $snt[size];
            }
            mysql_close;
          echo '</option>';
        }
        mysql_close;
      echo '</select>';
      echo '</font> -
      <a href="/order?a=rem&item=' .  $nt[recordKey] .'&coupon=' . $nt[couponCode] . '"><font size=1 color="red"><i>[Remove]</i></font></a></div><br />';
      echo '<div align="center" ><font color="red"><b>Coupon #' . $nt[couponCode] . '</b></font></div><br />';
      }
    
      echo '<br /><tr>
      <td><td colspan=2><!--<div align="right"><input id="save-button" type="submit" name="save" value="Update"></div>--></form>
      
      <div style="margin-top:.4em;margin-bottom:.5em;"><tr><td colspan=3 style="height:.4em;background-color:#666;"></td></tr></div>';
      
    }
    //echo "</table></div>";
    //check if delivery selected = if not, drop delivery charge
  if($_SESSION['UserKey']=="9999"){
    $delivery=0;
    
  }
    //include('test.php');
    $_SESSION['order_total'] = $gtotal;
    //$total_html_string = "<div id='price-block-line'><div id='left-title'>min value: </div><div id='right-price'><b>".$min_order_total."</b></div></div><br>";

    $total_html_string .= "<div id='price-block-line'><div id='left-title'>Subtotal: </div><div id='right-price'><b>$".number_format($gtotal, 2, '.', ',')."</b></div></div>";

	

	

    //sub-total has been calculated, now apply any discount coupons necessary.
    unset($coupon);
    //lookup coupon code used in cart
    $cpnquery = "Select max(couponCode) as couponCode, recordKey from cart where sessionID = '" . session_id()  .  "' AND couponCode is not null"; // and itemNumber=''";
    //echo $cpnquery  ;
    $rt7=mysql_query($cpnquery);          // query executed
            while($nt7=mysql_fetch_array($rt7)){
        $coupon = $nt7[couponCode];
        $recordKey =  $nt7[recordKey];
     }
     mysql_close;
     if(!empty($coupon)){  //discount coupon found in cart, get values from coupon
         $cquery = "select * from coupon where code ='" . $coupon . "'";
         $crt=mysql_query($cquery);
           //echo  $cquery ;
         while($cnt=mysql_fetch_array($crt)){
           $coupontype=$cnt[couponType];
           //type 1 = regular discount amount
           //type 2 = discount percentage
           //type 3 = one set coupon price
           $discount =  $cnt[discountAmount];
           $minimum =   $cnt[minOrder];
           $discpct =  $cnt[discountPercent];
           $couponprice = $cnt[couponPrice];
         } //end while loop
         }
         if((!empty($discount))&&(($coupontype==1)||($coupontype==4))){
         //check if total meets minimum
          if($gtotal >= $minimum){

          //if($min_order_total >= $minimum){
          $totaltax = number_format($totaltax - ($tax * ($discount)), 4, '.', ',');  //adjust tax for discount
          echo '<tr>' . $tab . '<td colspan=2><div align="right">Coupon# '.$coupon . ' Discount: </div><td><div align="right"><b><font color="red">- $' . number_format($discount, 2, '.', ',') . '</font></b></div>';
          //$total_html_string .= "<br />Coupon #$coupon: <b><font color='red'>-$" .number_format($discount, 2, '.', ',')."</font></b>";
          $total_html_string .= "<br /><div id='price-block-line'><div id='left-title'>Coupon: </div><div id='right-price'><b>-$" .number_format($discount, 2, '.', ',')."</b></div></div>";
          }else{
          echo '<tr>' . $tab . '<td colspan=2><div align="center"><font color="red">Subtotal must be at least $' . $minimum . ' to use coupon #'.$coupon . '.</font><br /><a href="/order?a=rem&item=' .  $recordKey .'">Remove coupon</a></div>';
          }
         }
         if((!empty($discpct))&&($coupontype==2)){
         //check if total meets minimum
                     if(((!empty($minimum))&&($gtotal >= $minimum))||(empty($minimum))){
                     $discpct = ($discpct * .01);
                      $discount = $discpct * $gtotal ;
                      $totaltax = number_format($totaltax - ($tax * ($discount)), 4, '.', ',');  //adjust tax for discount
                      echo '<tr>' . $tab . '<td colspan=2><div align="right">Coupon# '.$coupon . ' ' .$discpct*100 .'% Discount: </div><td><div align="right"><b><font color="red">- $' . number_format($discount, 2, '.', ',') . '</font></b></div>';
                      $total_html_string .= "<br /><div id='price-block-line'><div id='left-title'>Coupon: </div><div id='right-price'><b>-$" .number_format($discount, 2, '.', ',')."</b></div></div>";
                     }else{
                      echo '<tr>' . $tab . '<td colspan=2><div align="center"><font color="red">Subtotal must be at least $' . $minimum . ' to use coupon #'.$coupon . '.</font><br /><a href="/order?a=rem&item=' .  $recordKey .'">Remove coupon</a></div>';
                     }
         }
         if($coupontype==3){     //one set price for a selected list of coupon items
                       echo '<tr>' . $tab . '<td colspan=2><div align="right">Coupon# '.$coupon . ' - Price: </div><td><div align="right"><b> $' . number_format($couponprice, 2, '.', ',') . '</b></div>';
                       $gtotal = $gtotal + $couponprice;
                       $totaltax = number_format($totaltax + ($tax * ($couponprice)), 4, '.', ',');  //adjust tax for coupon
                }
         
      if($wedeliver==1){      
    //$total_html_string .= "<br /><div id='price-block-line'><div id='left-title'>Delivery: </div><div id='right-price'><b>$" .number_format($delivery, 2, '.', ',')."</b></div></div>";
		if($_SESSION['delivery']>0.00){
			$total_html_string .= "<br /><div id='price-block-line'><div id='left-title'>Delivery: </div><div id='right-price'><b>$" .number_format($_SESSION['delivery'], 2, '.', ',')."</b></div></div>";
		}
      } else {
    $delivery = 0;  //zero out delivery cost if not offered
      }
     if ($totaltax<0){$totaltax =0;} //in case discount made tax negative, set to zero
      if($total_discount>0.00){
        $total_html_string .="<br /><div id='price-block-line'><div id='left-title'>Discount: </div><div id='right-price'><b>-$" . number_format(($total_discount) , 2, '.', ',')."</b></div></div>";
      }
        $total_html_string .="<br /><div id='price-block-line'><div id='left-title'>Tax: </div><div id='right-price'><b>$" . number_format(($totaltax+$deltax) , 2, '.', ',')."</b></div></div>";

		if($_SESSION['tipline']==1){

        	$total_html_string .="<br /><div id='price-block-line'><div id='left-title'>Tip: </div><div id='right-price'><b>$" . number_format(($tipamount) , 2, '.', ',')."</b></div></div>";

        }

        $total_html_string .="<br /><div id='price-block-line' style='border-top:solid 1px #000;line-height:1.9em;'><div id='left-title'>Total: </div><div id='right-price'><b>$" . number_format(($gtotal + $totaltax + $_SESSION['delivery'] + $tipamount + $deltax -$discount -$total_discount ), 2, '.', ',')."</b></div></div>";
        //$total_html_string .="</div>";
      
      echo '</table><!--</div> -->
      <br />';
      if(($tipline==1)&&($_SESSION['UserKey']!=="9999")){
        echo '<div id="tip-box"><form id="tipform" action="/order?a=addtip" method="post"><div align="right">If you wish to add a tip, you may enter it here: </div>
        $<input type="text" size="5" id="tipamount" name="tipamount" value="0.00"> <input id="save-button" type="submit" name="save" value="Add Tip"></form></div>';
        if(!empty($tip_wording)){echo'<div><center><b>'.$tip_wording.'</b></center></div><br>';}
      }
      if($_SESSION['brand']=="froogle"){
        echo '<div id="notes-box"><div align="center"><font color="red">If you do not see what you want to order, please call the store to make this order.</font></div>';  
      } else {
        echo '<div id="notes-box"><div align="center"><font color="red">Need to make a substitution or special request? Add it below!</font></div>';
      }
      echo '<form id="noteform" action="/order?a=savenote" method="post">
      <div style="width:100%;clear:both;"><div style="width:100%;overflow:auto;margin-top:.3em;"><textarea name="notes" cols=66 rows=4 id="addNotes">' . $note . '</textarea></div><div align="right">';
      echo '</div></form>';
        echo '</div>';
      
        echo '</div>';
         
    echo"<div id='price-block'>";
    echo  $total_html_string; //this will show the order total summary box    
    echo "</div>";    
  echo"<div id='check-out-wrapper'>";
     //paypal checkout button
    echo '<div>';
	
	
	$query = "Select * from storePrefs";
      $rt=mysql_query($query);          
      //echo mysql_error();  
      //die($query);                  
      if (mysql_num_rows($rt)!==0) {
        while($nt=mysql_fetch_array($rt)){
             $tip_reminder = $nt['tip_reminder']; //die($tip_reminder);
        }
      }
	  $orderType = $_SESSION['order_type'];
        $query = "Select tipamount from guestLogin Where  UserKey = '" . $_SESSION['UserKey'] . "'";
        $rt = mysql_query($query);          // query executed
        if (mysql_num_rows($rt)> 0) {
          while($rows = mysql_fetch_array($rt)){
            $tipamount = $rows['tipamount'];
          }
        }
      
          // echo "order type".$orderType;
          // echo "tip amount".$tipamount;
          // echo "tip remainder".$tip_reminder;
          if($orderType=="delivery" && $tipamount==0.00 && $tip_reminder==1 &&($_SESSION['UserKey']!=="9999")){
            $addTip = 1;
          }else{
            $addTip = 0;
          }
	  
    if(!empty($paypalid)){
        if($min_order_total >= $minimum_order){
            echo '<div id="checkout-button"><form action="/order?a=submit" method="post" id="checkTip">
            <input type="hidden" id="addTip" value="'.$addTip.'">
      <input id="check-out-submit" type="submit" name="order" value="Check Out"></div></form>';
        }else {
        	echo "<div><font color=red><center>Minimum order not met. Please add to your order to continue. </center></font><br></div>";
        }
    } else{ //paypal not used, use regular checkout button/form action
    //check order total first. If not enough, do not show button to finish
    //if($gtotal >= $minimum_order){

    if($min_order_total >= $minimum_order){	
        echo '<div id="checkout-button"><form action="/order?a=submit" method="post" id="checkTip">
        <input type="hidden" id="addTip" value="'.$addTip.'">
        <input id="check-out-submit" type="submit" name="order" value="Check Out" >
        </div></form>';
        } else {

        	echo "<div><font color=red><center>Minimum order not met. Please add to your order to continue. </center></font><br></div>";

        }
    }

    //end of paypal button
    echo '</div>';

      echo '<div id="check-clear-buttons"><a href="/order?a=empty">Clear Order & Start Over</a></div>
      ';
      if($mobile==1){
       echo '<div id="check-clear-buttons"><span class="menu_modal_open">Add to Your Order</span></div><div style="clear:both;"></div>';
      } else {
       echo '<div id="check-clear-buttons"><span class="menu_modal_open">Add to Your Order</span></div><div style="clear:both;"></div>';
      }
      echo '</div>';
   echo '</div><!-- end of check-out-wrapper div-->'; //end of check-out-wrapper div
  }
}  else { //upsell flag is set. prompt user to see if they are interested in an upsell item
}
  mysql_close;
?>
<div id="example" class="flora" style="display: none;">
<h1>Please choose the type of order.</h1>
        <table>
          <tr>
            <td><a href="javascript:void(0)" class="typeOfOrder" data-id="delivery"><img src="images/delivery.png"></a><td>
            <td><a href="javascript:void(0)" class="typeOfOrder" data-id="carryout"><img src="images/carryout.png"></a><td>
          </tr>
        </table>
</div>
<input type="hidden" name="orderType" id="orderType" value="<?php echo $_SESSION[order_type];?>">
<style type="text/css">
  .ui-dialog-titlebar-close{
      display: none;
  }
  .tip {
    background: #48a3db;
    color: #fff;
    border: 1px solid #777777;
    -webkit-border-radius: 4px;
    -moz-border-radius: 4px;
    border-radius: 4px;
    padding: 3px 6px;
}
</style>
<script type="text/javascript">
  $('#checkTip').submit(function(){
    
    var addTip = $('#addTip').val();
    if(addTip==1){
        $("#tip").dialog(
              {
                autoOpen: true,
                resizable: false,
                position: 'center',
                height: 'auto',
                width: 'auto'
         });
        $(".ui-dialog-titlebar").hide();
        $('#yes-tip').click(function(){
          
          $("#tip").dialog('close');
          $("#tipamount").focus();
          return false;
        });
        $('#no-tip').click(function(){
            $('#addTip').val(0);
            $('#checkTip').submit();
        });
        return false;  
      }else{
        return true;
      }
  });
  var orderType = $("#orderType").val();
  if(orderType!='unknown'){
    $(document).ready(function() {
        $("#menu_modal").popup();
    });    
  }
  $("#test").click(function(){
      var orderType1 = $("#orderType").val();
      if(orderType1 == 'unknown'){
         $('#menu_modal').popup('hide');
         $("#example").dialog(
          {
            autoOpen: true,
            resizable: false,
            position: 'center',
            height: 'auto',
            width: 'auto'
         });
      }else{
         
        // $("#menu_modal").popup("show");
        // $(".menu_modal_open").click();
      }
  });
  $(".typeOfOrder").on('click',function(){
        var type = $(this).data('id');
        $("#menu_modal").popup("show");
        $("#test").trigger("click");//
        $("#example").dialog('close');
                //$(".menu_modal_open" ).trigger("click");
              //var type="delivery";
          $("#orderType").val(type)
          $.ajax({
                  type: 'post',
                  url: 'backend.php',
                  data: {
                     type: type,
                  },
                  dataType: 'json'
        }).done(function(response) {
                
        });
  });
  $("#addNotes").on('keyup',function(){
        
        $.ajax({
                  type: 'post',
                  url: 'backend.php',
                  data: {
                    notes : $("#addNotes").val(),
                  },
                  dataType: 'json'
        }).done(function(response) {
          if(response.success==1){
          }
                
        });
  });

  $("input[name=order_type]:radio").change(function () {
        var order_type = $(this).val();
        $.ajax({
                  type: 'post',
                  url: 'backend.php',
                  data: {
                     type: order_type,
                  },
                  dataType: 'json'
        }).done(function(response) {
          if(response.success==1){
            window.location.replace('?a='+ "");
          }else{
            console.error();
          }

        });
  });
      
</script>

Youez - 2016 - github.com/yon3zu
LinuXploit