2 namespace Statistical\Service;
7 * Manage Statistical data.
10 class Statistical extends \Workspace\Service\DataBin
16 protected $meta = array(
17 'Base' => 'Statistical',
18 'DatasetName' => 'statistical',
19 'Entity' => '\Statistical\Entity\Statistical',
20 'References' => array(),
26 protected $metaList = array(
27 'Contract' => 'Recurring',
28 'RequiredInput' => array(),
29 'OptionalInput' => array(
32 'dealdone' => 'Boolean',
33 'dealnotdone' => 'Boolean',
34 'tradecentre' => 'Boolean',
35 'fromProfile' => 'Id',
54 protected $metaCreate = array(
55 'Contract' => 'Recurring',
56 'RequiredInput' => array(
60 'OptionalInput' => array(
61 'dealdone' => 'Boolean',
62 'dealnotdone' => 'Boolean',
63 'tradecentre' => 'Boolean',
70 public function clickReport()
72 $counts = $this->em->createQuery(
73 'SELECT c.bannerId, COUNT(c.id) AS total '
74 . 'FROM \\Statistical\\Entity\\Click c '
75 . 'WHERE c.created >= :minDate '
76 . 'GROUP BY c.bannerId'
78 ->setParameter('minDate', date('Y-m-') . '01 00:00:00')
81 $data[] = '<h4>Click report for ' . date('Y-m') . '</h4>';
83 foreach ($counts as $count)
85 $data[] = $count['bannerId'] . ': ' . $count['total'] . '<br/>';
90 $oNotify = new \Utility\Comms\Notification();
91 $oNotify->sendBasicEmail(
92 'info@bid4cars.com.na',
93 'Click report for ' . date('Y-m'),