By filling this templates provided, we can import data to Good books.
Note: No changes should be made on file type or details provided in the sheet.Just fill correct data on particulars....
Maintenance- To download Accounts Data Template click on Accounts button
- To download Stores Data Template click on Stores button
- To download Payroll Data Template click on Payroll button
- To download Maintenance Data Template click on Maintenance button
Contents
Revisions
- June 22, 2019 @ 05:33:36 [Current Revision] by arul
- June 22, 2019 @ 05:33:36 by vv
- June 22, 2019 @ 05:32:37 by vv
- June 22, 2019 @ 05:30:33 by vv
- June 22, 2019 @ 05:30:07 [Autosave] by vv
- November 8, 2017 @ 10:09:43 by vv
- November 8, 2017 @ 09:48:07 by vv
- November 8, 2017 @ 09:12:19 by vv
- November 8, 2017 @ 07:20:12 by vv
- November 7, 2017 @ 13:05:07 by vv
- November 7, 2017 @ 07:51:39 by vv
- November 7, 2017 @ 07:39:39 by vv
- November 7, 2017 @ 07:16:09 by vv
- October 26, 2017 @ 07:38:45 by arul
- October 10, 2017 @ 07:51:52 by arul
- October 10, 2017 @ 07:39:39 by arul
- October 10, 2017 @ 07:39:28 [Autosave] by arul
- August 31, 2017 @ 07:40:59 by arul
- August 31, 2017 @ 07:36:52 by arul
- August 31, 2017 @ 07:35:36 by arul
- August 31, 2017 @ 07:30:48 by arul
- August 31, 2017 @ 07:29:15 by arul
- August 31, 2017 @ 07:14:32 by arul
- August 31, 2017 @ 06:55:18 by arul
- August 31, 2017 @ 06:53:58 by arul
- August 31, 2017 @ 06:36:57 by arul
- August 31, 2017 @ 04:54:45 by arul
- August 31, 2017 @ 04:53:29 by arul
- August 31, 2017 @ 04:40:50 by arul
- August 31, 2017 @ 04:40:24 by arul
- August 31, 2017 @ 04:39:52 by arul
- August 31, 2017 @ 04:39:13 by arul
- August 31, 2017 @ 04:36:59 by arul
- August 31, 2017 @ 04:33:05 by arul
- August 31, 2017 @ 04:31:49 by arul
- August 31, 2017 @ 04:30:42 by arul
- August 31, 2017 @ 04:28:25 by arul
- August 31, 2017 @ 04:25:04 by arul
- August 31, 2017 @ 04:22:20 by arul
- August 31, 2017 @ 04:21:33 by arul
- August 31, 2017 @ 04:21:18 by arul
- August 31, 2017 @ 04:20:47 by arul
- August 31, 2017 @ 04:20:34 by arul
- August 31, 2017 @ 04:20:05 by arul
- August 31, 2017 @ 04:18:09 by arul
- August 30, 2017 @ 13:14:09 by arul
- August 30, 2017 @ 13:12:28 by arul
- August 30, 2017 @ 13:11:42 by arul
- August 30, 2017 @ 13:10:06 by arul
- August 30, 2017 @ 13:01:06 by arul
- August 30, 2017 @ 13:00:06 by arul
- August 30, 2017 @ 12:58:59 by arul
- August 30, 2017 @ 12:51:46 by arul
- August 30, 2017 @ 12:44:13 by arul
- August 30, 2017 @ 12:37:13 by arul
- August 30, 2017 @ 12:32:19 by arul
- August 30, 2017 @ 12:28:57 by arul
- August 30, 2017 @ 12:24:24 by arul
- August 30, 2017 @ 12:19:43 by arul
- August 30, 2017 @ 12:14:39 by arul
- August 30, 2017 @ 11:56:07 by arul
- August 30, 2017 @ 11:10:24 by arul
- August 30, 2017 @ 10:56:47 by arul
- August 30, 2017 @ 10:35:14 by arul
- August 30, 2017 @ 09:47:51 by arul
- August 30, 2017 @ 09:46:47 by arul
- August 30, 2017 @ 09:17:39 by arul
- August 30, 2017 @ 09:09:58 by arul
- August 30, 2017 @ 09:09:25 by arul
- August 30, 2017 @ 07:31:39 by arul
- August 30, 2017 @ 07:27:09 by arul
- August 30, 2017 @ 07:10:57 by arul
- August 30, 2017 @ 07:06:01 by arul
- August 30, 2017 @ 07:01:49 by arul
- August 30, 2017 @ 06:58:45 by arul
- August 30, 2017 @ 06:52:54 by arul
- August 30, 2017 @ 06:30:26 by arul
- August 30, 2017 @ 06:29:54 by arul
- August 29, 2017 @ 13:46:18 by arul
- August 29, 2017 @ 13:45:46 by arul
- August 29, 2017 @ 13:43:28 by arul
- August 29, 2017 @ 13:42:13 by arul
- August 29, 2017 @ 13:37:02 by arul
- August 29, 2017 @ 13:30:54 by arul
- August 29, 2017 @ 13:30:28 by arul
- August 29, 2017 @ 13:29:25 by arul
- August 29, 2017 @ 13:28:12 by arul
- August 29, 2017 @ 13:26:00 by arul
- August 29, 2017 @ 13:22:29 by arul
- August 29, 2017 @ 12:15:57 by arul
- August 29, 2017 @ 11:26:03 by arul
- August 29, 2017 @ 11:24:50 by arul
- August 29, 2017 @ 11:24:25 by arul
- August 29, 2017 @ 11:21:46 by arul
- August 29, 2017 @ 11:07:55 by arul
- August 29, 2017 @ 10:55:44 by arul
Revision Differences
August 29, 2017 @ 11:24:25 | Current Revision | ||
---|---|---|---|
Content | |||
Deleted: define([ | |||
Deleted: "dojo/_base/xhr", | |||
Deleted: "dojo/query", | |||
Deleted: "dojo/_base/declare", | |||
Deleted: "dojo/_base/fx", | |||
Deleted: "dojo/_base/lang", | |||
Deleted: "dijit/_WidgetBase", | |||
Deleted: "dijit/_TemplatedMixin", | |||
Deleted: "dijit/_WidgetsInTemplateMixin", | |||
Deleted: "dijit/registry", | |||
Deleted: "dojo/topic", | |||
Deleted: "dojo/dom-attr", | |||
Deleted: ], function (xhr, query, declare, baseFx, lang, _WidgetBase, _TemplatedMixin, WidgetsInTemplateMixin, registry, topic, domAttr) { | |||
Deleted: return declare([_WidgetBase, _TemplatedMixin, WidgetsInTemplateMixin], { | |||
Deleted: templateString: templatestring(), | |||
Deleted: buildRendering: function () { | |||
Deleted: this.inherited(arguments); | |||
Deleted: }, | |||
Deleted: postCreate: function () { | |||
Deleted: this.inherited(arguments); | |||
Deleted: this.ReportStart( this.store.ReportDetail); | |||
Deleted: }, | |||
Deleted: ReportStart: function (data) { | |||
Deleted: console.log(JSON.stringify(data)); | |||
Deleted: var controller = "#content_" + this.id; | |||
Deleted: var tfoot = "#tfoot_" + this.id; | |||
Deleted: var Total1 = "#Total1_" + this.id; | |||
Deleted: $(controller).html(""); | |||
Deleted: alert(JSON.stringify(data)); | |||
Deleted: var detail = data.length; | |||
Deleted: if (detail < 10) { | |||
Deleted: var sm = "#scrollingtable_" + this.id; | |||
Deleted: $(sm).addClass( "height_less"); | |||
Deleted: } | |||
Deleted: for (var v in data) { | |||
Deleted: if (v == 0) { | |||
Deleted: | |||
Deleted: $(controller) .append(addDaterow(data[v], this.id)); | |||
Deleted: $(controller) .append(addrow(data[v], this.id)); | |||
Deleted: $(Total1).append( addTotal1(data[0], this.id)); | |||
Deleted: } else { | |||
Deleted: if (data[v].ReasonId == data[v - 1].ReasonId) { | |||
Deleted: if (data[v].EmployeeId == data[v - 1].EmployeeId) { | |||
Deleted: $(controller) .append(addrow(data[v], this.id)); | |||
Deleted: } else { | |||
Deleted: //$(controller) .append(addHeadrow( data[v],this.id)); | |||
Deleted: $(controller) .append(addrow(data[v], this.id)); | |||
Deleted: } | |||
Deleted: } else { | |||
Deleted: $(controller) .append(addDaterow(data[v], this.id)); | |||
Deleted: //$(controller) .append(addHeadrow( data[v],this.id)); | |||
Deleted: $(controller) .append(addrow(data[v], this.id)); | |||
Deleted: } | |||
Deleted: } | |||
Deleted: } | |||
Deleted: //$(tfoot).html( addFooter()); | |||
Deleted: runTooltips(); | Added: | ||
Deleted: /*----------- ------------- ---------------EVENT PUBLISH CODING------- ------------- ------------ ----------------*/ | |||
Deleted: OverTime = function (dataid, self, type) { | |||
Deleted: switch (type) { | |||
Deleted: case 0: | |||
Deleted: topic.publish( "Payroll/Report/ attendance/Name", { | |||
Deleted: id: dataid, | |||
Deleted: sourcedata: self | |||
Deleted: }); | |||
Deleted: break; | |||
Deleted: case 1: | |||
Deleted: topic.publish( "Payroll/Report/attendance/ Overtimeentry", { | |||
Deleted: id: dataid, | |||
Deleted: sourcedata: self | |||
Deleted: }); | |||
Deleted: break; | |||
Deleted: case 2: | |||
Added: <div class="w3-container" ><strong><span id=":sv.co" class="tL8wMe EMoHub" dir="ltr">By filling this templates provided, we can import data to Good books.</span></strong> | |||
Added: <strong>Note:</strong> No changes should be made on file type or details provided in the sheet.Just fill correct data on particulars.... | |||
Added: <ul> | |||
Added: <li>To download Accounts Data Template click on Accounts button</li> | |||
Added: <li>To download Stores Data Template click on Stores button</li> | |||
Added: <li>To download Payroll Data Template click on Payroll button</li> | |||
Added: <li>To download Maintenance Data Template click on Maintenance button</li> | |||
Added: </ul> | |||
Added: | |||
Added: <a class="w3-button w3-indigo" style="text-decoration: none; width: 200px;" href="http:// help.goodbookserp.com/?p= 8456">Accounts</a> | |||
Added: <a class="w3-button w3-deep-orange" style="text-decoration: none; width: 200px;" href="http:// help.goodbookserp.com/?p= 8470">Stores</a> | |||
Added: <a class="w3-button w3-teal" style="text-decoration: none; width: 200px;" href="http:// help.goodbookserp.com/?p= 8474">Payroll</a></div> | |||
Deleted: topic.publish( "Payroll/Report/attendance/ EmployeeName", { | Added: <a href="http:// help.goodbookserp.com/?p= 11240">Maintenance</a> | ||
Deleted: id: dataid, | |||
Deleted: sourcedata: self | |||
Deleted: }); | |||
Deleted: break; | |||
Deleted: default: | |||
Deleted: break; | |||
Deleted: } | |||
Deleted: } | |||
Deleted: /*----------- ------------- ---------------SELF SUBSCRIBER CODING------- ------------- ------------ ----------------*/ | |||
Deleted: topic.subscribe( "Payroll/Report/attendance/ Overtimeentry", function (e) { | |||
Deleted: console.log(e.id); | |||
Deleted: ReportHyperlink(Reason, e.id, -1, 1); | |||
Deleted: }); | |||
Deleted: topic.subscribe( "Payroll/Report/attendance/ EmployeeName", function (e) { | |||
Deleted: employeelightbox(e.id); | |||
Deleted: }); | |||
Deleted: | |||
Deleted: topic.subscribe( "Payroll/Report/ attendance/Name", function (e) { | |||
Deleted: var sourcedata = registry.byNode( e.sourcedata) .params.store.ReportCriteria; | |||
Deleted: var temptodate = JSONDateToFormat( GLOBAL_userdetail.WorkPeriodToDate, "dd/mmm/yyyy"); | |||
Deleted: var temp = ToEpochGMT(temptodate); | |||
Deleted: var customcriteria = { | |||
Deleted: "SectionCriteriaList": [{ | |||
Deleted: "SectionId": 0, | |||
Deleted: "AttributesCriteriaList": [{ | |||
Deleted: "FieldName": "EmployeeId", | |||
Deleted: "OperationType": "5", | |||
Deleted: "FieldValue": "" + e.id, | |||
Deleted: "JoinType": "2" | |||
Deleted: }, { | |||
Deleted: "FieldName": "PeriodFromDate", | |||
Deleted: "OperationType": 10, | |||
Deleted: "FieldValue": "" + temp, | |||
Deleted: "JoinType": 0 | |||
Deleted: }, { | |||
Deleted: "FieldName": "PeriodToDate", | |||
Deleted: "OperationType": 11, | |||
Deleted: "FieldValue": "" + temp, | |||
Deleted: "JoinType": 0 | |||
Deleted: } | |||
Deleted: ], | |||
Deleted: "OperationType": 0 | |||
Deleted: } | |||
Deleted: ] | |||
Deleted: }; | |||
Deleted: commonreportlinking( reportmenu.Overtimereport, customcriteria, sourcedata); //linked with statement of account single | |||
Deleted: e.sourcedata = false; | |||
Deleted: }); | |||
Deleted: } | |||
Deleted: }); | |||
Deleted: /*----------- ------------- ------------ ---------HTML DESIGN CODING------- ------------- ------------ --------------------- */ | |||
Deleted: // function addHeadrow(data,self) | |||
Deleted: // { | |||
Deleted: // return '<tr class="LedHead1" style="font:bold 13px open sans;"><td style="width:15%" (' + data.EmployeeId + ','+self+',2);><span style="cursor:default;" > '+ JSONDateToFormat( data.ProductionDate , "dd/mm/yyyy") + '</span></td><td style="width:15%"><span class="group_style" style="cursor:default;" ></span></td><td style="width: 25%"></td><td style="width: 10%"></td><td style="width: 40%"></td></tr>'; | |||
Deleted: // } | |||
Deleted: function addDaterow(data, self) { | |||
Deleted: console.log(data.OverTimeId) | |||
Deleted: return '<tr class="group_style tooltips" ><td style="width:15%" onclick="OverTime(' + data.ReasonTypeId + ',' + self + ',1);"><span class="group_style tooltips" data-original-title="To view Reason Form" data-placement="right">' + data.ReasonCode + '</span></td><td colspan="2" style="width:15%;" onclick="OverTime(' + data.ReasonTypeId + ',' + self + ',0);"><span class="group_style tooltips" data-original-title="To view OverTime report" data-placement="right">' + data.ReasonName + '</span></td><td style="width:10%; text-align:right;"><span class="group_style tooltips" >' + data.TotalStoppageDuration + '</span></td></tr>'; | |||
Deleted: } | |||
Deleted: function addrow(data, self) { | |||
Deleted: var Stoppage = data.StoppageDuration; | |||
Deleted: Stoppage = formattime(Stoppage); | |||
Deleted: // if (JSONDateToFormat( data.StoppageFromDateTime, "h.mm a") <= "12:00") { | |||
Deleted: // var Time = "am"; | |||
Deleted: // } else { | |||
Deleted: // var Time = "pm"; | |||
Deleted: // } | |||
Deleted: | |||
Deleted: return '<tr class="account_ style"><td><span tool-title="OverTime Entry" data-placement= "right"> ' + JSONDateToFormat( data.IndentDate, "dd/mm/yyyy") + '</td><td style="cursor:pointer" onclick="OverTime(' + data.EmployeeId + ',' + self + ',0);"> ' + data.EmployeeCode + '</td><td style="width:20%;" onclick="OverTime(' + data.EmployeeId + ',' + self + ',2);"><span class="account_style tooltips" data-original-title="To view EmployeeLightbox" data-placement="right">' + data.EmployeeName + '</span></td><td style="cursor: pointer;text- align:right; "><span>'+Stoppage+ '</span></td><td style="cursor:pointer;">' + data.Remarks + '</td></tr>'; | |||
Deleted: } | |||
Deleted: function addTotal1(data, self) { | |||
Deleted: var Total1 = data.CallTotalStoppageDuration; | |||
Deleted: return '<b>' + Total1 + '</b>'; | |||
Deleted: } | |||
Deleted: function templatestring() { | |||
Deleted: return '<div class="htmlreport_ outer"><table style="width:100%"><tr style="width: 100%;"><div><td><span class="debit" >   Total Stoppage Duration :  </span><span class="totalValue" id="Total1_${id}" ></span></td></div></tr> </table><div class="scrollingtablegb4" id="scrollingtable_ ${id}"><div>< div><table>< thead><tr><th><div label="Date"></div></th> <th><div label="Emp Code"></div>< /th><th><div label="Emp Name"></div></th><th style="text-align: right;"><div label="Duration" ></div></th><th><div label="Remarks" ></div></th>< /tr></thead><tbody id="content_${id}" ></tbody><tfoot id="tfoot_${id}"></tfoot> </table></div> </div></div></div>'; | |||
Deleted: } | |||
Deleted: }); |
Note: Spaces may be added to comparison text to allow better line wrapping.