com.broadleafcommerce.oms.fulfillment.dao

Class FulfillmentOrderAdminAssignmentDaoImpl

java.lang.Object

com.broadleafcommerce.oms.fulfillment.dao.FulfillmentOrderAdminAssignmentDaoImpl

All Implemented Interfaces:

FulfillmentOrderAdminAssignmentDao

@Repository(value="blFulfillmentOrderAdminAssignmentDao")
public class FulfillmentOrderAdminAssignmentDaoImpl
extends Object
implements FulfillmentOrderAdminAssignmentDao

Field Summary

Fields

Modifier and Type	Field and Description
protected javax.persistence.EntityManager	em
protected org.broadleafcommerce.common.persistence.EntityConfiguration	entityConfiguration
protected FulfillmentOrderDao	fulfillmentOrderDao

Constructor Summary

Constructors

Constructor and Description
FulfillmentOrderAdminAssignmentDaoImpl()

Method Summary

Modifier and Type	Method and Description
FulfillmentOrder	assignFulfillmentOrderToAdmin(FulfillmentOrder fulfillmentOrder, org.broadleafcommerce.openadmin.server.security.domain.AdminUser admin)
FulfillmentOrder	assignNextAvailableFulfillmentOrder(org.broadleafcommerce.openadmin.server.security.domain.AdminUser adminUser)
FulfillmentOrderAdminAssignment	createNew() Creates a new instance of OrderAdminAssignment.
void	delete(FulfillmentOrderAdminAssignment foaa) Deletes the OrderAdminAssignment.
protected List<FulfillmentOrder>	findNextAvailableFulfillmentOrders() SELECT DISTINCT fo.FULFILLMENT_ORDER_ID FROM BLC_FULFILLMENT_ORDER fo JOIN BLC_FULFILLMENT_GROUP fg JOIN BLC_ORDER o WHERE o.orderStatus = 'SUBMITTED' AND fo.status = 'NEW' AND fo.FULFILLMENT_ORDER_ID NOT IN (SELECT a.FULFILLMENT_ORDER_ID FROM BLC_FULFILLMENT_ORDER_ADMIN_ASSIGNMENT a) AND o.ORDER_ID NOT IN (SELECT obr.ORDER_ID FROM BLC_ORDER_BLOCK_REASON obr WHERE obr.status = 'FAIL') ORDER BY o.submitDate
FulfillmentOrderAdminAssignment	readById(Long id) Reads OrderAdminAssignment by primary key.
List<FulfillmentOrder>	readFulfillmentOrdersAssignedToAdmin(org.broadleafcommerce.openadmin.server.security.domain.AdminUser admin) Reads all of the Orders associated with the AdminUser
FulfillmentOrderAdminAssignment	save(FulfillmentOrderAdminAssignment foaa) Saves the OrderAdminAssignment.
FulfillmentOrder	unassignFulfillmentOrder(FulfillmentOrder fulfillmentOrder)

Methods inherited from class java.lang.Object

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

Field Detail

fulfillmentOrderDao

protected FulfillmentOrderDao fulfillmentOrderDao

entityConfiguration

protected org.broadleafcommerce.common.persistence.EntityConfiguration entityConfiguration

em

protected javax.persistence.EntityManager em

Constructor Detail

FulfillmentOrderAdminAssignmentDaoImpl

public FulfillmentOrderAdminAssignmentDaoImpl()

Method Detail

createNew

public FulfillmentOrderAdminAssignment createNew()

Description copied from interface: FulfillmentOrderAdminAssignmentDao

Creates a new instance of OrderAdminAssignment.

Specified by:

createNew in interface FulfillmentOrderAdminAssignmentDao

Returns:

readById

public FulfillmentOrderAdminAssignment readById(Long id)

Description copied from interface: FulfillmentOrderAdminAssignmentDao

Reads OrderAdminAssignment by primary key.

Specified by:

readById in interface FulfillmentOrderAdminAssignmentDao

Returns:

save

public FulfillmentOrderAdminAssignment save(FulfillmentOrderAdminAssignment foaa)

Description copied from interface: FulfillmentOrderAdminAssignmentDao

Saves the OrderAdminAssignment.

Specified by:

save in interface FulfillmentOrderAdminAssignmentDao

Returns:

delete

public void delete(FulfillmentOrderAdminAssignment foaa)

Description copied from interface: FulfillmentOrderAdminAssignmentDao

Deletes the OrderAdminAssignment.

Specified by:

delete in interface FulfillmentOrderAdminAssignmentDao

assignNextAvailableFulfillmentOrder

@Transactional(value="blTransactionManager")
public FulfillmentOrder assignNextAvailableFulfillmentOrder(org.broadleafcommerce.openadmin.server.security.domain.AdminUser adminUser)

Specified by:

assignNextAvailableFulfillmentOrder in interface FulfillmentOrderAdminAssignmentDao

unassignFulfillmentOrder

@Transactional(value="blTransactionManager")
public FulfillmentOrder unassignFulfillmentOrder(FulfillmentOrder fulfillmentOrder)

Specified by:

unassignFulfillmentOrder in interface FulfillmentOrderAdminAssignmentDao

assignFulfillmentOrderToAdmin

@Transactional(value="blTransactionManager")
public FulfillmentOrder assignFulfillmentOrderToAdmin(FulfillmentOrder fulfillmentOrder,
                                                                                                   org.broadleafcommerce.openadmin.server.security.domain.AdminUser admin)

Specified by:

assignFulfillmentOrderToAdmin in interface FulfillmentOrderAdminAssignmentDao

findNextAvailableFulfillmentOrders

protected List<FulfillmentOrder> findNextAvailableFulfillmentOrders()

SELECT DISTINCT fo.FULFILLMENT_ORDER_ID FROM BLC_FULFILLMENT_ORDER fo JOIN BLC_FULFILLMENT_GROUP fg JOIN BLC_ORDER o WHERE o.orderStatus = 'SUBMITTED' AND fo.status = 'NEW' AND fo.FULFILLMENT_ORDER_ID NOT IN (SELECT a.FULFILLMENT_ORDER_ID FROM BLC_FULFILLMENT_ORDER_ADMIN_ASSIGNMENT a) AND o.ORDER_ID NOT IN (SELECT obr.ORDER_ID FROM BLC_ORDER_BLOCK_REASON obr WHERE obr.status = 'FAIL') ORDER BY o.submitDate

readFulfillmentOrdersAssignedToAdmin

public List<FulfillmentOrder> readFulfillmentOrdersAssignedToAdmin(org.broadleafcommerce.openadmin.server.security.domain.AdminUser admin)

Description copied from interface: FulfillmentOrderAdminAssignmentDao

Reads all of the Orders associated with the AdminUser

Specified by:

readFulfillmentOrdersAssignedToAdmin in interface FulfillmentOrderAdminAssignmentDao