hi, i have a datatable and bind form .
There are both in the form text fields that 2 richselect .
About saving the form , go to the update in the DB and works , while the datatable refresh the entire line except the cells that are " bindate " to 2 combo of form .
How do I also update those two cells that should contain values of richselect ?
I hope I was clear .
Thank you
Can you specify what’s going wrong?
You can use this sample as a base: http://webix.com/snippet/bb188c30
the problem when use a query database to load object…
this example not work
where am I wrong ?
webix.ui({
rows:[
{
id: "table",
view:"datatable",
columns:[
{ id:"rank", header:"", css:"rank", width:50},
{ id:"title", header:"Film title",fillspace: true}
],
autoheight:true,
url: "load.php?cmd=test1",
on:{
onItemClick:function(id){
this.setCursor(id);
}
}
},
{
view: "form",
id: "editor-form",
elements:[
{view: "richselect", name:"title", label: "Title", options:"load.php?cmd=test"},
{view: "text", name:"rating", label: "Rating"},
{view: "button", label: "Save", type:"form", click: function(){
$$("editor-form").save();
}}
]
}
]
});
$$("editor-form").bind("table");
case “test”:
$sql = "SELECT Id as id, title as value FROM data_test";
$ret = sqlExec($sql);
echo json_encode( $ret );
break;
case "test1":
$sql = "SELECT * FROM data_test";
$ret = sqlExec($sql);
echo json_encode( $ret );
break;
table data_test
Id rank title
1 1 titolo1
2 2 titolo2
3 3 titolo3
Most probably it’s a typo: in yourdata_test the title of id field starts with the uppercase “I”.
<!DOCTYPE html>
<html>
<head>
<title>Datatable: Loading with Connector</title>
<link rel="stylesheet" href="webix/codebase/webix.css" type="text/css" charset="utf-8">
<script src="webix/codebase/webix.js" type="text/javascript" charset="utf-8"></script>
</head>
<body>
<div id='areaA'></div>
<div id='areaB'></div>
<script type="text/javascript" charset="utf-8">
webix.ui({
view:"datatable",
id:"datatable1",
container: "areaA",
columns:[
{ id:"id", name:"id", header:"#", css:"rank", width:50},
{ id:"rank", name:"rank", header:"Rank", css:"rank", width:50},
{ id:"title", name:"title", header:"Film title", width:200},
{ id:"cType", name:"cType", header:["Type Film", {content:"selectFilter"} ], sort:"string", width:200}
],
on:{
'onItemDblClick': function(id,e) {
showForm("frmEdit");
}
},
autoheight:true,
autowidth:true,
select:"row",
url: "tipologiche.php?cmd=test"
});
var form_edit = {
id: "form1",
view:"form",
container: "areaB",
elements:[
{ view:"text", id:"id", name:"id", label:"id"},
{ view:"text", id:"rank", name:"rank", label:"Rank"},
{ view:"text", id:"title", name:"title", label:"Title"},
{ view : "richselect", name:"idType",id:"idType", options:"tipologiche.php?cmd=type_films", label : "Type Film"},
{ view:"button", label:"Save" , type:"form", click:save_form },
{ view:"button", label:"Clear", click:"$$('form1').clear();" }
]
};
webix.ui({
view:"window",
id:"frmEdit",
move:true,
width:1300,
height:620,
position:"center",
modal:true,
head:{
view:"toolbar", margin:-4, cols:[
{ view:"label", label: "Element details" },
{ view:"icon", icon:"times-circle", click:"$$('frmEdit').hide();"}
]
},
body:webix.copy(form_edit)
});
$$('form1').bind($$('datatable1'));
function showForm(winId,node){
$$(winId).show(node);
$$(winId).getBody().focus();
}
function save_form(){
var row = $$("form1").getValues();
var s = { "cmd":"test", "table": "films", "row":row, "IdName":"id", "IdValue":row['id'] }
webix.ajax().post("update.php", s ,function(text) {
console.log(text);
});
$$("form1").save();
$$("frmEdit").hide();
};
</script>
</body>
</html>
<?php
error_reporting(E_ALL ^ E_DEPRECATED);
include("include\\application.php");
$req = sizeof( $_POST ) > 0 ? $_POST : $_GET;
$cmd = $req['cmd'];
switch( $cmd ) {
case "test":
$sql = "SELECT * FROM films INNER JOIN type_films on films.idType = type_films.idType";
$ret = sqlExec($sql);
echo json_encode( $ret );
break;
case "type_films":
$sql = "SELECT idType as id, cType as value FROM type_films";
$ret = sqlExec($sql);
echo json_encode( $ret );
break;
case "owners":
$sql = "SELECT owner_name as id, owner_name as value FROM aisurvey_owner";
$ret = sqlExec($sql);
echo json_encode( $ret );
break;
case "profiles":
$sql = "SELECT IdProfilo as id, cProfilo as value FROM aisurvey_profiles";
$ret = sqlExec($sql);
echo json_encode( $ret );
break;
}
function sqlExec( $sql ) {
$ar = array();
$res = mysql_query( $sql );
while ($row = mysql_fetch_assoc($res)) {
$ar[] = $row;
}
return $ar;
}
?>
<?php
error_reporting(E_ALL ^ E_DEPRECATED);
include("include/application.php");
$req = sizeof( $_POST ) > 0 ? $_POST : $_GET;
$cmd = $req['cmd'];
switch( $cmd ) {
case "owner":
$table = $req['table'];
$row = json_decode( $_POST['row'], true );
$IdName = $req['IdName'];
$IdValue= $req['IdValue'];
$ret = dbSql( $cmd, $table, $row, $IdName, $IdValue);
break;
case "test":
$table = $req['table'];
$row = json_decode( $_POST['row'], true );
unset($row['cType']);
$IdName = $req['IdName'];
$IdValue= $req['IdValue'];
$ret = dbSql( $cmd, $table, $row, $IdName, $IdValue);
break;
}
function dbSql( $cmd, $table, $ar, $idname, $idvalue ) {
$z = "";
foreach( $ar as $k => $v ) {
if( $k == "id" )
continue;
$z .= ($z != "" ) ? ",":"";
$z .= $k . "='" . mysql_real_escape_string($v) . "'";
}
$sql = sprintf( "UPDATE %s SET %s WHERE %s=%d", $table, $z, $idname, $idvalue );
$ret['sql'] = $sql;
$ret['ret'] = mysql_query( $sql );
$ret['ar'] = json_encode( $ar );
$ret['error'] = mysql_error();
$ret['insert_id'] = mysql_insert_id();
$ret['success'] = true;
if( mysql_error() != "" )
$ret['success'] = false;
return $ret;
}
?>
I’m sorry but I posted all my sample code .
I have two problems :
when I make the save , but the update does not update the Type Film on datatable and consequently do not update the filter of the column.
I hope I was clear
Thank you