<?php
namespace common\models;

use Yii;
use common\controllers\CommonCartController;

class DownloadCsv {

 
 public function generateDownloadCSV($documents, $filename, $forInst) {
	try {
	//var_dump($documents);
		header('Content-Encoding: UTF-8');
		header('Content-Disposition: attachment; filename="'.$filename.'";');
		header('Content-Type: application/csv; charset=UTF-8');
		
		// open the "output" stream
		// see http://www.php.net/manual/en/wrappers.php.php#refsect2-wrappers.php-unknown-unknown-unknown-descriptioq
		$handle = fopen('php://output', 'w');
		
		
		
	//	$handle = fopen ( $filename, 'w' );
		
		$firstLine = array (
				'accessionnumber',
				'ipen',
				'institution',
				'accessionStatus',
				'fullScientificName',
				'family',
				'country',
				'sea',
				'locality',
				'latitude',
				'longitude',
				'collectors',
				'collectiondate',
				'collectornumber',
				'material'
		);
	
		fwrite ( $handle, implode ( ',', $firstLine ) . "\r\n" );
		
		if(isset($documents['response'])) {
			$helperAr = [];
		foreach ( $documents['response'] as $doc ) { 
				
			$helperAr ['accessionnumber'] = $doc->unitaccessionnumber;
			$helperAr ['ipen'] = $doc->ipen;
			$helperAr ['institution'] = $doc->institution;
			$helperAr ['accessionStatus'] = $doc->disposition;
			$helperAr ['fullScientificName'] = $doc->fullScientificName;
			$helperAr ['family'] = $doc->familyName;
			$helperAr ['country'] = $doc->country;
			$helperAr ['sea'] = $doc->sea;
			$helperAr ['locality'] = $doc->locality;
			$helperAr ['latitude'] = $doc->latitude;
			$helperAr ['longitude'] = $doc->longitude;
			$helperAr ['collectors'] = $doc->collectors;
			$helperAr ['collectiondate'] = $doc->gatheringdate;
			$helperAr ['collectornumber'] = $doc->collectornumber;
			$helperAr ['material'] = $doc->sampletype;
			
		
			// write the line to the file. Replace all existing commas by semicolons
			$line = '';
			foreach ( $firstLine as $value ) {
					$rep = str_replace ( ",", ";", $helperAr [$value] );
					$line .= mb_convert_encoding($rep, 'UTF-16LE', 'UTF-8') . ',';
				}
			//echo $line;
			fwrite ( $handle, $line . "\r\n" );
			}

		}
		
	} catch ( Exception $e ) {
		// TODO
	}
	return [$filename];
	}

}