public static function getSomeComment($goodsId, $nextId, $size) { if (empty($goodsId) || $size <= 0) { return array(); } $nextId = (int) $nextId; if ($nextId > 0) { $ret = DB::getDB()->fetchSome('g_goods_comment', '*', array('goods_id', 'state', 'id<'), array($goodsId, self::COMMENT_ST_VALID, $nextId), array('and', 'and'), array('id'), array('desc'), array($size)); } else { $ret = DB::getDB()->fetchSome('g_goods_comment', '*', array('goods_id', 'state'), array($goodsId, self::COMMENT_ST_VALID), array('and'), array('id'), array('desc'), array($size)); } if (empty($ret)) { return array(); } foreach ($ret as &$item) { $item['nickname'] = Util::emojiDecode($item['nickname']); $item['content'] = Util::emojiDecode($item['content']); $item['kf_reply'] = Util::emojiDecode($item['kf_reply']); } return empty($ret) ? array() : $ret; }
public static function findUserByPhone($phone, $fromDb = 'w') { if (empty($phone)) { return array(); } $ck = Cache::CK_USER_INFO_FOR_PHONE . $phone; $ret = Cache::get($ck); if ($ret !== false) { $ret = json_decode($ret, true); } else { $ret = DB::getDB($fromDb)->fetchOne('u_user', '*', array('phone'), array($phone)); if ($ret !== false) { Cache::set($ck, json_encode($ret)); } } if (empty($ret)) { return array(); } $ret['nickname'] = Util::emojiDecode($ret['nickname']); return $ret; }
public static function findUserByOpenId($openid, $fromDb = 'w') { if (empty($openid)) { return array(); } $ck = Cache::CK_WX_USER_INFO . $openid; $ret = Cache::get($ck); if ($ret !== false) { $ret = json_decode($ret, true); } else { $ret = DB::getDB($fromDb)->fetchOne('u_wx_user', '*', array('openid'), array($openid)); if ($ret !== false) { Cache::set($ck, json_encode($ret)); } } if (empty($ret)) { return array(); } $ret['nickname'] = Util::emojiDecode($ret['nickname']); return $ret; }