form1.adoquery_zayavki.disablecontrols;
if form1.adoquery_zayavki.active then id_goto:=form1.ADOQuery_zayavki.fieldbyname('id').asinteger;
form1.adoquery_zayavki.Close;form1.adoquery_zayavki.sql.clear;
form1.adoquery_zayavki.sql.add('select zayavki.*,materials.*,mat_name+'' ''+mat_specif as mat_fullname,object.object_name,(select name from edizm where edizm.id=materials.mat_edizm_id) as edizm_name');
form1.adoquery_zayavki.sql.add(',(select pers_fullname from pers where pers.pers_id=zayavki.pers_id_zak) as pers_zak_name,(select pers_fullname from pers where pers.pers_id=zayavki.pers_id_pokup) as pers_pokup_name');
//if form1.n3.checked then form1.adoquery_zayavki.sql.strings[ 1 ]:=form1.adoquery_zayavki.sql.strings[ 1 ]+',''post_otdel_name''=case when zayavki.perebros=0 then ''f'' when zayavki.perebros=1 then (select object_name from object where object.object_id=zayavki.object_id_perebros) end';
if not form1.n3.checked then form1.adoquery_zayavki.sql.add(',zayavki_go.*,zayavki_go.mat_price*zayavki_go.mat_kolvo_go as mat_sum,(select car_no from cars where cars.id=zayavki_go.cars_id) as car_no,''post_otdel_name''=case'+' when zayavki.perebros=0 then (select post_otdel_name from post_otdel where post_otdel.post_otdel_id=zayavki_go.post_otdel_id) when perebros=1 then (select object_name from object where object.object_id=zayavki.object_id_perebros) end'+' ,(select pers_fullname from pers where pers.pers_id=zayavki_go.pers_id_pokup_go) as pers_pokup_name') else form1.adoquery_zayavki.sql.add('');
form1.adoquery_zayavki.sql.add('');
form1.adoquery_zayavki.sql.add('from zayavki,object,materials');
if not form1.n3.checked then form1.adoquery_zayavki.sql.add(',zayavki_go');
form1.adoquery_zayavki.sql.add('where zayavki.id=zayavki.id');
if not form1.n3.checked then form1.adoquery_zayavki.sql.add('and zayavki.id=zayavki_go.zayavki_id and zayavki_go.mat_id=materials.mat_id') else form1.adoquery_zayavki.sql.add('and zayavki.mat_id=materials.mat_id');
form1.adoquery_zayavki.sql.add('and zayavki.object_id=object.object_id');

if form1.comb_cars_filter.itemindex> 0  then form1.adoquery_zayavki.sql.add('and zayavki_go.cars_id='+inttostr(get_id_from_comb(form1.comb_cars_filter)));

if form1.comb_object_filter.itemindex> 0  then form1.adoquery_zayavki.sql.add('and zayavki.object_id='+inttostr(get_id_from_comb(form1.comb_object_filter)));

if form1.comb_date_dostavki_filter.itemindex> 0  then
        begin
        form1.adoquery_zayavki.sql.add('and date_dostavki='+date_to_sqldate(strtodate(form1.comb_date_dostavki_filter.items.strings[form1.comb_date_dostavki_filter.itemindex]))+'');
        end;

form1.adoquery_zayavki.sql.add('order by 1');

//for id_goto:= 0  to form1.ADOQuery_zayavki.SQL.count- 1  do showmessage(form1.ADOQuery_zayavki.SQL.Strings[id_goto]);

form1.adoquery_zayavki.open;