Merge pull request #21882 from mariav0/patch-20
[civicrm-core.git] / ang / api4Explorer / Explorer.html
1 <div id="bootstrap-theme" class="api4-explorer-page">
2 <div crm-ui-debug="availableParams"></div>
3
4 <h1 crm-page-title>
5 {{:: ts('CiviCRM APIv4') }}{{ entity ? (' (' + entity + '::' + action + ')') : '' }}
6 </h1>
7
8 <div class="api4-explorer-row crm-flex-box">
9 <form name="api4-explorer" class="panel panel-default explorer-params-panel crm-flex-2">
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, formatResultCssClass: formatResultCssClass}" />
14 </span>
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, formatResultCssClass: formatResultCssClass}" />
17 </span>
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>
21 </div>
22 </div>
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)">
26 <label>
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>
29 </label>
30 </div>
31 <div class="checkbox-inline form-control" ng-mouseenter="help('selectRowCount', availableParams.select)" ng-mouseleave="help()" ng-if="::availableParams.select">
32 <label>
33 <input type="checkbox" id="api4-param-selectRowCount" ng-checked="isSelectRowCount()" ng-click="selectRowCount()" />
34 <span>SelectRowCount</span>
35 </label>
36 </div>
37 </div>
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
42 </label>
43 <label class="radio-inline">
44 <input type="radio" ng-model="params[name]" ng-value="false" />false
45 </label>
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>
47 </div>
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>
55 </div>
56 </div>
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" />
59 </div>
60 </fieldset>
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>
73 </select>
74 <a href class="crm-hover-button" title="Clear" ng-click="clearParam('join', $index)"><i class="crm-i fa-times"></i></a>
75 </div>
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>
78 </fieldset>
79 </fieldset>
80 </div>
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" />
83 </div>
84 </fieldset>
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%;"/>
88 </div>
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"/>
92 </div>
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>
98 </div>
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" ng-if="::!param.options" id="api4-param-{{:: name }}" ng-model="params[name]">
102 </textarea>
103 <select multiple ng-if="::param.options" crm-ui-select class="form-control" id="api4-param-{{:: name }}" ng-model="params[name]">
104 <option ng-repeat="opt in param.options" value="{{ opt }}">{{ opt }}</option>
105 </select>
106 </div>
107 <fieldset ng-if="::availableParams.where" class="api4-clause-fieldset" ng-mouseenter="help('where', availableParams.where)" ng-mouseleave="help()">
108 <crm-api4-clause clauses="params.where" is-required="availableParams.where.required" op="AND" label="Where" fields="fieldsAndJoins" ></crm-api4-clause>
109 </fieldset>
110 <fieldset ng-repeat="name in ['values', 'defaults']" ng-if="::availableParams[name]" ng-mouseenter="help(name, availableParams[name])" ng-mouseleave="help()">
111 <legend>{{:: name }}<span class="crm-marker" ng-if="::availableParams[name].required"> *</span></legend>
112 <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])">
113 <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'}" />
114 <input class="form-control" ng-model="clause[1]" api4-exp-value="{field: clause[0], action: action === 'getFields' ? params.action || 'get' : action}" />
115 </div>
116 <div class="api4-input form-inline">
117 <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)})}"/>
118 </div>
119 </fieldset>
120 <fieldset ng-if="::availableParams.groupBy" ng-mouseenter="help('groupBy', availableParams.groupBy)" ng-mouseleave="help()">
121 <legend>groupBy<span class="crm-marker" ng-if="::availableParams.groupBy.required"> *</span></legend>
122 <div ng-model="params.groupBy" ui-sortable="{axis: 'y'}">
123 <div class="api4-input form-inline" ng-repeat="item in params.groupBy track by $index">
124 <i class="crm-i fa-arrows" aria-hidden="true"></i>
125 <input class="form-control huge" type="text" ng-model="params.groupBy[$index]" />
126 <a href class="crm-hover-button" title="Clear" ng-click="clearParam('groupBy', $index)"><i class="crm-i fa-times" aria-hidden="true"></i></a>
127 </div>
128 </div>
129 <div class="api4-input form-inline">
130 <input class="collapsible-optgroups form-control huge" ng-model="controls.groupBy" crm-ui-select="{data: fieldsAndJoinsAndFunctions}" placeholder="Add groupBy" />
131 </div>
132 </fieldset>
133 <fieldset ng-if="::availableParams.having" class="api4-clause-fieldset" ng-mouseenter="help('having', availableParams.having)" ng-mouseleave="help()">
134 <crm-api4-clause clauses="params.having" is-required="availableParams.having.required" op="AND" label="Having" fields="havingOptions" ></crm-api4-clause>
135 </fieldset>
136 <fieldset ng-if="::availableParams.orderBy" ng-mouseenter="help('orderBy', availableParams.orderBy)" ng-mouseleave="help()">
137 <legend>orderBy<span class="crm-marker" ng-if="::availableParams.orderBy.required"> *</span></legend>
138 <div ng-model="params.orderBy" ui-sortable="{axis: 'y'}">
139 <div class="api4-input form-inline" ng-repeat="clause in params.orderBy">
140 <i class="crm-i fa-arrows" aria-hidden="true"></i>
141 <input class="form-control huge" type="text" ng-model="clause[0]" />
142 <select class="form-control" ng-model="clause[1]">
143 <option value="ASC">ASC</option>
144 <option value="DESC">DESC</option>
145 </select>
146 <a href class="crm-hover-button" title="Clear" ng-click="clearParam('orderBy', $index)"><i class="crm-i fa-times" aria-hidden="true"></i></a>
147 </div>
148 </div>
149 <div class="api4-input form-inline">
150 <input class="collapsible-optgroups form-control huge" ng-model="controls.orderBy" crm-ui-select="{data: fieldsAndJoinsAndFunctionsWithSuffixes}" placeholder="Add orderBy" />
151 </div>
152 </fieldset>
153 <fieldset ng-if="::availableParams.limit && availableParams.offset">
154 <div class="api4-input form-inline">
155 <span ng-mouseenter="help('limit', availableParams.limit)" ng-mouseleave="help()">
156 <label for="api4-param-limit">limit<span class="crm-marker" ng-if="::availableParams.limit.required"> *</span></label>
157 <input class="form-control" type="number" min="0" id="api4-param-limit" ng-model="params.limit"/>
158 </span>
159 <span ng-mouseenter="help('offset', availableParams.offset)" ng-mouseleave="help()">
160 <label for="api4-param-offset">offset<span class="crm-marker" ng-if="::availableParams.offset.required"> *</span></label>
161 <input class="form-control" type="number" min="0" id="api4-param-offset" ng-model="params.offset"/>
162 </span>
163 <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>
164 </div>
165 </fieldset>
166 <fieldset ng-if="::availableParams.chain" ng-mouseenter="help('chain', availableParams.chain)" ng-mouseleave="help()">
167 <legend>chain</legend>
168 <div class="api4-input form-inline" ng-repeat="clause in params.chain" api4-exp-chain="clause" entities="::entities" main-entity="::entity" >
169 </div>
170 <div class="api4-input form-inline">
171 <input class="form-control" ng-model="controls.chain" crm-ui-select="::{data: entities}" placeholder="Add chain" />
172 </div>
173 </fieldset>
174 </div>
175 </form>
176 <div class="panel panel-info explorer-help-panel">
177 <div class="panel-heading">
178 <h3 class="panel-title" crm-icon="fa-info-circle">{{ helpTitle }}</h3>
179 </div>
180 <div class="panel-body">
181 <h4 ng-bind-html="helpContent.description"></h4>
182 <div ng-bind-html="helpContent.comment"></div>
183 <p ng-repeat="(key, item) in helpContent" ng-if="key !== 'description' && key !== 'comment' && key !== 'see'">
184 <strong>{{ key }}:</strong> {{ item }}
185 </p>
186 <div ng-if="helpContent.see">
187 <strong>See:</strong>
188 <ul>
189 <li ng-repeat="ref in helpContent.see" ng-bind-html="ref"> </li>
190 </ul>
191 </div>
192 </div>
193 </div>
194 </div>
195 <div class="api4-explorer-row crm-flex-box">
196 <div class="panel panel-info explorer-code-panel">
197 <ul class="panel-heading nav nav-tabs">
198 <li role="presentation" ng-repeat="lang in ::langs" ng-class="{active: selectedTab.code === lang}">
199 <a href ng-click="selectLang(lang)">
200 {{:: lang }}
201 </a>
202 </li>
203 </ul>
204 <div class="panel-body">
205 <div ng-repeat="style in code[selectedTab.code]">
206 <label>{{:: style.label }}</label>
207 <div><pre class="prettyprint" ng-bind-html="style.code"></pre></div>
208 </div>
209 </div>
210 </div>
211 <div class="panel explorer-result-panel panel-{{ status }}" >
212 <ul class="panel-heading nav nav-tabs">
213 <li role="presentation" ng-class="{active: selectedTab.result === 'result'}">
214 <a href ng-click="selectedTab.result = 'result'">
215 <span ng-switch="status">
216 <i class="fa fa-fw fa-circle-o" ng-switch-when="default"></i>
217 <i class="fa fa-fw fa-check-circle" ng-switch-when="success"></i>
218 <i class="fa fa-fw fa-check-circle" ng-switch-when="warning"></i>
219 <i class="fa fa-fw fa-minus-circle" ng-switch-when="danger"></i>
220 <i class="fa fa-fw fa-spinner fa-pulse" ng-switch-when="info"></i>
221 </span>
222 <span>{{:: ts('Result') }}</span>
223 </a>
224 </li>
225 <li role="presentation" ng-if="::perm.accessDebugOutput" ng-class="{active: selectedTab.result === 'debug'}">
226 <a href ng-click="selectedTab.result = 'debug'">
227 <i class="fa fa-fw fa-{{ debug ? (status === 'warning' || status === 'danger' ? 'warning' : 'bug') : 'circle-o' }}"></i>
228 <span>{{:: ts('Debug') }}</span>
229 </a>
230 </li>
231 </ul>
232 <div class="panel-body">
233 <div ng-show="selectedTab.result === 'result'">
234 <pre class="prettyprint" ng-repeat="code in result" ng-bind-html="code"></pre>
235 </div>
236 <div ng-if="::perm.accessDebugOutput" ng-show="selectedTab.result === 'debug'">
237 <pre ng-if="debug" class="prettyprint" ng-bind-html="debug"></pre>
238 <div ng-if="!debug">
239 <p>
240 {{:: ts('To view debugging output, enable the debug param before executing.') }}
241 </p>
242 <p>
243 {{:: ts('Enable backtrace in system settings to see error backtraces.') }}
244 </p>
245 </div>
246 </div>
247 </div>
248 </div>
249 </div>
250 </div>