So you use order_by? or what method did you use to accomplish this?
wolfiton
OvermindDL1
Sure add an order field then. Doesn’t mean other translations won’t want a different order (you’d be surprised, like big time…). ^.^
From just a quick initial look (it’s now in my to-read list) isn’t this significantly more easily solved via the path datatype in pgsql? He even says at the end you should stick to a sql server that at least has array’s in it, lol.
0
kokolegorille
I use order_by position.
But it is done in a way the end user does not have to set position, it is done at the server level.
I use sortable js and the end user can freely drag and drop items to reorder them.
0
wolfiton
Oh drag and drop and update the position of the item when the user drop the item?
Can you share your method please?, I saw something similar in node.
0
kokolegorille
I made some libs with webpack to build lists and trees… It uses fetch to send data to server, where the order is persisted.
const buildList = id => {
// If no id is defined, select the first element with class sortable
let list = id ?
document.getElementById(id) :
document.getElementsByClassName('sortable')[0];
// https://github.com/SortableJS/Sortable
if (list) {
const {url} = list.dataset;
Sortable.create(list, {
onUpdate: (/**Event*/evt) => {
const data = {oldIndex: evt.oldIndex, newIndex: evt.newIndex};
// Post data as query string and use right headers
fetch(url, {
method: "POST",
headers: {
"Content-type": "application/x-www-form-urlencoded"
},
body: toQueryString(data),
})
.then(resp => {
// Handle data
console.log(resp);
}).catch(error => {
// Handle error
console.log(error);
});
},
});
} else {
console.log("No List found.");
}
}
1
wolfiton
Thanks here is an example with vue I think it does the same thing https://codepen.io/phphe/pen/KRapQm
0
kokolegorille
kokolegorille
wolfiton
I like Vue more because it is structured and clear, anyone that looks over the code will understand what is happening and also the vue-cli and vue-ui makes development a pleasure. You should try it sometime.
0
