package pwc.taxtech.atms.vat.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.session.RowBounds;
import pwc.taxtech.atms.MyVatMapper;
import pwc.taxtech.atms.vat.entity.Balance;
import pwc.taxtech.atms.vat.entity.BalanceExample;

import java.math.BigDecimal;
import java.util.List;

@Mapper
public interface BalanceMapper extends MyVatMapper {
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT. BALANCE
     *
     * @mbg.generated
     */
    long countByExample(BalanceExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT. BALANCE
     *
     * @mbg.generated
     */
    int deleteByExample(BalanceExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT. BALANCE
     *
     * @mbg.generated
     */
    int deleteByPrimaryKey(String balanceId);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT. BALANCE
     *
     * @mbg.generated
     */
    int insert(Balance record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT. BALANCE
     *
     * @mbg.generated
     */
    int insertSelective(Balance record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT. BALANCE
     *
     * @mbg.generated
     */
    List<Balance> selectByExampleWithRowbounds(BalanceExample example, RowBounds rowBounds);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT. BALANCE
     *
     * @mbg.generated
     */
    List<Balance> selectByExample(BalanceExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT. BALANCE
     *
     * @mbg.generated
     */
    Balance selectByPrimaryKey(String balanceId);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT. BALANCE
     *
     * @mbg.generated
     */
    int updateByExampleSelective(@Param("record") Balance record, @Param("example") BalanceExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT. BALANCE
     *
     * @mbg.generated
     */
    int updateByExample(@Param("record") Balance record, @Param("example") BalanceExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT. BALANCE
     *
     * @mbg.generated
     */
    int updateByPrimaryKeySelective(Balance record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_PROJECT. BALANCE
     *
     * @mbg.generated
     */
    int updateByPrimaryKey(Balance record);

    BigDecimal getSumOfBalance(@Param("acctCode") String acctCode, @Param("direction") int direction, @Param("period") int period);

    BigDecimal getFirstOfBalance(@Param("acctCode") String acctCode, @Param("direction") int direction, @Param("period") int period);

    Balance getFirstWithDbNameAndAccountCodeAndPeriod(@Param("dbName") String dbName, @Param("accountCode") String accountCode,
                                                      @Param("period") int period);
}