\SalContractList

<?php
/*
 *
 * crm.ContractList  客户销售合同管理   
 *
 * =========================================================
 * 零起飞网络 - 专注于网站建设服务和行业系统开发
 * 以质量求生存，以服务谋发展，以信誉创品牌 !
 * ----------------------------------------------
 * @copyright	Copyright (C) 2017-2018 07FLY Network Technology Co,LTD (www.07FLY.com) All rights reserved.
 * @license    For licensing, see LICENSE.html or http://www.07fly.xyz/crm/license
 * @author ：kfrs <goodkfrs@QQ.com> 574249366
 * @version ：1.0
 * @link ：http://www.07fly.xyz
 */	
class SalContractList extends Action{	
	private $cacheDir='';//缓存目录
	public function __construct() {
		_instance('Action/sysmanage/Auth');
		$this->contract=_instance('Action/crm/SalContract');
		$this->store=_instance('Action/erp/StockStore');
	}	
	
	public function sal_contract_list(){
		$contract_id= $this->_REQUEST("contract_id");
		$totalSql	= "select sum(num) as total_num,sum(goods_money) as total_goods_money 
						from sal_contract_list where contract_id='$contract_id'";	
		$totalOne	= $this->C($this->cacheDir)->findOne($totalSql);
		
		$sql	= "select * from sal_contract_list where contract_id='$contract_id'";	
		$list	= $this->C($this->cacheDir)->findAll($sql);
		return array('list'=>$list,'totalCount'=>$totalOne);
	}

	public function sal_contract_list_json(){
		$assArr = $this->sal_contract_list();
		echo json_encode($assArr);
	}
	
	public function sal_contract_list_detail(){
		$contract_id= $this->_REQUEST("contract_id");
		$smarty = $this->setSmarty();
		$smarty->assign(array('contract_id'=>$contract_id));
		$smarty->display('crm/sal_contract_list_detail.html');			
		
	}

	public function sal_contract_list_add(){
		$contract_id= $this->_REQUEST("contract_id");
		if(empty($_POST)){
			$list['contract']=$this->contract->sal_contract_get_one($contract_id);
			$smarty = $this->setSmarty();
			$smarty->assign($list);
			$smarty->display('crm/sal_contract_list_add.html');	
		}else{
			$sku_id		= $this->_REQUEST("sku_id");
			$sku_name	= $this->_REQUEST("sku_name");
			$goods_id	= $this->_REQUEST("goods_id");
			$goods_name	= $this->_REQUEST("goods_name");
			$sale_price	= $this->_REQUEST("sale_price");
			$num		= $this->_REQUEST("num");
			$goods_money= $this->_REQUEST("goods_money");
			$remarks	= $this->_REQUEST("remarks");
			$total_goods_money=array_sum($goods_money);
			
			$contract_money= $this->_REQUEST("contract_money");
			if($contract_money<$total_goods_money){
				$this->L("Common")->ajax_json_error("明细商品总金额不能超过合同金额");
				return false;
			}
			
			//删除数据
			$this->C($this->cacheDir)->delete('sal_contract_list',"contract_id='$contract_id'");
			
			foreach($sku_id as $i=>$sku_one_id){
				$into_data=array(
					'contract_id'=>$contract_id,
					'sku_id'=>$sku_id[$i],
					'sku_name'=>$sku_name[$i],
					'goods_id'=>$goods_id[$i],
					'goods_name'=>$goods_name[$i],
					'sale_price'=>$sale_price[$i],
					'num'=>$num[$i],
					'owe_num'=>$num[$i],
					'goods_money'=>$goods_money[$i],
					'owe_money'=>$goods_money[$i],
					'remarks'=>$remarks[$i],
					'create_time'=>NOWTIME,
					'create_user_id'=>SYS_USER_ID,
				);	
				$this->C($this->cacheDir)->insert('sal_contract_list',$into_data);
			}
			//修改状态为录入明细
			$this->C($this->cacheDir)->modify('sal_contract',array('deliver_status'=>'2'),"contract_id='$contract_id'");
			//更新合同执行状态
			$this->contract->sal_contract_modify_status($contract_id);	
			$this->L("Common")->ajax_json_success("操作成功");
		}
		
		
		
	}	
	//删除
	public function sal_contract_list_del($contract_id=null){
		$contract_id=($contract_id)?$contract_id:$this->_REQUEST('contract_id');
		$this->C($this->cacheDir)->delete('sal_contract_list',"contract_id in ($contract_id)");
		$this->C($this->cacheDir)->modify('sal_contract',array('deliver_status'=>'1'),"contract_id='$contract_id'");
		//更新合同执行状态
		$this->contract->sal_contract_modify_status($contract_id);		
		$this->L("Common")->ajax_json_success("操作成功");
	}
	
	//销售订单明生成出库单，接口
	public function sal_contract_list_stock_out(){
		$contract_id= $this->_REQUEST("contract_id");
		$list['contract']=$this->contract->sal_contract_get_one($contract_id);
		$list['store']=$this->store->stock_store_select();
		$smarty = $this->setSmarty();
		$smarty->assign($list);
		$smarty->display('crm/sal_contract_list_stock_out.html');
	}
	//出库数据回显示
	public function sal_contract_list_stock_out_json(){
		$contract_id= $this->_REQUEST("contract_id");
		$totalSql= "select sum(goods_money) as total_goods_money,sum(num) as total_num,
					sum(owe_money) as total_owe_money,sum(owe_num) as total_owe_num
				   from sal_contract_list  where contract_id='$contract_id'";	
		$totalRs = $this->C($this->cacheDir)->findOne($totalSql);
		
		$sql	= "select * from sal_contract_list where contract_id='$contract_id'";	
		$list	= $this->C($this->cacheDir)->findAll($sql);
		$rtnArr = array('list'=>$list,'totalCount'=>$totalRs);
		echo json_encode($rtnArr);
	}	
	//确认出库时更改订单
	public function sal_contract_list_stock_out_sure($contract_list_id,$number,$money){
		$contract_list_sql="select * from sal_contract_list where list_id='$contract_list_id'";
		$contract_list_one=$this->C($this->cacheDir)->findOne($contract_list_sql);

		$new_out_num	=$contract_list_one['out_num']+$number;
		$new_owe_num 	=$contract_list_one['owe_num']-$number;
		$new_owe_money 	=$contract_list_one['owe_money']-$money;
		$out_data=array(
			'out_num'=>$new_out_num,
			'owe_num'=>$new_owe_num,
			'owe_money'=>$new_owe_money,
		);
		$this->C($this->cacheDir)->modify('sal_contract_list',$out_data,"list_id='$contract_list_id'");
	}	
	//删除入库时更改订单
	public function sal_contract_list_stock_out_del($contract_list_id,$number,$money){
		$contract_list_sql="select * from sal_contract_list where list_id='$contract_list_id'";
		$contract_list_one=$this->C($this->cacheDir)->findOne($contract_list_sql);

		$new_out_num	=$contract_list_one['out_num']-$number;
		$new_owe_num 	=$contract_list_one['owe_num']+$number;
		$new_owe_money 	=$contract_list_one['owe_money']+$money;
		$out_data=array(
			'out_num'=>$new_out_num,
			'owe_num'=>$new_owe_num,
			'owe_money'=>$new_owe_money,
		);
		$this->C($this->cacheDir)->modify('sal_contract_list',$out_data,"list_id='$contract_list_id'");
	}	
}
?>