public function destroy($id)
{
$validacion = Validation::find($id);
$anexo = $validacion->anexo22_id;
$result = Validation::destroy($id);
return Response::json($anexo);
}
public function show($referen)
{
$empresa = Session::get('empresa');
Checklist::where('chk_referen', $referen)->delete();
$documentos = \DB::connection('master')->table('mdb_tipodocum')->select('doc_clave', 'doc_nombre')->get();
foreach ($documentos as $doc) {
$result = Result::where('res_referen', $referen)->first();
if (!empty($result)) {
$validacion = Validation::where('attribute_id', 9)->where('id', $result->validations_id)->whereRaw('SUBSTRING_INDEX(val_data, "|", 1) = ' . $doc->doc_clave)->count();
if ($validacion > 0) {
$imagen = \DB::connection('users')->table('opauimg')->where('pk_referencia', $referen)->where('imgtipodoc', $doc->doc_clave)->count();
if ($imagen > 0) {
$check = 1;
} else {
$check = 0;
}
} else {
$check = 2;
}
} else {
$check = 0;
}
$data = ["chk_referen" => $referen, "chk_document" => $doc->doc_nombre, "chk_status" => $check, "chk_company" => $empresa];
Checklist::create($data);
}
$result = Checklist::where('chk_company', $empresa)->get();
return view('list_document')->with(['document' => $result, 'referen' => $referen]);
}
public function checkPedimento($referen, $valorOrigen)
{
if ($valorOrigen['entrada'] == 1) {
$pk_referencia = $referen->pk_referencia;
$tabla = 'optr02';
$camposel1 = 'pk_factura';
$camposel2 = 'pk_cove';
$campow = 'pk_referencia';
} else {
$pk_referencia = $referen->folio_ds;
$tabla = 'ds505';
$camposel1 = 'NumeroFactura';
$camposel2 = 'NumeroFactura';
$campow = 'folio_ds';
}
//Recorrer campos del Anexo 22
$anexo = Anexo22::all();
foreach ($anexo as $anx) {
//Checar validaciones por campo
foreach ($anx->validations as $val) {
$valid = $val->id;
$camposbd = $anx->relationships->where('origin_id', $valorOrigen['entrada'])->first();
$data = ["tabla" => $camposbd->table, "campos" => $camposbd->field, "attr_id" => $val->attribute_id, "data_val" => $val->val_data, "anx_id" => $anx->id, "entrada" => $valorOrigen['entrada'], "referencia" => $pk_referencia];
$validacion = new Validation();
$valor = $validacion->isValid($data);
if ($valor == 0) {
if ($val->attribute_id == 9) {
$docum = 1;
} else {
$docum = 0;
}
$datos = ["res_referen" => $pk_referencia, "validations_id" => $valid, "res_document" => $docum, "res_company" => Session::get('empresa'), "res_user" => Session::get('usuario')];
$totalres = Result::where('res_referen', $pk_referencia)->where('validations_id', $valid)->count();
if ($totalres == 0) {
Result::create($datos);
}
}
}
}
$factura = \DB::connection('users')->table($tabla)->where($campow, $pk_referencia)->first();
$cove = $this->checkCove($factura, $camposel1, $camposel2, $pk_referencia);
echo $cove;
}
public static function insertDocument($request)
{
$result = Result::find($request->results_id);
$result->res_status = 1;
$result->save();
$validacion = Validation::find($result->validations_id);
$data = explode('|', $validacion->val_data);
$documento = \Input::file('document');
$nombre = $result->res_referen . '_' . $data[0];
$dir = '../../public_html/clientes/ftp/' . Session::get('empresa') . '/pdf/';
if (null === $documento) {
$documento->move($dir, $nombre);
}
$nombredoc = \DB::connection('master')->table('mdb_tipodocum')->where('doc_clave', $data[0])->first();
\DB::connection('users')->table('opauimg')->insert(['pk_referencia' => $result->res_referen, 'imgNameFile' => $nombre, 'strImageName' => $nombredoc->doc_nombre, 'imgtipo' => 'application/pdf', 'imgtipodoc' => $data[0]]);
}
<?php
namespace App\Modules\mod_booking;
use App\Validation;
use App\Booking;
use App\Rooms;
$fields = Validation::NotEmpty($_POST);
if ($fields && isset($_POST['submit'])) {
$fields_array = Validation::Filter($fields);
if ($fields_array) {
Booking::Insert($fields_array);
header("Location: index.php?pid=3");
}
}
?>
<div class="wrapper">
<div id="form_container">
<form id="bookForm" method="post" action="" class="validate">
<div class="form_description">
<h2>Hotel Reservation</h2>
</div><!-- END of Book_Form -->
<hr>
<div class="form_element">
<label class="labels" for="name">Firstname: </label>
<input id="firstname" name="firstname" type="text" maxlength="255"
value="" title ="Firstname required" />
</div>
<div class="form_element">
public function action_message()
{
if (Users::login()) {
$user = Users::factory();
$valid = Validation::factory($_POST);
$valid->rule('fio', 'alpha', 0)->rule('phone', 'digit', 0);
if ($valid->check()) {
$this->header('Content-type', 'application/json')->body(json_encode(array('error' => !$user->message())));
} else {
$this->header('Content-type', 'application/json')->body(json_encode(array('error' => true, 'message' => 'data')));
}
} else {
throw new HTTP_Exception(401);
}
}