Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
50.00% |
5 / 10 |
CRAP | |
79.76% |
134 / 168 |
| AdminController | |
0.00% |
0 / 1 |
|
50.00% |
5 / 10 |
28.77 | |
79.76% |
134 / 168 |
| login | |
0.00% |
0 / 1 |
2.00 | |
90.91% |
10 / 11 |
|||
| index | |
0.00% |
0 / 1 |
5 | |
96.92% |
63 / 65 |
|||
| changePassword | |
0.00% |
0 / 1 |
30 | |
0.00% |
0 / 29 |
|||
| searchNonStockProducts | |
0.00% |
0 / 1 |
3.00 | |
92.86% |
13 / 14 |
|||
| findOrderStatus | |
100.00% |
1 / 1 |
1 | |
100.00% |
5 / 5 |
|||
| getOrderEachStatus | |
100.00% |
1 / 1 |
2 | |
100.00% |
11 / 11 |
|||
| getSalesByMonth | |
0.00% |
0 / 1 |
2.01 | |
87.50% |
7 / 8 |
|||
| getSalesByDay | |
100.00% |
1 / 1 |
2 | |
100.00% |
8 / 8 |
|||
| countNonStockProducts | |
100.00% |
1 / 1 |
1 | |
100.00% |
8 / 8 |
|||
| countCustomers | |
100.00% |
1 / 1 |
1 | |
100.00% |
9 / 9 |
|||
| <?php | |
| /* | |
| * This file is part of EC-CUBE | |
| * | |
| * Copyright(c) 2000-2015 LOCKON CO.,LTD. All Rights Reserved. | |
| * | |
| * http://www.lockon.co.jp/ | |
| * | |
| * This program is free software; you can redistribute it and/or | |
| * modify it under the terms of the GNU General Public License | |
| * as published by the Free Software Foundation; either version 2 | |
| * of the License, or (at your option) any later version. | |
| * | |
| * This program is distributed in the hope that it will be useful, | |
| * but WITHOUT ANY WARRANTY; without even the implied warranty of | |
| * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | |
| * GNU General Public License for more details. | |
| * | |
| * You should have received a copy of the GNU General Public License | |
| * along with this program; if not, write to the Free Software | |
| * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. | |
| */ | |
| namespace Eccube\Controller\Admin; | |
| use Doctrine\ORM\NoResultException; | |
| use Doctrine\ORM\Query\ResultSetMapping; | |
| use Eccube\Application; | |
| use Eccube\Common\Constant; | |
| use Eccube\Controller\AbstractController; | |
| use Eccube\Event\EccubeEvents; | |
| use Eccube\Event\EventArgs; | |
| use Symfony\Component\HttpFoundation\Request; | |
| class AdminController extends AbstractController | |
| { | |
| public function login(Application $app, Request $request) | |
| { | |
| if ($app->isGranted('ROLE_ADMIN')) { | |
| return $app->redirect($app->url('admin_homepage')); | |
| } | |
| /* @var $form \Symfony\Component\Form\FormInterface */ | |
| $builder = $app['form.factory'] | |
| ->createNamedBuilder('', 'admin_login'); | |
| $event = new EventArgs( | |
| array( | |
| 'builder' => $builder, | |
| ), | |
| $request | |
| ); | |
| $app['eccube.event.dispatcher']->dispatch(EccubeEvents::ADMIN_ADMIM_LOGIN_INITIALIZE, $event); | |
| $form = $builder->getForm(); | |
| return $app->render('login.twig', array( | |
| 'error' => $app['security.last_error']($request), | |
| 'form' => $form->createView(), | |
| )); | |
| } | |
| public function index(Application $app, Request $request) | |
| { | |
| // install.phpのチェック. | |
| if (isset($app['config']['eccube_install']) && $app['config']['eccube_install'] == 1) { | |
| $file = $app['config']['root_dir'] . '/html/install.php'; | |
| if (file_exists($file)) { | |
| $message = $app->trans('admin.install.warning', array('installphpPath' => 'html/install.php')); | |
| $app->addWarning($message, 'admin'); | |
| } | |
| $fileOnRoot = $app['config']['root_dir'] . '/install.php'; | |
| if (file_exists($fileOnRoot)) { | |
| $message = $app->trans('admin.install.warning', array('installphpPath' => 'install.php')); | |
| $app->addWarning($message, 'admin'); | |
| } | |
| } | |
| // 受注マスター検索用フォーム | |
| $searchOrderBuilder = $app['form.factory'] | |
| ->createBuilder('admin_search_order'); | |
| // 商品マスター検索用フォーム | |
| $searchProductBuilder = $app['form.factory'] | |
| ->createBuilder('admin_search_product'); | |
| // 会員マスター検索用フォーム | |
| $searchCustomerBuilder = $app['form.factory'] | |
| ->createBuilder('admin_search_customer'); | |
| $event = new EventArgs( | |
| array( | |
| 'searchOrderBuilder' => $searchOrderBuilder, | |
| 'searchProductBuilder' => $searchProductBuilder, | |
| 'searchCustomerBuilder' => $searchCustomerBuilder, | |
| ), | |
| $request | |
| ); | |
| $app['eccube.event.dispatcher']->dispatch(EccubeEvents::ADMIN_ADMIM_INDEX_INITIALIZE, $event); | |
| // 受注マスター検索用フォーム | |
| $searchOrderForm = $searchOrderBuilder->getForm(); | |
| // 商品マスター検索用フォーム | |
| $searchProductForm = $searchProductBuilder->getForm(); | |
| // 会員マスター検索用フォーム | |
| $searchCustomerForm = $searchCustomerBuilder->getForm(); | |
| /** | |
| * 受注状況. | |
| */ | |
| $excludes = array(); | |
| $excludes[] = $app['config']['order_pending']; | |
| $excludes[] = $app['config']['order_processing']; | |
| $excludes[] = $app['config']['order_cancel']; | |
| $excludes[] = $app['config']['order_deliv']; | |
| $event = new EventArgs( | |
| array( | |
| 'excludes' => $excludes, | |
| ), | |
| $request | |
| ); | |
| $app['eccube.event.dispatcher']->dispatch(EccubeEvents::ADMIN_ADMIM_INDEX_ORDER, $event); | |
| // 受注ステータスごとの受注件数. | |
| $Orders = $this->getOrderEachStatus($app['orm.em'], $excludes); | |
| // 受注ステータスの一覧. | |
| $OrderStatuses = $this->findOrderStatus($app['orm.em'], $excludes); | |
| /** | |
| * 売り上げ状況 | |
| */ | |
| $excludes = array(); | |
| $excludes[] = $app['config']['order_processing']; | |
| $excludes[] = $app['config']['order_cancel']; | |
| $excludes[] = $app['config']['order_pending']; | |
| $event = new EventArgs( | |
| array( | |
| 'excludes' => $excludes, | |
| ), | |
| $request | |
| ); | |
| $app['eccube.event.dispatcher']->dispatch(EccubeEvents::ADMIN_ADMIM_INDEX_SALES, $event); | |
| // 今日の売上/件数 | |
| $salesToday = $this->getSalesByDay($app['orm.em'], new \DateTime(), $excludes); | |
| // 昨日の売上/件数 | |
| $salesYesterday = $this->getSalesByDay($app['orm.em'], new \DateTime('-1 day'), $excludes); | |
| // 今月の売上/件数 | |
| $salesThisMonth = $this->getSalesByMonth($app['orm.em'], new \DateTime(), $excludes); | |
| /** | |
| * ショップ状況 | |
| */ | |
| // 在庫切れ商品数 | |
| $countNonStockProducts = $this->countNonStockProducts($app['orm.em']); | |
| // 本会員数 | |
| $countCustomers = $this->countCustomers($app['orm.em']); | |
| $event = new EventArgs( | |
| array( | |
| 'Orders' => $Orders, | |
| 'OrderStatuses' => $OrderStatuses, | |
| 'salesThisMonth' => $salesThisMonth, | |
| 'salesToday' => $salesToday, | |
| 'salesYesterday' => $salesYesterday, | |
| 'countNonStockProducts' => $countNonStockProducts, | |
| 'countCustomers' => $countCustomers, | |
| ), | |
| $request | |
| ); | |
| $app['eccube.event.dispatcher']->dispatch(EccubeEvents::ADMIN_ADMIM_INDEX_COMPLETE, $event); | |
| return $app->render('index.twig', array( | |
| 'searchOrderForm' => $searchOrderForm->createView(), | |
| 'searchProductForm' => $searchProductForm->createView(), | |
| 'searchCustomerForm' => $searchCustomerForm->createView(), | |
| 'Orders' => $Orders, | |
| 'OrderStatuses' => $OrderStatuses, | |
| 'salesThisMonth' => $salesThisMonth, | |
| 'salesToday' => $salesToday, | |
| 'salesYesterday' => $salesYesterday, | |
| 'countNonStockProducts' => $countNonStockProducts, | |
| 'countCustomers' => $countCustomers, | |
| )); | |
| } | |
| /** | |
| * パスワード変更画面 | |
| * | |
| * @param Application $app | |
| * @param Request $request | |
| * @return \Symfony\Component\HttpFoundation\RedirectResponse|\Symfony\Component\HttpFoundation\Response | |
| */ | |
| public function changePassword(Application $app, Request $request) | |
| { | |
| $builder = $app['form.factory'] | |
| ->createBuilder('admin_change_password'); | |
| $event = new EventArgs( | |
| array( | |
| 'builder' => $builder, | |
| ), | |
| $request | |
| ); | |
| $app['eccube.event.dispatcher']->dispatch(EccubeEvents::ADMIN_ADMIM_CHANGE_PASSWORD_INITIALIZE, $event); | |
| $form = $builder->getForm(); | |
| $form->handleRequest($request); | |
| if ($form->isSubmitted() && $form->isValid()) { | |
| $password = $form->get('change_password')->getData(); | |
| $Member = $app->user(); | |
| $dummyMember = clone $Member; | |
| $dummyMember->setPassword($password); | |
| $salt = $dummyMember->getSalt(); | |
| if (!isset($salt)) { | |
| $salt = $app['eccube.repository.member']->createSalt(5); | |
| $dummyMember->setSalt($salt); | |
| } | |
| $encryptPassword = $app['eccube.repository.member']->encryptPassword($dummyMember); | |
| $Member | |
| ->setPassword($encryptPassword) | |
| ->setSalt($salt); | |
| $status = $app['eccube.repository.member']->save($Member); | |
| if ($status) { | |
| $event = new EventArgs( | |
| array( | |
| 'form' => $form, | |
| ), | |
| $request | |
| ); | |
| $app['eccube.event.dispatcher']->dispatch(EccubeEvents::ADMIN_ADMIN_CHANGE_PASSWORD_COMPLETE, $event); | |
| $app->addSuccess('admin.change_password.save.complete', 'admin'); | |
| return $app->redirect($app->url('admin_change_password')); | |
| } | |
| $app->addError('admin.change_password.save.error', 'admin'); | |
| } | |
| return $app->render('change_password.twig', array( | |
| 'form' => $form->createView(), | |
| )); | |
| } | |
| /** | |
| * 在庫なし商品の検索結果を表示する. | |
| * | |
| * @param Application $app | |
| * @param Request $request | |
| * @return \Symfony\Component\HttpFoundation\Response | |
| */ | |
| public function searchNonStockProducts(Application $app, Request $request) | |
| { | |
| // 商品マスター検索用フォーム | |
| $form = $app['form.factory'] | |
| ->createBuilder('admin_search_product') | |
| ->getForm(); | |
| if ('POST' === $request->getMethod()) { | |
| $form->handleRequest($request); | |
| if ($form->isValid()) { | |
| // 在庫なし商品の検索条件をセッションに付与し, 商品マスタへリダイレクトする. | |
| $searchData = array(); | |
| $searchData['stock_status'] = Constant::DISABLED; | |
| $session = $request->getSession(); | |
| $session->set('eccube.admin.product.search', $searchData); | |
| return $app->redirect($app->url('admin_product_page', array( | |
| 'page_no' => 1, | |
| 'status' => $app['config']['admin_product_stock_status']))); | |
| } | |
| } | |
| return $app->redirect($app->url('admin_homepage')); | |
| } | |
| protected function findOrderStatus($em, array $excludes) | |
| { | |
| $qb = $em | |
| ->getRepository('Eccube\Entity\Master\OrderStatus') | |
| ->createQueryBuilder('os'); | |
| return $qb | |
| ->where($qb->expr()->notIn('os.id', $excludes)) | |
| ->getQuery() | |
| ->getResult(); | |
| } | |
| 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; | |
| } | |
| protected function getSalesByMonth($em, $dateTime, array $excludes) | |
| { | |
| // concat... for pgsql | |
| // http://stackoverflow.com/questions/1091924/substr-does-not-work-with-datatype-timestamp-in-postgres-8-3 | |
| $dql = 'SELECT | |
| SUBSTRING(CONCAT(o.order_date, \'\'), 1, 7) AS order_month, | |
| SUM(o.payment_total) AS order_amount, | |
| COUNT(o) AS order_count | |
| FROM | |
| Eccube\Entity\Order o | |
| WHERE | |
| o.del_flg = 0 | |
| AND o.OrderStatus NOT IN (:excludes) | |
| AND SUBSTRING(CONCAT(o.order_date, \'\'), 1, 7) = SUBSTRING(:targetDate, 1, 7) | |
| GROUP BY | |
| order_month'; | |
| $q = $em | |
| ->createQuery($dql) | |
| ->setParameter(':excludes', $excludes) | |
| ->setParameter(':targetDate', $dateTime); | |
| $result = array(); | |
| try { | |
| $result = $q->getSingleResult(); | |
| } catch (NoResultException $e) { | |
| // 結果がない場合は空の配列を返す. | |
| } | |
| return $result; | |
| } | |
| protected function getSalesByDay($em, $dateTime, array $excludes) | |
| { | |
| // concat... for pgsql | |
| // http://stackoverflow.com/questions/1091924/substr-does-not-work-with-datatype-timestamp-in-postgres-8-3 | |
| $dql = 'SELECT | |
| SUBSTRING(CONCAT(o.order_date, \'\'), 1, 10) AS order_day, | |
| SUM(o.payment_total) AS order_amount, | |
| COUNT(o) AS order_count | |
| FROM | |
| Eccube\Entity\Order o | |
| WHERE | |
| o.del_flg = 0 | |
| AND o.OrderStatus NOT IN (:excludes) | |
| AND SUBSTRING(CONCAT(o.order_date, \'\'), 1, 10) = SUBSTRING(:targetDate, 1, 10) | |
| GROUP BY | |
| order_day'; | |
| $q = $em | |
| ->createQuery($dql) | |
| ->setParameter(':excludes', $excludes) | |
| ->setParameter(':targetDate', $dateTime); | |
| $result = array(); | |
| try { | |
| $result = $q->getSingleResult(); | |
| } catch (NoResultException $e) { | |
| // 結果がない場合は空の配列を返す. | |
| } | |
| return $result; | |
| } | |
| protected function countNonStockProducts($em) | |
| { | |
| /** @var $qb \Doctrine\ORM\QueryBuilder */ | |
| $qb = $em->getRepository('Eccube\Entity\Product') | |
| ->createQueryBuilder('p') | |
| ->select('count(p.id)') | |
| ->innerJoin('p.ProductClasses', 'pc') | |
| ->where('pc.stock_unlimited = :StockUnlimited AND pc.stock = 0') | |
| ->setParameter('StockUnlimited', Constant::DISABLED); | |
| return $qb | |
| ->getQuery() | |
| ->getSingleScalarResult(); | |
| } | |
| protected function countCustomers($em) | |
| { | |
| $Status = $em | |
| ->getRepository('Eccube\Entity\Master\CustomerStatus') | |
| ->find(2); | |
| /** @var $qb \Doctrine\ORM\QueryBuilder */ | |
| $qb = $em->getRepository('Eccube\Entity\Customer') | |
| ->createQueryBuilder('c') | |
| ->select('count(c.id)') | |
| ->where('c.Status = :Status') | |
| ->setParameter('Status', $Status); | |
| return $qb | |
| ->getQuery() | |
| ->getSingleScalarResult(); | |
| } | |
| } |