�����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.69
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/inventory2/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /home/pateltimber.com/public_html/inventory2/newchallan_new.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();

    }

} 

$taxid = 2;



    $taxname = "GST";

    $taxtype = 1;

    $taxrate = 18;

	$tax_incl = 0;

	$tax_rate =18;

	$tax_type=1;





?>

     <link media="screen" rel="stylesheet" href="colorbox/colorbox.css" />

<script src="colorbox/jquery.colorbox.js"></script>

<script>

		$(document).ready(function(){

			//Examples of how to assign the ColorBox event to elements

			$(".group1").colorbox({rel:'group1'});

			$(".group2").colorbox({rel:'group2', transition:"fade"});

			$(".group3").colorbox({rel:'group3', transition:"none", width:"75%", height:"75%"});

			$(".group4").colorbox({rel:'group4', slideshow:true});

			$(".ajax").colorbox();

			$(".youtube").colorbox({iframe:true, innerWidth:425, innerHeight:344});

			$(".iframe").colorbox({iframe:true, width:"80%", height:"80%"});

			$(".inline").colorbox({inline:true, width:"50%"});

			$(".callbacks").colorbox({

				onOpen:function(){ alert('onOpen: colorbox is about to open'); },

				onLoad:function(){ alert('onLoad: colorbox has started to load the targeted content'); },

				onComplete:function(){ alert('onComplete: colorbox has displayed the loaded content'); },

				onCleanup:function(){ alert('onCleanup: colorbox has begun the close process'); },

				onClosed:function(){ alert('onClosed: colorbox has completely closed'); }

			});

		});



	</script>

<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=""  class="panel panel-primary " >

                <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[]" >

																		<!--	<input type="text" name="company_sun_name[]"  id="company_sun_name_<?php echo $x; ?>" onkeypress="ProductList(<?php echo $x; ?>);" ondblclick="ProductList(<?php echo $x; ?>);"   class="form-control "  required="true" autocomplete="off" value="<?php echo getvalue("product_name","tbl_product","where product_id=".$row_sunmica['goods_company']); ?>" />-->

                                                                           

																		<select  <?php echo $disable; ?>  data-container="body" name="company_sun[]" class="form-control    company_sun   " id="company_sun_<?php echo $x; ?>"   onfocus="ProductList(<?php echo $x; ?>);" ondblclick="ProductList(<?php echo $x; ?>);" >

                                                                              <option value="<?php echo $row_sunmica['goods_company']; ?>"><?php echo getvalue("product_name","tbl_product","where product_id=".$row_sunmica['goods_company']); ?></option>

																			     </select>

																			    <?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 } */?>

                                                                         

																		

                                                                           

                                                                        </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']; ?>"   onchange="getCalulation('<?php echo $x; ?>')">

                                                                            </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"  onchange="getCalulation('<?php echo $x; ?>')"><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 $taxid; ?>" class="taxid" id="taxid_<?php echo $x; ?>">

                                                                        <input type="hidden" name="tax_incl_sun[]"  value="<?php echo $tax_incl; ?>" class="taxincl" id="taxincl_<?php echo $x; ?>">

                                                                        <input type="hidden" name="tax_type_sun[]" value="<?php echo $tax_type; ?>" class="taxtype" id="taxtype_<?php echo $x; ?>">

                                                                        <input type="hidden" name="tax_rate_sun[]" value="<?php echo $tax_rate; ?>" class="taxrate" id="taxrate_<?php echo $x; ?>">

                                                                        <input type="hidden" name="tax_amount_sun[]" value="<?php echo $row_sunmica['tax_amount']; ?>" class="taxamount" id="taxamount_<?php echo $x; ?>">

																		<input type="hidden" name="prooduct_rate[]" value="<?php echo $row_sunmica['ammount']* $row_sunmica['goods_quantity']; ?>" class="productRate" id="productRate_<?php echo $x; ?>"></td>

																		<input type="hidden" name="prooduct_rate[]" value="<?php echo $row_sunmica['ammount']* $row_sunmica['goods_quantity']; ?>" class="productRate" id="productRate_<?php echo $x; ?>"></td>

                                                                  <td> <input type="hidden"  name="final_amount_sun[]" value="<?php echo $row_sunmica['final_amount']; ?>" class="finalamount form-control" id="finalamount_<?php echo $x; ?>">

																	

																	

																	

																	<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><span class="cgstTax"><?php echo $halftotaltaxamount; ?></span></td></tr>

                                            <tr><td>SGST</td><td><span class="sgstTax"><?php echo $halftotaltaxamount; ?></span></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" readonly="readonly" 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   " id="company_sun_<?php echo $x; ?>"   onfocus="ProductList(<?php echo $x; ?>);" ondblclick="ProductList(<?php echo $x; ?>);" >

                                                                              <option value="<?php echo $row_sunmica['goods_company']; ?>"><?php echo getvalue("product_name","tbl_product","where product_id=".$row_sunmica['goods_company']); ?></option>

																			     </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']; ?>"   onchange=" getCalulation('<?php echo $x; ?>')">

                                                                                </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"  onchange=" getCalulation('<?php echo $x; ?>')"><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">

																			<input type="hidden" name="prooduct_rate[]" value="<?php echo $row_sunmica['ammount']* $row_sunmica['goods_quantity']; ?>" class="productRate" id="productRate_<?php echo $x; ?>"></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 } */ 

															 $suncount = 2;

															 ?>

                                                                </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[]" >

																					

																		<!--	 <input type="text" name="company_sun[]"  id="company_sun_name_<?php echo $x; ?>" onkeypress="ProductList(1);" ondblclick="ProductList(1);"   class="form-control "  required="true" autocomplete="off" value="" />

                                                                            <input type="hidden" name="company_sun[]"  id="company_sun_<?php echo $x; ?>" class="form-control company_sun" data-validate="required" value=""   />-->

																		      

																		<select  <?php echo $disable; ?>  data-container="body" name="company_sun[]" class="form-control    company_sun   " id="company_sun_1"   onfocus="ProductList(1);" ondblclick="ProductList(1);" >

                                                                              <option value="">Select an option</option>

																			     </select>

																			

                                                                         

                                                                        </div>

                                                                    </td>

                                                                    <td data-title="Quantity"><div class="form-group input-group">

                                                                            <div class="  ">

                                                                                <input type="number" min="0" name="quant_sun[]"  class="form-control quant_sun" placeholder="Quantity :" value=""   onchange=" getCalulation(1)" id="quant_sun_1">

                                                                            </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_1"  >

                                                                                    <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[]"  class="form-control amount amount_sun" id="amount_sun_1"  onchange=" getCalulation(1)"><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 $taxid; ?>" class="taxid" id="taxid_1">

                                                                        <input type="hidden" name="tax_incl_sun[]"  value="<?php echo $tax_incl; ?>" class="taxincl" id="taxincl_1">

                                                                        <input type="hidden" name="tax_type_sun[]" value="<?php echo $tax_type; ?>" class="taxtype" id="taxtype_1">

                                                                        <input type="hidden" name="tax_rate_sun[]" value="<?php echo $tax_rate; ?>" class="taxrate" id="taxrate_1">

                                                                        <input type="hidden" name="tax_amount_sun[]" value="<?php echo $row_sunmica['tax_amount']; ?>" class="taxamount" id="taxamount_1">

																		 <input type="hidden" name="productRate[]" value="<?php echo $row_sunmica['tax_amount']; ?>" class="productRate" id="productRate_1">

                                                                  </td>

                                                                    <td>      <input type="text" readonly="readonly" name="final_amount_sun[]" value="<?php echo $row_sunmica['final_amount']; ?>" class="finalamount form-control" id="finalamount_1">

																	</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>















        





        <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>



        <p>

		 <script type="text/javascript">

    function show_product_list(id) {



        if (id !== '' ) {

            $.colorbox({width: "90%", height: "90%", iframe: true, href:  "product_list.php" + id });

          //  $('#list').show();

            //$('#s2example-1').attr('required', 'required');

        } else {

            alert('Kindly Select OrderType First');

        }

//                            sum();

    }

</script>

          <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 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('');



                    }







                })

































                $('#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);

										$(this).closest("td").siblings().children('.finalamount').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;

                            }

                        }

                    });

                   

                });







                $('body').on('change','.customer',function(e){

                    e.stopPropagation();

                    // $(this).valid();

                    $('#labour').val(0);

                    $('#freight').val(0);

                    checkselected($(this));

                });



             

             



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

                    e.stopPropagation();

                    checkselected($(this));

                });

















                /*$('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++;

				//	alert(suncount);

				var suncount = document.getElementById('sunmicatable').rows.length;

		

                    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><input type="text" name="company_sun_name[]"  id="company_sun_name_'+suncount+'" onkeypress="ProductList('+suncount+');" ondblclick="ProductList('+suncount+');"   class="form-control " required="true" autocomplete="off" value="" /><input type="hidden" name="company_sun[]"  id="company_sun_'+suncount+'" class="form-control company_sun" data-validate="required" value=""   /></td>';

				   

				         

					html += '<td data-title="Particulars"><div class="form-group "><select data-container="body" name="company_sun[]" class="form-control company_sun   " id="company_sun_'+suncount+'"   onfocus="ProductList('+suncount+');" ondblclick="ProductList('+suncount+');" ><option value="">Select an option</option></select>';

				   

                    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=""    onchange=" getCalulation('+suncount+')"></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"  onchange=" getCalulation('+suncount+')"><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" value="<?php echo $taxid; ?>" id="taxid_'+suncount+'">';

                    html += '<input type="hidden" name="tax_incl_sun[]"  class="taxincl" value="<?php echo $tax_incl; ?>" id="taxincl_'+suncount+'">';

                    html += '<input type="hidden" name="tax_type_sun[]" class="taxtype" value="<?php echo $tax_type; ?>" id="taxtype_'+suncount+'">';

                    html += '<input type="hidden" name="tax_rate_sun[]" class="taxrate" value="<?php echo $tax_rate; ?>" id="taxrate_'+suncount+'">';

                    html += '<input type="hidden" name="tax_amount_sun[]" class="taxamount" value="" id="taxamount_'+suncount+'">';

					html += '<input type="hidden" name="prooduct_rate[]" class="productRate" value="" id="productRate_'+suncount+'">';

                    html += '</td>';

                    html += '<td><input type="text" readonly="readonly" name="final_amount_sun[]" class="finalamount form-control" id="finalamount_'+suncount+'"></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);

                    $('.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');

                            }













                        }

                    });



                }





            }





function ProductList(id)

{



   $.colorbox({width: "50%", height: "90%", iframe: true, href: "productList.php?fieldId=" + id });

	// var companythis =  $('#company_sun_'+rowId).val();



}



function checkProduct(companythis)

{

//alert(companythis);

  

                    var exist = 0;

                    $('.company_sun').each(function(){

					

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

                        if((company.length != 0) && (company == companythis)){

                            exist++;

                            if(exist == 2){

                                $(this).val('');

                                $(this).select2('destroy');

                                $(this).select2();

								alert("Product already Selected !");

                                warning("Info :","Product already Selected !");

                                return false;

                            }

                        }

                    });

}



function getCalulation(rowId)

{

	var sun_company = $('#company_sun_'+rowId).val();

var quant_sun = $('#quant_sun_'+rowId).val();

var unit_sun = $('#unit_sun_'+rowId).val();

var amount_sun = $('#amount_sun_'+rowId).val();



var taxrate = $('#taxrate_'+rowId).val();

var amount_sun = $('#amount_sun_'+rowId).val();



var tot_amount = amount_sun * quant_sun;

var taxAmount = (tot_amount * taxrate)/118;

$('#taxamount_'+rowId).val(taxAmount.toFixed(2));

var finalAmount = tot_amount - taxAmount;

$('#finalamount_'+rowId).val(taxAmount.toFixed(2));

$('#finalamount_'+rowId).val(finalAmount.toFixed(2));

$('#productRate_'+rowId).val(tot_amount.toFixed(2));

allTaxCalculation();









}

function allTaxCalculation()

{

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

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

		  

		  var labourTaxaxAmount = (labour * 18)/118;

		  var freightTaxAmount = (freight * 18)/118;

		

		  var sum = 0;

                  $('.taxamount').each(function () {

                   if (!isNaN($(this).val()) && $(this).val().length !== 0) {

                      sum += parseFloat($(this).val());

	                 }

                  });



		var totalTax = 		 parseFloat(sum+labourTaxaxAmount+freightTaxAmount).toFixed(2);

		var totalCgst = parseFloat(totalTax/2).toFixed(2);

    	var totalSgst = parseFloat(totalTax/2).toFixed(2);



                  $('#taxable_value_show').val(totalTax);

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

		    $('#central_value_show').html(totalCgst);

	  $('#state_value_show').html(totalSgst);

	  

$('#central_value_show').html(totalCgst);

$('#central_value').val(totalCgst);

$('#state_value_show').html(totalSgst);

$('#state_value').html(totalSgst);



$('#central_tax_show').html(totalCgst);

$('#central_tax').val(totalCgst);

$('#state_tax_show').html(totalSgst);





$('#state_tax').val(totalSgst);





	  var productRate = 0;

                  $('.productRate').each(function () {

                   if (!isNaN($(this).val()) && $(this).val().length !== 0) {

                      productRate += parseFloat($(this).val());

	                 }

                  });



var totalAmount = parseFloat(Number(productRate) + Number(labour) + Number(freight)).toFixed(2);



 $('#totalamount_show').html(totalAmount);

  $('#totalamount').val(totalAmount);



    $('#taxable_value_show').html(totalAmount);

	 $('#taxable_value').val(totalAmount);

   



var halftaxrate = 9;

 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>';

                            taxdata +='<tr><td>CGST</td><td>'+totalCgst+'</td></tr>';

                            taxdata +='<tr><td>SGST</td><td>'+totalSgst+'</td></tr>';

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

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





                            var taxdata1 = '<div class="row"> <div class="col-md-12"> <label class="alert alert-info text-center sectionheaders" >TAXES DETAILS</label></div> </div>';

                            taxdata1 += '<table class="table table-bordered table-striped " id="veneerstable"><thead>';

                            taxdata1 += '<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>';

                            taxdata1 += '<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>';

                            taxdata1 += '</thead><tbody>';







taxdata1 +=  '<tr><td style="display:none;"></td><td><input type="hidden" name="ot_taxable_value[]" value="'+totalTax+'">'+totalTax+'</td><td><input type="hidden" name="ot_central_rate[]" value="'+halftaxrate+'">'+halftaxrate+'%</td><td><input type="hidden" name="ot_central_amount[]" value="'+totalCgst+'">'+totalCgst+'</td><td><input type="hidden" name="ot_state_rate[]" value="'+halftaxrate+'">'+halftaxrate+'%</td><td><input type="hidden" name="ot_state_amount[]" value="'+totalSgst+'">'+totalSgst+'</td></tr>'

   taxdata1 +='</tbody></rable>';

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



   $('#totalamtinwords_show').html(RsinWord(totalAmount));

   $('#totalamtinwords').val(RsinWord(totalAmount));

   

$('#taxamtinwords').val(RsinWord(totalTax));



$('#taxamtinwords_show').html(RsinWord(totalTax));



}







function Rs(amount){

var words = new Array();

words[0] = 'Zero';words[1] = 'One';words[2] = 'Two';words[3] = 'Three';words[4] = 'Four';words[5] = 'Five';words[6] = 'Six';words[7] = 'Seven';words[8] = 'Eight';words[9] = 'Nine';words[10] = 'Ten';words[11] = 'Eleven';words[12] = 'Twelve';words[13] = 'Thirteen';words[14] = 'Fourteen';words[15] = 'Fifteen';words[16] = 'Sixteen';words[17] = 'Seventeen';words[18] = 'Eighteen';words[19] = 'Nineteen';words[20] = 'Twenty';words[30] = 'Thirty';words[40] = 'Forty';words[50] = 'Fifty';words[60] = 'Sixty';words[70] = 'Seventy';words[80] = 'Eighty';words[90] = 'Ninety';var op;

amount = amount.toString();

var atemp = amount.split(".");

var number = atemp[0].split(",").join("");

var n_length = number.length;

var words_string = "";

if(n_length <= 9){

var n_array = new Array(0, 0, 0, 0, 0, 0, 0, 0, 0);

var received_n_array = new Array();

for (var i = 0; i < n_length; i++){

received_n_array[i] = number.substr(i, 1);}

for (var i = 9 - n_length, j = 0; i < 9; i++, j++){

n_array[i] = received_n_array[j];}

for (var i = 0, j = 1; i < 9; i++, j++){

if(i == 0 || i == 2 || i == 4 || i == 7){

if(n_array[i] == 1){

n_array[j] = 10 + parseInt(n_array[j]);

n_array[i] = 0;}}}

value = "";

for (var i = 0; i < 9; i++){

if(i == 0 || i == 2 || i == 4 || i == 7){

value = n_array[i] * 10;} else {

value = n_array[i];}

if(value != 0){

words_string += words[value] + " ";}

if((i == 1 && value != 0) || (i == 0 && value != 0 && n_array[i + 1] == 0)){

words_string += "Crores ";}

if((i == 3 && value != 0) || (i == 2 && value != 0 && n_array[i + 1] == 0)){

words_string += "Lakhs ";}

if((i == 5 && value != 0) || (i == 4 && value != 0 && n_array[i + 1] == 0)){

words_string += "Thousand ";}

if(i == 6 && value != 0 && (n_array[i + 1] != 0 && n_array[i + 2] != 0)){

words_string += "Hundred and ";} else if(i == 6 && value != 0){

words_string += "Hundred ";}}

words_string = words_string.split(" ").join(" ");}

return words_string;}

function RsinWord(n){

nums = n.toString().split('.')

var whole = Rs(nums[0])

if(nums[1]==null)nums[1]=0;

if(nums[1].length == 1 )nums[1]=nums[1]+'0';

if(nums[1].length> 2){nums[1]=nums[1].substring(2,length - 1)}

if(nums.length == 2){

if(nums[0]<=9){nums[0]=nums[0]*10} else {nums[0]=nums[0]};

var fraction = Rs(nums[1])

if(whole=='' && fraction==''){op= 'Zero only';}

if(whole=='' && fraction!=''){op= 'paise ' + fraction + ' only';}

if(whole!='' && fraction==''){op='Rupees ' + whole + ' only';} 

if(whole!='' && fraction!=''){op='Rupees ' + whole + 'and paise ' + fraction + ' only';}

amt=document.getElementById('amt').value;

if(amt > 999999999.99){op='Oops!!! The amount is too big to convert';}

if(isNaN(amt) == true ){op='Error : Amount in number appears to be incorrect. Please Check.';}

document.getElementById('op').innerHTML=op;}}

        </script>

		

		

    

          

          <!--company_sun

quant_sun

unit_sun

amount_sun





taxid

taxincl

taxtype

taxrate

taxamount

finalamount

finalamount_show_amount





rmove Class

genete id

call function-->

          

            </p>

    </div>



</section>

Youez - 2016 - github.com/yon3zu
LinuXploit