FrontAccounting forum — Customer Picture image in sales page

Re: Customer Picture image in sales page

2013-02-15T08:48:53Z

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

2013-02-15T08:45:36Z

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

2013-02-15T08:23:15Z

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

2013-02-15T08:20:26Z

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

2013-02-15T03:28:14Z

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

Re: Customer Picture image in sales page

2013-02-15T03:16:50Z

Where are we storing Customer's pictures?

Customer Picture image in sales page

2013-02-14T10:50:44Z

Hi,

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

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