Re: [WebERP-developers] Doubts with labels and label printing

[Pak R. <pak...@gm...>]

Thanks all for your comments:

I just commited Labels.php and PDFPrintLabel.php with several fixes. Now it
works. To be able to center, or right justify fields we should add a new
table field (lenght) for every label field. Not done yet.

The problem I face now, is I should create the PDF at 200 dpi, as the
labels we want to use are really small and 72 dpi produce a barcode way too
long. Label printer is 200 dpi so, I should use its full resolution. Any
way to improve the resolution of the PDF file?

Thanks in advance.

Regards,
Ricard

2015-09-22 4:00 GMT+08:00 Tim <tim...@bl...>:

> I don't think this or all the other emails were meant for me you have the
> wrong email address, please remove me from this list.
>
> Thank you
>
> Tim
>
> -----Original Message-----
> From: Phil Daintree [mailto:ph...@lo...]
> Sent: 21 September 2015 20:54
> To: webERP Developers
> Subject: Re: [WebERP-developers] Doubts with labels and label printing
>
> Sorry it has been a long tim since that script and I can't recall off the
> top of my head about the units used. I know the script was written long
> after we ditched R & Os library pretty sure it was written using TCPDF but
> no other library. I can't have done such a good job on this script sorry.
>
> Phil
> Phil Daintree
> +64 (0)275 567 890
>
> > On 21/09/2015, at 11:44 pm, Pak Ricard <pak...@gm...> wrote:
> >
> > Hi Phil:
> >
> > I'm trying to make Labels.php and PDFPrintLabels.php work and I'm facing
> some issues.
> >
> > 1) Units in PDF points or mm?
> > The title of the script states that all measurements are in PDF points,
> but line 11 onwards are meausrements in mm (A4 is 297 x 210 mm, as
> example).
> > In PDFPrintLabels.php line 134 SELECT statement seems to transform DB
> fields in mm to PDF points
> > In PDFPrintLabels.php line 164 and 165 seems to transform from mm to PDF
> points
> > So not sure if page and label measurements must be done (and stored in
> DB)
> in mm or in PDF points. Looks like it's in mm, but title text and comments
> state differently.
> >
> > 2) Can't delete a field
> > Also, in Labels.php, trying to delete a field shows an error:
> > Not Acceptable!
> > An appropriate representation of the requested resource could not be
> found
> on this server. This error was generated by Mod_Security.
> > It's the first time I get this error message, so no clue what it meant.
> Are you using any specific library?
> >
> > 3) Problem positioning items
> > I am creating a label with Code, price and barcode. It seems like the
> first field is properly positioned (stockid) but not price. Any combination
> tried does not position it correctly. Not sure what's wrong. I want Code
> and
> Price on the left half (code in top of the price) and barcode on the right
> half. There is no way to position price below stockid.
> >
> > Here is the definition of label I'm using and the desired position of
> fields (I supposed right measurements are in mm)
> >
> > INSERT INTO `labels` (`labelid`, `description`, `pagewidth`,
> `pageheight`,
> `height`, `width`, `topmargin`, `leftmargin`, `rowheight`, `columnwidth`)
> VALUES
> > (2, 'Zetags T-570', 86.2, 10.2, 10, 86, 0.01, 0.01, 10.1, 86.1);
> >
> > INSERT INTO `labelfields` (`labelfieldid`, `labelid`, `fieldvalue`,
> `vpos`, `hpos`, `fontsize`, `barcode`) VALUES
> > (4, 2, 'itemcode', 7, 1, 4, 0),
> > (5, 2, 'price', 2, 1, 4, 0),
> > (6, 2, 'barcode', 1, 43, 20, 1);
> >
> >
> > Would be really appreciated if you could check it out. Thanks!
> >
> >
> > Regards,
> > Ricard
> >
>
> ----------------------------------------------------------------------------
> --
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
> ----------------------------------------------------------------------------
> --
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2015.0.6140 / Virus Database: 4419/10677 - Release Date: 09/21/15
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>