email.c

   1 /*
   2  * SARG Squid Analysis Report Generator      http://sarg.sourceforge.net
   3  *                                                            1998, 2010
   4  *
   5  * SARG donations:
   6  *      please look at http://sarg.sourceforge.net/donations.php
   7  * Support:
   8  *     http://sourceforge.net/projects/sarg/forums/forum/363374
   9  * ---------------------------------------------------------------------
  10  *
  11  *  This program is free software; you can redistribute it and/or modify
  12  *  it under the terms of the GNU General Public License as published by
  13  *  the Free Software Foundation; either version 2 of the License, or
  14  *  (at your option) any later version.
  15  *
  16  *  This program is distributed in the hope that it will be useful,
  17  *  but WITHOUT ANY WARRANTY; without even the implied warranty of
  18  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  19  *  GNU General Public License for more details.
  20  *
  21  *  You should have received a copy of the GNU General Public License
  22  *  along with this program; if not, write to the Free Software
  23  *  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111, USA.
  24  *
  25  */
  26
  27 #include "include/conf.h"
  28 #include "include/defs.h"
  29
  30 int geramail(const char *dirname, int debug, const char *outdir, const char *email, const char *TempDir)
  31 {
  32         FILE *fp_in, *fp_top1, *fp_top2, *fp_top3;
  33         long long int ttnbytes=0, ttnacc=0, tnacc=0;
  34         long long int tnbytes=0, ttnelap=0, tnelap=0;
  35         long long int nacc, nbytes, elap;
  36         long long int avgacc, avgelap;
  37         double perc=0.00;
  38         double perc2=0.00;
  39         int posicao=0;
  40         char olduser[MAX_USER_LEN], csort[MAXLEN];
  41         char wger[MAXLEN], top1[MAXLEN], top2[MAXLEN], top3[MAXLEN], user[MAX_USER_LEN];
  42         char strip1[MAXLEN], strip2[MAXLEN], strip3[MAXLEN], strip4[MAXLEN], strip5[MAXLEN], strip6[MAXLEN], strip7[MAXLEN];
  43         char *buf;
  44         char warea[MAXLEN];
  45         int totuser=0;
  46         time_t t;
  47         struct tm *local;
  48         int cstatus;
  49         struct getwordstruct gwarea;
  50         struct generalitemstruct item;
  51         longline line;
  52         const struct userinfostruct *uinfo;
  53
  54         snprintf(wger,sizeof(wger),"%s/sarg-general",dirname);
  55         if((fp_in=fopen(wger,"r"))==NULL) {
  56                 debuga(_("(email) Cannot open file %s\n"),wger);
  57                 exit(EXIT_FAILURE);
  58         }
  59
  60         snprintf(top1,sizeof(top1),"%s/top",dirname);
  61         if((fp_top1=fopen(top1,"w"))==NULL) {
  62                 debuga(_("(email) Cannot open file %s\n"),top1);
  63                 exit(EXIT_FAILURE);
  64         }
  65
  66         snprintf(top2,sizeof(top2),"%s/top.tmp",dirname);
  67         if((fp_top2=fopen(top2,"w"))==NULL) {
  68                 debuga(_("(email) Cannot open file %s\n"),top2);
  69                 exit(EXIT_FAILURE);
  70         }
  71
  72         olduser[0]='\0';
  73         totuser=0;
  74
  75         if ((line=longline_create())==NULL) {
  76                 debuga(_("Not enough memory to read file %s\n"),wger);
  77                 exit(EXIT_FAILURE);
  78         }
  79
  80         while((buf=longline_read(fp_in,line))!=NULL) {
  81                 ger_read(buf,&item,wger);
  82                 if(item.total) continue;
  83                 if(strcmp(olduser,item.user) != 0) {
  84                         totuser++;
  85
  86                         if (olduser[0] != '\0') {
  87 #if defined(__FreeBSD__)
  88                                 fprintf(fp_top2,"%s\t%qu\t%qu\t%qu\n",olduser,tnbytes,tnacc,tnelap);
  89 #else
  90                                 fprintf(fp_top2,"%s\t%"PRIu64"\t%"PRIu64"\t%"PRIu64"\n",olduser,(uint64_t)tnbytes,(uint64_t)tnacc,(uint64_t)tnelap);
  91 #endif
  92                                 ttnbytes+=tnbytes;
  93                                 ttnacc+=tnacc;
  94                                 ttnelap+=tnelap;
  95                         }
  96                         strcpy(olduser,item.user);
  97                         tnbytes=0;
  98                         tnacc=0;
  99                         tnelap=0;
 100                 }
 101
 102                 tnbytes+=item.nbytes;
 103                 tnacc+=item.nacc;
 104                 tnelap+=item.nelap;
 105         }
 106         fclose(fp_in);
 107         longline_destroy(&line);
 108
 109         if (olduser[0] != '\0') {
 110 #if defined(__FreeBSD__)
 111                 fprintf(fp_top2,"%s\t%qu\t%qu\t%qu\n",olduser,tnbytes,tnacc,tnelap);
 112 #else
 113                 fprintf(fp_top2,"%s\t%"PRIu64"\t%"PRIu64"\t%"PRIu64"\n",olduser,(uint64_t)tnbytes,(uint64_t)tnacc,(uint64_t)tnelap);
 114 #endif
 115                 ttnbytes+=tnbytes;
 116                 ttnacc+=tnacc;
 117                 ttnelap+=tnelap;
 118         }
 119
 120         fclose(fp_top2);
 121
 122         sprintf(csort,"sort -n -T \"%s\" -r -k 2,2 -o \"%s\" \"%s\"", TempDir, top1, top2);
 123         cstatus=system(csort);
 124         if (!WIFEXITED(cstatus) || WEXITSTATUS(cstatus)) {
 125                 debuga(_("sort command return status %d\n"),WEXITSTATUS(cstatus));
 126                 debuga(_("sort command: %s\n"),csort);
 127                 exit(EXIT_FAILURE);
 128         }
 129
 130         unlink(top2);
 131
 132         if((fp_top1=fopen(top1,"r"))==NULL) {
 133                 debuga(_("(email) Cannot open file %s\n"),top1);
 134                 exit(EXIT_FAILURE);
 135         }
 136
 137         snprintf(top3,sizeof(top3),"%s/report",dirname);
 138         if((fp_top3=fopen(top3,"w"))==NULL) {
 139                 debuga(_("(email) Cannot open file %s\n"),top3);
 140                 exit(EXIT_FAILURE);
 141         }
 142
 143         strcpy(strip1,_("Squid User Access Report"));
 144         strip_latin(strip1);
 145         fprintf(fp_top3,"%s\n",strip1);
 146
 147         strcpy(strip1,_("Decreasing Access (bytes)"));
 148         strip_latin(strip1);
 149         fprintf(fp_top3,"%s\n",strip1);
 150
 151         strcpy(strip1,_("Period"));
 152         strip_latin(strip1);
 153         fprintf(fp_top3,"%s %s\n\n",strip1,period.text);
 154
 155         strcpy(strip1,_("NUM"));
 156         strip_latin(strip1);
 157         strcpy(strip2,_("USERID"));
 158         strip_latin(strip2);
 159         strcpy(strip3,_("CONNECT"));
 160         strip_latin(strip3);
 161         strcpy(strip4,_("BYTES"));
 162         strip_latin(strip4);
 163         strcpy(strip5,_("ELAPSED TIME"));
 164         strip_latin(strip5);
 165         strcpy(strip6,_("MILLISEC"));
 166         strip_latin(strip6);
 167         strcpy(strip7,_("TIME"));
 168         strip_latin(strip7);
 169
 170         fprintf(fp_top3,"%-7s %-20s %-8s %-15s %%%-6s %-10s %-10s %%%-7s\n------- -------------------- -------- --------------- ------- ---------- ---------- -------\n",strip1,strip2,strip3,strip4,strip4,strip5,strip6,strip7);
 171
 172         while(fgets(warea,sizeof(warea),fp_top1)) {
 173                 fixendofline(warea);
 174                 getword_start(&gwarea,warea);
 175                 if (getword(user,sizeof(user),&gwarea,'\t')<0) {
 176                         debuga(_("There is an invalid user ID in file %s\n"),top1);
 177                         exit(EXIT_FAILURE);
 178                 }
 179                 if (getword_atoll(&nbytes,&gwarea,'\t')<0) {
 180                         debuga(_("There is an invalid number of bytes in file %s\n"),top1);
 181                         exit(EXIT_FAILURE);
 182                 }
 183                 if (getword_atoll(&nacc,&gwarea,'\t')<0) {
 184                         debuga(_("There is an invalid number of access in file %s\n"),top1);
 185                         exit(EXIT_FAILURE);
 186                 }
 187                 if (getword_atoll(&elap,&gwarea,'\0')<0) {
 188                         debuga(_("There is an invalid elapsed time in file %s\n"),top1);
 189                         exit(EXIT_FAILURE);
 190                 }
 191
 192                 uinfo=userinfo_find_from_id(user);
 193                 if (!uinfo) {
 194                         debuga(_("Unknown user ID %s in file %s\n"),user,top1);
 195                         exit(EXIT_FAILURE);
 196                 }
 197
 198                 perc=(ttnbytes) ? nbytes * 100. / ttnbytes : 0;
 199                 perc2=(ttnelap) ? elap * 100. / ttnelap : 0;
 200
 201                 posicao++;
 202
 203 #if defined(__FreeBSD__)
 204                 fprintf(fp_top3,"%7d %20s %8lld %15s %3.2lf%% %10s %10qu %3.2lf%%\n",posicao,uinfo->label,nacc,fixnum(nbytes,1),perc,buildtime(elap),elap,perc2);
 205 #else
 206                 fprintf(fp_top3,"%7d %20s %8"PRIu64" %15s %3.2lf%% %10s %10"PRIu64" %3.2lf%%\n",posicao,uinfo->label,(uint64_t)nacc,fixnum(nbytes,1),perc,buildtime(elap),(uint64_t)elap,perc2);
 207 #endif
 208         }
 209
 210         // output total
 211         fputs("------- -------------------- -------- --------------- ------- ---------- ---------- -------\n",fp_top3);
 212 #if defined(__FreeBSD__)
 213         fprintf(fp_top3,"%-7s %20s %8qu %15s %8s %9s %10qu\n",_("TOTAL")," ",ttnacc,fixnum(ttnbytes,1)," ",buildtime(ttnelap),ttnelap);
 214 #else
 215         fprintf(fp_top3,"%-7s %20s %8"PRIu64" %15s %8s %9s %10"PRIu64"\n",_("TOTAL")," ",(uint64_t)ttnacc,fixnum(ttnbytes,1)," ",buildtime(ttnelap),(uint64_t)ttnelap);
 216 #endif
 217
 218         // compute and write average
 219         if (totuser>0) {
 220                 tnbytes=(totuser) ? ttnbytes / totuser : 0;
 221                 avgacc=ttnacc/totuser;
 222                 avgelap=ttnelap/totuser;
 223         } else {
 224                 tnbytes=0;
 225                 avgacc=0;
 226                 avgelap=0;
 227         }
 228
 229         strcpy(strip1,_("AVERAGE"));
 230         strip_latin(strip1);
 231 #if defined(__FreeBSD__)
 232         fprintf(fp_top3,"%-7s %20s %8qu %15s %8s %9s %10qu\n",strip1," ",avgacc,fixnum(tnbytes,1)," ",buildtime(avgelap),avgelap);
 233 #else
 234         fprintf(fp_top3,"%-7s %20s %8"PRIu64" %15s %8s %9s %10"PRIu64"\n",strip1," ",(uint64_t)avgacc,fixnum(tnbytes,1)," ",buildtime(avgelap),(uint64_t)avgelap);
 235 #endif
 236
 237         fclose(fp_top1);
 238         unlink(top1);
 239
 240         t = time(NULL);
 241         local = localtime(&t);
 242         fprintf(fp_top3, "\n%s\n", asctime(local));
 243
 244         fclose(fp_top3);
 245
 246         if(strcmp(email,"stdout") == 0) {
 247                 if((fp_top3=fopen(top3,"r"))==NULL) {
 248                         debuga(_("(email) Cannot open file %s\n"),top3);
 249                         exit(EXIT_FAILURE);
 250                 }
 251
 252                 while(fgets(warea,sizeof(warea),fp_top3)!=NULL)
 253                         fputs(warea,stdout);
 254         } else {
 255                 snprintf(warea,sizeof(warea),"%s -s \"SARG %s, %s\" \"%s\" <\"%s\"",MailUtility,_("Report"),asctime(local),email,top3);
 256                 cstatus=system(warea);
 257                 if (!WIFEXITED(cstatus) || WEXITSTATUS(cstatus)) {
 258                         debuga(_("command return status %d\n"),WEXITSTATUS(cstatus));
 259                         debuga(_("command: %s\n"),warea);
 260                         exit(EXIT_FAILURE);
 261                 }
 262         }
 263
 264         //unlinkdir(TempDir,0);
 265
 266         return (0);
 267 }