?? account_edit.php
字號:
<?
########################################
#OsoonCrm
#客戶列表
########################################
include "include/check.inc.php";
include "include/db.inc.php";
include "include/header.inc.php";
include "include/array.inc.php";
$sql="select * from crm_account where AccountID='$AccountID'";
$res=mysql_query($sql);
$rows=mysql_fetch_row($res);
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="90%">
<tr valign=top>
<td width="201">
<?
include "include/left.inc.php";
?>
</td>
<td>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height=25>
<tr align="right">
<td> <a href="account_add.php">添加客戶</a> | <a href="account_list.php">客戶列表</a>
</td>
</tr>
</table>
<hr>
<form name="NewAccount" method="post" action="account_edit_post.php" id="NewAccount">
<div style="DISPLAY: none"> </div>
<table class="DetailTable" cellspacing="0" cellpadding="5" border="1" bordercolor="#F5F1E9">
<tr class="DTitle">
<td colspan="2" bgcolor="#ede5d2"><span id="Account_New1_lblStatus" style="font-weight:bold;">編輯帳戶</span>
<span id="Account_New1_lblAccountNameCopy" style="font-weight:bold;"></span></td>
</tr>
<tr>
<td class="DTitleHL1" colspan="2"><font face="宋體"></font></td>
</tr>
<tr>
<td class="DTitleHL2" colspan="2"> <a id="Account_New1_lnkBasicInfo" style="CURSOR:hand" class="tabmore" onClick="JScript:ShowBasicInfo();document.images('MoreInfoList').src=src='../Resources/list2.gif';document.images('BasicInfoList').src=src='../Resources/list.gif'" onMouseOver="JScript:this.style.color = 'Blue'" onMouseOut="JScript:this.style.color = '#930000'"></a>
<a id="Account_New1_lnkMore" style="CURSOR:hand" class="tabmore" onMouseOver="JScript:this.style.color = 'Blue'" onMouseOut="JScript:this.style.color = '#930000'" onClick="JScript:ShowMoreClick()"></a>
</td>
</tr>
</table>
<div id="DivBasicInfo">
<table class="DetailTable" cellspacing="1" cellpadding="0">
<tr class="DTitle">
<td>>>基本信息</td>
<td align="right">
<input type="submit" name="Account_New1:btnSave" value="保存" >
<input type="button" value="返回客戶列表" onClick="javascript:document.location='account_list.php'"; name="button">
<input type="hidden" name="AccountID" value="<? echo $AccountID ?>">
</td>
</tr>
<tr>
<td class="HL" colspan="2"> </td>
</tr>
</table>
<table class="DetailTable" cellspacing="0" cellpadding="5" border="1" bordercolor="#F5F1E9">
<colgroup> <col class="LDetail"> <col class="RDetail"> <col class="LDetail">
<col class="RDetail"> </colgroup>
<tr>
<td height="14">帳戶擁有者</td>
<td height="14"> <? echo $array_crm_id2user[$rows[1]] ?></td>
<td class="LaltDetail" height="14">類型</td>
<td height="14">
<select name="AccountType" id="Account_New1_ddlAccountType" class="nmTxt">
<?
$sql="select * from crm_account_type";
$res=mysql_query($sql);
while($row=mysql_fetch_array($res))
{
?>
<option value="<? echo $row[TypeID] ?>" <? if ($row[TypeID]==$rows[3]) echo "selected"; ?> ><? echo $row[TypeName] ?></option>
<?
}
?>
</select>
</td>
</tr>
<tr>
<td class="LaltDetail">帳戶名稱</td>
<td>
<input name="AccountName" type="text" value="<? echo $rows[2] ?>">
</td>
<td>行業</td>
<td>
<select name="AccountIndustry" id="Account_New1_ddlIndustry" class="nmTxt">
<?
$sql="select * from crm_account_industry";
$res=mysql_query($sql);
while($row=mysql_fetch_array($res))
{
?>
<option value="<? echo $row[IndustryID] ?>" <? if ($row[IndustryID]==$rows[5]) echo "selected"; ?>><? echo $row[IndustryName] ?></option>
<?
}
?>
</select>
</td>
</tr>
<tr>
<td>編號</td>
<td>
<input name="AccountSN" type="text" id="Account_New1_txbAccountSN" class="nmTxt" value="<? echo $rows[4] ?>" />
</td>
<td>來源</td>
<td>
<select id="Account_New1_ddlSource" class="nmTxt" name="AccountSource">
<?
$sql="select * from crm_source";
$res=mysql_query($sql);
while($row=mysql_fetch_array($res))
{
?>
<option value="<? echo $row[SourceID] ?>" <? if ($row[SourceID]==$rows[6]) echo "selected"; ?>><? echo $row[SourceName] ?></option>
<?
}
?>
</select>
</td>
</tr>
<tr>
<td class="LaltDetail">地域 </td>
<td>
<input name="Area" type="text" id="Account_New1_txbAccountGeo" class="roTxt" value="<? echo $rows[7] ?>" />
</td>
<td>年收入</td>
<td>
<select name="YearRevenue" id="Account_New1_ddlRevenue" class="nmTxt">
<?
$sql="select * from crm_account_year_revenue ";
$res=mysql_query($sql);
while($row=mysql_fetch_array($res))
{
?>
<option value="<? echo $row[RevenueID] ?>" <? if ($row[RevenueID]==$rows[8]) echo "selected"; ?>><? echo $row[RevenueName] ?></option>
<?
}
?>
</select>
</td>
</tr>
<tr>
<td>電話</td>
<td>
<input name="Tel" type="text" id="Account_New1_txbTelephone" class="nmTxt" value="<? echo $rows[9] ?>">
</td>
<td>人員規模</td>
<td>
<select name="HumanScale" id="Account_New1_ddlScale" class="nmTxt">
<?
$sql="select * from crm_account_human_scale ";
$res=mysql_query($sql);
while($row=mysql_fetch_array($res))
{
?>
<option value="<? echo $row[ScaleID] ?>" <? if ($row[ScaleID]==$rows[10]) echo "selected"; ?>><? echo $row[ScaleName] ?></option>
<?
}
?>
</select>
</td>
</tr>
<tr>
<td>傳真</td>
<td>
<input name="Fax" type="text" id="Account_New1_txbFax" class="nmTxt" value="<? echo $rows[11] ?>">
</td>
<td>關系等級</td>
<td>
<select name="Relationship" id="Account_New1_ddlRelationship" class="nmTxt">
<?
$sql="select * from crm_account_relationship ";
$res=mysql_query($sql);
while($row=mysql_fetch_array($res))
{
?>
<option value="<? echo $row[RelationshipID] ?>" <? if ($row[RelationshipID]==$rows[12]) echo "selected"; ?>><? echo $row[RelationshipName] ?></option>
<?
}
?>
</select>
</td>
</tr>
<tr>
<td>網址</td>
<td>
<input name="WebSite" type="text" id="Account_New1_txbWebSite" class="nmTxt" value="<? echo $rows[13] ?>" />
</td>
<td>主聯系人</td>
<td>
<input name="MainContact" type="text" id="Account_New1_txbTax" class="nmTxt" value="<? echo $rows[14] ?>" />
</td>
</tr>
<tr>
<td>信用度</td>
<td>
<input name="Credit" type="text" value="<? echo $rows[15] ?>" id="Account_New1_txbCredit" class="nmTxt" />
</td>
<td>稅號</td>
<td>
<input name="TaxSN" type="text" id="Account_New1_txbTax" class="nmTxt" value="<? echo $rows[16] ?>" />
</td>
</tr>
</table>
<table class="DetailTable" cellspacing="1" cellpadding="0">
<tr>
<td class="DTitle" colspan="4">>>企業信息<a name="PostBackByCountry"></a></td>
</tr>
<tr>
<td class="HL" colspan="4"></td>
</tr>
</table>
<table id="Account_New1_ucCustomizeFields_tblCustomize" class="DetailTable" cellspacing="0" cellpadding="5" border="1" bordercolor="#F5F1E9">
<tr>
<td title="(貨幣)" class="LDetail">固定資產（人民幣萬元）</td>
<td class="RDetail">
<input name="FixedAssets" type="text" value="<? echo $rows[17] ?>" class="nmTxt" />
</td>
<td title="(貨幣)" class="LDetail">銷售額（人民幣萬元）</td>
<td class="RDetail">
<input name="Sale" type="text" value="<? echo $rows[18] ?>" class="nmTxt" />
</td>
</tr>
<tr>
<td title="(整數)" class="LDetail">銷售人員人數</td>
<td class="RDetail">
<input name="SaleManNumber" type="text" value="<? echo $rows[19] ?>" class="nmTxt" />
</td>
<td title="(整數)" class="LDetail">電腦數量</td>
<td class="RDetail">
<input name="ComputerNumber" type="text" value="<? echo $rows[20] ?>" class="nmTxt" />
</td>
</tr>
<tr>
<td title="(大文本)" class="LDetail">企業性質</td>
<td class="RDetail" colspan="3">
<select name="CorpProperty">
<?
$sql="select * from crm_corp_kind ";
$res=mysql_query($sql);
while($row=mysql_fetch_array($res))
{
?>
<option value="<? echo $row[CorpKindID] ?>" <? if ($row[CorpKindID]==$rows[21]) echo "selected"; ?>>
<? echo $row[CorpKindName] ?>
</option>
<?
}
?>
</select>
</td>
</tr>
<tr>
<td title="(大文本)" class="LDetail">成立時間 </td>
<td class="RDetail" colspan="3">
<input name="FoundTime" type="text" value="<? echo $rows[22] ?>">
</td>
</tr>
</table>
<table class="DetailTable" cellspacing="1" cellpadding="0">
<tr>
<td class="DTitle" colspan="4">>>地址信息<a name="PostBackByCountry"></a></td>
</tr>
<tr>
<td class="HL" colspan="4"></td>
</tr>
</table>
<table class="DetailTable" cellspacing="0" cellpadding="5" border="1" bordercolor="#F5F1E9">
<colgroup> <col class="LDetail"> <col class="RDetail"> <col class="LDetail">
<col class="RDetail"> </colgroup>
<tr>
<td>國家</td>
<td>
<select name="Country">
<option value="1" <? if ($rows[24]==1) echo "selected" ?>>中國</option>
<option value="2" <? if ($rows[24]==2) echo "selected" ?>>美國</option>
<option value="3" <? if ($rows[24]==3) echo "selected" ?>>日本</option>
<option value="4" <? if ($rows[24]==4) echo "selected" ?>>韓國</option>
<option value="5" <? if ($rows[24]==5) echo "selected" ?>>加拿大</option>
</select>
</td>
<td>省份</td>
<td>
<input name="Province" type="text" id="Account_New1_txbCity" class="nmTxt" value="<? echo $rows[25] ?>" />
</td>
</tr>
<tr>
<td>城市</td>
<td>
<input name="City" type="text" id="Account_New1_txbCity" class="nmTxt" value="<? echo $rows[26] ?>" />
</td>
<td>郵編</td>
<td>
<input name="Zip" type="text" id="Account_New1_txbPostCode" class="nmTxt" value="<? echo $rows[28] ?>" />
</td>
</tr>
<tr>
<td>地址</td>
<td class="RLDetail" colspan="3">
<input name="Address" type="text" id="Account_New1_txbAddress" class="nmTxt" value="<? echo $rows[27] ?>" />
</td>
</tr>
<tr>
<td>備注</td>
<td class="RLDetail" colspan="3">
<textarea name="Msg" id="Account_New1_txbMark" class="nmTxt"><? echo $row[29] ?></textarea>
</td>
</tr>
</table>
</div>
<div id="DivMoreInfo"> <iframe id="Frame_Tab" frameborder="0" height="0" scrolling="no" class="MoreFrame"></iframe>
</div>
</form>
</td>
</tr>
</table>
<?
include "include/footer.inc.php";
?>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -