<?php
/**
 * Documentation
 * @author
 * @category
 * @package
 * @subpackage
 * @copyright  Copyright (c) 2005-2009 ITCrimea Ukraine Inc. (http://www.itcrimea.com)
 * @license
 */
class LiteMail_IndexController extends System_Controller_Base
{
    /**
     * Documentation
     *
     * @var mixed
     */
    protected $_model = null;
    /**
     * Documentation
     * @author
     * @return mixed
     */
    function init ()
    {
        parent::init();
    }
    /**
     * Documentation
     * @author
     * @return mixed
     */
    function indexAction ()
    {}

    
    
    // temporary function
    function storestartAction()
    {
        exit(); //!!!!!!!!!!!!!!!!!!!!!!! action for one run
        
        $tableUser = new Khancepts_User_Table();
        $select = $tableUser->select()->from('users');
        //$select->setIntegrityCheck(false);
        //$select->joinLeft('shop_orders', 'shop_orders.UserID = users.ID', array('OrderID'=>'ID'));
        $select->where('users.ID < 1088')->where('users.ID > 2');
        $select->where('users.LastLogin < \'2009-12-15 15:47:48\' ');
        $select->order('users.ID ASC');
        
        $objUsers = $tableUser->fetchAll($select);
        //Zend_Debug::dump($objUsers);
        
        //exit();
        
        if ($objUsers->count()) {
            $tableQueue = new LiteMail_Queue_Table();
            $tableOrder = new Shop_Order_Table();
            $chars = 'abdefhiknrstyzABDEFGHKNQRSTYZ23456789';
            $numChars = strlen($chars);
            
            foreach ($objUsers as $objUser) {
                $select = $tableOrder->select()->where('UserID = ?', $objUser->ID);
                $objOrder = $tableOrder->fetchRow($select);
                if (is_object($objOrder)) {
                    //Zend_Debug::dump($objOrder->ID);
                    continue;
                }
                
                $Password = '';
                for ($i = 0; $i < 10; $i++) {
                    $Password .= substr($chars, rand(1, $numChars) - 1, 1);
                }
                $objUser->Password = md5($Password);
                $objUser->save();
                
                //continue;
                $objectQueue = $tableQueue->fetchNew();
                $objectQueue->User_ID = $objUser->ID;
                $objectQueue->MailTemplate_ID = 0;
                $objectQueue->Status = LiteMail_Queue::STATUS_NEW;
                $objectQueue->EmailFrom = '[email protected]';
                $objectQueue->NameFrom = 'Khancepts.com';
                $objectQueue->EmailTo = $objUser->Email;
                $UserName = trim($objUser->Name . ' ' . $objUser->LastName);
                $objectQueue->NameTo = $UserName;
                $objectQueue->Subject = 'AdText Generator: Welcome to special members area for you!';
                $objectQueue->Body = 'Dear '.$UserName.','."\n\n".'We have made it easier for you to pick up your free software of Adtext Hunter and other resources by creating a special members area for you. You may also find your previous purchases and download links there as well.'."\n\n".'Here is the members link, username & password.'."\n\n".'link: https://secure.khancepts.com/store/'."\n".'user: '.$objUser->Login.''."\n".'pass: '.$Password.''."\n\n\n".'As always, we appreciate your loyalty and we plan to continue providing excellent software and services.'."\n\n".'Thank You in advance & enjoy!'."\n\n".'AM Khan';
                $objectQueue->save();
                //exit(); // for test
            }
        }
        exit();
    }
    
    
}