public function store()
{
$input = Input::all();
for ($i = 1; $i < 179; $i++) {
$infra = 0;
$rect = 0;
$mult = 0;
if (isset($input['inf_' . $i])) {
$infra = $input['inf_' . $i];
}
if (isset($input['rect_' . $i])) {
$rect = $input['rect_' . $i];
}
if (isset($input['mult_' . $i])) {
$mult = $input['mult_' . $i];
}
$id = $input['id_' . $i];
$anexo = Anexo22::find($id);
$anexo->a22_rectifiable = $rect;
$anexo->a22_fine = $mult;
$anexo->infractions_id = $infra;
$anexo->save();
echo $infra . $mult . $rect;
}
//return redirect()->back();
}
public function index()
{
$data = Infraction::all();
$anexo = Anexo22::all();
$infraccion = Infraction::lists('inf_description', 'id');
return view('infraction.index')->with(["data" => $data, 'anexo' => $anexo, 'infra' => $infraccion]);
}
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 function isValid($data)
{
$tamanio = 0;
$valor = 1;
if ($data['entrada'] == 1) {
$campo = 'pk_referencia';
} else {
$campo = 'folio_ds';
}
$consulta = \DB::connection('users')->table($data['tabla'])->where($campo, $data['referencia'])->get();
if ($consulta != null) {
foreach ($consulta as $query) {
//============================== Validaciones ================================
if ($data['attr_id'] == 4) {
if ($query->{$data}['campos'] == '') {
$valor = 0;
}
}
if ($data['attr_id'] == 2) {
$campo = explode(",", $data['campos']);
if ($data['attr_id'] == 2) {
for ($i = 0; $i < count($campo); $i++) {
$tamanio += strlen($query->{$campo}[$i]);
}
if ($tamanio != $data['data_val']) {
$valor = 0;
}
} else {
$campos = $campo[0];
}
}
if ($data['attr_id'] == 6 || $data['attr_id'] == 5) {
$catalogo = explode("|", $data['data_val']);
$tablaval = $catalogo[0];
$campoval = $catalogo[1];
Session::put('tablacat', $tablaval);
if ($data['attr_id'] == 5) {
$formula = explode(',', $catalogo[1]);
$campobd = $formula[0];
$operador = $formula[1];
$result = $formula[2];
$camposwh = Anexo22::find($result)->relationships->where('origin_id', $data['entrada'])->first();
$campowh = explode(',', $camposwh->field);
$val_campo = Catalog::where($catalogo[2], 'LIKE', '%' . $query->{$data}['campos'] . '%')->where($campobd, $query->{$campowh}[0])->count();
}
if ($data['attr_id'] == 6) {
$campo = explode(',', $data['campos']);
$campocat = $campo[0];
$val_campo = Catalog::where($campoval, $query->{$campocat})->count();
}
if ($val_campo == 0) {
$valor = 0;
}
}
if ($data['attr_id'] == 3) {
$camposval = explode(",", $data['data_val']);
$valanexo = Anexo22::find($camposval[0]);
$campanx = $valanexo->a22_field;
if ($query->{$campanx} != $camposval[1]) {
$valor = 0;
}
}
if ($data['attr_id'] == 8) {
//$camposval = explode(",", $data['campos']);
$valores = explode("|", $data['data_val']);
$identif = $valores[1];
$docum = $valores[0];
$documentos = \DB::connection('users')->table('opauimg')->where('pk_referencia', $data['referencia'])->where('imgtipodoc', $docum)->count();
if ($query->{$data}['campos'] != $identif && $documentos == 0) {
$valor = 0;
}
}
}
}
return $valor;
}
public function show($anx)
{
$anexo = Anexo22::where('id', $anx)->first();
$validaciones = $anexo->validations()->where('anexo22_id', $anx)->get();
return $validaciones;
}
public function show($anx)
{
$anexo = Anexo22::where('id', $anx)->first();
$validaciones = $anexo->validations()->join('aud_attributes', 'attribute_id', '=', 'aud_attributes.id')->select('val_data', 'attribute_id', 'name', 'aud_validations.id as id')->where('anexo22_id', $anx)->get();
return $validaciones;
}
