<?php
	session_start();
	
	if(isset($_POST['edit_row']))
	{
		$list = $_POST['list'];
		$d = date("Y-m-01"); 
		$dyr = date("Y");
		$mysqli = new mysqli('localhost:8889','root','root','Ginkgo');
		if($mysqli->connect_errno){
			echo ('Error connecting to MySQL server. '.$mysqli->connect_errno .' '.$mysqli->connect_error);
		}
	
		//get calendar list
		$sql = "SELECT `".$d."` FROM 514Creek WHERE id=25;";
		$result = mysqli_query($mysqli,$sql) or die('Error querying cal database.');
		$i=1;
		while ($row = mysqli_fetch_assoc($result)) {
			$list[8]=$row["'".$d."'"];
			$i=$i+1;
		}
		
		$k=1;
		$l=1;
		$lastyr = $_SESSION['fullarray'][0][0]-12*($dyr-2015);
		if ($_SESSION['fullarray'][0][0]%3==0)
			$lastqtr = 3;
		else
			$lastqtr = $_SESSION['fullarray'][0][0]%3;

		if($lastyr>=1 && $lastyr<=3)
			$m=1;
		elseif ($lastyr>=4 && $lastyr<=6)
			$m=2;
		elseif ($lastyr>=7 && $lastyr<=9)
			$m=3;
		elseif ($lastyr>=10 && $lastyr<=12)
			$m=4;
	
		$qtr = array();
		$yr = array();
		
		for($i=1;$i<=25;$i++){
			$qtr[$i] = $_SESSION['fullarray'][0][38][$i];
			$yr[$i] = $_SESSION['fullarray'][0][39][$i];
		}
		
	/*	$i = 36
		$m = 4
		$lastqtr = 3
	*/
		for($i=$_SESSION['fullarray'][0][0];$i<86;$i++){
			$newdate = date('Y-m-d',strtotime($d.' + '.($l-1).' month'));
			$newyr = date('Y',strtotime($d.' + '.($l-1).' month'));
			
			//rent
			$rent = $_SESSION['fullarray'][0][40]*pow((1+$list[3]/100),$k);
			$sql = "UPDATE 514Creek SET `".$newdate."`=".$rent." where id=2;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying mkt rent database.');
			
			//vac
			$vac = -$rent*($list[2]/100);
			$sql = "UPDATE 514Creek SET `".$newdate."`=".$vac." where id=3;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying vac database.');
			//eff rent
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($rent+$vac)." where id=4;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying eff rent database.');
			//tax
			if($newyr>$dyr)
				$tax = $_SESSION['fullarray'][0][41]*pow((1+$list[4]/100),$k)/12;
			else
				$tax = 0;
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($tax)." where id=7;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying tax database.');
			//ins
			$ins = $_SESSION['fullarray'][0][42]*pow((1+$list[1]/100),$k)/12;
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($ins)." where id=8;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying ins database.');
			//hoa
			if($newyr>$dyr)
				$hoa = $_SESSION['fullarray'][0][43]*pow((1+$list[1]/100),$k)/12;
			else
				$hoa = 0;
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($hoa)." where id=9;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying hoa database.');
			//mgmt
			$mgmt = -$rent*$list[7]/100;
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($mgmt)." where id=10;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying mgmt database.');
			//util
			$util = $_SESSION['fullarray'][0][44]*pow((1+$list[1]/100),$k);
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($util)." where id=11;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying util database.');
			//value
			$value = $_SESSION['fullarray'][0][45]*pow((1+($list[0]/100)/12),$k);
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($value)." where id=25;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying value database.');
			//maint
			$maint = -$value*0.01/12;
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($maint)." where id=12;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying maint database.');
			//opex
			$opex = $tax+$ins+$hoa+$mgmt+$util+$maint;
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($opex)." where id=6;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying opex database.');
			//noi
			$noi = $rent+$vac+$opex;
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($noi)." where id=13;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying noi database.');
			
			if($l%12==0){
				//lc
				$lc = -$rent*$list[6];
				$sql = "UPDATE 514Creek SET `".$newdate."`=".($lc)." where id=15;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying lc database.');
				$k = $k+1;
			}
			else
				$lc = 0;
			
			//unlev
			$unlev = $noi + $lc;
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($unlev)." where id=18;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying unlev database.');
			//lev
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($unlev)." where id=22;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying lev database.');
			//btcf
			$sql = "UPDATE 514Creek SET `".$newdate."`=".($unlev)." where id=24;";
			$result = mysqli_query($mysqli, $sql) or die('Error querying btcf database.');
			
			if($lastqtr <> 0){
				$qtr[2] = $qtr[2]+$rent;
				$qtr[3] = $qtr[3]+$vac;
				$qtr[4] = $qtr[4]+$rent+$vac;
				$qtr[6] = $qtr[6]+$opex;
				$qtr[7] = $qtr[7]+$tax;
				$qtr[8] = $qtr[8]+$ins;
				$qtr[9] = $qtr[9]+$hoa;
				$qtr[10] = $qtr[10]+$mgmt;
				$qtr[11] = $qtr[11]+$util;
				$qtr[12] = $qtr[12]+$maint;
				$qtr[13] = $qtr[13]+$noi;
				$qtr[15] = $qtr[15]+$lc;
				$qtr[18] = $qtr[18]+$unlev;
				$qtr[22] = $qtr[22]+$lev;
				$qtr[24] = $qtr[24]+$btcf;
				$qtr[25] = $value;
			}
			else{
				$qtr[2] = 0;
				$qtr[3] = 0;
				$qtr[4] = 0;
				$qtr[6] = 0;
				$qtr[7] = 0;
				$qtr[8] = 0;
				$qtr[9] = 0;
				$qtr[10] = 0;
				$qtr[11] = 0;
				$qtr[12] = 0;
				$qtr[13] = 0;
				$qtr[15] = 0;
				$qtr[18] = 0;
				$qtr[22] = 0;
				$qtr[24] = 0;
			}
			
			if($lastyr <> 0){
				$yr[1] = $rent;
				$yr[2] = $yr[2]+$rent;
				$yr[3] = $yr[3]+$vac;
				$yr[4] = $yr[4]+$rent+$vac;
				$yr[6] = $yr[6]+$opex;
				$yr[7] = $yr[7]+$tax;
				$yr[8] = $yr[8]+$ins;
				$yr[9] = $yr[9]+$hoa;
				$yr[10] = $yr[10]+$mgmt;
				$yr[11] = $yr[11]+$util;
				$ry[12] = $yr[12]+$maint;
				$yr[13] = $yr[13]+$noi;
				$yr[15] = $yr[15]+$lc;
				$yr[18] = $yr[18]+$unlev;
				$yr[22] = $yr[22]+$lev;
				$yr[24] = $yr[24]+$btcf;
				$yr[25] = $value;
			}
			else{
				$yr[2] = 0;
				$yr[3] = 0;
				$yr[4] = 0;
				$yr[6] = 0;
				$yr[7] = 0;
				$yr[8] = 0;
				$yr[9] = 0;
				$yr[10] = 0;
				$yr[11] = 0;
				$yr[12] = 0;
				$yr[13] = 0;
				$yr[15] = 0;
				$yr[18] = 0;
				$yr[22] = 0;
				$yr[24] = 0;
			}
			
			if($newyr<2021 && $lastqtr%3==0){
				//rent
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[2]." where id=2;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying mkt rent database.');
				//vac
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[3]." where id=3;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying vac database.');
				//eff rent
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[4]." where id=4;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying eff rent database.');
				//tax
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[7]." where id=7;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying tax database.');
				//ins
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[8]." where id=8;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying ins database.');
				//hoa
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[9]." where id=9;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying hoa database.');
				//mgmt
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[10]." where id=10;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying mgmt database.');
				//util
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[11]." where id=11;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying util database.');
				//value
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[25]." where id=25;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying value database.');
				//maint
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[12]." where id=12;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying maint database.');
				//opex
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[6]." where id=6;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying opex database.');
				//noi
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[13]." where id=13;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying noi database.');
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[15]." where id=15;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying lc database.');
				//unlev
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[18]." where id=18;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying unlev database.');
				//lev
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[22]." where id=22;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying lev database.');
				//btcf
				$sql = "UPDATE 514Creek SET `".$newyr." Q".$m."`=".$qtr[24]." where id=24;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying btcf database.');
			}
			
			if($newyr<2021 && $lastyr%12==0){
				//rent
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[2]." where id=2;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying mkt rent database.');
				//vac
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[3]." where id=3;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying vac database.');
				//eff rent
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[4]." where id=4;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying eff rent database.');
				//tax
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[7]." where id=7;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying tax database.');
				//ins
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[8]." where id=8;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying ins database.');
				//hoa
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[9]." where id=9;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying hoa database.');
				//mgmt
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[10]." where id=10;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying mgmt database.');
				//util
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[11]." where id=11;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying util database.');
				//value
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[25]." where id=25;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying value database.');
				//maint
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[12]." where id=12;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying maint database.');
				//opex
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[6]." where id=6;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying opex database.');
				//noi
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[13]." where id=13;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying noi database.');
				//lc
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[15]." where id=15;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying lc database.');
				//unlev
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[18]." where id=18;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying unlev database.');
				//lev
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[22]." where id=22;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying lev database.');
				//btcf
				$sql = "UPDATE 514Creek SET `".$newyr."`=".$yr[24]." where id=24;";
				$result = mysqli_query($mysqli, $sql) or die('Error querying btcf database.');
			}
			$l = $l+1;
			if($lastqtr ==3)
				$lastqtr = 1;
			else
				$lastqtr = $lastqtr + 1;
				
			if($m==4)
				$m=1;
			else
				$m = $m +1;
			
			if($lastyr ==12)
				$lastyr = 1;
			else
				$lastyr = $lastyr + 1;
		}
		$mysqli->close();
	}
?>