app/Customize/Controller/custumEventController.php line 269

Open in your IDE?
  1. <?php
  3. namespace Customize\Controller;
  5. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Method;
  6. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
  7. use Symfony\Component\HttpFoundation\Response;
  9. use Doctrine\ORM\Query\ResultSetMapping;
  12. /* add */
  13. use Eccube\Controller\AbstractController;
  14. use Eccube\Entity\Product;
  15. use Eccube\Repository\CustomerRepository;
  16. use Eccube\Common\EccubeConfig;
  17. use Symfony\Component\Security\Core\Encoder\EncoderFactoryInterface;
  18. use Eccube\Service\MailService;
  19. use Eccube\Service\TeikiService;
  21. /* add2 reminde */
  22. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  23. use Eccube\Form\Type\Front\ForgotType;
  24. use Eccube\Form\Type\Front\PasswordResetType;
  25. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  27. use Eccube\Form\Type\SearchProductType;
  28. use Sensio\Bundle\FrameworkExtraBundle\Configuration\ParamConverter;
  29. use Symfony\Component\HttpFoundation\Request;
  30. use Eccube\Form\Type\AddCartType;
  31. use Eccube\Event\EventArgs;
  32. use Eccube\Event\EccubeEvents;
  33. use Eccube\Repository\BaseInfoRepository;
  35. use Google_Client;
  36. use Google_Service_Calendar;
  37. use Google_Service_Calendar_Event;
  38. use Eccube\Form\Type\Front\PhotoType;
  39. use Carbon\Carbon;
  42. class custumEventController extends AbstractController
  43. {
  45.     protected $BaseInfo;
  46.     protected $customerRepository;
  47.     protected $mailService;
  49.     /**
  50.      * SamplePageController constructor.
  51.      * @param \Eccube\Repository\BaseInfoRepository $baseInfoRepository
  52.      * @param \Eccube\Repository\CustomerRepository $customerRepository
  53.      * @param \Eccube\Service\MailService $mailService
  54.      */
  55.     public function __construct(
  56.         \Eccube\Repository\BaseInfoRepository $baseInfoRepository,
  57.         \Eccube\Repository\CustomerRepository $customerRepository,
  58.         \Eccube\Service\MailService $mailService,
  59.         )
  60.     {
  61.         $this->BaseInfo = $baseInfoRepository->get();
  62.         $this->customerRepository = $customerRepository;
  63.         $this->mailService = $mailService;
  64.     }
  67.     /**
  68.     * @Route("/plan/2024sakura", name="sakura2024", methods={"GET"})
  69.     * @Template("Plan/2024sakura.twig")
  70.     */
  71.     public function sakura2024()
  72.     {
  73.         try {
  74.             $this->session->set('sakura2004', "set");
  76.             //----------------------------------
  77.             //ここから下はカレンダー 
  78.             //----------------------------------
  79.             // サービスオブジェクトを作成
  80.             $client = new Google_Client();
  81.             // サービスアカウント作成時にダウンロードしたjsonファイル
  82.             $aimJsonPath = './ornate-axiom-406706-fd999b268a9d.json';
  84.             // サービスオブジェクトを作成
  85.             $client = new Google_Client();
  87.             // このアプリケーション名
  88.             $client->setApplicationName('カレンダー操作テスト イベントの取得');
  90.             // ※ 注意ポイント: 権限の指定
  91.             // 予定を取得する時は Google_Service_Calendar::CALENDAR_READONLY
  92.             // 予定を追加する時は Google_Service_Calendar::CALENDAR_EVENTS
  93.             $client->setScopes(Google_Service_Calendar::CALENDAR_READONLY);
  95.             // ユーザーアカウントのjsonを指定
  96.             $client->setAuthConfig($aimJsonPath);
  98.             // サービスオブジェクトの用意
  99.             $service = new Google_Service_Calendar($client);
  101.             // カレンダーID 2024桜イベントのカレンダー設定
  102.             $calendarId = 'f815c4cba3a22813d3bda95af18688b85cdbca97bd25e4c4e5bfb3fbd289d8e3@group.calendar.google.com';
  105.             // 取得時の詳細設定
  106.             // 日付を最短
  107.             $optParams = array(
  108.                 'orderBy' => 'startTime',
  109.                 'singleEvents' => true,
  110.                 'timeMax' => date('2024-04-08\T00:00:00\Z'),
  111.             );
  112.             $results = $service->events->listEvents($calendarId, $optParams);
  114.             //書式設定
  115.             foreach( $results->getItems() as $event) {
  116.                 for($i=date('Ymd', strtotime( $event->start->dateTime)); $i<=date('Ymd', strtotime($event->end->dateTime)); $i++){
  117.                     $tmp=date('Y/m/d', strtotime($i));
  118.                     $res[$tmp][date('H',strtotime($event->start->dateTime))] = date('H',strtotime($event->start->dateTime));
  119.                 }
  120.             }
  121.             //カレンダー開始日を設定
  122.             //+3 hourは、3時間前に時間判定するため
  123.             $today = date('Y/m/d',strtotime('+3 hour'));
  124.             $startDate = '2024/03/20';
  125.             if( $today > $startDate ) {
  126.                 $startDate=$today;
  127.             }
  129.             //返却値
  130.             return [
  131.                 'reserveInfo' => $res,
  132.                 'startdate' => $startDate,
  133.                 'nowdate' => date('Y/m/d',strtotime('+3 hour')),
  134.                 'nowtime' => date('Hi',strtotime('+3 hour')),
  135.                 'nextdate' => date('Y/m/d',strtotime('+1 day +3 hour')),
  136.                 'next2date' => date('Y/m/d',strtotime('+2 day +3 hour')),
  137.             ];
  139.         } catch (\Exception $e) {
  140. //            log_error('getFavorites Exception: ',  $e->getMessage());
  141.             return [
  142.                 'testtest' => $e->getMessage(),
  143.             ];
  144.         }
  145.     }
  148.     /**
  149.      * @Route("/plan/2024sakura/reserved", name="2024sakura_reserved", methods={"POST"})
  150.      * @Template("Plan/2024sakura_reserved.twig")
  151.      */
  152.     public function sakura2024_reserved()
  153.     {
  155.         try {
  157.             log_info('2024sakura_reserved 開始');
  159. //             if(!$this->session->get('sakura2004')) {
  160. //                 return $this->redirectToRoute('homepage');
  161. //             }
  163.             // カレンダーID
  164.             $calendarId = 'f815c4cba3a22813d3bda95af18688b85cdbca97bd25e4c4e5bfb3fbd289d8e3@group.calendar.google.com';
  165.             $aimJsonPath = './ornate-axiom-406706-fd999b268a9d.json';
  167.     
  168.             if($calendarId) {
  169.                 // サービスオブジェクトを作成
  170.                 $client = new Google_Client();
  172.                 // このアプリケーション名
  173.                 $client->setApplicationName('カレンダー操作テスト イベントの取得');
  175.                 log_info('2024sakura_reserved 開始１');
  177.                 // ※ 注意ポイント: 権限の指定
  178.                 // 予定を取得する時は Google_Service_Calendar::CALENDAR_READONLY
  179.                 // 予定を追加する時は Google_Service_Calendar::CALENDAR_EVENTS
  180.                 $client->setScopes(Google_Service_Calendar::CALENDAR_EVENTS);
  182.                 log_info('2024sakura_reserved 開始２');
  183.                 // ユーザーアカウントのjsonを指定
  184.                 $client->setAuthConfig($aimJsonPath);
  186.                 log_info('2024sakura_reserved 開始３');
  187.                 // サービスオブジェクトの用意
  188.                 $service = new Google_Service_Calendar($client);
  190.                 //日付と時間に分割
  191.                 $year = substr($_POST['request'], 0, 4);
  192.                 $month = substr($_POST['request'], 4, 2);
  193.                 $day = substr($_POST['request'], 6, 2);
  194.                 $hour = substr($_POST['request'], 8, 2);
  195.                 $minute = substr($_POST['request'], 10, 2);
  197.                 $start_datetime = new Carbon(sprintf("%s-%s-%s %s:%s:00", $year, $month, $day, $hour, $minute));
  198.                 $end_datetime = new Carbon(sprintf("%s-%s-%s %s:%s:00", $year, $month, $day, $hour, $minute));
  199.                 $end_datetime->addHour(2);    //２時間後を設定
  200.                 
  201.                 log_info('2024sakura_reserved 開始４');
  203.                 $description = "name:".$_POST['name'];
  204.                 log_info('2024sakura_reserved 開始５－１');
  205.                 $description .= "<br>Country:".$_POST['country'];
  206.                 log_info('2024sakura_reserved 開始５－２');
  207.                 $description .= "<br>mail:".$_POST['email'];
  208.                 log_info('2024sakura_reserved 開始５－３');
  209.                 $description .= "<br>tel:".$_POST['telcode'].' '.$_POST['tel'];
  210.                 log_info('2024sakura_reserved 開始５－４');
  211.                 $description .= "<br>参加人数:".$_POST['participants'];
  212.                 log_info('2024sakura_reserved 開始５－５');
  213.                 log_info('2024sakura_reserved 開始５－６');
  214.                 $description .= "<br>Transfer Option:".$_POST['transfer'];
  215.                 log_info('2024sakura_reserved 開始５－７');
  216.                 if (isset($_POST['pickup'])) {
  217.                 $description .= "<br>pickup:".$_POST['pickup'];
  218.                 } else {
  219.                     $_POST['pickup']='';
  220.                 }
  221.                 log_info('2024sakura_reserved 開始５－８');
  222.                 $description .= "<br>コメント:".$_POST['message'];
  224.                 log_info('2024sakura_reserved 開始６');
  227.                 $event = new Google_Service_Calendar_Event(array(
  228.                     'summary' => "2024 SAKURA name:".$_POST['name'],
  229.                     'start' => array(
  230.                         'dateTime' => $start_datetime,
  231.                         'timeZone' => 'Asia/Tokyo',
  232.                     ),
  233.                     'end' => array(
  234.                         'dateTime' => $end_datetime,
  235.                         'timeZone' => 'Asia/Tokyo',
  236.                     ),
  237.                     'description' => $description,
  238.                 ));
  240.                 log_info('2024sakura_reserved 開始７');
  241.                 $event = $service->events->insert($calendarId, $event);
  243.                 log_info('2024sakura_reserved 開始８');
  244.             }
  246.             //
  247. //            INSERT INTO dtb_order(name01, email, phone_number, subtotal, tax, total, payment_total, payment_method, create_date, update_date, order_date, currency_code, add_point, use_point, order_status_id, discriminator_type) VALUES ('TEST', 'yell.616@gmail.com', '0000000000', '160000', '0', '160000', '160000', '代金引換', now(), now(), now(), 'JPY', '0', '0', '1', 'order');
  249.             //メール送信、17は「dtb_mail_template」のID
  250.             $this->mailService->sendReserveRequest($_POST,17);
  252.             $this->session->remove('sakura2004');
  253.             log_info('2024sakura_reserved 終了');
  254.             return [
  255.             ];
  256.         } catch (\Exception $e) {
  257.             log_info('2024sakura_reserved Exception');
  258.             return [
  259.                 'testtest' => $e->getMessage(),
  260.             ];
  261.         }
  262.     }
  265.     /**
  266.     * @Route("/plan/limited", name="limited", methods={"GET"})
  267.     * @Template("Plan/limited.twig")
  268.     */
  269.     public function limited()
  270.     {
  271.         try {
  272.             $this->session->set('limited', "set");
  274.             //----------------------------------
  275.             //ここから下はカレンダー 
  276.             //----------------------------------
  277.             // サービスオブジェクトを作成
  278.             $client = new Google_Client();
  279.             // サービスアカウント作成時にダウンロードしたjsonファイル
  280.             $aimJsonPath = './ornate-axiom-406706-fd999b268a9d.json';
  282.             // サービスオブジェクトを作成
  283.             $client = new Google_Client();
  285.             // このアプリケーション名
  286.             $client->setApplicationName('カレンダー操作テスト イベントの取得');
  288.             // ※ 注意ポイント: 権限の指定
  289.             // 予定を取得する時は Google_Service_Calendar::CALENDAR_READONLY
  290.             // 予定を追加する時は Google_Service_Calendar::CALENDAR_EVENTS
  291.             $client->setScopes(Google_Service_Calendar::CALENDAR_READONLY);
  293.             // ユーザーアカウントのjsonを指定
  294.             $client->setAuthConfig($aimJsonPath);
  296.             // サービスオブジェクトの用意
  297.             $service = new Google_Service_Calendar($client);
  299.             // カレンダーID 2024桜イベントのカレンダー設定
  300.             $calendarId = 'cd71e0a784b8b714563997b9e6ddafab3fd57ee1f4f9e543a15861610afb9a22@group.calendar.google.com';
  303.             // 取得時の詳細設定
  304.             // 日付を最短
  305.             $optParams = array(
  306.                 'orderBy' => 'startTime',
  307.                 'singleEvents' => true,
  308.                 'timeMax' => date('c',strtotime("+3 month")),    //３か月分
  309.             );
  310.             $results = $service->events->listEvents($calendarId, $optParams);
  313.             //書式設定
  314.             $res['calendar']=true;
  315.             foreach( $results->getItems() as $event) {
  316.                 for($i=date('Ymd', strtotime( $event->start->dateTime)); $i<=date('Ymd', strtotime($event->end->dateTime)); $i++){
  317.                     $year = substr($i, 0,4);
  318.                     $month = substr($i, 4,2);
  319.                     $day = substr($i, 6,2);
  320.                     if(checkdate ( $month , $day , $year )) {
  321.                         $tmp=date('Y-m-d', strtotime($i));
  322.                         $res[$tmp] = $tmp;
  323.                     }
  324.                 }
  325.             }
  327.             //返却値
  328.             return [
  329.                 'events' => json_encode($res),
  330.                 'calendar_start_date' => date('Y-m-d', strtotime('+2 day')),
  331.             ];
  333.         } catch (\Exception $e) {
  334. //            log_error('getFavorites Exception: ',  $e->getMessage());
  335.             return [
  336.                 'testtest' => $e->getMessage(),
  337.                 'events' => json_encode($res),
  338.             ];
  339.         }
  340.     }
  343.     /**
  344.      * @Route("/plan/limited/reserved", name="limited_reserved", methods={"POST"})
  345.      * @Template("Plan/limited_reserved.twig")
  346.      */
  347.     public function limited_reserved()
  348.     {
  350.         try {
  352.             log_info('limited_reserved 開始');
  354. //             if(!$this->session->get('limited')) {
  355. //                 return $this->redirectToRoute('homepage');
  356. //             }
  358.             // カレンダーID
  359.             $calendarId = "cd71e0a784b8b714563997b9e6ddafab3fd57ee1f4f9e543a15861610afb9a22@group.calendar.google.com";
  360.             $aimJsonPath = './ornate-axiom-406706-fd999b268a9d.json';
  362.     
  363.             if($calendarId) {
  364.                 // サービスオブジェクトを作成
  365.                 $client = new Google_Client();
  367.                 // このアプリケーション名
  368.                 $client->setApplicationName('カレンダー操作テスト イベントの取得');
  370.                 // ※ 注意ポイント: 権限の指定
  371.                 // 予定を取得する時は Google_Service_Calendar::CALENDAR_READONLY
  372.                 // 予定を追加する時は Google_Service_Calendar::CALENDAR_EVENTS
  373.                 $client->setScopes(Google_Service_Calendar::CALENDAR_EVENTS);
  375.                 // ユーザーアカウントのjsonを指定
  376.                 $client->setAuthConfig($aimJsonPath);
  379.                 // サービスオブジェクトの用意
  380.                 $service = new Google_Service_Calendar($client);
  382.                 
  383.                 log_info('limited_reserved 開始４');
  385.                 $description = "date:".$_POST['startdate'];
  386.                 $description .= "<br>name:".$_POST['name'];
  387.                 $description .= "<br>Country:".$_POST['country'];
  388.                 $description .= "<br>mail:".$_POST['email'];
  389.                 $description .= "<br>tel:".$_POST['telcode'].' '.$_POST['tel'];
  390.                 $description .= "<br>参加人数:".$_POST['participants'];
  391.                 $description .= "<br>pickup:".$_POST['pickup'];
  392.                 $description .= "<br>コメント:".$_POST['message'];
  395.                 $start_datetime = new Carbon($_POST['startdate']." 13:00:00");
  396.                 $end_datetime = new Carbon($_POST['startdate']." 20:00:00");
  397.                 $event = new Google_Service_Calendar_Event(array(
  398.                     'summary' => "Limited - name:".$_POST['name'],
  399.                     'start' => array(
  400.                         'dateTime' => $start_datetime,
  401.                         'timeZone' => 'Asia/Tokyo',
  402.                     ),
  403.                     'end' => array(
  404.                         'dateTime' => $end_datetime,
  405.                         'timeZone' => 'Asia/Tokyo',
  406.                     ),
  407.                     'description' => $description,
  408.                 ));
  410.                 log_info('limited_reserved $start_datetime:'.$start_datetime);
  411.                 log_info('limited_reserved $end_datetime:'.$end_datetime);
  412.                 log_info('limited_reserved $description:'.$description);
  413.                 log_info('limited_reserved 開始７');
  414.                 $event = $service->events->insert($calendarId, $event);
  416.                 log_info('limited_reserved 開始８');
  417.             }
  419.             //
  421.             //メール送信、24は「dtb_mail_template」のID
  422.             $this->mailService->sendReserveRequest($_POST,24);
  424.             $this->session->remove('limited');
  425.             log_info('limited_reserved 終了');
  426.             return [
  427.                 'testtest' => '',
  428.             ];
  429.         } catch (\Exception $e) {
  430.             log_info('limited_reserved Exception');
  431.             return [
  432.                 'testtest' => $e->getMessage(),
  433.             ];
  434.         }
  435.     }
  437.     /**
  438.     * @Route("/plan/fireworks", name="fireworks", methods={"GET"})
  439.     * @Template("Plan/fireworks.twig")
  440.     */
  441.     public function fireworks()
  442.     {
  443.         try {
  444.             $this->session->set('limited', "set");
  447.             //返却値
  448.             return [
  449.             ];
  451.         } catch (\Exception $e) {
  452. //            log_error('getFavorites Exception: ',  $e->getMessage());
  453.             return [
  454.                 'testtest' => $e->getMessage(),
  455.                 'events' => json_encode($res),
  456.             ];
  457.         }
  458.     }
  461.     /**
  462.      * @Route("/plan/fireworks/reserved", name="fireworks_reserved", methods={"POST"})
  463.      * @Template("Plan/fireworks_reserved.twig")
  464.      */
  465.     public function fireworks_reserved()
  466.     {
  468.         try {
  470.             log_info('fireworks_reserved 開始');
  472.              if(!$this->session->get('limited')) {
  473.                  return $this->redirectToRoute('homepage');
  474.              }
  476.             //メール送信、24は「dtb_mail_template」のID
  477.             $this->mailService->sendReserveRequest($_POST,25);
  479.             $this->session->remove('limited');
  480.             log_info('limited_reserved 終了');
  481.             return [
  482.                 'testtest' => '',
  483.             ];
  484.         } catch (\Exception $e) {
  485.             log_info('limited_reserved Exception');
  486.             return [
  487.                 'testtest' => $e->getMessage(),
  488.             ];
  489.         }
  490.     }
  493.     /**
  494.     * @Route("/plan/cruisefireworks", name="cruisefireworks", methods={"GET"})
  495.     * @Template("Plan/cruisefireworks.twig")
  496.     */
  497.     public function cruisefireworks()
  498.     {
  499.         try {
  500.             $this->session->set('limited', "set");
  503.             //返却値
  504.             return [
  505.             ];
  507.         } catch (\Exception $e) {
  508. //            log_error('getFavorites Exception: ',  $e->getMessage());
  509.             return [
  510.                 'testtest' => $e->getMessage(),
  511.                 'events' => json_encode($res),
  512.             ];
  513.         }
  514.     }
  517.     /**
  518.      * @Route("/plan/cruisefireworks/reserved", name="cruisefireworks_reserved", methods={"POST"})
  519.      * @Template("Plan/cruisefireworks_reserved.twig")
  520.      */
  521.     public function cruisefireworks_reserved()
  522.     {
  524.         try {
  526.             log_info('cruisefireworks_reserved 開始');
  528.              if(!$this->session->get('limited')) {
  529.                  return $this->redirectToRoute('homepage');
  530.              }
  532.             //メール送信、24は「dtb_mail_template」のID
  533.             $this->mailService->sendReserveRequest($_POST,25);
  535.             $this->session->remove('limited');
  536.             log_info('limited_reserved 終了');
  537.             return [
  538.                 'testtest' => '',
  539.             ];
  540.         } catch (\Exception $e) {
  541.             log_info('limited_reserved Exception');
  542.             return [
  543.                 'testtest' => $e->getMessage(),
  544.             ];
  545.         }
  546.     }
  550.     /**
  551.     * @Route("/plan/carlimited", name="carlimited", methods={"GET"})
  552.     * @Template("Plan/carlimited.twig")
  553.     */
  554.     public function carlimited()
  555.     {
  556.         try {
  557.             $this->session->set('limited', "set");
  560.             //返却値
  561.             return [
  562.             ];
  564.         } catch (\Exception $e) {
  565. //            log_error('getFavorites Exception: ',  $e->getMessage());
  566.             return [
  567.                 'testtest' => $e->getMessage(),
  568.                 'events' => json_encode($res),
  569.             ];
  570.         }
  571.     }
  574.     /**
  575.      * @Route("/plan/carlimited/reserved", name="carlimited_reserved", methods={"POST"})
  576.      * @Template("Plan/carlimited_reserved.twig")
  577.      */
  578.     public function carlimited_reserved()
  579.     {
  581.         try {
  583.             log_info('carlimited_reserved 開始');
  585.              if(!$this->session->get('limited')) {
  586.                  return $this->redirectToRoute('homepage');
  587.              }
  589.             //メール送信、28は「dtb_mail_template」のID
  590.             $this->mailService->sendReserveRequest($_POST,28);
  592.             $this->session->remove('limited');
  593.             log_info('carlimited_reserved 終了');
  594.             return [
  595.                 'testtest' => '',
  596.             ];
  597.         } catch (\Exception $e) {
  598.             log_info($e);
  599.             log_info('carlimited_reserved Exception');
  600.             return [
  601.                 'testtest' => $e->getMessage(),
  602.             ];
  603.         }
  604.     }
  605. }