package?com.sf.arch.udata.order;

/**
?*?\*?Created?with?IntelliJ?IDEA.
?*?\*?User:?xiangyongqing
?*?\*?Date:?2018/3/20
?*?\*?Time:?下午11:42
?*?\*?To?change?this?template?use?File?|?Settings?|?File?Templates.
?*?\*?Description:
?*?\
?*/
public?class?Constant?{
????public?final?static?String?SQL_ORDER?=?“SELECT\n“?+
????????????“basic.order_id\n“?+
????????????“basic.order_status\n“?+
????????????“basic.order_type\n“?+
????????????“basic.delivery_distance_meter\n“?+
????????????“basic.user_order_time\n“?+
????????????“basic.expect_time\n“?+
????????????“info.distribute_time\n“?+
????????????“info.redistribute_time\n“?+
????????????“info.confirm_time\n“?+
????????????“info.arriveshop_time\n“?+
????????????“info.pickup_time\n“?+
????????????“info.finish_time\n“?+
????????????“info.cancel_time\n“?+
????????????“basic.delivery_type\n“?+
????????????“basic.city_id\n“?+
????????????“l(fā)ist.supplier_id\n“?+
????????????“l(fā)ist.station_id\n“?+
????????????“l(fā)ist.aoi_id\n“?+
????????????“basic.user_address\n“?+
????????????“basic.dispatch_type\n“?+
????????????“basic.brand\n“?+
????????????“l(fā)ist.shop_id\n“?+
????????????“l(fā)ist.shop_name\n“?+
????????????“l(fā)ist.rider_name\n“?+
????????????“rider.ucode\n“?+
????????????“rider.work_type\n“?+
????????????“basic.delivery_fees\n“?+
????????????“FROM?order_list_20180326?as?list\n“?+
????????????“LEFT?JOIN?api_order_basic_20180326?as?basic?on?list.order_id?=?basic.order_id\n“?+
????????????“LEFT?JOIN?order_info_20180326?as?info?on?list.order_id?=?info.order_id\n“?+
????????????“LEFT?JOIN?loc_rider?as?rider?on?list.rider_id?=?rider.rider_id\n“?+
????????????“WHERE?list.date?=?20180327?and?basic.is_test=0\n“;
????public?final?static?String[]?EXCEL_HEADER={
????????????“時(shí)間“
????????????“訂單號“
????????????“訂單狀態(tài)“
????????????“下單方式“
????????????“送餐距離“
????????????“下單時(shí)間“
????????????“期望時(shí)間“
????????????“指派時(shí)間“
????????????“改派時(shí)間“
????????????“騎士接單時(shí)間“
????????????“騎士到店時(shí)間“
????????????“取餐時(shí)間“
????????????“完成時(shí)間“
????????????“取消時(shí)間“
????????????“配送類型“
????????????“城市編號“
????????????“供應(yīng)商編號“
????????????“站點(diǎn)編號“
????????????“商圈編號“
????????????“用戶地址“
????????????“配送模式“
????????????“品牌“
????????????“店鋪編號“
????????????“店鋪名字“
????????????“騎士名字“
????????????“順豐工號“
????????????“騎士類型“
????????????“配送費(fèi)“
????};
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-03-28?23:47??udata-order\
?????文件????????8791??2018-03-20?20:51??udata-order\udata-order.iml
?????文件???????10244??2018-03-28?23:47??udata-order\.DS_Store
?????目錄???????????0??2018-03-28?23:47??__MACOSX\
?????目錄???????????0??2018-03-28?23:47??__MACOSX\udata-order\
?????文件?????????120??2018-03-28?23:47??__MACOSX\udata-order\._.DS_Store
?????目錄???????????0??2018-03-28?23:47??udata-order\mails\
?????文件????????6148??2018-03-28?23:47??udata-order\mails\.DS_Store
?????目錄???????????0??2018-03-28?23:47??__MACOSX\udata-order\mails\
?????文件?????????120??2018-03-28?23:47??__MACOSX\udata-order\mails\._.DS_Store
?????文件???????11989??2018-03-23?11:17??udata-order\mails\citys
?????文件?????????210??2018-03-23?11:17??__MACOSX\udata-order\mails\._citys
?????文件????????4994??2018-03-19?16:51??udata-order\mvnw.cmd
?????目錄???????????0??2018-03-20?21:05??udata-order\target\
?????目錄???????????0??2018-03-20?16:44??udata-order\target\test-classes\
?????目錄???????????0??2018-03-20?16:44??udata-order\target\test-classes\com\
?????目錄???????????0??2018-03-20?16:44??udata-order\target\test-classes\com\sf\
?????目錄???????????0??2018-03-20?16:44??udata-order\target\test-classes\com\sf\arch\
?????目錄???????????0??2018-03-20?16:44??udata-order\target\test-classes\com\sf\arch\udata\
?????目錄???????????0??2018-03-20?16:45??udata-order\target\test-classes\com\sf\arch\udata\hive\
?????文件?????????649??2018-03-20?20:59??udata-order\target\test-classes\com\sf\arch\udata\hive\UdataHiveApplicationTests.class
?????目錄???????????0??2018-03-19?16:52??udata-order\target\generated-sources\
?????目錄???????????0??2018-03-19?16:52??udata-order\target\generated-sources\annotations\
?????文件????????6148??2018-03-20?21:05??udata-order\target\.DS_Store
?????目錄???????????0??2018-03-28?23:47??__MACOSX\udata-order\target\
?????文件?????????120??2018-03-20?21:05??__MACOSX\udata-order\target\._.DS_Store
?????目錄???????????0??2018-03-23?11:42??udata-order\target\classes\
?????文件?????????177??2018-03-23?11:42??udata-order\target\classes\logback.xml
?????文件????????6148??2018-03-20?21:05??udata-order\target\classes\.DS_Store
?????目錄???????????0??2018-03-28?23:47??__MACOSX\udata-order\target\classes\
?????文件?????????120??2018-03-20?21:05??__MACOSX\udata-order\target\classes\._.DS_Store
............此處省略445個(gè)文件信息