Timezone issue for Start Date in map/reduce || RESOLVED THE ISSUE

PHOTO

Thu Jan 19 2023 08:40:20 GMT+0000 (Coordinated Universal Time)

/**
     * @author Anirban Gupta (Huron)
     * @NApiVersion 2.1
     * @NScriptType UserEventScript
     * @NModuleScope SameAccount
     * @NAmdConfig /SuiteScripts/Library/requireConfig.json
     */
/**
     * Module Description
     * Script to adjust Date and Time to be entered from the User's end if the User's Timezone and Server's Timezone does not match.
     *
     *  Version   Date           Author              Comments
     *  1.0       18 Jan 2023    Anirban Gupta       Script Created.
     *
 */

define(['N/runtime', 'N/format', 'N/config', 'moment', 'moment-timezone'], function (runtime, format, config, moment, momentTz) {
    /**
     * Function definition to be triggered before record is submitted.
     *
     * @param {Object} context - Context
     * @Since 2015.2
     */
    function beforeSubmit(context) {
        log.audit('UE Type', context.type);
        log.audit('Execution Context', runtime.executionContext);
        let userObj = runtime.getCurrentUser();
        log.audit('User', 'User Internal ID:' + userObj.id);

        if (isSupportedUserEventType(context) && isSupportedContext()) {
            try {
                let userTimezone = userObj.getPreference({
                    name: 'timezone'
                });
                log.debug('Timezone', 'User preference for timezone: ' + userTimezone);

                let serverConfigurationRecord = config.load({
                    type: config.Type.COMPANY_INFORMATION
                });

                /* Fetching Server Timezone */
                let serverTimeZone = serverConfigurationRecord.getValue('timezone');
                log.debug('TimeZone', 'Server timezone: ' + serverTimeZone);

                /* If User's Timezone is not the same as the server's Timezone - we are manipulating the Date/Time to be set */
                if (userTimezone !== serverTimeZone) {
                    let startdate = context.newRecord.getValue('startdate');
                    let originalTime = format.parse({
                        value: startdate,
                        type: format.Type.DATETIME,
                        timezone: userTimezone
                    });
                    log.debug('Original Time', 'Original Time: ' + originalTime);
                    let originalDateInMomentFormat = parseInt(originalTime.getFullYear()) + '-' + (originalTime.getMonth() + 1) + '-' + parseInt(originalTime.getDate());

                    /* Calculating difference between Server's Timezone and User's Timezone */
                    let timeDifferenceInMinutes = momentTz(originalDateInMomentFormat).tz(userTimezone).utcOffset() - momentTz(originalDateInMomentFormat).tz(serverTimeZone).utcOffset();

                    /* Sometimes an entire day's minutes (1440) is added to the difference when we are calculating offset between a non-DST timezone and a DST timezone on the DST shift day, hence we are recalculating to get the correct difference */
                    while (timeDifferenceInMinutes > 1440) {
                        timeDifferenceInMinutes -= 1440;
                    }
                    while (timeDifferenceInMinutes < -1440) {
                        timeDifferenceInMinutes += 1440;
                    }

                    /* Adding the difference between the Server's Timezone and User's Timezone to the Date/Time set by the User */
                    let adjustedUserDateTime = new Date(momentTz(originalDateInMomentFormat).add(timeDifferenceInMinutes, 'minutes').tz(userTimezone).toISOString());

                    /* Preparing Date */
                    let adjustedUserDate = (adjustedUserDateTime.getMonth() + 1) + '/' + parseInt(adjustedUserDateTime.getDate()) + '/' + parseInt(adjustedUserDateTime.getFullYear());
                    let formattedAdjustedDate = format.parse({ value: adjustedUserDate, type: format.Type.DATE });
                    log.debug('Adjusted User Date', adjustedUserDate);

                    /* Preparing Time */
                    let adjustedUserTime = moment(adjustedUserDateTime).format("hh:mm a");
                    log.debug('Adjusted User Time', adjustedUserTime);

                    context.newRecord.setValue('startdate', formattedAdjustedDate);
                    context.newRecord.setText('starttime', adjustedUserTime);

                    log.audit('Adjusted Date', 'Adjusted Date And Time is:' + adjustedUserDateTime);
                }
            } catch (error) {
                log.debug("Error", error.name + ' ' + error.message + ' ' + error.stack);
            }
        }
    }

    let isSupportedUserEventType = (context) => {
        let UserEventType = context.UserEventType;
        return [UserEventType.CREATE, UserEventType.EDIT, UserEventType.XEDIT].indexOf(context.type) > -1;
    };

    // Does not support Webstore and RESTlet
    let isSupportedContext = () => {
        let ContextType = runtime.ContextType;

        return [
            ContextType.CLIENT,
            ContextType.CSV_IMPORT,
            ContextType.USEREVENT,
            ContextType.USER_INTERFACE,
            ContextType.WORKFLOW].indexOf(runtime.executionContext) > -1;
    };

    return {
        beforeSubmit: beforeSubmit
    };
});

COPY

Save snippets that work from anywhere online with our extensions

Comments

SUITESCRIPT (NETSUITE)

@mdfaizi

SAVED SEARCH DATE FORMAT(page wise) AND LOOP THROUGH EACH DATA || With Pagination || Avoids 4000 data Limt Rest in Suitlet CALL ANOTHER SCRIPT | SUITELET FROM ANY OTHER SCRIPT | SUITELET | ALSO PASSING OF PARAMETERS CALLING RESTLET |FROM SUITELET Where Is The “IF” Statement In A Saved Search Formula? – > script everything Where Is The “IF” Statement In A Saved Search Formula? – > script everything ClientScript Add Sublist Line items etc Saving Record In different way. BFO AND FREEMarkup || advance pdf html template Join In Lookup Field Search || Alternative of saved search Use Saved Serch or Lookup field search for Getting value or id of Fields not visible On UI or xml https://www.xmlvalidation.com/ XML Validate Load Record--->selectLine--->CommitLine--->Save [Set Sublist field Data After Submit] Null Check Custom Check SEND MAIL WITH FILE ATTACHED EXECUTION CONTEXT || runtime.context In BeforeLoad Use This When Trying to Get Value In BeforeLoad Convert String Into JSON Freemarker Below 2.3.31 use ?eval || above use ?eval_json Design Of Full Advance PDF Template using Suitescript PART 1: Design Of Full Advance PDF Template using Suitescript PART 2: Iterate Through Complex Nested JSON Object Freemarker || BFO || Advance PDF HTML Template WORKING JSON OBJ ITERATE FreeMarker get String convert to JSON ,Iterate through it ,Print Values In Table Series Addition Freemarker Using Loop(List) Modified Null Check || Keep Updated One Here Navigations In Netsuite || Records || etc DATE FORMAT Netsuite Javascript Transform Invoice To Credit Memo NULLCHECK Freemarker||BFO|| XML||Template Before Accessing Any Value Refresh Page Without Pop Up | | client script || Reload Page Easy Manner To Format Date || Date to simple Format || MM/DD/YYYY Format ||Simple Date CUSTOM ERROR MESSAGE CREATE HOW TO STOP MAP/REDUCE SCRIPT RUNNING FILTER ON JSON OBJECT SAVED SEARCH CRITERIA LOGIC FOR WITHIN DATE | | WITHIN START DATE END DATE TO GET Line no. also of Error NETSUITE SERVER TIMEZONE : (GMT-05:00) Eastern Time (US & Canada) || Problem resolved for Map/reduce Timezone issue for Start Date in map/reduce || RESOLVED THE ISSUE compare/check date that it lies between two dates or not || Use of .getTime() object of Date TO FIND ALL TASKS WITHIN SO START DATE AND END DATE || SAVED SEARCH CODE WORDS Saved Search Get only one Result || getRange netsuite - SuiteScript 2.0 Add filters to saved search in script - Stack Overflow || Addition in saved search filter MASS DELETE ALL RCORD FROM SAVED SEARCH DATA IN PARAMETER|| ADD SS IN THE DEPLOYMENT PARAMETER SAVED SEARCH DATE COMPARE AND GET RESULT IN DAYS HOURS MINUTES Multiple Formula Columns Comment In Saved Search || Saved search used SQL language for writing formula Logic Set Addressbook Values || Addressbook is a subrecord SuiteQL || N/Query Module || Support SQL query VALIDATE 2 DATES LIE BETWEEN 2 DATES OR NOT || OVERLAPPING CASE ALSO Weeks Within two dates:

#html #javascript #nodejs

How to Save HTML Form Data in JSON - Express

<form action="/new" method="post">
 
  <input name="title" type="text">
  <input name="description" type="text">
  <button type="submit">Submit Form</button>
 
</form>

> More steps

#javascript

Get URL and URL Parts in JavaScript

var newURL = window.location.protocol + "//" + window.location.host + "/" + window.location.pathname + window.location.search

#javascript

Add event listener to multiple buttons with the same class

    btns = document.getElementsByClassName("saveBtn");
    for (var i = 0; i < btns.length; i++) {
        btns[i].addEventListener("click", function () {
			//Add function here
        });
    }

#javascript

Replace Textarea with Codemirror editor

<link rel="stylesheet" type="text/css" href="plugin/codemirror/lib/codemirror.css">

<body>
	<textarea class="codemirror-textarea"></textarea>
</body>

<script>

$(document).ready(function(){
    var codeText = $(".codemirror-textarea")[0];
    var editor = CodeMirror.fromTextArea(codeText, {
        lineNumbers : true
    });
});

</script>

<script type="text/javascript" src="plugin/codemirror/lib/codemirror.js"></script>

#javascript #nodejs #commandline

HTTPS Redirect in Nodejs

npm install heroku-ssl-redirect

> More steps

#javascript #nodejs

Save to MongoDB without Duplicates Using Mongoose

var mongoose = require('mongoose');
var Schema = mongoose.Schema;

const exampleSchema = new Schema({
    title: { type: String , required: true},
    content: [{type: String}]
});


var Example = mongoose.model('Example', exampleSchema);
module.exports = Example;

> More steps

#html #javascript #jsfunctions #dom #dommanipulation

getAttribute() - how to get the value of any attribute of HTML element

<html>

<input id="contact" name="address">

<script>

    var x = document.getElementById("contact").getAttribute('name');

</script>

</html>

#javascript

Full Stack Developer

function full_stack_developer() {
    full_stack_developer();
}

#javascript #javascript #functions #parameters

Required Parameters for Functions in JavaScript

 const isRequired = () => { throw new Error('param is required'); };

const hello = (name = isRequired()) => { console.log(`hello ${name}`) };

// These will throw errors
hello();
hello(undefined);

// These will not
hello(null);
hello('David');
The idea here is that it uses default parameters, like how the b parameter here has a default if you don’t send it anything:
function multiply(a, b = 1) {
  return a * b;
}

#javascript

3 Ways To Detect Selenium Bots Using Javascript - CodingTutz

if (navigator.webdriver) {
    document.body.innerHTML = "This is a Bot";
}

#javascript

Copy Text to Clipboard with Line Breaks

function copyToClipboard(){

    var codeToBeCopied = document.getElementById('code-snippet').innerText;
    var emptyArea = document.createElement('TEXTAREA');
    emptyArea.innerHTML = codeToBeCopied;
    const parentElement = document.getElementById('post-title');
    parentElement.appendChild(emptyArea);

    emptyArea.select();
    document.execCommand('copy');

    parentElement.removeChild(emptyArea);
    M.toast({html: 'Code copied to clipboard'})

    }

#javascript #promises #howto

How to Get the Domain From A URL Using Javascript

var url = "http://scratch99.com/web-development/javascript/";
var urlParts = url.replace('http://','').replace('https://','').split(/[/?#]/);
var domain = urlParts[0];

#javascript

Mapping an Object

const object1 = {
  a: 'somestring',
  b: 42
};

for (let [key, value] of Object.entries(object1)) {
  console.log(`${key}: ${value}`);
}

#javascript #jquery

jQuery.post() - AJAX for post requests

$.ajax({
  type: "POST",
  url: url,
  data: data,
  success: success,
  dataType: dataType
});

#javascript

How to store fetch response in javascript variable - Stack Overflow

async function fun() {
  return fetch('https://jsonplaceholder.typicode.com/todos/1').then(res => res.json());
}

const data  = await fun();

Timezone issue for Start Date in map/reduce || RESOLVED THE ISSUE

Save snippets that work from anywhere online with our extensions

Comments

More like this

SUITESCRIPT (NETSUITE)

Browse more snippets >>

Timezone issue for Start Date in map/reduce || RESOLVED THE ISSUE

Save snippets that work from anywhere online with our extensions

Comments

More like this

SUITESCRIPT (NETSUITE)

Browse more snippets >>

Embed code snippet