src/Controller/Admin/Sales/SalesController.php line 568

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Admin\Sales;
  5. use App\Dto\CalculatorProductsCostsDTO;
  6. use App\Dto\NewStockDto\SalesProductsDto;
  7. use App\Dto\PaginationDTO;
  8. use App\Dto\SalesProductsDtoBuilder;
  9. use App\Entity\Customer;
  10. use App\Entity\MeasurementUnits;
  11. use App\Entity\Payment;
  12. use App\Entity\ProductsSold;
  13. use App\Entity\Sales;
  14. use App\Entity\SalesHistory;
  15. use App\Entity\Stock;
  16. use App\Entity\StockTransaction;
  17. use App\Entity\User;
  18. use App\Entity\Warehouse;
  19. use App\Enum\SalesHistoryEventType;
  20. use App\Enum\SalesStatus;
  21. use App\Enum\SalesType;
  22. use App\Exception\IncorrectAmountException;
  23. use App\Exception\StockNotAvaibleException;
  24. use App\Exception\StockNotFoundException;
  25. use App\Form\CustomerType;
  26. use App\Form\PaymentType;
  27. use App\Form\ProductsSoldType;
  28. use App\Form\SalesFormType;
  29. use App\Repository\SalesRepository;
  30. use App\Repository\StockRepository;
  31. use App\Services\Customer\CustomerService;
  32. use App\Services\MailService;
  33. use App\Services\MeasurementConversions\MeasurementConversionsService;
  34. use App\Services\PDFService;
  35. use App\Services\LogService;
  36. use App\Services\Payment\PaymentMethodService;
  37. use App\Services\Payment\PaymentReminderService;
  38. use App\Services\Payment\PaymentService;
  39. use App\Services\Product\ProductService;
  40. use App\Services\Sales\Impl\SalesProductsServiceImpl;
  41. use App\Services\Sales\Impl\SalesServiceImpl;
  42. use App\Services\Sales\InvoiceService;
  43. use App\Services\Sales\SalesHistoryService;
  44. use App\Services\Sales\SalesService;
  45. use App\Repository\SalesReturnRepository;
  46. use App\Services\Stock\StockInfoService;
  47. use App\Services\Stock\StockService;
  48. use App\Services\Stock\StockTransferService;
  49. use App\Services\StockTransactionService;
  50. use App\Services\Warehouse\WarehouseService;
  51. use App\Utils\CurrencyHelper;
  52. use App\Utils\MailTemplateHelper;
  53. use Doctrine\DBAL\LockMode;
  54. use Doctrine\Common\Collections\ArrayCollection;
  55. use Doctrine\ORM\EntityManagerInterface;
  56. use Doctrine\ORM\NonUniqueResultException;
  57. use Doctrine\ORM\NoResultException;
  58. use Exception;
  59. use Knp\Bundle\SnappyBundle\Snappy\Response\PdfResponse;
  60. use Knp\Snappy\Pdf;
  61. use PhpOffice\PhpSpreadsheet\IOFactory;
  62. use Psr\Log\LoggerInterface;
  63. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  64. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  65. use Symfony\Component\HttpFoundation\BinaryFileResponse;
  66. use Symfony\Component\HttpFoundation\JsonResponse;
  67. use Symfony\Component\HttpFoundation\Request;
  68. use Symfony\Component\HttpFoundation\Response;
  69. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  70. use Symfony\Component\HttpKernel\KernelInterface;
  71. use Symfony\Component\Mailer\Exception\TransportExceptionInterface;
  72. use Symfony\Component\Mailer\Mailer;
  73. use Symfony\Component\Mailer\MailerInterface;
  74. use Symfony\Component\Mailer\Transport;
  75. use Symfony\Component\Mime\Address;
  76. use Symfony\Component\Mime\Email;
  77. use Symfony\Component\Routing\Annotation\Route;
  78. use Symfony\Component\Security\Core\User\UserInterface;
  79. use Symfony\Component\Serializer\SerializerInterface;
  80. use Symfony\Contracts\Translation\TranslatorInterface;
  82. class SalesController extends AbstractController
  83. {
  84.     private const STOCK_EXEMPT_PRODUCT_TYPES = ['INSTALLATION_SERVICE', 'MAINTENANCE_SERVICE', 'CONSULTATION_SERVICE', 'TREE'];
  85.     private const NEGATIVE_PRICE_ALLOWED_PRODUCT_TYPES = [];
  86.     private const MONEY_SCALE = 2;
  88.     private StockService $stockService;
  89.     private SerializerInterface $serializer;
  90.     private WarehouseService $warehouseService;
  91.     private SalesService $salesService;
  93.     private $projectDir;
  94.     private StockTransferService $stockTransferService;
  95.     private ProductService $productService;
  96.     private StockInfoService $stockInfoService;
  97.     private EntityManagerInterface $entityManager;
  98.     private StockRepository $stockRepository;
  99.     private CustomerService $customerService;
  100.     private PaymentMethodService $paymentMethodService;
  102.     private PaymentService $paymentService;
  103.     private PaymentReminderService $paymentReminderService;
  104.     private LogService $logService;
  105.     private StockTransactionService $stockTransactionService;
  106.     private LoggerInterface $logger;
  107.     private SalesProductsServiceImpl $salesProductsServiceImpl;
  108.     private SalesHistoryService $salesHistoryService;
  109.     private SalesReturnRepository $salesReturnRepository;
  111.     private TranslatorInterface $translator;
  112.     private SalesServiceImpl $salesServiceImpl;
  113.     private Pdf $knpSnappyPdf;
  114.     private InvoiceService $invoiceService;
  116.     private PDFService $pdfService;
  117.     private MeasurementConversionsService $measurementConversionsService;
  119.     /**
  120.      * @param KernelInterface $kernel
  121.      * @param StockService $stockService
  122.      * @param SerializerInterface $serializer
  123.      * @param WarehouseService $warehouseService
  124.      * @param SalesService $salesService
  125.      * @param StockTransferService $stockTransferService
  126.      * @param ProductService $productService
  127.      * @param StockInfoService $stockInfoService
  128.      * @param EntityManagerInterface $entityManager
  129.      * @param StockRepository $stockRepository
  130.      * @param CustomerService $customerService
  131.      * @param PaymentMethodService $paymentMethodService
  132.      * @param PaymentService $paymentService
  133.      * @param PaymentReminderService $paymentReminderService
  134.      * @param LogService $logService
  135.      * @param StockTransactionService $stockTransactionService
  136.      * @param LoggerInterface $logger
  137.      * @param SalesProductsServiceImpl $salesProductsServiceImpl
  138.      * @param TranslatorInterface $translator
  139.      * @param SalesServiceImpl $salesServiceImpl
  140.      * @param Pdf $knpSnappyPdf
  141.      * @param InvoiceService $invoiceService
  142.      * @param PDFService $pdfService
  143.      * @param MeasurementConversionsService $measurementConversionsService
  144.      */
  145.     public function __construct(
  146.         KernelInterface $kernel,
  147.         StockService $stockService,
  148.         SerializerInterface $serializer,
  149.         WarehouseService $warehouseService,
  150.         SalesService $salesService,
  151.         StockTransferService $stockTransferService,
  152.         ProductService $productService,
  153.         StockInfoService $stockInfoService,
  154.         EntityManagerInterface $entityManager,
  155.         StockRepository $stockRepository,
  156.         CustomerService $customerService,
  157.         PaymentMethodService $paymentMethodService,
  158.         PaymentService $paymentService,
  159.         PaymentReminderService $paymentReminderService,
  160.         LogService $logService,
  161.         StockTransactionService $stockTransactionService,
  162.         LoggerInterface $logger,
  163.         SalesProductsServiceImpl $salesProductsServiceImpl,
  164.         SalesHistoryService $salesHistoryService,
  165.         SalesReturnRepository $salesReturnRepository,
  166.         TranslatorInterface $translator,
  167.         SalesServiceImpl $salesServiceImpl,
  168.         Pdf $knpSnappyPdf,
  169.         InvoiceService $invoiceService,
  170.         PDFService $pdfService,
  171.         MeasurementConversionsService $measurementConversionsService
  172.     ) {
  173.         $this->stockService = $stockService;
  174.         $this->serializer = $serializer;
  175.         $this->warehouseService = $warehouseService;
  176.         $this->salesService = $salesService;
  177.         $this->stockTransferService = $stockTransferService;
  178.         $this->productService = $productService;
  179.         $this->stockInfoService = $stockInfoService;
  180.         $this->entityManager = $entityManager;
  181.         $this->stockRepository = $stockRepository;
  182.         $this->customerService = $customerService;
  183.         $this->paymentMethodService = $paymentMethodService;
  184.         $this->paymentService = $paymentService;
  185.         $this->paymentReminderService = $paymentReminderService;
  186.         $this->logService = $logService;
  187.         $this->stockTransactionService = $stockTransactionService;
  188.         $this->logger = $logger;
  189.         $this->salesProductsServiceImpl = $salesProductsServiceImpl;
  190.         $this->salesHistoryService = $salesHistoryService;
  191.         $this->salesReturnRepository = $salesReturnRepository;
  192.         $this->translator = $translator;
  193.         $this->salesServiceImpl = $salesServiceImpl;
  194.         $this->projectDir = $kernel->getProjectDir();
  195.         $this->knpSnappyPdf = $knpSnappyPdf;
  196.         $this->invoiceService = $invoiceService;
  197.         $this->pdfService = $pdfService;
  198.         $this->measurementConversionsService = $measurementConversionsService;
  199.     }
  202.     /**
  203.      * @throws StockNotAvaibleException
  204.      * @throws StockNotFoundException
  205.      */
  206.     #[Route('/sales', name: 'app_admin_sales')]
  207.     public function index(Request $request, SalesServiceImpl $salesServiceImpl, TranslatorInterface $translator): Response
  208.     {
  210.         $paymentMethods = $this->paymentMethodService->getPaymentMethods();
  212.         $sales = new Sales();
  213.         $sales->setInvoiceNumber($translator->trans('willBeCreatedAutomatically'));
  214.         $form = $this->createForm(SalesFormType::class, $sales);
  215.         $form->handleRequest($request);
  217.         $soldProducts = new ProductsSold();
  218.         $soldProductsFrom = $this->createForm(ProductsSoldType::class, $soldProducts);
  220.         $customer = new Customer();
  221.         $customer->setCode($this->customerService->createCustomerCode());
  222.         $customerForm = $this->createForm(CustomerType::class, $customer);
  223.         $customerForm->handleRequest($request);
  225.         $payment = new Payment();
  226.         $paymentForm = $this->createForm(PaymentType::class, $payment);
  227.         $paymentForm->handleRequest($request);
  229.         $stocks = $this->stockService->getAll();
  230.         $warehouses = $this->warehouseService->getAll();
  232.         if ($customerForm->isSubmitted() && $customerForm->isValid()) {
  233.             $customer = $customerForm->getData();
  234.             $customers = $this->customerService->findByFullName($customer->getFullName());
  236.             $this->addFlash('success', 'Müşteri başarıyla eklendi. Listeden seçebilirsiniz.');
  237.             $email = $customer->getEmail();
  238.             $customer->setEmail(mb_strtolower($email, 'UTF-8'));
  239.             $this->customerService->save($customerForm->getData());
  241.         }
  243.         return $this->render('admin/sales/index.html.twig', [
  244.             'controller_name' => 'SalesController',
  245.             'form' => $form->createView(),
  246.             'productsSoldForm' => $soldProductsFrom->createView(),
  247.             'customerForm' => $customerForm->createView(),
  248.             'paymentForm' => $paymentForm->createView(),
  249.             'warehouses' => $warehouses,
  250.             'paymentMethods' => $paymentMethods,
  251.         ]);
  252.     }
  255.     // Duplicate proforma
  256.     #[Route('/sales/duplicate/{id}', name: 'app_admin_sales_duplicate')]
  257.     public function duplicateProforma(Request $request, SalesServiceImpl $salesServiceImpl, TranslatorInterface $translator)
  258.     {
  260.         $paymentMethods = $this->paymentMethodService->getPaymentMethods();
  262.         $sales = $this->salesService->getEntityById($request->get('id'));
  263.         //        dd($sales->getProductsSolds()->get(0));
  264.         $sales->setInvoiceNumber($translator->trans('willBeCreatedAutomatically'));
  265.         $form = $this->createForm(SalesFormType::class, $sales);
  266.         $form->handleRequest($request);
  268.         $soldProducts = new ProductsSold();
  269.         $soldProductsFrom = $this->createForm(ProductsSoldType::class, $soldProducts);
  271.         $customer = new Customer();
  272.         $customer->setCode($this->customerService->createCustomerCode());
  273.         $customerForm = $this->createForm(CustomerType::class, $customer);
  274.         $customerForm->handleRequest($request);
  276.         $payment = new Payment();
  277.         $paymentForm = $this->createForm(PaymentType::class, $payment);
  278.         $paymentForm->handleRequest($request);
  280.         $stocks = $this->stockService->getAll();
  281.         $warehouses = $this->warehouseService->getAll();
  283.         if ($customerForm->isSubmitted() && $customerForm->isValid()) {
  284.             $customer = $customerForm->getData();
  285.             $customers = $this->customerService->findByFullName($customer->getFullName());
  286.             if (count($customers) > 0) {
  287.                 $this->addFlash('error', 'Bu müşteri kaydı zaten var ! Listeden seçip devam edebilirsiniz.');
  288.             } else {
  289.                 $this->addFlash('success', 'Müşteri başarıyla eklendi. Listeden seçebilirsiniz.');
  290.                 $email = $customer->getEmail();
  291.                 $customer->setEmail(mb_strtolower($email, 'UTF-8'));
  292.                 $this->customerService->save($customerForm->getData());
  293.             }
  294.         }
  296.         return $this->render('admin/sales/index.html.twig', [
  297.             'sales' => $sales,
  298.             'controller_name' => 'SalesController',
  299.             'form' => $form->createView(),
  300.             'productsSoldForm' => $soldProductsFrom->createView(),
  301.             'customerForm' => $customerForm->createView(),
  302.             'paymentForm' => $paymentForm->createView(),
  303.             'warehouses' => $warehouses,
  304.             'paymentMethods' => $paymentMethods,
  305.             'sales'
  306.         ]);
  308.     }
  310.     #[Route('/sales/create', name: 'app_admin_sales_create')]
  311.     public function create(Request $request, SalesServiceImpl $salesServiceImpl): Response
  312.     {
  314.         $this->logger->info("sales", [
  315.             'title' => 'Satış işlemi başlatıldı',
  316.             'request' => $request->request->all(),
  317.         ]);
  318.         $this->entityManager->beginTransaction();
  320.         $products = $request->get('products');
  321.         $payments = $request->get('payments');
  322.         $soldList = $request->get('soldList');
  323.         $invoice = $request->get('invoice');
  324.         $warehouseId = $soldList[0]['warehouse'];
  325.         $salesType = $invoice['salesType'] ?? 'proforma';
  327.         $intendedStatus = $this->resolveSalesStatus($invoice['salesStatus'] ?? null);
  328.         try {
  329.             // Stok kontrolü: yalnızca COMPLETED veya PENDING_ITEMS durumunda yapılır
  330.             if ($this->shouldAffectStock($intendedStatus)) {
  331.                 $this->checkStocks($soldList);
  332.             }
  334.             // Ürün bazlı indirim kdv gibi işlemler yapılıp total fiyatların frontend ile aynı olup olmadığı kontrol ediliyor.
  335.             foreach ($soldList as $soldProduct) {
  336.                 $this->logger->info("sales", [
  337.                     'title' => 'Ürün bazlı indirim kdv hesaplanıyor...',
  338.                     'product' => $soldProduct,
  339.                 ]);
  340.                 $this->assertUnitPriceAllowed($soldProduct);
  341.                 $this->calculateTotalPrice($soldProduct);
  342.             }
  344.             // Ödeme planı ile ürünlerin toplam fiyatlarının eşitliği kontrol ediliyor.
  345.             $totalPrice = $this->checkPaymentAndAmountIsEqual($payments, $soldList);
  347.             $repo = $this->entityManager->getRepository(Sales::class);
  348.             $invoiceNumber = $salesServiceImpl->createProformaNumber();
  349.             $sale = $repo->findBy(['invoiceNumber' => $invoiceNumber]);
  350.             //            dd($request);
  351.             if ($sale != null) {
  352.                 throw new Exception(sprintf("%s fatura numarası ile kayıtlı bir fatura var. Lütfen kontrol ediniz.", $invoice['invoiceNumber']));
  353.             } else {
  354.                 $soldProductsArray = new ArrayCollection();
  355.                 for ($i = 0; $i < count($soldList); $i++) {
  356.                     $product = $this->productService->getEntityId($soldList[$i]['productid']);
  357.                     $calculatorDto = $this->stockRepository->calculateCost($soldList[$i]['productid'], $warehouseId);
  358.                     $builder = new SalesProductsDtoBuilder();
  359.                     $soldProductsArray->add(
  360.                         $builder
  361.                             ->setProductName($soldList[$i]['productName'])
  362.                             ->setMeasurement($product->getMeasurement()?->getMeasurement())
  363.                             ->setQuantity($soldList[$i]['quantity'])
  364.                             ->setUnitPriceFob($calculatorDto->getPriceFob())
  365.                             ->setUnitPriceNavlun($calculatorDto->getPriceNavlun())
  366.                             ->setTotalUnitPrice($calculatorDto->getAverageCostPrice())
  367.                             ->setTotalUnitPurchasePrice($soldList[$i]['totalPurchasePrice'])
  368.                             ->setProductId($product->getId())
  369.                             ->setTotalUnitPrice($soldList[$i]['unitPrice'])
  370.                             ->setWarehouseId($warehouseId)
  371.                             ->setTax($soldList[$i]['tax'])
  372.                             ->setTotalSalePrice($soldList[$i]['totalPurchasePrice'])
  373.                             ->setDiscount($soldList[$i]['discount'])
  374.                             ->setUnAllocatedQuantity($soldList[$i]['unAllocatedQuantity'])
  375.                             ->setSelectedUnitId($soldList[$i]['selectedUnitId'])
  376.                             ->build()
  377.                     );
  378.                 }
  380.                 $customer = $this->customerService->getCustomerById($invoice['customer']);
  381.                 $sales = new Sales();
  382.                 $sales->setSalesDate(new \DateTime($invoice['salesDate']));
  383.                 $sales->setCustomer($customer);
  384.                 $sales->setStatus($intendedStatus);
  385.                 $userRepo = $this->entityManager->getRepository(User::class);
  386.                 $sales->setSeller($userRepo->find($invoice['seller']));
  387.                 $sales->setInvoiceNumber($invoice['invoiceNumber']);
  388.                 $sales->setTotalPurchasePrice($totalPrice);
  389.                 $sales->setDescription($invoice['description']);
  390.                 $sales->setShippingNotes($invoice['shippingNotes']);
  391.                 $sales->setPaymentNotes($invoice['paymentNotes']);
  393.                 $performedBy = $this->getUser();
  394.                 $sales = $this->salesService->create(
  395.                     $sales,
  396.                     $soldProductsArray,
  397.                     $salesType,
  398.                     $performedBy instanceof User ? $performedBy : null
  399.                 );
  401.                 $this->createPayments($payments, $customer, $sales);
  402.                 $this->entityManager->commit();
  403.                 return new JsonResponse(['success' => true, 'id' => $sales->getId()]);
  404.             }
  407.         } catch (Exception $e) {
  408.             $this->entityManager->rollback();
  409.             $message = $e->getMessage();
  410.             return new JsonResponse(['status' => 'error', 'message' => $message], 400);
  411.         }
  413.         return new JsonResponse(['status' => 'success']);
  414.     }
  417.     #[Route('/sales/un-allocated-products', name: 'un_allocated_products_index')]
  418.     public function getUnAllocatedProducts(Request $request)
  419.     {
  421.         $warehouses = $this->warehouseService->getAll();
  423.         if ($request->getMethod() == 'POST') {
  425.             if (isset($request->get('search')['value']))
  426.                 $s = $request->get('search')['value'];
  427.             else
  428.                 $s = '';
  430.             if (isset($request->get('order')[0]['column']))
  431.                 $column = $request->get('order')[0]['column'];
  432.             else
  433.                 $column = 0;
  435.             if (isset($request->get('order')[0]['dir']))
  436.                 $dir = $request->get('order')[0]['dir'];
  437.             else
  438.                 $dir = 'ASC';
  440.             $startDate = $request->get('startDate');
  441.             $finishDate = $request->get('finishDate');
  443.             $limit = $request->get('length');
  444.             if ($request->get('start'))
  445.                 $page = 1 + ($request->get('start') / $limit);
  446.             else
  447.                 $page = 1;
  449.             $warehouseid = $request->get('warehouseid');
  451.             $result = $this->salesProductsServiceImpl->getAllUnAllocatedProductsPaginate(
  452.                 $s,
  453.                 $column,
  454.                 $dir,
  455.                 $page,
  456.                 $limit,
  457.                 $startDate,
  458.                 $finishDate,
  459.                 $warehouseid
  460.             );
  461.             return $this->json($result);
  462.         }
  465.         return $this->render('admin/sales/unallocated_products.html.twig', [
  466.             'warehouses' => $warehouses
  467.         ]);
  468.     }
  470.     /**
  471.      * @throws NonUniqueResultException
  472.      * @throws NoResultException
  473.      */
  474.     #[Route('/sales/un-allocated-products/allocate', name: 'un_allocated_products_allocate')]
  475.     public function allocateProduct(Request $request)
  476.     {
  477.         $content = $request->getContent();
  478.         $data = json_decode($content, true);
  480.         $id = $data["id"];
  481.         $allocatedQuantity = $data["allocatedQuantity"];
  482.         $customer = $data["customer"];
  483.         $measurement = $data["measurement"];
  484.         $measurementUnit = $data["measurementUnit"];
  485.         $productCode = $data["productCode"];
  486.         $productName = $data["productName"];
  487.         $salesDate = $data["salesDate"];
  488.         $sellerName = $data["sellerName"];
  489.         $stockInfo = $data["stockInfo"];
  490.         $totalSold = $data["totalSold"];
  491.         $unAllocatedQuantity = $data["unAllocatedQuantity"];
  492.         $warehouseName = $data["warehouseName"];
  494.         $productSold = $this->salesProductsServiceImpl->getEntityById($id);
  496.         $quantityToAllocate = $allocatedQuantity - $productSold->getQuantity();
  498.         $stock = $this->stockInfoService->getStockInfoByProductAndWarehouse(
  499.             $productSold->getProduct(),
  500.             $productSold->getSales()->getWarehouse()
  501.         );
  502.         if ($quantityToAllocate > $stock->getTotalQuantity()) {
  503.             return $this->json([
  504.                 'message' => sprintf('Stok miktarı yetersiz, depodaki stok miktarı = %s', $stock->getTotalQuantity())
  505.             ], 400);
  506.         }
  507.         //        dd($quantityToAllocate, CurrencyHelper::convertToFloat($productSold->getUnAllocatedQuantity()));
  508.         $unAllocatedQuantityFromProduct = round(CurrencyHelper::convertToFloat($productSold->getUnAllocatedQuantity()), 2);
  509.         $quantityToAllocate = round($quantityToAllocate, 2);
  511.         if ($quantityToAllocate > $unAllocatedQuantityFromProduct) {
  512.             return $this->json([
  513.                 'message' => sprintf(
  514.                     'Hatalı bilgi. Tahsis etmek istediğiniz miktar tahsis edilmemiş miktardan büyük olamaz. Tahsis edilmemiş miktar = %s',
  515.                     $productSold->getUnAllocatedQuantity()
  516.                 )
  517.             ], 400);
  518.         }
  521.         return $this->json(
  522.             ['message' => $this->salesProductsServiceImpl->allocateQuantity($productSold, $quantityToAllocate)]
  523.         );
  525.     }
  527.     #[Route('/sales/un-allocated-products/detail/ajax', name: 'un_allocated_products_detail_ajax')]
  528.     public function getUnAllocatedProduct(Request $request)
  529.     {
  530.         /**
  531.          * @var ProductsSold $entity
  532.          */
  533.         $entity = $this->salesProductsServiceImpl->getEntityById($request->get('productSoldId'));
  534.         return $this->json([
  535.             'id' => $entity->getId(),
  536.             'productName' => $entity->getProduct()->getName(),
  537.             'productCode' => $entity->getProduct()->getCode(),
  538.             'measurement' => $entity->getProduct()->getMeasurement()->getName(),
  539.             'measurementUnit' => $entity->getProduct()->getMeasurementUnit()->getSymbol(),
  540.             'customer' => $entity->getSales()->getCustomer()->getFullName(),
  541.             'allocatedQuantity' => $entity->getQuantity(),
  542.             'unAllocatedQuantity' => $entity->getUnAllocatedQuantity(),
  543.             'salesDate' => $entity->getSales()->getSalesDate()->format('d-m-Y'),
  544.             'warehouseName' => $entity->getSales()->getWarehouse()->getName(),
  545.             'stockInfo' => $this->stockInfoService->getStockInfoByProductAndWarehouse(
  546.                 $entity->getProduct(),
  547.                 $entity->getSales()->getWarehouse()
  548.             )->getTotalQuantity(),
  549.             'sellerName' => $entity->getSales()->getSeller()->getFullname(),
  550.             'totalSold' => CurrencyHelper::convertToCurrency($entity->getQuantity() + ($entity->getUnAllocatedQuantity() == null ? 0 : $entity->getUnAllocatedQuantity())),
  551.         ]);
  552.     }
  555.     #[Route('/proforma/index', name: 'proforma_index')]
  556.     public function getAllProformas(Request $request, EntityManagerInterface $entityManager)
  557.     {
  558.         $warehouses = $this->warehouseService->getAll();
  560.         return $this->render('admin/sales/proforma_index.html.twig', [
  561.             'controller_name' => 'StockController',
  562.             'warehouses' => $warehouses
  563.         ]);
  564.     }
  567.     #[Route('/proforma/ajax', name: 'proforma_ajax')]
  568.     public function getAllProformasAjax(Request $request, SalesServiceImpl $salesServiceImpl)
  569.     {
  571.         $user = $this->getUser();
  572.         if (isset($request->get('search')['value']))
  573.             $s = $request->get('search')['value'];
  574.         else
  575.             $s = '';
  577.         $id = $request->get('id');
  578.         if (isset($request->get('order')[0]['column']))
  579.             $column = $request->get('order')[0]['column'];
  580.         else
  581.             $column = 0;
  582.         if (isset($request->get('order')[0]['dir']))
  583.             $dir = $request->get('order')[0]['dir'];
  584.         else
  585.             $dir = 'ASC';
  586.         $startDate = $request->get('startDate');
  587.         $finishDate = $request->get('finishDate');
  589.         $limit = $request->get('length');
  590.         if ($request->get('start'))
  591.             $page = 1 + ($request->get('start') / $limit);
  592.         else
  593.             $page = 1;
  594.         $warehouseid = $request->get('warehouseid');
  595.         $stocks = $salesServiceImpl->getAllProformasPaginate($user, $page, $limit, $warehouseid, $column, $dir, $s, $startDate, $finishDate);
  596.         return new JsonResponse($this->createArrayForDataTable($stocks));
  597.     }
  600.     private function createPayments($payments, $customer, $sales)
  601.     {
  602.         foreach ($payments as $payment) {
  603.             $paymentMethod = $this->paymentMethodService->getPaymentMethodById($payment['paymentMethod']);
  604.             $paymentObj = $this->paymentService->createPayment($customer, $paymentMethod, $sales, $payment['paymentDate'], $payment['amount'], $payment['status'], $payment['paymentDueDate'], $payment['description']);
  605.             $a = 0;
  606.             if ($paymentObj->getPaymentStatus() == 2) {
  607.                 $paymentReminder = $this->paymentReminderService->create($paymentObj, $payment['paymentDate'], $payment['status'], $payment['paymentMethod']);
  608.             }
  609.         }
  610.     }
  612.     /**
  613.      * @throws StockNotAvaibleException
  614.      * @throws StockNotFoundException
  615.      */
  616.     private function checkStocks($soldList): array
  617.     {
  618.         $warehouseId = $soldList[0]['warehouse'];
  620.         $quantities = [];
  622.         foreach ($soldList as $soldProduct) {
  623.             $productId = $soldProduct['productid'];
  625.             // Ürün tipine göre stok kontrolünü atla (service & tree)
  626.             $product = $this->productService->getEntityId($productId);
  628.             if ($product && $this->isStockExemptProductType($product->getProductTypeEnum())) {
  629.                 continue; // bu ürünlerde stok kontrolü yapılmaz
  630.             }
  632.             // Birim dönüşümü: selectedUnitId farklı ise temel birime çevirerek topla
  633.             $rawQuantity = (float) $soldProduct['quantity'];
  634.             $selectedUnitId = $soldProduct['selectedUnitId'] ?? null;
  636.             if (!isset($quantities[$productId])) {
  637.                 $quantities[$productId] = 0.0;
  638.             }
  640.             if ($selectedUnitId) {
  641.                 // SalesServiceImpl içindeki dönüştürme mantığını kullan
  642.                 $converted = $this->salesServiceImpl->getConvertedQuantity($product, $selectedUnitId, $rawQuantity);
  643.                 $quantities[$productId] += (float) $converted;
  644.             } else {
  645.                 $quantities[$productId] += $rawQuantity;
  646.             }
  647.         }
  649.         foreach ($quantities as $productId => $quantity) {
  650.             $this->stockInfoService->checkIsStockAvailable($quantity, $productId, $warehouseId);
  651.         }
  653.         return $quantities;
  654.     }
  656.     /**
  657.      * @throws Exception
  658.      */
  659.     private function applyRoundingRule(float $value): float
  660.     {
  661.         return round($value, self::MONEY_SCALE, PHP_ROUND_HALF_UP);
  662.     }
  664.     /**
  665.      * @throws Exception
  666.      */
  667.     private function checkPaymentAndAmountIsEqual($payments, $soldList)
  668.     {
  669.         $totalPriceRaw = 0.0;
  670.         $totalAmountOfPayments = 0.0;
  672.         foreach ($payments as $payment) {
  673.             $totalAmountOfPayments += CurrencyHelper::convertToFloat($payment['amount']);
  674.         }
  676.         foreach ($soldList as $soldProduct) {
  677.             $totalPriceRaw += $this->calculateTotalPrice($soldProduct);
  678.         }
  680.         $totalPrice = $this->applyRoundingRule($totalPriceRaw);
  681.         $totalAmountOfPayments = $this->applyRoundingRule($totalAmountOfPayments);
  683.         $diff = abs($totalPrice - $totalAmountOfPayments);
  684.         if ($diff > 1) {
  685.             throw new Exception("Ödemeler ile ürünlerin fiyatları farklı. Toplam Ürün Fiyatı: " . $totalPrice . ", Toplam Ödeme: " . $totalAmountOfPayments . ", Fark: " . $diff, 401);
  686.         }
  687.         return $totalPrice;
  688.     }
  690.     /**
  691.      * @throws Exception
  692.      */
  693.     private function calculateTotalPrice($soldProduct): float
  694.     {
  695.         $quantity = CurrencyHelper::convertToFloat($soldProduct['quantity']);
  696.         $unAllocatedQuantity = CurrencyHelper::convertToFloat($soldProduct['unAllocatedQuantity']);
  697.         $tax = CurrencyHelper::convertToFloat($soldProduct['tax']);
  698.         $unitPrice = CurrencyHelper::convertToFloat($soldProduct['unitPrice']);
  699.         $discount = CurrencyHelper::convertToFloat($soldProduct['discount']);
  700.         $totalPurchasePrice = CurrencyHelper::convertToFloat($soldProduct['totalPurchasePrice']);
  702.         $totalQuantity = $quantity + $unAllocatedQuantity;
  704.         $subtotal = $totalQuantity * $unitPrice;
  705.         $discountAmount = $subtotal * ($discount / 100);
  706.         $afterDiscount = $subtotal - $discountAmount;
  707.         $taxAmount = $afterDiscount * ($tax / 100);
  708.         $lineTotal = $afterDiscount + $taxAmount;
  709.         $roundedLineTotal = $this->applyRoundingRule($lineTotal);
  710.         $roundedFrontend = $this->applyRoundingRule($totalPurchasePrice);
  711.         $difference = abs($roundedLineTotal - $roundedFrontend);
  712.         $rawDifference = abs($lineTotal - $totalPurchasePrice);
  713.         if ($difference > 1) {
  714.             throw new Exception("Fiyatlar arasında hesaplamada fark var. Backend: " . $roundedLineTotal . ", Frontend: " . $totalPurchasePrice . ", Fark: " . $difference, 401);
  715.         }
  717.         $this->logger->info("sales", [
  718.             'title' => 'Kullanıcının girdiği ödemeler ile ürün bazlı toplamlar karşılaştırılıyor',
  719.             'backend_rounded' => $roundedLineTotal,
  720.             'backend_raw' => $lineTotal,
  721.             'frontend' => $totalPurchasePrice,
  722.             'frontend_rounded' => $roundedFrontend,
  723.             'difference' => $difference,
  724.             'raw_difference' => $rawDifference,
  725.         ]);
  727.         return $lineTotal;
  728.     }
  730.     private function roundUpToTwoDecimalsPrecise($number)
  731.     {
  732.         return round(ceil($number * 1000) / 1000, 2);
  733.     }
  735.     #[Route('/product-calculate-cost', name: 'product_calculate_cost')]
  736.     public function exampleCostCalcolator(Request $request, StockRepository $stockRepository)
  737.     {
  738.         $repo = $stockRepository->calculateCost(30);
  739.         return $this->json(['data' => 'data']);
  740.     }
  744.     #[Route('/stock-detail/{id}', name: 'app_admin_stock_detail')]
  745.     public function stockDetail(Request $request, $id)
  746.     {
  747.         $stock = $this->stockService->getStockById($id);
  748.         return $this->json($stock);
  749.     }
  752.     /**
  753.      * @throws Exception
  754.      */
  755.     #[Route('/product/{id}/measurement-units', name: 'get_product_measurement_units', methods: ['GET'])]
  756.     public function getAvailableMeasurementUnits(int $id): JsonResponse
  757.     {
  758.         $product = $this->productService->getEntityId($id);
  759.         if (!$product)
  760.             throw new Exception(sprintf("Product not found with %s", $id), 404);
  761.         $availableUnits = $this->measurementConversionsService->getAvailableUnitsFor($product);
  762.         //        dd($availableUnits);
  763.         return $this->json(
  764.             $availableUnits,
  765.             JsonResponse::HTTP_OK,
  766.             [],
  767.             ['groups' => 'measurement:read']
  768.         );
  769.     }
  773.     #[Route('/sales/detail/{id}', name: 'app_admin_sales_detail')]
  774.     public function edit(Request $request, $id, SalesRepository $salesRepository)
  775.     {
  776.         $payments = $request->get('payments');
  777.         $soldList = $request->get('soldList');
  778.         $oldStatus = $this->salesService->getEntityById($id)->getStatus();
  779.         $newStatus = $request->get('invoice')['salesStatus'] ?? null;
  782.         $sales = $this->salesServiceImpl->getEntityById(3);
  783.         if (isset($soldList[0]['warehouse']))
  784.             $warehouseId = $soldList[0]['warehouse'];
  785.         else
  786.             $warehouseId = 0;
  787.         $invoice = $request->get('invoice');
  788.         // Log the edit operation
  789.         $this->logger->info("sales", [
  790.             'title' => 'Satış düzenleme işlemi başlatıldı',
  791.             'saleId' => $id,
  792.             'request' => $request->request->all(),
  793.         ]);
  794.         $this->entityManager->beginTransaction();
  796.         try {
  797.             $sale = $this->salesService->getEntityById($id);
  799.             $form = $this->createForm(SalesFormType::class, $sale);
  800.             $soldProducts = new ProductsSold();
  801.             $soldProductsFrom = $this->createForm(ProductsSoldType::class, $soldProducts);
  802.             $form->handleRequest($request);
  804.             $customer = new Customer();
  805.             $customerForm = $this->createForm(CustomerType::class, $customer);
  807.             $customerForm->handleRequest($request);
  809.             if ($customerForm->isSubmitted() && $customerForm->isValid()) {
  810.                 /**
  811.                  * @var Customer $customer
  812.                  */
  813.                 $customer = $customerForm->getData();
  815.                 $this->addFlash('success', 'Müşteri başarıyla eklendi. Listeden seçebilirsiniz.');
  816.                 $email = $customer->getEmail();
  817.                 $customer->setEmail(mb_strtolower($email, 'UTF-8'));
  818.                 $this->customerService->save($customerForm->getData());
  820.                 $this->entityManager->commit();
  821.                 $referer = $request->headers->get('referer');
  822.                 return $this->redirect($referer ?: '/sales/detail/' . $id);
  823.             }
  825.             $payment = new Payment();
  826.             $paymentForm = $this->createForm(PaymentType::class, $payment);
  828.             $paymentMethods = $this->paymentMethodService->getPaymentMethods();
  830.             $warehouses = $this->warehouseService->getAll();
  831.             if ($request->getMethod() == 'POST') {
  833.                 $sale = $this->salesService->getEntityById($id);
  834.                 $salesType = $invoice['salesType'] ?? 'PROFORMA'; // Default to PROFORMA if not provided
  836.                 $groupedTotalQuantitiesByProduct = $salesRepository->getGroupedProductsSoldBySale($sale);
  838.                 // Stok kontrolü: yalnızca COMPLETED veya PENDING_ITEMS durumunda yapılır
  839.                 $intendedStatus = $this->resolveSalesStatus($invoice['salesStatus'] ?? null);
  840.                 if ($this->shouldAffectStock($intendedStatus)) {
  841.                     $this->checkStocksIsAvailableForEditedSale($soldList, $groupedTotalQuantitiesByProduct);
  842.                 }
  844.                 // Ürün bazlı indirim kdv gibi işlemler yapılıp total fiyatların frontend ile aynı olup olmadığı kontrol ediliyor.
  845.                 foreach ($soldList as $soldProduct) {
  846.                     $this->logger->info("sales", [
  847.                         'title' => 'Ürün bazlı indirim kdv hesaplanıyor (düzenleme)...',
  848.                         'product' => $soldProduct,
  849.                     ]);
  850.                     $this->assertUnitPriceAllowed($soldProduct);
  851.                     $this->calculateTotalPrice($soldProduct);
  852.                 }
  854.                 // Ödeme planı ile ürünlerin toplam fiyatlarının eşitliği kontrol ediliyor.
  855.                 $totalPrice = $this->checkPaymentAndAmountIsEqual($payments, $soldList);
  857.                 $repo = $this->entityManager->getRepository(Sales::class);
  859.                 $saleQ = $repo->createQueryBuilder('c')
  860.                     ->where('c.invoiceNumber = :invoiceNumber')
  861.                     ->andWhere('c.id != :id')
  862.                     ->setParameters(['invoiceNumber' => $invoice['invoiceNumber'], 'id' => $id])
  863.                     ->getQuery()
  864.                     ->getResult();
  865.                 if ($saleQ) {
  866.                     throw new Exception(sprintf("%s fatura numarasına kayıtlı bir satış mevcut.", $invoice['invoiceNumber']));
  867.                 } else {
  868.                     $soldProductsArray = new ArrayCollection();
  869.                     for ($i = 0; $i < count($soldList); $i++) {
  870.                         $product = $this->productService->getEntityId($soldList[$i]['productid']);
  871.                         $calculatorDto = $this->stockRepository->calculateCost($soldList[$i]['productid'], $warehouseId);
  873.                         $builder = new SalesProductsDtoBuilder();
  874.                         $soldProductsArray->add(
  875.                             $builder
  876.                                 ->setProductName($soldList[$i]['productName'] ?? $product->getName())
  877.                                 ->setMeasurement($product->getMeasurement()?->getMeasurement())
  878.                                 ->setQuantity($soldList[$i]['quantity'])
  879.                                 ->setUnitPriceFob($calculatorDto->getPriceFob())
  880.                                 ->setUnitPriceNavlun($calculatorDto->getPriceNavlun())
  881.                                 ->setTotalUnitPrice($soldList[$i]['unitPrice'])
  882.                                 ->setTotalUnitPurchasePrice($soldList[$i]['totalPurchasePrice'])
  883.                                 ->setProductId($product->getId())
  884.                                 ->setWarehouseId($warehouseId)
  885.                                 ->setTax($soldList[$i]['tax'])
  886.                                 ->setTotalSalePrice($soldList[$i]['totalPurchasePrice'])
  887.                                 ->setDiscount($soldList[$i]['discount'])
  888.                                 ->setUnAllocatedQuantity($soldList[$i]['unAllocatedQuantity'])
  889.                                 ->setSelectedUnitId($soldList[$i]['selectedUnitId'] ?? null)
  890.                                 ->build()
  891.                         );
  892.                     }
  894.                     $customer = $this->customerService->getCustomerById($invoice['customer']);
  896.                     $sale->setSalesDate(new \DateTime($invoice['salesDate']));
  897.                     $sale->setCustomer($customer);
  898.                     $userRepo = $this->entityManager->getRepository(User::class);
  899.                     $sale->setSeller($userRepo->find($invoice['seller']));
  900.                     $sale->setInvoiceNumber($invoice['invoiceNumber']);
  901.                     $sale->setTotalPurchasePrice($totalPrice);
  902.                     $sale->setDescription($invoice['description']);
  903.                     $sale->setShippingNotes($invoice['shippingNotes']);
  904.                     $sale->setPaymentNotes($invoice['paymentNotes']);
  906.                     $performedBy = $this->getUser();
  907.                     $sale = $this->salesService->update(
  908.                         $sale,
  909.                         $soldProductsArray,
  910.                         $intendedStatus,
  911.                         $performedBy instanceof User ? $performedBy : null
  912.                     );
  913.                     $this->createPayments($payments, $customer, $sale);
  914.                     $this->entityManager->commit();
  916.                     return new JsonResponse(['success' => true]);
  917.                 }
  918.             }
  920.         } catch (Exception $exception) {
  921.             $this->entityManager->rollback();
  922.             $message = $exception->getMessage();
  923.             $this->logger->error("sales", [
  924.                 'title' => 'Satış düzenleme hatası',
  925.                 'error' => $message,
  926.                 'trace' => $exception->getTraceAsString()
  927.             ]);
  928.             return new JsonResponse(['status' => 'error', 'message' => $message], 400);
  929.         }
  931.         $historyEntries = $sale->getHistoryEntries()->toArray();
  932.         usort(
  933.             $historyEntries,
  934.             static fn(SalesHistory $a, SalesHistory $b) => $b->getPerformedAt()->getTimestamp() <=> $a->getPerformedAt()->getTimestamp()
  935.         );
  936.         $returns = $this->salesReturnRepository->findBy(['sale' => $sale], ['requestedAt' => 'DESC']);
  938.         // Check if returns can be created for this sale
  939.         $canCreateReturn = $this->canCreateReturnForSale($sale);
  941.         return $this->render('admin/sales/edit.html.twig', [
  942.             'sale' => $sale,
  943.             'form' => $form->createView(),
  944.             'warehouses' => $warehouses,
  945.             'productsSoldForm' => $soldProductsFrom->createView(),
  946.             'customerForm' => $customerForm->createView(),
  947.             'paymentForm' => $paymentForm->createView(),
  948.             'paymentMethods' => $paymentMethods,
  949.             'historyEntries' => $historyEntries,
  950.             'returns' => $returns,
  951.             'canCreateReturn' => $canCreateReturn,
  952.             'defaultMailContent' => $this->getDefaultMailContent(),
  953.         ]);
  954.     }
  958.     public function checkStocksIsAvailableForEditedSale($productToSolds, $soldQuantities)
  959.     {
  960.         $newProductSoldArr = [];
  961.         $warehouse = $productToSolds[0]['warehouse'];
  963.         foreach ($productToSolds as $productToSold) {
  964.             $productId = $productToSold['productid'];
  966.             // Ürün tipine göre stok kontrolünü atla (service & tree)
  967.             $product = $this->productService->getEntityId($productId);
  969.             if ($product && $this->isStockExemptProductType($product->getProductTypeEnum())) {
  970.                 continue; // bu ürünlerde stok kontrolü yapılmaz
  971.             }
  973.             // Birim dönüşümü: selectedUnitId farklı ise temel birime çevirerek topla
  974.             $rawQuantity = (float) $productToSold['quantity'];
  975.             $selectedUnitId = $productToSold['selectedUnitId'] ?? null;
  977.             if (!isset($newProductSoldArr[$productId])) {
  978.                 $newProductSoldArr[$productId] = 0.0;
  979.             }
  981.             if ($selectedUnitId) {
  982.                 // SalesServiceImpl içindeki dönüştürme mantığını kullan
  983.                 $converted = $this->salesServiceImpl->getConvertedQuantity($product, $selectedUnitId, $rawQuantity);
  984.                 $newProductSoldArr[$productId] += (float) $converted;
  985.             } else {
  986.                 $newProductSoldArr[$productId] += $rawQuantity;
  987.             }
  988.         }
  990.         foreach ($newProductSoldArr as $productId => $requiredQuantity) {
  991.             $availableStock = $this->stockInfoService->getStockInfoByProductAndWarehouse(
  992.                 $this->productService->getEntityId($productId),
  993.                 $this->warehouseService->getEntityById($warehouse)
  994.             );
  995.             $previouslySoldQuantity = $this->findStockInArray($soldQuantities, $productId);
  996.             $totalAvailableStock = $previouslySoldQuantity + $availableStock->getTotalQuantity();
  998.             if ($requiredQuantity > $totalAvailableStock) {
  999.                 throw new Exception(sprintf(
  1000.                     "Yetersiz stok. %s id'li ürün için toplam kullanılabilir stok miktarı = %s, talep edilen = %s",
  1001.                     $productId,
  1002.                     $totalAvailableStock,
  1003.                     $requiredQuantity
  1004.                 ));
  1005.             }
  1006.         }
  1007.         return true;
  1008.     }
  1010.     public function findStockInArray($arr, $productId)
  1011.     {
  1012.         foreach ($arr as $item) {
  1013.             if ($item['productId'] == $productId) {
  1014.                 return $item['totalQuantity'];
  1015.             }
  1016.         }
  1017.         return 0;
  1018.     }
  1020.     private function normalizeProductTypeName($type): ?string
  1021.     {
  1022.         if ($type instanceof \UnitEnum) {
  1023.             return $type->name;
  1024.         }
  1025.         if (is_array($type)) {
  1026.             return $type['name'] ?? ($type['key'] ?? null);
  1027.         }
  1028.         if (is_string($type)) {
  1029.             return strtoupper($type);
  1030.         }
  1031.         return null;
  1032.     }
  1034.     private function isStockExemptProductType($type): bool
  1035.     {
  1036.         $normalized = $this->normalizeProductTypeName($type);
  1037.         return $normalized ? in_array($normalized, self::STOCK_EXEMPT_PRODUCT_TYPES, true) : false;
  1038.     }
  1040.     private function canProductTypeUseNegativePrice($type): bool
  1041.     {
  1042.         $normalized = $this->normalizeProductTypeName($type);
  1043.         return $normalized ? in_array($normalized, self::NEGATIVE_PRICE_ALLOWED_PRODUCT_TYPES, true) : false;
  1044.     }
  1046.     private function assertUnitPriceAllowed(array $soldProduct): void
  1047.     {
  1048.         if (empty($soldProduct['productid']) || !array_key_exists('unitPrice', $soldProduct)) {
  1049.             return;
  1050.         }
  1052.         $product = $this->productService->getEntityId($soldProduct['productid']);
  1053.         if (!$product) {
  1054.             return;
  1055.         }
  1057.         $unitPrice = CurrencyHelper::convertToFloat($soldProduct['unitPrice']);
  1058.         $type = $product->getProductTypeEnum();
  1060.         if ($this->canProductTypeUseNegativePrice($type)) {
  1061.             if ($unitPrice >= 0) {
  1062.                 throw new Exception('Avoir ürünlerinde birim fiyat negatif olmalıdır.');
  1063.             }
  1064.             return;
  1065.         }
  1067.     }
  1069.     private function resolveSalesStatus(?string $status): SalesStatus
  1070.     {
  1071.         if ($status === null) {
  1072.             return SalesStatus::PENDING;
  1073.         }
  1075.         return SalesStatus::tryFrom($status) ?? SalesStatus::PENDING;
  1076.     }
  1078.     private function shouldAffectStock(SalesStatus $status): bool
  1079.     {
  1080.         return in_array($status, [SalesStatus::COMPLETED, SalesStatus::PENDING_ITEMS], true);
  1081.     }
  1083.     /**
  1084.      * Check if returns can be created for this sale
  1085.      * Returns can only be created for:
  1086.      * 1. Sales with COMPLETED or PENDING_ITEMS status
  1087.      * 2. Sales that have at least one physical product (excluding services, trees)
  1088.      */
  1089.     private function canCreateReturnForSale(Sales $sale): bool
  1090.     {
  1091.         // Check sale status
  1092.         $saleStatus = $sale->getStatus();
  1093.         if (!$saleStatus || !in_array($saleStatus, [SalesStatus::COMPLETED, SalesStatus::PENDING_ITEMS], true)) {
  1094.             return false;
  1095.         }
  1097.         // Check if there are any physical products
  1098.         $productsSold = $sale->getProductsSolds();
  1099.         foreach ($productsSold as $productSold) {
  1100.             if (!$productSold instanceof ProductsSold) {
  1101.                 continue;
  1102.             }
  1104.             $product = $productSold->getProduct();
  1105.             if (!$product) {
  1106.                 continue;
  1107.             }
  1109.             $type = $product->getProductTypeEnum();
  1110.             if (!$this->isStockExemptProductType($type)) {
  1111.                 return true; // Found at least one physical product
  1112.             }
  1113.         }
  1115.         return false; // No physical products found
  1116.     }
  1119.     #[Route('/delete-sales/{id}', name: 'delete-sales')]
  1120.     public function delete(Request $request, $id, EntityManagerInterface $entityManager)
  1121.     {
  1122.         $sale = $entityManager->getRepository(Sales::class)->find($id);
  1123.         if (!$sale) {
  1124.             throw $this->createNotFoundException('Satış bulunamadı.');
  1125.         }
  1127.         $performedBy = $this->getUser();
  1128.         $sale->setVisible(false);
  1129.         $this->salesHistoryService->record(
  1130.             $sale,
  1131.             SalesHistoryEventType::VISIBILITY_CHANGED,
  1132.             'Satış gizlendi (soft delete).',
  1133.             ['visible' => false],
  1134.             $performedBy instanceof User ? $performedBy : null
  1135.         );
  1136.         $entityManager->persist($sale);
  1137.         $entityManager->flush();
  1138.         $this->addFlash('success', 'Satış Başarıyla silindi. Stoklar eklendi');
  1139.         return $this->redirectToRoute('app_admin_sales');
  1140.         /*
  1141.         $sale = $entityManager->getRepository(Sales::class)->find($id);
  1142.         $entityManager->beginTransaction();
  1143.         try{
  1145.             if($sale->getInvoice() != null){
  1146.                 $this->invoiceService->deleteInvoice($sale->getInvoice());
  1147.             }
  1149.             if($sale->getStatus() === SalesStatus::PENDING_ITEMS || $sale->getStatus() === SalesStatus::COMPLETED){
  1150.                 $warehouse = $sale->getWarehouse();
  1152.                 foreach ($sale->getProductsSolds() as $salesProductsDto) {
  1153.                         $productEntity = $this->productService->getEntityId($salesProductsDto->getProduct()->getId());
  1154.                         $beforeQuantity = $this->stockInfoService->getStockInfoByProductAndWarehouse($productEntity, $warehouse)->getTotalQuantity();
  1155.                         $stockTransaction = new StockTransaction();
  1156.                         $stockTransaction->setWarehouse($warehouse);
  1157.                         $stockTransaction->setProductId($productEntity);
  1158.                         $stockTransaction->setName($productEntity->getName() . " Code " . $productEntity->getCode());
  1159.                         $stockTransaction->setQuantity($salesProductsDto->getQuantity());
  1160.                         $stockTransaction->setAction("IN");
  1161.                         $stockTransaction->setDescription("Satış siliyor bu yüzden ürün stoğu EKLENİYOR");
  1162.                         $stockTransaction->setBeforeQuantity(
  1163.                             $beforeQuantity
  1164.                         );
  1165.                         $this->stockInfoService->addStock( $productEntity, $warehouse,$salesProductsDto->getQuantity());
  1166.                         $stockTransaction->setAfterQuantity(
  1167.                             $this->stockInfoService->getStockInfoByProductAndWarehouse($productEntity, $warehouse)->getTotalQuantity()
  1168.                         );
  1169.                         $stockTransaction->setSale($sale);
  1170.                         $this->entityManager->remove($salesProductsDto);
  1171.                         $this->entityManager->persist($stockTransaction);
  1172.                     }
  1174.             }else{
  1175.                 $products = $sale->getProductsSolds();
  1176.                 foreach ($products as $product){
  1177.                     $this->entityManager->remove($product);
  1178.                 }
  1179.             }
  1182.             $payments = $sale->getPayments();
  1183.             foreach ($payments as $payment){
  1184.                 $this->paymentService->deletePayment($payment);
  1185.             }
  1187.             $entityManager->remove($sale);
  1188.             $entityManager->flush();
  1189.             $entityManager->commit();
  1190.             $this->addFlash('success', 'Satış Başarıyla silindi. Stoklar eklendi');
  1191.             return $this->redirectToRoute('app_admin_sales');
  1192.         }catch (\Exception $exception){
  1193.             $entityManager->rollback();
  1194.             throw $exception;
  1195.         }
  1196.         */
  1199.     }
  1201.     #[Route('/warehouse-stocks/{warehouseId}', name: 'app_admin_warehouse_stock_information')]
  1202.     public function getStockByWarehouse(Request $request, $warehouseId)
  1203.     {
  1204.         $stocks = $this->stockService->getStocksByWarehouse($warehouseId);
  1205.         return $this->json($stocks);
  1206.     }
  1208.     // Tüm satışlar anasayfa
  1209.     #[Route('/sales/all', name: 'app_admin_sales_all')]
  1210.     public function showAll(Request $request, EntityManagerInterface $entityManager)
  1211.     {
  1212.         $warehouses = $this->warehouseService->getAll();
  1214.         return $this->render('admin/sales/allsales.html.twig', [
  1215.             'controller_name' => 'StockController',
  1216.             'warehouses' => $warehouses,
  1217.             'statuses' => SalesStatus::cases(),
  1218.             'defaultMailContent' => $this->getDefaultMailContent(),
  1219.         ]);
  1220.     }
  1222.     // Tüm satışlar ajax ile dataların gönderiliyor
  1223.     #[Route('/admin/sales/show', name: 'app_admin_sales_show')]
  1224.     public function show(Request $request, EntityManagerInterface $entityManager)
  1225.     {
  1227.         if (isset($request->get('search')['value']))
  1228.             $s = $request->get('search')['value'];
  1229.         else
  1230.             $s = '';
  1232.         $id = $request->get('id');
  1233.         if (isset($request->get('order')[0]['column']))
  1234.             $column = $request->get('order')[0]['column'];
  1235.         else
  1236.             $column = 0;
  1237.         if (isset($request->get('order')[0]['dir']))
  1238.             $dir = $request->get('order')[0]['dir'];
  1239.         else
  1240.             $dir = 'ASC';
  1241.         $startDate = $request->get('startDate');
  1242.         $finishDate = $request->get('finishDate');
  1244.         $limit = $request->get('length');
  1245.         if ($request->get('start'))
  1246.             $page = 1 + ($request->get('start') / $limit);
  1247.         else
  1248.             $page = 1;
  1249.         $warehouseid = $request->get('warehouseid');
  1250.         $statusParam = $request->get('status');
  1251.         $status = null;
  1252.         if (!empty($statusParam)) {
  1253.             try {
  1254.                 $status = SalesStatus::from($statusParam);
  1255.             } catch (\ValueError $exception) {
  1256.                 $status = null;
  1257.             }
  1258.         }
  1260.         $stocks = $this->salesService->getAllSalesPaginate($page, $limit, $warehouseid, $column, $dir, $s, $startDate, $finishDate, $status, $this->getUser());
  1261.         return new JsonResponse($this->createArrayForDataTable($stocks));
  1262.     }
  1264.     private function getPdfContentFromProforma($proformaId)
  1265.     {
  1266.         $logoPath = $this->projectDir . '/public/images/decopierrelogo.png';
  1267.         $logoDataUri = '';
  1269.         if (file_exists($logoPath)) {
  1270.             $logoBase64 = base64_encode(file_get_contents($logoPath));
  1271.             $logoDataUri = 'data:' . mime_content_type($logoPath) . ';base64,' . $logoBase64;
  1272.         }
  1274.         $sales = $this->salesServiceImpl->getEntityById($proformaId);
  1276.         if (!$sales) {
  1277.             return null; // Fatura bulunamazsa null döndür
  1278.         }
  1280.         $companyData = [
  1281.             'name' => 'DECO PIERRE ET NATURE',
  1282.             'address' => '152 ROUTE DE GRENOBLE 69800 SAINT PRIEST, France',
  1283.             'siren' => '948485271',
  1284.             'tva' => 'FR13948485271',
  1285.             'contact' => 'MATHIAS | 0652901882 | decopierreetnature@gmail.com',
  1286.             'bank_details' => [
  1287.                 'titulaire' => 'SAS FAV',
  1288.                 'bank_name' => 'BANQUE POPULAIRE',
  1289.                 'code_banque' => '16807',
  1290.                 'num_compte' => '37402602218',
  1291.                 'iban' => 'FR7616807004133740260221837',
  1292.                 'bic' => 'CCBPFRPPGRE'
  1293.             ]
  1294.         ];
  1296.         $html = $this->renderView('/admin/sales/proforma.html.twig', [
  1297.             'proforma' => $sales,
  1298.             'logo_data_uri' => $logoDataUri,
  1299.             'company' => $companyData
  1300.         ]);
  1302.         $footerHtml = $this->renderView('/admin/sales/invoice_footer.html.twig', [
  1303.             'company' => $companyData
  1304.         ]);
  1306.         $options = [
  1307.             'footer-html' => $footerHtml,
  1308.             'margin-bottom' => 30,
  1309.             'enable-local-file-access' => true,
  1310.             'encoding' => 'UTF-8',
  1311.         ];
  1313.         return [
  1314.             'html' => $html,
  1315.             'options' => $options,
  1316.         ];
  1317.     }
  1319.     private function getDefaultMailContent(): string
  1320.     {
  1321.         return MailTemplateHelper::getDefaultMailContent();
  1322.     }
  1324.     private function applyMailPlaceholders(string $mailContent, Sales $sale): string
  1325.     {
  1326.         $customer = $sale->getCustomer();
  1328.         $placeholders = [
  1329.             '[[client_name]]' => $customer ? (string) $customer->getFullName() : '',
  1330.             '[[client_email]]' => $customer && $customer->getEmail() ? (string) $customer->getEmail() : '',
  1331.             '[[client_phone]]' => $customer && $customer->getPhone() ? (string) $customer->getPhone() : '',
  1332.         ];
  1334.         foreach ($placeholders as $placeholder => $value) {
  1335.             $mailContent = str_replace($placeholder, $value ?? '', $mailContent);
  1336.         }
  1338.         return $mailContent;
  1339.     }
  1341.     private function getPdfContentFromInvoice(int $invoiceId): ?array
  1342.     {
  1343.         $logoPath = $this->projectDir . '/public/images/decopierrelogo.png';
  1344.         $logoDataUri = '';
  1346.         if (file_exists($logoPath)) {
  1347.             $logoBase64 = base64_encode(file_get_contents($logoPath));
  1348.             $logoDataUri = 'data:' . mime_content_type($logoPath) . ';base64,' . $logoBase64;
  1349.         }
  1351.         $invoice = $this->invoiceService->getEntityById($invoiceId);
  1353.         if (!$invoice) {
  1354.             return null;
  1355.         }
  1357.         $companyData = [
  1358.             'name' => 'DECO PIERRE ET NATURE',
  1359.             'address' => '152 ROUTE DE GRENOBLE 69800 SAINT PRIEST, France',
  1360.             'siren' => '948485271',
  1361.             'tva' => 'FR13948485271',
  1362.             'contact' => 'MATHIAS | 0652901882 | decopierreetnature@gmail.com',
  1363.             'bank_details' => [
  1364.                 'titulaire' => 'SAS FAV',
  1365.                 'bank_name' => 'BANQUE POPULAIRE',
  1366.                 'code_banque' => '16807',
  1367.                 'num_compte' => '37402602218',
  1368.                 'iban' => 'FR7616807004133740260221837',
  1369.                 'bic' => 'CCBPFRPPGRE'
  1370.             ]
  1371.         ];
  1373.         $html = $this->renderView('/admin/sales/invoice.html.twig', [
  1374.             'invoice' => $invoice,
  1375.             'logo_data_uri' => $logoDataUri,
  1376.             'company' => $companyData
  1377.         ]);
  1379.         $footerHtml = $this->renderView('/admin/sales/invoice_footer.html.twig', [
  1380.             'company' => $companyData
  1381.         ]);
  1383.         $options = [
  1384.             'footer-html' => $footerHtml,
  1385.             'margin-bottom' => 30,
  1386.             'enable-local-file-access' => true,
  1387.             'encoding' => 'UTF-8',
  1388.         ];
  1390.         return [
  1391.             'html' => $html,
  1392.             'options' => $options,
  1393.         ];
  1394.     }
  1396.     #[Route('/proforma/send-mail/{proformaId}', name: 'proforma_send_mail', methods: ['POST'])]
  1397.     public function sendMailToCustomer(Request $request, $proformaId, MailService $mailService)
  1398.     {
  1399.         $sale = $this->salesService->getEntityById($proformaId);
  1401.         if (!$sale) {
  1402.             return new JsonResponse(['message' => 'sale_not_found'], 404);
  1403.         }
  1405.         $data = json_decode($request->getContent(), true);
  1406.         if (json_last_error() !== JSON_ERROR_NONE || !is_array($data)) {
  1407.             $data = $request->request->all();
  1408.         }
  1410.         $recipientsRaw = $data['recipients'] ?? [];
  1411.         if (!is_array($recipientsRaw)) {
  1412.             $recipientsRaw = explode(',', (string) $recipientsRaw);
  1413.         }
  1415.         if (empty($recipientsRaw) && $sale->getCustomer() && $sale->getCustomer()->getEmail()) {
  1416.             $recipientsRaw = [$sale->getCustomer()->getEmail()];
  1417.         }
  1419.         $recipients = [];
  1420.         foreach ($recipientsRaw as $recipient) {
  1421.             $recipient = mb_strtolower(trim((string) $recipient));
  1422.             if ($recipient && filter_var($recipient, FILTER_VALIDATE_EMAIL)) {
  1423.                 $recipients[] = $recipient;
  1424.             }
  1425.         }
  1426.         $recipients = array_values(array_unique($recipients));
  1428.         if (!$recipients) {
  1429.             return new JsonResponse(['message' => 'recipient_not_found'], 400);
  1430.         }
  1432.         $mailContent = $data['content'] ?? $this->getDefaultMailContent();
  1433.         if (!$mailContent) {
  1434.             $mailContent = $this->getDefaultMailContent();
  1435.         }
  1436.         $mailContent = $this->applyMailPlaceholders($mailContent, $sale);
  1438.         $includeProforma = array_key_exists('includeProforma', $data)
  1439.             ? filter_var($data['includeProforma'], FILTER_VALIDATE_BOOLEAN)
  1440.             : true;
  1442.         $includeInvoice = array_key_exists('includeInvoice', $data)
  1443.             ? filter_var($data['includeInvoice'], FILTER_VALIDATE_BOOLEAN)
  1444.             : ($sale->getInvoice() !== null);
  1446.         $attachments = [];
  1448.         if ($includeProforma) {
  1449.             $proformaContent = $this->getPdfContentFromProforma($proformaId);
  1450.             if ($proformaContent) {
  1451.                 $proformaPath = $this->pdfService->convertAndSave(
  1452.                     $proformaContent['html'],
  1453.                     $sale->getInvoiceNumber(),
  1454.                     'proforma',
  1455.                     $proformaContent['options']
  1456.                 );
  1457.                 if ($proformaPath && file_exists($proformaPath)) {
  1458.                     $attachments[] = $proformaPath;
  1459.                 }
  1460.             }
  1461.         }
  1463.         if ($includeInvoice && $sale->getInvoice()) {
  1464.             $invoiceContent = $this->getPdfContentFromInvoice($sale->getInvoice()->getId());
  1465.             if ($invoiceContent) {
  1466.                 $invoicePath = $this->pdfService->convertAndSave(
  1467.                     $invoiceContent['html'],
  1468.                     $sale->getInvoice()->getInvoiceNumber(),
  1469.                     'invoice',
  1470.                     $invoiceContent['options']
  1471.                 );
  1472.                 if ($invoicePath && file_exists($invoicePath)) {
  1473.                     $attachments[] = $invoicePath;
  1474.                 }
  1475.             }
  1476.         }
  1478.         $subject = ($includeInvoice && $sale->getInvoice())
  1479.             ? 'Facture ' . $sale->getInvoice()->getInvoiceNumber()
  1480.             : 'Devis ' . $sale->getInvoiceNumber();
  1482.         //        dd($mailContent);
  1483.         $result = $mailService->sendAdvancedMail([
  1484.             'to' => $recipients,
  1485.             'subject' => $subject,
  1486.             'html' => $mailContent,
  1487.             'bcc' => ['arsiv@decopierrenature.com'],
  1488.             'replyTo' => 'decopierrefatih@gmail.com',
  1489.             'attachments' => array_values(array_unique($attachments)),
  1490.             'sale' => $sale,
  1491.             'senderUser' => $this->getUser(),
  1492.         ]);
  1494.         $message = $result ? 'success' : 'error';
  1496.         return new JsonResponse(['message' => $message]);
  1497.     }
  1499.     /**
  1500.      * @throws Exception
  1501.      */
  1502.     #[Route('/proforma/convert-to-invoice/{salesId}', name: 'proforma_convert_to_invoice')]
  1503.     public function convertToInvoice(int $salesId): JsonResponse
  1504.     {
  1505.         $this->entityManager->beginTransaction();
  1507.         try {
  1508.             /** @var Sales|null $sales */
  1509.             $sales = $this->entityManager->find(Sales::class, $salesId, LockMode::PESSIMISTIC_WRITE);
  1511.             if (!$sales) {
  1512.                 throw new Exception(sprintf("Proforma not found with %s id", $salesId));
  1513.             }
  1515.             if ($sales->getInvoice()) {
  1516.                 $invoiceId = $sales->getInvoice()->getId();
  1517.                 $this->entityManager->commit();
  1519.                 return new JsonResponse(
  1520.                     [
  1521.                         'success' => false,
  1522.                         'message' => 'invoice_already_exists',
  1523.                         'invoiceId' => $invoiceId,
  1524.                     ],
  1525.                     Response::HTTP_CONFLICT
  1526.                 );
  1527.             }
  1529.             $invoice = $this->invoiceService->create($sales);
  1530.             $this->entityManager->commit();
  1532.             return new JsonResponse(
  1533.                 [
  1534.                     'success' => true,
  1535.                     'invoiceId' => $invoice->getId(),
  1536.                 ],
  1537.                 Response::HTTP_CREATED
  1538.             );
  1539.         } catch (Exception $exception) {
  1540.             $this->entityManager->rollback();
  1541.             throw $exception;
  1542.         }
  1543.     }
  1545.     private function createArrayForDataTable($stocks): array
  1546.     {
  1547.         $records = [];
  1548.         $records['recordsTotal'] = $stocks->getTotalItemCount();
  1549.         $records['recordsFiltered'] = $stocks->getTotalItemCount();
  1550.         $records["data"] = [];
  1552.         /**
  1553.          * @var Sales $entity
  1554.          */
  1555.         foreach ($stocks as $entity) {
  1556.             $pdfLink = '/admin/sales/proforma/generate-pdf/' . $entity->getId();
  1557.             $printLink = '/admin/sales/proforma/preview-print/' . $entity->getId();
  1558.             $showProforma = '/admin/sales/proforma/' . $entity->getId();
  1560.             $customer = $entity->getCustomer();
  1561.             $customerName = $customer ? (string) $customer->getFullName() : '';
  1562.             $customerEmail = $customer && $customer->getEmail() ? mb_strtolower((string) $customer->getEmail(), 'UTF-8') : '';
  1563.             $customerPhone = $customer && $customer->getPhone() ? (string) $customer->getPhone() : '';
  1565.             $proformaPreviewUrl = $this->generateUrl('admin_sales_proforma_preview_print', ['salesId' => $entity->getId()]);
  1566.             $invoicePreviewUrl = $entity->getInvoice() ? $this->generateUrl('admin_sales_invoice_preview_print', ['invoiceId' => $entity->getInvoice()->getId()]) : '';
  1567.             $sendMailUrl = $this->generateUrl('proforma_send_mail', ['proformaId' => $entity->getId()]);
  1569.             $sendMailAttributes = sprintf(
  1570.                 'data-id="%s" data-sale-id="%s" data-send-url="%s" data-default-email="%s" data-customer-name="%s" data-customer-email="%s" data-customer-phone="%s" data-proforma-url="%s" data-invoice-url="%s" data-has-invoice="%s"',
  1571.                 htmlspecialchars((string) $entity->getId(), ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8'),
  1572.                 htmlspecialchars((string) $entity->getId(), ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8'),
  1573.                 htmlspecialchars($sendMailUrl, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8'),
  1574.                 htmlspecialchars($customerEmail, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8'),
  1575.                 htmlspecialchars($customerName, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8'),
  1576.                 htmlspecialchars($customerEmail, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8'),
  1577.                 htmlspecialchars($customerPhone, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8'),
  1578.                 htmlspecialchars($proformaPreviewUrl, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8'),
  1579.                 htmlspecialchars($invoicePreviewUrl, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8'),
  1580.                 $entity->getInvoice() ? '1' : '0'
  1581.             );
  1583.             $actions = sprintf(
  1584.                 '<a href="%s" target="_blank" title="Download PDF" style="margin-right: 8px;"><i class="far fa-file-pdf fa-lg" style="color: #d32f2f;"></i></a>
  1585.                         <a type="button" class="send-mail-btn" %s title="Send Mail" style="margin-right: 8px;"><i class="fas fa-mail-bulk fa-lg" style="color: #3498db;"></i></a>
  1586.                         <a href="%s" title="Print" target="_blank"><i class="fas fa-print fa-lg" style="color: #026309;"></i></a>
  1587.                         <a href="%s" title="Show" target="_blank"><i class="fas fa-eye fa-lg"></i></a>',
  1588.                 $pdfLink,
  1589.                 $sendMailAttributes,
  1590.                 $printLink,
  1591.                 $showProforma
  1592.             );
  1594.             $salesStatus = $entity->getStatus();
  1595.             $statusLabel = $salesStatus?->getLabel() ?? 'Belirtilmedi';
  1596.             $statusValue = $salesStatus?->value ?? 'UNSPECIFIED';
  1597.             $statusCell = sprintf(
  1598.                 "<span class='sales-status-badge' data-status='%s'>%s</span>",
  1599.                 htmlspecialchars($statusValue, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8'),
  1600.                 htmlspecialchars($statusLabel, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8')
  1601.             );
  1603.             $records["data"][] = [
  1604.                 $entity->getId(),
  1605.                 $entity->getInvoiceNumber(),
  1606.                 $customerName,
  1607.                 CurrencyHelper::convertToCurrency($entity->getTotalPurchasePrice()) . ' ' . $this->translator->trans('currency.symbol'),
  1608.                 $entity->getSeller()->getFullname(),
  1609.                 $entity->getInvoice() ?
  1610.                 "<a target='_blank' href='" . $this->generateUrl('admin_sales_invoice_preview_print', ['invoiceId' => $entity->getInvoice()->getId()]) . "' class='btn btn-primary btn-xs showInvoiceBtn'>" . $this->translator->trans('showInvoice') . "</a>" :
  1611.                 "<a target='_blank' data-id='" . $entity->getId() . "' class='btn btn-warning btn-xs convertToInvoiceBtn'>" . $this->translator->trans('convertToInvoice') . "</a>",
  1612.                 $entity->getSalesDate()->format('d-m-Y'),
  1613.                 $statusCell,
  1614.                 $this->getPaymentStatus($entity),
  1615.                 $actions
  1616.             ];
  1617.         }
  1619.         return $records;
  1620.     }
  1621.     private function getPaymentStatus(Sales $sales)
  1622.     {
  1623.         $paymentStatus = '';
  1624.         foreach ($sales->getPayments() as $payment) {
  1625.             if ($payment->getPaymentStatus() == 2) {
  1626.                 $paymentStatus = "TERM_SALE-" . $this->translator->trans('payment_status.term_sale');
  1627.                 break;
  1628.             }
  1629.             if ($payment->getPaymentStatus() == 1) {
  1630.                 $paymentStatus = "UNPAID-" . $this->translator->trans('payment_status.not_paid');
  1631.                 ;
  1632.                 break;
  1633.             }
  1634.             $paymentStatus = "PAID-" . $this->translator->trans('payment_status.paid');
  1635.             ;
  1637.         }
  1638.         return $paymentStatus;
  1639.     }
  1641.     // PROFORMAYI HTML SAYFASI OLARAK GÖSTERİYOR
  1642.     #[Route('/admin/sales/proforma/{salesId}', name: 'admin_sales_proforma_show')]
  1643.     public function showInvoice(Request $request, $salesId)
  1644.     {
  1645.         $logoPath = $this->projectDir . '/public/images/decopierrelogo.png';
  1646.         $logoDataUri = '';
  1648.         if (file_exists($logoPath)) {
  1649.             $logoBase64 = base64_encode(file_get_contents($logoPath));
  1650.             $logoDataUri = 'data:' . mime_content_type($logoPath) . ';base64,' . $logoBase64;
  1651.         }
  1653.         $sales = $this->salesServiceImpl->getEntityById($salesId);
  1655.         $html = $this->render('/admin/sales/proforma.html.twig', [
  1656.             'proforma' => $sales,
  1657.             'logo_data_uri' => $logoDataUri,
  1658.             'company' => [
  1659.                 'name' => 'DECO PIERRE & NATURE',
  1660.                 'address' => '152 ROUTE DE GRENOBLE 69800 SAINT PRIEST, France',
  1661.                 'siren' => '948485271',
  1662.                 'tva' => 'FR13948485271',
  1663.                 'contact' => 'MATHIAS | 0652901882 | decopierreetnature@gmail.com'
  1664.             ]
  1665.         ]);
  1667.         return $html;
  1668.     }
  1671.     // PROFORMAYI PDF OLARAK İNDİRİYOR
  1672.     #[Route('/admin/sales/proforma/generate-pdf/{salesId}', name: 'admin_sales_proforma_generate_pdf')]
  1673.     public function generatePdf(Request $request, $salesId, Pdf $knpSnappyPdf)
  1674.     {
  1675.         $logoPath = $this->projectDir . '/public/images/decopierrelogo.png';
  1676.         $logoDataUri = '';
  1678.         if (file_exists($logoPath)) {
  1679.             $logoBase64 = base64_encode(file_get_contents($logoPath));
  1680.             $logoDataUri = 'data:' . mime_content_type($logoPath) . ';base64,' . $logoBase64;
  1681.         }
  1683.         $invoice = $this->salesServiceImpl->getEntityById($salesId);
  1685.         // Şirket ve banka bilgilerini içeren bir array oluşturun
  1686.         $companyData = [
  1687.             'name' => 'DECO PIERRE ET NATURE',
  1688.             'address' => '152 ROUTE DE GRENOBLE 69800 SAINT PRIEST, France',
  1689.             'siren' => '948485271',
  1690.             'tva' => 'FR13948485271',
  1691.             'contact' => 'MATHIAS | 0652901882 | decopierreetnature@gmail.com',
  1692.             'bank_details' => [
  1693.                 'titulaire' => 'SAS FAV',
  1694.                 'bank_name' => 'BANQUE POPULAIRE',
  1695.                 'code_banque' => '16807',
  1696.                 'num_compte' => '37402602218',
  1697.                 'iban' => 'FR7616807004133740260221837',
  1698.                 'bic' => 'CCBPFRPPGRE'
  1699.             ]
  1700.         ];
  1702.         // Ana fatura içeriği için Twig render'ı
  1703.         $html = $this->renderView('/admin/sales/proforma.html.twig', [
  1704.             'proforma' => $invoice,
  1705.             'logo_data_uri' => $logoDataUri,
  1706.             'company' => $companyData
  1707.         ]);
  1709.         // Footer içeriği için Twig render'ı
  1710.         // NOT: footer.html.twig dosyasına sadece companyData'yı göndermeniz yeterlidir.
  1711.         $footerHtml = $this->renderView('/admin/sales/invoice_footer.html.twig', [
  1712.             'company' => $companyData
  1713.         ]);
  1715.         $options = [
  1716.             'footer-html' => $footerHtml,
  1717.             'margin-bottom' => 30,
  1718.             'enable-local-file-access' => true,
  1719.             'encoding' => 'UTF-8',
  1720.         ];
  1722.         return new PdfResponse(
  1723.             $knpSnappyPdf->getOutputFromHtml($html, $options),
  1724.             $invoice->getInvoiceNumber() . '.pdf',
  1725.             'inline'
  1726.         );
  1729.     }
  1732.     // PROFORMAYI PDF OLARAK KAYDEDİYOR DOSYA YOLU DÖNÜYOR
  1733.     private function createAndSavePdf(int $invoiceId): ?string
  1734.     {
  1735.         $content = $this->getPdfContentFromProforma($invoiceId);
  1736.         return $this->pdfService->convertAndSave($content['html'], $invoiceId, 'proforma', $content['options']);
  1737.     }
  1740.     // PROFORMAYI PDF OLARAK AÇAR ANCAK YAZDIRMA SEÇENEĞİ AÇILMAZ
  1741.     #[Route('/admin/sales/proforma/send-pdf/{salesId}', name: 'admin_sales_proforma_send_pdf')]
  1742.     public function sendPdf(Request $request, int $salesId): Response
  1743.     {
  1744.         $filePath = $this->createAndSavePdf($salesId);
  1746.         if (!$filePath || !file_exists($filePath)) {
  1747.             throw $this->createNotFoundException('PDF dosyası oluşturulamadı veya bulunamadı.');
  1748.         }
  1750.         $sales = $this->salesServiceImpl->getEntityById($salesId);
  1751.         $fileName = $sales ? $sales->getInvoiceNumber() . '.pdf' : 'fatura.pdf';
  1753.         $response = new BinaryFileResponse($filePath);
  1754.         $response->setContentDisposition(
  1755.             ResponseHeaderBag::DISPOSITION_INLINE,
  1756.             $fileName
  1757.         );
  1759.         $response->headers->set('Cache-Control', 'no-cache, no-store, must-revalidate');
  1760.         $response->headers->set('Pragma', 'no-cache');
  1761.         $response->headers->set('Expires', '0');
  1763.         return $response;
  1764.     }
  1766.     // PROFORMAYI PDF OLARAK AÇAR VE YAZDIRMA SEÇENEĞİ ÇIKAR
  1767.     #[Route('/admin/sales/proforma/preview-print/{salesId}', name: 'admin_sales_proforma_preview_print')]
  1768.     public function previewAndPrint(int $salesId): Response
  1769.     {
  1770.         return $this->render('/admin/sales/proforma_print_preview.html.twig', [
  1771.             'salesId' => $salesId,
  1772.             'pdf_url' => $this->generateUrl('admin_sales_proforma_send_pdf', ['salesId' => $salesId]),
  1773.         ]);
  1774.     }
  1776.     public function findColumn($rank)
  1777.     {
  1778.         $columns = [
  1779.             'id',
  1780.             'invoiceNumber',
  1781.             'salesCompany',
  1782.             'totalPurchasePrice',
  1783.             'seller',
  1784.             'salesDate'
  1785.         ];
  1786.         return $columns[$rank];
  1787.     }
  1793.     #[Route('/admin/excel')]
  1794.     public function excelDetail()
  1795.     {
  1796.         $spreadsheet = IOFactory::load($this->getParameter('kernel.project_dir') . '/public/yeni.xlsx'); // Here we are able to read from the excel file
  1797.         $row = $spreadsheet->getActiveSheet()->removeRow(1); // I added this to be able to remove the first file line
  1798.         $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true); // here, the read data is turned into an array
  1799.         dd($sheetData);
  1800.     }
  1802.     #[Route('/product-cost-detail/{id}', name: 'product_cost_detail')]
  1803.     public function getProductCost(Request $request, $id)
  1804.     {
  1805.         $warehouseId = $request->get('warehouse');
  1807.         $product = $this->productService->getEntityId($id);
  1808.         $warehouse = $this->entityManager->getRepository(Warehouse::class)->findOneBy(['id' => $warehouseId]);
  1810.         /**
  1811.          * @var CalculatorProductsCostsDTO $cost
  1812.          */
  1813.         $cost = $this->stockRepository->calculateCost($id, $warehouse);
  1814.         $stock = $this->stockInfoService->getStockInfoByProductAndWarehouse($product, $warehouse);
  1815.         $info = [
  1816.             'cost' => $cost->getAverageCostPrice(),
  1817.             'stock' => $stock->getTotalQuantity(),
  1818.             'measurement' => $product->getMeasurementUnit()?->getName(),
  1819.         ];
  1820.         return $this->json($info);
  1821.     }
  1824.     #[Route('/hesapla/kar')]
  1825.     public function calculateProfitOrDamage(EntityManagerInterface $entityManager)
  1826.     {
  1827.         $salesId = 13;
  1828.         $productId = 16;
  1829.         $quantity = 8;
  1830.         $totalPrice = 55.1;
  1831.         $sale = $this->salesService->getEntityById($salesId);
  1832.         $product = $this->productService->getEntityId($productId);
  1833.         $product->getStockTransferProducts();
  1834.         $warehouse = $sale->getWarehouse();
  1835.         $stockRepo = $entityManager->getRepository(Stock::class);
  1836.         $lastStock = $stockRepo->findOneBy(['product' => $product, 'warehouse' => $warehouse], ['createdAt' => 'desc']);
  1837.         $stockTransfer = $lastStock->getStockTransfer();
  1838.         dd($stockTransfer);
  1839.         dd($product->getStockTransferProducts());
  1840.         //        $transferProduct = $this->stockTransferService->getEntityById($sale-)
  1841.     }
  1852. }