PHP Decode

b'

class BalikobotPackage
{
    /** @var int Order ID in PrestaShop. */
    public $id_order;

    /** @var string Package ID in Balikobot API. */
    public $package_id;

    /** @var int Carrier ID in PrestaShop. */
    public $carrier_id;

    /** @var BalikobotCarrier Corresponding carrier in Balikobot. */
    public $carrier;

    /** @var string Package Type for selected carrier. */
    public $carrier_package_type;

    /** @var int Supplier ID in PrestaShop. */
    public $supplier;

    /** @var string Link to PDF file with package\'s label. */
    public $label_url;

    /** @var bool True if package was ordered at the carrier. */
    public $sent;

    /** @var int Number of package in multi-package order. For single-package order this is equal to 1. */
    public $order_number;

    /** @var int Total count of packages in multi-package order. */
    public $order_count;

    /** @var int 0 = no VAT, 1 = with VAT, 2 = custom price */
    public $price_type;

    /** @var float Custom price for the package. */
    public $custom_price;

	/** @var int ID of the responsible employee. */
	public $id_employee;

	protected $tableName;

    public function __construct($id_order = null, $order_number = 1)
    {
        $this->tableName = _DB_PREFIX_ . \'monster_balikobot_packages\';
        $this->id_order = $id_order;
        $result = Db::getInstance()->getRow(\'SELECT * FROM \' . $this->tableName . \' WHERE order_number = \' . $order_number . \' AND id_order=\' . $id_order);

        if (is_array($result))
        {
            $this->package_id = $result[\'package_id\'];
            $this->carrier_id = $result[\'carrier_id\'];
            $this->carrier = new BalikobotCarrier($result[\'carrier\']);
            $this->carrier_package_type = $result[\'carrier_package_type\'];
            $this->label_text = $result[\'label_text\'];
            $this->supplier = $result[\'supplier\'];
            $this->label_url = $result[\'label_url\'];
            $this->sent = $result[\'sent\'];
            $this->order_number = $result[\'order_number\'];
            $this->order_count = $result[\'order_count\'];
            $this->price_type = $result[\'price_type\'];
            $this->custom_price = $result[\'custom_price\'];
			$this->id_employee = $result[\'id_employee\'];
        }
        else
        {
            $this->initValues();
        }
    }

    /**
     * Set empty values to class attributes.
     */
    protected function initValues()
    {
		global $cookie;

        $this->package_id = \'\';
        $this->carrier_id = \'\';
        $this->carrier = null;
        $this->carrier_package_type = null;
        $this->label_text = \'\';
        $this->supplier = self::getPackageSupplier($this->id_order);
        $this->label_url = \'\';
        $this->sent = false;
        $this->order_number = 1;
        $this->order_count = 1;
        $this->price_type = 1;
        $this->custom_price = null;
		$this->id_employee = $cookie->id_employee?$cookie->id_employee:\'null\';
    }

    /**
     * Returns URL to package\'s label, optionally with selected position.
     * If package is not in API, this method adds it there.
     *
     * @param int $position
     * @return string
     * @throws BalikobotAPIException
     */
    public function getLabelUrl($position = null, $orderCount = 1, $orderToPrint = \'all\')
    {
        if (!$this->label_url)
        {
            $this->registerPackage($orderCount);
        }

        if ($this->order_count == 1 || $orderToPrint != \'all\') { // print only one label
            $suffix = \'\';
            if ($position != null && $position != \'\') {
                $suffix = \'?p=\' . $position;
            }

            if ($this->order_count == 1 || $orderToPrint == 1) {
                return $this->label_url . $suffix;
            }
            else {
                $packageToPrint = new BalikobotPackage($this->id_order, $orderToPrint);
                return $packageToPrint->label_url . $suffix;
            }
        }
        else // print multiple labels
        {
            $packagesId = [];
            for ($i = 1; $i <= $this->order_count; $i++)
            {
                $package = new BalikobotPackage($this->id_order, $i);
                $packagesId[] = $package->package_id;
            }
            $response = BalikobotAPI::labels($packagesId, $this->getCarrier()->code);
            if (isset($response[\'labels_url\']))
            {
                 return $response[\'labels_url\'];
            }
            else
            {
                throw new BalikobotAPIException($packagesId);
                return \'\';
            }
        }
    }

    /**
     * Returns package\'s ID in Balikobot API.
     * If package is not in API, this method adds it there.
     *
     * @return string
     * @throws BalikobotAPIException
     */
    public function getPackageId()
    {
        if (!$this->package_id)
        {
            $this->registerPackage();
        }
        return $this->package_id;
    }

    /**
     * Saves package into database.
     */
    public function save()
    {
		global $cookie;

        if($this->carrier->code == \'toptrans\' && is_null($this->carrier_package_type)){
            $this->carrier_package_type = Configuration::get(\'MONSTER_BALIKOBOT_CARRIER_CUSTOM_TOPTRANS\');
        }

		if($this->carrier->code == \'gwcz\' && is_null($this->carrier_package_type)){
			$this->carrier_package_type = Configuration::get(\'MONSTER_BALIKOBOT_CARRIER_CUSTOM_GWCZ\');
		}

        $insertQuery = "INSERT INTO " . _DB_PREFIX_ . "monster_balikobot_packages (id_order, package_id, carrier_id, carrier, carrier_package_type, label_text, supplier, label_url, sent, order_number, order_count, price_type, custom_price, id_employee) VALUES (" .
            $this->id_order . ", \'" . $this->package_id .
            "\', \'" . $this->carrier_id . "\', " . $this->carrier->id_carrier . ", \'" . $this->carrier_package_type . "\', \'" . $this->label_text . "\', " . $this->supplier . ", \'" .
            $this->label_url . "\', " . ($this->sent ? \'1\' : \'0\') . ", " . $this->order_number . ", " . $this->order_count . ", " . $this->price_type . ", " . $this->custom_price . ", " . $this->id_employee . ")";

        $queryPassed = Db::getInstance()->execute($insertQuery);

		if (!$queryPassed && Configuration::get(\'MONSTER_BALIKOBOT_DEBUG\')) {

            "INSERT INTO " . _DB_PREFIX_ . "monster_balikobot_packages (id_order, package_id, carrier_id, carrier, carrier_package_type, label_text, supplier, label_url, sent, order_number, order_count, price_type, custom_price, id_employee) VALUES (" .
            $this->id_order . ", \'" . $this->package_id .
            "\', \'" . $this->carrier_id . "\', " . $this->carrier->id_carrier . ", \'" . $this->carrier_package_type . "\', \'" . $this->label_text . "\', " . $this->supplier . ", \'" .
            $this->label_url . "\', " . ($this->sent ? \'1\' : \'0\') . ", " . $this->order_number . ", " . $this->order_count . ", " . $this->price_type . ", " . $this->custom_price . ", " . $this->id_employee . ")";

            $logger = new FileLogger(0);
            if(_PS_VERSION_ > 1.6){
                $logger->setFilename(_PS_ROOT_DIR_ . "/var/logs/mm_balikobot_query.log");
            }else{
                $logger->setFilename(_PS_ROOT_DIR_ . "/log/mm_balikobot_query.log");
            }
            $logger->logDebug("FAILED QUERY: $insertQuery");
            $logger->logDebug("------------------------------");

        }

        if ($this->order_number == 1) {
            $order = new Order($this->id_order);
            $order->shipping_number = $this->carrier_id;
            $order->update();

            $order_carrier = new OrderCarrier($order->getIdOrderCarrier());
            $order_carrier->tracking_number = $this->carrier_id;

            if ($order_carrier->update() && Configuration::get(\'MONSTER_BALIKOBOT_TRACKING_MAIL\')) {

                $customer = new Customer((int)$order->id_customer);
                $carrier = new Carrier((int)$order->id_carrier, $order->id_lang);

                $templateVars = array(
                    \'{followup}\' => str_replace(\'@\', $order->shipping_number, $carrier->url),
                    \'{firstname}\' => $customer->firstname,
                    \'{lastname}\' => $customer->lastname,
                    \'{id_order}\' => $order->id,
                    \'{shipping_number}\' => $order->shipping_number,
                    \'{order_name}\' => $order->getUniqReference()
                );
                if (@Mail::Send((int)$order->id_lang, \'in_transit\', Mail::l(\'Package in transit\', (int)$order->id_lang), $templateVars,
                    $customer->email, $customer->firstname.\' \'.$customer->lastname, null, null, null, null,
                    _PS_MAIL_DIR_, true, (int)$order->id_shop)) {
                } else {
                    $this->warnings[] = \'An error occurred while sending an email to the customer.\';
                }
            }

			$setState = Configuration::get(\'MONSTER_BALIKOBOT_NEW_STATE_1\');
			if($setState && $setState > 0) {
				if($order->current_state != $setState){
					$history = new OrderHistory();
					$carrier = new Carrier($order->id_carrier, $order->id_lang);

					$templateVars = array();
					if ($history->id_order_state == Configuration::get(\'PS_OS_SHIPPING\') && $order->shipping_number) {
						$templateVars = array(\'{followup}\' => str_replace(\'@\', $order->shipping_number, $carrier->url));
					}

					$history->id_employee = (int)$cookie->id_employee;;
					$history->id_order = (int)$this->id_order;
					$history->changeIdO'b'rderState((int)$setState, $order);
					$history->addWithEmail(true, $templateVars);
				}
			}
        }
    }

    /**
     * Add package to Balikobot API and to the database.
     * Throws exception if an error occurs during adding package to Balikobot API.
     *
     * @param int $orderCount Total number of packages in order.
     * @throws BalikobotAPIException
     */
    public function registerPackage($orderCount = 1)
    {
		$this->order_count = $orderCount;

		if ($this->getCarrier()->code == \'toptrans\') {
			//toptrans posl balky v jednom callu
			$this->pieces_count = $orderCount;
			$this->order_count = 1;
		}

		for ($i = 1; $i <= $this->order_count; $i++) {
            $this->order_number = $i;

            $response = $this->addPackageToAPI();
            $packagesData = $response[\'packages\'];
            if($packagesData){
                foreach($packagesData as $packageData){
                    if (!isset($packageData[\'status\']) || !in_array($packageData[\'status\'], [200, 208])) {
                        $messages = [\'\'];
                        $messages[] = \'Chyba pi pidvn balku do Balkobotu (ID objednvky: \' . $this->id_order . \'):\';

                        if($packageData[\'errors\']) {
                            foreach($packageData[\'errors\'] as $error){
                                $messages[] = $error[\'attribute\']." - ".$error[\'message\'];
                            }
                        } else {
                            $messages[] = "Neznm chyba";
                            $messages[] = json_encode($response[0][\'errors\'],  JSON_UNESCAPED_UNICODE);
                        }

                        throw new BalikobotAPIException($messages);
                    }

                    $this->package_id = $packageData[\'package_id\'];
                    $this->carrier_id = $packageData[\'carrier_id\'];
                    $this->label_url = $packageData[\'label_url\'];
                    $this->sent = 0;
                    $this->carrier = $this->getCarrier();
                    $this->save();
                }
            } else {
                $messages = [\'\'];
                $messages[] = \'Chyba pi pidvn balku do Balkobotu (ID objednvky: \' . $this->id_order . \'):\';
                $messages[] = $response[\'status_message\'];
                if($response[\'status\'] == 404) {
                    $messages[] = \'Zkontrolujte namapovn dopravce v konfiguraci modulu.\';
                }
                throw new BalikobotAPIException($messages);
            }

        }
    }

    /**
     * Returns track information about package.
     * Result array contains current package status (\'status\') and array of status changes (\'events\').
     *
     * @return array
     */
    public function trackPackage()
    {
        return BalikobotAPI::trackStatus($this->carrier_id, $this->getCarrier()->code);

        /* $response = BalikobotAPI::track($this->carrier_id, $this->getCarrier()->code);
            var_dump($response);
            die();
        */
    }

    /**
     * Checks package information.
     *
     * @return array
     */
    public function checkPackage()
    {
        return BalikobotAPI::check(
            $this->prepareAddData(),
            $this->getCarrier()->code,
            self::getSupplierApiCodes($this->supplier)
        );
    }

	/**
	 * Adds package into Balikobot API.
	 *
	 * @return array
	 */
	public function addPackageToAPI()
	{
		return BalikobotAPI::add(
			$this->prepareAddData(),
			$this->getCarrier()->code,
			self::getSupplierApiCodes($this->supplier)
		);
	}

    /**
     * Returns array with data to be sent to Balikobot API through ADD method.
     *
     * @return array
     */
    protected function prepareAddData()
    {
        $data = [];

        $order = new Order($this->id_order);
        $customer = new Customer($order->id_customer);
        $address = new Address($order->id_address_delivery);
        $country = new Country($address->id_country);
        $currency = new Currency($order->id_currency);

        $carrierCode = $this->getCarrier()->code;
        $serviceType = $this->getCarrier()->service;

        $data[\'note\'] = $this->label_text;

        // required fields for all carriers:
        if (Configuration::get(\'MONSTER_BALIKOBOT_ID_ORDER_PARAM\') == \'reference\') {
            $data[\'eid\'] = $order->reference;
            $data[\'vs\'] = $order->reference;
        }
        else {
            $data[\'eid\'] = $this->id_order;
            $data[\'vs\'] = $this->id_order;
        }

        switch((int)$this->price_type){
            case 0:{
                $data[\'price\'] = $order->total_paid_tax_excl;
                break;
            }
            case 1:{
                $data[\'price\'] = $order->total_paid;
                break;
            }
            case 2:{
                $data[\'price\'] = $this->custom_price;
                break;
            }
        }

        $data[\'rec_name\'] = $address->firstname . \' \' . $address->lastname;
        $data[\'rec_street\'] = $address->address1;
        $data[\'rec_city\'] = $address->city;
        $data[\'rec_zip\'] = str_replace(\' \', \'\', $address->postcode);
        $data[\'rec_country\'] = $country->iso_code;
        $data[\'rec_email\'] = $customer->email;
        $data[\'rec_phone\'] = (strlen($address->phone_mobile) > 1) ? $address->phone_mobile : $address->phone;

        if ($this->order_count > 1) {
            $data[\'order_number\'] = $this->order_number;
        }

        $weight = self::getWeight($this->id_order);
        $data[\'weight\'] = (($weight > 0) ? $weight : $order->getTotalWeight()) / ($this->order_count > 0 ? $this->order_count : 1);

        if (!empty($address->company)) {
            $data[\'rec_firm\'] = $address->company;
        }

        if (!empty($serviceType))
        {
            $data[\'service_type\'] = $serviceType;
        }

        if (($order->module == Configuration::get(\'MONSTER_BALIKOBOT_COD_MODULE\') || $order->module == Configuration::get(\'MONSTER_BALIKOBOT_COD_MODULE_2\')) && $this->order_number == 1)
        {
            switch((int)$this->price_type){
                case 0:{
                    $data[\'cod_price\'] = $order->total_paid_tax_excl;
                    break;
                }
                case 1:{
                    $data[\'cod_price\'] = $order->total_paid;
                    break;
                }
                case 2:{
                    $data[\'cod_price\'] = $this->custom_price;
                    break;
                }
            }
            $data[\'cod_currency\'] = $currency->iso_code;
        }


        // ESK POTA
        if ($carrierCode == \'cp\' && $serviceType == \'NB\') {
            if (Module::isInstalled(\'monster_cpost\')){

                $id_branch = Db::getInstance()->getValue(\'SELECT zip FROM \'._DB_PREFIX_.\'monster_cpost_expedition WHERE id_order=\' . $this->id_order);

                if($id_branch) {
                    $data[\'rec_zip\'] = $id_branch;
                }
            } else if (Module::isInstalled(\'shaim_balikovna\')) {
                $id_branch = Db::getInstance()->getValue(
                    \'SELECT psc FROM \'._DB_PREFIX_.\'shaim_balikovna_data JOIN \'._DB_PREFIX_.\'orders USING(id_cart) WHERE id_order=\' . $this->id_order
                );

                if($id_branch) {
                    $data[\'rec_zip\'] = $id_branch;
                }
            } else if (Module::isInstalled(\'add_ceskaposta_carriers\')) {
				$id_branch = Db::getInstance()->getValue(
					\'SELECT psc FROM \'._DB_PREFIX_.\'add_cp_all_orders o
					JOIN \'._DB_PREFIX_.\'add_cp_all_branches_B b ON o.id_branch = b.id
					WHERE id_order=\' . $this->id_order
				);

				if($id_branch) {
					$data[\'rec_zip\'] = $id_branch;
				}
			}
        }
        else if ($carrierCode == \'cp\' && $serviceType == \'NP\'){
            if (Module::isInstalled(\'monster_cpost\')) {
                $id_branch = Db::getInstance()->getValue(\'SELECT zip FROM \'._DB_PREFIX_.\'monster_cpost_expedition WHERE id_order=\' . $this->id_order);
                if($id_branch) {
                    $data[\'rec_zip\'] = $id_branch;
                }
            } else if (Module::isInstalled(\'add_ceskaposta_carriers\')) {
				$id_branch = Db::getInstance()->getValue(
					\'SELECT psc FROM \'._DB_PREFIX_.\'add_cp_all_orders o
					JOIN \'._DB_PREFIX_.\'add_cp_all_branches_NP b ON o.id_branch = b.id
					WHERE id_order=\' . $this->id_order
				);

				if($id_branch) {
					$data[\'rec_zip\'] = $id_branch;
				}
			} else if (Module::isInstalled(\'shaim_baliknapostu\')) {
                $id_branch = Db::getInstance()->getValue(\'SELECT psc FROM \'._DB_PREFIX_.\'shaim_baliknapostu_data JOIN \'._DB_PREFIX_.\'orders USING(id_cart) WHERE id_order=\' . $this->id_order);

                if($id_branch) {
                    $data[\'rec_zip\'] = $id_branch;
                }
            }
        }

        // DPD
        else if ($carrierCode == \'dpd\' && in_array($serviceType, [ 3 ])){
            if(Module::isInstalled(\'dpdparcelshop\')){
                $id_branch = Db::getInstance()->getValue(\'SELECT zip FROM \'._DB_PREFIX_.\'cart_parcelshop JOIN \'._DB_PREFIX_.\'orders USING(id_cart) WHERE id_order=\' . $this->id_order);
                if($id_branch) {
                    $data[\'branch_id\'] = "CZ".$id_branch;
                }
            }
            if(Module::isInstalled(\'shaim_dpdparcelshop\')){
                $id_branch = Db::getInstance()->getValue(\'SELECT id FROM \'._DB_PREFIX_.\'shaim_dpdparcelshop_data JOIN \'._DB_PREFIX_.\'shaim_dpdparcelshop USING(id) 'b'JOIN \'._DB_PREFIX_.\'orders USING(id_cart) WHERE id_order=\' . $this->id_order);
                if($id_branch) {
                    $data[\'branch_id\'] = "CZ".$id_branch;
                }
            }
        }

        // GEIS
        else if($carrierCode == \'geis\' && in_array($serviceType, [ 4, 5, 10, 11 ])){
            if(is_null($this->carrier_package_type)){
                $this->carrier_package_type = Configuration::get(\'MONSTER_BALIKOBOT_CARRIER_CUSTOM_GEIS\');
            }
            $data[\'mu_type\'] = $this->carrier_package_type;
        }

        // GLS
        else if ($carrierCode == \'gls\' && in_array($serviceType, [ 2 ])){
            if(Module::isInstalled(\'shaim_glsparcelshop\')){
                $id_branch = Db::getInstance()->getValue(\'SELECT psc FROM \'._DB_PREFIX_.\'shaim_glsparcelshop_data JOIN \'._DB_PREFIX_.\'shaim_glsparcelshop USING(id) JOIN \'._DB_PREFIX_.\'orders USING(id_cart) WHERE id_order=\' . $this->id_order);
                if($id_branch) {
                    $data[\'branch_id\'] = "CZ".$id_branch;
                }
            }
        }

		// Gerbruder Weiss CZ
		else if ($carrierCode == \'gwcz\'){
			if(is_null($this->carrier_package_type)){
				$this->carrier_package_type = Configuration::get(\'MONSTER_BALIKOBOT_CARRIER_CUSTOM_GWCZ\');
			}
			$data[\'mu_type\'] = $this->carrier_package_type;
		}

        // ULOENKA
        else if ($carrierCode == \'ulozenka\' && in_array($serviceType, [ 1 ])){

			if(Module::isInstalled(\'shaim_ulozenka\')){
				$id_branch = Db::getInstance()->getValue(\'SELECT id FROM \'._DB_PREFIX_.\'shaim_ulozenka_data JOIN \'._DB_PREFIX_.\'orders USING(id_cart) WHERE id_order=\' . $this->id_order);
				$id_branch = str_replace(\'ID\', \'\', $id_branch);
			} elseif(Module::isInstalled(\'monster_ulozenka\')){
                $id_branch = Db::getInstance()->getValue(\'SELECT id_ulozenka FROM \'._DB_PREFIX_.\'monster_ulozenka_expedition WHERE id_order=\' . $this->id_order);
            } else {
				try { // pvodn oficiln modul na uloenku
					$id_branch = Db::getInstance()->getValue(\'SELECT id_ulozenka FROM \' . _DB_PREFIX_ . \'ulozenka WHERE id_order=\' . $this->id_order);
				} catch(Exception $e) {}
			}
			if ($id_branch) {
				$data[\'branch_id\'] = $id_branch;
			}
        }

        else if ($carrierCode == \'ulozenka\' && in_array($serviceType, [ 5 ])){

        	try {
				$id_branch = Db::getInstance()->getValue(\'SELECT id_ulozenka FROM \'._DB_PREFIX_.\'ulozenka WHERE id_order=\' . $this->id_order);
				if($id_branch) {
					$data[\'branch_id\'] = $id_branch;
				}
			}catch(Exception $e){}

			if(!$id_branch && Module::isInstalled(\'dpdparcelshop\')){
				$id_branch = Db::getInstance()->getValue(\'SELECT zip FROM \'._DB_PREFIX_.\'cart_parcelshop JOIN \'._DB_PREFIX_.\'orders USING(id_cart) WHERE id_order=\' . $this->id_order);
				if($id_branch) {
					$data[\'branch_id\'] = "CZ".$id_branch;
				}
			}
        }

        // PPL
        else if ($carrierCode == \'ppl\' && in_array($serviceType, [ 2, 3, 4, 15, 19 ])){
			if(Module::isInstalled(\'monster_ppl\')) {
				$moduleData = Db::getInstance()->getRow(\'SELECT * FROM \' . _DB_PREFIX_ . \'monster_ppl_expedition WHERE id_order=\' . $this->id_order);

				if ($moduleData) {

					switch ($moduleData[\'id_service_type\']) {

						case 2:
						{//ppl private - veern doruen
							$data[\'service_type\'] = 9;
							$data[\'del_evening\'] = true;
							break;
						}
						case 3:
						{//ppl private - sobotn doruen
							$data[\'sat_delivery\'] = true;
							break;
						}
						case 4:
						{//ppl parcel shop
							$data[\'service_type\'] = 4;
							$data[\'branch_id\'] = substr($moduleData[\'code\'], 2);
							break;
						}
					}
				}
			}

            if(in_array($serviceType, [ 15, 19 ])){
                $data[\'mu_type\'] = Configuration::get(\'MONSTER_BALIKOBOT_CARRIER_CUSTOM_PPL\');
            }
        }

		// SLOVENSKA POSTA
		if ($carrierCode == \'sp\' && $serviceType == \'BNP\'){
			if(Module::isInstalled(\'shaim_baliknapostu\')){
				$id_branch = Db::getInstance()->getValue(\'SELECT psc FROM \'._DB_PREFIX_.\'shaim_baliknapostu_data JOIN \'._DB_PREFIX_.\'orders USING(id_cart) WHERE id_order=\' . $this->id_order);

				if($id_branch) {
					$data[\'rec_zip\'] = $id_branch;
				}
			}
		}

        // TOPTRANS
        else if($carrierCode == \'toptrans\'){
			$data[\'pieces_count_one\'] = (int)$this->pieces_count;
            if(is_null($this->carrier_package_type)){
                $this->carrier_package_type = Configuration::get(\'MONSTER_BALIKOBOT_CARRIER_CUSTOM_TOPTRANS\');
            }
            $data[\'mu_type_one\'] = $this->carrier_package_type;
            if(Configuration::get(\'MONSTER_BALIKOBOT_CARRIER_CUSTOM_SERVICE_\'.$this->carrier->id_carrier)){
                $data[\'comfort_service\'] = 1;
            }
        }

        // ZSILKOVNA , 3060 - PL Packzkomat
        else if ($carrierCode == \'zasilkovna\' && in_array($serviceType, [ "VMCZ" , "VMPL", "VMSK", "VMHU", "VMRO", 3060 ])){
            if(Module::isInstalled(\'monster_zasilkovna\')) {
                $id_branch = Db::getInstance()->getValue(\'SELECT id_zasilkovna FROM \'._DB_PREFIX_.\'monster_zasilkovna_expedition WHERE id_order=\' . $this->id_order);
            }elseif(Module::isInstalled(\'shaim_zasilkovna_widget\')){
                                $row = Db::getInstance()->getRow(\'SELECT id, carrierPickupPointId FROM \'._DB_PREFIX_.\'shaim_zasilkovna_widget_data JOIN \'._DB_PREFIX_.\'orders USING(id_cart) WHERE id_order=\' . $this->id_order);
                                //carrierPickupPointId - pobocka mimo zasilkovnu v zahranici
                                $id_branch = $row[\'id\'] ? $row[\'id\'] : $row[\'carrierPickupPointId\'];
			}else{
                $id_branch = Db::getInstance()->getValue(\'SELECT id_branch FROM \'._DB_PREFIX_.\'packetery_order WHERE id_order=\' . $this->id_order);
            }
            if($id_branch) {
                $data[\'branch_id\'] = $id_branch;
            }
        }
        else if ($carrierCode == \'zasilkovna\' && $serviceType && $serviceType > 1){
                $data[\'branch_id\'] = $serviceType; //ostatn sluby zsilkovny - pod ID virtuln poboky
        }

        $data[\'return_full_errors\'] = true;

        return $data;
    }

    /**
     * @return array
     */
    public function dropPackageFromAPI()
    {
        return BalikobotAPI::drop($this->package_id, $this->carrier->code, self::getSupplierApiCodes($this->supplier));
    }

    /**
     * @return BalikobotCarrier Package\'s carrier.
     */
    public function getCarrier()
    {
        if (!$this->carrier)
        {
            $order = new Order($this->id_order);
            $this->carrier = new BalikobotCarrier($order->id_carrier);
        }

        return $this->carrier;
    }

    /**
     * @return int Number of possible positions of label for the package.
     */
    public function getLabelPositionCount()
    {
        $carrierCode = $this->getCarrier()->code;
        return BalikobotCarrier::getLabelPositionCount($carrierCode);
    }

    public static function getWeight($id_order)
    {
        $order = new Order($id_order);
        $orderCarrier = new OrderCarrier($order->getIdOrderCarrier());
        return round($orderCarrier->weight, 2);
    }

    public static function setWeight($id_order, $weight)
    {
        $order = new Order($id_order);
        $orderCarrier = new OrderCarrier($order->getIdOrderCarrier());
        $orderCarrier->weight = $weight;
        $orderCarrier->save();

    }

    public static function getPrice($id_order)
    {
        $order = new Order($id_order);
        return round($order->total_paid, 2);
    }

	public static function getCarrierStatic($id_order)
	{
		$order = new Order($id_order);
		$carrier = new BalikobotCarrier($order->id_carrier);

		return $carrier->code;
	}
    /*public static function setPrice($id_order, $price)
    {
        $order = new Order($id_order);
        $orderCarrier = new OrderCarrier($order->getIdOrderCarrier());
        $orderCarrier->custom_price = $price;
        $orderCarrier->save();

    }

    public static function setVat($id_order, $vat)
    {
        $order = new Order($id_order);
        $orderCarrier = new OrderCarrier($order->getIdOrderCarrier());
        $orderCarrier->vat = $vat;
        $orderCarrier->save();

    }

    public static function setLabelText($id_order, $labelText)
    {
        $order = new Order($id_order);
        $orderCarrier = new OrderCarrier($order->getIdOrderCarrier());
        $orderCarrier->custom_price = $price;
        $orderCarrier->save();

    }

    public static function setCarrierPackageType($id_order, $carrierPackageType)
    {
        $order = new Order($id_order);
        $orderCarrier = new OrderCarrier($order->getIdOrderCarrier());
        $orderCarrier->custom_price = $price;
        $orderCarrier->save();

    }*/

    /**
     * Delete package from Balikobot API and from database.
     * Throws exception if package could not be deleted from API.
     *
     * @param $id_order
     * @throws BalikobotAPIException
     */
    public static function delete($id_order)
    {
        $package = new BalikobotPackage($id_order);
        $order_count = $package->order_count;
        $errors = [];

        for ($i = 1; $i <= $order_count; $i++) {
            if ($i > 1) {
                $package = new BalikobotPackage($id_order, $i);
            }
            $response = $package->dropPackageFromAPI();
            if ($response[\'status\'] == 200) {
                Db::getInstance()->execute(\'DELETE FROM \' . _DB_PREFIX_ . \'monster_balikobot_packages WHERE i'b'd_order=\' .
                    $id_order . \' AND order_number = \' . $i);

                Db::getInstance()->execute(\'UPDATE \' . _DB_PREFIX_ . \'order_carrier SET tracking_number="" WHERE id_order=\' .
                    $id_order);

            } else if ($response[\'status\'] == 404) {
                $errors[] = \'Balk s danm ID buto neexistuje, nebo byl ji odesln ke svozu.\';
            } else {
                $errors[] = \'Vyskytla se neznm chyba pi odebrn balku z API Balkobotu.\';
            }
        }

        if (!empty($errors)) {
            throw new BalikobotAPIException($errors);
        }
    }

    /**
     * Returns number of packages ready for order at carrier.
     * Result array structure:
     * [
     *      \'total\' => total number of packages
     *      \'carriers\' => [
     *          \'carrier_1_code\' => [
     *              \'name\' => \'Carrier 1 Name\',
     *              \'count\' => number of packages for carrier
     *          ],
     *          \'carrier_2_code\' => ...
     *          ...
     *      ],
     * ]
     *
     * @return array
     */
    public static function getPackagesToOrderCount()
    {
		global $cookie;

		if(Configuration::get(\'MONSTER_BALIKOBOT_EMPLOYEE_PACKAGES\')){
			$limit = \'bp.id_employee IS NULL OR bp.id_employee = \' . $cookie->id_employee;
		} else {
			$limit = \'1\';
		}

        $packages = Db::getInstance()->executeS(
            \'SELECT COUNT(bp.id) AS packages_count, bc.name as carrier_name, bc.code as carrier_code, supplier FROM \' .
            _DB_PREFIX_ . \'monster_balikobot_packages bp LEFT JOIN \' .
            _DB_PREFIX_ . \'monster_balikobot_carriers bc ON bc.id_carrier = bp.carrier WHERE bp.sent = 0 AND (\'.$limit.\') GROUP BY supplier, carrier_code\'
        );

        $result = [];
        $result[\'total\'] = 0;
        $result[\'expeditions\'] = [];

        foreach ($packages as $row){
            $result[\'expeditions\'][$row[\'supplier\']][$row[\'carrier_code\']] = [
                \'supplier_name\' => (($row[\'supplier\'] == 0)?\'Hlavn sklad\':Supplier::getNameById($row[\'supplier\'])),
                \'carrier_name\' => $row[\'carrier_name\'],
                \'count\' => $row[\'packages_count\'],
            ];
            $result[\'total\'] += $row[\'packages_count\'];
        }

        return $result;
    }

    /**
     * Sends order for packages to carrier and add record with order generated links into database.
     * If an error occurs, the result array has index \'error\' with information about the error.
     *
     * @param string $carrierCode
     * @return array
     */
    public static function orderPackagesForCarrier($supplierId, $carrierCode)
    {
		global $cookie;

		if(Configuration::get(\'MONSTER_BALIKOBOT_EMPLOYEE_PACKAGES\')){
			$limit = \'bp.id_employee IS NULL OR bp.id_employee = \' . $cookie->id_employee;
		} else {
			$limit = \'1\';
		}

		$packages = Db::getInstance()->executeS(
			\'SELECT bp.package_id as package_id, id_order FROM \' . _DB_PREFIX_ . \'monster_balikobot_packages bp LEFT JOIN \' .
			_DB_PREFIX_ . \'monster_balikobot_carriers bc ON bp.carrier = bc.id_carrier WHERE bp.sent = 0 AND (\'.$limit.\') AND bp.supplier = "\'.$supplierId.\'" AND bc.code = "\' . $carrierCode . \'"\'
        );
        $packageIds = [];
        $orderIds = [];

        foreach ($packages as $row)
        {
            $packageIds[] = $row[\'package_id\'];
            $orderIds[] = $row[\'id_order\'];

            Db::getInstance()->execute(
                "UPDATE " . _DB_PREFIX_ . "monster_balikobot_packages SET sent = 1 WHERE package_id = \'" . $row[\'package_id\'] . "\'"
            );

            $setState = Configuration::get(\'MONSTER_BALIKOBOT_NEW_STATE_2\');

			if($setState && $setState > 0){
				$order = new Order((int)$row[\'id_order\']);
				if($order->current_state != $setState) {
					$history = new OrderHistory();
					$carrier = new Carrier($order->id_carrier, $order->id_lang);

					$templateVars = array();
					if ($history->id_order_state == Configuration::get(\'PS_OS_SHIPPING\') && $order->shipping_number) {
						$templateVars = array(\'{followup}\' => str_replace(\'@\', $order->shipping_number, $carrier->url));
					}

					$history->id_employee = (int)$cookie->id_employee;
					$history->id_order = (int)$row[\'id_order\'];
					$history->changeIdOrderState((int)$setState, $order);
					$history->addWithEmail(true, $templateVars);
				}
            }
        }

        if (Module::isInstalled(\'monster_ppl\') && $orderIds){
            Db::getInstance()->execute(
                \'UPDATE \' . _DB_PREFIX_ . \'monster_ppl_expedition SET finished = 1 WHERE id_order IN (\' . implode(",",$orderIds).\')\'
            );
        }

        $response = BalikobotAPI::order([ \'package_ids\' => $packageIds ], $carrierCode, self::getSupplierApiCodes($supplierId));

        if ($response[\'status\'] == 200) {
            $order = new BalikobotOrder();
            $order->carrier_code = $carrierCode;
            $order->order_id = $response[\'order_id\'];
            $order->file_url = isset($response[\'file_url\']) ? $response[\'file_url\'] : \'\';
            $order->handover_url = $response[\'handover_url\'];
            $order->labels_url = $response[\'labels_url\'];
            $order->date = date(\'Y-m-d H:i:s\');
            $order->count = count($packageIds);
            $order->save();
        }
        else if ($response[\'status\'] == 406)
        {
            $response[\'error\'] = \'V systmu nejsou dn balky pro import.\';
        }
        else if ($response[\'status\'] == 503)
        {
            $response[\'error\'] = \'Technologie dopravce nen momentln dostupn.\';
        }

        return $response;
    }

    /**
     * Sends order for packages to all carriers.
     *
     * @return array
     */
    public static function orderPackagesForAll()
    {
        $result = [];
        $packages = self::getPackagesToOrderCount();

        foreach ($packages[\'expeditions\'] as $supplierId => $carriers){
            foreach ($carriers as $carrierCode => $info) {
                if ($info[\'count\'] > 0) {
                    $result[Supplier::getNameById($supplierId)][BalikobotCarrier::getCarrierNameFromCode($carrierCode)] =
                        self::orderPackagesForCarrier($supplierId, $carrierCode);
                }
            }
        }

        return $result;
    }

    /**
     * Returns labels for selected orders.
     * Result array is indexed with carrier\'s code and contain carrier\'s name (\'name\'),
     *  link to labels PDF (\'labelsUrl\') and labels count (\'count\').
     *
     * @param $orderIds
     * @return array
     */
    public static function getLabelsUrl($orderIds)
    {
        $result = [];
        $packageIds = [];

        foreach ($orderIds as $id_order)
        {
            try {
                $package = new BalikobotPackage($id_order);
                $order_count = $package->order_count;

                for ($i = 1; $i <= $order_count; $i++) {
                    if ($i > 1) {
                        $package = new BalikobotPackage($id_order, $i);
                    }
                    $carrier = $package->getCarrier();
                    if (!isset($result[$package->supplier][$carrier->code])) {
                        $result[$package->supplier][$carrier->code] = [
                            \'supplier\' => (($package->supplier == 0) ? \'Hlavn sklad\' : Supplier::getNameById($package->supplier)),
                            \'name\' => $carrier->name,
                            \'count\' => 0,
                            \'labelsUrl\' => \'\',
                        ];
                        $packageIds[$package->supplier][$carrier->code] = [];
                    }
                    $packageId = $package->getPackageId();
                    if($packageId){
                        $packageIds[$package->supplier][$carrier->code][] = $packageId;
                        $result[$package->supplier][$carrier->code][\'count\']++;
                    }
                }
            } catch(BalikobotAPIException $e) {
                $result[\'errors\'][] = $e->getMessageList();
            }
        }

        foreach ($packageIds as $supplier => $carriers){

            foreach ($carriers as $carrierCode => $packages)
            {
                $response = BalikobotAPI::labels($packages, $carrierCode, self::getSupplierApiCodes($supplier));
                if (isset($response[\'labels_url\']))
                {
                    $result[$supplier][$carrierCode][\'labelsUrl\'] = $response[\'labels_url\'];
                }
            }
        }

        return $result;
    }


    public static function getPackageSupplier($orderId){

        if(Configuration::get(\'MONSTER_BALIKOBOT_SUPPLIERS\')){

            $package_suppliers = DB::getInstance()->executeS(\'SELECT DISTINCT id_supplier
                FROM \'._DB_PREFIX_.\'order_detail od
                JOIN \'._DB_PREFIX_.\'product p ON ( od.product_id = p.id_product )
                WHERE id_order = \'.$orderId);

            if(count($package_suppliers) == 1){
               return $package_suppliers[0][\'id_supplier\'];
            }
        }

        return 0;
    }

    public static function getSupplierApiCodes($id_supplier){

        if($id_supplier == 0){

            return [
                    \'api_user\' => Configuration::get(\'MONSTER_BALIKOBOT_API_USER\'),
                    \'api_key\' => Configuration::get(\'MONSTER_BALIKOBOT_API_KEY\')
            ];

        }else{
            return json_decode(Configuration::get(\'MONSTER_BALIKOBOT_SUPPLIERS_API_\'.$id_supplier), true);
        }
    }
}
'