示例#1
0
 /**
  * @return Connection
  */
 public function getConnection()
 {
     if (!$this->connection) {
         $this->connection = Database::connection();
     }
     return $this->connection;
 }
示例#2
0
 /**
  * {@inheritDoc}
  */
 public function handle()
 {
     $this->setPageTitle("concrete5 has encountered an issue.");
     $result = self::QUIT;
     $enabled = Config::get('concrete.debug.display_errors');
     if ($enabled) {
         $detail = Config::get('concrete.debug.detail', 'message');
         if ($detail === 'debug') {
             $this->addDetails();
             $result = parent::handle();
         } else {
             $e = $this->getInspector()->getException();
             Core::make('helper/concrete/ui')->renderError(t('An unexpected error occurred.'), h($e->getMessage()));
         }
     } else {
         Core::make('helper/concrete/ui')->renderError(t('An unexpected error occurred.'), t('An error occurred while processing this request.'));
     }
     if (Config::get('concrete.log.errors')) {
         try {
             $e = $this->getInspector()->getException();
             $db = Database::get();
             if ($db->isConnected()) {
                 $l = new Logger(LOG_TYPE_EXCEPTIONS);
                 $l->emergency(sprintf("Exception Occurred: %s:%d %s (%d)\n", $e->getFile(), $e->getLine(), $e->getMessage(), $e->getCode()), array($e));
             }
         } catch (\Exception $e) {
         }
     }
     return $result;
 }
 public function delete()
 {
     $db = Database::connection();
     $db->Execute('delete from AttributeFormsAttributeValues where afID = ? and akID = ? and avID = ?', array($this->item->getID(), $this->attributeKey->getAttributeKeyID(), $this->getAttributeValueID()));
     // Before we run delete() on the parent object, we make sure that attribute value isn't being referenced in the table anywhere else
     $num = $db->GetOne('select count(avID) from AttributeFormsAttributeValues where avID = ?', array($this->getAttributeValueID()));
     if ($num < 1) {
         parent::delete();
     }
 }
 public function setAttributes($attributes)
 {
     if (is_array($attributes)) {
         $db = Database::connection();
         $db->Execute('DELETE FROM AttributeFormTypeAttributes WHERE aftID = ?', array($this->getID()));
         $sortOrder = 1;
         foreach ($attributes as $akID) {
             $data = ['aftID' => $this->getID(), 'akID' => $akID, 'sortOrder' => $sortOrder++];
             $db->insert('AttributeFormTypeAttributes', $data);
         }
     }
 }
 /**
  * {@inheritDoc}
  */
 public function handle()
 {
     $this->setPageTitle("concrete5 has encountered an issue.");
     if (Config::get('concrete.log.errors')) {
         try {
             $e = $this->getInspector()->getException();
             $db = Database::get();
             if ($db->isConnected()) {
                 $l = new Logger(LOG_TYPE_EXCEPTIONS);
                 $l->emergency(t('Exception Occurred: ') . sprintf("%s:%d %s (%d)\n", $e->getFile(), $e->getLine(), $e->getMessage(), $e->getCode()), array($e));
             }
         } catch (Exception $e) {
         }
     }
     $debug = Config::get('concrete.debug.level', 0);
     if ($debug === DEBUG_DISPLAY_ERRORS) {
         $this->addDetails();
         return parent::handle();
     }
     Core::make('helper/concrete/ui')->renderError(t('An unexpected error occurred.'), t('An error occurred while processing this request.'));
     Core::shutdown();
 }
示例#6
0
 public static function getParametersForQuery($query)
 {
     $db = Database::get();
     return $db->GetCol('select params from SystemDatabaseQueryLog where query = ? order by params asc', array($query));
 }
示例#7
0
 public function update($pTemplateHandle, $pTemplateName, $pTemplateIcon = FILENAME_PAGE_TEMPLATE_DEFAULT_ICON)
 {
     $this->pTemplateHandle = $pTemplateHandle;
     $this->pTemplateName = $pTemplateName;
     $this->pTemplateIcon = $pTemplateIcon;
     $em = Database::get()->getEntityManager();
     $em->persist($this);
     $em->flush();
 }
 public function delete()
 {
     parent::delete();
     $db = Database::connection();
     $r = $db->Execute('select avID from AttributeFormsAttributeValues where akID = ?', array($this->getAttributeKeyID()));
     while ($row = $r->FetchRow()) {
         $db->Execute('delete from AttributeValues where avID = ?', array($row['avID']));
     }
     $db->Execute('delete from AttributeFormsAttributeValues where akID = ?', array($this->getAttributeKeyID()));
 }
 public function deleteValue()
 {
     $db = Database::connection();
     $db->Execute('delete from atAttributeSwitcher where avID = ?', array($this->getAttributeValueID()));
 }
 public function getAttributeValueObject($ak, $createIfNotFound = false)
 {
     $db = Database::connection();
     $av = false;
     $v = array($this->getID(), $ak->getAttributeKeyID());
     $avID = $db->GetOne("select avID from AttributeFormsAttributeValues where afID = ? and akID = ?", $v);
     if ($avID > 0) {
         $av = AttributeFormValue::getByID($avID);
         if (is_object($av)) {
             $av->setAttributeForm($this);
             $av->setAttributeKey($ak);
         }
     }
     if ($createIfNotFound) {
         $cnt = 0;
         // Is this avID in use ?
         if (is_object($av)) {
             $cnt = $db->GetOne("select count(avID) from AttributeFormsAttributeValues where avID = ?", $av->getAttributeValueID());
         }
         if (!is_object($av) || $cnt > 1) {
             $av = $ak->addAttributeValue();
         }
     }
     return $av;
 }