'Statistical',
'DatasetName' => 'statistical',
'Entity' => '\Statistical\Entity\Statistical',
'References' => array(),
);
/**
* @var array
*/
protected $metaList = array(
'Contract' => 'Recurring',
'RequiredInput' => array(),
'OptionalInput' => array(
'Filter' => array(
'stock' => 'Id',
'dealdone' => 'Boolean',
'dealnotdone' => 'Boolean',
'tradecentre' => 'Boolean',
'fromProfile' => 'Id',
'created' => 'Date',
)
),
'Filter' => array(),
'Fields' => array(
'stock',
'dealdone',
'dealnotdone',
'tradecentre',
'fromProfile',
'created'
),
'Expand' => array()
);
/**
* @var array
*/
protected $metaCreate = array(
'Contract' => 'Recurring',
'RequiredInput' => array(
'stock' => 'Id',
'created' => 'Date'
),
'OptionalInput' => array(
'dealdone' => 'Boolean',
'dealnotdone' => 'Boolean',
'tradecentre' => 'Boolean',
'fromProfile' => 'Id'
)
);
public function clickReport()
{
$counts = $this->em->createQuery(
'SELECT c.bannerId, COUNT(c.id) AS total '
. 'FROM \\Statistical\\Entity\\Click c '
. 'WHERE c.created >= :minDate '
. 'GROUP BY c.bannerId'
)
->setParameter('minDate', date('Y-m-') . '01 00:00:00')
->getScalarResult();
$data = array();
$data[] = 'Click report for ' . date('Y-m') . '
';
$data[] = '
';
foreach ($counts as $count)
{
$data[] = $count['bannerId'] . ': ' . $count['total'] . '
';
}
$data[] = '
';
$data[] = '
';
$oNotify = new \Utility\Comms\Notification();
$oNotify->sendBasicEmail(
'info@bid4cars.co.za',
'Click report for ' . date('Y-m'),
implode('', $data)
);
}
}