/**
* 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);
}
