Guriddo » Topic: Multi Y Dimension

Multi Y Dimension

Guriddo
Multi Y Dimension
Multi Y Dimension

Tagged: Multi Y Dimension

This topic has 7 replies, 2 voices, and was last updated 8 years, 2 months ago by ariadrianto.

Creator

Topic

November 3, 2017 at 5:23 am #126415

ariadrianto

Participant

Hi…

This code is not working when I want to create multi YDimension … It always appear last column.


$pivot-&gt;setxDimension(array(
array(&quot;dataName&quot;=&gt;&quot;NOCOA&quot;, &quot;width&quot;=&gt;150)
));

// Grid yDimension settings
$pivot-&gt;setyDimension(array(

array(&quot;dataName&quot; =&gt; &quot;TYPES&quot;, &quot;width&quot;=&gt;185),
array(&quot;dataName&quot; =&gt; &quot;BL&quot;)
));

$pivot->setxDimension(array(

array("dataName"=>"NOCOA", "width"=>150)

));

// Grid yDimension settings

$pivot->setyDimension(array(

array("dataName" => "TYPES", "width"=>185),

array("dataName" => "BL")

));

Creator

Topic

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

Author

Replies

November 3, 2017 at 10:51 am #126417

guriddo.support

Participant

We will try to reproduce the proble, but could you please send to us a small working example, which demonstrates the problem.

Also which version of the JavaScript is used?

Kind Regards,

Will

Guriddo Support Team

November 22, 2017 at 8:50 am #126434

ariadrianto

Participant

I’m sorry for my late answer.

https://s18.postimg.org/i6zni33i1/Selection_159.jpg

Here’s my demo : http://multidayacipta.com/demos/hrd/info/pivot.php


....
$pivot = new jqPivotGrid($conn);

$pivot-&gt;SelectCommand =&quot;
SELECT
N.NERACAID,
N.THBL,
N.TIPE,
N.NOCOA,
N.DEBET,
N.KREDIT
FROM NERACA N

&quot;;

$pivot-&gt;setGridOptions(array(
&quot;rowNum&quot;=&gt;999999,
&quot;height&quot;=&gt;200,&quot;width&quot;=&gt;1000,
&quot;sortname&quot; =&gt; &quot;NOCOA&quot;,
&quot;rowList&quot;=&gt;array(10,20,50,10),
&quot;shrinkToFit&quot;=&gt;false,
&quot;caption&quot;=&gt;&quot;Group Nama&quot;,
&quot;groupingView&quot;=&gt;array(&quot;groupCollapse&quot;=&gt;true)
));

$pivot-&gt;setData(&#039;pivot_.php&#039;);
// Grid xDimension settings
$pivot-&gt;setxDimension(array(
array(&quot;dataName&quot;=&gt;&quot;NOCOA&quot;, &quot;width&quot;=&gt;150)
));

// Grid yDimension settings
$pivot-&gt;setyDimension(array(

array(&quot;dataName&quot; =&gt; &quot;THBL&quot;, &quot;width&quot;=&gt;185),
array(&quot;dataName&quot; =&gt; &quot;TIPE&quot;, &quot;width&quot;=&gt;185)
));

// Members
$pivot-&gt;setaggregates(array(
array(
&quot;member&quot;=&gt;&#039;DEBET&#039;,
&quot;aggregator&quot;=&gt;&#039;sum&#039;,
&quot;width&quot;=&gt;&#039;120&#039;,
&quot;label&quot;=&gt;&#039;Debet&#039;,
&quot;formatter&quot;=&gt;&#039;number&#039;,
&quot;align&quot;=&gt;&#039;right&#039;,
// the summary type set the sum function of the groups
&quot;summaryType&quot;=&gt;&#039;sum&#039;
),
array(
&quot;member&quot;=&gt;&#039;KREDIT&#039;,
&quot;aggregator&quot;=&gt;&#039;sum&#039;,
&quot;width&quot;=&gt;&#039;120&#039;,
&quot;label&quot;=&gt;&#039;Kredit&#039;,
&quot;formatter&quot;=&gt;&#039;number&#039;,
&quot;align&quot;=&gt;&#039;right&#039;,
// the summary type set the sum function of the groups
&quot;summaryType&quot;=&gt;&#039;sum&#039;
)
));

$pivot-&gt;setPivotOptions(array(
&quot;rowTotals&quot; =&gt; true,
&quot;colTotals&quot; =&gt; true
));

$pivot-&gt;ignoreCaseSearch = true;
$pivot-&gt;setSearchOptions( array ( &quot;sqlfunc&quot; =&gt; &quot;UPPER&quot;, &quot;phpfunc&quot; =&gt; &quot;strtoupper&quot; ));

//$grid-&gt;setNavOptions(&#039;navigator&#039;,array(&quot;csv&quot;=&gt;true, &quot;pdf&quot;=&gt;true));
$pivot-&gt;setFilterOptions(array(&quot;stringResult&quot;=&gt;true, &quot;searchOperators&quot;=&gt;true));
$pivot-&gt;setExcelOptions(array(
&quot;file_type&quot;=&gt;&quot;Excel5&quot;, //Excel2007,Excel5,xml
&quot;file&quot;=&gt;&quot;neraca.xls&quot;,
&quot;start_cell&quot; =&gt; &quot;A1&quot;,
&quot;font&quot;=&gt;&quot;Arial&quot;,
&quot;font_size&quot;=&gt;11,

&quot;protect&quot; =&gt; false,

));

$pivot-&gt;navigator = true;
$pivot-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&quot;=&gt;true,&quot;add&quot;=&gt;false,&quot;edit&quot;=&gt;false, &quot;del&quot;=&gt;false));

$pivot-&gt;renderPivot(&quot;#grid&quot;,&quot;#pager&quot;, true, null, true, true);

....

$pivot = new jqPivotGrid($conn);

$pivot->SelectCommand ="

SELECT

N.NERACAID,

N.THBL,

N.TIPE,

N.NOCOA,

N.DEBET,

N.KREDIT

FROM NERACA N

$pivot->setGridOptions(array(

"rowNum"=>999999,

"height"=>200,"width"=>1000,

"sortname" => "NOCOA",

"rowList"=>array(10,20,50,10),

"shrinkToFit"=>false,

"caption"=>"Group Nama",

"groupingView"=>array("groupCollapse"=>true)

));

$pivot->setData('pivot_.php');

// Grid xDimension settings

$pivot->setxDimension(array(

array("dataName"=>"NOCOA", "width"=>150)

));

// Grid yDimension settings

$pivot->setyDimension(array(

array("dataName" => "THBL", "width"=>185),

array("dataName" => "TIPE", "width"=>185)

));

// Members

$pivot->setaggregates(array(

array(

"member"=>'DEBET',

"aggregator"=>'sum',

"width"=>'120',

"label"=>'Debet',

"formatter"=>'number',

"align"=>'right',

// the summary type set the sum function of the groups

"summaryType"=>'sum'

array(

"member"=>'KREDIT',

"aggregator"=>'sum',

"width"=>'120',

"label"=>'Kredit',

"formatter"=>'number',

"align"=>'right',

// the summary type set the sum function of the groups

"summaryType"=>'sum'

)

));

$pivot->setPivotOptions(array(

"rowTotals" => true,

"colTotals" => true

));

$pivot->ignoreCaseSearch = true;

$pivot->setSearchOptions( array ( "sqlfunc" => "UPPER", "phpfunc" => "strtoupper" ));

//$grid->setNavOptions('navigator',array("csv"=>true, "pdf"=>true));

$pivot->setFilterOptions(array("stringResult"=>true, "searchOperators"=>true));

$pivot->setExcelOptions(array(

"file_type"=>"Excel5", //Excel2007,Excel5,xml

"file"=>"neraca.xls",

"start_cell" => "A1",

"font"=>"Arial",

"font_size"=>11,

"protect" => false,

));

$pivot->navigator = true;

$pivot->setNavOptions('navigator', array("excel"=>true,"add"=>false,"edit"=>false, "del"=>false));

$pivot->renderPivot("#grid","#pager", true, null, true, true);

And there’s something weird… No Excel export button too…

This reply was modified 8 years, 4 months ago by ariadrianto. Reason: image link not shown up
This reply was modified 8 years, 4 months ago by ariadrianto. Reason: image link

November 22, 2017 at 9:02 am #126437

ariadrianto

Participant

Just Info that your demo page of export excel is not working…

http://www.guriddo.net/demo/demos/pivotgrid/export/default.php

no button show up…

November 24, 2017 at 3:03 pm #126440

guriddo.support

Participant

Hello,

First of all thank you very much for the test case and demo and that you find these problems.

1.Currently there is a problem when rowTotal is set to true. We will try to fix this ASAP. In order to achieve what you want temporary set this parameter to false – i.e:

$pivot-&gt;setPivotOptions(array(
&quot;rowTotals&quot; =&gt; false,
&quot;colTotals&quot; =&gt; true
));

$pivot->setPivotOptions(array(

"rowTotals" => false,

"colTotals" => true

));

2. The code for the buttons in pivot is fixed in JavaScript in GitHub. If you have difficulties to get it, please let us know

Kind Regards,
Will

Guriddo Support Team

November 25, 2017 at 6:21 am #126441

ariadrianto

Participant

guriddo.support wrote:

Hello, First of all thank you very much for the test case and demo and that you find these problems.
1.Currently there is a problem when rowTotal is set to true. We will try to fix this ASAP. In order to achieve what you want temporary set this parameter to false – i.e: <!– Crayon Syntax Highlighter v_2.7.2_beta –>

<table class=”crayon-table”>
<tbody>
<tr class=”crayon-row”>
<td class=”crayon-nums ” data-settings=”show”>

1

2

3

4

</td>
<td class=”crayon-code”>

$pivot->setPivotOptions(array(

”rowTotals” => false,

”colTotals” => true

));

</td>
</tr>
</tbody>
</table>

It’s working… Thank you…

<!– [Format Time: 0.0008 seconds] –>

guriddo.support wrote:

2. The code for the buttons in pivot is fixed in JavaScript in GitHub. If you have difficulties to get it, please let us know Kind Regards, Will

would you like to send me a link to fix it ?

November 27, 2017 at 12:32 pm #126444

guriddo.support

Participant

Hello,

You have a e-mail.

Kind Regards,
Will

Guriddo Support Team

January 20, 2018 at 3:58 am #126587

ariadrianto

Participant

guriddo.support wrote:

Hello, First of all thank you very much for the test case and demo and that you find these problems. 1.Currently there is a problem when rowTotal is set to true. We will try to fix this ASAP. In order to achieve what you want temporary set this parameter to false

Hi…
Any progress for this bug ?

Best Regards,

This reply was modified 8 years, 2 months ago by ariadrianto. Reason: bad format

Author

Replies

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

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

Multi Y Dimension

Search Forum

Recent Replies

Forum Statistics

UserOnline