src/Controller/DemandeAchatController.php line 127

Open in your IDE?
  1. <?php
  2. namespace App\Controller;
  4. use Doctrine\ORM\EntityManagerInterface;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\HttpFoundation\Request;
  7. use Symfony\Component\HttpFoundation\Response;
  8. use Symfony\Component\HttpFoundation\JsonResponse;
  9. use Symfony\Component\Routing\Annotation\Route;
  10. use Symfony\Component\Security\Core\Security;
  11. use App\Service\EmailService;
  12. use App\Service\DemandeAchatService;
  13. use App\Service\ExcelImportService;
  14. use App\Service\ContratCadreService;
  15. use App\Service\TranslationWriter;
  16. use PhpOffice\PhpSpreadsheet\IOFactory;
  17. use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
  18. use Twig\Environment;
  19. use Dompdf\Dompdf;
  20. use Symfony\Component\Form\Extension\Core\Type\FileType;
  21. use Symfony\Component\Form\Extension\Core\Type\TextType;
  22. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  23. use Symfony\Component\Form\Extension\Core\Type\IntegerType;
  24. use Symfony\Component\Form\Extension\Core\Type\HiddenType;
  25. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  26. use App\Form\demAchatType;
  27. use App\Form\ModifDemAchatType;
  28. use App\Form\DemAchatAddItemType;
  29. use App\Form\RegistrationFormType;
  30. use App\Form\PPMdemAchatType;
  31. use App\Entity\User;
  32. use App\Entity\Parametre;
  33. use App\Entity\NumDA;
  34. use App\Entity\demAchat;
  35. use App\Entity\RapportageDA;
  36. use App\Entity\DemAchatTemp;
  37. use App\Entity\Approb;
  38. use App\Entity\Bailleur;
  39. use App\Entity\UseBailleur;
  40. use App\Entity\CategoryCatalogue;
  41. use App\Entity\CommandeAchat;
  42. use App\Entity\Catalogue;
  43. use App\Entity\SupH;
  44. use App\Entity\Image;
  45. use App\Entity\ImageS;
  46. use App\Form\BonImageType;
  47. use App\Form\ImageSType;
  48. use App\Entity\demPaiement;
  49. use App\Entity\UserCentre;
  50. use App\Entity\CentreCout;
  51. use App\Entity\ReviewTec;
  52. use App\Entity\CategorieMarche;
  53. use App\Entity\ContratCadre;
  55. class DemandeAchatController extends AbstractController
  56. {
  57. private TranslationWriter $translationWriter;
  58. private EntityManagerInterface $em;
  59. private Security $security;
  60. private DemandeAchatService $demandeAchatService;
  61. private EmailService $emailService;
  62. private ExcelImportService $excelImportService;
  63. private Environment $twig;
  64. private ContratCadreService $contratCadreService;
  65. // Le constructeur prend tous les services en paramètre
  66. public function __construct(
  67. EntityManagerInterface $em,
  68. Security $security,
  69. DemandeAchatService $demandeAchatService,
  70. EmailService $emailService,
  71. ExcelImportService $excelImportService,
  72. Environment $twig,
  73. ContratCadreService $contratCadreService,
  74. TranslationWriter $translationWriter
  76. ) {
  77. $this->em = $em;
  78. $this->security = $security;
  79. $this->demandeAchatService = $demandeAchatService;
  80. $this->emailService = $emailService;
  81. $this->excelImportService = $excelImportService;
  82. $this->twig = $twig;
  83. $this->translationWriter = $translationWriter;
  84. $this->contratCadreService = $contratCadreService;
  85. }
  88. public function updateData(Request $request, EntityManagerInterface $em): JsonResponse
  89. {
  90. $input = $request->request->get('input');
  92. if (!$input) {
  93. return new JsonResponse(['countryList' => ''], 400);
  94. }
  96. // Requête DQL corrigée pour Symfony 5+
  97. $queryBuilder = $em->createQueryBuilder()
  98. ->select('c.designation')
  99. ->from(Catalogue::class, 'c')
  100. ->where('c.designation LIKE :input')
  101. // C'est ici que l'on modifie la clause ORDER BY pour donner la priorité aux résultats
  102. // qui commencent par la chaîne de recherche.
  103. ->orderBy('CASE WHEN c.designation LIKE :start THEN 0 ELSE 1 END', 'ASC')
  104. ->addOrderBy('c.designation', 'ASC')
  105. ->setParameter('input', '%' . $input . '%')
  106. ->setParameter('start', $input . '%');
  108. $results = $queryBuilder->getQuery()->getArrayResult();
  111. $countryList = '<ul id="matchList" class="ui-autocomplete ui-menu ui-widget ui-widget-content ui-corner-all">';
  112. foreach ($results as $result) {
  113. $matchStringBold = preg_replace('/('.$input.')/i', '<strong>$1</strong>', $result['designation']); // Replace text field input by bold one
  114. $countryList .= '<span id="li"><li class="ui-menu-item" id="'.$result['designation'].'"><span id="bol">'.$matchStringBold.'</span></li></span>'; // Create the matching list - we put maching name in the ID too
  115. }
  116. $countryList .= '</ul>';
  120. return new JsonResponse(['countryList' => $countryList]);
  122. }
  127. public function gestionDemandeAchat(Request $request): Response
  128. {
  129. $user = $this->security->getUser();
  130. $list_demAcha = [];
  131. $list_demAcha2 = [];
  133. $demAchat = new demAchat;
  135. $usersel=new User;
  136. $data = $this->demandeAchatService->getValidationData();
  137. $admin = $data['admin'];
  138. $list_demAchaall = $data['list_demAchaall'];
  139. $list_demAchavalide = $data['list_demAchavalide'];
  140. $list_demAchauser = $data['list_demAchauser'];
  141. $list_demAcharefuse = $data['list_demAcharefuse'];
  142. $list_demAcha1 = $data['list_demAcha1'];
  143. $list_demAcha3 = $data['list_demAcha3'];
  144. $list_demAcha = $data['list_demAcha'];
  145. $list_demAcha2 = $data['list_demAcha2'];
  146. $list_use = $data['list_use'];
  147. $list_useb = $data['list_useb'];
  148. $list_demAchaval = $data['list_demAchaval'];
  149. $nbdarejet = $data['nbdarejet'];
  150. $nballda = $data['nballda'];
  151. $nbdavalid = $data['nbdavalid'];
  152. $nbdanivo = $data['nbdanivo'];
  153. $nbmesda = $data['nbmesda'];
  155. $form = $this->createForm(demAchatType::class);
  156. $form3 = $this->createForm(DemAchatAddItemType::class);
  157. $form33 = $this->createForm(PPMdemAchatType::class);
  159. $form2 = $this->createFormBuilder()
  160. ->add('listnum', ChoiceType::class, [
  161. 'label' => 'Toute DA',
  162. 'choices' => $list_demAchaall,
  163. 'required' => false,
  164. 'mapped' => false,
  165. 'placeholder'=>'Toute DA',
  166. ])
  167. ->getForm();
  169. $form5 = $this->createFormBuilder()
  170. ->add('listnum3', ChoiceType::class, [
  171. 'label' => 'DA que j\'ai validé',
  172. 'choices' => $list_demAchavalide,
  173. 'required' => false,
  174. 'mapped' => false,
  175. 'placeholder'=>'choisir',
  176. ])
  177. ->getForm();
  179. $form7 = $this->createFormBuilder()
  180. ->add('listnum7', ChoiceType::class, [
  181. 'label' => 'DA rejeté',
  182. 'choices' => $list_demAcharefuse,
  183. 'required' => false,
  184. 'mapped' => false,
  185. 'placeholder'=>'choisir',
  186. ])
  187. ->getForm();
  189. $form9 = $this->createFormBuilder()
  190. ->add('listnum9', ChoiceType::class, [
  191. 'label' => 'Mes DA',
  192. 'choices' => $list_demAchauser,
  193. 'required' => false,
  194. 'mapped' => false,
  195. 'placeholder'=>'choisir',
  196. ])
  197. ->getForm();
  200. $form4 = $this->createFormBuilder()
  201. ->add('listnum2', ChoiceType::class, [
  202. 'label' => 'DA à valider',
  203. 'choices' => $list_demAcha2,
  204. 'required' => false,
  205. 'mapped' => false,
  206. 'placeholder'=>'choisir',
  207. ])
  208. ->getForm();
  210. $form1 = $this->createFormBuilder()
  211. ->add('listnum1', ChoiceType::class, [
  212. 'label' => 'DA valider non pris en charge',
  213. 'choices' => $list_demAcha1,
  214. 'required' => false,
  215. 'mapped' => false,
  216. 'placeholder'=>'DA valider non pris en charge',
  217. ])
  218. ->getForm();
  220. $form10 = $this->createFormBuilder()
  221. ->add('listnum5', ChoiceType::class, [
  222. 'label' => 'DA pris en charge',
  223. 'choices' => $list_demAcha3,
  224. 'required' => false,
  225. 'mapped' => false,
  226. 'placeholder'=>'DA pris en charge',
  227. ])
  228. ->getForm();
  230. $form6 = $this->createFormBuilder()
  231. ->add('user', ChoiceType::class, [
  232. 'label' => 'utilisateur',
  233. 'choices' => $list_use,
  234. 'required' => false,
  235. 'mapped' => false,
  236. 'placeholder'=> 'choisir un utilisateur',
  237. ])
  239. ->add('listnum4', ChoiceType::class, [
  240. 'label' => '',
  241. 'choices' => [], // Le tableau est vide
  242. 'required' => false,
  243. 'mapped' => false, // Important si ce champ n'est pas lié à une entité
  244. 'placeholder'=>'Liste DA /utilisateur',
  245. ])
  246. ->getForm();
  248. $form8 = $this->createFormBuilder()
  249. ->add('usebaille', ChoiceType::class, [
  250. 'label' => 'usebaille',
  251. 'choices' => $list_useb,
  252. 'required' => false,
  253. 'mapped' => false,
  254. 'placeholder'=>'choisir un bailleur',
  255. ])
  256. ->add('listnum6', ChoiceType::class, [
  257. 'label' => '',
  258. 'choices' => [], // Le tableau est vide
  259. 'required' => false,
  260. 'mapped' => false, // Important si ce champ n'est pas lié à une entité
  261. 'placeholder'=>'Liste DA/ bailleur',
  262. ])
  263. ->getForm();
  265. $form10 = $this->createFormBuilder()
  266. ->add('listnum5', ChoiceType::class, [
  267. 'label' => 'DA pris en charge',
  268. 'choices' => $list_demAcha3,
  269. 'required' => false,
  270. 'mapped' => false,
  271. 'placeholder'=>'DA pris en charge',
  272. ])
  273. ->getForm();
  275. $form110 = $this->createFormBuilder()
  276. ->add('listnum55', ChoiceType::class, [
  277. 'label' => ' DA valider',
  278. 'choices' => $list_demAchavalide,
  279. 'required' => false,
  280. 'mapped' => false,
  281. 'placeholder'=>'DAs valider',
  282. ])
  283. ->getForm();
  285. $form01 = $this->createFormBuilder()
  286. ->add('fiche', FileType::class, [
  287. 'required' => false,
  288. 'mapped' => false, // Cette ligne est cruciale
  289. ])
  290. ->getForm();
  291. $demacha=$this->em->getRepository(demAchat::class)->find(8745);
  293. $form200 = $this->createForm(demAchatType::class, $demacha);
  294. $form01->handleRequest( $request);
  296. if ($form01->isSubmitted() ) {
  297. $file = $form01->get('fiche')->getData();
  299. if ($file) {
  300. try {
  301. // Appel du service qui gère l'importation
  302. $this->excelImportService->importDemandesAchat($file);
  303. // $this->addFlash('success', 'Le fichier a été importé avec succès !');
  304. } catch (\Exception $e) {
  305. $this->addFlash('error', 'Erreur lors de l\'importation : ' . $e->getMessage());
  306. }
  308. }
  309. return $this->redirect( $this->generateUrl('mstopes_gestion_demande_achat'));
  312. }
  317. return $this->render('DemandeAchatVue/demandeAchat.html.twig'
  318. ,['form' => $form->createView(),'form2' => $form2->createView(),'form4' => $form4->createView(),
  319. 'form3' => $form3->createView(),'form6' => $form6->createView(),'form5' => $form5->createView(),
  320. 'form7' => $form7->createView(),'form9' => $form9->createView(),'nbmesda' => $nbmesda,
  321. 'nbdanivo' => $nbdanivo,'nbdavalid' => $nbdavalid,'nballda' => $nballda,'nbdarejet' => $nbdarejet,
  322. 'form1' => $form1->createView(),'form10' => $form10->createView(),'form8' => $form8->createView(),
  323. 'form33' => $form33->createView(),'form01' => $form01->createView(),
  324. 'form110' => $form110->createView(),'admin' => $admin,'form200' => $form200->createView(),
  327. ]
  329. );
  331. }
  334. public function ajaxListDemAchat(Request $request): Response
  335. {
  336. // On vérifie que la requête est bien une requête AJAX.
  337. // C'est un point de contrôle important pour éviter les accès directs.
  338. if ($request->isXmlHttpRequest()) {
  339. $id = $request->request->get('listnum');
  341. // On s'assure que l'ID n'est pas vide avant de continuer.
  342. if ($id !== null) {
  343. // On redirige vers la route 'liste_demachat' avec l'ID en paramètre.
  344. // Cela permet de ne pas dupliquer la logique d'affichage.
  345. return $this->redirect($this->generateUrl('liste_demachat', ['id' => $id]));
  346. }
  347. }
  349. // Si la requête n'est pas une requête AJAX ou si l'ID est manquant,
  350. // on retourne une réponse d'erreur HTTP 400 Bad Request.
  351. return new Response('Requête invalide', Response::HTTP_BAD_REQUEST);
  352. }
  354. public function listdemachat(int $id, Request $request): Response
  355. {
  356. $user = $this->security->getUser();
  357. // 1. Appelez le service pour obtenir les données
  358. $data = $this->demandeAchatService->getDemandeAchatData($id);
  360. // Si le service ne trouve pas la demande, lancez une 404
  361. if (empty($data)) {
  362. throw $this->createNotFoundException("La demande d'achat n'existe pas.");
  363. }
  364. $da_sans_cc = $data['da_sans_cc'];
  365. $utildrmedical = $data['utildrmedical'];
  366. $usedrmedical = $data['usedrmedical'];
  367. $demachats = $data['demachats'];
  368. $numach = $data['numach'];
  369. $x = $data['x'];
  370. $total3 = $data['total3'];
  371. $param = $data['param'];
  372. $usesuph = $data['usesuph'];
  373. $userr = $data['userr'];
  374. $usedscsc = $data['usedscsc'];
  375. $usedp = $data['usedp'];
  376. $uselead = $data['uselead'];
  377. $code = $data['code'];
  378. $useprojet = $data['useprojet'];
  379. $usechef1 = $data['usechef1'];
  380. $usechef2 = $data['usechef2'];
  381. $usechef3 = $data['usechef3'];
  382. $usechef4 = $data['usechef4'];
  383. $usechef5 = $data['usechef5'];
  384. $usechef6 = $data['usechef6'];
  385. $usechef7 = $data['usechef7'];
  386. $userreg = $data['userreg'];
  387. $userespacha = $data['userespacha'];
  388. $demachatrefus = $data['demachatrefus'];
  389. $v = $data['v'];
  390. $usereg = $data['usereg'];
  391. $signechefp1 = $data['signechefp1'];
  392. $signechefp2 = $data['signechefp2'];
  393. $signechefp3 = $data['signechefp3'];
  394. $signechefp4 = $data['signechefp4'];
  395. $signechefp5 = $data['signechefp5'];
  396. $signechefp6 = $data['signechefp6'];
  397. $signechefp7 = $data['signechefp7'];
  398. $nb = $data['nb'];
  399. $nomb = $data['nomb'];
  400. $suph = $data['suph'];
  401. $ub = $data['ub'];
  402. $nbch = $data['nbch'];
  403. $usebaille1 = $data['usebaille1'];
  404. $usebaille2 = $data['usebaille2'];
  405. $usebaille3 = $data['usebaille3'];
  406. $usebaille4 = $data['usebaille4'];
  407. $usebaille5 = $data['usebaille5'];
  408. $usebaille6 = $data['usebaille6'];
  409. $usebaille7 = $data['usebaille7'];
  410. $valid1 = $data['valid1'];
  411. $valid2 = $data['valid2'];
  412. $usevalid1 = $data['usevalid1'];
  413. $usevalid2 = $data['usevalid2'];
  414. $uselead1 = $data['uselead1'];
  415. $uselead2 = $data['uselead2'];
  416. $uselead3 = $data['uselead3'];
  417. $uselead4 = $data['uselead4'];
  418. $uselead5 = $data['uselead5'];
  419. $w = $data['w'];
  420. $signelead1 = $data['signelead1'];
  421. $signelead2 = $data['signelead2'];
  422. $signelead3 = $data['signelead3'];
  423. $signelead4 = $data['signelead4'];
  424. $signelead5 = $data['signelead5'];
  425. $utiltecgarag = $data['utiltecgarag'];
  426. $utiltecinfo = $data['utiltecinfo'];
  427. $utilrachat = $data['utilrachat'];
  428. $utildscsc = $data['utildscsc'];
  429. $utildscsc2 = $data['utildscsc2'];
  430. $utilrr = $data['utilrr'];
  431. $userlead = $data['userlead'];
  432. $demachatrefuleads = $data['demachatrefuleads'];
  433. $signeDP1 = $data['signeDP1'];
  434. $signeDP2 = $data['signeDP2'];
  435. $signeDP3 = $data['signeDP3'];
  436. $signeDP4 = $data['signeDP4'];
  437. $signeDP5 = $data['signeDP5'];
  438. $signeDP6 = $data['signeDP6'];
  439. $signeDP7 = $data['signeDP7'];
  440. $signeDP8 = $data['signeDP8'];
  441. $usedp1 = $data['usedp1'];
  442. $usedp2 = $data['usedp2'];
  443. $usedp3 = $data['usedp3'];
  444. $usedp4 = $data['usedp4'];
  445. $usedp5 = $data['usedp5'];
  446. $usedp6 = $data['usedp6'];
  447. $usedp7 = $data['usedp7'];
  448. $usedp8 = $data['usedp8'];
  449. $usedep = $data['usedep'];
  450. $usechefp = $data['usechefp'];
  451. $categmedical = $data['categmedical'];
  452. $cloture = $data['cloture'];
  453. // 2. Gérez les formulaires. La logique de gestion des requêtes POST reste ici.
  454. $demach = $demachats[0]; // Récupérez l'objet principal
  457. $form10 = $this->createFormBuilder(new demAchat())
  458. ->add('tva', ChoiceType::class, ['choices' => ['0' => 0, '5' => 5, '15' => 15, '18' => 18]])
  459. ->getForm();
  462. /* $form20 = $this->createForm(demAchatType::class, $demach);
  463. $form20= $this->createFormBuilder()
  464. ->add('images', ImageSType::class,['required' => false, ])
  465. ->getForm();
  467. // Gérez l'envoi de formulaire si la méthode est POST
  468. $form20->handleRequest($request);
  470. if ($form20->isSubmitted() && $form20->isValid()) {
  473. $this->em->flush();
  474. return $this->redirectToRoute('mstopes_gestion_demande_achat');
  476. }*/
  479. return $this->render('DemandeAchatVue/show.html.twig'
  480. ,[
  481. 'cloture' => $cloture,
  482. 'da_sans_cc' => $da_sans_cc,
  483. 'utildrmedical' => $utildrmedical,
  484. 'categmedical' => $categmedical,
  485. 'usedrmedical' => $usedrmedical,
  486. 'demachats' => $demachats,
  487. 'numach' => $numach,
  488. 'user' => $user,
  489. 'id' => $id,
  490. 'x' => $x,
  491. 'total3' => $total3,
  492. 'param' => $param,
  493. 'usesuph' => $usesuph,
  494. 'userr' => $userr,
  495. 'usedscsc' => $usedscsc,
  496. 'usedp' => $usedp,
  498. 'uselead' => $uselead,
  499. 'usechefp' => $usechefp,
  500. 'usedep' => $usedep,
  501. 'code' => $code,
  502. 'useprojet' => $useprojet,
  503. 'usechef1' => $usechef1,
  504. 'usechef2' => $usechef2,
  505. 'usechef3' => $usechef3,
  506. 'userreg' => $userreg,
  507. 'usechef4' => $usechef4,
  508. 'usechef5' => $usechef5,
  509. 'usechef6' => $usechef6,
  510. 'userespacha' => $userespacha,
  511. 'usereg' => $usereg,
  512. 'signechefp1' => $signechefp1,
  513. 'signechefp2' => $signechefp2,
  514. 'signechefp3' => $signechefp3,
  515. 'signechefp4' => $signechefp4,
  516. 'signechefp5' => $signechefp5,
  517. 'signechefp6' => $signechefp6,
  518. 'v' => $v,
  519. 'demachatrefus' => $demachatrefus,
  520. 'nb' => $nb,
  521. 'form10' => $form10->createView(),
  522. 'nomb' => $nomb,
  523. 'suph' => $suph,
  524. 'ub' => $ub,
  525. 'nbch' => $nbch,
  526. //'form20' => $form20->createView(),
  527. 'signechefp7' => $signechefp7,
  528. 'usechef7' => $usechef7,
  529. 'usebaille1' => $usebaille1,
  530. 'usebaille2' => $usebaille2,
  531. 'usebaille3' => $usebaille3,
  532. 'usebaille4' => $usebaille4,
  533. 'usebaille5' => $usebaille5,
  534. 'usebaille6' => $usebaille6,
  535. 'usebaille7' => $usebaille7
  536. ,'valid1' => $valid1,
  537. 'valid2' => $valid2,
  538. 'usevalid1' => $usevalid1,
  539. 'usegarage' => $usevalid2,
  540. 'uselead1' => $uselead1,
  541. 'uselead2' => $uselead2,
  542. 'uselead3' => $uselead3,
  543. 'w' => $w,
  544. 'signelead1' => $signelead1,
  545. 'signelead2' => $signelead2,
  546. 'signelead3' => $signelead3,
  547. 'signelead4' => $signelead4,
  548. 'signelead5' => $signelead5,
  549. 'utiltecgarag' => $utiltecgarag,
  550. 'utiltecinfo' => $utiltecinfo,
  551. 'utilrachat' => $utilrachat,
  552. 'utildscsc' => $utildscsc,
  553. 'utildscsc2' => $utildscsc2,
  554. 'utilrr' => $utilrr,
  555. 'uselead4' => $uselead4,
  556. 'uselead5' => $uselead5,
  557. 'userlead' => $userlead,
  558. 'demachatrefuleads' => $demachatrefuleads,
  559. 'signeDP1' => $signeDP1,
  560. 'signeDP2' => $signeDP2,
  561. 'signeDP3' => $signeDP3,
  562. 'signeDP4' => $signeDP4,
  563. 'signeDP5' => $signeDP5,
  564. 'signeDP6' => $signeDP6,
  565. 'signeDP7' => $signeDP7,
  566. 'signeDP8' => $signeDP8,
  567. 'usedp1' => $usedp1,
  568. 'usedp2' => $usedp2,
  569. 'usedp3' => $usedp3,
  570. 'usedp4' => $usedp4,
  571. 'usedp5' => $usedp5,
  572. 'usedp6' => $usedp6,
  573. 'usedp7' => $usedp7,
  574. 'usedp8' => $usedp8
  575. ]
  576. );
  577. }
  578. public function addfileda(int $id, Request $request): Response
  579. {
  583. //$user = $this->security->getUser();
  584. $demacha=$this->em->getRepository(demAchat::class)->find($id);
  586. $form = $this->createForm(demAchatType::class, $demacha);
  589. // Gérez l'envoi de formulaire si la méthode est POST
  590. $form->handleRequest($request);
  592. if ($form->isSubmitted() ) {
  595. $this->em->flush();
  596. return $this->redirectToRoute('mstopes_gestion_demande_achat');
  598. }
  601. return $this->render('DemandeAchatVue/addfileda.html.twig'
  602. ,[
  603. 'id' => $id,'form' => $form->createView()]
  604. );
  605. }
  608. public function uploadImageAndLink(Request $request): JsonResponse
  609. {
  610. // 1. Récupérer l'ID du demAchat à partir des données POST de FormData
  611. // JQuery doit inclure 'demAchatId' dans le FormData.
  612. $demAchatId = $request->request->get('demAchatId');
  614. if (!$demAchatId) {
  615. return new JsonResponse(['error' => 'Missing demAchat ID'], 400);
  616. }
  618. /** @var demAchat $demAchat */
  619. $demAchat = $this->em->getRepository(demAchat::class)->find($demAchatId);
  621. if (!$demAchat) {
  622. return new JsonResponse(['error' => 'DemAchat not found'], 404);
  623. }
  625. /** @var UploadedFile $file */
  626. $file = $request->files->get('image'); // 'image' est le nom du champ file
  628. if (!$file) {
  629. return new JsonResponse(['error' => 'No file uploaded'], 400);
  630. }
  632. // --- Logique d'upload et de persistance de ImageS ---
  633. /*
  634. $imageS = new Image();
  635. $fileName = md5(uniqid()) . '.' . $file->guessExtension();
  637. try {
  638. $file->move($imageS->getUploadRootDir(), $fileName);
  639. } catch (\Exception $e) {
  640. return new JsonResponse(['error' => 'File move failed'], 500);
  641. }
  643. $imageS->setUrl($fileName);
  644. $imageS->setAlt($file->getClientOriginalName());
  646. // 2. Lier l'ImageS au demAchat et persister/flusher
  648. // Si un ancien fichier existait, vous pouvez le supprimer ici.
  649. if ($oldImage = $demAchat->getImage()) {
  650. // Logique de suppression de l'ancien fichier/entité ImageS (Optionnel)
  651. $oldImagePath = $oldImage->getUploadRootDir() . '/' . $oldImage->getUrl();
  652. if (file_exists($oldImagePath)) {
  653. unlink($oldImagePath);
  654. }
  655. $this->em->remove($oldImage);
  656. }
  658. $demAchat->setImage($imageS); // Lier la nouvelle image
  660. $this->em->persist($imageS);
  661. $this->em->flush(); // Le flush va enregistrer ImageS et mettre à jour demAchat
  662. */
  663. // --- Fin Logique d'upload ---
  665. return new JsonResponse([
  666. 'success' => true,
  667. //'imageId' => $imageS->getId(),
  668. 'message' => 'Image uploaded and linked successfully to DemAchat ID: ' . $demAchatId,
  669. ]);
  670. }
  671. public function listedatemp(int $id, Request $request): Response
  672. {
  675. $datemps=null;
  676. $user = $this->security->getUser();
  677. $datemps=$this->em->getRepository(DemAchatTemp::class)->findDemandeAchatPerso($id);
  678. $montant=0; $nb=count($datemps);
  679. if($datemps!==null){
  680. foreach($datemps as $datemp)
  681. {
  682. $montant= $montant+$datemp->getPrixU()*$datemp->getQuantDemande();
  684. }
  685. $datemps[0]->setNumOrdre($montant);
  686. $this->em->flush();
  687. }
  689. return $this->render('DemandeAchatVue/listedatemp.html.twig'
  690. ,[
  691. 'demachats' => $datemps,'nb' => $nb]
  692. );
  693. }
  694. public function ajouterachattemp(Request $request): Response
  695. {
  698. $demAch = new DemAchatTemp;
  699. $user = $this->security->getUser();
  704. $demachas=$this->em->getRepository(DemAchatTemp::class)->findAll();
  705. $obje = $request->request->get('obje');
  706. $idcentreCout = $request->request->get('centreCout');
  707. $idnomprojet = $request->request->get('bailleur');
  708. $descrip = $request->request->get('descrip');
  710. $quantDemand = $request->request->get('quantDemand');
  711. $delais = $request->request->get('delais');
  712. $region = $request->request->get('region');
  713. $prixUnit = $request->request->get('prixUnit');
  714. $iddesignrech = $request->request->get('iddesignrech');
  716. if($region ==1){$region="Bamako";}
  717. elseif($region ==2){$region="Segou";}
  718. elseif($region ==3){$region="Mopti";}
  719. elseif($region ==4){$region="Sikasso";}
  720. elseif($region ==5){$region="Koulikoro";}
  722. $nomprojet= $this->em->getRepository(Bailleur::class)->find($idnomprojet);
  723. $cecout= $this->em->getRepository(CentreCout::class)->find($idcentreCout);
  724. if($iddesignrech!=null)
  725. $designrech= $this->em->getRepository(Catalogue::class)->findOneByDesignation($iddesignrech);
  726. else
  727. $designrech=null;
  729. $num=1;
  730. if($demachas!==null){
  732. foreach($demachas as $demacha)
  733. {
  734. if($demacha->getNumDemandeAchat()>$num)
  735. $num=$demacha->getNumDemandeAchat();
  737. }
  738. $num=$num+1;
  739. }
  742. $demAch->setCentreCout($cecout->getLibele());
  743. $demAch->setCostcenter($cecout);
  744. $demAch->setNombaille($nomprojet);
  746. $demAch->setNomProjet($nomprojet->getLibele());
  747. $demAch->setQuantDemande($quantDemand);
  748. $demAch->setObjet($obje);
  750. $demAch->setRegion($region);
  751. $demAch->setDescription($descrip);
  754. if($designrech != null){
  756. $demAch->setDesignation($designrech->getDesignation());
  757. $demAch->setCatalogue($designrech);
  758. $demAch->setPrixU($prixUnit);
  759. }
  760. else {
  761. $demAch->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  762. }
  765. $dat=date('Y-m-d H:i:s');
  766. $demAch->setDateSoumis(new \DateTime($dat));
  767. $demAch->setUser($user);
  768. $demAch->setNumDemandeAchat($num);
  769. //$demAch->setNumOrdre(1);
  771. $demAch->setDelais($delais);
  772. $this->em->persist($demAch);
  774. $this->em->flush();
  779. return $this->redirectToRoute('liste_da_temp', ['id' => $num]);
  786. }
  787. public function ajoutdesigndatemp(Request $request): Response
  788. {
  790. $demAch = new DemAchatTemp;
  791. $user = $this->security->getUser();
  793. $demtempuses = $this->em->getRepository(DemAchatTemp::class)->findByUser( $user);
  794. $demtemp = end($demtempuses);
  798. $idbailleur = $request->request->get('bailleur');
  799. $descrip = $request->request->get('descrip');
  800. $idcentreCout = $request->request->get('centreCout');
  801. $quantDemand = $request->request->get('quantDemand');
  804. $prixUnit = $request->request->get('prixUnit');
  805. $iddesignrech = $request->request->get('iddesignrech');
  807. $nomprojet = $this->em->getRepository(Bailleur::class)->find($idbailleur);
  808. $centrecout = $this->em->getRepository(CentreCout::class)->find($idcentreCout);
  809. if($iddesignrech!=null)
  810. $designrech= $this->em->getRepository(Catalogue::class)->findOneByDesignation($iddesignrech);
  811. else
  812. $designrech=null;
  813. $num=$demtemp->getNumDemandeAchat();
  816. $demAch->setCentreCout($centrecout->getLibele());
  817. $demAch->setCostcenter($centrecout);
  818. $demAch->setNomProjet($nomprojet->getLibele());
  821. $demAch->setNombaille($nomprojet);
  822. $demAch->setRegion($demtemp->getRegion());
  823. $demAch->setQuantDemande($quantDemand);
  824. $demAch->setObjet($demtemp->getObjet());
  825. $demAch->setDescription($descrip);
  828. if($designrech != null){
  830. $demAch->setDesignation($designrech->getDesignation());
  831. $demAch->setCatalogue($designrech);
  832. $demAch->setPrixU($prixUnit);
  833. }
  834. else {
  835. $demAch->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  836. }
  838. $dat=date('Y-m-d H:i:s');
  839. $demAch->setDateSoumis(new \DateTime($dat));
  840. $demAch->setUser($user);
  841. $demAch->setNumDemandeAchat($num);
  842. $demAch->setNumOrdre(1);
  844. $demAch->setDelais($demtemp->getDelais());
  845. $this->em->persist($demAch);
  846. $this->em->flush();
  851. return $this->redirectToRoute('liste_da_temp', ['id' => $num]);
  860. }
  861. //creer DA sans le centre de cout
  863. public function ajaxadatemp(Request $request): Response
  864. {
  865. $demAch = new DemAchatTemp;
  866. $user = $this->security->getUser();
  871. $demachas=$this->em->getRepository(DemAchatTemp::class)->findAll();
  872. $obje = $request->request->get('obje');
  874. $descrip = $request->request->get('descrip');
  875. $region = $request->request->get('region');
  876. $baille2 = $request->request->get('baille2');
  877. $quantDemand = $request->request->get('quantDemand');
  879. $prixUnit = $request->request->get('prixUnit');
  880. $iddesignrech = $request->request->get('iddesignrech');
  882. $nomprojet= $this->em->getRepository(Bailleur::class)->find($baille2);
  884. if($iddesignrech!=null)
  885. $designrech= $this->em->getRepository(Catalogue::class)->findOneByDesignation($iddesignrech);
  886. else
  887. $designrech=null;
  889. $num=1;
  890. if($demachas!=null){
  892. foreach($demachas as $demacha)
  893. {
  894. if($demacha->getNumDemandeAchat()>$num)
  895. $num=$demacha->getNumDemandeAchat();
  897. }
  898. $num=$num+1;
  899. }
  902. $demAch->setQuantDemande($quantDemand);
  903. $demAch->setObjet($obje);
  904. $demAch->setNombaille($nomprojet);
  905. $demAch->setNomProjet($nomprojet->getLibele());
  906. $demAch->setDescription($descrip);
  907. $demAch->setRegion($region);
  909. if($designrech !=null ){
  910. if($designrech[0]->getId()!=749){
  911. $demAch->setDesignation($designrech[0]->getDesignation());
  912. $demAch->setPrixU($prixUnit);
  913. $demAch->setCatalogue($designrech[0]);
  914. }
  915. else
  916. $demAch->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  918. }
  919. if($designrech==null )
  920. $demAch->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  924. $demAch->setUser($user);
  925. $demAch->setNumDemandeAchat($num);
  926. $demAch->setNumOrdre(1);
  930. $this->em->persist($demAch);
  931. $this->em->flush();
  936. return $this->redirectToRoute('liste_da_temp', ['id' => $num]);
  943. }
  945. public function ajaxajoutdatempAction()
  946. {
  947. $request = $this->container->get('request');
  948. $em = $this->getDoctrine()->getEntityManager();
  950. $demAch = new demAchatTemp;
  954. $user = $this->container->get('security.context')->getToken()->getUser();
  955. $demtempuses=$this->em->getRepository(DemAchatTemp::class)->selectdemuser($user);
  956. $demtemp=end($demtempuses);
  961. $descrip = $request->request->get('descrip');
  962. $obje = $request->request->get('obje');
  963. $quantDemand = $request->request->get('quantDemand');
  964. $idbailleur = $request->request->get('baille2');
  966. $prixUnit = $request->request->get('prixUnit');
  967. $iddesignrech = $request->request->get('iddesignrech');
  968. $designrech=$em->getRepository('mstopeIntranetBundle:Catalogue')->findByDesignation($iddesignrech);
  969. $nomprojet=$em->getRepository('mstopeIntranetBundle:Bailleur')->find($idbailleur);
  970. $num=$demtemp->getNumDemandeAchat();
  972. $demAch->setQuantDemande($quantDemand);
  973. $demAch->setObjet($demtemp->getObjet());
  974. $demAch->setRegion($demtemp->getRegion());
  975. $demAch->setDescription($descrip);
  977. if(isset($designrech)){
  978. if($designrech[0]->getId()!=749){
  979. $demAch->setDesignation($designrech[0]->getDesignation());
  980. $demAch->setCatalogue($designrech[0]);}
  982. else
  983. $demAch->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  984. }
  985. if($designrech==null )
  986. $demAch->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  988. $demAch->setPrixU($prixUnit);
  989. $demAch->setNomProjet($nomprojet->getLibele());
  990. $demAch->setNombaille($nomprojet);
  991. $demAch->setUser($user);
  992. $demAch->setNumDemandeAchat($num);
  993. $demAch->setNumOrdre(1);
  996. $em->persist($demAch);
  997. $em->flush();
  1001. //return $this->redirect( $this->generateUrl('mstopes_gestion_demande_achat'));
  1002. return $this->redirect( $this->generateUrl('liste_da_temp', array('id' => $num)));
  1011. }
  1014. public function daenvoyer(Request $request): Response
  1015. {
  1016. $user = $this->security->getUser();
  1017. $numero = $request->request->get('num');
  1018. $datemps=$this->em->getRepository(DemAchatTemp::class)->findDemandeAchatPerso($numero);
  1020. $numda = $this->em->getRepository(NumDA::class)->find(1);
  1021. $num=$numda->getNum()+1;
  1022. $total=0;$total3=0;
  1023. $contratCadreSelectionne = null;
  1024. $presenceLigneSansCC = false;
  1025. foreach($datemps as $datemp)
  1026. {
  1027. $numtemp= $datemp->getNumDemandeAchat();
  1028. $achat = new demAchat; $raport= new RapportageDA;
  1030. $achat->setDesignation($datemp->getDesignation());
  1031. $achat->setPrixU($datemp->getPrixU());
  1032. $achat->setCentreCout($datemp->getCentreCout());
  1033. $achat->setNomProjet($datemp->getNomProjet());
  1034. $achat->setNombaille($datemp->getNombaille());
  1035. $achat->setCostcenter($datemp->getCostcenter());
  1036. $achat->setCatalogue($datemp->getCatalogue());
  1037. $achat->setObjet($datemp->getObjet());
  1038. $achat->setRegion($datemp->getRegion());
  1039. $achat->setDescription($datemp->getDescription());
  1040. $achat->setUser($datemp->getUser());
  1041. $achat->setNomProjet($datemp->getNomProjet());
  1044. $achat->setQuantDemande($datemp->getQuantDemande());
  1045. $achat->setResteACommander($datemp->getQuantDemande());
  1046. $achat->setDelais($datemp->getDelais());
  1048. $achat->setNumOrdre(1);
  1049. $dat=date('Y-m-d H:i:s');
  1050. $achat->setDateSoumis(new \DateTime($dat));
  1052. // =====================================================
  1053. // GESTION AUTOMATIQUE CONTRAT-CADRE
  1054. // =====================================================
  1056. $montantLigne =
  1057. (float)$datemp->getPrixU()
  1058. * (float)$datemp->getQuantDemande();
  1060. $contratCadre = null;
  1062. $catalogue = $datemp->getCatalogue();
  1064. $categorieCatalogue = $catalogue
  1065. ? $catalogue->getCategorycatalogue()
  1066. : null;
  1068. if ($categorieCatalogue) {
  1070. // ManyToMany :
  1071. // CategoryCatalogue -> CategoriesMarche
  1073. $categoriesMarche =
  1074. $categorieCatalogue->getCategoriesMarche();
  1076. if (!$categoriesMarche->isEmpty()) {
  1078. foreach ($categoriesMarche as $categorieMarche) {
  1080. $contrats =
  1081. $this->contratCadreService
  1082. ->listerDisponiblesPourDA(
  1083. $categorieMarche->getId(),
  1084. $montantLigne
  1085. );
  1087. // premier contrat compatible
  1088. if (!empty($contrats)) {
  1090. $contratCadre = $contrats[0];
  1091. break;
  1092. }
  1093. }
  1094. }
  1095. }
  1097. // =====================================================
  1098. // CONTROLE COHERENCE DA
  1099. // =====================================================
  1102. // contrat trouvé
  1103. if ($contratCadre) {
  1105. // rattachement DA -> ContratCadre
  1106. $achat->setContratCadre($contratCadre);
  1107. $achat->setStatutContratCadree(demAchat::CC_SUGGERE);
  1111. // réservation budget
  1112. $montantReserve =
  1113. (float)$contratCadre->getMontantReserve();
  1115. $contratCadre->setMontantReserve(
  1116. (string)($montantReserve + $montantLigne)
  1117. );
  1119. $this->em->persist($contratCadre);
  1120. }
  1123. $numda->setNum($num);
  1124. $achat->setNumDemandeAchat($num);
  1125. $this->em->persist($achat);
  1126. $this->em->remove($datemp);
  1127. $raport->setDateSoumis(new \DateTime($dat));
  1128. $raport->setDemAchat($achat);
  1129. $this->em->persist($raport);
  1130. $this->em->flush();
  1134. if (!empty($datemp->getDescription()) && $datemp->getDescription() !== "undefined" &&(trim($datemp->getDescription()) !== ""))
  1135. {// 🔥 2. Sauvegarde traductions FR
  1136. $this->translationWriter->create
  1137. (
  1138. 'demAchat',
  1139. $achat->getId(),
  1140. 'description',
  1141. $achat->getDescription()
  1142. );
  1143. }
  1144. }
  1146. $this->em->refresh($achat);
  1148. // 🔥 2. Sauvegarde traductions FR
  1149. $this->translationWriter->create(
  1150. 'demAchat',
  1151. $achat->getId(),
  1152. 'objet',
  1153. $achat->getObjet()
  1154. );
  1155. $this->em->flush();
  1160. // return $this->redirectToRoute('liste_da_temp', ['id' => $numero]);
  1161. return $this->redirect( $this->generateUrl('mstopes_gestion_demande_achat'));
  1163. }
  1166. //ajout article apres creation de la DA
  1168. public function ajaxajoutdesignachat(Request $request)
  1169. {
  1170. if (!$request->isXmlHttpRequest()) {
  1172. return new JsonResponse([
  1173. 'error' => 'Invalid request'
  1174. ], 400);
  1175. }
  1177. $user = $this->getUser();
  1179. $id = $request->request->get('listnum');
  1180. $id2 = $request->request->get('listnum2');
  1181. $id3 = $request->request->get('listnum9');
  1182. $id4 = $request->request->get('listnum4');
  1183. $id5 = $request->request->get('listnum3');
  1184. $id6 = $request->request->get('listnum7');
  1185. $id7 = $request->request->get('listnum1');
  1186. $id8 = $request->request->get('listnum5');
  1188. $idcentreCout = $request->request->get('centreCout');
  1189. $idbailleur = $request->request->get('bailleur');
  1191. $quantDemand = (float)$request->request->get('quantDemand');
  1192. $prixUni = (float)$request->request->get('prixUni');
  1194. $descrip = $request->request->get('descrip');
  1195. $designation = $request->request->get('designation');
  1197. // =====================================================
  1198. // Catalogue
  1199. // =====================================================
  1201. $design = $this->em
  1202. ->getRepository(Catalogue::class)
  1203. ->findOneBy([
  1204. 'designation' => $designation
  1205. ]);
  1207. $bailleur = $this->em
  1208. ->getRepository(Bailleur::class)
  1209. ->find($idbailleur);
  1211. $centrecout = $this->em
  1212. ->getRepository(CentreCout::class)
  1213. ->find($idcentreCout);
  1215. // =====================================================
  1216. // Demande principale
  1217. // =====================================================
  1219. $ids = [$id, $id2, $id3, $id4, $id5, $id6, $id7, $id8];
  1221. $demacha = null;
  1223. foreach ($ids as $oneId) {
  1225. if ($oneId) {
  1227. $demacha = $this->em
  1228. ->getRepository(DemAchat::class)
  1229. ->find($oneId);
  1231. if ($demacha) {
  1232. break;
  1233. }
  1234. }
  1235. }
  1237. if (!$demacha) {
  1239. return new JsonResponse([
  1240. 'message' =>
  1241. "Ajout impossible : demande introuvable"
  1242. ], 400);
  1243. }
  1245. // =====================================================
  1246. // Sécurité logique
  1247. // =====================================================
  1249. if (($id2 && $id) || ($id3 && $id)) {
  1251. return new JsonResponse([
  1252. 'message' =>
  1253. "Ajout non effectué : veuillez actualiser la page"
  1254. ], 400);
  1255. }
  1257. // =====================================================
  1258. // Création ligne DA
  1259. // =====================================================
  1261. $demAch = new demAchat();
  1263. if ($design) {
  1265. $demAch->setDesignation($designation);
  1267. $demAch->setCatalogue($design);
  1269. } else {
  1271. $demAch->setDesignation(
  1272. 'Produit introuvable dans le catalogue'
  1273. );
  1274. }
  1276. $demAch->setPrixU($prixUni);
  1278. $demAch->setCentreCout(
  1279. $centrecout?->getLibele()
  1280. );
  1282. $demAch->setCostcenter($centrecout);
  1284. $demAch->setNombaille($bailleur);
  1286. $demAch->setNomProjet(
  1287. $bailleur?->getLibele()
  1288. );
  1290. $demAch->setQuantDemande($quantDemand);
  1292. $demAch->setDelais(
  1293. $demacha->getDelais()
  1294. );
  1296. $demAch->setObjet(
  1297. $demacha->getObjet()
  1298. );
  1300. if (
  1301. !empty($descrip)
  1302. &&
  1303. $descrip !== "undefined"
  1304. ) {
  1306. $demAch->setDescription($descrip);
  1307. }
  1309. $demAch->setRegion(
  1310. $demacha->getRegion()
  1311. );
  1313. $demAch->setNumOrdre(1);
  1315. $demAch->setUser($user);
  1317. $demAch->setNumDemandeAchat(
  1318. $demacha->getNumDemandeAchat()
  1319. );
  1321. $demAch->setDateSoumis(new \DateTime());
  1323. // =====================================================
  1324. // GESTION CONTRAT CADRE
  1325. // =====================================================
  1327. $contratCadre = null;
  1329. $montantLigne =
  1330. $prixUni * $quantDemand;
  1332. if (
  1333. $design
  1334. &&
  1335. $design->getCategorycatalogue()
  1336. ) {
  1338. $categorieCatalogue =
  1339. $design->getCategorycatalogue();
  1341. foreach (
  1342. $categorieCatalogue->getCategoriesMarche()
  1343. as $categorieMarche
  1344. ) {
  1346. $contrats =
  1347. $this->contratCadreService
  1348. ->listerDisponiblesPourDA(
  1349. $categorieMarche->getId(),
  1350. $montantLigne
  1351. );
  1353. if (!empty($contrats)) {
  1355. $contratCadre = $contrats[0];
  1357. break;
  1358. }
  1359. }
  1360. }
  1362. // =====================================================
  1363. // Affectation contrat + réservation
  1364. // =====================================================
  1366. if ($contratCadre) {
  1368. $demAch->setContratCadre(
  1369. $contratCadre
  1370. );
  1372. $demAch->setStatutContratCadree(
  1373. demAchat::CC_SUGGERE
  1374. );
  1376. // réservation
  1377. $reserve =
  1378. (float)$contratCadre->getMontantReserve();
  1380. $contratCadre->setMontantReserve(
  1381. (string)($reserve + $montantLigne)
  1382. );
  1384. $this->em->persist($contratCadre);
  1385. }
  1387. // =====================================================
  1388. // Save
  1389. // =====================================================
  1391. $this->em->persist($demAch);
  1393. $this->em->flush();
  1395. $this->em->refresh($demAch);
  1397. // =====================================================
  1398. // Traduction description
  1399. // =====================================================
  1401. if (
  1402. !empty($descrip)
  1403. &&
  1404. $descrip !== "undefined"
  1405. &&
  1406. trim($descrip) !== ""
  1407. ) {
  1409. $this->translationWriter->create(
  1410. 'demAchat',
  1411. $demAch->getId(),
  1412. 'description',
  1413. $demAch->getDescription()
  1414. );
  1416. $this->em->flush();
  1417. }
  1419. // =====================================================
  1420. // Retour
  1421. // =====================================================
  1423. return $this->redirect(
  1424. $this->generateUrl(
  1425. 'liste_demachat',
  1426. [
  1427. 'id' => $demacha->getId()
  1428. ]
  1429. )
  1430. );
  1431. }
  1432. public function downloadfileDA(int $id_ap):Response
  1433. {
  1436. $img = $this->em->getRepository(ImageS::class)->find($id_ap);
  1439. $fichier = $img->getAlt();
  1440. $chemin =$img->getUploadRootDir().'/';
  1442. $response = new Response();
  1443. $response->setContent(file_get_contents($chemin.$fichier));
  1444. $response->headers->set('Content-Type', 'application/force-download');
  1445. $response->headers->set('Content-disposition', 'filename='.$fichier);
  1447. return $response;
  1452. }
  1454. public function imprimdemachat(int $id, Request $request): Response
  1455. {
  1456. $user = $this->security->getUser();
  1457. // 1. Appelez le service pour obtenir les données
  1458. $data = $this->demandeAchatService->getDemandeAchatData($id);
  1460. // Si le service ne trouve pas la demande, lancez une 404
  1461. if (empty($data)) {
  1462. throw $this->createNotFoundException("La demande d'achat n'existe pas.");
  1463. }
  1464. $demachats = $data['demachats'];
  1465. $numach = $data['numach'];
  1466. $x = $data['x'];
  1467. $total3 = $data['total3'];
  1468. $param = $data['param'];
  1469. $usesuph = $data['usesuph'];
  1470. $userr = $data['userr'];
  1471. $usedscsc = $data['usedscsc'];
  1472. $usedp = $data['usedp'];
  1473. $uselead = $data['uselead'];
  1474. $code = $data['code'];
  1475. $useprojet = $data['useprojet'];
  1476. $usechef1 = $data['usechef1'];
  1477. $usechef2 = $data['usechef2'];
  1478. $usechef3 = $data['usechef3'];
  1479. $usechef4 = $data['usechef4'];
  1480. $usechef5 = $data['usechef5'];
  1481. $usechef6 = $data['usechef6'];
  1482. $usechef7 = $data['usechef7'];
  1483. $userreg = $data['userreg'];
  1484. $userespacha = $data['userespacha'];
  1485. $demachatrefus = $data['demachatrefus'];
  1486. $v = $data['v'];
  1487. $usereg = $data['usereg'];
  1488. $signechefp1 = $data['signechefp1'];
  1489. $signechefp2 = $data['signechefp2'];
  1490. $signechefp3 = $data['signechefp3'];
  1491. $signechefp4 = $data['signechefp4'];
  1492. $signechefp5 = $data['signechefp5'];
  1493. $signechefp6 = $data['signechefp6'];
  1494. $signechefp7 = $data['signechefp7'];
  1495. $nb = $data['nb'];
  1496. $nomb = $data['nomb'];
  1497. $suph = $data['suph'];
  1498. $ub = $data['ub'];
  1499. $nbch = $data['nbch'];
  1500. $usebaille1 = $data['usebaille1'];
  1501. $usebaille2 = $data['usebaille2'];
  1502. $usebaille3 = $data['usebaille3'];
  1503. $usebaille4 = $data['usebaille4'];
  1504. $usebaille5 = $data['usebaille5'];
  1505. $usebaille6 = $data['usebaille6'];
  1506. $usebaille7 = $data['usebaille7'];
  1507. $valid1 = $data['valid1'];
  1508. $valid2 = $data['valid2'];
  1509. $usevalid1 = $data['usevalid1'];
  1510. $usevalid2 = $data['usevalid2'];
  1511. $uselead1 = $data['uselead1'];
  1512. $uselead2 = $data['uselead2'];
  1513. $uselead3 = $data['uselead3'];
  1514. $uselead4 = $data['uselead4'];
  1515. $uselead5 = $data['uselead5'];
  1516. $w = $data['w'];
  1517. $signelead1 = $data['signelead1'];
  1518. $signelead2 = $data['signelead2'];
  1519. $signelead3 = $data['signelead3'];
  1520. $signelead4 = $data['signelead4'];
  1521. $signelead5 = $data['signelead5'];
  1522. $utiltecgarag = $data['utiltecgarag'];
  1523. $utiltecinfo = $data['utiltecinfo'];
  1524. $utilrachat = $data['utilrachat'];
  1525. $utildscsc = $data['utildscsc'];
  1526. $utildscsc2 = $data['utildscsc2'];
  1527. $utilrr = $data['utilrr'];
  1528. $userlead = $data['userlead'];
  1529. $demachatrefuleads = $data['demachatrefuleads'];
  1530. $signeDP1 = $data['signeDP1'];
  1531. $signeDP2 = $data['signeDP2'];
  1532. $signeDP3 = $data['signeDP3'];
  1533. $signeDP4 = $data['signeDP4'];
  1534. $signeDP5 = $data['signeDP5'];
  1535. $signeDP6 = $data['signeDP6'];
  1536. $signeDP7 = $data['signeDP7'];
  1537. $signeDP8 = $data['signeDP8'];
  1538. $usedp1 = $data['usedp1'];
  1539. $usedp2 = $data['usedp2'];
  1540. $usedp3 = $data['usedp3'];
  1541. $usedp4 = $data['usedp4'];
  1542. $usedp5 = $data['usedp5'];
  1543. $usedp6 = $data['usedp6'];
  1544. $usedp7 = $data['usedp7'];
  1545. $usedp8 = $data['usedp8'];
  1546. $usedep = $data['usedep'];
  1547. $usechefp = $data['usechefp'];
  1549. // 2. Gérez les formulaires. La logique de gestion des requêtes POST reste ici.
  1550. $demach = $demachats[0]; // Récupérez l'objet principal
  1552. $path = 'C:\wamp64\www\intranetbf\public\img\valid.png';
  1553. $type = pathinfo($path, PATHINFO_EXTENSION);
  1554. $data = file_get_contents($path);
  1555. $base64 = base64_encode($data);
  1562. $html = $this->twig->render('DemandeAchatVue/imprimdemachat.html.twig'
  1563. ,[
  1564. 'base64_image_data' => $base64,
  1565. 'demachats' => $demachats,
  1566. 'numach' => $numach,
  1567. 'user' => $user,
  1568. 'id' => $id,
  1569. 'x' => $x,
  1570. 'total3' => $total3,
  1571. 'param' => $param,
  1572. 'usesuph' => $usesuph,
  1573. 'userr' => $userr,
  1574. 'usedscsc' => $usedscsc,
  1575. 'usedp' => $usedp,
  1577. 'uselead' => $uselead,
  1578. 'usechefp' => $usechefp,
  1579. 'usedep' => $usedep,
  1580. 'code' => $code,
  1581. 'useprojet' => $useprojet,
  1582. 'usechef1' => $usechef1,
  1583. 'usechef2' => $usechef2,
  1584. 'usechef3' => $usechef3,
  1585. 'userreg' => $userreg,
  1586. 'usechef4' => $usechef4,
  1587. 'usechef5' => $usechef5,
  1588. 'usechef6' => $usechef6,
  1589. 'userespacha' => $userespacha,
  1590. 'usereg' => $usereg,
  1591. 'signechefp1' => $signechefp1,
  1592. 'signechefp2' => $signechefp2,
  1593. 'signechefp3' => $signechefp3,
  1594. 'signechefp4' => $signechefp4,
  1595. 'signechefp5' => $signechefp5,
  1596. 'signechefp6' => $signechefp6,
  1597. 'v' => $v,
  1598. 'demachatrefus' => $demachatrefus,
  1599. 'nb' => $nb,
  1600. //'form10' => $form10->createView(),
  1601. 'nomb' => $nomb,
  1602. 'suph' => $suph,
  1603. 'ub' => $ub,
  1604. 'nbch' => $nbch,
  1605. //'form20' => $form20->createView(),
  1606. 'signechefp7' => $signechefp7,
  1607. 'usechef7' => $usechef7,
  1608. 'usebaille1' => $usebaille1,
  1609. 'usebaille2' => $usebaille2,
  1610. 'usebaille3' => $usebaille3,
  1611. 'usebaille4' => $usebaille4,
  1612. 'usebaille5' => $usebaille5,
  1613. 'usebaille6' => $usebaille6,
  1614. 'usebaille7' => $usebaille7
  1615. ,'valid1' => $valid1,
  1616. 'valid2' => $valid2,
  1617. 'usevalid1' => $usevalid1,
  1618. 'usegarage' => $usevalid2,
  1619. 'uselead1' => $uselead1,
  1620. 'uselead2' => $uselead2,
  1621. 'uselead3' => $uselead3,
  1622. 'w' => $w,
  1623. 'signelead1' => $signelead1,
  1624. 'signelead2' => $signelead2,
  1625. 'signelead3' => $signelead3,
  1626. 'signelead4' => $signelead4,
  1627. 'signelead5' => $signelead5,
  1628. 'utiltecgarag' => $utiltecgarag,
  1629. 'utiltecinfo' => $utiltecinfo,
  1630. 'utilrachat' => $utilrachat,
  1631. 'utildscsc' => $utildscsc,
  1632. 'utildscsc2' => $utildscsc2,
  1633. 'utilrr' => $utilrr,
  1634. 'uselead4' => $uselead4,
  1635. 'uselead5' => $uselead5,
  1636. 'userlead' => $userlead,
  1637. 'demachatrefuleads' => $demachatrefuleads,
  1638. 'signeDP1' => $signeDP1,
  1639. 'signeDP2' => $signeDP2,
  1640. 'signeDP3' => $signeDP3,
  1641. 'signeDP4' => $signeDP4,
  1642. 'signeDP5' => $signeDP5,
  1643. 'signeDP6' => $signeDP6,
  1644. 'signeDP7' => $signeDP7,
  1645. 'signeDP8' => $signeDP8,
  1646. 'usedp1' => $usedp1,
  1647. 'usedp2' => $usedp2,
  1648. 'usedp3' => $usedp3,
  1649. 'usedp4' => $usedp4,
  1650. 'usedp5' => $usedp5,
  1651. 'usedp6' => $usedp6,
  1652. 'usedp7' => $usedp7,
  1653. 'usedp8' => $usedp8
  1654. ]
  1655. );
  1656. // 3. Utiliser une bibliothèque plus récente pour le PDF, comme 'dompdf/dompdf'
  1657. // Installez-la via Composer si ce n'est pas déjà fait : composer require dompdf/dompdf
  1658. $html2pdf = new \Dompdf\Dompdf();
  1659. $html2pdf->loadHtml($html);
  1660. $html2pdf->setPaper('A4', 'landscape');
  1661. $html2pdf->render();
  1663. $output = $html2pdf->output();
  1665. // Envoi direct de la sortie PDF en tant que réponse
  1666. $response = new Response($output);
  1667. $response->headers->set('Content-Type', 'application/pdf');
  1668. $response->headers->set('Content-Disposition', 'inline; filename="demande_achat_'.$id.'.pdf"');
  1670. // 4. Remplacer la logique d'envoi d'e-mail par le composant Mailer
  1671. $userE = $demach->getUser();
  1672. $emailUser = $userE->getEmail();
  1673. $nom = $userE->getNom();
  1674. $prenom = $userE->getPrenom();
  1675. /*
  1676. $email = (new Email())
  1677. ->from('votre_email@votredomaine.com')
  1678. ->to($emailUser)
  1679. ->subject('Demande d\'achat imprimée')
  1680. ->html(
  1681. "<html><head></head><body><b>Bonjour</b>,<br/>
  1682. Mrs/Mr $nom $prenom, votre demande d'achat N&deg$numach a &eacutet&eacute imprim&eacute.<br/><br/>
  1683. Suivez ce lien pour voir la demande:<br/>
  1684. http://www.intranet-mariestopesbf.org/web/login
  1685. </body></html>"
  1686. );
  1688. $mailer->send($email);*/
  1690. return $response;
  1692. }
  1693. public function telechargerFileA($id_ap)
  1694. {
  1697. $img = $this->em->getRepository(Image::class)->find($id_ap);
  1700. $fichier = $img->getAlt();
  1701. $chemin =$img->getUploadRootDir().'/';
  1703. $response = new Response();
  1704. $response->setContent(file_get_contents($chemin.$id_ap.$fichier));
  1705. $response->headers->set('Content-Type', 'application/force-download');
  1706. $response->headers->set('Content-disposition', 'filename='.$fichier);
  1708. return $response;
  1713. }
  1714. public function ajaxmodifierdelaiprevu($id_dem): Response
  1715. {
  1718. $achat = $this->em->getRepository(demAchat::class)->find($id_dem);
  1719. $form = $this->createForm(ModifDemAchatType::class, $achat);
  1721. return $this->render('DemandeAchatVue/modifierdelaiprevu.html.twig',
  1722. ['id_dem' => $id_dem,'form' => $form->createView(),]);
  1723. }
  1724. public function modifierdelaiprevu(Request $request): Response
  1725. {
  1728. $listnum = $request->request->get('id');
  1729. $delai = $request->request->get('delai');
  1731. $demacha=$this->em->getRepository(demAchat::class)->find($listnum);
  1735. $demachas = $this->em->getRepository(demAchat::class)->findBy([
  1736. 'numDemandeAchat' =>$demacha->getNumDemandeAchat(),'drapoRejetchef'=>0]);
  1737. foreach($demachas as $demach){
  1738. $demach->setDelaisPrevu($delai);
  1740. }
  1742. $this->em->flush();
  1744. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $listnum)));
  1751. }
  1752. public function ajaxmodifierdemacha($id_dem)
  1753. {
  1755. $demach = $this->em->getRepository(demAchat::class)->find($id_dem);
  1757. //$demachats = $this->em->getRepository(demAchat::class)->findByNumDemandeAchat($demach->getNumDemandeAchat() );
  1759. $user1=$demach->getUser();
  1760. $user = $this->security->getUser();
  1761. $form9 = $this->createForm(ModifDemAchatType::class, $demach);
  1763. return $this->render('DemandeAchatVue/modifierdemacha.html.twig',
  1764. ['id_dem' => $id_dem,'form9' => $form9->createView(),'user1' => $user1,'user' => $user]);
  1765. }
  1768. public function modifierdemacha(Request $request): Response
  1769. {
  1770. $objet = $request->request->get('objet');
  1771. $designation = $request->request->get('designatio');
  1772. $description = $request->request->get('description');
  1774. $quantd = (float)$request->request->get('quantd');
  1776. $idcentreCout = $request->request->get('centreCout');
  1777. $idnomProjet = $request->request->get('nomProjet');
  1779. $prixU = (float)$request->request->get('prixU');
  1781. $id = $request->request->get('id');
  1783. $demacha = $this->em
  1784. ->getRepository(demAchat::class)
  1785. ->find($id);
  1787. if (!$demacha) {
  1789. throw $this->createNotFoundException();
  1790. }
  1792. // =====================================================
  1793. // Ancien contrat + ancien montant
  1794. // =====================================================
  1796. $ancienContrat = $demacha->getContratCadre();
  1798. $ancienMontant =
  1799. (float)$demacha->getPrixU()
  1800. *
  1801. (float)$demacha->getQuantDemande();
  1803. if ($demacha->getTva()) {
  1805. $ancienMontant +=
  1806. $ancienMontant
  1807. *
  1808. ((float)$demacha->getTva() / 100);
  1809. }
  1811. // =====================================================
  1812. // Données liées
  1813. // =====================================================
  1815. $centreCout = $this->em
  1816. ->getRepository(CentreCout::class)
  1817. ->find($idcentreCout);
  1819. $nomProjet = $this->em
  1820. ->getRepository(Bailleur::class)
  1821. ->find($idnomProjet);
  1823. $design = $this->em
  1824. ->getRepository(Catalogue::class)
  1825. ->findOneByDesignation($designation);
  1827. // =====================================================
  1828. // MAJ ligne DA
  1829. // =====================================================
  1831. if ($design != null) {
  1833. $demacha->setDesignation(
  1834. $design->getDesignation()
  1835. );
  1837. $demacha->setCatalogue($design);
  1839. } else {
  1841. $demacha->setDesignation(
  1842. 'votre article selectionner ne se trouve pas dans le catalogue'
  1843. );
  1844. }
  1846. $demacha->setPrixU($prixU);
  1848. $demacha->setQuantDemande($quantd);
  1849. $demacha->setResteACommander($quantd);
  1850. $demacha->setCentreCout(
  1851. $centreCout->getLibele()
  1852. );
  1854. $demacha->setCostcenter($centreCout);
  1856. $demacha->setNomProjet(
  1857. $nomProjet->getLibele()
  1858. );
  1860. $demacha->setNombaille($nomProjet);
  1862. $demacha->setDescription($description);
  1864. // =====================================================
  1865. // MAJ objet sur toutes lignes DA
  1866. // =====================================================
  1868. $numach = $demacha->getNumDemandeAchat();
  1870. $demachats = $this->em
  1871. ->getRepository(demAchat::class)
  1872. ->findBy([
  1873. 'numDemandeAchat' => $numach,
  1874. 'drapoRejetchef' => 0
  1875. ]);
  1877. foreach ($demachats as $demachat) {
  1879. $demachat->setObjet($objet);
  1880. }
  1882. // =====================================================
  1883. // Nouveau montant
  1884. // =====================================================
  1886. $nouveauMontant =
  1887. $prixU * $quantd;
  1889. if ($demacha->getTva()) {
  1891. $nouveauMontant +=
  1892. $nouveauMontant
  1893. *
  1894. ((float)$demacha->getTva() / 100);
  1895. }
  1897. // =====================================================
  1898. // Retrait ancien montant réservation
  1899. // =====================================================
  1901. if ($ancienContrat) {
  1903. $ancienReserve =
  1904. (float)$ancienContrat->getMontantReserve();
  1906. $ancienContrat->setMontantReserve(
  1907. (string)max(
  1908. 0,
  1909. $ancienReserve - $ancienMontant
  1910. )
  1911. );
  1913. $this->em->persist($ancienContrat);
  1914. }
  1916. // =====================================================
  1917. // Recherche nouveau contrat compatible
  1918. // =====================================================
  1920. $nouveauContrat = null;
  1922. if ($design && $design->getCategorycatalogue()) {
  1924. $categorieCatalogue =
  1925. $design->getCategorycatalogue();
  1927. foreach (
  1928. $categorieCatalogue->getCategoriesMarche()
  1929. as $categorieMarche
  1930. ) {
  1932. $contrats =
  1933. $this->contratCadreService
  1934. ->listerDisponiblesPourDA(
  1935. $categorieMarche->getId(),
  1936. $nouveauMontant
  1937. );
  1939. if (!empty($contrats)) {
  1941. $nouveauContrat = $contrats[0];
  1943. break;
  1944. }
  1945. }
  1946. }
  1948. // =====================================================
  1949. // Nouveau contrat
  1950. // =====================================================
  1952. $demacha->setContratCadre($nouveauContrat);
  1954. if ($nouveauContrat) {
  1956. $reserve =
  1957. (float)$nouveauContrat->getMontantReserve();
  1959. $nouveauContrat->setMontantReserve(
  1960. (string)($reserve + $nouveauMontant)
  1961. );
  1963. $demacha->setStatutContratCadree(
  1964. demAchat::CC_SUGGERE
  1965. );
  1967. $this->em->persist($nouveauContrat);
  1969. } else {
  1971. $demacha->setStatutContratCadree(null);
  1972. }
  1974. // =====================================================
  1975. // Save
  1976. // =====================================================
  1978. $this->em->persist($demacha);
  1980. $this->em->flush();
  1982. return $this->redirect( $this->generateUrl( 'liste_demachat',
  1983. [
  1984. 'id' => $id
  1985. ]
  1986. )
  1987. );
  1988. }
  1991. public function ajaxmodacha($id_dem)
  1992. {
  1994. $demac = $this->em->getRepository(demAchat::class)->find($id_dem);
  1996. $form8 = $this->createForm(ModifDemAchatType::class, $demac);
  1999. return $this->render('DemandeAchatVue/modifacha.html.twig'
  2000. ,['id_dem' => $id_dem,'form8' => $form8->createView(),]
  2001. );
  2002. }
  2003. public function modifacha(Request $request): Response
  2004. {
  2008. $id = $request->request->get('id');
  2009. $bailleur = $request->request->get('bailleur');
  2010. $projet = $request->request->get('projet');
  2011. $ligneBudget = $request->request->get('ligneBudget');
  2013. $demacha=$this->em->getRepository(demAchat::class)->find($id);
  2017. $demacha->setBailleur($bailleur);
  2018. $demacha->setProjet($projet);
  2019. $demacha->setLigneBudget($ligneBudget);
  2021. $this->em->flush();
  2022. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id)));
  2029. }
  2031. public function ajaxmodifdemacha($id_dem)
  2032. {
  2035. $demac = $this->em->getRepository(demAchat::class)->find($id_dem);
  2037. $form = $this->createForm(ModifDemAchatType::class, $demac);
  2040. return $this->render('DemandeAchatVue/modifdemacha.html.twig',
  2041. ['id_dem' => $id_dem,'form' => $form->createView(),]);
  2044. }
  2045. public function modifdemacha(Request $request): Response
  2046. {
  2048. $user = $this->security->getUser();
  2049. $observation = $request->request->get('observation');
  2050. $id = $request->request->get('id');
  2051. //$quanta = $request->request->get('quantA');
  2053. $demacha=$this->em->getRepository(demAchat::class)->find($id);
  2056. $observation= $observation.' / par '.$user->getNom().' '.$user->getPrenom();
  2058. // $demacha->setQuantAccorde(null);
  2059. $demacha->setObservation($observation);
  2061. $this->em->flush();
  2062. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id)));
  2069. }
  2070. public function ajaxcorrectionda(Request $request): Response
  2071. {
  2072. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2073. $demachas = $data['demachas'];
  2074. $id_achat = $data['id_achat'];
  2077. foreach($demachas as $demach){
  2078. $demach->setDrapoRespRegrefu(0);
  2079. $demach->setDrapoRespAcharefu(0);
  2080. $demach->setDrapoDSCSCrefu(0);
  2081. $demach->setDrapoDPrefu(0);
  2082. $demach->setDrapoRRrefu(0);
  2083. $demach->setDrapoSuprefu(0);
  2084. $demach->setDrapoLeadrefu(0);
  2085. $demach->setDrapoLeadrefu1(0);
  2086. $demach->setDrapoLeadrefu2(0);
  2087. $demach->setDrapoLeadrefu3(0);
  2088. $demach->setDrapoLeadrefu4(0);
  2089. $demach->setDrapoLeadrefu5(0);
  2090. $demach->setDrapoRejetLead(0);
  2091. $demach->setDrapoChefprefu(0);
  2092. $demach->setDrapoChefprefu1(0);
  2093. $demach->setDrapoChefprefu2(0);
  2094. $demach->setDrapoChefprefu3(0);
  2095. $demach->setDrapoChefprefu4(0);
  2096. $demach->setDrapoChefprefu5(0);
  2097. $demach->setDrapoChefprefu6(0);
  2098. $demach->setDrapoChefprefu7(0);
  2099. $demach->setDrapoDPrefu1(0);
  2100. $demach->setDrapoDPrefu2(0);
  2101. $demach->setDrapoDPrefu3(0);
  2102. $demach->setDrapoDPrefu4(0);
  2103. $demach->setDrapoDPrefu5(0);
  2104. $demach->setDrapoDPrefu6(0);
  2105. $demach->setDrapoDPrefu7(0);
  2106. $demach->setRaisonRefu(null);
  2107. $demach->setObservation(null);
  2108. $demach->setSigneLead(null);
  2109. $demach->setSigneLead1(null);
  2110. $demach->setSigneLead2(null);
  2111. $demach->setSigneLead3(null);
  2112. $demach->setSigneLead4(null);
  2113. $demach->setSigneLead5(null);
  2114. $demach->setSigneSUP(null);
  2115. $demach->setSigneChefp(null);
  2116. $demach->setSigneChefp1(null);
  2117. $demach->setSigneChefp2(null);
  2118. $demach->setSigneChefp3(null);
  2119. $demach->setSigneChefp4(null);
  2120. $demach->setSigneChefp5(null);
  2121. $demach->setSigneChefp6(null);
  2122. $demach->setSigneChefp7(null);
  2123. $demach->setSigneDF(null);
  2124. $demach->setSigneDP(null);
  2125. $demach->setSigneRR(null);
  2126. $demach->setSigneDP1(null);
  2127. $demach->setSigneDP2(null);
  2128. $demach->setSigneDP3(null);
  2129. $demach->setSigneDP4(null);
  2130. $demach->setSigneDP5(null);
  2131. $demach->setSigneDP6(null);
  2132. $demach->setSigneDP7(null);
  2133. $demach->setDrapoRespReg(0);
  2134. $demach->setDrapoRespAcha(0);
  2135. $demach->setDrapoDSCSC(0);
  2136. $demach->setDrapoDP(0);
  2137. $demach->setDrapoRR(0);
  2138. $demach->setDrapoSup(0);
  2139. $demach->setDrapoLead(0);
  2140. $demach->setDrapoChefp(0);
  2141. $demach->setDrapoChefp1(0);
  2142. $demach->setDrapoChefp2(0);
  2143. $demach->setDrapoChefp3(0);
  2144. $demach->setDrapoChefp4(0);
  2145. $demach->setDrapoChefp5(0);
  2146. $demach->setDrapoChefp6(0);
  2147. $demach->setDrapoChefp7(0);
  2148. $demach->setDrapoRejetchef(0);
  2149. $demach->setDrapoLead1(0);
  2150. $demach->setDrapoLead2(0);
  2151. $demach->setDrapoLead3(0);
  2152. $demach->setDrapoLead4(0);
  2153. $demach->setDrapoLead5(0);
  2154. $demach->setDrapoDP1(0);
  2155. $demach->setDrapoDP2(0);
  2156. $demach->setDrapoDP3(0);
  2157. $demach->setDrapoDP4(0);
  2158. $demach->setDrapoDP5(0);
  2159. $demach->setDrapoDP6(0);
  2160. $demach->setDrapoDP7(0);
  2161. $demach->setDrapoGaragerefu(0);
  2162. }
  2163. $this->em->flush();
  2165. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2169. }
  2170. /*public function ajaxmodtva(Request $request): Response
  2171. {
  2172. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2173. $demachas = $data['demachas'];
  2174. $id_achat = $data['id_achat'];
  2175. $tva = $data['tva'];
  2177. foreach($demachas as $demach){
  2178. $demach->setTva($tva);
  2180. }
  2181. $this->em->flush();
  2183. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2187. } */
  2188. public function ajaxmodtva(Request $request): Response
  2189. {
  2190. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2192. $demachas = $data['demachas'];
  2193. $id_achat = $data['id_achat'];
  2194. $tva = (float)$data['tva'];
  2196. if (empty($demachas)) {
  2197. return $this->redirect(
  2198. $this->generateUrl('liste_demachat', ['id' => $id_achat])
  2199. );
  2200. }
  2202. // même contrat pour toute la DA
  2203. $contratCadre = $demachas[0]->getContratCadre();
  2205. $ancienMontantTotal = 0;
  2206. $nouveauMontantTotal = 0;
  2208. foreach ($demachas as $demach) {
  2210. $prixU = (float)$demach->getPrixU();
  2211. $qte = (float)$demach->getQuantDemande();
  2213. // ancien montant avec ancienne TVA
  2214. $ancienneTva = (float)$demach->getTva();
  2216. $ancienLigne =
  2217. ($prixU * $qte)
  2218. +
  2219. (($prixU * $qte) * $ancienneTva / 100);
  2221. $ancienMontantTotal += $ancienLigne;
  2223. // mise à jour TVA
  2224. $demach->setTva((string)$tva);
  2226. // nouveau montant
  2227. $nouveauLigne =
  2228. ($prixU * $qte)
  2229. +
  2230. (($prixU * $qte) * $tva / 100);
  2232. $nouveauMontantTotal += $nouveauLigne;
  2233. }
  2235. // ajustement réservation CC
  2236. if ($contratCadre) {
  2238. $montantReserveActuel =
  2239. (float)$contratCadre->getMontantReserve();
  2241. // différence TTC
  2242. $difference =
  2243. $nouveauMontantTotal - $ancienMontantTotal;
  2245. $contratCadre->setMontantReserve(
  2246. (string)($montantReserveActuel + $difference)
  2247. );
  2249. $this->em->persist($contratCadre);
  2250. }
  2252. $this->em->flush();
  2254. return $this->redirect(
  2255. $this->generateUrl('liste_demachat', ['id' => $id_achat])
  2256. );
  2257. }
  2259. public function ajaxdrapoCharge(Request $request): Response
  2260. {
  2263. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2264. $demachas = $data['demachas'];
  2265. $id_achat = $data['id_achat'];
  2266. $user = $data['user'];
  2267. $demacha = $data['demacha'];
  2268. $var=0;
  2269. foreach($demachas as $demach){
  2271. if (empty($demach->getDelaisPrevu()))
  2272. $var=1;
  2273. }
  2274. if($var==1){
  2275. return new JsonResponse(['message' => 'veuillez renseigner le delais prévisionnel !']);
  2277. }
  2278. else
  2279. {
  2280. foreach($demachas as $demach){
  2281. $demach->setDrapoPriCharge(1);
  2283. }
  2284. $this->em->flush();
  2287. $delais=$demacha->getDelaisPrevu();
  2288. $emailuser=$user->getEmail();
  2289. $num=$demacha->getNumDemandeAchat();
  2290. $nom=$user->getNom();
  2291. $prenom=$user->getPrenom();
  2292. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  2293. la demande d'achat N&deg$num de Mrs/Mr $nom $prenom a ete pris en charge.
  2294. le delais de livraison prévisionnel est de $delais jours.
  2295. .<br/><br/>
  2296. <br/>
  2298. </body></html>
  2299. </body></html>";
  2303. // $this->Envoi($emailuser,$contenu);
  2304. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2305. }
  2309. }
  2311. public function ajaxvalidtech1(Request $request): Response
  2312. {
  2313. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2314. $demachas = $data['demachas'];
  2315. // $id_achat = $data['id_achat'];
  2316. $user = $data['user'];
  2317. $demacha = $data['demacha'];
  2318. $dat = $data['dat'];
  2320. foreach($demachas as $demach){
  2321. $demach->setSigneInfo($user);
  2322. $demach->setDrapoInfo(1);
  2323. $demach->setDrapoInforefu(0);
  2324. $demach->setDateInfo(new \DateTime($dat));
  2325. }
  2326. $this->em->flush();
  2328. $id_achat=$demacha->getId();
  2329. $user=$demacha->getUser();
  2330. $emailuser=$user->getEmail();
  2331. $num=$demacha->getNumDemandeAchat();
  2332. $nom=$user->getNom();
  2333. $prenom=$user->getPrenom();
  2334. $contenu="<html><head></head><body><b>Bonjour,
  2335. le responsable technique a validé la DA</b>,<br/>
  2337. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2338. </body></html>";
  2340. // $this->Envoi($emailuser,$contenu);
  2343. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2347. }
  2348. public function ajaxvalidtech1refu(Request $request): Response
  2349. {
  2350. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2351. $demachas = $data['demachas'];
  2352. $id_achat = $data['id_achat'];
  2353. $user = $data['user'];
  2354. $demacha = $data['demacha'];
  2355. $dat = $data['dat'];
  2357. foreach($demachas as $demach){
  2358. $demach->setSigneInfo($user);
  2359. $demach->setDrapoInfo(0);
  2360. $demach->setDrapoInforefu(1);
  2361. $demach->setDateInfo(new \DateTime($dat));
  2362. }
  2363. $this->em->flush();
  2365. $user=$demacha->getUser();
  2366. $emailuser=$user->getEmail();
  2367. $num=$demacha->getNumDemandeAchat();
  2368. $nom=$user->getNom();
  2369. $prenom=$user->getPrenom();
  2370. $contenu="<html><head></head><body><b>Bonjour,
  2371. le responsable technique a rejeté la DA</b>,<br/>
  2373. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2374. </body></html>";
  2376. // $this->Envoi($emailuser,$contenu);
  2379. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2383. }
  2384. public function ajaxvalid2(Request $request): Response
  2385. {
  2386. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2387. $demachas = $data['demachas'];
  2388. $id_achat = $data['id_achat'];
  2389. $user = $data['user'];
  2390. $demacha = $data['demacha'];
  2391. $dat = $data['dat'];
  2393. foreach($demachas as $demach){
  2394. $demach->setSigneGarage($user);
  2395. $demach->setDrapoGarage(1);
  2396. $demach->setDrapoGaragerefu(0);
  2397. $demach->setDateGarage(new \DateTime($dat));
  2398. if($demach->getUser()->getId()==294){
  2399. $demach->setDrapoSup(1);
  2400. $demach->setDrapoSuprefu(0);
  2401. $demach->setSigneSUP($user);
  2402. $demach->setDateSuph(new \DateTime($dat));
  2403. }
  2404. }
  2405. $this->em->flush();
  2408. $user=$demacha->getUser();
  2409. $emailuser=$user->getEmail();
  2410. $num=$demacha->getNumDemandeAchat();
  2411. $nom=$user->getNom();
  2412. $prenom=$user->getPrenom();
  2413. $contenu="<html><head></head><body><b>Bonjour,
  2414. le responsable technique a validé la DA</b>,<br/>
  2416. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2417. </body></html>";
  2419. // $this->Envoi($emailuser,$contenu);
  2422. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2426. }
  2427. public function ajaxvalid2refu(Request $request): Response
  2428. {
  2429. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2430. $demachas = $data['demachas'];
  2431. $id_achat = $data['id_achat'];
  2432. $user = $data['user'];
  2433. $demacha = $data['demacha'];
  2434. $dat = $data['dat'];
  2435. foreach($demachas as $demach){
  2436. $demach->setSigneGarage($user);
  2437. $demach->setDrapoGarage(0);
  2438. $demach->setDrapoGaragerefu(1);
  2439. $demach->setDateGarage(new \DateTime($dat));
  2440. if($demach->getUser()->getId()==294){
  2441. $demach->setDrapoSup(1);
  2442. $demach->setDrapoSuprefu(0);
  2443. $demach->setSigneSUP($user);
  2444. $demach->setDateSuph(new \DateTime($dat));
  2445. }
  2446. }
  2447. $this->em->flush();
  2449. $user=$demacha->getUser();
  2450. $emailuser=$user->getEmail();
  2451. $num=$demacha->getNumDemandeAchat();
  2452. $nom=$user->getNom();
  2453. $prenom=$user->getPrenom();
  2454. $contenu="<html><head></head><body><b>Bonjour,
  2455. le responsable technique a rejeté la DA</b>,<br/>
  2457. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2458. </body></html>";
  2460. // $this->Envoi($emailuser,$contenu);
  2463. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2467. }
  2469. public function ajaxdraporacha(Request $request): Response
  2470. {
  2471. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2472. $demachas = $data['demachas'];
  2473. $id_achat = $data['id_achat'];
  2474. $user = $data['user'];
  2475. $demacha = $data['demacha'];
  2476. $dat = $data['dat'];
  2477. $nbselect = $data['nbselect'];
  2480. if( $nbselect >1){
  2481. return new JsonResponse(array('message' => 'veuillez actualiser la page, vous avez plusieurs DAs ouvertes !'));
  2483. }
  2485. foreach($demachas as $demach){
  2486. $demach->setSigneRespAcha($user);
  2487. $demach->setDrapoRespAcha(1);
  2488. $demach->setDrapoRespAcharefu(0);
  2489. $demach->setDateRespAcha(new \DateTime($dat));
  2490. }
  2491. $this->em->flush();
  2493. $user=$demacha->getUser();
  2494. $emailuser=$user->getEmail();
  2495. $num=$demacha->getNumDemandeAchat();
  2496. $nom=$user->getNom();
  2497. $prenom=$user->getPrenom();
  2498. $contenu="<html><head></head><body><b>Bonjour,
  2499. le responsable achat a validé la DA</b>,<br/>
  2501. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2502. </body></html>";
  2504. // $this->Envoi($emailuser,$contenu);
  2506. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2512. }
  2514. public function ajaxdraporacharefu(Request $request): Response
  2515. {
  2516. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2517. $demachas = $data['demachas'];
  2518. $id_achat = $data['id_achat'];
  2519. $user = $data['user'];
  2520. $demacha = $data['demacha'];
  2521. $dat = $data['dat'];
  2522. $nbselect = $data['nbselect'];
  2524. if( $nbselect >1){
  2525. return new JsonResponse(array('message' => 'veuillez actualiser la page, vous avez plusieurs DAs ouvertes !'));
  2527. }
  2529. foreach($demachas as $demach){
  2530. $demach->setSigneRespAcha($user);
  2531. $demach->setDrapoRespAcha(0);
  2532. $demach->setDrapoRespAcharefu(1);
  2533. $demach->setDateRespAcha(new \DateTime($dat));
  2534. }
  2535. $this->em->flush();
  2537. $user=$demacha->getUser();
  2538. $emailuser=$user->getEmail();
  2539. $num=$demacha->getNumDemandeAchat();
  2540. $nom=$user->getNom();
  2541. $prenom=$user->getPrenom();
  2542. $contenu="<html><head></head><body><b>Bonjour,
  2543. le responsable achat a validé la DA</b>,<br/>
  2545. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2546. </body></html>";
  2548. // $this->Envoi($emailuser,$contenu);
  2550. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2555. }
  2557. public function ajaxdrapodrmedical(Request $request): Response
  2558. {
  2559. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2560. $demachas = $data['demachas'];
  2561. $id_achat = $data['id_achat'];
  2562. $user = $data['user'];
  2563. $demacha = $data['demacha'];
  2564. $dat = $data['dat'];
  2566. foreach($demachas as $demach){
  2567. $demach->setSigneDRMEDICAL($user);
  2568. $demach->setDrapoDRMEDICAL(1);
  2569. $demach->setDrapoDRMEDICALrefu(0);
  2570. $demach->setDateDRMEDICAL(new \DateTime($dat));
  2571. }
  2572. $this->em->flush();
  2574. $user=$demacha->getUser();
  2575. $emailuser=$user->getEmail();
  2576. $num=$demacha->getNumDemandeAchat();
  2577. $nom=$user->getNom();
  2578. $prenom=$user->getPrenom();
  2579. $contenu="<html><head></head><body><b>Bonjour,
  2580. le responsable médical a validé la DA</b>,<br/>
  2582. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2583. </body></html>";
  2585. // $this->Envoi($emailuser,$contenu);
  2587. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2593. }
  2595. public function ajaxdrmedicalrefu(Request $request): Response
  2596. {
  2597. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2598. $demachas = $data['demachas'];
  2599. $id_achat = $data['id_achat'];
  2600. $user = $data['user'];
  2601. $demacha = $data['demacha'];
  2602. $dat = $data['dat'];
  2604. foreach($demachas as $demach){
  2605. $demach->setSigneDRMEDICAL($user);
  2606. $demach->setDrapoDRMEDICAL(0);
  2607. $demach->setDrapoDRMEDICALrefu(1);
  2608. $demach->setDateDRMEDICAL(new \DateTime($dat));
  2609. }
  2610. $this->em->flush();
  2612. $user=$demacha->getUser();
  2613. $emailuser=$user->getEmail();
  2614. $num=$demacha->getNumDemandeAchat();
  2615. $nom=$user->getNom();
  2616. $prenom=$user->getPrenom();
  2617. $contenu="<html><head></head><body><b>Bonjour,
  2618. le responsable médical a validé la DA</b>,<br/>
  2620. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2621. </body></html>";
  2623. // $this->Envoi($emailuser,$contenu);
  2625. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2631. }
  2633. public function ajaxdraposuph(Request $request): Response
  2634. {
  2636. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2637. $demachas = $data['demachas'];
  2638. $id_achat = $data['id_achat'];
  2639. $user = $data['user'];
  2640. $demacha = $data['demacha'];
  2641. $dat = $data['dat'];
  2643. foreach($demachas as $demach){
  2645. $demach->setSigneSUP($user);
  2646. $demach->setDrapoSup(1);
  2647. $demach->setDrapoSuprefu(0);
  2649. $demach->setDateSuph(new \DateTime($dat));}
  2650. $this->em->flush();
  2652. $user=$demacha->getUser();
  2653. $emailuser=$user->getEmail();
  2654. $num=$demacha->getNumDemandeAchat();
  2655. $nom=$user->getNom();
  2656. $prenom=$user->getPrenom();
  2657. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  2658. le superieur hierarchique de Mrs/Mr $nom $prenom a approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  2659. Suivez ce lien pour voir la demande:<br/>
  2660. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2661. </body></html>";
  2664. $centrecout=$demacha->getCentreCout();
  2665. $centre = $this->em->getRepository(CentreCout::class)->findOneByLibele($centrecout);
  2666. $usecentres = $this->em->getRepository(UserCentre::class)->findByCentrecout($centre);
  2668. $usedp=null;
  2670. foreach ($usecentres as $usecentre)
  2671. {
  2672. if($usecentre->getUser()->hasRole('ROLE_DP'))
  2673. $usedp=$usecentre->getUser();
  2676. }
  2677. $email=$usedp->getEmail();
  2678. // $this->Envoi($email,$contenu);
  2679. // $this->Envoi($emailuser,$contenu);
  2682. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2688. }
  2690. public function ajaxdraposuphrefu(Request $request): Response
  2691. {
  2693. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2694. $demachas = $data['demachas'];
  2695. $id_achat = $data['id_achat'];
  2696. $user = $data['user'];
  2697. $demacha = $data['demacha'];
  2698. $dat = $data['dat'];
  2700. foreach($demachas as $demach){
  2702. $demach->setSigneSUP($user);
  2703. $demach->setDrapoSup(0);
  2704. $demach->setDrapoSuprefu(1);
  2706. $demach->setDateSuph(new \DateTime($dat));}
  2707. $this->em->flush();
  2709. $user=$demacha->getUser();
  2710. $emailuser=$user->getEmail();
  2711. $num=$demacha->getNumDemandeAchat();
  2712. $nom=$user->getNom();
  2713. $prenom=$user->getPrenom();
  2714. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  2715. le superieur hierarchique de Mrs/Mr $nom $prenom n'a pas approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  2716. Suivez ce lien pour voir la demande:<br/>
  2717. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2719. </body></html>";
  2722. // $this->Envoi($emailuser,$contenu);
  2723. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2727. }
  2729. public function ajaxdraporespreg(Request $request): Response
  2730. {
  2731. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2732. $demachas = $data['demachas'];
  2733. $id_achat = $data['id_achat'];
  2734. $user = $data['user'];
  2735. $demacha = $data['demacha'];
  2736. $dat = $data['dat'];
  2738. foreach($demachas as $demach){
  2739. $demach->setSigneRespReg($user);
  2740. $demach->setDrapoRespReg(1);
  2741. $demach->setDrapoRespRegrefu(0);
  2742. $demach->setDateRespReg(new \DateTime($dat));
  2743. if($user->hasRole('ROLE_DP2') )
  2744. {
  2746. $demach->setSigneDP2($user);
  2747. $demach->setDrapoDP2(1);
  2748. $demach->setDrapoDPrefu2(0);
  2749. $demach->setDateDP2(new \DateTime($dat));
  2750. }
  2751. }
  2752. $this->em->flush();
  2754. $user=$demacha->getUser();
  2755. $emailuser=$user->getEmail();
  2756. $num=$demacha->getNumDemandeAchat();
  2757. $nom=$user->getNom();
  2758. $prenom=$user->getPrenom();
  2759. $contenu="<html><head></head><body><b>Bonjour</b>,
  2760. le responsable regionale a valid&eacute la DA<br/>
  2762. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2763. </body></html>";
  2764. $centrecout=$demacha->getCentreCout();
  2765. $centre = $this->em->getRepository(CentreCout::class)->findOneByLibele($centrecout);
  2766. $usecentres = $this->em->getRepository(UserCentre::class)->findByCentrecout($centre);
  2767. $code= $usecentres[0]->getCode();
  2768. $usedp=null; $usefinance=null; $uselead=null;
  2769. if($code==13)
  2770. {
  2772. foreach ($usecentres as $usecentre)
  2773. {
  2774. if($usecentre->getUselead()->hasRole('ROLE_LEAD'))
  2775. $uselead=$usecentre->getUser();
  2776. $email=$uselead->getEmail();
  2777. //$this->Envoi($email,$contenu);
  2779. }
  2781. }
  2782. if($code==61)
  2783. {
  2784. foreach ($usecentres as $usecentre)
  2785. {
  2786. if($usecentre->getUser()->hasRole('ROLE_DP'))
  2787. $usedp=$usecentre->getUser();
  2788. $email=$usedp->getEmail();
  2789. //$this->Envoi($email,$contenu);
  2791. }
  2792. }
  2793. // $this->Envoi($emailuser,$contenu);
  2797. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2801. }
  2803. public function ajaxdraporespregrefu(Request $request): Response
  2804. {
  2805. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2806. $demachas = $data['demachas'];
  2807. $id_achat = $data['id_achat'];
  2808. $user = $data['user'];
  2809. $demacha = $data['demacha'];
  2810. $dat = $data['dat'];
  2811. foreach($demachas as $demach){
  2812. $demach->setSigneRespReg($user);
  2813. $demach->setDrapoRespReg(0);
  2814. $demach->setDrapoRespRegrefu(1);
  2815. $demach->setDateRespReg(new \DateTime($dat));
  2817. }
  2818. $this->em->flush();
  2820. $use=$demacha->getUser();
  2821. $emailuser=$use->getEmail();
  2822. $num=$demacha->getNumDemandeAchat();
  2823. $nom=$use->getNom();
  2824. $prenom=$use->getPrenom();
  2825. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  2826. le responsable regional n'a pas approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  2827. Suivez ce lien pour voir la demande:<br/>
  2828. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2829. </body></html>";
  2831. // $this->Envoi($emailuser,$contenu);
  2834. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2838. }
  2840. public function ajaxdrapolead(Request $request): Response
  2841. {
  2843. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2844. $demachas = $data['demachas'];
  2845. $id_achat = $data['id_achat'];
  2846. $user = $data['user'];
  2847. $demacha = $data['demacha'];
  2848. $dat = $data['dat'];
  2850. if($user->hasRole('ROLE_LEAD1') )
  2851. {
  2853. foreach($demachas as $demach)
  2854. {
  2857. $demach->setSigneLead1($user);
  2858. $demach->setDrapoLead1(1);
  2859. $demach->setDrapoLeadrefu1(0);
  2860. $demach->setDateLead1(new \DateTime($dat));
  2862. }
  2863. $this->em->flush();
  2864. }
  2865. elseif($user->hasRole('ROLE_LEAD2') )
  2866. {
  2868. foreach($demachas as $demach)
  2869. {
  2872. $demach->setSigneLead2($user);
  2873. $demach->setDrapoLead2(1);
  2874. $demach->setDrapoLeadrefu2(0);
  2875. $demach->setDateLead2(new \DateTime($dat));
  2877. }
  2878. $this->em->flush();
  2879. }
  2880. elseif($user->hasRole('ROLE_LEAD3') )
  2881. {
  2883. foreach($demachas as $demach)
  2884. {
  2887. $demach->setSigneLead3($user);
  2888. $demach->setDrapoLead3(1);
  2889. $demach->setDrapoLeadrefu3(0);
  2890. $demach->setDateLead3(new \DateTime($dat));
  2892. }
  2893. $this->em->flush();
  2894. }
  2895. elseif($user->hasRole('ROLE_LEAD4') )
  2896. {
  2898. foreach($demachas as $demach)
  2899. {
  2902. $demach->setSigneLead4($user);
  2903. $demach->setDrapoLead4(1);
  2904. $demach->setDrapoLeadrefu4(0);
  2905. $demach->setDateLead4(new \DateTime($dat));
  2907. }
  2908. $this->em->flush();
  2909. }
  2910. elseif($user->hasRole('ROLE_LEAD5') )
  2911. {
  2913. foreach($demachas as $demach)
  2914. {
  2917. $demach->setSigneLead5($user);
  2918. $demach->setDrapoLead5(1);
  2919. $demach->setDrapoLeadrefu5(0);
  2920. $demach->setDateLead5(new \DateTime($dat));
  2922. }
  2923. $this->em->flush();
  2924. }
  2927. $user=$demacha->getUser();
  2928. $emailuser=$user->getEmail();
  2929. $num=$demacha->getNumDemandeAchat();
  2930. $nom=$user->getNom();
  2931. $prenom=$user->getPrenom();
  2932. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  2933. le Channel Lead a approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  2934. Suivez ce lien pour voir la demande:<br/>
  2935. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2936. </body></html>";
  2939. $bailleur=$demacha->getNomProjet();
  2942. $baille = $this->em->getRepository(Bailleur::class)->findOneByLibele($bailleur);
  2945. $usebaille = $this->em->getRepository(UseBailleur::class)->findOneByBailleur($baille);
  2947. $email=$usebaille->getUser()->getEmail();
  2948. // $this->Envoi($email,$contenu);
  2949. // $this->Envoi($emailuser,$contenu);
  2951. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2955. }
  2957. public function ajaxdrapoleadrefu(Request $request): Response
  2958. {
  2960. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2961. $demachas = $data['demachas'];
  2962. $id_achat = $data['id_achat'];
  2963. $user = $data['user'];
  2964. $demacha = $data['demacha'];
  2965. $dat = $data['dat'];
  2966. $usecentres = $data['usecentres'];
  2967. if($user->hasRole('ROLE_LEAD1') )
  2968. {
  2970. foreach($demachas as $demach)
  2971. {
  2974. $demach->setSigneLead1($user);
  2975. $demach->setDrapoLead1(0);
  2976. $demach->setDrapoLeadrefu1(1);
  2977. $demach->setDateLead1(new \DateTime($dat));
  2978. foreach($usecentres as $usecentre)
  2979. {
  2980. if( $demach->getCostcenter()==$usecentre->getCentrecout())
  2981. $demach->setDrapoRejetLead(1);
  2982. }
  2983. }
  2984. $this->em->flush();
  2985. }
  2986. elseif($user->hasRole('ROLE_LEAD2') )
  2987. {
  2989. foreach($demachas as $demach)
  2990. {
  2993. $demach->setSigneLead2($user);
  2994. $demach->setDrapoLead2(0);
  2995. $demach->setDrapoLeadrefu2(1);
  2996. $demach->setDateLead2(new \DateTime($dat));
  2997. foreach($usecentres as $usecentre)
  2998. {
  2999. if( $demach->getCostcenter()==$usecentre->getCentrecout())
  3000. $demach->setDrapoRejetLead(1);
  3001. }
  3003. }
  3004. $this->em->flush();
  3005. }
  3006. elseif($user->hasRole('ROLE_LEAD3') )
  3007. {
  3009. foreach($demachas as $demach)
  3010. {
  3013. $demach->setSigneLead3($user);
  3014. $demach->setDrapoLead3(0);
  3015. $demach->setDrapoLeadrefu3(1);
  3016. $demach->setDateLead3(new \DateTime($dat));
  3017. foreach($usecentres as $usecentre)
  3018. {
  3019. if( $demach->getCostcenter()==$usecentre->getCentrecout())
  3020. $demach->setDrapoRejetLead(1);
  3021. }
  3023. }
  3024. $this->em->flush();
  3025. }
  3026. elseif($user->hasRole('ROLE_LEAD4') )
  3027. {
  3029. foreach($demachas as $demach)
  3030. {
  3033. $demach->setSigneLead4($user);
  3034. $demach->setDrapoLead4(0);
  3035. $demach->setDrapoLeadrefu4(1);
  3036. $demach->setDateLead4(new \DateTime($dat));
  3037. foreach($usecentres as $usecentre)
  3038. {
  3039. if( $demach->getCostcenter()==$usecentre->getCentrecout())
  3040. $demach->setDrapoRejetLead(1);
  3041. }
  3043. }
  3044. $this->em->flush();
  3045. }
  3046. elseif($user->hasRole('ROLE_LEAD5') )
  3047. {
  3049. foreach($demachas as $demach)
  3050. {
  3053. $demach->setSigneLead5($user);
  3054. $demach->setDrapoLead5(0);
  3055. $demach->setDrapoLeadrefu5(1);
  3056. $demach->setDateLead5(new \DateTime($dat));
  3057. foreach($usecentres as $usecentre)
  3058. {
  3059. if( $demach->getCostcenter()==$usecentre->getCentrecout())
  3060. $demach->setDrapoRejetLead(1);
  3061. }
  3063. }
  3064. $this->em->flush();
  3065. }
  3067. $user=$demacha->getUser();
  3068. $emailuser=$user->getEmail();
  3069. $num=$demacha->getNumDemandeAchat();
  3070. $nom=$user->getNom();
  3071. $prenom=$user->getPrenom();
  3072. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3073. lechannel lead n'a pas approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  3074. Suivez ce lien pour voir la demande:<br/>
  3075. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  3076. </body></html>";
  3078. // $this->Envoi($emailuser,$contenu);
  3080. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  3084. }
  3086. public function ajaxdrapochefp(Request $request): Response
  3087. {
  3089. $data = $this->demandeAchatService->getDemachatSigneData($request);
  3090. $demachas = $data['demachas'];
  3091. $id_achat = $data['id_achat'];
  3092. $user = $data['user'];
  3093. $demacha = $data['demacha'];
  3094. $dat = $data['dat'];
  3096. $var=0;
  3097. if($demacha->getCostcenter()!=null)
  3098. {
  3099. foreach($demachas as $demach)
  3100. {
  3101. $usebail= $this->em->getRepository(UseBailleur::class)->findOneByBailleur($demach->getNombaille());
  3103. if($usebail!=null){
  3105. if($usebail->getUser()==$user)
  3106. {
  3108. if($demach->getBailleur()=="" || $demach->getProjet()=="" || $demach->getLigneBudget()=="")
  3109. $var=1;
  3110. }
  3111. }
  3112. }
  3113. }
  3114. if($var==1)
  3115. {
  3116. // Retourner la réponse JSON
  3117. return new JsonResponse(array('message' => 'veuillez renseigner les codes bailleurs,codes projets et lignes budgetaires !'));
  3118. }
  3119. elseif( $var==0){
  3120. // $iduser=$user->getId();
  3121. $total=0;
  3122. if($user->hasRole('ROLE_CHEFP1') )
  3123. {
  3124. foreach($demachas as $demach)
  3125. {
  3126. if($demach->getQuantAccorde()!=null)
  3127. $total=$demach->getQuantAccorde()*$demach->getPrixU()+$total;
  3128. else
  3129. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3130. $demach->setSigneChefp1($user);
  3131. $demach->setDrapoChefp1(1);
  3132. $demach->setDrapoChefprefu1(0);
  3133. $demach->setDateChefp1(new \DateTime($dat));
  3134. /*if($user->hasRole('ROLE_RR') ){
  3135. $demach->setDrapoChefp6(1);
  3136. $demach->setDrapoChefprefu6(0);
  3137. $demach->setSigneChefp6($user);}*/
  3138. }
  3139. $this->em->flush();
  3140. }
  3141. if($user->hasRole('ROLE_CHEFP2') )
  3142. {
  3143. foreach($demachas as $demach)
  3144. {
  3145. if($demach->getQuantAccorde()!=null)
  3146. $total=$demach->getQuantAccorde()*$demach->getPrixU()+$total;
  3147. else
  3148. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3149. $demach->setSigneChefp2($user);
  3150. $demach->setDrapoChefp2(1);
  3151. $demach->setDrapoChefprefu2(0);
  3152. $demach->setDateChefp2(new \DateTime($dat));
  3154. }
  3155. $this->em->flush();
  3156. }
  3157. if($user->hasRole('ROLE_CHEFP3') )
  3158. {
  3159. foreach($demachas as $demach)
  3160. {
  3162. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3163. $demach->setSigneChefp3($user);
  3164. $demach->setDrapoChefp3(1);
  3165. $demach->setDrapoChefprefu3(0);
  3166. $demach->setDateChefp3(new \DateTime($dat));
  3167. /*if($user->hasRole('ROLE_RR') ){
  3168. $demach->setDrapoChefp6(1);
  3169. $demach->setDrapoChefprefu6(0);
  3170. $demach->setSigneChefp6($user);}*/
  3171. }
  3172. $this->em->flush();
  3173. }
  3174. if($user->hasRole('ROLE_CHEFP4') )
  3175. {
  3176. foreach($demachas as $demach)
  3177. {
  3179. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3180. $demach->setSigneChefp4($user);
  3181. $demach->setDrapoChefp4(1);
  3182. $demach->setDrapoChefprefu4(0);
  3183. $demach->setDateChefp4(new \DateTime($dat));
  3184. /* if($user->hasRole('ROLE_RR') ){
  3185. $demach->setDrapoChefp6(1);
  3186. $demach->setDrapoChefprefu6(0);
  3187. $demach->setSigneChefp6($user);}*/
  3189. }
  3190. $this->em->flush();
  3191. }
  3192. if($user->hasRole('ROLE_CHEFP5') )
  3193. {
  3194. foreach($demachas as $demach)
  3195. {
  3196. if($demach->getQuantAccorde()!=null)
  3197. $total=$demach->getQuantAccorde()*$demach->getPrixU()+$total;
  3198. else
  3199. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3200. $demach->setSigneChefp5($user);
  3201. $demach->setDrapoChefp5(1);
  3202. $demach->setDrapoChefprefu5(0);
  3203. $demach->setDateChefp5(new \DateTime($dat));
  3204. /* if($user->hasRole('ROLE_RR') ){
  3205. $demach->setDrapoChefp6(1);
  3206. $demach->setDrapoChefprefu6(0);
  3207. $demach->setSigneChefp6($user);}*/
  3208. }
  3209. $em->flush();
  3210. }
  3211. if($user->hasRole('ROLE_CHEFP6') )
  3212. {
  3213. foreach($demachas as $demach)
  3214. {
  3215. if($demach->getQuantAccorde()!=null)
  3216. $total=$demach->getQuantAccorde()*$demach->getPrixU()+$total;
  3217. else
  3218. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3219. $demach->setSigneChefp6($user);
  3220. $demach->setDrapoChefp6(1);
  3221. $demach->setDrapoChefprefu6(0);
  3222. $demach->setDateChefp6(new \DateTime($dat));
  3224. }
  3225. $this->em->flush();
  3226. }
  3227. if($user->hasRole('ROLE_CHEFP7') )
  3228. {
  3229. foreach($demachas as $demach)
  3230. {
  3231. if($demach->getQuantAccorde()!=null)
  3232. $total=$demach->getQuantAccorde()*$demach->getPrixU()+$total;
  3233. else
  3234. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3235. $demach->setSigneChefp7($user);
  3236. $demach->setDrapoChefp7(1);
  3237. $demach->setDrapoChefprefu7(0);
  3238. $demach->setDateChefp7(new \DateTime($dat));
  3240. }
  3241. $this->em->flush();
  3242. }
  3243. $use=$demacha->getUser();
  3244. $emailuser=$use->getEmail();
  3245. $num=$demacha->getNumDemandeAchat();
  3246. $nom=$use->getNom();
  3247. $prenom=$use->getPrenom();
  3248. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3249. le Chef de projet a approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  3250. Suivez ce lien pour voir la demande:<br/>
  3251. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  3252. </body></html>";
  3254. if($demacha->getCostcenter()!=null){
  3256. $utils=$this->em->getRepository(User::class)->findAll();
  3257. $centrecout=$demacha->getCentreCout();
  3258. $centre = $this->em->getRepository(CentreCout::class)->findOneByLibele($centrecout);
  3259. $usecentres = $this->em->getRepository(UserCentre::class)->findByCentrecout($centre);
  3261. $code= $usecentres[0]->getCode();
  3262. $usedp=null; $usefinance=null;
  3263. if($code==13)
  3264. {
  3265. foreach ($usecentres as $usecentre)
  3266. {
  3267. if($usecentre->getUser()->hasRole('ROLE_DP'))
  3268. $usedp=$usecentre->getUser();
  3269. if($usedp!=null){
  3270. $email=$usedp->getEmail();
  3271. // $this->Envoi($email,$contenu);
  3272. }
  3273. }
  3275. }
  3276. elseif($code==61)
  3277. {
  3278. foreach ($utils as $util)
  3279. {
  3280. if($util->hasRole('ROLE_DSCSC2') and $total<2500000){
  3281. //$usefinance=$usecentre->getUser();
  3282. $email=$util->getEmail();
  3283. $this->Envoi($email,$contenu);}
  3284. if($util->hasRole('ROLE_DSCSC') and $total>2499999){
  3285. //$usefinance=$usecentre->getUser();
  3286. $email=$util->getEmail();
  3287. // $this->Envoi($email,$contenu);}
  3291. }
  3292. }
  3293. // $this->Envoi($emailuser,$contenu);
  3294. }
  3295. }
  3296. else{
  3297. foreach ($utils as $util)
  3298. {
  3299. if($util->hasRole('ROLE_RACHAT'))
  3300. {
  3302. $email=$util->getEmail();
  3303. // $this->Envoi($email,$contenu);
  3304. }
  3306. }
  3307. }
  3308. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  3310. }
  3315. }
  3317. //formulaire de confirmation du rejet d'une ligne du DA par un chef de projet
  3318. //formulaire de confirmation du rejet du DA par un chef de projet
  3320. public function rairefchefp($id): Response
  3321. {
  3322. $demach =$this->em->getRepository(demAchat::class)->find($id);
  3324. $form = $this->createFormBuilder($demach)
  3325. ->add('id')
  3326. ->add('raisonRefu')
  3327. ->getForm();
  3330. return $this->render('DemandeAchatVue/raisonrefu.html.twig'
  3331. ,['id_dem' => $id,'form' => $form->createView(),]
  3332. );
  3334. }
  3335. //rejet du DA par un chef de projet,
  3336. public function ajaxraisonrefu(Request $request): Response
  3337. {
  3338. $user = $this->security->getUser();
  3339. $id = $request->request->get('id');
  3340. $raisonRefu = $request->request->get('raison');
  3342. $demacha=$this->em->getRepository(demAchat::class)->find($id);
  3345. $dat=date('Y-m-d H:i:s');
  3346. $num= $demacha->getNumDemandeAchat();
  3347. $demachas=$this->em->getRepository(demAchat::class)->Selectnumda($num);
  3349. $use=$demacha->getUser();
  3350. $emailuser=$use->getEmail();
  3351. $num=$demacha->getNumDemandeAchat();
  3352. $nom=$use->getNom();
  3353. $prenom=$use->getPrenom();
  3356. if($user->hasRole('ROLE_CHEFP1') )
  3357. {
  3358. foreach($demachas as $demach)
  3359. {
  3360. $demach->setSigneChefp1($user);
  3361. $demach->setDrapoChefp1(0);
  3362. $demach->setDrapoChefprefu1(1);
  3363. $demach->setDateChefp1(new \DateTime($dat));
  3364. $demach->setRaisonRefu($raisonRefu);
  3367. }
  3368. $this->em->flush();
  3369. }
  3372. elseif($user->hasRole('ROLE_CHEFP2') )
  3373. {
  3374. foreach($demachas as $demach)
  3375. {
  3376. $demach->setSigneChefp2($user);
  3377. $demach->setDrapoChefp2(0);
  3378. $demach->setDrapoChefprefu2(1);
  3379. $demach->setRaisonRefu($raisonRefu);
  3380. $demach->setDateChefp2(new \DateTime($dat));
  3383. }
  3384. $this->em->flush();
  3385. }
  3386. elseif($user->hasRole('ROLE_CHEFP3') )
  3387. {
  3388. foreach($demachas as $demach)
  3389. {
  3390. $demach->setSigneChefp3($user);
  3391. $demach->setDrapoChefp3(0);
  3392. $demach->setDrapoChefprefu3(1);
  3393. $demach->setRaisonRefu($raisonRefu);
  3394. $demach->setDateChefp3(new \DateTime($dat));
  3396. }
  3397. $this->em->flush();
  3398. }
  3399. elseif($user->hasRole('ROLE_CHEFP4') )
  3400. {
  3401. foreach($demachas as $demach)
  3402. {
  3403. $demach->setSigneChefp4($user);
  3404. $demach->setDrapoChefp4(0);
  3405. $demach->setDrapoChefprefu4(1);
  3406. $demach->setRaisonRefu($raisonRefu);
  3407. $demach->setDateChefp4(new \DateTime($dat));
  3409. }
  3410. $this->em->flush();
  3411. }
  3412. elseif($user->hasRole('ROLE_CHEFP5') )
  3413. {
  3414. foreach($demachas as $demach)
  3415. {
  3416. $demach->setSigneChefp5($user);
  3417. $demach->setDrapoChefp5(0);
  3418. $demach->setRaisonRefu($raisonRefu);
  3419. $demach->setDrapoChefprefu5(1);
  3420. $demach->setDateChefp5(new \DateTime($dat));
  3422. }
  3423. $this->em->flush();
  3424. }
  3425. elseif($user->hasRole('ROLE_CHEFP6') )
  3426. {
  3427. foreach($demachas as $demach)
  3428. {
  3429. $demach->setSigneChefp6($user);
  3430. $demach->setDrapoChefp6(0);
  3431. $demach->setRaisonRefu($raisonRefu);
  3432. $demach->setDrapoChefprefu6(1);
  3433. $demach->setDateChefp6(new \DateTime($dat));
  3434. }
  3435. $this->em->flush();
  3436. }
  3437. elseif($user->hasRole('ROLE_CHEFP7') )
  3438. {
  3439. foreach($demachas as $demach)
  3440. {
  3441. $demach->setSigneChefp7($user);
  3442. $demach->setDrapoChefp7(0);
  3443. $demach->setRaisonRefu($raisonRefu);
  3444. $demach->setDrapoChefprefu7(1);
  3445. $demach->setDateChefp7(new \DateTime($dat));
  3446. }
  3447. $this->em->flush();
  3448. }
  3450. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3451. le Chef de projet n'a pas approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  3452. Suivez ce lien pour voir la demande:<br/>
  3453. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  3454. </body></html>";
  3457. //$this->Envoi($emailuser,$contenu);
  3461. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id)));
  3464. }
  3466. public function articleraisonrefu($id)
  3467. {
  3468. $demach =$this->em->getRepository(demAchat::class)->find($id);
  3470. $form = $this->createFormBuilder($demach)
  3471. ->add('id')
  3472. ->add('raisonRefu')
  3473. ->getForm();
  3476. return $this->render('DemandeAchatVue/articleraisonrefu.html.twig'
  3477. ,['id_dem' => $id,'form' => $form->createView(),]
  3478. );
  3480. }
  3482. public function ajaxarticlerefu(Request $request): Response
  3483. {
  3484. $user = $this->security->getUser();
  3485. $id = $request->request->get('id');
  3486. $raisonRefu = $request->request->get('raison');
  3488. $demacha=$this->em->getRepository(demAchat::class)->find($id);
  3489. $num= $demacha->getNumDemandeAchat();
  3491. $dat=date('Y-m-d H:i:s');
  3493. $demacha->setRaisonRefu($raisonRefu);
  3494. $demacha->setSigneChef($user);
  3495. $demacha->setDrapoRejetchef(1);
  3497. $this->em->flush();
  3498. $demachas=$this->em->getRepository(demAchat::class)->Selectnumda($num);
  3499. $idachat= $demachas[0]->getId();
  3502. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3503. le Chef de projet n'a pas approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  3504. Suivez ce lien pour voir la demande:<br/>
  3505. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  3506. </body></html>";
  3508. // $this->Envoi($emailuser,$contenu);
  3512. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $idachat)));
  3516. }
  3518. public function moduleachat(): Response
  3519. {
  3520. $id = $request->request->get('id');
  3523. $data = $this->demandeAchatService ->getdaParUser($id); // ton return actuel
  3525. return new JsonResponse($data);
  3529. }
  3534. public function uploadPieceJointe(
  3535. Request $request,
  3536. DemAchat $demAchat,
  3537. EntityManagerInterface $em
  3538. ): JsonResponse {
  3539. // ✅ Défini UNE SEULE FOIS ici
  3540. $uploadDir = $this->getParameter('kernel.project_dir') . '/public/uploads/dem_achat';
  3542. $file = $request->files->get('pieceJointe');
  3544. if (!$file) {
  3545. return $this->json(['success' => false, 'message' => 'Aucun fichier reçu.'], 400);
  3546. }
  3548. $maxSize = 5 * 1024 * 1024;
  3549. if ($file->getSize() > $maxSize) {
  3550. return $this->json(['success' => false, 'message' => 'Fichier trop volumineux. Taille max : 5 Mo.'], 422);
  3551. }
  3553. $allowedExtensions = ['pdf', 'doc', 'docx', 'xls', 'xlsx', 'png', 'jpeg', 'txt'];
  3554. $extension = strtolower($file->getClientOriginalExtension());
  3555. if (!in_array($extension, $allowedExtensions)) {
  3556. return $this->json(['success' => false, 'message' => 'Type de fichier non autorisé.'], 422);
  3557. }
  3559. $newFilename = uniqid('pj_') . '.' . $extension;
  3561. // Créer le dossier s'il n'existe pas
  3562. if (!is_dir($uploadDir)) {
  3563. mkdir($uploadDir, 0777, true);
  3564. }
  3566. // Supprimer l'ancien fichier si existant
  3567. if ($demAchat->getPieceJointe()) {
  3568. $oldFile = $uploadDir . '/' . $demAchat->getPieceJointe();
  3569. if (file_exists($oldFile)) unlink($oldFile);
  3570. }
  3572. try {
  3573. $file->move($uploadDir, $newFilename);
  3574. } catch (\Exception $e) {
  3575. return $this->json(['success' => false, 'message' => 'Erreur lors de l\'upload : ' . $e->getMessage()], 500);
  3576. }
  3578. $demAchat->setPieceJointe($newFilename);
  3579. $em->flush();
  3581. return $this->json([
  3582. 'success' => true,
  3583. 'message' => 'Fichier uploadé avec succès.',
  3584. 'filename' => $newFilename,
  3585. 'downloadUrl' => '/uploads/dem_achat/' . $newFilename,
  3586. ]);
  3587. }
  3591. public function ajaxdrapodp(Request $request): Response
  3592. {
  3593. $data = $this->demandeAchatService->getDemachatSigneData($request);
  3594. $demachas = $data['demachas'];
  3595. $id_achat = $data['id_achat'];
  3596. $use = $data['user'];
  3597. $demacha = $data['demacha'];
  3598. $dat = $data['dat'];
  3602. // $iduser=$user->getId();
  3603. $total=0;
  3604. $totalprix=0;
  3605. if($use->hasRole('ROLE_DP1') )
  3606. {
  3607. foreach($demachas as $demach){
  3608. $demach->setSigneDP1($use);
  3609. $demach->setDrapoDP1(1);
  3610. $demach->setDrapoDPrefu1(0);
  3611. $demach->setDateDP1(new \DateTime($dat));
  3612. if($demach->getQuantAccorde() != null)
  3613. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3614. else
  3615. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3616. $this->em->persist($demach);}
  3617. $this->em->flush();
  3618. }
  3619. elseif($use->hasRole('ROLE_DP2') )
  3620. {
  3621. foreach($demachas as $demach){
  3622. $demach->setSigneDP2($use);
  3623. $demach->setDrapoDP2(1);
  3624. $demach->setDrapoDPrefu2(0);
  3625. $demach->setDateDP2(new \DateTime($dat));
  3626. if($demach->getQuantAccorde() != null)
  3627. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3628. else
  3629. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3630. $this->em->persist($demach);}
  3631. $this->em->flush();
  3632. }
  3633. elseif($use->hasRole('ROLE_DP3') )
  3634. {
  3635. foreach($demachas as $demach){
  3636. $demach->setSigneDP3($use);
  3637. $demach->setDrapoDP3(1);
  3638. $demach->setDrapoDPrefu3(0);
  3639. $demach->setDateDP3(new \DateTime($dat));
  3640. if($demach->getQuantAccorde() != null)
  3641. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3642. else
  3643. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3644. $this->em->persist($demach);}
  3645. $this->em->flush();
  3646. }
  3647. elseif($use->hasRole('ROLE_DP4') )
  3648. {
  3649. foreach($demachas as $demach){
  3650. $demach->setSigneDP4($use);
  3651. $demach->setDrapoDP4(1);
  3652. $demach->setDrapoDPrefu4(0);
  3653. $demach->setDateDP4(new \DateTime($dat));
  3654. if($demach->getQuantAccorde() != null)
  3655. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3656. else
  3657. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3658. $this->em->persist($demach);}
  3659. $this->em->flush();
  3660. }
  3662. elseif($use->hasRole('ROLE_DP5') )
  3663. {
  3664. foreach($demachas as $demach){
  3665. $demach->setSigneDP5($use);
  3666. $demach->setDrapoDP5(1);
  3667. $demach->setDrapoDPrefu5(0);
  3668. $demach->setDateDP5(new \DateTime($dat));
  3669. if($demach->getQuantAccorde() != null)
  3670. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3671. else
  3672. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3673. $this->em->persist($demach);}
  3674. $this->em->flush();
  3675. }
  3676. elseif($use->hasRole('ROLE_DP6') )
  3677. {
  3678. foreach($demachas as $demach){
  3679. $demach->setSigneDP6($use);
  3680. $demach->setDrapoDP6(1);
  3681. $demach->setDrapoDPrefu6(0);
  3682. $demach->setDateDP6(new \DateTime($dat));
  3683. if($demach->getQuantAccorde() != null)
  3684. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3685. else
  3686. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3687. $this->em->persist($demach);}
  3688. $this->em->flush();
  3689. }
  3690. elseif($use->hasRole('ROLE_DP7') )
  3691. {
  3692. foreach($demachas as $demach){
  3693. $demach->setSigneDP7($use);
  3694. $demach->setDrapoDP7(1);
  3695. $demach->setDrapoDPrefu7(0);
  3696. $demach->setDateDP7(new \DateTime($dat));
  3697. if($demach->getQuantAccorde() != null)
  3698. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3699. else
  3700. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3701. $this->em->persist($demach);}
  3702. $this->em->flush();
  3703. }
  3704. elseif($use->hasRole('ROLE_DP8') )
  3705. {
  3706. foreach($demachas as $demach){
  3707. $demach->setSigneDP8($use);
  3708. $demach->setDrapoDP8(1);
  3709. $demach->setDrapoDPrefu8(0);
  3710. $demach->setDateDP8(new \DateTime($dat));
  3711. if($demach->getQuantAccorde() != null)
  3712. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3713. else
  3714. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3715. $this->em->persist($demach);}
  3716. $this->em->flush();
  3717. }
  3718. /*$user=$demacha->getUser();
  3719. $emailuser=$user->getEmail();
  3720. $num=$demacha->getNumDemandeAchat();
  3721. $nom=$user->getNom();
  3722. $suphemail=$user->getSupH()->getEmail();
  3723. $prenom=$user->getPrenom();
  3724. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3725. le Directeur des Département a approuv&eacute la demande d'achat N&deg$num de Mrs/Mr $nom $prenom<br/><br/>
  3726. Suivez ce lien pour voir la demande:<br/>
  3727. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  3728. </body></html>";
  3730. $utils=$em->getRepository('mstopeUserBundle:User')->findAll();
  3732. $centrecout=$demacha->getCentreCout();
  3733. $nomProjet=$demacha->getNomProjet();
  3734. $baille = $em->getRepository('mstopeIntranetBundle:Bailleur')->findOneByLibele($nomProjet);
  3735. $bailleur = $em->getRepository('mstopeIntranetBundle:UseBailleur')->findOneByBailleur($baille);
  3736. $centre = $em->getRepository('mstopeIntranetBundle:CentreCout')->findOneByLibele($centrecout);
  3737. $usecentres = $em->getRepository('mstopeIntranetBundle:UserCentre')->findByCentrecout($centre);
  3738. $code= $usecentres[0]->getCode();
  3739. $usedp=null; $usefinance=null;
  3741. if($code==13)
  3742. {
  3743. foreach ($utils as $util)
  3744. {
  3747. if($util->hasRole('ROLE_DSCSC2') and $totalprix < 2500000)
  3748. {
  3750. $email=$util->getEmail();
  3751. //$this->Envoi($email,$contenu);
  3752. }
  3754. if($util->hasRole('ROLE_DSCSC') and $totalprix >2499999)
  3755. {
  3757. $email=$util->getEmail();
  3758. // $this->Envoi($email,$contenu);
  3759. }
  3761. }
  3762. }
  3763. if($code==61)
  3764. {
  3765. if($bailleur!=null){
  3766. $chefprojet=$bailleur->getUser();
  3767. $email=$chefprojet->getEmail();
  3768. // $this->Envoi($email,$contenu);
  3769. }
  3770. }
  3771. */
  3773. // $this->Envoi($emailuser,$contenu);
  3775. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  3778. }
  3780. public function ajaxdrapodprefu(Request $request): Response
  3781. {
  3783. $data = $this->demandeAchatService->getDemachatSigneData($request);
  3784. $demachas = $data['demachas'];
  3785. $id_achat = $data['id_achat'];
  3786. $user = $data['user'];
  3787. $demacha = $data['demacha'];
  3788. $dat = $data['dat'];
  3792. // $iduser=$user->getId();
  3793. $total=0;
  3794. $totalprix=0;
  3795. if($user->hasRole('ROLE_DP1') )
  3796. {
  3797. foreach($demachas as $demach){
  3798. $demach->setSigneDP1($user);
  3799. $demach->setDrapoDP1(0);
  3800. $demach->setDrapoDPrefu1(1);
  3801. $demach->setDateDP1(new \DateTime($dat));
  3802. $this->em->persist($demach);}
  3803. $this->em->flush();
  3804. }
  3805. elseif($user->hasRole('ROLE_DP2') )
  3806. {
  3807. foreach($demachas as $demach){
  3808. $demach->setSigneDP2($user);
  3809. $demach->setDrapoDP2(0);
  3810. $demach->setDrapoDPrefu2(1);
  3811. $demach->setDateDP2(new \DateTime($dat));
  3812. $this->em->persist($demach);}
  3813. $this->em->flush();
  3814. }
  3815. elseif($user->hasRole('ROLE_DP3') )
  3816. {
  3817. foreach($demachas as $demach){
  3818. $demach->setSigneDP3($user);
  3819. $demach->setDrapoDP3(0);
  3820. $demach->setDrapoDPrefu3(1);
  3821. $demach->setDateDP3(new \DateTime($dat));
  3822. $this->em->persist($demach);}
  3823. $this->em->flush();
  3824. }
  3825. elseif($user->hasRole('ROLE_DP4') )
  3826. {
  3827. foreach($demachas as $demach){
  3828. $demach->setSigneDP4($use);
  3829. $demach->setDrapoDP4(0);
  3830. $demach->setDrapoDPrefu4(1);
  3831. $demach->setDateDP4(new \DateTime($dat));
  3832. $this->em->persist($demach);}
  3833. $this->em->flush();
  3834. }
  3835. elseif($user->hasRole('ROLE_DP5') )
  3836. {
  3837. foreach($demachas as $demach){
  3838. $demach->setSigneDP5($user);
  3839. $demach->setDrapoDP5(0);
  3840. $demach->setDrapoDPrefu5(1);
  3841. $demach->setDateDP5(new \DateTime($dat));
  3842. $this->em->persist($demach);}
  3843. $this->em->flush();
  3844. }
  3845. elseif($user->hasRole('ROLE_DP6') )
  3846. {
  3847. foreach($demachas as $demach){
  3848. $demach->setSigneDP6($user);
  3849. $demach->setDrapoDP6(0);
  3850. $demach->setDrapoDPrefu6(1);
  3851. $demach->setDateDP6(new \DateTime($dat));
  3852. $this->em->persist($demach);}
  3853. $this->em->flush();
  3854. }
  3855. elseif($user->hasRole('ROLE_DP7') )
  3856. {
  3857. foreach($demachas as $demach){
  3858. $demach->setSigneDP7($user);
  3859. $demach->setDrapoDP7(0);
  3860. $demach->setDrapoDPrefu7(1);
  3861. $demach->setDateDP7(new \DateTime($dat));
  3862. $this->em->persist($demach);}
  3863. $this->em->flush();
  3864. }
  3865. elseif($user->hasRole('ROLE_DP8') )
  3866. {
  3867. foreach($demachas as $demach){
  3868. $demach->setSigneDP8($user);
  3869. $demach->setDrapoDP8(0);
  3870. $demach->setDrapoDPrefu8(1);
  3871. $demach->setDateDP8(new \DateTime($dat));
  3872. $this->em->persist($demach);}
  3873. $this->em->flush();
  3874. }
  3876. /* $user=$demacha->getUser();
  3877. $emailuser=$user->getEmail();
  3878. $num=$demacha->getNumDemandeAchat();
  3879. $nom=$user->getNom();
  3880. $suphemail=$user->getSupH()->getEmail();
  3881. $prenom=$user->getPrenom();
  3882. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3883. le Directeur de Département n'a pas approuv&eacute la demande d'achat N&deg$num
  3884. de Mrs/Mr $nom $prenom<br/><br/>
  3885. Suivez ce lien pour voir la demande:<br/>
  3887. </body></html>";*/
  3889. //$this->Envoi($suphemail,$contenu);
  3890. //$this->Envoi($emailuser,$contenu);
  3892. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  3898. }
  3900. public function ajaxdrapodscsc(Request $request): Response
  3901. {
  3903. $data = $this->demandeAchatService->getDemachatSigneData($request);
  3904. $demachas = $data['demachas'];
  3905. $id_achat = $data['id_achat'];
  3906. $user = $data['user'];
  3907. $demacha = $data['demacha'];
  3908. $dat = $data['dat'];
  3910. $totalprix=0;
  3911. $dat=date('Y-m-d H:i:s');
  3914. foreach($demachas as $demach)
  3915. {
  3916. $demach->setSigneDF($user);
  3917. $demach->setDrapoDSCSC(1);
  3918. $demach->setDrapoDSCSCrefu(0);
  3919. $demach->setDateDSCSC(new \DateTime($dat));
  3920. if($demach->getQuantAccorde()!=null)
  3921. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3922. else
  3923. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3924. $this->em->persist($demach);
  3925. }
  3926. $this->em->flush();
  3928. /* $user=$demacha->getUser();
  3929. $emailuser=$user->getEmail();
  3930. $num=$demacha->getNumDemandeAchat();
  3931. $nom=$user->getNom();
  3932. $suphemail=$user->getSupH()->getEmail();
  3933. $prenom=$user->getPrenom();
  3934. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3935. le Directeur des Finances a approuv&eacute la demande d'achat N&deg$num de Mrs/Mr $nom $prenom<br/><br/>
  3936. Suivez ce lien pour voir la demande:<br/>
  3938. </body></html>";
  3939. $contenu2="<html><head></head><body><b>Bonjour</b>,<br/>
  3940. la Finance a approuv&eacute la demande d'achat N&deg$num de Mrs/Mr $nom $prenom<br/><br/>
  3941. la demande est prete pour l'impression<br/><br/>
  3942. Suivez ce lien pour voir la demande:<br/>
  3944. </body></html>";
  3946. $users=$em->getRepository('mstopeUserBundle:User')->findAll();
  3947. foreach ($users as $use)
  3948. {
  3949. if($use->hasRole('ROLE_RR') and $demacha->getMontant() > 4999999)
  3950. {
  3952. $emaildest=$use->getEmail();
  3953. $this->Envoi($emaildest,$contenu);
  3955. }
  3958. if($use->hasRole('ROLE_RACHAT') and $demacha->getMontant() < 4999999)
  3959. {
  3960. $emailachat=$use->getEmail();
  3961. $this->Envoi($emailuser,$contenu2);
  3962. $this->Envoi($emailachat,$contenu2);
  3963. }
  3965. }
  3967. */
  3969. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  3974. }
  3976. public function ajaxdrapodscscrefu(Request $request): Response
  3977. {
  3978. $data = $this->demandeAchatService->getDemachatSigneData($request);
  3979. $demachas = $data['demachas'];
  3980. $id_achat = $data['id_achat'];
  3981. $user = $data['user'];
  3982. $demacha = $data['demacha'];
  3983. $dat = $data['dat'];
  3985. $totalprix=0;
  3986. $dat=date('Y-m-d H:i:s');
  3988. foreach($demachas as $demach){
  3989. $demach->setSigneDF($user);
  3990. $demach->setDrapoDSCSC(0);
  3991. $demach->setDrapoDSCSCrefu(1);
  3992. $demach->setDateDSCSC(new \DateTime($dat));
  3995. $this->em->persist($demach);}
  3996. $this->em->flush();
  3997. /* $user=$demacha->getUser();
  3998. $emailuser=$user->getEmail();
  3999. $num=$demacha->getNumDemandeAchat();
  4000. $nom=$user->getNom();
  4001. $suphemail=$user->getSupH()->getEmail();
  4002. $prenom=$user->getPrenom();
  4003. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  4004. la Finance n'a pas approuv&eacute la demande d'achat N&deg$num de Mrs/Mr $nom $prenom<br/><br/>
  4005. Suivez ce lien pour voir la demande:<br/>
  4007. </body></html>";
  4009. $users=$em->getRepository('mstopeUserBundle:User')->findAll();
  4010. foreach ($users as $use)
  4011. {
  4012. if($use->hasRole('ROLE_RR')){
  4013. //if($use->hasRole('ROLE_ADMIN')){
  4014. $emaildest=$use->getEmail();
  4015. $this->Envoi($emaildest,$contenu);
  4016. }
  4017. }
  4018. $this->Envoi($suphemail,$contenu);
  4019. $this->Envoi($emailuser,$contenu);*/
  4022. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  4026. }
  4029. public function ajaxdraporr(Request $request): Response
  4030. {
  4031. $data = $this->demandeAchatService->getDemachatSigneData($request);
  4032. $demachas = $data['demachas'];
  4033. $id_achat = $data['id_achat'];
  4034. $user = $data['user'];
  4035. $demacha = $data['demacha'];
  4036. $dat = $data['dat'];
  4038. $totalprix=0;
  4039. $dat=date('Y-m-d H:i:s');
  4041. foreach($demachas as $demacha){
  4042. $demacha->setSigneRR($user);
  4043. $demacha->setDrapoRR(1);
  4044. $demacha->setDrapoRRrefu(0);
  4045. $demacha->setDrapoImp(1);
  4046. $demacha->setDateRR(new \DateTime($dat));
  4047. $this->em->persist($demacha);}
  4048. $this->em->flush();
  4050. /* $user=$demacha->getUser();
  4051. $emailuser=$user->getEmail();
  4052. $num=$demacha->getNumDemandeAchat();
  4053. $nom=$user->getNom();
  4054. $suphemail=$user->getSupH()->getEmail();
  4055. $prenom=$user->getPrenom();
  4056. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  4057. le Repr&eacutesentant R&eacutesident a approuv&eacute la demande d'achat N&deg$num
  4058. de Mrs/Mr $nom $prenom<br/>
  4059. <br/>
  4060. La demande est pr&ecircte pour impression!
  4061. <br/><br/>
  4062. Suivez ce lien pour voir la demande:<br/>
  4064. </body></html>";
  4066. $users=$em->getRepository('mstopeUserBundle:User')->findAll();
  4067. foreach ($users as $use)
  4068. {
  4069. if( $use->hasRole('ROLE_RACHAT')){
  4070. // if($use->hasRole('ROLE_ADMIN')){
  4071. $emaildest=$use->getEmail();
  4072. $this->Envoi($emaildest,$contenu);
  4073. }
  4074. }
  4075. // $this->Envoi($suphemail,$contenu);
  4076. $this->Envoi($emailuser,$contenu);*/
  4078. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  4082. }
  4085. public function ajaxdraporrrefu(Request $request): Response
  4086. {
  4087. $data = $this->demandeAchatService->getDemachatSigneData($request);
  4088. $demachas = $data['demachas'];
  4089. $id_achat = $data['id_achat'];
  4090. $user = $data['user'];
  4091. $demacha = $data['demacha'];
  4092. $dat = $data['dat'];
  4094. foreach($demachas as $demacha){
  4095. $demacha->setSigneRR($user);
  4096. $demacha->setDrapoRR(0);
  4097. $demacha->setDrapoRRrefu(1);
  4098. $demacha->setDateRR(new \DateTime($dat));
  4100. //$demacha->setDrapoRR(0);
  4101. //$demacha->setDrapoRRrefu(1);
  4102. $this->em->persist($demacha);}
  4103. $this->em->flush();
  4104. /*
  4105. $user=$demacha->getUser();
  4106. $emailuser=$user->getEmail();
  4107. $num=$demacha->getNumDemandeAchat();
  4108. $nom=$user->getNom();
  4109. $prenom=$user->getPrenom();
  4110. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  4111. le Repr&eacutesentant R&eacutesident n'a pas approuv&eacute la demande d'achat N&deg$num
  4112. de Mrs/Mr $nom $prenom<br/>
  4113. <br/>
  4115. Suivez ce lien pour voir la demande:<br/>
  4117. </body></html>";
  4119. $users=$em->getRepository('mstopeUserBundle:User')->findAll();
  4120. foreach ($users as $use)
  4121. {
  4122. if($use->hasRole('ROLE_ADMIN')){
  4123. //if($use->hasRole('ROLE_ADMIN')){
  4124. $emaildest=$use->getEmail();
  4125. $this->Envoi($emaildest,$contenu);
  4126. }
  4127. }
  4128. // $this->Envoi($suphemail,$contenu);
  4129. $this->Envoi($emailuser,$contenu);*/
  4131. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  4137. }
  4139. public function ajaxlistnum4( Request $request): JsonResponse
  4140. {
  4141. // Tableau de réponse
  4142. $listnum4 = [];
  4146. // Récupérer l'id envoyé
  4147. $id = $request->request->get('id');
  4149. // Récupérer l'utilisateur
  4150. $user = $this->em->getRepository(User::class)->find($id);
  4154. // Récupérer les demandes d'achat
  4155. $dems = $this->em->getRepository(demAchat::class) ->SelectListdemachat($user);
  4157. // Valeur par défaut
  4158. $listnum4[0] = 'choisir';
  4160. // Remplir le tableau
  4161. foreach ($dems as $dem) {
  4162. $listnum4[$dem->getId()] = $dem->getNumDemandeAchat();
  4163. }
  4167. // Retour JSON
  4168. return new JsonResponse($listnum4);
  4169. }
  4171. public function ajaxlistnum6( Request $request): JsonResponse
  4172. {
  4173. // Tableau de réponse
  4174. $listnum6 = [];
  4177. $dems=array();
  4178. // Récupérer l'id envoyé
  4179. $id = $request->request->get('id');
  4181. // Récupérer l'utilisateur
  4182. $useb = $this->em->getRepository(UseBailleur::class)->find($id);
  4184. $bail=$useb->getBailleur();
  4186. // Récupérer les demandes d'achat
  4187. $dems = $this->em->getRepository(demAchat::class) ->listDemachatBail($bail);
  4189. // Valeur par défaut
  4190. $listnum6[0] = 'choisir';
  4192. // Remplir le tableau
  4193. foreach ($dems as $dem) {
  4194. $listnum6[$dem->getId()] = $dem->getNumDemandeAchat();
  4195. }
  4199. // Retour JSON
  4200. return new JsonResponse($listnum6);
  4201. }
  4204. public function ajaxmodifcontracadre($id_dem)
  4205. {
  4207. $demac = $this->em->getRepository(demAchat::class)->find($id_dem);
  4210. // ============================
  4211. // Contrats compatibles
  4212. // ============================
  4214. $contratsDisponibles = [];
  4216. $categorieCatalogue =
  4217. $demac->getCatalogue()?->getCategorycatalogue();
  4219. if ($categorieCatalogue) {
  4221. foreach ( $categorieCatalogue->getCategoriesMarche()as $categorieMarche) {
  4222. $v=0;
  4223. $contrats = $this->em
  4224. ->getRepository(ContratCadre::class)
  4225. ->createQueryBuilder('cc')
  4226. ->where('cc.categorieMarche = :cat')
  4227. ->andWhere('cc.actif = true')
  4228. ->setParameter('cat', $categorieMarche)
  4229. ->orderBy('cc.reference', 'ASC')
  4230. ->getQuery()
  4231. ->getResult();
  4233. foreach ($contrats as $cc) {
  4235. $contratsDisponibles[$cc->getId()] = $cc;
  4237. }
  4238. }
  4239. }
  4241. $contratsDisponibles = array_values($contratsDisponibles);
  4242. // ============================
  4243. // Formulaire
  4244. // ============================
  4246. $form = $this->createFormBuilder($demac)
  4247. ->add('id', HiddenType::class)
  4248. ->add('contratCadre', EntityType::class, [
  4249. 'class' => ContratCadre::class,
  4251. 'choices' => $contratsDisponibles,
  4253. 'choice_label' => function ($cc) {
  4255. return sprintf(
  4256. '%s - %s',
  4257. $cc->getReference(),
  4258. $cc->getFournisseur()?->getRaisonSociale()
  4259. );
  4260. },
  4262. 'placeholder' => 'Aucun contrat-cadre',
  4264. 'required' => false,
  4265. ])
  4267. ->getForm();
  4269. return $this->render('DemandeAchatVue/ajaxmodifcontracadre.html.twig'
  4270. ,['id_dem' => $id_dem,'form' => $form->createView(),]
  4271. );
  4272. }
  4274. public function modifcontracadre(Request $request): Response
  4275. {
  4277. $idContrat = $request->request->get('contrat');
  4278. $idDemande = $request->request->get('id');
  4280. $demacha = $this->em
  4281. ->getRepository(demAchat::class)
  4282. ->find($idDemande);
  4284. if (!$demacha) {
  4286. return new JsonResponse([
  4287. 'success' => false,
  4288. 'message' => 'Demande achat introuvable.'
  4289. ]);
  4290. }
  4292. // =========================
  4293. // Ancien contrat
  4294. // =========================
  4296. $ancienContrat = $demacha->getContratCadre();
  4298. // =========================
  4299. // Nouveau contrat
  4300. // =========================
  4302. $nouveauContrat = null;
  4304. if (!empty($idContrat)) {
  4306. $nouveauContrat = $this->em
  4307. ->getRepository(ContratCadre::class)
  4308. ->find($idContrat);
  4310. if (!$nouveauContrat) {
  4312. return new JsonResponse([
  4313. 'success' => false,
  4314. 'message' => 'Contrat-cadre introuvable.'
  4315. ]);
  4316. }
  4317. }
  4319. // =========================
  4320. // Calcul montant réservation
  4321. // =========================
  4323. $montantLigne =
  4324. (float)$demacha->getPrixU()
  4325. *
  4326. (float)$demacha->getQuantDemande();
  4328. // TVA éventuelle
  4329. if ($demacha->getTva()) {
  4331. $montantLigne +=
  4332. $montantLigne
  4333. *
  4334. ((float)$demacha->getTva() / 100);
  4335. }
  4337. // =========================
  4338. // Retirer réservation ancien contrat
  4339. // =========================
  4341. if ($ancienContrat) {
  4343. $ancienReserve =
  4344. (float)$ancienContrat->getMontantReserve();
  4346. $ancienContrat->setMontantReserve(
  4347. (string)max(
  4348. 0,
  4349. $ancienReserve - $montantLigne
  4350. )
  4351. );
  4353. $this->em->persist($ancienContrat);
  4354. }
  4356. // =========================
  4357. // Ajouter réservation nouveau contrat
  4358. // =========================
  4360. if ($nouveauContrat) {
  4362. $nouveauReserve =
  4363. (float)$nouveauContrat->getMontantReserve();
  4365. $nouveauContrat->setMontantReserve(
  4366. (string)($nouveauReserve + $montantLigne)
  4367. );
  4369. $this->em->persist($nouveauContrat);
  4370. }
  4372. // =========================
  4373. // Mise à jour DA
  4374. // =========================
  4376. $demacha->setContratCadre($nouveauContrat);
  4378. // statut contrat
  4379. if ($nouveauContrat) {
  4381. $demacha->setStatutContratCadree(
  4382. demAchat::CC_VALIDE
  4383. );
  4385. } else {
  4387. $demacha->setStatutContratCadree(null);
  4388. }
  4390. $this->em->persist($demacha);
  4392. // =========================
  4393. // Save
  4394. // =========================
  4396. $this->em->flush();
  4398. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $idDemande)));
  4400. }
  4402. public function supprimeracha($id)
  4403. {
  4405. $demac = $this->em->getRepository(demAchat::class)->find($id);
  4407. $form = $this->createFormBuilder($demac)
  4408. ->add('id', HiddenType::class) ->getForm();
  4410. return $this->render('DemandeAchatVue/supprimeracha.html.twig'
  4411. ,['id' => $id,'form' => $form->createView(),]
  4412. );
  4413. }
  4415. public function ajaxsupprimeracha(Request $request): Response
  4416. {
  4419. $idDemande = $request->request->get('id');
  4421. $demacha = $this->em
  4422. ->getRepository(demAchat::class)
  4423. ->find($idDemande);
  4424. $num=$demacha->getNumDemandeAchat();
  4425. if (!$demacha) {
  4427. return new JsonResponse([
  4428. 'success' => false,
  4429. 'message' => 'Demande achat introuvable.'
  4430. ]);
  4431. }
  4433. // =========================
  4434. // Ancien contrat
  4435. // =========================
  4437. $ancienContrat = $demacha->getContratCadre();
  4440. // =========================
  4441. // Calcul montant réservation
  4442. // =========================
  4444. $montantLigne =
  4445. (float)$demacha->getPrixU()
  4446. *
  4447. (float)$demacha->getQuantDemande();
  4449. // TVA éventuelle
  4450. if ($demacha->getTva()) {
  4452. $montantLigne +=
  4453. $montantLigne
  4454. *
  4455. ((float)$demacha->getTva() / 100);
  4456. }
  4458. // =========================
  4459. // Retirer réservation ancien contrat
  4460. // =========================
  4462. if ($ancienContrat) {
  4464. $ancienReserve =
  4465. (float)$ancienContrat->getMontantReserve();
  4467. $ancienContrat->setMontantReserve(
  4468. (string)max(
  4469. 0,
  4470. $ancienReserve - $montantLigne
  4471. )
  4472. );
  4474. $this->em->persist($ancienContrat);
  4475. }
  4478. $this->em->remove($demacha);
  4479. //$this->em->persist($demacha);
  4481. // =========================
  4482. // Save
  4483. // =========================
  4485. $this->em->flush();
  4487. $demacha = $this->em
  4488. ->getRepository(demAchat::class)
  4489. ->findOneByNumDemandeAchat($num);
  4491. return $this->redirect( $this->generateUrl('liste_demachat', array('id' =>$demacha ->getId())));
  4493. }
  4496. }