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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /home/pateltimber.com/public_html//inventory_new/newchallan.php
<?php

if(isset($_REQUEST['action']) && (isset($_REQUEST['order_id']) && !empty($_REQUEST['order_id'])) && !isset($_SESSION['bow'])){

    $recordid = $_REQUEST['order_id'];
    $custid =  getvalue("customerid","tbl_challan_entry"," where id = '".$recordid."'");
    $isBow  =  getvalue("bow","tbl_customer"," where cust_id = '".$custid."'");
    if($isBow != 1){
        ?>
<script>
            window.location.href = "index.php?page=<?php echo $page;?>";
        </script>
<?php
        exit();
    }
} 
else   if(isset($_REQUEST['estimate_id']))
{
	$orderdetials  = selectfetch("*","tbl_estimate_entry as o"," WHERE id = '".$orderid."'");
	$orderid = $_REQUEST['estimate_id'];
	$officeid = $orderdetials->office_id;
    $customerid = $orderdetials->customerid;
	$custid =  getvalue("customerid","tbl_challan_entry"," where id = '".$recordid."'");

                                    $totaltaxamount = $orderdetials->total_tax;
}
 $orderdate = date('d-m-Y');
$taxid = 2;
$taxname = "GST";
$taxtype = 1;
$taxrate = 18;
$tax_incl = 0;
$tax_rate =18;
$tax_type=1;


?>
<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 = '';
 $disable='';
$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'])){

} ?>
<style>

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

    }
	label.error {
    font-size: 12px;
    display: block;
    margin-top: 5px;
    font-weight: normal;
    color: #F44336;
}
</style>
<section class="content">
<div class="container-fluid">
<div class="block-header">
  <h2>Delivery Challan Entry</h2>
</div>
<div class="">
 
	
	 <div   id="addcard"  class="panel panel-primary <?php    if (!isset($_REQUEST['action']) && !isset($_REQUEST['estimate_id'])) { echo "hideme"; }    ?>" >
      <div   id=""  class="panel panel-primary " >
    <div class="panel-heading">
      <h2 class="panel-title"> <?php echo $Title; ?> <small></small> </h2>
    </div>      
		   	
  </div>
    <div class="panel-body">
      <div class="row clearfix">
        <form method="post" action="" id="frm" name="frm">
          <?php

 if(isset($_REQUEST['estimate_id']))
{
	$orderdetials  = selectfetch("*","tbl_estimate_entry as o"," WHERE id = '".$orderid."'");
	$orderid = $_REQUEST['estimate_id'];
	$order_id = $_REQUEST['estimate_id'];
	$officeid = $orderdetials->office_id;
    $customerid = $orderdetials->customerid;
	$custid =  getvalue("customerid","tbl_challan_entry"," where id = '".$recordid."'");
 // Product List
   $sunmica_query  = select("*","tbl_estimate"," where o_id = '".$orderid."'");
   
   //Amount Detail
   $total_amount = $orderdetials->total_amount;
   $total_amount_words = $orderdetials->total_amount_words;
   $taxable_value = $orderdetials->taxable_value;
    $central_tax = $orderdetials->central_tax;
    $state_tax = $orderdetials->state_tax;
 $taxesdetails_qry = select("*","estimate_taxes_table","where order_id = '".$orderid."'");
         $total_tax_words = $orderdetials->total_tax_words;                                       

 
}else
{
	 $orderid  = $_REQUEST['order_id'];
	  $order_id  = $_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 ";
     }
	 $totaltaxamount = $orderdetials->total_tax;
	 $orderdate  = $orderdetials->order_date;
     if(!empty($orderdate) && ($orderdate != "0000-00-00")){
         $orderdate = date('d-m-Y',strtotime($orderdate));
     } else
	 {
	 	$orderdate = date('d-m-Y');
	 }
	 $officeid = $orderdetials->office_id;
	 $customerid = $orderdetials->customerid;
	 
	  // Product List
   $sunmica_query  = select("*","tbl_challan"," where o_id = '".$orderid."'");
	 
	 
	 
	 // Amount and tax detail
	 
	    $total_amount = $orderdetials->total_amount;
                               
                                    $total_amount_words = $orderdetials->total_amount_words;
                               
                                    $taxable_value = $orderdetials->taxable_value;
                                
                                    $central_tax = $orderdetials->central_tax;
                               
                                    $state_tax = $orderdetials->state_tax;
                               
                                    $total_tax_words = $orderdetials->total_tax_words;
                             
	  $taxesdetails_qry = select("*","challan_taxes_table","where order_id = '".$order_id."'");
                                           
	 
}
                                



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


                                


                                
                                

                                $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;
                                }
								
								
								
                             
                                 


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


                            ?>
          <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>
              <?php   if(isset($_REQUEST['action']) || $_REQUEST['action'] == 'edit' || $_REQUEST['action'] == 'view'){ ?>
              <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="text" 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>
              <?php } ?>
            </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">
              <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 if(isset($_SESSION['bow']) &&  $_SESSION['bow'] == 2  )
					 { 
					 	$query_customer = select("*","tbl_customer","where  cust_id IS NOT NULL  order by cust_name ");
					 }
					 else
					 { 
					 	$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>
              <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>
          <div id="challanblock">
            <div class="col-md-12">
              <div class="row">
                <div class="col-md-12">
                  <div class="table-responsive">
                    <div id="challanblock">
                      <table class="table table-bordered table-striped " id="purchaseDetail" style="table-layout:fixed;">
                        <thead>
                        <th>Particulars </th>
                          <th  >Quantity</th>
                          <th>Unit</th>
                          <th>Rate/Item</th>
                          <th >Amount</th>
                          <th>Action</th>
                          </thead>
                        <tbody>
                          <?php   if(isset($_REQUEST['action']) || $_REQUEST['action'] == 'edit' || $_REQUEST['action'] == 'view' || (isset($_REQUEST['estimate_id']) && $_REQUEST['estimate_id']!='')){

                                                            $x=1;
                                                            while($row_sunmica = mysql_fetch_array($sunmica_query)){  ?>
                          <tr>
                            <td><select  <?php echo $disable; ?>   name="company_sun[]" class="   company_sun   " id="company_sun_<?php echo $x; ?>" onchange="checkProduct(this.value,this.id); getProductAmount(this.value,<?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>
                            </td>
                            <td><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; ?>)">
                            </td>
                            <td><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>
                            </td>
                            <td><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; ?>)">
                              <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="productRate[]" value="<?php echo $row_sunmica['ammount']* $row_sunmica['goods_quantity']; ?>" class="productRate" id="productRate_<?php echo $x; ?>">
                            </td>
                            <td><input  readonly="readonly" name="final_amount_sun[]"  class="form-control finalamount " value="<?php echo $row_sunmica['final_amount']; ?>"  id="finalamount_<?php echo $x; ?>">
                            </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;
}
else
{
                                                           
  $x=1; ?>
                          <tr>
                            <td><select id="company_sun_<?php echo $x; ?>" class="company_sun "  name="company_sun[]" onchange="checkProduct(this.value,this.id); getProductAmount(this.value,<?php echo $x; ?>);">
                                <option value='0'>- Search Product -</option>
                              </select></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"  >
                                    <?php echo $unit_sunopt; ?>
                                  </select>
                                </div>
                              </div></td>
                            <td><input type="number" min="0"   name="amount_sun[]"  class="form-control amount amount_sun" id="amount_sun_1"  onchange=" getCalulation(1)">
                              <input type="hidden" name="tax_amount_sun[]" value="" class="taxamount" id="taxamount_1">
                              <input type="hidden" name="productRate[]" value="" class="productRate" id="productRate_1">
                            </td>
                            <td><input type="text" readonly="readonly" name="final_amount_sun[]" value="" class="finalamount form-control" id="finalamount_1">
                            </td>
                            <td data-title="Action"><i title="Delete Row" class="material-icons delete">delete</i></td>
                          </tr>
                          <?php } ?>
                        </tbody>
                      </table>
                    </div>
                    <!-- /table#table-data -->
					
                  </div>
                </div>
              </div>
            </div>
			<?php   if(!isset($_REQUEST['action']) || $_REQUEST['action'] != 'view'){ ?>
            <div class="" style="margin-bottom: 20px;">
              <div class="col-md-5"> <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>  </div>
				<?php   if(!isset($_REQUEST['action']) || $_REQUEST['action'] != 'view'){ ?>
                    <button type="button" id="addProduct" class="btn btn-info" onclick="addNewProduct()" > +</button>
					<?php } ?>
				
				
            </div>
			<?php } ?>
            <div class="row">
              <div class="col-md-12">
                <div class="col-md-3 col-sm-3 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 "  value="<?php echo $labour; ?>" min="0" autofocus onchange="allTaxCalculation()">
                    </div>
                  </div>
                </div>
                <div class="col-md-3 col-sm-3 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 "  value="<?php echo $freight; ?>"  min="0" onchange="allTaxCalculation()"  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="freight"> Total Item Cost</label>
                      <input type="number" readonly="readonly" class="form-control"  placeholder="Total Product charges " id="total_particular_amount"  value=""  min="0"  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="freight">Total Amount</label>
                      <input type="text" class="totalamount form-control" name="totalamount" value="<?php echo $total_amount;?>">
                     
                    </div>
                  </div>
                </div>
              </div>
            </div>
			<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
                - Amount (in words) - <b  class="totalamtinwordsTxt" ><?php echo $total_amount_words;?></b>
                <input type="hidden" name="total_amount_words" class="totalamtinwords" value="<?php echo $total_amount_words;?>">
              </div>
              
            </div>
            <!-- sunmica ends-->
            <!-- Tax applied ends-->
            <!-- Tax Detials start -->
            <div class="col-md-12">
              <label class="alert alert-info text-center sectionheaders" ></label>
              <table class="table table-bordered table-striped " id="veneerstable">
                <thead>
                  <tr >
                    <th class="sectionheaders" colspan="6" style="background:#0099FF; color:#fff" >TAXES
                      DETAILS</th>
                  </tr>
                  <tr>
                    <th rowspan="2" class="text-center">Sr</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
                                     
				if(isset($order_id) && $order_id !=='')
				{
                                            while($taxesdetail_row =mysql_fetch_array($taxesdetails_qry))
                                            { ?>
                  <tr>
                    <td>1<input type="hidden" name="ot_hsn[]" value="<?php echo $taxesdetail_row['ot_hsn']; ?>"></td>
                    <td><input type="text" readonly="readonly" name="ot_taxable_value[]" class="form-control totalTaxAmount" value="<?php echo $taxesdetail_row['ot_taxable_value']; ?>"></td>
                    <td><input type="text" readonly="readonly" name="ot_central_rate[]"  class="form-control central_rate" value="<?php echo $taxesdetail_row['ot_central_rate']; ?>"></td>
                    <td><input type="text" readonly="readonly" name="ot_central_amount[]"   class="form-control central_tax" value="<?php echo $taxesdetail_row['ot_central_amount']; ?>"></td>
                    <td><input type="text" readonly="readonly" name="ot_state_rate[]" class="form-control state_rate" value="<?php echo $taxesdetail_row['ot_state_rate']; ?>"></td>
                    <td><input type="text" readonly="readonly" name="ot_state_amount[]" class="form-control state_tax"  value="<?php echo $taxesdetail_row['ot_state_amount']; ?>"></td>
                  </tr>
                  <?php   }   
				  }
				  else
				  {?>
                  <tr>
                    <td >1
                      <input type="hidden" name="ot_hsn[]" value="">
                    </td>
                    <td><input type="text" readonly="readonly" name="ot_taxable_value[]" value=""  class="form-control totalTaxAmount"></td>
                    <td><input type="text" readonly="readonly" name="ot_central_rate[]"  class="form-control central_rate" value=""></td>
                    <td><input type="text" readonly="readonly" name="ot_central_amount[]"  class="form-control central_tax" value=""></td>
                    <td><input type="text" readonly="readonly" name="ot_state_rate[]" class="form-control state_rate" value=""></td>
                    <td><input type="text" readonly="readonly" name="ot_state_amount[]" class="form-control state_tax" value="">
                    </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" > Total
                - Taxable value:
                <input type="text" readonly="readonly" name="taxable_value"   class=" totalamount " style="width:100px" value="<?php echo $taxable_value; ?>">
                Central Tax:
                <input type="text" readonly="readonly"  name="central_tax" class="central_tax"  style="width:100px" value="<?php echo $central_tax; ?>">
                State Tax:
                <input type="text" readonly="readonly"  name="state_tax" class="state_tax"  style="width:100px" value="<?php echo $state_tax; ?>">
              </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) : <b class="taxamtinwordsTxt"><?php echo $total_tax_words; ?></b>
                <input type="hidden" readonly="readonly" name="taxamount" class="totalTaxAmount" value="<?php echo  $totaltaxamount; ?>">
                <input type="hidden" name="taxamtinwords" id="taxamtinwords" class="taxamtinwords" value="<?php echo $total_tax_words; ?>">
                </label>
              </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 totalamount" placeholder="Amount Paid " value="<?php echo $pay_amount; ?>" min="0"  autofocus>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
		  <?php   if(!isset($_REQUEST['action']) || $_REQUEST['action'] != 'view'){ ?>
		  
          <div class="col-md-12"> 
		  
		  
            <button  type="button"  class="btn btn-info m-t-15 waves-effect" onclick="recalcuate()">Recalculate Challan</button>
		  <span class="btn waitbutton    btn-danger" >Wait... </span>
            <button type="button"   id="button2" value="<?php echo $Title; ?>" class="btn btn-primary m-t-15 waves-effect dontshow" ><?php echo $Title; ?> Record</button>
            <input type="hidden" name="button"  value="<?php echo $Title; ?>" >
            <button   id="cancel" class="btn btn-primary m-t-15 waves-effect">Cancel </button>
          </div>
		  <?php } ?>
        </form>
      </div>
    </div>
	
	</div>
	
	
	<div class="panel padding_20 panel-default  listingview  <?php if(isset($_REQUEST['action']) || $_REQUEST['estimate_id']){ echo " hidden ";  }   ?>  ">

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

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

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

                    </div>
                </div>







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


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

                                    <label>Financial Year :</label>

                                  <select name="financial_year" id="financial_year" class="form-control ">
                                       <?php 
if(date('m') < 4){
  $y=date('y')-1;
}else{
   $y=date('y');
}
									   		for($y;$y>17;$y--)
											{
									   ?>
										<option value="<?php echo $y.$y+1 ?>" > 20<?php echo $y ?>-20<?php echo $y+1 ?> </option>
										<?php } ?>
                         
                                    </select>


                                </div>


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



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

                                    <label>Challan no :</label>

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


                                </div>



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

                                    <label>Party :</label>

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


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

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


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


                                        }

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


                                </div>



                            <?php }else{  ?>



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

                                    <label>Challan no :</label>

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


                                </div>



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

                                    <label>Party :</label>

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


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

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


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


                                        }

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


                                </div>


                            <?php   }   ?>

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

                                  <?php  }else{ ?>

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

                                  <?php  } ?>
                               </span>









                        </div>



                    </div>


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

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

                    </div>
                </div>



            </div>



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

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

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

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

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




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

            </div>

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

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

	

</div>
</section>
<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>
<?php include('add_customer_script.php') ?>
<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');
                    }

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






                        }
                    });

                }


            }

        $(document).ready(function(){
		
		//alert(numberToWords(856321.68));
	

			  var productRate = 0;
                  $('.productRate').each(function () {
                   if (!isNaN($(this).val()) && $(this).val().length !== 0) {
                      productRate += parseFloat($(this).val());
	                 }
                  });
	var total_particular_amount = Number(productRate);
	$('#total_particular_amount').val(total_particular_amount);
			$('.unit_sun').select2();			
			$('.select2').select2();
			
			
			
			
			

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

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

                });
				$('body').on('change','#financial_year',function(){

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

                });

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

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









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

			
        });
// Prpare Product List using ajax
$(window).load(function () {
     <?php   if(isset($_REQUEST['action']) || $_REQUEST['action'] == 'edit' || $_REQUEST['action'] == 'view'){

                                                            $sunmica_query  = select("*","tbl_challan"," where o_id = '".$orderid."'");
                                                            $x=1;
                                                            while($row_sunmica = mysql_fetch_array($sunmica_query)){  ?>
 			select2lists('company_sun_<?php echo $x ?>');
		
			<?php	 $x++; } 
			
			}else if(isset($_REQUEST['estimate_id']) && $_REQUEST['estimate_id'] !=''){

                                                            $sunmica_query  = select("*","tbl_estimate"," where o_id = '".$orderid."'");
                                                            $x=1;
                                                            while($row_sunmica = mysql_fetch_array($sunmica_query)){  ?>
														
 			select2lists('company_sun_<?php echo $x ?>');
		
			<?php	 $x++; } 
			
			}else
			{?>
 			select2lists('company_sun_1');
			<?php } ?>
			validateform();
});

    function select2lists(id) {
	//alert(id);
	$('.unit_sun').select2();
            $("#"+id).select2({
                ajax: {
                    url: "ajax/getData.php",
                    type: "post",
                    dataType: 'json',
                    delay: 250,
                    data: function (params) {
                        return {
                            searchTerm: params.term // search term
                        };
                    },
                    processResults: function (response) {
				//	alert(response);
                        return {
                            results: response
                        };
                    },
                    cache: true
                }
            });
	} 
// Add new Row for product
function addNewProduct() {    
	   
				var rowCount = document.getElementById('purchaseDetail').rows.length;
        //    e.preventDefault();
            var html = '';
				html += '<tr>';
				html += '<td><select id="company_sun_'+rowCount+'" class="company_sun "  name="company_sun[]"  onchange="checkProduct(this.value,this.id); getProductAmount(this.value,'+rowCount+');"><option value="0">- Search Product -</option></select></td>';
                html += '<td><input  id="quant_sun_'+rowCount+'" type="number" min="0" name="quant_sun[]"  class="form-control quant_sun" placeholder="Quantity :" value="" onchange=" getCalulation('+rowCount+')"></td>';
				html += '<td><select  id="unit_sun_'+rowCount+'" data-container="body" name="unit_sun[]" class="form-control    unit_sun  select2 "  ><?php echo $unit_sunopt; ?></select></td>';
				html += '<td><input id="amount_sun_'+rowCount+'" type="number" min="0"   name="amount_sun[]"  class="form-control amount amount_sun" onchange=" getCalulation('+rowCount+')"><input type="hidden" name="tax_amount_sun[]" value="" class="taxamount" id="taxamount_'+rowCount+'"><input type="hidden" name="productRate[]" value="" class="productRate" id="productRate_'+rowCount+'"></td>';
                html += '<td><input id="finalamount_'+rowCount+'" type="text" readonly="readonly" name="final_amount_sun[]" value="" class="finalamount form-control"></td>';
				html += '<td><i title="Delete Product " class="material-icons delete">delete</i></td>';
	
				html += '</tr>';

            $('#purchaseDetail').append(html);
			
			select2lists('company_sun_'+rowCount);
			
			
        }
		
		      $('table').on('click', '.delete', function (e){
                    e.preventDefault();
                    var currentitem = $(this);
                    currentitem.parent().parent().remove();
					  var productRate = 0;
                  $('.productRate').each(function () {
                   if (!isNaN($(this).val()) && $(this).val().length !== 0) {
                      productRate += parseFloat($(this).val());
	                 }
                  });
	var total_particular_amount = Number(productRate);
	$('#total_particular_amount').val(total_particular_amount);
                    allTaxCalculation();
                });
// Check Product Availablity
function checkProduct(companythis,rowId)
{

                    var exist = 0;
                    $('.company_sun').each(function(){
					
                        var company =  $(this).val();
                        if((company.length != 0) && (company == companythis)){
                            exist++;
                            if(exist == 2){
                               $(this).val(0);
                               //$(this).select2('destroy');
                                select2lists(rowId);
								alert("Product already Selected !");
                                warning("Info :","Product already Selected !");
                                return false;
                            }
                        }
                    });
						
}
function getProductAmount(companythis,rowId)
{
var cust_id =  $('#customer').val();
 $.ajax({
                        type: "POST",
                        url: "ajax/product_rate_detail.php",
                        data: "cust_id="+cust_id+"&prod_id="+companythis,
                        success: function(html)
                        {
							  var custdata = $.parseJSON(html);
                            //  console.log(custdata);
                            $("#amount_sun_"+rowId).val(custdata.amount);
							 getCalulation(rowId)
                        }
                    });	
}
function recalcuate()
{
	var i = 1;
	 var rowCount = document.getElementById('purchaseDetail').rows.length;
	 for(i;i<rowCount;i++)
	 {
			  amountCalculation(i);
 
	 }
	
	
	
	allTaxCalculation();

}
function amountCalculation(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 = <?php echo $tax_rate; ?>;
	var tot_amount = parseInt(amount_sun * quant_sun);
	var taxAmount = (tot_amount * taxrate)/118;
	$('#taxamount_'+rowId).val(taxAmount.toFixed(2));
	var finalAmount = tot_amount - taxAmount;
	$('#finalamount_'+rowId).val(finalAmount.toFixed(2));
	$('#productRate_'+rowId).val(tot_amount.toFixed(2));
	
		  var productRate = 0;
                  $('.productRate').each(function () {
                   if (!isNaN($(this).val()) && $(this).val().length !== 0) {
                      productRate += parseFloat($(this).val());
	                 }
                  });
	var total_particular_amount = Number(productRate);
	
	$('#total_particular_amount').val(total_particular_amount);
	

}
function getCalulation(rowId)
{
 var rowCount = document.getElementById('purchaseDetail').rows.length;

 amountCalculation(rowId);
 
	
	
	allTaxCalculation();

 if(rowId == rowCount-1 && ( $('#finalamount_'+rowId).val()!='' && $('#finalamount_'+rowId).val()>0 ))
 {
 	addNewProduct();
 }


}
function allTaxCalculation()
{


	var labour = $('#labour').val();
	var freight = $('#freight').val();
var productRate = $('#total_particular_amount').val();



var totalAmount = parseFloat(Number(productRate) + Number(labour) + Number(freight)).toFixed(2);
$('#totalamount_show').html(totalAmount);
$('.totalamount').val(totalAmount);
var totalAmountWord = RsPaise(totalAmount);
$('.totalamtinwords').val(totalAmountWord);
$('.totalamtinwordsTxt').html(totalAmountWord);

 var totalTaxAmount = (totalAmount * 18)/118;
 

		var totalTax =  parseFloat(totalTaxAmount).toFixed(2);
		var totalCgst = parseFloat(totalTax/2).toFixed(2);
    	var totalSgst = parseFloat(totalTax/2).toFixed(2);
		
var totalTaxWord = 		RsPaise(totalTaxAmount);
	 $('.taxamtinwords').val(totalTaxWord);
	 	 $('.taxamtinwordsTxt').html(totalTaxWord);
 $('.totalTaxAmount').val(totalTax);		
 $('.central_tax').val(totalCgst);
$('.state_tax').val(totalSgst);
$('.central_rate').val('9 %');
$('.state_rate').val('9 %');


validateform();



}

</script>

<script>

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


 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');
                                }
});
               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();
                    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 == '' || product == 0){
                            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){
					formerror == 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('');

                        }

                    });
					
					
					 $(".finalamount").each(function(){

                        var finalamount   =  $(this).val();
					
                        if(finalamount  == '' || finalamount == 0 || finalamount == 0.00){
	
                            formerror = 1;

                            var errormsg = "Amount should be more than 0";
                            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');
						$('#button2').removeClass('dontshow');
                    }


                    formerror = 0;



                }
 $(document).ready(function(){



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

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

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


                                    }

                                    thisbutton.addClass('ok');
                                    thisbutton.html('Submit');

                                }
                            });

                        }



                    }




                });






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

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



var payable = $('.totalamount').val();

	$('#pay_amount').val(payable);


                        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>
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 RsPaise(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= '' + fraction + ' paise only';}
if(whole!='' && fraction==''){op='' + whole + ' Rupees only';} 
if(whole!='' && fraction!=''){op='' + whole + ' Rupees and ' + fraction + ' Paise only';}
return op;
}}



</script>

Youez - 2016 - github.com/yon3zu
LinuXploit