XoopsModules25x / oledrion

class/Exports/DbaseExport.php

<?php

namespace XoopsModules\Oledrion\Exports;

/*
 You may not change or alter any portion of this comment or credits
 of supporting developers from this source code or any supporting source code
 which is considered copyrighted (c) material of the original comment or credit authors.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
*/

/**
 * oledrion
 *
 * @copyright   {@link https://xoops.org/ XOOPS Project}
 * @license     {@link http://www.fsf.org/copyleft/gpl.html GNU public license}
 * @author      Hervé Thouzard (http://www.herve-thouzard.com/)
 */

/**
 * Export au format Dbase 3
 */

use XoopsModules\Oledrion;
use XoopsModules\Oledrion\Constants;

// defined('XOOPS_ROOT_PATH') || die('Restricted access');

/**
 * Class DbaseExport
 */
class DbaseExport extends Export
{
    /**
     * DbaseExport constructor.
     * @param string|array $parameters
     */
    public function __construct($parameters = '')
    {
        if (!is_array($parameters)) {
            $this->filename  = 'oledrion.dbf';
            $this->folder    = OLEDRION_CSV_PATH;
            $this->url       = OLEDRION_CSV_URL;
            $this->orderType = Constants::OLEDRION_STATE_VALIDATED;
        }
        parent::__construct($parameters);
    }

    /**
     * Export des données
     * @return bool Vrai si l'export a réussi sinon faux
     */
    public function doExport()
    {
        $def = [
            ['o_id', 'N', 10, 0],
            ['o_uid', 'N', 10, 0],
            ['o_date', 'D'],
            ['o_state', 'N', 1, 0],
            ['o_ip', 'C', 32],
            ['o_lastname', 'C', 155],
            ['o_firstnam', 'C', 155],
            ['o_adress', 'C', 155],
            ['o_zip', 'C', 30],
            ['o_town', 'C', 155],
            ['o_country', 'C', 3],
            ['o_telephon', 'C', 30],
            ['o_email', 'C', 155],
            ['o_articles', 'N', 10, 0],
            ['o_total', 'N', 10, 2],
            ['o_shipping', 'N', 10, 2],
            ['o_bill', 'L'],
            ['o_password', 'C', 155],
            ['o_text', 'C', 155],
            ['o_cancel', 'C', 155],
            ['c_id', 'N', 10, 0],
            ['c_prod_id', 'N', 10, 0],
            ['c_qte', 'N', 10, 0],
            ['c_price', 'N', 10, 2],
            ['c_o_id', 'N', 10, 0],
            ['c_shipping', 'N', 10, 2],
            ['c_pass', 'C', 155],
        ];
        /*
           * Correspondances
           * cmd_id                o_id
           * cmd_uid                 o_uid
           * cmd_date                o_date
           * cmd_state               o_state
           * cmd_ip                  o_ip
           * cmd_lastname            o_lastname
           * cmd_firstname           o_firstnam
           * cmd_adress              o_adress
           * cmd_zip                 o_zip
           * cmd_town                o_town
           * cmd_country             o_country
           * cmd_telephone           o_telephon
           * cmd_email               o_email
           * cmd_articles_count      o_articles
           * cmd_total               o_total
           * cmd_shipping            o_shipping
           * cmd_bill                o_bill
           * cmd_password            o_password
           * cmd_text                o_text
           * cmd_cancel              o_cancel
           * caddy_id                c_id
           * caddy_product_id        c_prod_id
           * caddy_qte               c_qte
           * caddy_price             c_price
           * caddy_cmd_id            c_o_id
           * caddy_shipping          c_shipping
           * caddy_pass              c_pass
           */
        $db              = \XoopsDatabaseFactory::getDatabaseConnection();
        $caddyHandler    = new Oledrion\CaddyHandler($db);
        $commandsHandler = new Oledrion\CommandsHandler($db);
        if (!dbase_create($this->folder . '/' . $this->filename, $def)) {

The function dbase_create was not found. Maybe you did not declare it correctly or list all dependencies?

            $this->success = false;

            return false;
        }
        $dbf = dbase_open($this->folder . '/' . $this->filename, 2);

The function dbase_open was not found. Maybe you did not declare it correctly or list all dependencies?

        if (false === $dbf) {
            $this->success = false;

            return false;
        }

        $criteria = new \CriteriaCompo();
        $criteria->add(new \Criteria('cmd_id', 0, '<>'));
        $criteria->add(new \Criteria('cmd_state', $this->orderType, '='));
        $criteria->setSort('cmd_date');
        $criteria->setOrder('DESC');
        $orders = $commandsHandler->getObjects($criteria);
        foreach ($orders as $order) {
            $carts = [];

The assignment to $carts is dead and can be removed.

            $carts = $caddyHandler->getObjects(new \Criteria('caddy_cmd_id', $order->getVar('cmd_id'), '='));
            foreach ($carts as $cart) {
                dbase_add_record($dbf, [

The function dbase_add_record was not found. Maybe you did not declare it correctly or list all dependencies?

                    $order->getVar('cmd_id'),
                    $order->getVar('cmd_uid'),
                    date('Ymd', strtotime($order->getVar('cmd_date'))),
                    $order->getVar('cmd_state'),
                    $order->getVar('cmd_ip'),
                    $order->getVar('cmd_lastname'),
                    $order->getVar('cmd_firstname'),
                    $order->getVar('cmd_adress'),
                    $order->getVar('cmd_zip'),
                    $order->getVar('cmd_town'),
                    $order->getVar('cmd_country'),
                    $order->getVar('cmd_telephone'),
                    $order->getVar('cmd_email'),
                    $order->getVar('cmd_articles_count'),
                    $order->getVar('cmd_total'),
                    $order->getVar('cmd_shipping'),
                    $order->getVar('cmd_bill'),
                    $order->getVar('cmd_password'),
                    $order->getVar('cmd_text'),
                    $order->getVar('cmd_cancel'),
                    $cart->getVar('caddy_id'),
                    $cart->getVar('caddy_product_id'),
                    $cart->getVar('caddy_qte'),
                    $cart->getVar('caddy_price'),
                    $cart->getVar('caddy_cmd_id'),
                    $cart->getVar('caddy_shipping'),
                    $cart->getVar('caddy_pass'),
                ]);
            }
        }
        dbase_close($dbf);

The function dbase_close was not found. Maybe you did not declare it correctly or list all dependencies?

        $this->success = true;

        return true;
    }

    /**
     * Retourne le lien à utiliser pour télécharger le fichier d'export
     * @return bool|string Le lien à utiliser
     */
    public function getDownloadUrl()
    {
        if ($this->success) {
            return $this->url . '/' . $this->filename;
        }

        return false;
    }

    /**
     * @return bool|string
     */
    public function getDownloadPath()
    {
        if ($this->success) {
            return $this->folder . DIRECTORY_SEPARATOR . $this->filename;
        }

        return false;
    }
}