lakshmi lakshmi - 7 months ago 17
PHP Question

How to generate the CSV and PDF selecting two dates json value in Drupal7

drupal_add_http_header('Content-Type', 'text/csv');
drupal_add_http_header('Content-Disposition','attachment;filename=csvfile.csv');
// code indentation
$fp = fopen('php://transactions', 'w')
foreach ($result->response as $transaction) {
fputcsv($fp, $transaction);
}
fclose($fp);
drupal_exit();


The (result->response as transaction) contains all the data, with that only i arrange in table format to view for the customer. This same data i am selecting (from and to->date result) to be download in CSV.

Print of transaction:
In stdClassObject([card]=>1234,[fromdate]=>4/1/2016,[amount]=>5000)

Suggestion Needed.

Answer

Instead of

fputcsv($fp, $transaction);

Use

fputcsv($fp, array($transaction->card, $transaction->fromdate, $transaction->amount));

for formatting the numbers you can use as below:

$number = (float) str_replace( ',', '', '5,000.00');
echo number_format($number, '2','.', '');

Thanks