FrontAccounting forum — Customer Picture image in sales page

Re: Customer Picture image in sales page

null@example.com (shive9jai) — Fri, 15 Feb 2013 08:48:53 +0000

i am not as good as you are thinking.
if possible then can you pls provide me exact codes and where i need to fit them......

thanks........

Re: Customer Picture image in sales page

null@example.com (apmuthu) — Fri, 15 Feb 2013 08:45:36 +0000

You will need to show it in a popup window when an invoice is being created or editied or viewed. So code a separate php page to show it and pass it a variables like debtor_id, company#, logged_in_user, logged_in_token, etc. - check if the said user is logged in and the token matches and then pop up the window.

Re: Customer Picture image in sales page

null@example.com (shive9jai) — Fri, 15 Feb 2013 08:23:15 +0000

Ok i understand but tell me how to display this pic in direct invoice page
which code and where to insert

Re: Customer Picture image in sales page

null@example.com (apmuthu) — Fri, 15 Feb 2013 08:20:26 +0000

Better still, create a new table called, say, customer_images and link it on a 1 : N relationship with the debtors_master table and have a timestamp field in the new table as the date of last update and use the latest photo in it to display in the invoice form. Possibly have and show a signature field as well to have their scanned signatures for verification.

debtor_id INT AUTOINCREMENT NOT NULL PRIMARY KEY
lupdate DATETIME
Picture BLOB
PictureType enum ('Photo', 'Signature')
IsDeleted TINYINT DEFAULT 0

This way, when there is an FA Upgrade, your table will not be affected.

Re: Customer Picture image in sales page

null@example.com (shive9jai) — Fri, 15 Feb 2013 03:28:14 +0000

We can create a new blob column under 0_debtors_master table to store images.....

Re: Customer Picture image in sales page

null@example.com (apmuthu) — Fri, 15 Feb 2013 03:16:50 +0000

Where are we storing Customer's pictures?

Customer Picture image in sales page

null@example.com (shive9jai) — Thu, 14 Feb 2013 10:50:44 +0000

Hi,

I want to display customer picture on the direct invoice page.

Pls help me how to do that...........