Hi,

I would like to use a view in a multi domain environment, where the filter of the view is dependend on the $base_url of the site.

If $base_url is the default site, the filter should filter specific ad's (related to a specifiv vocabulary and taxonomy term).
If $base_url is a subsite, the filter should only show the ad's in the specific vocabulary and taxonomy term.

I installed the advertisement.module and filled the ad_group vocabulary with:
- default-site
- sub-site

And would like to use the argument handling code with an if statement to display the right view.
Something like: argument handling code:

<?php
If $base_url = ''www.test.com'' then arg(1) = "default-site"
If $base_url = '''www.testsub.com" then arg(1) = "subsite"

Filter on arg(1).. 
.......

I am not a coder, so above is more pseudocode
Can somebody help with this?

greetings,
Martijn

Comments

michelle’s picture

michelle
she/her
Primary language English
Location Wisconsin, USA
commented

A few of us on IRC worked together and came up with this to try. If it doesn't work, let us know and we'll try to tweak it. Don't forget that you don't want to put the opening and closing php tags around it. That's just so it formats right in the post.

global $base_url;
switch ($base_url) {
  case ('http://www.test.com'):
  $args[0] = "default-site";
  break;
  
  case ('http://www.testsub.com') : 
  $args[0] = "subsite";
  break;
  
  default:
  $args[0] = "SOMETHING HERE IF NO CASE MATCHES";
  break;
}

Michelle

summit’s picture

summit commented

Hi,

Great you replied so fast!
What I would like to achieve to have a specific views-filter based on the $base_url.
I think you have then put the whole filter-code in the argument-handling-code-text-block right?

I tried:

global $base_url;
switch ($base_url) {
  case ('http://www.gratis-informatie.nl'):

and then copy-paste of the $views->filter peace from the views-export:

   $view->filter = array (
    array (
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array (
      'tablename' => 'node',
      'field' => 'distinct',
      'operator' => '=',
      'options' => '',
      'value' => array (
  0 => 'distinct',
       ),
    ),
    array (
      'tablename' => 'term_node_109',
      'field' => 'tid',
      'operator' => 'AND',
      'options' => '3',
      'value' => array (
  0 => '176',
      ),
    ),
    array (
      'tablename' => 'term_node_138',
      'field' => 'tid',
      'operator' => 'AND',
      'options' => '3',
      'value' => array (
  0 => '170',
      ),
    ),
    array (
      'tablename' => 'ads',
      'field' => 'adstatus',
      'operator' => 'NOR',
      'options' => '',
      'value' => array (
  0 => 'pending',
  1 => 'offline',
  2 => 'unpublished',
  3 => 'expired',
  4 => 'denied',
      ),
    ),
    array (
      'tablename' => 'term_node_140',
      'field' => 'tid',
      'operator' => 'NOR',
      'options' => '',
      'value' => array (
  0 => '1739',
  1 => '1737',
),
    ),
  );

  break;
  
  default:
  $args[0] = $args[1];
  break;
}

But then I got all kind of user-warnings about the sql:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '1') AND ((. NOT IN ('pending','offline','unpublished','expired','denied') OR ' at line 1 query: SELECT count(node.nid) FROM GR5_node node WHERE (. = '1') AND ((. NOT IN ('pending','offline','unpublished','expired','denied') OR . IS NULL)) AND ((. NOT IN ('1739','1737') OR . IS NULL)) in /home/public_html/includes/database.mysql.inc on line 172. 
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '1') AND ((. NOT IN ('pending','offline','unpublished','expired','denied') OR ' at line 1 query: SELECT node.nid, node.sticky AS node_sticky, node.title AS node_title FROM GR5_node node WHERE (. = '1') AND ((. NOT IN ('pending','offline','unpublished','expired','denied') OR . IS NULL)) AND ((. NOT IN ('1739','1737') OR . IS NULL)) ORDER BY node_sticky DESC, node_title ASC LIMIT 0, 10 in /home/public_html/includes/database.mysql.inc on line 172.

Please help!
greetings,
Martijn

michelle’s picture

michelle
she/her
Primary language English
Location Wisconsin, USA
commented

That's not going to work at all. The argument handling code just sets the arguments. I assumed from your first post that you had an argument that made use of the URL and the code I gave you would set the value of that argument to the URL. You don't go pasting bits of a views export into argument handling code. That will just make a mess.

I don't know of any way to set filters dynamically like that; just arguments. Maybe someone else can answer that part.

Michelle

summit’s picture

summit commented

Hi,
Michelle thanks a lot for your effort!
On this post I saw a sort of pseudocode which can be of help: http://drupal.org/node/161795#comment-296376
Can may be somebody use this example to help me form my filter-argument-handling-code?

Thanks in advance,
greetings,
Martijn

summit’s picture

summit commented

Hi,
Until now no luckl.
May be somebody can help related to this: http://drupal.org/node/164471
Can somebody help to make my code above to be able to use filters related to the multisite-site I am on?

$view->filter[1]['value'] = X; ??

thanks in advance!

greetings,
Martijn

Piyavkin’s picture

Piyavkin commented

That's right (if there is a page view). Let's just modify it a little:

global $base_url;
$tmparg = '';

// select a term
switch ($base_url) {
  case ('http://www.test.com'):
  case ('http://test.com'):
  $tmparg = "default-site";
  break;
 
  case ('http://www.testsub.com') :
  case ('http://testsub.com') :
  $tmparg = "subsite";
  break;
 
  default:
  //SOMETHING HERE IF NO CASE MATCHES
  break;
}

// get term's object by its name
$tmparg = taxonomy_get_term_by_name($tmparg);

// place id of term into filter’s value
$view->filter[0][value][0] = $tmparg[0]->tid;

// place name of term as title of page or block (if necessary)
//$view->block_title = $tmparg[0]->name;
$view->page_title = $tmparg[0]->name;

return $args;

Code is not tested. Try that.

Beforehand you must to create manually a filter. Something like that:
Field=Taxonomy: Term
Operator=Is One Of
Value= // the value will be replaced in Argument Code section
Option=3 // taxonomy depth

To create dynamically whole filter is unnecessary I think (Drupal not so fast already, you know).

And as Michelle said: "Don't forget that you don't want to put [into field Argument Code] the opening and closing php tags around it. That's just so it formats right in the post".

summit’s picture

summit commented

Hi,

This is a piece of the argument handling code what is working for me:
I need to alter filter values because I use different subsites in which the tagged terms should not be shown.

// select a term
// site 1 = 2266
// site 2 = 2265

switch ($base_url) {
  case ('http://www.site1.com):
  case ('http://site1.com'):
  $view->page_title = $tmpterms_0[0]->name . ' ' . $tmpterms_1[0]->name;
  $view->filter[4][value][0] = "2265";
  break;

  case ('http://www.site2.com') :
  case ('http://site2.com') :
  $view->page_title = $tmpterms_0[0]->name . ' ' . $tmpterms_1[0]->name . ' ' . $base_url;
  $view->filter[4][value][0] = "2266";
  break;

  default:
  $view->page_title = "onbekende site";
  break;
}
return $args;

What I would like to ask. Is this performance-wise a good solution?
For the rest, thanks for helping me with this!

greetings,
Martijn

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Status: Active » Closed (won't fix)

Sorry, unfortunately this support request is way too specific. Please have a look at the issue queue - Views maintainers are buried already. You might want to try to get further support at http://drupal.org/support. Additionally, the answer to your question might be covered in the handbooks at http://drupal.org/handbook/modules/views already.
If you were able to solve this issue on your own in the meantime, you might want to add the involved steps to this closed issue, so other users searching for a similar solution might find it.