public function getArticle($id = 0)
{
try {
if (empty($id)) {
throw new \Exception("Error request [10]");
}
$model = \Wintness::where('status', '=', '1')->find($id);
if (empty($model)) {
throw new \Exception('Error request [11]');
}
$list = array('cover' => array('fieldName' => 'cover', 'items' => array()), 'before' => array('fieldName' => 'img_before', 'items' => array()), 'after' => array('fieldName' => 'img_after', 'items' => array()), 'gallery' => array('fieldName' => 'gallery', 'items' => array()));
foreach ($list as $key => $val) {
$bool = $key == 'gallery' || $key == 'tabs' ? false : true;
$list[$key]['items'] = json_decode($model->{$val}['fieldName'], $bool);
}
$labels = array();
$rows = \WintnessLabels::where('wid', '=', $model->id)->lists('label_id');
if (!empty($rows)) {
$labels = $rows;
}
$labelList = array('service' => array(), 'faq' => array());
$rows = \ServiceFaq::where('status', '=', 'Y')->orderBy('_parent', 'desc')->orderBy('sort', 'desc')->orderBy('updated_at', 'desc')->findMany($labels, array('id', 'title', 'type'));
if (!empty($rows)) {
foreach ($rows as $row) {
$labelList[$row->type][] = array('id' => $row->id, 'title' => $row->title);
}
}
// find prev and next
$prev = \Wintness::where('status', '=', '1')->where('sort', '>=', $model->sort)->where('updated_at', '>', $model->updated_at)->first(array('id', 'title'));
$next = \Wintness::where('status', '=', '1')->where('sort', '<=', $model->sort)->where('updated_at', '<', $model->updated_at)->first(array('id', 'title'));
// read service
$servicefaq = \ServiceFaq::where('status', '=', 'Y')->orderBy('type', 'asc')->orderBy('_parent', 'desc')->orderBy('sort', 'desc')->orderBy('updated_at', 'desc')->get(array('id', 'title', '_parent', 'type'));
$servicesFaqs = array('service' => array(), 'faq' => array());
foreach ($servicefaq as $item) {
$key = $item->id;
$parent = $item->_parent;
$items = $servicesFaqs[$item->type];
if ($parent == 'N') {
if (!isset($items[$key])) {
$items[$key] = array('id' => $key, 'title' => $item->title, 'subItems' => array());
}
} else {
$items[$parent]['subItems'][] = array('id' => $key, 'title' => $item->title);
}
$servicesFaqs[$item->type] = $items;
}
$tabs = \Tabs::where('type', '=', 'wintness')->where('item_id', '=', $model->id)->orderBy('sort', 'desc')->get(array('title', 'content'));
return \View::make('aesthetics.wintness.view_article', array('bodyId' => 'casePost', 'labelList' => &$labelList, 'list' => &$list, 'model' => &$model, 'prev' => $prev, 'next' => $next, 'servicesFaqs' => &$servicesFaqs, 'tabs' => &$tabs));
} catch (Exception $e) {
return \Redirect::route('frontend.wintness.index');
}
}
<?php
$cases = \Wintness::where('status', '=', '1')->where('isInSiderbar', '=', '1')->orderBy('sort', 'desc')->orderBy('updated_at', 'desc')->take(5)->get(array('id', 'title', 'description', 'img_before', 'img_after'));
?>
<div class="setListWrap">
<h3 class="titleRp h3_share">美麗見證</h3>
<ul class="setList shareList">
<?php
if (sizeof($cases) > 0) {
foreach ($cases as $case) {
$before = json_decode($case->img_before, true);
$after = json_decode($case->img_after, true);
?>
<li>
<a href="<?php
echo URL::route('frontend.wintness.article', array('id' => $case->id));
?>
">
<div class="imgWrap"><img src="<?php
echo $before[0]['image'] . '?w=116&h=100&ar=i';
?>
" alt="before" width="116" height="100"/><img src="<?php
echo $after[0]['image'] . '?w=116&h=100&ar=i';
?>
" alt="after" width="116" height="100"/></div>
<h4><?php
echo $case->title;
?>
</h4>
<p><?php
echo \Text::preEllipsize(HTML::entities($case->description), 30);
