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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /home/pateltimber.com/public_html/inventory2/newchallan_10_13_21.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"> <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 

									   		for($y=date('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);

                        }

                    });	

}

function getCalulation(rowId)

{

 var rowCount = document.getElementById('purchaseDetail').rows.length;





 

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

	

	

	allTaxCalculation();



 if(rowId == rowCount-1 && (sun_company !=0 && quant_sun!='' && unit_sun!='' && amount_sun!=''))

 {

 	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 == ''){

                            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