PHP DBQuery::quote方法代码示例

 public function afterConstruct()
 {
     foreach ($this->Language->findAll() as $Language) {
         $modelName = 'Text' . ucFirst($Language->id);
         $this->bind($modelName, 'hasOne', array('class' => 'MediaText', 'foreignKey' => 'media_file_id', 'dependent' => true, 'conditions' => array($modelName . '.language_id' => DBQuery::quote($Language->id))));
         $this->{$modelName}->language_id = $Language->id;
     }
     return parent::afterConstruct();
 }

 /**
  *	Tests if the user is unique
  * 	@return boolean
  */
 public function isUnique()
 {
     $params = array('conditions' => array('User.email' => DBQuery::quote($this->email)));
     if ($this->exists()) {
         $params['conditions']['User.id <>'] = (int) $this->id;
     }
     if ($doubleUser = $this->find($params)) {
         return false;
     }
     return true;
 }

 public function similarEntries()
 {
     if (!$this->exists() || $this->Tags->count() == 0) {
         return false;
     }
     $queryFile = dirname(__FILE__) . '/../../console/sql/similarBlogPosts.sql';
     if (!file_exists($queryFile)) {
         return false;
     }
     $tmp = new IndexedArray();
     foreach ($this->Tags as $Tag) {
         $tmp[] = 'Tag.name = ' . DBQuery::quote($Tag->get('name'));
     }
     $tagConditions = $tmp->implode(' OR ');
     $query = sprintf(file_get_contents($queryFile), $tagConditions, $this->id);
     return $this->query($query);
 }

 public function toModel(Model $model, $fields = null, $ignore = null)
 {
     if ($model->behaviors->hasBehavior('Flagable')) {
         if ($this->hasField('allowComments')) {
             $model->setFlag(BlogPostFlag::ALLOW_COMMENTS, $this->allowComments->value());
         }
         if ($this->hasField('sticky')) {
             $model->setFlag(BlogPostFlag::STICKY, $this->sticky->value());
         }
     }
     // saving tags
     $this->Tags = new IndexedArray();
     $tags = array_filter(array_unique(preg_split('/\\s+/i', $this->tags->value())));
     foreach ($tags as $tag) {
         $Tag = new Tag(array('name' => $tag, 'model' => DBQuery::quote($model->name)));
         $Tag->set('BlogPostTag', array('model' => DBQuery::quote($model->name)));
         $model->Tags[] = $Tag;
     }
     return parent::toModel($model, $fields, $ignore);
 }

}
require_once $AppUI->getModuleClass('companies');
global $dPconfig, $canEdit, $stub, $where, $orderby;
$q = new DBQuery();
$q->addTable('users', 'u');
$q->addQuery('DISTINCT(user_id), user_username, contact_last_name, contact_first_name,
	permission_user, contact_email, company_name, contact_company');
$q->addJoin('contacts', 'con', 'user_contact = contact_id');
$q->addJoin('companies', 'com', 'contact_company = company_id');
$q->addJoin('permissions', 'per', 'user_id = permission_user');
$obj = new CCompany();
$companies = $obj->getAllowedRecords($AppUI->user_id, 'company_id,company_name', 'company_name');
if (count($companies) > 0) {
    $companyList = '0';
    foreach ($companies as $k => $v) {
        $companyList .= ', ' . $k;
    }
    $q->addWhere('user_company in (' . $companyList . ')');
}
if ($stub) {
    $q->addWhere("(UPPER(user_username) LIKE '{$stub}%'" . " OR UPPER(contact_first_name) LIKE '{$stub}%'" . " OR UPPER(contact_last_name) LIKE '{$stub}%')");
} else {
    if ($where) {
        $where = $q->quote("%{$where}%");
        $q->addWhere("(UPPER(user_username) LIKE {$where}" . " OR UPPER(contact_first_name) LIKE {$where}" . " OR UPPER(contact_last_name) LIKE {$where})");
    }
}
$q->addOrder($orderby);
$users = $q->loadList();
$canLogin = true;
require DP_BASE_DIR . '/modules/admin/vw_usr.php';

 function getDepartmentDetails()
 {
     $result = array('dept_id' => 0, 'dept_name' => '');
     if (!$this->contact_department) {
         return $result;
     }
     $sql = "select dept_id, dept_name from departments";
     $q = new DBQuery();
     $q->addTable('departments');
     $q->addQuery('dept_id, dept_name');
     if ($this->is_alpha($this->contact_department)) {
         $q->addWhere('dept_name = ' . $q->quote($this->contact_department));
     } else {
         $q->addWhere("dept_id = '" . $this->contact_department . "'");
     }
     $sql = $q->prepare();
     $q->clear();
     db_loadHash($sql, $result);
     return $result;
 }

function w2PgetUsersHashList($stub = null, $where = null, $orderby = 'contact_first_name, contact_last_name')
{
    global $AppUI;
    $q = new DBQuery();
    $q->addTable('users');
    $q->addQuery('DISTINCT(user_id), user_username, contact_last_name, contact_first_name,
		 contact_email, company_name, contact_company, dept_id, dept_name, CONCAT(contact_first_name,\' \',contact_last_name) contact_name, user_type');
    $q->addJoin('contacts', 'con', 'contact_id = user_contact', 'inner');
    if ($stub) {
        $q->addWhere('(UPPER(user_username) LIKE \'' . $stub . '%\' or UPPER(contact_first_name) LIKE \'' . $stub . '%\' OR UPPER(contact_last_name) LIKE \'' . $stub . '%\')');
    } elseif ($where) {
        $where = $q->quote('%' . $where . '%');
        $q->addWhere('(UPPER(user_username) LIKE ' . $where . ' OR UPPER(contact_first_name) LIKE ' . $where . ' OR UPPER(contact_last_name) LIKE ' . $where . ')');
    }
    $q->addGroup('user_id');
    $q->addOrder($orderby);
    // get CCompany() to filter by company
    $obj = new CCompany();
    $companies = $obj->getAllowedSQL($AppUI->user_id, 'company_id');
    $q->addJoin('companies', 'com', 'company_id = contact_company');
    if ($companies) {
        $q->addWhere('(' . implode(' OR ', $companies) . ' OR contact_company=\'\' OR contact_company IS NULL OR contact_company = 0)');
    }
    $dpt = new CDepartment();
    $depts = $dpt->getAllowedSQL($AppUI->user_id, 'dept_id');
    $q->addJoin('departments', 'dep', 'dept_id = contact_department');
    if ($depts) {
        $q->addWhere('(' . implode(' OR ', $depts) . ' OR contact_department=0)');
    }
    return $q->loadHashList('user_id');
}

 /**
  * Tries to find a node by the passed $idOrNodeName
  *	
  * @param integer|string $idOrNodeName
  * @return Node|boolean
  */
 public function findNode($idOrNodeName, $languageId = null)
 {
     $this->depth = 1;
     $languageId = coalesce(@$languageId, I18n::locale());
     if (is_int($idOrNodeName)) {
         $conditions = array('id' => $idOrNodeName);
     } else {
         $conditions = array('NodeText' . ucfirst(substr($languageId, 0, 2)) . '.uri' => DBQuery::quote($idOrNodeName));
     }
     return $this->find(array('conditions' => $conditions));
 }

 public function getDepartmentDetails()
 {
     $result = array('dept_id' => 0, 'dept_name' => '');
     if (!$this->contact_department) {
         return $result;
     }
     $q = new DBQuery();
     $q->addTable('departments');
     $q->addQuery('dept_id, dept_name');
     if ($this->is_alpha($this->contact_department)) {
         $q->addWhere('dept_name = ' . $q->quote($this->contact_department));
     } else {
         $q->addWhere('dept_id = ' . (int) $this->contact_department);
     }
     return $q->loadHash();
 }

 public function getModuleByName($name)
 {
     $q = new DBQuery();
     $name = $q->quote($name);
     $q->addTable('modules');
     $q->addQuery('mod_directory');
     $q->addWhere("permissions_item_table = '" . $name . "' OR mod_directory = '" . $name . "'");
     return $q->loadResult();
 }

 /**
  * Standard search action, searches for a $key $keyword match and lists
  * all matches
  * @deprecated move this to component
  * @param string $keyword
  */
 public function search($q = null, $fields = array())
 {
     $results = new IndexedArray();
     $this->data->set('q', $q);
     if (strlen($q) <= 0 || !isset($this->{$this->name}) || empty($fields)) {
         return $results;
     }
     foreach ($fields as $fieldname) {
         if (strstr($fieldname, '.') == false) {
             $conditions[] = $this->{$this->name}->name . '.' . $fieldname . ' LIKE ' . DBQuery::quote('%' . $q . '%') . ' OR';
         } else {
             $conditions[] = $fieldname . ' LIKE ' . DBQuery::quote('%' . $q . '%') . ' OR';
         }
     }
     $page = isset($this->params['page']) ? $this->params['page'] : 1;
     $pagination = $this->{$this->name}->paginate($page, null, $conditions);
     $pagination['url'] = Router::getRoute(lcfirst($this->name) . 'SearchPaged', array('q' => $q));
     $this->data->set('pagination', $pagination);
     $params = array('conditions' => $conditions, 'offset' => ($page - 1) * $this->{$this->name}->perPage, 'limit' => $this->{$this->name}->perPage);
     $results = $this->{$this->name}->findAll($params);
     $this->data->set(Inflector::pluralize($this->name), $results);
     return $results;
 }