Output document (2 columns and how to hide elements with empty variables?)

Reply

Output document (2 columns and how to hide elements with empty variables?)#812388

By stevensi1018 - Fri Dec 01, 2017 3:25 pm

- Fri Dec 01, 2017 3:25 pm #812388

Hi,

1) we're trying to generate an output document for a very long summary dynaform (that contains 10 smaller forms). We need to visualize the data (variables) in 2 columns (about 5 forms for each) but I don,t understand why it won't display in my generated document.
I added <div style="float:left; width:50%;" and it works great in the document editor but when I generate it, it's still in one column (5 pages so it's too long). Any easy way to do this ?

2) Also, there is about 100 variable fields. I'm trying to hide or put N/A or just hiding the variable when it's empty. Any way to do that programmatically? I don't want to set another variable for example to append the label + value and put this new variable in my output document.

So far, I have:

Code: Select all

$caseId = @@APPLICATION;
$c = new Cases();
$aCase = $c->LoadCase($caseId, @%INDEX);
$aVars = $aCase['APP_DATA'];
foreach($aVars as $key => $var)
{
	if($var == null || $var == "")
	{
		@@a = 1;
		$baseClass = new BaseCLASS();
		$baseClass->setByName($key, "N/A", "BasePeer::TYPE_PHPNAME");
	}
	else
		@@a = 0;
}

I thought that the function setByName could help since I'm in a foreach with my variable name stocked in $key each iteration. But this doesn't seem to be the right syntax for this function/class since I get a blank Dynaform.

Thanks

Re: Output document (2 columns and how to hide elements with empty variables?)#812390

By amosbatto - Fri Dec 01, 2017 8:00 pm

- Fri Dec 01, 2017 8:00 pm #812390

If you want to create two columns in your Output Document, then DIVs won't work. You can do it with an HTML table like this:

Code: Select all

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<style>
.column {    
    width: 50%;
    valign: top;
}
<style>
</head>
<body>
<table>
<tbody>
<tr>
 <td class="column">
 <p><b>First Name:</b> @#firstName</p>
 <p><b>Last Name:</b> @#lastName</p>
 <p><b>Email Address:</b> @#email</p>
 <p><b>Cell number:</b> @#celNumber</p>
 <p><b>Address:</b><br>@#address</p>
</td>
<td class="column">
 <p><b>Special Needs:</b><br>@#specialNeeds</p>
 <p><b>Comments about Client:</b><br>@#commentsAboutClient</p>
</td>
</tr>
</tbody>
</table>
</body>
</html>

Unfortunately there is no overflow from one column to the next column. I'm not if there is any way to do it with HTML.

Re: Output document (2 columns and how to hide elements with empty variables?)#812400

By stevensi1018 - Mon Dec 04, 2017 9:49 am

- Mon Dec 04, 2017 9:49 am #812400

amosbatto wrote:If you want to create two columns in your Output Document, then DIVs won't work. You can do it with an HTML table like this:

Code: Select all

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<style>
.column {    
    width: 50%;
    valign: top;
}
<style>
</head>
<body>
<table>
<tbody>
<tr>
 <td class="column">
 <p><b>First Name:</b> @#firstName</p>
 <p><b>Last Name:</b> @#lastName</p>
 <p><b>Email Address:</b> @#email</p>
 <p><b>Cell number:</b> @#celNumber</p>
 <p><b>Address:</b><br>@#address</p>
</td>
<td class="column">
 <p><b>Special Needs:</b><br>@#specialNeeds</p>
 <p><b>Comments about Client:</b><br>@#commentsAboutClient</p>
</td>
</tr>
</tbody>
</table>
</body>
</html>

Unfortunately there is no overflow from one column to the next column. I'm not if there is any way to do it with HTML.

Thanks for that , it worked.

Re: Output document (2 columns and how to hide elements with empty variables?)#812406

By amosbatto - Mon Dec 04, 2017 9:03 pm

- Mon Dec 04, 2017 9:03 pm #812406

As for setting the case variables to "N/A", your work won't work very well because the variables are not yet initialized.

You can use this code:

Code: Select all

//get case variables
$caseId = @@APPLICATION;
$c = new Cases();
$aCase = $c->LoadCase($caseId, @%INDEX);
$aCaseVars = $aCase['APP_DATA'];

//get variables for process:
$g = new G();
$g->LoadClass('xmlfield_InputPM');
$aVars = getDynaformsVars(@@PROCESS);

foreach ($aVars as $aVar) {
    $varName = $aVar['sName'];
    if ($aVar['sType'] == 'string' and !isset($aCaseVars[$varName])) {
        $aCaseVars[$varName] = 'N/A';
    }
}

$aCase['APP_DATA'] = $aCaseVars;
$c->updateCase($caseId, $aCase);

You can't set this trigger to fire before an Output Document step because ProcessMaker won't execute it (this seems to be a bug in PM 3.2.1).
Also don't set it to fire after a DynaForm step, because any changes to the case's variables will be overwritten.

Re: Output document (2 columns and how to hide elements with empty variables?)#812411

By amosbatto - Mon Dec 04, 2017 9:54 pm

- Mon Dec 04, 2017 9:54 pm #812411

I played with this a bit more. This trigger code can be used after a DynaForm step:

Code: Select all

$caseId = @@APPLICATION;

//save variables from the DynaForm that just got submitted:
$aRecentVars = array(
    'myVar1' => @=myVar1,
    'myVar2' => @=myVar2
);
PMFSendVariables($caseId, $aRecentVars);

//get case variables
$c = new Cases();
$aCase = $c->LoadCase($caseId, @%INDEX);
$aCaseVars = $aCase['APP_DATA'];

//get variables for process:
$g = new G();
$g->LoadClass('xmlfield_InputPM');
$aVars = getDynaformsVars(@@PROCESS);

foreach ($aVars as $aVar) {
    $varName = $aVar['sName'];
    if ($aVar['sType'] == 'string' and !isset($aCaseVars[$varName])) {
        $aCaseVars[$varName] = 'N/A';
    }
}

PMFSendVariables($caseId, $aCaseVars);

The only problem is if the DynaForm sets a variable, then it still hasn't been saved to the database, so this code will overwrite it, so you have to save the variables from the DynaForm at the start.

Re: Output document (2 columns and how to hide elements with empty variables?)#812427

By stevensi1018 - Tue Dec 05, 2017 11:51 am

- Tue Dec 05, 2017 11:51 am #812427

Thanks again, worked exactly as I wanted it to

Re: Output document (2 columns and how to hide elements with empty variables?)#813515

By amosbatto - Mon Mar 05, 2018 4:09 pm

- Mon Mar 05, 2018 4:09 pm #813515

No, this just sets variables to "N/A" which are blank. A later step generates the output document. I answered your question about how to automatically generate an Output Document with variables in another thread.

Reply

Page 1 of 1
7 posts

Output document (2 columns and how to hide elements with empty variables?)#812388

Re: Output document (2 columns and how to hide elements with empty variables?)#812390

Re: Output document (2 columns and how to hide elements with empty variables?)#812400

Re: Output document (2 columns and how to hide elements with empty variables?)#812406

Re: Output document (2 columns and how to hide elements with empty variables?)#812411

Re: Output document (2 columns and how to hide elements with empty variables?)#812427

Re: Output document (2 columns and how to hide elements with empty variables?)#813515

Make Your Cryptocurrency Exchange Business A Successful One!

What's SAP FICO?

How to optimize your rental software?

Cenforce 100mg - Sildenafil Citrate - Genericcures

About us

Join us on Twitter @processmaker