1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| Query6.Close;
Query6.sql.clear;
Query6.sql.Add('SELECT S.SDate,SUM(P.PCost),SUM(P.PTotals)');
Query6.sql.Add('FROM Products P');
Query6.SQL.Add('JOIN MarketItems MI ON MI.P.PCode=IPCode');
Query6.SQL.Add('JOIN Markets M ON MI.IMCode=M.MCode');
Query6.SQL.Add('JOIN Sales S ON M.MCode=S.SMCode');
Query6.SQL.Add('WHERE (S.SMCode=:x)');
Query6.SQL.Add('GROUP BY SDate');
Query6.Params[0].AsString:=AnsiUpperCase(combobox1.text);
Query6.Open;
t:=0;
While not Query6.Eof and (t<h) do
begin
t:=t+(Query6.Fields[1].AsFloat/Query6.Fields[2].AsFloat);
u:=Query6.Fields[0].AsString;
end;
Query3.Close;
Query3.sql.clear;
Query3.sql.Add('SELECT P.PCode,P.PName,Count(P.PCode) as NbrP,S.SDate,SUM(P.PPrice) AS PV,SUM(P.PCost/P.PTotals) AS CU');
Query3.sql.Add('FROM Products P');
Query3.SQL.Add('JOIN MarketItems MI ON MI.P.PCode=IPCode');
Query3.SQL.Add('JOIN Markets M ON MI.IMCode=M.MCode');
Query3.SQL.Add('JOIN Sales S ON M.MCode=S.SMCode');
Query3.SQL.Add('WHERE (S.SMCode=:x)');
Query3.SQL.Add('GROUP BY P.PCode,P.PName,S.SDate');
Query3.Params[0].AsString:=AnsiUpperCase(combobox1.text);
Query3.Open;
g:=0;
o:=0;
Query3.First;
while not Query3.Eof and (StrToDate(Query3.Fields[3].AsString)<StrToDate(u)) do
begin
m:=m+1;
q:=Query3.fieldbyname('pv').AsFloat-Query3.fieldbyname('cu').AsFloat;
g:=g+q;
StringGrid1.Cells[0,m]:=Query3.Fields[1].AsString;
StringGrid1.Cells[1,m]:=Query3.Fields[2].AsString;
StringGrid1.Cells[2,m]:=floattostr(q);
pc:=Query3.Fields[0].AsString;
o:=o+Query3.Fields[2].AsInteger;
Query3.Next;
end; |
Partager