public function getCategories($id = null)
{
//Config::set('laravel-debugbar::config.enabled', false);
$categories = Object::where('objects.type', 'category')->where('parent_id', $id)->select(array('objects.id', 'objects.title', 'objects.name'))->get();
$response = $categories;
foreach ($categories as $category) {
if ($contentImageId = ObjectMeta::getValue($category->id, '_content_image')) {
if ($contentImageUrl = getImageSrc($contentImageId, 'medium')) {
$category['contentImageUrl'] = '/uploads/' . $contentImageUrl;
}
}
if ($featuredImageId = ObjectMeta::getValue($category->id, '_featured_image')) {
if ($featuredImageUrl = getImageSrc($featuredImageId, 'thumbnail')) {
$category['featuredImageUrl'] = '/uploads/' . $featuredImageUrl;
}
}
$category['childrenCount'] = Object::where('objects.type', 'category')->where('parent_id', $category['id'])->count();
$category['itemsCount'] = ObjectMeta::join('objects', 'object_meta.object_id', '=', 'objects.id')->where('meta_key', '_category_id')->where('meta_value', $category['id'])->where('objects.type', '<>', 'category')->groupBy('object_id')->count();
}
// $categories = Object::leftJoin('objects as t1', function($join) {
// $join->on('objects.id', '=', 't1.parent_id');
// })
// ->where('objects.type', 'category')
// //->whereNull('objects.parent_id')
// ->where('t1.parent_id', $id)
// ->select(DB::raw('jini_t1.*'))
// ->get();
//print_r($categories);
//
// $response = array(
// 'categories' => $categories
// //'contentImage' =>
// );
return response()->json($categories);
}
private function processCategory(&$category)
{
if ($contentImageId = ObjectMeta::getValue($category->id, '_content_image')) {
if ($contentImageUrl = getImageSrc($contentImageId, 'medium')) {
$category['contentImageUrl'] = '/uploads/' . $contentImageUrl;
}
}
if ($featuredImageId = ObjectMeta::getValue($category->id, '_featured_image')) {
if ($featuredImageUrl = getImageSrc($featuredImageId, 'small')) {
$category['featuredImageUrl'] = '/uploads/' . $featuredImageUrl;
// $path = __DIR__ . '/../../../public/uploads/' . $featuredImageUrl;
// echo $path . '<br />' . file_exists($path) . '<br />';
// if (file_exists($path)) {
// $type = pathinfo($path, PATHINFO_EXTENSION);
// $data = file_get_contents($path);
// $category['featuredImageUrl'] = base64_encode($data);
// }
}
}
$category['childrenCount'] = Object::where('objects.type', 'category')->where('parent_id', $category['id'])->count();
$category['itemsCount'] = ObjectMeta::join('objects', 'object_meta.object_id', '=', 'objects.id')->where('meta_key', '_category_id')->where('meta_value', $category['id'])->where('objects.type', '<>', 'category')->groupBy('object_id')->count();
return $category;
}
