src/Controller/DemandeAchatController.php line 460

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\Repository\DemAchatTempRepository;
  13. use App\Service\DemandeAchatService;
  14. use App\Service\ExcelImportService;
  15. use App\Service\ContratCadreService;
  16. use App\Service\TranslationWriter;
  17. use App\Service\PlanAchatBudgetService;
  18. use App\Service\RejectionService;
  19. use PhpOffice\PhpSpreadsheet\IOFactory;
  20. use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
  21. use Twig\Environment;
  22. use Dompdf\Dompdf;
  23. use Symfony\Component\Form\Extension\Core\Type\FileType;
  24. use Symfony\Component\Form\Extension\Core\Type\TextType;
  25. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  26. use Symfony\Component\Form\Extension\Core\Type\IntegerType;
  27. use Symfony\Component\Form\Extension\Core\Type\HiddenType;
  28. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  29. use App\Form\demAchatType;
  30. use App\Form\ModifDemAchatType;
  31. use App\Form\DemAchatAddItemType;
  32. use App\Form\RegistrationFormType;
  33. use App\Form\PPMdemAchatType;
  34. use App\Entity\User;
  35. use App\Entity\Parametre;
  36. use App\Entity\NumDA;
  37. use App\Entity\demAchat;
  38. use App\Entity\RapportageDA;
  39. use App\Entity\DemAchatTemp;
  40. use App\Entity\Approb;
  41. use App\Entity\Bailleur;
  42. use App\Entity\UseBailleur;
  43. use App\Entity\CategoryCatalogue;
  44. use App\Entity\CommandeAchat;
  45. use App\Entity\Catalogue;
  46. use App\Entity\SupH;
  47. use App\Entity\Image;
  48. use App\Entity\ImageS;
  49. use App\Form\BonImageType;
  50. use App\Form\ImageSType;
  51. use App\Entity\demPaiement;
  52. use App\Entity\UserCentre;
  53. use App\Entity\CentreCout;
  54. use App\Entity\ReviewTec;
  55. use App\Entity\CategorieMarche;
  56. use App\Entity\ContratCadre;
  58. class DemandeAchatController extends AbstractController
  59. {
  61. // Le constructeur prend tous les services en paramètre
  62. public function __construct(
  63. private TranslationWriter $translationWriter,
  64. private EntityManagerInterface $em,
  65. private Security $security,
  66. private DemandeAchatService $demandeAchatService,
  67. private EmailService $emailService,
  68. private ExcelImportService $excelImportService,
  69. private Environment $twig,
  70. private ContratCadreService $contratCadreService,
  71. private PlanAchatBudgetService $planBudgetService,
  72. private RejectionService $rejectionService,
  74. ) {
  76. }
  79. public function updateData(Request $request, EntityManagerInterface $em): JsonResponse
  80. {
  81. $input = $request->request->get('input');
  82. // Récupération de l'utilisateur connecté via le contexte de sécurité
  83. $user = $this->security->getUser();
  85. // 1. Récupérer la DA active (le brouillon) de l'utilisateur
  86. $demtempuses = $em->getRepository(DemAchatTemp::class)->findByUser($user);
  87. $dernierBrouillon = end($demtempuses); // Le brouillon en cours
  89. $qb = $em->createQueryBuilder()
  90. ->select('c.id,c.designation')
  91. ->from(Catalogue::class, 'c');
  93. // 2. FILTRE : Si le brouillon a déjà un catalogue (article)
  94. if ($dernierBrouillon && $dernierBrouillon->getCatalogue()) {
  95. $catId = $dernierBrouillon->getCatalogue()->getCategorycatalogue()->getId();
  97. $qb->where('c.categorycatalogue = :catId')
  98. ->setParameter('catId', $catId);
  99. }
  101. // 3. RECHERCHE : Application du LIKE sur la désignation
  102. $qb->andWhere('c.designation LIKE :input')
  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 = $qb->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']);
  114. $countryList .= '<span id="li">
  115. <li class="ui-menu-item"
  116. id="'.$result['designation'].'"
  117. data-id="'.$result['id'].'"
  118. data-designation="'.$result['designation'].'">
  119. <span id="bol">'.$matchStringBold.'</span>
  120. </li>
  121. </span>';
  122. }
  123. $countryList .= '</ul>';
  125. return new JsonResponse(['countryList' => $countryList]);
  126. }
  132. public function gestionDemandeAchat(Request $request): Response
  133. {
  134. $user = $this->security->getUser();
  135. $list_demAcha = [];
  136. $list_demAcha2 = [];
  138. $demAchat = new demAchat;
  140. $usersel=new User;
  141. $data = $this->demandeAchatService->getValidationData();
  142. $admin = $data['admin'];
  143. $list_demAchaall = $data['list_demAchaall'];
  144. $list_demAchavalide = $data['list_demAchavalide'];
  145. $list_demAchauser = $data['list_demAchauser'];
  146. $list_demAcharefuse = $data['list_demAcharefuse'];
  147. $list_demAcha1 = $data['list_demAcha1'];
  148. $list_demAcha3 = $data['list_demAcha3'];
  149. $list_demAcha = $data['list_demAcha'];
  150. $list_demAcha2 = $data['list_demAcha2'];
  151. $list_use = $data['list_use'];
  152. $list_useb = $data['list_useb'];
  153. $list_demAchaval = $data['list_demAchaval'];
  154. $nbdarejet = $data['nbdarejet'];
  155. $nballda = $data['nballda'];
  156. $nbdavalid = $data['nbdavalid'];
  157. $nbdanivo = $data['nbdanivo'];
  158. $nbmesda = $data['nbmesda'];
  160. $form = $this->createForm(demAchatType::class);
  161. $form3 = $this->createForm(DemAchatAddItemType::class);
  162. $form33 = $this->createForm(PPMdemAchatType::class);
  164. $form2 = $this->createFormBuilder()
  165. ->add('listnum', ChoiceType::class, [
  166. 'label' => 'Toute DA',
  167. 'choices' => $list_demAchaall,
  168. 'required' => false,
  169. 'mapped' => false,
  170. 'placeholder'=>'Toute DA',
  171. ])
  172. ->getForm();
  174. $form5 = $this->createFormBuilder()
  175. ->add('listnum3', ChoiceType::class, [
  176. 'label' => 'DA que j\'ai validé',
  177. 'choices' => $list_demAchavalide,
  178. 'required' => false,
  179. 'mapped' => false,
  180. 'placeholder'=>'choisir',
  181. ])
  182. ->getForm();
  184. $form7 = $this->createFormBuilder()
  185. ->add('listnum7', ChoiceType::class, [
  186. 'label' => 'DA rejeté',
  187. 'choices' => $list_demAcharefuse,
  188. 'required' => false,
  189. 'mapped' => false,
  190. 'placeholder'=>'choisir',
  191. ])
  192. ->getForm();
  194. $form9 = $this->createFormBuilder()
  195. ->add('listnum9', ChoiceType::class, [
  196. 'label' => 'Mes DA',
  197. 'choices' => $list_demAchauser,
  198. 'required' => false,
  199. 'mapped' => false,
  200. 'placeholder'=>'choisir',
  201. ])
  202. ->getForm();
  205. $form4 = $this->createFormBuilder()
  206. ->add('listnum2', ChoiceType::class, [
  207. 'label' => 'DA à valider',
  208. 'choices' => $list_demAcha2,
  209. 'required' => false,
  210. 'mapped' => false,
  211. 'placeholder'=>'choisir',
  212. ])
  213. ->getForm();
  215. $form1 = $this->createFormBuilder()
  216. ->add('listnum1', ChoiceType::class, [
  217. 'label' => 'DA valider non pris en charge',
  218. 'choices' => $list_demAcha1,
  219. 'required' => false,
  220. 'mapped' => false,
  221. 'placeholder'=>'DA valider non pris en charge',
  222. ])
  223. ->getForm();
  225. $form10 = $this->createFormBuilder()
  226. ->add('listnum5', ChoiceType::class, [
  227. 'label' => 'DA pris en charge',
  228. 'choices' => $list_demAcha3,
  229. 'required' => false,
  230. 'mapped' => false,
  231. 'placeholder'=>'DA pris en charge',
  232. ])
  233. ->getForm();
  235. $form6 = $this->createFormBuilder()
  236. ->add('user', ChoiceType::class, [
  237. 'label' => 'utilisateur',
  238. 'choices' => $list_use,
  239. 'required' => false,
  240. 'mapped' => false,
  241. 'placeholder'=> 'choisir un utilisateur',
  242. ])
  244. ->add('listnum4', ChoiceType::class, [
  245. 'label' => '',
  246. 'choices' => [], // Le tableau est vide
  247. 'required' => false,
  248. 'mapped' => false, // Important si ce champ n'est pas lié à une entité
  249. 'placeholder'=>'Liste DA /utilisateur',
  250. ])
  251. ->getForm();
  253. $form8 = $this->createFormBuilder()
  254. ->add('usebaille', ChoiceType::class, [
  255. 'label' => 'usebaille',
  256. 'choices' => $list_useb,
  257. 'required' => false,
  258. 'mapped' => false,
  259. 'placeholder'=>'choisir un bailleur',
  260. ])
  261. ->add('listnum6', ChoiceType::class, [
  262. 'label' => '',
  263. 'choices' => [], // Le tableau est vide
  264. 'required' => false,
  265. 'mapped' => false, // Important si ce champ n'est pas lié à une entité
  266. 'placeholder'=>'Liste DA/ bailleur',
  267. ])
  268. ->getForm();
  270. $form10 = $this->createFormBuilder()
  271. ->add('listnum5', ChoiceType::class, [
  272. 'label' => 'DA pris en charge',
  273. 'choices' => $list_demAcha3,
  274. 'required' => false,
  275. 'mapped' => false,
  276. 'placeholder'=>'DA pris en charge',
  277. ])
  278. ->getForm();
  280. $form110 = $this->createFormBuilder()
  281. ->add('listnum55', ChoiceType::class, [
  282. 'label' => ' DA valider',
  283. 'choices' => $list_demAchavalide,
  284. 'required' => false,
  285. 'mapped' => false,
  286. 'placeholder'=>'DAs valider',
  287. ])
  288. ->getForm();
  290. $form01 = $this->createFormBuilder()
  291. ->add('fiche', FileType::class, [
  292. 'required' => false,
  293. 'mapped' => false, // Cette ligne est cruciale
  294. ])
  295. ->getForm();
  296. $demacha=$this->em->getRepository(demAchat::class)->find(8745);
  298. $form200 = $this->createForm(demAchatType::class, $demacha);
  299. $form01->handleRequest( $request);
  301. if ($form01->isSubmitted() ) {
  302. $file = $form01->get('fiche')->getData();
  304. if ($file) {
  305. try {
  306. // Appel du service qui gère l'importation
  307. $this->excelImportService->importDemandesAchat($file);
  308. // $this->addFlash('success', 'Le fichier a été importé avec succès !');
  309. } catch (\Exception $e) {
  310. $this->addFlash('error', 'Erreur lors de l\'importation : ' . $e->getMessage());
  311. }
  313. }
  314. return $this->redirect( $this->generateUrl('mstopes_gestion_demande_achat'));
  317. }
  322. return $this->render('DemandeAchatVue/demandeAchat.html.twig'
  323. ,['form' => $form->createView(),'form2' => $form2->createView(),'form4' => $form4->createView(),
  324. 'form3' => $form3->createView(),'form6' => $form6->createView(),'form5' => $form5->createView(),
  325. 'form7' => $form7->createView(),'form9' => $form9->createView(),'nbmesda' => $nbmesda,
  326. 'nbdanivo' => $nbdanivo,'nbdavalid' => $nbdavalid,'nballda' => $nballda,'nbdarejet' => $nbdarejet,
  327. 'form1' => $form1->createView(),'form10' => $form10->createView(),'form8' => $form8->createView(),
  328. 'form33' => $form33->createView(),'form01' => $form01->createView(),
  329. 'form110' => $form110->createView(),'admin' => $admin,'form200' => $form200->createView(),
  332. ]
  334. );
  336. }
  339. public function ajaxListDemAchat(Request $request): Response
  340. {
  341. // On vérifie que la requête est bien une requête AJAX.
  342. // C'est un point de contrôle important pour éviter les accès directs.
  343. if ($request->isXmlHttpRequest()) {
  344. $id = $request->request->get('listnum');
  346. // On s'assure que l'ID n'est pas vide avant de continuer.
  347. if ($id !== null) {
  348. // On redirige vers la route 'liste_demachat' avec l'ID en paramètre.
  349. // Cela permet de ne pas dupliquer la logique d'affichage.
  350. return $this->redirect($this->generateUrl('liste_demachat', ['id' => $id]));
  351. }
  352. }
  354. // Si la requête n'est pas une requête AJAX ou si l'ID est manquant,
  355. // on retourne une réponse d'erreur HTTP 400 Bad Request.
  356. return new Response('Requête invalide', Response::HTTP_BAD_REQUEST);
  357. }
  359. public function listdemachat(int $id, Request $request): Response
  360. {
  361. $user = $this->security->getUser();
  362. // 1. Appelez le service pour obtenir les données
  363. $data = $this->demandeAchatService->getDemandeAchatData($id);
  365. // Si le service ne trouve pas la demande, lancez une 404
  366. if (empty($data)) {
  367. throw $this->createNotFoundException("La demande d'achat n'existe pas.");
  368. }
  369. $da_sans_cc = $data['da_sans_cc'];
  370. $utildrmedical = $data['utildrmedical'];
  371. $usedrmedical = $data['usedrmedical'];
  372. $demachats = $data['demachats'];
  373. $numach = $data['numach'];
  374. $x = $data['x'];
  375. $total3 = $data['total3'];
  376. $param = $data['param'];
  377. $usesuph = $data['usesuph'];
  378. $userr = $data['userr'];
  379. $usedscsc = $data['usedscsc'];
  380. $usedp = $data['usedp'];
  381. $uselead = $data['uselead'];
  382. $code = $data['code'];
  383. $useprojet = $data['useprojet'];
  384. $usechef1 = $data['usechef1'];
  385. $usechef2 = $data['usechef2'];
  386. $usechef3 = $data['usechef3'];
  387. $usechef4 = $data['usechef4'];
  388. $usechef5 = $data['usechef5'];
  389. $usechef6 = $data['usechef6'];
  390. $usechef7 = $data['usechef7'];
  391. $userreg = $data['userreg'];
  392. $userespacha = $data['userespacha'];
  393. $demachatrefus = $data['demachatrefus'];
  394. $v = $data['v'];
  395. $usereg = $data['usereg'];
  396. $signechefp1 = $data['signechefp1'];
  397. $signechefp2 = $data['signechefp2'];
  398. $signechefp3 = $data['signechefp3'];
  399. $signechefp4 = $data['signechefp4'];
  400. $signechefp5 = $data['signechefp5'];
  401. $signechefp6 = $data['signechefp6'];
  402. $signechefp7 = $data['signechefp7'];
  403. $nb = $data['nb'];
  404. $nomb = $data['nomb'];
  405. $suph = $data['suph'];
  406. $ub = $data['ub'];
  407. $nbch = $data['nbch'];
  408. $usebaille1 = $data['usebaille1'];
  409. $usebaille2 = $data['usebaille2'];
  410. $usebaille3 = $data['usebaille3'];
  411. $usebaille4 = $data['usebaille4'];
  412. $usebaille5 = $data['usebaille5'];
  413. $usebaille6 = $data['usebaille6'];
  414. $usebaille7 = $data['usebaille7'];
  415. $valid1 = $data['valid1'];
  416. $valid2 = $data['valid2'];
  417. $usevalid1 = $data['usevalid1'];
  418. $usevalid2 = $data['usevalid2'];
  419. $uselead1 = $data['uselead1'];
  420. $uselead2 = $data['uselead2'];
  421. $uselead3 = $data['uselead3'];
  422. $uselead4 = $data['uselead4'];
  423. $uselead5 = $data['uselead5'];
  424. $w = $data['w'];
  425. $signelead1 = $data['signelead1'];
  426. $signelead2 = $data['signelead2'];
  427. $signelead3 = $data['signelead3'];
  428. $signelead4 = $data['signelead4'];
  429. $signelead5 = $data['signelead5'];
  430. $utiltecgarag = $data['utiltecgarag'];
  431. $utiltecinfo = $data['utiltecinfo'];
  432. $utilrachat = $data['utilrachat'];
  433. $utildscsc = $data['utildscsc'];
  434. $utildscsc2 = $data['utildscsc2'];
  435. $utilrr = $data['utilrr'];
  436. $userlead = $data['userlead'];
  437. $demachatrefuleads = $data['demachatrefuleads'];
  438. $signeDP1 = $data['signeDP1'];
  439. $signeDP2 = $data['signeDP2'];
  440. $signeDP3 = $data['signeDP3'];
  441. $signeDP4 = $data['signeDP4'];
  442. $signeDP5 = $data['signeDP5'];
  443. $signeDP6 = $data['signeDP6'];
  444. $signeDP7 = $data['signeDP7'];
  445. $signeDP8 = $data['signeDP8'];
  446. $usedp1 = $data['usedp1'];
  447. $usedp2 = $data['usedp2'];
  448. $usedp3 = $data['usedp3'];
  449. $usedp4 = $data['usedp4'];
  450. $usedp5 = $data['usedp5'];
  451. $usedp6 = $data['usedp6'];
  452. $usedp7 = $data['usedp7'];
  453. $usedp8 = $data['usedp8'];
  454. $usedep = $data['usedep'];
  455. $usechefp = $data['usechefp'];
  456. $categmedical = $data['categmedical'];
  457. $cloture = $data['cloture'];
  458. // 2. Gérez les formulaires. La logique de gestion des requêtes POST reste ici.
  459. $demach = $demachats[0]; // Récupérez l'objet principal
  462. $form10 = $this->createFormBuilder(new demAchat())
  463. ->add('tva', ChoiceType::class, ['choices' => ['0' => 0, '5' => 5, '15' => 15, '18' => 18]])
  464. ->getForm();
  467. /* $form20 = $this->createForm(demAchatType::class, $demach);
  468. $form20= $this->createFormBuilder()
  469. ->add('images', ImageSType::class,['required' => false, ])
  470. ->getForm();
  472. // Gérez l'envoi de formulaire si la méthode est POST
  473. $form20->handleRequest($request);
  475. if ($form20->isSubmitted() && $form20->isValid()) {
  478. $this->em->flush();
  479. return $this->redirectToRoute('mstopes_gestion_demande_achat');
  481. }*/
  484. return $this->render('DemandeAchatVue/show.html.twig'
  485. ,[
  486. 'cloture' => $cloture,
  487. 'da_sans_cc' => $da_sans_cc,
  488. 'utildrmedical' => $utildrmedical,
  489. 'categmedical' => $categmedical,
  490. 'usedrmedical' => $usedrmedical,
  491. 'demachats' => $demachats,
  492. 'numach' => $numach,
  493. 'user' => $user,
  494. 'id' => $id,
  495. 'x' => $x,
  496. 'total3' => $total3,
  497. 'param' => $param,
  498. 'usesuph' => $usesuph,
  499. 'userr' => $userr,
  500. 'usedscsc' => $usedscsc,
  501. 'usedp' => $usedp,
  503. 'uselead' => $uselead,
  504. 'usechefp' => $usechefp,
  505. 'usedep' => $usedep,
  506. 'code' => $code,
  507. 'useprojet' => $useprojet,
  508. 'usechef1' => $usechef1,
  509. 'usechef2' => $usechef2,
  510. 'usechef3' => $usechef3,
  511. 'userreg' => $userreg,
  512. 'usechef4' => $usechef4,
  513. 'usechef5' => $usechef5,
  514. 'usechef6' => $usechef6,
  515. 'userespacha' => $userespacha,
  516. 'usereg' => $usereg,
  517. 'signechefp1' => $signechefp1,
  518. 'signechefp2' => $signechefp2,
  519. 'signechefp3' => $signechefp3,
  520. 'signechefp4' => $signechefp4,
  521. 'signechefp5' => $signechefp5,
  522. 'signechefp6' => $signechefp6,
  523. 'v' => $v,
  524. 'demachatrefus' => $demachatrefus,
  525. 'nb' => $nb,
  526. 'form10' => $form10->createView(),
  527. 'nomb' => $nomb,
  528. 'suph' => $suph,
  529. 'ub' => $ub,
  530. 'nbch' => $nbch,
  531. //'form20' => $form20->createView(),
  532. 'signechefp7' => $signechefp7,
  533. 'usechef7' => $usechef7,
  534. 'usebaille1' => $usebaille1,
  535. 'usebaille2' => $usebaille2,
  536. 'usebaille3' => $usebaille3,
  537. 'usebaille4' => $usebaille4,
  538. 'usebaille5' => $usebaille5,
  539. 'usebaille6' => $usebaille6,
  540. 'usebaille7' => $usebaille7
  541. ,'valid1' => $valid1,
  542. 'valid2' => $valid2,
  543. 'usevalid1' => $usevalid1,
  544. 'usegarage' => $usevalid2,
  545. 'uselead1' => $uselead1,
  546. 'uselead2' => $uselead2,
  547. 'uselead3' => $uselead3,
  548. 'w' => $w,
  549. 'signelead1' => $signelead1,
  550. 'signelead2' => $signelead2,
  551. 'signelead3' => $signelead3,
  552. 'signelead4' => $signelead4,
  553. 'signelead5' => $signelead5,
  554. 'utiltecgarag' => $utiltecgarag,
  555. 'utiltecinfo' => $utiltecinfo,
  556. 'utilrachat' => $utilrachat,
  557. 'utildscsc' => $utildscsc,
  558. 'utildscsc2' => $utildscsc2,
  559. 'utilrr' => $utilrr,
  560. 'uselead4' => $uselead4,
  561. 'uselead5' => $uselead5,
  562. 'userlead' => $userlead,
  563. 'demachatrefuleads' => $demachatrefuleads,
  564. 'signeDP1' => $signeDP1,
  565. 'signeDP2' => $signeDP2,
  566. 'signeDP3' => $signeDP3,
  567. 'signeDP4' => $signeDP4,
  568. 'signeDP5' => $signeDP5,
  569. 'signeDP6' => $signeDP6,
  570. 'signeDP7' => $signeDP7,
  571. 'signeDP8' => $signeDP8,
  572. 'usedp1' => $usedp1,
  573. 'usedp2' => $usedp2,
  574. 'usedp3' => $usedp3,
  575. 'usedp4' => $usedp4,
  576. 'usedp5' => $usedp5,
  577. 'usedp6' => $usedp6,
  578. 'usedp7' => $usedp7,
  579. 'usedp8' => $usedp8
  580. ]
  581. );
  582. }
  583. public function addfileda(int $id, Request $request): Response
  584. {
  588. //$user = $this->security->getUser();
  589. $demacha=$this->em->getRepository(demAchat::class)->find($id);
  591. $form = $this->createForm(demAchatType::class, $demacha);
  594. // Gérez l'envoi de formulaire si la méthode est POST
  595. $form->handleRequest($request);
  597. if ($form->isSubmitted() ) {
  600. $this->em->flush();
  601. return $this->redirectToRoute('mstopes_gestion_demande_achat');
  603. }
  606. return $this->render('DemandeAchatVue/addfileda.html.twig'
  607. ,[
  608. 'id' => $id,'form' => $form->createView()]
  609. );
  610. }
  613. public function uploadImageAndLink(Request $request): JsonResponse
  614. {
  615. // 1. Récupérer l'ID du demAchat à partir des données POST de FormData
  616. // JQuery doit inclure 'demAchatId' dans le FormData.
  617. $demAchatId = $request->request->get('demAchatId');
  619. if (!$demAchatId) {
  620. return new JsonResponse(['error' => 'Missing demAchat ID'], 400);
  621. }
  623. /** @var demAchat $demAchat */
  624. $demAchat = $this->em->getRepository(demAchat::class)->find($demAchatId);
  626. if (!$demAchat) {
  627. return new JsonResponse(['error' => 'DemAchat not found'], 404);
  628. }
  630. /** @var UploadedFile $file */
  631. $file = $request->files->get('image'); // 'image' est le nom du champ file
  633. if (!$file) {
  634. return new JsonResponse(['error' => 'No file uploaded'], 400);
  635. }
  637. // --- Logique d'upload et de persistance de ImageS ---
  638. /*
  639. $imageS = new Image();
  640. $fileName = md5(uniqid()) . '.' . $file->guessExtension();
  642. try {
  643. $file->move($imageS->getUploadRootDir(), $fileName);
  644. } catch (\Exception $e) {
  645. return new JsonResponse(['error' => 'File move failed'], 500);
  646. }
  648. $imageS->setUrl($fileName);
  649. $imageS->setAlt($file->getClientOriginalName());
  651. // 2. Lier l'ImageS au demAchat et persister/flusher
  653. // Si un ancien fichier existait, vous pouvez le supprimer ici.
  654. if ($oldImage = $demAchat->getImage()) {
  655. // Logique de suppression de l'ancien fichier/entité ImageS (Optionnel)
  656. $oldImagePath = $oldImage->getUploadRootDir() . '/' . $oldImage->getUrl();
  657. if (file_exists($oldImagePath)) {
  658. unlink($oldImagePath);
  659. }
  660. $this->em->remove($oldImage);
  661. }
  663. $demAchat->setImage($imageS); // Lier la nouvelle image
  665. $this->em->persist($imageS);
  666. $this->em->flush(); // Le flush va enregistrer ImageS et mettre à jour demAchat
  667. */
  668. // --- Fin Logique d'upload ---
  670. return new JsonResponse([
  671. 'success' => true,
  672. //'imageId' => $imageS->getId(),
  673. 'message' => 'Image uploaded and linked successfully to DemAchat ID: ' . $demAchatId,
  674. ]);
  675. }
  676. public function listedatemp(int $id, Request $request): Response
  677. {
  680. $datemps=null;
  681. $user = $this->security->getUser();
  682. $datemps=$this->em->getRepository(DemAchatTemp::class)->findDemandeAchatPerso($id);
  683. $montant=0; $nb=count($datemps);
  684. if($datemps!==null){
  685. foreach($datemps as $datemp)
  686. {
  687. $montant= $montant+$datemp->getPrixU()*$datemp->getQuantDemande();
  689. }
  690. $datemps[0]->setNumOrdre($montant);
  691. $this->em->flush();
  692. }
  694. return $this->render('DemandeAchatVue/listedatemp.html.twig'
  695. ,[
  696. 'demachats' => $datemps,'nb' => $nb]
  697. );
  698. }
  699. public function ajouterachattemp(Request $request): Response
  700. {
  703. $demAch = new DemAchatTemp;
  704. $user = $this->security->getUser();
  709. $demachas=$this->em->getRepository(DemAchatTemp::class)->findAll();
  710. $obje = $request->request->get('obje');
  711. $idcentreCout = $request->request->get('centreCout');
  712. $idnomprojet = $request->request->get('bailleur');
  713. $descrip = $request->request->get('descrip');
  715. $quantDemand = $request->request->get('quantDemand');
  716. $delais = $request->request->get('delais');
  717. $region = $request->request->get('region');
  718. $prixUnit = $request->request->get('prixUnit');
  719. $iddesignrech = $request->request->get('iddesignrech');
  721. if($region ==1){$region="Bamako";}
  722. elseif($region ==2){$region="Segou";}
  723. elseif($region ==3){$region="Mopti";}
  724. elseif($region ==4){$region="Sikasso";}
  725. elseif($region ==5){$region="Koulikoro";}
  727. $nomprojet= $this->em->getRepository(Bailleur::class)->find($idnomprojet);
  728. $cecout= $this->em->getRepository(CentreCout::class)->find($idcentreCout);
  729. if($iddesignrech!=null)
  730. $designrech= $this->em->getRepository(Catalogue::class)->findOneByDesignation($iddesignrech);
  731. else
  732. $designrech=null;
  734. $num=1;
  735. if($demachas!==null){
  737. foreach($demachas as $demacha)
  738. {
  739. if($demacha->getNumDemandeAchat()>$num)
  740. $num=$demacha->getNumDemandeAchat();
  742. }
  743. $num=$num+1;
  744. }
  747. $demAch->setCentreCout($cecout->getLibele());
  748. $demAch->setCostcenter($cecout);
  749. $demAch->setNombaille($nomprojet);
  751. $demAch->setNomProjet($nomprojet->getLibele());
  752. $demAch->setQuantDemande($quantDemand);
  753. $demAch->setObjet($obje);
  755. $demAch->setRegion($region);
  756. $demAch->setDescription($descrip);
  759. if($designrech != null){
  761. $demAch->setDesignation($designrech->getDesignation());
  762. $demAch->setCatalogue($designrech);
  763. $demAch->setPrixU($prixUnit);
  764. }
  765. else {
  766. $demAch->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  767. }
  770. $dat=date('Y-m-d H:i:s');
  771. $demAch->setDateSoumis(new \DateTime($dat));
  772. $demAch->setUser($user);
  773. $demAch->setNumDemandeAchat($num);
  774. //$demAch->setNumOrdre(1);
  776. $demAch->setDelais($delais);
  777. $this->em->persist($demAch);
  779. $this->em->flush();
  784. return $this->redirectToRoute('liste_da_temp', ['id' => $num]);
  791. }
  792. public function ajoutdesigndatemp(Request $request): Response
  793. {
  795. $demAch = new DemAchatTemp;
  796. $user = $this->security->getUser();
  798. $demtempuses = $this->em->getRepository(DemAchatTemp::class)->findByUser( $user);
  799. $demtemp = end($demtempuses);
  803. $idbailleur = $request->request->get('bailleur');
  804. $descrip = $request->request->get('descrip');
  805. $idcentreCout = $request->request->get('centreCout');
  806. $quantDemand = $request->request->get('quantDemand');
  809. $prixUnit = $request->request->get('prixUnit');
  810. $iddesignrech = $request->request->get('iddesignrech');
  812. $nomprojet = $this->em->getRepository(Bailleur::class)->find($idbailleur);
  813. $centrecout = $this->em->getRepository(CentreCout::class)->find($idcentreCout);
  814. if($iddesignrech!=null)
  815. $designrech= $this->em->getRepository(Catalogue::class)->findOneByDesignation($iddesignrech);
  816. else
  817. $designrech=null;
  818. $num=$demtemp->getNumDemandeAchat();
  821. $demAch->setCentreCout($centrecout->getLibele());
  822. $demAch->setCostcenter($centrecout);
  823. $demAch->setNomProjet($nomprojet->getLibele());
  826. $demAch->setNombaille($nomprojet);
  827. $demAch->setRegion($demtemp->getRegion());
  828. $demAch->setQuantDemande($quantDemand);
  829. $demAch->setObjet($demtemp->getObjet());
  830. $demAch->setDescription($descrip);
  833. if($designrech != null){
  835. $demAch->setDesignation($designrech->getDesignation());
  836. $demAch->setCatalogue($designrech);
  837. $demAch->setPrixU($prixUnit);
  838. }
  839. else {
  840. $demAch->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  841. }
  843. $dat=date('Y-m-d H:i:s');
  844. $demAch->setDateSoumis(new \DateTime($dat));
  845. $demAch->setUser($user);
  846. $demAch->setNumDemandeAchat($num);
  847. $demAch->setNumOrdre(1);
  849. $demAch->setDelais($demtemp->getDelais());
  850. $this->em->persist($demAch);
  851. $this->em->flush();
  856. return $this->redirectToRoute('liste_da_temp', ['id' => $num]);
  865. }
  866. //creer DA sans le centre de cout
  868. public function ajaxadatemp(Request $request): Response
  869. {
  870. $demAch = new DemAchatTemp;
  871. $user = $this->security->getUser();
  876. $demachas=$this->em->getRepository(DemAchatTemp::class)->findAll();
  877. $obje = $request->request->get('obje');
  879. $descrip = $request->request->get('descrip');
  880. $region = $request->request->get('region');
  881. $baille2 = $request->request->get('baille2');
  882. $quantDemand = $request->request->get('quantDemand');
  884. $prixUnit = $request->request->get('prixUnit');
  885. $iddesignrech = $request->request->get('iddesignrech');
  887. $nomprojet= $this->em->getRepository(Bailleur::class)->find($baille2);
  889. if($iddesignrech!=null)
  890. $designrech= $this->em->getRepository(Catalogue::class)->findOneByDesignation($iddesignrech);
  891. else
  892. $designrech=null;
  894. $num=1;
  895. if($demachas!=null){
  897. foreach($demachas as $demacha)
  898. {
  899. if($demacha->getNumDemandeAchat()>$num)
  900. $num=$demacha->getNumDemandeAchat();
  902. }
  903. $num=$num+1;
  904. }
  907. $demAch->setQuantDemande($quantDemand);
  908. $demAch->setObjet($obje);
  909. $demAch->setNombaille($nomprojet);
  910. $demAch->setNomProjet($nomprojet->getLibele());
  911. $demAch->setDescription($descrip);
  912. $demAch->setRegion($region);
  914. if($designrech !=null ){
  915. if($designrech[0]->getId()!=749){
  916. $demAch->setDesignation($designrech[0]->getDesignation());
  917. $demAch->setPrixU($prixUnit);
  918. $demAch->setCatalogue($designrech[0]);
  919. }
  920. else
  921. $demAch->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  923. }
  924. if($designrech==null )
  925. $demAch->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  929. $demAch->setUser($user);
  930. $demAch->setNumDemandeAchat($num);
  931. $demAch->setNumOrdre(1);
  935. $this->em->persist($demAch);
  936. $this->em->flush();
  941. return $this->redirectToRoute('liste_da_temp', ['id' => $num]);
  948. }
  950. public function ajaxajoutdatempAction()
  951. {
  952. $request = $this->container->get('request');
  953. $em = $this->getDoctrine()->getEntityManager();
  955. $demAch = new demAchatTemp;
  959. $user = $this->container->get('security.context')->getToken()->getUser();
  960. $demtempuses=$this->em->getRepository(DemAchatTemp::class)->selectdemuser($user);
  961. $demtemp=end($demtempuses);
  966. $descrip = $request->request->get('descrip');
  967. $obje = $request->request->get('obje');
  968. $quantDemand = $request->request->get('quantDemand');
  969. $idbailleur = $request->request->get('baille2');
  971. $prixUnit = $request->request->get('prixUnit');
  972. $iddesignrech = $request->request->get('iddesignrech');
  973. $designrech=$em->getRepository('mstopeIntranetBundle:Catalogue')->findByDesignation($iddesignrech);
  974. $nomprojet=$em->getRepository('mstopeIntranetBundle:Bailleur')->find($idbailleur);
  975. $num=$demtemp->getNumDemandeAchat();
  977. $demAch->setQuantDemande($quantDemand);
  978. $demAch->setObjet($demtemp->getObjet());
  979. $demAch->setRegion($demtemp->getRegion());
  980. $demAch->setDescription($descrip);
  982. if(isset($designrech)){
  983. if($designrech[0]->getId()!=749){
  984. $demAch->setDesignation($designrech[0]->getDesignation());
  985. $demAch->setCatalogue($designrech[0]);}
  987. else
  988. $demAch->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  989. }
  990. if($designrech==null )
  991. $demAch->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  993. $demAch->setPrixU($prixUnit);
  994. $demAch->setNomProjet($nomprojet->getLibele());
  995. $demAch->setNombaille($nomprojet);
  996. $demAch->setUser($user);
  997. $demAch->setNumDemandeAchat($num);
  998. $demAch->setNumOrdre(1);
  1001. $em->persist($demAch);
  1002. $em->flush();
  1006. //return $this->redirect( $this->generateUrl('mstopes_gestion_demande_achat'));
  1007. return $this->redirect( $this->generateUrl('liste_da_temp', array('id' => $num)));
  1016. }
  1019. public function daenvoyer(Request $request): Response
  1020. {
  1021. $user = $this->security->getUser();
  1022. $numero = $request->request->get('num');
  1023. $datemps=$this->em->getRepository(DemAchatTemp::class)->findDemandeAchatPerso($numero);
  1025. $numda = $this->em->getRepository(NumDA::class)->find(1);
  1026. $num=$numda->getNum()+1;
  1027. $total=0;$total3=0;
  1028. $contratCadreSelectionne = null;
  1029. $presenceLigneSansCC = false;
  1030. foreach($datemps as $datemp)
  1031. {
  1032. $numtemp= $datemp->getNumDemandeAchat();
  1033. $achat = new demAchat; $raport= new RapportageDA;
  1035. $achat->setDesignation($datemp->getDesignation());
  1036. $achat->setPrixU($datemp->getPrixU());
  1037. $achat->setCentreCout($datemp->getCentreCout());
  1038. $achat->setNomProjet($datemp->getNomProjet());
  1039. $achat->setNombaille($datemp->getNombaille());
  1040. $achat->setCostcenter($datemp->getCostcenter());
  1041. $achat->setCatalogue($datemp->getCatalogue());
  1042. $achat->setObjet($datemp->getObjet());
  1043. $achat->setRegion($datemp->getRegion());
  1044. $achat->setDescription($datemp->getDescription());
  1045. $achat->setUser($datemp->getUser());
  1046. $achat->setNomProjet($datemp->getNomProjet());
  1049. $achat->setQuantDemande($datemp->getQuantDemande());
  1050. $achat->setResteACommander($datemp->getQuantDemande());
  1051. $achat->setDelais($datemp->getDelais());
  1053. $achat->setNumOrdre(1);
  1054. $dat=date('Y-m-d H:i:s');
  1055. $achat->setDateSoumis(new \DateTime($dat));
  1057. // =====================================================
  1058. // GESTION AUTOMATIQUE CONTRAT-CADRE
  1059. // =====================================================
  1061. $montantLigne =
  1062. (float)$datemp->getPrixU()
  1063. * (float)$datemp->getQuantDemande();
  1065. $contratCadre = null;
  1067. $catalogue = $datemp->getCatalogue();
  1069. $categorieCatalogue = $catalogue
  1070. ? $catalogue->getCategorycatalogue()
  1071. : null;
  1073. if ($categorieCatalogue) {
  1075. // ManyToMany :
  1076. // CategoryCatalogue -> CategoriesMarche
  1078. $categoriesMarche =
  1079. $categorieCatalogue->getCategoriesMarche();
  1081. if (!$categoriesMarche->isEmpty()) {
  1083. foreach ($categoriesMarche as $categorieMarche) {
  1085. $contrats =
  1086. $this->contratCadreService
  1087. ->listerDisponiblesPourDA(
  1088. $categorieMarche->getId(),
  1089. $montantLigne
  1090. );
  1092. // premier contrat compatible
  1093. if (!empty($contrats)) {
  1095. $contratCadre = $contrats[0];
  1096. break;
  1097. }
  1098. }
  1099. }
  1100. }
  1102. // =====================================================
  1103. // CONTROLE COHERENCE DA
  1104. // =====================================================
  1107. // contrat trouvé
  1108. if ($contratCadre) {
  1110. // rattachement DA -> ContratCadre
  1111. $achat->setContratCadre($contratCadre);
  1112. $achat->setStatutContratCadree(demAchat::CC_SUGGERE);
  1116. // réservation budget
  1117. $montantReserve =
  1118. (float)$contratCadre->getMontantReserve();
  1120. $contratCadre->setMontantReserve(
  1121. (string)($montantReserve + $montantLigne)
  1122. );
  1124. $this->em->persist($contratCadre);
  1125. }
  1128. $numda->setNum($num);
  1129. $achat->setNumDemandeAchat($num);
  1130. $this->em->persist($achat);
  1131. $this->em->remove($datemp);
  1132. $raport->setDateSoumis(new \DateTime($dat));
  1133. $raport->setDemAchat($achat);
  1134. $this->em->persist($raport);
  1135. $this->em->flush();
  1139. if (!empty($datemp->getDescription()) && $datemp->getDescription() !== "undefined" &&(trim($datemp->getDescription()) !== ""))
  1140. {// 🔥 2. Sauvegarde traductions FR
  1141. $this->translationWriter->create
  1142. (
  1143. 'demAchat',
  1144. $achat->getId(),
  1145. 'description',
  1146. $achat->getDescription()
  1147. );
  1148. }
  1149. }
  1151. $this->em->refresh($achat);
  1153. // 🔥 2. Sauvegarde traductions FR
  1154. $this->translationWriter->create(
  1155. 'demAchat',
  1156. $achat->getId(),
  1157. 'objet',
  1158. $achat->getObjet()
  1159. );
  1160. $this->em->flush();
  1165. // return $this->redirectToRoute('liste_da_temp', ['id' => $numero]);
  1166. return $this->redirect( $this->generateUrl('mstopes_gestion_demande_achat'));
  1168. }
  1171. //ajout article apres creation de la DA
  1173. public function ajaxajoutdesignachat(Request $request)
  1174. {
  1175. if (!$request->isXmlHttpRequest()) {
  1177. return new JsonResponse([
  1178. 'error' => 'Invalid request'
  1179. ], 400);
  1180. }
  1182. $user = $this->getUser();
  1184. $id = $request->request->get('listnum');
  1185. $id2 = $request->request->get('listnum2');
  1186. $id3 = $request->request->get('listnum9');
  1187. $id4 = $request->request->get('listnum4');
  1188. $id5 = $request->request->get('listnum3');
  1189. $id6 = $request->request->get('listnum7');
  1190. $id7 = $request->request->get('listnum1');
  1191. $id8 = $request->request->get('listnum5');
  1193. $idcentreCout = $request->request->get('centreCout');
  1194. $idbailleur = $request->request->get('bailleur');
  1196. $quantDemand = (float)$request->request->get('quantDemand');
  1197. $prixUni = (float)$request->request->get('prixUni');
  1199. $descrip = $request->request->get('descrip');
  1200. $designation = $request->request->get('designation');
  1202. // =====================================================
  1203. // Catalogue
  1204. // =====================================================
  1206. $design = $this->em
  1207. ->getRepository(Catalogue::class)
  1208. ->findOneBy([
  1209. 'designation' => $designation
  1210. ]);
  1212. $bailleur = $this->em
  1213. ->getRepository(Bailleur::class)
  1214. ->find($idbailleur);
  1216. $centrecout = $this->em
  1217. ->getRepository(CentreCout::class)
  1218. ->find($idcentreCout);
  1220. // =====================================================
  1221. // Demande principale
  1222. // =====================================================
  1224. $ids = [$id, $id2, $id3, $id4, $id5, $id6, $id7, $id8];
  1226. $demacha = null;
  1228. foreach ($ids as $oneId) {
  1230. if ($oneId) {
  1232. $demacha = $this->em
  1233. ->getRepository(DemAchat::class)
  1234. ->find($oneId);
  1236. if ($demacha) {
  1237. break;
  1238. }
  1239. }
  1240. }
  1242. if (!$demacha) {
  1244. return new JsonResponse([
  1245. 'message' =>
  1246. "Ajout impossible : demande introuvable"
  1247. ], 400);
  1248. }
  1250. // =====================================================
  1251. // Sécurité logique
  1252. // =====================================================
  1254. if (($id2 && $id) || ($id3 && $id)) {
  1256. return new JsonResponse([
  1257. 'message' =>
  1258. "Ajout non effectué : veuillez actualiser la page"
  1259. ], 400);
  1260. }
  1262. // =====================================================
  1263. // Création ligne DA
  1264. // =====================================================
  1266. $demAch = new demAchat();
  1268. if ($design) {
  1270. $demAch->setDesignation($designation);
  1272. $demAch->setCatalogue($design);
  1274. } else {
  1276. $demAch->setDesignation(
  1277. 'Produit introuvable dans le catalogue'
  1278. );
  1279. }
  1281. $demAch->setPrixU($prixUni);
  1283. $demAch->setCentreCout(
  1284. $centrecout?->getLibele()
  1285. );
  1287. $demAch->setCostcenter($centrecout);
  1289. $demAch->setNombaille($bailleur);
  1291. $demAch->setNomProjet(
  1292. $bailleur?->getLibele()
  1293. );
  1295. $demAch->setQuantDemande($quantDemand);
  1297. $demAch->setDelais(
  1298. $demacha->getDelais()
  1299. );
  1301. $demAch->setObjet(
  1302. $demacha->getObjet()
  1303. );
  1305. if (
  1306. !empty($descrip)
  1307. &&
  1308. $descrip !== "undefined"
  1309. ) {
  1311. $demAch->setDescription($descrip);
  1312. }
  1314. $demAch->setRegion(
  1315. $demacha->getRegion()
  1316. );
  1318. $demAch->setNumOrdre(1);
  1320. $demAch->setUser($user);
  1322. $demAch->setNumDemandeAchat(
  1323. $demacha->getNumDemandeAchat()
  1324. );
  1326. $demAch->setDateSoumis(new \DateTime());
  1328. // =====================================================
  1329. // GESTION CONTRAT CADRE
  1330. // =====================================================
  1332. $contratCadre = null;
  1334. $montantLigne =
  1335. $prixUni * $quantDemand;
  1337. if (
  1338. $design
  1339. &&
  1340. $design->getCategorycatalogue()
  1341. ) {
  1343. $categorieCatalogue =
  1344. $design->getCategorycatalogue();
  1346. foreach (
  1347. $categorieCatalogue->getCategoriesMarche()
  1348. as $categorieMarche
  1349. ) {
  1351. $contrats =
  1352. $this->contratCadreService
  1353. ->listerDisponiblesPourDA(
  1354. $categorieMarche->getId(),
  1355. $montantLigne
  1356. );
  1358. if (!empty($contrats)) {
  1360. $contratCadre = $contrats[0];
  1362. break;
  1363. }
  1364. }
  1365. }
  1367. // =====================================================
  1368. // Affectation contrat + réservation
  1369. // =====================================================
  1371. if ($contratCadre) {
  1373. $demAch->setContratCadre(
  1374. $contratCadre
  1375. );
  1377. $demAch->setStatutContratCadree(
  1378. demAchat::CC_SUGGERE
  1379. );
  1381. // réservation
  1382. $reserve =
  1383. (float)$contratCadre->getMontantReserve();
  1385. $contratCadre->setMontantReserve(
  1386. (string)($reserve + $montantLigne)
  1387. );
  1389. $this->em->persist($contratCadre);
  1390. }
  1392. // =====================================================
  1393. // Save
  1394. // =====================================================
  1396. $this->em->persist($demAch);
  1398. $this->em->flush();
  1400. $this->em->refresh($demAch);
  1402. // =====================================================
  1403. // Traduction description
  1404. // =====================================================
  1406. if (
  1407. !empty($descrip)
  1408. &&
  1409. $descrip !== "undefined"
  1410. &&
  1411. trim($descrip) !== ""
  1412. ) {
  1414. $this->translationWriter->create(
  1415. 'demAchat',
  1416. $demAch->getId(),
  1417. 'description',
  1418. $demAch->getDescription()
  1419. );
  1421. $this->em->flush();
  1422. }
  1424. // =====================================================
  1425. // Retour
  1426. // =====================================================
  1428. return $this->redirect(
  1429. $this->generateUrl(
  1430. 'liste_demachat',
  1431. [
  1432. 'id' => $demacha->getId()
  1433. ]
  1434. )
  1435. );
  1436. }
  1437. public function downloadfileDA(int $id_ap):Response
  1438. {
  1441. $img = $this->em->getRepository(ImageS::class)->find($id_ap);
  1444. $fichier = $img->getAlt();
  1445. $chemin =$img->getUploadRootDir().'/';
  1447. $response = new Response();
  1448. $response->setContent(file_get_contents($chemin.$fichier));
  1449. $response->headers->set('Content-Type', 'application/force-download');
  1450. $response->headers->set('Content-disposition', 'filename='.$fichier);
  1452. return $response;
  1457. }
  1459. public function imprimdemachat(int $id, Request $request): Response
  1460. {
  1461. $user = $this->security->getUser();
  1462. // 1. Appelez le service pour obtenir les données
  1463. $data = $this->demandeAchatService->getDemandeAchatData($id);
  1465. // Si le service ne trouve pas la demande, lancez une 404
  1466. if (empty($data)) {
  1467. throw $this->createNotFoundException("La demande d'achat n'existe pas.");
  1468. }
  1469. $demachats = $data['demachats'];
  1470. $numach = $data['numach'];
  1471. $x = $data['x'];
  1472. $total3 = $data['total3'];
  1473. $param = $data['param'];
  1474. $usesuph = $data['usesuph'];
  1475. $userr = $data['userr'];
  1476. $usedscsc = $data['usedscsc'];
  1477. $usedp = $data['usedp'];
  1478. $uselead = $data['uselead'];
  1479. $code = $data['code'];
  1480. $useprojet = $data['useprojet'];
  1481. $usechef1 = $data['usechef1'];
  1482. $usechef2 = $data['usechef2'];
  1483. $usechef3 = $data['usechef3'];
  1484. $usechef4 = $data['usechef4'];
  1485. $usechef5 = $data['usechef5'];
  1486. $usechef6 = $data['usechef6'];
  1487. $usechef7 = $data['usechef7'];
  1488. $userreg = $data['userreg'];
  1489. $userespacha = $data['userespacha'];
  1490. $demachatrefus = $data['demachatrefus'];
  1491. $v = $data['v'];
  1492. $usereg = $data['usereg'];
  1493. $signechefp1 = $data['signechefp1'];
  1494. $signechefp2 = $data['signechefp2'];
  1495. $signechefp3 = $data['signechefp3'];
  1496. $signechefp4 = $data['signechefp4'];
  1497. $signechefp5 = $data['signechefp5'];
  1498. $signechefp6 = $data['signechefp6'];
  1499. $signechefp7 = $data['signechefp7'];
  1500. $nb = $data['nb'];
  1501. $nomb = $data['nomb'];
  1502. $suph = $data['suph'];
  1503. $ub = $data['ub'];
  1504. $nbch = $data['nbch'];
  1505. $usebaille1 = $data['usebaille1'];
  1506. $usebaille2 = $data['usebaille2'];
  1507. $usebaille3 = $data['usebaille3'];
  1508. $usebaille4 = $data['usebaille4'];
  1509. $usebaille5 = $data['usebaille5'];
  1510. $usebaille6 = $data['usebaille6'];
  1511. $usebaille7 = $data['usebaille7'];
  1512. $valid1 = $data['valid1'];
  1513. $valid2 = $data['valid2'];
  1514. $usevalid1 = $data['usevalid1'];
  1515. $usevalid2 = $data['usevalid2'];
  1516. $uselead1 = $data['uselead1'];
  1517. $uselead2 = $data['uselead2'];
  1518. $uselead3 = $data['uselead3'];
  1519. $uselead4 = $data['uselead4'];
  1520. $uselead5 = $data['uselead5'];
  1521. $w = $data['w'];
  1522. $signelead1 = $data['signelead1'];
  1523. $signelead2 = $data['signelead2'];
  1524. $signelead3 = $data['signelead3'];
  1525. $signelead4 = $data['signelead4'];
  1526. $signelead5 = $data['signelead5'];
  1527. $utiltecgarag = $data['utiltecgarag'];
  1528. $utiltecinfo = $data['utiltecinfo'];
  1529. $utilrachat = $data['utilrachat'];
  1530. $utildscsc = $data['utildscsc'];
  1531. $utildscsc2 = $data['utildscsc2'];
  1532. $utilrr = $data['utilrr'];
  1533. $userlead = $data['userlead'];
  1534. $demachatrefuleads = $data['demachatrefuleads'];
  1535. $signeDP1 = $data['signeDP1'];
  1536. $signeDP2 = $data['signeDP2'];
  1537. $signeDP3 = $data['signeDP3'];
  1538. $signeDP4 = $data['signeDP4'];
  1539. $signeDP5 = $data['signeDP5'];
  1540. $signeDP6 = $data['signeDP6'];
  1541. $signeDP7 = $data['signeDP7'];
  1542. $signeDP8 = $data['signeDP8'];
  1543. $usedp1 = $data['usedp1'];
  1544. $usedp2 = $data['usedp2'];
  1545. $usedp3 = $data['usedp3'];
  1546. $usedp4 = $data['usedp4'];
  1547. $usedp5 = $data['usedp5'];
  1548. $usedp6 = $data['usedp6'];
  1549. $usedp7 = $data['usedp7'];
  1550. $usedp8 = $data['usedp8'];
  1551. $usedep = $data['usedep'];
  1552. $usechefp = $data['usechefp'];
  1554. // 2. Gérez les formulaires. La logique de gestion des requêtes POST reste ici.
  1555. $demach = $demachats[0]; // Récupérez l'objet principal
  1557. $path = 'C:\wamp64\www\intranetbf\public\img\valid.png';
  1558. $type = pathinfo($path, PATHINFO_EXTENSION);
  1559. $data = file_get_contents($path);
  1560. $base64 = base64_encode($data);
  1567. $html = $this->twig->render('DemandeAchatVue/imprimdemachat.html.twig'
  1568. ,[
  1569. 'base64_image_data' => $base64,
  1570. 'demachats' => $demachats,
  1571. 'numach' => $numach,
  1572. 'user' => $user,
  1573. 'id' => $id,
  1574. 'x' => $x,
  1575. 'total3' => $total3,
  1576. 'param' => $param,
  1577. 'usesuph' => $usesuph,
  1578. 'userr' => $userr,
  1579. 'usedscsc' => $usedscsc,
  1580. 'usedp' => $usedp,
  1582. 'uselead' => $uselead,
  1583. 'usechefp' => $usechefp,
  1584. 'usedep' => $usedep,
  1585. 'code' => $code,
  1586. 'useprojet' => $useprojet,
  1587. 'usechef1' => $usechef1,
  1588. 'usechef2' => $usechef2,
  1589. 'usechef3' => $usechef3,
  1590. 'userreg' => $userreg,
  1591. 'usechef4' => $usechef4,
  1592. 'usechef5' => $usechef5,
  1593. 'usechef6' => $usechef6,
  1594. 'userespacha' => $userespacha,
  1595. 'usereg' => $usereg,
  1596. 'signechefp1' => $signechefp1,
  1597. 'signechefp2' => $signechefp2,
  1598. 'signechefp3' => $signechefp3,
  1599. 'signechefp4' => $signechefp4,
  1600. 'signechefp5' => $signechefp5,
  1601. 'signechefp6' => $signechefp6,
  1602. 'v' => $v,
  1603. 'demachatrefus' => $demachatrefus,
  1604. 'nb' => $nb,
  1605. //'form10' => $form10->createView(),
  1606. 'nomb' => $nomb,
  1607. 'suph' => $suph,
  1608. 'ub' => $ub,
  1609. 'nbch' => $nbch,
  1610. //'form20' => $form20->createView(),
  1611. 'signechefp7' => $signechefp7,
  1612. 'usechef7' => $usechef7,
  1613. 'usebaille1' => $usebaille1,
  1614. 'usebaille2' => $usebaille2,
  1615. 'usebaille3' => $usebaille3,
  1616. 'usebaille4' => $usebaille4,
  1617. 'usebaille5' => $usebaille5,
  1618. 'usebaille6' => $usebaille6,
  1619. 'usebaille7' => $usebaille7
  1620. ,'valid1' => $valid1,
  1621. 'valid2' => $valid2,
  1622. 'usevalid1' => $usevalid1,
  1623. 'usegarage' => $usevalid2,
  1624. 'uselead1' => $uselead1,
  1625. 'uselead2' => $uselead2,
  1626. 'uselead3' => $uselead3,
  1627. 'w' => $w,
  1628. 'signelead1' => $signelead1,
  1629. 'signelead2' => $signelead2,
  1630. 'signelead3' => $signelead3,
  1631. 'signelead4' => $signelead4,
  1632. 'signelead5' => $signelead5,
  1633. 'utiltecgarag' => $utiltecgarag,
  1634. 'utiltecinfo' => $utiltecinfo,
  1635. 'utilrachat' => $utilrachat,
  1636. 'utildscsc' => $utildscsc,
  1637. 'utildscsc2' => $utildscsc2,
  1638. 'utilrr' => $utilrr,
  1639. 'uselead4' => $uselead4,
  1640. 'uselead5' => $uselead5,
  1641. 'userlead' => $userlead,
  1642. 'demachatrefuleads' => $demachatrefuleads,
  1643. 'signeDP1' => $signeDP1,
  1644. 'signeDP2' => $signeDP2,
  1645. 'signeDP3' => $signeDP3,
  1646. 'signeDP4' => $signeDP4,
  1647. 'signeDP5' => $signeDP5,
  1648. 'signeDP6' => $signeDP6,
  1649. 'signeDP7' => $signeDP7,
  1650. 'signeDP8' => $signeDP8,
  1651. 'usedp1' => $usedp1,
  1652. 'usedp2' => $usedp2,
  1653. 'usedp3' => $usedp3,
  1654. 'usedp4' => $usedp4,
  1655. 'usedp5' => $usedp5,
  1656. 'usedp6' => $usedp6,
  1657. 'usedp7' => $usedp7,
  1658. 'usedp8' => $usedp8
  1659. ]
  1660. );
  1661. // 3. Utiliser une bibliothèque plus récente pour le PDF, comme 'dompdf/dompdf'
  1662. // Installez-la via Composer si ce n'est pas déjà fait : composer require dompdf/dompdf
  1663. $html2pdf = new \Dompdf\Dompdf();
  1664. $html2pdf->loadHtml($html);
  1665. $html2pdf->setPaper('A4', 'landscape');
  1666. $html2pdf->render();
  1668. $output = $html2pdf->output();
  1670. // Envoi direct de la sortie PDF en tant que réponse
  1671. $response = new Response($output);
  1672. $response->headers->set('Content-Type', 'application/pdf');
  1673. $response->headers->set('Content-Disposition', 'inline; filename="demande_achat_'.$id.'.pdf"');
  1675. // 4. Remplacer la logique d'envoi d'e-mail par le composant Mailer
  1676. $userE = $demach->getUser();
  1677. $emailUser = $userE->getEmail();
  1678. $nom = $userE->getNom();
  1679. $prenom = $userE->getPrenom();
  1680. /*
  1681. $email = (new Email())
  1682. ->from('votre_email@votredomaine.com')
  1683. ->to($emailUser)
  1684. ->subject('Demande d\'achat imprimée')
  1685. ->html(
  1686. "<html><head></head><body><b>Bonjour</b>,<br/>
  1687. Mrs/Mr $nom $prenom, votre demande d'achat N&deg$numach a &eacutet&eacute imprim&eacute.<br/><br/>
  1688. Suivez ce lien pour voir la demande:<br/>
  1689. http://www.intranet-mariestopesbf.org/web/login
  1690. </body></html>"
  1691. );
  1693. $mailer->send($email);*/
  1695. return $response;
  1697. }
  1698. public function telechargerFileA($id_ap)
  1699. {
  1702. $img = $this->em->getRepository(Image::class)->find($id_ap);
  1705. $fichier = $img->getAlt();
  1706. $chemin =$img->getUploadRootDir().'/';
  1708. $response = new Response();
  1709. $response->setContent(file_get_contents($chemin.$id_ap.$fichier));
  1710. $response->headers->set('Content-Type', 'application/force-download');
  1711. $response->headers->set('Content-disposition', 'filename='.$fichier);
  1713. return $response;
  1718. }
  1719. public function ajaxmodifierdelaiprevu($id_dem): Response
  1720. {
  1723. $achat = $this->em->getRepository(demAchat::class)->find($id_dem);
  1724. $form = $this->createForm(ModifDemAchatType::class, $achat);
  1726. return $this->render('DemandeAchatVue/modifierdelaiprevu.html.twig',
  1727. ['id_dem' => $id_dem,'form' => $form->createView(),]);
  1728. }
  1729. public function modifierdelaiprevu(Request $request): Response
  1730. {
  1733. $listnum = $request->request->get('id');
  1734. $delai = $request->request->get('delai');
  1736. $demacha=$this->em->getRepository(demAchat::class)->find($listnum);
  1740. $demachas = $this->em->getRepository(demAchat::class)->findBy([
  1741. 'numDemandeAchat' =>$demacha->getNumDemandeAchat(),'drapoRejetchef'=>0]);
  1742. foreach($demachas as $demach){
  1743. $demach->setDelaisPrevu($delai);
  1745. }
  1747. $this->em->flush();
  1749. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $listnum)));
  1756. }
  1757. public function ajaxmodifierdemacha($id_dem)
  1758. {
  1760. $demach = $this->em->getRepository(demAchat::class)->find($id_dem);
  1762. //$demachats = $this->em->getRepository(demAchat::class)->findByNumDemandeAchat($demach->getNumDemandeAchat() );
  1764. $user1=$demach->getUser();
  1765. $user = $this->security->getUser();
  1766. $form9 = $this->createForm(ModifDemAchatType::class, $demach);
  1768. return $this->render('DemandeAchatVue/modifierdemacha.html.twig',
  1769. ['id_dem' => $id_dem,'form9' => $form9->createView(),'user1' => $user1,'user' => $user]);
  1770. }
  1773. public function modifierdemacha(Request $request): Response
  1774. {
  1775. $objet = $request->request->get('objet');
  1776. $designation = $request->request->get('designatio');
  1777. $description = $request->request->get('description');
  1779. $quantd = (float)$request->request->get('quantd');
  1781. $idcentreCout = $request->request->get('centreCout');
  1782. $idnomProjet = $request->request->get('nomProjet');
  1784. $prixU = (float)$request->request->get('prixU');
  1786. $id = $request->request->get('id');
  1788. $demacha = $this->em
  1789. ->getRepository(demAchat::class)
  1790. ->find($id);
  1792. if (!$demacha) {
  1794. throw $this->createNotFoundException();
  1795. }
  1797. // =====================================================
  1798. // Ancien contrat + ancien montant
  1799. // =====================================================
  1801. $ancienContrat = $demacha->getContratCadre();
  1803. $ancienMontant =
  1804. (float)$demacha->getPrixU()
  1805. *
  1806. (float)$demacha->getQuantDemande();
  1808. if ($demacha->getTva()) {
  1810. $ancienMontant +=
  1811. $ancienMontant
  1812. *
  1813. ((float)$demacha->getTva() / 100);
  1814. }
  1816. // =====================================================
  1817. // Données liées
  1818. // =====================================================
  1820. $centreCout = $this->em
  1821. ->getRepository(CentreCout::class)
  1822. ->find($idcentreCout);
  1824. $nomProjet = $this->em
  1825. ->getRepository(Bailleur::class)
  1826. ->find($idnomProjet);
  1828. $design = $this->em
  1829. ->getRepository(Catalogue::class)
  1830. ->findOneByDesignation($designation);
  1832. // =====================================================
  1833. // MAJ ligne DA
  1834. // =====================================================
  1836. if ($design != null) {
  1838. $demacha->setDesignation(
  1839. $design->getDesignation()
  1840. );
  1842. $demacha->setCatalogue($design);
  1844. } else {
  1846. $demacha->setDesignation(
  1847. 'votre article selectionner ne se trouve pas dans le catalogue'
  1848. );
  1849. }
  1851. $demacha->setPrixU($prixU);
  1853. $demacha->setQuantDemande($quantd);
  1854. $demacha->setResteACommander($quantd);
  1855. $demacha->setCentreCout(
  1856. $centreCout->getLibele()
  1857. );
  1859. $demacha->setCostcenter($centreCout);
  1861. $demacha->setNomProjet(
  1862. $nomProjet->getLibele()
  1863. );
  1865. $demacha->setNombaille($nomProjet);
  1867. $demacha->setDescription($description);
  1869. // =====================================================
  1870. // MAJ objet sur toutes lignes DA
  1871. // =====================================================
  1873. $numach = $demacha->getNumDemandeAchat();
  1875. $demachats = $this->em
  1876. ->getRepository(demAchat::class)
  1877. ->findBy([
  1878. 'numDemandeAchat' => $numach,
  1879. 'drapoRejetchef' => 0
  1880. ]);
  1882. foreach ($demachats as $demachat) {
  1884. $demachat->setObjet($objet);
  1885. }
  1887. // =====================================================
  1888. // Nouveau montant
  1889. // =====================================================
  1891. $nouveauMontant =
  1892. $prixU * $quantd;
  1894. if ($demacha->getTva()) {
  1896. $nouveauMontant +=
  1897. $nouveauMontant
  1898. *
  1899. ((float)$demacha->getTva() / 100);
  1900. }
  1902. // =====================================================
  1903. // Retrait ancien montant réservation
  1904. // =====================================================
  1906. if ($ancienContrat) {
  1908. $ancienReserve =
  1909. (float)$ancienContrat->getMontantReserve();
  1911. $ancienContrat->setMontantReserve(
  1912. (string)max(
  1913. 0,
  1914. $ancienReserve - $ancienMontant
  1915. )
  1916. );
  1918. $this->em->persist($ancienContrat);
  1919. }
  1921. // =====================================================
  1922. // Recherche nouveau contrat compatible
  1923. // =====================================================
  1925. $nouveauContrat = null;
  1927. if ($design && $design->getCategorycatalogue()) {
  1929. $categorieCatalogue =
  1930. $design->getCategorycatalogue();
  1932. foreach (
  1933. $categorieCatalogue->getCategoriesMarche()
  1934. as $categorieMarche
  1935. ) {
  1937. $contrats =
  1938. $this->contratCadreService
  1939. ->listerDisponiblesPourDA(
  1940. $categorieMarche->getId(),
  1941. $nouveauMontant
  1942. );
  1944. if (!empty($contrats)) {
  1946. $nouveauContrat = $contrats[0];
  1948. break;
  1949. }
  1950. }
  1951. }
  1953. // =====================================================
  1954. // Nouveau contrat
  1955. // =====================================================
  1957. $demacha->setContratCadre($nouveauContrat);
  1959. if ($nouveauContrat) {
  1961. $reserve =
  1962. (float)$nouveauContrat->getMontantReserve();
  1964. $nouveauContrat->setMontantReserve(
  1965. (string)($reserve + $nouveauMontant)
  1966. );
  1968. $demacha->setStatutContratCadree(
  1969. demAchat::CC_SUGGERE
  1970. );
  1972. $this->em->persist($nouveauContrat);
  1974. } else {
  1976. $demacha->setStatutContratCadree(null);
  1977. }
  1979. // =====================================================
  1980. // Save
  1981. // =====================================================
  1983. $this->em->persist($demacha);
  1985. $this->em->flush();
  1987. return $this->redirect( $this->generateUrl( 'liste_demachat',
  1988. [
  1989. 'id' => $id
  1990. ]
  1991. )
  1992. );
  1993. }
  1996. public function ajaxmodacha($id_dem)
  1997. {
  1999. $demac = $this->em->getRepository(demAchat::class)->find($id_dem);
  2001. $form8 = $this->createForm(ModifDemAchatType::class, $demac);
  2004. return $this->render('DemandeAchatVue/modifacha.html.twig'
  2005. ,['id_dem' => $id_dem,'form8' => $form8->createView(),]
  2006. );
  2007. }
  2008. public function modifacha(Request $request): Response
  2009. {
  2013. $id = $request->request->get('id');
  2014. $bailleur = $request->request->get('bailleur');
  2015. $projet = $request->request->get('projet');
  2016. $ligneBudget = $request->request->get('ligneBudget');
  2018. $demacha=$this->em->getRepository(demAchat::class)->find($id);
  2022. $demacha->setBailleur($bailleur);
  2023. $demacha->setProjet($projet);
  2024. $demacha->setLigneBudget($ligneBudget);
  2026. $this->em->flush();
  2027. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id)));
  2034. }
  2036. public function ajaxmodifdemacha($id_dem)
  2037. {
  2040. $demac = $this->em->getRepository(demAchat::class)->find($id_dem);
  2042. $form = $this->createForm(ModifDemAchatType::class, $demac);
  2045. return $this->render('DemandeAchatVue/modifdemacha.html.twig',
  2046. ['id_dem' => $id_dem,'form' => $form->createView(),]);
  2049. }
  2050. public function modifdemacha(Request $request): Response
  2051. {
  2053. $user = $this->security->getUser();
  2054. $observation = $request->request->get('observation');
  2055. $id = $request->request->get('id');
  2056. //$quanta = $request->request->get('quantA');
  2058. $demacha=$this->em->getRepository(demAchat::class)->find($id);
  2061. $observation= $observation.' / par '.$user->getNom().' '.$user->getPrenom();
  2063. // $demacha->setQuantAccorde(null);
  2064. $demacha->setObservation($observation);
  2066. $this->em->flush();
  2067. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id)));
  2074. }
  2075. public function ajaxcorrectionda(Request $request): Response
  2076. {
  2077. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2078. $demachas = $data['demachas'];
  2079. $id_achat = $data['id_achat'];
  2082. foreach($demachas as $demach){
  2083. $demach->setDrapoRespRegrefu(0);
  2084. $demach->setDrapoRespAcharefu(0);
  2085. $demach->setDrapoDSCSCrefu(0);
  2086. $demach->setDrapoDPrefu(0);
  2087. $demach->setDrapoRRrefu(0);
  2088. $demach->setDrapoSuprefu(0);
  2089. $demach->setDrapoLeadrefu(0);
  2090. $demach->setDrapoLeadrefu1(0);
  2091. $demach->setDrapoLeadrefu2(0);
  2092. $demach->setDrapoLeadrefu3(0);
  2093. $demach->setDrapoLeadrefu4(0);
  2094. $demach->setDrapoLeadrefu5(0);
  2095. $demach->setDrapoRejetLead(0);
  2096. $demach->setDrapoChefprefu(0);
  2097. $demach->setDrapoChefprefu1(0);
  2098. $demach->setDrapoChefprefu2(0);
  2099. $demach->setDrapoChefprefu3(0);
  2100. $demach->setDrapoChefprefu4(0);
  2101. $demach->setDrapoChefprefu5(0);
  2102. $demach->setDrapoChefprefu6(0);
  2103. $demach->setDrapoChefprefu7(0);
  2104. $demach->setDrapoDPrefu1(0);
  2105. $demach->setDrapoDPrefu2(0);
  2106. $demach->setDrapoDPrefu3(0);
  2107. $demach->setDrapoDPrefu4(0);
  2108. $demach->setDrapoDPrefu5(0);
  2109. $demach->setDrapoDPrefu6(0);
  2110. $demach->setDrapoDPrefu7(0);
  2111. $demach->setRaisonRefu(null);
  2112. $demach->setObservation(null);
  2113. $demach->setSigneLead(null);
  2114. $demach->setSigneLead1(null);
  2115. $demach->setSigneLead2(null);
  2116. $demach->setSigneLead3(null);
  2117. $demach->setSigneLead4(null);
  2118. $demach->setSigneLead5(null);
  2119. $demach->setSigneSUP(null);
  2120. $demach->setSigneChefp(null);
  2121. $demach->setSigneChefp1(null);
  2122. $demach->setSigneChefp2(null);
  2123. $demach->setSigneChefp3(null);
  2124. $demach->setSigneChefp4(null);
  2125. $demach->setSigneChefp5(null);
  2126. $demach->setSigneChefp6(null);
  2127. $demach->setSigneChefp7(null);
  2128. $demach->setSigneDF(null);
  2129. $demach->setSigneDP(null);
  2130. $demach->setSigneRR(null);
  2131. $demach->setSigneDP1(null);
  2132. $demach->setSigneDP2(null);
  2133. $demach->setSigneDP3(null);
  2134. $demach->setSigneDP4(null);
  2135. $demach->setSigneDP5(null);
  2136. $demach->setSigneDP6(null);
  2137. $demach->setSigneDP7(null);
  2138. $demach->setDrapoRespReg(0);
  2139. $demach->setDrapoRespAcha(0);
  2140. $demach->setDrapoDSCSC(0);
  2141. $demach->setDrapoDP(0);
  2142. $demach->setDrapoRR(0);
  2143. $demach->setDrapoSup(0);
  2144. $demach->setDrapoLead(0);
  2145. $demach->setDrapoChefp(0);
  2146. $demach->setDrapoChefp1(0);
  2147. $demach->setDrapoChefp2(0);
  2148. $demach->setDrapoChefp3(0);
  2149. $demach->setDrapoChefp4(0);
  2150. $demach->setDrapoChefp5(0);
  2151. $demach->setDrapoChefp6(0);
  2152. $demach->setDrapoChefp7(0);
  2153. $demach->setDrapoRejetchef(0);
  2154. $demach->setDrapoLead1(0);
  2155. $demach->setDrapoLead2(0);
  2156. $demach->setDrapoLead3(0);
  2157. $demach->setDrapoLead4(0);
  2158. $demach->setDrapoLead5(0);
  2159. $demach->setDrapoDP1(0);
  2160. $demach->setDrapoDP2(0);
  2161. $demach->setDrapoDP3(0);
  2162. $demach->setDrapoDP4(0);
  2163. $demach->setDrapoDP5(0);
  2164. $demach->setDrapoDP6(0);
  2165. $demach->setDrapoDP7(0);
  2166. $demach->setDrapoGaragerefu(0);
  2167. }
  2168. $this->em->flush();
  2170. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2174. }
  2175. /*public function ajaxmodtva(Request $request): Response
  2176. {
  2177. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2178. $demachas = $data['demachas'];
  2179. $id_achat = $data['id_achat'];
  2180. $tva = $data['tva'];
  2182. foreach($demachas as $demach){
  2183. $demach->setTva($tva);
  2185. }
  2186. $this->em->flush();
  2188. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2192. } */
  2193. public function ajaxmodtva(Request $request): Response
  2194. {
  2195. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2197. $demachas = $data['demachas'];
  2198. $id_achat = $data['id_achat'];
  2199. $tva = (float)$data['tva'];
  2201. if (empty($demachas)) {
  2202. return $this->redirect(
  2203. $this->generateUrl('liste_demachat', ['id' => $id_achat])
  2204. );
  2205. }
  2207. // même contrat pour toute la DA
  2208. $contratCadre = $demachas[0]->getContratCadre();
  2210. $ancienMontantTotal = 0;
  2211. $nouveauMontantTotal = 0;
  2213. foreach ($demachas as $demach) {
  2215. $prixU = (float)$demach->getPrixU();
  2216. $qte = (float)$demach->getQuantDemande();
  2218. // ancien montant avec ancienne TVA
  2219. $ancienneTva = (float)$demach->getTva();
  2221. $ancienLigne =
  2222. ($prixU * $qte)
  2223. +
  2224. (($prixU * $qte) * $ancienneTva / 100);
  2226. $ancienMontantTotal += $ancienLigne;
  2228. // mise à jour TVA
  2229. $demach->setTva((string)$tva);
  2231. // nouveau montant
  2232. $nouveauLigne =
  2233. ($prixU * $qte)
  2234. +
  2235. (($prixU * $qte) * $tva / 100);
  2237. $nouveauMontantTotal += $nouveauLigne;
  2238. }
  2240. // ajustement réservation CC
  2241. if ($contratCadre) {
  2243. $montantReserveActuel =
  2244. (float)$contratCadre->getMontantReserve();
  2246. // différence TTC
  2247. $difference =
  2248. $nouveauMontantTotal - $ancienMontantTotal;
  2250. $contratCadre->setMontantReserve(
  2251. (string)($montantReserveActuel + $difference)
  2252. );
  2254. $this->em->persist($contratCadre);
  2255. }
  2257. $this->em->flush();
  2259. return $this->redirect(
  2260. $this->generateUrl('liste_demachat', ['id' => $id_achat])
  2261. );
  2262. }
  2264. public function ajaxdrapoCharge(Request $request): Response
  2265. {
  2268. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2269. $demachas = $data['demachas'];
  2270. $id_achat = $data['id_achat'];
  2271. $user = $data['user'];
  2272. $demacha = $data['demacha'];
  2273. $var=0;
  2274. foreach($demachas as $demach){
  2276. if (empty($demach->getDelaisPrevu()))
  2277. $var=1;
  2278. }
  2279. if($var==1){
  2280. return new JsonResponse(['message' => 'veuillez renseigner le delais prévisionnel !']);
  2282. }
  2283. else
  2284. {
  2285. foreach($demachas as $demach){
  2286. $demach->setDrapoPriCharge(1);
  2288. }
  2289. $this->em->flush();
  2292. $delais=$demacha->getDelaisPrevu();
  2293. $emailuser=$user->getEmail();
  2294. $num=$demacha->getNumDemandeAchat();
  2295. $nom=$user->getNom();
  2296. $prenom=$user->getPrenom();
  2297. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  2298. la demande d'achat N&deg$num de Mrs/Mr $nom $prenom a ete pris en charge.
  2299. le delais de livraison prévisionnel est de $delais jours.
  2300. .<br/><br/>
  2301. <br/>
  2303. </body></html>
  2304. </body></html>";
  2308. // $this->Envoi($emailuser,$contenu);
  2309. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2310. }
  2314. }
  2316. public function ajaxvalidtech1(Request $request): Response
  2317. {
  2318. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2319. $demachas = $data['demachas'];
  2320. // $id_achat = $data['id_achat'];
  2321. $user = $data['user'];
  2322. $demacha = $data['demacha'];
  2323. $dat = $data['dat'];
  2325. foreach($demachas as $demach){
  2326. $demach->setSigneInfo($user);
  2327. $demach->setDrapoInfo(1);
  2328. $demach->setDrapoInforefu(0);
  2329. $demach->setDateInfo(new \DateTime($dat));
  2330. }
  2331. $this->em->flush();
  2333. $id_achat=$demacha->getId();
  2334. $user=$demacha->getUser();
  2335. $emailuser=$user->getEmail();
  2336. $num=$demacha->getNumDemandeAchat();
  2337. $nom=$user->getNom();
  2338. $prenom=$user->getPrenom();
  2339. $contenu="<html><head></head><body><b>Bonjour,
  2340. le responsable technique a validé la DA</b>,<br/>
  2342. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2343. </body></html>";
  2345. // $this->Envoi($emailuser,$contenu);
  2348. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2352. }
  2353. public function ajaxvalidtech1refu(Request $request): Response
  2354. {
  2355. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2356. $demachas = $data['demachas'];
  2357. $id_achat = $data['id_achat'];
  2358. $user = $data['user'];
  2359. $demacha = $data['demacha'];
  2360. $dat = $data['dat'];
  2362. foreach($demachas as $demach){
  2363. $demach->setSigneInfo($user);
  2364. $demach->setDrapoInfo(0);
  2365. $demach->setDrapoInforefu(1);
  2366. $demach->setDateInfo(new \DateTime($dat));
  2367. }
  2368. $this->em->flush();
  2369. $this->rejectionService->libererBudgetDA($demachas);
  2370. $user=$demacha->getUser();
  2371. $emailuser=$user->getEmail();
  2372. $num=$demacha->getNumDemandeAchat();
  2373. $nom=$user->getNom();
  2374. $prenom=$user->getPrenom();
  2375. $contenu="<html><head></head><body><b>Bonjour,
  2376. le responsable technique a rejeté la DA</b>,<br/>
  2378. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2379. </body></html>";
  2381. // $this->Envoi($emailuser,$contenu);
  2384. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2388. }
  2389. public function ajaxvalid2(Request $request): Response
  2390. {
  2391. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2392. $demachas = $data['demachas'];
  2393. $id_achat = $data['id_achat'];
  2394. $user = $data['user'];
  2395. $demacha = $data['demacha'];
  2396. $dat = $data['dat'];
  2398. foreach($demachas as $demach){
  2399. $demach->setSigneGarage($user);
  2400. $demach->setDrapoGarage(1);
  2401. $demach->setDrapoGaragerefu(0);
  2402. $demach->setDateGarage(new \DateTime($dat));
  2403. if($demach->getUser()->getId()==294){
  2404. $demach->setDrapoSup(1);
  2405. $demach->setDrapoSuprefu(0);
  2406. $demach->setSigneSUP($user);
  2407. $demach->setDateSuph(new \DateTime($dat));
  2408. }
  2409. }
  2410. $this->em->flush();
  2413. $user=$demacha->getUser();
  2414. $emailuser=$user->getEmail();
  2415. $num=$demacha->getNumDemandeAchat();
  2416. $nom=$user->getNom();
  2417. $prenom=$user->getPrenom();
  2418. $contenu="<html><head></head><body><b>Bonjour,
  2419. le responsable technique a validé la DA</b>,<br/>
  2421. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2422. </body></html>";
  2424. // $this->Envoi($emailuser,$contenu);
  2427. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2431. }
  2432. public function ajaxvalid2refu(Request $request): Response
  2433. {
  2434. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2435. $demachas = $data['demachas'];
  2436. $id_achat = $data['id_achat'];
  2437. $user = $data['user'];
  2438. $demacha = $data['demacha'];
  2439. $dat = $data['dat'];
  2440. foreach($demachas as $demach){
  2441. $demach->setSigneGarage($user);
  2442. $demach->setDrapoGarage(0);
  2443. $demach->setDrapoGaragerefu(1);
  2444. $demach->setDateGarage(new \DateTime($dat));
  2445. if($demach->getUser()->getId()==294){
  2446. $demach->setDrapoSup(1);
  2447. $demach->setDrapoSuprefu(0);
  2448. $demach->setSigneSUP($user);
  2449. $demach->setDateSuph(new \DateTime($dat));
  2450. }
  2451. }
  2452. $this->em->flush();
  2454. $user=$demacha->getUser();
  2455. $emailuser=$user->getEmail();
  2456. $num=$demacha->getNumDemandeAchat();
  2457. $nom=$user->getNom();
  2458. $prenom=$user->getPrenom();
  2459. $contenu="<html><head></head><body><b>Bonjour,
  2460. le responsable technique a rejeté la DA</b>,<br/>
  2462. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2463. </body></html>";
  2465. // $this->Envoi($emailuser,$contenu);
  2468. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2472. }
  2474. public function ajaxdraporacha(Request $request): Response
  2475. {
  2476. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2477. $demachas = $data['demachas'];
  2478. $id_achat = $data['id_achat'];
  2479. $user = $data['user'];
  2480. $demacha = $data['demacha'];
  2481. $dat = $data['dat'];
  2482. $nbselect = $data['nbselect'];
  2485. if( $nbselect >1){
  2486. return new JsonResponse(array('message' => 'veuillez actualiser la page, vous avez plusieurs DAs ouvertes !'));
  2488. }
  2490. foreach($demachas as $demach){
  2491. $demach->setSigneRespAcha($user);
  2492. $demach->setDrapoRespAcha(1);
  2493. $demach->setDrapoRespAcharefu(0);
  2494. $demach->setDateRespAcha(new \DateTime($dat));
  2495. }
  2496. $this->em->flush();
  2498. $user=$demacha->getUser();
  2499. $emailuser=$user->getEmail();
  2500. $num=$demacha->getNumDemandeAchat();
  2501. $nom=$user->getNom();
  2502. $prenom=$user->getPrenom();
  2503. $contenu="<html><head></head><body><b>Bonjour,
  2504. le responsable achat a validé la DA</b>,<br/>
  2506. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2507. </body></html>";
  2509. // $this->Envoi($emailuser,$contenu);
  2511. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2517. }
  2519. public function ajaxdraporacharefu(Request $request): Response
  2520. {
  2521. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2522. $demachas = $data['demachas'];
  2523. $id_achat = $data['id_achat'];
  2524. $user = $data['user'];
  2525. $demacha = $data['demacha'];
  2526. $dat = $data['dat'];
  2527. $nbselect = $data['nbselect'];
  2529. if( $nbselect >1){
  2530. return new JsonResponse(array('message' => 'veuillez actualiser la page, vous avez plusieurs DAs ouvertes !'));
  2532. }
  2534. foreach($demachas as $demach){
  2535. $demach->setSigneRespAcha($user);
  2536. $demach->setDrapoRespAcha(0);
  2537. $demach->setDrapoRespAcharefu(1);
  2538. $demach->setDateRespAcha(new \DateTime($dat));
  2539. }
  2540. $this->em->flush();
  2541. $this->rejectionService->libererBudgetDA($demachas);
  2542. $user=$demacha->getUser();
  2543. $emailuser=$user->getEmail();
  2544. $num=$demacha->getNumDemandeAchat();
  2545. $nom=$user->getNom();
  2546. $prenom=$user->getPrenom();
  2547. $contenu="<html><head></head><body><b>Bonjour,
  2548. le responsable achat a validé la DA</b>,<br/>
  2550. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2551. </body></html>";
  2553. // $this->Envoi($emailuser,$contenu);
  2555. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2560. }
  2562. public function ajaxdrapodrmedical(Request $request): Response
  2563. {
  2564. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2565. $demachas = $data['demachas'];
  2566. $id_achat = $data['id_achat'];
  2567. $user = $data['user'];
  2568. $demacha = $data['demacha'];
  2569. $dat = $data['dat'];
  2571. foreach($demachas as $demach){
  2572. $demach->setSigneDRMEDICAL($user);
  2573. $demach->setDrapoDRMEDICAL(1);
  2574. $demach->setDrapoDRMEDICALrefu(0);
  2575. $demach->setDateDRMEDICAL(new \DateTime($dat));
  2576. }
  2577. $this->em->flush();
  2579. $user=$demacha->getUser();
  2580. $emailuser=$user->getEmail();
  2581. $num=$demacha->getNumDemandeAchat();
  2582. $nom=$user->getNom();
  2583. $prenom=$user->getPrenom();
  2584. $contenu="<html><head></head><body><b>Bonjour,
  2585. le responsable médical a validé la DA</b>,<br/>
  2587. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2588. </body></html>";
  2590. // $this->Envoi($emailuser,$contenu);
  2592. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2598. }
  2600. public function ajaxdrmedicalrefu(Request $request): Response
  2601. {
  2602. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2603. $demachas = $data['demachas'];
  2604. $id_achat = $data['id_achat'];
  2605. $user = $data['user'];
  2606. $demacha = $data['demacha'];
  2607. $dat = $data['dat'];
  2609. foreach($demachas as $demach){
  2610. $demach->setSigneDRMEDICAL($user);
  2611. $demach->setDrapoDRMEDICAL(0);
  2612. $demach->setDrapoDRMEDICALrefu(1);
  2613. $demach->setDateDRMEDICAL(new \DateTime($dat));
  2614. }
  2615. $this->em->flush();
  2617. $user=$demacha->getUser();
  2618. $emailuser=$user->getEmail();
  2619. $num=$demacha->getNumDemandeAchat();
  2620. $nom=$user->getNom();
  2621. $prenom=$user->getPrenom();
  2622. $contenu="<html><head></head><body><b>Bonjour,
  2623. le responsable médical a validé la DA</b>,<br/>
  2625. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2626. </body></html>";
  2628. // $this->Envoi($emailuser,$contenu);
  2630. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2636. }
  2638. public function ajaxdraposuph(Request $request): Response
  2639. {
  2641. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2642. $demachas = $data['demachas'];
  2643. $id_achat = $data['id_achat'];
  2644. $user = $data['user'];
  2645. $demacha = $data['demacha'];
  2646. $dat = $data['dat'];
  2648. foreach($demachas as $demach){
  2650. $demach->setSigneSUP($user);
  2651. $demach->setDrapoSup(1);
  2652. $demach->setDrapoSuprefu(0);
  2654. $demach->setDateSuph(new \DateTime($dat));}
  2655. $this->em->flush();
  2657. $user=$demacha->getUser();
  2658. $emailuser=$user->getEmail();
  2659. $num=$demacha->getNumDemandeAchat();
  2660. $nom=$user->getNom();
  2661. $prenom=$user->getPrenom();
  2662. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  2663. le superieur hierarchique de Mrs/Mr $nom $prenom a approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  2664. Suivez ce lien pour voir la demande:<br/>
  2665. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2666. </body></html>";
  2669. $centrecout=$demacha->getCentreCout();
  2670. $centre = $this->em->getRepository(CentreCout::class)->findOneByLibele($centrecout);
  2671. $usecentres = $this->em->getRepository(UserCentre::class)->findByCentrecout($centre);
  2673. $usedp=null;
  2675. foreach ($usecentres as $usecentre)
  2676. {
  2677. if($usecentre->getUser()->hasRole('ROLE_DP'))
  2678. $usedp=$usecentre->getUser();
  2681. }
  2682. $email=$usedp->getEmail();
  2683. // $this->Envoi($email,$contenu);
  2684. // $this->Envoi($emailuser,$contenu);
  2687. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2693. }
  2695. public function ajaxdraposuphrefu(Request $request): Response
  2696. {
  2698. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2699. $demachas = $data['demachas'];
  2700. $id_achat = $data['id_achat'];
  2701. $user = $data['user'];
  2702. $demacha = $data['demacha'];
  2703. $dat = $data['dat'];
  2705. foreach($demachas as $demach){
  2707. $demach->setSigneSUP($user);
  2708. $demach->setDrapoSup(0);
  2709. $demach->setDrapoSuprefu(1);
  2711. $demach->setDateSuph(new \DateTime($dat));}
  2712. $this->em->flush();
  2714. $user=$demacha->getUser();
  2715. $emailuser=$user->getEmail();
  2716. $num=$demacha->getNumDemandeAchat();
  2717. $nom=$user->getNom();
  2718. $prenom=$user->getPrenom();
  2719. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  2720. le superieur hierarchique de Mrs/Mr $nom $prenom n'a pas approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  2721. Suivez ce lien pour voir la demande:<br/>
  2722. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2724. </body></html>";
  2727. // $this->Envoi($emailuser,$contenu);
  2728. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2732. }
  2734. public function ajaxdraporespreg(Request $request): Response
  2735. {
  2736. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2737. $demachas = $data['demachas'];
  2738. $id_achat = $data['id_achat'];
  2739. $user = $data['user'];
  2740. $demacha = $data['demacha'];
  2741. $dat = $data['dat'];
  2743. foreach($demachas as $demach){
  2744. $demach->setSigneRespReg($user);
  2745. $demach->setDrapoRespReg(1);
  2746. $demach->setDrapoRespRegrefu(0);
  2747. $demach->setDateRespReg(new \DateTime($dat));
  2748. if($user->hasRole('ROLE_DP2') )
  2749. {
  2751. $demach->setSigneDP2($user);
  2752. $demach->setDrapoDP2(1);
  2753. $demach->setDrapoDPrefu2(0);
  2754. $demach->setDateDP2(new \DateTime($dat));
  2755. }
  2756. }
  2757. $this->em->flush();
  2759. $user=$demacha->getUser();
  2760. $emailuser=$user->getEmail();
  2761. $num=$demacha->getNumDemandeAchat();
  2762. $nom=$user->getNom();
  2763. $prenom=$user->getPrenom();
  2764. $contenu="<html><head></head><body><b>Bonjour</b>,
  2765. le responsable regionale a valid&eacute la DA<br/>
  2767. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2768. </body></html>";
  2769. $centrecout=$demacha->getCentreCout();
  2770. $centre = $this->em->getRepository(CentreCout::class)->findOneByLibele($centrecout);
  2771. $usecentres = $this->em->getRepository(UserCentre::class)->findByCentrecout($centre);
  2772. $code= $usecentres[0]->getCode();
  2773. $usedp=null; $usefinance=null; $uselead=null;
  2774. if($code==13)
  2775. {
  2777. foreach ($usecentres as $usecentre)
  2778. {
  2779. if($usecentre->getUselead()->hasRole('ROLE_LEAD'))
  2780. $uselead=$usecentre->getUser();
  2781. $email=$uselead->getEmail();
  2782. //$this->Envoi($email,$contenu);
  2784. }
  2786. }
  2787. if($code==61)
  2788. {
  2789. foreach ($usecentres as $usecentre)
  2790. {
  2791. if($usecentre->getUser()->hasRole('ROLE_DP'))
  2792. $usedp=$usecentre->getUser();
  2793. $email=$usedp->getEmail();
  2794. //$this->Envoi($email,$contenu);
  2796. }
  2797. }
  2798. // $this->Envoi($emailuser,$contenu);
  2802. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2806. }
  2808. public function ajaxdraporespregrefu(Request $request): Response
  2809. {
  2810. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2811. $demachas = $data['demachas'];
  2812. $id_achat = $data['id_achat'];
  2813. $user = $data['user'];
  2814. $demacha = $data['demacha'];
  2815. $dat = $data['dat'];
  2816. foreach($demachas as $demach){
  2817. $demach->setSigneRespReg($user);
  2818. $demach->setDrapoRespReg(0);
  2819. $demach->setDrapoRespRegrefu(1);
  2820. $demach->setDateRespReg(new \DateTime($dat));
  2822. }
  2823. $this->em->flush();
  2825. $use=$demacha->getUser();
  2826. $emailuser=$use->getEmail();
  2827. $num=$demacha->getNumDemandeAchat();
  2828. $nom=$use->getNom();
  2829. $prenom=$use->getPrenom();
  2830. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  2831. le responsable regional n'a pas approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  2832. Suivez ce lien pour voir la demande:<br/>
  2833. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2834. </body></html>";
  2836. // $this->Envoi($emailuser,$contenu);
  2839. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2843. }
  2845. public function ajaxdrapolead(Request $request): Response
  2846. {
  2848. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2849. $demachas = $data['demachas'];
  2850. $id_achat = $data['id_achat'];
  2851. $user = $data['user'];
  2852. $demacha = $data['demacha'];
  2853. $dat = $data['dat'];
  2855. if($user->hasRole('ROLE_LEAD1') )
  2856. {
  2858. foreach($demachas as $demach)
  2859. {
  2862. $demach->setSigneLead1($user);
  2863. $demach->setDrapoLead1(1);
  2864. $demach->setDrapoLeadrefu1(0);
  2865. $demach->setDateLead1(new \DateTime($dat));
  2867. }
  2868. $this->em->flush();
  2869. }
  2870. elseif($user->hasRole('ROLE_LEAD2') )
  2871. {
  2873. foreach($demachas as $demach)
  2874. {
  2877. $demach->setSigneLead2($user);
  2878. $demach->setDrapoLead2(1);
  2879. $demach->setDrapoLeadrefu2(0);
  2880. $demach->setDateLead2(new \DateTime($dat));
  2882. }
  2883. $this->em->flush();
  2884. }
  2885. elseif($user->hasRole('ROLE_LEAD3') )
  2886. {
  2888. foreach($demachas as $demach)
  2889. {
  2892. $demach->setSigneLead3($user);
  2893. $demach->setDrapoLead3(1);
  2894. $demach->setDrapoLeadrefu3(0);
  2895. $demach->setDateLead3(new \DateTime($dat));
  2897. }
  2898. $this->em->flush();
  2899. }
  2900. elseif($user->hasRole('ROLE_LEAD4') )
  2901. {
  2903. foreach($demachas as $demach)
  2904. {
  2907. $demach->setSigneLead4($user);
  2908. $demach->setDrapoLead4(1);
  2909. $demach->setDrapoLeadrefu4(0);
  2910. $demach->setDateLead4(new \DateTime($dat));
  2912. }
  2913. $this->em->flush();
  2914. }
  2915. elseif($user->hasRole('ROLE_LEAD5') )
  2916. {
  2918. foreach($demachas as $demach)
  2919. {
  2922. $demach->setSigneLead5($user);
  2923. $demach->setDrapoLead5(1);
  2924. $demach->setDrapoLeadrefu5(0);
  2925. $demach->setDateLead5(new \DateTime($dat));
  2927. }
  2928. $this->em->flush();
  2929. }
  2932. $user=$demacha->getUser();
  2933. $emailuser=$user->getEmail();
  2934. $num=$demacha->getNumDemandeAchat();
  2935. $nom=$user->getNom();
  2936. $prenom=$user->getPrenom();
  2937. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  2938. le Channel Lead a approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  2939. Suivez ce lien pour voir la demande:<br/>
  2940. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  2941. </body></html>";
  2944. $bailleur=$demacha->getNomProjet();
  2947. $baille = $this->em->getRepository(Bailleur::class)->findOneByLibele($bailleur);
  2950. $usebaille = $this->em->getRepository(UseBailleur::class)->findOneByBailleur($baille);
  2952. $email=$usebaille->getUser()->getEmail();
  2953. // $this->Envoi($email,$contenu);
  2954. // $this->Envoi($emailuser,$contenu);
  2956. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  2960. }
  2962. public function ajaxdrapoleadrefu(Request $request): Response
  2963. {
  2965. $data = $this->demandeAchatService->getDemachatSigneData($request);
  2966. $demachas = $data['demachas'];
  2967. $id_achat = $data['id_achat'];
  2968. $user = $data['user'];
  2969. $demacha = $data['demacha'];
  2970. $dat = $data['dat'];
  2971. $usecentres = $data['usecentres'];
  2972. if($user->hasRole('ROLE_LEAD1') )
  2973. {
  2975. foreach($demachas as $demach)
  2976. {
  2979. $demach->setSigneLead1($user);
  2980. $demach->setDrapoLead1(0);
  2981. $demach->setDrapoLeadrefu1(1);
  2982. $demach->setDateLead1(new \DateTime($dat));
  2983. foreach($usecentres as $usecentre)
  2984. {
  2985. if( $demach->getCostcenter()==$usecentre->getCentrecout())
  2986. $demach->setDrapoRejetLead(1);
  2987. }
  2988. }
  2989. $this->em->flush();
  2990. }
  2991. elseif($user->hasRole('ROLE_LEAD2') )
  2992. {
  2994. foreach($demachas as $demach)
  2995. {
  2998. $demach->setSigneLead2($user);
  2999. $demach->setDrapoLead2(0);
  3000. $demach->setDrapoLeadrefu2(1);
  3001. $demach->setDateLead2(new \DateTime($dat));
  3002. foreach($usecentres as $usecentre)
  3003. {
  3004. if( $demach->getCostcenter()==$usecentre->getCentrecout())
  3005. $demach->setDrapoRejetLead(1);
  3006. }
  3008. }
  3009. $this->em->flush();
  3010. }
  3011. elseif($user->hasRole('ROLE_LEAD3') )
  3012. {
  3014. foreach($demachas as $demach)
  3015. {
  3018. $demach->setSigneLead3($user);
  3019. $demach->setDrapoLead3(0);
  3020. $demach->setDrapoLeadrefu3(1);
  3021. $demach->setDateLead3(new \DateTime($dat));
  3022. foreach($usecentres as $usecentre)
  3023. {
  3024. if( $demach->getCostcenter()==$usecentre->getCentrecout())
  3025. $demach->setDrapoRejetLead(1);
  3026. }
  3028. }
  3029. $this->em->flush();
  3030. }
  3031. elseif($user->hasRole('ROLE_LEAD4') )
  3032. {
  3034. foreach($demachas as $demach)
  3035. {
  3038. $demach->setSigneLead4($user);
  3039. $demach->setDrapoLead4(0);
  3040. $demach->setDrapoLeadrefu4(1);
  3041. $demach->setDateLead4(new \DateTime($dat));
  3042. foreach($usecentres as $usecentre)
  3043. {
  3044. if( $demach->getCostcenter()==$usecentre->getCentrecout())
  3045. $demach->setDrapoRejetLead(1);
  3046. }
  3048. }
  3049. $this->em->flush();
  3050. }
  3051. elseif($user->hasRole('ROLE_LEAD5') )
  3052. {
  3054. foreach($demachas as $demach)
  3055. {
  3058. $demach->setSigneLead5($user);
  3059. $demach->setDrapoLead5(0);
  3060. $demach->setDrapoLeadrefu5(1);
  3061. $demach->setDateLead5(new \DateTime($dat));
  3062. foreach($usecentres as $usecentre)
  3063. {
  3064. if( $demach->getCostcenter()==$usecentre->getCentrecout())
  3065. $demach->setDrapoRejetLead(1);
  3066. }
  3068. }
  3069. $this->em->flush();
  3070. }
  3072. $user=$demacha->getUser();
  3073. $emailuser=$user->getEmail();
  3074. $num=$demacha->getNumDemandeAchat();
  3075. $nom=$user->getNom();
  3076. $prenom=$user->getPrenom();
  3077. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3078. lechannel lead n'a pas approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  3079. Suivez ce lien pour voir la demande:<br/>
  3080. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  3081. </body></html>";
  3083. // $this->Envoi($emailuser,$contenu);
  3085. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  3089. }
  3091. public function ajaxdrapochefp(Request $request): Response
  3092. {
  3094. $data = $this->demandeAchatService->getDemachatSigneData($request);
  3095. $demachas = $data['demachas'];
  3096. $id_achat = $data['id_achat'];
  3097. $user = $data['user'];
  3098. $demacha = $data['demacha'];
  3099. $dat = $data['dat'];
  3101. $var=0;
  3102. if($demacha->getCostcenter()!=null)
  3103. {
  3104. foreach($demachas as $demach)
  3105. {
  3106. $usebail= $this->em->getRepository(UseBailleur::class)->findOneByBailleur($demach->getNombaille());
  3108. if($usebail!=null){
  3110. if($usebail->getUser()==$user)
  3111. {
  3113. if($demach->getBailleur()=="" || $demach->getProjet()=="" || $demach->getLigneBudget()=="")
  3114. $var=1;
  3115. }
  3116. }
  3117. }
  3118. }
  3119. if($var==1)
  3120. {
  3121. // Retourner la réponse JSON
  3122. return new JsonResponse(array('message' => 'veuillez renseigner les codes bailleurs,codes projets et lignes budgetaires !'));
  3123. }
  3124. elseif( $var==0){
  3125. // $iduser=$user->getId();
  3126. $total=0;
  3127. if($user->hasRole('ROLE_CHEFP1') )
  3128. {
  3129. foreach($demachas as $demach)
  3130. {
  3131. if($demach->getQuantAccorde()!=null)
  3132. $total=$demach->getQuantAccorde()*$demach->getPrixU()+$total;
  3133. else
  3134. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3135. $demach->setSigneChefp1($user);
  3136. $demach->setDrapoChefp1(1);
  3137. $demach->setDrapoChefprefu1(0);
  3138. $demach->setDateChefp1(new \DateTime($dat));
  3139. /*if($user->hasRole('ROLE_RR') ){
  3140. $demach->setDrapoChefp6(1);
  3141. $demach->setDrapoChefprefu6(0);
  3142. $demach->setSigneChefp6($user);}*/
  3143. }
  3144. $this->em->flush();
  3145. }
  3146. if($user->hasRole('ROLE_CHEFP2') )
  3147. {
  3148. foreach($demachas as $demach)
  3149. {
  3150. if($demach->getQuantAccorde()!=null)
  3151. $total=$demach->getQuantAccorde()*$demach->getPrixU()+$total;
  3152. else
  3153. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3154. $demach->setSigneChefp2($user);
  3155. $demach->setDrapoChefp2(1);
  3156. $demach->setDrapoChefprefu2(0);
  3157. $demach->setDateChefp2(new \DateTime($dat));
  3159. }
  3160. $this->em->flush();
  3161. }
  3162. if($user->hasRole('ROLE_CHEFP3') )
  3163. {
  3164. foreach($demachas as $demach)
  3165. {
  3167. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3168. $demach->setSigneChefp3($user);
  3169. $demach->setDrapoChefp3(1);
  3170. $demach->setDrapoChefprefu3(0);
  3171. $demach->setDateChefp3(new \DateTime($dat));
  3172. /*if($user->hasRole('ROLE_RR') ){
  3173. $demach->setDrapoChefp6(1);
  3174. $demach->setDrapoChefprefu6(0);
  3175. $demach->setSigneChefp6($user);}*/
  3176. }
  3177. $this->em->flush();
  3178. }
  3179. if($user->hasRole('ROLE_CHEFP4') )
  3180. {
  3181. foreach($demachas as $demach)
  3182. {
  3184. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3185. $demach->setSigneChefp4($user);
  3186. $demach->setDrapoChefp4(1);
  3187. $demach->setDrapoChefprefu4(0);
  3188. $demach->setDateChefp4(new \DateTime($dat));
  3189. /* if($user->hasRole('ROLE_RR') ){
  3190. $demach->setDrapoChefp6(1);
  3191. $demach->setDrapoChefprefu6(0);
  3192. $demach->setSigneChefp6($user);}*/
  3194. }
  3195. $this->em->flush();
  3196. }
  3197. if($user->hasRole('ROLE_CHEFP5') )
  3198. {
  3199. foreach($demachas as $demach)
  3200. {
  3201. if($demach->getQuantAccorde()!=null)
  3202. $total=$demach->getQuantAccorde()*$demach->getPrixU()+$total;
  3203. else
  3204. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3205. $demach->setSigneChefp5($user);
  3206. $demach->setDrapoChefp5(1);
  3207. $demach->setDrapoChefprefu5(0);
  3208. $demach->setDateChefp5(new \DateTime($dat));
  3209. /* if($user->hasRole('ROLE_RR') ){
  3210. $demach->setDrapoChefp6(1);
  3211. $demach->setDrapoChefprefu6(0);
  3212. $demach->setSigneChefp6($user);}*/
  3213. }
  3214. $em->flush();
  3215. }
  3216. if($user->hasRole('ROLE_CHEFP6') )
  3217. {
  3218. foreach($demachas as $demach)
  3219. {
  3220. if($demach->getQuantAccorde()!=null)
  3221. $total=$demach->getQuantAccorde()*$demach->getPrixU()+$total;
  3222. else
  3223. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3224. $demach->setSigneChefp6($user);
  3225. $demach->setDrapoChefp6(1);
  3226. $demach->setDrapoChefprefu6(0);
  3227. $demach->setDateChefp6(new \DateTime($dat));
  3229. }
  3230. $this->em->flush();
  3231. }
  3232. if($user->hasRole('ROLE_CHEFP7') )
  3233. {
  3234. foreach($demachas as $demach)
  3235. {
  3236. if($demach->getQuantAccorde()!=null)
  3237. $total=$demach->getQuantAccorde()*$demach->getPrixU()+$total;
  3238. else
  3239. $total=$demach->getQuantDemande()*$demach->getPrixU()+$total;
  3240. $demach->setSigneChefp7($user);
  3241. $demach->setDrapoChefp7(1);
  3242. $demach->setDrapoChefprefu7(0);
  3243. $demach->setDateChefp7(new \DateTime($dat));
  3245. }
  3246. $this->em->flush();
  3247. }
  3248. $use=$demacha->getUser();
  3249. $emailuser=$use->getEmail();
  3250. $num=$demacha->getNumDemandeAchat();
  3251. $nom=$use->getNom();
  3252. $prenom=$use->getPrenom();
  3253. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3254. le Chef de projet a approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  3255. Suivez ce lien pour voir la demande:<br/>
  3256. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  3257. </body></html>";
  3259. if($demacha->getCostcenter()!=null){
  3261. $utils=$this->em->getRepository(User::class)->findAll();
  3262. $centrecout=$demacha->getCentreCout();
  3263. $centre = $this->em->getRepository(CentreCout::class)->findOneByLibele($centrecout);
  3264. $usecentres = $this->em->getRepository(UserCentre::class)->findByCentrecout($centre);
  3266. $code= $usecentres[0]->getCode();
  3267. $usedp=null; $usefinance=null;
  3268. if($code==13)
  3269. {
  3270. foreach ($usecentres as $usecentre)
  3271. {
  3272. if($usecentre->getUser()->hasRole('ROLE_DP'))
  3273. $usedp=$usecentre->getUser();
  3274. if($usedp!=null){
  3275. $email=$usedp->getEmail();
  3276. // $this->Envoi($email,$contenu);
  3277. }
  3278. }
  3280. }
  3281. elseif($code==61)
  3282. {
  3283. foreach ($utils as $util)
  3284. {
  3285. if($util->hasRole('ROLE_DSCSC2') and $total<2500000){
  3286. //$usefinance=$usecentre->getUser();
  3287. $email=$util->getEmail();
  3288. $this->Envoi($email,$contenu);}
  3289. if($util->hasRole('ROLE_DSCSC') and $total>2499999){
  3290. //$usefinance=$usecentre->getUser();
  3291. $email=$util->getEmail();
  3292. // $this->Envoi($email,$contenu);}
  3296. }
  3297. }
  3298. // $this->Envoi($emailuser,$contenu);
  3299. }
  3300. }
  3301. else{
  3302. foreach ($utils as $util)
  3303. {
  3304. if($util->hasRole('ROLE_RACHAT'))
  3305. {
  3307. $email=$util->getEmail();
  3308. // $this->Envoi($email,$contenu);
  3309. }
  3311. }
  3312. }
  3313. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  3315. }
  3320. }
  3322. //formulaire de confirmation du rejet d'une ligne du DA par un chef de projet
  3323. //formulaire de confirmation du rejet du DA par un chef de projet
  3325. public function rairefchefp($id): Response
  3326. {
  3327. $demach =$this->em->getRepository(demAchat::class)->find($id);
  3329. $form = $this->createFormBuilder($demach)
  3330. ->add('id')
  3331. ->add('raisonRefu')
  3332. ->getForm();
  3335. return $this->render('DemandeAchatVue/raisonrefu.html.twig'
  3336. ,['id_dem' => $id,'form' => $form->createView(),]
  3337. );
  3339. }
  3340. //rejet du DA par un chef de projet,
  3341. public function ajaxraisonrefu(Request $request): Response
  3342. {
  3343. $user = $this->security->getUser();
  3344. $id = $request->request->get('id');
  3345. $raisonRefu = $request->request->get('raison');
  3347. $demacha=$this->em->getRepository(demAchat::class)->find($id);
  3350. $dat=date('Y-m-d H:i:s');
  3351. $num= $demacha->getNumDemandeAchat();
  3352. $demachas=$this->em->getRepository(demAchat::class)->Selectnumda($num);
  3354. $use=$demacha->getUser();
  3355. $emailuser=$use->getEmail();
  3356. $num=$demacha->getNumDemandeAchat();
  3357. $nom=$use->getNom();
  3358. $prenom=$use->getPrenom();
  3361. if($user->hasRole('ROLE_CHEFP1') )
  3362. {
  3363. foreach($demachas as $demach)
  3364. {
  3365. $demach->setSigneChefp1($user);
  3366. $demach->setDrapoChefp1(0);
  3367. $demach->setDrapoChefprefu1(1);
  3368. $demach->setDateChefp1(new \DateTime($dat));
  3369. $demach->setRaisonRefu($raisonRefu);
  3372. }
  3373. $this->em->flush();
  3374. }
  3377. elseif($user->hasRole('ROLE_CHEFP2') )
  3378. {
  3379. foreach($demachas as $demach)
  3380. {
  3381. $demach->setSigneChefp2($user);
  3382. $demach->setDrapoChefp2(0);
  3383. $demach->setDrapoChefprefu2(1);
  3384. $demach->setRaisonRefu($raisonRefu);
  3385. $demach->setDateChefp2(new \DateTime($dat));
  3388. }
  3389. $this->em->flush();
  3390. }
  3391. elseif($user->hasRole('ROLE_CHEFP3') )
  3392. {
  3393. foreach($demachas as $demach)
  3394. {
  3395. $demach->setSigneChefp3($user);
  3396. $demach->setDrapoChefp3(0);
  3397. $demach->setDrapoChefprefu3(1);
  3398. $demach->setRaisonRefu($raisonRefu);
  3399. $demach->setDateChefp3(new \DateTime($dat));
  3401. }
  3402. $this->em->flush();
  3403. }
  3404. elseif($user->hasRole('ROLE_CHEFP4') )
  3405. {
  3406. foreach($demachas as $demach)
  3407. {
  3408. $demach->setSigneChefp4($user);
  3409. $demach->setDrapoChefp4(0);
  3410. $demach->setDrapoChefprefu4(1);
  3411. $demach->setRaisonRefu($raisonRefu);
  3412. $demach->setDateChefp4(new \DateTime($dat));
  3414. }
  3415. $this->em->flush();
  3416. }
  3417. elseif($user->hasRole('ROLE_CHEFP5') )
  3418. {
  3419. foreach($demachas as $demach)
  3420. {
  3421. $demach->setSigneChefp5($user);
  3422. $demach->setDrapoChefp5(0);
  3423. $demach->setRaisonRefu($raisonRefu);
  3424. $demach->setDrapoChefprefu5(1);
  3425. $demach->setDateChefp5(new \DateTime($dat));
  3427. }
  3428. $this->em->flush();
  3429. }
  3430. elseif($user->hasRole('ROLE_CHEFP6') )
  3431. {
  3432. foreach($demachas as $demach)
  3433. {
  3434. $demach->setSigneChefp6($user);
  3435. $demach->setDrapoChefp6(0);
  3436. $demach->setRaisonRefu($raisonRefu);
  3437. $demach->setDrapoChefprefu6(1);
  3438. $demach->setDateChefp6(new \DateTime($dat));
  3439. }
  3440. $this->em->flush();
  3441. }
  3442. elseif($user->hasRole('ROLE_CHEFP7') )
  3443. {
  3444. foreach($demachas as $demach)
  3445. {
  3446. $demach->setSigneChefp7($user);
  3447. $demach->setDrapoChefp7(0);
  3448. $demach->setRaisonRefu($raisonRefu);
  3449. $demach->setDrapoChefprefu7(1);
  3450. $demach->setDateChefp7(new \DateTime($dat));
  3451. }
  3452. $this->em->flush();
  3453. }
  3455. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3456. le Chef de projet n'a pas approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  3457. Suivez ce lien pour voir la demande:<br/>
  3458. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  3459. </body></html>";
  3462. //$this->Envoi($emailuser,$contenu);
  3466. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id)));
  3469. }
  3471. public function articleraisonrefu($id)
  3472. {
  3473. $demach =$this->em->getRepository(demAchat::class)->find($id);
  3475. $form = $this->createFormBuilder($demach)
  3476. ->add('id')
  3477. ->add('raisonRefu')
  3478. ->getForm();
  3481. return $this->render('DemandeAchatVue/articleraisonrefu.html.twig'
  3482. ,['id_dem' => $id,'form' => $form->createView(),]
  3483. );
  3485. }
  3487. public function ajaxarticlerefu(Request $request): Response
  3488. {
  3489. $user = $this->security->getUser();
  3490. $id = $request->request->get('id');
  3491. $raisonRefu = $request->request->get('raison');
  3493. $demacha=$this->em->getRepository(demAchat::class)->find($id);
  3494. $num= $demacha->getNumDemandeAchat();
  3496. $dat=date('Y-m-d H:i:s');
  3498. $demacha->setRaisonRefu($raisonRefu);
  3499. $demacha->setSigneChef($user);
  3500. $demacha->setDrapoRejetchef(1);
  3502. $this->em->flush();
  3503. $demachas=$this->em->getRepository(demAchat::class)->Selectnumda($num);
  3504. $idachat= $demachas[0]->getId();
  3507. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3508. le Chef de projet n'a pas approuv&eacute la demande d'achat N&deg$num .<br/><br/>
  3509. Suivez ce lien pour voir la demande:<br/>
  3510. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  3511. </body></html>";
  3513. // $this->Envoi($emailuser,$contenu);
  3517. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $idachat)));
  3521. }
  3523. public function moduleachat(): Response
  3524. {
  3525. $id = $request->request->get('id');
  3528. $data = $this->demandeAchatService ->getdaParUser($id); // ton return actuel
  3530. return new JsonResponse($data);
  3534. }
  3539. public function uploadPieceJointe(
  3540. Request $request,
  3541. DemAchat $demAchat,
  3542. EntityManagerInterface $em
  3543. ): JsonResponse {
  3544. // ✅ Défini UNE SEULE FOIS ici
  3545. $uploadDir = $this->getParameter('kernel.project_dir') . '/public/uploads/dem_achat';
  3547. $file = $request->files->get('pieceJointe');
  3549. if (!$file) {
  3550. return $this->json(['success' => false, 'message' => 'Aucun fichier reçu.'], 400);
  3551. }
  3553. $maxSize = 5 * 1024 * 1024;
  3554. if ($file->getSize() > $maxSize) {
  3555. return $this->json(['success' => false, 'message' => 'Fichier trop volumineux. Taille max : 5 Mo.'], 422);
  3556. }
  3558. $allowedExtensions = ['pdf', 'doc', 'docx', 'xls', 'xlsx', 'png', 'jpeg', 'txt'];
  3559. $extension = strtolower($file->getClientOriginalExtension());
  3560. if (!in_array($extension, $allowedExtensions)) {
  3561. return $this->json(['success' => false, 'message' => 'Type de fichier non autorisé.'], 422);
  3562. }
  3564. $newFilename = uniqid('pj_') . '.' . $extension;
  3566. // Créer le dossier s'il n'existe pas
  3567. if (!is_dir($uploadDir)) {
  3568. mkdir($uploadDir, 0777, true);
  3569. }
  3571. // Supprimer l'ancien fichier si existant
  3572. if ($demAchat->getPieceJointe()) {
  3573. $oldFile = $uploadDir . '/' . $demAchat->getPieceJointe();
  3574. if (file_exists($oldFile)) unlink($oldFile);
  3575. }
  3577. try {
  3578. $file->move($uploadDir, $newFilename);
  3579. } catch (\Exception $e) {
  3580. return $this->json(['success' => false, 'message' => 'Erreur lors de l\'upload : ' . $e->getMessage()], 500);
  3581. }
  3583. $demAchat->setPieceJointe($newFilename);
  3584. $em->flush();
  3586. return $this->json([
  3587. 'success' => true,
  3588. 'message' => 'Fichier uploadé avec succès.',
  3589. 'filename' => $newFilename,
  3590. 'downloadUrl' => '/uploads/dem_achat/' . $newFilename,
  3591. ]);
  3592. }
  3596. public function ajaxdrapodp(Request $request): Response
  3597. {
  3598. $data = $this->demandeAchatService->getDemachatSigneData($request);
  3599. $demachas = $data['demachas'];
  3600. $id_achat = $data['id_achat'];
  3601. $use = $data['user'];
  3602. $demacha = $data['demacha'];
  3603. $dat = $data['dat'];
  3607. // $iduser=$user->getId();
  3608. $total=0;
  3609. $totalprix=0;
  3610. if($use->hasRole('ROLE_DP1') )
  3611. {
  3612. foreach($demachas as $demach){
  3613. $demach->setSigneDP1($use);
  3614. $demach->setDrapoDP1(1);
  3615. $demach->setDrapoDPrefu1(0);
  3616. $demach->setDateDP1(new \DateTime($dat));
  3617. if($demach->getQuantAccorde() != null)
  3618. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3619. else
  3620. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3621. $this->em->persist($demach);}
  3622. $this->em->flush();
  3623. }
  3624. elseif($use->hasRole('ROLE_DP2') )
  3625. {
  3626. foreach($demachas as $demach){
  3627. $demach->setSigneDP2($use);
  3628. $demach->setDrapoDP2(1);
  3629. $demach->setDrapoDPrefu2(0);
  3630. $demach->setDateDP2(new \DateTime($dat));
  3631. if($demach->getQuantAccorde() != null)
  3632. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3633. else
  3634. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3635. $this->em->persist($demach);}
  3636. $this->em->flush();
  3637. }
  3638. elseif($use->hasRole('ROLE_DP3') )
  3639. {
  3640. foreach($demachas as $demach){
  3641. $demach->setSigneDP3($use);
  3642. $demach->setDrapoDP3(1);
  3643. $demach->setDrapoDPrefu3(0);
  3644. $demach->setDateDP3(new \DateTime($dat));
  3645. if($demach->getQuantAccorde() != null)
  3646. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3647. else
  3648. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3649. $this->em->persist($demach);}
  3650. $this->em->flush();
  3651. }
  3652. elseif($use->hasRole('ROLE_DP4') )
  3653. {
  3654. foreach($demachas as $demach){
  3655. $demach->setSigneDP4($use);
  3656. $demach->setDrapoDP4(1);
  3657. $demach->setDrapoDPrefu4(0);
  3658. $demach->setDateDP4(new \DateTime($dat));
  3659. if($demach->getQuantAccorde() != null)
  3660. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3661. else
  3662. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3663. $this->em->persist($demach);}
  3664. $this->em->flush();
  3665. }
  3667. elseif($use->hasRole('ROLE_DP5') )
  3668. {
  3669. foreach($demachas as $demach){
  3670. $demach->setSigneDP5($use);
  3671. $demach->setDrapoDP5(1);
  3672. $demach->setDrapoDPrefu5(0);
  3673. $demach->setDateDP5(new \DateTime($dat));
  3674. if($demach->getQuantAccorde() != null)
  3675. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3676. else
  3677. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3678. $this->em->persist($demach);}
  3679. $this->em->flush();
  3680. }
  3681. elseif($use->hasRole('ROLE_DP6') )
  3682. {
  3683. foreach($demachas as $demach){
  3684. $demach->setSigneDP6($use);
  3685. $demach->setDrapoDP6(1);
  3686. $demach->setDrapoDPrefu6(0);
  3687. $demach->setDateDP6(new \DateTime($dat));
  3688. if($demach->getQuantAccorde() != null)
  3689. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3690. else
  3691. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3692. $this->em->persist($demach);}
  3693. $this->em->flush();
  3694. }
  3695. elseif($use->hasRole('ROLE_DP7') )
  3696. {
  3697. foreach($demachas as $demach){
  3698. $demach->setSigneDP7($use);
  3699. $demach->setDrapoDP7(1);
  3700. $demach->setDrapoDPrefu7(0);
  3701. $demach->setDateDP7(new \DateTime($dat));
  3702. if($demach->getQuantAccorde() != null)
  3703. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3704. else
  3705. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3706. $this->em->persist($demach);}
  3707. $this->em->flush();
  3708. }
  3709. elseif($use->hasRole('ROLE_DP8') )
  3710. {
  3711. foreach($demachas as $demach){
  3712. $demach->setSigneDP8($use);
  3713. $demach->setDrapoDP8(1);
  3714. $demach->setDrapoDPrefu8(0);
  3715. $demach->setDateDP8(new \DateTime($dat));
  3716. if($demach->getQuantAccorde() != null)
  3717. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantAccorde());
  3718. else
  3719. $totalprix=$totalprix+($demach->getPrixU()*$demach->getQuantDemande());
  3720. $this->em->persist($demach);}
  3721. $this->em->flush();
  3722. }
  3723. /*$user=$demacha->getUser();
  3724. $emailuser=$user->getEmail();
  3725. $num=$demacha->getNumDemandeAchat();
  3726. $nom=$user->getNom();
  3727. $suphemail=$user->getSupH()->getEmail();
  3728. $prenom=$user->getPrenom();
  3729. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3730. le Directeur des Département a approuv&eacute la demande d'achat N&deg$num de Mrs/Mr $nom $prenom<br/><br/>
  3731. Suivez ce lien pour voir la demande:<br/>
  3732. http://www.intranet-mariestopesmali.org/web/gestionDemandeAchat
  3733. </body></html>";
  3735. $utils=$em->getRepository('mstopeUserBundle:User')->findAll();
  3737. $centrecout=$demacha->getCentreCout();
  3738. $nomProjet=$demacha->getNomProjet();
  3739. $baille = $em->getRepository('mstopeIntranetBundle:Bailleur')->findOneByLibele($nomProjet);
  3740. $bailleur = $em->getRepository('mstopeIntranetBundle:UseBailleur')->findOneByBailleur($baille);
  3741. $centre = $em->getRepository('mstopeIntranetBundle:CentreCout')->findOneByLibele($centrecout);
  3742. $usecentres = $em->getRepository('mstopeIntranetBundle:UserCentre')->findByCentrecout($centre);
  3743. $code= $usecentres[0]->getCode();
  3744. $usedp=null; $usefinance=null;
  3746. if($code==13)
  3747. {
  3748. foreach ($utils as $util)
  3749. {
  3752. if($util->hasRole('ROLE_DSCSC2') and $totalprix < 2500000)
  3753. {
  3755. $email=$util->getEmail();
  3756. //$this->Envoi($email,$contenu);
  3757. }
  3759. if($util->hasRole('ROLE_DSCSC') and $totalprix >2499999)
  3760. {
  3762. $email=$util->getEmail();
  3763. // $this->Envoi($email,$contenu);
  3764. }
  3766. }
  3767. }
  3768. if($code==61)
  3769. {
  3770. if($bailleur!=null){
  3771. $chefprojet=$bailleur->getUser();
  3772. $email=$chefprojet->getEmail();
  3773. // $this->Envoi($email,$contenu);
  3774. }
  3775. }
  3776. */
  3778. // $this->Envoi($emailuser,$contenu);
  3780. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  3783. }
  3785. public function ajaxdrapodprefu(Request $request): Response
  3786. {
  3788. $data = $this->demandeAchatService->getDemachatSigneData($request);
  3789. $demachas = $data['demachas'];
  3790. $id_achat = $data['id_achat'];
  3791. $user = $data['user'];
  3792. $demacha = $data['demacha'];
  3793. $dat = $data['dat'];
  3797. // $iduser=$user->getId();
  3798. $total=0;
  3799. $totalprix=0;
  3800. if($user->hasRole('ROLE_DP1') )
  3801. {
  3802. foreach($demachas as $demach){
  3803. $demach->setSigneDP1($user);
  3804. $demach->setDrapoDP1(0);
  3805. $demach->setDrapoDPrefu1(1);
  3806. $demach->setDateDP1(new \DateTime($dat));
  3807. $this->em->persist($demach);}
  3808. $this->em->flush();
  3809. }
  3810. elseif($user->hasRole('ROLE_DP2') )
  3811. {
  3812. foreach($demachas as $demach){
  3813. $demach->setSigneDP2($user);
  3814. $demach->setDrapoDP2(0);
  3815. $demach->setDrapoDPrefu2(1);
  3816. $demach->setDateDP2(new \DateTime($dat));
  3817. $this->em->persist($demach);}
  3818. $this->em->flush();
  3819. }
  3820. elseif($user->hasRole('ROLE_DP3') )
  3821. {
  3822. foreach($demachas as $demach){
  3823. $demach->setSigneDP3($user);
  3824. $demach->setDrapoDP3(0);
  3825. $demach->setDrapoDPrefu3(1);
  3826. $demach->setDateDP3(new \DateTime($dat));
  3827. $this->em->persist($demach);}
  3828. $this->em->flush();
  3829. }
  3830. elseif($user->hasRole('ROLE_DP4') )
  3831. {
  3832. foreach($demachas as $demach){
  3833. $demach->setSigneDP4($use);
  3834. $demach->setDrapoDP4(0);
  3835. $demach->setDrapoDPrefu4(1);
  3836. $demach->setDateDP4(new \DateTime($dat));
  3837. $this->em->persist($demach);}
  3838. $this->em->flush();
  3839. }
  3840. elseif($user->hasRole('ROLE_DP5') )
  3841. {
  3842. foreach($demachas as $demach){
  3843. $demach->setSigneDP5($user);
  3844. $demach->setDrapoDP5(0);
  3845. $demach->setDrapoDPrefu5(1);
  3846. $demach->setDateDP5(new \DateTime($dat));
  3847. $this->em->persist($demach);}
  3848. $this->em->flush();
  3849. }
  3850. elseif($user->hasRole('ROLE_DP6') )
  3851. {
  3852. foreach($demachas as $demach){
  3853. $demach->setSigneDP6($user);
  3854. $demach->setDrapoDP6(0);
  3855. $demach->setDrapoDPrefu6(1);
  3856. $demach->setDateDP6(new \DateTime($dat));
  3857. $this->em->persist($demach);}
  3858. $this->em->flush();
  3859. }
  3860. elseif($user->hasRole('ROLE_DP7') )
  3861. {
  3862. foreach($demachas as $demach){
  3863. $demach->setSigneDP7($user);
  3864. $demach->setDrapoDP7(0);
  3865. $demach->setDrapoDPrefu7(1);
  3866. $demach->setDateDP7(new \DateTime($dat));
  3867. $this->em->persist($demach);}
  3868. $this->em->flush();
  3869. }
  3870. elseif($user->hasRole('ROLE_DP8') )
  3871. {
  3872. foreach($demachas as $demach){
  3873. $demach->setSigneDP8($user);
  3874. $demach->setDrapoDP8(0);
  3875. $demach->setDrapoDPrefu8(1);
  3876. $demach->setDateDP8(new \DateTime($dat));
  3877. $this->em->persist($demach);}
  3878. $this->em->flush();
  3879. }
  3881. /* $user=$demacha->getUser();
  3882. $emailuser=$user->getEmail();
  3883. $num=$demacha->getNumDemandeAchat();
  3884. $nom=$user->getNom();
  3885. $suphemail=$user->getSupH()->getEmail();
  3886. $prenom=$user->getPrenom();
  3887. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3888. le Directeur de Département n'a pas approuv&eacute la demande d'achat N&deg$num
  3889. de Mrs/Mr $nom $prenom<br/><br/>
  3890. Suivez ce lien pour voir la demande:<br/>
  3892. </body></html>";*/
  3894. //$this->Envoi($suphemail,$contenu);
  3895. //$this->Envoi($emailuser,$contenu);
  3897. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  3903. }
  3905. public function ajaxdrapodscsc(Request $request): Response
  3906. {
  3908. $data = $this->demandeAchatService->getDemachatSigneData($request);
  3909. $demachas = $data['demachas'];
  3910. $id_achat = $data['id_achat'];
  3911. $user = $data['user'];
  3912. $demacha = $data['demacha'];
  3913. $dat = $data['dat'];
  3915. $totalprix=0;
  3916. $dat=date('Y-m-d H:i:s');
  3917. foreach ($demachas as $demach) {
  3918. $demach->setSigneDF($user);
  3919. $demach->setDrapoDSCSC(1);
  3920. $demach->setDrapoDSCSCrefu(0);
  3921. $demach->setDateDSCSC(new \DateTime($dat));
  3923. if ($demach->getMontant() < 5000000) {
  3924. $demach->setDrapoValide(1);
  3925. $this->em->persist($demach);
  3926. $this->em->flush();
  3928. // ── Consommer le budget ───────────────────────────────────────
  3929. $this->planBudgetService->consommerBudget($demach);
  3930. } else {
  3931. $this->em->persist($demach);
  3932. }
  3935. }
  3937. $this->em->flush();
  3941. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  3946. }
  3948. public function ajaxdrapodscscrefu(Request $request): Response
  3949. {
  3950. $data = $this->demandeAchatService->getDemachatSigneData($request);
  3951. $demachas = $data['demachas'];
  3952. $id_achat = $data['id_achat'];
  3953. $user = $data['user'];
  3954. $demacha = $data['demacha'];
  3955. $dat = $data['dat'];
  3957. $totalprix=0;
  3958. $dat=date('Y-m-d H:i:s');
  3960. foreach($demachas as $demach){
  3961. $demach->setSigneDF($user);
  3962. $demach->setDrapoDSCSC(0);
  3963. $demach->setDrapoDSCSCrefu(1);
  3964. $demach->setDateDSCSC(new \DateTime($dat));
  3967. $this->em->persist($demach);}
  3968. $this->em->flush();
  3969. /* $user=$demacha->getUser();
  3970. $emailuser=$user->getEmail();
  3971. $num=$demacha->getNumDemandeAchat();
  3972. $nom=$user->getNom();
  3973. $suphemail=$user->getSupH()->getEmail();
  3974. $prenom=$user->getPrenom();
  3975. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  3976. la Finance n'a pas approuv&eacute la demande d'achat N&deg$num de Mrs/Mr $nom $prenom<br/><br/>
  3977. Suivez ce lien pour voir la demande:<br/>
  3979. </body></html>";
  3981. $users=$em->getRepository('mstopeUserBundle:User')->findAll();
  3982. foreach ($users as $use)
  3983. {
  3984. if($use->hasRole('ROLE_RR')){
  3985. //if($use->hasRole('ROLE_ADMIN')){
  3986. $emaildest=$use->getEmail();
  3987. $this->Envoi($emaildest,$contenu);
  3988. }
  3989. }
  3990. $this->Envoi($suphemail,$contenu);
  3991. $this->Envoi($emailuser,$contenu);*/
  3994. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  3998. }
  4001. public function ajaxdraporr(Request $request): Response
  4002. {
  4003. $data = $this->demandeAchatService->getDemachatSigneData($request);
  4004. $demachas = $data['demachas'];
  4005. $id_achat = $data['id_achat'];
  4006. $user = $data['user'];
  4007. $demacha = $data['demacha'];
  4008. $dat = $data['dat'];
  4010. $totalprix=0;
  4011. $dat=date('Y-m-d H:i:s');
  4013. foreach ($demachas as $demacha) {
  4014. $demacha->setSigneRR($user);
  4015. $demacha->setDrapoRR(1);
  4016. $demacha->setDrapoRRrefu(0);
  4017. $demacha->setDrapoImp(1);
  4018. $demacha->setDrapoValide(1);
  4019. $demacha->setDateRR(new \DateTime($dat));
  4020. $this->em->persist($demacha);
  4021. $this->em->flush();
  4023. // ── Consommer le budget ───────────────────────────────────────────
  4024. $this->planBudgetService->consommerBudget($demacha);
  4025. }
  4027. $this->em->flush();$this->em->flush();
  4029. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  4033. }
  4036. public function ajaxdraporrrefu(Request $request): Response
  4037. {
  4038. $data = $this->demandeAchatService->getDemachatSigneData($request);
  4039. $demachas = $data['demachas'];
  4040. $id_achat = $data['id_achat'];
  4041. $user = $data['user'];
  4042. $demacha = $data['demacha'];
  4043. $dat = $data['dat'];
  4045. foreach($demachas as $demacha){
  4046. $demacha->setSigneRR($user);
  4047. $demacha->setDrapoRR(0);
  4048. $demacha->setDrapoRRrefu(1);
  4049. $demacha->setDateRR(new \DateTime($dat));
  4051. //$demacha->setDrapoRR(0);
  4052. //$demacha->setDrapoRRrefu(1);
  4053. $this->em->persist($demacha);}
  4054. $this->em->flush();
  4055. /*
  4056. $user=$demacha->getUser();
  4057. $emailuser=$user->getEmail();
  4058. $num=$demacha->getNumDemandeAchat();
  4059. $nom=$user->getNom();
  4060. $prenom=$user->getPrenom();
  4061. $contenu="<html><head></head><body><b>Bonjour</b>,<br/>
  4062. le Repr&eacutesentant R&eacutesident n'a pas approuv&eacute la demande d'achat N&deg$num
  4063. de Mrs/Mr $nom $prenom<br/>
  4064. <br/>
  4066. Suivez ce lien pour voir la demande:<br/>
  4068. </body></html>";
  4070. $users=$em->getRepository('mstopeUserBundle:User')->findAll();
  4071. foreach ($users as $use)
  4072. {
  4073. if($use->hasRole('ROLE_ADMIN')){
  4074. //if($use->hasRole('ROLE_ADMIN')){
  4075. $emaildest=$use->getEmail();
  4076. $this->Envoi($emaildest,$contenu);
  4077. }
  4078. }
  4079. // $this->Envoi($suphemail,$contenu);
  4080. $this->Envoi($emailuser,$contenu);*/
  4082. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $id_achat)));
  4088. }
  4090. public function ajaxlistnum4( Request $request): JsonResponse
  4091. {
  4092. // Tableau de réponse
  4093. $listnum4 = [];
  4097. // Récupérer l'id envoyé
  4098. $id = $request->request->get('id');
  4100. // Récupérer l'utilisateur
  4101. $user = $this->em->getRepository(User::class)->find($id);
  4105. // Récupérer les demandes d'achat
  4106. $dems = $this->em->getRepository(demAchat::class) ->SelectListdemachat($user);
  4108. // Valeur par défaut
  4109. $listnum4[0] = 'choisir';
  4111. // Remplir le tableau
  4112. foreach ($dems as $dem) {
  4113. $listnum4[$dem->getId()] = $dem->getNumDemandeAchat();
  4114. }
  4118. // Retour JSON
  4119. return new JsonResponse($listnum4);
  4120. }
  4122. public function ajaxlistnum6( Request $request): JsonResponse
  4123. {
  4124. // Tableau de réponse
  4125. $listnum6 = [];
  4128. $dems=array();
  4129. // Récupérer l'id envoyé
  4130. $id = $request->request->get('id');
  4132. // Récupérer l'utilisateur
  4133. $useb = $this->em->getRepository(UseBailleur::class)->find($id);
  4135. $bail=$useb->getBailleur();
  4137. // Récupérer les demandes d'achat
  4138. $dems = $this->em->getRepository(demAchat::class) ->listDemachatBail($bail);
  4140. // Valeur par défaut
  4141. $listnum6[0] = 'choisir';
  4143. // Remplir le tableau
  4144. foreach ($dems as $dem) {
  4145. $listnum6[$dem->getId()] = $dem->getNumDemandeAchat();
  4146. }
  4150. // Retour JSON
  4151. return new JsonResponse($listnum6);
  4152. }
  4155. public function ajaxmodifcontracadre($id_dem)
  4156. {
  4158. $demac = $this->em->getRepository(demAchat::class)->find($id_dem);
  4161. // ============================
  4162. // Contrats compatibles
  4163. // ============================
  4165. $contratsDisponibles = [];
  4167. $categorieCatalogue =
  4168. $demac->getCatalogue()?->getCategorycatalogue();
  4170. if ($categorieCatalogue) {
  4172. foreach ( $categorieCatalogue->getCategoriesMarche()as $categorieMarche) {
  4173. $v=0;
  4174. $contrats = $this->em
  4175. ->getRepository(ContratCadre::class)
  4176. ->createQueryBuilder('cc')
  4177. ->where('cc.categorieMarche = :cat')
  4178. ->andWhere('cc.actif = true')
  4179. ->setParameter('cat', $categorieMarche)
  4180. ->orderBy('cc.reference', 'ASC')
  4181. ->getQuery()
  4182. ->getResult();
  4184. foreach ($contrats as $cc) {
  4186. $contratsDisponibles[$cc->getId()] = $cc;
  4188. }
  4189. }
  4190. }
  4192. $contratsDisponibles = array_values($contratsDisponibles);
  4193. // ============================
  4194. // Formulaire
  4195. // ============================
  4197. $form = $this->createFormBuilder($demac)
  4198. ->add('id', HiddenType::class)
  4199. ->add('contratCadre', EntityType::class, [
  4200. 'class' => ContratCadre::class,
  4202. 'choices' => $contratsDisponibles,
  4204. 'choice_label' => function ($cc) {
  4206. return sprintf(
  4207. '%s - %s',
  4208. $cc->getReference(),
  4209. $cc->getFournisseur()?->getRaisonSociale()
  4210. );
  4211. },
  4213. 'placeholder' => 'Aucun contrat-cadre',
  4215. 'required' => false,
  4216. ])
  4218. ->getForm();
  4220. return $this->render('DemandeAchatVue/ajaxmodifcontracadre.html.twig'
  4221. ,['id_dem' => $id_dem,'form' => $form->createView(),]
  4222. );
  4223. }
  4225. public function modifcontracadre(Request $request): Response
  4226. {
  4228. $idContrat = $request->request->get('contrat');
  4229. $idDemande = $request->request->get('id');
  4231. $demacha = $this->em
  4232. ->getRepository(demAchat::class)
  4233. ->find($idDemande);
  4235. if (!$demacha) {
  4237. return new JsonResponse([
  4238. 'success' => false,
  4239. 'message' => 'Demande achat introuvable.'
  4240. ]);
  4241. }
  4243. // =========================
  4244. // Ancien contrat
  4245. // =========================
  4247. $ancienContrat = $demacha->getContratCadre();
  4249. // =========================
  4250. // Nouveau contrat
  4251. // =========================
  4253. $nouveauContrat = null;
  4255. if (!empty($idContrat)) {
  4257. $nouveauContrat = $this->em
  4258. ->getRepository(ContratCadre::class)
  4259. ->find($idContrat);
  4261. if (!$nouveauContrat) {
  4263. return new JsonResponse([
  4264. 'success' => false,
  4265. 'message' => 'Contrat-cadre introuvable.'
  4266. ]);
  4267. }
  4268. }
  4270. // =========================
  4271. // Calcul montant réservation
  4272. // =========================
  4274. $montantLigne =
  4275. (float)$demacha->getPrixU()
  4276. *
  4277. (float)$demacha->getQuantDemande();
  4279. // TVA éventuelle
  4280. if ($demacha->getTva()) {
  4282. $montantLigne +=
  4283. $montantLigne
  4284. *
  4285. ((float)$demacha->getTva() / 100);
  4286. }
  4288. // =========================
  4289. // Retirer réservation ancien contrat
  4290. // =========================
  4292. if ($ancienContrat) {
  4294. $ancienReserve =
  4295. (float)$ancienContrat->getMontantReserve();
  4297. $ancienContrat->setMontantReserve(
  4298. (string)max(
  4299. 0,
  4300. $ancienReserve - $montantLigne
  4301. )
  4302. );
  4304. $this->em->persist($ancienContrat);
  4305. }
  4307. // =========================
  4308. // Ajouter réservation nouveau contrat
  4309. // =========================
  4311. if ($nouveauContrat) {
  4313. $nouveauReserve =
  4314. (float)$nouveauContrat->getMontantReserve();
  4316. $nouveauContrat->setMontantReserve(
  4317. (string)($nouveauReserve + $montantLigne)
  4318. );
  4320. $this->em->persist($nouveauContrat);
  4321. }
  4323. // =========================
  4324. // Mise à jour DA
  4325. // =========================
  4327. $demacha->setContratCadre($nouveauContrat);
  4329. // statut contrat
  4330. if ($nouveauContrat) {
  4332. $demacha->setStatutContratCadree(
  4333. demAchat::CC_VALIDE
  4334. );
  4336. } else {
  4338. $demacha->setStatutContratCadree(null);
  4339. }
  4341. $this->em->persist($demacha);
  4343. // =========================
  4344. // Save
  4345. // =========================
  4347. $this->em->flush();
  4349. return $this->redirect( $this->generateUrl('liste_demachat', array('id' => $idDemande)));
  4351. }
  4353. public function supprimeracha($id)
  4354. {
  4356. $demac = $this->em->getRepository(demAchat::class)->find($id);
  4358. $form = $this->createFormBuilder($demac)
  4359. ->add('id', HiddenType::class) ->getForm();
  4361. return $this->render('DemandeAchatVue/supprimeracha.html.twig'
  4362. ,['id' => $id,'form' => $form->createView(),]
  4363. );
  4364. }
  4366. public function ajaxsupprimeracha(Request $request): Response
  4367. {
  4370. $idDemande = $request->request->get('id');
  4372. $demacha = $this->em
  4373. ->getRepository(demAchat::class)
  4374. ->find($idDemande);
  4375. $num=$demacha->getNumDemandeAchat();
  4376. if (!$demacha) {
  4378. return new JsonResponse([
  4379. 'success' => false,
  4380. 'message' => 'Demande achat introuvable.'
  4381. ]);
  4382. }
  4384. // =========================
  4385. // Ancien contrat
  4386. // =========================
  4388. $ancienContrat = $demacha->getContratCadre();
  4391. // =========================
  4392. // Calcul montant réservation
  4393. // =========================
  4395. $montantLigne =
  4396. (float)$demacha->getPrixU()
  4397. *
  4398. (float)$demacha->getQuantDemande();
  4400. // TVA éventuelle
  4401. if ($demacha->getTva()) {
  4403. $montantLigne +=
  4404. $montantLigne
  4405. *
  4406. ((float)$demacha->getTva() / 100);
  4407. }
  4409. // =========================
  4410. // Retirer réservation ancien contrat
  4411. // =========================
  4413. if ($ancienContrat) {
  4415. $ancienReserve =
  4416. (float)$ancienContrat->getMontantReserve();
  4418. $ancienContrat->setMontantReserve(
  4419. (string)max(
  4420. 0,
  4421. $ancienReserve - $montantLigne
  4422. )
  4423. );
  4425. $this->em->persist($ancienContrat);
  4426. }
  4429. $this->em->remove($demacha);
  4430. //$this->em->persist($demacha);
  4432. // =========================
  4433. // Save
  4434. // =========================
  4436. $this->em->flush();
  4438. $demacha = $this->em
  4439. ->getRepository(demAchat::class)
  4440. ->findOneByNumDemandeAchat($num);
  4442. return $this->redirect( $this->generateUrl('liste_demachat', array('id' =>$demacha ->getId())));
  4444. }
  4446. public function ajaxmodifierdemachatemp(int $id_dem, DemAchatTempRepository $repository): Response
  4447. {
  4448. $demach = $repository->find($id_dem);
  4450. if (!$demach) {
  4451. throw $this->createNotFoundException('Demande non trouvée');
  4452. }
  4454. $form19 = $this->createFormBuilder($demach)
  4455. ->add('id', HiddenType::class)
  4456. ->add('objet', TextType::class, ['required' => false])
  4457. ->add('quantDemande')
  4458. ->add('description')
  4459. ->add('designation', TextType::class, ['required' => false])
  4460. ->add('nombaille', EntityType::class, [
  4461. 'class' => Bailleur::class,
  4462. 'choice_label' => 'libele',
  4463. ])
  4464. ->add('costcenter', EntityType::class, [
  4465. 'class' => CentreCout::class,
  4466. 'choice_label' => 'libele',
  4467. ])
  4468. ->add('prixU', IntegerType::class)
  4469. ->add('region', ChoiceType::class, [
  4470. 'choices' => [
  4471. 'Segou' => 'Segou',
  4472. 'Mopti' => 'Mopti',
  4473. 'Sikasso' => 'Sikasso',
  4474. 'Bamako' => 'Bamako'
  4475. ],
  4476. 'placeholder' => ''
  4477. ])
  4478. ->getForm();
  4480. return $this->render('DemandeAchatVue/modifierdemachatemp.html.twig', [
  4481. 'id_dem' => $id_dem,
  4482. 'form19' => $form19->createView()
  4483. ]);
  4484. }
  4486. public function modifierdemachatemp(
  4487. Request $request,
  4488. EntityManagerInterface $em,
  4489. DemAchatTempRepository $repo
  4490. ): Response {
  4492. // Vérification AJAX
  4493. if (!$request->isXmlHttpRequest()) {
  4494. return new Response('Accès non autorisé', 403);
  4495. }
  4497. // Récupération des données via $request->request
  4498. $listnum = $request->request->get('id');
  4499. $demach = $repo->find($listnum);
  4501. if (!$demach) {
  4502. throw $this->createNotFoundException('Demande non trouvée');
  4503. }
  4505. // Hydratation des entités liées
  4506. $idcentreCout = $request->request->get('centreCout');
  4507. $idnomProjet = $request->request->get('nomProjet');
  4509. $centreCout = $em->getRepository(CentreCout::class)->find($idcentreCout);
  4510. $bailleur = $em->getRepository(Bailleur::class)->find($idnomProjet);
  4512. // Gestion du catalogue
  4513. $designation = $request->request->get('designatio');
  4514. $design = null;
  4515. if ($designation) {
  4516. $design = $em->getRepository(Catalogue::class)->findBy(['designation' => $designation]);
  4517. }
  4519. if ($design ) {
  4520. $demach->setDesignation($design[0]->getDesignation());
  4521. $demach->setCatalogue($design[0]);
  4522. } else {
  4523. $demach->setDesignation('votre article selectionner ne se trouve pas dans le catalogue');
  4524. }
  4526. // Mise à jour des propriétés
  4527. $demach->setPrixU((int)$request->request->get('prixU'));
  4528. $demach->setQuantDemande($request->request->get('quantd'));
  4529. $demach->setDescription($request->request->get('descrip'));
  4530. $demach->setObjet($request->request->get('objet'));
  4532. if ($centreCout) {
  4533. $demach->setCentreCout($centreCout->getLibele());
  4534. $demach->setCostcenter($centreCout);
  4535. }
  4537. if ($bailleur) {
  4538. $demach->setNomProjet($bailleur->getLibele());
  4539. $demach->setNombaille($bailleur);
  4540. }
  4542. // Mise à jour de la collection (DA groupées)
  4543. $demachats = $repo->findBy(['numDemandeAchat' => $demach->getNumDemandeAchat()]);
  4544. foreach ($demachats as $demachat) {
  4545. $demachat->setObjet($request->request->get('objet'));
  4546. $demachat->setRegion($request->request->get('region'));
  4547. }
  4549. $em->flush();
  4551. return $this->redirectToRoute('liste_da_temp', ['id' => $demach->getNumDemandeAchat()]);
  4552. }
  4555. }