1 <div id=
"bootstrap-theme" class=
"api4-explorer-page">
2 <div crm-ui-debug=
"availableParams"></div>
5 {{:: ts('CiviCRM APIv4') }}{{ entity ? (' (' + entity + '::' + action + ')') : '' }}
8 <!--This warning will show if bootstrap is unavailable. Normally it will be hidden by the bootstrap .collapse class.-->
9 <div class=
"messages warning no-popup collapse">
11 <i class=
"crm-i fa-exclamation-triangle" aria-hidden=
"true"></i>
12 <strong>{{:: ts('Bootstrap theme not found.') }}
</strong>
14 <p>{{:: ts('This screen may not work correctly without a bootstrap-based theme such as Shoreditch installed.') }}
</p>
17 <div class=
"api4-explorer-row">
18 <form name=
"api4-explorer" class=
"panel panel-default explorer-params-panel">
19 <div class=
"panel-heading">
20 <div class=
"form-inline">
21 <span ng-mouseenter=
"help('entity', paramDoc('$entity'))" ng-mouseleave=
"help()">
22 <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}" />
24 <span ng-mouseenter=
"help('action', paramDoc('$action'))" ng-mouseleave=
"help()">
25 <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}" />
27 <input class=
"form-control api4-index" type=
"search" ng-model=
"index" ng-mouseenter=
"help('index', paramDoc('$index'))" ng-mouseleave=
"help()" placeholder=
"{{:: ts('Index') }}" />
28 <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>
29 <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>
32 <div class=
"panel-body">
33 <div class=
"api4-input form-inline">
34 <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)">
35 <input type=
"checkbox" id=
"api4-param-{{:: name }}" ng-model=
"params[name]"/>
36 {{:: name }}
<span class=
"crm-marker" ng-if=
"::param.required"> *
</span>
38 <label class=
"form-control" ng-mouseenter=
"help('selectRowCount', availableParams.select)" ng-mouseleave=
"help()" ng-class=
"{'api4-option-selected': isSelectRowCount()}" ng-if=
"::availableParams.select">
39 <input type=
"checkbox" id=
"api4-param-selectRowCount" ng-checked=
"isSelectRowCount()" ng-click=
"selectRowCount()" />
43 <div class=
"api4-input form-inline" ng-mouseenter=
"help(name, param)" ng-mouseleave=
"help()" ng-repeat=
"(name, param) in ::getGenericParams(['bool'], true)">
44 <label>{{ name }}
<span class=
"crm-marker" ng-if=
"::param.required"> *
</span></label>
45 <label class=
"radio-inline">
46 <input type=
"radio" ng-model=
"params[name]" ng-value=
"true" />true
48 <label class=
"radio-inline">
49 <input type=
"radio" ng-model=
"params[name]" ng-value=
"false" />false
51 <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>
53 <fieldset class=
"api4-input form-inline" ng-mouseenter=
"help('select', availableParams.select)" ng-mouseleave=
"help()" ng-if=
"availableParams.select && !isSelectRowCount()">
54 <legend>select
<span class=
"crm-marker" ng-if=
"::availableParams.select.required"> *
</span></legend>
55 <div ng-model=
"params.select" ui-sortable=
"{axis: 'y'}">
56 <div class=
"api4-input form-inline" ng-repeat=
"item in params.select track by $index">
57 <i class=
"crm-i fa-arrows" aria-hidden=
"true"></i>
58 <input class=
"form-control huge" type=
"text" ng-model=
"params.select[$index]" />
59 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('select', $index)"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
62 <div class=
"api4-input form-inline">
63 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.select" crm-ui-select=
"{data: fieldsAndJoinsAndFunctionsAndWildcards}" placeholder=
"Add select" />
66 <fieldset class=
"api4-input form-inline" ng-mouseenter=
"help('join', availableParams.join)" ng-mouseleave=
"help()" ng-if=
"::availableParams.join">
67 <legend>join
<span class=
"crm-marker" ng-if=
"::availableParams.join.required"> *
</span></legend>
68 <div ng-model=
"params.join" ui-sortable=
"{axis: 'y'}">
69 <div class=
"api4-input form-inline" ng-repeat=
"item in params.join track by $index">
70 <i class=
"crm-i fa-arrows"></i>
71 <input class=
"form-control twenty" type=
"text" ng-model=
"params.join[$index][0]" />
72 <select class=
"form-control" ng-model=
"params.join[$index][1]" ng-options=
"o.k as o.v for o in ::joinTypes" ></select>
73 <input class=
"form-control twenty" type=
"text" ng-model=
"params.join[$index][2]" />
74 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('join', $index)"><i class=
"crm-i fa-times"></i></a>
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()" crm-api4-clause=
"{type: 'where', clauses: params.where, required: availableParams.where.required, op: 'AND', label: 'where', fields: fieldsAndJoins}">
102 <fieldset ng-repeat=
"name in ['values', 'defaults']" ng-if=
"::availableParams[name]" ng-mouseenter=
"help(name, availableParams[name])" ng-mouseleave=
"help()">
103 <legend>{{:: name }}
<span class=
"crm-marker" ng-if=
"::availableParams[name].required"> *
</span></legend>
104 <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])">
105 <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'}" />
106 <input class=
"form-control" ng-model=
"clause[1]" api4-exp-value=
"{field: clause[0], action: action === 'getFields' ? params.action || 'get' : action}" />
108 <div class=
"api4-input form-inline">
109 <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)})}"/>
112 <fieldset ng-if=
"::availableParams.groupBy" ng-mouseenter=
"help('groupBy', availableParams.groupBy)" ng-mouseleave=
"help()">
113 <legend>groupBy
<span class=
"crm-marker" ng-if=
"::availableParams.groupBy.required"> *
</span></legend>
114 <div ng-model=
"params.groupBy" ui-sortable=
"{axis: 'y'}">
115 <div class=
"api4-input form-inline" ng-repeat=
"item in params.groupBy track by $index">
116 <i class=
"crm-i fa-arrows" aria-hidden=
"true"></i>
117 <input class=
"form-control huge" type=
"text" ng-model=
"params.groupBy[$index]" />
118 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('groupBy', $index)"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
121 <div class=
"api4-input form-inline">
122 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.groupBy" crm-ui-select=
"{data: fieldsAndJoinsAndFunctions}" placeholder=
"Add groupBy" />
125 <fieldset ng-if=
"::availableParams.having" class=
"api4-clause-fieldset" ng-mouseenter=
"help('having', availableParams.having)" ng-mouseleave=
"help()" crm-api4-clause=
"{type: 'having', clauses: params.having, required: availableParams.having.required, op: 'AND', label: 'having', fields: havingOptions}">
127 <fieldset ng-if=
"::availableParams.orderBy" ng-mouseenter=
"help('orderBy', availableParams.orderBy)" ng-mouseleave=
"help()">
128 <legend>orderBy
<span class=
"crm-marker" ng-if=
"::availableParams.orderBy.required"> *
</span></legend>
129 <div ng-model=
"params.orderBy" ui-sortable=
"{axis: 'y'}">
130 <div class=
"api4-input form-inline" ng-repeat=
"clause in params.orderBy">
131 <i class=
"crm-i fa-arrows" aria-hidden=
"true"></i>
132 <input class=
"form-control huge" type=
"text" ng-model=
"clause[0]" />
133 <select class=
"form-control" ng-model=
"clause[1]">
134 <option value=
"ASC">ASC
</option>
135 <option value=
"DESC">DESC
</option>
137 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('orderBy', $index)"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
140 <div class=
"api4-input form-inline">
141 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.orderBy" crm-ui-select=
"{data: fieldsAndJoinsAndFunctionsWithSuffixes}" placeholder=
"Add orderBy" />
144 <fieldset ng-if=
"::availableParams.limit && availableParams.offset">
145 <div class=
"api4-input form-inline">
146 <span ng-mouseenter=
"help('limit', availableParams.limit)" ng-mouseleave=
"help()">
147 <label for=
"api4-param-limit">limit
<span class=
"crm-marker" ng-if=
"::availableParams.limit.required"> *
</span></label>
148 <input class=
"form-control" type=
"number" min=
"0" id=
"api4-param-limit" ng-model=
"params.limit"/>
150 <span ng-mouseenter=
"help('offset', availableParams.offset)" ng-mouseleave=
"help()">
151 <label for=
"api4-param-offset">offset
<span class=
"crm-marker" ng-if=
"::availableParams.offset.required"> *
</span></label>
152 <input class=
"form-control" type=
"number" min=
"0" id=
"api4-param-offset" ng-model=
"params.offset"/>
154 <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>
157 <fieldset ng-if=
"::availableParams.chain" ng-mouseenter=
"help('chain', availableParams.chain)" ng-mouseleave=
"help()">
158 <legend>chain
</legend>
159 <div class=
"api4-input form-inline" ng-repeat=
"clause in params.chain" api4-exp-chain=
"clause" entities=
"::entities" main-entity=
"::entity" >
161 <div class=
"api4-input form-inline">
162 <input class=
"form-control" ng-model=
"controls.chain" crm-ui-select=
"::{data: entities}" placeholder=
"Add chain" />
167 <div class=
"panel panel-info explorer-help-panel">
168 <div class=
"panel-heading">
169 <h3 class=
"panel-title" crm-icon=
"fa-info-circle">{{ helpTitle }}
</h3>
171 <div class=
"panel-body">
172 <h4 ng-bind-html=
"helpContent.description"></h4>
173 <div ng-bind-html=
"helpContent.comment"></div>
174 <p ng-repeat=
"(key, item) in helpContent" ng-if=
"key !== 'description' && key !== 'comment' && key !== 'see'">
175 <strong>{{ key }}:
</strong> {{ item }}
177 <div ng-if=
"helpContent.see">
178 <strong>See:
</strong>
180 <li ng-repeat=
"ref in helpContent.see" ng-bind-html=
"ref"> </li>
186 <div class=
"api4-explorer-row">
187 <div class=
"panel panel-info explorer-code-panel">
188 <ul class=
"panel-heading nav nav-tabs">
189 <li role=
"presentation" ng-repeat=
"lang in ::langs" ng-class=
"{active: selectedTab.code === lang}">
190 <a href
ng-click=
"selectLang(lang)">
195 <div class=
"panel-body">
197 <tr ng-repeat=
"style in code[selectedTab.code]">
198 <td>{{:: style.label }}
</td>
199 <td><pre class=
"prettyprint" ng-bind-html=
"style.code"></pre></td>
204 <div class=
"panel explorer-result-panel panel-{{ status }}" >
205 <ul class=
"panel-heading nav nav-tabs">
206 <li role=
"presentation" ng-class=
"{active: selectedTab.result === 'result'}">
207 <a href
ng-click=
"selectedTab.result = 'result'">
208 <span ng-switch=
"status">
209 <i class=
"fa fa-fw fa-circle-o" ng-switch-when=
"default"></i>
210 <i class=
"fa fa-fw fa-check-circle" ng-switch-when=
"success"></i>
211 <i class=
"fa fa-fw fa-check-circle" ng-switch-when=
"warning"></i>
212 <i class=
"fa fa-fw fa-minus-circle" ng-switch-when=
"danger"></i>
213 <i class=
"fa fa-fw fa-spinner fa-pulse" ng-switch-when=
"info"></i>
215 <span>{{:: ts('Result') }}
</span>
218 <li role=
"presentation" ng-if=
"::perm.accessDebugOutput" ng-class=
"{active: selectedTab.result === 'debug'}">
219 <a href
ng-click=
"selectedTab.result = 'debug'">
220 <i class=
"fa fa-fw fa-{{ debug ? (status === 'warning' || status === 'danger' ? 'warning' : 'bug') : 'circle-o' }}"></i>
221 <span>{{:: ts('Debug') }}
</span>
225 <div class=
"panel-body">
226 <div ng-show=
"selectedTab.result === 'result'">
227 <pre class=
"prettyprint" ng-repeat=
"code in result" ng-bind-html=
"code"></pre>
229 <div ng-if=
"::perm.accessDebugOutput" ng-show=
"selectedTab.result === 'debug'">
230 <pre ng-if=
"debug" class=
"prettyprint" ng-bind-html=
"debug"></pre>
233 {{:: ts('To view debugging output, enable the debug param before executing.') }}
236 {{:: ts('Enable backtrace in system settings to see error backtraces.') }}