yii中的控制台应用程序无法包含AR模型


Console app in yii fails to include AR model

我想在yii中调度运行控制台命令。我编写了php脚本,并在web应用程序中尝试了它,效果很好。然而,当我把它作为控制台命令时,cron发送以下消息:

PHP Error[2]: include(User.php): failed to open stream: No such file or directory
    in file /home/srv50213/htdocs/framework/YiiBase.php at line 427
#0 /home/srv50213/htdocs/framework/YiiBase.php(427): autoload()
#1 unknown(0): autoload()
#2 /home/srv50213/htdocs/doc/protected/commands/ReportMailerCommand.php(20): spl_autoload_call()
#3 unknown(0): ReportMailerCommand->actionIndex2()
#4 /home/srv50213/htdocs/framework/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#5 /home/srv50213/htdocs/framework/console/CConsoleCommandRunner.php(71): ReportMailerCommand->run()
#6 /home/srv50213/htdocs/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#7 /home/srv50213/htdocs/framework/base/CApplication.php(180): CConsoleApplication->processRequest()
#8 /home/srv50213/htdocs/framework/yiic.php(33): CConsoleApplication->run()
#9 /home/srv50213/htdocs/doc/protected/yiic.php(8): require_once()

似乎自动加载()不能正常工作。对于控制台应用$config,我使用config/console.php,其中我插入了db设置(来自main.php和用户设置)。

'components'=>array(
    'db'=>array(            
            // настройки для конфигурации 
        'connectionString' => 
        'mysql:host=localhost;dbname=xxx',
        'emulatePrepare' => true,
        'schemaCachingDuration' => 3600,
        'username' => 'xxx',
        'password' => 'xxx',
        'charset' => 'utf8',
        'tablePrefix' => 'yiiapp_', 
        'class'     => 'CDbConnection'          
    ),
    'user'=>array(      
        'class' => 'WebUser', 
        //'class' => 'application.components.User',
        // enable cookie-based authentication
        'allowAutoLogin'=>true,
    ),  
 )

脚本是smth。这样的:

public function actionIndex2($args) 
{    
    $users = User::model()->findAllByPk( array(177) );  
    foreach($users as $user)
    {         
        $query = "SELECT  e.id, e.Subject
                        FROM  `yiiapp_doc_events` AS e
                        LEFT JOIN  `yiiapp_doc_event_users` AS u ON e.id = u.eventId
                        WHERE e.StatusId NOT IN (5,7)  
                        AND u.userId = {$user->id}
                        GROUP BY e.id";
        $queryResult = Yii::app()->db->createCommand($query)->queryAll(); 
        if ($queryResult)
        {   
            foreach($queryResult as $res)
            {
                $i++;
                $link = Yii::app()->createAbsoluteUrl('docEvents/update', array('id'=>$res['id']));
                $table .= "<tr><td> {$i} </td><td> <a href='{$link}'>{$res['id']}</a> </td><td> <a href='{$link}'>{$res['Subject']}</a> </td></tr>";                
            }
            //echo $table . '</table>';
            $content= "  $table . '</table>';
            mail($user->email,  "Report (". $i . ')', $content,  'Content-type: text/html');
        }
    } 
}

出了什么问题,怎么解决?

<标题> 更新

根据chris的建议,我在配置数组中添加了import参数。现在这个问题已经解决了。然而,由于我要求Yii::app()->createAbsoluteUrl(),另一件事使Undefined index: SERVER_NAME受挫:

PHP Error[8]: Undefined index: SERVER_NAME
in file /home/srv50213/htdocs/framework/web/CHttpRequest.php at line 317
#0 /home/srv50213/htdocs/framework/base/CApplication.php(560): CHttpRequest->getHostInfo()
#1 /home/srv50213/htdocs/doc/protected/commands/ReportMailerCommand.php(39): CConsoleApplication->createAbsoluteUrl()
...

解决方案是什么?

<标题> 解决方案

在控制台命令中搜索createAbsoluteUrl后,我发现了有用的线程1和2。

在config/console.php中添加以下内容:

'components' => array(
     'request' => array(
        'hostInfo' => 'https://domainname.com',
        'baseUrl' => '',
        'scriptUrl' => '',
     ),
     ...
)

第二种方式类似:

'components' => array(
    'urlManager' => array(
        'baseUrl' => 'https://domain.com'
    )
)

您是否正确定义了导入?我认为这不是默认的控制台配置。输入如下内容:

'import' => array(
    'application.models.*',
),

编辑:到你的更新:不能在控制台应用程序中使用createUrl()功能。就像你发现的那样,它使用$_SERVER['SERVER_NAME'],它没有设置,因为控制台应用程序总是在没有服务器的情况下运行,直接通过php cli。