Example #1
0
 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);
     }
 }
Example #3
0
 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());
 }
Example #4
0
 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);
 }
Example #11
0
 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' => '删除成功'));
 }
Example #12
0
 public function deleteAdmin(\Request $req, \Response $res)
 {
     $admin = new \Model\Admin($req->param("id"));
     $admin->deleteFromDb();
     $res->Json(array("message" => "Admin successfully deleted"));
 }
Example #13
0
 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);
 }
Example #17
0
 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);
 }
Example #20
0
 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);
 }