src/Controller/GuardianRegister/GuardianRegisterAdminController.php line 471

Open in your IDE?
  1. <?php
  3. namespace App\Controller\GuardianRegister;
  5. use App\Entity\Child;
  6. use App\Entity\ChildPreference;
  7. use App\Entity\Guardian;
  8. use App\Entity\Guardian\GuardianPriceDiscount;
  9. use App\Entity\GuardianRegister\GuardianRegister;
  10. use App\Entity\GuardianRegister\GuardianRegisterChild;
  11. use App\Entity\GuardianRegister\GuardianRegisterChildPreference;
  12. use App\Entity\Lesson;
  14. use App\Form\GuardianRegister\GuardianRegisterRawType;
  15. use App\Form\GuardianRegister\GuardianRegisterType;
  16. use App\Message\AssignChildPreferenceTeacherMessage;
  17. use App\Message\SendMailMessage;
  18. use App\Message\SendSMSMessage;
  19. use App\Repository\AdminRepository;
  20. use App\Repository\ChildRepository;
  21. use App\Repository\ConfigurationRepository;
  22. use App\Repository\Guardian\GuardianContractPriceClassAmountPriceRepository;
  23. use App\Repository\GuardianRegister\GuardianRegisterRepository;
  24. use App\Repository\GuardianRepository;
  25. use App\Repository\PaymentRepository;
  26. use App\Repository\ReminderConfigurationRepository;
  27. use App\Service\ChildPreferenceService;
  28. use App\Service\CredentialsService;
  29. use App\Service\GuardianRegisterDuplicateReconciliationService;
  30. use App\Service\OmnisendService;
  31. use App\Service\SmsService;
  32. use App\Utils\HelperUtils;
  33. use App\Utils\RestUtils;
  34. use Doctrine\ORM\EntityManagerInterface;
  35. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  36. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  37. use Symfony\Component\HttpFoundation\JsonResponse;
  38. use Symfony\Component\HttpFoundation\Request;
  39. use Symfony\Component\HttpFoundation\Response;
  40. use Symfony\Component\Messenger\Envelope;
  41. use Symfony\Component\Messenger\MessageBusInterface;
  42. use Symfony\Component\Messenger\Stamp\DelayStamp;
  43. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  44. use Symfony\Component\Routing\Annotation\Route;
  45. use Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface;
  46. use Symfony\Component\Serializer\Normalizer\AbstractNormalizer;
  48. /**
  49. * @Route("/guardian_register")
  50. */
  51. class GuardianRegisterAdminController extends AbstractController
  52. {
  53. private SmsService $smsService;
  54. private EntityManagerInterface $entityManager;
  55. private ReminderConfigurationRepository $reminderConfigurationRepository;
  56. private GuardianRegisterRepository $guardianRegisterRepository;
  57. private ConfigurationRepository $configurationRepository;
  58. private UserPasswordEncoderInterface $passwordEncoder;
  59. private GuardianRepository $guardianRepository;
  60. private ChildRepository $childRepository;
  61. private GuardianContractPriceClassAmountPriceRepository $guardianContractPriceClassAmountPriceRepository;
  62. private CredentialsService $credentialsService;
  63. private MessageBusInterface $messageBus;
  64. private ChildPreferenceService $childPreferenceService;
  65. private UserPasswordHasherInterface $userPasswordHasher;
  66. private OmnisendService $omnisendService;
  67. private GuardianRegisterDuplicateReconciliationService $guardianRegisterDuplicateReconciliationService;
  69. public function __construct(
  70. UserPasswordEncoderInterface $passwordEncoder,
  71. GuardianRepository $guardianRepository,
  72. ChildRepository $childRepository,
  73. SmsService $smsService,
  74. EntityManagerInterface $entityManager,
  75. ConfigurationRepository $configurationRepository,
  76. GuardianRegisterRepository $guardianRegisterRepository,
  77. ReminderConfigurationRepository $reminderConfigurationRepository,
  78. GuardianContractPriceClassAmountPriceRepository $guardianContractPriceClassAmountPriceRepository,
  79. CredentialsService $credentialsService,
  80. MessageBusInterface $messageBus,
  81. ChildPreferenceService $childPreferenceService,
  82. UserPasswordHasherInterface $userPasswordHasher,
  83. OmnisendService $omnisendService,
  84. GuardianRegisterDuplicateReconciliationService $guardianRegisterDuplicateReconciliationService
  85. ) {
  86. $this->smsService = $smsService;
  87. $this->entityManager = $entityManager;
  88. $this->reminderConfigurationRepository = $reminderConfigurationRepository;
  89. $this->guardianRegisterRepository = $guardianRegisterRepository;
  90. $this->configurationRepository = $configurationRepository;
  91. $this->passwordEncoder = $passwordEncoder;
  92. $this->guardianRepository = $guardianRepository;
  93. $this->childRepository = $childRepository;
  94. $this->guardianContractPriceClassAmountPriceRepository = $guardianContractPriceClassAmountPriceRepository;
  95. $this->credentialsService = $credentialsService;
  96. $this->messageBus = $messageBus;
  97. $this->childPreferenceService = $childPreferenceService;
  98. $this->userPasswordHasher = $userPasswordHasher;
  99. $this->omnisendService = $omnisendService;
  100. $this->guardianRegisterDuplicateReconciliationService = $guardianRegisterDuplicateReconciliationService;
  101. }
  103. /**
  104. * @Route("/guardian-google-conversion_csv.csv", name="guardian_google_conversion_csv", methods={"GET", "POST"})
  105. */
  106. public function guardian_google_conversion_csv(Request $request, GuardianRegisterRepository $guardianRegisterRepository, PaymentRepository $paymentRepository): Response
  107. {
  109. // ===============================
  110. // BASIC AUTH CONFIGURATION
  111. // ===============================
  112. $username = 'corepetitus_google_conversion_csv';
  113. $password = 'vTvCzW7eBTT40rVxTkgKmHN3vUtctyJ8';
  115. // ===============================
  116. // AUTH CHECK
  117. // ===============================
  118. if (!isset($_SERVER['PHP_AUTH_USER'])) {
  119. header('WWW-Authenticate: Basic realm="Protected CSV"');
  120. header('HTTP/1.0 401 Unauthorized');
  121. echo "Authentication required.";
  122. exit;
  123. } else {
  124. if ($_SERVER['PHP_AUTH_USER'] !== $username || $_SERVER['PHP_AUTH_PW'] !== $password) {
  125. header('WWW-Authenticate: Basic realm="Protected CSV"');
  126. header('HTTP/1.0 401 Unauthorized');
  127. echo "Invalid credentials.";
  128. exit;
  129. }
  130. }
  132. // if($request->query->get('token') != '9sd1f8sdf18af8ergftgh1e58hrsegawfgs1h8as8gf1asdf')
  133. // {
  134. // die();
  135. // }
  136. //Email,Phone Number,Google Click ID,Conversion Name,Conversion Time,Conversion Value,Conversion Currency
  137. // $f = fopen('php://memory', 'w');
  138. header('Content-Type: text/csv');
  139. header('Content-Disposition: attachment; filename="google_ads.csv"');
  140. $f = fopen('php://output', 'w');
  142. // $data = [0=>'Parameters:TimeZone=Europe/Vilnius'];
  143. // fputcsv($f, $data, ';');
  145. fputcsv($f, [
  146. 'Email',
  147. 'Phone Number',
  148. 'Google Click ID',
  149. 'Conversion Name',
  150. 'Conversion Time',
  151. 'Conversion Value',
  152. 'Conversion Currency',
  153. 'Ad User Data',
  154. 'Ad Personalization',
  155. ], ',');
  157. $dateFrom = new \DateTime();
  158. $dateFrom->setTime(8,50,0);
  159. $dateFrom->modify('-1 days');
  161. $dateTo = new \DateTime();
  162. $dateTo->setTime(9,10,0);
  164. $guardianRegistrations = $guardianRegisterRepository
  165. ->createQueryBuilder('gr')
  166. ->leftJoin('gr.guardian', 'g')
  167. ->andWhere('g.status = :status')
  168. ->setParameter('status', Guardian::STATUS_CONFIRMED['value'])
  169. ->andWhere('gr.contractSignedAt >= :dateFrom')
  170. ->andWhere('gr.contractSignedAt <= :dateto')
  171. ->setParameter('dateFrom', $dateFrom)
  172. ->setParameter('dateto', $dateTo)
  173. ->getQuery()
  174. ->getResult();
  176. //vakar 8.50 ir siandien 9.10
  177. foreach ($guardianRegistrations as $guardianRegister) {
  179. $guardian = $guardianRegister->getGuardian();
  181. if (strlen($guardianRegister->getLandingPage())) {
  182. $parts = parse_url($guardianRegister->getLandingPage());
  183. parse_str($parts['query'] ?? '', $params);
  184. $gclid = $params['gclid'] ?? '';
  185. }
  186. else
  187. {
  188. $gclid = '';
  189. }
  191. $payment = $paymentRepository->createQueryBuilder('p')
  192. ->andWhere('p.guardian = :guardian')
  193. ->setParameter('guardian', $guardian)
  194. ->setMaxResults(1)
  195. ->getQuery()
  196. ->getOneOrNullResult();
  199. $amount = 10;
  200. if($payment)
  201. {
  202. $amount = $payment->getAmount();
  203. }
  205. if ($amount < 0) {
  206. continue;
  207. }
  209. $data = [
  210. 0 => $guardian->getEmail(),
  211. 1 => $guardian->getPhoneNumber(),
  212. 2 => $gclid,
  213. 3 => "TSM ACTUAL BUYERS 2025.10 offline (Upload)",
  214. 4 => $guardianRegister->getContractSignedAt()->format('Y-m-d H:i:s'),
  215. 5 => $amount,
  216. 6 => "EUR",
  217. 7 => "Granted",
  218. 8 => "Granted",
  219. ];
  220. fputcsv($f, $data, ',');
  221. }
  222. fclose($f);
  223. // fseek($f, 0);
  224. // header('Content-Encoding: UTF-8');
  225. // header('Content-Type: text/csv; charset=UTF-8');
  226. // header('Content-Disposition: attachment; filename="guardian_google_conversion_csv.csv";');
  227. // echo "\xEF\xBB\xBF"; // UTF-8 BOM
  228. // fpassthru($f);
  230. exit();
  231. }
  233. /**
  234. * @Route("/ajax/check", name="guardian_registrations_dupe_check", methods={"GET", "POST"})
  235. * @Security("is_granted('ROLE_ADMIN')")
  236. */
  237. public function dupe_check(Request $request, GuardianRegisterRepository $guardianRegisterRepository): Response
  238. {
  239. $email = $request->get('email');
  240. $phone = $request->get('phone');
  241. $guardianRegisterRep = $guardianRegisterRepository->createQueryBuilder('g');
  242. if($email)
  243. {
  244. $guardianRegisterRep->andWhere('(g.email = :email or g.guardianEmail = :email)');
  245. $guardianRegisterRep->setParameter('email', $email);
  246. }
  247. if($phone)
  248. {
  249. $guardianRegisterRep->andWhere('(g.phone = :phone or g.guardianPhone = :phone)');
  250. $guardianRegisterRep->setParameter('phone', $phone);
  251. }
  252. $result = $guardianRegisterRep->getQuery()->getResult();
  254. $normalized = $this->get('serializer')->normalize($result, null, ['groups' => 'GuardianRegisterList']);
  256. return new JsonResponse($normalized);
  257. }
  259. /**
  260. * @Route("/recheck", name="guardian_registrations_recheck", methods={"GET", "POST"})
  261. * @Security("is_granted('ROLE_ADMIN')")
  262. */
  263. public function recheck(Request $request, GuardianRegisterRepository $guardianRegisterRepository): Response
  264. {
  265. $registrations = $guardianRegisterRepository->findBy(['status' => GuardianRegister::STATUS_CONFIRMED['value'], 'guardian' => null]);
  267. dump($registrations);
  268. die();
  270. foreach ($registrations as $guardianRegister) {
  271. $plainPassword = $this->createRandomPassword();
  272. $this->convertRegisterToGuardian($guardianRegister, $plainPassword);
  273. $this->sendSignedEmail($guardianRegister, $plainPassword);
  274. }
  276. exit();
  277. }
  279. /**
  280. * @Route("/registrations", name="guardian_registrations_index", methods={"GET", "POST"})
  281. * @Security("is_granted('ROLE_ADMIN')")
  282. */
  283. public function applications(Request $request, AdminRepository $adminRepository): Response
  284. {
  285. $admins = $adminRepository->findAll();
  286. $adminsToFront = [];
  287. $adminsToFront['Visi'] = ['Visi'];
  288. foreach ($admins as $admin) {
  289. if (in_array($admin->getId(), [2, 3, 5])) {
  290. continue;
  291. }
  292. if (in_array('ROLE_SALES', $admin->getRoles())) {
  293. $adminsToFront[$admin->getFullname()] = $admin->getFullname();
  294. }
  295. if (15 == $admin->getId()) {
  296. $adminsToFront[$admin->getFullname()] = $admin->getFullname();
  297. }
  298. }
  299. return $this->render('guardian_register/admin/list.html.twig', [
  300. 'adminsToFront' => $adminsToFront
  301. ]);
  302. }
  304. /**
  305. * @Route("/ajax", name="guardian_registrations_ajax", methods={"POST"})
  306. * @Security("is_granted('ROLE_ADMIN') and is_granted('IS_AUTHENTICATED_FULLY')")
  307. */
  308. public function ajax(Request $request, GuardianRegisterRepository $guardianRegisterRepository): Response
  309. {
  310. $objectRepository = $guardianRegisterRepository;
  311. $page = $request->request->get('page');
  312. $perPage = $request->request->get('perPage');
  313. $page = ($page && $page > 1) ? $page : 1;
  314. $perPage = ($perPage && $perPage > 0) ? $perPage : 10; // should change in the future
  315. $searchFilters = $request->request->get('filters', []);
  316. $sorters = $request->request->get('sorters', []);
  317. $query = $objectRepository->createQueryBuilder('a');
  320. $query->andWhere("a.status <> :ignoreStatusC")
  321. ->setParameter("ignoreStatusC", GuardianRegister::STATUS_CONFIRMED['value']);
  324. $query->andWhere("a.guardian IS NULL OR a.status IN (:earlyPaymentStatuses)")
  325. ->setParameter("earlyPaymentStatuses", [
  326. GuardianRegister::STATUS_WAITING['value'],
  327. GuardianRegister::STATUS_LOST_48['value'],
  328. GuardianRegister::STATUS_PAID_FIRST['value'],
  329. GuardianRegister::STATUS_NOT_PAID['value'],
  330. GuardianRegister::STATUS_NOT_PAID_48['value'],
  331. GuardianRegister::STATUS_LEFT_EARLY_PAYMENT['value'],
  332. ]);
  334. if (!$searchFilters || (count($searchFilters) == 1 && $searchFilters[0]['field'] == 'salesPerson.fullname')) {
  335. $query->andWhere("a.status <> :ignoreStatus")
  336. ->setParameter("ignoreStatus", GuardianRegister::STATUS_LOST['value']);
  337. $query->andWhere("a.status <> :ignoreStatus2")
  338. ->setParameter("ignoreStatus2", GuardianRegister::STATUS_UNTARGETED['value']);
  339. }
  341. $salesPersonSelected = false;
  342. $statusFilterIsLeftEarlyPayment = false;
  343. foreach ($searchFilters as $filter) {
  344. if ($filter['field'] == 'salesPerson.fullname' && !empty($filter['value']) && $filter['value'] != 'Visi') {
  345. $salesPersonSelected = true;
  346. }
  347. if ($filter['field'] == 'status' && ($filter['value'] ?? null) == GuardianRegister::STATUS_LEFT_EARLY_PAYMENT['value']) {
  348. $statusFilterIsLeftEarlyPayment = true;
  349. }
  350. }
  352. if ($salesPersonSelected && !$statusFilterIsLeftEarlyPayment) {
  353. $query->andWhere("a.status <> :ignoreStatusLeftEarlyPayment")
  354. ->setParameter("ignoreStatusLeftEarlyPayment", GuardianRegister::STATUS_LEFT_EARLY_PAYMENT['value']);
  355. }
  357. if ($searchFilters) {
  358. foreach ($searchFilters as $filter) {
  359. if (isset($filter['value'])) {
  360. if ($filter['value'] == 'Visi') {
  361. continue;
  362. }
  363. $relation = explode('.', $filter['field']);
  365. if (count($relation) == 1) {
  366. $searchValue = (is_string($filter['value']) ? $filter['value'] : reset($filter['value']));
  367. if ($filter['type'] == "like") {
  368. $query->andWhere("a.{$filter['field']} {$filter['type']} :{$filter['field']}")
  369. ->setParameter("{$filter['field']}", "%{$searchValue}%");
  370. if ($filter['field'] == 'email') {
  371. $query->orWhere("a.guardianEmail {$filter['type']} :{$filter['field']}");
  372. }
  373. if ($filter['field'] == 'phone') {
  374. $query->orWhere("a.guardianPhone {$filter['type']} :{$filter['field']}");
  375. }
  376. } else {
  377. $query->andWhere("a.{$filter['field']} {$filter['type']} :{$filter['field']}")
  378. ->setParameter("{$filter['field']}", "{$searchValue}");
  379. }
  380. } elseif (count($relation) == 2) {
  381. $searchValue = (is_string($filter['value']) ? $filter['value'] : reset($filter['value']));
  383. $field = $relation[1];
  384. $relation = $relation[0];
  386. if ($filter['type'] == "like") {
  387. $query
  388. ->leftJoin("a." . $relation, $relation)
  389. ->andWhere("{$relation}.{$field} {$filter['type']} :{$field}")
  390. ->setParameter("{$field}", "%{$searchValue}%");
  391. } else {
  392. $query
  393. ->leftJoin("a." . $relation, $relation)
  394. ->andWhere("{$relation}.{$field} {$filter['type']} :{$field}")
  395. ->setParameter("{$field}", "{$searchValue}");
  396. }
  397. }
  398. }
  399. }
  400. }
  401. if ($sorters) {
  402. foreach ($sorters as $sorter) {
  403. $query->addOrderBy('a.' . $sorter['field'], $sorter['dir']);
  404. }
  405. }
  406. $count = RestUtils::getQueryCount(clone $query);
  407. $pagesCount = ceil($count / $perPage);
  408. $guardianRegistrations = $this->get('serializer')->normalize(RestUtils::getPaginatedResults($query->getQuery(), $page, $perPage), null, ['groups' => "GuardianRegisterList"]);
  409. foreach ($guardianRegistrations as $key => $guardianRegistration) {
  410. $guardianRegistrations[$key]['guardian_name'] = $guardianRegistration['isGuardian'] ? $guardianRegistration['name'] : $guardianRegistration['guardianName'];
  411. $guardianRegistrations[$key]['email'] = $guardianRegistration['isGuardian'] ? $guardianRegistrations[$key]['email'] : $guardianRegistration['guardianEmail'];
  412. $guardianRegistrations[$key]['phone'] = $guardianRegistration['isGuardian'] ? $guardianRegistrations[$key]['phone'] : $guardianRegistration['guardianPhone'];
  413. $guardianRegistrations[$key]['isGuardian'] = $guardianRegistration['isGuardian'] ? 'TEV' : 'MOK';
  414. }
  415. return new JsonResponse([
  416. "last_page" => $pagesCount,
  417. "data" => $guardianRegistrations
  418. ]);
  419. }
  421. /**
  422. * @Route("/new", name="guardian_register_new", methods={"GET","POST"})
  423. * @Security("is_granted('ROLE_ADMIN') and is_granted('IS_AUTHENTICATED_FULLY')")
  424. */
  425. public function new(Request $request): Response
  426. {
  427. $guardianRegister = new GuardianRegister();
  429. $childName = 'Vardas1';
  430. if (!$guardianRegister->getGuardianRegisterChildren()->count()) {
  431. $guardianRegisterChild = new GuardianRegisterChild();
  432. $guardianRegisterChild->setName($childName);
  433. $guardianRegisterChild->setClass(8);
  434. $guardianRegisterChild->setGuardianRegister($guardianRegister);
  435. $guardianRegisterChildPreference = new GuardianRegisterChildPreference();
  436. $guardianRegisterChildPreference->setDuration(60);
  437. $guardianRegisterChildPreference->setAmount(2);
  438. $guardianRegisterChildPreference->setGuardianRegisterChild($guardianRegisterChild);
  439. $guardianRegisterChild->addGuardianRegisterChildPreference($guardianRegisterChildPreference);
  440. $guardianRegister->addGuardianRegisterChild($guardianRegisterChild);
  441. }
  443. $DEFAULT_GUARDIAN_PRICE_CHANGE = $this->configurationRepository->findOneBy(['name' => 'DEFAULT_GUARDIAN_PRICE_CHANGE'])->getValue();
  444. $guardianRegister->setPriceChange($DEFAULT_GUARDIAN_PRICE_CHANGE);
  445. $guardianRegister->setSalesPerson($this->getUser());
  447. if (!$guardianRegister->getSalesAssignedAt()) {
  448. $guardianRegister->setSalesAssignedAt(new \DateTime());
  449. }
  451. $form = $this->createForm(GuardianRegisterType::class, $guardianRegister);
  452. $form->handleRequest($request);
  454. if ($form->isSubmitted() && $form->isValid()) {
  455. foreach ($guardianRegister->getGuardianRegisterChildren() as $guardianRegisterChild) {
  456. foreach ($guardianRegisterChild->getGuardianRegisterChildPreferences() as $guardianRegisterChildPreference) {
  457. $guardianRegisterChildPreference->setGuardianRegisterChild($guardianRegisterChild);
  458. $this->entityManager->persist($guardianRegisterChildPreference);
  459. }
  460. $guardianRegisterChild->setGuardianRegister($guardianRegister);
  461. $this->entityManager->persist($guardianRegisterChild);
  462. }
  464. $this->handleStatusChange($guardianRegister, '');
  465. $this->entityManager->persist($guardianRegister);
  466. $this->entityManager->flush();
  467. $this->sendSuccessEmail($guardianRegister);
  468. return $this->redirectToRoute('guardian_registrations_index');
  469. }
  471. return $this->renderForm('guardian_register/admin/new.html.twig', [
  472. 'form' => $form,
  473. 'raw' => false,
  474. 'returningChildMatches' => $this->resolveReturningChildMatches($guardianRegister)
  475. ]);
  476. }
  478. /**
  479. * @Route("/ajax/{id}/edit", name="guardian_register_ajax_edit", methods={"POST"})
  480. * @Security("is_granted('ROLE_ADMIN') and is_granted('IS_AUTHENTICATED_FULLY')")
  481. */
  482. public function ajaxEdit(GuardianRegister $guardianRegister, Request $request): Response
  483. {
  484. if (!$guardianRegister) {
  485. $error = new JsonResponse();
  486. $error
  487. ->setStatusCode(Response::HTTP_NOT_FOUND)
  488. ->setData(['status' => "error"]);
  489. return $error;
  490. }
  492. $data = json_decode($request->getContent(), true);
  494. if (isset($data['status'])) {
  495. if (!$guardianRegister->getEmail() || $guardianRegister->getEmail() == "") {
  496. return new JsonResponse(['status' => "Vartotojas neturi elektroninio pasto"], Response::HTTP_BAD_REQUEST);
  497. }
  498. }
  500. $oldStatus = $guardianRegister->getStatus();
  502. $guardianRegister = $this->get('serializer')->deserialize($request->getContent(), GuardianRegister::class, 'json', [
  503. AbstractNormalizer::OBJECT_TO_POPULATE => $guardianRegister
  504. ]);
  505. $this->handleStatusChange($guardianRegister, $oldStatus);
  506. $this->entityManager->persist($guardianRegister);
  507. $this->entityManager->flush();
  509. return new JsonResponse(['status' => "OK"], Response::HTTP_OK);
  510. }
  512. /**
  513. * @Route("/setSales", name="guardian_register_set_sales", methods={"GET"})
  514. * @Security("is_granted('ROLE_ADMIN') and is_granted('IS_AUTHENTICATED_FULLY')")
  515. */
  516. public function setSales(Request $request, GuardianRegisterRepository $guardianRegisterRepository): Response
  517. {
  518. $ids = $request->query->get('Ids');
  519. $ids = explode(',', $ids);
  521. $currentUser = $this->getUser();
  522. foreach ($ids as $id) {
  523. $guardianRegister = $guardianRegisterRepository->find($id);
  524. if (!$guardianRegister->getSalesPerson()) {
  525. $guardianRegister->setSalesPerson($currentUser);
  526. if (!$guardianRegister->getSalesAssignedAt()) {
  527. $guardianRegister->setSalesAssignedAt(new \DateTime());
  528. }
  530. $this->entityManager->persist($guardianRegister);
  531. $this->entityManager->flush();
  532. }
  533. }
  535. return new JsonResponse();
  536. }
  538. /**
  539. * @Route("/{id}/edit", name="guardian_register_edit", methods={"GET","POST"})
  540. * @Security("is_granted('ROLE_ADMIN') and is_granted('IS_AUTHENTICATED_FULLY')")
  541. */
  542. public function edit(Request $request, GuardianRegister $guardianRegister, GuardianRegisterRepository $guardianRegisterRepository): Response
  543. {
  544. // if($guardianRegister->getSalesPerson() && $guardianRegister->getSalesPerson() != $this->getUser())
  545. // {
  546. // exit("Šią registraciją redaguoti gali tik {$this->getUser()->getFullname()}");
  547. // }
  549. // $date = new \DateTime();
  550. // dump("1. {$date->format('Y-m-d H:i:s')}");
  551. $childName = 'Vardas1';
  552. if (!$guardianRegister->getIsGuardian()) {
  553. $childName = "{$guardianRegister->getName()} {$guardianRegister->getLastname()}";
  554. }
  555. if (!$guardianRegister->getGuardianRegisterChildren()->count()) {
  556. $guardianRegisterChild = new GuardianRegisterChild();
  557. $guardianRegisterChild->setName($childName);
  558. $guardianRegisterChild->setClass(8);
  559. $guardianRegisterChild->setGuardianRegister($guardianRegister);
  560. $guardianRegisterChildPreference = new GuardianRegisterChildPreference();
  561. $guardianRegisterChildPreference->setDuration(60);
  562. $guardianRegisterChildPreference->setAmount(2);
  563. $guardianRegisterChildPreference->setGuardianRegisterChild($guardianRegisterChild);
  564. $guardianRegisterChild->addGuardianRegisterChildPreference($guardianRegisterChildPreference);
  565. $guardianRegister->addGuardianRegisterChild($guardianRegisterChild);
  566. }
  568. foreach ($guardianRegister->getGuardianRegisterChildren() as $guardianRegisterChild) {
  569. if(!$guardianRegisterChild->getGuardianRegisterChildPreferences()->count())
  570. {
  571. $guardianRegisterChildPreference = new GuardianRegisterChildPreference();
  572. $guardianRegisterChildPreference->setDuration(60);
  573. $guardianRegisterChildPreference->setAmount(2);
  574. $guardianRegisterChildPreference->setGuardianRegisterChild($guardianRegisterChild);
  575. $guardianRegisterChild->addGuardianRegisterChildPreference($guardianRegisterChildPreference);
  576. $guardianRegister->addGuardianRegisterChild($guardianRegisterChild);
  577. }
  578. }
  579. $form = $this->createForm(GuardianRegisterType::class, $guardianRegister);
  580. $oldStatus = $guardianRegister->getStatus();
  582. $originalGuardianRegisterChildren = $guardianRegister->getGuardianRegisterChildren()->getValues();
  583. $originalGuardianRegisterChildrenPreferences = [];
  585. foreach ($guardianRegister->getGuardianRegisterChildren() as $guardianRegisterChild) {
  586. $originalGuardianRegisterChildrenPreferences = array_merge($originalGuardianRegisterChildrenPreferences, $guardianRegisterChild->getGuardianRegisterChildPreferences()->getValues());
  587. }
  590. $form->handleRequest($request);
  592. if ($form->isSubmitted() && $form->isValid()) {
  594. // $date = new \DateTime();
  595. // dump("1. {$date->format('Y-m-d H:i:s')}");
  596. //remove
  597. foreach ($originalGuardianRegisterChildrenPreferences as $originalGuardianRegisterChildrenPreference) {
  598. $delete = true;
  599. foreach ($guardianRegister->getGuardianRegisterChildren() as $guardianRegisterChild) {
  600. if ($guardianRegisterChild->getGuardianRegisterChildPreferences()->contains($originalGuardianRegisterChildrenPreference)) {
  601. $delete = false;
  602. }
  603. }
  604. if ($delete) {
  605. $this->entityManager->remove($originalGuardianRegisterChildrenPreference);
  606. }
  607. }
  608. // $date = new \DateTime();
  609. // dump("2. {$date->format('Y-m-d H:i:s')}");
  610. foreach ($originalGuardianRegisterChildren as $originalGuardianRegisterChild) {
  611. if (!$guardianRegister->getGuardianRegisterChildren()->contains($originalGuardianRegisterChild)) {
  612. $this->entityManager->remove($originalGuardianRegisterChild);
  613. }
  614. }
  615. //add
  616. foreach ($guardianRegister->getGuardianRegisterChildren() as $guardianRegisterChild) {
  617. foreach ($guardianRegisterChild->getGuardianRegisterChildPreferences() as $guardianRegisterChildPreference) {
  618. $guardianRegisterChildPreference->setGuardianRegisterChild($guardianRegisterChild);
  619. $this->entityManager->persist($guardianRegisterChildPreference);
  620. }
  621. $guardianRegisterChild->setGuardianRegister($guardianRegister);
  622. $this->entityManager->persist($guardianRegisterChild);
  623. }
  624. // $date = new \DateTime();
  625. // dump("3. {$date->format('Y-m-d H:i:s')}");
  626. $this->handleStatusChange($guardianRegister, $oldStatus);
  627. // $date = new \DateTime();
  628. // dump("5. {$date->format('Y-m-d H:i:s')}");
  629. $this->entityManager->persist($guardianRegister);
  630. $this->entityManager->flush();
  631. // $date = new \DateTime();
  632. // dump("6. {$date->format('Y-m-d H:i:s')}");
  633. // $date = new \DateTime();
  634. // dump("3. {$date->format('Y-m-d H:i:s')}");
  635. if ($form->has('change')) {
  636. $changeClicked = $form->get('change')->isClicked();
  637. } else {
  638. $changeClicked = false;
  639. }
  640. if ($changeClicked && $guardianRegister->getCurrentGuardianFoundBy()) {
  641. if ($guardian = $this->guardianRepository->findOneBy(['email' => $guardianRegister->getEmail()])) {
  642. $guardian->setEmail($guardian->getEmail() . 'BACK');
  643. }
  645. $phoneToSearch = $guardianRegister->getPhone();
  646. if ($phoneToSearch && strlen($phoneToSearch) > 6) {
  647. $phoneToSearch = str_replace('+3706', '', $phoneToSearch);
  649. $query = $this->guardianRepository->createQueryBuilder('g');
  650. $guardians = $query->andWhere('g.phoneNumber like :phone')
  651. ->setParameter('phone', "%{$phoneToSearch}%")
  652. ->getQuery()
  653. ->getResult();
  654. foreach ($guardians as $guardian) {
  655. $guardian->setPhoneNumber($guardian->getPhoneNumber() . 'BACK');
  656. $this->entityManager->persist($guardian);
  657. $this->entityManager->flush();
  658. }
  660. $query = $this->childRepository->createQueryBuilder('g');
  661. /**
  662. * @var $child Child
  663. */
  664. $children = $query->andWhere('g.phoneNumber like :phone')
  665. ->setParameter('phone', "%{$phoneToSearch}%")
  666. ->getQuery()
  667. ->getResult();
  668. foreach ($children as $child) {
  669. $child->setPhoneNumber($child->getPhoneNumber() . 'BACK');
  670. $this->entityManager->persist($child);
  671. $this->entityManager->flush();
  672. }
  673. }
  675. $phone = $guardianRegister->getGuardianPhone();
  676. if ($phone && strlen($phone) > 6) {
  677. $phoneToSearch = $phone;
  678. $phoneToSearch = str_replace('+3706', '', $phoneToSearch);
  679. $phoneToSearch = str_replace('3706', '', $phoneToSearch);
  680. $pattern = '/^86/i';
  681. $phoneToSearch = preg_replace($pattern, '', $phoneToSearch);
  683. $query = $this->guardianRepository->createQueryBuilder('g');
  684. $guardians = $query->andWhere('g.phoneNumber like :phone')
  685. ->setParameter('phone', "%{$phoneToSearch}%")
  686. ->getQuery()
  687. ->getResult();
  688. foreach ($guardians as $guardian) {
  689. $guardian->setPhoneNumber($guardian->getPhoneNumber() . 'BACK');
  690. $this->entityManager->persist($guardian);
  691. $this->entityManager->flush();
  692. }
  694. $query = $this->childRepository->createQueryBuilder('g');
  695. $children = $query->andWhere('g.phoneNumber like :phone')
  696. ->setParameter('phone', "%{$phoneToSearch}%")
  697. ->getQuery()
  698. ->getResult();
  699. foreach ($children as $child) {
  700. $child->setPhoneNumber($child->getPhoneNumber() . 'BACK');
  701. $this->entityManager->persist($child);
  702. $this->entityManager->flush();
  703. }
  704. }
  705. }
  708. $foundByEmail = false;
  709. $foundByPhone = false;
  710. if ($this->guardianRepository->findOneBy(['email' => $guardianRegister->getEmail()])) {
  711. $foundByEmail = true;
  712. }
  714. if ($guardianRegister->getGuardianEmail() && $this->guardianRepository->findOneBy(['email' => $guardianRegister->getGuardianEmail()])) {
  715. $foundByEmail = true;
  716. }
  718. $phoneToSearch = $guardianRegister->getPhone();
  719. $phoneToSearch = str_replace('+3706', '', $phoneToSearch);
  720. if ($phoneToSearch && strlen($phoneToSearch) > 6) {
  721. $query = $this->guardianRepository->createQueryBuilder('g');
  722. $result = $query->andWhere('g.phoneNumber like :phone')
  723. ->setParameter('phone', "%{$phoneToSearch}%")
  724. ->getQuery()
  725. ->getResult();
  726. if ($result) {
  727. $foundByPhone = true;
  728. }
  731. $query = $this->childRepository->createQueryBuilder('g');
  732. $result = $query->andWhere('g.phoneNumber like :phone')
  733. ->setParameter('phone', "%{$phoneToSearch}%")
  734. ->getQuery()
  735. ->getResult();
  736. if ($result) {
  737. $foundByPhone = true;
  738. }
  739. }
  741. $phone = $guardianRegister->getGuardianPhone();
  743. if ($phone && strlen($phone) > 6) {
  744. $phoneToSearch = $phone;
  745. $phoneToSearch = str_replace('+3706', '', $phoneToSearch);
  746. $phoneToSearch = str_replace('3706', '', $phoneToSearch);
  747. $pattern = '/^86/i';
  748. $phoneToSearch = preg_replace($pattern, '', $phoneToSearch);
  750. $query = $this->guardianRepository->createQueryBuilder('g');
  751. $result = $query->andWhere('g.phoneNumber like :phone')
  752. ->setParameter('phone', "%{$phoneToSearch}%")
  753. ->getQuery()
  754. ->getResult();
  755. if ($result) {
  756. $foundByPhone = true;
  757. }
  759. $query = $this->childRepository->createQueryBuilder('g');
  760. $result = $query->andWhere('g.phoneNumber like :phone')
  761. ->setParameter('phone', "%{$phoneToSearch}%")
  762. ->getQuery()
  763. ->getResult();
  764. if ($result) {
  765. $foundByPhone = true;
  766. }
  767. }
  769. if ($foundByEmail && !$foundByPhone) {
  770. $guardianRegister->setCurrentGuardianFoundBy('EMAIL');
  771. }
  773. if (!$foundByEmail && $foundByPhone) {
  774. $guardianRegister->setCurrentGuardianFoundBy('TEL');
  775. }
  777. if ($foundByEmail && $foundByPhone) {
  778. $guardianRegister->setCurrentGuardianFoundBy('EMAIL&TEL');
  779. }
  783. $this->entityManager->persist($guardianRegister);
  784. $this->entityManager->flush();
  786. return $this->redirectToRoute('guardian_registrations_index', [], Response::HTTP_SEE_OTHER);
  787. }
  789. $registrationData = $guardianRegister->getData() ?? json_decode($guardianRegister->getData());
  790. if (!empty($guardianRegister->getData())) {
  791. $registrationData = $this->changeFormat($registrationData);
  792. }
  794. $guardianRegisterRep = $guardianRegisterRepository->createQueryBuilder('g');
  795. $result = $guardianRegisterRep
  796. ->andWhere('(g.email = :email or g.guardianEmail = :email) and g.id != :id')
  797. ->orWhere('(g.phone = :phone or g.guardianPhone = :phone) and g.id != :id')
  798. ->setParameter('email', $guardianRegister->getEmail())
  799. ->setParameter('id', $guardianRegister->getId())
  800. ->setParameter('phone', $guardianRegister->getPhone())
  801. ->andWhere('g.createdAt >= :createdAt')
  802. ->setParameter('createdAt', ($guardianRegister->getCreatedAt())->modify('-7 days'))
  803. ->getQuery()
  804. ->getResult();
  806. return $this->renderForm('guardian_register/admin/edit.html.twig', [
  807. 'form' => $form,
  808. 'raw' => false,
  809. 'same_accounts_count' => $this->findSameAccounts($guardianRegister)['count'],
  810. 'same_accounts_id' => $this->findSameAccounts($guardianRegister)['id'],
  811. 'registrationData' => $registrationData,
  812. 'duplicateRegistrations' => $result,
  813. 'returningChildMatches' => $this->resolveReturningChildMatches($guardianRegister)
  814. ]);
  815. }
  817. private function resolveReturningChildMatches(GuardianRegister $guardianRegister): array
  818. {
  819. $matches = [];
  820. if (!in_array($guardianRegister->getCurrentGuardianFoundBy(), ['EMAIL', 'EMAIL&TEL'], true)) {
  821. return $matches;
  822. }
  824. $email = $guardianRegister->getIsGuardian() ? $guardianRegister->getEmail() : $guardianRegister->getGuardianEmail();
  825. $guardian = $email ? $this->guardianRepository->findOneBy(['email' => $email]) : null;
  826. if (!$guardian) {
  827. return $matches;
  828. }
  830. $classLabels = ['<1', 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, '>12'];
  832. foreach ($guardianRegister->getGuardianRegisterChildren() as $index => $guardianRegisterChild) {
  833. $existingChild = $this->childRepository->findByGuardianAndNormalizedName($guardian, $guardianRegisterChild->getName());
  834. if ($existingChild) {
  835. $matches[$index] = [
  836. 'name' => $existingChild->getFullname(),
  837. 'classLabel' => $classLabels[$existingChild->getClass()] ?? $existingChild->getClass(),
  838. ];
  839. }
  840. }
  842. return $matches;
  843. }
  845. public function findSameAccounts(GuardianRegister $guardianRegister)
  846. {
  847. $foundByEmail = 0;
  848. $foundByPhone = 0;
  849. $guardianId = 0;
  850. if ($guardian = $this->guardianRepository->findOneBy(['email' => $guardianRegister->getEmail()])) {
  851. $foundByEmail++;
  852. $guardianId = $guardian->getId();
  853. }
  854. $phoneToSearch = $guardianRegister->getPhone();
  855. // dump($phoneToSearch);
  856. $phoneToSearch = str_replace('+3706', '', $phoneToSearch);
  857. // dump($phoneToSearch);
  858. // die();
  859. $query = $this->guardianRepository->createQueryBuilder('g');
  860. $result = $query->andWhere('g.phoneNumber like :phone')
  861. ->setParameter('phone', "%{$phoneToSearch}")
  862. ->getQuery()
  863. ->getResult();
  864. if ($result) {
  865. $foundByPhone += count($result);
  866. $guardianId = $result[0]->getId();
  868. // dump($guardianId);
  869. // dump($foundByPhone);
  870. // dump($phoneToSearch);
  871. // die();
  872. }
  874. $query = $this->childRepository->createQueryBuilder('g');
  875. $result = $query->andWhere('g.phoneNumber like :phone')
  876. ->setParameter('phone', "%{$phoneToSearch}")
  877. ->getQuery()
  878. ->getResult();
  879. if ($result) {
  880. $foundByPhone += count($result);
  881. $guardianId = $result[0]->getGuardian()->getId();
  882. }
  884. $phone = $guardianRegister->getGuardianPhone();
  886. if ($phone) {
  887. $phoneToSearch = $phone;
  888. $phoneToSearch = str_replace('+3706', '', $phoneToSearch);
  889. $phoneToSearch = str_replace('3706', '', $phoneToSearch);
  890. // $pattern = '/^86/i';
  891. // $phoneToSearch = preg_replace($pattern, '', $phoneToSearch);
  893. $query = $this->guardianRepository->createQueryBuilder('g');
  894. $result = $query->andWhere('g.phoneNumber like :phone')
  895. ->setParameter('phone', "%{$phoneToSearch}")
  896. ->getQuery()
  897. ->getResult();
  898. if ($result) {
  899. $foundByPhone += count($result);
  900. $guardianId = $result[0]->getId();
  901. }
  903. $query = $this->childRepository->createQueryBuilder('g');
  904. $result = $query->andWhere('g.phoneNumber like :phone')
  905. ->setParameter('phone', "%{$phoneToSearch}")
  906. ->getQuery()
  907. ->getResult();
  908. if ($result) {
  909. $foundByPhone += count($result);
  910. $guardianId = $result[0]->getGuardian()->getId();
  911. }
  912. }
  914. return ['count' => $foundByEmail + $foundByPhone, 'id' => $guardianId];
  915. }
  917. /**
  918. * @Route("/{id}/editRaw", name="guardian_register_edit_raw", methods={"GET","POST"})
  919. * @Security("is_granted('ROLE_ADMIN') and is_granted('IS_AUTHENTICATED_FULLY')")
  920. */
  921. public function editRaw(Request $request, GuardianRegister $guardianRegister): Response
  922. {
  923. $childName = 'Vardas1';
  924. if (!$guardianRegister->getIsGuardian()) {
  925. $childName = "{$guardianRegister->getName()} {$guardianRegister->getLastname()}";
  926. }
  927. if (!$guardianRegister->getGuardianRegisterChildren()->count()) {
  928. $guardianRegisterChild = new GuardianRegisterChild();
  929. $guardianRegisterChild->setName($childName);
  930. $guardianRegisterChild->setClass(8);
  931. $guardianRegisterChild->setGuardianRegister($guardianRegister);
  932. $guardianRegisterChildPreference = new GuardianRegisterChildPreference();
  933. $guardianRegisterChildPreference->setDuration(60);
  934. $guardianRegisterChildPreference->setAmount(2);
  935. $guardianRegisterChildPreference->setGuardianRegisterChild($guardianRegisterChild);
  936. $guardianRegisterChild->addGuardianRegisterChildPreference($guardianRegisterChildPreference);
  937. $guardianRegister->addGuardianRegisterChild($guardianRegisterChild);
  938. }
  939. $form = $this->createForm(GuardianRegisterRawType::class, $guardianRegister);
  940. $oldStatus = $guardianRegister->getStatus();
  942. $originalGuardianRegisterChildren = $guardianRegister->getGuardianRegisterChildren()->getValues();
  943. $originalGuardianRegisterChildrenPreferences = [];
  945. foreach ($guardianRegister->getGuardianRegisterChildren() as $guardianRegisterChild) {
  946. $originalGuardianRegisterChildrenPreferences = array_merge($originalGuardianRegisterChildrenPreferences, $guardianRegisterChild->getGuardianRegisterChildPreferences()->getValues());
  947. }
  949. $form->handleRequest($request);
  951. if ($form->isSubmitted() && $form->isValid()) {
  953. //remove
  954. foreach ($originalGuardianRegisterChildrenPreferences as $originalGuardianRegisterChildrenPreference) {
  955. $delete = true;
  956. foreach ($guardianRegister->getGuardianRegisterChildren() as $guardianRegisterChild) {
  957. if ($guardianRegisterChild->getGuardianRegisterChildPreferences()->contains($originalGuardianRegisterChildrenPreference)) {
  958. $delete = false;
  959. }
  960. }
  961. if ($delete) {
  962. $this->entityManager->remove($originalGuardianRegisterChildrenPreference);
  963. }
  964. }
  966. foreach ($originalGuardianRegisterChildren as $originalGuardianRegisterChild) {
  967. if (!$guardianRegister->getGuardianRegisterChildren()->contains($originalGuardianRegisterChild)) {
  968. $this->entityManager->remove($originalGuardianRegisterChild);
  969. }
  970. }
  971. //add
  972. foreach ($guardianRegister->getGuardianRegisterChildren() as $guardianRegisterChild) {
  973. foreach ($guardianRegisterChild->getGuardianRegisterChildPreferences() as $guardianRegisterChildPreference) {
  974. $guardianRegisterChildPreference->setGuardianRegisterChild($guardianRegisterChild);
  975. $this->entityManager->persist($guardianRegisterChildPreference);
  976. }
  977. $guardianRegisterChild->setGuardianRegister($guardianRegister);
  978. $this->entityManager->persist($guardianRegisterChild);
  979. }
  981. $this->handleStatusChange($guardianRegister, $oldStatus);
  982. $this->entityManager->persist($guardianRegister);
  983. $this->entityManager->flush();
  986. return $this->redirectToRoute('guardian_registrations_index', [], Response::HTTP_SEE_OTHER);
  987. }
  989. return $this->renderForm('guardian_register/admin/_form.html.twig', [
  990. 'form' => $form,
  991. 'raw' => true,
  992. 'returningChildMatches' => $this->resolveReturningChildMatches($guardianRegister)
  993. ]);
  994. }
  996. public function sendSuccessEmail(GuardianRegister $guardianRegister)
  997. {
  998. // $this->messageBus->dispatch(new SendMailMessage($guardianRegister->getEmail(), '', '', [], 'REGISTER_NOTIF_0'));
  999. }
  1001. public function handleStatusChange(GuardianRegister $guardianRegister, $oldStatus)
  1002. {
  1004. if ($guardianRegister->isFlagEarlyPayment()) {
  1005. if (!$guardianRegister->getEarlyPaymentToken() || !$guardianRegister->getEarlyPaymentTokenValidTo() || $guardianRegister->getEarlyPaymentTokenValidTo() < new \DateTime()) {
  1006. $randomString = $this->createRandomString();
  1007. while ($this->guardianRegisterRepository->findOneBy(['earlyPaymentToken' => $randomString])) {
  1008. $randomString = $this->createRandomString();
  1009. }
  1010. $guardianRegister->setEarlyPaymentToken($randomString);
  1011. $guardianRegister->setEarlyPaymentTokenValidTo((new \DateTime())->modify('+2 days'));
  1012. $guardianRegister->setEarlyPaymentSentAt(new \DateTime());
  1013. $this->entityManager->persist($guardianRegister);
  1014. $this->entityManager->flush();
  1015. }
  1017. }
  1019. $foundByEmail = false;
  1020. $foundByPhone = false;
  1021. if ($this->guardianRepository->findOneBy(['email' => $guardianRegister->getEmail()])) {
  1022. $foundByEmail = true;
  1023. }
  1025. if ($guardianRegister->getGuardianEmail() && $this->guardianRepository->findOneBy(['email' => $guardianRegister->getGuardianEmail()])) {
  1026. $foundByEmail = true;
  1027. }
  1029. $phoneToSearch = $guardianRegister->getPhone();
  1030. $phoneToSearch = str_replace('+3706', '', $phoneToSearch);
  1032. if ($phoneToSearch && strlen($phoneToSearch) > 5) {
  1033. $query = $this->guardianRepository->createQueryBuilder('g');
  1034. $result = $query->andWhere('g.phoneNumber like :phone')
  1035. ->setParameter('phone', "%{$phoneToSearch}%")
  1036. ->getQuery()
  1037. ->getResult();
  1038. if ($result) {
  1039. $foundByPhone = true;
  1040. }
  1042. $query = $this->childRepository->createQueryBuilder('g');
  1043. $result = $query->andWhere('g.phoneNumber like :phone')
  1044. ->setParameter('phone', "%{$phoneToSearch}%")
  1045. ->getQuery()
  1046. ->getResult();
  1047. if ($result) {
  1048. $foundByPhone = true;
  1049. }
  1050. }
  1052. $phone = $guardianRegister->getGuardianPhone();
  1054. if ($phone && strlen($phone) > 5) {
  1055. $phoneToSearch = $phone;
  1056. $phoneToSearch = str_replace('+3706', '', $phoneToSearch);
  1057. $phoneToSearch = str_replace('3706', '', $phoneToSearch);
  1058. $pattern = '/^86/i';
  1059. $phoneToSearch = preg_replace($pattern, '', $phoneToSearch);
  1061. $query = $this->guardianRepository->createQueryBuilder('g');
  1062. $result = $query->andWhere('g.phoneNumber like :phone')
  1063. ->setParameter('phone', "%{$phoneToSearch}%")
  1064. ->getQuery()
  1065. ->getResult();
  1066. if ($result) {
  1067. $foundByPhone = true;
  1068. }
  1070. $query = $this->childRepository->createQueryBuilder('g');
  1071. $result = $query->andWhere('g.phoneNumber like :phone')
  1072. ->setParameter('phone', "%{$phoneToSearch}%")
  1073. ->getQuery()
  1074. ->getResult();
  1075. if ($result) {
  1076. $foundByPhone = true;
  1077. }
  1078. }
  1080. if ($foundByEmail && !$foundByPhone) {
  1081. $guardianRegister->setCurrentGuardianFoundBy('EMAIL');
  1082. }
  1084. if (!$foundByEmail && $foundByPhone) {
  1085. $guardianRegister->setCurrentGuardianFoundBy('TEL');
  1086. }
  1088. if ($foundByEmail && $foundByPhone) {
  1089. $guardianRegister->setCurrentGuardianFoundBy('EMAIL&TEL');
  1090. }
  1091. $this->entityManager->persist($guardianRegister);
  1092. $this->entityManager->flush();
  1095. $newStatus = $guardianRegister->getStatus();
  1096. if ($oldStatus == $newStatus) {
  1097. return;
  1098. }
  1099. if (!$guardianRegister->getSalesPerson()) {
  1100. $guardianRegister->setSalesPerson($this->getUser());
  1101. if (!$guardianRegister->getSalesAssignedAt()) {
  1102. $guardianRegister->setSalesAssignedAt(new \DateTime());
  1103. }
  1104. }
  1105. $guardianRegister->setIgnoredEmailCount(0);
  1106. $guardianRegister->setIgnoredAt(null);
  1107. if ($newStatus == GuardianRegister::STATUS_IGNORED['value']) {
  1108. if (!$guardianRegister->getIgnoredAt()) {
  1109. $guardianRegister->setIgnoredAt(new \DateTime());
  1110. }
  1111. $this->sendIgnoredEmailAndSMS($guardianRegister);
  1112. }
  1113. if ($newStatus == GuardianRegister::STATUS_DECLINED['value']) {
  1114. $this->sendDeclinedEmail($guardianRegister);
  1115. }
  1116. if ($newStatus == GuardianRegister::STATUS_LOST['value']) {
  1117. $this->sendLostEmail($guardianRegister);
  1118. $guardianRegister->setLostAt(new \DateTime());
  1119. $this->entityManager->persist($guardianRegister);
  1120. $this->entityManager->flush();
  1121. $emailToSend = $guardianRegister->getEmail();
  1122. if (!$guardianRegister->getIsGuardian()) {
  1123. $emailToSend = $guardianRegister->getGuardianEmail();
  1124. }
  1125. $this->omnisendService->trackEvent($emailToSend, 'ContractLost');
  1126. }
  1127. if ($newStatus == GuardianRegister::STATUS_SENT['value']) {
  1128. if (!$guardianRegister->getContractSentAt()) {
  1129. $guardianRegister->setContractSentAt(new \DateTime());
  1130. }
  1131. $this->sendContractEmailAndSMS($guardianRegister);
  1132. }
  1133. if ($newStatus == GuardianRegister::STATUS_CONFIRMED['value']) {
  1134. $plainPassword = $this->createRandomPassword();
  1135. $childrenCredentials = $this->convertRegisterToGuardian($guardianRegister, $plainPassword);
  1136. $this->sendSignedEmail($guardianRegister, $plainPassword, $childrenCredentials);
  1138. if (!$guardianRegister->getContractSignedAt()) {
  1139. $guardianRegister->setContractSignedAt(new \DateTime());
  1140. $this->entityManager->persist($guardianRegister);
  1141. $this->entityManager->flush();
  1142. }
  1144. if (!$guardianRegister->isFlagManualAssignment()) {
  1145. $this->entityManager->refresh($guardianRegister);
  1146. $guardian = $guardianRegister->getGuardian();
  1147. $this->entityManager->refresh($guardian);
  1148. foreach ($guardian->getChildren() as $child) {
  1149. $this->entityManager->refresh($child);
  1150. $dateToSendAt = new \DateTime();
  1151. foreach ($child->getChildPreferences() as $childPreference) {
  1152. $this->entityManager->refresh($childPreference);
  1154. $this->messageBus->dispatch(new Envelope(new AssignChildPreferenceTeacherMessage($childPreference->getId()), [
  1155. DelayStamp::delayUntil($dateToSendAt),
  1156. ]));
  1157. $dateToSendAt->modify('+1 minute');
  1158. }
  1159. }
  1160. }
  1161. }
  1162. if ($newStatus == GuardianRegister::STATUS_UNTARGETED['value']) {
  1163. $emailToSend = $guardianRegister->getEmail();
  1164. if (!$guardianRegister->getIsGuardian()) {
  1165. $emailToSend = $guardianRegister->getGuardianEmail();
  1166. }
  1168. $replacements = [
  1169. '[ADMIN_NAME]' => $guardianRegister->getSalesPerson()->getFullname(),
  1170. '[ADMIN_PHONE]' => $guardianRegister->getSalesPerson()->getPhone(),
  1171. ];
  1173. $this->messageBus->dispatch(new SendMailMessage($emailToSend, '', '', $replacements, 'REGISTER_FAKE'));
  1175. $this->omnisendService->trackEvent($emailToSend, 'ContractUntargeted');
  1176. }
  1177. }
  1179. public function convertRegisterToGuardian(GuardianRegister $guardianRegister, $plainPassword)
  1180. {
  1181. $childrenCredentials = "";
  1182. if ($guardianRegister->getIsGuardian()) {
  1183. $name = $guardianRegister->getName();
  1184. $lastname = $guardianRegister->getLastname();
  1185. $email = $guardianRegister->getEmail();
  1186. $phone = $guardianRegister->getPhone();
  1187. } else {
  1188. $name = $guardianRegister->getGuardianName();
  1189. $lastname = $guardianRegister->getGuardianLastname();
  1190. $email = $guardianRegister->getGuardianEmail();
  1191. $phone = $guardianRegister->getGuardianPhone();
  1192. }
  1193. $guardian = null;
  1194. if ($guardianRegister->getCurrentGuardianFoundBy() == "EMAIL" || $guardianRegister->getCurrentGuardianFoundBy() == "EMAIL&TEL") {
  1195. $guardian = $this->guardianRepository->findOneBy(['email' => $email]);
  1197. if ($guardian) {
  1198. $otherGuardianRegisters = $this->guardianRegisterRepository->findBy(['guardian' => $guardian->getId()]);
  1199. foreach ($otherGuardianRegisters as $otherGuardianRegister) {
  1200. $otherGuardianRegister->setGuardian(null);
  1201. $this->entityManager->persist($otherGuardianRegister);
  1202. $this->entityManager->flush();
  1203. }
  1204. }
  1205. }
  1207. if (!$guardian) {
  1208. $guardian = new Guardian();
  1209. }
  1211. $guardian->setGuardianRegister($guardianRegister);
  1212. $guardian->setEmail($email);
  1213. $guardian->setFullname("{$name} {$lastname}");
  1214. $guardian->setPhoneNumber($phone);
  1215. $guardian->setStatus(Guardian::STATUS_CONFIRMED['value']);
  1216. $guardian->setGuardianContract($guardianRegister->getGuardianContract());
  1217. $guardian->setComment($guardianRegister->getComment());
  1218. $guardian->setContractPricingFrom(new \DateTime());
  1219. $guardian->setEarlyPaymentDay($guardianRegister->getEarlyPaymentDay());
  1220. $guardian->setFlagEarlyPayment($guardianRegister->isFlagEarlyPayment());
  1222. $encoded = $this->userPasswordHasher->hashPassword($guardian, $plainPassword);
  1223. $guardian->setPassword($encoded);
  1225. $this->entityManager->persist($guardian);
  1226. $this->entityManager->flush($guardian);
  1227. $guardianRegister->setGuardian($guardian);
  1228. $this->entityManager->persist($guardianRegister);
  1229. $this->entityManager->flush($guardianRegister);
  1231. $this->guardianRegisterDuplicateReconciliationService->closeOpenDuplicates($guardianRegister, $phone, $email);
  1233. if ($guardianRegister->getGuardianPriceDiscount()) {
  1234. $guardianPriceDiscount = new GuardianPriceDiscount();
  1235. $guardianPriceDiscount->setGuardian($guardian);
  1236. $guardianPriceDiscount->setDateFrom(new \DateTime());
  1237. $guardianPriceDiscount->setDateTo((new \DateTime())->modify('+10 years'));
  1238. $guardianPriceDiscount->setDiscountPercent($guardianRegister->getGuardianPriceDiscount());
  1239. $this->entityManager->persist($guardianPriceDiscount);
  1240. $this->entityManager->flush();
  1241. }
  1242. // $priceChange = new PriceChange();
  1243. // $priceChange->setGuardian($guardian);
  1244. // $priceChange->setValue($guardianRegister->getPriceChange());
  1245. // $priceChange->setDateFrom(new \Datetime());
  1246. // $this->entityManager->persist($priceChange);
  1247. // $this->entityManager->flush();
  1249. foreach ($guardianRegister->getGuardianRegisterChildren() as $guardianRegisterChild) {
  1250. $child = null;
  1251. if ($guardianRegister->getCurrentGuardianFoundBy() == "EMAIL" || $guardianRegister->getCurrentGuardianFoundBy() == "EMAIL&TEL") {
  1252. $child = $this->childRepository->findByGuardianAndNormalizedName($guardian, $guardianRegisterChild->getName());
  1253. }
  1255. if (!$child) {
  1256. $child = new Child();
  1257. }
  1258. $child->setLessonsEnd(null);
  1259. $child->setGuardian($guardian);
  1260. $child->setFullname($guardianRegisterChild->getName());
  1261. $child->setClass($guardianRegisterChild->getClass());
  1262. $child->setEmail($guardianRegisterChild->getEmail());
  1263. $child->setFittingTimes($guardianRegisterChild->getFittingTimes());
  1264. $child->setFittingTimesPriority($guardianRegisterChild->getFittingTimesPriority());
  1266. $child->setFlagENG($guardianRegisterChild->getFlagENG());
  1267. $child->setFlagPL($guardianRegisterChild->getFlagPL());
  1268. $child->setFlagRU($guardianRegisterChild->getFlagRU());
  1269. $child->setFlagDyslexia($guardianRegisterChild->getFlagDyslexia());
  1270. $child->setFlagIB($guardianRegisterChild->getFlagIB());
  1271. $child->setFlagIelts($guardianRegisterChild->isFlagIelts());
  1272. $child->setFlagDyslexia($guardianRegisterChild->getFlagDyslexia());
  1273. $child->setFlagSensitive($guardianRegisterChild->getFlagSensitive());
  1274. $child->setFlagStrict($guardianRegisterChild->isFlagStrict());
  1275. $child->setVbeOver90($guardianRegisterChild->isVbeOver90());
  1276. $child->setFlagExperienceAtSchool($guardianRegisterChild->isFlagExperienceAtSchool());
  1277. $child->setExperienceOver12Month($guardianRegisterChild->isExperienceOver12Month());
  1278. $child->setGender($guardianRegisterChild->getGender());
  1279. $child->setSchool($guardianRegisterChild->getSchool());
  1280. $child->setTutorComment($guardianRegisterChild->getTutorComment());
  1282. $token = HelperUtils::createRandomString();
  1283. while ($this->childRepository->findOneBy(['loginToken' => $token])) {
  1284. $token = HelperUtils::createRandomString();
  1285. }
  1286. $child->setLoginToken($token);
  1287. if (!$guardianRegister->getIsGuardian()) {
  1288. $child->setPhoneNumber($guardianRegister->getPhone());
  1289. $child->setEmail($guardianRegister->getEmail());
  1290. }
  1292. $childPlainPwd = HelperUtils::generateLithuanianPassword(1, 4);
  1293. $encoded = $this->userPasswordHasher->hashPassword($child, $childPlainPwd);
  1294. $child->setPassword($encoded);
  1296. if (!$child->getUsername()) {
  1297. $username = HelperUtils::removeLtLetters(strtolower(explode(' ', $child->getFullname())[0] . "cor"));
  1298. if (!$username) {
  1299. $username = HelperUtils::generateLithuanianPassword(1, 0) . 'cor';
  1300. }
  1302. $counter = 1;
  1303. while ($this->childRepository->findOneBy(['username' => $username . $counter])) {
  1304. $counter++;
  1305. if ($counter == 69) {
  1306. $counter++;
  1307. }
  1308. }
  1309. $username = $username . $counter;
  1310. $child->setUsername($username);
  1311. }
  1313. $childUsername = $child->getEmail();
  1314. if (!$childUsername) {
  1315. $childUsername = $child->getUsername();
  1316. }
  1318. $childrenCredentials .= "
  1319. <b>Mokinys:</b> {$guardianRegisterChild->getName()}<br>
  1320. <b>Mokinio prisijungimo vardas:</b> {$childUsername}<br>
  1321. <b>Slaptažodis:</b> {$childPlainPwd}<br><br>
  1322. ";
  1323. $guardian->addChild($child);
  1324. $this->entityManager->persist($child);
  1325. $this->entityManager->flush();
  1326. if ($child->getEmail()) {
  1327. $this->credentialsService->sendChildrenEmailLogins($child, $childPlainPwd);
  1328. }
  1329. foreach ($guardianRegisterChild->getGuardianRegisterChildPreferences() as $guardianRegisterChildPreference) {
  1330. $childPreference = new ChildPreference();
  1332. if ($guardianRegister->isFlagManualAssignment()) {
  1333. $childPreference->setFlagManualAssignment(true);
  1334. }
  1336. $childPreference->setChild($child);
  1337. $childPreference->setFittingTimes($guardianRegisterChild->getFittingTimes());
  1338. $childPreference->setFittingTimesPriority($guardianRegisterChild->getFittingTimesPriority());
  1339. $childPreference->setComment($guardianRegisterChildPreference->getComment());
  1340. $childPreference->setDiscipline($guardianRegisterChildPreference->getDiscipline());
  1341. $childPreference->setSingleEmailDuration($guardianRegisterChildPreference->getDuration());
  1342. $childPreference->setType(Lesson::TYPE_INDIVIDUAL);
  1343. $childPreference->setEmailDuration($guardianRegisterChildPreference->getDuration() * $guardianRegisterChildPreference->getAmount());
  1344. $childPreference->setAssignedFrom('Naujas');
  1345. $child->addChildPreference($childPreference);
  1346. $this->entityManager->persist($childPreference);
  1347. $this->entityManager->persist($child);
  1348. $this->entityManager->flush();
  1349. }
  1351. }
  1353. // $this->credentialsService->sendChildrenCredentialsTokenEmail($guardian);
  1355. return $childrenCredentials;
  1356. // $this->credentialsService->sendChildrenCredentialsEmailOLD($guardian);
  1357. }
  1359. public function sendSignedEmail(GuardianRegister $guardianRegister, $plainPassword, $childrenCredentials)
  1360. {
  1361. $emailToSend = $guardianRegister->getEmail();
  1362. if (!$guardianRegister->getIsGuardian()) {
  1363. $emailToSend = $guardianRegister->getGuardianEmail();
  1364. }
  1366. $replacements = [
  1367. '[ADMIN_NAME]' => $guardianRegister->getSalesPerson()->getFullname(),
  1368. '[ADMIN_PHONE]' => $guardianRegister->getSalesPerson()->getPhone(),
  1369. '[USER_EMAIL]' => $emailToSend,
  1370. '[USER_PASSWORD]' => $plainPassword,
  1371. '[CURRENT_TIME]' => (new \DateTime())->format('H:i'),
  1372. '[CHILDREN_CREDENTIALS]' => $childrenCredentials
  1373. ];
  1375. $this->messageBus->dispatch(new SendMailMessage($emailToSend, '', '', $replacements, 'REGISTER_NOTIF_4'));
  1376. }
  1378. public function createRandomPassword(): string
  1379. {
  1380. $length = rand(10, 12);
  1381. $chars = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';
  1382. return substr(str_shuffle(str_repeat($chars, $length)), 0, $length);
  1383. }
  1385. public function sendEarlyPaymentEmailAndSMS(GuardianRegister $guardianRegister)
  1386. {
  1387. $randomString = $this->createRandomString();
  1388. while ($this->guardianRegisterRepository->findOneBy(['cancelToken' => $randomString])) {
  1389. $randomString = $this->createRandomString();
  1390. }
  1391. $guardianRegister->setCancelToken($randomString);
  1392. $guardianRegister->setContractGeneratedAt(new \Datetime());
  1393. $guardianRegister->setMarksignUrl(null);
  1394. $guardianRegister->setMarksignDocumentId(null);
  1395. $guardianRegister->setIgnoredEmailCount(0);
  1397. $guardianRegister->setStatus(GuardianRegister::STATUS_WAITING['value']);
  1398. $this->entityManager->persist($guardianRegister);
  1399. $this->entityManager->flush();
  1401. $replacements = [
  1402. '[APMOKĖJIMO_NUORODĄ]' => "https://cor.lt/ep/{$guardianRegister->getEarlyPaymentToken()}",
  1403. '[ĮDĖKITE NUORODĄ]' => "https://cor.lt/ep/{$guardianRegister->getEarlyPaymentToken()}",
  1404. '[_LINK]' => "https://cor.lt/ep/{$guardianRegister->getEarlyPaymentToken()}",
  1405. '[CURRENT_TIME]' => (new \Datetime())->format('H:i'),
  1406. '[ADMIN_NAME]' => $guardianRegister->getSalesPerson()->getFullname(),
  1407. '[ADMIN_PHONE]' => $guardianRegister->getSalesPerson()->getPhone(),
  1408. '[CONTRACT_LINK]' => "https://cor.lt/c/{$guardianRegister->getContractToken()}",
  1409. 'https://app.corepetitus.lt/[CANCEL_LINK]' => $this->getParameter('domain') . $this->generateUrl('guardian_register_cancel', ['token' => $guardianRegister->getCancelToken()]),
  1410. '[CANCEL_LINK]' => $this->getParameter('domain') . $this->generateUrl('guardian_register_cancel', ['token' => $guardianRegister->getCancelToken()]),
  1411. ];
  1413. $emailToSend = $guardianRegister->getEmail();
  1414. $phoneToSend = $guardianRegister->getPhone();
  1415. if (!$guardianRegister->getIsGuardian()) {
  1416. $emailToSend = $guardianRegister->getGuardianEmail();
  1417. $phoneToSend = $guardianRegister->getGuardianPhone();
  1418. }
  1420. $this->messageBus->dispatch(new SendMailMessage($emailToSend, '', '', $replacements, 'CLIENT_PAYMENT_LINK'));
  1421. $this->messageBus->dispatch(new SendSMSMessage($phoneToSend, '', $replacements, 'CLIENT_PAYMENT_LINK'));
  1422. }
  1424. public function sendContractEmailAndSMS(GuardianRegister $guardianRegister)
  1425. {
  1426. $emailToSend = $guardianRegister->getEmail();
  1427. if (!$guardianRegister->getIsGuardian()) {
  1428. $emailToSend = $guardianRegister->getGuardianEmail();
  1429. }
  1430. $this->omnisendService->trackEvent($emailToSend, 'ContractSent');
  1432. if ($guardianRegister->getEarlyPaymentDay()) {
  1433. $this->sendEarlyPaymentEmailAndSMS($guardianRegister);
  1434. return true;
  1435. }
  1437. $randomString = $this->createRandomString();
  1438. while ($this->guardianRegisterRepository->findOneBy(['contractToken' => $randomString])) {
  1439. $randomString = $this->createRandomString();
  1440. }
  1441. $guardianRegister->setContractToken($randomString);
  1442. $randomString = $this->createRandomString();
  1443. while ($this->guardianRegisterRepository->findOneBy(['cancelToken' => $randomString])) {
  1444. $randomString = $this->createRandomString();
  1445. }
  1446. $guardianRegister->setCancelToken($randomString);
  1447. $guardianRegister->setContractGeneratedAt(new \Datetime());
  1448. $guardianRegister->setMarksignUrl(null);
  1449. $guardianRegister->getMarksignDocumentId(null);
  1450. $guardianRegister->setIgnoredEmailCount(0);
  1452. $contractSummary = "";
  1453. $weeklyCost = 0;
  1454. $totalAmount = 0;
  1455. foreach ($guardianRegister->getGuardianRegisterChildren() as $guardianRegisterChild) {
  1456. foreach ($guardianRegisterChild->getGuardianRegisterChildPreferences() as $guardianRegisterChildPreference) {
  1457. $hourCost = $this->findPriceByClass($guardianRegister, $guardianRegisterChildPreference);
  1459. $totalAmount += $guardianRegisterChildPreference->getAmount();
  1460. $preferenceWeekDuration = $guardianRegisterChildPreference->getAmount() * $guardianRegisterChildPreference->getDuration();
  1461. $preferenceWeekCost = round($preferenceWeekDuration / 60 * $hourCost, 2);
  1462. $weeklyCost += $preferenceWeekCost;
  1463. $fittingTimes = $guardianRegisterChild->getFittingTimes();
  1464. $fittingTimes = str_replace(';', ';<br>', $fittingTimes);
  1465. $contractSummary .= "Vaiko vardas: {$guardianRegisterChild->getName()}<br>
  1466. Klasė: {$guardianRegisterChild->getClass()}<br>
  1467. Disciplina: {$guardianRegisterChildPreference->getDiscipline()->getName()}<br>
  1468. Dažnis (per savaitę): {$guardianRegisterChildPreference->getAmount()}<br>
  1469. Vieno užsiėmimo trukmė (min.): {$guardianRegisterChildPreference->getDuration()}<br>
  1470. Bendra užsiėmimų trukmė per savaitę (min.): {$preferenceWeekDuration}<br>
  1471. Vietos tipas: Nuotolinis <br>
  1472. Tipas: Individualiai <br>
  1473. Mokiniui tinkami užsiėmimų laikai:<br>
  1474. {$fittingTimes}
  1475. Užsiėmimų kaina į savaitę: {$preferenceWeekCost} EUR<br><br>
  1476. ";
  1477. }
  1478. }
  1481. // if(count($guardianRegister->getGuardianRegisterChildren()) >=2 && $guardianRegister->getGuardianContract()->getId() > 25)
  1482. // {
  1483. // if($totalAmount == 2)
  1484. // {
  1485. // $contractSummary .= "Nuolaida: 10% vienam savaitiniam užsiėmimui vyresniam mokiniui.<br><br>";
  1486. // }
  1487. // elseif($totalAmount == 3)
  1488. // {
  1489. // $contractSummary .= "Nuolaida: 15% vienam savaitiniam užsiėmimui vyresniam mokiniui.<br><br>";
  1490. // }
  1491. // elseif($totalAmount > 3)
  1492. // {
  1493. // $contractSummary .= "Nuolaida: 20% vienam savaitiniam užsiėmimui vyresniam mokiniui.<br><br>";
  1494. // }
  1495. // }
  1498. $replacements = [
  1499. '[CURRENT_TIME]' => (new \Datetime())->format('H:i'),
  1500. '[ADMIN_NAME]' => $guardianRegister->getSalesPerson()->getFullname(),
  1501. '[ADMIN_PHONE]' => $guardianRegister->getSalesPerson()->getPhone(),
  1502. '[CONTRACT_SUMMARY]' => $contractSummary,
  1503. '[WEEKLY_COST]' => $weeklyCost,
  1504. '[CONTRACT_LINK]' => "https://cor.lt/c/{$guardianRegister->getContractToken()}",
  1505. // '[CONTRACT_LINK]' => "https://corepetitus.tlprojektai.lt/c/{$guardianRegister->getContractToken()}",
  1506. '[CANCEL_LINK]' => $this->getParameter('domain') . $this->generateUrl('guardian_register_cancel', ['token' => $guardianRegister->getCancelToken()])
  1507. ];
  1509. $emailToSend = $guardianRegister->getEmail();
  1510. $phoneToSend = $guardianRegister->getPhone();
  1511. if (!$guardianRegister->getIsGuardian()) {
  1512. $emailToSend = $guardianRegister->getGuardianEmail();
  1513. $phoneToSend = $guardianRegister->getGuardianPhone();
  1514. }
  1516. $this->messageBus->dispatch(new SendMailMessage($emailToSend, '', '', $replacements, 'REGISTER_NOTIF_2'));
  1517. $this->messageBus->dispatch(new SendSMSMessage($phoneToSend, '', $replacements, 'REGISTER_NOTIF_2'));
  1518. }
  1520. public function findPriceByClass(GuardianRegister $guardianRegister, GuardianRegisterChildPreference $guardianRegisterChildPreference)
  1521. {
  1522. $guardianContract = $guardianRegister->getGuardianContract();
  1523. $amountFrom = 0;
  1524. foreach ($guardianRegisterChildPreference->getGuardianRegisterChild()->getGuardianRegister()->getGuardianRegisterChildren() as $guardianRegisterChild) {
  1525. foreach ($guardianRegisterChild->getGuardianRegisterChildPreferences() as $guardianRegisterChildPreferenceForAmount) {
  1526. $amountFrom += $guardianRegisterChildPreferenceForAmount->getAmount();
  1527. }
  1528. }
  1531. $class = $guardianRegisterChildPreference->getGuardianRegisterChild()->getClass();
  1532. $query = $this->guardianContractPriceClassAmountPriceRepository->createQueryBuilder('cap');
  1533. $guardianContractPriceClassAmountPrice = $query
  1534. ->leftJoin('cap.guardianContractPriceDiscipline', 'guardianContractPriceDiscipline')
  1535. ->leftJoin('guardianContractPriceDiscipline.guardianContractPrice', 'guardianContractPrice')
  1536. ->andWhere('guardianContractPrice.guardianContract = :guardianContract')
  1537. ->setParameter('guardianContract', $guardianContract)
  1538. ->andWhere(':discipline MEMBER OF guardianContractPriceDiscipline.disciplines')
  1539. ->setParameter('discipline', $guardianRegisterChildPreference->getDiscipline())
  1540. ->andWhere('cap.classFrom <= :classFrom')
  1541. ->setParameter('classFrom', $class)
  1542. ->andWhere('cap.amountFrom < :amountFrom')
  1543. ->setParameter('amountFrom', $amountFrom)
  1544. ->orderBy('cap.classFrom', 'DESC')
  1545. ->addOrderBy('cap.amountFrom', 'DESC')
  1546. ->setMaxResults(1)
  1547. ->getQuery()
  1548. ->getOneOrNullResult();
  1551. $priceAmountGuardian = $guardianContractPriceClassAmountPrice->getPrice();
  1553. if ($guardianRegister->getGuardianPriceDiscount()) {
  1554. $priceAmountGuardian *= ((100 - $guardianRegister->getGuardianPriceDiscount()) / 100);
  1555. }
  1556. return round($priceAmountGuardian, 2);
  1557. }
  1559. public function createRandomString(): string
  1560. {
  1561. $length = rand(4, 6);
  1562. $chars = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';
  1563. return substr(str_shuffle(str_repeat($chars, $length)), 0, $length);
  1564. }
  1566. public function sendIgnoredEmailAndSMS(GuardianRegister $guardianRegister)
  1567. {
  1568. $reminderObject = $this->reminderConfigurationRepository->findOneBy(['reminder_key' => 'REGISTER_NOTIF_1']);
  1570. $replacements = [
  1571. '[ADMIN_NAME]' => $guardianRegister->getSalesPerson()->getFullname(),
  1572. '[ADMIN_PHONE]' => $guardianRegister->getSalesPerson()->getPhone(),
  1573. '[CURRENT_TIME]' => (new \DateTime())->format('H:i'),
  1574. ];
  1576. $emailToSend = $guardianRegister->getEmail();
  1577. $phoneToSend = $guardianRegister->getPhone();
  1579. $this->messageBus->dispatch(new SendMailMessage($emailToSend, '', '', $replacements, 'REGISTER_NOTIF_1'));
  1582. if ($guardianRegister->getGuardianEmail()) {
  1583. $emailToSend = $guardianRegister->getGuardianEmail();
  1584. $this->messageBus->dispatch(new SendMailMessage($emailToSend, '', '', $replacements, 'REGISTER_NOTIF_1'));
  1585. }
  1587. $smsContent = $reminderObject->getSmsTemplate();
  1589. $smsContent = str_replace(array_keys($replacements), array_values($replacements), $smsContent);
  1590. $this->smsService->send($phoneToSend, $smsContent, true);
  1591. if ($guardianRegister->getGuardianPhone()) {
  1592. $phoneToSend = $guardianRegister->getGuardianPhone();
  1593. $this->smsService->send($phoneToSend, $smsContent, true);
  1594. }
  1595. }
  1597. public function sendLostEmail(GuardianRegister $guardianRegister)
  1598. {
  1599. $replacements = [
  1600. '[ADMIN_NAME]' => $guardianRegister->getSalesPerson()->getFullname(),
  1601. '[ADMIN_PHONE]' => $guardianRegister->getSalesPerson()->getPhone(),
  1602. '[CURRENT_TIME]' => (new \DateTime())->format('H:i'),
  1603. ];
  1605. $this->messageBus->dispatch(new SendMailMessage($guardianRegister->getEmail(), '', '', $replacements, 'REGISTER_NOTIF_5'));
  1606. }
  1608. public function sendDeclinedEmail(GuardianRegister $guardianRegister)
  1609. {
  1610. $replacements = [
  1611. '[ADMIN_NAME]' => $guardianRegister->getSalesPerson()->getFullname(),
  1612. '[ADMIN_PHONE]' => $guardianRegister->getSalesPerson()->getPhone(),
  1613. '[CURRENT_TIME]' => (new \DateTime())->format('H:i'),
  1614. ];
  1615. $this->messageBus->dispatch(new SendMailMessage($guardianRegister->getEmail(), '', '', $replacements, 'REGISTER_NOTIF_3'));
  1616. }
  1618. private function changeFormat(array $data): array
  1619. {
  1620. $dayMap = [
  1621. 'Pir' => 'monday',
  1622. 'Ant' => 'tuesday',
  1623. 'Tre' => 'wednesday',
  1624. 'Ket' => 'thursday',
  1625. 'Pen' => 'friday',
  1626. 'Šeš' => 'saturday',
  1627. 'Ses' => 'saturday',
  1628. 'Sek' => 'sunday',
  1629. ];
  1631. $times = [
  1632. 'monday' => [],
  1633. 'tuesday' => [],
  1634. 'wednesday' => [],
  1635. 'thursday' => [],
  1636. 'friday' => [],
  1637. 'saturday' => [],
  1638. 'sunday' => [],
  1639. ];
  1641. $timeRows = [];
  1642. if (isset($data['weekday_time']) && is_array($data['weekday_time'])) {
  1643. $timeRows = array_merge($timeRows, $data['weekday_time']);
  1644. }
  1645. if (isset($data['weekend_time']) && is_array($data['weekend_time'])) {
  1646. $timeRows = array_merge($timeRows, $data['weekend_time']);
  1647. }
  1649. foreach ($timeRows as $row) {
  1650. if (!is_array($row)) {
  1651. continue;
  1652. }
  1654. $dayKey = $dayMap[$row['day'] ?? ''] ?? null;
  1655. $rawTime = $row['time'] ?? '';
  1656. if (!$dayKey || !$rawTime) {
  1657. continue;
  1658. }
  1660. $time = trim($rawTime);
  1661. $time = preg_replace('/\s*[–-]\s*/u', ' - ', $time);
  1662. $time = preg_replace('/:00\b/', '', $time);
  1663. $time = trim($time);
  1665. if ($time !== '' && !in_array($time, $times[$dayKey], true)) {
  1666. $times[$dayKey][] = $time;
  1667. }
  1668. }
  1670. $data['times'] = $times;
  1671. unset($data['weekday_time'], $data['weekend_time']);
  1673. return $data;
  1674. }
  1675. }