public function run() { $class_id = intval(Input::get('class_id', 0)); if (empty($class_id)) { return '相册类别错误'; } $class = TemplateClassORM::whereId($class_id)->whereStatus(BaseORM::ENABLE)->first(); if (empty($class)) { return '相册分类未找到'; } $sql = "SELECT t.*, ts.source FROM template as t LEFT JOIN template_source as ts ON ts.template_id = t.id WHERE t.class={$class_id} AND t.status=" . BaseORM::ENABLE . " AND ts.is_front = " . BaseORM::ENABLE . " ORDER BY t.sort DESC"; $results = DB::select(DB::raw($sql)); return TemplateModel::listData($results); }
public function show() { $id = (int) Input::get('id', 0); $template = TemplateORM::find($id); if ($id > 0 && empty($template)) { Session::flash('error', '模版未找到'); return Redirect::route('templateLists'); } $sources = TemplateSourceORM::whereTemplateId($id)->get(); $classes = TemplateClassORM::all(); array_ch_key('id', $classes); $format_classes = array_ch_key('id', $classes); return View::make('template.show', ['row' => $template, 'id' => $id, 'sources' => $sources, 'classes' => $format_classes]); }
public function show() { $id = (int) Input::get('id', 0); $album = AlbumORM::find($id); if ($id > 0 && empty($album)) { Session::flash('error', '相册未找到'); return Redirect::route('albumLists'); } $sources = AlbumSourceORM::whereAlbumId($id)->get(); $classes = TemplateClassORM::all(); array_ch_key('id', $classes); $format_classes = array_ch_key('id', $classes); $user = UserORM::find($album->user_id); return View::make('album.show', ['row' => $album, 'user' => $user, 'source' => $sources, 'classes' => $format_classes]); }
public function show() { $id = (int) Input::get('id', 0); $order = OrderORM::find($id); if ($id > 0 && empty($order)) { Session::flash('error', '订单未找到'); return Redirect::route('orderLists'); } $user = UserORM::whereId($order->user_id)->first(); $album = AlbumORM::whereId($order->album_id)->first(); $template = TemplateORM::whereId($album->template_id)->first(); $template_class = TemplateClassORM::whereId($template->class)->first(); $source = AlbumSourceORM::whereAlbumId($album->id)->get(); return View::make('order.show', ['row' => $order, 'user' => $user, 'album' => $album, 'template' => $template, 'class' => $template_class, 'source' => $source, 'id' => $id]); }
public function save() { $id = (int) Input::get('id', 0); $params = Input::all(); unset($params['id']); $params['sort'] = intval(Input::get('sort', 0)); if (empty($params['name'])) { $this->_fail('名称必填'); } try { TemplateClassORM::edit($id, $params); $this->_succ('保存成功', URL::route('templateClasses')); } catch (Exception $e) { $this->_fail('保存失败'); } }
public function run() { $user_id = Input::get('user_id', 0); $class_id = Input::get('class_id', 0); $template_id = Input::get('template_id', 0); $user = UserORM::whereId($user_id)->whereStatus(BaseORM::ENABLE)->first(); if (empty($user)) { return '用户未找到'; } $class = TemplateClassORM::whereId($class_id)->whereStatus(BaseORM::ENABLE)->first(); if (empty($class)) { return '相册分类未找到'; } $template = TemplateORM::whereId($template_id)->whereClass($class_id)->whereStatus(BaseORM::ENABLE)->first(); if (empty($template)) { return '模版未找到'; } $r = AlbumORM::edit(0, ['user_id' => $user_id, 'class' => $class_id, 'template_id' => $template_id]); return $r[1]; }
public function run() { $image_id = Input::get('image_id', 0); $image = TemplateSourceORM::whereId($image_id)->first(); if (empty($image)) { return '模板图片不存在'; } $image->source = Config::get('app.image_host') . $image->source; $template_id = $image->template_id; $template = TemplateORM::whereId($template_id)->whereStatus(BaseORM::ENABLE)->first(); if (empty($template)) { return '模板不存在'; } $class = $template->class; $class = TemplateClassORM::whereId($class)->whereStatus(BaseORM::ENABLE)->first(); if (empty($class)) { return '相册分类不存在'; } $class->front = Config::get('app.image_host') . $class->front; return ['image' => $image, 'template' => $template, 'class' => $class]; }
public function run() { $classes = TemplateClassORM::whereStatus(BaseORM::ENABLE)->orderBy('sort', 'DESC')->get(); return TemplateClassModel::listData($classes); }