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 <div class=
"checkbox-inline form-control" ng-mouseenter=
"help(name, param)" ng-mouseleave=
"help()" ng-repeat=
"(name, param) in ::getGenericParams(['bool'], false)">
27 <input type=
"checkbox" id=
"api4-param-{{:: name }}" ng-model=
"params[name]"/>
28 <span>{{:: name }}
</span><span class=
"crm-marker" ng-if=
"::param.required"> *
</span>
31 <div class=
"checkbox-inline form-control" ng-mouseenter=
"help('selectRowCount', availableParams.select)" ng-mouseleave=
"help()" ng-if=
"::availableParams.select">
33 <input type=
"checkbox" id=
"api4-param-selectRowCount" ng-checked=
"isSelectRowCount()" ng-click=
"selectRowCount()" />
34 <span>SelectRowCount
</span>
38 <div class=
"api4-input form-inline" ng-mouseenter=
"help(name, param)" ng-mouseleave=
"help()" ng-repeat=
"(name, param) in ::getGenericParams(['bool'], true)">
39 <label>{{ name }}
<span class=
"crm-marker" ng-if=
"::param.required"> *
</span></label>
40 <label class=
"radio-inline">
41 <input type=
"radio" ng-model=
"params[name]" ng-value=
"true" />true
43 <label class=
"radio-inline">
44 <input type=
"radio" ng-model=
"params[name]" ng-value=
"false" />false
46 <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>
48 <fieldset class=
"api4-input form-inline" ng-mouseenter=
"help('select', availableParams.select)" ng-mouseleave=
"help()" ng-if=
"availableParams.select">
49 <legend>select
<span class=
"crm-marker" ng-if=
"::availableParams.select.required"> *
</span></legend>
50 <div ng-model=
"params.select" ui-sortable=
"{axis: 'y'}">
51 <div class=
"api4-input form-inline" ng-repeat=
"item in params.select track by $index" ng-show=
"item !== 'row_count'">
52 <i class=
"crm-i fa-arrows" aria-hidden=
"true"></i>
53 <input class=
"form-control huge" type=
"text" ng-model=
"params.select[$index]" />
54 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('select', $index)"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
57 <div class=
"api4-input form-inline">
58 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.select" crm-ui-select=
"{data: fieldsAndJoinsAndFunctionsAndWildcards}" placeholder=
"Add select" />
61 <fieldset id=
"api4-join-fieldset" class=
"api4-input form-inline" ng-mouseenter=
"help('join', availableParams.join)" ng-mouseleave=
"help()" ng-if=
"::availableParams.join">
62 <legend>join
<span class=
"crm-marker" ng-if=
"::availableParams.join.required"> *
</span></legend>
63 <div ng-model=
"params.join" ui-sortable=
"{axis: 'y', containment: '#api4-join-fieldset'}">
64 <fieldset ng-repeat=
"item in params.join track by $index">
65 <div class=
"api4-input form-inline">
66 <i class=
"crm-i fa-arrows"></i>
67 <input class=
"form-control twenty" type=
"text" ng-model=
"params.join[$index][0]" ng-model-options=
"{updateOn: 'blur'}" ng-change=
"$ctrl.buildFieldList()"/>
68 <label>{{:: ts('Required:') }}
</label>
69 <select class=
"form-control" ng-model=
"params.join[$index][1]" ng-options=
"o.k as o.v for o in ::joinTypes" ></select>
70 <label>{{:: ts('Using:') }}
</label>
71 <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()">
72 <option value=
"">{{:: ts('- none -') }}
</option>
74 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('join', $index)"><i class=
"crm-i fa-times"></i></a>
76 <fieldset class=
"api4-clause-fieldset">
77 <crm-api4-clause clauses=
"params.join[$index]" format=
"plain" skip=
"3" op=
"AND" label=
"On" fields=
"fieldsAndJoins" ></crm-api4-clause>
81 <div class=
"api4-input form-inline">
82 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.join" crm-ui-select=
"{data: entities}" placeholder=
"Add join" />
85 <div class=
"api4-input form-inline" ng-mouseenter=
"help('fields', availableParams.fields)" ng-mouseleave=
"help()" ng-if=
"::availableParams.fields">
86 <label for=
"api4-param-fields">fields
<span class=
"crm-marker" ng-if=
"::availableParams.fields.required"> *
</span></label>
87 <input class=
"form-control" ng-list
crm-ui-select=
"::{data: fields, multiple: true}" id=
"api4-param-fields" ng-model=
"params.fields" style=
"width: 85%;"/>
89 <div class=
"api4-input form-inline" ng-mouseenter=
"help('action', availableParams.action)" ng-mouseleave=
"help()"ng-if=
"::availableParams.action">
90 <label for=
"api4-param-action">action
<span class=
"crm-marker" ng-if=
"::availableParams.action.required"> *
</span></label>
91 <input class=
"form-control" crm-ui-select=
"{data: actions, allowClear: true, placeholder: 'None'}" id=
"api4-param-action" ng-model=
"params.action"/>
93 <div class=
"api4-input form-inline" ng-mouseenter=
"help(name, param)" ng-mouseleave=
"help()" ng-repeat=
"(name, param) in ::getGenericParams(['string', 'int'])">
94 <label for=
"api4-param-{{:: name }}">{{:: name }}
<span class=
"crm-marker" ng-if=
"::param.required"> *
</span></label>
95 <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]"/>
96 <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>
97 <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>
99 <div class=
"api4-input" ng-mouseenter=
"help(name, param)" ng-mouseleave=
"help()" ng-repeat=
"(name, param) in ::getGenericParams(['array', 'mixed'])">
100 <label for=
"api4-param-{{:: name }}">{{:: name }}
<span class=
"crm-marker" ng-if=
"::param.required"> *
</span></label>
101 <textarea class=
"form-control" type=
"{{:: param.type[0] === 'int' && param.type.length === 1 ? 'number' : 'text' }}" id=
"api4-param-{{:: name }}" ng-model=
"params[name]">
104 <fieldset ng-if=
"::availableParams.where" class=
"api4-clause-fieldset" ng-mouseenter=
"help('where', availableParams.where)" ng-mouseleave=
"help()">
105 <crm-api4-clause clauses=
"params.where" is-required=
"availableParams.where.required" op=
"AND" label=
"Where" fields=
"fieldsAndJoins" ></crm-api4-clause>
107 <fieldset ng-repeat=
"name in ['values', 'defaults']" ng-if=
"::availableParams[name]" ng-mouseenter=
"help(name, availableParams[name])" ng-mouseleave=
"help()">
108 <legend>{{:: name }}
<span class=
"crm-marker" ng-if=
"::availableParams[name].required"> *
</span></legend>
109 <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])">
110 <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'}" />
111 <input class=
"form-control" ng-model=
"clause[1]" api4-exp-value=
"{field: clause[0], action: action === 'getFields' ? params.action || 'get' : action}" />
113 <div class=
"api4-input form-inline">
114 <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)})}"/>
117 <fieldset ng-if=
"::availableParams.groupBy" ng-mouseenter=
"help('groupBy', availableParams.groupBy)" ng-mouseleave=
"help()">
118 <legend>groupBy
<span class=
"crm-marker" ng-if=
"::availableParams.groupBy.required"> *
</span></legend>
119 <div ng-model=
"params.groupBy" ui-sortable=
"{axis: 'y'}">
120 <div class=
"api4-input form-inline" ng-repeat=
"item in params.groupBy track by $index">
121 <i class=
"crm-i fa-arrows" aria-hidden=
"true"></i>
122 <input class=
"form-control huge" type=
"text" ng-model=
"params.groupBy[$index]" />
123 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('groupBy', $index)"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
126 <div class=
"api4-input form-inline">
127 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.groupBy" crm-ui-select=
"{data: fieldsAndJoinsAndFunctions}" placeholder=
"Add groupBy" />
130 <fieldset ng-if=
"::availableParams.having" class=
"api4-clause-fieldset" ng-mouseenter=
"help('having', availableParams.having)" ng-mouseleave=
"help()">
131 <crm-api4-clause clauses=
"params.having" is-required=
"availableParams.having.required" op=
"AND" label=
"Having" fields=
"havingOptions" ></crm-api4-clause>
133 <fieldset ng-if=
"::availableParams.orderBy" ng-mouseenter=
"help('orderBy', availableParams.orderBy)" ng-mouseleave=
"help()">
134 <legend>orderBy
<span class=
"crm-marker" ng-if=
"::availableParams.orderBy.required"> *
</span></legend>
135 <div ng-model=
"params.orderBy" ui-sortable=
"{axis: 'y'}">
136 <div class=
"api4-input form-inline" ng-repeat=
"clause in params.orderBy">
137 <i class=
"crm-i fa-arrows" aria-hidden=
"true"></i>
138 <input class=
"form-control huge" type=
"text" ng-model=
"clause[0]" />
139 <select class=
"form-control" ng-model=
"clause[1]">
140 <option value=
"ASC">ASC
</option>
141 <option value=
"DESC">DESC
</option>
143 <a href
class=
"crm-hover-button" title=
"Clear" ng-click=
"clearParam('orderBy', $index)"><i class=
"crm-i fa-times" aria-hidden=
"true"></i></a>
146 <div class=
"api4-input form-inline">
147 <input class=
"collapsible-optgroups form-control huge" ng-model=
"controls.orderBy" crm-ui-select=
"{data: fieldsAndJoinsAndFunctionsWithSuffixes}" placeholder=
"Add orderBy" />
150 <fieldset ng-if=
"::availableParams.limit && availableParams.offset">
151 <div class=
"api4-input form-inline">
152 <span ng-mouseenter=
"help('limit', availableParams.limit)" ng-mouseleave=
"help()">
153 <label for=
"api4-param-limit">limit
<span class=
"crm-marker" ng-if=
"::availableParams.limit.required"> *
</span></label>
154 <input class=
"form-control" type=
"number" min=
"0" id=
"api4-param-limit" ng-model=
"params.limit"/>
156 <span ng-mouseenter=
"help('offset', availableParams.offset)" ng-mouseleave=
"help()">
157 <label for=
"api4-param-offset">offset
<span class=
"crm-marker" ng-if=
"::availableParams.offset.required"> *
</span></label>
158 <input class=
"form-control" type=
"number" min=
"0" id=
"api4-param-offset" ng-model=
"params.offset"/>
160 <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>
163 <fieldset ng-if=
"::availableParams.chain" ng-mouseenter=
"help('chain', availableParams.chain)" ng-mouseleave=
"help()">
164 <legend>chain
</legend>
165 <div class=
"api4-input form-inline" ng-repeat=
"clause in params.chain" api4-exp-chain=
"clause" entities=
"::entities" main-entity=
"::entity" >
167 <div class=
"api4-input form-inline">
168 <input class=
"form-control" ng-model=
"controls.chain" crm-ui-select=
"::{data: entities}" placeholder=
"Add chain" />
173 <div class=
"panel panel-info explorer-help-panel">
174 <div class=
"panel-heading">
175 <h3 class=
"panel-title" crm-icon=
"fa-info-circle">{{ helpTitle }}
</h3>
177 <div class=
"panel-body">
178 <h4 ng-bind-html=
"helpContent.description"></h4>
179 <div ng-bind-html=
"helpContent.comment"></div>
180 <p ng-repeat=
"(key, item) in helpContent" ng-if=
"key !== 'description' && key !== 'comment' && key !== 'see'">
181 <strong>{{ key }}:
</strong> {{ item }}
183 <div ng-if=
"helpContent.see">
184 <strong>See:
</strong>
186 <li ng-repeat=
"ref in helpContent.see" ng-bind-html=
"ref"> </li>
192 <div class=
"api4-explorer-row">
193 <div class=
"panel panel-info explorer-code-panel">
194 <ul class=
"panel-heading nav nav-tabs">
195 <li role=
"presentation" ng-repeat=
"lang in ::langs" ng-class=
"{active: selectedTab.code === lang}">
196 <a href
ng-click=
"selectLang(lang)">
201 <div class=
"panel-body">
202 <div ng-repeat=
"style in code[selectedTab.code]">
203 <label>{{:: style.label }}
</label>
204 <div><pre class=
"prettyprint" ng-bind-html=
"style.code"></pre></div>
208 <div class=
"panel explorer-result-panel panel-{{ status }}" >
209 <ul class=
"panel-heading nav nav-tabs">
210 <li role=
"presentation" ng-class=
"{active: selectedTab.result === 'result'}">
211 <a href
ng-click=
"selectedTab.result = 'result'">
212 <span ng-switch=
"status">
213 <i class=
"fa fa-fw fa-circle-o" ng-switch-when=
"default"></i>
214 <i class=
"fa fa-fw fa-check-circle" ng-switch-when=
"success"></i>
215 <i class=
"fa fa-fw fa-check-circle" ng-switch-when=
"warning"></i>
216 <i class=
"fa fa-fw fa-minus-circle" ng-switch-when=
"danger"></i>
217 <i class=
"fa fa-fw fa-spinner fa-pulse" ng-switch-when=
"info"></i>
219 <span>{{:: ts('Result') }}
</span>
222 <li role=
"presentation" ng-if=
"::perm.accessDebugOutput" ng-class=
"{active: selectedTab.result === 'debug'}">
223 <a href
ng-click=
"selectedTab.result = 'debug'">
224 <i class=
"fa fa-fw fa-{{ debug ? (status === 'warning' || status === 'danger' ? 'warning' : 'bug') : 'circle-o' }}"></i>
225 <span>{{:: ts('Debug') }}
</span>
229 <div class=
"panel-body">
230 <div ng-show=
"selectedTab.result === 'result'">
231 <pre class=
"prettyprint" ng-repeat=
"code in result" ng-bind-html=
"code"></pre>
233 <div ng-if=
"::perm.accessDebugOutput" ng-show=
"selectedTab.result === 'debug'">
234 <pre ng-if=
"debug" class=
"prettyprint" ng-bind-html=
"debug"></pre>
237 {{:: ts('To view debugging output, enable the debug param before executing.') }}
240 {{:: ts('Enable backtrace in system settings to see error backtraces.') }}