composants orm object conditions - yamsuz/damix GitHub Wiki

ORM - Gestion des conditions

Récupérer les conditions

getConditionsClear

La fonction ''getConditionsClear'' de l'objet des orm (FactoryBase) vous permet de récupérer l'ensemble des conditions de cette fonction et de vider les conditions précédemment ajouter

Le paramètre ''$name'' permet de récupérer les conditions des sous requêtes.

public function getConditionsClear( string $method, string $name = 'default' ) : \damix\engines\orm\conditions\OrmCondition

exemple :

$orm = \damix\engines\orm\Orm::get('[monModule]~[monorm]' );
$c = $orm->getConditionsClear( '[maFonction]' );

getConditions

La fonction ''getConditions'' de l'objet des orm (FactoryBase) vous permet de récupérer l'ensemble des conditions de cette fonction.

Le paramètre ''$name'' permet de récupérer les conditions des sous requêtes.

public function getConditions( string $method, string $name = 'default' ) : \damix\engines\orm\conditions\OrmCondition

exemple :

$orm = \damix\engines\orm\Orm::get('[monModule]~[monorm]' );
$c = $orm->getConditions( '[maFonction]' );

getConditionsAll

La fonction ''getConditionsAll'' de l'objet des orm (FactoryBase) vous permet de récupérer l'ensemble des conditions de cette fonction

public function getConditions( string $method, string $name = 'default' ) : \damix\engines\orm\conditions\OrmCondition

exemple :

$orm = \damix\engines\orm\Orm::get('[monModule]~[monorm]' );
$c = $orm->getConditions( '[maFonction]' );

Gestions des Conditions

clear

public function clear() : void

addGroupBegin

public function addGroupBegin( string $name = '' ) : void

exemple

$c = $orm->getConditions();
$c->addGroupBegin();
$c->addInt( array( 'table' => '[maTable]', 'field' => '[maPropriete]'), \damix\engines\orm\conditions\OrmOperator::ORM_OP_EQ, 1);
$c->addLogic( \damix\engines\orm\conditions\OrmOperator::ORM_OP_AND );
$c->addString( '[maTable]', \damix\engines\orm\conditions\OrmOperator::ORM_OP_EQ, '[maPropriete2]');
$c->addGroupEnd();

addGroupEnd

public function addGroupEnd( string $name = '' ) : void

exemple

$c = $orm->getConditions();
$c->addGroupBegin();
$c->addInt( array( 'table' => '[maTable]', 'field' => '[maPropriete]'), \damix\engines\orm\conditions\OrmOperator::ORM_OP_EQ, 1);
$c->addLogic( \damix\engines\orm\conditions\OrmOperator::ORM_OP_AND );
$c->addString( '[maTable]', \damix\engines\orm\conditions\OrmOperator::ORM_OP_EQ, '[maPropriete2]');
$c->addGroupEnd();

addLogic

public function addLogic( \damix\engines\orm\conditions\OrmOperator $value = \damix\engines\orm\conditions\OrmOperator::ORM_OP_AND, string $name = '' ) : void

Dans le cas où la fonction n'est pas appelé, la valeur par défaut et ''\damix\engines\orm\conditions\OrmOperator::ORM_OP_AND''

exemple

$c = $orm->getConditions();
$c->addGroupBegin();
$c->addInt( array( 'table' => '[maTable]', 'field' => '[maPropriete]'), \damix\engines\orm\conditions\OrmOperator::ORM_OP_EQ, 1);
$c->addLogic( \damix\engines\orm\conditions\OrmOperator::ORM_OP_AND );
$c->addString( '[maTable]', \damix\engines\orm\conditions\OrmOperator::ORM_OP_EQ, '[maPropriete2]');
$c->addGroupEnd();

addString

public function addString( string|array|\damix\engines\orm\request\structure\OrmFormula $property, ?\damix\engines\orm\conditions\OrmOperator $operator, string|array $value, string $name = '' ) : void

exemple :

$orm = \damix\engines\orm\Orm::get('[monModule]~[monorm]' );
$c = $orm->getConditionsClear( '[maFonction]' );
$c->addString( array( 'table' => '[maTable]', 'field' => '[maPropriete]'), \damix\engines\orm\conditions\OrmOperator::ORM_OP_EQ, 'maChaine' );

addInt

public function addInt( string|array $property, ?\damix\engines\orm\conditions\OrmOperator $operator, int|array $value, string $name = '' ) : void

exemple :

$orm = \damix\engines\orm\Orm::get('[monModule]~[monorm]' );
$c = $orm->getConditionsClear( '[maFonction]' );
$c->addInt( array( 'table' => '[maTable]', 'field' => '[maPropriete]'), \damix\engines\orm\conditions\OrmOperator::ORM_OP_EQ, 5 );

addBool

public function addBool( string|array $property, ?\damix\engines\orm\conditions\OrmOperator $operator, bool|array $value, string $name = '' ) : void

exemple :

$orm = \damix\engines\orm\Orm::get('[monModule]~[monorm]' );
$c = $orm->getConditionsClear( '[maFonction]' );
$c->addBool( array( 'table' => '[maTable]', 'field' => '[maPropriete]'), \damix\engines\orm\conditions\OrmOperator::ORM_OP_EQ, true );

addDecimal

public function addDecimal( string|array $property, ?\damix\engines\orm\conditions\OrmOperator $operator, float|array $value, string $name = '' ) : void

exemple :

$orm = \damix\engines\orm\Orm::get('[monModule]~[monorm]' );
$c = $orm->getConditionsClear( '[maFonction]' );
$c->addDecimal( array( 'table' => '[maTable]', 'field' => '[maPropriete]'), \damix\engines\orm\conditions\OrmOperator::ORM_OP_EQ, 7.54 );

addDate

public function addDate( string|array $property, ?\damix\engines\orm\conditions\OrmOperator $operator, \damix\engines\tools\xDate $value, string $name = '' ) : void

exemple :

$orm = \damix\engines\orm\Orm::get('[monModule]~[monorm]' );
$c = $orm->getConditionsClear( '[maFonction]' );
$c->addDate( array( 'table' => '[maTable]', 'field' => '[maPropriete]'), \damix\engines\orm\conditions\OrmOperator::ORM_OP_EQ, new \damix\engines\tools\xDate() );

addDateTime

public function addDateTime( string|array $property, ?\damix\engines\orm\conditions\OrmOperator $operator, \damix\engines\tools\xDate $value, string $name = '' ) : void

exemple :

$orm = \damix\engines\orm\Orm::get('[monModule]~[monorm]' );
$c = $orm->getConditionsClear( '[maFonction]' );
$c->addDate( array( 'table' => '[maTable]', 'field' => '[maPropriete]'), \damix\engines\orm\conditions\OrmOperator::ORM_OP_EQ, new \damix\engines\tools\xDate() );

addPeriod

public function addPeriod( string|array $property, ?\damix\engines\tools\xDate $value1, ?\damix\engines\tools\xDate $value2, string $name = '' ) : void

exemple :

$orm = \damix\engines\orm\Orm::get('[monModule]~[monorm]' );
$c = $orm->getConditionsClear( '[maFonction]' );
$c->addPeriod( array( 'table' => '[maTable]', 'field' => '[maPropriete]'), \damix\engines\tools\xDate::load('15/06/2023'), \damix\engines\tools\xDate::load('31/07/2023') );

addNull

public function addNull( string|array|\damix\engines\orm\request\structure\OrmFormula $property, string $name = '' ) : void

exemple :

$orm = \damix\engines\orm\Orm::get('[monModule]~[monorm]' );
$c = $orm->getConditionsClear( '[maFonction]' );
$c->addNull( array( 'table' => '[maTable]', 'field' => '[maPropriete]') );

Gestion des sous-requêtes

	</display>
	<joins>
		<join type="subrequest" name="ssfilm" selector="video~sormstats" function="film_annee" alias="stat"/>
	</joins>
</method>

<method type="select" name="film_annee">
	<display>
		
		<property ref="video~tormfilm:annee" alias="annee"/>
		
	</display>
	<joins>
		<join type="from" ref="video~tormfilm" />
		
		<join type="join" ref="video~tormgenre:idgenre" join="left">
			<condition ref="video~tormgenre:idgenre" with="video~tormfilm:idgenre" />
		</join>
	</joins>
</method>

$orm = \damix\engines\orm\Orm::get('[monModule]~[monorm]' ); $cvideoliste = $orm->getConditionsClear( 'videoliste' ); $cvideoliste->addString( array( 'field' => 'annee'), \damix\engines\orm\conditions\OrmOperator::ORM_OP_GTEQ, '1970' );

$cfilmannee = $orm->getConditionsClear( 'videoliste', 'ssfilm' ); $cfilmannee->addString( array( 'field' => 'idfilm'), \damix\engines\orm\conditions\OrmOperator::ORM_OP_LTEQ, '50' );

$liste = $orm->videoliste();
⚠️ **GitHub.com Fallback** ⚠️