package th.co.muangthai.endrprint.dao.serviceInterface;

import th.co.muangthai.endrprint.model.bean.form.data.PrinterDataTxtForm;
import th.co.muangthai.endrprint.model.bean.form.data.PrintingDataForm;
import th.co.muangthai.endrprint.model.bean.form.master.*;
import th.co.muangthai.endrprint.model.bean.master.EndrPrintServerBean;
import th.co.muangthai.endrprint.model.bean.master.EndrProvincialBean;
import th.co.muangthai.endrprint.model.bean.master.EndrProvincialPrintBean;
import th.co.muangthai.endrprint.model.bean.tmp.EndrTmpDataPrintBean;

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

/**
 * Information management Job CommonService Interface
 */
public interface CommonServiceInterface {

    /**
     * Check Connect Database
     *
     * @return Boolean Result
     */
    public boolean chkConnectDB();

    /**
     * Update Table
     *
     * @param obj -Data Object
     * @return Boolean Result
     */
    public boolean updateTable(Object obj);

    /**
     * Update Table
     *
     * @param obj  -Data Object
     * @param obj2 -Data Object
     * @param obj3 -Data Object
     * @param obj4 -Data Object
     * @param obj5 -Data Object
     * @return Boolean Result
     */
    public boolean updateTable(Object obj, Object obj2, Object obj3, Object obj4, Object obj5);

    /**
     * Search Class By Primary key
     *
     * @param obj -Data Object
     * @param pk  -Primary key
     * @return Object Result
     */
    public Object searchClassByPK(Object obj, BigDecimal pk);

    /**
     * Search Class By Primary key BigDecimal
     *
     * @param obj -Data Object
     * @param pk  -Primary key
     * @return Object Result
     */
    public Object searchClassByPKBigDecimal(Object obj, BigDecimal pk);

    /**
     * Search Class By Primary key
     *
     * @param obj -Data Object
     * @param pk  -Primary key
     * @return Object Result
     */
    public Object searchClassByPK(Object obj, String pk);

    /**
     * Search user login by package
     *
     * @param userId   - userId
     * @param passWord - password
     * @return EndrUserLoginForm - data
     */
    public EndrUserLoginForm searchUserLoginBeanByUserId(String userId, String passWord);

    /**
     * Search ENDR data print
     *
     * @param dataForm - PrintingDataForm
     * @return - List of PrintingDataForm
     */
    public List<PrintingDataForm> searchPrintingDataFormPkg(PrintingDataForm dataForm);

    /**
     * Search Endr Print Server for ENDR300
     *
     * @param dataForm - EndrPrintServerForm
     * @return - List of EndrPrintServerForm
     */
    public List<EndrPrintServerForm> searchEndrPrintServerFormPkg(EndrPrintServerForm dataForm);

    /**
     * Search Endr Print Server for ENDR400
     *
     * @param b - EndrPrintServerForm
     * @return - List of EndrPrintServerForm
     */
    public List<EndrPrintServerBean> searchEndrPrintServerByBean(EndrPrintServerForm b);


    /**
     * Search Endr Provincial for ENDR400
     *
     * @param b - EndrProvincialForm
     * @return - List of EndrProvincialForm
     */
    public List<EndrProvincialBean> searchEndrProvincialByBean(EndrProvincialForm b);

    /**
     * Search Endr Provincial Print for ENDR400
     *
     * @param provincialId - BigDecimal
     * @param serverId     - BigDecimal
     * @return - List of EndrProvincialPrintForm
     */
    public List<EndrProvincialPrintForm> searchEndrProvincialPrintByPkg(BigDecimal provincialId, BigDecimal serverId, BigDecimal statusFlag);


    /**
     * Insert/Save Endr Print Server into temp table by package
     *
     * @param endrPrintServerBean - Endr Print Server
     * @return boolean
     */
    public boolean insertEndrPrintServer(EndrPrintServerBean endrPrintServerBean);

    /**
     * Insert/Save Endr Print Server into temp table by package
     *
     * @param endrProvincialPrintBean - Endr Print Server
     * @return boolean
     */
    public boolean insertEndrProvincialPrint(EndrProvincialPrintBean endrProvincialPrintBean);


    /**
     * Insert/Save Endr Print Server into temp table by package
     *
     * @param endrProvincialPrintBean - Endr Print Server
     * @return boolean
     */
    public boolean deleteEndrProvincialPrint(EndrProvincialPrintBean endrProvincialPrintBean);

    /**
     * Search master team by package
     *
     * @param userId - userId
     * @return List of TeamForm
     */
    public List<TeamForm> searchTeamFormPkg(String userId);

    /**
     * Search master printer by package
     *
     * @param userId - userId
     * @return List of PrinterForm
     */
    public List<PrinterForm> searchPrinterFormPkg(String userId);

    /**
     * Insert/Save ENDR print data into temp table by package
     *
     * @param lstEndrTmpDataPrintBean - list of ENDR print data
     * @return boolean
     */
    public boolean insertEndrTmpDataPrint(List<EndrTmpDataPrintBean> lstEndrTmpDataPrintBean);

    /**
     * Search ENDR print data by package
     *
     * @param sProcessID - processId
     * @param sType      - 0 = first printing, 1 = reprint
     * @return List of PrinterDataTxtForm
     */
    public List<PrinterDataTxtForm> searchPrinterDataTxtFormPkg(String sProcessID, BigDecimal sType);

    /**
     * Update ENDR print data to finish by package
     *
     * @param sProcessID - processId
     * @param sType      - 0 = first printing, 1 = reprint
     * @return boolean
     */
    public boolean updateFinishFtp(String sProcessID, BigDecimal sType);

    /**
     * Update ENDR print data to reject by package
     *
     * @param sProcessID - processId
     * @param sType      - 0 = first printing, 1 = reject
     * @return boolean
     */
    public boolean updateReject(String sProcessID, BigDecimal sType);

    /**
     * Search data path file
     *
     * @return Map Result
     */
    public Map getPathFile();

    public Object[] searchTxtSql(String sql);

    public int executeTxtSql(String sql);

    public boolean executeTxtSqlUpdatePkg(String sql);

    public Object[] searchTxtSqlEdas(String sql);

    /**
     * Search master provincial by package
     *
     * @param userId - userId
     * @return object of EndrProvincialForm
     */
    public EndrProvincialForm searchProvincialFormPkg(String userId);

    /**
     * Search master provincial by package
     *
     * @param provincial - provincial
     * @return boolean
     */
    public boolean isProvincialFormPkg(EndrProvincialForm provincial);

    /**
     * Search master team by package
     *
     * @param userId - userId
     * @return List of TeamForm
     */
    public List<TeamForm> searchProvincialTeamFormPkg(String userId);

    /**
     * Search master printer by package
     *
     * @param userId - userId
     * @return List of PrinterForm
     */
    public List<PrinterForm> searchProvincialPrinterFormPkg(String userId);

    /**
     * Search userId printer by package
     *
     * @param userId    - userId
     * @param firstname - firstname
     * @param lastname  - lastname
     * @param operId    - operId
     * @return List of EndrUserLoginForm -data
     */
    public List<EndrUserLoginForm> searchLstUserLoginBeanFormPkg(String userId, String firstname, String lastname, String operId);
}