def create_items_both_cps_with_allocs():
"""
Saves all of the line items from both control points
to the DB. Used to setup cross-control point inheritance
tests.
"""
cp = create_cp_1382_12()
item = ControlPointLineItem()
item.id = 1
item.ien = '96224134'
item.fyqseq = '1210001'
item.txn_type = 'CA'
item.description = '1210001:CAN:'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 2
item.ien = '96224118'
item.fyqseq = '1210002'
item.txn_type = 'O'
item.obl_nbr = 'D27012'
item.txn_amt = Decimal('6666')
item.cost = item.txn_amt
item.description = '1210002:OBL:D27012'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 3
item.ien = '96041404'
item.fyqseq = '1210009'
item.txn_type = 'CA'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 4
item.ien = '95958457'
item.fyqseq = '1210011'
item.txn_type = 'O'
item.obl_nbr = 'D25011'
item.obl_date = '2011-10-03'
item.txn_amt = Decimal('560')
item.cost = item.txn_amt
item.unallocated_amt = Decimal(0)
item.description = '1210011:OBL:D25011'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 5
item.ien = '95877740'
item.fyqseq = '1210021'
item.txn_type = 'O'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('12368')
item.cost = item.txn_amt
item.description = '1210021:OBL:D25025'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 6
item.ien = '95876936'
item.fyqseq = '1210029'
item.txn_type = 'A'
item.obl_nbr = 'D25011'
item.obl_date = '2011-10-31'
item.txn_amt = Decimal('-40')
item.description = '1210029:ADJ:D25011'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 7
item.ien = '95873815'
item.fyqseq = '1210033'
item.txn_type = 'A'
item.obl_nbr = 'D25011'
item.obl_date = '2011-11-25'
item.txn_amt = Decimal('-240')
item.description = '1210033:ADJ:D25011'
cp.line_items.add(item)
allocate_D25011_all()
item = ControlPointLineItem()
item.id = 8
item.ien = '95871250'
item.fyqseq = '1210038'
item.txn_type = 'C'
item.obl_nbr = '506FC9276'
item.txn_amt = Decimal('157655')
item.description = '1210038:CEI:506FC9276'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 9
item.ien = '95870938'
item.fyqseq = '1210043'
item.txn_type = 'A'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('-1207')
item.description = '1210043:ADJ:D25025'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 10
item.ien = '95864913'
item.fyqseq = '1220062'
item.txn_type = 'A'
item.obl_nbr = 'QTRADJ'
item.txn_amt = Decimal('50')
item.description = '1220062:ADJ:QTRADJ'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 11
item.ien = '95857527'
item.fyqseq = '1220076'
item.txn_type = 'A'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('7242')
item.description = '1220076:ADJ:D25025'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 12
item.ien = '95817232'
item.fyqseq = '1230155'
item.txn_type = 'A'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('7242')
item.description = '1230155:ADJ:D25025'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 13
item.ien = '95765346'
item.fyqseq = '1230232'
item.txn_type = 'O'
item.obl_nbr = 'R24911'
item.txn_amt = Decimal('364.28')
item.cost = item.txn_amt
item.description = '1230232:OBL:R24911'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 14
item.ien = '95720469'
item.fyqseq = '1240304'
item.txn_type = 'A'
item.obl_nbr = 'B0523F'
item.txn_amt = Decimal('176472')
item.description = '1240304:ADJ:B0523F'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 15
item.ien = '95718275'
item.fyqseq = '1240311'
item.txn_type = 'A'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('-281.99')
item.description = '1240311:ADJ:D25025'
cp.line_items.add(item)
cp.save()
cp = create_cp_1382_13()
item = ControlPointLineItem()
item.id = 16
item.ien = '95434961'
item.fyqseq = '1240637'
item.txn_type = 'A'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('874.86')
item.description = '1240637:ADJ:D25025'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 17
item.ien = '95432617'
item.fyqseq = '1240640'
item.txn_type = 'A'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('-40.00')
item.description = '1240640:ADJ:D25025'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 18
item.ien = '95436544'
item.fyqseq = '1310003'
item.txn_type = 'A'
item.obl_nbr = 'ADJ002'
item.txn_amt = Decimal('-8469.86')
item.description = '1310003:ADJ:ADJ002'
cp.line_items.add(item)
cp.save()
def create_cp_1382_12_items_partial():
"""
Saves to DB part of control point 1382-12.
Simulates state after new FMS items have been
saved and an OBL has been allocated from which
ADJs in a subsequent report will inherit.
"""
cp = create_cp_1382_12()
item = ControlPointLineItem()
item.id = 1
item.ien = '96224134'
item.fyqseq = '1210001'
item.txn_type = 'CA'
item.description = 'None'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 2
item.ien = '96224118'
item.fyqseq = '1210002'
item.txn_type = 'O'
item.obl_nbr = 'D27012'
item.txn_amt = Decimal('6666')
item.unallocated_amt = item.txn_amt
item.cost = item.txn_amt
item.description = 'None'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 3
item.ien = '96041404'
item.fyqseq = '1210009'
item.txn_type = 'CA'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 4
item.ien = '95958457'
item.fyqseq = '1210011'
item.txn_type = 'O'
item.obl_nbr = 'D25011'
item.obl_date = '2011-10-03'
item.txn_amt = Decimal('560')
item.unallocated_amt = item.txn_amt
item.cost = item.txn_amt
item.unallocated_amt = Decimal(0)
item.description = 'Case of the screaming meemies'
cp.line_items.add(item)
allocate_D25011_OBL()
item = ControlPointLineItem()
item.id = 5
item.ien = '95877740'
item.fyqseq = '1210021'
item.txn_type = 'O'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('12368')
item.unallocated_amt = item.txn_amt
item.cost = item.txn_amt
item.description = 'None'
cp.line_items.add(item)
cp.save()
def create_cp_1382_12_items_whole_no_allocs():
"""
Saves all of the line items for control point 1382-12
to the DB. Used to test bequeathing.
"""
cp = create_cp_1382_12()
item = ControlPointLineItem()
item.id = 1
item.ien = '96224134'
item.fyqseq = '1210001'
item.txn_type = 'CA'
item.description = '1210001:CAN:'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 2
item.ien = '96224118'
item.fyqseq = '1210002'
item.txn_type = 'O'
item.obl_nbr = 'D27012'
item.txn_amt = Decimal('6666')
item.cost = item.txn_amt
item.description = '1210002:OBL:D27012'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 3
item.ien = '96041404'
item.fyqseq = '1210009'
item.txn_type = 'CA'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 4
item.ien = '95958457'
item.fyqseq = '1210011'
item.txn_type = 'O'
item.obl_nbr = 'D25011'
item.obl_date = '2011-10-03'
item.txn_amt = Decimal('560')
item.cost = item.txn_amt
item.description = '1210011:OBL:D25011'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 5
item.ien = '95877740'
item.fyqseq = '1210021'
item.txn_type = 'O'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('12368')
item.cost = item.txn_amt
item.description = '1210021:OBL:D25025'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 6
item.ien = '95876936'
item.fyqseq = '1210029'
item.txn_type = 'A'
item.obl_nbr = 'D25011'
item.obl_date = '2011-10-31'
item.txn_amt = Decimal('-40')
item.description = '1210029:ADJ:D25011'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 7
item.ien = '95873815'
item.fyqseq = '1210033'
item.txn_type = 'A'
item.obl_nbr = 'D25011'
item.obl_date = '2011-11-25'
item.txn_amt = Decimal('-240')
item.description = '1210033:ADJ:D25011'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 8
item.ien = '95871250'
item.fyqseq = '1210038'
item.txn_type = 'C'
item.obl_nbr = '506FC9276'
item.txn_amt = Decimal('157655')
item.description = '1210038:CEI:506FC9276'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 9
item.ien = '95870938'
item.fyqseq = '1210043'
item.txn_type = 'A'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('-1207')
item.description = '1210043:ADJ:D25025'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 10
item.ien = '95864913'
item.fyqseq = '1220062'
item.txn_type = 'A'
item.obl_nbr = 'QTRADJ'
item.txn_amt = Decimal('50')
item.description = '1220062:ADJ:QTRADJ'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 11
item.ien = '95857527'
item.fyqseq = '1220076'
item.txn_type = 'A'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('7242')
item.description = '1220076:ADJ:D25025'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 12
item.ien = '95817232'
item.fyqseq = '1230155'
item.txn_type = 'A'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('7242')
item.description = '1230155:ADJ:D25025'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 13
item.ien = '95765346'
item.fyqseq = '1230232'
item.txn_type = 'O'
item.obl_nbr = 'R24911'
item.txn_amt = Decimal('364.28')
item.cost = item.txn_amt
item.description = '1230232:OBL:R24911'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 14
item.ien = '95720469'
item.fyqseq = '1240304'
item.txn_type = 'A'
item.obl_nbr = 'B0523F'
item.txn_amt = Decimal('176472')
item.description = '1240304:ADJ:B0523F'
cp.line_items.add(item)
item = ControlPointLineItem()
item.id = 15
item.ien = '95718275'
item.fyqseq = '1240311'
item.txn_type = 'A'
item.obl_nbr = 'D25025'
item.txn_amt = Decimal('-281.99')
item.description = '1240311:ADJ:D25025'
cp.line_items.add(item)
cp.save()
