erevna-services - npm Package Compare versions

Comparing version 1.2.11 to 1.3.0

constanta.js

 module.exports = {
+    'localstorage-gdoc-sync-rayasem-kemendagri-datalocation':'localstorage-gdoc-sync-rayasem-kemendagri-datalocation',
+    'localstorage-property-trx-type-synonym':'property-trx-type-synonym',
+    'localstorage-location':'localstorage-location',
+    'localstorage-locationv2':'localstorage-locationv2',
+    'property-trx-type-synonym':'property-trx-type-synonym',
+    'localstorage-partner-synonym':'localstorage-partner-synonym',
     'localstorage-property-types-synonym':'property-types-synonym',
-    'localstorage-property-trx-type-synonym':'property-trx-type-synonym',
+    'localstorage-location-synonym':'localstorage-location-synonym',
     'localstorage-gdoc-sync-sheet-5':'localstorage-gdoc-sync-sheet-5',
-    'localstorage-gdoc-sync-sheet-6':'localstorage-gdoc-sync-sheet-6'
+    'localstorage-gdoc-sync-sheet-6':'localstorage-gdoc-sync-sheet-6',
+    'property_index_name':'property_v13',
+    'localstorage-gdoc-sync-rayasem-translate-sheet-1':'localstorage-gdoc-sync-rayasem-translate-sheet-1',
 }

index.js

@@ -5,2 +5,3 @@ var LocalStorage = require('node-localstorage').LocalStorage;
 const service_synonymService = require('./services/synonymService');
+const script_gdocsync = require('./script/gdocsync');
 const gdoc_sync_service =  require('./services/googleSpreadsheetSyncService');
@@ -16,1 +17,3 @@
 module.exports.getLocalstorage = service_localstorage.getLocalstorage;
+module.exports.constanta = require('./constanta');
+module.exports.gdocsync = script_gdocsync;

package.json

 {
   "name": "erevna-services",
-  "version": "1.2.11",
+  "version": "1.3.0",
   "description": "modul untuk produk erevna",
@@ -5,0 +5,0 @@ "main": "index.js",

services/googleSpreadsheetSyncService.js

 var GoogleSpreadsheet = require('google-spreadsheet');
 var async = require('async');
 var LocalStorage = require('node-localstorage').LocalStorage;
-localStorage = new LocalStorage('./scratch');
 const constanta = require('../constanta');
@@ -12,2 +11,3 @@
 function run(options){
+    const localStorage = new LocalStorage(options.dataLocation || './scratch');
 
@@ -14,0 +14,0 @@ //cek mandatory

test.js

 var index = require('./index');
 var assert = require('assert');
+//const job = require('./job');
+var script_gdocsync = require('./script/gdocsync');
 
@@ -242,3 +244,133 @@ function unit_test_1(){
 
-unit_test_1();
+
+var datalocationv2 = function(cells, currentDataRow){
+    //npm run gdocsync -- -minrow=1 -maxrow=3 -sheetnumber=0 -gdoc=1PyMqH5ts4g-I_19q8awi09yL00iFk404RdtRTXX-OEE -storagekey=localstorage-locationv2 -job=datalocationv2
+    var list=[];
+    var tempRow = '';
+    var theKey = '';
+    var dataJson = {};
+    var dataRow = currentDataRow || {};
+    var lang = '';
+
+    var keyLevel1='';
+    var keyLevel2='';
+    var keyLevel3='';
+    var keyLevel4='';
+
+    var level1_lat='';
+    var level2_lat='';
+    var level3_lat='';
+    var level4_lat='';
+
+    var level1_long='';
+    var level2_long='';
+    var level3_long='';
+    var level4_long='';
+    cells.forEach(function(v,k){
+                        if(v.col < 17 && v.row > 1 && v.value!=''){
+        //                    if(tempRow != v.row){
+
+                                if(v.col==1 && keyLevel1 != v.value && v.value != ''){
+                                    keyLevel1 = v.value;
+                                    keyLevel1 = keyLevel1.toLowerCase();
+                                    dataRow[keyLevel1] = dataRow[''+keyLevel1] || {};
+                                    dataRow[keyLevel1]['name'] = keyLevel1;
+                                }
+                                if(v.col==3){
+                                    if(v.value != '') level1_lat = v.value;
+        //                            dataRow[keyLevel1] = dataRow[''+keyLevel1] || {};
+                                    dataRow[keyLevel1]['lat'] = level1_lat;
+                                }
+                                if(v.col==4){
+                                    if(v.value != '') level1_long = v.value;
+        //                            dataRow[''+keyLevel1] = dataRow[''+keyLevel1] || {};
+                                    dataRow[''+keyLevel1]['long'] = level1_long;
+                                }
+                                if(v.col==5 && keyLevel2 != v.value && v.value != ''){
+                                    keyLevel2 = v.value;
+                                    keyLevel2 = keyLevel2.toLowerCase();
+                                    dataRow[keyLevel1+'-'+keyLevel2] = dataRow[keyLevel1+'-'+keyLevel2] || {};
+                                    dataRow[keyLevel1+'-'+keyLevel2]['name'] = keyLevel2;
+                                }
+                                if(v.col==7){
+                                    if(v.value != '') level2_lat = v.value;
+        //                            dataRow[keyLevel1][keyLevel2] = dataRow[keyLevel1][keyLevel2] || {};
+                                    dataRow[keyLevel1+'-'+keyLevel2]['lat'] = level2_lat;
+                                }
+                                if(v.col==8){
+                                    if(v.value != '') level2_long = v.value;
+        //                            dataRow[keyLevel1][''+keyLevel2] = dataRow[keyLevel1][''+keyLevel2] || {};
+                                    dataRow[keyLevel1+'-'+keyLevel2]['long'] = level2_long;
+                                }
+                                if(v.col==9 && keyLevel3 != v.value && v.value != ''){
+                                    keyLevel3 = v.value;
+                                    keyLevel3 = keyLevel3.toLowerCase();
+                                    dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3] = dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3] || {};
+                                    dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3]['name'] = keyLevel3;
+                                }
+                                if(v.col==11){
+                                    if(v.value != '') level3_lat = v.value;
+        //                            dataRow[keyLevel1][''+keyLevel2][keyLevel3] = dataRow[keyLevel1][''+keyLevel2][keyLevel3] || {};
+                                    dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3]['lat'] = level3_lat;
+                                }
+                                if(v.col==12){
+                                    if(v.value != '') level3_long = v.value;
+        //                            dataRow[keyLevel1][''+keyLevel2][keyLevel3] = dataRow[keyLevel1][''+keyLevel2][keyLevel3] || {};
+                                    dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3]['long'] = level3_long;
+                                }
+                                if(v.col==13 && keyLevel4 != v.value && v.value != ''){
+                                    keyLevel4 = v.value;
+                                    keyLevel4 = keyLevel4.toLowerCase();
+                                    dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3+'-'+keyLevel4] = dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3+'-'+keyLevel4] || {};
+                                    dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3+'-'+keyLevel4]['name'] = keyLevel4;
+                                }
+                                if(v.col==15){
+                                    if(v.value != '') level4_lat = v.value;
+        //                            dataRow[keyLevel1][''+keyLevel2][keyLevel3][keyLevel4] = dataRow[keyLevel1][''+keyLevel2][keyLevel3][keyLevel4] || {};
+                                    dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3+'-'+keyLevel4]['lat'] = level4_lat;
+                                }
+                                if(v.col==16){
+                                    if(v.value != '') level4_long = v.value;
+        //                            dataRow[keyLevel1][''+keyLevel2][keyLevel3][keyLevel4] = dataRow[keyLevel1][''+keyLevel2][keyLevel3][keyLevel4] || {};
+                                    dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3+'-'+keyLevel4]['long'] = level4_long;
+                                }
+
+                                if(tempRow != v.row && v.value != ''){
+                                    tempRow = v.row;
+                                    theKey = v.value;
+                                    theKey = theKey.toLowerCase();
+
+                                }
+        //                        if(v.col==3) lang = 'en';
+        //                        var val = v.value;
+        ////                        val = val.toLowerCase();
+
+
+                            console.log('Cell R'+v.row+' C'+v.col+' = '+v.value);
+                        }
+                    });
+
+    dataJson = dataRow;
+    return dataJson;
+}
+
+function unit_test_6(){
+    console.log('unit_test_6 invoked');
+    script_gdocsync.execute([
+        "-minrow=1",
+        "-maxrow=5",
+        "-sheetnumber=0",
+        "-gdoc=1PyMqH5ts4g-I_19q8awi09yL00iFk404RdtRTXX-OEE",
+        "-storagekey=localstorage-locationv2",
+        "-datalocation=/Users/opetstudio/AdventistEducation",
+    ], require('./service-account-creds.json'), datalocationv2);
+//    const translations = index.getLocalstorage('localstorage-gdoc-sync-rayasem-translate-sheet-1');
+//    var actual = translations['en']['title-location'];
+//    var expected = 'location';
+//    var message = 'expected='+expected+'|but='+actual;
+//    assert.equal(actual, expected, message);
+//    console.log('unit_test_5 OK');
+}
+
+//unit_test_1();
 //unit_test_2();
@@ -248,1 +380,3 @@ //unit_test_3();
 //unit_test_5();
+unit_test_6();
+

No alert changes

Improved metrics

Total package byte prevSize

2672556

increased by0.98%

Number of package files

16

increased by14.29%

Lines of code

1422

increased by55.07%

No dependency changes