Dim Cursor As Cursor
Cursor = Main.SQL1.ExecQuery($"Select id, usuario, data, Cliente,
Unidade, ciclo, area, subarea, formulario, peca, grupo, pergunta, resposta, foto
FROM inspecao
where coalesce(status, '') <> 'enviado' order by id"$)
Dim data As String = "?"
For i = 0 To Cursor.RowCount - 1
Cursor.Position = i
For y = 0 To Cursor.ColumnCount -1
Dim coluna As String = Cursor.GetColumnName(y)
data = data & coluna & "="
If coluna = "foto" Then
If Cursor.GetString(coluna) <> Null Then
Dim bmp As Bitmap = LoadBitmapResize(File.DirRootExternal, Cursor.GetString(coluna), 100dip, 100dip, True)
Dim ImageBytes() As Byte = func.BitmapToBytes(bmp)
Dim Base64String As String
Base64String = BytesToString(ImageBytes, 0, ImageBytes.Length, "UTF8")
data = data & Base64String & "&"
Else
data = data & "&"
End If
Else
data = data & Cursor.GetString(coluna) & "&"
End If
' Log(data)
Next
Dim jg As HttpJob
jg.Initialize("", Me)
jg.PostString(Main.URLServidor & "/app/receber.php", $"data=${data}"$)
Wait For (jg) JobDone (jg As HttpJob)
If jg.Success Then
Log(jg.GetString)
Else
func.msg("erro 132 " & jg.ErrorMessage)
End If
jg.Release
Next