public function exportcsvAction() { $this->_helper->viewRenderer->setNoRender(true); $this->_helper->layout->disableLayout(); $recordsModel = new Records(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $records = $recordsModel->searchByArray($data); $csv = "RecordID, Date, EmployeeFirst,EmployeeLast,EmpID,TitlePaid,EmpAcct#1,Percent#1,Percent#2,Location,SubFirst,SubLast,SubCert,Payrate,SubSS,Reason,Note,LeaveForm,SubID"; $csv .= "\n"; foreach ($records as $record) { if (trim($record->acct) != '') { $acctNumber = $this->formatMumberAccount($record->acct); } else { $acctNumber = $this->formatMumberAccount($record->account_number); } if (trim($record->acct_two) != '') { $acctNumberTwo = $this->formatMumberAccount($record->acct_two); } else { $acctNumberTwo = $this->formatMumberAccount($record->account_number_two); } if (trim($record->payrate) != '' && $record->payrate != NULL) { $payrateNumber = $record->payrate; } else { $payrateNumber = $record->spayrate; } $l_form = 'No'; if ($record->leave_form == '1') { $l_form = 'Yes'; } if ($record->leave_form == '0') { $l_form = 'No'; } $csv .= $record->id . ","; $csv .= $record->date . ","; $csv .= $record->efirstname . ","; $csv .= $record->elastname . ","; $csv .= $record->ecp_id . ","; $csv .= $record->epaid . ","; if ($record->substitute == 129 || !$record->substitute) { $acctNumber = '5-000-0-0000-0000-00000-0000-0'; } $csv .= '="' . $acctNumber . '",'; $csv .= $record->percent . ","; $csv .= $record->percent_two . ","; $csv .= $record->lname . ","; $csv .= $record->sfirstname . ","; $csv .= $record->slastname . ","; $csv .= $record->scertified . ","; $csv .= $payrateNumber . ","; $csv .= $record->ssn . ","; $csv .= $record->reason . ","; $csv .= str_replace(",", "", $record->notes) . ","; $csv .= $l_form . ","; $csv .= $record->ssecondary_id . ","; $csv .= "\n"; } header('Content-Type: application/csv'); header('Content-Disposition: attachment; filename=CSV_Export-' . date('Y-m-d') . ".csv"); header('Pragma: no-cache'); echo $csv; } }