public function run()
{
$classRooms = DB::select(DB::raw("select classrooms.block from classrooms group by classrooms.block order by classrooms.block"));
foreach ($classRooms as $value) {
$block = new Block();
$block->name = $value->block;
$block->save();
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('page')->delete();
DB::table('block')->delete();
$page = new Page();
$page->name = 'Homepage';
$page->slug = 'homepage';
$page->enabled = true;
$page->user_id = DB::table('users')->first()->id;
$page->save();
for ($i = 0; $i < 3; $i++) {
$block = new Block();
$block->slug = 'html_block' . $i;
$block->type = 'html';
$block->content = array('html' => '<b>Bold ' . $i . ' block</b>');
$block->class = 'col-md-4';
$block->enabled = true;
$block->page_id = $page->id;
$block->save();
}
}
public function parseBlocks($blocks, $userid, $alpha, $core = 0, $modid = 0)
{
//purge all existing blocks that are core and of this alpha version
Block::where(array('user_id' => 1, 'alpha' => 12.4))->delete();
//dd($blocks);
$processed = 0;
foreach ($blocks['block'] as $item) {
$block = new \App\Block();
$block->name = $item['@attributes']['name'];
if ($core) {
$block->user_id = 1;
$block->mod_id = 1;
$block->core = 1;
$block->pimp_id = $item['@attributes']['id'];
} else {
$block->user_id = $userid;
$block->mod_id = $modid;
$block->core = 0;
$block->pimp_id = 0;
}
$block->alpha = $alpha;
$block->save();
$currentid = $item['@attributes']['id'];
if (isset($item['property'])) {
foreach ($item['property'] as $prop) {
if (isset($prop['@attributes'])) {
$attribs = $prop['@attributes'];
$properties = '';
$parameters = '';
$attribute = 'property';
foreach ($attribs as $key => $value) {
if ($key == 'name') {
$propname = $value;
} else {
if ($key == 'value') {
$propvalue = $value;
} else {
if ($key == 'class') {
$attribute = 'class';
$propname = 'class';
$propvalue = $value;
} else {
$parameters = $parameters . "{$key}={$value}|";
}
}
}
if ($key == 'value' && $value == 'PlantGrowing') {
$plantblock = true;
} else {
$plantblock = false;
}
if ($value == 'UpgradeBlock') {
$properties = "UB";
foreach ($prop['property'] as $subprop) {
foreach ($subprop['@attributes'] as $ukey => $uvalue) {
if ($ukey == 'name') {
$subname = $uvalue;
}
if ($ukey == 'value') {
$subvalue = $uvalue;
}
}
$parameters = $parameters . "{$subname}&{$subvalue}|";
}
}
if ($value == 'Explosion') {
$properties = "EX";
foreach ($prop['property'] as $subprop) {
foreach ($subprop['@attributes'] as $ukey => $uvalue) {
if ($ukey == 'name') {
$subname = $uvalue;
}
if ($ukey == 'value') {
$subvalue = $uvalue;
}
}
$parameters = $parameters . "{$subname}&{$subvalue}|";
}
}
if ($value == 'PlantGrowing' && !$plantblock) {
$properties = "PG";
foreach ($prop['property'] as $subprop) {
foreach ($subprop['@attributes'] as $gkey => $gvalue) {
if ($gkey == 'name') {
$subname = $gvalue;
}
if ($gkey == 'value') {
$subvalue = $gvalue;
}
}
$parameters = $parameters . "{$subname}&{$subvalue}|";
}
}
}
$prop = new \App\BlockProperties();
$prop->block_id = $block->id;
$prop->attribute = $attribute;
$prop->key = $propname;
$prop->key = $propname;
$prop->value = $propvalue;
$prop->properties = rtrim($properties, "|");
$prop->parameters = rtrim($parameters, "|");
$prop->save();
}
}
}
if (isset($item['drop'])) {
foreach ($item['drop'] as $property) {
$parameters = '';
$okToSave = false;
$propname = '';
$propvalue = '';
foreach ($property as $key => $value) {
if (is_array($value)) {
$parameters = '';
foreach ($value as $skey => $svalue) {
if ($skey == 'event') {
$propname = $svalue;
} else {
if ($skey == 'name') {
$propvalue = $svalue;
} else {
$parameters = $parameters . "{$skey}={$svalue}|";
}
}
}
$prop = new \App\BlockProperties();
$prop->block_id = $block->id;
$prop->attribute = 'drop';
$prop->key = $propname;
$prop->value = $propvalue;
$prop->parameters = rtrim($parameters, "|");
$prop->save();
} else {
$okToSave = true;
if ($key == 'event') {
$propname = $value;
} else {
if ($key == 'name') {
$propvalue = $value;
} else {
$parameters = $parameters . "{$key}={$value}|";
}
}
}
}
if ($okToSave) {
$prop = new \App\BlockProperties();
$prop->block_id = $block->id;
$prop->attribute = 'drop';
$prop->key = $propname;
$prop->value = $propvalue;
$prop->parameters = rtrim($parameters, "|");
$prop->save();
}
}
}
}
}
public function addBlock($color = null)
{
if ($this->lock) {
return false;
}
$block = new Block();
$block->swatch_id = $this->id;
$data = $block->init($color);
$block->save();
return array_merge(['id' => $block->id], $data);
}
