<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
You can develop own customfnction to get quantity_pending value from
vtiger_inventoryproductrel table.<br>
<br>
<a class="moz-txt-link-freetext" href="https://it-solutions4you.com/manuals/vtiger7/pdfmaker/#custom-functions">https://it-solutions4you.com/manuals/vtiger7/pdfmaker/#custom-functions</a><br>
<br>
<pre class="moz-signature" cols="72">S pozdravom / Best regards / Mit freundlichen Grüßen
Matus SOPKO
IT-Solutions4You s.r.o.
</pre>
<div class="moz-cite-prefix">Dňa 17. 4. 2023 o 9:07 Jorge Eduardo
Olaya Perdomo napísal(a):<br>
</div>
<blockquote type="cite"
cite="mid:CADQ9pxrjRR-S2H=wOrEnWCTDUp8WWpA=HsHAfNw6RATqo5HigA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:#000000">Thank
you<br>
<br>
I understood him that the proposed solution is to update
pdfmaker, with the current version it is not possible to add
more fields as I am trying to do, taking into account that I
am trying to do it directly in the source code.<br>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:#000000"><br>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:#000000"><br>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:#000000"><br>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:#000000"><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">El dom, 16 abr 2023 a la(s)
22:10, Alexander Allen (<a
href="mailto:alexander.allenz@gmail.com"
moz-do-not-send="true" class="moz-txt-link-freetext">alexander.allenz@gmail.com</a>)
escribió:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hola
Jorge. Me refiero a este módulo adicional. Te consulté porque
es mucho más práctico que el template predeterminado de
vtiger. Puede que te sirva
<div><br>
</div>
<div><a
href="https://it-solutions4you.com/manuals/vtiger7/pdfmaker/"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://it-solutions4you.com/manuals/vtiger7/pdfmaker/</a></div>
<div><br>
</div>
<div>Tienen una versión gratuita que considero que puede
servirte. Por eso era mi pregunta si lo habías utilizado <br>
<br>
El domingo, 16 de abril de 2023, Jorge Eduardo Olaya Perdomo
<<a href="mailto:jorgeeolayap@gmail.com" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">jorgeeolayap@gmail.com</a>>
escribió:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)">Thank
you Alexander for answering.<br>
<br>
If I have used it, I fail to see the scope of your
question.<br>
<br>
If I place myself in a profile of a normal user, I
understand how the tool works.<br>
<br>
I am trying to understand the code to be able to add
two fields that are in the vtiger_inventoryproductrel
table which are quantity_pending and quantity_sent and
add them to the quote template<br>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">El dom, 16 abr 2023 a
la(s) 20:54, Alexander Allen (<a
href="mailto:alexander.allenz@gmail.com"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">alexander.allenz@gmail.com</a>)
escribió:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">Have you use Vtiger
PDFMaker from it4you? <br>
<br>
El domingo, 16 de abril de 2023, Jorge Eduardo Olaya
Perdomo <<a href="mailto:jorgeeolayap@gmail.com"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">jorgeeolayap@gmail.com</a>>
escribió:<br>
<blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br
clear="all">
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)">
<p style="margin:0px 0px
1.1em;padding:0px;border:0px;font-stretch:inherit;line-height:inherit;font-family:-apple-system,BlinkMacSystemFont,"Segoe
UI Adjusted","Segoe
UI","Liberation
Sans",sans-serif;font-size:15px;vertical-align:baseline;clear:both;color:rgb(35,38,41)">There
is a module for vtiger that is pdfmaker In
this module you can make templates and
parameterize the combinable fields</p>
<p style="margin:0px 0px
1.1em;padding:0px;border:0px;font-stretch:inherit;line-height:inherit;font-family:-apple-system,BlinkMacSystemFont,"Segoe
UI Adjusted","Segoe
UI","Liberation
Sans",sans-serif;font-size:15px;vertical-align:baseline;clear:both;color:rgb(35,38,41)">I
want to add two more variables to this list of
variables</p>
<p style="margin:0px 0px
1.1em;padding:0px;border:0px;font-stretch:inherit;line-height:inherit;font-family:-apple-system,BlinkMacSystemFont,"Segoe
UI Adjusted","Segoe
UI","Liberation
Sans",sans-serif;font-size:15px;vertical-align:baseline;clear:both;color:rgb(35,38,41)">In
the pdfmaker script there are these lines</p>
<p style="margin:0px 0px
1.1em;padding:0px;border:0px;font-stretch:inherit;line-height:inherit;font-family:-apple-system,BlinkMacSystemFont,"Segoe
UI Adjusted","Segoe
UI","Liberation
Sans",sans-serif;font-size:15px;vertical-align:baseline;clear:both;color:rgb(35,38,41)">$Product_Fields["PRODUCTQUANTITY"]
= vtranslate("LBL_VARIABLE_QUANTITY",
"PDFMaker");
$Product_Fields["PRODUCTUSAGEUNIT"] =
vtranslate("LBL_VARIABLE_USAGEUNIT",
"PDFMaker");
$Product_Fields["PRODUCTLISTPRICE"] =
vtranslate("LBL_VARIABLE_LISTPRICE",
"PDFMaker"); $Product_Fields["PRODUCTTOTAL"] =
vtranslate("LBL_PRODUCT_TOTAL", "PDFMaker");
$Product_Fields["PRODUCTDISCOUNT"] =
vtranslate("LBL_VARIABLE_DISCOUNT",
"PDFMaker");
$Product_Fields["PRODUCTDISCOUNTPERCENT"] =
vtranslate("LBL_VARIABLE_DISCOUNT_PERCENT",
"PDFMaker");
$Product_Fields["PRODUCTSTOTALAFTERDISCOUNT"]
=
vtranslate("LBL_VARIABLE_PRODUCTTOTALAFTERDISCOUNT",
"PDFMaker");
$Product_Fields["PRODUCTVATPERCENT"] =
vtranslate("LBL_PRODUCT_VAT_PERCENT",
"PDFMaker"); $Product_Fields["PRODUCTVATSUM"]
= vtranslate("LBL_PRODUCT_VAT_SUM",
"PDFMaker");
$Product_Fields["PRODUCTTOTALSUM"] =
vtranslate("LBL_PRODUCT_TOTAL_VAT",
"PDFMaker"); $result["SELECT_PRODUCT_FIELD"] =
$Product_Fields;</p>
<p style="margin:0px 0px
1.1em;padding:0px;border:0px;font-stretch:inherit;line-height:inherit;font-family:-apple-system,BlinkMacSystemFont,"Segoe
UI Adjusted","Segoe
UI","Liberation
Sans",sans-serif;font-size:15px;vertical-align:baseline;clear:both;color:rgb(35,38,41)">I
added</p>
<p style="margin:0px 0px
1.1em;padding:0px;border:0px;font-stretch:inherit;line-height:inherit;font-family:-apple-system,BlinkMacSystemFont,"Segoe
UI Adjusted","Segoe
UI","Liberation
Sans",sans-serif;font-size:15px;vertical-align:baseline;clear:both;color:rgb(35,38,41)">$Product_Fields["PRODUCTQUANTITYPENDING"]
= vtranslate("LBL_VARIABLE_QUANTITYPENDING",
"PDFMaker");
$Product_Fields["PRODUCTQUANTITYSEND"] =
vtranslate("LBL_VARIABLE_QUANTITYSEND",
"PDFMaker");</p>
<p style="margin:0px 0px
1.1em;padding:0px;border:0px;font-stretch:inherit;line-height:inherit;font-family:-apple-system,BlinkMacSystemFont,"Segoe
UI Adjusted","Segoe
UI","Liberation
Sans",sans-serif;font-size:15px;vertical-align:baseline;clear:both;color:rgb(35,38,41)">but
in the template it does not match me</p>
<p style="margin:0px 0px
1.1em;padding:0px;border:0px;font-stretch:inherit;line-height:inherit;font-family:-apple-system,BlinkMacSystemFont,"Segoe
UI Adjusted","Segoe
UI","Liberation
Sans",sans-serif;font-size:15px;vertical-align:baseline;clear:both;color:rgb(35,38,41)">How
do I get it to combine?</p>
</div>
<div class="gmail_default"
style="font-family:georgia,serif;font-size:small;color:rgb(0,0,0)"><br>
</div>
<div>
<div dir="ltr">
<div dir="ltr">
<div
style="font-size:13px;font-family:georgia,serif;color:rgb(51,102,102)">---------------------------------------------------------------</div>
<div
style="font-size:13px;font-family:georgia,serif;color:rgb(51,102,102)"><br>
</div>
<div><font
style="font-family:georgia,serif;font-size:13px"
color="#336666"> Jorge Eduardo Olaya
Perdomo </font><font
style="font-family:georgia,serif;font-size:13px"
color="#336666"><br>
</font><a
href="mailto:jorgeeolayap@gmail.com"
target="_blank" moz-do-not-send="true"><font
face="georgia, serif" color="#336633">jorgeeolayap@</font>gmail.com</a><br>
<font
style="font-family:georgia,serif;font-size:12.8px"
color="#336666"><span
style="font-size:13px">Celular:
3223426320</span><br>
</font><span
style="font-family:georgia,serif;font-size:12.8px"><font
color="#336666">Código postal: 730005</font></span></div>
</div>
</div>
</div>
</div>
</blockquote>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">http://www.vtiger.com/</a></blockquote>
</div>
</blockquote>
</div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">http://www.vtiger.com/</a></blockquote>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</body>
</html>