package com.taover.repository.test;

import java.util.List;
import java.util.Map;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.ConfigurableApplicationContext;
import org.springframework.scheduling.annotation.EnableScheduling;

import com.taover.repository.jdbctemplate.JdbcTemplateWrapperTenant;

@SpringBootApplication
@EnableScheduling
public class TestAutoconfigure {
	public static void main(String args[]) {
		ConfigurableApplicationContext context = SpringApplication.run(TestAutoconfigure.class, args);
		
//		JdbcTemplateBroadcast jdbcTemplateB = context.getBean(JdbcTemplateBroadcast.class);
//		System.out.println(jdbcTemplateB.queryForObject("select id from wxorder_order order by id desc limit 5 ", String.class, new String[]{"wxorder_order"}));
		
//		JdbcTemplateWrapperTenant jdbcTemplate = context.getBean(JdbcTemplateWrapperTenant.class);
//		System.out.println(jdbcTemplate.queryForObject("select id from wxorder_order limit 1", Long.class, 1L));
//		System.out.println(jdbcTemplate.queryForList("select * from wxorder_order limit 1", 1L));
//		System.out.println(jdbcTemplate.queryForList("select * from wxorder_order limit 1", 2L));
//		System.out.println(jdbcTemplate.queryForList("select * from wxorder_order_express limit 1", 1L));
		
		String sql = " SELECT wo.customer_network_name as customerNetworkName,wo.order_sn AS orderSn, wog.`goods_name` AS goodsName, wog.`sku_name` AS skuName, wog.`goods_number` AS saleNumber,"
				//  woe.order_goods_id  woe.order_goods_origin_id
				+ " (SELECT sum(woe.`goods_number`) from `wxorder_order_express` as woe WHERE woe.order_goods_id = wog.id and woe.tenant_id=16)as deliveryGoodsNumber, "
				+ " ww.name as wareName, ww.manager_nickname as wareManager, "
				+ " wc.name as channelName, "
				+ " wog.goods_base_sku_price as costSinglePrice, "
				+ " wc.manager_nickname as channelManager,"
				+ " (wog.money_paid-wog.refund_money) AS shouldReceiveMoney, "
				+ " wog.refund_money AS channelRefund, "
				+ " wog.ware_refund_money AS wareRefund, "
				+ " (wog.goods_base_sku_price*wog.goods_number+wog.ware_shipping_price) AS cost, "
				+ " wog.channel_goods_price as channelGoodsPrice, "
				+ " wog.money_paid as moneyPaid, "
				+ " wo.create_time as orderTime "
				+ " FROM `wxorder_order` wo "
				+ " INNER JOIN `wxorder_order_goods_origin` wog ON wo.id = wog.`order_id` and wo.tenant_id=16 and wog.tenant_id=16 "
				+ " INNER JOIN wxorder_channel as wc on wc.id = wo.channel_id "
				+ " INNER JOIN wxorder_ware as ww on ww.id=wo.ware_id "
				+ " INNER JOIN wxorder_channel_goods as wcg on wcg.id = wog.channel_goods_id"
				+ " limit 10 ";
		JdbcTemplateWrapperTenant jdbcTemplate = context.getBean(JdbcTemplateWrapperTenant.class);
		List<Map<String, Object>> data = jdbcTemplate.queryForList(sql, 16L);
		System.out.println(data);
	}
}