function viewChildTableList($subtable, $parent_value) { global $db; $maintable_key = $subtable['maintable_key']; $table_title = $subtable['subtable_title']; $tablename2 = $subtable['subtable_name']; $childkey2 = $subtable['subtable_key']; $where2 = $subtable['subtable_where']; $where2 = str_replace("(", "(", $where2); $where2 = str_replace(")", ")", $where2); $showlistfieldlist2 = $subtable['subtable_showlistfieldlist']; $columns2 = returntablecolumn($tablename2); $html_etc2 = returnsystemlang($tablename2); $showlistfieldlistArray2 = explode(",", $showlistfieldlist2); $iniFilename = "Model/" . $tablename2 . "_newai.ini"; if (!file_exists($iniFilename)) { $iniFilename = "../JXC/Model/" . $tablename2 . "_newai.ini"; } if (!file_exists($iniFilename)) { $iniFilename = "../CRM/Model/" . $tablename2 . "_newai.ini"; } if (!file_exists($iniFilename)) { $iniFilename = "../Framework/Model/" . $tablename2 . "_newai.ini"; } $file_ini2 = parse_ini_file($iniFilename, true); $org_showlistfieldlist = explode(",", $file_ini2['view_default']['showlistfieldlist']); $org_showlistfieldfilter = explode(",", $file_ini2['view_default']['showlistfieldfilter']); $showlistfieldfilterArray2 = array(); for ($i = 0; $i < sizeof($org_showlistfieldlist); $i++) { if (in_array($org_showlistfieldlist[$i], $showlistfieldlistArray2)) { $showlistfieldfilterArray2[$org_showlistfieldlist[$i]] = $org_showlistfieldfilter[$i]; } } //构建SQL语句 $SQLText = ""; for ($i = 0; $i < sizeof($showlistfieldlistArray2); $i++) { $listIndex = $showlistfieldlistArray2[$i]; $listIndexName = $columns2[$listIndex]; if ($SQLText != "") { $SQLText .= ","; } $SQLText .= $listIndexName; } if (is_array($parent_value)) { $childkey2Array = explode(",", $childkey2); $mainkey2Array = explode(",", $maintable_key); $SQL_Select = "select {$SQLText} from {$tablename2} where 1=1 "; $i = 0; foreach ($mainkey2Array as $row) { $SQL_Select = $SQL_Select . "and " . $childkey2Array[$i] . "='" . $parent_value[$row] . "' "; $i++; } } else { $SQL_Select = "select {$SQLText} from {$tablename2} where {$childkey2} = '" . $parent_value . "'"; } if ($where2 != '') { $where2 = str_replace(":", "=", $where2); $where2 = str_replace("\\", "", $where2); $SQL_Select .= " and " . $where2; } $rs = $db->Execute($SQL_Select); $rs_a = $rs->GetArray(); //print_R($rs_a);print_R($showlistfieldlistArray2); print "<tr ><td colspan=6 nowrap width=100%>\n"; table_begin("100%"); //标题显示部分 if ($table_title != "") { $url_filename = $tablename2 . "_newai.php"; if (file_exists("../JXC/" . $url_filename)) { $url_filename = "../JXC/" . $url_filename; } else { if (file_exists("../CRM/" . $url_filename)) { $url_filename = "../CRM/" . $url_filename; } else { $url_filename = ""; } } if ($url_filename != '') { $table_title = "<a href='{$url_filename}' target='_blank'>{$table_title}</a>"; } print "<tr><td class=TableHeader align=center colspan=" . sizeof($showlistfieldlistArray2) . ">{$table_title}</td></tr>"; } print "<tr class=TableContent>\n"; for ($i = 0; $i < sizeof($showlistfieldlistArray2); $i++) { $listIndex = $showlistfieldlistArray2[$i]; $listIndexName = $columns2[$listIndex]; $listFilter = $showlistfieldfilterArray2[$listIndex]; $listFilterArray = explode(":", $listFilter); if (stristr($listFilterArray[0], "tablefilter") && $listFilterArray[1] == $tablename2) { $TempColumns = returntablecolumn($listFilterArray[1]); $showText = $html_etc2[$tablename2][$TempColumns[$listFilterArray[3]]]; } else { $showText = $html_etc2[$tablename2][$listIndexName]; } print "<td nowrap>" . $showText . "</td>"; } print "</tr>"; $allnum = array(); $allmoney = array(); //数据窗口部分 for ($j = 0; $j < sizeof($rs_a); $j++) { print "<tr class=TableData>\n"; for ($i = 0; $i < sizeof($showlistfieldlistArray2); $i++) { $listIndex = $showlistfieldlistArray2[$i]; $listIndexName = $columns2[$listIndex]; $listFilter = $showlistfieldfilterArray2[$listIndex]; //数据过滤区 $listFilterArray = explode(":", $listFilter); if (stristr($listFilterArray[0], 'color')) { $hascolor = true; } else { $hascolor = false; } $nowrap = ""; if (strlen($rs_a[$j][$listIndexName]) < 20) { $nowrap = "nowrap"; } switch ($listFilterArray[0]) { case 'tablefilter': case 'tablefiltercolor': $TempColumns = returntablecolumn($listFilterArray[1]); $DataElement = returntablefieldColorFilterGray($listFilterArray[1], $TempColumns[(string) $listFilterArray[2]], $rs_a[$j][$listIndexName], $TempColumns[(string) $listFilterArray[3]], '', '', '', $hascolor); break; case 'radiofilter': $TempColumns = returntablecolumn($listFilterArray[1]); $DataElement = returntablefield($listFilterArray[1], $TempColumns[(string) $listFilterArray[2]], $rs_a[$j][$listIndexName], $TempColumns[(string) $listFilterArray[3]]); break; case 'radiofiltergroup': $TempColumns = returntablecolumn($listFilterArray[1]); $DataElement = returntablefield($listFilterArray[1], $TempColumns[(string) $listFilterArray[2]], $rs_a[$j][$listIndexName], $TempColumns[(string) $listFilterArray[3]]); break; case 'select_sex': $DataElement = returnsex($rs_a[$j][$listIndexName]); break; case 'boolean': $DataElement = returnboolean($rs_a[$j][$listIndexName]); break; case 'datetime': if ($rs_a[$j][$listIndexName] == '0000-00-00 00:00:00') { $DataElement = ''; } else { $DataElement = $rs_a[$j][$listIndexName]; } break; /* case 'input': $DataElement=cutStr($rs_a[$j][$listIndexName],15); if($DataElement!=$rs_a[$j][$listIndexName]) $DataElement="<span title='".$rs_a[$j][$listIndexName]."'>".$DataElement."..</span>"; else $DataElement = $rs_a[$j][$listIndexName]; break; case 'textarea': if(cutStr($rs_a[$j][$listIndexName],30)!=$rs_a[$j][$listIndexName]) $DataElement = "<div title='".$rs_a[$j][$listIndexName]."'>".cutStr($rs_a[$j][$listIndexName],30)."...</div>"; else $DataElement = $rs_a[$j][$listIndexName]; break; */ /* case 'input': $DataElement=cutStr($rs_a[$j][$listIndexName],15); if($DataElement!=$rs_a[$j][$listIndexName]) $DataElement="<span title='".$rs_a[$j][$listIndexName]."'>".$DataElement."..</span>"; else $DataElement = $rs_a[$j][$listIndexName]; break; case 'textarea': if(cutStr($rs_a[$j][$listIndexName],30)!=$rs_a[$j][$listIndexName]) $DataElement = "<div title='".$rs_a[$j][$listIndexName]."'>".cutStr($rs_a[$j][$listIndexName],30)."...</div>"; else $DataElement = $rs_a[$j][$listIndexName]; break; */ case 'qq': $DataElement = !empty($rs_a[$j][$listIndexName]) ? "<a target=\"_blank\" href=\"http://wpa.qq.com/msgrd?v=3&uin=" . $rs_a[$j][$listIndexName] . "&site=qq&menu=yes\"><img border=\"0\" src=\"http://wpa.qq.com/pa?p=2:" . $rs_a[$j][$listIndexName] . ":45\" onerror=\"this.src='" . ROOT_DIR . "general/ERP/Framework/images/help3.gif';this.title='此QQ号码可能不存在'\" title=\"点击这里发消息\">" . $rs_a[$j][$listIndexName] . "</a>" : ''; break; case 'mobile': $addicon = "<img src='" . ROOT_DIR . "general/ERP/Framework/images/menu/gif-0348.gif' title='点击号码发送短信'>"; if ($rs_a[$j][$listIndexName] != '') { $DataElement = "<a href='../JXC/sms_sendlist_newai.php?" . base64_encode("action=add_default&sendlist=" . $rs_a[$j][$listIndexName]) . "' target='_blank'>" . $addicon . $rs_a[$j][$listIndexName] . "</a>"; } else { $DataElement = $rs_a[$j][$listIndexName]; } break; case 'email': $linkman = ''; $fromsrc = ''; if ($tablename2 == 'linkman') { $fromsrc = 'customer'; $linkman = gettablefield($tablename2, 'email', 'rowid', $rs_a[$j][$listIndexName]); } else { if ($tablename2 == 'supplylinkman') { $fromsrc = 'supply'; $linkman = gettablefield($tablename2, 'email', 'rowid', $rs_a[$j][$listIndexName]); } else { $linkman = $rs_a[$j][$listIndexName]; $fromsrc = ''; } } $addicon = "<img src='" . ROOT_DIR . "general/ERP/Framework/images/menu/gif-0037.gif' title='点击链接发送邮件'>"; if ($rs_a[$j][$listIndexName] != '') { $DataElement = "<a href='../CRM/email_newai.php?" . base64_encode("action=add_default&sendlist=" . $linkman . "&fromsrc=" . $fromsrc) . "' target='_blank' >" . $addicon . $rs_a[$j][$listIndexName] . "</a>"; } break; case 'picturefile': global $ifincludemaginfier; $PicturePath = $rs_a[$j][$listIndexName]; if ($PicturePath != "" && strlen($PicturePath) > 10) { if (!$ifincludemaginfier) { print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.js\"></script>"; print "<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.magnifier.js\"></script>"; $ifincludemaginfier = true; } $DataElement = "<img src='" . $PicturePath . "' width=32 class=\"magnify\" data-magnifyto=\"500\" onmouseover=\"this.style.cursor='pointer';this.style.cursor='hand'\" onmouseout=\"this.style.cursor='default'\">"; //$file_path="<a href='$PicturePath'><img src='".$PicturePath."' border=0 width=120></a>"; } else { $DataElement = ""; } break; case 'userdefine': $functionName = trim($listFilterArray[1]); $fileName = $functionName . ".php"; $fileName0 = "userdefine/{$fileName}"; $fileName = "../../Enginee/userdefine/{$fileName}"; if (file_exists($fileName0)) { require_once $fileName0; $functionName = $functionName . "_value"; if (function_exists($functionName)) { $DataElement = $functionName($rs_a[$j][$listIndexName], $rs_a, $j); } } else { $DataElement = $rs_a[$j][$listIndexName]; } break; case 'tdoafile': require_once 'lib/utility_file.php'; //形成通达OA下载文件所需要的变量格式 $var_value_array = explode('||', $rs_a[$j][$listIndexName]); $ATTACHMENT_ID = $var_value_array[1]; $ATTACHMENT_NAME = $var_value_array[0]; if (strlen($rs_a[$j][$listIndexName]) < 3) { $file_path = "无附件"; } else { $file_path = attach_link($ATTACHMENT_ID, $ATTACHMENT_NAME, 1, 1, 1, 0, 0, 1, 1, 0); } //print_R($ATTACHMENT_NAME);exit; print "<script src=\"../../Enginee/lib/attach.js\"></script>"; print "\n\t\t\t\t\t<input type=\"hidden\" name=\"ATTACHMENT_ID_OLD\" value=\"{$ATTACHMENT_ID}\">\n\t\t\t\t\t<input type=\"hidden\" name=\"ATTACHMENT_NAME_OLD\" value=\"{$ATTACHMENT_NAME}\">"; $DataElement = $file_path; break; default: $DataElement = $rs_a[$j][$listIndexName]; break; } if ($listIndexName == 'zhekou') { $DataElement = $DataElement * 100 . "%"; } $tip = ''; if ((stristr($tablename2, "detail") || $tablename2 == "store_product") && $listIndexName == 'num') { $tablename3 = $tablename2 . "_color"; if ($tablename2 == "store_product") { $tablename3 = "store_color"; } $sql = "SELECT COUNT(*) as allnum FROM information_schema.TABLES WHERE TABLE_NAME='{$tablename3}'"; $rs = $db->Execute($sql); if ($rs->fields['allnum'] == 1) { $sql = "select id,{$SQLText} from {$tablename2} where {$childkey2} = '" . $parent_value . "'"; $rs = $db->Execute($sql); $rs_id = $rs->GetArray(); $id = $rs_id[$j][id]; $sql = "select a.num,b.name from {$tablename3} a inner join productcolor b on a.color=b.id where a.id={$id}"; $rs = $db->Execute($sql); $rs_color = $rs->GetArray(); foreach ($rs_color as $row) { $tip .= $row[name] . ":" . $row[num] . "\r\n"; } if ($tip != '') { $tip = " <span title='{$tip}'><img src='" . ROOT_DIR . "general/ERP/Framework/images/sepan.gif'></span>"; } } } print "<td {$nowrap}>" . $DataElement . $tip . "</td>"; if (stristr($html_etc2[$tablename2][$listIndexName], "数量")) { $allnum[$html_etc2[$tablename2][$listIndexName]] = $allnum[$html_etc2[$tablename2][$listIndexName]] + $rs_a[$j][$listIndexName]; } else { if (stristr($html_etc2[$tablename2][$listIndexName], "金额")) { $allmoney[$html_etc2[$tablename2][$listIndexName]] = $allmoney[$html_etc2[$tablename2][$listIndexName]] + $rs_a[$j][$listIndexName]; } } } print "</tr>"; } if (sizeof($allnum) > 0 || sizeof($allmoney) > 0) { print "<tr class=TableData><td align=center><b>合计</b></td>"; for ($i = 1; $i < sizeof($showlistfieldlistArray2); $i++) { $listIndex = $showlistfieldlistArray2[$i]; $listIndexName = $columns2[$listIndex]; if (array_key_exists($html_etc2[$tablename2][$listIndexName], $allnum)) { print "<td nowrap>" . $allnum[$html_etc2[$tablename2][$listIndexName]] . "</td>"; } else { if (array_key_exists($html_etc2[$tablename2][$listIndexName], $allmoney)) { print "<td nowrap>" . $allmoney[$html_etc2[$tablename2][$listIndexName]] . "</td>"; } else { print "<td nowrap></td>"; } } } print "</tr>"; } if (sizeof($rs_a) == 0) { print "<tr class=TableData><td align=center nowrap colspan=" . sizeof($showlistfieldlistArray2) . "><font color=gray>无此项记录</font></td>"; print "</tr>"; } table_end(); print "</td></tr>"; }
function print_tdoafile($showtext, $var, $var_value = "", $size = "25", $colspan = 1) { //形成通达OA下载文件所需要的变量格式 //print_R($_SESSION); $var_value_array = explode('||', $var_value); $ATTACHMENT_ID = $var_value_array[1]; $ATTACHMENT_NAME = $var_value_array[0]; print "<tr class=\"TableData\" id=\"attachment2\">\n <td nowrap>附件文档:</td>\n <td nowrap colspan='{$colspan}'>"; if (strlen($var_value) < 3) { echo "无附件"; } else { echo attach_link($ATTACHMENT_ID, $ATTACHMENT_NAME, 1, 1, 1, 1, 1, 1, 1, 1); } print " </td>\n"; print "<TR>\n"; print "<TD class=TableContent noWrap width=20%>{$showtext} </TD>\n"; print "<TD class=TableData noWrap height=30 colspan=\"{$colspan}\">\n"; if (is_file("../DanDian/Enginee/lib/attach.js")) { print "<script src=\"../DanDian/Enginee/lib/attach.js\"></script>"; } else { if (is_file("../../Enginee/lib/attach.js")) { print "<script src=\"../../Enginee/lib/attach.js\"></script>"; } } $QUERY_STRING = $_SERVER['QUERY_STRING']; $FormPageAction = FormPageAction('action', $_GET['action'], 'DeleteField', $var, '', "actionDeleteFile", 'DeleteFile'); //print $FormPageAction; print "<script>\n\t\t\t var upload_limit=1,limit_type=\"php,php3,php4,php5,\";\n\t\t\t function InsertImage(src)\n\t\t\t\t{\n\t\t\t\t //AddImage2Editor('CARE_CONTENT', src);\n\t\t\t\t}\n\t\t\tfunction delete_attach(ATTACHMENT_ID,ATTACHMENT_NAME)\n\t\t\t\t{\n\t\t\t\t msg=\"确定要删除文件 '\"+ ATTACHMENT_NAME +\"' 吗?\";\n\t\t\t\t if(window.confirm(msg))\n\t\t\t\t {\n\t\t\t\t\tURL=\"?{$FormPageAction}&ATTACHMENT_ID=\"+ATTACHMENT_ID+\"&ATTACHMENT_NAME=\"+ATTACHMENT_NAME;\n\t\t\t\t\twindow.location=URL;\n\t\t\t\t }\n\t\t\t\t}\n\t\t\t</script>\n"; if ($_SESSION['SYSTEM_IS_TD_OA'] != '1') { print "<script>ShowAddFile(\"\",0);ShowAddImage();</script>\n"; } else { print "<script>ShowAddFile();ShowAddImage();</script>\n"; } print "<INPUT type=hidden name='通达格式上传文件' value=\"{$var}\">\n"; print "\n <input type=\"hidden\" name=\"ATTACHMENT_ID_OLD\" value=\"{$ATTACHMENT_ID}\">\n\n <input type=\"hidden\" name=\"ATTACHMENT_NAME_OLD\" value=\"{$ATTACHMENT_NAME}\">\n"; print "</TD>\n"; print "</TR>\n"; }