def GetXiaoFeiTable(self, startTime, endTime, YeJi=False, Table=True):
self.conn = sqlite3.connect('MYDATA.db')
today = False
if startTime == endTime or YeJi == True:
today = True
startTime = Common.MakeTime(startTime)
# endTime = Common.MakeTime(endTime,today)
endTime = Common.MakeTime(endTime, True)
if Table:
sqlStr = 'SELECT orderNo,createdTime,pcSign,carId,carUser,carPhone,carModel,workerName,project,attribute,orderCheckId' \
' FROM XiaoFei WHERE createdTime BETWEEN \'{}\' and \'{}\' ORDER BY createdTime DESC '.format(
startTime, endTime)
else:
sqlStr = 'SELECT orderCheckId,orderNo,createdTime,pcSign,carId,carUser,carPhone,carModel,workerName,project,attribute' \
' FROM XiaoFei WHERE createdTime BETWEEN \'{}\' and \'{}\' ORDER BY createdTime DESC '.format(
startTime, endTime)
cursor = self.conn.execute(sqlStr)
data = cursor.fetchall()
cursor.close()
self.conn.close()
return data
def GetCallBack(self):
self.conn = sqlite3.connect('MYDATA.db')
now = datetime.now()
timeStr = "{}/{}/{}".format(now.year, now.month, now.day)
timeStr = Common.MakeTime(timeStr, True)
sqlStr = 'SELECT id,username,carId,phone,callbackTime FROM CallBack WHERE state=\'0\' AND callbackTime <= \'{}\' ORDER BY createdTime DESC '.format(
timeStr)
cursor = self.conn.execute(sqlStr)
datas = cursor.fetchall()
cursor.close()
self.conn.close()
return datas
