Dolibarr\Code\Reception\Classes\Reception::delete()

Complexity

Conditions

23

Size

Total Lines	128
Code Lines	81

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function delete(User $user)
    {
        global $conf, $langs, $user;
        require_once constant('DOL_DOCUMENT_ROOT') . '/core/lib/files.lib.php';

        $error = 0;
        $this->error = '';


        $this->db->begin();

        // Stock control
        if (isModEnabled('stock') && !getDolGlobalInt('STOCK_CALCULATE_ON_RECEPTION') && $this->statut > 0) {

The property Dolibarr\Core\Base\CommonObject::$statut has been deprecated: Use $status instead.

            require_once DOL_DOCUMENT_ROOT . "/product/stock/class/mouvementstock.class.php";

            $langs->load("agenda");

            // Loop on each product line to add a stock movement
            $sql = "SELECT cd.fk_product, cd.subprice, ed.qty, ed.fk_entrepot, ed.eatby, ed.sellby, ed.batch, ed.rowid as receptiondet_batch_id";
            $sql .= " FROM " . MAIN_DB_PREFIX . "commande_fournisseurdet as cd,";
            $sql .= " " . MAIN_DB_PREFIX . "receptiondet_batch as ed";
            $sql .= " WHERE ed.fk_reception = " . ((int) $this->id);
            $sql .= " AND cd.rowid = ed.fk_elementdet";

            dol_syslog(get_class($this) . "::delete select details", LOG_DEBUG);
            $resql = $this->db->query($sql);
            if ($resql) {
                $cpt = $this->db->num_rows($resql);
                for ($i = 0; $i < $cpt; $i++) {
                    dol_syslog(get_class($this) . "::delete movement index " . $i);
                    $obj = $this->db->fetch_object($resql);

                    $mouvS = new MouvementStock($this->db);
                    // we do not log origin because it will be deleted
                    $mouvS->origin = null;

                    $result = $mouvS->livraison($user, $obj->fk_product, $obj->fk_entrepot, $obj->qty, 0, $langs->trans("ReceptionDeletedInDolibarr", $this->ref), '', $obj->eatby, $obj->sellby, $obj->batch); // Price is set to 0, because we don't want to see WAP changed
                }
            } else {
                $error++;
                $this->errors[] = "Error " . $this->db->lasterror();
            }
        }

        if (!$error) {
            $main = MAIN_DB_PREFIX . 'receptiondet_batch';
            $ef = $main . "_extrafields";

            $sqlef = "DELETE FROM " . $ef . " WHERE fk_object IN (SELECT rowid FROM " . $main . " WHERE fk_reception = " . ((int) $this->id) . ")";

            $sql = "DELETE FROM " . MAIN_DB_PREFIX . "receptiondet_batch";
            $sql .= " WHERE fk_reception = " . ((int) $this->id);

            if ($this->db->query($sqlef) && $this->db->query($sql)) {
                // Delete linked object
                $res = $this->deleteObjectLinked();
                if ($res < 0) {
                    $error++;
                }

                if (!$error) {
                    $sql = "DELETE FROM " . MAIN_DB_PREFIX . "reception";
                    $sql .= " WHERE rowid = " . ((int) $this->id);

                    if ($this->db->query($sql)) {
                        // Call trigger
                        $result = $this->call_trigger('RECEPTION_DELETE', $user);
                        if ($result < 0) {
                            $error++;
                        }
                        // End call triggers

                        if (!empty($this->origin) && $this->origin_id > 0) {
                            $this->fetch_origin();
                            if ($this->origin_object->statut == 4) {     // If order source of reception is "partially received"
                                // Check if there is no more reception. If not, we can move back status of order to "validated" instead of "reception in progress"
                                $this->origin_object->loadReceptions();
                                //var_dump($this->$origin->receptions);exit;
                                if (count($this->origin_object->receptions) <= 0) {
                                    $this->origin_object->setStatut(3); // ordered
                                }
                            }
                        }

                        if (!$error) {
                            $this->db->commit();

                            // We delete PDFs
                            $ref = dol_sanitizeFileName($this->ref);
                            if (!empty($conf->reception->dir_output)) {
                                $dir = $conf->reception->dir_output . '/' . $ref;
                                $file = $dir . '/' . $ref . '.pdf';
                                if (file_exists($file)) {
                                    if (!dol_delete_file($file)) {
                                        return 0;
                                    }
                                }
                                if (file_exists($dir)) {
                                    if (!dol_delete_dir_recursive($dir)) {
                                        $this->error = $langs->trans("ErrorCanNotDeleteDir", $dir);
                                        return 0;
                                    }
                                }
                            }

                            return 1;
                        } else {
                            $this->db->rollback();
                            return -1;
                        }
                    } else {
                        $this->error = $this->db->lasterror() . " - sql=$sql";
                        $this->db->rollback();
                        return -3;
                    }
                } else {
                    $this->error = $this->db->lasterror() . " - sql=$sql";
                    $this->db->rollback();
                    return -2;
                }
            } else {
                $this->error = $this->db->lasterror() . " - sql=$sql";
                $this->db->rollback();
                return -1;
            }
        } else {
            $this->db->rollback();
            return -1;
        }