AppGini Community Forums

Code: Select all

function tbltimesheets_dv($selectedID, $memberInfo, &$html, &$args)
	{
		if ($selectedID)					// if viewing an existing record then do this lot
		{
			$id=makeSafe($selectedID);
			
			// get the sum of all the hours for this timesheet - will only return 1 row of 1 column
			$res = sql(
				"SELECT (tbltimesheets.MondayHours + tbltimesheets.TuesdayHours + ".
					"tbltimesheets.WednesdayHours + tbltimesheets.ThursdayHours + ".
					"tbltimesheets.FridayHours + tbltimesheets.SaturdayHours + ".
					"tbltimesheets.SundayHours) AS ToThours ".
				"FROM tbltimesheets ".
				"WHERE tbltimesheets.TimesheetID = '$id'"	
				, $eo);
			
			if (mysql_num_rows($res))					// SQL returned one or more rows?
			{
				$row = mysql_fetch_row($res);

				$th = sprintf("%.2f", $row[0]);			// Get total hours 
				$td = sprintf("%.2f", ($th / 8));		// Get total days 
				
				$frh = 'id="TotHours"></p>';			// Set up target "hours" HTML to change
				$toh = 'id="TotHours">'.$th.'</p>';		// Set up the "hours" HTML the target will be changed too
				
				$frd = 'id="TotDays"></p>';				// Set up target "days" HTML to change
				$tod = 'id="TotDays">'.$td.'</p>';		// Set up the "days" HTML the target will be changed too
				
				$html = str_replace($frh, $toh, $html);
				$html = str_replace($frd, $tod, $html);
			}
		}
		else									// otherwise, if viewing a "new" empty record do this
		{
			$frh = 'id="TotHours"></p>';
			$toh = 'id="TotHours">Automatically calculated after a timesheet is submitted or updated</p>';
			
			$frd = 'id="TotDays"></p>';
			$tod = 'id="TotDays">Automatically calculated after a timesheet is submitted or updated</p>';
			
			$html = str_replace($frh, $toh, $html);
			$html = str_replace($frd, $tod, $html);
		}

	}