src/Repository/Idempiere/CCurrencyRepository.php line 33

Open in your IDE?
  1. <?php
  3. namespace App\Repository\Idempiere;
  5. use App\Constant;
  6. use App\Entity\Idempiere\CCurrency;
  7. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  8. use Doctrine\Persistence\ManagerRegistry;
  10. /**
  11. * @method CCurrency|null find($id, $lockMode = null, $lockVersion = null)
  12. * @method CCurrency|null findOneBy(array $criteria, array $orderBy = null)
  13. * @method CCurrency[] findAll()
  14. * @method CCurrency[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  15. */
  16. class CCurrencyRepository extends ServiceEntityRepository
  17. {
  18. public function __construct(ManagerRegistry $registry)
  19. {
  20. parent::__construct($registry, CCurrency::class);
  21. }
  23. /**
  24. * Convertir el monto con la tasa del sistema
  25. * @param float $Amt Monto a convertir
  26. * @param int $C_Currency_ID Moneda base
  27. * @param int $C_Currency_To_ID Moneda destino
  28. * @param string $Date Fecha de la tasa
  29. * @param int $C_ConversionType_ID Tipo de conversion/tasa
  30. * @param int $AD_Client_ID Grupo empresarial
  31. * @param int $AD_Org_ID Organizacion
  32. */
  33. public function convertAmt(Float $Amt, Int $C_Currency_ID, Int $C_Currency_To_ID, String $Date = null,
  34. Int $C_ConversionType_ID, Int $AD_Client_ID = 0, Int $AD_Org_ID = 0
  35. )
  36. {
  37. if ( is_null($Date) )
  38. $Date = date('Y-m-d H:i:s');
  40. $conn = $this->getEntityManager()->getConnection();
  42. $sql = 'SELECT CURRENCYCONVERT(:payamt, :currency_id, :currencytarget_id, :dateacct, :conversiontype_id, :client_id, :org_id)';
  43. $stmt = $conn->prepare($sql);
  44. $rs = $stmt->executeQuery([
  45. 'payamt' => $Amt,
  46. 'currency_id' => $C_Currency_ID,
  47. 'currencytarget_id' => $C_Currency_To_ID,
  48. 'dateacct' => $Date,
  49. 'conversiontype_id' => $C_ConversionType_ID,
  50. 'client_id' => $AD_Client_ID,
  51. 'org_id' => $AD_Org_ID
  52. ]);
  54. return $rs->fetchOne();
  55. }
  56. }