����JFIFXX�����    $.' ",#(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�8ds|\���Ҿp6�Ҵ���]��.����6�z<�v��@]�i%��$j��~�g��J>��no����pM[me�i$[����s�o�ᘨ�˸ nɜG-�ĨU�ycP�3.DB�li�;��hj���x7Z^�N�h������N3u{�:j�x�힞��#M&��jL P@_���� P��&��o8������9�����@Sz6�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*-iH��g�D�)� E�m�|�ؘbҗ�a��Ҿ����t4���o���G��*oCN�rP���Q��@z,|?W[0�����:�n,jWiE��W��$~/�hp\��?��{(�0���+�Y8rΟ�+����>S-S����VN;�}�s?.����� w�9��˟<���Mq4�Wv'��{)0�1mB��V����W[�����8�/<� �%���wT^�5���b��)iM� pg�N�&ݝ��VO~�q���u���9� ����!��J27����$O-���! �:�%H��� ـ����y�ΠM=t{!S�� oK8������t<����è:a������[�����ա�H���~��w��Qz`�po�^ ����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�_�uX6��3?nk��Wy�f;^*B� ��@�~a�`��Eu������+���6�L��.ü>��}y���}_�O�6�͐�:�YrG�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�!039C� �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 Xp3�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@:)ִ�:�]��hv�E�w���T�l��P���"Ju�}��وV J��G6��. J/�Qgl߭�e�����@�z�Zev2u�)]կ�����7x���s�M�-<ɯ�c��r�v�����@��$�ޮ}lk���a���'����>x��O\�ZFu>�����ck#��&:��`�$�ai�>2Δ����l���oF[h��lE�ܺ�Πk:)���`�� $[6�����9�����kOw�\|���8}������ބ:��񶐕��I�A1/�=�2[�,�!��.}gN#�u����b��� ~��݊��}34q����d�E��Lc��$��"�[q�U�硬g^��%B �z���r�pJ�ru%v\h1Y�ne`ǥ:g���pQM~�^�Xi� ��`S�:V29.�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&Ú����2g�}&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��f24;�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)*Pt����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���#yw��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���/$�WPw���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��BS�('$�ɻ� �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 : 194.163.35.170  /  Your IP : 216.73.216.125
Web Server : LiteSpeed
System : Linux sg-nme-web589.main-hosting.eu 5.14.0-503.16.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Dec 13 01:47:05 EST 2024 x86_64
User : u506035920 ( 506035920)
PHP Version : 8.2.27
Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /home/u506035920/domains/gcmcindia.com/public_html/admin-file/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /home/u506035920/domains/gcmcindia.com/public_html/admin-file//order.php
<?php
include('../mastercontroler/connection.php');
include('../mastercontroler/functions.php');
include('../mastercontroler/sidebarpermission.php');

$error = "";
$success = "";

// Fetch company state code from company_master table
$sql_company = "SELECT state_code FROM company_master WHERE id = '1'";
$result_company = $conn->query($sql_company);

if ($result_company->num_rows > 0) {
    $row_company = $result_company->fetch_assoc();
    $company_state_code = $row_company['state_code'];
} else {
    $company_state_code = ''; // Handle case when no company is found
}

// Function to generate the next order number
function generateOrderNo($conn)
{
    $prefix = "MM#O";
    $query = "SELECT order_no FROM order_list ORDER BY id DESC LIMIT 1";
    $result = $conn->query($query);
    if ($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        $lastOrderNo = $row['order_no'];
        $lastNumber = (int) substr($lastOrderNo, strlen($prefix));
        $newNumber = $lastNumber + 1;
    } else {
        $newNumber = 1;
    }
    return $prefix . str_pad($newNumber, 5, '0', STR_PAD_LEFT);
}

// On page load, call this function to set initial value
$order_no = generateOrderNo($conn);

if (isset($_POST['submit'])) {
    date_default_timezone_set("America/New_York");

    // Generate order number and assign values from the form
    $order_no = generateOrderNo($conn);
    $order_id = $_POST['order_id'] ?? ''; // Ensure order_id is not null
    $invoice_no = !empty($_POST['invoice_no']) ? $_POST['invoice_no'] : null; // Optional invoice number
    $order_date = $_POST['order_date'];
    $order_create_person = $_POST['order_create_person'];
    $special_instruction = $_POST['special_instruction'];
    $order_category = $_POST['order_category'];
    $portal_name = $_POST['portal_name'];
    $status = $_POST['status'];

    // Billing details
    $billing_name = $_POST['billing_name'];
    $billing_mobile = $_POST['billing_mobile'];
    $billing_country = $_POST['billing_country_name'];
    $billing_state = $_POST['billing_state_name'];
    $billing_state_code = $_POST['billing_state_code'];
    $billing_city = $_POST['billing_city_name'];
    $billing_address = $_POST['billing_address'];

    // Shipping details
    $shipping_name = $_POST['shipping_name'];
    $shipping_mobile = $_POST['shipping_mobile'];
    $shipping_country = $_POST['shipping_country_name'];
    $shipping_state = $_POST['shipping_state_name'];
    $shipping_state_code = $_POST['shipping_state_code'];
    $shipping_city = $_POST['shipping_city_name'];
    $shipping_address = $_POST['shipping_address'];

    // Handle new fields
    $gst_type = $_POST['gst_type'] ?? ''; // GST type
    $gst_no = $_POST['gst_no'] ?? ''; // GST number
    $total_invoice_amount = $_POST['total_invoice_amount'] ?? ''; // Total Invoice Amount
    $total_tax_amount = $_POST['total_tax_amount'] ?? ''; // Total Tax Amount
    $invoice_status = $_POST['invoice_status'];
    $portal_ids = $_POST['portal_id'];

    // Specify the directory where you want to save the files
    $target_dir = "data/";

    // Handling PDF Uploads
    $label_pdf_name = $_FILES['label_pdf']['name'];
    $label_pdf_tmp = $_FILES['label_pdf']['tmp_name'];
    $label_pdf_target = $target_dir . basename($label_pdf_name);

    // Invoice PDF (optional)
    $invoice_pdf_name = $_FILES['invoice_pdf']['name'] ?? null;
    $invoice_pdf_tmp = $_FILES['invoice_pdf']['tmp_name'] ?? null;
    $invoice_pdf_target = null;

    if (!empty($invoice_pdf_name)) {
        $invoice_pdf_target = $target_dir . basename($invoice_pdf_name);
        if (!move_uploaded_file($invoice_pdf_tmp, $invoice_pdf_target)) {
            $error = "Failed to upload invoice PDF file.";
            $invoice_pdf_target = null;
        }
    }

    if (move_uploaded_file($label_pdf_tmp, $label_pdf_target)) {
        // Check if the generated order number already exists
        $checkOrderNoQuery = "SELECT order_no FROM order_list WHERE order_no = '$order_no'";
        $result = $conn->query($checkOrderNoQuery);

        if ($result->num_rows > 0) {
            $error = "Order number already exists.";
        } else {
            // Insert into order_list table
            $stmt_create_order = $conn->prepare("INSERT INTO order_list 
(order_no, order_id, invoice_no, order_date, order_create_person, 
label_pdf, invoice_pdf, special_instruction, order_category, portal_name, status,
billing_name, billing_mobile, billing_country, billing_state, billing_state_code, 
billing_city, billing_address, shipping_name, shipping_mobile, 
shipping_country, shipping_state, shipping_state_code, 
shipping_city, shipping_address, gst_type, gst_no, 
total_invoice_amount, total_tax_amount, invoice_status, portal_id) 
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");

            // Bind parameters including new fields
            $stmt_create_order->bind_param(
                "sssssssssssssssssssssssssssssss",
                $order_no,
                $order_id,
                $invoice_no,
                $order_date,
                $order_create_person,
                $label_pdf_target,
                $invoice_pdf_target, // Nullable invoice PDF path
                $special_instruction,
                $order_category,
                $portal_name,
                $status,
                $billing_name,
                $billing_mobile,
                $billing_country,
                $billing_state,
                $billing_state_code,
                $billing_city,
                $billing_address,
                $shipping_name,
                $shipping_mobile,
                $shipping_country,
                $shipping_state,
                $shipping_state_code,
                $shipping_city,
                $shipping_address,
                $gst_type,
                $gst_no,
                $total_invoice_amount,
                $total_tax_amount,
                $invoice_status,
                $portal_ids
            );

 

            if ($stmt_create_order->execute()) {

                // Get the last inserted order_id from order_list table
                $last_order_id = $conn->insert_id;

                // Prepare to insert into order_item table
                $stmt_create_item = $conn->prepare("INSERT INTO order_item (order_no, order_id, order_main_id, item_sku_no, item_name, item_image, item_qty, item_finish, item_price, item_totalamount, cgst, cgst_amount, sgst, sgst_amount, igst, igst_amount, hsn,tax_amount) 
                VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");

                for ($i = 0; $i < count($_POST['item_SKU_no']); $i++) {
                    $item_SKU_no = $_POST['item_SKU_no'][$i];
                    $item_name = $_POST['item_name'][$i];
                    $item_image = $_POST['item_image'][$i];
                    $item_qty = $_POST['item_qty'][$i];
                    $item_finish = $_POST['item_finish'][$i];
                    $item_price = $_POST['item_price'][$i];
                    $item_totalamount = $_POST['item_totalamount'][$i];
                    $cgst = $_POST['cgst'][$i];
                    $cgst_amount = $_POST['cgst_amount'][$i];
                    $sgst = $_POST['sgst'][$i];
                    $sgst_amount = $_POST['sgst_amount'][$i];
                    $igst = $_POST['igst'][$i];
                    $igst_amount = $_POST['igst_amount'][$i];
                    $hsn = $_POST['hsn'][$i];
                    $tax_amount = $_POST['tax_amount'][$i];

                    // Bind parameters for order_item with the last order id
                    $stmt_create_item->bind_param("ssssssssssssssssss", $order_no, $order_id, $last_order_id, $item_SKU_no, $item_name, $item_image, $item_qty, $item_finish, $item_price, $item_totalamount, $cgst, $cgst_amount, $sgst, $sgst_amount, $igst, $igst_amount, $hsn, $tax_amount);

                    if (!$stmt_create_item->execute()) {
                        echo "Error: " . $stmt_create_item->error;
                    }
                }
                // Redirect to order_list.php with a success message
                header("Location: order_list.php");
                exit(); // Always call exit after header redirection
            } else {
                echo "Error: " . $stmt_create_order->error;
            }
        }
    } else {
        // If the file upload fails
        $error = "Failed to upload PDF files.";
    }
}
?>




<!DOCTYPE html>
<html lang="en">

<head>
    <?php include("../mastercontroler/link.php"); ?>
    <!-- Add jQuery CDN -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>


</head>


<body>
    <!--Preloader-->
    <div class="preloader-it">
        <div class="la-anim-1"></div>
    </div>
    <!--/Preloader-->
    <div class="wrapper theme-4-active pimary-color-gold">
        <!-- Top Menu Items -->
        <?php include("../mastercontroler/header.php"); ?>
        <!-- /Top Menu Items -->
        <!-- Left Sidebar Menu -->
        <?php include("../mastercontroler/sidebar.php"); ?>
        <!-- Right Setting Menu -->
        <!-- /Right Setting Menu -->
        <?php include("../mastercontroler/thems.php"); ?>
        <!-- Right Sidebar Backdrop -->
        <div class="right-sidebar-backdrop"></div>
        <!-- Main Content -->
        <div class="page-wrapper">
            <div class="container-fluid">
                <!-- Title -->
                <div class="row heading-bg">
                    <div class="col-lg-3 col-md-4 col-sm-4 col-xs-12">
                        <h4 class="txt-dark"> Order Entry </h4>
                    </div>
                    <!-- Breadcrumb -->
                    <div class="col-lg-9 col-sm-8 col-md-8 col-xs-12">
                        <ol class="breadcrumb">
                            <li><a href="#">Dashboard</a></li>
                            <li><a href="#"><span>Add Order Material</span></a></li>
                        </ol>
                    </div>

                </div>

                <div class="row">
                    <div class="col-sm-12">
                        <div class="panel panel-default card-view">
                            <div class="panel-wrapper collapse in">
                                <div class="panel-body">
                                    <div class="col-md-12">
                                        <div class="form-wrap">
                                            <form role="form" method="post" enctype="multipart/form-data">
                                                <div class="row">

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="order_create_person">Sales
                                                            Person</label>
                                                        <select class="form-control select2" name="order_create_person"
                                                            id="order_create_person" required>
                                                            <option value="">Select Sales Person</option>
                                                            <!-- Options will be dynamically loaded here -->
                                                        </select>
                                                    </div>

                                                    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
                                                    <script>
                                                        $(document).ready(function () {
                                                            // Fetch sales persons on page load
                                                            $.ajax({
                                                                url: 'get_sales_persons.php', // PHP script to fetch sales persons
                                                                method: 'GET',
                                                                dataType: 'json',
                                                                success: function (response) {
                                                                    let salesPersonSelect = $('#order_create_person');
                                                                    salesPersonSelect.empty(); // Clear the current options
                                                                    salesPersonSelect.append('<option value="">Select Sales Person</option>'); // Default option

                                                                    // Loop through the response and append each sales person as an option
                                                                    $.each(response, function (index, salesPerson) {
                                                                        salesPersonSelect.append('<option value="' + salesPerson.full_name + '">' + salesPerson.full_name + '</option>');
                                                                    });
                                                                },
                                                                error: function (xhr, status, error) {
                                                                    console.log('Error fetching sales persons: ', error);
                                                                }
                                                            });
                                                        });
                                                    </script>

                                                    <!-- Order Category Select -->
                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label for="main_category">Order Category:<span
                                                                class="text-danger">*</span></label>
                                                        <select class="form-control" name="order_category"
                                                            id="order_category" required>
                                                            <option value="">Select</option>
                                                            <option value="Direct Buyer">Direct Buyer Order</option>
                                                            <option value="Portal Order">Portal Order</option>
                                                        </select>
                                                    </div>

                                                    <!-- PI No. (Visible for Direct Buyer Order) -->
                                                    <!-- PI No. Dropdown Field -->
                                                    <div class="col-lg-3 col-mb-12 form-group" id="pi_no_field"
                                                        style="display: none;">
                                                        <label for="pi_no">PI No.:<span
                                                                class="text-danger">*</span></label>
                                                        <select class="form-control" name="pi_no" id="pi_no">
                                                            <option value="">Select PI No.</option>
                                                            <!-- Options will be dynamically loaded here -->
                                                        </select>
                                                    </div>

                                                    <!-- Include jQuery -->
                                                    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

                                                    <script>
                                                        $(document).ready(function () {
                                                            // Fetch PI numbers on page load
                                                            $.ajax({
                                                                url: 'get_pi_numbers.php', // PHP script to fetch PI numbers
                                                                method: 'GET',
                                                                dataType: 'json',
                                                                success: function (response) {
                                                                    let piSelect = $('#pi_no');
                                                                    piSelect.empty(); // Clear the current options
                                                                    piSelect.append('<option value="">Select PI No.</option>'); // Default option

                                                                    // Loop through the PI numbers and append options
                                                                    $.each(response, function (index, pi) {
                                                                        // Append option with the PI number
                                                                        piSelect.append('<option value="' + pi.pi_no + '">' + pi.pi_no + '</option>');
                                                                    });
                                                                },
                                                                error: function (xhr, status, error) {
                                                                    console.log('Error fetching PI numbers: ', error);
                                                                }
                                                            });
                                                        });
                                                    </script>


                                                    <!-- Portal Order ID (Visible for Portal Order) -->
                                                    <div class="col-lg-3 col-mb-12 form-group"
                                                        id="portal_order_id_field" style="display:none;">
                                                        <label class="form-label" for="order_id">Portal Order ID</label>
                                                        <input type="text" name="order_id" id="order_id"
                                                            class="form-control" placeholder="Order ID" />
                                                    </div>

                                                    <!-- Portal Name (Visible for Portal Order) -->
                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label for="portal_name">Portal:<span
                                                                class="text-danger">*</span></label>
                                                        <select class="form-control" name="portal_name" id="portal_name"
                                                            required>
                                                            <option value="">Select Portal</option>
                                                        </select>
                                                        <!-- Hidden input to store portal ID -->
                                                        <input type="hidden" name="portal_id" id="portal_id">
                                                    </div>


                                                    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
                                                    <script>
                                                        $(document).ready(function () {
                                                            // Fetch portal names on page load
                                                            $.ajax({
                                                                url: 'get_portals.php', // PHP script to fetch portal names and abbreviations
                                                                method: 'GET',
                                                                dataType: 'json',

                                                                success: function (response) {
                                                                    let portalSelect = $('#portal_name');
                                                                    portalSelect.empty(); // Clear the current options
                                                                    portalSelect.append('<option value="">Select Portal</option>'); // Default option

                                                                    // Loop through the portals and append options
                                                                    $.each(response, function (index, portal) {
                                                                        // Append option with both name and abbreviation in the display text
                                                                        portalSelect.append('<option value="' + portal.portal_abbrewaition_name + '" data-id="' + portal.portal_id + '">' + portal.portal_name + ' (' + portal.portal_abbrewaition_name + ')</option>');
                                                                    });

                                                                    // When an option is selected, update the hidden input with portal ID
                                                                    portalSelect.on('change', function () {
                                                                        let selectedOption = $(this).find('option:selected');
                                                                        let portalID = selectedOption.data('id'); // Get portal ID from data-id attribute
                                                                        $('#portal_id').val(portalID); // Set hidden input value
                                                                    });
                                                                },
                                                                error: function (xhr, status, error) {
                                                                    console.log('Error fetching portal names: ', error);
                                                                }
                                                            });
                                                        });


                                                    </script>

                                                </div>



                                                <div class="row">
                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="Weight"> Order
                                                            create Date</label>
                                                        <input type="date" name="order_date" id="order_date"
                                                            class="form-control" placeholder="Order Date" required />
                                                    </div>


                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="order_no">MMI Order Number
                                                            <span class="text-danger">*</span></label>
                                                        <input type="text" id="order_no" name="order_no"
                                                            class="form-control" placeholder="Order Number"
                                                            value="<?php echo $order_no; ?>" readonly required>
                                                        <span id="order_no" style="color: red;"></span>
                                                    </div>




                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="Weight">Order Date</label>
                                                        <input type="date" name="order_date" id="order_date"
                                                            class="form-control" placeholder="Order Date" required />
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="label_pdf">Label PDF</label>
                                                        <input type="file" name="label_pdf" id="label_pdf"
                                                            class="form-control" accept="application/pdf" required />
                                                    </div>

                                                    <div class="col-lg-2 col-mb-12 form-group">
                                                        <label>Are you uploaded invoice?</label>
                                                        <div>
                                                            <input type="radio" id="yes" name="invoice_status"
                                                                value="yes" onclick="toggleInvoiceFields(true)"
                                                                required>
                                                            <label for="yes" style="color: green;">Yes</label>

                                                            <input type="radio" id="no" name="invoice_status" value="no"
                                                                onclick="toggleInvoiceFields(false)">
                                                            <label for="no" style="color: red;">No</label>
                                                        </div>
                                                    </div>

                                                    <!-- Invoice Number Field -->
                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="invoice_no">Invoice No.</label>
                                                        <input type="text" name="invoice_no" id="invoice_no"
                                                            class="form-control" placeholder="Invoice No." />
                                                    </div>

                                                    <!-- Customer Invoice PDF Upload -->
                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="invoice_pdf">Customer Invoice
                                                            PDF</label>
                                                        <input type="file" name="invoice_pdf" id="invoice_pdf"
                                                            class="form-control" accept="application/pdf" />
                                                    </div>


                                                    



                                                    <!-- Add a hidden field to store the company state code -->
                                                    <input type="hidden" id="company_state_code"
                                                        value="<?php echo $company_state_code; ?>" />

                                                    <div class="col-md-12 col-sm-12 col-xs-12 form-group">
                                                        <hr>
                                                        <h5>Billed To</h5>
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="billing_name">Customer Name<span
                                                                class="text-danger">*</span></label>
                                                        <input type="text" id="billing_name" name="billing_name"
                                                            class="form-control" placeholder="Name" required />
                                                        <span id="billing_name_error" class="text-danger"></span>
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="billing_mobile">Billing Mobile No
                                                            <span class="text-danger"></span></label>
                                                        <input type="number" id="billing_mobile" name="billing_mobile"
                                                            class="form-control" placeholder="Mobile No"
                                                            oninput="validateMobile('billing_mobile', 'mobile_error')"
                                                            required />
                                                        <span id="mobile_error" class="text-danger"></span>
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label for="billing_country">Select a Country:<span
                                                                class="text-danger">*</span></label>
                                                        <select name="billing_country_name" id="billing_country"
                                                            class="form-control">
                                                            <option value="">Select Country</option>
                                                            <?php
                                                            $sql_country = "SELECT * FROM countries ORDER BY name";
                                                            $result_country = $conn->query($sql_country);
                                                            if ($result_country->num_rows > 0) {
                                                                while ($row_country = $result_country->fetch_assoc()) {
                                                                    echo '<option value="' . $row_country['name'] . '" data-id="' . $row_country['id'] . '">' . $row_country['name'] . '</option>';
                                                                }
                                                            } else {
                                                                echo '<option value="">Country not available</option>';
                                                            }
                                                            ?>
                                                        </select>
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label for="billing_state">Select a State: <span
                                                                class="text-danger">*</span></label>
                                                        <select name="billing_state_name" id="billing_state"
                                                            class="form-control">
                                                            <option value="">Select State</option>
                                                        </select>
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="billing_stateCode">State
                                                            Code<span class="text-danger">*</span></label>
                                                        <input type="text" id="billing_stateCode"
                                                            name="billing_state_code" class="form-control"
                                                            placeholder="State Code" readonly />
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label for="billing_city">Select a City: <span
                                                                class="text-danger">*</span></label>
                                                        <select name="billing_city_name" id="billing_city"
                                                            class="form-control">
                                                            <option value="">Select City</option>
                                                        </select>
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="billing_address">Address <span
                                                                class="text-danger"></span></label>
                                                        <textarea type="text" id="billing_address"
                                                            name="billing_address" class="form-control"
                                                            placeholder="Address"></textarea>
                                                    </div>

                                                    <div class="col-md-12 col-sm-12 col-xs-12 form-group">
                                                        <input type="checkbox" id="copy_info" />
                                                        <label for="copy_info">Same as Billing Information</label>
                                                    </div>
                                                    <!-- Shipped To Section -->
                                                    <script>
                                                        function validateMobile(inputId, errorId) {
                                                            const mobileInput = document.getElementById(inputId);
                                                            const mobileError = document.getElementById(errorId);

                                                            // Get the value of the input
                                                            const mobileValue = mobileInput.value;

                                                            // Check if the mobile number is not exactly 10 digits
                                                            if (mobileValue.length < 10) {
                                                                mobileError.textContent = 'Mobile number must be exactly 10 digits.';
                                                            } else if (mobileValue.length > 10) {
                                                                mobileError.textContent = 'Mobile number must be exactly 10 digits.';
                                                                // Optionally truncate the input to 10 digits
                                                                mobileInput.value = mobileValue.substring(0, 10);
                                                            } else {
                                                                mobileError.textContent = ''; // Clear the error message
                                                            }
                                                        }
                                                    </script>
                                                    <script>
                                                        $(document).ready(function () {
                                                            // Billed To - Country change
                                                            $('#billing_country').change(function () {
                                                                var countryId = $('option:selected', this).data('id');
                                                                if (countryId) {
                                                                    $.ajax({
                                                                        type: 'POST',
                                                                        url: 'fetchinglocation.php',
                                                                        data: {
                                                                            option: 'states',
                                                                            country_id: countryId
                                                                        },
                                                                        success: function (html) {
                                                                            $('#billing_state').html(html);
                                                                            $('#billing_city').html('<option value="">Select City</option>');
                                                                            $('#billing_stateCode').val('');
                                                                        }
                                                                    });
                                                                }
                                                            });

                                                            // Billed To - State change
                                                            $('#billing_state').change(function () {
                                                                var stateId = $('option:selected', this).data('id');
                                                                var stateCode = $('option:selected', this).data('code');
                                                                $('#billing_stateCode').val(stateCode);
                                                                if (stateId) {
                                                                    $.ajax({
                                                                        type: 'POST',
                                                                        url: 'fetchinglocation1.php',
                                                                        data: {
                                                                            option: 'cities',
                                                                            state_id: stateId
                                                                        },
                                                                        success: function (html) {
                                                                            $('#billing_city').html(html);
                                                                        }
                                                                    });
                                                                }
                                                            });

                                                            // Shipped To - Country change
                                                            $('#shipping_country').change(function () {
                                                                var countryId = $('option:selected', this).data('id');
                                                                if (countryId) {
                                                                    $.ajax({
                                                                        type: 'POST',
                                                                        url: 'fetchinglocation.php',
                                                                        data: {
                                                                            option: 'states',
                                                                            country_id: countryId
                                                                        },
                                                                        success: function (html) {
                                                                            $('#shipping_state').html(html);
                                                                            $('#shipping_city').html('<option value="">Select City</option>');
                                                                            $('#shipping_stateCode').val('');
                                                                        }
                                                                    });
                                                                }
                                                            });

                                                            // Shipped To - State change
                                                            $('#shipping_state').change(function () {
                                                                var stateId = $('option:selected', this).data('id');
                                                                var stateCode = $('option:selected', this).data('code');
                                                                $('#shipping_stateCode').val(stateCode);
                                                                if (stateId) {
                                                                    $.ajax({
                                                                        type: 'POST',
                                                                        url: 'fetchinglocation1.php',
                                                                        data: {
                                                                            option: 'cities',
                                                                            state_id: stateId
                                                                        },
                                                                        success: function (html) {
                                                                            $('#shipping_city').html(html);
                                                                        }
                                                                    });
                                                                }
                                                            });

                                                            // Copying billing info to shipping info
                                                            $('#copy_info').change(function () {
                                                                if ($(this).is(':checked')) {
                                                                    $('#shipping_name').val($('#billing_name').val());
                                                                    $('#shipping_mobile').val($('#billing_mobile').val());
                                                                    $('#shipping_country').val($('#billing_country').val()).change();
                                                                    $('#shipping_state').val($('#billing_state').val()).change();
                                                                    $('#shipping_address').val($('#billing_address').val());
                                                                } else {
                                                                    $('#shipping_name').val('');
                                                                    $('#shipping_mobile').val('');
                                                                    $('#shipping_country').val('');
                                                                    $('#shipping_state').val('');
                                                                    $('#shipping_city').val('');
                                                                    $('#shipping_address').val('');
                                                                }
                                                            });
                                                        });
                                                    </script>
                                                    <!-- Shipped To Section -->
                                                    <div class="col-md-12 col-sm-12 col-xs-12 form-group">
                                                        <hr>
                                                        <h5>Shipped To</h5>
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="shipping_name">Name<span
                                                                class="text-danger">*</span></label>
                                                        <input type="text" id="shipping_name" name="shipping_name"
                                                            class="form-control" placeholder="Name" required />
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="shipping_mobile">Shipping Mobile
                                                            No <span class="text-danger"></span></label>
                                                        <input type="number" id="shipping_mobile" name="shipping_mobile"
                                                            class="form-control" placeholder="Mobile No"
                                                            oninput="validateMobile('shipping_mobile', 'shipping_mobile_error')"
                                                            required />
                                                        <span id="shipping_mobile_error" class="text-danger"></span>
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label for="shipping_country">Select a Country:<span
                                                                class="text-danger">*</span></label>
                                                        <select name="shipping_country_name" id="shipping_country"
                                                            class="form-control">
                                                            <option value="">Select Country</option>
                                                            <?php
                                                            $sql_country = "SELECT * FROM countries ORDER BY name";
                                                            $result_country = $conn->query($sql_country);
                                                            if ($result_country->num_rows > 0) {
                                                                while ($row_country = $result_country->fetch_assoc()) {
                                                                    echo '<option value="' . $row_country['name'] . '" data-id="' . $row_country['id'] . '">' . $row_country['name'] . '</option>';
                                                                }
                                                            } else {
                                                                echo '<option value="">Country not available</option>';
                                                            }
                                                            ?>
                                                        </select>
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label for="shipping_state">Select a State: <span
                                                                class="text-danger">*</span></label>
                                                        <select name="shipping_state_name" id="shipping_state"
                                                            class="form-control">
                                                            <option value="">Select State</option>
                                                        </select>
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="shipping_stateCode">State
                                                            Code<span class="text-danger">*</span></label>
                                                        <input type="text" id="shipping_stateCode"
                                                            name="shipping_state_code" class="form-control"
                                                            placeholder="State Code" readonly />
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label for="shipping_city">Select a City: <span
                                                                class="text-danger">*</span></label>
                                                        <select name="shipping_city_name" id="shipping_city"
                                                            class="form-control">
                                                            <option value="">Select City</option>
                                                        </select>
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="shipping_address">Address <span
                                                                class="text-danger"></span></label>
                                                        <textarea type="text" id="shipping_address"
                                                            name="shipping_address" class="form-control"
                                                            placeholder="Address"></textarea>
                                                    </div>


                                                    <div class="col-md-12 col-sm-12 col-xs-12 form-group">
                                                        <hr>
                                                    </div>
                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="gst_checkbox">Do you want to
                                                            provide GST?</label>
                                                        <input type="checkbox" id="gst_checkbox" />
                                                    </div>

                                                    <!-- Sub GST Checkboxes (Hidden initially) -->
                                                    <div id="gst_options" class="col-lg-3 col-mb-12 form-group"
                                                        style="display: none;">
                                                        <label class="form-label">Select GST Type:</label>
                                                        <div class="form-check">
                                                            <input class="form-check-input" type="radio" name="gst_type"
                                                                id="portal_gst" value="Portal GST" />
                                                            <label class="form-check-label" for="portal_gst">Portal
                                                                GST</label>
                                                        </div>
                                                        <div class="form-check">
                                                            <input class="form-check-input" type="radio" name="gst_type"
                                                                id="business_gst" value="Business GST" />
                                                            <label class="form-check-label" for="business_gst">Business
                                                                GST</label>
                                                        </div>
                                                        <div class="form-check">
                                                            <input class="form-check-input" type="radio" name="gst_type"
                                                                id="direct_buyer_gst" value="Direct Buyer GST" />
                                                            <label class="form-check-label"
                                                                for="direct_buyer_gst">Direct Buyer GST</label>
                                                        </div>
                                                    </div>

                                                    <!-- GST Input Field (Hidden initially) -->
                                                    <div class="col-lg-3 col-mb-12 form-group" id="gst_field"
                                                        style="display: none;">
                                                        <label class="form-label" for="gst_no">GST No.</label>
                                                        <input type="text" name="gst_no" id="gst_no"
                                                            class="form-control" placeholder="GST No." />
                                                    </div>


                                                    <div class="col-lg-6 col-mb-12 form-group col-6 mb-4">
                                                        <label class="form-label" for="basic-default-message">Special
                                                            Instruction
                                                            <span class="text-danger"></span></label>
                                                        <textarea id="special_instruction" name="special_instruction"
                                                            class="form-control"
                                                            placeholder="special instruction"></textarea>
                                                    </div>


                                                    <div class="col-md-12 col-sm-12 col-xs-12 form-group">
                                                        <hr>
                                                    </div>
                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="total_invoice_amount">Total
                                                            Invoice Amount<span class="text-danger">*</span></label>
                                                        <input type="text" id="total_invoice_amount"
                                                            name="total_invoice_amount" class="form-control"
                                                            placeholder="Amount" readonly />
                                                    </div>

                                                    <div class="col-lg-3 col-mb-12 form-group">
                                                        <label class="form-label" for="total_tax_amount">Total Tax
                                                            Amount<span class="text-danger">*</span></label>
                                                        <input type="text" id="total_tax_amount" name="total_tax_amount"
                                                            class="form-control" placeholder="Amount" readonly />
                                                    </div>

                                                </div>
                                                <hr>
                                                <h5>DMD Information</h5>
                                                <hr>

                                                <div class="row">
                                                    <div id="contact-person-details_consign">
                                                        <div class="additional-fields">
                                                            <div class="row rowAdd">
                                                                <!-- Form fields -->
                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label for="country">Item SKU Number:<span
                                                                            class="text-danger">*</span></label>
                                                                    <select class="form-control item_SKU_no"
                                                                        name="item_SKU_no[]"
                                                                        onchange="fetchItemDetails(this)"
                                                                        id="item_SKU_no_select" required>
                                                                        <option>Select</option>
                                                                        <?php
                                                                        $sql_sku = "SELECT item_SKU_no FROM item_master ORDER BY id";
                                                                        $result_sku = $conn->query($sql_sku);
                                                                        if ($result_sku->num_rows > 0) {
                                                                            while ($row_sku = $result_sku->fetch_assoc()) {
                                                                                echo '<option value="' . $row_sku['item_SKU_no'] . '">' . $row_sku['item_SKU_no'] . '</option>';
                                                                            }
                                                                        } else {
                                                                            echo '<option value="">Not available</option>';
                                                                        }
                                                                        ?>
                                                                    </select>
                                                                </div>

                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="item_name">Item
                                                                        Name<span class="text-danger">*</span></label>
                                                                    <input type="text" name="item_name[]"
                                                                        class="form-control item_name"
                                                                        placeholder="item name" readonly />
                                                                </div>
                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="finish_name">Finish
                                                                        Name</label>
                                                                    <input type="text" name="item_finish[]"
                                                                        class="form-control finish_name"
                                                                        placeholder="finish_name" readonly />
                                                                </div>
                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="hsn">HSN
                                                                        CODE</label>
                                                                    <input type="text" name="hsn[]"
                                                                        class="form-control hsn_code"
                                                                        placeholder="HSN CODE" readonly />
                                                                </div>

                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="qty">Qty</label>
                                                                    <input type="text" class="form-control item_qty"
                                                                        name="item_qty[]" placeholder="Qty" required>
                                                                </div>
                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="unit_price">Base
                                                                        Amount DMD
                                                                    </label>
                                                                    <input type="text" class="form-control item_price"
                                                                        name="item_price[]" id="unit_price"
                                                                        placeholder="Unit Price (INR)" required>
                                                                </div>

                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="total_amount">CGST %
                                                                    </label>
                                                                    <input type="text" class="form-control cgst"
                                                                        name="cgst[]" placeholder="CGST %" required>
                                                                </div>
                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="total_amount">CGST
                                                                        Amount
                                                                    </label>
                                                                    <input type="text" class="form-control cgst_amount"
                                                                        name="cgst_amount[]" placeholder="CGST Amount"
                                                                        required>
                                                                </div>
                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="total_amount">SGST %
                                                                    </label>
                                                                    <input type="text" class="form-control sgst"
                                                                        name="sgst[]" placeholder="SGST %" required>
                                                                </div>
                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="total_amount">SGST
                                                                        Amount
                                                                    </label>
                                                                    <input type="text" class="form-control sgst_amount"
                                                                        name="sgst_amount[]" placeholder="SGST Amount"
                                                                        required>
                                                                </div>
                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="total_amount">IGST %
                                                                    </label>
                                                                    <input type="text" class="form-control igst"
                                                                        name="igst[]" placeholder="IGST %" required>
                                                                </div>
                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="total_amount">IGST
                                                                        Amount
                                                                    </label>
                                                                    <input type="text" class="form-control igst_amount"
                                                                        name="igst_amount[]" placeholder="IGST Amount"
                                                                        required>
                                                                </div>
                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="total_amount">Tax
                                                                        Amount
                                                                        (INR)</label>
                                                                    <input type="text" class="form-control tax_amount"
                                                                        name="tax_amount[]" placeholder="Amount (INR)"
                                                                        required readonly>
                                                                </div>
                                                                <div class="col-lg-2 col-mb-12 form-group">
                                                                    <label class="form-label" for="total_amount">Amount
                                                                        (INR)</label>
                                                                    <input type="text"
                                                                        class="form-control item_totalamount"
                                                                        name="item_totalamount[]"
                                                                        placeholder="Amount (INR)" required readonly>
                                                                </div>
                                                                <div class="col-lg-3 col-mb-12 form-group">
                                                                    <img class="photo1" src="" alt=""
                                                                        style="height:100px;width:100px; border: 2px solid;">
                                                                    <input type="hidden" name="item_image[]" />
                                                                </div>
                                                                <div class="col-lg-12 col-mb-12 form-group text-right">
                                                                    <button type="button"
                                                                        class="btn btn-danger removeFieldsBtn"
                                                                        style="display: none;">Remove</button>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </div>


                                                    <hr>
                                                    <div>
                                                        <button type="button" id="addFieldsBtn"
                                                            class="btn btn-success">Add Item</button>
                                                        <button type="submit" name="submit"
                                                            class="btn btn-primary me-sm-3 me-1">Submit</button>
                                                        <a href="./pi-table.php" class="btn btn-danger">Cancel</a>
                                                        <div class="col-lg-2 col-mb-12 form-group">
                                                            <select class="form-control" name="status" id="status">
                                                                <option value="" disabled selected>Select Status
                                                                </option>
                                                                <option value="pending"
                                                                    style="background-color: #ffcccc; color: #ff0000;">
                                                                    Pending</option>
                                                                <option value="done"
                                                                    style="background-color: #ccffcc; color: #00ff00;">
                                                                    Done</option>
                                                            </select>
                                                        </div>


                                                    </div>
                                                    <input type="hidden" id="delete_id" name="delete_id">
                                                </div>


                                            </form>
                                        </div>
                                    </div>
                                </div>
                                </form>
                            </div>




                            <script>
                                $(document).ready(function () {
                                    function fetchItemDetails(element, itemSKU) {
                                        $.ajax({
                                            url: 'getItemDetails.php', // Adjust the path as necessary
                                            type: 'POST',
                                            data: {
                                                item_SKU_no: itemSKU
                                            },
                                            dataType: 'json',
                                            success: function (data) {
                                                if (!data.error) {
                                                    element.find('.finish_name').val(data.finish_name);
                                                    element.find('.item_name').val(data.item_name);
                                                    element.find('.length').val(data.length);
                                                    element.find('.height').val(data.Height); // Ensure case-sensitivity
                                                    element.find('.width').val(data.Weidth); // Ensure case-sensitivity
                                                    element.find('.cbm').val(data.CBM);
                                                    element.find('.hsn_code').val(data.item_hsncode); // Updated field for HSN Code
                                                    element.find('.photo1').attr('src', 'data/' + data.photo1); // Adjust the path as necessary
                                                    element.find('.photo2').attr('src', 'data/' + data.photo2); // Adjust the path as necessary

                                                    // Set the hidden input fields with the image paths
                                                    element.find('input[name="item_image[]"]').val('data/' + data.photo1);
                                                    element.find('input[name="item_image2[]"]').val('data/' + data.photo2);

                                                    // Set tax values if they are available
                                                    element.find('.sgst').val(data.sgst || ''); // Use empty string if data is not present
                                                    element.find('.cgst').val(data.cgst || ''); // Use empty string if data is not present
                                                    element.find('.igst').val(data.igst || ''); // Use empty string if data is not present
                                                } else {
                                                    alert(data.error);
                                                }
                                            },
                                            error: function () {
                                                alert('Error retrieving item details');
                                            }
                                        });
                                    }

                                    $('#contact-person-details_consign').on('change', '.item_SKU_no', function () {
                                        var itemSKU = $(this).val();
                                        var parent = $(this).closest('.rowAdd');
                                        if (itemSKU !== 'Select') {
                                            fetchItemDetails(parent, itemSKU);
                                        }
                                    });

                                    function calculateTotal(parent) {
                                        var qty = parseFloat(parent.find('.item_qty').val());
                                        var price = parseFloat(parent.find('.item_price').val());
                                        if (!isNaN(qty) && !isNaN(price)) {
                                            var total = qty * price;
                                            parent.find('.item_totalamount').val(total.toFixed(2)); // Ensure 2 decimal places
                                        } else {
                                            parent.find('.item_totalamount').val('');
                                        }
                                    }


                                    $('#contact-person-details_consign').on('input', '.item_qty, .item_price', function () {
                                        var parent = $(this).closest('.rowAdd');
                                        calculateTotal(parent);
                                    });

                                    $('#addFieldsBtn').click(function () {
                                        var newFields = $('.rowAdd').first().clone();
                                        newFields.find('input').val('');
                                        newFields.find('select').val('Select');
                                        newFields.find('img').attr('src', '');
                                        newFields.find('input[name="item_image[]"]').val('');
                                        newFields.find('input[name="item_image2[]"]').val('');
                                        newFields.find('.removeFieldsBtn').show();
                                        $('#contact-person-details_consign .additional-fields').append(newFields);
                                    });

                                    $('#contact-person-details_consign').on('click', '.removeFieldsBtn', function () {
                                        $(this).closest('.rowAdd').remove();
                                    });
                                });
                            </script>
                            <script>
                                $(document).ready(function () {
                                    const companyStateCode = '<?php echo $company_state_code; ?>';

                                    function calculateGST() {
                                        const billingStateCode = $('#billing_stateCode').val();
                                        const shippingStateCode = $('#shipping_stateCode').val();

                                        let overallTaxAmount = 0;
                                        let overallTotalAmount = 0;

                                        $('.rowAdd').each(function () {
                                            const qty = parseFloat($(this).find('.item_qty').val()) || 0;
                                            const unitPrice = parseFloat($(this).find('.item_price').val()) || 0;
                                            const baseAmount = qty * unitPrice;

                                            let cgstAmount = 0;
                                            let sgstAmount = 0;
                                            let igstAmount = 0;

                                            if (billingStateCode === shippingStateCode && billingStateCode === companyStateCode) {
                                                const cgstRate = parseFloat($(this).find('.cgst').val()) || 0;
                                                const sgstRate = parseFloat($(this).find('.sgst').val()) || 0;

                                                if (cgstRate > 0) {
                                                    cgstAmount = (baseAmount * cgstRate) / 100;
                                                }
                                                if (sgstRate > 0) {
                                                    sgstAmount = (baseAmount * sgstRate) / 100;
                                                }

                                                $(this).find('.igst_amount').val('');
                                                $(this).find('.igst').hide();
                                                $(this).find('.cgst, .sgst').show();
                                            } else {
                                                const igstRate = parseFloat($(this).find('.igst').val()) || 0;

                                                if (igstRate > 0) {
                                                    igstAmount = (baseAmount * igstRate) / 100;
                                                }

                                                $(this).find('.cgst_amount').val('');
                                                $(this).find('.sgst_amount').val('');
                                                $(this).find('.cgst, .sgst').hide();
                                                $(this).find('.igst').show();
                                            }

                                            const taxAmount = cgstAmount + sgstAmount + igstAmount;
                                            const totalAmount = baseAmount + taxAmount;

                                            $(this).find('.cgst_amount').val(cgstAmount.toFixed(2));
                                            $(this).find('.sgst_amount').val(sgstAmount.toFixed(2));
                                            $(this).find('.igst_amount').val(igstAmount.toFixed(2));
                                            $(this).find('.tax_amount').val(taxAmount.toFixed(2));
                                            $(this).find('.item_totalamount').val(totalAmount.toFixed(2));

                                            // Add to overall totals
                                            overallTaxAmount += taxAmount;
                                            overallTotalAmount += totalAmount;
                                        });

                                        // Update overall totals in the main fields
                                        $('#total_invoice_amount').val(overallTotalAmount.toFixed(2));
                                        $('#total_tax_amount').val(overallTaxAmount.toFixed(2));
                                    }

                                    $(document).on('input', '.item_qty, .item_price, .cgst, .sgst, .igst', function () {
                                        calculateGST();
                                    });

                                    $('#billing_stateCode, #shipping_stateCode').on('change', function () {
                                        calculateGST();
                                    });
                                });
                            </script>

                            <script>
                                // Function to add new item row
                                function addNewItemRow() {
                                    var additionalFieldsContainer = document.querySelector('.additional-fields');

                                    // Clone the existing row
                                    var rowClone = document.querySelector('.rowAdd').cloneNode(true);

                                    // Clear the input fields in the cloned row
                                    rowClone.querySelectorAll('input').forEach(function (input) {
                                        input.value = '';
                                    });
                                    rowClone.querySelectorAll('select').forEach(function (select) {
                                        select.selectedIndex = 0;
                                    });

                                    // Show the remove button
                                    rowClone.querySelector('.removeFieldsBtn').style.display = 'block';

                                    // Attach remove button functionality
                                    rowClone.querySelector('.removeFieldsBtn').addEventListener('click', function () {
                                        rowClone.remove();
                                    });

                                    // Append the cloned row to the container
                                    additionalFieldsContainer.appendChild(rowClone);
                                }

                                // Add event listener for the Add Item button
                                document.getElementById('addFieldsBtn').addEventListener('click', addNewItemRow);

                                // Initial setup to ensure remove button only appears for rows added
                                document.addEventListener('DOMContentLoaded', function () {
                                    document.querySelectorAll('.removeFieldsBtn').forEach(function (button) {
                                        button.style.display = 'none';
                                    });
                                });
                            </script>


                            <script>
                                function fetchItemDetails(selectElement) {
                                    var sku_no = selectElement.value;
                                    var priceInput = selectElement.closest('.form-group').nextElementSibling.querySelector('#unit_price');

                                    if (sku_no) {
                                        var xhr = new XMLHttpRequest();
                                        xhr.open('GET', 'fetch_item_pricepi.php?sku_no=' + encodeURIComponent(sku_no), true);
                                        xhr.onload = function () {
                                            if (xhr.status === 200) {
                                                var response = JSON.parse(xhr.responseText);
                                                priceInput.value = response.price || '';
                                            } else {
                                                console.error('Failed to fetch price');
                                            }
                                        };
                                        xhr.send();
                                    } else {
                                        priceInput.value = '';
                                    }
                                }
                            </script>

                            <!-- JavaScript for Dynamic Show/Hide -->
                            <script>
                                // GST Main Checkbox Logic
                                document.getElementById('gst_checkbox').addEventListener('change', function () {
                                    var gstOptions = document.getElementById('gst_options');
                                    var gstField = document.getElementById('gst_field');

                                    if (this.checked) {
                                        gstOptions.style.display = 'block'; // Show GST options
                                    } else {
                                        gstOptions.style.display = 'none'; // Hide GST options
                                        gstField.style.display = 'none'; // Hide GST input field
                                        document.querySelectorAll('input[name="gst_type"]').forEach(el => el.checked = false); // Uncheck radio buttons
                                    }
                                });

                                // GST Type Selection Logic
                                document.querySelectorAll('input[name="gst_type"]').forEach(function (radio) {
                                    radio.addEventListener('change', function () {
                                        var gstField = document.getElementById('gst_field');
                                        gstField.style.display = 'block'; // Show GST input field
                                    });
                                });
                            </script>

                            <script>
                                $(document).ready(function () {
                                    $('#gst_checkbox').change(function () {
                                        if ($(this).is(':checked')) {
                                            $('#gst_options').show(); // Show GST options if checkbox is checked
                                            $('#gst_field').show(); // Show GST number field
                                        } else {
                                            $('#gst_options').hide(); // Hide GST options if checkbox is unchecked
                                            $('#gst_field').hide(); // Hide GST number field
                                            // Clear GST-related inputs when unchecked
                                            $('input[name="gst_type"]').prop('checked', false);
                                            $('#gst_no').val('');
                                        }
                                    });
                                });
                            </script>


                            <!-- JavaScript to Toggle Fields Based on Order Category -->
                            <script>
                                document.getElementById('order_category').addEventListener('change', function () {
                                    var orderCategory = this.value;
                                    var piNoField = document.getElementById('pi_no_field');
                                    var portalOrderIdField = document.getElementById('portal_order_id_field');
                                    var portalNameField = document.getElementById('portal_name_field');

                                    if (orderCategory === 'Portal Order') {
                                        // Show Portal Order fields (Portal Order ID & Portal Name)
                                        portalOrderIdField.style.display = 'block';
                                        portalNameField.style.display = 'block';
                                        // Hide PI No. for Portal Order
                                        piNoField.style.display = 'none';
                                    } else if (orderCategory === 'Direct Buyer') {
                                        // Show PI No. for Direct Buyer Order
                                        piNoField.style.display = 'block';
                                        // Hide Portal Order fields
                                        portalOrderIdField.style.display = 'none';
                                        portalNameField.style.display = 'none';
                                    } else {
                                        // Default state if no category is selected
                                        piNoField.style.display = 'none';
                                        portalOrderIdField.style.display = 'none';
                                        portalNameField.style.display = 'none';
                                    }
                                });
                            </script>

                        </div>
                        <?php include("../mastercontroler/script.php"); ?>

</body>

</html>

Youez - 2016 - github.com/yon3zu
LinuXploit