07-14-2018, 10:40 AM
(This post was last modified: 07-14-2018, 10:43 AM by construmet4.)
Es posible que el error de la generación de la consulta, esté en el archivo php del módulo en cuestión?
Este es el contenido que tengo en el archivo del modulo LlamadasRecibidas.php
<?php
/*+**********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright © vtiger.
* All Rights Reserved.
************************************************************************************/
require_once 'data/CRMEntity.php';
require_once 'data/Tracker.php';
class llamadasrecibidas extends CRMEntity {
public $db;
public $log;
public $table_name = 'vtiger_llamadasrecibidas';
public $table_index= 'llamadasrecibidasid';
public $column_fields = array();
/** Indicator if this is a custom module or standard module */
public $IsCustomModule = true;
public $HasDirectImageField = false;
/**
* Mandatory table for supporting custom fields.
*/
public $customFieldTable = array('vtiger_llamadasrecibidascf', 'llamadasrecibidasid');
// related_tables variable should define the association (relation) between dependent tables
// FORMAT: related_tablename => array(related_tablename_column[, base_tablename, base_tablename_column[, related_module]] )
// Here base_tablename_column should establish relation with related_tablename_column
// NOTE: If base_tablename and base_tablename_column are not specified, it will default to modules (table_name, related_tablename_column)
// Uncomment the line below to support custom field columns on related lists
// var $related_tables = array('vtiger_llamadasrecibidascf' => array('llamadasrecibidasid', 'vtiger_llamadasrecibidas', 'llamadasrecibidasid', 'llamadasrecibidas'));
/**
* Mandatory for Saving, Include tables related to this module.
*/
public $tab_name = array('vtiger_crmentity', 'vtiger_llamadasrecibidas', 'vtiger_llamadasrecibidascf');
/**
* Mandatory for Saving, Include tablename and tablekey columnname here.
*/
public $tab_name_index = array(
'vtiger_crmentity' => 'crmid',
'vtiger_llamadasrecibidas' => 'llamadasrecibidasid',
'vtiger_llamadasrecibidascf' => 'llamadasrecibidasid',
);
/**
* Mandatory for Listing (Related listview)
*/
public $list_fields = array (
/* Format: Field Label => array(tablename => columnname) */
// tablename should not have prefix 'vtiger_'
'LlamadasRecibidas'=> array('llamadasrecibidas' => 'llamadasrecibidasid'),
'Assigned To' => array('crmentity' => 'smownerid')
);
public $list_fields_name = array(
/* Format: Field Label => fieldname */
'LlamadasRecibidas'=> 'llamadasrecibidasid',
'Assigned To' => 'assigned_user_id'
);
// Make the field link to detail view from list view (Fieldname)
public $list_link_field = 'llamadasrecibidas';
// For Popup listview and UI type support
public $search_fields = array(
/* Format: Field Label => array(tablename => columnname) */
// tablename should not have prefix 'vtiger_'
'LlamadasRecibidas'=> array('llamadasrecibidas' => 'llamadasrecibidasid')
);
public $search_fields_name = array(
/* Format: Field Label => fieldname */
'LlamadasRecibidas'=> 'llamadasrecibidas'
);
// For Popup window record selection
public $popup_fields = array('llamadasrecibidas');
// Placeholder for sort fields - All the fields will be initialized for Sorting through initSortFields
public $sortby_fields = array();
// For Alphabetical search
public $def_basicsearch_col = 'llamadasrecibidas';
// Column value to use on detail view record text display
public $def_detailview_recname = 'llamadasrecibidas';
// Required Information for enabling Import feature
public $required_fields = array('llamadasrecibidas'=>1);
// Callback function list during Importing
public $special_functions = array('set_import_assigned_user');
public $default_order_by = 'llamadasrecibidasid';
public $default_sort_order='DESC';
// Used when enabling/disabling the mandatory fields for the module.
// Refers to vtiger_field.fieldname values.
public $mandatory_fields = array('createdtime', 'modifiedtime', 'llamadasrecibidas');
public function save_module($module) {
if ($this->HasDirectImageField) {
$this->insertIntoAttachment($this->id, $module);
}
}
/**
* Invoked when special actions are performed on the module.
* @param String Module name
* @param String Event Type (module.postinstall, module.disabled, module.enabled, module.preuninstall)
*/
public function vtlib_handler($modulename, $event_type) {
if ($event_type == 'module.postinstall') {
// TODO Handle post installation actions
$this->setModuleSeqNumber('configure', $modulename, $modulename.'-', '0000001');
} elseif ($event_type == 'module.disabled') {
// TODO Handle actions when this module is disabled.
} elseif ($event_type == 'module.enabled') {
// TODO Handle actions when this module is enabled.
} elseif ($event_type == 'module.preuninstall') {
// TODO Handle actions when this module is about to be deleted.
} elseif ($event_type == 'module.preupdate') {
// TODO Handle actions before this module is updated.
} elseif ($event_type == 'module.postupdate') {
// TODO Handle actions after this module is updated.
}
}
/**
* Handle saving related module information.
* NOTE: This function has been added to CRMEntity (base class).
* You can override the behavior by re-defining it here.
*/
// public function save_related_module($module, $crmid, $with_module, $with_crmid) { }
/**
* Handle deleting related module information.
* NOTE: This function has been added to CRMEntity (base class).
* You can override the behavior by re-defining it here.
*/
//public function delete_related_module($module, $crmid, $with_module, $with_crmid) { }
/**
* Handle getting related list information.
* NOTE: This function has been added to CRMEntity (base class).
* You can override the behavior by re-defining it here.
*/
//public function get_related_list($id, $cur_tab_id, $rel_tab_id, $actions=false) { }
/**
* Handle getting dependents list information.
* NOTE: This function has been added to CRMEntity (base class).
* You can override the behavior by re-defining it here.
*/
//public function get_dependents_list($id, $cur_tab_id, $rel_tab_id, $actions=false) { }
}
?>
Faltan los campos?, con este archivo realiza todas las construcciones de las consultas que realiza COREBOS?
Este es el contenido que tengo en el archivo del modulo LlamadasRecibidas.php
<?php
/*+**********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright © vtiger.
* All Rights Reserved.
************************************************************************************/
require_once 'data/CRMEntity.php';
require_once 'data/Tracker.php';
class llamadasrecibidas extends CRMEntity {
public $db;
public $log;
public $table_name = 'vtiger_llamadasrecibidas';
public $table_index= 'llamadasrecibidasid';
public $column_fields = array();
/** Indicator if this is a custom module or standard module */
public $IsCustomModule = true;
public $HasDirectImageField = false;
/**
* Mandatory table for supporting custom fields.
*/
public $customFieldTable = array('vtiger_llamadasrecibidascf', 'llamadasrecibidasid');
// related_tables variable should define the association (relation) between dependent tables
// FORMAT: related_tablename => array(related_tablename_column[, base_tablename, base_tablename_column[, related_module]] )
// Here base_tablename_column should establish relation with related_tablename_column
// NOTE: If base_tablename and base_tablename_column are not specified, it will default to modules (table_name, related_tablename_column)
// Uncomment the line below to support custom field columns on related lists
// var $related_tables = array('vtiger_llamadasrecibidascf' => array('llamadasrecibidasid', 'vtiger_llamadasrecibidas', 'llamadasrecibidasid', 'llamadasrecibidas'));
/**
* Mandatory for Saving, Include tables related to this module.
*/
public $tab_name = array('vtiger_crmentity', 'vtiger_llamadasrecibidas', 'vtiger_llamadasrecibidascf');
/**
* Mandatory for Saving, Include tablename and tablekey columnname here.
*/
public $tab_name_index = array(
'vtiger_crmentity' => 'crmid',
'vtiger_llamadasrecibidas' => 'llamadasrecibidasid',
'vtiger_llamadasrecibidascf' => 'llamadasrecibidasid',
);
/**
* Mandatory for Listing (Related listview)
*/
public $list_fields = array (
/* Format: Field Label => array(tablename => columnname) */
// tablename should not have prefix 'vtiger_'
'LlamadasRecibidas'=> array('llamadasrecibidas' => 'llamadasrecibidasid'),
'Assigned To' => array('crmentity' => 'smownerid')
);
public $list_fields_name = array(
/* Format: Field Label => fieldname */
'LlamadasRecibidas'=> 'llamadasrecibidasid',
'Assigned To' => 'assigned_user_id'
);
// Make the field link to detail view from list view (Fieldname)
public $list_link_field = 'llamadasrecibidas';
// For Popup listview and UI type support
public $search_fields = array(
/* Format: Field Label => array(tablename => columnname) */
// tablename should not have prefix 'vtiger_'
'LlamadasRecibidas'=> array('llamadasrecibidas' => 'llamadasrecibidasid')
);
public $search_fields_name = array(
/* Format: Field Label => fieldname */
'LlamadasRecibidas'=> 'llamadasrecibidas'
);
// For Popup window record selection
public $popup_fields = array('llamadasrecibidas');
// Placeholder for sort fields - All the fields will be initialized for Sorting through initSortFields
public $sortby_fields = array();
// For Alphabetical search
public $def_basicsearch_col = 'llamadasrecibidas';
// Column value to use on detail view record text display
public $def_detailview_recname = 'llamadasrecibidas';
// Required Information for enabling Import feature
public $required_fields = array('llamadasrecibidas'=>1);
// Callback function list during Importing
public $special_functions = array('set_import_assigned_user');
public $default_order_by = 'llamadasrecibidasid';
public $default_sort_order='DESC';
// Used when enabling/disabling the mandatory fields for the module.
// Refers to vtiger_field.fieldname values.
public $mandatory_fields = array('createdtime', 'modifiedtime', 'llamadasrecibidas');
public function save_module($module) {
if ($this->HasDirectImageField) {
$this->insertIntoAttachment($this->id, $module);
}
}
/**
* Invoked when special actions are performed on the module.
* @param String Module name
* @param String Event Type (module.postinstall, module.disabled, module.enabled, module.preuninstall)
*/
public function vtlib_handler($modulename, $event_type) {
if ($event_type == 'module.postinstall') {
// TODO Handle post installation actions
$this->setModuleSeqNumber('configure', $modulename, $modulename.'-', '0000001');
} elseif ($event_type == 'module.disabled') {
// TODO Handle actions when this module is disabled.
} elseif ($event_type == 'module.enabled') {
// TODO Handle actions when this module is enabled.
} elseif ($event_type == 'module.preuninstall') {
// TODO Handle actions when this module is about to be deleted.
} elseif ($event_type == 'module.preupdate') {
// TODO Handle actions before this module is updated.
} elseif ($event_type == 'module.postupdate') {
// TODO Handle actions after this module is updated.
}
}
/**
* Handle saving related module information.
* NOTE: This function has been added to CRMEntity (base class).
* You can override the behavior by re-defining it here.
*/
// public function save_related_module($module, $crmid, $with_module, $with_crmid) { }
/**
* Handle deleting related module information.
* NOTE: This function has been added to CRMEntity (base class).
* You can override the behavior by re-defining it here.
*/
//public function delete_related_module($module, $crmid, $with_module, $with_crmid) { }
/**
* Handle getting related list information.
* NOTE: This function has been added to CRMEntity (base class).
* You can override the behavior by re-defining it here.
*/
//public function get_related_list($id, $cur_tab_id, $rel_tab_id, $actions=false) { }
/**
* Handle getting dependents list information.
* NOTE: This function has been added to CRMEntity (base class).
* You can override the behavior by re-defining it here.
*/
//public function get_dependents_list($id, $cur_tab_id, $rel_tab_id, $actions=false) { }
}
?>
Faltan los campos?, con este archivo realiza todas las construcciones de las consultas que realiza COREBOS?