package com.shop.Manager.Impl;

import java.util.List;

import com.shop.Manager.OrderManager;
import com.shop.Model.Items;
import com.shop.Model.ShopOrder;
import com.shop.Model.Store;
import com.shop.Util.Pager.PagerManager;
import com.shop.Util.Pager.PagerModel;

public class OrderManagerImpl extends PagerManager implements OrderManager {

	public void addOrder(ShopOrder order) {
		this.getHibernateTemplate().save(order);

	}
	public void addItem(Items items){
		this.getHibernateTemplate().save(items);
	}
	public ShopOrder getOrderById(int id) {
		return (ShopOrder)this.getHibernateTemplate().get(ShopOrder.class, id);
	}
	public void addStore(Store store, int shopId) {
		String hql = "select s from Store s where s.shop.id = ? and s.code = ?";
		Store s = (Store)this.getSession().createQuery(hql).setParameter(0, shopId).setParameter(1, store.getCode()).uniqueResult();
		if(s != null){
			int a = s.getAccount()+store.getAccount();
			s.setAccount(a);
			this.getHibernateTemplate().update(s);
			return;
		}
		this.getHibernateTemplate().save(store);
	}
	public PagerModel searchOrders(ShopOrder order,String oid,String supId,String shopId,String strState,String start,String end) {
		String where = "";
		if(oid!=null && oid != ""){
			where = where+" and o.id = "+Integer.parseInt(oid);
		}
		if(supId!=null && supId != ""){
			where = where+" and o.supplier.id = "+Integer.parseInt(supId);
		}
		if(shopId!=null && shopId != ""){
			where = where+" and o.shop.id = "+Integer.parseInt(shopId);
		}
		if(order.getType()!=0){
			where = where+" and o.type = "+order.getType();
		}
		if(strState!=null && strState != ""){
			where = where+" and o.state = "+Integer.parseInt(strState);
		}
		if(start!=null && start!=""){
			where = where+" and o.repDate >= '"+start+"'";
		}
		if(end!=null && end!=""){
			where = where+" and o.repDate <= '"+end+"'";
		}
		String hql = "select o from ShopOrder o where 1=1 "+where+" order by o.id desc";
		return this.searchPaginated(hql);
	}
	public PagerModel searchSupCaiOrders(ShopOrder order,String oid,String supId,String shopId,String strState,String start,String end){
		String where = "";
		if(oid!=null && oid != ""){
			where = where+" and o.id = "+Integer.parseInt(oid);
		}
		if(supId!=null && supId != ""){
			where = where+" and o.supplier.id = "+Integer.parseInt(supId);
		}
		if(shopId!=null && shopId != ""){
			where = where+" and o.shop.id = "+Integer.parseInt(shopId);
		}
		if(order.getType()!=0){
			where = where+" and o.type = "+order.getType();
		}
		if(strState!=null && strState != ""){
			where = where+" and o.state = "+Integer.parseInt(strState);
		}else{
			where = where+" and o.state != 0";
		}
		if(start!=null && start!=""){
			where = where+" and o.repDate >= '"+start+"'";
		}
		if(end!=null && end!=""){
			where = where+" and o.repDate <= '"+end+"'";
		}
		String hql = "select o from ShopOrder o where 1=1 "+where+" order by o.id desc";
		System.out.println("#############"+hql);
		return this.searchPaginated(hql);
	}
	public void updateOrder(int state,int id) {
		String hql="update ShopOrder o set o.state = "+state+" where o.id = "+id;
		this.getSession().createQuery(hql).executeUpdate();
	}
	public List searchLines(int oid){
		String hql = "select i from Items i where i.order.id = "+oid;
		return this.getSession().createQuery(hql).list();
	}
}