activity_add.php

CRM 不仅仅是一个管理名词和管理概念

<?
	########################################
	#OsoonCrm
	#新增行动
	########################################
		
	include "include/db.inc.php";
	include "include/check.inc.php";
	include "include/array.inc.php";
	
	if($Submit)
	{
		//check submit
		if(!$ActivityName)
		{
			echo "请填写行动主题...";
			echo "<META HTTP-EQUIV=\"Refresh\"  CONTENT=\"3; url=activity_add.php\">";
			exit;
		}
		
		$sql="insert into $tbl_crm_activity (ActivityName,ActivityLocation,BeginTime,EndTime,ActivityMode,ActivityExecuteID,YuJianSale,PeiTongRen,AccountID,ProjectID,Result,Memo)values('$ActivityName','$ActivityLocation','$BeginTime','$EndTime','$ActivityMode','$actid','$YuJianSale','$PeiTongRen','$AccountID','$ProjectID','$Result','$Memo')";
		mysql_query($sql);
		echo "成功创建新行动,请稍候...";
		echo "<META HTTP-EQUIV=\"Refresh\"  CONTENT=\"3; url=activity_list.php\">";
		exit;
	}
	include "include/header.inc.php";
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="90%">
  <tr valign=top> 
    <td width="201">
<?
	include "include/left.inc.php";
?>
    </td>
    <td>
<?
	$sql="select * from $tbl_crm_activity where ActivityID='$actid'";
	$res=mysql_query($sql);
	$row=mysql_fetch_array($res);

	$sql_account="select * from $tbl_crm_account where AccountOwnerID='$G_uid'";
	$res_account=mysql_query($sql_account);

	$sql_project="select * from $tbl_crm_project where CreateID='$G_uid'";
	$res_project=mysql_query($sql_project);
?>
		<br>
      <form method="post" action="activity_add.php">
        <table width="95%" border="0" cellspacing="0" cellpadding="5" align="center">
          <tr> 
            <td width=50%><b>创建新行动</b><font color="red"> * </font>为必填项</td>
            <td width=50% align=right>
              <input type="hidden" name="actid" value="<? echo $G_uid?>">
              <input type="submit" name="Submit" value="创建新行动">
              <input type="button" name="button" value="行动列表" onClick="javascript:document.location='activity_list.php';">
            </td>
		  </tr>
        </table>
        <hr width=95% align=center>
        <table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#ede5d2" bordercolor="#FFFFFF">
          <tr> 
            <td colspan="2"> <b>基本信息</b></td>
          </tr>
        </table>
        <table width="95%" border="1" cellspacing="0" cellpadding="5" align="center" bgcolor="#F5F1E9" bordercolor="#FFFFFF">
          <tr> 
            <td width="25%">行动主题<font color="red"> * </font></td>
            <td width="25%"> 
              <input type="text" name="ActivityName">
            </td>
            <td width="25%">行动地点</td>
            <td width="25%"> 
              <input type="text" name="ActivityLocation" value="<? echo $row[ActivityLocation] ?>">
            </td>
          </tr>
          <tr> 
            <td width="25%">执行者</td>
            <td width="25%"> 
              <? echo $array_crm_id2user[$G_uid]?>
            </td>
            <td width="25%">开始时间</td>
            <td width="25%"> 
              <input type="text" name="BeginTime" value="<? echo $row[BeginTime]?>">
            </td>
          </tr>
          <tr> 
            <td width="25%">完成时间</td>
            <td width="25%"> 
              <input type="text" name="EndTime" value="<? echo $row[EndTime]?>">
            </td>
            <td width="25%">行动方式</td>
            <td width="25%"> 
              <input type="text" name="ActivityMode" value="<? echo $row[ActivityMode]?>">
            </td>
          </tr>
          <tr> 
            <td width="25%">预计费用</td>
            <td width="25%"> 
              <input type="text" name="YuJianSale" value="<? echo $row[YuJianSale]?>">
            </td>
            <td width="25%">陪同者</td>
            <td width="25%"> 
              <input type="text" name="PeiTongRen" value="<? echo $row[PeiTongRen]?>">
            </td>
          </tr>
          <tr> 
            <td width="25%">所属客户</td>
            <td> 
              <select name="AccountID">
<?
	while ($row_account=@mysql_fetch_array($res_account))
	{
		$key = $row_account[AccountID];
		$val = $row_account[AccountName];
?>
		<option value="<? echo $key?>"<? if($row[AccountID]==$key){echo "selected";} ?>><? echo $val ?></option>
<?
	}
?> 
              </select>
            </td>
            <td>所属项目</td>
            <td> 
              <select name="ProjectID">
<?
	while ($row_project=@mysql_fetch_array($res_project)) {
		$key = $row_project[ProjectID];
		$val = $row_project[ProjectName];
?>
		<option value="<? echo $key ?>"<? if($row[ProjectID]==$key){echo "selected";} ?>><? echo $val ?></option>
<?
	}
?> 
              </select>
            </td>
          </tr>
          <tr> 
            <td width="25%">行动结果</td>
            <td width="25%"> 
              <input type="text" name="Result" value="<? echo $row[Result] ?>">
            </td>
            <td width="25%">&nbsp;</td>
            <td width="25%">&nbsp; </td>
          </tr>
          <tr> 
            <td width="25%">备注</td>
            <td colspan="3"> 
              <textarea name="Memo" cols="50" rows="6"><? echo $row[Memo] ?></textarea>
            </td>
          </tr>
        </table>
        <br>
        <br>
        <table width="95%" border="0" cellspacing="0" cellpadding="5" align="center">
          <tr>
            <td>&nbsp; </td>
          </tr>
        </table>
      </form>
      <p>&nbsp;</p></td>
  </tr> 
</table>
<?
	include "include/footer.inc.php";
?>