public function sendweeklyAction1()
{
$weeklyreport = new Application_Model_Report();
$sendReportsTo = $weeklyreport->sendRportTo();
$queueCount = count($sendReportsTo);
$sendCount = 0;
if (is_array($sendReportsTo)) {
if (!empty($sendReportsTo)) {
foreach ($sendReportsTo as $user) {
$mail = new Zend_Mail();
$mail->setBodyText('Please see the weekly report:');
$mail->setFrom('*****@*****.**', 'Textmunication.com');
$mail->addTo($user['email'], 'Joseph Saunders');
$mail->addCc('*****@*****.**', 'Wais Asefi');
//$mail->addCc('*****@*****.**', 'Robert Gonzalez');
$mail->setSubject('Weekly Reports');
// Get the Excel model
$excel = new Application_Model_Excel();
if ($weeklyreport->checkAdminUser($user['id']) and $user['id'] != 187) {
if (isset($user['edituser'])) {
$excelDataArray = $weeklyreport->getWeeklyReportByEditUser($user['edituser']);
//echo "single"; print_r($excelDataArray); exit;
$date = date('Ymd');
$excelFileName = "weeklyreport_pollo" . $user['edituser'] . '_' . $date;
logWrite("Creating the Excel spreadsheets");
$excel = new Application_Model_Excel();
$excelFile = $excel->create($excelDataArray, $excelFileName);
logWrite("Attaching the spreadsheets");
$at = $mail->createAttachment(file_get_contents($excelFile['path']));
$at->filename = $excelFile['name'];
} else {
$excelDataArray = $weeklyreport->getWeeklyReport($user['id']);
$date = date('Ymd');
$excelFileName = "weeklyreport_clientid" . $user['id'] . '_' . $date;
$excel = new Application_Model_Excel();
$excelFile = $excel->create($excelDataArray, $excelFileName);
$at = $mail->createAttachment(file_get_contents($excelFile['path']));
$at->filename = $excelFile['name'];
}
} else {
// Get the subscriber datasets
$excelDataArray = $weeklyreport->getWeeklyReport();
//echo "<pre>"; print_r($excelDataArray); exit;
// Get a date stamp for the file
$date = date('Ymd');
// Create our file names
$excelFileName = "weeklyreport_clientid" . $user['id'] . '_' . $date;
// Log the steps
//logWrite("Creating the Excel spreadsheets");
// Make the Excel files for each day
$excelFile = $excel->create($excelDataArray, $excelFileName);
$at = $mail->createAttachment(file_get_contents($excelFile['path']));
$at->filename = $excelFile['name'];
}
// Log the steps
//logWrite("Preparing to send...");
// Send it off
if (!$mail->send()) {
echo "MESSAGE NOT SENT";
} else {
echo "Message sent";
}
}
} else {
$this->error = "No reports to send";
}
} else {
$this->error = "Send to report was not properly fetched";
}
}
