1 <div id=
"bootstrap-theme" class=
"api4-explorer-page">
2 <div crm-ui-debug=
"availableParams"></div>
5 {{:: ts('CiviCRM APIv4') }}{{ entity ? (' (' + entity + '::' + action + ')') : '' }}
8 <div class=
"api4-explorer-row">
9 <form name=
"api4-explorer" class=
"panel panel-default explorer-params-panel">
10 <div class=
"panel-heading">
11 <div class=
"form-inline">
12 <span ng-mouseenter=
"help('entity', paramDoc('$entity'))" ng-mouseleave=
"help()">
13 <input class=
"collapsible-optgroups form-control" ng-model=
"entity" ng-disabled=
"!entities.length" ng-class=
"{loading: !entities.length}" crm-ui-select=
"::{placeholder: ts('Entity'), data: entities}" />
15 <span ng-mouseenter=
"help('action', paramDoc('$action'))" ng-mouseleave=
"help()">
16 <input class=
"collapsible-optgroups form-control" ng-model=
"action" ng-disabled=
"!entity || !actions.length" ng-class=
"{loading: entity && !actions.length}" crm-ui-select=
"::{placeholder: ts('Action'), data: actions}" />
18 <input class=
"form-control api4-index" type=
"search" ng-model=
"index" ng-mouseenter=
"help('index', paramDoc('$index'))" ng-mouseleave=
"help()" placeholder=
"{{:: ts('Index') }}" />
19 <button class=
"btn btn-success pull-right" crm-icon=
"fa-bolt" ng-disabled=
"!entity || !action || loading" ng-click=
"execute()" ng-mouseenter=
"help(ts('Execute'), executeDoc())" ng-mouseleave=
"help()">{{:: ts('Execute') }}
</button>
20 <button class=
"btn btn-primary pull-right" crm-icon=
"fa-save" ng-show=
"perm.editGroups && action === 'get'" ng-click=
"save()" ng-mouseenter=
"help(ts('Save smart group'), saveDoc())" ng-mouseleave=
"help()">{{:: ts('Save...') }}
</button>
23 <div class=
"panel-body">
24 <div class=
"api4-input form-inline">
25 <label class=
"form-control" ng-mouseenter=
"help(name, param)" ng-mouseleave=
"help()" ng-class=
"{'api4-option-selected': params[name]}" ng-repeat=
"(name, param) in ::getGenericParams(['bool'], false)">
26 <input type=
"checkbox" id=
"api4-param-{{:: name }}" ng-model=
"params[name]"/>
27 {{:: name }}
<span class=
"crm-marker" ng-if=
"::param.required"> *
</span>
29 <label class=
"form-control" ng-mouseenter=
"help('selectRowCount', availableParams.select)" ng-mouseleave=
"help()" ng-class=
"{'api4-option-selected': isSelectRowCount()}" ng-if=
"::availableParams.select">
30 <input type=
"checkbox" id=
"api4-param-selectRowCount" ng-checked=
"isSelectRowCount()" ng-click=
"selectRowCount()" />
34 <div class=
"api4-input form-inline" ng-mouseenter=
"help(name, param)" ng-mouseleave=
"help()" ng-repeat=
"(name, param) in ::getGenericParams(['bool'], true)">
35 <label>{{ name }}
<span class=
"crm-marker" ng-if=
"::param.required"> *
</span></label>
36 <label class=
"radio-inline">
37 <input type=
"radio" ng-model=
"params[name]" ng-value=
"true" />true
39 <label class=
"radio-inline">
40 <input type=
"radio" ng-model=
"params[name]" ng-value=
"false" />false
42 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam(name)" ng-show=
"params[name] !== null"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
44 <fieldset class=
"api4-input form-inline" ng-mouseenter=
"help('select', availableParams.select)" ng-mouseleave=
"help()" ng-if=
"availableParams.select">
45 <legend>select
<span class=
"crm-marker" ng-if=
"::availableParams.select.required"> *
</span></legend>
46 <div ng-model=
"params.select" ui-sortable=
"{axis: 'y'}">
47 <div class=
"api4-input form-inline" ng-repeat=
"item in params.select track by $index" ng-show=
"item !== 'row_count'">
48 <i class=
"crm-i fa-arrows" aria-hidden=
"true"></i>
49 <input class=
"form-control huge" type=
"text" ng-model=
"params.select[$index]" />
50 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('select', $index)"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
53 <div class=
"api4-input form-inline">
54 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.select" crm-ui-select=
"{data: fieldsAndJoinsAndFunctionsAndWildcards}" placeholder=
"Add select" />
57 <fieldset id=
"api4-join-fieldset" class=
"api4-input form-inline" ng-mouseenter=
"help('join', availableParams.join)" ng-mouseleave=
"help()" ng-if=
"::availableParams.join">
58 <legend>join
<span class=
"crm-marker" ng-if=
"::availableParams.join.required"> *
</span></legend>
59 <div ng-model=
"params.join" ui-sortable=
"{axis: 'y', containment: '#api4-join-fieldset'}">
60 <fieldset ng-repeat=
"item in params.join track by $index">
61 <div class=
"api4-input form-inline">
62 <i class=
"crm-i fa-arrows"></i>
63 <input class=
"form-control twenty" type=
"text" ng-model=
"params.join[$index][0]" ng-model-options=
"{updateOn: 'blur'}" ng-change=
"$ctrl.buildFieldList()"/>
64 <label>{{:: ts('Required:') }}
</label>
65 <select class=
"form-control" ng-model=
"params.join[$index][1]" ng-options=
"o.k as o.v for o in ::joinTypes" ></select>
66 <label>{{:: ts('Using:') }}
</label>
67 <select class=
"form-control" ng-model=
"params.join[$index][2]" ng-options=
"e.name as e.name for e in ::bridgeEntities" ng-change=
"$ctrl.buildFieldList()">
68 <option value=
"">{{:: ts('- none -') }}
</option>
70 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('join', $index)"><i class=
"crm-i fa-times"></i></a>
72 <fieldset class=
"api4-clause-fieldset">
73 <crm-api4-clause clauses=
"params.join[$index]" format=
"plain" skip=
"3" op=
"AND" label=
"On" fields=
"fieldsAndJoins" ></crm-api4-clause>
77 <div class=
"api4-input form-inline">
78 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.join" crm-ui-select=
"{data: entities}" placeholder=
"Add join" />
81 <div class=
"api4-input form-inline" ng-mouseenter=
"help('fields', availableParams.fields)" ng-mouseleave=
"help()" ng-if=
"::availableParams.fields">
82 <label for=
"api4-param-fields">fields
<span class=
"crm-marker" ng-if=
"::availableParams.fields.required"> *
</span></label>
83 <input class=
"form-control" ng-list
crm-ui-select=
"::{data: fields, multiple: true}" id=
"api4-param-fields" ng-model=
"params.fields" style=
"width: 85%;"/>
85 <div class=
"api4-input form-inline" ng-mouseenter=
"help('action', availableParams.action)" ng-mouseleave=
"help()"ng-if=
"::availableParams.action">
86 <label for=
"api4-param-action">action
<span class=
"crm-marker" ng-if=
"::availableParams.action.required"> *
</span></label>
87 <input class=
"form-control" crm-ui-select=
"{data: actions, allowClear: true, placeholder: 'None'}" id=
"api4-param-action" ng-model=
"params.action"/>
89 <div class=
"api4-input form-inline" ng-mouseenter=
"help(name, param)" ng-mouseleave=
"help()" ng-repeat=
"(name, param) in ::getGenericParams(['string', 'int'])">
90 <label for=
"api4-param-{{:: name }}">{{:: name }}
<span class=
"crm-marker" ng-if=
"::param.required"> *
</span></label>
91 <input class=
"form-control" ng-if=
"::!param.options" type=
"{{:: param.type[0] === 'int' && param.type.length === 1 ? 'number' : 'text' }}" id=
"api4-param-{{:: name }}" ng-model=
"params[name]"/>
92 <select class=
"form-control" ng-if=
"::param.options" ng-options=
"o for o in ::param.options" id=
"api4-param-{{:: name }}" ng-model=
"params[name]"></select>
93 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam(name)" ng-show=
"!!params[name]"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
95 <div class=
"api4-input" ng-mouseenter=
"help(name, param)" ng-mouseleave=
"help()" ng-repeat=
"(name, param) in ::getGenericParams(['array', 'mixed'])">
96 <label for=
"api4-param-{{:: name }}">{{:: name }}
<span class=
"crm-marker" ng-if=
"::param.required"> *
</span></label>
97 <textarea class=
"form-control" type=
"{{:: param.type[0] === 'int' && param.type.length === 1 ? 'number' : 'text' }}" id=
"api4-param-{{:: name }}" ng-model=
"params[name]">
100 <fieldset ng-if=
"::availableParams.where" class=
"api4-clause-fieldset" ng-mouseenter=
"help('where', availableParams.where)" ng-mouseleave=
"help()">
101 <crm-api4-clause clauses=
"params.where" is-required=
"availableParams.where.required" op=
"AND" label=
"Where" fields=
"fieldsAndJoins" ></crm-api4-clause>
103 <fieldset ng-repeat=
"name in ['values', 'defaults']" ng-if=
"::availableParams[name]" ng-mouseenter=
"help(name, availableParams[name])" ng-mouseleave=
"help()">
104 <legend>{{:: name }}
<span class=
"crm-marker" ng-if=
"::availableParams[name].required"> *
</span></legend>
105 <div class=
"api4-input form-inline" ng-repeat=
"clause in params[name]" ng-mouseenter=
"help('value: ' + clause[0], fieldHelp(clause[0]))" ng-mouseleave=
"help(name, availableParams[name])">
106 <input class=
"collapsible-optgroups form-control twenty" ng-model=
"clause[0]" crm-ui-select=
"{formatResult: formatSelect2Item, formatSelection: formatSelect2Item, data: fieldList(name), allowClear: true, placeholder: 'Field'}" />
107 <input class=
"form-control" ng-model=
"clause[1]" api4-exp-value=
"{field: clause[0], action: action === 'getFields' ? params.action || 'get' : action}" />
109 <div class=
"api4-input form-inline">
110 <input class=
"collapsible-optgroups form-control twenty" ng-model=
"controls[name]" crm-ui-select=
"{formatResult: formatSelect2Item, formatSelection: formatSelect2Item, data: fieldList(name), placeholder: ts('Add %1', {1: name.slice(0, -1)})}"/>
113 <fieldset ng-if=
"::availableParams.groupBy" ng-mouseenter=
"help('groupBy', availableParams.groupBy)" ng-mouseleave=
"help()">
114 <legend>groupBy
<span class=
"crm-marker" ng-if=
"::availableParams.groupBy.required"> *
</span></legend>
115 <div ng-model=
"params.groupBy" ui-sortable=
"{axis: 'y'}">
116 <div class=
"api4-input form-inline" ng-repeat=
"item in params.groupBy track by $index">
117 <i class=
"crm-i fa-arrows" aria-hidden=
"true"></i>
118 <input class=
"form-control huge" type=
"text" ng-model=
"params.groupBy[$index]" />
119 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('groupBy', $index)"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
122 <div class=
"api4-input form-inline">
123 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.groupBy" crm-ui-select=
"{data: fieldsAndJoinsAndFunctions}" placeholder=
"Add groupBy" />
126 <fieldset ng-if=
"::availableParams.having" class=
"api4-clause-fieldset" ng-mouseenter=
"help('having', availableParams.having)" ng-mouseleave=
"help()">
127 <crm-api4-clause clauses=
"params.having" is-required=
"availableParams.having.required" op=
"AND" label=
"Having" fields=
"havingOptions" ></crm-api4-clause>
129 <fieldset ng-if=
"::availableParams.orderBy" ng-mouseenter=
"help('orderBy', availableParams.orderBy)" ng-mouseleave=
"help()">
130 <legend>orderBy
<span class=
"crm-marker" ng-if=
"::availableParams.orderBy.required"> *
</span></legend>
131 <div ng-model=
"params.orderBy" ui-sortable=
"{axis: 'y'}">
132 <div class=
"api4-input form-inline" ng-repeat=
"clause in params.orderBy">
133 <i class=
"crm-i fa-arrows" aria-hidden=
"true"></i>
134 <input class=
"form-control huge" type=
"text" ng-model=
"clause[0]" />
135 <select class=
"form-control" ng-model=
"clause[1]">
136 <option value=
"ASC">ASC
</option>
137 <option value=
"DESC">DESC
</option>
139 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('orderBy', $index)"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
142 <div class=
"api4-input form-inline">
143 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.orderBy" crm-ui-select=
"{data: fieldsAndJoinsAndFunctionsWithSuffixes}" placeholder=
"Add orderBy" />
146 <fieldset ng-if=
"::availableParams.limit && availableParams.offset">
147 <div class=
"api4-input form-inline">
148 <span ng-mouseenter=
"help('limit', availableParams.limit)" ng-mouseleave=
"help()">
149 <label for=
"api4-param-limit">limit
<span class=
"crm-marker" ng-if=
"::availableParams.limit.required"> *
</span></label>
150 <input class=
"form-control" type=
"number" min=
"0" id=
"api4-param-limit" ng-model=
"params.limit"/>
152 <span ng-mouseenter=
"help('offset', availableParams.offset)" ng-mouseleave=
"help()">
153 <label for=
"api4-param-offset">offset
<span class=
"crm-marker" ng-if=
"::availableParams.offset.required"> *
</span></label>
154 <input class=
"form-control" type=
"number" min=
"0" id=
"api4-param-offset" ng-model=
"params.offset"/>
156 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('limit');clearParam('offset');" ng-show=
"!!params.limit || !!params.offset"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
159 <fieldset ng-if=
"::availableParams.chain" ng-mouseenter=
"help('chain', availableParams.chain)" ng-mouseleave=
"help()">
160 <legend>chain
</legend>
161 <div class=
"api4-input form-inline" ng-repeat=
"clause in params.chain" api4-exp-chain=
"clause" entities=
"::entities" main-entity=
"::entity" >
163 <div class=
"api4-input form-inline">
164 <input class=
"form-control" ng-model=
"controls.chain" crm-ui-select=
"::{data: entities}" placeholder=
"Add chain" />
169 <div class=
"panel panel-info explorer-help-panel">
170 <div class=
"panel-heading">
171 <h3 class=
"panel-title" crm-icon=
"fa-info-circle">{{ helpTitle }}
</h3>
173 <div class=
"panel-body">
174 <h4 ng-bind-html=
"helpContent.description"></h4>
175 <div ng-bind-html=
"helpContent.comment"></div>
176 <p ng-repeat=
"(key, item) in helpContent" ng-if=
"key !== 'description' && key !== 'comment' && key !== 'see'">
177 <strong>{{ key }}:
</strong> {{ item }}
179 <div ng-if=
"helpContent.see">
180 <strong>See:
</strong>
182 <li ng-repeat=
"ref in helpContent.see" ng-bind-html=
"ref"> </li>
188 <div class=
"api4-explorer-row">
189 <div class=
"panel panel-info explorer-code-panel">
190 <ul class=
"panel-heading nav nav-tabs">
191 <li role=
"presentation" ng-repeat=
"lang in ::langs" ng-class=
"{active: selectedTab.code === lang}">
192 <a href
ng-click=
"selectLang(lang)">
197 <div class=
"panel-body">
199 <tr ng-repeat=
"style in code[selectedTab.code]">
200 <td>{{:: style.label }}
</td>
201 <td><pre class=
"prettyprint" ng-bind-html=
"style.code"></pre></td>
206 <div class=
"panel explorer-result-panel panel-{{ status }}" >
207 <ul class=
"panel-heading nav nav-tabs">
208 <li role=
"presentation" ng-class=
"{active: selectedTab.result === 'result'}">
209 <a href
ng-click=
"selectedTab.result = 'result'">
210 <span ng-switch=
"status">
211 <i class=
"fa fa-fw fa-circle-o" ng-switch-when=
"default"></i>
212 <i class=
"fa fa-fw fa-check-circle" ng-switch-when=
"success"></i>
213 <i class=
"fa fa-fw fa-check-circle" ng-switch-when=
"warning"></i>
214 <i class=
"fa fa-fw fa-minus-circle" ng-switch-when=
"danger"></i>
215 <i class=
"fa fa-fw fa-spinner fa-pulse" ng-switch-when=
"info"></i>
217 <span>{{:: ts('Result') }}
</span>
220 <li role=
"presentation" ng-if=
"::perm.accessDebugOutput" ng-class=
"{active: selectedTab.result === 'debug'}">
221 <a href
ng-click=
"selectedTab.result = 'debug'">
222 <i class=
"fa fa-fw fa-{{ debug ? (status === 'warning' || status === 'danger' ? 'warning' : 'bug') : 'circle-o' }}"></i>
223 <span>{{:: ts('Debug') }}
</span>
227 <div class=
"panel-body">
228 <div ng-show=
"selectedTab.result === 'result'">
229 <pre class=
"prettyprint" ng-repeat=
"code in result" ng-bind-html=
"code"></pre>
231 <div ng-if=
"::perm.accessDebugOutput" ng-show=
"selectedTab.result === 'debug'">
232 <pre ng-if=
"debug" class=
"prettyprint" ng-bind-html=
"debug"></pre>
235 {{:: ts('To view debugging output, enable the debug param before executing.') }}
238 {{:: ts('Enable backtrace in system settings to see error backtraces.') }}