src/Service/ChildPreferenceService.php line 126

Open in your IDE?
  1. <?php
  3. namespace App\Service;
  5. use App\Entity\Child;
  6. use App\Entity\ChildPreference;
  7. use App\Entity\ChildPreferenceDeclineHistory;
  8. use App\Entity\ChildPreferenceTime;
  9. use App\Entity\Guardian;
  10. use App\Entity\GuardianRegister\GuardianRegisterChild;
  11. use App\Entity\Lesson;
  12. use App\Entity\LessonDeleted;
  13. use App\Entity\Teacher;
  14. use App\Entity\TeacherHoliday;
  15. use App\Entity\TeacherSickLeaves;
  16. use App\Entity\TeacherUnavailableRange;
  17. use App\Message\AssignChildPreferenceTeacherMessage;
  18. use App\Message\SendMailMessage;
  19. use App\Message\SendSMSMessage;
  20. use App\Repository\ChildPreferenceDeclineHistoryRepository;
  21. use App\Repository\ChildPreferenceHistoryRepository;
  22. use App\Repository\ChildPreferenceRepository;
  23. use App\Repository\ChildPreferenceTimeRepository;
  24. use App\Repository\LessonDeletedRepository;
  25. use App\Repository\LessonRepository;
  26. use App\Repository\NotificationRepository;
  27. use App\Repository\ReminderConfigurationRepository;
  28. use App\Repository\TeacherHolidayRepository;
  29. use App\Repository\TeacherRepository;
  30. use App\Repository\TeacherSickLeavesRepository;
  31. use App\Repository\TeacherUnavailableRangeRepository;
  32. use App\Repository\UserFireBaseTokenRepository;
  33. use Doctrine\ORM\EntityManagerInterface;
  34. use Psr\Container\ContainerInterface;
  35. use Symfony\Component\HttpFoundation\RequestStack;
  36. use Symfony\Component\Messenger\Envelope;
  37. use Symfony\Component\Messenger\MessageBusInterface;
  38. use Symfony\Component\Messenger\Stamp\DelayStamp;
  39. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  40. use Symfony\Component\Serializer\SerializerInterface;
  42. class ChildPreferenceService
  43. {
  44. public const NEW_CHILD_ASSIGNMENT_VACATION_BUFFER_DAYS = 14;
  46. private $testMode = false;
  47. private $testEmailTeacher = 'thelincius@gmail.com';
  48. // private $testPhoneTeacher = '37065520239';
  49. private $testPhoneTeacher = '37063794090';
  51. // private $testEmailGuardian = 'tomas970506@gmail.com';
  52. private $testEmailGuardian = 'apolskis.linas@gmail.com';
  53. // private $testPhoneGuardian = '37065520239';
  54. private $testPhoneGuardian = '37063794090';
  55. private ReminderConfigurationRepository $reminderConfigurationRepository;
  56. private UrlGeneratorInterface $urlGenerator;
  57. private SmsService $smsService;
  58. private EntityManagerInterface $entityManager;
  59. private ContainerInterface $container;
  60. private RequestStack $requestStack;
  61. private LessonRepository $lessonRepository;
  62. private MessageBusInterface $bus;
  63. private LessonDeletedRepository $lessonDeletedRepository;
  64. private PaymentService $paymentService;
  65. private MessageBusInterface $messageBus;
  66. private TeacherRepository $teacherRepository;
  67. private ChildPreferenceTimeRepository $childPreferenceTimeRepository;
  68. private ChildPreferenceRepository $childPreferenceRepository;
  69. private ChildPreferenceHistoryRepository $childPreferenceHistoryRepository;
  70. private SerializerInterface $serializer;
  71. private TeacherSickLeavesRepository $teacherSickLeavesRepository;
  72. private TeacherHolidayRepository $teacherHolidayRepository;
  73. private TeacherUnavailableRangeRepository $teacherUnavailableRangeRepository;
  74. private NotificationService $notificationService;
  75. private GetStreamService $getStreamService;
  76. private FcmService $fcmService;
  77. private UserFireBaseTokenRepository $userFireBaseTokenRepository;
  78. private LessonDeletionService $lessonDeletionService;
  79. private GuardianLogService $guardianLogService;
  82. public function __construct(
  83. SmsService $smsService,
  84. LessonRepository $lessonRepository,
  85. EntityManagerInterface $entityManager,
  86. ContainerInterface $container,
  87. RequestStack $requestStack,
  88. UrlGeneratorInterface $urlGenerator,
  89. ReminderConfigurationRepository $reminderConfigurationRepository,
  90. MessageBusInterface $bus,
  91. LessonDeletedRepository $lessonDeletedRepository,
  92. PaymentService $paymentService,
  93. MessageBusInterface $messageBus,
  94. TeacherRepository $teacherRepository,
  95. ChildPreferenceTimeRepository $childPreferenceTimeRepository,
  96. ChildPreferenceRepository $childPreferenceRepository,
  97. ChildPreferenceHistoryRepository $childPreferenceHistoryRepository,
  98. ChildPreferenceDeclineHistoryRepository $childPreferenceDeclineHistoryRepository,
  99. SerializerInterface $serializer,
  100. TeacherSickLeavesRepository $teacherSickLeavesRepository,
  101. TeacherHolidayRepository $teacherHolidayRepository,
  102. TeacherUnavailableRangeRepository $teacherUnavailableRangeRepository,
  103. NotificationService $notificationService,
  104. GetStreamService $getStreamService,
  105. FcmService $fcmService,
  106. UserFireBaseTokenRepository $userFireBaseTokenRepository,
  107. LessonDeletionService $lessonDeletionService,
  108. GuardianLogService $guardianLogService
  109. )
  110. {
  111. $this->entityManager = $entityManager;
  112. $this->container = $container;
  113. $this->requestStack = $requestStack;
  114. $this->reminderConfigurationRepository = $reminderConfigurationRepository;
  115. $this->urlGenerator = $urlGenerator;
  116. $this->smsService = $smsService;
  117. $this->lessonRepository = $lessonRepository;
  118. $this->bus = $bus;
  119. $this->lessonDeletedRepository = $lessonDeletedRepository;
  120. $this->paymentService = $paymentService;
  121. $this->messageBus = $messageBus;
  122. $this->teacherRepository = $teacherRepository;
  123. $this->childPreferenceTimeRepository = $childPreferenceTimeRepository;
  124. $this->childPreferenceRepository = $childPreferenceRepository;
  125. $this->childPreferenceHistoryRepository = $childPreferenceHistoryRepository;
  126. $this->childPreferenceDeclineHistoryRepository = $childPreferenceDeclineHistoryRepository;
  127. $this->serializer = $serializer;
  128. $this->teacherSickLeavesRepository = $teacherSickLeavesRepository;
  129. $this->teacherHolidayRepository = $teacherHolidayRepository;
  130. $this->teacherUnavailableRangeRepository = $teacherUnavailableRangeRepository;
  131. $this->notificationService = $notificationService;
  132. $this->getStreamService = $getStreamService;
  133. $this->fcmService = $fcmService;
  134. $this->userFireBaseTokenRepository = $userFireBaseTokenRepository;
  135. $this->lessonDeletionService = $lessonDeletionService;
  136. $this->guardianLogService = $guardianLogService;
  137. }
  139. public function assignTeacher(ChildPreference $childPreferenceObjectToAssign, ?Child $child = null, ?Teacher $teacherToForceAssign = null, $maxClass = null, $debug = false)
  140. {
  141. if(!$child)
  142. {
  143. $child = $childPreferenceObjectToAssign->getChild();
  144. }
  146. $this->entityManager->refresh($childPreferenceObjectToAssign);
  147. if($childPreferenceObjectToAssign->getStatus() == ChildPreference::STATUS_ASSIGNED['value'])
  148. {
  149. return;
  150. }
  152. // if(in_array($childPreferenceObjectToAssign->getStatus(), ['CANCELLED','NOT_FOUND']))
  153. // {
  154. if(!$debug) {
  155. foreach ($childPreferenceObjectToAssign->getChildPreferenceTimes() as $childPreferenceTime) {
  156. $childPreferenceObjectToAssign->removeChildPreferenceTime($childPreferenceTime);
  157. $this->entityManager->remove($childPreferenceTime);
  158. $this->entityManager->flush();
  159. }
  160. $childPreferenceObjectToAssign->setTeacher(null);
  161. $childPreferenceObjectToAssign->setStatus(ChildPreference::STATUS_TO_ASSIGN['value']);
  162. $this->entityManager->persist($childPreferenceObjectToAssign);
  163. $this->entityManager->flush();
  164. }
  165. // }
  167. //First filter teachers by status, discipline, class, available
  168. $discipline = $childPreferenceObjectToAssign->getDiscipline();
  169. $class = $child->getClass();
  170. $minClass = $child->getClass();
  171. if(!$maxClass) {
  172. $maxClass = $child->getClass();
  173. }
  174. $amount = $childPreferenceObjectToAssign->getEmailDuration() / $childPreferenceObjectToAssign->getSingleEmailDuration();
  175. $duration = $childPreferenceObjectToAssign->getEmailDuration();
  176. $school = $child->getSchool();
  177. $ielts = $child->isFlagIelts();
  179. $flagRU = $child->getFlagRU();
  180. $flagPL = $child->getFlagPL();
  181. $flagENG = $child->getFlagENG();
  182. $flagIB = $child->getFlagIB();
  183. $flagDyslexia = $child->getFlagDyslexia();
  185. $flagVbeOver90 = $child->isVbeOver90();
  186. $flagExperienceOver12Month = $child->isExperienceOver12Month();
  187. $flagExperienceAtSchool = $child->isFlagExperienceAtSchool();
  189. //Optional
  190. $flagSensitive = $child->getFlagSensitive();
  191. $gender = $child->getGender();
  192. $flagStrict = $child->isFlagStrict();
  194. //dump($class);
  195. //die();
  196. // $condition = "dc.maxClass {$classSearchType} :class AND dc.discipline = :discipline";
  197. // $condition = '';
  198. // foreach ($class as $selectedClass)
  199. // {
  200. // if($condition)
  201. // {
  202. // $condition .= ' OR ';
  203. // }
  204. // $selectedClass = str_replace('–', '%', $selectedClass);
  205. // $selectedClass = str_replace('š', '%', $selectedClass);
  206. // $condition = "dc.classes like '%{$selectedClass}%' AND dc.discipline = :discipline";
  207. // }
  210. // $classSearchType = $form->get('classSearchType')->getData() ? '=' : '>=';
  218. $busyTeacherIds = [];
  220. $busyTeachers = $this->childPreferenceRepository
  221. ->createQueryBuilder('c')
  222. ->select('teacher.id')
  223. ->leftJoin('c.teacher', 'teacher')
  224. ->where('c.status = :status')
  225. ->setParameter('status', ChildPreference::STATUS_ASSIGNED['value'])
  226. ->getQuery()
  227. ->getArrayResult();
  229. foreach ($busyTeachers as $busyTeacherId)
  230. {
  231. $busyTeacherIds[] = $busyTeacherId['id'];
  232. }
  233. $declinedAt = new \DateTime();
  234. $declinedAt->modify('-3 hours');
  235. $query = $this->childPreferenceDeclineHistoryRepository->createQueryBuilder('a');
  236. $query
  237. ->andWhere('a.declinedAt > :declined_at')
  238. ->setParameter('declined_at', $declinedAt);
  240. $histories = $query->getQuery()->getResult();
  242. /** @var ChildPreferenceDeclineHistory $history */
  243. foreach ($histories as $history)
  244. {
  245. if($history && $history->getTeacher()) {
  246. $busyTeacherIds[] = $history->getTeacher()->getId();
  247. }
  248. }
  251. $sickLeaves = $this
  252. ->teacherSickLeavesRepository
  253. ->createQueryBuilder('t')
  254. ->andWhere('t.dateStart <= :currentTime')
  255. ->andWhere('t.dateEnd >= :currentTime')
  256. ->setParameter('currentTime', new \DateTime())
  257. ->getQuery()
  258. ->getResult();
  260. /** @var TeacherSickLeaves $sickLeave */
  261. foreach ($sickLeaves as $sickLeave)
  262. {
  263. $busyTeacherIds[] = $sickLeave->getTeacher()->getId();
  264. }
  266. // Also excludes a holiday that hasn't started yet but starts soon: a
  267. // teacher whose vacation begins within NEW_CHILD_ASSIGNMENT_VACATION_BUFFER_DAYS
  268. // must not be handed new children whose first lessons would land right
  269. // before/inside it (see [issue: teacher 2197 vacation]). A vacation
  270. // further out than that is not excluded here — it's still safe, since
  271. // generateLessonsForChildPreference() marks any occurrence landing
  272. // inside it as INFORMED_MISSED regardless of how far away it is.
  273. $vacationSoonThreshold = (new \DateTime())->modify(
  274. '+' . self::NEW_CHILD_ASSIGNMENT_VACATION_BUFFER_DAYS . ' days'
  275. );
  276. $teacherHolidays = $this
  277. ->teacherHolidayRepository
  278. ->createQueryBuilder('t')
  279. ->andWhere('t.dateStart <= :vacationSoonThreshold')
  280. ->andWhere('t.dateEnd >= :currentTime')
  281. ->setParameter('vacationSoonThreshold', $vacationSoonThreshold)
  282. ->setParameter('currentTime', new \DateTime())
  283. ->getQuery()
  284. ->getResult();
  286. /** @var TeacherHoliday $teacherHoliday */
  287. foreach ($teacherHolidays as $teacherHoliday)
  288. {
  289. $busyTeacherIds[] = $teacherHoliday->getTeacher()->getId();
  290. }
  292. $teacherUnavailableRanges = $this
  293. ->teacherUnavailableRangeRepository
  294. ->createQueryBuilder('t')
  295. ->andWhere('t.startTime <= :currentTime')
  296. ->andWhere('t.endTime >= :currentTime')
  297. ->setParameter('currentTime', new \DateTime())
  298. ->getQuery()
  299. ->getResult();
  301. /** @var TeacherUnavailableRange $teacherUnavailableRange */
  302. foreach ($teacherUnavailableRanges as $teacherUnavailableRange)
  303. {
  304. $busyTeacherIds[] = $teacherUnavailableRange->getTeacher()->getId();
  305. }
  307. // dump($busyTeacherIds);
  308. // die();
  310. $query = $this->teacherRepository->createQueryBuilder('t');
  311. $query
  312. ->andWhere('t.roles LIKE :roles')
  313. ->setParameter('roles', '%"ROLE_TEACHER"%');
  315. if($debug)
  316. {
  317. dump('busy teachers:');
  318. dump($busyTeacherIds);
  319. }
  322. $declinedAt = new \DateTime();
  323. $declinedAt->modify('-72 hours');
  324. $histories = $this->childPreferenceDeclineHistoryRepository->createQueryBuilder('a')
  325. ->andWhere('a.declinedAt > :declined_at')
  326. ->setParameter('declined_at', $declinedAt)
  327. ->andWhere('a.discipline = :discipline')
  328. ->setParameter('discipline', $discipline)
  329. ->andWhere('a.child = :child')
  330. ->setParameter('child', $child)
  331. ->getQuery()
  332. ->getResult();
  334. if(count($histories) >= 2) {
  335. $query->andWhere('t.flagAutoAcceptAssignment = 1');
  336. }
  338. $busyTeacherIds = array_filter($busyTeacherIds);
  339. if($busyTeacherIds && !$teacherToForceAssign) {
  340. $query
  341. ->andWhere('t.id NOT IN (:busyTeacherIds)')
  342. ->setParameter('busyTeacherIds', $busyTeacherIds);
  343. }
  345. if($teacherToForceAssign)
  346. {
  347. $query
  348. ->andWhere('t.id = :teacherToForceAssign')
  349. ->setParameter('teacherToForceAssign', $teacherToForceAssign->getId());
  350. }
  353. $available = $duration / 60;
  355. if($minClass == 0){
  356. $minClass = 'Priešmokyklinukai';
  357. }
  358. if($maxClass == 0){
  359. $maxClass = 'Priešmokyklinukai';
  360. }
  362. if($minClass == 13){
  363. $minClass = 'Suaugę';
  364. }
  365. if($maxClass == 13){
  366. $maxClass = 'Suaugę';
  367. }
  370. $availableClasses = [
  371. 'Priešmokyklinukai' => 'Priešmokyklinukai',
  372. 1 => 1,
  373. 2 => 2,
  374. 3 => 3,
  375. 4 => 4,
  376. 5 => 5,
  377. 6 => 6,
  378. 7 => 7,
  379. 8 => 8,
  380. 9 => 9,
  381. 10 => 10,
  382. 11 => 11,
  383. 12 => 12,
  384. 'Suaugę' => 'Suaugę',
  385. ];
  386. $selectedClassesRange = [];
  387. $doNotIncludeClassesRange = [];
  388. if(!$maxClass && !$minClass){
  389. return new JsonResponse([
  390. "data" => [],
  391. 'timeSlots' => [],
  392. ]);
  393. }
  394. elseif($maxClass && !$minClass) {
  395. foreach ($availableClasses as $class) {
  396. if($class != $maxClass) {
  397. continue;
  398. }
  399. $selectedClassesRange[] = $class;
  400. if($class == $maxClass) {
  401. break;
  402. }
  403. }
  404. $reached = false;
  405. foreach ($availableClasses as $class) {
  406. if($class != $maxClass && !$reached) {
  407. continue;
  408. }
  409. if($reached) {
  410. $doNotIncludeClassesRange[] = $class;
  411. }
  412. $reached = true;
  413. }
  414. }
  415. elseif(!$maxClass && $minClass)
  416. {
  417. foreach ($availableClasses as $class) {
  418. if($class != $minClass && !$selectedClassesRange) {
  419. continue;
  420. }
  421. $selectedClassesRange[] = $class;
  422. }
  423. }
  424. elseif($maxClass && $minClass)
  425. {
  426. foreach ($availableClasses as $class) {
  427. if($class != $minClass && !$selectedClassesRange) {
  428. continue;
  429. }
  430. $selectedClassesRange[] = $class;
  431. if($class == $maxClass) {
  432. break;
  433. }
  434. }
  436. $reached = false;
  437. foreach ($availableClasses as $class) {
  438. if($class != $maxClass && !$reached) {
  439. continue;
  440. }
  441. if($reached) {
  442. $doNotIncludeClassesRange[] = $class;
  443. }
  444. $reached = true;
  445. }
  446. }
  447. $condition = '';
  449. if($debug)
  450. {
  451. dump('selectedClassesRange:');
  452. dump($selectedClassesRange);
  453. dump('doNotIncludeClassesRange:');
  454. dump($doNotIncludeClassesRange);
  455. }
  456. $hiddenCases = "";
  457. // dump($selectedClassesRange);
  458. // die();
  459. if($selectedClassesRange) {
  461. foreach ($selectedClassesRange as $class) {
  462. if(!$condition)
  463. {
  464. $condition .= '( ';
  465. }
  466. if(substr($condition, -2, 2) == '1 ' || substr($condition, -3, 3) == "%' ")
  467. {
  468. $condition .= 'OR ';
  469. }
  470. if(is_int($class)) {
  471. $condition .= "JSON_CONTAINS(dc.classYears, '{$class}') = 1 ";
  472. }
  474. else
  475. {
  476. if($class == 'Suaugę')
  477. {
  478. $condition .= "dc.classes like '%Suaug%' ";
  479. }
  480. if($class == 'Priešmokyklinukai')
  481. {
  482. $condition .= "dc.classes like '%mokyklinukai%' ";
  483. }
  484. }
  485. }
  486. $condition .= ") AND dc.discipline = :discipline";
  487. if($flagVbeOver90){
  488. $condition .= " AND dc.vbe >= 90 ";
  489. }
  490. }
  492. if($doNotIncludeClassesRange)
  493. {
  494. // $condition .= " AND ( ";
  496. foreach ($doNotIncludeClassesRange as $class) {
  497. // if(substr($condition, -2, 2) == '0 ' || substr($condition, -3, 3) == "%' ")
  498. // {
  499. // $condition .= ' AND ';
  500. // }
  501. if(is_int($class)) {
  502. // $condition .= " JSON_CONTAINS(dc.classYears, '{$class}') = 0 ";
  503. //
  504. //
  505. if($hiddenCases)
  506. {
  507. $hiddenCases.= ' + ';
  508. }
  509. $hiddenCases .= "(CASE WHEN JSON_CONTAINS(dc.classYears, '{$class}') = 0 THEN -1 ELSE 0 END)";
  510. }
  512. else
  513. {
  514. if($class == 'Suaugę')
  515. {
  516. // $condition .= " dc.classes not like '%Suaug%' ";
  518. if($hiddenCases)
  519. {
  520. $hiddenCases.= ' + ';
  521. }
  522. $hiddenCases .= "(CASE WHEN dc.classes not like '%Suaug%' THEN -1 ELSE 0 END)";
  523. }
  524. if($class == 'Priešmokyklinukai')
  525. {
  526. // $condition .= " dc.classes not like '%mokyklinukai%' ";
  528. if($hiddenCases)
  529. {
  530. $hiddenCases.= ' + ';
  531. }
  532. $hiddenCases .= "(CASE WHEN dc.classes not like '%mokyklinukai%' THEN -1 ELSE 0 END)";
  533. }
  534. }
  535. }
  537. // $condition .= " ) ";
  538. }
  542. // dump($condition);
  543. // die();
  544. $query
  545. ->andWhere('t.status = :status')
  546. ->setParameter('status', Teacher::STATUS_ACTIVE)
  547. ->andWhere('t.workedHours <= :workedHours')
  548. ->setParameter('workedHours', 1424)
  549. ->andWhere('t.available >= :available')
  550. ->setParameter('available', $available)
  551. ->innerJoin('t.teacherDisciplineClasses', 'dc', 'WITH', $condition)
  552. ->setParameter('discipline', $discipline);
  554. if($debug)
  555. {
  556. dump($condition);
  557. }
  560. if ($ielts) { $query->andWhere('t.ielts > 0'); }
  561. if ($flagRU) { $query->andWhere('t.flagRU = :flagRU')->setParameter('flagRU', $flagRU); }
  562. if ($flagPL) { $query->andWhere('t.flagPL = :flagPL')->setParameter('flagPL', $flagPL); }
  563. if ($flagENG) { $query->andWhere('t.flagENG = :flagENG')->setParameter('flagENG', $flagENG); }
  564. if ($flagIB) {
  565. $query->andWhere('t.flagIB = :flagIB')->setParameter('flagIB', $flagIB);
  566. }
  567. else
  568. {
  569. $query->andWhere('t.flagOnlyIB IS NULL OR t.flagOnlyIB = :flagOnlyIB')->setParameter('flagOnlyIB', 0);
  570. }
  571. if ($flagDyslexia) { $query->andWhere('t.flagDyslexia = :flagDyslexia')->setParameter('flagDyslexia', $flagDyslexia); }
  572. if ($flagSensitive) { $query->andWhere('t.flagSensitive = :flagSensitive')->setParameter('flagSensitive', $flagSensitive); }
  573. if ($flagStrict) { $query->andWhere('t.flagStrict = :flagStrict')->setParameter('flagStrict', $flagStrict); }
  574. if ($flagExperienceAtSchool) { $query->andWhere('t.flagExperienceAtSchool = :flagExperienceAtSchool')->setParameter('flagExperienceAtSchool', $flagExperienceAtSchool); }
  575. $dateNow = new \DateTime();
  576. $dateNow->modify('-1 year');
  577. if ($flagExperienceOver12Month) { $query->andWhere('t.workStart <= :workStart')->setParameter('workStart', $dateNow); }
  579. if ($school) { $query->andWhere('t.school = :school')->setParameter('school', $school); }
  580. if ($gender && $gender != 'Nesvarbu')
  581. {
  582. $query->andWhere('t.gender = :gender')->setParameter('gender', $gender);
  583. }
  585. // $query->addSelect("0 AS HIDDEN ORD ");
  588. //optional
  589. // $dateNow = new \DateTime();
  590. // $dateNow->modify('-1 year');
  591. // if ($flagExperienceOver12Month)
  592. // {
  593. // if($hiddenCases)
  594. // {
  595. // $hiddenCases.= ' + ';
  596. // }
  597. // $hiddenCases .= "(CASE WHEN t.workStart <= :workStart THEN 1 ELSE 0 END)";
  598. // $query->setParameter('workStart', $dateNow);
  599. //
  600. // $query
  601. // ->andWhere('t.workedHours >= :workedHours2')
  602. // ->setParameter('workedHours2', 840);
  603. // }
  604. // if ($gender && $gender != 'Nesvarbu')
  605. // {
  606. // if($hiddenCases)
  607. // {
  608. // $hiddenCases.= ' + ';
  609. // }
  610. // $hiddenCases .= "(CASE WHEN t.gender = :gender THEN 1 ELSE 0 END)";
  611. // $query->setParameter('gender', $gender);
  612. // }
  613. // if ($flagExperienceAtSchool)
  614. // {
  615. // if($hiddenCases)
  616. // {
  617. // $hiddenCases.= ' + ';
  618. // }
  619. // $hiddenCases .= "(CASE WHEN t.flagExperienceAtSchool = :flagExperienceAtSchool THEN 1 ELSE 0 END)";
  620. // $query->setParameter('flagExperienceAtSchool', $flagExperienceAtSchool);
  621. // }
  622. if($hiddenCases)
  623. {
  624. $hiddenCases.= ' + ';
  625. }
  626. $hiddenCases .= "(CASE WHEN t.flagPriorityAssignment = :flagPriorityAssignment THEN 1 ELSE 0 END)";
  627. $query->setParameter('flagPriorityAssignment', 1);
  629. $workStart30d = new \DateTime();
  630. $workStart30d->modify('-30 days');
  631. if($hiddenCases)
  632. {
  633. $hiddenCases.= ' + ';
  634. }
  635. $hiddenCases .= "(CASE WHEN t.workStart >= :workStart30d THEN 2 ELSE 0 END)";
  636. $query->setParameter('workStart30d', $workStart30d);
  638. $workStart60d = new \DateTime();
  639. $workStart60d->modify('-60 days');
  640. if($hiddenCases)
  641. {
  642. $hiddenCases.= ' + ';
  643. }
  644. $hiddenCases .= "(CASE WHEN t.workStart >= :workStart60d AND t.workStart <= :workStart30d THEN 1 ELSE 0 END)";
  645. $query->setParameter('workStart60d', $workStart60d);
  647. if($hiddenCases)
  648. {
  649. $hiddenCases.= ' + ';
  650. }
  651. $hiddenCases .= "(CASE WHEN t.workStart >= :workStart60d AND t.workStart <= :workStart30d THEN 1 ELSE 0 END)";
  653. if ($hiddenCases)
  654. {
  655. $hiddenCases .= ' + ';
  656. }
  657. $hiddenCases .= "(CASE
  658. WHEN SIZE(t.childPreferences) = 0 THEN 3
  659. WHEN SIZE(t.childPreferences) = 1 THEN 2
  660. WHEN SIZE(t.childPreferences) = 2 THEN 1
  661. ELSE 0
  662. END)";
  664. $twoWeeksAgo = new \DateTime();
  665. $twoWeeksAgo->modify('-14 days');
  667. if ($hiddenCases)
  668. {
  669. $hiddenCases .= ' + ';
  670. }
  671. $hiddenCases .= "(CASE
  672. WHEN (
  673. (SELECT COUNT(cp2.id) FROM App\\Entity\\ChildPreference cp2 WHERE cp2.teacher = t AND cp2.assignedAt >= :twoWeeksAgo) = 0
  674. AND (t.available < (0.5 * t.maxLoad))
  675. ) THEN 3
  676. ELSE 0
  677. END)";
  678. $query->setParameter('twoWeeksAgo', $twoWeeksAgo);
  681. // if ($hiddenCases)
  682. // {
  683. // $hiddenCases .= ' + ';
  684. // }
  685. // $hiddenCases .= "(CASE WHEN t.maxLoad - t.available >= 4 THEN -10 ELSE 0 END)";
  688. if($hiddenCases)
  689. {
  690. $hiddenCases.= ' + ';
  691. }
  692. $hiddenCases .= "(CASE WHEN t.flagAutoAcceptAssignment = :flagAutoAcceptAssignment THEN 2 ELSE 0 END)";
  693. $query->setParameter('flagAutoAcceptAssignment', 1);
  696. if($hiddenCases)
  697. {
  698. $hiddenCases.= ' + ';
  699. }
  700. $hiddenCases .= "(CASE WHEN t.levelName = :level1 THEN 3 ELSE 0 END)";
  701. $query->setParameter('level1', 'Senior Tutor');
  705. if($hiddenCases)
  706. {
  707. $hiddenCases.= ' + ';
  708. }
  709. $hiddenCases .= "(CASE WHEN t.levelName = :level2 THEN 2 ELSE 0 END)";
  710. $query->setParameter('level2', 'Pro Tutor');
  712. if($hiddenCases)
  713. {
  714. $hiddenCases.= ' + ';
  715. }
  716. $hiddenCases .= "(CASE WHEN t.levelName = :level3 THEN 1 ELSE 0 END)";
  717. $query->setParameter('level3', 'Expert Tutor');
  720. if($hiddenCases) {
  721. $hiddenSql = "({$hiddenCases}) AS HIDDEN ORD";
  722. $query->addSelect($hiddenSql);
  723. $query->addOrderBy('ORD', 'DESC');
  724. }
  725. //dump($hiddenSql);
  726. $query->addOrderBy('t.available', 'DESC');
  727. // dump($query->getQuery()->getSQL());
  728. // die();
  729. $teachers = $query
  730. ->getQuery()
  731. ->getResult();
  733. // if($_SERVER['REMOTE_ADDR'] == '86.38.84.66' && $maxClass == 4) {
  734. // dump($teachers);
  735. // die();
  736. // }
  738. //Filter by times
  739. $startTime1Priority = false;
  740. $startTime2Priority = false;
  741. $startTime3Priority = false;
  742. $startTime4Priority = false;
  743. $startTime5Priority = false;
  744. $startTime6Priority = false;
  745. $startTime7Priority = false;
  746. $startTime1 = false;
  747. $startTime2 = false;
  748. $startTime3 = false;
  749. $startTime4 = false;
  750. $startTime5 = false;
  751. $startTime6 = false;
  752. $startTime7 = false;
  753. $endTime1 = false;
  754. $endTime2 = false;
  755. $endTime3 = false;
  756. $endTime4 = false;
  757. $endTime5 = false;
  758. $endTime6 = false;
  759. $endTime7 = false;
  760. $fittingTimes = $childPreferenceObjectToAssign->getChild()->getFittingTimes();
  761. if($childPreferenceObjectToAssign->getFittingTimes())
  762. {
  763. $fittingTimes = $childPreferenceObjectToAssign->getFittingTimes();
  764. }
  765. $fittingTimes = str_replace(PHP_EOL, '', $fittingTimes);
  766. $fittingTimes = str_replace("\r", '', $fittingTimes);
  767. $fittingTimes = str_replace(" ", '', $fittingTimes);
  768. $fittingTimes = explode(';', $fittingTimes);
  769. $fittingTimes = array_filter($fittingTimes);
  771. foreach ($fittingTimes as $fittingTime) {
  772. $fittingDates = explode(',', $fittingTime);
  773. if(!isset($fittingDates[1]))
  774. {
  775. continue;
  776. }
  777. $fittingHours = explode('-', $fittingDates[1]);
  778. $fittingHours[0] = new \Datetime("1970-01-01 ".$fittingHours[0]);
  779. $fittingHours[1] = new \Datetime("1970-01-01 ".$fittingHours[1]);
  781. if ($fittingDates[0] == 'Pirmadienis') {
  782. $startTime1 = $fittingHours[0];
  783. $endTime1 = $fittingHours[1];
  784. }
  785. if ($fittingDates[0] == 'Antradienis') {
  786. $startTime2 = $fittingHours[0];
  787. $endTime2 = $fittingHours[1];
  788. }
  789. if ($fittingDates[0] == 'Trečiadienis') {
  790. $startTime3 = $fittingHours[0];
  791. $endTime3 = $fittingHours[1];
  792. }
  793. if ($fittingDates[0] == 'Ketvirtadienis') {
  794. $startTime4 = $fittingHours[0];
  795. $endTime4 = $fittingHours[1];
  796. }
  797. if ($fittingDates[0] == 'Penktadienis') {
  798. $startTime5 = $fittingHours[0];
  799. $endTime5 = $fittingHours[1];
  800. }
  801. if ($fittingDates[0] == 'Šeštadienis') {
  802. $startTime6 = $fittingHours[0];
  803. $endTime6 = $fittingHours[1];
  804. }
  805. if ($fittingDates[0] == 'Sekmadienis') {
  806. $startTime7 = $fittingHours[0];
  807. $endTime7 = $fittingHours[1];
  808. }
  809. }
  811. $fittingTimes = $childPreferenceObjectToAssign->getChild()->getFittingTimesPriority();
  812. if($childPreferenceObjectToAssign->getFittingTimesPriority())
  813. {
  814. $fittingTimes = $childPreferenceObjectToAssign->getFittingTimesPriority();
  815. }
  817. if($fittingTimes == null)
  818. {
  819. $fittingTimes = '';
  820. }
  822. $fittingTimes = str_replace(PHP_EOL, '', $fittingTimes);
  823. $fittingTimes = str_replace("\r", '', $fittingTimes);
  824. $fittingTimes = str_replace(" ", '', $fittingTimes);
  825. $fittingTimes = explode(';', $fittingTimes);
  826. $fittingTimes = array_filter($fittingTimes);
  828. foreach ($fittingTimes as $fittingTime) {
  829. $fittingDates = explode(',', $fittingTime);
  830. $fittingHours = explode('-', $fittingDates[1]);
  831. $fittingHours[0] = new \Datetime("1970-01-01 ".$fittingHours[0]);
  832. $fittingHours[1] = new \Datetime("1970-01-01 ".$fittingHours[1]);
  834. if ($fittingDates[0] == 'Pirmadienis') {
  835. $startTime1 = $fittingHours[0];
  836. $endTime1 = $fittingHours[1];
  837. $startTime1Priority = true;
  838. }
  839. if ($fittingDates[0] == 'Antradienis') {
  840. $startTime2 = $fittingHours[0];
  841. $endTime2 = $fittingHours[1];
  842. $startTime2Priority = true;
  843. }
  844. if ($fittingDates[0] == 'Trečiadienis') {
  845. $startTime3 = $fittingHours[0];
  846. $endTime3 = $fittingHours[1];
  847. $startTime3Priority = true;
  848. }
  849. if ($fittingDates[0] == 'Ketvirtadienis') {
  850. $startTime4 = $fittingHours[0];
  851. $endTime4 = $fittingHours[1];
  852. $startTime4Priority = true;
  853. }
  854. if ($fittingDates[0] == 'Penktadienis') {
  855. $startTime5 = $fittingHours[0];
  856. $endTime5 = $fittingHours[1];
  857. $startTime5Priority = true;
  858. }
  859. if ($fittingDates[0] == 'Šeštadienis') {
  860. $startTime6 = $fittingHours[0];
  861. $endTime6 = $fittingHours[1];
  862. $startTime6Priority = true;
  863. }
  864. if ($fittingDates[0] == 'Sekmadienis') {
  865. $startTime7 = $fittingHours[0];
  866. $endTime7 = $fittingHours[1];
  867. $startTime7Priority = true;
  868. }
  869. }
  871. $timesOriginal = [
  872. 1 => ['start' => $startTime1, 'end' => $endTime1, 'priority' => $startTime1Priority, 'weekday' => 1],
  873. 2 => ['start' => $startTime2, 'end' => $endTime2, 'priority' => $startTime2Priority, 'weekday' => 2],
  874. 3 => ['start' => $startTime3, 'end' => $endTime3, 'priority' => $startTime3Priority, 'weekday' => 3],
  875. 4 => ['start' => $startTime4, 'end' => $endTime4, 'priority' => $startTime4Priority, 'weekday' => 4],
  876. 5 => ['start' => $startTime5, 'end' => $endTime5, 'priority' => $startTime5Priority, 'weekday' => 5],
  877. 6 => ['start' => $startTime6, 'end' => $endTime6, 'priority' => $startTime6Priority, 'weekday' => 6],
  878. 7 => ['start' => $startTime7, 'end' => $endTime7, 'priority' => $startTime7Priority, 'weekday' => 7],
  879. ];
  881. $availableTeachers = [];
  882. $availableTimeSlots = [];
  884. // dump($teachers);
  885. // die();
  886. //dump($timesOriginal);
  887. //die();
  888. if($debug)
  889. {
  890. dump('Teachers:');
  891. foreach ($teachers as $teacher) {
  892. dump($teacher->getId().' '.$teacher->getFullName().' '.$teacher->getAvailable());
  893. }
  894. dump('Times:');
  895. dump($timesOriginal);
  896. }
  897. $workEndCheck = new \DateTime();
  899. /**
  900. * @var Teacher $teacher
  901. */
  902. foreach ($teachers as $teacherKey => $teacher) {
  903. // if($teacher->getId() != 1){
  904. // continue;
  905. // }
  907. if ($teacher->getAvailable() < $available || $teacher->getAvailable() < 1) {
  908. unset($teachers[$teacherKey]);
  909. continue;
  910. }
  911. $teacherWorkEnd = null;
  912. if($teacher->getWorkEnd())
  913. {
  914. $teacherWorkEnd = clone $teacher->getWorkEnd();
  915. $teacherWorkEnd->modify('-60 days');
  916. }
  917. // 2025-10-25 2025-12-08
  918. if ($teacherWorkEnd && $teacherWorkEnd < $workEndCheck) {
  919. unset($teachers[$teacherKey]);
  920. continue;
  921. }
  923. $foundAvailableTimeSlots = 0;
  924. $availableTimeSlotsTeacher = [];
  927. $addedWeekdays = [];
  928. foreach ($teacher->getTeacherAvailabilityTimes() as $teacherAvailabilityTime) {
  929. $times = $timesOriginal;
  930. if($teacherAvailabilityTime->getStartTime() >= $teacherAvailabilityTime->getEndTime()) {
  931. continue;
  932. }
  933. //dump($times);
  934. //die();
  935. $weekday = $teacherAvailabilityTime->getWeekday();
  937. if ($times[$weekday]['start'] && $times[$weekday]['end']) {
  938. // $debug = [
  939. // "searchStart"=>$times[$weekday]['start'],
  940. // "searchEnd"=>$times[$weekday]['end'],
  941. // "teacherFoundStart"=>$teacherAvailabilityTime->getStartTime(),
  942. // "teacherFoundEnd"=>$teacherAvailabilityTime->getEndTime(),
  943. // "ifState1"=>($teacherAvailabilityTime->getEndTime() < $times[$weekday]['end'] && $teacherAvailabilityTime->getStartTime() > $times[$weekday]['start']),
  944. // "ifState2"=>( $times[$weekday]['start'] < $teacherAvailabilityTime->getStartTime() && $times[$weekday]['end'] < $teacherAvailabilityTime->getEndTime() && $teacherAvailabilityTime->getStartTime() < $times[$weekday]['end']),
  945. // "ifState3"=>($times[$weekday]['end'] > $teacherAvailabilityTime->getEndTime() && $times[$weekday]['start'] > $teacherAvailabilityTime->getStartTime() && $times[$weekday]['start'] < $teacherAvailabilityTime->getEndTime() )
  946. // ];
  947. // dump($debug);
  948. // die();
  949. //20:00 < 19:01 and 17:00 > 16:00
  950. // dump($teacherAvailabilityTime->getEndTime());
  951. // dump($times[$weekday]['end']);
  952. // die();
  953. if ($teacherAvailabilityTime->getEndTime() <= $times[$weekday]['end'] && $teacherAvailabilityTime->getStartTime() >= $times[$weekday]['start']) {
  954. $times[$weekday]['end'] = $teacherAvailabilityTime->getEndTime();
  955. $times[$weekday]['start'] = $teacherAvailabilityTime->getStartTime();
  957. } // 16:00 < 17:00 ir 20:00 < 20:00
  958. else if ($times[$weekday]['start'] < $teacherAvailabilityTime->getStartTime() && $times[$weekday]['end'] < $teacherAvailabilityTime->getEndTime() && $teacherAvailabilityTime->getStartTime() < $times[$weekday]['end']) {
  959. $times[$weekday]['start'] = $teacherAvailabilityTime->getStartTime();
  960. } else if ($times[$weekday]['end'] > $teacherAvailabilityTime->getEndTime() && $times[$weekday]['start'] > $teacherAvailabilityTime->getStartTime() && $times[$weekday]['start'] < $teacherAvailabilityTime->getEndTime()) {
  961. $times[$weekday]['end'] = $teacherAvailabilityTime->getEndTime();
  962. }
  963. $afterIfs = [
  964. 'afterStart' => $times[$weekday]['start'],
  965. 'afterEnd' => $times[$weekday]['end']
  966. ];
  968. if ($teacherAvailabilityTime->getStartTime() <= $times[$weekday]['start'] && $teacherAvailabilityTime->getEndTime() >= $times[$weekday]['end']) {
  969. // dump('x');
  970. // die();
  971. $childPreferenceTimes = [];
  972. $start = clone $teacherAvailabilityTime->getStartTime();
  973. $end = clone $teacherAvailabilityTime->getEndTime();
  974. $childPreferenceTimesQuery = $this->childPreferenceTimeRepository->createQueryBuilder('cpt');
  975. $childPreferenceTimesSide = $childPreferenceTimesQuery
  976. ->leftJoin('cpt.childPreference', 'cp')
  977. ->andWhere('cp.teacher = :teacher')
  978. ->andWhere('cp.endTime IS NULL OR cp.endTime >= :CPendTime')
  979. ->andWhere('cpt.startTime >= :startTime')
  980. ->andWhere('cpt.endTime <= :endTime')
  981. ->andWhere('cpt.weekday = :weekday')
  982. ->setParameter('teacher', $teacher)
  983. ->setParameter('startTime', $start)
  984. ->setParameter('endTime', $end)
  985. ->setParameter('weekday', $weekday)
  986. ->setParameter('CPendTime', $childPreferenceObjectToAssign->getStartTime())
  987. ->orderBy('cpt.startTime', 'ASC')
  988. ->getQuery()
  989. ->getResult();
  991. foreach ($childPreferenceTimesSide as $childPreferenceTimesSideElement) {
  992. if (!in_array($childPreferenceTimesSideElement, $childPreferenceTimes)) {
  993. $childPreferenceTimes[] = $childPreferenceTimesSideElement;
  994. }
  995. }
  997. $start = clone $teacherAvailabilityTime->getStartTime();
  998. $end = clone $teacherAvailabilityTime->getEndTime();
  999. $childPreferenceTimesQuery = $this->childPreferenceTimeRepository->createQueryBuilder('cpt');
  1000. $childPreferenceTimesSide = $childPreferenceTimesQuery
  1001. ->leftJoin('cpt.childPreference', 'cp')
  1002. ->andWhere('cp.teacher = :teacher')
  1003. ->andWhere('cp.endTime IS NULL OR cp.endTime >= :CPendTime')
  1004. ->andWhere('cpt.startTime <= :startTime')
  1005. ->andWhere('cpt.endTime >= :startTime')
  1006. ->andWhere('cpt.weekday = :weekday')
  1007. ->setParameter('teacher', $teacher)
  1008. ->setParameter('startTime', $start)
  1009. ->setParameter('weekday', $weekday)
  1010. ->setParameter('CPendTime', $childPreferenceObjectToAssign->getStartTime())
  1011. ->orderBy('cpt.startTime', 'ASC')
  1012. ->getQuery()
  1013. ->getResult();
  1015. foreach ($childPreferenceTimesSide as $childPreferenceTimesSideElement) {
  1016. if (!in_array($childPreferenceTimesSideElement, $childPreferenceTimes)) {
  1017. $childPreferenceTimes[] = $childPreferenceTimesSideElement;
  1018. }
  1019. }
  1021. $start = clone $teacherAvailabilityTime->getStartTime();
  1022. $end = clone $teacherAvailabilityTime->getEndTime();
  1023. $childPreferenceTimesQuery = $this->childPreferenceTimeRepository->createQueryBuilder('cpt');
  1024. $childPreferenceTimesSide = $childPreferenceTimesQuery
  1025. ->leftJoin('cpt.childPreference', 'cp')
  1026. ->andWhere('cp.teacher = :teacher')
  1027. ->andWhere('cp.endTime IS NULL OR cp.endTime >= :CPendTime')
  1028. ->andWhere('cpt.startTime <= :endTime')
  1029. ->andWhere('cpt.endTime >= :endTime')
  1030. ->andWhere('cpt.weekday = :weekday')
  1031. ->setParameter('teacher', $teacher)
  1032. ->setParameter('endTime', $end)
  1033. ->setParameter('CPendTime', $childPreferenceObjectToAssign->getStartTime())
  1034. ->setParameter('weekday', $weekday)
  1035. ->orderBy('cpt.startTime', 'ASC')
  1036. ->getQuery()
  1037. ->getResult();
  1038. foreach ($childPreferenceTimesSide as $childPreferenceTimesSideElement) {
  1039. if (!in_array($childPreferenceTimesSideElement, $childPreferenceTimes)) {
  1040. $childPreferenceTimes[] = $childPreferenceTimesSideElement;
  1041. }
  1042. }
  1044. //child Part
  1046. $start = clone $teacherAvailabilityTime->getStartTime();
  1047. $end = clone $teacherAvailabilityTime->getEndTime();
  1048. $childPreferenceTimesQuery = $this->childPreferenceTimeRepository->createQueryBuilder('cpt');
  1049. $childPreferenceTimesQuery
  1050. ->leftJoin('cpt.childPreference', 'cp')
  1051. ->andWhere('cp.child = :child')
  1052. ->andWhere('cpt.startTime >= :startTime')
  1053. ->andWhere('cpt.endTime <= :endTime')
  1054. ->andWhere('cpt.weekday = :weekday')
  1055. ->setParameter('child', $childPreferenceObjectToAssign->getChild())
  1056. ->setParameter('startTime', $start)
  1057. ->setParameter('endTime', $end)
  1058. ->setParameter('weekday', $weekday)
  1059. ->orderBy('cpt.startTime', 'ASC');
  1062. if($childPreferenceObjectToAssign->getStartTime())
  1063. {
  1064. $childPreferenceTimesQuery
  1065. ->andWhere('cp.endTime IS NULL OR cp.endTime >= :CPstartTime')->setParameter('CPstartTime', $childPreferenceObjectToAssign->getStartTime());
  1066. }
  1068. $childPreferenceTimesSide = $childPreferenceTimesQuery->getQuery()->getResult();
  1070. foreach ($childPreferenceTimesSide as $childPreferenceTimesSideElement) {
  1071. if (!in_array($childPreferenceTimesSideElement, $childPreferenceTimes)) {
  1072. $childPreferenceTimes[] = $childPreferenceTimesSideElement;
  1073. }
  1074. }
  1076. $start = clone $teacherAvailabilityTime->getStartTime();
  1077. $end = clone $teacherAvailabilityTime->getEndTime();
  1078. $childPreferenceTimesQuery = $this->childPreferenceTimeRepository->createQueryBuilder('cpt');
  1079. $childPreferenceTimesQuery
  1080. ->leftJoin('cpt.childPreference', 'cp')
  1081. ->andWhere('cp.child = :child')
  1082. ->andWhere('cpt.startTime <= :startTime')
  1083. ->andWhere('cpt.endTime >= :startTime')
  1084. ->andWhere('cpt.weekday = :weekday')
  1085. ->setParameter('child', $childPreferenceObjectToAssign->getChild())
  1086. ->setParameter('startTime', $start)
  1087. ->setParameter('weekday', $weekday)
  1088. ->orderBy('cpt.startTime', 'ASC');
  1090. if($childPreferenceObjectToAssign->getStartTime())
  1091. {
  1092. $childPreferenceTimesQuery
  1093. ->andWhere('cp.endTime IS NULL OR cp.endTime >= :CPstartTime')->setParameter('CPstartTime', $childPreferenceObjectToAssign->getStartTime());
  1094. }
  1096. $childPreferenceTimesSide = $childPreferenceTimesQuery->getQuery()->getResult();
  1097. foreach ($childPreferenceTimesSide as $childPreferenceTimesSideElement) {
  1098. if (!in_array($childPreferenceTimesSideElement, $childPreferenceTimes)) {
  1099. $childPreferenceTimes[] = $childPreferenceTimesSideElement;
  1100. }
  1101. }
  1103. $start = clone $teacherAvailabilityTime->getStartTime();
  1104. $end = clone $teacherAvailabilityTime->getEndTime();
  1105. $childPreferenceTimesQuery = $this->childPreferenceTimeRepository->createQueryBuilder('cpt');
  1106. $childPreferenceTimesQuery
  1107. ->leftJoin('cpt.childPreference', 'cp')
  1108. ->andWhere('cp.child = :child')
  1109. ->andWhere('cpt.startTime <= :endTime')
  1110. ->andWhere('cpt.endTime >= :endTime')
  1111. ->andWhere('cpt.weekday = :weekday')
  1112. ->setParameter('child', $childPreferenceObjectToAssign->getChild())
  1113. ->setParameter('endTime', $end)
  1114. ->setParameter('weekday', $weekday)
  1115. ->orderBy('cpt.startTime', 'ASC');
  1117. if($childPreferenceObjectToAssign->getStartTime())
  1118. {
  1119. $childPreferenceTimesQuery
  1120. ->andWhere('cp.endTime IS NULL OR cp.endTime >= :CPstartTime')->setParameter('CPstartTime', $childPreferenceObjectToAssign->getStartTime());
  1121. }
  1123. $childPreferenceTimesSide = $childPreferenceTimesQuery->getQuery()->getResult();
  1125. /** @var ChildPreferenceTime $childPreferenceTimesSideElement */
  1126. foreach ($childPreferenceTimesSide as $childPreferenceTimesSideElement) {
  1127. if (!in_array($childPreferenceTimesSideElement, $childPreferenceTimes)) {
  1128. $childPreferenceTimes[] = $childPreferenceTimesSideElement;
  1129. }
  1130. }
  1133. /**
  1134. * @var ChildPreferenceTime $childPreferenceTime
  1135. */
  1136. foreach ($childPreferenceTimes as $key => $childPreferenceTime) {
  1137. $start = clone $childPreferenceTime->getStartTime();
  1138. $end = clone $childPreferenceTime->getEndTime();
  1139. if($teacherAvailabilityTime->getTeacher()->getGapBetweenAssignments())
  1140. {
  1141. $start->modify('-'.$teacherAvailabilityTime->getTeacher()->getGapBetweenAssignments().' minutes');
  1142. $end->modify('+'.$teacherAvailabilityTime->getTeacher()->getGapBetweenAssignments().' minutes');
  1143. }
  1144. if ($end <= $times[$weekday]['start']) {
  1145. unset($childPreferenceTimes[$key]);
  1146. }
  1147. if ($start >= $times[$weekday]['end']) {
  1148. unset($childPreferenceTimes[$key]);
  1149. }
  1150. }
  1152. usort($childPreferenceTimes,
  1153. static fn($a, $b) => $a->getStartTime() <=> $b->getStartTime()
  1154. );
  1156. $childPreferenceTimes = array_values(array_filter($childPreferenceTimes));
  1160. if (count($childPreferenceTimes) == 0) {
  1161. //There are no child preferences just check if slot time
  1162. $slotTimeDuration = date_diff($times[$weekday]['start'], $times[$weekday]['end']);
  1163. $slotTime = (int)$slotTimeDuration->i + (int)$slotTimeDuration->h * 60;
  1164. // if($_SERVER['REMOTE_ADDR'] == '86.38.84.66' && $maxClass == 4) {
  1165. // dump($slotTime);
  1166. // dump($duration);
  1167. // }
  1168. if ($slotTime >= $duration/$amount) {
  1170. if(in_array($weekday, $addedWeekdays)) {
  1171. continue;
  1172. }
  1174. $foundAvailableTimeSlots++;
  1175. $availableTimeSlotsTeacher[] = [
  1176. '0start' => $times[$weekday]['start'],
  1177. '1end' => $times[$weekday]['end'],
  1178. 'weekday' => $weekday
  1179. ];
  1181. $addedWeekdays[] = $weekday;
  1183. continue;
  1184. }
  1185. }
  1187. //Find slots between other child preferences
  1188. /**
  1189. * @var ChildPreferenceTime $childPreferenceTime
  1190. */
  1191. foreach ($childPreferenceTimes as $key => $childPreferenceTime) {
  1192. $start = clone $childPreferenceTime->getStartTime();
  1193. $end = clone $childPreferenceTime->getEndTime();
  1194. if($teacherAvailabilityTime->getTeacher()->getGapBetweenAssignments())
  1195. {
  1196. $start->modify('-'.$teacherAvailabilityTime->getTeacher()->getGapBetweenAssignments().' minutes');
  1197. $end->modify('+'.$teacherAvailabilityTime->getTeacher()->getGapBetweenAssignments().' minutes');
  1198. }
  1199. if ($key == 0 && $start >= $times[$weekday]['start']) {
  1200. $slotTimeDuration = date_diff($times[$weekday]['start'], $start);
  1201. $slotTime = (int)$slotTimeDuration->i + (int)$slotTimeDuration->h * 60;
  1202. if ($slotTime >= $duration/$amount) {
  1204. if(in_array($weekday, $addedWeekdays)) {
  1205. continue;
  1206. }
  1208. $foundAvailableTimeSlots++;
  1209. $availableTimeSlotsTeacher[] = [
  1210. '0start' => $times[$weekday]['start'],
  1211. '1end' => $start,
  1212. 'weekday' => $weekday
  1213. ];
  1215. $addedWeekdays[] = $weekday;
  1216. continue 2;
  1217. }
  1218. }
  1221. if ($key + 1 == count($childPreferenceTimes) && $end <= $times[$weekday]['end']) {
  1222. //Last element
  1223. $slotTimeDuration = date_diff($end, $times[$weekday]['end']);
  1224. $slotTime = (int)$slotTimeDuration->i + (int)$slotTimeDuration->h * 60;
  1225. if ($slotTime >= $duration/$amount) {
  1227. if(in_array($weekday, $addedWeekdays)) {
  1228. continue;
  1229. }
  1231. $foundAvailableTimeSlots++;
  1232. $availableTimeSlotsTeacher[] = [
  1233. '0start' => $end,
  1234. '1end' => $times[$weekday]['end'],
  1235. 'weekday' => $weekday
  1236. ];
  1238. $addedWeekdays[] = $weekday;
  1239. continue 2;
  1240. }
  1241. } elseif ($end <= $times[$weekday]['end']) {
  1242. //Not last element
  1243. /**
  1244. * @var ChildPreferenceTime $nextChildPreferenceTime
  1245. */
  1246. $nextChildPreferenceTime = $childPreferenceTimes[$key + 1];
  1247. $nextStart = clone $nextChildPreferenceTime->getStartTime();
  1248. if($teacherAvailabilityTime->getTeacher()->getGapBetweenAssignments()){
  1249. $nextStart->modify('-'.$teacherAvailabilityTime->getTeacher()->getGapBetweenAssignments().' minutes');
  1250. }
  1251. if ($end >= $nextStart) {
  1252. continue;
  1253. }
  1254. $slotTimeDuration = date_diff($end, $nextStart);
  1255. $slotTime = (int)$slotTimeDuration->i + (int)$slotTimeDuration->h * 60;
  1256. if ($slotTime >= $duration/$amount) {
  1258. if(in_array($weekday, $addedWeekdays)) {
  1259. continue;
  1260. }
  1262. $foundAvailableTimeSlots++;
  1263. $availableTimeSlotsTeacher[] = [
  1264. '0start' => $end,
  1265. '1end' => $nextStart,
  1266. 'weekday' => $weekday
  1267. ];
  1269. $addedWeekdays[] = $weekday;
  1270. continue 2;
  1271. }
  1272. }
  1273. }
  1277. }
  1278. }
  1279. }
  1280. // if($_SERVER['REMOTE_ADDR'] == '86.38.84.66' && $maxClass == 4) {
  1281. // dump($foundAvailableTimeSlots);
  1282. // dump($amount);
  1283. // dump($teacher->getId());
  1284. // die();
  1285. // }
  1288. // die();
  1289. if ($foundAvailableTimeSlots >= $amount) {
  1290. $availableTeachers[] = $teacher;
  1291. $availableTimeSlots[] = [
  1292. 'times' => $availableTimeSlotsTeacher,
  1293. 'teacher' => $teacher->getFullname(true)
  1294. ];
  1295. }
  1296. // else
  1297. // {
  1298. // unset($teachers[$key]);
  1299. // }
  1301. }
  1303. $teachers = $this->serializer->normalize($availableTeachers, null, ['groups' => "TeacherList"]);
  1305. $dateNow = new \DateTime();
  1306. foreach ($teachers as $key => $teacher)
  1307. {
  1308. $teacherObj = $this->teacherRepository->find($teacher['id']);
  1310. $teacherHolidaysString = '';
  1311. foreach ($teacherObj->getTeacherHolidays() as $teacherHoliday)
  1312. {
  1313. if($teacherHoliday->getDateEnd() > $dateNow)
  1314. {
  1315. if($teacherHolidaysString)
  1316. {
  1317. $teacherHolidaysString .= '<br>';
  1318. }
  1319. $teacherHolidaysString .= "Nuo: {$teacherHoliday->getDateStart()->format('Y-m-d')} <br> Iki: {$teacherHoliday->getDateEnd()->format('Y-m-d')}";
  1320. }
  1321. }
  1322. $teachers[$key]['holiday'] = $teacherHolidaysString;
  1323. $teachers[$key]['fullname'] = $teacherObj->getFullname(true);
  1325. $teachers[$key]['have_moved_lessons'] = false;
  1327. $teachers[$key]['unavailableUntil'] = '';
  1328. foreach ($teacher['teacherUnavailableRanges'] as $teacherUnavailableRange)
  1329. {
  1330. if(new \DateTime($teacherUnavailableRange['startTime']) < new \DateTime() && new \DateTime($teacherUnavailableRange['endTime']) > new \DateTime())
  1331. {
  1332. $teachers[$key]['unavailableUntil'] = $teacherUnavailableRange['endTime'];
  1333. }
  1334. }
  1337. foreach ($timesOriginal as $weekdayKey => $originalTime) {
  1338. if (!$originalTime['start'] || !$originalTime['end']) {
  1339. continue;
  1340. }
  1343. $weeksToSearch = [0,1,2];
  1344. foreach ($weeksToSearch as $weekToSearch) {
  1345. $end = new \DateTime($originalTime['end']->format('H:i'));
  1346. $start = new \DateTime($originalTime['start']->format('H:i'));
  1348. $end->modify("next {$this->getWeekdayEnglishFromNumber($weekdayKey)}");
  1349. $end->setTime($originalTime['end']->format('H'), $originalTime['end']->format('i'));
  1350. $start->modify("next {$this->getWeekdayEnglishFromNumber($weekdayKey)}");
  1351. $start->setTime($originalTime['start']->format('H'), $originalTime['start']->format('i'));
  1352. $end->modify("+{$weekToSearch} weeks");
  1353. $start->modify("+{$weekToSearch} weeks");
  1355. $query = $this->lessonRepository->createQueryBuilder('l');
  1356. $lessons = $query
  1357. ->andWhere('l.teacher = :teacher')
  1358. ->setParameter('teacher', $teacherObj)
  1359. ->andWhere('l.status = :status')
  1360. ->setParameter('status', Lesson::STATUS_REGULAR_MOVED['value'])
  1361. ->andWhere('l.startTime < :end')
  1362. ->setParameter('end', $end)
  1363. ->andWhere('l.endTime > :start')
  1364. ->setParameter('start', $start)
  1365. ->getQuery()
  1366. ->getResult();
  1369. if ($lessons) {
  1370. unset($teachers[$key]);
  1371. unset($availableTimeSlots[$key]);
  1372. break;
  1373. }
  1374. }
  1375. }
  1376. }
  1378. foreach ($availableTimeSlots as $key => &$availableTimeSlot) {
  1380. $priorities = array_column($timesOriginal, 'priority', 'weekday');
  1382. usort($availableTimeSlot['times'], function($a, $b) use ($priorities) {
  1383. $priorityA = $priorities[$a['weekday']] ?? false;
  1384. $priorityB = $priorities[$b['weekday']] ?? false;
  1385. if ($priorityA === $priorityB) {
  1386. return 0;
  1387. }
  1388. return $priorityA ? -1 : 1;
  1389. });
  1391. // $availableTimeSlots['times'] = [];
  1392. // dump($availableTimeSlot);
  1393. // dump($timesOriginal);
  1394. // dump($times);
  1395. // die();
  1396. }
  1397. // dump($timesOriginal);
  1398. // die();
  1399. // dump($availableTimeSlots);
  1400. // die();
  1401. //if($_SERVER['REMOTE_ADDR'] == '78.63.47.47') {
  1402. // foreach ($teachers as $teacher)
  1403. // {
  1404. // dump($teacher['fullname']);
  1405. // }
  1406. // dump($teachers);
  1407. //// dump(["data" => $timesOriginal, 'timeSlots' => $availableTimeSlots]);
  1408. // dump($timesOriginal);
  1410. // dump($availableTimeSlots);
  1411. //// dump($childPreferenceObjectToAssign->getChildPreferenceTimes()->getValues());
  1412. //// dump($availableTimeSlots[1]['times'][0]);
  1413. // die();
  1414. //}
  1416. $this->entityManager->refresh($childPreferenceObjectToAssign);
  1417. if($childPreferenceObjectToAssign->getStatus() == ChildPreference::STATUS_ASSIGNED['value'])
  1418. {
  1419. return;
  1420. }
  1422. if($debug)
  1423. {
  1424. dump('availableTimeSlots:');
  1425. dump($availableTimeSlots);
  1426. }
  1427. $firstKey = array_key_first($teachers);
  1428. // if($_SERVER['REMOTE_ADDR'] == '78.63.47.47') {
  1429. // $firstKey = 1;
  1430. // }
  1431. if(isset($teachers[$firstKey]) && $teachers[$firstKey])
  1432. {
  1433. if(!count($childPreferenceObjectToAssign->getChildPreferenceTimes()->getValues())) {
  1434. for($i = 0; $i < $amount; $i++) {
  1435. if (isset($availableTimeSlots[$firstKey]['times'][$i]['weekday'])) {
  1436. if(!$debug)
  1437. {
  1438. $childPreferenceTime = (new ChildPreferenceTime())
  1439. ->setChildPreference($childPreferenceObjectToAssign)
  1440. ->setCreatedAt(new \DateTime())
  1441. ->setWeekday($availableTimeSlots[$firstKey]['times'][$i]['weekday'])
  1442. ->setStartTime((new \DateTime("{$availableTimeSlots[$firstKey]['times'][$i]['0start']->format('H:i')}")))
  1443. ->setEndTime((new \DateTime("{$availableTimeSlots[$firstKey]['times'][$i]['0start']->format('H:i')}"))->modify("+{$childPreferenceObjectToAssign->getSingleEmailDuration()} minutes"));
  1444. // if($_SERVER['REMOTE_ADDR'] == '78.63.47.47') {
  1445. // dump($availableTimeSlots[$firstKey]);
  1446. // dump($childPreferenceTime);
  1447. // die();
  1448. // }
  1449. $this->entityManager->persist($childPreferenceTime);
  1450. $childPreferenceObjectToAssign->addChildPreferenceTime($childPreferenceTime);
  1451. $this->entityManager->persist($childPreferenceObjectToAssign);
  1452. $this->entityManager->flush();
  1453. }
  1454. }
  1455. }
  1456. }
  1457. // if($_SERVER['REMOTE_ADDR'] == '78.63.47.47') {
  1458. // die();
  1459. // }
  1460. if(!$debug) {
  1461. $oldChildPreferenceObjectToAssign = clone $childPreferenceObjectToAssign;
  1462. $childPreferenceObjectToAssign->setTeacher($this->teacherRepository->find($teachers[$firstKey]['id']));
  1463. $childPreferenceObjectToAssign->setStatus(ChildPreference::STATUS_ASSIGNED['value']);
  1464. $childPreferenceObjectToAssign->setAssignedAt(new \DateTime());
  1465. $childPreferenceObjectToAssign->setAssignedAutomaticly(new \DateTime());
  1466. $this->entityManager->persist($childPreferenceObjectToAssign);
  1467. $this->entityManager->flush();
  1469. $this->guardianLogService->addGuardianActionLog(
  1470. "Automatinis priskyrimas ({$childPreferenceObjectToAssign->getChild()->getFullname()} {$childPreferenceObjectToAssign->getDiscipline()->getName()}): {$childPreferenceObjectToAssign->getTeacher()->getFullname()}",
  1471. $childPreferenceObjectToAssign->getChild()->getGuardian(),
  1472. $childPreferenceObjectToAssign,
  1473. 'update'
  1474. );
  1475. $this->entityManager->flush();
  1477. $this->handleStatusChange($oldChildPreferenceObjectToAssign, $childPreferenceObjectToAssign);
  1478. }
  1480. if($debug)
  1481. {
  1482. die();
  1483. }
  1485. }
  1486. // elseif ($maxClass < 13)
  1487. // {
  1488. // $maxClass++;
  1489. // $this->assignTeacher($childPreferenceObjectToAssign, $child ,$teacherToForceAssign, $maxClass, $debug);
  1490. // }
  1491. else {
  1492. if($debug)
  1493. {
  1494. die();
  1495. }
  1496. $childPreferenceObjectToAssign->setStatus(ChildPreference::STATUS_NOT_FOUND['value']);
  1497. $this->entityManager->persist($childPreferenceObjectToAssign);
  1498. $this->entityManager->flush();
  1499. }
  1501. }
  1504. public function sendAssignedNotification(ChildPreference $childPreference)
  1505. {
  1506. $guardian = $childPreference->getChild()->getGuardian();
  1507. $child = $childPreference->getChild();
  1508. $teacher = $childPreference->getTeacher();
  1510. $message = "Sveiki,
  1511. Pirmasis mūsų užsiėmimas jau netoliese, jeigu turite klausimų, galite parašyti čia.
  1512. Iki pasimatymo!
  1513. {$childPreference->getTeacher()->getFullname()}
  1514. ";
  1516. try {
  1517. $this->getStreamService->sendMessage($teacher, $guardian, $message);
  1518. $this->getStreamService->sendMessage($teacher, $child, $message);
  1519. }
  1520. catch (\Exception $e)
  1521. {
  1523. }
  1525. if(!$guardian->getMobileAppLastUsedAt()) {
  1526. $dateToSendAt = new \DateTime();
  1527. $this->messageBus->dispatch(new Envelope(new SendSMSMessage($guardian->getPhoneNumber(), '', ['[GUARDIAN_ID]' => $guardian->getId()], 'GUARDIAN_MISSED_MESSAGE'), [
  1528. DelayStamp::delayUntil($dateToSendAt),
  1529. ]));
  1531. $dateToSendAt = new \DateTime();
  1532. $dateToSendAt->modify('+24 hours');
  1533. $dateToSendAt->setTime(9, 0, 0);
  1534. $this->messageBus->dispatch(new Envelope(new SendSMSMessage($guardian->getPhoneNumber(), '', ['[GUARDIAN_ID]' => $guardian->getId()], 'GUARDIAN_MISSED_MESSAGE'), [
  1535. DelayStamp::delayUntil($dateToSendAt),
  1536. ]));
  1538. $dateToSendAt = new \DateTime();
  1539. $dateToSendAt->modify('+48 hours');
  1540. $dateToSendAt->setTime(9, 0, 0);
  1541. $this->messageBus->dispatch(new Envelope(new SendSMSMessage($guardian->getPhoneNumber(), '', ['[GUARDIAN_ID]' => $guardian->getId()], 'GUARDIAN_MISSED_MESSAGE'), [
  1542. DelayStamp::delayUntil($dateToSendAt),
  1543. ]));
  1545. $dateToSendAt = new \DateTime();
  1546. $dateToSendAt->modify('+72 hours');
  1547. $dateToSendAt->setTime(9, 0, 0);
  1548. $this->messageBus->dispatch(new Envelope(new SendSMSMessage($guardian->getPhoneNumber(), '', ['[GUARDIAN_ID]' => $guardian->getId()], 'GUARDIAN_MISSED_MESSAGE'), [
  1549. DelayStamp::delayUntil($dateToSendAt),
  1550. ]));
  1551. }
  1552. }
  1555. public function handleStatusChange(ChildPreference $oldChildPreference, ChildPreference $childPreference, $oldChildPreferenceTimes = [])
  1556. {
  1557. if ($oldChildPreference->getStatus() != $childPreference->getStatus() && $childPreference->getStatus() == ChildPreference::STATUS_AUTOMATIC_ASSIGNMENT['value']) {
  1558. $dateToSendAt = new \DateTime();
  1560. $this->messageBus->dispatch(new Envelope(new AssignChildPreferenceTeacherMessage($childPreference->getId(), $childPreference->getTeacher()), [
  1561. DelayStamp::delayUntil($dateToSendAt),
  1562. ]));
  1563. }
  1565. //Jeigu keiciasi mokytojas, metam i priskirta
  1566. //Notif 0
  1567. if ($oldChildPreference->getTeacher() != $childPreference->getTeacher() || ($oldChildPreference->getStatus() != $childPreference->getStatus() && $childPreference->getStatus() == ChildPreference::STATUS_ASSIGNED['value'])) {
  1568. $childPreference->setStatus(ChildPreference::STATUS_ASSIGNED['value']);
  1569. $childPreference->setAssignedAt(new \DateTime());
  1570. $childPreference->setTeacherAssignRemindCount(0);
  1571. $this->entityManager->persist($childPreference);
  1572. $this->entityManager->flush();
  1574. if($childPreference->getTeacher() && $childPreference->getTeacher()->isFlagAutoAcceptAssignment())
  1575. {
  1577. if ($childPreference->getChild()->getLessonsEnd()) {
  1578. $child = $childPreference->getChild();
  1579. $child->setLessonsEnd(null);
  1580. $this->entityManager->persist($child);
  1581. $this->entityManager->flush();
  1582. }
  1584. $childPreference->setStatus(ChildPreference::STATUS_ACCEPTED['value']);
  1585. $childPreference->setAcceptedAt(new \Datetime());
  1586. $startTime = $this->findFirstLessonDate($childPreference);
  1587. if($startTime) {
  1588. $childPreference->setStartTime($startTime);
  1589. }
  1590. $oldChildPreference = clone $childPreference;
  1591. $this->entityManager->persist($childPreference);
  1592. $this->entityManager->flush();
  1593. $this->entityManager->refresh($childPreference);
  1594. $this->generateLessonsForChildPreference($childPreference);
  1595. if($startTime) {
  1596. $this->recalculatePricesForFurtherLessons($childPreference->getChild()->getGuardian(), $startTime);
  1597. }
  1599. $this->sendAcceptedEmailAndSMS($childPreference);
  1600. $this->sendAssignedNotification($childPreference);
  1602. $teacherComments = $this->findPreviousComments($childPreference);
  1604. $teacherCommentsString = '';
  1605. if ($teacherComments) {
  1606. foreach ($teacherComments as $teacherComment) {
  1607. $date = $teacherComment->getCreatedAt()->format('Y-m-d');
  1608. $teacherCommentsString .= "<strong>{$date}</strong>:<br>{$teacherComment->getComment()}<br>";
  1609. }
  1610. }
  1612. $preferenceSummary = "";
  1614. foreach ($childPreference->getChildPreferenceTimes() as $childPreferenceTime) {
  1615. $preferenceSummary .= "{$childPreferenceTime->getWeekdayString()} {$childPreferenceTime->getStartTime()->format('H:i')}-{$childPreferenceTime->getEndTime()->format('H:i')}<br>";
  1616. }
  1617. $replacements = [
  1618. '[CHILD_NAME]' => $childPreference->getChild()->getFullname(),
  1619. '[DISCIPLINE_SHORT_NAME]' => $childPreference->getDiscipline()->getName(),
  1620. '[FIRST_LESSON_DATE]' => $childPreference->getStartTime()->format('Y-m-d H:i'),
  1621. '[GUARDIAN_NAME]' => $childPreference->getChild()->getGuardian()->getFullname(),
  1622. '[CHILD_CLASS]' => $childPreference->getChild()->getClass(),
  1623. '[SINGLE_LESSON_AMOUNT]' => $childPreference->getAmount(),
  1624. '[SINGLE_LESSON_DURATION]' => $childPreference->getSingleEmailDuration(),
  1625. '[PREFERENCES_TIMES_SUMMARY]' => $preferenceSummary,
  1626. '[FIRST_LESSON_DATE_TIME]' => $childPreference->getStartTime()->format('Y-m-d H:i'),
  1627. '[PREFERENCE_COMMENT]' => $childPreference->getComment(),
  1628. '[TEACHER_COMMENTS]' => $teacherCommentsString,
  1629. '[GUARDIAN_EMAIL]' => $childPreference->getChild()->getGuardian()->getEmail(),
  1630. '[CHILD_EMAIL]' => $childPreference->getChild()->getEmail(),
  1631. ];
  1632. $this->notificationService->sendNotificationTemplate($childPreference->getTeacher(),'TEACHER_NEW_AUTO_ACCEPT_ASSIGNMENT', $replacements, true);
  1633. if($childPreference->getTeacher() && $childPreference->getTeacher()->getPhoneNumber()) {
  1634. $this->messageBus->dispatch(new SendSMSMessage($childPreference->getTeacher()->getPhoneNumber(), '', $replacements, 'ASSIGNMENT_NEW_AUTO_NOTIF_1'));
  1635. }
  1637. }
  1638. if (!$childPreference->getIgnoreNotifications() && (!$childPreference->getTeacher() || !$childPreference->getTeacher()->isFlagAutoAcceptAssignment())) {
  1639. $this->sendAssignedEmailandSMS($childPreference);
  1640. }
  1642. }
  1644. //Jeigu mokytojas patvirtino
  1645. //Notif 1
  1646. if ($oldChildPreference->getStatus() != $childPreference->getStatus() && $childPreference->getStatus() == ChildPreference::STATUS_ACCEPTED['value'] && $childPreference->getTeacher()) {
  1647. $this->sendAcceptedEmailAndSMS($childPreference);
  1648. }
  1650. //Jeigu keicia mokytoja, uzsetinam priezasti jeigu jos neirase tiesiog.
  1651. if ($childPreference->getTeacherChange() && !$childPreference->getTerminateReason()) {
  1652. if ($childPreference->getTeacherChange() == 'teacherChangeTeacher') {
  1653. $childPreference->setTerminateReason('Korepetitoriaus prašymu');
  1654. }
  1655. if ($childPreference->getTeacherChange() == 'teacherChangeGuardian') {
  1656. $childPreference->setTerminateReason('Kliento prašymas');
  1657. }
  1658. if ($childPreference->getTeacherChange() == 'amountDiscipline') {
  1659. $childPreference->setTerminateReason('Dažnio/ krūvio/ disciplinos keitimas');
  1660. }
  1661. $this->entityManager->persist($childPreference);
  1662. $this->entityManager->flush();
  1663. }
  1665. //Jeigu nera priezasties, nesaugom ir pabaigos datos. Administracijos klaida.
  1666. if (!$childPreference->getTerminateReason() && $childPreference->getEndTime()) {
  1667. $childPreference->setEndTime(null);
  1668. $this->entityManager->persist($childPreference);
  1669. $this->entityManager->flush();
  1670. }
  1672. //Jeigu tiesiog nutraukia uzsiemimus
  1673. //Notif 2
  1674. if (!$oldChildPreference->getEndTime() && $childPreference->getTerminateReason() && $childPreference->getEndTime() && !$childPreference->getTeacherChange() && $childPreference->getTeacher()) {
  1675. $childPreference->setStatus(ChildPreference::STATUS_TERMINATING['value']);
  1676. $this->entityManager->persist($childPreference);
  1677. $this->entityManager->flush();
  1678. $this->deleteLessonAfterPreferenceEndPeriod($childPreference);
  1679. if (!$childPreference->getIgnoreNotifications()) {
  1680. $this->sendTerminatingEmailAndSMS($childPreference);
  1681. }
  1682. }
  1684. //Jeigu nutraukia su senu mokytoju, bet skirs nauja keiciasi mokytojas
  1685. if ($childPreference->getTeacherChange() && $childPreference->getEndTime() && !$oldChildPreference->getTerminateReason() && !$oldChildPreference->getEndTime() && $childPreference->getTeacher()) {
  1686. $childPreference->setStatus(ChildPreference::STATUS_TERMINATING['value']);
  1687. //Notif 3
  1689. $this->deleteLessonAfterPreferenceEndPeriod($childPreference);
  1690. $newChildPreference = new ChildPreference();
  1691. $newChildPreference->setChild($childPreference->getChild());
  1692. $newChildPreference->setAdminComment($childPreference->getAdminComment());
  1693. $newChildPreference->setEmailDuration($childPreference->getEmailDuration());
  1694. $newChildPreference->setSingleEmailDuration($childPreference->getSingleEmailDuration());
  1695. $newChildPreference->setDiscipline($childPreference->getDiscipline());
  1696. $newChildPreference->setComment($childPreference->getComment());
  1697. $newChildPreference->setType($childPreference->getType());
  1698. $newChildPreference->setFittingTimes($childPreference->getFittingTimes());
  1699. $this->entityManager->persist($newChildPreference);
  1700. foreach ($childPreference->getChildPreferenceTimes() as $childPreferenceTime) {
  1701. $newChildPreferenceTime = new ChildPreferenceTime();
  1702. $newChildPreferenceTime->setChildPreference($newChildPreference);
  1703. $newChildPreferenceTime->setEndTime($childPreferenceTime->getEndTime());
  1704. $newChildPreferenceTime->setStartTime($childPreferenceTime->getStartTime());
  1705. $newChildPreferenceTime->setWeekday($childPreferenceTime->getWeekday());
  1706. $this->entityManager->persist($newChildPreferenceTime);
  1707. $newChildPreference->addChildPreferenceTime($newChildPreferenceTime);
  1708. }
  1709. $this->entityManager->flush();
  1711. if ($childPreference->getTeacherChange() == 'teacherChangeTeacher') {
  1712. if (!$childPreference->getIgnoreNotifications()) {
  1713. $this->sendTerminatingByTeacherEmailAndSMS($childPreference);
  1714. }
  1715. }
  1716. //Notif 4
  1717. if ($childPreference->getTeacherChange() == 'teacherChangeGuardian') {
  1718. if (!$childPreference->getIgnoreNotifications()) {
  1719. $this->sendTerminatingByGuardianEmailAndSMS($childPreference);
  1720. }
  1721. }
  1722. //Notif 4
  1723. if ($childPreference->getTeacherChange() == 'amountDiscipline') {
  1724. if (!$childPreference->getIgnoreNotifications()) {
  1725. $this->sendTerminatingByChangeEmailAndSMS($childPreference);
  1726. }
  1727. }
  1728. }
  1730. if ($childPreference->getIgnoreNotifications() && $childPreference->getRegenerateLessonsFrom()) {
  1731. $this->deleteLessonBeforeRegenerate($oldChildPreference, $oldChildPreferenceTimes, $childPreference->getRegenerateLessonsFrom());
  1732. $this->generateLessonsForChildPreference($childPreference, $childPreference->getRegenerateLessonsFrom()->format('Y-m-d H:i'));
  1733. }
  1735. if ($childPreference->getRegenerateAllLessons() && $childPreference->getRegenerateLessonsFrom()) {
  1736. $this->deleteChildLessons($childPreference->getChild(), $childPreference->getRegenerateLessonsFrom());
  1737. foreach ($childPreference->getChild()->getChildPreferences() as $childPreferenceForRegenerating) {
  1738. $this->generateLessonsForChildPreference($childPreferenceForRegenerating, $childPreference->getRegenerateLessonsFrom()->format('Y-m-d H:i'));
  1739. }
  1740. }
  1741. }
  1743. public function sendAssignedEmailAndSMS(ChildPreference $childPreference, $onlySMS = false)
  1744. {
  1745. $reminderObject = $this->reminderConfigurationRepository->findOneBy(['reminder_key' => 'ASSIGNMENT_NEW_NOTIF_0']);
  1747. $preferenceSummary = "";
  1749. foreach ($childPreference->getChildPreferenceTimes() as $childPreferenceTime) {
  1750. $preferenceSummary .= "{$childPreferenceTime->getWeekdayString()} {$childPreferenceTime->getStartTime()->format('H:i')}-{$childPreferenceTime->getEndTime()->format('H:i')}<br>";
  1751. }
  1753. $startTime = $childPreference->getStartTime();
  1754. if (!$startTime) {
  1755. $startTime = new \DateTime();
  1756. }
  1758. $childName = $childPreference->getChild()->getFullname();
  1759. $childName = explode(' ', $childName);
  1760. $childName = $childName[0];
  1761. $replacements = [
  1762. '[FIRST_LESSON_DATE]' => "{$this->getWeekdayFromNumber($startTime->format('N'))} {$startTime->format('(Y-m-d) H:i')}",
  1763. '[PREFERENCE_SUMMARY]' => $preferenceSummary,
  1764. '[CHILD_NAME]' => $childName,
  1765. '[CHILD_CLASS]' => $childPreference->getChild()->getClass(),
  1766. '[DISCIPLINE_SHORT_NAME]' => $childPreference->getDiscipline()->getName(),
  1767. '[ACCEPT_LINK]' => 'https://cor.lt' . $this->urlGenerator->generate('app_teacher_my_students'),
  1768. // '[ACCEPT_LINK]' => 'https://corepetitus.tlprojektai.lt' . $this->urlGenerator->generate('app_teacher_my_students'),
  1769. '[CURRENT_TIME]' => (new \DateTime())->format('H:i'),
  1771. ];
  1773. $emailAddress = $childPreference->getTeacher()->getEmail();
  1774. if ($this->testMode) {
  1775. $emailAddress = $this->testEmailTeacher;
  1776. }
  1778. if (!$onlySMS) {
  1779. $this->messageBus->dispatch(new SendMailMessage($emailAddress, '', '', $replacements, 'ASSIGNMENT_NEW_NOTIF_0'));
  1780. }
  1782. $smsContent = $reminderObject->getSmsTemplate();
  1784. $smsContent = str_replace(array_keys($replacements), array_values($replacements), $smsContent);
  1785. $phoneNumber = $childPreference->getTeacher()->getPhoneNumber();
  1786. if ($this->testMode) {
  1787. $phoneNumber = $this->testPhoneTeacher;
  1788. }
  1789. $this->smsService->send($phoneNumber, $smsContent);
  1791. foreach ($this->userFireBaseTokenRepository->findBy(['userClass' => 'teacher', 'userId' => $childPreference->getTeacher()->getId()]) as $userFireBaseToken) {
  1792. $token = $userFireBaseToken->getToken();
  1793. $this->fcmService->send($token, 'Naujas priskyrimas', 'Prašome per 1 val. patvirtinti mokinio priskyrimą');
  1794. }
  1796. }
  1798. private function isDateWithinVacationForDiscipline(Child $child, \DateTimeInterface $date, int $disciplineId): bool
  1799. {
  1800. foreach ($child->getChildVacations() as $vacation) {
  1801. if ($vacation->isIsDeleted()) {
  1802. continue;
  1803. }
  1804. if ($vacation->getDateFrom() >= $date || $vacation->getDateTo() <= $date) {
  1805. continue;
  1806. }
  1807. $vacationDisciplineIds = $vacation->getDisciplineIds();
  1808. if ($vacationDisciplineIds === null || in_array($disciplineId, $vacationDisciplineIds)) {
  1809. return true;
  1810. }
  1811. }
  1813. return false;
  1814. }
  1816. public function sendAcceptedEmailAndSMS(ChildPreference $childPreference)
  1817. {
  1818. $startTime = $childPreference->getStartTime();
  1819. if (!$startTime) {
  1820. $startTime = new \DateTime();
  1821. }
  1823. if ($this->isDateWithinVacationForDiscipline(
  1824. $childPreference->getChild(),
  1825. $startTime,
  1826. $childPreference->getDiscipline()->getId()
  1827. )) {
  1828. return;
  1829. }
  1831. //Tutor Part
  1832. $reminderObject = $this->reminderConfigurationRepository->findOneBy(['reminder_key' => 'ASSIGNMENT_CONFIRMED_TUTOR_NOTIF_1']);
  1834. $preferenceSummary = "";
  1836. foreach ($childPreference->getChildPreferenceTimes() as $childPreferenceTime) {
  1837. $preferenceSummary .= "{$childPreferenceTime->getWeekdayString()} {$childPreferenceTime->getStartTime()->format('H:i')}-{$childPreferenceTime->getEndTime()->format('H:i')}<br>";
  1838. }
  1840. $childName = $childPreference->getChild()->getFullname();
  1841. $childName = explode(' ', $childName);
  1842. $childName = $childName[0];
  1844. $teacherComments = $this->findPreviousComments($childPreference);
  1846. $teacherCommentsString = '';
  1847. if ($teacherComments) {
  1848. $teacherCommentsString = "<strong>Buvusio korepetitoriaus atsiliepimai apie mokinį:</strong><br>";
  1849. foreach ($teacherComments as $teacherComment) {
  1850. $date = $teacherComment->getCreatedAt()->format('Y-m-d');
  1851. $teacherCommentsString .= "<strong>{$date}</strong>:<br>{$teacherComment->getComment()}<br>";
  1852. }
  1853. }
  1855. // dump($teacherCommentsString);
  1856. // die();
  1858. $replacements = [
  1859. '[FIRST_LESSON_DATE]' => "{$this->getWeekdayFromNumber($startTime->format('N'))} {$startTime->format('(Y-m-d) H:i')}",
  1860. '[CHILD_NAME]' => $childName,
  1861. '[DISCIPLINE_SHORT_NAME]' => $childPreference->getDiscipline()->getName(),
  1862. '[PREFERENCES_TIMES_SUMMARY]' => $preferenceSummary,
  1863. '[SINGLE_LESSON_DURATION]' => $childPreference->getSingleEmailDuration(),
  1864. '[SINGLE_LESSON_AMOUNT]' => count($childPreference->getChildPreferenceTimes()),
  1865. '[CHILD_CLASS]' => $childPreference->getChild()->getClass(),
  1866. '[CHILD_EMAIL]' => $childPreference->getChild()->getEmail(),
  1867. '[GUARDIAN_EMAIL]' => $childPreference->getChild()->getGuardian()->getEmail(),
  1868. '[GUARDIAN_NAME]' => $childPreference->getChild()->getGuardian()->getFullname(),
  1869. '[PREFERENCE_COMMENT]' => $childPreference->getComment(),
  1870. '[FIRST_LESSON_DATE_TIME]' => "{$this->getWeekdayFromNumber($startTime->format('N'))} {$startTime->format('(Y-m-d) H:i')}",
  1871. '[TUTOR_FULLNAME]' => $childPreference->getTeacher()->getFullname(),
  1872. '[TUTOR_PHONE]' => $childPreference->getTeacher()->getPhoneNumber(),
  1873. '[TEACHER_COMMENTS]' => $teacherCommentsString,
  1874. '[CURRENT_TIME]' => (new \DateTime())->format('H:i'),
  1876. ];
  1878. $emailAddress = $childPreference->getTeacher()->getEmail();
  1879. if ($this->testMode) {
  1880. $emailAddress = $this->testEmailTeacher;
  1881. }
  1882. $this->bus->dispatch(new SendMailMessage($emailAddress,'','', $replacements, 'ASSIGNMENT_CONFIRMED_TUTOR_NOTIF_1'));
  1885. $smsContent = $reminderObject->getSmsTemplate();
  1887. $smsContent = str_replace(array_keys($replacements), array_values($replacements), $smsContent);
  1888. $phoneNumber = $childPreference->getTeacher()->getPhoneNumber();
  1889. if ($this->testMode) {
  1890. $phoneNumber = $this->testPhoneTeacher;
  1891. }
  1892. // $this->smsService->send($phoneNumber, $smsContent);
  1893. if($phoneNumber) {
  1894. $this->bus->dispatch(new SendSMSMessage($phoneNumber, $smsContent));
  1895. }
  1898. //Guardian Part
  1900. $replacements['[CHILD_NAME]'] = $childPreference->getChild()->getFullname();
  1902. $reminderObject = $this->reminderConfigurationRepository->findOneBy(['reminder_key' => 'ASSIGNMENT_CONFIRMED_GUARDIAN_NOTIF_1']);
  1904. $emailAddress = $childPreference->getChild()->getGuardian()->getEmail();
  1905. if ($this->testMode) {
  1906. $emailAddress = $this->testEmailGuardian;
  1907. }
  1910. $smsContent = $reminderObject->getSmsTemplate();
  1912. $smsContent = str_replace(array_keys($replacements), array_values($replacements), $smsContent);
  1913. $phoneNumber = $childPreference->getChild()->getGuardian()->getPhoneNumber();
  1914. if ($this->testMode) {
  1915. $phoneNumber = $this->testPhoneGuardian;
  1916. }
  1919. $dateNow = new \DateTime();
  1920. $dateMax = new \DateTime();
  1921. $dateMax->setTime(19, 0);
  1922. $dateMin = new \DateTime();
  1923. $dateMin->setTime(8, 59);
  1924. if ($dateNow < $dateMin || $dateNow > $dateMax) {
  1925. $dateToSendAt = new \DateTime();
  1926. if ($dateNow > $dateMax) {
  1927. $dateToSendAt->modify('+1 day');
  1928. }
  1929. $dateToSendAt->setTime(9, 0);
  1931. $this->bus->dispatch(new Envelope(new SendMailMessage($emailAddress,'','', $replacements, 'ASSIGNMENT_CONFIRMED_GUARDIAN_NOTIF_1'), [
  1932. DelayStamp::delayUntil($dateToSendAt),
  1933. ]));
  1935. $this->bus->dispatch(new Envelope(new SendSMSMessage($phoneNumber, $smsContent), [
  1936. DelayStamp::delayUntil($dateToSendAt),
  1937. ]));
  1938. } else {
  1939. //send Now
  1940. $this->bus->dispatch(new SendMailMessage($emailAddress,'','', $replacements, 'ASSIGNMENT_CONFIRMED_GUARDIAN_NOTIF_1'));
  1941. $this->bus->dispatch(new SendSMSMessage($phoneNumber, $smsContent));
  1943. // $this->smsService->send($phoneNumber, $smsContent);
  1944. }
  1945. }
  1947. public function sendTerminatingEmailAndSMS(ChildPreference $childPreference)
  1948. {
  1949. //Tutor Part
  1950. $reminderObject = $this->reminderConfigurationRepository->findOneBy(['reminder_key' => 'ASSIGNMENT_CLIENT_STOP_TUTOR_NOTIF_2']);
  1952. $preferenceSummary = "";
  1954. foreach ($childPreference->getChildPreferenceTimes() as $childPreferenceTime) {
  1955. $preferenceSummary .= "{$childPreferenceTime->getWeekdayString()} {$childPreferenceTime->getStartTime()->format('H:i')}-{$childPreferenceTime->getEndTime()->format('H:i')}<br>";
  1956. }
  1958. $endTime = $childPreference->getEndTime();
  1959. if (!$endTime) {
  1960. $endTime = new \DateTime();
  1961. }
  1963. $replacements = [
  1964. '[LAST_LESSON_DATE]' => "{$this->getWeekdayFromNumber($endTime->format('N'))} {$endTime->format('(Y-m-d)')}",
  1965. '[CHILD_NAME]' => $childPreference->getChild()->getFullname(),
  1966. '[DISCIPLINE_SHORT_NAME]' => $childPreference->getDiscipline()->getName(),
  1967. '[PREFERENCES_TIMES_SUMMARY]' => $preferenceSummary,
  1968. '[SINGLE_LESSON_DURATION]' => $childPreference->getSingleEmailDuration(),
  1969. '[SINGLE_LESSON_AMOUNT]' => count($childPreference->getChildPreferenceTimes()),
  1970. '[CHILD_CLASS]' => $childPreference->getChild()->getClass(),
  1971. '[CHILD_EMAIL]' => $childPreference->getChild()->getEmail(),
  1972. '[GUARDIAN_EMAIL]' => $childPreference->getChild()->getGuardian()->getEmail(),
  1973. '[GUARDIAN_NAME]' => $childPreference->getChild()->getGuardian()->getFullname(),
  1974. '[PREFERENCE_COMMENT]' => $childPreference->getComment(),
  1975. '[LAST_LESSON_DATE_TIME]' => "{$this->getWeekdayFromNumber($endTime->format('N'))} {$endTime->format('(Y-m-d) H:i')}",
  1976. '[TUTOR_FULLNAME]' => $childPreference->getTeacher()->getFullname(),
  1977. '[TUTOR_PHONE]' => $childPreference->getTeacher()->getPhoneNumber(),
  1978. '[CANCEL_REASON]' => $childPreference->getTerminateReason(),
  1979. '[CURRENT_TIME]' => (new \DateTime())->format('H:i'),
  1980. ];
  1982. $emailAddress = $childPreference->getTeacher()->getEmail();
  1983. if ($this->testMode) {
  1984. $emailAddress = $this->testEmailTeacher;
  1985. }
  1987. $this->messageBus->dispatch(new SendMailMessage($emailAddress, '', '', $replacements, 'ASSIGNMENT_CLIENT_STOP_TUTOR_NOTIF_2'));
  1990. $smsContent = $reminderObject->getSmsTemplate();
  1992. $smsContent = str_replace(array_keys($replacements), array_values($replacements), $smsContent);
  1993. $phoneNumber = $childPreference->getTeacher()->getPhoneNumber();
  1994. if ($this->testMode) {
  1995. $phoneNumber = $this->testPhoneTeacher;
  1996. }
  1997. $this->smsService->send($phoneNumber, $smsContent);
  1999. //Guardian Part
  2002. if ($childPreference->getChild()->getGuardian()->getSummer() && (new \DateTime()) < (new \DateTime('2024-08-31'))) {
  2003. return;
  2004. }
  2005. $reminderObject = $this->reminderConfigurationRepository->findOneBy(['reminder_key' => 'ASSIGNMENT_CLIENT_STOP_GUARDIAN_NOTIF_2']);
  2007. $smsContent = $reminderObject->getSmsTemplate();
  2009. $smsContent = str_replace(array_keys($replacements), array_values($replacements), $smsContent);
  2010. $phoneNumber = $childPreference->getChild()->getGuardian()->getPhoneNumber();
  2011. if ($this->testMode) {
  2012. $phoneNumber = $this->testPhoneGuardian;
  2013. }
  2014. $this->smsService->send($phoneNumber, $smsContent);
  2015. }
  2017. public function sendTerminatingByTeacherEmailAndSMS(ChildPreference $childPreference)
  2018. {
  2019. //Tutor Part
  2020. $reminderObject = $this->reminderConfigurationRepository->findOneBy(['reminder_key' => 'ASSIGNMENT_TUTOR_STOP_TUTOR_NOTIF_3']);
  2022. $preferenceSummary = "";
  2024. foreach ($childPreference->getChildPreferenceTimes() as $childPreferenceTime) {
  2025. $preferenceSummary .= "{$childPreferenceTime->getWeekdayString()} {$childPreferenceTime->getStartTime()->format('H:i')}-{$childPreferenceTime->getEndTime()->format('H:i')}<br>";
  2026. }
  2028. $endTime = $childPreference->getEndTime();
  2029. if (!$endTime) {
  2030. $endTime = new \DateTime();
  2031. }
  2033. $replacements = [
  2034. '[LAST_LESSON_DATE]' => "{$endTime->format('Y-m-d')} ({$this->getWeekdayFromNumber($endTime->format('N'))})",
  2035. '[LAST_LESSON_DATE_TEACHER]' => "{$this->getWeekdayFromNumber($endTime->format('N'))} {$endTime->format('(Y-m-d)')}",
  2036. '[CHILD_NAME]' => $childPreference->getChild()->getFullname(),
  2037. '[DISCIPLINE_SHORT_NAME]' => $childPreference->getDiscipline()->getName(),
  2038. '[PREFERENCES_TIMES_SUMMARY]' => $preferenceSummary,
  2039. '[SINGLE_LESSON_DURATION]' => $childPreference->getSingleEmailDuration(),
  2040. '[SINGLE_LESSON_AMOUNT]' => count($childPreference->getChildPreferenceTimes()),
  2041. '[CHILD_CLASS]' => $childPreference->getChild()->getClass(),
  2042. '[CHILD_EMAIL]' => $childPreference->getChild()->getEmail(),
  2043. '[GUARDIAN_EMAIL]' => $childPreference->getChild()->getGuardian()->getEmail(),
  2044. '[GUARDIAN_NAME]' => $childPreference->getChild()->getGuardian()->getFullname(),
  2045. '[PREFERENCE_COMMENT]' => $childPreference->getComment(),
  2046. '[LAST_LESSON_DATE_TIME]' => "{$endTime->format('Y-m-d')} ({$this->getWeekdayFromNumber($endTime->format('N'))})",
  2047. '[TUTOR_FULLNAME]' => $childPreference->getTeacher()->getFullname(),
  2048. '[TUTOR_PHONE]' => $childPreference->getTeacher()->getPhoneNumber(),
  2049. '[CANCEL_REASON]' => $childPreference->getTerminateReason(),
  2050. '[CURRENT_TIME]' => (new \DateTime())->format('H:i'),
  2051. '[TUTOR_TERMINATE_COMMENT]' => $childPreference->getTutorTerminateComment(),
  2052. ];
  2054. $emailAddress = $childPreference->getTeacher()->getEmail();
  2055. if ($this->testMode) {
  2056. $emailAddress = $this->testEmailTeacher;
  2057. }
  2059. $this->messageBus->dispatch(new SendMailMessage($emailAddress, '', '', $replacements, 'ASSIGNMENT_TUTOR_STOP_TUTOR_NOTIF_3'));
  2062. $smsContent = $reminderObject->getSmsTemplate();
  2064. $smsContent = str_replace(array_keys($replacements), array_values($replacements), $smsContent);
  2065. $phoneNumber = $childPreference->getTeacher()->getPhoneNumber();
  2066. if ($this->testMode) {
  2067. $phoneNumber = $this->testPhoneTeacher;
  2068. }
  2069. $this->smsService->send($phoneNumber, $smsContent);
  2071. //Guardian Part
  2074. $reminderObject = $this->reminderConfigurationRepository->findOneBy(['reminder_key' => 'ASSIGNMENT_TUTOR_STOP_GUARDIAN_NOTIF_3']);
  2076. $emailAddress = $childPreference->getChild()->getGuardian()->getEmail();
  2077. if ($this->testMode) {
  2078. $emailAddress = $this->testEmailGuardian;
  2079. }
  2081. $this->messageBus->dispatch(new SendMailMessage($emailAddress, '', '', $replacements, 'ASSIGNMENT_TUTOR_STOP_GUARDIAN_NOTIF_3'));
  2083. $smsContent = $reminderObject->getSmsTemplate();
  2085. $smsContent = str_replace(array_keys($replacements), array_values($replacements), $smsContent);
  2086. $phoneNumber = $childPreference->getChild()->getGuardian()->getPhoneNumber();
  2087. if ($this->testMode) {
  2088. $phoneNumber = $this->testPhoneGuardian;
  2089. }
  2090. $this->smsService->send($phoneNumber, $smsContent);
  2091. }
  2093. public function sendTerminatingByGuardianEmailAndSMS(ChildPreference $childPreference)
  2094. {
  2095. //Tutor Part
  2096. $reminderObject = $this->reminderConfigurationRepository->findOneBy(['reminder_key' => 'ASSIGNMENT_CLIENT_CHANGE_TUTOR_NOTIF_4']);
  2098. $preferenceSummary = "";
  2100. foreach ($childPreference->getChildPreferenceTimes() as $childPreferenceTime) {
  2101. $preferenceSummary .= "{$childPreferenceTime->getWeekdayString()} {$childPreferenceTime->getStartTime()->format('H:i')}-{$childPreferenceTime->getEndTime()->format('H:i')}<br>";
  2102. }
  2104. $endTime = $childPreference->getEndTime();
  2105. if (!$endTime) {
  2106. $endTime = new \DateTime();
  2107. }
  2109. $replacements = [
  2110. '[LAST_LESSON_DATE]' => "{$endTime->format('Y-m-d')} ({$this->getWeekdayFromNumber($endTime->format('N'))})",
  2111. '[CHILD_NAME]' => $childPreference->getChild()->getFullname(),
  2112. '[DISCIPLINE_SHORT_NAME]' => $childPreference->getDiscipline()->getName(),
  2113. '[PREFERENCES_TIMES_SUMMARY]' => $preferenceSummary,
  2114. '[SINGLE_LESSON_DURATION]' => $childPreference->getSingleEmailDuration(),
  2115. '[SINGLE_LESSON_AMOUNT]' => count($childPreference->getChildPreferenceTimes()),
  2116. '[CHILD_CLASS]' => $childPreference->getChild()->getClass(),
  2117. '[CHILD_EMAIL]' => $childPreference->getChild()->getEmail(),
  2118. '[GUARDIAN_EMAIL]' => $childPreference->getChild()->getGuardian()->getEmail(),
  2119. '[GUARDIAN_NAME]' => $childPreference->getChild()->getGuardian()->getFullname(),
  2120. '[PREFERENCE_COMMENT]' => $childPreference->getComment(),
  2121. '[LAST_LESSON_DATE_TIME]' => "{$endTime->format('Y-m-d')} ({$this->getWeekdayFromNumber($endTime->format('N'))})",
  2122. '[TUTOR_FULLNAME]' => $childPreference->getTeacher()->getFullname(),
  2123. '[TUTOR_PHONE]' => $childPreference->getTeacher()->getPhoneNumber(),
  2124. '[CANCEL_REASON]' => $childPreference->getTerminateReason(),
  2125. '[CURRENT_TIME]' => (new \DateTime())->format('H:i'),
  2126. '[TUTOR_TERMINATE_COMMENT]' => $childPreference->getTutorTerminateComment(),
  2127. ];
  2129. $emailAddress = $childPreference->getTeacher()->getEmail();
  2130. if ($this->testMode) {
  2131. $emailAddress = $this->testEmailTeacher;
  2132. }
  2134. $this->messageBus->dispatch(new SendMailMessage($emailAddress, '', '', $replacements, 'ASSIGNMENT_CLIENT_CHANGE_TUTOR_NOTIF_4'));
  2137. $smsContent = $reminderObject->getSmsTemplate();
  2139. $smsContent = str_replace(array_keys($replacements), array_values($replacements), $smsContent);
  2140. $phoneNumber = $childPreference->getTeacher()->getPhoneNumber();
  2141. if ($this->testMode) {
  2142. $phoneNumber = $this->testPhoneTeacher;
  2143. }
  2144. $this->smsService->send($phoneNumber, $smsContent);
  2146. //Guardian Part
  2149. $reminderObject = $this->reminderConfigurationRepository->findOneBy(['reminder_key' => 'ASSIGNMENT_CLIENT_CHANGE_GUARDIAN_NOTIF_4']);
  2151. $emailAddress = $childPreference->getChild()->getGuardian()->getEmail();
  2152. if ($this->testMode) {
  2153. $emailAddress = $this->testEmailGuardian;
  2154. }
  2156. $this->messageBus->dispatch(new SendMailMessage($emailAddress, '', '', $replacements, 'ASSIGNMENT_CLIENT_CHANGE_GUARDIAN_NOTIF_4'));
  2159. $smsContent = $reminderObject->getSmsTemplate();
  2161. $smsContent = str_replace(array_keys($replacements), array_values($replacements), $smsContent);
  2162. $phoneNumber = $childPreference->getChild()->getGuardian()->getPhoneNumber();
  2163. if ($this->testMode) {
  2164. $phoneNumber = $this->testPhoneGuardian;
  2165. }
  2166. $this->smsService->send($phoneNumber, $smsContent);
  2167. }
  2169. public function sendTerminatingByChangeEmailAndSMS(ChildPreference $childPreference)
  2170. {
  2171. //Tutor Part
  2172. $reminderObject = $this->reminderConfigurationRepository->findOneBy(['reminder_key' => 'ASSIGNMENT_CHANGE_AMOUNT_TUTOR']);
  2174. $preferenceSummary = "";
  2176. foreach ($childPreference->getChildPreferenceTimes() as $childPreferenceTime) {
  2177. $preferenceSummary .= "{$childPreferenceTime->getWeekdayString()} {$childPreferenceTime->getStartTime()->format('H:i')}-{$childPreferenceTime->getEndTime()->format('H:i')}<br>";
  2178. }
  2180. $endTime = $childPreference->getEndTime();
  2181. if (!$endTime) {
  2182. $endTime = new \DateTime();
  2183. }
  2185. $replacements = [
  2186. '[LAST_LESSON_DATE]' => "{$endTime->format('Y-m-d')} ({$this->getWeekdayFromNumber($endTime->format('N'))})",
  2187. '[CHILD_NAME]' => $childPreference->getChild()->getFullname(),
  2188. '[DISCIPLINE_SHORT_NAME]' => $childPreference->getDiscipline()->getName(),
  2189. '[PREFERENCES_TIMES_SUMMARY]' => $preferenceSummary,
  2190. '[SINGLE_LESSON_DURATION]' => $childPreference->getSingleEmailDuration(),
  2191. '[SINGLE_LESSON_AMOUNT]' => count($childPreference->getChildPreferenceTimes()),
  2192. '[CHILD_CLASS]' => $childPreference->getChild()->getClass(),
  2193. '[CHILD_EMAIL]' => $childPreference->getChild()->getEmail(),
  2194. '[GUARDIAN_EMAIL]' => $childPreference->getChild()->getGuardian()->getEmail(),
  2195. '[GUARDIAN_NAME]' => $childPreference->getChild()->getGuardian()->getFullname(),
  2196. '[PREFERENCE_COMMENT]' => $childPreference->getComment(),
  2197. '[LAST_LESSON_DATE_TIME]' => "{$endTime->format('Y-m-d')} ({$this->getWeekdayFromNumber($endTime->format('N'))})",
  2198. '[TUTOR_FULLNAME]' => $childPreference->getTeacher()->getFullname(),
  2199. '[TUTOR_PHONE]' => $childPreference->getTeacher()->getPhoneNumber(),
  2200. '[CANCEL_REASON]' => $childPreference->getTerminateReason(),
  2201. '[CURRENT_TIME]' => (new \DateTime())->format('H:i'),
  2202. ];
  2204. $emailAddress = $childPreference->getTeacher()->getEmail();
  2205. if ($this->testMode) {
  2206. $emailAddress = $this->testEmailTeacher;
  2207. }
  2209. $this->messageBus->dispatch(new SendMailMessage($emailAddress, '', '', $replacements, 'ASSIGNMENT_CHANGE_AMOUNT_TUTOR'));
  2212. $smsContent = $reminderObject->getSmsTemplate();
  2214. $smsContent = str_replace(array_keys($replacements), array_values($replacements), $smsContent);
  2215. $phoneNumber = $childPreference->getTeacher()->getPhoneNumber();
  2216. if ($this->testMode) {
  2217. $phoneNumber = $this->testPhoneTeacher;
  2218. }
  2219. $this->smsService->send($phoneNumber, $smsContent);
  2221. //Guardian Part
  2224. $reminderObject = $this->reminderConfigurationRepository->findOneBy(['reminder_key' => 'ASSIGNMENT_CHANGE_AMOUNT_GUARDIAN']);
  2226. $emailAddress = $childPreference->getChild()->getGuardian()->getEmail();
  2227. if ($this->testMode) {
  2228. $emailAddress = $this->testEmailGuardian;
  2229. }
  2231. $this->messageBus->dispatch(new SendMailMessage($emailAddress, '', '', $replacements, 'ASSIGNMENT_CHANGE_AMOUNT_GUARDIAN'));
  2234. $smsContent = $reminderObject->getSmsTemplate();
  2236. $smsContent = str_replace(array_keys($replacements), array_values($replacements), $smsContent);
  2237. $phoneNumber = $childPreference->getChild()->getGuardian()->getPhoneNumber();
  2238. if ($this->testMode) {
  2239. $phoneNumber = $this->testPhoneGuardian;
  2240. }
  2241. $this->smsService->send($phoneNumber, $smsContent);
  2242. }
  2244. public function findPreviousComments(ChildPreference $childPreference)
  2245. {
  2246. $teacherComments = [];
  2248. foreach (array_reverse($childPreference->getChild()->getTeacherSurveyResponses()->getValues()) as $teacherComment) {
  2249. if ($childPreference->getDiscipline() == $teacherComment->getDiscipline()) {
  2250. $teacherComments[] = $teacherComment;
  2251. if (count($teacherComments) == 3) {
  2252. break;
  2253. }
  2254. }
  2255. }
  2256. usort($teacherComments, function ($a, $b) {
  2257. return $a->getCreatedAt() < $b->getCreatedAt();
  2258. });
  2259. return $teacherComments;
  2260. }
  2262. public function findFirstLessonDate(ChildPreference $childPreference)
  2263. {
  2266. $currentTime = new \DateTime();
  2267. if (!$childPreference->getStartTime()) {
  2268. $dateNow = new \DateTime();
  2269. $dateNow->modify('+24 hours');
  2270. } elseif ($childPreference->getStartTime() < new \DateTime()) {
  2271. $dateNow = new \DateTime();
  2272. } else {
  2273. $dateNow = $childPreference->getStartTime();
  2274. }
  2277. $firstLessonDate = null;
  2278. foreach ($childPreference->getChildPreferenceTimes() as $childPreferenceTime) {
  2279. $startTimePreference = $childPreferenceTime->getStartTime();
  2280. $weekday = $this->getWeekdayEnglishFromNumber($childPreferenceTime->getWeekday());
  2281. for ($i = 0; $i <= 24; $i++) {
  2282. $startTime = new \DateTime();
  2284. $startTime->modify("first {$weekday} of {$startTime->format('Y-M')}");
  2285. $startTime->setTime((int)$startTimePreference->format('H'), (int)$startTimePreference->format('i'));
  2286. $startTime->modify("+{$i} weeks");
  2287. if ($currentTime <= $startTime && $startTime >= $dateNow && (!$firstLessonDate || $startTime <= $firstLessonDate)) {
  2288. $firstLessonDate = $startTime;
  2289. }
  2290. }
  2291. }
  2292. $childPreference->setStartTime($firstLessonDate);
  2293. return $firstLessonDate;
  2294. }
  2296. public function findFirstLessonDateForAccepted(ChildPreference $childPreference)
  2297. {
  2299. $query = $this->lessonRepository->createQueryBuilder('l');
  2300. $lesson = $query
  2301. ->andWhere('l.teacher = :teacher')
  2302. ->setParameter('teacher', $childPreference->getTeacher())
  2303. ->andWhere('l.discipline = :discipline')
  2304. ->setParameter('discipline', $childPreference->getDiscipline())
  2305. ->andWhere(':child member of l.children')
  2306. ->setParameter('child', $childPreference->getChild()->getId())
  2307. ->setMaxResults(1)
  2308. ->orderBy('l.startTime', 'ASC')
  2309. ->getQuery()
  2310. ->getOneOrNullResult();
  2312. if ($lesson) {
  2313. $childPreference->setStartTime($lesson->getStartTime());
  2314. }
  2315. return $childPreference->getStartTime();
  2316. }
  2318. public function deleteLessonAfterPreferenceEndPeriod(ChildPreference $childPreference, $doNotDeleteList = null)
  2319. {
  2320. $lessonsQuery = $this->lessonRepository->createQueryBuilder('l');
  2322. $dateStart = new \DateTime($childPreference->getEndTime()->format('Y-m-d H:i'));
  2323. $lessons = $lessonsQuery
  2324. ->andWhere('l.teacher = :teacher')
  2325. ->setParameter('teacher', $childPreference->getTeacher())
  2326. ->andWhere('l.startTime >= :dateStart')
  2327. ->setParameter('dateStart', $dateStart)
  2328. ->andWhere(':child MEMBER OF l.children')
  2329. ->setParameter('child', $childPreference->getChild()->getId())
  2330. ->andWhere('l.discipline = :discipline')
  2331. ->setParameter('discipline', $childPreference->getDiscipline())
  2332. ->andWhere('l.type = :type')
  2333. ->setParameter('type', $childPreference->getType())
  2334. ->getQuery()
  2335. ->getResult();
  2338. /**
  2339. * @var $lesson Lesson
  2340. */
  2341. foreach ($lessons as $lesson) {
  2342. // if($lesson->getStatusValue() == Lesson::STATUS_REGULAR_MOVED['value']){
  2343. // continue;
  2344. // }
  2346. $skip = false;
  2347. if ($doNotDeleteList) {
  2348. foreach ($doNotDeleteList as $doNotDeleteDate) {
  2349. if ($doNotDeleteDate->format('Y-m-d H:i') == $lesson->getStartTime()->format('Y-m-d H:i')) {
  2350. $skip = true;
  2351. }
  2352. }
  2353. }
  2354. if (!$skip) {
  2355. foreach ($lesson->getTeacherPaymentLogs() as $teacherPaymentLog) {
  2356. $this->entityManager->remove($teacherPaymentLog);
  2357. }
  2358. $this->lessonDeletionService->delete(
  2359. $lesson,
  2360. LessonDeletionService::REASON_PREFERENCE_END_PERIOD
  2361. );
  2362. $this->entityManager->flush();
  2363. }
  2364. }
  2365. }
  2367. public function deleteLessonBeforeRegenerate(ChildPreference $childPreference, $childPreferenceTimes, $dateStart)
  2368. {
  2369. if (!$childPreference->getChild()) {
  2370. return true;
  2371. }
  2372. $lessonsQuery = $this->lessonRepository->createQueryBuilder('l');
  2374. $lessons = $lessonsQuery
  2375. ->andWhere('l.teacher = :teacher')
  2376. ->setParameter('teacher', $childPreference->getTeacher())
  2377. ->andWhere('l.startTime >= :dateStart')
  2378. ->setParameter('dateStart', $dateStart)
  2379. ->andWhere(':child MEMBER OF l.children')
  2380. ->setParameter('child', $childPreference->getChild()->getId())
  2381. ->andWhere('l.discipline = :discipline')
  2382. ->setParameter('discipline', $childPreference->getDiscipline())
  2383. ->andWhere('l.type = :type')
  2384. ->setParameter('type', $childPreference->getType())
  2385. ->getQuery()
  2386. ->getResult();
  2389. /**
  2390. * @var $lesson Lesson
  2391. */
  2392. foreach ($lessons as $lesson) {
  2393. if (in_array($lesson->getStatusValue(), [Lesson::STATUS_REGULAR_MOVED['value'], Lesson::STATUS_ADDITIONAL['value']])) {
  2394. continue;
  2395. }
  2396. $this->lessonDeletionService->delete(
  2397. $lesson,
  2398. LessonDeletionService::REASON_PREFERENCE_REGENERATED
  2399. );
  2400. $this->entityManager->flush();
  2401. }
  2402. }
  2404. public function deleteChildLessons(Child $child, $dateStart)
  2405. {
  2406. if (!$child || !$dateStart) {
  2407. return true;
  2408. }
  2409. $lessonsQuery = $this->lessonRepository->createQueryBuilder('l');
  2411. $lessons = $lessonsQuery
  2412. ->andWhere(':child MEMBER OF l.children')
  2413. ->setParameter('child', $child)
  2414. ->andWhere('l.startTime >= :dateStart')
  2415. ->setParameter('dateStart', $dateStart)
  2416. ->getQuery()
  2417. ->getResult();
  2419. /**
  2420. * @var $lesson Lesson
  2421. */
  2422. foreach ($lessons as $lesson) {
  2423. if (in_array($lesson->getStatusValue(), [Lesson::STATUS_REGULAR_MOVED['value'], Lesson::STATUS_ADDITIONAL['value']])) {
  2424. continue;
  2425. }
  2426. $this->lessonDeletionService->delete(
  2427. $lesson,
  2428. LessonDeletionService::REASON_CHILD_LESSONS_REMOVED
  2429. );
  2430. $this->entityManager->flush();
  2431. }
  2432. }
  2434. public function deleteLessonsForRemovedPreferenceTime(ChildPreference $childPreference, ChildPreferenceTime $removedTime): void
  2435. {
  2436. if (!$childPreference->getChild() || !$childPreference->getTeacher() || !$childPreference->getDiscipline()) {
  2437. return;
  2438. }
  2440. $removedWeekday = (int) $removedTime->getWeekday();
  2441. $removedStartTime = $removedTime->getStartTime()->format('H:i');
  2443. foreach ($childPreference->getChildPreferenceTimes() as $stillActiveTime) {
  2444. if ((int) $stillActiveTime->getWeekday() === $removedWeekday
  2445. && $stillActiveTime->getStartTime()->format('H:i') === $removedStartTime) {
  2446. // A remaining row still covers this weekday/time (e.g. it was re-added), so its lessons are legitimate.
  2447. return;
  2448. }
  2449. }
  2451. $lessons = $this->lessonRepository->createQueryBuilder('l')
  2452. ->andWhere('l.teacher = :teacher')
  2453. ->setParameter('teacher', $childPreference->getTeacher())
  2454. ->andWhere(':child MEMBER OF l.children')
  2455. ->setParameter('child', $childPreference->getChild()->getId())
  2456. ->andWhere('l.discipline = :discipline')
  2457. ->setParameter('discipline', $childPreference->getDiscipline())
  2458. ->andWhere('l.type = :type')
  2459. ->setParameter('type', $childPreference->getType())
  2460. ->andWhere('l.startTime >= :now')
  2461. ->setParameter('now', new \DateTime())
  2462. ->getQuery()
  2463. ->getResult();
  2465. /** @var Lesson $lesson */
  2466. foreach ($lessons as $lesson) {
  2467. if (in_array($lesson->getStatusValue(), [Lesson::STATUS_REGULAR_MOVED['value'], Lesson::STATUS_ADDITIONAL['value']])) {
  2468. continue;
  2469. }
  2470. if ((int) $lesson->getStartTime()->format('N') !== $removedWeekday) {
  2471. continue;
  2472. }
  2473. if ($lesson->getStartTime()->format('H:i') !== $removedStartTime) {
  2474. continue;
  2475. }
  2476. $this->lessonDeletionService->delete($lesson, LessonDeletionService::REASON_PREFERENCE_TIME_REMOVED);
  2477. $this->entityManager->flush();
  2479. $guardian = $childPreference->getChild()->getGuardian();
  2480. if ($guardian) {
  2481. $this->guardianLogService->addGuardianActionLog(
  2482. LessonDeletionService::REASON_PREFERENCE_TIME_REMOVED,
  2483. $guardian,
  2484. $lesson,
  2485. 'delete'
  2486. );
  2487. }
  2488. }
  2489. }
  2491. public function generateLessonsForChildPreference(ChildPreference $preference, $dateFrom = null, $doNotCreateList = null, $isPaid = false, $byPassStatusCheck = false, $byPassEarlyPaymentDateStart = false)
  2492. {
  2493. if ($dateFrom) {
  2494. $generateFrom = $dateFrom;
  2495. } else {
  2496. $generateFrom = $preference->getStartTime()->format('Y-m-d H:i');
  2497. }
  2498. // if($_SERVER['REMOTE_ADDR'] == '86.38.84.66')
  2499. // {
  2500. // dump('ok');
  2501. // die();
  2502. // }
  2503. $generateForMonth = new \DateTime($generateFrom);
  2504. $generateForMonth->modify("first day of {$generateForMonth->format('Y-M')}");
  2505. $dateMonthToGenerateFor = $generateForMonth->format('Y-m-d');
  2506. $generateTo = new \DateTime($dateMonthToGenerateFor);
  2508. $generateTo->modify("last day of {$generateTo->format('Y-M')}");
  2509. $generateTo->modify("+31 days");
  2510. $generateTo->setTime(23, 59);
  2512. $maxGenerateTo = new \DateTime();
  2513. $maxGenerateTo->modify("first day of {$maxGenerateTo->format('Y-M')}");
  2514. $maxGenerateTo->modify("+35 days");
  2515. $maxGenerateTo->setTime(23, 59);
  2516. $maxGenerateTo->modify("last day of {$maxGenerateTo->format('Y-M')}");
  2518. if ($generateTo > $maxGenerateTo) {
  2519. $generateTo = $maxGenerateTo;
  2520. }
  2522. $guardian = $preference->getChild()->getGuardian();
  2523. if($guardian->isFlagEarlyPayment() && !$byPassEarlyPaymentDateStart)
  2524. {
  2525. $paymentDay = $guardian->getEarlyPaymentDay();
  2526. $dateNow = new \DateTime();
  2527. $generateFromDate = new \DateTime($generateFrom);
  2528. if ($generateFromDate > $dateNow) {
  2529. // Future-dated preference start (delayed cutover): anchor on it, else $generateTo lands before $generateFrom and skips every lesson.
  2530. $dateNow = $generateFromDate;
  2531. }
  2532. $periodEndTime = new \DateTime("{$dateNow->format('Y-m-')}{$paymentDay}");
  2533. while ($dateNow->format('Y-m') == $periodEndTime->format('Y-m'))
  2534. {
  2535. $periodEndTime->modify('+7 days');
  2536. }
  2537. $periodEndTime->setDate($periodEndTime->format('Y'), $periodEndTime->format('m'), $paymentDay);
  2538. $generateTo = clone $periodEndTime;
  2539. }
  2540. // dump($generateTo);
  2541. // die();
  2545. $child = $preference->getChild();
  2546. // START CREATING INDIVIDUAL LESSONS
  2547. foreach ($child->getChildPreferences() as $childPreference) {
  2548. if($childPreference->getStatus() != ChildPreference::STATUS_ACCEPTED['value'] && !$byPassStatusCheck)
  2549. {
  2550. continue;
  2551. }
  2552. foreach ($childPreference->getChildPreferenceTimes() as $childPreferenceTime) {
  2553. $childPreference = $childPreferenceTime->getChildPreference();
  2554. if ($childPreference->getType() != Lesson::TYPE_INDIVIDUAL) {
  2555. continue;
  2556. }
  2558. if ($childPreference->getId() != $preference->getId()) {
  2559. continue;
  2560. }
  2562. $startTimePreference = $childPreferenceTime->getStartTime();
  2563. $endTimePreference = $childPreferenceTime->getEndTime();
  2564. $weekday = $this->getWeekdayEnglishFromNumber($childPreferenceTime->getWeekday());
  2566. for ($i = 0; $i <= 8; $i++) {
  2567. $startTime = new \DateTime($generateFrom);
  2569. $startTime->modify("first {$weekday} of {$startTime->format('Y-M')}");
  2570. $startTime->setTime((int)$startTimePreference->format('H'), (int)$startTimePreference->format('i'));
  2571. $startTime->modify("+{$i} weeks");
  2573. $endTime = new \DateTime($generateFrom);
  2574. $endTime->modify("first {$weekday} of {$endTime->format('Y-M')}");
  2575. $endTime->setTime((int)$endTimePreference->format('H'), (int)$endTimePreference->format('i'));
  2576. $endTime->modify("+{$i} weeks");
  2579. if ($generateTo <= $startTime) {
  2580. continue;
  2581. }
  2583. if ($startTime < new \DateTime($generateFrom)) {
  2584. continue;
  2585. }
  2587. if ($childPreference->getChild()->getLessonsEnd()) {
  2588. if ($startTime > $childPreference->getChild()->getLessonsEnd()) {
  2589. continue;
  2590. }
  2591. }
  2593. if ($childPreference->getStartTime() && $childPreference->getStartTime() > $startTime) {
  2594. continue;
  2595. }
  2597. if ($childPreference->getEndTime() && $childPreference->getEndTime() < $endTime) {
  2598. continue;
  2599. }
  2601. if (!$childPreference->getTeacher()) {
  2602. continue;
  2603. }
  2605. foreach ($child->getChildVacations() as $vacation) {
  2606. if ($vacation->isIsDeleted()) {
  2607. continue;
  2608. }
  2609. if ($vacation->getDateFrom() >= $startTime || $vacation->getDateTo() <= $startTime) {
  2610. continue;
  2611. }
  2612. $vacationDisciplineIds = $vacation->getDisciplineIds();
  2613. if ($vacationDisciplineIds === null || in_array($childPreference->getDiscipline()->getId(), $vacationDisciplineIds)) {
  2614. continue 2;
  2615. }
  2616. }
  2619. $skip = false;
  2620. if ($doNotCreateList) {
  2621. foreach ($doNotCreateList as $doNotCreateDate) {
  2622. if ($doNotCreateDate->format('Y-m-d H:i') == $startTime->format('Y-m-d H:i')) {
  2623. $skip = true;
  2624. }
  2625. }
  2626. }
  2627. if ($skip) {
  2628. continue;
  2629. }
  2630. $duration = date_diff($startTime, $endTime);
  2632. $duration = (int)$duration->i + (int)$duration->h * 60;
  2635. $lessonsQuery = $this->lessonRepository->createQueryBuilder('l');
  2636. $lessons = $lessonsQuery
  2637. ->andWhere('l.teacher = :teacher')
  2638. ->setParameter('teacher', $childPreference->getTeacher()->getId())
  2639. ->andWhere('l.discipline = :discipline')
  2640. ->setParameter('discipline', $childPreference->getDiscipline()->getId())
  2641. ->andWhere(':child MEMBER OF l.children')
  2642. ->setParameter('child', $childPreference->getChild()->getId())
  2643. ->andWhere('l.startTime = :startTime OR l.originalStartTime = :startTime')
  2644. ->setParameter('startTime', $startTime->format('Y-m-d H:i'))
  2645. ->andWhere('l.endTime = :endTime OR l.originalEndTime = :endTime')
  2646. ->setParameter('endTime', $endTime->format('Y-m-d H:i'))
  2647. ->andWhere('l.type = :type')
  2648. ->setParameter('type', $childPreference->getType())
  2649. ->andWhere('l.duration = :duration')
  2650. ->setParameter('duration', $duration)
  2651. ->getQuery()
  2652. ->getResult();
  2655. $guardian = $childPreference->getChild()->getGuardian();
  2656. //sita nutrinam nes: uzkeisdavo esamas pamokas i regular statusa su sumoketa suma, bet niekada neatminusuoja is balanso, bugas palikdavo pamokas apmoketas nepakeitus balanso
  2658. // dump($childPreference->getTeacher()->getStatus());
  2659. // dump(Teacher::STATUS_ACTIVE);
  2661. if (!$lessons && $childPreference->getTeacher()->getStatus() == Teacher::STATUS_ACTIVE) {
  2662. $lesson = (new Lesson())
  2663. ->setType($childPreference->getType())
  2664. ->setStatus(Lesson::STATUS_REGULAR['value'])
  2665. ->setClass($childPreference->getChild()->getClass())
  2666. ->setDiscipline($childPreference->getDiscipline())
  2667. ->setTeacher($childPreference->getTeacher())
  2668. ->setDuration($duration)
  2669. ->setStartTime($startTime)
  2670. ->setEndTime($endTime)
  2671. ->setOriginalStartTime($startTime)
  2672. ->setOriginalEndTime($endTime);
  2673. $lesson->addChild($childPreference->getChild());
  2675. if ($guardian->isFlagEarlyPayment()) {
  2676. $lesson->setPaid(0);
  2677. $lesson->setStatus(Lesson::STATUS_WAITING_PAYMENT['value']);
  2678. }
  2680. if ($this->teacherHolidayRepository->isTeacherOnHolidayAt($childPreference->getTeacher(), $startTime)) {
  2681. $lesson->setStatus(Lesson::STATUS_INFORMED_MISSED['value']);
  2682. }
  2684. $this->entityManager->persist($lesson);
  2685. $this->entityManager->flush();
  2686. }
  2687. }
  2688. }
  2689. }
  2690. }
  2692. public function restoreLessonsForChildPreference(ChildPreference $preference, $restoreDeletedList = null)
  2693. {
  2694. if (!$restoreDeletedList) {
  2695. return;
  2696. }
  2698. foreach ($restoreDeletedList as $restoreDeletedDate) {
  2700. $query = $this->lessonDeletedRepository->createQueryBuilder('l');
  2701. /** @var LessonDeleted $deletedLessonToRestore */
  2702. $deletedLessonToRestore = $query
  2703. ->andWhere('l.discipline = :discipline')
  2704. ->setParameter('discipline', $preference->getDiscipline()->getId())
  2705. ->andWhere('l.teacher = :teacher')
  2706. ->setParameter('teacher', $preference->getTeacher()->getId())
  2707. ->andWhere('l.startTime = :startTime')
  2708. ->setParameter('startTime', $restoreDeletedDate)
  2709. ->setMaxResults(1)
  2710. ->getQuery()
  2711. ->getOneOrNullResult();
  2713. if (!$deletedLessonToRestore) {
  2714. return;
  2715. }
  2717. $startTime = $deletedLessonToRestore->getStartTime();
  2719. $endTime = $deletedLessonToRestore->getEndTime();
  2721. $duration = $deletedLessonToRestore->getDuration();
  2724. $lessonsQuery = $this->lessonRepository->createQueryBuilder('l');
  2725. $lessons = $lessonsQuery
  2726. ->andWhere('l.teacher = :teacher')
  2727. ->setParameter('teacher', $preference->getTeacher()->getId())
  2728. ->andWhere('l.discipline = :discipline')
  2729. ->setParameter('discipline', $preference->getDiscipline()->getId())
  2730. ->andWhere(':child MEMBER OF l.children')
  2731. ->setParameter('child', $preference->getChild()->getId())
  2732. ->andWhere('l.startTime = :startTime')
  2733. ->setParameter('startTime', $startTime->format('Y-m-d H:i'))
  2734. ->andWhere('l.endTime = :endTime')
  2735. ->setParameter('endTime', $endTime->format('Y-m-d H:i'))
  2736. ->andWhere('l.type = :type')
  2737. ->setParameter('type', $preference->getType())
  2738. ->andWhere('l.duration = :duration')
  2739. ->setParameter('duration', $duration)
  2740. ->getQuery()
  2741. ->getResult();
  2744. if (!$lessons && $preference->getTeacher()->getStatus() == Teacher::STATUS_ACTIVE) {
  2745. $lesson = (new Lesson())
  2746. ->setType($preference->getType())
  2747. ->setStatus(Lesson::STATUS_REGULAR['value'])
  2748. ->setClass($preference->getChild()->getClass())
  2749. ->setDiscipline($preference->getDiscipline())
  2750. ->setTeacher($preference->getTeacher())
  2751. ->setDuration($duration)
  2752. ->setStartTime($startTime)
  2753. ->setEndTime($endTime);
  2754. $lesson->addChild($preference->getChild());
  2755. $this->entityManager->persist($lesson);
  2756. $this->entityManager->flush();
  2757. }
  2760. }
  2761. }
  2764. public function recalculatePricesForFurtherLessons(Guardian $guardian, \Datetime $dateFrom)
  2765. {
  2767. $lessonsQuery = $this->lessonRepository->createQueryBuilder('l');
  2768. $lessons = $lessonsQuery
  2769. ->andWhere(':children member of l.children')
  2770. ->setParameter('children', $guardian->getChildren())
  2771. ->andWhere('l.startTime > :startTime')
  2772. ->setParameter('startTime', $dateFrom)
  2773. ->getQuery()
  2774. ->getResult();
  2775. foreach ($lessons as $lesson) {
  2776. $this->paymentService->editPayment($lesson);
  2777. }
  2778. }
  2780. public function getWeekdayFromNumber(int $day)
  2781. {
  2782. if ($day == 1) {
  2783. return 'Pirmadienis';
  2784. }
  2785. if ($day == 2) {
  2786. return 'Antradienis';
  2787. }
  2788. if ($day == 3) {
  2789. return 'Trečiadienis';
  2790. }
  2791. if ($day == 4) {
  2792. return 'Ketvirtadienis';
  2793. }
  2794. if ($day == 5) {
  2795. return 'Penktadienis';
  2796. }
  2797. if ($day == 6) {
  2798. return 'Šeštadienis';
  2799. }
  2800. if ($day == 7) {
  2801. return 'Sekmadienis';
  2802. } else {
  2803. return "";
  2804. }
  2805. }
  2807. public function getWeekdayEnglishFromNumber(int $day)
  2808. {
  2809. if ($day == 1) {
  2810. return 'monday';
  2811. }
  2812. if ($day == 2) {
  2813. return 'tuesday';
  2814. }
  2815. if ($day == 3) {
  2816. return 'wednesday';
  2817. }
  2818. if ($day == 4) {
  2819. return 'thursday';
  2820. }
  2821. if ($day == 5) {
  2822. return 'friday';
  2823. }
  2824. if ($day == 6) {
  2825. return 'saturday';
  2826. }
  2827. if ($day == 7) {
  2828. return 'sunday';
  2829. } else {
  2830. return "";
  2831. }
  2832. }
  2833. }