function journal($id, $isLive = false) { global $db, $auth, $insertstatements; if ($isLive) { $id = translateState($id, 10, false); } $this->id = $id; $this->userId = $auth->userId; $jnlCreated = getDBCell("journal", "CREATED", "ITEM_ID = $this->id"); if ($jnlCreated == 0) { $nextSlot = count($insertstatements); $journalInsert = new InsertSet("journal"); $journalInsert->setPK("JOURNAL_ID"); $journalInsert->add("ITEM_ID", $this->id, "NUMBER"); $journalInsert->add("CREATED", time(), "NUMBER"); $insertstatements[$nextSlot] = $journalInsert; $this->itemStatus["created"]["time"] = 0; //$this->itemStatus["created"]["by"] = $rstJournal->getValue("CREATED_BY"); $this->itemStatus["launched"]["time"] = 0; //$this->itemStatus["launched"]["by"] = $rstJournal->getValue("LAUNCHED_BY"); $this->itemStatus["expired"]["time"] = 0; //$this->itemStatus["expired"]["by"] = $rstJournal->getValue("EXPIRED_BY"); $this->itemStatus["changed"]["time"] = 0; //$this->itemStatus["changed"]["by"] = $rstJournal->getValue("CHANGED_BY"); $this->itemStatus["deleted"]["time"] = 0; //$this->itemStatus["deleted"]["by"] = $rstJournal->getValue("DELETED_BY"); $this->itemStatus["staged"]["time"] = 0; //$this->itemStatus["staged"]["by"] = $rstJournal->getValue("STAGED_BY"); $this->itemStatus["locked"]["time"] = 0; $this->itemStatus["locked"]["by"] = 0; } else { $rstJournal = new Recordset("journal", "*", "ITEM_ID = $this->id"); $this->itemStatus["created"]["time"] = $rstJournal->getValue("CREATED"); //$this->itemStatus["created"]["by"] = $rstJournal->getValue("CREATED_BY"); $this->itemStatus["launched"]["time"] = $rstJournal->getValue("LAUNCHED"); //$this->itemStatus["launched"]["by"] = $rstJournal->getValue("LAUNCHED_BY"); $this->itemStatus["expired"]["time"] = $rstJournal->getValue("EXPIRED"); //$this->itemStatus["expired"]["by"] = $rstJournal->getValue("EXPIRED_BY"); $this->itemStatus["changed"]["time"] = $rstJournal->getValue("CHANGED"); //$this->itemStatus["changed"]["by"] = $rstJournal->getValue("CHANGED_BY"); $this->itemStatus["deleted"]["time"] = $rstJournal->getValue("DELETED"); //$this->itemStatus["deleted"]["by"] = $rstJournal->getValue("DELETED_BY"); $this->itemStatus["staged"]["time"] = $rstJournal->getValue("STAGED"); //$this->itemStatus["staged"]["by"] = $rstJournal->getValue("STAGED_BY"); $this->itemStatus["locked"]["time"] = $rstJournal->getValue("LOCKED"); $this->itemStatus["locked"]["by"] = $rstJournal->getValue("LOCKED_BY"); } }
/** * the constructor takes the model and values passes in, assigns values to internal * vars, sets up the offset and limit on the model and use this->paginate * calls parent __construct * @param string $WaxModel * @param string $page * @param string $per_page */ public function __construct($model, $page, $per_page) { $this->per_page = $per_page; $this->current_page = $page; //setup model $this->model = $model; $this->model->_offset = ($page - 1) * $per_page; $this->model->_limit = $per_page; //paginate the model $rowset = $model->rows(); $this->set_count($model->total_without_limits); parent::__construct($model, $rowset); }
function kmImage($data = '') { if (is_array($data)) { parent::RecordSet($data); } }
public function query($sql) { $result = mysql_query($sql); if (!$result) { if ($this->err_log_file) { $this->txt_log($this->err_log_file, $sql); } die('SQL query error'); } $rs = new Recordset(); $rs->result = $result; $rs->record_count = mysql_num_rows($result); $rs->move_next(); return $rs; }