word_report.php

通达OA2007SE源代码 非常好的

<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $STYLE_ARRAY = explode (',', $FIELDMSGNAME);
  $ARRAY_COUNT = sizeof ($STYLE_ARRAY);
  $COUNT = 0;
  if (($STYLE_ARRAY[($ARRAY_COUNT - 1)] == ''))
  {
    --$ARRAY_COUNT;
  }
  for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
  {
    if (($I == 0))
    {
      ($WORD_OUT .= '<table border=1 cellspacing=0 cellpadding=0 style=\'border-collapse:collapse;border:none;mso-border-alt:solid\'><tr bgcolor=#EEEEEE>');
    }
    ($WORD_OUT .= (((''.'<td nowrap align="center" style=\'border:solid windowtext .5pt;padding:0.1cm 5.4pt 0.1cm 5.4pt\'><b>').$STYLE_ARRAY[$I]).'</b></td>'));
  }
  ($WORD_OUT .= '</tr>');
  if ((($SCOPE == '1') OR ($SCOPE == '')))
  {
    ($WHERE_STR .= (((''.' where a.SELLER=\'').$LOGIN_USER_ID).'\' '));
  }
  if (($SCOPE == '2'))
  {
    ($WHERE_STR .= (((((''.' where ((find_in_set( \'').$LOGIN_USER_ID).'\',a.SHAREUSER) and a.SHARE=\'1\') or (a.SHAREUSER=\'\' and  a.SELLER!=\'').$LOGIN_USER_ID).'\' and a.SHARE=\'1\'))'));
  }
  if (($SCOPE == '3'))
  {
    $query1 = 'select DEPT_ID from DEPARTMENT';
    $cursor1 = exequery ($connection, $query1);
    while ($ROW = mysql_fetch_array ($cursor1))
    {
      $DEPT_ID = $ROW['DEPT_ID'];
      if ((is_dept_priv ($DEPT_ID) == 1))
      {
        $TO_ID = (($TO_ID.$DEPT_ID).',');
        continue;
      }
    }
    $TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
    ($WHERE_STR .= (((''.' where h.DEPT_ID in (').$TO_ID).')'));
  }
  if (($CUSTOMER_NAME != ''))
  {
    ($WHERE_STR .= ((' and a.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
  }
  if (($CUSTOMER_CODE != ''))
  {
    ($WHERE_STR .= ((' and a.CUSTOMER_CODE like \'%'.$CUSTOMER_CODE).'%\''));
  }
  if (($CUSTOMER_SHORT != ''))
  {
    ($WHERE_STR .= ((' and a.CUSTOMER_SHORT like \'%'.$CUSTOMER_SHORT).'%\''));
  }
  if (($CUSTOMER_AREA != ''))
  {
    ($WHERE_STR .= (((''.' and a.CUSTOMER_AREA=\'').$CUSTOMER_AREA).'\''));
  }
  if (($CUSTOMER_ADD != ''))
  {
    ($WHERE_STR .= ((' and a.CUSTOMER_ADD like \'%'.$CUSTOMER_ADD).'%\''));
  }
  if (($SOURCE != ''))
  {
    ($WHERE_STR .= (((''.' and a.SOURCE =\'').$SOURCE).'\''));
  }
  if (($KIND != ''))
  {
    ($WHERE_STR .= (((''.' and a.KIND =\'').$KIND).'\''));
  }
  if (($SELLMODE != ''))
  {
    ($WHERE_STR .= (((''.' and a.SELLMODE =\'').$SELLMODE).'\''));
  }
  if (($ATTRIBUTE != ''))
  {
    ($WHERE_STR .= (((''.' and a.ATTRIBUTE =\'').$ATTRIBUTE).'\''));
  }
  if (($ENTERTYPE != ''))
  {
    ($WHERE_STR .= (((''.' and a.ENTERTYPE =\'').$ENTERTYPE).'\''));
  }
  if (($ENTERMEMO != ''))
  {
    ($WHERE_STR .= ((' and a.ENTERMEMO like \'%'.$ENTERMEMO).'%\''));
  }
  $query = 'SELECT FIELDNO from FIELDSETTING where TABLENAME=\'CUSTOMER\'';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $FIELDNO = ('CUSTOMER'.$ROW['FIELDNO']);
    if (($$FIELDNO != ''))
    {
      $CUSTOMERID_STR = '';
      $urlstr = (((($urlstr.'&').$FIELDNO).'=').$$FIELDNO);
      $WHERE_STR1 = ((((' where TABLENAME=\'CUSTOMER\' and (FIELDNO=\''.$ROW['FIELDNO']).'\' and ITEM_DATE like \'%').$$FIELDNO).'%\')');
      $query1 = ('SELECT IDENTY_ID FROM `FIELD_DATE`'.$WHERE_STR1);
      $cursor1 = exequery ($connection, $query1);
      while ($ROW1 = mysql_fetch_array ($cursor1))
      {
        $CUSTOMERID_STR = (($CUSTOMERID_STR.$ROW1['IDENTY_ID']).',');
      }
      $CUSTOMERID_STR = (('\''.str_replace (',', '\',\'', substr ($CUSTOMERID_STR, 0, -1))).'\'');
      ($WHERE_STR .= (((''.' and a.CUSTOMER_ID in (').$CUSTOMERID_STR).')'));
      continue;
    }
  }
  $query = ('SELECT a.CUSTOMER_ID,a.CUSTOMER_NAME as CUSTOMER_NAME,a.CUSTOMER_SHORT as CUSTOMER_SHORT,a.CUSTOMER_CODE as CUSTOMER_CODE, a.TEL_NO as TEL_NO,
        a.FAX_NO,a.CUSTOMER_WWW,a.EMAIL,d.CODE_NAME as CUSTOMER_AREA,a.CUSTOMER_ADD,a.POSTALCODE,a.MEMO,h.USER_NAME AS SELLER,
        e.CODE_NAME AS `SOURCE`,c.CODE_NAME AS KIND,b.CODE_NAME AS \'SELLMODE\',f.CODE_NAME AS `ATTRIBUTE`,g.CODE_NAME AS `ENTERTYPE`,
        a.ENTERMEMO,a.MEMO1,a.USERDEF1,a.USERDEF2,a.USERDEF3,a.USERDEF4,a.USERDEF5
        from CUSTOMER a LEFT OUTER JOIN SYS_CODE b
        ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = \'SELL_MODE\'
        LEFT OUTER JOIN SYS_CODE c
        ON a.KIND = c.CODE_NO AND c.PARENT_NO = \'CRM_KIND\'
        LEFT OUTER JOIN SYS_CODE d
        ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = \'AREA\'
        LEFT OUTER JOIN SYS_CODE e
        ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = \'CRM_SOURCE\'
        LEFT OUTER JOIN SYS_CODE f
        ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = \'CRM_ATTRIBUTE\'
        LEFT OUTER JOIN SYS_CODE g
        ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = \'CRM_TYPE\'
        LEFT OUTER JOIN USER h ON a.SELLER = h.USER_ID
        '.$WHERE_STR);
  $cursor = exequery ($connection, $query);
  $USER_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ($WORD_OUT .= '<tr>');
    $STYLE_ARRAY = explode (',', $FIELDMSG);
    $ARRAY_COUNT = sizeof ($STYLE_ARRAY);
    $IDENTY_ID = $ROW['CUSTOMER_ID'];
    $COUNT = 0;
    if (($STYLE_ARRAY[($ARRAY_COUNT - 1)] == ''))
    {
      --$ARRAY_COUNT;
    }
    for ($I = 0; ($I < $ARRAY_COUNT); ++$I)
    {
      $query = (((''.'select * from FIELDSETTING where TABLENAME=\'CUSTOMER\' and FIELDNO=\'').$STYLE_ARRAY[$I]).'\' ORDER BY ORDERNO ASC  ');
      $cursor1 = exequery ($connection, $query);
      if ($ROW1 = mysql_fetch_array ($cursor1))
      {
        $MESSAGE = '';
        $FIELDNAME = $ROW1['FIELDNAME'];
        $ORDERNO = $ROW1['ORDERNO'];
        $STYPE = $ROW1['STYPE'];
        $TYPENAME = $ROW1['TYPENAME'];
        $TYPEVALUE = $ROW1['TYPEVALUE'];
        $TYPECODE = $ROW1['TYPECODE'];
        $ISQUERY = $ROW1['ISQUERY'];
        $ISGROUY = $ROW1['ISGROUY'];
        $FIELDNAME = $ROW1['FIELDNAME'];
        $FIELDNO = $ROW1['FIELDNO'];
        $FIELDNO1 = ($FIELDNO.'1');
        $query2 = (((((''.'select ITEM_DATE from FIELD_DATE where TABLENAME=\'CUSTOMER\' and FIELDNO=\'').$STYLE_ARRAY[$I]).'\' and IDENTY_ID=\'').$IDENTY_ID).'\'');
        $cursor2 = exequery ($connection, $query2);
        if ($ROW2 = mysql_fetch_array ($cursor2))
        {
          $MESSAGE = $ROW2['ITEM_DATE'];
        }
        if (($STYPE == 'D'))
        {
          if (($TYPECODE != ''))
          {
            $query2 = (((''.'select * from SYS_CODE where PARENT_NO=\'').$TYPECODE).'\' order by CODE_ORDER');
            $cursor2 = exequery ($connection, $query2);
            while ($ROW = mysql_fetch_array ($cursor2))
            {
              $CODE_NO = $ROW['CODE_NO'];
              $CODE_NAME = $ROW['CODE_NAME'];
              $TYPEVALUE = (($TYPEVALUE.$CODE_NO).',');
              $TYPENAME = (($TYPENAME.$CODE_NAME).',');
            }
          }
          $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;
          }
          for ($I1 = 0; ($I1 < $TYPENAME_COUNT); ++$I1)
          {
            if (($MESSAGE == $TYPEVALUE_ARRAY[$I1]))
            {
              $MESSAGE = $TYPENAME_ARRAY[$I1];
              continue;
            }
          }
        }
        if (($STYPE == 'C'))
        {
          if (($TYPECODE != ''))
          {
            $query2 = (((''.'select * from SYS_CODE where PARENT_NO=\'').$TYPECODE).'\' order by CODE_ORDER');
            $cursor2 = exequery ($connection, $query2);
            while ($ROW = mysql_fetch_array ($cursor2))
            {
              $CODE_NO = $ROW['CODE_NO'];
              $CODE_NAME = $ROW['CODE_NAME'];
              $TYPEVALUE = (($TYPEVALUE.$CODE_NO).',');
              $TYPENAME = (($TYPENAME.$CODE_NAME).',');
            }
          }
          $MESSAGE1 = '';
          $temp = str_replace ('，', ',', $MESSAGE);
          $temp_ARRAY = explode (',', $temp);
          $temp_ARRAY_count = sizeof ($temp_ARRAY);
          $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;
          }
          for ($I1 = 0; ($I1 < $TYPENAME_COUNT); ++$I1)
          {
            $flag = 0;
            for ($T = 0; ($T < $temp_ARRAY_count); ++$T)
            {
              if (($temp_ARRAY[$T] == $TYPEVALUE_ARRAY[$I1]))
              {
                $MESSAGE1 = (($MESSAGE1.$TYPENAME_ARRAY[$I1]).',');
                $MESSAGE = $MESSAGE1;
                continue;
              }
            }
          }
        }
        if (($STYPE == 'R'))
        {
          if (($TYPECODE != ''))
          {
            $query2 = (((''.'select * from SYS_CODE where PARENT_NO=\'').$TYPECODE).'\' order by CODE_ORDER');
            $cursor2 = exequery ($connection, $query2);
            while ($ROW = mysql_fetch_array ($cursor2))
            {
              $CODE_NO = $ROW['CODE_NO'];
              $CODE_NAME = $ROW['CODE_NAME'];
              $TYPEVALUE = (($TYPEVALUE.$CODE_NO).',');
              $TYPENAME = (($TYPENAME.$CODE_NAME).',');
            }
          }
          $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;
          }
          for ($I1 = 0; ($I1 < $TYPENAME_COUNT); ++$I1)
          {
            if (($MESSAGE == $TYPEVALUE_ARRAY[$I1]))
            {
              $MESSAGE = $TYPENAME_ARRAY[$I1];
              continue;
            }
          }
        }
      }
      else
      {
        $MESSAGE = $ROW[$STYLE_ARRAY[$I]];
      }
      ($WORD_OUT .= (((''.'<td align="center" style=\'border:solid windowtext .5pt;padding:0.1cm 5.4pt 0.1cm 5.4pt\'>').$MESSAGE).'</td>'));
    }
    ($WORD_OUT .= '</tr>');
  }
  ($WORD_OUT .= '</table>');
  $WORD_NAME = '客户资料-报表';
  ob_end_clean ();
  header ('Cache-control: private');
  header ('Content-type: application/msword');
  header ('Accept-Ranges: bytes');
  header (('Accept-Length: '.strlen ($WORD_OUT)));
  header ((((''.'Content-Disposition: attachment; filename= ').$WORD_NAME).'.doc'));
  echo $WORD_OUT;
?>