fannie/cron/tasks/PriceBatchAlertTask.php
<?php
/*******************************************************************************
Copyright 2015 Whole Foods Co-op
This file is part of CORE-POS.
CORE-POS is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
CORE-POS is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
in the file license.txt along with IT CORE; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*********************************************************************************/
use COREPOS\Fannie\API\data\pipes\OutgoingEmail;
if (!class_exists('BasicModel')) {
include(dirname(__FILE__).'/../../classlib2.0/data/models/BasicModel.php');
}
if (!class_exists('ProdUpdateModel')) {
include(dirname(__FILE__).'/../../classlib2.0/data/models/op/ProdUpdateModel.php');
}
class PriceBatchAlertTask extends FannieTask
{
public $name = 'Price Change Batch Alert';
public $description = 'Sends an email to report whenever a non-produce,
non-deli price change batch has started.';
public $default_schedule = array(
'min' => 50,
'hour' => 3,
'day' => '*',
'month' => '*',
'weekday' => '*',
);
public function run()
{
$superDepts = array('GROCERY','REFRIGERATED','FROZEN','GEN MERCH','BULK','WELLNESS',
'MEAT','MULTIPLE DEPTS.');
$scanEmail = $this->config->get('SCANCOORD_EMAIL');
$contacts = array($scanEmail);
$this->getBathchesBySuperDept($superDepts,$contacts);
return false;
}
private function getBathchesBySuperDept($superDepts,$contacts)
{
$dbc = FannieDB::get($this->config->get('OP_DB'));
$date = date('Y-m-d').' 00:00:00';
$d = date('d');
$m = date('m');
$y = date('Y');
$model = new BatchesModel($dbc);
$model->endDate($date);
list($inClause,$args) = $dbc->safeInClause($superDepts);
$query = "SELECT batchName, batchID, startDate, endDate, owner
FROM batches
WHERE startDate = CURDATE()
AND owner IN (".$inClause.")
and batchType = 4;
";
$prep = $dbc->prepare($query);
$result = $dbc->execute($prep,$args);
$ret = '';
$style = '
<style>
table {
border-radius: 3px;
}
table, th, td {
border: 1px solid black;
border-collapse: collapse;
}
th {
width: 210px;
background-color: lightblue;
}
tr.danger {
background-color: tomato;
}
td.produce {
background-color: #71c98a;
}
td.grocery, td.refrigerated, td.frozen,
td.bulk, td.gen_merch, td.meat {
background-color: #ffa72b;
}
td.wellness {
background-color: cyan;
}
td.deli {
background-color: #c674cc;
}
td.it {
background-color: lightgrey;
}
span.danger {
background-color: tomato;
background-radius: 2px;
padding: 2px;
}
</style>
';
if ($dbc->numRows($result) > 0) {
$ret .= '<table><thead><th>Batch Name</th><th>Batch ID</th><th>Start Date</th><th>End Date</th><th>Owner</th></thead><tbody>';
while ($row = $dbc->fetch_row($result)) {
$ret .= '<tr>';
$ret .= '<td>' . $row['batchName'] . '</td>';
$ret .= '<td>' . $row['batchID'] . '</td>';
$ret .= '<td>' . substr($row['startDate'],0,10) . '</td>';
$ret .= '<td>' . substr($row['endDate'],0,10) . '</td>';
$ret .= '<td class="'.$row['owner'].'">' . $row['owner'] . '</td>';
$ret .= '</tr>';
}
$ret .= '</tbody></table>';
if (OutgoingEmail::available()) {
$mail = OutgoingEmail::get();
foreach ($contacts as $contact) {
$mail->addAddress($contact);
}
$mail->isHTML();
$mail->From = 'automail@wholefoods.coop';
$mail->FromName = 'CORE POS Monitoring';
$mail->Subject ='Report: New Prices Starting Today';
$msg = $style;
$msg .= date('m-d-y').' The following <strong>PRICE CHANGE BATCH(ES)</strong> went
into effect today. <br /><br />';
$msg .= $ret;
$mail->Body = $msg;
if (!$mail->send()) {
$this->logger->error('Error emailing monitoring notification');
}
}
return false;
}
}
}