Guriddo » Topic: Access row data for custom formatter

Access row data for custom formatter

Guriddo
Access row data for custom formatter

This topic has 2 replies, 2 voices, and was last updated 9 years, 6 months ago by niyunyun.

Creator

Topic

July 9, 2015 at 5:27 pm #124029

niyunyun

Participant

Hi,

I am trying to use the cell value from other columns in the same row when I format one particular column in the grid. I could not get it to work. I have posted the relevant part of the code below.

//set column models:
$model = array(
array("name"=>"uid","width"=>40, "editable"=>false),
array("name"=>"chr","width"=>40, "editable"=>false),
array("name"=>"pos","width"=>80, "editable"=>false, "formatter"=>"js:igv_link"),
array("name"=>"cosmicID","width"=>80, "editable"=>false, "formatter"=>"js:cosmic_link", "unformat"=>"js:unformat_cosmic"),
array("name"=>"cosmicLookup","width"=>30, "editable"=>false),
array("name"=>"ref","width"=>30, "editable"=>false),
array("name"=>"alt","width"=>30, "editable"=>false),
array("name"=>"genotype","width"=>60, "editable"=>false),
array("name"=>"depth","width"=>30, "editable"=>false),
array("name"=>"altCount","width"=>30, "editable"=>false),
array("name"=>"frequency","width"=>60, "editable"=>false),
array("name"=>"report_no", "width"=>30, "editable"=>false),
array("name"=>"barcode","width"=>30, "editable"=>false),
array("name"=>"cDNA","width"=>60, "editable"=>false),
array("name"=>"protein","width"=>100, "editable"=>false),
array("name"=>"coding","width"=>100, "editable"=>false),
array("name"=>"gene","width"=>60, "editable"=>false),
array("name"=>"dbsnp","width"=>60, "editable"=>false, "formatter"=>"js:dbSNP_link", "unformat"=>"js:unformat_dbSNP"),
array("name"=>"dbSNP_property","width"=>60, "editable"=>false),
array("name"=>"lastName","width"=>30, "editable"=>false),
array("name"=>"firstName","width"=>30, "editable"=>false),
array("name"=>"occurance_count","width"=>30, "editable"=>false),
array("name"=>"pathology_no","width"=>30, "editable"=>false),
array("name"=>"order_no","width"=>30, "editable"=>false));
$grid->setColModel($model);

//custom formatter
$custom = <<<CUSTOM
//This function works which only needs value for the column being formatted
function cosmic_link(cellValue) {
return "<a href='http://cancer.sanger.ac.uk/cosmic/search?q="+cellValue+"'>"+cellValue+"</a>";
}
function unformat_cosmic(cellValue, options, cell)
{
return $(cell).text();
}
//This function does not work
//the report_no variable shows up to be "undefined"
function igv_link(cellValue,rowData) {
var report_no = rowData.report_no;
var url = "http://www.broadinstitute.org/igv/projects/current/igv.php?sessionURL="+report_no+"&locus=locu";
return "<a href="+url+">"+cellValue+"</a>";
}
CUSTOM;
$grid->setJSCode($custom);

//set column models:

$model = array(

array("name"=>"uid","width"=>40, "editable"=>false),

array("name"=>"chr","width"=>40, "editable"=>false),

array("name"=>"pos","width"=>80, "editable"=>false, "formatter"=>"js:igv_link"),

array("name"=>"cosmicID","width"=>80, "editable"=>false, "formatter"=>"js:cosmic_link", "unformat"=>"js:unformat_cosmic"),

array("name"=>"cosmicLookup","width"=>30, "editable"=>false),

array("name"=>"ref","width"=>30, "editable"=>false),

array("name"=>"alt","width"=>30, "editable"=>false),

array("name"=>"genotype","width"=>60, "editable"=>false),

array("name"=>"depth","width"=>30, "editable"=>false),

array("name"=>"altCount","width"=>30, "editable"=>false),

array("name"=>"frequency","width"=>60, "editable"=>false),

array("name"=>"report_no", "width"=>30, "editable"=>false),

array("name"=>"barcode","width"=>30, "editable"=>false),

array("name"=>"cDNA","width"=>60, "editable"=>false),

array("name"=>"protein","width"=>100, "editable"=>false),

array("name"=>"coding","width"=>100, "editable"=>false),

array("name"=>"gene","width"=>60, "editable"=>false),

array("name"=>"dbsnp","width"=>60, "editable"=>false, "formatter"=>"js:dbSNP_link", "unformat"=>"js:unformat_dbSNP"),

array("name"=>"dbSNP_property","width"=>60, "editable"=>false),

array("name"=>"lastName","width"=>30, "editable"=>false),

array("name"=>"firstName","width"=>30, "editable"=>false),

array("name"=>"occurance_count","width"=>30, "editable"=>false),

array("name"=>"pathology_no","width"=>30, "editable"=>false),

array("name"=>"order_no","width"=>30, "editable"=>false));

$grid->setColModel($model);

//custom formatter

$custom = <<<CUSTOM

//This function works which only needs value for the column being formatted

function cosmic_link(cellValue) {

return "<a href='http://cancer.sanger.ac.uk/cosmic/search?q="+cellValue+"'>"+cellValue+"</a>";

}

function unformat_cosmic(cellValue, options, cell)

{

return $(cell).text();

}

//This function does not work

//the report_no variable shows up to be "undefined"

function igv_link(cellValue,rowData) {

var report_no = rowData.report_no;

var url = "http://www.broadinstitute.org/igv/projects/current/igv.php?sessionURL="+report_no+"&locus=locu";

return "<a href="+url+">"+cellValue+"</a>";

}

CUSTOM;

$grid->setJSCode($custom);

Creator

Topic

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies
July 10, 2015 at 8:40 am #124031
guriddo.support
Participant
Hello,

Suppose you mean the <span class=”crayon-e”>igv_link</span> formatter function.

In your colModel I do not see report_no field which you access with rowData.report_no

Maybe this is another field like order_no or pathology_no which are present in your colModel.

Regards,

Will
- This reply was modified 9 years, 6 months ago by guriddo.support.
Guriddo Support Team
July 10, 2015 at 3:29 pm #124034

niyunyun
Participant

Hi Will,

Line14 is the definition for report_no.
Author

Replies