YNU_JEUS/app_home/himed/xpapps/mis/miscommonxp/xp/RAM001.xjs

<?xml version="1.0" encoding="utf-8"?>
<Script type="xscript4.0"><![CDATA[function ramfCashFlowFormula(valuenode, seqcolumn, calculationcolumn, sourcecolumn, returncolumn, optcolumn, maxcalseq, calbase)
{
	var instancerows = eval(valuenode).rowcount;
	var instancefirstrow = 0;

	var seq = 0;
	var seqmappingrownum = new Array();
	var arrvalue = new Array();
	
	var optarr = optcolumn.split(',');
	var optarrlength = optarr.length;
	
	var calarr = sourcecolumn.split(',');
	var calarrlength = calarr.length;
	var returnarr = returncolumn.split(',');
	var returnarrlength = returnarr.length;
	
	var insertionValue = 0;
	if(calarrlength != returnarrlength)
	{
		sysf_messageBox("계산식 필드 애러", "E008");
	}			
		
	calarrvalue = new Array(instancerows);
	
	for(var i = instancefirstrow ; i < instancerows ; i++)
	{	
		calarrvalue[i] = new Array(calarrlength);
							
		for(var j = 0 ; j < calarrlength; j++)
		{
			if(utlf_isNull(eval(valuenode).getColumn(i, calarr[j])))
			{
				insertionValue = 0;
			}
			else
			{
				insertionValue = eval(valuenode).getColumn(i, calarr[j]);
			}
			calarrvalue[i][j] = insertionValue;	
		}
		seqmappingrownum[i] = eval(valuenode).getColumn(i, seqcolumn);		
	}
	for(var m = instancefirstrow ; m < instancerows ; m++)
	{
		if(!utlf_isNull(eval(valuenode).getColumn(m, calculationcolumn)) && maxcalseq == eval(valuenode).getColumn(m, optarr[1]))
		{
			var minusstr = "";
			var plusstr = "";
			
			var temparr = eval(valuenode).getColumn(m, calculationcolumn)
									
			arr = temparr.split("-");
			
			for( i = 0 ; i < arr.length ; i++ )
			{
				if( i == 0 )
				{											 						
					var firstarr = arr[i].split("+");
					if(firstarr.length > 0)
					{
						for( k = 0 ; k < firstarr.length ; k++)
						{
							plusstr = plusstr +  firstarr[k] + "|";
						}
					}
				}
				else
				{
					var unitarr = arr[i].split("+");
					
					minusstr = minusstr + unitarr[0] + "|";
					
					if(unitarr.length > 1)
					{
						for(k = 1 ; k < unitarr.length ; k++)
						{
							plusstr = plusstr + unitarr[k] + "|";
						}
					}							
				}
			}
			
			var plusarr = plusstr.split("|");
			var minusarr = minusstr.split("|");						
			
			var resultarr = new Array();
			
			for(k = 0 ; k <  calarrlength ; k++)
			{
				 resultarr[k] = 0;
			}
 
			for(var i = instancefirstrow ; i < instancerows ; i++)
			{							
				for(var j = 0 ; j < plusarr.length; j++)
				{
					if(plusarr[j] ==  seqmappingrownum[i])
					{
						for(var k = 0 ; k <  calarrlength ; k++)
						{
							 resultarr[k] =  parseInt(resultarr[k]) + parseInt(calarrvalue[i][k]);
						}
					}
				}
				
				for(var j = 0 ; j < minusarr.length - 1 ; j++)
				{
					if(minusarr[j] ==  seqmappingrownum[i])
					{
						for(var k = 0 ; k <  calarrlength ; k++)
						{
							 resultarr[k] =  parseInt(resultarr[k]) - parseInt(calarrvalue[i][k]);
						}
					}
				}
			}
			
			for(k = 0 ; k < calarrlength  ; k++)
			{      
				if((calbase == "N" || !utlf_isNull(calbase) && eval(valuenode).getColumn(m, "prntnm4") == calbase))
				{
					eval(valuenode).enableevent = false;
					eval(valuenode).setColumn(m, returnarr[k], resultarr[k]);
					eval(valuenode).enableevent = true;
				}			 
			}	
		}
	}
}

function ramfSheetColor(grid, lowhightacnt, printcolRef)
{
	var dataset = this.objects[grid.binddataset]
	for(var i = 0; i < dataset.rowcount; i++)
	{	
		dataset.enableevent = false;
		dataset.updatecontrol = false;
		if(dataset.getColumn(i, "acntclsflag") == '5')
		{
			misfSetGridColor(grid, "all", "#ffff99", "B",i);
			dsf_makeValue(dataset, "font", "string", "arial,9,bold", i);
			dsf_makeValue(dataset, "align", "string", "center middle", i);
		}
		else if(dataset.getColumn(i, "acntclsflag") == '4')
		{							
			misfSetGridColor(grid, "all", "#99ccff", "B",i);
			dsf_makeValue(dataset, "font", "string", "arial,9,bold", i);
			dsf_makeValue(dataset, "align", "string", "left middle", i);
		}
		else if(dataset.getColumn(i, "acntclsflag") == '3')
		{	
			misfSetGridColor(grid, "all", "#66ffff", "B",i);
			dsf_makeValue(dataset, "font", "string", "", i);
			dsf_makeValue(dataset, "align", "string", "left middle", i);
		}
		else if(dataset.getColumn(i, "acntclsflag") == '2')
		{	
			misfSetGridColor(grid, "all", "#ccffff", "B",i);
			dsf_makeValue(dataset, "font", "string", "", i);
			dsf_makeValue(dataset, "align", "string", "left middle", i);
		}
		else if(dataset.getColumn(i, "acntclsflag") == '1')
		{	
			misfSetGridColor(grid, "all", "#ffffee", "B",i);
			dsf_makeValue(dataset, "font", "string", "", i);
			dsf_makeValue(dataset, "align", "string", "left middle", i);
		}
		else if(dataset.getColumn(i, "acntclsflag") == '0')
		{	
			misfSetGridColor(grid, "all", "#ffffff", "B",i);
			dsf_makeValue(dataset, "font", "string", "", i);
			dsf_makeValue(dataset, "align", "string", "left middle", i);
		}
		dataset.updatecontrol = true;
		dataset.enableevent = true;
	}
	
	for(var j = 1; j < grid.getFormatColCount(); j++)
	{
		grid.setCellProperty("Body", j, "font", "BIND:font");
		grid.setCellProperty("Body", grid.getBindCellIndex("Body", printcolRef), "align", "BIND:align");
	}
	
}

/****************************************************************************************
 * Argument			: lowhightacnt	- 데이터셋 컬럼 '/' 로 컬럼 구분 ex) ds_send/columnid 
 *					: gridnode		- 그리드
 *					: calline
 * Description		: 
 ****************************************************************************************/
function ramfLineSetting(lowhightacnt, gridnode, calline)
{
	var s_lowhightacnt = lowhightacnt.split("/");
	var dataset = s_lowhightacnt[0];
	var columnid = s_lowhightacnt[1];
	
	if(eval(dataset).getColumn(0, columnid) == "0")
	{
		var lineflag = "0";
	}
	else
	{
		var lineflag = "1";
	}			

	var preacntflag = "N";
	
	for(var i = 0 ; i < eval(gridnode).rowcount; i++ )
	{
		if(preacntflag == lineflag && eval(gridnode).getColumn(i, "acntclsflag") == lineflag)
		{
			eval(gridnode).setColumn(i, calline, "no_upline")			
		}
		var preacntflag = eval(gridnode).getColumn(i, "acntclsflag");
	}					
}

function ramfFnworksheetAlign(valnode, valcol, comparedcol, Avalset, Asetcol, Bvalset, Bsetcol, Cvalset, Csetcol, Dvalset, Dsetcol)
{
	var arrvalcol = valcol.split(",");						
	var arrAvalset 	= Avalset.split(",");
	var arrAsetcol 	= Asetcol.split(",");
	var arrBvalset 	= Bvalset.split(",");
	var arrBsetcol	= Bsetcol.split(",");
	
	for(var i = 0; i < eval(valnode).rowcount; i++)
	{
		for(j = 0 ; j < arrAvalset.length ; j++)
		{
			if(eval(valnode).getColumn(i, comparedcol) == arrAvalset[j])
			{
				for(m = 0 ; m < valcol.length ; m++)
				{
					if(!utlf_isNull(eval(valnode).getColumn(i, arrvalcol[m])))
					{
						eval(valnode).setColumn(i, arrAsetcol[m], eval(valnode).getColumn(i, arrvalcol[m]));										
					}
				}
			}
			break;
		}
		
		for(j = 0 ; j < arrBvalset.length ; j++)
		{
			if(eval(valnode).getColumn(i, comparedcol) == arrBvalset[j])
			{
				for(m = 0 ; m < valcol.length ; m++)
				{
					if(!utlf_isNull(eval(valnode).getColumn(i, arrvalcol[m])))
					{
						eval(valnode).setColumn(i, arrBsetcol[m], eval(valnode).getColumn(i, arrvalcol[m]));										
					}
				}
				break;
			}
		}						
	}
}	]]></Script>