public ChartOption GetCHART(WIPProfileInput input)
{
var summaryData = _HoldLotInfoRepository.QueryCWIP(input);
var percentData1 = _HoldLotInfoRepository.QueryMOVE(input);
var percentData2 = _HoldLotInfoRepository.QueryHoldWIP(input);
var percentData3 = _HoldLotInfoRepository.QueryRunWIP(input);
var percentData4 = _HoldLotInfoRepository.QueryQueueWIP(input);
string chartTitle = "WIPProfile Chart";
string firstAxisName = "MOVE QTY";
string secondAxisName = "WIP";
ChartOption optionSummary = percentData1.ToChartOption(ChartType.Line, chartTitle, "", "name", "Series", "value", "", ChartDirection.Vertical, "", firstAxisName);
ChartOption addtionOption = summaryData.AddToChartOption(optionSummary, ChartType.Line, "name", "Series", "value", "", "", firstAxisName);
ChartOption addtionOption1 = percentData2.AddToChartOption(optionSummary, ChartType.Bar, "name", "Series", "value", "", "", secondAxisName);
ChartOption addtionOption2 = percentData3.AddToChartOption(optionSummary, ChartType.Bar, "name", "Series", "value", "", "", secondAxisName);
ChartOption addtionOption3 = percentData4.AddToChartOption(optionSummary, ChartType.Bar, "name", "Series", "value", "", "", secondAxisName);
addtionOption1.xAxis[0].axisLabel = new AxisLabel()
{
interval = 0
};
addtionOption1.title.x = "left";
return(addtionOption1);
}
public PagedResults GetWIPData(WIPProfileInput input)
{
string filter = string.Empty;
filter = Getfilter(input, "data");
string sql = string.Format(listSQL, filter);
return(base.PagingQueryDataTable(sql, input));
}
public string Getfilter(WIPProfileInput input, string flag)
{
string s1 = "1";
string s2 = "1";
string s3 = "1";
if (flag == "data")
{
s1 = "fwt.txntimestamp";
s2 = "ProductName";
s3 = "lot.lottype";
}
else if (flag == "chart")
{
s1 = "RECORD_DATE";
s2 = "substr(partid,1,length(partid)-2)";
s3 = "lottype";
}
string filter = string.Empty;
if (input.IsIncludeEngLots == false)
{
filter = " AND " + s3 + " = 'P' ";
}
string filter2 = string.Empty;
if (input.Product != null && input.Product.Length > 0)
{
filter2 = string.Format(" AND " + s2 + " IN ('{0}')", input.Product);
}
string filter6 = string.Empty;
if (input.Stage != null && input.Stage.Length > 0)
{
filter6 = string.Format(" AND hs.stagename = ('{0}')", input.Stage);
}
string filter3 = string.Empty;
if (flag == "data")
{
if (input.ByDate == "1")
{
// System.DateTime currentTime = new System.DateTime();
DateTime dt = DateTime.Now;
// DateTime now = DateTime.Now;
input.StartTime = dt.ToString();
if (dt.Hour >= 8)
{
filter3 = " AND to_date(substr( " + s1 + ",0,15),'yyyy-mm-dd hh24:mi:ss') between to_date(substr(:StartTime,1,10) || ' 08:00:00','yyyy-mm-dd hh24:mi:ss') and to_date(:StartTime , 'yyyy-mm-dd hh24:mi:ss') ";
}
else
{
filter3 = " AND to_date(substr(" + s1 + ",0,15),'yyyy-mm-dd hh24:mi:ss') between to_date(to_char(:StartTime-1,'yyyy-mm-dd') || ' 08:00:00','yyyy-mm-dd hh24:mi:ss') and to_date(:StartTime , 'yyyy-mm-dd hh24:mi:ss') ";
}
}
else if (input.ByDate == "2")
{
filter3 = " AND to_date(substr(" + s1 + ",0,15),'yyyy-mm-dd hh24:mi:ss') between to_date(to_char(to_date(:StartTime,'yyyy-mm-dd')-1,'yyyy-mm-dd') || ' 08:00:00','yyyy-mm-dd hh24:mi:ss') and to_date(:StartTime|| ' 08:00:00', 'yyyy-mm-dd hh24:mi:ss')";
}
}
else if (flag == "chart")
{
if (input.ByDate == "1")
{
filter3 = " AND to_date( " + s1 + ",'yyyymmdd') = to_date(replace(:StartTime,'-',''),'yyyymmdd') ";
}
else if (input.ByDate == "2")
{
filter3 = " AND to_date( " + s1 + ",'yyyymmdd') = to_date(replace(:StartTime,'-',''),'yyyymmdd') ";
}
}
string sumfilter = filter + filter2 + filter3 + filter6;
return(sumfilter);
}
public JsonResult QueryChartData(WIPProfileInput input)
{
return(Json(_WIPProfileLogicLogic.GetCHART(input)));
}
public JsonResult QueryWIPData(WIPProfileInput input)
{
return(JsonForGridPaging(_WIPProfileLogicLogic.QueryWIPData(input)));
}
public PagedResults QueryWIPData(WIPProfileInput input)
{
var pageResults = _HoldLotInfoRepository.GetWIPData(input);
return(pageResults);
}
