include "../../include.php"; $return = '<table width="100%" border="1"> <tr bgcolor="#EEEEEE"> <td>Funder</td> <td>Award</td> <td>Status</td> <td>Amount</td> <td>Type</td> <td>Program</td> <td>Start</td> <td>End</td> <td>Contact</td> </tr>'; $result = db_query("select\n\t\t\t\t\t\t\ta.funderID,\n\t\t\t\t\t\t\tf.name,\n\t\t\t\t\t\t\ta.awardID,\n\t\t\t\t\t\t\ta.awardTitle,\n\t\t\t\t\t\t\ts.awardStatusDesc,\n\t\t\t\t\t\t\ta.awardAmount,\n\t\t\t\t\t\t\tat.awardTypeDesc,\n\t\t\t\t\t\t\tp.programDesc,\n\t\t\t\t\t\t\ta.awardStartDate,\n\t\t\t\t\t\t\ta.awardEndDate,\n\t\t\t\t\t\t\tISNULL(u.nickname, u.firstname) + ' ' + u.lastname contact\n\t\t\t\t\t\t\tFROM funders_awards a\n\t\t\t\t\t\t\tLEFT JOIN funders f on f.funderID = a.funderID\n\t\t\t\t\t\t\tLEFT JOIN funders_awards_types at on a.awardTypeID = at.awardTypeID\n\t\t\t\t\t\t\tLEFT JOIN funders_programs p on a.awardprogramID = p.programID\n\t\t\t\t\t\t\tLEFT JOIN funders_awards_statuses s on a.awardStatusID = s.awardStatusID\n\t\t\t\t\t\t\tLEFT JOIN users u ON u.id = a.staffID"); while ($r = db_fetch($result)) { $return .= ' <tr bgcolor="#FFFFFF" valign="top"> <td><a href="http://' . $_josh["request"]["host"] . '/funders/funder_view.php?id=' . $r["funderID"] . '">' . $r["name"] . '</a></td> <td><a href="http://' . $_josh["request"]["host"] . '/funders/award_view.php?id=' . $r["awardID"] . '">' . $r["awardTitle"] . '</a></td> <td>' . $r["awardStatusDesc"] . '</td> <td>' . number_format($r["awardAmount"]) . '</td> <td>' . $r["awardTypeDesc"] . '</td> <td>' . $r["programDesc"] . '</td> <td>' . format_date_excel($r["awardStartDate"]) . '</td> <td>' . format_date_excel($r["awardEndDate"]) . '</td> <td>' . $r["contact"] . '</td> </tr>'; } $return .= '</table>'; file_download($return, "All Awards - " . date("m/d/y"), "xls");
$name = db_fetch_field($result, $i); array_push($fields, $name->name . "|||" . db_field_type($result, $i)); } $return = ' <table border="1"> <tr bgcolor="#fffceo">'; foreach ($fields as $field) { list($name, $datatype) = explode("|||", $field); $return .= ' <td><b>' . trim(str_replace("_", " ", $name)) . '</b></td> '; } $return .= '</tr>'; while ($r = db_fetch($result)) { $return .= '<tr>'; reset($fields); foreach ($fields as $field) { list($name, $datatype) = explode("|||", $field); if ($datatype == "datetime") { $r[$name] = format_date_excel($r[$name]); } $return .= '<td>' . $r[$name] . '</td>'; } $return .= '</tr>'; $num_rows++; } $return .= '</table>'; //save exec info db_switch($_josh["db"]["database"]); db_query("INSERT INTO queries_executions ( \n\t\t\t\tqueryID, \n\t\t\t\tuserID, \n\t\t\t\texecutedOn, \n\t\t\t\tnum_rows, \n\t\t\t\tnum_columns\n\t\t\t) VALUES (\n\t\t\t\t{$_GET["id"]},\n\t\t\t\t{$_SESSION["user_id"]},\n\t\t\t\tGETDATE(),\n\t\t\t\t{$num_rows},\n\t\t\t\t{$num_columns}\n\t\t\t)"); file_download($return, $filename, "xls");