File: /home/nexper/www/67.225.167.226/public_html/crm/include/SearchForm/SearchForm2.php
<?php
/*********************************************************************************
* SugarCRM is a customer relationship management program developed by
* SugarCRM, Inc. Copyright (C) 2004 - 2009 SugarCRM Inc.
*
* This program is free software; you can redistribute it and/or modify it under
* the terms of the GNU General Public License version 3 as published by the
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
* details.
*
* You should have received a copy of the GNU General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU General Public License version 3.
*
* In accordance with Section 7(b) of the GNU General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
/*
* Created on May 30, 2007
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
require_once('include/tabs.php');
require_once('include/ListView/ListViewSmarty.php');
require_once('include/utils.php');
require_once('include/TemplateHandler/TemplateHandler.php');
require_once('include/EditView/EditView2.php');
require_once('modules/SavedSearch/SavedSearch.php');
class SearchForm extends EditView{
var $seed = null;
var $module = '';
var $action = 'index';
var $searchdefs = array();
var $listViewDefs = array();
var $lv;
var $th;
var $tpl;
var $view = 'SearchForm';
var $displayView = 'basic_search';
var $formData;
var $fieldDefs;
var $customFieldDefs;
var $tabs;
var $parsedView = 'basic';
//may remove
var $searchFields;
var $displaySavedSearch = true;
//show the advanced tab
var $showAdvanced = true;
//show the basic tab
var $showBasic = true;
//array of custom tab to show declare in searchdefs (no custom tab if false)
var $showCustom = false;
// nb of tab to show
var $nbTabs = 0;
// hide saved searches drop and down near the search button
var $showSavedSearchesOptions = true;
function SearchForm($seed, $module, $action = 'index'){
$this->th = new TemplateHandler();
$this->th->loadSmarty();
$this->seed = $seed;
$this->module = $module;
$this->action = $action;
$this->tabs = array(array('title' => $GLOBALS['app_strings']['LNK_BASIC_SEARCH'],
'link' => $module . '|basic_search',
'key' => $module . '|basic_search',
'name' => 'basic',
'displayDiv' => ''),
array('title' => $GLOBALS['app_strings']['LNK_ADVANCED_SEARCH'],
'link' => $module . '|advanced_search',
'key' => $module . '|advanced_search',
'name' => 'advanced',
'displayDiv' => 'display:none'),
);
$this->searchColumns = array () ;
}
function setup($searchdefs, $searchFields = array(), $tpl, $displayView = 'basic_search', $listViewDefs = array()){
$this->searchdefs = $searchdefs[$this->module];
$this->tpl = $tpl;
//used by advanced search
$this->listViewDefs = $listViewDefs;
$this->displayView = $displayView;
$this->view = $this->view.'_'.$displayView;
$tokens = split('_', $this->displayView);
$this->parsedView = $tokens[0];
if($this->displayView != 'saved_views'){
$this->_build_field_defs();
}
/*if(file_exists('modules/' . $this->module . '/metadata/SearchFields.php'))
require_once('modules/' . $this->module . '/metadata/SearchFields.php');
if(file_exists('custom/modules/' . $this->module . '/metadata/SearchFields.php'))
require_once('custom/modules/' . $this->module . '/metadata/SearchFields.php');
*/
$this->searchFields = $searchFields[$this->module];
// Setub the tab array
$this->tabs = array();
if($this->showBasic){
$this->nbTabs++;
$this->tabs[]=array('title' => $GLOBALS['app_strings']['LNK_BASIC_SEARCH'],
'link' => $this->module . '|basic_search',
'key' => $this->module . '|basic_search',
'name' => 'basic',
'displayDiv' => '');
}
if($this->showAdvanced){
$this->nbTabs++;
$this->tabs[]=array('title' => $GLOBALS['app_strings']['LNK_ADVANCED_SEARCH'],
'link' => $this->module . '|advanced_search',
'key' => $this->module . '|advanced_search',
'name' => 'advanced',
'displayDiv' => 'display:none');
}
if($this->showCustom){
foreach($this->showCustom as $v){
$this->nbTabs++;
$this->tabs[]=array('title' => $GLOBALS['app_strings']["LNK_" . strtoupper($v)],
'link' => $this->module . '|' . $v,
'key' => $this->module . '|' . $v,
'name' => str_replace('_search','',$v),
'displayDiv' => 'display:none',);
}
}
}
function display($header = true){
global $theme, $timedate, $image_path;
$header_txt = '';
$footer_txt = '';
$return_txt = '';
$this->th->ss->assign('module', $this->module);
$this->th->ss->assign('action', $this->action);
$this->th->ss->assign('displayView', $this->displayView);
$this->th->ss->assign('templateMeta', $this->searchdefs['templateMeta']);
$this->th->ss->assign('APP', $GLOBALS['app_strings']);
//Show the tabs only if there is more than one
if($this->nbTabs>1){
$this->th->ss->assign('TABS', $this->_displayTabs($this->module . '|' . $this->displayView));
}
$this->th->ss->assign('fields', $this->fieldDefs);
$this->th->ss->assign('customFields', $this->customFieldDefs);
$this->th->ss->assign('formData', $this->formData);
$time_format = $timedate->get_user_time_format();
$this->th->ss->assign('TIME_FORMAT', $time_format);
$this->th->ss->assign('USER_DATEFORMAT', $timedate->get_user_date_format());
$date_format = $timedate->get_cal_date_format();
$time_separator = ":";
if(preg_match('/\d+([^\d])\d+([^\d]*)/s', $time_format, $match)) {
$time_separator = $match[1];
}
// Create Smarty variables for the Calendar picker widget
$t23 = strpos($time_format, '23') !== false ? '%H' : '%I';
if(!isset($match[2]) || $match[2] == '') {
$this->th->ss->assign('CALENDAR_FORMAT', $date_format . ' ' . $t23 . $time_separator . "%M");
} else {
$pm = $match[2] == "pm" ? "%P" : "%p";
$this->th->ss->assign('CALENDAR_FORMAT', $date_format . ' ' . $t23 . $time_separator . "%M" . $pm);
}
$this->th->ss->assign('TIME_SEPARATOR', $time_separator);
$this->th->ss->assign('IMG_PATH', $image_path);
//Show and hide the good tab form
foreach($this->tabs as $tabkey=>$viewtab){
$viewName=str_replace(array($this->module . '|','_search'),'',$viewtab['key']);
if(strpos($this->view,$viewName)!==false){
$this->tabs[$tabkey]['displayDiv']='';
//if this is advanced tab, use form with saved search sub form built in
if($viewName=='advanced'){
$this->tpl = 'include/SearchForm/tpls/SearchFormGenericAdvanced.tpl';
if ($this->action =='ListView') {
$this->th->ss->assign('DISPLAY_SEARCH_HELP', true);
}
$this->th->ss->assign('DISPLAY_SAVED_SEARCH', $this->displaySavedSearch);
$this->th->ss->assign('SAVED_SEARCH', $this->displaySavedSearch());
//this determines whether the saved search subform should be rendered open or not
if(isset($_REQUEST['showSSDIV']) && $_REQUEST['showSSDIV']=='yes'){
$this->th->ss->assign('SHOWSSDIV', 'yes');
$this->th->ss->assign('DISPLAYSS', '');
}else{
$this->th->ss->assign('SHOWSSDIV', 'no');
$this->th->ss->assign('DISPLAYSS', 'display:none');
}
}
}else{
$this->tabs[$tabkey]['displayDiv']='display:none';
}
}
$this->th->ss->assign('TAB_ARRAY', $this->tabs);
// return the form of the shown tab only
$return_txt = $this->th->displayTemplate($this->seed->module_dir, 'SearchForm_'.$this->parsedView, $this->tpl);
if($header){
$this->th->ss->assign('return_txt', $return_txt);
$header_txt = $this->th->displayTemplate($this->seed->module_dir, 'SearchFormHeader', 'include/SearchForm/tpls/header.tpl');
//pass in info to render the select dropdown below the form
$this->th->ss->assign('IMG_PATH', $image_path);
if($this->showSavedSearchesOptions){
$this->th->ss->assign('SAVED_SEARCHES_OPTIONS', $this->displaySavedSearchSelect());
}
if ($this->module == 'Documents'){
$this->th->ss->assign('DOCUMENTS_MODULE', true);
}
$footer_txt = $this->th->displayTemplate($this->seed->module_dir, 'SearchFormFooter', 'include/SearchForm/tpls/footer.tpl');
$return_txt = $header_txt.$footer_txt;
}
return $return_txt;
}
function displaySavedSearch(){
$savedSearch = new SavedSearch($this->listViewDefs[$this->module], $this->lv->data['pageData']['ordering']['orderBy'], $this->lv->data['pageData']['ordering']['sortOrder']);
return $savedSearch->getForm($this->module, false);
}
function displaySavedSearchSelect(){
$savedSearch = new SavedSearch($this->listViewDefs[$this->module], $this->lv->data['pageData']['ordering']['orderBy'], $this->lv->data['pageData']['ordering']['sortOrder']);
return $savedSearch->getSelect($this->module);
}
/**
* displays the tabs (top of the search form)
*
* @param string $currentKey key in $this->tabs to show as the current tab
*
* @return string html
*/
function _displayTabs($currentKey) {
$tabPanel = new SugarWidgetTabs($this->tabs, $currentKey, 'SUGAR.searchForm.searchFormSelect');
if(isset($_REQUEST['saved_search_select']) && $_REQUEST['saved_search_select']!='_none') {
$saved_search=loadBean('SavedSearch');
$saved_search->retrieveSavedSearch($_REQUEST['saved_search_select']);
}
$str = $tabPanel->display();
$str .= '<script>';
if(!empty($_REQUEST['displayColumns']))
$str .= 'SUGAR.savedViews.displayColumns = "' . $_REQUEST['displayColumns'] . '";';
elseif(isset($saved_search->contents['displayColumns']) && !empty($saved_search->contents['displayColumns']))
$str .= 'SUGAR.savedViews.displayColumns = "' . $saved_search->contents['displayColumns'] . '";';
if(!empty($_REQUEST['hideTabs']))
$str .= 'SUGAR.savedViews.hideTabs = "' . $_REQUEST['hideTabs'] . '";';
elseif(isset($saved_search->contents['hideTabs']) && !empty($saved_search->contents['hideTabs']))
$str .= 'SUGAR.savedViews.hideTabs = "' . $saved_search->contents['hideTabs'] . '";';
if(!empty($_REQUEST['orderBy']))
$str .= 'SUGAR.savedViews.selectedOrderBy = "' . $_REQUEST['orderBy'] . '";';
elseif(isset($saved_search->contents['orderBy']) && !empty($saved_search->contents['orderBy']))
$str .= 'SUGAR.savedViews.selectedOrderBy = "' . $saved_search->contents['orderBy'] . '";';
if(!empty($_REQUEST['sortOrder']))
$str .= 'SUGAR.savedViews.selectedSortOrder = "' . $_REQUEST['sortOrder'] . '";';
elseif(isset($saved_search->contents['sortOrder']) && !empty($saved_search->contents['sortOrder']))
$str .= 'SUGAR.savedViews.selectedSortOrder = "' . $saved_search->contents['sortOrder'] . '";';
$str .= '</script>';
return $str;
}
/*
* Generate the data
*/
function _build_field_defs(){
$this->formData = array();
$this->fieldDefs = array();
foreach($this->searchdefs['layout'][$this->displayView] as $data){
if(is_array($data)){
$data['name'] = $data['name'].'_'.$this->parsedView;
$this->formData[] = array('field' => $data);
$this->fieldDefs[$data['name']]= $data;
} else {
$this->formData[] = array('field' => array('name'=>$data.'_'.$this->parsedView));
}
}
if($this->seed){
$this->seed->fill_in_additional_detail_fields();
foreach($this->seed->toArray() as $name => $value) {
if(!empty($this->fieldDefs[$name.'_'.$this->parsedView]))
$this->fieldDefs[$name.'_'.$this->parsedView] = array_merge($this->seed->field_defs[$name], $this->fieldDefs[$name.'_'.$this->parsedView]);
else{
$this->fieldDefs[$name.'_'.$this->parsedView] = $this->seed->field_defs[$name];
$this->fieldDefs[$name.'_'.$this->parsedView]['name'] = $this->fieldDefs[$name.'_'.$this->parsedView]['name'].'_'.$this->parsedView;
}
if(isset($this->fieldDefs[$name.'_'.$this->parsedView]['type']) && $this->fieldDefs[$name.'_'.$this->parsedView]['type'] == 'relate') {
if(isset($this->fieldDefs[$name.'_'.$this->parsedView]['id_name'])) {
$this->fieldDefs[$name.'_'.$this->parsedView]['id_name'] .= '_'.$this->parsedView;
}
}
if(isset($this->fieldDefs[$name.'_'.$this->parsedView]['options']) && isset($GLOBALS['app_list_strings'][$this->fieldDefs[$name.'_'.$this->parsedView]['options']])) {
$this->fieldDefs[$name.'_'.$this->parsedView]['options'] = $GLOBALS['app_list_strings'][$this->fieldDefs[$name.'_'.$this->parsedView]['options']]; // fill in enums
}
if(isset($this->fieldDefs[$name.'_'.$this->parsedView]['function'])) {
$this->fieldDefs[$name.'_'.$this->parsedView]['type']='multienum';
if(is_array($this->fieldDefs[$name.'_'.$this->parsedView]['function'])) {
$this->fieldDefs[$name.'_'.$this->parsedView]['function']['preserveFunctionValue']=true;
}
$function = $this->fieldDefs[$name.'_'.$this->parsedView]['function'];
if(is_array($function) && isset($function['name'])){
$function = $this->fieldDefs[$name.'_'.$this->parsedView]['function']['name'];
}else{
$function = $this->fieldDefs[$name.'_'.$this->parsedView]['function'];
}
if(!empty($this->fieldDefs[$name.'_'.$this->parsedView]['function']['returns']) && $this->fieldDefs[$name.'_'.$this->parsedView]['function']['returns'] == 'html'){
if(!empty($this->fieldDefs[$name.'_'.$this->parsedView]['function']['include'])){
require_once($this->fieldDefs[$name.'_'.$this->parsedView]['function']['include']);
}
$value = $function($this->seed, $name, $value, $this->view);
$this->fieldDefs[$name.'_'.$this->parsedView]['value'] = $value;
}else{
if(!isset($function['params'])) {
$this->fieldDefs[$name.'_'.$this->parsedView]['options'] = $function($this->seed, $name, $value, $this->view);
} else {
$this->fieldDefs[$name.'_'.$this->parsedView]['options'] = call_user_func_array($function, $function['params']);
}
}
}
if(isset($this->fieldDefs[$name]['type']) && $this->fieldDefs[$name.'_'.$this->parsedView]['type'] == 'function' && isset($this->fieldDefs[$name.'_'.$this->parsedView]['function_name'])){
$value = $this->callFunction($this->fieldDefs[$name.'_'.$this->parsedView]);
$this->fieldDefs[$name.'_'.$this->parsedView]['value'] = $value;
}
$this->fieldDefs[$name]['value'] = $value;
if((!empty($_REQUEST[$name.'_'.$this->parsedView]) || (isset($_REQUEST[$name.'_'.$this->parsedView]) && $_REQUEST[$name.'_'.$this->parsedView] == '0'))
&& empty($this->fieldDefs[$name.'_'.$this->parsedView]['function']['preserveFunctionValue'])) {
$value = $_REQUEST[$name.'_'.$this->parsedView];
$this->fieldDefs[$name.'_'.$this->parsedView]['value'] = $value;
}
}
}
}
/**
* Populate the searchFields from an array
*
* @param array $array array to search through
* @param string $switchVar variable to use in switch statement
* @param bool $addAllBeanFields true to process at all bean fields
*/
function populateFromArray(&$array, $switchVar = null, $addAllBeanFields = true) {
if((!empty($array['searchFormTab']) || !empty($switchVar)) && !empty($this->searchFields)) {
$arrayKeys = array_keys($array);
$searchFieldsKeys = array_keys($this->searchFields);
if(empty($switchVar)) $switchVar = $array['searchFormTab'];
//name of the search tab
$SearchName=str_replace('_search', '', $switchVar);
if($switchVar=='saved_views'){
foreach($this->searchFields as $name => $params) {
foreach($this->tabs as $tabName){
if(!empty($array[$name . '_' . $tabName['name']])) {
$this->searchFields[$name]['value'] = $array[$name . '_' . $tabName['name']];
if(empty($this->fieldDefs[$name . '_' . $tabName['name']]['value'])) $this->fieldDefs[$name . '_' . $tabName['name']]['value'] = $array[$name . '_' . $tabName['name']];
}
}
}
if($addAllBeanFields) {
foreach($this->seed->field_name_map as $key => $params) {
if(!in_array($key, $searchFieldsKeys)) {
foreach($this->tabs->name as $tabName){
if(in_array($key . '_' . $tabName['name'], $arrayKeys) ) {
$this->searchFields[$key] = array('query_type' => 'default',
'value' => $array[$key . '_' . $tabName['name']]);
}
}
}
}
}
}else{
foreach($this->searchFields as $name => $params) {
$long_name = $name.'_'.$SearchName; /*nsingh 21648: Add additional check for bool values=0. empty() considers 0 to be empty Only repopulates if value is 0 or 1:( */
if(isset($array[$long_name]) && ( !empty($array[$long_name]) || (isset($this->fieldDefs[$long_name]) && $this->fieldDefs[$long_name]['type'] == 'bool' && ($array[$long_name]=='0' || $array[$long_name]=='1'))) ) { //advanced*/
$this->searchFields[$name]['value'] = $array[$long_name];
if(empty($this->fieldDefs[$long_name]['value'])) $this->fieldDefs[$long_name]['value'] = $array[$long_name];
}else if(!empty($array[$name])) { //basic
$this->searchFields[$name]['value'] = $array[$name];
if(empty($this->fieldDefs[$long_name]['value'])) $this->fieldDefs[$long_name]['value'] = $array[$name];
}
}
if((empty($array['massupdate']) || $array['massupdate'] == 'false') && $addAllBeanFields) {
foreach($this->seed->field_name_map as $key => $params) {
if(in_array($key.'_'.$SearchName, $arrayKeys) && !in_array($key, $searchFieldsKeys)) {
$this->searchFields[$key] = array('query_type' => 'default',
'value' => $array[$key.'_'.$SearchName]);
if (!empty($params['type']) && $params['type'] == 'parent' && !empty($params['type_name']) && !empty($this->searchFields[$key]['value'])) {
$this->searchFields[$params['type_name']] = array('query_type' => 'default',
'value' => $array[$params['type_name']]);
}
}
}
}
}
}
}
/**
* Populate the searchFields from $_REQUEST
*
* @param string $switchVar variable to use in switch statement
* @param bool $addAllBeanFields true to process at all bean fields
*/
function populateFromRequest($switchVar = null, $addAllBeanFields = true) {
$this->populateFromArray($_REQUEST, $switchVar, $addAllBeanFields);
}
function generateSearchWhere($add_custom_fields = false, $module='') {
global $timedate;
$this->searchColumns = array () ;
$values = $this->searchFields;
$where_clauses = array();
$like_char = '%';
$table_name = $this->seed->object_name;
$this->seed->fill_in_additional_detail_fields();
foreach($this->searchFields as $field=>$parms) {
$customField = false;
// Jenny - Bug 7462: We need a type check here to avoid database errors
// when searching for numeric fields. This is a temporary fix until we have
// a generic search form validation mechanism.
$type = (!empty($this->seed->field_name_map[$field]['type']))?$this->seed->field_name_map[$field]['type']:'';
if(!empty($this->seed->field_name_map[$field]['source'])
&& ($this->seed->field_name_map[$field]['source'] == 'custom_fields' ||
//Non-db custom fields, such as custom relates
($this->seed->field_name_map[$field]['source'] == 'non-db'
&& (!empty($this->seed->field_name_map[$field]['custom_module']) ||
isset($this->seed->field_name_map[$field]['ext2']))))){
$customField = true;
}
if ($type == 'int') {
if (!empty($parms['value'])) {
$tempVal = explode(',', $parms['value']);
$newVal = '';
foreach($tempVal as $key => $val) {
if (!empty($newVal))
$newVal .= ',';
if(!empty($val) && !(is_numeric($val)))
$newVal .= -1;
else
$newVal .= $val;
}
$parms['value'] = $newVal;
}
}
//Navjeet- 6/24/08 checkboxes have been changed to dropdowns, so we can query unchecked checkboxes! Bug: 21648.
// elseif($type == 'bool' && empty($parms['value']) && preg_match("/current_user_only/", string subject, array subpatterns, int flags, [int offset])) {
// continue;
// }
//
elseif($type == 'html' && $customField) {
continue;
}
if(isset($parms['value']) && $parms['value'] != "") {
$operator = 'like';
if(!empty($parms['operator'])) {
$operator = $parms['operator'];
}
if(is_array($parms['value'])) {
$field_value = '';
// always construct the where clause for multiselects using the 'like' form to handle combinations of multiple $vals and multiple $parms
if(/*$GLOBALS['db']->dbType != 'mysql' &&*/ !empty($this->seed->field_name_map[$field]['isMultiSelect']) && $this->seed->field_name_map[$field]['isMultiSelect']) {
// construct the query for multenums
// use the 'like' query for all mssql and oracle examples as both custom and OOB multienums are implemented with types that cannot be used with an 'in'
$operator = 'custom_enum';
$table_name = $this->seed->table_name ;
if ($customField)
$table_name .= "_cstm" ;
$db_field = $table_name . "." . $field;
foreach($parms['value'] as $key => $val) {
if($val != ' ' and $val != '') {
$qVal = $GLOBALS['db']->quote($val);
if (!empty($field_value)) {
$field_value .= ' or ';
}
$field_value .= "$db_field like '$qVal' or $db_field like '%$qVal^%' or $db_field like '%^$qVal%' or $db_field like '%^$qVal^%'";
}
}
} else {
$operator = 'in';
foreach($parms['value'] as $key => $val) {
if($val != ' ' and $val != '') {
if (!empty($field_value)) {
$field_value .= ',';
}
$field_value .= "'" . $GLOBALS['db']->quote($val) . "'";
}
}
}
}
else {
$field_value = $GLOBALS['db']->quote($parms['value']);
}
//set db_fields array.
if(!isset($parms['db_field'])) {
$parms['db_field'] = array($field);
}
if(isset($parms['my_items']) and $parms['my_items'] == true) {
if( $parms['value'] == false ) { //do not include where clause for custom fields with checkboxes that are unchecked
continue;
}
else{ //my items is checked.
global $current_user;
$field_value = $GLOBALS['db']->quote($current_user->id);
$operator = '=' ;
}
// $operator = ($parms['value'] == '1') ? '=' : '!=';
}
$where = '';
$itr = 0;
if($field_value != '') {
$this->searchColumns [ strtoupper($field) ] = $field ;
foreach ($parms['db_field'] as $db_field) {
if (strstr($db_field, '.') === false) {
//Try to get the table for relate fields from link defs
if ($type == 'relate' && !empty($this->seed->field_name_map[$field]['link'])
&& !empty($this->seed->field_name_map[$field]['rname'])) {
$link = $this->seed->field_name_map[$field]['link'];
$relname = $link['relationship'];
if (($this->seed->load_relationship($link))){
//Martin fix #27494
$db_field = $this->seed->field_name_map[$field]['name'];
} else {
//Best Guess for table name
$db_field = strtolower($link['module']) . '.' . $db_field;
}
}
else if ($type == 'parent') {
if (!empty($this->searchFields['parent_type'])) {
$parentType = $this->searchFields['parent_type'];
$rel_module = $parentType['value'];
global $beanFiles, $beanList;
if(!empty($beanFiles[$beanList[$rel_module]])) {
require_once($beanFiles[$beanList[$rel_module]]);
$rel_seed = new $beanList[$rel_module]();
$db_field = 'parent_' . $rel_module . '_' . $rel_seed->table_name . '.name';
}
}
}
//This should be triggered only for custom relate fields and relate fields in custom modules.
else if ($type == 'relate' && $customField && !empty($this->seed->field_name_map[$field]['module'])) {
$db_field = strtolower($this->seed->field_name_map[$field]['module'])
. '.' . !empty($this->seed->field_name_map[$field]['name'])?$this->seed->field_name_map[$field]['name']:'name';
}
else if(!$customField){
if ( !empty($this->seed->field_name_map[$field]['db_concat_fields']) )
$db_field = db_concat($this->seed->table_name, $this->seed->field_name_map[$db_field]['db_concat_fields']);
else
$db_field = $this->seed->table_name . "." . $db_field;
}else{
if ( !empty($this->seed->field_name_map[$field]['db_concat_fields']) )
$db_field = db_concat($this->seed->table_name . "_cstm.", $this->seed->field_name_map[$db_field]['db_concat_fields']);
else
$db_field = $this->seed->table_name . "_cstm." . $db_field;
}
}
if($type == 'date') {
// Collin - Have mysql as first because it's usually the case
// The regular expression check is to circumvent special case YYYY-MM
if($GLOBALS['db']->dbType == 'mysql') {
if(preg_match('/^\d{4}.\d{1,2}$/', $field_value) == 0) {
$field_value = $timedate->to_db_date($field_value, false);
$operator = '=';
} else {
$operator = 'db_date';
}
} else if($GLOBALS['db']->dbType == 'oci8') {
if(preg_match('/^\d{4}.\d{1,2}$/', $field_value) == 0) {
$field_value = $timedate->to_db_date($field_value, false);
$field_value = "to_date('" . $field_value . "', 'YYYY-MM-DD hh24:mi:ss')";
}
$operator = 'db_date';
} else if($GLOBALS['db']->dbType == 'mssql') {
if(preg_match('/^\d{4}.\d{1,2}$/', $field_value) == 0) {
$field_value = "Convert(DateTime, '".$timedate->to_db_date($field_value, false)."')";
}
$operator = 'db_date';
} else {
$field_value = $timedate->to_db_date($field_value, false);
$operator = '=';
}
}
if($type == 'datetime') {//bug 22564, date type field may also have this problem. we may add a date type here.
$field_value = $timedate->to_db_date($field_value, false);//This think of the timezone problem
$temp_offset = strtotime($timedate->swap_formats($timedate->to_display_date_time($field_value." 00:00:00"),$timedate->get_date_time_format(),$timedate->get_db_date_time_format())) - strtotime($field_value." 00:00:00");
$start_datetime = date("Y-m-d H:i:s", strtotime($field_value." 00:00:00") - $temp_offset);
$end_datetime = date("Y-m-d H:i:s", strtotime($field_value." 23:59:59") - $temp_offset);
$field_value = $start_datetime . "<>" . $end_datetime;
$operator = 'between';
}
if($GLOBALS['db']->dbType == 'oci8' && isset($parms['query_type']) && $parms['query_type'] == 'case_insensitive') {
$db_field = 'upper(' . $db_field . ")";
$field_value = strtoupper($field_value);
}
$itr++;
if(!empty($where)) {
$where .= " OR ";
}
switch(strtolower($operator)) {
case 'subquery':
$sq = $parms['subquery'];
if(is_array($sq)){
$and_or = ' AND ';
if (isset($sq['OR'])){
$and_or = ' OR ';
}
$first = true;
foreach($sq as $q){
if(empty($q) || strlen($q)<2) continue;
if(!$first){
$where .= $and_or;
}
$where .= " {$db_field} IN ({$q} '{$field_value}%') ";
$first = false;
}
}else{
$where .= "{$db_field} IN ({$parms['subquery']} '{$field_value}%')";
}
break;
case 'like':
if($type == 'bool' && $field_value == 0) {
$where .= $db_field . " = '0' OR " . $db_field . " IS NULL";
}
else {
$where .= $db_field . " like '".$field_value.$like_char."'";
}
break;
case 'in':
$where .= $db_field . " in (".$field_value.')';
break;
case '=':
if($type == 'bool' && $field_value == 0) {
$where .= $db_field . " = '0' OR " . $db_field . " IS NULL";
}
else {
$where .= $db_field . " = '".$field_value ."'";
}
break;
case 'db_date':
if(preg_match('/^\d{4}.\d{1,2}$/', $field_value) == 0) {
$where .= $db_field . " = ". $field_value;
} else {
// Create correct date_format conversion String
if($GLOBALS['db']->dbType == 'oci8') {
$where .= db_convert($db_field,'date_format',array("'YYYY-MM'")) . " = '" . $field_value . "'";
} else {
$where .= db_convert($db_field,'date_format',array("'%Y-%m'")) . " = '" . $field_value . "'";
}
}
break;
// tyoung bug 15971 - need to add these special cases into the $where query
case 'custom_enum':
$where .= $field_value;
break;
case 'between':
$field_value = explode('<>', $field_value);
$where .= $db_field . " > '".$field_value[0] . "' AND " .$db_field . " < '".$field_value[1]."'";
break;
}
}
}
if(!empty($where)) {
if($itr > 1) {
array_push($where_clauses, '( '.$where.' )');
}
else {
array_push($where_clauses, $where);
}
}
}
}
return $where_clauses;
}
}
?>