public function fetch() { $db = new dbConnection(); if ($this->name != "") { //$res = $db->exec_sp("getProject", array($this->name)); $res = $db->do_query("SELECT * FROM project WHERE name = '{$this->name}'"); if ($res !== true) { return $res; } while ($arr = $db->get_row_array()) { $this->fromArr($arr); } if (preg_match('/^ec_ade::/', $this->submission_id)) { $this->submission_id = str_replace('ec_ade::', '', $this->submission_id); $this->allowDownloadEdits = true; } $db = new dbConnection(); //get forms $res = $db->exec_sp("getForms", array($this->name)); if ($res === true) { while ($arr = $db->get_row_array()) { $frm = new EcTable($this); $frm->fromArray($arr); //get fields $frm->fetch(); //get options if ($frm->number > 0) { $this->tables[$frm->name] = $frm; } } foreach ($this->tables as $tname => $tbl) { foreach ($tbl->branches as $branch) { $this->tables[$branch]->branchOf = $tname; } } } else { return false; } } }
public function addToDb() { global $db; if (!$db) { $db = new dbConnection(); } $qry = "SELECT idFieldType FROM FieldType where name = '{$this->type}'"; $db->do_query($qry); while ($arr = $db->get_row_array()) { $fieldType = $arr["idFieldType"]; } $lbl = mysql_escape_string($this->label); $qry = "INSERT INTO Field (form, projectName, formName, type, name, label, language, regex, title, `key`, isinteger, isdouble, active, doubleentry, jump, required, search, group_form, branch_form, display, genkey, date, time, setdate, settime, position) VALUES\n\t\t\t\t\t\t\t\t ({$this->form->id}, '{$this->form->survey->name}', '{$this->form->name}', {$fieldType}, '{$this->name}','{$lbl}', '{$this->language}',"; $qry .= $this->regex != "" ? "'{$this->regex}'," : "NULL,"; $qry .= $this->title ? "1," : "0,"; $qry .= $this->key ? "1," : "0,"; $qry .= $this->isInt ? "1," : "0,"; $qry .= $this->isDouble ? "1," : "0,"; $qry .= "1,"; $qry .= $this->doubleEntry ? "1," : "0,"; $qry .= $this->jump ? "'{$this->jump}'," : "NULL,"; $qry .= $this->required ? "1," : "0,"; $qry .= $this->search ? "1," : "0,"; $qry .= $this->group_form ? "'{$this->group_form}'," : "NULL,"; $qry .= $this->branch_form ? "'{$this->branch_form}'," : "NULL,"; $qry .= $this->display ? "1," : "0,"; $qry .= $this->genkey ? "1," : "0,"; $qry .= $this->date ? "'{$this->date}'," : "NULL,"; $qry .= $this->time ? "'{$this->time}'," : "NULL,"; $qry .= $this->setDate ? "'{$this->setDate}'," : "NULL,"; $qry .= $this->setTime ? "'{$this->setTime}'," : "NULL,"; $qry .= "{$this->position})"; $res = $db->do_query($qry); if ($res === true) { foreach ($this->options as $opt) { $res = $db->exec_sp("addOption", array($this->form->survey->name, $this->form->name, $this->name, $opt->idx, $opt->label, $opt->value)); if ($res !== true) { return $res; } } } return $res; }