public static function recover($sid, $tid) { $tokenRecuperable = DB::Table('tokens_' . $sid)->where('tid', $tid)->first(); $attRecargables = LlamadasController::getAttRecargables($sid); $selectSQL = ''; $updatedValues = array(); $updatedValues['completed'] = 'N'; if (sizeof($attRecargables) != 0) { $firstElement = true; foreach ($attRecargables as $key => $value) { if (!$firstElement) { $selectSQL .= ','; } else { $firstElement = false; } $selectSQL .= '`' . $value . '` as ' . $key; } $sqlUltimosDatosRegistrados = " select " . $selectSQL . " from ( select token,max(id) as maxid from survey_" . $sid . " group by token) as maxTable " . " inner join survey_" . $sid . " as sv on maxTable.token=sv.token and maxTable.maxId = sv.id " . " where maxTable.token='" . $tokenRecuperable->token . "'"; $rsUpdatedValues = DB::select($sqlUltimosDatosRegistrados)[0]; var_dump($rsUpdatedValues); foreach ($attRecargables as $key => $value) { $updatedValues[$key] = $rsUpdatedValues->{$key}; } } //Actualizo el token recibido DB::table('tokens_' . $sid)->where('tid', $tid)->update($updatedValues); }