require_once __DIR__.'/vendor/autoload.php';
require_once __DIR__.'/config.php';

$accounts = file(
    __DIR__.'/accounts.txt', FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES
);


foreach ($accounts as $account) {
    list($provider, $name, $password, $date, $seen) = explode(';', $account);

    Stats::printPrimaryInfo($name);
    $database = new Database(DB_HOST, DB_NAME, DB_USER, DB_PASS);

    $producer = new GmailProvider($name, $password);
    $producer->setDate($date)->setSeen($seen);
	
	//$database->DeleteDBTable();
	$id_check_email = $database->insert_check_email($provider, 1);
	
    //get inbox message
    foreach ($producer->getMessageList('INBOX') as $message) {
        $mid = str_replace(['<', '>'], '', $message->getId());
        if (!$database->isMessageExist($provider, $mid)) {
            $type = 'inbox';
           // $provider = 'gmail';         
			$subject = empty($message->getSubject()) ? 'Без темы' : $message->getSubject();
            $date = $message->getDate()->format('Y-m-d H:i:s');
            $sender = $message->getFrom()->getAddress();
	    $recipient = empty($message->getTo()[0]) ? $recipient = $provider : $message->getTo()[0]->getAddress();			
            $body_text = strip_tags($message->getBodyText());
            $body_html = empty($message->getBodyHtml()) ? $message->getBodyText() : $message->getBodyHtml();
            //insert new message in to database
            $id = $database->insertMessage(
                [$type, $provider, $mid, $subject, $date, $sender, $recipient, $body_text, $body_html]
            );

            //download attachments and save in to database
            $check_name_company = false;
	    $name_company = "";
	    $attachments = $message->getAttachments();
            foreach ($attachments as $attachment) {
                if ($filename = $attachment->getFilename()) {
                    
			$filename = str_replace(['?'], '_', $filename);
			if ($check_name_company == false) 
			{	
				$name_company = $database->get_name_company_to_email($sender);
				$check_name_company = true;
			}
		    $dt = new DateTime($date);
                    $date = $dt->format('Y/m/d');
                    $path_filename = __DIR__."/attachments/{$provider}/{$type}/{$sender}/{$date}/{$mid}/{$filename}";
                    if (!is_dir(dirname($path_filename))) {
                        mkdir(dirname($path_filename), 0775, true);
                    }
                    file_put_contents(
                        mb_convert_encoding($path_filename, "Windows-1251", "UTF-8"), $attachment->getDecodedContent()
                    );
                    //insert new attachment in to database
                    $database->insertAttachment($id, $filename, $path_filename);
					
					
		    $path_parts = pathinfo($filename);
		    $ext_file = mb_convert_case($path_parts['extension'], MB_CASE_LOWER, "UTF-8");
		    if (($name_company != "") && (($ext_file == "xls") || ($ext_file == "xlsx") || ($ext_file == "ods")))
			{
			$new_filename = $database->get_name_file_company($name_company);
			if ($new_filename != "") {$path_filename = __DIR__."/Setki/".$new_filename.".".$ext_file;}
			else 
			{$path_filename = __DIR__."/Setki/!".$name_company."_".$filename;}	
			//Stats::printInfo("--", $new_filename, "--");
						
			if (!is_dir(dirname($path_filename))) { mkdir(dirname($path_filename), 0775, true); }
              
						
			file_put_contents(mb_convert_encoding($path_filename, "Windows-1251", "UTF-8"), $attachment->getDecodedContent());
						
											
					}	
                }
            }

            Stats::printInfo($sender, $subject, $date);
        }
    } 
	
	$database->update_check_email($id_check_email);

$producer->setDate($date)->setSeen($seen);

 $message->keepUnseen()->getBodyHtml();