function bankandyuchu_value($fieldvalue, $fields, $i)
{
if ($fieldvalue == '0') {
$fieldvalue = "预储值冲抵";
} else {
$fieldvalue = returntablefieldColorFilterGray("bank", "rowid", $fieldvalue, "bankname", "", "", "", "tablefiltercolor");
}
return $fieldvalue;
}
function print_select_text($showtext, $value, $showfield, $tablename, $field_value, $field_name, $groupfield = '', $groupvalue = '', $colspan = '2', $fieldfilter = 'select')
{
global $db;
global $colflag;
if ($colflag == 0) {
$colspan = 5;
}
if ($colflag == 1 || $colflag == 0) {
print "<tr>\n";
}
print "<TD class=TableContent noWrap>" . $showtext . "</TD>\n";
print "<TD class=TableData noWrap colspan=\"{$colspan}\">\n";
$hascolor = false;
if (stristr($fieldfilter, 'color')) {
$hascolor = 'true';
}
$returnname = returntablefieldColorFilterGray($tablename, $field_value, $value, $field_name, '', '', $hascolor);
print $returnname;
print "</TD>\n";
if ($colflag == 2 || $colflag == 0) {
print "</TR>\n";
}
}
function newaiinit_value($fields)
{
global $common_html, $html_etc;
global $return_sql_line, $db;
global $_POST, $_GET, $ROWS_PAGE;
global $action_add, $action_model, $mark;
global $read_type, $email_filter, $returnmodel;
global $sms_filter, $nullshow, $columns;
global $primarykey_index;
global $systemorder;
global $tablename;
//print $systemorder;
$systemorderArray = explode(',', $systemorder);
//echo '<br>';//by cwf
//var_dump($systemorderArray);//by cwf ='0:desc'
//var_dump($columns);//by cwf
for ($xx = 0; $xx < sizeof($systemorderArray); $xx++) {
$KeyOrderSqlIndexArray = explode(':', $systemorderArray[$xx]);
//{0,desc} by cwf
$KeyOrderSqlIndexName = $KeyOrderSqlIndexArray[0];
// 0
$KeyOrderSqlIndexOrderDesc = $KeyOrderSqlIndexArray[1];
//desc
$OrderSQLARRAY[$xx] = $columns[$KeyOrderSqlIndexName] . " " . $KeyOrderSqlIndexOrderDesc;
//id desc
}
$OrderSQLText = join(' , ', $OrderSQLARRAY);
//将数组转化成字符串，以，隔开。 =id desc
if (TRIM($OrderSQLARRAY[0]) != "") {
//判断移除特殊字符后的变量是否为空
$systemorderText = $OrderSQLText;
//id desc
} else {
if ($systemorder != "") {
$systemorder1 = "asc";
} else {
$systemorder1 = "desc";
}
$systemorderText = $primarykey_index . " {$systemorder1}";
}
//print $systemorderText;
switch ($db->databaseType) {
case 'mssql':
if (isset($_GET[ordername]) && in_array($_GET[ordername], $columns)) {
if ($_GET[doubletime] % 2 == 0) {
$addsql = "order by [" . $_GET[ordername] . "] asc";
} else {
$addsql = "order by [" . $_GET[ordername] . "] desc";
}
} else {
$addsql = "order by [" . $primarykey_index . "] {$systemorder1}";
}
break;
case 'mysql':
default:
if (isset($_GET[ordername]) && in_array($_GET[ordername], $columns)) {
if ($_GET[doubletime] % 2 == 0) {
$addsql = "order by " . $_GET[ordername] . " asc";
} else {
$addsql = "order by " . $_GET[ordername] . " desc";
}
} else {
$addsql = "order by {$systemorderText}";
}
break;
}
//end switch
//判断是否进行搜索设定
if ($action_add == 'search') {
$SQL = $return_sql_line['uniquekey_sql_search'] . " " . $addsql;
$SQL_NUM = $return_sql_line['uniquekey_sql_num_search'];
$SQL_SUM = $return_sql_line['uniquekey_sql_sum_search'];
} else {
$SQL = $return_sql_line['uniquekey_sql'] . " " . $addsql;
$SQL_NUM = $return_sql_line['uniquekey_sql_num_get'];
$SQL_SUM = $return_sql_line['uniquekey_sql_sum_get'];
}
global $NEWAIINIT_VALUE_SYSTEM;
global $NEWAIINIT_VALUE_SYSTEM_NUM;
global $NEWAIINIT_VALUE_SYSTEM_SUM;
if (strlen($NEWAIINIT_VALUE_SYSTEM) > 10) {
$SQL = $NEWAIINIT_VALUE_SYSTEM;
$SQL_NUM = $NEWAIINIT_VALUE_SYSTEM_NUM;
$SQL_SUM = $NEWAIINIT_VALUE_SYSTEM_SUM;
}
global $SYSTEM_MODE, $SYSTEM_PRINT_SQL;
//print_R($SYSTEM_MODE);
//print_R($return_sql_line);exit;
//print_R($return_sql_line);
if ($SYSTEM_PRINT_SQL) {
$SYSTEM_PRINT_SQL = $SQL;
print_R($SQL);
print "<HR>";
print_R($_GET);
print "<HR>";
//print_R($_SESSION);
//print "<HR>";
}
//print_R($SQL_SUM);EXIT;
global $rc;
$rs =& $db->CacheExecute(5, $SQL_NUM);
$rs_a = $rs->GetArray();
$rc = $rs_a[0]['num'];
if ($rc == '') {
$rc = $rs_a[0]['NUM'];
}
//求和开始 2011-01-31日支持数组
global $UserSumFunction;
//print $UserSumFunction;exit;
$UserSumFunctionArray = explode(',', $UserSumFunction);
$SQL_SUM_原始 = $SQL_SUM;
for ($ixx = 0; $ixx < sizeof($UserSumFunctionArray); $ixx++) {
$UserSumFunctionTEMP = $UserSumFunctionArray[$ixx];
if ($UserSumFunctionTEMP != "") {
$UserSumFunctionTEMP = $columns[$UserSumFunctionTEMP];
//有些字段职员看不到汇总
if ($fields['INPUT_TEXT'][$UserSumFunctionTEMP] == "private") {
$grade = str_split($fields['inputsize'][$UserSumFunctionTEMP]);
if (!in_array($_SESSION['LOGIN_USER_PRIV'], $grade)) {
continue;
}
}
$SQL_SUM = eregi_replace("___", $UserSumFunctionTEMP, $SQL_SUM_原始);
//print $SQL_SUM;//exit;
$rs_sum =& $db->CacheExecute(15, $SQL_SUM);
$sum_number = $rs_sum->fields['sum'];
$UserSumFunctionTEMP = $html_etc[$fields['tablename']][$UserSumFunctionTEMP];
$fields['other']['sum_number'][$UserSumFunctionTEMP] = is_float($sum_number + 0) ? number_format($sum_number, 2, '.', ',') : $sum_number;
}
}
//求和结束
if ($rc == 0 && $nullshow != 1) {
$return = "location='?action=init_" . $mark . "'";
$showtext = $common_html['common_html']['norecord'];
$location_title = 'sunshine_inside';
$action_array_temp = explode('_', $_GET['action']);
if ($action_array_temp[1] == 'customer') {
} else {
if ($email_filter != '') {
$return = isset($returnmodel) ? "location='?action=" . $returnmodel . "'" : "history.back();";
$showtext = $common_html['common_html']["nomail" . $mark];
} else {
if ($sms_filter != '') {
$return = isset($returnmodel) ? "location='?action=" . $returnmodel . "'" : "history.back();";
$showtext = $common_html['common_html']["nosms" . $mark];
} else {
//page_css('system');
//$action_model='add_default:new:n';
//show_new_element($action_model);
}
}
}
print_infor($showtext, 'trip', "{$return}");
exit;
}
if ($ROWS_PAGE <= 0) {
$pagenums = 0;
} else {
$pagenums = ceil($rc / $ROWS_PAGE);
$pageid = $_GET['pageid'];
}
if ($pageid == "" || empty($pageid)) {
$pageid = 1;
}
if ($pageid > $pagenums) {
$pageid = $pagenums;
}
$from = ($pageid - 1) * $ROWS_PAGE;
//print $SQL;print $SQL_NUM;
global $SYSTEM_SQL;
$SYSTEM_SQL = $SQL;
//print_r($SQL);
$rsl = $db->SelectLimit($SQL, $ROWS_PAGE, $from);
$rsa = $rsl->GetArray();
//print_R($rsa[0]);
@($fields['header'] = array_keys($rsa[0]));
$fields['sql']['SQL'] = $SQL;
$fields['sql']['SQL_NUM'] = $SQL_NUM;
$fields['value'] = $rsa;
//print_R(array_keys($rsa[0]));
//print_R($fields['value']);
$counter = 0;
//行数增加
//是否引入图片放大脚本
$ifincludemaginfier = false;
//2011-06-21初始化编辑与删除权限的值
$fields['view_priv'][$counter] = 0;
$fields['edit_priv'][$counter] = 0;
$fields['delete_priv'][$counter] = 0;
$fields['value2'] = $fields['value'];
foreach ($fields['value'] as $list) {
//print_R($list);exit;
//print $tablename;
$i = 0;
//
global $showlistfieldstopedit;
$showlistfieldstopeditArray = explode(',', $showlistfieldstopedit);
global $showlistfieldstopdelete;
$showlistfieldstopdeleteArray = explode(',', $showlistfieldstopdelete);
foreach ($fields['name'] as $list_index) {
$mode = $fields['filter'][$i];
//在此判断是否在专业科科长权限,如果是,则不显示USER_DEFINE字段
if ($_SESSION['SUNSHINE_BANJI_LIST'] != "") {
if ($mode == 'userdefine') {
$mode = 'input';
//设置为INPUT则不会显示增加操作的连接
}
}
//2011-06-20 处理针对行的编辑和删除按钮的禁用权限处理,兼容用户自定义部分的权限控制
//用户权限定义部分
//得到X列Y行的值
$filtervalue = $fields['value'][$counter][$list_index];
$showlistfieldstopeditArrayCheckArray = explode(':', $showlistfieldstopeditArray[$i]);
//print_R($showlistfieldstopeditArrayCheckArray);
if (in_array($filtervalue, $showlistfieldstopeditArrayCheckArray) && $filtervalue != "") {
$fields['edit_priv'][$counter] = 1;
} else {
//兼容旧的返回结果
//$fields['edit_priv'][$counter] = 0;
}
$filtervalue = $fields['value'][$counter][$list_index];
$showlistfieldstopdeleteArrayCheckArray = explode(':', $showlistfieldstopdeleteArray[$i]);
if (in_array($filtervalue, $showlistfieldstopdeleteArrayCheckArray) && $filtervalue != "") {
$fields['delete_priv'][$counter] = 1;
} else {
//兼容旧的返回结果
//$fields['delete_priv'][$counter] = 0;
}
$i++;
//列数增加
//exit($mode);
if (stristr($mode, 'color')) {
$hascolor = true;
} else {
$hascolor = false;
}
switch ($mode) {
case '':
case 'input':
case 'autoincrement':
case 'autoincrementdate':
$filtervalue = $fields['value'][$counter][$list_index];
break;
case 'number':
$filtervalue = "<div align=right>" . $fields['value'][$counter][$list_index] . "</div>";
break;
case 'money':
$filtervalue = "<div align=right>" . number_format(floatval($fields['value'][$counter][$list_index]), 2) . "</div>";
break;
case 'password':
$filtervalue = "******";
break;
case 'password_simple':
$filtervalue = "******";
break;
case 'ajaxinput':
global $sessionkey;
$INPUT_TEXT = $fields['INPUT_TEXT'][$list_index];
if ($INPUT_TEXT == "") {
$INPUT_SIZE = 15;
} else {
$INPUT_SIZE = $INPUT_TEXT;
}
//print $sessionkey;
$filtervalue = $fields['value'][$counter][$list_index];
$AjaxID = $fields['value'][$counter][$primarykey_index];
$openDir = "sessionkey={$sessionkey}&action=jiyun512&tablename={$tablename}&primarykey={$primarykey_index}&IDValue={$AjaxID}&FieldName={$list_index}";
if (is_file("newai_ajax.php")) {
$TempDirPath = "./";
} else {
if (is_file("../../Framework/newai_ajax.php")) {
$TempDirPath = "../../Framework/";
} else {
$TempDirPath = '';
}
}
$openDir = $TempDirPath . "newai_ajax.php?" . base64_encode($openDir);
$filtervalue = "<input type=\"text\" class=\"SmallInput\" size=\"{$INPUT_SIZE}\" value=\"" . $filtervalue . "\"\n\t\t\t\tonBlur=\"GetResult('" . $openDir . "&FieldValue='+this.value);\"\n\t\t\t\tonkeypress=\"GetResult('" . $openDir . "&FieldValue='+this.value);\"\n\t\t\t\tonchange=\"GetResult('" . $openDir . "&FieldValue='+this.value);\"\n\t\t\t\t>";
$filtervalue = $filtervalue;
break;
case 'ajaxinputhidden':
global $sessionkey;
$INPUT_TEXT = $fields['INPUT_TEXT'][$list_index];
if ($INPUT_TEXT == "") {
$INPUT_SIZE = 15;
} else {
$INPUT_SIZE = $INPUT_TEXT;
}
//print $sessionkey;
$filtervalue = $fields['value'][$counter][$list_index];
$AjaxID = $fields['value'][$counter][$primarykey_index];
$openDir = "sessionkey={$sessionkey}&action=jiyun512&tablename={$tablename}&primarykey={$primarykey_index}&IDValue={$AjaxID}&FieldName={$list_index}";
if (is_file("newai_ajax.php")) {
$TempDirPath = "./";
} else {
if (is_file("../../Framework/newai_ajax.php")) {
$TempDirPath = "../../Framework/";
} else {
$TempDirPath = '';
}
}
$openDir = $TempDirPath . "newai_ajax.php?" . base64_encode($openDir);
//$filtervalue="<input type=\"text\" class=\"SmallInput\" size=\"$INPUT_SIZE\" value=\"".$filtervalue."\" onkeyup=\"GetResult('".$openDir."&FieldValue='+this.value);\">";
if (TRIM($filtervalue) != "") {
$SpanInputText = "";
} else {
$SpanInputText = " ";
}
$filtervalue = "<SPAN onclick=\"listTable_edit(this,'{$list_index}',{$AjaxID},'{$sessionkey}','{$tablename}','{$primarykey_index}','{$AjaxID}','{$list_index}','{$openDir}')\">" . $filtervalue . $SpanInputText . "</SPAN>";
break;
case 'ajaxboolean':
global $sessionkey;
$INPUT_TEXT = $fields['INPUT_TEXT'][$list_index];
if ($INPUT_TEXT == "") {
$INPUT_SIZE = 15;
} else {
$INPUT_SIZE = $INPUT_TEXT;
}
//print $sessionkey;
$filtervalue = $fields['value'][$counter][$list_index];
$AjaxID = $fields['value'][$counter][$primarykey_index];
$openDir = "action=jiyun512&tablename={$tablename}&primarykey={$primarykey_index}&IDValue={$AjaxID}&sessionkey={$sessionkey}&FieldName={$list_index}";
if (is_file("newai_ajax.php")) {
$TempDirPath = "./";
} else {
if (is_file("../../newai_ajax.php")) {
$TempDirPath = "../../Framework/";
} else {
$TempDirPath = '';
}
}
if (is_file("images/error.gif")) {
$PicDirPath = "./";
} else {
$PicDirPath = "../../Framework/";
}
$openDir = $TempDirPath . "newai_ajax.php?" . base64_encode($openDir);
//$filtervalue="<input type=\"text\" class=\"SmallInput\" size=\"$INPUT_SIZE\" value=\"".$filtervalue."\" onkeyup=\"GetResult('".$openDir."&FieldValue='+this.value);\">";
if ($filtervalue == "1") {
$filtervalue = "<img onclick=\"listTable_boolean(this,'{$list_index}',{$AjaxID},'{$sessionkey}','{$tablename}','{$primarykey_index}','{$AjaxID}','{$list_index}','{$openDir}')\" src=\"" . $PicDirPath . "images/right.gif\" border=0>";
} else {
$filtervalue = "<img onclick=\"listTable_boolean(this,'{$list_index}',{$AjaxID},'{$sessionkey}','{$tablename}','{$primarykey_index}','{$AjaxID}','{$list_index}','{$openDir}')\" src=\"" . $PicDirPath . "images/error.gif\" border=0>";
}
break;
case 'avatar':
$filtervalue = $fields['value'][$counter][$list_index];
$filepath = "images/avatar/{$filtervalue}.gif";
if (is_file($filepath)) {
$filtervalue = "<img src=\"{$filepath}\" border=0>";
} else {
$filtervalue = "<img src=\"images/avatar/9.gif\" border=0>";
}
break;
case 'textarea':
$filtervalue = $fields['value'][$counter][$list_index];
$filtervalue = strip_tags(htmlspecialchars_decode($filtervalue));
if (cutStr($filtervalue, 25) != $filtervalue) {
$filtervalue = "<font title='{$filtervalue}'>" . cutStr($filtervalue, 25) . "</font>" . "...";
}
break;
case 'textareabr':
$filtervalue = $fields['value'][$counter][$list_index];
$filtervaluetext = addslashes($filtervalue);
if (cutStr($filtervalue, 25) != $filtervalue) {
$filtervalue = "<font title='{$filtervaluetext}'>" . cutStr($filtervalue, 25) . "</font>" . "...";
}
//if(strlen($filtervalue)>50) $filtervalue=substr($filtervalue,0,50)."...";
break;
case 'readonlytextarea':
$filtervalue = $fields['value'][$counter][$list_index];
$filtervaluetext = addslashes($filtervalue);
if (cutStr($filtervalue, 25) != $filtervalue) {
$filtervalue = "<font title='{$filtervaluetext}'>" . cutStr($filtervalue, 25) . "</font>" . "...";
}
break;
case 'idtoname_user':
$filtervalue = idtoname($fields['value'][$counter][$list_index], $mode = 'user');
break;
case 'idtoname_course':
$filtervalue = idtoname($fields['value'][$counter][$list_index], $mode = 'course');
break;
case 'idtoname_YuanXi':
$filtervalue = idtoname($fields['value'][$counter][$list_index], $mode = 'YuanXi');
break;
case 'idtoname_dept':
$filtervalue = idtoname($fields['value'][$counter][$list_index], $mode = 'dept');
//$filtervalue=$fields['value'][$counter][$list_index];
break;
case 'colorselect':
$filtervalue = "<div style=\"border:1px double #000000;width:16px;height:16px;background-color:{$filtervalue};overflow:hidden;\"></div>";
break;
case 'date':
case 'date1':
$filtervalue = $fields['value'][$counter][$list_index];
break;
case 'dateonly':
$filtervalue_Array = explode(' ', $fields['value'][$counter][$list_index]);
$filtervalue = $filtervalue_Array[0];
break;
case 'timeonly':
$filtervalue_Array = explode(' ', $fields['value'][$counter][$list_index]);
$filtervalue = $filtervalue_Array[1];
break;
case 'datetime':
$filtervalue = $fields['value'][$counter][$list_index];
break;
case 'url':
$filtervalue = $fields['value'][$counter][$list_index];
$urlfield = $fields['INPUT_TEXT'][$list_index];
$urlid = $fields['inputsize'][$list_index];
if ($filtervalue != '' && $urlid != '') {
$filtervalue = $filtervalue . "-" . $fields['value'][$counter][$urlid];
}
$url = $fields['value'][$counter][$urlfield];
$urlarray = explode("?", $url);
$urlarray[1] = str_ireplace("&", "&", $urlarray[1]);
$url = $urlarray[0] . "?" . base64_encode($urlarray[1]);
$filtervalue = "<a href=\"{$url}\" target=_blank >{$filtervalue}</a>";
break;
case 'mulcheckbox':
$filtervalue = $fields['value'][$counter][$list_index];
$subtablename = $fields['INPUT_TEXT'][$list_index];
$subkey = $fields['inputsize'][$list_index];
$subval = $fields['inputother'][$list_index];
$subcolums = returntablecolumn($subtablename);
$subkey = $subcolums[$subkey];
$subval = $subcolums[$subval];
$fieldValueArray = explode(",", $filtervalue);
array_pop($fieldValueArray);
$fieldValueArrayTEXT = join("','", $fieldValueArray);
$sql = "select {$subval} from {$subtablename} where {$subkey} in ('{$fieldValueArrayTEXT}')";
$rsxx = $db->CacheExecute(5, $sql);
$rsxxA = $rsxx->GetArray();
$fieldValueNameText = '';
for ($iD = 0; $iD < sizeof($rsxxA); $iD++) {
$fieldValueNameText .= $rsxxA[$iD][$subval] . ",";
}
//for($iD=0;$iD<sizeof($fieldValueArray);$iD++) {
// $fieldValueArrayValue = $fieldValueArray[$iD];
// if($fieldValueArrayValue!="")
// $fieldValueNameText .= returntablefield("user","USER_ID",$fieldValueArrayValue,"USER_NAME").",";
//}
$filtervalue = $fieldValueNameText;
break;
case 'file':
$filtervalue = $fields['value'][$counter][$list_index];
$filtervalue_file = explode('=', $filtervalue);
$filtervalue_sizeof = sizeof($filtervalue_file) - 1;
$filename = $filtervalue_file[$filtervalue_sizeof];
$filtervalue = "<a href=\"{$filtervalue}\">{$filename}</a>";
break;
case 'singlefile':
case 'picturefile':
$filtervalue = $fields['value'][$counter][$list_index];
$var_value = ereg_replace("&", "&", $filtervalue);
//print $filtervalue;
$parse_url = parse_url($var_value);
$query = $parse_url['query'];
parse_str($query, $output);
//print_R($output);
$attachmentid = $output['attachmentid'];
$attachmentname = $output['attachmentname'];
$filtervalue_file = explode('=', $filtervalue);
$filtervalue_sizeof = sizeof($filtervalue_file) - 1;
$filename = $filtervalue_file[$filtervalue_sizeof];
$filename_newfile = "../../attachment/{$attachmentid}/{$attachmentname}";
$filename_newfile2 = "../../Framework/attachment/{$attachmentid}/{$attachmentname}";
//print $filename_newfile;
//print_R(is_file($filename_newfile));
if (is_file($filename_newfile) || is_file($filename_newfile2)) {
$filtervalue = trim($fields['value'][$counter][$list_index]);
$filtervalue_file = explode('=', $filtervalue);
$filtervalue_sizeof = sizeof($filtervalue_file) - 1;
$filename = $filtervalue_file[$filtervalue_sizeof];
//$filtervalue = "<a href='".$filtervalue."'>$filename</a>";
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;
}
$image = "<img src='" . $filtervalue . "' height=25 class=\"magnify\" data-magnifyto=\"500\" onmouseover=\"this.style.cursor='pointer';this.style.cursor='hand'\" onmouseout=\"this.style.cursor='default'\">";
//$filtervalue = "<a href='".$filtervalue."'>$image</a>";
$filtervalue = $image;
} else {
$filtervalue = "";
}
break;
case 'tdoafile':
$filtervalue = $fields['value'][$counter][$list_index];
$var_value_array = explode('||', $filtervalue);
$ATTACHMENT_ID = $var_value_array[1];
$ATTACHMENT_NAME = $var_value_array[0];
$ATTACHMENT_ID_ARRAY = explode(",", $ATTACHMENT_ID);
$ATTACHMENT_NAME_ARRAY = explode("*", $ATTACHMENT_NAME);
$ATTACH_LINK = '';
require_once 'lib/utility_file.php';
$MODULE = attach_sub_dir();
for ($IX = 0; $IX < count($ATTACHMENT_ID_ARRAY); $IX++) {
if ($ATTACHMENT_ID_ARRAY[$IX] != "") {
$ATTACH_IMAGE = image_mimetype($ATTACHMENT_NAME_ARRAY[$IX]);
//print $ATTACH_IMAGE;
$ATTACHMENT_ID = $ATTACHMENT_ID_ARRAY[$IX];
//print_R($ATTACHMENT_ID);
$ATTACHMENT_ID_ARRAY2 = explode('_', $ATTACHMENT_ID);
$YM = $ATTACHMENT_ID_ARRAY2[0];
$ATTACHMENT_ID = $ATTACHMENT_ID_ARRAY2[1];
$SIGN_KEY = "";
//$SIGN_KEY = substr( $ATTACHMENT_ID, strpos( $ATTACHMENT_ID, "." ) + 1 );
//$ATTACHMENT_ID = substr( $ATTACHMENT_ID, 0, strpos( $ATTACHMENT_ID, "." ) );
//print_R($ATTACHMENT_ID);
$ATTACHMENT_ID_ENCODED = attach_id_encode($ATTACHMENT_ID, $ATTACHMENT_NAME_ARRAY[$IX]);
$ATTACH_SIZE = attach_size($ATTACHMENT_ID_ARRAY[$IX], $ATTACHMENT_NAME_ARRAY[$IX], $MODULE);
if (0 < floor($ATTACH_SIZE / 1024 / 1024)) {
$ATTACH_SIZE = round($ATTACH_SIZE / 1024 / 1024, 2) . "MB";
} else {
if (0 < floor($ATTACH_SIZE / 1024)) {
$ATTACH_SIZE = round($ATTACH_SIZE / 1024, 2) . "KB";
} else {
$ATTACH_SIZE .= "字节";
}
}
$ATTACH_LINK .= "<img src=\"../../Framework/images/attach/" . $ATTACH_IMAGE . "\" align=\"absmiddle\"\n\t\t\t\t\t\t\ttitle='" . urldecode($ATTACHMENT_NAME_ARRAY[$IX]) . " 大小:{$ATTACH_SIZE}'><a href=\"../../Enginee/lib/attach.php?MODULE=" . $MODULE . "&YM=" . $YM . "&ATTACHMENT_ID=" . $ATTACHMENT_ID_ENCODED . "&ATTACHMENT_NAME=" . urlencode($ATTACHMENT_NAME_ARRAY[$IX]) . "\" " . ($ATTACH_OFFICE_OPEN_IN_IE ? " target=\"_blank\"" : "") . "\n\t\t\t\t\t\t\ttitle='" . urldecode($ATTACHMENT_NAME_ARRAY[$IX]) . " 大小:{$ATTACH_SIZE}'\n\t\t\t\t\t\t\t>" . urldecode($ATTACHMENT_NAME_ARRAY[$IX]) . "</a>\n";
}
}
$filtervalue = $ATTACH_LINK;
break;
case 'binaryfile':
$filtervalue = $fields['value'][$counter][$list_index];
$filtervalue_file = explode('=', $filtervalue);
$filtervalue_sizeof = sizeof($filtervalue_file) - 1;
$filename = $filtervalue_file[$filtervalue_sizeof];
$filtervalue = "<a href=\"{$filtervalue}\">{$filename}</a>";
break;
case 'sex':
$filtervalue = returnsexcolor($fields['value'][$counter][$list_index]);
break;
case 'select_sex':
$filtervalue = returnsexcolor($fields['value'][$counter][$list_index]);
break;
case 'boolean':
$filtervalue = returnboolean_gif($fields['value'][$counter][$list_index]);
break;
case 'checkbox':
$filtervalue = returncheckbox($fields['value'][$counter][$list_index]);
break;
case 'select_sms':
$filtervalue = return_select_filter('select_sms', $fields['value'][$counter][$list_index]);
break;
case 'select_education':
$filtervalue = return_select_filter('select_education', $fields['value'][$counter][$list_index]);
break;
case 'select_marriage':
$filtervalue = return_select_filter('select_marriage', $fields['value'][$counter][$list_index]);
break;
case 'select_politics':
$filtervalue = return_select_filter('select_politics', $fields['value'][$counter][$list_index]);
break;
case 'sms_self_status':
$filtervalue = return_select_filter('sms_self_status', $fields['value'][$counter][$list_index]);
break;
case 'sms_delete_status':
$filtervalue = return_select_filter('sms_delete_status', $fields['value'][$counter][$list_index]);
break;
case 'select_worklog':
$filtervalue = return_select_filter('select_worklog', $fields['value'][$counter][$list_index]);
break;
case 'email_read_status_inbox':
$filtervalue = return_select_filter('email_read_status_inbox', $fields['value'][$counter][$list_index]);
break;
case 'email_read_status_outbox':
$filtervalue = return_select_filter('email_read_status_outbox', $fields['value'][$counter][$list_index]);
break;
case 'email_delete_status_outbox':
$filtervalue = return_select_filter('email_delete_status_outbox', $fields['value'][$counter][$list_index]);
break;
case 'ajax':
$filtervalue = ajaxtablefield($fields['select'][$i - 1]['tablename'], $fields['select'][$i - 1]['value'], $fields['value'][$counter][$list_index], $fields['select'][$i - 1]['field'], $counter, $fields['tablename'], $fields['name'][$i - 1], $primarykey_index, $fields['value'][$counter][$primarykey_index]);
break;
case 'select':
$filtervalue = returntablefield($fields['select'][$i - 1]['tablename'], $fields['select'][$i - 1]['value'], $fields['value'][$counter][$list_index], $fields['select'][$i - 1]['field']);
break;
case 'radio':
$filtervalue = returntablefield($fields['select'][$i - 1]['tablename'], $fields['select'][$i - 1]['value'], $fields['value'][$counter][$list_index], $fields['select'][$i - 1]['field']);
//print_R($fields['select'][$i-1]);;
break;
case 'radiogroup':
$filtervalue = returntablefieldColorFilterGray($fields['select'][$i - 1]['tablename'], $fields['select'][$i - 1]['value'], $fields['value'][$counter][$list_index], $fields['select'][$i - 1]['field'], $fields['select'][$i - 1]['groupfield'], $fields['select'][$i - 1]['groupvalue'], '', '', '', $hascolor);
break;
case 'selectcolor':
$filtervalue = returntablefieldColorFilterGray($fields['select'][$i - 1]['tablename'], $fields['select'][$i - 1]['value'], $fields['value'][$counter][$list_index], $fields['select'][$i - 1]['field'], '', '', '', $hascolor);
break;
case 'select_input':
$value = $fields['value'][$counter][$list_index];
$filtervalue = returntablefield($fields['select'][$i - 1]['tablename'], $fields['select'][$i - 1]['value'], $fields['value'][$counter][$list_index], $fields['select'][$i - 1]['field']);
break;
case 'select_textarea':
$value = $fields['value'][$counter][$list_index];
$filtervalue = idtoname($value, $mode = 'dept');
//returntablefield($fields['select'][$i-1]['tablename'],$fields['select'][$i-1]['value'],$fields['value'][$counter][$list_index],$fields['select'][$i-1]['field']);
break;
case 'checkread':
$index_key = $fields['table']['primarykeyindex'];
$index_key = $fields['value'][$counter][$index_key];
$in_array = checkread_username('checkread', $fields['checkread'][$i - 1]['field'], $index_key);
$in_array = $in_array == 1 ? 1 : 0;
$filtervalue = return_select_filter('notify_read_status', $in_array);
break;
case 'usertonamelist':
$filtervalue = $fields['value'][$counter][$list_index];
$fieldValueArray = explode(",", $filtervalue);
array_pop($fieldValueArray);
$fieldValueArrayTEXT = join("','", $fieldValueArray);
$sql = "select UID,USER_NAME from user where USER_ID in ('{$fieldValueArrayTEXT}') order by USER_NAME";
$rsxx = $db->CacheExecute(5, $sql);
$rsxxA = $rsxx->GetArray();
$fieldValueNameText = '';
for ($iD = 0; $iD < sizeof($rsxxA); $iD++) {
$fieldValueNameText .= "<a target='_blank' href='../Framework/user_newai.php?action=view_default&UID=" . $rsxxA[$iD]['UID'] . "'>" . $rsxxA[$iD]['USER_NAME'] . "</a>,";
}
//for($iD=0;$iD<sizeof($fieldValueArray);$iD++) {
// $fieldValueArrayValue = $fieldValueArray[$iD];
// if($fieldValueArrayValue!="")
// $fieldValueNameText .= returntablefield("user","USER_ID",$fieldValueArrayValue,"USER_NAME").",";
//}
$filtervalue = $fieldValueNameText;
//$filtervalue="<font title='$fieldValueNameText'>".$fieldValueNameText."</font>"."...";
break;
case 'link':
$filtervalue = $fields['value'][$counter][$list_index];
$url = $fields['link'][$i - 1]['url'];
$target = $fields['link'][$i - 1]['target'];
$filename = $fields['link'][$i - 1]['filename'];
$index_key = $fields['table']['primarykeyindex'];
$filtervalue = "<a href='{$filename}?" . base64_encode("action={$url}&{$index_key}=" . $fields['value'][$counter][$index_key]) . "' target={$target}>{$filtervalue}</a>";
//$filtervalue="<a href='$filename?action=$url&$list_index=$filtervalue&$index_key=".$fields['value'][$counter][$index_key]."' target=$target>$filtervalue</a>";
break;
case 'mobile':
$filtervalue = $fields['value'][$counter][$list_index];
$regex = "/1[34568]+\\d{9}/";
preg_match_all($regex, $filtervalue, $phones);
if (strlen($phones[0][0]) == 11) {
$filtervalue = "<a href='../JXC/sms_sendlist_newai.php?" . base64_encode("action=add_default&sendlist=" . $phones[0][0]) . "' target='_blank'>{$filtervalue}</a>";
}
break;
case 'qq':
$filtervalue = $fields['value'][$counter][$list_index];
$filtervalue = !empty($filtervalue) ? "<a target=\"_blank\" href=\"http://wpa.qq.com/msgrd?v=3&uin=" . $filtervalue . "&site=qq&menu=yes\"><img border=\"0\" src=\"http://wpa.qq.com/pa?p=2:" . $filtervalue . ":45\" title=\"点击这里发消息\" onerror=\"this.src='" . ROOT_DIR . "general/ERP/Framework/images/help3.gif';this.title='此QQ号码可能不存在'\">" . $filtervalue . "</a>" : '';
break;
case 'email':
$filtervalue = $fields['value'][$counter][$list_index];
if ($fields['tablename'] == 'linkman') {
$fromsrc = 'customer';
$linkman = gettablefield($fields['tablename'], 'email', 'rowid', $filtervalue);
} else {
if ($fields['tablename'] == 'supplylinkman') {
$fromsrc = 'supply';
$linkman = gettablefield($fields['tablename'], 'email', 'rowid', $filtervalue);
} else {
$linkman = $filtervalue;
$fromsrc = '';
}
}
$filtervalue = "<a href='../CRM/email_newai.php?" . base64_encode("action=add_default&sendlist=" . $linkman . "&fromsrc=" . $fromsrc) . "' target='_blank' >" . $filtervalue . "</a>";
break;
case 'userdefine':
$filtervalue = $fields['value'][$counter][$list_index];
$functionName = $fields['userdefine'][$i - 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)) {
$filtervalue = $functionName($fields['value'][$counter][$list_index], $fields, $counter);
}
} else {
if (file_exists($fileName)) {
require_once $fileName;
$functionName = $functionName . "_Value";
if (function_exists($functionName)) {
$filtervalue = $functionName($fields['value'][$counter][$list_index], $fields, $counter);
} else {
print "函数名称[{$functionName}]不存在！";
}
} else {
print "没有相应文件,文件名：{$fileName}";
}
}
//用户权限定义部分
//print_R($functionName."_PRIV");print_R("<BR>");
if (function_exists($functionName . "_PRIV")) {
$NewFunctionNamePriv = $functionName . "_PRIV";
$userdefine_priv_Infor = $NewFunctionNamePriv($fields['value'][$counter][$list_index], $fields, $counter);
if ($userdefine_priv_Infor['view_priv'] == 1) {
$fields['view_priv'][$counter] = 1;
}
if ($userdefine_priv_Infor['edit_priv'] == 1) {
$fields['edit_priv'][$counter] = 1;
}
if ($userdefine_priv_Infor['delete_priv'] == 1) {
$fields['delete_priv'][$counter] = 1;
}
if ($userdefine_priv_Infor['shenhe_priv'] == 1) {
$fields['shenhe_priv'][$counter] = 1;
}
if ($userdefine_priv_Infor['flow_priv'] == 1) {
$fields['flow_priv'][$counter] = 1;
}
if ($userdefine_priv_Infor['next_priv'] == 1) {
$fields['next_priv'][$counter] = 1;
}
if ($userdefine_priv_Infor == 1) {
$fields['view_priv'][$counter] = 1;
$fields['edit_priv'][$counter] = 1;
$fields['delete_priv'][$counter] = 1;
$fields['shenhe_priv'][$counter] = 1;
$fields['flow_priv'][$counter] = 1;
$fields['next_priv'][$counter] = 1;
}
//print_R($fields['delete_priv']);
}
break;
}
global $limitEditDelUser;
global $limitEditDelCust;
if ($limitEditDelUser != '') {
//限制上级的编辑和删除权限
if ($_SESSION['limitEditDel'] == '0' && $fields['value2'][$counter][$limitEditDelUser] != $_SESSION['LOGIN_USER_ID'] && $_SESSION['LOGIN_USER_ID'] != 'admin' && $fields['value2'][$counter]['datascope'] != '1') {
$fields['edit_priv'][$counter] = 1;
$fields['delete_priv'][$counter] = 1;
}
//限制公共客户的编辑和删除权限
if ($fields['value2'][$counter]['datascope'] == '1' && !ifHasRoleUser($fields['value2'][$counter][$limitEditDelUser])) {
$fields['edit_priv'][$counter] = 1;
$fields['delete_priv'][$counter] = 1;
}
}
if ($limitEditDelCust != '') {
$guanlianSysuser = returntablefield("customer", "rowid", $fields['value2'][$counter][$limitEditDelCust], "sysuser,datascope");
////限制上级的编辑和删除权限
if ($_SESSION['limitEditDel'] == '0' && $guanlianSysuser['sysuser'] != $_SESSION['LOGIN_USER_ID'] && $_SESSION['LOGIN_USER_ID'] != 'admin' && $guanlianSysuser['datascope'] != '1') {
$fields['edit_priv'][$counter] = 1;
$fields['delete_priv'][$counter] = 1;
}
//限制公共客户的编辑和删除权限
if ($guanlianSysuser['datascope'] == '1' && !ifHasRoleUser($guanlianSysuser['sysuser'])) {
$fields['edit_priv'][$counter] = 1;
$fields['delete_priv'][$counter] = 1;
}
}
$fields['elementlink'][$counter][$list_index] = $fields['value'][$counter][$list_index];
$fields['value'][$counter][$list_index] = $filtervalue;
}
$counter++;
}
$fields['other']['pageid'] = $pageid;
$fields['other']['pagenums'] = $pagenums;
$fields['other']['rc'] = $rc;
//print_r($fields['delete_priv']);print_r($fields['edit_priv']);exit;
return $fields;
}
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>";
}
