package fengyun.Fastmail.beans.admin;

import java.io.*;
import java.sql.*;
import fengyun.Fastmail.beans.*;

public class UserDelete {
  public static String delete(String grade) {
    String home = null;
    String userid = null;
	StringBuffer deleted = new StringBuffer();
    try {
      Mysql mysql = new Mysql();
      ResultSet rs = mysql.executeQuery("select mailbox.userid,mailbox.home from profile,mailbox where profile.cardNumber like '"+grade+"%' and profile.certificateType=2 and profile.signup='N' and profile.userid=mailbox.userid");
	  while (rs.next()) {
	    home = rs.getString("home");
	    userid = rs.getString("userid");
		deleted.append(userid+"<br>");
        File homedir = new File (home);
	    if (homedir.exists()) deleteDirectory(home);
	    String profilesql = "delete from profile where userid='"+userid+"'";
	    String mailboxsql = "delete from mailbox where userid='"+userid+"'";
	    String folderlistsql = "delete from folderlist where userid='"+userid+"'";
	    String addresssql = "delete from address where userid='"+userid+"'";
        mysql.executeUpdate(profilesql);
	    mysql.executeUpdate(mailboxsql);
	    mysql.executeUpdate(folderlistsql);
	    mysql.executeUpdate(addresssql);
      }
      mysql.close();
    } catch (Exception ex) {
      System.err.println("UserDelete.delete():");
      ex.printStackTrace(System.err);
    }
	return deleted.toString();
  }
  public static void deleteDirectory(String home) {
    Runtime r=Runtime.getRuntime(); 
	Process p=null; 
	String cmd[]={"rm","-rf",home}; 
	try{ 
	  p=r.exec(cmd); 
	} catch(Exception e){ 
	  System.out.println("error executing: "+cmd[0]); 
	} 
  }
  public static boolean isValid(String sgrade) {
    int grade = Integer.parseInt(sgrade);
    return (grade>1900 && grade<2100);
  }
}