Subversion Repositories SmartDukaan

package in.shop2020.payment.persistence;

import java.util.List;

import java.util.Map;

import org.apache.ibatis.annotations.Param;

import in.shop2020.payment.domain.Payment;

import in.shop2020.payment.domain.PaymentAttribute;

public interface PaymentMapper {

	int insertPayment(Payment payment);

	void updatePayment(Payment payment);

	// TODO: All getPayment methods currently employ the simple N+1 strategy to

	// load the attributes. This is not desirable. Instead, more labour should

	// be spent into writing the long result maps which will use a single query.

	Payment getPayment(long id);

	List<Payment> getPaymentsForUser(@Param("userId") long userId,

			@Param("fromTime") String fromTime, @Param("toTime") String toTime,

			@Param("status") int status, @Param("gatewayId") long gatewayId);

	List<Payment> getPayments(@Param("fromTime") String fromTime, @Param("toTime") String toTime,

			@Param("status") int status, @Param("gatewayId") long gatewayId);

	List<Payment> getPaymentsByCapturedDate(@Param("fromTime") String fromTime, @Param("toTime") String toTime,

			@Param("status") int status, @Param("gatewayId") long gatewayId);

    /**

     * Currently, it returns the last payment for a transaction assuming that

     * it is the only one which can be successful.

     * 

     * @param merchantTxnId

     *            The merchant transaction for which payments are required.

     * @return A list of payments

     */

	List<Payment> getPaymentForTxn(long merchantTxnId);

    /**

     * Finds the maximum and minimum amount among the successful payments.

     * 

     * @return A map containing the maximum and minimum amount keyed using MAX

     *         and MIN as keys respectively.

     */

	Map<String, Float> getMinMaxPaymentAmount();

    /**

     * Get the list of attributes of a payment.

     * 

     * @param id

     *            Id of the payment whose attributes are required.

     * @return A list of all the attributes of a payment.

     */

	List<PaymentAttribute> getAttributesForPayment(long id);

    /**

     * Inserts an attribute for the given payments. If the attribute is already

     * present, just updates its value.

     * 

     * @param paymentId

     *            Id of the payment for which the attribute has to be added or

     *            updated.

     * @param name

     *            Name of the attribute

     * @param value

     *            Value of the attribute

     */

	void insertPaymentAttribute(@Param("paymentId") long paymentId,

			@Param("name") String name, @Param("value") String value);

    List<Payment> getPaymentForRechargeTxn(long merchantTxnId);

}