adminhome.php

通达OA部分源代码

                        Offers </font></strong></td>
                      <td height="25" align="center" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Product 
                        Catalogs </font></strong></td>
                      <td align="center" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Company 
                        Profiles</font></strong></td>
                      <td height="25" align="center" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Signups</font></strong></td>
                    </tr>
                    <tr> 
                      <td height="25" align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Today</font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_offers where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))=0"));
				echo $num;
				?>
                        </font></strong></td>
                      <td height="25" align="center"><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
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))=0"));
				echo $num;
				?>
                        </font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_products where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))=0"));
				echo $num;
				?>
                        </font></strong></td>
                      <td align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_companyprofiles where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))=0"));
				echo $num;
				?>
                        </font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_members where
				(TO_DAYS(NOW()) - TO_DAYS(sb_ondate))=0"));
				echo $num;
				?>
                        </font></strong></td>
                    </tr>
                    <tr> 
                      <td height="25" align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Yesterday</font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_offers  where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))=1"));
				echo $num;
				?>
                        </font></strong></td>
                      <td height="25" align="center"><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
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))=1"));
				echo $num;
				?>
                        </font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_products where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))=1"));
				echo $num;
				?>
                        </font></strong></td>
                      <td align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_companyprofiles where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))=1"));
				echo $num;
				?>
                        </font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_members where
				(TO_DAYS(NOW()) - TO_DAYS(sb_ondate))=1"));
				echo $num;
				?>
                        </font></strong></td>
                    </tr>
                    <tr> 
                      <td height="25" align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Last 
                        7 Days</font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_offers  where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))<=7"));
				echo $num;
				?>
                        </font></strong></td>
                      <td height="25" align="center"><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
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))<=7"));
				echo $num;
				?>
                        </font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_products where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))<=7"));
				echo $num;
				?>
                        </font></strong></td>
                      <td align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_companyprofiles where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))<=7"));
				echo $num;
				?>
                        </font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_members where
				(TO_DAYS(NOW()) - TO_DAYS(sb_ondate))<=7"));
				echo $num;
				?>
                        </font></strong></td>
                    </tr>
                    <tr> 
                      <td height="25" align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Last 
                        30 Days</font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        &nbsp; 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_offers  where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))<=30"));
				echo $num;
				?>
                        &nbsp;</font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        &nbsp; 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_offers_buy where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))<=30"));
				echo $num;
				?>
                        &nbsp;</font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        &nbsp; 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_products  where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))<=30"));
				echo $num;
				?>
                        &nbsp;</font></strong></td>
                      <td align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        &nbsp; 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_companyprofiles where
				(TO_DAYS(NOW()) - TO_DAYS(sb_postedon))<=30"));
				echo $num;
				?>
                        &nbsp;</font></strong></td>
                      <td height="25" align="center"><strong><font color="#FF6600" size="2" face="Arial, Helvetica, sans-serif"> 
                        &nbsp; 
                        <?
				$num=mysql_num_rows(mysql_query("select sb_id from sbbleads_members where
				(TO_DAYS(NOW()) - TO_DAYS(sb_ondate))<=30"));
				echo $num;
				?>
                        &nbsp;</font></strong></td>
                    </tr>
                  </table></td></tr>
            </table></td>
        </tr>
      </table> </td>
  </tr>
</table>
<?
}// end main

include_once "template.php";
?>