PHP format_date_excel примеры использования

Пример #1

Файл: excel_all_awards.php Проект: Rhenan/intranet-1

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");

Пример #2

Файл: download.php Проект: Rhenan/intranet-1

    $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");