public static function addValue($objectId, $metaKey, $metaValue) { $objectMeta = ObjectMeta::getMeta($objectId, $metaKey); if (!isset($objectMeta) || $objectMeta->meta_value != $metaValue) { $objectMeta = new ObjectMeta(); $objectMeta->object_id = $objectId; } $objectMeta->meta_key = $metaKey; $objectMeta->meta_value = $metaValue; return $objectMeta->save(); }
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); }
public function getLocations() { $results = $this->getSearch(); $data = array(); $locations = array('type' => 1, 'userMsg' => false); if (!empty($results)) { foreach ($results as $result) { if ($lat = ObjectMeta::getValue($result['id'], '_field_address-location-g')) { if ($long = ObjectMeta::getValue($result['id'], '_field_address-location-k')) { $location = array('geo_latitude' => $lat, 'geo_longitude' => $long, 'location' => '', 'title' => $result['title']); $data[] = $location; } } } } $locations['data'] = $data; return $locations; //return view('partials.map', compact( 'locations' )); }
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; }
function addImage($object, $destinationPath, $picture, $filename, $newfileName, $extension, $mimeType, $fieldName) { list($source_image_width, $source_image_height, $source_image_type) = getimagesize($destinationPath . $picture); $imageObjectInfo = array(); $imageObjectInfo['width'] = $source_image_width; $imageObjectInfo['height'] = $source_image_height; $imageObjectInfo['filePath'] = $filename; $imageObjectInfo['sizes'] = array(); if ($source_image_width > 1920) { //} || $source_image_height > 1080) { Thumbnail::generate_image_thumbnail($destinationPath . $picture, $destinationPath . $newfileName . '-resized.' . $extension, 1920, 1080); list($siw, $sih, $sit) = getimagesize($destinationPath . $newfileName . '-resized.' . $extension); rename($destinationPath . $newfileName . '-resized.' . $extension, $destinationPath . $newfileName . '-' . $siw . 'x' . $sih . '.' . $extension); $imageInfo = array(); $imageInfo['fileName'] = $destinationPath . $newfileName . '-' . $siw . 'x' . $sih . '.' . $extension; $imageInfo['width'] = $siw; $imageInfo['height'] = $sih; $imageInfo['mimeType'] = $mimeType; $imageObjectInfo['sizes']['large'] = $imageInfo; } if ($source_image_width > 1024) { // || $source_image_height > 768) { Thumbnail::generate_image_thumbnail($destinationPath . $picture, $destinationPath . $newfileName . '-resized.' . $extension, 1024, 768); list($siw, $sih, $sit) = getimagesize($destinationPath . $newfileName . '-resized.' . $extension); rename($destinationPath . $newfileName . '-resized.' . $extension, $destinationPath . $newfileName . '-' . $siw . 'x' . $sih . '.' . $extension); $imageInfo = array(); $imageInfo['fileName'] = $newfileName . '-' . $siw . 'x' . $sih . '.' . $extension; $imageInfo['width'] = $siw; $imageInfo['height'] = $sih; $imageInfo['mimeType'] = $mimeType; $imageObjectInfo['sizes']['medium'] = $imageInfo; } if ($source_image_width > 350) { //|| $source_image_height > 350) { Thumbnail::generate_image_thumbnail($destinationPath . $picture, $destinationPath . $newfileName . '-resized.' . $extension, 350, 350); list($siw, $sih, $sit) = getimagesize($destinationPath . $newfileName . '-resized.' . $extension); rename($destinationPath . $newfileName . '-resized.' . $extension, $destinationPath . $newfileName . '-' . $siw . 'x' . $sih . '.' . $extension); $imageInfo = array(); $imageInfo['fileName'] = $newfileName . '-' . $siw . 'x' . $sih . '.' . $extension; $imageInfo['width'] = $siw; $imageInfo['height'] = $sih; $imageInfo['mimeType'] = $mimeType; $imageObjectInfo['sizes']['small'] = $imageInfo; } if ($source_image_width > 300) { //|| $source_image_height > 350) { Thumbnail::generate_image_thumbnail($destinationPath . $picture, $destinationPath . $newfileName . '-resized.' . $extension, 300, 300); list($siw, $sih, $sit) = getimagesize($destinationPath . $newfileName . '-resized.' . $extension); rename($destinationPath . $newfileName . '-resized.' . $extension, $destinationPath . $newfileName . '-' . $siw . 'x' . $sih . '.' . $extension); $imageInfo = array(); $imageInfo['fileName'] = $newfileName . '-' . $siw . 'x' . $sih . '.' . $extension; $imageInfo['width'] = $siw; $imageInfo['height'] = $sih; $imageInfo['mimeType'] = $mimeType; $imageObjectInfo['sizes']['thumbnail'] = $imageInfo; } // Save image object if ($imageObjectId = ObjectMeta::getValue($object->id, $fieldName)) { $imageObject = Object::find($imageObjectId); } if (empty($imageObject)) { $imageObject = new Object(); } $imageObject->author_id = Auth::user()->id; $imageObject->type = 'image'; $imageObject->name = $newfileName . '.' . $extension; $imageObject->title = $filename; $imageObject->status = 'inherit'; $imageObject->guid = $newfileName; $imageObject->save(); ObjectMeta::setValue($imageObject->id, '_file_path', $newfileName . '.' . $extension); ObjectMeta::setValue($imageObject->id, '_image_info', serialize($imageObjectInfo)); ObjectMeta::setValue($object->id, $fieldName, $imageObject->id); return $imageObject; }
/** * Remove the specified resource from storage. * * @param $id * @return Response */ public function postDelete(DeleteRequest $request, $id) { if ($object = object::find($id)) { $object->delete(); ObjectMeta::where('object_id', $id)->delete(); return redirect('admin/objects')->with('message', 'Type deleted successfully'); } }
echo '<div style="color: cornflowerblue; font-family: Arial, Helvetica, sans-serif;">' . '<div style="float: left; padding: 20px 10px 5px 5px;">' . '<span> #' . $index . '</span>' . '</div>' . '<div style="float: left;">' . '<span>ID: </span>' . $item['id'] . '<br>' . '<span>File name: </span>' . $item['filename'] . '<br>' . '<span>Error message: </span>' . $item['error'] . '</div>' . '</div>'; echo '<br>'; } } } } if ($refreshThisPage) { die('<meta http-equiv="refresh" content="2">'); } else { die('Done!'); } }); /* Crop and resize images */ Route::get('/crop', function () { ini_set('memory_limit', '1G'); $results = \App\ObjectMeta::where('object_meta.meta_key', '_file_path')->join('object_meta AS om', function ($join) { $join->on('object_meta.object_id', '=', 'om.object_id')->where('om.meta_key', '=', '_image_info'); })->join('object_meta AS om2', 'object_meta.object_id', '=', 'om2.meta_value')->join('objects as obj', 'obj.id', '=', 'om2.object_id')->select('object_meta.object_id', 'object_meta.meta_value AS path', 'om2.meta_key AS type', 'om2.object_id AS parentObjectID', 'obj.type AS parentObjectType')->groupBy('path')->get(); // dd($results->get()->toArray()); if (isset($_GET['type']) && $_GET['type'] == 'content') { $content = $results->reject(function (&$v) { $v->info = unserialize($v->info); return $v->type == '_featured_image'; }); ini_set('max_execution_time', 300); $failed = array(); foreach ($content as $image) { $x = autoCrop(0, $image->path, $image->type); // echo $image->path . '<br>'; // echo $image->type . '<br>'; // var_dump($x);
public function getLocations() { $results = $this->getSearchPage(true); $results = $results['items']; // dd($results->toArray()); $data = array(); $locations = array('type' => 1, 'userMsg' => false); if (!empty($results)) { foreach ($results as $result) { if ($lat = ObjectMeta::getValue($result->id, '_field_address-location-g')) { if ($long = ObjectMeta::getValue($result->id, '_field_address-location-k')) { $location = array('id' => $result->id, 'geo_latitude' => $lat, 'geo_longitude' => $long, 'location' => '', 'title' => $result->title, 'name' => $result->name, 'excerpt' => $result->excerpt, 'score' => $result->score); if ($contentImageId = ObjectMeta::getValue($result->id, '_content_image')) { $location['content_image'] = Url('/uploads/' . getImageSrc($contentImageId, 'medium')); } else { $location['content_image'] = ''; } $location['address_street'] = ObjectMeta::getValue($result->id, '_field_address-address'); $location['address_city'] = ObjectMeta::getValue($result->id, '_field_address-city'); $location['address_country'] = ObjectMeta::getValue($result->id, '_field_address-country'); $location['promoted'] = ObjectMeta::getValue($result->id, '_field_promoted'); $data[] = $location; } } } } $options = array(); foreach ($data as &$item) { if (isset($options[$item['geo_latitude'] . '_' . $item['geo_longitude']])) { $options[$item['geo_latitude'] . '_' . $item['geo_longitude']] += 1; $current = $options[$item['geo_latitude'] . '_' . $item['geo_longitude']] - 1; $lat = substr($item['geo_latitude'], -3); if ($lat + $current * 10 < 1000) { $lat = $lat + $current * 10; $subLat = substr($item['geo_latitude'], 0, strlen($item['geo_latitude']) - 3); $item['geo_latitude'] = $subLat . $lat; } else { $lat = substr($item['geo_latitude'], -4); $lat = $lat + $current * 10; $subLat = substr($item['geo_latitude'], 0, strlen($item['geo_latitude']) - 4); $item['geo_latitude'] = $subLat . $lat; } } else { $options[$item['geo_latitude'] . '_' . $item['geo_longitude']] = 1; } } $locations['data'] = $data; return $locations; //return view('partials.map', compact( 'locations' )); }
public function getCategories($id = null) { //Config::set('laravel-debugbar::config.enabled', false); $this->fetchCategories(); foreach ($this->items as $category) { if ($contentImageId = ObjectMeta::getValue($category->id, '_content_image')) { if ($contentImageUrl = getImageSrc($contentImageId)) { // if ($contentImageUrl = getImageSrc($contentImageId, 'medium') ) { $category['contentImageUrl'] = 'cropped/' . getTheImageSize($contentImageUrl, '_content_image'); // $category['contentImageUrl'] = $contentImageUrl; } } if ($featuredImageId = ObjectMeta::getValue($category->id, '_featured_image')) { if ($featuredImageUrl = getImageSrc($featuredImageId)) { // if ($featuredImageUrl = getImageSrc($featuredImageId, 'small')) { $category['featuredImageUrl'] = 'cropped/' . getTheImageSize($featuredImageUrl, '_featured_image'); // $category['featuredImageUrl'] = $featuredImageUrl; } } } $this->itemsParents[0] = []; $categories = $this->itemArray(); $this->items2 = $this->items->getDictionary(); /* $time11 = microtime(true); foreach($this->items2 as $k => &$v) { if($v->items_count) continue; $objects = Object::whereNotIn('objects.type', ['object_type', 'image','category']) ->join('objects as obj', function ($join){ $join->on('obj.name', '=', DB::raw("concat( '_object_type_', objects.type )")); }) ->join('object_meta', function ($join){ $join->on('object_meta.object_id', '=', 'obj.id') ->where('object_meta.meta_key', '=', '_category_id'); }) ->join('objects as cat', function ($join){ $join->on('cat.id', '=', 'object_meta.meta_value'); }) ->where('object_meta.meta_value', $k) ->select('objects.id', 'objects.name') ->limit(2) ; if($objects->count() != 1) continue; $v->url = $objects->first()->toArray(); } $time22 = microtime(true); */ $categories2 = $this->itemArray2(); $this->itemsParents2[0] = []; $breadCrumbs = []; $breadCrumbs[0] = []; foreach ($this->itemsParents as $itemID => $arr) { foreach ($arr as $subK) { $subItem = $this->items->getDictionary()[$subK]; $breadCrumbs[$itemID][] = ['id' => $subK, 'title' => $subItem->title, 'url' => $subItem->name, 'hasItems' => (bool) $subItem->items_count]; } } $currentItem = !$id ? false : ['id' => $id, 'title' => $this->items->getDictionary()[$id]['title'], 'contentImageUrl' => $this->items->getDictionary()[$id]['contentImageUrl'], 'featuredImageUrl' => $this->items->getDictionary()[$id]['featuredImageUrl']]; // echo "script execution time: ".($time22-$time11); //value in seconds return response()->json(['categories' => $categories2, 'parents' => $this->itemsParents, 'breadcrumbs' => $breadCrumbs, 'currentItem' => $currentItem]); }
public static function getFields($id) { return ObjectMeta::where('object_id', $id)->where('meta_key', 'LIKE', '_field_%'); }
public static function getField($id, $name) { return ObjectMeta::where('object_id', $id); //->where('meta_key', '=', '_field_'. $name); }
public function deleteField($id) { if ($field = ObjectMeta::find($id)) { $field->delete(); } }
function addImage($object, $destinationPath, $picture, $filename, $newfileName, $extension, $mimeType, $fieldName) { list($source_image_width, $source_image_height, $source_image_type) = getimagesize($destinationPath . $picture); $imageObjectInfo = array(); $imageObjectInfo['width'] = $source_image_width; $imageObjectInfo['height'] = $source_image_height; $imageObjectInfo['fileName'] = $filename; $imageObjectInfo['filePath'] = $newfileName . '.' . $extension; $imageObjectInfo['sizes'] = array(); $x = autoCrop($destinationPath, $picture, $fieldName); if ($x !== false) { $round = (int) \App\ResizesTinypng::max('round') + 1; insertIntoTableResizes($round, getTheImageSize($picture, $fieldName), $destinationPath . 'cropped/' . getTheImageSize($picture, $fieldName), 0, 'N', 0, false); $results_table = selectByRoundNumber($round); if (!empty($results_table)) { foreach ($results_table as $res_row) { $result_array = array('id' => intval($res_row['id']), 'round' => intval($res_row['round']), 'filename' => $res_row['file_name'], 'path' => $res_row['path'], 'runTiny' => intval($res_row['run_tiny']), 'error' => $res_row['error'], 'timeTiny' => intval($res_row['time_tiny']), 'timeAdded' => intval($res_row['created_at'])); $row_obj = array_to_object($result_array); $error_message = "N"; //START >> tinify images $tmp_path = str_replace(getcwd() . '/', "", $row_obj->path); //GET SERVER PATH $save_path = str_replace($row_obj->filename, "", $tmp_path); //OVERRIDE CURRENT LOCATION $flag = tinifyImage($row_obj->path, $save_path); if ($flag === false) { if ($error_message == "N") { $error_message = "Y - Compression failed"; } else { $error_message .= " - Compression failed"; } } //END << tinify image //UPDATE DB updateTableResizes($row_obj->id, $row_obj->round, $row_obj->filename, $row_obj->path, 1, $error_message, time(), $row_obj->timeAdded); } } } /* if ($source_image_width > 1920) {//} || $source_image_height > 1080) { Thumbnail::generate_image_thumbnail($destinationPath . $picture, $destinationPath . $newfileName . '-resized.'. $extension, 1920, 1080); list($siw, $sih, $sit) = getimagesize($destinationPath . $newfileName . '-resized.'. $extension); rename( $destinationPath . $newfileName . '-resized.'. $extension, $destinationPath . $newfileName . '-'. $siw . 'x'. $sih . '.'. $extension); $imageInfo = array(); $imageInfo['fileName'] = $destinationPath . $newfileName . '-'. $siw . 'x'. $sih . '.'. $extension; $imageInfo['width'] = $siw; $imageInfo['height'] = $sih; $imageInfo['mimeType'] = $mimeType; $imageObjectInfo['sizes']['large'] = $imageInfo; } if ($source_image_width > 1024) { // || $source_image_height > 768) { Thumbnail::generate_image_thumbnail($destinationPath . $picture, $destinationPath . $newfileName . '-resized.'. $extension, 1024, 768); list($siw, $sih, $sit) = getimagesize($destinationPath . $newfileName . '-resized.'. $extension); rename( $destinationPath . $newfileName . '-resized.'. $extension, $destinationPath . $newfileName . '-'. $siw . 'x'. $sih . '.'. $extension); $imageInfo = array(); $imageInfo['fileName'] = $newfileName . '-'. $siw . 'x'. $sih . '.'. $extension; $imageInfo['width'] = $siw; $imageInfo['height'] = $sih; $imageInfo['mimeType'] = $mimeType; $imageObjectInfo['sizes']['medium'] = $imageInfo; } if ($source_image_width > 350) {//|| $source_image_height > 350) { Thumbnail::generate_image_thumbnail($destinationPath . $picture, $destinationPath . $newfileName . '-resized.'. $extension, 350, 350); list($siw, $sih, $sit) = getimagesize($destinationPath . $newfileName . '-resized.'. $extension); rename( $destinationPath . $newfileName . '-resized.'. $extension, $destinationPath . $newfileName . '-'. $siw . 'x'. $sih . '.'. $extension); $imageInfo = array(); $imageInfo['fileName'] = $newfileName . '-'. $siw . 'x'. $sih . '.'. $extension; $imageInfo['width'] = $siw; $imageInfo['height'] = $sih; $imageInfo['mimeType'] = $mimeType; $imageObjectInfo['sizes']['small'] = $imageInfo; } if ($source_image_width > 300) {//|| $source_image_height > 350) { Thumbnail::generate_image_thumbnail($destinationPath . $picture, $destinationPath . $newfileName . '-resized.'. $extension, 300, 300); list($siw, $sih, $sit) = getimagesize($destinationPath . $newfileName . '-resized.'. $extension); rename( $destinationPath . $newfileName . '-resized.'. $extension, $destinationPath . $newfileName . '-'. $siw . 'x'. $sih . '.'. $extension); $imageInfo = array(); $imageInfo['fileName'] = $newfileName . '-'. $siw . 'x'. $sih . '.'. $extension; $imageInfo['width'] = $siw; $imageInfo['height'] = $sih; $imageInfo['mimeType'] = $mimeType; $imageObjectInfo['sizes']['thumbnail'] = $imageInfo; } */ // Save image object if ($imageObjectId = ObjectMeta::getValue($object->id, $fieldName)) { $imageObject = Object::find($imageObjectId); } if (empty($imageObject)) { $imageObject = new Object(); } $imageObject->author_id = Auth::user()->id; $imageObject->type = 'image'; $imageObject->name = $newfileName . '.' . $extension; $imageObject->title = $filename; $imageObject->status = 'inherit'; $imageObject->guid = $newfileName; $imageObject->save(); ObjectMeta::setValue($imageObject->id, '_file_path', $newfileName . '.' . $extension); ObjectMeta::setValue($imageObject->id, '_image_info', serialize($imageObjectInfo)); ObjectMeta::setValue($object->id, $fieldName, $imageObject->id); return $imageObject; }
public function getLocations() { $results = $this->getSearch(); $data = array(); $locations = array('type' => 1, 'userMsg' => false); if (!empty($results)) { foreach ($results as $result) { if ($lat = ObjectMeta::getValue($result->id, '_field_address-location-g')) { if ($long = ObjectMeta::getValue($result->id, '_field_address-location-k')) { $location = array('geo_latitude' => $lat, 'geo_longitude' => $long, 'location' => '', 'title' => $result->title, 'excerpt' => $result->excerpt); if ($contentImageId = ObjectMeta::getValue($result->id, '_content_image')) { $location['content_image'] = Url('/uploads/' . getImageSrc($contentImageId, 'medium')); } else { $location['content_image'] = ''; } $location['address_street'] = ObjectMeta::getValue($result->id, '_field_address-address'); $location['address_city'] = ObjectMeta::getValue($result->id, '_field_address-city'); $location['address_country'] = ObjectMeta::getValue($result->id, '_field_address-country'); $location['promoted'] = ObjectMeta::getValue($result->id, '_field_promoted'); $data[] = $location; } } } } $locations['data'] = $data; return $locations; //return view('partials.map', compact( 'locations' )); }