add shorturl in day_report