/**
* @return array
*/
public function getTopicOptions()
{
$raw = Topic::find()->orderBy('Category_id')->all();
$arr = array();
foreach ($raw as $row) {
$categpry = \app\models\Category::getCategoryById($row['Category_id']);
$arr[$row['id']] = $categpry . ' - ' . $row['name'];
}
return $arr;
}
public function export()
{
$data = array(array('Name', 'Alias', 'Meta keywords', 'Meta description', 'Parent', 'Publish', 'Views', 'Type'));
$pages = Category::getCategoriesByContentType(2);
foreach ($pages as $page) {
$page_array = array();
$name = $page['name'];
array_push($page_array, $name);
$alias = $page['alias'];
array_push($page_array, $alias);
if (empty($page['meta_keys'])) {
$meta_keys = 'None';
} else {
$meta_keys = $page['meta_keys'];
}
array_push($page_array, $meta_keys);
if (empty($page['meta_desc'])) {
$meta_desc = 'None';
} else {
$meta_desc = $page['meta_desc'];
}
array_push($page_array, $meta_desc);
if ($page['type'] == 1) {
$parent = 'None';
} else {
$parent = Category::getCategoryById($page['parent_id'])['name'];
}
array_push($page_array, $parent);
if ($page['publish'] == 1) {
$publish = 'Published';
} else {
$publish = 'Unpublished';
}
array_push($page_array, $publish);
$views = (string) $page->visits()->count();
array_push($page_array, $views);
if ($page['type'] == 1) {
$type = 'Parent';
} else {
$type = 'Sub category';
}
array_push($page_array, $type);
array_push($data, $page_array);
}
Excel::create('Pages', function ($excel) use($data) {
$excel->sheet('Pages', function ($sheet) use($data) {
$sheet->fromArray($data, null, 'A1', false, false);
$sheet->cells('A1:H1', function ($cells) {
$cells->setFontWeight('bold');
});
});
})->export('xls');
}
/**
* Export posts
*/
public function export()
{
$data = array(array('Name', 'Alias', 'Tags', 'Category', 'Status', 'Views', 'Publish'));
$posts = Post::getPosts(0, '', Auth::user()->id);
foreach ($posts as $post) {
$post_array = array();
$alias = $post['alias'];
array_push($post_array, $alias);
if ($post->tags->count() == 0) {
$tags = 'None';
} else {
$tags = "";
foreach ($post->tags as $tag) {
$tags .= $tag['name'] . ',';
}
}
array_push($post_array, $tags);
if (empty($post['category_id'])) {
$category = 'None';
} else {
$category = Category::getCategoryById($post['category_id'])['name'];
}
array_push($post_array, $category);
if ($post['approve'] == 1) {
$status = 'Approved';
} else {
$status = 'Not approved';
}
array_push($post_array, $status);
$visits = (string) $post->visits()->count();
array_push($post_array, $visits);
if (empty($post['publish'])) {
$publish = 'Unpublished';
} else {
$publish = 'Published';
}
array_push($post_array, $publish);
array_push($data, $post_array);
}
Excel::create('Posts', function ($excel) use($data) {
$excel->sheet('Posts', function ($sheet) use($data) {
$sheet->fromArray($data, null, 'A1', false, false);
$sheet->cells('A1:G1', function ($cells) {
$cells->setFontWeight('bold');
});
});
})->export('xls');
}
