PHP getUserNameById函数代码示例

 public function __construct()
 {
     parent::__construct();
     $this->smarty->template_dir = WEB_PATH . 'pda/html/';
     $this->smarty->assign('curusername', $_SESSION['userId'] ? getUserNameById($_SESSION['userId']) : '');
     //设置当前用户名
 }

 /**
  * 提交信息生成订单
  * @param string type 来源 package ，cart 。普通
  * @param int cart_ids 购物车id
  */
 public function makeOrder()
 {
     $work_id = I('get.workid');
     if (!is_numeric($work_id)) {
         $this->assign('message', '作品信息');
         $this->display('Public/error');
         exit;
     }
     $data['work_id'] = $work_id;
     $data['order_category'] = 2;
     $session = session('user');
     $user_id = 2;
     // $session['user_id'];
     $data['user_id'] = $user_id;
     if (empty($user_id)) {
         $this->assign('message', '请登录后再操作');
         $this->display('Public/error');
         exit;
     }
     $data['order_number'] = '2cyj' . makeOrderCardId();
     $worksModel = D('Works');
     $work = $worksModel->getOrderWorkByid($work_id);
     if (!$work) {
         $this->assign('message', '生成订单异常，请重新操作');
         $this->display('Public/error');
         exit;
     }
     $data['author_id'] = $work['user_id'];
     $data['auther'] = getUserNameById($work['user_id']);
     $data['work_title'] = $work['title'];
     $data['create_date'] = date('Y-m-d H:i:s', time());
     $data['update_date'] = $data['create_date'];
     $data['money'] = $work['money'];
     $data['order_type'] = 0;
     $data['handle'] = 1;
     $data['ajax_type'] = 0;
     $OrderModel = D('Order');
     $id = $OrderModel->add($data);
     if ($id) {
         redirect('/Order/pay/orderid/' . $id);
     } else {
         $this->assign('message', '订单生成异常');
         $this->display('Public/error');
         exit;
     }
 }

 public function act_selectsku()
 {
     $sku = isset($_POST['sku']) ? trim($_POST['sku']) : "";
     $sku = get_goodsSn($sku);
     $goodsinfo = wrapperSkuOutModel::skuinfo($sku);
     $res = array();
     if (empty($goodsinfo)) {
         self::$errCode = 3;
         self::$errMsg = "<font color='red'>系统没有相应包装材料，请核对！</font>" . $sku;
         return $sku;
     } else {
         self::$errCode = 2;
         self::$errMsg = "包装材料正确，请扫描仓位！";
         $cguser = getUserNameById($goodsinfo['purchaseId']);
         $res['res_info'] = $goodsinfo['goodsName'] . "<br>采购:" . $cguser;
         $res['sku'] = $sku;
         return $res;
     }
 }

 public function act_export()
 {
     $checkUser = $_GET['checkUser'];
     $sku = $_GET['sku'];
     $startdate = $_GET['startdate'];
     $enddate = $_GET['enddate'];
     if (empty($checkUser) && empty($sku) && empty($startdate) && empty($enddate)) {
         echo "请选择导出条件";
         exit;
     }
     if (!empty($checkUser)) {
         $where[] = "tallyUserId='{$checkUser}'";
     }
     if (!empty($sku)) {
         $where[] = "sku = '{$sku}'";
     }
     if (!empty($startdate)) {
         $start = strtotime($startdate);
         $where[] = "entryTime >{$start}";
     }
     if (!empty($enddate)) {
         $end = strtotime($enddate);
         $where[] = "entryTime <{$end}";
     }
     $where = implode(" AND ", $where);
     $where = " where is_delete=0 and entryStatus=0 and " . $where;
     $lists = packageCheckModel::selectList($where);
     $excel = new ExportDataExcel('browser', "pointKpiExport" . date('Y-m-d') . ".xls");
     $excel->initialize();
     /** edit by Gary**/
     $tharr = array("点货人", "点货时间", "SKU", "数量", "良品数", "上架数", "批次号", '打标时间', '贴标时间', '检测时间', '上架时间', '备注');
     $excel->addRow($tharr);
     foreach ($lists as $list) {
         $user = getUserNameById($list['tallyUserId']);
         $time = date('Y-m-d H:i:s', $list['entryTime']);
         $sku = $list['sku'];
         $num = $list['num'];
         $ichibanNums = $list['ichibanNums'];
         $shelvesNums = $list['shelvesNums'];
         $batchNum = $list['batchNum'];
         //新增打标、贴标、检测、上架时间
         $printTime = $list['printTime'] ? date('Y-m-d H:i:s', $list['printTime']) : '无';
         $pasteTime = getSkuTime(array('type' => 'paste', 'tallyList' => $list['id']));
         $checkTime = $list['ichibanTime'] ? date('Y-m-d H:i:s', $list['ichibanTime']) : '无';
         $inputArray = array('type' => 'input', 'sku' => $list['sku'], 'finishTime' => $list['finishTime'], 'shelvesNums' => $list['shelvesNums']);
         $inputTime = getSkuTime($inputArray);
         $tdarr = array($user, $time, $sku, $num, $ichibanNums, $shelvesNums, $batchNum, $printTime, $pasteTime, $checkTime, $inputTime, $list['note']);
         /** end**/
         $excel->addRow($tdarr);
     }
     $excel->finalize();
     exit;
 }

include_once 'app/users.php';
//include_once('../user.php');
if (empty($_SESSION['logged_in'])) {
    redirect('index.php');
}
if (isset($_GET['uid'])) {
    $user = $_GET['uid'];
} else {
    $user = $_SESSION['uid'];
}
$interactions = getInteractions($user);
if ($interactions) {
    foreach ($interactions as $i) {
        $timestamp = $i['created_on'];
        $user = getUserNameById($i['created_by']);
        $author = getUserNameById($i['author']);
        if ($i['type'] == 'ideathread') {
            $title = getIdeaTitle($i['id']);
            $url = SITE_URL . '/home.php?iid=' . $i['id'];
        }
        if ($i['type'] == 'project') {
            $title = getProjectTitle($i['id']);
            $url = SITE_URL . '/home.php?pid=' . $i['id'];
        }
        if ($i['action'] == 'like') {
            $action = 'liked';
            $icon_image = SITE_URL . '/images/icons/like.png';
        }
        if ($i['action'] == 'comment') {
            $action = 'commented on';
            $icon_image = SITE_URL . '/images/icons/comment.jpg';

//.........这里部分代码省略.........
</td>
				<td><?php 
            echo $_smarty_tpl->tpl_vars['list']->value['purchasedays'];
            ?>
</td>
				<td><?php 
            echo checkSkuOnWayNum($_smarty_tpl->tpl_vars['list']->value['sku']);
            ?>
</td>
				<td></td>
				<td></td>
				<td></td>
				<td><?php 
            echo $_smarty_tpl->tpl_vars['list']->value['goodsWeight'];
            ?>
</td>
				<td><?php 
            if ($_smarty_tpl->tpl_vars['list']->value['status'] == 1) {
                ?>
在线<?php 
            } elseif ($_smarty_tpl->tpl_vars['list']->value['status'] == 2) {
                ?>
暂时停售<?php 
            } elseif ($_smarty_tpl->tpl_vars['list']->value['status'] == 3) {
                ?>
永久性停售<?php 
            } else {
                ?>
在线<?php 
            }
            ?>
</td>
				<td><?php 
            echo getUserNameById($_smarty_tpl->tpl_vars['list']->value['purchaseId']);
            ?>
</td>
			</tr>
			<tr <?php 
            if ($_smarty_tpl->getVariable('smarty')->value['foreach']['foo']['iteration'] % 2 == 0) {
                ?>
style="background-color:#f2f2f2;"<?php 
            }
            ?>
>
				<td  colspan="7" style="border-bottom:1px solid #ccc;">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['goodsName'];
            ?>

				</td>
				<td colspan="2"  style="border-bottom:1px solid #ccc;">

				</td>
				<?php 
            $_smarty_tpl->tpl_vars['ptlist'] = new Smarty_variable(CommonModel::getSkuPartner($_smarty_tpl->tpl_vars['list']->value['sku']), null, 0);
            ?>
				<td  colspan="7" style="border-bottom:1px solid #ccc;">
					
				</td>
				<td  style="border-bottom:1px solid #ccc;">
				</td>
				<td colspan="7" style="border-bottom:1px solid #ccc;">
					<?php 
            $_smarty_tpl->tpl_vars['pt'] = new Smarty_Variable();
            $_smarty_tpl->tpl_vars['pt']->_loop = false;
            $_from = $_smarty_tpl->tpl_vars['ptlist']->value;

    if ($participants['sender'] == $_SESSION['uid']) {
        $conv_partner = $participants['recipient'];
    } else {
        $conv_partner = $participants['sender'];
    }
    $messages = getMessageDetails($_GET['conv']);
    ?>
<div class="user-name-tops">
  <a href ="<?php 
    echo SITE_URL;
    ?>
/user.php?uid=<?php 
    echo $conv_partner;
    ?>
">  <?php 
    echo ucwords(getUserNameById($conv_partner));
    ?>
</a>
</div>
<div class="inboxs-messages">

    <?php 
    foreach ($messages as $message) {
        $user = getUserData($message['sender']);
        $recipent = $message['recipient'];
        if ($user['user_id'] == $_SESSION['uid']) {
            $classval = 'router-user-photo';
            $alignmessage = 'message-right';
            $alignphoto = 'photo-right';
        } else {
            $classval = 'router-user-photo';

						</div>

					</div>
				</div>
			</div>
			
			<div class="col-md-6 col-xs-12">
				<div class="panel panel-default">
					<div class="panel-heading"><strong class="panel-title">Товар</strong></div>
					<div class="panel-body">
						
						<div class="container-fluid">
							<div class="row" style="margin-bottom: 1em;">
								<div class="col-xs-4">Отправитель:</div>
								<div class="col-xs-8"><?php 
        echo getUserNameById($v->shipper_id);
        ?>
 &nbsp;&nbsp;<a href="<?php 
        echo $cfg['options']['siteurl'];
        ?>
/newchat/<?php 
        echo $v->shipper_id;
        ?>
/new"><i class="fa fa-envelope"></i></a></div>
							</div>
							<div class="row" style="margin-bottom: 1em;">
								<div class="col-xs-4">Товар:</div>
								<div class="col-xs-8"><?php 
        echo $v->item;
        ?>
</div>

 /**
  * 导出料号与箱号关联报表
  */
 public function view_exportBoxInfo()
 {
     require_once WEB_PATH . 'lib/PHPExcel.php';
     $objPHPExcel = new PHPExcel();
     $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '备货单号Shipment ID');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B1', '箱号CTN NO.');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('C1', '料号SKU');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('D1', '每箱个数');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('E1', '优先上架Priority for Putaway');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('F1', '纸箱长度L(cm)');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('G1', '纸箱宽度W(cm)');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('H1', '纸箱高度H(cm)');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('I1', '体积CBM');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('J1', '每箱净重N.W(kg)');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('K1', '每箱毛重G.W(kg)');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('L1', '中文描述Goods Desc(CN)');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('M1', '英文描述 Goods Desc');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('N1', '材质Material');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('O1', '单价U/P(RMB)');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('P1', '总价TTL(RMB)');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('Q1', '单价U/P(USD)');
     $objPHPExcel->setActiveSheetIndex(0)->setCellValue('R1', '总价TTL(USD)');
     $serOrderSn = isset($_GET['orderSn']) ? $_GET['orderSn'] : '';
     $serStatus = isset($_GET['status']) ? $_GET['status'] : '';
     $serSku = isset($_GET['sku']) ? $_GET['sku'] : '';
     $serStartTime = isset($_GET['startTime']) ? $_GET['startTime'] : '';
     $serEndTime = isset($_GET['endTime']) ? $_GET['endTime'] : '';
     $condition = '';
     if (!empty($serOrderSn)) {
         $condition .= " AND a.replenshId = '{$serOrderSn}'";
     }
     if (!empty($serSku)) {
         $condition .= " AND b.sku = '{$serSku}'";
     }
     if (!empty($serStatus)) {
         $condition .= " AND a.status = '{$serStatus}'";
     }
     if (!empty($serStartTime) && $serEndTime >= $serStartTime) {
         $serstart = strpos($serStartTime, ':') !== false ? strtotime($serStartTime) : strtotime($serStartTime . " 00:00:00");
         $serend = strpos($serEndTime, ':') !== false ? strtotime($serEndTime) : strtotime($serEndTime . " 23:59:59");
         $condition .= " AND a.addtime BETWEEN '{$serstart}' AND '{$serend}'";
     }
     $boxModel = new BoxManageModel();
     $rtnData = $boxModel->getListBoxInfo($condition);
     if (!empty($rtnData)) {
         $row = 2;
         foreach ($rtnData as $k => $v) {
             $orderSn = $v['replenshId'];
             $boxId = $v['boxid'];
             $length = $v['length'];
             $width = $v['width'];
             $high = $v['high'];
             $volume = round($v['volume'] / 1000000, 3);
             $grossWeight = $v['grossWeight'];
             $netWeight = $v['netWeight'];
             $addtime = date('Y-m-d', $v['addtime']);
             $status = $v['status'];
             $userName = getUserNameById($v['adduser']);
             $sku = $v['sku'];
             $num = $v['num'];
             $skuBase = $boxModel->getSkuBaseInfo($sku);
             $skuName = $skuBase['goodsName'];
             $skuPrice = $skuBase['goodsCost'];
             $totalRmb = $skuPrice * $num;
             switch ($status) {
                 case '1':
                     $stu = '已配货';
                     break;
                 case '2':
                     $stu = '已复核';
                     break;
                 case '3':
                     $stu = '已装柜';
                     break;
                 case '4':
                     $stu = '海外已收货';
                     break;
                 default:
                     $stu = '';
                     break;
             }
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $row, $orderSn);
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . $row, $boxId);
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('C' . $row, $sku);
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('D' . $row, $num);
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('E' . $row, '');
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('F' . $row, $length);
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('G' . $row, $width);
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('H' . $row, $high);
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('I' . $row, $volume);
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('J' . $row, $netWeight);
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('K' . $row, $grossWeight);
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('L' . $row, $skuName);
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('M' . $row, '');
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('O' . $row, $skuPrice);
             $objPHPExcel->setActiveSheetIndex(0)->setCellValue('P' . $row, $totalRmb);
//.........这里部分代码省略.........

				</div>
			<?php 
        }
        ?>
			<div class="col-md-2 col-xs-12">
				Чат с <?php 
        if ($v[0]->from_id == $user['id']) {
            $chatwith = $v[0]->to_id;
        } else {
            $chatwith = $v[0]->from_id;
        }
        ?>
				<?php 
        echo getUserIconById($chatwith);
        echo " ";
        echo getUserNameById($chatwith);
        ?>
			</div>
			<div class="col-md-7 col-xs-12"><?php 
        echo preg_replace("/[\n|\r|\r\n|\n\r]+/", "<br><br>", $v[0]->text);
        ?>
</div>
			<div class="col-md-2 col-xs-12 text-right"><small class="text-muted"><?php 
        echo $v[0]->time;
        ?>
</small></div>

		</div>
	</a>
	<hr style="margin: 0;">
	<?php 

 /**
  * WhGoodsAssignAct::export_data()
  * 导出调拨数据 
  * @return void
  */
 public function export_data()
 {
     $ids = trim($_GET['ids']);
     if ($ids) {
         $assignList = WhGoodsAssignModel::getAssignList(" and a.id in ({$ids})", '', '', 'a.id');
         $assign_status = C('assign_status');
         //print_r($assign_status);exit;
         $name = 'assignList' . date('Y-m-d') . ".xls";
         //$name   =   iconv('UTF-8', 'gb2312//ignore', $name);
         $excel = new ExportDataExcel('browser', $name);
         $excel->initialize();
         $tharr = array("调拨单号", "SKU", "产品名称", "转出仓库", "转入仓库", "需求数量", "配货数量", '出库复核数量', '接收数量', '生成人员', '生成时间', '调拨单状态', '状态变更时间');
         $excel->addRow($tharr);
         if (!empty($assignList)) {
             foreach ($assignList as $assign) {
                 $outStore = WarehouseManagementModel::warehouseManagementModelList(" where id = {$assign['outStoreId']}");
                 $outStore = $outStore[0]['whName'];
                 $inStore = WarehouseManagementModel::warehouseManagementModelList(" where id = {$assign['inStoreId']}");
                 $inStore = $inStore[0]['whName'];
                 $maker = getUserNameById($assign['createUid']);
                 $make_date = date('Y-m-d H:i:s', $assign['createTime']);
                 $state_date = date('Y-m-d H:i:s', $assign['statusTime']);
                 $status = $assign_status[$assign['status']];
                 $details = WhGoodsAssignModel::getsAssignListDetail($assign['id']);
                 foreach ($details as $k => $val) {
                     $tdarr = array($k == 0 ? $assign['assignNumber'] : '', $val['sku'], $val['goodsName'], $outStore, $inStore, $val['num'], $val['assignNum'], $val['outCheckNum'], $val['inCheckNum'], $k == 0 ? $maker : '', $k == 0 ? $make_date : '', $k == 0 ? $status : '', $k == 0 ? $state_date : '');
                     //print_r($tdarr);exit;
                     $excel->addRow($tdarr);
                 }
             }
         }
         $excel->finalize();
         exit;
     }
 }

function getEmpathizerUserNameByDbToken($iDbTokenSg)
{
    global $wpdb;
    $tTableNameSg = getCallRecordTableName();
    $tDbTokenColNameSg = DatabaseAttributes::database_token;
    $tEmpathizerColumnSg = DatabaseAttributes::empathizer_id;
    $tQuerySg = "SELECT {$tEmpathizerColumnSg} FROM {$tTableNameSg} WHERE {$tDbTokenColNameSg}='{$iDbTokenSg}'";
    $tCallRecordsItemsMix = $wpdb->get_results($tQuerySg, ARRAY_N);
    $userId = $tCallRecordsItemsMix[0][0];
    $rEmailSg = getUserNameById($userId);
    return $rEmailSg;
}

	
	<?php 
foreach ($chat as $v) {
    ?>
		<div class="row <?php 
    if ($v->is_read == 0) {
        echo 'bg-unread';
    }
    ?>
" style="padding:1em;">

			<div class="col-md-2 col-xs-12">
				<?php 
    echo getUserIconById($v->from_id);
    echo " ";
    echo getUserNameById($v->from_id);
    ?>
			</div>
			<div class="col-md-7 col-xs-12"><?php 
    echo preg_replace("/[\n|\r|\r\n|\n\r]+/", "<br><Br>", $v->text);
    ?>
</div>
			<div class="col-md-2 col-xs-12 text-right"><small class="text-muted"><?php 
    echo $v->time;
    ?>
</small></div>
			
		</div>
	<hr style="margin:0;">
	<?php 
}

"></ul>
                        </div>

                        <div style="width:296px;float:right;margin-left:-5px;">
                            <ul class="rater-users raterusers-<?php 
        echo $project['project_id'];
        ?>
" data-id="<?php 
        echo $project['project_id'];
        ?>
">
                                <!--                --><?php 
        //$raters = getRatersForProject($project_id);
        if ($raters) {
            foreach ($raters as $rater) {
                echo '<div class="rater-users-list" data-id="' . $rater['rater_id'] . '" user-id="' . $rater['user_id'] . '"><span class="remove-rater" data-id="' . $rater['rater_id'] . '" user-id="' . $rater['user_id'] . '">X</span><a href="' . SITE_URL . '/user.php?uid=' . $rater['user_id'] . '"><li class="rater-name">' . getUserNameById($rater['user_id']) . '</li></a></div>';
            }
        }
        ?>
                            </ul>
                            <div class="success-message"></div>
                        </div>

                    </div> <!-- project-rater-area -->
                </td>
                <td>
                    <?php 
        // $rate = getAdminRatedStatus($project['project_id'], $_SESSION['uid']);
        $value = getAdminRateForProject($project['project_id'], $_SESSION['uid']);
        if ($project['seed_rating'] == 0) {
            $seed = 'N/A';

                            <input type="text" id="route-search" placeholder="Type Your Router Name"
                                   data-id="<?php 
        echo $_SESSION['uid'];
        ?>
"/>
                            <input type="hidden" id="route-button" value="Search"/>
                            <ul id="route-result"></ul>
                        </div>

                        <div style="width:296px;float:right;margin-left:-20px;cursor: pointer;">
                            <ul class="routed-users">
                                <?php 
        $routers = getRoutersForProject($project['project_id'], $_SESSION['uid']);
        if ($routers) {
            foreach ($routers as $router) {
                echo '<div class="routed-users-list" data-id="' . $router['router_id'] . '" user-id="' . $router['routed_to'] . '"><span class="unroute" data-id="' . $router['router_id'] . '" user-id="' . $router['routed_to'] . '">X</span><a href="' . SITE_URL . '/user.php?uid=' . $router['routed_to'] . '"><li class="routed-name">' . getUserNameById($router['routed_to']) . '</li></a></div>';
            }
        }
        //
        ?>
                            </ul>
                            <div class="success-message"></div>
                        </div>
                        <!--                        <div class="routers-set">-->

                        <!--                        </div> <!-- routers-set -->
                    </div> <!-- route-area -->


                           <!-- report area -->
                    <div class="report-area">