<?php

namespace YHMOrders\SqlMap\Delivery;

class Delivery {

    const SELECT_DELIVERY_BY_ORDER_CODE = 'select * from orders_deliver where order_code = :order_code ';

    const INSERT_DELIVERY = 'insert  into orders_deliver (`order_code`,`receiver_name`,`receiver_mobile`,`area_code`,`address`,`zip_code`) values (:order_code,:receiver_name,:receiver_mobile,:area_code,:address,:zip_code)';
    
    const UPDATE_DELIVERY_BY_ORDER_CODE = 'update orders_deliver set deliver_company_id=:deliver_company_id,deliver_company_name=:deliver_company_name,delivery_code=:delivery_code where order_code=:order_code';
}