exp_rtx_sdk.php

通达OA2007SE源代码 非常好的

<?
  function userlisttree ($DEPT_PARENT)
  {
    global $connection;
    global $DEEP_COUNT;
    $DEEP_COUNT1 = $DEEP_COUNT;
    ($DEEP_COUNT .= '  ');
    $query = (((''.'SELECT * from DEPARTMENT where DEPT_PARENT=').$DEPT_PARENT).' order by DEPT_NO');
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $DEPT_ID = $ROW['DEPT_ID'];
      $DEPT_NAME = htmlspecialchars ($ROW['DEPT_NAME']);
      ($RETURN_TEXT .= ((($DEEP_COUNT1.'<department name="').$DEPT_NAME).'" describe=""'));
      $USER_TEXT = '';
      $query = (((''.'SELECT * from USER,USER_PRIV where DEPT_ID=').$DEPT_ID).' and USER.USER_PRIV=USER_PRIV.USER_PRIV and NOT_LOGIN!=\'1\' order by PRIV_NO,USER_NO,USER_NAME');
      $cursor1 = exequery ($connection, $query);
      while ($ROW = mysql_fetch_array ($cursor1))
      {
        $USER_ID = htmlspecialchars ($ROW['USER_ID']);
        $USER_NAME = htmlspecialchars ($ROW['USER_NAME']);
        $PRIV_NAME = htmlspecialchars ($ROW['PRIV_NAME']);
        $EMAIL = htmlspecialchars ($ROW['EMAIL']);
        $MOBIL_NO = htmlspecialchars ($ROW['MOBIL_NO']);
        $TEL_NO_DEPT = htmlspecialchars ($ROW['TEL_NO_DEPT']);
        $FAX_NO_DEPT = htmlspecialchars ($ROW['FAX_NO_DEPT']);
        $BIRTHDAY = substr ($ROW['BIRTHDAY'], 0, 10);
        if ((($BIRTHDAY != '1900-01-01') AND ($BIRTHDAY != '0000-00-00')))
        {
          $AGE = floor (((((time () - strtotime ($BIRTHDAY)) / 3600) / 24) / 365));
        }
        else
        {
          $AGE = 0;
          $BIRTHDAY = '';
        }
        ($USER_TEXT .= ((((((((((((((((($DEEP_COUNT1.'  <user uid="').$USER_ID).'" name="').$USER_NAME).'" email="').$EMAIL).'" mobile="').$MOBIL_NO).'" fax="').$FAX_NO_DEPT).'" phone="').$TEL_NO_DEPT).'" position="').$PRIV_NAME).'" age="').$AGE).'"  homepage="" address="" postcode="" country="" province="" city="" college="" gender="0" birthday="0" bloodtype="null" memo="" type="0" authtype="0"/>
'));
      }
      $DEPT_TEXT = userlisttree ($DEPT_ID);
      if ((($USER_TEXT == '') AND ($DEPT_TEXT == '')))
      {
        ($RETURN_TEXT .= '/>
');
        continue;
      }
      else
      {
        ($RETURN_TEXT .= (((('>
'.$USER_TEXT).$DEPT_TEXT).$DEEP_COUNT1).'</department>
'));
        continue;
      }
    }
    $DEEP_COUNT = $DEEP_COUNT1;
    return $RETURN_TEXT;
  }
  include_once 'inc/auth.php';
  if (($LOGIN_USER_PRIV != 1))
  {
    exit ();
  }
  $XML_OUT = '<?xml version="1.0" encoding="gb2312" ?>
';
  $query = 'SELECT * from UNIT';
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $UNIT_NAME = htmlspecialchars ($ROW['UNIT_NAME']);
    $TEL_NO = htmlspecialchars ($ROW['TEL_NO']);
    $POST_NO = htmlspecialchars ($ROW['POST_NO']);
    $ADDRESS = htmlspecialchars ($ROW['ADDRESS']);
    $EMAIL = htmlspecialchars ($ROW['EMAIL']);
  }
  ($XML_OUT .= (((((((((('<enterprise name="'.$UNIT_NAME).'" postcode="').$POST_NO).'" address="').$ADDRESS).'" phone="').$TEL_NO).'" email="').$EMAIL).'">
'));
  ($XML_OUT .= '<departments>
');
  ($XML_OUT .= userlisttree (0));
  ($XML_OUT .= '</departments>
');
  ($XML_OUT .= '</enterprise>
');
  ob_end_clean ();
  header ('Cache-control: private');
  header ('Content-type: application/octet-stream');
  header ('Accept-Ranges: bytes');
  header (('Accept-Length: '.strlen ($XML_OUT)));
  header (('Content-Length: '.strlen ($XML_OUT)));
  header ('Content-Disposition: attachment; filename= OA组织结构.xml');
  echo $XML_OUT;
?>