package com.product.mobile.core.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import com.product.common.lang.StringUtils;
import com.product.core.dao.BaseDao;
import com.product.core.entity.DataTableEntity;
import com.product.core.entity.FieldSetEntity;
import com.product.core.exception.BaseException;
import com.product.core.service.support.AbstractBaseService;
import com.product.util.BaseUtil;

/**
 * 手机端，获取用户所有应用
 * @author Administrator
 *
 */
@Component
public class SystemTableMetaService extends AbstractBaseService{
    @Autowired
    public BaseDao baseDao;
    /**
     * 	数据表结构信息
     * @param cpage
     * @param pagesize
     * @return
     * @throws BaseException
     */
    public FieldSetEntity getSystemTableMeta(FieldSetEntity fse) throws BaseException{
   
    	Map<Object,Object> vs=fse.getValues();
		StringBuilder b=new StringBuilder();
		b.append("select t.table_name,f.field_name,f.field_length,f.field_show_name,f.field_type,f.field_reference,f.is_required from product_sys_datamodel_field f left join product_sys_datamodel_table t on f.table_uuid=t.uuid");
		List<Object> ps=new ArrayList<>();
    	if(vs!=null && vs.size()>0) {
    		b.append(" where ");
    		Iterator keys=vs.keySet().iterator();
    		int c=0;
    		while(keys.hasNext()) {
    			Object key=keys.next();
    			Object field=vs.get(key);
//    			if(StringUtils.isEmpty(field)) {
//    				continue;
//    			}
    			if(c>0) {
    				b.append(" or ");
    			}
    			Object fp[]=BaseUtil.buildQuestionMarkFilter("f.field_name","in",field.toString());
    			b.append("(t.table_name=? ");
    			ps.add(key);
    			if(fp!=null && fp.length>1) {
    				b.append(" and ");
    				b.append(fp[0]);
    				ps.addAll((List)fp[1]);
    			}
    			b.append(")");
    			c++;
    		}
    		b.append(" order by  t.table_name ");
    		FieldSetEntity fs=new FieldSetEntity("product_sys_datamodel_field");
    		DataTableEntity dt=baseDao.listTable(b.toString(), ps.toArray());
    		String table=null;
    		DataTableEntity sub=new DataTableEntity();
    		for(int i=0;i<dt.getRows();i++) {
    			String tb=dt.getString(i, "table_name");
    			if(table!=null && !table.equals(tb)) {
    				sub.getMeta().getTableName()[0]=table;
    				fs.addSubDataTable(sub);
    				sub=new DataTableEntity();
    			}
    			table=tb;
    			sub.addFieldSetEntity(dt.getFieldSetEntity(i));
    		}
    		sub.getMeta().getTableName()[0]=table;
    		fs.addSubDataTable(sub);
    		return fs;
    	}
        return null;
    }
}