01/25/2020

--------------------- Visit and Inspection ------------------------

SELECT FROM_UNIXTIME(vi_date,'%m-%d-%Y') vidate, COUNT(vi_date) novis
FROM wisi_gsia.vi_hdr 
WHERE (vi_date>='1564329600' AND vi_date <= '1579881600') AND agency='GSIA'
GROUP BY vi_date;

SELECT contract_id,FROM_UNIXTIME(vi_date,'%m-%d-%Y') vidate, COUNT(contract_id) nocl
FROM wisi_gsia.vi_hdr 
WHERE (vi_date>='1564329600' AND vi_date <= '1579881600') AND agency='GSIA'
GROUP BY contract_id;

SELECT a.contract_id,c.name,FROM_UNIXTIME(a.vi_date,'%m-%d-%Y') vidate, COUNT(a.contract_id) nocl
FROM wisi_gsia.vi_hdr a INNER JOIN wisi_gsia.cust_contract b ON a.contract_id=b.id INNER JOIN wisi_gsia.cust_geninfo c ON b.cust_id=c.id
WHERE (a.vi_date>='1564329600' AND a.vi_date <= '1579881600') AND a.agency='GSIA'
GROUP BY a.contract_id;