function getDomainCheckUrl($fdomains)
{
$checkUrl = "https://test.httpapi.com/api/domains/available.json?auth-userid=646061&api-key=sP6NPKSyagaoitKcihSlMMdAEmot3zFq";
if (count($fdomains) > 0) {
$domain_name_array = i_array_column($fdomains, "domain_name");
$tlds_array = i_array_column($fdomains, "tlds");
$domain_name_url = join("&domain-name=", $domain_name_array);
$tlds_url = join("&tlds=", $tlds_array);
return $checkUrl . "&domain-name=" . $domain_name_url . "&tlds=" . $tlds_url;
}
}
public function getMemberPrice($goods_id)
{
$rows = $this->field("member_level_id,price")->where(array("goods_id" => $goods_id))->select();
//取出member_level_id
$member_level_ids = i_array_column($rows, "member_level_id");
//取出price
$prices = i_array_column($rows, "price");
//将member_level_id作为键值,price作为值
$row = array_combine($member_level_ids, $prices);
return $row;
dump($row);
}
public function articleDetail()
{
$arr = I();
$article = M('article');
$tags = M('articleTags');
$relational = M('articleTagsRelational');
$articleCategory = M('article_category');
$articleCategorys = $articleCategory->select();
$article->where(array('id' => $arr['id']))->setInc('visit_num');
$data = $article->where(array('id' => $arr['id']))->find();
$listHot = $article->where(array('is_show' => '1', 'is_del' => '0'))->order('visit_num desc')->limit(0, 5)->select();
$relat = $relational->where(array('article_id' => $arr['id']))->select();
$aboutArticle = "";
if ($relat) {
$tag = array();
$t = array();
foreach ($relat as $key => $value) {
$d = $tags->where(array('id' => $value['tags_id']))->find();
$tag[$key]['name'] = $d['name'];
$tag[$key]['id'] = $d['id'];
if ($d) {
$t[$key][] = 'eq';
$t[$key][] = $d['id'];
}
}
if ($t) {
array_push($t, 'or');
$condition = array();
$condition['tags_id'] = $t;
$condition['article_id'] = array('neq', $arr['id']);
$about = $relational->distinct(true)->field('article_id')->where($condition)->select();
if ($about) {
$about = i_array_column($about, 'article_id');
$con['id'] = array('in', $about);
$con['is_show'] = '1';
$aboutArticle = $article->where($con)->limit(0, 2)->select();
}
}
}
$this->assign('aboutArticle', $aboutArticle);
$this->assign('listHot', $listHot);
$this->assign('categorys', $articleCategorys);
$this->assign('data', $data);
$this->assign('tag', $tag);
$this->display();
}
/**
* 模拟专辑
* @return [type] [description]
*/
function monialbum()
{
//专辑数量
$count = I("post.count");
$user = M()->query("select id,name,headpic from usertable order by rand() LIMIT " . $count);
$AlbumTable = M("album");
$j = 0;
while ($count) {
$count--;
$songs = M()->query("select id from songtable order by rand() LIMIT 12");
$data['uid'] = $user[$count]['id'];
$data['name'] = $user[$count]['name'] . "收藏";
$data['detail'] = "都是好听的歌曲";
$data['pic'] = $user[$count]['headpic'];
$data['songs'] = implode("#", i_array_column($songs, 'id'));
$data['mtime'] = date("Y-m-d H:i:s");
if ($AlbumTable->add($data)) {
$j++;
}
}
echo "成功增加专辑" . $j . "个";
}
/**
* 分页同步数据
* select * from i_member where length(mobile)>11 手机长度超过11位
* @param int $page 数据库分页当前页数
* @param int $totalNum 数据库总记录
*/
public function sync($page)
{
$params = null;
$prefixAvatar = 'http://www.idaiyan.cn';
$sexMap = [1 => 1, 2 => 2, 3 => 0, 0 => 0];
$statusMap = [0 => 1, 1 => 0];
if ($page <= 0) {
$page = 1;
}
$page = ($page - 1) * self::$pageSize;
$multiMobile = $this->multi();
$multiMobile = implode(',', $multiMobile);
$query = self::find()->where(['AND', "mobile not in ({$multiMobile})", "mobile<>''", "is_admin=0", "is_del<>2"])->orderBy('uid')->offset($page)->limit(self::$pageSize)->asArray();
$fileLogger = FileLogger::getInstance('idaiyan.log');
$fileLog = FileLogger::getInstance('idaiyan_dc.log');
$user = new UserBaseInfo();
foreach ($query->batch(self::$batchSize) as $members) {
$now = time();
foreach ($members as $member) {
// $exists = $user->uniqueUser($member['mobile']);
// if ($exists) {
// $fileLog->writeOne($member['mobile'] , Logger::LEVEL_INFO, 'i代言语句数据中心用户同步手机重复检测');
// continue;
// }
if ($member['avatar']) {
$avatar = $prefixAvatar . $member['avatar'];
} else {
$avatar = '';
}
$openId = openId('idaiyan');
$params[] = ['username' => $member['nickname'], 'realname' => $member['truename'], 'password' => $member['password'], 'password_salt' => $member['random'], 'mobile' => $member['mobile'], 'email' => $member['email'], 'gender' => $sexMap[$member['sex']], 'avatar' => $avatar, 'birthday' => date('Y-m-d', $member['birthday']), 'reg_ip' => $member['create_ip'], 'reg_channel' => 'idaiyan', 'last_login_time' => $member['update_at'], 'last_login_ip' => '', 'create_time' => $now, 'update_time' => $member['update_at'], 'status' => $statusMap[$member['is_del']], 'open_id' => $openId];
}
$result = $user->batchInsertUser($params);
if (!$result) {
$mobiles = i_array_column($members, 'mobile');
$fileLogger->writeOne('同步失败' . json_encode($mobiles), Logger::LEVEL_INFO, 'iDaiyan用户同步失败');
}
unset($params);
}
}
