echo "\t\t<div class=outerframe>\n"; // Inner table 1: User attributes echo "\t\t\t\t<table class=leftframe>\n"; echo "\t\t\t\t\t<thead>\n"; echo "\t\t\t\t\t\t<tr>\n"; echo "\t\t\t\t\t\t\t<th>User ID</th>\n"; echo "\t\t\t\t\t\t\t<th colspan=2>" . $myrow['userid'] . "</th>\n"; echo "\t\t\t\t\t\t</tr>\n"; echo "\t\t\t\t\t</thead>\n"; // This function allows for editable fields detail_row($current_tbl, $myrow['userid'], $myrow['firstname'], 'firstname', $edit_field); detail_row($current_tbl, $myrow['userid'], $myrow['lastname'], 'lastname', $edit_field); detail_row($current_tbl, $myrow['userid'], $myrow['department'], 'department', $edit_field); detail_row($current_tbl, $myrow['userid'], $myrow['extension'], 'extension', $edit_field); // detail_row($current_tbl, $myrow['userid'], $myrow[user_status], 'user_status', $edit_field); detail_row($current_tbl, $myrow['userid'], $myrow['active'], 'active', $edit_field); // Framing. Replace with div? echo "\t\t\t\t\t</table>\n"; // echo "\t\t\t\t</td>\n"; // echo "\t\t\t\t<td class=outerframe>\n"; // Inner table 2: User Assignments echo "\t\t\t\t\t<table class=rightframe>\n"; $user_query = "SELECT * FROM asset_tbl a\n\t\t\tLEFT OUTER JOIN pc_detail_tbl ON (pc_assetid=assetid)\n\t\t\tLEFT JOIN (\n\t\t\t\tSELECT DISTINCT ON (assetid_fkey) * FROM assignment_tbl \n\t\t\t\tLEFT JOIN user_tbl ON (userid_fkey=userid)\n\t\t\t\tORDER BY assetid_fkey, datetime desc\n\t\t\t) AS usernames\n\t\t\tON assetid=assetid_fkey\n\t\t\tWHERE userid = '{$userid}'\n\t\t\tORDER BY type ASC, description ASC"; $result = pg_query($user_query); if (!$result) { echo "<pre>Problem with query: " . $user_query . "\n\n"; echo pg_last_error(); echo "</pre>"; exit; } echo "\t\t\t\t<thead>\n";
exit; } $pc_row = pg_fetch_assoc($pc_result); // Build PC Data list detail_row($sub_tbl, $asset_row['assetid'], $pc_row['computernumber'], 'computernumber', $edit_field); detail_row($sub_tbl, $asset_row['assetid'], $pc_row['videocard'], 'videocard', $edit_field); detail_row($sub_tbl, $asset_row['assetid'], $pc_row['videobus'], 'videobus', $edit_field); detail_row($sub_tbl, $asset_row['assetid'], $pc_row['cpu'], 'cpu', $edit_field); detail_row($sub_tbl, $asset_row['assetid'], $pc_row['harddrive'], 'harddrive', $edit_field); detail_row($sub_tbl, $asset_row['assetid'], $pc_row['memory'], 'memory', $edit_field); detail_row($sub_tbl, $asset_row['assetid'], $pc_row['batch'], 'batch', $edit_field); detail_row($sub_tbl, $asset_row['assetid'], $pc_row['expresscode'], 'expresscode', $edit_field); detail_row($sub_tbl, $asset_row['assetid'], $pc_row['warranty'], 'warranty', $edit_field); detail_row($sub_tbl, $asset_row['assetid'], $pc_row['mayadongle'], 'mayadongle', $edit_field); } detail_row($current_tbl, $asset_row['assetid'], $asset_row['active'], 'active', $edit_field); echo "\t\t\t</table>\n"; // Framing. Replace with div? /* echo "\t\t\t\t</td>\n"; echo "\t\t\t\t<td class=outerframe>\n"; */ // Inner table 2: User Assignments echo "\t\t\t<table class=rightframe>\n"; $assignment_query = "SELECT * FROM asset_tbl \n\t\t\t\tLEFT JOIN assignment_tbl ON (asset_tbl.assetid=assignment_tbl.assetid_fkey)\n\t\t\t\tLEFT JOIN user_tbl ON (assignment_tbl.userid_fkey=user_tbl.userid)\n\t\t\t\t\tWHERE (asset_tbl.assetid='" . $asset_row['assetid'] . "')\n\t\t\t\t\tORDER BY assignment_tbl.datetime DESC"; $assignment_result = pg_query($assignment_query); if (!$assignment_result) { echo "<pre>Problem with query: " . $assignment_query . "\n\n"; echo pg_last_error(); echo "</pre>"; exit; } // Get the first row for use with the New User Assignment form