adminhome.php

通达OA部分源代码

<?php
include "logincheck.php";
include_once "myconnect.php";
function main()
{

$keyword="";
$sbexpiry=1;
$sbapproval=1;
$recperpage=10;
?> 
<table width="100%" border="0" cellpadding="0" cellspacing="0" dwcopytype="CopyTableCell">
  <tr>
    <td valign="top"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="10" class="onepxtable">
              <form name="form1" method="post" action="search.php" <? //onSubmit="return validate();"?>>
                <tr align="left"> 
                  <td height="25" colspan="3" valign="top" bgcolor="#004080">&nbsp;<font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>Search</strong></font></td>
                </tr>
                <tr> 
                  <td width="50%" align="right" valign="top" class="innertablestyle"><font class='normal'><strong>Search 
                    Keywords:</strong></font></td>
                  <td valign="top" class="maintext"> <font class='normal'> 
                    <input name="keyword" type="text" size="40">
                    </font></td>
                </tr>
                <!--<tr valign="top"> 
                  <td width="40%" align="right" class="innertablestyle"><font class='normal'><strong>Search 
                    in </strong></font></td>
                  <td width="6" class="maintext">&nbsp;</td>
                  <td width="60%" class="maintext"> <p><font class='normal'>(Please choose at least one option of these)<br>
                      <input name="all_p" type="checkbox" value="yes" checked>
                      All<br>
                      <input name="article" type="checkbox" id="article" value="yes">
                      Article<br>
                      <input type="checkbox" name="int_comment" value="yes">
                      Initial Comment<br>
                      <input type="checkbox" name="all_comment" value="yes">
                      All Comments<br>
                      <input type="checkbox" name="member" value="yes">
                      Members Username/Name<br>
                      </font></p></td>
                </tr>-->
                <tr>
                  <td height="25" align="right" valign="top" class="innertablestyle"><font class='normal'><strong>Show:</strong></font></td>
                  <td align="left"><font face="Arial, Helvetica, sans-serif"> 
                    <font size="2"> 
                    <input name="sbapproval" type="radio" value="1" <? if($sbapproval==1) { echo "checked";}?>>
                    All</font></font><font size="2" face="Arial, Helvetica, sans-serif"> 
                    <input type="radio" name="sbapproval" value="2" <? if($sbapproval==2) { echo "checked";}?> >
                    Unapproved 
                    <input type="radio" name="sbapproval" value="3" <? if($sbapproval==3) { echo "checked";}?> >
                    Approved</font></td>
                </tr>
                <tr> 
                  <td align="right" valign="top" class="innertablestyle"><font class='normal'><strong>Search 
                    in:</strong></font></td>
                  <td valign="top" class="maintext"> <select name="type">
                      <option value="1" selected>Sell Offers</option>
                      <option value="2">Buy Offers</option>
                      <option value="3">Products Catalogs</option>
                      <option value="4">Company Profiles</option>
                    </select> </td>
                </tr>
                <tr> 
                  <td align="right" valign="top" class="innertablestyle"><font class='normal'><strong>Category:</strong></font></td>
                  <td valign="top" class="maintext"><font face="Arial, Helvetica, sans-serif" size="2"> 
                    <select name=cid id="cid"  >
                      <option value=0>All Categories</option>
                      <?
			
				$rs_query=mysql_query("Select * from sbbleads_categories where sb_pid=0");
	
	while ($rs=mysql_fetch_array($rs_query))
	{
				?>
                      <option value="<?php echo $rs["sb_id"]; ?>"
						
				><?php echo $rs["sb_cat_name"]; ?></option>
                      <?
                      
			  }
			  ?>
                    </select>
                    </font><font class='normal'>&nbsp;</font></td>
                </tr>
                <tr> 
                  <td align="right" valign="top" class="innertablestyle"><font class='normal'>&nbsp;</font></td>
                  <td valign="top" class="maintext"><font class='normal'> 
                    <input type="submit" name="Submit" value="Search">
                    </font></td>
                </tr>
              </form>
            </table></td>
        </tr>
        <tr> 
          <td align="left" valign="top"> <table width="100%" border="0" align="center" cellpadding="2" cellspacing="10">
              <tr bgcolor="#004080"> 
                <td height="25" colspan="2"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>&nbsp;Site 
                  Statistics </strong></font></td>
              </tr>
              <tr> 
                <td align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Total 
                  Members:</font></strong></td>
                <td><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                  <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_members "));
				echo $num;
				?>
                  </font></strong></td>
              </tr>
              <tr> 
                <td align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Total 
                  Categories:</font></strong></td>
                <td><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                  <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_categories"));
				echo $num;
				?>
                  </font></strong></td>
              </tr>
              <tr> 
                <td align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Total 
                  Sell Offers:</font></strong></td>
                <td><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                  <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_offers where 1"));
				echo $num;
				?>
                  </font></strong></td>
              </tr>
              <tr> 
                <td width="50%" align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Total 
                  Buy Offers:</font></strong></td>
                <td><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                  <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_offers_buy where 1"));
				echo $num;
				?>
                  </font></strong></td>
              </tr>
              <tr> 
                <td align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Total 
                  Product Catalogs:</font></strong></td>
                <td><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                  <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_products where 1"));
				echo $num;
				?>
                  </font></strong></td>
              </tr>
              <tr> 
                <td align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Total 
                  Company Profiles:</font></strong></td>
                <td><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                  <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_companyprofiles where 1"));
				echo $num;
				?>
                  </font></strong></td>
              </tr>
            </table></td>
        </tr>
        <tr> 
          <td align="left" valign="top"><table width="100%" border="0" cellspacing="10" cellpadding="2">
              <tr> 
                <td height="25"  bgcolor="#004080"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>&nbsp;Recent 
                  Statistics</strong></font></td>
              </tr>
			  <tr><td><table width="100%" align="center" cellpadding="2" cellspacing="1">
                    <tr> 
                      <td height="25" align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Posted 
                        \Type</font></strong></td>
                      <td height="25" align="center" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Sell 
                        Offers</font></strong></td>
                      <td height="25" align="center" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Buy