Guriddo » ariadrianto's Replies

ariadrianto

Guriddo

Forum Replies Created

Viewing 15 replies - 31 through 45 (of 59 total)

← 1 2 3 4 →

Author

Replies

March 22, 2016 at 3:48 am in reply to: closeAfterEdit not working on Detail grid #125003

ariadrianto

Participant

Hi,

I’ve just realized that it’s not working too on master… but it works when using navigator edit button.

Thanks,

March 22, 2016 at 3:40 am in reply to: closeAfterEdit not working on Detail grid #125001

ariadrianto

Participant

hi thanks…

Now I know whats wrong…

when I use onclick event and call editGridRow


$grid->setNavOptions('edit', array("height"=>"auto","dataheight"=>'auto',"recreateForm"=>true, "closeAfterEdit"=>true));
$grid->setNavOptions('add',array("height"=>"auto","dataheight"=>'auto',"closeAfterEdit"=>true));

$summaryrow = array("NAMA"=>array("MASUK"=>"SUM") );
$grid->navigator = true;

$onselrow = <<< ONSELROW

function(rowid, selected) {

if(rowid && rowid !== lastSelection) {

$("#detail").jqGrid('restoreRow', lastSelection); $("#detail").jqGrid('editGridRow', rowid, true);

lastSelection = rowid;

} }

ONSELROW;

$grid->setGridEvent('onSelectRow', $onselrow);
$grid->renderGrid("#detail","#pgdetail", true, $summaryrow,  array((int)$rowid), true,true);

$grid->setNavOptions('edit', array("height"=>"auto","dataheight"=>'auto',"recreateForm"=>true, "closeAfterEdit"=>true));

$grid->setNavOptions('add',array("height"=>"auto","dataheight"=>'auto',"closeAfterEdit"=>true));

$summaryrow = array("NAMA"=>array("MASUK"=>"SUM") );

$grid->navigator = true;

$onselrow = <<< ONSELROW

function(rowid, selected) {

if(rowid && rowid !== lastSelection) {

$("#detail").jqGrid('restoreRow', lastSelection); $("#detail").jqGrid('editGridRow', rowid, true);

lastSelection = rowid;

} }

ONSELROW;

$grid->setGridEvent('onSelectRow', $onselrow);

$grid->renderGrid("#detail","#pgdetail", true, $summaryrow, array((int)$rowid), true,true);

but when I use navigator edit button.. it will work.

This reply was modified 9 years, 1 month ago by ariadrianto. Reason: reformat source code

February 26, 2016 at 7:57 am in reply to: Unsuccess DateTimePicker #124898

ariadrianto

Participant

I’m sorry…
I’ve found an example :
http://www.guriddo.net/demo/jqgridphp/editing_data/timepicker/default.php

it works
Thanks

February 26, 2016 at 4:34 am in reply to: SetAutoComplete only 10 rows #124896

ariadrianto

Participant

have you fixed this problem ?

Thanks

Ari Adrianto

February 3, 2016 at 6:24 am in reply to: SetAutoComplete only 10 rows #124774

ariadrianto

Participant

it’s not working… still 10 rows

I’ve tried to change value… but no luck..


$grid->setAutocomplete("TRUCKING","#TRUCKINGID","select
cc.nama || ' | ' || ss.dari || ' | ' || ss.tujuan || ' | ' || ss.tipe || ' | ' || cast (ss.tarif as integer) ,
cc.nama || ' | ' || ss.dari || ' | ' || ss.tujuan || ' | ' || ss.tipe || ' | ' || cast (ss.tarif as integer) ,
ss.tarifsupid
from customer cc
inner join tarif_supplier ss on cc.customerid = ss.customerid
where cc.tipe = 'TRUCKING' and ss.status = 'Aktif'
and ( cc.nama LIKE upper( ? ) or ss.tujuan LIKE upper( ? ))
ORDER BY cc.nama ",array("itemLength"=>50), true, true);

$grid->setAutocomplete("TRUCKING","#TRUCKINGID","select

cc.nama || ' | ' || ss.dari || ' | ' || ss.tujuan || ' | ' || ss.tipe || ' | ' || cast (ss.tarif as integer) ,

ss.tarifsupid

from customer cc

inner join tarif_supplier ss on cc.customerid = ss.customerid

where cc.tipe = 'TRUCKING' and ss.status = 'Aktif'

and ( cc.nama LIKE upper( ? ) or ss.tujuan LIKE upper( ? ))

ORDER BY cc.nama ",array("itemLength"=>50), true, true);

November 11, 2015 at 2:44 am in reply to: toolbar search ignorecase #124508

ariadrianto

Participant

you can see this….
[/url]
http://postimg.org/image/l3nttsa85/

column “alamat” shift left on spreadsheet filling column “panggilan”, and following by all other column on the right side…

This reply was modified 9 years, 5 months ago by ariadrianto. Reason: image link too small

November 10, 2015 at 11:13 am in reply to: toolbar search ignorecase #124500

ariadrianto

Participant

Hi ,

Thanks… it’s working now.

Even a null value in column when export excel, make column shift left.

November 6, 2015 at 10:07 am in reply to: toolbar search ignorecase #124487

ariadrianto

Participant

Hi Tony,

when I can get your updated code ?
has it already available ?

Thanks…

October 26, 2015 at 11:23 am in reply to: Export Excel / PDF on grouping #124471

ariadrianto

Participant

I’m using adodb …

I’m just edit your examples : http://www.guriddo.net/demo/demos/jqgrid/export/true_excel5/default.php


grid.php.
<!--?php require_once '../../jq-config.php'; // include the jqGrid Class require_once ABSPATH."php/PHPSuito/jqGrid.php"; // include the driver class require_once ABSPATH."php/PHPSuito/DBdrivers/jqGridPdo.php"; // Connection to the server $conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD); // Tell the db that we use utf-8 $conn->query("SET NAMES utf8");</p>
<p>// Create the jqGrid instance<br ?--> $grid = new jqGridRender($conn);
// Write the SQL Query
$grid->SelectCommand = 'SELECT OrderID, OrderDate, CustomerID, ShipName, Freight FROM orders';
// Set output format to json
$grid->dataType = 'json';
// Let the grid create the model
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('grid.php');
// Set some grid options
$grid->setGridOptions(array(
"rowNum"=>10,
"rowList"=>array(10,20,30),
"sortname"=>"OrderID",
"caption"=>"Excel export"
));
// Change some property of the field(s)
$grid->setColProperty("OrderDate", array(
"formatter"=>"date",
"formatoptions"=>array("srcformat"=>"Y-m-d H:i:s","newformat"=>"m/d/Y"),
"search"=>false
)
);
$grid->setColProperty("ShipName", array("label"=>"Shipper Name","width"=>"200"));
$grid->setSelect('CustomerID', "SELECT CustomerID, CompanyName FROM customers");
// Enable navigator
$grid->navigator = true;
// Enable excel export
$grid->setNavOptions('navigator', array("excel"=>true,"add"=>false,"edit"=>false,"del"=>false,"view"=>false));
// Set different Excel options (all available)
// a PHP excel lib should be preset
// Set some grid options
$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"ShipName", "width"=>"1000", "height"=>'300',
"footerrow"=>true,
"userDataOnFooter"=>true,
"grouping"=>true,
"shrinkToFit"=>false,
"width"=>1000,
"groupingView"=>array(
"groupField" => array('ShipName'),
"groupOrder" => array('asc'),
"groupDataSorted" => true,
"groupColumnShow" => array(true),
"groupText" =>array('<b> ShipName:{0}</b>')
)
));

$grid->setExcelOptions(array(
"file_type"=>"Excel5", //Excel2007,Excel5,xml
"file"=>"report.xls",
"start_cell" => "A1",
"creator"=>"jqGrid",
"author"=>"jqGrid",
"title"=>"jqGrid Excel",
"subject"=>"Office XLS Document",
"description"=>"Document created with Guriddo",
"keywords"=>"Guriddo, jqGrid, Excel",
"font"=>"Arial",
"font_size"=>11,
"header_title"=>"Report created with jqGrid",
"protect" => false,
"password"=>"Guriddo",
"path_to_phpexcel_class"=>"External/phpexcel/PHPExcel.php"
));
$grid->exportfile = 'Report.xls';
// Enjoy
$grid->renderGrid('#grid','#pager',true, null, null, true,true);

grid.php.

<!--?php require_once '../../jq-config.php'; // include the jqGrid Class require_once ABSPATH."php/PHPSuito/jqGrid.php"; // include the driver class require_once ABSPATH."php/PHPSuito/DBdrivers/jqGridPdo.php"; // Connection to the server $conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD); // Tell the db that we use utf-8 $conn->query("SET NAMES utf8");

// Create the jqGrid instance $grid = new jqGridRender($conn);

// Write the SQL Query

$grid->SelectCommand = 'SELECT OrderID, OrderDate, CustomerID, ShipName, Freight FROM orders';

// Set output format to json

$grid->dataType = 'json';

// Let the grid create the model

$grid->setColModel();

// Set the url from where we obtain the data

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

// Set some grid options

$grid->setGridOptions(array(

"rowNum"=>10,

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

"sortname"=>"OrderID",

"caption"=>"Excel export"

));

// Change some property of the field(s)

$grid->setColProperty("OrderDate", array(

"formatter"=>"date",

"formatoptions"=>array("srcformat"=>"Y-m-d H:i:s","newformat"=>"m/d/Y"),

"search"=>false

)

);

$grid->setColProperty("ShipName", array("label"=>"Shipper Name","width"=>"200"));

$grid->setSelect('CustomerID', "SELECT CustomerID, CompanyName FROM customers");

// Enable navigator

$grid->navigator = true;

// Enable excel export

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

// Set different Excel options (all available)

// a PHP excel lib should be preset

// Set some grid options

$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"ShipName", "width"=>"1000", "height"=>'300',

"footerrow"=>true,

"userDataOnFooter"=>true,

"grouping"=>true,

"shrinkToFit"=>false,

"width"=>1000,

"groupingView"=>array(

"groupField" => array('ShipName'),

"groupOrder" => array('asc'),

"groupDataSorted" => true,

"groupColumnShow" => array(true),

"groupText" =>array(' ShipName:{0}')

)

));

$grid->setExcelOptions(array(

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

"file"=>"report.xls",

"start_cell" => "A1",

"creator"=>"jqGrid",

"author"=>"jqGrid",

"title"=>"jqGrid Excel",

"subject"=>"Office XLS Document",

"description"=>"Document created with Guriddo",

"keywords"=>"Guriddo, jqGrid, Excel",

"font"=>"Arial",

"font_size"=>11,

"header_title"=>"Report created with jqGrid",

"protect" => false,

"password"=>"Guriddo",

"path_to_phpexcel_class"=>"External/phpexcel/PHPExcel.php"

));

$grid->exportfile = 'Report.xls';

// Enjoy

$grid->renderGrid('#grid','#pager',true, null, null, true,true);

What I mean : when I delete grouping, Export Excel working fine…
But when grouping available… only header appear on excel sheet.

October 7, 2015 at 8:54 am in reply to: setAutocomplete… 404 : error. Status: error #124428

ariadrianto

Participant

Ohh… sorry… noted…

Thanks

October 6, 2015 at 9:10 am in reply to: setAutocomplete… 404 : error. Status: error #124423

ariadrianto

Participant

solved…

After debugging your jqGridRender.php , found this :


// source code deleted due license violation
..

// source code deleted due license violation

just put setURL up, after selectCommand and everything would be fine just before setColProperty :



.......

$grid->SelectCommand ='SELECT a.LEMBURID, a.PERIODE, a.KARYAWANID, k.nama, a.JAMLEMBUR, a.JMLSPECIAL,
a.JMLDINAS
FROM LEMBUR a
left join karyawan k on a.karyawanid = k.karyawanid
left join divisi d on k.divisi = d.divisiid ';

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

$grid->dataType = 'json';

$grid->setPrimaryKeyId("LEMBURID");
$grid->setColModel();
$grid->table = $table;

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

......

.......

$grid->SelectCommand ='SELECT a.LEMBURID, a.PERIODE, a.KARYAWANID, k.nama, a.JAMLEMBUR, a.JMLSPECIAL,

a.JMLDINAS

FROM LEMBUR a

left join karyawan k on a.karyawanid = k.karyawanid

left join divisi d on k.divisi = d.divisiid ';

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

$grid->dataType = 'json';

$grid->setPrimaryKeyId("LEMBURID");

$grid->setColModel();

$grid->table = $table;

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

......

This reply was modified 9 years, 6 months ago by tony.

October 5, 2015 at 9:41 am in reply to: setAutocomplete… 404 : error. Status: error #124421

ariadrianto

Participant

wow thanks…

it’s strange… looking for this :

http://localhost/test/jqGridRender.php?term=a&acelem=NAMA&oper=autocmpl

should be find : newEntryLembur_.php.

why looking for jqGridRender.php ??

October 3, 2015 at 11:36 am in reply to: setAutocomplete… 404 : error. Status: error #124417

ariadrianto

Participant

Here’s all my structure file :

jq-config.php


define('ABSPATH', '../');
// Form settings
$SERVER_HOST = ""; // the host name
$SELF_PATH = ""; // the web path to the project without http
$CODE_PATH = "../php/PHPSuito/"; // the physical path to the php files

// include the jqGrid Class
require_once ABSPATH."php/PHPSuito/jqGrid.php";
require_once ABSPATH."php/PHPSuito/DBdrivers/jqGridAdodb.php";
//require_once ABSPATH."php/PHPSuito/jqGridUtils.php";
require_once ABSPATH."php/PHPSuito/jqAutocomplete.php";
// include the driver class
define('ADODB_ASSOC_CASE', 2);
require_once ABSPATH."php/PHPSuito/External/adodb5/adodb.inc.php";
require_once ABSPATH."php/PHPSuito/External/adodb5/adodb-exceptions.inc.php";
require_once ABSPATH."php/PHPSuito/External/phpexcel/PHPExcel.php";

try {
$conn = ADONewConnection("firebird");
$conn->Connect('localhost',DB_USER,DB_PASSWORD, '/var/lib/firebird/2.5/data/testing.fdb');
} catch (exception $e) {
var_dump($e);
adodb_backtrace($e->gettrace());

}

define('ABSPATH', '../');

// Form settings

$SERVER_HOST = ""; // the host name

$SELF_PATH = ""; // the web path to the project without http

$CODE_PATH = "../php/PHPSuito/"; // the physical path to the php files

// include the jqGrid Class

require_once ABSPATH."php/PHPSuito/jqGrid.php";

require_once ABSPATH."php/PHPSuito/DBdrivers/jqGridAdodb.php";

//require_once ABSPATH."php/PHPSuito/jqGridUtils.php";

require_once ABSPATH."php/PHPSuito/jqAutocomplete.php";

// include the driver class

define('ADODB_ASSOC_CASE', 2);

require_once ABSPATH."php/PHPSuito/External/adodb5/adodb.inc.php";

require_once ABSPATH."php/PHPSuito/External/adodb5/adodb-exceptions.inc.php";

require_once ABSPATH."php/PHPSuito/External/phpexcel/PHPExcel.php";

try {

$conn = ADONewConnection("firebird");

$conn->Connect('localhost',DB_USER,DB_PASSWORD, '/var/lib/firebird/2.5/data/testing.fdb');

} catch (exception $e) {

var_dump($e);

adodb_backtrace($e->gettrace());

}

newEntryLembur.php

.... html stuff
include ("newEntryLembur_.php");

.... html stuff

include ("newEntryLembur_.php");

and newEntryLembur_.php


<!--?php require_once '../jq-config.php'; $grid = new jqGridRender($conn); $table = 'LEMBUR'; $grid->SelectCommand ='SELECT a.LEMBURID, a.PERIODE, a.KARYAWANID, k.nama, a.JAMLEMBUR, a.JMLSPECIAL,<br ?--> a.JMLDINAS
FROM LEMBUR a
left join karyawan k on a.karyawanid = k.karyawanid
left join divisi d on k.divisi = d.divisiid ';

$grid->dataType = 'json';

$grid->setPrimaryKeyId("LEMBURID");
$grid->setColModel();
$grid->table = $table;

$grid->setColProperty("LEMBURID", array("label"=>"ID", "hidden"=>true));
$grid->setColProperty("PRIODE", array("label"=>"Periode"));
$grid->setColProperty("KARYAWANID", array("label"=>"KaryawanId"));

$grid->setAutocomplete("NAMA","#KARYAWANID","SELECT NAMA, KARYAWANID FROM karyawan WHERE nama LIKE ? ORDER BY nama ",null, true, true);
;
$grid->setColProperty("JAMLEMBUR", array("label"=>"Jam Lembur"));
$grid->setColProperty("JMLSPECIAL", array("label"=>"Special Day"));
$grid->setColProperty("JMLDINAS", array("label"=>"Dinas Luar"));

$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"KARYAWANID", "width"=>"1000"));

$grid->toolbarfilter = true;
$grid->navigator = true;
$grid->setNavOptions('navigator', array("excel"=>true,"add"=>true,"edit"=>true,"del"=>true,"view"=>true));

$grid->setFilterOptions(array("stringResult"=>true));
$grid->setUrl('newEntryLembur_.php');
$grid->renderGrid('#grid','#pager',true, null, null, true,true);

<!--?php require_once '../jq-config.php'; $grid = new jqGridRender($conn); $table = 'LEMBUR'; $grid->SelectCommand ='SELECT a.LEMBURID, a.PERIODE, a.KARYAWANID, k.nama, a.JAMLEMBUR, a.JMLSPECIAL, a.JMLDINAS

FROM LEMBUR a

left join karyawan k on a.karyawanid = k.karyawanid

left join divisi d on k.divisi = d.divisiid ';

$grid->dataType = 'json';

$grid->setPrimaryKeyId("LEMBURID");

$grid->setColModel();

$grid->table = $table;

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

$grid->setColProperty("PRIODE", array("label"=>"Periode"));

$grid->setColProperty("KARYAWANID", array("label"=>"KaryawanId"));

$grid->setAutocomplete("NAMA","#KARYAWANID","SELECT NAMA, KARYAWANID FROM karyawan WHERE nama LIKE ? ORDER BY nama ",null, true, true);

;

$grid->setColProperty("JAMLEMBUR", array("label"=>"Jam Lembur"));

$grid->setColProperty("JMLSPECIAL", array("label"=>"Special Day"));

$grid->setColProperty("JMLDINAS", array("label"=>"Dinas Luar"));

$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"KARYAWANID", "width"=>"1000"));

$grid->toolbarfilter = true;

$grid->navigator = true;

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

$grid->setFilterOptions(array("stringResult"=>true));

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

$grid->renderGrid('#grid','#pager',true, null, null, true,true);

404 : error always appear when I started typing on search or adding or edit.
All I know is that 404 is URL not found, but which URL ?
I’m only using this 3 files…

October 1, 2015 at 12:15 pm in reply to: setAutocomplete… 404 : error. Status: error #124410

ariadrianto

Participant

Oh No…

what did I missed ?
if i change


$grid->setAutocomplete("NAMA","#KARYAWANID","SELECT   NAMA, KARYAWANID FROM karyawan WHERE nama LIKE ? ORDER BY nama ",null, true, true);

$grid->setAutocomplete("NAMA","#KARYAWANID","SELECT NAMA, KARYAWANID FROM karyawan WHERE nama LIKE ? ORDER BY nama ",null, true, true);

with :
$grid->setColProperty(“KARYAWANID”, array(“label”=>”KaryawanId”));

Everything is fine…

October 1, 2015 at 12:07 pm in reply to: setAutocomplete… 404 : error. Status: error #124407

ariadrianto

Participant

Oh No…

what did I missed ?
if i change

$grid->setAutocomplete("NAMA","#KARYAWANID","SELECT NAMA, KARYAWANID FROM karyawan WHERE nama LIKE ? ORDER BY nama ",null, true, true);

with

$grid->setColProperty(“NAMA”, array(“label”=>”Nama”));

Everything is fine…

I’ve tried to debug using netbeans and nothing found.

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

Author

Replies

Viewing 15 replies - 31 through 45 (of 59 total)

← 1 2 3 4 →