danielebarchiesi@0: <?php
danielebarchiesi@0: 
danielebarchiesi@0: /**
danielebarchiesi@0:  * @file
danielebarchiesi@0:  * Definition of views_handler_argument_formula.
danielebarchiesi@0:  */
danielebarchiesi@0: 
danielebarchiesi@0: /**
danielebarchiesi@0:  * Abstract argument handler for simple formulae.
danielebarchiesi@0:  *
danielebarchiesi@0:  * Child classes of this object should implement summary_argument, at least.
danielebarchiesi@0:  *
danielebarchiesi@0:  * Definition terms:
danielebarchiesi@0:  * - formula: The formula to use for this handler.
danielebarchiesi@0:  *
danielebarchiesi@0:  * @ingroup views_argument_handlers
danielebarchiesi@0:  */
danielebarchiesi@0: class views_handler_argument_formula extends views_handler_argument {
danielebarchiesi@0:   var $formula = NULL;
danielebarchiesi@0:   /**
danielebarchiesi@0:    * Constructor
danielebarchiesi@0:    */
danielebarchiesi@0:   function construct() {
danielebarchiesi@0:     parent::construct();
danielebarchiesi@0: 
danielebarchiesi@0:     if (!empty($this->definition['formula'])) {
danielebarchiesi@0:       $this->formula = $this->definition['formula'];
danielebarchiesi@0:     }
danielebarchiesi@0:   }
danielebarchiesi@0: 
danielebarchiesi@0:   function get_formula() {
danielebarchiesi@0:     return str_replace('***table***', $this->table_alias, $this->formula);
danielebarchiesi@0:   }
danielebarchiesi@0: 
danielebarchiesi@0:   /**
danielebarchiesi@0:    * Build the summary query based on a formula
danielebarchiesi@0:    */
danielebarchiesi@0:   function summary_query() {
danielebarchiesi@0:     $this->ensure_my_table();
danielebarchiesi@0:     // Now that our table is secure, get our formula.
danielebarchiesi@0:     $formula = $this->get_formula();
danielebarchiesi@0: 
danielebarchiesi@0:     // Add the field.
danielebarchiesi@0:     $this->base_alias = $this->name_alias = $this->query->add_field(NULL, $formula, $this->field);
danielebarchiesi@0:     $this->query->set_count_field(NULL, $formula, $this->field);
danielebarchiesi@0: 
danielebarchiesi@0:     return $this->summary_basics(FALSE);
danielebarchiesi@0:   }
danielebarchiesi@0: 
danielebarchiesi@0:   /**
danielebarchiesi@0:    * Build the query based upon the formula
danielebarchiesi@0:    */
danielebarchiesi@0:   function query($group_by = FALSE) {
danielebarchiesi@0:     $this->ensure_my_table();
danielebarchiesi@0:     // Now that our table is secure, get our formula.
danielebarchiesi@0:     $placeholder = $this->placeholder();
danielebarchiesi@0:     $formula = $this->get_formula() .' = ' . $placeholder;
danielebarchiesi@0:     $placeholders = array(
danielebarchiesi@0:       $placeholder => $this->argument,
danielebarchiesi@0:     );
danielebarchiesi@0:     $this->query->add_where(0, $formula, $placeholders, 'formula');
danielebarchiesi@0:   }
danielebarchiesi@0: }