Guest User

Untitled

a guest
Dec 21st, 2015
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. $str = $g->get_dropdown_values("
  2. SELECT
  3. distinct ROUND((h.ayuda_conc/10),0) as k,
  4. g.pae_gestion,
  5. g.id_gestion,
  6. h.n_pae,
  7. h.ayuda_conc,
  8. ROUND((h.ayuda_conc/10),0) as v
  9.  
  10. FROM hijos_ayudas h
  11. INNER JOIN
  12. gestion g
  13. ON h.n_pae = g.pae_gestion
  14. ");
  15.  
  16. $col["editoptions"] = array("value"=>":;".$str);
  17. $col["editoptions"]["onload"]["sql"] = "SELECT
  18. distinct ROUND((h.ayuda_conc/10),0) as k,
  19. g.pae_gestion,
  20. g.id_gestion,
  21. h.n_pae,
  22. h.ayuda_conc,
  23. ROUND((h.ayuda_conc/10),0) as v
  24.  
  25. FROM hijos_ayudas h
  26. INNER JOIN
  27. gestion g
  28. ON h.n_pae = g.pae_gestion
  29. WHERE g.id_gestion = '{id_gestion}'";
Add Comment
Please, Sign In to add comment