<%@page contentType="text/html"%>
<%@page	import="javax.xml.parsers.DocumentBuilderFactory,javax.xml.parsers.DocumentBuilder,org.w3c.dom.*"%>
<%@page import="ibase.dashboard.mfg.bean.*"%>
<%@page import="javax.naming.Context"%>
<%@page import="org.w3c.dom.Node"%>
<%@page import="org.w3c.dom.NodeList"%>
<%@page import="ibase.webitm.utility.GenericUtility"%>
<%@page import="java.util.Calendar"%>
<%@page import="java.util.Enumeration"%>
<%@page import="java.util.List"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.text.SimpleDateFormat"%>
<jsp:useBean id="productionVsBudgetBean" scope="request"
	class="ibase.dashboard.mfg.bean.ProductionVsBudgetReportBean" />
<%!GenericUtility genericUtility = GenericUtility.getInstance();
	String objName = "";
	Document dom = null;
	NodeList dtlList = null;
	Node parentNode = null;
	NodeList childNodeList = null;
	Node currDetail = null;
	ArrayList<String> chartDataList = null;
	List<String> geoLocList   = new ArrayList<String>();
	List<String> unitFormList =new ArrayList<String>();
	
	
	String childNodeName = "";
	String period = "";
	String netsales = "";
	String amount = "";
	String fin_entity = "";
	StringBuffer chartData = null;
	String xmlDataString = "";
	String selectedEntity = "";
	String entity = "", descr = "";
	String user = "TA821";
	String rptTitle = "";
	String srcJSPath = "";
	String srcImagesPath = "";
	Calendar calendar = null;
	String frmDate = "";
	String toDate = "";
	String dayQty = "";
	NodeList locationList = null;
	NodeList detailList = null;
	NodeList unitList = null;
	NodeList dateList = null;
	NodeList dayQtyList = null;
	Node locationNode = null;
	NodeList foreCastList = null;
	Node unitNode = null;
	Node dateNode = null;
	Node dayNode = null;
	Node foreCastNode=null;
	String date = "";
	int lastDayOfMonth=0;
	int todaysDay=0;
	String month="";
	int preyear=0;
	int year=0;
	List<String> sumDayPro  =new ArrayList<String>();
	List<String> cumLstYear =new ArrayList<String>();
	List<Double> cumuQty    =new ArrayList<Double>();
	List<String> LBEList    =new ArrayList<String>();
	
	SimpleDateFormat simpleDateFormat = null;%>
<%
	response.setHeader("Expires", "Sat, 6 May 1995 12:00:00 GMT");
	response.setHeader("Cache-Control", "no-store, no-cache,must-revalidate");
	response.addHeader("Cache-Control", "post-check=0, pre-check=0");
	response.setHeader("Pragma", "no-cache");
%>
<%
	String userAgent = request.getHeader("user-agent");
	System.out.println("userAgent ==" + userAgent);
	if (userAgent.indexOf("Android") > 0 || userAgent.indexOf("iPhone") > 0 || userAgent.indexOf("iPad") > 0)
	{
		srcJSPath = "ibase/FusionChart/js/FusionCharts.js";
		srcImagesPath = "ibase/FusionChart/images/MSCombi3D.swf";

	} else
	{
		srcJSPath = "/ibase/FusionChart/js/FusionCharts.js";
		srcImagesPath = "/ibase/FusionChart/images/MSCombi3D.swf";

		System.out.println("srcJSPath ==" + srcJSPath);
		System.out.println("srcImagesPath ==" + srcImagesPath);

	}
%>

<%@page import="java.util.ArrayList"%><html>
<head>
<style type="text/css">
.tdLabel {
	FONT-FAMILY: Arial;
	font-size: 12pt;
}
.title {
	FONT-FAMILY: Arial;
	font-size: 14pt;
	
	}
  .headerTable{
	   height: 50px;
	   width:100px;
	    border: 1;
	    align:center;
	   }
	   .headerTr{
	   background-color: green;
	   height:30px;
	   font-size:7pt;
	   }	
	    .detailTr{
	   background-color: yellow;
	   height:20px;
	   font-size:7pt;
	   } 


</style>
<script type="text/javascript" src="<%=srcJSPath%>"></script>
</head>
<body>

<%
	try
	{

		//ibase.utility.UserInfoBean userInfo = (ibase.utility.UserInfoBean) session.getAttribute("USER_INFO");
		//String user  = userInfo.getLoginCode();	
		
		//out.println("user===="+user);		
		simpleDateFormat = new SimpleDateFormat("dd-MMM-yy");
		calendar = Calendar.getInstance();
		preyear  =calendar.get(Calendar.YEAR)-1;
		year     =calendar.get(Calendar.YEAR);
		month    = new SimpleDateFormat("MMM").format(calendar.getTime());	
		
		String currDate = simpleDateFormat.format(calendar.getTime());
		calendar.set(Calendar.DAY_OF_MONTH, calendar.getActualMaximum(Calendar.DAY_OF_MONTH));
		toDate = simpleDateFormat.format(calendar.getTime());
       
		//out.print("max day ="+calendar.getActualMaximum(Calendar.DAY_OF_MONTH));
		//out.print("min day ="+calendar.getActualMinimum(Calendar.DAY_OF_MONTH));
		calendar = Calendar.getInstance();
		calendar.set(Calendar.DAY_OF_MONTH, calendar.getActualMinimum(Calendar.DAY_OF_MONTH));
		frmDate = simpleDateFormat.format(calendar.getTime());
		 
		 todaysDay      =Calendar.getInstance().get(Calendar.DAY_OF_MONTH);		 		 
		 lastDayOfMonth = Calendar.getInstance().getActualMaximum(Calendar.DAY_OF_MONTH);
		
		//frmDate = "01-apr-12";
		//toDate  = "30-apr-12";		
		rptTitle = "Production Vs Budget Report - "+currDate;		
        System.out.println("rptTitle====="+rptTitle);
		if (user != null && user.trim().length() != 0)
		{
			xmlDataString = productionVsBudgetBean.getProductionBudget(frmDate, toDate);
			System.out.print("xmlDataString in jsp= " + xmlDataString);
			
		}
%>
	<table  align="center">
	 <tr><td class="title"><%=rptTitle %></td></tr>
	</table><br>

<%
	//Add here Details for Chart container 
		//xmlDataString="<?xml version='1.0'?><Root><Detail><geo_loc location='110' glocdescr ='SILVASSA 1 - FACTORY'  ><unit_form unit='CAP' unitdescr ='CAPSULES'><tran_date  date='01'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='02'><day_quantity quantity='313450'><pyr_dayqty><![CDATA[]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[313450]]></cur_cumqty></day_quantity></tran_date><tran_date  date='03'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[313450]]></cur_cumqty></day_quantity></tran_date><tran_date  date='04'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[313450]]></cur_cumqty></day_quantity></tran_date><tran_date  date='05'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[313450]]></cur_cumqty></day_quantity></tran_date><tran_date  date='06'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[313450]]></cur_cumqty></day_quantity></tran_date><tran_date  date='07'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[313450]]></cur_cumqty></day_quantity></tran_date><tran_date  date='08'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[313450]]></cur_cumqty></day_quantity></tran_date><tran_date  date='09'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[313450]]></cur_cumqty></day_quantity></tran_date><tran_date  date='10'><day_quantity quantity='152310'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='11'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='12'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='13'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='14'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='15'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='16'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='17'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='18'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='19'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='20'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='21'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='22'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='23'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='24'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='25'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='26'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='27'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='28'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='29'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date><tran_date  date='30'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2260890]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[465760]]></cur_cumqty></day_quantity></tran_date></unit_form></geo_loc><geo_loc location='110' glocdescr ='SILVASSA 1 - FACTORY'  ><unit_form unit='TAB' unitdescr ='TABLETS'><tran_date  date='01'><day_quantity quantity='574590'><pyr_dayqty><![CDATA[]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[574590]]></cur_cumqty></day_quantity></tran_date><tran_date  date='02'><day_quantity quantity='1344790'><pyr_dayqty><![CDATA[1693450]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[1919380]]></cur_cumqty></day_quantity></tran_date><tran_date  date='03'><day_quantity quantity='1426220'><pyr_dayqty><![CDATA[3606330]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[3345600]]></cur_cumqty></day_quantity></tran_date><tran_date  date='04'><day_quantity quantity='1470030'><pyr_dayqty><![CDATA[4261180]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[4815630]]></cur_cumqty></day_quantity></tran_date><tran_date  date='05'><day_quantity quantity='2117640'><pyr_dayqty><![CDATA[5368740]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[6933270]]></cur_cumqty></day_quantity></tran_date><tran_date  date='06'><day_quantity quantity='2204740'><pyr_dayqty><![CDATA[7224840]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[9138010]]></cur_cumqty></day_quantity></tran_date><tran_date  date='07'><day_quantity quantity='0'><pyr_dayqty><![CDATA[7224840]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[9138010]]></cur_cumqty></day_quantity></tran_date><tran_date  date='08'><day_quantity quantity='937532'><pyr_dayqty><![CDATA[9361990]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[10075542]]></cur_cumqty></day_quantity></tran_date><tran_date  date='09'><day_quantity quantity='4529340'><pyr_dayqty><![CDATA[10295310]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[14604882]]></cur_cumqty></day_quantity></tran_date><tran_date  date='10'><day_quantity quantity='768430'><pyr_dayqty><![CDATA[12470440]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[15373312]]></cur_cumqty></day_quantity></tran_date><tran_date  date='11'><day_quantity quantity='2744872'><pyr_dayqty><![CDATA[17153210]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[18118184]]></cur_cumqty></day_quantity></tran_date><tran_date  date='12'><day_quantity quantity='3000250'><pyr_dayqty><![CDATA[20058470]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21118434]]></cur_cumqty></day_quantity></tran_date><tran_date  date='13'><day_quantity quantity='585950'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='14'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='15'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='16'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='17'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='18'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='19'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='20'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='21'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='22'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='23'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='24'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='25'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='26'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='27'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='28'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='29'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date><tran_date  date='30'><day_quantity quantity='0'><pyr_dayqty><![CDATA[22461136]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21704384]]></cur_cumqty></day_quantity></tran_date></unit_form></geo_loc><geo_loc location='120' glocdescr ='JAMMU FACTORY'  ><unit_form unit='CAP' unitdescr ='CAPSULES'><tran_date  date='01'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='02'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='03'><day_quantity quantity='102000'><pyr_dayqty><![CDATA[500000]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[102000]]></cur_cumqty></day_quantity></tran_date><tran_date  date='04'><day_quantity quantity='0'><pyr_dayqty><![CDATA[500000]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[102000]]></cur_cumqty></day_quantity></tran_date><tran_date  date='05'><day_quantity quantity='169200'><pyr_dayqty><![CDATA[2134600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[271200]]></cur_cumqty></day_quantity></tran_date><tran_date  date='06'><day_quantity quantity='7550'><pyr_dayqty><![CDATA[2195080]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[278750]]></cur_cumqty></day_quantity></tran_date><tran_date  date='07'><day_quantity quantity='45600'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='08'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='09'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='10'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='11'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='12'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='13'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='14'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='15'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='16'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='17'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='18'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='19'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='20'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='21'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='22'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='23'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='24'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='25'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='26'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='27'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='28'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='29'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='30'><day_quantity quantity='0'><pyr_dayqty><![CDATA[2350600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[324350]]></cur_cumqty></day_quantity></tran_date></unit_form></geo_loc><geo_loc location='120' glocdescr ='JAMMU FACTORY'  ><unit_form unit='TAB' unitdescr ='TABLETS'><tran_date  date='01'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='02'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='03'><day_quantity quantity='240000'><pyr_dayqty><![CDATA[174600]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[240000]]></cur_cumqty></day_quantity></tran_date><tran_date  date='04'><day_quantity quantity='1843140'><pyr_dayqty><![CDATA[4207560]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[2083140]]></cur_cumqty></day_quantity></tran_date><tran_date  date='05'><day_quantity quantity='0'><pyr_dayqty><![CDATA[4207560]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[2083140]]></cur_cumqty></day_quantity></tran_date><tran_date  date='06'><day_quantity quantity='2347394'><pyr_dayqty><![CDATA[10868634]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[4430534]]></cur_cumqty></day_quantity></tran_date><tran_date  date='07'><day_quantity quantity='3511460'><pyr_dayqty><![CDATA[12127214]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[7941994]]></cur_cumqty></day_quantity></tran_date><tran_date  date='08'><day_quantity quantity='0'><pyr_dayqty><![CDATA[12127214]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[7941994]]></cur_cumqty></day_quantity></tran_date><tran_date  date='09'><day_quantity quantity='1926100'><pyr_dayqty><![CDATA[12419754]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[9868094]]></cur_cumqty></day_quantity></tran_date><tran_date  date='10'><day_quantity quantity='7323980'><pyr_dayqty><![CDATA[12726474]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[17192074]]></cur_cumqty></day_quantity></tran_date><tran_date  date='11'><day_quantity quantity='4864000'><pyr_dayqty><![CDATA[13168944]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[22056074]]></cur_cumqty></day_quantity></tran_date><tran_date  date='12'><day_quantity quantity='5360540'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='13'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='14'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='15'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='16'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='17'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='18'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='19'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='20'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='21'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='22'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='23'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='24'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='25'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='26'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='27'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='28'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='29'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date><tran_date  date='30'><day_quantity quantity='0'><pyr_dayqty><![CDATA[13955684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[27416614]]></cur_cumqty></day_quantity></tran_date></unit_form></geo_loc><geo_loc location='130' glocdescr ='SPS-SIKKIM'  ><unit_form unit='CAP' unitdescr ='CAPSULES'><tran_date  date='01'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='02'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='03'><day_quantity quantity='1972000'><pyr_dayqty><![CDATA[4331530]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[1972000]]></cur_cumqty></day_quantity></tran_date><tran_date  date='04'><day_quantity quantity='527000'><pyr_dayqty><![CDATA[5989220]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[2499000]]></cur_cumqty></day_quantity></tran_date><tran_date  date='05'><day_quantity quantity='1747600'><pyr_dayqty><![CDATA[9473230]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[4246600]]></cur_cumqty></day_quantity></tran_date><tran_date  date='06'><day_quantity quantity='1292000'><pyr_dayqty><![CDATA[12820630]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[5538600]]></cur_cumqty></day_quantity></tran_date><tran_date  date='07'><day_quantity quantity='2310750'><pyr_dayqty><![CDATA[12870630]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[7849350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='08'><day_quantity quantity='0'><pyr_dayqty><![CDATA[12870630]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[7849350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='09'><day_quantity quantity='32000'><pyr_dayqty><![CDATA[12870630]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[7881350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='10'><day_quantity quantity='32000'><pyr_dayqty><![CDATA[12923750]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[7913350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='11'><day_quantity quantity='32000'><pyr_dayqty><![CDATA[12923750]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[7945350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='12'><day_quantity quantity='695000'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='13'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='14'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='15'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='16'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='17'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='18'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='19'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='20'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='21'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='22'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='23'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='24'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='25'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='26'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='27'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='28'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='29'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date><tran_date  date='30'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17219150]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[8640350]]></cur_cumqty></day_quantity></tran_date></unit_form></geo_loc><geo_loc location='130' glocdescr ='SPS-SIKKIM'  ><unit_form unit='TAB' unitdescr ='TABLETS'><tran_date  date='01'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='02'><day_quantity quantity='2229300'><pyr_dayqty><![CDATA[9993682]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[2229300]]></cur_cumqty></day_quantity></tran_date><tran_date  date='03'><day_quantity quantity='10630730'><pyr_dayqty><![CDATA[18292482]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[12860030]]></cur_cumqty></day_quantity></tran_date><tran_date  date='04'><day_quantity quantity='8579645'><pyr_dayqty><![CDATA[37086192]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[21439675]]></cur_cumqty></day_quantity></tran_date><tran_date  date='05'><day_quantity quantity='9858505'><pyr_dayqty><![CDATA[53868468]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[31298180]]></cur_cumqty></day_quantity></tran_date><tran_date  date='06'><day_quantity quantity='4631300'><pyr_dayqty><![CDATA[62928578]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[35929480]]></cur_cumqty></day_quantity></tran_date><tran_date  date='07'><day_quantity quantity='12115130'><pyr_dayqty><![CDATA[63834378]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[48044610]]></cur_cumqty></day_quantity></tran_date><tran_date  date='08'><day_quantity quantity='0'><pyr_dayqty><![CDATA[63834378]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[48044610]]></cur_cumqty></day_quantity></tran_date><tran_date  date='09'><day_quantity quantity='6784972'><pyr_dayqty><![CDATA[63834378]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[54829582]]></cur_cumqty></day_quantity></tran_date><tran_date  date='10'><day_quantity quantity='11685360'><pyr_dayqty><![CDATA[72332026]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[66514942]]></cur_cumqty></day_quantity></tran_date><tran_date  date='11'><day_quantity quantity='17424788'><pyr_dayqty><![CDATA[73221516]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[83939730]]></cur_cumqty></day_quantity></tran_date><tran_date  date='12'><day_quantity quantity='14821560'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='13'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='14'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='15'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='16'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='17'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='18'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='19'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='20'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='21'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='22'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='23'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='24'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='25'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='26'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='27'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='28'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='29'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date><tran_date  date='30'><day_quantity quantity='0'><pyr_dayqty><![CDATA[94816684]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[98761290]]></cur_cumqty></day_quantity></tran_date></unit_form></geo_loc><geo_loc location='130' glocdescr =''  ><unit_form unit='' unitdescr =''><tran_date  date='01'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='02'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='03'><day_quantity quantity='22500'><pyr_dayqty><![CDATA[]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[22500]]></cur_cumqty></day_quantity></tran_date><tran_date  date='04'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[22500]]></cur_cumqty></day_quantity></tran_date><tran_date  date='05'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[22500]]></cur_cumqty></day_quantity></tran_date><tran_date  date='06'><day_quantity quantity='80500'><pyr_dayqty><![CDATA[]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[103000]]></cur_cumqty></day_quantity></tran_date><tran_date  date='07'><day_quantity quantity='19480'><pyr_dayqty><![CDATA[]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[122480]]></cur_cumqty></day_quantity></tran_date><tran_date  date='08'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[122480]]></cur_cumqty></day_quantity></tran_date><tran_date  date='09'><day_quantity quantity='32560'><pyr_dayqty><![CDATA[]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[155040]]></cur_cumqty></day_quantity></tran_date><tran_date  date='10'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[155040]]></cur_cumqty></day_quantity></tran_date><tran_date  date='11'><day_quantity quantity='26540'><pyr_dayqty><![CDATA[]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[181580]]></cur_cumqty></day_quantity></tran_date><tran_date  date='12'><day_quantity quantity='9760'><pyr_dayqty><![CDATA[]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='13'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='14'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='15'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='16'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='17'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='18'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='19'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='20'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='21'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='22'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='23'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='24'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='25'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='26'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='27'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='28'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='29'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date><tran_date  date='30'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[191340]]></cur_cumqty></day_quantity></tran_date></unit_form></geo_loc><geo_loc location='145' glocdescr ='SUN PHARMACEUTICAL INDUSTRIES'  ><unit_form unit='CAP' unitdescr ='CAPSULES'><tran_date  date='01'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='02'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='03'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='04'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='05'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='06'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='07'><day_quantity quantity='10750'><pyr_dayqty><![CDATA[]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[10750]]></cur_cumqty></day_quantity></tran_date><tran_date  date='08'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[10750]]></cur_cumqty></day_quantity></tran_date><tran_date  date='09'><day_quantity quantity='187200'><pyr_dayqty><![CDATA[]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='10'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='11'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='12'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='13'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='14'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='15'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='16'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='17'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='18'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='19'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='20'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='21'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='22'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='23'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='24'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='25'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='26'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='27'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='28'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='29'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date><tran_date  date='30'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[197950]]></cur_cumqty></day_quantity></tran_date></unit_form></geo_loc><geo_loc location='145' glocdescr ='SUN PHARMACEUTICAL INDUSTRIES'  ><unit_form unit='TAB' unitdescr ='TABLETS'><tran_date  date='01'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='02'><day_quantity quantity='0'><pyr_dayqty><![CDATA[0.0]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[0.0]]></cur_cumqty></day_quantity></tran_date><tran_date  date='03'><day_quantity quantity='2775000'><pyr_dayqty><![CDATA[2619050]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[2775000]]></cur_cumqty></day_quantity></tran_date><tran_date  date='04'><day_quantity quantity='1595700'><pyr_dayqty><![CDATA[3239400]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[4370700]]></cur_cumqty></day_quantity></tran_date><tran_date  date='05'><day_quantity quantity='492350'><pyr_dayqty><![CDATA[5097490]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[4863050]]></cur_cumqty></day_quantity></tran_date><tran_date  date='06'><day_quantity quantity='1993980'><pyr_dayqty><![CDATA[6916690]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[6857030]]></cur_cumqty></day_quantity></tran_date><tran_date  date='07'><day_quantity quantity='6847630'><pyr_dayqty><![CDATA[8286140]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[13704660]]></cur_cumqty></day_quantity></tran_date><tran_date  date='08'><day_quantity quantity='0'><pyr_dayqty><![CDATA[8286140]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[13704660]]></cur_cumqty></day_quantity></tran_date><tran_date  date='09'><day_quantity quantity='2590000'><pyr_dayqty><![CDATA[8886140]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[16294660]]></cur_cumqty></day_quantity></tran_date><tran_date  date='10'><day_quantity quantity='0'><pyr_dayqty><![CDATA[8886140]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[16294660]]></cur_cumqty></day_quantity></tran_date><tran_date  date='11'><day_quantity quantity='0'><pyr_dayqty><![CDATA[8886140]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[16294660]]></cur_cumqty></day_quantity></tran_date><tran_date  date='12'><day_quantity quantity='700000'><pyr_dayqty><![CDATA[16285940]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[16994660]]></cur_cumqty></day_quantity></tran_date><tran_date  date='13'><day_quantity quantity='1395000'><pyr_dayqty><![CDATA[17245940]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[18389660]]></cur_cumqty></day_quantity></tran_date><tran_date  date='14'><day_quantity quantity='0'><pyr_dayqty><![CDATA[17245940]]></pyr_dayqty><daily_budqty><![CDATA[0.0]]></daily_budqty><cur_cumqty><![CDATA[18389660]]></cur_cumqty></day_quantity></tran_date></unit_form></geo_loc></Detail></Root>";
		dom = genericUtility.parseString(xmlDataString);
       
		if (dom != null)
		{
				
			
			chartDataList = new ArrayList<String>();
			detailList  = dom.getElementsByTagName("Detail");
			
			if(detailList.item(0).getFirstChild()!=null)
			{
			locationList  = dom.getElementsByTagName("geo_loc");			
			for (int cntr = 0; cntr < locationList.getLength(); cntr++)
			{
				
				locationNode = locationList.item(cntr);	
				
				
				//start  Labling  setting 1			
				
				geoLocList.add(locationNode.getAttributes().getNamedItem("glocdescr").getNodeValue());						
				chartData = new StringBuffer("<chart caption='");				
				chartData.append("' palette='1' showValues='0' yAxisValuesPadding='10' numberPrefix='' chartOrder='line,area,column' startAngX='8' startAngY='-32' endAngX='8' endAngY='-32' zdepth='50' zgapPlot='10' showPlotBorder='0' dynamicShading='1' showAlternateHGridColor='1' labelDisplay='Stagger' legendNumColumns='2'>");
				chartData.append("<categories>");

				unitList     = locationNode.getChildNodes();
				for (int nodCtr = 0; nodCtr < unitList.getLength(); nodCtr++)
				{
					
					unitNode = unitList.item(nodCtr);
					
					//Add unit form in unitForm List
					unitFormList.add(unitNode.getAttributes().getNamedItem("unitdescr").getNodeValue());
					//geoLocList.add(locationNode.getAttributes().getNamedItem("glocdescr").getNodeValue());
					
					dateList = unitNode.getChildNodes();
					for (int dateCtr = 0; dateCtr < dateList.getLength(); dateCtr++)
					{
						
						dateNode = dateList.item(dateCtr);
						date = dateNode.getAttributes().item(0).getNodeValue();
						chartData.append("<category label='" + date + "'/>");
					}
					
				}
				
				
				chartData.append("<category label='" +"fc"+ "'/>");				
				chartData.append("</categories>");
				
				//End of  Labling  setting 1		
				//2. Start dataset for Forecasting	
				chartData.append("<dataset seriesName='Forecast' >");
				
				for (int nodCtr = 0; nodCtr < unitList.getLength(); nodCtr++)
				{   
					double cumulativeQty=0.0;					
					unitNode = unitList.item(nodCtr);
					dateList = unitNode.getChildNodes();
					for (int dateCtr = 0; dateCtr < dateList.getLength(); dateCtr++)
					{
						dateNode   = dateList.item(dateCtr);
						dayQtyList = dateNode.getChildNodes();
						int day    =Integer.parseInt(dateNode.getAttributes().item(0).getNodeValue());
						
						for (int dayCtr = 0; dayCtr < dayQtyList.getLength(); dayCtr++)
						{
							dayNode = dayQtyList.item(dayCtr);
							foreCastList = dayNode.getChildNodes();						 	  
								  
								for (int prevCtr = 0; prevCtr < foreCastList.getLength(); prevCtr++)
								{
									foreCastNode = foreCastList.item(prevCtr);
									
									if(foreCastNode.getNodeName().equals("cur_cumqty"))
									{		
										//out.println("day:"+day+"--todaysDay"+todaysDay);
										if(day==todaysDay)
										  {	 
											cumulativeQty =Double.parseDouble(foreCastNode.getTextContent());
											
											cumulativeQty= Math.round(cumulativeQty*lastDayOfMonth)/day;
											cumuQty.add(cumulativeQty);
											//cumulativeQty =(cumulativeQty*30)/30;									        
											for(int dayOfMonth=1; dayOfMonth<=lastDayOfMonth; dayOfMonth++)
									        {
									        	chartData.append("<set value='0'/>");
									        }
									       chartData.append("<set value='" + cumulativeQty + "'/>");
								          
										 }
									       
									       
								    }								
							  
						       }
					     }
					}
				}
								
			chartData.append("</dataset>");
			//2. End dataset for Forecasting				
			//3. Start dataset for Daily Budget Quantity
            chartData.append("<dataset seriesName='Cumulative Production' >");
			String curCumQtyTem="";
				for (int nodCtr = 0; nodCtr < unitList.getLength(); nodCtr++)
				{
					unitNode = unitList.item(nodCtr);
					dateList = unitNode.getChildNodes();
					
					for (int dateCtr = 0; dateCtr < dateList.getLength(); dateCtr++)
					{
						dateNode   = dateList.item(dateCtr);
						int day   =Integer.parseInt(dateNode.getAttributes().item(0).getNodeValue());
						dayQtyList = dateNode.getChildNodes();
						if(day<=todaysDay)
						{
							for (int dayCtr = 0; dayCtr < dayQtyList.getLength(); dayCtr++)
							{
								dayNode = dayQtyList.item(dayCtr);
								NodeList curCumQtyList = dayNode.getChildNodes();
							
								for (int curCumCtr = 0; curCumCtr < curCumQtyList.getLength(); curCumCtr++)
								{
									Node curCumQtyNode = curCumQtyList.item(curCumCtr);
									if(curCumQtyNode.getNodeName().equals("cur_cumqty")  )
									{
										
										curCumQtyTem =curCumQtyNode.getTextContent();
										
								  		chartData.append("<set value='" + curCumQtyNode.getTextContent() + "'/>");
							     	}
								}
							 }
					  	 }else{
					  		 for(int p=todaysDay+1;p<=lastDayOfMonth;p++){
					  			chartData.append("<set value='0'/>");
					  		 }
					  	 }
					}
				}
				sumDayPro.add(curCumQtyTem);				
				chartData.append("</dataset>");					
		//3. End dataset for Daily Budget Quantity	
		//4. start dataset for Day wise Quantity
				chartData.append("<dataset seriesName='Day Production'>");
				
				for (int nodCtr = 0; nodCtr < unitList.getLength(); nodCtr++)
				{
					unitNode = unitList.item(nodCtr);
					dateList = unitNode.getChildNodes();		
					
					
					for (int dateCtr = 0; dateCtr < dateList.getLength(); dateCtr++)
					{
						dateNode = dateList.item(dateCtr);
						int day   =Integer.parseInt(dateNode.getAttributes().item(0).getNodeValue());
						dayQtyList = dateNode.getChildNodes();
						if(day<=todaysDay)
						{
							for (int dayCtr = 0; dayCtr < dayQtyList.getLength(); dayCtr++)
							{
								dayNode    = dayQtyList.item(dayCtr);							
								dayQty     = dayNode.getAttributes().item(0).getNodeValue();
								
								
								chartData.append("<set value='" + dayQty + "'/>");
							}
						 }else{
					  		 for(int p=todaysDay+1;p<=lastDayOfMonth;p++){
						  			chartData.append("<set value='0'/>");
						  		 }
						  	 }
					}
					
					
				}
				chartData.append("</dataset>");
			//4. End dataset for Day wise Quantity	
            //5. start dataset for Last year Quantity
			
			  chartData.append("<dataset seriesName='Cumulative Last Year'  renderAs='Line'>");
			   String prevYearQtyTemp="";
				for (int nodCtr = 0; nodCtr < unitList.getLength(); nodCtr++)
				{
					unitNode = unitList.item(nodCtr);
					dateList = unitNode.getChildNodes();
					for (int dateCtr = 0; dateCtr < dateList.getLength(); dateCtr++)
					{
						dateNode   = dateList.item(dateCtr);
						dayQtyList = dateNode.getChildNodes();

						for (int dayCtr = 0; dayCtr < dayQtyList.getLength(); dayCtr++)
						{
							//dayNode = dayQtyList.item(dateCtr);
							dayNode = dayQtyList.item(dayCtr);
							NodeList prevYearQtyList = dayNode.getChildNodes();

							for (int prevCtr = 0; prevCtr < prevYearQtyList.getLength(); prevCtr++)
							{
								Node prevYearQtyNode = prevYearQtyList.item(prevCtr);
								
								if(prevYearQtyNode.getNodeName().equals("pyr_dayqty"))
								{
									prevYearQtyTemp = (prevYearQtyNode.getTextContent());					  
								    chartData.append("<set value='" + prevYearQtyNode.getTextContent() + "'/>");
							     }
							}
						}
					}
				}
				cumLstYear.add(prevYearQtyTemp);
				chartData.append("</dataset>");	
				//5. End dataset for Last year Quantity
				//6. Start dataset for Daily Budget Quantity				
				chartData.append("<dataset seriesName='Cumulative Budget'  renderAs='Line'>");
				String LBETEMP="";
				for (int nodCtr = 0; nodCtr < unitList.getLength(); nodCtr++)
				{
					unitNode = unitList.item(nodCtr);
					dateList = unitNode.getChildNodes();
					for (int dateCtr = 0; dateCtr < dateList.getLength(); dateCtr++)
					{
						dateNode   = dateList.item(dateCtr);
						dayQtyList = dateNode.getChildNodes();

						for (int dayCtr = 0; dayCtr < dayQtyList.getLength(); dayCtr++)
						{
							dayNode = dayQtyList.item(dayCtr);
							NodeList dailyBdgtList = dayNode.getChildNodes();

							for (int dBdgtCtr = 0; dBdgtCtr < dailyBdgtList.getLength(); dBdgtCtr++)
							{
								Node dailyBdgtNode = dailyBdgtList.item(dBdgtCtr);
								
								if(dailyBdgtNode.getNodeName().equals("daily_budqty"))
								{
									LBETEMP =dailyBdgtNode.getTextContent();
									//out.println("daliyBdgtQty==="+dailyBdgtNode.getTextContent());
								    chartData.append("<set value='" + dailyBdgtNode.getTextContent() + "'/>");
							     }
							}
						}
					}
				}
				LBEList.add(LBETEMP);
				chartData.append("</dataset>");					
			//6. End dataset for Daily Budget Quantity
            
				chartData.append("</chart>");
				chartDataList.add(chartData.toString());
				//System.out.println("chartData is  :" + chartData.toString() + "Chart data List sizeee is =" + chartDataList.size());
				chartData.setLength(0);
				
			}
		}
			else{
				%>
				<table  cellspacing="1" cellpadding="2" align="center">
				<tr><td><h4> No data found !</h4></td></tr>
				</table>				
				<%
				
			}
		}

		int chartDivId = 0;
		int countChart=0;
		int tablId=0;
		
		%>
		<table border="1" cellspacing="1" cellpadding="2">
		<%
		 
		for (String chartDatFrmList : chartDataList)
		{
			chartDivId++;
           %>          
            <% if(tablId ==0 || (tablId%3==0))
            {
		   %>
            	<tr>
            <%	
            	tablId=0;
            }
            %>
            
             

	       <td align ="left" style="font-size:12px"><b> <%=geoLocList.get(countChart)%> - <%=unitFormList.get(countChart)%> </b>
	       <div id="chartContainer<%=chartDivId%>">Chart will load here ! </div>
           
	         <script type="text/javascript"> 
		         FusionCharts.setCurrentRenderer('javascript');
		         var myChart = new FusionCharts("<%=srcImagesPath%>", "myChartId", "400", "350", "0", "0");
		         myChart.setXMLData("<%=chartDatFrmList%>");          
		         myChart.render("chartContainer<%=chartDivId%>");      
              </script>
            
          
    
<table class="headerTable">
	<tr class="headerTr">
      <td >Month</td>
      <td >Actual</td>
      <td >LBE</td>
      <td >Actual/LBE</td>
      <td >Pace(EOM)</td>
      <td >Pace(EOM)/LBE</td>
      <td ><%=preyear%>/<%=month%></td>
    </tr>
    <tr  class="detailTr">
      <td ><%=year %>/<%=month%></td>
      <td ><%=sumDayPro.get(countChart)%></td>
      <td ><%= LBEList.get(countChart)%></td>
      <% 
      Double actLBE=0.0;
      Double cumuQtyLBE=0.0;
      if(Double.parseDouble(LBEList.get(countChart))==0.0){
    	  actLBE=0.0;
    	  cumuQtyLBE=0.0;
    	  
      }
    	  
      else{
    	  actLBE =((Double.parseDouble(sumDayPro.get(countChart))/Double.parseDouble(LBEList.get(countChart))*100));    	  
    	  cumuQtyLBE=(cumuQty.get(countChart)/Double.parseDouble(LBEList.get(countChart))*100);
      }
      
      %>
      <td ><%=String.format("%.2f",actLBE)%> %</td>
      <td ><%=String.format("%.2f",cumuQty.get(countChart))%></td>      
      <td ><%=cumuQtyLBE%>%</td>
      <td ><%=cumLstYear.get(countChart)%></td>
    </tr>
   </table>
   </td>
            
            <% if(tablId >0 && tablId%3==0)
            {
		   %>
            	</tr>
            <%	
            }
            %>
        
         <%
         tablId++;
         countChart++;
	     }
		%>
	</table>
		<%
	   } catch (Exception ex)
	{
		System.out.println("Exception : ProductionVsBudgetReport.jsp :" + ex.getMessage());
	}
%>

</body>
</html>
