protected function actionStore($params)
{
$columnModel = new ColumnModel(Category::model());
$columnModel->formatColumn('user_name', '$model->user ? $model->user->name : 0');
$store = new DbStore('GO\\Notes\\Model\\Category', $columnModel, $params);
$store->defaultSort = 'name';
$store->multiSelectable('no-multiselect');
echo $this->render('store', array('store' => $store));
}
/**
* Render JSON output that can be used by ExtJS GridPanel
* @param array $params the $_REQUEST params
*/
protected function actionUsers($module)
{
//Create ColumnModel from model
$columnModel = new ColumnModel(Module::model());
$columnModel->formatColumn('checked', '\\GO::scriptCanBeDecoded() && \\GO\\Professional\\License::userHasModule($model->username, $module, true)', array('module' => $module));
$findParams = FindParams::newInstance()->select('t.first_name,t.middle_name,t.last_name,t.username')->ignoreAcl()->limit(0);
//Create store
$store = new DbStore('GO\\Base\\Model\\User', $columnModel, $_POST, $findParams);
$store->defaultSort = 'username';
$response = $this->renderStore($store);
$props = \GO::scriptCanBeDecoded() ? \GO\Professional\License::properties() : array();
$response['license_id'] = isset($props['licenseid']) ? $props['licenseid'] : 0;
$response['hostname'] = $_SERVER['HTTP_HOST'];
echo $response;
}
protected function formatColumns(\GO\Base\Data\ColumnModel $columnModel)
{
$columnModel->formatColumn('category_name', '$model->category_name');
$columnModel->formatColumn('thumb', '$model->thumbURL');
$columnModel->formatColumn('permissionLevel', '$model->permissionLevel');
$columnModel->formatColumn('content', 'urldecode($model->content)');
}
/**
* Return an array with all the labels of the columns
*
* @return array
*/
public function getLabels()
{
$columns = $this->columnModel->getColumns();
$labels = array();
foreach ($columns as $column) {
$labels[$column->getDataIndex()] = $column->getLabel();
}
return $labels;
}
public function formatColumns(\GO\Base\Data\ColumnModel $columnModel)
{
$sortAlias = \GO::user()->sort_name == "first_name" ? array('first_name', 'last_name') : array('last_name', 'first_name');
$columnModel->formatColumn('name', '$model->getName(\\GO::user()->sort_name)', array(), $sortAlias, \GO::t('strName'));
$columnModel->formatColumn('company_name', '$model->company_name', array(), '', \GO::t('company', 'addressbook'));
$columnModel->formatColumn('ab_name', '$model->ab_name', array(), '', \GO::t('addressbook', 'addressbook'));
$columnModel->formatColumn('age', '$model->age', array(), 'birthday');
$columnModel->formatColumn('action_date', '$model->getActionDate()', array(), 'action_date');
$columnModel->formatColumn('cf', '$model->id.":".$model->name');
//special field used by custom fields. They need an id an value in one.)
return parent::formatColumns($columnModel);
}
protected function formatColumns(\GO\Base\Data\ColumnModel $cm)
{
$cm->formatColumn('manage_permission', 'isset($model->level) ? $model->level : ""');
$cm->formatColumn('name', '$model->name', array(), array('first_name', 'last_name'));
return parent::formatColumns($cm);
}
protected function formatColumns(\GO\Base\Data\ColumnModel $columnModel)
{
$columnModel->formatColumn('iconCls', '"go-model-".str_replace(\'\\\\\',\'_\',$model->model_name)');
$columnModel->formatColumn('name_and_type', '"(".$model->type.") ".$model->name');
$columnModel->formatColumn('model_name_and_id', '$model->model_name.":".$model->model_id');
return parent::formatColumns($columnModel);
}
protected function formatColumns(\GO\Base\Data\ColumnModel $columnModel)
{
$columnModel->formatColumn('type', 'GO\\Base\\Fs\\File::getFileTypeDescription($model->extension)');
return parent::formatColumns($columnModel);
}
protected function formatColumns(\GO\Base\Data\ColumnModel $columnModel)
{
$columnModel->formatColumn('completion_time', '$model->getAttribute("completion_time","formatted")', array(), 'completion_time');
$columnModel->formatColumn('completed', '$model->status=="COMPLETED" ? 1 : 0');
$columnModel->formatColumn('is_active', '$model->isActive()');
// $columnModel->formatColumn('status', '$l["statuses[\'".$model->status."\']"');
//$columnModel->formatColumn('category_name','$model->category->name',array(),'category_id');
$columnModel->formatColumn('tasklist_name', '$model->tasklist_name');
$columnModel->formatColumn('late', '$model->isLate();');
$columnModel->formatColumn('user_name', '$model->user->name');
if (\GO::modules()->projects2) {
$columnModel->formatColumn('project_name', '$model->project2->name');
} elseif (\GO::modules()->projects) {
$columnModel->formatColumn('project_name', '$model->project->name');
}
return parent::formatColumns($columnModel);
}
/**
* Get the columnmodel for this export
*
* @param array $columns
* @return \GO\Base\Model\ColumnModel
*/
public function getColumnModel($columns = false)
{
$colModel = new ColumnModel();
if (!$columns) {
$columns = $this->_columns;
}
foreach ($columns as $col) {
// $format = '$model->'.str_replace('.','->', $col);
$format = '$model->resolveAttribute("' . $col . '","formatted");';
$colModel->formatColumn($col, $format, array(), '', $this->getLabel($col));
}
$colModel->sort($columns);
$colModel = $this->formatColumns($colModel);
$formattedColumns = $colModel->getColumns();
foreach ($formattedColumns as $formattedCol) {
if (!in_array($formattedCol->getDataIndex(), $columns)) {
$colModel->removeColumn($formattedCol->getDataIndex());
}
}
return $colModel;
}
protected function formatColumns(\GO\Base\Data\ColumnModel $cm)
{
$cm->formatColumn('manage_permission', 'isset($model->level) ? $model->level : ""');
return parent::formatColumns($cm);
}
private function _listShares($params)
{
//$store = \GO\Base\Data\Store::newInstance(\GO\Files\Model\Folder::model());
//
// //set sort aliases
// $store->getColumnModel()->formatColumn('type', '$model->type',array(),'name');
// $store->getColumnModel()->formatColumn('size', '"-"',array(),'name');
//
// $store->getColumnModel()->setFormatRecordFunction(array($this, 'formatListRecord'));
// $findParams = $store->getDefaultParams($params);
// $stmt = \GO\Files\Model\Folder::model()->findShares($findParams);
// $store->setStatement($stmt);
//
// $response = $store->getData();
// $fp = \GO\Base\Db\FindParams::newInstance()->limit(100);
//$fp = \GO\Base\Db\FindParams::newInstance()->calcFoundRows();
$cm = new \GO\Base\Data\ColumnModel('GO\\Files\\Model\\Folder');
$cm->setFormatRecordFunction(array($this, 'formatListRecord'));
$findParams = \GO\Base\Db\FindParams::newInstance()->joinRelation('sharedRootFolders')->ignoreAcl()->order('name', 'ASC');
$findParams->getCriteria()->addCondition('user_id', \GO::user()->id, '=', 'sharedRootFolders');
$store = new \GO\Base\Data\DbStore('GO\\Files\\Model\\Folder', $cm, $params, $findParams);
$response = $store->getData();
$response['permission_level'] = \GO\Base\Model\Acl::READ_PERMISSION;
// $response['results']=array();
// $shares =\GO\Files\Model\Folder::model()->getTopLevelShares($fp);
// foreach($shares as $folder){
// $record=$folder->getAttributes("html");
// $record = $this->formatListRecord($record, $folder, false);
// $response['results'][]=$record;
// }
// $response['total']=$shares->foundRows;
return $response;
}
protected function formatColumns(\GO\Base\Data\ColumnModel $columnModel)
{
$columnModel->formatColumn('user_name', '$model->user ? $model->user->name : \\GO::t("globalCategory","tasks")');
return parent::formatColumns($columnModel);
}
/**
* Render JSON output that can be used by ExtJS GridPanel
* @param array $params the $_REQUEST params
*/
protected function actionStore($excerpt = false)
{
//Create ColumnModel from model
$columnModel = new \GO\Base\Data\ColumnModel();
$columnModel->formatColumn('user_name', '$model->user->name', array(), 'user_id');
$columnModel->setModelFormatType('raw');
$findParams = \GO\Base\Db\FindParams::newInstance()->export('notes');
if ($excerpt) {
$columnModel->formatColumn('excerpt', '$model->excerpt');
$findParams->select('t.*');
}
$nn = new Note();
$store = new \GO\Base\Data\DbStore($nn->className(), $columnModel, null, $findParams);
$store->multiSelect('no-multiselect', Category::className(), 'category_id');
echo $this->render('store', array('store' => $store));
}
protected function formatColumns(\GO\Base\Data\ColumnModel $columnModel)
{
$columnModel->formatColumn('name', '$model->getName()', array(), \GO::user()->sort_name);
$columnModel->formatColumn('enabled', "!empty(\$model->enabled) ? \\GO::t('yes') : \\GO::t('no')");
return parent::formatColumns($columnModel);
}
/**
* Tell the controller to change some column values
*/
protected function formatColumns(\GO\Base\Data\ColumnModel $columnModel)
{
$columnModel->formatColumn('party_id', '$model->party->name');
$columnModel->formatColumn('income_val', '$model->income');
return parent::formatColumns($columnModel);
}
protected function formatColumns(\GO\Base\Data\ColumnModel $columnModel)
{
$columnModel->formatColumn('user_name', '$model->user->name');
return parent::formatColumns($columnModel);
}
protected function formatColumns(\GO\Base\Data\ColumnModel $columnModel)
{
$columnModel->formatColumn('name_with_id', '$model->id.":".$model->name');
}
