REF - Divorce API4SelectQuery from base class SelectQuery

[civicrm-core.git] / ang / api4Explorer / Explorer.html

<div id="bootstrap-theme" class="api4-explorer-page">
  <div crm-ui-debug="availableParams"></div>

  <h1 crm-page-title>
    {{:: ts('CiviCRM APIv4') }}{{ entity ? (' (' + entity + '::' + action + ')') : '' }}
  </h1>

  <!--This warning will show if bootstrap is unavailable. Normally it will be hidden by the bootstrap .collapse class.-->
  <div class="messages warning no-popup collapse">
    <p>
      <i class="crm-i fa-exclamation-triangle" aria-hidden="true"></i>
      <strong>{{:: ts('Bootstrap theme not found.') }}</strong>
    </p>
    <p>{{:: ts('This screen may not work correctly without a bootstrap-based theme such as Shoreditch installed.') }}</p>
  </div>

  <div class="api4-explorer-row">
      <form name="api4-explorer" class="panel panel-default explorer-params-panel">
        <div class="panel-heading">
          <div class="form-inline">
            <span ng-mouseenter="help('entity', paramDoc('$entity'))" ng-mouseleave="help()">
              <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}" />
            </span>
            <span ng-mouseenter="help('action', paramDoc('$action'))" ng-mouseleave="help()">
              <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}" />
            </span>
            <input class="form-control api4-index" type="search" ng-model="index" ng-mouseenter="help('index', paramDoc('$index'))" ng-mouseleave="help()" placeholder="{{:: ts('Index') }}" />
            <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>
            <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>
          </div>
        </div>
        <div class="panel-body">
          <div class="api4-input form-inline">
            <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)">
              <input type="checkbox" id="api4-param-{{:: name }}" ng-model="params[name]"/>
              {{:: name }}<span class="crm-marker" ng-if="::param.required"> *</span>
            </label>
            <label class="form-control" ng-mouseenter="help('selectRowCount', availableParams.select)" ng-mouseleave="help()" ng-class="{'api4-option-selected': isSelectRowCount()}" ng-if="::availableParams.select">
              <input type="checkbox" id="api4-param-selectRowCount" ng-checked="isSelectRowCount()" ng-click="selectRowCount()" />
              SelectRowCount
            </label>
          </div>
          <div class="api4-input form-inline" ng-mouseenter="help(name, param)" ng-mouseleave="help()" ng-repeat="(name, param) in ::getGenericParams(['bool'], true)">
            <label>{{ name }}<span class="crm-marker" ng-if="::param.required"> *</span></label>
            <label class="radio-inline">
              <input type="radio" ng-model="params[name]" ng-value="true" />true
            </label>
            <label class="radio-inline">
              <input type="radio" ng-model="params[name]" ng-value="false" />false
            </label>
            <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>
          </div>
          <fieldset class="api4-input form-inline" ng-mouseenter="help('select', availableParams.select)" ng-mouseleave="help()" ng-if="availableParams.select && !isSelectRowCount()">
            <legend>select<span class="crm-marker" ng-if="::availableParams.select.required"> *</span></legend>
            <div ng-model="params.select" ui-sortable="{axis: 'y'}">
              <div class="api4-input form-inline" ng-repeat="item in params.select track by $index">
                <i class="crm-i fa-arrows" aria-hidden="true"></i>
                <input class="form-control huge" type="text" ng-model="params.select[$index]" />
                <a href class="crm-hover-button" title="Clear" ng-click="clearParam('select', $index)"><i class="crm-i fa-times" aria-hidden="true"></i></a>
              </div>
            </div>
            <div class="api4-input form-inline">
              <input class="collapsible-optgroups form-control huge" ng-model="controls.select" crm-ui-select="{data: fieldsAndJoinsAndFunctionsAndWildcards}" placeholder="Add select" />
            </div>
          </fieldset>
          <fieldset id="api4-join-fieldset" class="api4-input form-inline" ng-mouseenter="help('join', availableParams.join)" ng-mouseleave="help()" ng-if="::availableParams.join">
            <legend>join<span class="crm-marker" ng-if="::availableParams.join.required"> *</span></legend>
            <div ng-model="params.join" ui-sortable="{axis: 'y', containment: '#api4-join-fieldset'}">
              <fieldset ng-repeat="item in params.join track by $index">
                <div class="api4-input form-inline">
                  <i class="crm-i fa-arrows"></i>
                  <input class="form-control twenty" type="text" ng-model="params.join[$index][0]" ng-model-options="{updateOn: 'blur'}" ng-change="$ctrl.buildFieldList()"/>
                  <select class="form-control" ng-model="params.join[$index][1]" ng-options="o.k as o.v for o in ::joinTypes" ></select>
                  <a href class="crm-hover-button" title="Clear" ng-click="clearParam('join', $index)"><i class="crm-i fa-times"></i></a>
                </div>
                <fieldset class="api4-clause-fieldset" crm-api4-clause="{skip: 2, clauses: params.join[$index], op: 'AND', label: 'On', fields: fieldsAndJoins, format: 'plain'}">
                </fieldset>
              </fieldset>
            </div>
            <div class="api4-input form-inline">
              <input class="collapsible-optgroups form-control huge" ng-model="controls.join" crm-ui-select="{data: entities}" placeholder="Add join" />
            </div>
          </fieldset>
          <div class="api4-input form-inline" ng-mouseenter="help('fields', availableParams.fields)" ng-mouseleave="help()" ng-if="::availableParams.fields">
            <label for="api4-param-fields">fields<span class="crm-marker" ng-if="::availableParams.fields.required"> *</span></label>
            <input class="form-control" ng-list crm-ui-select="::{data: fields, multiple: true}" id="api4-param-fields" ng-model="params.fields" style="width: 85%;"/>
          </div>
          <div class="api4-input form-inline" ng-mouseenter="help('action', availableParams.action)" ng-mouseleave="help()"ng-if="::availableParams.action">
            <label for="api4-param-action">action<span class="crm-marker" ng-if="::availableParams.action.required"> *</span></label>
            <input class="form-control" crm-ui-select="{data: actions, allowClear: true, placeholder: 'None'}" id="api4-param-action" ng-model="params.action"/>
          </div>
          <div class="api4-input form-inline" ng-mouseenter="help(name, param)" ng-mouseleave="help()" ng-repeat="(name, param) in ::getGenericParams(['string', 'int'])">
            <label for="api4-param-{{:: name }}">{{:: name }}<span class="crm-marker" ng-if="::param.required"> *</span></label>
            <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]"/>
            <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>
            <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>
          </div>
          <div class="api4-input" ng-mouseenter="help(name, param)" ng-mouseleave="help()" ng-repeat="(name, param) in ::getGenericParams(['array', 'mixed'])">
            <label for="api4-param-{{:: name }}">{{:: name }}<span class="crm-marker" ng-if="::param.required"> *</span></label>
            <textarea class="form-control" type="{{:: param.type[0] === 'int' && param.type.length === 1 ? 'number' : 'text' }}" id="api4-param-{{:: name }}" ng-model="params[name]">
            </textarea>
          </div>
          <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}">
          </fieldset>
          <fieldset ng-repeat="name in ['values', 'defaults']" ng-if="::availableParams[name]" ng-mouseenter="help(name, availableParams[name])" ng-mouseleave="help()">
            <legend>{{:: name }}<span class="crm-marker" ng-if="::availableParams[name].required"> *</span></legend>
            <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])">
              <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'}" />
              <input class="form-control" ng-model="clause[1]" api4-exp-value="{field: clause[0], action: action === 'getFields' ? params.action || 'get' : action}" />
            </div>
            <div class="api4-input form-inline">
              <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)})}"/>
            </div>
          </fieldset>
          <fieldset ng-if="::availableParams.groupBy" ng-mouseenter="help('groupBy', availableParams.groupBy)" ng-mouseleave="help()">
            <legend>groupBy<span class="crm-marker" ng-if="::availableParams.groupBy.required"> *</span></legend>
            <div ng-model="params.groupBy" ui-sortable="{axis: 'y'}">
              <div class="api4-input form-inline" ng-repeat="item in params.groupBy track by $index">
                <i class="crm-i fa-arrows" aria-hidden="true"></i>
                <input class="form-control huge" type="text" ng-model="params.groupBy[$index]" />
                <a href class="crm-hover-button" title="Clear" ng-click="clearParam('groupBy', $index)"><i class="crm-i fa-times" aria-hidden="true"></i></a>
              </div>
            </div>
            <div class="api4-input form-inline">
              <input class="collapsible-optgroups form-control huge" ng-model="controls.groupBy" crm-ui-select="{data: fieldsAndJoinsAndFunctions}" placeholder="Add groupBy" />
            </div>
          </fieldset>
          <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}">
          </fieldset>
          <fieldset ng-if="::availableParams.orderBy" ng-mouseenter="help('orderBy', availableParams.orderBy)" ng-mouseleave="help()">
            <legend>orderBy<span class="crm-marker" ng-if="::availableParams.orderBy.required"> *</span></legend>
            <div ng-model="params.orderBy" ui-sortable="{axis: 'y'}">
              <div class="api4-input form-inline" ng-repeat="clause in params.orderBy">
                <i class="crm-i fa-arrows" aria-hidden="true"></i>
                <input class="form-control huge" type="text" ng-model="clause[0]" />
                <select class="form-control" ng-model="clause[1]">
                  <option value="ASC">ASC</option>
                  <option value="DESC">DESC</option>
                </select>
                <a href class="crm-hover-button" title="Clear" ng-click="clearParam('orderBy', $index)"><i class="crm-i fa-times" aria-hidden="true"></i></a>
              </div>
            </div>
            <div class="api4-input form-inline">
              <input class="collapsible-optgroups form-control huge" ng-model="controls.orderBy" crm-ui-select="{data: fieldsAndJoinsAndFunctionsWithSuffixes}" placeholder="Add orderBy" />
            </div>
          </fieldset>
          <fieldset ng-if="::availableParams.limit && availableParams.offset">
            <div class="api4-input form-inline">
              <span ng-mouseenter="help('limit', availableParams.limit)" ng-mouseleave="help()">
                <label for="api4-param-limit">limit<span class="crm-marker" ng-if="::availableParams.limit.required"> *</span></label>
                <input class="form-control" type="number" min="0" id="api4-param-limit" ng-model="params.limit"/>
              </span>
              <span ng-mouseenter="help('offset', availableParams.offset)" ng-mouseleave="help()">
                <label for="api4-param-offset">offset<span class="crm-marker" ng-if="::availableParams.offset.required"> *</span></label>
                <input class="form-control" type="number" min="0" id="api4-param-offset" ng-model="params.offset"/>
              </span>
              <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>
            </div>
          </fieldset>
          <fieldset ng-if="::availableParams.chain" ng-mouseenter="help('chain', availableParams.chain)" ng-mouseleave="help()">
            <legend>chain</legend>
            <div class="api4-input form-inline" ng-repeat="clause in params.chain" api4-exp-chain="clause" entities="::entities" main-entity="::entity" >
            </div>
            <div class="api4-input form-inline">
              <input class="form-control" ng-model="controls.chain" crm-ui-select="::{data: entities}" placeholder="Add chain" />
            </div>
          </fieldset>
        </div>
      </form>
      <div class="panel panel-info explorer-help-panel">
        <div class="panel-heading">
          <h3 class="panel-title" crm-icon="fa-info-circle">{{ helpTitle }}</h3>
        </div>
        <div class="panel-body">
          <h4 ng-bind-html="helpContent.description"></h4>
          <div ng-bind-html="helpContent.comment"></div>
          <p ng-repeat="(key, item) in helpContent" ng-if="key !== 'description' && key !== 'comment' && key !== 'see'">
            <strong>{{ key }}:</strong> {{ item }}
          </p>
          <div ng-if="helpContent.see">
            <strong>See:</strong>
            <ul>
              <li ng-repeat="ref in helpContent.see" ng-bind-html="ref"> </li>
            </ul>
          </div>
        </div>
      </div>
  </div>
  <div class="api4-explorer-row">
      <div class="panel panel-info explorer-code-panel">
        <ul class="panel-heading nav nav-tabs">
          <li role="presentation" ng-repeat="lang in ::langs" ng-class="{active: selectedTab.code === lang}">
            <a href ng-click="selectLang(lang)">
              {{:: lang }}
            </a>
          </li>
        </ul>
        <div class="panel-body">
          <table>
            <tr ng-repeat="style in code[selectedTab.code]">
              <td>{{:: style.label }}</td>
              <td><pre class="prettyprint" ng-bind-html="style.code"></pre></td>
            </tr>
          </table>
        </div>
      </div>
      <div class="panel explorer-result-panel panel-{{ status }}" >
        <ul class="panel-heading nav nav-tabs">
          <li role="presentation" ng-class="{active: selectedTab.result === 'result'}">
            <a href ng-click="selectedTab.result = 'result'">
              <span ng-switch="status">
                <i class="fa fa-fw fa-circle-o" ng-switch-when="default"></i>
                <i class="fa fa-fw fa-check-circle" ng-switch-when="success"></i>
                <i class="fa fa-fw fa-check-circle" ng-switch-when="warning"></i>
                <i class="fa fa-fw fa-minus-circle" ng-switch-when="danger"></i>
                <i class="fa fa-fw fa-spinner fa-pulse" ng-switch-when="info"></i>
              </span>
              <span>{{:: ts('Result') }}</span>
            </a>
          </li>
          <li role="presentation" ng-if="::perm.accessDebugOutput" ng-class="{active: selectedTab.result === 'debug'}">
            <a href ng-click="selectedTab.result = 'debug'">
              <i class="fa fa-fw fa-{{ debug ? (status === 'warning' || status === 'danger' ? 'warning' : 'bug') : 'circle-o' }}"></i>
              <span>{{:: ts('Debug') }}</span>
            </a>
          </li>
        </ul>
        <div class="panel-body">
          <div ng-show="selectedTab.result === 'result'">
            <pre class="prettyprint" ng-repeat="code in result" ng-bind-html="code"></pre>
          </div>
          <div ng-if="::perm.accessDebugOutput" ng-show="selectedTab.result === 'debug'">
            <pre ng-if="debug" class="prettyprint" ng-bind-html="debug"></pre>
            <div ng-if="!debug">
              <p>
                {{:: ts('To view debugging output, enable the debug param before executing.') }}
              </p>
              <p>
                {{:: ts('Enable backtrace in system settings to see error backtraces.') }}
              </p>
            </div>
          </div>
        </div>
      </div>
  </div>
</div>