Guriddo » ariadrianto's Replies

ariadrianto

Guriddo

Forum Replies Created

Viewing 15 replies - 1 through 15 (of 59 total)

1 2 3 4 →

Author

Replies

April 10, 2022 at 6:07 am in reply to: Integrate HTML Editor #127931

ariadrianto

Participant

Hi,

I’ve solution with my problem…

Adding tinyMCE remove will solve this…

$custelm =<<<CUSTELM
function( value, options) {
var elm = $('<textarea></textarea>');
elm.val( value );
// give the editor time to initialize
setTimeout( function() {
try {
tinymce.remove("#" + options.id);
} catch(ex) {}
tinymce.init({
selector: "textarea#SOAL"
});
}, 100);
return elm;
}
CUSTELM;

$custelm =<<<CUSTELM

function( value, options) {

var elm = $('<textarea></textarea>');

elm.val( value );

// give the editor time to initialize

setTimeout( function() {

try {

tinymce.remove("#" + options.id);

} catch(ex) {}

tinymce.init({

selector: "textarea#SOAL"

});

}, 100);

return elm;

}

CUSTELM;

March 30, 2022 at 4:52 am in reply to: setExcelOption numeric #127928

ariadrianto

Participant

My mistake…

you’ve already answer this before… with


<div>
<div>$grid->setExcelOptions(array(</div>
<div>"file_type" => "Excel2007",</div>
<div>"empty_date" => true,</div>
<div>...</div>
<div>));</div>
<div>

<div>

<div>$grid->setExcelOptions(array(</div>

<div>"file_type" => "Excel2007",</div>

<div>"empty_date" => true,</div>

<div>

March 30, 2022 at 4:49 am in reply to: setExcelOption numeric #127927

ariadrianto

Participant

Hi,

Thanks… it works…

any excel_format for date… it become ‘1970-01-01’ when null value.

Date

01-January-1970

28-February-2022

01-January-1970

thanks…

January 14, 2022 at 5:04 am in reply to: setAutocomplete with parameter #127837

ariadrianto

Participant

Here’s the code :



...
$search = jqGridUtils::GetParam('_search','true');
if($search == 'true')
{
$from = jqGridUtils::GetParam('from',date('m/d/Y'));
$to = jqGridUtils::GetParam('to',date('m/d/Y'));
$companyid = jqGridUtils::GetParam('companyid', '');

$_SESSION['from'] = $from;
$_SESSION['to'] = $to;

}

$table = 'BK';
$grid->SelectCommand = "
SELECT BK.NO_BK,
BK.BKID,
BK.TGL,
BK.URAIAN,
BK.KASBANKID,K.BANK,
BK.TYPES,
bk.companyid
FROM BK
LEFT JOIN KASBANK K ON (BK.KASBANKID = K.KASBANKID)

where bk.tgl between '".$from."' and '".$to."'
and bk.companyid = $companyid

";
$grid->dataType = 'json';

$grid->setColModel();
$grid->table = $table;
$grid->setUrl( 'bk_.php');

$grid->setColProperty("BKID", array("label" => "ID", "hidden" => true));
$grid->setColProperty("KASBANKID", array("label" => "ID", "hidden" => true));
$grid->setColProperty("COMPANYID", array("label" => "ID", "hidden" => true,
"editoptions" => array("defaultValue"=>$companyid )));
$grid->setAutocomplete("BANK", "#KASBANKID", "
select
ct.BANK,
ct.BANK,
ct.KASBANKID
from KASBANK ct
where ( upper(ct.bank ) LIKE '%' || upper( ? ) || '%' )
and CT.companyid = $companyid
order by ct.bank ", null, true, true);
...

...

$search = jqGridUtils::GetParam('_search','true');

if($search == 'true')

{

$from = jqGridUtils::GetParam('from',date('m/d/Y'));

$to = jqGridUtils::GetParam('to',date('m/d/Y'));

$companyid = jqGridUtils::GetParam('companyid', '');

$_SESSION['from'] = $from;

$_SESSION['to'] = $to;

}

$table = 'BK';

$grid->SelectCommand = "

SELECT BK.NO_BK,

BK.BKID,

BK.TGL,

BK.URAIAN,

BK.KASBANKID,K.BANK,

BK.TYPES,

bk.companyid

FROM BK

LEFT JOIN KASBANK K ON (BK.KASBANKID = K.KASBANKID)

where bk.tgl between '".$from."' and '".$to."'

and bk.companyid = $companyid

$grid->dataType = 'json';

$grid->setColModel();

$grid->table = $table;

$grid->setUrl( 'bk_.php');

$grid->setColProperty("BKID", array("label" => "ID", "hidden" => true));

$grid->setColProperty("KASBANKID", array("label" => "ID", "hidden" => true));

$grid->setColProperty("COMPANYID", array("label" => "ID", "hidden" => true,

"editoptions" => array("defaultValue"=>$companyid )));

$grid->setAutocomplete("BANK", "#KASBANKID", "

select

ct.BANK,

ct.KASBANKID

from KASBANK ct

where ( upper(ct.bank ) LIKE '%' || upper( ? ) || '%' )

and CT.companyid = $companyid

order by ct.bank ", null, true, true);

...

let’s focus on setAutocomplete



$grid->setAutocomplete("BANK", "#KASBANKID", "
select
ct.BANK,
ct.BANK,
ct.KASBANKID
from KASBANK ct
where ( upper(ct.bank ) LIKE '%' || upper( ? ) || '%' )
and CT.companyid = $companyid
order by ct.bank ", null, true, true);

&nbsp;

$grid->setAutocomplete("BANK", "#KASBANKID", "

select

ct.BANK,

ct.KASBANKID

from KASBANK ct

where ( upper(ct.bank ) LIKE '%' || upper( ? ) || '%' )

and CT.companyid = $companyid

order by ct.bank ", null, true, true);

if I change companyid, it won’t filter companyid …

Regards,

January 13, 2022 at 9:09 am in reply to: setAutocomplete with parameter #127830

ariadrianto

Participant

Hi,

Thanks. But what I meant is $_session filter.

...

where ( upper(ct.bank ) LIKE '%' || upper( ? ) || '%' )

and CT.companyid = ".$_SESSION['companyid']."

...

”
<p style=”padding-left: 40px;”>where ( upper(ct.bank ) LIKE ‘%’ || upper( ? ) || ‘%’ )’</p>

and CT.companyid = “.$_SESSION[‘companyid’].”

“

it’s not working to filter when I change Session…

Regards,

nb. sorry, i don’t know how to copy paste a code …

This reply was modified 3 years, 1 month ago by ariadrianto.
This reply was modified 3 years, 1 month ago by ariadrianto. Reason: how to copy paste a code ??

May 15, 2021 at 7:37 am in reply to: Inline AutoComplete Not Working #127621

ariadrianto

Participant

Hi,

I’ve been waiting for this…
I hope I can get this fixed release too…

April 21, 2019 at 4:10 am in reply to: Auto Scroll #127167

ariadrianto

Participant

Gee,

I thought that scroll 1 will make auto scroll down by record by record at a second…

or is there any implementation to fire next page every loading table ?

Thanks

April 18, 2018 at 11:43 am in reply to: Theme Change #126817

ariadrianto

Participant

Oh God… my mistaken, I change js too…

Thank you…
it works…

January 20, 2018 at 3:58 am in reply to: Multi Y Dimension #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 7 years ago by ariadrianto. Reason: bad format

December 5, 2017 at 9:34 am in reply to: PivotGrid Reload Example #126476

ariadrianto

Participant

Hi,

Thank you very much… it’s worked now…

December 2, 2017 at 8:12 am in reply to: PivotGrid Reload Example #126472

ariadrianto

Participant

Hi…

It’s working… Thank you

but… without summary column / colTotals …

November 25, 2017 at 6:34 am in reply to: PivotGrid Reload Example #126442

ariadrianto

Participant

Hi…
i’ve tried but no luck…

Uncaught TypeError: Cannot read property ‘grid’ of undefined

is there any demo of this ?

Thank you

November 25, 2017 at 6:21 am in reply to: Multi Y Dimension #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”>

<span class=”crayon-sy”>$</span><span class=”crayon-v”>pivot</span><span class=”crayon-o”>-></span><span class=”crayon-e”>setPivotOptions</span><span class=”crayon-sy”>(</span><span class=”crayon-t”>array</span><span class=”crayon-sy”>(</span>

<span class=”crayon-s”>”rowTotals”</span> <span class=”crayon-o”>=</span><span class=”crayon-o”>></span> <span class=”crayon-t”>false</span><span class=”crayon-sy”>,</span>

<span class=”crayon-s”>”colTotals”</span> <span class=”crayon-o”>=</span><span class=”crayon-o”>></span> <span class=”crayon-t”>true</span>

<span class=”crayon-sy”>)</span><span class=”crayon-sy”>)</span><span class=”crayon-sy”>;</span>

</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 22, 2017 at 9:02 am in reply to: Multi Y Dimension #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 22, 2017 at 8:50 am in reply to: Multi Y Dimension #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->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);

....

$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 7 years, 2 months ago by ariadrianto. Reason: image link not shown up
This reply was modified 7 years, 2 months ago by ariadrianto. Reason: image link

Author

Replies

Viewing 15 replies - 1 through 15 (of 59 total)

1 2 3 4 →