<h2>最近7天新增客户跟进统计</h2> <table width="98%" height="94" border="0" cellpadding="3" cellspacing="1" bgcolor="#cccccc" style="margin:0 auto;padding-top:10px;"> <thead> <tr bgcolor="#f9f9f9"> <td width="5%" height="24" align="center" valign="middle">用户名</td> <td width="20%" height="24" align="center" valign="middle">数量</td> </tr> </thead> <?php $sqlstr = get_sql("SELECT userid,COUNT(*) AS c FROM {pre}services WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= DATE(dateline) GROUP BY userid"); $list = $db->getList($sqlstr); foreach ($list as $c) { ?> <tr bgcolor="#f9f9f9"> <td width="5%" align="center" valign="middle"><?php echo getRealnamebyName($c['userid']); ?> </td> <td align="center" valign="middle"><?php echo $c['c']; ?> </td> </tr> <?php } ?> </table> </div> </div>
echo $list['addr'] . "<br>" . $list['email']; ?> </td> <td height="24" align="left" valign="middle"><?php echo $list['mobile'] . "<br>" . $list['tel']; ?> </td> <td height="24" align="left" valign="middle"><?php echo getLastServices($list['id']); ?> </td> <td height="24" align="left" valign="middle"><?php echo date('Y-m-d', strtotime($list['dateline'])); ?> <br><?php echo empty($list['managerid']) ? "公海" : getRealnamebyName($list['managerid']); ?> </td> <td width="15%" height="24" align="left" valign="middle"> <?php if ($industry == '4') { echo $list['rank']; } else { echo "<a href='customer_action.php?act=mod&id=" . $list['id'] . "&tab=0' title='" . $list['services'] . "'>" . utf_substr($list['services'], 20) . "</a>"; } ?> </td> <td height="24" align="center" valign="middle"> <a href="customer_action.php?act=mod&id=<?php echo $list['id']; ?> &page=<?php echo $page;
function getLastServices($fid) { global $db; $sql = get_sql("select name,dateline,userid from {pre}services where isdel=0 and fid=" . $fid . " order by id desc limit 1"); $list = $db->getonerow($sql); return "<a href='customer_action.php?act=mod&id=" . $fid . "&tab=1' title='" . $list['name'] . "'>" . utf_substr($list['name'], 20) . "</a><BR>" . $list['dateline'] . "/" . getRealnamebyName($list["userid"]); }