Metelin

raca

Aug 1st, 2020
16
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. $this->db->where('pais','argentina');
  3. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  4. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  5. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  6. $consulta=$this->db->get_where('cooperativa');
  7. $fila1=$consulta->row();
  8.  
  9. // Stock KG
  10. $data['fonarg']=number_format($fila1->fondocoop/100, 0, '', '.');
  11. $data['gasarg']=number_format($fila1->gaso, 0, ',', '.');
  12. $data['agarg']=number_format($fila1->agua, 0, ',', '.');
  13. $data['maqgarg']=number_format($fila1->maqagri, 0, ',', '.');
  14. $data['maqearg']=number_format($fila1->maqenva, 0, ',', '.');
  15. $data['ferarg']=number_format($fila1->fertil, 0, ',', '.');
  16. $data['pesarg']=number_format($fila1->pestic, 0, ',', '.');
  17. $data['piearg']=number_format($fila1->pienso, 0, ',', '.');
  18. $data['fitarg']=number_format($fila1->fitosa, 0, ',', '.');
  19. $data['alcarg']=number_format($fila1->alcoho, 0, ',', '.');
  20. $data['exarg']=number_format($fila1->extracto, 0, ',', '.');
  21. $data['petarg']=number_format($fila1->pet, 0, ',', '.');
  22.  
  23. // Precio venta (precio subvencionado)
  24. $data['subgasarg']=number_format($fila1->prgaso/100, 0, ',', '.');
  25. $data['subagarg']=number_format($fila1->pragua/100, 0, ',', '.');
  26. $data['submaqgarg']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  27. $data['submaqearg']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  28. $data['subferarg']=number_format($fila1->prfertil/100, 0, ',', '.');
  29. $data['subpesarg']=number_format($fila1->prpestic/100, 0, ',', '.');
  30. $data['subpiearg']=number_format($fila1->prpienso/100, 0, ',', '.');
  31. $data['subfitarg']=number_format($fila1->prfitosa/100, 0, ',', '.');
  32. $data['subalcarg']=number_format($fila1->pralcoho/100, 0, ',', '.');
  33. $data['subexarg']=number_format($fila1->prextracto/100, 0, ',', '.');
  34. $data['subpetarg']=number_format($fila1->prpet/100, 0, ',', '.');
  35.  
  36. // Precio Coste (precio medio)
  37. $data['prgasarg']=number_format($fila1->prgaso/100, 0, ',', '.');
  38. $data['pragarg']=number_format($fila1->pragua/100, 0, ',', '.');
  39. $data['prmaqgarg']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  40. $data['prmaqearg']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  41. $data['prferarg']=number_format($fila1->prfertil/100, 0, ',', '.');
  42. $data['prpesarg']=number_format($fila1->prpestic/100, 0, ',', '.');
  43. $data['prpiearg']=number_format($fila1->prpienso/100, 0, ',', '.');
  44. $data['prfitarg']=number_format($fila1->prfitosa/100, 0, ',', '.');
  45. $data['pralcarg']=number_format($fila1->pralcoho/100, 0, ',', '.');
  46. $data['prexarg']=number_format($fila1->prextracto/100, 0, ',', '.');
  47. $data['prpetarg']=number_format($fila1->prpet/100, 0, ',', '.');
  48.  
  49. $this->db->where('pais','catalunya');
  50. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  51. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  52. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  53. $consulta=$this->db->get_where('cooperativa');
  54. $fila1=$consulta->row();
  55.  
  56. // Stock KG
  57. $data['foncat']=number_format($fila1->fondocoop/100, 0, '', '.');
  58. $data['gascat']=number_format($fila1->gaso, 0, ',', '.');
  59. $data['agcat']=number_format($fila1->agua, 0, ',', '.');
  60. $data['maqgcat']=number_format($fila1->maqagri, 0, ',', '.');
  61. $data['maqecat']=number_format($fila1->maqenva, 0, ',', '.');
  62. $data['fercat']=number_format($fila1->fertil, 0, ',', '.');
  63. $data['pescat']=number_format($fila1->pestic, 0, ',', '.');
  64. $data['piecat']=number_format($fila1->pienso, 0, ',', '.');
  65. $data['fitcat']=number_format($fila1->fitosa, 0, ',', '.');
  66. $data['alccat']=number_format($fila1->alcoho, 0, ',', '.');
  67. $data['excat']=number_format($fila1->extracto, 0, ',', '.');
  68. $data['petcat']=number_format($fila1->pet, 0, ',', '.');
  69.  
  70. // Precio venta (precio subvencionado)
  71. $data['subgascat']=number_format($fila1->prgaso/100, 0, ',', '.');
  72. $data['subagcat']=number_format($fila1->pragua/100, 0, ',', '.');
  73. $data['submaqgcat']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  74. $data['submaqecat']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  75. $data['subfercat']=number_format($fila1->prfertil/100, 0, ',', '.');
  76. $data['subpescat']=number_format($fila1->prpestic/100, 0, ',', '.');
  77. $data['subpiecat']=number_format($fila1->prpienso/100, 0, ',', '.');
  78. $data['subfitcat']=number_format($fila1->prfitosa/100, 0, ',', '.');
  79. $data['subalccat']=number_format($fila1->pralcoho/100, 0, ',', '.');
  80. $data['subexcat']=number_format($fila1->prextracto/100, 0, ',', '.');
  81. $data['subpetcat']=number_format($fila1->prpet/100, 0, ',', '.');
  82.  
  83. // Precio Coste (precio medio)
  84. $data['prgascat']=number_format($fila1->prgaso/100, 0, ',', '.');
  85. $data['pragcat']=number_format($fila1->pragua/100, 0, ',', '.');
  86. $data['prmaqgcat']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  87. $data['prmaqecat']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  88. $data['prfercat']=number_format($fila1->prfertil/100, 0, ',', '.');
  89. $data['prpescat']=number_format($fila1->prpestic/100, 0, ',', '.');
  90. $data['prpiecat']=number_format($fila1->prpienso/100, 0, ',', '.');
  91. $data['prfitcat']=number_format($fila1->prfitosa/100, 0, ',', '.');
  92. $data['pralccat']=number_format($fila1->pralcoho/100, 0, ',', '.');
  93. $data['prexcat']=number_format($fila1->prextracto/100, 0, ',', '.');
  94. $data['prpetcat']=number_format($fila1->prpet/100, 0, ',', '.');
  95.  
  96. $this->db->where('pais','chile');
  97. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  98. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  99. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  100. $consulta=$this->db->get_where('cooperativa');
  101. $fila1=$consulta->row();
  102.  
  103. // Stock KG
  104. $data['fonchi']=number_format($fila1->fondocoop/100, 0, '', '.');
  105. $data['gaschi']=number_format($fila1->gaso, 0, ',', '.');
  106. $data['agchi']=number_format($fila1->agua, 0, ',', '.');
  107. $data['maqgchi']=number_format($fila1->maqagri, 0, ',', '.');
  108. $data['maqechi']=number_format($fila1->maqenva, 0, ',', '.');
  109. $data['ferchi']=number_format($fila1->fertil, 0, ',', '.');
  110. $data['peschi']=number_format($fila1->pestic, 0, ',', '.');
  111. $data['piechi']=number_format($fila1->pienso, 0, ',', '.');
  112. $data['fitchi']=number_format($fila1->fitosa, 0, ',', '.');
  113. $data['alcchi']=number_format($fila1->alcoho, 0, ',', '.');
  114. $data['exchi']=number_format($fila1->extracto, 0, ',', '.');
  115. $data['petchi']=number_format($fila1->pet, 0, ',', '.');
  116.  
  117. // Precio venta (precio subvencionado)
  118. $data['subgaschi']=number_format($fila1->prgaso/100, 0, ',', '.');
  119. $data['subagchi']=number_format($fila1->pragua/100, 0, ',', '.');
  120. $data['submaqgchi']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  121. $data['submaqechi']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  122. $data['subferchi']=number_format($fila1->prfertil/100, 0, ',', '.');
  123. $data['subpeschi']=number_format($fila1->prpestic/100, 0, ',', '.');
  124. $data['subpiechi']=number_format($fila1->prpienso/100, 0, ',', '.');
  125. $data['subfitchi']=number_format($fila1->prfitosa/100, 0, ',', '.');
  126. $data['subalcchi']=number_format($fila1->pralcoho/100, 0, ',', '.');
  127. $data['subexchi']=number_format($fila1->prextracto/100, 0, ',', '.');
  128. $data['subpetchi']=number_format($fila1->prpet/100, 0, ',', '.');
  129.  
  130. // Precio Coste (precio medio)
  131. $data['prgaschi']=number_format($fila1->prgaso/100, 0, ',', '.');
  132. $data['pragchi']=number_format($fila1->pragua/100, 0, ',', '.');
  133. $data['prmaqgchi']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  134. $data['prmaqechi']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  135. $data['prferchi']=number_format($fila1->prfertil/100, 0, ',', '.');
  136. $data['prpeschi']=number_format($fila1->prpestic/100, 0, ',', '.');
  137. $data['prpiechi']=number_format($fila1->prpienso/100, 0, ',', '.');
  138. $data['prfitchi']=number_format($fila1->prfitosa/100, 0, ',', '.');
  139. $data['pralcchi']=number_format($fila1->pralcoho/100, 0, ',', '.');
  140. $data['prexchi']=number_format($fila1->prextracto/100, 0, ',', '.');
  141. $data['prpetchi']=number_format($fila1->prpet/100, 0, ',', '.');
  142.  
  143. $this->db->where('pais','china');
  144. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  145. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  146. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  147. $consulta=$this->db->get_where('cooperativa');
  148. $fila1=$consulta->row();
  149.  
  150. // Stock KG
  151. $data['fonchi']=number_format($fila1->fondocoop/100, 0, '', '.');
  152. $data['gaschi']=number_format($fila1->gaso, 0, ',', '.');
  153. $data['agchi']=number_format($fila1->agua, 0, ',', '.');
  154. $data['maqgchi']=number_format($fila1->maqagri, 0, ',', '.');
  155. $data['maqechi']=number_format($fila1->maqenva, 0, ',', '.');
  156. $data['ferchi']=number_format($fila1->fertil, 0, ',', '.');
  157. $data['peschi']=number_format($fila1->pestic, 0, ',', '.');
  158. $data['piechi']=number_format($fila1->pienso, 0, ',', '.');
  159. $data['fitchi']=number_format($fila1->fitosa, 0, ',', '.');
  160. $data['alcchi']=number_format($fila1->alcoho, 0, ',', '.');
  161. $data['exchi']=number_format($fila1->extracto, 0, ',', '.');
  162. $data['petchi']=number_format($fila1->pet, 0, ',', '.');
  163.  
  164. // Precio venta (precio subvencionado)
  165. $data['subgaschi']=number_format($fila1->prgaso/100, 0, ',', '.');
  166. $data['subagchi']=number_format($fila1->pragua/100, 0, ',', '.');
  167. $data['submaqgchi']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  168. $data['submaqechi']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  169. $data['subferchi']=number_format($fila1->prfertil/100, 0, ',', '.');
  170. $data['subpeschi']=number_format($fila1->prpestic/100, 0, ',', '.');
  171. $data['subpiechi']=number_format($fila1->prpienso/100, 0, ',', '.');
  172. $data['subfitchi']=number_format($fila1->prfitosa/100, 0, ',', '.');
  173. $data['subalcchi']=number_format($fila1->pralcoho/100, 0, ',', '.');
  174. $data['subexchi']=number_format($fila1->prextracto/100, 0, ',', '.');
  175. $data['subpetchi']=number_format($fila1->prpet/100, 0, ',', '.');
  176.  
  177. // Precio Coste (precio medio)
  178. $data['prgaschi']=number_format($fila1->prgaso/100, 0, ',', '.');
  179. $data['pragchi']=number_format($fila1->pragua/100, 0, ',', '.');
  180. $data['prmaqgchi']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  181. $data['prmaqechi']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  182. $data['prferchi']=number_format($fila1->prfertil/100, 0, ',', '.');
  183. $data['prpeschi']=number_format($fila1->prpestic/100, 0, ',', '.');
  184. $data['prpiechi']=number_format($fila1->prpienso/100, 0, ',', '.');
  185. $data['prfitchi']=number_format($fila1->prfitosa/100, 0, ',', '.');
  186. $data['pralcchi']=number_format($fila1->pralcoho/100, 0, ',', '.');
  187. $data['prexchi']=number_format($fila1->prextracto/100, 0, ',', '.');
  188. $data['prpetchi']=number_format($fila1->prpet/100, 0, ',', '.');
  189.  
  190. $this->db->where('pais','colombia');
  191. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  192. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  193. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  194. $consulta=$this->db->get_where('cooperativa');
  195. $fila1=$consulta->row();
  196.  
  197. // Stock KG
  198. $data['foncol']=number_format($fila1->fondocoop/100, 0, '', '.');
  199. $data['gascol']=number_format($fila1->gaso, 0, ',', '.');
  200. $data['agcol']=number_format($fila1->agua, 0, ',', '.');
  201. $data['maqgcol']=number_format($fila1->maqagri, 0, ',', '.');
  202. $data['maqecol']=number_format($fila1->maqenva, 0, ',', '.');
  203. $data['fercol']=number_format($fila1->fertil, 0, ',', '.');
  204. $data['pescol']=number_format($fila1->pestic, 0, ',', '.');
  205. $data['piecol']=number_format($fila1->pienso, 0, ',', '.');
  206. $data['fitcol']=number_format($fila1->fitosa, 0, ',', '.');
  207. $data['alccol']=number_format($fila1->alcoho, 0, ',', '.');
  208. $data['excol']=number_format($fila1->extracto, 0, ',', '.');
  209. $data['petcol']=number_format($fila1->pet, 0, ',', '.');
  210.  
  211. // Precio venta (precio subvencionado)
  212. $data['subgascol']=number_format($fila1->prgaso/100, 0, ',', '.');
  213. $data['subagcol']=number_format($fila1->pragua/100, 0, ',', '.');
  214. $data['submaqgcol']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  215. $data['submaqecol']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  216. $data['subfercol']=number_format($fila1->prfertil/100, 0, ',', '.');
  217. $data['subpescol']=number_format($fila1->prpestic/100, 0, ',', '.');
  218. $data['subpiecol']=number_format($fila1->prpienso/100, 0, ',', '.');
  219. $data['subfitcol']=number_format($fila1->prfitosa/100, 0, ',', '.');
  220. $data['subalccol']=number_format($fila1->pralcoho/100, 0, ',', '.');
  221. $data['subexcol']=number_format($fila1->prextracto/100, 0, ',', '.');
  222. $data['subpetcol']=number_format($fila1->prpet/100, 0, ',', '.');
  223.  
  224. // Precio Coste (precio medio)
  225. $data['prgascol']=number_format($fila1->prgaso/100, 0, ',', '.');
  226. $data['pragcol']=number_format($fila1->pragua/100, 0, ',', '.');
  227. $data['prmaqgcol']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  228. $data['prmaqecol']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  229. $data['prfercol']=number_format($fila1->prfertil/100, 0, ',', '.');
  230. $data['prpescol']=number_format($fila1->prpestic/100, 0, ',', '.');
  231. $data['prpiecol']=number_format($fila1->prpienso/100, 0, ',', '.');
  232. $data['prfitcol']=number_format($fila1->prfitosa/100, 0, ',', '.');
  233. $data['pralccol']=number_format($fila1->pralcoho/100, 0, ',', '.');
  234. $data['prexcol']=number_format($fila1->prextracto/100, 0, ',', '.');
  235. $data['prpetcol']=number_format($fila1->prpet/100, 0, ',', '.');
  236.  
  237. $this->db->where('pais','dominicana');
  238. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  239. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  240. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  241. $consulta=$this->db->get_where('cooperativa');
  242. $fila1=$consulta->row();
  243.  
  244. // Stock KG
  245. $data['fondom']=number_format($fila1->fondocoop/100, 0, '', '.');
  246. $data['gasdom']=number_format($fila1->gaso, 0, ',', '.');
  247. $data['agdom']=number_format($fila1->agua, 0, ',', '.');
  248. $data['maqgdom']=number_format($fila1->maqagri, 0, ',', '.');
  249. $data['maqedom']=number_format($fila1->maqenva, 0, ',', '.');
  250. $data['ferdom']=number_format($fila1->fertil, 0, ',', '.');
  251. $data['pesdom']=number_format($fila1->pestic, 0, ',', '.');
  252. $data['piedom']=number_format($fila1->pienso, 0, ',', '.');
  253. $data['fitdom']=number_format($fila1->fitosa, 0, ',', '.');
  254. $data['alcdom']=number_format($fila1->alcoho, 0, ',', '.');
  255. $data['exdom']=number_format($fila1->extracto, 0, ',', '.');
  256. $data['petdom']=number_format($fila1->pet, 0, ',', '.');
  257.  
  258. // Precio venta (precio subvencionado)
  259. $data['subgasdom']=number_format($fila1->prgaso/100, 0, ',', '.');
  260. $data['subagdom']=number_format($fila1->pragua/100, 0, ',', '.');
  261. $data['submaqgdom']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  262. $data['submaqedom']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  263. $data['subferdom']=number_format($fila1->prfertil/100, 0, ',', '.');
  264. $data['subpesdom']=number_format($fila1->prpestic/100, 0, ',', '.');
  265. $data['subpiedom']=number_format($fila1->prpienso/100, 0, ',', '.');
  266. $data['subfitdom']=number_format($fila1->prfitosa/100, 0, ',', '.');
  267. $data['subalcdom']=number_format($fila1->pralcoho/100, 0, ',', '.');
  268. $data['subexdom']=number_format($fila1->prextracto/100, 0, ',', '.');
  269. $data['subpetdom']=number_format($fila1->prpet/100, 0, ',', '.');
  270.  
  271. // Precio Coste (precio medio)
  272. $data['prgasdom']=number_format($fila1->prgaso/100, 0, ',', '.');
  273. $data['pragdom']=number_format($fila1->pragua/100, 0, ',', '.');
  274. $data['prmaqgdom']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  275. $data['prmaqedom']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  276. $data['prferdom']=number_format($fila1->prfertil/100, 0, ',', '.');
  277. $data['prpesdom']=number_format($fila1->prpestic/100, 0, ',', '.');
  278. $data['prpiedom']=number_format($fila1->prpienso/100, 0, ',', '.');
  279. $data['prfitdom']=number_format($fila1->prfitosa/100, 0, ',', '.');
  280. $data['pralcdom']=number_format($fila1->pralcoho/100, 0, ',', '.');
  281. $data['prexdom']=number_format($fila1->prextracto/100, 0, ',', '.');
  282. $data['prpetdom']=number_format($fila1->prpet/100, 0, ',', '.');
  283.  
  284. $this->db->where('pais','ecuador');
  285. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  286. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  287. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  288. $consulta=$this->db->get_where('cooperativa');
  289. $fila1=$consulta->row();
  290.  
  291. // Stock KG
  292. $data['fonecu']=number_format($fila1->fondocoop/100, 0, '', '.');
  293. $data['gasecu']=number_format($fila1->gaso, 0, ',', '.');
  294. $data['agecu']=number_format($fila1->agua, 0, ',', '.');
  295. $data['maqgecu']=number_format($fila1->maqagri, 0, ',', '.');
  296. $data['maqeecu']=number_format($fila1->maqenva, 0, ',', '.');
  297. $data['ferecu']=number_format($fila1->fertil, 0, ',', '.');
  298. $data['pesecu']=number_format($fila1->pestic, 0, ',', '.');
  299. $data['pieecu']=number_format($fila1->pienso, 0, ',', '.');
  300. $data['fitecu']=number_format($fila1->fitosa, 0, ',', '.');
  301. $data['alcecu']=number_format($fila1->alcoho, 0, ',', '.');
  302. $data['execu']=number_format($fila1->extracto, 0, ',', '.');
  303. $data['petecu']=number_format($fila1->pet, 0, ',', '.');
  304.  
  305. // Precio venta (precio subvencionado)
  306. $data['subgasecu']=number_format($fila1->prgaso/100, 0, ',', '.');
  307. $data['subagecu']=number_format($fila1->pragua/100, 0, ',', '.');
  308. $data['submaqgecu']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  309. $data['submaqeecu']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  310. $data['subferecu']=number_format($fila1->prfertil/100, 0, ',', '.');
  311. $data['subpesecu']=number_format($fila1->prpestic/100, 0, ',', '.');
  312. $data['subpieecu']=number_format($fila1->prpienso/100, 0, ',', '.');
  313. $data['subfitecu']=number_format($fila1->prfitosa/100, 0, ',', '.');
  314. $data['subalcecu']=number_format($fila1->pralcoho/100, 0, ',', '.');
  315. $data['subexecu']=number_format($fila1->prextracto/100, 0, ',', '.');
  316. $data['subpetecu']=number_format($fila1->prpet/100, 0, ',', '.');
  317.  
  318. // Precio Coste (precio medio)
  319. $data['prgasecu']=number_format($fila1->prgaso/100, 0, ',', '.');
  320. $data['pragecu']=number_format($fila1->pragua/100, 0, ',', '.');
  321. $data['prmaqgecu']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  322. $data['prmaqeecu']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  323. $data['prferecu']=number_format($fila1->prfertil/100, 0, ',', '.');
  324. $data['prpesecu']=number_format($fila1->prpestic/100, 0, ',', '.');
  325. $data['prpieecu']=number_format($fila1->prpienso/100, 0, ',', '.');
  326. $data['prfitecu']=number_format($fila1->prfitosa/100, 0, ',', '.');
  327. $data['pralcecu']=number_format($fila1->pralcoho/100, 0, ',', '.');
  328. $data['prexecu']=number_format($fila1->prextracto/100, 0, ',', '.');
  329. $data['prpetecu']=number_format($fila1->prpet/100, 0, ',', '.');
  330.  
  331. $this->db->where('pais','españa');
  332. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  333. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  334. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  335. $consulta=$this->db->get_where('cooperativa');
  336. $fila1=$consulta->row();
  337.  
  338. // Stock KG
  339. $data['fonesp']=number_format($fila1->fondocoop/100, 0, '', '.');
  340. $data['gasesp']=number_format($fila1->gaso, 0, ',', '.');
  341. $data['agesp']=number_format($fila1->agua, 0, ',', '.');
  342. $data['maqgesp']=number_format($fila1->maqagri, 0, ',', '.');
  343. $data['maqeesp']=number_format($fila1->maqenva, 0, ',', '.');
  344. $data['feresp']=number_format($fila1->fertil, 0, ',', '.');
  345. $data['pesesp']=number_format($fila1->pestic, 0, ',', '.');
  346. $data['pieesp']=number_format($fila1->pienso, 0, ',', '.');
  347. $data['fitesp']=number_format($fila1->fitosa, 0, ',', '.');
  348. $data['alcesp']=number_format($fila1->alcoho, 0, ',', '.');
  349. $data['exesp']=number_format($fila1->extracto, 0, ',', '.');
  350. $data['petesp']=number_format($fila1->pet, 0, ',', '.');
  351.  
  352. // Precio venta (precio subvencionado)
  353. $data['subgasesp']=number_format($fila1->prgaso/100, 0, ',', '.');
  354. $data['subagesp']=number_format($fila1->pragua/100, 0, ',', '.');
  355. $data['submaqgesp']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  356. $data['submaqeesp']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  357. $data['subferesp']=number_format($fila1->prfertil/100, 0, ',', '.');
  358. $data['subpesesp']=number_format($fila1->prpestic/100, 0, ',', '.');
  359. $data['subpieesp']=number_format($fila1->prpienso/100, 0, ',', '.');
  360. $data['subfitesp']=number_format($fila1->prfitosa/100, 0, ',', '.');
  361. $data['subalcesp']=number_format($fila1->pralcoho/100, 0, ',', '.');
  362. $data['subexesp']=number_format($fila1->prextracto/100, 0, ',', '.');
  363. $data['subpetesp']=number_format($fila1->prpet/100, 0, ',', '.');
  364.  
  365. // Precio Coste (precio medio)
  366. $data['prgasesp']=number_format($fila1->prgaso/100, 0, ',', '.');
  367. $data['pragesp']=number_format($fila1->pragua/100, 0, ',', '.');
  368. $data['prmaqgesp']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  369. $data['prmaqeesp']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  370. $data['prferesp']=number_format($fila1->prfertil/100, 0, ',', '.');
  371. $data['prpesesp']=number_format($fila1->prpestic/100, 0, ',', '.');
  372. $data['prpieesp']=number_format($fila1->prpienso/100, 0, ',', '.');
  373. $data['prfitesp']=number_format($fila1->prfitosa/100, 0, ',', '.');
  374. $data['pralcesp']=number_format($fila1->pralcoho/100, 0, ',', '.');
  375. $data['prexesp']=number_format($fila1->prextracto/100, 0, ',', '.');
  376. $data['prpetesp']=number_format($fila1->prpet/100, 0, ',', '.');
  377.  
  378. $this->db->where('pais','estadosunidos');
  379. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  380. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  381. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  382. $consulta=$this->db->get_where('cooperativa');
  383. $fila1=$consulta->row();
  384.  
  385. // Stock KG
  386. $data['fonest']=number_format($fila1->fondocoop/100, 0, '', '.');
  387. $data['gasest']=number_format($fila1->gaso, 0, ',', '.');
  388. $data['agest']=number_format($fila1->agua, 0, ',', '.');
  389. $data['maqgest']=number_format($fila1->maqagri, 0, ',', '.');
  390. $data['maqeest']=number_format($fila1->maqenva, 0, ',', '.');
  391. $data['ferest']=number_format($fila1->fertil, 0, ',', '.');
  392. $data['pesest']=number_format($fila1->pestic, 0, ',', '.');
  393. $data['pieest']=number_format($fila1->pienso, 0, ',', '.');
  394. $data['fitest']=number_format($fila1->fitosa, 0, ',', '.');
  395. $data['alcest']=number_format($fila1->alcoho, 0, ',', '.');
  396. $data['exest']=number_format($fila1->extracto, 0, ',', '.');
  397. $data['petest']=number_format($fila1->pet, 0, ',', '.');
  398.  
  399. // Precio venta (precio subvencionado)
  400. $data['subgasest']=number_format($fila1->prgaso/100, 0, ',', '.');
  401. $data['subagest']=number_format($fila1->pragua/100, 0, ',', '.');
  402. $data['submaqgest']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  403. $data['submaqeest']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  404. $data['subferest']=number_format($fila1->prfertil/100, 0, ',', '.');
  405. $data['subpesest']=number_format($fila1->prpestic/100, 0, ',', '.');
  406. $data['subpieest']=number_format($fila1->prpienso/100, 0, ',', '.');
  407. $data['subfitest']=number_format($fila1->prfitosa/100, 0, ',', '.');
  408. $data['subalcest']=number_format($fila1->pralcoho/100, 0, ',', '.');
  409. $data['subexest']=number_format($fila1->prextracto/100, 0, ',', '.');
  410. $data['subpetest']=number_format($fila1->prpet/100, 0, ',', '.');
  411.  
  412. // Precio Coste (precio medio)
  413. $data['prgasest']=number_format($fila1->prgaso/100, 0, ',', '.');
  414. $data['pragest']=number_format($fila1->pragua/100, 0, ',', '.');
  415. $data['prmaqgest']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  416. $data['prmaqeest']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  417. $data['prferest']=number_format($fila1->prfertil/100, 0, ',', '.');
  418. $data['prpesest']=number_format($fila1->prpestic/100, 0, ',', '.');
  419. $data['prpieest']=number_format($fila1->prpienso/100, 0, ',', '.');
  420. $data['prfitest']=number_format($fila1->prfitosa/100, 0, ',', '.');
  421. $data['pralcest']=number_format($fila1->pralcoho/100, 0, ',', '.');
  422. $data['prexest']=number_format($fila1->prextracto/100, 0, ',', '.');
  423. $data['prpetest']=number_format($fila1->prpet/100, 0, ',', '.');
  424.  
  425. $this->db->where('pais','euskadi');
  426. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  427. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  428. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  429. $consulta=$this->db->get_where('cooperativa');
  430. $fila1=$consulta->row();
  431.  
  432. // Stock KG
  433. $data['foneus']=number_format($fila1->fondocoop/100, 0, '', '.');
  434. $data['gaseus']=number_format($fila1->gaso, 0, ',', '.');
  435. $data['ageus']=number_format($fila1->agua, 0, ',', '.');
  436. $data['maqgeus']=number_format($fila1->maqagri, 0, ',', '.');
  437. $data['maqeeus']=number_format($fila1->maqenva, 0, ',', '.');
  438. $data['fereus']=number_format($fila1->fertil, 0, ',', '.');
  439. $data['peseus']=number_format($fila1->pestic, 0, ',', '.');
  440. $data['pieeus']=number_format($fila1->pienso, 0, ',', '.');
  441. $data['fiteus']=number_format($fila1->fitosa, 0, ',', '.');
  442. $data['alceus']=number_format($fila1->alcoho, 0, ',', '.');
  443. $data['exeus']=number_format($fila1->extracto, 0, ',', '.');
  444. $data['peteus']=number_format($fila1->pet, 0, ',', '.');
  445.  
  446. // Precio venta (precio subvencionado)
  447. $data['subgaseus']=number_format($fila1->prgaso/100, 0, ',', '.');
  448. $data['subageus']=number_format($fila1->pragua/100, 0, ',', '.');
  449. $data['submaqgeus']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  450. $data['submaqeeus']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  451. $data['subfereus']=number_format($fila1->prfertil/100, 0, ',', '.');
  452. $data['subpeseus']=number_format($fila1->prpestic/100, 0, ',', '.');
  453. $data['subpieeus']=number_format($fila1->prpienso/100, 0, ',', '.');
  454. $data['subfiteus']=number_format($fila1->prfitosa/100, 0, ',', '.');
  455. $data['subalceus']=number_format($fila1->pralcoho/100, 0, ',', '.');
  456. $data['subexeus']=number_format($fila1->prextracto/100, 0, ',', '.');
  457. $data['subpeteus']=number_format($fila1->prpet/100, 0, ',', '.');
  458.  
  459. // Precio Coste (precio medio)
  460. $data['prgaseus']=number_format($fila1->prgaso/100, 0, ',', '.');
  461. $data['prageus']=number_format($fila1->pragua/100, 0, ',', '.');
  462. $data['prmaqgeus']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  463. $data['prmaqeeus']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  464. $data['prfereus']=number_format($fila1->prfertil/100, 0, ',', '.');
  465. $data['prpeseus']=number_format($fila1->prpestic/100, 0, ',', '.');
  466. $data['prpieeus']=number_format($fila1->prpienso/100, 0, ',', '.');
  467. $data['prfiteus']=number_format($fila1->prfitosa/100, 0, ',', '.');
  468. $data['pralceus']=number_format($fila1->pralcoho/100, 0, ',', '.');
  469. $data['prexeus']=number_format($fila1->prextracto/100, 0, ',', '.');
  470. $data['prpeteus']=number_format($fila1->prpet/100, 0, ',', '.');
  471.  
  472. $this->db->where('pais','galicia');
  473. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  474. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  475. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  476. $consulta=$this->db->get_where('cooperativa');
  477. $fila1=$consulta->row();
  478.  
  479. // Stock KG
  480. $data['fongal']=number_format($fila1->fondocoop/100, 0, '', '.');
  481. $data['gasgal']=number_format($fila1->gaso, 0, ',', '.');
  482. $data['aggal']=number_format($fila1->agua, 0, ',', '.');
  483. $data['maqggal']=number_format($fila1->maqagri, 0, ',', '.');
  484. $data['maqegal']=number_format($fila1->maqenva, 0, ',', '.');
  485. $data['fergal']=number_format($fila1->fertil, 0, ',', '.');
  486. $data['pesgal']=number_format($fila1->pestic, 0, ',', '.');
  487. $data['piegal']=number_format($fila1->pienso, 0, ',', '.');
  488. $data['fitgal']=number_format($fila1->fitosa, 0, ',', '.');
  489. $data['alcgal']=number_format($fila1->alcoho, 0, ',', '.');
  490. $data['exgal']=number_format($fila1->extracto, 0, ',', '.');
  491. $data['petgal']=number_format($fila1->pet, 0, ',', '.');
  492.  
  493. // Precio venta (precio subvencionado)
  494. $data['subgasgal']=number_format($fila1->prgaso/100, 0, ',', '.');
  495. $data['subaggal']=number_format($fila1->pragua/100, 0, ',', '.');
  496. $data['submaqggal']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  497. $data['submaqegal']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  498. $data['subfergal']=number_format($fila1->prfertil/100, 0, ',', '.');
  499. $data['subpesgal']=number_format($fila1->prpestic/100, 0, ',', '.');
  500. $data['subpiegal']=number_format($fila1->prpienso/100, 0, ',', '.');
  501. $data['subfitgal']=number_format($fila1->prfitosa/100, 0, ',', '.');
  502. $data['subalcgal']=number_format($fila1->pralcoho/100, 0, ',', '.');
  503. $data['subexgal']=number_format($fila1->prextracto/100, 0, ',', '.');
  504. $data['subpetgal']=number_format($fila1->prpet/100, 0, ',', '.');
  505.  
  506. // Precio Coste (precio medio)
  507. $data['prgasgal']=number_format($fila1->prgaso/100, 0, ',', '.');
  508. $data['praggal']=number_format($fila1->pragua/100, 0, ',', '.');
  509. $data['prmaqggal']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  510. $data['prmaqegal']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  511. $data['prfergal']=number_format($fila1->prfertil/100, 0, ',', '.');
  512. $data['prpesgal']=number_format($fila1->prpestic/100, 0, ',', '.');
  513. $data['prpiegal']=number_format($fila1->prpienso/100, 0, ',', '.');
  514. $data['prfitgal']=number_format($fila1->prfitosa/100, 0, ',', '.');
  515. $data['pralcgal']=number_format($fila1->pralcoho/100, 0, ',', '.');
  516. $data['prexgal']=number_format($fila1->prextracto/100, 0, ',', '.');
  517. $data['prpetgal']=number_format($fila1->prpet/100, 0, ',', '.');
  518.  
  519. $this->db->where('pais','guinea');
  520. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  521. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  522. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  523. $consulta=$this->db->get_where('cooperativa');
  524. $fila1=$consulta->row();
  525.  
  526. // Stock KG
  527. $data['fongui']=number_format($fila1->fondocoop/100, 0, '', '.');
  528. $data['gasgui']=number_format($fila1->gaso, 0, ',', '.');
  529. $data['aggui']=number_format($fila1->agua, 0, ',', '.');
  530. $data['maqggui']=number_format($fila1->maqagri, 0, ',', '.');
  531. $data['maqegui']=number_format($fila1->maqenva, 0, ',', '.');
  532. $data['fergui']=number_format($fila1->fertil, 0, ',', '.');
  533. $data['pesgui']=number_format($fila1->pestic, 0, ',', '.');
  534. $data['piegui']=number_format($fila1->pienso, 0, ',', '.');
  535. $data['fitgui']=number_format($fila1->fitosa, 0, ',', '.');
  536. $data['alcgui']=number_format($fila1->alcoho, 0, ',', '.');
  537. $data['exgui']=number_format($fila1->extracto, 0, ',', '.');
  538. $data['petgui']=number_format($fila1->pet, 0, ',', '.');
  539.  
  540. // Precio venta (precio subvencionado)
  541. $data['subgasgui']=number_format($fila1->prgaso/100, 0, ',', '.');
  542. $data['subaggui']=number_format($fila1->pragua/100, 0, ',', '.');
  543. $data['submaqggui']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  544. $data['submaqegui']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  545. $data['subfergui']=number_format($fila1->prfertil/100, 0, ',', '.');
  546. $data['subpesgui']=number_format($fila1->prpestic/100, 0, ',', '.');
  547. $data['subpiegui']=number_format($fila1->prpienso/100, 0, ',', '.');
  548. $data['subfitgui']=number_format($fila1->prfitosa/100, 0, ',', '.');
  549. $data['subalcgui']=number_format($fila1->pralcoho/100, 0, ',', '.');
  550. $data['subexgui']=number_format($fila1->prextracto/100, 0, ',', '.');
  551. $data['subpetgui']=number_format($fila1->prpet/100, 0, ',', '.');
  552.  
  553. // Precio Coste (precio medio)
  554. $data['prgasgui']=number_format($fila1->prgaso/100, 0, ',', '.');
  555. $data['praggui']=number_format($fila1->pragua/100, 0, ',', '.');
  556. $data['prmaqggui']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  557. $data['prmaqegui']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  558. $data['prfergui']=number_format($fila1->prfertil/100, 0, ',', '.');
  559. $data['prpesgui']=number_format($fila1->prpestic/100, 0, ',', '.');
  560. $data['prpiegui']=number_format($fila1->prpienso/100, 0, ',', '.');
  561. $data['prfitgui']=number_format($fila1->prfitosa/100, 0, ',', '.');
  562. $data['pralcgui']=number_format($fila1->pralcoho/100, 0, ',', '.');
  563. $data['prexgui']=number_format($fila1->prextracto/100, 0, ',', '.');
  564. $data['prpetgui']=number_format($fila1->prpet/100, 0, ',', '.');
  565.  
  566. $this->db->where('pais','islas');
  567. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  568. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  569. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  570. $consulta=$this->db->get_where('cooperativa');
  571. $fila1=$consulta->row();
  572.  
  573. // Stock KG
  574. $data['fonisl']=number_format($fila1->fondocoop/100, 0, '', '.');
  575. $data['gasisl']=number_format($fila1->gaso, 0, ',', '.');
  576. $data['agisl']=number_format($fila1->agua, 0, ',', '.');
  577. $data['maqgisl']=number_format($fila1->maqagri, 0, ',', '.');
  578. $data['maqeisl']=number_format($fila1->maqenva, 0, ',', '.');
  579. $data['ferisl']=number_format($fila1->fertil, 0, ',', '.');
  580. $data['pesisl']=number_format($fila1->pestic, 0, ',', '.');
  581. $data['pieisl']=number_format($fila1->pienso, 0, ',', '.');
  582. $data['fitisl']=number_format($fila1->fitosa, 0, ',', '.');
  583. $data['alcisl']=number_format($fila1->alcoho, 0, ',', '.');
  584. $data['exisl']=number_format($fila1->extracto, 0, ',', '.');
  585. $data['petisl']=number_format($fila1->pet, 0, ',', '.');
  586.  
  587. // Precio venta (precio subvencionado)
  588. $data['subgasisl']=number_format($fila1->prgaso/100, 0, ',', '.');
  589. $data['subagisl']=number_format($fila1->pragua/100, 0, ',', '.');
  590. $data['submaqgisl']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  591. $data['submaqeisl']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  592. $data['subferisl']=number_format($fila1->prfertil/100, 0, ',', '.');
  593. $data['subpesisl']=number_format($fila1->prpestic/100, 0, ',', '.');
  594. $data['subpieisl']=number_format($fila1->prpienso/100, 0, ',', '.');
  595. $data['subfitisl']=number_format($fila1->prfitosa/100, 0, ',', '.');
  596. $data['subalcisl']=number_format($fila1->pralcoho/100, 0, ',', '.');
  597. $data['subexisl']=number_format($fila1->prextracto/100, 0, ',', '.');
  598. $data['subpetisl']=number_format($fila1->prpet/100, 0, ',', '.');
  599.  
  600. // Precio Coste (precio medio)
  601. $data['prgasisl']=number_format($fila1->prgaso/100, 0, ',', '.');
  602. $data['pragisl']=number_format($fila1->pragua/100, 0, ',', '.');
  603. $data['prmaqgisl']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  604. $data['prmaqeisl']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  605. $data['prferisl']=number_format($fila1->prfertil/100, 0, ',', '.');
  606. $data['prpesisl']=number_format($fila1->prpestic/100, 0, ',', '.');
  607. $data['prpieisl']=number_format($fila1->prpienso/100, 0, ',', '.');
  608. $data['prfitisl']=number_format($fila1->prfitosa/100, 0, ',', '.');
  609. $data['pralcisl']=number_format($fila1->pralcoho/100, 0, ',', '.');
  610. $data['prexisl']=number_format($fila1->prextracto/100, 0, ',', '.');
  611. $data['prpetisl']=number_format($fila1->prpet/100, 0, ',', '.');
  612.  
  613. $this->db->where('pais','laronia');
  614. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  615. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  616. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  617. $consulta=$this->db->get_where('cooperativa');
  618. $fila1=$consulta->row();
  619.  
  620. // Stock KG
  621. $data['fonlar']=number_format($fila1->fondocoop/100, 0, '', '.');
  622. $data['gaslar']=number_format($fila1->gaso, 0, ',', '.');
  623. $data['aglar']=number_format($fila1->agua, 0, ',', '.');
  624. $data['maqglar']=number_format($fila1->maqagri, 0, ',', '.');
  625. $data['maqelar']=number_format($fila1->maqenva, 0, ',', '.');
  626. $data['ferlar']=number_format($fila1->fertil, 0, ',', '.');
  627. $data['peslar']=number_format($fila1->pestic, 0, ',', '.');
  628. $data['pielar']=number_format($fila1->pienso, 0, ',', '.');
  629. $data['fitlar']=number_format($fila1->fitosa, 0, ',', '.');
  630. $data['alclar']=number_format($fila1->alcoho, 0, ',', '.');
  631. $data['exlar']=number_format($fila1->extracto, 0, ',', '.');
  632. $data['petlar']=number_format($fila1->pet, 0, ',', '.');
  633.  
  634. // Precio venta (precio subvencionado)
  635. $data['subgaslar']=number_format($fila1->prgaso/100, 0, ',', '.');
  636. $data['subaglar']=number_format($fila1->pragua/100, 0, ',', '.');
  637. $data['submaqglar']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  638. $data['submaqelar']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  639. $data['subferlar']=number_format($fila1->prfertil/100, 0, ',', '.');
  640. $data['subpeslar']=number_format($fila1->prpestic/100, 0, ',', '.');
  641. $data['subpielar']=number_format($fila1->prpienso/100, 0, ',', '.');
  642. $data['subfitlar']=number_format($fila1->prfitosa/100, 0, ',', '.');
  643. $data['subalclar']=number_format($fila1->pralcoho/100, 0, ',', '.');
  644. $data['subexlar']=number_format($fila1->prextracto/100, 0, ',', '.');
  645. $data['subpetlar']=number_format($fila1->prpet/100, 0, ',', '.');
  646.  
  647. // Precio Coste (precio medio)
  648. $data['prgaslar']=number_format($fila1->prgaso/100, 0, ',', '.');
  649. $data['praglar']=number_format($fila1->pragua/100, 0, ',', '.');
  650. $data['prmaqglar']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  651. $data['prmaqelar']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  652. $data['prferlar']=number_format($fila1->prfertil/100, 0, ',', '.');
  653. $data['prpeslar']=number_format($fila1->prpestic/100, 0, ',', '.');
  654. $data['prpielar']=number_format($fila1->prpienso/100, 0, ',', '.');
  655. $data['prfitlar']=number_format($fila1->prfitosa/100, 0, ',', '.');
  656. $data['pralclar']=number_format($fila1->pralcoho/100, 0, ',', '.');
  657. $data['prexlar']=number_format($fila1->prextracto/100, 0, ',', '.');
  658. $data['prpetlar']=number_format($fila1->prpet/100, 0, ',', '.');
  659.  
  660. $this->db->where('pais','mexico');
  661. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  662. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  663. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  664. $consulta=$this->db->get_where('cooperativa');
  665. $fila1=$consulta->row();
  666.  
  667. // Stock KG
  668. $data['fonmex']=number_format($fila1->fondocoop/100, 0, '', '.');
  669. $data['gasmex']=number_format($fila1->gaso, 0, ',', '.');
  670. $data['agmex']=number_format($fila1->agua, 0, ',', '.');
  671. $data['maqgmex']=number_format($fila1->maqagri, 0, ',', '.');
  672. $data['maqemex']=number_format($fila1->maqenva, 0, ',', '.');
  673. $data['fermex']=number_format($fila1->fertil, 0, ',', '.');
  674. $data['pesmex']=number_format($fila1->pestic, 0, ',', '.');
  675. $data['piemex']=number_format($fila1->pienso, 0, ',', '.');
  676. $data['fitmex']=number_format($fila1->fitosa, 0, ',', '.');
  677. $data['alcmex']=number_format($fila1->alcoho, 0, ',', '.');
  678. $data['exmex']=number_format($fila1->extracto, 0, ',', '.');
  679. $data['petmex']=number_format($fila1->pet, 0, ',', '.');
  680.  
  681. // Precio venta (precio subvencionado)
  682. $data['subgasmex']=number_format($fila1->prgaso/100, 0, ',', '.');
  683. $data['subagmex']=number_format($fila1->pragua/100, 0, ',', '.');
  684. $data['submaqgmex']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  685. $data['submaqemex']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  686. $data['subfermex']=number_format($fila1->prfertil/100, 0, ',', '.');
  687. $data['subpesmex']=number_format($fila1->prpestic/100, 0, ',', '.');
  688. $data['subpiemex']=number_format($fila1->prpienso/100, 0, ',', '.');
  689. $data['subfitmex']=number_format($fila1->prfitosa/100, 0, ',', '.');
  690. $data['subalcmex']=number_format($fila1->pralcoho/100, 0, ',', '.');
  691. $data['subexmex']=number_format($fila1->prextracto/100, 0, ',', '.');
  692. $data['subpetmex']=number_format($fila1->prpet/100, 0, ',', '.');
  693.  
  694. // Precio Coste (precio medio)
  695. $data['prgasmex']=number_format($fila1->prgaso/100, 0, ',', '.');
  696. $data['pragmex']=number_format($fila1->pragua/100, 0, ',', '.');
  697. $data['prmaqgmex']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  698. $data['prmaqemex']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  699. $data['prfermex']=number_format($fila1->prfertil/100, 0, ',', '.');
  700. $data['prpesmex']=number_format($fila1->prpestic/100, 0, ',', '.');
  701. $data['prpiemex']=number_format($fila1->prpienso/100, 0, ',', '.');
  702. $data['prfitmex']=number_format($fila1->prfitosa/100, 0, ',', '.');
  703. $data['pralcmex']=number_format($fila1->pralcoho/100, 0, ',', '.');
  704. $data['prexmex']=number_format($fila1->prextracto/100, 0, ',', '.');
  705. $data['prpetmex']=number_format($fila1->prpet/100, 0, ',', '.
  706.  
  707. $this->db->where('pais','paisdemierda');
  708. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  709. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  710. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  711. $consulta=$this->db->get_where('cooperativa');
  712. $fila1=$consulta->row();
  713.  
  714. // Stock KG
  715. $data['fonpai']=number_format($fila1->fondocoop/100, 0, '', '.');
  716. $data['gaspai']=number_format($fila1->gaso, 0, ',', '.');
  717. $data['agpai']=number_format($fila1->agua, 0, ',', '.');
  718. $data['maqgpai']=number_format($fila1->maqagri, 0, ',', '.');
  719. $data['maqepai']=number_format($fila1->maqenva, 0, ',', '.');
  720. $data['ferpai']=number_format($fila1->fertil, 0, ',', '.');
  721. $data['pespai']=number_format($fila1->pestic, 0, ',', '.');
  722. $data['piepai']=number_format($fila1->pienso, 0, ',', '.');
  723. $data['fitpai']=number_format($fila1->fitosa, 0, ',', '.');
  724. $data['alcpai']=number_format($fila1->alcoho, 0, ',', '.');
  725. $data['expai']=number_format($fila1->extracto, 0, ',', '.');
  726. $data['petpai']=number_format($fila1->pet, 0, ',', '.');
  727.  
  728. // Precio venta (precio subvencionado)
  729. $data['subgaspai']=number_format($fila1->prgaso/100, 0, ',', '.');
  730. $data['subagpai']=number_format($fila1->pragua/100, 0, ',', '.');
  731. $data['submaqgpai']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  732. $data['submaqepai']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  733. $data['subferpai']=number_format($fila1->prfertil/100, 0, ',', '.');
  734. $data['subpespai']=number_format($fila1->prpestic/100, 0, ',', '.');
  735. $data['subpiepai']=number_format($fila1->prpienso/100, 0, ',', '.');
  736. $data['subfitpai']=number_format($fila1->prfitosa/100, 0, ',', '.');
  737. $data['subalcpai']=number_format($fila1->pralcoho/100, 0, ',', '.');
  738. $data['subexpai']=number_format($fila1->prextracto/100, 0, ',', '.');
  739. $data['subpetpai']=number_format($fila1->prpet/100, 0, ',', '.');
  740.  
  741. // Precio Coste (precio medio)
  742. $data['prgaspai']=number_format($fila1->prgaso/100, 0, ',', '.');
  743. $data['pragpai']=number_format($fila1->pragua/100, 0, ',', '.');
  744. $data['prmaqgpai']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  745. $data['prmaqepai']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  746. $data['prferpai']=number_format($fila1->prfertil/100, 0, ',', '.');
  747. $data['prpespai']=number_format($fila1->prpestic/100, 0, ',', '.');
  748. $data['prpiepai']=number_format($fila1->prpienso/100, 0, ',', '.');
  749. $data['prfitpai']=number_format($fila1->prfitosa/100, 0, ',', '.');
  750. $data['pralcpai']=number_format($fila1->pralcoho/100, 0, ',', '.');
  751. $data['prexpai']=number_format($fila1->prextracto/100, 0, ',', '.');
  752. $data['prpetpai']=number_format($fila1->prpet/100, 0, ',', '.');
  753.  
  754. $this->db->where('pais','peru');
  755. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  756. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  757. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  758. $consulta=$this->db->get_where('cooperativa');
  759. $fila1=$consulta->row();
  760.  
  761. // Stock KG
  762. $data['fonper']=number_format($fila1->fondocoop/100, 0, '', '.');
  763. $data['gasper']=number_format($fila1->gaso, 0, ',', '.');
  764. $data['agper']=number_format($fila1->agua, 0, ',', '.');
  765. $data['maqgper']=number_format($fila1->maqagri, 0, ',', '.');
  766. $data['maqeper']=number_format($fila1->maqenva, 0, ',', '.');
  767. $data['ferper']=number_format($fila1->fertil, 0, ',', '.');
  768. $data['pesper']=number_format($fila1->pestic, 0, ',', '.');
  769. $data['pieper']=number_format($fila1->pienso, 0, ',', '.');
  770. $data['fitper']=number_format($fila1->fitosa, 0, ',', '.');
  771. $data['alcper']=number_format($fila1->alcoho, 0, ',', '.');
  772. $data['exper']=number_format($fila1->extracto, 0, ',', '.');
  773. $data['petper']=number_format($fila1->pet, 0, ',', '.');
  774.  
  775. // Precio venta (precio subvencionado)
  776. $data['subgasper']=number_format($fila1->prgaso/100, 0, ',', '.');
  777. $data['subagper']=number_format($fila1->pragua/100, 0, ',', '.');
  778. $data['submaqgper']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  779. $data['submaqeper']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  780. $data['subferper']=number_format($fila1->prfertil/100, 0, ',', '.');
  781. $data['subpesper']=number_format($fila1->prpestic/100, 0, ',', '.');
  782. $data['subpieper']=number_format($fila1->prpienso/100, 0, ',', '.');
  783. $data['subfitper']=number_format($fila1->prfitosa/100, 0, ',', '.');
  784. $data['subalcper']=number_format($fila1->pralcoho/100, 0, ',', '.');
  785. $data['subexper']=number_format($fila1->prextracto/100, 0, ',', '.');
  786. $data['subpetper']=number_format($fila1->prpet/100, 0, ',', '.');
  787.  
  788. // Precio Coste (precio medio)
  789. $data['prgasper']=number_format($fila1->prgaso/100, 0, ',', '.');
  790. $data['pragper']=number_format($fila1->pragua/100, 0, ',', '.');
  791. $data['prmaqgper']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  792. $data['prmaqeper']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  793. $data['prferper']=number_format($fila1->prfertil/100, 0, ',', '.');
  794. $data['prpesper']=number_format($fila1->prpestic/100, 0, ',', '.');
  795. $data['prpieper']=number_format($fila1->prpienso/100, 0, ',', '.');
  796. $data['prfitper']=number_format($fila1->prfitosa/100, 0, ',', '.');
  797. $data['pralcper']=number_format($fila1->pralcoho/100, 0, ',', '.');
  798. $data['prexper']=number_format($fila1->prextracto/100, 0, ',', '.');
  799. $data['prpetper']=number_format($fila1->prpet/100, 0, ',', '.');
  800.  
  801. $this->db->where('pais','rusia');
  802. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  803. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  804. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  805. $consulta=$this->db->get_where('cooperativa');
  806. $fila1=$consulta->row();
  807.  
  808. // Stock KG
  809. $data['fonrus']=number_format($fila1->fondocoop/100, 0, '', '.');
  810. $data['gasrus']=number_format($fila1->gaso, 0, ',', '.');
  811. $data['agrus']=number_format($fila1->agua, 0, ',', '.');
  812. $data['maqgrus']=number_format($fila1->maqagri, 0, ',', '.');
  813. $data['maqerus']=number_format($fila1->maqenva, 0, ',', '.');
  814. $data['ferrus']=number_format($fila1->fertil, 0, ',', '.');
  815. $data['pesrus']=number_format($fila1->pestic, 0, ',', '.');
  816. $data['pierus']=number_format($fila1->pienso, 0, ',', '.');
  817. $data['fitrus']=number_format($fila1->fitosa, 0, ',', '.');
  818. $data['alcrus']=number_format($fila1->alcoho, 0, ',', '.');
  819. $data['exrus']=number_format($fila1->extracto, 0, ',', '.');
  820. $data['petrus']=number_format($fila1->pet, 0, ',', '.');
  821.  
  822. // Precio venta (precio subvencionado)
  823. $data['subgasrus']=number_format($fila1->prgaso/100, 0, ',', '.');
  824. $data['subagrus']=number_format($fila1->pragua/100, 0, ',', '.');
  825. $data['submaqgrus']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  826. $data['submaqerus']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  827. $data['subferrus']=number_format($fila1->prfertil/100, 0, ',', '.');
  828. $data['subpesrus']=number_format($fila1->prpestic/100, 0, ',', '.');
  829. $data['subpierus']=number_format($fila1->prpienso/100, 0, ',', '.');
  830. $data['subfitrus']=number_format($fila1->prfitosa/100, 0, ',', '.');
  831. $data['subalcrus']=number_format($fila1->pralcoho/100, 0, ',', '.');
  832. $data['subexrus']=number_format($fila1->prextracto/100, 0, ',', '.');
  833. $data['subpetrus']=number_format($fila1->prpet/100, 0, ',', '.');
  834.  
  835. // Precio Coste (precio medio)
  836. $data['prgasrus']=number_format($fila1->prgaso/100, 0, ',', '.');
  837. $data['pragrus']=number_format($fila1->pragua/100, 0, ',', '.');
  838. $data['prmaqgrus']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  839. $data['prmaqerus']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  840. $data['prferrus']=number_format($fila1->prfertil/100, 0, ',', '.');
  841. $data['prpesrus']=number_format($fila1->prpestic/100, 0, ',', '.');
  842. $data['prpierus']=number_format($fila1->prpienso/100, 0, ',', '.');
  843. $data['prfitrus']=number_format($fila1->prfitosa/100, 0, ',', '.');
  844. $data['pralcrus']=number_format($fila1->pralcoho/100, 0, ',', '.');
  845. $data['prexrus']=number_format($fila1->prextracto/100, 0, ',', '.');
  846. $data['prpetrus']=number_format($fila1->prpet/100, 0, ',', '.');
  847.  
  848. $this->db->where('pais','suiza');
  849. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  850. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  851. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  852. $consulta=$this->db->get_where('cooperativa');
  853. $fila1=$consulta->row();
  854.  
  855. // Stock KG
  856. $data['fonsui']=number_format($fila1->fondocoop/100, 0, '', '.');
  857. $data['gassui']=number_format($fila1->gaso, 0, ',', '.');
  858. $data['agsui']=number_format($fila1->agua, 0, ',', '.');
  859. $data['maqgsui']=number_format($fila1->maqagri, 0, ',', '.');
  860. $data['maqesui']=number_format($fila1->maqenva, 0, ',', '.');
  861. $data['fersui']=number_format($fila1->fertil, 0, ',', '.');
  862. $data['pessui']=number_format($fila1->pestic, 0, ',', '.');
  863. $data['piesui']=number_format($fila1->pienso, 0, ',', '.');
  864. $data['fitsui']=number_format($fila1->fitosa, 0, ',', '.');
  865. $data['alcsui']=number_format($fila1->alcoho, 0, ',', '.');
  866. $data['exsui']=number_format($fila1->extracto, 0, ',', '.');
  867. $data['petsui']=number_format($fila1->pet, 0, ',', '.');
  868.  
  869. // Precio venta (precio subvencionado)
  870. $data['subgassui']=number_format($fila1->prgaso/100, 0, ',', '.');
  871. $data['subagsui']=number_format($fila1->pragua/100, 0, ',', '.');
  872. $data['submaqgsui']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  873. $data['submaqesui']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  874. $data['subfersui']=number_format($fila1->prfertil/100, 0, ',', '.');
  875. $data['subpessui']=number_format($fila1->prpestic/100, 0, ',', '.');
  876. $data['subpiesui']=number_format($fila1->prpienso/100, 0, ',', '.');
  877. $data['subfitsui']=number_format($fila1->prfitosa/100, 0, ',', '.');
  878. $data['subalcsui']=number_format($fila1->pralcoho/100, 0, ',', '.');
  879. $data['subexsui']=number_format($fila1->prextracto/100, 0, ',', '.');
  880. $data['subpetsui']=number_format($fila1->prpet/100, 0, ',', '.');
  881.  
  882. // Precio Coste (precio medio)
  883. $data['prgassui']=number_format($fila1->prgaso/100, 0, ',', '.');
  884. $data['pragsui']=number_format($fila1->pragua/100, 0, ',', '.');
  885. $data['prmaqgsui']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  886. $data['prmaqesui']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  887. $data['prfersui']=number_format($fila1->prfertil/100, 0, ',', '.');
  888. $data['prpessui']=number_format($fila1->prpestic/100, 0, ',', '.');
  889. $data['prpiesui']=number_format($fila1->prpienso/100, 0, ',', '.');
  890. $data['prfitsui']=number_format($fila1->prfitosa/100, 0, ',', '.');
  891. $data['pralcsui']=number_format($fila1->pralcoho/100, 0, ',', '.');
  892. $data['prexsui']=number_format($fila1->prextracto/100, 0, ',', '.');
  893. $data['prpetsui']=number_format($fila1->prpet/100, 0, ',', '.');
  894.  
  895. $this->db->where('pais','uruguay');
  896. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  897. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  898. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  899. $consulta=$this->db->get_where('cooperativa');
  900. $fila1=$consulta->row();
  901.  
  902. // Stock KG
  903. $data['fonuru']=number_format($fila1->fondocoop/100, 0, '', '.');
  904. $data['gasuru']=number_format($fila1->gaso, 0, ',', '.');
  905. $data['aguru']=number_format($fila1->agua, 0, ',', '.');
  906. $data['maqguru']=number_format($fila1->maqagri, 0, ',', '.');
  907. $data['maqeuru']=number_format($fila1->maqenva, 0, ',', '.');
  908. $data['feruru']=number_format($fila1->fertil, 0, ',', '.');
  909. $data['pesuru']=number_format($fila1->pestic, 0, ',', '.');
  910. $data['pieuru']=number_format($fila1->pienso, 0, ',', '.');
  911. $data['fituru']=number_format($fila1->fitosa, 0, ',', '.');
  912. $data['alcuru']=number_format($fila1->alcoho, 0, ',', '.');
  913. $data['exuru']=number_format($fila1->extracto, 0, ',', '.');
  914. $data['peturu']=number_format($fila1->pet, 0, ',', '.');
  915.  
  916. // Precio venta (precio subvencionado)
  917. $data['subgasuru']=number_format($fila1->prgaso/100, 0, ',', '.');
  918. $data['subaguru']=number_format($fila1->pragua/100, 0, ',', '.');
  919. $data['submaqguru']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  920. $data['submaqeuru']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  921. $data['subferuru']=number_format($fila1->prfertil/100, 0, ',', '.');
  922. $data['subpesuru']=number_format($fila1->prpestic/100, 0, ',', '.');
  923. $data['subpieuru']=number_format($fila1->prpienso/100, 0, ',', '.');
  924. $data['subfituru']=number_format($fila1->prfitosa/100, 0, ',', '.');
  925. $data['subalcuru']=number_format($fila1->pralcoho/100, 0, ',', '.');
  926. $data['subexuru']=number_format($fila1->prextracto/100, 0, ',', '.');
  927. $data['subpeturu']=number_format($fila1->prpet/100, 0, ',', '.');
  928.  
  929. // Precio Coste (precio medio)
  930. $data['prgasuru']=number_format($fila1->prgaso/100, 0, ',', '.');
  931. $data['praguru']=number_format($fila1->pragua/100, 0, ',', '.');
  932. $data['prmaqguru']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  933. $data['prmaqeuru']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  934. $data['prferuru']=number_format($fila1->prfertil/100, 0, ',', '.');
  935. $data['prpesuru']=number_format($fila1->prpestic/100, 0, ',', '.');
  936. $data['prpieuru']=number_format($fila1->prpienso/100, 0, ',', '.');
  937. $data['prfituru']=number_format($fila1->prfitosa/100, 0, ',', '.');
  938. $data['pralcuru']=number_format($fila1->pralcoho/100, 0, ',', '.');
  939. $data['prexuru']=number_format($fila1->prextracto/100, 0, ',', '.');
  940. $data['prpeturu']=number_format($fila1->prpet/100, 0, ',', '.');
  941.  
  942. $this->db->where('pais','venezuela');
  943. $this->db->select('fondocoop,fertil,pestic,gaso,maqagri,agua,pienso,fitosa,alcoho,extracto,maqenva,pet,
  944. prfertil,prpestic,prgaso,prmaqagri,pragua,prpienso,prfitosa,pralcoho,prextracto,prmaqenva,prpet,
  945. subfertil,subpestic,subgaso,submaqagri,subagua,subpienso,subfitosa,subalcoho,subextracto,submaqenva,subpet');
  946. $consulta=$this->db->get_where('cooperativa');
  947. $fila1=$consulta->row();
  948.  
  949. // Stock KG
  950. $data['fonven']=number_format($fila1->fondocoop/100, 0, '', '.');
  951. $data['gasven']=number_format($fila1->gaso, 0, ',', '.');
  952. $data['agven']=number_format($fila1->agua, 0, ',', '.');
  953. $data['maqgven']=number_format($fila1->maqagri, 0, ',', '.');
  954. $data['maqeven']=number_format($fila1->maqenva, 0, ',', '.');
  955. $data['ferven']=number_format($fila1->fertil, 0, ',', '.');
  956. $data['pesven']=number_format($fila1->pestic, 0, ',', '.');
  957. $data['pieven']=number_format($fila1->pienso, 0, ',', '.');
  958. $data['fitven']=number_format($fila1->fitosa, 0, ',', '.');
  959. $data['alcven']=number_format($fila1->alcoho, 0, ',', '.');
  960. $data['exven']=number_format($fila1->extracto, 0, ',', '.');
  961. $data['petven']=number_format($fila1->pet, 0, ',', '.');
  962.  
  963. // Precio venta (precio subvencionado)
  964. $data['subgasven']=number_format($fila1->prgaso/100, 0, ',', '.');
  965. $data['subagven']=number_format($fila1->pragua/100, 0, ',', '.');
  966. $data['submaqgven']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  967. $data['submaqeven']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  968. $data['subferven']=number_format($fila1->prfertil/100, 0, ',', '.');
  969. $data['subpesven']=number_format($fila1->prpestic/100, 0, ',', '.');
  970. $data['subpieven']=number_format($fila1->prpienso/100, 0, ',', '.');
  971. $data['subfitven']=number_format($fila1->prfitosa/100, 0, ',', '.');
  972. $data['subalcven']=number_format($fila1->pralcoho/100, 0, ',', '.');
  973. $data['subexven']=number_format($fila1->prextracto/100, 0, ',', '.');
  974. $data['subpetven']=number_format($fila1->prpet/100, 0, ',', '.');
  975.  
  976. // Precio Coste (precio medio)
  977. $data['prgasven']=number_format($fila1->prgaso/100, 0, ',', '.');
  978. $data['pragven']=number_format($fila1->pragua/100, 0, ',', '.');
  979. $data['prmaqgven']=number_format($fila1->prmaqagri/100, 0, ',', '.');
  980. $data['prmaqeven']=number_format($fila1->prmaqenva/100, 0, ',', '.');
  981. $data['prferven']=number_format($fila1->prfertil/100, 0, ',', '.');
  982. $data['prpesven']=number_format($fila1->prpestic/100, 0, ',', '.');
  983. $data['prpieven']=number_format($fila1->prpienso/100, 0, ',', '.');
  984. $data['prfitven']=number_format($fila1->prfitosa/100, 0, ',', '.');
  985. $data['pralcven']=number_format($fila1->pralcoho/100, 0, ',', '.');
  986. $data['prexven']=number_format($fila1->prextracto/100, 0, ',', '.');
  987. $data['prpetven']=number_format($fila1->prpet/100, 0, ',', '.');
RAW Paste Data