jQWidgets Forums

Forum Replies Created

Viewing 15 posts - 16 through 30 (of 38 total)

← 1 2 3 →

Author

Posts

January 16, 2013 at 11:05 am in reply to: Grid Two Database Grid Two Database #13693

ekaperintis

Participant

Hii master Peter Stoev : thanks you

Yeah, I know and have tried it with the example that you gave

But, what I want without any foreignkeycolumn

What you can help me

January 11, 2013 at 6:47 am in reply to: Move or Insert to Database MySQL Move or Insert to Database MySQL #13481

ekaperintis

Participant

Haii Dimitar

Thank you, i know ….but that is not i mean …

this is simulation :

database|table_test —> load to ———> grid —–> insert ——–> database|table_temporary

thank you

December 29, 2012 at 1:52 pm in reply to: Images Renderer Images Renderer #12917

ekaperintis

Participant

Hii master Peter ,

Yes, I know, but don’t work in my source code, please look in

<!DOCTYPE html>
<html lang="en">
<head>
    <title id='Description'>This example shows how to use the Grid API to customize a column's rendering.</title>
    <link rel="stylesheet" href="./../jqwidgets/styles/jqx.base.css" type="text/css" />
    <script type="text/javascript" src="./../scripts/jquery-1.8.2.min.js"></script>
    <script type="text/javascript" src="./../jqwidgets/jqxcore.js"></script>
    <script type="text/javascript" src="./../jqwidgets/jqxdata.js"></script> 
    <script type="text/javascript" src="./../jqwidgets/jqxbuttons.js"></script>
    <script type="text/javascript" src="./../jqwidgets/jqxscrollbar.js"></script>
    <script type="text/javascript" src="./../jqwidgets/jqxlistbox.js"></script>
    <script type="text/javascript" src="./../jqwidgets/jqxdropdownlist.js"></script>
    <script type="text/javascript" src="./../jqwidgets/jqxmenu.js"></script>
    <script type="text/javascript" src="./../jqwidgets/jqxgrid.js"></script>
    <script type="text/javascript" src="./../jqwidgets/jqxgrid.pager.js"></script>    
    <script type="text/javascript" src="./../jqwidgets/jqxgrid.selection.js"></script>      
    <script type="text/javascript" src="./../scripts/gettheme.js"></script>
	<script type="text/javascript" src="./../jqwidgets/jqxgrid.edit.js"></script>
	<script type="text/javascript" src="./../jqwidgets/jqxnumberinput.js"></script>
	<script type="text/javascript" src="./../jqwidgets/jqxcombobox.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            var theme = getTheme();
            var movies = new Array();
            // Avatar
            movies[0] = { Status: 'Y', Image: 'Y.png', Title: 'Avatar', Year: 2009 };
            movies[1] = { Status: 'Y', Image: 'Y.png', Title: 'Priest', Year: 2006 };
            movies[2] = { Status: 'N', Image: 'no.png', Title: 'End Game', Year: 2006 };
            movies[3] = { Status: 'Y', Image: 'Y.png', Title: 'Unknown', Year: 2011 };
            movies[4] = { Status: 'Y', Image: 'Y.png', Title: 'Unstoppable', Year: 2010 };
            movies[5] = { Status: 'Y', Image: 'Y.png', Title: 'Twilight', Year: 2008 };
            movies[6] = { Status: 'N', Image: 'no.png', Title: 'Kung Fu Panda', Year: 2008 };
            movies[7] = { Status: 'N', Image: 'no.png', Title: 'Knockout', Year: 2011 };
            movies[8] = { Status: 'N', Image: 'no.png', Title: 'The Plane', Year: 2010 };
            movies[9] = { Status: 'N', Image: 'no.png', Title: 'Big Daddy', Year: 1999 };
            var imagerenderer = function (row, datafield, value) {
                return '<img style="margin-left: 5px;" height="30" width="30" src="./../images/' + value + '"/>';
            }
            var source = { localdata: movies, datatype: "array" };
            var dataAdapter = new $.jqx.dataAdapter(source);
            // Create jqxGrid.
            $("#jqxgrid").jqxGrid(
            {
                width: 700,
                source: dataAdapter,
                theme: theme,
				editable: true,
                rowsheight: 30,
                columns: [
				  { text: 'Status', datafield: 'Status', width: 140, columntype: 'combobox',
						validation: function (cell, value) {
						if (value =="Y") {
							  return '<img style="margin-left: 5px;" height="30" width="30" src="./../images/no.png" />';
                        }
                        return true;
                      },
				  },
                  { text: 'Bad', datafield: 'Image', width: 140, cellsrenderer: imagerenderer },
                  { text: 'Title', datafield: 'Title', width: 200},
                  { text: 'Year', datafield: 'Year'}
               ]
            });
        });
    </script>
</head>
<body class='default'>
    <div id='jqxWidget' style="font-size: 13px; font-family: Verdana; float: left;">
        <div id="jqxgrid">
        </div>
    </div>
</body>
</html>

Can you help me,,

I want selection field Status =”Y” then field value image =”Y.png” else “no.png”

thank you

December 28, 2012 at 11:51 pm in reply to: Images Renderer Images Renderer #12906

ekaperintis

Participant

My Program Caputed

December 27, 2012 at 4:21 pm in reply to: autoresizecolumns on bindingcomplete autoresizecolumns on bindingcomplete #12859

ekaperintis

Participant

Hii Peter your source code it’s work ,,,, good is the best master

December 27, 2012 at 3:54 pm in reply to: Only Number Input Only Number Input #12858

ekaperintis

Participant

Hi Peter Stoev

Yes, i know but i dont understand implementation with source code this …

rendertoolbar: function (toolbar) {
                    var me = this;
                    var container = $("<div style='margin: 5px;'></div>");
                    var span = $("<span style='float: left; margin-top: 5px; margin-right: 4px;'>Search Nopel: </span>");
                    var input = $("<input class='jqx-input jqx-widget-content jqx-rc-all' id='searchField' type='text' style='height: 23px; float: left; width: 223px;' />");
					toolbar.append(container);
                    container.append(span);
                    container.append(input);
                    if (theme != "") {
                        input.addClass('jqx-widget-content-' + theme);
                        input.addClass('jqx-rc-all-' + theme);
                    }

Thanks you

December 27, 2012 at 3:31 pm in reply to: Only Number Input Only Number Input #12856

ekaperintis

Participant

I can just only input text numeric,

can you help me …

December 26, 2012 at 11:58 pm in reply to: Only Number Input Only Number Input #12822

ekaperintis

Participant

Hii Peter ….. I’m sorry if my language is less you understand it

I want to just be inputted text fields with numbers

December 25, 2012 at 7:35 pm in reply to: insert to table from grid insert to table from grid #12798

ekaperintis

Participant

Hii master Peter Stoev : thank you,

November 30, 2012 at 2:45 am in reply to: Refresh Data in Grid Refresh Data in Grid #11751

ekaperintis

Participant

Ohh im sorry master …..

may I see the code that you have created, I want to try to correct

November 29, 2012 at 4:48 am in reply to: Refresh Data in Grid Refresh Data in Grid #11665

ekaperintis

Participant

hi darind ….

please you captured your project

November 29, 2012 at 4:46 am in reply to: Get Value 2 column Get Value 2 column #11664

ekaperintis

Participant

hi, Peter …

yeah, I mean it’s true

in fact, had never seen before, but forgot the address … hehehe …

thank you master,,,,

November 29, 2012 at 2:56 am in reply to: Keyboard Navigation in the Grid Keyboard Navigation in the Grid #11659

ekaperintis

Participant

this is you look documentatios navigation keyboard

http://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-cells-selection.htm

November 29, 2012 at 2:53 am in reply to: Get Value 2 column Get Value 2 column #11658

ekaperintis

Participant

Hi Peter Stoev …

I for The method accepts 2 params – row index and column’s datafield I’ve already done, but the results are not as expected, this code that I created

to javascript

$("#jqxgrid").bind('cellselect', function (event) {
                var column = $("#jqxgrid").jqxGrid('getcolumn', event.args.datafield);
                var value = $("#jqxgrid").jqxGrid('getcellvalue', event.args.rowindex, column.datafield);
                var displayValue = $("#jqxgrid").jqxGrid('getcellvalue', event.args.rowindex, column.displayfield);
                $("#eventLog").html("Informasi Pelanggan : " + value);
            });

to body

<body class='default'>
	<div style="font-size: 20px; "margin-top: 20px; 
		font-family: Verdana, Geneva, 'DejaVu Sans', sans-serif;" 
		id="eventLog">Informasi Pelanggan : </div>
		<div>
		&nbsp
		</div>
		
		<div id='jqxWidget'>      
		
		<div id="jqxgrid"></div>
	
	</div>
</body>

if there is something wrong or is there a solution for my problem ???

November 28, 2012 at 6:46 pm in reply to: Search in toolbars Search in toolbars #11637

ekaperintis

Participant

Hi Peter Stoev ,,,,

I’ve managed to solve my problem, of course, the enlightenment and enter from your …

in the following code that I created

// get data and store in a json array
$searchField=$_GET['name_startsWith'];
$query = "SELECT * FROM tr_drd WHERE Nopel LIKE '$searchField%'";

thanks you master

Author

Posts

Viewing 15 posts - 16 through 30 (of 38 total)

← 1 2 3 →