/**
* Replace all of the category pairs with the correct data.
*
* @param String The tagdata to be parsed
* @param Object The channel parser object
* @param Mixed The results from the preparse method
*
* @return String The processed tagdata
*/
public function replace($tagdata, EE_Channel_data_parser $obj, $cat_chunk)
{
$data = $obj->row();
$prefix = $obj->prefix();
$categories = $obj->data('categories', array());
$tagname = $prefix . 'categories';
// Check to see if the category chunks still exist; if not, check
// the tagdata in case they've been modified since pre-processing
foreach ($cat_chunk as $chunk) {
if (strpos($tagdata, $chunk[2]) === FALSE) {
$cat_chunk = $this->_get_cat_chunks($tagdata, $prefix);
$obj->preparsed()->set_once_data($this, $cat_chunk);
break;
}
}
if (isset($categories[$data['entry_id']]) and is_array($categories[$data['entry_id']]) and count($cat_chunk) > 0) {
// Get category ID from URL for {if active} conditional
ee()->load->helper('segment');
$active_cat = $obj->channel()->pagination->dynamic_sql && $obj->channel()->cat_request ? parse_category($obj->channel()->query_string) : FALSE;
foreach ($cat_chunk as $catkey => $catval) {
$cats = '';
$i = 0;
$not_these = array();
$these = array();
$not_these_groups = array();
$these_groups = array();
if (isset($catval[1]['show'])) {
if (strncmp($catval[1]['show'], 'not ', 4) == 0) {
$not_these = explode('|', trim(substr($catval[1]['show'], 3)));
} else {
$these = explode('|', trim($catval[1]['show']));
}
}
if (isset($catval[1]['show_group'])) {
if (strncmp($catval[1]['show_group'], 'not ', 4) == 0) {
$not_these_groups = explode('|', trim(substr($catval[1]['show_group'], 3)));
} else {
$these_groups = explode('|', trim($catval[1]['show_group']));
}
}
foreach ($categories[$data['entry_id']] as $k => $v) {
if (in_array($v[0], $not_these) or isset($v[5]) && in_array($v[5], $not_these_groups)) {
continue;
} elseif (count($these) > 0 && !in_array($v[0], $these) or count($these_groups) > 0 && isset($v[5]) && !in_array($v[5], $these_groups)) {
continue;
}
$temp = $catval[0];
if (preg_match_all("#" . LD . "path=(.+?)" . RD . "#", $temp, $matches)) {
foreach ($matches[1] as $match) {
if ($obj->channel()->use_category_names == TRUE) {
$temp = preg_replace("#" . LD . "path=.+?" . RD . "#", reduce_double_slashes(ee()->functions->create_url($match) . '/' . $obj->channel()->reserved_cat_segment . '/' . $v[6]), $temp, 1);
} else {
$temp = preg_replace("#" . LD . "path=.+?" . RD . "#", reduce_double_slashes(ee()->functions->create_url($match) . '/C' . $v[0]), $temp, 1);
}
}
} else {
$temp = preg_replace("#" . LD . "path=.+?" . RD . "#", ee()->functions->create_url("SITE_INDEX"), $temp);
}
ee()->load->library('file_field');
$cat_image = ee()->file_field->parse_field($v[3]);
$cat_vars = array('category_name' => $v[2], 'category_url_title' => $v[6], 'category_description' => isset($v[4]) ? $v[4] : '', 'category_group' => isset($v[5]) ? $v[5] : '', 'category_image' => $cat_image['url'], 'category_id' => $v[0], 'parent_id' => $v[1], 'active' => $active_cat == $v[0] || $active_cat == $v[6]);
// add custom fields for conditionals prep
foreach ($obj->channel()->catfields as $cv) {
$cat_vars[$cv['field_name']] = !isset($v['field_id_' . $cv['field_id']]) ? '' : $v['field_id_' . $cv['field_id']];
}
$temp = ee()->functions->prep_conditionals($temp, $cat_vars);
$temp = str_replace(array(LD . "category_id" . RD, LD . "category_name" . RD, LD . "category_url_title" . RD, LD . "category_image" . RD, LD . "category_group" . RD, LD . 'category_description' . RD, LD . 'parent_id' . RD), array($v[0], ee()->functions->encode_ee_tags($v[2]), $v[6], $cat_image['url'], isset($v[5]) ? $v[5] : '', isset($v[4]) ? ee()->functions->encode_ee_tags($v[4]) : '', $v[1]), $temp);
foreach ($obj->channel()->catfields as $cv2) {
if (isset($v['field_id_' . $cv2['field_id']]) and $v['field_id_' . $cv2['field_id']] != '') {
$field_content = ee()->typography->parse_type($v['field_id_' . $cv2['field_id']], array('text_format' => $v['field_ft_' . $cv2['field_id']], 'html_format' => $v['field_html_formatting'], 'auto_links' => 'n', 'allow_img_url' => 'y'));
$temp = str_replace(LD . $cv2['field_name'] . RD, $field_content, $temp);
} else {
// garbage collection
$temp = str_replace(LD . $cv2['field_name'] . RD, '', $temp);
}
$temp = reduce_double_slashes($temp);
}
$cats .= $temp;
if (is_array($catval[1]) && isset($catval[1]['limit']) && $catval[1]['limit'] == ++$i) {
break;
}
}
if (is_array($catval[1]) and isset($catval[1]['backspace'])) {
$cats = substr($cats, 0, -$catval[1]['backspace']);
}
// Check to see if we need to parse {filedir_n}
if (strpos($cats, '{filedir_') !== FALSE) {
ee()->load->library('file_field');
$cats = ee()->file_field->parse_string($cats);
}
$tagdata = str_replace($catval[2], $cats, $tagdata);
}
} else {
$tagdata = preg_replace('/{' . $tagname . '[^}]*}(.+?){\\/' . $tagname . '[^}]*}/is', '', $tagdata);
}
return $tagdata;
}
/**
* Build SQL Query
*/
private function _get_file_data($pagination = '')
{
$file_id = '';
$category_id = FALSE;
$category_group = FALSE;
$category_params = array('category' => 'category_id', 'category_group' => 'category_group');
$dynamic = ee()->TMPL->fetch_param('dynamic') !== 'no' ? TRUE : FALSE;
// Parse the URL query string
$query_string = ee()->uri->page_query_string != '' ? ee()->uri->page_query_string : ee()->uri->query_string;
$uristr = ee()->uri->uri_string;
if ($dynamic && !empty($query_string)) {
// If the query string is a number, treat it as a file ID
if (is_numeric($query_string)) {
$file_id = $query_string;
} else {
if ($this->enable['categories']) {
ee()->load->helper('segment');
$category_id = parse_category($query_string);
}
}
}
// Check the file_id parameter and override the one fetched from the
// query string
if (ee()->TMPL->fetch_param('file_id')) {
$file_id = ee()->TMPL->fetch_param('file_id');
}
// Chec k for category parameters
foreach ($category_params as $param => $variable) {
if ($this->enable['categories'] && ($temp = ee()->TMPL->fetch_param($param))) {
${$variable} = $temp;
}
}
// Start the cache so we can use for pagination
ee()->db->start_cache();
// Join the categories table if we're dealing with categories at all
if ($category_id or $category_group) {
ee()->db->distinct();
// We use 'LEFT' JOIN when there is a 'not' so that we get entries
// that are not assigned to a category.
if ((substr($category_group, 0, 3) == 'not' or substr($category_id, 0, 3) == 'not') && ee()->TMPL->fetch_param('uncategorized_entries') !== 'n') {
ee()->db->join('file_categories', 'exp_files.file_id = exp_file_categories.file_id', 'LEFT');
ee()->db->join('categories', 'exp_file_categories.cat_id = exp_categories.cat_id', 'LEFT');
} else {
ee()->db->join('file_categories', 'exp_files.file_id = exp_file_categories.file_id', 'INNER');
ee()->db->join('categories', 'exp_file_categories.cat_id = exp_categories.cat_id', 'INNER');
}
}
// Start pulling File IDs to both paginate on then pull data
ee()->db->select('exp_files.file_id');
ee()->db->from('files');
// Specify file ID(s) if supplied
if ($file_id != '') {
ee()->functions->ar_andor_string($file_id, 'exp_files.file_id');
}
// Specify directory ID(s) if supplied
if (($directory_ids = ee()->TMPL->fetch_param('directory_id')) != FALSE) {
ee()->functions->ar_andor_string($directory_ids, 'upload_location_id');
} else {
ee()->db->where_in('exp_files.site_id', ee()->TMPL->site_ids);
}
// Specify category and category group ID(s) if supplied
foreach ($category_params as $param => $variable) {
if (${$variable}) {
$cat_field_name = $param == 'category' ? 'exp_categories.cat_id' : 'exp_categories.group_id';
$include_uncategorized = substr(${$variable}, 0, 3) == 'not' && ee()->TMPL->fetch_param('uncategorized_entries') !== 'n' ? TRUE : FALSE;
ee()->functions->ar_andor_string(${$variable}, $cat_field_name, '', $include_uncategorized);
}
}
ee()->db->stop_cache();
// Set the limit
$limit = (int) ee()->TMPL->fetch_param('limit', 0);
$offset = (int) ee()->TMPL->fetch_param('offset', 0);
if ($limit > 0 && $this->enable['pagination'] && $pagination->paginate == TRUE) {
$pagination->build(ee()->db->count_all_results(), $limit);
ee()->db->limit($pagination->per_page, $pagination->offset);
} else {
if ($limit > 0 && $offset >= 0) {
ee()->db->limit($limit, $offset);
} else {
ee()->db->limit(100);
}
}
// Set order and sort
$allowed_orders = array('date', 'upload_date', 'random');
$order_by = strtolower(ee()->TMPL->fetch_param('orderby', 'upload_date'));
$order_by = ($order_by == 'date' or !in_array($order_by, $allowed_orders)) ? 'upload_date' : $order_by;
$random = $order_by == 'random' ? TRUE : FALSE;
$sort = strtolower(ee()->TMPL->fetch_param('sort', 'desc'));
$sort = $random ? 'random' : $sort;
ee()->db->order_by($order_by, $sort);
// Run the query and pass it to the final query
$query = ee()->db->get();
ee()->db->flush_cache();
if ($query->num_rows() == 0) {
return array();
}
foreach ($query->result() as $row) {
$file_ids[] = $row->file_id;
}
// Build the full SQL query
ee()->db->select('*')->join('upload_prefs', 'upload_prefs.id = files.upload_location_id', 'LEFT')->where_in('file_id', $file_ids)->order_by($order_by, $sort);
return ee()->db->get('files');
}
/**
* Category Sub-tree
*/
public function category_subtree($cdata = array())
{
$default = array('parent_id', 'path', 'template', 'depth', 'channel_array', 'show_empty');
foreach ($default as $val) {
${$val} = !isset($cdata[$val]) ? '' : $cdata[$val];
}
$open = 0;
if ($depth == '') {
$depth = 1;
}
$tab = '';
for ($i = 0; $i <= $depth; $i++) {
$tab .= "\t";
}
$total_results = count($this->cat_array);
// Get category ID from URL for {if active} conditional
$this->EE->load->helper('segment');
$active_cat = parse_category($this->query_string);
foreach ($this->cat_array as $key => $val) {
if ($parent_id == $val[0]) {
if ($open == 0) {
$open = 1;
$this->category_list[] = "\n" . $tab . "<ul>\n";
}
$chunk = $template;
$this->EE->load->library('file_field');
$cat_image = $this->EE->file_field->parse_field($val[2]);
$cat_vars = array('category_name' => $val[1], 'category_url_title' => $val[4], 'category_description' => $val[3], 'category_image' => $cat_image['url'], 'category_id' => $key, 'parent_id' => $val[0], 'active' => $active_cat == $key || $active_cat == $val[4]);
// add custom fields for conditionals prep
foreach ($this->catfields as $v) {
$cat_vars[$v['field_name']] = !isset($val['field_id_' . $v['field_id']]) ? '' : $val['field_id_' . $v['field_id']];
}
$cat_vars['count'] = ++$this->category_count;
$cat_vars['total_results'] = $total_results;
$chunk = $this->EE->functions->prep_conditionals($chunk, $cat_vars);
$chunk = str_replace(array(LD . 'category_id' . RD, LD . 'category_name' . RD, LD . 'category_url_title' . RD, LD . 'category_image' . RD, LD . 'category_description' . RD, LD . 'parent_id' . RD), array($key, $val[1], $val[4], $cat_image['url'], $val[3], $val[0]), $chunk);
foreach ($path as $pkey => $pval) {
if ($this->use_category_names == TRUE) {
$chunk = str_replace($pkey, $this->EE->functions->remove_double_slashes($pval . '/' . $this->reserved_cat_segment . '/' . $val[4]), $chunk);
} else {
$chunk = str_replace($pkey, $this->EE->functions->remove_double_slashes($pval . '/C' . $key), $chunk);
}
}
// parse custom fields
foreach ($this->catfields as $ccv) {
if (isset($val['field_id_' . $ccv['field_id']]) and $val['field_id_' . $ccv['field_id']] != '') {
$field_content = $this->EE->typography->parse_type($val['field_id_' . $ccv['field_id']], array('text_format' => $val['field_ft_' . $ccv['field_id']], 'html_format' => $val['field_html_formatting'], 'auto_links' => 'n', 'allow_img_url' => 'y'));
$chunk = str_replace(LD . $ccv['field_name'] . RD, $field_content, $chunk);
} else {
// garbage collection
$chunk = str_replace(LD . $ccv['field_name'] . RD, '', $chunk);
}
}
/** --------------------------------
/** {count}
/** --------------------------------*/
if (strpos($chunk, LD . 'count' . RD) !== FALSE) {
$chunk = str_replace(LD . 'count' . RD, $this->category_count, $chunk);
}
/** --------------------------------
/** {total_results}
/** --------------------------------*/
if (strpos($chunk, LD . 'total_results' . RD) !== FALSE) {
$chunk = str_replace(LD . 'total_results' . RD, $total_results, $chunk);
}
$this->category_list[] = $tab . "\t<li>" . $chunk;
if (is_array($channel_array)) {
$fillable_entries = 'n';
foreach ($channel_array as $k => $v) {
$k = substr($k, strpos($k, '_') + 1);
if ($key == $k) {
if (!isset($fillable_entries) or $fillable_entries == 'n') {
$this->category_list[] = "\n{$tab}\t\t<ul>\n";
$fillable_entries = 'y';
}
$this->category_list[] = "{$tab}\t\t\t{$v}";
}
}
}
if (isset($fillable_entries) && $fillable_entries == 'y') {
$this->category_list[] = "{$tab}\t\t</ul>\n";
}
$t = '';
if ($this->category_subtree(array('parent_id' => $key, 'path' => $path, 'template' => $template, 'depth' => $depth + 2, 'channel_array' => $channel_array)) != 0) {
}
if (isset($fillable_entries) && $fillable_entries == 'y') {
$t .= "{$tab}\t";
}
$this->category_list[] = $t . "</li>\n";
unset($this->temp_array[$key]);
$this->close_ul($parent_id, $depth + 1);
}
}
return $open;
}
