assign-proj-mbrs-to-all-tasks.php at Timesheet Next Gen

<?php
// $Header: /cvsroot/tsheet/timesheet.php/task_maint.php,v 1.11 2005/05/17 03:38:37 vexil Exp $
// Authenticate
require("class.AuthenticationManager.php");
require("class.CommandMenu.php");
if (!$authenticationManager->isLoggedIn() || !$authenticationManager->hasAccess('aclTasks')) {
        Header("Location: login.php?redirect=$_SERVER[PHP_SELF]&clearanceRequired=" . get_acl_level('aclTasks'));
        exit;
}

// Connect to database.
$dbh = dbConnect();

//define the command menu & we get these variables from $_REQUEST:
//  $month $day $year $client_id $proj_id $task_id
include("timesheet_menu.inc");

$contextUser = strtolower($_SESSION['contextUser']);
$assignTasks = isset($_REQUEST["assignTasks"]) ? $_REQUEST["assignTasks"]: false;

function do_query($sql) {
	$result = mysql_query($sql);
	if(!$result) {
		print "Query failed: \"$sql\"\n";
		print get_db_error(mysql_error())."\n";
		return false;
	}
	return $result;
}

?>

<html>
<head>
	<title>Assign all Tasks</title>
<?php
include ("header.inc");
?>
<script language="Javascript">

	function delete_task(projectId, taskId) {
		if (confirm('Deleting a task which has been used in the past will make those timesheet ' +
				'entries invalid, and may cause errors. This action is not recommended. ' +
				'Are you sure you want to delete this task?'))
			location.href = 'task_action.php?proj_id=' + projectId + '&task_id=' + taskId + '&action=delete';
	}

</script>
</head>
<body <?php include ("body.inc"); ?> >
<?php
include ("banner.inc");
?>

<form name="changeForm" action="<?php echo $_SERVER["PHP_SELF"]; ?>" style="margin-bottom: 0px;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td width="100%" class="face_padding_cell">

<!-- include the timesheet face up until the heading start section -->
<?php include("timesheet_face_part_1.inc"); ?>

			<table width="100%" border="0">
				<tr>
					<td align="center" nowrap>
						<h2>Assign all Tasks to all Project Members</h2>
					</td>
				</tr>
			</table>

<!-- include the timesheet face up until the heading start section -->
<?php include("timesheet_face_part_2.inc"); ?>


			<table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" class="outer_table">
				<tr>
					<td width="40">&nbsp;</td>
					<td>
<?php if($assignTasks!='checked') { ?>
<h2><font color="red"><b>Attention!</b></font> &nbsp;<font color="red">Read this carefully</font><br></h2>
<h3>Clicking on the checkbox below and submitting this form will:
<ol><li> clear the entire task assignment database table</li>
<li> iterate through the users and project tables</li>
<li> and assign each user to all the tasks for every project of which they are a member &nbsp;&nbsp;&nbsp; <a href="explain-assign-all-tasks.php">Click here</a> if you don't understand</li>
</ol>
If this is what you want to do, check this box <input type="checkbox" name="assignTasks" value="checked" <?php if($assignTasks) echo " checked" ?>>  and hit submit, or return. <br>
<img src="images/spacer.gif" width="50" height="1" /><INPUT type="submit" value="Submit"></h3>
<?php } else { 
	$task_array=array();

	$sql = "SELECT task_id, proj_id FROM $TASK_TABLE order by task_id";
	$result = do_query($sql);
	if($result) {
		while($data = mysql_fetch_array($result)) {
			$task_id=$data["task_id"];
			$proj_id=$data["proj_id"];

			$task_array[$proj_id][$task_id]=1;
		}
	}

	$sql = "DELETE from $TASK_ASSIGNMENTS_TABLE";
	$rslt = do_query($sql);
	print "All task assignments removed<br>\n";

	$lastuser="";
	$userprojcnt=0;
	$usertaskcnt=0;

	$sql = "SELECT username, proj_id FROM $ASSIGNMENTS_TABLE order by username";
	$result = do_query($sql);
	if($result) {
		while($data = mysql_fetch_array($result)) {
			$proj_id=$data["proj_id"];
			$username=$data["username"];

			if($lastuser=='') $lastuser=$username;
			if($lastuser != $username) {
				print "$lastuser assigned to $usertaskcnt tasks in $userprojcnt projects<br>\n";
				$lastuser=$username;
				$userprojcnt=0;
				$usertaskcnt=0;
			}
			$userprojcnt++;

			foreach($task_array[$proj_id] as $task_id => $value) {	
				$sql = "INSERT into $TASK_ASSIGNMENTS_TABLE VALUES ($task_id,'$username',$proj_id)";
				$rslt = do_query($sql);
				$usertaskcnt++;
			}
		}
		print "$lastuser assigned to $usertaskcnt tasks in $userprojcnt projects<br>\n";
	}
}

?>
					</td>
				</tr>
			</table>

<!-- include the timesheet face up until the end -->
<?php include("timesheet_face_part_3.inc"); ?>

		</td>
	</tr>
</table>

</form>
<?php
include ("footer.inc");
?>
</BODY>
</HTML>