New user pb - Ghost values in a grig
March 12th, 2010http://extjs.com/forum/D:%5CDeisk%5Cexcelshell6131
Associated code:
SampleGrid.superclass.constructor.call(this, {
store: new Ext.data.Store({
reader: new Ext.data.ArrayReader({}, [
{name: 'op'},
{name: 'w'},
{name: 'pw'},
{name: 'm'},
{name: 'pm'},
{name: 't'},
{name: 'pt'},
{name: 'a'},
{name: 'pa'}
]),
//print_r($percentT);
//print_r($valT);
echo 'data:[';
for ($index = 0; $index <= $b; $index++)
{
if ($index < $b)
{echo '[''.$tab[$index].'','.$val[$index].','.$percent[$index].','.$valM[$index].','.$percentM[$index].','.$valM[$index].','.$percentT[$index].','.$valY[$index].','.$percentY[$index].'],';}
else
{echo '[''.$tab[$index].'','.$val[$index].','.$percent[$index].','.$valM[$index].','.$percentM[$index].','.$valM[$index].','.$percentT[$index].','.$valY[$index].','.$percentY[$index].']';}
}
echo ']';
?>
}),
columns: columns,
autoExpandColumn: 'op',
width:400
});Columns beetween "Trim" are wrong. The value for "Trim" are in "% Trim".
If I suppress the "Trim" values form the echo line, like following :
//print_r($percentT);
//print_r($valT);
echo 'data:[';
for ($index = 0; $index <= $b; $index++)
{
if ($index < $b)
{echo '[''.$tab[$index].'','.$val[$index].','.$percent[$index].','.$valM[$index].','.$percentM[$index]./*','.$valT[$index].*/','.$percentT[$index].','.$valY[$index].','.$percentY[$index].'],';}
else
{echo '[''.$tab[$index].'','.$val[$index].','.$percent[$index].','.$valM[$index].','.$percentM[$index]./*','.$valT[$index].*/','.$percentT[$index].','.$valY[$index].','.$percentY[$index].']';}
}
echo ']';
?>We can see the result here :
6132
Values for "% Trim", "Annee", "% annee" are good.
Only the "Trim" column id wrong, and I don't know where the values comming.
Anybody's have an idea
Thanks for response
Seb
for ($iii =0; $iii <= $b; $iii++)
{
$name = "SELECT * FROM " . $table . " WHERE comID = " . $idx . " and action = ".$tabID[$iii]." and sem=" . $w. " and annee=" . $annee;
$result = mysql_query($name, $gunnebo) or die(mysql_error());
$totalRows_rsca = mysql_num_rows($result);
$var = $totalRows_rsca/$totalRows_totalaction*100;
$var = number_format($var, 0, ',', ' ');
$t = $t + $totalRows_rsca;
array_push($val, $totalRows_rsca);
array_push($percent, $var);
}The var column definition id the following:
var columns = [
{id:'op',header: "Resultat par critere", width: 45, sortable: true, renderer: objectif, dataIndex: 'op'},
{header: "Semaine", width: 50, sortable: false, renderer: objectif, dataIndex: 'w'},
{header: "% Sem.", width: 45, sortable: false, renderer: pctobjectif, dataIndex: 'pw'},
{header: "Mois", width: 75, sortable: false, renderer: objectif, dataIndex: 'm'},
{header: "% Mois", width: 65, sortable: false, renderer: pctobjectif, dataIndex: 'pm'},
{header: "T", width: 75, sortable: false, renderer: objectif, dataIndex: 't'},
{header: "% Trim", width: 45, sortable: false, renderer: pctobjectif, dataIndex: 'pt'},
{header: "Annee", width: 45, sortable: false, renderer: objectif, dataIndex: 'a'},
{header: "% An.", width: 45, sortable: false, renderer: pctobjectif, dataIndex: 'pa'}
];
When I edit the code of the generated page we can see data's :
SampleGrid.superclass.constructor.call(this, {
store: new Ext.data.Store({
reader: new Ext.data.ArrayReader({}, [
{name: 'op'},
{name: 'w'},
{name: 'pw'},
{name: 'm'},
{name: 'pm'},
{name: 't'},
{name: 'pt'},
{name: 'a'},
{name: 'pa'}
]),
data:[['Obtention Commande',1,2,3,5,3,3,5,23,21,9],
['Demande Devis',1,2,3,5,3,3,5,9,8,6],
['Formation Vendeurs',1,2,2,3,5,2,4,4,3,8],
['Equipement Show-room',1,2,3,5,3,3,5,6,5,7],
['Suivi devis Distributeur',1,2,2,3,5,2,4,5,4,8],
['Organisation evennement',1,2,2,3,5,2,4,5,4,8],
['Habillage PLV',0,0,2,3,5,2,4,2,1,9],
['Accompagnement Vendeur',1,2,2,3,5,2,4,2,1,9],
['BIlan Client',1,2,1,1,8,1,2,2,1,9],
['Referencement',1,2,1,1,8,1,2,1,1,0],
['Presentation gamme',9,21,11,19,3,11,19,13,12,4],
['Simple Visite',23,55,24,42,1,24,42,32,30,5],
['Mailing local',1,2,1,1,8,1,2,1,1,0]] }),
columns: columns,
autoExpandColumn: 'op',
width:400
});Numbers of data in each line : 11
The command corresponding to the generation can generate : only 9 data's per line
//print_r($valT);
//print_r($percentT);
echo 'data:[';
for ($index = 0; $index <= $b; $index++)
{
if ($index < $b)
{echo '[''.$tab[$index].'','.$val[$index].','.$percent[$index].','.$valM[$index].','.$percentM[$index].','.$valT[$index].','.$percentT[$index].','.$valY[$index].','.$percentY[$index].'],';}
else
{echo '[''.$tab[$index].'','.$val[$index].','.$percent[$index].','.$valM[$index].','.$percentM[$index].','.$valT[$index].','.$percentT[$index].','.$valY[$index].','.$percentY[$index].']';}
}
echo ']';
?>
Anybody's have an idea
Thanks for response
Seb
for ($iii =0; $iii <= $b; $iii++)
{
$name = "SELECT * FROM " . $table . " WHERE comID = " . $idx . " and action = ".$tabID[$iii]." and sem=" . $w. " and annee=" . $annee;
$result = mysql_query($name, $gunnebo) or die(mysql_error());
$totalRows_rsca = mysql_num_rows($result);
$var = $totalRows_rsca/$totalRows_totalaction*100;
$var = number_format($var, 0, ',', ' ');
$t = $t + $totalRows_rsca;
array_push($val, $totalRows_rsca);
array_push($percent, $var);
}The var column definition id the following:
var columns = [
{id:'op',header: "Resultat par critere", width: 45, sortable: true, renderer: objectif, dataIndex: 'op'},
{header: "Semaine", width: 50, sortable: false, renderer: objectif, dataIndex: 'w'},
{header: "% Sem.", width: 45, sortable: false, renderer: pctobjectif, dataIndex: 'pw'},
{header: "Mois", width: 75, sortable: false, renderer: objectif, dataIndex: 'm'},
{header: "% Mois", width: 65, sortable: false, renderer: pctobjectif, dataIndex: 'pm'},
{header: "T", width: 75, sortable: false, renderer: objectif, dataIndex: 't'},
{header: "% Trim", width: 45, sortable: false, renderer: pctobjectif, dataIndex: 'pt'},
{header: "Annee", width: 45, sortable: false, renderer: objectif, dataIndex: 'a'},
{header: "% An.", width: 45, sortable: false, renderer: pctobjectif, dataIndex: 'pa'}
];
When I edit the code of the generated page we can see data's :
SampleGrid.superclass.constructor.call(this, {
store: new Ext.data.Store({
reader: new Ext.data.ArrayReader({}, [
{name: 'op'},
{name: 'w'},
{name: 'pw'},
{name: 'm'},
{name: 'pm'},
{name: 't'},
{name: 'pt'},
{name: 'a'},
{name: 'pa'}
]),
data:[['Obtention Commande',1,2,3,5,3,3,5,23,21,9],
['Demande Devis',1,2,3,5,3,3,5,9,8,6],
['Formation Vendeurs',1,2,2,3,5,2,4,4,3,8],
['Equipement Show-room',1,2,3,5,3,3,5,6,5,7],
['Suivi devis Distributeur',1,2,2,3,5,2,4,5,4,8],
['Organisation evennement',1,2,2,3,5,2,4,5,4,8],
['Habillage PLV',0,0,2,3,5,2,4,2,1,9],
['Accompagnement Vendeur',1,2,2,3,5,2,4,2,1,9],
['BIlan Client',1,2,1,1,8,1,2,2,1,9],
['Referencement',1,2,1,1,8,1,2,1,1,0],
['Presentation gamme',9,21,11,19,3,11,19,13,12,4],
['Simple Visite',23,55,24,42,1,24,42,32,30,5],
['Mailing local',1,2,1,1,8,1,2,1,1,0]] }),
columns: columns,
autoExpandColumn: 'op',
width:400
});Numbers of data in each line : 11
The command corresponding to the generation can generate : only 9 data's per line
//print_r($valT);
//print_r($percentT);
echo 'data:[';
for ($index = 0; $index <= $b; $index++)
{
if ($index < $b)
{echo '[''.$tab[$index].'','.$val[$index].','.$percent[$index].','.$valM[$index].','.$percentM[$index].','.$valT[$index].','.$percentT[$index].','.$valY[$index].','.$percentY[$index].'],';}
else
{echo '[''.$tab[$index].'','.$val[$index].','.$percent[$index].','.$valM[$index].','.$percentM[$index].','.$valT[$index].','.$percentT[$index].','.$valY[$index].','.$percentY[$index].']';}
}
echo ']';
?>
#If you have any other info about this subject , Please add it free.# |
