Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Advise to add Picture in Quotation
02-17-2012, 02:41 PM
Post: #1
Advise to add Picture in Quotation
Hi all,

I would like to add pictures to the quotation (see picture attached), because sometimes the customers would like to see how the item looks like.

Can I have some advise in big picture what I should do, what scripts would I look at and things in the Database, etc I need to be aware if affecting other stuff?

The picture is taken from the product image and should be automatically reduced in size to a thumbnail...

Thanks in advance...


Attached File(s) Thumbnail(s)
   

Thomas Timothy Lie
Bali Open Source Solution, Indonesia
[url=http://www.baliboss.com]http://www.baliboss.com[/url]
Find all posts by this user
Quote this message in a reply
03-14-2012, 07:30 PM (This post was last modified: 03-14-2012 07:31 PM by thomas_lie.)
Post: #2
RE: Advise to add Picture in Quotation
Hi all,

replying to my own post, I managed to get Pictures inside the Quotation.
In case anyone finds it useful, I attach the files of the modification. I don't know if it's worth to be part of the release Smile

So additional features in Quotation are:
1) Picture (similar mechanism as Item Details so pictures will show up for items that already have .jpg file in the image directory)
2) Sales Person (in the company we're setting up, the sales person is needed in case the customer would like to call back they know who to talk to)
3) Location (I change the address & contact details, not to the headquarter in the company preferences, instead I use the outlet location that the customer is attached to... because in our case when the customer wants to come and see the products, they can come to the outlet location that the quotation is made from)
4) Units of Measure (UOM after Quantity)
5) I also shift the most right column of Total a bit to the right, because when I enter hundreds of millions (possible in Indonesian currency), the number overwrites the Tax Amount on the left.

I used from the stable version and my changes are marked by the text "tlie"

Attached are:
1) PDFQuotation.php
2) includes/PDFQuotationPageHeader.inc (delete the txt extension as .inc was not allowed to attach)
3) also the image of sample quotation with circles where changes are made.

Feel free to use it, or test it.... so to make sure what I change is bug-free.....

thanks to the whole webERP community, I love this program & really appreciate for it Smile

PS: Phil, please move this thread to the Development Discussion & Specification. I think I put it in Feature Request, wrong thread I guess Smile


regards,
Thomas


Attached File(s) Thumbnail(s)
   

.php  PDFQuotation.php (Size: 10.92 KB / Downloads: 10)
.txt  PDFQuotationPageHeader.inc.txt (Size: 7.14 KB / Downloads: 10)

Thomas Timothy Lie
Bali Open Source Solution, Indonesia
[url=http://www.baliboss.com]http://www.baliboss.com[/url]
Find all posts by this user
Quote this message in a reply
03-15-2012, 10:26 AM
Post: #3
RE: Advise to add Picture in Quotation
Hi, Thomas,

Thank you for your sharing and your contribute to webERP community!

I'm not sure if it's a special requirements or a general one. If enough users like this feature, I believe it should be added to the trunk.

Thank you very much!

Exson
Find all posts by this user
Quote this message in a reply
03-15-2012, 10:55 AM
Post: #4
RE: Advise to add Picture in Quotation
(03-15-2012 10:26 AM)Exsonqu_Qu Wrote:  Hi, Thomas,

Thank you for your sharing and your contribute to webERP community!

I'm not sure if it's a special requirements or a general one. If enough users like this feature, I believe it should be added to the trunk.

Thank you very much!

Exson

I do think it's a general improvement, so my vote is to move it to the trunk version. Nice to have the pic of the item and also it make sense (at least to us) the other modifications

Regards,
Pak Ricard
Find all posts by this user
Quote this message in a reply
03-30-2012, 08:17 PM (This post was last modified: 03-30-2012 08:17 PM by andreasp.)
Post: #5
RE: Advise to add Picture in Quotation
Hi Thomas,

first of all thank you for sharing this with us. It is a great feature, actually the one feature for which I decided to use WebErp at all. I am trying to adjust it, so that the pictures do not show up so small but at least in a size, so that the client can identify the product. However, I get one image on top of the other, images covering some part of other columns, etc. I guess it got something to do with the line-height. Do you have any suggestion on how to be able to have a photo sized at least 200x200 pixels in the quotation, so that it shows up on the PDF 4x4 cm when printed to an A4 sheet?

I tried a lot, but I am stuck. Your help would be highly appreciated and integrating this feature as a standard, I consider to be very important.

Thank you

Andreas
Find all posts by this user
Quote this message in a reply
03-31-2012, 01:54 AM
Post: #6
RE: Advise to add Picture in Quotation
Hi Andreas,

For picture size, you can adjust the picture size line 218 of the previously attached file PDFQuotation.php where the line says

PHP Code:
$pdf->addJpegFromFile($_SESSION['part_pics_dir'] . '/' .$myrow2['stkcode'].'.jpg',145,$YPos-3,0,15); 

When you enlarge the picture size, you need to adjust the spacing of each line order, in the same file, I think line 131:

PHP Code:
$line_height=15


Have a try...


Regards,

Thomas Timothy Lie
Bali Open Source Solution, Indonesia
[url=http://www.baliboss.com]http://www.baliboss.com[/url]
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)