This topic is locked

Print search field values in a report

1/29/2019 5:21:13 AM
PHPRunner General questions
A
armin.hujic author

Hi,
I was using PHPRunner 9.6 and recently I moved to PHPRunner 10.
In my project, I was printing dates fields values in reports (Advanced and basic search).

I was using Advanced search for choosing BETWEEN 2 dates and Basic search for only 1 date.
In PHPRunner 10 I have problems with old code because nothing is working properly.
I need help from you guys because I am not a programmer and reason I bought PHPRunner because I could make a very nice project without programming knowledge.
I was using the next code in code snippet, Editor Page, for the printing search field values,
global $strTableName;

if (isset($_SESSION[$strTableName.'_advsearch']))

{

$searchClauseObj = unserialize($_SESSION[$strTableName.'_advsearch']);

}
$fieldSearchData = $searchClauseObj->_where[$strTableName."_srchFields"];
for($i=0; $i<count($fieldSearchData); $i++){

$fName = $fieldSearchData[$i]['fName'];

$val1 = $fieldSearchData[$i]['value1'];

$val2 = $fieldSearchData[$i]['value2'];

$srchCat = $fieldSearchData[$i]['opt'];

$srchNot = $fieldSearchData[$i]['not'];
if ($fName=="Date" && !empty($val1) && !empty($val2))

{

echo ("Report from: "."$val1"."&nbsp"."to: "."$val2");

}
else

if ($fName=="Date" && !empty($val1) && empty($val2))
echo ("Report for: "."$val1");

}

Hope someone will help me or point me in the right direction.
Regards,

Armin