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" crm-api4-clause=
"{skip: 3, clauses: params.join[$index], op: 'AND', label: 'On', fields: fieldsAndJoins, format: 'plain'}">
76 <div class=
"api4-input form-inline">
77 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.join" crm-ui-select=
"{data: entities}" placeholder=
"Add join" />
80 <div class=
"api4-input form-inline" ng-mouseenter=
"help('fields', availableParams.fields)" ng-mouseleave=
"help()" ng-if=
"::availableParams.fields">
81 <label for=
"api4-param-fields">fields
<span class=
"crm-marker" ng-if=
"::availableParams.fields.required"> *
</span></label>
82 <input class=
"form-control" ng-list
crm-ui-select=
"::{data: fields, multiple: true}" id=
"api4-param-fields" ng-model=
"params.fields" style=
"width: 85%;"/>
84 <div class=
"api4-input form-inline" ng-mouseenter=
"help('action', availableParams.action)" ng-mouseleave=
"help()"ng-if=
"::availableParams.action">
85 <label for=
"api4-param-action">action
<span class=
"crm-marker" ng-if=
"::availableParams.action.required"> *
</span></label>
86 <input class=
"form-control" crm-ui-select=
"{data: actions, allowClear: true, placeholder: 'None'}" id=
"api4-param-action" ng-model=
"params.action"/>
88 <div class=
"api4-input form-inline" ng-mouseenter=
"help(name, param)" ng-mouseleave=
"help()" ng-repeat=
"(name, param) in ::getGenericParams(['string', 'int'])">
89 <label for=
"api4-param-{{:: name }}">{{:: name }}
<span class=
"crm-marker" ng-if=
"::param.required"> *
</span></label>
90 <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]"/>
91 <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>
92 <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>
94 <div class=
"api4-input" ng-mouseenter=
"help(name, param)" ng-mouseleave=
"help()" ng-repeat=
"(name, param) in ::getGenericParams(['array', 'mixed'])">
95 <label for=
"api4-param-{{:: name }}">{{:: name }}
<span class=
"crm-marker" ng-if=
"::param.required"> *
</span></label>
96 <textarea class=
"form-control" type=
"{{:: param.type[0] === 'int' && param.type.length === 1 ? 'number' : 'text' }}" id=
"api4-param-{{:: name }}" ng-model=
"params[name]">
99 <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}">
101 <fieldset ng-repeat=
"name in ['values', 'defaults']" ng-if=
"::availableParams[name]" ng-mouseenter=
"help(name, availableParams[name])" ng-mouseleave=
"help()">
102 <legend>{{:: name }}
<span class=
"crm-marker" ng-if=
"::availableParams[name].required"> *
</span></legend>
103 <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])">
104 <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'}" />
105 <input class=
"form-control" ng-model=
"clause[1]" api4-exp-value=
"{field: clause[0], action: action === 'getFields' ? params.action || 'get' : action}" />
107 <div class=
"api4-input form-inline">
108 <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)})}"/>
111 <fieldset ng-if=
"::availableParams.groupBy" ng-mouseenter=
"help('groupBy', availableParams.groupBy)" ng-mouseleave=
"help()">
112 <legend>groupBy
<span class=
"crm-marker" ng-if=
"::availableParams.groupBy.required"> *
</span></legend>
113 <div ng-model=
"params.groupBy" ui-sortable=
"{axis: 'y'}">
114 <div class=
"api4-input form-inline" ng-repeat=
"item in params.groupBy track by $index">
115 <i class=
"crm-i fa-arrows" aria-hidden=
"true"></i>
116 <input class=
"form-control huge" type=
"text" ng-model=
"params.groupBy[$index]" />
117 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('groupBy', $index)"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
120 <div class=
"api4-input form-inline">
121 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.groupBy" crm-ui-select=
"{data: fieldsAndJoinsAndFunctions}" placeholder=
"Add groupBy" />
124 <fieldset ng-if=
"::availableParams.having" class=
"api4-clause-fieldset" ng-mouseenter=
"help('having', availableParams.having)" ng-mouseleave=
"help()" crm-api4-clause=
"{clauses: params.having, required: availableParams.having.required, op: 'AND', label: 'Having', fields: havingOptions}">
126 <fieldset ng-if=
"::availableParams.orderBy" ng-mouseenter=
"help('orderBy', availableParams.orderBy)" ng-mouseleave=
"help()">
127 <legend>orderBy
<span class=
"crm-marker" ng-if=
"::availableParams.orderBy.required"> *
</span></legend>
128 <div ng-model=
"params.orderBy" ui-sortable=
"{axis: 'y'}">
129 <div class=
"api4-input form-inline" ng-repeat=
"clause in params.orderBy">
130 <i class=
"crm-i fa-arrows" aria-hidden=
"true"></i>
131 <input class=
"form-control huge" type=
"text" ng-model=
"clause[0]" />
132 <select class=
"form-control" ng-model=
"clause[1]">
133 <option value=
"ASC">ASC
</option>
134 <option value=
"DESC">DESC
</option>
136 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('orderBy', $index)"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
139 <div class=
"api4-input form-inline">
140 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.orderBy" crm-ui-select=
"{data: fieldsAndJoinsAndFunctionsWithSuffixes}" placeholder=
"Add orderBy" />
143 <fieldset ng-if=
"::availableParams.limit && availableParams.offset">
144 <div class=
"api4-input form-inline">
145 <span ng-mouseenter=
"help('limit', availableParams.limit)" ng-mouseleave=
"help()">
146 <label for=
"api4-param-limit">limit
<span class=
"crm-marker" ng-if=
"::availableParams.limit.required"> *
</span></label>
147 <input class=
"form-control" type=
"number" min=
"0" id=
"api4-param-limit" ng-model=
"params.limit"/>
149 <span ng-mouseenter=
"help('offset', availableParams.offset)" ng-mouseleave=
"help()">
150 <label for=
"api4-param-offset">offset
<span class=
"crm-marker" ng-if=
"::availableParams.offset.required"> *
</span></label>
151 <input class=
"form-control" type=
"number" min=
"0" id=
"api4-param-offset" ng-model=
"params.offset"/>
153 <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>
156 <fieldset ng-if=
"::availableParams.chain" ng-mouseenter=
"help('chain', availableParams.chain)" ng-mouseleave=
"help()">
157 <legend>chain
</legend>
158 <div class=
"api4-input form-inline" ng-repeat=
"clause in params.chain" api4-exp-chain=
"clause" entities=
"::entities" main-entity=
"::entity" >
160 <div class=
"api4-input form-inline">
161 <input class=
"form-control" ng-model=
"controls.chain" crm-ui-select=
"::{data: entities}" placeholder=
"Add chain" />
166 <div class=
"panel panel-info explorer-help-panel">
167 <div class=
"panel-heading">
168 <h3 class=
"panel-title" crm-icon=
"fa-info-circle">{{ helpTitle }}
</h3>
170 <div class=
"panel-body">
171 <h4 ng-bind-html=
"helpContent.description"></h4>
172 <div ng-bind-html=
"helpContent.comment"></div>
173 <p ng-repeat=
"(key, item) in helpContent" ng-if=
"key !== 'description' && key !== 'comment' && key !== 'see'">
174 <strong>{{ key }}:
</strong> {{ item }}
176 <div ng-if=
"helpContent.see">
177 <strong>See:
</strong>
179 <li ng-repeat=
"ref in helpContent.see" ng-bind-html=
"ref"> </li>
185 <div class=
"api4-explorer-row">
186 <div class=
"panel panel-info explorer-code-panel">
187 <ul class=
"panel-heading nav nav-tabs">
188 <li role=
"presentation" ng-repeat=
"lang in ::langs" ng-class=
"{active: selectedTab.code === lang}">
189 <a href
ng-click=
"selectLang(lang)">
194 <div class=
"panel-body">
196 <tr ng-repeat=
"style in code[selectedTab.code]">
197 <td>{{:: style.label }}
</td>
198 <td><pre class=
"prettyprint" ng-bind-html=
"style.code"></pre></td>
203 <div class=
"panel explorer-result-panel panel-{{ status }}" >
204 <ul class=
"panel-heading nav nav-tabs">
205 <li role=
"presentation" ng-class=
"{active: selectedTab.result === 'result'}">
206 <a href
ng-click=
"selectedTab.result = 'result'">
207 <span ng-switch=
"status">
208 <i class=
"fa fa-fw fa-circle-o" ng-switch-when=
"default"></i>
209 <i class=
"fa fa-fw fa-check-circle" ng-switch-when=
"success"></i>
210 <i class=
"fa fa-fw fa-check-circle" ng-switch-when=
"warning"></i>
211 <i class=
"fa fa-fw fa-minus-circle" ng-switch-when=
"danger"></i>
212 <i class=
"fa fa-fw fa-spinner fa-pulse" ng-switch-when=
"info"></i>
214 <span>{{:: ts('Result') }}
</span>
217 <li role=
"presentation" ng-if=
"::perm.accessDebugOutput" ng-class=
"{active: selectedTab.result === 'debug'}">
218 <a href
ng-click=
"selectedTab.result = 'debug'">
219 <i class=
"fa fa-fw fa-{{ debug ? (status === 'warning' || status === 'danger' ? 'warning' : 'bug') : 'circle-o' }}"></i>
220 <span>{{:: ts('Debug') }}
</span>
224 <div class=
"panel-body">
225 <div ng-show=
"selectedTab.result === 'result'">
226 <pre class=
"prettyprint" ng-repeat=
"code in result" ng-bind-html=
"code"></pre>
228 <div ng-if=
"::perm.accessDebugOutput" ng-show=
"selectedTab.result === 'debug'">
229 <pre ng-if=
"debug" class=
"prettyprint" ng-bind-html=
"debug"></pre>
232 {{:: ts('To view debugging output, enable the debug param before executing.') }}
235 {{:: ts('Enable backtrace in system settings to see error backtraces.') }}