shipment.php

<?php
namespace Bitrix\Sale\Internals;
 
use Bitrix\Main;
use Bitrix\Main\Localization\Loc;
 
Loc::loadMessages(__FILE__);
 
 
class ShipmentTable extends Main\Entity\DataManager
{
    public static function getFilePath()
    {
        return __FILE__;
    }
 
    public static function getUfId()
    {
        return 'SHIPMENT';
    }
 
    public static function deleteWithItems($id)
    {
        $id = intval($id);
        if ($id <= 0)
            throw new Main\ArgumentNullException("id");
 
        $itemsList = ShipmentItemTable::getList(
            array(
                "filter" => array("ORDER_DELIVERY_ID" => $id),
                "select" => array("ID")
            )
        );
        while ($item = $itemsList->fetch())
            ShipmentItemTable::deleteWithItems($item["ID"]);
 
        return ShipmentTable::delete($id);
    }
 
    public static function getTableName()
    {
        return 'b_sale_order_delivery';
    }
 
    public static function getMap()
    {
        global $DB;
 
        return array(
            'ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_ID_FIELD'),
            ),
            'ORDER_ID' => array(
                'data_type' => 'integer',
                'required' => true,
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_ORDER_ID_FIELD'),
            ),
            new Main\Entity\StringField(
                    'ACCOUNT_NUMBER',
                    array(
                            'size' => 100
                    )
            ),
            'ORDER' => array(
                'data_type' => 'Order',
                'reference' => array(
                    '=ref.ID' => 'this.ORDER_ID'
                )
            ),
            'DATE_INSERT' => array(
                'data_type' => 'datetime'
            ),
            'DATE_UPDATE' => array(
                'data_type' => 'datetime'
            ),
 
            new Main\Entity\ExpressionField(
                'DATE_INSERT_SHORT',
                $DB->datetimeToDateFunction('%s'),
                array('DATE_INSERT')
            ),
 
            new Main\Entity\StringField(
                'STATUS_ID',
                array('size' => 2)
            ),
 
            new Main\Entity\StringField(
                'DELIVERY_LOCATION',
                array('size' => 50)
            ),
 
            new Main\Entity\FloatField(
                'BASE_PRICE_DELIVERY'
            ),
 
            new Main\Entity\FloatField(
                'PRICE_DELIVERY'
            ),
 
            new Main\Entity\FloatField(
                'WEIGHT',
                [
                    'default_value' => 0
                ]
            ),
 
            new Main\Entity\BooleanField(
                'CUSTOM_PRICE_DELIVERY',
                array(
                    'values' => array('N','Y'),
                    'default_value' => 'N'
                )
            ),
 
 
            new Main\Entity\StringField(
                'CURRENCY',
                array(
                    'size' => 3
                )
            ),
 
            new Main\Entity\FloatField(
                'DISCOUNT_PRICE'
            ),
 
            new Main\Entity\BooleanField(
                'ALLOW_DELIVERY',
                array(
                    'values' => array('N','Y'),
                    'default_value' => 'N'
                )
            ),
 
            new Main\Entity\DatetimeField('DATE_ALLOW_DELIVERY'),
 
            new Main\Entity\ExpressionField(
                'DATE_ALLOW_DELIVERY_SHORT',
                $DB->datetimeToDateFunction('%s'),
                array('DATE_ALLOW_DELIVERY')
            ),
 
            'EMP_ALLOW_DELIVERY_ID' => array(
                'data_type' => 'integer',
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_EMP_ALLOW_DELIVERY_FIELD'),
            ),
            'EMP_ALLOW_DELIVERY_BY' => array(
                'data_type' => 'Bitrix\Main\User',
                'reference' => array(
                    '=this.EMP_ALLOW_DELIVERY_ID' => 'ref.ID'
                )
            ),
 
            new Main\Entity\BooleanField(
                'DEDUCTED',
                array(
                    'values' => array('N','Y'),
                    'default_value' => 'N'
                )
            ),
 
            'DATE_DEDUCTED' => array(
                'data_type' => 'datetime',
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_DATE_DEDUCTED_FIELD'),
            ),
            new Main\Entity\ExpressionField(
                'DATE_DEDUCTED_SHORT',
                $DB->datetimeToDateFunction('%s'),
                array('DATE_DEDUCTED')
            ),
            'EMP_DEDUCTED_ID' => array(
                'data_type' => 'integer',
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_EMP_DEDUCTED_ID_FIELD'),
            ),
            'EMP_DEDUCTED_BY' => array(
                'data_type' => 'Bitrix\Main\User',
                'reference' => array(
                    '=this.EMP_DEDUCTED_ID' => 'ref.ID'
                )
            ),
            'REASON_UNDO_DEDUCTED' => array(
                'data_type' => 'string',
                'validation' => array(__CLASS__, 'validateReasonUndoDeducted'),
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_REASON_UNDO_DEDUCTED_FIELD'),
            ),
 
            new Main\Entity\BooleanField(
                'RESERVED',
                array(
                    'values' => array('N','Y'),
                    'default_value' => 'N'
                )
            ),
 
            new Main\Entity\IntegerField(
                'DELIVERY_ID',
                 array(
                     'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_DELIVERY_ID_FIELD'),
                 )
            ),
 
            'DELIVERY' => array(
                'data_type' => '\Bitrix\Sale\Delivery\Services\Table',
                'reference' => array(
                    '=this.DELIVERY_ID' => 'ref.ID'
                )
            ),
            'DELIVERY_DOC_NUM' => array(
                'data_type' => 'string',
                'validation' => array(__CLASS__, 'validateDeliveryDocNum'),
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_DELIVERY_DOC_NUM_FIELD'),
            ),
 
            new Main\Entity\DatetimeField('DELIVERY_DOC_DATE'),
 
            new Main\Entity\ExpressionField(
                'DELIVERY_DOC_DATE_SHORT',
                $DB->datetimeToDateFunction('%s'),
                array('DELIVERY_DOC_DATE')
            ),
 
            'TRACKING_NUMBER' => array(
                'data_type' => 'string',
                'validation' => array(__CLASS__, 'validateTrackingNumber'),
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_TRACKING_NUMBER_FIELD'),
            ),
            'TRACKING_STATUS' => array(
                'data_type' => 'integer',
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_TRACKING_STATUS_FIELD'),
            ),
            'TRACKING_DESCRIPTION' => array(
                'data_type' => 'string',
                'validation' => array(__CLASS__, 'validateTrackingDescription'),
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_TRACKING_DESCRIPTION_FIELD'),
            ),
            'TRACKING_LAST_CHECK' => array(
                'data_type' => 'datetime',
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_TRACKING_LAST_CHECK_FIELD'),
            ),
            'TRACKING_LAST_CHANGE' => array(
                'data_type' => 'datetime',
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_TRACKING_LAST_CHANGE_FIELD'),
            ),
 
            'XML_ID' => array(
                'data_type' => 'string',
                'validation' => array(__CLASS__, 'validateXmlId'),
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_XML_ID_FIELD'),
            ),
            'PARAMS' => array(
                'data_type' => 'text',
                'serialized' => true,
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_PARAMETERS_FIELD'),
            ),
            'DELIVERY_NAME' => array(
                'data_type' => 'string',
//              'required' => true,
                'validation' => array(__CLASS__, 'validateDeliveryName'),
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_DELIVERY_NAME_FIELD'),
            ),
 
            new Main\Entity\BooleanField(
                'CANCELED',
                array(
                    'values' => array('N','Y'),
                    'default_value' => 'N'
                )
            ),
            'DATE_CANCELED' => array(
                'data_type' => 'datetime',
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_DATE_CANCELED_FIELD'),
            ),
            'EMP_CANCELED_ID' => array(
                'data_type' => 'integer',
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_EMP_CANCELED_ID_FIELD'),
            ),
            'REASON_CANCELED' => array(
                'data_type' => 'string',
                'validation' => array(__CLASS__, 'validateReasonCanceled'),
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_REASON_CANCELED_FIELD'),
            ),
            'EMP_CANCELED_BY' => array(
                'data_type' => 'Bitrix\Main\User',
                'reference' => array(
                    '=this.EMP_CANCELED_ID' => 'ref.ID'
                )
            ),
            new Main\Entity\BooleanField(
                'MARKED',
                array(
                    'values' => array('N','Y'),
                    'default_value' => 'N'
                )
            ),
            'DATE_MARKED' => array(
                'data_type' => 'datetime',
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_DATE_MARKED_FIELD'),
            ),
            'EMP_MARKED_ID' => array(
                'data_type' => 'integer',
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_EMP_MARKED_ID_FIELD'),
            ),
            'EMP_MARKED_BY' => array(
                'data_type' => 'Bitrix\Main\User',
                'reference' => array(
                    '=this.EMP_MARKED_ID' => 'ref.ID'
                )
            ),
            'REASON_MARKED' => array(
                'data_type' => 'string',
                'validation' => array(__CLASS__, 'validateReasonMarked'),
                'title' => Loc::getMessage('ORDER_SHIPMENT_ENTITY_REASON_MARKED_FIELD'),
            ),
 
            new Main\Entity\BooleanField(
                'SYSTEM',
                array(
                    'values' => array('N','Y'),
                    'default_value' => 'N'
                )
            ),
 
            'RESPONSIBLE_ID' => array(
                'data_type' => 'integer',
                'title' => Loc::getMessage('ORDER_PAYMENT_ENTITY_RESPONSIBLE_ID_FIELD')
            ),
            'RESPONSIBLE_BY' => array(
                'data_type' => 'Bitrix\Main\User',
                'reference' => array(
                    '=this.RESPONSIBLE_ID' => 'ref.ID'
                )
            ),
            'EMP_RESPONSIBLE_ID' => array(
                'data_type' => 'integer',
                'title' => Loc::getMessage('ORDER_PAYMENT_ENTITY_EMP_RESPONSIBLE_ID_FIELD')
            ),
            'EMP_RESPONSIBLE_BY' => array(
                'data_type' => 'Bitrix\Main\User',
                'reference' => array(
                    '=this.EMP_RESPONSIBLE_ID' => 'ref.ID'
                )
            ),
            'DATE_RESPONSIBLE_ID' => array(
                'data_type' => 'datetime',
                'title' => Loc::getMessage('ORDER_PAYMENT_ENTITY_DATE_RESPONSIBLE_ID_FIELD')
            ),
            'COMMENTS' => array(
                'data_type' => 'string',
                'title' => Loc::getMessage('ORDER_PAYMENT_ENTITY_COMMENTS_FIELD')
            ),
            'COMPANY_ID' => array(
                'data_type' => 'integer',
                'title' => Loc::getMessage('ORDER_PAYMENT_ENTITY_COMPANY_ID_FIELD')
            ),
            'COMPANY_BY' => array(
                'data_type' => 'Bitrix\Sale\Internals\Company',
                'reference' => array(
                    '=this.COMPANY_ID' => 'ref.ID'
                )
            ),
            'STATUS' => array(
                'data_type' => 'Bitrix\Sale\Internals\StatusTable',
                'reference' => array(
                    '=this.STATUS_ID' => 'ref.ID'
                )
            ),
            'SHIPMENT_ITEM' => array(
                    'data_type' => 'ShipmentItem',
                    'reference' => array(
                            'this.ID' => 'ref.ORDER_DELIVERY_ID',
                    )
            ),
            new Main\Entity\BooleanField(
                'UPDATED_1C',
                array(
                    'values' => array('N', 'Y')
                )
            ),
 
            new Main\Entity\StringField('ID_1C'),
 
            new Main\Entity\StringField('VERSION_1C'),
 
            new Main\Entity\BooleanField(
                'EXTERNAL_DELIVERY',
                array(
                    'values' => array('N', 'Y')
                )
            ),
        );
    }
    public static function validateAllowDelivery()
    {
        return array(
            new Main\Entity\Validator\Length(null, 1),
        );
    }
    public static function validateDeducted()
    {
        return array(
            new Main\Entity\Validator\Length(null, 1),
        );
    }
    public static function validateReasonUndoDeducted()
    {
        return array(
            new Main\Entity\Validator\Length(null, 255),
        );
    }
    public static function validateReserved()
    {
        return array(
            new Main\Entity\Validator\Length(null, 1),
        );
    }
    public static function validateDeliveryDocNum()
    {
        return array(
            new Main\Entity\Validator\Length(null, 20),
        );
    }
    public static function validateTrackingNumber()
    {
        return array(
            new Main\Entity\Validator\Length(null, 255),
        );
    }
    public static function validateXmlId()
    {
        return array(
            new Main\Entity\Validator\Length(null, 255),
        );
    }
    public static function validateDeliveryName()
    {
        return array(
            new Main\Entity\Validator\Length(null, 255),
        );
    }
    public static function validateCanceled()
    {
        return array(
            new Main\Entity\Validator\Length(null, 1),
        );
    }
    public static function validateReasonCanceled()
    {
        return array(
            new Main\Entity\Validator\Length(null, 255),
        );
    }
    public static function validateMarked()
    {
        return array(
            new Main\Entity\Validator\Length(null, 1),
        );
    }
    public static function validateReasonMarked()
    {
        return array(
            new Main\Entity\Validator\Length(null, 255),
        );
    }
    public static function validateSystem()
    {
        return array(
            new Main\Entity\Validator\Length(null, 1),
        );
    }
    public static function validateTrackingDescription()
    {
        return array(
            new Main\Entity\Validator\Length(null, 255),
        );
    }
 
}