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