public function getIndex() { $gallery = \WintnessGallery::where('status', '=', '1')->orderBy('sort', 'desc')->orderBy('updated_at', 'desc')->get(array('title', 'link', 'target', 'imageURL')); if (empty($gallery)) { $gallery = array(); } // 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; $list = $servicesFaqs[$item->type]; if ($parent == 'N') { if (!isset($list[$key])) { $list[$key] = array('id' => $key, 'title' => $item->title, 'subItems' => array()); } } else { $list[$parent]['subItems'][] = array('id' => $key, 'title' => $item->title); } $servicesFaqs[$item->type] = $list; } return \View::make('aesthetics.wintness.view_index', array('bodyId' => 'case', 'gallery' => &$gallery, 'servicesFaqs' => &$servicesFaqs)); }
public function postUpdateSort($type) { try { if (!isset($_POST) || !isset($_POST['id']) || !isset($_POST['sort'])) { throw new Exception('Error request [10]'); } $id = (int) Arr::get($_POST, 'id'); $sort = (int) Arr::get($_POST, 'sort'); $isUpdatedTime = Arr::get($_POST, 'isUpdatedTime', false); $lastUpdatedId = Arr::get($_POST, 'lastUpdatedId', false); $model = $type == 'gallery' ? WintnessGallery::find($id) : Wintness::find($id); if (empty($model)) { throw new Exception("Error request [11]"); } $model->sort = $sort; if (!$model->save()) { throw new Exception("更新排序失敗,請通知工程師"); } if ($isUpdatedTime) { $orm = $type == 'gallery' ? 'WintnessGallery' : 'Wintness'; $cmd = $orm::where('id', '<>', $id)->where('sort', '=', $sort)->where('id', '>=', $lastUpdatedId)->orderBy('sort', 'desc')->orderBy('updated_at', 'desc'); $items = $cmd->get(); if (sizeof($items) > 0) { $t = time(); foreach ($items as $key => $item) { $t = $t + $key; $item->updated_at = $t; $item->save(); } } } return Response::json(array('status' => 'ok', 'message' => '更新排序完成')); } catch (Exception $e) { return Response::json(array('status' => 'error', 'message' => $e->getMessage())); } }