ITG:Opgørelse af SMS-forbrug
From ITG
Følgende skal p.t. opdateres manuelt
UPDATE `sms_outbound` SET `multisms` = ROUND(LENGTH(message)/150+0.5) WHERE LENGTH(message) > 160
UPDATE `sms_outbound` SET `receivers` = LENGTH(to_number)-LENGTH(REPLACE(to_number, ',', ''))+1 WHERE LOCATE(',', `to_number`) > 0
UPDATE `sms_outbound` SET totalsms = multisms*receivers
