From: Tim <tim...@bl...> - 2015-09-21 20:00:24
|
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 |