Settings_Groups_GetData_View::process()

Complexity

Conditions	7
Paths	12

Size

Total Lines	39
Code Lines	31

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
	public function process(App\Request $request)
	{
		$this->request = $request;
		$rows = $columns = [];
		foreach ($this->request->getArray('columns') as $key => $value) {
			$columns[$key] = $value['name'];
		}
		$this->moduleModel = Settings_Vtiger_Module_Model::getInstance($this->request->getModule(false));
		$fields = $this->moduleModel->getListFields();
		$table = $this->moduleModel->baseTable;
		$this->baseIndex = $this->moduleModel->baseIndex;
		$query = (new \App\Db\Query())->select(["{$table}.{$this->baseIndex}"])->from($table);
		$query = $this->setConditions($query, $fields);
		$query->limit($this->request->getInteger('length'))->offset($this->request->getInteger('start'));
		$order = current($this->request->getArray('order', App\Purifier::ALNUM));
		if ($order && isset($columns[$order['column']], $fields[$columns[$order['column']]])) {
			$field = $fields[$columns[$order['column']]];
			$query->orderBy([$field->getColumnName() => \App\Db::ASC === strtoupper($order['dir']) ? \SORT_ASC : \SORT_DESC]);
		}
		$filter = $query->count("{$table}.{$this->baseIndex}");
		$resultData = $query->distinct()->all();

		foreach ($resultData as $key => $row) {
			$recordModel = Settings_Groups_Record_Model::getInstance($row['groupid']);
			$data = [];
			foreach ($fields as $fieldModel) {
				$data[] = $recordModel->getDisplayValue($fieldModel->getName());
			}
			$data[] = '<span class="js-detail-button d-none" data-recordurl="' . $recordModel->getDetailViewUrl() . '"></span>
			<a class="btn btn-primary btn-sm js-no-link" title="' . \App\Language::translate('LBL_EDIT') . '" href="' . $recordModel->getEditViewUrl() . '"><span class="yfi yfi-full-editing-view"></span></a><button type="button" class="btn btn-danger btn-sm ml-1 js-no-link js-show-modal" data-id="' . $row[$this->baseIndex] . '" title="' . \App\Language::translate('LBL_DELETE_RECORD') . '" data-url="' . $recordModel->getDeleteActionUrl() . '"><span class="fas fa-trash-alt js-no-link"></span></button>';
			$rows[] = $data;
		}
		$result = [
			'draw' => $this->request->getInteger('draw'),
			'iTotalDisplayRecords' => $filter,
			'aaData' => $rows
		];
		header('content-type: text/json; charset=UTF-8');
		echo \App\Json::encode($result);
	}