Generating Future dates based on condition

<?php // RAY_temp_t3chguy.php 2013-10-16
error_reporting(E_ALL);
echo '<pre>';

// SCHEDULE BASED ON CONSECUTIVE TASKS
// http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_28268506.html#a39576941

// USE THIS TO SIMULATE A SET OF TASK DURATIONS
$tasks = array
( 'one' => 2
, 'two' => 3
, 'tre' => 4
, 'for' => 1
, 'fiv' => 2
)
;

// WE WILL CAPTURE THE TASK START AND END DAYS HERE
$out = array();

// OUR STARTING DAY WILL BE TOMORROW
$alpha = date('Y-m-d', strtotime('Tomorrow'));

// ADD IN THE TASKS
foreach ($tasks as $item => $num)
{
    // THE NUMBER OF WHOLE DAYS
    $omega = date('Y-m-d', strtotime($alpha . " + $num DAYS - 1 SECOND"));

    // SAVE THE RESULTS
    $ndx = $item . "($num days)";
    $out[$ndx] = array("Start" => $alpha, "Ended" => $omega);

    // START THE NEXT TASK ON THE DAY FOLLOWING THE PRIOR COMPLETION
    $alpha = date('Y-m-d', strtotime($omega . " + 1 DAY"));
}

print_r($out);

Select allOpen in new window

$nextStart = 'duh' . date("Y-m-d", strtotime($taskLength . ' weekdays', strtotime($lastActionDate)));

Select allOpen in new window

// MAKE ISO-8601 OF THE LAST DATE + 1 
$lastActionDate = date('Y-m-d', strtotime($lastActionDate));

// ADD WEEK DAYS
$nextStart      = date('Y-m-d', strtotime($lastActionDate . " + $taskLength WEEKDAYS"));

Select allOpen in new window

	$getProjects = mysql_query("SELECT helpDesk_projectList.id, createdFor, projectName, projectPriority, projectStatus, programmerAssigned
													FROM helpDesk_projectList
													LEFT JOIN helpDesk_projectAssignments ON helpDesk_projectList.id = helpDesk_projectAssignments.projectId
													WHERE (projectStatus = '1' OR projectStatus = '2' OR projectStatus = '3') and programmerAssigned = '".$programmer."'") or die("Cannot get current projects: " . mysql_error());
	
	if(mysql_num_rows($getProjects) > 0)
		{
		$i = 0;
		$prevRow = 0;
		
		while($pData = mysql_fetch_assoc($getProjects))
			{
			//Sum Days of Tasks for each project
			$getTasks = mysql_query("SELECT SUM(taskLength) as taskLength FROM helpDesk_projectTasks WHERE projectId = '".$pData['id']."'") or die("Cannot get Tasks: " . mysql_error());

			if(mysql_num_rows($getTasks) > 0)
				{
				while($taskData = mysql_fetch_assoc($getTasks))
					{
					$taskLength = $taskData['taskLength'];
					}
				}
						
			//Check for any other projects that may have dates associated with them.
			$checkProjects = mysql_query("SELECT actionDate, actionType FROM helpDesk_projectDates WHERE projectId = '".$pData['id']."' AND actionType <> '1'") or die("Cannot check projects: " . mysql_error());
			
			if(mysql_num_rows($checkProjects) > 0)
				{
				while($cpData = mysql_fetch_assoc($checkProjects))
					{
					//add dates to the last action date.
					$lastActionDate = $cpData['actionDate'];
					$nextStart = date("Y-m-d", strtotime($taskLength . ' weekdays', strtotime($lastActionDate)));
					}
				}
				
			else
				{
				//Last completed + 1
				$nextDay =  date("Y-m-d", strtotime('+1 weekday', strtotime($lastCompletedProject)));
				}
			
				//Add dates to last completed date.
				$endDate = date('Y-m-d', strtotime($alpha . " + $taskLength DAYS - 1 SECOND"));
				
					
				// MAKE ISO-8601 OF THE LAST DATE + 1 
				$lastActionDate = date('Y-m-d', strtotime($nextDay));

				// ADD WEEK DAYS
				$nextEnd      = date('Y-m-d', strtotime($lastActionDate . " + $taskLength WEEKDAYS"));

				//Add Task Length to prevoius project Completion Date
			
				echo '<tr>
							<td ' . $row_color . '>'.$pData['id'] . '</td>
							<td ' . $row_color . '>'.$pData['projectName'] . '</td>
							<td ' . $row_color . '>'.getCkname($pData['programmerAssigned']) . '</td>
							<td ' . $row_color . '>'.$lastActionDate . '</td>
							<td ' . $row_color . '>'.$nextEnd . '</td>
							<td ' . $row_color . '><span class="boldblacklinks"><a href="editProject.php?projectId='.$projectId.'" class="iframetall">Edit</a></span></td>
						</tr>';
			
			$prevRow = $currentRow;
			}
		}
	}

Select allOpen in new window

$nextStart = date("Y-m-d", strtotime($taskLength . ' weekdays', strtotime($lastActionDate)));

Select allOpen in new window

$nextStart returns

NULL

NULL

NULL 

Select allOpen in new window

$nextStart = date("Y-m-d", strtotime($lastActionDate . " + $taskLength weekdays"));

Select allOpen in new window

<?php // RAY_temp_t3chguy_1.php 2013-10-16
error_reporting(E_ALL);
echo '<pre>';

// SCHEDULE BASED ON CONSECUTIVE TASKS
// http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_28268506.html#a39576941

$taskLength = 4;
$lastActionDate = '2013-10-16';
$nextStart = date("Y-m-d", strtotime($taskLength . ' weekdays', strtotime($lastActionDate)));
var_dump($nextStart);

$nextStart = date("Y-m-d", strtotime($lastActionDate . " + $taskLength weekdays"));
var_dump($nextStart);

Select allOpen in new window

<?php // RAY_temp_t3chguy_3.php 2013-10-16
error_reporting(E_ALL);
echo '<pre>';

// SCHEDULE BASED ON CONSECUTIVE TASKS
// http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_28268506.html#a39576941


// WHAT WE HAVE
$getTasks = mysql_query("SELECT SUM(taskLength) as taskLength FROM helpDesk_projectTasks WHERE projectId = '".$pData['id']."'") or die("Cannot get Tasks: " . mysql_error());
if(mysql_num_rows($getTasks) > 0)


// THIS IS MORE LIKE WHAT WE NEED
$getTasksQry = "SELECT SUM(taskLength) as taskLength FROM helpDesk_projectTasks WHERE projectId = '{$pData["id"]}' ";
$getTasks    = mysql_query($getTasksQry);
if (!$getTasks)
{
    $err = "<br>FAIL: $getTasksQry";
    $err .= "<br>ERRNO: " . mysql_errno();
    $err .= "<br>ERROR: " . mysql_error();
    trigger_error($err, E_USER_ERROR);
}
$numTasks = mysql_num_rows($getTasks);
if ($numTasks)
{
    echo "<br>getTasksQry FOUND $numTasks ROWS";
}
else
{
    echo "<br>getTasksQry FOUND NO ROWS";
}

Select allOpen in new window

getTasksQry FOUND 1 ROWSArray
(
    [taskLength] => 2
)

getTasksQry FOUND 1 ROWSArray
(
    [taskLength] => 3
)



getTasksQry FOUND 1 ROWSArray
(
    [taskLength] => 63
)

Select allOpen in new window

getTasksQry FOUND 1 ROWS Last Completed Project: 2013-10-14
Project Id: 3 -  2 days - 2013-10-15 - 2013-10-17

getTasksQry FOUND 1 ROWS Last Completed Project: 2013-10-14
Project Id: 5 -  3 days - 2013-10-15 - 2013-10-18

Select allOpen in new window

foreach($programmers AS $programmer)
	{
	echo '<strong>' . getCkname($programmer) . ' Projects</strong><br /><br />';
	
	//Get Projects
	$getProjects = mysql_query("SELECT helpDesk_projectList.id, createdFor, projectName, projectPriority, projectStatus, programmerAssigned
													FROM helpDesk_projectList
													LEFT JOIN helpDesk_projectAssignments ON helpDesk_projectList.id = helpDesk_projectAssignments.projectId
													WHERE (projectStatus = '1' OR projectStatus = '2' OR projectStatus = '3') and programmerAssigned = '".$programmer."'") or die("Cannot get current projects: " . mysql_error());
	
	if(mysql_num_rows($getProjects) > 0)
		{
		$z = 1;
		
		while($pData = mysql_fetch_assoc($getProjects))
			{
			$getTasksQry = "SELECT SUM(taskLength) as taskLength FROM helpDesk_projectTasks WHERE projectId = '{$pData["id"]}' LIMIT 1";
			$getTasks    = mysql_query($getTasksQry);
			if (!$getTasks)
				{
				$err = "<br>FAIL: $getTasksQry";
				$err .= "<br>ERRNO: " . mysql_errno();
				$err .= "<br>ERROR: " . mysql_error();
				trigger_error($err, E_USER_ERROR);
				}

			$numTasks = mysql_num_rows($getTasks);

			while($tData = mysql_fetch_assoc($getTasks))
				{
				$taskLength = $tData['taskLength'];
				}
				
			$currentProject = $pData['id'];

			if($z == '1')
				{
				//Set End Date for last completed project!	
				$lastCompletedProject = lastCompletedProject($programmer);
				$nextStart = date("Y-m-d", strtotime($lastCompletedProject . " + 1 weekday"));
				$estimatedEnd = date("Y-m-d", strtotime($nextStart . " + $taskLength weekdays"));
				}
				
			if($z > '1')
				{
				$lastCompletedProject = $estimatedEnd;
				$nextStart = date("Y-m-d", strtotime($lastCompletedProject . " + 1 weekday"));
				$estimatedEnd = date("Y-m-d", strtotime($nextStart . " + $taskLength weekdays"));
				$estimatedEnd = date("Y-m-d", strtotime($estimatedEnd . " 1 weekday"));
				}
		
			echo 'Last Completed Project: ' . $lastCompletedProject . '<br /><br />';

			//Print Task Length and Start & End Dates.
			echo '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project Id: ' . $pData['id'] . ' - &nbsp;' . $taskLength . ' days - ' . $nextStart . ' - ' . $estimatedEnd . '<br />'; 
			
			$z++;
			
			echo '<br />';
			}
		}

Select allOpen in new window

... complicates this a lot.