i purchase the full version
am trying to change the column cell backgroud color base on date but the column data is in week so i have to convert to date first. the following is not work bcos is not getting the dynamic content of Year and Week.
Note, plist is an array of columns
for($n=0;$n<sizeof($plist);$n++){
$condt = date( "Y-m-d", strtotime('$row["IYEAR"]'."-W".sprintf("%02u", 40)."-1") );
$bg = "white";
if($condt <= date('Y-m-d', strtotime("-1 days"))){$bg = "black";}
elseif( $condt <= date('Y-m-d', strtotime("+30 days"))){$bg = "red";}
elseif($condt <= date('Y-m-d', strtotime("+90 days"))){$bg = "yellow";}
$f = array();
$f["column"] = $plist[$n];
$f["op"] = "!=";
$f["value"] = "0";
$f["cellcss"] = "'background-color':'$bg'";
$f_conditions[] = $f;
}
$g->set_conditional_css($f_conditions);
getting dynamic content into a variable eg $yr = '$row["IYEAR"]' or $yr = '{IYEAR}' is not working in conditional block