function create_where_clause($parameter_values = array())
 {
     global $beanList, $beanFiles;
     $result = "";
     $beanName = $beanList[$this->module_name];
     $beanFile = $beanFiles[$beanName];
     if (!empty($beanName) && !empty($beanFile)) {
         require_once $beanFile;
         $seed = new $beanName();
         $field_def = $seed->field_defs[$this->field_name];
         if ($field_def["type"] == "relate" && $field_def["source"] == "non-db") {
             $result .= $field_def["table"] . "." . $field_def["rname"];
         } else {
             $result .= $seed->table_name . "." . $this->field_name;
         }
         $result .= " " . $this->comparator . " ";
         if ($this->value_type == "parameter") {
             $rpl = new ReportParameterLink();
             $rpl->retrieve($this->value);
             $result .= "'" . $parameter_values[$rpl->name] . "'";
         } else {
             $result .= "'" . $this->value . "'";
         }
     }
     return $result;
 }
示例#2
0
require_once 'include/upload_file.php';
require_once 'modules/ZuckerListingTemplateFilter/ListingTemplateFilter.php';
if (!is_admin($current_user)) {
    sugar_die("only admin allowed");
}
$filter = new ListingTemplateFilter();
if (!empty($_REQUEST['record'])) {
    $filter->retrieve($_REQUEST['record']);
}
$filter = populateFromPost("filter_", $filter);
$lt = new ListingTemplate();
$lt->retrieve($filter->listing_template_id);
if (!empty($_REQUEST["filter_value_param"])) {
    $rp = new ReportParameter();
    $rp->retrieve($_REQUEST["filter_value_param"]);
    $rpl = new ReportParameterLink();
    $rpl->template_id = $lt->id;
    $rpl->parameter_id = $rp->id;
    $rpl->name = $rp->default_name;
    $rpl->default_value = $rp->default_value;
    $rpl->save();
    $filter->value = $rpl->id;
    $filter->value_type = "parameter";
} else {
    if (!empty($_REQUEST["filter_value_enum"])) {
        $filter->value = $_REQUEST["filter_value_enum"];
        $filter->value_type = "text";
    } else {
        if (!empty($_REQUEST["filter_value_input"])) {
            $filter->value = $_REQUEST["filter_value_input"];
            $filter->value_type = "text";
示例#3
0
<?php

require_once 'include/formbase.php';
require_once 'modules/ZuckerListingTemplateFilter/ListingTemplateFilter.php';
if (!is_admin($current_user)) {
    sugar_die("only admin allowed");
}
if (!empty($_REQUEST['record'])) {
    $filter = new ListingTemplateFilter();
    $filter->retrieve($_REQUEST['record']);
    if ($filter->value_type == "parameter") {
        $rpl = new ReportParameterLink();
        $rpl->mark_deleted($filter->value);
    }
    $filter->mark_deleted($_REQUEST['record']);
}
handleRedirect("", "");
示例#4
0
<?php

require_once 'include/formbase.php';
require_once 'include/upload_file.php';
require_once 'modules/ZuckerReportParameterLink/ReportParameterLink.php';
if (!is_admin($current_user)) {
    sugar_die("only admin allowed");
}
$link = new ReportParameterLink();
if (!empty($_REQUEST['record'])) {
    $link->retrieve($_REQUEST['record']);
}
$link = populateFromPost("link_", $link);
$return_id = $link->save();
handleRedirect();
示例#5
0
<?php

require_once 'include/formbase.php';
require_once 'modules/ZuckerReportParameterLink/ReportParameterLink.php';
if (!is_admin($current_user)) {
    sugar_die("only admin allowed");
}
if (!empty($_REQUEST['record'])) {
    $link = new ReportParameterLink();
    $link->mark_deleted($_REQUEST['record']);
}
handleRedirect("", "");