/**
* Generate FAke Values
*/
public static function fakeValues()
{
$categories = [['title' => 'Root Category', 'status' => 2, 'children' => [['title' => 'TV & Home Theather', 'status' => rand(0, 2)], ['title' => 'Tablets & E-Readers', 'status' => rand(0, 2)], ['title' => 'Computers', 'status' => rand(0, 2), 'children' => [['title' => 'Laptops', 'status' => rand(0, 2), 'children' => [['title' => 'PC Laptops', 'status' => rand(0, 2)], ['title' => 'Macbooks (Air/Pro)', 'status' => rand(0, 2)]]], ['title' => 'Desktops', 'status' => rand(0, 2), 'children' => [['title' => 'Towers Only', 'status' => rand(0, 2)], ['title' => 'Desktop Packages', 'status' => rand(0, 2)], ['title' => 'All-in-One Computers', 'status' => rand(0, 2)], ['title' => 'Gaming Desktops', 'status' => rand(0, 2)]]]]], ['title' => 'Cell Phones', 'status' => rand(0, 2)]]]];
parent::buildTree($categories);
}
/**
* Run the migrations dynamically
*
* @return void
*/
public function up()
{
$migrateCommand = app('command.migrate');
$this->down();
//$migrator->note();
$migrateCommand->info(" - Migrating");
$dbTblPrefix = zbase_db_prefix();
$entities = zbase_config_get('entity', []);
if (!empty($entities)) {
foreach ($entities as $entityName => $entity) {
$enable = zbase_data_get($entity, 'enable', false);
if (empty($enable)) {
continue;
}
$build = zbase_data_get($entity, 'build', true);
if (empty($build)) {
continue;
}
/**
* acceptable value is false|string|classname
* if null, will pass the entity
*/
$model = zbase_data_get($entity, 'model', null);
if (is_null($model)) {
continue;
}
$modelName = zbase_class_name($model);
$isPostModel = zbase_data_get($entity, 'post', false);
$postModel = null;
if (!empty($isPostModel)) {
$postModel = zbase_object_factory($modelName);
if ($postModel instanceof \Zbase\Post\PostInterface) {
$entity = $postModel->postTableConfigurations($entity);
}
}
if (empty($isPostModel) && empty($postModel)) {
if (method_exists($modelName, 'entityConfiguration')) {
$entity = $modelName::entityConfiguration($entity);
}
}
$tableName = zbase_data_get($entity, 'table.name', null);
if (empty($tableName)) {
continue;
}
$columns = zbase_data_get($entity, 'table.columns', []);
if (!empty($postModel) && $postModel instanceof \Zbase\Post\PostInterface) {
$columns = $postModel->postTableColumnsConfiguration($columns, $entity);
}
$nodeable = zbase_data_get($entity, 'table.nodeable', false);
if (!empty($nodeable)) {
$columns = array_merge_recursive($columns, \Zbase\Entity\Laravel\Node\Node::nodeDefaultColumns());
}
$nesteable = zbase_data_get($entity, 'table.nesteable', false);
if (!empty($nesteable)) {
$columns = array_merge_recursive($columns, \Zbase\Entity\Laravel\Node\Nested::nestedNodeDefaultColumns());
}
if (method_exists($modelName, 'tableColumns')) {
$columns = $modelName::tableColumns($columns, $entity);
}
// <editor-fold defaultstate="collapsed" desc="PivoTable">
$pivotable = false;
//zbase_data_get($entity, 'table.pivotable', false);
if (!empty($pivotable)) {
$pivotEntityTable = zbase_config_get('entity.' . $pivotable['entity'], null);
$nestedEntityTable = zbase_config_get('entity.' . $pivotable['nested'], null);
if (!is_null($pivotEntityTable) && !is_null($nestedEntityTable)) {
$entityPrimaryKey = zbase_data_get($pivotEntityTable, 'table.primaryKey', null);
$nestedPrimaryKey = zbase_data_get($nestedEntityTable, 'table.primaryKey', null);
$columns = [];
$columns[$entityPrimaryKey] = ['length' => 16, 'hidden' => false, 'fillable' => true, 'type' => 'integer', 'unsigned' => true, 'foreign' => ['table' => zbase_data_get($pivotEntityTable, 'table.name', null), 'column' => $entityPrimaryKey, 'onDelete' => 'cascade'], 'comment' => zbase_data_get($pivotEntityTable, 'table.description', null) . ' ID'];
$columns[$nestedPrimaryKey] = ['length' => 16, 'hidden' => false, 'fillable' => true, 'type' => 'integer', 'unsigned' => true, 'foreign' => ['table' => zbase_data_get($nestedEntityTable, 'table.name', null), 'column' => $nestedPrimaryKey, 'onDelete' => 'cascade'], 'comment' => zbase_data_get($nestedEntityTable, 'table.description', null) . ' ID'];
}
}
// </editor-fold>
if (empty($columns)) {
// continue;
}
Schema::create($tableName, function (Blueprint $table) use($columns, $entity, $modelName, $tableName, $migrateCommand) {
$tableTye = zbase_data_get($entity, 'table.type', 'InnoDB');
$table->engine = $tableTye;
$primaryKey = zbase_data_get($entity, 'table.primaryKey', null);
if (!is_null($primaryKey)) {
$table->increments($primaryKey);
}
if (!empty($columns)) {
// <editor-fold defaultstate="collapsed" desc="Columns">
foreach ($columns as $columnName => $column) {
$columnName = zbase_data_get($column, 'name', $columnName);
if ($columnName == $primaryKey) {
continue;
}
$type = zbase_data_get($column, 'type', 'string');
$defaultLength = 16;
if ($type == 'string') {
$defaultLength = 255;
} elseif ($type == 'integer' || $type == 'decimal' || $type == 'double') {
$defaultLength = 16;
}
$index = zbase_data_get($column, 'index', false);
$unique = zbase_data_get($column, 'unique', false);
$length = zbase_data_get($column, 'length', $defaultLength);
$comment = zbase_data_get($column, 'comment', false);
$default = zbase_data_get($column, 'default', null);
$unsigned = zbase_data_get($column, 'unsigned', false);
$nullable = zbase_data_get($column, 'nullable', false);
if (!is_null($type)) {
if ($type == 'decimal') {
$length = zbase_data_get($column, 'length', 16);
$decimal = zbase_data_get($column, 'decimal', 2);
$col = $table->decimal($columnName, $length, $decimal);
} elseif ($type == 'double') {
$length = zbase_data_get($column, 'length', 16);
$decimal = zbase_data_get($column, 'decimal', 2);
$col = $table->double($columnName, $length, $decimal);
} elseif ($type == 'json') {
$col = $table->text($columnName);
} elseif ($type == 'integer') {
$col = $table->integer($columnName);
} elseif ($type == 'bigint') {
$col = $table->bigInteger($columnName);
} elseif ($type == 'tinyint') {
$col = $table->tinyInteger($columnName);
} elseif ($type == 'ipAddress') {
$col = $table->ipAddress($columnName);
} elseif ($type == 'enum') {
$enums = zbase_data_get($column, 'enum', []);
if (!empty($enums)) {
$col = $table->enum($columnName, $enums);
}
} else {
if (empty($length)) {
$col = $table->{$type}($columnName);
} else {
$col = $table->{$type}($columnName, $length);
}
}
if (!is_null($default)) {
$col->default($default);
} else {
$col->default(null);
}
if (!empty($nullable)) {
$col->nullable();
}
if (!empty($index)) {
$table->index($columnName);
}
if (!empty($unique)) {
$table->unique($columnName);
}
if (!empty($unsigned)) {
$col->unsigned();
}
if (!empty($comment)) {
$col->comment($comment);
}
$foreignTable = zbase_data_get($column, 'foreign.table', null);
$foreignColumn = zbase_data_get($column, 'foreign.column', null);
$foreignOnDelete = zbase_data_get($column, 'foreign.onDelete', null);
$foreignOnUpdate = zbase_data_get($column, 'foreign.onUpdate', null);
if (!is_null($foreignTable) && !is_null($foreignColumn)) {
$col = $table->foreign($columnName)->references($foreignColumn)->on($foreignTable);
if (!is_null($foreignOnDelete)) {
$col->onDelete($foreignOnDelete);
}
if (!is_null($foreignOnUpdate)) {
$col->onUpdate($foreignOnUpdate);
}
}
}
}
// </editor-fold>
}
$orderable = zbase_data_get($entity, 'table.orderable', false);
if (!empty($orderable)) {
$table->integer('position')->unsigned()->comment('Row Order/Position');
}
$userable = zbase_data_get($entity, 'table.userable', false);
if (!empty($userable)) {
$table->integer('user_id')->unsigned()->comment('User Id')->nullable(true);
$table->index('user_id');
}
$otherUserable = zbase_data_get($entity, 'table.otherUserable', false);
if (!empty($otherUserable)) {
$table->integer('other_user_id')->unsigned()->comment('Other User Id')->nullable(true);
$table->index('other_user_id');
}
$statusable = zbase_data_get($entity, 'table.statusable', false);
if (!empty($statusable)) {
$table->integer('status')->unsigned()->comment('Status')->nullable(true);
$table->index('status');
}
$optionable = zbase_data_get($entity, 'table.optionable', false);
if (!empty($optionable)) {
$table->text('options')->nullable();
}
$typeable = zbase_data_get($entity, 'table.typeable', false);
if (!empty($typeable)) {
$table->integer('type')->unsigned()->comment('Type')->nullable(true);
}
$hashable = zbase_data_get($entity, 'table.hashable', false);
if (!empty($hashable)) {
$table->string('hash', 255)->nullable()->comment('Hash value');
}
$addedable = zbase_data_get($entity, 'table.addedable', false);
if (!empty($addedable)) {
$table->integer('added_by')->unsigned()->comment('Added by')->nullable(true);
$table->index('added_by');
}
$roleable = zbase_data_get($entity, 'table.roleable', false);
if (!empty($roleable)) {
$table->text('roles')->nullable()->comment('Roles/Access');
}
$remarkable = zbase_data_get($entity, 'table.remarkable', false);
if (!empty($remarkable)) {
$table->text('remarks')->nullable();
}
$sluggable = zbase_data_get($entity, 'table.sluggable', false);
if (!empty($sluggable)) {
$table->string('slug', 255)->nullable()->comment('Slug/URL key');
$table->index('slug');
$table->unique('slug');
}
$timestamp = zbase_data_get($entity, 'table.timestamp', false);
if ($timestamp) {
$table->timestamps();
}
$softDelete = zbase_data_get($entity, 'table.softDelete', false);
if (!empty($softDelete)) {
$table->softDeletes();
}
$rememberToken = zbase_data_get($entity, 'table.rememberToken', false);
if (!empty($rememberToken)) {
$table->rememberToken();
$table->index('remember_token');
}
$ipAddressable = zbase_data_get($entity, 'table.ipAddress', false);
if (!empty($ipAddressable)) {
$table->ipAddress('ip_address')->comment('IP Address');
}
$alphaId = zbase_data_get($entity, 'table.alphaId', zbase_data_get($entity, 'table.alphable', false));
if (!empty($alphaId)) {
$table->string('alpha_id', 64)->nullable();
$table->unique('alpha_id');
}
$polymorphic = zbase_data_get($entity, 'table.polymorphic', []);
if (!empty($polymorphic)) {
$polymorphicPrefix = zbase_data_get($entity, 'table.polymorphic.prefix', 'taggable');
$table->integer($polymorphicPrefix . '_id')->nullable();
$table->string($polymorphicPrefix . '_type', 64)->nullable();
}
$indexes = zbase_data_get($entity, 'table.indexes', null);
if (!empty($indexes)) {
foreach ($indexes as $indexName => $index) {
$indexType = !empty($index['type']) ? $index['type'] : null;
$indexName = !empty($index['name']) ? $index['name'] : null;
$indexColumns = !empty($index['columns']) ? $index['columns'] : $indexName;
switch ($indexType) {
case 'unique':
$table->unique($indexColumns, $indexName);
break;
default:
$table->index($indexColumns, $indexName);
}
}
}
// echo " -- Migrated " . (!empty($modelName) ? $modelName . ' - ' : '') . $tableName . "\n";
$migrateCommand->info(" -- Migrated " . (!empty($modelName) ? $modelName . ' - ' : '') . $tableName);
});
$description = zbase_data_get($entity, 'table.description', null);
if (!is_null($description)) {
$tableName = $dbTblPrefix . $tableName;
\DB::statement("ALTER TABLE `{$tableName}` COMMENT='{$description}'");
// DB::select(DB::raw("ALTER TABLE `{$tableName}` COMMENT='{$description}'"));
}
}
}
}