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()