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;
}
}
