Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function getDataList($core_order, mysqli $mysqli) {
- $ids = array();
- $result = $mysqli->query(""
- . "SELECT "
- . "auth7.auth7_id AS id, "
- . "pa.payment_attempt_id AS pa_id, "
- . "pa.core_id AS pa_core_id "
- . "FROM "
- . "payment p "
- . "INNER JOIN "
- . "payment_attempt pa "
- . "ON "
- . "pa.`payment_attempt_id` = p.`payment_attempt_id` "
- . "AND "
- . "pa.`core_id` = p.`payment_attempt_core_id` "
- . "INNER JOIN "
- . "ucs_auth7 auth7 "
- . "ON "
- . "auth7.`payment_id` = p.`payment_id` "
- . "AND "
- . "auth7.`payment_core_id` = p.`core_id` "
- . "WHERE "
- . "(pa.`order_core_id`, pa.`order_id`) IN (" . $core_order . ")"
- . "");
- while ($row = $result->fetch_assoc()) {
- $ids[] = $row;
- }
- return $ids;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement