function index() { list($params, $id, $slug) = $this->parse_params(func_get_args()); // Create or update if ($this->method != 'get') { $c = new Content(); switch ($this->method) { case 'post': case 'put': if ($this->method == 'put') { // Update $c->get_by_id($id); if (!$c->exists()) { $this->error('404', "Content with ID: {$id} not found."); return; } $c->old_published_on = $c->published_on; $c->old_captured_on = $c->captured_on; $c->old_uploaded_on = $c->uploaded_on; if (isset($_POST['slug'])) { $c->current_slug = $c->slug; } } if (isset($_REQUEST['name'])) { if (isset($_REQUEST['upload_session_start'])) { $s = new Setting(); $s->where('name', 'last_upload')->get(); if ($s->exists() && $s->value != $_REQUEST['upload_session_start']) { $s->value = $_REQUEST['upload_session_start']; $s->save(); } } $file_name = $c->clean_filename($_REQUEST['name']); $chunk = isset($_REQUEST["chunk"]) ? $_REQUEST["chunk"] : 0; $chunks = isset($_REQUEST["chunks"]) ? $_REQUEST["chunks"] : 0; $tmp_dir = FCPATH . 'storage' . DIRECTORY_SEPARATOR . 'tmp'; $tmp_path = $tmp_dir . DIRECTORY_SEPARATOR . $file_name; make_child_dir($tmp_dir); if ($chunks == 0 || $chunk == $chunks - 1) { if (isset($_REQUEST['text'])) { $path = FCPATH . 'storage' . DIRECTORY_SEPARATOR . 'custom' . DIRECTORY_SEPARATOR; $internal_id = false; } else { if (isset($_REQUEST['plugin'])) { $info = pathinfo($_REQUEST['name']); $path = FCPATH . 'storage' . DIRECTORY_SEPARATOR . 'plugins' . DIRECTORY_SEPARATOR . $_REQUEST['plugin'] . DIRECTORY_SEPARATOR . 'storage' . DIRECTORY_SEPARATOR; $file_name = $_REQUEST['basename'] . '.' . $info['extension']; $internal_id = false; } else { list($internal_id, $path) = $c->generate_internal_id(); } } if ($path) { $path .= $file_name; if ($chunks == 0) { $tmp_path = $path; } } else { $this->error('500', 'Unable to create directory for upload.'); return; } } // Look for the content type header if (isset($_SERVER["HTTP_CONTENT_TYPE"])) { $contentType = $_SERVER["HTTP_CONTENT_TYPE"]; } else { if (isset($_SERVER["CONTENT_TYPE"])) { $contentType = $_SERVER["CONTENT_TYPE"]; } else { $contentType = ''; } } if (strpos($contentType, "multipart") !== false) { if (isset($_FILES['file']['tmp_name']) && is_uploaded_file($_FILES['file']['tmp_name'])) { $out = fopen($tmp_path, $chunk == 0 ? "wb" : "ab"); if ($out) { // Read binary input stream and append it to temp file $in = fopen($_FILES['file']['tmp_name'], "rb"); if ($in) { while ($buff = fread($in, 4096)) { fwrite($out, $buff); } } else { $this->error('500', 'Unable to read input stream.'); return; } fclose($out); unlink($_FILES['file']['tmp_name']); } else { $this->error('500', 'Unable to write to output file.'); return; } } else { $this->error('500', 'Unable to move uploaded file.'); return; } } else { $out = fopen($tmp_path, $chunk == 0 ? "wb" : "ab"); if ($out) { // Read binary input stream and append it to temp file $in = fopen("php://input", "rb"); if ($in) { while ($buff = fread($in, 4096)) { fwrite($out, $buff); } } else { $this->error('500', 'Unable to read uploaded file.'); return; } fclose($out); } else { $this->error('500', 'Unable to open output stream.'); return; } } if ($chunk < $chunks - 1) { // Don't continue until all chunks are uploaded exit; } else { if ($chunks > 0) { // Done, move to permanent location and save to DB rename($tmp_path, $path); } } if (!$internal_id) { // Custom text uploads can stop here die(json_encode(array('filename' => $file_name))); } $from = array(); $from['filename'] = $file_name; $from['internal_id'] = $internal_id; $from['file_modified_on'] = time(); } else { if (isset($_POST['localfile'])) { $filename = basename($_REQUEST['localfile']); list($internal_id, $path) = $c->generate_internal_id(); if (!file_exists($_REQUEST['localfile'])) { $this->error('500', '"localfile" does not exist.'); return; } if ($path) { $path .= $filename; } else { $this->error('500', 'Unable to create directory for upload.'); return; } copy($_REQUEST['localfile'], $path); $from = array(); $from['filename'] = $filename; $from['internal_id'] = $internal_id; $from['file_modified_on'] = time(); } else { if (isset($_POST['from_url'])) { $filename = basename($_POST['from_url']); list($internal_id, $path) = $c->generate_internal_id(); if ($path) { $path .= $filename; } else { $this->error('500', 'Unable to create directory for upload.'); return; } if ($this->_download(urldecode($_POST['from_url']), $path, true) && file_exists($path)) { $from = array(); $from['filename'] = $filename; $from['internal_id'] = $internal_id; $from['file_modified_on'] = time(); } else { $this->error('500', 'Unable to import file from provided URL.'); return; } } else { if (is_null($id)) { $this->error('403', 'New content records must be accompanied by an upload.'); return; } } } } if (isset($from)) { $from = array_merge($_POST, $from); } else { $from = $_POST; } if (isset($_REQUEST['rotate']) && is_numeric($_REQUEST['rotate']) && $c->exists()) { $r = $_REQUEST['rotate']; if (abs($r) != 90) { $this->error('403', 'Rotation can only be done in multiples of 90.'); return; } if (empty($c->storage_url)) { $path = $c->path_to_original(); $info = pathinfo($path); $midsize_path = preg_replace('/\\.' . $info['extension'] . '$/', '.1600.' . $info['extension'], $path); if (file_exists($midsize_path)) { $midsize = $midsize_path; } } else { $path = tempnam(sys_get_temp_dir(), 'original'); file_put_contents($path, file_get_contents($c->storage_url)); if (!empty($c->storage_url_midsize)) { $midsize = tempnam(sys_get_temp_dir(), 'midsize'); file_put_contents($midsize, file_get_contents($c->storage_url_midsize)); } } $s = new Setting(); $s->where('name', 'image_processing_library')->get(); include_once FCPATH . 'app' . DIRECTORY_SEPARATOR . 'koken' . DIRECTORY_SEPARATOR . 'DarkroomUtils.php'; $d = DarkroomUtils::init($s->value); $d->rotate($path, $r); if (isset($midsize)) { $d->rotate($midsize, $r); } if (!empty($c->storage_url)) { $key = $c->path . '/' . $c->filename; Shutter::store_original($path, $c->path . '/' . $c->filename); unlink($path); if (isset($midsize)) { $info = pathinfo($key); $key = preg_replace('/\\.' . $info['extension'] . '$/', '.1600.' . $info['extension'], $key); Shutter::store_original($midsize, $key); unlink($midsize); } } $c->clear_cache(); $from['width'] = $c->height; $from['height'] = $c->width; $from['aspect_ratio'] = $from['width'] / $from['height']; $from['file_modified_on'] = time(); } if (isset($_REQUEST['reset_internal_id']) && $_REQUEST['reset_internal_id'] && $c->exists()) { list($from['internal_id'], ) = $c->generate_internal_id(true); } $hook = 'content.' . ($id ? 'update' : 'create'); if (isset($from['filename']) && $id) { $c->clear_cache(); $hook .= '_with_upload'; $c->_before(); } $from = Shutter::filter("api.{$hook}", array_merge($from, array('id' => $id, 'file' => isset($path) ? $path : $c->path_to_original()))); unset($from['file']); try { $c->from_array($from, array(), true); } catch (Exception $e) { $this->error('400', $e->getMessage()); return; } if (isset($_POST['tags'])) { $c->_format_tags($_POST['tags']); } else { if ($this->method === 'put' && isset($_POST['visibility'])) { $c->_update_tag_counts(); } } $c->_readify(); $content = $c->to_array(array('auth' => true)); if ($hook === 'content.create' || $hook === 'content.update_with_upload') { if (ENVIRONMENT === 'production') { $this->load->library('mcurl'); if ($this->mcurl->is_enabled()) { $options = array(CURLOPT_HTTPHEADER => array('Connection: Close', 'Keep-Alive: 0')); $this->mcurl->add_call('normal', 'get', $content['presets']['medium_large']['url'], array(), $options); $this->mcurl->add_call('cropped', 'get', $content['presets']['medium_large']['cropped']['url'], array(), $options); $this->mcurl->execute(); } } $external_storage_url = Shutter::store_original($c->path_to_original(), str_replace('/storage/originals/', '', $content['original']['relative_url'])); if ($external_storage_url) { unlink($c->path_to_original()); $o = new Content(); $o->where('id', $content['id'])->update(array('storage_url' => $external_storage_url)); $content['storage_url'] = $external_storage_url; } } Shutter::hook($hook, $content); // Important to prevent failures from Lr plugin header('Connection: close'); $this->redirect("/content/{$c->id}" . (isset($params['context']) ? '/context:' . $params['context'] : '')); break; case 'delete': if (is_null($id)) { $this->error('403', 'Required parameter "id" not present.'); return; } else { $t = new Tag(); if (is_numeric($id)) { $content = $c->get_by_id($id); if ($c->exists()) { $trash = new Trash(); $this->db->query("DELETE from {$trash->table} WHERE id = 'content-{$c->id}'"); $c->do_delete(); } else { $this->error('404', "Content with ID: {$id} not found."); return; } } else { $is_trash = $id === 'trash'; if ($id === 'trash') { $id = array(); $trash = new Trash(); $trash->like('id', 'content-')->select_func('REPLACE', '@id', 'content-', '', 'actual_id')->get_iterated(); foreach ($trash as $item) { $id[] = (int) $item->actual_id; } } else { $id = explode(',', $id); } /* Multiple delete /content/n1/n2/n3 */ // Keep track of tags to -- $tags = array(); $c->where_in('id', $id); $contents = $c->get_iterated(); $trash = new Trash(); foreach ($contents as $c) { if ($c->exists()) { $tags = array_merge($tags, $c->tags); $this->db->query("DELETE from {$trash->table} WHERE id = 'content-{$c->id}'"); $c->do_delete(); } } } } exit; break; } } $c = new Content(); if ($slug || isset($id) && strpos($id, ',') === false) { $options = array('context' => false, 'neighbors' => false); $options = array_merge($options, $params); $original_context = $options['context']; if ($options['context'] && !in_array($options['context'], array('stream', 'favorites', 'features')) && strpos($options['context'], 'tag-') !== 0 && strpos($options['context'], 'category-') !== 0) { if (is_numeric($options['context'])) { $context_field = 'id'; } else { $context_field = 'slug'; $options['context'] = str_replace('slug-', '', $options['context']); } $a = new Album(); $a->group_start()->where($context_field, $options['context'])->or_where('internal_id', $options['context'])->group_end()->get(); $c->include_join_fields()->where_related_album('id', $a->id); } $with_token = false; if (is_numeric($id)) { $content = $c->where('deleted', 0)->get_by_id($id); } else { if ($slug) { $content = $c->where('deleted', 0)->group_start()->where('internal_id', $slug)->or_where('slug', $slug)->or_like('old_slug', ',' . $slug . ',', 'both')->group_end()->get(); } else { $content = $c->where('deleted', 0)->where('internal_id', $id)->get(); } if ($content->exists() && $content->internal_id === (is_null($id) ? $slug : $id)) { $with_token = true; } } if ($content->exists()) { if ($c->visibility == 1 && !$this->auth && !$with_token || !$this->auth && !is_numeric($id) && $c->visibility == 2) { $this->error('403', 'Private content.'); return; } $options['auth'] = $this->auth; if ($options['neighbors']) { // Make sure $neighbors is at least 2 $options['neighbors'] = max($options['neighbors'], 2); // Make sure neighbors is even if ($options['neighbors'] & 1 != 0) { $options['neighbors']++; } $options['neighbors'] = $options['neighbors'] / 2; $single_neighbors = false; } else { $options['neighbors'] = 1; $single_neighbors = true; } if ($options['context'] && !in_array($original_context, array('stream', 'favorites', 'features')) && strpos($original_context, 'tag-') !== 0 && strpos($original_context, 'category-') !== 0) { $options['in_album'] = $a; } $final = $content->to_array($options); if ($options['context']) { // TODO: Performance check $next = new Content(); $prev = new Content(); $in_a = new Album(); $next->where('deleted', 0); $prev->where('deleted', 0); $options['context'] = urldecode($options['context']); if (!in_array($original_context, array('stream', 'favorites', 'features')) && strpos($original_context, 'tag-') !== 0 && strpos($original_context, 'category-') !== 0) { if (!isset($options['context_order'])) { list($options['context_order'], $options['context_order_direction']) = explode(' ', $a->sort); } $final['context']['album'] = $a->to_array(array('auth' => $this->auth || $options['context'] === $a->internal_id)); $in_a->where("{$context_field} !=", $options['context']); $next->where_related_album('id', $a->id); $prev->where_related_album('id', $a->id); if ($options['context_order'] === 'manual') { $next->order_by_join_field('album', 'order', 'ASC')->group_start()->where_join_field('album', 'order >', $content->join_order)->or_group_start()->where_join_field('album', 'order', $content->join_order)->where_join_field('album', 'id >', $content->join_id)->group_end()->group_end(); $prev->order_by_join_field('album', 'order', 'DESC')->group_start()->where_join_field('album', 'order <', $content->join_order)->or_group_start()->where_join_field('album', 'order', $content->join_order)->where_join_field('album', 'id <', $content->join_id)->group_end()->group_end(); } else { $next_operator = strtolower($options['context_order_direction']) === 'desc' ? '<' : '>'; $prev_operator = $next_operator === '<' ? '>' : '<'; $next->group_start()->where($options['context_order'] . " {$next_operator}", $content->{$options['context_order']})->or_group_start()->where($options['context_order'], $content->{$options['context_order']})->where("id {$next_operator}", $content->id)->group_end()->group_end(); $prev->group_start()->where($options['context_order'] . " {$prev_operator}", $content->{$options['context_order']})->or_group_start()->where($options['context_order'], $content->{$options['context_order']})->where("id {$prev_operator}", $content->id)->group_end()->group_end(); } if (!$this->auth) { $next->where('visibility <', $final['context']['album']['visibility'] < 1 ? 1 : 2); $prev->where('visibility <', $final['context']['album']['visibility'] < 1 ? 1 : 2); } $in_album = $a; $final['context']['type'] = 'album'; $final['context']['title'] = $a->title; $final['context']['__koken_url'] = $final['context']['album']['__koken_url']; $final['context']['url'] = $final['context']['album']['url']; } else { if (!isset($options['context_order'])) { $options['context_order'] = 'captured_on'; $options['context_order_direction'] = 'DESC'; } else { if ($options['context_order'] === 'manual' && $original_context === 'favorites') { $options['context_order'] = 'favorite_order'; $options['context_order_direction'] = 'ASC'; } else { if ($options['context_order'] === 'manual' && $original_context === 'features') { $options['context_order'] = 'featured_order'; $options['context_order_direction'] = 'ASC'; } } } $next_operator = strtolower($options['context_order_direction']) === 'desc' ? '<' : '>'; $prev_operator = $next_operator === '<' ? '>' : '<'; $next->group_start()->where($options['context_order'] . " {$next_operator}", $content->{$options['context_order']})->or_group_start()->where($options['context_order'], $content->{$options['context_order']})->where("id {$next_operator}", $content->id)->group_end()->group_end(); $prev->group_start()->where($options['context_order'] . " {$prev_operator}", $content->{$options['context_order']})->or_group_start()->where($options['context_order'], $content->{$options['context_order']})->where("id {$prev_operator}", $content->id)->group_end()->group_end(); if (strpos($original_context, 'tag-') === 0) { $tag = str_replace('tag-', '', urldecode($original_context)); $t = new Tag(); $t->where('name', $tag)->get(); if ($t->exists()) { $next->where_related_tag('id', $t->id); $prev->where_related_tag('id', $t->id); $final['context']['type'] = 'tag'; $final['context']['title'] = $tag; $final['context']['slug'] = $tag; $t->model = 'tag_contents'; $t->slug = $t->name; $url = $t->url(); if ($url) { list($final['context']['__koken_url'], $final['context']['url']) = $url; } } } else { if (strpos($original_context, 'category-') === 0) { $category = str_replace('category-', '', $original_context); $cat = new Category(); $cat->where('slug', $category)->get(); if ($cat->exists()) { $next->where_related_category('id', $cat->id); $prev->where_related_category('id', $cat->id); $final['context']['type'] = 'category'; $final['context']['title'] = $cat->title; $final['context']['slug'] = $cat->slug; $cat->model = 'category_contents'; $url = $cat->url(); if ($url) { list($final['context']['__koken_url'], $final['context']['url']) = $url; } } } else { if ($original_context === 'favorites') { $url_data = $prev->get_data(); $urls = $prev->form_urls(); $next->where('favorite', 1); $prev->where('favorite', 1); $final['context']['type'] = 'favorite'; $final['context']['title'] = $url_data['favorite']['plural']; $final['context']['__koken_url'] = $urls['favorites']; if ($final['context']['__koken_url']) { $final['context']['url'] = $prev->get_base() . $final['context']['__koken_url'] . (defined('DRAFT_CONTEXT') && !is_numeric(DRAFT_CONTEXT) ? '&preview=' . DRAFT_CONTEXT : ''); } } else { if ($original_context === 'features') { $url_data = $prev->get_data(); $urls = $prev->form_urls(); $next->where('featured', 1); $prev->where('featured', 1); $final['context']['type'] = 'feature'; $final['context']['title'] = $url_data['feature']['plural']; $final['context']['__koken_url'] = isset($urls['features']) ? $urls['features'] : false; if ($final['context']['__koken_url']) { $final['context']['url'] = $prev->get_base() . $final['context']['__koken_url'] . (defined('DRAFT_CONTEXT') && !is_numeric(DRAFT_CONTEXT) ? '&preview=' . DRAFT_CONTEXT : ''); } } } } } if (!$this->auth) { $next->where('visibility', 0); $prev->where('visibility', 0); } $in_album = false; } $max = $next->get_clone()->count(); $min = $prev->get_clone()->count(); $final['context']['total'] = $max + $min + 1; $final['context']['position'] = $min + 1; $pre_limit = $next_limit = $options['neighbors']; if ($min < $pre_limit) { $next_limit += $pre_limit - $min; $pre_limit = $min; } if ($max < $next_limit) { $pre_limit = min($min, $pre_limit + ($next_limit - $max)); $next_limit = $max; } $final['context']['previous'] = array(); $final['context']['next'] = array(); if ($next_limit > 0) { if ($options['context_order'] !== 'manual') { $next->order_by($options['context_order'] . ' ' . $options['context_order_direction'] . ', id ' . $options['context_order_direction']); } $next->limit($next_limit)->get_iterated(); foreach ($next as $c) { $final['context']['next'][] = $c->to_array(array('auth' => $this->auth, 'in_album' => $in_album, 'context' => $original_context)); } } if ($pre_limit > 0) { if ($options['context_order'] !== 'manual') { $dir = strtolower($options['context_order_direction']) === 'desc' ? 'asc' : 'desc'; $prev->order_by($options['context_order'] . ' ' . $dir . ', id ' . $dir); } $prev->limit($pre_limit)->get_iterated(); foreach ($prev as $c) { $final['context']['previous'][] = $c->to_array(array('auth' => $this->auth, 'in_album' => $in_album, 'context' => $original_context)); } $final['context']['previous'] = array_reverse($final['context']['previous']); } } } else { $this->error('404', "Content with ID: {$id} not found."); return; } } else { if (isset($params['custom'])) { $final = $c->to_array_custom($params['custom']); } else { $c->where('deleted', 0); $params['auth'] = $this->auth; $final = $c->listing($params, $id); } } $this->set_response_data($final); }
public function update() { $this->load->library('form_validation'); $this->form_validation->set_rules('category[name]', 'lang:admin_categories_form_field_category_name', 'required'); $this->form_validation->set_rules('category[parent_id]', 'lang:admin_categories_form_field_parent_category', 'required'); $this->form_validation->set_rules('category_id', 'id', 'required'); if ($this->form_validation->run()) { $categori_id = $this->input->post('category_id'); $category = new Category(); $category->get_by_id($categori_id); if ($category->exists()) { $category_data = $this->input->post('category'); $category->name = $category_data['name']; $this->_transaction_isolation(); $this->db->trans_begin(); $cansave = TRUE; if ($category_data['parent_id'] == 'root') { $category->parent_id = NULL; } else { $parent = new Category(); $parent->get_by_id(intval($category_data['parent_id'])); if (!$parent->exists()) { $cansave = FALSE; } else { $category->parent_id = intval($category_data['parent_id']); } } if ($cansave && $category->save() && $this->db->trans_status()) { $this->db->trans_commit(); $this->messages->add_message('lang:admin_categories_flash_message_save_successful', Messages::MESSAGE_TYPE_SUCCESS); } else { $this->db->trans_rollback(); $this->messages->add_message('lang:admin_categories_flash_message_save_failed', Messages::MESSAGE_TYPE_ERROR); } } else { $this->messages->add_message('lang:admin_categories_error_category_not_found', Messages::MESSAGE_TYPE_ERROR); } redirect(create_internal_url('admin_categories/index')); } else { $this->edit(); } }
function listing($params, $id = false) { $sort = $this->_get_site_order('content'); $options = array('order_by' => $sort['by'], 'order_direction' => $sort['direction'], 'search' => false, 'search_filter' => false, 'tags' => false, 'tags_not' => false, 'page' => 1, 'match_all_tags' => false, 'limit' => 100, 'include_presets' => true, 'featured' => null, 'types' => false, 'auth' => false, 'favorites' => null, 'before' => false, 'after' => false, 'after_column' => 'uploaded_on', 'before_column' => 'uploaded_on', 'category' => false, 'category_not' => false, 'year' => false, 'year_not' => false, 'month' => false, 'month_not' => false, 'day' => false, 'day_not' => false, 'in_album' => false, 'reduce' => false, 'is_cover' => true, 'independent' => false); $options = array_merge($options, $params); if (isset($params['order_by']) && !isset($params['order_direction'])) { $options['order_direction'] = in_array($params['order_by'], array('title', 'filename')) ? 'ASC' : 'DESC'; } Shutter::hook('content.listing', array($this, $options)); if ($options['featured'] == 1 && !isset($params['order_by'])) { $options['order_by'] = 'featured_on'; } else { if ($options['favorites'] == 1 && !isset($params['order_by'])) { $options['order_by'] = 'favorited_on'; } } if ($options['auth']) { if (isset($options['visibility']) && $options['visibility'] !== 'album') { $values = array('public', 'unlisted', 'private'); if (in_array($options['visibility'], $values)) { $options['visibility'] = array_search($options['visibility'], $values); } else { if ($options['visibility'] === 'any') { $options['visibility'] = false; } else { $options['visibility'] = 0; } } } else { if (!isset($options['visibility']) || $options['visibility'] !== 'album') { $options['visibility'] = 0; } } } else { if ($options['in_album']) { $options['visibility'] = 'album'; } else { $options['visibility'] = 0; } } if ($options['visibility'] > 0 && $options['order_by'] === 'published_on') { $options['order_by'] = 'captured_on'; } if ($options['order_by'] == 'dimension') { $options['order_by'] = 'width * height'; } if (is_numeric($options['limit']) && $options['limit'] > 0) { $options['limit'] = min($options['limit'], 100); } else { $options['limit'] = 100; } if ($options['independent']) { $this->where_related('album', 'id', null); } if ($options['types']) { $types = explode(',', str_replace(' ', '', $options['types'])); $this->group_start(); foreach ($types as $t) { switch ($t) { case 'photo': $this->or_where('file_type', 0); break; case 'video': $this->or_where('file_type', 1); break; case 'audio': $this->or_where('file_type', 2); break; } } $this->group_end(); } if ($options['search'] && $options['search_filter'] === 'tags') { $options['tags'] = $options['search']; $options['search'] = false; } if ($options['search']) { $term = urldecode($options['search']); if ($options['search_filter']) { if ($options['search_filter'] === 'category') { $cat = new Category(); $cat->where('title', $term)->get(); if ($cat->exists()) { $this->where_related('category', 'id', $cat->id); } else { $this->where_related('category', 'id', 0); } } else { $this->group_start(); $this->like($options['search_filter'], $term, 'both'); $this->group_end(); } } else { $this->group_start(); $this->like('title', $term, 'both'); $this->or_like('caption', $term, 'both'); $t = new Tag(); $t->where('name', $term)->get(); if ($t->exists()) { $this->or_where_related('tag', 'id', $t->id); } $this->group_end(); } } else { if ($options['tags'] || $options['tags_not']) { $this->_do_tag_filtering($options); } } if (!is_null($options['featured'])) { $this->where('featured', $options['featured']); } if (!is_null($options['favorites'])) { $this->where('favorite', $options['favorites']); } if ($options['category']) { $this->where_related('category', 'id', $options['category']); } else { if ($options['category_not']) { $cat = new Content(); $cat->select('id')->where_related('category', 'id', $options['category_not'])->get_iterated(); $cids = array(); foreach ($cat as $c) { $cids[] = $c->id; } $this->where_not_in('id', $cids); } } if ($options['after']) { $this->where($options['after_column'] . ' >=', $options['after']); } if ($options['before']) { $this->where($options['before_column'] . ' <=', $options['before']); } if ($options['visibility'] === 'album') { $this->where('visibility <', $options['in_album']->visibility + 1); } else { if ($options['visibility'] !== false) { $this->where('visibility', $options['visibility']); } } if ($id) { $sql_order = "ORDER BY FIELD(id,{$id})"; $id = explode(',', $id); $this->where_in('id', $id); } if ($options['order_by'] === 'captured_on' || $options['order_by'] === 'uploaded_on' || $options['order_by'] === 'modified_on' || $options['order_by'] === 'published_on') { $bounds_order = $options['order_by']; } else { $bounds_order = 'published_on'; } $s = new Setting(); $s->where('name', 'site_timezone')->get(); $tz = new DateTimeZone($s->value); $offset = $tz->getOffset(new DateTime('now', new DateTimeZone('UTC'))); if ($offset === 0) { $shift = ''; } else { $shift = ($offset < 0 ? '-' : '+') . abs($offset); } // Do this before date filters are applied $bounds = $this->get_clone()->select('COUNT(DISTINCT ' . $this->table . '.id) as count, MONTH(FROM_UNIXTIME(' . $bounds_order . $shift . ')) as month, YEAR(FROM_UNIXTIME(' . $bounds_order . $shift . ')) as year')->group_by('month,year')->order_by('year')->get_iterated(); $dates = array(); foreach ($bounds as $b) { if (!is_numeric($b->year)) { continue; } if (!isset($dates[$b->year])) { $dates[$b->year] = array(); } $dates[$b->year][$b->month] = (int) $b->count; } if (in_array($options['order_by'], array('captured_on', 'uploaded_on', 'modified_on'))) { $date_col = $options['order_by']; } else { $date_col = 'published_on'; } if ($options['year'] || $options['year_not']) { if ($options['year_not']) { $options['year'] = $options['year_not']; $compare = ' !='; } else { $compare = ''; } $this->where('YEAR(FROM_UNIXTIME(' . $date_col . $shift . '))' . $compare, $options['year']); } if ($options['month'] || $options['month_not']) { if ($options['month_not']) { $options['month'] = $options['month_not']; $compare = ' !='; } else { $compare = ''; } $this->where('MONTH(FROM_UNIXTIME(' . $date_col . $shift . '))' . $compare, $options['month']); } if ($options['day'] || $options['day_not']) { if ($options['day_not']) { $options['day'] = $options['day_not']; $compare = ' !='; } else { $compare = ''; } $this->where('DAY(FROM_UNIXTIME(' . $date_col . $shift . '))' . $compare, $options['day']); if ($options['reduce']) { $a = new Album(); $a->select('id')->where('deleted', 0)->where('visibility', 0)->where('YEAR(FROM_UNIXTIME(' . $a->table . '.published_on' . $shift . '))', $options['year'])->where('MONTH(FROM_UNIXTIME(' . $a->table . '.published_on' . $shift . '))', $options['month'])->where('DAY(FROM_UNIXTIME(' . $a->table . '.published_on' . $shift . '))', $options['day'])->include_related('content', 'id')->get_iterated(); $ids = array(); foreach ($a as $album) { if ($album->content_id) { $ids[] = $album->content_id; } } $e = new Text(); $e->select('featured_image_id')->where('page_type', 0)->where('published', 1)->where('featured_image_id >', 0)->where('YEAR(FROM_UNIXTIME(' . $e->table . '.published_on' . $shift . '))', $options['year'])->where('MONTH(FROM_UNIXTIME(' . $e->table . '.published_on' . $shift . '))', $options['month'])->where('DAY(FROM_UNIXTIME(' . $e->table . '.published_on' . $shift . '))', $options['day'])->get_iterated(); foreach ($e as $essay) { if ($essay->featured_image_id) { $ids[] = $essay->featured_image_id; } } if (!empty($ids)) { $this->where_not_in('id', $ids); } } } $vid_count = $this->get_clone()->where('file_type', 1)->count(); $aud_count = $this->get_clone()->where('file_type', 2)->count(); $final = $this->paginate($options); $final['dates'] = $dates; $this->include_related_count('albums', NULL, array('visibility' => 0)); $this->include_related_count('categories'); if ($id && !isset($params['order_by'])) { $q = explode('LIMIT', $this->get_sql()); $query = $q[0] . $sql_order . ' LIMIT ' . $q[1]; $data = $this->query($query); } else { if ($options['order_by'] === 'title') { $q = explode('LIMIT', $this->get_sql()); $query = preg_replace('/SELECT\\s(`[^`]+`\\.\\*)/', "SELECT COALESCE(NULLIF(title, ''), filename) as order_title, \$1", $q[0]); $query .= 'ORDER BY order_title ' . $options['order_direction'] . ' LIMIT ' . $q[1]; $data = $this->query($query); } else { $data = $this->order_by($options['order_by'] . ' ' . $options['order_direction'] . ', id ' . $options['order_direction'])->get_iterated(); } } if (!$options['limit']) { $final['per_page'] = $data->result_count(); $final['total'] = $data->result_count(); } $final['counts'] = array('videos' => $vid_count, 'audio' => $aud_count, 'images' => $final['total'] - $vid_count - $aud_count, 'total' => $final['total']); $final['content'] = array(); $final['sort'] = $sort; $tag_map = $this->_eager_load_tags($data); foreach ($data as $content) { $tags = isset($tag_map['c' . $content->id]) ? $tag_map['c' . $content->id] : array(); $options['eager_tags'] = $tags; $final['content'][] = $content->to_array($options); } return $final; }
function index() { list($params, $id, $slug) = $this->parse_params(func_get_args()); // Create or update if ($this->method != 'get') { $c = new Category(); switch ($this->method) { case 'post': case 'put': if ($this->method == 'put') { if (is_null($id)) { $this->error('403', 'Required parameter "id" not present.'); return; } // Update $c->get_by_id($id); if (!$c->exists()) { $this->error('404', "Category with ID: {$id} not found."); return; } } // Don't allow these fields to be saved generically $private = array('album_count', 'content_count', 'text_count'); foreach ($private as $p) { unset($_POST[$p]); } if (!$c->from_array($_POST, array(), true)) { // TODO: More info $this->error('500', 'Save failed.'); return; } $this->redirect("/categories/{$c->id}"); break; case 'delete': if (is_null($id)) { $this->error('403', 'Required parameter "id" not present.'); return; } else { if (is_numeric($id)) { $category = $c->get_by_id($id); $title = $category->title; if ($category->exists()) { $s = new Slug(); $this->db->query("DELETE FROM {$s->table} WHERE id = 'category.{$category->slug}'"); if (!$category->delete()) { // TODO: More info $this->error('500', 'Delete failed.'); return; } $id = null; } else { $this->error('404', "Category with ID: {$id} not found."); return; } } else { $id = explode(',', $id); $c->where_in('id', $id); $cats = $c->get_iterated(); foreach ($cats as $c) { if ($c->exists()) { $s = new Slug(); $this->db->query("DELETE FROM {$s->table} WHERE id = 'category.{$c->slug}'"); $c->delete(); } } } } exit; break; } } $c = new Category(); // No id, so we want a list if (is_null($id) && !$slug) { $final = $c->listing($params); } else { if (!is_null($id)) { $category = $c->get_by_id($id); } else { if ($slug) { $category = $c->where('slug', $slug)->get(); } } if ($category->exists()) { $options = array('page' => 1, 'limit' => 50); $options = array_merge($options, $params); $category_arr = $category->to_array($options); $options['category'] = $category->id; list($final, $counts) = $this->aggregate('category', $options); $prev = new Category(); $next = new Category(); $prev->where('title <', $category->title)->where_func('', array('@content_count', '+', '@text_count', '+', '@album_count', '>', 0), null)->order_by('title DESC, id DESC'); $next->where('title >', $category->title)->where_func('', array('@content_count', '+', '@text_count', '+', '@album_count', '>', 0), null)->order_by('title ASC, id ASC'); $max = $next->get_clone()->count(); $min = $prev->get_clone()->count(); $context = array('total' => $max + $min + 1, 'position' => $min + 1); $prev->limit(1)->get(); $next->limit(1)->get(); unset($options['category']); if ($prev->exists()) { $context['previous'] = array($prev->to_array($options)); } else { $context['previous'] = array(); } if ($next->exists()) { $context['next'] = array($next->to_array($options)); } else { $context['next'] = array(); } $final = array_merge($category_arr, $final); $final['counts'] = $counts; $final['context'] = $context; } else { $this->error('404', "Category with ID: {$id} not found."); return; } } $this->set_response_data($final); }
function listing($params) { $sort = $this->_get_site_order('album'); $options = array('trash' => false, 'page' => 1, 'order_by' => $sort['by'], 'order_direction' => $sort['direction'], 'search' => false, 'search_filter' => false, 'tags' => false, 'tags_not' => false, 'match_all_tags' => false, 'limit' => false, 'include_empty' => true, 'types' => false, 'featured' => false, 'category' => false, 'category_not' => false, 'year' => false, 'year_not' => false, 'month' => false, 'month_not' => false, 'day' => false, 'day_not' => false, 'flat' => false, 'reduce' => false, 'id_not' => false, 'auth' => false); $options = array_merge($options, $params); if (isset($params['order_by']) && !isset($params['order_direction'])) { $options['order_direction'] = in_array($params['order_by'], array('created_on', 'modified_on', 'published_on', 'total_count', 'image_count', 'video_count')) ? 'DESC' : 'ASC'; } $options = Shutter::filter('api.albums.listing.options', $options); Shutter::hook('albums.listing', array($this, $options)); if ($options['order_by'] === 'manual') { $options['order_by'] = 'left_id'; if (!isset($params['order_direction'])) { $options['order_direction'] = 'asc'; } } if ($options['featured'] == 1 && !isset($params['order_by'])) { $options['order_by'] = 'featured_on'; } if (!is_numeric($options['limit'])) { $options['limit'] = false; } if ($options['types']) { $types = explode(',', str_replace(' ', '', $options['types'])); $this->group_start(); foreach ($types as $t) { switch ($t) { case 'set': $this->or_where('album_type', 2); break; case 'smart': $this->or_where('album_type', 1); break; case 'standard': $this->or_where('album_type', 0); break; } } $this->group_end(); } if ($options['search'] && $options['search_filter'] === 'tags') { $options['tags'] = $options['search']; $options['search'] = false; } if ($options['search']) { $term = urldecode($options['search']); if ($options['search_filter']) { if ($options['search_filter'] === 'category') { $cat = new Category(); $cat->where('title', $term)->get(); if ($cat->exists()) { $this->where_related('category', 'id', $cat->id); } else { $this->where_related('category', 'id', 0); } } else { $this->group_start(); $this->like($options['search_filter'], $term, 'both'); $this->group_end(); } } else { $this->group_start(); $this->like('title', $term, 'both'); $this->or_like('description', $term, 'both'); $t = new Tag(); $t->where('name', $term)->get(); if ($t->exists()) { $this->or_where_related('tag', 'id', $t->id); } $this->group_end(); } } else { if ($options['tags'] || $options['tags_not']) { $this->_do_tag_filtering($options); } } if ($options['id_not']) { $this->where_not_in('id', explode(',', $options['id_not'])); } $sub_list = false; if ($this->exists()) { $sub_list = true; $this->where('left_id >', $this->left_id)->where('right_id <', $this->right_id)->where('level', $this->level + 1)->where('visibility', $this->visibility); $options['visibility'] = $this->visibility; } else { if ($options['auth']) { if (isset($options['visibility'])) { $values = array('public', 'unlisted', 'private'); if (in_array($options['visibility'], $values)) { $options['visibility'] = array_search($options['visibility'], $values); } else { $options['visibility'] = 0; } } else { $options['visibility'] = 0; } } else { $options['visibility'] = 0; } } $this->where('visibility', $options['visibility']); if ($options['visibility'] > 0 && ($options['order_by'] === 'manual' || $options['order_by'] === 'published_on')) { $options['order_by'] = 'title'; } if (!$options['include_empty']) { $this->where('total_count >', 0); } if ($options['featured'] || $options['category'] || $options['category_not']) { if ($options['featured']) { $this->where('featured', 1); } if ($options['category']) { $this->where_related('category', 'id', $options['category']); } else { if ($options['category_not']) { $cat = new Album(); $cat->select('id')->where_related('category', 'id', $options['category_not'])->get_iterated(); $cids = array(); foreach ($cat as $c) { $cids[] = $c->id; } $this->where_not_in('id', $cids); } } } else { if ($options['featured'] !== false && (int) $options['featured'] === 0) { $this->where('featured', 0); } else { if (!$sub_list && !$options['category'] && !$options['tags'] && !$options['year'] && !$options['flat']) { $this->where('level', 1); } } } if ($options['order_by'] === 'left_id' && ($options['tags'] || $options['year'])) { $options['order_by'] = 'title,id'; $options['order_direction'] = 'asc'; } if (in_array($options['order_by'], array('created_on', 'modified_on'))) { $date_col = $options['order_by']; } else { $date_col = 'published_on'; } $s = new Setting(); $s->where('name', 'site_timezone')->get(); $tz = new DateTimeZone($s->value); $offset = $tz->getOffset(new DateTime('now', new DateTimeZone('UTC'))); if ($offset === 0) { $shift = ''; } else { $shift = ($offset < 0 ? '-' : '+') . abs($offset); } if ($options['year'] || $options['year_not']) { if ($options['year_not']) { $options['year'] = $options['year_not']; $compare = ' !='; } else { $compare = ''; } $this->where('YEAR(FROM_UNIXTIME(' . $this->table . '.' . $date_col . $shift . '))' . $compare, $options['year']); } if ($options['month'] || $options['month_not']) { if ($options['month_not']) { $options['month'] = $options['month_not']; $compare = ' !='; } else { $compare = ''; } $this->where('MONTH(FROM_UNIXTIME(' . $this->table . '.' . $date_col . $shift . '))' . $compare, $options['month']); } if ($options['day'] || $options['day_not']) { if ($options['day_not']) { $options['day'] = $options['day_not']; $compare = ' !='; } else { $compare = ''; } $this->where('DAY(FROM_UNIXTIME(' . $this->table . '.' . $date_col . $shift . '))' . $compare, $options['day']); if ($options['reduce']) { $e = new Text(); $e->select('id')->where('page_type', 0)->where('published', 1)->where('YEAR(FROM_UNIXTIME(' . $this->table . '.published_on' . $shift . '))', $options['year'])->where('MONTH(FROM_UNIXTIME(' . $this->table . '.published_on' . $shift . '))', $options['month'])->where('DAY(FROM_UNIXTIME(' . $this->table . '.published_on' . $shift . '))', $options['day'])->include_related('album', 'id')->get_iterated(); $ids = array(); foreach ($e as $essay) { if ($essay->album_id) { $ids[] = $essay->album_id; } } if (!empty($ids)) { $this->where_not_in('id', $ids); } $tops = $this->get_clone()->where('album_type', 2)->get_iterated(); $lefts = array(); foreach ($tops as $set) { if ($set->right_id - $set->left_id > 1) { $lefts = array_merge($lefts, range($set->left_id + 1, $set->right_id - 1)); } } if (!empty($lefts)) { $this->where_not_in('left_id', $lefts); } } } $this->where('deleted', (int) $options['trash']); $set_count = $this->get_clone()->where('album_type', 2)->count(); $final = $this->paginate($options); $this->include_related_count('text'); $this->include_related_count('categories'); if (preg_match('/_on$/', $options['order_by'])) { $options['order_by'] .= ' ' . $options['order_direction'] . ',id ' . $options['order_direction']; } else { $options['order_by'] .= ' ' . $options['order_direction']; } $data = $this->order_by($options['order_by'])->get_iterated(); if (!$options['limit']) { $final['per_page'] = $data->result_count(); $final['total'] = $data->result_count(); } $final['counts'] = array('albums' => $final['total'] - $set_count, 'sets' => $set_count, 'total' => $final['total']); $final['albums'] = array(); $final['sort'] = $sort; $tag_map = $this->_eager_load_tags($data); foreach ($data as $album) { $tags = isset($tag_map['c' . $album->id]) ? $tag_map['c' . $album->id] : array(); $params['eager_tags'] = $tags; $params['include_parent'] = !$sub_list; $final['albums'][] = $album->to_array($params); } return $final; }
function index() { list($params, $id, $slug) = $this->parse_params(func_get_args()); $params['auth'] = $this->auth; // Create or update if ($this->method != 'get') { $t = new Text(); switch ($this->method) { case 'post': case 'put': if ($id) { $t->get_by_id($id); $t->old_published = $t->published; $t->current_slug = $t->slug; if (isset($_POST['unpublish'])) { $_POST['published'] = 0; $_POST['published_on'] = null; } } else { if (isset($_POST['page_type']) && $_POST['page_type'] === 'page') { $_POST['published'] = 1; } } $arr = $_POST; global $raw_input_data; if (isset($raw_input_data['content'])) { $arr['content'] = $raw_input_data['content']; } if (isset($raw_input_data['draft'])) { $arr['draft'] = $raw_input_data['draft']; } // Little hack here to make sure content validation is always run // (newline gets stripped in text->_format_content) if (isset($arr['content'])) { $arr['content'] .= "\n"; } try { $t->from_array($arr, array(), true); } catch (Exception $e) { $this->error('400', $e->getMessage()); return; } if (isset($_POST['tags'])) { $t->_format_tags($_POST['tags']); } else { if ($this->method === 'put' && isset($_POST['published'])) { $t->_update_tag_counts(); } } $arr = $t->to_array(array('expand' => true)); if ($id) { Shutter::hook('text.update', $arr); } else { Shutter::hook('text.create', $arr); } $this->redirect("/text/{$t->id}" . (isset($params['render']) ? '/render:' . $params['render'] : '')); break; case 'delete': if (is_null($id)) { $this->error('403', 'Required parameter "id" not present.'); return; } else { if (is_numeric($id)) { $id = array($id); } else { $id = explode(',', $id); } $tags = array(); foreach ($id as $text_id) { $text = $t->get_by_id($text_id); if ($text->exists()) { $tags = array_merge($tags, $text->tags); $s = new Slug(); $prefix = $text->page_type == 0 ? 'essay' : 'page'; $this->db->query("DELETE FROM {$s->table} WHERE id = '{$prefix}.{$text->slug}'"); Shutter::hook('text.delete', $text->to_array(array('auth' => true))); if (!$text->delete()) { // TODO: More info $this->error('500', 'Delete failed.'); return; } } } } exit; break; } } $p = new Text(); // No id, so we want a list if (is_null($id) && !$slug) { $params['state'] = 'published'; $final = $p->listing($params); } else { if (!is_null($id)) { if (is_numeric($id)) { $page = $p->get_by_id($id); } else { $this->auth = $params['auth'] = true; $page = $p->get_by_internal_id($id); } } else { if ($slug) { $p->group_start()->where('slug', $slug)->or_like('old_slug', ',' . $slug . ',', 'both')->group_end(); if (isset($params['type'])) { $p->where('page_type', $params['type'] === 'essay' ? 0 : 1); } $page = $p->get(); } } $params['expand'] = true; if ($page->exists()) { $final = $page->to_array($params); if (!$this->auth && !$final['published']) { $this->error('404', 'Not found'); return; } } else { $this->error('404', "Text with ID: {$id} not found."); return; } if ($final['page_type'] === 'essay' && $page->published) { $options = array('neighbors' => false, 'context' => false); $options = array_merge($options, $params); if ($options['neighbors']) { // Make sure $neighbors is at least 2 $options['neighbors'] = max($options['neighbors'], 2); // Make sure neighbors is even if ($options['neighbors'] & 1 != 0) { $options['neighbors']++; } $options['neighbors'] = $options['neighbors'] / 2; } else { $options['neighbors'] = 1; } if ($options['neighbors']) { // TODO: Performance check $next = new Text(); $prev = new Text(); $to_arr_options = array('auth' => $this->auth); $next->group_start()->where('page_type', 0)->where('published', 1)->group_start()->where('published_on <', $page->published_on)->or_group_start()->where('published_on =', $page->published_on)->where('id <', $page->id)->group_end()->group_end()->group_end(); $prev->group_start()->where('page_type', 0)->where('published', 1)->group_start()->where('published_on >', $page->published_on)->or_group_start()->where('published_on =', $page->published_on)->where('id >', $page->id)->group_end()->group_end()->group_end(); if (strpos($options['context'], 'tag-') === 0) { $tag = str_replace('tag-', '', urldecode($options['context'])); $t = new Tag(); $t->where('name', $tag)->get(); $to_arr_options['context'] = "tag-{$tag}"; if ($t->exists()) { $next->where_related_tag('id', $t->id); $prev->where_related_tag('id', $t->id); $final['context']['type'] = 'tag'; $final['context']['title'] = $tag; $final['context']['slug'] = $tag; $t->model = 'tag_essays'; $t->slug = $t->name; $url = $t->url(); if ($url) { list($final['context']['__koken_url'], $final['context']['url']) = $url; } } } else { if (strpos($options['context'], 'category-') === 0) { $category = str_replace('category-', '', $options['context']); $cat = new Category(); $cat->where('slug', $category)->get(); if ($cat->exists()) { $next->where_related_category('id', $cat->id); $prev->where_related_category('id', $cat->id); $final['context']['type'] = 'category'; $final['context']['title'] = $cat->title; $final['context']['slug'] = $cat->slug; $to_arr_options['context'] = "category-{$cat->id}"; $cat->model = 'category_essays'; $url = $cat->url(); if ($url) { list($final['context']['__koken_url'], $final['context']['url']) = $url; } } } } $max = $next->get_clone()->count(); $min = $prev->get_clone()->count(); $final['context']['total'] = $max + $min + 1; $final['context']['position'] = $min + 1; $pre_limit = $next_limit = $options['neighbors']; if ($min < $pre_limit) { $next_limit += $pre_limit - $min; $pre_limit = $min; } if ($max < $next_limit) { $pre_limit = min($min, $pre_limit + ($next_limit - $max)); $next_limit = $max; } $final['context']['previous'] = array(); $final['context']['next'] = array(); if ($next_limit > 0) { $next->order_by('published_on DESC, id DESC')->limit($next_limit); $next->get_iterated(); foreach ($next as $c) { $final['context']['next'][] = $c->to_array($to_arr_options); } } if ($pre_limit > 0) { $prev->order_by('published_on ASC, id ASC')->limit($pre_limit); $prev->get_iterated(); foreach ($prev as $c) { $final['context']['previous'][] = $c->to_array($to_arr_options); } $final['context']['previous'] = array_reverse($final['context']['previous']); } } } } $this->set_response_data($final); }
function delete($id = NULL) { //filter & Sanitize $id $id = $id != 0 ? filter_var($id, FILTER_VALIDATE_INT) : NULL; //redirect if it´s no correct if (!$id) { $this->session->set_flashdata('message', array('type' => 'warning', 'text' => lang('web_object_not_exit'))); redirect('admin/categories/'); } //search the item to delete if (Category::exists($id)) { $category = Category::find($id); } else { $this->session->set_flashdata('message', array('type' => 'warning', 'text' => lang('web_object_not_exit'))); redirect('admin/categories/'); } //delete the item if ($category->delete() == TRUE) { $this->session->set_flashdata('message', array('type' => 'success', 'text' => lang('web_delete_success'))); } else { $this->session->set_flashdata('message', array('type' => 'error', 'text' => lang('web_delete_failed'))); } if ($category->category_id) { redirect('admin/categories/' . $category->category_id); } else { redirect('admin/categories'); } }
/** * Will test the build of the more comples many-to-many and the case where there is more than one relationships. */ public function testComplexBuild() { self::reset(); fFixture::setDatabase(fORMDatabase::retrieve()); $fixture = fFixture::create(FIXTURES_ROOT); // includes: categories.json, products.json, users.json, shops.json and the join table categories_products.json $fixture->build(); $shop = new Shop(1); $user = new User(1); $category = new Category(1); $product = new Product(1); $this->assertTrue($shop->exists()); $this->assertTrue($user->exists()); $this->assertTrue($category->exists()); $this->assertTrue($product->exists()); // Shop has manu users and products $this->assertEquals(1, $shop->buildUsers()->count()); $this->assertEquals(1, $shop->buildProducts()->count()); // User and product has a shop $this->assertTrue($user->createShop()->exists()); $this->assertTrue($product->createShop()->exists()); // Product and category has many of eachother $this->assertEquals(1, $product->buildCategories()->count()); $this->assertEquals(1, $category->buildProducts()->count()); }
function list_import_lamsfet_tasks_labels_relations($tasks, $labels, $tasks_labels) { echo 'Starting task_category_rel import (' . count($tasks_labels) . ') ['; if (count($tasks_labels)) { foreach ($tasks_labels as $relation) { $task_id = $tasks[$relation->task_id]->_list_id; $category_id = $labels[$relation->label_id]->_list_id; $task = new Task(); $task->get_by_id(intval($task_id)); $category = new Category(); $category->get_by_id(intval($category_id)); if ($task->exists() && $category->exists()) { $task->save($category); } else { echo ' ( CATEGORY OR TASK NOT FOUND ' . $task_id . '(' . $relation->task_id . ')/' . $category_id . '(' . $relation->label_id . ') ) '; } echo '.'; } } echo '] ... done' . "\n"; }