Guest User

Untitled

a guest
May 22nd, 2018
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. <td>Начало<input type="datetime-local" name="start" placeholder="С какого искать"></td>
  2. <td>Конец <input type="datetime-local" name="stop" placeholder="По какое искать"></td>
  3.  
  4. $sql = "select distinct -1 ID,A.*****,A.IdProcess,A.idGrc,case when B.CodeAbo is null then 1 else case when D.IDUSER is null then 0 else 1 end end UserRegist,A.Trans,A.ContainerName,A.IdDocob,A.InnerId,A.DatePriem,B.CodeAbo,B.NameAbo,B.InnAbo,B.KppAbo,IP_ABO,A.PtypeUnload from (Select h.IP_ABO,h.idAbo,h.Trans,h.ContainerName,h.IdDocob,h.InnerId,h.DatePriem,h.*******,isnull(l.name,'*****') PtypeUnload,h.IdProcess,h.id idGrc from ******** h left join ******* k on h.IdPackage=k.ID left join ******** l on k.PackageType=l.ID where h.IdProcess<>'15') A left join (select Id,CodeAbo,case when PrUl=1 then Name else ltrim(rtrim(isnull(******,'') + ' ' + isnull(*****,'') + ' ' + ISNULL(******,''))) end NameAbo,**** ****,**** ***** from *****) B on A.idAbo=B.Id left join ********* D on B.ID=D.IDABO where substring(A.Trans,1,2) in('01','02','03','04','05','06','07','08','09','10','11','12','13') and A.DatePriem between convert(DateTime,'**21.05.2018 00:00:00**',104) and convert(DateTime,'**21.05.2018 23:59:59**',104)"
Add Comment
Please, Sign In to add comment