{"info":{"_postman_id":"11474d5a-c051-bffc-7f3a-7d54432fbb58","name":"AUF","description":"

Auto Fill OrangeHRM Timesheet

This tool helps you auto-fill ~~annonying~~ timesheet in orangeHRM. It supports searching project and activity by name. Most importantly, it fills public holiday for you. Follow the instruction to setup and you are set free!

Instructions:

1. Update environment variables

\n\n\n \n \n \n\n\n \n \n \n\n\n \n \n \n\n\n \n \n \n\n\n \n \n \n\n\n \n \n \n\n\n \n \n \n\n\n \n \n \n\n

Variable	Description	Example
user	`string` Your login id	eason.chan
pw	`string` Your password. would be deleted after login	passw0rd
month	`integer` 1 to 12	11
project	`string` Project name, will read as RegExp for case-insensitive search	hactl.*lcs
activity	`string` Activity name, will read as RegExp for case-insensitive search	bug fix
session	`auto-generated` Your session	N/A
HRM_HOST	`string` URL to the orangehrm	http://www.xxx.com/orangehrm

\n\n\n

2. Click Run for this collection

Environment: choose the one you setup

3. Enjoy

Note that submitted timesheet would be skipped
For private use only

\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[{"content":"Auto Fill OrangeHRM Timesheet","slug":"auto-fill-orangehrm-timesheet"}],"owner":"5919958","collectionId":"11474d5a-c051-bffc-7f3a-7d54432fbb58","publishedId":"RzfdrAzV","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2018-12-02T14:37:40.000Z"},"item":[{"name":"Login","event":[{"listen":"prerequest","script":{"id":"21c94148-cffe-4550-b947-5104d006d34e","exec":["var Base64={_keyStr:\"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=\",e:function(e){var t=\"\";var n,r,i,s,o,u,a;var f=0;e=Base64._utf8_encode(e);while(f>2;o=(n&3)<<4|r>>4;u=(r&15)<<2|i>>6;a=i&63;if(isNaN(r)){u=a=64}else if(isNaN(i)){a=64}t=t+this._keyStr.charAt(s)+this._keyStr.charAt(o)+this._keyStr.charAt(u)+this._keyStr.charAt(a)}return t},d:function(e){var t=\"\";var n,r,i;var s,o,u,a;var f=0;e=e.replace(/[^A-Za-z0-9\\+\\/\\=]/g,\"\");while(f>4;r=(o&15)<<4|u>>2;i=(u&3)<<6|a;t=t+String.fromCharCode(n);if(u!=64){t=t+String.fromCharCode(r)}if(a!=64){t=t+String.fromCharCode(i)}}t=Base64._utf8_decode(t);return t},_utf8_encode:function(e){e=e.replace(/\\r\\n/g,\"n\");var t=\"\";for(var n=0;n127&&r<2048){t+=String.fromCharCode(r>>6|192);t+=String.fromCharCode(r&63|128)}else{t+=String.fromCharCode(r>>12|224);t+=String.fromCharCode(r>>6&63|128);t+=String.fromCharCode(r&63|128)}}return t},_utf8_decode:function(e){var t=\"\";var n=0;var r=c1=c2=0;while(n191&&r<224){c2=e.charCodeAt(n+1);t+=String.fromCharCode((r&31)<<6|c2&63);n+=2}else{c2=e.charCodeAt(n+1);c3=e.charCodeAt(n+2);t+=String.fromCharCode((r&15)<<12|(c2&63)<<6|c3&63);n+=3}}return t}}","","// wipe working env variable.","postman.clearEnvironmentVariable(\"token\");","postman.clearEnvironmentVariable(\"txtStartDate\");","postman.clearEnvironmentVariable(\"txtEndDate\");","postman.clearEnvironmentVariable(\"timesheetIds\");","postman.clearEnvironmentVariable(\"timesheetId\");","postman.clearEnvironmentVariable(\"employeeId\");","postman.clearEnvironmentVariable(\"holidayList\");","postman.clearEnvironmentVariable(\"projectId\");","postman.clearEnvironmentVariable(\"activityId\");","postman.clearEnvironmentVariable(\"hdnGridCount\");","postman.clearEnvironmentVariable(\"pw3\");","postman.clearEnvironmentVariable(\"verifyList\");","postman.clearEnvironmentVariable(\"STATUS\");","postman.clearEnvironmentVariable(\"tempTxtEndDate\");","postman.clearEnvironmentVariable(\"tempTxtStartDate\");","","for (var i=0; i<=6; i++){"," postman.clearEnvironmentVariable(\"hdnReportedDate\" + i);"," postman.clearEnvironmentVariable(\"duration0\" + i);"," postman.clearEnvironmentVariable(\"duration1\" + i);"," postman.clearEnvironmentVariable(\"cmbActivity\" + i);"," postman.clearEnvironmentVariable(\"cmbProject\" + i);","}","","s = postman.getEnvironmentVariable(\"session\")","ns = postman.getEnvironmentVariable(\"nSession\")","pw = postman.getEnvironmentVariable(\"pw\")","u = postman.getEnvironmentVariable(\"user\")","","if (s) pw = decodeURIComponent(Base64.d(s)).slice(u.length);","postman.setEnvironmentVariable(\"pw3\", pw)"," "],"type":"text/javascript"}},{"listen":"test","script":{"id":"d2cacc41-4830-4eae-b14a-db4ace182f50","exec":["var pw = postman.getEnvironmentVariable(\"pw\")","var pw3 = postman.getEnvironmentVariable(\"pw3\")","var s = postman.getEnvironmentVariable(\"session\")","var month = postman.getEnvironmentVariable(\"month\")","isLoggedIn = responseBody.has(\"Welcome \")","","var Base64={_keyStr:\"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=\",e:function(e){var t=\"\";var n,r,i,s,o,u,a;var f=0;e=Base64._utf8_encode(e);while(f>2;o=(n&3)<<4|r>>4;u=(r&15)<<2|i>>6;a=i&63;if(isNaN(r)){u=a=64}else if(isNaN(i)){a=64}t=t+this._keyStr.charAt(s)+this._keyStr.charAt(o)+this._keyStr.charAt(u)+this._keyStr.charAt(a)}return t},d:function(e){var t=\"\";var n,r,i;var s,o,u,a;var f=0;e=e.replace(/[^A-Za-z0-9\\+\\/\\=]/g,\"\");while(f>4;r=(o&15)<<4|u>>2;i=(u&3)<<6|a;t=t+String.fromCharCode(n);if(u!=64){t=t+String.fromCharCode(r)}if(a!=64){t=t+String.fromCharCode(i)}}t=Base64._utf8_decode(t);return t},_utf8_encode:function(e){e=e.replace(/\\r\\n/g,\"n\");var t=\"\";for(var n=0;n127&&r<2048){t+=String.fromCharCode(r>>6|192);t+=String.fromCharCode(r&63|128)}else{t+=String.fromCharCode(r>>12|224);t+=String.fromCharCode(r>>6&63|128);t+=String.fromCharCode(r&63|128)}}return t},_utf8_decode:function(e){var t=\"\";var n=0;var r=c1=c2=0;while(n191&&r<224){c2=e.charCodeAt(n+1);t+=String.fromCharCode((r&31)<<6|c2&63);n+=2}else{c2=e.charCodeAt(n+1);c3=e.charCodeAt(n+2);t+=String.fromCharCode((r&15)<<12|(c2&63)<<6|c3&63);n+=3}}return t}}","","if (!month"," || !postman.getEnvironmentVariable(\"user\")"," || !pw3){"," tests[\"Please specify your Environment!\"] = 0"," tests[\"- user: your login id\"] = 0"," tests[\"- pw: your password\"] = 0"," tests[\"- month: 1 to 12\"] = 0"," tests[\"- project: project name\"] = 0"," tests[\"- activity: activity name\"] = 0"," tests[\"For detail, please read the collection instruction\"] = 1"," postman.setNextRequest(null)"," ","} else if (!isLoggedIn){"," tests[\"Invalid user/password.\"] = 0"," postman.setEnvironmentVariable(\"STATUS\", JSON.stringify({code: \"A10\", msg: \"Invalid user / password.\"}))"," "," postman.clearEnvironmentVariable(\"pw3\")"," postman.clearEnvironmentVariable(\"session\");"," if (s != null) {"," postman.setEnvironmentVariable(\"pw\", \"\");"," }"," postman.setNextRequest(null)"," ","} else {"," tests[\"Logged in successfully.\"] = 1"," // A0. Greeting"," regex = /Welcome (\\w+)/"," match = regex.exec(responseBody)"," yourName = match[1]"," "," date = new Date()"," date.setUTCHours(8,0,0,0)"," "," // if it is Janurary and filling for last Decemeber"," // Put last year"," if (date.getMonth() == 0 && month == 12){"," date.setFullYear(date.getFullYear() - 1);"," }"," "," date.setMonth(month - 1)"," dateString = date.toISOString().slice(0, 7)"," tests[\"Welcome, \" + yourName + \"!\"] = 1"," tests[\"You're now auto-filling for \" + dateString + \".\"] = 1"," "," "," // A1. grep for employeeId"," regex = /employeeId=(\\d+)/"," match = regex.exec(responseBody)"," employeeId = match[1]"," postman.setEnvironmentVariable(\"employeeId\", employeeId);"," tests[\"OK. Your employeeId is \" + employeeId + \".\"] = true"," "," "," // A2. "," // get first sunday of input month and"," // set txtEndDate to 2 weeks ago"," u = postman.getEnvironmentVariable(\"user\")"," y = date.getFullYear()"," m = date.getMonth()"," "," prevSunday = new Date(y, m, 1) // first day in month"," prevSunday.setUTCHours(8,0,0,0)"," while (prevSunday.getDay() != 0){"," prevSunday.setDate(prevSunday.getDate() + 1)"," } "," "," prevSunday.setDate(prevSunday.getDate() - 15) // 2 weeks ago, + 1 week from pre-request of FetchNextTimesheet, + 1 week from FetchNextTimesheet logic itself"," prevSunday = prevSunday.toISOString().slice(0, 10)"," "," postman.setEnvironmentVariable(\"txtEndDate\", prevSunday)"," postman.setEnvironmentVariable(\"session\", Base64.e(encodeURIComponent(u+pw3)))"," postman.clearEnvironmentVariable(\"pw\")"," postman.clearEnvironmentVariable(\"pw3\");"," console.log(\"[Login] Prearing txtEndDate:\", prevSunday)"," "," postman.setNextRequest(\"Validate_Project\")","}"],"type":"text/javascript"}}],"id":"9facef22-ed5b-8b13-d75f-cb4c0aab8c5f","request":{"method":"POST","header":[],"body":{"mode":"formdata","formdata":[{"key":"actionID","value":"chkAuthentication","type":"text"},{"key":"hdnUserTimeZoneOffset","value":"8","type":"text"},{"key":"txtUserName","value":"{{user}}","type":"text"},{"key":"txtPassword","value":"{{pw3}}","type":"text"}]},"url":"{{HRM_HOST}}/login.php?actionID=chkAuthentication&hdnUserTimeZoneOffset=8&txtUserName={{user}}&txtPassword={{pw3}}","description":"

Login with user and pw
Produce employeeId working variables
Creates session to encrypt credentials

\n","urlObject":{"path":["login.php"],"host":["{{HRM_HOST}}"],"query":[{"key":"actionID","value":"chkAuthentication"},{"key":"hdnUserTimeZoneOffset","value":"8"},{"key":"txtUserName","value":"{{user}}"},{"key":"txtPassword","value":"{{pw3}}"}],"variable":[]}},"response":[],"_postman_id":"9facef22-ed5b-8b13-d75f-cb4c0aab8c5f"},{"name":"Validate_Project","event":[{"listen":"test","script":{"id":"dc84bdc1-3ba1-4306-a567-9cf582da4028","exec":["// Validate Input","var project = postman.getEnvironmentVariable(\"project\")","// project = \"145\"","projectRegex = new RegExp(project, \"i\")","","// B1. Validate Project Id","const projectsMap = {}","","// ","regex = /