xdmy/doc/sql/ps.sql

select * from bigcontract bc where providerId =2795 and pastureId =554

select sqlstr,params from apisql where sqlname ='getPartListByProvider';
select sqlstr,params from apisql where sqlname ='providerPactListV2';
select sqlstr,params from apisql where sqlname ='getpartsSync';
select sqlstr,params from apisql where sqlname ='syncEASParts';
select sqlstr,params from apisql where sqlname ='getBigcontractPId';

show create table dictlist;

select * from  pasture_bigcontract   where  pasture_id = 554;
select * from  pasture_bigcontract   where  pasture_id = 554 and bigcontract_id =546009;

select * from bigcontract  where contractCode like 'BJ0022010002%';
select * from contract where  partCode ='04.04.18.06.000225'

SELECT
5 typeIn,
id billCode,
partCode,
NAME partName,
specification,
DATE_FORMAT(createTime,'%Y-%m-%d') createTime,
msg failReason,
id
FROM parts
WHERE issync = 0 and statue = 1

{"typeIn":"5","billCode":"480277"}




SELECT d.VALUE,p.unit FROM dictlist d 
right join parts p on d.label =p.unit
 WHERE pid = 44 
 and not exists 
 (select unit from  parts p where  p.issync = 0 and p.statue = 1)



 select unit from  parts p 
 where  p.issync = 0 and p.statue = 1
 and not exists 
(SELECT d.VALUE FROM dictlist d where  d.label =p.unit and  pid = 44 )

 

    and p.partCode ='04.03.05.07.003229'

select * from dictlist where pid = 44  and  label ='米'

select trim('' from partcode) from parts where partCode ='04.04.18.06.000225';

update parts set unit =trim( CHAR(13),trim(CHAR(10) from unit));
update parts set unit =trim(CHAR(10) from unit);
update parts set unit =trim(CHAR(13) from unit);


select distinct  failReason from  parts p where  p.issync = 0 and p.statue = 1;
select * from  parts p where  p.issync = 0 and p.statue = 1 and partcode='04.04.17.03';
select *  from pasture where name='塞北五牧';
select * from bigcontract where id =547286;
select * from pasture_bigcontract where bigcontract_id =547286 and pasture_id =46;


select * from department where name ='现代牧业'   
select * from department where parentid =413;