Storage for ilLSPostConditions. More...

Collaboration diagram for ilLSPostConditionDB:

Public Member Functions
	__construct (ilDBInterface $db)

	select (array $ref_ids)

	delete (array $ref_ids, ?ilDBInterface $db=null)

	upsert (array $ls_post_conditions)

Data Fields
const	TABLE_NAME = 'post_conditions'

const	STD_ALWAYS_OPERATOR = 'always'

Protected Member Functions
	insert (array $ls_post_conditions, ilDBInterface $db)

Protected Attributes
ilDBInterface	$db

Detailed Description

Storage for ilLSPostConditions.

Definition at line 24 of file class.ilLSPostConditionDB.php.

Constructor & Destructor Documentation

◆ __construct()

ilLSPostConditionDB::__construct ( ilDBInterface $db )

Definition at line 31 of file class.ilLSPostConditionDB.php.

References $db.

     {
         $this->db = $db;
     }

Member Function Documentation

◆ delete()

ilLSPostConditionDB::delete	(	array	$ref_ids,
		?ilDBInterface	$db = `null`
	)

Definition at line 73 of file class.ilLSPostConditionDB.php.

References $db, and ilDBInterface\manipulate().

                                                                      : void
     {
         if ($ref_ids === []) {
             return;
         }
 
         if (is_null($db)) {
             $db = $this->db;
         }
 
         $query =
               "DELETE FROM " . static::TABLE_NAME . PHP_EOL
             . "WHERE ref_id IN (" . implode(',', $ref_ids) . ")" . PHP_EOL
         ;
 
         $db->manipulate($query);
     }

Here is the call graph for this function:

◆ insert()

ilLSPostConditionDB::insert	(	array	$ls_post_conditions,
		ilDBInterface	$db
	)

protected

Definition at line 91 of file class.ilLSPostConditionDB.php.

References ilDBInterface\insert().

Referenced by upsert().

                                                                            : void
     {
         foreach ($ls_post_conditions as $condition) {
             $values = [
                 "ref_id" => ["integer", $condition->getRefId()],
                 "condition_operator" => ["text", $condition->getConditionOperator()],
                 "value" => ["text", $condition->getValue()]
             ];
             $db->insert(static::TABLE_NAME, $values);
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ select()

ilLSPostConditionDB::select ( array $ref_ids )

Returns: ilLSPostCondition[]

Definition at line 39 of file class.ilLSPostConditionDB.php.

References $data, $ref_id, and null.

                                           : array
     {
         if ($ref_ids === []) {
             return [];
         }
 
         $data = [];
         $query =
               "SELECT ref_id, condition_operator, value" . PHP_EOL
             . "FROM " . static::TABLE_NAME . PHP_EOL
             . "WHERE ref_id IN (" . implode(',', $ref_ids) . ")" . PHP_EOL
         ;
 
         $result = $this->db->query($query);
 
         while ($row = $this->db->fetchAssoc($result)) {
             $data[$row['ref_id']] = [$row['condition_operator'], $row['value']];
         }
 
         $conditions = [];
         foreach ($ref_ids as $ref_id) {
             //always-condition, standard
             $op = self::STD_ALWAYS_OPERATOR;
             $value = null;
 
             //if from db: proper values
             if (array_key_exists($ref_id, $data)) {
                 list($op, $value) = $data[$ref_id];
             }
             $conditions[] = new \ilLSPostCondition($ref_id, $op, $value);
         }
         return $conditions;
     }

◆ upsert()

ilLSPostConditionDB::upsert ( array $ls_post_conditions )

Parameters

ilLSPostCondition[]

Definition at line 106 of file class.ilLSPostConditionDB.php.

References $db, ilLSPostCondition\getRefId(), and insert().

                                                      : void
     {
         if ($ls_post_conditions === []) {
             return;
         }
 
         $ref_ids = array_map(
             fn (ilLSPostCondition $condition) => $condition->getRefId(),
             $ls_post_conditions
         );
 
         $ilAtomQuery = $this->db->buildAtomQuery();
         $ilAtomQuery->addTableLock(static::TABLE_NAME);
         $ilAtomQuery->addQueryCallable(
             function (ilDBInterface $db) use ($ref_ids, $ls_post_conditions): void {
                 $this->delete($ref_ids, $db);
                 $this->insert($ls_post_conditions, $db);
             }
         );
         $ilAtomQuery->run();
     }