/** * Construct the column model of the grid. The model can be passed as array * or can be constructed from sql. See _setSQL() to determine which SQL is * used. The method try to determine the primary key and if it is found is * set as key:true to the appropriate field. If the primary key can not be * determined set the first field as key:true in the colModel. * Return true on success. * @see _setSQL * @param array $model if set construct the model ignoring the SQL command * @param array $params if a sql command is used parametters passed to the SQL * @param array $labels if this parameter is set it set the labels in colModel. * The array should be associative which key value correspond to the name of * colModel * @return boolean */ public function setColModel(array $model = null, array $params = null, array $labels = null) { $goper = $this->oper ? $this->oper : 'nooper'; // excel, nooper, !(in_array....) if ($goper == 'nooper' || $goper == $this->GridParams["excel"] || $goper == "pdf" || $goper == "csv") { $runme = true; } else { $runme = !in_array($goper, array_values($this->GridParams)); } if ($runme) { if (is_array($model) && count($model) > 0) { $this->colModel = $model; return true; } $sql = null; $sqlId = $this->_setSQL(); if (!$sqlId) { return false; } $nof = $this->dbtype == 'sqlite' || $this->dbtype == 'db2' || $this->dbtype == 'array' || $this->dbtype == 'mongodb' ? 1 : 0; //$sql = $this->parseSql($sqlId, $params); $ret = $this->execute($sqlId, $params, $sql, true, $nof, 0); //$this->execute($sqlId, $params, $sql, $limit, $nrows, $offset) if ($ret) { if (is_array($labels) && count($labels) > 0) { $names = true; } else { $names = false; } $colcount = jqGridDB::columnCount($sql); for ($i = 0; $i < $colcount; $i++) { $meta = jqGridDB::getColumnMeta($i, $sql); if (strtolower($meta['name']) == 'jqgrid_row') { continue; } //Oracle, IBM DB2 if ($names && array_key_exists($meta['name'], $labels)) { $this->colModel[] = array('label' => $labels[$meta['name']], 'name' => $meta['name'], 'index' => $meta['name'], 'sorttype' => jqGridDB::MetaType($meta, $this->dbtype)); } else { $this->colModel[] = array('name' => $meta['name'], 'index' => $meta['name'], 'sorttype' => jqGridDB::MetaType($meta, $this->dbtype)); } } jqGridDB::closeCursor($sql); if ($this->primaryKey) { $pk = $this->primaryKey; } else { $pk = jqGridDB::getPrimaryKey($this->table, $this->pdo, $this->dbtype); $this->primaryKey = $pk; } if ($pk) { $this->setColProperty($pk, array("key" => true)); } else { $this->colModel[0] = array_merge($this->colModel[0], array("key" => true)); } } else { $this->errorMessage = jqGridDB::errorMessage($sql); if ($this->showError) { $this->sendErrorHeader(); } return $ret; } } if ($goper == $this->GridParams["excel"]) { // notify all other set methods not to be executed $this->runSetCommands = false; } else { if (!$runme) { $this->runSetCommands = false; } } return true; }
public function setColModel(array $model = null, array $params = null, array $labels = null) { $oper = $this->GridParams["oper"]; $goper = jqGridUtils::GetParam($oper, 'nooper'); if ($goper == 'nooper' || $goper == $this->GridParams["excel"]) { $runme = true; } else { $runme = !in_array($goper, array_values($this->GridParams)); } if ($runme) { if (is_array($model) && count($model) > 0) { $this->colModel = $model; return true; } $sql = null; $sqlId = $this->_setSQL(); if (!$sqlId) { return false; } $nof = $this->dbtype == 'sqlite' || $this->dbtype == 'db2' ? 1 : 0; $ret = $this->execute($sqlId, $params, $sql, true, $nof, 0); if ($ret === true) { if (is_array($labels) && count($labels) > 0) { $names = true; } else { $names = false; } $colcount = jqGridDB::columnCount($sql); for ($i = 0; $i < $colcount; $i++) { $meta = jqGridDB::getColumnMeta($i, $sql); if (strtolower($meta['name']) == 'jqgrid_row') { continue; } if ($names && array_key_exists($meta['name'], $labels)) { $this->colModel[] = array('label' => $labels[$meta['name']], 'name' => $meta['name'], 'index' => $meta['name'], 'editable' => true, 'sorttype' => jqGridDB::MetaType($meta, $this->dbtype)); } else { $this->colModel[] = array('name' => $meta['name'], 'index' => $meta['name'], 'editable' => true, 'sorttype' => jqGridDB::MetaType($meta, $this->dbtype)); } } jqGridDB::closeCursor($sql); if ($this->primaryKey) { $pk = $this->primaryKey; } else { $pk = jqGridDB::getPrimaryKey($this->table, $this->pdo, $this->dbtype); $this->primaryKey = $pk; } if ($pk) { $this->setColProperty($pk, array("key" => true)); } else { $this->colModel[0] = array_merge($this->colModel[0], array("key" => true)); } } else { return false; } } if ($goper == $this->GridParams["excel"]) { $this->runSetCommands = false; } else { if (!$runme) { $this->runSetCommands = false; } } return true; }