/**
  * Generates set of code based on data.
  * 
  * @return array
  */
 public function generate()
 {
     $this->prepareData($this->data);
     $columnFields = ['name', 'description', 'label'];
     $table = $this->describe->getTable($this->data['name']);
     foreach ($table as $column) {
         if ($column->isAutoIncrement()) {
             continue;
         }
         $field = strtolower($column->getField());
         $method = 'set_' . $field;
         $this->data['camel'][$field] = lcfirst(camelize($method));
         $this->data['underscore'][$field] = underscore($method);
         array_push($this->data['columns'], $field);
         if ($column->isForeignKey()) {
             $referencedTable = Tools::stripTableSchema($column->getReferencedTable());
             $this->data['foreignKeys'][$field] = $referencedTable;
             array_push($this->data['models'], $referencedTable);
             $dropdown = ['list' => plural($referencedTable), 'table' => $referencedTable, 'field' => $field];
             if (!in_array($field, $columnFields)) {
                 $dropdown['field'] = $this->describe->getPrimaryKey($referencedTable);
             }
             array_push($this->data['dropdowns'], $dropdown);
         }
     }
     return $this->data;
 }
Beispiel #2
0
 /**
  * Gets the primary keys based on specified field.
  *
  * @param  array  $data
  * @param  string $field
  * @param  string $referencedTable
  * @return array
  */
 protected function getPrimaryKey(array $data, $field, $referencedTable)
 {
     $accessor = 'get_' . $this->describe->getPrimaryKey($referencedTable);
     $data['primaryKeys'][$field] = $accessor;
     if ($data['isCamel']) {
         $camelized = camelize($data['primaryKeys'][$field]);
         $data['primaryKeys'][$field] = $camelized;
     }
     return $data;
 }
Beispiel #3
0
 /**
  * Returns the required data for model.
  * 
  * @return void
  */
 public function concat(array &$data)
 {
     $columns = $this->describe->getTable($data['name']);
     $counter = 0;
     $data['labels'] = '';
     $data['rules'] = '';
     foreach ($columns as $column) {
         $isBoolean = $column->getDataType() == 'integer' && $column->getLength() == 1;
         if ($column->isPrimaryKey() || $column->isNull() || $isBoolean || strpos($column->getDataType(), 'blob') !== false) {
             continue;
         }
         $template = '$this->validator->rule(\'required\', \'{name}\');' . "\n";
         $keywords = ['{name}' => $column->getField(), '{mutatorName}' => Inflector::camelize('set_' . $column->getField())];
         $label = ucfirst(str_replace('_', ' ', Inflector::tableize($column->getField())));
         $template = str_replace(array_keys($keywords), array_values($keywords), $template);
         if ($column->isForeignKey()) {
             $referencedTable = $this->stripTableSchema($column->getReferencedTable());
             $label = ucfirst(str_replace('_', ' ', Inflector::tableize($referencedTable)));
         }
         if ($column->getField() != 'datetime_created' && $column->getField() != 'datetime_updated' && $column->getField() != 'password') {
             $data['labels'] .= '\'' . $column->getField() . '\' => \'' . $label . '\',';
             $data['rules'] .= $template;
         }
         if ($column->getField() == 'password') {
             $data['labels'] .= '\'' . $column->getField() . '\' => \'' . $label . '\',';
             $data['labels'] .= "\n            " . '\'password_confirmation\' => \'Password confirmation\',';
         }
         if ($counter < count($columns) - 1) {
             if ($column->getField() != 'datetime_created' && $column->getField() != 'datetime_updated') {
                 if ($column->getField() != 'password') {
                     $data['rules'] .= '        ';
                 }
                 $data['labels'] .= "\n" . '            ';
             }
         }
         $counter++;
     }
     $data['labels'] = trim($data['labels']);
     $data['rules'] = trim($data['rules']);
     foreach ($columns as $column) {
         if ($column->getField() == 'password') {
             $data['rules'] .= "\n\n        " . 'if (isset($data[\'password\']) && $data[\'password\'] != null || ! isset($data[\'_method\'])) { ' . "\n            " . '$this->validator->rule(\'required\', \'password\');' . "\n            " . '$this->validator->rule(\'equals\', \'password\', \'password_confirmation\');' . "\n        " . '}';
         }
     }
 }
Beispiel #4
0
 /**
  * Generates set of code based on data.
  * 
  * @return array
  */
 public function generate()
 {
     $this->prepareData($this->data);
     foreach ($this->data['columns'] as $column) {
         $field = strtolower($column->getField());
         $accessor = 'get_' . $field;
         $mutator = 'set_' . $field;
         $this->data['camel'][$field] = ['field' => lcfirst(camelize($field)), 'accessor' => lcfirst(camelize($accessor)), 'mutator' => lcfirst(camelize($mutator))];
         $this->data['underscore'][$field] = ['field' => lcfirst(underscore($field)), 'accessor' => lcfirst(underscore($accessor)), 'mutator' => lcfirst(underscore($mutator))];
         if ($column->isForeignKey()) {
             $field = $column->getField();
             array_push($this->data['indexes'], $field);
             $this->data['primaryKeys'][$field] = 'get_' . $this->describe->getPrimaryKey($column->getReferencedTable());
             if ($this->data['isCamel']) {
                 $this->data['primaryKeys'][$field] = camelize($this->data['primaryKeys'][$field]);
             }
         }
         $column->setReferencedTable(Tools::stripTableSchema($column->getReferencedTable()));
     }
     return $this->data;
 }
Beispiel #5
0
 /**
  * Generates set of code based on data.
  * 
  * @return array
  */
 public function generate()
 {
     $this->prepareData($this->data);
     foreach ($this->data['columns'] as $column) {
         $field = strtolower($column->getField());
         $accessor = 'get_' . $field;
         $mutator = 'set_' . $field;
         $this->data['camel'][$field] = ['field' => lcfirst(camelize($field)), 'accessor' => lcfirst(camelize($accessor)), 'mutator' => lcfirst(camelize($mutator))];
         $this->data['underscore'][$field] = ['field' => lcfirst(underscore($field)), 'accessor' => lcfirst(underscore($accessor)), 'mutator' => lcfirst(underscore($mutator))];
         if ($column->isForeignKey()) {
             $referencedTable = Tools::stripTableSchema($column->getReferencedTable());
             $this->data['foreignKeys'][$field] = plural($referencedTable);
             $singular = $field . '_singular';
             $this->data['foreignKeys'][$singular] = singular($referencedTable);
             $this->data['primaryKeys'][$field] = 'get_' . $this->describe->getPrimaryKey($referencedTable);
             if ($this->data['isCamel']) {
                 $this->data['primaryKeys'][$field] = camelize($this->data['primaryKeys'][$field]);
             }
         }
     }
     return $this->data;
 }
Beispiel #6
0
 /**
  * Returns the required data for model.
  * 
  * @return void
  */
 public function concat(array &$data)
 {
     $config = Configuration::get();
     $columns = $this->describe->getTable($data['name']);
     $data['repository'] = (object) ['compacts' => (object) ['create' => [], 'edit' => ''], 'dropdowns' => '', 'name' => 'repository'];
     $data['parameters'] = '';
     foreach ($columns as $column) {
         if (strpos($column->getDataType(), 'blob') !== false) {
             $data['parameters'] = "\n\n        " . '$files = request()->getUploadedFiles();';
         }
     }
     foreach ($columns as $column) {
         if ($column->isForeignKey()) {
             $referencedTable = $this->stripTableSchema($column->getReferencedTable());
             $keywords = ['{application}' => $config->application->name, '{namespace}' => $config->namespaces->repositories, '{plural}' => Inflector::pluralize($referencedTable), '{singularTitle}' => ucfirst(Inflector::singularize($referencedTable)), '{singular}' => lcfirst(Inflector::classify(Inflector::singularize($referencedTable)))];
             $data['repository']->name = lcfirst(Inflector::classify($data['singular'])) . 'Repository';
             $compact = ', \'{plural}\'';
             $dropdown = '${plural} = repository(\'{application}\\{namespace}\\{singularTitle}Repository\')->findAll();' . "\n        ";
             $compact = str_replace(array_keys($keywords), array_values($keywords), $compact);
             $dropdown = str_replace(array_keys($keywords), array_values($keywords), $dropdown);
             $data['repository']->compacts->edit .= $compact;
             $data['repository']->dropdowns .= $dropdown;
             array_push($data['repository']->compacts->create, "'" . $keywords['{plural}'] . "'");
         }
         if (strpos($column->getDataType(), 'blob') !== false) {
             $data['parameters'] .= "\n        " . '$parameters[\'' . $column->getField() . '\'] = $files[\'' . $column->getField() . '\'];';
         }
     }
     if (!empty($data['repository']->compacts->create)) {
         $data['repository']->compacts->create = ', compact(' . implode(', ', $data['repository']->compacts->create) . ')';
     } else {
         $data['repository']->compacts->create = '';
     }
     if (!empty($data['repository']->dropdowns)) {
         $data['repository']->dropdowns = substr($data['repository']->dropdowns, 0, count($data['repository']->dropdowns) - 9);
         $data['repository']->dropdowns .= "\n        ";
     }
 }
Beispiel #7
0
 /**
  * Sets specified fields for foreign key values.
  * 
  * @param \Rougin\Describe\Column $column
  */
 public function setForeignKey(Column $column, array &$data, array &$keywords)
 {
     if (!$column->isForeignKey()) {
         return;
     }
     $config = Configuration::get();
     $template = $this->foreignColumnTemplate;
     $data['methods'] .= "\n    " . $this->mutatorMethodTemplate . "\n    ";
     $data['methods'] .= $this->accessorMethodTemplate;
     $referencedTable = $this->stripTableSchema($column->getReferencedTable());
     $keywords['{accessorName}'] = Inflector::camelize('get_' . $referencedTable);
     $keywords['{mutatorName}'] = Inflector::camelize('set_' . $referencedTable);
     $keywords['{primaryKey}'] = $this->describe->getPrimaryKey($referencedTable);
     $keywords['{variable}'] = $referencedTable;
     $keywords['{referencedTable}'] = ucfirst($referencedTable);
     $keywords['{description}'] = $referencedTable;
     $keywords['{class}'] = ucfirst($referencedTable) . ' ';
     $keywords['{datatype}'] = '\\' . $config->application->name . '\\' . $config->namespaces->models . '\\' . ucfirst($referencedTable);
     $template = str_replace(array_keys($keywords), array_values($keywords), $template);
     $data['methods'] = str_replace(array_keys($keywords), array_values($keywords), $data['methods']);
     $data['columns'] .= $template;
 }
Beispiel #8
0
 /**
  * Generates a template based on type.
  *
  * @param  array  $data
  * @param  string $templatesPath
  * @param  string $type
  * @return string
  */
 public function generate($data, $templatesPath, $type)
 {
     $columns = $this->describe->getTable($data['{name}']);
     $counter = 0;
     $tableHeading = [];
     $tableBody = [];
     $data['{columnForm}'] = '';
     foreach ($columns as $column) {
         if ($column->isPrimaryKey() || $column->getField() == 'datetime_created' || $column->getField() == 'datetime_updated') {
             continue;
         }
         $description = 'name';
         $referencedTable = '';
         $template = $this->columnFormTemplate;
         if ($column->isForeignKey()) {
             $referencedTable = $this->stripTableSchema($column->getReferencedTable());
             $foreignColumns = $this->describe->getTable($referencedTable);
             $template = $this->foreignColumnFormTemplate;
             foreach ($foreignColumns as $foreignColumn) {
                 if (!$foreignColumn->isPrimaryKey() && !$foreignColumn->isForeignKey()) {
                     $description = $foreignColumn->getField();
                     break;
                 }
             }
         }
         if ($type == 'edit') {
             $template = str_replace('session.old.{name}', 'item.{value}', $template);
         }
         $columnBody = Inflector::camelize($column->getField());
         $columnTitle = ucwords(str_replace('_', ' ', Inflector::tableize($column->getField())));
         if ($column->isForeignKey()) {
             $columnTitle = ucwords(str_replace('_', ' ', Inflector::tableize($referencedTable)));
             $columnBody = Inflector::singularize($referencedTable) . '.' . $description;
         }
         if ($column->getField() != 'password') {
             array_push($tableHeading, '<td>' . $columnTitle . '</td>');
             if (strpos($column->getDataType(), 'blob') !== false) {
                 $image = '<img src="data:image/png;base64,{{ item.' . $columnBody . ' }}" height="50" width="50" />';
                 array_push($tableBody, '<td>' . $image . '</td>');
             } else {
                 array_push($tableBody, '<td>{{ item.' . $columnBody . ' }}</td>');
             }
         }
         $keywords = ['{columnTitle}' => $columnTitle, '{description}' => $description, '{name}' => $column->getField(), '{plural}' => Inflector::pluralize($referencedTable), '{singular}' => Inflector::singularize($referencedTable)];
         if ($type == 'edit') {
             $keywords['{value}'] = Inflector::camelize($keywords['{name}']);
         }
         // column is a boolean (tinyint)
         if ($column->getDataType() == 'integer' && $column->getLength() == 1) {
             $template = str_replace(['<input type="text" name="{name}" class="form-control" value="{{ session.old.{name} }}" />', '{columnTitle}'], ['<input type="checkbox" name="{name}" />', '{columnTitle}?'], $template);
             if ($type == 'edit') {
                 $template = str_replace('<input type="text" name="{name}" class="form-control" value="{{ item.{value} }}" />', '<input type="checkbox" name="{name}" {{ item.{value} ? \'checked\' : \'\' }} />', $template);
             }
         } else {
             if ($column->getDataType() == 'date') {
                 $template = str_replace('type="text"', 'type="date"', $template);
             } else {
                 if (strpos($column->getDataType(), 'blob') !== false) {
                     $template = str_replace('type="text"', 'type="file"', $template);
                     $template = str_replace(' class="form-control" value="{{ session.old.{name} }}"', '', $template);
                     $template = str_replace(' class="form-control" value="{{ item.{value} }}"', '', $template);
                 } else {
                     if ($column->getField() == 'password') {
                         if ($type == 'edit') {
                             $template = str_replace(' value="{{ item.{value} }}"', '', $template);
                         }
                         $template = str_replace('type="text"', 'type="password"', $template);
                     }
                 }
             }
         }
         $template = str_replace(array_keys($keywords), array_values($keywords), $template);
         $data['{columnForm}'] .= $template;
         if ($column->getField() == 'password') {
             $keywords = ['{columnTitle}' => 'Confirm Password', '{name}' => 'password_confirmation', 'type="text"' => 'type="password"', ' value="{{ session.old.password_confirmation }}"' => ''];
             $template = str_replace(array_keys($keywords), array_values($keywords), $this->columnFormTemplate);
             $data['{columnForm}'] .= '        ' . $template;
         }
         if ($counter < count($columns) - 1) {
             $data['{columnForm}'] .= '        ';
         }
         $counter++;
     }
     $actions = '' . '<td>' . "\n              " . '<a href="{{ (\'/' . Inflector::pluralize($data['{name}']) . '/\' ~ item.id ~ \'/edit\') | url }}" class="btn btn-xs btn-info">' . "\n                " . '<i class="fa fa-pencil fa-fw"></i> Update' . "\n              " . '</a>' . "\n               " . '<form action="{{ (\'/' . Inflector::pluralize($data['{name}']) . '/\' ~ item.id) | url }}" style="display: inline-block" method="POST" onsubmit="return confirm(\'Are you sure that you want to delete the selected item?\');">' . "\n                 " . '<input type="hidden" name="_method" value="DELETE" />' . "\n                " . '<button type="submit" class="btn btn-xs btn-danger">' . "\n                   " . '<i class="fa fa-trash fa-fw"></i> Delete' . "\n                 " . '</button>' . "\n              " . '</form>' . "\n            " . '</td>';
     array_push($tableHeading, '<td width="200px">Action</td>');
     array_push($tableBody, $actions);
     $data['{columnForm}'] = trim($data['{columnForm}']);
     $data['{tableHeading}'] = implode("\n          ", $tableHeading);
     $data['{tableBody}'] = implode("\n            ", $tableBody);
     $item = file_get_contents($templatesPath . '/Views/' . $type . '.twig');
     $item = str_replace(array_keys($data), array_values($data), $item);
     return $item;
 }
Beispiel #9
0
 /**
  * Returns the required data for model.
  * 
  * @return void
  */
 public function concat(array &$data)
 {
     $config = Configuration::get();
     $columns = $this->describe->getTable($data['name']);
     $counter = 0;
     $foreignKeys = 0;
     $data['singular'] = lcfirst(Inflector::classify($data['singular']));
     $data['createColumns'] = '';
     $data['updateColumns'] = '';
     foreach ($columns as $column) {
         if ($column->isForeignKey()) {
             $foreignKeys++;
         }
     }
     foreach ($columns as $column) {
         if (!$column->isForeignKey()) {
             continue;
         }
         $referencedTable = $this->stripTableSchema($column->getReferencedTable());
         $template = $this->foreignVariableTemplate;
         $keywords = ['{application}' => $config->application->name, '{models}' => $config->namespaces->models, '{name}' => $column->getField(), '{referencedTable}' => $referencedTable, '{table}' => ucfirst($referencedTable)];
         $template = str_replace(array_keys($keywords), array_values($keywords), $template);
         $data['createColumns'] .= $template;
         $data['updateColumns'] .= $template;
         if ($counter < $foreignKeys - 1) {
             $data['createColumns'] .= '        ';
             $data['updateColumns'] .= '        ';
         }
         $counter++;
     }
     if ($data['createColumns'] != '') {
         $data['createColumns'] .= "\n        ";
         $data['updateColumns'] .= "\n        ";
     }
     $counter = 0;
     foreach ($columns as $column) {
         if ($column->isPrimaryKey()) {
             continue;
         }
         $keywords = ['{name}' => $column->getField(), '{mutatorName}' => Inflector::camelize('set_' . $column->getField()), '{singular}' => lcfirst($data['singularTitle'])];
         $template = $this->mutatorMethodTemplate;
         if ($column->isForeignKey()) {
             $referencedTable = $this->stripTableSchema($column->getReferencedTable());
             $template = $this->foreignMutatorMethodTemplate;
             $keywords['{table}'] = lcfirst(Inflector::classify($referencedTable));
             $keywords['{mutatorName}'] = Inflector::camelize('set_' . $referencedTable);
         }
         if ($column->getField() == 'datetime_created' || $column->getField() == 'datetime_updated') {
             $template = str_replace('$data[\'{name}\']', "'now'", $template);
         } else {
             if ($column->getDataType() == 'integer' && $column->getLength() == 1) {
                 $template = str_replace('$data[\'{name}\']', 'isset($data[\'{name}\'])', $template);
             } else {
                 if ($column->getField() == 'password') {
                     $template = str_replace('$data[\'{name}\']', 'md5($data[\'{name}\'])', $template);
                 } else {
                     if ($column->isNull()) {
                         $template = str_replace('$data[\'{name}\']', 'isset($data[\'{name}\']) ? $data[\'{name}\'] : null', $template);
                     }
                 }
             }
         }
         $template = str_replace(array_keys($keywords), array_values($keywords), $template);
         if ($column->getField() != 'datetime_updated' && strpos($column->getDataType(), 'blob') === false) {
             $data['createColumns'] .= $template;
         }
         if ($column->getField() != 'datetime_created' && $column->getField() != 'password' && strpos($column->getDataType(), 'blob') === false) {
             $data['updateColumns'] .= $template;
         }
         if ($counter < count($columns) - 1) {
             if ($column->getField() != 'datetime_updated' && strpos($column->getDataType(), 'blob') === false) {
                 $data['createColumns'] .= '        ';
             }
             if ($column->getField() != 'datetime_created' && $column->getField() != 'password' && strpos($column->getDataType(), 'blob') === false) {
                 $data['updateColumns'] .= '        ';
             }
         }
         $counter++;
     }
     $data['createColumns'] = trim($data['createColumns']);
     $data['updateColumns'] = trim($data['updateColumns']);
     foreach ($columns as $column) {
         if ($column->getField() != 'password' && strpos($column->getDataType(), 'blob') === false) {
             continue;
         }
         if ($column->getField() == 'password') {
             $table = lcfirst(Inflector::classify($data['singular']));
             $mutator = Inflector::camelize('set_' . $column->getField());
             $data['updateColumns'] .= "\n\n        " . 'if ($data[\'' . $column->getField() . '\']) {' . "\n            " . '$' . $table . '->' . $mutator . '(md5($data[\'' . $column->getField() . '\']));' . "\n        " . '}';
         }
         if (strpos($column->getDataType(), 'blob') !== false) {
             $table = lcfirst(Inflector::classify($data['singular']));
             $mutator = Inflector::camelize('set_' . $column->getField());
             $code = "\n\n        " . 'if (! $data[\'' . $column->getField() . '\']->getError()) {' . "\n            " . '$' . $column->getField() . ' = $data[\'' . $column->getField() . '\']->getStream()->getContents();' . "\n\n            " . '$' . $table . '->' . $mutator . '($' . $column->getField() . ');' . "\n        " . '}';
             $data['createColumns'] .= $code;
             $data['updateColumns'] .= $code;
         }
     }
 }