Timetracking grid system in Vue JS to work with PostgreSQL
I'm trying to build an application where users can track their hours worked per day by logging numbers in a grid system. It looks something like this: https://jsfiddle.net/L5u1fc0a/130/ - if you try to add some numbers in any "cell", you'll see that it populates the JSON below like this:
[
{
"name": "Erik",
"times": {
"2018-10-01": "10"
}
}
]
I wish to transform my v-model so it work nicely with my PostgreSQL database, where I got two tables, one for users, and another table for hours logged. The data represented in my database looks something like this:
"userdata": [
{
"id": 2,
"firstname": "Joe",
"lastname": "Bergsen",
"email": "joe@berg.com",
"hour": [
{
"id": 1,
"user_id": 2,
"userinput": {
"2018-10-10": 8
}
}
]
}
],
So, basically, each hour they log needs to belong to a specific user. Not really sure how I can traverse my v-model. Any insights? I need to have my v-model work so it responds to each unique input value in the grid, and populates that value with the respective date + the input value.
javascript postgresql vue.js
asked Nov 22 '18 at 12:51
erikvmerikvm
3619
add a comment |
I'm trying to build an application where users can track their hours worked per day by logging numbers in a grid system. It looks something like this: https://jsfiddle.net/L5u1fc0a/130/ - if you try to add some numbers in any "cell", you'll see that it populates the JSON below like this:
[
{
"name": "Erik",
"times": {
"2018-10-01": "10"
}
}
]
I wish to transform my v-model so it work nicely with my PostgreSQL database, where I got two tables, one for users, and another table for hours logged. The data represented in my database looks something like this:
"userdata": [
{
"id": 2,
"firstname": "Joe",
"lastname": "Bergsen",
"email": "joe@berg.com",
"hour": [
{
"id": 1,
"user_id": 2,
"userinput": {
"2018-10-10": 8
}
}
]
}
],
So, basically, each hour they log needs to belong to a specific user. Not really sure how I can traverse my v-model. Any insights? I need to have my v-model work so it responds to each unique input value in the grid, and populates that value with the respective date + the input value.
javascript postgresql vue.js
asked Nov 22 '18 at 12:51
erikvmerikvm
3619
add a comment |
I'm trying to build an application where users can track their hours worked per day by logging numbers in a grid system. It looks something like this: https://jsfiddle.net/L5u1fc0a/130/ - if you try to add some numbers in any "cell", you'll see that it populates the JSON below like this:
[
{
"name": "Erik",
"times": {
"2018-10-01": "10"
}
}
]
I wish to transform my v-model so it work nicely with my PostgreSQL database, where I got two tables, one for users, and another table for hours logged. The data represented in my database looks something like this:
"userdata": [
{
"id": 2,
"firstname": "Joe",
"lastname": "Bergsen",
"email": "joe@berg.com",
"hour": [
{
"id": 1,
"user_id": 2,
"userinput": {
"2018-10-10": 8
}
}
]
}
],
So, basically, each hour they log needs to belong to a specific user. Not really sure how I can traverse my v-model. Any insights? I need to have my v-model work so it responds to each unique input value in the grid, and populates that value with the respective date + the input value.
javascript postgresql vue.js
asked Nov 22 '18 at 12:51
erikvmerikvm
3619
I'm trying to build an application where users can track their hours worked per day by logging numbers in a grid system. It looks something like this: https://jsfiddle.net/L5u1fc0a/130/ - if you try to add some numbers in any "cell", you'll see that it populates the JSON below like this:
[
{
"name": "Erik",
"times": {
"2018-10-01": "10"
}
}
]
I wish to transform my v-model so it work nicely with my PostgreSQL database, where I got two tables, one for users, and another table for hours logged. The data represented in my database looks something like this:
"userdata": [
{
"id": 2,
"firstname": "Joe",
"lastname": "Bergsen",
"email": "joe@berg.com",
"hour": [
{
"id": 1,
"user_id": 2,
"userinput": {
"2018-10-10": 8
}
}
]
}
],
So, basically, each hour they log needs to belong to a specific user. Not really sure how I can traverse my v-model. Any insights? I need to have my v-model work so it responds to each unique input value in the grid, and populates that value with the respective date + the input value.
javascript postgresql vue.js
javascript postgresql vue.js
asked Nov 22 '18 at 12:51
erikvmerikvm
3619
asked Nov 22 '18 at 12:51
erikvmerikvm
3619
asked Nov 22 '18 at 12:51
erikvmerikvm
3619
asked Nov 22 '18 at 12:51
erikvmerikvm
3619
asked Nov 22 '18 at 12:51
erikvmerikvm
3619
3619
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53431451%2ftimetracking-grid-system-in-vue-js-to-work-with-postgresql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53431451%2ftimetracking-grid-system-in-vue-js-to-work-with-postgresql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
