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