Delete, Update, Save: edatagrid problem

[Punkerr]

Hi, i have this problem:

DEFINITION edatagrid jscript:

Code:

		$(function() {
			$('#dg').edatagrid({
				url: 'get.php',
				saveUrl: 'save.php',
				updateUrl: 'update.php',
				destroyUrl: 'destroy.php?ID='+row.ARTICLE, <!-- not working :(
				rowStyler: function(index, row) {
					if (row.QTY > row.STOCK) {
						return 'color:red;font-weight:bold;';
					}
				}
		
			});
		});

HTML:

Code:

	<table id="dg" title="Planner" style="width:1200px;height:530px"
			toolbar="#toolbar" pagination="true" idField="ID" url="get.php"  
			iconCls="icon-save" rownumbers="true" fitColumns="true" singleSelect="true">
		<thead>
			<tr>
				<th field="ARTICLE" width="30">Article</th>
				<th field="DESCRIPTION" width="110">Description</th>
				<th field="CLIENT" width="30">Client</th>
				<th field="CATEGORY" width="30">Category</th>
				<th field="A102" width="15" editor="{type:'numberbox',options:{required:true}}" align="right">A102</th>
				<th field="A104" width="15" editor="{type:'numberbox',options:{required:true}}" align="right">A104</th>
				<th field="A105" width="15" editor="{type:'numberbox',options:{required:true}}" align="right">A105</th>
				<th field="A109" width="15" editor="{type:'numberbox',options:{required:true}}" align="right">A106</th>
				<th field="A110" width="15" editor="{type:'numberbox',options:{required:true}}" align="right">A110</th>
				<th field="A111" width="15" editor="{type:'numberbox',options:{required:true}}" align="right">A111</th>
				<th field="A116" width="15" editor="{type:'numberbox',options:{required:true}}" align="right">A116</th>
				<th field="QTY" width="15" align="right">Total</th>
				<th field="STOCK" width="15" align="right">Stock</th>
				<th field="DIF" width="15" align="right" formatter="qtyNegative">Diferences</th>
			</tr>
		</thead>
	</table>
	<div id="toolbar" style="padding:5px;height:auto"> 
    	<div align="center">
            <span>Article Code:</span>
            <input id="articleid">
            <span>Article:</span>
            <input id="article">
            <span>Client:</span>
            <input id="clientid">
            <span>Category:</span>
            <input id="category">
            <a href="#" class="easyui-linkbutton" iconCls="icon-ok" plain="true" onClick="doSearch()">Do Filter</a>
            <a href="#" class="easyui-linkbutton" iconCls="icon-no" plain="true" onClick="clearSearch()">Clear Filter</a>
        </div>
        <div style="margin-bottom:5px" align="right">  
            <a href="#" class="easyui-linkbutton" iconCls="icon-remove" plain="true" onClick="javascript:$('#dg').edatagrid('destroyRow')">Delete Row</a>
            <a href="#" class="easyui-linkbutton" iconCls="icon-save" plain="true" onClick="javascript:$('#dg').edatagrid('saveRow')">Save Row Changes</a>
            <a href="#" class="easyui-linkbutton" iconCls="icon-undo" plain="true" onClick="javascript:$('#dg').edatagrid('cancelRow')">Cancel Edition</a>
        </div>
	</div>

DELETE SERVER CODE:

Code:

<?php

$id = $_REQUEST['ID'];

include 'conn.php';

$sql = "DELETE PUTBLPLANNER WHERE ARTICLE=$id";
@mysql_query($sql);
echo json_encode(array('success'=>true));
?>

I traced the query and ID comes in blank: "DELETE PUTBLPLANEADOR WHERE ARTICLE="

I'm doing something wrong?

By the way, I traced save and update, and nothing happens. Get Rows and Search (only textboxes not combos and lists) works fine to me.

Please, if someone checks the code, really appreciate it.

[stworthy]

What is the id field? Is it ARTICLE or ID? If the ARTICLE is the id field, please correct the idField property as:

idField="ARTICLE"

[Punkerr]

Ok I'm set it like you suggested, and redefined some things... but still the same problem:

TABLE:

ID	ARTICLE	ARTDESCRIPTION	CLIENT	CATEGORY	A102	QTY	STOCK	DIFERENCES
52	BVL1833120N	BVLGARI FRAG	BVLGARI	FRAGANCES	5	5	10	5
53	BVL1833124N	BVLGARI FRAG	BVLGARI	FRAGANCES	4	4	10	6
54	BVL1833420N	BVLGARI FRAG	BVLGARI	FRAGANCES	3	3	10	7

JSCRIPT:

Code:

		$(function() {
			$('#dg').edatagrid({
				url: 'get.php',
				saveUrl: 'save.php',
				updateUrl: 'update.php',
				destroyUrl: 'destroy.php',
				rowStyler: function(index, row) {
					if (row.QTY > row.STOCK) {
						return 'color:red;font-weight:bold;';
					}
				}
		
			});
		});

HTML:

Code:

	<table id="dg" title="Planner" style="width:1200px;height:530px"
			 toolbar="#toolbar" pagination="true" idField="ID" url="get.php"  
			 iconCls="icon-save" rownumbers="true" fitColumns="true" singleSelect="true">
		 <thead>
			 <tr>
				 <th field="ARTICLE" width="30">Article</th>
				 <th field="ARTDESCRIPTION" width="110">Description</th>
				 <th field="CLIENT" width="30">Client</th>
				 <th field="CATEGORY" width="30">Category</th>
				 <th field="A102" width="15" editor="{type:'numberbox',options:{required:true}}" align="right">A102</th>
				 <th field="QTY" width="15" align="right">Total</th>
				 <th field="STOCK" width="15" align="right">Stock</th>
				 <th field="DIFERENCES" width="15" align="right" formatter="qtyNegative">Diferences</th>
			 </tr>
		 </thead>
	 </table>
	 <div id="toolbar" style="padding:5px;height:auto"> 
    	 <div align="center">
            <span>Article Code:</span>
            <input id="articleid">
            <span>Article:</span>
            <input id="article">
            <span>Client:</span>
            <input id="clientid">
            <span>Category:</span>
            <input id="category">
            <a href="#" class="easyui-linkbutton" iconCls="icon-ok" plain="true" onClick="doSearch()">Do Filter</a>
            <a href="#" class="easyui-linkbutton" iconCls="icon-no" plain="true" onClick="clearSearch()">Clear Filter</a>
        </div>
        <div style="margin-bottom:5px" align="right">  
            <a href="#" class="easyui-linkbutton" iconCls="icon-remove" plain="true" onClick="javascript:$('#dg').edatagrid('destroyRow')">Delete Row</a>
            <a href="#" class="easyui-linkbutton" iconCls="icon-save" plain="true" onClick="javascript:$('#dg').edatagrid('saveRow')">Save Row Changes</a>
            <a href="#" class="easyui-linkbutton" iconCls="icon-undo" plain="true" onClick="javascript:$('#dg').edatagrid('cancelRow')">Cancel Edition</a>
        </div>
	 </div>

SERVER CODE (destroy.php):

Code:

<?php
include 'conn.php';
$id = $_REQUEST['ID'];
$sql = "DELETE PUTBLPLANEADOR WHERE ID=$id";
@mysql_query($sql);
echo json_encode(array('success'=>true));
?>

And I worry about update, doesn't work   :
SERVER CODE (update.php):

Code:

<?php
include 'conn.php';
$id = $_REQUEST['ID'];
$a102 = intval($_REQUEST['A102']);

$sql = "UPDATE PUTBLPLANEADOR SET A102=$a102, QTY=$a102 WHERE ID=$id";
@mysql_query($sql);
echo json_encode(array(
	'ARTICLE' => $id,
	'A102' => $a102

));
?>

Get and Search works fine, any idea?, thanks in advance!

[stworthy]

The json returned from update.php should include the id field.

Code:

echo json_encode(array(
‘ID’ => ...,
‘ARTICLE' => ...,
'A102' => ...
));

[Punkerr]

Thank you I will try.

And any idea about the problem with destroy rows?

[Punkerr]

Oh god it works! thanks stworthy, update works so cool.
For delete, I changed all query to lower case, and finally it works!