⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 index.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％ 源码
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>新建市场活动</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function delete_attach(ATTACHMENT_ID,ATTACHMENT_NAME)
{
  msg="如果您的市场活动还没保存，删除附件时将丢失新修改的数据，确定要删除附件 '"+ ATTACHMENT_NAME +"' 吗?";
  if(window.confirm(msg))
  {
    URL="delete_attach.php?ACTIVITY_ID=<?=$ACTIVITY_ID?>&ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME+"&ATTACHMENT_ID_OLD="+document.form1.ATTACHMENT_ID_OLD.value+"&ATTACHMENT_NAME_OLD="+document.form1.ATTACHMENT_NAME_OLD.value;
    window.location=URL;
  }
}
function upload_attach()
{
  if (document.form1.ATTACHMENT.value=="")
      return;
  if(CheckForm())
  {
   document.form1.OP.value="1";
   document.form1.submit();
  }
}
function CheckForm()
{
  if(document.form1.ACTIVITY_NAME.value=="")
  { 
  	 alert("市场活动名称不能为空！");
     return (false);
  }
  if(document.form1.BEGIN_DATE.value=="")
  { 
  	 alert("生效日期不能为空！");
     return (false);
  }
  if(document.form1.END_DATE.value=="")
  {  
  	 alert("终止日期不能为空！");
     return (false);
  }
  if (document.form1.ATTACHMENT.value!="")
  {
     var file_temp=document.form1.ATTACHMENT.value;
     var file_name;
     var Pos;
     Pos=file_temp.lastIndexOf("\\");
     file_name=file_temp.substring(Pos+1,file_temp.length);
     document.form1.ATTACHMENT_NAME.value=file_name;
  }
  return (true);
}
function LoadWindow()
{
  URL="/module/user_select_single";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+200;
  window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:350px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function td_calendar(fieldname)
{
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
  window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function chk(input,KC,KT,count)
{
  var lstr="";
  if(count==1)
  {
   if(document.all(KC).checked)
   {
  	document.all(KT).value=document.all(KC).value;
   }
   else
   {
  	 document.all(KT).value="";
   }
   }
   else
   {
  	 for(i=0;i<document.all(KC).length;i++)
     {
        el=document.all(KC).item(i);
        if(el.checked)
        {
        	 val=el.value;
           lstr+=val+",";
        }
     }
  	document.all(KT).value=lstr;
    }
}
function LoadWindow1(kname,codeid)
{
  URL="codedefine.php?kname="+kname+"&codeid="+codeid;
  myleft=(screen.availWidth-650)/2;
  window.open(URL,"formul_edit","height=300,width=550,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function sel_attach(div_id,dir_field,name_field,disk_id)
{
   var URL="/module/sel_file?EXT_FILTER=&MULTI_SELECT=1&DIV_ID=" + div_id + "&DIR_FIELD=" + dir_field + "&NAME_FIELD=" + name_field + "&TYPE_FIELD=" + disk_id;
   window.open(URL,null,"height=300,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=200,left=300,resizable=yes");
}
</script>
</head>
<?
if($ACTIVITY_ID!="")
{
   $query="select * from ACTIVITY where ACTIVITY_ID='$ACTIVITY_ID'";
   $cursor= exequery($connection,$query);
   if($ROW=mysql_fetch_array($cursor))
    {
      $ACTIVITY_ID=$ROW["ACTIVITY_ID"];
      $MANAGER=$ROW["MANAGER"];
      $MANAGER_DEPT=$ROW["MANAGER_DEPT"];
      $PARTICIPATOR=$ROW["PARTICIPATOR"];
      $ACTIVITY_NAME1=$ROW["ACTIVITY_NAME"];
      $ACTIVITY_TYPE1=$ROW["ACTIVITY_TYPE"];
      $BUDGET=$ROW["BUDGET"];
      $CHARGE=$ROW["CHARGE"];
      $CHARGE_USE=$ROW["CHARGE_USE"];
      $ACTIVITY_DESC=$ROW["ACTIVITY_DESC"];
      $ACTIVITY_STATUS1=$ROW["ACTIVITY_STATUS"];
      $ACTIVITY_FINISH=$ROW["ACTIVITY_FINISH"];
      $ACTIVITY_RESULT=$ROW["ACTIVITY_RESULT"];
      $BEGIN_DATE=$ROW["BEGIN_DATE"];
      $END_DATE=$ROW["END_DATE"];
      $ACTUAL_BEGIN_DATE=$ROW["ACTUAL_BEGIN_DATE"];
      $ACTUAL_END_DATE=$ROW["ACTUAL_END_DATE"];
	  if (!isset($ATTACHMENT_ID))
	  {
        $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
        $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
	  }
      if($END_DATE=="0000-00-00")
      $END_DATE="";
      if($BEGIN_DATE=="0000-00-00")
      $BEGIN_DATE="";
      if($ACTUAL_END_DATE=="0000-00-00")
      $ACTUAL_END_DATE="";
      if($ACTUAL_BEGIN_DATE=="0000-00-00")
      $ACTUAL_BEGIN_DATE="";
    }
}
?>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_new.gif" align="absmiddle"><span class="big3"> <? if($ACTIVITY_ID=="") echo '新建'; else echo '编辑'; ?>市场活动</span>
    </td>
  </tr>
</table>
<br>
<table border="0" cellspacing="1" width="85%"  class="small"  bgcolor="#000000" cellpadding="3" align="center" >
  <form action="add.php" enctype="multipart/form-data"  method="post" name="form1" onsubmit="return CheckForm();">
   <tr>
    <td nowrap  class="TableHeader" colspan="4" align="left">
     基本信息：
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">活动名称： </td>
    <td nowrap class="TableData">
        <input type="text" name="ACTIVITY_NAME" class="BigInput" size="20" maxlength="100" value="<?=$ACTIVITY_NAME1?>">
    </td>
   <td nowrap class="TableData">活动类型： </td>
    <td nowrap class="TableData">
        <select name="ACTIVITY_TYPE" class="BigSelect">
<?
        GETALLDATE("ACTIVITY_TYPE",$ACTIVITY_TYPE1);
?>
        </select>
   </td>
   </tr>
  <tr>
    <td nowrap class="TableData">生效日期： </td>
    <td nowrap class="TableData">
        <input type="text" name="BEGIN_DATE" size="10" maxlength="10" class="BigStatic" readonly value="<?=$BEGIN_DATE?>">
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.BEGIN_DATE');">       
    </td>
     <td nowrap class="TableData">终止日期： </td>
    <td nowrap class="TableData">
        <input type="text" name="END_DATE" size="10" maxlength="10" class="BigStatic" readonly  value="<?=$END_DATE?>">
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.END_DATE');">        
    </td>
  </tr>
  <tr>
    <td nowrap class="TableData">活动预算： </td>
    <td nowrap class="TableData">
        <input type="text" name="BUDGET" class="BigInput" size="15" maxlength="100" value="<?=$BUDGET?>">
    </td>
     <td nowrap class="TableData">实际费用： </td>
    <td nowrap class="TableData">
        <input type="text" name="CHARGE" class="BigInput" size="15" maxlength="100" value="<?=$CHARGE?>">
    </td>
   </tr>
   <tr>
   	<td nowrap class="TableData">负责人： </td>
    <td class="TableData">
        <input type="hidden" name="TO_ID" value="<?=$MANAGER?>">
<?
      $query2="select USER_NAME from USER where USER_ID='$MANAGER'";
      $cursor2 = exequery($connection, $query2);
       if($ROW=mysql_fetch_array($cursor2))
       $USER_NAME=$ROW["USER_NAME"];
?>
        <input type="text" name="TO_NAME" class="BigStatic" readonly size="15" maxlength="100"  value="<?=$USER_NAME?>">
        <input type="button" value="选择" class="SmallButton" onClick="LoadWindow()" title="指定负责人" name="button">
    </td>
    <td nowrap class="TableData">负责部门： </td>
    <td nowrap class="TableData">
        <select name="MANAGER_DEPT" class="BigSelect">
<?
      echo my_dept_tree(0,$MANAGER_DEPT,1);
?>
        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">参与人： </td>
    <td nowrap class="TableData" colspan="3">
        <input type="text" name="PARTICIPATOR" class="BigInput" size="50" maxlength="100" value="<?=$PARTICIPATOR?>">
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">市场活动描述： </td>
    <td nowrap class="TableData" colspan="3">
    	 <textarea cols=57 rows=3 name="ACTIVITY_DESC" class="BigInput" wrap="yes"><?=$ACTIVITY_DESC?></textarea>
    </td>
   </tr>
    <tr>
    <td nowrap class="TableData">经费使用情况： </td>
    <td nowrap class="TableData" colspan="3">
    	 <textarea cols=57 rows=6 name="CHARGE_USE" class="BigInput" wrap="yes"><?=$CHARGE_USE?></textarea>
    </td>
   </tr>
    <tr>
    <td nowrap class="TableData">市场活动附件： </td>
    <td nowrap class="TableData" colspan="3">
		<table cellpadding="0" cellspacing="0" border="0"  width="100%" id=tmp>
		<tr>
		<td class="TableData"></td>
		</tr>
		</table>
<?      
      if($ATTACHMENT_ID=="")
         echo "无";
      else
         echo attach_link($ATTACHMENT_ID,$ATTACHMENT_NAME,1,1,1,1,1,0,1,0,"");
?>
    </td>
   </tr>
    <tr height="25">
      <td nowrap class="TableData">附件选择：</td>
      <td class="TableData" colspan="3">
         <div id="SelFileDiv" class="TextColor2"></div>
         <a href="javascript:sel_attach('SelFileDiv','ATTACH_DIR','ATTACH_NAME','DISK_ID');">从文件柜和网络硬盘选择附件</a>
         <input type="hidden" value="" name="ATTACH_NAME">
         <input type="hidden" value="" name="ATTACH_DIR">
         <input type="hidden" value="" name="DISK_ID">
      </td>
    </tr>
  <tr>
      <td nowrap class="TableData">附件上传：</td>
      <td class="TableData" colspan="3">
        <input type="file" name="ATTACHMENT" size="30" class="BigInput" title="选择附件文件">
        <input type="button" value="上传附件" class="BigButton" onclick="upload_attach();" title="上传附件">
        <input type="hidden" name="ATTACHMENT_ID_OLD" value="<?=$ATTACHMENT_ID?>">
        <input type="hidden" name="ATTACHMENT_NAME_OLD" value="<?=$ATTACHMENT_NAME?>">
      </td>
    </tr>
<tr>
 <td nowrap  class="TableHeader" colspan="4" align="left">
     活动进度：
 </td>
</tr>
  <tr>
    <td nowrap class="TableData">实际开始日期： </td>
    <td nowrap class="TableData">
        <input type="text" name="ACTUAL_BEGIN_DATE" size="10" maxlength="10" class="BigStatic" readonly value="<?=$ACTUAL_BEGIN_DATE?>">
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.ACTUAL_BEGIN_DATE');">       
    </td>
     <td nowrap class="TableData">实际终止日期： </td>
    <td nowrap class="TableData">
        <input type="text" name="ACTUAL_END_DATE" size="10" maxlength="10" class="BigStatic" readonly  value="<?=$ACTUAL_END_DATE?>">
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.ACTUAL_END_DATE');">        
    </td>
  </tr>
   <tr>
   	<td nowrap class="TableData">进行状态： </td>
    <td class="TableData">
        <select name="ACTIVITY_STATUS" class="BigSelect">
<?
        GETALLDATE("ACTIVITY_STATUS",$ACTIVITY_STATUS1);
?>
        </select>
    </td>
    <td nowrap class="TableData">完成率： </td>
    <td nowrap class="TableData">
        <input type="text" name="ACTIVITY_FINISH" class="BigInput" size="15" maxlength="100" value="<?=$ACTIVITY_FINISH?>">
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">活动结果： </td>
    <td nowrap class="TableData" colspan="3">
    	 <textarea cols=57 rows=3 name="ACTIVITY_RESULT" class="BigInput" wrap="yes"><?=$ACTIVITY_RESULT?></textarea>
    </td>
   </tr>
<tr>
    <td nowrap  class="TableControl" colspan="4" align="center">
        <input type="hidden" value="&ACTIVITY_NAME=<?=$ACTIVITY_NAME?>&ACTIVITY_TYPE=<?=$ACTIVITY_TYPE?>&TO_ID=<?=$TO_ID?>&TO_NAME=<?=$TO_NAME?>&ACTIVITY_STATUS=<?=$ACTIVITY_STATUS?>&DATE_TYPE=<?=$DATE_TYPE?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>" name="QUERY_LIST">
        <input type="hidden" name="OP1" value="<?=$OP1?>">
        <input type="hidden" name="OP" value="">
        <input type="hidden" name="ACTIVITY_ID" value="<?=$ACTIVITY_ID?>">
        <input type="hidden" name="ATTACHMENT_NAME">
        <input type="submit" value="确定" class="BigButton" title="新建市场活动" name="button">&nbsp;
        <input type="reset" value="重置" class="BigButton">
    </td>
   </tr>
  </form>
</table>

</body>
</html>
<?
 function GETALLDATE($CODE,$GETVALUE)
{
  global $connection;
  $query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
  $connection=OpenConnection();
  $cursor= exequery($connection,$query);
  while($ROW=mysql_fetch_array($cursor))
  {
   $CODE_NO=$ROW["CODE_NO"];
   $CODE_NAME=$ROW["CODE_NAME"];
   if ($CODE_NO==$GETVALUE)
   {echo "<option value=".$CODE_NO."  selected>".$CODE_NAME."</option>";}
   else
   {echo "<option value=".$CODE_NO." >".$CODE_NAME."</option>";}
  }

}
?>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -