📄 index.php
字号:
}
echo "\r\n </td>\r\n </tr>\r\n";
}
}
echo "<tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"8\" align=\"left\">\r\n 联系人基本信息：\r\n </td>\r\n</tr> \t\r\n <tr>\r\n <td nowrap class=\"TableData\"> 联系人姓名：</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"LINKMAN_NAME\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $CUSTOMER_NAME;
echo "\">\r\n </td>\r\n <td nowrap class=\"TableData\">联系人职位： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"POST_PRIV\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $CUSTOMER_CODE;
echo "\">\r\n </td>\r\n\r\n <td nowrap class=\"TableData\">家庭邮编：</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"POSTALCODE_HOME\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $CUSTOMER_SHORT;
echo "\">\r\n </td>\r\n <td nowrap class=\"TableData\">性别： </td>\r\n <td nowrap class=\"TableData\" >\r\n <select name=\"SEX\" class=\"SmallSelect\">\r\n \t<option value=\"\" ></option>\r\n <option value=\"0\" >男</option>\r\n <option value=\"1\" >女</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n \t <td nowrap class=\"TableData\"> 家庭住址： </td>\r\n <td nowrap class=\"TableData\" colspan=\"2\">\r\n <textarea cols=27 rows=1 name=\"ADD_HOME\" class=\"SmallInput\" wrap=\"yes\">";
echo $MEMO;
echo "</textarea>\r\n </td>\r\n <td nowrap class=\"TableData\" colspan=\"5\">备注： \r\n <textarea cols=37 rows=1 name=\"MEMO1\" class=\"SmallInput\" wrap=\"yes\">";
echo $MEMO;
echo "</textarea>\r\n </td>\r\n </tr>\r\n";
$count = 0;
$connection = openconnection( );
$query = "select count(*) from FIELDSETTING where TABLENAME='PROVIDER_LINKMAN' and ISQUERY='1'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$count = $ROW[0];
}
if ( 0 < $count )
{
echo " <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"8\" align=\"left\">\r\n （联系人）用户自定义字段：\r\n </td>\r\n </tr>\r\n";
$query = "select * from FIELDSETTING where TABLENAME='PROVIDER_LINKMAN' AND ISQUERY='1' ORDER BY ORDERNO ASC ";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$FIELDNAME = $ROW['FIELDNAME'];
$ORDERNO = $ROW['ORDERNO'];
$STYPE = $ROW['STYPE'];
$TYPENAME = $ROW['TYPENAME'];
$TYPEVALUE = $ROW['TYPEVALUE'];
$TYPECODE = $ROW['TYPECODE'];
$ISQUERY = $ROW['ISQUERY'];
$ISGROUY = $ROW['ISGROUY'];
$FIELDNAME = $ROW['FIELDNAME'];
$FIELDNO = $ROW['FIELDNO'];
echo " <tr>\r\n <td nowrap class=\"TableData\"> ";
echo $FIELDNAME;
echo "：</td>\r\n <td nowrap class=\"TableData\" colspan=\"8\">\r\n";
if ( $STYPE == "T" )
{
echo " <input type=\"text\" name='LINKMAN";
echo $FIELDNO;
echo "' class=\"SmallInput\" size=\"33\" maxlength=\"25\" value=\"\">\r\n";
}
if ( $STYPE == "MT" )
{
echo " <textarea cols=37 rows=1 name='LINKMAN";
echo $FIELDNO;
echo "' class=\"SmallInput\" wrap=\"yes\"></textarea>\r\n\r\n";
}
if ( $STYPE == "D" )
{
$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 " <select name='LINKMAN";
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" )
{
$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='LINKMAN";
echo $FIELDNO;
echo "'>\r\n";
$I = 0;
for ( ; $I < $TYPENAME_COUNT; ++$I )
{
echo " <input type=\"checkbox\" name='CLINKMAN";
echo $FIELDNO;
echo "' value=\"";
echo $TYPEVALUE_ARRAY[$I];
echo "\" onclick=\"return chk(this,'CLINKMAN";
echo $FIELDNO;
echo "','LINKMAN";
echo $FIELDNO;
echo "','";
echo $TYPENAME_COUNT;
echo "');\">";
echo $TYPENAME_ARRAY[$I];
echo "\r\n";
}
}
if ( $STYPE == "R" )
{
$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='LINKMAN";
echo $FIELDNO;
echo "' value=\"";
echo $TYPEVALUE_ARRAY[$I];
echo "\">";
echo $TYPENAME_ARRAY[$I];
}
}
echo "\r\n </td>\r\n </tr>\r\n";
}
}
echo " \r\n<tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"8\" align=\"left\">\r\n 导出内容：\r\n </td>\r\n</tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" colspan=\"8\" 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=\"PROVIDER_NAME\">供应商单位</option>\r\n <option value=\"PROVIDER_CODE\">供应商编码</option>\r\n <option value=\"PROVIDER_SHORT\">供应商简称</option>\r\n <option value=\"LINKMAN_NAME\">姓名</option>\r\n <option value=\"POST_PRIV\">联系人职位</option>\r\n <option value=\"MAIN_LINKMAN\">主联系人</option>\r\n <option value=\"SEX\">性别</option>\r\n <option value=\"BIRTHDAY\">生日</option>\r\n <option value=\"HOBBY\">爱好</option>\r\n <option value=\"POSTALCODE_HOME\">家庭邮编</option>\r\n <option value=\"ADD_HOME\">家庭住址</option>\r\n <option value=\"TEL_NO_WORK\">工作电话</option>\r\n <option value=\"TEL_NO_HOME\">家庭电话</option>\r\n <option value=\"MOBILE\">手机</option>\r\n <option value=\"EMAIL\">EMAIL</option>\r\n <option value=\"OICQ\">QQ号码</option>\r\n <option value=\"ICQ\">MSN</option>\r\n <option value=\"MEMO\">备注1</option>\r\n <option value=\"MEMO1\">备注2</option>\r\n ";
$query = "select * from FIELDSETTING where TABLENAME='PROVIDER_LINKMAN' 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 " </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=\"8\" 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 type=\"hidden\" name=\"FIELDMSG\">\r\n <input type=\"hidden\" name=\"FIELDMSGNAME\">\r\n </td>\r\n </tr>\r\n</table>\r\n</div>\r\n</body>\r\n</html>\r\n\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -