http://app001.ir-win.com/irwindevfs/index.html?sk=GFxM%24Jk1K4bngrNCfX2UEZWLzJdQ3Fgj0lEimhdmORB9owHKfmC5jRU3h3I48wOLDc3ZrZz%24YpieqkloearxIKU7q0wJdSddGkTK&loc=http%3A%2F%2Fapp001.ir-win.com%2Firwindevfs%2F&ht=1&aid=


$sk = urldecode(CCGetFromGet("sk","0"));
	
	$varUserID = CCDLookUp("`UserID`", "`sessions`", "`SessionKey` = '".$sk."'", $DBIrwinSQL);
	$varUserLogin = CCDLookUp("`UserLogin`", "`users`", "`UserID` = '".$varUserID."'", $DBIrwinSQL);
	$varGroupID = CCDLookUp("`GroupID`", "`users`", "`UserID` = '".$varUserID."'", $DBIrwinSQL);
	$UserAddr = CCDLookUp("`IPV4Address`", "`sessions`", "`SessionKey` = '".$sk."'", $DBIrwinSQL);
	
	//$SessionUserServer = CCDLookUp("`Server`", "`users`", "`UserID` = '".$varUserID."'", $Page->Connections["IrwinSQL"]);
	$SessionServer = CCDLookUp("`ServerID`", "`accounts` a inner join `assignments` asg on a.AccountID = asg.AccountID`", "asg.BusinessCaseID = 0 and asg.UserID ='".$varUserID."'", $Page->Connections["IrwinID"]);
	$SessionServerDomain = CCDLookUp("`Domain`", "`servers`", "`ServerID` = '".$SessionServer."'", $Page->Connections["IrwinID"]);

	if($varGroupID == 1){
		global $Redirect;
		CCSetSession("varUsersAcc", 0);
		$homeType = "1"; // User is admin
	}else{			
		$nbOfAccts = CCDLookUp("COUNT(*)", assignments, "UserID = ".CCGetSession("varUserID")." and BusinessCaseID = 0 and RoleID = 0", $Page->Connections["IrwinSQL"]);
		
		if ($nbOfAccts == 1) {
			$usersAcc = CCDLookUp(AccountID, assignments, "UserID = ".CCGetSession("varUserID"), $Page->Connections["IrwinID"]);
			$location = "Location: ".$SessionServerDomain."Account/Account_view.php?sk=".$sk."&AccountID=".$usersAcc;
		}
		else if (nbOfAccts > 1) {
			$location = "Location: ".$SessionServerDomain."Account/Accounts_List.php?sk=".$sk;
		}
		else {
			$location = "Location: ".$SessionServerDomain."AccessDenied.php"; // access denied, the user has not account and is no admin
		}
			
	}
	
	
http://id01.ir-win.com/Redirector.php?sk=A7jO9ZZSCR6czRqIg0NF1NGXNkwQBa9PzL4ip63sMdT3FY0s0eu%24XIYail%24r9l815PZCmVBognEIzRyc1rbKfRHX5nGgGbf90lzn	
=INDEX(C76:N76,MATCH(TRUE,C76:N76>0,0))


/* ================== Balance Sheet  ============== */
declare intBalSheetOpening				int(11);
declare intBalSheetCash					int(11);
declare intBalSheetAR					int(11);
declare intBalSheetInventory			int(11);
declare intBalSheetFixedAsset			int(11);
declare intBalSheetFixedAssetAccAmort	int(11);
declare intBalSheetProjects				int(11);
declare intBalSheetProjectsAccAmort		int(11);
declare intBalSheetOtherAssets			int(11);
declare intBalSheetOtherAssetsAccAmort	int(11);
declare intBalSheetAP					int(11);
declare intBalSheetLeaseObligations		int(11);
declare intBalSheetLoansAdvances		int(11);
declare intBalSheetOtherLiabilities		int(11);
declare intBalSheetIncomeTaxesPayable	int(11);
declare intBalSheetInvestments			int(11);
declare intBalSheetRetainedEarnings		int(11);

declare decBSOpenCash 				decimal(20,8);
declare decBSOpenAR 				decimal(20,8);
declare decBSOpenInventory 			decimal(20,8);
declare decBSOpenFixedAsset			decimal(20,8);
declare decBSOpenFAAccumAmort 		decimal(20,8);
declare decBSOpenProject 			decimal(20,8);
declare decBSOpenPrAccumAmort 		decimal(20,8);
declare decBSOpenOtherAssets 		decimal(20,8);
declare decBSOpenOAAccumAmort 		decimal(20,8);
declare decBSOpenAP		 			decimal(20,8);
declare decBSOpenLeaseOblig 		decimal(20,8);
declare decBSOpenLoansAdv	 		decimal(20,8);
declare decBSOpenOtherLiabilities 	decimal(20,8);
declare decBSOpenIncTaxPayable 		decimal(20,8);
declare decBSOpenInvestments	 	decimal(20,8);
declare decBSOpenRetainedEarnings 	decimal(20,8);
/* ================================================ */



$sql	\r\n\tselect\r\n\t\tMonth\r\n\t\t, sum(DecimalValue) as decData\r\n\tfrom\r\n\t  report_calculation_items\r\n\twhere\r\n\t(\r\n\t   CalcItemTypePVID = 154\r\n\t  or CalcItemTypePVID = 157\r\n\t  or CalcItemTypePVID = 158\r\n\t  or CalcItemTypePVID = 161\r\n\t)\r\n\tand ReportInstanceID = 14\r\n\tgroup by month\r\n\torder by month asc\r\n\t	
decTmpTableE


intManufacturingStartingUnitsPVID


ReportInstanceGenerator
CalcItemParentID

CalcItemTypePVID	

BalanceSheetAccumulatedAmortization

Bal. Sheet Fixed Asset Accumulated Amortization


	//////////////////////////////////
	// A/R
	//////////////////////////////////
	// Line : 88
	// Formula : =D88-D51

	$objPHPExcel->setActiveSheetIndex(0)
	->setCellValue(num2alpha(0+$xOffset).(string)(88+$yOffset), 'A/R');
	$objPHPExcel->getActiveSheet()->getColumnDimension(num2alpha(0+$xOffset))->setAutoSize(true);

	$cellFormula = '=SUM('
		.num2alpha(2+$xOffset).(string)(88+$yOffset)
		.'+'.num2alpha(2+$xOffset).(string)(51+$yOffset)
		.')';
	
	$dataArray = array($cellFormula);

	$monthVar = 1;
	while ($monthVar <= ($nbOfMonths-1))
	{
		$cellFormula = '=SUM('
			.num2alpha(2+$xOffset+$monthVar).(string)(88+$yOffset)
			.'+'.num2alpha(2+$xOffset+$monthVar).(string)(51+$yOffset)
			.')';	
		array_push($dataArray, $cellFormula);
		$monthVar++;
	}

	$objPHPExcel->getActiveSheet()->getStyle((string)(88+$yOffset))->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD);
	$objPHPExcel->getActiveSheet()->getStyle((string)(88+$yOffset))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
	$objPHPExcel->getActiveSheet()->fromArray( $dataArray,  NULL, num2alpha(2+$xOffset) . (string)(88+$yOffset));




	//////////////////////////////////
	// Inventory
	//////////////////////////////////
	// Line : 89
	// Formula :

	//////////////////////////////////
	// Total current assets
	//////////////////////////////////
	// Line : 90 - Bold
	// Formula :



	//////////////////////////////////
	// Fixed assets
	//////////////////////////////////
	// Line : 92

	$objPHPExcel->setActiveSheetIndex(0)
		->setCellValue(num2alpha(0+$xOffset).(string)(92+$yOffset), 'Fixed assets');
	$objPHPExcel->getActiveSheet()->getStyle(num2alpha(0+$xOffset).(string)(92+$yOffset))->getFont()->setBold(true);
	

	
	
		setPercentage(91,$ReportInstanceID);
	$objPHPExcel->setActiveSheetIndex(0)
	->setCellValue(num2alpha(0+$xOffset).(string)(88+$yOffset), 'A/R');
	$objPHPExcel->getActiveSheet()->getColumnDimension(num2alpha(0+$xOffset))->setAutoSize(true);

	$cellFormula = '=SUM('
		.num2alpha(2+$xOffset).(string)(88+$yOffset)
		//.'-'.num2alpha(2+$xOffset).(string)(51+$yOffset)
		.')';
	
	$dataArray = array($cellFormula);

	$monthVar = 1;
	while ($monthVar <= ($nbOfMonths-1))
	{
		$cellFormula = '=SUM('
			.num2alpha(2+$xOffset+$monthVar).(string)(88+$yOffset)
			.')';	
		array_push($dataArray, $cellFormula);
		$monthVar++;
	}

	$objPHPExcel->getActiveSheet()->getStyle((string)(88+$yOffset))->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD);
	$objPHPExcel->getActiveSheet()->getStyle((string)(88+$yOffset))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
	$objPHPExcel->getActiveSheet()->fromArray( $dataArray,  NULL, num2alpha(2+$xOffset).(string)(88+$yOffset));

	
	$cellFormula = '=SUM('
		.num2alpha(2+$xOffset).(string)(75+$yOffset)
		.')';
	
	$dataArray = array($cellFormula);

	$monthVar = 1;
	while ($monthVar <= ($nbOfMonths-1))
	{
		$cellFormula = '=SUM('
			.num2alpha(2+$xOffset+$monthVar-1).(string)(76+$yOffset)
			.'+'.num2alpha(2+$xOffset+$monthVar).(string)(75+$yOffset)
			.')';	
		array_push($dataArray, $cellFormula);
		$monthVar++;
	}

	$objPHPExcel->getActiveSheet()->getStyle((string)(76+$yOffset))->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD);
	$objPHPExcel->getActiveSheet()->getStyle((string)(76+$yOffset))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
	$objPHPExcel->getActiveSheet()->fromArray( $dataArray,  NULL, num2alpha(2+$xOffset) . (string)(76+$yOffset));