newpersonHey I saw this post so the idea came to me that I could use this on my grid to point to interesting data.
Everything was going good until I wanted to use data inside my cells.
My question is: I want to use data inside my cell to put on the link, is the showlink restricted to id fields only, it seems to be hard coded and there isn't an option to specify anything regarding posting cell values. Would I need a custom formatter to do this?
I was able to get the basic example to work but it's using the id not other cell values
-> http://ubuntu/openaudit/system…..ew=summary
{name:'computer',index:'system_uuid', width:85, formatter:'showlink', formatoptions:{baseLinkUrl:'http://ubuntu/openaudit/system.php', addParam: '&view=summary', idName:'pc'}},
newpersonAndrea you are doing it wrong. Let me see if I can help.
newperson$searchOn = Strip($_REQUEST['_search']);
there is a function called Strip that will remove slashes from the user typed text
foreach( $sarr as $k=>$v) {
more or less this is pretty much saying for every value that the user entered in *note that the $v is data that comes out of your Strip function which as I mentioned it removes slashes from the user typed fields.
$wh .= ” AND “.$k.” LIKE '”.$v.”%'”;
If you noticed, your MYSQL syntax has .$wh at the end of it….and it needs this for searching basically this constructs a where clause that gives appends AND id, invdate,name,note plus a LIKE statement and since id,invdate,name,note are integer,text fields you are able to use the LIKE operator as opposed to float values such as amount, tax,total that is why you don't see the LIKE operator in
newpersonCheck this out http://www.trirand.net/demophp.aspx, this is extremely simple to follow and it differs greatly from what you are using. It is still in Beta but they are doing some good things with it.
newpersonari:
my example does have limitations, if you find a solution to yours can you share your code? Thanks!
newpersonI figured this problem out after closing my eyes and thinking real hard for 3 minutes. I am not sure anyone else will need this information but I am going to share it just in case
php
$responce->rows[$i]['id']=$row[computer_name].$row[record];
the db column computer_name exists in other tables in my db design and this column isn't unique on this particular table so I needed to use an autoincrementing column in this case record and concatenate it to the computer_name becoming one string, thus becoming a unique number!
javascript
newpersonAny ideas?
newpersonThis post has been made many times and with a little forum searching you could find answer.
your js file.js
…
colModel: [
…
{ name: 'Items', index: 'item_count', width: 80, align: “center”, searchoptions: { sopt: ['eq', 'ne', 'lt', 'le', 'gt', 'ge'] }, formatter: highlight },
…
newpersontony said:
Hello,
Could you please explain more simple?
Regards
Tony
I figured I was going offtopic so I decided to create a new more descriptive post: http://www.trirand.com/blog/?p…..d-scenario
I no longer need help with this, I was able to figure it out and I documneted it on that link.
newpersonI think what you are asking is a sample editurl php script so that fields you enter in editable fields are saved onto the database.
Good news is that it is simple and I also downloaded the demos you did and noticed that there is no php code to do this for you in the examples so I will give you what I made up, and you can adjust as necessary. I am new to php so what I created is by no means secure so I wouldn't recommend using it in a production/public environment in other words use at own risk.
editurl: 'someurl.php',
<?php
include(“dbconfig.php”);
//This contains the unique record to update
newpersonWould you know how can I create a function onSelectRow to instead of using the id to use another column?
newpersonmarkw65 said:
The problem I am having is that when my #masterGrid loads and there are several none unique id fields within that first 30 loaded rows and I click on any row whose id appears more than once in that list of 30 it highlights all the rows with the id I highlighted instead of showing Master Detail information for that id like Safari/FF would
There's your answer. Ids are required to be unique. If they're not, the grid will misbehave in strange ways. This particular thing may appear to “work” in FF, but lots of other things will fail.
Mark
You were right, I just changed my PHP code around so that there are distinct values passed and the browser is working correctly. So now that I narrowed the issue down to me needing to fix my php code to accomodate my needs I can now move forward.Me being a newbie I had to think outside the box to try and narrow down the issue, I was looking at it wrong and thought that the problem was with the javascript code.
Thank you very much
newpersonI don't mean to hijack this thread but I am having a similar weird behavior. My problem is only showing up in IE6-IE8, Firefox, Safari don't have this problem. The problem I am having is that when my #masterGrid loads and there are several none unique id fields within that first 30 loaded rows and I click on any row whose id appears more than once in that list of 30 it highlights all the rows with the id I highlighted instead of showing Master Detail information for that id like Safari/FF would.
I do not have this behavior on a public site yet but I have posted screen shots, I will work on creating a public link.
rowNum:30,
onSelectRow: function(ids) {
newpersonFigured out how to change the color on the cell, anyone know how to do it on the entire row?
…
newpersonWhy not attack this problem at the source?
or create separate grids or even subgrids?
When I say source why not convert all of the data in the database to one format, there are ways to do this automatically any time the table is updated.
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top