src/Controller/api/ApiController.php line 175

  1. <?php
  3. namespace App\Controller\api;
  5. use App\Classes\ApiUtility;
  6. use App\Classes\ASUtility;
  7. use App\Classes\CommonUtility;
  8. use App\Entity\AccountCodes;
  9. use App\Entity\Configurations;
  10. use App\Repository\ConfigurationsRepository;
  11. use App\Repository\ActivityAssignmentsRepository;
  12. use App\Repository\ActivityDefineCrewsRepository;
  13. use App\Repository\ActivityDefineCrewPairsRepository;
  14. use App\Repository\AccountCodeActivitiesRepository;
  15. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  16. use Symfony\Component\HttpFoundation\Request;
  17. use Symfony\Component\HttpFoundation\Response;
  18. use Symfony\Component\Routing\Annotation\Route;
  19. use Psr\Log\LoggerInterface;
  20. use Doctrine\ORM\EntityManagerInterface;
  22. /**
  23.  * @Route("/api")
  24.  */
  25. class ApiController extends AbstractController
  26. {
  27.     private $apiLogger;
  28.     private $apiUtility;
  29.     private $activityAssignmentsRepository;
  30.     private $activityDefineCrewsRepository;
  31.     private $activityDefineCrewPairsRepository;
  32.     private $accountCodeActivitiesRepository;
  33.     private $entityManager;
  35.     public function __construct(
  36.         ApiUtility $apiUtility,
  37.         LoggerInterface $apiLogger,
  38.         EntityManagerInterface $entityManager,
  39.         ConfigurationsRepository $configurationsRepository,
  40.         ActivityAssignmentsRepository $activityAssignmentsRepository,
  41.         ActivityDefineCrewsRepository $activityDefineCrewsRepository,
  42.         ActivityDefineCrewPairsRepository $activityDefineCrewPairsRepository,
  43.         AccountCodeActivitiesRepository $accountCodeActivitiesRepository,
  44.     ) {
  47.         header('Content-type: application/json');
  49.         $this->apiUtility                          = $apiUtility;
  50.         $this->activityAssignmentsRepository       = $activityAssignmentsRepository;
  51.         $this->activityDefineCrewsRepository       = $activityDefineCrewsRepository;
  52.         $this->activityDefineCrewPairsRepository   = $activityDefineCrewPairsRepository;
  53.         $this->accountCodeActivitiesRepository     = $accountCodeActivitiesRepository;
  54.         $this->apiLogger                           = $apiLogger;
  55.         $this->entityManager                       = $entityManager;
  57.         $CONF_EW_API_ADMIN_USERNAME = $configurationsRepository->findByCode(Configurations::CONF_EW_API_ADMIN_USERNAME);
  58.         $CONF_EW_API_ADMIN_PASSWORD = $configurationsRepository->findByCode(Configurations::CONF_EW_API_ADMIN_PASSWORD);
  60.         // dd($_SERVER['PHP_AUTH_USER'], $_SERVER['PHP_AUTH_PW'],
  61.         //$CONF_EW_API_ADMIN_USERNAME, $CONF_EW_API_ADMIN_PASSWORD);
  63.         if (
  64.             (isset($_SERVER['PHP_AUTH_USER']) && ($_SERVER['PHP_AUTH_USER'] === $CONF_EW_API_ADMIN_USERNAME))
  65.             && (isset($_SERVER['PHP_AUTH_PW']) && ($_SERVER['PHP_AUTH_PW'] === $CONF_EW_API_ADMIN_PASSWORD))
  66.         ) {
  67.         } else {
  68.             //Send headers to cause a browser to request
  69.             //username and password from user
  70.             header("WWW-Authenticate: " . "Basic realm=\"AS-EW Protected Area\"");
  71.             header("HTTP/1.0 401 Unauthorized");
  73.             //Show failure text, which browsers usually
  74.             //show only after several failed attempts
  75.             print("invalid webservice credentials");
  76.             exit;
  77.         }
  78.     }
  80.     /**
  81.      * @Route("/hworld", name="hello_world", methods={"GET"})
  82.      * @return Response
  83.      */
  84.     public function helloWorld(Request $request)
  85.     {
  87.         $response = 'Hello World';
  88.         return $this->json($response);
  89.     }
  91.     /**
  92.      * @Route("/checkActivityAssignWorkers", name="check_activity_assign_workers", methods={"GET"})
  93.      * @param Request $request
  94.      * @return Response
  95.      */
  96.     public function checkActivityAssignWorkers(Request $request)
  97.     {
  99.         $conferenceId = $request->query->get('conferenceId');
  100.         $worksheetId = $request->query->get('worksheetId');
  102.         $response = array();
  104.         try {
  105.             if ($conferenceId && $worksheetId) {
  106.                 $response = $this->activityAssignmentsRepository->findByFilters(array(
  107.                     'assign_workers' => true,
  108.                     'conference_id' => $conferenceId,
  109.                     'worksheet_id' => $worksheetId
  110.                 ));
  112.                 $response = (CommonUtility::countArray($response) > 0) ? true : false;
  113.             }
  114.         } catch (\Exception $e) {
  115.             $response = array(
  116.                 "error" => array(
  117.                     "message" => $e->getMessage(),
  118.                     "code" => $e->getCode()
  119.                 )
  120.             );
  121.         }
  122.         return $this->json($response);
  123.     }
  126.     /**
  127.      * @Route("/loadActivityAssignWorkers", name="load_activity_assign_workers", methods={"GET"})
  128.      * @param Request $request
  129.      * @return Response
  130.      */
  131.     public function loadActivityAssignWorkers(Request $request)
  132.     {
  134.         $conferenceId = $request->query->get('conferenceId');
  135.         $schoolYear = $request->query->get('schoolYear');
  136.         $eventId = $request->query->get('eventId');
  137.         $dateId = $request->query->get('dateId');
  138.         $aglId = $request->query->get('aglId');
  140.         $response = array();
  142.         try {
  143.             if ($conferenceId && $dateId && $eventId) {
  144.                 $response = $this->activityAssignmentsRepository->findByFilters(array(
  145.                     'assign_workers' => true,
  146.                     'conference_id' => $conferenceId,
  147.                     'school_year' => $schoolYear,
  148.                     'date_id' => $dateId,
  149.                     'event_id' => $eventId,
  151.                 ));
  153.                 if (CommonUtility::countArray($response) > 0) {
  154.                     $response = $response[$aglId];
  155.                 }
  156.             }
  157.         } catch (\Exception $e) {
  158.             $response = array(
  159.                 "error" => array(
  160.                     "message" => $e->getMessage(),
  161.                     "code" => $e->getCode()
  162.                 )
  163.             );
  164.         }
  165.         return $this->json($response);
  166.     }
  170.     /**
  171.      * @Route("/eventSync", name="event_sync", methods={"POST"})
  172.      * @param Request $request
  173.      * @return Response
  174.      */
  175.     public function eventSync(Request $request)
  176.     {
  178.         $parameters = json_decode($request->getContent(), true);
  179.         $action = (isset($parameters["action"])) ? $parameters["action"] : '';
  180.         $eventIds = (isset($parameters["eventIds"])) ? $parameters["eventIds"] : array();
  181.         $conferenceId = (isset($parameters["conferenceId"])) ? $parameters["conferenceId"] : 0;
  182.         $details = (isset($parameters["details"])) ? $parameters["details"] : array();
  184.         $this->apiLogger->info(" --- START EVENT SYNCING ---");
  185.         $this->apiLogger->info("parameters: " . $request->getContent());
  187.         $response = array();
  188.         $objEntityManager = $this->entityManager;
  190.         try {
  191.             if (isset($action)) {
  192.                 if ($action === 'edit') {
  193.                     if (CommonUtility::countArray($eventIds) > 0) {
  194.                         $aActivityAssignments = $this->activityAssignmentsRepository->findByFilters(array(
  195.                             'conference_id' => $conferenceId,
  196.                             'event_ids' => $eventIds,
  197.                             'event' => true
  198.                         ));
  200.                         if (CommonUtility::countArray($aActivityAssignments) > 0) {
  201.                             $aActivityAssignmentsEventIdFound = array();
  202.                             foreach ($aActivityAssignments as $assId) {
  203.                                 $objActivityAssignmentsRepository = $this->activityAssignmentsRepository
  204.                                 ->find($assId['assignment_id']);
  206.                                 if ($objActivityAssignmentsRepository) {
  207.                                     if ($objActivityAssignmentsRepository->getEventId()) {
  208.                                         $aActivityAssignmentsEventIdFound[] =
  209.                                             $objActivityAssignmentsRepository->getEventId();
  210.                                     }
  212.                                     if (isset($details["date_id"])) {
  213.                                         $objActivityAssignmentsRepository->setDateId($details["date_id"]);
  214.                                     }
  216.                                     if (isset($details["event_id"])) {
  217.                                         $objActivityAssignmentsRepository->setEventId($details["event_id"]);
  218.                                     }
  220.                                     if (isset($details["season_id"])) {
  221.                                         $objActivityAssignmentsRepository->setSeasonId($details["season_id"]);
  222.                                     }
  224.                                     if (isset($details["season_name"])) {
  225.                                         $objActivityAssignmentsRepository->setSeasonName($details["season_name"]);
  226.                                     }
  228.                                     if (isset($details["activity_id"])) {
  229.                                         $objActivityAssignmentsRepository->setActivityId($details["activity_id"]);
  230.                                     }
  232.                                     if (isset($details["activity_name"])) {
  233.                                         $objActivityAssignmentsRepository->setActivityName($details["activity_name"]);
  234.                                     }
  236.                                     if (isset($details["event_date"]) || isset($details["event_updated_details"])) {
  237.                                         $eventDate = $details["event_updated_details"]["date"]["new"] !== ""
  238.                                             ? $details["event_updated_details"]["date"]["new"]
  239.                                             : $details["event_date"];
  240.                                         $eventDate = ($eventDate != '')
  241.                                             ? \DateTime::createFromFormat('Y-m-d', $eventDate) : null;
  242.                                         $objActivityAssignmentsRepository->setEventDate($eventDate);
  243.                                     }
  245.                                     if (isset($details["date_start"]) || isset($details["event_updated_details"])) {
  246.                                         $dateStart = $details["event_updated_details"]["date"]["new"] !== ""
  247.                                             ? $details["event_updated_details"]["date"]["new"]
  248.                                             : $details["date_start"];
  249.                                         ;
  250.                                         $dateStart = ($dateStart != '')
  251.                                             ? \DateTime::createFromFormat('Y-m-d', $dateStart) : null;
  252.                                         $objActivityAssignmentsRepository->setDateStart($dateStart);
  253.                                     }
  255.                                     if (isset($details["date_end"]) || isset($details["event_updated_details"])) {
  256.                                         $dateEnd = $details["event_updated_details"]["date"]["new"] !== ""
  257.                                             ? $details["event_updated_details"]["date"]["new"]
  258.                                             : $details["date_end"];
  259.                                         $dateEnd = ($dateEnd != '')
  260.                                             ? \DateTime::createFromFormat('Y-m-d', $dateEnd) : null;
  261.                                         $objActivityAssignmentsRepository->setDateEnd($dateEnd);
  262.                                     }
  264.                                     if (isset($details["time_start"]) || isset($details["event_updated_details"])) {
  265.                                         $timeStart = $details["event_updated_details"]["time"]["new"]["start"]
  266.                                             !== "" ? $details["event_updated_details"]["time"]["new"]["start"]
  267.                                             : $details["time_start"];
  268.                                         $timeStart = ($timeStart != '')
  269.                                             ? \DateTime::createFromFormat('H:i:s', $timeStart) : null;
  270.                                         $objActivityAssignmentsRepository->setTimeStart($timeStart);
  271.                                     }
  273.                                     if (isset($details["time_end"]) || isset($details["event_updated_details"])) {
  274.                                         $timeEnd = $details["event_updated_details"]["time"]["new"]["end"]
  275.                                             !== "" ? $details["event_updated_details"]["time"]["new"]["end"]
  276.                                             : $details["time_end"];
  277.                                         $timeEnd = ($timeEnd != '')
  278.                                             ? \DateTime::createFromFormat('H:i:s', $timeEnd) : null;
  279.                                         $objActivityAssignmentsRepository->setTimeEnd($timeEnd);
  280.                                     }
  282.                                     if (isset($details["location"]) || isset($details["event_updated_details"])) {
  283.                                         $location = $details["event_updated_details"]["location"]["new"] !== ""
  284.                                             ? $details[
  285.                                                 "event_updated_details"
  286.                                                 ]["location"]["new"] : $details["location"];
  287.                                         $objActivityAssignmentsRepository->setLocation($location);
  288.                                     }
  291.                                     if (isset($details["home"])) {
  292.                                         $objActivityAssignmentsRepository->setHome($details["home"]);
  293.                                     }
  295.                                     if (isset($details["away_infos"])) {
  296.                                         $away = "";
  297.                                         $awayInfos = array();
  298.                                         if (CommonUtility::countArray($details["away_infos"]) > 0) {
  299.                                             $awayInfos = $details["away_infos"];
  300.                                             $away = $awayInfos[0]["name"];
  301.                                         }
  303.                                         $objActivityAssignmentsRepository->setAway($away);
  304.                                         $objActivityAssignmentsRepository->setAwayInfos(json_encode($awayInfos));
  305.                                     }
  307.                                     if (isset($details["is_fs_connected"])) {
  308.                                         $objActivityAssignmentsRepository->setIsFsConnected(
  309.                                             $details["is_fs_connected"]
  310.                                         );
  311.                                     }
  313.                                     if (isset($details["event_status_id"])) {
  314.                                         $objActivityAssignmentsRepository->setEventStatusId(
  315.                                             $details["event_status_id"]
  316.                                         );
  317.                                     }
  319.                                     if (isset($details["event_status_name"])) {
  320.                                         $objActivityAssignmentsRepository->setEventStatusName(
  321.                                             $details["event_status_name"]
  322.                                         );
  323.                                     }
  325.                                     if (isset($details["event_status_active"])) {
  326.                                         $objActivityAssignmentsRepository->setEventStatusActive(
  327.                                             intval($details["event_status_active"])
  328.                                         );
  329.                                     }
  331.                                     if (isset($details["event_updated_details"])) {
  332.                                         $objActivityAssignmentsRepository->setEventUpdatedDetails(
  333.                                             json_encode([$details["event_updated_details"]])
  334.                                         );
  335.                                     }
  337.                                     //updating activity assignment info....
  338.                                     $objEntityManager->persist($objActivityAssignmentsRepository);
  339.                                     $objEntityManager->flush();
  340.                                 }
  341.                             }
  343.                             if (CommonUtility::countArray($aActivityAssignmentsEventIdFound) > 0) {
  344.                                 $response = array(
  345.                                     "success" => array(
  346.                                         "event_ids" => $aActivityAssignmentsEventIdFound,
  347.                                         "message" => "Successfully Updated",
  348.                                         "code" => 200
  349.                                     )
  350.                                 );
  351.                             } else {
  352.                                 $response = array(
  353.                                     "error" => array(
  354.                                         "event_ids" => $eventIds,
  355.                                         "message" => "No Event IDs found",
  356.                                         "code" => 404
  357.                                     )
  358.                                 );
  359.                             }
  360.                         } else {
  361.                             $response = array(
  362.                                 "error" => array(
  363.                                     "event_ids" => $eventIds,
  364.                                     "message" => "No Event IDs found",
  365.                                     "code" => 404
  366.                                 )
  367.                             );
  368.                         }
  369.                     } else {
  370.                         $response = array(
  371.                             "error" => array(
  372.                                 "message" => "DATA NOT FOUND",
  373.                                 "code" => 404
  374.                             )
  375.                         );
  376.                     }
  377.                 } elseif ($action === 'delete') {
  378.                     if (CommonUtility::countArray($eventIds) > 0) {
  379.                         $aActivityAssignments = $this->activityAssignmentsRepository->findByFilters(array(
  380.                             'conference_id' => $conferenceId,
  381.                             'event_ids' => $eventIds > 0 ? $eventIds : false,
  382.                             'event' => true
  383.                         ));
  385.                         if (CommonUtility::countArray($aActivityAssignments) > 0) {
  386.                             $response = array(
  387.                                 "success" => array(
  388.                                     "data" => $aActivityAssignments,
  389.                                     "code" => 200
  390.                                 )
  391.                             );
  392.                         } else {
  393.                             $response = array(
  394.                                 "success" => array(
  395.                                     "message" => "Event(s) not found!",
  396.                                     "code" => 200
  397.                                 )
  398.                             );
  399.                         }
  400.                     }
  401.                 } else {
  402.                     $response = array(
  403.                         "error" => array(
  404.                             "message" => "Please specify action to be process",
  405.                             "code" => 404
  406.                         )
  407.                     );
  408.                 }
  409.             } else {
  410.                 $response = array(
  411.                     "error" => array(
  412.                         "message" => "Please specify action to be process",
  413.                         "code" => 404
  414.                     )
  415.                 );
  416.             }
  417.         } catch (\Exception $e) {
  418.             $response = array(
  419.                 "error" => array(
  420.                     "message" => $e->getMessage(),
  421.                     "code" => $e->getCode()
  422.                 )
  423.             );
  424.         }
  426.         return $this->json($response);
  427.     }
  429.     /**
  430.      * @Route("/deleteEventSync", name="delete_event_sync", methods={"POST"})
  431.      * @param Request $request
  432.      * @return Response
  433.      */
  434.     public function deleteEventSync(Request $request)
  435.     {
  437.         $conferenceId = $request->query->get('conferenceId');
  438.         $workSheetIds = $request->query->get('workSheetIds');
  440.         $this->apiLogger->info(" --- START EVENT DELETE SYNCING ---");
  441.         $this->apiLogger->info("conferenceId: " . $conferenceId);
  442.         $this->apiLogger->info("workSheetIds: " . serialize($workSheetIds));
  444.         $workSheetIds = ($workSheetIds) ? $workSheetIds : array();
  446.         $response = false;
  447.         if ($conferenceId > 0 && CommonUtility::countArray($workSheetIds) > 0) {
  448.             $aActivityAssignments = $this->activityAssignmentsRepository->findByFilters(array(
  449.                 'conference_id' => $conferenceId,
  450.                 'worksheet_ids' => $workSheetIds,
  451.                 'event' => true
  452.             ));
  454.             if (CommonUtility::countArray($aActivityAssignments) > 0) {
  455.                 $this->activityAssignmentsRepository->deleteActivityAssignments(array(
  456.                     'conference_id' => $conferenceId,
  457.                     "worksheet_ids" => $workSheetIds
  458.                 ));
  460.                 $response = true;
  461.             }
  462.         }
  464.         return $this->json($response);
  465.     }
  467.     public function eventSOSync(Request $request)
  468.     {
  470.         $parameters = json_decode($request->getContent(), true);
  471.         $action = (isset($parameters["action"])) ? $parameters["action"] : '';
  472.         $eventIds = (isset($parameters["eventIds"])) ? $parameters["eventIds"] : array();
  473.         $conferenceId = (isset($parameters["conferenceId"])) ? $parameters["conferenceId"] : 0;
  474.         $details = (isset($parameters["details"])) ? $parameters["details"] : array();
  476.         $this->apiLogger->info(" --- START EVENT SO SYNCING ---");
  477.         $this->apiLogger->info("parameters: " . $request->getContent());
  479.         $response = array();
  480.         $objEntityManager = $this->entityManager;
  482.         try {
  483.             // if(count($eventIds) > 0){
  485.             //     $aActivityAssignments = $this->activityAssignmentsRepository->findByFilters(array(
  486.             //             'conference_id' => $conferenceId,
  487.             //             'event_ids' => $eventIds,
  488.             //             'event' => true
  489.             //         ));
  491.             //     if(count($aActivityAssignments) > 0){
  493.             //         $aActivityAssignmentsEventIdFound = array();
  494.             //         foreach($aActivityAssignments AS $assId){
  495.             //             $objActivityAssignmentsRepository = $this->activityAssignmentsRepository->find($assId);
  497.             //             if($objActivityAssignmentsRepository){
  499.             //                 if($objActivityAssignmentsRepository->getEventId())
  500.             //                     $aActivityAssignmentsEventIdFound[]
  501.             //          = $objActivityAssignmentsRepository->getEventId();
  503.             //                 if(isset($details["date_id"]))
  504.             //                     $objActivityAssignmentsRepository->setDateId($details["date_id"]);
  506.             //                 if(isset($details["event_id"]))
  507.             //                     $objActivityAssignmentsRepository->setEventId($details["event_id"]);
  509.             //                 if(isset($details["season_id"]))
  510.             //                     $objActivityAssignmentsRepository->setSeasonId($details["season_id"]);
  512.             //                 if(isset($details["season_name"]))
  513.             //                     $objActivityAssignmentsRepository->setSeasonName($details["season_name"]);
  515.             //                 if(isset($details["activity_id"]))
  516.             //                     $objActivityAssignmentsRepository->setActivityId($details["activity_id"]);
  518.             //                 if(isset($details["activity_name"]))
  519.             //                     $objActivityAssignmentsRepository->setActivityName($details["activity_name"]);
  521.             //                 if(isset($details["event_date"])){
  522.             //                     $eventDate = $details["event_date"];
  523.             //                     $eventDate = ($eventDate != '')
  524.             // ? \DateTime::createFromFormat('Y-m-d', $eventDate) : null;
  525.             //                     $objActivityAssignmentsRepository->setEventDate($eventDate);
  526.             //                 }
  528.             //                 if(isset($details["date_start"])){
  529.             //                     $dateStart = $details["date_start"];
  530.             //                     $dateStart = ($dateStart != '')
  531.             // ? \DateTime::createFromFormat('Y-m-d', $dateStart) : null;
  532.             //                     $objActivityAssignmentsRepository->setDateStart($dateStart);
  533.             //                 }
  535.             //                 if(isset($details["date_end"])){
  536.             //                     $dateEnd = $details["date_end"];
  537.             //                     $dateEnd = ($dateEnd != '')? \DateTime::createFromFormat('Y-m-d', $dateEnd) : null;
  538.             //                     $objActivityAssignmentsRepository->setDateEnd($dateEnd);
  539.             //                 }
  541.             //                 if(isset($details["time_start"])){
  542.             //                     $timeStart = $details["time_start"];
  543.             //                     $timeStart = ($timeStart != '')
  544.             //? \DateTime::createFromFormat('H:i:s', $timeStart) : null;
  545.             //                     $objActivityAssignmentsRepository->setTimeStart($timeStart);
  546.             //                 }
  548.             //                 if(isset($details["time_end"])){
  549.             //                     $timeEnd = $details["time_end"];
  550.             //                     $timeEnd = ($timeEnd != '')? \DateTime::createFromFormat('H:i:s', $timeEnd) : null;
  551.             //                     $objActivityAssignmentsRepository->setTimeEnd($timeEnd);
  552.             //                 }
  554.             //                 if(isset($details["location"]))
  555.             //                     $objActivityAssignmentsRepository->setLocation($details["location"]);
  557.             //                 if(isset($details["home"]))
  558.             //                     $objActivityAssignmentsRepository->setHome($details["home"]);
  560.             //                 if(isset($details["away_infos"])){
  562.             //                     $away = "";
  563.             //                     $awayInfos = array();
  564.             //                     if(count($details["away_infos"]) > 0){
  565.             //                         $awayInfos = $details["away_infos"];
  566.             //                         $away = $awayInfos[0]["name"];
  567.             //                     }
  569.             //                     $objActivityAssignmentsRepository->setAway($away);
  570.             //                     $objActivityAssignmentsRepository->setAwayInfos(json_encode($awayInfos));
  572.             //                 }
  574.             //                 if(isset($details["is_fs_connected"]))
  575.             //                     $objActivityAssignmentsRepository->setIsFsConnected($details["is_fs_connected"]);
  577.             //                 //updating activity assignment info....
  578.             //                 $objEntityManager->persist($objActivityAssignmentsRepository);
  579.             //                 $objEntityManager->flush();
  581.             //             }
  583.             //         }
  585.             //         if(count($aActivityAssignmentsEventIdFound) > 0){
  587.             //             $response = array(
  588.             //                 "success" => array(
  589.             //                 "event_ids" => $aActivityAssignmentsEventIdFound,
  590.             //                 "message" => "Successfully Updated",
  591.             //                 "code" => 200
  592.             //                 )
  593.             //             );
  595.             //         }else{
  597.             //             $response = array(
  598.             //                 "error" => array(
  599.             //                     "event_ids" => $eventIds,
  600.             //                     "message" => "No Event IDs found",
  601.             //                     "code" => 404
  602.             //                 )
  603.             //             );
  605.             //         }
  608.             //     } else {
  610.             //         $response = array(
  611.             //             "error" => array(
  612.             //                 "event_ids" => $eventIds,
  613.             //                 "message" => "No Event IDs found",
  614.             //                 "code" => 404
  615.             //             )
  616.             //         );
  618.             //     }
  622.             // }else{
  624.             //     $response = array(
  625.             //         "error" => array(
  626.             //             "message" => "DATA NOT FOUND",
  627.             //             "code" => 404
  628.             //         )
  629.             //     );
  631.             // }
  632.         } catch (\Exception $e) {
  633.             $response = array(
  634.                 "error" => array(
  635.                     "message" => $e->getMessage(),
  636.                     "code" => $e->getCode()
  637.                 )
  638.             );
  639.         }
  641.         return $this->json($response);
  642.     }
  644.     /**
  645.      * @Route("/aglSync", name="agl_sync", methods={"POST"})
  646.      * @param Request $request
  647.      * @return Response
  648.      */
  649.     public function activityGenderLevelSync(Request $request)
  650.     {
  652.         $parameters = json_decode($request->getContent(), true);
  654.         $action = (isset($parameters["action"])) ? $parameters["action"] : '';
  655.         $activityId = (isset($parameters["activityId"])) ? $parameters["activityId"] : '';
  656.         $activityName = (isset($parameters["activityName"])) ? $parameters["activityName"] : '';
  658.         $this->apiLogger->info(" --- START AGL SYNCING ---");
  659.         $this->apiLogger->info("action: " . $action);
  660.         $this->apiLogger->info("activityId: " . $activityId);
  661.         $this->apiLogger->info("activityName: " . $activityName);
  663.         $response = array();
  664.         $objEntityManager = $this->entityManager;
  666.         try {
  667.             if ($activityId != "" && $activityName != "") {
  668.                 if ($action === "edit") {
  669.                     #activity assignment...
  670.                     $aActivityAssignmentsRepository = $this->activityAssignmentsRepository
  671.                         ->findAll(array('activity_id' => $activityId));
  672.                     if (CommonUtility::countArray($aActivityAssignmentsRepository) > 0) {
  673.                         foreach ($aActivityAssignmentsRepository as $objActivityAssignmentsRepository) {
  674.                             $objActivityAssignmentsRepository->setActivityName($activityName);
  675.                             //updating activity assignment info....
  676.                             $objEntityManager->persist($objActivityAssignmentsRepository);
  677.                             $objEntityManager->flush();
  678.                         }
  679.                     }
  681.                     #activity define...
  682.                     $aActivityDefineCrewsRepository = $this->activityDefineCrewsRepository
  683.                         ->findAll(array('activity_id' => $activityId));
  684.                     if (CommonUtility::countArray($aActivityDefineCrewsRepository) > 0) {
  685.                         foreach ($aActivityDefineCrewsRepository as $objActivityDefineCrewsRepository) {
  686.                             $objActivityDefineCrewsRepository->setActivityName($activityName);
  687.                             //updating activity define info....
  688.                             $objEntityManager->persist($objActivityDefineCrewsRepository);
  689.                             $objEntityManager->flush();
  690.                         }
  691.                     }
  693.                     #activity define pair...
  694.                     $aActivityDefineCrewPairsRepository = $this->activityDefineCrewPairsRepository
  695.                         ->findAll(array('activity_id' => $activityId));
  696.                     if (CommonUtility::countArray($aActivityDefineCrewPairsRepository) > 0) {
  697.                         foreach ($aActivityDefineCrewPairsRepository as $objActivityDefineCrewPairsRepository) {
  698.                             $objActivityDefineCrewPairsRepository->setActivityName($activityName);
  699.                             //updating activity define pair info....
  700.                             $objEntityManager->persist($objActivityDefineCrewPairsRepository);
  701.                             $objEntityManager->flush();
  702.                         }
  703.                     }
  705.                     #account code activities...
  706.                     $aAccountCodeActivitiesRepository = $this->accountCodeActivitiesRepository
  707.                         ->findAll(array('activity_id' => $activityId));
  708.                     if (CommonUtility::countArray($aAccountCodeActivitiesRepository) > 0) {
  709.                         foreach ($aAccountCodeActivitiesRepository as $objAccountCodeActivitiesRepository) {
  710.                             $objAccountCodeActivitiesRepository->setActivityName($activityName);
  711.                             //updating account code activities info....
  712.                             $objEntityManager->persist($objAccountCodeActivitiesRepository);
  713.                             $objEntityManager->flush();
  714.                         }
  715.                     }
  717.                     $response = array(
  718.                         "success" => array(
  719.                             "message" => "Successfully Updated"
  720.                         )
  721.                     );
  722.                 } elseif ($action === "delete") {
  723.                 }
  724.             } else {
  725.                 $response = array(
  726.                     "error" => array(
  727.                         "message" => "NOT FOUND",
  728.                         "code" => 404
  729.                     )
  730.                 );
  731.             }
  732.         } catch (\Exception $e) {
  733.             $response = array(
  734.                 "error" => array(
  735.                     "message" => $e->getMessage(),
  736.                     "code" => $e->getCode()
  737.                 )
  738.             );
  739.         }
  741.         return $this->json($response);
  742.     }
  744.     /**
  745.      * @Route("/getSchoolOnlyActivityUsage", name="get_school_only_activity_usage", methods={"GET"})
  746.      * @param Request $request
  747.      * @return Response
  748.      */
  749.     public function getSchoolOnlyActivityUsage(Request $request)
  750.     {
  752.         $conference_id = $request->query->get('conference_id');
  753.         $activity_id = $request->query->get('activity_id');
  755.         try {
  756.             $data = $this->activityDefineCrewsRepository->findByFilters(array(
  757.                 'checkSOActivities' => true,
  758.                 'conference_id' => $conference_id,
  759.                 'activity_id' => $activity_id
  760.             ));
  762.             if (CommonUtility::countArray($data) > 0) {
  763.                 $response = $data;
  764.             } else {
  765.                 $response = array(
  766.                     "data" => null,
  767.                     "meta" => null,
  768.                     "links" => null,
  769.                     "code" => 404,
  770.                     "message" => "data not found",
  771.                     "status" => "NOT_FOUND",
  772.                     "result" => null
  773.                 );
  774.             }
  775.         } catch (\Exception $e) {
  776.             $response = array(
  777.                 "error" => array(
  778.                     "message" => $e->getMessage(),
  779.                     "code" => $e->getCode()
  780.                 )
  781.             );
  782.         }
  785.         return $this->json($response);
  786.     }
  788.     /**
  789.      * @Route("/get-worker-info-by-event", name="get_worker_info_by_event", methods={"POST"})
  790.      * @param Request $request
  791.      * @return Response
  792.      */
  793.     public function getWorkerInfoByEvent(Request $request)
  794.     {
  795.         $parameters = json_decode($request->getContent(), true);
  796.         $eventIds = (isset($parameters["eventIds"])) ? $parameters["eventIds"] : array();
  797.         $conference_id = (isset($parameters["conference_id"])) ? $parameters["conference_id"] : '';
  800.         if (count($eventIds) > 0 && isset($conference_id)) {
  801.             $workerInfos = $this->activityAssignmentsRepository->getWorkerInfoPerEvent(array(
  802.                 'event_ids' => $eventIds,
  803.                 'conference_id' => $conference_id
  804.             ));
  806.             if (count($workerInfos) > 0) {
  807.                 $response = array(
  808.                     "success" => array(
  809.                         "data" => $workerInfos,
  810.                         "message" => "Worker Info Successfully Fetched!",
  811.                         "code" => 200
  812.                     )
  813.                 );
  814.             } else {
  815.                 $response = array(
  816.                     "error" => array(
  817.                         "event_ids" => $eventIds,
  818.                         "message" => "No Event IDs found",
  819.                         "code" => 404
  820.                     )
  821.                 );
  822.             }
  823.         } else {
  824.             $response = array(
  825.                 "error" => array(
  826.                     "message" => "DATA NOT FOUND",
  827.                     "payload_required" => 'eventIds, conference_id',
  828.                     "code" => 404
  829.                 )
  830.             );
  831.         }
  833.         return $this->json($response);
  834.     }
  835. }