需求:DetailView页面中显示与父表相关的子表ListView并可增加子表内容
解决方案:
1.两个模块
bw_Consignments 提运单信息 父表
bw_ConsignItems 提运单明细 子表 关系: 子表中ConsignmentID字段为父表中的id
2.关系字段
ConsignmentID 必须为主表字段
如何创建主表字段 详见 主表-自定义字段
3.增加关系
\modules\bw_Consignments\vardefs.php 父表模块下 添加如下
//BUILDER: included fields
'bw_ConsignItems' => //子表模块名
array (
'name' => 'bw_ConsignItems', //子表模块名
'type' => 'link',
'relationship' => 'MR_bw_ConsignItems', //关系名
'source'=>'non-db',
'vname'=>'LBL_REVMSGS',
),
//BUILDER:END of fields
//Relationships one-to-many //注意位置不能错,否则生成的sql语句有问
'relationships' => array(
'MR_bw_ConsignItems' => array(
'lhs_module'=> 'bw_ConsignItems', 'lhs_table'=> 'bw_ConsignItems', 'lhs_key' => 'ConsignmentID', //子表模块
'rhs_module'=> 'bw_Consignments', 'rhs_table'=> 'bw_Consignments', 'rhs_key' => 'id', //父表模块
'relationship_type'=>'one-to-many'),//关系
4.设置subpanel的显示
\modules\bw_Consignments\layout_defs.php 父表模块下 添加如下
$layout_defs['bw_Consignments'] = array(
'subpanel_setup' => array(
//BUILDER:END of subpanels
'bw_consignitems' => array( //必须小写
'order' => 25,
'module' => 'bw_ConsignItems', //子表模块名
'subpanel_name' => 'default',
'get_subpanel_data' => 'bw_ConsignItems', //子表模块名
'add_subpanel_data' => 'bw_Consignments', //父表模块名
'title_key' => 'LBL_MODULE_NAME', //subpanel的标题
'top_buttons' => array( array('widget_class' => 'SubPanelTopCreateButton')
),
),
'ser_rights' => array(
'order' => 26, //布局 多个SubPanel时显示的顺序
'module' => 'ser_Rights',
'subpanel_name' => 'default',
'get_subpanel_data' => 'ser_Rights',
'add_subpanel_data' => 'ser_right_id',
'title_key' => 'LBL_SER_RIGHTS_SUBPANEL_TITLE',//subpanel的标题 在父模块的 \language\zh_cn.lang.php 增加 'LBL_SER_RIGHTS_SUBPANEL_TITLE'=> '维权服务',
'top_buttons' => array( //array('widget_class' => 'SubPanelTopCreateButton') //新增 按钮 注掉则不显示按钮
),
),
),
);
5.DetailView中显示
\modules\bw_Consignments\DetailView.php
///////////////////////////////////////////////////////////////////////////////
//// SUBPANELS
///////////////////////////////////////////////////////////////////////////////
require_once('include/SubPanel/SubPanelTiles.php');
$subpanel = new SubPanelTiles($focus, 'MRConsignments');
echo $subpanel->display();
去掉上面注释的代码,即可在DetailView视图中显示subpanel
6.子表保存时,将赋父表的id
\modules\bw_ConsignItems\Save.php //在子表模块中
在下面代码后
$sugarbean = new bw_ConsignItems();
$sugarbean = populateFromPost('', $sugarbean);
$sugarbean->bw_Consignment_id = $_POST['return_id'];
添写
if ($_REQUEST['return_module']=='bw_Consignment'){
$sugarbean->ConsignmentID = $_REQUEST['return_id']; //将父表id 赋给子表的关系字段 ConsignmentID
}
7.刷新关系(非常重要,不刷新则子表全部显示)
系统管理 -> 升级 -> 重建关系(重建meta数据关系，删除cache文件)
8.此步骤不写好像也行
\modules\bw_ConsignItems\field_arrays.php
$fields_array['bw_ConsignItem'] = array (
'column_fields' => array(
'id',
'date_entered',
'date_modified',
'assigned_user_id',
'modified_user_id',
'created_by',
'name',
'description',
'deleted',
//BUILDER: included fields
'ConsignmentID', //关系字段 不写好像也行
//BUILDER:END of column fields
9.subpanel显示列
在子表模块的subpanel文件夹下的 Default.php文件中
\modules\bw_ConsignItems\default.php
'list_fields' => array(
'name' =>array(
'vname' => 'LBL_LIST_NAME',
'widget_class' => 'SubPanelDetailViewLink',
'width' => '20%',
),
//自定义列
'SequenceNumeric' =>array(
'vname' => 'LBL_SequenceNumeric',
'widget_class' => 'SubPanelDetailViewLink',
'width' => '20%',
),
'MarksNumbers' =>array(
'vname' => 'LBL_MarksNumbers',
'widget_class' => 'SubPanelDetailViewLink',
'width' => '20%',
),
//下面是修改,删除 按钮可删除则不显示(不删除，按钮也不好用)
'edit_button' =>array(
'widget_class' => 'SubPanelEditButton',
'module' => 'bw_ConsignItems',
'width' => '4%',
),
'remove_button'=>array(
'widget_class' => 'SubPanelRemoveButton',
'module' => 'bw_ConsignItems',
'width' => '5%',
),
),
);