- create user 'username'@'localhost' identified by 'user-password';
- create database dbname;
- grant all privileges on dbname.* to 'username'@'localhost';
- flush privileges;
- sudo --login --user postgres
Joe Bordes joebordes
joebordes
/ ListViewBusiness_Actions.csv
Created
August 28, 2022 00:33
List View Action Business Actions
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Link Type | Link Label | Link Url | Link Icon | Sequence | Handler Path | Only On My Module | Handler Class | Module List | Handler | Assigned To | Active | Action Role | For all users | Business Rule | Business Actions No | Created By | Created Time | Modified Time | Description | Unique Identifier | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LISTVIEWACTION | show message | module=Utilities&action=UtilitiesAjax&file=showMsgWidget&msg=ListViewAction&level=success | 0.00 | 0 | Accounts | admin | 1 | 1 | bact-0000139 | admin | 2022-08-24 21:28:57 | 2022-08-24 21:41:56 | b830de7a53ef16889c72d1f2859f285f47554f78 | ||||||||
| LISTVIEWACTION | show iframe | block://showHTMLBlock:modules/Utilities/showHTMLBlock.php:op=iframe&height=400px&ex=http%3A%2F%2Fcorebos.org%3Fifcrmid%3D%24RECORD%24%26ifmodule%3D%24MODULE%24 | 0.00 | 0 | Accounts | admin | 1 | 1 | bact-0000140 | admin | 2022-08-24 21:29:25 | 2022-08-24 21:33:54 | b888766f19f6101fb643aac161648137897ded43 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| getGraph = () => { | |
| mermaid.initialize({ startOnLoad: true, securityLevel: 'loose', }); | |
| cbconn.doLogin('admin', 'admin', true) | |
| .then(()=> { | |
| //cbconn.doInvoke('executeBusinessAction', { businessactionid: '47086', 'context':JSON.stringify({'ID':'13x47084', 'MODE':''}) }, 'GET') | |
| //cbconn.doInvoke('executeBusinessAction', { businessactionid: '47087', 'context':JSON.stringify({'ID':'13x47084', 'MODE':''}) }, 'GET') | |
| cbconn.doInvoke('PushAlongFlow', { pflowid: '47069', 'contextid': '13x47089'}, 'GET') | |
| .then(data => { | |
| // let graph = data.substr(data.indexOf('graph')); | |
| // graph = graph.substr(0, graph.indexOf('</div>')); |
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 2.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "Name Text","Question No","Type","Status","SQL Query","Collection","Module","Page Size","Assigned To","Created By","Created Time","Modified Time","Columns","Condition","Description","Order by Column","Group by Column","Type Properties","Main Table Alias","Unique ID Field","Materialized View Cron","Map Id","Materialized View Workflow","Conditions in Filter Format","CRM Entity Alias","Update View when Related Changes","Related Module List","Unique Identifier" | |
| "Contacts per Country","cbQ-0000008","Pie","Active","0","","Contacts","10.00","admin","admin","2020-04-19 16:27:14","2020-05-14 22:20:39","[{""fieldname"":""mailingcountry"",""operation"":""is"",""value"":""mailingcountry"",""valuetype"":""fieldname"",""joincondition"":""custom"",""groupid"":0,""groupjoin"":""mailingcountry""},{""fieldname"":""countres"",""operation"":""is"",""value"":""count(contact_no)"",""valuetype"":""expression"",""joincondition"":""count"",""groupid"":0,""groupjoin"":""contact_no""}]","[{""fieldname"":""mailingcountry"",""operation"" |
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 2.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "Name Text","Question No","Type","Status","SQL Query","Collection","Module","Page Size","Assigned To","Created By","Created Time","Modified Time","Columns","Condition","Description","Order by Column","Group by Column","Type Properties","Main Table Alias","Unique ID Field","Materialized View Cron","Map Id","Materialized View Workflow","Conditions in Filter Format","CRM Entity Alias","Update View when Related Changes","Related Module List","Unique Identifier" | |
| "Contacts in Spain","cbQ-0000007","Table","Active","0","","Contacts","10.00","admin","admin","2020-04-19 16:16:52","2020-04-19 16:18:26","[{""fieldname"":""firstname"",""operation"":""is"",""value"":""firstname"",""valuetype"":""fieldname"",""joincondition"":""custom"",""groupid"":0,""groupjoin"":""firstname""},{""fieldname"":""lastname"",""operation"":""is"",""value"":""lastname"",""valuetype"":""fieldname"",""joincondition"":""custom"",""groupid"":0,""groupjoin"":""lastname""}]","[{""fieldname"":""mailingcountry"",""operation"":""is"",""value"":""Spain"" |
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 2.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "Name Text","Question No","Type","Status","SQL Query","Collection","Module","Page Size","Assigned To","Created By","Created Time","Modified Time","Columns","Condition","Description","Order by Column","Group by Column","Type Properties","Main Table Alias","Unique ID Field","Materialized View Cron","Map Id","Materialized View Workflow","Conditions in Filter Format","CRM Entity Alias","Update View when Related Changes","Related Module List","Unique Identifier" | |
| "filter test2","cbQ-0000005","Number","Active","0","","Quotes","0.00","admin","admin","2020-04-19 15:06:03","2020-04-19 15:15:05","[{""fieldname"":""pl_gross_total"",""operation"":""is"",""value"":""round(sum(pl_gross_total), 2)"",""valuetype"":""expression"",""joincondition"":""sum"",""groupid"":0,""groupjoin"":""pl_gross_total""}]","[{""fieldname"":""subject"",""operation"":""contains"",""value"":""an"",""valuetype"":""rawtext"",""joincondition"":""or"",""groupid"":""0"",""groupjoin"":""""},{""fieldname"":""pl_gross_total"",""operation"":""greater than"" |
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 2.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "Name Text","Question No","Type","Status","SQL Query","Collection","Module","Page Size","Assigned To","Created By","Created Time","Modified Time","Columns","Condition","Description","Order by Column","Group by Column","Type Properties","Main Table Alias","Unique ID Field","Materialized View Cron","Map Id","Materialized View Workflow","Conditions in Filter Format","CRM Entity Alias","Update View when Related Changes","Related Module List","Unique Identifier" | |
| "mm2","cbQ-0000002","Mermaid","Active","0","","Potentials","0.00","admin","admin","2020-01-10 17:14:28","2020-05-12 23:22:06","A(( )) -->|contrat| B | |
| B(( )) -->|Avenants| C(( )) | |
| C(( )) -->|en cours| H | |
| D(( )) -->|Terrain| E | |
| E(( )) -->|Etudes| C(( )) | |
| F(( )) -->|Plans| G | |
| G(( )) -->|Métrés| C(( )) | |
| H((VT)) -->|""Control<br>Dossier""| I(( )) | |
| I(( )) -->|""Control<br>Prix""| J |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| diff --git a/include/Webservices/OperationManager.php b/include/Webservices/OperationManager.php | |
| index 7fd3dd8..d9b0732 100644 | |
| --- a/include/Webservices/OperationManager.php | |
| +++ b/include/Webservices/OperationManager.php | |
| @@ -91,6 +91,7 @@ class OperationManager { | |
| public function getOperationInput() { | |
| $type = strtolower($this->type); | |
| + $type='request'; | |
| switch ($type) { |
joebordes
/ kanban.diff
Last active
November 9, 2019 10:01
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| diff --git a/actions/websocket_actions.test.jsx b/actions/websocket_actions.test.jsx | |
| index 15925cb9e..e3cd431d2 100644 | |
| --- a/actions/websocket_actions.test.jsx | |
| +++ b/actions/websocket_actions.test.jsx | |
| @@ -565,7 +565,7 @@ describe('handlePluginEnabled/handlePluginDisabled', () => { | |
| // Pretend to be a browser, invoke onload | |
| mockScript.onload(); | |
| - expect(initialize).toHaveBeenCalledWith(expect.anything(), store); | |
| + expect(initialize).toHaveBeenCalledWith(expect.anything(), store, browserHistory); |
joebordes
/ Steps to install production docker compose
Last active
November 2, 2019 10:05
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ### Create user for process | |
| adduser --system --shell /bin/bash --gecos 'Desc of process' --group --disabled-password --home /home/$USER $USER | |
| ### add user to group | |
| usermod -aG docker $USER | |
| ### Create docker-compose file | |
| su - %USER | |
| create and test docker-compose.yml |
NewerOlder