Advertisement
Guest User

Untitled

a guest
Dec 5th, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. public function getDataList($core_order, mysqli $mysqli) {
  2. $ids = array();
  3. $result = $mysqli->query(""
  4. . "SELECT "
  5. . "auth7.auth7_id AS id, "
  6. . "pa.payment_attempt_id AS pa_id, "
  7. . "pa.core_id AS pa_core_id "
  8. . "FROM "
  9. . "payment p "
  10. . "INNER JOIN "
  11. . "payment_attempt pa "
  12. . "ON "
  13. . "pa.`payment_attempt_id` = p.`payment_attempt_id` "
  14. . "AND "
  15. . "pa.`core_id` = p.`payment_attempt_core_id` "
  16. . "INNER JOIN "
  17. . "ucs_auth7 auth7 "
  18. . "ON "
  19. . "auth7.`payment_id` = p.`payment_id` "
  20. . "AND "
  21. . "auth7.`payment_core_id` = p.`core_id` "
  22. . "WHERE "
  23. . "(pa.`order_core_id`, pa.`order_id`) IN (" . $core_order . ")"
  24. . "");
  25. while ($row = $result->fetch_assoc()) {
  26. $ids[] = $row;
  27. }
  28. return $ids;
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement