PageRenderTime 51ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

/library/Standard/Controller/Model.php

https://github.com/18thstreetmike/sodapop_for_codaserver
PHP | 655 lines | 631 code | 17 blank | 7 comment | 162 complexity | 6ee7a637ceeda3e4ebfd50dd2743a8d6 MD5 | raw file
    

  1. <?php
    2. 

  2. /**
    3. 

  3.  * Description of indexController
    4. 

  4.  *
    5. 

  5.  * @author michaelarace
    6. 

  6.  */
    7. 

  7. class Standard_Controller_Model extends Sodapop_Controller {
    8. 

  8. 	protected $model;
    9. 

  9. 

  10. 	protected $modelClassname = '';
    11. 

  11. 	protected $listSelectClause = '';
    12. 

  12. 	protected $listFromClause = '';
    13. 

  13. 	protected $joinedTables = array();
    14. 

  14. 	protected $selectedColumns = array();
    15. 

  15. 

  16. 	public function __call($name, $arguments) {
    17. 

  17. 		if (substr($name, -6) == 'Action') {
    18. 

  18. 			$actionName = substr($name, 0, strlen($name) - 6);
    19. 

  19. 			if ($this->model instanceof Sodapop_Database_Form_Abstract) {
    20. 

  20. 

  21. 			} else {
    22. 

  22. 				if ($this->user->hasTablePermission(strtolower(Sodapop_Inflector::camelCapsToUnderscores($this->modelClassname, false)), strtoupper($actionName))) {
    23. 

  23. 					$this->viewAction($actionName);
    24. 

  24. 				} else {
    25. 

  25. 					$this->viewAction();
    26. 

  26. 				}
    27. 

  27. 			}
    28. 

  28. 		}
    29. 

  29. 	}
    30. 

  30. 

  31. 	public function preDispatch() {
    32. 

  32. 		$modelClassname = str_replace('Controller','', get_class($this));
    33. 

  33. 		$this->modelClassname = $modelClassname;
    34. 

  34. 		$this->model = new $modelClassname();
    35. 

  35. 		$this->listFromClause = strtolower(Sodapop_Inflector::camelCapsToUnderscores($modelClassname, false)).' AS '.$this->createAlias($modelClassname).' ';
    36. 

  36. 		if ($this->model instanceof Sodapop_Database_Form_Abstract) {
    37. 

  37. 			$this->listFromClause .= ' INNER JOIN '.$this->model->getStatusTableName().' AS model_statuses ON model_statuses.id = '.$this->createAlias($modelClassname).'.status_id ';
    38. 

  38. 			$this->joinedTables[] = 'model_statuses';
    39. 

  39. 		}
    40. 

  40. 		$this->view->stylesheets = array('/styles/style.css');
    41. 

  41. 		$this->view->javascripts = array('/scripts/standard.js', '/scripts/jquery-1.4.1.min.js');
    42. 

  42. 		$this->view->currentTab = strtolower(substr($modelClassname, 0, 1)).substr($modelClassname, 1);
    43. 

  43. 		
    44. 

  44. 	}
    45. 

  45. 

  46. 	public function indexAction() {
    47. 

  47. 		$this->listAction();
    48. 

  48. 	}
    49. 

  49. 

  50. 	public function listAction() {
    51. 

  51. 		$this->viewPath = 'model/list';
    52. 

  52. 		$navigationItem = $this->application->getNavigationItem(strtolower(substr($this->modelClassname, 0, 1)).substr($this->modelClassname, 1));
    53. 

  53. 		$this->view->tabTitle = $navigationItem['label'];
    54. 

  54. 		if (isset($navigationItem['description'])) {
    55. 

  55. 			$this->view->tabDescription = $navigationItem['description'];
    56. 

  56. 		} else {
    57. 

  57. 			$this->view->tabDescription = '';
    58. 

  58. 		}
    59. 

  59. 		$filterVars = $this->processListFilterRequest();
    60. 

  60. 		$this->view->listState = $this->buildListState($filterVars);
    61. 

  61. 		$this->view->filter = $this->buildFilter($filterVars);
    62. 

  62. 		$grid = $this->buildGrid($filterVars, $this->model);
    63. 

  63. 		$this->view->grid = $grid;
    64. 

  64. 		$this->view->data = $this->getData($grid, $filterVars, $this->model);
    65. 

  65. 		$this->view->actions = $this->getInitialActions();
    66. 

  66. 	}
    67. 

  67. 

  68. 	public function viewAction($actionName = 'View') {
    69. 

  69. 		$this->viewPath = 'model/view';
    70. 

  70. 		$id = (isset($this->request->variables['id']) ? $this->request->id : (count($this->request->numeric) > 0 && isset($this->request->numeric[0]) ? $this->request->numeric[0] : null));
    71. 

  71. 		$filterVars = $this->processListFilterRequest();
    72. 

  72. 		$modelClassname = $this->modelClassname;
    73. 

  73. 		if (!is_null($id)) {
    74. 

  74. 			$model = new $modelClassname($id);
    75. 

  75. 		} else {
    76. 

  76. 			$model = new $modelClassname();
    77. 

  77. 		}
    78. 

  78. 

  79. 		$this->view->actionName = ucwords($actionName);
    80. 

  80. 		$this->view->entityName = ucwords(str_replace('_', ' ', Sodapop_Inflector::camelCapsToUnderscores($modelClassname)));
    81. 

  81. 		$this->view->controller = $this->modelClassname;
    82. 

  82. 		if ($this->request->isPost()) {
    83. 

  83. 			try {
    84. 

  84. 				$this->processPost($actionName, &$model);
    85. 

  85. 				$id = $model->id;
    86. 

  86. 				$this->view->successMessage = 'Your information was saved!';
    87. 

  87. 			} catch (Sodapop_Database_Exception $e) {
    88. 

  88. 				if (count($e->getErrors()) == 1) {
    89. 

  89. 					$this->view->errorMessage = $e->getMessage();
    90. 

  90. 				} else {
    91. 

  91. 					$this->view->errorMessage = 'The following errors have occurred:';
    92. 

  92. 					$this->view->errors = $e->getErrors();
    93. 

  93. 				}
    94. 

  94. 			}
    95. 

  95. 		}
    96. 

  96. 		$this->view->id = $id;
    97. 

  97. 		$form = $this->getModelForm(&$model);
    98. 

  98. 		$this->view->form = $form;
    99. 

  99. 		$actions = $this->getNextActions($model);
    100. 

  100. 		$this->view->renderedForm = $this->renderForm($form, '', count($actions) == 0);
    101. 

  101. 		$this->view->actions = $actions;
    102. 

  102. 	}
    103. 

  103. 

  104. 	protected function processListFilterRequest(){
    105. 

  105. 		$retval = array('numPerPage' => (isset($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($this->model), false)]) && isset($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($this->model), false)]['list_num_per_page']) ? $this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($this->model), false)]['list_num_per_page'] : 10), 'filters' => array(), 'startIndex' => 0, 'orderBy' => (isset($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($this->model), false)]) && isset($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($this->model), false)]['list_order_by']) ? $this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($this->model), false)]['list_order_by'] : 'id'), 'orderDirection' => 'ASC');
    106. 

  106. 		foreach($this->request->variables() as $key => $value) {
    107. 

  107. 			if (substr($key, 0, 7) == 'filter_') {
    108. 

  108. 				$keyName = substr($key, 7);
    109. 

  109. 				if ($keyName == 'numPerPage') {
    110. 

  110. 					$retval['numPerPage'] = $value;
    111. 

  111. 				} else if ($keyName == 'orderBy') {
    112. 

  112. 					$retval['orderBy'] = $value;
    113. 

  113. 				} else if ($keyName == 'orderDirection') {
    114. 

  114. 					$retval['orderDirection'] = $value;
    115. 

  115. 				} else if ($keyName == 'startIndex') {
    116. 

  116. 					$retval['startIndex'] = $value;
    117. 

  117. 				} else {
    118. 

  118. 					$retval['filters'][$keyName] = $value;
    119. 

  119. 				}
    120. 

  120. 			}
    121. 

  121. 		}
    122. 

  122. 		return $retval;
    123. 

  123. 	}
    124. 

  124. 

  125. 	protected function buildListState($filterVars) {
    126. 

  126. 		  $retval = array();
    127. 

  127. 		  $retval['sort'] = '&filter_startIndex=0&filter_numPerPage='.$filterVars['numPerPage'];
    128. 

  128. 		  $retval['nextPage'] = '&filter_startIndex='.($filterVars['startIndex'] + $filterVars['numPerPage']).'&filter_numPerPage='.$filterVars['numPerPage'].'&filter_orderBy='.$filterVars['orderBy'].'&filter_orderDirection='.$filterVars['orderDirection'];
    129. 

  129. 		  $retval['prevPage'] = '&filter_startIndex='.($filterVars['startIndex'] - $filterVars['numPerPage']).'&filter_numPerPage='.$filterVars['numPerPage'].'&filter_orderBy='.$filterVars['orderBy'].'&filter_orderDirection='.$filterVars['orderDirection'];
    130. 

  130. 		  $retval['viewItem'] = '?filter_startIndex='.($filterVars['startIndex'] - $filterVars['numPerPage']).'&filter_numPerPage='.$filterVars['numPerPage'].'&filter_orderBy='.$filterVars['orderBy'].'&filter_orderDirection='.$filterVars['orderDirection'];
    131. 

  131. 		  foreach($filterVars['filters'] as $key => $filter) {
    132. 

  132. 		  	$retval['sort'] .= '&filter_'.$key.'='.urlencode($filter);
    133. 

  133. 			$retval['nextPage'] .= '&filter_'.$key.'='.urlencode($filter);
    134. 

  134. 			$retval['prevPage'] .= '&filter_'.$key.'='.urlencode($filter);
    135. 

  135. 			$retval['viewItem'] .= '&filter_'.$key.'='.urlencode($filter);
    136. 

  136. 		  }
    137. 

  137. 		  $retval['filter'] = '';
    138. 

  138. 		  foreach($filterVars as $key => $filter) {
    139. 

  139. 		  	if ($key != 'filters') {
    140. 

  140. 			   $retval['filter'] .= '<input type="hidden" name="filter_'.$key.'" value="'.htmlentities($filter).'" />';
    141. 

  141. 			}
    142. 

  142. 		  } 
    143. 

  143. 		  return $retval;
    144. 

  144. 	}
    145. 

  145. 

  146. 	protected function buildFilter($filterVars) {
    147. 

  147. 		$retval = array('filters' => array(), 'buttonLabel' => (isset($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($this->model), false)]) && isset($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($this->model), false)]['list_filter_label']) ? $this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($this->model), false)]['list_filter_label'] : 'Update') );
    148. 

  148. 		if (isset($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($this->model), false)]) && isset($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($this->model), false)]['list_filters'])) {
    149. 

  149. 			// grab it from the models file
    150. 

  150. 			foreach ($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($this->model), false)]['list_filters'] as $filter) {
    151. 

  151. 				if (isset($filter['type']) && $filter['type'] == 'search') {
    152. 

  152. 					$retval['filters'][] = array('label' => 'Search', 'id'=> 'search', 'input' => 'text', 'default' => (isset($filterVars['filters']['search']) ? $filterVars['filters']['search'] : ''));
    153. 

  153. 				} else if (isset($filter['type']) && $filter['type'] == 'num_per_page') {
    154. 

  154. 					$retval['filters'][] = array('label' => '# Per Page', 'id'=> 'numPerPage', 'input' => 'select', 'options' => array('10' => '10', '20' => '20', '50' => '50', '100' => '100'), 'default' => $filterVars['numPerPage']);
    155. 

  155. 				} else if (isset($filter['field']) && $filter['field'] == 'status' && $this->model instanceof Sodapop_Database_Form_Abstract) {
    156. 

  156. 					$options = array();
    157. 

  157. 					if ($filter['include_all']) {
    158. 

  158. 						$options[''] = 'All';
    159. 

  159. 					}
    160. 

  160. 					foreach ($this->model->getFormStatuses() as $statusId => $status) {
    161. 

  161. 						$options[$statusId] = $status['display_adjective'];
    162. 

  162. 					}
    163. 

  163. 					$retval['filters'][] = array('label' => 'Status', 'id' => 'statusId', 'input' => 'select', 'options' => $options, 'default' => (isset($filterVars['filters']['statusId']) ? $filterVars['filters']['statusId'] : ''));
    164. 

  164. 				} else {
    165. 

  165. 					if (isset($filter['field'])) {
    166. 

  166. 						$fieldDef = $this->model->getFieldDefinition(Sodapop_Inflector::underscoresToCamelCaps($filter['field']));
    167. 

  167. 						if ($fieldDef) {
    168. 

  168. 							if ($fieldDef['type_name'] == 'REFERENCE' && (!$filter['type'] || $filter['type'] == 'select') && $filter['select_field'] && ($this->user->hasTablePermission($fieldDef['ref_table_name'], 'SELECT') || $this->user->hasFormPermission($fieldDef['ref_table_name'], false, 'VIEW'))) {
    169. 

  169. 								$options = array();
    170. 

  170. 								if ($filter['include_all']) {
    171. 

  171. 									$options[''] = 'All';
    172. 

  172. 								}
    173. 

  173. 								$result = $this->user->connection->runQuery("SELECT id, ".$filter['select_field']." FROM ".$fieldDef['ref_table_name']." ORDER BY ".$filter['select_field']." ASC");
    174. 

  174. 								foreach ($result['data'] as $row) {
    175. 

  175. 									$options[$row[0]] = $row[1];
    176. 

  176. 								}
    177. 

  177. 								$retval['filters'][] = array('label' => $fieldDef['display_name'], 'id' => Sodapop_Inflector::underscoresToCamelCaps($filter['field']), 'input' => 'select', 'options' => $options, 'default' => ($filterVars['filters'][Sodapop_Inflector::underscoresToCamelCaps($filter['field'])] ? $filterVars['filters'][Sodapop_Inflector::underscoresToCamelCaps($filter['field'])] : ''));
    178. 

  178. 							} else {
    179. 

  179. 								$retval['filters'][] = array('label' => $fieldDef['display_name'], 'id' => Sodapop_Inflector::underscoresToCamelCaps($filter['field']), 'input' => 'text', 'default' => ($filterVars['filters'][Sodapop_Inflector::underscoresToCamelCaps($filter['field'])] ? $filterVars['filters'][Sodapop_Inflector::underscoresToCamelCaps($filter['field'])] : ''));
    180. 

  180. 							}
    181. 

  181. 						}
    182. 

  182. 					}
    183. 

  183. 				}
    184. 

  184. 			}
    185. 

  185. 		} else {
    186. 

  186. 			$fieldDefs = $this->model->getFieldDefinitions();
    187. 

  187. 			foreach($fieldDefs as $fieldDef) {
    188. 

  188. 				if ($fieldDef['type_name'] == 'REFERENCE' && ($this->user->hasTablePermission($fieldDef['ref_table_name'], 'SELECT') || $this->user->hasFormPermission($fieldDef['ref_table_name'], false, 'VIEW'))) {
    189. 

  189. 					$options = array();
    190. 

  190. 					$options[''] = 'All';
    191. 

  191. 					$result = $this->user->connection->runQuery("SELECT * FROM ".strtolower($fieldDef['ref_table_name'])." ORDER BY id ASC");
    192. 

  192. 					for ($i = 0; $i < count($result['columns']); $i++) {
    193. 

  193. 						if ($result['columns'][$i]['columnname'] == 'id') {
    194. 

  194. 							break;
    195. 

  195. 						}
    196. 

  196. 					}
    197. 

  197. 					foreach ($result['data'] as $row) {
    198. 

  198. 						$options[$row[$i]] = $row[($i == 0 ? 1 : 0)];
    199. 

  199. 					}
    200. 

  200. 					$retval['filters'][] = array('label' => $fieldDef['display_name'], 'id' => Sodapop_Inflector::underscoresToCamelCaps(strtolower(isset($fieldDef['field_name']) ? $fieldDef['field_name'] : $fieldDef['column_name']), true, false), 'input' => 'select', 'options' => $options, 'default' => (isset($filterVars['filters'][Sodapop_Inflector::underscoresToCamelCaps(strtolower(isset($fieldDef['field_name']) ? $fieldDef['field_name'] : $fieldDef['column_name']), true, false)]) ? $filterVars['filters'][Sodapop_Inflector::underscoresToCamelCaps(strtolower(isset($fieldDef['field_name']) ? $fieldDef['field_name'] : $fieldDef['column_name']), true, false)] : ''));
    201. 

  201. 				}
    202. 

  202. 			}
    203. 

  203. 			$retval['filters'][] = array('label' => 'Search', 'id'=> 'search', 'input' => 'text', 'default' => (isset($filterVars['filters']['search']) ? $filterVars['filters']['search'] : ''));
    204. 

  204. 			$retval['filters'][] = array('label' => '# Per Page', 'id'=> 'numPerPage', 'input' => 'select', 'options' => array('10' => '10', '20' => '20', '50' => '50', '100' => '100'), 'default' => $filterVars['numPerPage']);
    205. 

  205. 		}
    206. 

  206. 		return $retval;
    207. 

  207. 	}
    208. 

  208. 

  209. 	protected function buildGrid($filterVars, $model) {
    210. 

  210. 		$retval = array('headings' =>array());
    211. 

  211. 		if (isset($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($model), false)]) && isset($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($model), false)]['list_fields'])) {
    212. 

  212. 			$retval['headings'] = $this->processModelList($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($model), false)]['list_fields'], $filterVars, $model);
    213. 

  213. 		} else {
    214. 

  214. 			$modelList = array(array('name' => 'id', 'link' => '/'.get_class($model).'/view/:id'));
    215. 

  215. 			$fields = $model->getFieldDefinitions();
    216. 

  216. 			foreach ($fields as $field) {
    217. 

  217. 				if (((isset($field['column_name']) && strtolower($field['column_name']) != 'id') || (isset($field['field_name']) && strtolower($field['field_name']) != 'id')) && strtolower($field['type_name']) != 'reference') {
    218. 

  218. 					$modelList[] = array('name' => isset($field['column_name']) ? strtolower($field['column_name']) : strtolower($field['field_name']));
    219. 

  219. 				}
    220. 

  220. 			}
    221. 

  221. 			if ($model instanceof Sodapop_Database_Form_Abstract) {
    222. 

  222. 				$modelList[] = array('name' => 'status');
    223. 

  223. 			}
    224. 

  224. 			$retval['headings'] = $this->processModelList($modelList, $filterVars, $model);
    225. 

  225. 		}
    226. 

  226. 		return $retval;
    227. 

  227. 	}
    228. 

  228. 

  229. 	protected function processModelList($modelList, $filterVars, $model) {
    230. 

  230. 		$retval = array();
    231. 

  231. 		foreach ($modelList as $listField) {
    232. 

  232. 			$heading = array('id' => $listField['name']);
    233. 

  233. 			if ($model instanceof Sodapop_Database_Form_Abstract && strtolower($listField['name']) == 'status') {
    234. 

  234. 				$heading['label'] = (isset($listField['label']) ? $listField['label'] : 'Status');
    235. 

  235. 				if (!array_key_exists('model_statuses.adj_display_name', $this->selectedColumns)) {
    236. 

  236. 					$this->listSelectClause .= ($this->listSelectClause == '' ? ' ' : ', ').'model_statuses.adj_display_name AS '.$this->createAlias(get_class($model)).'_status';
    237. 

  237. 					$this->selectedColumns['model_statuses.adj_display_name'] = 'STRING';
    238. 

  238. 				}
    239. 

  239. 				$heading['sortField'] = $this->createAlias(get_class($model)).'_status';
    240. 

  240. 			} else {
    241. 

  241. 				$fieldDefinition = $model->getFieldDefinition(Sodapop_Inflector::underscoresToCamelCaps($listField['name'], true, false));
    242. 

  242. 				if (!is_null($fieldDefinition)) {
    243. 

  243. 					$heading['label'] = (isset($listField['label']) ? $listField['label'] : $fieldDefinition['display_name']);
    244. 

  244. 					$heading['printExpression'] = array(array('type' => 'field', 'field' => $this->createAlias(get_class($model)).'_'.$listField['name']));
    245. 

  245. 					$heading['sortField'] = $this->createAlias(get_class($model)).'_'.$listField['name'];
    246. 

  246. 					if (!array_key_exists($this->createAlias(get_class($model)).'.'.$listField['name'], $this->selectedColumns)) {
    247. 

  247. 						$this->listSelectClause .= ($this->listSelectClause == '' ? ' ' : ', ').$this->createAlias(get_class($model)).'.'.$listField['name'].' AS '.$this->createAlias(get_class($model)).'_'.$listField['name'];
    248. 

  248. 						$this->selectedColumns[$this->createAlias(get_class($model)).'.'.$listField['name']] = $fieldDefinition['type_name'];
    249. 

  249. 					}
    250. 

  250. 				} else {
    251. 

  251. 					$heading['label'] = (isset($listField['label']) ? $listField['label'] : 'Column '.(count($retval) + 1));
    252. 

  252. 					if (isset($listField['concat'])) {
    253. 

  253. 						$heading['printExpression'] = array();
    254. 

  254. 						$concatParts = explode('+', $listField['concat']);
    255. 

  255. 						foreach ($concatParts as $concatPart) {
    256. 

  256. 							$concatPart = trim($concatPart);
    257. 

  257. 							if (substr($concatPart, 0, 1) == "'" && substr($concatPart, strlen($concatPart) - 2, 1) == "'") {
    258. 

  258. 								$heading['printExpression'][] = array('type' => 'text', 'text' => substr($concatPart,1, strlen($concatPart) - 2));
    259. 

  259. 							} else {
    260. 

  260. 								$moreParts = explode('.', $concatPart);
    261. 

  261. 								$partDefinition = $model->getFieldDefinition(Sodapop_Inflector::underscoresToCamelCaps($moreParts[0], true, false));
    262. 

  262. 								if (!is_null($partDefinition)) {
    263. 

  263. 									if (!isset($moreParts[1]) || $partDefinition['type_name'] != 'REFERENCE') {
    264. 

  264. 										$columnName = trim($moreParts[0]);
    265. 

  265. 										if (!array_key_exists($this->createAlias(get_class($model)).'.'.$columnName, $this->selectedColumns)) {
    266. 

  266. 											$this->listSelectClause .= ($this->listSelectClause == '' ? ' ' : ', ').$this->createAlias(get_class($model)).'.'.$columnName.' AS '.$this->createAlias(get_class($model)).'_'.$columnName;
    267. 

  267. 											$this->selectedColumns[$this->createAlias(get_class($model)).'.'.$columnName] = $partDefinition['type_name'];
    268. 

  268. 										}
    269. 

  269. 										$heading['printExpression'][] = array('type' => 'field', 'field' => Sodapop_Inflector::camelCapsToUnderscores(get_class($model), true).'_'.$columnName);
    270. 

  270. 										if (!isset($heading['sortField'])) {
    271. 

  271. 											$heading['sortField'] = $this->createAlias(get_class($model)).'_'.$columnName;
    272. 

  272. 										}
    273. 

  273. 									} else {
    274. 

  274. 										$childTableClassname = Sodapop_Inflector::underscoresToCamelCaps(strtolower($partDefinition['ref_table_name']), false);
    275. 

  275. 										$childObject = new $childTableClassname();
    276. 

  276. 										$childPartsDefinition = $childObject->getFieldDefinition(Sodapop_Inflector::underscoresToCamelCaps($moreParts[1], true, false));
    277. 

  277. 										if (!is_null($childPartsDefinition)) {
    278. 

  278. 											if (!array_key_exists($moreParts[0].'.'.$moreParts[1], $this->selectedColumns)) {
    279. 

  279. 												$this->listSelectClause .= ($this->listSelectClause == '' ? ' ' : ', ').$moreParts[0].'.'.$moreParts[1].' AS '.$moreParts[0].'_'.$moreParts[1];
    280. 

  280. 												$this->selectedColumns[$moreParts[0].'.'.$moreParts[1]] = $childPartsDefinition['type_name'];
    281. 

  281. 											}
    282. 

  282. 											if (!in_array($moreParts[0], $this->joinedTables)) {
    283. 

  283. 												$this->listFromClause .= ' LEFT OUTER JOIN '.strtolower($partDefinition['ref_table_name']).' AS '.$moreParts[0].' ON '.$moreParts[0].'.id = '.$this->createAlias(get_class($model)).'.'.$moreParts[0].' ';
    284. 

  284. 												$this->joinedTables[] = $moreParts[0];
    285. 

  285. 											}
    286. 

  286. 											$heading['printExpression'][] = array('type' => 'field', 'field' => $moreParts[0].'_'.$moreParts[1]);
    287. 

  287. 											if (!isset($heading['sortField'])) {
    288. 

  288. 												$heading['sortField'] = $moreParts[0].'_'.$moreParts[1];
    289. 

  289. 											}
    290. 

  290. 										}
    291. 

  291. 									}
    292. 

  292. 								}
    293. 

  293. 

  294. 							}
    295. 

  295. 						}
    296. 

  296. 					}
    297. 

  297. 					if (isset($listField['sort'])) {
    298. 

  298. 						$heading['sortField'] = str_replace('.', '_', $listField['sort']);
    299. 

  299. 					}
    300. 

  300. 				}
    301. 

  301. 			}
    302. 

  302. 			if (isset($listField['link']) && $listField['link']) {
    303. 

  303. 				$heading['link'] = $this->processLink($listField['link'], $model);
    304. 

  304. 			}
    305. 

  305. 			$heading['orderBy'] = $filterVars['orderBy'] == $heading['sortField'];
    306. 

  306. 			$heading['orderDirection'] = $filterVars['orderDirection'];
    307. 

  307. 			$retval[] = $heading;
    308. 

  308. 		}
    309. 

  309. 		return $retval;
    310. 

  310. 	}
    311. 

  311. 

  312. 	protected function processLink($link, $model) {
    313. 

  313. 		$retval = array();
    314. 

  314. 		$currentTextNode = '';
    315. 

  315. 		$linkParts = explode('/', $link);
    316. 

  316. 		foreach($linkParts as $part) {
    317. 

  317. 			$part = trim($part);
    318. 

  318. 			if (substr($part, 0, 1) == ':') {
    319. 

  319. 				$retval[] = array('type' => 'text', 'text' => $currentTextNode.'/');
    320. 

  320. 				$currentTextNode = '';
    321. 

  321. 				$fieldParts = explode('.', substr($part, 1));
    322. 

  322. 				$partDefinition = $model->getFieldDefinition(Sodapop_Inflector::underscoresToCamelCaps($fieldParts[0], true, false));
    323. 

  323. 				if (!is_null($partDefinition)) {
    324. 

  324. 					if (!isset($fieldParts[1]) || $partDefinition['type_name'] != 'REFERENCE') {
    325. 

  325. 						$columnName = trim($fieldParts[0]);
    326. 

  326. 						if (!array_key_exists($this->createAlias(get_class($model)).'.'.$columnName, $this->selectedColumns)) {
    327. 

  327. 							$this->listSelectClause .= ($this->listSelectClause == '' ? ' ' : ', ').$this->createAlias(get_class($model)).'.'.$columnName.' AS '.$this->createAlias(get_class($model)).'_'.$columnName;
    328. 

  328. 							$this->selectedColumns[$this->createAlias(get_class($model)).'.'.$columnName] = $partDefinition['type_name'];
    329. 

  329. 						}
    330. 

  330. 						$retval[] = array('type' => 'field', 'field' => $this->createAlias(get_class($model)).'_'.$columnName);
    331. 

  331. 					} else {
    332. 

  332. 						$childTableClassname = Sodapop_Inflector::underscoresToCamelCaps(strtolower($partDefinition['ref_table_name']), false);
    333. 

  333. 						$childObject = new $childTableClassname();
    334. 

  334. 						$childPartsDefinition = $childObject->getFieldDefinition(Sodapop_Inflector::underscoresToCamelCaps($fieldParts[1], true, false));
    335. 

  335. 						if (!is_null($childPartsDefinition)) {
    336. 

  336. 							if (!array_key_exists($fieldParts[0].'.'.$fieldParts[1], $this->selectedColumns)) {
    337. 

  337. 								$this->listSelectClause .= ($this->listSelectClause == '' ? ' ' : ', ').$fieldParts[0].'.'.$fieldParts[1].' AS '.$fieldParts[0].'_'.$fieldParts[1];
    338. 

  338. 								$this->selectedColumns[$fieldParts[0].'.'.$fieldParts[1]] = $childPartsDefinition['type_name'];
    339. 

  339. 							}
    340. 

  340. 							if (!in_array($fieldParts[0], $this->joinedTables)) {
    341. 

  341. 								$this->listFromClause .= ' LEFT OUTER JOIN '.strtolower($partDefinition['ref_table_name']).' AS '.$fieldParts[0].' ON '.$fieldParts[0].'.id = '.$this->createAlias(get_class($model)).'.'.$fieldParts[0].' ';
    342. 

  342. 								$this->joinedTables[] = $fieldParts[0];
    343. 

  343. 							}
    344. 

  344. 							$retval[] = array('type' => 'field', 'field' => $fieldParts[0].'_'.$fieldParts[1]);
    345. 

  345. 						}
    346. 

  346. 					}
    347. 

  347. 				}
    348. 

  348. 			} else {
    349. 

  349. 				$currentTextNode .= '/'.$part;
    350. 

  350. 			}
    351. 

  351. 		}
    352. 

  352. 		if ($currentTextNode != '') {
    353. 

  353. 			$retval[] = array('type' => 'text', 'text' => $currentTextNode);
    354. 

  354. 		}
    355. 

  355. 		return $retval;
    356. 

  356. 	}
    357. 

  357. 

  358. 	protected function getData($grid, $filterVars, $model, $parentTableId = null) {
    359. 

  359. 		$whereClause = '';
    360. 

  360. 		if (!is_null($parentTableId)) {
    361. 

  361. 			$whereClause .= ' WHERE '.$this->createAlias(get_class($model)).".parent_table_id = '".$parentTableId."' ";
    362. 

  362. 		}
    363. 

  363. 		if (count($filterVars['filters']) > 0) {
    364. 

  364. 			foreach($filterVars['filters'] as $key => $filter){
    365. 

  365. 				if (trim($filter) != '') {
    366. 

  366. 					if ($whereClause == '') {
    367. 

  367. 						$whereClause .= ' WHERE ';
    368. 

  368. 					} else {
    369. 

  369. 						$whereClause .= ' AND ';
    370. 

  370. 					}
    371. 

  371. 					if ($key == 'search') {
    372. 

  372. 						// add each field in the select clause, then add each field from this model
    373. 

  373. 						$search = '( ';
    374. 

  374. 						foreach ($this->selectedColumns as $column => $typeName) {
    375. 

  375. 							if ($typeName != 'INTEGER' && $typeName != 'FLOAT' && $typeName != 'REFERENCE' && $typeName != 'TIMESTAMP') {
    376. 

  376. 								if ($search != '( ') {
    377. 

  377. 									$search .= ' OR ';
    378. 

  378. 								}
    379. 

  379. 								$search .= $column ." LIKE '%".str_replace("'", "''", $filter)."%' ";
    380. 

  380. 							} else if (is_numeric($filter) && ($typeName == 'INTEGER' || $typeName == 'FLOAT' || $typeName == 'REFERENCE')) {
    381. 

  381. 								if ($search != '( ') {
    382. 

  382. 									$search .= ' OR ';
    383. 

  383. 								}
    384. 

  384. 								$search .= $column ." = '".$filter."' ";
    385. 

  385. 							}
    386. 

  386. 						}
    387. 

  387. 						foreach ($model->getFieldDefinitions() as $fieldName => $fieldDefinition) {
    388. 

  388. 							$typeName = $fieldDefinition['type_name'];
    389. 

  389. 							if (!in_array(Sodapop_Inflector::camelCapsToUnderscores(get_class($model)).'.'.Sodapop_Inflector::camelCapsToUnderscores($fieldName), $this->selectedColumns)) {
    390. 

  390. 								if ($typeName != 'INTEGER' && $typeName != 'FLOAT' && $typeName != 'REFERENCE' && $typeName != 'TIMESTAMP') {
    391. 

  391. 									if ($search != '( ') {
    392. 

  392. 										$search .= ' OR ';
    393. 

  393. 									}
    394. 

  394. 									$search .= Sodapop_Inflector::camelCapsToUnderscores(get_class($model)).'.'.Sodapop_Inflector::camelCapsToUnderscores($fieldName) ." LIKE '%".str_replace("'", "''", $filter)."%' ";
    395. 

  395. 								} else if (is_numeric($filter) && ($typeName == 'INTEGER' || $typeName == 'FLOAT' || $typeName == 'REFERENCE')) {
    396. 

  396. 									if ($search != '( ') {
    397. 

  397. 										$search .= ' OR ';
    398. 

  398. 									}
    399. 

  399. 									$search .= $column ." = '".$filter."' ";
    400. 

  400. 								}
    401. 

  401. 							}
    402. 

  402. 						}
    403. 

  403. 						$whereClause .= $search . ') ';
    404. 

  404. 					} else {
    405. 

  405. 						$whereClause .= Sodapop_Inflector::camelCapsToUnderscores($key)." = '".str_replace("'", "''", $filter)."' ";
    406. 

  406. 					}
    407. 

  407. 				}
    408. 

  408. 				// potentially reset
    409. 

  409. 				if ($whereClause == ' WHERE ') {
    410. 

  410. 					$whereClause = '';
    411. 

  411. 				}
    412. 

  412. 			}
    413. 

  413. 		}
    414. 

  414. 

  415. 		$retval = array('totalRows' => 0, 'numPerPage' => $filterVars['numPerPage'], 'startIndex' => $filterVars['startIndex'], 'data' => array());
    416. 

  416. 		$countSelectStatement = 'SELECT count('.$this->createAlias(get_class($model)).'.id) FROM '.$this->listFromClause.' '.$whereClause;
    417. 

  417. 		$countResult = $this->user->connection->runQuery($countSelectStatement);
    418. 

  418. 		foreach ($countResult['data'] as $row) {
    419. 

  419. 			$retval['totalRows'] = $row[0];
    420. 

  420. 		}
    421. 

  421. 

  422. 		$orderBy = ' ORDER BY '.$this->createAlias(get_class($model)).'.id '.$filterVars['orderDirection'];
    423. 

  423. 		foreach ($grid['headings'] as $gridValue) {
    424. 

  424. 			if ($gridValue['id'] == $filterVars['orderBy']) {
    425. 

  425. 				$orderBy = ' ORDER BY '.$gridValue['sortField'].' '.$filterVars['orderDirection'];
    426. 

  426. 				break;
    427. 

  427. 			}
    428. 

  428. 		}
    429. 

  429. 

  430. 		$selectStatement = 'SELECT TOP '.$filterVars['numPerPage'].' STARTING AT '.$filterVars['startIndex'].' '.$this->listSelectClause.' FROM '.$this->listFromClause .' '.$whereClause.' '.$orderBy;
    431. 

  431. 		$result = $this->user->connection->runQUery($selectStatement);
    432. 

  432. 		$data = array();
    433. 

  433. 		foreach ($result['data'] as $row) {
    434. 

  434. 			$dataRow = array();
    435. 

  435. 			for($i = 0; $i < count($result['columns']); $i++) {
    436. 

  436. 				$dataRow[$result['columns'][$i]['columnname']] = $row[$i];
    437. 

  437. 			}
    438. 

  438. 			$data[] = $dataRow;
    439. 

  439. 		}
    440. 

  440. 		$retval['data'] = $data;
    441. 

  441. 		$retval['emptyRows'] = $retval['numPerPage'] - count($data);
    442. 

  442. 		return $retval;
    443. 

  443. 	}
    444. 

  444. 

  445. 	protected function getModelForm($model) {
    446. 

  446. 		$retval = array('groups' => array(), 'tabs' => array());
    447. 

  447. 		if (isset($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($model), false)]) && isset($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($model), false)]['fields'])) {
    448. 

  448. 			foreach ($this->application->models[Sodapop_Inflector::camelCapsToUnderscores(get_class($model), false)]['fields'] as $groupTabItem) {
    449. 

  449. 				if (isset($groupTabItem['group'])) {
    450. 

  450. 					$retval['groups'][] = array('label' => $groupTabItem['group'], 'showFieldset' => (isset($groupTabItem['fieldset']) && $groupTabItem['fieldset'] == 'false' ? false : true), 'fields' => $this->parseGroupInfo(isset($groupTabItem['fields']) ? $groupTabItem['fields'] : array(), $model));
    451. 

  451. 				} else if (isset($groupTabItem['tab'])) {
    452. 

  452. 					$retval['tabs'][$groupTabItem['tab']] = array();
    453. 

  453. 					foreach ($groupTabItem['groups'] as $groupItem) {
    454. 

  454. 						$retval['tabs'][$groupTabItem['tab']][$groupItem['group']] = $this->parseGroupInfo(isset($groupItem['fields']) ? $groupItem['fields'] : array(), $model);
    455. 

  455. 					}
    456. 

  456. 				}
    457. 

  457. 			}
    458. 

  458. 		} else {
    459. 

  459. 			$retval['groups'][] = array('label' => 'Information', 'showFieldset' => true, 'fields' => array());
    460. 

  460. 			$fieldDefinitions = $model->getFieldDefinitions();
    461. 

  461. 			$invalidFields = array('id', 'modDate', 'createDate', 'modUserName', 'createUserName', 'activeFlag');
    462. 

  462. 			foreach ($fieldDefinitions as $fieldName => $fieldDefinition) {
    463. 

  463. 				if (!in_array($fieldName,$invalidFields )) {
    464. 

  464. 					$fieldArray = array();
    465. 

  465. 					$fieldArray['id'] = $this->createAlias(get_class($model)).'_'.strtolower($fieldDefinition['column_name']);
    466. 

  466. 					$fieldArray['label'] = $fieldDefinition['display_name'];
    467. 

  467. 					$fieldArray['arrayFlag'] = $fieldDefinition['array_flag'] == '1';
    468. 

  468. 					if ($fieldDefinition['type_name'] == 'REFERENCE') {
    469. 

  469. 						$referenceModelClassname = Sodapop_Inflector::underscoresToCamelCaps(strtolower($fieldDefinition['ref_table_name']), false);
    470. 

  470. 						$referenceModel = new $referenceModeClassName();
    471. 

  471. 						$referenceFieldDefinitions = $referenceModel->getFieldDefinitions();
    472. 

  472. 						$fieldArray['type'] = 'select';
    473. 

  473. 						$optionQuery = (isset($field['query']) ? $field['query'] : 'SELECT '.(isset($field['select']) ? $field['select'] : 'id, '.strtolower($referenceFieldDefinitions['column_name'])).' FROM '.strtolower($fieldDefinition['ref_table_name']).' '.(isset($field['where']) ? 'WHERE '.$field['where'] : '').' '.(isset($field['order']) ? 'ORDER BY '.$field['order'] : ''));
    474. 

  474. 						$optionsResult = $this->user->connection->runQuery($optionQuery);
    475. 

  475. 						$fieldArray['options'] = array();
    476. 

  476. 						foreach ($optionsResult['data'] as $optionRow) {
    477. 

  477. 							$fieldArray['options'][$optionRow[0]] = $optionRow[1];
    478. 

  478. 						}
    479. 

  479. 						$fieldArray['default'] = $model->$fieldName->id ? $model->$fieldName->id : $fieldDefinition['default_value'];
    480. 

  480. 

  481. 					} else {
    482. 

  482. 						$fieldArray['type'] = $fieldDefinition['type_name'];
    483. 

  483. 						$fieldArray['default'] = $model->$fieldName ? $model->$fieldName : $fieldDefinition['default_value'];
    484. 

  484. 

  485. 					}
    486. 

  486. 					$retval['groups'][0]['fields'][] = $fieldArray;
    487. 

  487. 				}
    488. 

  488. 			}
    489. 

  489. 		}
    490. 

  490. 		//echo 'Main :'.var_export($retval);
    491. 

  491. 		return $retval;
    492. 

  492. 	}
    493. 

  493. 

  494. 	protected function parseGroupInfo($fields, $model) {
    495. 

  495. 		$retval = array();
    496. 

  496. 		if ($fields) {
    497. 

  497. 			foreach ($fields as $field) {
    498. 

  498. 				$fieldArray = array();
    499. 

  499. 				if (isset($field['subtable'])) {
    500. 

  500. 					$subtableModelClassname = Sodapop_Inflector::underscoresToCamelCaps($field['subtable'], false);
    501. 

  501. 					$subtableModel = new $subtableModelClassname;
    502. 

  502. 					$filterVars = array('numPerPage' => 1000, 'filters' => array(), 'startIndex' => 0, 'orderBy' => (isset($this->application->models[$field['subtable']]) && isset($this->application->models[$field['subtable']]['list_order_by']) ? $this->application->models[$field['subtable']]['list_order_by'] : 'id'), 'orderDirection' => 'ASC');
    503. 

  503. 

  504. 					$fieldArray['subtable'] = true;
    505. 

  505. 					$fieldArray['grid'] = $this->buildGrid($filterVars, $subtableModel);
    506. 

  506. 					$fieldArray['data'] = $this->getData($fieldArray['grid'], $filterVars, $subtableModel, $model->id);
    507. 

  507. 				} else {
    508. 

  508. 					$fieldName = Sodapop_Inflector::underscoresToCamelCaps($field['name'], true, false);
    509. 

  509. 					$fieldDefinition = $model->getFieldDefinition($fieldName);
    510. 

  510. 					$fieldArray['id'] = $this->createAlias(get_class($model)).'_'.$field['name'];
    511. 

  511. 					$fieldArray['subtable'] = false;
    512. 

  512. 					$fieldArray['label'] = isset($field['label']) ? $field['label'] : $fieldDefinition['display_name'];
    513. 

  513. 					$fieldArray['arrayFlag'] = $fieldDefinition['array_flag'] == '1';
    514. 

  514. 					if ($fieldDefinition['type_name'] == 'REFERENCE') {
    515. 

  515. 						$referenceModelClassname = Sodapop_Inflector::underscoresToCamelCaps(strtolower($fieldDefinition['ref_table_name']), false);
    516. 

  516. 						$referenceModel = new $referenceModelClassname(isset($model->$fieldName->id) ? $model->$fieldName->id : $fieldDefinition['default_value']);
    517. 

  517. 						if ($field['visualization'] == 'editor') {
    518. 

  518. 							$fieldArray['type'] = 'form';
    519. 

  519. 							$fieldArray['form'] = $this->getModelForm($referenceModel);
    520. 

  520. 						} else {
    521. 

  521. 							$referenceFieldDefinitions = $referenceModel->getFieldDefinitions();
    522. 

  522. 							$fieldArray['type'] = 'select';
    523. 

  523. 							$optionQuery = (isset($field['query']) ? $field['query'] : 'SELECT '.(isset($field['select']) ? $field['select'] : 'id, '.strtolower($referenceFieldDefinitions['column_name'])).' FROM '.strtolower($fieldDefinition['ref_table_name']).' '.(isset($field['where']) ? 'WHERE '.$field['where'] : '').' '.(isset($field['order']) ? 'ORDER BY '.$field['order'] : ''));
    524. 

  524. 							$optionsResult = $this->user->connection->runQuery($optionQuery);
    525. 

  525. 							$fieldArray['options'] = array();
    526. 

  526. 							foreach ($optionsResult['data'] as $optionRow) {
    527. 

  527. 								$fieldArray['options'][$optionRow[0]] = $optionRow[1];
    528. 

  528. 							}
    529. 

  529. 						}
    530. 

  530. 						$fieldArray['default'] = isset($model->$fieldName->id) ? $model->$fieldName->id : $fieldDefinition['default_value'];
    531. 

  531. 					} else {
    532. 

  532. 						$fieldArray['type'] = $fieldDefinition['type_name'];
    533. 

  533. 						$fieldArray['default'] = $model->$fieldName ? $model->$fieldName : $fieldDefinition['default_value'];
    534. 

  534. 					
    535. 

  535. 					}
    536. 

  536. 				}
    537. 

  537. 				$retval[] = $fieldArray;
    538. 

  538. 			}
    539. 

  539. 		}
    540. 

  540. 		return $retval;
    541. 

  541. 	}
    542. 

  542. 

  543. 	protected function processPost($actionName, $model) {
    544. 

  544. 		$fieldDefinitions = $model->getFieldDefinitions();
    545. 

  545. 		$invalidFields = array('id', 'modDate', 'createDate', 'modUserName', 'createUserName', 'activeFlag');
    546. 

  546. 		foreach ($fieldDefinitions as $fieldName => $fieldDefinition) {
    547. 

  547. 			if (!in_array($fieldName,$invalidFields)) {
    548. 

  548. 				if ($fieldDefinition['type_name'] != 'REFERENCE') {
    549. 

  549. 					if (isset($this->request->variables[$this->createAlias(get_class($model)).'_'.strtolower($fieldDefinition['column_name'])])) {
    550. 

  550. 						$model->$fieldName = $this->request->variables[$this->createAlias(get_class($model)).'_'.strtolower($fieldDefinition['column_name'])];
    551. 

  551. 					}
    552. 

  552. 				} else {
    553. 

  553. 					$referenceModelClassname = Sodapop_Inflector::underscoresToCamelCaps(strtolower($fieldDefinition['ref_table_name']), false);
    554. 

  554. 					$referenceColumnPrefix = $this->createAlias(get_class($model)).'_'.strtolower($fieldDefinition['column_name']);
    555. 

  555. 					if (trim($this->request->variables[$this->createAlias(get_class($model)).'_'.strtolower($fieldDefinition['column_name'])]) != '') {
    556. 

  556. 						$referenceModel = new $referenceModelClassname($this->request->variables[$referenceColumnPrefix]);
    557. 

  557. 						$referenceAction = 'update';
    558. 

  558. 					} else {
    559. 

  559. 						$referenceModel = new $referenceModelClassname();
    560. 

  560. 						$referenceAction = 'insert';
    561. 

  561. 					}
    562. 

  562. 					$referenceFieldDefinitions = $referenceModel->getFieldDefinitions();
    563. 

  563. 					foreach ($referenceFieldDefinitions as $referenceFieldName => $referenceFieldDefinition) {
    564. 

  564. 						if (isset($this->request->variables[$referenceColumnPrefix.'_'.$this->createAlias(get_class($referenceModel)).'_'.strtolower($referenceFieldDefinition['column_name'])]) && !in_array($referenceFieldName,$invalidFields)) {
    565. 

  565. 							if ($referenceFieldDefinition['type_name'] != 'REFERENCE') {
    566. 

  566. 								$referenceModel->$referenceFieldName = $this->request->variables[$referenceColumnPrefix.'_'.$this->createAlias(get_class($referenceModel)).'_'.strtolower($referenceFieldDefinition['column_name'])];
    567. 

  567. 							} else {
    568. 

  568. 								$referenceReferenceModelClassname = Sodapop_Inflector::underscoresToCamelCaps(strtolower($referenceFieldDefinition['ref_table_name']), false);
    569. 

  569. 								$referenceModel->$referenceFieldName = new $referenceReferenceModelClassname($this->request->variables[$referenceColumnPrefix.'_'.$this->createAlias(get_class($referenceModel)).'_'.strtolower($referenceFieldDefinition['column_name'])]);
    570. 

  570. 							}
    571. 

  571. 						}
    572. 

  572. 					}
    573. 

  573. 					$referenceModel->$referenceAction();
    574. 

  574. 					$model->$fieldName = $referenceModel;
    575. 

  575. 				}
    576. 

  576. 			}
    577. 

  577. 		}
    578. 

  578. 		$model->$actionName();
    579. 

  579. 	}
    580. 

  580. 

  581. 	protected function renderForm($form, $namespace = '', $readonly = false) {
    582. 

  582. 		$retval = '';
    583. 

  583. 		foreach ($form['groups'] as $group) {
    584. 

  584. 			$retval .= $this->renderFormGroup($group, count($form['groups']) == 1 ? false : true, $namespace, $readonly);
    585. 

  585. 		}
    586. 

  586. 		foreach ($form['tabs'] as $tab) {
    587. 

  587. 			
    588. 

  588. 		}
    589. 

  589. 		return $retval;
    590. 

  590. 	}
    591. 

  591. 

  592. 	protected function renderFormGroup($group, $showFieldset = true, $namespace = '', $readonly = false) {
    593. 

  593. 		$retval = '';
    594. 

  594. 		$retval .= '<fieldgroup label="'.htmlentities($group['label']).'" border="'.($showFieldset ? 'true' : 'false').'">';
    595. 

  595. 		foreach ($group['fields'] as $field) {
    596. 

  596. 			if (isset($field['subtable']) && $field['subtable']) {
    597. 

  597. 				$retval .= $this->renderSubtable();
    598. 

  598. 			} else if ($field['type'] == 'form') {
    599. 

  599. 				$retval .= '<hidden id="'.$field['id'].'" value="'.$field['default'].'" />'.$this->renderForm($field['form'], $field['id'], $readonly);
    600. 

  600. 			} else {
    601. 

  601. 				$retval .= '<'.strtolower($field['type']).'input id="'.($namespace != '' ? $namespace.'_' : '').$field['id'].'" label="'.$field['label'].'" array="'.($field['arrayFlag'] ? 'true' : 'false').'" default="'.htmlentities(serialize($field['default'])).'" readonly="'.($readonly ? 'true' : 'false' ).'" />';
    602. 

  602. 			}
    603. 

  603. 		}
    604. 

  604. 		$retval .= '</fieldgroup>';
    605. 

  605. 		return $retval;
    606. 

  606. 	}
    607. 

  607. 

  608. 	protected function getInitialActions() {
    609. 

  609. 		$retval = array();
    610. 

  610. 		if ($this->model instanceof Sodapop_Database_Form_Abstract) {
    611. 

  611. 			foreach ($this->model->getFormStatuses() as $statusId => $status) {
    612. 

  612. 				if ($status['initial_flag'] == 1 && $this->user->hasFormPermission(strtolower(Sodapop_Inflector::camelCapsToUnderscores($this->modelClassname, false)), $status['adjective'], 'CALL' )) {
    613. 

  613. 					$retval[] = array(strtolower(substr($this->modelClassname, 0, 1)).substr($this->modelClassname, 1).'/'.strtolower($status['verb']) => $status['display_verb']);
    614. 

  614. 				}
    615. 

  615. 			}
    616. 

  616. 		} else {
    617. 

  617. 			if ($this->user->hasTablePermission(strtolower(Sodapop_Inflector::camelCapsToUnderscores($this->modelClassname, false)), 'INSERT')) {
    618. 

  618. 				$retval[] = array(strtolower(substr($this->modelClassname, 0, 1)).substr($this->modelClassname, 1).'/insert' => 'Insert');
    619. 

  619. 			}
    620. 

  620. 		}
    621. 

  621. 		return $retval;
    622. 

  622. 	}
    623. 

  623. 

  624. 	protected function getNextActions($model) {
    625. 

  625. 		$retval = array();
    626. 

  626. 		if ($model instanceof Sodapop_Database_Form_Abstract) {
    627. 

  627. 			foreach ($this->model->getFormStatuses() as $statusId => $status) {
    628. 

  628. 				if ($status['initial_flag'] == 1 && $this->user->hasFormPermission(strtolower(Sodapop_Inflector::camelCapsToUnderscores($this->modelClassname, false)), $status['adjective'], 'CALL' )) {
    629. 

  629. 					$retval[] = array(strtolower(substr($this->modelClassname, 0, 1)).substr($this->modelClassname, 1).'/'.strtolower($status['verb']) => $status['display_verb']);
    630. 

  630. 				}
    631. 

  631. 			}
    632. 

  632. 		} else {
    633. 

  633. 			if (!$model->id && $this->user->hasTablePermission(strtolower(Sodapop_Inflector::camelCapsToUnderscores($this->modelClassname, false)), 'INSERT')) {
    634. 

  634. 				$retval[] = array(strtolower(substr($this->modelClassname, 0, 1)).substr($this->modelClassname, 1).'/insert' => 'Insert');
    635. 

  635. 			}
    636. 

  636. 			if ($model->id && $this->user->hasTablePermission(strtolower(Sodapop_Inflector::camelCapsToUnderscores($this->modelClassname, false)), 'UPDATE')) {
    637. 

  637. 				$retval[] = array(strtolower(substr($this->modelClassname, 0, 1)).substr($this->modelClassname, 1).'/update' => 'Update');
    638. 

  638. 			}
    639. 

  639. 			if ($model->id && $this->user->hasTablePermission(strtolower(Sodapop_Inflector::camelCapsToUnderscores($this->modelClassname, false)), 'DELETE')) {
    640. 

  640. 				$retval[] = array(strtolower(substr($this->modelClassname, 0, 1)).substr($this->modelClassname, 1).'/delete' => 'Delete');
    641. 

  641. 			}
    642. 

  642. 		}
    643. 

  643. 		return $retval;
    644. 

  644. 	}
    645. 

  645. 

  646. 	protected function createAlias($modelName) {
    647. 

  647. 		$keywords = array('order', 'table' , 'form', 'column', 'field');
    648. 

  648. 		$retval = Sodapop_Inflector::camelCapsToUnderscores($modelName, true);
    649. 

  649. 		if (in_array($retval, $keywords)) {
    650. 

  650. 			return $retval.'z';
    651. 

  651. 		} else {
    652. 

  652. 			return $retval;
    653. 

  653. 		}
    654. 

  654. 	}
    655. 

  655. }
    656. 

  656.