function newai_import_XLS($Columns)
{
global $_FILES, $_POST, $_GET, $db;
global $showlistfieldlist, $showlistfieldfilter, $primarykey, $primarykey_index, $uniquekey;
global $common_html, $html_etc;
global $return_sql_line;
global $columns;
global $showlistfieldlist_key;
global $foreignkey, $showFieldName, $tablename;
if (is_uploaded_file($_FILES['uploadfileXLS']['tmp_name'])) {
$uploadfile_self = $_FILES['uploadfileXLS']['tmp_name'];
$uploadfile_name = $_FILES['uploadfileXLS']['name'];
$checkFileType = substr($uploadfile_name, -3);
if ($checkFileType != "xls") {
print_nouploadfile("你上传的不是EXCEL格式的文件!");
exit;
}
//print $checkFileType;exit;
if (!is_dir("FileCache")) {
mkdir("FileCache");
}
$uploadfile_name = "FileCache/" . $uploadfile_name;
copy($_FILES['uploadfileXLS']['tmp_name'], $uploadfile_name);
if (is_file("../../Framework/PHPExcelParser4/readExcel.php")) {
require_once "../../Framework/PHPExcelParser4/readExcel.php";
} else {
if (is_file("../DANDIAN/PHPExcelParser4/readExcel.php")) {
require_once "../DANDIAN/PHPExcelParser4/readExcel.php";
} else {
require_once "../Framework/PHPExcelParser4/readExcel.php";
}
}
$a = new ReadExcel($uploadfile_name);
$tmp = $a->read();
//按列读取的数据,转换为按行读取的数据
$MainData = $tmp[0];
$ColumnNumber = sizeof(array_values($MainData));
if ($MainData[$ColumnNumber - 1][0] == '错误信息') {
--$ColumnNumber;
}
for ($i = 0; $i < $ColumnNumber; $i++) {
$ColumnArray = $MainData[$i];
for ($ii = 0; $ii < sizeof($ColumnArray); $ii++) {
$ContentArray[$ii][$i] = $ColumnArray[$ii];
//$ContentArray[$ii][$i] = str_replace("，",",", $ContentArray[$ii][$i]);
}
}
$first_row_array = $ContentArray[0];
$first_row_array_chinese = $first_row_array;
//print_r($first_row_array);exit;
// changchang008@gmail.com at 2012-2-7
$sql = "select fieldname,chinese,english from systemlang where tablename='" . $tablename . "'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$fieldchinesename_to_fieldname = array();
foreach ($rs_a as $row) {
if (in_array($row[fieldname], $columns)) {
$fieldchinesename_to_fieldname[$row[chinese]] = $row[fieldname];
}
}
foreach ($first_row_array as $key => $vo) {
if (isset($fieldchinesename_to_fieldname[$vo])) {
$first_row_array[$key] = $fieldchinesename_to_fieldname[$vo];
}
}
for ($iii = 0; $iii < sizeof($first_row_array); $iii++) {
$first_row_array[$iii] = TRIM($first_row_array[$iii]);
}
//得到字段过滤信息列表
$newstring = array();
$newstring1 = array();
//需关联的字段
$newstring2 = array();
//需过滤的字段
$showlistfieldlistArray = explode(',', $showlistfieldlist);
$showlistfieldfilterArray = explode(',', $showlistfieldfilter);
//可以允许导入的列表
for ($i = 0; $i < sizeof($showlistfieldlistArray); $i++) {
if ($showlistfieldlistArray[$i] != '') {
$ElementTableField = $showlistfieldlistArray[$i];
$ElementFieldName = $Columns[$ElementTableField];
array_push($newstring, $ElementFieldName);
$filterItemArray = explode(":", $showlistfieldfilterArray[$i]);
if ($filterItemArray[0] == "tablefilter" || $filterItemArray[0] == "tablefiltercolor" || $filterItemArray[0] == "radiofilter" || $filterItemArray[0] == "zhujima" || $filterItemArray[0] == "system_datetime") {
$newstring1[$ElementFieldName] = $showlistfieldfilterArray[$i];
}
if ($filterItemArray[0] == "input" && $filterItemArray[1] == "name") {
$newstring2[$ElementFieldName] = $showlistfieldfilterArray[$i];
}
}
}
//$result = array_intersect ($newstring, $first_row_array);
$result = array();
foreach ($first_row_array as $row) {
if (in_array($row, $newstring)) {
$result[] = $row;
}
}
if (sizeof($result) == 0) {
print "<script language='javascript'>alert('没有可导入的列，请检查Excel的列头');window.history.back(-1);</script>";
exit;
}
//自动递增的主键
if (!empty($primarykey_index)) {
$sql = "select max({$primarykey_index}) as max from {$tablename}";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$primarykey_value = intval($rs_a[0][max]);
}
// 须要检查的唯一key
$uniquekeyArray = explode(',', $uniquekey);
foreach ($uniquekeyArray as $key => $row) {
$uniquekeyArray[$key] = $columns[$row];
}
//数据行检测
$Insert_RIGHT = 0;
$Insert_ERROR = 0;
$is_error = false;
$ChildTableCacheArray = array();
//缓存关联到的数据
for ($i = 1; $i < sizeof($ContentArray); $i++) {
$line_array = $ContentArray[$i];
$line_array_text = join("','", $line_array);
$newline_array = array();
//以前的SIZEOF用的是line_array变量，后变为first_row_array，用于对应一些没有发生的变化
$uniquekey_error_sig = false;
$uniquekey_error_info = '';
$uniquekey_Array = array();
for ($j = 0; $j < sizeof($first_row_array); $j++) {
$convertFirstRow = array_flip($first_row_array);
//主键不能为空
$j_prikey = -1;
$j_prikey = $convertFirstRow[$primarykey_index];
if ($j_prikey > -1) {
if (TRIM($line_array[$j_prikey]) == '') {
$line_array[$j_prikey] = ++$primarykey_value;
//$uniquekey_error_sig = true;
//$is_error = true;
//$uniquekey_error_info .= '<'.$ContentArray[0][$j_prikey].">列数据不能为空、";
//break;
}
}
//索引键不能重复
$sql_where = '';
$uniquekey_realname = '';
foreach ($uniquekeyArray as $key => $value) {
if ($value != '') {
$j_prikey = $convertFirstRow[$value];
$sql_where .= " and {$value} ='" . $line_array[$j_prikey] . "'";
$uniquekey_realname .= $ContentArray[0][$j_prikey] . ",";
}
}
if ($sql_where != '') {
$exists_sql_text = "select count(*) as num from {$tablename} where 1=1" . $sql_where;
$rs = $db->Execute($exists_sql_text);
$rs_a = $rs->GetArray();
if ($rs_a[0][num] != 0) {
$uniquekey_error_sig = true;
$is_error = true;
$uniquekey_error_info .= '<' . $uniquekey_realname . ">列数据不能和数据库中的数据重复";
break;
}
}
//对每格数据进行处理
$ColumnName = $first_row_array[$j];
$in_array = in_array($ColumnName, $result);
if ($in_array) {
if (array_key_exists($ColumnName, $newstring1)) {
$ChildTableArray = explode(":", $newstring1[$ColumnName]);
if ($ChildTableArray[0] == 'zhujima') {
$srcFieldName = $Columns[$ChildTableArray[1]];
$key = array_search($srcFieldName, $first_row_array);
$line_array[$j] = 汉字转拼音首字母($line_array[$key]);
} else {
if ($ChildTableArray[0] == 'system_datetime') {
if ($line_array[$j] == '') {
$line_array[$j] = date("Y-m-d H:i:s");
} else {
if (strtotime($line_array[$j]) == -1) {
$line_array[$j] = date("Y-m-d H:i:s");
}
}
} else {
$ChildTableName = $ChildTableArray[1];
if ($ChildTableCacheArray[$ChildTableName][$line_array[$j]] == '' && $line_array[$j] != '') {
$ChildColumns = returntablecolumn($ChildTableName);
$ChildTableFieldValue = $ChildColumns[$ChildTableArray[2]];
$ChildTableFieldName = $ChildColumns[$ChildTableArray[3]];
$realvalue = returntablefield($ChildTableName, $ChildTableFieldName, $line_array[$j], $ChildTableFieldValue);
if ($realvalue == '') {
$uniquekey_error_sig = true;
$is_error = true;
$uniquekey_error_info .= '<' . $first_row_array_chinese[$j] . ">列在关联表" . $ChildTableName . "中找不到对应的数据";
break;
}
$ChildTableCacheArray[$ChildTableName][$line_array[$j]] = $realvalue;
} else {
$realvalue = $ChildTableCacheArray[$ChildTableName][$line_array[$j]];
}
$line_array[$j] = $realvalue;
}
}
}
if (array_key_exists($ColumnName, $newstring2)) {
$line_array[$j] = str_replace("\r", "", $line_array[$j]);
$line_array[$j] = str_replace("\n", "", $line_array[$j]);
$line_array[$j] = str_replace("'", "", $line_array[$j]);
//$line_array[$j]=str_replace("\"","",$line_array[$j]);
$line_array[$j] = str_replace("\\", "", $line_array[$j]);
$line_array[$j] = str_replace("/", "", $line_array[$j]);
$line_array[$j] = str_replace(",", "", $line_array[$j]);
$line_array[$j] = str_replace("#", "", $line_array[$j]);
}
/*
if(function_exists('FK_'.$tablename.'_'.$ColumnName)){
$line_array[$j] = call_user_func('FK_'.$tablename.'_'.$ColumnName,$line_array[$j]);
}
*/
$ResultFieldCode = $line_array[$j];
array_push($newline_array, htmlentitiesUser($ResultFieldCode));
}
}
//分析结束
if ($uniquekey_error_sig) {
$ContentArray[$i][FK_error_info] = $uniquekey_error_info;
$Insert_ERROR += 1;
} else {
if (!empty($primarykey_index) && !in_array($primarykey_index, $result)) {
$newline_array[] = ++$primarykey_value;
$result_add = ',' . $primarykey_index;
}
$insert_sql_text = "insert into " . $tablename . "(" . join(',', $result) . $result_add . ") values('" . join("','", $newline_array) . "')";
//exit($insert_sql_text);
$rs = $db->Execute($insert_sql_text);
if ($rs->EOF) {
$Insert_RIGHT += 1;
} else {
$Insert_ERROR += 1;
$ContentArray[$i][FK_error_info] = $insert_sql_text;
}
}
}
if ($is_error) {
if (is_file("../../Framework/PHPExcelParser4/WriteExcel/class.writeexcel_workbook.inc.php")) {
require_once "../../Framework/PHPExcelParser4/WriteExcel/class.writeexcel_workbook.inc.php";
require_once "../../Framework/PHPExcelParser4/WriteExcel/class.writeexcel_worksheet.inc.php";
} else {
if (is_file("../DANDIAN/PHPExcelParser4/WriteExcel/class.writeexcel_workbook.inc.php")) {
require_once "../DANDIAN/PHPExcelParser4/WriteExcel/class.writeexcel_workbook.inc.php";
require_once "../DANDIAN/PHPExcelParser4/WriteExcel/class.writeexcel_worksheet.inc.php";
} else {
require_once "../Framework/PHPExcelParser4/WriteExcel/class.writeexcel_workbook.inc.php";
require_once "../Framework/PHPExcelParser4/WriteExcel/class.writeexcel_worksheet.inc.php";
}
}
if (!is_dir("FileCache")) {
mkdir("FileCache");
}
$fname = "FileCache/导入失败记录.xls";
@unlink($fname);
$workbook =& new writeexcel_workbook($fname);
$worksheet1 =& $workbook->addworksheet('Sheet1');
# Frozen panes
$worksheet1->freeze_panes(1, 0);
# 1 row
$header =& $workbook->addformat();
$header->set_color('white');
$header->set_align('center');
$header->set_align('vcenter');
$header->set_pattern();
$header->set_fg_color('green');
$center =& $workbook->addformat();
$center->set_align('center');
$center->set_align('vcenter');
$header->set_pattern();
//列出字段的EXCEL列,通过此指定列宽度
$LitterArray = explode(',', 'A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z');
$LeftArray = array();
$LitterSize = sizeof($LitterArray);
for ($i = 0; $i < 10; $i++) {
if ($i == 0) {
$Little = '';
} else {
$Little = $LitterArray[$i - 1];
}
for ($ii = 0; $ii < $LitterSize; $ii++) {
$PartLitte = $LitterArray[$ii];
$Left = $Little . $PartLitte;
array_push($LeftArray, $Left);
}
}
//宽度值形成列表
$title_row_array = $ContentArray[0];
$title_row_array[] = '错误信息';
$TEMPVALUE = sizeof($title_row_array);
$LastValue = $LeftArray[$TEMPVALUE - 1];
for ($i = 0; $i < sizeof($title_row_array); $i++) {
//宽度值形成列表
$LastValue = $LeftArray[$i];
$LENGHT_VALUE = strlen($title_row_array[$i]);
$LENGHT_VALUE > 50 ? $LENGHT_VALUE = 50 : '';
$worksheet1->set_column($LastValue . ":" . $LastValue, $LENGHT_VALUE);
}
//写标题
for ($i = 0; $i < sizeof($title_row_array); $i++) {
//行列内容
$Element = $title_row_array[$i];
$worksheet1->write_string(0, $i, $Element, $header);
}
//写内容
$m = 0;
foreach ($ContentArray as $vo) {
if (!empty($vo['FK_error_info'])) {
$i = 0;
foreach ($vo as $row) {
$worksheet1->write_string($m + 1, $i, $row, $center);
$i++;
}
++$m;
}
}
$workbook->close();
$down_error_file = "<a href='./FileCache/导入失败记录.xls'>请点击此处下载导入错误的记录，修改正确后重新导入！</a>";
}
page_css('数据导入');
$Insert_Text = "新增数据成功:{$Insert_RIGHT} 条 失败:{$Insert_ERROR} 条";
//返回值链接判断,如果是回到首页,则直接用链接,否则则直接返回
global $returnmodel;
if ($returnmodel == "import_default") {
$returnmodel_TEXT = "history.back();";
} else {
$returnmodel_TEXT = "location='?action={$returnmodel}'";
}
print "\n\t\t\t\t<style type='text/css'>.style1 {\n\t\t\t\tcolor: #FFFFFF;\n\t\t\t\tfont-weight: bold;\n\t\t\t\tfont-family: Arial, Helvetica, sans-serif;\n\t\t\t\tfont-size: 14px;\n\t\t\t\t}\n\t\t\t\t</style>\n\t\t\t\t<BR><BR>\n\t\t\t\t<table width='450' border='0' align='center' cellpadding='0' cellspacing='0' class='small' style='border:1px solid #006699;'>\n\t\t\t\t<tr><td height='110' align='middle' colspan=2 bgcolor='#E0F2FC'>\n\t\t\t\t<font color=red >" . $common_html['common_html']['importsuccess'] . "<BR><BR>{$Insert_Text}<BR><BR>{$down_error_file}<BR><BR><input type=button accesskey='c' name='cancel' value=' 点击返回 ' class=SmallButton onClick=\"{$returnmodel_TEXT}\" title='快捷键:ALT+c'></font>\n\t\t\t\t</td></tr></table>";
unlink($uploadfile_name);
exit;
} else {
print_nouploadfile();
}
}
<?php
/*
版权归属:郑州单点科技软件有限公司;
联系方式:0371-69663266;
公司地址:河南郑州经济技术开发区第五大街经北三路通信产业园四楼西南;
公司简介:郑州单点科技软件有限公司位于中国中部城市-郑州,成立于2007年1月,致力于把基于先进信息技术（包括通信技术）的最佳管理与业务实践普及到教育行业客户的管理与业务创新活动中，全面提供具有自主知识产权的教育管理软件、服务与解决方案，是中部最优秀的高校教育管理软件及中小学校管理软件提供商。目前己经有多家高职和中职类院校使用通达中部研发中心开发的软件和服务;
软件名称:单点科技软件开发基础性架构平台,以及在其基础之上扩展的任何性软件作品;
发行协议:数字化校园产品为商业软件,发行许可为LICENSE方式;单点CRM系统即SunshineCRM系统为GPLV3协议许可,GPLV3协议许可内容请到百度搜索;
特殊声明:软件所使用的ADODB库,PHPEXCEL库,SMTARY库归原作者所有,余下代码沿用上述声明;
*/
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
error_reporting(E_WARNING | E_ERROR);
require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
validateMenuPriv("供应商");
if ($_GET['action'] == "edit_default_data" || $_GET['action'] == "add_default_data") {
$_POST['supplycn'] = 汉字转拼音首字母($_POST['supplyname']);
}
if ($_GET['action'] == "addlinkman") {
print "<script>location.href='supplylinkman_newai.php?action=add_default&supplyid=" . $_GET['ROWID'] . "';</script>";
exit;
}
addShortCutByDate("startdate", "建立日期");
$filetablename = "supply";
require_once "include.inc.php";
$mainrowid = returntablefield("buyplanmain_detail", "prodid", $_GET['productid'], "mainrowid");
if ($mainrowid != "") {
print "<script language='javascript'>alert('产品编号 " . $_GET['productid'] . " 已存在于采购单 {$mainrowid} 中，不能修改编号');window.history.back(-1);</script>";
exit;
}
}
if ($_POST['oldproductid'] != '' && $_POST['supplyid'] != '') {
$sql = "select productid from product where oldproductid='" . $_POST['oldproductid'] . "' and supplyid=" . $_POST['supplyid'] . " and productid<>'" . $_GET['productid'] . "'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
if (sizeof($rs_a) > 0) {
print "<script language='javascript'>alert('此厂家已存在原厂码为 " . $_POST['oldproductid'] . " 的产品');window.history.back(-1);</script>";
exit;
}
}
$_POST['productcn'] = 汉字转拼音首字母($_POST['productname']);
} else {
if ($_GET['action'] == "" && $_GET['producttype'] != "") {
$ids = $_GET['producttype'];
getIds($_GET['producttype']);
$SYSTEM_ADD_SQL = "and producttype in (" . $ids . ")";
$_GET['producttype'] = "";
}
}
//判断是否已使用
if ($_GET['action'] == "delete_array") {
$selectid = $_GET['selectid'];
$selectid = explode(",", $selectid);
for ($i = 0; $i < sizeof($selectid); $i++) {
if ($selectid[$i] != "") {
$mainrowid = returntablefield("stockinmain_detail", "prodid", $selectid[$i], "mainrowid");
function autoCreateProduct()
{
global $rowid;
global $tablename;
global $db;
try {
$db->StartTrans();
$supplyid = returntablefield("buyplanmain", "billid", $rowid, "supplyid");
$sql = "select a.*,b.productid,b.sellprice as psellprice from {$tablename} a left join product b on a.oldproductid=b.oldproductid and b.supplyid={$supplyid} where b.productid is null and mainrowid=" . $rowid;
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
$prodArray = array();
for ($i = 0; $i < count($rs_a); $i++) {
if ($rs_a[$i]['prodname'] == '') {
throw new Exception("商品" . $rs_a[$i]['oldproductid'] . "的名称不能为空");
}
if (floatval($rs_a[$i]['sellprice']) == 0) {
throw new Exception("商品" . $rs_a[$i]['oldproductid'] . "的零售价不能为0");
}
if ($prodArray[$rs_a[$i]['oldproductid']] == '') {
if ($rs_a[$i]['prodid'] == '') {
$barcode = "2";
$str_supplyid = $supplyid;
while (strlen($str_supplyid) < 4) {
$str_supplyid = "0" . $str_supplyid;
}
if ($rs_a[$i]['prodtype'] == '') {
throw new Exception("商品" . $rs_a[$i]['oldproductid'] . "的类型不能为空");
}
$str_prodtype = $rs_a[$i]['prodtype'];
while (strlen($str_prodtype) < 3) {
$str_prodtype = "0" . $str_prodtype;
}
$barcode .= $str_supplyid . $str_prodtype;
$maxid = 1;
$sql = "select max(substr(productid,9,4)) as maxid from product where left(productid,8)='" . $barcode . "'";
$rs = $db->Execute($sql);
$rs_b = $rs->GetArray();
if (!empty($rs_b[0][maxid])) {
$maxid = $rs_b[0][maxid] + 1;
}
while (strlen($maxid) < 4) {
$maxid = "0" . $maxid;
}
$barcode .= $maxid;
$jishu = 0;
$oushu = 0;
for ($j = 0; $j < 6; $j++) {
$jishu = $jishu + intval($barcode[$j * 2]);
$oushu = $oushu + intval($barcode[$j * 2 + 1]);
}
$jiaoyan = 10 - ($jishu + $oushu * 3) % 10;
if ($jiaoyan == 10) {
$jiaoyan = 0;
}
$barcode .= $jiaoyan;
$rs_a[$i]['prodid'] = $barcode;
}
$prodArray[$rs_a[$i]['oldproductid']] = $rs_a[$i]['prodid'];
} else {
$rs_a[$i]['prodid'] = $prodArray[$rs_a[$i]['oldproductid']];
}
if ($rs_a[$i]['productid'] == '') {
$productid = returntablefield("product", "productid", $rs_a[$i]['prodid'], "productid");
if ($productid == '') {
if ($rs_a[$i]['danwei'] == '') {
$rs_a[$i]['danwei'] = '个';
}
$productcn = 汉字转拼音首字母($rs_a[$i]['prodname']);
$sql = "insert into product (productid,productname,measureid,producttype,sellprice,productcn,oldproductid,ifkucun,supplyid) \n\t\t \t\tvalues('" . $rs_a[$i]['prodid'] . "','" . $rs_a[$i]['prodname'] . "','" . $rs_a[$i]['danwei'] . "'," . $rs_a[$i]['prodtype'] . "," . $rs_a[$i]['sellprice'] . ",'{$productcn}','" . $rs_a[$i]['oldproductid'] . "','是',{$supplyid})";
$db->Execute($sql);
}
}
}
$db->CompleteTrans();
} catch (Exception $e) {
print $e->getMessage();
exit;
}
}
软件名称:单点科技软件开发基础性架构平台,以及在其基础之上扩展的任何性软件作品;
发行协议:数字化校园产品为商业软件,发行许可为LICENSE方式;单点CRM系统即SunshineCRM系统为GPLV3协议许可,GPLV3协议许可内容请到百度搜索;
特殊声明:软件所使用的ADODB库,PHPEXCEL库,SMTARY库归原作者所有,余下代码沿用上述声明;
*/
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
error_reporting(E_WARNING | E_ERROR);
require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
validateMenuPriv("客户联系人");
$customerid = $_GET['customerid'];
if ($customerid != '' && $_GET['action'] == 'add_default') {
$ADDINIT = array("customerid" => $customerid);
}
if ($_GET['action'] == 'add_default_data' || $_GET['action'] == 'edit_default_data') {
$_POST['linkmanpy'] = 汉字转拼音首字母($_POST['linkmanname']);
}
if ($_GET['action'] == 'operation_sendsms') {
validateMenuPriv("手机短信");
$selectid = $_GET['selectid'];
print "<script>location='sms_sendlist_newai.php?action=add_default&sendlist=" . $selectid . "&fromsrc=customer';</script>";
exit;
}
if ($_GET['action'] == 'operation_sendemail') {
validateMenuPriv("发送邮件");
$selectid = $_GET['selectid'];
print "<script>location='../CRM/email_newai.php?action=add_default&sendlist=" . $selectid . "&fromsrc=customer';</script>";
exit;
}
if ($_GET['action'] == 'operation_printKuaiDi') {
$selectid = $_GET['selectid'];
ini_set('error_reporting', E_ALL);
error_reporting(E_WARNING | E_ERROR);
require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
//print_r($_GET);exit;
validateMenuPriv("客户基本信息");
if ($_GET['action'] == "add_default") {
$ADDINIT = array("sysuser" => $_SESSION['LOGIN_USER_ID']);
}
if ($_GET['action'] == "edit_default_data" || $_GET['action'] == "add_default_data") {
if ($_POST['amtagio'] <= 0 || $_POST['amtagio'] > 1) {
//print "<script language='javascript'>alert('折扣必须介于0-1之间');window.history.back(-1);</script>";
//exit;
$_POST['amtagio'] = 1;
}
$_POST['calling'] = 汉字转拼音首字母($_POST['supplyname']);
}
if ($_GET['action'] == "view_default") {
global $db;
$billid = $_GET['ROWID'];
$sql = "SELECT a.*,b.`name` as state,c.`name` as enterstype,a.style,e.USER_NAME as blong,e.USER_NAME,f.`name` as origin,g.`name` as salemode,h.`name` as property,a.yuchuzhi,a.createdate,a.integral,a.explainStr FROM customer a\n\t\tLEFT JOIN customerlever b on a.state=b.ROWID LEFT JOIN unitprop c on a.enterstype=c.ROWID LEFT JOIN `user` ee on a.user_id=ee.USER_ID LEFT JOIN `user` e on a.sysuser=e.USER_ID LEFT JOIN customerorigin f on a.origin=f.ROWID LEFT JOIN salemode g on a.salemode=g.ROWID LEFT JOIN property h on a.property=h.ROWID WHERE a.ROWID=" . $billid;
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
page_css("客户综合视图");
$custname = $rs_a[0][supplyname];
$UID = returntablefield("user", "user_id", $rs_a[$i]['user_id'], "uid");
$UID1 = returntablefield("user", "user_id", $rs_a[$i]['sysuser'], "uid");
$editrole = false;
/*
if(ifHasRoleCust($billid))
{
