userhome.php

通达OA部分源代码

<?
include_once "logincheck.php";

include_once "session.php";

function main()
{
$id=0;
if(isset($_SESSION["sbbleads_userid"]))
{
$id=$_SESSION["sbbleads_userid"];
}
if(isset($_REQUEST["tmp"]))
{
$id=$_REQUEST["tmp"];
}

$config=mysql_fetch_array(mysql_query("select * from sbbleads_config"));
//$config["null_char"]="-";
?>

<table width="100%" border="0" cellpadding="0" cellspacing="0" dwcopytype="CopyTableCell">
  <tr align="center"> 
    <td align="right" valign="top"> <table width="95%" border="0" cellspacing="0" cellpadding="0" class="maintablestyle" align="center">
        <tr> 
          <td width="100%" valign="top"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" class="onepxtable">
              <tr> 
                <td height="25" class="titlestyle"><div align="left">&nbsp;User 
                    Statistics</div></td>
              </tr>
              <tr> 
                <td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="5">
                    <tr> 
                      <td width="40%" height="25" class="innertablestyle">
<div align="right"><strong><font class='normal'>&nbsp;Total 
                          Number of Sell Offers Posted</font></strong></div></td>
                      <td><a href="manage_offers.php"><strong> 
                        <?php $sbq_off="select * from sbbleads_offers where sb_uid=".$_SESSION["sbbleads_userid"];
				echo mysql_num_rows(mysql_query($sbq_off)); ?>
                        </strong></a></td>
                    </tr>
                    <tr> 
                      <td width="40%" height="25" class="innertablestyle">
<div align="right"><strong><font class='normal'>&nbsp;Total 
                          Number of Buy Offers Posted</font></strong></div></td>
                      <td><a href="manage_offers_buy.php"><strong> 
                        <?php
						$sbq_off="select * from sbbleads_offers_buy where sb_uid=".$_SESSION["sbbleads_userid"];
				echo mysql_num_rows(mysql_query($sbq_off)); ?>
                        </strong></a></td>
                    </tr>
                    <tr> 
                      <td width="40%" height="25" class="innertablestyle">
<div align="right"><strong><font class='normal'>&nbsp;Total 
                          Number of Product Catalogs Posted</font></strong></div></td>
                      <td><a href="manage_products.php"><strong> 
                        <?php $sbq_off="select * from sbbleads_products where sb_uid=".$_SESSION["sbbleads_userid"];
				echo mysql_num_rows(mysql_query($sbq_off)); ?>
                        </strong></a></td>
                    </tr>
                    <tr> 
                      <td width="40%" height="25" class="innertablestyle">
<div align="right"><strong><font class='normal'>&nbsp;Total 
                          Number of Messages (Inbox)</font></strong></div></td>
                      <td><a href="show_messages.php"><strong> 
                        <? 
				  $num=mysql_num_rows(mysql_query("select sb_id from sbbleads_messages where sb_t_del='No' and sb_tid=$id"));
				  
				  echo $num;
				  
				  ?>
                        </strong></a></td>
                    </tr>
                    <tr> 
                      <td width="40%" height="25" class="innertablestyle">
<div align="right"><strong><font class='normal'>&nbsp;Total 
                          Number of Messages (Outbox)</font></strong></div></td>
                      <td><a href="show_messages.php"><strong> 
                        <? 
				  $num=mysql_num_rows(mysql_query("select sb_id from sbbleads_messages where sb_f_del='No' and sb_fid=$id"));
				  echo $num;
				  ?>
                        </strong></a></td>
                    </tr>
                    <tr> 
                      <td width="40%" height="25" class="innertablestyle">
<div align="right"><strong><font class='normal'>&nbsp;New 
                          Messages </font></strong></div></td>
                      <td><a href="show_messages.php"><strong> 
                        <? 
				  $num=mysql_num_rows(mysql_query("select sb_id from sbbleads_messages where sb_msg_read='No' and sb_t_del='No' and sb_tid=$id"));
				  echo $num;
				  ?>
                        </strong></a></td>
                    </tr>
                  </table></td>
              </tr>
            </table> 
            
          </td>
        </tr>
      </table>
      <br> </td>
  </tr>
</table>
<?
}// end main
include_once "template1.php";
?>