```
public interface WorkflowDAO
```

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method	Description
`void`	`deleteWorkflowEntries(String siteId, List<String> paths)`	Delete workflow entries
`void`	`deleteWorkflowEntriesForSite(long siteId)`	Delete workflow entries for site
`void`	`deleteWorkflowEntry(String siteId, String path)`	Delete workflow entry
`void`	`deleteWorkflowEntryById(long id)`	Delete workflow entry
`List<DashboardPublishingPackage>`	`getContentPendingApproval(String siteId, String openedState, int offset, int limit)`	Get workflow packages pending approval
`List<Workflow>`	`getContentPendingApprovalDetail(String siteId, String packageId)`	Get content pending approval for given workflow package id
`Optional<Integer>`	`getContentPendingApprovalTotal(String siteId, String openedState)`	Get total number of workflow packages pending approval
`List<WorkflowItem>`	`getSubmittedItems(String site, String stateOpened)`	Get submitted items
`Workflow`	`getWorkflowEntry(String siteId, String path, String publishingPackageId)`	Get workflow entry
`Workflow`	`getWorkflowEntryForApproval(Long itemId, String stateOpened)`	Get workflow entry for approval
`WorkflowItem`	`getWorkflowEntryOpened(String siteId, String path, String stateOpened)`	Get workflow entry
`void`	`insertWorkflowEntries(List<Workflow> workflowEntries)`	Insert workflow entries
`void`	`insertWorkflowEntry(Workflow workflow)`	Insert workflow entry
`void`	`updateWorkflowEntry(Workflow workflow)`	Update workflow entry

Method Detail

getWorkflowEntryOpened

WorkflowItem getWorkflowEntryOpened(@Param("siteId")
                                    String siteId,
                                    @Param("path")
                                    String path,
                                    @Param("stateOpened")
                                    String stateOpened)

Get workflow entry

Parameters:: siteId - site identifier; path - path of the item; stateOpened - state opened
Returns:

getWorkflowEntryForApproval

Workflow getWorkflowEntryForApproval(@Param("itemId")
                                     Long itemId,
                                     @Param("stateOpened")
                                     String stateOpened)

Get workflow entry for approval

Parameters:: itemId - item identifier; stateOpened - state opened
Returns:

getWorkflowEntry

Workflow getWorkflowEntry(@Param("siteId")
                          String siteId,
                          @Param("path")
                          String path,
                          @Param("publishingPackageId")
                          String publishingPackageId)

Get workflow entry

Parameters:: siteId - site identifier; path -; publishingPackageId -
Returns:

deleteWorkflowEntryById

void deleteWorkflowEntryById(@Param("id")
                             long id)

Delete workflow entry

Parameters:: id - entry id

insertWorkflowEntry

void insertWorkflowEntry(@Param("workflow")
                         Workflow workflow)

Insert workflow entry

Parameters:: workflow - workflow entry

insertWorkflowEntries

void insertWorkflowEntries(@Param("workflowEntries")
                           List<Workflow> workflowEntries)

Insert workflow entries

Parameters:: workflowEntries - list of workflow entries

updateWorkflowEntry
```
void updateWorkflowEntry(Workflow workflow)
```
Update workflow entry

Parameters:

workflow - workflow entry

getSubmittedItems

List<WorkflowItem> getSubmittedItems(@Param("siteId")
                                     String site,
                                     @Param("state")
                                     String stateOpened)

Get submitted items

Parameters:: site - site identifier; stateOpened - state opened
Returns:

deleteWorkflowEntries

void deleteWorkflowEntries(@Param("siteId")
                           String siteId,
                           @Param("paths")
                           List<String> paths)

Delete workflow entries

Parameters:: siteId - site identifier; paths - list of paths

deleteWorkflowEntry

void deleteWorkflowEntry(@Param("siteId")
                         String siteId,
                         @Param("path")
                         String path)

Delete workflow entry

Parameters:: siteId - site identifier; path - path

deleteWorkflowEntriesForSite
```
void deleteWorkflowEntriesForSite(long siteId)
```
Delete workflow entries for site

Parameters:

siteId - site id

getContentPendingApprovalTotal

Optional<Integer> getContentPendingApprovalTotal(@Param("siteId")
                                                 String siteId,
                                                 @Param("state")
                                                 String openedState)

Get total number of workflow packages pending approval

Parameters:: siteId - site identifier; openedState - value for OPENED state
Returns:: total number of workflow packages pending approval

getContentPendingApproval

List<DashboardPublishingPackage> getContentPendingApproval(@Param("siteId")
                                                           String siteId,
                                                           @Param("state")
                                                           String openedState,
                                                           @Param("offset")
                                                           int offset,
                                                           @Param("limit")
                                                           int limit)

Get workflow packages pending approval

Parameters:: siteId - site identifier; openedState - value for OPENED state; offset - offset of the first record in the result; limit - limit number of results
Returns:: list of workflow packages pending approval

getContentPendingApprovalDetail

List<Workflow> getContentPendingApprovalDetail(@Param("siteId")
                                               String siteId,
                                               @Param("packageId")
                                               String packageId)

Get content pending approval for given workflow package id

Parameters:: siteId - site identifier; packageId - workflow package identifier
Returns:: List of workflow entries

Interface WorkflowDAO