protected function getOrderEachStatus($em, array $excludes)
{
$sql = 'SELECT
t1.status as status,
COUNT(t1.order_id) as count
FROM
dtb_order t1
WHERE
t1.del_flg = 0
AND t1.status NOT IN (:excludes)
GROUP BY
t1.status
ORDER BY
t1.status';
$rsm = new ResultSetMapping();
$rsm->addScalarResult('status', 'status');
$rsm->addScalarResult('count', 'count');
$query = $em->createNativeQuery($sql, $rsm);
$query->setParameters(array(':excludes' => $excludes));
$result = $query->getResult();
$orderArray = array();
foreach ($result as $row) {
$orderArray[$row['status']] = $row['count'];
}
return $orderArray;
}