Guest User

Untitled

a guest
Jan 22nd, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.82 KB | None | 0 0
  1. $sql = "SELECT" "pr_employees.doctype_id, pr_employees.id, pr_employees.last_name,
  2. pr_employees.last_name2, pr_employees.name, pr_employees.bod, pr_employees.gender,
  3. pr_employees.address, pr_employees.phone, pr_employees.cell_phone, pr_employees.email,
  4. pr_employees.city_birth, pr_employees.city_life, pr_employees.cost_center_id,
  5. pr_employees.cesantias_id, pr_employees.afp_id, pr_employees.eps_id, pr_employees.ccf_id,
  6. pr_employeespr_cost_centers.provision_group_id, pr_employees.bank, pr_employees.bank_account,
  7. pr_employees.relationship_id, pr_employees.status, pr_employees.doa, pr_employees.dor,
  8. pr_cities.city, c.city,
  9. pr_cost_centers.cost_center,
  10. pr_relationship.relationship,
  11. pr_funds.fund, f.fund, u.fund, n.fund,
  12. pr_provision_groups.provision_group";
  13. $sql .= " FROM pr_employees";
  14. $sql .= " INNER JOIN pr_relationship ON pr_relationship.id = pr_employees.relationship_id ";
  15. $sql .= " INNER JOIN pr_cities ON pr_cities.id = pr_employees.city_birth ". $joinString;
  16. $sql .= " INNER JOIN pr_cities AS c ON pr_employees.city_life = c.id ". $joinString;
  17. $sql .= " INNER JOIN pr_cost_centers ON pr_cost_centers.id = pr_employees.cost_center_id ". $joinString;
  18. $sql .= " INNER JOIN pr_funds ON pr_employees.cesantias_id = pr_funds.id ". $joinString;
  19. $sql .= " INNER JOIN pr_funds AS f ON pr_employees.afp_id = f.id ". $joinString;
  20. $sql .= " INNER JOIN pr_funds AS u ON pr_employees.eps_id = u.id ". $joinString;
  21. $sql .= " INNER JOIN pr_funds AS n ON pr_employees.ccf_id = n.id ". $joinString;
  22. $sql .= " INNER JOIN pr_provision_groups ON pr_provision_groups.id = pr_employees.provision_group_id ". $joinString;
  23. $sql .= " WHERE pr_employees.id = 35523859 ". $whereString;
  24. $result = $this->db->fetchAll($sql, PhalconDb::FETCH_ASSOC, $params);
  25. $this->jsonResponseAction(['data' => $result]);
  26. }
Add Comment
Please, Sign In to add comment