<?php
//-------------------------------------------------------导入历史数据
date_default_timezone_set('Asia/Shanghai');
header("Content-type: text/html; charset=utf-8");
error_reporting(E_ERROR | E_WARNING | E_PARSE);
require "../config.php";
include "../../tmpl/config.php";
require THIS_FILE_ROOT."/include/function.php";
require THIS_FILE_ROOT."/include/db_mysql.php";
$page=@$_GET["page"];
$lx=@$_GET["lx"];
$limit=@$_GET["limit"];
$tbid=@$_GET["tbid"];
$json_data="";
$page=$page>0?$page:1;	
$limit=$limit>0?$limit:10;
$start=($page-1)*$limit;
$end=$limit;
//$arr_column_keyword=array("uid"=>"客户代码","c1"=>"波段名称","c2"=>"大类名称","je"=>"金额","js"=>"件数","ks"=>"款数");
//-------------------------------定义字段
//-------------------------------定义数据表
$wjname="plugin_report_zdy_3w";
$json_data="";

//$sql_create_table="CREATE TABLE ".$tname." (
//`id` int(10) unsigned NOT NULL auto_increment,
//`uid` int(10) unsigned NOT NULL default '0',
//`upath` varchar(255) NOT NULL default '',
//`c1` varchar(255) NOT NULL default '',
//`c2` varchar(255) NOT NULL default '',
//`je` int(10) unsigned NOT NULL default '0',
//`js` int(10) unsigned NOT NULL default '0',
//`ks` int(10) unsigned NOT NULL default '0',
//PRIMARY KEY  (`id`)
//) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
//-------------------------------mysql connect
$msg=""; 
$db=new DB_Sql;
$db->connect($dbhost,$dbuser,$dbpw,$dbname,"p");
$is_submit=$_POST["is_submit"];
$is_qk=$_POST["is_qk"];

$tmp=get_db_msg("select * from ".$table_pre."plugin where id='".$tbid."'");
$tmpa=explode(",",$tmp["param"]);
$tmpb=explode("|",$tmpa[0]);
$tname=$table_pre."plugin_zdy_".$tmpb[1];
$arr_zd=array("keyword_zd1"=>"zd1","keyword_zd2"=>"zd2","keyword_zd3"=>"zd3");
$arr_dr_zd=array("dr_zd1"=>"dr_zd1","dr_zd2"=>"dr_zd2","dr_zd3"=>"dr_zd3","dr_zd4"=>"dr_zd4","dr_zd5"=>"dr_zd5","dr_zd6"=>"dr_zd6","dr_zd7"=>"dr_zd7","dr_zd8"=>"dr_zd8");
$arr_column_keyword=array();
$arr_column_keyword["uid"]="客户代码";
foreach($tmpa as $k => $v){
	$tmparr=explode("|",$v);
	if(array_key_exists($tmparr[0],$arr_zd)){
		if($tmparr[1]){
			$arr_column_keyword[$arr_zd[$tmparr[0]]]=get_cate_title_no("arr_select",$tmparr[1]);
		}
	}
	if(array_key_exists($tmparr[0],$arr_dr_zd)){
		if($tmparr[1]){
			$tmpzd=explode("_",$tmparr[1]);
			$arr_column_keyword[$arr_dr_zd[$tmparr[0]]]=$tmpzd[0];
		}
	}
}
//print_r($arr_column_keyword);
//exit;
//-------------------------------导入数据
//建立数据表
//if(check_table_exist($tname)!="y")
	//$db->query($sql_create_table);
if($is_submit=="y"){
	//
	$file1=$_FILES["file1"];
	if($file1["name"]){
		if(!check_file_type("xls|xlsx",get_file_ext($file1["name"])))
			alert_and_back("请选择EXCEL文档(.xls)!");
	}else{
		alert_and_back("请选择EXCEL文档(.xls)!");
	}
	$tmp_file_name=save_tmp_file($file1);
	$tmp_content=get_tmp_content($tmp_file_name);
	$arr_content=explode("\n",$tmp_content);
	$arr_thead=get_table_thead($tmp_content);
	$arr_column=check_table_thead($arr_thead,$arr_column_keyword);
	if(count($arr_column[0])==0){
		alert_and_back("未检测到可导入字段，请返回检查EXCEL文件!");
		//del_tmp_file($tmp_file_name);
	}
	//检查客户代码
	$arr_wrong_username=array();
	for($i=1;$i<count($arr_content);$i++){
		$tmp_arr=explode("|^_^|",$arr_content[$i]);
		$insert_value="";
		for($k=0;$k<count($arr_column[0]);$k++){
			$ind=$arr_column[0][$k];
			$ititle=$arr_column[1][$k];
			if($ititle=="uid"){
				$m1=get_db_msg("select id from ".$table_pre."client where username='".trim($tmp_arr[$ind])."'");
				if($m1["id"]>0){
					//客户存在
				}else{
					if(!in_array($tmp_arr[$ind],$arr_wrong_username))
						$arr_wrong_username[]=$tmp_arr[$ind];
				}
			}
		}
	}
	if(count($arr_wrong_username)>0)
		alert_and_back("以下客户代码有误，请检查：".arr_to_str($arr_wrong_username)."!");
	//导入数据
	if($is_qk=="y"){
		//初始化
		$db->query("truncate table ".$tname.";");
	}
	foreach($arr_column[1] as $k1 => $v1){
		if($v1=="uid")
			$insert_column.=$v1.",upath,";
		else
			$insert_column.=$v1.",";
	}
	for($i=1;$i<count($arr_content);$i++){
		$tmp_arr=explode("|^_^|",$arr_content[$i]);
		$insert_value="";
		for($k=0;$k<count($arr_column[0]);$k++){
			$ind=$arr_column[0][$k];
			$ititle=$arr_column[1][$k];
			if($ititle=="uid"){
				$m1=get_db_msg("select id,path from ".$table_pre."client where username='".trim($tmp_arr[$ind])."'");
				$insert_value.="'".$m1["id"]."','".$m1["path"]."-".$m1["id"]."',";
			}else{
				$insert_value.="'".mysql_escape_string(trim($tmp_arr[$ind]))."',";
			}
		}
		$q="insert into ".$tname." (".substr($insert_column,0,-1).") values (".substr($insert_value,0,-1).")";
		//echo $i.".".$q."<br>";
		$db->query($q);
	}
	//del_tmp_file($tmp_file_name);
}

$json1='{type: "checkbox", fixed:"left", width:50},';
foreach($arr_column_keyword as $key=>$value){
        $json1.="{field: '".$key."', title: '".$value."', width:150},";
}
$json1.="{field:'action', title:'操作',templet: '#action_mx'}";
$json1="[[".$json1."]]";
$content="";

switch($lx){
	case "1":
			//取得总数
			$tmp=get_db_msg("select count(*) 'num' from ".$tname." where id>0 ".$sql_con);
			$total_num=$tmp["num"];
			$query="select * from ".$tname." where id>0 ".$sql_con." order by id limit ".$start.",".$end;
			$count=0;
			$res=$db->query($query);	
			$str_tmp="";
			$json_data.="{\"code\":0,\"msg\":\"\",\"count\":".$total_num.",\"data\":[";
			while($msg=$db->fetch_array($res)){
				$list=$count_first+$count+1;
				$kehu_name=get_db_msg("select username from ".$table_pre."client where id='".$msg["uid"]."'");
				$str_tmp.="{";
				$str_tmp.="\"id\":\"".$msg["id"]."\",";
				$str_tmp.="\"uid\":\"".$kehu_name["username"]."\",";
				$str_tmp.="\"bh\":\"".$list."\",";
				foreach($arr_column_keyword as $key=>$value){
					if($key!="uid"){
							$str_tmp.="\"".$key."\":\"".$msg[$key]."\",";
					}
				}
				//$str_tmp.="\"action\":\"".$msg["action"]."\",";
				$str_tmp.="\"ks\":\"".$msg["ks"]."\"";
				$str_tmp.="},";
				$count++;
			}
			$json_data.=substr($str_tmp,0,-1)."]}";
			echo $json_data;
	break;
	case "save_add":
		$neirong="";
		$id=@$_GET["id"];
		foreach($arr_column_keyword as $key=>$value){
			if($key!="uid"){
					$v="s_".$key."";
					$neirong =$_POST[$v];
					$sql_con.="".$key."='".$neirong."',";
			}
		}
		$sql_con=substr($sql_con,0,-1);
		$query="update ".$tname." set ".$sql_con." where id='".$id."'";
		$db->query($query);
		alert_and_back("保存成功");
	break;
	case "del":
			$id=@$_GET["id"];
			$id=(is_array($id))?$id:array($id);
			$num=count($id);
			for($i=0;$i<$num;$i++){
				$db->query("delete from ".$tname." where id='".$id[$i]."'");
			}
			$json_data.="{\"code\":1}";
			echo $json_data;
	break;
	case "edit":
		$id=@$_GET["id"];
		$content='<!DOCTYPE html><html><head><meta charset="utf-8"><meta name="renderer" content="webkit"><meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"><title>导入excel-e订通后台</title><link rel="stylesheet" href="../layuiadmin/layui/css/layui.css"><link rel="stylesheet" href="index.css"><script src="../layuiadmin/layui/layui.js"></script><script src="../js/function.js"></script><style>#table1{border:0px;}</style></head><body>';
		$content.='<form class="layui-form" action="'.$wjname.'.php?lx=save_add&id='.$id.'" method="post"><br><br><table class="layui-table" id="table1" style="width:90%;margin:0 auto;">';
		$xinxi=get_db_msg("select * from ".$tname." where id='".$id."'");
		foreach($arr_column_keyword as $key=>$value){
			if($key!="uid")
			$content.="<tr><td>".$value."</td><td><input type='text' class='layui-input' value='".$xinxi[$key]."' name='s_".$key."'></td></tr>";
			else{
				$check=get_db_msg("select username from web_client where id='".$xinxi[$key]."'");
			$content.="<tr style='background:#ccc;'><td>".$value."</td><td>".$check["username"]."</tr>";
			}
		}
		$content.='</table><div style="padding-left:300px;"><button id="form1_submit" class="layui-btn layui-btn-normal btn1" lay-submit lay-filter="form1_submit">保存</button></form></div></body></html>';
		$js="<script> 
		var this1=".$json1.";
		layui.use(['form','layer','laydate','table','laytpl','element',],function(){
			var form = layui.form,
        layer = parent.layer === undefined ? layui.layer : top.layer,
        $=layui.jquery,
        laydate = layui.laydate,
        laytpl = layui.laytpl,
        table = layui.table;
		 form.on('submit(form1_submit)',function(data){		
		 });
		
		});
		</script>";
		echo $js;
		echo $content;
	break;
	default:
		//-------------------------------取得数据
		$content='<!DOCTYPE html><html><head><meta charset="utf-8"><meta name="renderer" content="webkit"><meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"><title>导入excel-e订通后台</title><link rel="stylesheet" href="../layuiadmin/layui/css/layui.css"><link rel="stylesheet" href="index.css"><script src="../layuiadmin/layui/layui.js"></script><script src="../js/function.js"></script><style>#table1{border:0px;}</style></head><body>';
		$content.='<form class="layui-form" method="post"  enctype="multipart/form-data"><input type="hidden" name="is_submit" value="y"><div style="padding:20px;background:#ccc;" >导入自定义数据</div><table class="layui-table" id="table1" style="width:100%;"><tr><td width="300px">导入模板：</td><td><a href="'.$wjname.'_mb.xls"><img src="../images/excel.png" width="30" height="33"></a><a href="'.$wjname.'_mb.xls">debug/'.$wjname.'_mb.xls</a></td></tr><tr><td>请选择excel数据文档：</td><td><input type=file name="file1" style="width:250px"> <input type="checkbox" name="is_qk" id="is_qk" value="y"  lay-skin="primary" checked><label for="is_qk">清空导入<input type="submit" value="提交" class="layui-btn layui-btn-sm layui-btn-normal">(请根据实际表格情况删除excel中的多余栏，以及根据下面表格的字段名去命名excel第一行的标题名)</label>'.$content_sj.'</td></tr></table><a class="layui-btn layui-btn-danger btn_del">删除</a><table id="table2" lay-filter="layui_table"></table></form><script type="text/html" id="action_mx"><a lay-event="edit" style="color:blue;">修改</a></script><p id="aa"></p></body></html>';
		echo $content;
	$js="<script> 
		var this1=".$json1.";
		layui.use(['form','layer','laydate','table','laytpl','element',],function(){
			var form = layui.form,
        layer = parent.layer === undefined ? layui.layer : top.layer,
        $=layui.jquery,
        laydate = layui.laydate,
        laytpl = layui.laytpl,
        table = layui.table;
		//数据表格
		var url='".$wjname.".php?lx=1&tbid=".$tbid."';
		 var tableIns = table.render({
		even:false,
        elem: '#table2',
        url : url,
        cellMinWidth : 80,
        page : true,
        height : 'full-100',
        limit : 10,
        limits : [10,20,30,50,100],
        id : 'ListTable',
        cols :this1,
		done: function(res, curr, count){
			
		}
    });
    function add(id){
		var t1=(id>0)?'':'';
        var index = layui.layer.open({
            title : t1+'修改历史数据',
            type : 2,
			area: ['700px', '500px'],
            content : '".$wjname.".php?lx=edit&tbid=".$tbid."&id='+id,
            success : function(layero, index){
            }
			,cancel: function(index, layero){ 
				window.parent.location.reload();
			}
        })
    }
    //批量删除
    $('.btn_del').click(function(){
        var checkStatus = table.checkStatus('ListTable'),
            data = checkStatus.data,
            check_id = [];
        if(data.length > 0) {
            for (var i in data) {
                check_id.push(data[i].id);
            }
            layer.confirm('确定删除吗？', {icon: 3, title: '提示信息'}, function (index) {
				$.get('".$wjname.".php?lx=del&tbid=".$tbid."',{id:check_id},function(data){
					tableIns.reload();
					layer.close(index);
				})
			})
        }else{
            layer.msg('请选择需要删除的记录');
        }
    })

    //列表操作
    table.on('tool(layui_table)', function(obj){
        var layEvent = obj.event,
            data = obj.data;
        if(layEvent === 'edit'){ 
			//编辑
            add(data.id);
        } 
    });
});
</script>";
	echo $js;
	break;
}
?>