/**
 * D8-1 Move D12 ) Estimated Agent's Commission: 
 * Formula: =D5*D8*1.07
 *  		=D8 * D11 + GST
 * @param NA  csp-esp1, csp-eac1, csp-eac11
 * @return NA
 */
function cspEstimatedAgentsCommission1()
{
	//D5
	var csp_esp1 = parseFloat(formatToNumeric(getInputValue('#csp-esp1')));
	//D8
	var csp_eac1 = parseFloat(formatToNumeric(getInputValue('#csp-eac1')));
	//GST
	var csp_gst1 = parseFloat(formatToNumeric(getInputValue('#csp-gst1')));
	
	var reuslt_1 = ((csp_esp1 * csp_eac1) / 100 );
	var reuslt_2 = (reuslt_1 * csp_gst1  / 100) ;
	
	var reuslt = (reuslt_1 + reuslt_2);

	setInputValue('#csp-eac11', convertIntoCurrency(reuslt));
	cspCashFromSale3();
	cspCashRequired4();
}

/**
 * D15: Amount To Be Returned To CPF 
 * Formula: =D13+D14
 *
 * @param NA
 * @return NA
 */
function cspAmountReturnedCPF2O1()
{
	//D13
	var csp_cpfu2o1 = parseFloat(formatToNumeric(getInputValue('#csp-cpfu2o1')));
	//D14
	var csp_cpfai2o1 = parseFloat(formatToNumeric(getInputValue('#csp-cpfai2o1')));
	var reuslt_1 = csp_cpfu2o1 + csp_cpfai2o1;
	setInputValue('#csp-atbrtcpf2o1', convertIntoCurrency(reuslt_1));
	cspTotalAmountReturnedCPF3();
	cspIndividualCPFAvailableSaleCompletion6O1();
	cspTotalCPFAvailableSaleCompletion7();
}

/**
 * E15: Amount To Be Returned To CPF 
 * Formula: =E13+E14
 *
 * @param NA
 * @return NA
 */
function cspAmountReturnedCPF2O2()
{
	//E13
	var csp_cpfu2o2 = getInputValue('#csp-cpfu2o2');
	if(csp_cpfu2o2 != 'NA')
	{
		//E13
		var csp_cpfu2o2 = parseFloat(formatToNumeric(csp_cpfu2o2));
		//E14
		var csp_cpfai2o2 = parseFloat(formatToNumeric(getInputValue('#csp-cpfai2o2')));
		var reuslt_1 = csp_cpfu2o2 + csp_cpfai2o2;
		setInputValue('#csp-atbrtcpf2o2', convertIntoCurrency(reuslt_1));
	}
	cspTotalAmountReturnedCPF3();
	cspTotalCPFAvailableSaleCompletion7();
	cspIndividualCPFAvailableSaleCompletion6O2();
}

/**
 * D18: 7) Total Amount To Be Returned To CPF 
 * Formula: =D15+E15
 *
 * @param NA
 * @return NA
 */
function cspTotalAmountReturnedCPF3()
{
	//D15
	var csp_atbrtcpf2o1 = parseFloat(formatToNumeric(getInputValue('#csp-atbrtcpf2o1')));
	//E15
	var csp_atbrtcpf2o2 = parseFloat(formatToNumeric(getInputValue('#csp-atbrtcpf2o2')));
	var reuslt_1 = csp_atbrtcpf2o1 + csp_atbrtcpf2o2;
	setInputValue('#csp-tatbrtcpf3', convertIntoCurrency(reuslt_1));
	cspCashFromSale3();
	cspNettCPFReturnedAfterLoss4();
	cspIndividualCPFAvailableSaleCompletion6O1();
}

/**
 * D19: Cash From Sale [1-(2+3+4+5+6+7)] 
 * Formula: =D5-(D6+D7+D8+D9+D10+D18)
			=D8-(D9+D10+D12+D13+D14+D22)
 *
 * @param NA
 * @return NA
 */
function cspCashFromSale3()
{
	//D5
	var csp_esp1 = parseFloat(formatToNumeric(getInputValue('#csp-esp1')));
	//D6
	var csp_ola1 = parseFloat(formatToNumeric(getInputValue('#csp-ola1')));
	//D7
	var csp_elf1 = parseFloat(formatToNumeric(getInputValue('#csp-elf1')));
	//D8
	var csp_eac11 = parseFloat(formatToNumeric(getInputValue('#csp-eac11')));
	//D9
	var csp_ssd1 = parseFloat(formatToNumeric(getInputValue('#csp-ssd1')));
	//D10
	var csp_bc1 = parseFloat(formatToNumeric(getInputValue('#csp-bc1')));
	//D18
	var csp_tatbrtcpf3 = parseFloat(formatToNumeric(getInputValue('#csp-tatbrtcpf3')));
	var reuslt_1 = csp_esp1 - (csp_ola1 + csp_elf1 + csp_eac11 + csp_ssd1 + csp_bc1 + csp_tatbrtcpf3);
	setInputValue('#csp-cfs3', convertIntoCurrency(reuslt_1));
	cspNettCPFReturnedAfterLoss4();
	cspCashRequired4();
	cspCashAvailableAfterSaleCompletion5();
}


/**
 * D23: Nett CPF To Be Returned after loss 
 * Formula: =IF(D19<0,D18+(D5-D6-D18),"NA")
 				F(D23<0,D22+(D8-D9-D22),"NA")
 *
 * @param NA
 * @return NA
 */
function cspNettCPFReturnedAfterLoss4()
{
	//D19
	var csp_cfs3 = parseFloat(formatToNumeric(getInputValue('#csp-cfs3')));
	//D18
	var csp_tatbrtcpf3 = parseFloat(formatToNumeric(getInputValue('#csp-tatbrtcpf3')));
	//D5
	var csp_esp1 = parseFloat(formatToNumeric(getInputValue('#csp-esp1')));
	//D6
	var csp_ola1 = parseFloat(formatToNumeric(getInputValue('#csp-ola1')));
	var reuslt_1 = 0;
	if(csp_cfs3 < 0)
	{
		reuslt_1 = convertIntoCurrency(formatToNumeric(csp_tatbrtcpf3 + (csp_esp1 - csp_ola1 - csp_tatbrtcpf3)));
	}
	else
	{
		reuslt_1 = 'NA';
	}
	setInputValue('#csp-ncpftbral4', reuslt_1);
	cspCashAvailableAfterSaleCompletion5();
	cspIndividualCPFAvailableSaleCompletion6O1();
	cspTotalCPFAvailableSaleCompletion7();
	readonly1();
}

/**
 * D24: Cash required (Commission + Legal Fee) 
 * Formula: =IF(D19<0,D8+D7,"NA")
			 =IF(D23<0,D12+D10,"NA")
 *
 * @param NA
 * @return NA
 */
function cspCashRequired4()
{
	//D19
	var csp_cfs3 = parseFloat(formatToNumeric(getInputValue('#csp-cfs3')));
	//D8
	var csp_eac11 = parseFloat(formatToNumeric(getInputValue('#csp-eac11')));
	//D7
	var csp_elf1 = parseFloat(formatToNumeric(getInputValue('#csp-elf1')));
	var reuslt_1 = 0;
	if(csp_cfs3 < 0)
	{
		reuslt_1 = convertIntoCurrency(formatToNumeric(csp_eac11 + csp_elf1));
	}
	else
	{
		reuslt_1 = 'NA';
	}
	setInputValue('#csp-cr4', reuslt_1);
	cspCashAvailableAfterSaleCompletion5();
	readonly1();
}

/**
 * D28: Cash Available After Sale Completion 
 * Formula: =IF(D23="NA",D27+D19,D27-D24)
 *
 * @param NA
 * @return NA
 */
function cspCashAvailableAfterSaleCompletion5()
{
	//D23
	var csp_ncpftbral4 = getInputValue('#csp-ncpftbral4');
	//D27
	var csp_ccatsa5 = parseFloat(formatToNumeric(getInputValue('#csp-ccatsa5')));
	//D19
	var csp_cfs3 = parseFloat(formatToNumeric(getInputValue('#csp-cfs3')));
	//D24
	var csp_cr4 = parseFloat(formatToNumeric(getInputValue('#csp-cr4')));
	var reuslt_1 = 0;
	if(csp_ncpftbral4 == 'NA')
	{
		reuslt_1 = csp_ccatsa5 + csp_cfs3;
	}
	else
	{
		reuslt_1 = csp_ccatsa5 - csp_cr4;
	}
	setInputValue('#csp-caasc5', convertIntoCurrency(reuslt_1));
	cspTotalCashCPFAvailable8();
}

/**
 * D31: Individual CPF Available After Sale Completion (1 Month Later) 
 * Formula: =IF(D23="NA",D15+D30,D15-(D18-D23)+D30)
 *
 * @param NA
 * @return NA
 */
function cspIndividualCPFAvailableSaleCompletion6O1()
{
	//D23
	var csp_ncpftbral4 = getInputValue('#csp-ncpftbral4');
	//D15
	var csp_atbrtcpf2o1 = parseFloat(formatToNumeric(getInputValue('#csp-atbrtcpf2o1')));
	//D30
	var csp_ccpfatbu6o1 = parseFloat(formatToNumeric(getInputValue('#csp-ccpfatbu6o1')));
	//D18
	var csp_tatbrtcpf3 = parseFloat(formatToNumeric(getInputValue('#csp-tatbrtcpf3')));
	var reuslt_1 = 0;
	if(csp_ncpftbral4 == 'NA')
	{
		reuslt_1 = csp_atbrtcpf2o1 + csp_ccpfatbu6o1;
	}
	else
	{
		//D23
		var csp_ncpftbral4 = parseFloat(formatToNumeric(csp_ncpftbral4));
		reuslt_1 = csp_atbrtcpf2o1 - (csp_tatbrtcpf3 - csp_ncpftbral4) + csp_ccpfatbu6o1;
	}
	setInputValue('#csp-icpfaasc601', convertIntoCurrency(reuslt_1));
}

/**
 * E31: Individual CPF Available After Sale Completion (1 Month Later) 
 * Formula: =E15+E30
 *
 * @param NA
 * @return NA
 */
function cspIndividualCPFAvailableSaleCompletion6O2()
{
	//E15
	var csp_atbrtcpf2o2 = parseFloat(formatToNumeric(getInputValue('#csp-atbrtcpf2o2')));
	//E30
	var csp_ccpfatbu6o2 = parseFloat(formatToNumeric(getInputValue('#csp-ccpfatbu6o2')));
	var reuslt_1 = csp_atbrtcpf2o2 + csp_ccpfatbu6o2;
	setInputValue('#csp-icpfaasc602', convertIntoCurrency(reuslt_1));
}

/**
 * D33: Total Current CPF 
 * Formula: =D30+E30
 *
 * @param NA
 * @return NA
 */
function cspTotalCurrentCPF7()
{
	//D30
	var csp_ccpfatbu6o1 = parseFloat(formatToNumeric(getInputValue('#csp-ccpfatbu6o1')));
	//E30
	var csp_ccpfatbu6o2 = parseFloat(formatToNumeric(getInputValue('#csp-ccpfatbu6o2')));
	var reuslt_1 = csp_ccpfatbu6o1 + csp_ccpfatbu6o2;
	setInputValue('#csp-tccpf7', convertIntoCurrency(reuslt_1));
	cspTotalCPFAvailableSaleCompletion7();
}

/**
 * D34: Total CPF Available After Sale Completion (1 Month Later) 
 * Formula: =IF(D23="NA",D15+E15+D33,D23+D33)
 *
 * @param NA
 * @return NA
 */
function cspTotalCPFAvailableSaleCompletion7()
{
	//D23
	var csp_ncpftbral4 = getInputValue('#csp-ncpftbral4');
	//D15
	var csp_atbrtcpf2o1 = parseFloat(formatToNumeric(getInputValue('#csp-atbrtcpf2o1')));
	//E15
	var csp_atbrtcpf2o2 = parseFloat(formatToNumeric(getInputValue('#csp-atbrtcpf2o2')));
	//D33
	var csp_tccpf7 = parseFloat(formatToNumeric(getInputValue('#csp-tccpf7')));
	var reuslt_1 = 0;
	if(csp_ncpftbral4 == 'NA')
	{
		reuslt_1 = csp_atbrtcpf2o1 + csp_atbrtcpf2o2 + csp_tccpf7;
	}
	else
	{
		//D23
		var csp_ncpftbral4 = parseFloat(formatToNumeric(csp_ncpftbral4));
		reuslt_1 = csp_ncpftbral4 + csp_tccpf7;
	}
	setInputValue('#csp-tcpfaasc7', convertIntoCurrency(reuslt_1));
	cspTotalCashCPFAvailable8();
}

/**
 * D36: Total Cash + CPF Available 
 * Formula: =D28+D34
 *
 * @param NA
 * @return NA
 */
function cspTotalCashCPFAvailable8()
{
	//D28
	var csp_caasc5 = parseFloat(formatToNumeric(getInputValue('#csp-caasc5')));
	//D34
	var csp_tcpfaasc7 = parseFloat(formatToNumeric(getInputValue('#csp-tcpfaasc7')));
	var reuslt_1 = csp_caasc5 + csp_tcpfaasc7;
	setInputValue('#csp-tccpfa8', convertIntoCurrency(reuslt_1));
}


/**
 * D36: Total Cash + CPF Available 
 * Formula: =String
 *
 * @param NA
 * @return NA
 */
function cspFunCPFOwner11()
{
	//Dxx
	var csp_cpf_owner_11 = getInputValue('#csp-cpf-owner-11');
	var csp_cpf_owner_11_cr = ['#csp-owner-11'];
	bayersellerChainReaction(csp_cpf_owner_11, csp_cpf_owner_11_cr);
}

/**
 * D37: Total Cash + CPF Available 
 * Formula: =String
 *
 * @param NA
 * @return NA
 */
function cspFunCPFOwner12()
{
	//Dxx
	var csp_cpf_owner_12 = getInputValue('#csp-cpf-owner-12');
	var csp_cpf_owner_12_cr = ['#csp-owner-12'];
	bayersellerChainReaction(csp_cpf_owner_12, csp_cpf_owner_12_cr);
}

function readonly1()
{
	var csp_cpfai2o2_currency = getInputValue('#csp-cpfu2o2');
	var csp_cpfai203_currency = getInputValue('#csp-cpfu2o2');
	var csp_cpfu2o1_currency = getInputValue('#csp-cpfu2o2');
	var csp_ccpfatbu6o2_curncy = getInputValue('#csp-cpfu2o2');
	var csp_icpfaasc602_curncy = getInputValue('#csp-cpfu2o2');
	
	var csp_ncpftbral4_crncy = getInputValue('#csp-ncpftbral4');
	var csp_cr4_crncy = getInputValue('#csp-cr4');
	
	document.getElementById("csp-cpfu2o1-currency").innerHTML = addRemovedoller(csp_cpfu2o1_currency);
	document.getElementById("csp-cpfai2o2-currency").innerHTML = addRemovedoller(csp_cpfai2o2_currency);
	document.getElementById("csp-cpfai203-currency").innerHTML = addRemovedoller(csp_cpfai203_currency);

	document.getElementById("csp-ncpftbral4-crncy").innerHTML = addRemovedoller(csp_ncpftbral4_crncy);
	document.getElementById("csp-cr4-crncy").innerHTML = addRemovedoller(csp_cr4_crncy);

	document.getElementById("csp-ccpfatbu6o2-curncy").innerHTML = addRemovedoller(csp_ccpfatbu6o2_curncy);
	document.getElementById("csp-icpfaasc602-curncy").innerHTML = addRemovedoller(csp_icpfaasc602_curncy);

}


/**
 * INPUT: Change Refence input values when focus out
 *
 * @param NA
 * @return NA
 */
function changeRefWhenFocusOutINPUT()
{
	//alert('a');
	cspEstimatedAgentsCommission1();
	cspAmountReturnedCPF2O1();
	cspAmountReturnedCPF2O2();
	cspCashFromSale3();
	cspNettCPFReturnedAfterLoss4();
	cspCashRequired4();
	cspCashAvailableAfterSaleCompletion5();
	cspIndividualCPFAvailableSaleCompletion6O1();
	cspIndividualCPFAvailableSaleCompletion6O2();
	cspTotalCurrentCPF7();
}

/**
 * Sales Proceeds
 *
 * @param NA
 * @return NA
 */
function salesProceeds()
{
	validateInputCurrencyINPUT('#csp-esp1', false, null, null);
	validateInputCurrencyINPUT('#csp-ola1', false, null, null);
	validateInputCurrencyINPUT('#csp-elf1', false, null, null);
	validateInputNumericINPUT('#csp-eac1', false, null, null);
	validateInputNumericINPUT('#csp-gst1', false, null, null);

	//allLetter('#csp-cpf-owner-11');
	//lettersOnly('#csp-cpf-owner-11', evt);
	
	cspEstimatedAgentsCommission1();
	$('#csp-esp1').keyup(function()
	{
		cspEstimatedAgentsCommission1();
	});
	$('#csp-eac1').keyup(function()
	{
		cspEstimatedAgentsCommission1();
	});
	$('#csp-gst1').keyup(function()
	{
		cspEstimatedAgentsCommission1();
	});

	
	validateInputCurrencyINPUT('#csp-ssd1', false, null, null);
	validateInputCurrencyINPUT('#csp-bc1', false, null, null);
	validateInputCurrencyINPUT('#csp-cpfu2o1', false, null, null);
	validateInputCurrencyINPUT('#csp-cpfai2o1', false, null, null);
	validateInputCurrencyINPUT('#csp-cpfai2o2', false, null, null);
	cspAmountReturnedCPF2O1();
	$('#csp-cpfu2o1').keyup(function()
	{
		cspAmountReturnedCPF2O1();
	});
	$('#csp-cpfai2o1').keyup(function()
	{
		cspAmountReturnedCPF2O1();
	});
	cspAmountReturnedCPF2O2();
	$('#csp-cpfu2o2').keyup(function()
	{
		cspAmountReturnedCPF2O2();
	});
	$('#csp-cpfai2o2').keyup(function()
	{
		cspAmountReturnedCPF2O2();
	});
	
	cspCashFromSale3();
	$('#csp-esp1').keyup(function()
	{
		cspCashFromSale3();
	});
	$('#csp-ola1').keyup(function()
	{
		cspCashFromSale3();
	});
	$('#csp-elf1').keyup(function()
	{
		cspCashFromSale3();
	});
	$('#csp-ssd1').keyup(function()
	{
		cspCashFromSale3();
	});
	$('#csp-bc1').keyup(function()
	{
		cspCashFromSale3();
	});
	
	cspNettCPFReturnedAfterLoss4();
	$('#csp-esp1').keyup(function()
	{
		cspNettCPFReturnedAfterLoss4();
	});
	$('#csp-ola1').keyup(function()
	{
		cspNettCPFReturnedAfterLoss4();
	});
	
	cspCashRequired4();
	$('#csp-elf1').keyup(function()
	{
		cspCashRequired4();
	});
	
	validateInputCurrencyINPUT('#csp-ccatsa5', false, null, null);
	
	cspCashAvailableAfterSaleCompletion5();
	$('#csp-ccatsa5').keyup(function()
	{
		cspCashAvailableAfterSaleCompletion5();
	});
	
	validateInputCurrencyINPUT('#csp-ccpfatbu6o1', false, null, null);
	validateInputCurrencyINPUT('#csp-ccpfatbu6o2', false, null, null);
	
	cspIndividualCPFAvailableSaleCompletion6O1();
	$('#csp-ccpfatbu6o1').keyup(function()
	{
		cspIndividualCPFAvailableSaleCompletion6O1();
	});
	
	cspIndividualCPFAvailableSaleCompletion6O2();
	$('#csp-ccpfatbu6o2').keyup(function()
	{
		cspIndividualCPFAvailableSaleCompletion6O2();
	});
	
	cspTotalCurrentCPF7();
	$('#csp-ccpfatbu6o1').keyup(function()
	{
		cspTotalCurrentCPF7();
	});
	$('#csp-ccpfatbu6o2').keyup(function()
	{
		cspTotalCurrentCPF7();
	});
	
	$('#csp-cpf-owner-11').keyup(function()
	{
		cspFunCPFOwner11();
	});
	
	$('#csp-cpf-owner-12').keyup(function()
	{
		cspFunCPFOwner12();
	});
	
	var csp_cpfu2o2_naZero = ['#csp-cpfai2o2', '#csp-atbrtcpf2o2','#csp-icpfaasc602','#csp-ccpfatbu6o2'];
	var csp_cpfu2o2_roOrNot = ['#csp-cpfai2o2', '#csp-icpfaasc602'];
	validateInputCurrencyINPUT('#csp-cpfu2o2', true, csp_cpfu2o2_naZero, csp_cpfu2o2_roOrNot);

	readonly1();
	$('#csp-cpfu2o2').keyup(function()
	{
		readonly1();
	});
	
}
jQuery(document).ready(function()
{
	salesProceeds();
});
jQuery(window).on('load', function()
{	
});
jQuery(window).resize(function()
{
});
window.onscroll = function()
{
};