Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $commonParams = array(
- 'select' => [
- 'GROUP_ID' => 'TASK.GROUP_ID'
- ,'DEAL_ID' => 'TASK.UF_TASK_DEAL'
- ,'RATE' => 'RATE_HL.UF_RATE'
- ,'USER_ID'
- ,new ExpressionField('USER_NAME', 'CONCAT_WS(" ", %s, %s)', array('USER.NAME', 'USER.LAST_NAME'))
- ,new ExpressionField('TIME', 'SUM(%s)', 'SECONDS')
- ,new ExpressionField('TOTAL', 'ROUND(SUM(%s) / 3600 * %s, 0)', array('SECONDS', 'RATE_HL.UF_RATE'))
- ,new ExpressionField('PERIOD_FILTER_FROM', '%s <= %s', array('RATE_HL.UF_RATE_FROM', 'CREATED_DATE'))
- ,new ExpressionField('PERIOD_FILTER_TO', '%s <= %s', array('CREATED_DATE', 'RATE_HL.UF_RATE_TO'))
- ,new ExpressionField('CNT', 'COUNT(*)')
- ],
- 'filter' => ['GROUP_ID' => $groupsID, '>SECONDS' => 0,
- [
- 'LOGIC' => 'OR',
- ['==RATE_HL.UF_RATE_FROM' => null, '==RATE_HL.UF_RATE_TO' => null],
- ['==RATE_HL.UF_RATE_FROM' => null, '==PERIOD_FILTER_TO' => true],
- ['==PERIOD_FILTER_FROM' => true, '==PERIOD_FILTER_TO' => true],
- ['==PERIOD_FILTER_FROM' => true, '==RATE_HL.UF_RATE_TO' => null]
- ]
- ],
- 'group' => ['GROUP_ID', 'DEAL_ID', 'USER_ID'],
- 'runtime' => [
- 'RATE_HL' => [
- 'data_type' => $hlClass,
- 'reference' => [ '=this.USER_ID' => 'ref.UF_USER_ID']
- ],
- ],
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement