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 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;
}
