<?php

class HiboxAppPlatformController extends Controller
{
    /**
     * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
     * using two-column layout. See 'protected/views/layouts/column2.php'.
     */
    public $layout = '//layouts/column1';

    /**
     * @var CActiveRecord the currently loaded data model instance.
     */
    private $_model;

    /**
     * @return array action filters
     */
    public function filters()
    {
        return array(
                        'accessControl', // perform access control for CRUD operations
                    );
    }

    /**
     * Specifies the access control rules.
     * This method is used by the 'accessControl' filter.
     * @return array access control rules
    public function accessRules()
    {
        return array(
            array('allow',  // allow all users to perform 'index' and 'view' actions
                'actions' => array('index','view'),
                'users' => array('*'),
            ),
            array('allow', // allow authenticated user to perform 'create' and 'update' actions
                'actions' => array('create','update'),
                'users' => array('@'),
            ),
            array('allow', // allow admin user to perform 'admin' and 'delete' actions
                'actions' => array('admin','delete'),
                'users' => array('admin'),
            ),
            array('deny',  // deny all users
                'users' => array('*'),
            ),
        );
    }
    */

    /**
     * Displays a particular model.
     */
    public function actionView()
    {
        $this->render('view', array('model' => $this->loadModel()));
    }

    /**
     * Creates a new model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     */
    public function actionCreate()
    {
        $model = new HiboxAppPlatform;
        $appInfo = array();
        
        // Uncomment the following line if AJAX validation is needed
        $this->performAjaxValidation($model);
        
        if (isset($_GET['CALL']))
        {
            $appInfo = json_decode($_GET['CALL'], true);
        }
            
        if (isset($_POST['HiboxAppPlatform']))
        {
            $model->attributes = $_POST['HiboxAppPlatform'];
            if($model->save())
            {
                Yii::app()->user->setFlash('success', '应用“'.$_POST['appName'].'” 的 “'.ReplaceViewDataValue::getReplaced(3, $model->plat_id).'” 已创建成功！');
            }
        }

        $this->render('create',array(
                                        'model' => $model,
                                        'appInfo' => $appInfo,
                     ));
    }

    /**
     * Updates a particular model.
     * If update is successful, the browser will be redirected to the 'view' page.
     */
    public function actionUpdate()
    {
        $model = $this->loadModel();

        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);

        if(isset($_POST['HiboxAppPlatform']))
        {
            $model->attributes=$_POST['HiboxAppPlatform'];

            if($model->save())
            {
                $this->redirect(array('view', 'id' => $model->id));
                Yii::app()->end();
            }
        }

        $this->render('update', array('model' => $model));
    }

    /**
     * Deletes a particular model.
     * If deletion is successful, the browser will be redirected to the 'index' page.
     */
    public function actionDelete()
    {
        if(Yii::app()->request->isPostRequest)
        {
            // we only allow deletion via POST request
            $this->loadModel()->delete();

            // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
            if (!isset($_GET['ajax']))
            {
                $this->redirect(array('index'));
            }
        }
        else
            throw new CHttpException(400,'Invalid request. Please do not repeat this request again.');
    }

    /**
     * Lists all models.
     */
    public function actionIndex()
    {
        $dataProvider = new CActiveDataProvider('HiboxAppPlatform');
        
        $this->render('index', array('dataProvider' => $dataProvider ));
    }

    /**
     * Manages all models.
     */
    public function actionAdmin()
    {
        $model = new HiboxAppPlatform('search');
        $model->unsetAttributes();  // clear any default values
        if (isset($_GET['HiboxAppPlatform']))
            $model->attributes=$_GET['HiboxAppPlatform'];

        $this->render('admin',array('model' => $model));
    }
    
    /**
     * 自有应用管理
     */
    public function actionOwnAdmin()
    {
        $model = new HiboxAppPlatform('search');
        $model->unsetAttributes();  // clear any default values
        
        if (isset($_GET['HiboxAppPlatform']))
            $model->attributes=$_GET['HiboxAppPlatform'];
            
        $model->app_id = '<='.HiboxAppPlatform::KNOW_OWNORDEV_APPID_VALUE;
        
        $this->render('admin',array('model' => $model));
    }
    
    /**
     * 第三方应用管理
     */
    public function actionDevAdmin()
    {
        $model = new HiboxAppPlatform('search');
        $model->unsetAttributes();  // clear any default values
        
        if (isset($_GET['HiboxAppPlatform']))
            $model->attributes=$_GET['HiboxAppPlatform'];
            
        $model->app_id = '>'.HiboxAppPlatform::KNOW_OWNORDEV_APPID_VALUE;
        
        $this->render('admin',array('model' => $model));
    }
    

    /**
     * 自有应用发布
     */
    public function actionPublishAdmin()
    {
        if (isset($_REQUEST['id']))
        {
            $this->doPublish();
        }
        
        $model = new HiboxAppPlatform;
        $model->unsetAttributes();  // clear any default values
        
        $dataProvider = new CActiveDataProvider('HiboxAppPlatform', array(
                                                                             'criteria' => array('condition' => "app_state = 1 AND app_id < ".HiboxAppPlatform::KNOW_OWNORDEV_APPID_VALUE),
                                                                             'pagination' => array('pageSize' => 10),
                                               ));
        
        $this->render('publish', array(
                                          'dataProvider' => $dataProvider,
                                          'model' => $model,
                     ));
    }
    
    /**
     * 应用状态修改
     */
    public function actionStatusAdmin()
    {    
        if (Yii::app()->request->isPostRequest)
        {
            $this->updateState();
        }
        
        $model = new HiboxAppPlatform('search');
        $model->unsetAttributes();  // clear any default values
        
        $dataProvider = $model->search();

        $this->render('status', array(
                                         'dataProvider' => $dataProvider,
                                         'model' => $model,
                     ));
    }
    
    /**
     * Returns the data model based on the primary key given in the GET variable.
     * If the data model is not found, an HTTP exception will be raised.
     */
    public function loadModel()
    {
        if($this->_model === null)
        {
            if(isset($_GET['id']))
                $this->_model = HiboxAppPlatform::model()->findbyPk($_GET['id']);
            if($this->_model === null)
                throw new CHttpException(404, 'The requested page does not exist.');
        }
        return $this->_model;
    }

    /**
     * Performs the AJAX validation.
     * @param CModel the model to be validated
     */
    protected function performAjaxValidation($model)
    {
        if(isset($_POST['ajax']) && $_POST['ajax'] === 'wave-func-plat-form')
        {
            echo CActiveForm::validate($model);
            Yii::app()->end();
        }
    }
    
    /**
     * 自有应用发布
     * 
     * 步骤
     * [
     *     A. 更新应用信息表状态
     *  B. 更新应用平台表状态
     *  C. 初始化应用数据统计值
     *  D. 初始化应用日跃数据值
     * ]
     */
    protected function doPublish()
    {
        if (!isset($_REQUEST['id'], $_REQUEST['aid'], $_REQUEST['pid']))
        {
            throw new CHttpException(404, '您访问的页面不存在！');
        }

        $connection = Yii::app()->db;
        $transaction = $connection->beginTransaction();
        
        try 
        {
            $sqlStatement = "UPDATE `wave_func` SET app_state = 0 WHERE id = :aid";
            $command = $connection->createCommand($sqlStatement);
            $command->bindValue(':aid', $_REQUEST['aid']);
            $command->execute();
            
            $sqlStatement = "UPDATE `wave_func_plat` SET app_state = 0 WHERE id = :id";
            $command = $connection->createCommand($sqlStatement);
            $command->bindValue(':id', $_REQUEST['id']);
            $command->execute();

            $sqlStatement = "INSERT IGNORE INTO `wave_funcStat` (func_id) VALUE (:aid)";
            $command = $connection->createCommand($sqlStatement);
            $command->bindValue(':aid', $_REQUEST['aid']);
            $command->execute();
 
            $sqlStatement = "INSERT IGNORE INTO `wave_funcStatDay` (datekey,func_id,actives) VALUE ('".date('Ymd')."', :aid, 0)";
            $command = $connection->createCommand($sqlStatement);
            $command->bindValue(':aid', $_REQUEST['aid']);
            $command->execute();
            
            $transaction->commit();
        } 
        catch ( Exception $e ) 
        {
            $transaction->rollback();
            echo $e->getMessage();
        }
    }
    
    /**
     * 修改应用状态
     * 
     * @throws mixed (CHttpException|Exception)
     * @return int
     */
    protected function updateState()
    {
        $ids = null;

        if (isset($_POST['select'], $_POST['state']))
        {
            if (is_array($_POST['select']) && is_numeric($_POST['state']))
            {
                $connection = Yii::app()->db;
                $transaction = $connection->beginTransaction();
                try 
                {
                    $ids = array_map('intval', $_POST['select']);
                    $sqlStatement = "UPDATE `wave_func_plat` SET app_state = :state WHERE app_state <> :state AND id IN (".implode(',', $ids).")";
                    $command = $connection->createCommand($sqlStatement);
                    $command->bindValue(':state', intval($_POST['state']));
                    //$command->bindValue(':ids', implode(',', $ids));
                    
                    $result = $command->execute();
                    $transaction->commit();
                    
                    echo $result;
                }
                catch ( Exception $e )
                {
                    $transaction->rollback();
                    echo $e->getMessage();
                }
            }
        }
        else 
        {
            throw new CHttpException(404, '您访问的页面不存在！');
        }
    }
}
?>