{"info":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"description":"","owner":"9107702","collectionId":"5ea60f44-0233-47d3-a951-6933553972b4","publishedId":"2sBXiokpgB","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"FF6C37"},"publishDate":"2026-04-02T08:43:08.000Z"},"item":[{"name":"api","item":[{"name":"v1","item":[{"name":"orders.php","item":[{"name":"Create Order","id":"aca09027-9020-4fe9-8ec3-cbd0d408e7fb","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"customer_id\": 1,\r\n \"name\": \"Nik\", //Optional with customer_id\r\n \"phone\": \"0193913193\", //Optional with customer_id\r\n \"address\": \"No 1, Jalan 2\", //Optional\r\n \"postcode\": \"47810\", //Optional\r\n \"acc\": \"Sales\",\r\n \"date\": \"2026-04-01\", //Optional\r\n \"type\": \"S.O.\", //Optional\r\n \"isdo\": false, //Optional\r\n \"delivery\": \"No\", //Yes or No\r\n \"reference\": \"\",\r\n \"comments\": \"\",\r\n \"tags\": \"tag1, tag2, tag3\",\r\n \"promocode\": \"\",\r\n \"apply_rounding\": true,\r\n \"discper\": 0,\r\n \"items\": [\r\n {\r\n \"qty\": 1,\r\n \"priceid\": 60,\r\n \"type\": \"Baju Melayu 2 pcs\", //Optional with priceid\r\n \"category\": \"Dry Clean\", //Optional with priceid\r\n \"price\": 20, //Total per item line, not unit price. Optional with priceid, or to overwrite default\r\n \"taxpercent\": 0,\r\n \"note\": \"Biru\"\r\n },\r\n {\r\n \"qty\": 2,\r\n \"priceid\": 63,\r\n \"type\": \"Baju Kurung 2 pcs\", //Optional with priceid\r\n \"category\": \"Dry Clean\", //Optional with priceid\r\n \"price\": 40, //Total per item line, not unit price. Optional with priceid, or to overwrite default\r\n \"taxpercent\": 0,\r\n \"note\": \"Hitam\"\r\n }\r\n ]\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/orders.php","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","orders.php"],"host":[""],"query":[],"variable":[]}},"response":[{"id":"9900668f-78bf-43e5-86c9-fa67f4e2f873","name":"Create Order Using Price Ids","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"X-API-Key","value":"","description":"Added as a part of security scheme: apikey"}],"body":{"mode":"raw","raw":"{\n \"customer_id\": 0,\n \"name\": \"Nik\",\n \"phone\": \"0193913193\",\n \"address\": \"No 1, Jalan 2\",\n \"postcode\": \"47810\",\n \"acc\": \"Sales\",\n \"type\": \"S.O.\",\n \"isdo\": false,\n \"delivery\": \"No\",\n \"reference\": \"\",\n \"comments\": \"\",\n \"tags\": \"tag1, tag2, tag3\",\n \"promocode\": \"\",\n \"apply_rounding\": true,\n \"discper\": 0,\n \"items\": [\n {\n \"qty\": 1,\n \"priceid\": 60,\n \"taxpercent\": 0,\n \"note\": \"Biru\"\n },\n {\n \"qty\": 5,\n \"priceid\": 63,\n \"price\": 20,\n \"taxpercent\": 0,\n \"note\": \"Hitam\"\n }\n ]\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/orders.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 07:53:04 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 07:53:04 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"success\": true,\n \"id\": 1421,\n \"bilid\": \"6FAA110EC1E7\",\n \"sumprice\": 36,\n \"tax\": 0,\n \"rounding\": 0,\n \"items\": [\n {\n \"id\": \"3696\",\n \"type\": \"2 Piece Baju Melayu\",\n \"category\": \"Dry Clean\",\n \"qty\": 1,\n \"price\": 16\n },\n {\n \"id\": \"3697\",\n \"type\": \"2 Piece Baju Kurung\",\n \"category\": \"Dry Clean\",\n \"qty\": 5,\n \"price\": 20\n }\n ]\n}"},{"id":"c3862954-d1b6-4437-8de7-312124f9b9c9","name":"Create Order","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"customer_id\": 1,\r\n \"name\": \"Nik\", //Optional with customer_id\r\n \"phone\": \"0193913193\", //Optional with customer_id\r\n \"address\": \"No 1, Jalan 2\", //Optional\r\n \"postcode\": \"47810\", //Optional\r\n \"acc\": \"Sales\",\r\n \"date\": \"2026-04-01\", //Optional\r\n \"type\": \"S.O.\", //Optional\r\n \"isdo\": false, //Optional\r\n \"delivery\": \"No\", //Yes or No\r\n \"reference\": \"\",\r\n \"comments\": \"\",\r\n \"tags\": \"tag1, tag2, tag3\",\r\n \"promocode\": \"\",\r\n \"apply_rounding\": true,\r\n \"discper\": 0,\r\n \"items\": [\r\n {\r\n \"qty\": 1,\r\n \"priceid\": 60,\r\n \"type\": \"Baju Melayu 2 pcs\", //Optional with priceid\r\n \"category\": \"Dry Clean\", //Optional with priceid\r\n \"price\": 20, //Total per item line, not unit price. Optional with priceid, or to overwrite default\r\n \"taxpercent\": 0,\r\n \"note\": \"Biru\"\r\n },\r\n {\r\n \"qty\": 2,\r\n \"priceid\": 63,\r\n \"type\": \"Baju Kurung 2 pcs\", //Optional with priceid\r\n \"category\": \"Dry Clean\", //Optional with priceid\r\n \"price\": 40, //Total per item line, not unit price. Optional with priceid, or to overwrite default\r\n \"taxpercent\": 0,\r\n \"note\": \"Hitam\"\r\n }\r\n ]\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/orders.php"},"status":"OK","code":200,"_postman_previewlanguage":null,"header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 07:00:21 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 07:00:20 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"success\": true,\n \"id\": 1418,\n \"bilid\": \"7F916D68940C\",\n \"sumprice\": 60,\n \"tax\": 0,\n \"rounding\": 0,\n \"items\": [\n {\n \"id\": \"3690\",\n \"type\": \"Baju Melayu 2 pcs\",\n \"category\": \"Dry Clean\",\n \"qty\": 1,\n \"price\": 20\n },\n {\n \"id\": \"3691\",\n \"type\": \"Baju Kurung 2 pcs\",\n \"category\": \"Dry Clean\",\n \"qty\": 2,\n \"price\": 40\n }\n ]\n}"}],"_postman_id":"aca09027-9020-4fe9-8ec3-cbd0d408e7fb"},{"name":"Update Order","id":"b4eef75b-278e-4025-9122-162d5a592867","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PATCH","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"bilid\": \"M679FUY\", //Mandatory\r\n \"status\": \"Done\", //Either: Received, Done, Delivered or Pending\r\n \"date\": \"2026-04-03\", \r\n \"name\": \"Nik Shafie\",\r\n \"phone\": \"01234567890\",\r\n \"address\": \"No 1, Street 2, \",\r\n \"postcode\": \"12345\",\r\n \"customer_id\": 3,\r\n \"accept\": \"John\", //the staff (username) attending the order\r\n \"promoter\": \"Ahmad\", //the staff (username) promoting the order\r\n \"comments\": \"No comments\" //any note\r\n}\r\n//All fields are optional, except for the bilid","options":{"raw":{"language":"json"}}},"url":"/api/v1/orders.php","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","orders.php"],"host":[""],"query":[],"variable":[]}},"response":[{"id":"d2501691-36fc-40e7-ba08-f4053ef78cf5","name":"Update Order Status","originalRequest":{"method":"PATCH","header":[{"key":"Content-Type","value":"application/json"},{"key":"X-API-Key","value":"","description":"Added as a part of security scheme: apikey"}],"body":{"mode":"raw","raw":"{\n \"bilid\": \"7F916D68940C\",\n \"status\": \"Done\"\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/orders.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 07:54:17 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 07:54:17 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"success\": true,\n \"bilid\": \"7F916D68940C\",\n \"status\": \"Done\"\n}"}],"_postman_id":"b4eef75b-278e-4025-9122-162d5a592867"},{"name":"Void Order","id":"03b883f0-8ef8-47f4-bb2c-a0391b9b1c5f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"bilid\": \"M679FUY\"\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/orders.php?bilid=string","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","orders.php"],"host":[""],"query":[{"key":"bilid","value":"string"}],"variable":[]}},"response":[{"id":"6d549bb1-b7d5-4dc2-8aad-9637a66424ef","name":"Void An Order","originalRequest":{"method":"DELETE","header":[{"key":"Content-Type","value":"application/json"},{"key":"X-API-Key","value":"","description":"Added as a part of security scheme: apikey"}],"body":{"mode":"raw","raw":"{\n \"bilid\": \"76B8962ADFD5\"\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"/api/v1/orders.php?bilid=76B8962ADFD5","host":[""],"path":["api","v1","orders.php"],"query":[{"key":"bilid","value":"76B8962ADFD5"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 07:13:37 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 07:13:37 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"success\": true,\n \"bilid\": \"76B8962ADFD5\",\n \"status\": \"Void\"\n}"}],"_postman_id":"03b883f0-8ef8-47f4-bb2c-a0391b9b1c5f"},{"name":"Retrieve Single Order","id":"72b278bc-0c7b-4ac3-973e-33e4b99b9858","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"/api/v1/orders.php?bilid=","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","orders.php"],"host":[""],"query":[{"description":{"content":"

Unique Identifier of an Order

\n","type":"text/plain"},"key":"bilid","value":""}],"variable":[]}},"response":[{"id":"ff63c606-6d03-4022-9888-ba4a00b4ddca","name":"Retrieve Single Order","originalRequest":{"method":"GET","header":[],"url":{"raw":"/api/v1/orders.php?bilid=0C0B18019DC7","host":[""],"path":["api","v1","orders.php"],"query":[{"key":"bilid","value":"0C0B18019DC7","description":"Unique Identifier of an Order"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 07:14:56 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 07:14:56 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[{"expires":"Invalid Date","domain":"","path":""}],"responseTime":null,"body":"{\n \"bilid\": \"0C0B18019DC7\",\n \"id\": 1420,\n \"name\": \"Nik\",\n \"phone\": \"0193913193\",\n \"date\": \"2026-04-03 15:05:20\",\n \"status\": \"Done\",\n \"sumprice\": \"36.0000\",\n \"tax\": \"0.0000\",\n \"rounding\": \"0\",\n \"branch\": \"2\",\n \"profileid\": \"0\",\n \"accept\": \"Test POSTMAN\",\n \"staff\": \"\",\n \"runner\": \"\",\n \"discper\": \"0\",\n \"discnum\": \"\",\n \"reference\": \"\",\n \"delivery\": \"No\",\n \"deliveryaddress\": \"No 1, Jalan 2\",\n \"deliverypostcode\": \"47810\",\n \"deliverydate\": \"2026-04-05\",\n \"deliverytime\": \"15:02:43\",\n \"type\": \"\",\n \"account\": null,\n \"comments\": \"\",\n \"tags\": \"tag1, tag2, tag3\",\n \"promocode\": \"\",\n \"pickupdate\": \"2026-04-03\",\n \"pickuptime\": \"15:02:43\",\n \"invoiceid\": \"\",\n \"due\": \"36.0000\",\n \"charge\": \"36.0000\",\n \"items\": [\n {\n \"id\": 3694,\n \"category\": \"Dry Clean\",\n \"type\": \"2 Piece Baju Melayu\",\n \"size\": \"1.000\",\n \"price\": \"16.0000\",\n \"note\": \"Biru\",\n \"comments\": \"\",\n \"staff\": \"\",\n \"datesend\": \"2026-04-05 15:02:43\",\n \"subitem\": \"\",\n \"shelf\": \"\",\n \"subitemchangeable\": \"\",\n \"subitembaseuprice\": \"\",\n \"image\": null,\n \"tags\": null,\n \"date\": \"2026-04-03 15:02:43\",\n \"taxpercent\": 0,\n \"billorder\": 3694,\n \"subitems\": []\n },\n {\n \"id\": 3695,\n \"category\": \"Dry Clean\",\n \"type\": \"2 Piece Baju Kurung\",\n \"size\": \"5.000\",\n \"price\": \"20.0000\",\n \"note\": \"Hitam\",\n \"comments\": \"\",\n \"staff\": \"\",\n \"datesend\": \"2026-04-05 15:02:43\",\n \"subitem\": \"\",\n \"shelf\": \"\",\n \"subitemchangeable\": \"\",\n \"subitembaseuprice\": \"\",\n \"image\": null,\n \"tags\": null,\n \"date\": \"2026-04-03 15:02:43\",\n \"taxpercent\": 0,\n \"billorder\": 3695,\n \"subitems\": []\n }\n ],\n \"jobsdone\": [],\n \"subscriptions\": []\n}"}],"_postman_id":"72b278bc-0c7b-4ac3-973e-33e4b99b9858"},{"name":"Retrieve Orders","id":"9eb7fad8-1305-4ed8-99a6-41bea5304572","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"/api/v1/orders.php?status&unpaid&type&profileid&page&limit&date_from&date_to","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","orders.php"],"host":[""],"query":[{"description":{"content":"

Optional. Either: 'received', 'done', 'delivered', 'pending', 'voided', 'undelivered', 'unvoided', 'done or delivered', 'all'

\n","type":"text/plain"},"key":"status","value":null},{"description":{"content":"

Optional

\n","type":"text/plain"},"key":"unpaid","value":null},{"description":{"content":"

Optional

\n","type":"text/plain"},"key":"type","value":null},{"description":{"content":"

Optional

\n","type":"text/plain"},"key":"profileid","value":null},{"description":{"content":"

Default to 1

\n","type":"text/plain"},"key":"page","value":null},{"description":{"content":"

Page size

\n","type":"text/plain"},"key":"limit","value":null},{"description":{"content":"

Optional. Format: YYYY-MM-DD

\n","type":"text/plain"},"key":"date_from","value":null},{"description":{"content":"

Optional. Format: YYYY-MM-DD

\n","type":"text/plain"},"key":"date_to","value":null}],"variable":[]}},"response":[{"id":"8bd604cf-1a63-4ebc-8923-34f2c2c43149","name":"Retrieve Orders","originalRequest":{"method":"GET","header":[],"url":{"raw":"/api/v1/orders.php?status=all&date_from=2026-01-01","host":[""],"path":["api","v1","orders.php"],"query":[{"key":"status","value":"all","description":"Optional. Either: 'received', 'done', 'delivered', 'pending', 'voided', 'undelivered', 'unvoided', 'done or delivered', 'all'"},{"key":"unpaid","value":null,"description":"Optional","disabled":true},{"key":"type","value":null,"description":"Optional","disabled":true},{"key":"profileid","value":null,"description":"Optional","disabled":true},{"key":"page","value":null,"description":"Default to 1","disabled":true},{"key":"limit","value":null,"description":"Page size","disabled":true},{"key":"date_from","value":"2026-01-01","description":"Optional. Format: YYYY-MM-DD"},{"key":"date_to","value":null,"description":"Optional. Format: YYYY-MM-DD","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 07:15:35 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 07:15:35 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[{"expires":"Invalid Date","domain":"","path":""}],"responseTime":null,"body":"{\n \"data\": [\n {\n \"id\": 1420,\n \"bilid\": \"0C0B18019DC7\",\n \"name\": \"Nik\",\n \"phone\": \"0193913193\",\n \"date\": \"2026-04-03 15:05:20\",\n \"status\": \"Done\",\n \"due\": \"36.0000\",\n \"charge\": \"36.0000\",\n \"delivery\": \"No\",\n \"deliveryaddress\": \"No 1, Jalan 2\",\n \"deliverypostcode\": \"47810\",\n \"deliverydate\": \"2026-04-05\",\n \"deliverytime\": \"15:02:43\",\n \"profileid\": \"0\",\n \"reference\": \"\",\n \"discper\": \"0\",\n \"type\": \"\",\n \"accept\": \"Test POSTMAN\",\n \"staff\": \"\",\n \"promocode\": \"\",\n \"account\": null,\n \"tags\": \"tag1, tag2, tag3\",\n \"pickupdate\": \"2026-04-03\",\n \"branch\": \"2\",\n \"branchinitial\": \"\",\n \"business\": null\n },\n {\n \"id\": 1419,\n \"bilid\": \"76B8962ADFD5\",\n \"name\": \"Nik\",\n \"phone\": \"0193913193\",\n \"date\": \"2026-04-03 15:02:19\",\n \"status\": \"Void\",\n \"due\": \"0.0000\",\n \"charge\": \"0.0000\",\n \"delivery\": \"No\",\n \"deliveryaddress\": \"No 1, Jalan 2\",\n \"deliverypostcode\": \"47810\",\n \"deliverydate\": \"2026-04-05\",\n \"deliverytime\": \"15:02:19\",\n \"profileid\": \"0\",\n \"reference\": \"\",\n \"discper\": \"0\",\n \"type\": \"S.O.\",\n \"accept\": \"Test POSTMAN\",\n \"staff\": \"\",\n \"promocode\": \"\",\n \"account\": null,\n \"tags\": \"tag1, tag2, tag3\",\n \"pickupdate\": null,\n \"branch\": \"2\",\n \"branchinitial\": \"\",\n \"business\": null\n },\n {\n \"id\": 1418,\n \"bilid\": \"7F916D68940C\",\n \"name\": \"Nik\",\n \"phone\": \"0193913193\",\n \"date\": \"2026-04-01\",\n \"status\": \"Received\",\n \"due\": \"60.0000\",\n \"charge\": \"60.0000\",\n \"delivery\": \"No\",\n \"deliveryaddress\": \"No 1, Jalan 2\",\n \"deliverypostcode\": \"47810\",\n \"deliverydate\": \"2026-04-05\",\n \"deliverytime\": \"15:00:21\",\n \"profileid\": \"1\",\n \"reference\": \"\",\n \"discper\": \"0\",\n \"type\": \"S.O.\",\n \"accept\": \"Test POSTMAN\",\n \"staff\": \"\",\n \"promocode\": \"\",\n \"account\": null,\n \"tags\": \"tag1, tag2, tag3\",\n \"pickupdate\": null,\n \"branch\": \"2\",\n \"branchinitial\": \"\",\n \"business\": \"Mac 25 Enterprise 12\"\n }\n ],\n \"total\": 3,\n \"page\": 1,\n \"limit\": 50,\n \"pages\": 1\n}"}],"_postman_id":"9eb7fad8-1305-4ed8-99a6-41bea5304572"}],"id":"823c3521-9a10-4849-a4b5-75312f4cdb65","_postman_id":"823c3521-9a10-4849-a4b5-75312f4cdb65","description":"","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}}},{"name":"payments.php","item":[{"name":"Record Payment","id":"0c1e449f-aed3-4f43-8c38-1c3c225610e1","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"bilid\": \"M679FUY\", //Mandatory\r\n \"amount\": 204, //Mandatory. Extras will be saved as credit to the profile, if the profile has an id\r\n \"method\": \"Cash\"\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/payments.php","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","payments.php"],"host":[""],"query":[],"variable":[]}},"response":[{"id":"8e12346f-6133-41ac-8dec-269e0ceaeacd","name":"Cash Payment","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"X-API-Key","value":"","description":"Added as a part of security scheme: apikey"}],"body":{"mode":"raw","raw":"{\n \"bilid\": \"0C0B18019DC7\",\n \"amount\": 36,\n \"method\": \"Cash\"\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/payments.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 07:17:48 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 07:17:48 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"success\": true,\n \"bilid\": \"0C0B18019DC7\",\n \"paid_amount\": 36,\n \"method\": \"Cash\",\n \"balance_due\": 0,\n \"is_paid\": true,\n \"credited_overshoot\": 0\n}"}],"_postman_id":"0c1e449f-aed3-4f43-8c38-1c3c225610e1"},{"name":"Order Payment","id":"56fb0102-a208-4019-8f0d-82f7f4b11fd8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"/api/v1/payments.php?bilid=M679FUY","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","payments.php"],"host":[""],"query":[{"key":"bilid","value":"M679FUY"}],"variable":[]}},"response":[{"id":"31cb16e4-cff0-4d5e-909a-31f3d34fc7fa","name":"Get Payments on an Order","originalRequest":{"method":"GET","header":[],"url":{"raw":"/api/v1/payments.php?bilid=0C0B18019DC7","host":[""],"path":["api","v1","payments.php"],"query":[{"key":"bilid","value":"0C0B18019DC7"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 07:19:28 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 07:19:28 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"bilid\": \"0C0B18019DC7\",\n \"total_charged\": 36,\n \"total_paid\": 36,\n \"balance_due\": 0,\n \"is_paid\": true,\n \"payments\": [\n {\n \"date\": \"2026-04-03 15:17:48\",\n \"description\": \"1420\",\n \"amount\": \"36.0000\",\n \"method\": \"Cash\",\n \"docid\": \"\"\n }\n ]\n}"}],"_postman_id":"56fb0102-a208-4019-8f0d-82f7f4b11fd8"},{"name":"Debtors Aging","id":"e9098e83-de39-4fc1-a55f-ce296e53c010","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"/api/v1/payments.php?query=debtors_aging&date_to=","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","payments.php"],"host":[""],"query":[{"key":"query","value":"debtors_aging"},{"description":{"content":"

Optional. YYYY-MM-DD

\n","type":"text/plain"},"key":"date_to","value":""}],"variable":[]}},"response":[{"id":"201e16a5-dfb8-4905-90b5-16923b2b07ce","name":"Get Debtors Aging","originalRequest":{"method":"GET","header":[],"url":{"raw":"/api/v1/payments.php?query=debtors_aging&date_to=2026-04-30","host":[""],"path":["api","v1","payments.php"],"query":[{"key":"query","value":"debtors_aging"},{"key":"date_to","value":"2026-04-30","description":"Optional. YYYY-MM-DD"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 07:20:15 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 07:20:15 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"status\": \"success\",\n \"date_to\": \"2026-04-30\",\n \"debtors\": [\n {\n \"profileid\": 1,\n \"name\": \"Nik Hazwan\",\n \"business\": \"Mac 25 Enterprise 12\",\n \"lastpaydate\": \"2025-12-22 13:02:21\",\n \"aging\": {\n \"current\": 0,\n \"1_month\": 0,\n \"2_months\": 0,\n \"3_months\": 0,\n \"4_months\": 0,\n \"5_months_plus\": -2.445\n },\n \"total_balance\": -2.45\n }\n ]\n}"}],"_postman_id":"e9098e83-de39-4fc1-a55f-ce296e53c010"}],"id":"98d4258f-e9d9-4362-8c9a-f4e433fc1dea","_postman_id":"98d4258f-e9d9-4362-8c9a-f4e433fc1dea","description":"","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}}},{"name":"price.php","item":[{"name":"List Active Prices / Items","id":"cf183c86-f77f-4fb0-abd5-4bc368a3d712","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":"/api/v1/price.php?search=&category=&page=1&limit=50","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","price.php"],"host":[""],"query":[{"description":{"content":"

Optional

\n","type":"text/plain"},"key":"search","value":""},{"description":{"content":"

Optional

\n","type":"text/plain"},"key":"category","value":""},{"description":{"content":"

Optional

\n","type":"text/plain"},"key":"page","value":"1"},{"description":{"content":"

Optional

\n","type":"text/plain"},"key":"limit","value":"50"}],"variable":[]}},"response":[{"id":"b517c113-bd5f-4bdb-b917-b1b6b30a8d5d","name":"List Active Prices / Items","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":{"raw":"/api/v1/price.php?search=&category=&page=1&limit=50","host":[""],"path":["api","v1","price.php"],"query":[{"key":"search","value":"","description":"Optional"},{"key":"category","value":"","description":"Optional"},{"key":"page","value":"1","description":"Optional"},{"key":"limit","value":"50","description":"Optional"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 07:59:31 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 07:59:31 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"data\": [\n {\n \"id\": 6324,\n \"type\": \"Stamp Pad size 4 (pc)\",\n \"category\": \"Alat Tulis\",\n \"price\": \"5.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Sales\",\n \"identifier\": \"9557368047860\",\n \"ispackage\": 0\n },\n {\n \"id\": 6325,\n \"type\": \"Stamp Pad size 4 (pc)\",\n \"category\": \"Alat Tulis\",\n \"price\": \"5.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"9557368047860\",\n \"ispackage\": 0\n },\n {\n \"id\": 6326,\n \"type\": \"Stamp Pad size 4 (pc)\",\n \"category\": \"Alat Tulis\",\n \"price\": \"5.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Sales\",\n \"identifier\": \"a\",\n \"ispackage\": 0\n },\n {\n \"id\": 6499,\n \"type\": \"Jeans\",\n \"category\": \"Alteration\",\n \"price\": \"5.00\",\n \"taxpercent\": \"0\",\n \"period\": 2,\n \"account\": \"Jahit\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 6474,\n \"type\": \"Aluminium 2x1inch (kaki)\",\n \"category\": \"Aluminium\",\n \"price\": \"5.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Sales\",\n \"identifier\": \"aluminium2x1inch\",\n \"ispackage\": 0\n },\n {\n \"id\": 6486,\n \"type\": \"Aluminium 2x1inch (kaki)\",\n \"category\": \"Aluminium\",\n \"price\": \"5.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Test Sales Account\",\n \"identifier\": \"aluminium2x1inch\",\n \"ispackage\": 0\n },\n {\n \"id\": 35,\n \"type\": \"Dry Clean (sf)\",\n \"category\": \"Carpets\",\n \"price\": \"4.00\",\n \"taxpercent\": \"0\",\n \"period\": 1,\n \"account\": \"Sales\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 32,\n \"type\": \"HandMade Or Silk (sf)\",\n \"category\": \"Carpets\",\n \"price\": \"2.50\",\n \"taxpercent\": \"0\",\n \"period\": 1,\n \"account\": \"Sales\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 34,\n \"type\": \"Machine Made\",\n \"category\": \"Carpets\",\n \"price\": \"0.00\",\n \"taxpercent\": \"0\",\n \"period\": 1,\n \"account\": \"Sales\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 33,\n \"type\": \"Machine Made(sf)\",\n \"category\": \"Carpets\",\n \"price\": \"2.00\",\n \"taxpercent\": \"0\",\n \"period\": 1,\n \"account\": \"Sales\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 6476,\n \"type\": \"Mug Merah 200ml (pc)\",\n \"category\": \"Cawan\",\n \"price\": \"3.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Sales\",\n \"identifier\": \"MugMerah200ml\",\n \"ispackage\": 0\n },\n {\n \"id\": 6485,\n \"type\": \"Mug Merah 200ml (pc)\",\n \"category\": \"Cawan\",\n \"price\": \"3.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Test Sales Account\",\n \"identifier\": \"MugMerah200ml\",\n \"ispackage\": 0\n },\n {\n \"id\": 351,\n \"type\": \"ALOE VERA 99% LIPSTICK\",\n \"category\": \"COSMETIC PRODUCT\",\n \"price\": \"5.30\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"6970505530231\",\n \"ispackage\": 0\n },\n {\n \"id\": 352,\n \"type\": \"ALOE VERA MOISTURIZING LIP STICK 1 PCS\",\n \"category\": \"COSMETIC PRODUCT\",\n \"price\": \"4.90\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"11581\",\n \"ispackage\": 0\n },\n {\n \"id\": 1494,\n \"type\": \"DERMAL THERAPY HAND BALM 50G\",\n \"category\": \"COSMETIC PRODUCT\",\n \"price\": \"17.90\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"9329224000551\",\n \"ispackage\": 0\n },\n {\n \"id\": 1496,\n \"type\": \"DERMAL THERAPY LIP BALM 10G\",\n \"category\": \"COSMETIC PRODUCT\",\n \"price\": \"13.70\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"9329224000773\",\n \"ispackage\": 0\n },\n {\n \"id\": 1497,\n \"type\": \"DERMAL THERAPY LIPBALM SPF50 10G\",\n \"category\": \"COSMETIC PRODUCT\",\n \"price\": \"19.20\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"9329224001466\",\n \"ispackage\": 0\n },\n {\n \"id\": 2039,\n \"type\": \"FAIR & LOVELY\",\n \"category\": \"COSMETIC PRODUCT\",\n \"price\": \"8.40\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"9556126647236\",\n \"ispackage\": 0\n },\n {\n \"id\": 4582,\n \"type\": \"POLYLAB PETROLEUM JELLY 100GM\",\n \"category\": \"COSMETIC PRODUCT\",\n \"price\": \"6.90\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"9555018402618\",\n \"ispackage\": 0\n },\n {\n \"id\": 4915,\n \"type\": \"SAFI BAL OXYWHITE CC CR SPF25PA++ 20G\",\n \"category\": \"COSMETIC PRODUCT\",\n \"price\": \"21.30\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"9555052710991\",\n \"ispackage\": 0\n },\n {\n \"id\": 4917,\n \"type\": \"SAFI BAL OXYWHITE MOIST CR SPF 20 45G\",\n \"category\": \"COSMETIC PRODUCT\",\n \"price\": \"20.90\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"9555052708721\",\n \"ispackage\": 0\n },\n {\n \"id\": 6312,\n \"type\": \"RM200 worth of credit\",\n \"category\": \"Credits\",\n \"price\": \"190.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Sales\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 6310,\n \"type\": \"Dry Clean (Per Section)\",\n \"category\": \"Curtain Cleaning Estimation\",\n \"price\": \"0.00\",\n \"taxpercent\": \"0\",\n \"period\": 3,\n \"account\": \"Sales\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 94,\n \"type\": \"UphaLyte Oral Rehydration Salts\",\n \"category\": \"Dehydration\",\n \"price\": \"0.90\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"9557046001030\",\n \"ispackage\": 0\n },\n {\n \"id\": 6292,\n \"type\": \"Cheras\",\n \"category\": \"Delivery\",\n \"price\": \"30.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Sales\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 6293,\n \"type\": \"Kuala Lumpur\",\n \"category\": \"Delivery\",\n \"price\": \"25.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Sales\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 6294,\n \"type\": \"Petaling Jaya\",\n \"category\": \"Delivery\",\n \"price\": \"25.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Sales\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 6319,\n \"type\": \"Sabah Sarawak\",\n \"category\": \"Delivery\",\n \"price\": \"0.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Sales\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 6316,\n \"type\": \"Semenanjung Malaysia\",\n \"category\": \"Delivery\",\n \"price\": \"0.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Sales\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 6302,\n \"type\": \"Gift\",\n \"category\": \"Discount\",\n \"price\": \"-1.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Sales\",\n \"identifier\": \"\",\n \"ispackage\": 0\n },\n {\n \"id\": 6513,\n \"type\": \"Dress Cantik Green L (pc)\",\n \"category\": \"Dress\",\n \"price\": \"100.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"DressCantikGreen\",\n \"ispackage\": 0\n },\n {\n \"id\": 6514,\n \"type\": \"Dress Cantik Green M (pc)\",\n \"category\": \"Dress\",\n \"price\": \"100.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"DressCantikGreenM\",\n \"ispackage\": 0\n },\n {\n \"id\": 6515,\n \"type\": \"Dress Cantik Green S (pc)\",\n \"category\": \"Dress\",\n \"price\": \"100.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"DressCantikGreenS\",\n \"ispackage\": 0\n },\n {\n \"id\": 6301,\n \"type\": \"Summer Dress (M) (pc)\",\n \"category\": \"Dress\",\n \"price\": \"30.00\",\n \"taxpercent\": \"0\",\n \"period\": 0,\n \"account\": \"Sales\",\n \"identifier\": \"b\",\n \"ispackage\": 0\n },\n {\n \"id\": 163,\n \"type\": \"3M MICROPORE 1 IN X 10YD\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"4.10\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"11621\",\n \"ispackage\": 0\n },\n {\n \"id\": 165,\n \"type\": \"3M MICROPORE 1 IN X 10YD X 12\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"45.90\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"116211\",\n \"ispackage\": 0\n },\n {\n \"id\": 168,\n \"type\": \"3M MICROPORE 1/2 IN X 10YD\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"2.00\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"11620\",\n \"ispackage\": 0\n },\n {\n \"id\": 169,\n \"type\": \"3M MICROPORE 1/2 IN X 10YD X 24\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"45.90\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"116201\",\n \"ispackage\": 0\n },\n {\n \"id\": 171,\n \"type\": \"3M MICROPORE 2 IN X 10 YD\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"8.20\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"11622\",\n \"ispackage\": 0\n },\n {\n \"id\": 174,\n \"type\": \"3M MICROPORE 2 IN X 10 YD X 6\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"45.90\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"116221\",\n \"ispackage\": 0\n },\n {\n \"id\": 176,\n \"type\": \"3M MICROPORE 3 IN X 10 YD\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"12.20\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"11623\",\n \"ispackage\": 0\n },\n {\n \"id\": 177,\n \"type\": \"3M MICROPORE 3 IN X 10 YD X 4\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"45.90\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"116231\",\n \"ispackage\": 0\n },\n {\n \"id\": 182,\n \"type\": \"3M NEXCARE FABRIC DRESSING 6CMX1M\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"10.50\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"8850304084495\",\n \"ispackage\": 0\n },\n {\n \"id\": 183,\n \"type\": \"3M NEXCARE GENTLE PAPER DRESSING 6CMX1M\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"10.50\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"8850304102632\",\n \"ispackage\": 0\n },\n {\n \"id\": 184,\n \"type\": \"3M NEXCARE SOFT CLOTH DRESSING 6CMX1M\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"10.50\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"8850304015437\",\n \"ispackage\": 0\n },\n {\n \"id\": 186,\n \"type\": \"3M NEXCARE TEGADERM+PAD TRANS DRESSING 5S (2 3/8 IN X 4 IN)\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"15.40\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"51131835580\",\n \"ispackage\": 0\n },\n {\n \"id\": 187,\n \"type\": \"3M T/PORE WHITE DRESSING TAPE 1'S\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"6.60\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"123241\",\n \"ispackage\": 0\n },\n {\n \"id\": 188,\n \"type\": \"3M T/PORE WHITE DRESSING TAPE 1/2x10YD\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"2.90\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"123231\",\n \"ispackage\": 0\n },\n {\n \"id\": 189,\n \"type\": \"3M T/PORE WHITE DRESSING TAPE 1/2x10YD 20'S\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"37.90\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"2520488\",\n \"ispackage\": 0\n },\n {\n \"id\": 190,\n \"type\": \"3M T/PORE WHITE DRESSING TAPE 1x10YD 12'S\",\n \"category\": \"DRESSING PRODUCT\",\n \"price\": \"0.00\",\n \"taxpercent\": \"\",\n \"period\": 0,\n \"account\": \"Farmasi\",\n \"identifier\": \"2520548\",\n \"ispackage\": 0\n }\n ],\n \"total\": 6356,\n \"page\": 1,\n \"limit\": 50,\n \"pages\": 128\n}"}],"_postman_id":"cf183c86-f77f-4fb0-abd5-4bc368a3d712"},{"name":"Single Item Details","id":"0819b0b0-bdb7-484c-96ef-56dcd0df2389","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":"/api/v1/price.php?id=","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","price.php"],"host":[""],"query":[{"description":{"content":"

Price or Item ID

\n","type":"text/plain"},"key":"id","value":""}],"variable":[]}},"response":[{"id":"bbfe0e44-4181-42fa-8584-7b92918e1750","name":"Item Details","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":{"raw":"/api/v1/price.php?id=187&search=&category=&page=1&limit=50","host":[""],"path":["api","v1","price.php"],"query":[{"key":"id","value":"187"},{"key":"search","value":""},{"key":"category","value":""},{"key":"page","value":"1"},{"key":"limit","value":"50"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 08:00:29 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 08:00:29 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"id\": 187,\n \"account\": \"Farmasi\",\n \"category\": \"DRESSING PRODUCT\",\n \"type\": \"3M T/PORE WHITE DRESSING TAPE 1'S\",\n \"price\": \"6.60\",\n \"period\": 0,\n \"timestamp\": \"2025-10-28 13:49:52\",\n \"featured\": \"\",\n \"taxpercent\": \"\",\n \"ispackage\": 0,\n \"oncealife\": \"\",\n \"discpercent\": \"\",\n \"discstart\": \"0000-00-00\",\n \"discend\": \"0000-00-00\",\n \"maxuserlevel\": \"2\",\n \"imageid\": \"\",\n \"colorcode\": \"#ffffff\",\n \"points\": \"\",\n \"identifier\": \"123241\",\n \"comments\": \"\",\n \"variationgroup\": \"\",\n \"variationname\": \"\",\n \"html\": \"\",\n \"available\": \"1\",\n \"minorder\": \"0\",\n \"commissionpercent\": \"0\",\n \"weightkg\": \"0\",\n \"integrationid\": \"\",\n \"position\": 32000,\n \"tags\": null,\n \"isrental\": \"\",\n \"mintime\": 0,\n \"enforceassignment\": \"No\",\n \"einv_classification\": \"022\",\n \"einv_taxcode\": \"06\",\n \"selections\": [],\n \"addons\": [],\n \"ranges\": [],\n \"subscription\": null\n}"}],"_postman_id":"0819b0b0-bdb7-484c-96ef-56dcd0df2389"},{"name":"Create Price Item","id":"1dab2877-7478-4e08-9a69-895e852e4129","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"account\": \"Sales\", //Mandatory\r\n \"category\": \"Dry Cleaning\", //Mandatory\r\n \"type\": \"Baju Melayu\", //Mandatory\r\n \"price\": 25.00, //Mandatory\r\n \"period\": 3.0, //Mandatory. Service period in days, or Item Lead Days\r\n \"colorcode\": \"#FF5733\", //Mandatory\r\n \"taxpercent\": 6.0,\r\n \"identifier\": \"SKU-BM-001\",\r\n \"comments\": \"Handle with care, silk material\",\r\n \"weightkg\": 0.5,\r\n \"tags\": \"premium,traditional\",\r\n \"ispackage\": 0,\r\n \"selections\": [\r\n {\r\n \"question\": \"Choose Fragrance\",\r\n \"multi\": 0,\r\n \"options\": [\r\n {\"name\": \"Lavender\", \"price\": 0},\r\n {\"name\": \"Lemon\", \"price\": 0}\r\n ]\r\n },\r\n {\r\n \"question\": \"Packaging Type\",\r\n \"multi\": 0,\r\n \"options\": [\r\n {\"name\": \"Hanger\", \"price\": 0},\r\n {\"name\": \"Folded\", \"price\": 2.0}\r\n ]\r\n }\r\n ],\r\n \"addons\": [\r\n {\r\n \"option\": \"Stain Removal\",\r\n \"value\": 5.50\r\n }\r\n ],\r\n \"ranges\": [\r\n {\r\n \"startrange\": 1.0,\r\n \"endrange\": 5.0,\r\n \"price\": 0,\r\n \"priceperunit\": 20,\r\n \"period\": 2.0\r\n },\r\n {\r\n \"startrange\": 6.0,\r\n \"endrange\": 10.0,\r\n \"price\": 0,\r\n \"priceperunit\": 18,\r\n \"period\": 2.0\r\n }\r\n ]\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/price.php","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","price.php"],"host":[""],"query":[],"variable":[]}},"response":[{"id":"70663549-90dc-4026-a135-64b554bee39f","name":"Create Price Item","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"account\": \"Sales\", //Mandatory\r\n \"category\": \"Dry Cleaning\", //Mandatory\r\n \"type\": \"Baju Melayu\", //Mandatory\r\n \"price\": 25.00, //Mandatory\r\n \"period\": 3.0, //Mandatory. Service period in days, or Item Lead Days\r\n \"colorcode\": \"#FF5733\", //Mandatory\r\n \"taxpercent\": 6.0,\r\n \"identifier\": \"SKU-BM-001\",\r\n \"comments\": \"Handle with care, silk material\",\r\n \"weightkg\": 0.5,\r\n \"tags\": \"premium,traditional\",\r\n \"ispackage\": 0,\r\n \"selections\": [\r\n {\r\n \"question\": \"Choose Fragrance\",\r\n \"multi\": 0,\r\n \"options\": [\r\n {\"name\": \"Lavender\", \"price\": 0},\r\n {\"name\": \"Lemon\", \"price\": 0}\r\n ]\r\n },\r\n {\r\n \"question\": \"Packaging Type\",\r\n \"multi\": 0,\r\n \"options\": [\r\n {\"name\": \"Hanger\", \"price\": 0},\r\n {\"name\": \"Folded\", \"price\": 2.0}\r\n ]\r\n }\r\n ],\r\n \"addons\": [\r\n {\r\n \"option\": \"Stain Removal\",\r\n \"value\": 5.50\r\n }\r\n ],\r\n \"ranges\": [\r\n {\r\n \"startrange\": 1.0,\r\n \"endrange\": 5.0,\r\n \"price\": 0,\r\n \"priceperunit\": 20,\r\n \"period\": 2.0\r\n },\r\n {\r\n \"startrange\": 6.0,\r\n \"endrange\": 10.0,\r\n \"price\": 0,\r\n \"priceperunit\": 18,\r\n \"period\": 2.0\r\n }\r\n ]\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/price.php"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"1dab2877-7478-4e08-9a69-895e852e4129"},{"name":"Update Price Item","id":"2ccb90ff-9e44-4edc-9ce4-f96ce7750455","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PATCH","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"id\": 123, // Required: The primary key of the price item to update.\r\n \r\n // --- Core Fields (Optional: Only include what you want to change) ---\r\n \"type\": \"Baju Kurung 2 pcs\", // Updates the label/name of the service.\r\n \"category\": \"Dry Cleaning\",\r\n \"price\": 45.00, // Updated price value.\r\n \"taxpercent\": 6.0, // Updates tax calculation.\r\n \"identifier\": \"SKU-UPDATE-001\", // CRITICAL: Updates core table AND wipes/replaces 'goodprice' table entry.\r\n \"ispackage\": 1, // 0 for single item, 1 for package.\r\n\r\n // --- Relationship Arrays (Wipe-and-Replace Logic) ---\r\n \r\n // If 'selections' is sent, ALL previous selection types (1, 2, and 3) are deleted and replaced.\r\n \"selections\": [\r\n {\r\n \"question\": \"Fabric Type\",\r\n \"multi\": 0, // 0 for radio, 1 for checkbox.\r\n \"options\": [\r\n {\"name\": \"Silk\", \"price\": 5.0},\r\n {\"name\": \"Cotton\", \"price\": 0.0}\r\n ]\r\n }\r\n ],\r\n\r\n // If 'addons' is sent, ALL previous 'addon' types for this ID are deleted first.\r\n \"addons\": [\r\n {\r\n \"option\": \"Starch\",\r\n \"value\": 2.0\r\n }\r\n ],\r\n\r\n // If 'ranges' is sent, ALL previous price ranges for this serviceid are deleted first.\r\n \"ranges\": [\r\n {\r\n \"startrange\": 1.0,\r\n \"endrange\": 10.0,\r\n \"price\": 40.0,\r\n \"priceperunit\": 0,\r\n \"period\": 1.0\r\n }\r\n ],\r\n\r\n // --- Subscription Logic ---\r\n // If you send an empty object {}, it triggers: DELETE FROM subscriptiontype.\r\n // If you send data, it attempts an UPDATE; if no row exists, it performs an INSERT.\r\n \"subscription\": {\r\n \"period\": 30.0,\r\n \"type\": \"Monthly\",\r\n \"value\": 150.0,\r\n \"automatic\": \"yes\"\r\n },\r\n\r\n // If 'rentalslots' is sent, ALL previous slots are deleted and replaced.\r\n \"rentalslots\": [\r\n {\r\n \"day\": 1, // 1=Monday, 7=Sunday.\r\n \"start_time\": \"08:00:00\",\r\n \"end_time\": \"12:00:00\"\r\n }\r\n ]\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/price.php","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","price.php"],"host":[""],"query":[],"variable":[]}},"response":[{"id":"580bb453-e530-42d7-b2c8-9e8e5a0edd44","name":"Update Price Item","originalRequest":{"method":"PATCH","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"id\": 187,\r\n \"price\": 7.00\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/price.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 08:01:12 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 08:01:12 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[{"expires":"Invalid Date","domain":"","path":""}],"responseTime":null,"body":"{\n \"success\": true,\n \"id\": 187\n}"}],"_postman_id":"2ccb90ff-9e44-4edc-9ce4-f96ce7750455"},{"name":"Delete Price Item","id":"4357a3ba-2338-4d77-a6c1-c5a5c3d0bbfb","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"/api/v1/price.php?id=1947","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","price.php"],"host":[""],"query":[{"key":"id","value":"1947"}],"variable":[]}},"response":[{"id":"ceb144de-e869-48ad-9fd0-ad9bb188ff18","name":"Delete an Item From Price List","originalRequest":{"method":"DELETE","header":[{"key":"Content-Type","value":"application/json"},{"key":"X-API-Key","value":"","description":"Added as a part of security scheme: apikey"}],"body":{"mode":"raw","raw":"{\n \"id\": 6525\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"/api/v1/price.php?id=6525","host":[""],"path":["api","v1","price.php"],"query":[{"key":"id","value":"6525"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 08:09:49 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 08:09:49 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"success\": true,\n \"id\": 6525,\n \"deleted\": true\n}"}],"_postman_id":"4357a3ba-2338-4d77-a6c1-c5a5c3d0bbfb"}],"id":"c9616fc0-85de-4ea1-98fc-608b83e29e98","_postman_id":"c9616fc0-85de-4ea1-98fc-608b83e29e98","description":"","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}}},{"name":"customers.php","item":[{"name":"Get Details of a Customer","id":"39cdcdfe-07d3-48d7-92a3-4c1ddd6c0e50","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":"/api/v1/customers.php?id=1947","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","customers.php"],"host":[""],"query":[{"key":"id","value":"1947"}],"variable":[]}},"response":[{"id":"e2ffd5a5-0b3e-4336-959b-6fa67be17957","name":"Get Details of a Customer","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":{"raw":"/api/v1/customers.php?id=128","host":[""],"path":["api","v1","customers.php"],"query":[{"key":"id","value":"128"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 08:10:26 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 08:10:25 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"id\": 1,\n \"name\": \"Nik Hazwan\",\n \"phone\": \"0193913193\",\n \"email\": \"nichshazwan@gmail.com\",\n \"address\": \"No 50G, Jalan PJU5/20D\",\n \"poscode\": \"47810\",\n \"account\": \"Sales\",\n \"ic\": \"870912115521\",\n \"membershipnumber\": \"QWERTY\",\n \"points\": \"204719\",\n \"pointsvalid\": \"2027-04-01\",\n \"membership\": \"2030-08-31\",\n \"percentdisc\": \"0\",\n \"business\": \"Mac 25 Enterprise 12\",\n \"username\": \"Nik Mohd Hazwan Nik Kamaruddin1\",\n \"blocked\": \"\",\n \"branch\": \"1\",\n \"tags\": \"\",\n \"birthmonthday\": \"0912\",\n \"autowhatsapp\": 1,\n \"introducer\": \"\",\n \"TIN\": \"\",\n \"id_type\": \"\",\n \"statecode\": \"\",\n \"countrycode\": \"\",\n \"cityname\": \"\",\n \"defaultOrderType\": \"\",\n \"timestamp\": \"2026-04-01 11:48:47\",\n \"addresses\": [\n {\n \"id\": 33,\n \"shortname\": \"Nik\",\n \"contactperson\": \"Nik\",\n \"phone\": \"0193913193\",\n \"address\": \"No 1, Jalan 2\",\n \"poscode\": \"47810\",\n \"email\": \"\",\n \"account\": \"\",\n \"tags\": \"\",\n \"type\": \"\",\n \"timestamp\": \"2026-04-03 14:54:24\"\n },\n {\n \"id\": 32,\n \"shortname\": \"Zahra\",\n \"contactperson\": \"Zahra\",\n \"phone\": \"0193913193\",\n \"address\": \"Kota Damansara\",\n \"poscode\": \"47810\",\n \"email\": \"\",\n \"account\": \"\",\n \"tags\": \"\",\n \"type\": \"\",\n \"timestamp\": \"2024-01-14 12:29:52\"\n },\n {\n \"id\": 31,\n \"shortname\": \"Nik Hazwan\",\n \"contactperson\": \"Nik Hazwan\",\n \"phone\": \"0193913193\",\n \"address\": \"No 50G, Jalan PJU5/20D\",\n \"poscode\": \"47810\",\n \"email\": \"nichshazwan@gmail.com\",\n \"account\": \"\",\n \"tags\": \"\",\n \"type\": \"new\",\n \"timestamp\": \"2026-04-01 11:48:47\"\n },\n {\n \"id\": 30,\n \"shortname\": \"Nik Kota Bharu &\",\n \"contactperson\": \"Aini\",\n \"phone\": \"0129116636\",\n \"address\": \"Ini Alah alamat\\r\\nKota Bharo\",\n \"poscode\": \"22000\",\n \"email\": \"\",\n \"account\": \"\",\n \"tags\": \"\",\n \"type\": \"\",\n \"timestamp\": \"2024-01-14 12:29:52\"\n },\n {\n \"id\": 29,\n \"shortname\": \"Nik Johor Bharu\",\n \"contactperson\": \"Aini2\",\n \"phone\": \"01291166365\",\n \"address\": \"Ini Alah alamat\\r\\nJohor Bharo\",\n \"poscode\": \"87361\",\n \"email\": \"\",\n \"account\": \"\",\n \"tags\": \"\",\n \"type\": \"\",\n \"timestamp\": \"2024-01-14 12:29:52\"\n }\n ],\n \"outstanding\": 7994.05,\n \"vouchervalue\": 2,\n \"vouchercount\": 1,\n \"voucherexpiry\": \"2026-05-31\"\n}"}],"_postman_id":"39cdcdfe-07d3-48d7-92a3-4c1ddd6c0e50"},{"name":"Get Additional Saved Address for a Customer","id":"21a82911-ad19-4615-be36-3355df297c80","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":"/api/v1/customers.php?addresses_for=1947","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","customers.php"],"host":[""],"query":[{"description":{"content":"

the customer id

\n","type":"text/plain"},"key":"addresses_for","value":"1947"}],"variable":[]}},"response":[{"id":"1d41f094-372f-4228-8d1a-28d32031b7f2","name":"Get Additional Saved Address for a Customer","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":{"raw":"/api/v1/customers.php?addresses_for=1","host":[""],"path":["api","v1","customers.php"],"query":[{"key":"addresses_for","value":"1","description":"the customer id"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 08:10:50 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 08:10:50 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"profileid\": 1,\n \"addresses\": [\n {\n \"id\": 33,\n \"shortname\": \"Nik\",\n \"contactperson\": \"Nik\",\n \"phone\": \"0193913193\",\n \"address\": \"No 1, Jalan 2\",\n \"poscode\": \"47810\",\n \"email\": \"\",\n \"account\": \"\",\n \"tags\": \"\",\n \"type\": \"\",\n \"timestamp\": \"2026-04-03 14:54:24\"\n },\n {\n \"id\": 32,\n \"shortname\": \"Zahra\",\n \"contactperson\": \"Zahra\",\n \"phone\": \"0193913193\",\n \"address\": \"Kota Damansara\",\n \"poscode\": \"47810\",\n \"email\": \"\",\n \"account\": \"\",\n \"tags\": \"\",\n \"type\": \"\",\n \"timestamp\": \"2024-01-14 12:29:52\"\n },\n {\n \"id\": 31,\n \"shortname\": \"Nik Hazwan\",\n \"contactperson\": \"Nik Hazwan\",\n \"phone\": \"0193913193\",\n \"address\": \"No 50G, Jalan PJU5/20D\",\n \"poscode\": \"47810\",\n \"email\": \"nichshazwan@gmail.com\",\n \"account\": \"\",\n \"tags\": \"\",\n \"type\": \"new\",\n \"timestamp\": \"2026-04-01 11:48:47\"\n },\n {\n \"id\": 30,\n \"shortname\": \"Nik Kota Bharu &\",\n \"contactperson\": \"Aini\",\n \"phone\": \"0129116636\",\n \"address\": \"Ini Alah alamat\\r\\nKota Bharo\",\n \"poscode\": \"22000\",\n \"email\": \"\",\n \"account\": \"\",\n \"tags\": \"\",\n \"type\": \"\",\n \"timestamp\": \"2024-01-14 12:29:52\"\n },\n {\n \"id\": 29,\n \"shortname\": \"Nik Johor Bharu\",\n \"contactperson\": \"Aini2\",\n \"phone\": \"01291166365\",\n \"address\": \"Ini Alah alamat\\r\\nJohor Bharo\",\n \"poscode\": \"87361\",\n \"email\": \"\",\n \"account\": \"\",\n \"tags\": \"\",\n \"type\": \"\",\n \"timestamp\": \"2024-01-14 12:29:52\"\n }\n ]\n}"}],"_postman_id":"21a82911-ad19-4615-be36-3355df297c80"},{"name":"List Customers / Details","id":"26543324-6808-430f-af87-48aeff166f9a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":"/api/v1/customers.php?search=string&tags=string&blocked=string&page=1&limit=50","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","customers.php"],"host":[""],"query":[{"description":{"content":"

General search on name, phone, email, ic, membership number, and business name.

\n","type":"text/plain"},"key":"search","value":"string"},{"key":"tags","value":"string"},{"description":{"content":"

\"order\" or \"blockoncreditlimit\"

\n","type":"text/plain"},"key":"blocked","value":"string"},{"key":"page","value":"1"},{"key":"limit","value":"50"}],"variable":[]}},"response":[{"id":"178f763f-9e1f-436f-8692-ae3000e1beb4","name":"Customer Search","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":{"raw":"/api/v1/customers.php?search=019391","host":[""],"path":["api","v1","customers.php"],"query":[{"key":"search","value":"019391"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 08:18:04 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 08:18:04 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"data\": [\n {\n \"id\": 123,\n \"name\": \"Jamilah kasim\",\n \"phone\": \"0193913193\",\n \"email\": \"\",\n \"address\": \"\",\n \"poscode\": \"\",\n \"account\": \"Sales\",\n \"ic\": \"\",\n \"membershipnumber\": \"\",\n \"points\": \"2319\",\n \"pointsvalid\": \"2025-07-23\",\n \"membership\": \"\",\n \"percentdisc\": \"0\",\n \"business\": \"\",\n \"blocked\": \"\",\n \"branch\": \"1\",\n \"tags\": \"\",\n \"birthmonthday\": \"\",\n \"timestamp\": \"2025-07-15 07:31:41\"\n },\n {\n \"id\": 91,\n \"name\": \"Customer & (Nama) Pelik\",\n \"phone\": \"0193913193\",\n \"email\": \"\",\n \"address\": \"\",\n \"poscode\": \"\",\n \"account\": \"Sales\",\n \"ic\": \"\",\n \"membershipnumber\": \"\",\n \"points\": \"0\",\n \"pointsvalid\": \"0000-00-00\",\n \"membership\": \"\",\n \"percentdisc\": \"0\",\n \"business\": \"\",\n \"blocked\": \"\",\n \"branch\": \"1\",\n \"tags\": \"\",\n \"birthmonthday\": \"\",\n \"timestamp\": \"2025-07-15 07:31:41\"\n },\n {\n \"id\": 55,\n \"name\": \"Qurratun\",\n \"phone\": \"0193913145\",\n \"email\": \"systemmailer25@gmail.com\",\n \"address\": \"No 50G, Jalan PJU5/20D\",\n \"poscode\": null,\n \"account\": null,\n \"ic\": null,\n \"membershipnumber\": \"\",\n \"points\": \"1100\",\n \"pointsvalid\": \"2023-07-18\",\n \"membership\": null,\n \"percentdisc\": null,\n \"business\": null,\n \"blocked\": \"\",\n \"branch\": \"1\",\n \"tags\": \"\",\n \"birthmonthday\": \"\",\n \"timestamp\": \"2025-07-15 07:31:41\"\n },\n {\n \"id\": 50,\n \"name\": \"Nik Mohd Hazwan Nik Kamaruddin\",\n \"phone\": \"60193913193\",\n \"email\": \"nichshazwan@gmail.com\",\n \"address\": \"\",\n \"poscode\": \"\",\n \"account\": \"Farmasi\",\n \"ic\": \"\",\n \"membershipnumber\": \"\",\n \"points\": \"20\",\n \"pointsvalid\": \"2026-01-07\",\n \"membership\": \"\",\n \"percentdisc\": \"\",\n \"business\": \"\",\n \"blocked\": \"\",\n \"branch\": \"1\",\n \"tags\": \"\",\n \"birthmonthday\": \"\",\n \"timestamp\": \"2025-07-15 07:31:41\"\n },\n {\n \"id\": 15,\n \"name\": \"Khairuddin &\",\n \"phone\": \"0193913193\",\n \"email\": \"khairud@qdrugs.com\",\n \"address\": \"Kota Masar, Negeri Sembilan\",\n \"poscode\": \"\",\n \"account\": \"\",\n \"ic\": \"\",\n \"membershipnumber\": \"\",\n \"points\": \"84\",\n \"pointsvalid\": \"2025-09-04\",\n \"membership\": \"2025-08-30\",\n \"percentdisc\": \"20\",\n \"business\": \"Q Drugs\",\n \"blocked\": \"\",\n \"branch\": \"1\",\n \"tags\": \"\",\n \"birthmonthday\": \"\",\n \"timestamp\": \"2026-04-01 11:23:31\"\n },\n {\n \"id\": 1,\n \"name\": \"Nik Hazwan\",\n \"phone\": \"0193913193\",\n \"email\": \"nichshazwan@gmail.com\",\n \"address\": \"No 50G, Jalan PJU5/20D\",\n \"poscode\": \"47810\",\n \"account\": \"Sales\",\n \"ic\": \"870912115521\",\n \"membershipnumber\": \"QWERTY\",\n \"points\": \"204719\",\n \"pointsvalid\": \"2027-04-01\",\n \"membership\": \"2030-08-31\",\n \"percentdisc\": \"0\",\n \"business\": \"Mac 25 Enterprise 12\",\n \"blocked\": \"\",\n \"branch\": \"1\",\n \"tags\": \"\",\n \"birthmonthday\": \"0912\",\n \"timestamp\": \"2026-04-01 11:48:47\"\n }\n ],\n \"total\": 6,\n \"page\": 1,\n \"limit\": 50,\n \"pages\": 1,\n \"sql\": \"SELECT id, name, phone, email, address, poscode, account, ic, membershipnumber,\\n points, pointsvalid, membership, percentdisc, business, blocked, branch, tags, birthmonthday, timestamp\\n FROM profile WHERE 1 AND (name LIKE ? OR phone LIKE ? OR email LIKE ? OR ic LIKE ? OR membershipnumber LIKE ? OR business LIKE ?) ORDER BY id DESC LIMIT 50 OFFSET 0\",\n \"params\": [\n \"%019391%\",\n \"%019391%\",\n \"%019391%\",\n \"%019391%\",\n \"%019391%\",\n \"%019391%\"\n ]\n}"}],"_postman_id":"26543324-6808-430f-af87-48aeff166f9a"},{"name":"Create / Upsert Customer","id":"e3d441ce-8774-433e-881f-d60603b27f9d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"name\": \"Ahmad Bin Ismail\", // Trimmed server-side.\r\n \"phone\": \"+6012-345 6789\", // Logic: Server strips all non-numeric characters to \"60123456789\". Server checks if phone number already exists, and update the profile if so.\r\n \"email\": \"ahmad.ismail@email.com\",\r\n \"address\": \"No. 25, Jalan Sultan Ismail, Bukit Bintang\",\r\n \"postcode\": \"50250\", // Priority key for postal code.\r\n \"account\": \"Sales\", // General account classification.\r\n \"branch\": \"KL-01\", // Used only if the server-side $branch variable is empty.\r\n \"ic\": \"870101-14-5555\", // Identification Card number.\r\n \"membershipnumber\": \"W25-99821\",\r\n \"business\": \"Ismail & Sons Enterprise\", // Business Name\r\n \"tags\": \"VIP, Wholesale\",\r\n \"percentdisc\": 10.5, // Cast to float; represents the percentage discount (e.g., 10.5%).\r\n \"membership\": \"Platinum\",\r\n \"birthmonthday\": \"09-17\", // Stored as a string (likely MM-DD or DD-MM).\r\n \"autowhatsapp\": \"1\", // Logic: Not cast, usually treated as \"1\" or \"0\" for notifications.\r\n \"TIN\": \"C2580102030\", // Tax Identification Number (Required for e-Invoicing).\r\n \"id_type\": \"NRIC\", // Type of ID (e.g., NRIC, PASSPORT, BRN).\r\n \"statecode\": \"14\", // LHDN/State numeric code (e.g., 14 for Kuala Lumpur).\r\n \"countrycode\": \"MYS\", // ISO Country Code.\r\n \"cityname\": \"Kuala Lumpur\"\r\n}\r\n\r\n//All parameters are optional except for name, and phone number","options":{"raw":{"language":"json"}}},"url":"/api/v1/customers.php","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","customers.php"],"host":[""],"query":[],"variable":[]}},"response":[{"id":"9877f3df-51d9-4e13-8439-57ac64ac8509","name":"Basic Customer Creation","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"name\": \"Ahmad Bin Ismail\", \r\n \"phone\": \"+6012-345 6789\", \r\n \"email\": \"ahmad.ismail@email.com\"\r\n}\r\n","options":{"raw":{"language":"json"}}},"url":"/api/v1/customers.php"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 08:19:40 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 08:19:40 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[{"expires":"Invalid Date","domain":"","path":""}],"responseTime":null,"body":"{\n \"success\": true,\n \"id\": 128,\n \"upserted\": \"created\"\n}"}],"_postman_id":"e3d441ce-8774-433e-881f-d60603b27f9d"},{"name":"Create Additional Address","id":"e652328d-4f4c-4ada-b32d-135c6e67241f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"action\": \"add_address\", // Required: Must match exactly to trigger this block.\r\n \"profileid\": 1001, // Required: The ID of the existing customer profile.\r\n \r\n // --- Address Details ---\r\n \"name\": \"HQ Office\", // Required: Acts as 'shortname'. Fallback is 'shortname'.\r\n \"shortname\": \"HQ Office\", // Fallback for 'name' if 'name' is missing.\r\n \"contactperson\": \"Nik\", // Optional: Defaults to the 'name' value if omitted.\r\n \"phone\": \"012-345 6789\", // Logic: Cleaned to digits only (\"0123456789\") server-side.\r\n \"address\": \"Level 25, Menara Tech, 50450 KL\", \r\n \"postcode\": \"50450\", // Priority key for postal code.\r\n \r\n // --- Metadata & Categorization ---\r\n \"email\": \"hq@business.com\",\r\n \"account\": \"Corporate\", // Associated pricing account type for this specific address.\r\n \"tags\": \"billing, primary\", // Comma-separated tags for filtering.\r\n \"type\": \"Work\" // Label for the address type (e.g., Home, Work, Billing).\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/customers.php","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","customers.php"],"host":[""],"query":[],"variable":[]}},"response":[{"id":"b20ed5d6-ad6c-4517-a902-173e707f21f9","name":"Create Additional Address","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"action\": \"add_address\", // Required: Must match exactly to trigger this block.\r\n \"profileid\": 1001, // Required: The ID of the existing customer profile.\r\n \r\n // --- Address Details ---\r\n \"name\": \"HQ Office\", // Required: Acts as 'shortname'. Fallback is 'shortname'.\r\n \"shortname\": \"HQ Office\", // Fallback for 'name' if 'name' is missing.\r\n \"contactperson\": \"Nik\", // Optional: Defaults to the 'name' value if omitted.\r\n \"phone\": \"012-345 6789\", // Logic: Cleaned to digits only (\"0123456789\") server-side.\r\n \"address\": \"Level 25, Menara Tech, 50450 KL\", \r\n \"postcode\": \"50450\", // Priority key for postal code.\r\n \r\n // --- Metadata & Categorization ---\r\n \"email\": \"hq@business.com\",\r\n \"account\": \"Corporate\", // Associated pricing account type for this specific address.\r\n \"tags\": \"billing, primary\", // Comma-separated tags for filtering.\r\n \"type\": \"Work\" // Label for the address type (e.g., Home, Work, Billing).\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/customers.php"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"e652328d-4f4c-4ada-b32d-135c6e67241f"},{"name":"Update Customer","id":"85ba24b7-3aab-4329-83ed-7fe3b17f4e97","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PATCH","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"id\": 1001, // Required: The ID of the customer to update.\r\n\r\n // --- Identity & Contact ---\r\n \"name\": \"Nik Hazwan\", \r\n \"phone\": \"+6012-345 6789\", // Will be cleaned to \"60123456789\" by the server.\r\n \"email\": \"nik@works25.com\",\r\n \"ic\": \"870101-14-5555\",\r\n \"id_type\": \"NRIC\", // Options typically: NRIC, PASSPORT, BRN.\r\n\r\n // --- Address & e-Invoicing ---\r\n \"address\": \"No. 25, Jalan Technology\",\r\n \"postcode\": \"47810\", // Priority key: if both 'postcode' and 'poscode' are sent, this is used.\r\n \"cityname\": \"Petaling Jaya\",\r\n \"statecode\": \"10\", // LHDN State Code (e.g., 10 for Selangor).\r\n \"countrycode\": \"MYS\", \r\n \"TIN\": \"C2580102030\", // Tax Identification Number.\r\n\r\n // --- Business & Membership ---\r\n \"business\": \"Works25 Tech\",\r\n \"membershipnumber\": \"W25-VIP-001\",\r\n \"membership\": \"2026-12-31\", // Date of membership expiry\r\n \"percentdisc\": 15.0, // Floating point discount percentage.\r\n \"birthmonthday\": \"0917\",\r\n \"introducer\": \"Agent_007\",\r\n \"tags\": \"priority,corporate\",\r\n\r\n // --- System & Preferences ---\r\n \"account\": \"Credit\",\r\n \"branch\": 1,\r\n \"autowhatsapp\": 1, // Enable/Disable automated WhatsApp notifications.\r\n \"blocked\": \"order\" // \"order\" or \"blockoncreditlimit\"\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/customers.php","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","customers.php"],"host":[""],"query":[],"variable":[]}},"response":[{"id":"f26128da-3e4c-4ae6-9db5-c98f96a550f2","name":"Update Customer","originalRequest":{"method":"PATCH","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"id\": 128, // Required: The ID of the customer to update.\r\n\r\n // --- Identity & Contact ---\r\n \"phone\": \"+6013-345 6789\", // Will be cleaned to \"60123456789\" by the server.\r\n \"email\": \"nik@works25.com\",\r\n \"ic\": \"870101-14-5555\",\r\n \"id_type\": \"NRIC\", // Options typically: NRIC, PASSPORT, BRN.\r\n\r\n // --- Address & e-Invoicing ---\r\n \"address\": \"No. 25, Jalan Technology\",\r\n \"postcode\": \"47810\", // Priority key: if both 'postcode' and 'poscode' are sent, this is used.\r\n \"cityname\": \"Petaling Jaya\",\r\n \"statecode\": \"10\", // LHDN State Code (e.g., 10 for Selangor).\r\n \"countrycode\": \"MYS\", \r\n \"TIN\": \"C2580102030\", // Tax Identification Number.\r\n \"business\": \"Works25 Tech\",\r\n \"percentdisc\": 15.0 // Floating point discount percentage.\r\n\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/customers.php"},"_postman_previewlanguage":"","header":[],"cookie":[{"expires":"Invalid Date","domain":"","path":""}],"responseTime":null,"body":""}],"_postman_id":"85ba24b7-3aab-4329-83ed-7fe3b17f4e97"},{"name":"Block Customer","id":"4ec42ee9-0e77-4d6a-b650-4adb2eb55529","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"/api/v1/customers.php?id=1947","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","customers.php"],"host":[""],"query":[{"key":"id","value":"1947"}],"variable":[]}},"response":[{"id":"e257f156-0bf3-4fc3-9616-f65988bb03e2","name":"Block a Customer from new order","originalRequest":{"method":"DELETE","header":[{"key":"Content-Type","value":"application/json"},{"key":"X-API-Key","value":"","description":"Added as a part of security scheme: apikey"}],"body":{"mode":"raw","raw":"{\n \"id\": 8584\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"/api/v1/customers.php?id=128","host":[""],"path":["api","v1","customers.php"],"query":[{"key":"id","value":"128"}]}},"status":"OK","code":200,"_postman_previewlanguage":"text","header":[],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"4ec42ee9-0e77-4d6a-b650-4adb2eb55529"}],"id":"411b627d-d0d9-4284-ba46-1329f308592b","_postman_id":"411b627d-d0d9-4284-ba46-1329f308592b","description":"","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}}},{"name":"jobs.php","item":[{"name":"Retrieve Jobs at a Station","id":"245acd95-b1ed-44c1-a612-273d83b2a2ae","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":"/api/v1/jobs.php?query=station&category=Dry Clean&item=Baju Melayu&process=Keringkan&period=current&status=Received&sort=desc","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","jobs.php"],"host":[""],"query":[{"key":"query","value":"station"},{"key":"category","value":"Dry Clean"},{"key":"item","value":"Baju Melayu"},{"key":"process","value":"Keringkan"},{"description":{"content":"

Order Date: current, todaysbill, todaysdue, future

\n","type":"text/plain"},"key":"period","value":"current"},{"description":{"content":"

Order Status: ReceivedorDone, Done, Received

\n","type":"text/plain"},"key":"status","value":"Received"},{"description":{"content":"

desc or asc

\n","type":"text/plain"},"key":"sort","value":"desc"}],"variable":[]}},"response":[{"id":"7fdb03f7-7027-4f83-bd08-85fba8fecce1","name":"Retrieve Jobs at a Station","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":{"raw":"/api/v1/jobs.php?query=station&category=Dry Clean&period=current&status=Received&sort=desc","host":[""],"path":["api","v1","jobs.php"],"query":[{"key":"query","value":"station","description":"Mandatory"},{"key":"category","value":"Dry Clean"},{"key":"item","value":"Baju Melayu","disabled":true},{"key":"process","value":"Keringkan","disabled":true},{"key":"period","value":"current","description":"Order Date: current, todaysbill, todaysdue, future"},{"key":"status","value":"Received","description":"Order Status: ReceivedorDone, Done, Received"},{"key":"sort","value":"desc","description":"desc or asc"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Server","value":"nginx"},{"key":"Date","value":"Fri, 03 Apr 2026 08:24:38 GMT"},{"key":"Content-Type","value":"application/json"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"X-Powered-By","value":"PHP/8.2.30"},{"key":"X-Powered-By","value":"PleskLin"},{"key":"X-Frame-Options","value":"SAMEORIGIN"},{"key":"X-Content-Type-Options","value":"nosniff"},{"key":"X-XSS-Protection","value":"1; mode=block"},{"key":"Referrer-Policy","value":"strict-origin-when-cross-origin"},{"key":"Permissions-Policy","value":"geolocation=(self), microphone=(self), camera=(self)"},{"key":"Cache-Control","value":"max-age=2592000"},{"key":"Expires","value":"Sun, 03 May 2026 08:24:38 GMT"},{"key":"Content-Encoding","value":"br"}],"cookie":[{"expires":"Invalid Date","domain":"","path":""}],"responseTime":null,"body":"{\n \"count\": 2,\n \"data\": [\n {\n \"delivery\": \"No\",\n \"reference\": \"\",\n \"bilid\": \"6FAA110EC1E7\",\n \"billnumber\": 1421,\n \"jobnumber\": 3696,\n \"date\": \"2026-04-03 15:53:04\",\n \"type\": \"2 Piece Baju Melayu\",\n \"category\": \"Dry Clean\",\n \"size\": \"1.000\",\n \"datesend\": \"2026-04-05 15:53:04\",\n \"name\": \"Nik\",\n \"phone\": \"0193913193\",\n \"shelf\": \"\",\n \"status\": \"Received\",\n \"branch\": \"2\",\n \"note\": \"Biru\",\n \"deliverydate\": \"2026-04-05\",\n \"deliverytime\": \"15:53:04\",\n \"profileid\": \"0\"\n },\n {\n \"delivery\": \"No\",\n \"reference\": \"\",\n \"bilid\": \"6FAA110EC1E7\",\n \"billnumber\": 1421,\n \"jobnumber\": 3697,\n \"date\": \"2026-04-03 15:53:04\",\n \"type\": \"2 Piece Baju Kurung\",\n \"category\": \"Dry Clean\",\n \"size\": \"5.000\",\n \"datesend\": \"2026-04-05 15:53:04\",\n \"name\": \"Nik\",\n \"phone\": \"0193913193\",\n \"shelf\": \"\",\n \"status\": \"Received\",\n \"branch\": \"2\",\n \"note\": \"Hitam\",\n \"deliverydate\": \"2026-04-05\",\n \"deliverytime\": \"15:53:04\",\n \"profileid\": \"0\"\n }\n ]\n}"}],"_postman_id":"245acd95-b1ed-44c1-a612-273d83b2a2ae"},{"name":"Retrieve images of an Order","id":"583ebf22-bdb7-4ad5-a62b-3a50e3614e3d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":"/api/v1/jobs.php?query=images&bilid=M679FUY","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","jobs.php"],"host":[""],"query":[{"description":{"content":"

images

\n","type":"text/plain"},"key":"query","value":"images"},{"description":{"content":"

the order unique identifier

\n","type":"text/plain"},"key":"bilid","value":"M679FUY"}],"variable":[]}},"response":[{"id":"9d3d656b-c675-4c8d-a42a-56cea2e3cf0d","name":"Retrieve images of an Order","originalRequest":{"method":"GET","header":[],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"text"}}},"url":{"raw":"/api/v1/jobs.php?query=images&bilid=M679FUY","host":[""],"path":["api","v1","jobs.php"],"query":[{"key":"query","value":"images","description":"images"},{"key":"bilid","value":"M679FUY","description":"the order unique identifier"}]}},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"583ebf22-bdb7-4ad5-a62b-3a50e3614e3d"},{"name":"Upload Image to job","id":"dc3d8987-aec9-4573-a8f5-495580259a2c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"orderlist_id\": 450, // Required: The specific job/item ID from the orderlist table.\r\n \"imageurl\": \"https://storage.works25.com/uploads/orders/img_8821.jpg\", // Required: The link to the hosted image.\r\n \"note\": \"Customer mentioned slight discoloration on the left sleeve.\", // Optional: Description or staff notes.\r\n \"igroup\": \"UIHG78\", // Optional: Unique identifier for the image group. Create your own, or leave blank.\r\n \"fromgallery\": 0 // Optional: 0 for direct camera capture, 1 for upload from device gallery.\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/jobs.php?query=images","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","jobs.php"],"host":[""],"query":[{"key":"query","value":"images"}],"variable":[]}},"response":[{"id":"a2d61c2b-f40d-4fdb-9336-f64cc4febc00","name":"Upload Image to job","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"orderlist_id\": 450, // Required: The specific job/item ID from the orderlist table.\r\n \"imageurl\": \"https://storage.works25.com/uploads/orders/img_8821.jpg\", // Required: The link to the hosted image.\r\n \"note\": \"Customer mentioned slight discoloration on the left sleeve.\", // Optional: Description or staff notes.\r\n \"igroup\": \"UIHG78\", // Optional: Unique identifier for the image group. Create your own, or leave blank.\r\n \"fromgallery\": 0 // Optional: 0 for direct camera capture, 1 for upload from device gallery.\r\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"/api/v1/jobs.php?query=images","host":[""],"path":["api","v1","jobs.php"],"query":[{"key":"query","value":"images"}]}},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"dc3d8987-aec9-4573-a8f5-495580259a2c"},{"name":"Change Job current process or location","id":"ea8e1f72-351a-4d06-b1d5-19cf0411422b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PATCH","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"orderlist_id\": 5566, // Required: The unique ID of the specific job item.\r\n \"status\": \"Returned\", // The current process or location of the item or job.\r\n \"staff\": \"Nik Hazwan\", // Optional: The staff member (username) performing the task.\r\n \"note\": \"Slight ink stain, customer requested re-wash.\", // Optional: Updates item notes.\r\n \r\n // --- Return & Refund Specifics ---\r\n \"amount\": 1.0, // Used if 'status' is 'Returned'. If < original size, creates a split/clone.\r\n \"percent\": 100.0 // Refund percentage (default 100). Impacts transaction calculations.\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/jobs.php","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","jobs.php"],"host":[""],"query":[],"variable":[]}},"response":[{"id":"9722a1b4-7dd0-4aaf-be6e-911dc1d23064","name":"Record A Returned Item","originalRequest":{"method":"PATCH","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"orderlist_id\": 5566, // Required: The unique ID of the specific job item.\r\n \"status\": \"Returned\", // The current process or location of the item or job.\r\n \"staff\": \"Nik Hazwan\", // Optional: The staff member (username) performing the task.\r\n \"note\": \"Slight ink stain, customer requested re-wash.\", // Optional: Updates item notes.\r\n \r\n // --- Return & Refund Specifics ---\r\n \"amount\": 1.0, // Used if 'status' is 'Returned'. If < original size, creates a split/clone.\r\n \"percent\": 100.0 // Refund percentage (default 100). Impacts transaction calculations.\r\n}\r\n\r\n// Should be used only if the bill status is Delivered","options":{"raw":{"language":"json"}}},"url":"/api/v1/jobs.php"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null},{"id":"b1881661-4929-43f8-bbdc-98cb9dc4bcc4","name":"Update Item or Job Status","originalRequest":{"method":"PATCH","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"orderlist_id\": 5566, // Mandatory\r\n \"status\": \"Drying\", // Mandatory\r\n \"staff\": \"Staff_A\" // Optional\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/v1/jobs.php"},"_postman_previewlanguage":null,"header":null,"cookie":[],"responseTime":null,"body":null}],"_postman_id":"ea8e1f72-351a-4d06-b1d5-19cf0411422b"},{"name":"Delete Captured Image","id":"6a84c182-e9c6-418a-847c-c6a13b4782d4","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[{"key":"Content-Type","value":"application/json"}],"body":{"mode":"raw","raw":"","options":{"raw":{"language":"json"}}},"url":"/api/v1/jobs.php?query=images&imageid=1947","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}},"urlObject":{"path":["api","v1","jobs.php"],"host":[""],"query":[{"key":"query","value":"images"},{"key":"imageid","value":"1947"}],"variable":[]}},"response":[{"id":"d2267c1e-99c6-4e4f-b9f6-adf86a569837","name":"Delete an Image","originalRequest":{"method":"DELETE","header":[{"key":"Content-Type","value":"application/json"},{"key":"X-API-Key","value":"","description":"Added as a part of security scheme: apikey"}],"body":{"mode":"raw","raw":"{\n \"imageid\": 3228\n}","options":{"raw":{"language":"json"}}},"url":{"raw":"/api/v1/jobs.php?query=images&imageid=1947","host":[""],"path":["api","v1","jobs.php"],"query":[{"key":"query","value":"images"},{"key":"imageid","value":"1947"}]}},"status":"OK","code":200,"_postman_previewlanguage":"text","header":[],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"6a84c182-e9c6-418a-847c-c6a13b4782d4"}],"id":"1f5f3da0-24e6-4fa9-984f-a73da7713f08","_postman_id":"1f5f3da0-24e6-4fa9-984f-a73da7713f08","description":"","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}}}],"id":"b357455d-038b-46c2-ae7c-36082a5d1aa7","description":"

Works25 API Specification (v1)

This document outlines the exposed REST endpoints for the Works25 POS System. The API is designed to proxy native web engine behaviors securely, guaranteeing identical validation sequences for schedules, stock controls, and ledger translations.

Authentication

Every request must be authenticated via headers using a system-issued API Key. IP-restrictions and request logging are actively enforced:

X-API-Key:

Get API Key from Settings > Integration > API Keys

(Alternative: _Authorization: Bearer_ is also supported)

Orders (`/api/v1/orders.php`)

Create Order

POST /api/v1/orders.php

Creates a complete order. This API executes as a pure proxy to the internal web engines—packages will automatically unroll into sub-components, recurring parameters dynamically clone records into the future, and customer details will intelligently merge or initialize.

(Note: Payment is strictly separated from order creation and must be posted on the Checkout endpoint).

1. Main JSON Payload

\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\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\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

Field	Type	Requirement	Default	Description
`customer_id`	integer	Optional	`0` (Guest)	Links to `profile.id`. The API natively compares supplied `name`, `phone`, `address`, and `postcode` payloads against the registered profile. Any mismatch instantly generates a preserved `profileaddress` alias.
`name`	string	Conditional	`\"\"`	Consumer / Ordering Party name. (Required if constructing a new `_profileaddress_` without a master profile)
`phone`	string	Optional	`\"\"`	Consumer / Ordering Party contact.
`address`	string	Optional	`\"\"`	Primary billing / delivery string.
`postcode`	string	Optional	`\"\"`	Delivery area code natively parsed for routing.
`acc`	string	Optional	Auto-Evaluated	Revenue Catalog Account. If totally omitted, the API iterates through `$items[0]` to safely resolve a generalized pricing branch / customer-linked target `$account` constraint.
`date`	string	Optional	`Now`	Expected syntax `Y-m-d H:i:s`. Overrides the baseline checkout timestamp.
`type`	string	Optional	System Default	Set explicitly to `\"D.O.\"` or `\"S.O.\"` to categorize as a pro-forma or draft order. Doing so actively prevents Account Receivable `transaction` ledgers from being generated upfront.
`isdo`	boolean	Optional	`false`	Native shorthand equivalent to explicitly establishing `type` as `\"D.O.\"`.
`delivery`	string	Optional	`\"No\"`	Shipping/Handling classification map (\"`Yes`\" or \"`No`\"). Stored into native `.delivery` field on the record block.
`reference`	string	Optional	`\"\"`	Used to store external links, transaction references, or external database ID maps.
`comments`	string	Optional	`\"\"`	Comments Or Notes. Prints natively beneath internal receipts and billings.
`tags`	string	Optional	`\"\"`	Order routing classification tags globally accessible.
`promocode`	string	Optional	`\"\"`	Marketing metric link tracking parameters.
`apply_rounding`	boolean	Optional	`true`	Enables native 5-cent rounding mathematics evaluated onto the invoice final block.
`discper`	float	Optional	`0`	Global cart percentage discount. Providing `0` natively polls the backend `profile` metrics for generalized member percentages.

2. Repeating Scheduled Orders (Recurring Billing)

Passing the recur structure natively replicates the order outwards recursively across the database spanning parallel clones for dueandcharges, orderlists, jobsdone, subscriptions arrays identically mirroring system scheduling logic.

\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\n\n\n\n\n\n\n\n\n\n\n\n

Field	Type	Requirement	Example	Description
`recur`	string	Optional	`\"monthly\"`	Core repeating interval schedule `daily`, `weekly`, `monthly`, `yearly`
`recurcount`	integer	Conditional	`6`	Amount of copies generated iteratively into the future. (Required if `_recur_` is provided)
`recurfrom`	date	Optional	`\"YYYY-MM-DD\"`	Baseline start date resolving sequences
`recurevery`	integer	Optional	`1`	Step interval parameter modifier (e.g., Every 2 Weeks)
`monthStep`	string	Optional	`\"first\"`	Resolvable text scheduling modifiers (`first`, `last`)
`weekDay`	string	Optional	`\"Monday\"`	Text scheduling offset target

3. Inserting Items: `items[]`

The items array accepts highly granular component bounds perfectly aligning to the web store's configuration constraints (e.g., oncealife, goodmove proxy evaluation, Package Extraction hooks).

Basic Item Example:

{\n  \"priceid\": 12,\n  \"qty\": 2.5,\n  \"startDateTime\": \"2026-03-25T14:00\",\n  \"assignedstaff\": [\"John\", \"Jane\"]\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\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\n\n

Field	Type	Requirement	Description
`qty` / `size`	float	Mandatory	The quantity mapping for calculation multipliers. Must be `> 0`.
`priceid`	integer	Conditional	Item Catalog Identifier bridging constraints (period, bounds, discount rates, points, subscriptions, subitem structures) dynamically inherited directly from `price` table. (Required unless bypassing system catalog via generic payload overrides)
`type`	string	Conditional	Overrides the categorized classification structure natively inherited. (Mandatory if bypassing `_priceid_`)
`category`	string	Conditional	Overrides the categorized taxonomy structure. (Mandatory if bypassing `_priceid_`)
`price`	float	Conditional	Total price for the item line. Not unit price. Overrides the baseline selling cost string calculation dynamically. (Mandatory if bypassing `_priceid_`)
`taxpercent`	float	Optional	Explicitly maps tax allocations, in %.
`note`	string	Optional	Descriptive instruction. Also evaluates into `\"useNoteAsIdentifier\"` natively over subscriptions tracking.
`useNoteAsIdentifier`	boolean	Optional	Actively casts the `$note` payload as the `subscriptions` identifier alias mapped to subscriptions generated from `priceid` mapping traits.
`startDateTime`	string	Optional	Initializes a native `rentalbooking` transaction blocking out resource booking bounds explicitly resolving starting points. `(Y-m-d H:i)`
`endDateTime`	string	Optional	Finishes the bounds initialization on `rentalbooking` records. Closes workflow endpoints within `jobsdone`. `(Y-m-d H:i)`
`pickupdatetime`	string	Optional	Hard override mapping explicitly the sequence boundary for item delivery dispatch target bypassing native business-hours `datesend` calculations. `(Y-m-d H:i)`
`assignedstaff`	array	Optional	Generates internal allocations mapping explicitly linked workers / operators down into the `jobsdone` queue corresponding precisely to the mapped shelf / active process.

Example Standard API Delivery Order

This example bypasses transaction creation as it categorizes functionally as a drafted D.O. while enforcing a subscription parameter binding utilizing the $note.

{\n    \"customer_id\": 2045,\n    \"phone\": \"0123456789\",\n    \"name\": \"Jane Tester\",\n    \"type\": \"D.O.\",\n    \"isdo\": true,\n    \"apply_rounding\": true,\n    \"items\": [\n        {\n            \"priceid\": 240,\n            \"qty\": 1,\n            \"note\": \"JaneT-Sub-Mar\",\n            \"useNoteAsIdentifier\": true,\n            \"assignedstaff\": [\"AgentSmith\"]\n        }\n    ]\n}\n\n

JSON Response Handlers

If verification succeeds bypassing oncealife bounds, system pricing parameters, and business schedules, it evaluates identically formatted database returns.

{\n    \"success\": true,\n    \"id\": 105992,\n    \"bilid\": \"O_D1B3X91S\",\n    \"sumprice\": 105.00,\n    \"tax\": 2.10,\n    \"rounding\": 0.05,\n    \"items\": [\n        {\n            \"id\": 1284,\n            \"type\": \"Rental\",\n            \"category\": \"Equipment\",\n            \"qty\": 1,\n            \"price\": 105.00,\n            \"taxpercent\": 2\n        }\n    ]\n}\n\n

Get Orders (List)

GET /api/v1/orders.php

Returns a paginated list of orders mirroring the internal status dashboard query. Joins dueandcharge, company, and profile tables for enriched data.

Query Parameters

\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\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

Parameter	Type	Requirement	Default	Description
`date_from`	string	Optional	—	Filter start date `(YYYY-MM-DD)`.
`date_to`	string	Optional	—	Filter end date `(YYYY-MM-DD)`. Automatically appends `23:59:59`.
`status`	string	Optional	`all`	`received`, `done`, `delivered`, `pending`, `voided`, `undelivered`, `unvoided`, `done or delivered`, `all`.
`unpaid`	string	Optional	`all`	`due` (outstanding > 0.01), `paid` (outstanding ≤ 0.01), or omit for all.
`type`	string	Optional	—	`D.O.`, `S.O.`, or `Invoice` or `\"\"` for general orders.
`profileid`	integer	Optional	—	Filter by customer profile ID.
`page`	integer	Optional	`1`	Page number for pagination.
`limit`	integer	Optional	`50`	Records per page (max `200`).

Response

{\n    \"data\": [\n        {\n            \"id\": 105992,\n            \"bilid\": \"O_D1B3X91S\",\n            \"name\": \"Jane Tester\",\n            \"phone\": \"60123456789\",\n            \"date\": \"2026-03-29 10:00:00\",\n            \"status\": \"Received\",\n            \"due\": 105.00,\n            \"charge\": 105.00,\n            \"delivery\": \"Yes\",\n            \"deliveryaddress\": \"123 Main St\",\n            \"deliverypostcode\": \"50000\",\n            \"deliverydate\": \"\",\n            \"deliverytime\": \"\",\n            \"profileid\": 2045,\n            \"reference\": \"\",\n            \"discper\": 0,\n            \"type\": \"\",\n            \"accept\": \"admin\",\n            \"staff\": \"\",\n            \"promocode\": \"\",\n            \"account\": \"Sales\",\n            \"tags\": \"\",\n            \"pickupdate\": \"\",\n            \"branch\": \"1\",\n            \"branchinitial\": \"HQ\",\n            \"business\": \"\"\n        }\n    ],\n    \"total\": 1284,\n    \"page\": 1,\n    \"limit\": 50,\n    \"pages\": 26\n}\n\n

Get Order Detail

GET /api/v1/orders.php?bilid=

Returns a single order with full record fields, nested line items (with package subitems), jobsdone assignments, and subscriptions.

Query Parameters

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

Parameter	Type	Requirement	Description
`bilid`	string	Mandatory	The unique system bill identifier.

Response Structure

The response includes all record fields plus:

due / charge — from dueandcharge table
\n
items[] — line items ordered by billorder, each with a nested subitems[] array for package components
\n
jobsdone[] — staff process assignments with commission values
\n
subscriptions[] — active subscription mappings linked to this order
\n

Response Example

{\n    \"bilid\": \"O_D1B3X91S\",\n    \"id\": 105992,\n    \"name\": \"Jane Tester\",\n    \"phone\": \"60123456789\",\n    \"date\": \"2026-03-29 10:00:00\",\n    \"status\": \"Received\",\n    \"sumprice\": 105.00,\n    \"tax\": 2.10,\n    \"rounding\": 0.05,\n    \"due\": 105.00,\n    \"charge\": 105.00,\n    \"delivery\": \"Yes\",\n    \"deliveryaddress\": \"123 Main St\",\n    \"deliverypostcode\": \"50000\",\n    \"items\": [\n        {\n            \"id\": 1284,\n            \"category\": \"Equipment\",\n            \"type\": \"Rental\",\n            \"size\": 1,\n            \"price\": 105.00,\n            \"note\": \"\",\n            \"shelf\": \"\",\n            \"subitems\": []\n        }\n    ],\n    \"jobsdone\": [\n        { \"orderid\": 1284, \"process\": \"Clean\", \"staff\": \"John\", \"commission\": 5.25, \"timestamp\": \"2026-03-29 10:05:00\" }\n    ],\n    \"subscriptions\": []\n}\n\n

Update Order

PATCH /api/v1/orders.php

This endpoint acts as the central hub for safely editing an active order. Unlike raw database queries, modifying an order via this system perfectly duplicates the POS interface behavior.

Payload Structure

\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\n\n\n\n\n

Field	Type	Requirement	Description
`bilid`	string	Mandatory	The unique system bill identifier assigned upon creation.
`status`	string	Optional	State modifier. System natively protects constraints validating the forward sequence dynamically: `Received -> Pending / Done`, `Pending -> Done / Delivered`, `Done -> Delivered`. Reversing sequences yields an error.
`date`	string	Optional	Overwrites the core global mapping sequence `(Y-m-d H:i:s)`. Modifies cascading traits (`transactions.date` / `subscriptions.date`). Enforces `locktransactionsbefore` check securely.
`accept`	string	Optional	Updates the administrative attendant identity mapped onto `record.accept`.
`promoter`	string	Optional	Updates the designated commission target mapped tracking staff string securely parsing locally onto `record.staff`.
`comments`	string	Optional	Edits the POS thermal printing note.

Native State Hooks Fired Dynamically

Inventory Costs Commitments: Reaching Done or Delivered triggers the API to evaluate real-time cost margins resolving components actively off generic Orderlist staging grids placing them definitively as \"Sales\" lock increments affecting aggregate inventory natively!
\n
S.O. Consolidations: Pushing a draft Sales Order (type = S.O.) to Done/Delivered explicitly formulates total mathematical sums securely dropping its drafted .type string extracting definitive Accounts Receivable ledger rows dynamically mapping taxes into the system dynamically.
\n
Jobsdone Commissions: Empty sub-targets automatically split base bounds resolving fractions dynamically securely allocating staff balances upon transition to Done or Delivered.
\n

Headless Notifications Arrays Fired

To safely mimic POS native behavior natively out of webhook interactions, updating the $status triggers direct integration arrays seamlessly:

Pending****: Pings your Web Push systems mapping \"Pending Orders\".
\n
Pending / Received / Done / Delivered****: Matches your company templates parsing [NAME] and [BILL-LINK], pushing customized cURL messages across the active Wsapme (WhatsApp) gateway integration natively targeted at the profile strings.
\n
Done****: Validates individual customer Push Notification endpoints, natively pinging external App bounds confirming the target is explicitly scheduled for delivery or pickup logic!
\n

Void Order

DELETE /api/v1/orders.php

Soft-deletes an order by setting its status to Void. This endpoint does not physically remove the record — it mirrors the internal void cascade used by the POS system.

Payload / Query

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

Field	Type	Requirement	Description
`bilid`	string	Mandatory	Can be sent in JSON body or as a query parameter.

Pre-Validation Guards

The API will reject the void request (400 Bad Request) if any of the following conditions are true:

\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

Condition	Error Message
Order status is `Done` or `Delivered`	Only Received or Pending orders can be voided.
Order has an `einv_uuid`	Cannot void an order that has an issued e-invoice.
Order date ≤ `locktransactionsbefore`	Order date is on or before the lock date. Cannot void.
Transactions are `checked='OK'` or date < lock date	Order has checked or locked transactions. Cannot void.
Order is already `Void`	Order is already voided.

Void Cascade Effects

Upon successful validation, the following operations execute (mirroring admin/takingorder/api.php):

All transaction rows with toacc of Receivable, Discount Voucher, or Points are zeroed out.
\n
record.status is set to Void.
\n
subscriptions.status is set to Void.
\n
If the order was linked to an invoice (invoiceid), the parent invoice is marked Recalculate.
\n
All orderlist items are deleted (except category = 'Administrative').
\n
All jobsdone entries are deleted.
\n
Uncommitted goodmove placeholders are deleted.
\n
A pushtotopic(\"orders\") notification is fired.
\n

Response

{ \"success\": true, \"bilid\": \"O_D1B3X91S\", \"status\": \"Void\" }\n\n

Checkout & Payments (`/api/v1/checkout.php`)

(Documentation forthcoming. Handles final consolidation logic and fiscal transaction ledger generation upon full capture).

Payments & Debtors (`/api/v1/payments.php`)

Manages the recording of independent payments against orders and the retrieval of complex centralized debtor reporting metrics mimicking core POS interactions.

\n
[!TIP]
\n

Credit Overshoots: Rather than distributing explicit manual credit notes on excess payment, the system dynamically registers mathematical overshoots (where paid amount > outstanding due) natively against the Receivable ledger tracking. These negative receivables inherently serve as valid Credits on the client profile automatically.

Record a Payment

POST /api/v1/payments.php

Validates and accurately logs a partial or full payment transaction against an order.

Payload Options:

\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

Field	Type	Requirement	Description
`bilid`	string	Mandatory	The system order identifier.
`amount`	float	Mandatory	Absolute payment amount. Submitting an amount greater than the `balance_due` will safely map the remainder as Credits natively.
`method`	string	Optional	Tender method (e.g., `Cash`, `Maybank`, or `Credits`). Default: `Cash`.
`paymentreference`	string	Optional	External reference, receipt numbers, or gateway codes.

If the parameter method: \"Credits\" is explicitly used, the backend calculates the amount algorithmically across existing valid explicit creditnote records tied to the user.
\n
Upon reducing the order due balance <= 0, the endpoint intelligently simulates the core UI behavior by firing a background renewsubscription CURL dispatch to finalize internal status/workflow dependencies effortlessly.
\n

Response Output:

{\n  \"success\": true,\n  \"bilid\": \"O_D1B3X91S\",\n  \"paid_amount\": 100.00,\n  \"method\": \"Cash\",\n  \"balance_due\": 0,\n  \"is_paid\": true,\n  \"credited_overshoot\": 50.00\n}\n\n

List Payments Map

GET /api/v1/payments.php?bilid=

Returns the exact total charged, previously paid, resolving remaining balances mapped with chronological transactional arrays.

Debtors Aging Report

GET /api/v1/payments.php?query=debtors_aging

Emulates the complex 5-month aging array algorithm originally accessible under /admin/report/report_debtors.php.

Query Parameters

dateto: Date limit for calculating reporting depth arrays (Default: YYYY-MM-DD today).

Grouping Logic Schema (Nested Node Responses)

Evaluates strict active balances sorting the highest total_balance debtor to lowest.
\n
Each profile array resolves current, 1_month, 2_months, 3_months, 4_months, and 5_months_plus bucketized sums.
\n

Catalog Pricing (`/api/v1/price.php`)

Full CRUD interactions for point-of-sale catalog items (price), including complex relationships with variant selections, addons, tiered ranges, and recurring billing.

List Active Prices

GET /api/v1/price.php

Paginated listing of non-archived catalog items.

Query Parameters

\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

Parameter	Type	Default	Description
`search`	string	—	Fuzzy search by `type`, `category`, or `identifier`.
`category`	string	—	Exact match filter for `category`.
`page`	integer	`1`	Page number.
`limit`	integer	`50`	Results per page (max 200).

Get Item Detail

GET /api/v1/price.php?id=

Returns the core item details alongside fully resolved nested arrays for configurations.

Response Structure

Base price columns (category, type, price, taxpercent, account, identifier, ispackage, etc.)
\n
selections[]: Up to 3 objects representing choice modifiers (combines pricecustom and pricecustomoptions).
\n
addons[]: Array of optional item add-ons (question/unitvalue mapped to option/value).
\n
ranges[]: Wholesale or tiered volume pricing thresholds.
\n
subscription: An object (if configured) defining recurring billing rules (type, period, value, automatic).
\n
rentalslots[]: Operating day/time constraints.
\n

Create Item

POST /api/v1/price.php

Creates a new core item and seamlessly builds related tables based on provided arrays.

Payload Schema (Core)

\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\n\n\n\n\n

Field	Type	Requirement	Description
`category`	string	Mandatory	Item category name.
`type`	string	Mandatory	Item name.
`price`	float	Optional	Base price (Default: 0).
`account`	string	Optional	Revenue GL account.
`identifier`	string	Optional	Barcode or SKU (syncs to `goodprice` automatically).
`taxpercent`	float	Optional	Specific tax rate for the item.

Payload Schema (Nested Relationships)

Provide these arrays to automatically build constraints. All are optional.

{\n  \"category\": \"Food\",\n  \"type\": \"Signature Burger\",\n  \"price\": 15.50,\n  \"selections\": [\n     {\n       \"question\": \"Choose Drink\",\n       \"multi\": 0,\n       \"options\": [\n          {\"option\": \"Coke\", \"value\": 0, \"operation\": \"Add\"},\n          {\"option\": \"Juice\", \"value\": 2.50, \"operation\": \"Add\"}\n       ]\n     }\n  ],\n  \"addons\": [\n     {\"option\": \"Extra Cheese\", \"value\": 3.00}\n  ],\n  \"ranges\": [\n     {\"startrange\": 10, \"endrange\": 50, \"price\": 14.00, \"priceperunit\": 14.00, \"period\": 0}\n  ],\n  \"subscription\": {\n     \"type\": \"Months\",\n     \"period\": 1,\n     \"value\": 25.00,\n     \"automatic\": \"Yes\"\n  },\n  \"rentalslots\": [\n     {\"day\": 8, \"start_time\": \"10:00:00\", \"end_time\": \"12:00:00\"}\n  ]\n}\n\n

Update Item

PATCH /api/v1/price.php

Modifies an item. For base fields, only the provided keys are written to the database.

\n
[!WARNING]
\n

Wipe and Replace Strategy: For nested relationships (selections, addons, ranges, subscription, rentalslots), the system ensures rigid state adherence by performing a complete wipe-and-replace. If you send the array, all existing entries of that type will be deleted and replaced with the new array. If the key is omitted from the JSON entirely, the existing rules are untouched.

Payload

Must contain id (integer). Accepts all fields described in the POST payload.

Physically Delete Item

DELETE /api/v1/price.php

Performs a raw physical cascading delete, wiping the item from price and all associated tables (packages, goodprice, pricecustom, pricecustomoptions, pricerange, subscriptiontype, rentalslots, jobsprocess).

Payload

Must contain id (integer) either in JSON body or ?id= query string.

Customers (`/api/v1/customers.php`)

List Customers

GET /api/v1/customers.php

Paginated customer listing with search and filter support.

Query Parameters

\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\n\n\n\n\n

Parameter	Type	Requirement	Default	Description
`search`	string	Optional	—	Fuzzy match across `name`, `phone`, `email`, `ic`, `membershipnumber`, `business`.
`tags`	string	Optional	—	Filter by tag (CSV-compatible REGEXP match).
`blocked`	string	Optional	—	Filter: `Yes` or empty string.
`page`	integer	Optional	`1`	Page number.
`limit`	integer	Optional	`50`	Records per page (max `200`).

Get Customer Detail

GET /api/v1/customers.php?id=

Returns full profile including alternative addresses, outstanding balance, and active vouchers.

Response Includes

All profile fields (name, phone, email, address, IC, TIN, membership, points, etc.)
\n
addresses[] — from profileaddress table
\n
outstanding — calculated receivable debt
\n
vouchervalue / vouchercount / voucherexpiry — active voucher aggregation
\n

Create / Upsert Customer

POST /api/v1/customers.php

Creates a new customer or updates an existing one matched by phone.

Payload

Field	Type	Requirement	Description
`name`	string	Mandatory	Customer name.
`phone`	string	Optional	Sanitized to numerics. Used as upsert match key.
`email`	string	Optional	Email address.
`address`	string	Optional	Primary address.
`postcode`	string	Optional	Postal code (also accepts `poscode`).
`account`	string	Optional	Revenue account link.
`ic`	string	Optional	Identity card / passport number.
`membershipnumber`	string	Optional	Membership ID.
`business`	string	Optional	Business/company name.
`tags`	string	Optional	Comma-separated tags.
`percentdisc`	float	Optional	Default discount percentage.
`membership`	string	Optional	Membership tier.
`birthmonthday`	string	Optional	Birthday (MM-DD format).
`autowhatsapp`	tinyInt	Optional	WhatsApp auto-send preference. 1 or 0
`TIN`	string	Optional	Tax Identification Number (e-invoice).
`id_type`	string	Optional	ID type for e-invoice (`NRIC`, `BRN`, etc.).
`statecode`	string	Optional	State code for e-invoice.
`countrycode`	string	Optional	Country code for e-invoice.
`cityname`	string	Optional	City name for e-invoice.

Response

{ \"success\": true, \"id\": 2045, \"upserted\": \"created\" }\n\n

Update Customer

PATCH /api/v1/customers.php

Updates specific fields on an existing customer. Only provided fields are modified.

Payload

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

Field	Type	Requirement	Description
`id`	integer	Mandatory	The profile ID to update.
any		Optional	Any field from the POST payload above.

Block Customer

DELETE /api/v1/customers.php

Soft-blocks a customer by setting blocked = 'Yes'. Does not delete the record.

Payload / Query

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

Field	Type	Requirement	Description
`id`	integer	Mandatory	Can be sent in JSON body or query parameter.

Response

{ \"success\": true, \"id\": 2045, \"blocked\": \"Yes\" }\n\n

Jobs & Queues (`/api/v1/jobs.php`)

List Jobs by Station

GET /api/v1/jobs.php?query=station

Retrieves a paginated/filtered list of orderlist jobs natively matched against active queue parameters.

Query Parameters

\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\n\n\n\n\n

Parameter	Type	Default	Description
`category`	string	`allcategories`	Filter by exact category (e.g. `Printing`).
`process`	string	`allprocesses`	Filter by exact process/shelf (e.g. `Bindery`).
`item`	string	`allitems`	Filter by item type.
`period`	string	`all`	`current`, `todaysbill`, `todaysdue`, `future`, `all`.
`status`	string	`Received`	Filters overarching bill state: `ReceivedorDone`, `Done`, `Received`.
`sort`	string	`desc`	`asc` or `desc` targeting date ordering.

Response

{\n \"count\": 1,\n \"data\": [\n {\n \"delivery\": \"No\",\n \"reference\": \"\",\n \"bilid\": \"O_D1B3X91S\",\n \"jobnumber\": 431,\n \"date\": \"2026-03-31 10:00:00\",\n \"type\": \"Flyer\",\n \"category\": \"Printing\",\n \"size\": 500,\n \"name\": \"John Doe\",\n \"shelf\": \"Design\",\n \"status\": \"Received\"\n }\n ]\n}\n\n

Update Job Status (Process Migration)

PATCH /api/v1/jobs.php

Acts as the operational core mimicking exactly UI process advancement. Natively handles standard queue transitions, auto-staff assignments, explicit Returned logic blocks (auto-generating destructive inventory reversals and fractional quantity splitting mechanisms automatically), automatic Goods Sold insertions, and calculates flat or % based dynamic jobsprocess commission metrics writing directly to the jobsdone indices globally.

Payload

\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

Field	Type	Requirement	Description
`orderlist_id`	integer	Mandatory	Target job identifier (`orderlist.id`).
`status`	string	Optional	New process/station classification target.
`staff`	string	Optional	Assigned executor. Required parameter bounds if `jobsprocess` commissions are triggered explicitly.
`note`	string	Optional	Overrides the operational note natively log-recorded.
`amount`	float	Optional	Explicit partial unit identifier explicitly consumed when handling `Returned` flows exclusively parsing fractional reductions natively.

\n
[!NOTE]
\n

Auto-Resolution Binding: Any process update natively validates the sibling states of all jobs under the parent bilid. If $0$ jobs remain marked inside standard Process shelves (Pending, QC, -), the API automatically cascades the encompassing record.status dynamically to Done echoing checkshelfifdone() functionality flawlessly.

Retrieve Order Capture Assets

GET /api/v1/jobs.php?query=images&bilid=

Aggregates mapped metadata and URL resolutions explicitly tied exclusively to orderimages associations bounding directly against exact orderlistid grouping blocks.

Response

{\n  \"bilid\": \"O_D1B3X91S\",\n  \"images\": {\n    \"431\": [\n      {\n        \"orderlistid\": 431,\n        \"imageurl\": \"https://img.host.com/123\",\n        \"date\": \"2026-03-31 11:00:00\",\n        \"staff\": \"admin\",\n        \"igroup\": \"Artwork\",\n        \"process\": \"Design\"\n      }\n    ]\n  }\n}\n\n

Store Order Capture Assets

POST /api/v1/jobs.php?query=images

Inserts new image metadata logs pointing to remote image resources stored externally, mapping directly to orderlist entries.

Payload

\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

Field	Type	Requirement	Description
`orderlist_id`	integer	Mandatory	The target job index to attach the capture to.
`imageurl`	string	Mandatory	Fully qualified URL of the artifact storage location.
`note`	string	Optional	Optional context string.
`igroup`	string	Optional	Defined categorical boundary (e.g. `Artwork`, `Result`).
`fromgallery`	integer	Optional	Value `1` if uploaded from desktop via storage prompt or `0` (Capture).

Response

{\n  \"success\": true,\n  \"imageid\": 9923,\n  \"bilid\": \"O_D1B3X91S\"\n}\n\n

Delete Order Capture Assets

DELETE /api/v1/jobs.php?query=images

Orchestrates a physical remote deletion against cloud infrastructure (imagedelivery.net / files.works25.com) prior to dissolving the database binding. Images tagged dontdelete = 1 are dynamically shielded and will deny execution.

Payload

Accepts imageid payload parameter either dynamically mapped within JSON or injected via $GET string constraints.

Response

{\n  \"success\": true,\n  \"deletedimageid\": 9923,\n  \"domain\": \"imagedelivery.net\",\n  \"remoteid\": \"cloudflare-remote-token-110\",\n  \"url\": \"https://imagedelivery.net/account/cloudflare-remote-token-110\"\n}\n\n

\n","_postman_id":"b357455d-038b-46c2-ae7c-36082a5d1aa7","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}}}],"id":"c372b318-c17b-4759-865a-082176bf99f0","_postman_id":"c372b318-c17b-4759-865a-082176bf99f0","description":"","auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]},"isInherited":true,"source":{"_postman_id":"5ea60f44-0233-47d3-a951-6933553972b4","id":"5ea60f44-0233-47d3-a951-6933553972b4","name":"Works25 API","type":"collection"}}}],"auth":{"type":"apikey","apikey":{"basicConfig":[{"key":"key","value":"X-API-Key"},{"key":"value","value":""}]}},"event":[{"listen":"prerequest","script":{"id":"f3024129-3f02-467e-bea4-676180fda6c1","type":"text/javascript","packages":{},"requests":{},"exec":[""]}},{"listen":"test","script":{"id":"ae928daa-0d55-4228-8a6d-8e1944b69659","type":"text/javascript","packages":{},"requests":{},"exec":[""]}}],"variable":[{"key":"baseUrl","value":""},{"key":"apiKey","value":""}]}

Works25 API Specification (v1)

Authentication

Orders (/api/v1/orders.php)

Create Order

1. Main JSON Payload

2. Repeating Scheduled Orders (Recurring Billing)

3. Inserting Items: items[]

JSON Response Handlers

Get Orders (List)

Query Parameters

Response

Get Order Detail

Query Parameters

Response Structure

Response Example

Update Order

Payload Structure

Native State Hooks Fired Dynamically

Headless Notifications Arrays Fired

Void Order

Payload / Query

Pre-Validation Guards

Void Cascade Effects

Response

Checkout & Payments (/api/v1/checkout.php)

Payments & Debtors (/api/v1/payments.php)

Record a Payment

Payload Options:

Response Output:

List Payments Map

Debtors Aging Report

Query Parameters

Grouping Logic Schema (Nested Node Responses)

Catalog Pricing (/api/v1/price.php)

List Active Prices

Query Parameters

Get Item Detail

Response Structure

Create Item

Payload Schema (Core)

Payload Schema (Nested Relationships)

Update Item

Payload

Physically Delete Item

Payload

Customers (/api/v1/customers.php)

List Customers

Query Parameters

Get Customer Detail

Response Includes

Create / Upsert Customer

Payload

Response

Update Customer

Payload

Block Customer

Payload / Query

Response

Jobs & Queues (/api/v1/jobs.php)

List Jobs by Station

Query Parameters

Response

Update Job Status (Process Migration)

Payload

Retrieve Order Capture Assets

Response

Store Order Capture Assets

Payload

Response

Delete Order Capture Assets

Payload

Response

Orders (`/api/v1/orders.php`)

3. Inserting Items: `items[]`

Checkout & Payments (`/api/v1/checkout.php`)

Payments & Debtors (`/api/v1/payments.php`)

Catalog Pricing (`/api/v1/price.php`)

Customers (`/api/v1/customers.php`)

Jobs & Queues (`/api/v1/jobs.php`)