Example #1
0
 public function insertItem(Item $item)
 {
     $con = self::openConnection();
     mysqli_begin_transaction($con);
     $code = $item->getCode();
     $name = $item->getName();
     $parent = $item->getParent() == null ? '' : $item->getParent()->getCode();
     $sql = "INSERT INTO category (code, name, parent_category_id) VALUE ('{$code}', '{$name}', '{$parent}')";
     mysqli_query($con, $sql);
     $affected = mysqli_affected_rows($con);
     if ($affected == 1) {
         mysqli_commit($con);
     } else {
         mysqli_rollback($con);
     }
     return $affected;
 }
Example #2
0
 protected function uniteImplementationsRemoveLoop(Item $current, Item $implementationOf)
 {
     $parent = $current->getParent();
     if ($parent && $implementationOf->isDescendant($parent)) {
         while ($parent !== $implementationOf) {
             $parent->removeFromParent();
             $parent = $parent->getParent();
         }
     }
 }