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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /home/pateltimber.com/public_html/inventory/inventory/estimate.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_estimate_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();
    }
} ?>


<style>

    .finalamount_show{

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






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





    $order_entry_data = array(
        'party_return'=>1
    );


    update("tbl_estimate_entry",$order_entry_data, "where 	customerid = '".$_REQUEST['customer_return']."'");
    $customerreturn = $_REQUEST['customer_return'];



    $estimateno = $_REQUEST['estimate_id'];

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


    ?>
    <script>
        location.replace("index.php?page=newchallan&estimate_id=<?php echo $estimateno; ?>");
    </script>


    <?php
    //echo "welcome".$_REQUEST['customer_return'];

    exit();

}







$curpage =  $_REQUEST['page'];
$self = "index.php?page=".$curpage;


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

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

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


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


    $Title = 'View';
}

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

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

        
    
    //  $totalorders = getvalue("MAX(challan_number)"," tbl_estimate_entry","where challan_number like '%".$fystart.$fyend."' AND cancel IS NULL ");
    $totalorders = getvalue("MAX(challan_number)"," tbl_estimate_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_estimate_entry","where cancel IS NULL ");

    /*  new code start  */

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

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


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

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

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

        $totalorders_number = "0".$totalorders_number;

    }


    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  = "estimate_directory";
    // $pdf_name = $_POST['pdf_name'];



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


    $order_entry_data = array(
        'office_id'=>$officeid,
        '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'],
        'freight'=>$_POST['freight'],
        'labour'=>$_POST['labour'],
    );








    insert('tbl_estimate_entry',$order_entry_data);

    $order_id = mysql_insert_id();








// taxdata insert

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

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

            $estimate_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('estimate_taxes_table',$estimate_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_estimate',$sunmicadata);

                $x++;
            }
        }
    }




    $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,
            '[[rupees]]' => $totalamount,
            '[[orderdate]]' => $orderdate
        );
        send_sms("party_estimate",$customerid,$custname,$customer_mobile,$smsdata);
        send_sms("admin_estimate",0,'ADMIN1',$admin_mobile,$smsdata);
        send_sms("admin_estimate",0,'ADMIN2',$admin2_mobile,$smsdata);

    }







    $stat = 'Estimate  Added Successfully ';

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




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



    /*   if(isset($_REQUEST['dash'])){
           echo '<script type="text/javascript">window.location="estimate_generate_pdf.php?order_id='.$order_id.'&pdf_name='.$pdf_name.'&pdf_directory='.$pdf_directory.'&dash=true";</script>';
           exit();
       }
       echo '<script type="text/javascript">window.location="estimate_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=estimate";</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_estimate_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  = "estimate_directory";
    $pdf_name = $_POST['pdf_name'];





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




    $order_entry_data = array(
        'office_id'=>$officeid,
        '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'],
        'freight'=>$_POST['freight'],
        'labour'=>$_POST['labour'],
    );




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

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



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













// taxdata insert

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

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

            $estimate_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('estimate_taxes_table',$estimate_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_estimate',$sunmicadata);



                $x++;
            }
        }
    }




    // sms send for new challan

    // second party condition
    if($bowtype != 2 || true ){
        $customerdata = selectfetch('cust_name,cust_contact','tbl_customer'," where cust_id = '".$customerid."'");
        $custname = $customerdata->cust_name;
        $customer_mobile = $customerdata->cust_contact;
        $smsdata = array(
            '[[username]]' => $custname,
            '[[no]]'       => $_POST['pdf_name'],
            '[[rupees]]'   => $totalamount,
            '[[orderdate]]'=> $orderdate
        );
        // send_sms("party_estimate_edit",$customerid,$custname,$customer_mobile,$smsdata);
        send_sms("admin_estimate_edit",0,'ADMIN1',$admin_mobile,$smsdata);
        send_sms("admin_estimate_edit",0,'ADMIN2',$admin2_mobile,$smsdata);


    }








    $stat = 'Updated successfully';


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


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


    ?>


    <?php


    /*  echo '<script type="text/javascript">window.location="estimate_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=estimate";</script>';
    exit();



}




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

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


      // add stock ...







  // board data

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

      $stat = "Order Calcelled ";

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


   */
} ?>

<style>

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

    }
</style>





<?php


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


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



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

</script>



<?php     ?>



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




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




                            <!-- Veeners data start-->

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


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



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

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

                            ?>

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


                            <?php


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

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

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





                            <!-- Veeners data close-->











                            <!-- sunmica data-->

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


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

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



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



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

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

                            ?>

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








                            <?php

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

                            ?>

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


                            <?php

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

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


                            <!-- sunmica data close-->





                            <!-- Board data-->

                            <?php

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

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

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


                            <?php


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

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

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

                            <!-- Board data close-->










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


                                $orderid  = $_REQUEST['order_id'];




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


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

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



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


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


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

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

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



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


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


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



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


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

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





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

                                /* $boards


                                   $veneers


                                   $taxes */


                                ?>



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

<!--                                <div class="col-md-12">-->
<!--                                    <div class="form-group">-->
<!--                                        <label>From Office :</label>-->
<!--                                    </div>-->
<!--                                </div>-->


                                <div class="col-md-6 col-sm-6 col-xs-12">
                                    <div class="form-group input-group">
                                        <label>From Office :</label>
                                        <select  <?php echo $disable; ?>     name="office" id="office" onChange="" class="form-control  select2 "  data-live-search="true" required autofocus >
                                            <option value=""> Select Office </option>
                                            <?php $query_office = select("*","tbl_office_details","where status='Enabled' order by office_name ");
                                            while($row_office = mysql_fetch_array($query_office))
                                            {
                                                ?>
                                                <option value="<?php echo $row_office['office_id']; ?>" <?php echo selected($officeid,$row_office['office_id']); ?>><?php echo $row_office['office_name']; ?></option>
                                                <?php
                                            }
                                            ?>
                                        </select>
                                    </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">Estimate 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="order_date">Estimate Number</label>
                                            <input  <?php echo $disable; ?>   readonly  type="hidden" id="challan_number" name="challan_number" class="form-control " value="<?php echo $challan_number; ?>" placeholder="estimate number :" autofocus>

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

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

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


                                    <div class="row">









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

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

                                                        <div class="form-group input-group">
                                                            <label for="bow">User type  :</label>
                                                            <select id="bow"   name="bow" class="form-control ">
                                                                <option  value="1" >type one </option>
                                                                <option  value="2"  >type two</option>
                                                            </select>
                                                        </div>
                                                    </div>
                                         </span>  */ ?>


                                    </div>





                                </div>




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

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


                                            <?php }   ?>




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



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


                                    <div class="row">

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

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

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

                                                </div>
                                            </div>

                                        <?php }else{ ?>

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

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

                                    </div>
                                </div>

                                      <?php  }?>






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

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



                                    </div>



                                </div>



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


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


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


                                <div id="challanblock">







                                    <!-- sunmica starts-->

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


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



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

                                                <div class="table-responsive">

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

                                                        <table class="table table-bordered table-striped " id="sunmicatable" style="table-layout:fixed;">
                                                            <thead>
                                                            <th style="width:50px;">Particulars</th>
                                                            <th style="width: 30px;">Quantity</th>
                                                            <th style="width: 26px;">Unit</th>
                                                            <th style="width: 30px;">Rate</th>
                                                            <th style="width: 30px;">Amount</th>
                                                            <?php if(isset($_REQUEST['action']) && ($_REQUEST['action'] != 'view')){ ?>
                                                                <th style="width:20px">Action</th>
                                                            <?php } ?>
                                                            </thead>
                                                            <tbody>


                                                            <?php


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

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


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



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





                                                                                    ?>
                                                                                    <option value="<?php echo $row_company['product_id']; ?>"   <?php echo selected($row_sunmica['goods_company'],$row_company['product_id']); ?>><?php echo $filterproduct; ?></option>
                                                                                <?php } ?>
                                                                            </select>
                                                                        </div>
                                                                    </td>
                                                                    <!-- <td data-title="Rake">
                                                                <div class="form-group input-group">
                                                                    <select  <?php echo $disable; ?>   data-container="body" name="rake_no_sun[]"  id="rake_no_sun_<?php echo $x; ?>"  class="form-control   rake_no_sun  select2 ">
                                                                        <?php

                                                                    $rake_no_sunopt  = "";
                                                                    $rake_no_sunopt .= '<option value="">Select Rake</option>';
                                                                    $query_rake = select("*","tbl_rake","where rake_status='Enabled'");
                                                                    while($row_rake = mysql_fetch_array($query_rake))
                                                                    {  ?>
                                                                            <option value="<?php echo $row_rake['r_id']; ?>"  <?php echo selected($row_sunmica['goods_rake'],$row_rake['r_id']); ?>><?php echo $row_rake['rake_number']; ?></option>
                                                                        <?php } ?>
                                                                    </select>
                                                                </div>
                                                            </td>
                                                            <td data-title="Finish">
                                                                <div class="form-group input-group">
                                                                    <select   <?php echo $disable; ?>  data-container="body" name="finish_sun[]"  id="finish_sun_<?php echo $x; ?>"  class="form-control     finish_sun  select2 ">
                                                                        <?php

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


                                                            <td data-title="Code No."><div class="form-group input-group">
                                                                    <div class="  ">
                                                                        <input  <?php echo $disable; ?>  type="text" name="code_sun[]" id="code_sun_<?php echo $x; ?>" class="form-control code_sun" placeholder="Code No. :" value="<?php echo $row_sunmica['goods_code']; ?>"  autofocus>
                                                                    </div>
                                                                </div>
                                                            </td> -->

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



                                                                                <select  <?php echo $disable; ?>  data-container="body" name="unit_sun[]" class="form-control   unit_sun  select2 " id="unit_sun_<?php echo $x; ?>"  >
                                                                                    <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>
                                                                                    <option value="8"   <?php echo selected($row_sunmica['goods_unit'],8); ?>>SQ.FT.</option>



                                                                                </select>


                                                                            </div>
                                                                        </div>
                                                                    </td>
                                                                    <!--<td data-title="Purchase Date"><div class="form-group input-group">
                                                                                                    <div class="  ">
                                                                                                        <input type="text" name="purchase_date_sun[]" id="purchase_date_sun[]" class="form-control mydate" placeholder="Purchase Date :" value=""   autofocus>
                                                                                                    </div>
                                                                        </div>
                                                                    </td> -->

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




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




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

                                                            ?>

                                                            </tr>










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

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


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




                                    </div>





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


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



                                        </div>

                                    </div>





                                    <!-- sunmica ends-->






                                    <div id="tax_applied">

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











                                    </div>


                                    <!-- Tax applied ends-->



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


                                    <!-- Tax Detials start -->


                                    <div id="tax_details">

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



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

                                            <?php   }    ?>

                                            </tbody>
                                        </table>



                                    </div>


                                    <!-- Tax Details ends -->


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







                                </div>













                            <?php  }else{ ?>

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

                                <?php
 
                                
                               // $totalorders = getvalue("MAX(challan_number)"," tbl_estimate_entry","where challan_number like '%".$fystart.$fyend."' AND cancel IS NULL ");
                               // $totalorders = getvalue("MAX(challan_number)"," tbl_estimate_entry te ","  join  tbl_customer tc on tc.cust_id  = te.cust_id where tc.bow == ".$_POST["bow"]." challan_number like '%".$fystart.$fyend."' AND cancel IS NULL ");

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

                                /*  new code start  */

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

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


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

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

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

                                    $totalorders_number = "0".$totalorders_number;

                                }



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


                                /*  new code ends  */





                                // $totalorders = $totalorders + 1;

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




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

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

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




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

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



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


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


                                }










                                ?>


 


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

                                    <div class="form-group input-group">
                                        <label>From Office :</label>
                                        <select    name="office" id="office" onChange="" class="form-control   select2 "  data-live-search="true" required autofocus >
                                            <option value=""> Select Office </option>
                                            <?php $query_office = select("*","tbl_office_details","where status='Enabled' order by office_name ");
                                            while($row_office = mysql_fetch_array($query_office))
                                            {
                                                ?>
                                                <option value="<?php echo $row_office['office_id']; ?>" <?php echo selected($officeid,$row_office['office_id']); ?>><?php echo $row_office['office_name']; ?></option>
                                            <?php } ?>
                                        </select>

                                    </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"> Estimate Date </label>
                                            <input type="text" id="order_date" name="order_date" class="form-control mydate" placeholder="Order Date :" value="<?php echo date('d-m-Y'); ?>" autofocus>
                                        </div>
                                    </div>
                                </div>


                                <div  style="display:none;"  class="col-md-3 col-sm-3 col-xs-12">

                                    <div class="form-group input-group">
                                        <div class="  ">
                                            <label for="challan_number"> Estimate Number </label>
                                            <input type="hidden" readonly id="challan_number" name="challan_number" class="form-control" placeholder="estimate number"  value="<?php echo $totalorders; ?>" autofocus>
                                            <input type="text" readonly id="challan_number" name="pdf_name" class="form-control" placeholder="estimate number"  value="<?php echo $pdf_name; ?>" autofocus>
                                        </div>
                                    </div>
                                </div>






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

                                    <div class="row">






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





                                    </div>

                                </div>



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




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



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


                                        </label>




                                        <?php } ?>




                                    </div>
                                </div>


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

                                    <div class="row">

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

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

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

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


                                        <?php }else{ ?>

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

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

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






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


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




                                    </div>


                                </div>




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


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


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





                                <div id="challanblock">

                                    <!-- order details starts-->

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

                                                <div class="table-responsive">

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

                                                        <table class="table table-bordered table-striped " id="sunmicatable"  style="table-layout:fixed;">
                                                            <thead>
                                                            <th style="width:50px;">Particulars  </th>
                                                            <th style="width:30px;">Quantity</th>
                                                            <th style="width:26px;">Unit</th>
                                                            <th style="width:30px;">Rate</th>
                                                            <th style="width:30px;">Amount</th>
                                                            <th style="width:20px">Action</th>
                                                            </thead>
                                                            <tbody>
                                                            <tr>




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

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


                                                                <td>
                                                                    <div class="form-group input-group">
                                                                        <div class=" ">
                                                                            <input  type="number" min="0"   name="amount_sun[]" id="amount_sun[]" class="form-control amount amount_sun">
                                                                        </div>
                                                                    </div>
                                                                    <input type="hidden" name="taxid_sun[]" class="taxid">
                                                                    <input type="hidden" name="tax_incl_sun[]"  class="taxincl">
                                                                    <input type="hidden" name="tax_type_sun[]" class="taxtype">
                                                                    <input type="hidden" name="tax_rate_sun[]" class="taxrate">
                                                                    <input type="hidden" name="tax_amount_sun[]" class="taxamount">
                                                                    <input type="hidden" name="final_amount_sun[]" class="finalamount">
                                                                    <!--<span class="amount_show"></span>--></td>
                                                                <td><input disabled="" class="form-control finalamount_show_amount disabled_amount" value=""></td>





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










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

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


                                    <div class="row" style="display:none;">
                                        <div ></div>



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


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


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



                                        </div>

                                    </div>




                                    <!-- order details ends-->





                                    <!-- Tax applied start-->



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


                                    <!-- Tax applied ends-->



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


                                    <!-- Tax Detials start -->


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


                                    <!-- Tax Details ends -->


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



                                </div>








                            <?php } ?>


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


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


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


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

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



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

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

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

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

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


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



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

                                <?php }?>
                            </div>


                        </form>

                    </div>

                </div>

            </div>




            <div class="panel padding_20 panel-default  listingview  <?php if(isset($_REQUEST['action'])){ 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;">Estimate List

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


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

                    </div>
                </div>









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





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



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

                                    <label>Estimate no :</label>

                                    <?php
                                    $option_dep = '';
                                    $qry_dep = select("id,order_pdf", "tbl_estimate_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 mb20">

                                    <label>Party Name:</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)) {
                                        $option_dep .= '<option value="' . $row_dep['cust_id'] . '"    ' . selected($row_dep['cust_id'], $_REQUEST['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 one select2">
                                        <option value=""> Select</option>
                                        <?php echo $option_dep; ?>
                                    </select>


                                </div>




                            <?php }else{  ?>

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

                                    <label>Estimate no :</label>

                                    <?php
                                    $option_dep = '';
                                    //$totalorders = getvalue("MAX(challan_number)"," tbl_estimate_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 ");

                                    $qry_dep = select("id,order_pdf", "tbl_estimate_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 mb20">

                                    <label>Party Name:</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)) {
                                        $option_dep .= '<option value="' . $row_dep['cust_id'] . '"     ' . selected($row_dep['cust_id'], $_REQUEST['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 one select2">
                                        <option value=""> Select</option>
                                        <?php echo $option_dep; ?>
                                    </select>


                                </div>



                            <?php   }   ?>

                            <div class="col-sm-4 mb20">
                                <label>Estimate Day passes ( > = ) </label>
                                <input type="number" id="days_search" name="days_search" class="form-control">
                            </div>


                            <div class="col-sm-4   ">
                                <label style="display: block;">Party Not return </label>
                                <input type="checkbox" name="not_return_search" id="not_return_search" class="filled-in chk-col-orange">
                                <label for="not_return_search">Party Not return </label>
                            </div>


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



        <?php /* if(isset($_REQUEST['cust_id']) && $_REQUEST['cust_id']!='') {


//            $amounts = selectfetch("total_amount,total_amount_paid","tbl_goods_return_entry"," where customerid = '".$_REQUEST['cust_id']."'");
            $total_amount = 0;
            $total_paid_amount = 0;
            $total = mysql_query("select SUM(total_amount) as totalAmount,
(select SUM(amount_paid) from tbl_estimate_payout
 where payout_customerid = customerid) as totalAmountPaid
 from tbl_estimate_entry where customerid = '".$_REQUEST['cust_id']."'");




            while ($tot_amount = mysql_fetch_array($total)) {
                if (!empty($tot_amount['totalAmount'])) {
                    $total_amount = $tot_amount['totalAmount'];
                }

                if (!empty($tot_amount['totalAmountPaid'])) {
                    $total_paid_amount = $tot_amount['totalAmountPaid'];
                }
                $total_remaining = $total_amount - $total_paid_amount;
            }


            ?>




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

                    <div class="row">
                        <div class="col-md-12 col-sm-12 col-xs-12 m-b-15"><button style="margin-top:0;"  class="btn btn-primary m-t-15 waves-effect  pull-right  pull-top" id="showaddform" > Add</button>
                        </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>Total Amount : <?php echo $total_amount; ?></label>
                            </div>

                            <div class="col-sm-4 ">
                                <label>Total Amount Paid : <?php echo $total_paid_amount; ?></label>
                            </div>

                            <div class="col-sm-4 ">
                                <label>Remaining Amount : <?php echo $total_remaining; ?></label>
                            </div>
                            <div class="clearfix"></div>

                            <div class="col-sm-4">
                                <input type="hidden" id="amount" name="amount" class="form-control modal_name" value="<?php echo $total_amount; ?>" placeholder="Enter Amount" autofocus>
                                <input type="hidden" id="total_paid_amount" name="total_paid_amount" class="form-control modal_name" value="<?php echo $total_paid_amount; ?>" placeholder="Enter Amount" autofocus>
                                <input type="hidden" id="total_remaining_amount" name="total_remaining_amount" class="form-control modal_name" value="<?php echo $total_remaining; ?>" placeholder="Enter Amount" autofocus>
                                <input type="text" id="payment_amount" name="payment_amount" class="form-control modal_name" value="<?php echo $_SESSION['post_amount']; ?>" placeholder="Enter Amount" autofocus>
                            </div>

                            <div class="col-sm-4">
                                <input type="text" id="payment_date" name="payment_date" class="form-control modal_contact mydate" value="<?php echo $_SESSION['post_date']; ?>" placeholder="Enter payment date " autofocus>
                            </div>


                        </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="submit"  name="submit_payment" id="submit_payment" class="btn btn-blue " value="Make Payment" >
                        <!--                    <input type="reset" name="reset" id="reset" class="btn btn-warning" value="Reset Search"   />-->
                        <label id="loader"><div style="margin-left:20px;" class="preloader pl-size-xs">

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

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



            </div>



        <?php } */ ?>



        <div class="panel panel-default listingview  <?php if(isset($_REQUEST['action'])){ 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 Estimate Number in ASC</option>
                                        <option value="4">By Estimate 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>Estimate no.</th>
                                    <th>Party </th>
                                    <th>Items </th>
                                    <th>Total Amount </th>
                                    <th style="text-align:center;">Estimate Date </th>
                                    <th>Day passes</th>
                                    <th style="text-align:center;">Action</th>
                                </tr>
                            </table>




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

            </div>

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

        </div>


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

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

                    </div>
                </div>

            </div>
        </div>

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

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

        <script>
            $(document).ready(function() {

                $('body').keydown(function(event){

                    if(event.keyCode == 13) {
                        event.preventDefault();


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

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


            });

            $(document).ready(function() {
                $('#days_search').keydown(function(event){
                    if(event.keyCode == 13) {
                        event.preventDefault();
                        $('#searchbut').trigger('click');
                    }
                });
            });

            $(document).ready(function(){



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

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

                });

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



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

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




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




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

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

                    //$("#bow_search").val(1);
                    $('#bow_search option:selected').removeAttr('selected');


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


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


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


                    $('#not_return_search').attr('checked',false);



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









                    searchList();

                });




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


            });



        </script>



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


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

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







            $(document).ready(function (){





































                var challanid = 0;

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

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


                                var filterdata = $.parseJSON(html);

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


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


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



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




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



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


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


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

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


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



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


                            }



                        }
                    });


                });








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

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


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




                });















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




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

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

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

                });


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


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



                    if(error == 0){

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

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

                                        company_sunopt += html;

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



                                    }

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

                                }
                            });


                        }






                    }




                });






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

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

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

                              '<div style="margin-bottom: 25px;" class="bowUserType  '+dontsShow+' ">'+
                              '<div class="row">'+
                             '<div class="col-md-12">'+
                             '<div class="col-md-12">'+
                              '<div class="form-inline" style="padding-top: 10px; padding-bottom: 10px;">'+
                              '<div class="form-group " style="margin-bottom: 0;">'+
                               '<label for="bow">User Type  :</label>'+

                            <?php if($_SESSION['bow']){ ?>

                                        '<select id="bow"   name="bow" class="form-control " style="width: 200px;display: inline-block;margin-left: 10px;" >'+
                                        '<option  value=""  >Select</option>'+
                                        '<option  value="1"  >Type One </option>'+
                                        '<option  value="2"  >Type Two</option>'+
                                        '</select>'+

                            <?php }else{ ?>

                                        '<select id="bow"   name="bow" class="form-control " style="width: 200px;display: inline-block;margin-left: 10px;" >'+
                                        '<option  value="1"  >Type One </option>'+
                                        '</select>'+
                            <?php }?>


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


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


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

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



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




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




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

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

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









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



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








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

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








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

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

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


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


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




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

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

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



                        '</div>'+

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



                        '</div>'+








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


                        '<div style="height:20px;"></div>'+
                        '<div class="col-md-12">'+
                        '<div class="form-group input-group">'+
                        '<label for="refrence_two" >Reference Two :</label>'+
                        '<select name="refrence_two" id="refrence_two" class="form-control reference_name select2">'+
                        reference_sunopt+
                        '</select>'+
                        '</div>'+
                        '</div>'+














                        ''+
                        '<button id="addcustomerbutton" style="display:block;margin:0 auto;" class="btn btn-info ok"> Submit </button>'+
                        '<div style="clear:both;"></div>';

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

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




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

                });





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

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

                    }
                });








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



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

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

                    });


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




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


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



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

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

                                        reference_sunopt += html;

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



                                    }

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


                                }
                            });

                        }



                    }




                });










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

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




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



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


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

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

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


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

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


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


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



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

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

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

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

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






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

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


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


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

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



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


                    if(error == 0){




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



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


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

                                        if (html != "error") {


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


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

                                        if (html == "error") {

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

                                        }
                                    }
                                }

                            });

                        }







                    }




                });





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



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




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

                    var thisobj =  $(this);


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

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

                            console.log(tableheads);



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





                        }
                    });
                });







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

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


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

                });

              /*  $.validator.addMethod(
                    "firstCharNonNumeric",
                    function(value, element, check) {
                        if(check && value.length != 0){
                            var res = "";
                            if(value.length == 1){
                                res = value;
                            }else{
                                res = value.charAt(0);
                            }

                            // var hasnumber =   /\d/.test(res);
                            if(res == 0 || res == ''){
                                //  if(hasnumber){
                                return false;
                            }else{
                                return true;
                            }
                        }else{
                            return false;
                        }
                    },"Please check your input."
                ); */



                show = 1;


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

                function myTimer() {

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


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


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

                cansubmit = 1;
                formerror = 0;

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


                    cansubmit = 1;
                    formerror = 0;


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




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



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

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

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

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


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



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

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

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

















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

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

                        totalproduct++;

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

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

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


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

                        }

                    });

                    if(totalproduct == 0){
                        cansubmit = 0;
                    }





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

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

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

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


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

                    });


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

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


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

                            formerror = 1;

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

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

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

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

                    });




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

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

                            formerror = 1;

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

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

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


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

                        }

                    });


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


                    formerror = 0;
                }





                $('#button2').on('click',function(e){

                console.log('submiting form / fetching live data ');
                    //  e.preventDefault();
                    //  $('#frm').unbind().submit();
                  //   $(this).css('display','none');
                 //     $('.waitbutton').removeClass('dontshow');
               //   add_button_seconds();

                    /*  new code */


                    validateform();

                    if(cansubmit == 1){

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

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


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



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

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


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

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


                        var labour = 0;
                        if($('#labour').val().length != 0){
                            labour = $('#labour').val();
                        }
                        var freight = 0;
                        if($('#freight').val().length != 0){
                            freight = $('#freight').val();
                        }


                        $('.amount_sun').addClass('makeit_readonly');
//                    $('.amount_sun').attr('readonly','true');



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

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



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


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




                                // taxablevalue


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




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

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

                                taxable_value  = finaldata.taxablevalue.toFixed(2);






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

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


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


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

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

                                        }

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

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

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

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

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

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

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

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

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


                                        }

                                    }
                                    i++;
                                });







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

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

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


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




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

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

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

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

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

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


                                    }
                                }

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


                                //totaltaxamount



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


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

                                /*tax block code ends */

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


                                // $('#frm').valid();
                                validateform();

                                if(cansubmit == 1){

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

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

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





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


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


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


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

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

                    // console.log(amount_sun);



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

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


                    var labour = 0;
                    if($('#labour').val().length != 0){
                        labour = $('#labour').val();
                    }
                    var freight = 0;
                    if($('#freight').val().length != 0){
                        freight = $('#freight').val();
                    }


                    $('.amount_sun').addClass('makeit_readonly');
//                    $('.amount_sun').attr('readonly','true');



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

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



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


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




                            // taxablevalue


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




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

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

                            taxable_value  = finaldata.taxablevalue.toFixed(2);






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

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


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


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

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

                                    }

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

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

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

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

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

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

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

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

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


                                    }

                                }
                                i++;
                            });



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

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

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


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




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

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

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

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

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

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


                                }
                            }

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


                            //totaltaxamount



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


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

                            /*tax block code ends */

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


                            // $('#frm').valid();

                            console.log('checking for validations');
                            validateform();
                        },
                        error: function (jqXHR, exception) {
                            alert('internet issue ');

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


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

                    });



                }








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






                function   checkselected(object){
                    error  = 0;


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






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

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

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


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



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


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

                    }

                    if(error != 1 ){

                        cleartax();
                        calculate_order_invoice();

                    }





                }


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

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

                    });


                    checkselected($(this));
                });



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



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


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

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





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


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

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

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




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







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





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


                id = 1;

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



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






                <?php


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

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



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




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




                <?php


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

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



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




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


            });


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

            function showsrch(srch)
            {

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

            }

            function getcustomer_detail(id,cust_id)
            {

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

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

                        }
                    });

                }


            }

        </script>





    </div>

</section>

Youez - 2016 - github.com/yon3zu
LinuXploit