public function run()
{
$dbc = FannieDB::get($this->config->get('OP_DB'));
$yesterday = date('Y-m-d', strtotime('yesterday'));
$url = $this->config->get('URL');
$host = php_uname('n');
$dtrans = DTransactionsModel::selectDTrans($yesterday);
$findP = $dbc->prepare('
SELECT d.upc,
d.description,
d.department,
p.inUse,
count(*) AS occurences
FROM ' . $dtrans . ' AS d ' . DTrans::joinProducts('d') . '
WHERE d.trans_type=\'L\'
AND d.trans_subtype=\'OG\'
AND d.charflag=\'IU\'
AND d.emp_no <> 9999
AND d.register_no <> 99
AND d.datetime BETWEEN ? AND ?
GROUP BY d.upc,
d.description,
d.department,
p.inUse
HAVING SUM(d.quantity) <> 0
');
$findR = $dbc->execute($findP, array($yesterday . ' 00:00:00', $yesterday . ' 23:59:59'));
while ($w = $dbc->fetchRow($findR)) {
$msg = sprintf('%s (%s) was sold %d times while not inUse', $w['description'], $w['upc'], $w['occurences']);
$email = \COREPOS\Fannie\API\lib\AuditLib::getAddresses($w['department']);
if ($email) {
$subject = 'Not In Use Report';
$from = "From: automail\r\n";
$msg .= "\n";
$msg .= "http://{$host}/{$url}item/ItemEditorPage.php?searchupc={$w['upc']}\n";
mail($email, $subject, $msg, $from);
} else {
$this->cronMsg($msg);
}
}
}
