/**
 * @NApiVersion 2.x
 * @NScriptType ScheduledScript
 * @NModuleScope SameAccount
 * Find all EMPLOYEEs that have not logged in for 90 days, and remove their GIVE ACCESS. Then log a NOTES that we've done so
 * Using search exactly like search with ID=4079 in SB2
 */
define(['N/record', 'N/search', 'N/runtime'],

function(record, search, runtime){
	function execute(scriptContext){ 
		
       
    	var employeeSearchObj = search.create({
    		   type: "employee",
    		   filters:
    		   [
    		      ["access","is","T"], 
    		      "AND", 
    		      ["formuladate: {loginaudittrail.date}","notonorafter","daysago90"]
    		   ],
    		   columns:
    		   [
    		      search.createColumn({
    		         name: "internalid",
    		         summary: "GROUP",
    		         label: "Internal ID"
    		      }),
    		      search.createColumn({
    		         name: "entityid",
    		         summary: "GROUP",
    		         label: "Name"
    		      }),
    		      search.createColumn({
    		         name: "title",
    		         summary: "GROUP",
    		         label: "Job Title"
    		      }),
    		      search.createColumn({
    		         name: "role",
    		         summary: "GROUP",
    		         label: "Role"
    		      }),
    		      search.createColumn({
    		         name: "supervisor",
    		         summary: "GROUP",
    		         label: "Supervisor"
    		      }),
    		      search.createColumn({
    		         name: "giveaccess",
    		         summary: "GROUP",
    		         label: "Login Access"
    		      }),
    		      search.createColumn({
    		         name: "date",
    		         join: "loginAuditTrail",
    		         summary: "MAX",
    		         sort: search.Sort.ASC,
    		         label: "Last Login"
    		      }),
    		      search.createColumn({
    		         name: "email",
    		         summary: "GROUP",
    		         label: "Email"
    		      })
    		   ]
    		});
			
    		var searchResultCount = employeeSearchObj.runPaged().count;
    		log.debug("employeeSearchObj result count",searchResultCount);
			
    		var searchResult = employeeSearchObj.run().getRange({
			start: 0,
			end: 999
			});
			//Currently search limit of 1000.  Vertafore should not surpass this limit
			
				for(i=0;i<searchResult.length;i++)
				{   
				var empid = result[i].getId();
    			log.debug('EMPLOYEE ID is:', empid);
				var empname = result[i].getValue({name: 'name'});
				log.debug('EMPNAME is:', empname);
				
				var empRecordObj = record.load({
					type: record.Type.EMPLOYEE,
					id: empid,
					isDynamic: true
				});
				
				empRecordObj.setFieldValue({
					name: 'giveaccess',
					value: false
				});
				
				//var jsDateObj = new Date;
				
				empRecordObj.setFieldValue({
					name: 'comments',
					value: 'Script detected no login for 90 days.  Set GIVE ACCESS to FALSE'
				});
				
				var recordId = empRecordObj.save({
					enableSourcing: true,
				ignoreMandatoryFields: true});
				
				log.debug('Removed LOGIN ACCESS for EMPLOYEE with ID:', recordId);
				}
			   
			   
			   
	}
  return {
            execute: execute
        };
    		   
});