50 lines
1.1 KiB
SQL
50 lines
1.1 KiB
SQL
|
|
DROP PROCEDURE IF EXISTS `SetExpenseClaimGroup`
|
|
|
|
#
|
|
|
|
DROP PROCEDURE IF EXISTS `SetExpenseClaimGroupClosed`
|
|
|
|
#
|
|
|
|
|
|
CREATE PROCEDURE `SetExpenseClaimGroupClosed` (
|
|
IN expenseClaimGroupId INT
|
|
)
|
|
BEGIN
|
|
DECLARE createdByPersonId INT;
|
|
DECLARE organizationId INT;
|
|
|
|
SELECT ExpenseClaimGroups.CreatedByPersonId
|
|
INTO createdByPersonId FROM ExpenseClaimGroups
|
|
WHERE ExpenseClaimGroups.ExpenseClaimGroupId = expenseClaimGroupId;
|
|
|
|
SELECT ExpenseClaimGroups.OrganizationId
|
|
INTO organizationId FROM ExpenseClaimGroups
|
|
WHERE ExpenseClaimGroups.ExpenseClaimGroupId = expenseClaimGroupId;
|
|
|
|
UPDATE ExpenseClaimGroups
|
|
SET ExpenseClaimGroups.Open = 0
|
|
WHERE ExpenseClaimGroups.ExpenseClaimGroupId = expenseClaimGroupId;
|
|
|
|
UPDATE ExpenseClaims
|
|
SET ClaimingPersonId = createdByPersonId,
|
|
OrganizationId = organizationId
|
|
WHERE ExpenseClaims.ExpenseClaimGroupId = expenseClaimGroupId;
|
|
|
|
END
|
|
|
|
#
|
|
|
|
CREATE PROCEDURE `SetExpenseClaimGroup` (
|
|
IN expenseClaimId INT,
|
|
IN expenseClaimGroupId INT
|
|
)
|
|
BEGIN
|
|
UPDATE ExpenseClaims
|
|
SET ExpenseClaimGroupId=expenseClaimGroupId
|
|
WHERE ExpenseClaims.ExpenseClaimId=expenseClaimId;
|
|
END
|
|
|
|
|