1.在主表模块中创建子表字段标签
/wwws/language/zh_cn.lang.php
'LBL_ConsignmentItem'=>'提运单明细',
'LBL_ADDROW'=>'新增明细',
'LBL_REMOVEROW'=>'删除',
'LBL_SequenceNumeric' => '托运货物序号',
'LBL_MarksNumbers' => '唛头',
'LBL_CargoDescription' => '货物简要描述',
'LBL_Content' => '备注',
2.创建Item模板
/wwws/EditView.html
</table>//在此语句后添写下面代码
<!-- BEGIN: open_source -->
<!-- END: open_source -->
<!-- END: main -->
<!-- BEGIN: Item -->
<div id="productSection">
<INPUT class="button" id="add_row" onclick="addRow('prod', lableMap);" type="button" value="{MOD.LBL_ADDROW}" name="add_row">
<table id="prod" width="100%" border="0" cellspacing="0" cellpadding="0" class="tabForm">
<THEAD>
<tr>
<TD class="dataLabel" width="20%" ><span>{MOD.LBL_SequenceNumeric}</span></TD>
<TD class="dataLabel" width="25%" ><span>{MOD.LBL_MarksNumbers}</span></TD>
<TD class="dataLabel" width="20%" ><span>{MOD.LBL_CargoDescription}</span></TD>
<TD class="dataLabel" width="35%" ><span>{MOD.LBL_Content}</span></TD>
</tr>
</THEAD>
<!-- BEGIN: items -->
<TR>
<TD class="dataField" ><input type=text size=15 value="{ITEM_SequenceNumeric}" name="SequenceNumeric_ {ITEM_IDX}" id="SequenceNumeric_{ITEM_IDX}"></TD>
<TD class="dataField" ><input type=text size=25 value="{ITEM_MarksNumbers}" name="MarksNumbers_ {ITEM_IDX}" id="MarksNumbers_{ITEM_IDX}"></TD>
<TD class="dataField" ><input type=text size=20 value="{ITEM_CargoDescription}" name="CargoDescription_ {ITEM_IDX}" id="CargoDescription_{ITEM_IDX}"></TD>
<TD class="dataField" ><input type=text size=35 value="{ITEM_Content}" name="Content_ {ITEM_IDX}" id="Content_{ITEM_IDX}"></TD>
<TD class="dataField" ><INPUT class="button" id="remove" onclick="delRow('prod',{ITEM_IDX})" type="button" value="{MOD.LBL_REMOVEROW}" name="remove">
<input type=hidden id=rowIndexId_{ITEM_IDX} name=rowIndexId_{ITEM_IDX} value=0>
<INPUT type="hidden" name="item_id_{ITEM_IDX}" id="item_id_{ITEM_IDX}" value="{ITEM_ID}"/> </TD>
</TR>
<!-- END: items -->
</table>
</form>
{JAVASCRIPT}
<!-- END: Item -->
3.向模板赋值
/wwws/EditView.php
//Add Custom Fields
require_once('modules/DynamicFields/templates/Files/EditView.php');//在此语句后添写下面代码
//contract items
require_once('modules/Contracts/ContractItem.php');
$itemObj = new ContractItem();
$items = $itemObj->getAllByContractId($focus->id);
if(empty($focus->id) || empty($items))
{
$xtpl->assign("ITEM_IDX", 1);
$xtpl->assign("ITEM_SequenceNumeric",'1');
$xtpl->assign("ITEM_MarksNumbers",'');
$xtpl->assign("ITEM_CargoDescription",'');
$xtpl->assign("ITEM_Content",'');
$xtpl->assign("ITEM_ID",'');
$xtpl->parse("main.item");
}
else
{
$idx = 1;
foreach($items as $item)
{
$xtpl->assign("ITEM_IDX", $idx++);
$xtpl->assign("ITEM_SequenceNumeric",$item->SequenceNumeric);
$xtpl->assign("ITEM_MarksNumbers",$item->MarksNumbers);
$xtpl->assign("ITEM_CargoDescription",$item->CargoDescription);
$xtpl->assign("ITEM_PRODUCT_NUM",$item->product_num);
$xtpl->assign("ITEM_Content",$item->Content);
$xtpl->assign("ITEM_ID",$item->id);
$xtpl->parse("main.item");
}
}
//~~~ end contract items;
//下面的代码是控制输出,需要调整
$xtpl->parse("main.open_source");
$xtpl->parse("main");
$xtpl->out("main");//注意:main 中 没有 </from>标签 , 它在Item标签中所以下面代码必须写
echo "\n<p>\n";//输出明细的标题
echo get_module_title($mod_strings['LBL_ConsignmentItem'], $mod_strings['LBL_ConsignmentItem'].": ".$focus->name, true);
echo "\n</p>\n";
$xtpl->parse("Item.items"); //赋明细列表 <!-- BEGIN: items --> 与 <!-- END: items --> 之间
$xtpl->parse("Item"); //赋 <!-- BEGIN: Item --> 与 <!-- END: Item --> 之间
$xtpl->out("Item"); //输出 <!-- BEGIN: Item --> 与 <!-- END: Item --> 之间
4.调用javascript脚本
/wwws/EditView.html
//在文件开始部分中调用javascript的地方添写下面代码
<script type="text/javascript" src="modules/wwws/ConsignmentItem.js"></script>
<script>
lableMap =
{
'btn_del':'{MOD.LBL_REMOVEROW}'
};
</script>
5.创建javascript脚本 ,用于Item中创建新行和删除行的javascript
在模块路径下创建名为 ConsignmentItem.js 的js文件,文件应为明细item模块的名称
文件中添加下面代码
function addRow(tbId, lableMap)
{
var tbl = document.getElementById(tbId);
var count = tbl.rows.length;
var row = tbl.insertRow(count);
var cell0 = row.insertCell(row.cells.length);
cell0.innerHTML = '<input type=text size=7 value="1" name=SequenceNumeric_'+count+' id=SequenceNumeric_'+count+'>';
var cell1 = row.insertCell(row.cells.length);
cell1.innerHTML = '<input type=text size=7 value="" name=MarksNumbers_'+count+' id=MarksNumbers_'+count+'>';
var cell2 = row.insertCell(row.cells.length);
cell2.innerHTML = '<input type=text size=7 value="0" name=CargoDescription_'+count+' id=CargoDescription_'+count+'>';
var cell3 = row.insertCell(row.cells.length);
cell3.innerHTML = '<input type=text size=7 value="" name=Content_'+count+' id=Content_'+count+'>';
var cell4 = row.insertCell(row.cells.length);
cell4.innerHTML = '<INPUT class="button" id="remove" onclick="delRow(\'prod\','+count+')" type="button" value="'+lableMap['btn_del']+'" name="remove"><input type=hidden id=rowIndexId_'+count+' name=rowIndexId_'+count+' value=0><INPUT type="hidden" name=contract_item_id_'+count+' value="" />';
// var cell7 = row.insertCell(row.cells.length);
// cell7.innserHTML = '';
}
function delRow(tbId, idx)
{
var tbl = document.getElementById(tbId);
var row = tbl.rows[idx];
row.style.display = 'none';
var delFlag = document.getElementById("rowIndexId_"+idx);
delFlag.value = 1;
//calculate();
}
6.保存
原理: save.php 控制保存的走向
SaveFormBase.php 执行保存的控制主文件(手动创建)
bw_ConsignmentItem.php 保存子表的所用文件(手动创建)
bw_Consignment.php 保存主表的所用文件(不用修改)
(1)修改 save.php
\modules\bw_Consignments\Save.php
将原有的所有代码注释掉
加入下面代码
require_once('modules/bw_Consignments/SaveFormBase.php');//引入 执行保存的控制主文件
$contractForm = new SaveFormBase();
$contractForm->handleSave('', true, false);
(2)创建 SaveFormBase.php
\modules\bw_Consignments\SaveFormBase.php \\在主表模块
加入下面代码
<?php
if(empty($GLOBALS['sugarEntry'])) die('Not A Valid Entry Point');
require_once('include/JSON.php');
class SaveFormBase{
function checkForDuplicates($prefix){
require_once('include/formbase.php');
require_once('modules/bw_Consignments/bw_Consignment.php');
$focus = new bw_Consignment();
$query = '';
$baseQuery = 'select id, Consignment_number from Consignments where deleted!=1 and (';
if(isset($_POST[$prefix.'bw_consignment_number']) && !empty($_POST[$prefix.'bw_consignment_number'])) {
$query = $baseQuery ." bw_consignment_number like '%".$_POST[$prefix.'bw_consignment_number']."%'";
$query .= getLikeForEachWord('bw_consignment_number', $_POST[$prefix.'bw_consignment_number']);
}
if(!empty($query)){
$rows = array();
require_once('include/database/PearDatabase.php');
$db = & PearDatabase::getInstance();
$result = $db->query($query.')');
if($db->getRowCount($result) == 0) {
return null;
}
for($i = 0; $i < $db->getRowCount($result); $i++) {
$rows[$i] = $db->fetchByAssoc($result, $i);
}
return $rows;
}
return null;
}
function handleSave($prefix, $redirect=true, $useRequired=false)
{
global $current_user;
require_once('modules/bw_Consignments/bw_Consignment.php');
require_once('modules/bw_Consignments/bw_ConsignmentItem.php');
require_once('log4php/LoggerManager.php');
require_once('include/formbase.php');
$focus = new bw_Consignment();
if($useRequired && !checkRequired($prefix, array_keys($focus->required_fields))) {
return null;
}
$focus = populateFromPost($prefix, $focus);
if( !ACLController::checkAccess($focus->module_dir, 'edit', $focus->isOwner($current_user->id))){
ACLController::displayNoAccess(true);
}
$check_notify = FALSE;
if (isset($GLOBALS['check_notify'])) {
$check_notify = $GLOBALS['check_notify'];
}
if (empty($_POST['record']) && empty($_POST['dup_checked'])) {
$duplicates = $this->checkForDuplicates($prefix);
if(isset($duplicates)){
$duplicateMsg = '';
foreach ($duplicates as $duplicate)
{
$duplicateMsg .= "<a href='index.php?module=" . $focus->module_dir . "&action=DetailView&record=". $duplicate['id']. "'>". $duplicate['bw_consignment_number']. "</a><br>\n";
}
die("Please check this duplicate record first.<br>\n". $duplicateMsg);
}
}
$return_id = $focus->save($check_notify);
$ci = new bw_ConsignmentItem();
$all_items = $ci->getAllById($return_id);//通过主表的id 获取此id在子表中的数据列表
$updated = array();
$keys = array_keys($_POST);//$_POST 中是主表的内容 及 子表的内容 提交的所有数据
$sum = 0;
for($index = 1; ; $index++) //子表数据 遍历一行赋赋值
{
if(!isset($_POST["SequenceNumeric_".$index])) //for循环出口
break;
$MessageID="";//$_POST[""];
$ConsignmentID=$return_id;//主表保存后的id
$SequenceNumeric = $_POST["SequenceNumeric_".$index];
$MarksNumbers = $_POST["MarksNumbers_".$index];
$CargoDescription = $_POST["CargoDescription_".$index];
$Content = $_POST["Content_".$index];
// if($quantity <= 0 || !isset($product_id) || empty($product_id))// 条件判断
// continue;
$item_id = $_POST["item_id_".$index];
$Item = new bw_ConsignmentItem();
$deleted = $_POST['rowIndexId_'.$index];
if($deleted == 0)
{
if(!empty($item_id))
{
$Item->id = $item_id;
array_push($updated, $item_id); //if the id is empty, create one, otherwise, update it.
}
$Item->MessageID = $MessageID;
$Item->ConsignmentID = $ConsignmentID;//主表的id
$Item->SequenceNumeric = $SequenceNumeric;
$Item->MarksNumbers = $MarksNumbers;
$Item->CargoDescription = $CargoDescription;
$Item->Content = $Content;
$Item->date_entered = date("Y-m-d H:i:s");
$Item->date_modified = date("Y-m-d H:i:s");
$Item->save();
}
}
//delete some items.
foreach($all_items as $item)
{
$ci_id = $item->id;
if( !in_array($ci_id, $updated) )
$item->mark_deleted($ci_id);
}
//~~ end saving contract items.
if(!empty($_POST['duplicate_parent_id'])) {
clone_relationship($focus->db, array('bw_consignments_documents'), 'bw_consignment_id', $_POST['duplicate_parent_id'], $focus->id);
}
$return_id = $focus->id;
$GLOBALS['log']->debug("Saved record with id of ".$return_id);
if ($redirect) {
handleRedirect($return_id,"bw_Consignments" );
} else {
return $focus;
}
}
}
?>
(3)创建 bw_ConsignmentItem.php 文件
\modules\bw_Consignments\bw_ConsignmentItem.php \\在主表模块
加入下面代码
<?php
include_once('config.php');
require_once('log4php/LoggerManager.php');
require_once('include/database/PearDatabase.php');
require_once('data/SugarBean.php');
// Contact is used to store customer information.
class bw_ConsignmentItem extends SugarBean
{
// Stored fields
var $id;
var $date_entered;
var $date_modified;
var $assigned_user_id;
var $modified_user_id;
var $created_by;
var $name;
var $description;
var $deleted;
//custom fields
var $MessageID;
var $ConsignmentID;
var $SequenceNumeric;
var $MarksNumbers;
var $CargoDescription;
var $Content;
var $table_name = 'bw_consignitems';
var $object_name = 'bw_ConsignItem';
var $module_dir = 'bw_ConsignItems';
var $new_schema = true;
var $column_fields = Array('id'
,'MessageID'
,'ConsignmentID'
,'SequenceNumeric'
,'MarksNumbers'
,'CargoDescription'
,'deleted'
,'date_entered'
,'date_modified'
,'created_by'
);
var $list_fields= array();
var $required_fields = array();
function Order()
{
parent::SugarBean();
$this->list_fields = $this->column_fields;
}
function get_xtemplate_data() {
$return_array = array();
global $current_user;
foreach($this->column_fields as $field) {
$return_array[strtoupper($field)] = $this->$field;
}
return $return_array;
}
function mark_deletedById($id) {
$return_array = $this->get_full_list("id","ConsignmentID='".$id."'");
foreach ($return_array as $value) {
$this->mark_deleted($value->id);
}
}
function fill_in_additional_list_fields() {
$this->fill_in_additional_detail_fields();
$this->single_total = $this->quantity * $this->trade_price;
}
function getAllById($id)//传入主表的保存后的id
{
$return_array = $this->get_full_list("id","ConsignmentID='".$id."'");
return $return_array;
}
}
?>