<?
  ob_start();
  session_start();
  
  include("include.php");
  
  header("Cache-control: private");
  $work=$_GET["work"];
 
  
  //有無登入       
  
   //有無登入
 if(empty($_SESSION["sename"])){
	 $tpl->display("login.html");	
		
 }else{
   	$tpl->display("index.htm"); 
       
              
   if($work=="" || $work=="cus"){
    $check= new sqlbasic();
    $check -> sql="SELECT COUNT(`cnumber`) FROM `customer`";
    $check->returntype="s"; //回傳數量  s=select
    $re=$check ->sqlcarry();
    $count=$re[0][0];    
    
    $p=$_GET["p"];
	
    if($p>0){
		$p=$p*200;
    }else{
  	    $p=0;
    }
	page($p,$count,$insertdbase,200);
    
     
    
    if(empty($_GET["type"])){
		$type="all";
	}else{
		$type=$_GET["type"];	
		if(empty($_POST["search"])){
			$search=$_GET["search"]; 	
		}else{
			$search=$_POST["search"];  
		}
	}
 	
  	if($type=="Sales"){//業務
  	   	$check -> sql="SELECT `cnumber`,`buss`,`cname`,`cname2`,`cphone1`,`fax`,`ps`,`Sales`
  	          FROM `customer` WHERE  `".$type."` LIKE '".$search."'  ORDER BY `cnumber` ASC  ";  
  	}elseif($type=="cnumber"){//編號
  	   	$check -> sql="SELECT `cnumber`,`buss`,`cname`,`cname2`,`cphone1`,`fax`,`ps`,`Sales`
  	          FROM `customer` WHERE  `".$type."` LIKE '".$search."'  ORDER BY `cnumber` ASC  ";  		
  	}elseif($type=="cname"){//連絡人
  	   	$check -> sql="SELECT `cnumber`,`buss`,`cname`,`cname2`,`cphone1`,`fax`,`ps`,`Sales`
  	          FROM `customer` WHERE  `".$type."` LIKE '%".$search."%' OR `cname2` LIKE '%".$search."%' OR `cname3` LIKE '%".$search."%' ORDER BY `cnumber` ASC  ";  		
  	}elseif($type=="phone"){//連絡電話或傳真
  		$check -> sql="SELECT `cnumber`,`buss`,`cname`,`cname2`,`cphone1`,`fax`,`ps`,`Sales`
  	          FROM `customer` WHERE  `cphone1` LIKE '%".$search."%' OR `cphone2` LIKE '%".$search."%' OR `cphone3` LIKE '%".$search."%' OR `cphone4` LIKE '%".$search."%' OR `cphone5` LIKE '%".$search."%' OR `cphone6` LIKE '%".$search."%' OR `cphone7` LIKE '%".$search."%' OR `cphone8` LIKE '%".$search."%' OR `cphone9` LIKE '%".$search."%'
  	          OR `fax` LIKE '%".$search."%' OR `fax2` LIKE '%".$search."%' OR `fax3` LIKE '%".$search."%' ORDER BY `cnumber` ASC  "; 
  	}elseif($type=="buss"){//公司
  	    $check -> sql="SELECT `cnumber`,`buss`,`cname`,`cname2`,`cphone1`,`fax`,`ps`,`Sales`
  	          FROM `customer` WHERE  `".$type."` LIKE '%".$search."%' ORDER BY `cnumber` ASC  ";
    }elseif($type=="caddress"){//地址或Mail
  	   	$check -> sql="SELECT `cnumber`,`buss`,`cname`,`cname2`,`cphone1`,`fax`,`ps`,`Sales`
  	          FROM `customer` WHERE `caddress` LIKE '%".$search."%' OR `caddress2` LIKE '%".$search."%' OR `caddress3` LIKE '%".$search."%' OR `email` LIKE '%".$search."%' OR `email2` LIKE '%".$search."%' OR `email3` LIKE '%".$search."%' ORDER BY `cnumber` ASC  ";  		
  	}elseif($type=="all"){//所有
  	    $check -> sql="SELECT `cnumber`,`buss`,`cname`,`cname2`,`cphone1`,`fax`,`ps`,`Sales`
  	          FROM `customer` ORDER BY `cnumber` ASC LIMIT $p,200 ";
  	}

    $check->returntype="s"; //回傳數量  s=select
    $cus=$check ->sqlcarry();
  
  //業務
  
   $check->sql="SELECT `Salesnum`,`Salesname` FROM `sales`";
   $array5=$check ->sqlcarry();
  
   $tpl->assign("array1",$cus);
   $tpl->assign("array3",$array3);
   $tpl->assign("array4",$array4);
   $tpl->assign("array5",$array5);
   $tpl->assign("search",$search);
   $tpl->assign("p",$_GET["p"]);
	 
  	$tpl->assign("total",$count);
    $tpl->display("cus.htm"); 
       
  
  }elseif($work=="file"){
    $check= new sqlbasic();
    $id=$_GET["id"];
  	$check->sql="SELECT `cnumber`,`buss`,`cname`,`cname2`,`cname3`,`Line1`,`Line2`,`Line3`,`cphone1`,`cphone2`,`cphone3`,`cphone4`,`cphone5`,`cphone6`,`cphone7`,`cphone8`,`cphone9`,`fax`,`fax2`,`fax3`,`email`,`email2`,`email3`,`con`,`caddress`,`caddress2`,`caddress3`,
  	      `ps`,`Sales` FROM `customer` WHERE `cnumber`='".$id."'";
    $check->returntype="s"; //回傳數量  s=select
    $cus=$check ->sqlcarry();          
  	
	
	
	$check->sql="SELECT `Salesnum`,`Salesname` FROM `sales`";
  	$sales=$check ->sqlcarry();
  
  
  	$tpl->assign("cus",$cus);
  	$tpl->assign("sales",$sales);
	$tpl->assign("p",$_GET["p"]);
    $tpl->display("file.htm");
  
  }elseif($work=="newcus"){
    $check= new sqlbasic();
  
    $check->sql="SELECT `Salesnum`,`Salesname` FROM `sales`";
    $check->returntype="s"; //回傳數量  s=select
  	$sales=$check ->sqlcarry();     
  	$tpl->assign("sales",$sales);
  	
    $tpl->display("newcus.htm");
  }
 
 
 }
     
  
 
?>