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