r_FraisKm3.bas 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
  1. Operation =1
  2. Option =0
  3. Begin InputTables
  4. Name ="r_FraisKm2"
  5. Name ="tbl_baremes"
  6. End
  7. Begin OutputColumns
  8. Expression ="r_FraisKm2.CodeAgent"
  9. Expression ="r_FraisKm2.AnneeRH"
  10. Expression ="r_FraisKm2.MoisRH"
  11. Expression ="r_FraisKm2.TypeVehicule"
  12. Expression ="tbl_baremes.Commentaire"
  13. Expression ="tbl_baremes.NomBareme"
  14. Expression ="r_FraisKm2.PeriodeBareme"
  15. Expression ="tbl_baremes.BorneInf"
  16. Expression ="tbl_baremes.BorneSup"
  17. Expression ="tbl_baremes.UniteBornes"
  18. Expression ="tbl_baremes.Valeur"
  19. Expression ="tbl_baremes.UniteValeur"
  20. Expression ="r_FraisKm2.DistanceAnnee"
  21. Expression ="r_FraisKm2.DistanceMois"
  22. Alias ="DistanceAnneeRepartie"
  23. Expression ="IIf([DistanceAnnee]>[BorneSup],([BorneSup]-[BorneInf]),IIf([DistanceAnnee]>[Born"
  24. "eInf],[DistanceAnnee]-[BorneInf],0))"
  25. Alias ="DistanceMoisRepartie"
  26. Expression ="IIf(([DistanceAnnee]+[DistanceMois])>[BorneSup],([BorneSup]-[BorneInf]),IIf(([Di"
  27. "stanceAnnee]+[DistanceMois])>[BorneInf],([DistanceAnnee]+[DistanceMois])-[BorneI"
  28. "nf],0))-[DistanceAnneeRepartie]"
  29. Alias ="Montant"
  30. Expression ="CCur([DistanceMoisRepartie]*[Valeur])"
  31. End
  32. Begin Joins
  33. LeftTable ="r_FraisKm2"
  34. RightTable ="tbl_baremes"
  35. Expression ="r_FraisKm2.BaremeUtilise = tbl_baremes.NomBareme"
  36. Flag =1
  37. LeftTable ="r_FraisKm2"
  38. RightTable ="tbl_baremes"
  39. Expression ="r_FraisKm2.PeriodeBareme = tbl_baremes.PeriodeValidite"
  40. Flag =1
  41. End
  42. Begin OrderBy
  43. Expression ="r_FraisKm2.CodeAgent"
  44. Flag =0
  45. Expression ="r_FraisKm2.AnneeRH"
  46. Flag =0
  47. Expression ="r_FraisKm2.MoisRH"
  48. Flag =0
  49. Expression ="tbl_baremes.NomBareme"
  50. Flag =0
  51. Expression ="tbl_baremes.BorneInf"
  52. Flag =0
  53. End
  54. dbBoolean "ReturnsRecords" ="-1"
  55. dbInteger "ODBCTimeout" ="60"
  56. dbByte "RecordsetType" ="0"
  57. dbBoolean "OrderByOn" ="0"
  58. dbByte "Orientation" ="0"
  59. dbByte "DefaultView" ="2"
  60. dbBoolean "FilterOnLoad" ="0"
  61. dbBoolean "OrderByOnLoad" ="-1"
  62. dbBoolean "TotalsRow" ="0"
  63. Begin
  64. Begin
  65. dbText "Name" ="tbl_baremes.Commentaire"
  66. dbLong "AggregateType" ="-1"
  67. End
  68. Begin
  69. dbText "Name" ="tbl_baremes.NomBareme"
  70. dbLong "AggregateType" ="-1"
  71. End
  72. Begin
  73. dbText "Name" ="tbl_baremes.BorneInf"
  74. dbLong "AggregateType" ="-1"
  75. End
  76. Begin
  77. dbText "Name" ="r_FraisKm2.DistanceMois"
  78. dbLong "AggregateType" ="-1"
  79. End
  80. Begin
  81. dbText "Name" ="tbl_baremes.BorneSup"
  82. dbLong "AggregateType" ="-1"
  83. End
  84. Begin
  85. dbText "Name" ="tbl_baremes.UniteBornes"
  86. dbLong "AggregateType" ="-1"
  87. End
  88. Begin
  89. dbText "Name" ="tbl_baremes.Valeur"
  90. dbLong "AggregateType" ="-1"
  91. End
  92. Begin
  93. dbText "Name" ="tbl_baremes.UniteValeur"
  94. dbLong "AggregateType" ="-1"
  95. End
  96. Begin
  97. dbText "Name" ="r_FraisKm2.CodeAgent"
  98. dbLong "AggregateType" ="-1"
  99. End
  100. Begin
  101. dbText "Name" ="r_FraisKm2.MoisRH"
  102. dbLong "AggregateType" ="-1"
  103. End
  104. Begin
  105. dbText "Name" ="r_FraisKm2.AnneeRH"
  106. dbLong "AggregateType" ="-1"
  107. End
  108. Begin
  109. dbText "Name" ="r_FraisKm2.DistanceAnnee"
  110. dbLong "AggregateType" ="-1"
  111. End
  112. Begin
  113. dbText "Name" ="DistanceAnneeRepartie"
  114. dbInteger "ColumnWidth" ="2340"
  115. dbBoolean "ColumnHidden" ="0"
  116. dbLong "AggregateType" ="-1"
  117. End
  118. Begin
  119. dbText "Name" ="DistanceMoisRepartie"
  120. dbLong "AggregateType" ="-1"
  121. dbInteger "ColumnWidth" ="2715"
  122. dbBoolean "ColumnHidden" ="0"
  123. End
  124. Begin
  125. dbText "Name" ="Montant"
  126. dbLong "AggregateType" ="-1"
  127. End
  128. Begin
  129. dbText "Name" ="r_FraisKm2.PeriodeBareme"
  130. dbLong "AggregateType" ="-1"
  131. End
  132. Begin
  133. dbText "Name" ="r_FraisKm2.TypeVehicule"
  134. dbLong "AggregateType" ="-1"
  135. End
  136. End
  137. Begin
  138. State =0
  139. Left =0
  140. Top =0
  141. Right =1125
  142. Bottom =545
  143. Left =-1
  144. Top =-1
  145. Right =1109
  146. Bottom =53
  147. Left =0
  148. Top =0
  149. ColumnsShown =539
  150. Begin
  151. Left =48
  152. Top =12
  153. Right =207
  154. Bottom =200
  155. Top =0
  156. Name ="r_FraisKm2"
  157. Name =""
  158. End
  159. Begin
  160. Left =372
  161. Top =9
  162. Right =608
  163. Bottom =192
  164. Top =0
  165. Name ="tbl_baremes"
  166. Name =""
  167. End
  168. End