intraface / intraface.dk

    {

        $identifier = strip_tags($identifier);

        if (!empty($identifier)) {

            $this->db->query("SELECT site_id, id FROM cms_page WHERE identifier = '" . $identifier . "' AND intranet_id = " . $this->kernel->intranet->get('id') . " AND active = 1 AND site_id = " . $site_id);

        } else {

            // @todo choose the default page - vi skal lige have noget med publish og expire date her ogs�

            $this->db->query("SELECT site_id, id FROM cms_page WHERE intranet_id = " . $this->kernel->intranet->get('id') . " AND active = 1 AND status_key = 1 AND site_id = " . $site_id . " ORDER BY position ASC LIMIT 1");

        }

        if (!$this->db->nextRecord()) {

            $this->db->query("SELECT site_id, id FROM cms_page WHERE id = " . (int)$identifier . " AND intranet_id = " . $this->kernel->intranet->get('id') . " AND active = 1 AND site_id = " . $site_id);

            if (!$this->db->nextRecord()) {

        $db = new DB_Sql;

        if ($this->id > 0) {

            $db->query("UPDATE onlinepayment SET ".$sql." WHERE intranet_id = ".$this->kernel->intranet->get('id')." AND id = ".$this->id);

        } else {

            $db->query("INSERT INTO onlinepayment SET ".$sql.",

                intranet_id = ".$this->kernel->intranet->get('id').",

                date_created = NOW()");

            $this->id = $db->insertedId();

        }

        $this->load();

        return $this->id;

    }

            price_shipment_etc = ".$input["price_shipment_etc"].",

            vat = ".$input["vat"]."";

        if ($this->id != 0) {

            $db->query("UPDATE procurement SET ".$sql." WHERE id = ".$this->id." AND intranet_id = ".$this->kernel->intranet->get("id"));

        } else {

            $db->query("INSERT INTO procurement SET intranet_id = ".$this->kernel->intranet->get("id").", date_created = NOW(), active = 1, ".$sql);

            $this->id = $db->insertedId();

        }

        $this->load();

        return true;