📄 index.php
字号:
echo " <select name='CUSTOMER";
echo $FIELDNO;
echo "' class=\"SmallSelect\">\r\n <option value=\"\"></option>\r\n";
$I = 0;
for ( ; $I < $TYPENAME_COUNT; ++$I )
{
echo "\r\n <option value=\"";
echo $TYPEVALUE_ARRAY[$I];
echo "\">";
echo $TYPENAME_ARRAY[$I];
echo "</option>\r\n\r\n";
}
}
if ( $STYPE == "C" )
{
if ( $TYPECODE != "" )
{
$query2 = "select * from SYS_CODE where PARENT_NO='".$TYPECODE."' order by CODE_ORDER";
$cursor2 = exequery( $connection, $query2 );
while ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
$TYPEVALUE = $TYPEVALUE.$CODE_NO.",";
$TYPENAME = $TYPENAME.$CODE_NAME.",";
}
}
$TYPEVALUE = str_replace( ",", ",", $TYPEVALUE );
$TYPEVALUE_ARRAY = explode( ",", $TYPEVALUE );
$TYPENAME = str_replace( ",", ",", $TYPENAME );
$TYPENAME_ARRAY = explode( ",", $TYPENAME );
$TYPENAME_COUNT = sizeof( $TYPENAME_ARRAY );
if ( $TYPENAME_ARRAY[$TYPENAME_COUNT - 1] == "" )
{
--$TYPENAME_COUNT;
}
echo " <input type=\"hidden\" name='CUSTOMER";
echo $FIELDNO;
echo "'>\r\n";
$I = 0;
for ( ; $I < $TYPENAME_COUNT; ++$I )
{
echo " <input type=\"checkbox\" name='CCUSTOMER";
echo $FIELDNO;
echo "' id='CCUSTOMER";
echo $FIELDNO;
echo $I;
echo "' value=\"";
echo $TYPEVALUE_ARRAY[$I];
echo "\" onclick=\"return chk(this,'CCUSTOMER";
echo $FIELDNO;
echo "','CUSTOMER";
echo $FIELDNO;
echo "','";
echo $TYPENAME_COUNT;
echo "');\"><label for=\"CCUSTOMER";
echo $FIELDNO;
echo $I;
echo "\">";
echo $TYPENAME_ARRAY[$I];
echo "</label>\r\n\r\n";
}
}
if ( $STYPE == "R" )
{
if ( $TYPECODE != "" )
{
$query2 = "select * from SYS_CODE where PARENT_NO='".$TYPECODE."' order by CODE_ORDER";
$cursor2 = exequery( $connection, $query2 );
while ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
$TYPEVALUE = $TYPEVALUE.$CODE_NO.",";
$TYPENAME = $TYPENAME.$CODE_NAME.",";
}
}
$TYPEVALUE = str_replace( ",", ",", $TYPEVALUE );
$TYPEVALUE_ARRAY = explode( ",", $TYPEVALUE );
$TYPENAME = str_replace( ",", ",", $TYPENAME );
$TYPENAME_ARRAY = explode( ",", $TYPENAME );
$TYPENAME_COUNT = sizeof( $TYPENAME_ARRAY );
if ( $TYPENAME_ARRAY[$TYPENAME_COUNT - 1] == "" )
{
--$TYPENAME_COUNT;
}
$I = 0;
for ( ; $I < $TYPENAME_COUNT; ++$I )
{
echo " <input type=\"radio\" name='CUSTOMER";
echo $FIELDNO;
echo "' id='CUSTOMER";
echo $FIELDNO;
echo $I;
echo "' value=\"";
echo $TYPEVALUE_ARRAY[$I];
echo "\"><label for=\"CUSTOMER";
echo $FIELDNO;
echo $I;
echo "\">";
echo $TYPENAME_ARRAY[$I];
echo "</label>\r\n";
}
}
echo "\r\n </td>\r\n </tr>\r\n";
}
}
echo "<tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"6\" align=\"left\">\r\n 导出内容:\r\n </td>\r\n</tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" colspan=\"6\" align=\"center\">\r\n \t<br>\r\n \t<table width=\"150\" border=\"1\" cellspacing=\"0\" cellpadding=\"3\" bordercolorlight=\"#000000\" bordercolordark=\"#FFFFFF\" class=\"small\">\r\n <tr bgcolor=\"#CCCCCC\">\r\n <td align=\"center\">排序</td>\r\n <td align=\"center\"><b>显示字段</b></td>\r\n <td align=\"center\"> </td>\r\n <td align=\"center\" valign=\"top\"><b>可选字段</b></td>\r\n </tr>\r\n <tr>\r\n \t<td align=\"center\" bgcolor=\"#999999\">\r\n <input type=\"button\" class=\"SmallInput\" value=\" ↑ \" onclick=\"func_up();\">\r\n <br><br>\r\n <input type=\"button\" class=\"SmallInput\" value=\" ↓ \" onclick=\"func_down();\">\r\n </td>\r\n <td valign=\"top\" align=\"center\" bgcolor=\"#CCCCCC\">\r\n <select name=\"select1\" ondblclick=\"func_delete();\" MULTIPLE style=\"width:200;height:280\">\r\n </select>\r\n <input type=\"button\" value=\" 全 选 \" onclick=\"func_select_all1();\" class=\"SmallInput\">\r\n </td>\r\n\r\n <td align=\"center\" bgcolor=\"#999999\">\r\n <input type=\"button\" class=\"SmallInput\" value=\" ← \" onclick=\"func_insert();\">\r\n <br><br>\r\n <input type=\"button\" class=\"SmallInput\" value=\" → \" onclick=\"func_delete();\">\r\n </td>\r\n\r\n <td align=\"center\" valign=\"top\" bgcolor=\"#CCCCCC\">\r\n <select name=\"select2\" ondblclick=\"func_insert();\" MULTIPLE style=\"width:200;height:280\">\r\n <option value=\"CUSTOMER_NAME\">客户名称</option>\r\n <option value=\"CUSTOMER_CODE\">客户编码</option>\r\n <option value=\"CUSTOMER_SHORT\">客户简称</option>\r\n <option value=\"TEL_NO\">电话</option>\r\n <option value=\"FAX_NO\">传真</option>\r\n <option value=\"CUSTOMER_WWW\">网址</option>\r\n <option value=\"EMAIL\">电子邮件</option>\r\n <option value=\"CUSTOMER_AREA\">地区</option>\r\n <option value=\"POSTALCODE\">邮政编码</option>\r\n <option value=\"CUSTOMER_ADD\">详细地址</option>\r\n <option value=\"SOURCE\">客户来源</option>\r\n <option value=\"KIND\">客户类别</option>\r\n <option value=\"SELLMODE\">销售方式</option>\r\n <option value=\"ATTRIBUTE\">行业属性</option>\r\n <option value=\"ENTERTYPE\">企业性质</option>\r\n <option value=\"ENTERMEMO\">企业描述</option>\r\n <option value=\"MEMO\">备注1</option>\r\n <option value=\"MEMO1\">备注2</option>\r\n";
$query = "select * from FIELDSETTING where TABLENAME='CUSTOMER' ORDER BY ORDERNO ASC ";
$cursor1 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
echo " \r\n <option value=\"";
echo $ROW['FIELDNO'];
echo "\">";
echo $ROW['FIELDNAME'];
echo "</option>\r\n";
}
echo " \r\n </select>\r\n <input type=\"button\" value=\" 全 选 \" onclick=\"func_select_all2();\" class=\"SmallInput\">\r\n </td>\r\n </tr>\r\n</table>\r\n \t<br>\r\n </td>\r\n</tr>\r\n <tr>\r\n \t\t<td nowrap class=\"TableData\" colspan=\"6\" align=\"center\" width=\"650\">\r\n <input value=\"EXCEL报表\" type=\"button\" class=\"SmallButton\" title=\"EXCEL报表\" name=\"button\" onClick=\"exreport()\"> \r\n <input value=\"WORD报表\" type=\"button\" class=\"SmallButton\" title=\"WORD报表\" name=\"button\" onClick=\"wordeport()\"> \r\n <input value=\"清空\" type=\"button\" class=\"SmallButton\" title=\"清空\" name=\"button\" onclick=\"location='index.php'\"> \r\n <input value=\"返回\" type=\"button\" class=\"SmallButton\" title=\"返回\" name=\"button\" onclick=\"location='../index.php'\"> \r\n <input type=\"hidden\" name=\"FIELDMSG\">\r\n <input type=\"hidden\" name=\"FIELDMSGNAME\">\r\n </td>\r\n </tr>\r\n\r\n</table>\r\n</fieldset>\r\n</div>\r\n</body>\r\n</html>\r\n\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -