public function actionCreateUser()
 {
     $this->layout = 'select_company_main';
     $model = new User();
     $ass_comp = new assignCompanyUserTable();
     //$model->setScenario('create');
     $auth_assign = new AuthAssignment();
     // Uncomment the following line if AJAX validation is needed
     $this->performAjaxValidation($model);
     if (isset($_POST['User'])) {
         $model->attributes = $_POST['User'];
         $model->user_password = md5($model->user_password . $model->user_password);
         $model->user_type = 'admin';
         $model->user_created_by = 1;
         $model->user_creation_date = new CDbExpression('NOW()');
         $model->user_organization_id = $_REQUEST['id'];
         if ($model->save()) {
             $ass_comp->assign_user_id = $model->user_id;
             $ass_comp->assign_org_id = $_REQUEST['id'];
             $ass_comp->assign_created_by = $model->user_id;
             $ass_comp->assign_creation_date = new CDbExpression('NOW()');
             $ass_comp->save();
             $auth_assign->itemname = 'SuperAdmin';
             $auth_assign->userid = $model->user_id;
             $auth_assign->save(false);
             $this->redirect(array('site/redirectLogin'));
         }
     }
     $this->render('create_user', array('model' => $model));
 }
	/**
	 * Manages all models.
	 */
	public function actionTransferemployee()
	{
		$model=new EmployeeTransaction('transferemployee');
		$info=new EmployeeInfo;
		$user =new User;
		$photo =new EmployeePhotos;
		$address=new EmployeeAddress;
		$lang=new LanguagesKnown;
		$ass_comp = new assignCompanyUserTable;
		$auth_assign = new AuthAssignment;

		$this->performAjaxValidation(array($info,$model,$user));
		if(!empty($_POST['user_id1']))
		{
			$model->attributes=$_POST['EmployeeTransaction'];
			$info->attributes=$_POST['EmployeeInfo'];
			
		
			$trans_id = $_POST['user_id1'];
			$old_model = EmployeeTransaction::model()->resetScope()->findByPk($trans_id);
			$old_info = EmployeeInfo::model()->findByPk($old_model->employee_transaction_employee_id);
			$old_info->transfer_left_remarks= $_POST['EmployeeTransaction']['transfer_left_remarks'];
			$old_info->employee_left_transfer_date = new CDbExpression('NOW()');
			$old_info->save(false);

			$old_model->employee_status = 1;
			$old_model->save();


			$user = User::model()->findByPk($old_model->employee_transaction_user_id);
			
			$user->user_created_by =  Yii::app()->user->id;
			$user->user_creation_date = new CDbExpression('NOW()');
			$user->user_organization_id = $_POST['EmployeeTransaction']['employee_transaction_organization_id'];
			
			if($user->save())
			{
			$org_data = Organization::model()->findByPk($_POST['EmployeeTransaction']['employee_transaction_organization_id']);
			$org_name = $org_data->organization_name;
			$org_arr = explode(' ',$org_name);
			$bizrule = 'return Yii::app()->user->getState("org_id")=='.$_POST['EmployeeTransaction']['employee_transaction_organization_id'].";";
			$var_data = serialize($_POST['EmployeeTransaction']['employee_transaction_organization_id']);
			$suffix_lab = '';
			foreach($org_arr as $list)
				$suffix_lab .= $list[0];


			$auth_assign->itemname = 'Employee of '.$suffix_lab;
			$check = AuthAssignment::model()->findByAttributes(array('itemname'=>$auth_assign->itemname,'userid' => $user->user_id,'data' =>$var_data));
			if(empty($check)){
			$auth_assign->userid = $user->user_id;
			$auth_assign->bizrule = $bizrule;
			$auth_assign->data = $var_data;
			
			$auth_assign->save();
			}

			$ass_comp->assign_user_id = $user->user_id;
			$ass_comp->assign_role_id = 3;
			$ass_comp->assign_org_id = $_POST['EmployeeTransaction']['employee_transaction_organization_id'];
			$ass_comp->assign_created_by = Yii::app()->user->id;
			$ass_comp->assign_creation_date = new CDbExpression('NOW()');
			$ass_comp->save();

			$info = $old_info;
			$info->employee_joining_date = new CDbExpression('NOW()');
			$info->employee_type = $_POST['EmployeeInfo']['employee_type'];
			$info->employee_attendance_card_id = '';
			$info->employee_created_by =  Yii::app()->user->id;
			$info->employee_creation_date = new CDbExpression('NOW()');
			$info->employee_left_transfer_date = NULL;
			$info->employee_id = null;
			$info->setIsNewRecord(true);
			$info->save(false);
			
			$model = $old_model;
			$model->employee_transaction_id = null;
			$model->setIsNewRecord(true);
			$model->employee_transaction_user_id = $user->user_id;
			$model->employee_transaction_employee_id = $info->employee_id;
			$model->employee_transaction_shift_id = $_POST['EmployeeTransaction']['employee_transaction_shift_id'];
			$model->employee_transaction_designation_id = $_POST['EmployeeTransaction']['employee_transaction_designation_id']; 
			$model->employee_transaction_department_id = $_POST['EmployeeTransaction']['employee_transaction_department_id'];
			$model->employee_transaction_organization_id = $_POST['EmployeeTransaction']['employee_transaction_organization_id'];
			$model->employee_status = 0;
			$model->save(false);
			EmployeeInfo::model()->updateByPk($model->employee_transaction_employee_id, array('employee_info_transaction_id'=>$model->employee_transaction_id));
			Yii::app()->user->setFlash('success',"Transfer of ".$info->employee_first_name.' to '.$org_name.' successfully.!');
			$this->redirect(array('employeeTransaction/admin'));	
			}
			
		}
		$this->render('transfer_employee',array(
			'model'=>$model,'info'=>$info,'user'=>$user,
		));

	}
	public function actionAprove($id)
	{
		$model= StudentRegistrationInfo::model()->findByPk($id);
		$info = new StudentInfo;
		$stud_trans = new StudentTransaction;
		$user =new User;
		$photo =new StudentPhotos;
		$address=new StudentAddress;
		$lang=new LanguagesKnown;
		$ass_comp = new assignCompanyUserTable;
		$auth_assign = new AuthAssignment;
		$qualification=new StudentAcademicRecordTrans;

		if(isset($_REQUEST['StudentRegistrationInfo']))
		{
			$org_id = $model->organization_id;
	
			if($model->student_status==1){

				$acd = Yii::app()->db->createCommand()
					->select("academic_term_id,academic_term_name,academic_term_period_id")
					->from('academic_term')
					->where('current_sem=1 and academic_term_name =1 and academic_term_organization_id='.$org_id)
					->queryAll();
			
				if(!$acd){
					Yii::app()->user->setFlash('notice','Semester-1 is not an Active semester');
					$this->redirect(array('admin'));
				}
				$info->student_dtod_regular_status = 'Regular';	
			}
			elseif($model->student_status==2){

				$acd = Yii::app()->db->createCommand()
					->select("academic_term_id,academic_term_name,academic_term_period_id")
					->from('academic_term')
					->where('current_sem=1 and academic_term_name =3 and academic_term_organization_id='.$org_id)
					->queryAll();
			
				if(!$acd){
					Yii::app()->user->setFlash('notice','Semester-3 is not an Active semester');
					$this->redirect(array('admin'));
				}	
				$info->student_dtod_regular_status = 'DTOD';
			}
			$info->title = 	$model->student_title;
			$info->student_merit_no = $model->student_merit_no;
			$info->student_first_name = $model->student_first_name;
			$info->student_middle_name =$model->student_middle_name;
			$info->student_last_name = $model->student_last_name;
			$info->student_father_name = $model->student_father_name;
			$info->student_mother_name = $model->student_mother_name;
			$info->student_dob = $model->student_dob;
			$info->student_adm_date =  new CDbExpression('NOW()');
			$info->student_birthplace = $model->student_place_of_birth;
			$info->student_gender = $model->student_gender;
			$info->student_email_id_1 = $model->student_email_id;
			$info->student_mobile_no = $model->student_mobile;
			$info->student_created_by = Yii::app()->user->id;
			$info->student_creation_date = new CDbExpression('NOW()');

			$user->user_organization_email_id = strtolower($info->student_email_id_1);
			$user->user_password =  md5($info->student_email_id_1.$info->student_email_id_1);
			$user->user_created_by =  Yii::app()->user->id;
			$user->user_creation_date = new CDbExpression('NOW()');
			$user->user_organization_id = $org_id;
			$user->user_type = "student";

			$photo->student_photos_path = $model->student_photo;
		
			$address->student_address_c_line1 = $model->student_address_c_line1;
			$address->student_address_c_line2 = $model->student_address_c_line2;
			$address->student_address_c_taluka = $model->student_address_c_taluka;
			$address->student_address_c_district = $model->student_address_c_district;
			$address->student_address_c_country = $model->student_address_c_country;
			$address->student_address_c_city = $model->student_address_c_city;
			$address->student_address_c_pin  = $model->student_address_c_pin ;
			$address->student_address_c_state = $model->student_address_c_state;
			$address->student_address_p_line1 = $model->student_address_p_line1;
			$address->student_address_p_line2 = $model->student_address_p_line2;
			$address->student_address_p_taluka = $model->student_address_p_taluka;
			$address->student_address_p_district = $model->student_address_p_district;
			$address->student_address_p_country = $model->student_address_p_country;
			$address->student_address_p_city = $model->student_address_p_city;
			$address->student_address_p_pin  = $model->student_address_p_pin ;
			$address->student_address_p_state = $model->student_address_p_state;
			$address->student_address_phone = $model->student_phoneno;
			$address->student_address_mobile = $model->student_mobile;

			if($info->save(false)){
				
				$user->save(false);
				$photo->save(false);
				$address->save(false);
				$lang->save(false);		
			
				$stud_trans->student_transaction_user_id = $user->user_id;
				$stud_trans->student_transaction_student_id = $info->student_id;
				//$stud_trans->student_transaction_branch_id = $model->student_branch_id;
				if(!empty($model->student_category_id))
				$stud_trans->student_transaction_category_id = $model->student_category_id;
				$stud_trans->student_transaction_organization_id = $org_id;
				$stud_trans->student_transaction_student_address_id = $address->student_address_id;
				$stud_trans->student_transaction_languages_known_id= $lang->languages_known_id;
				$stud_trans->student_transaction_detain_student_flag='5';
				$stud_trans->student_transaction_student_photos_id = $photo->student_photos_id;
				$stud_trans->student_transaction_branch_id=$_POST['StudentRegistrationInfo']['student_branch_id'];
				$stud_trans->student_academic_term_period_tran_id = $acd[0]['academic_term_period_id']; 
				$stud_trans->student_academic_term_name_id = $acd[0]['academic_term_id'];
				$stud_trans->save(false);

				StudentInfo::model()->updateByPk($stud_trans->student_transaction_student_id, array('student_info_transaction_id'=>$stud_trans->student_transaction_id));					
		
				$org_data = Organization::model()->findByPk($org_id);
				$org_name = $org_data->organization_name;
				$org_arr = explode(' ',$org_name);
				$suffix_lab = '';
				foreach($org_arr as $list)
					$suffix_lab .= $list[0];
				$bizrule = 'return Yii::app()->user->getState("org_id")=='.$org_id.";";
				$var_data = serialize(Yii::app()->user->getState('org_id'));

				$auth_assign->itemname = 'Student of '.$suffix_lab;
				$auth_assign->userid = $user->user_id;
				$auth_assign->bizrule = $bizrule;
				$auth_assign->data = $var_data;
				$auth_assign->save();

				$ass_comp->assign_user_id = $user->user_id;
				$ass_comp->assign_org_id = $org_id;
				$ass_comp->assign_created_by = Yii::app()->user->id;
				$ass_comp->assign_creation_date = new CDbExpression('NOW()');
				$ass_comp->save();
	
				StudentRegistrationInfo::model()->updateByPk($id, 
					array(
						'student_aproved'=>'1',
						));
				$this->redirect(array('admin'));
				}	
		}
		$this->render('aprove',array('model'=>$model));
	}