public function isLoggedIn(\Request $req, \Response $res) { if ($_SESSION['admin_id']) { $res->Json(array("flash" => "logged in")); } else { $res->Json(array("flash" => "not logged in"), "401"); } }
public function getGrafico2() { if (Request::ajax()) { $resultados = Proyecto::getResultados2(); return Response::Json($resultados); } }
public function createItem(\Request $req, \Response $res) { $item = new \Model\Item(); $item->customer_id = $req->customer_id; $item->name = $req->name; $item->product_id = $req->product_id; $item->next_bill_date = $req->next_bill_date; $item->write(); $res->Json($item->toArray()); }
public function getProducts(\Request $req, \Response $res) { $product = new \Model\Product(); $products = $product->fetchAll(); $result = array(); foreach ($products as $product) { $result[] = $product->toArray(); } $res->Json($result); }
public function getLinks(\Request $req, \Response $res) { $links = array(array("name" => "Admins", "url" => \Router::controllerUrl("Controller\\Admin::getAdmins")), array("name" => "Customers", "url" => \Router::controllerUrl("Controller\\Customer::getCustomers")), array("name" => "Products", "url" => \Router::controllerUrl("Controller\\Product::listProduct"))); $res->Json($links); }
public function getAll() { $servicios = VistaServicioFuneral::select('id', 'nombre', 'precio_servicio', 'monto_comisionable', 'porcentaje_comision', DB::raw('CONCAT(nombre, " ","$", (round(precio_servicio * 1.16))) AS nombre_display'))->get(); return Response::Json($servicios); }
public function getAll() { $cliente = VistaClientes::select('id', DB::raw("CONCAT(nombres, ' ', apellido_paterno, ' ', apellido_materno) as nombre"))->get(); return Response::Json($cliente); }
public function getAll() { $asesor = Asesor::select('asesor.id as id_asesor', DB::raw("CONCAT(persona.nombres, ' ', persona.apellido_paterno, ' ', persona.apellido_materno) as Asesor"))->leftjoin('persona', 'asesor.persona_id', '=', 'persona.id')->get(); return Response::Json($asesor); }
public function getAll() { $productos_recubrimientos = VistaRecubrimiento::select('id', 'nombre', 'precio_recubrimiento', 'porcentaje_comision', DB::raw('CONCAT(nombre, " ","$", (round(precio_recubrimiento * 1.16))) AS nombre_display'))->get(); return Response::Json($productos_recubrimientos); }
public function getAll() { $comisiones = VistaComision::all(); return Response::Json($comisiones); }
public function dreply() { if (!Sentry::check()) { return Response::json(array('errCode' => 10, 'message' => '请登录')); } $user = Sentry::getUser(); $reply_id = Input::get('reply_id'); $reply = ArticleJoinCom::find($reply_id); if (!isset($reply)) { return Response::Json(array('errCode' => 2, 'message' => '[reply_id对应的回复不存在]此回复不存在!')); } if ($reply->sender_id != $user->id) { return Response::Json(array('errCode' => 3, 'message' => '[权限不够]不可删除别人的回复!')); } if (!$reply->delete()) { return Response::json(array('errCode' => 4, 'message' => '[数据库错误]删除失败')); } return Response::json(array('errCode' => 0, 'message' => '删除成功')); }
public function deleteAdmin(\Request $req, \Response $res) { $admin = new \Model\Admin($req->param("id")); $admin->deleteFromDb(); $res->Json(array("message" => "Admin successfully deleted")); }
public function getAll() { $extras = VistaExtra::select('id', 'nombre', 'precio_extra', 'porcentaje_comision', DB::raw('CONCAT(nombre, " ","$", (round(precio_extra * 1.16))) AS nombre_display'))->get(); return Response::Json($extras); }
function postNestable() { $listMenus = Input::get('menu'); $order = 0; if (!empty($listMenus)) { foreach ($listMenus as $id => $parent) { $order++; $menu = Menus::where('id', $id)->update(array('parent_id' => intval($parent), 'order' => $order)); } } return Response::Json(TRUE); }
public function getAll() { $construcciones = VistaProductoConstruccion::select('id', 'nombre', 'precio_construccion', 'porcentaje_comision', DB::raw('CONCAT(nombre, " ","$", (round(precio_construccion * 1.16))) AS nombre_display'))->get(); return Response::Json($construcciones); }
public function listUserProfiles() { $per_page = Input::get('per_page', 10000000); $s_id = Input::get('s_id', 0); $s_name = Input::get('s_name', ''); $name = Input::get('name', ''); $has_id_img = Input::get('has_id_img', -1); $has_stu_img = Input::get('has_stu_img', -1); try { $query = DB::table('users')->select('users.u_id AS id', 'users.u_mobile', 'users.u_name', 'users.u_nickname', 'users.u_status', 'users.u_remark', 'users.u_is_verified as is_verified', 'users.u_head_img', 'dic_schools.t_name', 'tmp_user_profile_bases.u_status AS base_status', 'tmp_user_profile_bases.u_id_imgs', 'tmp_user_profile_bases.u_student_imgs', 'tmp_user_profile_bankcards.b_status AS bank_status', 'tmp_user_profile_bases.u_is_id_verified AS id_verified', 'tmp_user_profile_bases.u_is_student_verified AS stu_verified', 'clubs.c_status AS club_status')->leftJoin('tmp_user_profile_bases', function ($q) { $q->on('users.u_id', '=', 'tmp_user_profile_bases.u_id'); })->leftJoin('tmp_user_profile_bankcards', function ($q) { $q->on('users.u_id', '=', 'tmp_user_profile_bankcards.u_id'); })->leftJoin('dic_schools', function ($q) { $q->on('dic_schools.t_id', '=', 'users.u_school_id'); })->leftJoin('clubs', function ($q) { $q->on('clubs.u_id', '=', 'users.u_id'); }); if ($s_id) { $query = $query->where('users.u_school_id', '=', $s_id); } if ($s_name) { $query = $query->where('dic_schools.t_name', 'LIKE', '%' . $s_name . '%'); } if ($name) { $query = $query->where(function ($q) use($name) { $q->where('users.u_name', 'LIKE', '%' . $name . '%')->orWhere('users.u_nickname', 'LIKE', '%' . $name . '%')->orWhere('users.u_mobile', 'LIKE', '%' . $name . '%'); }); } if ($has_id_img == 1) { $query = $query->whereNotNull('tmp_user_profile_bases.u_id_imgs')->where('tmp_user_profile_bases.u_id_imgs', '<>', ''); } elseif ($has_id_img == 0) { $query = $query->whereNull('tmp_user_profile_bases.u_id_imgs')->where('tmp_user_profile_bases.u_id_imgs', '=', ''); } if ($has_stu_img == 1) { $query = $query->whereNotNull('tmp_user_profile_bases.u_student_imgs')->where('tmp_user_profile_bases.u_student_imgs', '<>', ''); } elseif ($has_stu_img == 0) { $query = $query->whereNull('tmp_user_profile_bases.u_student_imgs')->where('tmp_user_profile_bases.u_student_imgs', '=', ''); } $list = $query->paginate($per_page); $array = $list->toArray(); $data['rows'] = []; foreach ($array['data'] as $key => $userProfile) { if ($userProfile->u_id_imgs) { $userProfile->has_id_img = 1; } else { $userProfile->has_id_img = 0; } if ($userProfile->u_student_imgs) { $userProfile->has_student_img = 1; } else { $userProfile->has_student_img = 0; } unset($userProfile->u_id_imgs); unset($userProfile->u_student_imgs); $data['rows'][] = $userProfile; } $data['total'] = $list->getTotal(); $re = Tools::reTrue('获取用户信息成功', $data, $list); } catch (Exception $e) { $re = Tools::reFalse($e->getCode(), '获取用户信息失败:' . $e->getMessage()); } return Response::Json($re); }
public function getqrcode() { $barcode = Input::get('barcode'); $data = $this->qrcode($barcode); if ($data) { $json_result = ['err' => 0, 'msg' => '获取成功', 'data' => $data]; } else { $json_result = ['err' => 1001, 'msg' => '不存在手机站', 'data' => []]; } return Response::Json($json_result); }
public function getSectoresnicho() { $sectores_nicho = Sector::select('sector.id as sector_id', 'recinto.id as recinto_id', DB::raw('CONCAT("Nicho ",sector.nombre, " ", "Recinto ", recinto.nombre) AS product_name'))->join('recinto', 'sector.id', '=', 'recinto.sector_id')->get(); return Response::Json($sectores_nicho); }
public function summary() { $start = Input::get("start"); $end = Input::get("end"); $frequency = Input::get("frequency"); $member = Member::find(Input::get("member")); $plan = new Plan(); $result = $plan->Subcription($frequency, $start, $end, $member->due); return Response::Json($result); }
public function deleteCustomer(\Request $req, \Response $res) { $customer = new \Model\Customer($req->param("id")); $customer->deleteFromDb(); $res->Json(array("message" => "customer deleted")); }
public function getSectoresall() { $sectores = Sector::all(); return Response::Json($sectores); }