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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /home/pateltimber.com/public_html/inventory/inventory/newchallan.php
<?php
if(isset($_REQUEST['action']) && (isset($_REQUEST['order_id']) && !empty($_REQUEST['order_id'])) && !isset($_SESSION['bow'])){

    $recordid = $_REQUEST['order_id'];
    $custid =  getvalue("customerid","tbl_challan_entry"," where id = '".$recordid."'");
    $isBow  =  getvalue("bow","tbl_customer"," where cust_id = '".$custid."'");
    if($isBow != 1){
        ?>
        <script>
            window.location.href = "index.php?page=<?php echo $page;?>";
        </script>
        <?php
        exit();
    }
} ?>


<script>
    custstatus = '';
</script>
<style>
    .finalamount_show{

    }

    .supervisor_number_error{
        color:red;
    }
    table span.select2{

        width:100%;
        min-width:20px !important;
    }
    .refresh_change div i{
        position: absolute;
        right: 0;
        top: 0;
        z-index: 100;
        cursor: pointer;
        font-size: 36px;
        color:green;
        display:none;
    }

    .makeit_readonly{
        background-color:lightgrey !important;
    }

    .dontshow{
        display:none !important;
    }

    .refrence_div{
        margin-top:10px;
        margin-bottom:10px;
    }

    #addreferencebutton,#closerefrence{

        margin-top:25px;
    }

    /*  .waitbutton{
          display: inline-block;
          padding-left:2px !important;
          padding-right:2px !important;
          font-size: 20px !important;
          font-weight: 400;
          color: black;
          width: 120px;

           margin-top:14px !important;




          display: inline-block;
          margin-bottom: 0;
          font-size: 14px;
          font-weight: normal;
          line-height: 1.42857143;
          text-align: left !important;
          white-space: nowrap;
          vertical-align: middle;
          -ms-touch-action: manipulation;
          touch-action: manipulation;
          -webkit-user-select: none;
          -moz-user-select: none;
          -ms-user-select: none;
          user-select: none;
          background-image: none;
          border: 1px solid transparent;

      } */

    .waitbutton{
        margin-top:16px !important;
    }


</style>

<?php
$curpage =  $_REQUEST['page'];
if(isset($_SESSION)){
    if($_SESSION['utype'] !='Admin'){
        $submodulepermission  =  selectfetch('submodule_id','tbl_userpermission'," where  utype_id ='".$_SESSION['utype']."'");
        $uspermission = " ";
        if(!empty($submodulepermission->submodule_id)){
            $uspermission = $submodulepermission->submodule_id;
            $haspages  = totalrows("tbl_submodule", "where submodule_id IN ( ".$uspermission." )   AND 	subpage_address = '".$curpage."'");
            if(empty($haspages)){
                ?>
                <script>
                    window.location = 'index.php';
                </script>
                <?php
            }
        }else{
            ?>
            <script>
                window.location = 'index.php';
            </script>
            <?php
        }
    }
}else{
    ?>
    <script>
        window.location = 'index.php';
    </script>
    <?php
}

































$self = "index.php?page=".$curpage;


$action = "Add";
if (isset($_REQUEST['action'])) {
    $action = $_REQUEST['action'];
}

$cust_name='';
$cust_cont='';
$cust_add='';
//$cust_id='';
$customer='';
$goods_type = '';

$stat = '';
$Title = 'Add';
$cust_id = $_REQUEST['cust_id'];
if(isset($_REQUEST['action']) && ($_REQUEST['action'] == 'edit')){
    $Title = 'Edit';
}


if(isset($_REQUEST['action']) && ($_REQUEST['action'] == 'view')){
    $disable="disabled";


    $Title = 'View';
}

if(isset($_REQUEST['action']))
{
    $action = $_REQUEST['action'];
}
if(isset($_REQUEST['add_customer']) && ($_REQUEST['add_customer']=='Add New'))
{
    header("location:index.php?page=customer_form");
}
if(isset($_REQUEST['button']) && $_REQUEST['button']=='Add')
{


    if(isset($_SESSION['submitform'])){

        unset($_SESSION['submitform']);
        ?>

        <script>
            window.location="index.php?page=newchallan";
        </script>

        <?php
        exit();
    } else{


        $_SESSION['submitform'] = true;


        $customerid = $_POST['customer'];

        $bowtype =   getvalue('bow','tbl_customer'," where cust_id  ='".$customerid."'");


        $totalorders = getvalue("MAX(challan_number)"," tbl_challan_entry te ","   join  tbl_customer tc ON tc.cust_id  = te.customerid where tc.bow = '".$bowtype."' AND  challan_number like '%".$fystart.$fyend."' AND cancel IS NULL ");

     //   $totalorders = getvalue("MAX(challan_number)"," tbl_challan_entry","where cancel IS NULL ");

        /*  new code start  */


        $oldfinancialYear  = substr($totalorders, -4);
        
        if($oldfinancialYear == $fystart.$fyend){
            $totalorders =  substr($totalorders, 0, -4);
        }else{
            $totalorders = 0;
        }
        


        $totalorders_number = ($totalorders + 1);
        $pdf_name = "";
        if(strlen($totalorders_number) == 1){

            $totalorders_number = "0".$totalorders_number;

        }



        if($bowtype == 2){
            $pdf_name  = $totalorders_number."PT2(".$fystart."-".$fyend.")";
        }else{
            $pdf_name  = $totalorders_number."(".$fystart."-".$fyend.")";
        }

        $totalorders =  $totalorders_number.$fyear;



        /*  new code ends  */


        $_POST['challan_number'] = $totalorders;





        if(isset($_POST['company_sun'])  && empty($_POST['company_sun'])){
            ?>
            <script>
                window.location.href = 'index.php?page=<?php echo $curpage; ?>';
            </script>
            <?php
            exit();
        }
        if(!isset($_POST['company_sun'])){

            ?>
            <script>
                window.location.href = 'index.php?page=<?php echo $curpage; ?>';
            </script>
            <?php
            exit();
        }




        if(!empty($_POST['order_date'])){
            $_POST['order_date'] =  date('Y-m-d',strtotime($_POST['order_date']));
        }else{
            $_POST['order_date'] = "";
        }




// insert order details ..
//$officeid = $_POST['office'];
        $customerid = $_POST['customer'];
        $orderdate = $_POST['order_date'];
        $totalamount = $_POST['totalamount'];
        $total_amount_words = $_POST['total_amount_words'];
        $taxamount = $_POST['taxamount'];
        $taxamtinwords = $_POST['taxamtinwords'];
        $taxable_value = $_POST['taxable_value'];
        $central_tax = $_POST['central_tax'];
        $state_tax = $_POST['state_tax'];






        //$pdf_name = '';
        $pdf_directory  = '';

        $pdf_directory  = "challan_directory";
        //$pdf_name = $_POST['pdf_name'];



        if(empty($_POST['labour'])){
            $_POST['labour'] = 0;
        }
        if(empty($_POST['freight'])){
            $_POST['freight'] = 0;
        }

        $pay_now = 0;
        if(isset($_POST['pay_now']) && !empty($_POST['pay_now'])){
            $pay_now = 1;
        }


        $order_entry_data = array(
            'customerid'=>$customerid,
            'order_date'=>$_POST['order_date'],
            'total_amount'=>$totalamount,
            'total_amount_words' => $total_amount_words,
            'total_tax'=>$taxamount,
            'total_tax_words'=>$taxamtinwords,
            'taxable_value'=>$taxable_value,
            'central_tax'=>$central_tax,
            'state_tax'=>$state_tax,
            'order_pdf'=>$pdf_name,
            'challan_number'=>$_POST['challan_number'],
            'vehicle_no'=>$_POST['vehicle_no'],
            'freight'=>$_POST['freight'],
            'labour'=>$_POST['labour'],
            'pay_now'=>$pay_now,
            'supervisor_number'=>trim($_POST['supervisor_number'])
        );

        insert('tbl_challan_entry',$order_entry_data);

        $order_id = mysql_insert_id();



        $transaction_data = array(
            'cust_id'=>$customerid,
            'th_date'=>$_POST['order_date'],
            'th_type'=>1,
            'th_debit'=>$totalamount,
            'th_credit'=>0,
            'challan_id'=>$order_id,
            'gr_id'=>0
        );

        insert('tbl_transaction_history',$transaction_data);





        if(!empty($pay_now)){



            $details = "";
            if(($_POST['th_payment_mode'] == 2) || $_POST['th_payment_mode'] == 5){
                $details  = $_POST['th_details'];
            }

            $pay_amount = 0;
            if(!empty($_POST['pay_amount'])){
                $pay_amount = $_POST['pay_amount'];
            }


            // insert
            $data=array(
                'cust_id' => $customerid,
                'th_date' =>$_POST['order_date'],
                'th_type' =>3,
                'th_debit'=>0,
                'th_credit'=>$pay_amount,
                'challan_id'=>$order_id,
                'gr_id'=>0,
                'th_payment_mode'=>$_POST['th_payment_mode'],
                'th_details'=>$details
            );

            insert("tbl_transaction_history",$data);
        }



















// taxdata insert

        if(isset($_POST['ot_hsn'])){

            $x=0;
            foreach($_POST['ot_hsn']  as $hsn){

                $challan_taxes_table = array(
                    'order_id'=>$order_id,
                    'ot_hsn' =>$hsn,
                    'ot_taxable_value'=>$_POST['ot_taxable_value'][$x],
                    'ot_central_rate'=>$_POST['ot_central_rate'][$x],
                    'ot_central_amount'=>$_POST['ot_central_amount'][$x],
                    'ot_state_rate'=>$_POST['ot_state_rate'][$x],
                    'ot_state_amount'=>$_POST['ot_state_amount'][$x],
                );


                insert('challan_taxes_table',$challan_taxes_table);

                $x++;
            }

        }




//



// sunmica entries ..
        if(isset($_POST['company_sun'])  && !empty($_POST['company_sun'])){
            $selectedcompnies =  $_POST['company_sun'];
            if(!empty($selectedcompnies)){
                $x=0;
                foreach($selectedcompnies as $company){


                    $exist = totalrows("product_rates","WHERE cust_id='".$customerid."' AND   product_id = '".$company."'");
                    if(empty($exist)){
                        // insert
                        $ratedata=array(
                            'cust_id' =>$customerid,
                            'product_id'=>$company,
                            'amount'=>$_POST['amount_sun'][$x]
                        );
                        insert("product_rates",$ratedata);
                    }else{
                        //update
                        $ratedata=array('amount'=>$_POST['amount_sun'][$x]);
                        update("product_rates",$ratedata,"where  cust_id='".$customerid."' AND product_id = '".$company."'");
                    }












                    $sunmicadata  = array(
                        'o_id'=> $order_id,
                        'cust_id'=>$customerid,
                        'goods_company'=>$company,
                        'goods_unit'=>$_POST['unit_sun'][$x],
                        'goods_type' =>0,
                        'goods_size'=>'',
                        'goods_thickness'=>'',
                        'goods_finish'=>0,
                        'goods_code'=>'',
                        'goods_quantity'=>$_POST['quant_sun'][$x],
                        'goods_rake'=>0,
                        'ammount'=>$_POST['amount_sun'][$x],
                        'taxid'=>$_POST['taxid_sun'][$x],
                        'tax_incl'=>$_POST['tax_incl_sun'][$x],
                        'tax_type'=>$_POST['tax_type_sun'][$x],
                        'tax_rate'=>$_POST['tax_rate_sun'][$x],
                        'tax_amount'=>$_POST['tax_amount_sun'][$x],
                        'final_amount'=>$_POST['final_amount_sun'][$x],
                        'order_date'=>$_POST['order_date']
                    );

                    insert('tbl_challan',$sunmicadata);

                    $x++;
                }
            }
        }












        $challan_sql =  "select id,customerid,challan_number,order_date,total_amount from tbl_challan_entry where customerid='".$customerid."' order by order_date";
        $challan_result = mysql_query($challan_sql);

        $challan_rows = array();





        $prev_bal_sql =  "select cust_id,th_date,th_debit from tbl_transaction_history where  		(th_type = '7' or th_type='6')  and  cust_id = '".$customerid."'  order by th_date";
        $prev_bal_result = mysql_query($prev_bal_sql);


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



            $challan_rows[] = array(
                'id'=>'',
                'challan_number'=>'**prev balance**',
                'cust_id'=>$row['cust_id'],
                'order_date'=>$row['th_date'],
                'total_amount'=>$row['th_debit']
            );

        }









        while ($row = mysql_fetch_array($challan_result)){
            $challan_rows[] = array(
                'id'=>$row['id'],
                'challan_number'=>$row['challan_number'],
                'cust_id'=>$row['customerid'],
                'order_date'=>$row['order_date'],
                'total_amount'=>$row['total_amount']
            );
        }









        $sql =  "select *,

      CASE 
      when nolimit  != '0' then  'unlimited'
      when setlimit != '0' then   setlimit       
      ELSE default_limit  
      END as user_limit
       
       
       from

    (

select cust_id,cust_status,cust_name,cust_contact,IFNULL(unlimited_access,0) AS nolimit,IFNULL(set_limit,0) AS setlimit, IFNULL(total_paid,0) AS total_paid_amount,default_limit  from (
      select         
      tc.cust_id,
      tc.cust_contact,
      tc.cust_name,
      tc.cust_status,
      tc.set_limit,   
      tc.unlimited_access,  
       (select  party_default_limit   From tbl_settings AS ts  where  ts.id = '1' ) as default_limit, 
         (select SUM(th_credit)  From tbl_transaction_history AS thd  where  thd.cust_id = tc.cust_id ) as total_paid 
        from tbl_customer tc  
        left join tbl_transaction_history oe  on oe.cust_id = tc.cust_id        
     ) mytbl

) mytbl2 WHERE  cust_id = '".$customerid."'   group by cust_id order by cust_id ";



        $result = mysql_query($sql);



        $remaining = 0;

// sms user
        $custname    = "";
        $custstatus  = "";
        $custcontact = "";



        $dueamount = 0;

        while ($row = mysql_fetch_array($result)){
            $totalpaid = 0;
            $totalchallan_amt = 0;
            $totalpaid = $row['total_paid_amount'];

            $totalchallan_amt = 0;

            $remaining  = $row['total_paid_amount'];
            $unblockamount  = 0;
            $daysoverfirst = 0;

            $userid  =0 ;
            for($x=0;$x< count($challan_rows); $x++){
                if(($challan_rows[$x]['cust_id'] == $row['cust_id'])){


                    $totalchallan_amt  += $challan_rows[$x]['total_amount'];

                    $challan_amount = $challan_rows[$x]['total_amount'];
                    $remaining     = $remaining - $challan_amount;
                    $totalexpenses += $challan_amount;


                    if($remaining < 0){
                        $current_date=date_create(date('Y-m-d'));
                        $challan_date=date_create($challan_rows[$x]['order_date']);
                        $diff=date_diff($current_date,$challan_date);
                        $daysover = $diff->days;
                        if($daysover  > $row['user_limit']){

                            if($row['user_limit'] != 'unlimited'){
                                $unblockamount =  $remaining;
                            }
                        }
                        if(empty($daysoverfirst)){
                            $daysoverfirst = $daysover;
                        }
                    }
                }
            }





            $dueamount = $totalpaid - $totalchallan_amt;

            if((float)$totalpaid >  (float)$totalchallan_amt){
                $dueamount =  -1 * $dueamount;
            }elseif((float)$totalpaid < (float)$totalchallan_amt){
                $dueamount =  -1 * $dueamount;
            }



            // sms user
            $custname    = $row['cust_name'];
            $custstatus  = $row['cust_status'];
            $custcontact = $row['cust_contact'];


            if($unblockamount <= 0){
                $unblockamount = abs($unblockamount);
            }

            if($remaining <= 0){
                $remaining = abs($remaining);
            }


            if(empty($unblockamount)){
                // unblock user and send sms


            }else{
                if($row['user_limit'] != 'unlimited'){

                    if($row['cust_status'] == "Enabled"){
                        $custdata  = array(
                            'cust_status'=>'Disabled'
                        );
                        update("tbl_customer",$custdata,"where cust_id  = '".$row['cust_id']."'");
                    }

                }


            }


        }








// sms send for new challan


        if(empty($pay_now)){


            $customerdata = selectfetch('cust_name,cust_contact,cust_address','tbl_customer'," where cust_id = '".$customerid."'");
            $custname = $customerdata->cust_name;
            $customer_mobile = $customerdata->cust_contact;

            // second party condition
            if($bowtype != 2 || true ){
                $smsdata = array(
                    '[[username]]'  =>$custname,
                    '[[rupees]]'    => $totalamount,
                    '[[orderdate]]' => $orderdate,
                    '[[dueamount]]' => number_format($dueamount,2)
                );
                send_sms("party_challan",$customerid,$custname,$customer_mobile,$smsdata);
                send_sms("admin_party_challan",0,'ADMIN1',$admin_mobile,$smsdata);
                send_sms("admin_party_challan",0,'ADMIN2',$admin2_mobile,$smsdata);

            }








        } else{

            $pay_amount = 0;
            if(!empty($_POST['pay_amount'])){
                $pay_amount = $_POST['pay_amount'];
            }


            $customerdata = selectfetch('cust_name,cust_contact,cust_address','tbl_customer'," where cust_id = '".$customerid."'");
            $custname = $customerdata->cust_name;
            $customer_mobile = $customerdata->cust_contact;

            // second party condition
            if($bowtype != 2 || true ){


                $smsdata = array(
                    '[[username]]'=>$custname,
                    '[[rupees]]' => $totalamount,
                    '[[orderdate]]' => $orderdate,
                    '[[receivedamount]]'=>number_format($pay_amount,2),
                    '[[dueamount]]' => number_format($dueamount,2)
                );
                send_sms("party_challan_amount_received",$customerid,$custname,$customer_mobile,$smsdata);
                send_sms("admin_party_challan_amount_received",0,'ADMIN1',$admin_mobile,$smsdata);
                send_sms("admin_party_challan_amount_received",0,'ADMIN2',$admin2_mobile,$smsdata);


            }




            $_REQUEST['cust_id'] = $customerid;
            include_once('pending_zero_condition.php');




        }







        $stat = 'Delivery Challan Added Successfully ';

        $_SESSION['alert_msg'] = array(
            'type'=>'1',
            'text'=>$stat
        );


        $_POST = array();
        $_REQUEST = array();




        unset($_SESSION['submitform']);
        echo '<script type="text/javascript">window.location="index.php?page=newchallan";</script>';
        exit();








    }
}




if(isset($_REQUEST['button']) && $_REQUEST['button']=='Edit')
{
    $TABLE= 'default-tab';
    $oid = $_REQUEST['order_id'];

    $customerid = $_POST['customer'];

    $bowtype =   getvalue('bow','tbl_customer'," where cust_id  ='".$customerid."'");



    if(!empty($_POST['order_date'])){
        $_POST['order_date'] =  date('Y-m-d',strtotime($_POST['order_date']));
    }else{
        $_POST['order_date'] = "";
    }


// insert order details ..
    $order_id = $_REQUEST['order_id'];
    $officeid =  getvalue("office_id","tbl_challan_entry","where id='".$order_id."'");
    $office_id=0;
// $officeid = $_POST['office'];
    $customerid = $_POST['customer'];
    $orderdate = date('Y-m-d');
    $totalamount = $_POST['totalamount'];
    $total_amount_words = $_POST['total_amount_words'];
    $taxamount = $_POST['taxamount'];
    $taxamtinwords = $_POST['taxamtinwords'];
    $taxable_value = $_POST['taxable_value'];
    $central_tax = $_POST['central_tax'];
    $state_tax = $_POST['state_tax'];





    $pdf_directory  = "challan_directory";
    $pdf_name = $_POST['pdf_name'];





    if(empty($_POST['labour'])){
        $_POST['labour'] = 0;
    }
    if(empty($_POST['freight'])){
        $_POST['freight'] = 0;
    }

    $pay_now = 0;
    if(isset($_POST['pay_now']) && !empty($_POST['pay_now'])){
        $pay_now = 1;
    }



    $order_entry_data = array(
        'customerid'=>$customerid,
        'order_date'=>$_POST['order_date'],
        'total_amount'=>$totalamount,
        'total_amount_words' => $total_amount_words,
        'total_tax'=>$taxamount,
        'total_tax_words'=>$taxamtinwords,
        'taxable_value'=>$taxable_value,
        'central_tax'=>$central_tax,
        'state_tax'=>$state_tax,
        'order_pdf'=>$pdf_name,
        'challan_number'=>$_POST['challan_number'],
        'vehicle_no'=>$_POST['vehicle_no'],
        'freight'=>$_POST['freight'],
        'labour'=>$_POST['labour'],
        'pay_now'=>$pay_now,
        'supervisor_number'=>trim($_POST['supervisor_number'])
    );

    update("tbl_challan_entry",$order_entry_data, "where id = '$order_id'");


    $th_id =  getvalue("th_id","tbl_transaction_history","WHERE   challan_id = '".$order_id."'   and th_type = '1' ");

    if(!empty($th_id)){
        //update
        $transaction_data = array(
            'cust_id'=>$customerid,
            'th_date'=>$_POST['order_date'],
            'th_type'=>1,
            'th_debit'=>$totalamount,
            'th_credit'=>0,
            'challan_id'=>$order_id,
            'gr_id'=>0
        );
        update("tbl_transaction_history",$transaction_data, "where th_id = '".$th_id."'");

    }else{
        // insert
        $transaction_data = array(
            'cust_id'=>$customerid,
            'th_date'=>$_POST['order_date'],
            'th_type'=>1,
            'th_debit'=>$totalamount,
            'th_credit'=>0,
            'challan_id'=>$order_id,
            'gr_id'=>0
        );

        insert('tbl_transaction_history',$transaction_data);


    }




    if(!empty($pay_now)){




        $th_id =  getvalue("th_id","tbl_transaction_history","WHERE  challan_id = '".$order_id."'   and th_type = '3' ");


        $details = "";
        if(($_POST['th_payment_mode'] == 2) || $_POST['th_payment_mode'] == 5){
            $details  = $_POST['th_details'];
        }

        $pay_amount = 0;
        if(!empty($_POST['pay_amount'])){
            $pay_amount = $_POST['pay_amount'];
        }




        if(!empty($th_id)){
            // update


            $data=array(
                'cust_id' => $customerid,
                'th_date' =>$_POST['order_date'],
                'th_type' =>3,
                'th_debit'=>0,
                'th_credit'=>$pay_amount,
                'challan_id'=>$order_id,
                'gr_id'=>0,
                'th_payment_mode'=>$_POST['th_payment_mode'],
                'th_details'=>$details
            );

            update("tbl_transaction_history",$data, "where th_id = '".$th_id."'");


        }else{
            //insert


            $data=array(
                'cust_id' => $customerid,
                'th_date' =>$_POST['order_date'],
                'th_type' =>3,
                'th_debit'=>0,
                'th_credit'=>$pay_amount,
                'challan_id'=>$order_id,
                'gr_id'=>0,
                'th_payment_mode'=>$_POST['th_payment_mode'],
                'th_details'=>$details
            );

            insert("tbl_transaction_history",$data);



        }

    }else{
        delete("tbl_transaction_history", "WHERE cust_id='".$customerid."' AND   challan_id = '".$order_id."'   and th_type = '3' ");
    }







    delete("challan_taxes_table", "where order_id = '".$order_id."'");



    delete("tbl_challan", "where o_id = '".$order_id."'");


// taxdata insert

    if(isset($_POST['ot_hsn'])){

        $x=0;
        foreach($_POST['ot_hsn']  as $hsn){

            $challan_taxes_table = array(
                'order_id'=>$order_id,
                'ot_hsn' =>$hsn,
                'ot_taxable_value'=>$_POST['ot_taxable_value'][$x],
                'ot_central_rate'=>$_POST['ot_central_rate'][$x],
                'ot_central_amount'=>$_POST['ot_central_amount'][$x],
                'ot_state_rate'=>$_POST['ot_state_rate'][$x],
                'ot_state_amount'=>$_POST['ot_state_amount'][$x],
            );
            insert('challan_taxes_table',$challan_taxes_table);
            $x++;
        }

    }



// sunmica entries ..
    if(isset($_POST['company_sun'])  && !empty($_POST['company_sun'])){
        $selectedcompnies =  $_POST['company_sun'];
        if(!empty($selectedcompnies)){
            $x=0;
            foreach($selectedcompnies as $company){


                $exist = totalrows("product_rates","WHERE cust_id='".$customerid."' AND   product_id = '".$company."'");
                if(empty($exist)){
                    // insert
                    $ratedata=array(
                        'cust_id' =>$customerid,
                        'product_id'=>$company,
                        'amount'=>$_POST['amount_sun'][$x]
                    );
                    insert("product_rates",$ratedata);
                }else{
                    //update
                    $ratedata=array('amount'=>$_POST['amount_sun'][$x]);
                    update("product_rates",$ratedata,"where  cust_id='".$customerid."' AND product_id = '".$company."'");
                }




                $sunmicadata  = array(
                    'o_id'=> $order_id,
                    'cust_id'=>$customerid,
                    'goods_company'=>$company,
                    'goods_unit'=>$_POST['unit_sun'][$x],
                    'goods_type' =>0,
                    'goods_size'=>'',
                    'goods_thickness'=>'',
                    'goods_finish'=>0,
                    'goods_code'=>'',
                    'goods_quantity'=>$_POST['quant_sun'][$x],
                    'goods_rake'=>0,
                    'ammount'=>$_POST['amount_sun'][$x],
                    'taxid'=>$_POST['taxid_sun'][$x],
                    'tax_incl'=>$_POST['tax_incl_sun'][$x],
                    'tax_type'=>$_POST['tax_type_sun'][$x],
                    'tax_rate'=>$_POST['tax_rate_sun'][$x],
                    'tax_amount'=>$_POST['tax_amount_sun'][$x],
                    'final_amount'=>$_POST['final_amount_sun'][$x],
                    'order_date'=>$_POST['order_date']
                );

                insert('tbl_challan',$sunmicadata);



                $x++;
            }
        }
    }


    $challan_sql =  "select id,customerid,challan_number,order_date,total_amount from tbl_challan_entry where customerid='".$customerid."' order by order_date";
    $challan_result = mysql_query($challan_sql);

    $challan_rows = array();





    $prev_bal_sql =  "select cust_id,th_date,th_debit from tbl_transaction_history where  		(th_type = '7' or th_type='6')  and  cust_id = '".$customerid."'  order by th_date";
    $prev_bal_result = mysql_query($prev_bal_sql);


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



        $challan_rows[] = array(
            'id'=>'',
            'challan_number'=>'**prev balance**',
            'cust_id'=>$row['cust_id'],
            'order_date'=>$row['th_date'],
            'total_amount'=>$row['th_debit']
        );

    }

    while ($row = mysql_fetch_array($challan_result)){
        $challan_rows[] = array(
            'id'=>$row['id'],
            'challan_number'=>$row['challan_number'],
            'cust_id'=>$row['customerid'],
            'order_date'=>$row['order_date'],
            'total_amount'=>$row['total_amount']
        );
    }


    $sql =  "select *,

      CASE 
      when nolimit  != '0' then  'unlimited'
      when setlimit != '0' then   setlimit       
      ELSE default_limit  
      END as user_limit
       
       
       from

    (

select cust_id,cust_status,cust_name,cust_contact,IFNULL(unlimited_access,0) AS nolimit,IFNULL(set_limit,0) AS setlimit, IFNULL(total_paid,0) AS total_paid_amount,default_limit  from (
      select         
      tc.cust_id,
      tc.cust_contact,
      tc.cust_name,
      tc.cust_status,
      tc.set_limit,   
      tc.unlimited_access,  
       (select  party_default_limit   From tbl_settings AS ts  where  ts.id = '1' ) as default_limit, 
         (select SUM(th_credit)  From tbl_transaction_history AS thd  where  thd.cust_id = tc.cust_id ) as total_paid 
        from tbl_customer tc  
        left join tbl_transaction_history oe  on oe.cust_id = tc.cust_id        
     ) mytbl

) mytbl2 WHERE  cust_id = '".$customerid."'   group by cust_id order by cust_id ";



    $result = mysql_query($sql);



    $remaining = 0;

// sms user
    $custname    = "";
    $custstatus  = "";
    $custcontact = "";



    $dueamount = 0;

    while ($row = mysql_fetch_array($result)){
        $totalpaid = 0;
        $totalchallan_amt = 0;
        $totalpaid = $row['total_paid_amount'];

        $totalchallan_amt = 0;

        $remaining  = $row['total_paid_amount'];
        $unblockamount  = 0;
        $daysoverfirst = 0;

        $userid  =0 ;
        for($x=0;$x< count($challan_rows); $x++){
            if(($challan_rows[$x]['cust_id'] == $row['cust_id'])){


                $totalchallan_amt  += $challan_rows[$x]['total_amount'];

                $challan_amount = $challan_rows[$x]['total_amount'];
                $remaining     = $remaining - $challan_amount;
                $totalexpenses += $challan_amount;


                if($remaining < 0){
                    $current_date=date_create(date('Y-m-d'));
                    $challan_date=date_create($challan_rows[$x]['order_date']);
                    $diff=date_diff($current_date,$challan_date);
                    $daysover = $diff->days;
                    if($daysover  > $row['user_limit']){

                        if($row['user_limit'] != 'unlimited'){
                            $unblockamount =  $remaining;
                        }
                    }
                    if(empty($daysoverfirst)){
                        $daysoverfirst = $daysover;
                    }
                }
            }
        }





        $dueamount = $totalpaid - $totalchallan_amt;

        if((float)$totalpaid >  (float)$totalchallan_amt){
            $dueamount =  -1 * $dueamount;
        }elseif((float)$totalpaid < (float)$totalchallan_amt){
            $dueamount =  -1 * $dueamount;
        }



        // echo 'paid: '.$totalpaid.' challan: '.$totalchallan_amt.' due: '.$dueamount;


        // sms user
        $custname    = $row['cust_name'];
        $custstatus  = $row['cust_status'];
        $custcontact = $row['cust_contact'];


        if($unblockamount <= 0){
            $unblockamount = abs($unblockamount);
        }

        if($remaining <= 0){
            $remaining = abs($remaining);
        }


        if(empty($unblockamount)){


        }else{
            if($row['user_limit'] != 'unlimited'){
                if($row['cust_status'] == "Enabled"){
                    $custdata  = array(
                        'cust_status'=>'Disabled'
                    );
                    update("tbl_customer",$custdata,"where cust_id  = '".$row['cust_id']."'");
                }

            }


        }


    }







// sms send for new challan


    if(empty($pay_now)){


        // second party condition
        if($bowtype != 2 || true ){
            $smsdata = array(
                '[[username]]' => $custname,
                '[[no]]'       => $_POST['pdf_name'],
                '[[rupees]]'   => $totalamount,
                '[[orderdate]]'=> $orderdate,
                '[[dueamount]]' => number_format($dueamount,2)
            );
            // send_sms("party_challan_edit",$customerid,$custname,$customer_mobile,$smsdata);
            send_sms("admin_challan_edit",0,'ADMIN1',$admin_mobile,$smsdata);
            send_sms("admin_challan_edit",0,'ADMIN2',$admin2_mobile,$smsdata);
        }



    }else{

        $pay_amount = 0;
        if(!empty($_POST['pay_amount'])){
            $pay_amount = $_POST['pay_amount'];
        }


        $customerdata = selectfetch('cust_name,cust_contact','tbl_customer'," where cust_id = '".$customerid."'");
        $custname = $customerdata->cust_name;
        $customer_mobile = $customerdata->cust_contact;

        // second party condition
        if($bowtype != 2 || true){
            $smsdata = array(
                '[[username]]'=>$custname,
                '[[no]]'       => $_POST['pdf_name'],
                '[[rupees]]' => $totalamount,
                '[[orderdate]]' => $orderdate,
                '[[receivedamount]]'=>number_format($pay_amount,2),
                '[[dueamount]]' => number_format($dueamount,2)
            );
            send_sms("admin_challan_edit_amount_received",0,'ADMIN1',$admin_mobile,$smsdata);
            send_sms("admin_challan_edit_amount_received",0,'ADMIN2',$admin2_mobile,$smsdata);
        }





        $_REQUEST['cust_id'] = $customerid;
        include_once('pending_zero_condition.php');


    }




    $stat = 'Updated successfully';


    $_SESSION['alert_msg'] = array(
        'type'=>'1',
        'text'=>$stat
    );


    $_POST = array();
    $_REQUEST = array();


    ?>


    <?php

    /*  save pdf */
    /*  echo '<script type="text/javascript">window.location="challan_generate_pdf.php?order_id='.$order_id.'&pdf_name='.$pdf_name.'&pdf_directory='.$pdf_directory.'";</script>';

      exit(); */

    echo '<script type="text/javascript">window.location="index.php?page=newchallan";</script>';
    exit();



}




if(isset($_REQUEST['cancel'])){
    /*  $order_id = $_REQUEST['order_id'];
      $order_entry_data= array(
          'cancel'=>1
      );
      update("tbl_challan_entry",$order_entry_data, "where id = '$order_id'");
      update("tbl_challan",$order_entry_data, "where o_id = '$order_id'");

      delete("challan_taxes_table", "where order_id = '".$order_id."'");


      // add stock ...







  // board data

      $board_qry = select("*","tbl_challan","where o_id = '".$order_id."' and goods_type='6'");
      while($board_row=mysql_fetch_array($board_qry));
      {
          $total_quantity = getvalue("total_quantitty","tbl_stock"," where 	goods_id='6' AND goods_company='".$board_row['goods_company']."' AND goods_size = '".$board_row['goods_size']."'    AND    goods_thickness  ='".$board_row['goods_thickness']."'");
          $new_quantity = $total_quantity + $board_row['goods_quantity'];
          $stock_data = array('total_quantitty'=>$new_quantity);
          update("tbl_stock",$stock_data," WHERE goods_id='6' AND goods_company='".$board_row['goods_company']."' AND goods_size = '".$board_row['goods_size']."' AND    goods_thickness  ='".$board_row['goods_thickness']."'");
      }

      $stat = "Order Calcelled ";

      $_SESSION['alert_msg'] = array(
          'type'=>'1',
          'text'=>$stat
      ); ?>
      <script>
          window.location.href = 'index.php?page=<?php echo $curpage; ?>';
      </script>
      <?php  exit();


   */
} ?>

<style>

    .modal-backdrop.in {
        opacity: 0 !important;
        z-index: 0;

    }
</style>





<?php


$reference_sunopt = "";
$reference_sunopt  .= '<option value="">Select</option>';


$query_company = select("*","tbl_reference"," ");
while($row_company = mysql_fetch_array($query_company))
{
    $reference_sunopt  .= '<option value="'.$row_company['ref_id'].'">'.$row_company['ref_name'].'</option>';
} ?>



<script>
    reference_sunopt = '<?php echo $reference_sunopt; ?>';

</script>



<?php     ?>




<section class="content">
    <div class="container-fluid">
        <div class="block-header">
            <h2>Delivery Challan Entry</h2>
        </div>




        <div class="">
            <div   id="addcard"  class="panel panel-primary <?php    if (!isset($_REQUEST['action']) && !isset($_REQUEST['estimate_id'])) { echo "hideme"; }    ?>" >
                <div class="panel-heading">
                    <h2 class="panel-title">
                        <?php echo $Title; ?>
                        <small></small>
                    </h2>
                </div>
                <div class="panel-body">
                    <div class="row clearfix">
                        <form method="post" action="" id="frm" name="frm">




                            <!-- Veeners data start-->

                            <?php
                            $company_venopt = "";
                            $company_venopt  .= '<option value="">Select Company</option>';


                            $query_company = select("*","tbl_company","where status='Enabled' and goods_id='16'");
                            while($row_company = mysql_fetch_array($query_company))
                            {
                                $company_venopt  .= '<option value="'.$row_company['company_id'].'">'.$row_company['company'].'</option>';
                            } ?>



                            <script>
                                company_venopt = '<?php echo $company_venopt; ?>';
                            </script>
                            <?php

                            $rake_no_venopt  = "";
                            $rake_no_venopt .= '<option value="">Select Rake</option>';
                            $query_rake = select("*","tbl_rake","where rake_status='Enabled'");
                            while($row_rake = mysql_fetch_array($query_rake))
                            {
                                $rake_no_venopt .= '<option value="'.$row_rake['r_id'].'">'.$row_rake['rake_number'].'</option>';
                            }

                            ?>

                            <script>
                                rake_no_venopt = '<?php  echo $rake_no_venopt; ?>';
                            </script>


                            <?php


                            $size_venopt = "";
                            $size_venopt  .= '<option value="">Select Size</option>';

                            $query_size = select("*","tbl_boardsize","where status='Enabled'");
                            while($row_size = mysql_fetch_array($query_size))
                            {
                                $size_venopt .='<option value="'.$row_size['board_size_id'].'">'.$row_size['board_size'].'</option>';
                            } ?>

                            <script>
                                size_venopt = '<?php echo $size_venopt; ?>';
                            </script>





                            <!-- Veeners data close-->











                            <!-- sunmica data-->

                            <?php
                            $company_sunopt = "";
                            $company_sunopt  .= '<option value="">Select Product</option>';


                            $query_company = select("*","tbl_product"," ");
                            while($row_company = mysql_fetch_array($query_company))
                            {


                                $filterproduct = stripslashes($row_company['product_name']);
                                $filterproduct = str_replace("'","&#39;",$filterproduct);
                                $filterproduct = str_replace('"',"&#34;",$filterproduct);


                                $company_sunopt  .= '<option value="'.$row_company['product_id'].'">'.$filterproduct.'</option>';

                            } ?>



                            <script>
                                company_sunopt = '<?php echo $company_sunopt; ?>';
                            </script>
                            <?php

                            $unit_sunopt = "";
                            $unit_sunopt .= '<option value="">Select unit</option>';
                            $unit_sunopt .= '<option value="1" >NO</option>';
                            $unit_sunopt .= '<option value="2" >RF</option>';
                            $unit_sunopt .= '<option value="3" >PKT</option>';
                            $unit_sunopt .= '<option value="4" >KG</option>';
                            $unit_sunopt .= '<option value="5" >SET</option>';
                            $unit_sunopt .= '<option value="6" >DZN</option>';
                            $unit_sunopt .= '<option value="7" >GRM</option>';


                            ?>

                            <script>
                                unit_sunopt = '<?php echo $unit_sunopt; ?>';
                            </script>








                            <?php

                            $rake_no_sunopt  = "";
                            $rake_no_sunopt .= '<option value="">Select Rake</option>';
                            $query_rake = select("*","tbl_rake","where rake_status='Enabled'");
                            while($row_rake = mysql_fetch_array($query_rake))
                            {
                                $rake_no_sunopt .= '<option value="'.$row_rake['r_id'].'">'.$row_rake['rake_number'].'</option>';
                            }

                            ?>

                            <script>
                                rake_no_sunopt = '<?php   echo $rake_no_sunopt; ?>';
                            </script>


                            <?php

                            $finish_sunopt  = "";
                            $finish_sunopt .= '<option value="">Select Finish</option>';
                            $query_finish = select("*","tbl_finish","where status='Enabled'");
                            while($row_finish = mysql_fetch_array($query_finish))
                            {
                                $finish_sunopt .=  '<option value="'.$row_finish['finish_id'].'">'.$row_finish['finish'].'</option>';
                            } ?>

                            <script>
                                finish_sunopt = '<?php echo $finish_sunopt; ?>';
                            </script>


                            <!-- sunmica data close-->





                            <!-- Board data-->

                            <?php

                            $companyopt = "";
                            $companyopt  .= '<option value="">Select Company</option>';

                            $query_company = select("*","tbl_company","where status='Enabled' and goods_id='6'");
                            while($row_company = mysql_fetch_array($query_company))
                            {
                                $companyopt.= '<option value="'.$row_company['company_id'].'">'.$row_company['company'].'</option>';
                            } ?>

                            <script>
                                companyopt = '<?php echo $companyopt; ?>';
                            </script>


                            <?php


                            $sizeopt = "";
                            $sizeopt  .= '<option value="">Select Size</option>';

                            $query_size = select("*","tbl_boardsize","where status='Enabled'");
                            while($row_size = mysql_fetch_array($query_size))
                            {
                                $sizeopt .='<option value="'.$row_size['board_size_id'].'">'.$row_size['board_size'].'</option>';
                            } ?>

                            <script>
                                sizeopt = '<?php echo $sizeopt; ?>';
                            </script>

                            <!-- Board data close-->










                            <?php if(isset($_REQUEST['action']) && (($_REQUEST['action'] == 'edit') || ($_REQUEST['action'] == 'view'))  ){





                                $orderid  = $_REQUEST['order_id'];




                                $orderdetials  = selectfetch("*","tbl_challan_entry as o"," WHERE id = '".$orderid."'");


                                $challan_number = $orderdetials->challan_number;
                                $pdf_name = $orderdetials->order_pdf;


                                $vehicle_no = $orderdetials->vehicle_no;
                                $supervisor_number = $orderdetials->supervisor_number;


                                $freight = $orderdetials->freight;
                                $labour = $orderdetials->labour;





                                $pay_now_checked = "";
                                if(!empty($orderdetials->pay_now)){
                                    $pay_now = 1;
                                    $pay_now_checked = " checked ";
                                }



                                /*echo '<pre>';
                                print_r($orderdetials);
                                echo '</pre>'; */


                                $totaltaxamount = $orderdetials->total_tax;
                                $orderdate  = $orderdetials->order_date;
                                if(!empty($orderdate) && ($orderdate != "0000-00-00")){
                                    $orderdate = date('d-m-Y',strtotime($orderdate));
                                }


                                $officeid = $orderdetials->office_id;
                                $customerid = $orderdetials->customerid;

                                $customerdetials = selectfetch("*","tbl_customer","where cust_id IS NOT NULL and cust_id = '".$customerid."'");
                                $cust_contact = '';
                                if(!empty($customerdetials->cust_contact)){
                                    $cust_contact = $customerdetials->cust_contact;
                                }

                                $cust_tin = '';
                                if(!empty($customerdetials->cust_tin)){
                                    $cust_tin = $customerdetials->cust_tin;
                                }



                                $cust_email = '';
                                if(!empty($customerdetials->cust_email)){
                                    $cust_email = $customerdetials->cust_email;
                                }


                                $cust_address = '';
                                if(!empty($customerdetials->cust_address)){
                                    $cust_address = $customerdetials->cust_address;
                                }
                                $total_amount = 0;
                                if(!empty($orderdetials->total_amount)){
                                    $total_amount = $orderdetials->total_amount;
                                }


                                $total_amount_words = '';
                                if(!empty($orderdetials->total_amount_words)){
                                    $total_amount_words = $orderdetials->total_amount_words;
                                }



                                $taxable_value = 0;
                                if(!empty($orderdetials->taxable_value)){
                                    $taxable_value = $orderdetials->taxable_value;
                                }


                                $central_tax = 0;
                                if(!empty($orderdetials->central_tax)){
                                    $central_tax = $orderdetials->central_tax;
                                }

                                $state_tax = 0;
                                if(!empty($orderdetials->state_tax)){
                                    $state_tax = $orderdetials->state_tax;
                                }





                                $total_tax_words = '';
                                if(!empty($orderdetials->total_tax_words)){
                                    $total_tax_words = $orderdetials->total_tax_words;
                                }


                                ?>



                                <input type="hidden" id="sunmicahsn" name="sunmicahsn" value="<?php echo $sunmicahsn; ?>">
                                <input type="hidden" id="veneerhsn" name="veneerhsn" value="<?php echo $veneerhsn; ?>">
                                <input type="hidden" id="boardhsn" name="boardhsn" value="<?php echo $boardhsn; ?>">
                                <input type="hidden" name="cust_id" id="cust_id" value="<?php echo $cust_id;?>"/>



                                <div class="col-md-12">


                                    <div class="row">


                                        <div class="col-md-3 col-sm-3 col-xs-12">
                                            <div class="form-group input-group">
                                                <div class="">
                                                    <label for="challan_number"> Vehicle number </label>
                                                    <input  <?php echo $disable; ?> type="text" id="vehicle_no" name="vehicle_no" class="form-control" placeholder="vehicle number"  value="<?php echo $vehicle_no; ?>" autofocus>
                                                </div>
                                            </div>
                                        </div>













                                        <div class="col-md-3 col-sm-3 col-xs-12">
                                            <div class="form-group input-group">
                                                <div class="">
                                                    <label for="order_date">Challan Date </label>
                                                    <input  <?php echo $disable; ?>  type="text" id="order_date" name="order_date" class="form-control mydate" value="<?php echo $orderdate; ?>" placeholder="Order Date :" autofocus>
                                                </div>
                                            </div>
                                        </div>






                                        <div class="col-md-3 col-sm-3 col-xs-12">
                                            <div class="form-group input-group">
                                                <div class=" ">
                                                    <label for="supervisor_number">Supervisor Number </label>
                                                    <input  <?php echo $disable; ?> type="number" id="supervisor_number" name="supervisor_number" class="form-control" placeholder="Supervisor Number"  value="<?php echo $supervisor_number; ?>" autofocus>
                                                </div>
                                                <label class="supervisor_number_error"></label>
                                            </div>
                                        </div>



                                        <div class="col-md-3 col-sm-3 col-xs-12">
                                            <div class="form-group input-group">
                                                <div class=" ">
                                                    <label for="order_date">Challan Number</label>
                                                    <input  <?php echo $disable; ?>   readonly  type="hidden" id="challan_number" name="challan_number" class="form-control " value="<?php echo $challan_number; ?>" placeholder="challan number :" autofocus>

                                                    <input  <?php echo $disable; ?>  readonly  type="text" id="challan_number" name="pdf_name" class="form-control " value="<?php echo $pdf_name; ?>" placeholder="estimate number :" autofocus>
                                                </div>
                                            </div>
                                        </div>





                                    </div>



                                </div>




                                <div class="col-md-12">
                                    <div class="form-group">
                                        <label>Customer Details :
                                            <?php   if(!isset($_REQUEST['action']) || $_REQUEST['action'] != 'view'){ ?>

                                                <span id="addcustomer" style="display:inline;cursor:pointer;">
                                                <div style="display: inline-block; padding-left: 20px;" class="demo-google-material-icon">
                                                    <i  title="Add New Customer" style="color: #483aea;"  class="material-icons">person_add</i>
                                                    <span class="icon-name"></span>
                                                </div>
                                            </span>


                                            <?php }   ?>




                                        </label>
                                    </div>
                                </div>



                                <div class="col-md-12">


                                    <div class="row">



                                        <?php if(isset($_SESSION['bow']) &&  $_SESSION['bow'] == 2  ){ ?>

                                        <div class="col-md-6 col-sm-6 col-xs-12">

                                            <div class="form-group input-group">
                                                <label for="customer">Customer Name :</label>
                                                <select  <?php echo $disable; ?>   name="customer" id="customer" onChange="getcustomer_detail(document.getElementById(id),this.value);" class="form-control customer   select2 "  data-live-search="true"  autofocus >
                                                    <option value=""> Select Party </option>
                                                    <?php $query_customer = select("*","tbl_customer","where  cust_id IS NOT NULL  order by cust_name ");
                                                    while($row_customer = mysql_fetch_array($query_customer))
                                                    {
                                                        ?>
                                                        <option value="<?php echo $row_customer['cust_id']; ?>" <?php echo selected($customerid,$row_customer['cust_id']); ?>><?php echo $row_customer['cust_name']; ?></option>
                                                    <?php } ?>
                                                </select>

                                            </div>
                                        </div>

                                        <?php }else{ ?>

                                            <div class="col-md-6 col-sm-6 col-xs-12">

                                                <div class="form-group input-group">
                                                    <label for="customer">Customer Name :</label>
                                                    <select  <?php echo $disable; ?>   name="customer" id="customer" onChange="getcustomer_detail(document.getElementById(id),this.value);" class="form-control customer   select2 "  data-live-search="true"  autofocus >
                                                        <option value=""> Select Party </option>
                                                        <?php $query_customer = select("*","tbl_customer","where  cust_id IS NOT NULL  and bow = '1'   order by cust_name ");
                                                        while($row_customer = mysql_fetch_array($query_customer))
                                                        {
                                                            ?>
                                                            <option value="<?php echo $row_customer['cust_id']; ?>" <?php echo selected($customerid,$row_customer['cust_id']); ?>><?php echo $row_customer['cust_name']; ?></option>
                                                        <?php } ?>
                                                    </select>

                                                </div>
                                            </div>


                                        <?php } ?>
                                        

                                        <div class="col-md-6 col-sm-6 col-xs-12">
                                            <div class="form-group input-group">
                                                <div class="">
                                                    <label for="cust_no">Customer Number :</label>
                                                    <input  <?php echo $disable; ?>  type="text" id="cust_no" name="cust_no" class="form-control disabled" placeholder="Contact No :" value="<?php echo $cust_contact; ?>" disabled autofocus>
                                                </div>
                                            </div>
                                        </div>



                                    </div>
                                </div>

                                <div class="col-md-12">


                                    <div class="row">

                                        <div class="col-md-6 col-sm-6 col-xs-12">
                                            <div class="form-group input-group">
                                                <div class="  ">
                                                    <label for="cust_tin">GST NO. :</label>
                                                    <input  <?php echo $disable; ?>  type="text" id="cust_tin" name="cust_tin" class="form-control disabled" placeholder="GST No. :" value="<?php echo $cust_tin; ?>" disabled autofocus>
                                                </div>
                                            </div>
                                        </div>



                                        <div class="col-md-6 col-sm-6 col-xs-12">
                                            <div class="form-group input-group">
                                                <div class=" ">
                                                    <label for="cust_email">Customer Email :</label>
                                                    <input  <?php echo $disable; ?>  type="text" id="cust_email" name="cust_email" class="form-control disabled" value="<?php echo $cust_email; ?>" placeholder="Party Email:"  disabled autofocus>
                                                </div>
                                            </div>
                                        </div>



                                    </div>



                                </div>






                                <div class="col-md-12 col-sm-12 col-xs-12">
                                    <div class="form-group input-group">
                                        <div class=" ">
                                            <label for="cust_addr">Customer Address :</label>
                                            <textarea  <?php echo $disable; ?>  id="cust_addr" name="cust_addr" class="form-control disabled"   placeholder="Party Address:"  disabled autofocus><?php echo $cust_address; ?></textarea>
                                        </div>
                                    </div>
                                </div>




                                <div class="col-md-12">
                                    <div class="form-group">
                                        <h3 id="challanblock_title" class="text-center">
                                            Delivery challan  Details
                                        </h3>
                                        <hr />
                                    </div>
                                </div>







                                <!-- sunmica starts-->

                                <!--  <div class="row">
                                      <div class="col-md-12">
                                          <label class="alert alert-warning sectionheaders" style="">Challan Details</label>
                                      </div>
                                  </div> -->



                                <div id="challanblock">






                                    <div class="col-md-12">



                                        <div class="row">
                                            <div class="col-md-12">

                                                <div class="table-responsive">

                                                    <div id="no-more-tables">

                                                        <table class="table table-bordered table-striped " id="sunmicatable" style="table-layout:fixed;">
                                                            <thead>
                                                            <th style="width:50px;">Particulars
                                                                <?php  /* if(!isset($_REQUEST['action']) || $_REQUEST['action'] != 'view'){ ?>

                                                                <span id="addproduct" style="display:inline;cursor:pointer;"> <div style="display: inline-block; padding-left: 20px;" class="demo-google-material-icon"> <i class="material-icons">add_circle</i> <span class="icon-name"></span> </div>  </span>
                                                            <?php }  */ ?>
                                                            </th>
                                                            <th style="width: 30px;"  >Quantity</th>
                                                            <th style="width: 26px;">Unit</th>
                                                            <th style="width: 30px;">Rate</th>
                                                            <th style="width: 30px;">Amount</th>
                                                            <?php if(isset($_REQUEST['action']) && ($_REQUEST['action'] != 'view')){ ?>
                                                                <th style="width:20px">Action</th>
                                                            <?php } ?>
                                                            </thead>
                                                            <tbody>


                                                            <?php


                                                            $sunmica_query  = select("*","tbl_challan"," where o_id = '".$orderid."'");
                                                            $x=1;
                                                            while($row_sunmica = mysql_fetch_array($sunmica_query)){  ?>

                                                                <tr>
                                                                    <td data-title="Particulars">
                                                                        <div class="form-group ">
                                                                            <input type="hidden" name="sunmica[]" >
                                                                            <select  <?php echo $disable; ?>  data-container="body" name="company_sun[]" class="form-control    company_sun  select2 " id="company_sun_<?php echo $x; ?>" style="width:150px">
                                                                                <?php   $company_sunopt = "";
                                                                                $company_sunopt  .= '<option value="">Select Company</option>';


                                                                                $query_company = select("*","tbl_product"," ");
                                                                                while($row_company = mysql_fetch_array($query_company))
                                                                                {




                                                                                    $filterproduct = stripslashes($row_company['product_name']);
                                                                                    $filterproduct = str_replace("'","&#39;",$filterproduct);
                                                                                    $filterproduct = str_replace('"',"&#34;",$filterproduct);






                                                                                    ?>
                                                                                    <option value="<?php echo $row_company['product_id']; ?>"   <?php echo selected($row_sunmica['goods_company'],$row_company['product_id']); ?>><?php echo $filterproduct; ?></option>
                                                                                <?php } ?>
                                                                            </select>
                                                                        </div>
                                                                    </td>


                                                                    <td data-title="Quantity"><div class="form-group input-group">
                                                                            <div class="  ">
                                                                                <input  <?php echo $disable; ?>  type="number" min="0" name="quant_sun[]" id="quant_sun_<?php echo $x; ?>" class="form-control quant_sun" placeholder="Quantity :" value="<?php echo $row_sunmica['goods_quantity']; ?>"  autofocus>
                                                                            </div>
                                                                        </div>
                                                                    </td>
                                                                    <td data-title="Unit"><div class="form-group input-group">
                                                                            <div class="  ">



                                                                                <select  <?php echo $disable; ?>  data-container="body" name="unit_sun[]" class="form-control    unit_sun  select2 " id="unit_sun_<?php echo $x; ?>" style="width:150px">
                                                                                    <option value="">Select unit</option>
                                                                                    <option value="1"   <?php echo selected($row_sunmica['goods_unit'],1); ?>>NO</option>
                                                                                    <option value="2"   <?php echo selected($row_sunmica['goods_unit'],2); ?>>RF</option>
                                                                                    <option value="3"   <?php echo selected($row_sunmica['goods_unit'],3); ?>>PKT</option>
                                                                                    <option value="4"   <?php echo selected($row_sunmica['goods_unit'],4); ?>>KG</option>
                                                                                    <option value="5"   <?php echo selected($row_sunmica['goods_unit'],5); ?>>SET</option>
                                                                                    <option value="6"   <?php echo selected($row_sunmica['goods_unit'],6); ?>>DZN</option>
                                                                                    <option value="7"   <?php echo selected($row_sunmica['goods_unit'],7); ?>>GRM</option>

                                                                                </select>


                                                                            </div>
                                                                        </div>
                                                                    </td>


                                                                    <td> <div class="form-group input-group">
                                                                            <div class=" " style="position:relative;">
                                                                                <input type="number" min="0" <?php echo $disable; ?> name="amount_sun[]"  value="<?php echo $row_sunmica['ammount']; ?>" id="amount_sun_<?php echo $x; ?>" class="form-control amount amount_sun"><span class="refresh_change"><div class="demo-google-material-icon"> <i class="material-icons ">refresh</i> </div></span>
                                                                            </div>
                                                                        </div>
                                                                        <input type="hidden" name="taxid_sun[]" value="<?php echo $row_sunmica['taxid']; ?>" class="taxid">
                                                                        <input type="hidden" name="tax_incl_sun[]"  value="<?php echo $row_sunmica['tax_incl']; ?>" class="taxincl">
                                                                        <input type="hidden" name="tax_type_sun[]" value="<?php echo $row_sunmica['tax_type']; ?>" class="taxtype">
                                                                        <input type="hidden" name="tax_rate_sun[]" value="<?php echo $row_sunmica['tax_rate']; ?>" class="taxrate">
                                                                        <input type="hidden" name="tax_amount_sun[]" value="<?php echo $row_sunmica['tax_amount']; ?>" class="taxamount">
                                                                        <input type="hidden" name="final_amount_sun[]" value="<?php echo $row_sunmica['final_amount']; ?>" class="finalamount"></td>
                                                                    <td><input disabled class="form-control finalamount_show_amount disabled_amount" value="<?php echo $row_sunmica['final_amount']; ?>"></td>




                                                                    <?php if(isset($_REQUEST['action']) && ($_REQUEST['action'] != "view")){ ?>
                                                                        <td data-title="Action"><i title="Delete Row " class="material-icons delete">delete</i><span class="finalamount_show"></span></td>
                                                                    <?php } ?>




                                                                </tr>
                                                                <?php $x++;
                                                            }
                                                            $suncount = $x;

                                                            ?>

                                                            </tr>










                                                            </tbody>
                                                        </table>
                                                    </div>
                                                </div>

                                            </div>
                                        </div>
                                        <div class="row" style="margin-bottom: 20px;">
                                            <div class="col-md-12">
                                                <?php if(isset($_REQUEST['action']) && ($_REQUEST['action'] != 'view')){ ?>
                                                    <span class="btn btn-primary" id="addproduct" style="display:inline;cursor:pointer;"> <div style="display: inline-block; padding-left: 0;" class="demo-google-material-icon"> <i style="top:6px;" class="material-icons">add_circle</i>&nbsp;Add New Product </div>  </span>


                                                    <span id="addsunmica" style="width:0;margin:0 auto;display: inherit"> <i  title="Add New Row "    style="color: #483aea;font-size: 30px !important;"class="material-icons">add_box</i></span>
                                                <?php  } ?>
                                            </div>
                                        </div>




                                    </div>





                                    <div class="row">
                                        <div class="col-md-12">
                                            <div class="col-md-6 col-sm-6 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class="  ">
                                                        <label for="labour"> Labour  </label>
                                                        <input <?php echo $disable; ?> type="number" id="labour" name="labour" class="form-control labour" placeholder="labour charges "  value="<?php echo $labour; ?>" min="0" autofocus>
                                                    </div>
                                                </div>
                                            </div>


                                            <div class="col-md-6 col-sm-6 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class="  ">
                                                        <label for="freight"> Freight ( भाडा )  </label>
                                                        <input <?php echo $disable; ?> type="number" id="freight" name="freight" class="form-control freight" placeholder="Freight charges "  value="<?php echo $freight; ?>"  min="0"  autofocus>
                                                    </div>
                                                </div>
                                            </div>



                                        </div>

                                    </div>





                                    <!-- sunmica ends-->






                                    <div id="tax_applied">

                                        <div class="row">
                                            <div class="col-md-12">
                                                <label class="alert alert-info text-center sectionheaders" >TAXES</label>
                                            </div>
                                        </div>
                                        <table class="table table-bordered table-striped " id="veneerstable">
                                            <thead>
                                            <tr><th>Tax</th><th>Amount</th></tr>
                                            </thead>
                                            <tbody>
                                            <?php
                                            $halftotaltaxamount = (float)$totaltaxamount/ 2;
                                            $halftotaltaxamount = round($halftotaltaxamount,2);
                                            ?>
                                            <tr><td>CGST</td><td><?php echo $halftotaltaxamount; ?></td></tr>
                                            <tr><td>SGST</td><td><?php echo $halftotaltaxamount; ?></td></tr>
                                            </tbody>
                                        </table>











                                    </div>


                                    <!-- Tax applied ends-->



                                    <hr>
                                    <div class="row">
                                        <div class="col-md-12">
                                            <label style="display:inline-block;float:right;width:auto  !important;" class="btn bg-default btn-lg btn-block waves-effect" type="button">Total :  <span class="badge" id="totalamount_show"><?php echo $total_amount;?></span></label><input type="hidden" id="totalamount" name="totalamount" value="<?php echo $total_amount;?>">
                                        </div>
                                        <div class="col-md-12">
                                            <label style="text-align:left;" class="btn bg-default btn-lg btn-block waves-effect" type="button">Amount Chargable (in words) :  <span class="badge" id="totalamtinwords_show"><?php echo $total_amount_words;?></span></label><input type="hidden" name="total_amount_words" id="totalamtinwords" value="<?php echo $total_amount_words;?>">
                                        </div>
                                    </div>


                                    <!-- Tax Detials start -->


                                    <div id="tax_details">

                                        <div class="row"> <div class="col-md-12"> <label class="alert alert-info text-center sectionheaders" >TAXES DETAILS</label></div> </div>
                                        <table class="table table-bordered table-striped " id="veneerstable"><thead>
                                            <tr><!--<th rowspan="2" class="text-center">HSN / SAC</th>--><th rowspan="2" class="text-center">Taxable Value</th><th colspan="2" class="text-center">Central Tax</th><th colspan="2" class="text-center">State Tax</th></tr>
                                            <tr><th class="text-center">Rate</th><th class="text-center">Amount</th><th class="text-center">Rate</th><th class="text-center">Amount</th></tr>
                                            </thead><tbody>



                                            <?php
                                            $order_id = $_REQUEST['order_id'];
                                            //print_r($order_id);
                                            $taxesdetails_qry = select("*","challan_taxes_table","where order_id = '".$order_id."'");
                                            while($taxesdetail_row =mysql_fetch_array($taxesdetails_qry))
                                            { ?>
                                                <tr>
                                                    <td style="display:none;"><input type="hidden" name="ot_hsn[]" value="<?php echo $taxesdetail_row['ot_hsn']; ?>"><?php echo $taxesdetail_row['ot_hsn']; ?></td>
                                                    <td><input type="hidden" name="ot_taxable_value[]" value="<?php echo $taxesdetail_row['ot_taxable_value']; ?>"><?php echo $taxesdetail_row['ot_taxable_value']; ?></td>
                                                    <td><input type="hidden" name="ot_central_rate[]" value="<?php echo $taxesdetail_row['ot_central_rate']; ?>"><?php echo $taxesdetail_row['ot_central_rate']; ?></td>
                                                    <td><input type="hidden" name="ot_central_amount[]" value="<?php echo $taxesdetail_row['ot_central_amount']; ?>"><?php echo $taxesdetail_row['ot_central_amount']; ?></td>
                                                    <td><input type="hidden" name="ot_state_rate[]" value="<?php echo $taxesdetail_row['ot_state_rate']; ?>"><?php echo $taxesdetail_row['ot_state_rate']; ?></td>
                                                    <td><input type="hidden" name="ot_state_amount[]" value="<?php echo $taxesdetail_row['ot_state_amount']; ?>"><?php echo $taxesdetail_row['ot_state_amount']; ?></td>
                                                </tr>

                                            <?php   }    ?>

                                            </tbody>
                                        </table>



                                    </div>


                                    <!-- Tax Details ends -->


                                    <hr>
                                    <div class="row">
                                        <div class="col-md-12">
                            <span style="display:inline-block;float:right;width:auto  !important;" class="btn bg-default btn-lg btn-block waves-effect" type="button">
                                Total - Taxable value:  <span class="badge" id="taxable_value_show"><?php echo $taxable_value; ?></span><input type="hidden" name="taxamount" id="taxamount" value="<?php echo  $totaltaxamount; ?>"><input type="hidden" name="taxable_value" id="taxable_value" value="<?php echo $taxable_value; ?>">
                                Central Tax:  <span class="badge" id="central_tax_show"><?php echo $central_tax; ?></span></label><input type="hidden" name="central_tax" id="central_tax" value="<?php echo $central_tax; ?>">
                            State Tax:  <span class="badge" id="state_tax_show"><?php echo $state_tax; ?></span></label><input type="hidden" name="state_tax" id="state_tax" value="<?php echo $state_tax; ?>">
                             </span>
                                        </div>
                                        <div class="col-md-12">
                                            <label style="text-align:left;" class="btn bg-default btn-lg btn-block waves-effect" type="button">Tax Amount (in words) :  <span class="badge" id="taxamtinwords_show"><?php echo $total_tax_words; ?></span></label><input type="hidden" name="taxamtinwords" id="taxamtinwords" value="<?php echo $total_tax_words; ?>">
                                        </div>
                                    </div>






                                    <div class="row">
                                        <div class="col-md-12">

                                            <div style="padding-top:20px;border-top: 1px solid #00000057 !important;">
                                                <div class="col-md-6 col-sm-6 col-xs-12">

                                                    <div class="demo-checkbox">
                                                        <input  <?php echo $disable; ?>  type="checkbox"  id="pay_now" name="pay_now"  <?php echo $pay_now_checked; ?> value="1" class="">
                                                        <label class="tdcss" for="pay_now">Pay Now</label>
                                                    </div>



                                                </div>


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





                                    <?php if(!empty($pay_now)){

                                        $order_id = $_REQUEST['order_id'];


                                        $transaction_data =  selectfetch("th_payment_mode,th_details,th_credit","tbl_transaction_history","WHERE  challan_id = '".$order_id."'   and th_type = '3' ");

                                        $th_payment_mode  =  $transaction_data->th_payment_mode;
                                        $th_details       =  $transaction_data->th_details;
                                        $pay_amount = $transaction_data->th_credit;



                                    }?>


                                    <div class="row" >
                                        <div class="col-md-12"  >




                                            <div class="col-md-4 col-sm-4 col-xs-12   <?php if(empty($pay_now_checked)){ echo " dontshow  "; } ?>    payment_mode">

                                                <div class="form-group " style="">
                                                    <!-- <div class="form-line "> -->
                                                    <label for="th_payment_mode">Payment Mode : </label>
                                                    <select    <?php echo $disable; ?>   readonly     name="th_payment_mode" id="th_payment_mode" class="form-control    select2 "     autofocus >
                                                        <option value=""> Select </option>
                                                        <option value="1" <?php echo selected('1',$th_payment_mode); ?>>CASH</option>
                                                        <option value="2" <?php echo selected('2',$th_payment_mode); ?>>CHEQUE</option>
                                                        <option value="3" <?php echo selected('3',$th_payment_mode); ?>>CARD</option>
                                                        <option value="4" <?php echo selected('4',$th_payment_mode); ?>>CASH ON BANK</option>
                                                        <option value="5" <?php echo selected('5',$th_payment_mode); ?>>RTGS</option>
                                                        <option value="6" <?php echo selected('6',$th_payment_mode); ?>>NEFT</option>
                                                    </select>
                                                    <label id="th_payment_mode-error" class="error" for="th_payment_mode"></label>

                                                    <!--  </div>-->
                                                </div>
                                            </div>


                                            <div class="col-md-4 col-sm-4 col-xs-12 <?php if($th_payment_mode != 2 && $th_payment_mode != 5 ){ echo " dontshow ";  }?> chequedetails" >
                                                <div class="form-group input-group">
                                                    <div class=" ">
                                                        <label for="th_details" id="chequedetails_title">
                                                            <?php if($th_payment_mode == 2){
                                                                echo " CHEQUE Details : ";
                                                            }else{
                                                                echo " RTGS Details : ";
                                                            }
                                                            ?>
                                                        </label>
                                                        <input   <?php echo $disable; ?>     type="text" name="th_details" id="th_details"   class="form-control" placeholder="<?php if($th_payment_mode == 2){
                                                            echo "CHEQUE Details : ";
                                                        }else{
                                                            echo "RTGS Details : ";
                                                        }
                                                        ?>" value="<?php echo  $th_details; ?>"  autofocus>
                                                    </div>
                                                </div>
                                            </div>






                                            <div class="col-md-4 col-sm-4 col-xs-12   <?php if(empty($pay_now_checked)){ echo " dontshow  "; } ?>   pay_amount" >
                                                <div class="form-group input-group">
                                                    <div class=" ">
                                                        <label for="pay_amount" > Amount Paid</label>
                                                        <input   <?php echo $disable; ?>     type="number" name="pay_amount" id="pay_amount"   class="form-control" placeholder="Amount Paid " value="<?php echo $pay_amount; ?>" min="0"  autofocus>
                                                    </div>
                                                </div>
                                            </div>










                                        </div>
                                    </div>















                                </div>





                            <?php  }
                            else{


                                if(isset($_REQUEST['estimate_id'])){



                                 /*   $totalorders = getvalue("MAX(challan_number)"," tbl_challan_entry","where challan_number like '%".$fystart.$fyend."' AND cancel IS NULL ");


                                 //   $totalorders = getvalue("MAX(challan_number)"," tbl_challan_entry","where cancel IS NULL ");

                                    /*  new code start  */


                                 /*   $oldfinancialYear  = substr($totalorders, -4);

                                    if($oldfinancialYear == $fystart.$fyend){
                                        $totalorders =  substr($totalorders, 0, -4);
                                    }else{
                                        $totalorders = 0;
                                    } */

                                  //  $totalorders =  substr($totalorders, 0, -4);

                                    /*  $fs  = explode($fyear,$totalorders);
                                      $totalorders  = 0;
                                      if(count($fs) > 1){
                                          $totalorders = $fs[0];
                                      } */

                                 /*   $totalorders_number = ($totalorders + 1);
                                    $pdf_name = "";
                                    if(strlen($totalorders_number) == 1){

                                        $totalorders_number = "0".$totalorders_number;

                                    }



                                    $pdf_name  = $totalorders_number."(".$fystart."-".$fyend.")";
                                    $totalorders =  $totalorders_number.$fyear; */


                                    /*  new code ends  */


                                  /*  if(isset($_POST['challan_number'])){
                                        if(!empty($_POST['challan_number'])){
                                            $totalorders = $_POST['challan_number'];
                                        }
                                    } */











                                    $orderid = $_REQUEST['estimate_id'];




                                    $orderdetials  = selectfetch("*","tbl_estimate_entry as o"," WHERE id = '".$orderid."'");




                                    $totaltaxamount = $orderdetials->total_tax;



                                    $pay_now = 0;
                                    $pay_now_checked = "";



//                            $orderdate  = $orderdetials->order_date;
//                            if(!empty($orderdate) && ($orderdate != "0000-00-00")){
//                                $orderdate = date('d-m-Y',strtotime($orderdate));
//                            }


                                    $orderdate = date('d-m-Y');

                                    $officeid = $orderdetials->office_id;
                                    $customerid = $orderdetials->customerid;

                                    $customerdetials = selectfetch("*","tbl_customer","where cust_id IS NOT NULL and cust_id = '".$customerid."'");
                                    $cust_contact = '';
                                    if(!empty($customerdetials->cust_contact)){
                                        $cust_contact = $customerdetials->cust_contact;
                                    }

                                    $cust_tin = '';
                                    if(!empty($customerdetials->cust_tin)){
                                        $cust_tin = $customerdetials->cust_tin;
                                    }



                                    $cust_email = '';
                                    if(!empty($customerdetials->cust_email)){
                                        $cust_email = $customerdetials->cust_email;
                                    }


                                    $cust_address = '';
                                    if(!empty($customerdetials->cust_address)){
                                        $cust_address = $customerdetials->cust_address;
                                    }
                                    $total_amount = 0;
                                    if(!empty($orderdetials->total_amount)){
                                        $total_amount = $orderdetials->total_amount;
                                    }


                                    $total_amount_words = '';
                                    if(!empty($orderdetials->total_amount_words)){
                                        $total_amount_words = $orderdetials->total_amount_words;
                                    }



                                    $taxable_value = 0;
                                    if(!empty($orderdetials->taxable_value)){
                                        $taxable_value = $orderdetials->taxable_value;
                                    }


                                    $central_tax = 0;
                                    if(!empty($orderdetials->central_tax)){
                                        $central_tax = $orderdetials->central_tax;
                                    }

                                    $state_tax = 0;
                                    if(!empty($orderdetials->state_tax)){
                                        $state_tax = $orderdetials->state_tax;
                                    }





                                    $total_tax_words = '';
                                    if(!empty($orderdetials->total_tax_words)){
                                        $total_tax_words = $orderdetials->total_tax_words;
                                    }

                                    /* $boards


                                       $veneers


                                       $taxes */


                                    ?>



                                    <input type="hidden" id="sunmicahsn" name="sunmicahsn" value="<?php echo $sunmicahsn; ?>">
                                    <input type="hidden" id="veneerhsn" name="veneerhsn" value="<?php echo $veneerhsn; ?>">
                                    <input type="hidden" id="boardhsn" name="boardhsn" value="<?php echo $boardhsn; ?>">
                                    <input type="hidden" name="cust_id" id="cust_id" value="<?php echo $cust_id;?>"/>



                                    <div class="col-md-12">


                                        <div class="row">


                                            <div class="col-md-3 col-sm-3 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class=" ">
                                                        <label for="challan_number"> Vehicle number </label>
                                                        <input  <?php echo $disable; ?> type="text" id="vehicle_no" name="vehicle_no" class="form-control" placeholder="vehicle number"  value="" autofocus>
                                                    </div>
                                                </div>
                                            </div>


                                            <div class="col-md-3 col-sm-3 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class="  ">
                                                        <label for="order_date">Challan Date </label>
                                                        <input  <?php echo $disable; ?>  type="text" id="order_date" name="order_date" class="form-control mydate" value="<?php echo $orderdate; ?>" placeholder="Order Date :" autofocus>
                                                    </div>
                                                </div>
                                            </div>




                                            <div class="col-md-3 col-sm-3 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class=" ">
                                                        <label for="supervisor_number">Supervisor Number </label>
                                                        <input  <?php echo $disable; ?> type="number" id="supervisor_number" name="supervisor_number" class="form-control" placeholder="Supervisor Number"  value="" autofocus>

                                                    </div>
                                                    <label class="supervisor_number_error"></label>
                                                </div>
                                            </div>


                                            <div style="display:none;" class="col-md-6 col-sm-6 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class=" ">
                                                        <label for="order_date">Challan Number </label>
                                                        <input  <?php echo $disable; ?>   readonly  type="hidden" id="challan_number" name="challan_number" class="form-control " value="<?php echo $totalorders; ?>" placeholder="challan number :" autofocus>

                                                        <input  <?php echo $disable; ?>  readonly  type="text" id="challan_number" name="pdf_name" class="form-control " value="<?php echo $pdf_name; ?>" placeholder="estimate number :" autofocus>
                                                    </div>
                                                </div>
                                            </div>




                                        </div>



                                    </div>




                                    <div class="col-md-12">
                                        <div class="form-group">
                                            <label>Customer Details :
                                                <?php   if(!isset($_REQUEST['action']) || $_REQUEST['action'] != 'view'){ ?>

                                                    <span id="addcustomer" style="display:inline;cursor:pointer;">
                                                <div style="display: inline-block; padding-left: 20px;" class="demo-google-material-icon">
                                                    <i  title="Add New Customer" style="color: #483aea;"  class="material-icons">person_add</i>
                                                    <span class="icon-name"></span>
                                                </div>
                                            </span>


                                                <?php }   ?>




                                            </label>
                                        </div>
                                    </div>



                                    <div class="col-md-12">


                                        <div class="row">


                                    <?php if(isset($_SESSION['bow']) &&  $_SESSION['bow'] == 2  ){ ?>
                                            
                                            

                                            <div class="col-md-4 col-sm-4 col-xs-12">

                                                <div class="form-group input-group">
                                                    <label for="customer">Customer Name :</label>
                                                    <select  <?php echo $disable; ?>   name="customer" id="customer" onChange="getcustomer_detail(document.getElementById(id),this.value);" class="form-control customer   select2 "  data-live-search="true"   autofocus >
                                                        <option value=""> Select Party </option>
                                                        <?php $query_customer = select("*","tbl_customer","where  cust_id IS NOT NULL  order by cust_name ");
                                                        while($row_customer = mysql_fetch_array($query_customer))
                                                        {
                                                            ?>
                                                            <option value="<?php echo $row_customer['cust_id']; ?>" <?php echo selected($customerid,$row_customer['cust_id']); ?>><?php echo $row_customer['cust_name']; ?></option>
                                                        <?php } ?>
                                                    </select>

                                                </div>
                                            </div>


                                    <?php }else{ ?>


                                        <div class="col-md-4 col-sm-4 col-xs-12">

                                            <div class="form-group input-group">
                                                <label for="customer">Customer Name :</label>
                                                <select  <?php echo $disable; ?>   name="customer" id="customer" onChange="getcustomer_detail(document.getElementById(id),this.value);" class="form-control customer   select2 "  data-live-search="true"   autofocus >
                                                    <option value=""> Select Party </option>
                                                    <?php $query_customer = select("*","tbl_customer","where  cust_id IS NOT NULL  and bow = '1'  order by cust_name ");
                                                    while($row_customer = mysql_fetch_array($query_customer))
                                                    {
                                                        ?>
                                                        <option value="<?php echo $row_customer['cust_id']; ?>" <?php echo selected($customerid,$row_customer['cust_id']); ?>><?php echo $row_customer['cust_name']; ?></option>
                                                    <?php } ?>
                                                </select>

                                            </div>
                                        </div>

                                    <?php } ?>



                                            <div class="col-md-4 col-sm-4 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class=" ">
                                                        <label for="cust_no">Customer Number :</label>
                                                        <input  <?php echo $disable; ?>  type="text" id="cust_no" name="cust_no" class="form-control disabled" placeholder="Contact No :" value="<?php echo $cust_contact; ?>" disabled autofocus>
                                                    </div>
                                                </div>
                                            </div>

                                            <div class="col-md-4 col-sm-4 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class=" ">
                                                        <label for="cust_tin">GST NO. :</label>
                                                        <input  <?php echo $disable; ?>  type="text" id="cust_tin" name="cust_tin" class="form-control disabled" placeholder="GST No. :" value="<?php echo $cust_tin; ?>" disabled autofocus>
                                                    </div>
                                                </div>
                                            </div>



                                        </div>



                                    </div>



                                    <div class="col-md-12 col-sm-12 col-xs-12">
                                        <div class="form-group input-group">
                                            <div class=" ">
                                                <label for="cust_email">Customer Email :</label>
                                                <input  <?php echo $disable; ?>  type="text" id="cust_email" name="cust_email" class="form-control disabled" value="<?php echo $cust_email; ?>" placeholder="Party Email:"  disabled autofocus>
                                            </div>
                                        </div>
                                    </div>


                                    <div class="col-md-12 col-sm-12 col-xs-12">
                                        <div class="form-group input-group">
                                            <div class=" ">
                                                <label for="cust_addr">Customer Address :</label>
                                                <textarea  <?php echo $disable; ?>  id="cust_addr" name="cust_addr" class="form-control disabled"   placeholder="Party Address:"  disabled autofocus><?php echo $cust_address; ?></textarea>
                                            </div>
                                        </div>
                                    </div>




                                    <div class="col-md-12">
                                        <div class="form-group">
                                            <h3 id="challanblock_title" class="text-center">
                                                Delivery challan  Details
                                            </h3>
                                            <hr />
                                        </div>
                                    </div>







                                    <!-- sunmica starts-->

                                    <!--  <div class="row">
                                          <div class="col-md-12">
                                              <label class="alert alert-warning sectionheaders" style="">Challan Details</label>
                                          </div>
                                      </div> -->



                                    <div id="challanblock">






                                        <div class="col-md-12">



                                            <div class="row">
                                                <div class="col-md-12">

                                                    <div class="table-responsive">

                                                        <div id="no-more-tables">

                                                            <table class="table table-bordered table-striped " id="sunmicatable" style="table-layout:fixed;">
                                                                <thead>
                                                                <th style="width:50px;">Particulars
                                                                    <?php /*   if(!isset($_REQUEST['action']) || $_REQUEST['action'] != 'view'){ ?>
                                                                          <span id="addproduct" style="display:inline;cursor:pointer;"> <div style="display: inline-block; padding-left: 20px;" class="demo-google-material-icon"> <i class="material-icons">add_circle</i> <span class="icon-name"></span> </div>  </span>
                                                                      <?php } */
                                                                    ?>
                                                                </th>
                                                                <th style="width: 30px;"  >Quantity</th>
                                                                <th style="width: 26px;">Unit</th>
                                                                <th style="width: 30px;">Rate</th>
                                                                <th style="width: 30px;">Amount</th>
                                                                <th style="width: 20px;">Action</th>

                                                                </thead>
                                                                <tbody>


                                                                <?php


                                                                $sunmica_query  = select("*","tbl_estimate"," where o_id = '".$orderid."'");
                                                                $x=1;
                                                                while($row_sunmica = mysql_fetch_array($sunmica_query)){  ?>

                                                                    <tr>
                                                                        <td data-title="Particulars">
                                                                            <div class="form-group ">
                                                                                <input type="hidden" name="sunmica[]" >
                                                                                <select  <?php echo $disable; ?>  data-container="body" name="company_sun[]" class="form-control    company_sun  select2 " id="company_sun_<?php echo $x; ?>" style="width:150px">
                                                                                    <?php   $company_sunopt = "";
                                                                                    $company_sunopt  .= '<option value="">Select Company</option>';


                                                                                    $query_company = select("*","tbl_product"," ");
                                                                                    while($row_company = mysql_fetch_array($query_company))
                                                                                    {




                                                                                        $filterproduct = stripslashes($row_company['product_name']);
                                                                                        $filterproduct = str_replace("'","&#39;",$filterproduct);
                                                                                        $filterproduct = str_replace('"',"&#34;",$filterproduct);






                                                                                        ?>
                                                                                        <option value="<?php echo $row_company['product_id']; ?>"   <?php echo selected($row_sunmica['goods_company'],$row_company['product_id']); ?>><?php echo $filterproduct; ?></option>
                                                                                    <?php } ?>
                                                                                </select>
                                                                            </div>
                                                                        </td>


                                                                        <td data-title="Quantity"><div class="form-group input-group">
                                                                                <div class="  ">
                                                                                    <input  <?php echo $disable; ?>  type="number" min="0" name="quant_sun[]" id="quant_sun_<?php echo $x; ?>" class="form-control quant_sun" placeholder="Quantity :" value="<?php echo $row_sunmica['goods_quantity']; ?>"  autofocus>
                                                                                </div>
                                                                            </div>
                                                                        </td>
                                                                        <td data-title="Unit"><div class="form-group input-group">
                                                                                <div class="  ">



                                                                                    <select  <?php echo $disable; ?>  data-container="body" name="unit_sun[]" class="form-control    unit_sun  select2 " id="unit_sun_<?php echo $x; ?>" style="width:150px">
                                                                                        <option value="">Select unit</option>
                                                                                        <option value="1"   <?php echo selected($row_sunmica['goods_unit'],1); ?>>NO</option>
                                                                                        <option value="2"   <?php echo selected($row_sunmica['goods_unit'],2); ?>>RF</option>
                                                                                        <option value="3"   <?php echo selected($row_sunmica['goods_unit'],3); ?>>PKT</option>
                                                                                        <option value="4"   <?php echo selected($row_sunmica['goods_unit'],4); ?>>KG</option>
                                                                                        <option value="5"   <?php echo selected($row_sunmica['goods_unit'],5); ?>>SET</option>
                                                                                        <option value="6"   <?php echo selected($row_sunmica['goods_unit'],6); ?>>DZN</option>
                                                                                        <option value="7"   <?php echo selected($row_sunmica['goods_unit'],7); ?>>GRM</option>

                                                                                    </select>


                                                                                </div>
                                                                            </div>
                                                                        </td>


                                                                        <td> <div class="form-group input-group">
                                                                                <div class=" " style="position:relative;">
                                                                                    <input type="number" min="0"  <?php echo $disable; ?> name="amount_sun[]"  value="<?php echo $row_sunmica['ammount']; ?>" id="amount_sun_<?php echo $x; ?>" class="form-control amount amount_sun"><span class="refresh_change"><div class="demo-google-material-icon"> <i class="material-icons ">refresh</i> </div></span>
                                                                                </div>
                                                                            </div>
                                                                            <input type="hidden" name="taxid_sun[]" value="<?php echo $row_sunmica['taxid']; ?>" class="taxid">
                                                                            <input type="hidden" name="tax_incl_sun[]"  value="<?php echo $row_sunmica['tax_incl']; ?>" class="taxincl">
                                                                            <input type="hidden" name="tax_type_sun[]" value="<?php echo $row_sunmica['tax_type']; ?>" class="taxtype">
                                                                            <input type="hidden" name="tax_rate_sun[]" value="<?php echo $row_sunmica['tax_rate']; ?>" class="taxrate">
                                                                            <input type="hidden" name="tax_amount_sun[]" value="<?php echo $row_sunmica['tax_amount']; ?>" class="taxamount">
                                                                            <input type="hidden" name="final_amount_sun[]" value="<?php echo $row_sunmica['final_amount']; ?>" class="finalamount"></td>
                                                                        <td><input disabled class="form-control finalamount_show_amount disabled_amount" value="<?php echo $row_sunmica['final_amount']; ?>"></td>





                                                                        <td data-title="Action"><i title="Delete Row" class="material-icons delete">delete</i><span class="finalamount_show"></span></td>





                                                                    </tr>
                                                                    <?php $x++;
                                                                }
                                                                $suncount = $x;

                                                                ?>

                                                                </tr>










                                                                </tbody>
                                                            </table>
                                                        </div>
                                                    </div>

                                                </div>
                                            </div>
                                            <div class="row" style="margin-bottom: 20px;">
                                                <div class="col-md-12">

                                                    <span class="btn btn-primary" id="addproduct" style="display:inline;cursor:pointer;"> <div style="display: inline-block; padding-left: 0;" class="demo-google-material-icon"> <i style="top:6px;" class="material-icons">add_circle</i>&nbsp;Add New Product </div>  </span>

                                                    <span id="addsunmica" style="width:0;margin:0 auto;display: inherit"> <i title="Add New Row "    style="color: #483aea;font-size: 30px !important;"class="material-icons">add_box</i></span>

                                                </div>
                                            </div>




                                        </div>





                                        <div class="row">
                                            <div class="col-md-12">
                                                <div class="col-md-6 col-sm-6 col-xs-12">
                                                    <div class="form-group input-group">
                                                        <div class="  ">
                                                            <label for="labour"> Labour  </label>
                                                            <input <?php echo $disable; ?> type="number" id="labour" name="labour" class="form-control labour" placeholder="labour charges "   min="0"  value="0" autofocus>
                                                        </div>
                                                    </div>
                                                </div>


                                                <div class="col-md-6 col-sm-6 col-xs-12">
                                                    <div class="form-group input-group">
                                                        <div class="  ">
                                                            <label for="freight"> Freight ( भाडा )  </label>
                                                            <input <?php echo $disable; ?> type="number" id="freight" name="freight" class="form-control freight" placeholder="Freight charges "  min="0"   value="0" autofocus>
                                                        </div>
                                                    </div>
                                                </div>



                                            </div>

                                        </div>





                                        <!-- sunmica ends-->






                                        <div id="tax_applied">

                                            <div class="row">
                                                <div class="col-md-12">
                                                    <label class="alert alert-info text-center sectionheaders" >TAXES</label>
                                                </div>
                                            </div>
                                            <table class="table table-bordered table-striped " id="veneerstable">
                                                <thead>
                                                <tr><th>Tax</th><th>Amount</th></tr>
                                                </thead>
                                                <tbody>
                                                <?php
                                                $halftotaltaxamount = (float)$totaltaxamount/ 2;
                                                $halftotaltaxamount = round($halftotaltaxamount,2);
                                                ?>
                                                <tr><td>CGST</td><td><?php echo $halftotaltaxamount; ?></td></tr>
                                                <tr><td>SGST</td><td><?php echo $halftotaltaxamount; ?></td></tr>
                                                </tbody>
                                            </table>
                                        </div>


                                        <!-- Tax applied ends-->



                                        <hr>
                                        <div class="row">
                                            <div class="col-md-12">
                                                <label style="display:inline-block;float:right;width:auto  !important;" class="btn bg-default btn-lg btn-block waves-effect" type="button">Total :  <span class="badge" id="totalamount_show"><?php echo $total_amount;?></span></label><input type="hidden" id="totalamount" name="totalamount" value="<?php echo $total_amount;?>">
                                            </div>
                                            <div class="col-md-12">
                                                <label style="text-align:left;" class="btn bg-default btn-lg btn-block waves-effect" type="button">Amount Chargable (in words) :  <span class="badge" id="totalamtinwords_show"><?php echo $total_amount_words;?></span></label><input type="hidden" name="total_amount_words" id="totalamtinwords" value="<?php echo $total_amount_words;?>">
                                            </div>
                                        </div>


                                        <!-- Tax Detials start -->


                                        <div id="tax_details">

                                            <div class="row"> <div class="col-md-12"> <label class="alert alert-info text-center sectionheaders" >TAXES DETAILS</label></div> </div>
                                            <table class="table table-bordered table-striped " id="veneerstable"><thead>
                                                <tr><!--<th rowspan="2" class="text-center">HSN / SAC</th>--><th rowspan="2" class="text-center">Taxable Value</th><th colspan="2" class="text-center">Central Tax</th><th colspan="2" class="text-center">State Tax</th></tr>
                                                <tr><th class="text-center">Rate</th><th class="text-center">Amount</th><th class="text-center">Rate</th><th class="text-center">Amount</th></tr>
                                                </thead><tbody>



                                                <?php
                                                $order_id = $_REQUEST['estimate_id'];
                                                //print_r($order_id);
                                                $taxesdetails_qry = select("*","estimate_taxes_table","where order_id = '".$order_id."'");
                                                while($taxesdetail_row =mysql_fetch_array($taxesdetails_qry))
                                                { ?>
                                                    <tr>
                                                        <td style="display:none;"><input type="hidden" name="ot_hsn[]" value="<?php echo $taxesdetail_row['ot_hsn']; ?>"><?php echo $taxesdetail_row['ot_hsn']; ?></td>
                                                        <td><input type="hidden" name="ot_taxable_value[]" value="<?php echo $taxesdetail_row['ot_taxable_value']; ?>"><?php echo $taxesdetail_row['ot_taxable_value']; ?></td>
                                                        <td><input type="hidden" name="ot_central_rate[]" value="<?php echo $taxesdetail_row['ot_central_rate']; ?>"><?php echo $taxesdetail_row['ot_central_rate']; ?></td>
                                                        <td><input type="hidden" name="ot_central_amount[]" value="<?php echo $taxesdetail_row['ot_central_amount']; ?>"><?php echo $taxesdetail_row['ot_central_amount']; ?></td>
                                                        <td><input type="hidden" name="ot_state_rate[]" value="<?php echo $taxesdetail_row['ot_state_rate']; ?>"><?php echo $taxesdetail_row['ot_state_rate']; ?></td>
                                                        <td><input type="hidden" name="ot_state_amount[]" value="<?php echo $taxesdetail_row['ot_state_amount']; ?>"><?php echo $taxesdetail_row['ot_state_amount']; ?></td>
                                                    </tr>

                                                <?php   }    ?>

                                                </tbody>
                                            </table>



                                        </div>


                                        <!-- Tax Details ends -->


                                        <hr>
                                        <div class="row">
                                            <div class="col-md-12">
                            <span style="display:inline-block;float:right;width:auto  !important;" class="btn bg-default btn-lg btn-block waves-effect" type="button">
                                Total - Taxable value:  <span class="badge" id="taxable_value_show"><?php echo $taxable_value; ?></span><input type="hidden" name="taxamount" id="taxamount" value="<?php echo  $totaltaxamount; ?>"><input type="hidden" name="taxable_value" id="taxable_value" value="<?php echo $taxable_value; ?>">
                                Central Tax:  <span class="badge" id="central_tax_show"><?php echo $central_tax; ?></span></label><input type="hidden" name="central_tax" id="central_tax" value="<?php echo $central_tax; ?>">
                            State Tax:  <span class="badge" id="state_tax_show"><?php echo $state_tax; ?></span></label><input type="hidden" name="state_tax" id="state_tax" value="<?php echo $state_tax; ?>">
                             </span>
                                            </div>
                                            <div class="col-md-12">
                                                <label style="text-align:left;" class="btn bg-default btn-lg btn-block waves-effect" type="button">Tax Amount (in words) :  <span class="badge" id="taxamtinwords_show"><?php echo $total_tax_words; ?></span></label><input type="hidden" name="taxamtinwords" id="taxamtinwords" value="<?php echo $total_tax_words; ?>">
                                            </div>
                                        </div>






                                        <div class="row">
                                            <div class="col-md-12">

                                                <div style="padding-top:20px;border-top: 1px solid #00000057 !important;">
                                                    <div class="col-md-6 col-sm-6 col-xs-12">

                                                        <div class="demo-checkbox">
                                                            <input  <?php echo $disable; ?>  type="checkbox"  id="pay_now" name="pay_now"  <?php echo $pay_now_checked; ?> value="1" class="">
                                                            <label class="tdcss" for="pay_now">Pay Now</label>
                                                        </div>



                                                    </div>


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





                                        <div class="row" >
                                            <div class="col-md-12"  >




                                                <div class="col-md-4 col-sm-4 col-xs-12   <?php if(empty($pay_now_checked)){ echo " dontshow  "; } ?>    payment_mode">

                                                    <div class="form-group " style="">
                                                        <!-- <div class="form-line "> -->
                                                        <label for="th_payment_mode">Payment Mode : </label>
                                                        <select    <?php echo $disable; ?>   readonly     name="th_payment_mode" id="th_payment_mode" class="form-control    select2 "     autofocus >
                                                            <option value=""> Select </option>
                                                            <option value="1" >CASH</option>
                                                            <option value="2"  >CHEQUE</option>
                                                            <option value="3" >CARD</option>
                                                            <option value="4" >CASH ON BANK</option>
                                                            <option value="5" >RTGS</option>
                                                            <option value="6" >NEFT</option>
                                                        </select>
                                                        <label id="th_payment_mode-error" class="error" for="th_payment_mode"></label>

                                                        <!--  </div>-->
                                                    </div>
                                                </div>


                                                <div class="col-md-4 col-sm-4 col-xs-12 <?php if($th_payment_mode != 2 && $th_payment_mode != 5 ){ echo " dontshow ";  }?> chequedetails" >
                                                    <div class="form-group input-group">
                                                        <div class=" ">
                                                            <label for="th_details" id="chequedetails_title">  </label>
                                                            <input   <?php echo $disable; ?>     type="text" name="th_details" id="th_details"   class="form-control" placeholder="" value=""   autofocus>
                                                        </div>
                                                    </div>
                                                </div>






                                                <div class="col-md-4 col-sm-4 col-xs-12   dontshow   pay_amount" >
                                                    <div class="form-group input-group">
                                                        <div class=" ">
                                                            <label for="pay_amount" > Amount Paid</label>
                                                            <input   <?php echo $disable; ?>     type="number" name="pay_amount" id="pay_amount"   class="form-control" placeholder="Amount Paid " value="<?php echo $total_amount; ?>" min="0"  autofocus>
                                                        </div>
                                                    </div>
                                                </div>










                                            </div>
                                        </div>












                                    </div>






                                <?php   }

                                else{ ?>

                                    <input type="hidden" id="sunmicahsn" name="sunmicahsn" value="<?php echo $sunmicahsn; ?>">
                                    <input type="hidden" id="veneerhsn" name="veneerhsn" value="<?php echo $veneerhsn; ?>">
                                    <input type="hidden" id="boardhsn" name="boardhsn" value="<?php echo $boardhsn; ?>">
                                    <input type="hidden" name="cust_id" id="cust_id" value="<?php echo $cust_id;?>"/>

                                    <?php
                                 /*   $totalorders = getvalue("MAX(challan_number)"," tbl_challan_entry","where challan_number like '%".$fystart.$fyend."' AND cancel IS NULL ");

                                    



                                    $oldfinancialYear  = substr($totalorders, -4);

                                    if($oldfinancialYear == $fystart.$fyend){
                                        $totalorders =  substr($totalorders, 0, -4);
                                    }else{
                                        $totalorders = 0;
                                    }




                                    //$totalorders =  substr($totalorders, 0, -4);

                                    /*$fs  = explode($fyear,$totalorders);
                                    $totalorders  = 0;
                                    if(count($fs) > 1){
                                        $totalorders = $fs[0];
                                    } */



                                  /*  $totalorders_number = ($totalorders + 1);

                                    $pdf_name = "";
                                    if(strlen($totalorders_number) == 1){

                                        $totalorders_number = "0".$totalorders_number;

                                    }



                                    $pdf_name  = $totalorders_number."(".$fystart."-".$fyend.")";
                                    $totalorders =  $totalorders_number.$fyear; */


                                    /*  new code ends  */


                                  /*  if(isset($_POST['challan_number'])){
                                        if(!empty($_POST['challan_number'])){
                                            $totalorders = $_POST['challan_number'];
                                        }
                                    }  */





                                    $customerid = '';
                                    $cust_contact = '';
                                    $cust_tin = '';
                                    $cust_email = '';
                                    $cust_address = '';

                                    if(isset($_REQUEST['cust_id'])){

                                        $customerid = $_REQUEST['cust_id'];
                                        $customerdetials = selectfetch("*","tbl_customer","where cust_id IS NOT NULL and cust_id = '".$customerid."'");




                                        $cust_contact = '';
                                        if(!empty($customerdetials->cust_contact)){
                                            $cust_contact = $customerdetials->cust_contact;
                                        }

                                        $cust_tin = '';
                                        if(!empty($customerdetials->cust_tin)){
                                            $cust_tin = $customerdetials->cust_tin;
                                        }



                                        $cust_email = '';
                                        if(!empty($customerdetials->cust_email)){
                                            $cust_email = $customerdetials->cust_email;
                                        }


                                        $cust_address = '';
                                        if(!empty($customerdetials->cust_address)){
                                            $cust_address = $customerdetials->cust_address;
                                        }


                                    }




                                    ?>


                                    <div class="col-md-12">

                                        <div class="row">

                                            <div class="col-md-3 col-sm-3 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class=" ">
                                                        <label for="challan_number"> Vehicle number </label>
                                                        <input type="text" id="vehicle_no" name="vehicle_no" class="form-control" placeholder="vehicle number"  value="" autofocus>
                                                    </div>
                                                </div>
                                            </div>

                                            <div class="col-md-3 col-sm-3 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class=" ">
                                                        <label for="order_date"> Challan Date </label>
                                                        <input type="text" id="order_date" name="order_date" class="form-control mydate" placeholder="Order Date :"  value="<?php echo date('d-m-Y'); ?>" autofocus>
                                                    </div>
                                                </div>
                                            </div>




                                            <div class="col-md-3 col-sm-3 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class=" ">
                                                        <label for="supervisor_number">Supervisor Number </label>
                                                        <input  <?php echo $disable; ?>  type="number" id="supervisor_number" name="supervisor_number" class="form-control" placeholder="Supervisor Number"  value="" autofocus>

                                                    </div>
                                                    <label class="supervisor_number_error"></label>
                                                </div>
                                            </div>


                                            <div style="display:none;" class="col-md-6 col-sm-6 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class=" ">
                                                        <label for="challan_number"> Challan Number </label>
                                                        <input type="hidden" readonly id="challan_number" name="challan_number" class="form-control" placeholder="challan number"  value="<?php echo $totalorders; ?>" autofocus>
                                                        <input type="text" readonly id="challan_number" name="pdf_name" class="form-control" placeholder="challan number"  value="<?php echo $pdf_name; ?>" autofocus>
                                                     </div>
                                                </div>
                                            </div>

                                         </div>

                                    </div>



                                    <div class="col-md-12">
                                        <div class="form-group">
                                            <label>Customer Details :




                                                <?php   if(!isset($_REQUEST['action']) || $_REQUEST['action'] != 'view'){ ?>



                                                <span id="addcustomer" style="display:inline;cursor:pointer;">
                                            <div style="display: inline-block; padding-left: 20px;" class="demo-google-material-icon">
                                                <i  title="Add New Customer" style="color: #483aea;"  class="material-icons">person_add</i> <span class="icon-name"></span>
                                            </div>
                                        </span>


                                            </label>




                                            <?php } ?>




                                        </div>
                                    </div>






                                    <div class="col-md-12">

                                        <div class="row">


                                    <?php if(isset($_SESSION['bow']) &&  $_SESSION['bow'] == 2  ){ ?>

                                            <div class="col-md-4 col-sm-4 col-xs-12">

                                                <div class="form-group input-group">
                                                    <label for="customer">Customer Name :</label>
                                                    <select  name="customer" id="customer" onChange="getcustomer_detail(document.getElementById(id),this.value);" class="form-control  customer     select2 "  data-live-search="true"   autofocus >
                                                        <option value=""> Select Party </option>
                                                        <?php $query_customer = select("*","tbl_customer","where cust_id IS NOT NULL order by cust_name ");
                                                        while($row_customer = mysql_fetch_array($query_customer))

                                                        {
                                                            ?>
                                                            <option value="<?php echo $row_customer['cust_id']; ?>" <?php echo selected($customerid,$row_customer['cust_id']); ?>><?php echo $row_customer['cust_name']; ?></option>
                                                        <?php } ?>
                                                    </select>

                                                </div>
                                            </div>

                                    <?php }else{ ?>

                                        <div class="col-md-4 col-sm-4 col-xs-12">

                                            <div class="form-group input-group">
                                                <label for="customer">Customer Name :</label>
                                                <select  name="customer" id="customer" onChange="getcustomer_detail(document.getElementById(id),this.value);" class="form-control  customer     select2 "  data-live-search="true"   autofocus >
                                                    <option value=""> Select Party </option>
                                                    <?php $query_customer = select("*","tbl_customer","where cust_id IS NOT NULL  and bow = '1'  order by cust_name ");
                                                    while($row_customer = mysql_fetch_array($query_customer))

                                                    {
                                                        ?>
                                                        <option value="<?php echo $row_customer['cust_id']; ?>" <?php echo selected($customerid,$row_customer['cust_id']); ?>><?php echo $row_customer['cust_name']; ?></option>
                                                    <?php } ?>
                                                </select>

                                            </div>
                                        </div>




                                    <?php } ?>




                                            <div class="col-md-4 col-sm-4 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class="  ">
                                                        <label for="cust_no">Customer Mobile :</label>
                                                        <input type="text" id="cust_no" value="<?php echo $cust_contact; ?>" name="cust_no" class="form-control disabled" placeholder="Contact No :"  disabled autofocus>
                                                    </div>
                                                </div>
                                            </div>


                                            <div class="col-md-4 col-sm-4 col-xs-12">
                                                <div class="form-group input-group">
                                                    <div class=" ">
                                                        <label for="cust_tin">GST NO. :</label>
                                                        <input type="text" id="cust_tin" value="<?php echo $cust_tin; ?>" name="cust_tin" class="form-control disabled" placeholder="GST No. :"  disabled autofocus>
                                                    </div>
                                                </div>
                                            </div>




                                        </div>


                                    </div>




                                    <div class="col-md-12 col-sm-12 col-xs-12">
                                        <div class="form-group input-group">
                                            <div class="  ">
                                                <label for="cust_email">Customer Email :</label>
                                                <input type="text" id="cust_email" value="<?php echo $cust_email; ?>" name="cust_email" class="form-control disabled" placeholder="Party Email:"  disabled autofocus>
                                            </div>
                                        </div>
                                    </div>



                                    <div class="col-md-12 col-sm-12 col-xs-12">
                                        <div class="form-group input-group">
                                            <div class=" ">
                                                <label for="cust_addr">Customer Address :</label>
                                                <textarea id="cust_addr"   name="cust_addr" class="form-control disabled" placeholder="Party Address:"  disabled autofocus><?php echo trim(stripslashes($cust_address)); ?></textarea>
                                            </div>
                                        </div>
                                    </div>


                                    <div class="col-md-12">
                                        <div class="form-group">
                                            <h3 id="challanblock_title" class="text-center"><?php
                                                if($custstatus == 'Disabled'){ echo " <span style='color:red;'>Cannot create Challan : Contact Admin </span>"; }else{
                                                    echo "  Delivery challan  Details ";
                                                } ?>  </h3>
                                            <hr />
                                        </div>
                                    </div>


                                    <!--   Disable condition   -->
                                    <div id="challanblock" style="<?php  if($custstatus == 'Disabled'){ echo "display:none;"; } ?>" >





                                        <!-- order details starts-->

                                        <div class="col-md-12">
                                            <div class="row">
                                                <div class="col-md-12">

                                                    <div class="table-responsive">

                                                        <div id="no-more-tables">

                                                            <table class="table table-bordered table-striped " id="sunmicatable" style="table-layout: fixed;" >
                                                                <thead>
                                                                <th style="width: 50px;" >Particulars
                                                                    <?php  /* if(!isset($_REQUEST['action']) || $_REQUEST['action'] != 'view'){ ?>
                                                                 <span id="addproduct" style="display:inline;cursor:pointer;"> <div style="display: inline-block; padding-left: 20px;" class="demo-google-material-icon"> <i class="material-icons">add_circle</i> <span class="icon-name"></span> </div>  </span>
                                                             <?php } */ ?>
                                                                </th>
                                                                <th style="width: 30px;"  >Quantity</th>
                                                                <th style="width: 26px;">Unit</th>
                                                                <th style="width: 30px;">Rate</th>
                                                                <th style="width: 30px;">Amount</th>
                                                                <th style="width: 20px;" >Action</th>
                                                                </thead>
                                                                <tbody>
                                                                <tr>




                                                                    <td data-title="Company">
                                                                        <div class="form-group ">
                                                                            <input type="hidden" name="sunmica[]" >
                                                                            <select data-container="body" name="company_sun[]" class="form-control    company_sun  select2 " id="company_sun[]" style="width:150px">
                                                                                <?php echo  $company_sunopt; ?>
                                                                            </select>
                                                                        </div>
                                                                    </td>
                                                                    <td data-title="Quantity"><div class="form-group input-group">
                                                                            <div class="  ">
                                                                                <input type="number" min="0" name="quant_sun[]" id="quant_sun[]" class="form-control quant_sun" placeholder="Quantity :" value=""  autofocus>
                                                                            </div>
                                                                        </div>
                                                                    </td>

                                                                    <td data-title="Unit"><div class="form-group input-group">
                                                                            <div class="  ">
                                                                                <select  data-container="body" name="unit_sun[]" class="form-control    unit_sun  select2 " id="unit_sun_<?php echo $x; ?>"  >
                                                                                    <option value="">Select unit</option>
                                                                                    <option value="1" >NO</option>
                                                                                    <option value="2" >RF</option>
                                                                                    <option value="3" >PKT</option>
                                                                                    <option value="4" >KG</option>
                                                                                    <option value="5" >SET</option>
                                                                                    <option value="6" >DZN</option>
                                                                                    <option value="7" >GRM</option>
                                                                                </select>
                                                                            </div>
                                                                        </div>
                                                                    </td>


                                                                    <td>
                                                                        <div class="form-group input-group">
                                                                            <div class="  " style="position:relative">
                                                                                <input type="number" min="0"   name="amount_sun[]" id="amount_sun[]" class="form-control amount amount_sun"><span class="refresh_change"><div class="demo-google-material-icon"> <i class="material-icons ">refresh</i> </div></span>
                                                                            </div>
                                                                        </div>
                                                                        <input type="hidden" name="taxid_sun[]" class="taxid">
                                                                        <input type="hidden" name="tax_incl_sun[]"  class="taxincl">
                                                                        <input type="hidden" name="tax_type_sun[]" class="taxtype">
                                                                        <input type="hidden" name="tax_rate_sun[]" class="taxrate">
                                                                        <input type="hidden" name="tax_amount_sun[]" class="taxamount">
                                                                        <input type="hidden" name="final_amount_sun[]" class="finalamount">
                                                                        <!--<span class="amount_show"></span>--></td>
                                                                    <td><input disabled class="form-control finalamount_show_amount disabled_amount" ></td>





                                                                    <td data-title="Action"><i title="Delete Row" class="material-icons delete">delete</i><span class="finalamount_show"></span></td>
                                                                </tr>


                                                                </tbody>
                                                            </table>


                                                        </div>
                                                    </div>

                                                </div>
                                            </div>
                                            <div class="row" style="margin-bottom: 20px;">
                                                <div class="col-md-12">
                                                    <span class="btn btn-primary" id="addproduct" style="display:inline;cursor:pointer;"> <div style="display: inline-block; padding-left: 0;" class="demo-google-material-icon"> <i style="top:6px;" class="material-icons">add_circle</i>&nbsp;Add New Product </div>  </span>
                                                    <span id="addsunmica" style="width:0;margin:0 auto;display: inherit"> <i title="Add New Row "    style="color: #483aea;font-size: 30px !important;"class="material-icons">add_box</i></span>
                                                </div>
                                            </div>
                                        </div>


                                        <div class="row">
                                            <div ></div>



                                            <div class="col-md-12">


                                                <div class="col-md-6 col-sm-6 col-xs-12">
                                                    <div class="form-group input-group">
                                                        <div class="  ">
                                                            <label for="labour"> Labour  </label>
                                                            <input type="number" id="labour" name="labour" class="form-control labour" placeholder="labour charges "  min="0"   value="" autofocus>
                                                        </div>
                                                    </div>
                                                </div>


                                                <div class="col-md-6 col-sm-6 col-xs-12">
                                                    <div class="form-group input-group">
                                                        <div class="  ">
                                                            <label for="freight"> Freight ( भाडा )  </label>
                                                            <input type="number" id="freight" name="freight" class="form-control freight" placeholder="Freight charges "  min="0"   value="" autofocus>
                                                        </div>
                                                    </div>
                                                </div>



                                            </div>

                                        </div>




                                        <!-- order details ends-->





                                        <!-- Tax applied start-->



                                        <div id="tax_applied"></div>


                                        <!-- Tax applied ends-->



                                        <hr>
                                        <div class="row">
                                            <div class="col-md-12">
                                                <label style="display:inline-block;float:right;width:auto  !important;" class="btn bg-default btn-lg btn-block waves-effect" type="button">Total :  <span class="badge" id="totalamount_show">0</span></label><input type="hidden" id="totalamount" name="totalamount">
                                            </div>
                                            <div class="col-md-12">
                                                <label style="text-align:left;" class="btn bg-default btn-lg btn-block waves-effect" type="button">Amount Chargable (in words) :  <span class="badge" id="totalamtinwords_show"></span></label><input type="hidden" name="total_amount_words" id="totalamtinwords">
                                            </div>
                                        </div>


                                        <!-- Tax Detials start -->


                                        <div id="tax_details"></div>


                                        <!-- Tax Details ends -->


                                        <hr>
                                        <div class="row">
                                            <div class="col-md-12">
                            <span style="display:inline-block;float:right;width:auto  !important;" class="btn bg-default btn-lg btn-block waves-effect" type="button">
                                 Total - Taxable value:  <span class="badge" id="taxable_value_show">0</span><input type="hidden" name="taxamount" id="taxamount"><input type="hidden" name="taxable_value" id="taxable_value">
                                         Central Tax:  <span class="badge" id="central_tax_show">0</span></label><input type="hidden" name="central_tax" id="central_tax">
                                         State Tax:  <span class="badge" id="state_tax_show">0</span></label><input type="hidden" name="state_tax" id="state_tax">
                             </span>
                                            </div>
                                            <div class="col-md-12">
                                                <label style="text-align:left;" class="btn bg-default btn-lg btn-block waves-effect" type="button">Tax Amount (in words) :  <span class="badge" id="taxamtinwords_show"></span></label><input type="hidden" name="taxamtinwords" id="taxamtinwords">
                                            </div>
                                        </div>







                                        <div class="row">
                                            <div class="col-md-12">

                                                <div style="padding-top:20px;border-top: 1px solid #00000057 !important;">
                                                    <div class="col-md-6 col-sm-6 col-xs-12">

                                                        <div class="demo-checkbox">
                                                            <input   type="checkbox"  id="pay_now" name="pay_now"  value="1" class="">
                                                            <label class="tdcss" for="pay_now">Pay Now</label>
                                                        </div>



                                                    </div>


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



                                        <div class="row" >
                                            <div class="col-md-12"  >




                                                <div class="col-md-4 col-sm-4 col-xs-12      dontshow  payment_mode">

                                                    <div class="form-group " style="">
                                                        <!-- <div class="form-line "> -->
                                                        <label for="th_payment_mode">Payment Mode : </label>
                                                        <select     name="th_payment_mode" id="th_payment_mode" class="form-control   select2 " autofocus >
                                                            <option value=""> Select </option>
                                                            <option value="1" <?php echo selected('1',$th_payment_mode); ?>>CASH</option>
                                                            <option value="2" <?php echo selected('2',$th_payment_mode); ?>>CHEQUE</option>
                                                            <option value="3" <?php echo selected('3',$th_payment_mode); ?>>CARD</option>
                                                            <option value="4" <?php echo selected('4',$th_payment_mode); ?>>CASH ON BANK</option>
                                                            <option value="5" <?php echo selected('5',$th_payment_mode); ?>>RTGS</option>
                                                            <option value="6" <?php echo selected('6',$th_payment_mode); ?>>NEFT</option>
                                                        </select>
                                                        <label id="th_payment_mode-error" class="error" for="th_payment_mode"></label>

                                                        <!--  </div>-->
                                                    </div>
                                                </div>


                                                <div class="col-md-4 col-sm-4 col-xs-12   dontshow  chequedetails" >
                                                    <div class="form-group input-group">
                                                        <div class=" ">
                                                            <label for="th_details" id="chequedetails_title"> </label>
                                                            <input type="text" name="th_details" id="th_details"   class="form-control" placeholder="" value=""   autofocus>
                                                        </div>
                                                    </div>
                                                </div>

                                                <div class="col-md-4 col-sm-4 col-xs-12   dontshow  pay_amount" >
                                                    <div class="form-group input-group">
                                                        <div class=" ">
                                                            <label for="pay_amount" > Amount Paid</label>
                                                            <input type="number" name="pay_amount" id="pay_amount"   class="form-control" placeholder="Amount Paid " value="" min="0"  autofocus>
                                                        </div>
                                                    </div>
                                                </div>










                                            </div>
                                        </div>




                                    </div>



                                <?php } ?>


                            <?php } ?>



                            <div class="col-md-12">


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


                                    <span class="btn waitbutton dontshow  btn-danger" >Wait </span>


                                    <button     type="button"   id="button2" value="<?php echo $Title; ?>" class="btn btn-primary m-t-15 waves-effect"><?php if($Title == 'Edit'){ echo " Edit & Save ";  }else{  echo $Title; } ?></button>

                                    <input type="hidden" name="button"  value="<?php echo $Title; ?>" >



                                    <a href="index.php"  class="btn btn-primary m-t-15 waves-effect">Cancel </a>
                                <?php  }elseif(!isset($_REQUEST['action']) || $_REQUEST['action'] == 'add'){     ?>

                                    <span class=" btn waitbutton dontshow   btn-danger" >Wait </span>
                                    <span id="challanblock_addbtn" style="<?php if($custstatus == 'Disabled'){ echo "display:none";   } ?>" >

                                              <button     type="button"   id="button2" value="<?php echo $Title; ?>" class="btn btn-primary m-t-15 waves-effect"><?php if($Title == 'Edit'){ echo " Edit & Save ";  }else{  echo $Title; } ?></button>

                                              <input type="hidden" name="button"  value="<?php echo $Title; ?>" >
                                             </span>
                                    <button   id="cancel" class="btn btn-primary m-t-15 waves-effect">Cancel </button>
                                <?php }elseif($_REQUEST['action'] == 'edit'){      ?>

                                    <span class="btn waitbutton dontshow   btn-danger" >Wait </span>


                                    <button     type="button"   id="button2" value="<?php echo $Title; ?>" class="btn btn-primary m-t-15 waves-effect"><?php if($Title == 'Edit'){ echo " Edit & Save ";  }else{  echo $Title; } ?></button>
                                    <input type="hidden" name="button"  value="<?php echo $Title; ?>" >



                                    <button   id="cancel" class="btn btn-primary m-t-15 waves-effect">Cancel </button>
                                <?php  }else{     ?>
                                    <button   id="cancel" class="btn btn-primary m-t-15 waves-effect">Back </button>
                                    <a  style="margin-top:14px;" href="index.php?page=newchallan&action=edit&order_id=<?php echo $_GET['order_id']; ?>" class="btn btn-danger">Edit </a>
                                <?php }?>
                            </div>

                        </form>

                    </div>

                </div>

            </div>




            <div class="panel padding_20 panel-default  listingview  <?php if(isset($_REQUEST['action']) || $_REQUEST['estimate_id']){ echo " hidden ";  }   ?>  ">

                <div class="panel-heading">
                    <div class="panel-title">
                        <div class="row">
                            <div class="col-md-12 col-sm-12 col-xs-12 " >
                                <h4 style="margin-top:7px;margin-bottom: 5px;">Delivery Challan List

                                    <button  class="btn btn-primary m-t-15 waves-effect  pull-right  pull-top" id="showaddform" style="margin-top:-6px;background-color: orange !important;">
                                        Add
                                    </button>


                                </h4>
                            </div>
                        </div>

                    </div>
                </div>







                <form action="" method="post" name="" id="" enctype="multipart/form-data">
                    <div class="panel-body">
                        <div class="row">




                            <?php if(isset($_SESSION['bow']) &&  $_SESSION['bow'] == 2  ){ ?>



                                <div class="col-sm-4 ">

                                    <label>Challan no :</label>

                                    <?php
                                    $option_dep = '';
                                    $qry_dep = select("id,order_pdf", "tbl_challan_entry", " order by challan_number");
                                    while ($row_dep = mysql_fetch_array($qry_dep)) {
                                        $option_dep .= '<option value="' . $row_dep['order_pdf']. '">' . $row_dep['order_pdf'] . '</option>';
                                        // $option_dep .= '<option value="' . $row_dep['project_id'] . '" ' . selected($row_dep['project_id'], $_REQUEST['project_id']) . ' >' . $row_dep['project_name'] . '</option>';
                                    }
                                    ?><select name="challan_number_search" id="challan_number_search" class="form-control select2">
                                        <option value="" > Select </option>
                                        <?php echo $option_dep; ?>
                                    </select>


                                </div>



                                <div class="col-sm-4 ">

                                    <label>Party :</label>

                                    <?php
                                    $option_dep = '';
                                    $qry_dep = select("cust_id,cust_name", "tbl_customer", " order by cust_name");
                                    while ($row_dep = mysql_fetch_array($qry_dep)) {


                                        if(isset($_REQUEST['cust_id'])){

                                            $option_dep .= '<option value="' . $row_dep['cust_id']. '"  '.selected($_REQUEST['cust_id'],$row_dep['cust_id']).'  >' . $row_dep['cust_name'] . '</option>';


                                        }else{
                                            $option_dep .= '<option value="' . $row_dep['cust_id']. '">' . $row_dep['cust_name'] . '</option>';


                                        }

                                        // $option_dep .= '<option value="' . $row_dep['project_id'] . '" ' . selected($row_dep['project_id'], $_REQUEST['project_id']) . ' >' . $row_dep['project_name'] . '</option>';
                                    }
                                    ?><select name="cust_name_search" id="cust_name_search" class="form-control select2">
                                        <option value="" > Select </option>
                                        <?php echo $option_dep; ?>
                                    </select>


                                </div>



                            <?php }else{  ?>



                                <div class="col-sm-4 ">

                                    <label>Challan no :</label>

                                    <?php
                                    $option_dep = '';
                                    $qry_dep = select("id,order_pdf", "tbl_challan_entry te", "   join  tbl_customer tc ON tc.cust_id  = te.customerid where tc.bow = '1'   order by challan_number");
                                    while ($row_dep = mysql_fetch_array($qry_dep)) {
                                        $option_dep .= '<option value="' . $row_dep['order_pdf']. '">' . $row_dep['order_pdf'] . '</option>';
                                        // $option_dep .= '<option value="' . $row_dep['project_id'] . '" ' . selected($row_dep['project_id'], $_REQUEST['project_id']) . ' >' . $row_dep['project_name'] . '</option>';
                                    }
                                    ?><select name="challan_number_search" id="challan_number_search" class="form-control select2">
                                        <option value="" > Select </option>
                                        <?php echo $option_dep; ?>
                                    </select>


                                </div>



                                <div class="col-sm-4 ">

                                    <label>Party :</label>

                                    <?php
                                    $option_dep = '';
                                    $qry_dep = select("cust_id,cust_name", "tbl_customer", "  where bow = '1'  order by cust_name");
                                    while ($row_dep = mysql_fetch_array($qry_dep)) {


                                        if(isset($_REQUEST['cust_id'])){

                                            $option_dep .= '<option value="' . $row_dep['cust_id']. '"  '.selected($_REQUEST['cust_id'],$row_dep['cust_id']).'  >' . $row_dep['cust_name'] . '</option>';


                                        }else{
                                            $option_dep .= '<option value="' . $row_dep['cust_id']. '">' . $row_dep['cust_name'] . '</option>';


                                        }

                                        // $option_dep .= '<option value="' . $row_dep['project_id'] . '" ' . selected($row_dep['project_id'], $_REQUEST['project_id']) . ' >' . $row_dep['project_name'] . '</option>';
                                    }
                                    ?><select name="cust_name_search" id="cust_name_search" class="form-control select2">
                                        <option value="" > Select </option>
                                        <?php echo $option_dep; ?>
                                    </select>


                                </div>


                            <?php   }   ?>

                            <span class="bowUserType <?php if(!isset($_SESSION['bow']) ||  $_SESSION['bow'] != 2  ){  echo ' dontShow ';   }   ?>" >
                                  <?php if(isset($_SESSION['bow']) &&  $_SESSION['bow'] == 2  ){ ?>
                                      <div class="col-md-4">
                                             <div class="form-group input-group">
                                                    <label for="bow_search">User  Type Search :</label>
                                                    <select id='bow_search'  name="bow_search" class="form-control">
                                                        <option  value="0"  >All Users</option>
                                                        <option  value="1" <?php echo selected('1', $_REQUEST['bow']); ?>  >Type One </option>
                                                        <option  value="2" <?php echo selected('2', $_REQUEST['bow']); ?>  >Type Two</option>
                                                    </select>
                                                </div>
                                        </div>

                                  <?php  }else{ ?>

                                      <div class="col-md-4">
                                             <div class="form-group input-group">
                                                    <label for="bow_search">User  Type Search :</label>
                                                    <select id='bow_search'  name="bow_search" class="form-control">
                                                        <option  value="1"   >Type One </option>
                                                    </select>
                                                </div>
                                        </div>

                                  <?php  } ?>
                               </span>









                        </div>



                    </div>


                    <div class="clearfix"></div>
                    <div class="col-md-12"> <input type="hidden"  name="project_name_get"  id="project_name_get"    value="<?php echo $_GET['project_id']; ?>"   />
                        <!--<input  type="submit" style="visibility:hidden;" class="btn btn-primary pull-right margin" name="search_item" id="search_item" value="Search" />-->
                        <input type="hidden"  name="type"  id="type"  value="<?php echo $_GET['type']; ?>"   />
                        <input type="button"  name="searchbut" id="searchbut" class="btn btn-blue " value="Search" >
                        <input type="reset" name="reset" id="reset" class="btn btn-warning" value="Reset Search"  style="margin-left:10px;" />
                        <label id="loader"><div style="margin-left:20px;" class="preloader pl-size-xs">
                                <div class="spinner-layer pl-red-grey">
                                    <div class="circle-clipper left">
                                        <div class="circle"></div>
                                    </div>
                                    <div class="circle-clipper right">
                                        <div class="circle"></div>
                                    </div>
                                </div>
                            </div></label>    </div>
                </form>

                <div class="row">
                    <div class="col-md-12">

                    </div>
                </div>



            </div>
        </div>







        <div class="panel panel-default listingview  <?php if(isset($_REQUEST['action']) || isset($_REQUEST['estimate_id']) ){ echo " hidden ";  }   ?>">
            <div class="panel-body">
                <!--<div class="row" style="margin-bottom:20px;">
                    <div class="col-md-12">
                        <a target="_blank" id="excellink" href="challan_report.php" class="btn btn-warning pull-right">Print Report</a>
                    </div>
                </div> -->

                <!--scroller-->
                <div class="box-body table-responsive">
                    <div id="table_div">

                        <!--scroller-->
                        <table width="100%">
                            <tr>
                                <td>
                                    <select name="dataTables-example_length" id="orderByCombo" aria-controls="dataTables-example" class="form-control input-sm" style="width:150px;">
                                        <option value="1">By Record Id in DESC</option>
                                        <option value="2">By Record Id in  ASC</option>
                                        <option value="3">By Challan Number in ASC</option>
                                        <option value="4">By Challan Number in DESC</option>
                                    </select>
                                </td>
                                <td align="right">
                                    <?php include 'Auth_user/paging_common/pagging_panel_header.php'; ?>
                                </td>
                            </tr>
                        </table>

                        <!---scroller-->
                        <br/>

                        <div class="accordion-inner">
                            <!--scroller-->
                            <table id="userList" class="table table-bordered table-hover table-small-font">
                                <tr>
                                    <th>S.No</th>
                                    <th>Challan</th>
                                    <th>Party </th>
                                    <th>Items </th>
                                    <th>Total Amount </th>
                                    <th>Order Date </th>
                                    <th style="text-align:center;">Action</th>
                                </tr>
                            </table>




                            <?php include 'Auth_user/paging_common/pagging_panel_footer.php'; ?>
                            <!-- scroller -->
                        </div>
                    </div>
                </div>
                <!--scroller-->

            </div>

            <div style="clear:both;"></div>

        </div>


        <div id="modal" class="modal fade" role="dialog">
            <div class="modal-dialog">

                <!-- Modal content-->
                <div class="modal-content">
                    <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal">&times;</button>
                        <h4 class="modal-title" id="modaltitle"> </h4>
                    </div>
                    <div class="modal-body" id="modalbody">

                    </div>
                </div>

            </div>
        </div>

        <script type="text/javascript" src="Auth_user/paging_js/challanList.js?v=1"></script>
        <script type="text/javascript" src="Auth_user/paging_common/pagging_searching.js"></script>

        <script src="js/session.js"></script>

        <script>

            $('body').keydown(function(event){
                if(event.keyCode == 13) {
                    event.preventDefault();


                    if($("#addproductbutton").is(":visible")){
                        $('#addproductbutton').trigger('click');
                    }

                    if($("#searchbut").is(":visible")){
                        $("#searchbut").trigger('click');
                    }

                }
            });




            $(document).ready(function(){




                $('body').on('change','#pay_now',function(){
                    if($(this).is(':checked')){

                        $('.payment_mode').removeClass('dontshow');
                        $('.pay_amount').removeClass('dontshow');



                        var  mode = $("#th_payment_mode option:selected").val();

                        if(mode.length != 0  && (mode == 2 || mode == 5)){

                            if(mode == 2){
                                $('#chequedetails_title').html('CHEQUE Details : ');
                                $("#th_details").attr("placeholder", "Enter cheque details");
                            }else{
                                $('#chequedetails_title').html('RTGS Details : ');
                                $("#th_details").attr("placeholder", "Enter RTGS details");
                            }

                            $('.chequedetails').removeClass('dontshow');
                            $("#th_details").prop('required',true);


                        }


                        $("#th_payment_mode").prop('required',true);
                        $('#pay_amount').prop('required',true);
                    }else{
                        $('.pay_amount').addClass('dontshow');
                        $('.payment_mode').addClass('dontshow');
                        $('.chequedetails').addClass('dontshow');

                        $("#th_payment_mode").prop('required',false);
                        $("#th_details").prop('required',false);
                        $('#pay_amount').prop('required',false);
                    }


                });



                $('body').on('change','#th_payment_mode',function(){
                    var mode  = $('option:selected',this).val();





                    var paymentmode  =  $('option:selected',this).val();
                    if(paymentmode == ''){
                        formerror = 1;
                        var errormsg = "select payment mode";
                        if($(this).parent().children('label.error').length == 0){

                            $(this).parent().append('<label class="error">'+errormsg+'</label>');

                        }else{
                            $(this).parent().children('label.error').html(errormsg);
                        }


                    }else{
                        $(this).parent().children('label.error').html('');

                    }













                    if(mode.length != 0  && (mode == 2 || mode == 5)){



                        if(mode == 2){
                            $('#chequedetails_title').html('CHEQUE Details : ');
                            $("#th_details").attr("placeholder", "Enter cheque details");
                        }else{
                            $('#chequedetails_title').html('RTGS Details : ');
                            $("#th_details").attr("placeholder", "Enter RTGS details");
                        }




                        $('.chequedetails').removeClass('dontshow');
                        $("#th_details").prop('required',true);
                    }else{
                        $('.chequedetails').addClass('dontshow');
                        $("#th_details").prop('required',false);
                    }
                });


                $('#th_details').on('keyup',function(){
                    var thdetail =  $(this).val();

                    if(thdetail.length == 0){
                        formerror = 1;
                        var errormsg = "enter payment details";
                        if($(this).parent().children('label.error').length == 0){

                            $(this).parent().append('<label class="error" style="display:block;">'+errormsg+'</label>');

                        }else{
                            $(this).parent().children('label.error').html(errormsg);
                        }

                    }else{
                        $(this).parent().children('label.error').html('');

                    }



                });


                $('#supervisor_number').on('keyup',function(){
                    $('.supervisor_number_error').html('');
                    validateform();
                });

                $('#pay_amount').on('keyup',function(){

                    var pay_amount = $(this).val();
                    if(pay_amount.length == 0){
                        formerror = 1;
                        var errormsg = "enter payment Amount";
                        if($(this).parent().children('label.error').length == 0){

                            $(this).parent().append('<label class="error" style="display:block;">'+errormsg+'</label>');

                        }else{
                            $(this).parent().children('label.error').html(errormsg);
                        }

                    }else{
                        $(this).parent().children('label.error').html('');

                    }



                })














                $('body').on('change','#challan_number_search',function(){

                    $('#searchbut').trigger('click');

                });

                $('body').on('change','#cust_name_search',function(){
                    $('#searchbut').trigger('click');
                });

                $('body').on('change', '#bow_search', function () {
                    $('#searchbut').trigger('click');
                });









                $('#searchbut').on('click',function(){
                    searchList();
                });




                $('#reset').on('click',function(){

                    $('#freeText').val('');

                    $('#bow_search option:selected').removeAttr('selected');


                    $('#challan_number_search').val('');
                    $('#challan_number_search').select2('destroy');
                    $('#challan_number_search').select2();


                    $('#cust_name_search').val('');
                    $('#cust_name_search').select2('destroy');
                    $('#cust_name_search').select2();



                    $('#orderByCombo').val(1);
                    //$('#cust_name_search').select2('destroy');
                    //$('#cust_name_search').select2();









                    searchList();

                });




                $('#cancel').on('click', function (e) {
                    e.preventDefault();
                    window.location.href = 'index.php?page=<?php echo $curpage; ?>';
                });


            });



        </script>



        <script type="text/javascript">
            editid = 0;
            <?php if(isset($_REQUEST['action']) && ($_REQUEST['action'] == 'edit')){ ?>
            editid = '<?php echo $_REQUEST['order_id']; ?>';
            <?php } ?>


            suncount = '<?php echo $suncount; ?>';

            boardcount = '<?php echo $boardcount; ?>';
            vencount = '<?php echo $vencount; ?>';







            $(document).ready(function (){





































                var challanid = 0;

                $('.addpayment').on('click',function(){
                    challanid = 0;
                    var id = $(this).attr('id');
                    challanid = $(this).attr('id');

                    $.ajax({
                        type: "POST",
                        url: "ajax/get_product_payments.php",
                        data:{id:id},
                        success: function (html)
                        {
                            if(html){


                                var filterdata = $.parseJSON(html);

                                var total_amount =   filterdata.total_amount;
                                var total_amount_paid =   filterdata.total_amount_paid;
                                var total_remaining =   filterdata.total_remaining;
                                var payments = filterdata.payments;


                                var htdata = '<div class="text-center"><b>Total amount  : </b>'+total_amount +'<br/>';
                                htdata += '<b>Total paid amount  : </b>'+total_amount_paid +'<br/>';
                                htdata += '<b>Total remaining amount  : </b>'+total_remaining +'<br/></div><br><br>';


                                htdata += '' +
                                    ' <div class="col-md-12 col-sm-12 col-xs-12"> ' +
                                    '<div class="form-group input-group">' +
                                    '<div class="  "> ' +
                                    '<label for="order_date">Amount </label>' +
                                    ' <input type="text" id="modal_name" name="modal_name" class="form-control modal_name" pattern="[0-9]" value="" placeholder="Enter Amount" autofocus>' +
                                    '</div>' +
                                    '<label id="error_modal_name" class="error" for="modal_name" style="display:none;">please enter name</label>' +
                                    '</div>' +
                                    '</div>' +



                                    ' <div class="col-md-12 col-sm-12 col-xs-12"> ' +
                                    '<div class="form-group input-group">' +
                                    '<div class="  "> ' +
                                    '<label for="order_date">Date. </label>' +
                                    ' <input type="text" id="modal_contact" name="modal_contact" class="form-control modal_contact mydate" value="" placeholder="Enter payment date " autofocus>' +
                                    '</div>' +
                                    '<label id="error_modal_contact" class="error" for="modal_contact" style="display:none;">please enter payment date</label>' +
                                    '</div>' +
                                    '</div>' +




                                    '<div style="clear:both;"></div>'+
                                    '<button id="addpaymentbutton" style="display:block;margin:0 auto;"> Submit </button>'+
                                    '<div style="clear:both;"></div>';



                                htdata += '<h3 class="text-center"> payment history </h3>';


                                htdata +='<table class="table table-condensed"><thead><tr><th>Date</th><th>Amount</th></tr></thead><tbody>';
                                for(var i=0; i< payments.length ; i++ ){
                                    htdata += '<tr><td>'+ payments[i].date +'</td><td>'+ payments[i].amount +'</td></tr>';
                                }


                                if(i == 0){
                                    htdata += '<tr><td colspan="2" class="text-center"> No Payments Received !</td></tr>'
                                }
                                htdata += '</tbody></table>';

                                $('#modaltitle').html("Add Payment ");
                                $('#modalbody').html(htdata);


                                $('#modal').modal('show');



                                $('#modal_contact').bootstrapMaterialDatePicker({
                                    format: 'DD-MM-YYYY',
                                    clearButton: true,
                                    weekStart: 1,
                                    autoclose: true,
                                    time: false
                                }).on('dateSelected', function(e, date)
                                {
                                    $('.dtp-btn-ok.btn.btn-flat').trigger('click');
                                });


                            }



                        }
                    });


                });








                $('body').on('click','#addpaymentbutton',function(){
                    var modal_name    = $('#modal_name').val();
                    var modal_contact = $('#modal_contact').val();
                    var error = 0;
                    if(modal_name.length == 0){
                        $('#error_modal_name').css('display','block');
                        error = 1;
                    }

                    if(modal_contact.length == 0){
                        $('#error_modal_contact').css('display','block');
                        error = 1;
                    }


                    if(error == 0){
                        $.ajax({
                            type: "POST",
                            url: "ajax/save_payment.php",
                            data:{'amount':modal_name,'date':modal_contact,'challanid':challanid},
                            success: function (html)
                            {
                                if(html == "success"){
                                    $('#material_'+challanid).addClass('green');
                                }
                                $('#modal').modal('hide');
                            }
                        });
                    }




                });















                $('#addproduct').on('click',function(){




                    var modalbody = '' +
                        ' <div class="col-md-12 col-sm-12 col-xs-12"> ' +
                        '<div class="form-group input-group">' +
                        '<div class=" "> ' +
                        '<label for="order_date">Product Name </label>' +
                        ' <input type="text" id="modal_name" name="modal_name" class="form-control modal_name" value="" placeholder="Enter product name" autofocus>' +
                        '</div>' +
                        '<label id="error_modal_name" class="error" for="modal_name" style="display:none;">please enter name</label>' +
                        '</div>' +
                        '</div>' +
                        ''+
                        '<button id="addproductbutton" style="display:block;margin:0 auto;" class=" btn btn-info ok"> Submit </button>'+
                        '<div style="clear:both;"></div>';

                    $('#modaltitle').html("Add Product ");
                    $('#modalbody').html(modalbody);

                    $('#modal').modal('show');

                });


                $('body').on('click','#addproductbutton',function(){
                    var thisbutton = $(this);
                    var modal_name    = $('#modal_name').val();


                    var error = 0;
                    if(modal_name.length == 0){
                        $('#error_modal_name').css('display','block');
                        error = 1;
                    }




                    if(error == 0){
                        if(thisbutton.hasClass('ok')) {
                            thisbutton.removeClass('ok');
                            thisbutton.html('Wait....');

                            $.ajax({
                                type: "POST",
                                url: "ajax/add_product.php",
                                data:{product_name:modal_name},
                                success: function (html)
                                {

                                    // alert(html);
                                    if(html){
                                        company_sunopt += html;
                                        $(".company_sun").append(html);
                                        //  $(".company_sun").trigger('change');



                                    }

                                    $('#modal').modal('hide');
                                    thisbutton.addClass('ok');
                                    thisbutton.html('Submit');

                                }
                            });

                        }



                    }




                });






                $('#addcustomer').on('click',function(){

                    dontsShow = "<?php if(!isset($_SESSION['bow']) ||  $_SESSION['bow'] != 2){ echo ' dontShow '; }?>";

                    var modalbody = '' +
                        ' <div class="col-md-12 col-sm-12 col-xs-12"> ' +

                        '<div style="margin-bottom: 25px;" class="bowUserType  '+dontsShow+' ">'+
                        '<div class="row">'+
                        '<div class="col-md-12">'+
                        '<div class="col-md-12">'+
                        '<div class="form-inline" style="padding-top: 10px; padding-bottom: 10px;">'+
                        '<div class="form-group " style="margin-bottom: 0;">'+
                        '<label for="bow">User Type  :</label>'+
                         <?php if($_SESSION['bow']){ ?>
                        '<select id="bow"   name="bow" class="form-control " style="width: 200px;display: inline-block;margin-left: 10px;" >'+
                        '<option  value=""  >Select</option>'+
                        '<option  value="1"  >Type One </option>'+
                        '<option  value="2"  >Type Two</option>'+
                        '</select>'+
                        <?php }else{ ?>
                        '<select id="bow"   name="bow" class="form-control " style="width: 200px;display: inline-block;margin-left: 10px;" >'+
                        '<option  value="1"  >Type One </option>'+
                        '</select>'+
                        <?php }?>


                        '</div>'+
                        '<label id="error_modal_bow"  class="error" for="bow" style="color: red;display: none;font-weight: 100;font-size: 12px;margin-top: 12px; ">please Select User Type</label>' +



                        '</div>'+
                        '</div> '+
                        '</div>'+
                        '</div>'+
                        '</div>'+
                        '</div>'+








                        ' <div class="col-md-12 col-sm-12 col-xs-12"> ' +
                        '<div class="form-group input-group">' +
                        '<div class="  "> ' +
                        '<label for="order_date">Customer Name </label>' +
                        ' <input type="text" id="modal_name" name="modal_name" class="form-control modal_name" value="" placeholder="Enter customer name" autofocus>' +
                        '</div>' +
                        '<label id="error_modal_name" class="error" for="modal_name" style="display:none;">please enter name</label>' +

                        '</div>' +
                        '</div>' +
                        ' <div class="col-md-12 col-sm-12 col-xs-12"> ' +
                        '<div class="form-group input-group">' +
                        '<div class="   "> ' +
                        '<label for="order_date">Contact No. </label>' +
                        ' <input type="number" min="0"  id="modal_contact" name="modal_contact" class="form-control modal_contact" value="" placeholder="Enter contact number " autofocus>' +
                        '</div>' +
                        '<label id="error_modal_contact" class="error" for="modal_contact" style="display:none;">please enter contact number</label>' +
                        '</div>' +
                        '</div>' +



                        '</div>' +
                        '</div>' +
                        '<div class="col-md-12 col-sm-12 col-xs-12"> ' +
                        '<div class="form-group input-group">' +
                        '<div class=" "> ' +
                        '<label for="order_date">GST NO. </label>' +
                        '<input type="text" id="gst_number" name="gst_number" class="form-control gst_number" value="" placeholder="Enter GST no. " autofocus>' +
                        '</div>' +
                        '<label id="error_gst_number" class="error" for="gst_number" style="display:none;">please enter GST number</label>' +
                        '</div>' +
                        '</div>' +




                        ' <div class="col-md-12 col-sm-12 col-xs-12"> ' +
                        '<div class="form-group input-group">' +
                        '<div class="  "> ' +
                        '<label for="order_date">Email </label>' +
                        ' <input type="text" id="modal_email" name="modal_email" class="form-control modal_email" value="" placeholder="Enter email " autofocus>' +
                        '</div>' +
                        '<label id="error_modal_email" class="error" for="modal_email" style="display:none;">please enter email </label>' +
                        '</div>' +
                        '</div>' +




                        ' <div class="col-md-12 col-sm-12 col-xs-12"> ' +
                        '<div class="form-group input-group">' +
                        '<div class=" "> ' +
                        '<label for="order_date">Address </label>' +

                        '<textarea id="modal_address" name="modal_address" class="form-control"  placeholder="Enter address " ></textarea>'+

                        '</div>' +
                        '<label id="error_modal_address" class="error" for="modal_address" style="display:none;">please enter address </label>' +
                        '</div>' +
                        '</div>' +





                        '<div class=" col-md-12 col-sm-12 col-xs-12">'+
                        '<div class="form-group input-group">'+
                        '<input type="checkbox" id="setlimit" name="setlimit"    value="set">'+
                        '<label for="setlimit" style="margin-right: 10px;">Set Limit</label>'+
                        '<input type="checkbox" id="nolimit" name="setlimit"   value="no">'+
                        '<label for="nolimit">No Limit</label>'+
                        '</div>'+
                        '</div>'+



                        '<div class=" col-md-12 col-sm-12 col-xs-12" id="limitdiv"  style="display:none;" >'+
                        '<div class="form-group input-group">'+
                        '<div class=" ">'+
                        '<label for="set_limit">Set Limit In Days :</label>'+
                        '<input type="number" name="set_limit" id="set_limit" value="" class="form-control" placeholder=""   autofocus="" aria-required="true" aria-invalid="false">'+
                        '<label id="set_limit-error" class="error" for="set_limit"></label>'+
                        '</div>'+
                        '</div>'+
                        '</div>'+






                        '<div class="row">'+
                        '<div class="col-md-12">'+
                        '<div class=" col-md-6 col-sm-6 col-xs-12" >'+
                        '<div class="form-group input-group">'+
                        '<div class="">'+
                        '<label for="opening_balance">Opening Balance :</label>'+
                        '<input type="number" name="opening_balance" id="opening_balance" value="" class="form-control" placeholder=""   autofocus="" aria-required="true" aria-invalid="false">'+
                        '<label id="opening_balance-error" class="error" for="opening_balance"></label>'+
                        '</div>'+
                        '</div>'+
                        '</div>'+

                        '<div class=" col-md-6 col-sm-6 col-xs-12" >'+
                        '<div class="form-group input-group">'+
                        '<div class=" ">'+
                        '<label for="opening_balance_date">Opening Balance Date:</label>'+
                        '<input type="text" name="opening_balance_date" id="opening_balance_date" value="30-12-2017" class="form-control mydate" placeholder=""   autofocus="" aria-required="true" aria-invalid="false">'+
                        '<label id="opening_balance_date-error" class="error" for="opening_balance_date"></label>'+
                        '</div>'+
                        '</div>'+
                        '</div>'+
                        '</div>'+
                        '</div>'+








                        '<div class="col-md-12">'+
                        '<b>Add New Reference </b><span title="Add New Reference " id="addreference" style="display:inline;cursor:pointer;"> <div style="display: inline-block; padding-left: 20px;" class="demo-google-material-icon"> <i  style="color:#483aea;" class="material-icons">add_circle</i> <span class="icon-name"></span> </div>  </span>' +
                        '</div>'+

                        '<div class="col-md-12 col-sm-12 col-xs-12    refrence_div   dontshow"> ' +

                        '<div style="border:1px solid #6e00ff4d;">'+


                        '<div class="col-md-8 col-sm-8 col-xs-8">'+


                        '<div class="form-group input-group">' +
                        '<div class="  "> ' +
                        '<label for="modal_reference_name">Reference Name </label>' +
                        ' <input type="text" id="modal_reference_name" name="modal_reference_name" class="form-control " value="" placeholder="Enter reference name" autofocus>' +
                        '</div>' +
                        '<label id="error_modal_reference_name" class="error" for="modal_reference_name" style="display:none;">please enter reference name</label>' +
                        '</div>' +
                        '</div>' +




                        '<div class="col-md-4 col-sm-4 col-xs-4">'+

                        '<span>'+
                        '<button class="btn btn-info  ok" id="addreferencebutton">Add</button>'+
                        '</span>'+

                        '<span>'+
                        '<button class="btn btn-info"  style="display: inline-block; margin-left: 10px;" id="closerefrence">Cancel</button>'+
                        '</span>'+



                        '</div>'+

                        '<div style="clear:both;"></div>'+
                        '</div>'+



                        '</div>'+








                        '<div class="col-md-12">'+
                        '<div class="form-group input-group">'+
                        '<label for="refrence_one" >Reference One :</label>'+
                        '<select name="refrence_one" id="refrence_one" class="form-control reference_name select2">'+
                        reference_sunopt+
                        '</select>'+
                        '</div>'+
                        '</div>'+


                        '<div style="height:20px;"></div>'+
                        '<div class="col-md-12">'+
                        '<div class="form-group input-group">'+
                        '<label for="refrence_two" >Reference Two :</label>'+
                        '<select name="refrence_two" id="refrence_two" class="form-control reference_name select2">'+
                        reference_sunopt+
                        '</select>'+
                        '</div>'+
                        '</div>'+
                        ''+
                        '<button id="addcustomerbutton" style="display:block;margin:0 auto;" class="btn btn-info ok"> Submit </button>'+
                        '<div style="clear:both;"></div>';

                    $('#modaltitle').html("Add Customer");
                    $('#modalbody').html(modalbody);

                    $('#modal').modal('show');
                    $('.select2').select2();

                    $('.mydate').bootstrapMaterialDatePicker({
                        format: 'DD-MM-YYYY',
                        clearButton: true,
                        weekStart: 1,
                        time: false
                    }).on('dateSelected', function(e, date)
                    {
                        $('.dtp-btn-ok.btn.btn-flat').trigger('click');
                    });






                });

                $('body').on('change','#setlimit',function(){
                    if($(this).is(':checked')){
                        $('#nolimit').attr('checked',false);
                        $('#limitdiv').css('display','block');
                        $("#set_limit").prop('required',true);
                    }else{
                        $('#limitdiv').css('display','none');
                        $("#set_limit").prop('required',false);
                    }
                });

                $('body').on('change','#nolimit',function(){
                    $('#setlimit').attr('checked',false);
                    $('#limitdiv').css('display','none');
                    $("#set_limit").prop('required',false);
                    if($(this).is(':checked')){

                    }
                });







                $('body').on('change','.reference_name',function(e){
                    e.stopPropagation();



                    var referencethis =  $("option:selected", this).val();

                    var exist = 0;
                    $('select.reference_name').each(function(){
                        var reference =  $("option:selected", this).val();
                        if(reference == referencethis){
                            exist++;
                            if(exist == 2){
                                $(this).val('');
                                $(this).select2('destroy');
                                $(this).select2();
                                warning("Info :","Reference already Selected !");
                                return false;
                            }
                        }

                    });


                    //  checkselected($(this));
                });




                $('body').on('click','#addreferencebutton',function(e){
                    e.preventDefault();
                    var thisbutton = $(this);
                    var modal_reference_name    = $('#modal_reference_name').val();


                    var error = 0;
                    if(modal_reference_name.length == 0){
                        $('#error_modal_reference_name').css('display','block');
                        error = 1;
                    }



                    if(error == 0){
                        if(thisbutton.hasClass('ok')) {
                            thisbutton.removeClass('ok');
                            thisbutton.html('Wait....');

                            $.ajax({
                                type: "POST",
                                url: "ajax/add_reference.php",
                                data:{ref_name:modal_reference_name},
                                success: function (html)
                                {
                                    if(html){

                                        reference_sunopt += html;

                                        $(".reference_name").append(html);
                                        // $(".reference_name").trigger('change');



                                    }

                                    $('#modal_reference_name').val('');
                                    thisbutton.addClass('ok');
                                    thisbutton.html('Add');
                                    $('.refrence_div').addClass('dontshow');


                                }
                            });

                        }



                    }




                });










                $('body').on('click','#addreference',function(e){
                    e.preventDefault();
                    $('.refrence_div').removeClass('dontshow');
                });

                $('body').on('click','#closerefrence',function(e){
                    e.preventDefault();
                    $('#modal_reference_name').val('');
                    $('.refrence_div').addClass('dontshow');
                });





                $('body').on('keyup','#modal_name',function(){
                    $('#error_modal_name').css('display','none');
                });

                $('body').on('change','#bow',function(){
                    $('#error_modal_bow').css('display','none');
                });

                $('body').on('keyup','#modal_contact',function(){
                    $('#error_modal_contact').css('display','none');
                });

                $('body').on('change','#modal_contact',function(){
                    $('#error_modal_contact').css('display','none');
                });

                $('body').on('change','#gst_number',function(){
                    $('#error_gst_number').css('display','none');
                });


                $('body').on('keyup','#modal_email',function(){
                    // $('#error_modal_email').css('display','none');
                });

                $('body').on('keyup','#modal_address',function(){
                    $('#error_modal_address').css('display','none');
                });


                $('body').on('click','#addcustomerbutton',function(){
                    var thisbutton = $(this);



                    var opening_balance  = $('#opening_balance').val();
                    var opening_balance_date  = $('#opening_balance_date').val();


                    var set_limit = 0;
                    if($('#setlimit').is(':checked')){
                        set_limit =  $('#set_limit').val();
                    }

                    var nolimit = 0;
                    if($('#nolimit').is(':checked')){
                        nolimit = 1;
                    }


                    var bow = $('#bow').val();

                    if(bow.length == 0){
                        $('#error_modal_bow').css('display','block');
                        error = 1;
                    }


                    var refrence_one = $('#refrence_one :selected').val();
                    if(refrence_one.length == 0){
                        refrence_one = 0;
                    }

                    var refrence_two = $('#refrence_two :selected').val();
                    if(refrence_two.length == 0){
                        refrence_two = 0;
                    }


                    var modal_name    = $('#modal_name').val();
                    var modal_contact = $('#modal_contact').val();
                    var gst_number    = $('#gst_number').val();


                    var modal_email   = $('#modal_email').val();
                    var modal_address = $('#modal_address').val();
                    var error = 0;
                    if(modal_name.length == 0){
                        $('#error_modal_name').css('display','block');
                        error = 1;
                    }

                    if(modal_contact.length == 0){
                        $('#error_modal_contact').css('display','block');
                        error = 1;
                    }

                    /*  if(gst_number.length == 0){
                     $('#error_gst_number').css('display','block');
                     error = 1;
                     } */
                    /* if(modal_email.length == 0){
                     $('#error_modal_email').css('display','block');
                     error = 1;
                     } */
                    if(modal_address.length == 0){
                        $('#error_modal_address').css('display','block');
                        error = 1;
                    }


                    if(error == 0){




                        if(thisbutton.hasClass('ok')) {
                            thisbutton.removeClass('ok');
                            thisbutton.html('Wait....');



                            $.ajax({
                                type: "POST",
                                url: "ajax/add_customer.php",
                                data:{bow:bow,cust_name:modal_name,cust_cont:modal_contact,cust_email:modal_email,cust_addr:modal_address,gst_number:gst_number,refrence_one:refrence_one,refrence_two:refrence_two,set_limit:set_limit,nolimit:nolimit,opening_balance:opening_balance,opening_balance_date:opening_balance_date},
                                success: function (html)
                                {


                                    console.log(html);
                                    if(html) {

                                        if (html != "error") {


                                            $("#customer").select2("destroy");
                                            $("#customer").html(html);
                                            $("#customer").select2();
                                            $("#customer").trigger('change');
                                        }


                                        $('#modal').modal('hide');
                                        thisbutton.addClass('ok');
                                        thisbutton.html('Submit');

                                        if (html == "error") {


                                            swal({
                                                title: "unable to add Customer",
                                                text: "Party Name already exist",
                                                type: "warning"
                                            });

                                        }
                                    }
                                }

                            });

                        }







                    }




                });





                /* var countries = {
                 "AD": "Andorra",
                 "A2": "Andorra Test",
                 "AE": "United Arab Emirates",
                 "AF": "Afghanistan",
                 "AG": "Antigua and Barbuda",
                 "AI": "Anguilla",
                 "AL": "Albania",
                 "AM": "Armenia",
                 "AN": "Netherlands Antilles"
                 } */



                /*  var countriesArray = $.map(countries, function (value, key) { return { value: value, data: key }; });
                 $('.company_sun').autocomplete({
                 lookup: countriesArray
                 }); */




                $('body').on('change','.products',function(){

                    var thisobj =  $(this);


                    var goods_id =  $('option:selected',this).val();
                    $.ajax({
                        type: "POST",
                        url: "ajax/products.php?get_goods_options=true",
                        data: {goods_id:goods_id},
                        success: function (data)
                        {
                            var tableheads = [];
                            var hide_heads = [1,2,3,4,5,6];
                            if(data.length != 0){
                                tableheads =  data.split(",");
                                var i;
                                for (i = 0; i < tableheads.length; ++i){
                                    //product_head_
                                    if(tableheads[i].length != 0){

                                        console.log('show '+tableheads[i]);
                                        thisobj.parent().parent().parent().parent().siblings('thead').children('tr').children('th.product_head_'+tableheads[i]).css('display','table-cell');
                                        hide_heads.splice( $.inArray(tableheads[i], hide_heads),1);
                                    }
                                }
                            }

                            console.log(tableheads);



                            /*for (i = 0; i < hide_heads.length; ++i){
                             if(hide_heads[i].length != 0){
                             console.log('hide '+hide_heads[i]);
                             thisobj.parent().parent().parent().parent().siblings('thead').children('tr').children('th.product_head_'+hide_heads[i]).css('display','none');
                             }
                             } */





                        }
                    });
                });







                $('.select2').select2();
                $('body').on('click','.cancel',function(e){

                    var orderid = $(this).attr('id').split("_")[1];


                    e.preventDefault();
                    swal({
                        title: "",
                        text: "Cancel Delivery Challan  ?",
                        type: "warning",
                        showCancelButton: true,
                        confirmButtonColor: "#DD6B55",
                        confirmButtonText: "Yes !",
                        closeOnConfirm: false
                    }, function () {
                        window.location = "index.php?page=<?php echo $self; ?>&cancel=true&order_id="+orderid;
                    });

                });


                show = 1;


                /* $('#button2').on('click',function(){
                 $(this).css('display','none');
                 $('.waitbutton').removeClass('dontshow');
                 add_button_seconds();
                 });
                 number = 15;
                 myVar = "";
                 function add_button_seconds(){
                 myVar = setInterval(function(){
                 myTimer();
                 }, 1000);
                 }

                 function myTimer() {

                 number--;
                 if(number > 0){
                 $('.waitbutton').html("Wait:"+number);
                 }else{


                 if(show == 1){
                 $('#button2').css('display','inline-block');
                 }
                 $('.waitbutton').addClass('dontshow');
                 myStopFunction();
                 }
                 } */


                /* function myStopFunction() {
                 number = 15;
                 clearInterval(myVar);
                 } */

                cansubmit = 1;
                formerror = 0;

                function validateform(){
                    console.log('*** In validation function ** ');


                    cansubmit = 1;
                    formerror = 0;


                    // empty error messages
                    $("#customer-error").html('');



                    var supervisornumber = $('#supervisor_number').val();


                    if(supervisornumber.length != 0 && supervisornumber.length != 10){
                        formerror = 1;
                        var errormsg = 'Only 10 digit  mobile number allowed';
                        $('.supervisor_number_error').html(errormsg);
                    }else{
                        $('.supervisor_number_error').html('');
                    }





                    var customer = $('#customer :selected').val();







                    // alert(' form error '+formerror);

                    if(customer == null || customer == ''){
                        formerror = 1;
                        var errormsg = "Select Customer";
                        if($('#customer').parent().children('label.error').length == 0){

                            $('#customer').parent().append('<label class="error">'+errormsg+'</label>');

                        }else{
                            $('#customer').parent().children('label.error').html(errormsg);
                        }
                    }else if($('#customer').parent().children('label.error').length != 0){
                        $('#customer').parent().children('label.error').html('');
                    }

                    // alert('customer error  = '+formerror);

                    var totalproduct = 0;
                    $(".company_sun").each(function(){

                        totalproduct++;

                        var product  =  $('option:selected',this).val();
                        if(product == ''){
                            formerror = 1;
                            var errormsg = "Select Product";
                            if($(this).parent().children('label.error').length == 0){

                                $(this).parent().append('<label class="error">'+errormsg+'</label>');

                            }else{
                                $(this).parent().children('label.error').html(errormsg);
                            }


                        }else{
                            $(this).parent().children('label.error').html('');

                        }

                    });

                    if(totalproduct == 0){
                        cansubmit = 0;
                        // alert('Please select atleast one product');
                    }





                    //   alert('product error  = '+formerror);

                    $(".quant_sun").each(function(){

                        var quantity  =  $(this).val();
                        if(quantity == ''){
                            formerror = 1;
                            var errormsg = "Enter Quantity";
                            if($(this).parent().children('label.error').length == 0){

                                $(this).parent().append('<label class="error">'+errormsg+'</label>');

                            }else{
                                $(this).parent().children('label.error').html(errormsg);
                            }


                        }else{
                            var errormsg = $(this).parent().children('label.error').html();
                            if(errormsg == "Enter Quantity"){
                                $(this).parent().children('label.error').html('');
                            }
                        }

                    });


                    //   alert('quantity  error  = '+formerror);
                    $(".amount_sun").each(function(){

                        var mrprate  =  $(this).val();


                        if(mrprate == '' || mrprate == 0 ){

                            formerror = 1;

                            var errormsg = "Enter Rate";
                            if($(this).parent().children('label.error').length == 0){

                                $(this).parent().append('<label class="error">'+errormsg+'</label>');

                            }else{
                                $(this).parent().children('label.error').html(errormsg);
                            }

                        }else{
                            $(this).parent().children('label.error').html('');
                        }

                    });





                    $(".unit_sun").each(function(){

                        var unit  =  $('option:selected',this).val();
                        if(unit == ''){

                            formerror = 1;

                            var errormsg = "Select Unit";
                            if($(this).parent().children('label.error').length == 0){

                                $(this).parent().append('<label class="error">'+errormsg+'</label>');

                            }else{
                                $(this).parent().children('label.error').html(errormsg);
                            }


                        }else{
                            $(this).parent().children('label.error').html('');

                        }

                    });




                    if($('#pay_now').is(':checked')){

                        paymentmode = '';



                        paymentmode  =  $('#th_payment_mode :selected').val();
                        if(paymentmode == ''){
                            formerror = 1;
                            var errormsg = "select payment mode";
                            if($('#th_payment_mode').parent().children('label.error').length == 0){

                                $('#th_payment_mode').parent().append('<label class="error">'+errormsg+'</label>');

                            }else{
                                $('#th_payment_mode').parent().children('label.error').html(errormsg);
                            }


                        }else{
                            $('#th_payment_mode').parent().children('label.error').html('');

                        }







                        // payment detail


                        if(paymentmode == 2 || paymentmode == 5){

                            var thdetail =    $('#th_details').val();

                            if(thdetail.length == 0){
                                formerror = 1;
                                var errormsg = "Enter Payment Details";
                                if($('#th_details').parent().children('label.error').length == 0){

                                    $('#th_details').parent().append('<label class="error" style="display:block;">'+errormsg+'</label>');

                                }else{
                                    $('#th_details').parent().children('label.error').html(errormsg);
                                }

                            }else{
                                $('#th_details').parent().children('label.error').html('');

                            }


                        }







                        // amount


                        var pay_amount = $('#pay_amount').val();
                        if(pay_amount.length == 0){
                            formerror = 1;
                            var errormsg = "Enter Payment Amount";
                            if($('#pay_amount').parent().children('label.error').length == 0){

                                $('#pay_amount').parent().append('<label class="error" style="display:block;">'+errormsg+'</label>');

                            }else{
                                $('#pay_amount').parent().children('label.error').html(errormsg);
                            }

                        }else{
                            $('#pay_amount').parent().children('label.error').html('');

                        }





                    }



                    if(formerror == 1){
                        cansubmit = 0;
                    }else{
                        console.log('validation ok ready to submit ');
                        $('#button2').css('display','inline-block');
                        $('.waitbutton').addClass('dontshow');
                    }


                    formerror = 0;



                }






                $('#button2').on('click',function(e){
                    console.log('submiting form / fetching live data ');

//                    $(this).css('display','none');
//                    $('.waitbutton').removeClass('dontshow');
                    // add_button_seconds();
                    /*  new code */
                    validateform();
                    if(cansubmit == 1){
                        //  myStopFunction();
                        $('#button2').css('display','none');
                        $('.waitbutton').removeClass('dontshow');


                        $('#challanblock').css('display','none');
                        $('#challanblock_title').html('Dont close page ... work in progress ..!');
                        $('.waitbutton').html('Submitting.');
                        $('#cancel').css('display','none');

                        // customer


                        var sun_company = [];
                        $('select.company_sun').each(function(){
                            var company =  $("option:selected", this).val();
                            if(company == undefined){
                                company = '';
                            }
                            sun_company.push(company);
                        });

                        var rake_no_sun = [];
                        $('select.rake_no_sun').each(function(){
                            var rake =  $("option:selected", this).val();
                            if(rake == undefined){
                                rake = '';
                            }
                            rake_no_sun.push(rake);
                        });

                        var finish_sun = [];
                        $('select.finish_sun').each(function(){
                            var finish =  $("option:selected", this).val();
                            if(finish == undefined){
                                finish = '';
                            }
                            finish_sun.push(finish);
                        });


                        var code_sun = [];
                        $('.code_sun').each(function(){
                            var code  = $(this).val();
                            code_sun.push(code);
                        });

                        var quant_sun = [];
                        $('.quant_sun').each(function(){
                            var quantity  = $(this).val();
                            quant_sun.push(quantity);
                        });

                        var amount_sun = [];
                        $('.amount_sun').each(function(){
                            //  $(this).css('display','none');
                            var amount  = $(this).val();
                            amount_sun.push(amount);
                        });



                        var spinner = '<div class="preloader pl-size-xs"> <div class="spinner-layer pl-red-grey"> <div class="circle-clipper left"> <div class="circle"></div> </div> <div class="circle-clipper right"> <div class="circle"></div> </div> </div> </div>';
                        $('.amount_show').html(spinner);
                        $('.finalamount_show').html(spinner);

                        var customer = $('#customer :selected').val();
                        if(customer.length == 0){
                            customer = '';
                        }


                        var labour = 0;
                        if($('#labour').val().length != 0){
                            labour = $('#labour').val();
                        }
                        var freight = 0;
                        if($('#freight').val().length != 0){
                            freight = $('#freight').val();
                        }
                        $('.amount_sun').addClass('makeit_readonly');
                        $('.amount_sun').attr('readonly','true');



                        $.ajax({
                            url: 'ajax/order_challan_tax.php?action=get_taxes',
                            type: 'post',
                            data:{
                                // all sunmica data
                                'sun_company':sun_company,
                                'rake_no_sun':rake_no_sun,
                                'finish_sun':finish_sun,
                                'code_sun':code_sun,
                                'quant_sun':quant_sun,
                                'amount_sun':amount_sun,
                                'customer':customer,
                                'labour':labour,
                                'freight':freight,
                                'editid':editid

                            },
                            success:function(data){
                                //alert('wait');
                                $('.amount_show').html('');
                                $('.finalamount_show').html('');
                                var finaldata  = $.parseJSON(data);



                                var sunmicadata = finaldata.sunmica;
                                var boarddata = finaldata.board;
                                var veneerdata = finaldata.veneer;


                                var totalamtinwords = finaldata.totalamtinwords;
                                var totalamt = finaldata.totalamt;
                                $('#totalamount').val(totalamt);
                                $('#totalamount_show').html(totalamt);

                              // console.log("at pay_amount code ");

                               // $('#pay_amount').val(totalamt);

                                // if($('#pay_amount').length == 0){
                                  //  $('#pay_amount').val(0);

                               //}

                                  if($('#pay_amount').length == 0){
                                   $('#pay_amount').val(0);
                                  }






                                $('#totalamtinwords').val(totalamtinwords);
                                $('#totalamtinwords_show').html(totalamtinwords);




                                // taxablevalue


                                var totaltaxamountinwords = finaldata.totaltaxamountinwords;
                                var totaltaxamount = finaldata.totaltaxamount;




                                $('#taxamount').val(totaltaxamount);

                                halftotaltax =  totaltaxamount / 2;
                                halftotaltax = halftotaltax.toFixed(2)

                                taxable_value  = finaldata.taxablevalue.toFixed(2);






                                $('#taxable_value').val(taxable_value);
                                $('#taxable_value_show').html(taxable_value);

                                $('#central_tax').val(halftotaltax);
                                $('#central_tax_show').html(halftotaltax);


                                $('#state_tax').val(halftotaltax);
                                $('#state_tax_show').html(halftotaltax);


                                // $('#taxamount_show').html(totaltaxamount);
                                $('#taxamtinwords').val(totaltaxamountinwords);
                                $('#taxamtinwords_show').html(totaltaxamountinwords);

                                i = 0;
                                $('select.company_sun').each(function(){
                                    if(sunmicadata[i].error == 1){
                                        // error case
                                        if(sunmicadata[i].init == 1){
                                            $(this).closest("td").siblings().children().children().children('.quant_sun').val('');
                                            warning("Info :",sunmicadata[i].msg);

                                        }

                                    }else{
                                        if(sunmicadata[i] != undefined){



                                            var current_amount = $(this).closest("td").siblings().children().children().children('.amount').val();
                                            if((current_amount.length == 0 ) || (parseInt(current_amount) == 0)){
                                                $(this).closest("td").siblings().children().children().children('.amount').val(sunmicadata[i].amount);
                                            }



                                            $(this).closest("td").siblings().children().children().children('.amount').val(sunmicadata[i].amount);
                                            $(this).closest("td").siblings().children('.taxid').val(sunmicadata[i].taxid);
                                            $(this).closest("td").siblings().children('.taxincl').val(sunmicadata[i].taxincl);

                                            $(this).closest("td").siblings().children('.taxtype').val(sunmicadata[i].taxtype);
                                            $(this).closest("td").siblings().children('.taxrate').val(sunmicadata[i].taxrate);

                                            $(this).closest("td").siblings().children('.taxamount').val(sunmicadata[i].taxamount);
                                            $(this).closest("td").siblings().children('.finalamount').val(sunmicadata[i].finalamount);

                                            $(this).closest("td").siblings().children('.amount_show').val(sunmicadata[i].amount);

                                            taxincl = '';
                                            if(sunmicadata[i].taxincl){
                                                taxincl = '<i style=" color:red; " class="material-icons">done</i>';
                                            }else{
                                                taxincl = '<i style=" color:red; " class="material-icons">clear</i>';
                                            }

                                            $(this).closest("td").siblings().children('.amount_show').html(sunmicadata[i].amount);
                                            //$(this).closest("td").siblings().children('.finalamount_show').html(sunmicadata[i].finalamount);
                                            $(this).closest("td").siblings().children('.finalamount_show_amount').val(sunmicadata[i].finalamount);


                                        }

                                    }
                                    i++;
                                });






                                var taxdata = '<div class="row"> <div class="col-md-12"> <label class="alert alert-info text-center sectionheaders" >TAXES</label></div> </div>';
                                taxdata += '<table class="table table-bordered table-striped " id="veneerstable"><thead>';
                                taxdata += '<tr><th>Tax</th><th>Amount</th></tr>';
                                taxdata += '</thead><tbody>';
                                var taxapplied  = finaldata.taxdeduction;
                                var totaltaxamount = finaldata.totaltaxamount;
                                var halftotaltaxamount = parseFloat(totaltaxamount)/ 2;
                                halftotaltaxamount = halftotaltaxamount.toFixed(2);

                                taxdata +='<tr><td>CGST</td><td>'+halftotaltaxamount+'</td></tr>';
                                taxdata +='<tr><td>SGST</td><td>'+halftotaltaxamount+'</td></tr>';

                                taxdata += '</tbody></table>';
                                $('#tax_applied').html(taxdata);


                                var taxdata = '<div class="row"> <div class="col-md-12"> <label class="alert alert-info text-center sectionheaders" >TAXES DETAILS</label></div> </div>';
                                taxdata += '<table class="table table-bordered table-striped " id="veneerstable"><thead>';
                                taxdata += '<tr><!--<th rowspan="2" class="text-center">HSN / SAC</th>--><th rowspan="2" class="text-center">Taxable Value</th><th colspan="2" class="text-center">Central Tax</th><th colspan="2" class="text-center">State Tax</th></tr>';
                                taxdata += '<tr><th class="text-center">Rate</th><th class="text-center">Amount</th><th class="text-center">Rate</th><th class="text-center">Amount</th></tr>';
                                taxdata += '</thead><tbody>';




                                var taxess = finaldata.taxesapplied;
                                if(taxess.length != 0){
                                    for(var i=0; i< taxess.length; i++){

                                        taxrate = 0;
                                        taxamount = 0;
                                        if(taxess[i].taxtype == 1){
                                            // %
                                            if(taxess[i].taxrate.length == 0){
                                                taxrate = 0;
                                            }else{
                                                taxrate = taxess[i].taxrate;
                                            }
                                            if(taxess[i].taxamount.length == 0){
                                                taxamount = 0;
                                            }else{
                                                taxamount =  taxess[i].taxamount;
                                            }
                                            halftaxrate = parseFloat(taxrate) / 2;
                                            halftaxrate += ' %';
                                            halftaxamount = parseFloat(taxamount) / 2;
                                            halftaxamount =  halftaxamount.toFixed(2);

                                        }else if(taxess[i].taxtype == 2){
                                            if(taxess[i].taxrate.length == 0){
                                                taxrate = 0;
                                            }else{
                                                taxrate = taxess[i].taxrate;
                                            }
                                            if(taxess[i].taxamount.length == 0){
                                                taxamount = 0;
                                            }else{
                                                taxamount =  taxess[i].taxamount;
                                            }

                                            halftaxrate = parseFloat(taxrate) / 2;
                                            halftaxrate += ' Rs';
                                            halftaxamount = parseFloat(taxamount) / 2;
                                            halftaxamount =  halftaxamount.toFixed(2);
                                        }

                                        taxamount = taxess[i].taxamount.toFixed(2);
                                        if(halftaxamount != 0){

                                            taxdata += '<tr><td style="display:none;"><input type="hidden" name="ot_hsn[]" value="'+taxess[i].hsn_sac+'">'+taxess[i].hsn_sac+'</td><td><input type="hidden" name="ot_taxable_value[]" value="'+taxamount+'">'+taxamount+'</td><td><input type="hidden" name="ot_central_rate[]" value="'+halftaxrate+'">'+halftaxrate+'</td><td><input type="hidden" name="ot_central_amount[]" value="'+halftaxamount+'">'+halftaxamount+'</td><td><input type="hidden" name="ot_state_rate[]" value="'+halftaxrate+'">'+halftaxrate+'</td><td><input type="hidden" name="ot_state_amount[]" value="'+halftaxamount+'">'+halftaxamount+'</td></tr>';
                                        }


                                    }
                                }

                                taxdata += '</tbody></table>';


                                //totaltaxamount



                                $('#tax_details').html(taxdata);

                                $('.amount_sun').removeClass('makeit_readonly');
//                            $('.amount_sun').attr('readonly',false);

                                /*tax block code ends */


                                /*  if(show == 1){
                                 $('#button2').css('display','inline-block');
                                 }
                                 $('.waitbutton').addClass('dontshow'); */
                                validateform();
                                if(cansubmit == 1){
                                    show = 0;

                                    $('#button2').css('display','none');
                                    $('#challanblock').css('display','none');
                                    $('#challanblock_title').html('Dont close page ... work in progress ..!');
                                    $('.waitbutton').html('Submitting.');

                                    // myStopFunction();
                                    $('#frm').submit();
                                }else{
                                    console.log('on button click  --- showing button on error');
                                    $('#button2').css('display','inline-block');
                                    $('.waitbutton').addClass('dontshow');
                                    $('#challanblock').css('display','block');
                                    $('#challanblock_title').html('');
                                    $('.waitbutton').html('Wait');
                                    $('.amount_sun').removeClass('makeit_readonly');
                                    $('.amount_sun').attr('readonly',false);
                                    $('#freight').removeClass('makeit_readonly');
                                    $('#freight').attr('readonly',false);
                                    $('#labour').removeClass('makeit_readonly');
                                    $('#labour').attr('readonly',false);
                                    $('#cancel').css('display','inline-block');
                                }
                            },
                            error: function (jqXHR, exception) {
                                alert('internet issue ');

                                $('#button2').css('display','inline-block');
                                $('.waitbutton').addClass('dontshow');
                                $('#challanblock').css('display','block');
                                $('#challanblock_title').html('');
                                $('.waitbutton').html('Wait');
                                $('.amount_sun').removeClass('makeit_readonly');
                                $('.amount_sun').attr('readonly',false);
                                $('#freight').removeClass('makeit_readonly');
                                $('#freight').attr('readonly',false);
                                $('#labour').removeClass('makeit_readonly');
                                $('#labour').attr('readonly',false);
                                $('#cancel').css('display','inline-block');
                            }
                        });

                    }else{
                        console.log('on button click  --- showing button on error');
                        $('#button2').css('display','inline-block');
                        $('.waitbutton').addClass('dontshow');
                        $('#challanblock').css('display','block');
                        $('#challanblock_title').html('');
                        $('.waitbutton').html('Wait');
                        $('.amount_sun').removeClass('makeit_readonly');
                        $('.amount_sun').attr('readonly',false);
                        $('#freight').removeClass('makeit_readonly');
                        $('#freight').attr('readonly',false);
                        $('#labour').removeClass('makeit_readonly');
                        $('#labour').attr('readonly',false);
                        $('#cancel').css('display','inline-block');
                    }




                });





                function calculate_order_invoice(){
                    console.log('fetching live data hiding buttons ');
                    //  myStopFunction();


                    $('#button2').css('display','none');
                    $('.waitbutton').removeClass('dontshow');

                    // customer


                    var sun_company = [];
                    $('select.company_sun').each(function(){
                        var company =  $("option:selected", this).val();
                        if(company == undefined){
                            company = '';
                        }
                        sun_company.push(company);
                    });

                    var rake_no_sun = [];
                    $('select.rake_no_sun').each(function(){
                        var rake =  $("option:selected", this).val();
                        if(rake == undefined){
                            rake = '';
                        }
                        rake_no_sun.push(rake);
                    });

                    var finish_sun = [];
                    $('select.finish_sun').each(function(){
                        var finish =  $("option:selected", this).val();
                        if(finish == undefined){
                            finish = '';
                        }
                        finish_sun.push(finish);
                    });


                    var code_sun = [];
                    $('.code_sun').each(function(){
                        var code  = $(this).val();
                        code_sun.push(code);
                    });

                    var quant_sun = [];
                    $('.quant_sun').each(function(){
                        var quantity  = $(this).val();
                        quant_sun.push(quantity);
                    });

                    var amount_sun = [];
                    $('.amount_sun').each(function(){
                        //  $(this).css('display','none');
                        var amount  = $(this).val();
                        amount_sun.push(amount);
                    });



                    var spinner = '<div class="preloader pl-size-xs"> <div class="spinner-layer pl-red-grey"> <div class="circle-clipper left"> <div class="circle"></div> </div> <div class="circle-clipper right"> <div class="circle"></div> </div> </div> </div>';
                    $('.amount_show').html(spinner);
                    $('.finalamount_show').html(spinner);

                    var customer = $('#customer :selected').val();
                    if(customer.length == 0){
                        customer = '';
                    }


                    var labour = 0;
                    if($('#labour').val().length != 0){
                        labour = $('#labour').val();
                    }
                    var freight = 0;
                    if($('#freight').val().length != 0){
                        freight = $('#freight').val();
                    }
                    $('.amount_sun').addClass('makeit_readonly');
//                 $('.amount_sun').attr('readonly','true');

                    $.ajax({
                        url: 'ajax/order_challan_tax.php?action=get_taxes',
                        type: 'post',
                        data:{
                            // all sunmica data
                            'sun_company':sun_company,
                            'rake_no_sun':rake_no_sun,
                            'finish_sun':finish_sun,
                            'code_sun':code_sun,
                            'quant_sun':quant_sun,
                            'amount_sun':amount_sun,
                            'customer':customer,
                            'labour':labour,
                            'freight':freight,
                            'editid':editid

                        },
                        success:function(data){
                            //alert('wait');
                            $('.amount_show').html('');
                            $('.finalamount_show').html('');
                            var finaldata  = $.parseJSON(data);



                            var sunmicadata = finaldata.sunmica;
                            var boarddata = finaldata.board;
                            var veneerdata = finaldata.veneer;


                            var totalamtinwords = finaldata.totalamtinwords;
                            var totalamt = finaldata.totalamt;
                            $('#totalamount').val(totalamt);
                            $('#totalamount_show').html(totalamt);


                             <?php  if($_REQUEST['action'] != 'edit'){ ?>
                                $('#pay_amount').val(totalamt);
                           <?php  }  ?>





                            $('#totalamtinwords').val(totalamtinwords);
                            $('#totalamtinwords_show').html(totalamtinwords);




                            // taxablevalue


                            var totaltaxamountinwords = finaldata.totaltaxamountinwords;
                            var totaltaxamount = finaldata.totaltaxamount;




                            $('#taxamount').val(totaltaxamount);

                            halftotaltax =  totaltaxamount / 2;
                            halftotaltax = halftotaltax.toFixed(2)

                            taxable_value  = finaldata.taxablevalue.toFixed(2);






                            $('#taxable_value').val(taxable_value);
                            $('#taxable_value_show').html(taxable_value);

                            $('#central_tax').val(halftotaltax);
                            $('#central_tax_show').html(halftotaltax);


                            $('#state_tax').val(halftotaltax);
                            $('#state_tax_show').html(halftotaltax);


                            // $('#taxamount_show').html(totaltaxamount);
                            $('#taxamtinwords').val(totaltaxamountinwords);
                            $('#taxamtinwords_show').html(totaltaxamountinwords);

                            i = 0;
                            $('select.company_sun').each(function(){
                                if(sunmicadata[i].error == 1){
                                    // error case
                                    if(sunmicadata[i].init == 1){
                                        $(this).closest("td").siblings().children().children().children('.quant_sun').val('');
                                        warning("Info :",sunmicadata[i].msg);

                                    }

                                }else{
                                    if(sunmicadata[i] != undefined){



                                        var current_amount = $(this).closest("td").siblings().children().children().children('.amount').val();
                                        if((current_amount.length == 0 ) || (parseInt(current_amount) == 0)){
                                            $(this).closest("td").siblings().children().children().children('.amount').val(sunmicadata[i].amount);
                                        }



                                        $(this).closest("td").siblings().children().children().children('.amount').val(sunmicadata[i].amount);
                                        $(this).closest("td").siblings().children('.taxid').val(sunmicadata[i].taxid);
                                        $(this).closest("td").siblings().children('.taxincl').val(sunmicadata[i].taxincl);

                                        $(this).closest("td").siblings().children('.taxtype').val(sunmicadata[i].taxtype);
                                        $(this).closest("td").siblings().children('.taxrate').val(sunmicadata[i].taxrate);

                                        $(this).closest("td").siblings().children('.taxamount').val(sunmicadata[i].taxamount);
                                        $(this).closest("td").siblings().children('.finalamount').val(sunmicadata[i].finalamount);

                                        $(this).closest("td").siblings().children('.amount_show').val(sunmicadata[i].amount);

                                        taxincl = '';
                                        if(sunmicadata[i].taxincl){
                                            taxincl = '<i style=" color:red; " class="material-icons">done</i>';
                                        }else{
                                            taxincl = '<i style=" color:red; " class="material-icons">clear</i>';
                                        }

                                        $(this).closest("td").siblings().children('.amount_show').html(sunmicadata[i].amount);
                                        //$(this).closest("td").siblings().children('.finalamount_show').html(sunmicadata[i].finalamount);
                                        $(this).closest("td").siblings().children('.finalamount_show_amount').val(sunmicadata[i].finalamount);


                                    }

                                }
                                i++;
                            });






                            var taxdata = '<div class="row"> <div class="col-md-12"> <label class="alert alert-info text-center sectionheaders" >TAXES</label></div> </div>';
                            taxdata += '<table class="table table-bordered table-striped " id="veneerstable"><thead>';
                            taxdata += '<tr><th>Tax</th><th>Amount</th></tr>';
                            taxdata += '</thead><tbody>';
                            var taxapplied  = finaldata.taxdeduction;
                            var totaltaxamount = finaldata.totaltaxamount;
                            var halftotaltaxamount = parseFloat(totaltaxamount)/ 2;
                            halftotaltaxamount = halftotaltaxamount.toFixed(2);

                            taxdata +='<tr><td>CGST</td><td>'+halftotaltaxamount+'</td></tr>';
                            taxdata +='<tr><td>SGST</td><td>'+halftotaltaxamount+'</td></tr>';

                            taxdata += '</tbody></table>';
                            $('#tax_applied').html(taxdata);


                            var taxdata = '<div class="row"> <div class="col-md-12"> <label class="alert alert-info text-center sectionheaders" >TAXES DETAILS</label></div> </div>';
                            taxdata += '<table class="table table-bordered table-striped " id="veneerstable"><thead>';
                            taxdata += '<tr><!--<th rowspan="2" class="text-center">HSN / SAC</th>--><th rowspan="2" class="text-center">Taxable Value</th><th colspan="2" class="text-center">Central Tax</th><th colspan="2" class="text-center">State Tax</th></tr>';
                            taxdata += '<tr><th class="text-center">Rate</th><th class="text-center">Amount</th><th class="text-center">Rate</th><th class="text-center">Amount</th></tr>';
                            taxdata += '</thead><tbody>';




                            var taxess = finaldata.taxesapplied;
                            if(taxess.length != 0){
                                for(var i=0; i< taxess.length; i++){

                                    taxrate = 0;
                                    taxamount = 0;
                                    if(taxess[i].taxtype == 1){
                                        // %
                                        if(taxess[i].taxrate.length == 0){
                                            taxrate = 0;
                                        }else{
                                            taxrate = taxess[i].taxrate;
                                        }
                                        if(taxess[i].taxamount.length == 0){
                                            taxamount = 0;
                                        }else{
                                            taxamount =  taxess[i].taxamount;
                                        }
                                        halftaxrate = parseFloat(taxrate) / 2;
                                        halftaxrate += ' %';
                                        halftaxamount = parseFloat(taxamount) / 2;
                                        halftaxamount =  halftaxamount.toFixed(2);

                                    }else if(taxess[i].taxtype == 2){
                                        if(taxess[i].taxrate.length == 0){
                                            taxrate = 0;
                                        }else{
                                            taxrate = taxess[i].taxrate;
                                        }
                                        if(taxess[i].taxamount.length == 0){
                                            taxamount = 0;
                                        }else{
                                            taxamount =  taxess[i].taxamount;
                                        }

                                        halftaxrate = parseFloat(taxrate) / 2;
                                        halftaxrate += ' Rs';
                                        halftaxamount = parseFloat(taxamount) / 2;
                                        halftaxamount =  halftaxamount.toFixed(2);
                                    }

                                    taxamount = taxess[i].taxamount.toFixed(2);
                                    if(halftaxamount != 0){

                                        taxdata += '<tr><td style="display:none;"><input type="hidden" name="ot_hsn[]" value="'+taxess[i].hsn_sac+'">'+taxess[i].hsn_sac+'</td><td><input type="hidden" name="ot_taxable_value[]" value="'+taxamount+'">'+taxamount+'</td><td><input type="hidden" name="ot_central_rate[]" value="'+halftaxrate+'">'+halftaxrate+'</td><td><input type="hidden" name="ot_central_amount[]" value="'+halftaxamount+'">'+halftaxamount+'</td><td><input type="hidden" name="ot_state_rate[]" value="'+halftaxrate+'">'+halftaxrate+'</td><td><input type="hidden" name="ot_state_amount[]" value="'+halftaxamount+'">'+halftaxamount+'</td></tr>';
                                    }


                                }
                            }

                            taxdata += '</tbody></table>';


                            //totaltaxamount



                            $('#tax_details').html(taxdata);

                            $('.amount_sun').removeClass('makeit_readonly');
//                            $('.amount_sun').attr('readonly',false);

                            /*tax block code ends */


                            /*  if(show == 1){
                             $('#button2').css('display','inline-block');
                             }
                             $('.waitbutton').addClass('dontshow'); */
                            console.log('checking for validations');
                            validateform();

                        },
                        error: function (jqXHR, exception) {
                            alert('internet issue ');

                            $('.amount_show').html('');
                            $('.finalamount_show').html('');


                            $('#button2').css('display','inline-block');
                            $('.waitbutton').addClass('dontshow');
                            $('#challanblock').css('display','block');
                            $('#challanblock_title').html('');
                            $('.waitbutton').html('Wait');
                            $('.amount_sun').removeClass('makeit_readonly');
                            $('.amount_sun').attr('readonly',false);
                        }
                    });



                }








                function cleartax(){
                    // $('.amount').val('');
                    $('.taxid').val('');
                    $('.taxincl').val('');
                    $('.taxtype').val('');
                    $('.taxrate').val('');
                    $('.taxamount').val('');
                    $('.finalamount').val('');
                    $('.amount_show').html('');
                }






                function   checkselected(object){
                    error  = 0;


                    if(object.hasClass('customer')){
                        $('.amount_sun').val(0);
                    }

                    // sunmica    starts
                    if(object.hasClass('company_sun')){




                        // if deselect ...
                        var selectedcompany = $('option:selected', object).val();
                        var selectedcompany_name = $('option:selected', object).text();
                        if(selectedcompany == undefined ||  selectedcompany == ''){

                            object.closest("td").siblings().children().children().children('.quant_sun').val('');
                            object.closest("td").siblings().children().children().children('.amount_sun').val('');
                            // warning("Info :","Select Particular's");
                            error = 1;
                        }else{
                            object.closest("td").siblings().children().children().children('.amount_sun').val('');
                        }
                    }else if( object.hasClass('quant_sun')  || object.hasClass('amount_sun')){
                        if(object.hasClass('quant_sun')){
                            var codesun =  object.val();
                            if(codesun.length != 0){
                                var quantity = parseInt(codesun);
                                if(quantity <=0){
                                    object.val('');
                                }
                            }


                            if(codesun.length == 0){
                                error = 1;
                                //  warning("Info :","Enter Quantity ");
                            }
                        }



                        if(object.hasClass('amount_sun')){

                            var amountsun =  object.val();
                            if(amountsun.length != 0){
                                var amt_sun = parseFloat(amountsun);
                                if(amt_sun <=0){
                                    object.val('');
                                }
                            }


                            if(amountsun.length == 0){
                                error = 1;
                                //  warning("Info :","Enter Rate");
                            }
                        }

                    }

                    if(error != 1 ){

                        cleartax();
                        calculate_order_invoice();

                    }





                }


                $('body').on('change','.company_sun',function(e){
                    e.stopPropagation();
                    var companythis =  $("option:selected", this).val();

                    var exist = 0;
                    $('select.company_sun').each(function(){
                        var company =  $("option:selected", this).val();
                        if((company.length != 0) && (company == companythis)){
                            exist++;
                            if(exist == 2){
                                $(this).val('');
                                $(this).select2('destroy');
                                $(this).select2();
                                warning("Info :","Product already Selected !");
                                return false;
                            }
                        }
                    });
                    checkselected($(this));
                });



                $('body').on('change','.customer',function(e){
                    e.stopPropagation();
                    // $(this).valid();
                    $('#labour').val(0);
                    $('#freight').val(0);
                    checkselected($(this));
                });

                $('body').on('keyup','.quant_sun',function(e){
                    e.stopPropagation();
                    checkselected($(this));
                });

                $('body').on('change','.unit_sun',function(e){
                    e.stopPropagation();
                    checkselected($(this));
                });

                $('body').on('change','#th_payment_mode',function(e){
                    e.stopPropagation();
                    checkselected($(this));
                });







                $('body').on('keyup','.amount_sun',function(e){
                    e.stopPropagation();

                    var currentamount= $(this).val();
                    newamount = currentamount.replace(/^0+/, '');
                    if(!(currentamount === newamount)){
                        $(this).val(newamount);
                    }
                    checkselected($(this));
                    $('.refresh_change div i').css('color','red');
                });

                $('body').on('change','.amount_sun',function(e){
                    e.stopPropagation();

                    var currentamount= $(this).val();
                    newamount = currentamount.replace(/^0+/, '');
                    if(!(currentamount === newamount)){
                        $(this).val(newamount);
                    }
                    checkselected($(this));
                    $('.refresh_change div i').css('color','red');
                });


                /*$('body').on('click','.refresh_change div i',function(e){
                 e.stopPropagation();
                 checkselected($(this));
                 $('.refresh_change div i').css('color','green');
                 }); */





                $('body').on('keyup','.labour',function(e){
                    e.stopPropagation();
                    checkselected($(this));
                });
                $('body').on('keyup','.freight',function(e){
                    e.stopPropagation();
                    checkselected($(this));
                });







                function warning(title,text){
                    swal({
                        title:title,
                        text:text,
                        type: "warning"
                    });
                }





                $('#cancel').on('click', function (e) {
                    e.preventDefault();
                    window.location.href = 'index.php?page=<?php echo $curpage; ?>';
                });


                id = 1;

                $('body').on('click','#addsunmica',function(e){
                    id++;
                    e.preventDefault();
                    var html = '';
                    html += '<tr>';
                    html += '<td data-title="Particulars"><div class="form-group "><input type="hidden" name="sunmica[]" ><select data-container="body" name="company_sun[]" class="form-control company_sun     select2 " id="company_sun_'+suncount+'" style="width:150px">'+ company_sunopt+'</select></div></td>';
                    html += '<td data-title="Quantity"><div class="form-group input-group"><div class=" "><input type="number" min="0" name="quant_sun[]" id="quant_sun_'+suncount+'" class="form-control quant_sun" placeholder="Quantity :" value=""   autofocus></div></div></td>';
                    html += '<td data-title="Unit"><div class="form-group input-group"><div class=" "><select data-container="body" name="unit_sun[]" class="form-control   unit_sun  select2 " id="unit_sun_'+suncount+'"  style="width:150px">'+unit_sunopt+'</select></div></div></td>';
                    html += '<td><div class="form-group input-group"><div class=" " style="position:absolute;"><input type="number" min="0" name="amount_sun[]" id="amount_sun_'+suncount+'" class="form-control amount amount_sun"><span class="refresh_change"><div class="demo-google-material-icon"> <i class="material-icons ">refresh</i> </div></span></div></div>';
                    html += '<input type="hidden" name="taxid_sun[]" class="taxid">';
                    html += '<input type="hidden" name="tax_incl_sun[]"  class="taxincl">';
                    html += '<input type="hidden" name="tax_type_sun[]" class="taxtype">';
                    html += '<input type="hidden" name="tax_rate_sun[]" class="taxrate">';
                    html += '<input type="hidden" name="tax_amount_sun[]" class="taxamount">';
                    html += '<input type="hidden" name="final_amount_sun[]" class="finalamount">';
                    html += '</td>';
                    html += '<td><input disabled class="form-control finalamount_show_amount disabled_amount"></td>';
                    html += '<td data-title="Action"><i title="Delete Product " class="material-icons delete">delete</i><span class="finalamount_show"></span></td>';
                    html += '</tr>';
                    $('#sunmicatable').append(html);
                    //$('select').selectpicker();
                    $('.select2').select2();
                    $('.mydate').bootstrapMaterialDatePicker({
                        format: 'DD-MM-YYYY',
                        clearButton: true,
                        weekStart: 1,
                        time: false
                    }).on('dateSelected', function(e, date)
                    {
                        $('.dtp-btn-ok.btn.btn-flat').trigger('click');
                    });


                });



                $('table').on('click', '.delete', function (e){
                    e.preventDefault();
                    var currentitem = $(this);
                    currentitem.parent().parent().remove();
                    calculate_order_invoice();
                });






                <?php


                if(!isset($_REQUEST['action']) &&  isset($_SESSION['alert_msg'])){
                $type = '';

                if($_SESSION['alert_msg']['type']=='1'){
                    $type = "success";
                }else if($_SESSION['alert_msg']['type']=='2'){
                    $type = "warning";
                }else if($_SESSION['alert_msg']['type']=='3'){
                    $type = "danger";
                }   ?>



                title = '';
                text = '<?php echo $_SESSION['alert_msg']['text']; ?>';
                type = '<?php echo $type; ?>';
                swal({
                    title:title,
                    text:text,
                    type: type
                });




                <?php   unset($_SESSION['alert_msg']);
                unset($_SESSION['post_amount']);
                unset($_SESSION['post_date']);
                }  ?>




                <?php


                if(!isset($_REQUEST['action']) &&  isset($_SESSION['alert_msg'])){
                $type = '';

                if($_SESSION['alert_msg']['type']=='1'){
                    $type = "success";
                }else if($_SESSION['alert_msg']['type']=='2'){
                    $type = "warning";
                }else if($_SESSION['alert_msg']['type']=='3'){
                    $type = "danger";
                }   ?>



                title = '';
                text = '<?php echo $_SESSION['alert_msg']['text']; ?>';
                type = '<?php echo $type; ?>';
                swal({
                    title:title,
                    text:text,
                    type: type
                });




                <?php  unset($_SESSION['alert_msg']);
                }  ?>


            });


            var id= 1;
            function showtype(type)
            {  id++; //alert (type);
                $.ajax({
                    type: "POST",
                    url: "ajax/board_entry.php",
                    data: {type:type,id:id},
                    success: function (html)
                    {
                        $("#typediv").html(html);
                        $('.select2').select2();
                    }
                });
            }

            function showsrch(srch)
            {

                $.ajax({
                    type: "POST",
                    url: "ajax/order_search.php",
                    data: "srch=" + srch,
                    success: function (html)
                    {
                        $("#typediv").html(html);
                        $('.select2').select2();
                        $('.mydate').bootstrapMaterialDatePicker({
                            format: 'DD-MM-YYYY',
                            clearButton: true,
                            weekStart: 1,
                            time: false
                        }).on('dateSelected', function(e, date)
                        {
                            $('.dtp-btn-ok.btn.btn-flat').trigger('click');
                        });
                    }
                });

            }

            function getcustomer_detail(id,cust_id)
            {

                if(cust_id.length == 0){
                    $("#cust_no").val('');
                    $("#cust_email").val('');
                    $("#cust_addr").val('');
                    $("#cust_tin").val('');
                }else{
                    $.ajax({
                        type: "POST",
                        url: "ajax/getcust_detail.php",
                        data: "cust_id="+cust_id,
                        success: function(html)
                        {

                            var custdata = $.parseJSON(html);
                            //  console.log(custdata);
                            $("#cust_no").val(custdata.contact);
                            $("#cust_email").val(custdata.email);
                            $("#cust_addr").val(custdata.address);
                            $("#cust_tin").val(custdata.cust_tin);

                            if(custdata.cust_status == "Disabled"){
                                $('#challanblock').css('display','none');
                                $('#challanblock_title').html("<span style='color:red;'>Cannot create Challan : Contact Admin </span>");
                                $('#challanblock_addbtn').css('display','none');
                            }else{
                                $('#challanblock').css('display','block');
                                $('#challanblock_title').html(" Delivery challan Details ");
                                $('#challanblock_addbtn').css('display','inline-block');
                            }






                        }
                    });

                }


            }

        </script>





    </div>

</section>

Youez - 2016 - github.com/yon3zu
LinuXploit