Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function downloadJournalRecordAction()
- {
- $journalRecordId = $this->params()->fromRoute()['house'];
- //$dbConn = pg_connect ("host=monitor.reformagkh.ru port=54325 dbname=rgkh_migration_1206_logs user=readonlyuser password=tralivali");
- $myDbConn = pg_connect ("host=rgkh-dev-postgres port=5432 dbname=mylogs user=postgreadmin password=1");
- $sql = <<<SQL
- SELECT
- jr.object_type_id AS object_type_id,
- ot.table_name AS object_type_name,
- jr.action AS action,
- jr.user_id AS user_id,
- jr.created_at AS created_at,
- jr.changes AS changes,
- jr.context AS context,
- jr.object_pk AS object_pk,
- jr.id AS id
- FROM journal.journal_record jr
- JOIN journal.journal_object_type ot ON ot.id = jr.object_type_id
- WHERE jr.id = $journalRecordId
- SQL;
- $query = pg_query($myDbConn, $sql);
- $result = pg_fetch_all($query);
- $csvFile = fopen('php://temp', 'r+');
- fputcsv($csvFile, ['object_type_id','object_type_name','action','user_id','created_at','changes','context','object_pk','id']);
- foreach($result as $row) {
- fputcsv($csvFile, $row);
- }
- $response = new Stream();
- $response->setStream($csvFile);
- $response->setStatusCode(200);
- $response->setStreamName('journalRecord.csv');
- $headers = new Headers();
- $headers->addHeaders([
- // 'Content-Disposition' => 'attachment; filename=journalRecord.csv',
- // 'Content-Type' => 'application/octet-stream',
- // 'Expires' => '@0', // @0, because zf2 parses date as string to \DateTime() object
- // 'Cache-Control' => 'must-revalidate',
- // 'Pragma' => 'public',
- ]);
- $response->setHeaders($headers);
- fclose($csvFile);
- pg_close($myDbConn);
- //return $response;
- return $this->jsonSuccess();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement