/** * Open the AutoCode for edit. * * @param EcrProjectAutocode $AutoCode The AutoCode * * @return void */ public function edit(EcrProjectAutocode $AutoCode) { /* Array with required fields */ $requireds = array(); $requireds[] = EcrHtmlSelect::scope($this->scope); echo '<input type="hidden" name="element" value="' . $this->element . '" />'; /* Draws an input box for a name field */ $requireds[] = EcrHtmlSelect::name($this->element, jgettext('Table')); $tableFields = EcrTableHelper::getTableColumns($this->element); echo '<br />'; $key = $AutoCode->getKey() . '.row'; if (array_key_exists($key, $AutoCode->fields)) { $acFields = $AutoCode->fields[$key]; } else { $acFields = array(); } echo '<div style="background-color: #f3fbe6;">Header</div>'; echo '<table>'; echo '<tr>'; echo '<th>' . jgettext('Field') . '</th>'; echo '<th>' . jgettext('Label') . '</th>'; echo '<th>' . jgettext('Input type') . '</th>'; echo '</tr>'; foreach ($tableFields as $name => $tableField) { if (array_key_exists($name, $acFields)) { //-- Autocode present $label = $acFields[$name]->label; $inputType = $acFields[$name]->inputType; $width = $acFields[$name]->width; } else { //-- New field $label = $tableField->Field; $inputType = 'text'; $width = 0; } echo '<tr>'; echo '<th>'; echo $name; echo '</th>'; echo '<td>'; echo '<input type="text" name="field[' . $name . '][label]" value="' . $label . '" />'; echo '</td>'; echo '<td>'; echo '<select name="field[' . $name . '][input_type]">'; $selected = $inputType == 'text' ? ' selected="selected"' : ''; echo '<option value="text"' . $selected . '><text></option>'; $selected = $inputType == 'hidden' ? ' selected="selected"' : ''; echo '<option value="hidden"' . $selected . '><hidden></option>'; $selected = $inputType == 'category' ? ' selected="selected"' : ''; echo '<option value="category"' . $selected . '>Catergory select</option>'; echo '</select>'; echo '</td>'; echo '</tr>'; } //foreach echo '</table>'; /* Draws the submit button */ EcrHtmlButton::autoCode($requireds); }
/** * Inserts the AutoCode into the project. * * @param EcrProjectBase $project The project. * @param array $options Insert options. * @param EcrLogger $logger EcrLogger. * * @return boolean */ public function insert(EcrProjectBase $project, $options, EcrLogger $logger) { $input = JFactory::getApplication()->input; $table_name = $input->get('element'); $var_scope = $input->get('var_scope'); $element_scope = $input->get('element_scope'); if (!$table_name) { JFactory::getApplication()->enqueueMessage(jgettext('No table given'), 'error'); return false; } $db = JFactory::getDBO(); $prefix = $db->getPrefix(); $fields = $db->getTableFields($prefix . $table_name); $table_vars = ''; $autoCodeFields = array(); $reqFields = $input->get('field', array(), 'array'); if (count($fields)) { foreach ($fields[$prefix . $table_name] as $name => $type) { $reqField = $reqFields[$name]; if (isset($project->autoCodes[$this->key]->fields[$this->key . '.var'][$name])) { $field = $project->autoCodes[$this->key]->fields[$this->key . '.var'][$name]; $field->label = $reqField['label']; } else { $field = new EcrTableField(); $field->name = $name; $field->label = $name; $field->type = $type; } $autoCodeFields[] = $field; $adds = array($field->label); $table_vars .= EcrTableHelper::formatTableVar($name, $type, $adds, $var_scope); } //foreach } $AutoCode = new EcrProjectAutocode($this->group, $this->name, $table_name, $element_scope); $AutoCode->options = array(); $AutoCode->options['varscope'] = $var_scope; $AutoCode->fields[$AutoCode->getKey() . '.var'] = $autoCodeFields; $AutoCode->codes[$AutoCode->getKey() . '.var'] = $AutoCode->enclose($table_vars, $AutoCode->getKey() . '.var'); $project->addAutoCode($AutoCode); /* * Add substitutes * * Define keys that will be substitutes in the code */ $project->addSubstitute('ECR_SUBPACKAGE', 'Tables'); $project->addSubstitute('_ECR_TABLE_NAME_', $table_name); foreach ($AutoCode->codes as $key => $code) { $project->addSubstitute($key, $code); } //foreach /* Insert the part to your project and return the results */ return $project->insertPart($options, $logger); }
/** * Adds AutoCode to the project. * * @param EcrProjectAutocode $autoCode The AutoCode * * @return void */ public function addAutoCode(EcrProjectAutocode $autoCode) { $this->autoCodes[$autoCode->getKey()] = $autoCode; }
/** * Open the AutoCode for edit. * * @param EcrProjectAutocode $AutoCode The AutoCode * * @return void */ public function edit(EcrProjectAutocode $AutoCode) { JFactory::getApplication()->enqueueMessage(__METHOD__ . ' not finished', 'warning'); /* Array with required fields */ $requireds = array(); $requireds[] = EcrHtmlSelect::scope($this->scope); echo '<input type="hidden" name="element" value="' . $this->element . '" />'; /* Draws an input box for a name field */ $requireds[] = EcrHtmlSelect::name($this->element, jgettext('Table')); $tableFields = EcrTableHelper::getTableColumns($this->element); $elements = array('header', 'cell'); echo '<br />'; /* * Header */ $key = $AutoCode->getKey() . '.header'; if (array_key_exists($key, $AutoCode->fields)) { $acFields = $AutoCode->fields[$key]; } else { $acFields = array(); } echo '<div style="background-color: #f3fbe6;">Header</div>'; echo '<table>'; echo '<tr>'; echo '<th>' . jgettext('Field') . '</th>'; echo '<th>' . jgettext('Label') . '</th>'; echo '<th>' . jgettext('Display') . '</th>'; echo '<th>' . jgettext('Width') . '</th>'; echo '</tr>'; foreach ($tableFields as $name => $tableField) { if (array_key_exists($name, $acFields)) { //-- Autocode present $label = $acFields[$name]->label; $display = $acFields[$name]->display; $width = $acFields[$name]->width; } else { //-- New field $label = $tableField->Field; $display = 'on'; $width = 0; } echo '<tr>'; echo '<th>'; echo $name; echo '</th>'; echo '<td>'; echo '<input type="text" name="field[header][' . $name . '][label]" value="' . $label . '" />'; echo '</td>'; echo '<td>'; echo '<select name="field[header][' . $name . '][display]">'; $selected = $display == 'on' ? ' selected="selected"' : ''; echo '<option value="on"' . $selected . '>' . jgettext('On') . '</option>'; $selected = $display == 'off' ? ' selected="selected"' : ''; echo '<option value="off"' . $selected . '>' . jgettext('Off') . '</option>'; echo '</select>'; echo '</td>'; echo '<td>'; echo '<input type="text" name="field[header][' . $name . '][width]" value="' . $width . '" />'; echo '</td>'; echo '</tr>'; } //foreach echo '</table>'; /* * Cell */ $key = $AutoCode->getKey() . '.cell'; if (array_key_exists($key, $AutoCode->fields)) { $acFields = $AutoCode->fields[$key]; } else { $acFields = array(); } echo '<div style="background-color: #f3fbe6;">Cell</div>'; echo '<table>'; echo '<tr>'; echo '<th>' . jgettext('Field') . '</th>'; // echo '<th>'.jgettext('Label').'</th>'; echo '</tr>'; foreach ($tableFields as $name => $tableField) { if (array_key_exists($name, $acFields)) { //-- Autocode present $value = $acFields[$name]->label; } else { //-- New field $value = $tableField->Field; } echo '<tr>'; echo '<th>'; echo $name; echo '<input type="hidden" name="field[cell][' . $name . '][name]" value="' . $name . '" />'; echo '</th>'; echo '</tr>'; } //foreach echo '</table>'; /* Draws the submit button */ EcrHtmlButton::autoCode($requireds); }