public function getFeira($id) { $dados = \DB::connection('mysql')->select(\DB::raw("SELECT *, date_format(data, '%d-%m-%Y %H:%i') as dataBR FROM feira WHERE id={$id}"))[0]; // $function = new Functions(); // $dados->data = $function->convertDataToBR("2016-01-02"); return $dados; }
public function getQuery($r) { $q = $r->toSql(); $rGet = $r->get(); $arr = $r->getBindings(); $pdo = \DB::connection()->getPdo(); foreach ($arr as $val) { //echo $pdo->quote($val)."|<br>"; preg_match('~= \?~', '= ' . $pdo->quote($val), $arr);printR($arr); $q = preg_replace('~(<=|>=|=|<|!=) \\?~', '= ' . $pdo->quote($val), $q, 1); } return $q; }
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]]); }
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; }