Insert extra field in authitemchild table

Dhara · December 10, 2014, 12:06pm

Hello friends,

I am currently working on project. In which i used rights and user module. I add extra field "trade_comapny_id" in authitemchild table. Now at the time of assign permission when i click on assign link for any role it should insert trade_company_id into authitemchild with parant,child field.

I try to add in actionAssign() lines (AuthItemController)

                if( &#036;childName&#33;==null &amp;&amp; &#036;model-&gt;hasChild(&#036;childName)===false )


			&#036;model-&gt;addChild(&#036;childName,&#036;trade);

and also in (RDbAuthManager)

    public function addItemChild(&#036;itemName, &#036;childName,&#036;trade)


{


        


	// Make sure that the item doesn't already have this child.


	if( &#036;this-&gt;hasItemChild(&#036;itemName, &#036;childName,&#036;trade)===false )


		return parent::addItemChild(&#036;itemName, &#036;childName,&#036;trade);


}

but it gives me error…

So is there any solution to insert extra fields???

Please help me…

Dhara · December 10, 2014, 1:05pm

Hey friends i solve it.

i called one function after

public function actionAssign()

if( Yii::app()->request->isPostRequest===true )

	{


		&#036;model = &#036;this-&gt;loadModel();


		&#036;childName = &#036;this-&gt;getChildName();


                    &#036;trade=0;


                    //for revoke in authassignment table


                    &#036;itemName = &#036;this-&gt;getItemName();


                    &#036;item = &#036;this-&gt;_authorizer-&gt;authManager-&gt;getAssignmentsByItemName(&#036;itemName);


                    &#036;x=  array_keys(&#036;item);


                    if(&#036;item)


                    {


                         for(&#036;i=0;&#036;i&lt;count(&#036;item);&#036;i++)


                                       {


                                &#036;this-&gt;_authorizer-&gt;authManager-&gt;assign(&#036;childName, &#036;x[&#036;i]);


                                       }


                    } 


                    


		if( &#036;childName&#33;==null &amp;&amp; &#036;model-&gt;hasChild(&#036;childName)===false )


			&#036;model-&gt;addChild(&#036;childName);


                   


                    // by Dhara - add the trade_company_id - who logged in - in created by


                    &#036;this-&gt;addItemChildCreator(&#036;childName,&#036;itemName,&#036;trade);


             


                    


		// if AJAX request, we should not redirect the browser


		if( isset(&#036;_POST['ajax'])===false )


			&#036;this-&gt;redirect(array('authItem/permissions'));


	}


	else


	{


		throw new CHttpException(400, Rights::t('core', 'Invalid request. Please do not repeat this request again.'));


	};

}

in AuthItemController.

and the function in AuthItemController.

public function addItemChildCreator($childName,$itemName,$trade)

    {


       &#036;trade=0;


        Yii::app()-&gt;db-&gt;createCommand()


        -&gt;update('authitemchild', array(


            'trade_company_id'=&gt;&#036;trade,


        ), 'child=:child and parent=:parent',      array(':child'=&gt;&#036;childName,':parent'=&gt;&#036;itemName));


    }

Done It…