2. PHPRunner General questions
  3. List Page Filtering
This topic is locked

List Page Filtering

 		9/23/2010 3:13:12 AM
PHPRunner General questions
R
 Ricky001 author

Hi All
I have a list page with ten fields, what i would like to do is place a small image on the page which I can do then on clicking the image this would filter the page lets same by customer name field where begins with A or completed field where = "completed"
I would like to put a number of images around 8 each with diffrent filter options
please could anyone give my an example of code i could use and where to put it, i think it maybe a php snip but not sure
Many thanks
Ricky
A
 		ann 9/23/2010

Ricky,
use Add PHP code snippet option on the Visual Editor tab.

Here is a sample code:

echo "<a href='TableName_list.php?a=integrated&ctlSearchFor=&simpleSrchFieldsComboOpt=&simpleSrchTypeComboNot=&simpleSrchTypeComboOpt=&

criteria=and&type1=&value11=completed&field1=FieldName&option1=Equals&not1='><img src='images/Picture.gif'></a>";
R
 		Ricky001 author 9/24/2010



Ricky,
use Add PHP code snippet option on the Visual Editor tab.

Here is a sample code:

echo "<a href='TableName_list.php?a=integrated&ctlSearchFor=&simpleSrchFieldsComboOpt=&simpleSrchTypeComboNot=&simpleSrchTypeComboOpt=&

criteria=and&type1=&value11=completed&field1=FieldName&option1=Equals&not1='><img src='images/Picture.gif'></a>";



May thanks for you help, please could you break the could down so I understand the parts.
TABLE NAME = Quotations

FIELD NAMES =

Invoicedate = Date Format 10/10/2010 example

PartnerDirect = Text

Value = currency field

WonLost = Text ( Yes No pending )

InvoiceSent = Date Format 10/10/2010 example

PayemtDue = Date Format 10/10/2010 example

JobCompleted = Text
If possiable please could you highlet in your example code the areas i need to change the code so i can understand how it works Example list say i woul like to show only when filed JobCompleted = Completed or if possable when Paymentdue is greater then todays date IE NOW()
if have change the to the following with is diaplay the image and i can click on it but no date is fillter
echo "<a href='Quotations_list.php?a=integrated&ctlSearchFor=&simpleSrchFieldsComboOpt=&simpleSrchTypeComboNot=&simpleSrchTypeComboOpt=&criteria=and&type1=&value11=Completed&field1=JobCompleted&option1=Equals&not1='><img src='images/icon_view_new.gif'></a>";
Alos I have noticed that a purple box is placed around my image, this would be great if i could lose this and kust display the image
Many thanks for taking the time to help me
Kind regards
Ricky
A
 		ann 9/28/2010

Ricky,
the code looks correct.
It's difficult to tell you what's happening without seeing actual files.

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error. 'Demo Account' button can be found on the last screen in the program.
R
 		Ricky001 author 9/28/2010



Ricky,
the code looks correct.
It's difficult to tell you what's happening without seeing actual files.

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error. 'Demo Account' button can be found on the last screen in the program.


Thank you for your reply I have found that i did not have search turned on in the page options all works, do you no if i can get rid of the colured box placed around the image and also how would i change the code to just text.
Regards
Ricky
A
 		ann 9/29/2010

Ricky,
could you clarify what image and what code do you mean (maybe a screenshot or two can help).