/**
  *
  *
  * @param bool $pb_delete_related
  * @param array $pa_options
  *		dontCheckPrimaryValue = if set the is_primary state of other related representations is not considered during the delete
  * @param array $pa_fields
  * @param array $pa_table_list
  *
  * @return bool
  */
 public function delete($pb_delete_related = false, $pa_options = null, $pa_fields = null, $pa_table_list = null)
 {
     if (!isset($pa_options['dontCheckPrimaryValue']) && !$pa_options['dontCheckPrimaryValue']) {
         // make some other row primary
         $o_db = $this->getDb();
         if ($vn_representation_id = $this->getPrimaryKey()) {
             $qr_res = $o_db->query("\n\t\t\t\t\tSELECT oxor.relation_id\n\t\t\t\t\tFROM ca_objects_x_object_representations oxor\n\t\t\t\t\tINNER JOIN ca_object_representations AS o_r ON o_r.representation_id = oxor.representation_id\n\t\t\t\t\tWHERE\n\t\t\t\t\t\toxor.representation_id = ? AND oxor.is_primary = 1 AND o_r.deleted = 0\n\t\t\t\t\tORDER BY\n\t\t\t\t\t\toxor.rank, oxor.relation_id\n\t\t\t\t", (int) $vn_representation_id);
             while ($qr_res->nextRow()) {
                 // nope - force this one to be primary
                 $t_rep_link = new ca_objects_x_object_representations();
                 $t_rep_link->setTransaction($this->getTransaction());
                 if ($t_rep_link->load($qr_res->get('relation_id'))) {
                     $t_rep_link->setMode(ACCESS_WRITE);
                     $t_rep_link->set('is_primary', 0);
                     $t_rep_link->update();
                     if ($t_rep_link->numErrors()) {
                         $this->postError(2700, _t('Could not update primary flag for representation: %1', join('; ', $t_rep_link->getErrors())), 'ca_objects_x_object_representations->delete()');
                         return false;
                     }
                 } else {
                     $this->postError(2700, _t('Could not load object-representation link'), 'ca_objects_x_object_representations->delete()');
                     return false;
                 }
             }
         }
     }
     return parent::delete($pb_delete_related, $pa_options, $pa_fields, $pa_table_list);
 }
 /**
  * Override BaseModel::delete() because the cascading delete implemented there
  * doesn't properly remove related items if they're organized in a ad-hoc hierarchy.
  */
 public function delete($pb_delete_related = false, $pa_options = null, $pa_fields = null, $pa_table_list = null)
 {
     if ($pb_delete_related) {
         $this->removeAllItems();
     }
     return parent::delete($pb_delete_related, $pa_options, $pa_fields, $pa_table_list);
 }
Example #3
0
 /**
  * Override delete() to scramble the set_code before we soft-delete. This is useful
  * because the database field has a unique key that really enforces uniqueneness
  * and we might wanna reuse a code of a set we previously deleted.
  */
 public function delete($pb_delete_related = false, $pa_options = null, $pa_fields = null, $pa_table_list = null)
 {
     if ($vn_rc = parent::delete($pb_delete_related, $pa_options, $pa_fields, $pa_table_list)) {
         if (!caGetOption('hard', $pa_options, false)) {
             // only applies if we don't hard-delete
             $vb_we_set_transaction = false;
             if (!$this->inTransaction()) {
                 $o_t = new Transaction($this->getDb());
                 $this->setTransaction($o_t);
                 $vb_we_set_transaction = true;
             }
             $this->set('set_code', $this->get('set_code') . '_' . time());
             $this->update(array('force' => true));
             if ($vb_we_set_transaction) {
                 $this->removeTransaction(true);
             }
         }
     }
     return $vn_rc;
 }
 public function delete($pb_delete_related = false, $pa_options = null, $pa_fields = null, $pa_table_list = null)
 {
     $vn_rc = parent::delete($pb_delete_related, $pa_options, $pa_fields, $pa_table_list);
     if (!$this->numErrors()) {
         $this->opo_annotations_properties = null;
     }
     return $vn_rc;
 }
Example #5
0
    /**
     * Override delete() to scramble the set_code before we soft-delete. This is useful
     * because the database field has a unique key that really enforces uniqueneness
     * and we might wanna reuse a code of a set we previously deleted.
     */
    public function delete($pb_delete_related = false, $pa_options = null, $pa_fields = null, $pa_table_list = null)
    {
        $vb_web_set_change_log_unit_id = BaseModel::setChangeLogUnitID();
        if ($pb_delete_related) {
            // quickly delete all labels for all set items in this set
            $this->getDb()->query('DELETE FROM ca_set_item_labels WHERE item_id IN (SELECT item_id FROM ca_set_items WHERE set_id=?)', $this->getPrimaryKey());
            // quickly delete attribute values
            $this->getDb()->query('
				DELETE FROM ca_attribute_values WHERE attribute_id IN
				(SELECT attribute_id FROM ca_attributes WHERE table_num=? and row_id IN (SELECT item_id FROM ca_set_items WHERE set_id=7))
			', $this->tableNum(), $this->getPrimaryKey());
            // quickly delete attributes
            $this->getDb()->query('
				DELETE FROM ca_attributes WHERE table_num=? and row_id IN (SELECT item_id FROM ca_set_items WHERE set_id=7)
			', $this->tableNum(), $this->getPrimaryKey());
            // get list of set item ids
            $qr_items = $this->getDb()->query('SELECT item_id FROM ca_set_items WHERE set_id=?', $this->getPrimaryKey());
            $va_item_ids = $qr_items->getAllFieldValues('item_id');
            // nuke set items
            $this->getDb()->query('DELETE FROM ca_set_items WHERE set_id=?', $this->getPrimaryKey());
            // remove search indexing for deleted set items
            foreach ($va_item_ids as $vn_item_id) {
                $this->getSearchIndexer()->startRowUnIndexing($this->tableNum(), $vn_item_id);
                $this->getSearchIndexer()->commitRowUnIndexing($this->tableNum(), $vn_item_id);
            }
        }
        if ($vn_rc = parent::delete($pb_delete_related, $pa_options, $pa_fields, $pa_table_list)) {
            if (!caGetOption('hard', $pa_options, false)) {
                // only applies if we don't hard-delete
                $vb_we_set_transaction = false;
                if (!$this->inTransaction()) {
                    $o_t = new Transaction($this->getDb());
                    $this->setTransaction($o_t);
                    $vb_we_set_transaction = true;
                }
                $this->set('set_code', $this->get('set_code') . '_' . time());
                $this->update(array('force' => true));
                if ($vb_we_set_transaction) {
                    $this->removeTransaction(true);
                }
            }
        }
        if ($vb_web_set_change_log_unit_id) {
            BaseModel::unsetChangeLogUnitID();
        }
        return $vn_rc;
    }
 /**
  * 
  */
 public function delete($pb_delete_related = false, $pa_options = null, $pa_fields = null, $pa_table_list = null)
 {
     $t_left = $this->getAppDatamodel()->getInstanceByTableNum($this->getLeftTableNum());
     $vn_left_id = $this->get($this->getLeftTableFieldName());
     $vn_right_id = $this->get($this->getRightTableFieldName());
     $t_right = $this->getAppDatamodel()->getInstanceByTableNum($this->getRightTableNum());
     if ($vn_rc = parent::delete($pb_delete_related, $pa_options, $pa_fields, $pa_table_list)) {
         foreach (array($this->getRightTableName() => $t_left, $this->getLeftTableName() => $t_right) as $vs_other_table_name => $t_instance) {
             if ((bool) $t_instance->getProperty('SUPPORTS_ACL_INHERITANCE')) {
                 if (is_array($va_inheritors = $t_instance->getProperty('ACL_INHERITANCE_LIST')) && in_array($vs_other_table_name, $va_inheritors)) {
                     ca_acl::applyACLInheritanceToRelatedRowFromRow($t_instance, $vs_other_table_name == $this->getLeftTableName() ? $vn_right_id : $vn_left_id, $vs_other_table_name, $vs_other_table_name == $this->getLeftTableName() ? $vn_left_id : $vn_right_id, array('deleteACLOnly' => true));
                 }
             }
         }
     }
     return $vn_rc;
 }