add_styles_page(); $db = new db_safeguard(); $assets_res = $db->select_query('assets', '*', "client_id = '{$_GET['client_id']}' ORDER BY asset_type_id ASC"); function get_status($id) { $db = new db_safeguard(); $status = $db->select_query("asset_status", "*", "record_id = '{$id}'"); return $status->fetch_assoc()["name"]; } function get_asset_type_id($id) { $db = new db_safeguard(); $asset_type_id = $db->select_query("asset_types", "*", "record_id = '{$id}'"); return $asset_type_id->fetch_assoc()["name"]; } function get_user($id) { $db = new db_safeguard(); $user = $db->select_query("users", "*", "record_id = '{$id}'"); return $user->fetch_assoc()["username"]; } function warrent($id) { if ($id == 1) { return "ACTIVE"; } else { return "INACTIVE"; } } echo ''; while ($asset = $assets_res->fetch_assoc()) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; if (strlen($asset['description']) > 5 && strlen($asset['images']) > 5) { echo ''; echo ''; echo ''; } echo ''; echo ''; echo ''; } echo ''; echo '

Asset Type	Name	Serial Number	Product Number	Model Number	Status	Date Purchased	Date Updated	Assigned Person	Warranty Active	Warranty Holder	Warranty Expiration Date	User Changed	QR Code
' . htmlspecialchars(get_asset_type_id($asset['asset_type_id'])) . '	' . htmlspecialchars($asset['name']) . '	' . htmlspecialchars($asset['s_n']) . '	' . htmlspecialchars($asset['product_number']) . '	' . htmlspecialchars($asset['model_number']) . '	' . htmlspecialchars(get_status($asset['status_id'])) . '	' . htmlspecialchars($asset['date_time_purchased']) . '	' . htmlspecialchars($asset['date_time_updated']) . '	' . htmlspecialchars($asset['assinged_person']) . '	' . htmlspecialchars(warrent($asset['warrenty_active'])) . '	' . htmlspecialchars($asset['warrenty_holder']) . '	' . htmlspecialchars($asset['warrenty_exp_date']) . '	' . htmlspecialchars(get_user($asset['user_id_changed'])) . '	' . htmlspecialchars($asset['qr_code']) . '
' . $asset['description'] . '							'; echo str_replace("'; echo '

';