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