Something

public text v1 · immutable

#35844

·published 2006-01-05 13:06 UTC

exten => s,2,Set(fin=5875)
exten => s,3,MYSQL(Query resultid ${connid} SELECT SUM(minutes)\ AS total\ FROM\ worked\ WHERE\ fin=`${fin}`\ AND\ startdate >= DATE_FORMAT(NOW(),\ '%Y-%m-01'))
exten => s,4,MYSQL(Fetch fetchid ${resultid} mymins)
exten => s,5,NoOp(${mymins})
exten => s,6,MYSQL(Clear ${resultid})
exten => s,7,MYSQL(Disconnect ${connid})
exten => s,8,Hangup