public function onRun(Enlight_Components_Cron_EventArgs $args)
{
$sql = '
SELECT
d.ordernumber,
d.id,
a.id as `articleID`,
d.unitID,
a.name,
a.description,
a.description_long,
a.shippingtime,
a.datum as `added`,
a.topseller,
a.keywords,
a.taxID,
a.supplierID,
a.changetime as `changed`,
d.id as `articledetailsID`,
d.ordernumber,
d.suppliernumber,
d.kind,
d.additionaltext,
d.impressions,
d.sales,
d.active,
d.instock,
d.stockmin,
d.weight,
d.position,
at.attr1, at.attr2, at.attr3, at.attr4, at.attr5, at.attr6, at.attr7, at.attr8, at.attr9, at.attr10,
at.attr11, at.attr12, at.attr13, at.attr14, at.attr15, at.attr16, at.attr17, at.attr18, at.attr19, at.attr20,
s.name as supplier,
u.unit,
t.tax
FROM s_articles a
INNER JOIN s_articles_details as d
INNER JOIN s_articles_attributes as at
LEFT JOIN s_articles_supplier as s
ON a.supplierID = s.id
LEFT JOIN s_core_units as u
ON d.unitID = u.id
LEFT JOIN s_core_tax as t
ON a.taxID = t.id
WHERE d.articleID = a.id
AND d.id = at.articledetailsID
AND stockmin > instock
';
$articles = Shopware()->Db()->fetchAssoc($sql);
$data = array('count' => count($articles), 'numbers' => array_keys($articles));
if (empty($articles)) {
return $data;
}
$job = $args->getJob();
$context = array('sData' => $data, 'sJob' => array('articles' => $articles));
$mail = Shopware()->TemplateMail()->createMail($job->get('inform_template'), $context);
$mail->addTo($job->get('inform_mail'));
$mail->send();
return $data;
}
/**
* Returns a value of an element in the list.
*
* @param string $key
* @return mixed
*/
public function get($key)
{
if ($key === 'data') {
return $this->getReturn();
}
return parent::get($key);
}
public function onJobAction(Enlight_Components_Cron_EventArgs $args)
{
$this->assertEquals('article_stock', $args->Job()->getAction());
}
