本文整理汇总了PHP中Articles::leftJoin方法的典型用法代码示例。如果您正苦于以下问题:PHP Articles::leftJoin方法的具体用法?PHP Articles::leftJoin怎么用?PHP Articles::leftJoin使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Articles
的用法示例。
在下文中一共展示了Articles::leftJoin方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: articlePreview
/**
* 显示文章页
*
* @param int $id 文章id
*/
public function articlePreview($id, $result = array())
{
if ($_SERVER["HTTP_HOST"] != "ht.5067.org") {
$article = Articles::find($id);
$customer_info = CustomerInfo::where('cus_id', $this->cus_id)->first();
if ($customer_info->lang == 'en') {
$lang['the_last'] = 'The last one';
$lang['the_first'] = 'The first one';
} else {
$lang['the_last'] = '已经是最后一篇';
$lang['the_first'] = '已经是第一篇';
}
$a_moreimg = Moreimg::where('a_id', $id)->get()->toArray();
array_unshift($a_moreimg, array('title' => $article->title, 'img' => $article->img));
$images = array();
if (count($a_moreimg)) {
$i = 0;
foreach ($a_moreimg as $a_img) {
$images[$i]['title'] = $a_img['title'];
$images[$i]['image'] = $a_img['img'] ? $this->source_dir . 'l/articles/' . $a_img['img'] : '';
$i++;
}
}
$list_id = Articles::where('c_id', $article->c_id)->where($this->type . '_show', '1')->where('use_url', '0')->orderBy('is_top', 'desc')->orderBy('sort', 'asc')->orderBy('created_at', 'desc')->select('id', 'title', 'img', 'introduction', 'created_at')->lists('id');
foreach ((array) $list_id as $key => $val) {
$article_prev = NULL;
$article_next = NULL;
if ($val == $id) {
if ($key != 0) {
$prev_id = $list_id[$key - 1];
$article_prev = Articles::find($prev_id);
}
if ($key < count($list_id) - 1) {
$next_id = $list_id[$key + 1];
$article_next = Articles::find($next_id);
}
break;
}
}
$result = $this->pagePublic($article->c_id);
if (is_array($result['navs']) && !empty($result['navs'])) {
foreach ((array) $result['navs'] as $nav) {
if ($nav['current'] == 1) {
$pagenavs = $nav['childmenu'];
break;
} else {
$pagenavs = array();
}
}
}
if (empty($pagenavs)) {
$pagenavs = array();
}
$result['pagenavs'] = $pagenavs;
$result['posnavs'] = $this->getPosNavs($article->c_id);
$result['title'] = $customer_info->title != "" ? $customer_info->title . '-' . $article->title : $article->title;
$result['keywords'] = $article->keywords != "" ? $article->keywords : $customer_info->keywords;
$result['description'] = $article->introduction != "" ? $article->introduction : $customer_info->description;
$result['article']['title'] = $article->title;
$result['article']['keywords'] = $article->keywords;
$result['article']['description'] = $article->introduction;
$result['article']['viewcount'] = '<em id="article-viewcount">0</em>';
$result['enlarge'] = 0;
$article_type = Articles::leftJoin('classify', 'classify.id', '=', 'article.c_id')->where('article.id', $id)->pluck('article_type');
if ($article_type == 1) {
//新闻内容
$viewname = 'content-news';
} elseif ($article_type == 2) {
//产品内容
$viewname = 'content-product';
$result['enlarge'] = $customer_info->enlarge;
if ($result['enlarge'] && $this->type == 'pc') {
$result['footscript'] .= '<script type="text/javascript" src="http://swap.5067.org/js/img.js"></script>';
}
} else {
//跳转404
}
//关联文章查询
// $pa = new PhpAnalysis();
//
// $pa->SetSource($article->title);
//
// //设置分词属性
// $pa->resultType = 2;
// $pa->differMax = true;
// $pa->StartAnalysis();
//
// //获取你想要的结果
// $keywords = $pa->GetFinallyIndex();
// if (count($keywords)) {
// $relation_where = "";
// foreach ((array) $keywords as $key => $word) {
// $relation_where.="or title like '%$key%' ";
// }
// $relation_where = ltrim($relation_where, 'or');
//.........这里部分代码省略.........
示例2: articlePreview
/**
* 显示文章页
*
* @param int $id 文章id
*/
public function articlePreview($id)
{
$article = Articles::find($id);
$a_moreimg = Moreimg::where('a_id', $id)->get()->toArray();
array_unshift($a_moreimg, array('title' => $article->title, 'img' => $article->img));
$images = array();
if (count($a_moreimg)) {
$i = 0;
foreach ($a_moreimg as $a_img) {
$images[$i]['title'] = $a_img['title'];
$images[$i]['image'] = $this->source_dir . 'l/articles/' . $a_img['img'];
$i++;
}
}
$list_id = Articles::where('c_id', $article->c_id)->where($this->type . '_show', '1')->orderBy('is_top', 'desc')->orderBy('created_at', 'desc')->select('id', 'title', 'img', 'introduction', 'created_at')->lists('id');
foreach ($list_id as $key => $val) {
$article_prev = NULL;
$article_next = NULL;
if ($val == $id) {
if ($key != 0) {
$prev_id = $list_id[$key - 1];
$article_prev = Articles::find($prev_id);
}
if ($key < count($list_id) - 1) {
$next_id = $list_id[$key + 1];
$article_next = Articles::find($next_id);
}
break;
}
}
$result = $this->pagePublic($article->c_id);
foreach ($result['navs'] as $nav) {
if ($nav['current'] == 1) {
$pagenavs = $nav['childmenu'];
break;
} else {
$pagenavs = [];
}
}
$result['pagenavs'] = $pagenavs;
$result['posnavs'] = $this->getPosNavs($article->c_id);
$result['title'] = $article->title;
$result['keywords'] = $article->keywords;
$result['description'] = $article->introduction;
$result['article']['title'] = $article->title;
$result['article']['keywords'] = $article->keywords;
$result['article']['description'] = $article->introduction;
$result['article']['viewcount'] = '<em id="article-viewcount">0</em>';
$article_type = Articles::leftJoin('classify', 'classify.id', '=', 'article.c_id')->where('article.id', $id)->pluck('article_type');
if ($article_type == 1) {
//新闻内容
$viewname = 'content-news';
} elseif ($article_type == 2) {
//产品内容
$viewname = 'content-product';
} else {
//跳转404
}
//关联文章查询
$pa = new PhpAnalysis();
$pa->SetSource($article->title);
//设置分词属性
$pa->resultType = 2;
$pa->differMax = true;
$pa->StartAnalysis();
//获取你想要的结果
$keywords = $pa->GetFinallyIndex();
if (count($keywords)) {
$relation_where = "";
foreach ($keywords as $key => $word) {
$relation_where .= "or title like '%{$key}%' ";
}
$relation_where = ltrim($relation_where, 'or');
$prefix = Config::get('database.connections.mysql.prefix');
$related_data = DB::select("select id,title,img as image,introduction,created_at,c_id from {$prefix}article where cus_id={$this->cus_id} and ({$relation_where})");
$related = array();
if (count($related_data)) {
foreach ($related_data as $val) {
$temp_arr = [];
$temp_arr['title'] = $val->title;
$temp_arr['description'] = $val->introduction;
$temp_arr['image'] = $this->source_dir . 'l/articles/' . $val->image;
if ($this->showtype == 'preview') {
$temp_arr['link'] = $this->domain . '/detail/' . $val->id;
$temp_arr['category']['link'] = $this->domain . '/category/' . $val->id . '.html';
} else {
$temp_arr['link'] = $this->domain . '/detail/' . $val->id . '.html';
$temp_arr['category']['link'] = $this->domain . '/category/' . $val->id . '.html';
}
$temp_arr['pubdate'] = $val->created_at;
$temp_arr['pubtimestamp'] = strtotime($val->created_at);
$a_c_info = Classify::where('id', $val->c_id)->first();
$temp_arr['category']['name'] = $a_c_info->name;
$temp_arr['category']['en_name'] = $a_c_info->en_name;
$temp_arr['category']['icon'] = '<i class="iconfont">' . $a_c_info->icon . '</i>';
//.........这里部分代码省略.........