d1635f562869287f9286d116e97e0f69874db5f8,modules/templates/RLPPTM/vouchers.py,VoucherCardLayout,lookup,#Any#Any#Any#,53

Before Change

        subject_name = "VoucherInstructions"
        query = (ctable.name == subject_name) & \
                (ctable.deleted == False)
        row = db(query).select(ctable.body,
                               join = join,
                               limitby = (0, 1),
                               ).first()
        instructions = row.body if row else None

        return {"logos": logos,
                "root_org_names": root_org_names,

After Change

            root_org_names = None

        // Get voucher instructions from programs
        program_ids = set(item["_row"]["fin_voucher.program_id"] for item in items)
        program_ids.discard(None)
        ptable = s3db.fin_voucher_program
        query = (ptable.id.belongs(program_ids)) & \
                (ptable.voucher_instructions != None) & \
                (ptable.deleted == False)
        programs = db(query).select(ptable.id,
                                    ptable.voucher_instructions,
                                    )
        instructions = {p.id: p.voucher_instructions for p in programs}

        return {"logos": logos,
                "root_org_names": root_org_names,

Instances