Untitled

var AlmHardwareUtils = Class.create();
AlmHardwareUtils.prototype = {
    initialize: function() {},

   updateAssignedToField: function(tableDBView) {
        var count = 0;
        var queryLatestMonth = "";

        if (tableDBView === "u_s1_automapping") {
            var valueLatestMonth = "";
            // get lastest month
            var grS1Maping = new GlideRecord("u_s1_automapping");
            grS1Maping.orderByDesc('s1_sys_created_on');
            grS1Maping.setLimit(1);
            grS1Maping.query();
            while (grS1Maping.next()) {
				valueLatestMonth = grS1Maping.s1_u_created_month.getDisplayValue();
            }

            queryLatestMonth = "^s1_u_created_month=" + valueLatestMonth;
        }


        var queryAssignedToEmpty = "hwr_assigned_toISEMPTY";
        var encodedQuery = queryAssignedToEmpty + queryLatestMonth;

		gs.print("query " + encodedQuery);

        var gr = new GlideRecord(tableDBView);
        gr.addEncodedQuery(encodedQuery);
        gr.query();

        while (gr.next()) {
            var userId = gr.user_sys_id;
            var hardwareSysId = gr.hwr_sys_id;

            var grHardware = new GlideRecord("alm_hardware");
            var hardwareFind = grHardware.get(hardwareSysId);
            if (hardwareFind) {
                count++;
                grHardware.setValue("assigned_to", userId);
                grHardware.update();
            }
        }

        gs.info("AlmHardware Log: " + tableDBView + count);
    },

    convertUsername: function(str) {
        var indexBackslash = str.indexOf("\\");
        var indexAmpersat = str.indexOf("@");

        if (indexBackslash >= 0 && indexAmpersat >= 0) {
            return str.slice(indexBackslash + 1, indexAmpersat);
        }

        if (indexBackslash >= 0) {
            return str.split("\\")[1];
        }

        if (indexAmpersat >= 0) {
            return str.split("@")[0];
        }

        return str;
    },

    type: 'AlmHardwareUtils'
};