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(); | |
} | |
} |