Print Product Specification or CofA - Printable Version +- webERP Forum (http://www.weberp.org/forum) +-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1) +--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8) +--- Thread: Print Product Specification or CofA (/showthread.php?tid=9261) |
Print Product Specification or CofA - srdjanm - 06-30-2022 I was experimenting with Quality Assurance module and it was working as expected. After editing some of existing product specification, the printing product spec or printing CofA stop working for all the products, not just for one that I changed. It will generate pdf with a header and footer with no data. But it will draw the one line per method group. html reports are not effected, only pdf generator. I analyzed db table, compared to older one that has a good data and can't find the culprit, very strange. I also created test env. with good and bad db, on the same webERP source and it is behave the same, good db produces expected output, and bad db does not. How I should trace this problem, any ideas? Thank you Srdjan RE: Print Product Specification or CofA - srdjanm - 10-28-2022 I'm still trying to make this work. With latest version 4.15.2 and totally new company, fresh database or demo company data I get same results, the pdf file of Product Specification or Certificate of Analysis has no specification or the test data, the pdf is empty, just header and footer. I attached the screenshot of Product Specification and pdf file of the same. Does anyone experience the same problem? RE: Print Product Specification or CofA - TurboPT - 11-06-2022 Apologies on the delay, I was out of the country last week... Product specification is an area that I've never used; however, I was able to create a spec, and it appears in the PDF when viewed. The PDF content is dynamically output for the PDFProdSpec, so there is no xml file involved. Are there any clues in the server error log? (errors/notices) What file(s) were modified? The PDFProdSpec.php file has not changed in 5 years. Something that may help while working with the files, have the server error log tailing in a separate terminal: Code: $ tail -F apache/logs/error.log RE: Print Product Specification or CofA - srdjanm - 11-28-2022 Thank you for reply! There is nothing in the web server log. No php file was modified. What version of php do you use? I have php 7.4.10 on production server and 7.4.3 on dev server RE: Print Product Specification or CofA - srdjanm - 11-30-2022 Problem solved. In "QA Tests Maintenance" screen (file QATests.php) , the Group by is a text box, free text. In Print Product Spec, file PDFProdSpec.php, there is hard coded values for groupby column (mysql table qatests), array variable SectionsArray. line 129 The hard coded value is PhysicalProperty!!! Thus if one by luck enter PhysicalProperty in "QA Tests Maintenance", Group By box, then Print Product Spec or Certificate of Analysis will work. Comment: In "QA Tests Maintenance" the Group by should be a text box, free text, so one can group by: Physical Property, Chemical Property, Organoleptic ect. Fix should be done in PDFProdSpec.php file. I'll try to implement the fix RE: Print Product Specification or CofA - TurboPT - 12-02-2022 To PHP, I either have 7.3.x or 7.4.x, I'm not 100% sure which, but definitely not yet on version 8+. |