ru.bgcrm.plugin.bgbilling.proto.dao

Class CrmDao

java.lang.Object

ru.bgcrm.plugin.bgbilling.dao.BillingDAO

ru.bgcrm.plugin.bgbilling.proto.dao.CrmDao

public class CrmDao
extends BillingDAO

Field Summary

Fields inherited from class ru.bgcrm.plugin.bgbilling.dao.BillingDAO

dbInfo, transferData, user

Constructor Summary

Constructors

Constructor and Description
CrmDao(User user, DBInfo dbInfo)
CrmDao(User user, java.lang.String billingId)

Method Summary

Methods

Modifier and Type	Method and Description
void	activateContractOption(java.lang.Integer contractId, java.lang.Integer optionId, java.lang.Integer modeId)
java.util.List<IdTitle>	activateModeList(java.lang.Integer optionId)
java.util.List<IdTitle>	additionalActionList(java.lang.Integer contractId)
java.util.List<ContractTariffGroup>	contractActiveTariffGroup(java.lang.Integer contractId)
java.util.List<IdTitle>	contractAvailableOptionList(java.lang.Integer contractId)
java.util.List<ContractTariff>	contractGlobalTariffList(java.lang.Integer contractId)
ContractObjectModuleInfo	contractObjectModuleList(java.lang.Integer objectId)
java.util.List<IdTitle>	contractObjectTypeList()
java.util.List<ContractPersonalTariff>	contractPersonalTaraffList(java.lang.Integer contractId)
java.util.List<ContractScript>	contractScriptList(java.lang.Integer contractId)
void	contractScriptLogList(SearchResult<ContractScriptLogItem> result, java.lang.Integer contractId, java.lang.String dateFrom, java.lang.String dateTo)
java.util.List<IdTitle>	contractSubcontractList(java.lang.Integer contractId)
IdTitle	contractSupercontract(java.lang.Integer contractId)
java.util.List<ContractTariffGroup>	contractTariffGroupList(java.lang.Integer contractId)
java.util.List<ContractTariffOption>	contractTariffOptionList(java.lang.Integer contractId)
java.util.List<IdTitle>	contractTariffPlanList(java.lang.String tariffItemId, java.lang.Integer moduleId, java.lang.Integer contractId, java.lang.Integer useFilter, java.lang.Integer showUsed)
java.lang.String	createTask(int contractId, int typeId, int groupId, int statusId, java.lang.String targetDate, java.lang.String targetTime, java.lang.String executeDate, java.lang.String executors, java.lang.String resolution, int addressParameterId, java.lang.String comment)
void	deactivateContractOption(java.lang.Integer contractId, java.lang.Integer optionId)
void	deleteContractMemo(java.lang.Integer contractId, java.lang.Integer memoId)
void	deleteContractPersonalTariff(java.lang.Integer contractId, java.lang.Integer tariffId)
void	deleteContractScript(java.lang.Integer scriptId)
void	deleteContractTariffGroup(java.lang.Integer tariffId)
void	deleteContractTariffPlan(java.lang.Integer contractId, java.lang.Integer tariffId)
java.lang.String	executeAdditionalAction(java.lang.Integer contractId, java.lang.Integer actionId)
java.util.List<IdTitle>	getBillingModuleList()
java.util.List<CallProblem>	getCallCurrentProblemList(java.lang.Integer contractId)
java.util.List<Call>	getCallList(java.lang.Integer contractId)
void	getCallList(SearchResult<Call> result, java.lang.Integer contractId)
java.util.List<CallType>	getCallRegisterTypeList()
ContractFace	getContractFace(java.lang.Integer contractId)
java.util.List<ContractMemo>	getContractMemoList(int contractId)
ContractScript	getContractScript(java.lang.Integer scriptId)
ContractTariffGroup	getContractTariffGroup(java.lang.Integer tariffGroupId)
ContractPersonalTariff	getPersonalTaraff(java.lang.Integer tariffId)
java.util.List<IdTitle>	getRegisterExecutorList(java.lang.String groupId)
java.util.List<IdTitle>	getRegisterGroupList()
Problem	getRegisterProblem(java.lang.Integer processId)
java.lang.Integer	getRegisterSubjectGroup(java.lang.Integer typeId)
java.util.List<IdTitle>	getRegistredContractGroupList(java.lang.Integer contractId)
java.util.List<IdTitle>	getRegistredTariffGroupList(java.lang.Integer selectedTariffGroupId)
java.util.List<java.lang.Integer>	getSelectedContractGroupIds(java.lang.Integer contractId)
TariffGroup	getTariffGroup(int groupId)
Task	getTask(int taskId)
void	getTaskList(SearchResult<Task> result, int contractId)
void	getTaskList(SearchResult<Task> result, int contractId, java.util.List<java.lang.Integer> statusIds)
java.util.List<IdTitle>	getTaskTypeList()
java.util.List<IdTitle>	scriptTypeList()
void	searchTask(SearchResult<Task> result, int contractId, java.util.List<java.lang.Integer> typeIds, java.util.List<java.lang.Integer> groupIds, java.util.List<java.lang.Integer> statusIds, java.util.Date createDateFrom, java.util.Date createDateTo, java.util.Date closeDateFrom, java.util.Date closeDateTo, java.util.Date acceptDateFrom, java.util.Date acceptDateTo)
void	updateContractGroup(java.lang.String command, java.lang.Integer contractId, java.lang.Integer groupId)
void	updateContractMemo(java.lang.Integer contractId, java.lang.Integer memoId, java.lang.String memoTitle, java.lang.String memoText)
void	updateContractMemo(java.lang.Integer contractId, java.lang.Integer memoId, java.lang.String memoTitle, java.lang.String memoText, boolean visible)
void	updateContractPersonalTariff(java.lang.Integer contractId, java.lang.Integer tariffId, java.lang.String title, java.lang.Integer position, java.lang.String dateFrom, java.lang.String dateTo)
void	updateContractScript(java.lang.Integer contractId, java.lang.Integer scriptId, java.lang.Integer scriptTypeId, java.lang.String comment, java.lang.String dateFrom, java.lang.String dateTo)
void	updateContractTariffGroup(java.lang.Integer contractId, java.lang.Integer tariffId, java.lang.Integer tariffGroupId, java.lang.String dateFrom, java.lang.String dateTo, java.lang.String comment)
void	updateContractTariffPlan(java.lang.Integer contractId, java.lang.Integer tariffId, java.lang.Integer tpid, java.lang.Integer position, java.lang.String dateFrom, java.lang.String dateTo, java.lang.String comment)
int	updateRegisterCall(int contractId, int subjectId, int groupId, int problemId, java.lang.String comment, java.lang.String problemComment) Функция создаёт звонок в плагине биллинга "CRM"
java.lang.String	updateRegisterProblem(java.lang.Integer problemId, java.lang.Integer statusId, java.lang.Integer groupId, java.lang.String executors, java.lang.String comment, java.lang.Integer urgency)
void	updateRegisterProblemShort(java.lang.Integer problemId, java.lang.Integer status, java.lang.String comment)
java.lang.String	updateTask(int taskId, int contractId, int typeId, int groupId, int statusId, java.lang.String targetDate, java.lang.String targetTime, java.lang.String executeDate, java.lang.String executors, java.lang.String resolution, int addressParameterId, java.lang.String comment)

Methods inherited from class ru.bgcrm.plugin.bgbilling.dao.BillingDAO

doRequest, getDbInfo, getPage, getParameterId, setPage

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

CrmDao

public CrmDao(User user,
      java.lang.String billingId)
       throws BGException

Throws:

BGException

CrmDao

public CrmDao(User user,
      DBInfo dbInfo)
       throws BGException

Throws:

BGException

Method Detail

createTask

public java.lang.String createTask(int contractId,
                          int typeId,
                          int groupId,
                          int statusId,
                          java.lang.String targetDate,
                          java.lang.String targetTime,
                          java.lang.String executeDate,
                          java.lang.String executors,
                          java.lang.String resolution,
                          int addressParameterId,
                          java.lang.String comment)
                            throws BGException

Throws:

BGException

getTask

public Task getTask(int taskId)
             throws BGException

Throws:

BGException

updateTask

public java.lang.String updateTask(int taskId,
                          int contractId,
                          int typeId,
                          int groupId,
                          int statusId,
                          java.lang.String targetDate,
                          java.lang.String targetTime,
                          java.lang.String executeDate,
                          java.lang.String executors,
                          java.lang.String resolution,
                          int addressParameterId,
                          java.lang.String comment)
                            throws BGException

Throws:

BGException

updateRegisterCall

public int updateRegisterCall(int contractId,
                     int subjectId,
                     int groupId,
                     int problemId,
                     java.lang.String comment,
                     java.lang.String problemComment)
                       throws BGException

Функция создаёт звонок в плагине биллинга "CRM"

Parameters:

contractId - ID договора к которому будет привязан звонок

subjectId - ID типа звонка

groupId - ID группы, на которую будет зарегистрирован звонок и проблема

problemId - ID проблемы к которой будет привязан звонок, если problemId <= 0, то будет создана новая проблема

comment - комментарий к звонку

problemComment - комментарий к проблеме

Returns:

ID проблемы, созданной по звонку, иначе -1

Throws:

BGException

updateRegisterProblemShort

public void updateRegisterProblemShort(java.lang.Integer problemId,
                              java.lang.Integer status,
                              java.lang.String comment)
                                throws BGException

Throws:

BGException

getCallList

public java.util.List<Call> getCallList(java.lang.Integer contractId)
                                 throws BGException

Throws:

BGException

getCallList

public void getCallList(SearchResult<Call> result,
               java.lang.Integer contractId)
                 throws BGException

Throws:

BGException

getCallRegisterTypeList

public java.util.List<CallType> getCallRegisterTypeList()
                                                 throws BGException

Throws:

BGException

getRegisterGroupList

public java.util.List<IdTitle> getRegisterGroupList()
                                             throws BGException

Throws:

BGException

getRegisterSubjectGroup

public java.lang.Integer getRegisterSubjectGroup(java.lang.Integer typeId)
                                          throws BGException

Throws:

BGException

getRegisterExecutorList

public java.util.List<IdTitle> getRegisterExecutorList(java.lang.String groupId)
                                                throws BGException

Throws:

BGException

getCallCurrentProblemList

public java.util.List<CallProblem> getCallCurrentProblemList(java.lang.Integer contractId)
                                                      throws BGException

Throws:

BGException

getTaskTypeList

public java.util.List<IdTitle> getTaskTypeList()
                                        throws BGException

Throws:

BGException

getTaskList

public void getTaskList(SearchResult<Task> result,
               int contractId)
                 throws BGException

Throws:

BGException

getTaskList

public void getTaskList(SearchResult<Task> result,
               int contractId,
               java.util.List<java.lang.Integer> statusIds)
                 throws BGException

Throws:

BGException

searchTask

public void searchTask(SearchResult<Task> result,
              int contractId,
              java.util.List<java.lang.Integer> typeIds,
              java.util.List<java.lang.Integer> groupIds,
              java.util.List<java.lang.Integer> statusIds,
              java.util.Date createDateFrom,
              java.util.Date createDateTo,
              java.util.Date closeDateFrom,
              java.util.Date closeDateTo,
              java.util.Date acceptDateFrom,
              java.util.Date acceptDateTo)
                throws BGException

Throws:

BGException

updateRegisterProblem

public java.lang.String updateRegisterProblem(java.lang.Integer problemId,
                                     java.lang.Integer statusId,
                                     java.lang.Integer groupId,
                                     java.lang.String executors,
                                     java.lang.String comment,
                                     java.lang.Integer urgency)
                                       throws BGException

Throws:

BGException

getRegisterProblem

public Problem getRegisterProblem(java.lang.Integer processId)
                           throws BGException

Throws:

BGException

additionalActionList

public java.util.List<IdTitle> additionalActionList(java.lang.Integer contractId)
                                             throws BGException

Throws:

BGException

executeAdditionalAction

public java.lang.String executeAdditionalAction(java.lang.Integer contractId,
                                       java.lang.Integer actionId)
                                         throws BGException

Throws:

BGException

getRegistredContractGroupList

public java.util.List<IdTitle> getRegistredContractGroupList(java.lang.Integer contractId)
                                                      throws BGException

Throws:

BGException

getSelectedContractGroupIds

public java.util.List<java.lang.Integer> getSelectedContractGroupIds(java.lang.Integer contractId)
                                                              throws BGException

Throws:

BGException

updateContractGroup

public void updateContractGroup(java.lang.String command,
                       java.lang.Integer contractId,
                       java.lang.Integer groupId)
                         throws BGException

Throws:

BGException

getContractMemoList

public java.util.List<ContractMemo> getContractMemoList(int contractId)
                                                 throws BGException

Throws:

BGException

updateContractMemo

public void updateContractMemo(java.lang.Integer contractId,
                      java.lang.Integer memoId,
                      java.lang.String memoTitle,
                      java.lang.String memoText,
                      boolean visible)
                        throws BGException

Throws:

BGException

updateContractMemo

public void updateContractMemo(java.lang.Integer contractId,
                      java.lang.Integer memoId,
                      java.lang.String memoTitle,
                      java.lang.String memoText)
                        throws BGException

Throws:

BGException

deleteContractMemo

public void deleteContractMemo(java.lang.Integer contractId,
                      java.lang.Integer memoId)
                        throws BGException

Throws:

BGException

getBillingModuleList

public java.util.List<IdTitle> getBillingModuleList()
                                             throws BGException

Throws:

BGException

contractTariffPlanList

public java.util.List<IdTitle> contractTariffPlanList(java.lang.String tariffItemId,
                                             java.lang.Integer moduleId,
                                             java.lang.Integer contractId,
                                             java.lang.Integer useFilter,
                                             java.lang.Integer showUsed)
                                               throws BGException

Throws:

BGException

contractGlobalTariffList

public java.util.List<ContractTariff> contractGlobalTariffList(java.lang.Integer contractId)
                                                        throws BGException

Throws:

BGException

updateContractTariffPlan

public void updateContractTariffPlan(java.lang.Integer contractId,
                            java.lang.Integer tariffId,
                            java.lang.Integer tpid,
                            java.lang.Integer position,
                            java.lang.String dateFrom,
                            java.lang.String dateTo,
                            java.lang.String comment)
                              throws BGException

Throws:

BGException

deleteContractTariffPlan

public void deleteContractTariffPlan(java.lang.Integer contractId,
                            java.lang.Integer tariffId)
                              throws BGException

Throws:

BGException

contractActiveTariffGroup

public java.util.List<ContractTariffGroup> contractActiveTariffGroup(java.lang.Integer contractId)
                                                              throws BGException

Throws:

BGException

contractTariffGroupList

public java.util.List<ContractTariffGroup> contractTariffGroupList(java.lang.Integer contractId)
                                                            throws BGException

Throws:

BGException

getTariffGroup

public TariffGroup getTariffGroup(int groupId)

getContractTariffGroup

public ContractTariffGroup getContractTariffGroup(java.lang.Integer tariffGroupId)
                                           throws BGException

Throws:

BGException

getRegistredTariffGroupList

public java.util.List<IdTitle> getRegistredTariffGroupList(java.lang.Integer selectedTariffGroupId)
                                                    throws BGException

Throws:

BGException

updateContractTariffGroup

public void updateContractTariffGroup(java.lang.Integer contractId,
                             java.lang.Integer tariffId,
                             java.lang.Integer tariffGroupId,
                             java.lang.String dateFrom,
                             java.lang.String dateTo,
                             java.lang.String comment)
                               throws BGException

Throws:

BGException

deleteContractTariffGroup

public void deleteContractTariffGroup(java.lang.Integer tariffId)
                               throws BGException

Throws:

BGException

contractTariffOptionList

public java.util.List<ContractTariffOption> contractTariffOptionList(java.lang.Integer contractId)
                                                              throws BGException,
                                                                     java.text.ParseException

Throws:

BGException

java.text.ParseException

contractAvailableOptionList

public java.util.List<IdTitle> contractAvailableOptionList(java.lang.Integer contractId)
                                                    throws BGException

Throws:

BGException

activateModeList

public java.util.List<IdTitle> activateModeList(java.lang.Integer optionId)
                                         throws BGException

Throws:

BGException

activateContractOption

public void activateContractOption(java.lang.Integer contractId,
                          java.lang.Integer optionId,
                          java.lang.Integer modeId)
                            throws BGException

Throws:

BGException

deactivateContractOption

public void deactivateContractOption(java.lang.Integer contractId,
                            java.lang.Integer optionId)
                              throws BGException

Throws:

BGException

contractPersonalTaraffList

public java.util.List<ContractPersonalTariff> contractPersonalTaraffList(java.lang.Integer contractId)
                                                                  throws BGException

Throws:

BGException

getPersonalTaraff

public ContractPersonalTariff getPersonalTaraff(java.lang.Integer tariffId)
                                         throws BGException

Throws:

BGException

deleteContractPersonalTariff

public void deleteContractPersonalTariff(java.lang.Integer contractId,
                                java.lang.Integer tariffId)
                                  throws BGException

Throws:

BGException

updateContractPersonalTariff

public void updateContractPersonalTariff(java.lang.Integer contractId,
                                java.lang.Integer tariffId,
                                java.lang.String title,
                                java.lang.Integer position,
                                java.lang.String dateFrom,
                                java.lang.String dateTo)
                                  throws BGException

Throws:

BGException

contractObjectTypeList

public java.util.List<IdTitle> contractObjectTypeList()
                                               throws BGException

Throws:

BGException

contractObjectModuleList

public ContractObjectModuleInfo contractObjectModuleList(java.lang.Integer objectId)
                                                  throws BGException

Throws:

BGException

contractSubcontractList

public java.util.List<IdTitle> contractSubcontractList(java.lang.Integer contractId)
                                                throws BGException

Throws:

BGException

contractSupercontract

public IdTitle contractSupercontract(java.lang.Integer contractId)
                              throws BGException

Throws:

BGException

contractScriptList

public java.util.List<ContractScript> contractScriptList(java.lang.Integer contractId)
                                                  throws BGException

Throws:

BGException

contractScriptLogList

public void contractScriptLogList(SearchResult<ContractScriptLogItem> result,
                         java.lang.Integer contractId,
                         java.lang.String dateFrom,
                         java.lang.String dateTo)
                           throws BGException

Throws:

BGException

getContractScript

public ContractScript getContractScript(java.lang.Integer scriptId)
                                 throws BGException

Throws:

BGException

scriptTypeList

public java.util.List<IdTitle> scriptTypeList()
                                       throws BGException

Throws:

BGException

updateContractScript

public void updateContractScript(java.lang.Integer contractId,
                        java.lang.Integer scriptId,
                        java.lang.Integer scriptTypeId,
                        java.lang.String comment,
                        java.lang.String dateFrom,
                        java.lang.String dateTo)
                          throws BGException

Throws:

BGException

deleteContractScript

public void deleteContractScript(java.lang.Integer scriptId)
                          throws BGException

Throws:

BGException

getContractFace

public ContractFace getContractFace(java.lang.Integer contractId)
                             throws BGException

Throws:

BGException