1
2
3
4
5
|
$(
"#spreadsheet"
).kendoSpreadsheet({
sheets: [{
name:
"sheet1"
}]
});
|
1
2
3
4
5
6
7
|
var
fileId = getQueryString(
'file_id'
);
if
(fileId) {
sessionStorage.setItem(
'File_ID'
, fileId);
}
else
{
sessionStorage.removeItem(
'File_ID'
);
}
|
1
2
3
4
5
6
7
8
9
|
function
getFileContentById(id) {
socket.emit(
"useredit"
, { FileId: id, UserID: userObj.UserID });
$.get(
'/file/content/'
+ id,
function
(result) {
$(
"#current_fileName"
).text(result.fullname);
if
(result && result.content) {
$(
"#spreadsheet"
).data(
"kendoSpreadsheet"
).fromJSON(JSON.parse(result.content));
}
})
}
|
1
2
3
4
5
6
|
router.get(
'/file/content/:id'
, fileRoutes.getFileContent)
exports.getFileContent =
function
(req, res) {
fileModel.findById(req.params.id).select(
'name content'
).exec(
function
(error, doc) {
res.json(doc);
});
}
|
1
2
3
4
5
6
7
8
9
10
11
12
|
$(
"#btn_Save"
).click(
function
() {
var
id = sessionStorage.getItem(
'File_ID'
);
var
content = $(
"#spreadsheet"
).data(
"kendoSpreadsheet"
).toJSON();
$.post(
'/file/content'
, { postData: JSON.stringify({ id: id, content: content, user: userObj }) },
function
(result) {
if
(result.isSuc) {
showMsg(
'success'
,
'Saved Successfully!'
);
}
else
{
showMsg(
'error'
, result.msg);
}
});
});
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
router.post(
'/file/content'
, fileRoutes.saveFileContent)
exports.saveFileContent =
function
(req, res) {
var
data = JSON.parse(req.body.postData);
var
fileId = data.id;
var
fileContent = data.content;
fileModel.findByIdAndUpdate(fileId, {
$set: {
content: JSON.stringify(fileContent),
lasteditdate: Date.now(),
lastedituserid: data.user.UserID,
lastedituser: data.user.FullName
}
},
function
(error, result) {
if
(error) {
res.json({ isSuc:
false
, msg: error.message });
return
;
}
res.json({ isSuc:
true
});
});
}
|
1
2
|
app.use(bodyParser.json({ limit:
'5mb'
}));
app.use(bodyParser.urlencoded({ limit:
'5mb'
, extended:
true
}));
|