export.php

通达OA官方提供的30源代码,感觉很实在

<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");

 $EXCEL_OUT="计划名称,计划内容,开始时间,结束时间,计划类别,开放部门,开放人员,负责人,参与人,创建人,创建日期,状态,备注\n";
 $query5 = "SELECT * from WORK_PLAN".str_replace("`","'",$CONDITION_STR1)." order by CREATE_DATE desc";
 $cursor5= exequery($connection,$query5);
 while($ROW=mysql_fetch_array($cursor5))
 {
   $PLAN_ID=$ROW["PLAN_ID"];
   $NAME=$ROW["NAME"];
   $CONTENT=$ROW["CONTENT"];
   $BEGIN_DATE=$ROW["BEGIN_DATE"];
   $END_DATE=$ROW["END_DATE"];
   $TYPE=$ROW["TYPE"];
   $TO_ID=$ROW["TO_ID"];
   $MANAGER=$ROW["MANAGER"];
   $PARTICIPATOR=$ROW["PARTICIPATOR"];
   $CREATOR=$ROW["CREATOR"];
   $CREATE_DATE=$ROW["CREATE_DATE"];
   $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
   $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
   $ATTACHMENT_COMMENT=$ROW["ATTACHMENT_COMMENT"];
   $REMARK=$ROW["REMARK"];
   $SUSPEND_FLAG=$ROW["SUSPEND_FLAG"];
   $TO_PERSON_ID=$ROW["TO_PERSON_ID"];
   
   $CONTENT=str_replace("\n","<br>",$CONTENT);
   $query1 = "SELECT * from PLAN_TYPE where TYPE_ID='$TYPE'";
   $cursor1= exequery($connection,$query1);
   if($ROW1=mysql_fetch_array($cursor1))
      $TYPE_DESC=$ROW1["TYPE_NAME"];
   else
      $TYPE_DESC="";

   if($TO_ID=="ALL_DEPT")
      $TO_NAME="全体部门";
   else
   {
     $TO_NAME="";
     $TOK=strtok($TO_ID,",");
     while($TOK!="")
     {
       if($TO_NAME!="")
          $TO_NAME.="，";
       $query1="select * from DEPARTMENT where DEPT_ID=$TOK";
       $cursor1= exequery($connection,$query1);
       if($ROW=mysql_fetch_array($cursor1))
          $TO_NAME.=$ROW["DEPT_NAME"];

       $TOK=strtok(",");
     }
   }

   $TO_PERSON_NAME="";
   $TOK=strtok($TO_PERSON_ID,",");
   while($TOK!="")
   {
     if($TO_PERSON_NAME!="")
        $TO_PERSON_NAME.="，";
     $query1="select * from USER where USER_ID='$TOK'";
     $cursor1= exequery($connection,$query1);
     if($ROW1=mysql_fetch_array($cursor1))
     {
        $DEPT_ID=$ROW1["DEPT_ID"];
        $DEPT_NAME=dept_long_name($DEPT_ID);
        $TO_PERSON_NAME.=$ROW1["USER_NAME"];
     }

     $TOK=strtok(",");
   }

   $PARTICIPATOR_NAME="";
   $TOK=strtok($PARTICIPATOR,",");
   while($TOK!="")
   {
     if($PARTICIPATOR_NAME!="")
        $PARTICIPATOR_NAME.="，";
     $query1="select * from USER where USER_ID='$TOK'";
     $cursor1= exequery($connection,$query1);
     if($ROW=mysql_fetch_array($cursor1))
     {
        $DEPT_ID=$ROW["DEPT_ID"];
        $DEPT_NAME=dept_long_name($DEPT_ID);
        $PARTICIPATOR_NAME.=$ROW["USER_NAME"];
     }

     $TOK=strtok(",");
   }
   //$PARTICIPATOR_NAME=substr($PARTICIPATOR_NAME,0,-1);

   $MANAGE_NAME="";
   $TOK=strtok($MANAGER,",");
   while($TOK!="")
   {
     if($MANAGE_NAME!="")
        $MANAGE_NAME.="，";
     $query1="select * from USER where USER_ID='$TOK'";
     $cursor1= exequery($connection,$query1);
     if($ROW=mysql_fetch_array($cursor1))
     {
        $DEPT_ID=$ROW["DEPT_ID"];
        $DEPT_NAME=dept_long_name($DEPT_ID);
        $MANAGE_NAME.=$ROW["USER_NAME"];
     }

     $TOK=strtok(",");
   }
   //$MANAGE_NAME=substr($MANAGE_NAME,0,-1);
   
   $query1="select * from USER where USER_ID='$CREATOR'";
   $cursor= exequery($connection,$query1);
   if($ROW=mysql_fetch_array($cursor))
   {
      $DEPT_ID=$ROW["DEPT_ID"];
      $DEPT_NAME=dept_long_name($DEPT_ID);
      $CREATOR_NAME=$ROW["USER_NAME"];
   }
  // $CREATOR_NAME=substr($CREATOR_NAME,0,-1);

   if($SUSPEND_FLAG==1)
   {
      if(compare_date($CUR_DATE,$BEGIN_DATE)<0)
         $STATUS_DESC="未开始";
      else
         $STATUS_DESC="<font color='#00AA00'><b>进行中</b></font>";
      
      if($END_DATE!="0000-00-00")
      {
         if(compare_date($CUR_DATE,$END_DATE)>0)
            $STATUS_DESC="<font color='#FF0000'><b>已结束</b></font>";
      }
      else
         $END_DATE="";
   }
   else
      $STATUS_DESC="<font color='#FF0000'><b>暂停</b></font>";
// $EXCEL_OUT="计划名称,计划内容,开始时间,结束时间,计划类别,开放部门,开放人员,负责人,参与人,创建人,创建日期,状态,备注\n";
    
    $EXCEL_OUT.="$NAME,$CONTENT,$BEGIN_DATE,$END_DATE,$TYPE_DESC,$TO_NAME,$TO_PERSON_NAME,$MANAGE_NAME,$PARTICIPATOR_NAME,$CREATOR_NAME,$CREATE_DATE,$STATUS_DESC,$REMARK\n";
}

 ob_end_clean();
 Header("Cache-control: private");
 Header("Content-type: application/vnd.ms-excel");
 Header("Accept-Ranges: bytes");
 Header("Accept-Length: ".strlen($EXCEL_OUT));
 Header("Content-Length: ".strlen($EXCEL_OUT));
 Header("Content-Disposition: attachment; filename= 工作计划.csv");
 echo $EXCEL_OUT;
?>