/** * Retorna uma instancia da model * * @author Hugo Ferreira da Silva * @link http://www.hufersil.com.br/lumine * @return ClientesModel */ public static function getInstance() { if (!self::$instance) { self::$instance = new ClientesModel(); } return self::$instance; }
public function postPedidosenviados() { $dados = Input::all(); if (isset($dados["columns"])) { $columns = $dados["columns"]; } if (isset($dados["order"])) { $order = $dados["order"]; $order = $order[0]; $orderIndex = intval($order["column"]); } if (isset($dados["search"])) { $search = $dados["search"]; } $limit = intval($dados["length"]); $start = intval($dados["start"]); $recordsTotal = count(PedidosModel::get()); if ($limit == -1) { $limit = $recordsTotal; } $pedidos = DB::table("pedidos")->leftJoin("clientes", "clientes.cod", "=", "pedidos.cod_cliente")->select(DB::raw('SQL_CALC_FOUND_ROWS *'))->where("pedidos.cod", "=", $search["value"])->orWhere(function ($query) use($search) { $exists = PedidosModel::where("data", "LIKE", "%" . $search["value"] . "%")->get(); if (count($exists) > 0) { $query->where("pedidos.data", "LIKE", "%" . $search["value"] . "%"); return true; } $exists = ClientesModel::where("nome", "LIKE", "%" . $search["value"] . "%")->get(); if (count($exists) > 0) { $query->where("clientes.nome", "LIKE", "%" . $search["value"] . "%"); return true; } $exists = PedidosModel::where("valor_total", "<=", $search["value"])->get(); if (count($exists) > 0) { $query->where("pedidos.valor_total", "<=", $search["value"]); return true; } })->orderBy("pedidos.cod", "desc")->take($limit)->skip($start)->get(); $recordsFiltered = DB::select(DB::raw("SELECT FOUND_ROWS() AS total;")); $recordsFiltered = $recordsFiltered[0]; $recordsFiltered = intval($recordsFiltered->total); $pedidos = DB::table("pedidos")->leftJoin("clientes", "clientes.cod", "=", "pedidos.cod_cliente")->where("pedidos.cod", "=", $search["value"])->orWhere(function ($query) use($search) { $exists = PedidosModel::where("data", "LIKE", "%" . $search["value"] . "%")->get(); if (count($exists) > 0) { $query->where("pedidos.data", "LIKE", "%" . $search["value"] . "%"); return true; } $exists = ClientesModel::where("nome", "LIKE", "%" . $search["value"] . "%")->get(); if (count($exists) > 0) { $query->where("clientes.nome", "LIKE", "%" . $search["value"] . "%"); return true; } $exists = PedidosModel::where("valor_total", "<=", $search["value"])->get(); if (count($exists) > 0) { $query->where("pedidos.valor_total", "<=", $search["value"]); return true; } })->select("pedidos.cod", "pedidos.nro_mesa", "clientes.nome", "pedidos.data", "pedidos.horario", "pedidos.status", "pedidos.origem", "pedidos.valor_total")->orderBy("pedidos.cod", "desc")->take($limit)->skip($start)->get(); $json = []; $json["draw"] = intval($dados["draw"]); $json["recordsTotal"] = $recordsTotal; $json["recordsFiltered"] = $recordsFiltered; $json["aaData"] = array(); foreach ($pedidos as $key => $value) { $value = (array) $value; switch (intval($value["status"])) { case 1: $value["status"] = "<span cod_status=" . intval($value["status"]) . ">" . Lang::get('geral.status_enviado') . "</span>"; break; case 2: $value["status"] = "<span class='text-primary' cod_status=" . intval($value["status"]) . ">" . Lang::get('geral.status_aceito') . "</span>"; break; case 3: $value["status"] = "<span class='text-danger' cod_status=" . intval($value["status"]) . ">" . Lang::get('geral.status_rejeitado') . "</span>"; break; case 4: $value["status"] = "<span class='text-primary' cod_status=" . intval($value["status"]) . ">" . Lang::get('geral.status_pronto') . "</span>"; break; case 5: $value["status"] = "<span class='text-info' cod_status=" . intval($value["status"]) . ">" . Lang::get('geral.status_pago') . "</span>"; break; case 6: $value["status"] = "<span class='text-warning' cod_status=" . intval($value["status"]) . ">" . Lang::get('geral.status_cancelado') . "</span>"; break; } if (intval($value["origem"]) == 1) { $value["origem"] = '<i class="fa fa-cloud"></i> ' . Lang::get('geral.org_web'); } else { $value["origem"] = '<i class="fa fa-mobile"></i> ' . Lang::get('geral.org_app'); } $value["valor_total"] = Lang::get('geral.rs') . " " . number_format((double) $value["valor_total"], 2, '.', ''); array_push($json["aaData"], array_values($value)); } return json_encode($json); }
public function getRecuperar() { $email = Input::get("email"); $exists = ClientesModel::where("email", $email)->get(); $response = array(); if (count($exists) == 0) { $response['error'] = true; $response['message'] = Lang::get('geral.msg_email_nao_localizado'); return json_encode($response); } if (isset($exists[0])) { $exists = $exists[0]; } $dados = array(); $dados["senha"] = sha1("123"); $dados["login"] = "******" . $exists->cod; $result = DB::table('clientes')->where('cod', $exists->cod)->update($dados); if ($result) { $data = ['nome' => $exists->nome, 'codigo' => $exists->cod]; /* ENVIA O EMAIL */ Mail::send('emails.recuperacao', $data, function ($m) use($email) { $m->to($email)->subject("Recuperação de Login e Senha "); }); $response['error'] = false; $response['message'] = Lang::get('geral.msg_email_recuperacao'); } else { $response['error'] = true; $response['message'] = Lang::get('geral.msg_erro'); } return json_encode($response); }
public function getListar() { $clientes = ClientesModel::orderBy("nome", "asc")->get(); return json_encode($clientes); }