src/Controller/Api/ProjectController.php line 1224

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Api;
  5. use App\Controller\ModulesAccessTypes;
  6. use App\Entity\AccessRoles;
  7. use App\Entity\Administrative;
  8. use App\Entity\Branches;
  9. use App\Entity\Certificates;
  10. use App\Entity\CertificatesGroups;
  11. use App\Entity\Countries;
  12. use App\Entity\Customer;
  13. use App\Entity\CustomerCertificates;
  14. use App\Entity\InvoiceType;
  15. use App\Entity\ProjectAddendumCosts;
  16. use App\Entity\ProjectBranches;
  17. use App\Entity\ProjectExpense;
  18. use App\Entity\ProjectOrderExpensePositions;
  19. use App\Entity\ProjectOrders;
  20. use App\Entity\ProjectOrderUndertakings;
  21. use App\Entity\ProjectOwner;
  22. use App\Entity\Projects;
  23. use App\Entity\ProjectSettings;
  24. use App\Entity\ProjectStakeholders;
  25. use App\Entity\Qualification;
  26. use App\Entity\TimesheetStatus;
  27. use App\Entity\User;
  28. use App\Entity\UserScopedItem;
  29. use App\Entity\WorkerActivities;
  30. use App\Entity\WorkerTimesheet;
  31. use App\Repository\BranchesRepository;
  32. use App\Repository\CertificatesRepository;
  33. use App\Repository\QualificationRepository;
  34. use App\Service\AisDate;
  35. use App\Service\PdfOutputProjectPaymentReport;
  36. use App\Service\PdfOutputTimesheet;
  37. use App\Service\RgbToHex;
  38. use App\Service\SeverityInterface;
  39. use App\Service\StatusCodes;
  40. use App\Service\TimesheetInterface\TimesheetReaderInterface;
  41. use Container69K1BxJ\getMaker_PhpCompatUtilService;
  42. use Doctrine\Common\Collections\ArrayCollection;
  43. use Doctrine\ORM\EntityManagerInterface;
  44. use Monolog\DateTimeImmutable;
  45. use PhpOffice\PhpSpreadsheet\IOFactory;
  46. use Ramsey\Uuid\Exception\UnsatisfiedDependencyException;
  47. use Sensio\Bundle\FrameworkExtraBundle\Configuration\ParamConverter;
  48. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  49. use Symfony\Component\HttpFoundation\JsonResponse;
  50. use Symfony\Component\HttpFoundation\Request;
  51. use Symfony\Component\HttpFoundation\Response;
  52. use Symfony\Component\Routing\Annotation\Route;
  53. use Symfony\Component\Serializer\Normalizer\AbstractNormalizer;
  54. use Symfony\Component\Serializer\SerializerInterface;
  55. use Symfony\Contracts\Translation\TranslatorInterface;
  56. use function Doctrine\StaticAnalysis\DBAL\makeMeACustomConnection;
  57. use function Psr\Log\error;
  58. use function Symfony\Bundle\MakerBundle\Util\advanceBeyondMultilineArrayLastItem;
  59. use function Symfony\Component\DependencyInjection\Loader\Configurator\param;
  62. /**
  63.  * @Route("/api/project")
  64. */
  65. class ProjectController extends AbstractController
  66. {
  68.     // ⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇⬇
  70.     /**
  71.      * 💡💡💡info 💡💡💡
  72.      * $postedBranches is Core Branch ( not projectBranch Id!!!)
  73.      */
  74.     private function appendBranchToProject(?Projects $project, EntityManagerInterface $manager, array $posted_branch_ids ): Projects {
  77.         // Eğer $posted_branch_ids bir string (JSON) olarak geldiyse, decode ederek diziye çevir
  78.         if (gettype($posted_branch_ids) === "string") {
  79.             $posted_branch_ids = json_decode($posted_branch_ids, false); // burada true da kullanılabilir, ama aşağıda map ile işleniyor
  80.         }
  82.         // ID'lerin hepsini integer'a çevir (in_array'nin strict karşılaştırması için)
  83.         $posted_branch_ids = array_map('intval', $posted_branch_ids);
  85.         // Projenin mevcut branch ilişkilerini al (Doctrine Collection)
  86.         $olderBranches = $project->getProjectBranches();
  88.         // Eğer projede daha önce eklenmiş branch'ler varsa
  89.         if ($olderBranches->count()) {
  91.             // Her eski ilişkiyi dön
  92.             foreach ($olderBranches as $olderBranch) {
  93.                 // İlişkili branch'in ID'sini al
  94.                 $olderBranchId = $olderBranch->getBranch()->getId();
  96.                 // Eğer bu eski ID, gelen yeni listede yoksa → bu ilişki silinmeli
  97.                 if (!in_array($olderBranchId, $posted_branch_ids, true)) {
  98.                     $project->removeProjectBranch($olderBranch); // Doctrine üzerinden ilişkiyi kaldır
  99.                 } else {
  100.                     // Varsa, tekrar eklemeye gerek yok
  101.                     // Aynı zamanda array'den çıkar ki, kalan ID'ler sadece yeni eklenecekler olsun
  102.                     $posted_branch_ids = array_diff($posted_branch_ids, [$olderBranchId]);
  103.                 }
  104.             }
  105.         }
  107.         // Yeni eklenecek branch ID'leri kaldıysa
  108.         if ($posted_branch_ids) {
  109.             if (count($posted_branch_ids)) {
  110.                 // Bu ID'lere karşılık gelen Branch objelerini DB'den çek
  111.                 $branches = $manager->getRepository(Branches::class)->findBy(["id" => $posted_branch_ids]);
  113.                 // Her yeni branch için ProjectBranches ilişkisi oluştur
  114.                 foreach ($branches as $branch) {
  115.                     $projectBranch = new ProjectBranches(); // Yeni ilişki nesnesi
  116.                     $projectBranch->setBranch($branch);     // Branch ilişkilendirilir
  118.                     // Gerekirse persist edilebilir (Doctrine cascade yoksa)
  119.                     // $manager->persist($projectBranch);
  121.                     $project->addProjectBranch($projectBranch); // İlişki projeye eklenir
  122.                 }
  123.             }
  124.         }
  126.         // Güncellenmiş Project nesnesi geri döndürülür
  127.         return $project;
  129.     }
  131.     private function manageProjectCertificates( Projects $project, EntityManagerInterface $manager, array $posted_certificate_ids = [] ): Projects {
  134.         #dd($posted_certificate_ids);
  136.         // Eğer $posted_certificate_ids bir string (JSON) olarak geldiyse, decode ederek diziye çevir
  137.         if (gettype($posted_certificate_ids) === "string") {
  138.             $posted_certificate_ids = json_decode($posted_certificate_ids, false); // burada true da kullanılabilir, ama aşağıda map ile işleniyor
  139.         }
  141.         // ID'lerin hepsini integer'a çevir (in_array'nin strict karşılaştırması için)
  142.         $posted_certificate_ids = array_map('intval', $posted_certificate_ids);
  144.         #dd($posted_certificate_ids);
  146.         // Projenin mevcut branch ilişkilerini al (Doctrine Collection)
  147.         $olderCertificates = $project->getDependentCertificates();
  149.         #dump($posted_certificate_ids);
  151.         // Eğer projede daha önce eklenmiş branch'ler varsa
  152.         if ($olderCertificates->count()) {
  154.             // Her eski ilişkiyi dön
  155.             foreach ($olderCertificates as $olderCertificate) {
  156.                 // İlişkili branch'in ID'sini al
  157.                 $olderCertificateId = $olderCertificate->getId();
  158.                 dump($olderCertificateId);
  160.                 // Eğer bu eski ID, gelen yeni listede yoksa → bu ilişki silinmeli
  161.                 if (!in_array($olderCertificateId, $posted_certificate_ids, true)) {
  162.                     $project->removeDependentCertificate($olderCertificate); // Doctrine üzerinden ilişkiyi kaldır
  163.                 } else {
  164.                     // Varsa, tekrar eklemeye gerek yok
  165.                     // Aynı zamanda array'den çıkar ki, kalan ID'ler sadece yeni eklenecekler olsun
  166.                     $posted_certificate_ids = array_diff($posted_certificate_ids, [$olderCertificateId]);
  167.                 }
  168.             }
  169.         }
  172.         // Yeni eklenecek branch ID'leri kaldıysa
  173.         if ($posted_certificate_ids) {
  174.             if (count($posted_certificate_ids)) {
  175.                 // Bu ID'lere karşılık gelen Branch objelerini DB'den çek
  176.                 $certificates = $manager->getRepository(Certificates::class)->findBy(["id" => $posted_certificate_ids]);
  178.                 // Her yeni branch için ProjectBranches ilişkisi oluştur
  179.                 foreach ($certificates as $certificate ) {
  180.                     $project->addDependentCertificate($certificate); // Yeni ilişki nesnesi
  181.                 }
  182.             }
  183.         }
  185.         // Güncellenmiş Project nesnesi geri döndürülür
  186.         return $project;
  187.     }
  189.     private function manageProjectQualifications( Projects $project, EntityManagerInterface $manager, array $posted_qualification_ids = [] ): Projects {
  191.         #dd($posted_qualification_ids);
  193.         // Eğer $posted_qualification_ids bir string (JSON) olarak geldiyse, decode ederek diziye çevir
  194.         if (gettype($posted_qualification_ids) === "string") {
  195.             $posted_qualification_ids = json_decode($posted_qualification_ids, false); // burada true da kullanılabilir, ama aşağıda map ile işleniyor
  196.         }
  198.         // ID'lerin hepsini integer'a çevir (in_array'nin strict karşılaştırması için)
  199.         $posted_qualification_ids = array_map('intval', $posted_qualification_ids);
  201.         #dd($posted_qualification_ids);
  203.         // Projenin mevcut branch ilişkilerini al (Doctrine Collection)
  204.         $olderQualifications = $project->getDependentQualifications();
  206.         #dump($posted_qualification_ids);
  208.         // Eğer projede daha önce eklenmiş branch'ler varsa
  209.         if ($olderQualifications->count()) {
  211.             // Her eski ilişkiyi dön
  212.             foreach ($olderQualifications as $olderQualification) {
  213.                 // İlişkili branch'in ID'sini al
  214.                 $olderQualificationId = $olderQualification->getId();
  215.                 dump($olderQualificationId);
  217.                 // Eğer bu eski ID, gelen yeni listede yoksa → bu ilişki silinmeli
  218.                 if (!in_array($olderQualificationId, $posted_qualification_ids, true)) {
  219.                     $project->removeDependentQualification($olderQualification); // Doctrine üzerinden ilişkiyi kaldır
  220.                 } else {
  221.                     // Varsa, tekrar eklemeye gerek yok
  222.                     // Aynı zamanda array'den çıkar ki, kalan ID'ler sadece yeni eklenecekler olsun
  223.                     $posted_qualification_ids = array_diff($posted_qualification_ids, [$olderQualificationId]);
  224.                 }
  225.             }
  226.         }
  229.         // Yeni eklenecek branch ID'leri kaldıysa
  230.         if ($posted_qualification_ids) {
  231.             if (count($posted_qualification_ids)) {
  232.                 // Bu ID'lere karşılık gelen Branch objelerini DB'den çek
  233.                 $qualifications = $manager->getRepository(Qualification::class)->findBy(["id" => $posted_qualification_ids]);
  235.                 // Her yeni branch için ProjectBranches ilişkisi oluştur
  236.                 foreach ($qualifications as $qualification ) {
  237.                     $project->addDependentQualification($qualification); // Yeni ilişki nesnesi
  238.                 }
  239.             }
  240.         }
  242.         // Güncellenmiş Project nesnesi geri döndürülür
  243.         return $project;
  247.     }
  250.     /**
  251.      * @param Projects|null $project
  252.      * @param Customer|null $customer
  253.      * @param AisDate $aisDate  
  254.      * @param TranslatorInterface $translator
  255.      * @return array
  256.      * @throws \Exception
  257.      */
  258.     public function coreProjectPrettyStatusData (?Projects $project, ?Customer $customer, AisDate $aisDate, TranslatorInterface $translator ): array
  259.     {
  260.         $alert[] = [
  261.             "header" => $translator->trans('Suitable!'),
  262.             "severity" => "success"
  263.         ];
  264.         $suitable = true;
  266.         // Core Warning's
  267.         // Check Core defined Qualifications
  268.         if (!$project->getDependentQualifications()->count()) {
  269.             $alert[] = [
  270.                 "header" => $project->getName() . " " . $translator->trans("is not suitable because the qualifications for this project not defined"),
  271.                 "severity" => "warning"
  272.             ];
  273.         }
  275.         // Check Core defined Certificates
  276.         if (!$project->getDependentCertificates()->count()) {
  277.             $alert[] = [
  278.                 "header" => $project->getName() . " " . $translator->trans("is not suitable because the certificates for this project not defined"),
  279.                 "severity" => "warning"
  280.             ];
  281.         }
  283.         $missingCertificates = $project->getDependentCertificates()->filter(function (/**@var $dependedCertificate Certificates */ $dependedCertificate) use ($customer) {
  284.             return $dependedCertificate->getCertificateEligibility()->getName() === 'company' && $customer->getCustomerCertificates()->filter(function (/**@var $customerCertificate CustomerCertificates */ $customerCertificate) use ($dependedCertificate) {
  285.                     return $customerCertificate->getCertificate()->getId() === $dependedCertificate->getId();
  286.                 })->count() === 0;
  287.         })->getValues();
  289.         if( count($missingCertificates) ){
  290.             $alert[] = [
  291.                 "header" => $project->getName() . " " . $translator->trans('Project for this company is suitable with missing certificates'),
  292.                 "subheader" => (new ArrayCollection($missingCertificates))->map( function( /**@var $missingCertificate Certificates*/$missingCertificate ){
  293.                     return [
  294.                         "header" => "* " . $missingCertificate->getName(),
  295.                         "severity" => "info"
  296.                     ];
  297.                 }),
  298.                 "severity" => "info"
  299.             ];
  300.         }
  302.         if ( !$project->getEndAt() ) {
  303.             $alert[] = [
  304.                 "header" => $translator->trans(
  305.                     "'End Date' of Core Project not defined,
  306.                     If any time, you try to define 'End Date' of Core with your confirmation,
  307.                     system can equalize 'End-Date' of Stakeholders with Core!,
  308.                     If you are unsure of the due date, I recommend leaving it blank."),
  309.                 "severity" => "info"
  310.             ];
  311.         }
  313.         // Worker Active in selected stakeholder project
  314.         // By join to project, not by edit!
  315.         if( $customer ){
  316.             $foundedCustomerInProject = $customer->getProjectStakeholders()->filter( function(/**@var $projectStakeholder ProjectStakeholders*/ $projectStakeholder ) use ( $project ){
  317.                 return $projectStakeholder->getProject()->getId() === $project->getId() &&
  318.                     ( !$projectStakeholder->getEndAt() || ($projectStakeholder->getEndAt() > new DateTimeImmutable('now')));
  319.             })->first();
  320.             #dd($foundedCustomerInProject);
  321.             if( $foundedCustomerInProject ){
  322.                 $alert = [
  323.                     "header" => $foundedCustomerInProject->getCustomer()->getCompany() . ' ' . $translator->trans('already in project!'),
  324.                     "severity" => "info"
  325.                 ];
  326.                 $suitable = false;
  327.             }
  328.         }
  330.         if(!is_null($project->getStatus())){
  332.             // Overwrite if completed
  333.             if($project->getStatus()['completed'] ){
  334.                 $alert = [
  335.                     "header" => $translator->trans('Completed!'),
  336.                     "severity" => "info"
  337.                 ];
  338.                 $suitable = false;
  339.             }
  340.             // Overwrite if expired
  341.             if ( !$project->getStatus()['completed'] && $project->getEndAt() && $aisDate->date($project->getEndAt())->lowerThan(new \DateTimeImmutable('now'))) {
  342.                 $alert = [
  343.                     "header" => $project->getName() . " " . $translator->trans(' has expired'),
  344.                     "severity" => "success"
  345.                 ];
  346.                 $suitable = false;
  347.             }
  348.         }
  350.         return [
  351.             "suitable" => $suitable,
  352.             "notifications" => $alert
  353.         ];
  357.     }
  359.     private function serializeProjects( array $projects, SerializerInterface $serializer): array {
  360.         return json_decode( $serializer->serialize( $projects, 'json', [
  361.             'groups' => [
  362.                 "project.list.with.necessary.details",
  363.                 "project.details.orders",
  364.                 "project.details"
  365.             ]
  366.         ]));
  367.     }
  369.     private function getUserAccessedProjects(User $user, EntityManagerInterface $manager, SerializerInterface $serializer): array {
  371.         $allProjects = new ArrayCollection($manager->getRepository(Projects::class)->findAll());
  373.         #dd($user->getUserScopedItems()->toArray());
  374.         $userScopedForProjectList = $user->getUserScopedItems()->filter(function(/**@var UserScopedItem $scopedItem */ $scopedItem){
  375.             return $scopedItem->getScopedItem()->getCategory()
  376.                 === ModulesAccessTypes::E_MODULES_SCOPED_CATEGORIES_PROJECT && $scopedItem->getScopedItem()->getType() === ModulesAccessTypes::E_MODULES_SCOPED_TYPES_LIST;
  377.         })->first();
  379.         #dd($userScopedForProjectList->isOnlyOwned());
  381.         #dd($allProjects);
  383.         #dd($userScopedForProjectList);
  385.         $isAdmin = (in_array('ROLE_ADMIN', $user->getRoles()) || in_array('ROLE_SUPER_ADMIN', $user->getRoles()));
  387.         if($userScopedForProjectList) {
  388.             $userScopedForProjectList = $userScopedForProjectList->isOnlyOwned();
  389.             if ($userScopedForProjectList) {
  390.                 $filteredProjects = $allProjects->filter(function (/**@var Projects $project */ $project) use ($user) {
  391.                     // NEDEN LEAD ICIN YAPIMIS ??? ⚠️ SADECE USER ONLY OWNED MI CONTROLU YETERLI
  392. //                        return $project->getProjectOrders()->exists(function($key, /**@var ProjectOrders $projectOrder*/ $projectOrder) use ($user) {
  393. //                            // Eğer sipariş lideri yoksa, sadece debug için dump
  394. //                            if ($projectOrder->getOrderLead() === null) {
  395. //                                #dump($projectOrder->getProject()->getProjectId());
  396. //                            }
  397. //                            // Sipariş lideri mevcutsa, kullanıcı eşleşmesini kontrol et
  398. //                            $orderLeadUser = null;
  399. //                            if( $projectOrder->getOrderLead() ){
  400. //                                $orderLeadUser = $projectOrder->getOrderLead()->getUser();
  401. //                                if(!is_null($orderLeadUser)){
  402. //                                    if($orderLeadUser->getId() === $user->getId()){
  403. //                                        #dump($orderLeadUser->getId(), $user->getId());
  404. //                                        return true;
  405. //                                    }
  406. //
  407. //                                }
  408. //                            }
  409. //                            return false;
  410. //                        });
  411. //                        // return $project->getProjectOrders()->filter( fn( Projects $project) => true );
  412.                     // return $project->getProjectOrders()->exists( fn(ProjectOrders $projectOrder ) => $projectOrder->getOrderLead()?->getUser()->getId() === $user->getId() );
  413.                     return $project->getProjectOrders()->contains(function (ProjectOrders $projectOrder) use ($user) {
  414.                         return $projectOrder->getOrderLead() && $projectOrder->getOrderLead()->getUser()->getId() === $user->getId() || $projectOrder->getOrderAlternateLeads()->exists(fn(WorkerActivities $workerActivity) => $workerActivity->getUser()->getId() === $user->getId());
  415.                     });
  416.                 });
  417.                 #
  419.                 $filteredProjects = $allProjects->filter(function (Projects $project) use ($user, $isAdmin) {
  420.                     foreach ($project->getProjectOrders() as /**@var ProjectOrders $projectOrder*/$projectOrder) {
  422.                         // Global Permissions
  423.                         $globalPermission = $projectOrder->getOrderPrimaryLead() && $projectOrder->getOrderPrimaryLead()->getWorkerActivitySubstitutions()->exists(
  424.                             fn ( $key, WorkerActivities $_workerActivity) => $_workerActivity->getId() === $this->getUser()->getUserAsWorkerLatestActivity()->getId()
  425.                         );
  426.                         // Order Based Permissions
  427.                         $orderBasedPermission = $projectOrder->getOrderAlternateLeads() && $projectOrder->getOrderAlternateLeads()->exists(
  428.                             fn( $key, WorkerActivities $workerActivity ) => $workerActivity->getId() === $this->getUser()->getUserAsWorkerLatestActivity()->getId()
  429.                         );
  430.                         // Scoped (Isolated) item's
  431.                         $scopeIsolated = ($projectOrder->getOrderPrimaryLead() && $projectOrder->getOrderPrimaryLead()->getUser()) && $projectOrder->getOrderPrimaryLead()->getUser()->getId() === $user->getId();
  433.                         return $isAdmin || ($globalPermission || (($orderBasedPermission || $scopeIsolated)));
  435.                     }
  436.                     return false;
  437.                 });
  439.                 $allProjects = $filteredProjects;
  440.             }
  442.         }
  443.         #dd();
  444.         #dd($allProjects->count());
  446.         $archived   = [];
  447.         $trashed    = [];
  448.         $active     = [];
  450.         #dd();
  452.         $allProjects->map( function( /**@var Projects $project */$project) use(&$archived, &$trashed, &$active){
  453.             if( !$project->isRecycle()){
  454.                 if($project->isArchived()){
  455.                     $archived[] = $project;
  456.                 } else {
  457.                     $active[] = $project;
  458.                 }
  459.             } else {
  460.                 $trashed[] = $project;
  461.             }
  462.         });
  464.         return [
  465.             "archived" => $this->serializeProjects($archived, $serializer),
  466.             "trashed" => $this->serializeProjects($trashed, $serializer),
  467.             "active" => $this->serializeProjects($active, $serializer),
  468.         ];
  470.     }
  472.     /**
  473.      * @Route("/fetch-projects-for-administrative-customer/{classify}", name="fetch_projects_for_administrative_customer")
  474.      * @param EntityManagerInterface $manager
  475.      * @param SerializerInterface $serializer
  476.      * @param string $classify
  477.      * @return Response
  478.      */
  479.     public function fetchProjectsForAdministrativeCustomer( EntityManagerInterface $manager, SerializerInterface $serializer, string $classify = 'active' ): Response {
  481.             /**@var $user User */
  482.             $user = $this->getUser();
  484.             #dd($this->getUser());
  485.             
  486.             $administrative = $manager->getRepository(Administrative::class)->findAdministrative();
  488.             // dd($administrative->getPairedCustomer()->getProjectStakeholders()->toArray());
  489.             if(!$administrative){
  490.                 return $this->json([
  491.                     "message" => "No any customer as administrative found!",
  492.                     "severity" => "error"
  493.                 ], Response::HTTP_NOT_FOUND, [], []);
  494.             }
  496.             # $fetchAdministrativeProjects = $manager->getRepository(Projects::class)->fetchAdministrativeProjects($administrative->getPairedCustomer()->getId(), $classify );
  497.             #dd($fetchAdministrativeProjects);
  498.             # $projects = $this->serializeProjects($fetchAdministrativeProjects, $serializer);
  500.         #dd('fetchProjectsForAdministrativeCustomer_12');
  502.         return $this->json([
  503.             # "projects" => $projects,
  504.             #"projects" => $allProjects,
  505.             "disposed" => $this->getUserAccessedProjects( $user, $manager, $serializer ),
  506.             "classify" => $classify
  507.         ], Response::HTTP_OK, [], []);
  508.     }
  510.     /**
  511.      * @Route("/fetch-projects-for-timesheet", name="fetch_projects_for_timesheet")
  512.      * @param EntityManagerInterface $manager
  513.      * @param SerializerInterface $serializer
  514.      * @return JsonResponse
  515.      */
  516.     public function fetchProjectsForTimesheet( EntityManagerInterface $manager, SerializerInterface $serializer ): Response {
  518.         $administrative = $manager->getRepository(Administrative::class)->findAdministrative();
  519.         if(!$administrative){
  520.             return $this->json([
  521.                 "message" => "No any customer as administrative found!",
  522.                 "severity" => "error"
  523.             ], Response::HTTP_NOT_FOUND, [], []);
  524.         }
  525.         
  526.         $projects = $manager->getRepository(Projects::class)->findAll();
  527.         $projects = json_decode($serializer->serialize($projects, 'json', [
  528.             'groups' => [
  529.                 'project.details.for.collected.timesheet',
  530.                 'order.base',
  531.                 'project.branches'
  532.             ]
  533.         ]));
  534.         
  535.         return $this->json([
  536.             "projects" => $projects
  537.         ], Response::HTTP_OK, [], []);
  538.     }
  540.     /**
  541.      * @deprecated using from one Component Future will Remove
  542.      * @see fetch-projects-for-administrative-customer
  543.      * nullable customer_id need while check customer status in core projects
  544.      * @Route("/fetch-projects/{customer_id}", name="fetch_weak_list", defaults={"customer_id":null})
  545.      * @ParamConverter("customer", options={"mapping":{"customer_id": "id"}})
  546.      * @param EntityManagerInterface $manager
  547.      * @param SerializerInterface $serializer
  548.      * @return Response
  549.      * Customer Analyse for projects
  550.      */
  551.     public function fetchProjects( EntityManagerInterface $manager, SerializerInterface $serializer ): Response
  552.     {
  555.         #dd("fetch-projects");
  556.         $projectsEntity = new ArrayCollection($manager->getRepository(Projects::class)->findAll());
  557.         $projects = json_decode( $serializer->serialize( $projectsEntity, 'json', [
  558.             'groups' => [
  559.                 "project.selectable.list"
  560.             ]
  561.         ]));
  562.         
  563.         return $this->json([
  564.             "projects" => $projects
  565.         ], Response::HTTP_OK, [], []);
  567.     }
  569.     /**
  570.      * @param Customer|null $customer
  571.      * @param Projects|null $project
  572.      * @param StatusCodes $codes
  573.      * @param SerializerInterface $serializer
  574.      * @param AisDate $aisDate
  575.      * @param TranslatorInterface $translator
  576.      * @param int|null $project_id
  577.      * @return Response
  578.      * @throws \Exception
  579.      * @Route("/core-joinable-project/{customer_slug}/{project_id}", name="core_joinable_project", methods={"POST"}, defaults={"project_id":null})
  580.      * @ParamConverter("project", options={"mapping":{"project_id":"id"}})
  581.      * @ParamConverter("customer", options={"mapping":{"customer_slug":"slug"}})
  582.      */
  583.     public function fetchCoreJoinableProject( ?Customer $customer, ?Projects $project, StatusCodes $codes, SerializerInterface $serializer, AisDate $aisDate, TranslatorInterface $translator, ?int $project_id ): Response{
  585.         if( !$project ){
  586.             return $this->json([
  587.                 'message' => $translator->trans('Project not found!'),
  588.                 "severity" => "error",
  589.                 "variant"=>"snackbar"
  590.             ], Response::HTTP_NOT_FOUND );
  591.         }
  594.         $serializedProject = json_decode( $serializer->serialize( $project, 'json', [
  595.             'groups' => [
  596.                 'stakeholder.selected.core.project.manage'
  597.             ]
  598.         ]));
  600.         return $this->json([
  601.             "customStatus" => $this->coreProjectPrettyStatusData( $project, $customer, $aisDate, $translator ),
  602.             "project" => $serializedProject,
  603.             'updatePath' => $this->generateUrl('customer_join_to_project', ['slug'=>$customer->getSlug()])
  604.         ], Response::HTTP_OK, [], [
  605.             AbstractNormalizer::IGNORED_ATTRIBUTES => [ ]
  606.         ]);
  607.     }
  610.     /**
  611.      * @Route("/save-project/{project_id}", name="save_project", defaults={"project_id": null })
  612.      * @ParamConverter("project", options={"mapping":{"project_id": "id"}})
  613.      * @param Projects|null $project
  614.      * @param EntityManagerInterface $manager
  615.      * @param AisDate $aisDate
  616.      * @param SerializerInterface $serializer
  617.      * @param TranslatorInterface $translator
  618.      * @param Request $request
  619.      * @return Response
  620.      * @throws \Exception
  621.      */
  622.     public function save( ?Projects $project, EntityManagerInterface $manager, AisDate $aisDate, SerializerInterface $serializer, TranslatorInterface $translator, Request $request, int $project_id = null ): Response
  623.     {
  624.         $params = $request->request;
  626.        #dd($params);
  628.         // @deprecated this mode use user_rights
  629. //        /**@var $userRole AccessRoles */
  630. //        $userRole =$this->getUser()->getUserAccessedRoles()->filter(function(/**@var $item AccessRoles*/$item){
  631. //            return $item->getAccessType()->getName() === 'Project';
  632. //        })->first();
  633. //
  634. //        /**@var $user User */
  635. //        $user = $this->getUser();
  636. //
  637. //        $userAccess = $user->getUserRights();
  638. //
  639. //
  640. //
  641. //
  642. //        if( !$userRole ){
  643. //            return $this->json([
  644. //                'message' => $translator->trans('Access role required for this operation.'),
  645. //                "severity" => "error",
  646. //                "variant"=>"snackbar"
  647. //            ], Response::HTTP_NOT_ACCEPTABLE );
  648. //        }
  652.         try{
  654.             if( $project_id && !$project ){
  655.                 return $this->json([
  656.                     "message" => $translator->trans('Project not found!') ,
  657.                     "severity"=>"warning"
  658.                 ], Response::HTTP_NOT_FOUND);
  659.             }
  662.             if( !$project ){
  663.                 // Check same ID already created
  664.                 $projectIdFound = $manager->getRepository( Projects::class )->findOneBy(['project_id' => $params->get('project_id')]);
  665.                 if($projectIdFound){
  666.                     return $this->json([
  667.                         "message" => $params->get('project_id') . ' ' . $translator->trans(', Project-ID already added, please try another one!') ,
  668.                         "severity"=>"warning"
  669.                     ], Response::HTTP_UNAUTHORIZED);
  670.                 }
  672.                 $project = new Projects();
  674.                 $project
  675.                     ->setProjectId( $params->get('project_id'))
  676.                     ->setCreatedAt( new \DateTimeImmutable('now'));
  677.             }
  680.             $project->setProjectId($params->get('project_id'));
  682.             /**@var $countryEntity Countries*/
  683.             $countryEntity = null;
  684.             if( intval($params->get('country')) ){
  685.                 $countryEntity = $manager->getRepository(Countries::class)->find($params->get('country'));
  686.             }
  688.             $project
  689.                 ->setName( $params->get('name') )
  690.                 ->setStartAt( new \DateTimeImmutable($params->get('start_at')))
  691.                 ->setEndAt( $params->get('end_at') ? new \DateTimeImmutable($params->get('end_at')) : null )
  692.                 // ->setCost(floatval($params->get('cost')) ? $params->get('cost') : null )
  693.                 //                // ->setLongitude($params->get('longitude'))
  694.                 //                // ->setLatitude($params->get('latitude'))
  695.                 //                // ->setScanDistance(intval($params->get('scan_distance')) ? $params->get('scan_distance') : null )
  696.                 //                ->setRewardTime(intval($params->get('reward_time')) ? $params->get('reward_time') : null )
  697.                                 // ->setWorkPause( intval($params->get('work_pause')) ? $params->get('work_pause') : null )
  698.                                 // ->setWorkingTimeStart($params->get('working_time_start'))
  699.                                 // ->setWorkingTimeStop($params->get('working_time_stop'))
  700.                                 // ->setAddress($params->get('address'))
  701.                                 // ->setCodePostal($params->get('code_postal'))
  702.                 ->setTown($params->get('town'))
  703.                 ->setCountry( $countryEntity )
  705.             ;
  707.             if(!empty($params->get('invoice_type'))){
  708.                 $invoice_type = $manager->getRepository(InvoiceType::class)->find($params->get('invoice_type'));
  709.                 $project->setInvoiceType($invoice_type);
  710.             }
  712.             $projectSettings = $project->getProjectSettings();
  713.             $target_profit = intval($params->get('target_profit')) ?? 0;
  714.             $material_budget = intval($params->get('material_budget')) ?? 0;
  716.             if( !$projectSettings ){
  717.                 $projectSettings = new ProjectSettings();
  718.             }
  720.             $projectSettings
  721.                 ->setTargetProfit($target_profit)
  722.                 ->setMaterialBudget($material_budget)
  723.                 ->setTimesheetBudget(100 - ($target_profit + $material_budget));
  725.             $project->setProjectSetting($projectSettings);
  728.             if( !empty($params->get('owner'))){
  729.                 $owner = $manager->getRepository(ProjectOwner::class)->find($params->get('owner'));
  730.                 $project->setOwner($owner);
  731.             }
  733.             $collectionRequiresErrors = [];
  735.             if($params->get('project_branches') === null) {
  736.                 $collectionRequiresErrors[] = [
  737.                     'message' => $translator->trans('At least one branch is required.'),
  738.                     'severity' => SeverityInterface::WARNING
  739.                 ];
  740.             }
  742.             if($params->get('dependent_qualifications') === null) {
  743.                 $collectionRequiresErrors[] = [
  744.                     'message' => $translator->trans('At least one qualification is required.'),
  745.                     'severity' => SeverityInterface::WARNING
  746.                 ];
  747.             }
  749.             if($params->get('dependent_certificates') === null) {
  750.                 $collectionRequiresErrors[] = [
  751.                     'message' => $translator->trans('At least one certificate is required.'),
  752.                     'severity' => SeverityInterface::WARNING
  753.                 ];
  754.             }
  756.             if(count($collectionRequiresErrors)){
  757.                 return $this->json([
  758.                     'errors' => $collectionRequiresErrors
  759.                 ], Response::HTTP_NOT_ACCEPTABLE);
  760.             }
  766.             $project = $this->manageProjectQualifications($project, $manager, $params->get('dependent_qualifications') );
  767.             $project = $this->manageProjectCertificates($project, $manager, $params->get('dependent_certificates') );
  769.             $this->appendBranchToProject( $project, $manager, (array)$params->get('project_branches') );
  771.             $manager->persist( $project );
  772.             $manager->flush();
  773.             $manager->refresh($project);
  775.         } catch (\Exception $exception) {
  776.             return $this->json([
  777.                 'message' => 'Error by core project save ' . $exception->getMessage()
  778.             ], Response::HTTP_UNAUTHORIZED);
  779.         }
  781.         $project_ = json_decode($serializer->serialize( $project, 'json', [
  782.             'groups' => [
  783.                 'project.base',
  784.                 'project.branches',
  785.                 'project.expenses',
  786.                 'project.owner',
  787.                 'project.qualifications',
  788.                 'project.certificates',
  789.                 'project.orders',
  791.                 "project.details.orders"
  792.             ]
  793.         ]), true );
  796.         return $this->json([
  797.             "message"=>$translator->trans('Project added successfully'),
  798.             "severity" => "success",
  799.             "project" => $project_,
  800.             "classify" => $params->get('classify')
  801.         ], Response::HTTP_OK, [], [
  802.             AbstractNormalizer::IGNORED_ATTRIBUTES => []
  803.         ] );
  804.     }
  806.     /**
  807.      * @Route("/save-partial-append-branches-to-project/{project_id}", name="save_partial_append_branches_to_project", defaults={"project_id": null })
  808.      * @ParamConverter("project", options={"mapping":{"project_id": "id"}})
  809.      * @param Projects|null $project
  810.      * @param EntityManagerInterface $manager
  811.      * @param AisDate $aisDate
  812.      * @param SerializerInterface $serializer
  813.      * @param TranslatorInterface $translator
  814.      * @param Request $request
  815.      * @return Response
  816.      * @throws \Exception
  817.      */
  818.     public function savePartialAppendBranches( ?Projects $project, EntityManagerInterface $manager, SerializerInterface $serializer, TranslatorInterface $translator, Request $request, int $project_id = null ): Response{
  821.         $params = $request->request;
  823.         #dd($params->all());
  824.         $project = $this->appendBranchToProject( $project, $manager, (array)$params->get('project_branches') );
  826.         $manager->persist( $project );
  827.         $manager->flush();
  828.         $manager->refresh($project);
  830.         $project_ = json_decode($serializer->serialize( $project, 'json', [
  831.             'groups' => [
  832.                 'project.base',
  833.                 'project.branches',
  834.                 'project.expenses',
  835.                 'project.owner',
  836.                 'project.qualifications',
  837.                 'project.certificates',
  838.                 'project.orders'
  839.             ]
  840.         ]), true );
  843.         return $this->json([
  844.             "message"=>$translator->trans('Project added successfully'),
  845.             "severity" => "success",
  846.             "project" => $project_
  847.         ], Response::HTTP_OK, [], [
  848.             AbstractNormalizer::IGNORED_ATTRIBUTES => []
  849.         ] );
  851.     }
  853.     /**
  854.      * @Route("/fetch/{project_id}", name="project_fetch", defaults={"project_id": null}, methods={"POST", "GET"})
  855.      * @ParamConverter("project", options={"mapping":{"project_id": "id"}})
  856.      * @param Projects|null $project
  857.      * @param EntityManagerInterface $manager
  858.      * @param SerializerInterface $serializer
  859.      * @return Response
  860.      */
  861.     public function fetch( ?Projects $project, EntityManagerInterface $manager, SerializerInterface $serializer ): Response
  862.     {
  863.         #dd(12);
  864.         /*return $this->json([
  865.             "message"=>"Error",
  866.             "severity" => "error"
  867.         ], Response::HTTP_NOT_FOUND, [], [
  868.             AbstractNormalizer::IGNORED_ATTRIBUTES => []
  869.         ] );*/
  870.         // dd($project->getProjectBranches()->toArray());
  871.         $countries = $manager->getRepository(Countries::class)->findAll();
  873.         /**@var $qualificationsRepo QualificationRepository*/
  874.         $qualificationsRepo = $manager->getRepository(Qualification::class);
  875.         $qualifications = $qualificationsRepo->fetchWeak(); // All
  877.         /**@var $certificatesRepo CertificatesRepository*/
  878.         $certificatesRepo = $manager->getRepository(Certificates::class);
  879.         $certificates = $certificatesRepo->fetchWeakByName(); // All
  881.         /**@var $certificateGroupsRepo CertificatesGroups*/
  882.         $certificateGroups = $manager->getRepository(CertificatesGroups::class)->findAll();
  885.         /**@var $projectBranchesRepo BranchesRepository */
  886.         $projectBranchesRepo = $manager->getRepository(Branches::class);
  887.         $branches = $projectBranchesRepo->findAll(); // All
  889.         /**@var $projectOwners ProjectOwner*/
  890.         $projectOwnersRepo = $manager->getRepository(ProjectOwner::class);
  891.         $projectOwners = $projectOwnersRepo->findAll(); // All
  893.         /**@var $projectOwners ProjectOwner*/
  894.         $invoiceTypesRepo = $manager->getRepository(InvoiceType::class);
  895.         $invoiceTypes = $invoiceTypesRepo->findAll(); // All
  897.         $project_ = $serializer->serialize( $project, 'json', [
  898.             'groups' => [
  899.                 'project.base',
  900.                 'project.branches',
  901.                 'project.expenses',
  902.                 'project.owner',
  903.                 'project.qualifications',
  904.                 'project.certificates',
  906.                 'project.settings',
  907.                 'project.setting.core',
  908.                 
  909.                 
  910.                 'project.orders',
  911.                 "project.details.orders",
  913.                 // "project.details.orders.expenses",
  914.                 // "project.orders.expense.base",
  915.                 "project.orders.expense.positions",
  916.                 "project.orders.expense.position.base",
  919.                 "project_order@stock_issues",
  920.                 "stock_issue@core",
  922.             ]
  923.         ]);
  927.         $countries_ = $serializer->serialize( $countries, 'json', [ 'groups' => ['countries.base']]);
  928.         $branches_ = $serializer->serialize( $branches, 'json', ['groups' => ['branches.base', 'branches.location.base']]);
  929.         $project_owners = $serializer->serialize( $projectOwners, 'json', ['groups' => ['project.owner']]);
  930.         $invoice_types = $serializer->serialize( $invoiceTypes, 'json', ['groups' => ['invoice.type.base']]);
  932.         $certificate_groups = $serializer->serialize( $certificateGroups, 'json', ['groups' => ['certificate.group.base']]);
  933.         $certificate_groups = json_decode($certificate_groups, true);
  935.         $project = json_decode( $project_ );
  936.         $countries = json_decode( $countries_ );
  937.         $branches = json_decode( $branches_ );
  938.         $project_owners = json_decode( $project_owners );
  939.         $invoice_types = json_decode( $invoice_types );
  942.         #dd($project);
  944.         #dd($project);
  946.         return $this->json([
  947.             "certificates"=>$certificates,
  948.             "certificate_groups" => $certificate_groups,
  949.             "qualifications"=>$qualifications,
  950.             'project'=>$project,
  951.             'countries'=>$countries,
  952.             'branches_collection' => $branches,
  953.             'project_owners' => $project_owners,
  954.             'invoice_types' => $invoice_types
  955.         ], Response::HTTP_OK );
  957.     }
  959.     /**
  960.      * @deprecated
  961.      * info for Stakeholder not more Use fetch direct Project!
  962.      * @Route("/project-stakeholder-timesheet-pdf-as-project-wait-for-check/{project_stakeholder_id}", name="project_stakeholder_timesheet_pdf_as_project_wait_for_check", methods={"POST", "GET"})
  963.      * @param Request $request
  964.      * @param RgbToHex $rgbToHex
  965.      * @param EntityManagerInterface $manager
  966.      * @param TimesheetReaderInterface $timesheetReader
  967.      * @param ProjectStakeholders|null $projectStakeholder
  968.      * @param SerializerInterface $serializer
  969.      * @param PdfOutputTimesheet $pdfOutputTimesheet
  970.      * @param StatusCodes $codes
  971.      * @param TranslatorInterface $translator
  972.      * @param int $project_stakeholder_id
  973.      * @return Response
  974.      * @ParamConverter("projectStakeholder", options={"mapping":{"project_stakeholder_id":"id"}})
  975.      */
  976.     public function _wait_for_check_stakeholderTimesheet(Request $request, RgbToHex $rgbToHex, EntityManagerInterface $manager, TimesheetReaderInterface $timesheetReader, ?ProjectStakeholders $projectStakeholder, SerializerInterface $serializer, PdfOutputTimesheet $pdfOutputTimesheet, StatusCodes $codes, TranslatorInterface $translator, int $project_stakeholder_id ): Response
  977.     {
  978.         $timesheets = null;
  979.         $years = $request->request->get('years');
  980.         $is_guest = $request->request->get('is_guest');
  982.         $projectJoinedEmployees = $projectStakeholder->getProject()->getStakeholders()->filter(function(/**@var $stakeholder ProjectStakeholders */$stakeholder) use ($is_guest, $projectStakeholder){
  983. //            if( $is_guest !== "true" ){
  984. //                return $stakeholder->getId() === $projectStakeholder->getId();
  985. //            }
  986.             return $stakeholder;
  987.         })->map(function(/**@var $stakeholder ProjectStakeholders */$stakeholder) use ( $is_guest, $projectStakeholder ){
  988.             return $stakeholder->getWorkerInProjects()->getValues();
  989.         });
  993.         $serializedWorkersInProject = json_decode($serializer->serialize( $projectJoinedEmployees , 'json', [
  994.             'groups' => [
  995.                 'timesheet.for.stakeholder'
  996.             ],
  997.             AbstractNormalizer::IGNORED_ATTRIBUTES => [
  998.                 // 'worker_timesheets'
  999.             ]
  1000.         ]) , true );
  1003.         #dd($serializedWorkersInProject);
  1004.         $serializedWorkersInProject = call_user_func_array('array_merge', $serializedWorkersInProject);
  1006.         /// Filtered For Current Project
  1007.         $collection = new ArrayCollection($serializedWorkersInProject);
  1008.         $accessedYears  = [(new DateTimeImmutable('now'))->format('Y')]; // Initial
  1009.         if( $years ) {
  1010.             $accessedYears  = json_decode($years); // <-- Should as param
  1011.         }
  1012.         // Overwrite for another process
  1013.         $years = [];
  1015.         $timesheetStatus = (new ArrayCollection($manager->getRepository(TimesheetStatus::class)->findAll() ?? []))->map( function(/**@var $item TimesheetStatus*/ $item ) use ($rgbToHex){
  1016.             // Manipulate color to Hex
  1017.             $item->setAbsenceColorHex($rgbToHex->convertWithArray($item->getAbsenceBrColor()));
  1018.             return $item;
  1019.         });
  1020.         // Initial Values
  1021.         $timesheetReader
  1022.             ->setTimesheetStatusCollection($timesheetStatus)
  1023.             // ->setProjectStakeholders( $projectStakeholder );
  1024.             ->readerPathManager( $projectStakeholder->getProject(), null, null );
  1026.         #dd($collection);
  1028.         array_map(function( $accessedYear ) use ( &$years, $is_guest, $collection, $timesheetReader, $timesheetStatus, &$final_times, &$final_costs ){
  1030.             $yearly_times = [];
  1031.             $yearly_costs = [];
  1033.             $final_month_times = [];
  1034.             $final_costs = [];
  1036.             #dd($collection);
  1037.             // Done Empty Workers for current year
  1038.             $workers = [];
  1039.             // Project Stakeholder workers Collection Loop
  1040.             $collection->filter(function($workerActivity) use ($is_guest){
  1041.                 return $workerActivity; // $workerActivity['worker_activity']['guest'] === "1" && $is_guest === "true";
  1042.             })->map(function($workerActivity) use (
  1043.                 &$yearly,
  1044.                 &$workers,
  1045.                 $accessedYear,
  1046.                 $timesheetReader,
  1047.                 $timesheetStatus,
  1048.                 &$yearly_times,
  1049.                 &$yearly_costs,
  1050.                 &$final_month_times,
  1051.                 &$final_costs
  1052.             ){
  1054.                 $_worker = [
  1055.                     "id" => $workerActivity['worker_activity']["id"],
  1056.                     "name" => $workerActivity['worker_activity']['worker']["name"],
  1057.                     "surname" => $workerActivity['worker_activity']['worker']["surname"],
  1058.                     "customer" => $workerActivity['worker_activity']['customer']["company"],
  1059.                     "guest" => $workerActivity['worker_activity']['guest']
  1061.                 ];
  1062.                 // Worker Timesheet Source
  1063.                 $foundedYear = array_filter( $workerActivity['worker_activity']['worker_timesheets'], function( $timesheetForYear ) use ( $accessedYear ){
  1064.                     return $timesheetForYear['year'] === $accessedYear;
  1065.                 });
  1067.                 // Update Worker Element with timesheet
  1068.                 // try{
  1069.                 if( $foundedYear ){
  1071.                     $foundedYear = array_values($foundedYear);
  1072.                     $foundedYear = $foundedYear[0];
  1075.                     $pattern = '/^m\d+_d\d+?$/';
  1076.                     $activeColumns = array_filter( array_keys($foundedYear), function($item) use ($pattern) {
  1077.                         return preg_match($pattern, $item);
  1078.                     });
  1079.                     $activeColumns = array_values($activeColumns);
  1080.                     try{
  1081.                         foreach ($foundedYear as $key => $item ) {
  1082.                             if( !in_array($key, $activeColumns) ){
  1083.                                 unset($foundedYear[$key]);
  1084.                             }
  1085.                         }
  1086.                     }catch (\Exception $exception ){
  1087.                         dd($exception->getMessage());
  1088.                     }
  1090.                     $months = $monthsFinal = [];
  1091.                     // Loop Months
  1092.                     foreach ( range(1, 12) as $monthIndex ) {
  1093.                         $timesheetReader->setMonth($monthIndex);
  1094.                         $workerMonthTimeCollection = $workerMonthCostCollection = $workerMonthInactiveTimeCollection = $workerMonthInactiveCostCollection = [];
  1096.                         $pattern = '/m' . $monthIndex . '_d\d/';
  1097.                         // Get days of current month
  1098.                         $activeColumns = array_filter( array_keys($foundedYear), function($item) use ($pattern) {
  1099.                             return preg_match($pattern, $item);
  1100.                         });
  1103.                         foreach ( $activeColumns as $dayKey ) {
  1106.                             $timesheetReader->setDayKey($dayKey)->setData($foundedYear[$dayKey]);
  1107.                             // $readData = $timesheetReader->readTimeExtend();
  1108.                             #dump($foundedYear[$dayKey]);
  1109.                             $readData = $timesheetReader->readTimeExtendRolesBasic();
  1110.                             #dump($readData);
  1113.                             if( array_key_exists($timesheetReader::KEY_TIME_PROP, $readData )){
  1115.                                 switch ($readData[$timesheetReader::KEY_COST_TYPE]){
  1116.                                     case $timesheetReader::KEY_COST_TYPE_ACTIVE:
  1117.                                         $workerMonthTimeCollection[] = $readData[$timesheetReader::KEY_TIME_PROP];
  1118.                                         $workerMonthCostCollection[] = $readData[$timesheetReader::KEY_COST];
  1119.                                         break;
  1120.                                     case $timesheetReader::KEY_COST_TYPE_INACTIVE:
  1121.                                         $workerMonthInactiveTimeCollection[] = $readData[$timesheetReader::KEY_TIME_PROP];
  1122.                                         $workerMonthInactiveCostCollection[] = $readData[$timesheetReader::KEY_COST];
  1123.                                         break;
  1124.                                 }
  1125.                             }
  1126.                         }
  1129.                         // Employee month
  1130.                         $months[$monthIndex] = [
  1131.                             "times" => array_sum($workerMonthTimeCollection),
  1132.                             "costs" => array_sum($workerMonthCostCollection),
  1133.                         ];
  1134.                         // Inactive Times
  1135.                         $monthsFinal[$monthIndex] = [
  1136.                             "times" => array_sum(array_merge($workerMonthInactiveTimeCollection, $workerMonthTimeCollection)),
  1137.                             "costs" => array_sum(array_merge($workerMonthInactiveCostCollection, $workerMonthInactiveCostCollection)),
  1138.                         ];
  1140.                         // Final month
  1141.                         // $final_month_times[$monthIndex][] =
  1142.                     }
  1144.                     $_worker["months"] = $months;
  1145.                     $_worker["months_final"] = $monthsFinal;
  1146.                     $_worker["yearTimes"] = array_sum(array_map( function ( $month ){
  1147.                         return floatval($month['times']);
  1148.                     }, $months ));
  1149.                     $_worker["yearCosts"] = array_sum(array_map( function ( $month ){
  1150.                         return floatval($month['costs']);
  1151.                     }, $months ));
  1153.                     $yearly_times[] = $_worker["yearTimes"];
  1154.                     $yearly_costs[] = $_worker["yearCosts"];
  1157.                     $workers[] = $_worker;
  1158.                 }
  1160.             });
  1163.             dump(array_sum($yearly_times));
  1165.             // Append created worker to accessed year
  1166.             $years[$accessedYear]['workers'] = $workers;
  1167.             $years[$accessedYear]['times'] = array_sum($yearly_times);
  1168.             $years[$accessedYear]['costs'] = array_sum($yearly_costs);
  1169.             if($yearly_times > 0 ){
  1170.                 dump($years);
  1171.             }
  1172.         }, $accessedYears );
  1175.         #dd(array_sum(array_map(function($item){ return $item['times']; }, $years )));
  1177.         #dump($final_times);
  1178.         #dump($final_costs);
  1179.         #dd();
  1180.         #dd($is_guest);
  1181.         # dd($years);
  1182.         try{
  1183.             $output = null;
  1184.             $pdfOutputTimesheet->setPrintedBy( $this->getUser()->getEmail());
  1185.             $output = $pdfOutputTimesheet->stakeholderTimesheet(
  1186.                 $translator->trans('Timesheet') . ' ' . $projectStakeholder->getProject()->getName() . ' ' . $projectStakeholder->getCustomer()->getCompany(),
  1187.                 $projectStakeholder->getCustomer()->getCompany() . ' in ' . $projectStakeholder->getProject()->getName(),
  1188.                 $years,
  1189.                 array_sum(array_map(function($item){ return $item['times']; }, $years )),
  1190.                 array_sum(array_map(function($item){ return $item['costs']; }, $years )),
  1191.                 'F'
  1192.             );
  1194.             if( $output->code !== Response::HTTP_OK ){
  1195.                 return $this->json([
  1196.                     'message' => $output->message,
  1197.                     "severity" => "error"
  1198.                 ], Response::HTTP_CONFLICT );
  1199.             }
  1201.         } catch (\Exception $exception){
  1202.             return $this->json([
  1203.                 'message' => $exception->getMessage(),
  1204.                 "severity" => "error"
  1205.             ], Response::HTTP_CONFLICT );
  1206.         }
  1208.         return $this->json([
  1209.             'message' => $translator->trans('Timesheet created successfully!'),
  1210.             "severity" => "success",
  1211.             'output'=>$output
  1212.         ]);
  1215.     }
  1217.     private function chartValueGetter( $value, $useOnePercent = false ){
  1218.         return is_numeric($value) ? ($useOnePercent ? $value / 100 : $value) : 0;
  1219.     }
  1220.     /**
  1221.      * @Route("/evaluate-profit-margin/{project_id}", name="app_project_evaluate_profit_margin", defaults={"project_id"=null})
  1222.      * @ParamConverter("project", options={"mapping":{"project_id": "id"}})
  1223.     */
  1224.     public function evaluateProfitMargin(?Projects $project, TranslatorInterface $translator): Response {
  1227.         $netRevenues       = [];
  1228.         $netProfitMargins   = [];
  1229.         $netExpenses       = [];
  1230.         $netHoursCostSpent = [];
  1231.         $netHoursSpent     = [];
  1232.         $netProfit          = [];
  1234.         $chartGroups        = [];
  1235.         $chartGroupColors   = [];
  1236.         // Chart Groups Data
  1237.         // Worked Times Data of all Contructions Managers
  1238.         $chartGroupsData[] = ["data" => []]; // Spent Times
  1239.         $chartGroupsData[] = ["data" => []]; // Revenue
  1240.         $chartGroupsData[] = ["data" => []]; // Expenses
  1241.         $chartGroupsData[] = ["data" => []]; // Cost Spent
  1242.         $chartGroupsData[] = ["data" => []]; // Profit
  1245.         $chartGroupsDataset = []; // Spent Times
  1247.         $profitMargins = [];
  1249.         if( !$project ){
  1250.             return $this->json([
  1251.                 'message' => $translator->trans('Project not found!'),
  1252.                 "severity" => "warning"
  1253.             ], Response::HTTP_CONFLICT );
  1254.         }
  1259.         // Calculate
  1260.         try{
  1261.             $project->getProjectOrders()->map(function (/**@var ProjectOrders $projectOrder*/$projectOrder) use (
  1262.                 &$profitMargins,
  1263.                 &$netRevenues,
  1264.                 &$netExpenses,
  1265.                 &$netHoursCostSpent,
  1266.                 &$netHoursSpent,
  1267.                 &$chartGroups,
  1268.                 &$chartGroupColors,
  1269.                 &$chartGroupsData,
  1270.                 $project,
  1272.                 &$chartGroupsDataset,
  1274.                 $translator
  1275.             ){
  1276.                 $defaultAverageProfitMargin = 20;
  1278.                 $profitMargin = $projectOrder->getTargetProfitAsPercent() ?? $defaultAverageProfitMargin;
  1279.                 $profitMargins[] = $profitMargin;
  1280.                 if(is_null($profitMargin)){
  1281.                     dump("Profit margin is null for {$projectOrder->getId()}");
  1282.                 }
  1283.                 else if ( $profitMargin <> 20 ) {
  1284.                     dump("Profit margin of order {$projectOrder->getId()} {$profitMargin}");
  1285.                 }
  1287.                 $netRevenues[] = $projectOrder->getOrderPrise();
  1289.                 $projectOrder->getProjectOrderExpensePositions()
  1290.                     ->filter(function(/**@var ProjectOrderExpensePositions $expensePosition */$expensePosition){
  1291.                         return !is_null($expensePosition->getAmount());
  1292.                     })->map(function(/**@var ProjectOrderExpensePositions $expensePosition */$expensePosition) use (&$netExpenses){
  1293.                         // return $expensePosition->getAmount() ? floatval($expensePosition->getAmount()) : 0;
  1294.                         $netExpenses[] = $expensePosition->getAmount() ? floatval($expensePosition->getAmount()) : 0;
  1295.                     });
  1297.                 $netHoursSpent[] = $projectOrder->getHoursSpent();
  1298.                 $netHoursCostSpent[] = $projectOrder->getCostSpent();
  1301.                 // Chart Grouplarini belirle
  1302.                 $foundedOrderLead = array_filter($chartGroups, function(/**@var User $user*/$user) use($projectOrder) {
  1303.                     return $projectOrder->getOrderLead() && $user
  1304.                         && $user->getId() === $projectOrder->getOrderLead()->getId();
  1305.                 });
  1307.                 if(!$foundedOrderLead){
  1309.                     $chartGroups[] = $projectOrder->getOrderLead();
  1311.                     $r = rand(100, 255); // 100-255
  1312.                     $g = rand(100, 255); // 100-255
  1313.                     $b = rand(100, 255); // 100-255
  1314.                     $chartGroupColors[] = "rgb({$r}, {$g}, {$b})";
  1316.                     // Chart Group Data yi olustur order lead a ait
  1318.                     $_hoursSpent = [];
  1319.                     $_workedCostSpent = [];
  1320.                     $_revenues = [];
  1321.                     $_expenses = [];
  1323.                     $project->getProjectOrders()
  1324.                         ->filter(function(/**@var ProjectOrders $_projectOrder*/$_projectOrder) use ($projectOrder) {
  1325.                             return $projectOrder->getOrderLead() && (!$_projectOrder->getOrderLead() || $_projectOrder->getOrderLead()->getId()
  1326.                                 === $projectOrder->getOrderLead()->getId());
  1327.                         })
  1328.                         ->map(function(/**@var ProjectOrders $_projectOrder*/$_projectOrder) use (
  1329.                             &$_hoursSpent,
  1330.                             &$_workedCostSpent,
  1331.                             &$_revenues,
  1332.                             &$_expenses
  1333.                         )
  1334.                         {
  1336.                             $__expense_pos_amounts = $_projectOrder->getProjectOrderExpensePositions()
  1337.                                 ->map(function (/**@var ProjectOrderExpensePositions $expensePosition*/ $expensePosition ){
  1338.                                     return !is_null($expensePosition->getAmount()) ? floatval($expensePosition->getAmount() ) : 0;
  1339.                                 })->toArray();
  1340.                             // Total Expenses for Lead assigned orders
  1341.                             $__expenses = array_reduce( $__expense_pos_amounts , function($carry, $item){
  1342.                                 return $carry + $item;
  1343.                             }, 0 );
  1344.                             $_workedCostSpent[] = $_projectOrder->getCostSpent();
  1345.                             $_hoursSpent[] = $_projectOrder->getHoursSpent();
  1346.                             $_revenues[] = $_projectOrder->getOrderPrise();
  1347.                             $_expenses[] = $__expenses;
  1349.                         }) ;
  1351.                     $_chartGroupsDataHoursSpent = array_reduce($_hoursSpent, function($carry, $item){
  1352.                         return $carry + $item;
  1353.                     }, 0 );
  1354.                     $_chartGroupsDataRevenue = array_reduce($_revenues, function($carry, $item){
  1355.                         return $carry + $item;
  1356.                     }, 0 );
  1357.                     $_chartGroupsDataExpense = array_reduce($_expenses, function($carry, $item){
  1358.                         return $carry + $item;
  1359.                     }, 0 );
  1360.                     $_chartGroupsDataWorkedCost = array_reduce($_workedCostSpent, function($carry, $item){
  1361.                         return $carry + $item;
  1362.                     }, 0 );
  1364.                     $_profit = $_chartGroupsDataRevenue - ( $_chartGroupsDataExpense + $_chartGroupsDataWorkedCost);
  1366.                     $chartGroupsData[0]["data"][] = is_numeric($_chartGroupsDataHoursSpent) ? $_chartGroupsDataHoursSpent : 0;
  1367.                     $chartGroupsData[1]["data"][] = is_numeric($_chartGroupsDataRevenue) ? $_chartGroupsDataRevenue / 100 : 0;
  1368.                     $chartGroupsData[2]["data"][] = is_numeric($_chartGroupsDataExpense) ? $_chartGroupsDataExpense / 100 : 0;
  1369.                     $chartGroupsData[3]["data"][] = is_numeric($_chartGroupsDataWorkedCost) ? $_chartGroupsDataWorkedCost / 100 : 0;
  1370.                     $chartGroupsData[4]["data"][] = is_numeric($_profit) ? $_profit / 100 : 0;
  1374.                     #dd($projectOrder->getOrderLead());
  1375. //                    $scoped = $this->getUser()->getUserScopedItems()->filter(function(/**@var $scopedItem UserScopedItem*/$scopedItem){
  1376. //                        return $scopedItem->getAccessFor() === 'project_chart';
  1377. //                    })->first();
  1378.                     /**@var $user User*/
  1379.                     $user = $this->getUser();
  1380.                     $scoped = $user->getUserScopedItems()->filter(function(/**@var $scopedItem UserScopedItem*/$scopedItem){
  1381.                         return $scopedItem->getScopedItem()->getCategory() === ModulesAccessTypes::E_MODULES_SCOPED_CATEGORIES_PROJECT && $scopedItem->getScopedItem()->getType() === ModulesAccessTypes::E_MODULES_SCOPED_TYPES_CHART;
  1382.                     })->first();
  1383.                     $onlyOwned = $scoped && $scoped->isOnlyOwned();
  1384.                     $ownedData = null;
  1385.                     try{
  1386.                         if(!is_null($projectOrder->getOrderLead())){
  1387.                             if( !is_null($projectOrder->getOrderLead()->getUser()) ){
  1388.                                 $ownedData = $this->getUser()->getId() === $projectOrder->getOrderLead()->getUser()->getId();
  1389.                             }
  1390.                         }
  1391.                     } catch (\Exception $e) {
  1393.                     }
  1394.                     // $ownedData = true;
  1395. //                    $chartGroupsDataset[] = [
  1396. //                        'timesheet' => is_numeric($_chartGroupsDataHoursSpent) ? $_chartGroupsDataHoursSpent : 0,
  1397. //                        'revenue' => is_numeric($_chartGroupsDataRevenue) ? $_chartGroupsDataRevenue / 100 : 0,
  1398. //                        'expenses' => is_numeric($_chartGroupsDataExpense) ? $_chartGroupsDataExpense / 100 : 0,
  1399. //                        'employee_cost' => is_numeric($_chartGroupsDataWorkedCost) ? $_chartGroupsDataWorkedCost / 100 : 0,
  1400. //                        'profit' => is_numeric($_profit) ? $_profit / 100 : 0,
  1401. //                        // 'owner' => substr($projectOrder->getOrderLead()->getName(), 0 ,1 ) . '. ' . $projectOrder->getOrderLead()->getSurname(),
  1402. //                        'owner' => $projectOrder->getOrderLead()->getName() . ' ' . $projectOrder->getOrderLead()->getSurname(),
  1403. //                        // 'ownerId' => $projectOrder->getOrderLead()->getId()
  1404. //                        // 'isLocked' => $scoped ? ($scoped->isOnlyOwned() ? true : $this->getUser()->getId() !== $projectOrder->getOrderLead()->getUser()->getId() : false ) : false  //$this->getUser()->getId() !== $projectOrder->getOrderLead()->getUser()->getId() // $scoped && ( && !($scoped->isOnlyOwned()))// : $this->getUser()->getId() !== $projectOrder->getOrderLead()->getUser()->getId() //&& ($scoped && $scoped->isOnlyOwned())
  1405. //                        'isLocked' => $ownedData ? false : $onlyOwned,
  1406. //                        'ownedData' => $ownedData,
  1407. //                        'onlyOwned' => $onlyOwned,
  1408. //                        'userId' => $this->getUser()->getId(),
  1409. //                        'orderLeadUserId' => $projectOrder->getOrderLead()->getUser()->getId()
  1410. //                    ];
  1412.                     $chartGroupsDataset[] = [
  1413.                         'timesheet' => $this->chartValueGetter( $_chartGroupsDataHoursSpent, false),
  1414.                         'revenue' => $this->chartValueGetter($_chartGroupsDataRevenue),
  1415.                         'expenses' => $this->chartValueGetter($_chartGroupsDataExpense),
  1416.                         'employee_cost' => $this->chartValueGetter($_chartGroupsDataWorkedCost),
  1417.                         'profit' => $this->chartValueGetter($_profit),
  1418.                         // 'owner' => substr($projectOrder->getOrderLead()->getName(), 0 ,1 ) . '. ' . $projectOrder->getOrderLead()->getSurname(),
  1419.                         'owner' => $projectOrder->getOrderLead() ? ( $projectOrder->getOrderLead()->getName() . ' ' . $projectOrder->getOrderLead()->getSurname() ) : "",
  1420.                         'ownerId' => $projectOrder->getOrderLead() && $projectOrder->getOrderLead()->getId(),
  1421.                         // 'locked' => $userScopped && ( $userScopped->isOnlyOwned() && $userScopped->getUser()->getId() !== $projectOrder->getOrderLead()->getUser()->getId())
  1422.                         'isLocked' => $ownedData ? false : $onlyOwned,
  1423.                     ];
  1424.                 }
  1425.             });
  1427.             #dd();
  1429.             // Net Gelir
  1430.             $netRevenue = array_reduce($netRevenues, function($carry, $item){
  1432.                 return $carry + $item;
  1433.             }, 0);
  1435.             // Yapilan Harcama
  1436.             $netExpense = array_reduce($netExpenses, function($carry, $item){
  1437.                 try{
  1438.                     return $carry + $item;
  1439.                 } catch (\Exception $exception){
  1440.                     dump($carry);
  1441.                 }
  1443.             }, 0);
  1445.             // Harcanan Is Gucu Saat
  1446.             $netHourSpent = array_reduce($netHoursSpent, function($carry, $item){
  1447.                 // dd($carry);
  1448.                 return $carry + $item;
  1449.             }, 0);
  1451.             // Harcanan Is Gucu Saat Fiyat
  1452.             $netHourCostSpent = array_reduce($netHoursCostSpent, function($carry, $item){
  1453.                 return $carry + $item;
  1454.             }, 0);
  1456.             // Profit Ortalama
  1457.             $averageProfitMargin = floatval(number_format(array_reduce($profitMargins, function($carry, $item){
  1458.                     return $carry + $item;
  1459.                 }, 0) / count($profitMargins), 2));
  1461.             // Net Kazanc
  1462.             $netProfit = $netRevenue - ( $netExpense + $netHourCostSpent);
  1464.             // Bekelnen Kar orani
  1465.             $idealerProfit = $netRevenue * $averageProfitMargin / 100;
  1467.             // Kazanc'a gore son kar margi
  1468.             $netProfitMargin = $netProfit * $averageProfitMargin / $idealerProfit;
  1471.             #dd($translator->trans('Timesheet'));
  1474.             return $this->json([
  1475.                 'message' => $translator->trans('The financial state of the last project has been calculated successfully'),
  1476.                 'Revenue' => $netRevenue,
  1477.                 'AverageProfitMargin' => $averageProfitMargin,
  1478.                 'Expense' => $netExpense,
  1479.                 'HourSpent' => $netHourSpent,
  1480.                 'HourCostSpent' => $netHourCostSpent,
  1481.                 'IdealerProfit' => $idealerProfit,
  1482.                 'NetProfit' => $netProfit,
  1483.                 'ProfitMargin' => $netProfitMargin,
  1484.                 // Only Name for Chart group
  1485.                 'ChartGroups' => array_map(function(/**@var User $user*/ $user ){
  1486.                     return $user ? substr($user->getName(), 0, 1) . '. ' . $user->getSurname() : "No name";
  1487.                 }, $chartGroups),
  1488.                 'ChartGroupsData' => $chartGroupsData,
  1489.                 'ChartGroupColors' => $chartGroupColors,
  1491.                 'ChartGroupsDataset' => $chartGroupsDataset,
  1492.                 'ChartGroupsDatasetLabels' => [
  1493.                     ["dataKey" => 'timesheet', "label" => $translator->trans('Timesheet')],
  1494.                     ["dataKey" => 'revenue', "label" => $translator->trans('Revenue')],
  1495.                     ["dataKey" => 'expenses', "label" => $translator->trans('Expenses')],
  1496.                     ["dataKey" => 'employee_cost', "label" => $translator->trans('Employee cost')],
  1497.                     ["dataKey" => 'profit', "label" => $translator->trans('Profit')],
  1498.                 ]
  1500.             ], Response::HTTP_OK );
  1502.         } catch (\Exception $exception ){
  1503.             return $this->json([
  1504.                 "message" => $exception->getMessage(),
  1505.                 "severity" => "error"
  1506.              ]);
  1507.         }
  1508.     }
  1511.     /**
  1512.      * @deprecated
  1513.      * info for Stakeholder not more Use fetch direct Project!
  1514.      * @Route("/project-stakeholder-timesheet-pdf-as-project/{project_stakeholder_id}", name="project_stakeholder_timesheet_pdf_as_project", methods={"POST", "GET"})
  1515.      * @param Request $request
  1516.      * @param RgbToHex $rgbToHex
  1517.      * @param EntityManagerInterface $manager
  1518.      * @param TimesheetReaderInterface $timesheetReader
  1519.      * @param ProjectStakeholders|null $projectStakeholder
  1520.      * @param SerializerInterface $serializer
  1521.      * @param PdfOutputTimesheet $pdfOutputTimesheet
  1522.      * @param StatusCodes $codes
  1523.      * @param TranslatorInterface $translator
  1524.      * @param int $project_stakeholder_id
  1525.      * @return Response
  1526.      * @ParamConverter("projectStakeholder", options={"mapping":{"project_stakeholder_id":"id"}})
  1527.      */
  1528.     public function stakeholderTimesheet(Request $request, RgbToHex $rgbToHex, EntityManagerInterface $manager, TimesheetReaderInterface $timesheetReader, ?ProjectStakeholders $projectStakeholder, SerializerInterface $serializer, PdfOutputTimesheet $pdfOutputTimesheet, StatusCodes $codes, TranslatorInterface $translator, int $project_stakeholder_id ): Response
  1529.     {
  1530.         $timesheets = null;
  1531.         $years = $request->request->get('years');
  1532.         $is_guest = $request->request->get('is_guest');
  1534.         $projectJoinedEmployees = $projectStakeholder->getProject()->getStakeholders()->filter(function(/**@var $stakeholder ProjectStakeholders */$stakeholder) use ($is_guest, $projectStakeholder){
  1535. //            if( $is_guest !== "true" ){
  1536. //                return $stakeholder->getId() === $projectStakeholder->getId();
  1537. //            }
  1538.             #dump(count($stakeholder->getWorkerInProjects()));
  1539.             return $stakeholder;
  1540.         })->map(function(/**@var $stakeholder ProjectStakeholders */$stakeholder) use ( $is_guest, $projectStakeholder ){
  1541.             #dump(count($stakeholder->getWorkerInProjects()));
  1542.             return $stakeholder->getWorkerInProjects()->getValues();
  1543.         });
  1545.             #dd();
  1548.         $serializedWorkersInProject = json_decode($serializer->serialize( $projectJoinedEmployees , 'json', [
  1549.             'groups' => [
  1550.                 'timesheet.for.stakeholder'
  1551.             ],
  1552.             AbstractNormalizer::IGNORED_ATTRIBUTES => [
  1553.                 // 'worker_timesheets'
  1554.             ]
  1555.         ]) , true );
  1558.         #dd($serializedWorkersInProject);
  1559.         $serializedWorkersInProject = call_user_func_array('array_merge', $serializedWorkersInProject);
  1561.         #dd($serializedWorkersInProject);
  1563.         /// Filtered For Current Project
  1564.         $collection = new ArrayCollection($serializedWorkersInProject);
  1565.         $accessedYears  = [(new DateTimeImmutable('now'))->format('Y')]; // Initial
  1566.         if( $years ) {
  1567.             $accessedYears  = json_decode($years); // <-- Should as param
  1568.         }
  1569.         // Overwrite for another process
  1570.         $years = [];
  1572.         $timesheetStatus = (new ArrayCollection($manager->getRepository(TimesheetStatus::class)->findAll() ?? []))->map( function(/**@var $item TimesheetStatus*/ $item ) use ($rgbToHex){
  1573.             // Manipulate color to Hex
  1574.             $item->setAbsenceColorHex($rgbToHex->convertWithArray($item->getAbsenceBrColor()));
  1575.             return $item;
  1576.         });
  1577.         // Initial Values
  1578.         $timesheetReader
  1579.             ->setTimesheetStatusCollection($timesheetStatus)
  1580.             // ->setProjectStakeholders( $projectStakeholder );
  1581.             ->readerPathManager( $projectStakeholder->getProject(), null, null );
  1583.         #dd($collection);
  1585.         array_map(function( $accessedYear ) use ( &$years, $is_guest, $collection, $timesheetReader, $timesheetStatus, &$final_times, &$final_costs ){
  1587.             $yearly_times = [];
  1588.             $yearly_costs = [];
  1590.             $final_month_times = [];
  1591.             $final_costs = [];
  1593.             #dd($collection);
  1594.             // Done Empty Workers for current year
  1595.             $workers = [];
  1596.             // Project Stakeholder workers Collection Loop
  1597.             $collection->filter(function($workerActivity) use ($is_guest){
  1598.                 return $workerActivity; // $workerActivity['worker_activity']['guest'] === "1" && $is_guest === "true";
  1599.             })->map(function($workerActivity) use (
  1600.                 &$yearly,
  1601.                 &$workers,
  1602.                 $accessedYear,
  1603.                 $timesheetReader,
  1604.                 $timesheetStatus,
  1605.                 &$yearly_times,
  1606.                 &$yearly_costs,
  1607.                 &$final_month_times,
  1608.                 &$final_costs
  1609.             ){
  1611.                 $_worker = [
  1612.                     "id" => $workerActivity['worker_activity']["id"],
  1613.                     "name" => $workerActivity['worker_activity']['worker']["name"],
  1614.                     "surname" => $workerActivity['worker_activity']['worker']["surname"],
  1615.                     "customer" => $workerActivity['worker_activity']['customer']["company"],
  1616.                     "guest" => $workerActivity['worker_activity']['guest']
  1618.                 ];
  1619.                 // Worker Timesheet Source
  1620.                 $foundedYear = array_filter( $workerActivity['worker_activity']['worker_timesheets'], function( $timesheetForYear ) use ( $accessedYear ){
  1621.                     return $timesheetForYear['year'] === $accessedYear;
  1622.                 });
  1624.                 // Update Worker Element with timesheet
  1625.                 // try{
  1626.                 if( $foundedYear ){
  1628.                     $foundedYear = array_values($foundedYear);
  1629.                     $foundedYear = $foundedYear[0];
  1632.                     $pattern = '/^m\d+_d\d+?$/';
  1633.                     $activeColumns = array_filter( array_keys($foundedYear), function($item) use ($pattern) {
  1634.                         return preg_match($pattern, $item);
  1635.                     });
  1636.                     $activeColumns = array_values($activeColumns);
  1637.                     try{
  1638.                         foreach ($foundedYear as $key => $item ) {
  1639.                             if( !in_array($key, $activeColumns) ){
  1640.                                 unset($foundedYear[$key]);
  1641.                             }
  1642.                         }
  1643.                     }catch (\Exception $exception ){
  1644.                         dd($exception->getMessage());
  1645.                     }
  1647.                     $months = $monthsFinal = [];
  1648.                     // Loop Months
  1649.                     foreach ( range(1, 12) as $monthIndex ) {
  1650.                         #dump($monthIndex);
  1651.                         $timesheetReader->setMonth($monthIndex);
  1652.                         $workerMonthTimeCollection = $workerMonthCostCollection = $workerMonthInactiveTimeCollection = $workerMonthInactiveCostCollection = [];
  1654.                         $pattern = '/m' . $monthIndex . '_d\d/';
  1655.                         // Get days of current month
  1656.                         $activeColumns = array_filter( array_keys($foundedYear), function($item) use ($pattern) {
  1657.                             return preg_match($pattern, $item);
  1658.                         });
  1660.                         #dump($activeColumns);
  1662.                         foreach ( $activeColumns as $dayKey ) {
  1665.                             $timesheetReader->setDayKey($dayKey)->setData($foundedYear[$dayKey]);
  1666.                             // $readData = $timesheetReader->readTimeExtend();
  1667.                             #dump($foundedYear[$dayKey]);
  1668.                             $readData = $timesheetReader->readTimeExtendRolesBasic();
  1672.                             if( array_key_exists($timesheetReader::KEY_TIME_PROP, $readData )){
  1674.                                 if($readData[$timesheetReader::KEY_ABSENCE_SHORT_KEY_PROP] === "P"){
  1675.                                     #dump($readData);
  1676.                                     $workerMonthTimeCollection[] = floatval($readData[$timesheetReader::KEY_TIME_PROP]);
  1677.                                     $workerMonthCostCollection[] = floatval($readData[$timesheetReader::KEY_COST]);
  1678.                                 }
  1680. //                                switch ($readData[$timesheetReader::KEY_COST_TYPE]){
  1681. //                                    case $timesheetReader::KEY_COST_TYPE_ACTIVE:
  1682. //                                        $workerMonthTimeCollection[] = $readData[$timesheetReader::KEY_TIME_PROP];
  1683. //                                        $workerMonthCostCollection[] = $readData[$timesheetReader::KEY_COST];
  1684. //                                        break;
  1685. //                                    case $timesheetReader::KEY_COST_TYPE_INACTIVE:
  1686. //                                        $workerMonthInactiveTimeCollection[] = $readData[$timesheetReader::KEY_TIME_PROP];
  1687. //                                        $workerMonthInactiveCostCollection[] = $readData[$timesheetReader::KEY_COST];
  1688. //                                        break;
  1689. //                                }
  1690.                             }
  1691.                         }
  1694.                         // Employee month
  1695.                         $months[$monthIndex] = [
  1696.                             "times" => array_sum($workerMonthTimeCollection),
  1697.                             "costs" => array_sum($workerMonthCostCollection),
  1698.                         ];
  1699.                         // Inactive Times
  1700.                         $monthsFinal[$monthIndex] = [
  1701.                             "times" => array_sum(array_merge($workerMonthInactiveTimeCollection, $workerMonthTimeCollection)),
  1702.                             "costs" => array_sum(array_merge($workerMonthInactiveCostCollection, $workerMonthInactiveCostCollection)),
  1703.                         ];
  1705.                         // Final month
  1706.                         // $final_month_times[$monthIndex][] =
  1707.                     }
  1709.                     $_worker["months"] = $months;
  1710.                     $_worker["months_final"] = $monthsFinal;
  1711.                     $_worker["yearTimes"] = array_sum(array_map( function ( $month ){
  1712.                         return floatval($month['times']);
  1713.                     }, $months ));
  1714.                     $_worker["yearCosts"] = array_sum(array_map( function ( $month ){
  1715.                         return floatval($month['costs']);
  1716.                     }, $months ));
  1718.                     $yearly_times[] = $_worker["yearTimes"];
  1719.                     $yearly_costs[] = $_worker["yearCosts"];
  1722.                     $workers[] = $_worker;
  1723.                 }
  1725.             });
  1728.             #dump(array_sum($yearly_times));
  1730.             // Append created worker to accessed year
  1731.             $years[$accessedYear]['workers'] = $workers;
  1732.             $years[$accessedYear]['times'] = array_sum($yearly_times);
  1733.             $years[$accessedYear]['costs'] = array_sum($yearly_costs);
  1734.             if($yearly_times > 0 ){
  1735.                 dump($years);
  1736.             }
  1737.         }, $accessedYears );
  1739.        #dd();
  1740.         #dd(array_sum(array_map(function($item){ return $item['times']; }, $years )));
  1742.         #dump($final_times);
  1743.         #dump($final_costs);
  1744.         #dd();
  1745.         #dd($is_guest);
  1746.         # dd($years);
  1747.         try{
  1748.             $output = null;
  1749.             $pdfOutputTimesheet->setPrintedBy( $this->getUser()->getEmail());
  1750.             $output = $pdfOutputTimesheet->stakeholderTimesheet(
  1751.                 $translator->trans('Timesheet') . ' ' . $projectStakeholder->getProject()->getName() . ' ' . $projectStakeholder->getCustomer()->getCompany(),
  1752.                 $projectStakeholder->getCustomer()->getCompany() . ' in ' . $projectStakeholder->getProject()->getName(),
  1753.                 $years,
  1754.                 array_sum(array_map(function($item){ return $item['times']; }, $years )),
  1755.                 array_sum(array_map(function($item){ return $item['costs']; }, $years )),
  1756.                 'F'
  1757.             );
  1759.             if( $output->code !== Response::HTTP_OK ){
  1760.                 return $this->json([
  1761.                     'message' => $output->message,
  1762.                     "severity" => "error"
  1763.                 ], Response::HTTP_CONFLICT );
  1764.             }
  1766.         } catch (\Exception $exception){
  1767.             return $this->json([
  1768.                 'message' => $exception->getMessage(),
  1769.                 "severity" => "error"
  1770.             ], Response::HTTP_CONFLICT );
  1771.         }
  1773.         return $this->json([
  1774.             'message' => $translator->trans('Timesheet created successfully!'),
  1775.             "severity" => "success",
  1776.             'output'=>$output
  1777.         ]);
  1780.     }
  1782.     /**
  1783.      * @Route("/all-timesheets-pdf-as-year-for-customer/{customer_slug}/{year}", name="all_timesheets_pdf_as_year_for_customer", methods={"POST"}, defaults={"year"=null})
  1784.      * @param Request $request
  1785.      * @param TimesheetReaderInterface $timesheetReader
  1786.      * @param SerializerInterface $serializer
  1787.      * @param Customer $customer
  1788.      * @param RgbToHex $rgbToHex
  1789.      * @param PdfOutputTimesheet $pdfOutputTimesheet
  1790.      * @param StatusCodes $codes
  1791.      * @param TranslatorInterface $translator
  1792.      * @param EntityManagerInterface $manager
  1793.      * @param int|null $year
  1794.      * @return Response
  1795.      * @ParamConverter("customer", options={"mapping":{"customer_slug":"slug"}})
  1796.      */
  1797.     public function customerTimesheet(Request $request, TimesheetReaderInterface $timesheetReader, SerializerInterface $serializer, Customer $customer, RgbToHex $rgbToHex, PdfOutputTimesheet $pdfOutputTimesheet, StatusCodes $codes, TranslatorInterface $translator, EntityManagerInterface $manager, ?int $year = null): Response
  1798.     {
  1800.         $timesheets = null;
  1801.         $years = $request->request->get('years');
  1802.         $is_guest = $request->request->get('is_guest');
  1803.         $timesheetStatus = (new ArrayCollection($manager->getRepository(TimesheetStatus::class)->findAll() ?? []))->map( function(/**@var $item TimesheetStatus*/ $item ) use ($rgbToHex){
  1804.             // Manipulate color to Hex
  1805.             $item->setAbsenceColorHex($rgbToHex->convertWithArray($item->getAbsenceBrColor()));
  1806.             return $item;
  1807.         });
  1809.         $accessedYears  = [(new DateTimeImmutable('now'))->format('Y')]; // Initial
  1810.         if( $years ) {
  1811.             $accessedYears  = json_decode($years); // <-- Should as param
  1812.         }
  1813.         // Overwrite for another process
  1814.         $years = [];
  1816.         $timesheetReader
  1817.             ->setTimesheetStatusCollection($timesheetStatus);
  1819.         try{
  1820.             array_map(function( $accessedYear ) use ( &$finalCost, &$years, $timesheetReader, $customer, $is_guest, $serializer ){
  1822.                 // Done Empty Workers for current year
  1823.                 // Project Stakeholder workers Collection Loop
  1825.                 $stakeholders = [];
  1826.                 // Visit every Customer Project
  1827.                 $customer->getProjectStakeholders()->map(function(/**@var $projectStakeholder ProjectStakeholders*/$projectStakeholder) use ($is_guest, &$years, &$finalCost, &$yearly, &$workers, &$stakeholders, $timesheetReader, $accessedYear, $serializer) {
  1829.                     // initial
  1830.                     $stakeholder["id"] = $projectStakeholder->getId();
  1831.                     $stakeholder["projectName"] = $projectStakeholder->getProject()->getName();
  1832.                     $stakeholder["year"] = $accessedYear;
  1833.                     $stakeholder['months'] = [];
  1834.                     $timesheetReader->readerPathManager( $projectStakeholder->getProject(), null, null );
  1836.                     $workers = [];
  1838.                     $projectJoinedEmployees = $projectStakeholder->getProject()->getStakeholders()->filter(function(/**@var $stakeholder ProjectStakeholders */$stakeholder) use ($is_guest, $projectStakeholder){
  1839.                         if( $is_guest !== "true" ){
  1840.                             return $stakeholder->getId() === $projectStakeholder->getId();
  1841.                         }
  1842.                         return $stakeholder;
  1843.                     })->map(function(/**@var $stakeholder ProjectStakeholders */$stakeholder) use ( $is_guest, $projectStakeholder ){
  1844.                         return $stakeholder->getWorkerInProjects()->getValues();
  1845.                     });
  1847.                     $serializedWorkersInProject = json_decode($serializer->serialize( $projectJoinedEmployees , 'json', [
  1848.                         'groups' => [
  1849.                             'timesheet.for.stakeholder'
  1850.                         ],
  1851.                         AbstractNormalizer::IGNORED_ATTRIBUTES => [
  1852.                             // 'worker_timesheets'
  1853.                         ]
  1854.                     ]) , true );
  1856.                     $serializedWorkersInProject = call_user_func_array('array_merge', $serializedWorkersInProject);
  1858.                     // $stakeholders[]["id"] = $projectStakeholder->getId();
  1859.                     // $stakeholders[]["projectName"] = $projectStakeholder->getProject()->getName();
  1860.                     // $stakeholders[]["year"] = $accessedYear;
  1862.                     array_map( function($workerInProject) use ( $projectStakeholder, &$finalCost, &$stakeholder, $timesheetReader, $accessedYear ){
  1864.                         $workerActivity = $workerInProject['worker_activity'];
  1865.                         // Worker Timesheet Source
  1866.                         $foundedYear = array_filter( $workerActivity['worker_timesheets'], function( $timesheetForYear ) use ( $accessedYear ){
  1867.                             return $timesheetForYear['year'] === intval($accessedYear);
  1868.                         });
  1869.                         // Update Worker Element with timesheet
  1870.                         if( $foundedYear ){
  1872.                             #dump($foundedYear);
  1873.                             $foundedYear = array_values($foundedYear);
  1874.                             $foundedYear = $foundedYear[0];
  1876.                             $pattern = '/^m\d+_d\d+?$/';
  1877.                             $activeColumns = array_filter( array_keys($foundedYear), function($item) use ($pattern) {
  1878.                                 return preg_match($pattern, $item);
  1879.                             });
  1881.                             $activeColumns = array_values($activeColumns);
  1882.                             foreach ($foundedYear as $key => $item ) {
  1883.                                 if( !in_array($key, $activeColumns) ){
  1884.                                     unset($foundedYear[$key]);
  1885.                                 }
  1886.                             }
  1888.                             // unset($foundedYear['year']);
  1889.                             foreach ( range(1, 12) as $monthIndex ) {
  1890.                                 $timesheetReader->setMonth($monthIndex);
  1891.                                 $workerMonthTimeCollection = $workerMonthCostCollection = [];
  1893.                                 $pattern = '/m' . $monthIndex . '_d\d/';
  1894.                                 // Get days of current month
  1895.                                 $activeColumns = array_filter( array_keys($foundedYear), function($item) use ($pattern) {
  1896.                                     return preg_match($pattern, $item);
  1897.                                 });
  1899.                                 foreach ( $activeColumns as $dayKey ) {
  1900.                                     $timesheetReader->setDayKey($dayKey)->setData($foundedYear[$dayKey]);
  1901.                                     // $readData = $timesheetReader->readTimeExtend();
  1902.                                     $readData = $timesheetReader->readTimeExtendRolesBasic();
  1905.                                     if( array_key_exists($timesheetReader::KEY_TIME_PROP, $readData )){
  1906.                                         switch ($readData[$timesheetReader::KEY_COST_TYPE]) {
  1907.                                             case $timesheetReader::KEY_COST_TYPE_ACTIVE:
  1908.                                                 $workerMonthTimeCollection[] = $readData[$timesheetReader::KEY_TIME_PROP];
  1909.                                                 $workerMonthCostCollection[] = $readData[$timesheetReader::KEY_COST];
  1910.                                                 break;
  1911.                                             case $timesheetReader::KEY_COST_TYPE_INACTIVE:
  1912.                                                 // $workerMonthInactiveTimeCollection[] = $readData[$timesheetReader::KEY_TIME_PROP];
  1913.                                                 // $workerMonthInactiveCostCollection[] = $readData[$timesheetReader::KEY_COST];
  1914.                                                 break;
  1915.                                         }
  1917.                                         // $workerMonthTimeCollection[] = $readData[$timesheetReader::KEY_TIME_PROP];
  1918.                                         // $workerMonthCostCollection[] = $readData[$timesheetReader::KEY_COST];
  1919.                                     }
  1920.                                 }
  1922.                                 $stakeholder['months'][$monthIndex][] = [
  1923.                                     "times" => array_sum($workerMonthTimeCollection),
  1924.                                     "costs" => array_sum($workerMonthCostCollection),
  1925.                                 ];
  1926.                             }
  1927.                         }
  1928.                     }, $serializedWorkersInProject );
  1930.                     /**
  1931.                      * $stakeholder['months'] has multiple times Worker defined
  1932.                      * For example month 11 Has 3 worker defined each of worker Has For Project and Month
  1933.                      * 2 Values times and Cost Should they values collected
  1934.                      * On Bottom Doing this operation
  1935.                      */
  1936.                     foreach ($stakeholder['months'] as $monthIndex => $monthEntries ) {
  1937.                         $monthTimesSimplify = []; // Stakeholder Months has multiple Month times (Worker Entry) do it simplify
  1938.                         $monthCostsSimplify = []; // Stakeholder Months has multiple Month Costs (Worker Entry) do it simplify
  1939.                         foreach ($monthEntries as $monthEntry) {
  1940.                             $monthTimesSimplify[] = $monthEntry['times'];
  1941.                             $monthCostsSimplify[] = $monthEntry['costs'];
  1942.                         }
  1943.                         $stakeholder['months'][$monthIndex] = [
  1944.                             'times' => array_sum($monthTimesSimplify),
  1945.                             'costs' => array_sum($monthCostsSimplify)
  1946.                         ];
  1947.                     }
  1949.                     /**
  1950.                      * For Project Months values have been simplified
  1951.                      * Now Collect All simplified Times And costs from Entry
  1952.                      */
  1953.                     $projectForYearFinalTimesCollection = [];
  1954.                     $projectForYearFinalCostsCollection = [];
  1955.                     foreach ($stakeholder['months'] as $monthIndex => $simplifiedMonth ) {
  1956.                         $projectForYearFinalTimesCollection[] = floatval( $simplifiedMonth['times'] );
  1957.                         $projectForYearFinalCostsCollection[] = floatval( $simplifiedMonth['costs'] );
  1958.                     }
  1959.                     $stakeholder['yearTimes'] = array_sum($projectForYearFinalTimesCollection);
  1960.                     $stakeholder["yearCosts"] = array_sum($projectForYearFinalCostsCollection);
  1962.                     $stakeholders[] = $stakeholder;
  1964.                 });
  1966.                 $years[$accessedYear] = $stakeholders;
  1969.             }, $accessedYears );
  1971.         } catch (\Exception $exception ){
  1972.             return $this->json([
  1973.                 'message' => $exception->getMessage(),
  1974.                 "severity" => "error"
  1975.             ], Response::HTTP_CONFLICT );
  1976.         }
  1978.         #dd();
  1979.         #dd($years);
  1981.         try{
  1982.             if( !is_null($finalCost)){
  1983.                 foreach ($finalCost as $_year => $yearValue ) {
  1984.                     $finalCost[$_year] = array_sum($yearValue);
  1985.                 }
  1986.             }
  1987.         } catch (\Exception $exception ){
  1988.             return $this->json([
  1989.                 'message' => $exception->getMessage(),
  1990.                 "severity" => "success"
  1991.             ], Response::HTTP_NOT_FOUND );
  1993.         }
  1995.         $output = null;
  1996.         $pdfOutputTimesheet->setPrintedBy( $this->getUser()->getEmail());
  1997.         $output = $pdfOutputTimesheet->customerTimesheet(
  1998.             $translator->trans('Timesheet') . ' ' . $customer->getCompany(),
  1999.             $translator->trans('Timesheet Plan by Years of') . ' ' . $customer->getCompany(),
  2000.             $years,
  2001.             $finalCost,
  2002.             'F'
  2003.         );
  2005.         return $this->json([
  2006.             'message' => $translator->trans('Timesheet created successfully!'),
  2007.             "severity" => "success",
  2008.             'output'=>$output
  2009.         ]);
  2010.     }
  2013.     /**
  2014.      * Relocate project toArchive | toTrash
  2015.      * @Route("/re-classify/{classify}/{project_id}", name="app_api_project_toarchive", methods={"POST"}, options={"project_id": null})
  2016.      * @ParamConverter("project", options={"mapping": {"project_id": "id"}})
  2017.     */
  2018.     public function reClassify ( ?Projects $project, EntityManagerInterface $manager, Request $request, SerializerInterface  $serializer, TranslatorInterface $translator, string $classify = "all", int $project_id = null): Response {
  2020.         $processedProjectIds = $request->request->get('projects') ?? [];
  2022.         /**@var $user User*/
  2023.         $user = $this->getUser();
  2027.         #dd($project_id);
  2028.         if(!$project_id && !count($processedProjectIds)){
  2029.             return $this->json([
  2030.                 "message" => $translator->trans("Project not defined"),
  2031.                 "severity" => "warning"
  2032.             ]);
  2033.         }
  2036.         if(!$project && !count($processedProjectIds)){
  2037.             return $this->json([
  2038.                 "message" => $translator->trans("Project not found"),
  2039.                 "severity" => "error"
  2040.             ]);
  2041.         }
  2043.         $projectIds = [];
  2044.         if(count($processedProjectIds)){
  2045.             $projectIds = $processedProjectIds;
  2046.         } else {
  2047.             $projectIds[] = $project->getId();
  2048.         }
  2050.         try {
  2052.             $projects = [];
  2053.             if(count($processedProjectIds)){
  2054.                 $projects = $manager->getRepository(Projects::class)->findBy(["id" => $processedProjectIds]);
  2056.             } else {
  2057.                 $projects[] = $project;
  2058.             }
  2060.             // dd($projects);
  2062.             (new ArrayCollection($projects))->map(function(/**@var Projects $project*/ $project) use ($classify, $manager) {
  2064.                 switch ($classify){
  2065.                     case "archive":
  2066.                         $project->setIsArchived(true);
  2067.                         break;
  2068.                     case "unarchive":
  2069.                         $project->setIsArchived(null);
  2070.                         break;
  2071.                     case "trash":
  2072.                         $project->setIsRecycle(true);
  2073.                         break;
  2074.                     case "untrash":
  2075.                         $project->setIsRecycle(null);
  2076.                         break;
  2077.                 }
  2079.                 $manager->persist($project);
  2080.                 $manager->flush();
  2081.                 dump($project->getId(), $classify, $project->isRecycle(), $project->isArchived());
  2083.             });
  2085.             #dd();
  2087.         } catch (\Exception $exception) {
  2088.             return $this->json([
  2089.                 "message"=> $exception->getMessage(),
  2090.                 "severity" => "error"
  2091.             ], $exception->getCode() );
  2092.         }
  2094. //        $archived = [];
  2095. //        $trashed  = [];
  2096. //        $active = [];
  2097. //        $projects = new ArrayCollection($manager->getRepository(Projects::class)->findAll());
  2098. //        $projects->map( function( /**@var Projects $project */$project) use(&$archived, &$trashed, &$active){
  2099. //            if( !$project->isRecycle()){
  2100. //                if($project->isArchived()){
  2101. //                    $archived[] = $project;
  2102. //                } else {
  2103. //                    $active[] = $project;
  2104. //                }
  2105. //            } else {
  2106. //                $trashed[] = $project;
  2107. //            }
  2108. //        });
  2110.         dd('reClassify_12');
  2112.         return $this->json([
  2113.             "message"=> "Successfully",
  2114.             "severity" => "success",
  2115.             "projectIds" => $projectIds,
  2116. //            "disposed" => [
  2117. //                "archived" => $this->serializeProjects($archived, $serializer),
  2118. //                "trashed" => $this->serializeProjects($trashed, $serializer),
  2119. //                "active" => $this->serializeProjects($active, $serializer)
  2120. //            ]
  2121.             "disposed" => $this->getUserAccessedProjects( $user, $manager, $serializer )
  2122.         ], Response::HTTP_OK);
  2124.     }
  2127.     /**
  2128.      * @Route("/payment-report/{project_id}", name="app_api_project_payment_report", methods={"POST"}, options={"project_id": null})
  2129.      * @ParamConverter("project", options={"mapping": {"project_id": "id"}})
  2130.      * @throws \Exception
  2131.      */
  2133.     public function paymentReport(?Projects $project, PdfOutputProjectPaymentReport $pdfOutputProjectPaymentReport, TranslatorInterface $translator ): Response {
  2135.         if(!$project){
  2136.             return $this->json([
  2137.                 "message" => "Project not found",
  2138.                 "severity" => "error"
  2139.             ], Response::HTTP_NOT_FOUND);
  2140.         }
  2142.         $collected = [];
  2143.         $totalInvoice = [];
  2144.         $totalPaidInvoice = [];
  2146.         $dataColumnNames = [
  2147.             $translator->trans('Order number'),
  2148.             $translator->trans('Position-ID'),
  2149.             $translator->trans('Price'),
  2150.             $translator->trans('Sent at'),
  2151.             $translator->trans('Completed!'),
  2152.             $translator->trans('Elapsed days'),
  2153.             $translator->trans('Voucher'),
  2154.             $project->getOwner()->getCompany() . " " . $translator->trans('Order number'),
  2155.             $project->getOwner()->getCompany() . " " . $translator->trans('CP'),
  2156.             $project->getOwner()->getCompany() . " " . $translator->trans('Telephone'),
  2157.         ];
  2159.         $dataColumnWidths = [
  2160.             70, 50, 70,70,70,70,80,100,80,122
  2161.         ];
  2164.         $project->getProjectOrders()->map( function(/**@var $projectOrder ProjectOrders*/ $projectOrder) use (&$collected, &$totalInvoice, &$totalPaidInvoice ){
  2165.             // $collected[] = $projectOrder->getInvoiceType() ? $projectOrder->getInvoiceType()->getName(): "No invouce type for " . $projectOrder->getOrderNr();
  2167.             if($projectOrder->getInvoiceType()){
  2169.                 if( $projectOrder->getInvoiceType()->getName() === "Voucher" ){
  2170.                     $projectOrder->getProjectOrderUndertakings()->map(function(/**@var $orderUndertaking ProjectOrderUndertakings*/ $orderUndertaking) use (&$collected, &$totalInvoice, &$totalPaidInvoice ){
  2172.                         // if( is_null($orderUndertaking->getCompletedAt()) ){
  2173.                         if( is_null($orderUndertaking->getVoucher()) ){
  2175.                             $completed_at = null;
  2177. //                            $waiting_day = $orderUndertaking->getSentAt()->diff(new DateTimeImmutable('now'))->days;
  2178. //                            if( $orderUndertaking->getVoucher()){
  2179. //                                if( $orderUndertaking->getVoucher()->getCompletedAt() ){
  2180. //                                    $completed_at = $orderUndertaking->getVoucher()->getCompletedAt();
  2181. //                                    $waiting_day = $orderUndertaking->getSentAt()->diff($completed_at)->days;
  2182. //                                    $totalPaidInvoice[] = floatval($orderUndertaking->getPrice());
  2183. //                                }
  2184. //                            }
  2185.                             // $waiting_day = $orderUndertaking->getSentAt()->diff()->days;
  2186.                             $waiting_day = (new DateTimeImmutable('now'))->diff( $orderUndertaking->getSentAt())->days;
  2188.                             // $remaining = 60 - $waiting_day;
  2189.                             $remaining = $waiting_day;
  2191.                             $color = "transparent";
  2192.                             $txtColor = "black";
  2194.                             if ($remaining <= 10) {
  2195.                                 // 50'den büyükse
  2196.                                 $color = "#5cffa1";
  2198.                             } elseif ($remaining <= 30) {
  2199.                                 $color = "#ffd800";
  2200.                                 // 21-50 arası
  2201.                             } elseif ($remaining < 50) {
  2202.                                 // 1-20 arası
  2203.                                 $color = "#ff6a00";
  2204.                             } else {
  2205.                                 // 0 veya daha az
  2206.                                 $color = "red";
  2207.                                 $txtColor = "white";
  2208.                             }
  2209.                             if($completed_at){
  2210.                                 $txtColor = "white";
  2211.                                 $color = "green";
  2212.                             }
  2218.                             $data = [
  2219.                                 "order_nr" => $orderUndertaking->getProjectOrder()->getOrderNr(),
  2220.                                 "price" => $orderUndertaking->getPrice(),
  2221.                                 "position_nr" => $orderUndertaking->getPositionNr(),
  2222.                                 "sent_at" => $orderUndertaking->getSentAt(),
  2223.                                 "completed_at" => $completed_at,
  2224.                                 // wait for day 60
  2225.                                 // "remaining_day" => 60 - $waiting_day,
  2226.                                 "remaining_day" => $waiting_day,
  2227.                                 "color" => $color,
  2228.                                 "txtColor" => $txtColor,
  2229.                                 "voucher_nr" => $orderUndertaking->getVoucher() ? $orderUndertaking->getVoucher()->getVoucherNr() : "",
  2230.                                 // Isi verene ait siparis numarasi
  2231.                                 "order_owner_order_nr" => $orderUndertaking->getProjectOrder()->getProjectOwnerOrderNr(),
  2232.                                 "order_owner_contact" => [
  2233.                                     "name" => $orderUndertaking->getProjectOrder()->getContactPerson()->getName(),
  2234.                                     "surname" => $orderUndertaking->getProjectOrder()->getContactPerson()->getSurname(),
  2235.                                     "tel" => $orderUndertaking->getProjectOrder()->getContactPerson()->getTel(),
  2236.                                 ]
  2238.                             ];
  2240.                             $totalInvoice[] = floatval($orderUndertaking->getPrice());
  2243.                             $collected[] = $data;
  2245.                         }
  2246.                     });
  2247.                 }
  2248.             }
  2250.         });
  2252.         $missingPayment = array_sum($totalInvoice) - array_sum($totalPaidInvoice);
  2254.         $output = null;
  2255.         $pdfOutputProjectPaymentReport->setPrintedBy( $this->getUser()->getEmail());
  2256.         $output = $pdfOutputProjectPaymentReport->report(
  2257.             $project->getName(),
  2258.             $translator->trans('Payment status'),
  2259.             $project->getProjectId(),
  2260.             $collected,
  2261.             $dataColumnNames,
  2262.             $dataColumnWidths,
  2263.             [
  2264.                 "total" => array_sum($totalInvoice),
  2265.                 "paid" => array_sum($totalPaidInvoice),
  2266.                 "missing" => $missingPayment,
  2267.             ],
  2268.             'F'
  2269.         );
  2273.         return $this->json([
  2274.             "message" => "Successfully",
  2275.             "severity" => "success",
  2276.             "data" => $collected,
  2277.             "output" => $output,
  2278.             "dataColumnNames" => $dataColumnNames
  2279.         ], Response::HTTP_OK );
  2281.     }
  2287.     // ⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆⬆
  2307.     /**
  2308.      * @Route("/all-timesheets-pdf-as-year/{year}", name="all_timesheets_pdf_as_year", methods={"POST"}, defaults={"year"=null})
  2309.      * @param PdfOutputTimesheet $pdfOutputTimesheet
  2310.      * @param StatusCodes $codes
  2311.      * @param TranslatorInterface $translator
  2312.      * @param EntityManagerInterface $manager
  2313.      * @param int|null $year
  2314.      * @return Response
  2315.      */
  2316.     public function allTimesheetPDFAsYear( PdfOutputTimesheet $pdfOutputTimesheet, StatusCodes $codes, TranslatorInterface $translator, EntityManagerInterface $manager, ?int $year = null): Response
  2317.     {
  2319.         $timesheets = null;
  2320.         if (!is_null($year)) {
  2321.             $timesheets = $manager->getRepository(WorkerTimesheet::class)->findBy(["year" => $year]);
  2322.         }
  2324.         $parsedData = null;
  2325.         if ($timesheets) {
  2326.             $parsedData = (new ArrayCollection($timesheets))->map(function (/**@var $workerTimesheet WorkerTimesheet */ $workerTimesheet) {
  2327.                 return [
  2328.                     "name" => substr($workerTimesheet->getWorker()->getName(), 0,1) . ". " . $workerTimesheet->getWorker()->getSurname() . ' by ' . $workerTimesheet->getWorker()->getWorkerActuallyActivity()->getCustomer()->getCompany(),
  2329.                     "timesheetMonths" => $workerTimesheet->getWorkerTimeInPlaceMonths()
  2330.                 ];
  2331.             });
  2332.         }
  2336.         // $this->workerTimeSheetDir . DIRECTORY_SEPARATOR . $filename . '.pdf'
  2337.         # return $this->json($pdfOutputTimesheet->resultForYear('Suleyman Topaloglu', $year, $parsedData, 'D' ));
  2338.         $output = null;
  2339.         try{
  2340.             $pdfOutputTimesheet->setPrintedBy( $this->getUser()->getEmail());
  2341.             $output = $pdfOutputTimesheet->resultForYear(
  2342.                 'Romon GmbH for ' . $year,
  2343.                 $year,
  2344.                 $parsedData,
  2345.                 'F'
  2346.             );
  2347.         } catch (\Exception $exception){
  2348.             $codes->set( 401 );
  2349.             return $this->json([
  2350.                 'message' => $exception->getMessage(),
  2351.                 "severity" => "error"
  2352.             ]);
  2353.         }
  2355.         return $this->json([
  2356.             'message' => $translator->trans('Timesheet created successfully!'),
  2357.             "severity" => "success",
  2358.             "output" => $output
  2359.         ]);
  2361.     }
  2365.     /**
  2366.      * @Route("/add-project-addendum-cost/{project_id}", name="add_project_addendum_cost", methods={"POST"}, defaults={"project_id": null})
  2367.      * @param Projects|null $project
  2368.      * @param StatusCodes $codes
  2369.      * @param AisDate $aisDate
  2370.      * @param TranslatorInterface $translator
  2371.      * @param EntityManagerInterface $manager
  2372.      * @param Request $request
  2373.      * @param int $project_id
  2374.      * @return Response
  2375.      * @throws \Exception
  2376.      * @ParamConverter("project", options={"mapping":{"project_id":"id"}})
  2377.      */
  2378.     public function addProjectAddendumCost( ?Projects $project, StatusCodes $codes, AisDate $aisDate, TranslatorInterface $translator, EntityManagerInterface $manager, Request $request, int $project_id ): Response
  2379.     {
  2381.         if( !$project ){
  2382.             $codes->set(404);
  2383.             return $this->json([
  2384.                 'message' => $translator->trans('Project not found!'),
  2385.                 "severity" => "error",
  2386.                 "variant"=>"snackbar"
  2387.             ]);
  2388.         }
  2390.         $params = $request->request;
  2392.         $costObj = new ProjectAddendumCosts();
  2393.         $costObj
  2394.             ->setAmount($params->get('amount'))
  2395.             ->setAddedAt(new \DateTimeImmutable($params->get('added_at')))
  2396.             ->setAddedBy($this->getUser())
  2397.             // ->setProject($project)
  2398.         ;
  2400.         $project->addProjectAddendumCost($costObj);
  2402.         try{
  2403.             // $manager->persist( $costObj );
  2404.             $manager->persist( $project );
  2405.             $manager->flush();
  2406.             $manager->refresh( $project );
  2407.         } catch (\Exception $exception){
  2408.             $codes->set( 401 );
  2409.             return $this->json([
  2410.                 'message' => $exception->getMessage(),
  2411.                 "severity" => "error"
  2412.             ]);
  2413.         }
  2415.         return $this->json([
  2416.             'message' => $translator->trans('Addendum Cost added successfully!'),
  2417.             "severity" => "success",
  2418.             "totalCost" => $project->getTotalCost(),
  2419.             'addedCost'=>[
  2420.                 'id' => $costObj->getId(),
  2421.                 'project' => $project->getId(),
  2422.                 'addedAt' => $costObj->getAddedAt(),
  2423.                 'addedBy' => [
  2424.                     "id" => $costObj->getAddedBy()->getId(),
  2425.                     "username" => $costObj->getAddedBy()->getEmail(),
  2426.                 ],
  2427.                 'amount' => $costObj->getAmount(),
  2428.             ]
  2429.         ], Response::HTTP_OK, [], [
  2430.             AbstractNormalizer::IGNORED_ATTRIBUTES => [
  2432.             ]
  2433.         ]);
  2436.     }
  2439.     // Upload excel
  2441.     /**
  2442.      * @Route("/upload-cost-list/{project_id}", name="upload_cost_list", defaults={"project_id": null })
  2443.      * @param Projects $project
  2444.      * @param $uploadedFilesDir
  2445.      * @param TranslatorInterface $translator
  2446.      * @param EntityManagerInterface $manager
  2447.      * @param StatusCodes $codes
  2448.      * @param Request $request
  2449.      * @return Response
  2450.      */
  2451.     function uploadCostList( Projects $project, $uploadedFilesDir, TranslatorInterface $translator, EntityManagerInterface $manager, StatusCodes $codes, Request $request ): Response{
  2453.         if(!$project){
  2454.             return $this->json([
  2455.                 "message" => $translator->trans('Project not found'),
  2456.                 "severity" => "warning"
  2457.             ], Response::HTTP_NOT_FOUND );
  2458.         }
  2462.         $file = $request->files->get('costs_file');
  2464.         if( !$file ){
  2465.             $codes->set(Response::HTTP_NOT_FOUND);
  2466.             return $this->json([
  2467.                 'code'=>404,
  2468.                 "message"=>$translator->trans('File not loaded'),
  2469.             ]);
  2470.         }
  2473.         #dd($file);
  2474.         $filePathName = md5(uniqid()) . $file->getClientOriginalName();
  2475.         // apply md5 function to generate an unique identifier for the file and concat it with the file extension
  2476.         try {
  2477.             $file->move( $uploadedFilesDir, $filePathName );
  2479.             $spreadsheet = IOFactory::load( $uploadedFilesDir . DIRECTORY_SEPARATOR . $filePathName );
  2480.             $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, false );
  2482.             // Delete file again!
  2483.             // unlink($uploadedFilesDir . DIRECTORY_SEPARATOR . $filePathName );
  2484.             // Check through is Correct file
  2485.             $header = array_shift($sheetData); // $sheetData[0];
  2487.             $source = [
  2488.                 "Status", "Int. Beleg-Nr." ,"Rechnungs-Nr." ,"Eingangsdatum" ,"Zahlungsstatus" ,
  2489.                 "Firmenname" ,"Zahlart" ,"Projekt" ,"Fällig am" ,"Bruttobetrag" ,"Offener Betrag" ,
  2490.                 "Projekt-Nr." ,"Kategorie" ,"Offene Überweisungen" ,"Zahlungsausgang"
  2491.             ];
  2493.             if( count(array_diff($source, $header))){
  2494.                 return $this->json([
  2495.                     "message" => $translator->trans('Invalid file, file columns title does\'t compare with nested column title, please check your file, '),
  2496.                     "severity" => "info"
  2497.                 ], Response::HTTP_UNAUTHORIZED );
  2498.             }
  2500.             $index_of_invoice_nr = array_search("Int. Beleg-Nr.", $source);
  2501.             $index_of_project_id = array_search("Projekt-Nr.", $source);
  2502.             $transfer_for = $request->request->get('transfer_for');
  2504.             // Filter already in found
  2505. //            $alreadyAdded = $project->getProjectExpenses()->map(function(/**@var $projectExpense ProjectExpense */ $projectExpense ) {
  2506. //                return $projectExpense->getReceiptNr();
  2507. //            })->toArray();
  2508.             $alreadyAdded = (new ArrayCollection($manager->getRepository(ProjectExpense::class)->findAll()))->map(function(/**@var $projectExpense ProjectExpense */ $projectExpense ) {
  2509.                 return $projectExpense->getReceiptNr();
  2510.             })->toArray();
  2514.             #dd($alreadyAdded);
  2516.             $addables = array_values(array_filter( $sheetData, function($item) use ( $index_of_invoice_nr, $index_of_project_id, $alreadyAdded, $transfer_for  ){
  2517.                 #dd($item[$index_of_invoice_nr]);
  2518.                 return $transfer_for === "all" ?
  2519.                     !in_array($item[$index_of_invoice_nr], $alreadyAdded ) :
  2520.                     !in_array($item[$index_of_invoice_nr], $alreadyAdded ) && $item[$index_of_project_id] === $transfer_for ;
  2521.             },ARRAY_FILTER_USE_BOTH ));
  2523.             #dd($addables);
  2525.             // Default chosen_ones all
  2526.             $chosen_ones = array_map(function($item) use ( $index_of_invoice_nr ) {
  2527.                 return $item[$index_of_invoice_nr];
  2528.             }, $addables);
  2529.             #dd($chosen_ones);
  2531. //            $addables = array_values(array_filter( $sheetData, function($item) use ( $index_of_invoice_nr, $alreadyAdded  ){
  2532. //                return !in_array($item[$index_of_invoice_nr], $alreadyAdded );
  2533. //            },ARRAY_FILTER_USE_BOTH ));
  2535.             #dd(array_values($addables));
  2537.         } catch (FileException $e) {
  2538.             return $this->json([
  2539.                 'code'=>$e->getCode(),
  2540.                 "message"=>$e->getMessage(),
  2541.             ]);
  2542.         }
  2544.         return $this->json([
  2545.             "code" => Response::HTTP_OK,
  2546.             "header" => $header,
  2547.             "collection" => $addables,
  2548.             "chosenOnes" => $chosen_ones,
  2549.             "message"=>$translator->trans('Uploaded successfully'),
  2550.             "fileName" => $filePathName
  2551.             ], Response::HTTP_OK, [], [
  2552.                 AbstractNormalizer::IGNORED_ATTRIBUTES => [
  2554.                 ]
  2555.             ]
  2556.         );
  2557.     }
  2559.     /**
  2560.      * @Route("/upload-cost-list-transfer/{project_id}", name="upload_cost_list_transfer", defaults={"project_id": null })
  2561.      * @param Projects $project
  2562.      * @param $uploadedFilesDir
  2563.      * @param EntityManagerInterface $manager
  2564.      * @param TranslatorInterface $translator
  2565.      * @param Request $request
  2566.      * @return Response
  2567.      * @throws \Exception
  2568.      */
  2569.     function uploadCostListTransfer( Projects $project, $uploadedFilesDir, EntityManagerInterface $manager,  TranslatorInterface $translator, Request $request ): Response
  2570.     {
  2572.         if (!$project) {
  2573.             return $this->json([
  2574.                 "message" => $translator->trans('Project not found'),
  2575.                 "severity" => "warning"
  2576.             ], Response::HTTP_NOT_FOUND);
  2577.         }
  2579.         $chosen_ones = !empty($request->request->get('chosen_ones')) ? preg_split("/\,/",  $request->request->get('chosen_ones') ) : [];
  2580.         $file_name = $request->request->get('file_name');
  2582.         $spreadsheet = IOFactory::load( $uploadedFilesDir . DIRECTORY_SEPARATOR . $file_name );
  2583.         $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, false );
  2585.         // Delete file again!
  2586.         // unlink($uploadedFilesDir . DIRECTORY_SEPARATOR . $filePathName );
  2587.         $prepared = array_map( function( $selected ) use( $sheetData ){
  2588.             $d = array_filter($sheetData, function($data) use ($selected){
  2589.                 return array_search($selected, $data);
  2590.             });
  2591.             return array_shift($d);
  2592.         }, $chosen_ones );
  2594.         if( !count($prepared) ){
  2595.             return $this->json([
  2596.                 "message" => $translator->trans('Please select at last one transfer item'),
  2597.                 "severity" => "warning"
  2598.             ], Response::HTTP_UNAUTHORIZED);
  2599.         }
  2601.         #dd($request->request->all());
  2603.         foreach ( $prepared as $item ) {
  2605.             if( !empty($item[11] ) && $request->request->get('transfer_for') === "all" ){
  2606.                 $project = $manager->getRepository(Projects::class)->findOneBy(["project_id"=>$item[11]]);
  2607.                 #dd($project);
  2608.             }
  2609.             if( $project ){
  2610.                 $project_expense = new ProjectExpense();
  2611.                 $project_expense
  2612.                     ->setStatus($item[0])
  2613.                     ->setReceiptNr($item[1])
  2614.                     ->setInvoiceNr($item[2])
  2615.                     ->setReceiptAt(new \DateTimeImmutable($item[3]))
  2616.                     ->setPaymentStatus($item[4])
  2617.                     ->setCompanyName($item[5])
  2618.                     ->setPaymentMethod($item[6])
  2619.                     ->setProject($project)
  2620.                     ->setDueAt(new \DateTimeImmutable($item[8]))
  2621.                     // ->setTotalAmount( money_format('%i', preg_replace("/\,/", "", $item[9] )))
  2622.                     ->setTotalAmount( floatval(preg_replace("/,/", null, $item[9] ) ) )
  2623.                     // ->setOutstandingBalance( money_format('%i', preg_replace("/\,/", "", $item[10] )) )
  2624.                     ->setOutstandingBalance( floatval(preg_replace("/,/", null, $item[10] ) ) )
  2625.                     ->setCategory($item[12])
  2626.                     ->setOpenTransfer($item[13])
  2627.                     ->setPaidAt(new \DateTimeImmutable($item[14]));
  2628.                 $manager->persist($project_expense);
  2630.                 $project = null;
  2631.             }
  2634.         }
  2636.         try{
  2637.             $manager->flush();
  2638.         } catch (\Exception $exception){
  2639.             return $this->json([
  2640.                 "message" => $exception->getMessage(),
  2641.                 "severity" => "warning"
  2642.             ], Response::HTTP_NOT_FOUND);
  2643.         }
  2645.         return $this->json([
  2646.             "message" => $translator->trans('Transfer successfully'),
  2647.             "severity" => "warning"
  2648.         ], Response::HTTP_OK);
  2650.     }
  2654.     // Read excel
  2656.     /**
  2657.      * @Route("/read-uploaded-cost-list", name="read_uploaded_cost_list")
  2658.      * @param $uploadedFilesDir
  2659.      * @param Request $request
  2660.      * @return Response
  2661.      */
  2662.     function readUploadedCostList( $uploadedFilesDir, Request $request ): Response{
  2664.         #dd($uploadedFilesDir);
  2665.         $spreadsheet = IOFactory::load( $uploadedFilesDir . DIRECTORY_SEPARATOR . "Export_Eingangsrechnung.xls");
  2666.         $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, false );
  2669.         dd($sheetData);
  2671.         return $this->json(
  2672.             [
  2673.                 "message" => "Successfully",
  2674.                 "severity" => "success"
  2676.             ], Response::HTTP_OK, [], [
  2677.                 AbstractNormalizer::IGNORED_ATTRIBUTES => [
  2679.                 ]
  2680.             ]
  2681.         );
  2682.     }
  2684.     // Transform
  2685.     /**
  2686.      * @Route("/transfer-uploaded-cost-list", name="transfer_uploaded_cost_list")
  2687.      * @param Request $request
  2688.      * @return Response
  2689.      */
  2690.     function transferUploadedCostList( Request $request ): Response{
  2694.         return $this->json(
  2695.             [
  2697.             ], Response::HTTP_OK, [], [
  2698.                 AbstractNormalizer::IGNORED_ATTRIBUTES => [
  2700.                 ]
  2701.             ]
  2702.         );
  2703.     }
  2705.     /**
  2706.      * @Route("/print-project-foreword/{project_id}", name="print_project_foreword", methods={"POST", "GET"})
  2707.      * @ParamConverter("project", options={"mapping":{"project_id":"id"}})
  2708.      * @param Projects $project
  2709.      * @param Request $request
  2710.      * @return Response
  2711.      */
  2712.     function printProjectForeword( Projects $project, Request $request, PdfOutputTimesheet $pdfOutputTimesheet ): Response{
  2714.         if( !$project ){
  2715.             // Project not found!
  2716.             return $this->json(
  2717.                 [
  2718.                     "message" => "Project not found",
  2719.                     "severity" => "error"
  2720.                 ], Response::HTTP_NOT_FOUND, [], [
  2721.                     AbstractNormalizer::IGNORED_ATTRIBUTES => [
  2723.                     ]
  2724.                 ]
  2725.             );
  2726.         }
  2728.         if( !$project->getQrCode() ){
  2730.             return $this->json(
  2731.                 [
  2732.                     "message" => "Project QR-Core not ready please save project and try again",
  2733.                     "severity" => "warning",
  2734.                 ], Response::HTTP_METHOD_NOT_ALLOWED, [], [
  2735.                     AbstractNormalizer::IGNORED_ATTRIBUTES => [
  2737.                     ]
  2738.                 ]
  2739.             );
  2742.         }
  2744.         #dd($uploadedFilesDir);
  2745.         $pdfOutputTimesheet->setPrintedBy('Suleyman Topaloglu');
  2747.         $output = $pdfOutputTimesheet->printProjectForeword( $project, 'F' );
  2750.         return $this->json(
  2751.             [
  2752.                 "message" => "Successfully",
  2753.                 "severity" => "success",
  2754.                 'output'=>$output
  2756.             ], Response::HTTP_OK, [], [
  2757.                 AbstractNormalizer::IGNORED_ATTRIBUTES => [
  2759.                 ]
  2760.             ]
  2761.         );
  2762.     }
  2764. }