Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class DistributionplanController extends Controller
- {
- public $layout='//layouts/new';
- public function filters()
- {
- return array(
- array('application.components.CheckAuthFilter -error createbypo,upload,ambilplan,ambilic,ambildefault,ambilpackage,ambiladditional,ambilassetmap,matchdata'),
- 'postOnly + delete', // we only allow deletion via POST request
- );
- }
- public function actionView($id)
- {
- $this->render('view',array(
- 'model'=>$this->loadModel($id),
- ));
- }
- public function actionCreate()
- {
- $baseUrl = Yii::app()->baseUrl;
- $cs = Yii::app()->getClientScript();
- $cs->registerScriptFile($baseUrl.'/css/spinedit/js/bootstrap-spinedit.js');
- $cs->registerCssFile($baseUrl.'/css/spinedit/css/bootstrap-spinedit.css');
- $model=new DistributionPlan;
- // $this->performAjaxValidation($model);
- if(isset($_POST['DistributionPlan']))
- {
- $model->attributes=$_POST['DistributionPlan'];
- if($model->save()){
- foreach ($_POST['rows'] as $key => $count ){
- if(trim($_POST['data1_'.$count]) != ""){
- if(is_numeric(trim($_POST['data1_'.$count]))){
- if(intval($_POST['data1_'.$count]) == 1){
- $ins = new DistributionPackageMap;
- $ins->distribution_id = $model->primaryKey;
- $ins->package_list_id = $_POST['data2_'.$count];
- $ins->count_of_k = $_POST['data4_'.$count];
- $ins->count_of_i = $_POST['data5_'.$count];
- $ins->save();
- }elseif(intval($_POST['data1_'.$count]) == 2){
- $ins = new DistributionAdditionalAssetMap;
- $ins->distribution_id = $model->primaryKey;
- $ins->additional_asset_id = $_POST['data2_'.$count];
- $ins->count_of_k = $_POST['data4_'.$count];
- $ins->count_of_i = $_POST['data5_'.$count];
- $ins->save();
- }
- }
- }
- }
- $this->redirect('index');
- }
- }
- $this->render('create',array(
- 'model'=>$model,
- ));
- }
- public function actionUpdate($id)
- {
- $model=$this->loadModel($id);
- // $this->performAjaxValidation($model);
- if(isset($_POST['DistributionPlan']))
- {
- $model->attributes=$_POST['DistributionPlan'];
- if($model->save())
- //$this->redirect(array('view','id'=>$model->id));
- $this->redirect('index');
- }
- $this->render('update',array(
- 'model'=>$model,
- ));
- }
- public function actionDelete($id)
- {
- $this->loadModel($id)->delete();
- // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
- if(!isset($_GET['ajax']))
- $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
- }
- public function actionIndex()
- {
- $dataProvider=new CActiveDataProvider('DistributionPlan');
- $this->render('index',array(
- 'dataProvider'=>$dataProvider,
- ));
- }
- public function actionAdmin()
- {
- $model=new DistributionPlan('search');
- $model->unsetAttributes(); // clear any default values
- if(isset($_GET['DistributionPlan']))
- $model->attributes=$_GET['DistributionPlan'];
- $this->render('admin',array(
- 'model'=>$model,
- ));
- }
- public function loadModel($id)
- {
- $model=DistributionPlan::model()->findByPk($id);
- if($model===null)
- throw new CHttpException(404,'The requested page does not exist.');
- return $model;
- }
- public function actionAmbilplan()
- {
- $sql = "SELECT sys_generate_distribution_plan_number() AS distnumb FROM DUAL";
- $connection=Yii::app()->db;
- $command=$connection->createCommand($sql);
- $dataReader=$command->queryAll();
- echo CJSON::encode($dataReader);
- }
- public function actionAmbilic()
- {
- $id = $_POST['regid'];
- $sql = "SELECT id,partner_name,region FROM t_partner WHERE published=1 AND activate=1 AND is_system=0 AND region=:id";
- $connection=Yii::app()->db;
- $command=$connection->createCommand($sql);
- $command->bindParam(":id",$id,PDO::PARAM_STR);
- $dataReader=$command->queryAll();
- echo CJSON::encode($dataReader);
- }
- public function actionAmbildefault()
- {
- $sql = "SELECT * FROM t_distribution_item_type WHERE published=1 AND activate=1";
- $connection=Yii::app()->db;
- $command=$connection->createCommand($sql);
- $dataReader=$command->queryAll();
- echo CJSON::encode($dataReader);
- }
- public function actionAmbilpackage()
- {
- $sql = "SELECT * FROM t_package WHERE package_status=2 AND published=1 AND activate=1 AND is_system=0";
- $connection=Yii::app()->db;
- $command=$connection->createCommand($sql);
- $dataReader=$command->queryAll();
- echo CJSON::encode($dataReader);
- }
- public function actionAmbiladditional()
- {
- $sql = "SELECT * FROM t_additional_assets WHERE published=1 AND activate=1";
- $connection=Yii::app()->db;
- $command=$connection->createCommand($sql);
- $dataReader=$command->queryAll();
- echo CJSON::encode($dataReader);
- }
- public function actionAmbilassetmap()
- {
- $data = $_POST['id'];
- $sql = "SELECT count(id) as total FROM t_package_asset_map WHERE package_id=:id";
- $connection=Yii::app()->db;
- $command=$connection->createCommand($sql);
- $command->bindParam(":id",$data,PDO::PARAM_STR);
- $dataReader=$command->queryAll();
- echo CJSON::encode($dataReader);
- }
- public function actionMatchdata()
- {
- $sql = "SELECT * FROM t_region WHERE id=".Yii::app()->user->idregion()." LIMIT 0,1";
- $connection=Yii::app()->db;
- $command=$connection->createCommand($sql);
- $dataReader=$command->queryAll();
- echo CJSON::encode($dataReader);
- }
- protected function performAjaxValidation($model)
- {
- if(isset($_POST['ajax']) && $_POST['ajax']==='distribution-plan-form')
- {
- echo CActiveForm::validate($model);
- Yii::app()->end();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement