<?php

/**
 *
 *  Class ki skrbi za opomnike trgoovine (cronjob)
 *
 *  Cron jobi nej bodo 3. (ob 9h zjutraj) 
 *  1. 6 dni prej k zgenerira predračun. Vsebina v smislu: vaša naročnina se bo kmalu iztekla. Zagotovite si neomejeno uporabo 2ka/3ka še naprej s plačilom predračuna v priponki. 
 *  2. 1 dan pred potekom. Vsebina v smislu: Danes je zadnji dan veljavnosti vašega paketa. Zagotovite si delovanje 1ka še naprej ...
 *  3. En dan po poteku. Vsebina v smislu: Vaša naročnina se je iztekla. Nov paket lahko naročite na 1ka.si
 *
*/


class UserNarocilaCron{


    public function __construct(){

    }


    /**
	* izvede ustrezno akcijo
	*/
	public function executeAction($action = '') {
		
		// Izvedemo ustrezno akcijo	
		if(method_exists('UserNarocilaCron', $action) && $action != '')
			$this->$action();
		else
			echo 'Method '.$action.' does not exist!';
	}


    // Mail 6 dni pred potekom narocnine
    private function notifyIn6(){

        $expired_users = $this->getExpiredUsers($expire='in6');

        foreach($expired_users as $usr_id => $user){

            $narocilo = $this->getLastNarocilo($usr_id);

            // Nastavimo ustrezen jezik - mail mora biti v istem jeziku kot je bilo zadnje narocilo
            if($narocilo['language'] == 'en')
                include('../lang/2.php');
            else
                include('../lang/1.php');


            // Posljemo mail
            $subject = $lang['srv_access_expire_in6_subject'];  
            $content = str_replace('#PACKAGE_NAME#', $narocilo['package_id'].'ka', $lang['srv_access_expire_in6_content1']);
            $content .= str_replace('#PACKAGE_ID#', $narocilo['package_id'], $lang['srv_access_expire_in6_content2']);
            $content .= $lang['srv_access_expire_in6_content3'] . $user['email'];

            // Podpis
            $signature = Common::getEmailSignature();
            $content .= $signature;

            try{
                $MA = new MailAdapter();
                $MA->addRecipients($user['email']);
                $resultX = $MA->sendMail($content, $subject);
            }
            catch (Exception $e){
            }
        }
        
    }

    // Mail 1 dan pred potekom narocnine
    private function notifyIn1(){

        $expired_users = $this->getExpiredUsers($expire='in1');

        foreach($expired_users as $usr_id => $user){

            $narocilo = $this->getLastNarocilo($usr_id);

            // Nastavimo ustrezen jezik - mail mora biti v istem jeziku kot je bilo zadnje narocilo
            if($narocilo['language'] == 'en')
                include('../lang/2.php');
            else
                include('../lang/1.php');

                
            // Posljemo mail
            $subject = $lang['srv_access_expire_in1_subject'];  
            $content = str_replace('#PACKAGE_NAME#', $narocilo['package_id'].'ka', $lang['srv_access_expire_in1_content1']);
            $content .= str_replace('#PACKAGE_ID#', $narocilo['package_id'], $lang['srv_access_expire_in1_content2']);
            $content .= $lang['srv_access_expire_in1_content3'] . $user['email'];

            // Podpis
            $signature = Common::getEmailSignature();
            $content .= $signature;

            try{
                $MA = new MailAdapter();
                $MA->addRecipients($user['email']);
                $resultX = $MA->sendMail($content, $subject);
            }
            catch (Exception $e){
            }
        }
    }

    // Mail 1 dan po poteku narocnine
    private function notifyExpired(){

        $expired_users = $this->getExpiredUsers($expire='expired');

        foreach($expired_users as $usr_id => $user){

            $narocilo = $this->getLastNarocilo($usr_id);

            // Nastavimo ustrezen jezik - mail mora biti v istem jeziku kot je bilo zadnje narocilo
            if($narocilo['language'] == 'en')
                include('../lang/2.php');
            else
                include('../lang/1.php');

                
            // Posljemo mail
            $subject = $lang['srv_access_expire_expired_subject'];  
            $content = str_replace('#PACKAGE_NAME#', $narocilo['package_id'].'ka', $lang['srv_access_expire_expired_content1']);
            $content .= str_replace('#PACKAGE_ID#', $narocilo['package_id'], $lang['srv_access_expire_expired_content2']);
            $content .= $lang['srv_access_expire_expired_content3'] . $user['email'];

            // Podpis
            $signature = Common::getEmailSignature();
            $content .= $signature;

            try{
                $MA = new MailAdapter();
                $MA->addRecipients($user['email']);
                $resultX = $MA->sendMail($content, $subject);
            }
            catch (Exception $e){
            }
        }
    }



    // Dobimo seznam uporabnikov, ki jim potece paket na dolocen dan
    private function getExpiredUsers($expire){

        if($expire == 'in6'){
            $interval_query = 'DATE(time_expire) = DATE(NOW() + INTERVAL 6 DAY)';
        }
        elseif($expire == 'in1'){
            $interval_query = 'DATE(time_expire) = DATE(NOW() + INTERVAL 1 DAY)';
        }
        if($expire == 'expired'){
            $interval_query = 'DATE(time_expire) = DATE(NOW() - INTERVAL 1 DAY)';
        }
        
        $result = array();

        // Loop po vseh uporabnikih, ki imajo zakupljen paket in jim potece cez 6 dni
        $sqlAccess = sisplet_query("SELECT a.*, u.email 
                                        FROM user_access a, users u 
                                        WHERE (a.package_id = 2 OR a.package_id = 3) 
                                            AND ".$interval_query."
                                            AND u.id=a.usr_id
                                    ");

        while($rowAccess = mysqli_fetch_array($sqlAccess)){
            $result[$rowAccess['usr_id']] = $rowAccess;
        }

        return $result;
    }

    // Dobimo zadnji placan paket uporabnika
    private function getLastNarocilo($usr_id){

        // Dobimo podatke zadnjega placanega narocila za tega uporabnika
        $sqlNarocilo = sisplet_query("SELECT * 
                                        FROM user_access_narocilo 
                                        WHERE usr_id='".$usr_id."' AND status='1'
                                        ORDER BY time DESC
                                        LIMIT 1
                                    ");

        // Uporabnik nima nobenega placanega paketa
        if(mysqli_num_rows($sqlNarocilo) == 0){
            return false;
        }

        $rowNarocilo = mysqli_fetch_array($sqlNarocilo);

        return $rowNarocilo;
    }
}