PHP getRealnamebyNameの例

コード例 #1

ファイル: customer_workload.php プロジェクト: sdgdsffdsfff/crm

	<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>

コード例 #2

ファイル: customer_list.php プロジェクト: sdgdsffdsfff/crm

    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">&nbsp;<?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">&nbsp;<a href="customer_action.php?act=mod&id=<?php 
    echo $list['id'];
    ?>
&page=<?php 
    echo $page;

コード例 #3

ファイル: function.php プロジェクト: sdgdsffdsfff/crm

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"]);
}