[Koha-bugs] [Bug 15272] aqbookseller addresses are combined into "physical address" field

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15272

Martin Renvoize <martin.renvoize at ptfs-europe.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #100877|0                           |1
        is obsolete|                            |

--- Comment #11 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
Created attachment 102351
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=102351&action=edit
Bug 15272: Merge aqbooksellers addressX columns

The physical address of a vendor is stored in 4 different DB columns:
address1, address2, address3 and address4
The are concatenated and split for storage/display purpose.

If you enter an address on more than 4 lines, the other lines are
truncated: data loss

To avoid such weird behavior, we could simplify the code and get more
flexibility (like address as long as you wish) merging those 4 columns
into 1, address

Test plan:
0. Do not apply the patches
1. Create a vendor and enter more than 4 lines in the physical address,
save
=> Notice that the lines has been stored in the 4 columns, and that you
lost the end of the address
2. Apply the patches and execute the updatedatabase script
3. Edit the vendor's address
=> Notice that the address is displayed correctly
4. Add more lines, save
=> Notice that the extra lines are kept
5. Generate a ACQCLAIM or ACQORDER notice for this vendor
=> Confirm that the address is displayed correctly in the generated
notice

Signed-off-by: Martin Renvoize <martin.renvoize at ptfs-europe.com>

-- 
You are receiving this mail because:
You are watching all bug changes.