+global\Procurement::update()

Complexity

Conditions	22
Paths	> 20000

Size

Total Lines	124
Code Lines	85

Duplication

Lines	6
Ratio	4.84 %

Code Coverage

Tests	91
CRAP Score	22.3527

Importance

Changes

0

<?php
    function update($input)
    {
        if (!is_array($input)) {
            throw new Exception('Procurement->update(): $input er ikke et array');
        }
        $db = new DB_sql;

        $input = safeToDb($input);
        $validator = new Intraface_Validator($this->error);

        if (!isset($input['dk_invoice_date'])) {
            $input['dk_invoice_date'] = '';
        }
        $validator->isDate($input["dk_invoice_date"], "Fakturadato er ikke en gyldig dato");
        $date = new Intraface_Date($input["dk_invoice_date"]);
        if ($date->convert2db()) {
            $input["invoice_date"] = $date->get();
        } else {
            $input["invoice_date"] = '';
        }

        if (!isset($input['dk_delivery_date'])) {
            $input['dk_delivery_date'] = '';
        }
        $validator->isDate($input["dk_delivery_date"], "Leveringsdato er ikke en gyldig dato", "allow_empty");
        $date = new Intraface_Date($input["dk_delivery_date"]);
        if ($date->convert2db()) {
            $input["delivery_date"] = $date->get();
        } else {
            $input['delivery_date'] = $input['invoice_date'];
        }

        if (!isset($input['dk_payment_date'])) {
            $input['dk_payment_date'] = '';
        }
        $validator->isDate($input["dk_payment_date"], "Betalingsdato er ikke en gyldig dato", "allow_empty");
        $date = new Intraface_Date($input["dk_payment_date"]);
        if ($date->convert2db()) {
            $input["payment_date"] = $date->get();
        } else {
            $input['payment_date'] = $input['delivery_date'];
        }

        if (empty($input['number'])) {
            $input['number'] = 0;
        }
        $validator->isNumeric($input["number"], "Nummer er ikke et gyldigt nummer", "greater_than_zero");
        $db->query("SELECT id FROM procurement WHERE id != ".$this->id." AND intranet_id = ".$this->kernel->intranet->get("id")." AND number = ".$input["number"]);
        if ($db->nextRecord()) {
            $this->error->set("Nummeret er allerede benyttet");
        }

        if (!isset($input['vendor'])) {
            $input['vendor'] = '';
        }
        $validator->isString($input["vendor"], "Fejl i leverandør", "", "allow_empty");

        if (!isset($input['description'])) {
            $input['description'] = '';
        }
        $validator->isString($input["description"], "Fejl i beskrivelse", "", "");

        if (!isset($input['from_region_key'])) {
            $input['from_region_key'] = 0;
        }
        $region_types = $this->getRegionTypes();
        if (!isset($region_types[$input["from_region_key"]])) {
            $this->error->set("Ugyldig købsregion");
        }

        if (!isset($input['dk_price_items'])) {
            $input['dk_price_items'] = 0;
        }
        $validator->isDouble($input["dk_price_items"], "Varepris er ikke et gyldigt beløb", 'zero_or_greater');
        $amount = new Intraface_Amount($input["dk_price_items"]);
        if ($amount->convert2db()) {
            $input["price_items"] = $amount->get();
        }

        if (!isset($input['dk_price_shipment_etc'])) {
            $input['dk_price_shipment_etc'] = 0;
        }
        $validator->isDouble($input["dk_price_shipment_etc"], "Pris for forsendelse og andet er ikke et gyldigt beløb", 'zero_or_greater');
        $amount = new Intraface_Amount($input["dk_price_shipment_etc"]);
        if ($amount->convert2db()) {
            $input["price_shipment_etc"] = $amount->get();
        }

        if (!isset($input['dk_vat'])) {
            $input['dk_vat'] = 0;
        }
        $validator->isDouble($input["dk_vat"], "Moms er ikke et gyldigt beløb", 'zero_or_greater');
        $amount = new Intraface_Amount($input["dk_vat"]);
        if ($amount->convert2db()) {
            $input["vat"] = $amount->get();
        }

        if ($this->error->isError()) {
            return false;
        }

        $sql = "user_id = ".$this->kernel->user->get("id").",
            date_changed = NOW(),
            invoice_date = \"".$input["invoice_date"]."\",
            delivery_date = \"".$input["delivery_date"]."\",
            payment_date = \"".$input["payment_date"]."\",
            number = ".$input["number"].",
            vendor = \"".$input["vendor"]."\",
            description = \"".$input["description"]."\",
            from_region_key = ".$input["from_region_key"].",
            price_items = ".$input["price_items"].",
            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;
    }