#
# Jing-Doo Wang, 2021/3/20, jdwang@asia.edu.tw
#
import os

GantryID = "03F2100S"
    
OutPutDir = "d:/TDCS_06A"
if (os.path.exists(OutPutDir)):
    print("Existed => "+OutPutDir)
else:
    os.mkdir(OutPutDir)
    print("Create => "+OutPutDir)
    
ID = "940100540_jdwang"
Version = "V11"

InputDir = "D:\\Python_jdwang\\Temp\\201701_1-1"
#InputFileName = "TDCS_M06A_20170101_000000.csv"
for InputFileName in os.listdir(InputDir):
    print(InputFileName)

    fn = os.path.join(InputDir, InputFileName)
    
    VehicleTypes= {"31":0, "32":0, "41":0, "42":0, "5":0}
       
    cnt = 0  
    with open(fn) as file_Obj:  
        for line in file_Obj:   
            #31,2021-02-24 18:10:37,03F0698S,2021-02-24 18:18:52,03F0846S,22.000,Y,2021-02-24 18:10:37+03F0698S; 2021-02-24 18:15:20+03F0783S; 2021-02-24 18:18:52+03F0846S
            Items = line.split(',')
            if (Items[2].find(GantryID) != -1):
                cnt = cnt+1
                VT = Items[0] 
                VehicleTypes[VT] = VehicleTypes[VT] + 1
            
    #for OneVT in VehicleTypes.keys():
    #    print (OneVT+"=>"+str(VehicleTypes[OneVT]))

    OutputfileName = InputFileName[:18] #"TDCS_M06A_20170101"
    Date = InputFileName[10:18]
    Hour = InputFileName[19:21]
    
    fn = os.path.join(OutPutDir, ID+"_"+OutputfileName+"_"+Version+".txt")
    
    if (os.path.exists(fn)):
        with open(fn, 'a') as file_Obj:  
            file_Obj.write(GantryID+"\t")
            file_Obj.write(Date+"\t")
            file_Obj.write(Hour)
            
            for OneVT in VehicleTypes.keys():
                file_Obj.write("\t"+str(VehicleTypes[OneVT]))
            file_Obj.write("\n")
    else:
        with open(fn, 'w') as file_Obj:
            file_Obj.write("GantryID"+"\t"+"Date"+"\t"+"Hour")
            for OneVT in VehicleTypes.keys():
                file_Obj.write("\t"+OneVT)
            file_Obj.write("\n")
            
            file_Obj.write(GantryID+"\t")
            file_Obj.write(Date+"\t")
            file_Obj.write(Hour)
            
            for OneVT in VehicleTypes.keys():
                file_Obj.write("\t"+str(VehicleTypes[OneVT]))
            file_Obj.write("\n")